ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Park" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635176 | 635176 | 2020-10-16 | Park | Colorado | 8093 | 69 | 1 |
631930 | 631930 | 2020-10-15 | Park | Colorado | 8093 | 65 | 1 |
628686 | 628686 | 2020-10-14 | Park | Colorado | 8093 | 65 | 1 |
625443 | 625443 | 2020-10-13 | Park | Colorado | 8093 | 64 | 1 |
622200 | 622200 | 2020-10-12 | Park | Colorado | 8093 | 64 | 1 |
618957 | 618957 | 2020-10-11 | Park | Colorado | 8093 | 64 | 1 |
615715 | 615715 | 2020-10-10 | Park | Colorado | 8093 | 64 | 1 |
612474 | 612474 | 2020-10-09 | Park | Colorado | 8093 | 61 | 1 |
609232 | 609232 | 2020-10-08 | Park | Colorado | 8093 | 59 | 1 |
605989 | 605989 | 2020-10-07 | Park | Colorado | 8093 | 59 | 1 |
602747 | 602747 | 2020-10-06 | Park | Colorado | 8093 | 59 | 1 |
599504 | 599504 | 2020-10-05 | Park | Colorado | 8093 | 59 | 1 |
596261 | 596261 | 2020-10-04 | Park | Colorado | 8093 | 59 | 1 |
593019 | 593019 | 2020-10-03 | Park | Colorado | 8093 | 59 | 1 |
589779 | 589779 | 2020-10-02 | Park | Colorado | 8093 | 59 | 1 |
586538 | 586538 | 2020-10-01 | Park | Colorado | 8093 | 58 | 1 |
583298 | 583298 | 2020-09-30 | Park | Colorado | 8093 | 58 | 1 |
580059 | 580059 | 2020-09-29 | Park | Colorado | 8093 | 58 | 1 |
576818 | 576818 | 2020-09-28 | Park | Colorado | 8093 | 57 | 1 |
573575 | 573575 | 2020-09-27 | Park | Colorado | 8093 | 57 | 1 |
570333 | 570333 | 2020-09-26 | Park | Colorado | 8093 | 56 | 1 |
567091 | 567091 | 2020-09-25 | Park | Colorado | 8093 | 56 | 1 |
563851 | 563851 | 2020-09-24 | Park | Colorado | 8093 | 55 | 1 |
560611 | 560611 | 2020-09-23 | Park | Colorado | 8093 | 55 | 1 |
557375 | 557375 | 2020-09-22 | Park | Colorado | 8093 | 54 | 1 |
554138 | 554138 | 2020-09-21 | Park | Colorado | 8093 | 51 | 1 |
550899 | 550899 | 2020-09-20 | Park | Colorado | 8093 | 51 | 1 |
547660 | 547660 | 2020-09-19 | Park | Colorado | 8093 | 50 | 1 |
544422 | 544422 | 2020-09-18 | Park | Colorado | 8093 | 49 | 1 |
541186 | 541186 | 2020-09-17 | Park | Colorado | 8093 | 48 | 1 |
537949 | 537949 | 2020-09-16 | Park | Colorado | 8093 | 46 | 1 |
534713 | 534713 | 2020-09-15 | Park | Colorado | 8093 | 46 | 1 |
531478 | 531478 | 2020-09-14 | Park | Colorado | 8093 | 46 | 1 |
528241 | 528241 | 2020-09-13 | Park | Colorado | 8093 | 46 | 1 |
525005 | 525005 | 2020-09-12 | Park | Colorado | 8093 | 46 | 1 |
521769 | 521769 | 2020-09-11 | Park | Colorado | 8093 | 46 | 1 |
518532 | 518532 | 2020-09-10 | Park | Colorado | 8093 | 46 | 1 |
515297 | 515297 | 2020-09-09 | Park | Colorado | 8093 | 46 | 1 |
512064 | 512064 | 2020-09-08 | Park | Colorado | 8093 | 46 | 1 |
508831 | 508831 | 2020-09-07 | Park | Colorado | 8093 | 45 | 1 |
505599 | 505599 | 2020-09-06 | Park | Colorado | 8093 | 46 | 1 |
502365 | 502365 | 2020-09-05 | Park | Colorado | 8093 | 46 | 1 |
499131 | 499131 | 2020-09-04 | Park | Colorado | 8093 | 45 | 1 |
495898 | 495898 | 2020-09-03 | Park | Colorado | 8093 | 43 | 1 |
492664 | 492664 | 2020-09-02 | Park | Colorado | 8093 | 43 | 1 |
489431 | 489431 | 2020-09-01 | Park | Colorado | 8093 | 43 | 1 |
486198 | 486198 | 2020-08-31 | Park | Colorado | 8093 | 43 | 1 |
482963 | 482963 | 2020-08-30 | Park | Colorado | 8093 | 43 | 1 |
479729 | 479729 | 2020-08-29 | Park | Colorado | 8093 | 43 | 1 |
476496 | 476496 | 2020-08-28 | Park | Colorado | 8093 | 43 | 1 |
473263 | 473263 | 2020-08-27 | Park | Colorado | 8093 | 43 | 1 |
470031 | 470031 | 2020-08-26 | Park | Colorado | 8093 | 43 | 1 |
466802 | 466802 | 2020-08-25 | Park | Colorado | 8093 | 43 | 1 |
463573 | 463573 | 2020-08-24 | Park | Colorado | 8093 | 43 | 1 |
460344 | 460344 | 2020-08-23 | Park | Colorado | 8093 | 43 | 1 |
457117 | 457117 | 2020-08-22 | Park | Colorado | 8093 | 43 | 1 |
453889 | 453889 | 2020-08-21 | Park | Colorado | 8093 | 43 | 1 |
450661 | 450661 | 2020-08-20 | Park | Colorado | 8093 | 42 | 1 |
447433 | 447433 | 2020-08-19 | Park | Colorado | 8093 | 42 | 1 |
444206 | 444206 | 2020-08-18 | Park | Colorado | 8093 | 42 | 1 |
440980 | 440980 | 2020-08-17 | Park | Colorado | 8093 | 42 | 1 |
437754 | 437754 | 2020-08-16 | Park | Colorado | 8093 | 42 | 1 |
434528 | 434528 | 2020-08-15 | Park | Colorado | 8093 | 42 | 1 |
431303 | 431303 | 2020-08-14 | Park | Colorado | 8093 | 42 | 1 |
428075 | 428075 | 2020-08-13 | Park | Colorado | 8093 | 42 | 1 |
424851 | 424851 | 2020-08-12 | Park | Colorado | 8093 | 42 | 1 |
421630 | 421630 | 2020-08-11 | Park | Colorado | 8093 | 42 | 1 |
418409 | 418409 | 2020-08-10 | Park | Colorado | 8093 | 42 | 1 |
415188 | 415188 | 2020-08-09 | Park | Colorado | 8093 | 42 | 1 |
411968 | 411968 | 2020-08-08 | Park | Colorado | 8093 | 42 | 1 |
408749 | 408749 | 2020-08-07 | Park | Colorado | 8093 | 42 | 1 |
405529 | 405529 | 2020-08-06 | Park | Colorado | 8093 | 42 | 1 |
402311 | 402311 | 2020-08-05 | Park | Colorado | 8093 | 42 | 1 |
399095 | 399095 | 2020-08-04 | Park | Colorado | 8093 | 42 | 1 |
395879 | 395879 | 2020-08-03 | Park | Colorado | 8093 | 42 | 1 |
392663 | 392663 | 2020-08-02 | Park | Colorado | 8093 | 41 | 1 |
389446 | 389446 | 2020-08-01 | Park | Colorado | 8093 | 41 | 1 |
386229 | 386229 | 2020-07-31 | Park | Colorado | 8093 | 42 | 1 |
383011 | 383011 | 2020-07-30 | Park | Colorado | 8093 | 41 | 1 |
379794 | 379794 | 2020-07-29 | Park | Colorado | 8093 | 41 | 1 |
376577 | 376577 | 2020-07-28 | Park | Colorado | 8093 | 40 | 1 |
373363 | 373363 | 2020-07-27 | Park | Colorado | 8093 | 40 | 1 |
370151 | 370151 | 2020-07-26 | Park | Colorado | 8093 | 40 | 1 |
366941 | 366941 | 2020-07-25 | Park | Colorado | 8093 | 39 | 1 |
363734 | 363734 | 2020-07-24 | Park | Colorado | 8093 | 37 | 1 |
360527 | 360527 | 2020-07-23 | Park | Colorado | 8093 | 36 | 1 |
357322 | 357322 | 2020-07-22 | Park | Colorado | 8093 | 35 | 1 |
354119 | 354119 | 2020-07-21 | Park | Colorado | 8093 | 35 | 1 |
350917 | 350917 | 2020-07-20 | Park | Colorado | 8093 | 35 | 1 |
347716 | 347716 | 2020-07-19 | Park | Colorado | 8093 | 35 | 1 |
344516 | 344516 | 2020-07-18 | Park | Colorado | 8093 | 33 | 1 |
341317 | 341317 | 2020-07-17 | Park | Colorado | 8093 | 33 | 1 |
338120 | 338120 | 2020-07-16 | Park | Colorado | 8093 | 33 | 0 |
334925 | 334925 | 2020-07-15 | Park | Colorado | 8093 | 33 | 0 |
331732 | 331732 | 2020-07-14 | Park | Colorado | 8093 | 33 | 0 |
328546 | 328546 | 2020-07-13 | Park | Colorado | 8093 | 32 | 0 |
325360 | 325360 | 2020-07-12 | Park | Colorado | 8093 | 33 | 0 |
322179 | 322179 | 2020-07-11 | Park | Colorado | 8093 | 33 | 0 |
319000 | 319000 | 2020-07-10 | Park | Colorado | 8093 | 33 | 0 |
315827 | 315827 | 2020-07-09 | Park | Colorado | 8093 | 32 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);