ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 8117 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953195 | 953195 | 2021-01-22 | Summit | Colorado | 8117 | 2476 | 5 |
949950 | 949950 | 2021-01-21 | Summit | Colorado | 8117 | 2460 | 5 |
946704 | 946704 | 2021-01-20 | Summit | Colorado | 8117 | 2441 | 6 |
943457 | 943457 | 2021-01-19 | Summit | Colorado | 8117 | 2426 | 6 |
940212 | 940212 | 2021-01-18 | Summit | Colorado | 8117 | 2410 | 5 |
936967 | 936967 | 2021-01-17 | Summit | Colorado | 8117 | 2400 | 5 |
933722 | 933722 | 2021-01-16 | Summit | Colorado | 8117 | 2383 | 5 |
930477 | 930477 | 2021-01-15 | Summit | Colorado | 8117 | 2363 | 5 |
927232 | 927232 | 2021-01-14 | Summit | Colorado | 8117 | 2346 | 5 |
923986 | 923986 | 2021-01-13 | Summit | Colorado | 8117 | 2333 | 5 |
920741 | 920741 | 2021-01-12 | Summit | Colorado | 8117 | 2312 | 5 |
917496 | 917496 | 2021-01-11 | Summit | Colorado | 8117 | 2295 | 5 |
914251 | 914251 | 2021-01-10 | Summit | Colorado | 8117 | 2285 | 5 |
911006 | 911006 | 2021-01-09 | Summit | Colorado | 8117 | 2265 | 5 |
907761 | 907761 | 2021-01-08 | Summit | Colorado | 8117 | 2231 | 5 |
904515 | 904515 | 2021-01-07 | Summit | Colorado | 8117 | 2210 | 5 |
901270 | 901270 | 2021-01-06 | Summit | Colorado | 8117 | 2190 | 5 |
898025 | 898025 | 2021-01-05 | Summit | Colorado | 8117 | 2190 | 5 |
894780 | 894780 | 2021-01-04 | Summit | Colorado | 8117 | 2185 | 5 |
891533 | 891533 | 2021-01-03 | Summit | Colorado | 8117 | 2166 | 5 |
888286 | 888286 | 2021-01-02 | Summit | Colorado | 8117 | 2167 | 5 |
885041 | 885041 | 2021-01-01 | Summit | Colorado | 8117 | 2143 | 5 |
881796 | 881796 | 2020-12-31 | Summit | Colorado | 8117 | 2134 | 5 |
878551 | 878551 | 2020-12-30 | Summit | Colorado | 8117 | 2114 | 5 |
875306 | 875306 | 2020-12-29 | Summit | Colorado | 8117 | 2099 | 5 |
872061 | 872061 | 2020-12-28 | Summit | Colorado | 8117 | 2092 | 5 |
868816 | 868816 | 2020-12-27 | Summit | Colorado | 8117 | 2077 | 5 |
865571 | 865571 | 2020-12-26 | Summit | Colorado | 8117 | 2073 | 5 |
862326 | 862326 | 2020-12-25 | Summit | Colorado | 8117 | 2065 | 5 |
859081 | 859081 | 2020-12-24 | Summit | Colorado | 8117 | 2039 | 5 |
855836 | 855836 | 2020-12-23 | Summit | Colorado | 8117 | 2030 | 5 |
852591 | 852591 | 2020-12-22 | Summit | Colorado | 8117 | 1990 | 5 |
849346 | 849346 | 2020-12-21 | Summit | Colorado | 8117 | 1961 | 5 |
846101 | 846101 | 2020-12-20 | Summit | Colorado | 8117 | 1939 | 5 |
842855 | 842855 | 2020-12-19 | Summit | Colorado | 8117 | 1934 | 5 |
839610 | 839610 | 2020-12-18 | Summit | Colorado | 8117 | 1915 | 5 |
836365 | 836365 | 2020-12-17 | Summit | Colorado | 8117 | 1890 | 5 |
833119 | 833119 | 2020-12-16 | Summit | Colorado | 8117 | 1882 | 5 |
829872 | 829872 | 2020-12-15 | Summit | Colorado | 8117 | 1859 | 5 |
826626 | 826626 | 2020-12-14 | Summit | Colorado | 8117 | 1826 | 5 |
823379 | 823379 | 2020-12-13 | Summit | Colorado | 8117 | 1826 | 5 |
820133 | 820133 | 2020-12-12 | Summit | Colorado | 8117 | 1811 | 5 |
816887 | 816887 | 2020-12-11 | Summit | Colorado | 8117 | 1789 | 5 |
813641 | 813641 | 2020-12-10 | Summit | Colorado | 8117 | 1776 | 5 |
810397 | 810397 | 2020-12-09 | Summit | Colorado | 8117 | 1752 | 4 |
807152 | 807152 | 2020-12-08 | Summit | Colorado | 8117 | 1739 | 4 |
803907 | 803907 | 2020-12-07 | Summit | Colorado | 8117 | 1714 | 4 |
800662 | 800662 | 2020-12-06 | Summit | Colorado | 8117 | 1698 | 4 |
797417 | 797417 | 2020-12-05 | Summit | Colorado | 8117 | 1677 | 4 |
794172 | 794172 | 2020-12-04 | Summit | Colorado | 8117 | 1646 | 4 |
790927 | 790927 | 2020-12-03 | Summit | Colorado | 8117 | 1621 | 4 |
787682 | 787682 | 2020-12-02 | Summit | Colorado | 8117 | 1582 | 4 |
784438 | 784438 | 2020-12-01 | Summit | Colorado | 8117 | 1553 | 4 |
781193 | 781193 | 2020-11-30 | Summit | Colorado | 8117 | 1517 | 4 |
777947 | 777947 | 2020-11-29 | Summit | Colorado | 8117 | 1488 | 4 |
774702 | 774702 | 2020-11-28 | Summit | Colorado | 8117 | 1469 | 4 |
771457 | 771457 | 2020-11-27 | Summit | Colorado | 8117 | 1451 | 4 |
768212 | 768212 | 2020-11-26 | Summit | Colorado | 8117 | 1426 | 4 |
764966 | 764966 | 2020-11-25 | Summit | Colorado | 8117 | 1392 | 4 |
761721 | 761721 | 2020-11-24 | Summit | Colorado | 8117 | 1366 | 4 |
758476 | 758476 | 2020-11-23 | Summit | Colorado | 8117 | 1344 | 4 |
755229 | 755229 | 2020-11-22 | Summit | Colorado | 8117 | 1330 | 4 |
751983 | 751983 | 2020-11-21 | Summit | Colorado | 8117 | 1287 | 4 |
748737 | 748737 | 2020-11-20 | Summit | Colorado | 8117 | 1242 | 4 |
745491 | 745491 | 2020-11-19 | Summit | Colorado | 8117 | 1230 | 4 |
742244 | 742244 | 2020-11-18 | Summit | Colorado | 8117 | 1189 | 4 |
738997 | 738997 | 2020-11-17 | Summit | Colorado | 8117 | 1174 | 4 |
735753 | 735753 | 2020-11-16 | Summit | Colorado | 8117 | 1150 | 4 |
732507 | 732507 | 2020-11-15 | Summit | Colorado | 8117 | 1129 | 4 |
729262 | 729262 | 2020-11-14 | Summit | Colorado | 8117 | 1116 | 4 |
726019 | 726019 | 2020-11-13 | Summit | Colorado | 8117 | 1094 | 4 |
722776 | 722776 | 2020-11-12 | Summit | Colorado | 8117 | 1058 | 4 |
719533 | 719533 | 2020-11-11 | Summit | Colorado | 8117 | 1031 | 4 |
716290 | 716290 | 2020-11-10 | Summit | Colorado | 8117 | 1024 | 4 |
713046 | 713046 | 2020-11-09 | Summit | Colorado | 8117 | 979 | 4 |
709802 | 709802 | 2020-11-08 | Summit | Colorado | 8117 | 962 | 4 |
706558 | 706558 | 2020-11-07 | Summit | Colorado | 8117 | 937 | 4 |
703315 | 703315 | 2020-11-06 | Summit | Colorado | 8117 | 904 | 4 |
700072 | 700072 | 2020-11-05 | Summit | Colorado | 8117 | 874 | 4 |
696828 | 696828 | 2020-11-04 | Summit | Colorado | 8117 | 858 | 4 |
693586 | 693586 | 2020-11-03 | Summit | Colorado | 8117 | 827 | 4 |
690343 | 690343 | 2020-11-02 | Summit | Colorado | 8117 | 800 | 4 |
687098 | 687098 | 2020-11-01 | Summit | Colorado | 8117 | 779 | 4 |
683854 | 683854 | 2020-10-31 | Summit | Colorado | 8117 | 753 | 4 |
680611 | 680611 | 2020-10-30 | Summit | Colorado | 8117 | 751 | 4 |
677368 | 677368 | 2020-10-29 | Summit | Colorado | 8117 | 731 | 4 |
674125 | 674125 | 2020-10-28 | Summit | Colorado | 8117 | 719 | 4 |
670883 | 670883 | 2020-10-27 | Summit | Colorado | 8117 | 696 | 4 |
667640 | 667640 | 2020-10-26 | Summit | Colorado | 8117 | 679 | 4 |
664395 | 664395 | 2020-10-25 | Summit | Colorado | 8117 | 667 | 4 |
661151 | 661151 | 2020-10-24 | Summit | Colorado | 8117 | 653 | 4 |
657907 | 657907 | 2020-10-23 | Summit | Colorado | 8117 | 636 | 4 |
654662 | 654662 | 2020-10-22 | Summit | Colorado | 8117 | 621 | 4 |
651417 | 651417 | 2020-10-21 | Summit | Colorado | 8117 | 605 | 4 |
648173 | 648173 | 2020-10-20 | Summit | Colorado | 8117 | 593 | 4 |
644928 | 644928 | 2020-10-19 | Summit | Colorado | 8117 | 567 | 4 |
641680 | 641680 | 2020-10-18 | Summit | Colorado | 8117 | 563 | 4 |
638433 | 638433 | 2020-10-17 | Summit | Colorado | 8117 | 549 | 4 |
635188 | 635188 | 2020-10-16 | Summit | Colorado | 8117 | 540 | 4 |
631942 | 631942 | 2020-10-15 | Summit | Colorado | 8117 | 537 | 4 |
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);