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 |
---|---|---|---|---|---|---|---|
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 |
1005490 | 1005490 | 2021-02-07 | Morgan | Illinois | 17137 | 3474 | 95 |
1005579 | 1005579 | 2021-02-07 | Morgan | Indiana | 18109 | 5857 | 124 |
1005910 | 1005910 | 2021-02-07 | Morgan | Kentucky | 21175 | 1943 | 0 |
1006390 | 1006390 | 2021-02-07 | Morgan | Missouri | 29141 | 1608 | 37 |
1006939 | 1006939 | 2021-02-07 | Morgan | Ohio | 39115 | 922 | 31 |
1007412 | 1007412 | 2021-02-07 | Morgan | Tennessee | 47129 | 2058 | 23 |
1007712 | 1007712 | 2021-02-07 | Morgan | Utah | 49029 | 1100 | 10 |
1007950 | 1007950 | 2021-02-07 | Morgan | West Virginia | 54065 | 884 | 11 |
1001627 | 1001627 | 2021-02-06 | Morgan | Alabama | 1103 | 13217 | 220 |
1001864 | 1001864 | 2021-02-06 | Morgan | Colorado | 8087 | 2386 | 89 |
1002069 | 1002069 | 2021-02-06 | Morgan | Georgia | 13211 | 1789 | 13 |
1002244 | 1002244 | 2021-02-06 | Morgan | Illinois | 17137 | 3474 | 95 |
1002333 | 1002333 | 2021-02-06 | Morgan | Indiana | 18109 | 5838 | 124 |
1002664 | 1002664 | 2021-02-06 | Morgan | Kentucky | 21175 | 1939 | 0 |
1003144 | 1003144 | 2021-02-06 | Morgan | Missouri | 29141 | 1607 | 37 |
1003693 | 1003693 | 2021-02-06 | Morgan | Ohio | 39115 | 922 | 31 |
1004166 | 1004166 | 2021-02-06 | Morgan | Tennessee | 47129 | 2053 | 23 |
1004466 | 1004466 | 2021-02-06 | Morgan | Utah | 49029 | 1099 | 10 |
1004704 | 1004704 | 2021-02-06 | Morgan | West Virginia | 54065 | 882 | 11 |
998381 | 998381 | 2021-02-05 | Morgan | Alabama | 1103 | 13174 | 217 |
998618 | 998618 | 2021-02-05 | Morgan | Colorado | 8087 | 2381 | 89 |
998823 | 998823 | 2021-02-05 | Morgan | Georgia | 13211 | 1771 | 13 |
998998 | 998998 | 2021-02-05 | Morgan | Illinois | 17137 | 3474 | 95 |
999087 | 999087 | 2021-02-05 | Morgan | Indiana | 18109 | 5800 | 122 |
999418 | 999418 | 2021-02-05 | Morgan | Kentucky | 21175 | 1933 | 0 |
999899 | 999899 | 2021-02-05 | Morgan | Missouri | 29141 | 1603 | 36 |
1000447 | 1000447 | 2021-02-05 | Morgan | Ohio | 39115 | 920 | 31 |
1000920 | 1000920 | 2021-02-05 | Morgan | Tennessee | 47129 | 2042 | 23 |
1001220 | 1001220 | 2021-02-05 | Morgan | Utah | 49029 | 1098 | 8 |
1001458 | 1001458 | 2021-02-05 | Morgan | West Virginia | 54065 | 881 | 11 |
995135 | 995135 | 2021-02-04 | Morgan | Alabama | 1103 | 13143 | 216 |
995372 | 995372 | 2021-02-04 | Morgan | Colorado | 8087 | 2374 | 89 |
995577 | 995577 | 2021-02-04 | Morgan | Georgia | 13211 | 1754 | 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);