ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 8045 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635152 | 635152 | 2020-10-16 | Garfield | Colorado | 8045 | 1053 | 5 |
631906 | 631906 | 2020-10-15 | Garfield | Colorado | 8045 | 1047 | 5 |
628662 | 628662 | 2020-10-14 | Garfield | Colorado | 8045 | 1028 | 5 |
625419 | 625419 | 2020-10-13 | Garfield | Colorado | 8045 | 1022 | 5 |
622176 | 622176 | 2020-10-12 | Garfield | Colorado | 8045 | 1016 | 5 |
618933 | 618933 | 2020-10-11 | Garfield | Colorado | 8045 | 1013 | 5 |
615691 | 615691 | 2020-10-10 | Garfield | Colorado | 8045 | 1006 | 5 |
612450 | 612450 | 2020-10-09 | Garfield | Colorado | 8045 | 993 | 5 |
609208 | 609208 | 2020-10-08 | Garfield | Colorado | 8045 | 990 | 5 |
605965 | 605965 | 2020-10-07 | Garfield | Colorado | 8045 | 985 | 5 |
602723 | 602723 | 2020-10-06 | Garfield | Colorado | 8045 | 982 | 5 |
599480 | 599480 | 2020-10-05 | Garfield | Colorado | 8045 | 972 | 5 |
596237 | 596237 | 2020-10-04 | Garfield | Colorado | 8045 | 965 | 5 |
592995 | 592995 | 2020-10-03 | Garfield | Colorado | 8045 | 965 | 5 |
589755 | 589755 | 2020-10-02 | Garfield | Colorado | 8045 | 963 | 5 |
586514 | 586514 | 2020-10-01 | Garfield | Colorado | 8045 | 958 | 5 |
583274 | 583274 | 2020-09-30 | Garfield | Colorado | 8045 | 956 | 5 |
580035 | 580035 | 2020-09-29 | Garfield | Colorado | 8045 | 949 | 5 |
576794 | 576794 | 2020-09-28 | Garfield | Colorado | 8045 | 947 | 5 |
573551 | 573551 | 2020-09-27 | Garfield | Colorado | 8045 | 945 | 5 |
570309 | 570309 | 2020-09-26 | Garfield | Colorado | 8045 | 944 | 5 |
567067 | 567067 | 2020-09-25 | Garfield | Colorado | 8045 | 942 | 5 |
563827 | 563827 | 2020-09-24 | Garfield | Colorado | 8045 | 939 | 5 |
560588 | 560588 | 2020-09-23 | Garfield | Colorado | 8045 | 936 | 5 |
557352 | 557352 | 2020-09-22 | Garfield | Colorado | 8045 | 937 | 5 |
554115 | 554115 | 2020-09-21 | Garfield | Colorado | 8045 | 936 | 5 |
550876 | 550876 | 2020-09-20 | Garfield | Colorado | 8045 | 929 | 5 |
547637 | 547637 | 2020-09-19 | Garfield | Colorado | 8045 | 925 | 5 |
544399 | 544399 | 2020-09-18 | Garfield | Colorado | 8045 | 916 | 5 |
541163 | 541163 | 2020-09-17 | Garfield | Colorado | 8045 | 912 | 5 |
537926 | 537926 | 2020-09-16 | Garfield | Colorado | 8045 | 906 | 5 |
534690 | 534690 | 2020-09-15 | Garfield | Colorado | 8045 | 900 | 5 |
531455 | 531455 | 2020-09-14 | Garfield | Colorado | 8045 | 892 | 5 |
528218 | 528218 | 2020-09-13 | Garfield | Colorado | 8045 | 891 | 5 |
524982 | 524982 | 2020-09-12 | Garfield | Colorado | 8045 | 891 | 5 |
521746 | 521746 | 2020-09-11 | Garfield | Colorado | 8045 | 884 | 5 |
518509 | 518509 | 2020-09-10 | Garfield | Colorado | 8045 | 879 | 4 |
515274 | 515274 | 2020-09-09 | Garfield | Colorado | 8045 | 875 | 5 |
512041 | 512041 | 2020-09-08 | Garfield | Colorado | 8045 | 874 | 4 |
508808 | 508808 | 2020-09-07 | Garfield | Colorado | 8045 | 869 | 4 |
505576 | 505576 | 2020-09-06 | Garfield | Colorado | 8045 | 868 | 4 |
502342 | 502342 | 2020-09-05 | Garfield | Colorado | 8045 | 859 | 4 |
499108 | 499108 | 2020-09-04 | Garfield | Colorado | 8045 | 857 | 4 |
495875 | 495875 | 2020-09-03 | Garfield | Colorado | 8045 | 847 | 4 |
492641 | 492641 | 2020-09-02 | Garfield | Colorado | 8045 | 846 | 4 |
489408 | 489408 | 2020-09-01 | Garfield | Colorado | 8045 | 845 | 4 |
486175 | 486175 | 2020-08-31 | Garfield | Colorado | 8045 | 844 | 4 |
482940 | 482940 | 2020-08-30 | Garfield | Colorado | 8045 | 839 | 4 |
479706 | 479706 | 2020-08-29 | Garfield | Colorado | 8045 | 838 | 4 |
476473 | 476473 | 2020-08-28 | Garfield | Colorado | 8045 | 839 | 4 |
473240 | 473240 | 2020-08-27 | Garfield | Colorado | 8045 | 830 | 4 |
470008 | 470008 | 2020-08-26 | Garfield | Colorado | 8045 | 825 | 4 |
466779 | 466779 | 2020-08-25 | Garfield | Colorado | 8045 | 821 | 4 |
463550 | 463550 | 2020-08-24 | Garfield | Colorado | 8045 | 818 | 4 |
460321 | 460321 | 2020-08-23 | Garfield | Colorado | 8045 | 816 | 4 |
457094 | 457094 | 2020-08-22 | Garfield | Colorado | 8045 | 814 | 4 |
453866 | 453866 | 2020-08-21 | Garfield | Colorado | 8045 | 813 | 4 |
450638 | 450638 | 2020-08-20 | Garfield | Colorado | 8045 | 807 | 4 |
447410 | 447410 | 2020-08-19 | Garfield | Colorado | 8045 | 805 | 4 |
444183 | 444183 | 2020-08-18 | Garfield | Colorado | 8045 | 804 | 4 |
440957 | 440957 | 2020-08-17 | Garfield | Colorado | 8045 | 802 | 4 |
437731 | 437731 | 2020-08-16 | Garfield | Colorado | 8045 | 797 | 4 |
434505 | 434505 | 2020-08-15 | Garfield | Colorado | 8045 | 792 | 4 |
431280 | 431280 | 2020-08-14 | Garfield | Colorado | 8045 | 784 | 4 |
428052 | 428052 | 2020-08-13 | Garfield | Colorado | 8045 | 780 | 4 |
424828 | 424828 | 2020-08-12 | Garfield | Colorado | 8045 | 776 | 4 |
421607 | 421607 | 2020-08-11 | Garfield | Colorado | 8045 | 773 | 4 |
418386 | 418386 | 2020-08-10 | Garfield | Colorado | 8045 | 768 | 4 |
415165 | 415165 | 2020-08-09 | Garfield | Colorado | 8045 | 767 | 4 |
411945 | 411945 | 2020-08-08 | Garfield | Colorado | 8045 | 764 | 4 |
408726 | 408726 | 2020-08-07 | Garfield | Colorado | 8045 | 757 | 4 |
405506 | 405506 | 2020-08-06 | Garfield | Colorado | 8045 | 753 | 4 |
402288 | 402288 | 2020-08-05 | Garfield | Colorado | 8045 | 742 | 4 |
399072 | 399072 | 2020-08-04 | Garfield | Colorado | 8045 | 734 | 4 |
395856 | 395856 | 2020-08-03 | Garfield | Colorado | 8045 | 721 | 4 |
392640 | 392640 | 2020-08-02 | Garfield | Colorado | 8045 | 713 | 4 |
389423 | 389423 | 2020-08-01 | Garfield | Colorado | 8045 | 705 | 4 |
386206 | 386206 | 2020-07-31 | Garfield | Colorado | 8045 | 691 | 4 |
382988 | 382988 | 2020-07-30 | Garfield | Colorado | 8045 | 682 | 4 |
379771 | 379771 | 2020-07-29 | Garfield | Colorado | 8045 | 664 | 4 |
376554 | 376554 | 2020-07-28 | Garfield | Colorado | 8045 | 639 | 4 |
373340 | 373340 | 2020-07-27 | Garfield | Colorado | 8045 | 626 | 4 |
370128 | 370128 | 2020-07-26 | Garfield | Colorado | 8045 | 624 | 4 |
366918 | 366918 | 2020-07-25 | Garfield | Colorado | 8045 | 612 | 4 |
363711 | 363711 | 2020-07-24 | Garfield | Colorado | 8045 | 591 | 4 |
360504 | 360504 | 2020-07-23 | Garfield | Colorado | 8045 | 575 | 4 |
357299 | 357299 | 2020-07-22 | Garfield | Colorado | 8045 | 561 | 4 |
354096 | 354096 | 2020-07-21 | Garfield | Colorado | 8045 | 537 | 4 |
350894 | 350894 | 2020-07-20 | Garfield | Colorado | 8045 | 528 | 4 |
347693 | 347693 | 2020-07-19 | Garfield | Colorado | 8045 | 519 | 4 |
344493 | 344493 | 2020-07-18 | Garfield | Colorado | 8045 | 505 | 4 |
341294 | 341294 | 2020-07-17 | Garfield | Colorado | 8045 | 493 | 4 |
338097 | 338097 | 2020-07-16 | Garfield | Colorado | 8045 | 469 | 4 |
334902 | 334902 | 2020-07-15 | Garfield | Colorado | 8045 | 448 | 4 |
331709 | 331709 | 2020-07-14 | Garfield | Colorado | 8045 | 441 | 3 |
328523 | 328523 | 2020-07-13 | Garfield | Colorado | 8045 | 423 | 3 |
325337 | 325337 | 2020-07-12 | Garfield | Colorado | 8045 | 415 | 3 |
322156 | 322156 | 2020-07-11 | Garfield | Colorado | 8045 | 403 | 3 |
318977 | 318977 | 2020-07-10 | Garfield | Colorado | 8045 | 379 | 3 |
315804 | 315804 | 2020-07-09 | Garfield | Colorado | 8045 | 349 | 3 |
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);