ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Montrose" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053793 | 1053793 | 2021-02-22 | Montrose | Colorado | 8085 | 3195 | 52 |
1050546 | 1050546 | 2021-02-21 | Montrose | Colorado | 8085 | 3188 | 52 |
1047299 | 1047299 | 2021-02-20 | Montrose | Colorado | 8085 | 3186 | 52 |
1044054 | 1044054 | 2021-02-19 | Montrose | Colorado | 8085 | 3184 | 52 |
1040809 | 1040809 | 2021-02-18 | Montrose | Colorado | 8085 | 3178 | 51 |
1037564 | 1037564 | 2021-02-17 | Montrose | Colorado | 8085 | 3171 | 51 |
1034319 | 1034319 | 2021-02-16 | Montrose | Colorado | 8085 | 3165 | 51 |
1031073 | 1031073 | 2021-02-15 | Montrose | Colorado | 8085 | 3158 | 51 |
1027826 | 1027826 | 2021-02-14 | Montrose | Colorado | 8085 | 3152 | 51 |
1024581 | 1024581 | 2021-02-13 | Montrose | Colorado | 8085 | 3138 | 51 |
1021336 | 1021336 | 2021-02-12 | Montrose | Colorado | 8085 | 3133 | 51 |
1018091 | 1018091 | 2021-02-11 | Montrose | Colorado | 8085 | 3123 | 50 |
1014846 | 1014846 | 2021-02-10 | Montrose | Colorado | 8085 | 3107 | 50 |
1011601 | 1011601 | 2021-02-09 | Montrose | Colorado | 8085 | 3104 | 49 |
1008355 | 1008355 | 2021-02-08 | Montrose | Colorado | 8085 | 3095 | 49 |
1005109 | 1005109 | 2021-02-07 | Montrose | Colorado | 8085 | 3094 | 49 |
1001863 | 1001863 | 2021-02-06 | Montrose | Colorado | 8085 | 3077 | 46 |
998617 | 998617 | 2021-02-05 | Montrose | Colorado | 8085 | 3068 | 46 |
995371 | 995371 | 2021-02-04 | Montrose | Colorado | 8085 | 3054 | 45 |
992125 | 992125 | 2021-02-03 | Montrose | Colorado | 8085 | 3046 | 45 |
988879 | 988879 | 2021-02-02 | Montrose | Colorado | 8085 | 3030 | 45 |
985632 | 985632 | 2021-02-01 | Montrose | Colorado | 8085 | 3026 | 45 |
982385 | 982385 | 2021-01-31 | Montrose | Colorado | 8085 | 2976 | 45 |
979139 | 979139 | 2021-01-30 | Montrose | Colorado | 8085 | 2976 | 45 |
975894 | 975894 | 2021-01-29 | Montrose | Colorado | 8085 | 2976 | 45 |
972649 | 972649 | 2021-01-28 | Montrose | Colorado | 8085 | 2956 | 43 |
969404 | 969404 | 2021-01-27 | Montrose | Colorado | 8085 | 2925 | 42 |
966160 | 966160 | 2021-01-26 | Montrose | Colorado | 8085 | 2918 | 42 |
962915 | 962915 | 2021-01-25 | Montrose | Colorado | 8085 | 2900 | 42 |
959670 | 959670 | 2021-01-24 | Montrose | Colorado | 8085 | 2900 | 42 |
956424 | 956424 | 2021-01-23 | Montrose | Colorado | 8085 | 2865 | 41 |
953179 | 953179 | 2021-01-22 | Montrose | Colorado | 8085 | 2819 | 41 |
949934 | 949934 | 2021-01-21 | Montrose | Colorado | 8085 | 2805 | 41 |
946688 | 946688 | 2021-01-20 | Montrose | Colorado | 8085 | 2776 | 41 |
943441 | 943441 | 2021-01-19 | Montrose | Colorado | 8085 | 2752 | 41 |
940196 | 940196 | 2021-01-18 | Montrose | Colorado | 8085 | 2726 | 41 |
936951 | 936951 | 2021-01-17 | Montrose | Colorado | 8085 | 2702 | 41 |
933706 | 933706 | 2021-01-16 | Montrose | Colorado | 8085 | 2658 | 41 |
930461 | 930461 | 2021-01-15 | Montrose | Colorado | 8085 | 2623 | 41 |
927216 | 927216 | 2021-01-14 | Montrose | Colorado | 8085 | 2572 | 40 |
923970 | 923970 | 2021-01-13 | Montrose | Colorado | 8085 | 2515 | 38 |
920725 | 920725 | 2021-01-12 | Montrose | Colorado | 8085 | 2482 | 38 |
917480 | 917480 | 2021-01-11 | Montrose | Colorado | 8085 | 2466 | 38 |
914235 | 914235 | 2021-01-10 | Montrose | Colorado | 8085 | 2418 | 38 |
910990 | 910990 | 2021-01-09 | Montrose | Colorado | 8085 | 2383 | 36 |
907745 | 907745 | 2021-01-08 | Montrose | Colorado | 8085 | 2348 | 35 |
904499 | 904499 | 2021-01-07 | Montrose | Colorado | 8085 | 2310 | 35 |
901254 | 901254 | 2021-01-06 | Montrose | Colorado | 8085 | 2287 | 34 |
898009 | 898009 | 2021-01-05 | Montrose | Colorado | 8085 | 2287 | 34 |
894764 | 894764 | 2021-01-04 | Montrose | Colorado | 8085 | 2268 | 33 |
891517 | 891517 | 2021-01-03 | Montrose | Colorado | 8085 | 2243 | 33 |
888270 | 888270 | 2021-01-02 | Montrose | Colorado | 8085 | 2199 | 33 |
885025 | 885025 | 2021-01-01 | Montrose | Colorado | 8085 | 2134 | 31 |
881780 | 881780 | 2020-12-31 | Montrose | Colorado | 8085 | 2114 | 31 |
878535 | 878535 | 2020-12-30 | Montrose | Colorado | 8085 | 2092 | 30 |
875290 | 875290 | 2020-12-29 | Montrose | Colorado | 8085 | 2072 | 30 |
872045 | 872045 | 2020-12-28 | Montrose | Colorado | 8085 | 2055 | 29 |
868800 | 868800 | 2020-12-27 | Montrose | Colorado | 8085 | 2034 | 29 |
865555 | 865555 | 2020-12-26 | Montrose | Colorado | 8085 | 1961 | 29 |
862310 | 862310 | 2020-12-25 | Montrose | Colorado | 8085 | 1944 | 29 |
859065 | 859065 | 2020-12-24 | Montrose | Colorado | 8085 | 1932 | 29 |
855820 | 855820 | 2020-12-23 | Montrose | Colorado | 8085 | 1910 | 29 |
852575 | 852575 | 2020-12-22 | Montrose | Colorado | 8085 | 1895 | 29 |
849330 | 849330 | 2020-12-21 | Montrose | Colorado | 8085 | 1862 | 28 |
846085 | 846085 | 2020-12-20 | Montrose | Colorado | 8085 | 1836 | 28 |
842839 | 842839 | 2020-12-19 | Montrose | Colorado | 8085 | 1806 | 27 |
839594 | 839594 | 2020-12-18 | Montrose | Colorado | 8085 | 1773 | 27 |
836349 | 836349 | 2020-12-17 | Montrose | Colorado | 8085 | 1746 | 26 |
833103 | 833103 | 2020-12-16 | Montrose | Colorado | 8085 | 1712 | 25 |
829856 | 829856 | 2020-12-15 | Montrose | Colorado | 8085 | 1700 | 23 |
826610 | 826610 | 2020-12-14 | Montrose | Colorado | 8085 | 1632 | 22 |
823363 | 823363 | 2020-12-13 | Montrose | Colorado | 8085 | 1632 | 22 |
820117 | 820117 | 2020-12-12 | Montrose | Colorado | 8085 | 1586 | 22 |
816871 | 816871 | 2020-12-11 | Montrose | Colorado | 8085 | 1532 | 22 |
813625 | 813625 | 2020-12-10 | Montrose | Colorado | 8085 | 1470 | 21 |
810381 | 810381 | 2020-12-09 | Montrose | Colorado | 8085 | 1436 | 19 |
807136 | 807136 | 2020-12-08 | Montrose | Colorado | 8085 | 1401 | 16 |
803891 | 803891 | 2020-12-07 | Montrose | Colorado | 8085 | 1367 | 16 |
800646 | 800646 | 2020-12-06 | Montrose | Colorado | 8085 | 1345 | 16 |
797401 | 797401 | 2020-12-05 | Montrose | Colorado | 8085 | 1319 | 16 |
794156 | 794156 | 2020-12-04 | Montrose | Colorado | 8085 | 1285 | 15 |
790911 | 790911 | 2020-12-03 | Montrose | Colorado | 8085 | 1225 | 15 |
787666 | 787666 | 2020-12-02 | Montrose | Colorado | 8085 | 1159 | 15 |
784422 | 784422 | 2020-12-01 | Montrose | Colorado | 8085 | 1146 | 15 |
781177 | 781177 | 2020-11-30 | Montrose | Colorado | 8085 | 1115 | 15 |
777931 | 777931 | 2020-11-29 | Montrose | Colorado | 8085 | 1094 | 15 |
774686 | 774686 | 2020-11-28 | Montrose | Colorado | 8085 | 1029 | 15 |
771441 | 771441 | 2020-11-27 | Montrose | Colorado | 8085 | 999 | 15 |
768196 | 768196 | 2020-11-26 | Montrose | Colorado | 8085 | 977 | 15 |
764950 | 764950 | 2020-11-25 | Montrose | Colorado | 8085 | 895 | 15 |
761705 | 761705 | 2020-11-24 | Montrose | Colorado | 8085 | 868 | 15 |
758460 | 758460 | 2020-11-23 | Montrose | Colorado | 8085 | 848 | 15 |
755213 | 755213 | 2020-11-22 | Montrose | Colorado | 8085 | 806 | 15 |
751967 | 751967 | 2020-11-21 | Montrose | Colorado | 8085 | 770 | 15 |
748721 | 748721 | 2020-11-20 | Montrose | Colorado | 8085 | 734 | 15 |
745475 | 745475 | 2020-11-19 | Montrose | Colorado | 8085 | 714 | 15 |
742228 | 742228 | 2020-11-18 | Montrose | Colorado | 8085 | 682 | 15 |
738981 | 738981 | 2020-11-17 | Montrose | Colorado | 8085 | 670 | 14 |
735737 | 735737 | 2020-11-16 | Montrose | Colorado | 8085 | 647 | 14 |
732491 | 732491 | 2020-11-15 | Montrose | Colorado | 8085 | 630 | 14 |
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);