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 |
---|---|---|---|---|---|---|---|---|
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 | |
227 | 227 | B1601_HRB105601 | B1601_HRB105601 | Mannheim HRB 105601 | Mannheim | B1601 | 2012-06-20 | |
228 | 228 | B1601_HRB105658 | B1601_HRB105658 | Mannheim HRB 105658 | Mannheim | B1601 | 2010-12-09 | |
229 | 229 | B1601_HRB105683 | B1601_HRB105683 | Mannheim HRB 105683 | Mannheim | B1601 | 2016-12-22 | |
230 | 230 | B1601_HRB105736 | B1601_HRB105736 | Mannheim HRB 105736 | Mannheim | B1601 | 2007-08-22 | |
231 | 231 | B1601_HRB105754-T3304_HRB30281 | B1601_HRB105754 | Mannheim HRB 105754 | Mannheim | B1601 | 2007-11-27 | |
232 | 232 | B1601_HRB105794 | B1601_HRB105794 | Mannheim HRB 105794 | Mannheim | B1601 | 2007-09-28 | |
233 | 233 | B1601_HRB105833 | B1601_HRB105833 | Mannheim HRB 105833 | Mannheim | B1601 | 2009-11-19 | |
234 | 234 | B1601_HRB105852 | B1601_HRB105852 | Mannheim HRB 105852 | Mannheim | B1601 | 2012-09-10 | |
235 | 235 | B1601_HRB105873 | B1601_HRB105873 | Mannheim HRB 105873 | Mannheim | B1601 | 2012-01-03 | |
236 | 236 | B1601_HRB105879 | B1601_HRB105879 | Mannheim HRB 105879 | Mannheim | B1601 | 2013-07-16 | |
237 | 237 | B1601_HRB105885 | B1601_HRB105885 | Mannheim HRB 105885 | Mannheim | B1601 | 2009-12-21 | |
238 | 238 | B1601_HRB105972 | B1601_HRB105972 | Mannheim HRB 105972 | Mannheim | B1601 | 2019-05-24 | |
239 | 239 | B1601_HRB106025 | B1601_HRB106025 | Mannheim HRB 106025 | Mannheim | B1601 | 2009-03-06 | |
240 | 240 | B1601_HRB106058 | B1601_HRB106058 | Mannheim HRB 106058 | Mannheim | B1601 | 2009-01-30 | |
241 | 241 | B1601_HRB106060 | B1601_HRB106060 | Mannheim HRB 106060 | Mannheim | B1601 | 2007-07-25 | |
242 | 242 | B1601_HRB106071 | B1601_HRB106071 | Mannheim HRB 106071 | Mannheim | B1601 | 2010-12-13 | |
243 | 243 | B1601_HRB106094 | B1601_HRB106094 | Mannheim HRB 106094 | Mannheim | B1601 | 2012-05-30 | |
244 | 244 | B1601_HRB106113 | B1601_HRB106113 | Mannheim HRB 106113 | Mannheim | B1601 | 2018-08-27 | |
245 | 245 | B1601_HRB106116 | B1601_HRB106116 | Mannheim HRB 106116 | Mannheim | B1601 | 2009-04-30 | |
246 | 246 | B1601_HRB106159 | B1601_HRB106159 | Mannheim HRB 106159 | Mannheim | B1601 | 2009-07-21 | |
247 | 247 | B1601_HRB106239 | B1601_HRB106239 | Mannheim HRB 106239 | Mannheim | B1601 | 2008-09-23 | |
248 | 248 | B1601_HRB106321 | B1601_HRB106321 | Mannheim HRB 106321 | Mannheim | B1601 | 2008-01-16 | |
249 | 249 | B1601_HRB106326 | B1601_HRB106326 | Mannheim HRB 106326 | Mannheim | B1601 | 2007-05-24 | |
250 | 250 | B1601_HRB106386 | B1601_HRB106386 | Mannheim HRB 106386 | Mannheim | B1601 | 2007-01-03 | |
251 | 251 | B1601_HRB106408 | B1601_HRB106408 | Mannheim HRB 106408 | Mannheim | B1601 | 2007-08-19 | |
252 | 252 | B1601_HRB106425 | B1601_HRB106425 | Mannheim HRB 106425 | Mannheim | B1601 | 2009-01-02 | |
253 | 253 | B1601_HRB106431 | B1601_HRB106431 | Mannheim HRB 106431 | Mannheim | B1601 | 2009-11-20 | |
254 | 254 | B1601_HRB106448 | B1601_HRB106448 | Mannheim HRB 106448 | Mannheim | B1601 | 2008-07-21 | |
255 | 255 | B1601_HRB106475 | B1601_HRB106475 | Mannheim HRB 106475 | Mannheim | B1601 | 2014-03-12 | |
256 | 256 | B1601_HRB106478 | B1601_HRB106478 | Mannheim HRB 106478 | Mannheim | B1601 | 2010-03-12 | |
257 | 257 | B1601_HRB106505 | B1601_HRB106505 | Mannheim HRB 106505 | Mannheim | B1601 | 2009-04-27 | |
258 | 258 | B1601_HRB106519 | B1601_HRB106519 | Mannheim HRB 106519 | Mannheim | B1601 | 2009-10-16 | |
259 | 259 | B1601_HRB106548 | B1601_HRB106548 | Mannheim HRB 106548 | Mannheim | B1601 | 2007-05-21 | |
260 | 260 | B1601_HRB106575 | B1601_HRB106575 | Mannheim HRB 106575 | Mannheim | B1601 | 2007-06-29 | |
261 | 261 | B1601_HRB106582 | B1601_HRB106582 | Mannheim HRB 106582 | Mannheim | B1601 | 2008-01-03 | |
262 | 262 | B1601_HRB106584 | B1601_HRB106584 | Mannheim HRB 106584 | Mannheim | B1601 | 2012-03-23 | |
263 | 263 | B1601_HRB106600 | B1601_HRB106600 | Mannheim HRB 106600 | Mannheim | B1601 | 2010-01-27 | |
264 | 264 | B1601_HRB106614 | B1601_HRB106614 | Mannheim HRB 106614 | Mannheim | B1601 | 2011-03-29 | |
265 | 265 | B1601_HRB106683 | B1601_HRB106683 | Mannheim HRB 106683 | Mannheim | B1601 | 2011-12-23 | |
266 | 266 | B1601_HRB106686 | B1601_HRB106686 | Mannheim HRB 106686 | Mannheim | B1601 | 2018-01-03 | |
267 | 267 | B1601_HRB106711 | B1601_HRB106711 | Mannheim HRB 106711 | Mannheim | B1601 | 2007-05-15 | |
268 | 268 | B1601_HRB106712 | B1601_HRB106712 | Mannheim HRB 106712 | Mannheim | B1601 | 2011-12-06 | |
269 | 269 | B1601_HRB106731 | B1601_HRB106731 | Mannheim HRB 106731 | Mannheim | B1601 | 2008-10-27 | |
270 | 270 | B1601_HRB106733 | B1601_HRB106733 | Mannheim HRB 106733 | Mannheim | B1601 | 2011-08-11 | |
271 | 271 | B1601_HRB106740 | B1601_HRB106740 | Mannheim HRB 106740 | Mannheim | B1601 | 2010-10-20 | |
272 | 272 | B1601_HRB106757 | B1601_HRB106757 | Mannheim HRB 106757 | Mannheim | B1601 | 2009-05-20 | |
273 | 273 | B1601_HRB106781 | B1601_HRB106781 | Mannheim HRB 106781 | Mannheim | B1601 | 2018-01-29 | |
274 | 274 | B1601_HRB106783 | B1601_HRB106783 | Mannheim HRB 106783 | Mannheim | B1601 | 2019-04-10 | |
275 | 275 | B1601_HRB106816-B8536_HRB717725 | B1601_HRB106816 | Mannheim HRB 106816 | Mannheim | B1601 | 2017-01-31 | 2018-02-27 |
276 | 276 | B1601_HRB106816-B8536_HRB717725 | B8536_HRB717725 | Freiburg HRB 717725 | Registergericht Freiburg i. Br. | B8536 | 2018-02-27 | |
277 | 277 | B1601_HRB106821 | B1601_HRB106821 | Mannheim HRB 106821 | Mannheim | B1601 | 2014-09-11 | |
278 | 278 | B1601_HRB106853 | B1601_HRB106853 | Mannheim HRB 106853 | Mannheim | B1601 | 2013-01-02 | |
279 | 279 | B1601_HRB106860 | B1601_HRB106860 | Mannheim HRB 106860 | Mannheim | B1601 | 2007-04-25 | |
280 | 280 | B1601_HRB106906 | B1601_HRB106906 | Mannheim HRB 106906 | Mannheim | B1601 | 2007-01-03 | |
281 | 281 | B1601_HRB106914 | B1601_HRB106914 | Mannheim HRB 106914 | Mannheim | B1601 | 2013-03-19 | |
282 | 282 | B1601_HRB106945 | B1601_HRB106945 | Mannheim HRB 106945 | Mannheim | B1601 | 2009-03-04 | |
283 | 283 | B1601_HRB106957 | B1601_HRB106957 | Mannheim HRB 106957 | Mannheim | B1601 | 2009-10-16 | |
284 | 284 | B1601_HRB106959 | B1601_HRB106959 | Mannheim HRB 106959 | Mannheim | B1601 | 2012-08-21 | |
285 | 285 | B1601_HRB106962 | B1601_HRB106962 | Mannheim HRB 106962 | Mannheim | B1601 | 2013-04-17 | |
286 | 286 | B1601_HRB106971 | B1601_HRB106971 | Mannheim HRB 106971 | Mannheim | B1601 | 2009-11-30 | |
287 | 287 | B1601_HRB107000 | B1601_HRB107000 | Mannheim HRB 107000 | Mannheim | B1601 | 2015-10-02 | |
288 | 288 | B1601_HRB107033 | B1601_HRB107033 | Mannheim HRB 107033 | Mannheim | B1601 | 2020-01-10 | |
289 | 289 | B1601_HRB107045 | B1601_HRB107045 | Mannheim HRB 107045 | Mannheim | B1601 | 2012-10-19 | |
290 | 290 | B1601_HRB107050 | B1601_HRB107050 | Mannheim HRB 107050 | Mannheim | B1601 | 2009-07-09 | |
291 | 291 | B1601_HRB107068 | B1601_HRB107068 | Mannheim HRB 107068 | Mannheim | B1601 | 2010-10-18 | |
292 | 292 | B1601_HRB107072 | B1601_HRB107072 | Mannheim HRB 107072 | Mannheim | B1601 | 2009-03-12 | |
293 | 293 | B1601_HRB107078 | B1601_HRB107078 | Mannheim HRB 107078 | Mannheim | B1601 | 2009-10-23 | |
294 | 294 | B1601_HRB107116-G1103_HRB11419CB | B1601_HRB107116 | Mannheim HRB 107116 | Mannheim | B1601 | 2007-06-04 | 2014-01-14 |
295 | 295 | B1601_HRB107116-G1103_HRB11419CB | G1103_HRB11419CB | Cottbus HRB 11419 CB | Cottbus | G1103 | 2014-01-14 | |
296 | 296 | B1601_HRB107137 | B1601_HRB107137 | Mannheim HRB 107137 | Mannheim | B1601 | 2011-07-26 | |
297 | 297 | B1601_HRB107166 | B1601_HRB107166 | Mannheim HRB 107166 | Mannheim | B1601 | 2011-12-05 | |
298 | 298 | B1601_HRB107169 | B1601_HRB107169 | Mannheim HRB 107169 | Mannheim | B1601 | 2008-02-18 | |
299 | 299 | B1601_HRB107188 | B1601_HRB107188 | Mannheim HRB 107188 | Mannheim | B1601 | 2009-11-27 | |
300 | 300 | B1601_HRB107193 | B1601_HRB107193 | Mannheim HRB 107193 | Mannheim | B1601 | 2021-03-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" );