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 |
---|---|---|---|---|---|---|---|
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 |
256532 | 256532 | 2020-06-20 | Johnson | Iowa | 19103 | 725 | 8 |
256622 | 256622 | 2020-06-20 | Johnson | Kansas | 20091 | 1236 | 79 |
256729 | 256729 | 2020-06-20 | Johnson | Kentucky | 21115 | 9 | 0 |
257214 | 257214 | 2020-06-20 | Johnson | Missouri | 29101 | 89 | 0 |
257354 | 257354 | 2020-06-20 | Johnson | Nebraska | 31097 | 6 | 0 |
258177 | 258177 | 2020-06-20 | Johnson | Tennessee | 47091 | 26 | 0 |
258348 | 258348 | 2020-06-20 | Johnson | Texas | 48251 | 298 | 4 |
258819 | 258819 | 2020-06-20 | Johnson | Wyoming | 56019 | 19 | 1 |
252727 | 252727 | 2020-06-19 | Johnson | Arkansas | 5071 | 121 | 0 |
253049 | 253049 | 2020-06-19 | Johnson | Georgia | 13167 | 80 | 2 |
253210 | 253210 | 2020-06-19 | Johnson | Illinois | 17087 | 20 | 0 |
253309 | 253309 | 2020-06-19 | Johnson | Indiana | 18081 | 1213 | 124 |
253412 | 253412 | 2020-06-19 | Johnson | Iowa | 19103 | 721 | 8 |
253502 | 253502 | 2020-06-19 | Johnson | Kansas | 20091 | 1229 | 77 |
253609 | 253609 | 2020-06-19 | Johnson | Kentucky | 21115 | 8 | 0 |
254094 | 254094 | 2020-06-19 | Johnson | Missouri | 29101 | 90 | 0 |
254231 | 254231 | 2020-06-19 | Johnson | Nebraska | 31097 | 6 | 0 |
255051 | 255051 | 2020-06-19 | Johnson | Tennessee | 47091 | 26 | 0 |
255221 | 255221 | 2020-06-19 | Johnson | Texas | 48251 | 298 | 4 |
255692 | 255692 | 2020-06-19 | Johnson | Wyoming | 56019 | 19 | 1 |
249612 | 249612 | 2020-06-18 | Johnson | Arkansas | 5071 | 107 | 0 |
249934 | 249934 | 2020-06-18 | Johnson | Georgia | 13167 | 78 | 2 |
250095 | 250095 | 2020-06-18 | Johnson | Illinois | 17087 | 20 | 0 |
250194 | 250194 | 2020-06-18 | Johnson | Indiana | 18081 | 1213 | 124 |
250297 | 250297 | 2020-06-18 | Johnson | Iowa | 19103 | 696 | 8 |
250387 | 250387 | 2020-06-18 | Johnson | Kansas | 20091 | 1150 | 76 |
250494 | 250494 | 2020-06-18 | Johnson | Kentucky | 21115 | 7 | 0 |
250979 | 250979 | 2020-06-18 | Johnson | Missouri | 29101 | 87 | 0 |
251116 | 251116 | 2020-06-18 | Johnson | Nebraska | 31097 | 6 | 0 |
251936 | 251936 | 2020-06-18 | Johnson | Tennessee | 47091 | 26 | 0 |
252106 | 252106 | 2020-06-18 | Johnson | Texas | 48251 | 282 | 4 |
252573 | 252573 | 2020-06-18 | Johnson | Wyoming | 56019 | 19 | 1 |
246500 | 246500 | 2020-06-17 | Johnson | Arkansas | 5071 | 99 | 0 |
246822 | 246822 | 2020-06-17 | Johnson | Georgia | 13167 | 78 | 2 |
246983 | 246983 | 2020-06-17 | Johnson | Illinois | 17087 | 20 | 0 |
247082 | 247082 | 2020-06-17 | Johnson | Indiana | 18081 | 1205 | 123 |
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);