Companies
Data license: CC-By 4.0
2,191,815 rows sorted by lastSeenDate
This data as json, CSV (advanced)
Link | rowid | companyId | firstSeenDate | lastSeenDate ▼ | foundedDate | dissolutionDate |
---|---|---|---|---|---|---|
1871502 | 1871502 | W1215_HRB3833 | 2002-06-05 | 2002-06-05 | 2002-06-05 | |
2134613 | 2134613 | W1215_HRB3830 | 2002-06-05 | 2002-06-05 | 2002-06-05 | |
260470 | 260470 | W1215_HRB85 | 2002-06-06 | 2002-06-06 | ||
533550 | 533550 | W1215_HRB3840 | 2002-06-06 | 2002-06-06 | 2002-06-06 | |
1341397 | 1341397 | W1215_HRB1139 | 2002-06-06 | 2002-06-06 | ||
1344451 | 1344451 | W1215_HRB3126 | 2002-06-06 | 2002-06-06 | ||
1344550 | 1344550 | W1215_HRB3837 | 2002-06-06 | 2002-06-06 | 2002-06-06 | |
1344551 | 1344551 | W1215_HRB3843 | 2002-06-06 | 2002-06-06 | 2002-06-06 | |
1607480 | 1607480 | W1215_HRB2912 | 2002-06-06 | 2002-06-06 | ||
1870570 | 1870570 | W1215_HRB2374 | 2002-06-06 | 2002-06-06 | ||
1870880 | 1870880 | W1215_HRB2676 | 2002-06-06 | 2002-06-06 | ||
1344027 | 1344027 | W1215_HRB2750 | 2002-06-07 | 2002-06-07 | ||
259906 | 259906 | W1215_HRB3846 | 2002-06-12 | 2002-06-12 | 2002-06-12 | |
533398 | 533398 | W1215_HRB3078 | 2002-06-12 | 2002-06-12 | ||
806198 | 806198 | W1215_HRB2433 | 2002-06-12 | 2002-06-12 | ||
1344514 | 1344514 | W1215_HRB3433 | 2002-06-12 | 2002-06-12 | ||
533551 | 533551 | W1215_HRB3850 | 2002-06-13 | 2002-06-13 | 2002-06-13 | |
1080130 | 1080130 | W1215_HRB2952 | 2002-06-13 | 2002-06-13 | ||
1344552 | 1344552 | W1215_HRB3851 | 2002-06-13 | 2002-06-13 | 2002-06-13 | |
2134579 | 2134579 | W1215_HRB3484 | 2002-06-13 | 2002-06-13 | ||
256831 | 256831 | W1215_HRB125 | 2002-06-19 | 2002-06-19 | ||
259281 | 259281 | W1215_HRB269 | 2002-06-19 | 2002-06-19 | ||
1343654 | 1343654 | W1215_HRB2414 | 2002-06-19 | 2002-06-19 | ||
1868777 | 1868777 | W1215_HRB130 | 2002-06-19 | 2002-06-19 | ||
1871893 | 1871893 | W1215_HRB72 | 2002-06-19 | 2002-06-19 | ||
533552 | 533552 | W1215_HRB3854 | 2002-06-21 | 2002-06-21 | 2002-06-21 | |
259908 | 259908 | W1215_HRB3855 | 2002-06-25 | 2002-06-25 | 2002-06-25 | |
260338 | 260338 | W1215_HRB745 | 2002-06-26 | 2002-06-26 | ||
533555 | 533555 | W1215_HRB3861 | 2002-06-26 | 2002-06-26 | 2002-06-26 | |
1871508 | 1871508 | W1215_HRB3864 | 2002-07-03 | 2002-07-03 | 2002-07-03 | |
1344540 | 1344540 | W1215_HRB3675 | 2002-07-04 | 2002-07-04 | ||
2134618 | 2134618 | W1215_HRB3868 | 2002-07-04 | 2002-07-04 | 2002-07-04 | |
806930 | 806930 | W1215_HRB3090 | 2002-07-05 | 2002-07-05 | ||
1079861 | 1079861 | W1215_HRB2706 | 2002-07-08 | 2002-07-08 | ||
532533 | 532533 | W1215_HRB2292 | 2002-07-09 | 2002-07-09 | ||
1871321 | 1871321 | W1215_HRB3069 | 2002-07-09 | 2002-07-09 | ||
1344554 | 1344554 | W1215_HRB3871 | 2002-07-11 | 2002-07-11 | 2002-07-11 | |
2134583 | 2134583 | W1215_HRB3536 | 2002-07-11 | 2002-07-11 | ||
260195 | 260195 | W1215_HRB62 | 2002-07-12 | 2002-07-12 | ||
1605757 | 1605757 | W1215_HRB2017 | 2002-07-12 | 2002-07-12 | ||
1607780 | 1607780 | W1215_HRB3693 | 2002-07-15 | 2002-07-15 | ||
806268 | 806268 | W1215_HRB2490 | 2002-07-16 | 2002-07-16 | ||
1079374 | 1079374 | W1215_HRB229 | 2002-07-19 | 2002-07-19 | ||
2135200 | 2135200 | W1215_HRB932 | 2002-07-19 | 2002-07-19 | ||
1869778 | 1869778 | W1215_HRB2084 | 2002-07-22 | 2002-07-22 | ||
804899 | 804899 | W1215_HRB1917 | 2002-07-23 | 2002-07-23 | ||
1344553 | 1344553 | W1215_HRB3863 | 2002-06-27 | 2002-07-24 | 2002-06-27 | |
1871157 | 1871157 | W1215_HRB2910 | 2002-07-24 | 2002-07-24 | ||
807077 | 807077 | W1215_HRB3578 | 2002-07-25 | 2002-07-25 | ||
2189238 | 2189238 | W1215_HRB1987 | 2002-07-25 | 2002-07-25 | ||
259867 | 259867 | W1215_HRB3519 | 2002-07-29 | 2002-07-29 | ||
533244 | 533244 | W1215_HRB2949 | 2002-07-30 | 2002-07-30 | ||
533558 | 533558 | W1215_HRB3880 | 2002-07-30 | 2002-07-30 | 2002-07-30 | |
1080770 | 1080770 | W1215_HRB678 | 2002-07-30 | 2002-07-30 | ||
1344518 | 1344518 | W1215_HRB3473 | 2002-07-31 | 2002-07-31 | ||
1607518 | 1607518 | W1215_HRB2951 | 2002-07-03 | 2002-08-05 | ||
807040 | 807040 | W1215_HRB3246 | 2002-08-06 | 2002-08-06 | ||
1344556 | 1344556 | W1215_HRB3884 | 2002-08-06 | 2002-08-06 | 2002-08-06 | |
807101 | 807101 | W1215_HRB3886 | 2002-08-07 | 2002-08-07 | 2002-08-07 | |
1871511 | 1871511 | W1215_HRB3887 | 2002-08-08 | 2002-08-08 | 2002-08-08 | |
259251 | 259251 | W1215_HRB2664 | 2002-08-26 | 2002-08-26 | 2002-08-26 | |
806452 | 806452 | W1215_HRB2663 | 2002-08-26 | 2002-08-26 | 2002-08-26 | |
1344513 | 1344513 | W1215_HRB3426 | 2002-08-26 | 2002-08-26 | ||
1608290 | 1608290 | W1215_HRB792 | 2002-08-26 | 2002-08-26 | ||
1608405 | 1608405 | W1215_HRB898 | 2002-08-26 | 2002-08-26 | ||
2132759 | 2132759 | W1215_HRB2058 | 2002-08-26 | 2002-08-26 | ||
804161 | 804161 | W1215_HRB1302 | 2002-08-27 | 2002-08-27 | ||
930014 | 930014 | H1101_HRB3487-W1215_HRB2348 | 2002-08-27 | 2002-08-27 | ||
1080415 | 1080415 | W1215_HRB3430 | 2002-08-27 | 2002-08-27 | ||
1607808 | 1607808 | W1215_HRB3893 | 2002-08-27 | 2002-08-27 | 2002-08-27 | |
1607866 | 1607866 | W1215_HRB440 | 2002-08-27 | 2002-08-27 | ||
1871512 | 1871512 | W1215_HRB3892 | 2002-08-27 | 2002-08-27 | 2002-08-27 | |
1871444 | 1871444 | W1215_HRB3198 | 2002-08-28 | 2002-08-28 | ||
1344531 | 1344531 | W1215_HRB3605 | 2002-06-06 | 2002-08-29 | ||
1871494 | 1871494 | W1215_HRB3767 | 2002-08-29 | 2002-08-29 | ||
259341 | 259341 | W1215_HRB2742 | 2002-09-03 | 2002-09-03 | ||
259910 | 259910 | W1215_HRB3896 | 2002-09-03 | 2002-09-03 | 2002-09-03 | |
1080464 | 1080464 | W1215_HRB3897 | 2002-09-03 | 2002-09-03 | 2002-09-03 | |
1870728 | 1870728 | W1215_HRB2541 | 2002-08-27 | 2002-09-03 | ||
1871215 | 1871215 | W1215_HRB2963 | 2002-09-03 | 2002-09-03 | ||
1607028 | 1607028 | W1215_HRB252 | 2002-09-04 | 2002-09-04 | ||
260452 | 260452 | W1215_HRB838 | 2002-09-05 | 2002-09-05 | ||
1344823 | 1344823 | W1215_HRB621 | 2002-09-05 | 2002-09-05 | ||
1869181 | 1869181 | W1215_HRB1717 | 2002-09-06 | 2002-09-06 | ||
1038240 | 1038240 | R3101_HRB3025 | 2002-11-06 | 2002-11-06 | 2002-11-06 | |
126708 | 126708 | M1114_HRB40400 | 2003-05-27 | 2003-05-27 | 2003-05-27 | |
2134641 | 2134641 | W1215_HRB4064 | 2003-05-28 | 2003-05-28 | 2003-05-28 | |
498046 | 498046 | R3306_HRB29258 | 2003-11-14 | 2003-11-14 | 2003-11-14 | |
519834 | 519834 | U1110_HRB1339-R2404_HRB4064 | 2004-04-14 | 2004-04-14 | 2004-04-14 | |
1839210 | 1839210 | R3306_HRB49291 | 2004-09-10 | 2004-09-10 | ||
748214 | 748214 | R2404_HRB2288 | 2004-10-11 | 2004-10-11 | 2004-10-11 | |
738410 | 738410 | R2101_HRB34760 | 2004-10-26 | 2004-10-26 | ||
1542444 | 1542444 | R2101_HRB35661 | 2004-10-26 | 2004-10-26 | ||
464794 | 464794 | R2101_HRB31075 | 2004-10-27 | 2004-10-27 | ||
1012084 | 1012084 | R2101_HRB31897 | 2004-10-28 | 2004-10-28 | ||
1806149 | 1806149 | R2101_HRB38194 | 2004-11-24 | 2004-11-24 | ||
2069160 | 2069160 | R2101_HRB38195 | 2004-11-24 | 2004-11-24 | ||
464864 | 464864 | R2101_HRB33307 | 2004-12-02 | 2004-12-02 | ||
1022132 | 1022132 | R2404_HRB4800 | 2004-12-02 | 2004-12-02 | 2004-12-02 | |
1542451 | 1542451 | R2101_HRB35714 | 2004-12-07 | 2004-12-07 | 2004-12-07 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "Companies" ( "companyId" varchar, "firstSeenDate" date, "lastSeenDate" date, "foundedDate" date, "dissolutionDate" date ); CREATE INDEX "CompaniesCompanyId" ON "Companies" ( "companyId" );