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 11
- Indiana 97
- Colorado 94
- Nebraska 89
- Pennsylvania 89
- Illinois 87
- Mississippi 87
- Washington 84
- Idaho 75
- Wisconsin 74
- Ohio 72
- Iowa 29
fips 11
county 1
- Adams · 877 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
237608 | 237608 | 2020-06-14 | Adams | Illinois | 17001 | 45 | 1 |
237710 | 237710 | 2020-06-14 | Adams | Indiana | 18001 | 26 | 1 |
237803 | 237803 | 2020-06-14 | Adams | Iowa | 19003 | 7 | 0 |
238403 | 238403 | 2020-06-14 | Adams | Mississippi | 28001 | 225 | 17 |
238628 | 238628 | 2020-06-14 | Adams | Nebraska | 31001 | 278 | 11 |
238989 | 238989 | 2020-06-14 | Adams | Ohio | 39001 | 15 | 1 |
239185 | 239185 | 2020-06-14 | Adams | Pennsylvania | 42001 | 290 | 9 |
239949 | 239949 | 2020-06-14 | Adams | Washington | 53001 | 91 | 0 |
240040 | 240040 | 2020-06-14 | Adams | Wisconsin | 55001 | 8 | 1 |
234159 | 234159 | 2020-06-13 | Adams | Colorado | 8001 | 3729 | 144 |
234467 | 234467 | 2020-06-13 | Adams | Idaho | 16003 | 4 | 0 |
234501 | 234501 | 2020-06-13 | Adams | Illinois | 17001 | 45 | 1 |
234603 | 234603 | 2020-06-13 | Adams | Indiana | 18001 | 25 | 1 |
234696 | 234696 | 2020-06-13 | Adams | Iowa | 19003 | 7 | 0 |
235296 | 235296 | 2020-06-13 | Adams | Mississippi | 28001 | 225 | 17 |
235521 | 235521 | 2020-06-13 | Adams | Nebraska | 31001 | 278 | 11 |
235881 | 235881 | 2020-06-13 | Adams | Ohio | 39001 | 14 | 1 |
236077 | 236077 | 2020-06-13 | Adams | Pennsylvania | 42001 | 289 | 9 |
236841 | 236841 | 2020-06-13 | Adams | Washington | 53001 | 90 | 0 |
236932 | 236932 | 2020-06-13 | Adams | Wisconsin | 55001 | 7 | 1 |
231053 | 231053 | 2020-06-12 | Adams | Colorado | 8001 | 3698 | 143 |
231361 | 231361 | 2020-06-12 | Adams | Idaho | 16003 | 4 | 0 |
231395 | 231395 | 2020-06-12 | Adams | Illinois | 17001 | 45 | 1 |
231497 | 231497 | 2020-06-12 | Adams | Indiana | 18001 | 24 | 1 |
231590 | 231590 | 2020-06-12 | Adams | Iowa | 19003 | 7 | 0 |
232190 | 232190 | 2020-06-12 | Adams | Mississippi | 28001 | 225 | 17 |
232415 | 232415 | 2020-06-12 | Adams | Nebraska | 31001 | 278 | 11 |
232776 | 232776 | 2020-06-12 | Adams | Ohio | 39001 | 12 | 1 |
232972 | 232972 | 2020-06-12 | Adams | Pennsylvania | 42001 | 284 | 9 |
233734 | 233734 | 2020-06-12 | Adams | Washington | 53001 | 89 | 0 |
233825 | 233825 | 2020-06-12 | Adams | Wisconsin | 55001 | 7 | 1 |
227950 | 227950 | 2020-06-11 | Adams | Colorado | 8001 | 3663 | 143 |
228258 | 228258 | 2020-06-11 | Adams | Idaho | 16003 | 3 | 0 |
228292 | 228292 | 2020-06-11 | Adams | Illinois | 17001 | 45 | 1 |
228394 | 228394 | 2020-06-11 | Adams | Indiana | 18001 | 24 | 1 |
228487 | 228487 | 2020-06-11 | Adams | Iowa | 19003 | 7 | 0 |
229086 | 229086 | 2020-06-11 | Adams | Mississippi | 28001 | 222 | 17 |
229310 | 229310 | 2020-06-11 | Adams | Nebraska | 31001 | 277 | 11 |
229671 | 229671 | 2020-06-11 | Adams | Ohio | 39001 | 12 | 1 |
229867 | 229867 | 2020-06-11 | Adams | Pennsylvania | 42001 | 279 | 9 |
230629 | 230629 | 2020-06-11 | Adams | Washington | 53001 | 89 | 0 |
230720 | 230720 | 2020-06-11 | Adams | Wisconsin | 55001 | 6 | 1 |
224848 | 224848 | 2020-06-10 | Adams | Colorado | 8001 | 3643 | 143 |
225156 | 225156 | 2020-06-10 | Adams | Idaho | 16003 | 3 | 0 |
225190 | 225190 | 2020-06-10 | Adams | Illinois | 17001 | 45 | 1 |
225292 | 225292 | 2020-06-10 | Adams | Indiana | 18001 | 24 | 1 |
225385 | 225385 | 2020-06-10 | Adams | Iowa | 19003 | 7 | 0 |
225984 | 225984 | 2020-06-10 | Adams | Mississippi | 28001 | 222 | 17 |
226207 | 226207 | 2020-06-10 | Adams | Nebraska | 31001 | 277 | 11 |
226567 | 226567 | 2020-06-10 | Adams | Ohio | 39001 | 12 | 1 |
226763 | 226763 | 2020-06-10 | Adams | Pennsylvania | 42001 | 278 | 9 |
227525 | 227525 | 2020-06-10 | Adams | Washington | 53001 | 87 | 0 |
227616 | 227616 | 2020-06-10 | Adams | Wisconsin | 55001 | 6 | 1 |
221753 | 221753 | 2020-06-09 | Adams | Colorado | 8001 | 3627 | 140 |
222061 | 222061 | 2020-06-09 | Adams | Idaho | 16003 | 3 | 0 |
222095 | 222095 | 2020-06-09 | Adams | Illinois | 17001 | 45 | 1 |
222197 | 222197 | 2020-06-09 | Adams | Indiana | 18001 | 23 | 1 |
222290 | 222290 | 2020-06-09 | Adams | Iowa | 19003 | 7 | 0 |
222886 | 222886 | 2020-06-09 | Adams | Mississippi | 28001 | 222 | 17 |
223108 | 223108 | 2020-06-09 | Adams | Nebraska | 31001 | 277 | 11 |
223467 | 223467 | 2020-06-09 | Adams | Ohio | 39001 | 11 | 1 |
223663 | 223663 | 2020-06-09 | Adams | Pennsylvania | 42001 | 275 | 9 |
224425 | 224425 | 2020-06-09 | Adams | Washington | 53001 | 80 | 0 |
224516 | 224516 | 2020-06-09 | Adams | Wisconsin | 55001 | 6 | 1 |
218658 | 218658 | 2020-06-08 | Adams | Colorado | 8001 | 3605 | 138 |
218966 | 218966 | 2020-06-08 | Adams | Idaho | 16003 | 3 | 0 |
219000 | 219000 | 2020-06-08 | Adams | Illinois | 17001 | 45 | 1 |
219102 | 219102 | 2020-06-08 | Adams | Indiana | 18001 | 22 | 1 |
219195 | 219195 | 2020-06-08 | Adams | Iowa | 19003 | 7 | 0 |
219791 | 219791 | 2020-06-08 | Adams | Mississippi | 28001 | 222 | 17 |
220013 | 220013 | 2020-06-08 | Adams | Nebraska | 31001 | 276 | 11 |
220372 | 220372 | 2020-06-08 | Adams | Ohio | 39001 | 11 | 1 |
220568 | 220568 | 2020-06-08 | Adams | Pennsylvania | 42001 | 275 | 8 |
221329 | 221329 | 2020-06-08 | Adams | Washington | 53001 | 79 | 0 |
221420 | 221420 | 2020-06-08 | Adams | Wisconsin | 55001 | 5 | 1 |
215567 | 215567 | 2020-06-07 | Adams | Colorado | 8001 | 3575 | 136 |
215875 | 215875 | 2020-06-07 | Adams | Idaho | 16003 | 3 | 0 |
215909 | 215909 | 2020-06-07 | Adams | Illinois | 17001 | 46 | 1 |
216010 | 216010 | 2020-06-07 | Adams | Indiana | 18001 | 22 | 1 |
216103 | 216103 | 2020-06-07 | Adams | Iowa | 19003 | 7 | 0 |
216699 | 216699 | 2020-06-07 | Adams | Mississippi | 28001 | 204 | 16 |
216921 | 216921 | 2020-06-07 | Adams | Nebraska | 31001 | 275 | 11 |
217280 | 217280 | 2020-06-07 | Adams | Ohio | 39001 | 11 | 1 |
217476 | 217476 | 2020-06-07 | Adams | Pennsylvania | 42001 | 273 | 8 |
218237 | 218237 | 2020-06-07 | Adams | Washington | 53001 | 79 | 0 |
218328 | 218328 | 2020-06-07 | Adams | Wisconsin | 55001 | 5 | 1 |
212480 | 212480 | 2020-06-06 | Adams | Colorado | 8001 | 3552 | 136 |
212788 | 212788 | 2020-06-06 | Adams | Idaho | 16003 | 3 | 0 |
212822 | 212822 | 2020-06-06 | Adams | Illinois | 17001 | 46 | 1 |
212923 | 212923 | 2020-06-06 | Adams | Indiana | 18001 | 22 | 1 |
213016 | 213016 | 2020-06-06 | Adams | Iowa | 19003 | 7 | 0 |
213611 | 213611 | 2020-06-06 | Adams | Mississippi | 28001 | 203 | 16 |
213832 | 213832 | 2020-06-06 | Adams | Nebraska | 31001 | 275 | 11 |
214190 | 214190 | 2020-06-06 | Adams | Ohio | 39001 | 11 | 1 |
214386 | 214386 | 2020-06-06 | Adams | Pennsylvania | 42001 | 269 | 8 |
215147 | 215147 | 2020-06-06 | Adams | Washington | 53001 | 79 | 0 |
215238 | 215238 | 2020-06-06 | Adams | Wisconsin | 55001 | 5 | 1 |
209395 | 209395 | 2020-06-05 | Adams | Colorado | 8001 | 3515 | 135 |
209703 | 209703 | 2020-06-05 | Adams | Idaho | 16003 | 3 | 0 |
209737 | 209737 | 2020-06-05 | Adams | Illinois | 17001 | 44 | 1 |
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);