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 |
---|---|---|---|---|---|---|---|
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 |
1788920 | 1788920 | 2021-10-06 | Johnson | Missouri | 29101 | 6916 | 70 |
1789091 | 1789091 | 2021-10-06 | Johnson | Nebraska | 31097 | 679 | 10 |
1789946 | 1789946 | 2021-10-06 | Johnson | Tennessee | 47091 | 3408 | 45 |
1790122 | 1790122 | 2021-10-06 | Johnson | Texas | 48251 | 26824 | 496 |
1790607 | 1790607 | 2021-10-06 | Johnson | Wyoming | 56019 | 1111 | 15 |
1784270 | 1784270 | 2021-10-05 | Johnson | Arkansas | 5071 | 4469 | 56 |
1784597 | 1784597 | 2021-10-05 | Johnson | Georgia | 13167 | 1529 | 57 |
1784769 | 1784769 | 2021-10-05 | Johnson | Illinois | 17087 | 2207 | 34 |
1784869 | 1784869 | 2021-10-05 | Johnson | Indiana | 18081 | 24402 | 449 |
1784972 | 1784972 | 2021-10-05 | Johnson | Iowa | 19103 | 17358 | 95 |
1785066 | 1785066 | 2021-10-05 | Johnson | Kansas | 20091 | 75358 | 897 |
1785183 | 1785183 | 2021-10-05 | Johnson | Kentucky | 21115 | 3568 | 45 |
1785672 | 1785672 | 2021-10-05 | Johnson | Missouri | 29101 | 6902 | 70 |
1785843 | 1785843 | 2021-10-05 | Johnson | Nebraska | 31097 | 679 | 10 |
1786698 | 1786698 | 2021-10-05 | Johnson | Tennessee | 47091 | 3398 | 45 |
1786874 | 1786874 | 2021-10-05 | Johnson | Texas | 48251 | 26731 | 494 |
1787359 | 1787359 | 2021-10-05 | Johnson | Wyoming | 56019 | 1104 | 15 |
1781021 | 1781021 | 2021-10-04 | Johnson | Arkansas | 5071 | 4465 | 56 |
1781348 | 1781348 | 2021-10-04 | Johnson | Georgia | 13167 | 1525 | 57 |
1781520 | 1781520 | 2021-10-04 | Johnson | Illinois | 17087 | 2197 | 34 |
1781620 | 1781620 | 2021-10-04 | Johnson | Indiana | 18081 | 24358 | 447 |
1781723 | 1781723 | 2021-10-04 | Johnson | Iowa | 19103 | 17358 | 95 |
1781817 | 1781817 | 2021-10-04 | Johnson | Kansas | 20091 | 75358 | 897 |
1781934 | 1781934 | 2021-10-04 | Johnson | Kentucky | 21115 | 3562 | 45 |
1782423 | 1782423 | 2021-10-04 | Johnson | Missouri | 29101 | 6881 | 69 |
1782594 | 1782594 | 2021-10-04 | Johnson | Nebraska | 31097 | 680 | 10 |
1783449 | 1783449 | 2021-10-04 | Johnson | Tennessee | 47091 | 3393 | 45 |
1783625 | 1783625 | 2021-10-04 | Johnson | Texas | 48251 | 26560 | 488 |
1784110 | 1784110 | 2021-10-04 | Johnson | Wyoming | 56019 | 1093 | 13 |
1777771 | 1777771 | 2021-10-03 | Johnson | Arkansas | 5071 | 4462 | 56 |
1778098 | 1778098 | 2021-10-03 | Johnson | Georgia | 13167 | 1522 | 57 |
1778270 | 1778270 | 2021-10-03 | Johnson | Illinois | 17087 | 2190 | 34 |
1778370 | 1778370 | 2021-10-03 | Johnson | Indiana | 18081 | 24225 | 445 |
1778473 | 1778473 | 2021-10-03 | Johnson | Iowa | 19103 | 17358 | 95 |
1778567 | 1778567 | 2021-10-03 | Johnson | Kansas | 20091 | 75105 | 897 |
1778684 | 1778684 | 2021-10-03 | Johnson | Kentucky | 21115 | 3544 | 43 |
1779173 | 1779173 | 2021-10-03 | Johnson | Missouri | 29101 | 6871 | 69 |
1779344 | 1779344 | 2021-10-03 | Johnson | Nebraska | 31097 | 679 | 10 |
1780200 | 1780200 | 2021-10-03 | Johnson | Tennessee | 47091 | 3372 | 45 |
1780376 | 1780376 | 2021-10-03 | Johnson | Texas | 48251 | 26560 | 488 |
1780861 | 1780861 | 2021-10-03 | Johnson | Wyoming | 56019 | 1080 | 13 |
1774521 | 1774521 | 2021-10-02 | Johnson | Arkansas | 5071 | 4459 | 56 |
1774848 | 1774848 | 2021-10-02 | Johnson | Georgia | 13167 | 1522 | 57 |
1775020 | 1775020 | 2021-10-02 | Johnson | Illinois | 17087 | 2190 | 34 |
1775120 | 1775120 | 2021-10-02 | Johnson | Indiana | 18081 | 24225 | 445 |
1775223 | 1775223 | 2021-10-02 | Johnson | Iowa | 19103 | 17358 | 95 |
1775317 | 1775317 | 2021-10-02 | Johnson | Kansas | 20091 | 75105 | 897 |
1775434 | 1775434 | 2021-10-02 | Johnson | Kentucky | 21115 | 3544 | 43 |
1775923 | 1775923 | 2021-10-02 | Johnson | Missouri | 29101 | 6871 | 69 |
1776094 | 1776094 | 2021-10-02 | Johnson | Nebraska | 31097 | 679 | 10 |
1776950 | 1776950 | 2021-10-02 | Johnson | Tennessee | 47091 | 3372 | 45 |
1777126 | 1777126 | 2021-10-02 | Johnson | Texas | 48251 | 26560 | 487 |
1777611 | 1777611 | 2021-10-02 | Johnson | Wyoming | 56019 | 1080 | 13 |
1771271 | 1771271 | 2021-10-01 | Johnson | Arkansas | 5071 | 4444 | 56 |
1771598 | 1771598 | 2021-10-01 | Johnson | Georgia | 13167 | 1522 | 57 |
1771770 | 1771770 | 2021-10-01 | Johnson | Illinois | 17087 | 2190 | 34 |
1771870 | 1771870 | 2021-10-01 | Johnson | Indiana | 18081 | 24225 | 445 |
1771973 | 1771973 | 2021-10-01 | Johnson | Iowa | 19103 | 17358 | 95 |
1772067 | 1772067 | 2021-10-01 | Johnson | Kansas | 20091 | 75105 | 897 |
1772184 | 1772184 | 2021-10-01 | Johnson | Kentucky | 21115 | 3544 | 43 |
1772673 | 1772673 | 2021-10-01 | Johnson | Missouri | 29101 | 6843 | 69 |
1772844 | 1772844 | 2021-10-01 | Johnson | Nebraska | 31097 | 679 | 10 |
1773700 | 1773700 | 2021-10-01 | Johnson | Tennessee | 47091 | 3372 | 45 |
1773876 | 1773876 | 2021-10-01 | Johnson | Texas | 48251 | 26458 | 483 |
1774361 | 1774361 | 2021-10-01 | Johnson | Wyoming | 56019 | 1080 | 13 |
1768022 | 1768022 | 2021-09-30 | Johnson | Arkansas | 5071 | 4429 | 56 |
1768349 | 1768349 | 2021-09-30 | Johnson | Georgia | 13167 | 1521 | 57 |
1768521 | 1768521 | 2021-09-30 | Johnson | Illinois | 17087 | 2190 | 33 |
1768621 | 1768621 | 2021-09-30 | Johnson | Indiana | 18081 | 24148 | 445 |
1768724 | 1768724 | 2021-09-30 | Johnson | Iowa | 19103 | 17358 | 95 |
1768818 | 1768818 | 2021-09-30 | Johnson | Kansas | 20091 | 74792 | 893 |
1768935 | 1768935 | 2021-09-30 | Johnson | Kentucky | 21115 | 3529 | 43 |
1769424 | 1769424 | 2021-09-30 | Johnson | Missouri | 29101 | 6816 | 69 |
1769595 | 1769595 | 2021-09-30 | Johnson | Nebraska | 31097 | 679 | 10 |
1770450 | 1770450 | 2021-09-30 | Johnson | Tennessee | 47091 | 3363 | 45 |
1770626 | 1770626 | 2021-09-30 | Johnson | Texas | 48251 | 26375 | 478 |
1771111 | 1771111 | 2021-09-30 | Johnson | Wyoming | 56019 | 1073 | 13 |
1764773 | 1764773 | 2021-09-29 | Johnson | Arkansas | 5071 | 4415 | 56 |
1765100 | 1765100 | 2021-09-29 | Johnson | Georgia | 13167 | 1521 | 57 |
1765272 | 1765272 | 2021-09-29 | Johnson | Illinois | 17087 | 2182 | 32 |
1765372 | 1765372 | 2021-09-29 | Johnson | Indiana | 18081 | 24070 | 444 |
1765475 | 1765475 | 2021-09-29 | Johnson | Iowa | 19103 | 17358 | 95 |
1765569 | 1765569 | 2021-09-29 | Johnson | Kansas | 20091 | 74792 | 893 |
1765686 | 1765686 | 2021-09-29 | Johnson | Kentucky | 21115 | 3518 | 43 |
1766175 | 1766175 | 2021-09-29 | Johnson | Missouri | 29101 | 6790 | 69 |
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);