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 |
---|---|---|---|---|---|---|---|
1193160 | 1193160 | 2021-04-06 | Morgan | Alabama | 1103 | 14142 | 267 |
1193397 | 1193397 | 2021-04-06 | Morgan | Colorado | 8087 | 2545 | 92 |
1193602 | 1193602 | 2021-04-06 | Morgan | Georgia | 13211 | 2188 | 28 |
1193777 | 1193777 | 2021-04-06 | Morgan | Illinois | 17137 | 3793 | 101 |
1193866 | 1193866 | 2021-04-06 | Morgan | Indiana | 18109 | 6330 | 139 |
1194197 | 1194197 | 2021-04-06 | Morgan | Kentucky | 21175 | 2130 | 3 |
1194677 | 1194677 | 2021-04-06 | Morgan | Missouri | 29141 | 1707 | 42 |
1195226 | 1195226 | 2021-04-06 | Morgan | Ohio | 39115 | 1047 | 22 |
1195700 | 1195700 | 2021-04-06 | Morgan | Tennessee | 47129 | 2414 | 39 |
1196000 | 1196000 | 2021-04-06 | Morgan | Utah | 49029 | 1205 | 11 |
1196239 | 1196239 | 2021-04-06 | Morgan | West Virginia | 54065 | 1041 | 16 |
1189910 | 1189910 | 2021-04-05 | Morgan | Alabama | 1103 | 14144 | 266 |
1190147 | 1190147 | 2021-04-05 | Morgan | Colorado | 8087 | 2543 | 92 |
1190352 | 1190352 | 2021-04-05 | Morgan | Georgia | 13211 | 2188 | 28 |
1190527 | 1190527 | 2021-04-05 | Morgan | Illinois | 17137 | 3776 | 101 |
1190616 | 1190616 | 2021-04-05 | Morgan | Indiana | 18109 | 6327 | 139 |
1190947 | 1190947 | 2021-04-05 | Morgan | Kentucky | 21175 | 2132 | 3 |
1191428 | 1191428 | 2021-04-05 | Morgan | Missouri | 29141 | 1707 | 42 |
1191978 | 1191978 | 2021-04-05 | Morgan | Ohio | 39115 | 1043 | 22 |
1192452 | 1192452 | 2021-04-05 | Morgan | Tennessee | 47129 | 2409 | 39 |
1192752 | 1192752 | 2021-04-05 | Morgan | Utah | 49029 | 1203 | 11 |
1192991 | 1192991 | 2021-04-05 | Morgan | West Virginia | 54065 | 1040 | 16 |
1186663 | 1186663 | 2021-04-04 | Morgan | Alabama | 1103 | 14144 | 266 |
1186900 | 1186900 | 2021-04-04 | Morgan | Colorado | 8087 | 2542 | 92 |
1187105 | 1187105 | 2021-04-04 | Morgan | Georgia | 13211 | 2185 | 28 |
1187280 | 1187280 | 2021-04-04 | Morgan | Illinois | 17137 | 3776 | 101 |
1187369 | 1187369 | 2021-04-04 | Morgan | Indiana | 18109 | 6323 | 139 |
1187700 | 1187700 | 2021-04-04 | Morgan | Kentucky | 21175 | 2129 | 3 |
1188180 | 1188180 | 2021-04-04 | Morgan | Missouri | 29141 | 1707 | 42 |
1188729 | 1188729 | 2021-04-04 | Morgan | Ohio | 39115 | 1040 | 22 |
1189203 | 1189203 | 2021-04-04 | Morgan | Tennessee | 47129 | 2399 | 39 |
1189503 | 1189503 | 2021-04-04 | Morgan | Utah | 49029 | 1194 | 11 |
1189741 | 1189741 | 2021-04-04 | Morgan | West Virginia | 54065 | 1040 | 16 |
1183416 | 1183416 | 2021-04-03 | Morgan | Alabama | 1103 | 14139 | 266 |
1183653 | 1183653 | 2021-04-03 | Morgan | Colorado | 8087 | 2542 | 92 |
1183858 | 1183858 | 2021-04-03 | Morgan | Georgia | 13211 | 2184 | 28 |
1184033 | 1184033 | 2021-04-03 | Morgan | Illinois | 17137 | 3776 | 101 |
1184122 | 1184122 | 2021-04-03 | Morgan | Indiana | 18109 | 6318 | 139 |
1184453 | 1184453 | 2021-04-03 | Morgan | Kentucky | 21175 | 2129 | 3 |
1184933 | 1184933 | 2021-04-03 | Morgan | Missouri | 29141 | 1707 | 42 |
1185482 | 1185482 | 2021-04-03 | Morgan | Ohio | 39115 | 1040 | 22 |
1185956 | 1185956 | 2021-04-03 | Morgan | Tennessee | 47129 | 2399 | 39 |
1186256 | 1186256 | 2021-04-03 | Morgan | Utah | 49029 | 1194 | 11 |
1186494 | 1186494 | 2021-04-03 | Morgan | West Virginia | 54065 | 1034 | 16 |
1180169 | 1180169 | 2021-04-02 | Morgan | Alabama | 1103 | 14139 | 265 |
1180406 | 1180406 | 2021-04-02 | Morgan | Colorado | 8087 | 2541 | 92 |
1180611 | 1180611 | 2021-04-02 | Morgan | Georgia | 13211 | 2184 | 28 |
1180786 | 1180786 | 2021-04-02 | Morgan | Illinois | 17137 | 3776 | 101 |
1180875 | 1180875 | 2021-04-02 | Morgan | Indiana | 18109 | 6311 | 139 |
1181206 | 1181206 | 2021-04-02 | Morgan | Kentucky | 21175 | 2119 | 3 |
1181687 | 1181687 | 2021-04-02 | Morgan | Missouri | 29141 | 1707 | 42 |
1182235 | 1182235 | 2021-04-02 | Morgan | Ohio | 39115 | 1040 | 22 |
1182709 | 1182709 | 2021-04-02 | Morgan | Tennessee | 47129 | 2399 | 39 |
1183009 | 1183009 | 2021-04-02 | Morgan | Utah | 49029 | 1194 | 11 |
1183247 | 1183247 | 2021-04-02 | Morgan | West Virginia | 54065 | 1029 | 16 |
1176922 | 1176922 | 2021-04-01 | Morgan | Alabama | 1103 | 14138 | 263 |
1177159 | 1177159 | 2021-04-01 | Morgan | Colorado | 8087 | 2540 | 92 |
1177364 | 1177364 | 2021-04-01 | Morgan | Georgia | 13211 | 2180 | 28 |
1177539 | 1177539 | 2021-04-01 | Morgan | Illinois | 17137 | 3776 | 101 |
1177628 | 1177628 | 2021-04-01 | Morgan | Indiana | 18109 | 6302 | 139 |
1177959 | 1177959 | 2021-04-01 | Morgan | Kentucky | 21175 | 2117 | 3 |
1178440 | 1178440 | 2021-04-01 | Morgan | Missouri | 29141 | 1707 | 42 |
1178988 | 1178988 | 2021-04-01 | Morgan | Ohio | 39115 | 1041 | 22 |
1179462 | 1179462 | 2021-04-01 | Morgan | Tennessee | 47129 | 2399 | 39 |
1179762 | 1179762 | 2021-04-01 | Morgan | Utah | 49029 | 1192 | 11 |
1180000 | 1180000 | 2021-04-01 | Morgan | West Virginia | 54065 | 1019 | 16 |
1173675 | 1173675 | 2021-03-31 | Morgan | Alabama | 1103 | 14131 | 263 |
1173912 | 1173912 | 2021-03-31 | Morgan | Colorado | 8087 | 2535 | 92 |
1174117 | 1174117 | 2021-03-31 | Morgan | Georgia | 13211 | 2170 | 28 |
1174292 | 1174292 | 2021-03-31 | Morgan | Illinois | 17137 | 3776 | 101 |
1174381 | 1174381 | 2021-03-31 | Morgan | Indiana | 18109 | 6295 | 139 |
1174712 | 1174712 | 2021-03-31 | Morgan | Kentucky | 21175 | 2108 | 3 |
1175193 | 1175193 | 2021-03-31 | Morgan | Missouri | 29141 | 1707 | 42 |
1175741 | 1175741 | 2021-03-31 | Morgan | Ohio | 39115 | 1041 | 22 |
1176215 | 1176215 | 2021-03-31 | Morgan | Tennessee | 47129 | 2393 | 39 |
1176515 | 1176515 | 2021-03-31 | Morgan | Utah | 49029 | 1189 | 11 |
1176753 | 1176753 | 2021-03-31 | Morgan | West Virginia | 54065 | 1017 | 16 |
1170428 | 1170428 | 2021-03-30 | Morgan | Alabama | 1103 | 14120 | 263 |
1170665 | 1170665 | 2021-03-30 | Morgan | Colorado | 8087 | 2531 | 92 |
1170870 | 1170870 | 2021-03-30 | Morgan | Georgia | 13211 | 2152 | 28 |
1171045 | 1171045 | 2021-03-30 | Morgan | Illinois | 17137 | 3773 | 101 |
1171134 | 1171134 | 2021-03-30 | Morgan | Indiana | 18109 | 6285 | 139 |
1171465 | 1171465 | 2021-03-30 | Morgan | Kentucky | 21175 | 2101 | 3 |
1171946 | 1171946 | 2021-03-30 | Morgan | Missouri | 29141 | 1707 | 42 |
1172494 | 1172494 | 2021-03-30 | Morgan | Ohio | 39115 | 1042 | 22 |
1172968 | 1172968 | 2021-03-30 | Morgan | Tennessee | 47129 | 2389 | 39 |
1173268 | 1173268 | 2021-03-30 | Morgan | Utah | 49029 | 1185 | 11 |
1173506 | 1173506 | 2021-03-30 | Morgan | West Virginia | 54065 | 1007 | 16 |
1167180 | 1167180 | 2021-03-29 | Morgan | Alabama | 1103 | 14116 | 263 |
1167417 | 1167417 | 2021-03-29 | Morgan | Colorado | 8087 | 2529 | 92 |
1167622 | 1167622 | 2021-03-29 | Morgan | Georgia | 13211 | 2149 | 28 |
1167797 | 1167797 | 2021-03-29 | Morgan | Illinois | 17137 | 3768 | 101 |
1167886 | 1167886 | 2021-03-29 | Morgan | Indiana | 18109 | 6279 | 140 |
1168217 | 1168217 | 2021-03-29 | Morgan | Kentucky | 21175 | 2101 | 3 |
1168698 | 1168698 | 2021-03-29 | Morgan | Missouri | 29141 | 1707 | 42 |
1169247 | 1169247 | 2021-03-29 | Morgan | Ohio | 39115 | 1040 | 22 |
1169721 | 1169721 | 2021-03-29 | Morgan | Tennessee | 47129 | 2385 | 39 |
1170021 | 1170021 | 2021-03-29 | Morgan | Utah | 49029 | 1180 | 11 |
1170259 | 1170259 | 2021-03-29 | Morgan | West Virginia | 54065 | 1005 | 16 |
1163932 | 1163932 | 2021-03-28 | Morgan | Alabama | 1103 | 14114 | 263 |
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);