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 |
---|---|---|---|---|---|---|---|---|
34 | 34 | B1601_HRB100381 | B1601_HRB100381 | Mannheim HRB 100381 | Mannheim | B1601 | 2007-06-06 | |
305551 | 305551 | B1601_HRB100384 | B1601_HRB100384 | Mannheim HRB 100384 | Mannheim | B1601 | 2009-07-27 | |
915067 | 915067 | B1601_HRB10039 | B1601_HRB10039 | Mannheim HRB 10039 | Mannheim | B1601 | 2007-01-30 | |
2099536 | 2099536 | B1601_HRB10040-M1103_HRB94875 | B1601_HRB10040 | Mannheim HRB 10040 | Mannheim | B1601 | 2007-05-22 | 2015-12-07 |
2099537 | 2099537 | B1601_HRB10040-M1103_HRB94875 | M1103_HRB94875 | Darmstadt HRB 94875 | Darmstadt | M1103 | 2015-12-07 | |
610257 | 610257 | B1601_HRB100404 | B1601_HRB100404 | Mannheim HRB 100404 | Mannheim | B1601 | 2010-02-15 | |
915068 | 915068 | B1601_HRB100407 | B1601_HRB100407 | Mannheim HRB 100407 | Mannheim | B1601 | 2009-12-17 | |
2099538 | 2099538 | B1601_HRB10041 | B1601_HRB10041 | Mannheim HRB 10041 | Mannheim | B1601 | 2009-03-12 | |
915069 | 915069 | B1601_HRB100414 | B1601_HRB100414 | Mannheim HRB 100414 | Mannheim | B1601 | 2011-05-12 | |
305552 | 305552 | B1601_HRB10042-T3104_HRB61605 | B1601_HRB10042 | Mannheim HRB 10042 | Mannheim | B1601 | 2008-02-04 | 2009-06-29 |
305553 | 305553 | B1601_HRB10042-T3104_HRB61605 | T3104_HRB61605 | Ludwigshafen a.Rhein (Ludwigshafen) HRB 61605 | Ludwigshafen a.Rhein (Ludwigshafen) | T3104 | 2009-06-29 | |
2099539 | 2099539 | B1601_HRB100428 | B1601_HRB100428 | Mannheim HRB 100428 | Mannheim | B1601 | 2007-05-09 | |
915070 | 915070 | B1601_HRB100429 | B1601_HRB100429 | Mannheim HRB 100429 | Mannheim | B1601 | 2007-09-13 | |
1806995 | 1806995 | B1601_HRB10043 | B1601_HRB10043 | Mannheim HRB 10043 | Mannheim | B1601 | 2009-06-10 | |
2099540 | 2099540 | B1601_HRB10044 | B1601_HRB10044 | Mannheim HRB 10044 | Mannheim | B1601 | 2009-09-28 | |
915071 | 915071 | B1601_HRB100457 | B1601_HRB100457 | Mannheim HRB 100457 | Mannheim | B1601 | 2021-05-10 | |
915072 | 915072 | B1601_HRB100459 | B1601_HRB100459 | Mannheim HRB 100459 | Mannheim | B1601 | 2007-04-19 | |
35 | 35 | B1601_HRB10046 | B1601_HRB10046 | Mannheim HRB 10046 | Mannheim | B1601 | 2021-02-09 | |
2099541 | 2099541 | B1601_HRB10047 | B1601_HRB10047 | Mannheim HRB 10047 | Mannheim | B1601 | 2011-10-31 | |
1219917 | 1219917 | B1601_HRB100473-B8536_HRB713522 | B1601_HRB100473 | Mannheim HRB 100473 | Mannheim | B1601 | 2015-09-01 | 2015-09-01 |
1219918 | 1219918 | B1601_HRB100473-B8536_HRB713522 | B8536_HRB713522 | Freiburg HRB 713522 | Registergericht Freiburg i. Br. | B8536 | 2015-09-01 | |
1806996 | 1806996 | B1601_HRB100475 | B1601_HRB100475 | Mannheim HRB 100475 | Mannheim | B1601 | 2007-02-22 | |
1513401 | 1513401 | B1601_HRB10048 | B1601_HRB10048 | Mannheim HRB 10048 | Mannheim | B1601 | 2006-12-21 | |
305554 | 305554 | B1601_HRB10049 | B1601_HRB10049 | Mannheim HRB 10049 | Mannheim | B1601 | 2011-04-01 | |
1806997 | 1806997 | B1601_HRB100490 | B1601_HRB100490 | Mannheim HRB 100490 | Mannheim | B1601 | 2009-11-16 | |
1513402 | 1513402 | B1601_HRB10050 | B1601_HRB10050 | Mannheim HRB 10050 | Mannheim | B1601 | 2011-02-14 | |
36 | 36 | B1601_HRB100502 | B1601_HRB100502 | Mannheim HRB 100502 | Mannheim | B1601 | 2007-04-26 | |
610258 | 610258 | B1601_HRB100506 | B1601_HRB100506 | Mannheim HRB 100506 | Mannheim | B1601 | 2008-01-14 | |
1513403 | 1513403 | B1601_HRB10051 | B1601_HRB10051 | Mannheim HRB 10051 | Mannheim | B1601 | 2010-10-28 | |
2099542 | 2099542 | B1601_HRB100511 | B1601_HRB100511 | Mannheim HRB 100511 | Mannheim | B1601 | 2009-02-05 | |
305555 | 305555 | B1601_HRB100513 | B1601_HRB100513 | Mannheim HRB 100513 | Mannheim | B1601 | 2009-04-24 | |
2099543 | 2099543 | B1601_HRB10052 | B1601_HRB10052 | Mannheim HRB 10052 | Mannheim | B1601 | 2008-04-18 | |
1513404 | 1513404 | B1601_HRB100526 | B1601_HRB100526 | Mannheim HRB 100526 | Mannheim | B1601 | 2008-11-27 | |
610259 | 610259 | B1601_HRB100531 | B1601_HRB100531 | Mannheim HRB 100531 | Mannheim | B1601 | 2015-02-20 | |
915073 | 915073 | B1601_HRB10054 | B1601_HRB10054 | Mannheim HRB 10054 | Mannheim | B1601 | 2012-08-22 | |
610260 | 610260 | B1601_HRB100548 | B1601_HRB100548 | Mannheim HRB 100548 | Mannheim | B1601 | 2012-04-13 | |
610261 | 610261 | B1601_HRB100554 | B1601_HRB100554 | Mannheim HRB 100554 | Mannheim | B1601 | 2006-12-18 | |
37 | 37 | B1601_HRB100556 | B1601_HRB100556 | Mannheim HRB 100556 | Mannheim | B1601 | 2011-12-06 | |
38 | 38 | B1601_HRB100560 | B1601_HRB100560 | Mannheim HRB 100560 | Mannheim | B1601 | 2008-06-16 | |
915074 | 915074 | B1601_HRB100565 | B1601_HRB100565 | Mannheim HRB 100565 | Mannheim | B1601 | 2007-12-27 | |
1219919 | 1219919 | B1601_HRB10057 | B1601_HRB10057 | Mannheim HRB 10057 | Mannheim | B1601 | 2009-06-03 | |
39 | 39 | B1601_HRB10058 | B1601_HRB10058 | Mannheim HRB 10058 | Mannheim | B1601 | 2010-03-09 | |
610262 | 610262 | B1601_HRB100585 | B1601_HRB100585 | Mannheim HRB 100585 | Mannheim | B1601 | 2011-11-28 | |
915075 | 915075 | B1601_HRB10059 | B1601_HRB10059 | Mannheim HRB 10059 | Mannheim | B1601 | 2019-01-24 | |
1513405 | 1513405 | B1601_HRB100603 | B1601_HRB100603 | Mannheim HRB 100603 | Mannheim | B1601 | 2008-02-07 | |
915076 | 915076 | B1601_HRB10061-T3104_HRB63098-B1601_HRB728139 | B1601_HRB10061 | Mannheim HRB 10061 | Mannheim | B1601 | 2008-11-24 | 2012-06-27 |
915077 | 915077 | B1601_HRB10061-T3104_HRB63098-B1601_HRB728139 | T3104_HRB63098 | Ludwigshafen a.Rhein (Ludwigshafen) HRB 63098 | Ludwigshafen a.Rhein (Ludwigshafen) | T3104 | 2012-06-27 | 2017-07-10 |
915078 | 915078 | B1601_HRB10061-T3104_HRB63098-B1601_HRB728139 | B1601_HRB728139 | Mannheim HRB 728139 | Mannheim | B1601 | 2017-07-10 | |
1513406 | 1513406 | B1601_HRB100613 | B1601_HRB100613 | Mannheim HRB 100613 | Mannheim | B1601 | 2010-04-13 | |
1513407 | 1513407 | B1601_HRB100617 | B1601_HRB100617 | Mannheim HRB 100617 | Mannheim | B1601 | 2013-04-10 | |
40 | 40 | B1601_HRB100622 | B1601_HRB100622 | Mannheim HRB 100622 | Mannheim | B1601 | 2022-05-02 | |
1219920 | 1219920 | B1601_HRB100625 | B1601_HRB100625 | Mannheim HRB 100625 | Mannheim | B1601 | 2012-03-16 | |
1513408 | 1513408 | B1601_HRB10063-R3306_HRB73729 | B1601_HRB10063 | Mannheim HRB 10063 | Mannheim | B1601 | 2007-04-26 | 2011-10-17 |
1513409 | 1513409 | B1601_HRB10063-R3306_HRB73729 | R3306_HRB73729 | Köln HRB 73729 | Köln | R3306 | 2011-10-17 | |
1806998 | 1806998 | B1601_HRB100632 | B1601_HRB100632 | Mannheim HRB 100632 | Mannheim | B1601 | 2007-03-21 | |
41 | 41 | B1601_HRB10064 | B1601_HRB10064 | Mannheim HRB 10064 | Mannheim | B1601 | 2008-09-03 | |
1806999 | 1806999 | B1601_HRB100648 | B1601_HRB100648 | Mannheim HRB 100648 | Mannheim | B1601 | 2007-08-31 | |
610263 | 610263 | B1601_HRB10065 | B1601_HRB10065 | Mannheim HRB 10065 | Mannheim | B1601 | 2009-12-21 | |
610264 | 610264 | B1601_HRB100653 | B1601_HRB100653 | Mannheim HRB 100653 | Mannheim | B1601 | 2015-11-04 | |
1219921 | 1219921 | B1601_HRB100656 | B1601_HRB100656 | Mannheim HRB 100656 | Mannheim | B1601 | 2014-07-02 | |
305556 | 305556 | B1601_HRB100657 | B1601_HRB100657 | Mannheim HRB 100657 | Mannheim | B1601 | 2008-02-25 | |
915079 | 915079 | B1601_HRB10066 | B1601_HRB10066 | Mannheim HRB 10066 | Mannheim | B1601 | 2008-02-01 | |
42 | 42 | B1601_HRB100661 | B1601_HRB100661 | Mannheim HRB 100661 | Mannheim | B1601 | 2007-08-20 | |
915080 | 915080 | B1601_HRB100663 | B1601_HRB100663 | Mannheim HRB 100663 | Mannheim | B1601 | 2007-06-27 | |
610265 | 610265 | B1601_HRB100664 | B1601_HRB100664 | Mannheim HRB 100664 | Mannheim | B1601 | 2009-12-11 | |
1807000 | 1807000 | B1601_HRB100677 | B1601_HRB100677 | Mannheim HRB 100677 | Mannheim | B1601 | 2011-02-15 | |
1807001 | 1807001 | B1601_HRB100680 | B1601_HRB100680 | Mannheim HRB 100680 | Mannheim | B1601 | 2012-05-29 | |
915081 | 915081 | B1601_HRB100695 | B1601_HRB100695 | Mannheim HRB 100695 | Mannheim | B1601 | 2016-05-03 | |
915082 | 915082 | B1601_HRB100696 | B1601_HRB100696 | Mannheim HRB 100696 | Mannheim | B1601 | 2010-10-21 | |
610266 | 610266 | B1601_HRB100705-B8536_HRB701137 | B1601_HRB100705 | Mannheim HRB 100705 | Mannheim | B1601 | 2007-03-31 | 2007-05-15 |
610267 | 610267 | B1601_HRB100705-B8536_HRB701137 | B8536_HRB701137 | Freiburg HRB 701137 | Registergericht Freiburg i. Br. | B8536 | 2007-05-15 | |
1219922 | 1219922 | B1601_HRB100718 | B1601_HRB100718 | Mannheim HRB 100718 | Mannheim | B1601 | 2015-03-02 | |
2099544 | 2099544 | B1601_HRB10072 | B1601_HRB10072 | Mannheim HRB 10072 | Mannheim | B1601 | 2009-11-25 | |
2099545 | 2099545 | B1601_HRB100724 | B1601_HRB100724 | Mannheim HRB 100724 | Mannheim | B1601 | 2007-12-11 | |
915083 | 915083 | B1601_HRB10073-M1301_HRB6062 | B1601_HRB10073 | Mannheim HRB 10073 | Mannheim | B1601 | 2009-06-10 | 2011-11-01 |
915084 | 915084 | B1601_HRB10073-M1301_HRB6062 | M1301_HRB6062 | Fulda HRB 6062 | Fulda | M1301 | 2011-11-01 | |
1219923 | 1219923 | B1601_HRB100730 | B1601_HRB100730 | Mannheim HRB 100730 | Mannheim | B1601 | 2010-01-27 | |
1513410 | 1513410 | B1601_HRB100731 | B1601_HRB100731 | Mannheim HRB 100731 | Mannheim | B1601 | 2008-01-18 | |
1219924 | 1219924 | B1601_HRB10074 | B1601_HRB10074 | Mannheim HRB 10074 | Mannheim | B1601 | 2014-10-23 | |
305557 | 305557 | B1601_HRB10075 | B1601_HRB10075 | Mannheim HRB 10075 | Mannheim | B1601 | 2008-12-23 | |
43 | 43 | B1601_HRB10076 | B1601_HRB10076 | Mannheim HRB 10076 | Mannheim | B1601 | 2011-01-21 | |
1513411 | 1513411 | B1601_HRB100765 | B1601_HRB100765 | Mannheim HRB 100765 | Mannheim | B1601 | 2007-01-09 | |
915085 | 915085 | B1601_HRB100766 | B1601_HRB100766 | Mannheim HRB 100766 | Mannheim | B1601 | 2010-08-09 | |
44 | 44 | B1601_HRB10077 | B1601_HRB10077 | Mannheim HRB 10077 | Mannheim | B1601 | 2014-11-25 | |
1513412 | 1513412 | B1601_HRB100776 | B1601_HRB100776 | Mannheim HRB 100776 | Mannheim | B1601 | 2015-11-16 | |
305558 | 305558 | B1601_HRB100777 | B1601_HRB100777 | Mannheim HRB 100777 | Mannheim | B1601 | 2007-03-13 | |
1219925 | 1219925 | B1601_HRB10078 | B1601_HRB10078 | Mannheim HRB 10078 | Mannheim | B1601 | 2008-01-04 | |
305559 | 305559 | B1601_HRB100782 | B1601_HRB100782 | Mannheim HRB 100782 | Mannheim | B1601 | 2006-12-19 | |
1219926 | 1219926 | B1601_HRB10079 | B1601_HRB10079 | Mannheim HRB 10079 | Mannheim | B1601 | 2014-11-24 | |
45 | 45 | B1601_HRB100799 | B1601_HRB100799 | Mannheim HRB 100799 | Mannheim | B1601 | 2007-06-04 | |
915086 | 915086 | B1601_HRB10080 | B1601_HRB10080 | Mannheim HRB 10080 | Mannheim | B1601 | 2007-02-26 | |
1219927 | 1219927 | B1601_HRB100801 | B1601_HRB100801 | Mannheim HRB 100801 | Mannheim | B1601 | 2008-01-09 | |
305560 | 305560 | B1601_HRB10081 | B1601_HRB10081 | Mannheim HRB 10081 | Mannheim | B1601 | 2008-09-16 | |
2099546 | 2099546 | B1601_HRB100819 | B1601_HRB100819 | Mannheim HRB 100819 | Mannheim | B1601 | 2010-08-09 | |
1219928 | 1219928 | B1601_HRB10082 | B1601_HRB10082 | Mannheim HRB 10082 | Mannheim | B1601 | 2008-09-09 | |
305561 | 305561 | B1601_HRB100821 | B1601_HRB100821 | Mannheim HRB 100821 | Mannheim | B1601 | 2011-06-08 | |
305562 | 305562 | B1601_HRB100823 | B1601_HRB100823 | Mannheim HRB 100823 | Mannheim | B1601 | 2008-09-23 | |
46 | 46 | B1601_HRB10083 | B1601_HRB10083 | Mannheim HRB 10083 | Mannheim | B1601 | 2011-04-14 | |
47 | 47 | B1601_HRB100831 | B1601_HRB100831 | Mannheim HRB 100831 | Mannheim | B1601 | 2008-07-17 | |
610268 | 610268 | B1601_HRB10084 | B1601_HRB10084 | Mannheim HRB 10084 | Mannheim | B1601 | 2011-08-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" );