ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,549 rows where county = "Morgan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1034525 | 1034525 | 2021-02-16 | Morgan | Georgia | 13211 | 1871 | 15 |
1034700 | 1034700 | 2021-02-16 | Morgan | Illinois | 17137 | 3608 | 97 |
1034789 | 1034789 | 2021-02-16 | Morgan | Indiana | 18109 | 5967 | 129 |
1035120 | 1035120 | 2021-02-16 | Morgan | Kentucky | 21175 | 1964 | 1 |
1035600 | 1035600 | 2021-02-16 | Morgan | Missouri | 29141 | 1619 | 39 |
1036148 | 1036148 | 2021-02-16 | Morgan | Ohio | 39115 | 943 | 34 |
1036621 | 1036621 | 2021-02-16 | Morgan | Tennessee | 47129 | 2257 | 34 |
1036921 | 1036921 | 2021-02-16 | Morgan | Utah | 49029 | 1114 | 11 |
1037159 | 1037159 | 2021-02-16 | Morgan | West Virginia | 54065 | 903 | 13 |
1030837 | 1030837 | 2021-02-15 | Morgan | Alabama | 1103 | 13407 | 234 |
1031074 | 1031074 | 2021-02-15 | Morgan | Colorado | 8087 | 2405 | 90 |
1031279 | 1031279 | 2021-02-15 | Morgan | Georgia | 13211 | 1852 | 13 |
1031454 | 1031454 | 2021-02-15 | Morgan | Illinois | 17137 | 3542 | 96 |
1031543 | 1031543 | 2021-02-15 | Morgan | Indiana | 18109 | 5960 | 129 |
1031874 | 1031874 | 2021-02-15 | Morgan | Kentucky | 21175 | 1964 | 1 |
1032355 | 1032355 | 2021-02-15 | Morgan | Missouri | 29141 | 1618 | 39 |
1032903 | 1032903 | 2021-02-15 | Morgan | Ohio | 39115 | 946 | 33 |
1033376 | 1033376 | 2021-02-15 | Morgan | Tennessee | 47129 | 2241 | 34 |
1033676 | 1033676 | 2021-02-15 | Morgan | Utah | 49029 | 1114 | 11 |
1033914 | 1033914 | 2021-02-15 | Morgan | West Virginia | 54065 | 903 | 13 |
1027590 | 1027590 | 2021-02-14 | Morgan | Alabama | 1103 | 13395 | 234 |
1027827 | 1027827 | 2021-02-14 | Morgan | Colorado | 8087 | 2403 | 90 |
1028032 | 1028032 | 2021-02-14 | Morgan | Georgia | 13211 | 1847 | 13 |
1028207 | 1028207 | 2021-02-14 | Morgan | Illinois | 17137 | 3542 | 96 |
1028296 | 1028296 | 2021-02-14 | Morgan | Indiana | 18109 | 5943 | 129 |
1028627 | 1028627 | 2021-02-14 | Morgan | Kentucky | 21175 | 1964 | 1 |
1029108 | 1029108 | 2021-02-14 | Morgan | Missouri | 29141 | 1616 | 39 |
1029657 | 1029657 | 2021-02-14 | Morgan | Ohio | 39115 | 940 | 33 |
1030130 | 1030130 | 2021-02-14 | Morgan | Tennessee | 47129 | 2233 | 34 |
1030430 | 1030430 | 2021-02-14 | Morgan | Utah | 49029 | 1114 | 11 |
1030668 | 1030668 | 2021-02-14 | Morgan | West Virginia | 54065 | 902 | 13 |
1024345 | 1024345 | 2021-02-13 | Morgan | Alabama | 1103 | 13375 | 234 |
1024582 | 1024582 | 2021-02-13 | Morgan | Colorado | 8087 | 2404 | 90 |
1024787 | 1024787 | 2021-02-13 | Morgan | Georgia | 13211 | 1845 | 13 |
1024962 | 1024962 | 2021-02-13 | Morgan | Illinois | 17137 | 3542 | 96 |
1025051 | 1025051 | 2021-02-13 | Morgan | Indiana | 18109 | 5931 | 129 |
1025382 | 1025382 | 2021-02-13 | Morgan | Kentucky | 21175 | 1959 | 1 |
1025862 | 1025862 | 2021-02-13 | Morgan | Missouri | 29141 | 1614 | 39 |
1026410 | 1026410 | 2021-02-13 | Morgan | Ohio | 39115 | 939 | 33 |
1026883 | 1026883 | 2021-02-13 | Morgan | Tennessee | 47129 | 2216 | 33 |
1027183 | 1027183 | 2021-02-13 | Morgan | Utah | 49029 | 1114 | 11 |
1027421 | 1027421 | 2021-02-13 | Morgan | West Virginia | 54065 | 901 | 13 |
1021100 | 1021100 | 2021-02-12 | Morgan | Alabama | 1103 | 13346 | 233 |
1021337 | 1021337 | 2021-02-12 | Morgan | Colorado | 8087 | 2402 | 90 |
1021542 | 1021542 | 2021-02-12 | Morgan | Georgia | 13211 | 1832 | 13 |
1021717 | 1021717 | 2021-02-12 | Morgan | Illinois | 17137 | 3542 | 96 |
1021806 | 1021806 | 2021-02-12 | Morgan | Indiana | 18109 | 5915 | 129 |
1022137 | 1022137 | 2021-02-12 | Morgan | Kentucky | 21175 | 1958 | 0 |
1022617 | 1022617 | 2021-02-12 | Morgan | Missouri | 29141 | 1613 | 39 |
1023165 | 1023165 | 2021-02-12 | Morgan | Ohio | 39115 | 934 | 32 |
1023638 | 1023638 | 2021-02-12 | Morgan | Tennessee | 47129 | 2201 | 32 |
1023938 | 1023938 | 2021-02-12 | Morgan | Utah | 49029 | 1112 | 11 |
1024176 | 1024176 | 2021-02-12 | Morgan | West Virginia | 54065 | 899 | 13 |
1017855 | 1017855 | 2021-02-11 | Morgan | Alabama | 1103 | 13329 | 230 |
1018092 | 1018092 | 2021-02-11 | Morgan | Colorado | 8087 | 2397 | 90 |
1018297 | 1018297 | 2021-02-11 | Morgan | Georgia | 13211 | 1828 | 13 |
1018472 | 1018472 | 2021-02-11 | Morgan | Illinois | 17137 | 3542 | 96 |
1018561 | 1018561 | 2021-02-11 | Morgan | Indiana | 18109 | 5902 | 129 |
1018892 | 1018892 | 2021-02-11 | Morgan | Kentucky | 21175 | 1953 | 0 |
1019372 | 1019372 | 2021-02-11 | Morgan | Missouri | 29141 | 1614 | 39 |
1019920 | 1019920 | 2021-02-11 | Morgan | Ohio | 39115 | 929 | 32 |
1020393 | 1020393 | 2021-02-11 | Morgan | Tennessee | 47129 | 2195 | 30 |
1020693 | 1020693 | 2021-02-11 | Morgan | Utah | 49029 | 1109 | 11 |
1020931 | 1020931 | 2021-02-11 | Morgan | West Virginia | 54065 | 898 | 13 |
1014610 | 1014610 | 2021-02-10 | Morgan | Alabama | 1103 | 13303 | 225 |
1014847 | 1014847 | 2021-02-10 | Morgan | Colorado | 8087 | 2398 | 89 |
1015052 | 1015052 | 2021-02-10 | Morgan | Georgia | 13211 | 1816 | 13 |
1015227 | 1015227 | 2021-02-10 | Morgan | Illinois | 17137 | 3497 | 95 |
1015316 | 1015316 | 2021-02-10 | Morgan | Indiana | 18109 | 5880 | 129 |
1015647 | 1015647 | 2021-02-10 | Morgan | Kentucky | 21175 | 1946 | 0 |
1016127 | 1016127 | 2021-02-10 | Morgan | Missouri | 29141 | 1609 | 39 |
1016675 | 1016675 | 2021-02-10 | Morgan | Ohio | 39115 | 926 | 31 |
1017148 | 1017148 | 2021-02-10 | Morgan | Tennessee | 47129 | 2163 | 29 |
1017448 | 1017448 | 2021-02-10 | Morgan | Utah | 49029 | 1105 | 10 |
1017686 | 1017686 | 2021-02-10 | Morgan | West Virginia | 54065 | 895 | 12 |
1011365 | 1011365 | 2021-02-09 | Morgan | Alabama | 1103 | 13285 | 220 |
1011602 | 1011602 | 2021-02-09 | Morgan | Colorado | 8087 | 2396 | 89 |
1011807 | 1011807 | 2021-02-09 | Morgan | Georgia | 13211 | 1813 | 13 |
1011982 | 1011982 | 2021-02-09 | Morgan | Illinois | 17137 | 3497 | 95 |
1012071 | 1012071 | 2021-02-09 | Morgan | Indiana | 18109 | 5877 | 129 |
1012402 | 1012402 | 2021-02-09 | Morgan | Kentucky | 21175 | 1944 | 0 |
1012882 | 1012882 | 2021-02-09 | Morgan | Missouri | 29141 | 1608 | 39 |
1013430 | 1013430 | 2021-02-09 | Morgan | Ohio | 39115 | 924 | 31 |
1013903 | 1013903 | 2021-02-09 | Morgan | Tennessee | 47129 | 2090 | 26 |
1014203 | 1014203 | 2021-02-09 | Morgan | Utah | 49029 | 1102 | 10 |
1014441 | 1014441 | 2021-02-09 | Morgan | West Virginia | 54065 | 892 | 11 |
1008119 | 1008119 | 2021-02-08 | Morgan | Alabama | 1103 | 13272 | 220 |
1008356 | 1008356 | 2021-02-08 | Morgan | Colorado | 8087 | 2393 | 89 |
1008561 | 1008561 | 2021-02-08 | Morgan | Georgia | 13211 | 1799 | 13 |
1008736 | 1008736 | 2021-02-08 | Morgan | Illinois | 17137 | 3497 | 95 |
1008825 | 1008825 | 2021-02-08 | Morgan | Indiana | 18109 | 5867 | 126 |
1009156 | 1009156 | 2021-02-08 | Morgan | Kentucky | 21175 | 1943 | 0 |
1009637 | 1009637 | 2021-02-08 | Morgan | Missouri | 29141 | 1608 | 37 |
1010185 | 1010185 | 2021-02-08 | Morgan | Ohio | 39115 | 923 | 31 |
1010658 | 1010658 | 2021-02-08 | Morgan | Tennessee | 47129 | 2060 | 25 |
1010958 | 1010958 | 2021-02-08 | Morgan | Utah | 49029 | 1101 | 10 |
1011196 | 1011196 | 2021-02-08 | Morgan | West Virginia | 54065 | 891 | 11 |
1004873 | 1004873 | 2021-02-07 | Morgan | Alabama | 1103 | 13250 | 220 |
1005110 | 1005110 | 2021-02-07 | Morgan | Colorado | 8087 | 2389 | 89 |
1005315 | 1005315 | 2021-02-07 | Morgan | Georgia | 13211 | 1791 | 13 |
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);