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 |
---|---|---|---|---|---|---|---|---|
2083541 | 2083541 | W1215_HRB239 | W1215_HRB239 | Stendal HRB 239 | Stendal | W1215 | 2002-05-14 | |
2084470 | 2084470 | W1215_HRB3208 | W1215_HRB3208 | Stendal HRB 3208 | Stendal | W1215 | 2002-05-14 | |
2374781 | 2374781 | W1215_HRB2083 | W1215_HRB2083 | Stendal HRB 2083 | Stendal | W1215 | 2002-05-14 | |
594709 | 594709 | W1215_HRB3794 | W1215_HRB3794 | Stendal HRB 3794 | Stendal | W1215 | 2002-05-15 | |
899402 | 899402 | W1215_HRB3796 | W1215_HRB3796 | Stendal HRB 3796 | Stendal | W1215 | 2002-05-15 | |
1204329 | 1204329 | W1215_HRB3797 | W1215_HRB3797 | Stendal HRB 3797 | Stendal | W1215 | 2002-05-15 | |
2084529 | 2084529 | W1215_HRB3795 | W1215_HRB3795 | Stendal HRB 3795 | Stendal | W1215 | 2002-05-15 | |
287766 | 287766 | W1215_HRB1959 | W1215_HRB1959 | Stendal HRB 1959 | Stendal | W1215 | 2002-05-16 | |
591676 | 591676 | W1215_HRB1392 | W1215_HRB1392 | Stendal HRB 1392 | Stendal | W1215 | 2002-05-16 | |
1203179 | 1203179 | W1215_HRB2298 | W1215_HRB2298 | Stendal HRB 2298 | Stendal | W1215 | 2002-05-16 | |
1791198 | 1791198 | W1215_HRB2382 | W1215_HRB2382 | Stendal HRB 2382 | Stendal | W1215 | 2002-05-16 | |
1792178 | 1792178 | W1215_HRB3798-W1215_HRB15031 | W1215_HRB3798 | Stendal HRB 3798 | Stendal | W1215 | 2002-05-16 | 2006-04-03 |
1792593 | 1792593 | W1215_HRB684 | W1215_HRB684 | Stendal HRB 684 | Stendal | W1215 | 2002-05-16 | |
286910 | 286910 | W1215_HRB1219 | W1215_HRB1219 | Stendal HRB 1219 | Stendal | W1215 | 2002-05-17 | |
592450 | 592450 | W1215_HRB1962 | W1215_HRB1962 | Stendal HRB 1962 | Stendal | W1215 | 2002-05-17 | |
593623 | 593623 | W1215_HRB2317 | W1215_HRB2317 | Stendal HRB 2317 | Stendal | W1215 | 2002-05-17 | |
1204254 | 1204254 | W1215_HRB3177 | W1215_HRB3177 | Stendal HRB 3177 | Stendal | W1215 | 2002-05-17 | |
1204288 | 1204288 | W1215_HRB3463 | W1215_HRB3463 | Stendal HRB 3463 | Stendal | W1215 | 2002-05-17 | |
1498666 | 1498666 | W1215_HRB56 | W1215_HRB56 | Stendal HRB 56 | Stendal | W1215 | 2002-05-17 | |
2084508 | 2084508 | W1215_HRB3591 | W1215_HRB3591 | Stendal HRB 3591 | Stendal | W1215 | 2002-05-17 | |
2437713 | 2437713 | W1215_HRB3799 | W1215_HRB3799 | Stendal HRB 3799 | Stendal | W1215 | 2002-05-17 | |
287307 | 287307 | W1215_HRB1574 | W1215_HRB1574 | Stendal HRB 1574 | Stendal | W1215 | 2002-05-23 | |
290012 | 290012 | W1215_HRB3768 | W1215_HRB3768 | Stendal HRB 3768 | Stendal | W1215 | 2002-05-23 | |
591933 | 591933 | W1215_HRB1588 | W1215_HRB1588 | Stendal HRB 1588 | Stendal | W1215 | 2002-05-23 | |
594685 | 594685 | W1215_HRB3505 | W1215_HRB3505 | Stendal HRB 3505 | Stendal | W1215 | 2002-05-23 | |
594705 | 594705 | W1215_HRB3747 | W1215_HRB3747 | Stendal HRB 3747 | Stendal | W1215 | 2002-05-23 | |
594710 | 594710 | W1215_HRB3800 | W1215_HRB3800 | Stendal HRB 3800 | Stendal | W1215 | 2002-05-23 | |
896368 | 896368 | W1215_HRB1328 | W1215_HRB1328 | Stendal HRB 1328 | Stendal | W1215 | 2002-05-23 | |
899366 | 899366 | W1215_HRB3448 | W1215_HRB3448 | Stendal HRB 3448 | Stendal | W1215 | 2002-05-23 | |
1204314 | 1204314 | W1215_HRB3731 | W1215_HRB3731 | Stendal HRB 3731 | Stendal | W1215 | 2002-05-23 | |
1204631 | 1204631 | W1215_HRB615 | W1215_HRB615 | Stendal HRB 615 | Stendal | W1215 | 2002-05-23 | |
1498361 | 1498361 | W1215_HRB3211 | W1215_HRB3211 | Stendal HRB 3211 | Stendal | W1215 | 2002-05-23 | |
1498390 | 1498390 | W1215_HRB3493 | W1215_HRB3493 | Stendal HRB 3493 | Stendal | W1215 | 2002-05-23 | |
1498421 | 1498421 | W1215_HRB3734 | W1215_HRB3734 | Stendal HRB 3734 | Stendal | W1215 | 2002-05-23 | |
1498867 | 1498867 | W1215_HRB70 | W1215_HRB70 | Stendal HRB 70 | Stendal | W1215 | 2002-05-23 | |
1787975 | 1787975 | W1215_HRB1017 | W1215_HRB1017 | Stendal HRB 1017 | Stendal | W1215 | 2002-05-23 | |
1789784 | 1789784 | W1215_HRB1858 | W1215_HRB1858 | Stendal HRB 1858 | Stendal | W1215 | 2002-05-23 | |
1792174 | 1792174 | W1215_HRB3706 | W1215_HRB3706 | Stendal HRB 3706 | Stendal | W1215 | 2002-05-23 | |
2080617 | 2080617 | W1215_HRB1086 | W1215_HRB1086 | Stendal HRB 1086 | Stendal | W1215 | 2002-05-23 | |
2082220 | 2082220 | W1215_HRB1975 | W1215_HRB1975 | Stendal HRB 1975 | Stendal | W1215 | 2002-05-23 | |
2375641 | 2375641 | W1215_HRB2313 | W1215_HRB2313 | Stendal HRB 2313 | Stendal | W1215 | 2002-05-23 | |
2376599 | 2376599 | W1215_HRB312 | W1215_HRB312 | Stendal HRB 312 | Stendal | W1215 | 2002-05-23 | |
289933 | 289933 | W1215_HRB3153 | W1215_HRB3153 | Stendal HRB 3153 | Stendal | W1215 | 2002-05-24 | |
1792128 | 1792128 | W1215_HRB3284 | W1215_HRB3284 | Stendal HRB 3284 | Stendal | W1215 | 2002-05-24 | |
2083668 | 2083668 | W1215_HRB2516 | W1215_HRB2516 | Stendal HRB 2516 | Stendal | W1215 | 2002-05-24 | |
2376710 | 2376710 | W1215_HRB3801 | W1215_HRB3801 | Stendal HRB 3801 | Stendal | W1215 | 2002-05-24 | |
2376959 | 2376959 | W1215_HRB585 | W1215_HRB585 | Stendal HRB 585 | Stendal | W1215 | 2002-05-24 | |
594692 | 594692 | W1215_HRB3571 | W1215_HRB3571 | Stendal HRB 3571 | Stendal | W1215 | 2002-05-27 | |
899339 | 899339 | W1215_HRB3185 | W1215_HRB3185 | Stendal HRB 3185 | Stendal | W1215 | 2002-05-27 | |
899404 | 899404 | W1215_HRB3803 | W1215_HRB3803 | Stendal HRB 3803 | Stendal | W1215 | 2002-05-27 | |
1498104 | 1498104 | W1215_HRB2928 | W1215_HRB2928 | Stendal HRB 2928 | Stendal | W1215 | 2002-05-27 | |
1498360 | 1498360 | W1215_HRB32 | W1215_HRB32 | Stendal HRB 32 | Stendal | W1215 | 2002-05-27 | |
1498427 | 1498427 | W1215_HRB3802 | W1215_HRB3802 | Stendal HRB 3802 | Stendal | W1215 | 2002-05-27 | |
1498428 | 1498428 | W1215_HRB3804 | W1215_HRB3804 | Stendal HRB 3804 | Stendal | W1215 | 2002-05-27 | |
1498483 | 1498483 | W1215_HRB423 | W1215_HRB423 | Stendal HRB 423 | Stendal | W1215 | 2002-05-27 | |
1791986 | 1791986 | W1215_HRB304 | W1215_HRB304 | Stendal HRB 304 | Stendal | W1215 | 2002-05-27 | |
1792180 | 1792180 | W1215_HRB3805-R1402_HRB12473-P1103_HRB203368-R1402_HRB14231-R2201_HRB15030 | W1215_HRB3805 | Stendal HRB 3805 | Stendal | W1215 | 2002-05-27 | 2009-06-05 |
2082174 | 2082174 | W1215_HRB1943 | W1215_HRB1943 | Stendal HRB 1943 | Stendal | W1215 | 2002-05-27 | |
289548 | 289548 | W1215_HRB2820 | W1215_HRB2820 | Stendal HRB 2820 | Stendal | W1215 | 2002-05-28 | |
289772 | 289772 | W1215_HRB3009-P3210_HRB202291 | W1215_HRB3009 | Stendal HRB 3009 | Stendal | W1215 | 2002-05-28 | 2008-05-28 |
290016 | 290016 | W1215_HRB3806-M1607_HRB14398 | W1215_HRB3806 | Stendal HRB 3806 | Stendal | W1215 | 2002-05-28 | 2007-10-30 |
290018 | 290018 | W1215_HRB3811 | W1215_HRB3811 | Stendal HRB 3811 | Stendal | W1215 | 2002-05-28 | |
594711 | 594711 | W1215_HRB3808 | W1215_HRB3808 | Stendal HRB 3808 | Stendal | W1215 | 2002-05-28 | |
594712 | 594712 | W1215_HRB3809 | W1215_HRB3809 | Stendal HRB 3809 | Stendal | W1215 | 2002-05-28 | |
594714 | 594714 | W1215_HRB3812 | W1215_HRB3812 | Stendal HRB 3812 | Stendal | W1215 | 2002-05-28 | |
899293 | 899293 | W1215_HRB3129 | W1215_HRB3129 | Stendal HRB 3129 | Stendal | W1215 | 2002-05-28 | |
899405 | 899405 | W1215_HRB3819 | W1215_HRB3819 | Stendal HRB 3819 | Stendal | W1215 | 2002-05-28 | |
899406 | 899406 | W1215_HRB3821 | W1215_HRB3821 | Stendal HRB 3821 | Stendal | W1215 | 2002-05-28 | |
1498429 | 1498429 | W1215_HRB3810 | W1215_HRB3810 | Stendal HRB 3810 | Stendal | W1215 | 2002-05-28 | |
1498430 | 1498430 | W1215_HRB3814 | W1215_HRB3814 | Stendal HRB 3814 | Stendal | W1215 | 2002-05-28 | |
1498431 | 1498431 | W1215_HRB3816 | W1215_HRB3816 | Stendal HRB 3816 | Stendal | W1215 | 2002-05-28 | |
1498432 | 1498432 | W1215_HRB3822 | W1215_HRB3822 | Stendal HRB 3822 | Stendal | W1215 | 2002-05-28 | |
1792119 | 1792119 | W1215_HRB3212 | W1215_HRB3212 | Stendal HRB 3212 | Stendal | W1215 | 2002-05-28 | |
1792185 | 1792185 | W1215_HRB3818 | W1215_HRB3818 | Stendal HRB 3818 | Stendal | W1215 | 2002-05-28 | |
1792186 | 1792186 | W1215_HRB3820 | W1215_HRB3820 | Stendal HRB 3820 | Stendal | W1215 | 2002-05-28 | |
2084530 | 2084530 | W1215_HRB3813 | W1215_HRB3813 | Stendal HRB 3813 | Stendal | W1215 | 2002-05-28 | |
2084531 | 2084531 | W1215_HRB3815 | W1215_HRB3815 | Stendal HRB 3815 | Stendal | W1215 | 2002-05-28 | |
2084532 | 2084532 | W1215_HRB3817 | W1215_HRB3817 | Stendal HRB 3817 | Stendal | W1215 | 2002-05-28 | |
2376705 | 2376705 | W1215_HRB3757 | W1215_HRB3757 | Stendal HRB 3757 | Stendal | W1215 | 2002-05-28 | |
2376711 | 2376711 | W1215_HRB3807-F1103_HRB116599B | W1215_HRB3807 | Stendal HRB 3807 | Stendal | W1215 | 2002-05-28 | 2008-12-05 |
290019 | 290019 | W1215_HRB3825 | W1215_HRB3825 | Stendal HRB 3825 | Stendal | W1215 | 2002-06-04 | |
594715 | 594715 | W1215_HRB3828 | W1215_HRB3828 | Stendal HRB 3828 | Stendal | W1215 | 2002-06-04 | |
594716 | 594716 | W1215_HRB3829 | W1215_HRB3829 | Stendal HRB 3829 | Stendal | W1215 | 2002-06-04 | |
1204330 | 1204330 | W1215_HRB3824 | W1215_HRB3824 | Stendal HRB 3824 | Stendal | W1215 | 2002-06-04 | |
1792187 | 1792187 | W1215_HRB3823 | W1215_HRB3823 | Stendal HRB 3823 | Stendal | W1215 | 2002-06-04 | |
2084534 | 2084534 | W1215_HRB3826 | W1215_HRB3826 | Stendal HRB 3826 | Stendal | W1215 | 2002-06-04 | |
2376713 | 2376713 | W1215_HRB3827 | W1215_HRB3827 | Stendal HRB 3827 | Stendal | W1215 | 2002-06-04 | |
287071 | 287071 | W1215_HRB1374 | W1215_HRB1374 | Stendal HRB 1374 | Stendal | W1215 | 2002-06-05 | |
290020 | 290020 | W1215_HRB3833 | W1215_HRB3833 | Stendal HRB 3833 | Stendal | W1215 | 2002-06-05 | |
290021 | 290021 | W1215_HRB3834 | W1215_HRB3834 | Stendal HRB 3834 | Stendal | W1215 | 2002-06-05 | |
594486 | 594486 | W1215_HRB3044 | W1215_HRB3044 | Stendal HRB 3044 | Stendal | W1215 | 2002-06-05 | |
594652 | 594652 | W1215_HRB3223 | W1215_HRB3223 | Stendal HRB 3223 | Stendal | W1215 | 2002-06-05 | |
1204302 | 1204302 | W1215_HRB3608 | W1215_HRB3608 | Stendal HRB 3608 | Stendal | W1215 | 2002-06-05 | |
1204331 | 1204331 | W1215_HRB3830 | W1215_HRB3830 | Stendal HRB 3830 | Stendal | W1215 | 2002-06-05 | |
1498433 | 1498433 | W1215_HRB3832 | W1215_HRB3832 | Stendal HRB 3832 | Stendal | W1215 | 2002-06-05 | |
1498894 | 1498894 | W1215_HRB717 | W1215_HRB717 | Stendal HRB 717 | Stendal | W1215 | 2002-06-05 | |
1790777 | 1790777 | W1215_HRB2144 | W1215_HRB2144 | Stendal HRB 2144 | Stendal | W1215 | 2002-06-05 | |
1791339 | 1791339 | W1215_HRB2488 | W1215_HRB2488 | Stendal HRB 2488 | Stendal | W1215 | 2002-06-05 | |
1792804 | 1792804 | W1215_HRB830 | W1215_HRB830 | Stendal HRB 830 | Stendal | W1215 | 2002-06-05 | |
2081849 | 2081849 | W1215_HRB1675 | W1215_HRB1675 | Stendal HRB 1675 | Stendal | W1215 | 2002-06-05 |
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" );