ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by courtCode
This data as json, CSV (advanced)
Link | rowid | companyId | stdRefNo | nativeReferenceNumber | courtName | courtCode ▼ | referenceNumberFirstSeen | validTill |
---|---|---|---|---|---|---|---|---|
125 | 125 | B1601_HRB103055 | B1601_HRB103055 | Mannheim HRB 103055 | Mannheim | B1601 | 2022-04-26 | |
126 | 126 | B1601_HRB103062 | B1601_HRB103062 | Mannheim HRB 103062 | Mannheim | B1601 | 2011-01-24 | |
127 | 127 | B1601_HRB10311 | B1601_HRB10311 | Mannheim HRB 10311 | Mannheim | B1601 | 2008-01-31 | |
128 | 128 | B1601_HRB103116 | B1601_HRB103116 | Mannheim HRB 103116 | Mannheim | B1601 | 2009-02-04 | |
129 | 129 | B1601_HRB103195 | B1601_HRB103195 | Mannheim HRB 103195 | Mannheim | B1601 | 2013-06-26 | |
130 | 130 | B1601_HRB10323-P2305_HRB204367 | B1601_HRB10323 | Mannheim HRB 10323 | Mannheim | B1601 | 2008-11-20 | 2009-06-26 |
132 | 132 | B1601_HRB103230 | B1601_HRB103230 | Mannheim HRB 103230 | Mannheim | B1601 | 2012-05-09 | |
133 | 133 | B1601_HRB10324 | B1601_HRB10324 | Mannheim HRB 10324 | Mannheim | B1601 | 2009-03-18 | |
134 | 134 | B1601_HRB103255 | B1601_HRB103255 | Mannheim HRB 103255 | Mannheim | B1601 | 2012-11-19 | |
135 | 135 | B1601_HRB103265 | B1601_HRB103265 | Mannheim HRB 103265 | Mannheim | B1601 | 2013-11-20 | |
136 | 136 | B1601_HRB10329 | B1601_HRB10329 | Mannheim HRB 10329 | Mannheim | B1601 | 2008-02-14 | |
137 | 137 | B1601_HRB103325 | B1601_HRB103325 | Mannheim HRB 103325 | Mannheim | B1601 | 2013-11-11 | |
138 | 138 | B1601_HRB10338 | B1601_HRB10338 | Mannheim HRB 10338 | Mannheim | B1601 | 2007-04-05 | |
139 | 139 | B1601_HRB103380 | B1601_HRB103380 | Mannheim HRB 103380 | Mannheim | B1601 | 2008-09-25 | |
140 | 140 | B1601_HRB103411 | B1601_HRB103411 | Mannheim HRB 103411 | Mannheim | B1601 | 2017-01-27 | |
141 | 141 | B1601_HRB103424 | B1601_HRB103424 | Mannheim HRB 103424 | Mannheim | B1601 | 2011-10-07 | |
142 | 142 | B1601_HRB103473 | B1601_HRB103473 | Mannheim HRB 103473 | Mannheim | B1601 | 2012-08-21 | |
143 | 143 | B1601_HRB10349 | B1601_HRB10349 | Mannheim HRB 10349 | Mannheim | B1601 | 2008-05-02 | |
144 | 144 | B1601_HRB103509 | B1601_HRB103509 | Mannheim HRB 103509 | Mannheim | B1601 | 2009-06-04 | |
145 | 145 | B1601_HRB103523 | B1601_HRB103523 | Mannheim HRB 103523 | Mannheim | B1601 | 2020-02-28 | |
146 | 146 | B1601_HRB103565 | B1601_HRB103565 | Mannheim HRB 103565 | Mannheim | B1601 | 2013-07-09 | |
147 | 147 | B1601_HRB103581 | B1601_HRB103581 | Mannheim HRB 103581 | Mannheim | B1601 | 2019-01-18 | |
148 | 148 | B1601_HRB10360 | B1601_HRB10360 | Mannheim HRB 10360 | Mannheim | B1601 | 2009-08-18 | |
149 | 149 | B1601_HRB103607 | B1601_HRB103607 | Mannheim HRB 103607 | Mannheim | B1601 | 2010-09-07 | |
150 | 150 | B1601_HRB103699 | B1601_HRB103699 | Mannheim HRB 103699 | Mannheim | B1601 | 2011-06-28 | |
151 | 151 | B1601_HRB103700 | B1601_HRB103700 | Mannheim HRB 103700 | Mannheim | B1601 | 2021-01-11 | |
152 | 152 | B1601_HRB103758 | B1601_HRB103758 | Mannheim HRB 103758 | Mannheim | B1601 | 2007-11-26 | |
153 | 153 | B1601_HRB10376 | B1601_HRB10376 | Mannheim HRB 10376 | Mannheim | B1601 | 2008-05-02 | |
154 | 154 | B1601_HRB103769 | B1601_HRB103769 | Mannheim HRB 103769 | Mannheim | B1601 | 2017-04-25 | |
155 | 155 | B1601_HRB10380 | B1601_HRB10380 | Mannheim HRB 10380 | Mannheim | B1601 | 2012-01-05 | |
156 | 156 | B1601_HRB103811 | B1601_HRB103811 | Mannheim HRB 103811 | Mannheim | B1601 | 2013-08-20 | |
157 | 157 | B1601_HRB103820 | B1601_HRB103820 | Mannheim HRB 103820 | Mannheim | B1601 | 2009-03-20 | |
158 | 158 | B1601_HRB103883 | B1601_HRB103883 | Mannheim HRB 103883 | Mannheim | B1601 | 2019-01-03 | |
159 | 159 | B1601_HRB103915 | B1601_HRB103915 | Mannheim HRB 103915 | Mannheim | B1601 | 2022-06-02 | |
160 | 160 | B1601_HRB103928 | B1601_HRB103928 | Mannheim HRB 103928 | Mannheim | B1601 | 2007-08-21 | |
161 | 161 | B1601_HRB10393 | B1601_HRB10393 | Mannheim HRB 10393 | Mannheim | B1601 | 2007-01-11 | |
162 | 162 | B1601_HRB103957 | B1601_HRB103957 | Mannheim HRB 103957 | Mannheim | B1601 | 2008-07-16 | |
163 | 163 | B1601_HRB103961 | B1601_HRB103961 | Mannheim HRB 103961 | Mannheim | B1601 | 2013-04-10 | |
164 | 164 | B1601_HRB10397 | B1601_HRB10397 | Mannheim HRB 10397 | Mannheim | B1601 | 2007-12-03 | |
165 | 165 | B1601_HRB103979 | B1601_HRB103979 | Mannheim HRB 103979 | Mannheim | B1601 | 2009-10-02 | |
166 | 166 | B1601_HRB103984 | B1601_HRB103984 | Mannheim HRB 103984 | Mannheim | B1601 | 2007-07-02 | |
167 | 167 | B1601_HRB10402 | B1601_HRB10402 | Mannheim HRB 10402 | Mannheim | B1601 | 2007-02-28 | |
168 | 168 | B1601_HRB104035 | B1601_HRB104035 | Mannheim HRB 104035 | Mannheim | B1601 | 2011-08-11 | |
169 | 169 | B1601_HRB104070 | B1601_HRB104070 | Mannheim HRB 104070 | Mannheim | B1601 | 2011-10-11 | |
170 | 170 | B1601_HRB104108 | B1601_HRB104108 | Mannheim HRB 104108 | Mannheim | B1601 | 2008-01-14 | |
171 | 171 | B1601_HRB10411 | B1601_HRB10411 | Mannheim HRB 10411 | Mannheim | B1601 | 2008-09-29 | |
172 | 172 | B1601_HRB104171 | B1601_HRB104171 | Mannheim HRB 104171 | Mannheim | B1601 | 2014-02-05 | |
173 | 173 | B1601_HRB104189 | B1601_HRB104189 | Mannheim HRB 104189 | Mannheim | B1601 | 2009-12-02 | |
174 | 174 | B1601_HRB104194 | B1601_HRB104194 | Mannheim HRB 104194 | Mannheim | B1601 | 2016-09-27 | |
175 | 175 | B1601_HRB104206 | B1601_HRB104206 | Mannheim HRB 104206 | Mannheim | B1601 | 2007-07-19 | |
176 | 176 | B1601_HRB10422 | B1601_HRB10422 | Mannheim HRB 10422 | Mannheim | B1601 | 2007-07-05 | |
177 | 177 | B1601_HRB104267 | B1601_HRB104267 | Mannheim HRB 104267 | Mannheim | B1601 | 2008-12-18 | |
178 | 178 | B1601_HRB104302 | B1601_HRB104302 | Mannheim HRB 104302 | Mannheim | B1601 | 2008-05-26 | |
179 | 179 | B1601_HRB10432 | B1601_HRB10432 | Mannheim HRB 10432 | Mannheim | B1601 | 2014-05-12 | |
180 | 180 | B1601_HRB104329 | B1601_HRB104329 | Mannheim HRB 104329 | Mannheim | B1601 | 2010-12-09 | |
181 | 181 | B1601_HRB104343 | B1601_HRB104343 | Mannheim HRB 104343 | Mannheim | B1601 | 2012-05-23 | |
182 | 182 | B1601_HRB104348 | B1601_HRB104348 | Mannheim HRB 104348 | Mannheim | B1601 | 2007-08-27 | |
183 | 183 | B1601_HRB104361 | B1601_HRB104361 | Mannheim HRB 104361 | Mannheim | B1601 | 2011-01-11 | |
184 | 184 | B1601_HRB104424 | B1601_HRB104424 | Mannheim HRB 104424 | Mannheim | B1601 | 2009-08-04 | |
185 | 185 | B1601_HRB10448 | B1601_HRB10448 | Mannheim HRB 10448 | Mannheim | B1601 | 2007-12-14 | |
186 | 186 | B1601_HRB104522 | B1601_HRB104522 | Mannheim HRB 104522 | Mannheim | B1601 | 2007-08-02 | |
187 | 187 | B1601_HRB104563 | B1601_HRB104563 | Mannheim HRB 104563 | Mannheim | B1601 | 2012-08-23 | |
188 | 188 | B1601_HRB104568 | B1601_HRB104568 | Mannheim HRB 104568 | Mannheim | B1601 | 2007-04-02 | |
189 | 189 | B1601_HRB104579 | B1601_HRB104579 | Mannheim HRB 104579 | Mannheim | B1601 | 2018-05-28 | |
190 | 190 | B1601_HRB104587 | B1601_HRB104587 | Mannheim HRB 104587 | Mannheim | B1601 | 2011-03-03 | |
191 | 191 | B1601_HRB104594 | B1601_HRB104594 | Mannheim HRB 104594 | Mannheim | B1601 | 2021-02-25 | |
192 | 192 | B1601_HRB104655 | B1601_HRB104655 | Mannheim HRB 104655 | Mannheim | B1601 | 2012-09-21 | |
193 | 193 | B1601_HRB104738 | B1601_HRB104738 | Mannheim HRB 104738 | Mannheim | B1601 | 2008-12-18 | |
194 | 194 | B1601_HRB104750 | B1601_HRB104750 | Mannheim HRB 104750 | Mannheim | B1601 | 2020-07-27 | |
195 | 195 | B1601_HRB104760 | B1601_HRB104760 | Mannheim HRB 104760 | Mannheim | B1601 | 2011-01-26 | |
196 | 196 | B1601_HRB104781 | B1601_HRB104781 | Mannheim HRB 104781 | Mannheim | B1601 | 2008-09-01 | |
197 | 197 | B1601_HRB104793 | B1601_HRB104793 | Mannheim HRB 104793 | Mannheim | B1601 | 2009-06-18 | |
198 | 198 | B1601_HRB104821-F1103_HRB174253B-F1103_HRB174253 | B1601_HRB104821 | Mannheim HRB 104821 | Mannheim | B1601 | 2007-10-17 | 2016-02-10 |
200 | 200 | B1601_HRB104846 | B1601_HRB104846 | Mannheim HRB 104846 | Mannheim | B1601 | 2007-05-14 | |
201 | 201 | B1601_HRB104861 | B1601_HRB104861 | Mannheim HRB 104861 | Mannheim | B1601 | 2010-01-13 | |
202 | 202 | B1601_HRB104867 | B1601_HRB104867 | Mannheim HRB 104867 | Mannheim | B1601 | 2013-10-22 | |
203 | 203 | B1601_HRB104902 | B1601_HRB104902 | Mannheim HRB 104902 | Mannheim | B1601 | 2007-08-07 | |
204 | 204 | B1601_HRB104962 | B1601_HRB104962 | Mannheim HRB 104962 | Mannheim | B1601 | 2007-11-20 | |
205 | 205 | B1601_HRB105023 | B1601_HRB105023 | Mannheim HRB 105023 | Mannheim | B1601 | 2008-01-02 | |
206 | 206 | B1601_HRB105030 | B1601_HRB105030 | Mannheim HRB 105030 | Mannheim | B1601 | 2015-12-04 | |
207 | 207 | B1601_HRB105035 | B1601_HRB105035 | Mannheim HRB 105035 | Mannheim | B1601 | 2012-01-26 | |
208 | 208 | B1601_HRB105129 | B1601_HRB105129 | Mannheim HRB 105129 | Mannheim | B1601 | 2013-03-08 | |
209 | 209 | B1601_HRB105136 | B1601_HRB105136 | Mannheim HRB 105136 | Mannheim | B1601 | 2022-02-04 | |
210 | 210 | B1601_HRB105162 | B1601_HRB105162 | Mannheim HRB 105162 | Mannheim | B1601 | 2012-07-26 | |
211 | 211 | B1601_HRB105248 | B1601_HRB105248 | Mannheim HRB 105248 | Mannheim | B1601 | 2007-09-11 | |
212 | 212 | B1601_HRB105257 | B1601_HRB105257 | Mannheim HRB 105257 | Mannheim | B1601 | 2008-02-20 | |
213 | 213 | B1601_HRB105271 | B1601_HRB105271 | Mannheim HRB 105271 | Mannheim | B1601 | 2014-08-13 | |
214 | 214 | B1601_HRB105277 | B1601_HRB105277 | Mannheim HRB 105277 | Mannheim | B1601 | 2017-11-29 | |
215 | 215 | B1601_HRB105302 | B1601_HRB105302 | Mannheim HRB 105302 | Mannheim | B1601 | 2014-10-28 | |
216 | 216 | B1601_HRB105357 | B1601_HRB105357 | Mannheim HRB 105357 | Mannheim | B1601 | 2007-11-20 | |
217 | 217 | B1601_HRB105418 | B1601_HRB105418 | Mannheim HRB 105418 | Mannheim | B1601 | 2011-03-01 | |
218 | 218 | B1601_HRB105425 | B1601_HRB105425 | Mannheim HRB 105425 | Mannheim | B1601 | 2011-07-18 | |
219 | 219 | B1601_HRB105447 | B1601_HRB105447 | Mannheim HRB 105447 | Mannheim | B1601 | 2008-11-03 | |
220 | 220 | B1601_HRB105470 | B1601_HRB105470 | Mannheim HRB 105470 | Mannheim | B1601 | 2007-03-08 | |
221 | 221 | B1601_HRB105509 | B1601_HRB105509 | Mannheim HRB 105509 | Mannheim | B1601 | 2011-01-13 | |
222 | 222 | B1601_HRB105511 | B1601_HRB105511 | Mannheim HRB 105511 | Mannheim | B1601 | 2012-04-20 | |
223 | 223 | B1601_HRB105521 | B1601_HRB105521 | Mannheim HRB 105521 | Mannheim | B1601 | 2013-03-22 | |
224 | 224 | B1601_HRB105538 | B1601_HRB105538 | Mannheim HRB 105538 | Mannheim | B1601 | 2019-05-14 | |
225 | 225 | B1601_HRB105557 | B1601_HRB105557 | Mannheim HRB 105557 | Mannheim | B1601 | 2011-10-20 | |
226 | 226 | B1601_HRB105589 | B1601_HRB105589 | Mannheim HRB 105589 | Mannheim | B1601 | 2010-03-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" );