ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | companyId | stdRefNo | nativeReferenceNumber | courtName | courtCode | referenceNumberFirstSeen | validTill |
---|---|---|---|---|---|---|---|---|
2440022 | 2440022 | Y1206_HRB514673 | Y1206_HRB514673 | Jena HRB 514673 | Jena | Y1206 | 2018-06-20 | |
2440021 | 2440021 | Y1206_HRB514642 | Y1206_HRB514642 | Jena HRB 514642 | Jena | Y1206 | 2018-06-12 | |
2440020 | 2440020 | Y1206_HRB514559 | Y1206_HRB514559 | Jena HRB 514559 | Jena | Y1206 | 2018-05-15 | |
2440019 | 2440019 | Y1206_HRB514546 | Y1206_HRB514546 | Jena HRB 514546 | Jena | Y1206 | 2018-05-09 | |
2440018 | 2440018 | Y1206_HRB514496 | Y1206_HRB514496 | Jena HRB 514496 | Jena | Y1206 | 2018-04-18 | |
2440017 | 2440017 | Y1206_HRB514423 | Y1206_HRB514423 | Jena HRB 514423 | Jena | Y1206 | 2018-03-19 | |
2440016 | 2440016 | Y1206_HRB514410 | Y1206_HRB514410 | Jena HRB 514410 | Jena | Y1206 | 2018-03-15 | |
2440015 | 2440015 | Y1206_HRB514408-B1601_HRB522326 | B1601_HRB522326 | Mannheim HRB 522326 | Mannheim | B1601 | 2018-03-16 | |
2440014 | 2440014 | Y1206_HRB514408-B1601_HRB522326 | Y1206_HRB514408 | Jena HRB 514408 | Jena | Y1206 | 2018-03-14 | 2018-03-16 |
2440013 | 2440013 | Y1206_HRB514374 | Y1206_HRB514374 | Jena HRB 514374 | Jena | Y1206 | 2018-03-02 | |
2440012 | 2440012 | Y1206_HRB514330 | Y1206_HRB514330 | Jena HRB 514330 | Jena | Y1206 | 2018-02-16 | |
2440011 | 2440011 | Y1206_HRB514289 | Y1206_HRB514289 | Jena HRB 514289 | Jena | Y1206 | 2018-02-07 | |
2440010 | 2440010 | Y1206_HRB514228 | Y1206_HRB514228 | Jena HRB 514228 | Jena | Y1206 | 2018-01-24 | |
2440009 | 2440009 | Y1206_HRB514133 | Y1206_HRB514133 | Jena HRB 514133 | Jena | Y1206 | 2017-12-27 | |
2440008 | 2440008 | Y1206_HRB514084 | Y1206_HRB514084 | Jena HRB 514084 | Jena | Y1206 | 2017-12-15 | |
2440007 | 2440007 | Y1206_HRB514075 | Y1206_HRB514075 | Jena HRB 514075 | Jena | Y1206 | 2017-12-13 | |
2440006 | 2440006 | Y1206_HRB513864 | Y1206_HRB513864 | Jena HRB 513864 | Jena | Y1206 | 2017-10-05 | |
2440005 | 2440005 | Y1206_HRB513826 | Y1206_HRB513826 | Jena HRB 513826 | Jena | Y1206 | 2017-09-21 | |
2440004 | 2440004 | Y1206_HRB513818-F1103_HRB244407B | F1103_HRB244407B | Charlottenburg (Berlin) HRB 244407 B | Berlin (Charlottenburg) | F1103 | 2022-07-26 | |
2440003 | 2440003 | Y1206_HRB513818-F1103_HRB244407B | Y1206_HRB513818 | Jena HRB 513818 | Jena | Y1206 | 2017-09-19 | 2022-07-26 |
2440002 | 2440002 | Y1206_HRB513752 | Y1206_HRB513752 | Jena HRB 513752 | Jena | Y1206 | 2017-09-01 | |
2440001 | 2440001 | Y1206_HRB513694 | Y1206_HRB513694 | Jena HRB 513694 | Jena | Y1206 | 2017-08-17 | |
2440000 | 2440000 | Y1206_HRB513692 | Y1206_HRB513692 | Jena HRB 513692 | Jena | Y1206 | 2017-08-17 | |
2439999 | 2439999 | Y1206_HRB513661 | Y1206_HRB513661 | Jena HRB 513661 | Jena | Y1206 | 2017-08-09 | |
2439998 | 2439998 | Y1206_HRB513640 | Y1206_HRB513640 | Jena HRB 513640 | Jena | Y1206 | 2017-08-01 | |
2439997 | 2439997 | Y1206_HRB513610 | Y1206_HRB513610 | Jena HRB 513610 | Jena | Y1206 | 2017-07-18 | |
2439996 | 2439996 | Y1206_HRB513572 | Y1206_HRB513572 | Jena HRB 513572 | Jena | Y1206 | 2017-07-07 | |
2439995 | 2439995 | Y1206_HRB513555 | Y1206_HRB513555 | Jena HRB 513555 | Jena | Y1206 | 2017-06-29 | |
2439994 | 2439994 | Y1206_HRB513546 | Y1206_HRB513546 | Jena HRB 513546 | Jena | Y1206 | 2017-06-27 | |
2439993 | 2439993 | Y1206_HRB513484 | Y1206_HRB513484 | Jena HRB 513484 | Jena | Y1206 | 2017-06-01 | |
2439992 | 2439992 | Y1206_HRB513439 | Y1206_HRB513439 | Jena HRB 513439 | Jena | Y1206 | 2017-05-16 | |
2439991 | 2439991 | Y1206_HRB513420 | Y1206_HRB513420 | Jena HRB 513420 | Jena | Y1206 | 2017-05-10 | |
2439990 | 2439990 | Y1206_HRB513212 | Y1206_HRB513212 | Jena HRB 513212 | Jena | Y1206 | 2017-02-23 | |
2439989 | 2439989 | Y1206_HRB513166 | Y1206_HRB513166 | Jena HRB 513166 | Jena | Y1206 | 2017-02-08 | |
2439988 | 2439988 | Y1206_HRB513020 | Y1206_HRB513020 | Jena HRB 513020 | Jena | Y1206 | 2016-12-28 | |
2439987 | 2439987 | Y1206_HRB513019 | Y1206_HRB513019 | Jena HRB 513019 | Jena | Y1206 | 2016-12-28 | |
2439986 | 2439986 | Y1206_HRB512962 | Y1206_HRB512962 | Jena HRB 512962 | Jena | Y1206 | 2016-12-19 | |
2439985 | 2439985 | Y1206_HRB512888 | Y1206_HRB512888 | Jena HRB 512888 | Jena | Y1206 | 2016-12-06 | |
2439984 | 2439984 | Y1206_HRB512887 | Y1206_HRB512887 | Jena HRB 512887 | Jena | Y1206 | 2016-12-06 | |
2439983 | 2439983 | Y1206_HRB512807 | Y1206_HRB512807 | Jena HRB 512807 | Jena | Y1206 | 2016-11-07 | |
2439982 | 2439982 | Y1206_HRB512690 | Y1206_HRB512690 | Jena HRB 512690 | Jena | Y1206 | 2016-09-21 | |
2439981 | 2439981 | Y1206_HRB512557 | Y1206_HRB512557 | Jena HRB 512557 | Jena | Y1206 | 2016-08-15 | |
2439980 | 2439980 | Y1206_HRB512419 | Y1206_HRB512419 | Jena HRB 512419 | Jena | Y1206 | 2016-06-29 | |
2439979 | 2439979 | Y1206_HRB512370-K1101_HRB152985 | K1101_HRB152985 | Hamburg HRB 152985 | Hamburg | K1101 | 2018-08-20 | |
2439978 | 2439978 | Y1206_HRB512370-K1101_HRB152985 | Y1206_HRB512370 | Jena HRB 512370 | Jena | Y1206 | 2016-06-09 | 2018-08-20 |
2439977 | 2439977 | Y1206_HRB512340 | Y1206_HRB512340 | Jena HRB 512340 | Jena | Y1206 | 2016-05-31 | |
2439976 | 2439976 | Y1206_HRB512312 | Y1206_HRB512312 | Jena HRB 512312 | Jena | Y1206 | 2016-05-23 | |
2439975 | 2439975 | Y1206_HRB512246 | Y1206_HRB512246 | Jena HRB 512246 | Jena | Y1206 | 2016-04-27 | |
2439974 | 2439974 | Y1206_HRB512192 | Y1206_HRB512192 | Jena HRB 512192 | Jena | Y1206 | 2016-04-08 | |
2439973 | 2439973 | Y1206_HRB512099 | Y1206_HRB512099 | Jena HRB 512099 | Jena | Y1206 | 2016-03-08 | |
2439972 | 2439972 | Y1206_HRB511968 | Y1206_HRB511968 | Jena HRB 511968 | Jena | Y1206 | 2016-01-28 | |
2439971 | 2439971 | Y1206_HRB511912 | Y1206_HRB511912 | Jena HRB 511912 | Jena | Y1206 | 2016-01-14 | |
2439970 | 2439970 | Y1206_HRB511890 | Y1206_HRB511890 | Jena HRB 511890 | Jena | Y1206 | 2016-01-08 | |
2439969 | 2439969 | Y1206_HRB511834 | Y1206_HRB511834 | Jena HRB 511834 | Jena | Y1206 | 2015-12-18 | |
2439968 | 2439968 | Y1206_HRB511681 | Y1206_HRB511681 | Jena HRB 511681 | Jena | Y1206 | 2015-10-30 | |
2439967 | 2439967 | Y1206_HRB511660 | Y1206_HRB511660 | Jena HRB 511660 | Jena | Y1206 | 2015-10-23 | |
2439966 | 2439966 | Y1206_HRB511564-U1206_HRB31471 | U1206_HRB31471 | Chemnitz HRB 31471 | Chemnitz | U1206 | 2018-01-05 | |
2439965 | 2439965 | Y1206_HRB511564-U1206_HRB31471 | Y1206_HRB511564 | Jena HRB 511564 | Jena | Y1206 | 2015-09-17 | 2018-01-05 |
2439964 | 2439964 | Y1206_HRB511491 | Y1206_HRB511491 | Jena HRB 511491 | Jena | Y1206 | 2015-08-26 | |
2439963 | 2439963 | Y1206_HRB511461 | Y1206_HRB511461 | Jena HRB 511461 | Jena | Y1206 | 2015-08-17 | |
2439962 | 2439962 | Y1206_HRB511421 | Y1206_HRB511421 | Jena HRB 511421 | Jena | Y1206 | 2015-07-31 | |
2439961 | 2439961 | Y1206_HRB511313 | Y1206_HRB511313 | Jena HRB 511313 | Jena | Y1206 | 2015-06-18 | |
2439960 | 2439960 | Y1206_HRB511307 | Y1206_HRB511307 | Jena HRB 511307 | Jena | Y1206 | 2015-06-16 | |
2439959 | 2439959 | Y1206_HRB511302 | Y1206_HRB511302 | Jena HRB 511302 | Jena | Y1206 | 2015-06-15 | |
2439958 | 2439958 | Y1206_HRB511297 | Y1206_HRB511297 | Jena HRB 511297 | Jena | Y1206 | 2015-06-11 | |
2439957 | 2439957 | Y1206_HRB511198 | Y1206_HRB511198 | Jena HRB 511198 | Jena | Y1206 | 2015-05-06 | |
2439956 | 2439956 | Y1206_HRB511165 | Y1206_HRB511165 | Jena HRB 511165 | Jena | Y1206 | 2015-04-28 | |
2439955 | 2439955 | Y1206_HRB511154-D3101_HRB6184 | D3101_HRB6184 | Amberg HRB 6184 | Amberg | D3101 | 2017-12-11 | |
2439954 | 2439954 | Y1206_HRB511154-D3101_HRB6184 | Y1206_HRB511154 | Jena HRB 511154 | Jena | Y1206 | 2015-04-27 | 2017-12-11 |
2439953 | 2439953 | Y1206_HRB511117 | Y1206_HRB511117 | Jena HRB 511117 | Jena | Y1206 | 2015-04-09 | |
2439952 | 2439952 | Y1206_HRB511109 | Y1206_HRB511109 | Jena HRB 511109 | Jena | Y1206 | 2015-04-07 | |
2439951 | 2439951 | Y1206_HRB510921-M1203_HRB9473 | M1203_HRB9473 | Königstein HRB 9473 | Königstein | M1203 | 2016-11-03 | |
2439950 | 2439950 | Y1206_HRB510921-M1203_HRB9473 | Y1206_HRB510921 | Jena HRB 510921 | Jena | Y1206 | 2015-01-26 | 2016-11-03 |
2439949 | 2439949 | Y1206_HRB510896-W1215_HRB26657 | W1215_HRB26657 | Stendal HRB 26657 | Stendal | W1215 | 2019-02-08 | |
2439948 | 2439948 | Y1206_HRB510896-W1215_HRB26657 | Y1206_HRB510896 | Jena HRB 510896 | Jena | Y1206 | 2015-01-16 | 2019-02-08 |
2439947 | 2439947 | Y1206_HRB510696 | Y1206_HRB510696 | Jena HRB 510696 | Jena | Y1206 | 2014-11-07 | |
2439946 | 2439946 | Y1206_HRB510658-B8536_HRB721969 | B8536_HRB721969 | Freiburg HRB 721969 | Registergericht Freiburg i. Br. | B8536 | 2020-06-09 | |
2439945 | 2439945 | Y1206_HRB510658-B8536_HRB721969 | Y1206_HRB510658 | Jena HRB 510658 | Jena | Y1206 | 2014-10-21 | 2020-06-09 |
2439944 | 2439944 | Y1206_HRB510652 | Y1206_HRB510652 | Jena HRB 510652 | Jena | Y1206 | 2014-10-20 | |
2439943 | 2439943 | Y1206_HRB510622 | Y1206_HRB510622 | Jena HRB 510622 | Jena | Y1206 | 2014-10-08 | |
2439942 | 2439942 | Y1206_HRB510399 | Y1206_HRB510399 | Jena HRB 510399 | Jena | Y1206 | 2014-07-23 | |
2439941 | 2439941 | Y1206_HRB510388 | Y1206_HRB510388 | Jena HRB 510388 | Jena | Y1206 | 2014-07-22 | |
2439940 | 2439940 | Y1206_HRB510316 | Y1206_HRB510316 | Jena HRB 510316 | Jena | Y1206 | 2014-06-24 | |
2439939 | 2439939 | Y1206_HRB510229 | Y1206_HRB510229 | Jena HRB 510229 | Jena | Y1206 | 2014-05-22 | |
2439938 | 2439938 | Y1206_HRB510110 | Y1206_HRB510110 | Jena HRB 510110 | Jena | Y1206 | 2014-04-11 | |
2439937 | 2439937 | Y1206_HRB509889 | Y1206_HRB509889 | Jena HRB 509889 | Jena | Y1206 | 2014-02-06 | |
2439936 | 2439936 | Y1206_HRB509877 | Y1206_HRB509877 | Jena HRB 509877 | Jena | Y1206 | 2014-02-03 | |
2439935 | 2439935 | Y1206_HRB509636 | Y1206_HRB509636 | Jena HRB 509636 | Jena | Y1206 | 2013-11-13 | |
2439934 | 2439934 | Y1206_HRB509588 | Y1206_HRB509588 | Jena HRB 509588 | Jena | Y1206 | 2013-10-24 | |
2439933 | 2439933 | Y1206_HRB509566 | Y1206_HRB509566 | Jena HRB 509566 | Jena | Y1206 | 2013-10-21 | |
2439932 | 2439932 | Y1206_HRB509552 | Y1206_HRB509552 | Jena HRB 509552 | Jena | Y1206 | 2013-10-14 | |
2439931 | 2439931 | Y1206_HRB509526 | Y1206_HRB509526 | Jena HRB 509526 | Jena | Y1206 | 2013-09-30 | |
2439930 | 2439930 | Y1206_HRB509422 | Y1206_HRB509422 | Jena HRB 509422 | Jena | Y1206 | 2013-08-26 | |
2439929 | 2439929 | Y1206_HRB509387 | Y1206_HRB509387 | Jena HRB 509387 | Jena | Y1206 | 2013-08-14 | |
2439928 | 2439928 | Y1206_HRB509375 | Y1206_HRB509375 | Jena HRB 509375 | Jena | Y1206 | 2013-08-09 | |
2439927 | 2439927 | Y1206_HRB509318 | Y1206_HRB509318 | Jena HRB 509318 | Jena | Y1206 | 2013-07-22 | |
2439926 | 2439926 | Y1206_HRB509309 | Y1206_HRB509309 | Jena HRB 509309 | Jena | Y1206 | 2013-07-19 | |
2439925 | 2439925 | Y1206_HRB509191 | Y1206_HRB509191 | Jena HRB 509191 | Jena | Y1206 | 2013-06-12 | |
2439924 | 2439924 | Y1206_HRB509190 | Y1206_HRB509190 | Jena HRB 509190 | Jena | Y1206 | 2013-06-12 | |
2439923 | 2439923 | Y1206_HRB509116 | Y1206_HRB509116 | Jena HRB 509116 | Jena | Y1206 | 2013-05-17 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "ReferenceNumbers" ( "companyId" varchar, "stdRefNo" varchar, "nativeReferenceNumber" varchar, "courtName" varchar, "courtCode" varchar, "referenceNumberFirstSeen" date, "validTill" date ); CREATE INDEX "RefNocompanyId" ON "ReferenceNumbers" ( "companyId" );