ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,786 rows where county = "Morgan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1092504 | 1092504 | 2021-03-06 | Morgan | Alabama | 1103 | 13785 | 255 |
1092741 | 1092741 | 2021-03-06 | Morgan | Colorado | 8087 | 2450 | 90 |
1092946 | 1092946 | 2021-03-06 | Morgan | Georgia | 13211 | 2012 | 19 |
1093121 | 1093121 | 2021-03-06 | Morgan | Illinois | 17137 | 3684 | 99 |
1093210 | 1093210 | 2021-03-06 | Morgan | Indiana | 18109 | 6145 | 133 |
1093541 | 1093541 | 2021-03-06 | Morgan | Kentucky | 21175 | 2040 | 1 |
1094021 | 1094021 | 2021-03-06 | Morgan | Missouri | 29141 | 1632 | 42 |
1094569 | 1094569 | 2021-03-06 | Morgan | Ohio | 39115 | 1021 | 20 |
1095043 | 1095043 | 2021-03-06 | Morgan | Tennessee | 47129 | 2311 | 38 |
1095343 | 1095343 | 2021-03-06 | Morgan | Utah | 49029 | 1132 | 11 |
1095581 | 1095581 | 2021-03-06 | Morgan | West Virginia | 54065 | 938 | 13 |
1089258 | 1089258 | 2021-03-05 | Morgan | Alabama | 1103 | 13770 | 255 |
1089495 | 1089495 | 2021-03-05 | Morgan | Colorado | 8087 | 2446 | 90 |
1089700 | 1089700 | 2021-03-05 | Morgan | Georgia | 13211 | 2009 | 19 |
1089875 | 1089875 | 2021-03-05 | Morgan | Illinois | 17137 | 3684 | 99 |
1089964 | 1089964 | 2021-03-05 | Morgan | Indiana | 18109 | 6134 | 131 |
1090295 | 1090295 | 2021-03-05 | Morgan | Kentucky | 21175 | 2038 | 1 |
1090775 | 1090775 | 2021-03-05 | Morgan | Missouri | 29141 | 1632 | 42 |
1091323 | 1091323 | 2021-03-05 | Morgan | Ohio | 39115 | 1016 | 20 |
1091797 | 1091797 | 2021-03-05 | Morgan | Tennessee | 47129 | 2308 | 38 |
1092097 | 1092097 | 2021-03-05 | Morgan | Utah | 49029 | 1132 | 11 |
1092335 | 1092335 | 2021-03-05 | Morgan | West Virginia | 54065 | 936 | 13 |
1086013 | 1086013 | 2021-03-04 | Morgan | Alabama | 1103 | 13753 | 254 |
1086250 | 1086250 | 2021-03-04 | Morgan | Colorado | 8087 | 2442 | 90 |
1086455 | 1086455 | 2021-03-04 | Morgan | Georgia | 13211 | 2007 | 19 |
1086630 | 1086630 | 2021-03-04 | Morgan | Illinois | 17137 | 3684 | 99 |
1086719 | 1086719 | 2021-03-04 | Morgan | Indiana | 18109 | 6122 | 131 |
1087050 | 1087050 | 2021-03-04 | Morgan | Kentucky | 21175 | 2038 | 1 |
1087530 | 1087530 | 2021-03-04 | Morgan | Missouri | 29141 | 1628 | 42 |
1088078 | 1088078 | 2021-03-04 | Morgan | Ohio | 39115 | 1011 | 19 |
1088551 | 1088551 | 2021-03-04 | Morgan | Tennessee | 47129 | 2303 | 38 |
1088851 | 1088851 | 2021-03-04 | Morgan | Utah | 49029 | 1130 | 11 |
1089089 | 1089089 | 2021-03-04 | Morgan | West Virginia | 54065 | 934 | 13 |
1082767 | 1082767 | 2021-03-03 | Morgan | Alabama | 1103 | 13742 | 252 |
1083004 | 1083004 | 2021-03-03 | Morgan | Colorado | 8087 | 2435 | 90 |
1083209 | 1083209 | 2021-03-03 | Morgan | Georgia | 13211 | 1996 | 18 |
1083384 | 1083384 | 2021-03-03 | Morgan | Illinois | 17137 | 3673 | 99 |
1083473 | 1083473 | 2021-03-03 | Morgan | Indiana | 18109 | 6119 | 130 |
1083804 | 1083804 | 2021-03-03 | Morgan | Kentucky | 21175 | 2038 | 1 |
1084285 | 1084285 | 2021-03-03 | Morgan | Missouri | 29141 | 1626 | 42 |
1084833 | 1084833 | 2021-03-03 | Morgan | Ohio | 39115 | 1011 | 19 |
1085306 | 1085306 | 2021-03-03 | Morgan | Tennessee | 47129 | 2301 | 38 |
1085606 | 1085606 | 2021-03-03 | Morgan | Utah | 49029 | 1130 | 11 |
1085844 | 1085844 | 2021-03-03 | Morgan | West Virginia | 54065 | 934 | 13 |
1079521 | 1079521 | 2021-03-02 | Morgan | Alabama | 1103 | 13693 | 251 |
1079758 | 1079758 | 2021-03-02 | Morgan | Colorado | 8087 | 2433 | 90 |
1079963 | 1079963 | 2021-03-02 | Morgan | Georgia | 13211 | 1990 | 18 |
1080138 | 1080138 | 2021-03-02 | Morgan | Illinois | 17137 | 3673 | 99 |
1080227 | 1080227 | 2021-03-02 | Morgan | Indiana | 18109 | 6112 | 130 |
1080558 | 1080558 | 2021-03-02 | Morgan | Kentucky | 21175 | 2038 | 1 |
1081039 | 1081039 | 2021-03-02 | Morgan | Missouri | 29141 | 1624 | 41 |
1081587 | 1081587 | 2021-03-02 | Morgan | Ohio | 39115 | 1009 | 19 |
1082060 | 1082060 | 2021-03-02 | Morgan | Tennessee | 47129 | 2297 | 38 |
1082360 | 1082360 | 2021-03-02 | Morgan | Utah | 49029 | 1129 | 11 |
1082598 | 1082598 | 2021-03-02 | Morgan | West Virginia | 54065 | 933 | 13 |
1076276 | 1076276 | 2021-03-01 | Morgan | Alabama | 1103 | 13667 | 251 |
1076513 | 1076513 | 2021-03-01 | Morgan | Colorado | 8087 | 2434 | 90 |
1076718 | 1076718 | 2021-03-01 | Morgan | Georgia | 13211 | 1979 | 18 |
1076893 | 1076893 | 2021-03-01 | Morgan | Illinois | 17137 | 3663 | 99 |
1076982 | 1076982 | 2021-03-01 | Morgan | Indiana | 18109 | 6108 | 130 |
1077313 | 1077313 | 2021-03-01 | Morgan | Kentucky | 21175 | 2030 | 1 |
1077793 | 1077793 | 2021-03-01 | Morgan | Missouri | 29141 | 1622 | 40 |
1078341 | 1078341 | 2021-03-01 | Morgan | Ohio | 39115 | 1008 | 34 |
1078814 | 1078814 | 2021-03-01 | Morgan | Tennessee | 47129 | 2295 | 37 |
1079114 | 1079114 | 2021-03-01 | Morgan | Utah | 49029 | 1129 | 11 |
1079352 | 1079352 | 2021-03-01 | Morgan | West Virginia | 54065 | 935 | 13 |
1073030 | 1073030 | 2021-02-28 | Morgan | Alabama | 1103 | 13659 | 251 |
1073267 | 1073267 | 2021-02-28 | Morgan | Colorado | 8087 | 2423 | 90 |
1073472 | 1073472 | 2021-02-28 | Morgan | Georgia | 13211 | 1975 | 18 |
1073647 | 1073647 | 2021-02-28 | Morgan | Illinois | 17137 | 3660 | 98 |
1073736 | 1073736 | 2021-02-28 | Morgan | Indiana | 18109 | 6100 | 130 |
1074067 | 1074067 | 2021-02-28 | Morgan | Kentucky | 21175 | 2024 | 1 |
1074547 | 1074547 | 2021-02-28 | Morgan | Missouri | 29141 | 1622 | 40 |
1075096 | 1075096 | 2021-02-28 | Morgan | Ohio | 39115 | 1005 | 34 |
1075569 | 1075569 | 2021-02-28 | Morgan | Tennessee | 47129 | 2296 | 37 |
1075869 | 1075869 | 2021-02-28 | Morgan | Utah | 49029 | 1128 | 11 |
1076107 | 1076107 | 2021-02-28 | Morgan | West Virginia | 54065 | 935 | 13 |
1069784 | 1069784 | 2021-02-27 | Morgan | Alabama | 1103 | 13641 | 251 |
1070021 | 1070021 | 2021-02-27 | Morgan | Colorado | 8087 | 2422 | 90 |
1070226 | 1070226 | 2021-02-27 | Morgan | Georgia | 13211 | 1974 | 18 |
1070401 | 1070401 | 2021-02-27 | Morgan | Illinois | 17137 | 3660 | 98 |
1070490 | 1070490 | 2021-02-27 | Morgan | Indiana | 18109 | 6091 | 130 |
1070821 | 1070821 | 2021-02-27 | Morgan | Kentucky | 21175 | 2024 | 1 |
1071301 | 1071301 | 2021-02-27 | Morgan | Missouri | 29141 | 1622 | 40 |
1071850 | 1071850 | 2021-02-27 | Morgan | Ohio | 39115 | 1005 | 34 |
1072323 | 1072323 | 2021-02-27 | Morgan | Tennessee | 47129 | 2291 | 37 |
1072623 | 1072623 | 2021-02-27 | Morgan | Utah | 49029 | 1128 | 11 |
1072861 | 1072861 | 2021-02-27 | Morgan | West Virginia | 54065 | 931 | 13 |
1066539 | 1066539 | 2021-02-26 | Morgan | Alabama | 1103 | 13624 | 251 |
1066776 | 1066776 | 2021-02-26 | Morgan | Colorado | 8087 | 2416 | 90 |
1066981 | 1066981 | 2021-02-26 | Morgan | Georgia | 13211 | 1952 | 18 |
1067156 | 1067156 | 2021-02-26 | Morgan | Illinois | 17137 | 3660 | 98 |
1067245 | 1067245 | 2021-02-26 | Morgan | Indiana | 18109 | 6082 | 129 |
1067576 | 1067576 | 2021-02-26 | Morgan | Kentucky | 21175 | 2023 | 1 |
1068056 | 1068056 | 2021-02-26 | Morgan | Missouri | 29141 | 1621 | 40 |
1068604 | 1068604 | 2021-02-26 | Morgan | Ohio | 39115 | 1004 | 34 |
1069077 | 1069077 | 2021-02-26 | Morgan | Tennessee | 47129 | 2290 | 37 |
1069377 | 1069377 | 2021-02-26 | Morgan | Utah | 49029 | 1128 | 11 |
1069615 | 1069615 | 2021-02-26 | Morgan | West Virginia | 54065 | 928 | 13 |
1063294 | 1063294 | 2021-02-25 | Morgan | Alabama | 1103 | 13599 | 249 |
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]);