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 |
---|---|---|---|---|---|---|---|
1199592 | 1199592 | 2021-04-07 | Johnson | Wyoming | 56019 | 714 | 10 |
1193254 | 1193254 | 2021-04-06 | Johnson | Arkansas | 5071 | 2885 | 37 |
1193581 | 1193581 | 2021-04-06 | Johnson | Georgia | 13167 | 1108 | 48 |
1193752 | 1193752 | 2021-04-06 | Johnson | Illinois | 17087 | 1376 | 20 |
1193852 | 1193852 | 2021-04-06 | Johnson | Indiana | 18081 | 17257 | 386 |
1193955 | 1193955 | 2021-04-06 | Johnson | Iowa | 19103 | 13719 | 80 |
1194049 | 1194049 | 2021-04-06 | Johnson | Kansas | 20091 | 56398 | 642 |
1194167 | 1194167 | 2021-04-06 | Johnson | Kentucky | 21115 | 1866 | 30 |
1194655 | 1194655 | 2021-04-06 | Johnson | Missouri | 29101 | 4937 | 49 |
1194826 | 1194826 | 2021-04-06 | Johnson | Nebraska | 31097 | 634 | 9 |
1195681 | 1195681 | 2021-04-06 | Johnson | Tennessee | 47091 | 2236 | 38 |
1195857 | 1195857 | 2021-04-06 | Johnson | Texas | 48251 | 19382 | 360 |
1196343 | 1196343 | 2021-04-06 | Johnson | Wyoming | 56019 | 714 | 10 |
1190004 | 1190004 | 2021-04-05 | Johnson | Arkansas | 5071 | 2884 | 37 |
1190331 | 1190331 | 2021-04-05 | Johnson | Georgia | 13167 | 1106 | 48 |
1190502 | 1190502 | 2021-04-05 | Johnson | Illinois | 17087 | 1376 | 20 |
1190602 | 1190602 | 2021-04-05 | Johnson | Indiana | 18081 | 17239 | 385 |
1190705 | 1190705 | 2021-04-05 | Johnson | Iowa | 19103 | 13688 | 80 |
1190799 | 1190799 | 2021-04-05 | Johnson | Kansas | 20091 | 56398 | 641 |
1190917 | 1190917 | 2021-04-05 | Johnson | Kentucky | 21115 | 1866 | 30 |
1191406 | 1191406 | 2021-04-05 | Johnson | Missouri | 29101 | 4933 | 49 |
1191577 | 1191577 | 2021-04-05 | Johnson | Nebraska | 31097 | 635 | 9 |
1192433 | 1192433 | 2021-04-05 | Johnson | Tennessee | 47091 | 2234 | 38 |
1192609 | 1192609 | 2021-04-05 | Johnson | Texas | 48251 | 19361 | 360 |
1193095 | 1193095 | 2021-04-05 | Johnson | Wyoming | 56019 | 713 | 10 |
1186757 | 1186757 | 2021-04-04 | Johnson | Arkansas | 5071 | 2884 | 37 |
1187084 | 1187084 | 2021-04-04 | Johnson | Georgia | 13167 | 1104 | 48 |
1187255 | 1187255 | 2021-04-04 | Johnson | Illinois | 17087 | 1374 | 20 |
1187355 | 1187355 | 2021-04-04 | Johnson | Indiana | 18081 | 17225 | 385 |
1187458 | 1187458 | 2021-04-04 | Johnson | Iowa | 19103 | 13664 | 80 |
1187552 | 1187552 | 2021-04-04 | Johnson | Kansas | 20091 | 56299 | 643 |
1187670 | 1187670 | 2021-04-04 | Johnson | Kentucky | 21115 | 1862 | 30 |
1188158 | 1188158 | 2021-04-04 | Johnson | Missouri | 29101 | 4933 | 49 |
1188329 | 1188329 | 2021-04-04 | Johnson | Nebraska | 31097 | 635 | 9 |
1189184 | 1189184 | 2021-04-04 | Johnson | Tennessee | 47091 | 2228 | 38 |
1189360 | 1189360 | 2021-04-04 | Johnson | Texas | 48251 | 19361 | 360 |
1189845 | 1189845 | 2021-04-04 | Johnson | Wyoming | 56019 | 713 | 10 |
1183510 | 1183510 | 2021-04-03 | Johnson | Arkansas | 5071 | 2883 | 37 |
1183837 | 1183837 | 2021-04-03 | Johnson | Georgia | 13167 | 1104 | 48 |
1184008 | 1184008 | 2021-04-03 | Johnson | Illinois | 17087 | 1374 | 20 |
1184108 | 1184108 | 2021-04-03 | Johnson | Indiana | 18081 | 17201 | 385 |
1184211 | 1184211 | 2021-04-03 | Johnson | Iowa | 19103 | 13649 | 80 |
1184305 | 1184305 | 2021-04-03 | Johnson | Kansas | 20091 | 56299 | 643 |
1184423 | 1184423 | 2021-04-03 | Johnson | Kentucky | 21115 | 1862 | 30 |
1184911 | 1184911 | 2021-04-03 | Johnson | Missouri | 29101 | 4931 | 49 |
1185082 | 1185082 | 2021-04-03 | Johnson | Nebraska | 31097 | 635 | 9 |
1185937 | 1185937 | 2021-04-03 | Johnson | Tennessee | 47091 | 2228 | 38 |
1186113 | 1186113 | 2021-04-03 | Johnson | Texas | 48251 | 19361 | 360 |
1186598 | 1186598 | 2021-04-03 | Johnson | Wyoming | 56019 | 713 | 10 |
1180263 | 1180263 | 2021-04-02 | Johnson | Arkansas | 5071 | 2882 | 37 |
1180590 | 1180590 | 2021-04-02 | Johnson | Georgia | 13167 | 1103 | 48 |
1180761 | 1180761 | 2021-04-02 | Johnson | Illinois | 17087 | 1374 | 20 |
1180861 | 1180861 | 2021-04-02 | Johnson | Indiana | 18081 | 17182 | 385 |
1180964 | 1180964 | 2021-04-02 | Johnson | Iowa | 19103 | 13630 | 79 |
1181058 | 1181058 | 2021-04-02 | Johnson | Kansas | 20091 | 56299 | 643 |
1181176 | 1181176 | 2021-04-02 | Johnson | Kentucky | 21115 | 1866 | 30 |
1181665 | 1181665 | 2021-04-02 | Johnson | Missouri | 29101 | 4926 | 49 |
1181836 | 1181836 | 2021-04-02 | Johnson | Nebraska | 31097 | 638 | 9 |
1182690 | 1182690 | 2021-04-02 | Johnson | Tennessee | 47091 | 2228 | 38 |
1182866 | 1182866 | 2021-04-02 | Johnson | Texas | 48251 | 19351 | 360 |
1183351 | 1183351 | 2021-04-02 | Johnson | Wyoming | 56019 | 713 | 10 |
1177016 | 1177016 | 2021-04-01 | Johnson | Arkansas | 5071 | 2879 | 37 |
1177343 | 1177343 | 2021-04-01 | Johnson | Georgia | 13167 | 1102 | 48 |
1177514 | 1177514 | 2021-04-01 | Johnson | Illinois | 17087 | 1373 | 20 |
1177614 | 1177614 | 2021-04-01 | Johnson | Indiana | 18081 | 17143 | 385 |
1177717 | 1177717 | 2021-04-01 | Johnson | Iowa | 19103 | 13591 | 79 |
1177811 | 1177811 | 2021-04-01 | Johnson | Kansas | 20091 | 56159 | 642 |
1177929 | 1177929 | 2021-04-01 | Johnson | Kentucky | 21115 | 1863 | 30 |
1178418 | 1178418 | 2021-04-01 | Johnson | Missouri | 29101 | 4926 | 49 |
1178589 | 1178589 | 2021-04-01 | Johnson | Nebraska | 31097 | 636 | 9 |
1179443 | 1179443 | 2021-04-01 | Johnson | Tennessee | 47091 | 2228 | 38 |
1179619 | 1179619 | 2021-04-01 | Johnson | Texas | 48251 | 19334 | 359 |
1180104 | 1180104 | 2021-04-01 | Johnson | Wyoming | 56019 | 713 | 10 |
1173769 | 1173769 | 2021-03-31 | Johnson | Arkansas | 5071 | 2879 | 37 |
1174096 | 1174096 | 2021-03-31 | Johnson | Georgia | 13167 | 1102 | 48 |
1174267 | 1174267 | 2021-03-31 | Johnson | Illinois | 17087 | 1372 | 20 |
1174367 | 1174367 | 2021-03-31 | Johnson | Indiana | 18081 | 17111 | 385 |
1174470 | 1174470 | 2021-03-31 | Johnson | Iowa | 19103 | 13561 | 79 |
1174564 | 1174564 | 2021-03-31 | Johnson | Kansas | 20091 | 56159 | 641 |
1174682 | 1174682 | 2021-03-31 | Johnson | Kentucky | 21115 | 1855 | 30 |
1175171 | 1175171 | 2021-03-31 | Johnson | Missouri | 29101 | 4922 | 49 |
1175342 | 1175342 | 2021-03-31 | Johnson | Nebraska | 31097 | 637 | 9 |
1176196 | 1176196 | 2021-03-31 | Johnson | Tennessee | 47091 | 2223 | 38 |
1176372 | 1176372 | 2021-03-31 | Johnson | Texas | 48251 | 19307 | 359 |
1176857 | 1176857 | 2021-03-31 | Johnson | Wyoming | 56019 | 713 | 10 |
1170522 | 1170522 | 2021-03-30 | Johnson | Arkansas | 5071 | 2878 | 36 |
1170849 | 1170849 | 2021-03-30 | Johnson | Georgia | 13167 | 1102 | 48 |
1171020 | 1171020 | 2021-03-30 | Johnson | Illinois | 17087 | 1372 | 20 |
1171120 | 1171120 | 2021-03-30 | Johnson | Indiana | 18081 | 17084 | 385 |
1171223 | 1171223 | 2021-03-30 | Johnson | Iowa | 19103 | 13544 | 78 |
1171317 | 1171317 | 2021-03-30 | Johnson | Kansas | 20091 | 56029 | 641 |
1171435 | 1171435 | 2021-03-30 | Johnson | Kentucky | 21115 | 1853 | 30 |
1171924 | 1171924 | 2021-03-30 | Johnson | Missouri | 29101 | 4919 | 49 |
1172095 | 1172095 | 2021-03-30 | Johnson | Nebraska | 31097 | 637 | 9 |
1172949 | 1172949 | 2021-03-30 | Johnson | Tennessee | 47091 | 2221 | 38 |
1173125 | 1173125 | 2021-03-30 | Johnson | Texas | 48251 | 19270 | 359 |
1173610 | 1173610 | 2021-03-30 | Johnson | Wyoming | 56019 | 713 | 10 |
1167274 | 1167274 | 2021-03-29 | Johnson | Arkansas | 5071 | 2875 | 36 |
1167601 | 1167601 | 2021-03-29 | Johnson | Georgia | 13167 | 1102 | 48 |
1167772 | 1167772 | 2021-03-29 | Johnson | Illinois | 17087 | 1372 | 20 |
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);