ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by stdRefNo
This data as json, CSV (advanced)
Suggested facets: referenceNumberFirstSeen (date)
These facets timed out: validTill
Link | rowid | companyId | stdRefNo ▼ | nativeReferenceNumber | courtName | courtCode | referenceNumberFirstSeen | validTill |
---|---|---|---|---|---|---|---|---|
610243 | 610243 | B1601_HRB100001 | B1601_HRB100001 | Mannheim HRB 100001 | Mannheim | B1601 | 2007-07-10 | |
24 | 24 | B1601_HRB100003 | B1601_HRB100003 | Mannheim HRB 100003 | Mannheim | B1601 | 2007-07-09 | |
25 | 25 | B1601_HRB10002-M1201_HRB87203 | B1601_HRB10002 | Mannheim HRB 10002 | Mannheim | B1601 | 2009-03-16 | 2010-01-18 |
305545 | 305545 | B1601_HRB100022 | B1601_HRB100022 | Mannheim HRB 100022 | Mannheim | B1601 | 2007-06-26 | |
915058 | 915058 | B1601_HRB100027 | B1601_HRB100027 | Mannheim HRB 100027 | Mannheim | B1601 | 2007-01-30 | |
1513388 | 1513388 | B1601_HRB100028 | B1601_HRB100028 | Mannheim HRB 100028 | Mannheim | B1601 | 2007-03-08 | |
1558694 | 1558694 | D2601_HRB166156-B1601_HRB10003 | B1601_HRB10003 | Mannheim HRB 10003 | Mannheim | B1601 | 2007-02-20 | |
1806981 | 1806981 | B1601_HRB100030 | B1601_HRB100030 | Mannheim HRB 100030 | Mannheim | B1601 | 2007-07-09 | |
1558692 | 1558692 | D2601_HRB166134-B1601_HRB10004 | B1601_HRB10004 | Mannheim HRB 10004 | Mannheim | B1601 | 2007-02-16 | |
610244 | 610244 | B1601_HRB10005 | B1601_HRB10005 | Mannheim HRB 10005 | Mannheim | B1601 | 2007-03-22 | |
1806982 | 1806982 | B1601_HRB100050 | B1601_HRB100050 | Mannheim HRB 100050 | Mannheim | B1601 | 2007-12-18 | |
610245 | 610245 | B1601_HRB100059-M1201_HRB102381 | B1601_HRB100059 | Mannheim HRB 100059 | Mannheim | B1601 | 2007-05-22 | 2015-06-10 |
2398973 | 2398973 | D2601_HRB166579-B1601_HRB10006 | B1601_HRB10006 | Mannheim HRB 10006 | Mannheim | B1601 | 2007-03-20 | |
915059 | 915059 | B1601_HRB100069-B2609_HRB756525 | B1601_HRB100069 | Mannheim HRB 100069 | Mannheim | B1601 | 2009-12-07 | 2016-04-21 |
1852336 | 1852336 | D2601_HRB166990-B1601_HRB10007 | B1601_HRB10007 | Mannheim HRB 10007 | Mannheim | B1601 | 2007-04-03 | |
1219909 | 1219909 | B1601_HRB100070 | B1601_HRB100070 | Mannheim HRB 100070 | Mannheim | B1601 | 2015-10-28 | |
2398969 | 2398969 | D2601_HRB166540-B1601_HRB10008 | B1601_HRB10008 | Mannheim HRB 10008 | Mannheim | B1601 | 2007-03-15 | |
915061 | 915061 | B1601_HRB100084 | B1601_HRB100084 | Mannheim HRB 100084 | Mannheim | B1601 | 2007-07-23 | |
2099529 | 2099529 | B1601_HRB100087 | B1601_HRB100087 | Mannheim HRB 100087 | Mannheim | B1601 | 2018-09-24 | |
915062 | 915062 | B1601_HRB100088 | B1601_HRB100088 | Mannheim HRB 100088 | Mannheim | B1601 | 2015-07-06 | |
1852192 | 1852192 | D2601_HRB166227-B1601_HRB10009-B1601_HRB743703 | B1601_HRB10009 | Mannheim HRB 10009 | Mannheim | B1601 | 2007-03-12 | 2022-04-26 |
610247 | 610247 | B1601_HRB100094-D2102_HRB22709 | B1601_HRB100094 | Mannheim HRB 100094 | Mannheim | B1601 | 2007-02-12 | 2007-06-27 |
27 | 27 | B1601_HRB100097 | B1601_HRB100097 | Mannheim HRB 100097 | Mannheim | B1601 | 2008-02-29 | |
47314 | 47314 | D2601_HRB166539-B1601_HRB10010 | B1601_HRB10010 | Mannheim HRB 10010 | Mannheim | B1601 | 2007-03-20 | |
2391415 | 2391415 | B1601_HRB100106 | B1601_HRB100106 | Mannheim HRB 100106 | Mannheim | B1601 | 2009-05-05 | |
1806983 | 1806983 | B1601_HRB10011 | B1601_HRB10011 | Mannheim HRB 10011 | Mannheim | B1601 | 2008-11-14 | |
1219910 | 1219910 | B1601_HRB100118 | B1601_HRB100118 | Mannheim HRB 100118 | Mannheim | B1601 | 2015-11-06 | |
610249 | 610249 | B1601_HRB10012 | B1601_HRB10012 | Mannheim HRB 10012 | Mannheim | B1601 | 2020-01-07 | |
915063 | 915063 | B1601_HRB100123 | B1601_HRB100123 | Mannheim HRB 100123 | Mannheim | B1601 | 2007-02-22 | |
657205 | 657205 | D2601_HRB167484-B1601_HRB10013 | B1601_HRB10013 | Mannheim HRB 10013 | Mannheim | B1601 | 2007-04-24 | |
1513389 | 1513389 | B1601_HRB100131 | B1601_HRB100131 | Mannheim HRB 100131 | Mannheim | B1601 | 2013-10-30 | |
1806984 | 1806984 | B1601_HRB100132 | B1601_HRB100132 | Mannheim HRB 100132 | Mannheim | B1601 | 2013-04-24 | |
1219911 | 1219911 | B1601_HRB100134 | B1601_HRB100134 | Mannheim HRB 100134 | Mannheim | B1601 | 2007-05-16 | |
915064 | 915064 | B1601_HRB100135 | B1601_HRB100135 | Mannheim HRB 100135 | Mannheim | B1601 | 2014-12-29 | |
610250 | 610250 | B1601_HRB100138 | B1601_HRB100138 | Mannheim HRB 100138 | Mannheim | B1601 | 2008-07-29 | |
1852173 | 1852173 | D2601_HRB166133-B1601_HRB10014 | B1601_HRB10014 | Mannheim HRB 10014 | Mannheim | B1601 | 2007-02-16 | |
28 | 28 | B1601_HRB100145 | B1601_HRB100145 | Mannheim HRB 100145 | Mannheim | B1601 | 2007-08-01 | |
2099530 | 2099530 | B1601_HRB100147 | B1601_HRB100147 | Mannheim HRB 100147 | Mannheim | B1601 | 2008-04-16 | |
29 | 29 | B1601_HRB10015 | B1601_HRB10015 | Mannheim HRB 10015 | Mannheim | B1601 | 2008-05-06 | |
30 | 30 | B1601_HRB100152 | B1601_HRB100152 | Mannheim HRB 100152 | Mannheim | B1601 | 2012-10-30 | |
1806985 | 1806985 | B1601_HRB100157 | B1601_HRB100157 | Mannheim HRB 100157 | Mannheim | B1601 | 2010-07-28 | |
610251 | 610251 | B1601_HRB100159 | B1601_HRB100159 | Mannheim HRB 100159 | Mannheim | B1601 | 2007-11-15 | |
352333 | 352333 | D2601_HRB166680-B1601_HRB10016 | B1601_HRB10016 | Mannheim HRB 10016 | Mannheim | B1601 | 2007-03-20 | |
1513390 | 1513390 | B1601_HRB100162 | B1601_HRB100162 | Mannheim HRB 100162 | Mannheim | B1601 | 2007-03-28 | |
2099531 | 2099531 | B1601_HRB100164 | B1601_HRB100164 | Mannheim HRB 100164 | Mannheim | B1601 | 2008-07-22 | |
1806986 | 1806986 | B1601_HRB100165 | B1601_HRB100165 | Mannheim HRB 100165 | Mannheim | B1601 | 2011-04-05 | |
610252 | 610252 | B1601_HRB10017 | B1601_HRB10017 | Mannheim HRB 10017 | Mannheim | B1601 | 2007-04-04 | |
1219912 | 1219912 | B1601_HRB10018 | B1601_HRB10018 | Mannheim HRB 10018 | Mannheim | B1601 | 2008-06-03 | |
31 | 31 | B1601_HRB100194 | B1601_HRB100194 | Mannheim HRB 100194 | Mannheim | B1601 | 2007-09-19 | |
1513391 | 1513391 | B1601_HRB100196 | B1601_HRB100196 | Mannheim HRB 100196 | Mannheim | B1601 | 2007-09-20 | |
1806987 | 1806987 | B1601_HRB100197 | B1601_HRB100197 | Mannheim HRB 100197 | Mannheim | B1601 | 2020-11-24 | |
1806988 | 1806988 | B1601_HRB10020 | B1601_HRB10020 | Mannheim HRB 10020 | Mannheim | B1601 | 2008-08-11 | |
1219913 | 1219913 | B1601_HRB100203 | B1601_HRB100203 | Mannheim HRB 100203 | Mannheim | B1601 | 2007-03-05 | |
2099532 | 2099532 | B1601_HRB10022 | B1601_HRB10022 | Mannheim HRB 10022 | Mannheim | B1601 | 2015-08-24 | |
32 | 32 | B1601_HRB100220 | B1601_HRB100220 | Mannheim HRB 100220 | Mannheim | B1601 | 2010-08-03 | |
1806989 | 1806989 | B1601_HRB100225 | B1601_HRB100225 | Mannheim HRB 100225 | Mannheim | B1601 | 2013-08-19 | |
2099533 | 2099533 | B1601_HRB10023 | B1601_HRB10023 | Mannheim HRB 10023 | Mannheim | B1601 | 2008-07-10 | |
1513392 | 1513392 | B1601_HRB100231 | B1601_HRB100231 | Mannheim HRB 100231 | Mannheim | B1601 | 2020-07-29 | |
1806990 | 1806990 | B1601_HRB100235 | B1601_HRB100235 | Mannheim HRB 100235 | Mannheim | B1601 | 2008-06-03 | |
610253 | 610253 | B1601_HRB10024 | B1601_HRB10024 | Mannheim HRB 10024 | Mannheim | B1601 | 2012-07-20 | |
1513393 | 1513393 | B1601_HRB10025-F1103_HRB195065B | B1601_HRB10025 | Mannheim HRB 10025 | Mannheim | B1601 | 2013-12-13 | 2018-04-03 |
1219914 | 1219914 | B1601_HRB10026 | B1601_HRB10026 | Mannheim HRB 10026 | Mannheim | B1601 | 2016-08-12 | |
1513395 | 1513395 | B1601_HRB100265 | B1601_HRB100265 | Mannheim HRB 100265 | Mannheim | B1601 | 2007-10-09 | |
915065 | 915065 | B1601_HRB100270 | B1601_HRB100270 | Mannheim HRB 100270 | Mannheim | B1601 | 2009-03-25 | |
305546 | 305546 | B1601_HRB100272 | B1601_HRB100272 | Mannheim HRB 100272 | Mannheim | B1601 | 2009-10-22 | |
1513396 | 1513396 | B1601_HRB10028 | B1601_HRB10028 | Mannheim HRB 10028 | Mannheim | B1601 | 2008-05-09 | |
1806991 | 1806991 | B1601_HRB100285-F1103_HRB114415B-F1103_HRB114415 | B1601_HRB100285 | Mannheim HRB 100285 | Mannheim | B1601 | 2007-03-12 | 2008-07-14 |
610254 | 610254 | B1601_HRB100288 | B1601_HRB100288 | Mannheim HRB 100288 | Mannheim | B1601 | 2007-02-15 | |
2059611 | 2059611 | T2304_HRB40722-B1601_HRB10029 | B1601_HRB10029 | Mannheim HRB 10029 | Mannheim | B1601 | 2007-02-08 | |
1219915 | 1219915 | B1601_HRB100294 | B1601_HRB100294 | Mannheim HRB 100294 | Mannheim | B1601 | 2007-05-10 | |
305547 | 305547 | B1601_HRB10030 | B1601_HRB10030 | Mannheim HRB 10030 | Mannheim | B1601 | 2009-04-03 | |
305548 | 305548 | B1601_HRB100302 | B1601_HRB100302 | Mannheim HRB 100302 | Mannheim | B1601 | 2007-03-14 | |
33 | 33 | B1601_HRB100306 | B1601_HRB100306 | Mannheim HRB 100306 | Mannheim | B1601 | 2008-02-05 | |
657051 | 657051 | D2601_HRB166536-B1601_HRB10031 | B1601_HRB10031 | Mannheim HRB 10031 | Mannheim | B1601 | 2007-04-03 | |
962196 | 962196 | D2601_HRB166623-B1601_HRB10032 | B1601_HRB10032 | Mannheim HRB 10032 | Mannheim | B1601 | 2007-03-12 | |
1806993 | 1806993 | B1601_HRB100326 | B1601_HRB100326 | Mannheim HRB 100326 | Mannheim | B1601 | 2010-08-04 | |
305549 | 305549 | B1601_HRB100327 | B1601_HRB100327 | Mannheim HRB 100327 | Mannheim | B1601 | 2020-07-31 | |
2391416 | 2391416 | B1601_HRB10033 | B1601_HRB10033 | Mannheim HRB 10033 | Mannheim | B1601 | 2008-07-04 | |
305550 | 305550 | B1601_HRB100330 | B1601_HRB100330 | Mannheim HRB 100330 | Mannheim | B1601 | 2010-02-25 | |
2099534 | 2099534 | B1601_HRB100332 | B1601_HRB100332 | Mannheim HRB 100332 | Mannheim | B1601 | 2010-01-14 | |
1558998 | 1558998 | D2601_HRB167915-B1601_HRB10034 | B1601_HRB10034 | Mannheim HRB 10034 | Mannheim | B1601 | 2007-06-06 | |
1513397 | 1513397 | B1601_HRB100341 | B1601_HRB100341 | Mannheim HRB 100341 | Mannheim | B1601 | 2013-09-11 | |
2099535 | 2099535 | B1601_HRB100343 | B1601_HRB100343 | Mannheim HRB 100343 | Mannheim | B1601 | 2013-09-17 | |
610255 | 610255 | B1601_HRB10035 | B1601_HRB10035 | Mannheim HRB 10035 | Mannheim | B1601 | 2007-07-26 | |
915066 | 915066 | B1601_HRB10036 | B1601_HRB10036 | Mannheim HRB 10036 | Mannheim | B1601 | 2019-02-28 | |
610256 | 610256 | B1601_HRB100360 | B1601_HRB100360 | Mannheim HRB 100360 | Mannheim | B1601 | 2014-09-17 | |
1219916 | 1219916 | B1601_HRB100361 | B1601_HRB100361 | Mannheim HRB 100361 | Mannheim | B1601 | 2008-01-09 | |
1806994 | 1806994 | B1601_HRB100369 | B1601_HRB100369 | Mannheim HRB 100369 | Mannheim | B1601 | 2010-08-30 | |
1513398 | 1513398 | B1601_HRB10037 | B1601_HRB10037 | Mannheim HRB 10037 | Mannheim | B1601 | 2007-02-23 | |
1513399 | 1513399 | B1601_HRB100372 | B1601_HRB100372 | Mannheim HRB 100372 | Mannheim | B1601 | 2006-12-27 | |
1513400 | 1513400 | B1601_HRB10038 | B1601_HRB10038 | Mannheim HRB 10038 | Mannheim | B1601 | 2009-01-30 | |
34 | 34 | B1601_HRB100381 | B1601_HRB100381 | Mannheim HRB 100381 | Mannheim | B1601 | 2007-06-06 | |
305551 | 305551 | B1601_HRB100384 | B1601_HRB100384 | Mannheim HRB 100384 | Mannheim | B1601 | 2009-07-27 | |
915067 | 915067 | B1601_HRB10039 | B1601_HRB10039 | Mannheim HRB 10039 | Mannheim | B1601 | 2007-01-30 | |
2099536 | 2099536 | B1601_HRB10040-M1103_HRB94875 | B1601_HRB10040 | Mannheim HRB 10040 | Mannheim | B1601 | 2007-05-22 | 2015-12-07 |
610257 | 610257 | B1601_HRB100404 | B1601_HRB100404 | Mannheim HRB 100404 | Mannheim | B1601 | 2010-02-15 | |
915068 | 915068 | B1601_HRB100407 | B1601_HRB100407 | Mannheim HRB 100407 | Mannheim | B1601 | 2009-12-17 | |
2099538 | 2099538 | B1601_HRB10041 | B1601_HRB10041 | Mannheim HRB 10041 | Mannheim | B1601 | 2009-03-12 | |
915069 | 915069 | B1601_HRB100414 | B1601_HRB100414 | Mannheim HRB 100414 | Mannheim | B1601 | 2011-05-12 | |
305552 | 305552 | B1601_HRB10042-T3104_HRB61605 | B1601_HRB10042 | Mannheim HRB 10042 | Mannheim | B1601 | 2008-02-04 | 2009-06-29 |
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" );