ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,212 rows where county = "Adams" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 12
- Indiana 144
- Colorado 142
- Nebraska 136
- Pennsylvania 136
- Illinois 134
- Mississippi 134
- Washington 131
- Idaho 123
- Wisconsin 121
- Ohio 119
- Iowa 76
- North Dakota 4
fips 12
county 1
- Adams · 1,400 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386183 | 386183 | 2020-07-31 | Adams | Colorado | 8001 | 5957 | 171 |
386494 | 386494 | 2020-07-31 | Adams | Idaho | 16003 | 18 | 0 |
386535 | 386535 | 2020-07-31 | Adams | Illinois | 17001 | 393 | 2 |
386638 | 386638 | 2020-07-31 | Adams | Indiana | 18001 | 75 | 3 |
386731 | 386731 | 2020-07-31 | Adams | Iowa | 19003 | 15 | 0 |
387347 | 387347 | 2020-07-31 | Adams | Mississippi | 28001 | 565 | 23 |
387597 | 387597 | 2020-07-31 | Adams | Nebraska | 31001 | 339 | 11 |
387921 | 387921 | 2020-07-31 | Adams | North Dakota | 38001 | 2 | 0 |
387977 | 387977 | 2020-07-31 | Adams | Ohio | 39001 | 53 | 2 |
388177 | 388177 | 2020-07-31 | Adams | Pennsylvania | 42001 | 462 | 20 |
388966 | 388966 | 2020-07-31 | Adams | Washington | 53001 | 374 | 3 |
389061 | 389061 | 2020-07-31 | Adams | Wisconsin | 55001 | 69 | 2 |
382965 | 382965 | 2020-07-30 | Adams | Colorado | 8001 | 5868 | 168 |
383276 | 383276 | 2020-07-30 | Adams | Idaho | 16003 | 18 | 0 |
383317 | 383317 | 2020-07-30 | Adams | Illinois | 17001 | 363 | 2 |
383420 | 383420 | 2020-07-30 | Adams | Indiana | 18001 | 74 | 2 |
383513 | 383513 | 2020-07-30 | Adams | Iowa | 19003 | 15 | 0 |
384129 | 384129 | 2020-07-30 | Adams | Mississippi | 28001 | 552 | 23 |
384379 | 384379 | 2020-07-30 | Adams | Nebraska | 31001 | 336 | 11 |
384704 | 384704 | 2020-07-30 | Adams | North Dakota | 38001 | 2 | 0 |
384760 | 384760 | 2020-07-30 | Adams | Ohio | 39001 | 53 | 2 |
384960 | 384960 | 2020-07-30 | Adams | Pennsylvania | 42001 | 461 | 19 |
385749 | 385749 | 2020-07-30 | Adams | Washington | 53001 | 374 | 3 |
385844 | 385844 | 2020-07-30 | Adams | Wisconsin | 55001 | 66 | 2 |
379748 | 379748 | 2020-07-29 | Adams | Colorado | 8001 | 5794 | 168 |
380059 | 380059 | 2020-07-29 | Adams | Idaho | 16003 | 18 | 0 |
380100 | 380100 | 2020-07-29 | Adams | Illinois | 17001 | 351 | 2 |
380203 | 380203 | 2020-07-29 | Adams | Indiana | 18001 | 74 | 2 |
380296 | 380296 | 2020-07-29 | Adams | Iowa | 19003 | 15 | 0 |
380912 | 380912 | 2020-07-29 | Adams | Mississippi | 28001 | 539 | 23 |
381163 | 381163 | 2020-07-29 | Adams | Nebraska | 31001 | 331 | 11 |
381486 | 381486 | 2020-07-29 | Adams | North Dakota | 38001 | 2 | 0 |
381542 | 381542 | 2020-07-29 | Adams | Ohio | 39001 | 51 | 2 |
381742 | 381742 | 2020-07-29 | Adams | Pennsylvania | 42001 | 454 | 18 |
382531 | 382531 | 2020-07-29 | Adams | Washington | 53001 | 371 | 2 |
382626 | 382626 | 2020-07-29 | Adams | Wisconsin | 55001 | 65 | 2 |
376531 | 376531 | 2020-07-28 | Adams | Colorado | 8001 | 5713 | 168 |
376842 | 376842 | 2020-07-28 | Adams | Idaho | 16003 | 17 | 0 |
376883 | 376883 | 2020-07-28 | Adams | Illinois | 17001 | 355 | 1 |
376986 | 376986 | 2020-07-28 | Adams | Indiana | 18001 | 74 | 2 |
377079 | 377079 | 2020-07-28 | Adams | Iowa | 19003 | 13 | 0 |
377695 | 377695 | 2020-07-28 | Adams | Mississippi | 28001 | 531 | 23 |
377945 | 377945 | 2020-07-28 | Adams | Nebraska | 31001 | 329 | 11 |
378269 | 378269 | 2020-07-28 | Adams | North Dakota | 38001 | 2 | 0 |
378325 | 378325 | 2020-07-28 | Adams | Ohio | 39001 | 48 | 2 |
378525 | 378525 | 2020-07-28 | Adams | Pennsylvania | 42001 | 448 | 18 |
379314 | 379314 | 2020-07-28 | Adams | Washington | 53001 | 368 | 2 |
379409 | 379409 | 2020-07-28 | Adams | Wisconsin | 55001 | 64 | 2 |
373317 | 373317 | 2020-07-27 | Adams | Colorado | 8001 | 5626 | 167 |
373628 | 373628 | 2020-07-27 | Adams | Idaho | 16003 | 17 | 0 |
373668 | 373668 | 2020-07-27 | Adams | Illinois | 17001 | 352 | 1 |
373771 | 373771 | 2020-07-27 | Adams | Indiana | 18001 | 72 | 2 |
373864 | 373864 | 2020-07-27 | Adams | Iowa | 19003 | 13 | 0 |
374480 | 374480 | 2020-07-27 | Adams | Mississippi | 28001 | 518 | 23 |
374730 | 374730 | 2020-07-27 | Adams | Nebraska | 31001 | 328 | 11 |
375108 | 375108 | 2020-07-27 | Adams | Ohio | 39001 | 44 | 2 |
375309 | 375309 | 2020-07-27 | Adams | Pennsylvania | 42001 | 442 | 17 |
376098 | 376098 | 2020-07-27 | Adams | Washington | 53001 | 363 | 1 |
376193 | 376193 | 2020-07-27 | Adams | Wisconsin | 55001 | 62 | 2 |
370105 | 370105 | 2020-07-26 | Adams | Colorado | 8001 | 5587 | 167 |
370416 | 370416 | 2020-07-26 | Adams | Idaho | 16003 | 16 | 0 |
370456 | 370456 | 2020-07-26 | Adams | Illinois | 17001 | 336 | 1 |
370559 | 370559 | 2020-07-26 | Adams | Indiana | 18001 | 71 | 2 |
370652 | 370652 | 2020-07-26 | Adams | Iowa | 19003 | 13 | 0 |
371268 | 371268 | 2020-07-26 | Adams | Mississippi | 28001 | 511 | 22 |
371518 | 371518 | 2020-07-26 | Adams | Nebraska | 31001 | 326 | 11 |
371896 | 371896 | 2020-07-26 | Adams | Ohio | 39001 | 42 | 2 |
372096 | 372096 | 2020-07-26 | Adams | Pennsylvania | 42001 | 442 | 17 |
372884 | 372884 | 2020-07-26 | Adams | Washington | 53001 | 360 | 1 |
372979 | 372979 | 2020-07-26 | Adams | Wisconsin | 55001 | 61 | 2 |
366895 | 366895 | 2020-07-25 | Adams | Colorado | 8001 | 5535 | 167 |
367206 | 367206 | 2020-07-25 | Adams | Idaho | 16003 | 15 | 0 |
367246 | 367246 | 2020-07-25 | Adams | Illinois | 17001 | 324 | 1 |
367349 | 367349 | 2020-07-25 | Adams | Indiana | 18001 | 70 | 2 |
367442 | 367442 | 2020-07-25 | Adams | Iowa | 19003 | 12 | 0 |
368058 | 368058 | 2020-07-25 | Adams | Mississippi | 28001 | 490 | 22 |
368307 | 368307 | 2020-07-25 | Adams | Nebraska | 31001 | 324 | 11 |
368684 | 368684 | 2020-07-25 | Adams | Ohio | 39001 | 40 | 2 |
368884 | 368884 | 2020-07-25 | Adams | Pennsylvania | 42001 | 442 | 17 |
369672 | 369672 | 2020-07-25 | Adams | Washington | 53001 | 342 | 1 |
369767 | 369767 | 2020-07-25 | Adams | Wisconsin | 55001 | 60 | 2 |
363688 | 363688 | 2020-07-24 | Adams | Colorado | 8001 | 5433 | 167 |
363999 | 363999 | 2020-07-24 | Adams | Idaho | 16003 | 15 | 0 |
364039 | 364039 | 2020-07-24 | Adams | Illinois | 17001 | 316 | 1 |
364142 | 364142 | 2020-07-24 | Adams | Indiana | 18001 | 70 | 2 |
364235 | 364235 | 2020-07-24 | Adams | Iowa | 19003 | 12 | 0 |
364850 | 364850 | 2020-07-24 | Adams | Mississippi | 28001 | 480 | 22 |
365098 | 365098 | 2020-07-24 | Adams | Nebraska | 31001 | 323 | 11 |
365475 | 365475 | 2020-07-24 | Adams | Ohio | 39001 | 40 | 2 |
365675 | 365675 | 2020-07-24 | Adams | Pennsylvania | 42001 | 441 | 17 |
366463 | 366463 | 2020-07-24 | Adams | Washington | 53001 | 328 | 0 |
366557 | 366557 | 2020-07-24 | Adams | Wisconsin | 55001 | 56 | 2 |
360481 | 360481 | 2020-07-23 | Adams | Colorado | 8001 | 5312 | 167 |
360792 | 360792 | 2020-07-23 | Adams | Idaho | 16003 | 15 | 0 |
360832 | 360832 | 2020-07-23 | Adams | Illinois | 17001 | 302 | 1 |
360935 | 360935 | 2020-07-23 | Adams | Indiana | 18001 | 67 | 2 |
361028 | 361028 | 2020-07-23 | Adams | Iowa | 19003 | 12 | 0 |
361643 | 361643 | 2020-07-23 | Adams | Mississippi | 28001 | 466 | 22 |
361891 | 361891 | 2020-07-23 | Adams | Nebraska | 31001 | 320 | 11 |
362269 | 362269 | 2020-07-23 | Adams | Ohio | 39001 | 40 | 2 |
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);