ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where deaths = 8, fips = 8107 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
680606 | 680606 | 2020-10-30 | Routt | Colorado | 8107 | 221 | 8 |
677363 | 677363 | 2020-10-29 | Routt | Colorado | 8107 | 219 | 8 |
674120 | 674120 | 2020-10-28 | Routt | Colorado | 8107 | 215 | 8 |
670878 | 670878 | 2020-10-27 | Routt | Colorado | 8107 | 211 | 8 |
667635 | 667635 | 2020-10-26 | Routt | Colorado | 8107 | 204 | 8 |
664390 | 664390 | 2020-10-25 | Routt | Colorado | 8107 | 202 | 8 |
661146 | 661146 | 2020-10-24 | Routt | Colorado | 8107 | 202 | 8 |
657902 | 657902 | 2020-10-23 | Routt | Colorado | 8107 | 200 | 8 |
654657 | 654657 | 2020-10-22 | Routt | Colorado | 8107 | 197 | 8 |
651412 | 651412 | 2020-10-21 | Routt | Colorado | 8107 | 196 | 8 |
648168 | 648168 | 2020-10-20 | Routt | Colorado | 8107 | 193 | 8 |
644923 | 644923 | 2020-10-19 | Routt | Colorado | 8107 | 187 | 8 |
641675 | 641675 | 2020-10-18 | Routt | Colorado | 8107 | 187 | 8 |
638428 | 638428 | 2020-10-17 | Routt | Colorado | 8107 | 185 | 8 |
635183 | 635183 | 2020-10-16 | Routt | Colorado | 8107 | 180 | 8 |
631937 | 631937 | 2020-10-15 | Routt | Colorado | 8107 | 175 | 8 |
628693 | 628693 | 2020-10-14 | Routt | Colorado | 8107 | 172 | 8 |
625450 | 625450 | 2020-10-13 | Routt | Colorado | 8107 | 171 | 8 |
622207 | 622207 | 2020-10-12 | Routt | Colorado | 8107 | 171 | 8 |
618964 | 618964 | 2020-10-11 | Routt | Colorado | 8107 | 172 | 8 |
615722 | 615722 | 2020-10-10 | Routt | Colorado | 8107 | 171 | 8 |
612481 | 612481 | 2020-10-09 | Routt | Colorado | 8107 | 171 | 8 |
609239 | 609239 | 2020-10-08 | Routt | Colorado | 8107 | 167 | 8 |
605996 | 605996 | 2020-10-07 | Routt | Colorado | 8107 | 164 | 8 |
602754 | 602754 | 2020-10-06 | Routt | Colorado | 8107 | 164 | 8 |
599511 | 599511 | 2020-10-05 | Routt | Colorado | 8107 | 163 | 8 |
596268 | 596268 | 2020-10-04 | Routt | Colorado | 8107 | 161 | 8 |
593026 | 593026 | 2020-10-03 | Routt | Colorado | 8107 | 161 | 8 |
589786 | 589786 | 2020-10-02 | Routt | Colorado | 8107 | 161 | 8 |
586545 | 586545 | 2020-10-01 | Routt | Colorado | 8107 | 159 | 8 |
583305 | 583305 | 2020-09-30 | Routt | Colorado | 8107 | 159 | 8 |
580066 | 580066 | 2020-09-29 | Routt | Colorado | 8107 | 158 | 8 |
576825 | 576825 | 2020-09-28 | Routt | Colorado | 8107 | 158 | 8 |
573582 | 573582 | 2020-09-27 | Routt | Colorado | 8107 | 155 | 8 |
570340 | 570340 | 2020-09-26 | Routt | Colorado | 8107 | 153 | 8 |
567098 | 567098 | 2020-09-25 | Routt | Colorado | 8107 | 152 | 8 |
563858 | 563858 | 2020-09-24 | Routt | Colorado | 8107 | 151 | 8 |
560618 | 560618 | 2020-09-23 | Routt | Colorado | 8107 | 148 | 8 |
557382 | 557382 | 2020-09-22 | Routt | Colorado | 8107 | 148 | 8 |
554145 | 554145 | 2020-09-21 | Routt | Colorado | 8107 | 145 | 8 |
550906 | 550906 | 2020-09-20 | Routt | Colorado | 8107 | 144 | 8 |
547667 | 547667 | 2020-09-19 | Routt | Colorado | 8107 | 143 | 8 |
544429 | 544429 | 2020-09-18 | Routt | Colorado | 8107 | 141 | 8 |
541193 | 541193 | 2020-09-17 | Routt | Colorado | 8107 | 140 | 8 |
537956 | 537956 | 2020-09-16 | Routt | Colorado | 8107 | 139 | 8 |
534720 | 534720 | 2020-09-15 | Routt | Colorado | 8107 | 139 | 8 |
531485 | 531485 | 2020-09-14 | Routt | Colorado | 8107 | 138 | 8 |
528248 | 528248 | 2020-09-13 | Routt | Colorado | 8107 | 138 | 8 |
525012 | 525012 | 2020-09-12 | Routt | Colorado | 8107 | 138 | 8 |
521776 | 521776 | 2020-09-11 | Routt | Colorado | 8107 | 136 | 8 |
518539 | 518539 | 2020-09-10 | Routt | Colorado | 8107 | 135 | 8 |
515304 | 515304 | 2020-09-09 | Routt | Colorado | 8107 | 135 | 8 |
512071 | 512071 | 2020-09-08 | Routt | Colorado | 8107 | 134 | 8 |
508838 | 508838 | 2020-09-07 | Routt | Colorado | 8107 | 134 | 8 |
505606 | 505606 | 2020-09-06 | Routt | Colorado | 8107 | 134 | 8 |
502372 | 502372 | 2020-09-05 | Routt | Colorado | 8107 | 134 | 8 |
499138 | 499138 | 2020-09-04 | Routt | Colorado | 8107 | 135 | 8 |
495905 | 495905 | 2020-09-03 | Routt | Colorado | 8107 | 135 | 8 |
492671 | 492671 | 2020-09-02 | Routt | Colorado | 8107 | 134 | 8 |
489438 | 489438 | 2020-09-01 | Routt | Colorado | 8107 | 134 | 8 |
486205 | 486205 | 2020-08-31 | Routt | Colorado | 8107 | 134 | 8 |
482970 | 482970 | 2020-08-30 | Routt | Colorado | 8107 | 132 | 8 |
479736 | 479736 | 2020-08-29 | Routt | Colorado | 8107 | 132 | 8 |
476503 | 476503 | 2020-08-28 | Routt | Colorado | 8107 | 132 | 8 |
473270 | 473270 | 2020-08-27 | Routt | Colorado | 8107 | 132 | 8 |
470038 | 470038 | 2020-08-26 | Routt | Colorado | 8107 | 132 | 8 |
466809 | 466809 | 2020-08-25 | Routt | Colorado | 8107 | 131 | 8 |
463580 | 463580 | 2020-08-24 | Routt | Colorado | 8107 | 131 | 8 |
460351 | 460351 | 2020-08-23 | Routt | Colorado | 8107 | 131 | 8 |
457124 | 457124 | 2020-08-22 | Routt | Colorado | 8107 | 131 | 8 |
453896 | 453896 | 2020-08-21 | Routt | Colorado | 8107 | 131 | 8 |
450668 | 450668 | 2020-08-20 | Routt | Colorado | 8107 | 131 | 8 |
447440 | 447440 | 2020-08-19 | Routt | Colorado | 8107 | 129 | 8 |
444213 | 444213 | 2020-08-18 | Routt | Colorado | 8107 | 129 | 8 |
440987 | 440987 | 2020-08-17 | Routt | Colorado | 8107 | 128 | 8 |
437761 | 437761 | 2020-08-16 | Routt | Colorado | 8107 | 127 | 8 |
434535 | 434535 | 2020-08-15 | Routt | Colorado | 8107 | 127 | 8 |
431310 | 431310 | 2020-08-14 | Routt | Colorado | 8107 | 125 | 8 |
428082 | 428082 | 2020-08-13 | Routt | Colorado | 8107 | 124 | 8 |
424858 | 424858 | 2020-08-12 | Routt | Colorado | 8107 | 124 | 8 |
421637 | 421637 | 2020-08-11 | Routt | Colorado | 8107 | 125 | 8 |
418416 | 418416 | 2020-08-10 | Routt | Colorado | 8107 | 125 | 8 |
415195 | 415195 | 2020-08-09 | Routt | Colorado | 8107 | 125 | 8 |
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);