registrations

Data license: CC-By 4.0 · Data source: OpenCorporates

375,180 rows sorted by previous_company_number

View and edit SQL

id confidence data_type publication_date retrieved_at source_url start_date start_date_type subsequent_registration_start_date company_id previous_company_number ▼ previous_jurisdiction_code previous_entity_type subsequent_company_number subsequent_jurisdiction_code subsequent_entity_type sample_date alternate_company_number alternate_jurisdiction_code alternate_entity_type previous_registration_end_date
2 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRA492             2018-11-01 F1103R_HRA492 de company  
3 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRA492             2018-11-01 M1201_HRA16068 de company  
4 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   X1321R_HRA1456IZ             2018-11-01 X1321R_HRA1456IZ de company  
5 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   X1321R_HRA1456IZ             2018-11-01 X1321R_HRA1860ME de company  
6 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R2713_HRA5300             2018-11-01 R1101_HRA15277 de company  
7 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R2713_HRA5300             2018-11-01 R2713_HRA5300 de company  
10 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   K1101R_HRB95838             2018-11-01 H1101_H1101_HRB23345 de company  
11 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   K1101R_HRB95838             2018-11-01 K1101R_HRB95838 de company  
33 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   B8535_HRA250254             2018-11-01 B8535_HRA231543 de company  
34 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   B8535_HRA250254             2018-11-01 B8535_HRA250254 de company  
35 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   B8535_HRB1666             2018-11-01 B8535_HRB1666 de company  
36 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   B8535_HRB1666             2018-11-01 F1103R_HRB1960 de company  
73 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   D2601V_HRA99464             2018-11-01 D2601V_HRA99464 de company  
74 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   D2601V_HRA99464             2018-11-01 K1101R_HRA115095 de company  
94 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R1202_HRB9092             2018-11-01 R1202_HRB9092 de company  
95 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R1202_HRB9092             2018-11-01 R2503_HRB15364 de company  
102 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R2503_HRB17420             2018-11-01 R2503_HRB17420 de company  
103 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R2503_HRB17420             2018-11-01 R3306_HRB117 de company  
104 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R2713_HRB9692             2018-11-01 P2305_HRB53744 de company  
105 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R2713_HRB9692             2018-11-01 R2713_HRB9692 de company  
106 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R3201_HRB18384             2018-11-01 M1201_HRB12394 de company  
107 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R3201_HRB18384             2018-11-01 R3201_HRB18384 de company  
109 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R3306_HRB29259             2018-11-01 F1103R_HRB64059 de company  
110 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R3306_HRB29259             2018-11-01 R3306_HRB29259 de company  
117 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   M1114_HRA22145             2018-11-01 M1114_HRA22145 de company  
118 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   M1114_HRA22145             2018-11-01 M1114_HRA32011 de company  
119 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   M1201_HRA29821             2018-11-01 M1201_HRA29821 de company  
120 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   M1201_HRA29821             2018-11-01 Y1206_HRA102181 de company  
137 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   P2305_HRB6580             2018-11-01 F1103R_HRB321 de company  
138 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   P2305_HRB6580             2018-11-01 P2305_HRB6580 de company  
235 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   X1517R_HRB6127KI             2018-11-01 K1101R_HRB87366 de company  
236 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   X1517R_HRB6127KI             2018-11-01 X1517R_HRB6127KI de company  
283 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   D2601V_HRB6684             2018-11-01 D2601V_HRB6684 de company  
284 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   D2601V_HRB6684             2018-11-01 F1103R_HRB12300 de company  
304 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   X1112R_HRA4296FL             2018-11-01 X1112R_HRA1081SL de company  
305 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   X1112R_HRA4296FL             2018-11-01 X1112R_HRA1752HU de company  
306 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   X1112R_HRA4296FL             2018-11-01 X1112R_HRA4296FL de company  
307 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   Y1206_HRA301173             2018-11-01 Y1206_HRA301173 de company  
308 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   Y1206_HRA301173             2018-11-01 Y1206_Y1304_HRA301174 de company  
309 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R2713_HRA5000             2018-11-01 R1101_HRA14000 de company  
310 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R2713_HRA5000             2018-11-01 R2713_HRA5000 de company  
311 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB1360             2018-11-01 D2601V_HRB6521 de company  
312 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB1360             2018-11-01 F1103R_HRB1360 de company  
313 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R1101_HRA13899             2018-11-01 F1103R_HRA29894 de company  
314 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R1101_HRA13899             2018-11-01 R1101_HRA13899 de company  
315 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB11982             2018-11-01 F1103R_HRB11982 de company  
316 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB11982             2018-11-01 K1101R_HRB21007 de company  
317 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB61             2018-11-01 F1103R_HRB61 de company  
318 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB61             2018-11-01 M1201_HRB8060 de company  
319 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB24900             2018-11-01 D2601V_HRB7158 de company  
320 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB24900             2018-11-01 F1103R_HRB24900 de company  
321 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   M1202_HRA3400             2018-11-01 M1201_HRA29813 de company  
322 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   M1202_HRA3400             2018-11-01 M1202_HRA3400 de company  
323 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB1968             2018-11-01 F1103R_HRB1968 de company  
324 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB1968             2018-11-01 R3306_HRB1710 de company  
325 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   K1101R_HRB104663             2018-11-01 F1103R_HRB49645 de company  
326 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   K1101R_HRB104663             2018-11-01 K1101R_HRB104663 de company  
327 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R2809_HRA2232             2018-11-01 R2307_HRA3406 de company  
328 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R2809_HRA2232             2018-11-01 R2809_HRA2232 de company  
329 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   P2305_HRB58285             2018-11-01 K1101R_HRB74288 de company  
330 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   P2305_HRB58285             2018-11-01 P2305_HRB58285 de company  
331 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   G1312_HRB17522             2018-11-01 F1103R_HRB91985 de company  
332 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   G1312_HRB17522             2018-11-01 G1312_HRB17522 de company  
333 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   N1105V_HRB1             2018-11-01 N1105V_HRB1 de company  
334 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   N1105V_HRB1             2018-11-01 P2305_HRB4667 de company  
335 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB1077             2018-11-01 F1103R_HRB1077 de company  
336 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB1077             2018-11-01 M1201_HRB14345 de company  
337 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   P2305_HRB55780             2018-11-01 F1103R_HRB45111 de company  
338 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   P2305_HRB55780             2018-11-01 P2305_HRB55780 de company  
339 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB2088             2018-11-01 D2601V_HRB42143 de company  
340 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB2088             2018-11-01 F1103R_HRB2088 de company  
341 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB1787             2018-11-01 F1103R_HRB1787 de company  
342 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB1787             2018-11-01 P2305_HRB4926 de company  
343 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB11983             2018-11-01 F1103R_HRB11983 de company  
344 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB11983             2018-11-01 K1101R_HRB20748 de company  
345 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB1603             2018-11-01 D2601V_HRB42000 de company  
346 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB1603             2018-11-01 F1103R_HRB1603 de company  
347 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   M1906_HRB2218             2018-11-01 F1103R_HRB4529 de company  
348 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   M1906_HRB2218             2018-11-01 M1906_HRB2218 de company  
349 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB652             2018-11-01 D2601V_HRB2194 de company  
350 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   F1103R_HRB652             2018-11-01 F1103R_HRB652 de company  
410 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   P3210_P3201_HRB435             2018-11-01 F1103R_HRB1159 de company  
411 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   P3210_P3201_HRB435             2018-11-01 P3210_P3201_HRB435 de company  
450 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   H1101_H1101_HRB4062             2018-11-01 H1101_H1101_HRB4062 de company  
451 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   H1101_H1101_HRB4062             2018-11-01 K1101R_HRB42653 de company  
60352 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R1101_HRA12303             2018-11-01 D2601V_HRA97160 de company  
60353 MEDIUM alternate-registration   2018-11-01 https://www.handelsregister.de 2018-11-01 before   R1101_HRA12303             2018-11-01 R1101_HRA12303 de company  
13460 MEDIUM subsequent-registration 2010-04-19 2017-06-27T01:18:23Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=184328&land_abk=bw 2010-04-12 at 2010-04-12 B1204_HRA260426 B1204_HRA260426 de company B8534_HRA725091 de company          
13461 MEDIUM subsequent-registration 2013-01-07 2017-06-27T16:46:18Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=341548&land_abk=bw 2013-01-02 at 2013-01-02 B1204_HRA260577 B1204_HRA260577 de company B8535_HRA704689 de company          
13462 MEDIUM subsequent-registration 2014-08-27 2017-06-28T00:45:08Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=443761&land_abk=bw 2014-08-27 at 2014-08-27 B1204_HRA261126 B1204_HRA261126 de company M1405_HRA4543 de company          
13463 MEDIUM subsequent-registration 2013-11-18 2017-06-27T20:59:20Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=394827&land_abk=bw 2013-11-14 at 2013-11-14 B1204_HRA270363 B1204_HRA270363 de company D2601V_HRA101444 de company          
13464 MEDIUM subsequent-registration 2012-01-23 2017-06-27T12:25:27Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=286873&land_abk=bw 2012-01-16 at 2012-01-16 B1204_HRA280458 B1204_HRA280458 de company B8535_HRA704082 de company          
13465 MEDIUM subsequent-registration 2011-12-19 2017-06-27T11:52:00Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=279618&land_abk=bw 2011-12-14 at 2011-12-14 B1204_HRA310463 B1204_HRA310463 de company R1402_HRA6121 de company          
125003 MEDIUM subsequent-registration 2011-12-15 2017-06-29T19:40:40Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=741376&land_abk=nw 2011-12-13 at   R1402_HRA6121 B1204_HRA310463 de company R1402_HRA6121 de company         2011-12-13
78727 MEDIUM subsequent-registration 2009-12-30 2017-06-27T20:49:04Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=162659&land_abk=he 2009-12-29 at   M1103_HRA84101 B1204_HRA320053 de company M1103_HRA84101 de company         2009-12-29
13466 MEDIUM subsequent-registration 2014-09-08 2017-06-28T00:53:51Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=445771&land_abk=bw 2014-09-08 at 2014-09-08 B1204_HRA380926 B1204_HRA380926 de company D2601V_HRA102650 de company          
13467 MEDIUM subsequent-registration 2008-04-14 2017-06-26T18:25:00Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=69673&land_abk=bw 2008-04-09 at 2008-04-09 B1204_HRA391328 B1204_HRA391328 de company D4708V_HRA6091 de company          
209393 MEDIUM subsequent-registration 2007-10-10 2017-06-26T17:21:48Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=50047&land_abk=be 2007-10-08 at   F1103R_HRA40257 B1204_HRA4238 de company F1103R_HRA40257 de company         2007-10-08
13468 MEDIUM subsequent-registration 2014-09-26 2017-06-28T01:06:45Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=448730&land_abk=bw 2014-09-26 at 2014-09-26 B1204_HRA4285 B1204_HRA4285 de company B8535_HRA705802 de company          
13469 MEDIUM subsequent-registration 2018-08-21 2018-10-16T10:48:36Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=692796&land_abk=bw 2018-08-21 at 2018-08-21 B1204_HRA4604 B1204_HRA4604 de company M1103_HRA86183 de company          

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE registrations (
	id INTEGER NOT NULL, 
	confidence TEXT, 
	data_type TEXT, 
	publication_date TEXT, 
	retrieved_at TEXT, 
	source_url TEXT, 
	start_date TEXT, 
	start_date_type TEXT, 
	subsequent_registration_start_date TEXT, 
	company_id TEXT, 
	previous_company_number TEXT, 
	previous_jurisdiction_code TEXT, 
	previous_entity_type TEXT, 
	subsequent_company_number TEXT, 
	subsequent_jurisdiction_code TEXT, 
	subsequent_entity_type TEXT, sample_date TEXT, alternate_company_number TEXT, alternate_jurisdiction_code TEXT, alternate_entity_type TEXT, previous_registration_end_date TEXT, 
	PRIMARY KEY (id)
)
Powered by Datasette · Query took 3332.233ms · Data license: CC-By 4.0 · Data source: OpenCorporates