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 |
---|---|---|---|---|---|---|---|
280928 | 280928 | 2020-06-28 | Johnson | Arkansas | 5071 | 210 | 0 |
281251 | 281251 | 2020-06-28 | Johnson | Georgia | 13167 | 87 | 2 |
281416 | 281416 | 2020-06-28 | Johnson | Illinois | 17087 | 20 | 0 |
281515 | 281515 | 2020-06-28 | Johnson | Indiana | 18081 | 1255 | 125 |
281618 | 281618 | 2020-06-28 | Johnson | Iowa | 19103 | 1033 | 8 |
281709 | 281709 | 2020-06-28 | Johnson | Kansas | 20091 | 1613 | 86 |
281819 | 281819 | 2020-06-28 | Johnson | Kentucky | 21115 | 10 | 0 |
282304 | 282304 | 2020-06-28 | Johnson | Missouri | 29101 | 113 | 0 |
282448 | 282448 | 2020-06-28 | Johnson | Nebraska | 31097 | 6 | 0 |
283274 | 283274 | 2020-06-28 | Johnson | Tennessee | 47091 | 34 | 0 |
283447 | 283447 | 2020-06-28 | Johnson | Texas | 48251 | 372 | 4 |
283920 | 283920 | 2020-06-28 | Johnson | Wyoming | 56019 | 20 | 1 |
277781 | 277781 | 2020-06-27 | Johnson | Arkansas | 5071 | 207 | 0 |
278104 | 278104 | 2020-06-27 | Johnson | Georgia | 13167 | 85 | 2 |
278268 | 278268 | 2020-06-27 | Johnson | Illinois | 17087 | 20 | 0 |
278367 | 278367 | 2020-06-27 | Johnson | Indiana | 18081 | 1248 | 125 |
278470 | 278470 | 2020-06-27 | Johnson | Iowa | 19103 | 1016 | 8 |
278561 | 278561 | 2020-06-27 | Johnson | Kansas | 20091 | 1550 | 85 |
278671 | 278671 | 2020-06-27 | Johnson | Kentucky | 21115 | 10 | 0 |
279156 | 279156 | 2020-06-27 | Johnson | Missouri | 29101 | 112 | 0 |
279300 | 279300 | 2020-06-27 | Johnson | Nebraska | 31097 | 6 | 0 |
280128 | 280128 | 2020-06-27 | Johnson | Tennessee | 47091 | 34 | 0 |
280301 | 280301 | 2020-06-27 | Johnson | Texas | 48251 | 372 | 4 |
280774 | 280774 | 2020-06-27 | Johnson | Wyoming | 56019 | 20 | 1 |
274633 | 274633 | 2020-06-26 | Johnson | Arkansas | 5071 | 188 | 0 |
274956 | 274956 | 2020-06-26 | Johnson | Georgia | 13167 | 84 | 2 |
275120 | 275120 | 2020-06-26 | Johnson | Illinois | 17087 | 20 | 0 |
275219 | 275219 | 2020-06-26 | Johnson | Indiana | 18081 | 1240 | 125 |
275322 | 275322 | 2020-06-26 | Johnson | Iowa | 19103 | 964 | 8 |
275413 | 275413 | 2020-06-26 | Johnson | Kansas | 20091 | 1545 | 83 |
275523 | 275523 | 2020-06-26 | Johnson | Kentucky | 21115 | 10 | 0 |
276008 | 276008 | 2020-06-26 | Johnson | Missouri | 29101 | 101 | 0 |
276152 | 276152 | 2020-06-26 | Johnson | Nebraska | 31097 | 6 | 0 |
276980 | 276980 | 2020-06-26 | Johnson | Tennessee | 47091 | 30 | 0 |
277153 | 277153 | 2020-06-26 | Johnson | Texas | 48251 | 328 | 4 |
277626 | 277626 | 2020-06-26 | Johnson | Wyoming | 56019 | 20 | 1 |
271493 | 271493 | 2020-06-25 | Johnson | Arkansas | 5071 | 175 | 0 |
271816 | 271816 | 2020-06-25 | Johnson | Georgia | 13167 | 84 | 2 |
271978 | 271978 | 2020-06-25 | Johnson | Illinois | 17087 | 20 | 0 |
272077 | 272077 | 2020-06-25 | Johnson | Indiana | 18081 | 1233 | 125 |
272180 | 272180 | 2020-06-25 | Johnson | Iowa | 19103 | 914 | 9 |
272270 | 272270 | 2020-06-25 | Johnson | Kansas | 20091 | 1427 | 81 |
272380 | 272380 | 2020-06-25 | Johnson | Kentucky | 21115 | 10 | 0 |
272865 | 272865 | 2020-06-25 | Johnson | Missouri | 29101 | 100 | 0 |
273009 | 273009 | 2020-06-25 | Johnson | Nebraska | 31097 | 6 | 0 |
273833 | 273833 | 2020-06-25 | Johnson | Tennessee | 47091 | 28 | 0 |
274005 | 274005 | 2020-06-25 | Johnson | Texas | 48251 | 328 | 4 |
274478 | 274478 | 2020-06-25 | Johnson | Wyoming | 56019 | 19 | 1 |
268358 | 268358 | 2020-06-24 | Johnson | Arkansas | 5071 | 166 | 0 |
268680 | 268680 | 2020-06-24 | Johnson | Georgia | 13167 | 82 | 2 |
268841 | 268841 | 2020-06-24 | Johnson | Illinois | 17087 | 20 | 0 |
268940 | 268940 | 2020-06-24 | Johnson | Indiana | 18081 | 1233 | 125 |
269043 | 269043 | 2020-06-24 | Johnson | Iowa | 19103 | 858 | 9 |
269133 | 269133 | 2020-06-24 | Johnson | Kansas | 20091 | 1409 | 81 |
269244 | 269244 | 2020-06-24 | Johnson | Kentucky | 21115 | 10 | 0 |
269727 | 269727 | 2020-06-24 | Johnson | Missouri | 29101 | 91 | 0 |
269870 | 269870 | 2020-06-24 | Johnson | Nebraska | 31097 | 6 | 0 |
270694 | 270694 | 2020-06-24 | Johnson | Tennessee | 47091 | 27 | 0 |
270865 | 270865 | 2020-06-24 | Johnson | Texas | 48251 | 328 | 4 |
271338 | 271338 | 2020-06-24 | Johnson | Wyoming | 56019 | 19 | 1 |
265228 | 265228 | 2020-06-23 | Johnson | Arkansas | 5071 | 166 | 0 |
265550 | 265550 | 2020-06-23 | Johnson | Georgia | 13167 | 81 | 2 |
265711 | 265711 | 2020-06-23 | Johnson | Illinois | 17087 | 20 | 0 |
265810 | 265810 | 2020-06-23 | Johnson | Indiana | 18081 | 1233 | 125 |
265913 | 265913 | 2020-06-23 | Johnson | Iowa | 19103 | 811 | 8 |
266003 | 266003 | 2020-06-23 | Johnson | Kansas | 20091 | 1316 | 81 |
266111 | 266111 | 2020-06-23 | Johnson | Kentucky | 21115 | 10 | 0 |
266594 | 266594 | 2020-06-23 | Johnson | Missouri | 29101 | 91 | 0 |
266736 | 266736 | 2020-06-23 | Johnson | Nebraska | 31097 | 6 | 0 |
267560 | 267560 | 2020-06-23 | Johnson | Tennessee | 47091 | 26 | 0 |
267731 | 267731 | 2020-06-23 | Johnson | Texas | 48251 | 328 | 4 |
268204 | 268204 | 2020-06-23 | Johnson | Wyoming | 56019 | 19 | 1 |
262100 | 262100 | 2020-06-22 | Johnson | Arkansas | 5071 | 158 | 0 |
262422 | 262422 | 2020-06-22 | Johnson | Georgia | 13167 | 80 | 2 |
262583 | 262583 | 2020-06-22 | Johnson | Illinois | 17087 | 20 | 0 |
262682 | 262682 | 2020-06-22 | Johnson | Indiana | 18081 | 1228 | 125 |
262785 | 262785 | 2020-06-22 | Johnson | Iowa | 19103 | 781 | 8 |
262875 | 262875 | 2020-06-22 | Johnson | Kansas | 20091 | 1310 | 80 |
262984 | 262984 | 2020-06-22 | Johnson | Kentucky | 21115 | 10 | 0 |
263468 | 263468 | 2020-06-22 | Johnson | Missouri | 29101 | 89 | 0 |
263609 | 263609 | 2020-06-22 | Johnson | Nebraska | 31097 | 6 | 0 |
264432 | 264432 | 2020-06-22 | Johnson | Tennessee | 47091 | 26 | 0 |
264603 | 264603 | 2020-06-22 | Johnson | Texas | 48251 | 328 | 4 |
265075 | 265075 | 2020-06-22 | Johnson | Wyoming | 56019 | 19 | 1 |
258973 | 258973 | 2020-06-21 | Johnson | Arkansas | 5071 | 146 | 0 |
259295 | 259295 | 2020-06-21 | Johnson | Georgia | 13167 | 80 | 2 |
259456 | 259456 | 2020-06-21 | Johnson | Illinois | 17087 | 20 | 0 |
259555 | 259555 | 2020-06-21 | Johnson | Indiana | 18081 | 1228 | 125 |
259658 | 259658 | 2020-06-21 | Johnson | Iowa | 19103 | 760 | 8 |
259748 | 259748 | 2020-06-21 | Johnson | Kansas | 20091 | 1257 | 80 |
259855 | 259855 | 2020-06-21 | Johnson | Kentucky | 21115 | 9 | 0 |
260340 | 260340 | 2020-06-21 | Johnson | Missouri | 29101 | 89 | 0 |
260480 | 260480 | 2020-06-21 | Johnson | Nebraska | 31097 | 6 | 0 |
261304 | 261304 | 2020-06-21 | Johnson | Tennessee | 47091 | 26 | 0 |
261475 | 261475 | 2020-06-21 | Johnson | Texas | 48251 | 298 | 4 |
261946 | 261946 | 2020-06-21 | Johnson | Wyoming | 56019 | 19 | 1 |
255846 | 255846 | 2020-06-20 | Johnson | Arkansas | 5071 | 135 | 0 |
256168 | 256168 | 2020-06-20 | Johnson | Georgia | 13167 | 80 | 2 |
256330 | 256330 | 2020-06-20 | Johnson | Illinois | 17087 | 20 | 0 |
256429 | 256429 | 2020-06-20 | Johnson | Indiana | 18081 | 1217 | 125 |
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);