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

This data as json, CSV (advanced)

Suggested facets: date (date)

state

fips

county

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