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 |
---|---|---|---|---|---|---|---|
1766346 | 1766346 | 2021-09-29 | Johnson | Nebraska | 31097 | 679 | 10 |
1767201 | 1767201 | 2021-09-29 | Johnson | Tennessee | 47091 | 3347 | 45 |
1767377 | 1767377 | 2021-09-29 | Johnson | Texas | 48251 | 26262 | 471 |
1767862 | 1767862 | 2021-09-29 | Johnson | Wyoming | 56019 | 1066 | 13 |
1761524 | 1761524 | 2021-09-28 | Johnson | Arkansas | 5071 | 4406 | 56 |
1761851 | 1761851 | 2021-09-28 | Johnson | Georgia | 13167 | 1519 | 56 |
1762023 | 1762023 | 2021-09-28 | Johnson | Illinois | 17087 | 2171 | 31 |
1762123 | 1762123 | 2021-09-28 | Johnson | Indiana | 18081 | 24005 | 441 |
1762226 | 1762226 | 2021-09-28 | Johnson | Iowa | 19103 | 17004 | 92 |
1762320 | 1762320 | 2021-09-28 | Johnson | Kansas | 20091 | 74468 | 888 |
1762437 | 1762437 | 2021-09-28 | Johnson | Kentucky | 21115 | 3507 | 43 |
1762926 | 1762926 | 2021-09-28 | Johnson | Missouri | 29101 | 6767 | 69 |
1763097 | 1763097 | 2021-09-28 | Johnson | Nebraska | 31097 | 678 | 10 |
1763952 | 1763952 | 2021-09-28 | Johnson | Tennessee | 47091 | 3339 | 45 |
1764128 | 1764128 | 2021-09-28 | Johnson | Texas | 48251 | 26169 | 465 |
1764613 | 1764613 | 2021-09-28 | Johnson | Wyoming | 56019 | 1065 | 13 |
1758276 | 1758276 | 2021-09-27 | Johnson | Arkansas | 5071 | 4398 | 56 |
1758603 | 1758603 | 2021-09-27 | Johnson | Georgia | 13167 | 1516 | 56 |
1758775 | 1758775 | 2021-09-27 | Johnson | Illinois | 17087 | 2159 | 31 |
1758875 | 1758875 | 2021-09-27 | Johnson | Indiana | 18081 | 23932 | 439 |
1758978 | 1758978 | 2021-09-27 | Johnson | Iowa | 19103 | 17004 | 92 |
1759072 | 1759072 | 2021-09-27 | Johnson | Kansas | 20091 | 74468 | 888 |
1759189 | 1759189 | 2021-09-27 | Johnson | Kentucky | 21115 | 3495 | 43 |
1759677 | 1759677 | 2021-09-27 | Johnson | Missouri | 29101 | 6749 | 68 |
1759848 | 1759848 | 2021-09-27 | Johnson | Nebraska | 31097 | 677 | 10 |
1760703 | 1760703 | 2021-09-27 | Johnson | Tennessee | 47091 | 3317 | 45 |
1760879 | 1760879 | 2021-09-27 | Johnson | Texas | 48251 | 25947 | 463 |
1761364 | 1761364 | 2021-09-27 | Johnson | Wyoming | 56019 | 1061 | 13 |
1755028 | 1755028 | 2021-09-26 | Johnson | Arkansas | 5071 | 4396 | 56 |
1755355 | 1755355 | 2021-09-26 | Johnson | Georgia | 13167 | 1512 | 55 |
1755527 | 1755527 | 2021-09-26 | Johnson | Illinois | 17087 | 2149 | 31 |
1755627 | 1755627 | 2021-09-26 | Johnson | Indiana | 18081 | 23796 | 436 |
1755730 | 1755730 | 2021-09-26 | Johnson | Iowa | 19103 | 17004 | 92 |
1755824 | 1755824 | 2021-09-26 | Johnson | Kansas | 20091 | 74174 | 882 |
1755941 | 1755941 | 2021-09-26 | Johnson | Kentucky | 21115 | 3463 | 43 |
1756429 | 1756429 | 2021-09-26 | Johnson | Missouri | 29101 | 6734 | 68 |
1756600 | 1756600 | 2021-09-26 | Johnson | Nebraska | 31097 | 677 | 10 |
1757455 | 1757455 | 2021-09-26 | Johnson | Tennessee | 47091 | 3283 | 45 |
1757631 | 1757631 | 2021-09-26 | Johnson | Texas | 48251 | 25947 | 462 |
1758116 | 1758116 | 2021-09-26 | Johnson | Wyoming | 56019 | 1055 | 13 |
1751780 | 1751780 | 2021-09-25 | Johnson | Arkansas | 5071 | 4389 | 56 |
1752107 | 1752107 | 2021-09-25 | Johnson | Georgia | 13167 | 1512 | 55 |
1752279 | 1752279 | 2021-09-25 | Johnson | Illinois | 17087 | 2149 | 31 |
1752379 | 1752379 | 2021-09-25 | Johnson | Indiana | 18081 | 23796 | 436 |
1752482 | 1752482 | 2021-09-25 | Johnson | Iowa | 19103 | 17004 | 92 |
1752576 | 1752576 | 2021-09-25 | Johnson | Kansas | 20091 | 74174 | 882 |
1752693 | 1752693 | 2021-09-25 | Johnson | Kentucky | 21115 | 3463 | 43 |
1753181 | 1753181 | 2021-09-25 | Johnson | Missouri | 29101 | 6727 | 68 |
1753352 | 1753352 | 2021-09-25 | Johnson | Nebraska | 31097 | 677 | 10 |
1754207 | 1754207 | 2021-09-25 | Johnson | Tennessee | 47091 | 3283 | 45 |
1754383 | 1754383 | 2021-09-25 | Johnson | Texas | 48251 | 25947 | 462 |
1754868 | 1754868 | 2021-09-25 | Johnson | Wyoming | 56019 | 1055 | 13 |
1748531 | 1748531 | 2021-09-24 | Johnson | Arkansas | 5071 | 4382 | 56 |
1748858 | 1748858 | 2021-09-24 | Johnson | Georgia | 13167 | 1512 | 55 |
1749030 | 1749030 | 2021-09-24 | Johnson | Illinois | 17087 | 2149 | 31 |
1749130 | 1749130 | 2021-09-24 | Johnson | Indiana | 18081 | 23796 | 436 |
1749233 | 1749233 | 2021-09-24 | Johnson | Iowa | 19103 | 17004 | 92 |
1749327 | 1749327 | 2021-09-24 | Johnson | Kansas | 20091 | 74174 | 882 |
1749444 | 1749444 | 2021-09-24 | Johnson | Kentucky | 21115 | 3463 | 43 |
1749933 | 1749933 | 2021-09-24 | Johnson | Missouri | 29101 | 6691 | 68 |
1750104 | 1750104 | 2021-09-24 | Johnson | Nebraska | 31097 | 677 | 10 |
1750959 | 1750959 | 2021-09-24 | Johnson | Tennessee | 47091 | 3283 | 45 |
1751135 | 1751135 | 2021-09-24 | Johnson | Texas | 48251 | 25734 | 458 |
1751620 | 1751620 | 2021-09-24 | Johnson | Wyoming | 56019 | 1055 | 13 |
1745281 | 1745281 | 2021-09-23 | Johnson | Arkansas | 5071 | 4367 | 56 |
1745608 | 1745608 | 2021-09-23 | Johnson | Georgia | 13167 | 1510 | 55 |
1745780 | 1745780 | 2021-09-23 | Johnson | Illinois | 17087 | 2144 | 30 |
1745880 | 1745880 | 2021-09-23 | Johnson | Indiana | 18081 | 23754 | 435 |
1745983 | 1745983 | 2021-09-23 | Johnson | Iowa | 19103 | 17004 | 92 |
1746077 | 1746077 | 2021-09-23 | Johnson | Kansas | 20091 | 73869 | 877 |
1746194 | 1746194 | 2021-09-23 | Johnson | Kentucky | 21115 | 3428 | 43 |
1746683 | 1746683 | 2021-09-23 | Johnson | Missouri | 29101 | 6659 | 68 |
1746854 | 1746854 | 2021-09-23 | Johnson | Nebraska | 31097 | 677 | 10 |
1747710 | 1747710 | 2021-09-23 | Johnson | Tennessee | 47091 | 3252 | 45 |
1747886 | 1747886 | 2021-09-23 | Johnson | Texas | 48251 | 25734 | 457 |
1748371 | 1748371 | 2021-09-23 | Johnson | Wyoming | 56019 | 1050 | 13 |
1742032 | 1742032 | 2021-09-22 | Johnson | Arkansas | 5071 | 4346 | 55 |
1742359 | 1742359 | 2021-09-22 | Johnson | Georgia | 13167 | 1508 | 54 |
1742531 | 1742531 | 2021-09-22 | Johnson | Illinois | 17087 | 2135 | 30 |
1742631 | 1742631 | 2021-09-22 | Johnson | Indiana | 18081 | 23678 | 435 |
1742734 | 1742734 | 2021-09-22 | Johnson | Iowa | 19103 | 17004 | 92 |
1742828 | 1742828 | 2021-09-22 | Johnson | Kansas | 20091 | 73869 | 877 |
1742945 | 1742945 | 2021-09-22 | Johnson | Kentucky | 21115 | 3408 | 43 |
1743434 | 1743434 | 2021-09-22 | Johnson | Missouri | 29101 | 6640 | 68 |
1743605 | 1743605 | 2021-09-22 | Johnson | Nebraska | 31097 | 677 | 10 |
1744460 | 1744460 | 2021-09-22 | Johnson | Tennessee | 47091 | 3247 | 44 |
1744636 | 1744636 | 2021-09-22 | Johnson | Texas | 48251 | 25544 | 451 |
1745121 | 1745121 | 2021-09-22 | Johnson | Wyoming | 56019 | 1045 | 13 |
1738783 | 1738783 | 2021-09-21 | Johnson | Arkansas | 5071 | 4334 | 55 |
1739110 | 1739110 | 2021-09-21 | Johnson | Georgia | 13167 | 1505 | 54 |
1739282 | 1739282 | 2021-09-21 | Johnson | Illinois | 17087 | 2123 | 30 |
1739382 | 1739382 | 2021-09-21 | Johnson | Indiana | 18081 | 23593 | 435 |
1739485 | 1739485 | 2021-09-21 | Johnson | Iowa | 19103 | 16619 | 90 |
1739579 | 1739579 | 2021-09-21 | Johnson | Kansas | 20091 | 73571 | 876 |
1739696 | 1739696 | 2021-09-21 | Johnson | Kentucky | 21115 | 3383 | 40 |
1740185 | 1740185 | 2021-09-21 | Johnson | Missouri | 29101 | 6612 | 68 |
1740356 | 1740356 | 2021-09-21 | Johnson | Nebraska | 31097 | 676 | 10 |
1741211 | 1741211 | 2021-09-21 | Johnson | Tennessee | 47091 | 3201 | 44 |
1741387 | 1741387 | 2021-09-21 | Johnson | Texas | 48251 | 25521 | 448 |
1741872 | 1741872 | 2021-09-21 | Johnson | Wyoming | 56019 | 1032 | 13 |
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);