home / openregister

company

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

5,305,727 rows sorted by native_company_number

View and edit SQL

id company_number current_status jurisdiction_code name registered_address retrieved_at register_flag_AD register_flag_CD register_flag_DK register_flag_HD register_flag_SI register_flag_UT register_flag_VOE federal_state native_company_number ▼ registered_office registrar register_art register_nummer former_registrar register_flag_ register_flag_Note: _registerNummerSuffix register_flag_Status information
1356963 R3101_GnR202 currently registered de Gemeinnützige Baugenossenschaft eG Herzogenrath Geilenkirchener Straße 19, 52134 Herzogenrath. 2018-06-18T18:31:38Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen GnR 202 Herzogenrath Aachen GnR 202          
1358120 R3101_GnR204 removed de Tabakwaren-Großeinkauf Aachen eingetragene Genossenschaft   2018-06-18T18:36:30Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 204 Aachen Aachen GnR 204          
1359167 R3101_GnR207 currently registered de Aachener Wohnungsgenossenschaft eG - Eigenheimbau Aachen - Schildstraße 13, 52062 Aachen. 2018-06-18T18:43:41Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen GnR 207 Aachen Aachen GnR 207          
923176 R3101_GnR210 currently registered de Fleischerei- und Gastronomie-Service Aachen-Düren eG Im Erdbeerfeld 20, 52078 Aachen. 2018-10-18T00:40:12Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen GnR 210 Aachen Aachen GnR 210          
1362286 R3101_GnR213 removed de Raiffeisenbank Walheim-Kornelimünster eG   2018-06-18T18:58:07Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 213 Aachen Aachen GnR 213          
1362865 R3101_GnR214 removed de Volksbank Aachen Süd eG   2018-06-18T19:00:31Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 214 Aachen Aachen GnR 214          
887492 R3101_GnR215 currently registered de Aachener Bank eG Theaterstr. 2018-10-17T04:46:24Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen GnR 215 Aachen Aachen GnR 215          
1363832 R3101_GnR217 removed de "Edeka" Aachen eingetragene Genossenschaft   2018-06-18T19:07:41Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 217 Roetgen Aachen GnR 217          
1364603 R3101_GnR218 removed de Raiffeisenbank Alsdorf eG.   2018-06-18T19:10:03Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 218 Alsdorf Aachen GnR 218          
887491 R3101_GnR219 currently registered de VR-Bank eG Kaiserstraße 75-79, 52146 Würselen. 2018-10-17T04:46:23Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen GnR 219 Würselen Aachen GnR 219          
1366312 R3101_GnR222 removed de Holz Genossenschaft Aachen eG.   2018-06-18T19:19:39Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 222 Aachen Aachen GnR 222          
1368413 R3101_GnR226 removed de VOLKSBANK HERZOGENRATH EG   2018-06-18T19:29:12Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 226 Herzogenrath Aachen GnR 226          
1369058 R3101_GnR228 currently registered de Genossenschaft Aachener Friedhofsgärtner eingetragene Genossenschaft Vaalser Str. 2018-06-18T19:33:57Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen GnR 228 Aachen Aachen GnR 228          
887493 R3101_GnR231 removed de Spar- und Darlehnskasse Hoengen eG Jülicher Straße 224, 52477 Alsdorf-Hoengen. 2018-10-17T04:46:27Z 0 1 0 1 0 1 1 North Rhine-Westphalia Aachen GnR 231 Alsdorf-Hoengen Aachen GnR 231          
1370996 R3101_GnR232 removed de Raiffeisenbank Loverich-Setterich eG   2018-06-18T19:43:35Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 232 Baesweiler-Setterich Aachen GnR 232          
1371379 R3101_GnR233 removed de Lovericher Bezugs- und Absatzgenossenschaft eingetragene Genossenschaft   2018-06-18T19:45:57Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 233 Baesweiler -Loverich Aachen GnR 233          
1371899 R3101_GnR234 removed de Raiffeisenbank Baesweiler e.G.   2018-06-18T19:48:39Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 234 Baesweiler Aachen GnR 234          
1372057 R3101_GnR235 currently registered de Baugenossenschaft Baesweiler eG.   2018-06-18T19:51:01Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen GnR 235 Baesweiler Aachen GnR 235          
1372950 R3101_GnR237 removed de Aachener Bank eG Volksbank Filiale Alsdorf   2018-06-18T19:56:10Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 237 Alsdorf Aachen GnR 237          
1374250 R3101_GnR239 removed de VFA Vieh- und Fleischversorgung Aachen eG.   2018-06-18T20:01:04Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 239 Aachen Aachen GnR 239          
1374306 R3101_GnR240 removed de AFZ Funkzentrale eG.   2018-06-18T20:03:26Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 240 Aachen Aachen GnR 240          
1375066 R3101_GnR241 removed de remeber e. G. Kollektiv für regenerative Energie, Meßtechnik. Medienarbeit und Beratung   2018-06-18T20:05:49Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 241 Aachen Aachen GnR 241          
1375260 R3101_GnR242 removed de DEG Aachen Zweigniederlassung der DEG Alles für das Dach eG   2018-06-18T20:08:11Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 242 Aachen Aachen GnR 242          
1375995 R3101_GnR243 removed de Volksbank Aachen-Eilendorf Niederlassung der VOLKSBANK STOLBERG-ESCHWEILER eG   2018-06-18T20:10:34Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 243 Aachen-Eilendorf Aachen GnR 243          
1376349 R3101_GnR244 removed de Raiffeisenbank Baesweiler Zweigniederlassung der VR-Bank eG   2018-06-18T20:12:59Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 244 Baesweiler Aachen GnR 244          
1376791 R3101_GnR245 removed de Raiffeisenbank Loverich-Setterich Zweigniederlassung der VR-Bank eG   2018-06-18T20:15:22Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 245 Baesweiler-Setterich Aachen GnR 245          
1377222 R3101_GnR246 removed de Raiffeisenbank Alsdorf Zweigniederlassung der VR-Bank eG   2018-06-18T20:17:50Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 246 Alsdorf Aachen GnR 246          
1377768 R3101_GnR247 removed de VR-Bank Aachen Zweigniederlassung der VR- Bank eG   2018-06-18T20:20:11Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 247 Aachen-Haaren Aachen GnR 247          
887495 R3101_GnR248 currently registered de Raiffeisenbank eG Hauptstr. 2019-01-30T17:04:20Z 1 1 1 1 1 1 0 North Rhine-Westphalia Aachen GnR 248 Simmerath Aachen GnR 248          
1378303 R3101_GnR249 currently registered de co op - Eifel eingetragene Genossenschaft Nassenhof 2, 52156 Monschau. 2018-06-18T20:24:56Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen GnR 249 Monschau-Mützenich Aachen GnR 249          
1378735 R3101_GnR250 removed de co op Monschau-Land eingetragene Genossenschaft   2018-06-18T20:27:20Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 250 Monschau-Kalterherberg Aachen GnR 250          
1379182 R3101_GnR251 currently registered de co op Rohren eingetragene Genossenschaft Dröft 11, 52156 Monschau. 2018-06-18T20:29:43Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen GnR 251 Monschau-Rohren Aachen GnR 251          
1003454 R3101_GnR252 currently registered de Konsumgenossenschaft Eicherscheid e.G.   2018-11-05T17:13:42Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen GnR 252 Simmerath-Eicherscheid Aachen GnR 252          
1380366 R3101_GnR253 removed de Wasserversorgungsgenossenschaft Einruhr eG   2018-06-18T20:34:32Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 253 Simmerah/Einruhr Aachen GnR 253          
1380781 R3101_GnR254 removed de VR-Bank Rur-Wurm eG Apweilerstraße 11, 52511 Geilenkirchen. 2018-06-18T20:36:55Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 254 Geilenkirchen-Immendorf Aachen GnR 254          
1381096 R3101_GnR255 removed de Raiffeisenbank Selfkant eG   2018-06-18T20:39:17Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 255 Gangelt Aachen GnR 255          
1381526 R3101_GnR256 removed de Raiffeisenbank eingetragene Genossenschaft   2018-06-18T20:41:38Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 256 Geilenkirchen Aachen GnR 256          
1382014 R3101_GnR257 currently registered de Volksbank Heinsberg eG Siemensstraße 5, 52525 Heinsberg. 2018-06-18T20:44:01Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen GnR 257 Heinsberg Aachen GnR 257          
1382160 R3101_GnR258 currently registered de Gemeinnütziger Bauverein Heinsberg eG   2018-06-18T20:46:22Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen GnR 258 Heinsberg Aachen GnR 258          
1382834 R3101_GnR259 currently registered de Volksbank Haaren e.G. Johannesstr. 2019-01-30T17:04:23Z 1 1 1 1 1 1 0 North Rhine-Westphalia Aachen GnR 259 Waldfeucht-Haaren Aachen GnR 259          
1383240 R3101_GnR260 currently registered de Wohnungsgenossenschaft Eschweiler eG Merkurstr. 2018-06-18T20:51:11Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen GnR 260 Eschweiler Aachen GnR 260          
1383531 R3101_GnR261 currently registered de Raiffeisen-Bank Eschweiler eG Franzstr. 2018-06-18T20:53:31Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen GnR 261 Eschweiler Aachen GnR 261          
1384060 R3101_GnR262 currently registered de WoGe Wohnungsgenossenschaft 1900 eG Stolberg Rhld. Ritzefeldstr. 2018-06-18T20:55:54Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen GnR 262 Stolberg Aachen GnR 262          
1384386 R3101_GnR263 currently registered de Rinderbesamungsgenossenschaft Aachen eG   2018-06-18T20:58:16Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen GnR 263 Stolberg Aachen GnR 263          
1384864 R3101_GnR264 removed de VOLKSBANK STOLBERG - ESCHWEILER eG   2018-06-18T21:00:41Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 264 Stolberg Aachen GnR 264          
1385023 R3101_GnR265 currently registered de FVE Fleischversorgung Eschweiler eG Indestr. 2018-06-18T21:03:02Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen GnR 265 Eschweiler Aachen GnR 265          
1385444 R3101_GnR266 removed de GDS Gemeinschafts-Dienste Stolberg eG   2018-06-18T21:05:28Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen GnR 266 Stolberg Aachen GnR 266          
1386091 R3101_GnR267 currently registered de Weidegenossenschaft Schevenhütte eG   2018-06-18T21:08:35Z 1 1 1 0 1 1 1 North Rhine-Westphalia Aachen GnR 267 Stolberg-Schevenhütte Aachen GnR 267          
1386235 R3101_GnR268 removed de euregio-it eG   2018-06-18T21:10:59Z 0 1 1 0 0 1 1 North Rhine-Westphalia Aachen GnR 268 Aachen Aachen GnR 268          
1386864 R3101_GnR269 currently registered de Steinmetzgenossenschaft Grabeskirche eG An der Kapelle 3, 52076 Aachen. 2018-06-18T21:13:22Z 1 1 1 0 1 1 1 North Rhine-Westphalia Aachen GnR 269 Aachen Aachen GnR 269          
1387188 R3101_GnR270 removed de myOpenFactory eG   2018-06-18T21:15:45Z 0 1 0 0 0 1 1 North Rhine-Westphalia Aachen GnR 270 Aachen Aachen GnR 270          
1387476 R3101_GnR271 removed de GOÄ Aachen Land eG Pumpe 47, 52249 Eschweiler. 2018-06-18T21:18:08Z 0 1 1 0 0 1 1 North Rhine-Westphalia Aachen GnR 271 Eschweiler Aachen GnR 271          
1387824 R3101_GnR272 currently registered de DocNet-HS eG   2018-06-18T21:20:29Z 1 1 1 0 1 1 1 North Rhine-Westphalia Aachen GnR 272 Übach-Palenberg Aachen GnR 272          
923184 R3101_GnR273 removed de Gesundheitsnetz Aachen eG Friedrich-Wilhelm-Platz 5/6, c/o Doctor Michael Benning, 52062 Aachen. 2018-10-18T00:40:23Z 0 1 1 0 0 1 1 North Rhine-Westphalia Aachen GnR 273 Aachen Aachen GnR 273          
1388673 R3101_GnR274 currently registered de Gastroenterologisches Netzwerk Euregio Aachen eG Marienstraße 47-51, 52249 Eschweiler. 2018-06-18T21:25:14Z 1 1 1 0 1 1 1 North Rhine-Westphalia Aachen GnR 274 Eschweiler Aachen GnR 274          
1389227 R3101_GnR275 currently registered de RoadFood eG Römerstraße 21, 52064 Aachen. 2018-06-18T21:27:35Z 1 1 1 0 1 1 1 North Rhine-Westphalia Aachen GnR 275 Aachen Aachen GnR 275          
1389572 R3101_GnR276 currently registered de LebensWeGe Aachen eG   2018-06-18T21:29:57Z 1 1 1 0 1 1 1 North Rhine-Westphalia Aachen GnR 276 Aachen Aachen GnR 276          
1389914 R3101_GnR277 currently registered de ISOVIS eG   2018-06-18T21:32:20Z 1 1 1 0 1 1 1 North Rhine-Westphalia Aachen GnR 277 Monschau Aachen GnR 277          
1390377 R3101_GnR278 removed de Pecurö GmbH Eichsfeldstraße 86, 52223 Stolberg. 2018-06-18T21:34:42Z 0 1 1 0 0 1 1 North Rhine-Westphalia Aachen GnR 278 Aachen Aachen GnR 278          
1390773 R3101_GnR279 currently registered de PatchWorkHaus in Aachen - gemeinsam leben eG   2018-06-18T21:37:04Z 1 1 1 0 1 1 1 North Rhine-Westphalia Aachen GnR 279 Aachen Aachen GnR 279          
1390960 R3101_GnR280 currently registered de Bürgerwindenergie Heinsberg eG   2018-06-18T21:39:25Z 1 1 1 0 1 1 1 North Rhine-Westphalia Aachen GnR 280 Heinsberg Aachen GnR 280          
1391319 R3101_GnR281 currently registered de AMOS eG   2018-06-18T21:41:47Z 1 1 1 0 1 1 1 North Rhine-Westphalia Aachen GnR 281 Heinsberg Aachen GnR 281          
1391787 R3101_GnR282 currently registered de EWV Bürgerenergie eG   2018-06-18T21:44:12Z 1 1 1 0 1 1 1 North Rhine-Westphalia Aachen GnR 282 Stolberg Aachen GnR 282          
1315452 R3101_HRA100 currently registered de Aachener Misch- und Knetmaschinenfabrik Peter Küpper GmbH & Co. KG   2018-06-18T15:02:29Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen HRA 100 Aachen Aachen HRA 100          
1644560 R3101_HRA1000 removed de Kamann & Sohn   2018-06-19T17:35:59Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1000 Würselen Aachen HRA 1000          
1644933 R3101_HRA1001 currently registered de Hans Schloemer Reise- und Verkehrsbetrieb Maurerstraße 39, 52477 Alsdorf. 2018-06-19T17:38:23Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen HRA 1001 Alsdorf Aachen HRA 1001          
1649208 R3101_HRA1010 removed de Herbert Wimmer KG Tabakwaren Groß- und Einzelhandel   2018-06-19T19:01:58Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1010 Brand Aachen HRA 1010          
1651350 R3101_HRA1014 removed de Zigarren Speckgens GmbH & Co. KG   2018-06-19T19:11:39Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1014 Hohendodeleben Aachen HRA 1014          
1651630 R3101_HRA1015 removed de Knops-Winkens, Inh. Maria Uinkens e. Kfr.   2018-06-19T19:14:04Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1015 Kohlscheid Aachen HRA 1015          
1316446 R3101_HRA102 removed de E. Hellenthal & Cie Aachener Spiegel-Manufactur GmbH & Co KG.   2018-06-18T15:07:21Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 102 Aachen Aachen HRA 102          
1654053 R3101_HRA1020 removed de Schuhhaus Maria Mevissen Inh. Iris Koll   2018-06-19T19:26:12Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1020 Würselen Aachen HRA 1020          
1655134 R3101_HRA1023 removed de Baugesellschaft Kehl mit beschränkter Haftung & Co. Kommanditgesellschaft.   2018-06-19T19:33:31Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1023 Aachen Aachen HRA 1023          
1656156 R3101_HRA1025 removed de Friedrich Debus, Maschinenbau   2018-06-19T19:38:22Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1025 Herzogenrath-Kohlscheid Aachen HRA 1025          
1659303 R3101_HRA1032 removed de "Corso Restaurant Hotel Tanzbar Franz Horbach"   2018-06-19T19:55:17Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1032 Alsdorf Aachen HRA 1032          
1660366 R3101_HRA1034 currently registered de Elektro Schaefer, Inhaber Klaus Schaefer   2018-06-19T20:00:15Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen HRA 1034 Aachen Aachen HRA 1034          
1661216 R3101_HRA1036 removed de ASITRA Handels-Gesellschaft mbH & Co. Kommanditgesellschaft   2018-06-19T20:05:14Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1036 Aachen-Laurensberg Aachen HRA 1036          
1661895 R3101_HRA1037 currently registered de Josef Delheid   2018-06-19T20:07:38Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen HRA 1037 Aachen Aachen HRA 1037          
1664253 R3101_HRA1042 currently registered de Modehaus Willy Röttsches GmbH & Co. Kommanditgesellschaft   2018-06-19T20:19:44Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen HRA 1042 Aachen Aachen HRA 1042          
1666237 R3101_HRA1047 removed de Aachener Stadtreklame MOPLAK Kommunale Aussenwerbung GmbH & Co. Kommanditgesellschaft   2018-06-19T20:31:53Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1047 Aachen Aachen HRA 1047          
1667924 R3101_HRA1050 removed de Peter Wilhelmy   2018-06-19T20:39:05Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1050 Aachen Aachen HRA 1050          
1668251 R3101_HRA1051 removed de Herd-Schmitz, Peter Schmitz GmbH & Co. Grüner Weg 37, 52070 Aachen. 2018-06-19T20:41:32Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1051 Aachen Aachen HRA 1051          
1669349 R3101_HRA1053 currently registered de Sport-Mulack Gerards OHG   2018-06-19T20:46:20Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen HRA 1053 Aachen Aachen HRA 1053          
1672887 R3101_HRA1061 currently registered de Hermann Körner   2018-06-19T21:05:41Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen HRA 1061 Kornelimünster Aachen HRA 1061          
1673258 R3101_HRA1062 currently registered de DEMMER Haus der Geschenke KG   2018-06-19T21:08:05Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen HRA 1062 Aachen Aachen HRA 1062          
1674642 R3101_HRA1065 removed de Deflex-Industriebedarf GmbH & Co. KG   2018-06-19T21:15:16Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1065 Aachen Aachen HRA 1065          
1675006 R3101_HRA1066 removed de "F R A P A L Bücken & Co. Kommanditgesellschaft"   2018-06-19T21:17:41Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1066 Würselen-Broichweiden Aachen HRA 1066          
1679223 R3101_HRA1075 removed de Debeur & Deden   2018-06-19T21:40:33Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1075 Aachen Aachen HRA 1075          
1682799 R3101_HRA1083 removed de Albert Haugg   2018-06-19T22:00:45Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1083 Aachen Aachen HRA 1083          
1686250 R3101_HRA1090 removed de Mode- u. Strumpfhaus Gebr. Bremen Inh. Dieter Böttner   2018-06-19T22:18:42Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1090 Aachen Aachen HRA 1090          
1688158 R3101_HRA1094 currently registered de Schreven Immobilien GmbH & Co. KG Gutenbergstraße 4, 52477 Alsdorf. 2018-06-19T22:28:51Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen HRA 1094 Alsdorf Aachen HRA 1094          
1285593 R3101_HRA11 removed de Franz Renerken & Söhne OHG Eygelshovener Straße 17 a, 52134 Herzogenrath. 2018-06-18T12:09:13Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 11 Würselen Aachen HRA 11          
1320501 R3101_HRA110 removed de Armaturenfabrik Metallgießerei Peter J. Schmitz GmbH & Co.   2018-06-18T15:26:48Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 110 Aachen Aachen HRA 110          
1695279 R3101_HRA1111 removed de Hirschapotheke Friedrich A. Keller Inh. Gert Keller   2018-06-19T23:27:00Z 0 0 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1111 Herzogenrath Aachen HRA 1111          
1700849 R3101_HRA1123 currently registered de Sporthaus Drucks GmbH & Co. KG Auerbachstraße 12, 52249 Eschweiler. 2018-06-19T23:57:40Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen HRA 1123 Aachen Aachen HRA 1123          
1707138 R3101_HRA1139 removed de Albert Hoppermanns KG.   2018-06-20T00:35:54Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1139 Aachen Aachen HRA 1139          
1709925 R3101_HRA1145 removed de Dr. Weipert & Co. Nachf.   2018-06-20T00:51:15Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 1145 Eilendorf Aachen HRA 1145          
1323013 R3101_HRA115 removed de J. G. Merckens GmbH & Co. Kommanditgesellschaft   2018-06-18T15:38:58Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 115 Aachen Aachen HRA 115          
1712277 R3101_HRA1150 removed de Hans von Mangoldt GmbH & Co. KG Hergelsbendenstr. 2018-06-20T01:04:00Z 0 1 0 1 0 1 1 North Rhine-Westphalia Aachen HRA 1150 Aachen-Haaren Aachen HRA 1150          
1714715 R3101_HRA1155 currently registered de Strumpf - Magazin Richard Göpfert   2018-06-20T01:16:44Z 1 1 1 1 1 1 1 North Rhine-Westphalia Aachen HRA 1155 Aachen Aachen HRA 1155          
1323429 R3101_HRA116 removed de FF Pagro Edmund Kronenberger e.K.   2018-06-18T15:41:22Z 0 1 1 1 0 1 1 North Rhine-Westphalia Aachen HRA 116 Aachen. Aachen HRA 116          

