ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by courtCode
This data as json, CSV (advanced)
Suggested facets: validTill (date)
These facets timed out: referenceNumberFirstSeen
Link | rowid | companyId | stdRefNo | nativeReferenceNumber | courtName | courtCode ▼ | referenceNumberFirstSeen | validTill |
---|---|---|---|---|---|---|---|---|
11 | 11 | B1404_HRB2708E-F1103_HRB99280B-B1601_HRB706489 | B1601_HRB706489 | Mannheim HRB 706489 | Mannheim | B1601 | 2009-04-08 | |
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 |
27 | 27 | B1601_HRB100097 | B1601_HRB100097 | Mannheim HRB 100097 | Mannheim | B1601 | 2008-02-29 | |
28 | 28 | B1601_HRB100145 | B1601_HRB100145 | Mannheim HRB 100145 | Mannheim | B1601 | 2007-08-01 | |
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 | |
31 | 31 | B1601_HRB100194 | B1601_HRB100194 | Mannheim HRB 100194 | Mannheim | B1601 | 2007-09-19 | |
32 | 32 | B1601_HRB100220 | B1601_HRB100220 | Mannheim HRB 100220 | Mannheim | B1601 | 2010-08-03 | |
33 | 33 | B1601_HRB100306 | B1601_HRB100306 | Mannheim HRB 100306 | Mannheim | B1601 | 2008-02-05 | |
34 | 34 | B1601_HRB100381 | B1601_HRB100381 | Mannheim HRB 100381 | Mannheim | B1601 | 2007-06-06 | |
35 | 35 | B1601_HRB10046 | B1601_HRB10046 | Mannheim HRB 10046 | Mannheim | B1601 | 2021-02-09 | |
36 | 36 | B1601_HRB100502 | B1601_HRB100502 | Mannheim HRB 100502 | Mannheim | B1601 | 2007-04-26 | |
37 | 37 | B1601_HRB100556 | B1601_HRB100556 | Mannheim HRB 100556 | Mannheim | B1601 | 2011-12-06 | |
38 | 38 | B1601_HRB100560 | B1601_HRB100560 | Mannheim HRB 100560 | Mannheim | B1601 | 2008-06-16 | |
39 | 39 | B1601_HRB10058 | B1601_HRB10058 | Mannheim HRB 10058 | Mannheim | B1601 | 2010-03-09 | |
40 | 40 | B1601_HRB100622 | B1601_HRB100622 | Mannheim HRB 100622 | Mannheim | B1601 | 2022-05-02 | |
41 | 41 | B1601_HRB10064 | B1601_HRB10064 | Mannheim HRB 10064 | Mannheim | B1601 | 2008-09-03 | |
42 | 42 | B1601_HRB100661 | B1601_HRB100661 | Mannheim HRB 100661 | Mannheim | B1601 | 2007-08-20 | |
43 | 43 | B1601_HRB10076 | B1601_HRB10076 | Mannheim HRB 10076 | Mannheim | B1601 | 2011-01-21 | |
44 | 44 | B1601_HRB10077 | B1601_HRB10077 | Mannheim HRB 10077 | Mannheim | B1601 | 2014-11-25 | |
45 | 45 | B1601_HRB100799 | B1601_HRB100799 | Mannheim HRB 100799 | Mannheim | B1601 | 2007-06-04 | |
46 | 46 | B1601_HRB10083 | B1601_HRB10083 | Mannheim HRB 10083 | Mannheim | B1601 | 2011-04-14 | |
47 | 47 | B1601_HRB100831 | B1601_HRB100831 | Mannheim HRB 100831 | Mannheim | B1601 | 2008-07-17 | |
48 | 48 | B1601_HRB100929 | B1601_HRB100929 | Mannheim HRB 100929 | Mannheim | B1601 | 2009-11-27 | |
49 | 49 | B1601_HRB10093 | B1601_HRB10093 | Mannheim HRB 10093 | Mannheim | B1601 | 2015-07-23 | |
50 | 50 | B1601_HRB10104 | B1601_HRB10104 | Mannheim HRB 10104 | Mannheim | B1601 | 2007-10-26 | |
51 | 51 | B1601_HRB101067 | B1601_HRB101067 | Mannheim HRB 101067 | Mannheim | B1601 | 2022-06-03 | |
52 | 52 | B1601_HRB101121 | B1601_HRB101121 | Mannheim HRB 101121 | Mannheim | B1601 | 2008-05-30 | |
53 | 53 | B1601_HRB10120 | B1601_HRB10120 | Mannheim HRB 10120 | Mannheim | B1601 | 2007-06-11 | |
54 | 54 | B1601_HRB101212 | B1601_HRB101212 | Mannheim HRB 101212 | Mannheim | B1601 | 2008-06-02 | |
55 | 55 | B1601_HRB101226 | B1601_HRB101226 | Mannheim HRB 101226 | Mannheim | B1601 | 2012-12-05 | |
56 | 56 | B1601_HRB101276 | B1601_HRB101276 | Mannheim HRB 101276 | Mannheim | B1601 | 2009-12-10 | |
57 | 57 | B1601_HRB10134 | B1601_HRB10134 | Mannheim HRB 10134 | Mannheim | B1601 | 2009-02-23 | |
58 | 58 | B1601_HRB101369 | B1601_HRB101369 | Mannheim HRB 101369 | Mannheim | B1601 | 2007-07-12 | |
59 | 59 | B1601_HRB101426 | B1601_HRB101426 | Mannheim HRB 101426 | Mannheim | B1601 | 2009-08-11 | |
60 | 60 | B1601_HRB101539 | B1601_HRB101539 | Mannheim HRB 101539 | Mannheim | B1601 | 2007-05-11 | |
61 | 61 | B1601_HRB10157 | B1601_HRB10157 | Mannheim HRB 10157 | Mannheim | B1601 | 2008-11-03 | |
62 | 62 | B1601_HRB101627 | B1601_HRB101627 | Mannheim HRB 101627 | Mannheim | B1601 | 2007-06-11 | |
63 | 63 | B1601_HRB101643 | B1601_HRB101643 | Mannheim HRB 101643 | Mannheim | B1601 | 2007-09-03 | |
64 | 64 | B1601_HRB10166 | B1601_HRB10166 | Mannheim HRB 10166 | Mannheim | B1601 | 2018-02-27 | |
65 | 65 | B1601_HRB10167 | B1601_HRB10167 | Mannheim HRB 10167 | Mannheim | B1601 | 2011-08-25 | |
66 | 66 | B1601_HRB101703 | B1601_HRB101703 | Mannheim HRB 101703 | Mannheim | B1601 | 2011-09-23 | |
67 | 67 | B1601_HRB101715 | B1601_HRB101715 | Mannheim HRB 101715 | Mannheim | B1601 | 2007-06-12 | |
68 | 68 | B1601_HRB101737 | B1601_HRB101737 | Mannheim HRB 101737 | Mannheim | B1601 | 2007-09-25 | |
69 | 69 | B1601_HRB101738 | B1601_HRB101738 | Mannheim HRB 101738 | Mannheim | B1601 | 2010-05-18 | |
70 | 70 | B1601_HRB101773 | B1601_HRB101773 | Mannheim HRB 101773 | Mannheim | B1601 | 2010-09-08 | |
71 | 71 | B1601_HRB101804 | B1601_HRB101804 | Mannheim HRB 101804 | Mannheim | B1601 | 2016-12-23 | |
72 | 72 | B1601_HRB10182 | B1601_HRB10182 | Mannheim HRB 10182 | Mannheim | B1601 | 2007-10-16 | |
73 | 73 | B1601_HRB101822 | B1601_HRB101822 | Mannheim HRB 101822 | Mannheim | B1601 | 2015-10-14 | |
74 | 74 | B1601_HRB10183 | B1601_HRB10183 | Mannheim HRB 10183 | Mannheim | B1601 | 2011-02-01 | |
75 | 75 | B1601_HRB101830 | B1601_HRB101830 | Mannheim HRB 101830 | Mannheim | B1601 | 2013-07-18 | |
76 | 76 | B1601_HRB101847 | B1601_HRB101847 | Mannheim HRB 101847 | Mannheim | B1601 | 2009-11-05 | |
77 | 77 | B1601_HRB10185 | B1601_HRB10185 | Mannheim HRB 10185 | Mannheim | B1601 | 2017-11-08 | |
78 | 78 | B1601_HRB101872-D4708_HRB9472 | B1601_HRB101872 | Mannheim HRB 101872 | Mannheim | B1601 | 2007-04-18 | 2007-06-01 |
80 | 80 | B1601_HRB101884 | B1601_HRB101884 | Mannheim HRB 101884 | Mannheim | B1601 | 2014-01-20 | |
81 | 81 | B1601_HRB101898 | B1601_HRB101898 | Mannheim HRB 101898 | Mannheim | B1601 | 2008-02-22 | |
82 | 82 | B1601_HRB101951 | B1601_HRB101951 | Mannheim HRB 101951 | Mannheim | B1601 | 2010-08-11 | |
83 | 83 | B1601_HRB101954 | B1601_HRB101954 | Mannheim HRB 101954 | Mannheim | B1601 | 2012-04-17 | |
84 | 84 | B1601_HRB10196 | B1601_HRB10196 | Mannheim HRB 10196 | Mannheim | B1601 | 2020-02-18 | |
85 | 85 | B1601_HRB101976 | B1601_HRB101976 | Mannheim HRB 101976 | Mannheim | B1601 | 2008-12-16 | |
86 | 86 | B1601_HRB102008 | B1601_HRB102008 | Mannheim HRB 102008 | Mannheim | B1601 | 2009-12-11 | |
87 | 87 | B1601_HRB102011 | B1601_HRB102011 | Mannheim HRB 102011 | Mannheim | B1601 | 2008-03-06 | |
88 | 88 | B1601_HRB102037 | B1601_HRB102037 | Mannheim HRB 102037 | Mannheim | B1601 | 2012-08-31 | |
89 | 89 | B1601_HRB102047 | B1601_HRB102047 | Mannheim HRB 102047 | Mannheim | B1601 | 2013-01-21 | |
90 | 90 | B1601_HRB102053 | B1601_HRB102053 | Mannheim HRB 102053 | Mannheim | B1601 | 2016-02-24 | |
91 | 91 | B1601_HRB102056 | B1601_HRB102056 | Mannheim HRB 102056 | Mannheim | B1601 | 2013-04-29 | |
92 | 92 | B1601_HRB10211 | B1601_HRB10211 | Mannheim HRB 10211 | Mannheim | B1601 | 2007-03-31 | |
93 | 93 | B1601_HRB10212 | B1601_HRB10212 | Mannheim HRB 10212 | Mannheim | B1601 | 2011-02-03 | |
94 | 94 | B1601_HRB102122 | B1601_HRB102122 | Mannheim HRB 102122 | Mannheim | B1601 | 2011-09-27 | |
95 | 95 | B1601_HRB10231 | B1601_HRB10231 | Mannheim HRB 10231 | Mannheim | B1601 | 2009-04-06 | |
96 | 96 | B1601_HRB102317 | B1601_HRB102317 | Mannheim HRB 102317 | Mannheim | B1601 | 2016-05-03 | |
97 | 97 | B1601_HRB102353 | B1601_HRB102353 | Mannheim HRB 102353 | Mannheim | B1601 | 2008-03-03 | |
98 | 98 | B1601_HRB102384 | B1601_HRB102384 | Mannheim HRB 102384 | Mannheim | B1601 | 2014-08-18 | |
99 | 99 | B1601_HRB102388 | B1601_HRB102388 | Mannheim HRB 102388 | Mannheim | B1601 | 2007-01-10 | |
100 | 100 | B1601_HRB102444 | B1601_HRB102444 | Mannheim HRB 102444 | Mannheim | B1601 | 2012-02-21 | |
101 | 101 | B1601_HRB102544 | B1601_HRB102544 | Mannheim HRB 102544 | Mannheim | B1601 | 2009-02-19 | |
102 | 102 | B1601_HRB102559 | B1601_HRB102559 | Mannheim HRB 102559 | Mannheim | B1601 | 2009-06-29 | |
103 | 103 | B1601_HRB10256 | B1601_HRB10256 | Mannheim HRB 10256 | Mannheim | B1601 | 2010-10-01 | |
104 | 104 | B1601_HRB102574 | B1601_HRB102574 | Mannheim HRB 102574 | Mannheim | B1601 | 2014-10-23 | |
105 | 105 | B1601_HRB102600 | B1601_HRB102600 | Mannheim HRB 102600 | Mannheim | B1601 | 2009-04-07 | |
106 | 106 | B1601_HRB102610 | B1601_HRB102610 | Mannheim HRB 102610 | Mannheim | B1601 | 2010-09-21 | |
107 | 107 | B1601_HRB10262 | B1601_HRB10262 | Mannheim HRB 10262 | Mannheim | B1601 | 2006-12-21 | |
108 | 108 | B1601_HRB10263 | B1601_HRB10263 | Mannheim HRB 10263 | Mannheim | B1601 | 2010-03-05 | |
109 | 109 | B1601_HRB102632 | B1601_HRB102632 | Mannheim HRB 102632 | Mannheim | B1601 | 2007-01-08 | |
110 | 110 | B1601_HRB102635 | B1601_HRB102635 | Mannheim HRB 102635 | Mannheim | B1601 | 2019-10-21 | |
111 | 111 | B1601_HRB102637 | B1601_HRB102637 | Mannheim HRB 102637 | Mannheim | B1601 | 2008-01-21 | |
112 | 112 | B1601_HRB102679 | B1601_HRB102679 | Mannheim HRB 102679 | Mannheim | B1601 | 2007-08-23 | |
113 | 113 | B1601_HRB10268 | B1601_HRB10268 | Mannheim HRB 10268 | Mannheim | B1601 | 2010-07-29 | |
114 | 114 | B1601_HRB102709 | B1601_HRB102709 | Mannheim HRB 102709 | Mannheim | B1601 | 2013-01-18 | |
115 | 115 | B1601_HRB102777 | B1601_HRB102777 | Mannheim HRB 102777 | Mannheim | B1601 | 2010-02-16 | |
116 | 116 | B1601_HRB102796 | B1601_HRB102796 | Mannheim HRB 102796 | Mannheim | B1601 | 2011-06-06 | |
117 | 117 | B1601_HRB102808 | B1601_HRB102808 | Mannheim HRB 102808 | Mannheim | B1601 | 2007-03-27 | |
118 | 118 | B1601_HRB102828 | B1601_HRB102828 | Mannheim HRB 102828 | Mannheim | B1601 | 2007-08-10 | |
119 | 119 | B1601_HRB102865 | B1601_HRB102865 | Mannheim HRB 102865 | Mannheim | B1601 | 2012-07-25 | |
120 | 120 | B1601_HRB102879 | B1601_HRB102879 | Mannheim HRB 102879 | Mannheim | B1601 | 2011-03-08 | |
121 | 121 | B1601_HRB10293 | B1601_HRB10293 | Mannheim HRB 10293 | Mannheim | B1601 | 2007-11-06 | |
122 | 122 | B1601_HRB102942 | B1601_HRB102942 | Mannheim HRB 102942 | Mannheim | B1601 | 2009-03-24 | |
123 | 123 | B1601_HRB102990 | B1601_HRB102990 | Mannheim HRB 102990 | Mannheim | B1601 | 2012-04-24 | |
124 | 124 | B1601_HRB10304 | B1601_HRB10304 | Mannheim HRB 10304 | Mannheim | B1601 | 2007-08-20 |
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" );