home / openregister

registrations

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

375,180 rows sorted by previous_entity_type

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  
1 MEDIUM subsequent-registration 2019-01-15 2019-01-29T23:32:58Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=387652&land_abk=hh 2019-01-15 at 2019-01-15 K1101R_HRB123809 K1101R_HRB123809 de company P2305_HRB217590 de company          
8 MEDIUM subsequent-registration 2019-01-08 2019-01-29T11:04:44Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=1619200&land_abk=nw 2019-01-08 at 2019-01-08 R1101_HRB52263 R1101_HRB52263 de company R1402_HRB17065 de company          
9 MEDIUM subsequent-registration 2019-01-21 2019-01-30T21:40:46Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=388427&land_abk=hh 2019-01-21 at 2019-01-21 K1101R_HRB98884 K1101R_HRB98884 de company X1721R_HRB18498HL de company          
12 MEDIUM subsequent-registration 2019-01-16 2019-01-30T08:40:01Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=1623359&land_abk=nw 2019-01-16 at 2019-01-16 R1101_HRB65947 R1101_HRB65947 de company U1206_HRB32188 de company          
13 MEDIUM subsequent-registration 2019-01-10 2019-01-29T17:01:53Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=1620598&land_abk=nw 2019-01-10 at 2019-01-10 R1101_HRB66512 R1101_HRB66512 de company R2713_HRB17715 de company          
14 MEDIUM subsequent-registration 2019-01-28 2019-01-31T01:29:01Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=389268&land_abk=hh 2019-01-28 at 2019-01-28 K1101R_HRB66654 K1101R_HRB66654 de company P2613_HRB207123 de company          
15 MEDIUM subsequent-registration 2019-01-22 2019-01-30T22:28:52Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=388608&land_abk=hh 2019-01-22 at 2019-01-22 K1101R_HRB89848 K1101R_HRB89848 de company W1215_HRB26565 de company          
16 MEDIUM subsequent-registration 2019-01-17 2019-01-30T10:05:46Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=388176&land_abk=hh 2019-01-17 at 2019-01-17 K1101R_HRB68777 K1101R_HRB68777 de company X1517R_HRB20300KI de company          
17 MEDIUM subsequent-registration 2019-01-14 2019-01-29T21:50:38Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=1621721&land_abk=nw 2019-01-14 at 2019-01-14 R1101_HRB68831 R1101_HRB68831 de company X1517R_HRB20267KI de company          
18 MEDIUM subsequent-registration 2019-01-23 2019-01-30T23:18:47Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=388847&land_abk=hh 2019-01-23 at 2019-01-23 K1101R_HRB69313 K1101R_HRB69313 de company F1103R_HRB202748 de company          
19 MEDIUM subsequent-registration 2019-01-21 2019-01-30T21:59:23Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=1625264&land_abk=nw 2019-01-21 at 2019-01-21 R1101_HRB70211 R1101_HRB70211 de company X1721R_HRB18503HL de company          
20 MEDIUM subsequent-registration 2019-01-28 2019-01-31T01:29:04Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=389224&land_abk=hh 2019-01-28 at 2019-01-28 K1101R_HRB74141 K1101R_HRB74141 de company P2613_HRB207118 de company          
21 MEDIUM subsequent-registration 2019-01-11 2019-01-29T19:35:08Z https://www.handelsregisterbekanntmachungen.de/en/skripte/hrb.php?rb_id=1621367&land_abk=nw 2019-01-11 at 2019-01-11 R1101_HRB79186 R1101_HRB79186 de company M1201_HRB114127 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 587.015ms · Data license: CC-By 4.0 · Data source: OpenCorporates