ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Franklin" and fips = 39049 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636968 | 636968 | 2020-10-16 | Franklin | Ohio | 39049 | 30157 | 635 |
633722 | 633722 | 2020-10-15 | Franklin | Ohio | 39049 | 29901 | 635 |
630477 | 630477 | 2020-10-14 | Franklin | Ohio | 39049 | 29698 | 635 |
627233 | 627233 | 2020-10-13 | Franklin | Ohio | 39049 | 29507 | 635 |
623991 | 623991 | 2020-10-12 | Franklin | Ohio | 39049 | 29327 | 635 |
620748 | 620748 | 2020-10-11 | Franklin | Ohio | 39049 | 29141 | 635 |
617506 | 617506 | 2020-10-10 | Franklin | Ohio | 39049 | 29005 | 635 |
614264 | 614264 | 2020-10-09 | Franklin | Ohio | 39049 | 28841 | 635 |
611023 | 611023 | 2020-10-08 | Franklin | Ohio | 39049 | 28661 | 633 |
607781 | 607781 | 2020-10-07 | Franklin | Ohio | 39049 | 28520 | 633 |
604538 | 604538 | 2020-10-06 | Franklin | Ohio | 39049 | 28291 | 633 |
601296 | 601296 | 2020-10-05 | Franklin | Ohio | 39049 | 28131 | 631 |
598053 | 598053 | 2020-10-04 | Franklin | Ohio | 39049 | 28014 | 630 |
594810 | 594810 | 2020-10-03 | Franklin | Ohio | 39049 | 27908 | 630 |
591569 | 591569 | 2020-10-02 | Franklin | Ohio | 39049 | 27770 | 629 |
588328 | 588328 | 2020-10-01 | Franklin | Ohio | 39049 | 27600 | 615 |
585088 | 585088 | 2020-09-30 | Franklin | Ohio | 39049 | 27424 | 615 |
581848 | 581848 | 2020-09-29 | Franklin | Ohio | 39049 | 27283 | 615 |
578608 | 578608 | 2020-09-28 | Franklin | Ohio | 39049 | 27119 | 607 |
575367 | 575367 | 2020-09-27 | Franklin | Ohio | 39049 | 26961 | 607 |
572123 | 572123 | 2020-09-26 | Franklin | Ohio | 39049 | 26872 | 607 |
568881 | 568881 | 2020-09-25 | Franklin | Ohio | 39049 | 26704 | 607 |
565640 | 565640 | 2020-09-24 | Franklin | Ohio | 39049 | 26545 | 606 |
562399 | 562399 | 2020-09-23 | Franklin | Ohio | 39049 | 26393 | 606 |
559162 | 559162 | 2020-09-22 | Franklin | Ohio | 39049 | 26242 | 603 |
555925 | 555925 | 2020-09-21 | Franklin | Ohio | 39049 | 26134 | 603 |
552688 | 552688 | 2020-09-20 | Franklin | Ohio | 39049 | 25977 | 603 |
549449 | 549449 | 2020-09-19 | Franklin | Ohio | 39049 | 25846 | 603 |
546210 | 546210 | 2020-09-18 | Franklin | Ohio | 39049 | 25658 | 603 |
542973 | 542973 | 2020-09-17 | Franklin | Ohio | 39049 | 25445 | 600 |
539737 | 539737 | 2020-09-16 | Franklin | Ohio | 39049 | 25274 | 599 |
536500 | 536500 | 2020-09-15 | Franklin | Ohio | 39049 | 25067 | 593 |
533264 | 533264 | 2020-09-14 | Franklin | Ohio | 39049 | 24832 | 579 |
530029 | 530029 | 2020-09-13 | Franklin | Ohio | 39049 | 24590 | 579 |
526792 | 526792 | 2020-09-12 | Franklin | Ohio | 39049 | 24419 | 579 |
523556 | 523556 | 2020-09-11 | Franklin | Ohio | 39049 | 24144 | 577 |
520320 | 520320 | 2020-09-10 | Franklin | Ohio | 39049 | 23994 | 573 |
517084 | 517084 | 2020-09-09 | Franklin | Ohio | 39049 | 23763 | 572 |
513849 | 513849 | 2020-09-08 | Franklin | Ohio | 39049 | 23477 | 570 |
510616 | 510616 | 2020-09-07 | Franklin | Ohio | 39049 | 23295 | 567 |
507383 | 507383 | 2020-09-06 | Franklin | Ohio | 39049 | 23099 | 565 |
504151 | 504151 | 2020-09-05 | Franklin | Ohio | 39049 | 22935 | 565 |
500917 | 500917 | 2020-09-04 | Franklin | Ohio | 39049 | 22629 | 565 |
497683 | 497683 | 2020-09-03 | Franklin | Ohio | 39049 | 22392 | 565 |
494450 | 494450 | 2020-09-02 | Franklin | Ohio | 39049 | 22161 | 563 |
491216 | 491216 | 2020-09-01 | Franklin | Ohio | 39049 | 22005 | 563 |
487983 | 487983 | 2020-08-31 | Franklin | Ohio | 39049 | 21785 | 562 |
484750 | 484750 | 2020-08-30 | Franklin | Ohio | 39049 | 21619 | 562 |
481515 | 481515 | 2020-08-29 | Franklin | Ohio | 39049 | 21497 | 562 |
478281 | 478281 | 2020-08-28 | Franklin | Ohio | 39049 | 21320 | 559 |
475048 | 475048 | 2020-08-27 | Franklin | Ohio | 39049 | 21133 | 556 |
471814 | 471814 | 2020-08-26 | Franklin | Ohio | 39049 | 20954 | 556 |
468582 | 468582 | 2020-08-25 | Franklin | Ohio | 39049 | 20794 | 554 |
465354 | 465354 | 2020-08-24 | Franklin | Ohio | 39049 | 20659 | 554 |
462125 | 462125 | 2020-08-23 | Franklin | Ohio | 39049 | 20534 | 553 |
458897 | 458897 | 2020-08-22 | Franklin | Ohio | 39049 | 20443 | 553 |
455669 | 455669 | 2020-08-21 | Franklin | Ohio | 39049 | 20316 | 551 |
452441 | 452441 | 2020-08-20 | Franklin | Ohio | 39049 | 20150 | 547 |
449213 | 449213 | 2020-08-19 | Franklin | Ohio | 39049 | 19980 | 545 |
445985 | 445985 | 2020-08-18 | Franklin | Ohio | 39049 | 19818 | 542 |
442759 | 442759 | 2020-08-17 | Franklin | Ohio | 39049 | 19683 | 537 |
439532 | 439532 | 2020-08-16 | Franklin | Ohio | 39049 | 19553 | 537 |
436307 | 436307 | 2020-08-15 | Franklin | Ohio | 39049 | 19437 | 537 |
433081 | 433081 | 2020-08-14 | Franklin | Ohio | 39049 | 19287 | 533 |
429855 | 429855 | 2020-08-13 | Franklin | Ohio | 39049 | 19124 | 533 |
426630 | 426630 | 2020-08-12 | Franklin | Ohio | 39049 | 18965 | 531 |
423407 | 423407 | 2020-08-11 | Franklin | Ohio | 39049 | 18697 | 529 |
420184 | 420184 | 2020-08-10 | Franklin | Ohio | 39049 | 18483 | 525 |
416964 | 416964 | 2020-08-09 | Franklin | Ohio | 39049 | 18317 | 524 |
413743 | 413743 | 2020-08-08 | Franklin | Ohio | 39049 | 18182 | 523 |
410523 | 410523 | 2020-08-07 | Franklin | Ohio | 39049 | 18006 | 522 |
407303 | 407303 | 2020-08-06 | Franklin | Ohio | 39049 | 17834 | 521 |
404084 | 404084 | 2020-08-05 | Franklin | Ohio | 39049 | 17619 | 517 |
400866 | 400866 | 2020-08-04 | Franklin | Ohio | 39049 | 17404 | 515 |
397651 | 397651 | 2020-08-03 | Franklin | Ohio | 39049 | 17254 | 514 |
394434 | 394434 | 2020-08-02 | Franklin | Ohio | 39049 | 17107 | 514 |
391218 | 391218 | 2020-08-01 | Franklin | Ohio | 39049 | 16952 | 513 |
388001 | 388001 | 2020-07-31 | Franklin | Ohio | 39049 | 16842 | 511 |
384784 | 384784 | 2020-07-30 | Franklin | Ohio | 39049 | 16630 | 507 |
381566 | 381566 | 2020-07-29 | Franklin | Ohio | 39049 | 16311 | 502 |
378349 | 378349 | 2020-07-28 | Franklin | Ohio | 39049 | 16042 | 496 |
375132 | 375132 | 2020-07-27 | Franklin | Ohio | 39049 | 15862 | 494 |
371920 | 371920 | 2020-07-26 | Franklin | Ohio | 39049 | 15682 | 489 |
368708 | 368708 | 2020-07-25 | Franklin | Ohio | 39049 | 15548 | 487 |
365499 | 365499 | 2020-07-24 | Franklin | Ohio | 39049 | 15301 | 487 |
362293 | 362293 | 2020-07-23 | Franklin | Ohio | 39049 | 14993 | 484 |
359087 | 359087 | 2020-07-22 | Franklin | Ohio | 39049 | 14736 | 478 |
355883 | 355883 | 2020-07-21 | Franklin | Ohio | 39049 | 14432 | 475 |
352680 | 352680 | 2020-07-20 | Franklin | Ohio | 39049 | 14246 | 468 |
349477 | 349477 | 2020-07-19 | Franklin | Ohio | 39049 | 14001 | 467 |
346276 | 346276 | 2020-07-18 | Franklin | Ohio | 39049 | 13778 | 461 |
343077 | 343077 | 2020-07-17 | Franklin | Ohio | 39049 | 13412 | 457 |
339879 | 339879 | 2020-07-16 | Franklin | Ohio | 39049 | 13099 | 456 |
336683 | 336683 | 2020-07-15 | Franklin | Ohio | 39049 | 12823 | 449 |
333489 | 333489 | 2020-07-14 | Franklin | Ohio | 39049 | 12574 | 449 |
330297 | 330297 | 2020-07-13 | Franklin | Ohio | 39049 | 12301 | 449 |
327110 | 327110 | 2020-07-12 | Franklin | Ohio | 39049 | 12035 | 447 |
323925 | 323925 | 2020-07-11 | Franklin | Ohio | 39049 | 11724 | 445 |
320745 | 320745 | 2020-07-10 | Franklin | Ohio | 39049 | 11433 | 443 |
317568 | 317568 | 2020-07-09 | Franklin | Ohio | 39049 | 11122 | 439 |
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);