ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Mercer" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922550 | 922550 | 2021-01-12 | Mercer | Ohio | 39107 | 4147 | 85 |
919305 | 919305 | 2021-01-11 | Mercer | Ohio | 39107 | 4122 | 85 |
916060 | 916060 | 2021-01-10 | Mercer | Ohio | 39107 | 4112 | 84 |
912815 | 912815 | 2021-01-09 | Mercer | Ohio | 39107 | 4106 | 84 |
909570 | 909570 | 2021-01-08 | Mercer | Ohio | 39107 | 4080 | 84 |
906325 | 906325 | 2021-01-07 | Mercer | Ohio | 39107 | 4070 | 83 |
903079 | 903079 | 2021-01-06 | Mercer | Ohio | 39107 | 4033 | 82 |
899834 | 899834 | 2021-01-05 | Mercer | Ohio | 39107 | 3998 | 82 |
896589 | 896589 | 2021-01-04 | Mercer | Ohio | 39107 | 3973 | 82 |
893343 | 893343 | 2021-01-03 | Mercer | Ohio | 39107 | 3950 | 82 |
890097 | 890097 | 2021-01-02 | Mercer | Ohio | 39107 | 3936 | 82 |
886850 | 886850 | 2021-01-01 | Mercer | Ohio | 39107 | 3911 | 82 |
883605 | 883605 | 2020-12-31 | Mercer | Ohio | 39107 | 3911 | 82 |
880360 | 880360 | 2020-12-30 | Mercer | Ohio | 39107 | 3893 | 81 |
877115 | 877115 | 2020-12-29 | Mercer | Ohio | 39107 | 3863 | 79 |
873870 | 873870 | 2020-12-28 | Mercer | Ohio | 39107 | 3811 | 79 |
870625 | 870625 | 2020-12-27 | Mercer | Ohio | 39107 | 3805 | 79 |
867380 | 867380 | 2020-12-26 | Mercer | Ohio | 39107 | 3789 | 79 |
864135 | 864135 | 2020-12-25 | Mercer | Ohio | 39107 | 3772 | 79 |
860890 | 860890 | 2020-12-24 | Mercer | Ohio | 39107 | 3772 | 79 |
857645 | 857645 | 2020-12-23 | Mercer | Ohio | 39107 | 3743 | 77 |
854400 | 854400 | 2020-12-22 | Mercer | Ohio | 39107 | 3733 | 77 |
851155 | 851155 | 2020-12-21 | Mercer | Ohio | 39107 | 3709 | 76 |
847910 | 847910 | 2020-12-20 | Mercer | Ohio | 39107 | 3700 | 76 |
844665 | 844665 | 2020-12-19 | Mercer | Ohio | 39107 | 3687 | 76 |
841419 | 841419 | 2020-12-18 | Mercer | Ohio | 39107 | 3667 | 76 |
838174 | 838174 | 2020-12-17 | Mercer | Ohio | 39107 | 3645 | 74 |
834928 | 834928 | 2020-12-16 | Mercer | Ohio | 39107 | 3613 | 73 |
831682 | 831682 | 2020-12-15 | Mercer | Ohio | 39107 | 3575 | 72 |
828435 | 828435 | 2020-12-14 | Mercer | Ohio | 39107 | 3547 | 70 |
825189 | 825189 | 2020-12-13 | Mercer | Ohio | 39107 | 3530 | 70 |
821942 | 821942 | 2020-12-12 | Mercer | Ohio | 39107 | 3501 | 70 |
818696 | 818696 | 2020-12-11 | Mercer | Ohio | 39107 | 3485 | 70 |
815450 | 815450 | 2020-12-10 | Mercer | Ohio | 39107 | 3444 | 70 |
812204 | 812204 | 2020-12-09 | Mercer | Ohio | 39107 | 3421 | 68 |
808960 | 808960 | 2020-12-08 | Mercer | Ohio | 39107 | 3365 | 66 |
805715 | 805715 | 2020-12-07 | Mercer | Ohio | 39107 | 3294 | 64 |
802470 | 802470 | 2020-12-06 | Mercer | Ohio | 39107 | 3274 | 64 |
799225 | 799225 | 2020-12-05 | Mercer | Ohio | 39107 | 3262 | 64 |
795980 | 795980 | 2020-12-04 | Mercer | Ohio | 39107 | 3225 | 60 |
792735 | 792735 | 2020-12-03 | Mercer | Ohio | 39107 | 3198 | 59 |
789490 | 789490 | 2020-12-02 | Mercer | Ohio | 39107 | 3169 | 57 |
786245 | 786245 | 2020-12-01 | Mercer | Ohio | 39107 | 3113 | 55 |
783001 | 783001 | 2020-11-30 | Mercer | Ohio | 39107 | 3047 | 52 |
779755 | 779755 | 2020-11-29 | Mercer | Ohio | 39107 | 3024 | 50 |
776510 | 776510 | 2020-11-28 | Mercer | Ohio | 39107 | 3017 | 50 |
773265 | 773265 | 2020-11-27 | Mercer | Ohio | 39107 | 2992 | 48 |
770020 | 770020 | 2020-11-26 | Mercer | Ohio | 39107 | 2960 | 47 |
766774 | 766774 | 2020-11-25 | Mercer | Ohio | 39107 | 2960 | 47 |
763529 | 763529 | 2020-11-24 | Mercer | Ohio | 39107 | 2899 | 45 |
760284 | 760284 | 2020-11-23 | Mercer | Ohio | 39107 | 2847 | 37 |
757039 | 757039 | 2020-11-22 | Mercer | Ohio | 39107 | 2812 | 37 |
753792 | 753792 | 2020-11-21 | Mercer | Ohio | 39107 | 2785 | 37 |
750546 | 750546 | 2020-11-20 | Mercer | Ohio | 39107 | 2745 | 37 |
747300 | 747300 | 2020-11-19 | Mercer | Ohio | 39107 | 2680 | 37 |
744054 | 744054 | 2020-11-18 | Mercer | Ohio | 39107 | 2619 | 37 |
740807 | 740807 | 2020-11-17 | Mercer | Ohio | 39107 | 2544 | 37 |
737561 | 737561 | 2020-11-16 | Mercer | Ohio | 39107 | 2498 | 37 |
734317 | 734317 | 2020-11-15 | Mercer | Ohio | 39107 | 2476 | 37 |
731071 | 731071 | 2020-11-14 | Mercer | Ohio | 39107 | 2455 | 37 |
727827 | 727827 | 2020-11-13 | Mercer | Ohio | 39107 | 2379 | 37 |
724583 | 724583 | 2020-11-12 | Mercer | Ohio | 39107 | 2301 | 35 |
721340 | 721340 | 2020-11-11 | Mercer | Ohio | 39107 | 2191 | 35 |
718097 | 718097 | 2020-11-10 | Mercer | Ohio | 39107 | 2131 | 35 |
714854 | 714854 | 2020-11-09 | Mercer | Ohio | 39107 | 2077 | 33 |
711610 | 711610 | 2020-11-08 | Mercer | Ohio | 39107 | 2067 | 33 |
708366 | 708366 | 2020-11-07 | Mercer | Ohio | 39107 | 2045 | 33 |
705123 | 705123 | 2020-11-06 | Mercer | Ohio | 39107 | 1995 | 33 |
701880 | 701880 | 2020-11-05 | Mercer | Ohio | 39107 | 1943 | 33 |
698636 | 698636 | 2020-11-04 | Mercer | Ohio | 39107 | 1883 | 33 |
695393 | 695393 | 2020-11-03 | Mercer | Ohio | 39107 | 1806 | 31 |
692151 | 692151 | 2020-11-02 | Mercer | Ohio | 39107 | 1775 | 30 |
688907 | 688907 | 2020-11-01 | Mercer | Ohio | 39107 | 1761 | 30 |
685662 | 685662 | 2020-10-31 | Mercer | Ohio | 39107 | 1752 | 30 |
682419 | 682419 | 2020-10-30 | Mercer | Ohio | 39107 | 1729 | 30 |
679176 | 679176 | 2020-10-29 | Mercer | Ohio | 39107 | 1679 | 30 |
675933 | 675933 | 2020-10-28 | Mercer | Ohio | 39107 | 1649 | 30 |
672690 | 672690 | 2020-10-27 | Mercer | Ohio | 39107 | 1616 | 30 |
669448 | 669448 | 2020-10-26 | Mercer | Ohio | 39107 | 1596 | 29 |
666204 | 666204 | 2020-10-25 | Mercer | Ohio | 39107 | 1585 | 28 |
662959 | 662959 | 2020-10-24 | Mercer | Ohio | 39107 | 1582 | 28 |
659715 | 659715 | 2020-10-23 | Mercer | Ohio | 39107 | 1547 | 28 |
656471 | 656471 | 2020-10-22 | Mercer | Ohio | 39107 | 1521 | 28 |
653226 | 653226 | 2020-10-21 | Mercer | Ohio | 39107 | 1505 | 28 |
649981 | 649981 | 2020-10-20 | Mercer | Ohio | 39107 | 1471 | 28 |
646737 | 646737 | 2020-10-19 | Mercer | Ohio | 39107 | 1449 | 27 |
643491 | 643491 | 2020-10-18 | Mercer | Ohio | 39107 | 1433 | 27 |
640243 | 640243 | 2020-10-17 | Mercer | Ohio | 39107 | 1427 | 27 |
636997 | 636997 | 2020-10-16 | Mercer | Ohio | 39107 | 1400 | 27 |
633751 | 633751 | 2020-10-15 | Mercer | Ohio | 39107 | 1380 | 27 |
630506 | 630506 | 2020-10-14 | Mercer | Ohio | 39107 | 1363 | 27 |
627262 | 627262 | 2020-10-13 | Mercer | Ohio | 39107 | 1336 | 27 |
624020 | 624020 | 2020-10-12 | Mercer | Ohio | 39107 | 1317 | 27 |
620777 | 620777 | 2020-10-11 | Mercer | Ohio | 39107 | 1314 | 27 |
617535 | 617535 | 2020-10-10 | Mercer | Ohio | 39107 | 1311 | 27 |
614293 | 614293 | 2020-10-09 | Mercer | Ohio | 39107 | 1295 | 27 |
611052 | 611052 | 2020-10-08 | Mercer | Ohio | 39107 | 1267 | 27 |
607810 | 607810 | 2020-10-07 | Mercer | Ohio | 39107 | 1255 | 21 |
604567 | 604567 | 2020-10-06 | Mercer | Ohio | 39107 | 1242 | 21 |
601325 | 601325 | 2020-10-05 | Mercer | Ohio | 39107 | 1224 | 21 |
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);