ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 8125 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635192 | 635192 | 2020-10-16 | Yuma | Colorado | 8125 | 176 | 1 |
631946 | 631946 | 2020-10-15 | Yuma | Colorado | 8125 | 173 | 1 |
628702 | 628702 | 2020-10-14 | Yuma | Colorado | 8125 | 158 | 1 |
625459 | 625459 | 2020-10-13 | Yuma | Colorado | 8125 | 157 | 1 |
622216 | 622216 | 2020-10-12 | Yuma | Colorado | 8125 | 153 | 1 |
618973 | 618973 | 2020-10-11 | Yuma | Colorado | 8125 | 152 | 1 |
615731 | 615731 | 2020-10-10 | Yuma | Colorado | 8125 | 151 | 1 |
612490 | 612490 | 2020-10-09 | Yuma | Colorado | 8125 | 150 | 1 |
609248 | 609248 | 2020-10-08 | Yuma | Colorado | 8125 | 146 | 1 |
606005 | 606005 | 2020-10-07 | Yuma | Colorado | 8125 | 147 | 1 |
602763 | 602763 | 2020-10-06 | Yuma | Colorado | 8125 | 143 | 1 |
599520 | 599520 | 2020-10-05 | Yuma | Colorado | 8125 | 139 | 1 |
596277 | 596277 | 2020-10-04 | Yuma | Colorado | 8125 | 132 | 1 |
593035 | 593035 | 2020-10-03 | Yuma | Colorado | 8125 | 130 | 1 |
589795 | 589795 | 2020-10-02 | Yuma | Colorado | 8125 | 129 | 1 |
586554 | 586554 | 2020-10-01 | Yuma | Colorado | 8125 | 126 | 1 |
583314 | 583314 | 2020-09-30 | Yuma | Colorado | 8125 | 125 | 1 |
580075 | 580075 | 2020-09-29 | Yuma | Colorado | 8125 | 124 | 1 |
576834 | 576834 | 2020-09-28 | Yuma | Colorado | 8125 | 122 | 1 |
573591 | 573591 | 2020-09-27 | Yuma | Colorado | 8125 | 114 | 1 |
570349 | 570349 | 2020-09-26 | Yuma | Colorado | 8125 | 113 | 1 |
567107 | 567107 | 2020-09-25 | Yuma | Colorado | 8125 | 104 | 1 |
563867 | 563867 | 2020-09-24 | Yuma | Colorado | 8125 | 103 | 1 |
560627 | 560627 | 2020-09-23 | Yuma | Colorado | 8125 | 101 | 1 |
557391 | 557391 | 2020-09-22 | Yuma | Colorado | 8125 | 91 | 0 |
554154 | 554154 | 2020-09-21 | Yuma | Colorado | 8125 | 88 | 0 |
550915 | 550915 | 2020-09-20 | Yuma | Colorado | 8125 | 87 | 0 |
547676 | 547676 | 2020-09-19 | Yuma | Colorado | 8125 | 84 | 0 |
544438 | 544438 | 2020-09-18 | Yuma | Colorado | 8125 | 84 | 0 |
541202 | 541202 | 2020-09-17 | Yuma | Colorado | 8125 | 84 | 0 |
537965 | 537965 | 2020-09-16 | Yuma | Colorado | 8125 | 76 | 0 |
534729 | 534729 | 2020-09-15 | Yuma | Colorado | 8125 | 75 | 0 |
531494 | 531494 | 2020-09-14 | Yuma | Colorado | 8125 | 72 | 0 |
528257 | 528257 | 2020-09-13 | Yuma | Colorado | 8125 | 72 | 0 |
525021 | 525021 | 2020-09-12 | Yuma | Colorado | 8125 | 70 | 0 |
521785 | 521785 | 2020-09-11 | Yuma | Colorado | 8125 | 70 | 0 |
518548 | 518548 | 2020-09-10 | Yuma | Colorado | 8125 | 71 | 0 |
515313 | 515313 | 2020-09-09 | Yuma | Colorado | 8125 | 71 | 0 |
512080 | 512080 | 2020-09-08 | Yuma | Colorado | 8125 | 68 | 0 |
508847 | 508847 | 2020-09-07 | Yuma | Colorado | 8125 | 68 | 0 |
505615 | 505615 | 2020-09-06 | Yuma | Colorado | 8125 | 67 | 0 |
502381 | 502381 | 2020-09-05 | Yuma | Colorado | 8125 | 67 | 0 |
499147 | 499147 | 2020-09-04 | Yuma | Colorado | 8125 | 65 | 0 |
495914 | 495914 | 2020-09-03 | Yuma | Colorado | 8125 | 65 | 0 |
492680 | 492680 | 2020-09-02 | Yuma | Colorado | 8125 | 64 | 0 |
489447 | 489447 | 2020-09-01 | Yuma | Colorado | 8125 | 63 | 0 |
486214 | 486214 | 2020-08-31 | Yuma | Colorado | 8125 | 63 | 0 |
482979 | 482979 | 2020-08-30 | Yuma | Colorado | 8125 | 63 | 0 |
479745 | 479745 | 2020-08-29 | Yuma | Colorado | 8125 | 63 | 0 |
476512 | 476512 | 2020-08-28 | Yuma | Colorado | 8125 | 63 | 0 |
473279 | 473279 | 2020-08-27 | Yuma | Colorado | 8125 | 63 | 0 |
470047 | 470047 | 2020-08-26 | Yuma | Colorado | 8125 | 63 | 0 |
466818 | 466818 | 2020-08-25 | Yuma | Colorado | 8125 | 63 | 0 |
463589 | 463589 | 2020-08-24 | Yuma | Colorado | 8125 | 63 | 0 |
460360 | 460360 | 2020-08-23 | Yuma | Colorado | 8125 | 63 | 0 |
457133 | 457133 | 2020-08-22 | Yuma | Colorado | 8125 | 63 | 0 |
453905 | 453905 | 2020-08-21 | Yuma | Colorado | 8125 | 63 | 0 |
450677 | 450677 | 2020-08-20 | Yuma | Colorado | 8125 | 63 | 0 |
447449 | 447449 | 2020-08-19 | Yuma | Colorado | 8125 | 63 | 0 |
444222 | 444222 | 2020-08-18 | Yuma | Colorado | 8125 | 63 | 0 |
440996 | 440996 | 2020-08-17 | Yuma | Colorado | 8125 | 63 | 0 |
437770 | 437770 | 2020-08-16 | Yuma | Colorado | 8125 | 63 | 0 |
434544 | 434544 | 2020-08-15 | Yuma | Colorado | 8125 | 63 | 0 |
431319 | 431319 | 2020-08-14 | Yuma | Colorado | 8125 | 63 | 0 |
428091 | 428091 | 2020-08-13 | Yuma | Colorado | 8125 | 63 | 0 |
424867 | 424867 | 2020-08-12 | Yuma | Colorado | 8125 | 63 | 0 |
421646 | 421646 | 2020-08-11 | Yuma | Colorado | 8125 | 63 | 0 |
418425 | 418425 | 2020-08-10 | Yuma | Colorado | 8125 | 63 | 0 |
415204 | 415204 | 2020-08-09 | Yuma | Colorado | 8125 | 63 | 0 |
411984 | 411984 | 2020-08-08 | Yuma | Colorado | 8125 | 63 | 0 |
408765 | 408765 | 2020-08-07 | Yuma | Colorado | 8125 | 63 | 0 |
405545 | 405545 | 2020-08-06 | Yuma | Colorado | 8125 | 63 | 0 |
402327 | 402327 | 2020-08-05 | Yuma | Colorado | 8125 | 63 | 0 |
399111 | 399111 | 2020-08-04 | Yuma | Colorado | 8125 | 62 | 0 |
395895 | 395895 | 2020-08-03 | Yuma | Colorado | 8125 | 62 | 0 |
392679 | 392679 | 2020-08-02 | Yuma | Colorado | 8125 | 62 | 0 |
389462 | 389462 | 2020-08-01 | Yuma | Colorado | 8125 | 62 | 0 |
386245 | 386245 | 2020-07-31 | Yuma | Colorado | 8125 | 62 | 0 |
383027 | 383027 | 2020-07-30 | Yuma | Colorado | 8125 | 57 | 0 |
379810 | 379810 | 2020-07-29 | Yuma | Colorado | 8125 | 57 | 0 |
376593 | 376593 | 2020-07-28 | Yuma | Colorado | 8125 | 57 | 0 |
373379 | 373379 | 2020-07-27 | Yuma | Colorado | 8125 | 57 | 0 |
370167 | 370167 | 2020-07-26 | Yuma | Colorado | 8125 | 57 | 0 |
366957 | 366957 | 2020-07-25 | Yuma | Colorado | 8125 | 57 | 0 |
363750 | 363750 | 2020-07-24 | Yuma | Colorado | 8125 | 56 | 0 |
360543 | 360543 | 2020-07-23 | Yuma | Colorado | 8125 | 56 | 0 |
357338 | 357338 | 2020-07-22 | Yuma | Colorado | 8125 | 56 | 0 |
354135 | 354135 | 2020-07-21 | Yuma | Colorado | 8125 | 56 | 0 |
350933 | 350933 | 2020-07-20 | Yuma | Colorado | 8125 | 56 | 0 |
347732 | 347732 | 2020-07-19 | Yuma | Colorado | 8125 | 56 | 0 |
344532 | 344532 | 2020-07-18 | Yuma | Colorado | 8125 | 55 | 0 |
341333 | 341333 | 2020-07-17 | Yuma | Colorado | 8125 | 55 | 0 |
338136 | 338136 | 2020-07-16 | Yuma | Colorado | 8125 | 55 | 0 |
334941 | 334941 | 2020-07-15 | Yuma | Colorado | 8125 | 55 | 0 |
331748 | 331748 | 2020-07-14 | Yuma | Colorado | 8125 | 54 | 0 |
328561 | 328561 | 2020-07-13 | Yuma | Colorado | 8125 | 54 | 0 |
325375 | 325375 | 2020-07-12 | Yuma | Colorado | 8125 | 54 | 0 |
322194 | 322194 | 2020-07-11 | Yuma | Colorado | 8125 | 54 | 0 |
319015 | 319015 | 2020-07-10 | Yuma | Colorado | 8125 | 54 | 0 |
315842 | 315842 | 2020-07-09 | Yuma | Colorado | 8125 | 54 | 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);