ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by referenceNumberFirstSeen
This data as json, CSV (advanced)
Link | rowid | companyId | stdRefNo | nativeReferenceNumber | courtName | courtCode | referenceNumberFirstSeen ▼ | validTill |
---|---|---|---|---|---|---|---|---|
2084535 | 2084535 | W1215_HRB3831 | W1215_HRB3831 | Stendal HRB 3831 | Stendal | W1215 | 2002-06-05 | |
2376648 | 2376648 | W1215_HRB3197 | W1215_HRB3197 | Stendal HRB 3197 | Stendal | W1215 | 2002-06-05 | |
2376714 | 2376714 | W1215_HRB3835 | W1215_HRB3835 | Stendal HRB 3835 | Stendal | W1215 | 2002-06-05 | |
2437708 | 2437708 | W1215_HRB3537 | W1215_HRB3537 | Stendal HRB 3537 | Stendal | W1215 | 2002-06-05 | |
289017 | 289017 | W1215_HRB2374 | W1215_HRB2374 | Stendal HRB 2374 | Stendal | W1215 | 2002-06-06 | |
289358 | 289358 | W1215_HRB2676 | W1215_HRB2676 | Stendal HRB 2676 | Stendal | W1215 | 2002-06-06 | |
290022 | 290022 | W1215_HRB3841 | W1215_HRB3841 | Stendal HRB 3841 | Stendal | W1215 | 2002-06-06 | |
290023 | 290023 | W1215_HRB3844 | W1215_HRB3844 | Stendal HRB 3844 | Stendal | W1215 | 2002-06-06 | |
593609 | 593609 | W1215_HRB2306 | W1215_HRB2306 | Stendal HRB 2306 | Stendal | W1215 | 2002-06-06 | |
594227 | 594227 | W1215_HRB2815 | W1215_HRB2815 | Stendal HRB 2815 | Stendal | W1215 | 2002-06-06 | |
899407 | 899407 | W1215_HRB3839 | W1215_HRB3839 | Stendal HRB 3839 | Stendal | W1215 | 2002-06-06 | |
899408 | 899408 | W1215_HRB3840 | W1215_HRB3840 | Stendal HRB 3840 | Stendal | W1215 | 2002-06-06 | |
1498085 | 1498085 | W1215_HRB2912 | W1215_HRB2912 | Stendal HRB 2912 | Stendal | W1215 | 2002-06-06 | |
1788766 | 1788766 | W1215_HRB1139 | W1215_HRB1139 | Stendal HRB 1139 | Stendal | W1215 | 2002-06-06 | |
1789798 | 1789798 | W1215_HRB1870 | W1215_HRB1870 | Stendal HRB 1870 | Stendal | W1215 | 2002-06-06 | |
1792074 | 1792074 | W1215_HRB3126 | W1215_HRB3126 | Stendal HRB 3126 | Stendal | W1215 | 2002-06-06 | |
1792158 | 1792158 | W1215_HRB3605 | W1215_HRB3605 | Stendal HRB 3605 | Stendal | W1215 | 2002-06-06 | |
1792188 | 1792188 | W1215_HRB3837 | W1215_HRB3837 | Stendal HRB 3837 | Stendal | W1215 | 2002-06-06 | |
1792189 | 1792189 | W1215_HRB3843 | W1215_HRB3843 | Stendal HRB 3843 | Stendal | W1215 | 2002-06-06 | |
2082360 | 2082360 | W1215_HRB2021 | W1215_HRB2021 | Stendal HRB 2021 | Stendal | W1215 | 2002-06-06 | |
2084469 | 2084469 | W1215_HRB3194 | W1215_HRB3194 | Stendal HRB 3194 | Stendal | W1215 | 2002-06-06 | |
2084536 | 2084536 | W1215_HRB3836 | W1215_HRB3836 | Stendal HRB 3836 | Stendal | W1215 | 2002-06-06 | |
2085180 | 2085180 | W1215_HRB85 | W1215_HRB85 | Stendal HRB 85 | Stendal | W1215 | 2002-06-06 | |
2376715 | 2376715 | W1215_HRB3838 | W1215_HRB3838 | Stendal HRB 3838 | Stendal | W1215 | 2002-06-06 | |
2376716 | 2376716 | W1215_HRB3842 | W1215_HRB3842 | Stendal HRB 3842 | Stendal | W1215 | 2002-06-06 | |
287290 | 287290 | W1215_HRB1564 | W1215_HRB1564 | Stendal HRB 1564 | Stendal | W1215 | 2002-06-07 | |
290024 | 290024 | W1215_HRB3845 | W1215_HRB3845 | Stendal HRB 3845 | Stendal | W1215 | 2002-06-07 | |
1202379 | 1202379 | W1215_HRB2079 | W1215_HRB2079 | Stendal HRB 2079 | Stendal | W1215 | 2002-06-07 | |
1791648 | 1791648 | W1215_HRB2750 | W1215_HRB2750 | Stendal HRB 2750 | Stendal | W1215 | 2002-06-07 | |
2083341 | 2083341 | W1215_HRB2238 | W1215_HRB2238 | Stendal HRB 2238 | Stendal | W1215 | 2002-06-07 | |
290000 | 290000 | W1215_HRB3649 | W1215_HRB3649 | Stendal HRB 3649 | Stendal | W1215 | 2002-06-12 | |
593765 | 593765 | W1215_HRB2433 | W1215_HRB2433 | Stendal HRB 2433 | Stendal | W1215 | 2002-06-12 | |
899246 | 899246 | W1215_HRB3078 | W1215_HRB3078 | Stendal HRB 3078 | Stendal | W1215 | 2002-06-12 | |
1204269 | 1204269 | W1215_HRB33 | W1215_HRB33 | Stendal HRB 33 | Stendal | W1215 | 2002-06-12 | |
1495860 | 1495860 | W1215_HRB174-G1207_HRB14827FF-W1215_HRB26096 | W1215_HRB174 | Stendal HRB 174 | Stendal | W1215 | 2002-06-12 | 2014-01-14 |
1498378 | 1498378 | W1215_HRB3410 | W1215_HRB3410 | Stendal HRB 3410 | Stendal | W1215 | 2002-06-12 | |
1792138 | 1792138 | W1215_HRB3433 | W1215_HRB3433 | Stendal HRB 3433 | Stendal | W1215 | 2002-06-12 | |
2084537 | 2084537 | W1215_HRB3846 | W1215_HRB3846 | Stendal HRB 3846 | Stendal | W1215 | 2002-06-12 | |
290680 | 290680 | W1215_HRB837 | W1215_HRB837 | Stendal HRB 837 | Stendal | W1215 | 2002-06-13 | |
896558 | 896558 | W1215_HRB1482 | W1215_HRB1482 | Stendal HRB 1482 | Stendal | W1215 | 2002-06-13 | |
899347 | 899347 | W1215_HRB3300 | W1215_HRB3300 | Stendal HRB 3300 | Stendal | W1215 | 2002-06-13 | |
899409 | 899409 | W1215_HRB3850 | W1215_HRB3850 | Stendal HRB 3850 | Stendal | W1215 | 2002-06-13 | |
1203491 | 1203491 | W1215_HRB2524 | W1215_HRB2524 | Stendal HRB 2524 | Stendal | W1215 | 2002-06-13 | |
1204291 | 1204291 | W1215_HRB3484 | W1215_HRB3484 | Stendal HRB 3484 | Stendal | W1215 | 2002-06-13 | |
1204332 | 1204332 | W1215_HRB3848 | W1215_HRB3848 | Stendal HRB 3848 | Stendal | W1215 | 2002-06-13 | |
1498434 | 1498434 | W1215_HRB3847 | W1215_HRB3847 | Stendal HRB 3847 | Stendal | W1215 | 2002-06-13 | |
1498435 | 1498435 | W1215_HRB3849 | W1215_HRB3849 | Stendal HRB 3849 | Stendal | W1215 | 2002-06-13 | |
1498436 | 1498436 | W1215_HRB3852-B2609_HRB723400-R2307_HRB6989 | W1215_HRB3852 | Stendal HRB 3852 | Stendal | W1215 | 2002-06-13 | 2007-07-11 |
1792190 | 1792190 | W1215_HRB3851 | W1215_HRB3851 | Stendal HRB 3851 | Stendal | W1215 | 2002-06-13 | |
2083379 | 2083379 | W1215_HRB2267 | W1215_HRB2267 | Stendal HRB 2267 | Stendal | W1215 | 2002-06-13 | |
2085139 | 2085139 | W1215_HRB83 | W1215_HRB83 | Stendal HRB 83 | Stendal | W1215 | 2002-06-13 | |
2376392 | 2376392 | W1215_HRB2952 | W1215_HRB2952 | Stendal HRB 2952 | Stendal | W1215 | 2002-06-13 | |
2437236 | 2437236 | W1215_HRB157 | W1215_HRB157 | Stendal HRB 157 | Stendal | W1215 | 2002-06-14 | |
287006 | 287006 | W1215_HRB130 | W1215_HRB130 | Stendal HRB 130 | Stendal | W1215 | 2002-06-19 | |
290515 | 290515 | W1215_HRB72 | W1215_HRB72 | Stendal HRB 72 | Stendal | W1215 | 2002-06-19 | |
1201323 | 1201323 | W1215_HRB1412 | W1215_HRB1412 | Stendal HRB 1412 | Stendal | W1215 | 2002-06-19 | |
1791245 | 1791245 | W1215_HRB2414 | W1215_HRB2414 | Stendal HRB 2414 | Stendal | W1215 | 2002-06-19 | |
2081345 | 2081345 | W1215_HRB125 | W1215_HRB125 | Stendal HRB 125 | Stendal | W1215 | 2002-06-19 | |
2083915 | 2083915 | W1215_HRB269 | W1215_HRB269 | Stendal HRB 269 | Stendal | W1215 | 2002-06-19 | |
1792115 | 1792115 | W1215_HRB3174 | W1215_HRB3174 | Stendal HRB 3174 | Stendal | W1215 | 2002-06-20 | |
2084538 | 2084538 | W1215_HRB3853 | W1215_HRB3853 | Stendal HRB 3853 | Stendal | W1215 | 2002-06-20 | |
593607 | 593607 | W1215_HRB2305 | W1215_HRB2305 | Stendal HRB 2305 | Stendal | W1215 | 2002-06-21 | |
899410 | 899410 | W1215_HRB3854 | W1215_HRB3854 | Stendal HRB 3854 | Stendal | W1215 | 2002-06-21 | |
2376935 | 2376935 | W1215_HRB570-P2507_HRB200601 | W1215_HRB570 | Stendal HRB 570 | Stendal | W1215 | 2002-06-21 | 2007-01-10 |
287429 | 287429 | W1215_HRB1684 | W1215_HRB1684 | Stendal HRB 1684 | Stendal | W1215 | 2002-06-24 | |
1792914 | 1792914 | W1215_HRB913 | W1215_HRB913 | Stendal HRB 913 | Stendal | W1215 | 2002-06-24 | |
591823 | 591823 | W1215_HRB15 | W1215_HRB15 | Stendal HRB 15 | Stendal | W1215 | 2002-06-25 | |
899411 | 899411 | W1215_HRB3856 | W1215_HRB3856 | Stendal HRB 3856 | Stendal | W1215 | 2002-06-25 | |
899412 | 899412 | W1215_HRB3859 | W1215_HRB3859 | Stendal HRB 3859 | Stendal | W1215 | 2002-06-25 | |
1201075 | 1201075 | W1215_HRB1205 | W1215_HRB1205 | Stendal HRB 1205 | Stendal | W1215 | 2002-06-25 | |
1201448 | 1201448 | W1215_HRB1510 | W1215_HRB1510 | Stendal HRB 1510 | Stendal | W1215 | 2002-06-25 | |
1204334 | 1204334 | W1215_HRB3857 | W1215_HRB3857 | Stendal HRB 3857 | Stendal | W1215 | 2002-06-25 | |
1498293 | 1498293 | W1215_HRB3098 | W1215_HRB3098 | Stendal HRB 3098 | Stendal | W1215 | 2002-06-25 | |
1792130 | 1792130 | W1215_HRB3309 | W1215_HRB3309 | Stendal HRB 3309 | Stendal | W1215 | 2002-06-25 | |
2084539 | 2084539 | W1215_HRB3855 | W1215_HRB3855 | Stendal HRB 3855 | Stendal | W1215 | 2002-06-25 | |
2376717 | 2376717 | W1215_HRB3858 | W1215_HRB3858 | Stendal HRB 3858 | Stendal | W1215 | 2002-06-25 | |
290025 | 290025 | W1215_HRB3860 | W1215_HRB3860 | Stendal HRB 3860 | Stendal | W1215 | 2002-06-26 | |
899342 | 899342 | W1215_HRB3245-F1103_HRB126473B | W1215_HRB3245 | Stendal HRB 3245 | Stendal | W1215 | 2002-06-26 | 2010-04-30 |
899413 | 899413 | W1215_HRB3861 | W1215_HRB3861 | Stendal HRB 3861 | Stendal | W1215 | 2002-06-26 | |
2085029 | 2085029 | W1215_HRB745 | W1215_HRB745 | Stendal HRB 745 | Stendal | W1215 | 2002-06-26 | |
2376718 | 2376718 | W1215_HRB3862 | W1215_HRB3862 | Stendal HRB 3862 | Stendal | W1215 | 2002-06-26 | |
1792191 | 1792191 | W1215_HRB3863 | W1215_HRB3863 | Stendal HRB 3863 | Stendal | W1215 | 2002-06-27 | |
1791200 | 1791200 | W1215_HRB2385 | W1215_HRB2385 | Stendal HRB 2385 | Stendal | W1215 | 2002-06-28 | |
2373354 | 2373354 | W1215_HRB1140 | W1215_HRB1140 | Stendal HRB 1140 | Stendal | W1215 | 2002-06-28 | |
286937 | 286937 | W1215_HRB1243 | W1215_HRB1243 | Stendal HRB 1243 | Stendal | W1215 | 2002-07-01 | |
1204415 | 1204415 | W1215_HRB453 | W1215_HRB453 | Stendal HRB 453 | Stendal | W1215 | 2002-07-01 | |
2085183 | 2085183 | W1215_HRB852 | W1215_HRB852 | Stendal HRB 852 | Stendal | W1215 | 2002-07-01 | |
290026 | 290026 | W1215_HRB3864 | W1215_HRB3864 | Stendal HRB 3864 | Stendal | W1215 | 2002-07-03 | |
590284 | 590284 | W1215_HRB10 | W1215_HRB10 | Stendal HRB 10 | Stendal | W1215 | 2002-07-03 | |
594699 | 594699 | W1215_HRB3725 | W1215_HRB3725 | Stendal HRB 3725 | Stendal | W1215 | 2002-07-03 | |
898515 | 898515 | W1215_HRB2441 | W1215_HRB2441 | Stendal HRB 2441 | Stendal | W1215 | 2002-07-03 | |
898707 | 898707 | W1215_HRB260 | W1215_HRB260 | Stendal HRB 260 | Stendal | W1215 | 2002-07-03 | |
1204335 | 1204335 | W1215_HRB3865 | W1215_HRB3865 | Stendal HRB 3865 | Stendal | W1215 | 2002-07-03 | |
1498130 | 1498130 | W1215_HRB2951 | W1215_HRB2951 | Stendal HRB 2951 | Stendal | W1215 | 2002-07-03 | |
1499057 | 1499057 | W1215_HRB836 | W1215_HRB836 | Stendal HRB 836 | Stendal | W1215 | 2002-07-03 | |
594717 | 594717 | W1215_HRB3866 | W1215_HRB3866 | Stendal HRB 3866 | Stendal | W1215 | 2002-07-04 | |
899414 | 899414 | W1215_HRB3867 | W1215_HRB3867 | Stendal HRB 3867 | Stendal | W1215 | 2002-07-04 | |
1204336 | 1204336 | W1215_HRB3868 | W1215_HRB3868 | Stendal HRB 3868 | Stendal | W1215 | 2002-07-04 | |
1792173 | 1792173 | W1215_HRB3675 | W1215_HRB3675 | Stendal HRB 3675 | Stendal | W1215 | 2002-07-04 | |
2084540 | 2084540 | W1215_HRB3869 | W1215_HRB3869 | Stendal HRB 3869 | Stendal | W1215 | 2002-07-04 |
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" );