ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by courtName
This data as json, CSV (advanced)
These facets timed out: validTill
Link | rowid | companyId | stdRefNo | nativeReferenceNumber | courtName ▼ | courtCode | referenceNumberFirstSeen | validTill |
---|---|---|---|---|---|---|---|---|
207487 | 207487 | R1504_HRB13163-R3101_HRB15546 | R3101_HRB15546 | Aachen HRB 15546 | Aachen | R3101 | 2009-07-02 | |
207865 | 207865 | R1504_HRB16485-R3101_HRB20929 | R3101_HRB20929 | Aachen HRB 20929 | Aachen | R3101 | 2017-01-24 | |
207878 | 207878 | R1504_HRB16638-R3101_HRB22617 | R3101_HRB22617 | Aachen HRB 22617 | Aachen | R3101 | 2019-01-29 | |
207926 | 207926 | R1504_HRB16985-R3101_HRB25294 | R3101_HRB25294 | Aachen HRB 25294 | Aachen | R3101 | 2021-11-12 | |
208060 | 208060 | R1504_HRB18067-R3101_HRB9898 | R3101_HRB9898 | Aachen HRB 9898 | Aachen | R3101 | 2018-02-19 | |
208097 | 208097 | R1504_HRB18363-R3101_HRB23016 | R3101_HRB23016 | Aachen HRB 23016 | Aachen | R3101 | 2019-07-23 | |
208554 | 208554 | R1504_HRB5690-R3101_HRB19068 | R3101_HRB19068 | Aachen HRB 19068 | Aachen | R3101 | 2014-06-16 | |
208885 | 208885 | R1504_HRB9092-R3101_HRB20564 | R3101_HRB20564 | Aachen HRB 20564 | Aachen | R3101 | 2016-07-26 | |
208918 | 208918 | R1504_HRB9340-R1101_HRB87057-R3101_HRB24278 | R3101_HRB24278 | Aachen HRB 24278 | Aachen | R3101 | 2020-11-27 | |
210096 | 210096 | R1608_HRB19564-R3101_HRB7262-R3306_HRB62383 | R3101_HRB7262 | Aachen HRB 7262 | Aachen | R3101 | 2006-01-18 | 2008-02-08 |
210822 | 210822 | R1608_HRB25522-R3306_HRB82329-R3101_HRB20923 | R3101_HRB20923 | Aachen HRB 20923 | Aachen | R3101 | 2017-01-20 | |
211496 | 211496 | R1608_HRB31174-R3101_HRB25327 | R3101_HRB25327 | Aachen HRB 25327 | Aachen | R3101 | 2021-11-25 | |
213264 | 213264 | R1901_HRB7889-R3101_HRB16485 | R3101_HRB16485 | Aachen HRB 16485 | Aachen | R3101 | 2010-10-28 | |
218119 | 218119 | R2201_HRB11745-R3101_HRB15759 | R3101_HRB15759 | Aachen HRB 15759 | Aachen | R3101 | 2009-11-05 | |
218294 | 218294 | R2201_HRB13075-R3101_HRB17875 | R3101_HRB17875 | Aachen HRB 17875 | Aachen | R3101 | 2012-11-26 | |
220902 | 220902 | R2307_HRB4302-R3101_HRB15120 | R3101_HRB15120 | Aachen HRB 15120 | Aachen | R3101 | 2008-12-08 | |
223039 | 223039 | R2402_HRB22848-R3101_HRB23835 | R3101_HRB23835 | Aachen HRB 23835 | Aachen | R3101 | 2020-06-18 | |
223642 | 223642 | R2402_HRB27389-R3101_HRB20743-B1601_HRB730406 | R3101_HRB20743 | Aachen HRB 20743 | Aachen | R3101 | 2016-10-24 | 2018-05-09 |
227605 | 227605 | R2503_HRB26292-R3101_HRB21195 | R3101_HRB21195 | Aachen HRB 21195 | Aachen | R3101 | 2017-05-12 | |
228253 | 228253 | R2503_HRB31922-R3101_HRB24738 | R3101_HRB24738 | Aachen HRB 24738 | Aachen | R3101 | 2021-04-21 | |
234177 | 234177 | R2707_HRB11392-R3101_HRB16620 | R3101_HRB16620 | Aachen HRB 16620 | Aachen | R3101 | 2011-01-05 | |
236150 | 236150 | R2707_HRB9748-R3101_HRB8656-P3313_HRB211709 | R3101_HRB8656 | Aachen HRB 8656 | Aachen | R3101 | 2005-07-18 | 2017-07-17 |
240145 | 240145 | R2909_HRB12889-R3101_HRB25746 | R3101_HRB25746 | Aachen HRB 25746 | Aachen | R3101 | 2022-04-28 | |
240959 | 240959 | R3101_HRB10004 | R3101_HRB10004 | Aachen HRB 10004 | Aachen | R3101 | 2006-04-05 | |
240960 | 240960 | R3101_HRB10009 | R3101_HRB10009 | Aachen HRB 10009 | Aachen | R3101 | 2005-04-14 | |
240961 | 240961 | R3101_HRB10021 | R3101_HRB10021 | Aachen HRB 10021 | Aachen | R3101 | 2006-05-11 | |
240962 | 240962 | R3101_HRB10022 | R3101_HRB10022 | Aachen HRB 10022 | Aachen | R3101 | 2014-01-17 | |
240963 | 240963 | R3101_HRB10043-R1504_HRB14530 | R3101_HRB10043 | Aachen HRB 10043 | Aachen | R3101 | 2005-02-23 | 2011-07-28 |
240965 | 240965 | R3101_HRB10048 | R3101_HRB10048 | Aachen HRB 10048 | Aachen | R3101 | 2019-12-30 | |
240966 | 240966 | R3101_HRB10060 | R3101_HRB10060 | Aachen HRB 10060 | Aachen | R3101 | 2005-07-14 | |
240967 | 240967 | R3101_HRB10066 | R3101_HRB10066 | Aachen HRB 10066 | Aachen | R3101 | 2007-02-20 | |
240968 | 240968 | R3101_HRB10075 | R3101_HRB10075 | Aachen HRB 10075 | Aachen | R3101 | 2005-01-04 | |
240969 | 240969 | R3101_HRB10077 | R3101_HRB10077 | Aachen HRB 10077 | Aachen | R3101 | 2008-12-04 | |
240970 | 240970 | R3101_HRB10081 | R3101_HRB10081 | Aachen HRB 10081 | Aachen | R3101 | 2010-04-09 | |
240971 | 240971 | R3101_HRB10105 | R3101_HRB10105 | Aachen HRB 10105 | Aachen | R3101 | 2010-10-13 | |
240972 | 240972 | R3101_HRB10118 | R3101_HRB10118 | Aachen HRB 10118 | Aachen | R3101 | 2015-02-04 | |
240973 | 240973 | R3101_HRB10143 | R3101_HRB10143 | Aachen HRB 10143 | Aachen | R3101 | 2007-10-19 | |
240974 | 240974 | R3101_HRB10146 | R3101_HRB10146 | Aachen HRB 10146 | Aachen | R3101 | 2021-05-05 | |
240975 | 240975 | R3101_HRB10176 | R3101_HRB10176 | Aachen HRB 10176 | Aachen | R3101 | 2014-01-23 | |
240976 | 240976 | R3101_HRB10178-R1304_HRB15001 | R3101_HRB10178 | Aachen HRB 10178 | Aachen | R3101 | 2006-09-22 | 2017-11-29 |
240978 | 240978 | R3101_HRB10185 | R3101_HRB10185 | Aachen HRB 10185 | Aachen | R3101 | 2018-01-29 | |
240979 | 240979 | R3101_HRB10190 | R3101_HRB10190 | Aachen HRB 10190 | Aachen | R3101 | 2015-10-15 | |
240980 | 240980 | R3101_HRB10204 | R3101_HRB10204 | Aachen HRB 10204 | Aachen | R3101 | 2005-06-09 | |
240981 | 240981 | R3101_HRB10222 | R3101_HRB10222 | Aachen HRB 10222 | Aachen | R3101 | 2005-10-14 | |
240982 | 240982 | R3101_HRB10226 | R3101_HRB10226 | Aachen HRB 10226 | Aachen | R3101 | 2007-04-27 | |
240983 | 240983 | R3101_HRB10230 | R3101_HRB10230 | Aachen HRB 10230 | Aachen | R3101 | 2005-02-23 | |
240984 | 240984 | R3101_HRB10246 | R3101_HRB10246 | Aachen HRB 10246 | Aachen | R3101 | 2006-06-28 | |
240985 | 240985 | R3101_HRB10253 | R3101_HRB10253 | Aachen HRB 10253 | Aachen | R3101 | 2020-01-31 | |
240986 | 240986 | R3101_HRB10266 | R3101_HRB10266 | Aachen HRB 10266 | Aachen | R3101 | 2005-07-25 | |
240987 | 240987 | R3101_HRB10268 | R3101_HRB10268 | Aachen HRB 10268 | Aachen | R3101 | 2007-08-07 | |
240988 | 240988 | R3101_HRB10274 | R3101_HRB10274 | Aachen HRB 10274 | Aachen | R3101 | 2014-07-10 | |
240989 | 240989 | R3101_HRB10277-R3201_HRB14652-M1201_HRB125526 | R3101_HRB10277 | Aachen HRB 10277 | Aachen | R3101 | 2005-10-11 | 2006-07-25 |
240992 | 240992 | R3101_HRB10281 | R3101_HRB10281 | Aachen HRB 10281 | Aachen | R3101 | 2010-03-31 | |
240993 | 240993 | R3101_HRB10285 | R3101_HRB10285 | Aachen HRB 10285 | Aachen | R3101 | 2009-07-01 | |
240994 | 240994 | R3101_HRB10292 | R3101_HRB10292 | Aachen HRB 10292 | Aachen | R3101 | 2007-09-17 | |
240995 | 240995 | R3101_HRB10294 | R3101_HRB10294 | Aachen HRB 10294 | Aachen | R3101 | 2005-02-21 | |
240996 | 240996 | R3101_HRB10296 | R3101_HRB10296 | Aachen HRB 10296 | Aachen | R3101 | 2021-04-01 | |
240997 | 240997 | R3101_HRB10300-M1114_HRB44634-M1103_HRB92939 | R3101_HRB10300 | Aachen HRB 10300 | Aachen | R3101 | 2006-10-05 | 2010-03-03 |
241000 | 241000 | R3101_HRB10306 | R3101_HRB10306 | Aachen HRB 10306 | Aachen | R3101 | 2006-05-11 | |
241001 | 241001 | R3101_HRB10323 | R3101_HRB10323 | Aachen HRB 10323 | Aachen | R3101 | 2007-12-07 | |
241002 | 241002 | R3101_HRB10354 | R3101_HRB10354 | Aachen HRB 10354 | Aachen | R3101 | 2010-06-18 | |
241003 | 241003 | R3101_HRB10365 | R3101_HRB10365 | Aachen HRB 10365 | Aachen | R3101 | 2019-03-05 | |
241004 | 241004 | R3101_HRB10372 | R3101_HRB10372 | Aachen HRB 10372 | Aachen | R3101 | 2007-11-07 | |
241005 | 241005 | R3101_HRB10373 | R3101_HRB10373 | Aachen HRB 10373 | Aachen | R3101 | 2018-02-21 | |
241006 | 241006 | R3101_HRB10374 | R3101_HRB10374 | Aachen HRB 10374 | Aachen | R3101 | 2011-04-11 | |
241007 | 241007 | R3101_HRB10399 | R3101_HRB10399 | Aachen HRB 10399 | Aachen | R3101 | 2013-11-19 | |
241008 | 241008 | R3101_HRB10411-R1504_HRB16883 | R3101_HRB10411 | Aachen HRB 10411 | Aachen | R3101 | 2006-12-04 | 2015-12-16 |
241010 | 241010 | R3101_HRB10427 | R3101_HRB10427 | Aachen HRB 10427 | Aachen | R3101 | 2009-07-13 | |
241011 | 241011 | R3101_HRB10451 | R3101_HRB10451 | Aachen HRB 10451 | Aachen | R3101 | 2022-04-12 | |
241012 | 241012 | R3101_HRB10475 | R3101_HRB10475 | Aachen HRB 10475 | Aachen | R3101 | 2006-11-14 | |
241013 | 241013 | R3101_HRB10480 | R3101_HRB10480 | Aachen HRB 10480 | Aachen | R3101 | 2007-03-30 | |
241014 | 241014 | R3101_HRB10482 | R3101_HRB10482 | Aachen HRB 10482 | Aachen | R3101 | 2010-01-26 | |
241015 | 241015 | R3101_HRB10485 | R3101_HRB10485 | Aachen HRB 10485 | Aachen | R3101 | 2018-01-24 | |
241016 | 241016 | R3101_HRB10505 | R3101_HRB10505 | Aachen HRB 10505 | Aachen | R3101 | 2008-04-23 | |
241017 | 241017 | R3101_HRB10507 | R3101_HRB10507 | Aachen HRB 10507 | Aachen | R3101 | 2015-08-27 | |
241018 | 241018 | R3101_HRB10508 | R3101_HRB10508 | Aachen HRB 10508 | Aachen | R3101 | 2019-09-12 | |
241019 | 241019 | R3101_HRB10524 | R3101_HRB10524 | Aachen HRB 10524 | Aachen | R3101 | 2005-04-28 | |
241020 | 241020 | R3101_HRB10540 | R3101_HRB10540 | Aachen HRB 10540 | Aachen | R3101 | 2006-01-09 | |
241021 | 241021 | R3101_HRB10545-Y1206_HRB503079-W1215_HRB23015 | R3101_HRB10545 | Aachen HRB 10545 | Aachen | R3101 | 2008-03-06 | 2008-10-07 |
241024 | 241024 | R3101_HRB10546 | R3101_HRB10546 | Aachen HRB 10546 | Aachen | R3101 | 2007-03-19 | |
241025 | 241025 | R3101_HRB10547 | R3101_HRB10547 | Aachen HRB 10547 | Aachen | R3101 | 2022-02-09 | |
241026 | 241026 | R3101_HRB10553-R2706_HRB7284-R2713_HRB13262 | R3101_HRB10553 | Aachen HRB 10553 | Aachen | R3101 | 2005-12-16 | 2006-04-28 |
241029 | 241029 | R3101_HRB10562 | R3101_HRB10562 | Aachen HRB 10562 | Aachen | R3101 | 2010-09-20 | |
241030 | 241030 | R3101_HRB10565 | R3101_HRB10565 | Aachen HRB 10565 | Aachen | R3101 | 2008-03-03 | |
241031 | 241031 | R3101_HRB10569 | R3101_HRB10569 | Aachen HRB 10569 | Aachen | R3101 | 2005-12-08 | |
241032 | 241032 | R3101_HRB10589 | R3101_HRB10589 | Aachen HRB 10589 | Aachen | R3101 | 2013-07-09 | |
241033 | 241033 | R3101_HRB10590 | R3101_HRB10590 | Aachen HRB 10590 | Aachen | R3101 | 2005-12-21 | |
241034 | 241034 | R3101_HRB10605 | R3101_HRB10605 | Aachen HRB 10605 | Aachen | R3101 | 2012-07-02 | |
241035 | 241035 | R3101_HRB10612 | R3101_HRB10612 | Aachen HRB 10612 | Aachen | R3101 | 2009-03-30 | |
241036 | 241036 | R3101_HRB10621 | R3101_HRB10621 | Aachen HRB 10621 | Aachen | R3101 | 2005-05-04 | |
241037 | 241037 | R3101_HRB10622 | R3101_HRB10622 | Aachen HRB 10622 | Aachen | R3101 | 2007-07-02 | |
241038 | 241038 | R3101_HRB10627 | R3101_HRB10627 | Aachen HRB 10627 | Aachen | R3101 | 2006-05-16 | |
241039 | 241039 | R3101_HRB10631 | R3101_HRB10631 | Aachen HRB 10631 | Aachen | R3101 | 2006-04-18 | |
241040 | 241040 | R3101_HRB10636 | R3101_HRB10636 | Aachen HRB 10636 | Aachen | R3101 | 2008-09-12 | |
241041 | 241041 | R3101_HRB10641 | R3101_HRB10641 | Aachen HRB 10641 | Aachen | R3101 | 2014-04-16 | |
241042 | 241042 | R3101_HRB10647 | R3101_HRB10647 | Aachen HRB 10647 | Aachen | R3101 | 2017-01-26 | |
241043 | 241043 | R3101_HRB10663 | R3101_HRB10663 | Aachen HRB 10663 | Aachen | R3101 | 2010-08-12 | |
241044 | 241044 | R3101_HRB10670-R1504_HRB17205 | R3101_HRB10670 | Aachen HRB 10670 | Aachen | R3101 | 2014-06-16 | 2016-08-04 |
241046 | 241046 | R3101_HRB10694 | R3101_HRB10694 | Aachen HRB 10694 | Aachen | R3101 | 2010-11-26 | |
241047 | 241047 | R3101_HRB10720-B1601_HRB713789 | R3101_HRB10720 | Aachen HRB 10720 | Aachen | R3101 | 2008-08-15 | 2012-02-01 |
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" );