Next page

Advanced export

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

CSV options:

CREATE TABLE company (
	id INTEGER NOT NULL, 
	company_number TEXT, 
	current_status TEXT, 
	jurisdiction_code TEXT, 
	name TEXT, 
	registered_address TEXT, 
	retrieved_at TEXT, 
	"register_flag_AD" BOOLEAN, 
	"register_flag_CD" BOOLEAN, 
	"register_flag_DK" BOOLEAN, 
	"register_flag_HD" BOOLEAN, 
	"register_flag_SI" BOOLEAN, 
	"register_flag_UT" BOOLEAN, 
	"register_flag_VOE" BOOLEAN, 
	federal_state TEXT, 
	native_company_number TEXT, 
	registered_office TEXT, 
	registrar TEXT, 
	register_art TEXT, 
	register_nummer TEXT, 
	former_registrar TEXT, register_flag_ TEXT, "register_flag_Note:" TEXT, "_registerNummerSuffix" TEXT, "register_flag_Status information" TEXT, 
	PRIMARY KEY (id), 
	CHECK ("register_flag_AD" IN (0, 1)), 
	CHECK ("register_flag_CD" IN (0, 1)), 
	CHECK ("register_flag_DK" IN (0, 1)), 
	CHECK ("register_flag_HD" IN (0, 1)), 
	CHECK ("register_flag_SI" IN (0, 1)), 
	CHECK ("register_flag_UT" IN (0, 1)), 
	CHECK ("register_flag_VOE" IN (0, 1))
)
Powered by Datasette · Query took 1684.449ms · Data license: CC-By 4.0 · Data source: OpenCorporates