ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by nativeReferenceNumber
This data as json, CSV (advanced)
Suggested facets: validTill (date)
These facets timed out: referenceNumberFirstSeen
Link | rowid | companyId | stdRefNo | nativeReferenceNumber ▼ | courtName | courtCode | referenceNumberFirstSeen | validTill |
---|---|---|---|---|---|---|---|---|
2329709 | 2329709 | R3101_HRB100 | R3101_HRB100 | Aachen HRB 100 | Aachen | R3101 | 2007-02-26 | |
2329710 | 2329710 | R3101_HRB10000 | R3101_HRB10000 | Aachen HRB 10000 | Aachen | R3101 | 2013-06-26 | |
850090 | 850090 | R3101_HRB10002 | R3101_HRB10002 | Aachen HRB 10002 | Aachen | R3101 | 2005-01-10 | |
2037446 | 2037446 | R3101_HRB10003 | R3101_HRB10003 | Aachen HRB 10003 | Aachen | R3101 | 2005-04-12 | |
240959 | 240959 | R3101_HRB10004 | R3101_HRB10004 | Aachen HRB 10004 | Aachen | R3101 | 2006-04-05 | |
545298 | 545298 | R3101_HRB10005 | R3101_HRB10005 | Aachen HRB 10005 | Aachen | R3101 | 2014-12-08 | |
1744900 | 1744900 | R3101_HRB10006 | R3101_HRB10006 | Aachen HRB 10006 | Aachen | R3101 | 2008-07-08 | |
2329711 | 2329711 | R3101_HRB10007 | R3101_HRB10007 | Aachen HRB 10007 | Aachen | R3101 | 2005-12-15 | |
1744901 | 1744901 | R3101_HRB10008 | R3101_HRB10008 | Aachen HRB 10008 | Aachen | R3101 | 2010-03-29 | |
240960 | 240960 | R3101_HRB10009 | R3101_HRB10009 | Aachen HRB 10009 | Aachen | R3101 | 2005-04-14 | |
545299 | 545299 | R3101_HRB10010 | R3101_HRB10010 | Aachen HRB 10010 | Aachen | R3101 | 2005-08-31 | |
545300 | 545300 | R3101_HRB10012 | R3101_HRB10012 | Aachen HRB 10012 | Aachen | R3101 | 2011-06-10 | |
545301 | 545301 | R3101_HRB10013 | R3101_HRB10013 | Aachen HRB 10013 | Aachen | R3101 | 2012-01-31 | |
1744902 | 1744902 | R3101_HRB10014 | R3101_HRB10014 | Aachen HRB 10014 | Aachen | R3101 | 2005-10-14 | |
545302 | 545302 | R3101_HRB10015-R1304_HRB10153 | R3101_HRB10015 | Aachen HRB 10015 | Aachen | R3101 | 2008-12-05 | 2010-02-18 |
2329712 | 2329712 | R3101_HRB10019 | R3101_HRB10019 | Aachen HRB 10019 | Aachen | R3101 | 2016-01-29 | |
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 | |
1451318 | 1451318 | R3101_HRB10024 | R3101_HRB10024 | Aachen HRB 10024 | Aachen | R3101 | 2007-05-09 | |
1451319 | 1451319 | R3101_HRB10025 | R3101_HRB10025 | Aachen HRB 10025 | Aachen | R3101 | 2005-03-02 | |
2037447 | 2037447 | R3101_HRB10026 | R3101_HRB10026 | Aachen HRB 10026 | Aachen | R3101 | 2010-10-14 | |
850091 | 850091 | R3101_HRB10028 | R3101_HRB10028 | Aachen HRB 10028 | Aachen | R3101 | 2010-08-05 | |
2037448 | 2037448 | R3101_HRB10030 | R3101_HRB10030 | Aachen HRB 10030 | Aachen | R3101 | 2018-02-22 | |
1451320 | 1451320 | R3101_HRB10031-R1102_HRB15103 | R3101_HRB10031 | Aachen HRB 10031 | Aachen | R3101 | 2009-01-06 | 2009-04-21 |
2037449 | 2037449 | R3101_HRB10032 | R3101_HRB10032 | Aachen HRB 10032 | Aachen | R3101 | 2011-01-05 | |
1155044 | 1155044 | R3101_HRB10033 | R3101_HRB10033 | Aachen HRB 10033 | Aachen | R3101 | 2007-07-19 | |
545304 | 545304 | R3101_HRB10034 | R3101_HRB10034 | Aachen HRB 10034 | Aachen | R3101 | 2015-10-05 | |
1451322 | 1451322 | R3101_HRB10036 | R3101_HRB10036 | Aachen HRB 10036 | Aachen | R3101 | 2005-05-13 | |
1744903 | 1744903 | R3101_HRB10037 | R3101_HRB10037 | Aachen HRB 10037 | Aachen | R3101 | 2011-04-07 | |
2329713 | 2329713 | R3101_HRB10038 | R3101_HRB10038 | Aachen HRB 10038 | Aachen | R3101 | 2015-06-22 | |
850092 | 850092 | R3101_HRB10040 | R3101_HRB10040 | Aachen HRB 10040 | Aachen | R3101 | 2013-10-28 | |
1451323 | 1451323 | R3101_HRB10041 | R3101_HRB10041 | Aachen HRB 10041 | Aachen | R3101 | 2006-07-17 | |
545305 | 545305 | R3101_HRB10042 | R3101_HRB10042 | Aachen HRB 10042 | Aachen | R3101 | 2010-11-02 | |
240963 | 240963 | R3101_HRB10043-R1504_HRB14530 | R3101_HRB10043 | Aachen HRB 10043 | Aachen | R3101 | 2005-02-23 | 2011-07-28 |
2329714 | 2329714 | R3101_HRB10044 | R3101_HRB10044 | Aachen HRB 10044 | Aachen | R3101 | 2007-04-27 | |
2043619 | 2043619 | R3208_HRB12297-R3101_HRB10045 | R3101_HRB10045 | Aachen HRB 10045 | Aachen | R3101 | 2013-01-25 | |
850093 | 850093 | R3101_HRB10046 | R3101_HRB10046 | Aachen HRB 10046 | Aachen | R3101 | 2014-08-20 | |
1451324 | 1451324 | R3101_HRB10047 | R3101_HRB10047 | Aachen HRB 10047 | Aachen | R3101 | 2008-08-05 | |
240965 | 240965 | R3101_HRB10048 | R3101_HRB10048 | Aachen HRB 10048 | Aachen | R3101 | 2019-12-30 | |
2037450 | 2037450 | R3101_HRB10049 | R3101_HRB10049 | Aachen HRB 10049 | Aachen | R3101 | 2010-03-11 | |
1744904 | 1744904 | R3101_HRB1005 | R3101_HRB1005 | Aachen HRB 1005 | Aachen | R3101 | 2006-02-24 | |
1451325 | 1451325 | R3101_HRB10050 | R3101_HRB10050 | Aachen HRB 10050 | Aachen | R3101 | 2014-07-23 | |
2037451 | 2037451 | R3101_HRB10051-R1504_HRB11338-R3101_HRB16357 | R3101_HRB10051 | Aachen HRB 10051 | Aachen | R3101 | 2005-04-15 | 2005-09-16 |
2037454 | 2037454 | R3101_HRB10052 | R3101_HRB10052 | Aachen HRB 10052 | Aachen | R3101 | 2010-01-26 | |
2329715 | 2329715 | R3101_HRB10055 | R3101_HRB10055 | Aachen HRB 10055 | Aachen | R3101 | 2005-02-24 | |
2329716 | 2329716 | R3101_HRB1006 | R3101_HRB1006 | Aachen HRB 1006 | Aachen | R3101 | 2006-10-13 | |
240966 | 240966 | R3101_HRB10060 | R3101_HRB10060 | Aachen HRB 10060 | Aachen | R3101 | 2005-07-14 | |
1451326 | 1451326 | R3101_HRB10061 | R3101_HRB10061 | Aachen HRB 10061 | Aachen | R3101 | 2008-11-28 | |
2037455 | 2037455 | R3101_HRB10063 | R3101_HRB10063 | Aachen HRB 10063 | Aachen | R3101 | 2020-02-04 | |
240967 | 240967 | R3101_HRB10066 | R3101_HRB10066 | Aachen HRB 10066 | Aachen | R3101 | 2007-02-20 | |
545306 | 545306 | R3101_HRB10067 | R3101_HRB10067 | Aachen HRB 10067 | Aachen | R3101 | 2005-06-08 | |
1155045 | 1155045 | R3101_HRB10068 | R3101_HRB10068 | Aachen HRB 10068 | Aachen | R3101 | 2008-01-18 | |
850094 | 850094 | R3101_HRB10071 | R3101_HRB10071 | Aachen HRB 10071 | Aachen | R3101 | 2012-12-18 | |
1744905 | 1744905 | R3101_HRB10073 | R3101_HRB10073 | Aachen HRB 10073 | Aachen | R3101 | 2010-12-23 | |
1451327 | 1451327 | R3101_HRB10074 | R3101_HRB10074 | Aachen HRB 10074 | Aachen | R3101 | 2021-10-06 | |
240968 | 240968 | R3101_HRB10075 | R3101_HRB10075 | Aachen HRB 10075 | Aachen | R3101 | 2005-01-04 | |
2037456 | 2037456 | R3101_HRB10076 | R3101_HRB10076 | Aachen HRB 10076 | Aachen | R3101 | 2010-08-18 | |
240969 | 240969 | R3101_HRB10077 | R3101_HRB10077 | Aachen HRB 10077 | Aachen | R3101 | 2008-12-04 | |
2037457 | 2037457 | R3101_HRB1008 | R3101_HRB1008 | Aachen HRB 1008 | Aachen | R3101 | 2005-09-28 | |
545307 | 545307 | R3101_HRB10080 | R3101_HRB10080 | Aachen HRB 10080 | Aachen | R3101 | 2015-06-17 | |
240970 | 240970 | R3101_HRB10081 | R3101_HRB10081 | Aachen HRB 10081 | Aachen | R3101 | 2010-04-09 | |
2329717 | 2329717 | R3101_HRB10082 | R3101_HRB10082 | Aachen HRB 10082 | Aachen | R3101 | 2005-04-25 | |
1062428 | 1062428 | M1201_HRB80478-R3101_HRB10083-D2601_HRB175154-F1103_HRB116700B | R3101_HRB10083 | Aachen HRB 10083 | Aachen | R3101 | 2007-07-02 | 2008-08-27 |
850095 | 850095 | R3101_HRB10085 | R3101_HRB10085 | Aachen HRB 10085 | Aachen | R3101 | 2007-02-14 | |
1744906 | 1744906 | R3101_HRB10086 | R3101_HRB10086 | Aachen HRB 10086 | Aachen | R3101 | 2022-05-05 | |
850096 | 850096 | R3101_HRB10087 | R3101_HRB10087 | Aachen HRB 10087 | Aachen | R3101 | 2005-03-11 | |
1744907 | 1744907 | R3101_HRB10088-R3103_HRB4777 | R3101_HRB10088 | Aachen HRB 10088 | Aachen | R3101 | 2005-06-20 | 2006-09-26 |
1451328 | 1451328 | R3101_HRB10089 | R3101_HRB10089 | Aachen HRB 10089 | Aachen | R3101 | 2007-12-05 | |
1155046 | 1155046 | R3101_HRB10091 | R3101_HRB10091 | Aachen HRB 10091 | Aachen | R3101 | 2009-09-28 | |
2037458 | 2037458 | R3101_HRB10094 | R3101_HRB10094 | Aachen HRB 10094 | Aachen | R3101 | 2007-07-23 | |
1155047 | 1155047 | R3101_HRB10095 | R3101_HRB10095 | Aachen HRB 10095 | Aachen | R3101 | 2006-10-31 | |
1451329 | 1451329 | R3101_HRB10096 | R3101_HRB10096 | Aachen HRB 10096 | Aachen | R3101 | 2006-02-02 | |
2329718 | 2329718 | R3101_HRB10097-P3101_HRB206193 | R3101_HRB10097 | Aachen HRB 10097 | Aachen | R3101 | 2015-05-13 | 2022-01-24 |
2329720 | 2329720 | R3101_HRB10098 | R3101_HRB10098 | Aachen HRB 10098 | Aachen | R3101 | 2018-01-09 | |
1451330 | 1451330 | R3101_HRB10099 | R3101_HRB10099 | Aachen HRB 10099 | Aachen | R3101 | 2009-11-09 | |
850097 | 850097 | R3101_HRB10102 | R3101_HRB10102 | Aachen HRB 10102 | Aachen | R3101 | 2010-10-15 | |
545308 | 545308 | R3101_HRB10103 | R3101_HRB10103 | Aachen HRB 10103 | Aachen | R3101 | 2007-08-10 | |
1744909 | 1744909 | R3101_HRB10104 | R3101_HRB10104 | Aachen HRB 10104 | Aachen | R3101 | 2006-03-03 | |
240971 | 240971 | R3101_HRB10105 | R3101_HRB10105 | Aachen HRB 10105 | Aachen | R3101 | 2010-10-13 | |
2037459 | 2037459 | R3101_HRB10106 | R3101_HRB10106 | Aachen HRB 10106 | Aachen | R3101 | 2020-03-20 | |
545309 | 545309 | R3101_HRB10107 | R3101_HRB10107 | Aachen HRB 10107 | Aachen | R3101 | 2005-11-08 | |
1451331 | 1451331 | R3101_HRB10109 | R3101_HRB10109 | Aachen HRB 10109 | Aachen | R3101 | 2007-11-21 | |
545310 | 545310 | R3101_HRB10111 | R3101_HRB10111 | Aachen HRB 10111 | Aachen | R3101 | 2010-03-26 | |
1451333 | 1451333 | R3101_HRB10112-R3306_HRB63302 | R3101_HRB10112 | Aachen HRB 10112 | Aachen | R3101 | 2008-06-17 | |
545311 | 545311 | R3101_HRB10113 | R3101_HRB10113 | Aachen HRB 10113 | Aachen | R3101 | 2007-03-12 | |
2037460 | 2037460 | R3101_HRB10115 | R3101_HRB10115 | Aachen HRB 10115 | Aachen | R3101 | 2012-03-05 | |
1451334 | 1451334 | R3101_HRB10116 | R3101_HRB10116 | Aachen HRB 10116 | Aachen | R3101 | 2005-09-16 | |
545312 | 545312 | R3101_HRB10117 | R3101_HRB10117 | Aachen HRB 10117 | Aachen | R3101 | 2009-11-17 | |
240972 | 240972 | R3101_HRB10118 | R3101_HRB10118 | Aachen HRB 10118 | Aachen | R3101 | 2015-02-04 | |
545313 | 545313 | R3101_HRB10119 | R3101_HRB10119 | Aachen HRB 10119 | Aachen | R3101 | 2020-09-03 | |
545314 | 545314 | R3101_HRB10120 | R3101_HRB10120 | Aachen HRB 10120 | Aachen | R3101 | 2009-10-08 | |
2329721 | 2329721 | R3101_HRB10121 | R3101_HRB10121 | Aachen HRB 10121 | Aachen | R3101 | 2008-04-07 | |
2329722 | 2329722 | R3101_HRB10122 | R3101_HRB10122 | Aachen HRB 10122 | Aachen | R3101 | 2015-03-31 | |
545315 | 545315 | R3101_HRB10123 | R3101_HRB10123 | Aachen HRB 10123 | Aachen | R3101 | 2017-12-18 | |
1744910 | 1744910 | R3101_HRB10124 | R3101_HRB10124 | Aachen HRB 10124 | Aachen | R3101 | 2005-12-13 | |
2037461 | 2037461 | R3101_HRB10125 | R3101_HRB10125 | Aachen HRB 10125 | Aachen | R3101 | 2016-06-06 | |
850098 | 850098 | R3101_HRB10126 | R3101_HRB10126 | Aachen HRB 10126 | Aachen | R3101 | 2022-01-25 | |
2329723 | 2329723 | R3101_HRB10127 | R3101_HRB10127 | Aachen HRB 10127 | Aachen | R3101 | 2005-02-18 | |
2037462 | 2037462 | R3101_HRB10129 | R3101_HRB10129 | Aachen HRB 10129 | Aachen | R3101 | 2006-01-20 | |
1451335 | 1451335 | R3101_HRB10130 | R3101_HRB10130 | Aachen HRB 10130 | Aachen | R3101 | 2011-06-06 |
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" );