ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by courtCode descending
This data as json, CSV (advanced)
Suggested facets: referenceNumberFirstSeen (date)
These facets timed out: validTill
Link | rowid | companyId | stdRefNo | nativeReferenceNumber | courtName | courtCode ▲ | referenceNumberFirstSeen | validTill |
---|---|---|---|---|---|---|---|---|
3420 | 3420 | B1601_HRB701511-Y1206_HRB518019 | Y1206_HRB518019 | Jena HRB 518019 | Jena | Y1206 | 2021-03-18 | |
4649 | 4649 | B1601_HRB710837-Y1206_HRB506598 | Y1206_HRB506598 | Jena HRB 506598 | Jena | Y1206 | 2011-04-06 | |
8768 | 8768 | B2602_HRB6255-Y1206_HRB210460 | Y1206_HRB210460 | Jena HRB 210460 | Jena | Y1206 | 2006-06-12 | |
14768 | 14768 | B2609_HRB722828-Y1206_HRB504490-F1103_HRB188738B | Y1206_HRB504490 | Jena HRB 504490 | Jena | Y1206 | 2009-09-17 | 2017-08-03 |
17037 | 17037 | B2609_HRB740712-Y1206_HRB107672 | Y1206_HRB107672 | Jena HRB 107672 | Jena | Y1206 | 2012-04-16 | |
17534 | 17534 | B2609_HRB744480-Y1206_HRB519130 | Y1206_HRB519130 | Jena HRB 519130 | Jena | Y1206 | 2022-01-17 | |
17568 | 17568 | B2609_HRB744719-Y1206_HRB513200 | Y1206_HRB513200 | Jena HRB 513200 | Jena | Y1206 | 2017-02-20 | |
17667 | 17667 | B2609_HRB745391-Y1206_HRB509356-B2609_HRB750636 | Y1206_HRB509356 | Jena HRB 509356 | Jena | Y1206 | 2013-07-31 | 2014-11-10 |
19222 | 19222 | B2609_HRB758280-Y1206_HRB515456 | Y1206_HRB515456 | Jena HRB 515456 | Jena | Y1206 | 2019-02-14 | |
19377 | 19377 | B2609_HRB759687-Y1206_HRB519170 | Y1206_HRB519170 | Jena HRB 519170 | Jena | Y1206 | 2022-01-27 | |
22561 | 22561 | B2609_HRB9577-Y1206_HRB513306-G1103_HRB13289CB | Y1206_HRB513306 | Jena HRB 513306 | Jena | Y1206 | 2017-03-21 | 2017-11-08 |
25692 | 25692 | B2805_HRB728888-Y1206_HRB513548 | Y1206_HRB513548 | Jena HRB 513548 | Jena | Y1206 | 2017-06-27 | |
25793 | 25793 | B2805_HRB729799-M1502_HRB95169-Y1206_HRB511715 | Y1206_HRB511715 | Jena HRB 511715 | Jena | Y1206 | 2015-11-13 | |
26066 | 26066 | B2805_HRB732177-Y1206_HRB512083 | Y1206_HRB512083 | Jena HRB 512083 | Jena | Y1206 | 2016-03-03 | |
26174 | 26174 | B2805_HRB733047-Y1206_HRB512757 | Y1206_HRB512757 | Jena HRB 512757 | Jena | Y1206 | 2016-10-19 | |
28546 | 28546 | B8536_HRB480180-Y1206_HRB516582 | Y1206_HRB516582 | Jena HRB 516582 | Jena | Y1206 | 2020-02-03 | |
28755 | 28755 | B8536_HRB542167-Y1206_HRB502170 | Y1206_HRB502170 | Jena HRB 502170 | Jena | Y1206 | 2007-12-27 | |
30398 | 30398 | B8536_HRB707501-Y1206_HRB509993 | Y1206_HRB509993 | Jena HRB 509993 | Jena | Y1206 | 2014-03-11 | |
31347 | 31347 | B8536_HRB715505-Y1206_HRB516764 | Y1206_HRB516764 | Jena HRB 516764 | Jena | Y1206 | 2020-03-24 | |
34265 | 34265 | D2102_HRB25282-Y1206_HRB506019 | Y1206_HRB506019 | Jena HRB 506019 | Jena | Y1206 | 2010-10-29 | |
36228 | 36228 | D2201_HRB3404-Y1206_HRB203098-D2803_HRB8947 | Y1206_HRB203098 | Jena HRB 203098 | Jena | Y1206 | 2010-01-29 | 2013-10-14 |
39569 | 39569 | D2505_HRB12777-Y1206_HRB500919 | Y1206_HRB500919 | Jena HRB 500919 | Jena | Y1206 | 2006-12-01 | |
39721 | 39721 | D2505_HRB13744-Y1206_HRB506583 | Y1206_HRB506583 | Jena HRB 506583 | Jena | Y1206 | 2011-03-30 | |
41020 | 41020 | D2601_HRB105196-Y1206_HRB514633 | Y1206_HRB514633 | Jena HRB 514633 | Jena | Y1206 | 2018-06-11 | |
45143 | 45143 | D2601_HRB152520-B2609_HRB720378-Y1206_HRB501907 | Y1206_HRB501907 | Jena HRB 501907 | Jena | Y1206 | 2007-09-28 | 2007-10-08 |
45916 | 45916 | D2601_HRB157819-Y1206_HRB501018 | Y1206_HRB501018 | Jena HRB 501018 | Jena | Y1206 | 2013-12-06 | |
46536 | 46536 | D2601_HRB161720-Y1206_HRB500402 | Y1206_HRB500402 | Jena HRB 500402 | Jena | Y1206 | 2006-06-26 | |
46911 | 46911 | D2601_HRB164126-Y1206_HRB200736 | Y1206_HRB200736 | Jena HRB 200736 | Jena | Y1206 | 2006-12-05 | |
47398 | 47398 | D2601_HRB166989-Y1206_HRB502159 | Y1206_HRB502159 | Jena HRB 502159 | Jena | Y1206 | 2007-12-20 | |
47795 | 47795 | D2601_HRB169810-Y1206_HRB108765 | Y1206_HRB108765 | Jena HRB 108765 | Jena | Y1206 | 2007-09-17 | |
48360 | 48360 | D2601_HRB173537-M1103_HRB87097-Y1206_HRB503671 | Y1206_HRB503671 | Jena HRB 503671 | Jena | Y1206 | 2009-03-10 | |
49762 | 49762 | D2601_HRB183965-Y1206_HRB509193 | Y1206_HRB509193 | Jena HRB 509193 | Jena | Y1206 | 2013-06-12 | |
50014 | 50014 | D2601_HRB186148-Y1206_HRB508284 | Y1206_HRB508284 | Jena HRB 508284 | Jena | Y1206 | 2012-09-04 | |
50798 | 50798 | D2601_HRB191429-Y1206_HRB508069 | Y1206_HRB508069 | Jena HRB 508069 | Jena | Y1206 | 2012-06-26 | |
51153 | 51153 | D2601_HRB194410-Y1206_HRB510244-D2601_HRB215040-B8536_HRB723224 | Y1206_HRB510244 | Jena HRB 510244 | Jena | Y1206 | 2014-06-02 | 2014-11-13 |
51188 | 51188 | D2601_HRB194683-Y1206_HRB509210 | Y1206_HRB509210 | Jena HRB 509210 | Jena | Y1206 | 2013-06-18 | |
52405 | 52405 | D2601_HRB203919-F1103_HRB150063B-Y1206_HRB509859 | Y1206_HRB509859 | Jena HRB 509859 | Jena | Y1206 | 2014-01-30 | |
52609 | 52609 | D2601_HRB205481-Y1206_HRB514750 | Y1206_HRB514750 | Jena HRB 514750 | Jena | Y1206 | 2018-07-10 | |
54132 | 54132 | D2601_HRB217521-Y1206_HRB512654 | Y1206_HRB512654 | Jena HRB 512654 | Jena | Y1206 | 2016-09-09 | |
56487 | 56487 | D2601_HRB236796-Y1206_HRB519257 | Y1206_HRB519257 | Jena HRB 519257 | Jena | Y1206 | 2022-02-18 | |
56807 | 56807 | D2601_HRB239419-Y1206_HRB516580 | Y1206_HRB516580 | Jena HRB 516580 | Jena | Y1206 | 2020-01-31 | |
57136 | 57136 | D2601_HRB241979-Y1206_HRB515082 | Y1206_HRB515082 | Jena HRB 515082 | Jena | Y1206 | 2018-11-02 | |
57915 | 57915 | D2601_HRB248554-Y1206_HRB517193 | Y1206_HRB517193 | Jena HRB 517193 | Jena | Y1206 | 2020-08-05 | |
63273 | 63273 | D2601_HRB89727-Y1206_HRB504860 | Y1206_HRB504860 | Jena HRB 504860 | Jena | Y1206 | 2009-12-29 | |
65619 | 65619 | D2910_HRB17297-Y1206_HRB201720 | Y1206_HRB201720 | Jena HRB 201720 | Jena | Y1206 | 2006-11-02 | |
65679 | 65679 | D2910_HRB17722-Y1206_HRB201944 | Y1206_HRB201944 | Jena HRB 201944 | Jena | Y1206 | 2007-06-12 | |
68058 | 68058 | D3101_HRB3854-Y1206_HRB305380 | Y1206_HRB305380 | Jena HRB 305380 | Jena | Y1206 | 2006-06-13 | |
68170 | 68170 | D3101_HRB4659-Y1206_HRB113839 | Y1206_HRB113839 | Jena HRB 113839 | Jena | Y1206 | 2010-08-18 | |
69446 | 69446 | D3304_HRB11352-Y1206_HRB301237 | Y1206_HRB301237 | Jena HRB 301237 | Jena | Y1206 | 2008-02-05 | |
70973 | 70973 | D3304_HRB9364-U1104_HRB24993-Y1206_HRB504919 | Y1206_HRB504919 | Jena HRB 504919 | Jena | Y1206 | 2010-01-15 | |
71727 | 71727 | D3310_HRB18542-Y1206_HRB502554 | Y1206_HRB502554 | Jena HRB 502554 | Jena | Y1206 | 2008-04-17 | |
72005 | 72005 | D3310_HRB21044-Y1206_HRB504933-D3310_HRB34874 | Y1206_HRB504933 | Jena HRB 504933 | Jena | Y1206 | 2010-01-18 | 2018-02-14 |
72151 | 72151 | D3310_HRB21975-Y1206_HRB506328 | Y1206_HRB506328 | Jena HRB 506328 | Jena | Y1206 | 2011-01-20 | |
72254 | 72254 | D3310_HRB22648-Y1206_HRB210185 | Y1206_HRB210185 | Jena HRB 210185 | Jena | Y1206 | 2006-06-23 | |
72461 | 72461 | D3310_HRB24040-Y1206_HRB502539 | Y1206_HRB502539 | Jena HRB 502539 | Jena | Y1206 | 2008-04-15 | |
72679 | 72679 | D3310_HRB25619-Y1206_HRB519432 | Y1206_HRB519432 | Jena HRB 519432 | Jena | Y1206 | 2022-04-11 | |
72965 | 72965 | D3310_HRB27819-Y1206_HRB512162-B2609_HRB771575 | Y1206_HRB512162 | Jena HRB 512162 | Jena | Y1206 | 2016-04-01 | 2019-11-21 |
73396 | 73396 | D3310_HRB31313-Y1206_HRB513410 | Y1206_HRB513410 | Jena HRB 513410 | Jena | Y1206 | 2017-05-05 | |
73581 | 73581 | D3310_HRB32881-Y1206_HRB207878-D3101_HRB5887 | Y1206_HRB207878 | Jena HRB 207878 | Jena | Y1206 | 2016-05-12 | 2016-07-21 |
73700 | 73700 | D3310_HRB33803-Y1206_HRB517689 | Y1206_HRB517689 | Jena HRB 517689 | Jena | Y1206 | 2020-12-22 | |
74908 | 74908 | D3410_HRB10547-Y1206_HRB201630 | Y1206_HRB201630 | Jena HRB 201630 | Jena | Y1206 | 2007-05-29 | |
76128 | 76128 | D3410_HRB3925-Y1206_HRB506896 | Y1206_HRB506896 | Jena HRB 506896 | Jena | Y1206 | 2011-07-12 | |
76781 | 76781 | D3413_HRB11223-Y1206_HRB208015-Y1206_HRB512445 | Y1206_HRB208015 | Jena HRB 208015 | Jena | Y1206 | 2006-10-17 | 2016-07-07 |
76782 | 76782 | D3413_HRB11223-Y1206_HRB208015-Y1206_HRB512445 | Y1206_HRB512445 | Jena HRB 512445 | Jena | Y1206 | 2016-07-07 | |
78979 | 78979 | D4102_HRB8749-Y1206_HRB502648 | Y1206_HRB502648 | Jena HRB 502648 | Jena | Y1206 | 2008-05-16 | |
79686 | 79686 | D4201_HRB5920-Y1206_HRB503584 | Y1206_HRB503584 | Jena HRB 503584 | Jena | Y1206 | 2009-02-20 | |
79904 | 79904 | D4201_HRB7530-Y1206_HRB210191 | Y1206_HRB210191 | Jena HRB 210191 | Jena | Y1206 | 2013-02-25 | |
80529 | 80529 | D4301_HRB4375-Y1206_HRB501299-U1206_HRB24277 | Y1206_HRB501299 | Jena HRB 501299 | Jena | Y1206 | 2007-03-29 | 2008-07-02 |
80575 | 80575 | D4301_HRB4645-Y1206_HRB507408 | Y1206_HRB507408 | Jena HRB 507408 | Jena | Y1206 | 2011-12-20 | |
80831 | 80831 | D4301_HRB6646-Y1206_HRB516385 | Y1206_HRB516385 | Jena HRB 516385 | Jena | Y1206 | 2019-12-10 | |
81160 | 81160 | D4401_HRB3623-Y1206_HRB503751 | Y1206_HRB503751 | Jena HRB 503751 | Jena | Y1206 | 2009-03-25 | |
81234 | 81234 | D4401_HRB4188-Y1206_HRB304761 | Y1206_HRB304761 | Jena HRB 304761 | Jena | Y1206 | 2006-11-09 | |
81238 | 81238 | D4401_HRB4215-Y1206_HRB306852 | Y1206_HRB306852 | Jena HRB 306852 | Jena | Y1206 | 2007-01-10 | |
81416 | 81416 | D4401_HRB5578-Y1206_HRB305203 | Y1206_HRB305203 | Jena HRB 305203 | Jena | Y1206 | 2015-02-06 | |
81518 | 81518 | D4401_HRB6517-Y1206_HRB306778 | Y1206_HRB306778 | Jena HRB 306778 | Jena | Y1206 | 2020-09-17 | |
81979 | 81979 | D4501_HRB5361-Y1206_HRB511137 | Y1206_HRB511137 | Jena HRB 511137 | Jena | Y1206 | 2015-04-16 | |
82142 | 82142 | D4608_HRB1260-Y1206_HRB502245 | Y1206_HRB502245 | Jena HRB 502245 | Jena | Y1206 | 2008-01-22 | |
82217 | 82217 | D4608_HRB2398-Y1206_HRB502045 | Y1206_HRB502045 | Jena HRB 502045 | Jena | Y1206 | 2007-11-16 | |
82472 | 82472 | D4608_HRB4964-Y1206_HRB302959 | Y1206_HRB302959 | Jena HRB 302959 | Jena | Y1206 | 2006-06-28 | |
82482 | 82482 | D4608_HRB5057-Y1206_HRB108359 | Y1206_HRB108359 | Jena HRB 108359 | Jena | Y1206 | 2006-12-15 | |
82715 | 82715 | D4608_HRB6973-Y1206_HRB306956 | Y1206_HRB306956 | Jena HRB 306956 | Jena | Y1206 | 2015-01-16 | |
83007 | 83007 | D4708_HRB10462-Y1206_HRB514854 | Y1206_HRB514854 | Jena HRB 514854 | Jena | Y1206 | 2018-08-16 | |
83148 | 83148 | D4708_HRB11553-Y1206_HRB513459-D4708_HRB14641 | Y1206_HRB513459 | Jena HRB 513459 | Jena | Y1206 | 2017-05-24 | 2019-05-29 |
83153 | 83153 | D4708_HRB11558-Y1206_HRB508254 | Y1206_HRB508254 | Jena HRB 508254 | Jena | Y1206 | 2012-08-27 | |
83182 | 83182 | D4708_HRB11714-Y1206_HRB511683 | Y1206_HRB511683 | Jena HRB 511683 | Jena | Y1206 | 2015-11-02 | |
83209 | 83209 | D4708_HRB11950-Y1206_HRB516660 | Y1206_HRB516660 | Jena HRB 516660 | Jena | Y1206 | 2020-02-24 | |
84461 | 84461 | D4708_HRB9852-Y1206_HRB509025 | Y1206_HRB509025 | Jena HRB 509025 | Jena | Y1206 | 2013-04-16 | |
84469 | 84469 | D4708_HRB9926-Y1206_HRB208661 | Y1206_HRB208661 | Jena HRB 208661 | Jena | Y1206 | 2008-10-02 | |
86096 | 86096 | F1103_HRB1021119B-Y1206_HRB113366 | Y1206_HRB113366 | Jena HRB 113366 | Jena | Y1206 | 2006-09-21 | |
86589 | 86589 | F1103_HRB105817B-Y1206_HRB114002 | Y1206_HRB114002 | Jena HRB 114002 | Jena | Y1206 | 2007-02-15 | |
87976 | 87976 | F1103_HRB116004B-Y1206_HRB302602-F1103_HRB116004 | Y1206_HRB302602 | Jena HRB 302602 | Jena | Y1206 | 2008-11-05 | |
88594 | 88594 | F1103_HRB120934B-Y1206_HRB515494-F1103_HRB210919B | Y1206_HRB515494 | Jena HRB 515494 | Jena | Y1206 | 2019-02-26 | 2019-10-08 |
89349 | 89349 | F1103_HRB126851B-Y1206_HRB513754 | Y1206_HRB513754 | Jena HRB 513754 | Jena | Y1206 | 2017-09-01 | |
91359 | 91359 | F1103_HRB142993B-Y1206_HRB508959-F1103_HRB176271B-F1103_HRB176271 | Y1206_HRB508959 | Jena HRB 508959 | Jena | Y1206 | 2013-03-27 | 2016-04-26 |
91414 | 91414 | F1103_HRB143426B-Y1206_HRB511690 | Y1206_HRB511690 | Jena HRB 511690 | Jena | Y1206 | 2015-11-09 | |
91858 | 91858 | F1103_HRB146806B-Y1206_HRB510354 | Y1206_HRB510354 | Jena HRB 510354 | Jena | Y1206 | 2014-07-04 | |
91886 | 91886 | F1103_HRB147044B-Y1206_HRB508986 | Y1206_HRB508986 | Jena HRB 508986 | Jena | Y1206 | 2013-04-08 | |
92549 | 92549 | F1103_HRB151989B-Y1206_HRB518067 | Y1206_HRB518067 | Jena HRB 518067 | Jena | Y1206 | 2021-03-26 | |
95092 | 95092 | F1103_HRB171563B-Y1206_HRB513551 | Y1206_HRB513551 | Jena HRB 513551 | Jena | Y1206 | 2017-06-28 | |
96219 | 96219 | F1103_HRB180636B-Y1206_HRB512869 | Y1206_HRB512869 | Jena HRB 512869 | Jena | Y1206 | 2016-11-28 |
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" );