ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

1,218 rows where county = "Johnson" sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

county

  • Johnson · 1,218
Link rowid date ▲ county state fips cases deaths
291904 2020-07-03 Johnson Arkansas 5071 253 0
292227 2020-07-03 Johnson Georgia 13167 100 2
292394 2020-07-03 Johnson Illinois 17087 21 0
292494 2020-07-03 Johnson Indiana 18081 1283 126
292597 2020-07-03 Johnson Iowa 19103 1243 8
292688 2020-07-03 Johnson Kansas 20091 2066 88
292799 2020-07-03 Johnson Kentucky 21115 10 0
293285 2020-07-03 Johnson Missouri 29101 151 0
293432 2020-07-03 Johnson Nebraska 31097 7 0
294183 2020-07-03 Johnson Tennessee 47091 39 0
294356 2020-07-03 Johnson Texas 48251 526 4
294829 2020-07-03 Johnson Wyoming 56019 20 1
288827 2020-07-02 Johnson Arkansas 5071 251 0
289150 2020-07-02 Johnson Georgia 13167 92 2
289316 2020-07-02 Johnson Illinois 17087 21 0
289415 2020-07-02 Johnson Indiana 18081 1272 126
289518 2020-07-02 Johnson Iowa 19103 1231 8
289609 2020-07-02 Johnson Kansas 20091 1870 88
289720 2020-07-02 Johnson Kentucky 21115 9 0
290206 2020-07-02 Johnson Missouri 29101 141 0
290352 2020-07-02 Johnson Nebraska 31097 7 0
291102 2020-07-02 Johnson Tennessee 47091 38 0
291275 2020-07-02 Johnson Texas 48251 478 4
291746 2020-07-02 Johnson Wyoming 56019 20 1
285752 2020-07-01 Johnson Arkansas 5071 236 0
286075 2020-07-01 Johnson Georgia 13167 90 2
286241 2020-07-01 Johnson Illinois 17087 20 0
286340 2020-07-01 Johnson Indiana 18081 1263 126
286443 2020-07-01 Johnson Iowa 19103 1186 8
286534 2020-07-01 Johnson Kansas 20091 1870 87
286645 2020-07-01 Johnson Kentucky 21115 9 0
287131 2020-07-01 Johnson Missouri 29101 124 0
287276 2020-07-01 Johnson Nebraska 31097 7 0
288025 2020-07-01 Johnson Tennessee 47091 37 0
288199 2020-07-01 Johnson Texas 48251 448 4
288670 2020-07-01 Johnson Wyoming 56019 20 1
282679 2020-06-30 Johnson Arkansas 5071 227 0
283002 2020-06-30 Johnson Georgia 13167 90 2
283169 2020-06-30 Johnson Illinois 17087 20 0
283268 2020-06-30 Johnson Indiana 18081 1260 126
283371 2020-06-30 Johnson Iowa 19103 1150 8
283462 2020-06-30 Johnson Kansas 20091 1722 86
283574 2020-06-30 Johnson Kentucky 21115 10 0
284059 2020-06-30 Johnson Missouri 29101 124 0
284203 2020-06-30 Johnson Nebraska 31097 7 0
284952 2020-06-30 Johnson Tennessee 47091 36 0
285125 2020-06-30 Johnson Texas 48251 436 4
285596 2020-06-30 Johnson Wyoming 56019 20 1
279610 2020-06-29 Johnson Arkansas 5071 211 0
279933 2020-06-29 Johnson Georgia 13167 88 2
280097 2020-06-29 Johnson Illinois 17087 20 0
280196 2020-06-29 Johnson Indiana 18081 1259 125
280299 2020-06-29 Johnson Iowa 19103 1119 8
280390 2020-06-29 Johnson Kansas 20091 1722 86
280502 2020-06-29 Johnson Kentucky 21115 10 0
280986 2020-06-29 Johnson Missouri 29101 120 0
281130 2020-06-29 Johnson Nebraska 31097 6 0
281878 2020-06-29 Johnson Tennessee 47091 35 0
282052 2020-06-29 Johnson Texas 48251 436 4
282523 2020-06-29 Johnson Wyoming 56019 20 1
276542 2020-06-28 Johnson Arkansas 5071 210 0
276865 2020-06-28 Johnson Georgia 13167 87 2
277030 2020-06-28 Johnson Illinois 17087 20 0
277129 2020-06-28 Johnson Indiana 18081 1255 125
277232 2020-06-28 Johnson Iowa 19103 1033 8
277323 2020-06-28 Johnson Kansas 20091 1613 86
277433 2020-06-28 Johnson Kentucky 21115 10 0
277918 2020-06-28 Johnson Missouri 29101 113 0
278062 2020-06-28 Johnson Nebraska 31097 6 0
278810 2020-06-28 Johnson Tennessee 47091 34 0
278983 2020-06-28 Johnson Texas 48251 372 4
279454 2020-06-28 Johnson Wyoming 56019 20 1
273473 2020-06-27 Johnson Arkansas 5071 207 0
273796 2020-06-27 Johnson Georgia 13167 85 2
273960 2020-06-27 Johnson Illinois 17087 20 0
274059 2020-06-27 Johnson Indiana 18081 1248 125
274162 2020-06-27 Johnson Iowa 19103 1016 8
274253 2020-06-27 Johnson Kansas 20091 1550 85
274363 2020-06-27 Johnson Kentucky 21115 10 0
274848 2020-06-27 Johnson Missouri 29101 112 0
274992 2020-06-27 Johnson Nebraska 31097 6 0
275742 2020-06-27 Johnson Tennessee 47091 34 0
275915 2020-06-27 Johnson Texas 48251 372 4
276386 2020-06-27 Johnson Wyoming 56019 20 1
270404 2020-06-26 Johnson Arkansas 5071 188 0
270727 2020-06-26 Johnson Georgia 13167 84 2
270891 2020-06-26 Johnson Illinois 17087 20 0
270990 2020-06-26 Johnson Indiana 18081 1240 125
271093 2020-06-26 Johnson Iowa 19103 964 8
271184 2020-06-26 Johnson Kansas 20091 1545 83
271294 2020-06-26 Johnson Kentucky 21115 10 0
271779 2020-06-26 Johnson Missouri 29101 101 0
271923 2020-06-26 Johnson Nebraska 31097 6 0
272673 2020-06-26 Johnson Tennessee 47091 30 0
272846 2020-06-26 Johnson Texas 48251 328 4
273317 2020-06-26 Johnson Wyoming 56019 20 1
267343 2020-06-25 Johnson Arkansas 5071 175 0
267666 2020-06-25 Johnson Georgia 13167 84 2
267828 2020-06-25 Johnson Illinois 17087 20 0
267927 2020-06-25 Johnson Indiana 18081 1233 125

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 959.04ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette