ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,366 rows where county = "Johnson" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1791470 | 1791470 | 2021-10-07 | Johnson | Iowa | 19103 | 17624 | 98 |
1791564 | 1791564 | 2021-10-07 | Johnson | Kansas | 20091 | 75656 | 907 |
1791681 | 1791681 | 2021-10-07 | Johnson | Kentucky | 21115 | 3587 | 45 |
1792169 | 1792169 | 2021-10-07 | Johnson | Missouri | 29101 | 6929 | 70 |
1792340 | 1792340 | 2021-10-07 | Johnson | Nebraska | 31097 | 686 | 10 |
1793195 | 1793195 | 2021-10-07 | Johnson | Tennessee | 47091 | 3416 | 45 |
1793371 | 1793371 | 2021-10-07 | Johnson | Texas | 48251 | 26967 | 497 |
1793856 | 1793856 | 2021-10-07 | Johnson | Wyoming | 56019 | 1113 | 15 |
1787519 | 1787519 | 2021-10-06 | Johnson | Arkansas | 5071 | 4478 | 56 |
1787846 | 1787846 | 2021-10-06 | Johnson | Georgia | 13167 | 1532 | 58 |
1788018 | 1788018 | 2021-10-06 | Johnson | Illinois | 17087 | 2214 | 36 |
1788118 | 1788118 | 2021-10-06 | Johnson | Indiana | 18081 | 24471 | 451 |
1788221 | 1788221 | 2021-10-06 | Johnson | Iowa | 19103 | 17624 | 98 |
1788315 | 1788315 | 2021-10-06 | Johnson | Kansas | 20091 | 75656 | 907 |
1788432 | 1788432 | 2021-10-06 | Johnson | Kentucky | 21115 | 3577 | 45 |
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);