ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by courtName
This data as json, CSV (advanced)
Suggested facets: referenceNumberFirstSeen (date)
These facets timed out: validTill
Link | rowid | companyId | stdRefNo | nativeReferenceNumber | courtName ▼ | courtCode | referenceNumberFirstSeen | validTill |
---|---|---|---|---|---|---|---|---|
626 | 626 | B1601_HRB111007-R3101_HRB14257-P2507_HRB202716 | R3101_HRB14257 | Aachen HRB 14257 | Aachen | R3101 | 2007-06-13 | 2010-09-03 |
9310 | 9310 | B2609_HRB108968-R3101_HRB15542-W1215_HRB27581-R2706_HRB13758 | R3101_HRB15542 | Aachen HRB 15542 | Aachen | R3101 | 2009-06-30 | 2019-10-18 |
11619 | 11619 | B2609_HRB24573-R3101_HRB19212 | R3101_HRB19212 | Aachen HRB 19212 | Aachen | R3101 | 2014-09-08 | |
15376 | 15376 | B2609_HRB727490-R3101_HRB15181 | R3101_HRB15181 | Aachen HRB 15181 | Aachen | R3101 | 2009-01-07 | |
15906 | 15906 | B2609_HRB731441-R3101_HRB19472 | R3101_HRB19472 | Aachen HRB 19472 | Aachen | R3101 | 2015-01-28 | |
21240 | 21240 | B2609_HRB774954-R3101_HRB24888 | R3101_HRB24888 | Aachen HRB 24888 | Aachen | R3101 | 2021-06-10 | |
21273 | 21273 | B2609_HRB775188-R3101_HRB24237 | R3101_HRB24237 | Aachen HRB 24237 | Aachen | R3101 | 2020-11-12 | |
30239 | 30239 | B8536_HRB706124-R3101_HRB16757 | R3101_HRB16757 | Aachen HRB 16757 | Aachen | R3101 | 2011-03-15 | |
30375 | 30375 | B8536_HRB707337-R3101_HRB24325 | R3101_HRB24325 | Aachen HRB 24325 | Aachen | R3101 | 2020-12-15 | |
30675 | 30675 | B8536_HRB709850-R3101_HRB18402 | R3101_HRB18402 | Aachen HRB 18402 | Aachen | R3101 | 2013-08-02 | |
35121 | 35121 | D2102_HRB32280-R3101_HRB23129 | R3101_HRB23129 | Aachen HRB 23129 | Aachen | R3101 | 2019-09-09 | |
45686 | 45686 | D2601_HRB156557-R3101_HRB13114-R3103_HRB6393-R3306_HRB89805 | R3101_HRB13114 | Aachen HRB 13114 | Aachen | R3101 | 2005-07-11 | 2012-08-09 |
45938 | 45938 | D2601_HRB157981-R3101_HRB13562 | R3101_HRB13562 | Aachen HRB 13562 | Aachen | R3101 | 2006-03-23 | |
55210 | 55210 | D2601_HRB226416-R3101_HRB23336 | R3101_HRB23336 | Aachen HRB 23336 | Aachen | R3101 | 2019-12-03 | |
55856 | 55856 | D2601_HRB231558-R3101_HRB21755 | R3101_HRB21755 | Aachen HRB 21755 | Aachen | R3101 | 2018-01-17 | |
63750 | 63750 | D2601_HRB98133-R3101_HRB24137 | R3101_HRB24137 | Aachen HRB 24137 | Aachen | R3101 | 2020-10-14 | |
72993 | 72993 | D3310_HRB28033-R3101_HRB17381 | R3101_HRB17381 | Aachen HRB 17381 | Aachen | R3101 | 2012-02-21 | |
77804 | 77804 | D4102_HRB11206-R3101_HRB16562-R3306_HRB75827-D4102_HRB13831 | R3101_HRB16562 | Aachen HRB 16562 | Aachen | R3101 | 2010-12-06 | 2012-06-28 |
81381 | 81381 | D4401_HRB5286-G1312_HRB31952P-R3101_HRB25044 | R3101_HRB25044 | Aachen HRB 25044 | Aachen | R3101 | 2021-08-04 | |
87098 | 87098 | F1103_HRB109300B-R3101_HRB8855 | R3101_HRB8855 | Aachen HRB 8855 | Aachen | R3101 | 2007-09-10 | |
89154 | 89154 | F1103_HRB125256B-R3101_HRB20941 | R3101_HRB20941 | Aachen HRB 20941 | Aachen | R3101 | 2017-01-26 | |
91216 | 91216 | F1103_HRB141760B-R3101_HRB18075 | R3101_HRB18075 | Aachen HRB 18075 | Aachen | R3101 | 2013-02-28 | |
91659 | 91659 | F1103_HRB145402B-R3101_HRB18082 | R3101_HRB18082 | Aachen HRB 18082 | Aachen | R3101 | 2013-03-04 | |
96334 | 96334 | F1103_HRB181465B-R3101_HRB23108 | R3101_HRB23108 | Aachen HRB 23108 | Aachen | R3101 | 2019-08-28 | |
96975 | 96975 | F1103_HRB186923B-R3101_HRB23501 | R3101_HRB23501 | Aachen HRB 23501 | Aachen | R3101 | 2020-02-10 | |
97167 | 97167 | F1103_HRB188469B-R3101_HRB21700-R2809_HRB13589 | R3101_HRB21700 | Aachen HRB 21700 | Aachen | R3101 | 2017-12-28 | 2018-09-13 |
97717 | 97717 | F1103_HRB193075B-R3101_HRB24330 | R3101_HRB24330 | Aachen HRB 24330 | Aachen | R3101 | 2020-12-15 | |
98999 | 98999 | F1103_HRB203093B-R3101_HRB23147 | R3101_HRB23147 | Aachen HRB 23147 | Aachen | R3101 | 2019-09-13 | |
99278 | 99278 | F1103_HRB205546B-R3101_HRB23528-B2609_HRB779237 | R3101_HRB23528 | Aachen HRB 23528 | Aachen | R3101 | 2020-02-21 | 2021-05-19 |
102006 | 102006 | F1103_HRB227980B-R3101_HRB25639 | R3101_HRB25639 | Aachen HRB 25639 | Aachen | R3101 | 2022-03-17 | |
105122 | 105122 | F1103_HRB52833B-R3101_HRB23244 | R3101_HRB23244 | Aachen HRB 23244 | Aachen | R3101 | 2019-10-28 | |
108192 | 108192 | F1103_HRB92702B-R3101_HRB16636 | R3101_HRB16636 | Aachen HRB 16636 | Aachen | R3101 | 2011-01-13 | |
109493 | 109493 | G1103_HRB12899CB-R3101_HRB21534-R3103_HRB8145 | R3101_HRB21534 | Aachen HRB 21534 | Aachen | R3101 | 2017-10-23 | 2019-09-16 |
111968 | 111968 | G1207_HRB328FF-R3101_HRB16072 | R3101_HRB16072 | Aachen HRB 16072 | Aachen | R3101 | 2010-03-29 | |
114540 | 114540 | G1312_HRB18257P-R3101_HRB9380 | R3101_HRB9380 | Aachen HRB 9380 | Aachen | R3101 | 2005-01-17 | |
114817 | 114817 | G1312_HRB20022P-R1402_HRB12390-R3101_HRB15632-R1101_HRB63287 | R3101_HRB15632 | Aachen HRB 15632 | Aachen | R3101 | 2009-08-27 | 2010-04-30 |
121203 | 121203 | K1101_HRB107987-R3101_HRB15373 | R3101_HRB15373 | Aachen HRB 15373 | Aachen | R3101 | 2009-04-01 | |
122811 | 122811 | K1101_HRB119953-R3101_HRB7835 | R3101_HRB7835 | Aachen HRB 7835 | Aachen | R3101 | 2011-09-29 | |
123166 | 123166 | K1101_HRB122565-R3101_HRB18777-G1312_HRB32166P | R3101_HRB18777 | Aachen HRB 18777 | Aachen | R3101 | 2014-01-27 | 2019-02-20 |
123811 | 123811 | K1101_HRB127390-R3101_HRB18826 | R3101_HRB18826 | Aachen HRB 18826 | Aachen | R3101 | 2014-02-17 | |
127901 | 127901 | K1101_HRB159847-R3101_HRB23420 | R3101_HRB23420 | Aachen HRB 23420 | Aachen | R3101 | 2020-01-13 | |
128369 | 128369 | K1101_HRB163410-R3101_HRB25855 | R3101_HRB25855 | Aachen HRB 25855 | Aachen | R3101 | 2022-06-20 | |
133758 | 133758 | K1101_HRB88161-R3101_HRB15841 | R3101_HRB15841 | Aachen HRB 15841 | Aachen | R3101 | 2009-12-14 | |
134902 | 134902 | K1101_HRB97459-R3101_HRB14049 | R3101_HRB14049 | Aachen HRB 14049 | Aachen | R3101 | 2007-01-29 | |
136623 | 136623 | M1103_HRB62025-R3101_HRB17195-R1402_HRB14592 | R3101_HRB17195 | Aachen HRB 17195 | Aachen | R3101 | 2011-11-07 | 2013-11-06 |
136762 | 136762 | M1103_HRB7129-R3101_HRB17787-M1103_HRB92807 | R3101_HRB17787 | Aachen HRB 17787 | Aachen | R3101 | 2012-10-09 | 2014-01-09 |
141640 | 141640 | M1201_HRB102032-R3101_HRB20096 | R3101_HRB20096 | Aachen HRB 20096 | Aachen | R3101 | 2015-12-10 | |
143080 | 143080 | M1201_HRB112993-R3101_HRB25181 | R3101_HRB25181 | Aachen HRB 25181 | Aachen | R3101 | 2021-09-27 | |
147831 | 147831 | M1201_HRB79818-F1103_HRB108841B-R3101_HRB18034 | R3101_HRB18034 | Aachen HRB 18034 | Aachen | R3101 | 2013-02-06 | |
148757 | 148757 | M1201_HRB85463-R3101_HRB15686 | R3101_HRB15686 | Aachen HRB 15686 | Aachen | R3101 | 2009-09-29 | |
148965 | 148965 | M1201_HRB86886-D2601_HRB183544-R3101_HRB16888 | R3101_HRB16888 | Aachen HRB 16888 | Aachen | R3101 | 2011-05-19 | |
150074 | 150074 | M1201_HRB95000-R1608_HRB24688-R3101_HRB22172-R1608_HRB24688FIR | R3101_HRB22172 | Aachen HRB 22172 | Aachen | R3101 | 2018-07-16 | |
151448 | 151448 | M1202_HRB4856-R3101_HRB18181 | R3101_HRB18181 | Aachen HRB 18181 | Aachen | R3101 | 2013-04-19 | |
152842 | 152842 | M1301_HRB4418-R3101_HRB8909 | R3101_HRB8909 | Aachen HRB 8909 | Aachen | R3101 | 2005-01-13 | |
161694 | 161694 | M1906_HRB27022-R3101_HRB20327 | R3101_HRB20327 | Aachen HRB 20327 | Aachen | R3101 | 2016-03-29 | |
171748 | 171748 | P2305_HRB208270-R3101_HRB18158-P2305_HRB210876 | R3101_HRB18158 | Aachen HRB 18158 | Aachen | R3101 | 2013-04-15 | 2014-03-03 |
171765 | 171765 | P2305_HRB208439-R3101_HRB17710 | R3101_HRB17710 | Aachen HRB 17710 | Aachen | R3101 | 2012-08-13 | |
171991 | 171991 | P2305_HRB209995-R3101_HRB18482 | R3101_HRB18482 | Aachen HRB 18482 | Aachen | R3101 | 2013-09-05 | |
172214 | 172214 | P2305_HRB211559-R3101_HRB19401 | R3101_HRB19401 | Aachen HRB 19401 | Aachen | R3101 | 2014-12-18 | |
180046 | 180046 | P2716_HRB111749-R3101_HRB9884 | R3101_HRB9884 | Aachen HRB 9884 | Aachen | R3101 | 2005-10-10 | |
187838 | 187838 | P3313_HRB201043-R3101_HRB8922 | R3101_HRB8922 | Aachen HRB 8922 | Aachen | R3101 | 2007-06-04 | |
190349 | 190349 | R1101_HRB23007-R3101_HRB22454 | R3101_HRB22454 | Aachen HRB 22454 | Aachen | R3101 | 2018-11-19 | |
190729 | 190729 | R1101_HRB32157-R3101_HRB25517 | R3101_HRB25517 | Aachen HRB 25517 | Aachen | R3101 | 2022-02-07 | |
191962 | 191962 | R1101_HRB46812-R1504_HRB12283-R3101_HRB16719 | R3101_HRB16719 | Aachen HRB 16719 | Aachen | R3101 | 2011-02-17 | |
192404 | 192404 | R1101_HRB50789-R3101_HRB19115 | R3101_HRB19115 | Aachen HRB 19115 | Aachen | R3101 | 2014-07-10 | |
192629 | 192629 | R1101_HRB52139-R3101_HRB4357 | R3101_HRB4357 | Aachen HRB 4357 | Aachen | R3101 | 2005-07-26 | |
193184 | 193184 | R1101_HRB55645-R3101_HRB15071 | R3101_HRB15071 | Aachen HRB 15071 | Aachen | R3101 | 2008-11-11 | |
193219 | 193219 | R1101_HRB55851-R3101_HRB15079 | R3101_HRB15079 | Aachen HRB 15079 | Aachen | R3101 | 2008-11-17 | |
193316 | 193316 | R1101_HRB56527-R3101_HRB14500 | R3101_HRB14500 | Aachen HRB 14500 | Aachen | R3101 | 2007-12-04 | |
193377 | 193377 | R1101_HRB56885-R3101_HRB14811 | R3101_HRB14811 | Aachen HRB 14811 | Aachen | R3101 | 2008-05-28 | |
193402 | 193402 | R1101_HRB57062-R3101_HRB14726-R1101_HRB95536 | R3101_HRB14726 | Aachen HRB 14726 | Aachen | R3101 | 2008-04-10 | 2021-11-19 |
193599 | 193599 | R1101_HRB58397-R3101_HRB16857-R1101_HRB68287 | R3101_HRB16857 | Aachen HRB 16857 | Aachen | R3101 | 2011-05-06 | 2012-07-18 |
193919 | 193919 | R1101_HRB60801-R3101_HRB15519 | R3101_HRB15519 | Aachen HRB 15519 | Aachen | R3101 | 2009-06-22 | |
194293 | 194293 | R1101_HRB63331-R3101_HRB16686 | R3101_HRB16686 | Aachen HRB 16686 | Aachen | R3101 | 2011-02-02 | |
194673 | 194673 | R1101_HRB66008-R3101_HRB17035 | R3101_HRB17035 | Aachen HRB 17035 | Aachen | R3101 | 2011-08-08 | |
194963 | 194963 | R1101_HRB68204-R3101_HRB20378 | R3101_HRB20378 | Aachen HRB 20378 | Aachen | R3101 | 2016-04-19 | |
195480 | 195480 | R1101_HRB72522-R3101_HRB23484 | R3101_HRB23484 | Aachen HRB 23484 | Aachen | R3101 | 2020-02-03 | |
196141 | 196141 | R1101_HRB78082-R3101_HRB21006 | R3101_HRB21006 | Aachen HRB 21006 | Aachen | R3101 | 2017-02-15 | |
196218 | 196218 | R1101_HRB78834-R3101_HRB21727 | R3101_HRB21727 | Aachen HRB 21727 | Aachen | R3101 | 2018-01-09 | |
197163 | 197163 | R1101_HRB86917-R3101_HRB25635 | R3101_HRB25635 | Aachen HRB 25635 | Aachen | R3101 | 2022-03-15 | |
198648 | 198648 | R1102_HRB13541-R3101_HRB7768 | R3101_HRB7768 | Aachen HRB 7768 | Aachen | R3101 | 2005-10-20 | |
200928 | 200928 | R1202_HRB17639-R3101_HRB12581 | R3101_HRB12581 | Aachen HRB 12581 | Aachen | R3101 | 2005-04-15 | |
201934 | 201934 | R1202_HRB25581-R3101_HRB22327 | R3101_HRB22327 | Aachen HRB 22327 | Aachen | R3101 | 2018-09-14 | |
203631 | 203631 | R1304_HRB11237-R3101_HRB18121 | R3101_HRB18121 | Aachen HRB 18121 | Aachen | R3101 | 2013-03-22 | |
203779 | 203779 | R1304_HRB12349-R3101_HRB18581 | R3101_HRB18581 | Aachen HRB 18581 | Aachen | R3101 | 2013-10-24 | |
205119 | 205119 | R1304_HRB7473-R3101_HRB7195 | R3101_HRB7195 | Aachen HRB 7195 | Aachen | R3101 | 2005-05-24 | 2009-07-21 |
205226 | 205226 | R1304_HRB8208-R1402_HRB11557-Y1206_HRB503324-R3101_HRB16738-R1504_HRB16621 | R3101_HRB16738 | Aachen HRB 16738 | Aachen | R3101 | 2011-03-02 | 2015-06-30 |
205611 | 205611 | R1402_HRB11114-R3101_HRB14086-D4501_HRB4586 | R3101_HRB14086 | Aachen HRB 14086 | Aachen | R3101 | 2007-02-23 | 2009-11-13 |
205622 | 205622 | R1402_HRB11191-R3101_HRB10997 | R3101_HRB10997 | Aachen HRB 10997 | Aachen | R3101 | 2006-09-04 | |
205890 | 205890 | R1402_HRB13200-R3101_HRB24988 | R3101_HRB24988 | Aachen HRB 24988 | Aachen | R3101 | 2021-07-15 | |
205907 | 205907 | R1402_HRB13326-R3101_HRB4341 | R3101_HRB4341 | Aachen HRB 4341 | Aachen | R3101 | 2011-02-03 | |
206145 | 206145 | R1402_HRB15467-R3101_HRB24438 | R3101_HRB24438 | Aachen HRB 24438 | Aachen | R3101 | 2021-01-28 | |
206710 | 206710 | R1402_HRB6083-R1402_HRB6083FIR-R3101_HRB24510 | R3101_HRB24510 | Aachen HRB 24510 | Aachen | R3101 | 2021-02-16 | |
207237 | 207237 | R1504_HRB11254-R3101_HRB9864 | R3101_HRB9864 | Aachen HRB 9864 | Aachen | R3101 | 2005-07-18 | |
207281 | 207281 | R1504_HRB11507-R3101_HRB23941 | R3101_HRB23941 | Aachen HRB 23941 | Aachen | R3101 | 2020-07-31 | |
207295 | 207295 | R1504_HRB11608-R3101_HRB15490 | R3101_HRB15490 | Aachen HRB 15490 | Aachen | R3101 | 2009-05-28 | |
207385 | 207385 | R1504_HRB12276-R3101_HRB14517 | R3101_HRB14517 | Aachen HRB 14517 | Aachen | R3101 | 2007-12-14 | |
207413 | 207413 | R1504_HRB12464-R3101_HRB11776 | R3101_HRB11776 | Aachen HRB 11776 | Aachen | R3101 | 2008-01-22 | |
207452 | 207452 | R1504_HRB12891-R3101_HRB16373 | R3101_HRB16373 | Aachen HRB 16373 | Aachen | R3101 | 2010-09-09 | |
207461 | 207461 | R1504_HRB12921-R3101_HRB23667 | R3101_HRB23667 | Aachen HRB 23667 | Aachen | R3101 | 2020-04-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" );