ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by referenceNumberFirstSeen
This data as json, CSV (advanced)
Suggested facets: referenceNumberFirstSeen (date), validTill (date)
Link | rowid | companyId | stdRefNo | nativeReferenceNumber | courtName | courtCode | referenceNumberFirstSeen ▼ | validTill |
---|---|---|---|---|---|---|---|---|
860540 | 860540 | R3306_HRB34285-R3103_HRB7714-R3201_HRB25706 | R3306_HRB34285 | Köln HRB 34285 | Köln | R3306 | 2001-06-26 | 2018-01-31 |
518125 | 518125 | R2101_HRB36359 | R2101_HRB36359 | Bielefeld HRB 36359 | Bielefeld | R2101 | 2002-03-20 | |
1719055 | 1719055 | R2101_HRB37425 | R2101_HRB37425 | Bielefeld HRB 37425 | Bielefeld | R2101 | 2002-03-20 | |
1719056 | 1719056 | R2101_HRB37426-R2108_HRB10768 | R2101_HRB37426 | Bielefeld HRB 37426 | Bielefeld | R2101 | 2002-03-20 | 2008-01-31 |
2011155 | 2011155 | R2101_HRB36360 | R2101_HRB36360 | Bielefeld HRB 36360 | Bielefeld | R2101 | 2002-03-20 | |
2011252 | 2011252 | R2101_HRB37424 | R2101_HRB37424 | Bielefeld HRB 37424 | Bielefeld | R2101 | 2002-03-20 | |
518237 | 518237 | R2101_HRB37427 | R2101_HRB37427 | Bielefeld HRB 37427 | Bielefeld | R2101 | 2002-03-21 | |
518153 | 518153 | R2101_HRB36571 | R2101_HRB36571 | Bielefeld HRB 36571 | Bielefeld | R2101 | 2002-03-22 | |
2011253 | 2011253 | R2101_HRB37428 | R2101_HRB37428 | Bielefeld HRB 37428 | Bielefeld | R2101 | 2002-03-22 | |
2303690 | 2303690 | R2101_HRB35529 | R2101_HRB35529 | Bielefeld HRB 35529 | Bielefeld | R2101 | 2002-03-22 | |
213858 | 213858 | R2101_HRB37118 | R2101_HRB37118 | Bielefeld HRB 37118 | Bielefeld | R2101 | 2002-03-25 | |
822787 | 822787 | R2101_HRB36920 | R2101_HRB36920 | Bielefeld HRB 36920 | Bielefeld | R2101 | 2002-03-25 | |
1127945 | 1127945 | R2101_HRB34259 | R2101_HRB34259 | Bielefeld HRB 34259 | Bielefeld | R2101 | 2002-03-25 | |
1128110 | 1128110 | R2101_HRB36507 | R2101_HRB36507 | Bielefeld HRB 36507 | Bielefeld | R2101 | 2002-03-25 | |
1718949 | 1718949 | R2101_HRB36100 | R2101_HRB36100 | Bielefeld HRB 36100 | Bielefeld | R2101 | 2002-03-25 | |
1718950 | 1718950 | R2101_HRB36111 | R2101_HRB36111 | Bielefeld HRB 36111 | Bielefeld | R2101 | 2002-03-25 | |
2010997 | 2010997 | R2101_HRB34197 | R2101_HRB34197 | Bielefeld HRB 34197 | Bielefeld | R2101 | 2002-03-25 | |
2303619 | 2303619 | R2101_HRB34356 | R2101_HRB34356 | Bielefeld HRB 34356 | Bielefeld | R2101 | 2002-03-25 | |
213792 | 213792 | R2101_HRB36350-R2103_HRB11853 | R2101_HRB36350 | Bielefeld HRB 36350 | Bielefeld | R2101 | 2002-03-26 | 2020-07-02 |
213888 | 213888 | R2101_HRB37429 | R2101_HRB37429 | Bielefeld HRB 37429 | Bielefeld | R2101 | 2002-03-26 | |
518163 | 518163 | R2101_HRB36662 | R2101_HRB36662 | Bielefeld HRB 36662 | Bielefeld | R2101 | 2002-03-26 | |
822718 | 822718 | R2101_HRB35942 | R2101_HRB35942 | Bielefeld HRB 35942 | Bielefeld | R2101 | 2002-03-26 | |
822760 | 822760 | R2101_HRB36482 | R2101_HRB36482 | Bielefeld HRB 36482 | Bielefeld | R2101 | 2002-03-26 | |
1425379 | 1425379 | R2101_HRB35232 | R2101_HRB35232 | Bielefeld HRB 35232 | Bielefeld | R2101 | 2002-03-26 | |
1425539 | 1425539 | R2101_HRB37271-M1201_HRB54260 | R2101_HRB37271 | Bielefeld HRB 37271 | Bielefeld | R2101 | 2002-03-26 | 2009-08-25 |
1425546 | 1425546 | R2101_HRB37315 | R2101_HRB37315 | Bielefeld HRB 37315 | Bielefeld | R2101 | 2002-03-26 | |
1718937 | 1718937 | R2101_HRB35964 | R2101_HRB35964 | Bielefeld HRB 35964 | Bielefeld | R2101 | 2002-03-26 | |
1718957 | 1718957 | R2101_HRB36183 | R2101_HRB36183 | Bielefeld HRB 36183 | Bielefeld | R2101 | 2002-03-26 | |
2011167 | 2011167 | R2101_HRB36474 | R2101_HRB36474 | Bielefeld HRB 36474 | Bielefeld | R2101 | 2002-03-26 | |
2303831 | 2303831 | R2101_HRB37351 | R2101_HRB37351 | Bielefeld HRB 37351 | Bielefeld | R2101 | 2002-03-26 | |
2425610 | 2425610 | R2101_HRB35983 | R2101_HRB35983 | Bielefeld HRB 35983 | Bielefeld | R2101 | 2002-03-26 | |
2425619 | 2425619 | R2101_HRB36872 | R2101_HRB36872 | Bielefeld HRB 36872 | Bielefeld | R2101 | 2002-03-26 | |
213757 | 213757 | R2101_HRB35826 | R2101_HRB35826 | Bielefeld HRB 35826 | Bielefeld | R2101 | 2002-03-27 | |
518098 | 518098 | R2101_HRB36030 | R2101_HRB36030 | Bielefeld HRB 36030 | Bielefeld | R2101 | 2002-03-27 | |
822663 | 822663 | R2101_HRB34883 | R2101_HRB34883 | Bielefeld HRB 34883 | Bielefeld | R2101 | 2002-03-27 | |
822738 | 822738 | R2101_HRB36156 | R2101_HRB36156 | Bielefeld HRB 36156 | Bielefeld | R2101 | 2002-03-27 | |
822823 | 822823 | R2101_HRB37250 | R2101_HRB37250 | Bielefeld HRB 37250 | Bielefeld | R2101 | 2002-03-27 | |
1127948 | 1127948 | R2101_HRB34317-U1104_HRB29016 | R2101_HRB34317 | Bielefeld HRB 34317 | Bielefeld | R2101 | 2002-03-27 | 2010-06-18 |
1127966 | 1127966 | R2101_HRB34579 | R2101_HRB34579 | Bielefeld HRB 34579 | Bielefeld | R2101 | 2002-03-27 | |
1425349 | 1425349 | R2101_HRB34596 | R2101_HRB34596 | Bielefeld HRB 34596 | Bielefeld | R2101 | 2002-03-27 | |
1425350 | 1425350 | R2101_HRB34666 | R2101_HRB34666 | Bielefeld HRB 34666 | Bielefeld | R2101 | 2002-03-27 | |
1425547 | 1425547 | R2101_HRB37319 | R2101_HRB37319 | Bielefeld HRB 37319 | Bielefeld | R2101 | 2002-03-27 | |
1718907 | 1718907 | R2101_HRB35479 | R2101_HRB35479 | Bielefeld HRB 35479 | Bielefeld | R2101 | 2002-03-27 | |
2011030 | 2011030 | R2101_HRB34809 | R2101_HRB34809 | Bielefeld HRB 34809 | Bielefeld | R2101 | 2002-03-27 | |
2011205 | 2011205 | R2101_HRB36833 | R2101_HRB36833 | Bielefeld HRB 36833 | Bielefeld | R2101 | 2002-03-27 | |
2303638 | 2303638 | R2101_HRB34677 | R2101_HRB34677 | Bielefeld HRB 34677 | Bielefeld | R2101 | 2002-03-27 | |
2303688 | 2303688 | R2101_HRB35483 | R2101_HRB35483 | Bielefeld HRB 35483 | Bielefeld | R2101 | 2002-03-27 | |
2303830 | 2303830 | R2101_HRB37338 | R2101_HRB37338 | Bielefeld HRB 37338 | Bielefeld | R2101 | 2002-03-27 | |
822722 | 822722 | R2101_HRB35957 | R2101_HRB35957 | Bielefeld HRB 35957 | Bielefeld | R2101 | 2002-03-28 | |
822840 | 822840 | R2101_HRB37430 | R2101_HRB37430 | Bielefeld HRB 37430 | Bielefeld | R2101 | 2002-03-28 | |
1425427 | 1425427 | R2101_HRB35908-P2305_HRB201384 | R2101_HRB35908 | Bielefeld HRB 35908 | Bielefeld | R2101 | 2002-03-28 | 2007-01-26 |
1718970 | 1718970 | R2101_HRB36446 | R2101_HRB36446 | Bielefeld HRB 36446 | Bielefeld | R2101 | 2002-03-28 | |
1719007 | 1719007 | R2101_HRB36877 | R2101_HRB36877 | Bielefeld HRB 36877 | Bielefeld | R2101 | 2002-03-28 | |
2011182 | 2011182 | R2101_HRB36619 | R2101_HRB36619 | Bielefeld HRB 36619 | Bielefeld | R2101 | 2002-03-28 | |
2303820 | 2303820 | R2101_HRB37195 | R2101_HRB37195 | Bielefeld HRB 37195 | Bielefeld | R2101 | 2002-03-28 | |
1128152 | 1128152 | R2101_HRB36988 | R2101_HRB36988 | Bielefeld HRB 36988 | Bielefeld | R2101 | 2002-04-02 | |
1425529 | 1425529 | R2101_HRB37166 | R2101_HRB37166 | Bielefeld HRB 37166 | Bielefeld | R2101 | 2002-04-02 | |
1425532 | 1425532 | R2101_HRB37200 | R2101_HRB37200 | Bielefeld HRB 37200 | Bielefeld | R2101 | 2002-04-02 | |
1425556 | 1425556 | R2101_HRB37431 | R2101_HRB37431 | Bielefeld HRB 37431 | Bielefeld | R2101 | 2002-04-02 | |
1719058 | 1719058 | R2101_HRB37432 | R2101_HRB37432 | Bielefeld HRB 37432 | Bielefeld | R2101 | 2002-04-02 | |
2011245 | 2011245 | R2101_HRB37327 | R2101_HRB37327 | Bielefeld HRB 37327 | Bielefeld | R2101 | 2002-04-02 | |
213548 | 213548 | R2101_HRB31099 | R2101_HRB31099 | Bielefeld HRB 31099 | Bielefeld | R2101 | 2002-04-03 | |
213628 | 213628 | R2101_HRB33086 | R2101_HRB33086 | Bielefeld HRB 33086 | Bielefeld | R2101 | 2002-04-03 | |
518176 | 518176 | R2101_HRB36779 | R2101_HRB36779 | Bielefeld HRB 36779 | Bielefeld | R2101 | 2002-04-03 | |
822511 | 822511 | R2101_HRB31379 | R2101_HRB31379 | Bielefeld HRB 31379 | Bielefeld | R2101 | 2002-04-03 | |
1127787 | 1127787 | R2101_HRB31078 | R2101_HRB31078 | Bielefeld HRB 31078 | Bielefeld | R2101 | 2002-04-03 | |
1128061 | 1128061 | R2101_HRB35857 | R2101_HRB35857 | Bielefeld HRB 35857 | Bielefeld | R2101 | 2002-04-03 | |
1425431 | 1425431 | R2101_HRB35937 | R2101_HRB35937 | Bielefeld HRB 35937 | Bielefeld | R2101 | 2002-04-03 | |
1425554 | 1425554 | R2101_HRB37403 | R2101_HRB37403 | Bielefeld HRB 37403 | Bielefeld | R2101 | 2002-04-03 | |
1718997 | 1718997 | R2101_HRB36793 | R2101_HRB36793 | Bielefeld HRB 36793 | Bielefeld | R2101 | 2002-04-03 | |
1719002 | 1719002 | R2101_HRB36843 | R2101_HRB36843 | Bielefeld HRB 36843 | Bielefeld | R2101 | 2002-04-03 | |
213588 | 213588 | R2101_HRB32148 | R2101_HRB32148 | Bielefeld HRB 32148 | Bielefeld | R2101 | 2002-04-04 | |
518031 | 518031 | R2101_HRB35037 | R2101_HRB35037 | Bielefeld HRB 35037 | Bielefeld | R2101 | 2002-04-04 | |
518238 | 518238 | R2101_HRB37433 | R2101_HRB37433 | Bielefeld HRB 37433 | Bielefeld | R2101 | 2002-04-04 | |
822657 | 822657 | R2101_HRB34829-X1321_HRB8613PI-K1101_HRB120286 | R2101_HRB34829 | Bielefeld HRB 34829 | Bielefeld | R2101 | 2002-04-04 | 2010-04-19 |
822841 | 822841 | R2101_HRB37434 | R2101_HRB37434 | Bielefeld HRB 37434 | Bielefeld | R2101 | 2002-04-04 | |
1128196 | 1128196 | R2101_HRB37435 | R2101_HRB37435 | Bielefeld HRB 37435 | Bielefeld | R2101 | 2002-04-04 | |
1718780 | 1718780 | R2101_HRB33604-F1103_HRB114790B | R2101_HRB33604 | Bielefeld HRB 33604 | Bielefeld | R2101 | 2002-04-04 | 2008-08-05 |
2010975 | 2010975 | R2101_HRB33746 | R2101_HRB33746 | Bielefeld HRB 33746 | Bielefeld | R2101 | 2002-04-04 | |
2303580 | 2303580 | R2101_HRB33758 | R2101_HRB33758 | Bielefeld HRB 33758 | Bielefeld | R2101 | 2002-04-04 | |
2303583 | 2303583 | R2101_HRB33814 | R2101_HRB33814 | Bielefeld HRB 33814 | Bielefeld | R2101 | 2002-04-04 | |
2303733 | 2303733 | R2101_HRB35932-K1101_HRB144042 | R2101_HRB35932 | Bielefeld HRB 35932 | Bielefeld | R2101 | 2002-04-04 | 2016-12-02 |
2303834 | 2303834 | R2101_HRB37410 | R2101_HRB37410 | Bielefeld HRB 37410 | Bielefeld | R2101 | 2002-04-04 | |
2304720 | 2304720 | R2101_HRB7787 | R2101_HRB7787 | Bielefeld HRB 7787 | Bielefeld | R2101 | 2002-04-04 | |
594440 | 594440 | W1215_HRB3 | W1215_HRB3 | Stendal HRB 3 | Stendal | W1215 | 2002-04-10 | |
895071 | 895071 | W1215_HRB1 | W1215_HRB1 | Stendal HRB 1 | Stendal | W1215 | 2002-04-10 | |
1204467 | 1204467 | W1215_HRB4899 | W1215_HRB4899 | Stendal HRB 4899 | Stendal | W1215 | 2002-04-10 | |
1496202 | 1496202 | W1215_HRB2 | W1215_HRB2 | Stendal HRB 2 | Stendal | W1215 | 2002-04-10 | |
2084494 | 2084494 | W1215_HRB35 | W1215_HRB35 | Stendal HRB 35 | Stendal | W1215 | 2002-04-15 | |
290015 | 290015 | W1215_HRB3792 | W1215_HRB3792 | Stendal HRB 3792 | Stendal | W1215 | 2002-04-18 | |
1204327 | 1204327 | W1215_HRB3791 | W1215_HRB3791 | Stendal HRB 3791 | Stendal | W1215 | 2002-04-18 | |
1204328 | 1204328 | W1215_HRB3793 | W1215_HRB3793 | Stendal HRB 3793 | Stendal | W1215 | 2002-04-18 | |
495587 | 495587 | R1101_HRB42366 | R1101_HRB42366 | Düsseldorf HRB 42366 | Düsseldorf | R1101 | 2002-04-22 | |
289889 | 289889 | W1215_HRB3118 | W1215_HRB3118 | Stendal HRB 3118 | Stendal | W1215 | 2002-05-13 | |
289958 | 289958 | W1215_HRB3192 | W1215_HRB3192 | Stendal HRB 3192 | Stendal | W1215 | 2002-05-13 | |
899417 | 899417 | W1215_HRB392 | W1215_HRB392 | Stendal HRB 392 | Stendal | W1215 | 2002-05-13 | |
289529 | 289529 | W1215_HRB2801 | W1215_HRB2801 | Stendal HRB 2801 | Stendal | W1215 | 2002-05-14 | |
289964 | 289964 | W1215_HRB3266 | W1215_HRB3266 | Stendal HRB 3266 | Stendal | W1215 | 2002-05-14 | |
594681 | 594681 | W1215_HRB3475 | W1215_HRB3475 | Stendal HRB 3475 | Stendal | W1215 | 2002-05-14 | |
1792175 | 1792175 | W1215_HRB3777 | W1215_HRB3777 | Stendal HRB 3777 | Stendal | W1215 | 2002-05-14 |
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" );