ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows
This data as json, CSV (advanced)
Link | rowid ▼ | companyId | stdRefNo | nativeReferenceNumber | courtName | courtCode | referenceNumberFirstSeen | validTill |
---|---|---|---|---|---|---|---|---|
301 | 301 | B1601_HRB107198 | B1601_HRB107198 | Mannheim HRB 107198 | Mannheim | B1601 | 2011-11-28 | |
302 | 302 | B1601_HRB107208 | B1601_HRB107208 | Mannheim HRB 107208 | Mannheim | B1601 | 2016-07-22 | |
303 | 303 | B1601_HRB107235 | B1601_HRB107235 | Mannheim HRB 107235 | Mannheim | B1601 | 2012-07-13 | |
304 | 304 | B1601_HRB107241 | B1601_HRB107241 | Mannheim HRB 107241 | Mannheim | B1601 | 2009-04-29 | |
305 | 305 | B1601_HRB107274 | B1601_HRB107274 | Mannheim HRB 107274 | Mannheim | B1601 | 2012-07-12 | |
306 | 306 | B1601_HRB107312 | B1601_HRB107312 | Mannheim HRB 107312 | Mannheim | B1601 | 2010-01-14 | |
307 | 307 | B1601_HRB107340 | B1601_HRB107340 | Mannheim HRB 107340 | Mannheim | B1601 | 2022-01-11 | |
308 | 308 | B1601_HRB107355 | B1601_HRB107355 | Mannheim HRB 107355 | Mannheim | B1601 | 2008-08-11 | |
309 | 309 | B1601_HRB107404 | B1601_HRB107404 | Mannheim HRB 107404 | Mannheim | B1601 | 2007-04-27 | |
310 | 310 | B1601_HRB107419 | B1601_HRB107419 | Mannheim HRB 107419 | Mannheim | B1601 | 2009-02-20 | |
311 | 311 | B1601_HRB107479 | B1601_HRB107479 | Mannheim HRB 107479 | Mannheim | B1601 | 2008-06-05 | |
312 | 312 | B1601_HRB107502 | B1601_HRB107502 | Mannheim HRB 107502 | Mannheim | B1601 | 2014-11-17 | |
313 | 313 | B1601_HRB107516 | B1601_HRB107516 | Mannheim HRB 107516 | Mannheim | B1601 | 2010-03-24 | |
314 | 314 | B1601_HRB107541 | B1601_HRB107541 | Mannheim HRB 107541 | Mannheim | B1601 | 2014-09-10 | |
315 | 315 | B1601_HRB107580 | B1601_HRB107580 | Mannheim HRB 107580 | Mannheim | B1601 | 2009-04-08 | |
316 | 316 | B1601_HRB107581 | B1601_HRB107581 | Mannheim HRB 107581 | Mannheim | B1601 | 2007-09-25 | |
317 | 317 | B1601_HRB107594 | B1601_HRB107594 | Mannheim HRB 107594 | Mannheim | B1601 | 2007-07-03 | |
318 | 318 | B1601_HRB107598 | B1601_HRB107598 | Mannheim HRB 107598 | Mannheim | B1601 | 2015-12-09 | |
319 | 319 | B1601_HRB107601 | B1601_HRB107601 | Mannheim HRB 107601 | Mannheim | B1601 | 2008-09-18 | |
320 | 320 | B1601_HRB107605 | B1601_HRB107605 | Mannheim HRB 107605 | Mannheim | B1601 | 2011-02-25 | |
321 | 321 | B1601_HRB107612 | B1601_HRB107612 | Mannheim HRB 107612 | Mannheim | B1601 | 2009-03-25 | |
322 | 322 | B1601_HRB107613 | B1601_HRB107613 | Mannheim HRB 107613 | Mannheim | B1601 | 2009-08-31 | |
323 | 323 | B1601_HRB107700 | B1601_HRB107700 | Mannheim HRB 107700 | Mannheim | B1601 | 2009-07-15 | |
324 | 324 | B1601_HRB107702 | B1601_HRB107702 | Mannheim HRB 107702 | Mannheim | B1601 | 2012-08-27 | |
325 | 325 | B1601_HRB107719 | B1601_HRB107719 | Mannheim HRB 107719 | Mannheim | B1601 | 2009-05-14 | |
326 | 326 | B1601_HRB107720 | B1601_HRB107720 | Mannheim HRB 107720 | Mannheim | B1601 | 2008-12-16 | |
327 | 327 | B1601_HRB107721 | B1601_HRB107721 | Mannheim HRB 107721 | Mannheim | B1601 | 2017-01-09 | |
328 | 328 | B1601_HRB107730 | B1601_HRB107730 | Mannheim HRB 107730 | Mannheim | B1601 | 2009-03-09 | |
329 | 329 | B1601_HRB107748 | B1601_HRB107748 | Mannheim HRB 107748 | Mannheim | B1601 | 2007-11-07 | |
330 | 330 | B1601_HRB107786 | B1601_HRB107786 | Mannheim HRB 107786 | Mannheim | B1601 | 2008-02-05 | |
331 | 331 | B1601_HRB107807 | B1601_HRB107807 | Mannheim HRB 107807 | Mannheim | B1601 | 2017-05-03 | |
332 | 332 | B1601_HRB107816 | B1601_HRB107816 | Mannheim HRB 107816 | Mannheim | B1601 | 2007-06-14 | |
333 | 333 | B1601_HRB107817 | B1601_HRB107817 | Mannheim HRB 107817 | Mannheim | B1601 | 2007-06-11 | |
334 | 334 | B1601_HRB107827 | B1601_HRB107827 | Mannheim HRB 107827 | Mannheim | B1601 | 2007-10-13 | |
335 | 335 | B1601_HRB107831 | B1601_HRB107831 | Mannheim HRB 107831 | Mannheim | B1601 | 2012-10-10 | |
336 | 336 | B1601_HRB107837 | B1601_HRB107837 | Mannheim HRB 107837 | Mannheim | B1601 | 2011-07-12 | |
337 | 337 | B1601_HRB107879 | B1601_HRB107879 | Mannheim HRB 107879 | Mannheim | B1601 | 2015-03-27 | |
338 | 338 | B1601_HRB107893 | B1601_HRB107893 | Mannheim HRB 107893 | Mannheim | B1601 | 2015-04-09 | |
339 | 339 | B1601_HRB107931 | B1601_HRB107931 | Mannheim HRB 107931 | Mannheim | B1601 | 2008-01-09 | |
340 | 340 | B1601_HRB107951 | B1601_HRB107951 | Mannheim HRB 107951 | Mannheim | B1601 | 2017-07-21 | |
341 | 341 | B1601_HRB107957 | B1601_HRB107957 | Mannheim HRB 107957 | Mannheim | B1601 | 2009-08-04 | |
342 | 342 | B1601_HRB107972 | B1601_HRB107972 | Mannheim HRB 107972 | Mannheim | B1601 | 2014-03-13 | |
343 | 343 | B1601_HRB107984 | B1601_HRB107984 | Mannheim HRB 107984 | Mannheim | B1601 | 2009-02-19 | |
344 | 344 | B1601_HRB107996 | B1601_HRB107996 | Mannheim HRB 107996 | Mannheim | B1601 | 2009-06-29 | |
345 | 345 | B1601_HRB108010 | B1601_HRB108010 | Mannheim HRB 108010 | Mannheim | B1601 | 2012-05-09 | |
346 | 346 | B1601_HRB108011 | B1601_HRB108011 | Mannheim HRB 108011 | Mannheim | B1601 | 2007-01-18 | |
347 | 347 | B1601_HRB108013 | B1601_HRB108013 | Mannheim HRB 108013 | Mannheim | B1601 | 2010-08-25 | |
348 | 348 | B1601_HRB108014 | B1601_HRB108014 | Mannheim HRB 108014 | Mannheim | B1601 | 2011-07-15 | |
349 | 349 | B1601_HRB108022 | B1601_HRB108022 | Mannheim HRB 108022 | Mannheim | B1601 | 2011-10-05 | |
350 | 350 | B1601_HRB108061 | B1601_HRB108061 | Mannheim HRB 108061 | Mannheim | B1601 | 2017-04-11 | |
351 | 351 | B1601_HRB108090-D3410_HRB12248 | B1601_HRB108090 | Mannheim HRB 108090 | Mannheim | B1601 | 2010-02-10 | 2010-10-27 |
352 | 352 | B1601_HRB108090-D3410_HRB12248 | D3410_HRB12248 | Regensburg HRB 12248 | Regensburg | D3410 | 2010-10-27 | |
353 | 353 | B1601_HRB108097 | B1601_HRB108097 | Mannheim HRB 108097 | Mannheim | B1601 | 2007-04-13 | |
354 | 354 | B1601_HRB108100 | B1601_HRB108100 | Mannheim HRB 108100 | Mannheim | B1601 | 2007-03-21 | |
355 | 355 | B1601_HRB108101 | B1601_HRB108101 | Mannheim HRB 108101 | Mannheim | B1601 | 2020-03-16 | |
356 | 356 | B1601_HRB108104 | B1601_HRB108104 | Mannheim HRB 108104 | Mannheim | B1601 | 2008-02-12 | |
357 | 357 | B1601_HRB108115 | B1601_HRB108115 | Mannheim HRB 108115 | Mannheim | B1601 | 2008-02-22 | |
358 | 358 | B1601_HRB108135 | B1601_HRB108135 | Mannheim HRB 108135 | Mannheim | B1601 | 2020-04-28 | |
359 | 359 | B1601_HRB108144 | B1601_HRB108144 | Mannheim HRB 108144 | Mannheim | B1601 | 2020-12-23 | |
360 | 360 | B1601_HRB108153 | B1601_HRB108153 | Mannheim HRB 108153 | Mannheim | B1601 | 2010-08-09 | |
361 | 361 | B1601_HRB108159 | B1601_HRB108159 | Mannheim HRB 108159 | Mannheim | B1601 | 2013-10-25 | |
362 | 362 | B1601_HRB108160 | B1601_HRB108160 | Mannheim HRB 108160 | Mannheim | B1601 | 2007-07-10 | |
363 | 363 | B1601_HRB108165 | B1601_HRB108165 | Mannheim HRB 108165 | Mannheim | B1601 | 2007-02-15 | |
364 | 364 | B1601_HRB108176 | B1601_HRB108176 | Mannheim HRB 108176 | Mannheim | B1601 | 2016-06-10 | |
365 | 365 | B1601_HRB108203-V1109_HRB102038 | B1601_HRB108203 | Mannheim HRB 108203 | Mannheim | B1601 | 2008-04-28 | 2014-11-19 |
366 | 366 | B1601_HRB108203-V1109_HRB102038 | V1109_HRB102038 | Saarbrücken HRB 102038 | Saarbrücken | V1109 | 2014-11-19 | |
367 | 367 | B1601_HRB108209 | B1601_HRB108209 | Mannheim HRB 108209 | Mannheim | B1601 | 2013-11-13 | |
368 | 368 | B1601_HRB108220 | B1601_HRB108220 | Mannheim HRB 108220 | Mannheim | B1601 | 2015-03-25 | |
369 | 369 | B1601_HRB108262 | B1601_HRB108262 | Mannheim HRB 108262 | Mannheim | B1601 | 2016-02-03 | |
370 | 370 | B1601_HRB108285 | B1601_HRB108285 | Mannheim HRB 108285 | Mannheim | B1601 | 2007-03-26 | |
371 | 371 | B1601_HRB108289 | B1601_HRB108289 | Mannheim HRB 108289 | Mannheim | B1601 | 2007-12-17 | |
372 | 372 | B1601_HRB108331 | B1601_HRB108331 | Mannheim HRB 108331 | Mannheim | B1601 | 2008-12-29 | |
373 | 373 | B1601_HRB108337 | B1601_HRB108337 | Mannheim HRB 108337 | Mannheim | B1601 | 2013-01-16 | |
374 | 374 | B1601_HRB108350 | B1601_HRB108350 | Mannheim HRB 108350 | Mannheim | B1601 | 2007-05-09 | |
375 | 375 | B1601_HRB108351 | B1601_HRB108351 | Mannheim HRB 108351 | Mannheim | B1601 | 2014-08-13 | |
376 | 376 | B1601_HRB108354 | B1601_HRB108354 | Mannheim HRB 108354 | Mannheim | B1601 | 2012-05-29 | |
377 | 377 | B1601_HRB108363 | B1601_HRB108363 | Mannheim HRB 108363 | Mannheim | B1601 | 2015-09-29 | |
378 | 378 | B1601_HRB108382 | B1601_HRB108382 | Mannheim HRB 108382 | Mannheim | B1601 | 2008-05-13 | |
379 | 379 | B1601_HRB108383 | B1601_HRB108383 | Mannheim HRB 108383 | Mannheim | B1601 | 2022-03-15 | |
380 | 380 | B1601_HRB108392 | B1601_HRB108392 | Mannheim HRB 108392 | Mannheim | B1601 | 2010-03-16 | |
381 | 381 | B1601_HRB108396 | B1601_HRB108396 | Mannheim HRB 108396 | Mannheim | B1601 | 2010-03-23 | |
382 | 382 | B1601_HRB108431-B2805_HRB727592 | B1601_HRB108431 | Mannheim HRB 108431 | Mannheim | B1601 | 2011-01-20 | 2012-02-21 |
383 | 383 | B1601_HRB108431-B2805_HRB727592 | B2805_HRB727592 | Ulm HRB 727592 | Ulm | B2805 | 2012-02-21 | |
384 | 384 | B1601_HRB108440 | B1601_HRB108440 | Mannheim HRB 108440 | Mannheim | B1601 | 2009-06-10 | |
385 | 385 | B1601_HRB108464 | B1601_HRB108464 | Mannheim HRB 108464 | Mannheim | B1601 | 2013-05-10 | |
386 | 386 | B1601_HRB108478 | B1601_HRB108478 | Mannheim HRB 108478 | Mannheim | B1601 | 2007-12-18 | |
387 | 387 | B1601_HRB108479 | B1601_HRB108479 | Mannheim HRB 108479 | Mannheim | B1601 | 2009-01-13 | |
388 | 388 | B1601_HRB108490 | B1601_HRB108490 | Mannheim HRB 108490 | Mannheim | B1601 | 2012-01-27 | |
389 | 389 | B1601_HRB108536 | B1601_HRB108536 | Mannheim HRB 108536 | Mannheim | B1601 | 2008-05-09 | |
390 | 390 | B1601_HRB108550 | B1601_HRB108550 | Mannheim HRB 108550 | Mannheim | B1601 | 2007-03-08 | |
391 | 391 | B1601_HRB108558-M1114_HRB53360 | B1601_HRB108558 | Mannheim HRB 108558 | Mannheim | B1601 | 2012-12-13 | 2021-02-18 |
392 | 392 | B1601_HRB108558-M1114_HRB53360 | M1114_HRB53360 | Offenbach am Main HRB 53360 | Offenbach am Main | M1114 | 2021-02-18 | |
393 | 393 | B1601_HRB108604 | B1601_HRB108604 | Mannheim HRB 108604 | Mannheim | B1601 | 2021-03-15 | |
394 | 394 | B1601_HRB108611 | B1601_HRB108611 | Mannheim HRB 108611 | Mannheim | B1601 | 2008-08-08 | |
395 | 395 | B1601_HRB108622 | B1601_HRB108622 | Mannheim HRB 108622 | Mannheim | B1601 | 2014-10-28 | |
396 | 396 | B1601_HRB108623 | B1601_HRB108623 | Mannheim HRB 108623 | Mannheim | B1601 | 2009-12-07 | |
397 | 397 | B1601_HRB108656 | B1601_HRB108656 | Mannheim HRB 108656 | Mannheim | B1601 | 2009-04-15 | |
398 | 398 | B1601_HRB108671 | B1601_HRB108671 | Mannheim HRB 108671 | Mannheim | B1601 | 2009-08-26 | |
399 | 399 | B1601_HRB108674 | B1601_HRB108674 | Mannheim HRB 108674 | Mannheim | B1601 | 2010-11-10 | |
400 | 400 | B1601_HRB108706 | B1601_HRB108706 | Mannheim HRB 108706 | Mannheim | B1601 | 2014-04-08 |
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" );