ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 8031 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053766 | 1053766 | 2021-02-22 | Denver | Colorado | 8031 | 58688 | 766 |
1050519 | 1050519 | 2021-02-21 | Denver | Colorado | 8031 | 58628 | 766 |
1047272 | 1047272 | 2021-02-20 | Denver | Colorado | 8031 | 58432 | 765 |
1044027 | 1044027 | 2021-02-19 | Denver | Colorado | 8031 | 58432 | 765 |
1040782 | 1040782 | 2021-02-18 | Denver | Colorado | 8031 | 58288 | 762 |
1037537 | 1037537 | 2021-02-17 | Denver | Colorado | 8031 | 58156 | 760 |
1034292 | 1034292 | 2021-02-16 | Denver | Colorado | 8031 | 58038 | 756 |
1031046 | 1031046 | 2021-02-15 | Denver | Colorado | 8031 | 57952 | 752 |
1027799 | 1027799 | 2021-02-14 | Denver | Colorado | 8031 | 57888 | 752 |
1024554 | 1024554 | 2021-02-13 | Denver | Colorado | 8031 | 57809 | 752 |
1021309 | 1021309 | 2021-02-12 | Denver | Colorado | 8031 | 57582 | 752 |
1018064 | 1018064 | 2021-02-11 | Denver | Colorado | 8031 | 57539 | 751 |
1014819 | 1014819 | 2021-02-10 | Denver | Colorado | 8031 | 57100 | 751 |
1011574 | 1011574 | 2021-02-09 | Denver | Colorado | 8031 | 57081 | 748 |
1008328 | 1008328 | 2021-02-08 | Denver | Colorado | 8031 | 56945 | 748 |
1005082 | 1005082 | 2021-02-07 | Denver | Colorado | 8031 | 56831 | 746 |
1001836 | 1001836 | 2021-02-06 | Denver | Colorado | 8031 | 56679 | 746 |
998590 | 998590 | 2021-02-05 | Denver | Colorado | 8031 | 56523 | 744 |
995344 | 995344 | 2021-02-04 | Denver | Colorado | 8031 | 56340 | 744 |
992098 | 992098 | 2021-02-03 | Denver | Colorado | 8031 | 56166 | 745 |
988852 | 988852 | 2021-02-02 | Denver | Colorado | 8031 | 55979 | 745 |
985605 | 985605 | 2021-02-01 | Denver | Colorado | 8031 | 55887 | 743 |
982358 | 982358 | 2021-01-31 | Denver | Colorado | 8031 | 55782 | 744 |
979112 | 979112 | 2021-01-30 | Denver | Colorado | 8031 | 55640 | 743 |
975867 | 975867 | 2021-01-29 | Denver | Colorado | 8031 | 55464 | 741 |
972622 | 972622 | 2021-01-28 | Denver | Colorado | 8031 | 55907 | 739 |
969377 | 969377 | 2021-01-27 | Denver | Colorado | 8031 | 55009 | 738 |
966133 | 966133 | 2021-01-26 | Denver | Colorado | 8031 | 54812 | 736 |
962888 | 962888 | 2021-01-25 | Denver | Colorado | 8031 | 54680 | 733 |
959643 | 959643 | 2021-01-24 | Denver | Colorado | 8031 | 54554 | 732 |
956397 | 956397 | 2021-01-23 | Denver | Colorado | 8031 | 54371 | 728 |
953152 | 953152 | 2021-01-22 | Denver | Colorado | 8031 | 54163 | 728 |
949907 | 949907 | 2021-01-21 | Denver | Colorado | 8031 | 54006 | 728 |
946661 | 946661 | 2021-01-20 | Denver | Colorado | 8031 | 53777 | 725 |
943414 | 943414 | 2021-01-19 | Denver | Colorado | 8031 | 53625 | 721 |
940169 | 940169 | 2021-01-18 | Denver | Colorado | 8031 | 53460 | 720 |
936924 | 936924 | 2021-01-17 | Denver | Colorado | 8031 | 53319 | 720 |
933679 | 933679 | 2021-01-16 | Denver | Colorado | 8031 | 53158 | 720 |
930434 | 930434 | 2021-01-15 | Denver | Colorado | 8031 | 52917 | 720 |
927189 | 927189 | 2021-01-14 | Denver | Colorado | 8031 | 52624 | 715 |
923943 | 923943 | 2021-01-13 | Denver | Colorado | 8031 | 52354 | 713 |
920698 | 920698 | 2021-01-12 | Denver | Colorado | 8031 | 51986 | 708 |
917453 | 917453 | 2021-01-11 | Denver | Colorado | 8031 | 51825 | 708 |
914208 | 914208 | 2021-01-10 | Denver | Colorado | 8031 | 51618 | 707 |
910963 | 910963 | 2021-01-09 | Denver | Colorado | 8031 | 51355 | 706 |
907718 | 907718 | 2021-01-08 | Denver | Colorado | 8031 | 51047 | 699 |
904472 | 904472 | 2021-01-07 | Denver | Colorado | 8031 | 50658 | 694 |
901227 | 901227 | 2021-01-06 | Denver | Colorado | 8031 | 49991 | 684 |
897982 | 897982 | 2021-01-05 | Denver | Colorado | 8031 | 49648 | 681 |
894737 | 894737 | 2021-01-04 | Denver | Colorado | 8031 | 48605 | 681 |
891490 | 891490 | 2021-01-03 | Denver | Colorado | 8031 | 48433 | 681 |
888243 | 888243 | 2021-01-02 | Denver | Colorado | 8031 | 48246 | 679 |
884998 | 884998 | 2021-01-01 | Denver | Colorado | 8031 | 48023 | 674 |
881753 | 881753 | 2020-12-31 | Denver | Colorado | 8031 | 47711 | 674 |
878508 | 878508 | 2020-12-30 | Denver | Colorado | 8031 | 47353 | 672 |
875263 | 875263 | 2020-12-29 | Denver | Colorado | 8031 | 46917 | 667 |
872018 | 872018 | 2020-12-28 | Denver | Colorado | 8031 | 46708 | 662 |
868773 | 868773 | 2020-12-27 | Denver | Colorado | 8031 | 46570 | 658 |
865528 | 865528 | 2020-12-26 | Denver | Colorado | 8031 | 46455 | 658 |
862283 | 862283 | 2020-12-25 | Denver | Colorado | 8031 | 46258 | 654 |
859038 | 859038 | 2020-12-24 | Denver | Colorado | 8031 | 45920 | 654 |
855793 | 855793 | 2020-12-23 | Denver | Colorado | 8031 | 45666 | 654 |
852548 | 852548 | 2020-12-22 | Denver | Colorado | 8031 | 45365 | 648 |
849303 | 849303 | 2020-12-21 | Denver | Colorado | 8031 | 45104 | 647 |
846058 | 846058 | 2020-12-20 | Denver | Colorado | 8031 | 44854 | 650 |
842812 | 842812 | 2020-12-19 | Denver | Colorado | 8031 | 44645 | 649 |
839567 | 839567 | 2020-12-18 | Denver | Colorado | 8031 | 44353 | 642 |
836322 | 836322 | 2020-12-17 | Denver | Colorado | 8031 | 43979 | 642 |
833076 | 833076 | 2020-12-16 | Denver | Colorado | 8031 | 43591 | 635 |
829829 | 829829 | 2020-12-15 | Denver | Colorado | 8031 | 43335 | 626 |
826583 | 826583 | 2020-12-14 | Denver | Colorado | 8031 | 43057 | 623 |
823336 | 823336 | 2020-12-13 | Denver | Colorado | 8031 | 42590 | 612 |
820090 | 820090 | 2020-12-12 | Denver | Colorado | 8031 | 42590 | 612 |
816844 | 816844 | 2020-12-11 | Denver | Colorado | 8031 | 42228 | 593 |
813598 | 813598 | 2020-12-10 | Denver | Colorado | 8031 | 41624 | 592 |
810354 | 810354 | 2020-12-09 | Denver | Colorado | 8031 | 41053 | 582 |
807109 | 807109 | 2020-12-08 | Denver | Colorado | 8031 | 40714 | 582 |
803864 | 803864 | 2020-12-07 | Denver | Colorado | 8031 | 40429 | 571 |
800619 | 800619 | 2020-12-06 | Denver | Colorado | 8031 | 40078 | 567 |
797374 | 797374 | 2020-12-05 | Denver | Colorado | 8031 | 39582 | 566 |
794129 | 794129 | 2020-12-04 | Denver | Colorado | 8031 | 38825 | 552 |
790884 | 790884 | 2020-12-03 | Denver | Colorado | 8031 | 38756 | 547 |
787639 | 787639 | 2020-12-02 | Denver | Colorado | 8031 | 37938 | 547 |
784395 | 784395 | 2020-12-01 | Denver | Colorado | 8031 | 37421 | 539 |
781150 | 781150 | 2020-11-30 | Denver | Colorado | 8031 | 37033 | 531 |
777904 | 777904 | 2020-11-29 | Denver | Colorado | 8031 | 36618 | 527 |
774659 | 774659 | 2020-11-28 | Denver | Colorado | 8031 | 36232 | 526 |
771414 | 771414 | 2020-11-27 | Denver | Colorado | 8031 | 35787 | 523 |
768169 | 768169 | 2020-11-26 | Denver | Colorado | 8031 | 35075 | 521 |
764923 | 764923 | 2020-11-25 | Denver | Colorado | 8031 | 34816 | 515 |
761678 | 761678 | 2020-11-24 | Denver | Colorado | 8031 | 33971 | 510 |
758433 | 758433 | 2020-11-23 | Denver | Colorado | 8031 | 33404 | 507 |
755186 | 755186 | 2020-11-22 | Denver | Colorado | 8031 | 32836 | 506 |
751940 | 751940 | 2020-11-21 | Denver | Colorado | 8031 | 32087 | 502 |
748694 | 748694 | 2020-11-20 | Denver | Colorado | 8031 | 31540 | 494 |
745448 | 745448 | 2020-11-19 | Denver | Colorado | 8031 | 30631 | 493 |
742201 | 742201 | 2020-11-18 | Denver | Colorado | 8031 | 30082 | 492 |
738954 | 738954 | 2020-11-17 | Denver | Colorado | 8031 | 29229 | 491 |
735710 | 735710 | 2020-11-16 | Denver | Colorado | 8031 | 28654 | 491 |
732464 | 732464 | 2020-11-15 | Denver | Colorado | 8031 | 27986 | 482 |
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);