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 |
---|---|---|---|---|---|---|---|
1053809 | 1053809 | 2021-02-22 | Summit | Colorado | 8117 | 2961 | 7 |
1050562 | 1050562 | 2021-02-21 | Summit | Colorado | 8117 | 2958 | 7 |
1047315 | 1047315 | 2021-02-20 | Summit | Colorado | 8117 | 2948 | 7 |
1044070 | 1044070 | 2021-02-19 | Summit | Colorado | 8117 | 2941 | 7 |
1040825 | 1040825 | 2021-02-18 | Summit | Colorado | 8117 | 2929 | 7 |
1037580 | 1037580 | 2021-02-17 | Summit | Colorado | 8117 | 2920 | 7 |
1034335 | 1034335 | 2021-02-16 | Summit | Colorado | 8117 | 2907 | 8 |
1031089 | 1031089 | 2021-02-15 | Summit | Colorado | 8117 | 2901 | 7 |
1027842 | 1027842 | 2021-02-14 | Summit | Colorado | 8117 | 2896 | 7 |
1024597 | 1024597 | 2021-02-13 | Summit | Colorado | 8117 | 2878 | 7 |
1021352 | 1021352 | 2021-02-12 | Summit | Colorado | 8117 | 2859 | 7 |
1018107 | 1018107 | 2021-02-11 | Summit | Colorado | 8117 | 2834 | 6 |
1014862 | 1014862 | 2021-02-10 | Summit | Colorado | 8117 | 2811 | 5 |
1011617 | 1011617 | 2021-02-09 | Summit | Colorado | 8117 | 2806 | 5 |
1008371 | 1008371 | 2021-02-08 | Summit | Colorado | 8117 | 2797 | 5 |
1005125 | 1005125 | 2021-02-07 | Summit | Colorado | 8117 | 2775 | 5 |
1001879 | 1001879 | 2021-02-06 | Summit | Colorado | 8117 | 2760 | 5 |
998633 | 998633 | 2021-02-05 | Summit | Colorado | 8117 | 2734 | 5 |
995387 | 995387 | 2021-02-04 | Summit | Colorado | 8117 | 2712 | 5 |
992141 | 992141 | 2021-02-03 | Summit | Colorado | 8117 | 2702 | 5 |
988895 | 988895 | 2021-02-02 | Summit | Colorado | 8117 | 2684 | 5 |
985648 | 985648 | 2021-02-01 | Summit | Colorado | 8117 | 2675 | 5 |
982401 | 982401 | 2021-01-31 | Summit | Colorado | 8117 | 2623 | 5 |
979155 | 979155 | 2021-01-30 | Summit | Colorado | 8117 | 2623 | 5 |
975910 | 975910 | 2021-01-29 | Summit | Colorado | 8117 | 2623 | 5 |
972665 | 972665 | 2021-01-28 | Summit | Colorado | 8117 | 2611 | 5 |
969420 | 969420 | 2021-01-27 | Summit | Colorado | 8117 | 2587 | 5 |
966176 | 966176 | 2021-01-26 | Summit | Colorado | 8117 | 2566 | 5 |
962931 | 962931 | 2021-01-25 | Summit | Colorado | 8117 | 2532 | 5 |
959686 | 959686 | 2021-01-24 | Summit | Colorado | 8117 | 2532 | 5 |
956440 | 956440 | 2021-01-23 | Summit | Colorado | 8117 | 2505 | 5 |
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 |
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);