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 |
---|---|---|---|---|---|---|---|
636944 | 636944 | 2020-10-16 | Adams | Ohio | 39001 | 187 | 6 |
633698 | 633698 | 2020-10-15 | Adams | Ohio | 39001 | 183 | 6 |
630453 | 630453 | 2020-10-14 | Adams | Ohio | 39001 | 180 | 6 |
627209 | 627209 | 2020-10-13 | Adams | Ohio | 39001 | 178 | 4 |
623967 | 623967 | 2020-10-12 | Adams | Ohio | 39001 | 173 | 4 |
620724 | 620724 | 2020-10-11 | Adams | Ohio | 39001 | 173 | 4 |
617482 | 617482 | 2020-10-10 | Adams | Ohio | 39001 | 169 | 4 |
614240 | 614240 | 2020-10-09 | Adams | Ohio | 39001 | 165 | 4 |
610999 | 610999 | 2020-10-08 | Adams | Ohio | 39001 | 162 | 4 |
607757 | 607757 | 2020-10-07 | Adams | Ohio | 39001 | 160 | 4 |
604514 | 604514 | 2020-10-06 | Adams | Ohio | 39001 | 158 | 4 |
601272 | 601272 | 2020-10-05 | Adams | Ohio | 39001 | 158 | 4 |
598029 | 598029 | 2020-10-04 | Adams | Ohio | 39001 | 153 | 4 |
594786 | 594786 | 2020-10-03 | Adams | Ohio | 39001 | 151 | 4 |
591545 | 591545 | 2020-10-02 | Adams | Ohio | 39001 | 148 | 4 |
588304 | 588304 | 2020-10-01 | Adams | Ohio | 39001 | 144 | 4 |
585064 | 585064 | 2020-09-30 | Adams | Ohio | 39001 | 139 | 4 |
581824 | 581824 | 2020-09-29 | Adams | Ohio | 39001 | 137 | 4 |
578584 | 578584 | 2020-09-28 | Adams | Ohio | 39001 | 136 | 4 |
575343 | 575343 | 2020-09-27 | Adams | Ohio | 39001 | 135 | 4 |
572099 | 572099 | 2020-09-26 | Adams | Ohio | 39001 | 131 | 4 |
568857 | 568857 | 2020-09-25 | Adams | Ohio | 39001 | 129 | 4 |
565616 | 565616 | 2020-09-24 | Adams | Ohio | 39001 | 126 | 4 |
562375 | 562375 | 2020-09-23 | Adams | Ohio | 39001 | 126 | 4 |
559138 | 559138 | 2020-09-22 | Adams | Ohio | 39001 | 123 | 4 |
555901 | 555901 | 2020-09-21 | Adams | Ohio | 39001 | 121 | 4 |
552664 | 552664 | 2020-09-20 | Adams | Ohio | 39001 | 121 | 4 |
549425 | 549425 | 2020-09-19 | Adams | Ohio | 39001 | 120 | 4 |
546186 | 546186 | 2020-09-18 | Adams | Ohio | 39001 | 119 | 4 |
542949 | 542949 | 2020-09-17 | Adams | Ohio | 39001 | 117 | 4 |
539713 | 539713 | 2020-09-16 | Adams | Ohio | 39001 | 114 | 4 |
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 |
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);