ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by referenceNumberFirstSeen descending
This data as json, CSV (advanced)
Suggested facets: referenceNumberFirstSeen (date), validTill (date)
Link | rowid | companyId | stdRefNo | nativeReferenceNumber | courtName | courtCode | referenceNumberFirstSeen ▲ | validTill |
---|---|---|---|---|---|---|---|---|
305531 | 305531 | Y1206_HRB519816 | Y1206_HRB519816 | Jena HRB 519816 | Jena | Y1206 | 2022-08-01 | |
2391411 | 2391411 | Y1206_HRB519815 | Y1206_HRB519815 | Jena HRB 519815 | Jena | Y1206 | 2022-08-01 | |
144215 | 144215 | M1201_HRB122065 | M1201_HRB122065 | Frankfurt am Main HRB 122065 / HRB 122065 | Frankfurt am Main | M1201 | 2022-07-31 | |
506153 | 506153 | R1202_HRB27074-M1114_HRB48794-M1201_HRB113661 | M1201_HRB113661 | Frankfurt am Main HRB 113661 / HRB 113661 | Frankfurt am Main | M1201 | 2022-07-31 | |
753934 | 753934 | M1201_HRB125740 | M1201_HRB125740 | Frankfurt am Main HRB 125740 / HRB 125740 | Frankfurt am Main | M1201 | 2022-07-31 | |
878841 | 878841 | T3201_HRB33521 | T3201_HRB33521 | Kaiserslautern HRB 33521 | Kaiserslautern | T3201 | 2022-07-31 | |
1358036 | 1358036 | M1201_HRB114543 | M1201_HRB114543 | Frankfurt am Main HRB 114543 / HRB 114543 | Frankfurt am Main | M1201 | 2022-07-31 | |
1359600 | 1359600 | M1201_HRB128240 | M1201_HRB128240 | Frankfurt am Main HRB 128240 / HRB 128240 | Frankfurt am Main | M1201 | 2022-07-31 | |
1363838 | 1363838 | M1201_HRB90353 | M1201_HRB90353 | Frankfurt am Main HRB 90353 / HRB 90353 | Frankfurt am Main | M1201 | 2022-07-31 | |
2054092 | 2054092 | R3306_HRB93553-M1201_HRB116832 | M1201_HRB116832 | Frankfurt am Main HRB 116832 / HRB 116832 | Frankfurt am Main | M1201 | 2022-07-31 | |
2236496 | 2236496 | M1201_HRB114918-T2408_HRB46126 | M1201_HRB114918 | Frankfurt am Main HRB 114918 / HRB 114918 | Frankfurt am Main | M1201 | 2022-07-31 | |
2237875 | 2237875 | M1201_HRB126389 | M1201_HRB126389 | Frankfurt am Main HRB 126389 / HRB 126389 | Frankfurt am Main | M1201 | 2022-07-31 | |
2305130 | 2305130 | R2103_HRB2942-R2307_HRB6559-M1201_HRB107053 | M1201_HRB107053 | Frankfurt am Main HRB 107053 / HRB 107053 | Frankfurt am Main | M1201 | 2022-07-31 | |
82923 | 82923 | D4608_HRB8806-G1312_HRB37079P | G1312_HRB37079P | Potsdam HRB 37079 P | Potsdam | G1312 | 2022-07-29 | |
116678 | 116678 | G1312_HRB37077P | G1312_HRB37077P | Potsdam HRB 37077 P | Potsdam | G1312 | 2022-07-29 | |
119726 | 119726 | H1101_HRB38190HB | H1101_HRB38190HB | Bremen HRB 38190 HB | Bremen | H1101 | 2022-07-29 | |
129906 | 129906 | K1101_HRB176459 | K1101_HRB176459 | Hamburg HRB 176459 | Hamburg | K1101 | 2022-07-29 | |
129907 | 129907 | K1101_HRB176469 | K1101_HRB176469 | Hamburg HRB 176469 | Hamburg | K1101 | 2022-07-29 | |
129908 | 129908 | K1101_HRB176471 | K1101_HRB176471 | Hamburg HRB 176471 | Hamburg | K1101 | 2022-07-29 | |
168119 | 168119 | P1103_HRB209423-G1312_HRB37073P | G1312_HRB37073P | Potsdam HRB 37073 P | Potsdam | G1312 | 2022-07-29 | |
282207 | 282207 | U1308_HRB40565 | U1308_HRB40565 | Leipzig HRB 40565 | Leipzig | U1308 | 2022-07-29 | |
282208 | 282208 | U1308_HRB40569 | U1308_HRB40569 | Leipzig HRB 40569 | Leipzig | U1308 | 2022-07-29 | |
291695 | 291695 | X1112_HRB15847FL | X1112_HRB15847FL | Flensburg HRB 15847 FL | Flensburg | X1112 | 2022-07-29 | |
434823 | 434823 | K1101_HRB176458 | K1101_HRB176458 | Hamburg HRB 176458 | Hamburg | K1101 | 2022-07-29 | |
434824 | 434824 | K1101_HRB176473 | K1101_HRB176473 | Hamburg HRB 176473 | Hamburg | K1101 | 2022-07-29 | |
725811 | 725811 | G1312_HRB37074P | G1312_HRB37074P | Potsdam HRB 37074 P | Potsdam | G1312 | 2022-07-29 | |
725812 | 725812 | G1312_HRB37075P | G1312_HRB37075P | Potsdam HRB 37075 P | Potsdam | G1312 | 2022-07-29 | |
739235 | 739235 | K1101_HRB176460 | K1101_HRB176460 | Hamburg HRB 176460 | Hamburg | K1101 | 2022-07-29 | |
891623 | 891623 | U1308_HRB40562 | U1308_HRB40562 | Leipzig HRB 40562 | Leipzig | U1308 | 2022-07-29 | |
891624 | 891624 | U1308_HRB40567 | U1308_HRB40567 | Leipzig HRB 40567 | Leipzig | U1308 | 2022-07-29 | |
915045 | 915045 | Y1206_HRB519810 | Y1206_HRB519810 | Jena HRB 519810 | Jena | Y1206 | 2022-07-29 | |
1034234 | 1034234 | H1101_HRB38191HB | H1101_HRB38191HB | Bremen HRB 38191 HB | Bremen | H1101 | 2022-07-29 | |
1044621 | 1044621 | K1101_HRB176461 | K1101_HRB176461 | Hamburg HRB 176461 | Hamburg | K1101 | 2022-07-29 | |
1183429 | 1183429 | T3201_HRB3492 | T3201_HRB3492 | Kaiserslautern HRB 3492 | Kaiserslautern | T3201 | 2022-07-29 | |
1196351 | 1196351 | U1308_HRB40560 | U1308_HRB40560 | Leipzig HRB 40560 | Leipzig | U1308 | 2022-07-29 | |
1196352 | 1196352 | U1308_HRB40568 | U1308_HRB40568 | Leipzig HRB 40568 | Leipzig | U1308 | 2022-07-29 | |
1204252 | 1204252 | W1215_HRB31663 | W1215_HRB31663 | Stendal HRB 31663 | Stendal | W1215 | 2022-07-29 | |
1219889 | 1219889 | Y1206_HRB519806 | Y1206_HRB519806 | Jena HRB 519806 | Jena | Y1206 | 2022-07-29 | |
1219890 | 1219890 | Y1206_HRB519808 | Y1206_HRB519808 | Jena HRB 519808 | Jena | Y1206 | 2022-07-29 | |
1328090 | 1328090 | G1207_HRB9174FF | G1207_HRB9174FF | Frankfurt/Oder HRB 9174 FF | Frankfurt/Oder | G1207 | 2022-07-29 | |
1335121 | 1335121 | H1101_HRB38189HB | H1101_HRB38189HB | Bremen HRB 38189 HB | Bremen | H1101 | 2022-07-29 | |
1344995 | 1344995 | K1101_HRB176464 | K1101_HRB176464 | Hamburg HRB 176464 | Hamburg | K1101 | 2022-07-29 | |
1478665 | 1478665 | T3201_HRB33520 | T3201_HRB33520 | Kaiserslautern HRB 33520 | Kaiserslautern | T3201 | 2022-07-29 | |
1619162 | 1619162 | G1103_HRB16512CB | G1103_HRB16512CB | Cottbus HRB 16512 CB | Cottbus | G1103 | 2022-07-29 | |
1638770 | 1638770 | K1101_HRB176462 | K1101_HRB176462 | Hamburg HRB 176462 | Hamburg | K1101 | 2022-07-29 | |
1638771 | 1638771 | K1101_HRB176463 | K1101_HRB176463 | Hamburg HRB 176463 | Hamburg | K1101 | 2022-07-29 | |
1638772 | 1638772 | K1101_HRB176472 | K1101_HRB176472 | Hamburg HRB 176472 | Hamburg | K1101 | 2022-07-29 | |
1770182 | 1770182 | T2408_HRB46135 | T2408_HRB46135 | Wittlich HRB 46135 | Wittlich | T2408 | 2022-07-29 | |
1784518 | 1784518 | U1308_HRB40561 | U1308_HRB40561 | Leipzig HRB 40561 | Leipzig | U1308 | 2022-07-29 | |
1784519 | 1784519 | U1308_HRB40566 | U1308_HRB40566 | Leipzig HRB 40566 | Leipzig | U1308 | 2022-07-29 | |
1792112 | 1792112 | W1215_HRB31664 | W1215_HRB31664 | Stendal HRB 31664 | Stendal | W1215 | 2022-07-29 | |
1792113 | 1792113 | W1215_HRB31665 | W1215_HRB31665 | Stendal HRB 31665 | Stendal | W1215 | 2022-07-29 | |
1806962 | 1806962 | Y1206_HRB519805 | Y1206_HRB519805 | Jena HRB 519805 | Jena | Y1206 | 2022-07-29 | |
1806963 | 1806963 | Y1206_HRB519807 | Y1206_HRB519807 | Jena HRB 519807 | Jena | Y1206 | 2022-07-29 | |
1905158 | 1905158 | F1103_HRB231746B-G1312_HRB37072P | G1312_HRB37072P | Potsdam HRB 37072 P | Potsdam | G1312 | 2022-07-29 | |
1918682 | 1918682 | G1312_HRB37076P | G1312_HRB37076P | Potsdam HRB 37076 P | Potsdam | G1312 | 2022-07-29 | |
1918683 | 1918683 | G1312_HRB37078P | G1312_HRB37078P | Potsdam HRB 37078 P | Potsdam | G1312 | 2022-07-29 | |
1921625 | 1921625 | H1101_HRB38193HB | H1101_HRB38193HB | Bremen HRB 38193 HB | Bremen | H1101 | 2022-07-29 | |
1931568 | 1931568 | K1101_HRB176465 | K1101_HRB176465 | Hamburg HRB 176465 | Hamburg | K1101 | 2022-07-29 | |
2076666 | 2076666 | U1308_HRB40563 | U1308_HRB40563 | Leipzig HRB 40563 | Leipzig | U1308 | 2022-07-29 | |
2076667 | 2076667 | U1308_HRB40564 | U1308_HRB40564 | Leipzig HRB 40564 | Leipzig | U1308 | 2022-07-29 | |
2099514 | 2099514 | Y1206_HRB519809 | Y1206_HRB519809 | Jena HRB 519809 | Jena | Y1206 | 2022-07-29 | |
2207494 | 2207494 | G1309_HRB13946NP | G1309_HRB13946NP | Neuruppin HRB 13946 NP | Neuruppin | G1309 | 2022-07-29 | |
2223851 | 2223851 | K1101_HRB176456 | K1101_HRB176456 | Hamburg HRB 176456 | Hamburg | K1101 | 2022-07-29 | |
2223852 | 2223852 | K1101_HRB176457 | K1101_HRB176457 | Hamburg HRB 176457 | Hamburg | K1101 | 2022-07-29 | |
2223853 | 2223853 | K1101_HRB176466 | K1101_HRB176466 | Hamburg HRB 176466 | Hamburg | K1101 | 2022-07-29 | |
2223854 | 2223854 | K1101_HRB176467 | K1101_HRB176467 | Hamburg HRB 176467 | Hamburg | K1101 | 2022-07-29 | |
2223855 | 2223855 | K1101_HRB176470 | K1101_HRB176470 | Hamburg HRB 176470 | Hamburg | K1101 | 2022-07-29 | |
2412119 | 2412119 | K1101_HRB176468 | K1101_HRB176468 | Hamburg HRB 176468 | Hamburg | K1101 | 2022-07-29 | |
8541 | 8541 | B1601_HRB744553 | B1601_HRB744553 | Mannheim HRB 744553 | Mannheim | B1601 | 2022-07-28 | |
11858 | 11858 | B2609_HRB253002 | B2609_HRB253002 | Stuttgart HRB 253002 | Stuttgart | B2609 | 2022-07-28 | |
22516 | 22516 | B2609_HRB785736 | B2609_HRB785736 | Stuttgart HRB 785736 | Stuttgart | B2609 | 2022-07-28 | |
27450 | 27450 | B2805_HRB744709 | B2805_HRB744709 | Ulm HRB 744709 | Ulm | B2805 | 2022-07-28 | |
32668 | 32668 | B8536_HRB727063 | B8536_HRB727063 | Freiburg HRB 727063 | Registergericht Freiburg i. Br. | B8536 | 2022-07-28 | |
32669 | 32669 | B8536_HRB727066 | B8536_HRB727066 | Freiburg HRB 727066 | Registergericht Freiburg i. Br. | B8536 | 2022-07-28 | |
32670 | 32670 | B8536_HRB727067 | B8536_HRB727067 | Freiburg HRB 727067 | Registergericht Freiburg i. Br. | B8536 | 2022-07-28 | |
32671 | 32671 | B8536_HRB727069 | B8536_HRB727069 | Freiburg HRB 727069 | Registergericht Freiburg i. Br. | B8536 | 2022-07-28 | |
32672 | 32672 | B8536_HRB727071 | B8536_HRB727071 | Freiburg HRB 727071 | Registergericht Freiburg i. Br. | B8536 | 2022-07-28 | |
52362 | 52362 | D2601_HRB203661-P2305_HRB223963 | P2305_HRB223963 | Hannover HRB 223963 | Hannover | P2305 | 2022-07-28 | |
94691 | 94691 | F1103_HRB168554B-G1103_HRB16511CB | G1103_HRB16511CB | Cottbus HRB 16511 CB | Cottbus | G1103 | 2022-07-28 | |
103939 | 103939 | F1103_HRB244488B | F1103_HRB244488B | Charlottenburg (Berlin) HRB 244488 B | Berlin (Charlottenburg) | F1103 | 2022-07-28 | |
103940 | 103940 | F1103_HRB244489B | F1103_HRB244489B | Charlottenburg (Berlin) HRB 244489 B | Berlin (Charlottenburg) | F1103 | 2022-07-28 | |
103941 | 103941 | F1103_HRB244500B | F1103_HRB244500B | Charlottenburg (Berlin) HRB 244500 B | Berlin (Charlottenburg) | F1103 | 2022-07-28 | |
103942 | 103942 | F1103_HRB244502B | F1103_HRB244502B | Charlottenburg (Berlin) HRB 244502 B | Berlin (Charlottenburg) | F1103 | 2022-07-28 | |
103943 | 103943 | F1103_HRB244510B | F1103_HRB244510B | Charlottenburg (Berlin) HRB 244510 B | Berlin (Charlottenburg) | F1103 | 2022-07-28 | |
109842 | 109842 | G1103_HRB16507CB | G1103_HRB16507CB | Cottbus HRB 16507 CB | Cottbus | G1103 | 2022-07-28 | |
129904 | 129904 | K1101_HRB176449 | K1101_HRB176449 | Hamburg HRB 176449 | Hamburg | K1101 | 2022-07-28 | |
129905 | 129905 | K1101_HRB176452 | K1101_HRB176452 | Hamburg HRB 176452 | Hamburg | K1101 | 2022-07-28 | |
131068 | 131068 | K1101_HRB47081 | K1101_HRB47081 | Hamburg HRB 47081 | Hamburg | K1101 | 2022-07-28 | |
135753 | 135753 | M1103_HRB103794 | M1103_HRB103794 | Darmstadt HRB 103794 | Darmstadt | M1103 | 2022-07-28 | |
141118 | 141118 | M1114_HRB53841-G1309_HRB13943NP | G1309_HRB13943NP | Neuruppin HRB 13943 NP | Neuruppin | G1309 | 2022-07-28 | |
144853 | 144853 | M1201_HRB127565-M1203_HRB11304 | M1203_HRB11304 | Königstein HRB 11304 | Königstein | M1203 | 2022-07-28 | |
144920 | 144920 | M1201_HRB128228 | M1201_HRB128228 | Frankfurt am Main HRB 128228 | Frankfurt am Main | M1201 | 2022-07-28 | |
144921 | 144921 | M1201_HRB128233 | M1201_HRB128233 | Frankfurt am Main HRB 128233 | Frankfurt am Main | M1201 | 2022-07-28 | |
144922 | 144922 | M1201_HRB128237 | M1201_HRB128237 | Frankfurt am Main HRB 128237 | Frankfurt am Main | M1201 | 2022-07-28 | |
160331 | 160331 | M1809_HRB8052 | M1809_HRB8052 | Marburg HRB 8052 | Marburg | M1809 | 2022-07-28 | |
168210 | 168210 | P1103_HRB210174 | P1103_HRB210174 | Braunschweig HRB 210174 | Braunschweig | P1103 | 2022-07-28 | |
175873 | 175873 | P2408_HRB208269 | P2408_HRB208269 | Hildesheim HRB 208269 | Hildesheim | P2408 | 2022-07-28 | |
186400 | 186400 | P3210_HRB218487 | P3210_HRB218487 | Oldenburg HRB 218487 | Oldenburg (Oldenburg) | P3210 | 2022-07-28 | |
186818 | 186818 | P3313_HRB110298 | P3313_HRB110298 | Osnabrück HRB 110298 | Osnabrück | P3313 | 2022-07-28 |
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" );