ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Morgan" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1021337 | 1021337 | 2021-02-12 | Morgan | Colorado | 8087 | 2402 | 90 |
1018092 | 1018092 | 2021-02-11 | Morgan | Colorado | 8087 | 2397 | 90 |
1014847 | 1014847 | 2021-02-10 | Morgan | Colorado | 8087 | 2398 | 89 |
1011602 | 1011602 | 2021-02-09 | Morgan | Colorado | 8087 | 2396 | 89 |
1008356 | 1008356 | 2021-02-08 | Morgan | Colorado | 8087 | 2393 | 89 |
1005110 | 1005110 | 2021-02-07 | Morgan | Colorado | 8087 | 2389 | 89 |
1001864 | 1001864 | 2021-02-06 | Morgan | Colorado | 8087 | 2386 | 89 |
998618 | 998618 | 2021-02-05 | Morgan | Colorado | 8087 | 2381 | 89 |
995372 | 995372 | 2021-02-04 | Morgan | Colorado | 8087 | 2374 | 89 |
992126 | 992126 | 2021-02-03 | Morgan | Colorado | 8087 | 2370 | 89 |
988880 | 988880 | 2021-02-02 | Morgan | Colorado | 8087 | 2367 | 89 |
985633 | 985633 | 2021-02-01 | Morgan | Colorado | 8087 | 2366 | 89 |
982386 | 982386 | 2021-01-31 | Morgan | Colorado | 8087 | 2354 | 88 |
979140 | 979140 | 2021-01-30 | Morgan | Colorado | 8087 | 2354 | 88 |
975895 | 975895 | 2021-01-29 | Morgan | Colorado | 8087 | 2354 | 88 |
972650 | 972650 | 2021-01-28 | Morgan | Colorado | 8087 | 2349 | 88 |
969405 | 969405 | 2021-01-27 | Morgan | Colorado | 8087 | 2345 | 88 |
966161 | 966161 | 2021-01-26 | Morgan | Colorado | 8087 | 2342 | 88 |
962916 | 962916 | 2021-01-25 | Morgan | Colorado | 8087 | 2338 | 87 |
959671 | 959671 | 2021-01-24 | Morgan | Colorado | 8087 | 2338 | 87 |
956425 | 956425 | 2021-01-23 | Morgan | Colorado | 8087 | 2337 | 87 |
953180 | 953180 | 2021-01-22 | Morgan | Colorado | 8087 | 2335 | 86 |
949935 | 949935 | 2021-01-21 | Morgan | Colorado | 8087 | 2330 | 86 |
946689 | 946689 | 2021-01-20 | Morgan | Colorado | 8087 | 2313 | 86 |
943442 | 943442 | 2021-01-19 | Morgan | Colorado | 8087 | 2308 | 86 |
940197 | 940197 | 2021-01-18 | Morgan | Colorado | 8087 | 2305 | 86 |
936952 | 936952 | 2021-01-17 | Morgan | Colorado | 8087 | 2302 | 86 |
933707 | 933707 | 2021-01-16 | Morgan | Colorado | 8087 | 2297 | 85 |
930462 | 930462 | 2021-01-15 | Morgan | Colorado | 8087 | 2292 | 85 |
927217 | 927217 | 2021-01-14 | Morgan | Colorado | 8087 | 2282 | 85 |
923971 | 923971 | 2021-01-13 | Morgan | Colorado | 8087 | 2274 | 85 |
920726 | 920726 | 2021-01-12 | Morgan | Colorado | 8087 | 2258 | 84 |
917481 | 917481 | 2021-01-11 | Morgan | Colorado | 8087 | 2248 | 84 |
914236 | 914236 | 2021-01-10 | Morgan | Colorado | 8087 | 2245 | 84 |
910991 | 910991 | 2021-01-09 | Morgan | Colorado | 8087 | 2237 | 84 |
907746 | 907746 | 2021-01-08 | Morgan | Colorado | 8087 | 2222 | 84 |
904500 | 904500 | 2021-01-07 | Morgan | Colorado | 8087 | 2213 | 84 |
901255 | 901255 | 2021-01-06 | Morgan | Colorado | 8087 | 2169 | 83 |
898010 | 898010 | 2021-01-05 | Morgan | Colorado | 8087 | 2169 | 83 |
894765 | 894765 | 2021-01-04 | Morgan | Colorado | 8087 | 2164 | 83 |
891518 | 891518 | 2021-01-03 | Morgan | Colorado | 8087 | 2160 | 83 |
888271 | 888271 | 2021-01-02 | Morgan | Colorado | 8087 | 2150 | 82 |
885026 | 885026 | 2021-01-01 | Morgan | Colorado | 8087 | 2136 | 82 |
881781 | 881781 | 2020-12-31 | Morgan | Colorado | 8087 | 2119 | 81 |
878536 | 878536 | 2020-12-30 | Morgan | Colorado | 8087 | 2110 | 77 |
875291 | 875291 | 2020-12-29 | Morgan | Colorado | 8087 | 2102 | 75 |
872046 | 872046 | 2020-12-28 | Morgan | Colorado | 8087 | 2094 | 74 |
868801 | 868801 | 2020-12-27 | Morgan | Colorado | 8087 | 2092 | 74 |
865556 | 865556 | 2020-12-26 | Morgan | Colorado | 8087 | 2085 | 74 |
862311 | 862311 | 2020-12-25 | Morgan | Colorado | 8087 | 2078 | 73 |
859066 | 859066 | 2020-12-24 | Morgan | Colorado | 8087 | 2067 | 72 |
855821 | 855821 | 2020-12-23 | Morgan | Colorado | 8087 | 2043 | 70 |
852576 | 852576 | 2020-12-22 | Morgan | Colorado | 8087 | 2037 | 69 |
849331 | 849331 | 2020-12-21 | Morgan | Colorado | 8087 | 2020 | 69 |
846086 | 846086 | 2020-12-20 | Morgan | Colorado | 8087 | 2013 | 69 |
842840 | 842840 | 2020-12-19 | Morgan | Colorado | 8087 | 1989 | 69 |
839595 | 839595 | 2020-12-18 | Morgan | Colorado | 8087 | 1980 | 65 |
836350 | 836350 | 2020-12-17 | Morgan | Colorado | 8087 | 1962 | 65 |
833104 | 833104 | 2020-12-16 | Morgan | Colorado | 8087 | 1937 | 64 |
829857 | 829857 | 2020-12-15 | Morgan | Colorado | 8087 | 1924 | 64 |
826611 | 826611 | 2020-12-14 | Morgan | Colorado | 8087 | 1901 | 63 |
823364 | 823364 | 2020-12-13 | Morgan | Colorado | 8087 | 1901 | 63 |
820118 | 820118 | 2020-12-12 | Morgan | Colorado | 8087 | 1885 | 63 |
816872 | 816872 | 2020-12-11 | Morgan | Colorado | 8087 | 1871 | 63 |
813626 | 813626 | 2020-12-10 | Morgan | Colorado | 8087 | 1848 | 62 |
810382 | 810382 | 2020-12-09 | Morgan | Colorado | 8087 | 1833 | 61 |
807137 | 807137 | 2020-12-08 | Morgan | Colorado | 8087 | 1809 | 58 |
803892 | 803892 | 2020-12-07 | Morgan | Colorado | 8087 | 1792 | 58 |
800647 | 800647 | 2020-12-06 | Morgan | Colorado | 8087 | 1766 | 58 |
797402 | 797402 | 2020-12-05 | Morgan | Colorado | 8087 | 1756 | 58 |
794157 | 794157 | 2020-12-04 | Morgan | Colorado | 8087 | 1737 | 58 |
790912 | 790912 | 2020-12-03 | Morgan | Colorado | 8087 | 1720 | 58 |
787667 | 787667 | 2020-12-02 | Morgan | Colorado | 8087 | 1691 | 54 |
784423 | 784423 | 2020-12-01 | Morgan | Colorado | 8087 | 1681 | 52 |
781178 | 781178 | 2020-11-30 | Morgan | Colorado | 8087 | 1667 | 52 |
777932 | 777932 | 2020-11-29 | Morgan | Colorado | 8087 | 1639 | 52 |
774687 | 774687 | 2020-11-28 | Morgan | Colorado | 8087 | 1618 | 52 |
771442 | 771442 | 2020-11-27 | Morgan | Colorado | 8087 | 1596 | 52 |
768197 | 768197 | 2020-11-26 | Morgan | Colorado | 8087 | 1570 | 52 |
764951 | 764951 | 2020-11-25 | Morgan | Colorado | 8087 | 1539 | 51 |
761706 | 761706 | 2020-11-24 | Morgan | Colorado | 8087 | 1499 | 51 |
758461 | 758461 | 2020-11-23 | Morgan | Colorado | 8087 | 1473 | 51 |
755214 | 755214 | 2020-11-22 | Morgan | Colorado | 8087 | 1445 | 51 |
751968 | 751968 | 2020-11-21 | Morgan | Colorado | 8087 | 1418 | 51 |
748722 | 748722 | 2020-11-20 | Morgan | Colorado | 8087 | 1377 | 51 |
745476 | 745476 | 2020-11-19 | Morgan | Colorado | 8087 | 1357 | 51 |
742229 | 742229 | 2020-11-18 | Morgan | Colorado | 8087 | 1325 | 51 |
738982 | 738982 | 2020-11-17 | Morgan | Colorado | 8087 | 1301 | 51 |
735738 | 735738 | 2020-11-16 | Morgan | Colorado | 8087 | 1258 | 51 |
732492 | 732492 | 2020-11-15 | Morgan | Colorado | 8087 | 1243 | 51 |
729247 | 729247 | 2020-11-14 | Morgan | Colorado | 8087 | 1210 | 50 |
726004 | 726004 | 2020-11-13 | Morgan | Colorado | 8087 | 1182 | 50 |
722761 | 722761 | 2020-11-12 | Morgan | Colorado | 8087 | 1129 | 50 |
719518 | 719518 | 2020-11-11 | Morgan | Colorado | 8087 | 1120 | 50 |
716275 | 716275 | 2020-11-10 | Morgan | Colorado | 8087 | 1094 | 50 |
713031 | 713031 | 2020-11-09 | Morgan | Colorado | 8087 | 1073 | 50 |
709787 | 709787 | 2020-11-08 | Morgan | Colorado | 8087 | 1057 | 50 |
706543 | 706543 | 2020-11-07 | Morgan | Colorado | 8087 | 1033 | 50 |
703300 | 703300 | 2020-11-06 | Morgan | Colorado | 8087 | 1011 | 50 |
700057 | 700057 | 2020-11-05 | Morgan | Colorado | 8087 | 973 | 49 |
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);