ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by courtName descending
This data as json, CSV (advanced)
Suggested facets: referenceNumberFirstSeen (date)
These facets timed out: validTill
Link | rowid | companyId | stdRefNo | nativeReferenceNumber | courtName ▲ | courtCode | referenceNumberFirstSeen | validTill |
---|---|---|---|---|---|---|---|---|
1604 | 1604 | B1601_HRB337669-T3403_HRB30508 | T3403_HRB30508 | Zweibrücken HRB 30508 | Zweibrücken | T3403 | 2009-06-25 | |
3530 | 3530 | B1601_HRB702199-T3403_HRB30368-T2408_HRB44085 | T3403_HRB30368 | Zweibrücken HRB 30368 | Zweibrücken | T3403 | 2008-09-01 | 2017-12-12 |
3719 | 3719 | B1601_HRB703659-T3403_HRB31710 | T3403_HRB31710 | Zweibrücken HRB 31710 | Zweibrücken | T3403 | 2017-07-20 | |
4798 | 4798 | B1601_HRB712004-T3403_HRB31061 | T3403_HRB31061 | Zweibrücken HRB 31061 | Zweibrücken | T3403 | 2013-05-27 | |
6439 | 6439 | B1601_HRB726178-T3403_HRB31841 | T3403_HRB31841 | Zweibrücken HRB 31841 | Zweibrücken | T3403 | 2018-03-20 | |
7541 | 7541 | B1601_HRB735572-T3403_HRB32312-T3201_HRB33303 | T3403_HRB32312 | Zweibrücken HRB 32312 | Zweibrücken | T3403 | 2020-06-19 | 2021-10-22 |
12139 | 12139 | B2609_HRB264547-T3403_HRB31293-V1109_HRB106007 | T3403_HRB31293 | Zweibrücken HRB 31293 | Zweibrücken | T3403 | 2015-02-04 | 2019-12-18 |
20783 | 20783 | B2609_HRB771097-T3403_HRB32483 | T3403_HRB32483 | Zweibrücken HRB 32483 | Zweibrücken | T3403 | 2021-03-29 | |
30754 | 30754 | B8536_HRB710467-T3403_HRB31165 | T3403_HRB31165 | Zweibrücken HRB 31165 | Zweibrücken | T3403 | 2014-03-03 | |
49444 | 49444 | D2601_HRB181508-T3403_HRB23659 | T3403_HRB23659 | Zweibrücken HRB 23659 | Zweibrücken | T3403 | 2009-09-24 | |
89080 | 89080 | F1103_HRB124636B-T3403_HRB31106 | T3403_HRB31106 | Zweibrücken HRB 31106 | Zweibrücken | T3403 | 2013-09-02 | |
104211 | 104211 | F1103_HRB32268B-T3403_HRB31078 | T3403_HRB31078 | Zweibrücken HRB 31078 | Zweibrücken | T3403 | 2013-07-04 | |
109189 | 109189 | G1103_HRB10374CB-T3403_HRB32766 | T3403_HRB32766 | Zweibrücken HRB 32766 | Zweibrücken | T3403 | 2022-06-07 | |
136620 | 136620 | M1103_HRB61997-T3403_HRB30736 | T3403_HRB30736 | Zweibrücken HRB 30736 | Zweibrücken | T3403 | 2011-01-13 | |
137632 | 137632 | M1103_HRB89174-T3403_HRB32050 | T3403_HRB32050 | Zweibrücken HRB 32050 | Zweibrücken | T3403 | 2019-02-28 | |
143485 | 143485 | M1201_HRB116253-T3403_HRB32490 | T3403_HRB32490 | Zweibrücken HRB 32490 | Zweibrücken | T3403 | 2021-04-12 | |
162280 | 162280 | M1906_HRB31807-T3403_HRB32410-T3403_HRB32410UNT | T3403_HRB32410 | Zweibrücken HRB 32410 | Zweibrücken | T3403 | 2020-12-02 | |
170138 | 170138 | P2305_HRB100929-T3403_HRB31626 | T3403_HRB31626 | Zweibrücken HRB 31626 | Zweibrücken | T3403 | 2017-01-24 | |
193696 | 193696 | R1101_HRB59209-T3403_HRB30706 | T3403_HRB30706 | Zweibrücken HRB 30706 | Zweibrücken | T3403 | 2010-10-18 | |
194875 | 194875 | R1101_HRB67477-T3403_HRB31215 | T3403_HRB31215 | Zweibrücken HRB 31215 | Zweibrücken | T3403 | 2014-06-16 | |
195899 | 195899 | R1101_HRB75993-T3403_HRB32271 | T3403_HRB32271 | Zweibrücken HRB 32271 | Zweibrücken | T3403 | 2020-02-28 | |
204946 | 204946 | R1304_HRB6089-R3306_HRB76061-T3403_HRB31035 | T3403_HRB31035 | Zweibrücken HRB 31035 | Zweibrücken | T3403 | 2013-04-17 | |
251894 | 251894 | R3306_HRB4135-T3403_HRB31945 | T3403_HRB31945 | Zweibrücken HRB 31945 | Zweibrücken | T3403 | 2018-09-13 | |
259481 | 259481 | T2101_HRB20304-T3403_HRB23491 | T3403_HRB23491 | Zweibrücken HRB 23491 | Zweibrücken | T3403 | 2007-03-09 | |
259821 | 259821 | T2101_HRB22888-T3403_HRB32727 | T3403_HRB32727 | Zweibrücken HRB 32727 | Zweibrücken | T3403 | 2022-03-21 | |
263848 | 263848 | T2304_HRB22439-V1109_HRB16735-T3403_HRB30778 | T3403_HRB30778 | Zweibrücken HRB 30778 | Zweibrücken | T3403 | 2011-05-13 | |
265019 | 265019 | T2304_HRB47219-T3403_HRB1839 | T3403_HRB1839 | Zweibrücken HRB 1839 | Zweibrücken | T3403 | 2017-02-09 | |
267767 | 267767 | T3104_HRB60064-T2304_HRB42420-T3403_HRB30843-B1601_HRB713652 | T3403_HRB30843 | Zweibrücken HRB 30843 | Zweibrücken | T3403 | 2011-10-17 | 2011-10-19 |
268216 | 268216 | T3104_HRB63485-T3403_HRB31747 | T3403_HRB31747 | Zweibrücken HRB 31747 | Zweibrücken | T3403 | 2017-10-13 | |
268845 | 268845 | T3201_HRB1660-T3403_HRB32474 | T3403_HRB32474 | Zweibrücken HRB 32474 | Zweibrücken | T3403 | 2021-03-15 | |
268858 | 268858 | T3201_HRB2020-T3403_HRB31532-T3201_HRB33227-D2601_HRB273027 | T3403_HRB31532 | Zweibrücken HRB 31532 | Zweibrücken | T3403 | 2016-06-07 | 2021-06-24 |
268862 | 268862 | T3201_HRB2027-T3403_HRB31131-T3201_HRB32061 | T3403_HRB31131 | Zweibrücken HRB 31131 | Zweibrücken | T3403 | 2013-11-20 | 2016-06-30 |
268935 | 268935 | T3201_HRB2887-T3403_HRB30635 | T3403_HRB30635 | Zweibrücken HRB 30635 | Zweibrücken | T3403 | 2010-04-19 | |
268969 | 268969 | T3201_HRB30156-T3403_HRB30238 | T3403_HRB30238 | Zweibrücken HRB 30238 | Zweibrücken | T3403 | 2007-09-03 | |
268982 | 268982 | T3201_HRB30216-T3403_HRB30378-M1706_HRB5303 | T3403_HRB30378 | Zweibrücken HRB 30378 | Zweibrücken | T3403 | 2008-10-02 | 2014-12-17 |
269107 | 269107 | T3201_HRB31115-T3403_HRB11710 | T3403_HRB11710 | Zweibrücken HRB 11710 | Zweibrücken | T3403 | 2011-05-26 | |
269125 | 269125 | T3201_HRB31206-T3403_HRB31806 | T3403_HRB31806 | Zweibrücken HRB 31806 | Zweibrücken | T3403 | 2018-01-12 | |
269152 | 269152 | T3201_HRB31335-T3403_HRB31187 | T3403_HRB31187 | Zweibrücken HRB 31187 | Zweibrücken | T3403 | 2014-04-15 | |
269176 | 269176 | T3201_HRB31461-T3403_HRB1606 | T3403_HRB1606 | Zweibrücken HRB 1606 | Zweibrücken | T3403 | 2013-03-15 | |
269180 | 269180 | T3201_HRB31477-T3403_HRB31308 | T3403_HRB31308 | Zweibrücken HRB 31308 | Zweibrücken | T3403 | 2015-02-24 | |
269233 | 269233 | T3201_HRB31758-T3403_HRB31330 | T3403_HRB31330 | Zweibrücken HRB 31330 | Zweibrücken | T3403 | 2015-04-09 | |
269327 | 269327 | T3201_HRB32553-T3403_HRB32507 | T3403_HRB32507 | Zweibrücken HRB 32507 | Zweibrücken | T3403 | 2021-05-03 | |
269452 | 269452 | T3201_HRB3390-T3403_HRB30574 | T3403_HRB30574 | Zweibrücken HRB 30574 | Zweibrücken | T3403 | 2009-11-26 | |
270059 | 270059 | T3304V_HRB32238-T3403_HRB31883-T3304_HRB32238 | T3403_HRB31883 | Zweibrücken HRB 31883 | Zweibrücken | T3403 | 2018-06-06 | |
270064 | 270064 | T3304V_HRB32257-V1109_HRB106418-T3403_HRB32344 | T3403_HRB32344 | Zweibrücken HRB 32344 | Zweibrücken | T3403 | 2020-08-10 | |
270184 | 270184 | T3304V_HRB3310-T3403_HRB30837 | T3403_HRB30837 | Zweibrücken HRB 30837 | Zweibrücken | T3403 | 2011-09-29 | |
270259 | 270259 | T3403_HRB1002 | T3403_HRB1002 | Zweibrücken HRB 1002 | Zweibrücken | T3403 | 2021-06-11 | |
270260 | 270260 | T3403_HRB1031 | T3403_HRB1031 | Zweibrücken HRB 1031 | Zweibrücken | T3403 | 2005-11-11 | |
270261 | 270261 | T3403_HRB1046 | T3403_HRB1046 | Zweibrücken HRB 1046 | Zweibrücken | T3403 | 2008-05-08 | |
270262 | 270262 | T3403_HRB11091 | T3403_HRB11091 | Zweibrücken HRB 11091 | Zweibrücken | T3403 | 2010-01-22 | |
270263 | 270263 | T3403_HRB11134 | T3403_HRB11134 | Zweibrücken HRB 11134 | Zweibrücken | T3403 | 2020-01-30 | |
270264 | 270264 | T3403_HRB11169 | T3403_HRB11169 | Zweibrücken HRB 11169 | Zweibrücken | T3403 | 2005-10-13 | |
270265 | 270265 | T3403_HRB1118 | T3403_HRB1118 | Zweibrücken HRB 1118 | Zweibrücken | T3403 | 2010-06-21 | |
270266 | 270266 | T3403_HRB11225 | T3403_HRB11225 | Zweibrücken HRB 11225 | Zweibrücken | T3403 | 2017-01-20 | |
270267 | 270267 | T3403_HRB11240 | T3403_HRB11240 | Zweibrücken HRB 11240 | Zweibrücken | T3403 | 2007-11-12 | |
270268 | 270268 | T3403_HRB11292 | T3403_HRB11292 | Zweibrücken HRB 11292 | Zweibrücken | T3403 | 2005-10-21 | |
270269 | 270269 | T3403_HRB1133 | T3403_HRB1133 | Zweibrücken HRB 1133 | Zweibrücken | T3403 | 2008-06-26 | |
270270 | 270270 | T3403_HRB1136 | T3403_HRB1136 | Zweibrücken HRB 1136 | Zweibrücken | T3403 | 2016-01-04 | |
270271 | 270271 | T3403_HRB11382 | T3403_HRB11382 | Zweibrücken HRB 11382 | Zweibrücken | T3403 | 2015-02-03 | |
270272 | 270272 | T3403_HRB11447 | T3403_HRB11447 | Zweibrücken HRB 11447 | Zweibrücken | T3403 | 2014-09-26 | |
270273 | 270273 | T3403_HRB11509 | T3403_HRB11509 | Zweibrücken HRB 11509 | Zweibrücken | T3403 | 2010-03-23 | |
270274 | 270274 | T3403_HRB11514 | T3403_HRB11514 | Zweibrücken HRB 11514 | Zweibrücken | T3403 | 2005-11-14 | |
270275 | 270275 | T3403_HRB11537 | T3403_HRB11537 | Zweibrücken HRB 11537 | Zweibrücken | T3403 | 2008-02-06 | |
270276 | 270276 | T3403_HRB11544 | T3403_HRB11544 | Zweibrücken HRB 11544 | Zweibrücken | T3403 | 2014-04-23 | |
270277 | 270277 | T3403_HRB11553 | T3403_HRB11553 | Zweibrücken HRB 11553 | Zweibrücken | T3403 | 2009-04-24 | |
270278 | 270278 | T3403_HRB11557 | T3403_HRB11557 | Zweibrücken HRB 11557 | Zweibrücken | T3403 | 2013-02-07 | |
270279 | 270279 | T3403_HRB1156-M1103_HRB98008-T2304_HRB49045 | T3403_HRB1156 | Zweibrücken HRB 1156 | Zweibrücken | T3403 | 2006-08-10 | 2018-07-19 |
270282 | 270282 | T3403_HRB1157 | T3403_HRB1157 | Zweibrücken HRB 1157 | Zweibrücken | T3403 | 2020-12-16 | |
270283 | 270283 | T3403_HRB11578 | T3403_HRB11578 | Zweibrücken HRB 11578 | Zweibrücken | T3403 | 2011-12-08 | |
270284 | 270284 | T3403_HRB11613-V1109_HRB18214 | T3403_HRB11613 | Zweibrücken HRB 11613 | Zweibrücken | T3403 | 2006-05-08 | 2009-11-11 |
270286 | 270286 | T3403_HRB11637 | T3403_HRB11637 | Zweibrücken HRB 11637 | Zweibrücken | T3403 | 2011-08-15 | |
270287 | 270287 | T3403_HRB11650 | T3403_HRB11650 | Zweibrücken HRB 11650 | Zweibrücken | T3403 | 2020-01-09 | |
270288 | 270288 | T3403_HRB11660 | T3403_HRB11660 | Zweibrücken HRB 11660 | Zweibrücken | T3403 | 2005-09-23 | |
270289 | 270289 | T3403_HRB11708 | T3403_HRB11708 | Zweibrücken HRB 11708 | Zweibrücken | T3403 | 2020-01-21 | |
270290 | 270290 | T3403_HRB11744 | T3403_HRB11744 | Zweibrücken HRB 11744 | Zweibrücken | T3403 | 2005-10-07 | |
270291 | 270291 | T3403_HRB11750 | T3403_HRB11750 | Zweibrücken HRB 11750 | Zweibrücken | T3403 | 2008-07-03 | |
270292 | 270292 | T3403_HRB11756 | T3403_HRB11756 | Zweibrücken HRB 11756 | Zweibrücken | T3403 | 2007-04-19 | |
270293 | 270293 | T3403_HRB11767 | T3403_HRB11767 | Zweibrücken HRB 11767 | Zweibrücken | T3403 | 2013-09-02 | |
270294 | 270294 | T3403_HRB11768 | T3403_HRB11768 | Zweibrücken HRB 11768 | Zweibrücken | T3403 | 2006-06-03 | |
270295 | 270295 | T3403_HRB11795 | T3403_HRB11795 | Zweibrücken HRB 11795 | Zweibrücken | T3403 | 2009-03-18 | |
270296 | 270296 | T3403_HRB11803 | T3403_HRB11803 | Zweibrücken HRB 11803 | Zweibrücken | T3403 | 2011-05-27 | |
270297 | 270297 | T3403_HRB11820-V1109_HRB104539 | T3403_HRB11820 | Zweibrücken HRB 11820 | Zweibrücken | T3403 | 2008-10-23 | 2018-03-07 |
270299 | 270299 | T3403_HRB11853 | T3403_HRB11853 | Zweibrücken HRB 11853 | Zweibrücken | T3403 | 2006-11-10 | |
270300 | 270300 | T3403_HRB11865 | T3403_HRB11865 | Zweibrücken HRB 11865 | Zweibrücken | T3403 | 2007-02-02 | |
270301 | 270301 | T3403_HRB11867 | T3403_HRB11867 | Zweibrücken HRB 11867 | Zweibrücken | T3403 | 2015-03-25 | |
270302 | 270302 | T3403_HRB11884 | T3403_HRB11884 | Zweibrücken HRB 11884 | Zweibrücken | T3403 | 2007-02-28 | |
270303 | 270303 | T3403_HRB11890 | T3403_HRB11890 | Zweibrücken HRB 11890 | Zweibrücken | T3403 | 2015-08-10 | |
270304 | 270304 | T3403_HRB11900 | T3403_HRB11900 | Zweibrücken HRB 11900 | Zweibrücken | T3403 | 2009-02-20 | |
270305 | 270305 | T3403_HRB11906 | T3403_HRB11906 | Zweibrücken HRB 11906 | Zweibrücken | T3403 | 2009-11-18 | |
270306 | 270306 | T3403_HRB11909 | T3403_HRB11909 | Zweibrücken HRB 11909 | Zweibrücken | T3403 | 2010-01-05 | |
270307 | 270307 | T3403_HRB1193 | T3403_HRB1193 | Zweibrücken HRB 1193 | Zweibrücken | T3403 | 2006-12-14 | |
270308 | 270308 | T3403_HRB1204 | T3403_HRB1204 | Zweibrücken HRB 1204 | Zweibrücken | T3403 | 2016-09-08 | |
270309 | 270309 | T3403_HRB1220 | T3403_HRB1220 | Zweibrücken HRB 1220 | Zweibrücken | T3403 | 2006-06-26 | |
270310 | 270310 | T3403_HRB1245 | T3403_HRB1245 | Zweibrücken HRB 1245 | Zweibrücken | T3403 | 2020-01-03 | |
270311 | 270311 | T3403_HRB1248 | T3403_HRB1248 | Zweibrücken HRB 1248 | Zweibrücken | T3403 | 2007-01-08 | |
270312 | 270312 | T3403_HRB1283 | T3403_HRB1283 | Zweibrücken HRB 1283 | Zweibrücken | T3403 | 2010-12-02 | |
270313 | 270313 | T3403_HRB1306 | T3403_HRB1306 | Zweibrücken HRB 1306 | Zweibrücken | T3403 | 2007-03-29 | |
270314 | 270314 | T3403_HRB1330 | T3403_HRB1330 | Zweibrücken HRB 1330 | Zweibrücken | T3403 | 2016-09-09 | |
270315 | 270315 | T3403_HRB1331 | T3403_HRB1331 | Zweibrücken HRB 1331 | Zweibrücken | T3403 | 2006-10-06 | |
270316 | 270316 | T3403_HRB1338 | T3403_HRB1338 | Zweibrücken HRB 1338 | Zweibrücken | T3403 | 2013-08-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" );