ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 8107 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
411975 | 411975 | 2020-08-08 | Routt | Colorado | 8107 | 122 | 7 |
408756 | 408756 | 2020-08-07 | Routt | Colorado | 8107 | 117 | 7 |
405536 | 405536 | 2020-08-06 | Routt | Colorado | 8107 | 111 | 6 |
402318 | 402318 | 2020-08-05 | Routt | Colorado | 8107 | 110 | 6 |
399102 | 399102 | 2020-08-04 | Routt | Colorado | 8107 | 110 | 6 |
395886 | 395886 | 2020-08-03 | Routt | Colorado | 8107 | 108 | 6 |
392670 | 392670 | 2020-08-02 | Routt | Colorado | 8107 | 107 | 6 |
389453 | 389453 | 2020-08-01 | Routt | Colorado | 8107 | 106 | 6 |
386236 | 386236 | 2020-07-31 | Routt | Colorado | 8107 | 99 | 6 |
383018 | 383018 | 2020-07-30 | Routt | Colorado | 8107 | 98 | 6 |
379801 | 379801 | 2020-07-29 | Routt | Colorado | 8107 | 96 | 6 |
376584 | 376584 | 2020-07-28 | Routt | Colorado | 8107 | 96 | 6 |
373370 | 373370 | 2020-07-27 | Routt | Colorado | 8107 | 95 | 6 |
370158 | 370158 | 2020-07-26 | Routt | Colorado | 8107 | 94 | 6 |
366948 | 366948 | 2020-07-25 | Routt | Colorado | 8107 | 94 | 6 |
363741 | 363741 | 2020-07-24 | Routt | Colorado | 8107 | 94 | 6 |
360534 | 360534 | 2020-07-23 | Routt | Colorado | 8107 | 94 | 6 |
357329 | 357329 | 2020-07-22 | Routt | Colorado | 8107 | 93 | 6 |
354126 | 354126 | 2020-07-21 | Routt | Colorado | 8107 | 91 | 6 |
350924 | 350924 | 2020-07-20 | Routt | Colorado | 8107 | 87 | 6 |
347723 | 347723 | 2020-07-19 | Routt | Colorado | 8107 | 87 | 6 |
344523 | 344523 | 2020-07-18 | Routt | Colorado | 8107 | 87 | 6 |
341324 | 341324 | 2020-07-17 | Routt | Colorado | 8107 | 85 | 6 |
338127 | 338127 | 2020-07-16 | Routt | Colorado | 8107 | 86 | 6 |
334932 | 334932 | 2020-07-15 | Routt | Colorado | 8107 | 86 | 6 |
331739 | 331739 | 2020-07-14 | Routt | Colorado | 8107 | 84 | 6 |
328553 | 328553 | 2020-07-13 | Routt | Colorado | 8107 | 84 | 6 |
325367 | 325367 | 2020-07-12 | Routt | Colorado | 8107 | 82 | 6 |
322186 | 322186 | 2020-07-11 | Routt | Colorado | 8107 | 81 | 6 |
319007 | 319007 | 2020-07-10 | Routt | Colorado | 8107 | 81 | 6 |
315834 | 315834 | 2020-07-09 | Routt | Colorado | 8107 | 79 | 6 |
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);