ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 39101 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922547 | 922547 | 2021-01-12 | Marion | Ohio | 39101 | 7161 | 111 |
919302 | 919302 | 2021-01-11 | Marion | Ohio | 39101 | 7121 | 111 |
916057 | 916057 | 2021-01-10 | Marion | Ohio | 39101 | 7080 | 111 |
912812 | 912812 | 2021-01-09 | Marion | Ohio | 39101 | 7056 | 111 |
909567 | 909567 | 2021-01-08 | Marion | Ohio | 39101 | 7018 | 111 |
906322 | 906322 | 2021-01-07 | Marion | Ohio | 39101 | 6983 | 110 |
903076 | 903076 | 2021-01-06 | Marion | Ohio | 39101 | 6938 | 106 |
899831 | 899831 | 2021-01-05 | Marion | Ohio | 39101 | 6912 | 106 |
896586 | 896586 | 2021-01-04 | Marion | Ohio | 39101 | 6872 | 106 |
893340 | 893340 | 2021-01-03 | Marion | Ohio | 39101 | 6834 | 106 |
890094 | 890094 | 2021-01-02 | Marion | Ohio | 39101 | 6793 | 106 |
886847 | 886847 | 2021-01-01 | Marion | Ohio | 39101 | 6733 | 105 |
883602 | 883602 | 2020-12-31 | Marion | Ohio | 39101 | 6733 | 105 |
880357 | 880357 | 2020-12-30 | Marion | Ohio | 39101 | 6684 | 105 |
877112 | 877112 | 2020-12-29 | Marion | Ohio | 39101 | 6631 | 104 |
873867 | 873867 | 2020-12-28 | Marion | Ohio | 39101 | 6601 | 102 |
870622 | 870622 | 2020-12-27 | Marion | Ohio | 39101 | 6575 | 102 |
867377 | 867377 | 2020-12-26 | Marion | Ohio | 39101 | 6533 | 102 |
864132 | 864132 | 2020-12-25 | Marion | Ohio | 39101 | 6479 | 102 |
860887 | 860887 | 2020-12-24 | Marion | Ohio | 39101 | 6479 | 102 |
857642 | 857642 | 2020-12-23 | Marion | Ohio | 39101 | 6421 | 100 |
854397 | 854397 | 2020-12-22 | Marion | Ohio | 39101 | 6379 | 96 |
851152 | 851152 | 2020-12-21 | Marion | Ohio | 39101 | 6326 | 96 |
847907 | 847907 | 2020-12-20 | Marion | Ohio | 39101 | 6289 | 93 |
844662 | 844662 | 2020-12-19 | Marion | Ohio | 39101 | 6221 | 93 |
841416 | 841416 | 2020-12-18 | Marion | Ohio | 39101 | 6185 | 91 |
838171 | 838171 | 2020-12-17 | Marion | Ohio | 39101 | 6136 | 88 |
834925 | 834925 | 2020-12-16 | Marion | Ohio | 39101 | 6080 | 86 |
831679 | 831679 | 2020-12-15 | Marion | Ohio | 39101 | 6040 | 84 |
828432 | 828432 | 2020-12-14 | Marion | Ohio | 39101 | 5995 | 82 |
825186 | 825186 | 2020-12-13 | Marion | Ohio | 39101 | 5940 | 80 |
821939 | 821939 | 2020-12-12 | Marion | Ohio | 39101 | 5862 | 79 |
818693 | 818693 | 2020-12-11 | Marion | Ohio | 39101 | 5726 | 74 |
815447 | 815447 | 2020-12-10 | Marion | Ohio | 39101 | 5683 | 71 |
812201 | 812201 | 2020-12-09 | Marion | Ohio | 39101 | 5617 | 71 |
808957 | 808957 | 2020-12-08 | Marion | Ohio | 39101 | 5576 | 69 |
805712 | 805712 | 2020-12-07 | Marion | Ohio | 39101 | 5418 | 69 |
802467 | 802467 | 2020-12-06 | Marion | Ohio | 39101 | 5360 | 69 |
799222 | 799222 | 2020-12-05 | Marion | Ohio | 39101 | 5332 | 69 |
795977 | 795977 | 2020-12-04 | Marion | Ohio | 39101 | 5277 | 69 |
792732 | 792732 | 2020-12-03 | Marion | Ohio | 39101 | 5230 | 67 |
789487 | 789487 | 2020-12-02 | Marion | Ohio | 39101 | 5161 | 67 |
786242 | 786242 | 2020-12-01 | Marion | Ohio | 39101 | 5114 | 67 |
782998 | 782998 | 2020-11-30 | Marion | Ohio | 39101 | 5050 | 61 |
779752 | 779752 | 2020-11-29 | Marion | Ohio | 39101 | 4984 | 60 |
776507 | 776507 | 2020-11-28 | Marion | Ohio | 39101 | 4938 | 59 |
773262 | 773262 | 2020-11-27 | Marion | Ohio | 39101 | 4893 | 59 |
770017 | 770017 | 2020-11-26 | Marion | Ohio | 39101 | 4767 | 59 |
766771 | 766771 | 2020-11-25 | Marion | Ohio | 39101 | 4767 | 59 |
763526 | 763526 | 2020-11-24 | Marion | Ohio | 39101 | 4652 | 51 |
760281 | 760281 | 2020-11-23 | Marion | Ohio | 39101 | 4577 | 51 |
757036 | 757036 | 2020-11-22 | Marion | Ohio | 39101 | 4514 | 51 |
753789 | 753789 | 2020-11-21 | Marion | Ohio | 39101 | 4462 | 51 |
750543 | 750543 | 2020-11-20 | Marion | Ohio | 39101 | 4374 | 51 |
747297 | 747297 | 2020-11-19 | Marion | Ohio | 39101 | 4323 | 51 |
744051 | 744051 | 2020-11-18 | Marion | Ohio | 39101 | 4267 | 51 |
740804 | 740804 | 2020-11-17 | Marion | Ohio | 39101 | 4191 | 51 |
737558 | 737558 | 2020-11-16 | Marion | Ohio | 39101 | 4151 | 51 |
734314 | 734314 | 2020-11-15 | Marion | Ohio | 39101 | 4098 | 51 |
731068 | 731068 | 2020-11-14 | Marion | Ohio | 39101 | 4047 | 51 |
727824 | 727824 | 2020-11-13 | Marion | Ohio | 39101 | 4008 | 51 |
724580 | 724580 | 2020-11-12 | Marion | Ohio | 39101 | 3950 | 51 |
721337 | 721337 | 2020-11-11 | Marion | Ohio | 39101 | 3907 | 51 |
718094 | 718094 | 2020-11-10 | Marion | Ohio | 39101 | 3844 | 50 |
714851 | 714851 | 2020-11-09 | Marion | Ohio | 39101 | 3797 | 50 |
711607 | 711607 | 2020-11-08 | Marion | Ohio | 39101 | 3772 | 50 |
708363 | 708363 | 2020-11-07 | Marion | Ohio | 39101 | 3740 | 50 |
705120 | 705120 | 2020-11-06 | Marion | Ohio | 39101 | 3705 | 50 |
701877 | 701877 | 2020-11-05 | Marion | Ohio | 39101 | 3668 | 50 |
698633 | 698633 | 2020-11-04 | Marion | Ohio | 39101 | 3651 | 50 |
695390 | 695390 | 2020-11-03 | Marion | Ohio | 39101 | 3624 | 50 |
692148 | 692148 | 2020-11-02 | Marion | Ohio | 39101 | 3603 | 50 |
688904 | 688904 | 2020-11-01 | Marion | Ohio | 39101 | 3585 | 50 |
685659 | 685659 | 2020-10-31 | Marion | Ohio | 39101 | 3547 | 50 |
682416 | 682416 | 2020-10-30 | Marion | Ohio | 39101 | 3546 | 50 |
679173 | 679173 | 2020-10-29 | Marion | Ohio | 39101 | 3529 | 50 |
675930 | 675930 | 2020-10-28 | Marion | Ohio | 39101 | 3505 | 50 |
672687 | 672687 | 2020-10-27 | Marion | Ohio | 39101 | 3487 | 50 |
669445 | 669445 | 2020-10-26 | Marion | Ohio | 39101 | 3456 | 50 |
666201 | 666201 | 2020-10-25 | Marion | Ohio | 39101 | 3443 | 50 |
662956 | 662956 | 2020-10-24 | Marion | Ohio | 39101 | 3427 | 50 |
659712 | 659712 | 2020-10-23 | Marion | Ohio | 39101 | 3412 | 50 |
656468 | 656468 | 2020-10-22 | Marion | Ohio | 39101 | 3388 | 50 |
653223 | 653223 | 2020-10-21 | Marion | Ohio | 39101 | 3375 | 50 |
649978 | 649978 | 2020-10-20 | Marion | Ohio | 39101 | 3351 | 49 |
646734 | 646734 | 2020-10-19 | Marion | Ohio | 39101 | 3330 | 49 |
643488 | 643488 | 2020-10-18 | Marion | Ohio | 39101 | 3321 | 49 |
640240 | 640240 | 2020-10-17 | Marion | Ohio | 39101 | 3310 | 49 |
636994 | 636994 | 2020-10-16 | Marion | Ohio | 39101 | 3300 | 48 |
633748 | 633748 | 2020-10-15 | Marion | Ohio | 39101 | 3289 | 48 |
630503 | 630503 | 2020-10-14 | Marion | Ohio | 39101 | 3281 | 48 |
627259 | 627259 | 2020-10-13 | Marion | Ohio | 39101 | 3263 | 48 |
624017 | 624017 | 2020-10-12 | Marion | Ohio | 39101 | 3255 | 48 |
620774 | 620774 | 2020-10-11 | Marion | Ohio | 39101 | 3247 | 48 |
617532 | 617532 | 2020-10-10 | Marion | Ohio | 39101 | 3236 | 48 |
614290 | 614290 | 2020-10-09 | Marion | Ohio | 39101 | 3227 | 48 |
611049 | 611049 | 2020-10-08 | Marion | Ohio | 39101 | 3216 | 48 |
607807 | 607807 | 2020-10-07 | Marion | Ohio | 39101 | 3203 | 48 |
604564 | 604564 | 2020-10-06 | Marion | Ohio | 39101 | 3193 | 48 |
601322 | 601322 | 2020-10-05 | Marion | Ohio | 39101 | 3185 | 48 |
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);