ny_times_us_counties

Table actions
⚠️ 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

6,239 rows where county = "Morgan" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

county

  • Morgan · 6,239 ✖
Link rowid date ▲ county state fips cases deaths
1816665 1816665 2021-10-15 Morgan Alabama 1103 20620 370
1816903 1816903 2021-10-15 Morgan Colorado 8087 3264 98
1817108 1817108 2021-10-15 Morgan Georgia 13211 3255 40
1817284 1817284 2021-10-15 Morgan Illinois 17137 5197 121
1817373 1817373 2021-10-15 Morgan Indiana 18109 9380 184
1817703 1817703 2021-10-15 Morgan Kentucky 21175 2822 6
1818184 1818184 2021-10-15 Morgan Missouri 29141 2597 57
1818733 1818733 2021-10-15 Morgan Ohio 39115 1881 32
1819207 1819207 2021-10-15 Morgan Tennessee 47129 3748 46
1819507 1819507 2021-10-15 Morgan Utah 49029 1737 11
1819745 1819745 2021-10-15 Morgan West Virginia 54065 2003 40
1813417 1813417 2021-10-14 Morgan Alabama 1103 20584 368
1813655 1813655 2021-10-14 Morgan Colorado 8087 3255 98
1813860 1813860 2021-10-14 Morgan Georgia 13211 3247 40
1814036 1814036 2021-10-14 Morgan Illinois 17137 5197 121
1814125 1814125 2021-10-14 Morgan Indiana 18109 9365 184
1814455 1814455 2021-10-14 Morgan Kentucky 21175 2819 6
1814935 1814935 2021-10-14 Morgan Missouri 29141 2595 57
1815484 1815484 2021-10-14 Morgan Ohio 39115 1875 32
1815958 1815958 2021-10-14 Morgan Tennessee 47129 3736 46
1816258 1816258 2021-10-14 Morgan Utah 49029 1728 11
1816496 1816496 2021-10-14 Morgan West Virginia 54065 1990 40
1810168 1810168 2021-10-13 Morgan Alabama 1103 20555 363
1810406 1810406 2021-10-13 Morgan Colorado 8087 3244 98
1810611 1810611 2021-10-13 Morgan Georgia 13211 3237 40
1810787 1810787 2021-10-13 Morgan Illinois 17137 5188 120
1810876 1810876 2021-10-13 Morgan Indiana 18109 9349 182
1811206 1811206 2021-10-13 Morgan Kentucky 21175 2817 6
1811687 1811687 2021-10-13 Morgan Missouri 29141 2585 57
1812236 1812236 2021-10-13 Morgan Ohio 39115 1863 32
1812710 1812710 2021-10-13 Morgan Tennessee 47129 3732 46
1813010 1813010 2021-10-13 Morgan Utah 49029 1720 11
1813248 1813248 2021-10-13 Morgan West Virginia 54065 1973 40
1806919 1806919 2021-10-12 Morgan Alabama 1103 20519 361
1807157 1807157 2021-10-12 Morgan Colorado 8087 3228 98
1807362 1807362 2021-10-12 Morgan Georgia 13211 3233 40
1807538 1807538 2021-10-12 Morgan Illinois 17137 5173 120
1807627 1807627 2021-10-12 Morgan Indiana 18109 9318 181
1807957 1807957 2021-10-12 Morgan Kentucky 21175 2810 6
1808438 1808438 2021-10-12 Morgan Missouri 29141 2583 57
1808987 1808987 2021-10-12 Morgan Ohio 39115 1852 32
1809461 1809461 2021-10-12 Morgan Tennessee 47129 3725 46
1809761 1809761 2021-10-12 Morgan Utah 49029 1711 11
1809999 1809999 2021-10-12 Morgan West Virginia 54065 1964 40
1803668 1803668 2021-10-11 Morgan Alabama 1103 20500 361
1803906 1803906 2021-10-11 Morgan Colorado 8087 3220 98
1804111 1804111 2021-10-11 Morgan Georgia 13211 3195 40
1804287 1804287 2021-10-11 Morgan Illinois 17137 5148 120
1804376 1804376 2021-10-11 Morgan Indiana 18109 9296 181
1804706 1804706 2021-10-11 Morgan Kentucky 21175 2805 6
1805187 1805187 2021-10-11 Morgan Missouri 29141 2583 57
1805737 1805737 2021-10-11 Morgan Ohio 39115 1844 31
1806211 1806211 2021-10-11 Morgan Tennessee 47129 3710 46
1806511 1806511 2021-10-11 Morgan Utah 49029 1676 11
1806750 1806750 2021-10-11 Morgan West Virginia 54065 1963 40
1800419 1800419 2021-10-10 Morgan Alabama 1103 20482 361
1800657 1800657 2021-10-10 Morgan Colorado 8087 3180 97
1800862 1800862 2021-10-10 Morgan Georgia 13211 3195 40
1801038 1801038 2021-10-10 Morgan Illinois 17137 5148 120
1801127 1801127 2021-10-10 Morgan Indiana 18109 9261 180
1801457 1801457 2021-10-10 Morgan Kentucky 21175 2801 6
1801938 1801938 2021-10-10 Morgan Missouri 29141 2583 57
1802487 1802487 2021-10-10 Morgan Ohio 39115 1841 31
1802961 1802961 2021-10-10 Morgan Tennessee 47129 3680 46
1803261 1803261 2021-10-10 Morgan Utah 49029 1676 11
1803499 1803499 2021-10-10 Morgan West Virginia 54065 1952 39
1797170 1797170 2021-10-09 Morgan Alabama 1103 20463 361
1797408 1797408 2021-10-09 Morgan Colorado 8087 3180 97
1797613 1797613 2021-10-09 Morgan Georgia 13211 3195 40
1797789 1797789 2021-10-09 Morgan Illinois 17137 5148 120
1797878 1797878 2021-10-09 Morgan Indiana 18109 9261 180
1798208 1798208 2021-10-09 Morgan Kentucky 21175 2801 6
1798689 1798689 2021-10-09 Morgan Missouri 29141 2582 57
1799238 1799238 2021-10-09 Morgan Ohio 39115 1822 31
1799712 1799712 2021-10-09 Morgan Tennessee 47129 3680 46
1800012 1800012 2021-10-09 Morgan Utah 49029 1676 11
1800250 1800250 2021-10-09 Morgan West Virginia 54065 1946 39
1793921 1793921 2021-10-08 Morgan Alabama 1103 20427 355
1794159 1794159 2021-10-08 Morgan Colorado 8087 3180 97
1794364 1794364 2021-10-08 Morgan Georgia 13211 3195 40
1794540 1794540 2021-10-08 Morgan Illinois 17137 5148 120
1794629 1794629 2021-10-08 Morgan Indiana 18109 9261 180
1794959 1794959 2021-10-08 Morgan Kentucky 21175 2801 6
1795440 1795440 2021-10-08 Morgan Missouri 29141 2581 57
1795989 1795989 2021-10-08 Morgan Ohio 39115 1822 31
1796463 1796463 2021-10-08 Morgan Tennessee 47129 3680 46
1796763 1796763 2021-10-08 Morgan Utah 49029 1676 11
1797001 1797001 2021-10-08 Morgan West Virginia 54065 1930 39
1790672 1790672 2021-10-07 Morgan Alabama 1103 20385 352
1790911 1790911 2021-10-07 Morgan Colorado 8087 3171 97
1791116 1791116 2021-10-07 Morgan Georgia 13211 3191 39
1791292 1791292 2021-10-07 Morgan Illinois 17137 5140 119
1791381 1791381 2021-10-07 Morgan Indiana 18109 9232 180
1791711 1791711 2021-10-07 Morgan Kentucky 21175 2794 6
1792191 1792191 2021-10-07 Morgan Missouri 29141 2573 57
1792740 1792740 2021-10-07 Morgan Ohio 39115 1811 30
1793214 1793214 2021-10-07 Morgan Tennessee 47129 3668 46
1793514 1793514 2021-10-07 Morgan Utah 49029 1667 11
1793752 1793752 2021-10-07 Morgan West Virginia 54065 1909 39
1787424 1787424 2021-10-06 Morgan Alabama 1103 20341 350

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
);
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);