Companies
Data license: CC-By 4.0
2,191,815 rows sorted by foundedDate
This data as json, CSV (advanced)
Link | rowid | companyId | firstSeenDate | lastSeenDate | foundedDate ▼ | dissolutionDate |
---|---|---|---|---|---|---|
215 | 215 | B1601_HRB105284 | 2011-11-09 | 2013-01-07 | 2013-01-07 | |
216 | 216 | B1601_HRB105295 | 2007-09-14 | 2018-08-14 | ||
217 | 217 | B1601_HRB105321 | 2012-08-10 | 2022-04-11 | 2022-04-11 | |
219 | 219 | B1601_HRB105389 | 2014-04-30 | 2014-04-30 | ||
220 | 220 | B1601_HRB105404 | 2011-03-17 | 2011-05-25 | 2011-05-25 | |
221 | 221 | B1601_HRB105409 | 2015-11-05 | 2015-11-05 | ||
222 | 222 | B1601_HRB105448 | 2009-07-21 | 2009-10-12 | 2009-10-12 | |
223 | 223 | B1601_HRB105470 | 2007-03-08 | 2007-03-08 | 2007-03-08 | |
224 | 224 | B1601_HRB105476 | 2009-06-05 | 2009-06-05 | 2009-06-05 | |
225 | 225 | B1601_HRB105483 | 2007-10-05 | 2007-10-05 | 2007-10-05 | |
226 | 226 | B1601_HRB105499 | 2019-01-29 | 2019-01-29 | ||
227 | 227 | B1601_HRB105500 | 2008-02-04 | 2008-02-04 | 2008-02-04 | |
228 | 228 | B1601_HRB105512 | 2007-09-07 | 2007-11-22 | 2007-11-22 | |
229 | 229 | B1601_HRB105551 | 2007-11-29 | 2007-11-29 | 2007-11-29 | |
230 | 230 | B1601_HRB105554 | 2013-05-10 | 2013-05-10 | 2013-05-10 | |
231 | 231 | B1601_HRB105594 | 2011-01-03 | 2017-01-17 | 2017-01-17 | |
232 | 232 | B1601_HRB105628 | 2010-07-23 | 2022-04-05 | ||
233 | 233 | B1601_HRB105632 | 2012-07-03 | 2015-11-30 | 2015-11-30 | |
234 | 234 | B1601_HRB105641 | 2022-01-25 | 2022-01-25 | ||
235 | 235 | B1601_HRB105650 | 2010-12-08 | 2017-01-11 | 2017-01-11 | |
236 | 236 | B1601_HRB105651 | 2020-01-31 | 2022-01-04 | ||
237 | 237 | B1601_HRB105660 | 2007-11-13 | 2019-10-10 | ||
239 | 239 | B1601_HRB105670 | 2010-08-09 | 2010-08-09 | ||
240 | 240 | B1601_HRB105672 | 2014-04-30 | 2020-12-15 | ||
241 | 241 | B1601_HRB105688 | 2012-07-04 | 2020-03-20 | ||
242 | 242 | B1601_HRB105689 | 2010-09-15 | 2017-12-08 | ||
243 | 243 | B1601_HRB105708 | 2013-01-25 | 2015-10-06 | 2015-10-06 | |
245 | 245 | B1601_HRB105736 | 2007-08-22 | 2007-08-22 | ||
246 | 246 | B1601_HRB105737 | 2007-11-23 | 2021-04-12 | 2021-04-12 | |
247 | 247 | B1601_HRB105758 | 2012-06-27 | 2012-06-27 | ||
248 | 248 | B1601_HRB105785 | 2009-06-25 | 2009-06-25 | 2009-06-25 | |
249 | 249 | B1601_HRB105789 | 2007-02-07 | 2017-07-20 | ||
250 | 250 | B1601_HRB105805 | 2007-12-17 | 2015-02-02 | ||
251 | 251 | B1601_HRB105827 | 2007-09-05 | 2018-09-05 | ||
252 | 252 | B1601_HRB105867 | 2013-04-19 | 2019-03-06 | ||
253 | 253 | B1601_HRB105876 | 2014-02-17 | 2014-02-17 | ||
254 | 254 | B1601_HRB105878 | 2011-04-26 | 2022-06-03 | ||
255 | 255 | B1601_HRB105902 | 2009-02-11 | 2009-03-25 | 2009-03-25 | |
256 | 256 | B1601_HRB105967 | 2012-06-29 | 2017-09-13 | 2017-09-13 | |
257 | 257 | B1601_HRB105969 | 2008-01-14 | 2008-02-29 | 2008-02-29 | |
258 | 258 | B1601_HRB105970 | 2007-06-08 | 2007-06-08 | 2007-06-08 | |
259 | 259 | B1601_HRB105991 | 2009-11-16 | 2009-11-16 | 2009-11-16 | |
260 | 260 | B1601_HRB106010 | 2009-11-19 | 2014-07-15 | 2014-07-15 | |
261 | 261 | B1601_HRB106023 | 2007-04-11 | 2021-01-15 | ||
262 | 262 | B1601_HRB106026 | 2016-04-14 | 2022-06-25 | ||
263 | 263 | B1601_HRB106038 | 2017-01-10 | 2019-07-30 | 2019-07-30 | |
264 | 264 | B1601_HRB106047 | 2009-08-18 | 2009-08-18 | ||
265 | 265 | B1601_HRB106060 | 2007-07-25 | 2017-11-24 | ||
266 | 266 | B1601_HRB106069 | 2007-06-27 | 2019-07-25 | ||
267 | 267 | B1601_HRB106103 | 2007-01-12 | 2007-04-10 | 2007-04-10 | |
268 | 268 | B1601_HRB106105 | 2007-05-02 | 2007-09-17 | 2007-09-17 | |
269 | 269 | B1601_HRB106107 | 2007-11-12 | 2007-11-12 | 2007-11-12 | |
270 | 270 | B1601_HRB106125 | 2008-07-07 | 2011-07-20 | ||
271 | 271 | B1601_HRB106139 | 2012-07-19 | 2012-10-08 | ||
272 | 272 | B1601_HRB106140 | 2007-04-16 | 2015-12-14 | ||
273 | 273 | B1601_HRB106198 | 2019-12-12 | 2019-12-12 | ||
274 | 274 | B1601_HRB106206 | 2013-01-03 | 2013-01-03 | ||
275 | 275 | B1601_HRB106229 | 2021-10-01 | 2021-10-01 | 2021-10-01 | |
276 | 276 | B1601_HRB106244 | 2011-05-24 | 2011-08-05 | 2011-08-05 | |
277 | 277 | B1601_HRB106262 | 2012-09-19 | 2012-09-19 | ||
278 | 278 | B1601_HRB106265 | 2007-06-21 | 2015-08-31 | 2015-08-31 | |
279 | 279 | B1601_HRB106278 | 2007-07-09 | 2016-12-19 | 2016-12-19 | |
280 | 280 | B1601_HRB106357 | 2021-09-02 | 2021-09-02 | ||
281 | 281 | B1601_HRB106389 | 2016-07-05 | 2018-07-02 | ||
282 | 282 | B1601_HRB106396 | 2007-08-06 | 2009-04-06 | ||
283 | 283 | B1601_HRB106430 | 2011-12-12 | 2014-01-14 | 2014-01-14 | |
284 | 284 | B1601_HRB106453 | 2018-10-12 | 2022-07-12 | ||
285 | 285 | B1601_HRB106458 | 2011-12-28 | 2012-07-09 | 2012-07-09 | |
286 | 286 | B1601_HRB106487 | 2008-05-20 | 2011-08-08 | 2011-08-08 | |
287 | 287 | B1601_HRB106528 | 2010-03-01 | 2021-10-20 | 2021-10-20 | |
288 | 288 | B1601_HRB106536 | 2007-07-31 | 2012-01-30 | ||
289 | 289 | B1601_HRB106555 | 2015-08-17 | 2016-10-13 | 2016-10-13 | |
290 | 290 | B1601_HRB106570 | 2008-10-08 | 2016-03-09 | 2016-03-09 | |
291 | 291 | B1601_HRB106579 | 2012-08-02 | 2020-02-10 | ||
292 | 292 | B1601_HRB106580 | 2014-10-21 | 2021-05-17 | 2021-05-17 | |
293 | 293 | B1601_HRB106601 | 2009-10-19 | 2021-10-07 | ||
294 | 294 | B1601_HRB106607 | 2012-01-20 | 2012-01-20 | 2012-01-20 | |
295 | 295 | B1601_HRB106640 | 2009-06-16 | 2019-10-21 | ||
296 | 296 | B1601_HRB106649 | 2016-04-12 | 2016-04-12 | ||
297 | 297 | B1601_HRB106669 | 2018-07-04 | 2018-07-04 | ||
298 | 298 | B1601_HRB106677 | 2013-01-31 | 2021-10-25 | ||
299 | 299 | B1601_HRB106682 | 2007-03-13 | 2021-08-19 | ||
300 | 300 | B1601_HRB106693 | 2019-04-17 | 2019-07-01 | 2019-07-01 | |
301 | 301 | B1601_HRB106702 | 2015-10-23 | 2015-10-23 | 2015-10-23 | |
302 | 302 | B1601_HRB106708 | 2020-01-21 | 2021-01-12 | ||
303 | 303 | B1601_HRB106760 | 2020-12-02 | 2020-12-02 | 2020-12-02 | |
304 | 304 | B1601_HRB106773 | 2010-07-26 | 2019-08-30 | ||
305 | 305 | B1601_HRB106789 | 2008-12-11 | 2018-01-08 | 2018-01-08 | |
306 | 306 | B1601_HRB106794 | 2018-11-26 | 2018-11-26 | 2018-11-26 | |
307 | 307 | B1601_HRB106807 | 2006-12-28 | 2012-01-27 | ||
308 | 308 | B1601_HRB106848 | 2014-03-06 | 2014-03-06 | ||
309 | 309 | B1601_HRB106864 | 2016-08-09 | 2016-10-26 | 2016-10-26 | |
310 | 310 | B1601_HRB106867 | 2018-03-20 | 2020-10-13 | 2020-10-13 | |
311 | 311 | B1601_HRB106874 | 2008-06-26 | 2008-06-26 | ||
312 | 312 | B1601_HRB106879 | 2016-03-30 | 2018-12-14 | 2018-12-14 | |
313 | 313 | B1601_HRB106901 | 2021-10-15 | 2021-10-15 | ||
314 | 314 | B1601_HRB106903 | 2008-10-23 | 2008-12-02 | ||
315 | 315 | B1601_HRB106908 | 2008-01-15 | 2016-12-27 | 2016-12-27 | |
316 | 316 | B1601_HRB106930 | 2011-12-21 | 2013-03-25 | 2013-03-25 | |
317 | 317 | B1601_HRB106937 | 2007-01-03 | 2012-07-09 | 2012-07-09 |
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" );