ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Adams" and fips = 39001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536476 | 536476 | 2020-09-15 | Adams | Ohio | 39001 | 109 | 4 |
533240 | 533240 | 2020-09-14 | Adams | Ohio | 39001 | 103 | 4 |
530005 | 530005 | 2020-09-13 | Adams | Ohio | 39001 | 100 | 4 |
526768 | 526768 | 2020-09-12 | Adams | Ohio | 39001 | 100 | 4 |
523532 | 523532 | 2020-09-11 | Adams | Ohio | 39001 | 99 | 4 |
520296 | 520296 | 2020-09-10 | Adams | Ohio | 39001 | 99 | 4 |
517060 | 517060 | 2020-09-09 | Adams | Ohio | 39001 | 98 | 4 |
513825 | 513825 | 2020-09-08 | Adams | Ohio | 39001 | 96 | 4 |
510592 | 510592 | 2020-09-07 | Adams | Ohio | 39001 | 96 | 4 |
507359 | 507359 | 2020-09-06 | Adams | Ohio | 39001 | 96 | 4 |
504127 | 504127 | 2020-09-05 | Adams | Ohio | 39001 | 95 | 4 |
500893 | 500893 | 2020-09-04 | Adams | Ohio | 39001 | 95 | 4 |
497659 | 497659 | 2020-09-03 | Adams | Ohio | 39001 | 95 | 4 |
494426 | 494426 | 2020-09-02 | Adams | Ohio | 39001 | 94 | 4 |
491192 | 491192 | 2020-09-01 | Adams | Ohio | 39001 | 93 | 4 |
487959 | 487959 | 2020-08-31 | Adams | Ohio | 39001 | 93 | 4 |
484726 | 484726 | 2020-08-30 | Adams | Ohio | 39001 | 91 | 4 |
481491 | 481491 | 2020-08-29 | Adams | Ohio | 39001 | 91 | 4 |
478257 | 478257 | 2020-08-28 | Adams | Ohio | 39001 | 89 | 4 |
475024 | 475024 | 2020-08-27 | Adams | Ohio | 39001 | 88 | 4 |
471790 | 471790 | 2020-08-26 | Adams | Ohio | 39001 | 86 | 4 |
468558 | 468558 | 2020-08-25 | Adams | Ohio | 39001 | 85 | 4 |
465330 | 465330 | 2020-08-24 | Adams | Ohio | 39001 | 84 | 4 |
462101 | 462101 | 2020-08-23 | Adams | Ohio | 39001 | 84 | 3 |
458873 | 458873 | 2020-08-22 | Adams | Ohio | 39001 | 84 | 3 |
455645 | 455645 | 2020-08-21 | Adams | Ohio | 39001 | 83 | 3 |
452417 | 452417 | 2020-08-20 | Adams | Ohio | 39001 | 79 | 3 |
449189 | 449189 | 2020-08-19 | Adams | Ohio | 39001 | 77 | 3 |
445961 | 445961 | 2020-08-18 | Adams | Ohio | 39001 | 74 | 3 |
442735 | 442735 | 2020-08-17 | Adams | Ohio | 39001 | 72 | 2 |
439508 | 439508 | 2020-08-16 | Adams | Ohio | 39001 | 70 | 2 |
436283 | 436283 | 2020-08-15 | Adams | Ohio | 39001 | 69 | 2 |
433057 | 433057 | 2020-08-14 | Adams | Ohio | 39001 | 68 | 2 |
429831 | 429831 | 2020-08-13 | Adams | Ohio | 39001 | 68 | 2 |
426606 | 426606 | 2020-08-12 | Adams | Ohio | 39001 | 64 | 2 |
423383 | 423383 | 2020-08-11 | Adams | Ohio | 39001 | 61 | 2 |
420160 | 420160 | 2020-08-10 | Adams | Ohio | 39001 | 61 | 2 |
416940 | 416940 | 2020-08-09 | Adams | Ohio | 39001 | 61 | 2 |
413719 | 413719 | 2020-08-08 | Adams | Ohio | 39001 | 59 | 2 |
410499 | 410499 | 2020-08-07 | Adams | Ohio | 39001 | 59 | 2 |
407279 | 407279 | 2020-08-06 | Adams | Ohio | 39001 | 59 | 2 |
404060 | 404060 | 2020-08-05 | Adams | Ohio | 39001 | 59 | 2 |
400842 | 400842 | 2020-08-04 | Adams | Ohio | 39001 | 56 | 2 |
397627 | 397627 | 2020-08-03 | Adams | Ohio | 39001 | 53 | 2 |
394410 | 394410 | 2020-08-02 | Adams | Ohio | 39001 | 53 | 2 |
391194 | 391194 | 2020-08-01 | Adams | Ohio | 39001 | 53 | 2 |
387977 | 387977 | 2020-07-31 | Adams | Ohio | 39001 | 53 | 2 |
384760 | 384760 | 2020-07-30 | Adams | Ohio | 39001 | 53 | 2 |
381542 | 381542 | 2020-07-29 | Adams | Ohio | 39001 | 51 | 2 |
378325 | 378325 | 2020-07-28 | Adams | Ohio | 39001 | 48 | 2 |
375108 | 375108 | 2020-07-27 | Adams | Ohio | 39001 | 44 | 2 |
371896 | 371896 | 2020-07-26 | Adams | Ohio | 39001 | 42 | 2 |
368684 | 368684 | 2020-07-25 | Adams | Ohio | 39001 | 40 | 2 |
365475 | 365475 | 2020-07-24 | Adams | Ohio | 39001 | 40 | 2 |
362269 | 362269 | 2020-07-23 | Adams | Ohio | 39001 | 40 | 2 |
359063 | 359063 | 2020-07-22 | Adams | Ohio | 39001 | 39 | 2 |
355859 | 355859 | 2020-07-21 | Adams | Ohio | 39001 | 37 | 2 |
352656 | 352656 | 2020-07-20 | Adams | Ohio | 39001 | 35 | 2 |
349453 | 349453 | 2020-07-19 | Adams | Ohio | 39001 | 34 | 2 |
346252 | 346252 | 2020-07-18 | Adams | Ohio | 39001 | 32 | 2 |
343053 | 343053 | 2020-07-17 | Adams | Ohio | 39001 | 30 | 2 |
339855 | 339855 | 2020-07-16 | Adams | Ohio | 39001 | 30 | 2 |
336659 | 336659 | 2020-07-15 | Adams | Ohio | 39001 | 30 | 2 |
333465 | 333465 | 2020-07-14 | Adams | Ohio | 39001 | 28 | 2 |
330273 | 330273 | 2020-07-13 | Adams | Ohio | 39001 | 28 | 2 |
327086 | 327086 | 2020-07-12 | Adams | Ohio | 39001 | 26 | 1 |
323901 | 323901 | 2020-07-11 | Adams | Ohio | 39001 | 26 | 1 |
320721 | 320721 | 2020-07-10 | Adams | Ohio | 39001 | 25 | 1 |
317544 | 317544 | 2020-07-09 | Adams | Ohio | 39001 | 24 | 1 |
314371 | 314371 | 2020-07-08 | Adams | Ohio | 39001 | 24 | 1 |
311199 | 311199 | 2020-07-07 | Adams | Ohio | 39001 | 24 | 1 |
308030 | 308030 | 2020-07-06 | Adams | Ohio | 39001 | 24 | 1 |
304863 | 304863 | 2020-07-05 | Adams | Ohio | 39001 | 22 | 1 |
301700 | 301700 | 2020-07-04 | Adams | Ohio | 39001 | 23 | 1 |
298537 | 298537 | 2020-07-03 | Adams | Ohio | 39001 | 22 | 1 |
295377 | 295377 | 2020-07-02 | Adams | Ohio | 39001 | 21 | 1 |
292222 | 292222 | 2020-07-01 | Adams | Ohio | 39001 | 21 | 1 |
289070 | 289070 | 2020-06-30 | Adams | Ohio | 39001 | 21 | 1 |
285920 | 285920 | 2020-06-29 | Adams | Ohio | 39001 | 21 | 1 |
282775 | 282775 | 2020-06-28 | Adams | Ohio | 39001 | 20 | 1 |
279629 | 279629 | 2020-06-27 | Adams | Ohio | 39001 | 20 | 1 |
276481 | 276481 | 2020-06-26 | Adams | Ohio | 39001 | 20 | 1 |
273334 | 273334 | 2020-06-25 | Adams | Ohio | 39001 | 20 | 1 |
270195 | 270195 | 2020-06-24 | Adams | Ohio | 39001 | 19 | 1 |
267061 | 267061 | 2020-06-23 | Adams | Ohio | 39001 | 19 | 1 |
263933 | 263933 | 2020-06-22 | Adams | Ohio | 39001 | 19 | 1 |
260805 | 260805 | 2020-06-21 | Adams | Ohio | 39001 | 18 | 1 |
257678 | 257678 | 2020-06-20 | Adams | Ohio | 39001 | 18 | 1 |
254553 | 254553 | 2020-06-19 | Adams | Ohio | 39001 | 18 | 1 |
251438 | 251438 | 2020-06-18 | Adams | Ohio | 39001 | 18 | 1 |
248323 | 248323 | 2020-06-17 | Adams | Ohio | 39001 | 17 | 1 |
245210 | 245210 | 2020-06-16 | Adams | Ohio | 39001 | 17 | 1 |
242098 | 242098 | 2020-06-15 | Adams | Ohio | 39001 | 15 | 1 |
238989 | 238989 | 2020-06-14 | Adams | Ohio | 39001 | 15 | 1 |
235881 | 235881 | 2020-06-13 | Adams | Ohio | 39001 | 14 | 1 |
232776 | 232776 | 2020-06-12 | Adams | Ohio | 39001 | 12 | 1 |
229671 | 229671 | 2020-06-11 | Adams | Ohio | 39001 | 12 | 1 |
226567 | 226567 | 2020-06-10 | Adams | Ohio | 39001 | 12 | 1 |
223467 | 223467 | 2020-06-09 | Adams | Ohio | 39001 | 11 | 1 |
220372 | 220372 | 2020-06-08 | Adams | Ohio | 39001 | 11 | 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);