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,846 rows where county = "Johnson" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

county

  • Johnson · 6,846 ✖
Link rowid date ▲ county state fips cases deaths
1816760 1816760 2021-10-15 Johnson Arkansas 5071 4552 55
1817087 1817087 2021-10-15 Johnson Georgia 13167 1543 60
1817259 1817259 2021-10-15 Johnson Illinois 17087 2238 37
1817359 1817359 2021-10-15 Johnson Indiana 18081 24894 459
1817462 1817462 2021-10-15 Johnson Iowa 19103 17809 100
1817556 1817556 2021-10-15 Johnson Kansas 20091 76717 912
1817673 1817673 2021-10-15 Johnson Kentucky 21115 3646 46
1818162 1818162 2021-10-15 Johnson Missouri 29101 7035 72
1818333 1818333 2021-10-15 Johnson Nebraska 31097 690 10
1819188 1819188 2021-10-15 Johnson Tennessee 47091 3489 47
1819364 1819364 2021-10-15 Johnson Texas 48251 27668 519
1819849 1819849 2021-10-15 Johnson Wyoming 56019 1139 15
1813512 1813512 2021-10-14 Johnson Arkansas 5071 4543 55
1813839 1813839 2021-10-14 Johnson Georgia 13167 1542 60
1814011 1814011 2021-10-14 Johnson Illinois 17087 2235 37
1814111 1814111 2021-10-14 Johnson Indiana 18081 24852 460
1814214 1814214 2021-10-14 Johnson Iowa 19103 17809 100
1814308 1814308 2021-10-14 Johnson Kansas 20091 76453 911
1814425 1814425 2021-10-14 Johnson Kentucky 21115 3641 46
1814913 1814913 2021-10-14 Johnson Missouri 29101 6979 72
1815084 1815084 2021-10-14 Johnson Nebraska 31097 688 10
1815939 1815939 2021-10-14 Johnson Tennessee 47091 3484 47
1816115 1816115 2021-10-14 Johnson Texas 48251 27560 517
1816600 1816600 2021-10-14 Johnson Wyoming 56019 1136 15
1810263 1810263 2021-10-13 Johnson Arkansas 5071 4535 55
1810590 1810590 2021-10-13 Johnson Georgia 13167 1540 59
1810762 1810762 2021-10-13 Johnson Illinois 17087 2232 37
1810862 1810862 2021-10-13 Johnson Indiana 18081 24775 457
1810965 1810965 2021-10-13 Johnson Iowa 19103 17809 100
1811059 1811059 2021-10-13 Johnson Kansas 20091 76453 911
1811176 1811176 2021-10-13 Johnson Kentucky 21115 3628 46
1811665 1811665 2021-10-13 Johnson Missouri 29101 6970 72
1811836 1811836 2021-10-13 Johnson Nebraska 31097 687 10
1812691 1812691 2021-10-13 Johnson Tennessee 47091 3473 46
1812867 1812867 2021-10-13 Johnson Texas 48251 27440 516
1813352 1813352 2021-10-13 Johnson Wyoming 56019 1135 15
1807014 1807014 2021-10-12 Johnson Arkansas 5071 4526 55
1807341 1807341 2021-10-12 Johnson Georgia 13167 1536 58
1807513 1807513 2021-10-12 Johnson Illinois 17087 2231 37
1807613 1807613 2021-10-12 Johnson Indiana 18081 24730 456
1807716 1807716 2021-10-12 Johnson Iowa 19103 17624 98
1807810 1807810 2021-10-12 Johnson Kansas 20091 76202 911
1807927 1807927 2021-10-12 Johnson Kentucky 21115 3621 46
1808416 1808416 2021-10-12 Johnson Missouri 29101 6964 70
1808587 1808587 2021-10-12 Johnson Nebraska 31097 687 10
1809442 1809442 2021-10-12 Johnson Tennessee 47091 3472 46
1809618 1809618 2021-10-12 Johnson Texas 48251 27361 510
1810103 1810103 2021-10-12 Johnson Wyoming 56019 1128 15
1803763 1803763 2021-10-11 Johnson Arkansas 5071 4520 55
1804090 1804090 2021-10-11 Johnson Georgia 13167 1535 58
1804262 1804262 2021-10-11 Johnson Illinois 17087 2226 37
1804362 1804362 2021-10-11 Johnson Indiana 18081 24698 455
1804465 1804465 2021-10-11 Johnson Iowa 19103 17624 98
1804559 1804559 2021-10-11 Johnson Kansas 20091 76202 911
1804676 1804676 2021-10-11 Johnson Kentucky 21115 3615 46
1805165 1805165 2021-10-11 Johnson Missouri 29101 6953 70
1805336 1805336 2021-10-11 Johnson Nebraska 31097 686 10
1806192 1806192 2021-10-11 Johnson Tennessee 47091 3452 45
1806368 1806368 2021-10-11 Johnson Texas 48251 27123 506
1806854 1806854 2021-10-11 Johnson Wyoming 56019 1123 15
1800514 1800514 2021-10-10 Johnson Arkansas 5071 4520 55
1800841 1800841 2021-10-10 Johnson Georgia 13167 1535 58
1801013 1801013 2021-10-10 Johnson Illinois 17087 2226 37
1801113 1801113 2021-10-10 Johnson Indiana 18081 24603 451
1801216 1801216 2021-10-10 Johnson Iowa 19103 17624 98
1801310 1801310 2021-10-10 Johnson Kansas 20091 75942 907
1801427 1801427 2021-10-10 Johnson Kentucky 21115 3603 45
1801916 1801916 2021-10-10 Johnson Missouri 29101 6950 70
1802087 1802087 2021-10-10 Johnson Nebraska 31097 686 10
1802942 1802942 2021-10-10 Johnson Tennessee 47091 3430 45
1803118 1803118 2021-10-10 Johnson Texas 48251 27123 506
1803603 1803603 2021-10-10 Johnson Wyoming 56019 1119 15
1797265 1797265 2021-10-09 Johnson Arkansas 5071 4513 57
1797592 1797592 2021-10-09 Johnson Georgia 13167 1535 58
1797764 1797764 2021-10-09 Johnson Illinois 17087 2226 37
1797864 1797864 2021-10-09 Johnson Indiana 18081 24603 451
1797967 1797967 2021-10-09 Johnson Iowa 19103 17624 98
1798061 1798061 2021-10-09 Johnson Kansas 20091 75942 907
1798178 1798178 2021-10-09 Johnson Kentucky 21115 3603 45
1798667 1798667 2021-10-09 Johnson Missouri 29101 6942 70
1798838 1798838 2021-10-09 Johnson Nebraska 31097 686 10
1799693 1799693 2021-10-09 Johnson Tennessee 47091 3430 45
1799869 1799869 2021-10-09 Johnson Texas 48251 27123 506
1800354 1800354 2021-10-09 Johnson Wyoming 56019 1119 15
1794016 1794016 2021-10-08 Johnson Arkansas 5071 4502 57
1794343 1794343 2021-10-08 Johnson Georgia 13167 1535 58
1794515 1794515 2021-10-08 Johnson Illinois 17087 2226 37
1794615 1794615 2021-10-08 Johnson Indiana 18081 24603 451
1794718 1794718 2021-10-08 Johnson Iowa 19103 17624 98
1794812 1794812 2021-10-08 Johnson Kansas 20091 75942 907
1794929 1794929 2021-10-08 Johnson Kentucky 21115 3603 45
1795418 1795418 2021-10-08 Johnson Missouri 29101 6935 70
1795589 1795589 2021-10-08 Johnson Nebraska 31097 686 10
1796444 1796444 2021-10-08 Johnson Tennessee 47091 3430 45
1796620 1796620 2021-10-08 Johnson Texas 48251 27038 501
1797105 1797105 2021-10-08 Johnson Wyoming 56019 1119 15
1790768 1790768 2021-10-07 Johnson Arkansas 5071 4492 56
1791095 1791095 2021-10-07 Johnson Georgia 13167 1533 58
1791267 1791267 2021-10-07 Johnson Illinois 17087 2217 36
1791367 1791367 2021-10-07 Johnson Indiana 18081 24517 451

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