ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by validTill descending
This data as json, CSV (advanced)
Suggested facets: validTill (date)
These facets timed out: referenceNumberFirstSeen
Link | rowid | companyId | stdRefNo | nativeReferenceNumber | courtName | courtCode | referenceNumberFirstSeen | validTill ▲ |
---|---|---|---|---|---|---|---|---|
144214 | 144214 | M1201_HRB122065 | M1201_HRB122065 | Frankfurt am Main HRB 122065 | Frankfurt am Main | M1201 | 2021-02-25 | 2022-07-31 |
506152 | 506152 | R1202_HRB27074-M1114_HRB48794-M1201_HRB113661 | M1201_HRB113661 | Frankfurt am Main HRB 113661 | Frankfurt am Main | M1201 | 2018-11-14 | 2022-07-31 |
753933 | 753933 | M1201_HRB125740 | M1201_HRB125740 | Frankfurt am Main HRB 125740 | Frankfurt am Main | M1201 | 2021-12-14 | 2022-07-31 |
1358035 | 1358035 | M1201_HRB114543 | M1201_HRB114543 | Frankfurt am Main HRB 114543 | Frankfurt am Main | M1201 | 2019-02-19 | 2022-07-31 |
1363837 | 1363837 | M1201_HRB90353 | M1201_HRB90353 | Frankfurt am Main HRB 90353 | Frankfurt am Main | M1201 | 2011-03-01 | 2022-07-31 |
2054091 | 2054091 | R3306_HRB93553-M1201_HRB116832 | M1201_HRB116832 | Frankfurt am Main HRB 116832 | Frankfurt am Main | M1201 | 2019-10-01 | 2022-07-31 |
2236495 | 2236495 | M1201_HRB114918-T2408_HRB46126 | T2408_HRB46126 | Wittlich HRB 46126 | Wittlich | T2408 | 2022-07-19 | 2022-07-31 |
2237874 | 2237874 | M1201_HRB126389 | M1201_HRB126389 | Frankfurt am Main HRB 126389 | Frankfurt am Main | M1201 | 2022-02-16 | 2022-07-31 |
2305129 | 2305129 | R2103_HRB2942-R2307_HRB6559-M1201_HRB107053 | M1201_HRB107053 | Frankfurt am Main HRB 107053 | Frankfurt am Main | M1201 | 2016-12-02 | 2022-07-31 |
82922 | 82922 | D4608_HRB8806-G1312_HRB37079P | D4608_HRB8806 | Schweinfurt HRB 8806 | Schweinfurt | D4608 | 2022-04-29 | 2022-07-29 |
168118 | 168118 | P1103_HRB209423-G1312_HRB37073P | P1103_HRB209423 | Braunschweig HRB 209423 | Braunschweig | P1103 | 2021-08-16 | 2022-07-29 |
1905157 | 1905157 | F1103_HRB231746B-G1312_HRB37072P | F1103_HRB231746B | Charlottenburg (Berlin) HRB 231746 B | Berlin (Charlottenburg) | F1103 | 2021-07-20 | 2022-07-29 |
52361 | 52361 | D2601_HRB203661-P2305_HRB223963 | D2601_HRB203661 | München HRB 203661 | München | D2601 | 2013-02-19 | 2022-07-28 |
94690 | 94690 | F1103_HRB168554B-G1103_HRB16511CB | F1103_HRB168554B | Charlottenburg (Berlin) HRB 168554 B | Berlin (Charlottenburg) | F1103 | 2015-07-07 | 2022-07-28 |
141117 | 141117 | M1114_HRB53841-G1309_HRB13943NP | M1114_HRB53841 | Offenbach am Main HRB 53841 | Offenbach am Main | M1114 | 2021-07-19 | 2022-07-28 |
144852 | 144852 | M1201_HRB127565-M1203_HRB11304 | M1201_HRB127565 | Frankfurt am Main HRB 127565 | Frankfurt am Main | M1201 | 2022-05-30 | 2022-07-28 |
363588 | 363588 | D2601_HRB253874-F1103_HRB244480B | D2601_HRB253874 | München HRB 253874 | München | D2601 | 2020-01-07 | 2022-07-28 |
400099 | 400099 | F1103_HRB173111B-B2609_HRB785724 | F1103_HRB173111B | Charlottenburg (Berlin) HRB 173111 B | Berlin (Charlottenburg) | F1103 | 2015-12-29 | 2022-07-28 |
668719 | 668719 | D2601_HRB257962-F1103_HRB244479B | D2601_HRB257962 | München HRB 257962 | München | D2601 | 2020-07-20 | 2022-07-28 |
669922 | 669922 | D2601_HRB267778-F1103_HRB244485B | D2601_HRB267778 | München HRB 267778 | München | D2601 | 2021-07-13 | 2022-07-28 |
710112 | 710112 | F1103_HRB217980B-M1201_HRB121271-M1203_HRB11305 | M1201_HRB121271 | Frankfurt am Main HRB 121271 | Frankfurt am Main | M1201 | 2020-12-04 | 2022-07-28 |
718384 | 718384 | F1103_HRB99913B-G1312_HRB37068P | F1103_HRB99913B | Charlottenburg (Berlin) HRB 99913 B | Berlin (Charlottenburg) | F1103 | 2006-01-03 | 2022-07-28 |
1059538 | 1059538 | M1201_HRB18229-M1103_HRB103787 | M1201_HRB18229 | Frankfurt am Main HRB 18229 | Frankfurt am Main | M1201 | 2008-04-16 | 2022-07-28 |
1278329 | 1278329 | D2601_HRB275564-B2609_HRB785733 | D2601_HRB275564 | München HRB 275564 | München | D2601 | 2022-04-26 | 2022-07-28 |
1318699 | 1318699 | F1103_HRB234066B-N1105_HRB21631-F1103_HRB244484B | N1105_HRB21631 | Neubrandenburg HRB 21631 | Neubrandenburg | N1105 | 2022-05-31 | 2022-07-28 |
1475905 | 1475905 | T2408_HRB42712-P2408_HRB208271 | T2408_HRB42712 | Wittlich HRB 42712 | Wittlich | T2408 | 2014-03-20 | 2022-07-28 |
1537538 | 1537538 | B2805_HRB725940-X1112_HRB15846FL | B2805_HRB725940 | Ulm HRB 725940 | Ulm | B2805 | 2010-12-27 | 2022-07-28 |
1556166 | 1556166 | D2601_HRB147010-P2305_HRB223960 | D2601_HRB147010 | München HRB 147010 | München | D2601 | 2005-01-24 | 2022-07-28 |
1572217 | 1572217 | D2601_HRB275568-B2609_HRB785730 | D2601_HRB275568 | München HRB 275568 | München | D2601 | 2022-04-26 | 2022-07-28 |
1897658 | 1897658 | F1103_HRB169585B-K1101_HRB145798-G1207_HRB19525FF | K1101_HRB145798 | Hamburg HRB 145798 | Hamburg | K1101 | 2017-03-31 | 2022-07-28 |
1902038 | 1902038 | F1103_HRB204900B-G1103_HRB16508CB | F1103_HRB204900B | Charlottenburg (Berlin) HRB 204900 B | Berlin (Charlottenburg) | F1103 | 2019-03-19 | 2022-07-28 |
2211012 | 2211012 | G1312_HRB35551P-G1207_HRB19527FF | G1312_HRB35551P | Potsdam HRB 35551 P | Potsdam | G1312 | 2021-07-08 | 2022-07-28 |
155209 | 155209 | M1502_HRB1053-T2214_HRB28626 | M1502_HRB1053 | Hanau HRB 1053 | Hanau | M1502 | 2008-08-21 | 2022-07-27 |
195538 | 195538 | R1101_HRB72982-B8536_HRB727055 | R1101_HRB72982 | Düsseldorf HRB 72982 | Düsseldorf | R1101 | 2014-07-24 | 2022-07-27 |
416724 | 416724 | G1207_HRB18412FF-B2609_HRB785706 | G1207_HRB18412FF | Frankfurt/Oder HRB 18412 FF | Frankfurt/Oder | G1207 | 2021-01-18 | 2022-07-27 |
456054 | 456054 | M1202_HRB14105-M1502_HRB98850 | M1202_HRB14105 | Bad Homburg HRB 14105 | Bad Homburg v.d.H. | M1202 | 2018-02-01 | 2022-07-27 |
695160 | 695160 | D5701_HRB9166-G1312_HRB37065P | D5701_HRB9166 | Ingolstadt HRB 9166 | Ingolstadt | D5701 | 2019-05-27 | 2022-07-27 |
1219643 | 1219643 | Y1206_HRB517562-G1207_HRB19518FF | Y1206_HRB517562 | Jena HRB 517562 | Jena | Y1206 | 2020-11-24 | 2022-07-27 |
1238972 | 1238972 | B2609_HRB764586-B1601_HRB744537 | B2609_HRB764586 | Stuttgart HRB 764586 | Stuttgart | B2609 | 2018-03-29 | 2022-07-27 |
1285845 | 1285845 | D3201_HRB5310-B1601_HRB744548 | D3201_HRB5310 | Ansbach HRB 5310 | Ansbach | D3201 | 2011-10-19 | 2022-07-27 |
1321316 | 1321316 | F1103_HRB58866B-G1207_HRB19519FF | F1103_HRB58866B | Charlottenburg (Berlin) HRB 58866 B | Berlin (Charlottenburg) | F1103 | 2013-01-14 | 2022-07-27 |
1332718 | 1332718 | H1101_HRB15487HB-B8536_HRB727060 | H1101_HRB15487HB | Bremen HRB 15487 HB | Bremen | H1101 | 2013-09-09 | 2022-07-27 |
1456787 | 1456787 | R3201_HRB26926-X1721_HRB22820HL | R3201_HRB26926 | Bonn HRB 26926 | Bonn | R3201 | 2022-02-08 | 2022-07-27 |
1474667 | 1474667 | T2304_HRB49929-D3410_HRB19465 | T2304_HRB49929 | Mainz HRB 49929 | Mainz | T2304 | 2020-10-28 | 2022-07-27 |
1610420 | 1610420 | F1103_HRB217931B-M1201_HRB121269-M1203_HRB11301 | M1201_HRB121269 | Frankfurt am Main HRB 121269 | Frankfurt am Main | M1201 | 2020-12-04 | 2022-07-27 |
1898216 | 1898216 | F1103_HRB173558B-G1103_HRB16503CB | F1103_HRB173558B | Charlottenburg (Berlin) HRB 173558 B | Berlin (Charlottenburg) | F1103 | 2016-01-19 | 2022-07-27 |
1906090 | 1906090 | F1103_HRB240558B-D2601_HRB277954 | F1103_HRB240558B | Charlottenburg (Berlin) HRB 240558 B | Berlin (Charlottenburg) | F1103 | 2022-04-04 | 2022-07-27 |
2001545 | 2001545 | R1304_HRB12676-G1103_HRB16500CB | R1304_HRB12676 | Kleve HRB 12676 | Kleve | R1304 | 2014-03-04 | 2022-07-27 |
2083906 | 2083906 | W1215_HRB26847-N1209_HRB21053-F1103_HRB244471B | N1209_HRB21053 | Stralsund HRB 21053 | Stralsund | N1209 | 2019-08-27 | 2022-07-27 |
2120263 | 2120263 | B2609_HRB779797-B8536_HRB727058 | B2609_HRB779797 | Stuttgart HRB 779797 | Stuttgart | B2609 | 2021-06-23 | 2022-07-27 |
2157398 | 2157398 | D2601_HRB272407-F1103_HRB244451B | D2601_HRB272407 | München HRB 272407 | München | D2601 | 2022-01-11 | 2022-07-27 |
2205834 | 2205834 | G1207_HRB14016FF-G1312_HRB37064P | G1207_HRB14016FF | Frankfurt/Oder HRB 14016 FF | Frankfurt/Oder | G1207 | 2012-04-18 | 2022-07-27 |
2320222 | 2320222 | R2602_HRB612-M1201_HRB101136-M1203_HRB11300 | M1201_HRB101136 | Frankfurt am Main HRB 101136 | Frankfurt am Main | M1201 | 2015-01-09 | 2022-07-27 |
327457 | 327457 | B2609_HRB783867-B8536_HRB727050 | B2609_HRB783867 | Stuttgart HRB 783867 | Stuttgart | B2609 | 2022-03-14 | 2022-07-26 |
352296 | 352296 | D2601_HRB166481-N1308_HRB11592-P2613_HRB205600-D2601_HRB277938 | P2613_HRB205600 | Tostedt HRB 205600 | Tostedt | P2613 | 2016-05-19 | 2022-07-26 |
366095 | 366095 | D2601_HRB275096-F1103_HRB244436B | D2601_HRB275096 | München HRB 275096 | München | D2601 | 2022-04-12 | 2022-07-26 |
408930 | 408930 | F1103_HRB2681B-B8536_HRB727052 | F1103_HRB2681B | Charlottenburg (Berlin) HRB 2681 B | Berlin (Charlottenburg) | F1103 | 2006-04-10 | 2022-07-26 |
432197 | 432197 | K1101_HRB153975-X1321_HRB16850PI | K1101_HRB153975 | Hamburg HRB 153975 | Hamburg | K1101 | 2018-10-30 | 2022-07-26 |
434599 | 434599 | K1101_HRB174456-X1517_HRB24657KI | K1101_HRB174456 | Hamburg HRB 174456 | Hamburg | K1101 | 2022-03-23 | 2022-07-26 |
733438 | 733438 | K1101_HRB129622-G1207_HRB5316FF-D3310_HRB40718 | G1207_HRB5316FF | Frankfurt/Oder HRB 5316 FF | Frankfurt/Oder | G1207 | 2013-11-22 | 2022-07-26 |
738965 | 738965 | K1101_HRB174025-P2507_HRB210682 | K1101_HRB174025 | Hamburg HRB 174025 | Hamburg | K1101 | 2022-03-04 | 2022-07-26 |
887334 | 887334 | U1206_HRB34280-U1104_HRB43082 | U1206_HRB34280 | Chemnitz HRB 34280 | Chemnitz | U1206 | 2021-08-17 | 2022-07-26 |
913593 | 913593 | Y1206_HRB507602-B2805_HRB744684 | Y1206_HRB507602 | Jena HRB 507602 | Jena | Y1206 | 2012-01-30 | 2022-07-26 |
1084209 | 1084209 | P2204_HRB206212-X1517_HRB24654KI | P2204_HRB206212 | Göttingen HRB 206212 | Göttingen | P2204 | 2021-01-22 | 2022-07-26 |
1111835 | 1111835 | R1101_HRB90932-F1103_HRB244401B | R1101_HRB90932 | Düsseldorf HRB 90932 | Düsseldorf | R1101 | 2020-09-08 | 2022-07-26 |
1147637 | 1147637 | R2706_HRB6021-F1103_HRB244420B | R2706_HRB6021 | Steinfurt HRB 6021 | Steinfurt | R2706 | 2013-03-27 | 2022-07-26 |
1332724 | 1332724 | H1101_HRB1562BHV | H1101_HRB1562BHV | Bremerhaven HRB 1562 BHV | Bremen | H1101 | 2011-02-04 | 2022-07-26 |
1377070 | 1377070 | N1206_HRB11085-N1105_HRB21669 | N1206_HRB11085 | Rostock HRB 11085 | Rostock | N1206 | 2008-11-18 | 2022-07-26 |
1409550 | 1409550 | R1101_HRB90023-F1103_HRB244416B | R1101_HRB90023 | Düsseldorf HRB 90023 | Düsseldorf | R1101 | 2020-06-09 | 2022-07-26 |
1409796 | 1409796 | R1101_HRB92215-H1101_HRB38180HB | R1101_HRB92215 | Düsseldorf HRB 92215 | Düsseldorf | R1101 | 2021-01-22 | 2022-07-26 |
1764678 | 1764678 | T2210_HRB28453-T2214_HRB28614 | T2210_HRB28453 | Koblenz HRB 28453 | Koblenz | T2210 | 2021-10-22 | 2022-07-26 |
1789830 | 1789830 | W1215_HRB18868-D2102_HRB37761 | W1215_HRB18868 | Stendal HRB 18868 | Stendal | W1215 | 2012-12-14 | 2022-07-26 |
2062003 | 2062003 | T2408_HRB43703-D2304_HRB16576 | T2408_HRB43703 | Wittlich HRB 43703 | Wittlich | T2408 | 2016-12-13 | 2022-07-26 |
2070239 | 2070239 | U1206_HRB10874-D4501_HRB6564 | D4501_HRB6564 | Hof HRB 6564 | Hof | D4501 | 2022-07-20 | 2022-07-26 |
2107239 | 2107239 | B1601_HRB739655-B2609_HRB785691 | B1601_HRB739655 | Mannheim HRB 739655 | Mannheim | B1601 | 2021-03-31 | 2022-07-26 |
2119908 | 2119908 | B2609_HRB776398-F1103_HRB244403B | B2609_HRB776398 | Stuttgart HRB 776398 | Stuttgart | B2609 | 2020-12-01 | 2022-07-26 |
2394433 | 2394433 | B2609_HRB753237-B2805_HRB744685 | B2609_HRB753237 | Stuttgart HRB 753237 | Stuttgart | B2609 | 2015-07-07 | 2022-07-26 |
2415483 | 2415483 | M1203_HRB11163-M1201_HRB128204 | M1203_HRB11163 | Königstein HRB 11163 | Königstein | M1203 | 2022-03-02 | 2022-07-26 |
2440003 | 2440003 | Y1206_HRB513818-F1103_HRB244407B | Y1206_HRB513818 | Jena HRB 513818 | Jena | Y1206 | 2017-09-19 | 2022-07-26 |
59147 | 59147 | D2601_HRB259121-B2805_HRB744681 | D2601_HRB259121 | München HRB 259121 | München | D2601 | 2020-09-04 | 2022-07-25 |
121723 | 121723 | K1101_HRB111954-G1207_HRB17776FF-K1101_HRB172611-W1215_HRB31642 | K1101_HRB172611 | Hamburg HRB 172611 | Hamburg | K1101 | 2021-12-13 | 2022-07-25 |
173602 | 173602 | P2305_HRB223281-D2601_HRB277877 | P2305_HRB223281 | Hannover HRB 223281 | Hannover | P2305 | 2022-03-03 | 2022-07-25 |
327122 | 327122 | B2609_HRB781053-B2805_HRB744671 | B2609_HRB781053 | Stuttgart HRB 781053 | Stuttgart | B2609 | 2021-09-15 | 2022-07-25 |
380687 | 380687 | D3410_HRB19448-M1103_HRB33270 | D3410_HRB19448 | Regensburg HRB 19448 | Regensburg | D3410 | 2022-07-12 | 2022-07-25 |
477719 | 477719 | P2305_HRB221313-B2805_HRB744672 | P2305_HRB221313 | Hannover HRB 221313 | Hannover | P2305 | 2021-02-23 | 2022-07-25 |
573271 | 573271 | T3104_HRB68036-B2609_HRB785670 | T3104_HRB68036 | Ludwigshafen a.Rhein (Ludwigshafen) HRB 68036 | Ludwigshafen a.Rhein (Ludwigshafen) | T3104 | 2022-02-17 | 2022-07-25 |
706723 | 706723 | F1103_HRB190032B-D2803_HRB11850 | F1103_HRB190032B | Charlottenburg (Berlin) HRB 190032 B | Berlin (Charlottenburg) | F1103 | 2017-09-28 | 2022-07-25 |
720867 | 720867 | G1207_HRB17717FF-F1103_HRB244384B | G1207_HRB17717FF | Frankfurt/Oder HRB 17717 FF | Frankfurt/Oder | G1207 | 2019-11-19 | 2022-07-25 |
787968 | 787968 | P2613_HRB206796-P2507_HRB210680 | P2613_HRB206796 | Tostedt HRB 206796 | Tostedt | P2613 | 2018-07-02 | 2022-07-25 |
811376 | 811376 | R1202_HRB31797-X1721_HRB22812HL | R1202_HRB31797 | Duisburg HRB 31797 | Duisburg | R1202 | 2019-05-09 | 2022-07-25 |
1194262 | 1194262 | U1308_HRB24779-G1103_HRB8388CB-G1103_HRB8388-D4102_HRB16787 | G1103_HRB8388CB | Cottbus HRB 8388 CB | Cottbus | G1103 | 2009-07-03 | 2022-07-25 |
1477772 | 1477772 | T3104_HRB65725-B2805_HRB744680 | T3104_HRB65725 | Ludwigshafen a.Rhein (Ludwigshafen) HRB 65725 | Ludwigshafen a.Rhein (Ludwigshafen) | T3104 | 2018-02-20 | 2022-07-25 |
1477890 | 1477890 | T3104_HRB66746-D2601_HRB277870 | T3104_HRB66746 | Ludwigshafen a.Rhein (Ludwigshafen) HRB 66746 | Ludwigshafen a.Rhein (Ludwigshafen) | T3104 | 2020-02-20 | 2022-07-25 |
1487301 | 1487301 | U1206_HRB883-B2609_HRB785672 | U1206_HRB883 | Chemnitz HRB 883 | Chemnitz | U1206 | 2006-05-04 | 2022-07-25 |
1661006 | 1661006 | M1301_HRB7531-M1114_HRB54946 | M1301_HRB7531 | Fulda HRB 7531 | Fulda | M1301 | 2019-06-21 | 2022-07-25 |
1840911 | 1840911 | D2102_HRB35643-B2805_HRB744682 | D2102_HRB35643 | Augsburg HRB 35643 | Augsburg | D2102 | 2021-01-29 | 2022-07-25 |
1865769 | 1865769 | D2601_HRB276247-T2210_HRB29043 | D2601_HRB276247 | München HRB 276247 | München | D2601 | 2022-05-19 | 2022-07-25 |
1929377 | 1929377 | K1101_HRB157638-P2613_HRB209552 | K1101_HRB157638 | Hamburg HRB 157638 | Hamburg | K1101 | 2019-06-19 | 2022-07-25 |
1930998 | 1930998 | K1101_HRB171160-F1103_HRB242492B | K1101_HRB171160 | Hamburg HRB 171160 | Hamburg | K1101 | 2021-09-28 | 2022-07-25 |
1950679 | 1950679 | M1201_HRB93153-M1203_HRB11296 | M1201_HRB93153 | Frankfurt am Main HRB 93153 | Frankfurt am Main | M1201 | 2012-02-22 | 2022-07-25 |
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" );