ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by nativeReferenceNumber
This data as json, CSV (advanced)
Link | rowid | companyId | stdRefNo | nativeReferenceNumber ▼ | courtName | courtCode | referenceNumberFirstSeen | validTill |
---|---|---|---|---|---|---|---|---|
1451353 | 1451353 | R3101_HRB10265-W1215_HRB12165 | R3101_HRB10265 | Aachen HRB 10265 | Aachen | R3101 | 2006-06-19 | 2010-05-26 |
240986 | 240986 | R3101_HRB10266 | R3101_HRB10266 | Aachen HRB 10266 | Aachen | R3101 | 2005-07-25 | |
2037474 | 2037474 | R3101_HRB10267 | R3101_HRB10267 | Aachen HRB 10267 | Aachen | R3101 | 2007-02-14 | |
240987 | 240987 | R3101_HRB10268 | R3101_HRB10268 | Aachen HRB 10268 | Aachen | R3101 | 2007-08-07 | |
2037475 | 2037475 | R3101_HRB10270 | R3101_HRB10270 | Aachen HRB 10270 | Aachen | R3101 | 2006-08-14 | |
850113 | 850113 | R3101_HRB10273 | R3101_HRB10273 | Aachen HRB 10273 | Aachen | R3101 | 2005-11-09 | |
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 |
850114 | 850114 | R3101_HRB10278 | R3101_HRB10278 | Aachen HRB 10278 | Aachen | R3101 | 2013-11-13 | |
850115 | 850115 | R3101_HRB10279 | R3101_HRB10279 | Aachen HRB 10279 | Aachen | R3101 | 2007-08-03 | |
545328 | 545328 | R3101_HRB10280 | R3101_HRB10280 | Aachen HRB 10280 | Aachen | R3101 | 2005-08-31 | |
240992 | 240992 | R3101_HRB10281 | R3101_HRB10281 | Aachen HRB 10281 | Aachen | R3101 | 2010-03-31 | |
2165052 | 2165052 | D3201_HRB4358-R3101_HRB10282 | R3101_HRB10282 | Aachen HRB 10282 | Aachen | R3101 | 2007-09-11 | |
545329 | 545329 | R3101_HRB10283 | R3101_HRB10283 | Aachen HRB 10283 | Aachen | R3101 | 2010-08-31 | |
545330 | 545330 | R3101_HRB10284 | R3101_HRB10284 | Aachen HRB 10284 | Aachen | R3101 | 2005-09-08 | |
240993 | 240993 | R3101_HRB10285 | R3101_HRB10285 | Aachen HRB 10285 | Aachen | R3101 | 2009-07-01 | |
2329739 | 2329739 | R3101_HRB10286-R1504_HRB16650 | R3101_HRB10286 | Aachen HRB 10286 | Aachen | R3101 | 2011-01-05 | 2015-07-09 |
1451355 | 1451355 | R3101_HRB10287 | R3101_HRB10287 | Aachen HRB 10287 | Aachen | R3101 | 2010-01-26 | |
545331 | 545331 | R3101_HRB10289 | R3101_HRB10289 | Aachen HRB 10289 | Aachen | R3101 | 2006-06-30 | |
1744924 | 1744924 | R3101_HRB10291 | R3101_HRB10291 | Aachen HRB 10291 | Aachen | R3101 | 2022-02-08 | |
240994 | 240994 | R3101_HRB10292 | R3101_HRB10292 | Aachen HRB 10292 | Aachen | R3101 | 2007-09-17 | |
1454184 | 1454184 | R3103_HRB5817-R3101_HRB10293-R3101_HRB20581 | R3101_HRB10293 | Aachen HRB 10293 | Aachen | R3101 | 2010-04-15 | 2016-08-03 |
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 | |
2037476 | 2037476 | R3101_HRB10297 | R3101_HRB10297 | Aachen HRB 10297 | Aachen | R3101 | 2013-07-29 | |
2329741 | 2329741 | R3101_HRB10298 | R3101_HRB10298 | Aachen HRB 10298 | Aachen | R3101 | 2007-10-31 | |
240997 | 240997 | R3101_HRB10300-M1114_HRB44634-M1103_HRB92939 | R3101_HRB10300 | Aachen HRB 10300 | Aachen | R3101 | 2006-10-05 | 2010-03-03 |
1744925 | 1744925 | R3101_HRB10301 | R3101_HRB10301 | Aachen HRB 10301 | Aachen | R3101 | 2011-02-08 | |
2037477 | 2037477 | R3101_HRB10303-R1504_HRB13027 | R3101_HRB10303 | Aachen HRB 10303 | Aachen | R3101 | 2005-01-31 | 2009-02-03 |
1744926 | 1744926 | R3101_HRB10304-R1504_HRB17878 | R3101_HRB10304 | Aachen HRB 10304 | Aachen | R3101 | 2010-07-22 | 2017-10-02 |
241000 | 241000 | R3101_HRB10306 | R3101_HRB10306 | Aachen HRB 10306 | Aachen | R3101 | 2006-05-11 | |
1744928 | 1744928 | R3101_HRB10308 | R3101_HRB10308 | Aachen HRB 10308 | Aachen | R3101 | 2008-05-30 | |
850116 | 850116 | R3101_HRB10310 | R3101_HRB10310 | Aachen HRB 10310 | Aachen | R3101 | 2011-11-21 | |
850117 | 850117 | R3101_HRB10312 | R3101_HRB10312 | Aachen HRB 10312 | Aachen | R3101 | 2006-07-11 | |
2329742 | 2329742 | R3101_HRB10313 | R3101_HRB10313 | Aachen HRB 10313 | Aachen | R3101 | 2008-04-07 | |
545332 | 545332 | R3101_HRB10314 | R3101_HRB10314 | Aachen HRB 10314 | Aachen | R3101 | 2022-03-10 | |
850118 | 850118 | R3101_HRB10316 | R3101_HRB10316 | Aachen HRB 10316 | Aachen | R3101 | 2006-01-16 | |
1155062 | 1155062 | R3101_HRB10319 | R3101_HRB10319 | Aachen HRB 10319 | Aachen | R3101 | 2005-08-24 | |
850119 | 850119 | R3101_HRB10320 | R3101_HRB10320 | Aachen HRB 10320 | Aachen | R3101 | 2008-04-22 | |
2329743 | 2329743 | R3101_HRB10321 | R3101_HRB10321 | Aachen HRB 10321 | Aachen | R3101 | 2005-03-10 | |
1451356 | 1451356 | R3101_HRB10322 | R3101_HRB10322 | Aachen HRB 10322 | Aachen | R3101 | 2005-05-04 | |
241001 | 241001 | R3101_HRB10323 | R3101_HRB10323 | Aachen HRB 10323 | Aachen | R3101 | 2007-12-07 | |
850120 | 850120 | R3101_HRB10324 | R3101_HRB10324 | Aachen HRB 10324 | Aachen | R3101 | 2014-12-30 | |
1155063 | 1155063 | R3101_HRB10325-R1504_HRB12852 | R3101_HRB10325 | Aachen HRB 10325 | Aachen | R3101 | 2006-03-02 | 2008-10-01 |
2037479 | 2037479 | R3101_HRB10326 | R3101_HRB10326 | Aachen HRB 10326 | Aachen | R3101 | 2010-08-26 | |
1744929 | 1744929 | R3101_HRB10327 | R3101_HRB10327 | Aachen HRB 10327 | Aachen | R3101 | 2012-07-16 | |
2037480 | 2037480 | R3101_HRB10328 | R3101_HRB10328 | Aachen HRB 10328 | Aachen | R3101 | 2007-06-05 | |
1155065 | 1155065 | R3101_HRB10329 | R3101_HRB10329 | Aachen HRB 10329 | Aachen | R3101 | 2005-05-18 | |
2329744 | 2329744 | R3101_HRB10330 | R3101_HRB10330 | Aachen HRB 10330 | Aachen | R3101 | 2010-08-04 | |
2329745 | 2329745 | R3101_HRB10331 | R3101_HRB10331 | Aachen HRB 10331 | Aachen | R3101 | 2010-08-30 | |
1451357 | 1451357 | R3101_HRB10332 | R3101_HRB10332 | Aachen HRB 10332 | Aachen | R3101 | 2011-09-27 | |
2037481 | 2037481 | R3101_HRB10333 | R3101_HRB10333 | Aachen HRB 10333 | Aachen | R3101 | 2011-06-27 | |
1155066 | 1155066 | R3101_HRB10334 | R3101_HRB10334 | Aachen HRB 10334 | Aachen | R3101 | 2005-08-04 | |
2037482 | 2037482 | R3101_HRB10335 | R3101_HRB10335 | Aachen HRB 10335 | Aachen | R3101 | 2006-05-08 | |
2329746 | 2329746 | R3101_HRB10336 | R3101_HRB10336 | Aachen HRB 10336 | Aachen | R3101 | 2021-03-12 | |
850121 | 850121 | R3101_HRB10339 | R3101_HRB10339 | Aachen HRB 10339 | Aachen | R3101 | 2020-08-05 | |
850122 | 850122 | R3101_HRB10340 | R3101_HRB10340 | Aachen HRB 10340 | Aachen | R3101 | 2010-12-01 | |
545333 | 545333 | R3101_HRB10341 | R3101_HRB10341 | Aachen HRB 10341 | Aachen | R3101 | 2007-02-15 | |
545334 | 545334 | R3101_HRB10342 | R3101_HRB10342 | Aachen HRB 10342 | Aachen | R3101 | 2010-03-22 | |
2329747 | 2329747 | R3101_HRB10343 | R3101_HRB10343 | Aachen HRB 10343 | Aachen | R3101 | 2008-04-18 | |
1451358 | 1451358 | R3101_HRB10344 | R3101_HRB10344 | Aachen HRB 10344 | Aachen | R3101 | 2007-11-13 | |
2429950 | 2429950 | R3101_HRB10346 | R3101_HRB10346 | Aachen HRB 10346 | Aachen | R3101 | 2009-12-23 | |
1744930 | 1744930 | R3101_HRB10347 | R3101_HRB10347 | Aachen HRB 10347 | Aachen | R3101 | 2005-08-16 | |
2037483 | 2037483 | R3101_HRB10348 | R3101_HRB10348 | Aachen HRB 10348 | Aachen | R3101 | 2007-10-01 | |
1744931 | 1744931 | R3101_HRB10349 | R3101_HRB10349 | Aachen HRB 10349 | Aachen | R3101 | 2015-01-13 | |
1451359 | 1451359 | R3101_HRB10350 | R3101_HRB10350 | Aachen HRB 10350 | Aachen | R3101 | 2013-10-15 | |
2329748 | 2329748 | R3101_HRB10351 | R3101_HRB10351 | Aachen HRB 10351 | Aachen | R3101 | 2010-10-18 | |
2329749 | 2329749 | R3101_HRB10352 | R3101_HRB10352 | Aachen HRB 10352 | Aachen | R3101 | 2009-12-16 | |
241002 | 241002 | R3101_HRB10354 | R3101_HRB10354 | Aachen HRB 10354 | Aachen | R3101 | 2010-06-18 | |
545335 | 545335 | R3101_HRB10355 | R3101_HRB10355 | Aachen HRB 10355 | Aachen | R3101 | 2005-06-07 | |
1155067 | 1155067 | R3101_HRB10356 | R3101_HRB10356 | Aachen HRB 10356 | Aachen | R3101 | 2005-05-23 | |
2329750 | 2329750 | R3101_HRB10357-R3103_HRB7863 | R3101_HRB10357 | Aachen HRB 10357 | Aachen | R3101 | 2016-02-03 | 2018-08-01 |
1744932 | 1744932 | R3101_HRB10358 | R3101_HRB10358 | Aachen HRB 10358 | Aachen | R3101 | 2005-04-28 | |
2329752 | 2329752 | R3101_HRB10359 | R3101_HRB10359 | Aachen HRB 10359 | Aachen | R3101 | 2006-03-14 | |
850123 | 850123 | R3101_HRB10360 | R3101_HRB10360 | Aachen HRB 10360 | Aachen | R3101 | 2016-01-06 | |
850124 | 850124 | R3101_HRB10361 | R3101_HRB10361 | Aachen HRB 10361 | Aachen | R3101 | 2018-01-03 | |
1155068 | 1155068 | R3101_HRB10364 | R3101_HRB10364 | Aachen HRB 10364 | Aachen | R3101 | 2009-02-03 | |
241003 | 241003 | R3101_HRB10365 | R3101_HRB10365 | Aachen HRB 10365 | Aachen | R3101 | 2019-03-05 | |
545336 | 545336 | R3101_HRB10366 | R3101_HRB10366 | Aachen HRB 10366 | Aachen | R3101 | 2014-12-22 | |
1744933 | 1744933 | R3101_HRB10367 | R3101_HRB10367 | Aachen HRB 10367 | Aachen | R3101 | 2012-10-02 | |
2329753 | 2329753 | R3101_HRB10368 | R3101_HRB10368 | Aachen HRB 10368 | Aachen | R3101 | 2006-12-06 | |
850125 | 850125 | R3101_HRB10369 | R3101_HRB10369 | Aachen HRB 10369 | Aachen | R3101 | 2006-07-26 | |
1744934 | 1744934 | R3101_HRB10370 | R3101_HRB10370 | Aachen HRB 10370 | Aachen | R3101 | 2006-01-18 | |
1744935 | 1744935 | R3101_HRB10371 | R3101_HRB10371 | Aachen HRB 10371 | Aachen | R3101 | 2005-12-22 | |
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 | |
2037484 | 2037484 | R3101_HRB10376 | R3101_HRB10376 | Aachen HRB 10376 | Aachen | R3101 | 2006-01-06 | |
1155069 | 1155069 | R3101_HRB10377 | R3101_HRB10377 | Aachen HRB 10377 | Aachen | R3101 | 2010-07-02 | |
1451360 | 1451360 | R3101_HRB10378 | R3101_HRB10378 | Aachen HRB 10378 | Aachen | R3101 | 2005-08-29 | |
2037485 | 2037485 | R3101_HRB10379 | R3101_HRB10379 | Aachen HRB 10379 | Aachen | R3101 | 2008-06-25 | |
1744936 | 1744936 | R3101_HRB10380 | R3101_HRB10380 | Aachen HRB 10380 | Aachen | R3101 | 2005-01-17 | |
1155070 | 1155070 | R3101_HRB10381 | R3101_HRB10381 | Aachen HRB 10381 | Aachen | R3101 | 2006-02-13 | |
2040200 | 2040200 | R3103_HRB4949-R3101_HRB10382 | R3101_HRB10382 | Aachen HRB 10382 | Aachen | R3101 | 2006-05-09 | 2006-05-10 |
749382 | 749382 | M1114_HRB44660-R3101_HRB10383-M1103_HRB92787 | R3101_HRB10383 | Aachen HRB 10383 | Aachen | R3101 | 2010-03-22 | 2014-01-03 |
1744937 | 1744937 | R3101_HRB10384 | R3101_HRB10384 | Aachen HRB 10384 | Aachen | R3101 | 2010-11-22 | |
545337 | 545337 | R3101_HRB10385 | R3101_HRB10385 | Aachen HRB 10385 | Aachen | R3101 | 2020-03-12 | |
2329754 | 2329754 | R3101_HRB10386 | R3101_HRB10386 | Aachen HRB 10386 | Aachen | R3101 | 2015-10-26 | |
1744938 | 1744938 | R3101_HRB10391 | R3101_HRB10391 | Aachen HRB 10391 | Aachen | R3101 | 2010-06-18 | |
850126 | 850126 | R3101_HRB10392 | R3101_HRB10392 | Aachen HRB 10392 | Aachen | R3101 | 2011-10-10 |
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" );