ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

1,080 rows where county = "Morgan" sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

county

  • Morgan · 1,080
Link rowid date ▲ county state fips cases deaths
291811 2020-07-03 Morgan Alabama 1103 1060 5
292044 2020-07-03 Morgan Colorado 8087 654 46
292248 2020-07-03 Morgan Georgia 13211 64 0
292419 2020-07-03 Morgan Illinois 17137 130 3
292508 2020-07-03 Morgan Indiana 18109 336 35
292829 2020-07-03 Morgan Kentucky 21175 9 0
293307 2020-07-03 Morgan Missouri 29141 15 0
293817 2020-07-03 Morgan Ohio 39115 11 0
294202 2020-07-03 Morgan Tennessee 47129 25 1
294492 2020-07-03 Morgan Utah 49029 24 0
294724 2020-07-03 Morgan West Virginia 54065 20 0
288735 2020-07-02 Morgan Alabama 1103 1032 3
288967 2020-07-02 Morgan Colorado 8087 654 46
289171 2020-07-02 Morgan Georgia 13211 54 0
289341 2020-07-02 Morgan Illinois 17137 129 3
289429 2020-07-02 Morgan Indiana 18109 333 34
289750 2020-07-02 Morgan Kentucky 21175 8 0
290228 2020-07-02 Morgan Missouri 29141 14 0
290736 2020-07-02 Morgan Ohio 39115 9 0
291121 2020-07-02 Morgan Tennessee 47129 24 1
291409 2020-07-02 Morgan Utah 49029 23 0
291641 2020-07-02 Morgan West Virginia 54065 20 0
285661 2020-07-01 Morgan Alabama 1103 993 3
285892 2020-07-01 Morgan Colorado 8087 653 46
286096 2020-07-01 Morgan Georgia 13211 52 0
286266 2020-07-01 Morgan Illinois 17137 128 3
286354 2020-07-01 Morgan Indiana 18109 330 34
286675 2020-07-01 Morgan Kentucky 21175 8 0
287153 2020-07-01 Morgan Missouri 29141 14 0
287660 2020-07-01 Morgan Ohio 39115 9 0
288044 2020-07-01 Morgan Tennessee 47129 24 1
288333 2020-07-01 Morgan Utah 49029 22 0
288565 2020-07-01 Morgan West Virginia 54065 20 0
282588 2020-06-30 Morgan Alabama 1103 966 3
282819 2020-06-30 Morgan Colorado 8087 652 46
283023 2020-06-30 Morgan Georgia 13211 52 0
283194 2020-06-30 Morgan Illinois 17137 128 3
283282 2020-06-30 Morgan Indiana 18109 328 34
283604 2020-06-30 Morgan Kentucky 21175 8 0
284081 2020-06-30 Morgan Missouri 29141 14 0
284587 2020-06-30 Morgan Ohio 39115 9 0
284971 2020-06-30 Morgan Tennessee 47129 24 1
285259 2020-06-30 Morgan Utah 49029 22 0
285491 2020-06-30 Morgan West Virginia 54065 20 0
279519 2020-06-29 Morgan Alabama 1103 948 3
279750 2020-06-29 Morgan Colorado 8087 652 46
279954 2020-06-29 Morgan Georgia 13211 49 0
280122 2020-06-29 Morgan Illinois 17137 127 3
280210 2020-06-29 Morgan Indiana 18109 326 34
280532 2020-06-29 Morgan Kentucky 21175 8 0
281008 2020-06-29 Morgan Missouri 29141 13 0
281514 2020-06-29 Morgan Ohio 39115 7 0
281897 2020-06-29 Morgan Tennessee 47129 23 1
282186 2020-06-29 Morgan Utah 49029 19 0
282418 2020-06-29 Morgan West Virginia 54065 20 0
276451 2020-06-28 Morgan Alabama 1103 925 3
276682 2020-06-28 Morgan Colorado 8087 652 46
276886 2020-06-28 Morgan Georgia 13211 49 0
277055 2020-06-28 Morgan Illinois 17137 126 3
277143 2020-06-28 Morgan Indiana 18109 324 34
277463 2020-06-28 Morgan Kentucky 21175 8 0
277940 2020-06-28 Morgan Missouri 29141 13 0
278446 2020-06-28 Morgan Ohio 39115 7 0
278829 2020-06-28 Morgan Tennessee 47129 23 1
279117 2020-06-28 Morgan Utah 49029 18 0
279349 2020-06-28 Morgan West Virginia 54065 20 0
273382 2020-06-27 Morgan Alabama 1103 916 3
273613 2020-06-27 Morgan Colorado 8087 651 46
273817 2020-06-27 Morgan Georgia 13211 46 0
273985 2020-06-27 Morgan Illinois 17137 126 3
274073 2020-06-27 Morgan Indiana 18109 323 34
274393 2020-06-27 Morgan Kentucky 21175 8 0
274870 2020-06-27 Morgan Missouri 29141 13 0
275378 2020-06-27 Morgan Ohio 39115 7 0
275761 2020-06-27 Morgan Tennessee 47129 23 1
276049 2020-06-27 Morgan Utah 49029 18 0
276281 2020-06-27 Morgan West Virginia 54065 20 0
270313 2020-06-26 Morgan Alabama 1103 895 3
270544 2020-06-26 Morgan Colorado 8087 650 46
270748 2020-06-26 Morgan Georgia 13211 46 0
270916 2020-06-26 Morgan Illinois 17137 124 3
271004 2020-06-26 Morgan Indiana 18109 319 34
271324 2020-06-26 Morgan Kentucky 21175 8 0
271801 2020-06-26 Morgan Missouri 29141 13 0
272309 2020-06-26 Morgan Ohio 39115 7 0
272692 2020-06-26 Morgan Tennessee 47129 23 1
272980 2020-06-26 Morgan Utah 49029 18 0
273212 2020-06-26 Morgan West Virginia 54065 20 0
267252 2020-06-25 Morgan Alabama 1103 866 2
267483 2020-06-25 Morgan Colorado 8087 649 46
267687 2020-06-25 Morgan Georgia 13211 46 0
267853 2020-06-25 Morgan Illinois 17137 123 3
267941 2020-06-25 Morgan Indiana 18109 318 33
268260 2020-06-25 Morgan Kentucky 21175 8 0
268737 2020-06-25 Morgan Missouri 29141 13 0
269241 2020-06-25 Morgan Ohio 39115 6 0
269624 2020-06-25 Morgan Tennessee 47129 22 1
269911 2020-06-25 Morgan Utah 49029 17 0
270143 2020-06-25 Morgan West Virginia 54065 20 0
264197 2020-06-24 Morgan Alabama 1103 825 2

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 928.106ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette