ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by companyId
This data as json, CSV (advanced)
Link | rowid | companyId ▼ | stdRefNo | nativeReferenceNumber | courtName | courtCode | referenceNumberFirstSeen | validTill |
---|---|---|---|---|---|---|---|---|
2099526 | 2099526 | B1510_HRB1705-V1109_HRB13614 | V1109_HRB13614 | Saarbrücken HRB 13614 | Saarbrücken | V1109 | 2005-02-03 | |
1806979 | 1806979 | B1510_HRB1760-F1103_HRB69452B | F1103_HRB69452B | Charlottenburg (Berlin) HRB 69452 B | Berlin (Charlottenburg) | F1103 | 2005-11-01 | |
915056 | 915056 | B1510_HRB1767-T3104_HRB42732 | T3104_HRB42732 | Ludwigshafen a.Rhein (Ludwigshafen) HRB 42732 | Ludwigshafen a.Rhein (Ludwigshafen) | T3104 | 2005-12-15 | |
20 | 20 | B1510_HRB1778-T3104_HRB42746 | T3104_HRB42746 | Ludwigshafen a.Rhein (Ludwigshafen) HRB 42746 | Ludwigshafen a.Rhein (Ludwigshafen) | T3104 | 2006-03-02 | |
1806980 | 1806980 | B1510_HRB1789-M1201_HRB41931 | M1201_HRB41931 | Frankfurt am Main HRB 41931 | Frankfurt am Main | M1201 | 2006-07-08 | |
915057 | 915057 | B1510_HRB1792-D2304_HRB8234 | D2304_HRB8234 | Kempten HRB 8234 | Kempten (Allgäu) | D2304 | 2006-03-29 | |
21 | 21 | B1510_HRB492ST-R1101_HRB50784 | R1101_HRB50784 | Düsseldorf HRB 50784 | Düsseldorf | R1101 | 2005-03-15 | |
22 | 22 | B1511_HRB1869DO-R1901_HRB6585 | R1901_HRB6585 | Arnsberg HRB 6585 | Arnsberg | R1901 | 2005-12-20 | |
2099527 | 2099527 | B1511_HRB1883DO-F1103_HRB98257B | F1103_HRB98257B | Charlottenburg (Berlin) HRB 98257 B | Berlin (Charlottenburg) | F1103 | 2006-06-13 | |
1219906 | 1219906 | B1511_HRB2439-R3306_HRB57826-R2604_HRB6998 | R3306_HRB57826 | Köln HRB 57826 | Köln | R3306 | 2006-05-30 | 2010-02-04 |
1219907 | 1219907 | B1511_HRB2439-R3306_HRB57826-R2604_HRB6998 | R2604_HRB6998 | Iserlohn HRB 6998 | Iserlohn | R2604 | 2010-02-04 | |
1513385 | 1513385 | B1511_HRB2773-R2706_HRB7072 | R2706_HRB7072 | Steinfurt HRB 7072 | Steinfurt | R2706 | 2005-08-03 | |
23 | 23 | B1511_HRB2899-R3306_HRB57627 | R3306_HRB57627 | Köln HRB 57627 | Köln | R3306 | 2006-04-25 | |
1513386 | 1513386 | B1511_HRB2960-D2102_HRB19395 | D2102_HRB19395 | Augsburg HRB 19395 | Augsburg | D2102 | 2005-01-24 | |
2099528 | 2099528 | B1511_HRB3012-D2601_HRB64127 | D2601_HRB64127 | München HRB 64127 | München | D2601 | 2005-08-18 | |
1219908 | 1219908 | B1511_HRB3064-U1206_HRB15109 | U1206_HRB15109 | Chemnitz HRB 15109 | Chemnitz | U1206 | 2006-02-06 | |
1513387 | 1513387 | B1511_HRB3087-D4608_HRB4177 | D4608_HRB4177 | Schweinfurt HRB 4177 | Schweinfurt | D4608 | 2006-05-05 | |
610243 | 610243 | B1601_HRB100001 | B1601_HRB100001 | Mannheim HRB 100001 | Mannheim | B1601 | 2007-07-10 | |
24 | 24 | B1601_HRB100003 | B1601_HRB100003 | Mannheim HRB 100003 | Mannheim | B1601 | 2007-07-09 | |
25 | 25 | B1601_HRB10002-M1201_HRB87203 | B1601_HRB10002 | Mannheim HRB 10002 | Mannheim | B1601 | 2009-03-16 | 2010-01-18 |
26 | 26 | B1601_HRB10002-M1201_HRB87203 | M1201_HRB87203 | Frankfurt am Main HRB 87203 | Frankfurt am Main | M1201 | 2010-01-18 | |
305545 | 305545 | B1601_HRB100022 | B1601_HRB100022 | Mannheim HRB 100022 | Mannheim | B1601 | 2007-06-26 | |
915058 | 915058 | B1601_HRB100027 | B1601_HRB100027 | Mannheim HRB 100027 | Mannheim | B1601 | 2007-01-30 | |
1513388 | 1513388 | B1601_HRB100028 | B1601_HRB100028 | Mannheim HRB 100028 | Mannheim | B1601 | 2007-03-08 | |
1806981 | 1806981 | B1601_HRB100030 | B1601_HRB100030 | Mannheim HRB 100030 | Mannheim | B1601 | 2007-07-09 | |
610244 | 610244 | B1601_HRB10005 | B1601_HRB10005 | Mannheim HRB 10005 | Mannheim | B1601 | 2007-03-22 | |
1806982 | 1806982 | B1601_HRB100050 | B1601_HRB100050 | Mannheim HRB 100050 | Mannheim | B1601 | 2007-12-18 | |
610245 | 610245 | B1601_HRB100059-M1201_HRB102381 | B1601_HRB100059 | Mannheim HRB 100059 | Mannheim | B1601 | 2007-05-22 | 2015-06-10 |
610246 | 610246 | B1601_HRB100059-M1201_HRB102381 | M1201_HRB102381 | Frankfurt am Main HRB 102381 | Frankfurt am Main | M1201 | 2015-06-10 | |
915059 | 915059 | B1601_HRB100069-B2609_HRB756525 | B1601_HRB100069 | Mannheim HRB 100069 | Mannheim | B1601 | 2009-12-07 | 2016-04-21 |
915060 | 915060 | B1601_HRB100069-B2609_HRB756525 | B2609_HRB756525 | Stuttgart HRB 756525 | Stuttgart | B2609 | 2016-04-21 | |
1219909 | 1219909 | B1601_HRB100070 | B1601_HRB100070 | Mannheim HRB 100070 | Mannheim | B1601 | 2015-10-28 | |
915061 | 915061 | B1601_HRB100084 | B1601_HRB100084 | Mannheim HRB 100084 | Mannheim | B1601 | 2007-07-23 | |
2099529 | 2099529 | B1601_HRB100087 | B1601_HRB100087 | Mannheim HRB 100087 | Mannheim | B1601 | 2018-09-24 | |
915062 | 915062 | B1601_HRB100088 | B1601_HRB100088 | Mannheim HRB 100088 | Mannheim | B1601 | 2015-07-06 | |
610247 | 610247 | B1601_HRB100094-D2102_HRB22709 | B1601_HRB100094 | Mannheim HRB 100094 | Mannheim | B1601 | 2007-02-12 | 2007-06-27 |
610248 | 610248 | B1601_HRB100094-D2102_HRB22709 | D2102_HRB22709 | Augsburg HRB 22709 | Augsburg | D2102 | 2007-06-27 | |
27 | 27 | B1601_HRB100097 | B1601_HRB100097 | Mannheim HRB 100097 | Mannheim | B1601 | 2008-02-29 | |
2391415 | 2391415 | B1601_HRB100106 | B1601_HRB100106 | Mannheim HRB 100106 | Mannheim | B1601 | 2009-05-05 | |
1806983 | 1806983 | B1601_HRB10011 | B1601_HRB10011 | Mannheim HRB 10011 | Mannheim | B1601 | 2008-11-14 | |
1219910 | 1219910 | B1601_HRB100118 | B1601_HRB100118 | Mannheim HRB 100118 | Mannheim | B1601 | 2015-11-06 | |
610249 | 610249 | B1601_HRB10012 | B1601_HRB10012 | Mannheim HRB 10012 | Mannheim | B1601 | 2020-01-07 | |
915063 | 915063 | B1601_HRB100123 | B1601_HRB100123 | Mannheim HRB 100123 | Mannheim | B1601 | 2007-02-22 | |
1513389 | 1513389 | B1601_HRB100131 | B1601_HRB100131 | Mannheim HRB 100131 | Mannheim | B1601 | 2013-10-30 | |
1806984 | 1806984 | B1601_HRB100132 | B1601_HRB100132 | Mannheim HRB 100132 | Mannheim | B1601 | 2013-04-24 | |
1219911 | 1219911 | B1601_HRB100134 | B1601_HRB100134 | Mannheim HRB 100134 | Mannheim | B1601 | 2007-05-16 | |
915064 | 915064 | B1601_HRB100135 | B1601_HRB100135 | Mannheim HRB 100135 | Mannheim | B1601 | 2014-12-29 | |
610250 | 610250 | B1601_HRB100138 | B1601_HRB100138 | Mannheim HRB 100138 | Mannheim | B1601 | 2008-07-29 | |
28 | 28 | B1601_HRB100145 | B1601_HRB100145 | Mannheim HRB 100145 | Mannheim | B1601 | 2007-08-01 | |
2099530 | 2099530 | B1601_HRB100147 | B1601_HRB100147 | Mannheim HRB 100147 | Mannheim | B1601 | 2008-04-16 | |
29 | 29 | B1601_HRB10015 | B1601_HRB10015 | Mannheim HRB 10015 | Mannheim | B1601 | 2008-05-06 | |
30 | 30 | B1601_HRB100152 | B1601_HRB100152 | Mannheim HRB 100152 | Mannheim | B1601 | 2012-10-30 | |
1806985 | 1806985 | B1601_HRB100157 | B1601_HRB100157 | Mannheim HRB 100157 | Mannheim | B1601 | 2010-07-28 | |
610251 | 610251 | B1601_HRB100159 | B1601_HRB100159 | Mannheim HRB 100159 | Mannheim | B1601 | 2007-11-15 | |
1513390 | 1513390 | B1601_HRB100162 | B1601_HRB100162 | Mannheim HRB 100162 | Mannheim | B1601 | 2007-03-28 | |
2099531 | 2099531 | B1601_HRB100164 | B1601_HRB100164 | Mannheim HRB 100164 | Mannheim | B1601 | 2008-07-22 | |
1806986 | 1806986 | B1601_HRB100165 | B1601_HRB100165 | Mannheim HRB 100165 | Mannheim | B1601 | 2011-04-05 | |
610252 | 610252 | B1601_HRB10017 | B1601_HRB10017 | Mannheim HRB 10017 | Mannheim | B1601 | 2007-04-04 | |
1219912 | 1219912 | B1601_HRB10018 | B1601_HRB10018 | Mannheim HRB 10018 | Mannheim | B1601 | 2008-06-03 | |
31 | 31 | B1601_HRB100194 | B1601_HRB100194 | Mannheim HRB 100194 | Mannheim | B1601 | 2007-09-19 | |
1513391 | 1513391 | B1601_HRB100196 | B1601_HRB100196 | Mannheim HRB 100196 | Mannheim | B1601 | 2007-09-20 | |
1806987 | 1806987 | B1601_HRB100197 | B1601_HRB100197 | Mannheim HRB 100197 | Mannheim | B1601 | 2020-11-24 | |
1806988 | 1806988 | B1601_HRB10020 | B1601_HRB10020 | Mannheim HRB 10020 | Mannheim | B1601 | 2008-08-11 | |
1219913 | 1219913 | B1601_HRB100203 | B1601_HRB100203 | Mannheim HRB 100203 | Mannheim | B1601 | 2007-03-05 | |
2099532 | 2099532 | B1601_HRB10022 | B1601_HRB10022 | Mannheim HRB 10022 | Mannheim | B1601 | 2015-08-24 | |
32 | 32 | B1601_HRB100220 | B1601_HRB100220 | Mannheim HRB 100220 | Mannheim | B1601 | 2010-08-03 | |
1806989 | 1806989 | B1601_HRB100225 | B1601_HRB100225 | Mannheim HRB 100225 | Mannheim | B1601 | 2013-08-19 | |
2099533 | 2099533 | B1601_HRB10023 | B1601_HRB10023 | Mannheim HRB 10023 | Mannheim | B1601 | 2008-07-10 | |
1513392 | 1513392 | B1601_HRB100231 | B1601_HRB100231 | Mannheim HRB 100231 | Mannheim | B1601 | 2020-07-29 | |
1806990 | 1806990 | B1601_HRB100235 | B1601_HRB100235 | Mannheim HRB 100235 | Mannheim | B1601 | 2008-06-03 | |
610253 | 610253 | B1601_HRB10024 | B1601_HRB10024 | Mannheim HRB 10024 | Mannheim | B1601 | 2012-07-20 | |
1513393 | 1513393 | B1601_HRB10025-F1103_HRB195065B | B1601_HRB10025 | Mannheim HRB 10025 | Mannheim | B1601 | 2013-12-13 | 2018-04-03 |
1513394 | 1513394 | B1601_HRB10025-F1103_HRB195065B | F1103_HRB195065B | Charlottenburg (Berlin) HRB 195065 B | Berlin (Charlottenburg) | F1103 | 2018-04-03 | |
1219914 | 1219914 | B1601_HRB10026 | B1601_HRB10026 | Mannheim HRB 10026 | Mannheim | B1601 | 2016-08-12 | |
1513395 | 1513395 | B1601_HRB100265 | B1601_HRB100265 | Mannheim HRB 100265 | Mannheim | B1601 | 2007-10-09 | |
915065 | 915065 | B1601_HRB100270 | B1601_HRB100270 | Mannheim HRB 100270 | Mannheim | B1601 | 2009-03-25 | |
305546 | 305546 | B1601_HRB100272 | B1601_HRB100272 | Mannheim HRB 100272 | Mannheim | B1601 | 2009-10-22 | |
1513396 | 1513396 | B1601_HRB10028 | B1601_HRB10028 | Mannheim HRB 10028 | Mannheim | B1601 | 2008-05-09 | |
1806991 | 1806991 | B1601_HRB100285-F1103_HRB114415B-F1103_HRB114415 | B1601_HRB100285 | Mannheim HRB 100285 | Mannheim | B1601 | 2007-03-12 | 2008-07-14 |
1806992 | 1806992 | B1601_HRB100285-F1103_HRB114415B-F1103_HRB114415 | F1103_HRB114415B | Charlottenburg (Berlin) HRB 114415 B | Berlin (Charlottenburg) | F1103 | 2008-07-14 | |
610254 | 610254 | B1601_HRB100288 | B1601_HRB100288 | Mannheim HRB 100288 | Mannheim | B1601 | 2007-02-15 | |
1219915 | 1219915 | B1601_HRB100294 | B1601_HRB100294 | Mannheim HRB 100294 | Mannheim | B1601 | 2007-05-10 | |
305547 | 305547 | B1601_HRB10030 | B1601_HRB10030 | Mannheim HRB 10030 | Mannheim | B1601 | 2009-04-03 | |
305548 | 305548 | B1601_HRB100302 | B1601_HRB100302 | Mannheim HRB 100302 | Mannheim | B1601 | 2007-03-14 | |
33 | 33 | B1601_HRB100306 | B1601_HRB100306 | Mannheim HRB 100306 | Mannheim | B1601 | 2008-02-05 | |
1806993 | 1806993 | B1601_HRB100326 | B1601_HRB100326 | Mannheim HRB 100326 | Mannheim | B1601 | 2010-08-04 | |
305549 | 305549 | B1601_HRB100327 | B1601_HRB100327 | Mannheim HRB 100327 | Mannheim | B1601 | 2020-07-31 | |
2391416 | 2391416 | B1601_HRB10033 | B1601_HRB10033 | Mannheim HRB 10033 | Mannheim | B1601 | 2008-07-04 | |
305550 | 305550 | B1601_HRB100330 | B1601_HRB100330 | Mannheim HRB 100330 | Mannheim | B1601 | 2010-02-25 | |
2099534 | 2099534 | B1601_HRB100332 | B1601_HRB100332 | Mannheim HRB 100332 | Mannheim | B1601 | 2010-01-14 | |
1513397 | 1513397 | B1601_HRB100341 | B1601_HRB100341 | Mannheim HRB 100341 | Mannheim | B1601 | 2013-09-11 | |
2099535 | 2099535 | B1601_HRB100343 | B1601_HRB100343 | Mannheim HRB 100343 | Mannheim | B1601 | 2013-09-17 | |
610255 | 610255 | B1601_HRB10035 | B1601_HRB10035 | Mannheim HRB 10035 | Mannheim | B1601 | 2007-07-26 | |
915066 | 915066 | B1601_HRB10036 | B1601_HRB10036 | Mannheim HRB 10036 | Mannheim | B1601 | 2019-02-28 | |
610256 | 610256 | B1601_HRB100360 | B1601_HRB100360 | Mannheim HRB 100360 | Mannheim | B1601 | 2014-09-17 | |
1219916 | 1219916 | B1601_HRB100361 | B1601_HRB100361 | Mannheim HRB 100361 | Mannheim | B1601 | 2008-01-09 | |
1806994 | 1806994 | B1601_HRB100369 | B1601_HRB100369 | Mannheim HRB 100369 | Mannheim | B1601 | 2010-08-30 | |
1513398 | 1513398 | B1601_HRB10037 | B1601_HRB10037 | Mannheim HRB 10037 | Mannheim | B1601 | 2007-02-23 | |
1513399 | 1513399 | B1601_HRB100372 | B1601_HRB100372 | Mannheim HRB 100372 | Mannheim | B1601 | 2006-12-27 | |
1513400 | 1513400 | B1601_HRB10038 | B1601_HRB10038 | Mannheim HRB 10038 | Mannheim | B1601 | 2009-01-30 |
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" );