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,176 rows where county = "Adams" sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

county

  • Adams · 1,176
Link rowid date ▲ county state fips cases deaths
316689 2020-07-11 Adams Colorado 8001 4719 158
316998 2020-07-11 Adams Idaho 16003 12 0
317038 2020-07-11 Adams Illinois 17001 167 1
317141 2020-07-11 Adams Indiana 18001 50 2
317234 2020-07-11 Adams Iowa 19003 8 0
317846 2020-07-11 Adams Mississippi 28001 351 20
318084 2020-07-11 Adams Nebraska 31001 312 11
318456 2020-07-11 Adams Ohio 39001 26 1
318656 2020-07-11 Adams Pennsylvania 42001 385 14
319360 2020-07-11 Adams Washington 53001 222 0
319452 2020-07-11 Adams Wisconsin 55001 37 2
313591 2020-07-10 Adams Colorado 8001 4669 157
313900 2020-07-10 Adams Idaho 16003 12 0
313940 2020-07-10 Adams Illinois 17001 151 1
314043 2020-07-10 Adams Indiana 18001 50 2
314136 2020-07-10 Adams Iowa 19003 8 0
314748 2020-07-10 Adams Mississippi 28001 347 19
314986 2020-07-10 Adams Nebraska 31001 309 11
315356 2020-07-10 Adams Ohio 39001 25 1
315556 2020-07-10 Adams Pennsylvania 42001 377 14
316259 2020-07-10 Adams Washington 53001 222 0
316351 2020-07-10 Adams Wisconsin 55001 37 2
310499 2020-07-09 Adams Colorado 8001 4588 156
310808 2020-07-09 Adams Idaho 16003 12 0
310848 2020-07-09 Adams Illinois 17001 142 1
310951 2020-07-09 Adams Indiana 18001 50 2
311044 2020-07-09 Adams Iowa 19003 8 0
311654 2020-07-09 Adams Mississippi 28001 340 19
311892 2020-07-09 Adams Nebraska 31001 309 11
312260 2020-07-09 Adams Ohio 39001 24 1
312459 2020-07-09 Adams Pennsylvania 42001 366 13
313161 2020-07-09 Adams Washington 53001 218 0
313253 2020-07-09 Adams Wisconsin 55001 35 2
307404 2020-07-08 Adams Colorado 8001 4546 156
307713 2020-07-08 Adams Idaho 16003 12 0
307754 2020-07-08 Adams Illinois 17001 139 1
307857 2020-07-08 Adams Indiana 18001 50 2
307950 2020-07-08 Adams Iowa 19003 8 0
308560 2020-07-08 Adams Mississippi 28001 332 18
308798 2020-07-08 Adams Nebraska 31001 304 11
309168 2020-07-08 Adams Ohio 39001 24 1
309367 2020-07-08 Adams Pennsylvania 42001 361 13
310069 2020-07-08 Adams Washington 53001 199 0
310161 2020-07-08 Adams Wisconsin 55001 35 2
304314 2020-07-07 Adams Colorado 8001 4478 156
304623 2020-07-07 Adams Idaho 16003 12 0
304664 2020-07-07 Adams Illinois 17001 134 1
304767 2020-07-07 Adams Indiana 18001 51 2
304860 2020-07-07 Adams Iowa 19003 8 0
305470 2020-07-07 Adams Mississippi 28001 315 18
305707 2020-07-07 Adams Nebraska 31001 302 11
306076 2020-07-07 Adams Ohio 39001 24 1
306275 2020-07-07 Adams Pennsylvania 42001 358 13
306974 2020-07-07 Adams Washington 53001 203 0
307066 2020-07-07 Adams Wisconsin 55001 33 2
301226 2020-07-06 Adams Colorado 8001 4400 156
301535 2020-07-06 Adams Idaho 16003 12 0
301576 2020-07-06 Adams Illinois 17001 131 1
301679 2020-07-06 Adams Indiana 18001 51 2
301772 2020-07-06 Adams Iowa 19003 8 0
302382 2020-07-06 Adams Mississippi 28001 313 18
302619 2020-07-06 Adams Nebraska 31001 301 11
302987 2020-07-06 Adams Ohio 39001 24 1
303186 2020-07-06 Adams Pennsylvania 42001 352 13
303885 2020-07-06 Adams Washington 53001 196 0
303977 2020-07-06 Adams Wisconsin 55001 33 2
298142 2020-07-05 Adams Colorado 8001 4362 156
298451 2020-07-05 Adams Idaho 16003 11 0
298491 2020-07-05 Adams Illinois 17001 122 1
298594 2020-07-05 Adams Indiana 18001 51 2
298687 2020-07-05 Adams Iowa 19003 8 0
299295 2020-07-05 Adams Mississippi 28001 311 18
299532 2020-07-05 Adams Nebraska 31001 299 11
299900 2020-07-05 Adams Ohio 39001 22 1
300099 2020-07-05 Adams Pennsylvania 42001 352 13
300797 2020-07-05 Adams Washington 53001 166 0
300888 2020-07-05 Adams Wisconsin 55001 32 2
295058 2020-07-04 Adams Colorado 8001 4322 156
295367 2020-07-04 Adams Idaho 16003 11 0
295407 2020-07-04 Adams Illinois 17001 113 1
295510 2020-07-04 Adams Indiana 18001 51 2
295603 2020-07-04 Adams Iowa 19003 8 0
296211 2020-07-04 Adams Mississippi 28001 310 18
296448 2020-07-04 Adams Nebraska 31001 299 11
296817 2020-07-04 Adams Ohio 39001 23 1
297016 2020-07-04 Adams Pennsylvania 42001 349 13
297713 2020-07-04 Adams Washington 53001 150 0
297804 2020-07-04 Adams Wisconsin 55001 27 2
291976 2020-07-03 Adams Colorado 8001 4293 156
292285 2020-07-03 Adams Idaho 16003 11 0
292325 2020-07-03 Adams Illinois 17001 106 1
292428 2020-07-03 Adams Indiana 18001 49 2
292521 2020-07-03 Adams Iowa 19003 8 0
293128 2020-07-03 Adams Mississippi 28001 293 18
293365 2020-07-03 Adams Nebraska 31001 298 11
293734 2020-07-03 Adams Ohio 39001 22 1
293932 2020-07-03 Adams Pennsylvania 42001 344 13
294629 2020-07-03 Adams Washington 53001 147 0
294720 2020-07-03 Adams Wisconsin 55001 23 2
288900 2020-07-02 Adams Colorado 8001 4267 156

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 995.634ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette