ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Morgan" and state = "Ohio" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
336716 | 336716 | 2020-07-15 | Morgan | Ohio | 39115 | 13 | 0 |
339912 | 339912 | 2020-07-16 | Morgan | Ohio | 39115 | 13 | 0 |
343110 | 343110 | 2020-07-17 | Morgan | Ohio | 39115 | 14 | 0 |
346309 | 346309 | 2020-07-18 | Morgan | Ohio | 39115 | 14 | 0 |
349510 | 349510 | 2020-07-19 | Morgan | Ohio | 39115 | 14 | 0 |
352713 | 352713 | 2020-07-20 | Morgan | Ohio | 39115 | 14 | 0 |
355916 | 355916 | 2020-07-21 | Morgan | Ohio | 39115 | 15 | 0 |
359120 | 359120 | 2020-07-22 | Morgan | Ohio | 39115 | 15 | 0 |
362326 | 362326 | 2020-07-23 | Morgan | Ohio | 39115 | 16 | 0 |
365532 | 365532 | 2020-07-24 | Morgan | Ohio | 39115 | 16 | 0 |
368741 | 368741 | 2020-07-25 | Morgan | Ohio | 39115 | 16 | 0 |
371953 | 371953 | 2020-07-26 | Morgan | Ohio | 39115 | 16 | 0 |
375165 | 375165 | 2020-07-27 | Morgan | Ohio | 39115 | 16 | 0 |
378382 | 378382 | 2020-07-28 | Morgan | Ohio | 39115 | 17 | 0 |
381599 | 381599 | 2020-07-29 | Morgan | Ohio | 39115 | 17 | 0 |
384817 | 384817 | 2020-07-30 | Morgan | Ohio | 39115 | 17 | 0 |
388034 | 388034 | 2020-07-31 | Morgan | Ohio | 39115 | 17 | 0 |
391251 | 391251 | 2020-08-01 | Morgan | Ohio | 39115 | 18 | 0 |
394467 | 394467 | 2020-08-02 | Morgan | Ohio | 39115 | 20 | 0 |
397684 | 397684 | 2020-08-03 | Morgan | Ohio | 39115 | 20 | 0 |
400899 | 400899 | 2020-08-04 | Morgan | Ohio | 39115 | 20 | 0 |
404117 | 404117 | 2020-08-05 | Morgan | Ohio | 39115 | 21 | 0 |
407336 | 407336 | 2020-08-06 | Morgan | Ohio | 39115 | 23 | 0 |
410556 | 410556 | 2020-08-07 | Morgan | Ohio | 39115 | 25 | 0 |
413776 | 413776 | 2020-08-08 | Morgan | Ohio | 39115 | 25 | 0 |
416997 | 416997 | 2020-08-09 | Morgan | Ohio | 39115 | 26 | 0 |
420217 | 420217 | 2020-08-10 | Morgan | Ohio | 39115 | 28 | 0 |
423440 | 423440 | 2020-08-11 | Morgan | Ohio | 39115 | 30 | 0 |
426663 | 426663 | 2020-08-12 | Morgan | Ohio | 39115 | 30 | 0 |
429888 | 429888 | 2020-08-13 | Morgan | Ohio | 39115 | 31 | 0 |
433114 | 433114 | 2020-08-14 | Morgan | Ohio | 39115 | 32 | 0 |
436340 | 436340 | 2020-08-15 | Morgan | Ohio | 39115 | 33 | 0 |
439565 | 439565 | 2020-08-16 | Morgan | Ohio | 39115 | 33 | 0 |
442792 | 442792 | 2020-08-17 | Morgan | Ohio | 39115 | 33 | 0 |
446018 | 446018 | 2020-08-18 | Morgan | Ohio | 39115 | 35 | 0 |
449246 | 449246 | 2020-08-19 | Morgan | Ohio | 39115 | 36 | 0 |
452474 | 452474 | 2020-08-20 | Morgan | Ohio | 39115 | 39 | 0 |
455702 | 455702 | 2020-08-21 | Morgan | Ohio | 39115 | 40 | 0 |
458930 | 458930 | 2020-08-22 | Morgan | Ohio | 39115 | 41 | 0 |
462158 | 462158 | 2020-08-23 | Morgan | Ohio | 39115 | 41 | 0 |
465387 | 465387 | 2020-08-24 | Morgan | Ohio | 39115 | 43 | 0 |
468615 | 468615 | 2020-08-25 | Morgan | Ohio | 39115 | 43 | 0 |
471847 | 471847 | 2020-08-26 | Morgan | Ohio | 39115 | 43 | 0 |
475081 | 475081 | 2020-08-27 | Morgan | Ohio | 39115 | 43 | 0 |
478314 | 478314 | 2020-08-28 | Morgan | Ohio | 39115 | 43 | 0 |
481548 | 481548 | 2020-08-29 | Morgan | Ohio | 39115 | 43 | 0 |
484783 | 484783 | 2020-08-30 | Morgan | Ohio | 39115 | 43 | 0 |
488016 | 488016 | 2020-08-31 | Morgan | Ohio | 39115 | 44 | 0 |
491249 | 491249 | 2020-09-01 | Morgan | Ohio | 39115 | 44 | 0 |
494483 | 494483 | 2020-09-02 | Morgan | Ohio | 39115 | 44 | 0 |
497716 | 497716 | 2020-09-03 | Morgan | Ohio | 39115 | 45 | 0 |
500950 | 500950 | 2020-09-04 | Morgan | Ohio | 39115 | 45 | 0 |
504184 | 504184 | 2020-09-05 | Morgan | Ohio | 39115 | 45 | 0 |
507416 | 507416 | 2020-09-06 | Morgan | Ohio | 39115 | 45 | 0 |
510649 | 510649 | 2020-09-07 | Morgan | Ohio | 39115 | 45 | 0 |
513882 | 513882 | 2020-09-08 | Morgan | Ohio | 39115 | 45 | 0 |
517117 | 517117 | 2020-09-09 | Morgan | Ohio | 39115 | 45 | 0 |
520353 | 520353 | 2020-09-10 | Morgan | Ohio | 39115 | 45 | 0 |
536533 | 536533 | 2020-09-15 | Morgan | Ohio | 39115 | 45 | 0 |
523589 | 523589 | 2020-09-11 | Morgan | Ohio | 39115 | 46 | 0 |
526825 | 526825 | 2020-09-12 | Morgan | Ohio | 39115 | 46 | 0 |
530062 | 530062 | 2020-09-13 | Morgan | Ohio | 39115 | 46 | 0 |
533297 | 533297 | 2020-09-14 | Morgan | Ohio | 39115 | 46 | 0 |
539770 | 539770 | 2020-09-16 | Morgan | Ohio | 39115 | 46 | 0 |
543006 | 543006 | 2020-09-17 | Morgan | Ohio | 39115 | 46 | 0 |
549482 | 549482 | 2020-09-19 | Morgan | Ohio | 39115 | 46 | 0 |
546243 | 546243 | 2020-09-18 | Morgan | Ohio | 39115 | 47 | 0 |
552721 | 552721 | 2020-09-20 | Morgan | Ohio | 39115 | 47 | 0 |
555958 | 555958 | 2020-09-21 | Morgan | Ohio | 39115 | 47 | 0 |
559195 | 559195 | 2020-09-22 | Morgan | Ohio | 39115 | 47 | 0 |
562432 | 562432 | 2020-09-23 | Morgan | Ohio | 39115 | 47 | 0 |
565673 | 565673 | 2020-09-24 | Morgan | Ohio | 39115 | 47 | 0 |
568914 | 568914 | 2020-09-25 | Morgan | Ohio | 39115 | 47 | 0 |
572156 | 572156 | 2020-09-26 | Morgan | Ohio | 39115 | 47 | 0 |
575400 | 575400 | 2020-09-27 | Morgan | Ohio | 39115 | 49 | 0 |
578641 | 578641 | 2020-09-28 | Morgan | Ohio | 39115 | 50 | 0 |
581881 | 581881 | 2020-09-29 | Morgan | Ohio | 39115 | 50 | 0 |
585121 | 585121 | 2020-09-30 | Morgan | Ohio | 39115 | 51 | 0 |
588361 | 588361 | 2020-10-01 | Morgan | Ohio | 39115 | 51 | 0 |
591602 | 591602 | 2020-10-02 | Morgan | Ohio | 39115 | 51 | 0 |
594843 | 594843 | 2020-10-03 | Morgan | Ohio | 39115 | 51 | 0 |
598086 | 598086 | 2020-10-04 | Morgan | Ohio | 39115 | 52 | 0 |
601329 | 601329 | 2020-10-05 | Morgan | Ohio | 39115 | 53 | 0 |
604571 | 604571 | 2020-10-06 | Morgan | Ohio | 39115 | 55 | 0 |
607814 | 607814 | 2020-10-07 | Morgan | Ohio | 39115 | 55 | 0 |
611056 | 611056 | 2020-10-08 | Morgan | Ohio | 39115 | 55 | 0 |
614297 | 614297 | 2020-10-09 | Morgan | Ohio | 39115 | 57 | 0 |
617539 | 617539 | 2020-10-10 | Morgan | Ohio | 39115 | 57 | 0 |
620781 | 620781 | 2020-10-11 | Morgan | Ohio | 39115 | 57 | 0 |
627266 | 627266 | 2020-10-13 | Morgan | Ohio | 39115 | 59 | 0 |
624024 | 624024 | 2020-10-12 | Morgan | Ohio | 39115 | 60 | 0 |
630510 | 630510 | 2020-10-14 | Morgan | Ohio | 39115 | 61 | 0 |
633755 | 633755 | 2020-10-15 | Morgan | Ohio | 39115 | 63 | 0 |
637001 | 637001 | 2020-10-16 | Morgan | Ohio | 39115 | 65 | 0 |
640247 | 640247 | 2020-10-17 | Morgan | Ohio | 39115 | 66 | 0 |
643495 | 643495 | 2020-10-18 | Morgan | Ohio | 39115 | 69 | 0 |
646741 | 646741 | 2020-10-19 | Morgan | Ohio | 39115 | 71 | 0 |
649985 | 649985 | 2020-10-20 | Morgan | Ohio | 39115 | 74 | 0 |
653230 | 653230 | 2020-10-21 | Morgan | Ohio | 39115 | 77 | 0 |
656475 | 656475 | 2020-10-22 | Morgan | Ohio | 39115 | 78 | 0 |
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);