ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 39035 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922514 | 922514 | 2021-01-12 | Cuyahoga | Ohio | 39035 | 78970 | 961 |
919269 | 919269 | 2021-01-11 | Cuyahoga | Ohio | 39035 | 78231 | 955 |
916024 | 916024 | 2021-01-10 | Cuyahoga | Ohio | 39035 | 77359 | 955 |
912779 | 912779 | 2021-01-09 | Cuyahoga | Ohio | 39035 | 76667 | 938 |
909534 | 909534 | 2021-01-08 | Cuyahoga | Ohio | 39035 | 75837 | 937 |
906289 | 906289 | 2021-01-07 | Cuyahoga | Ohio | 39035 | 75120 | 933 |
903043 | 903043 | 2021-01-06 | Cuyahoga | Ohio | 39035 | 74199 | 931 |
899798 | 899798 | 2021-01-05 | Cuyahoga | Ohio | 39035 | 73664 | 914 |
896553 | 896553 | 2021-01-04 | Cuyahoga | Ohio | 39035 | 73116 | 908 |
893307 | 893307 | 2021-01-03 | Cuyahoga | Ohio | 39035 | 72520 | 900 |
890061 | 890061 | 2021-01-02 | Cuyahoga | Ohio | 39035 | 71742 | 899 |
886814 | 886814 | 2021-01-01 | Cuyahoga | Ohio | 39035 | 70137 | 897 |
883569 | 883569 | 2020-12-31 | Cuyahoga | Ohio | 39035 | 70137 | 897 |
880324 | 880324 | 2020-12-30 | Cuyahoga | Ohio | 39035 | 69251 | 895 |
877079 | 877079 | 2020-12-29 | Cuyahoga | Ohio | 39035 | 68535 | 888 |
873834 | 873834 | 2020-12-28 | Cuyahoga | Ohio | 39035 | 67828 | 886 |
870589 | 870589 | 2020-12-27 | Cuyahoga | Ohio | 39035 | 67417 | 877 |
867344 | 867344 | 2020-12-26 | Cuyahoga | Ohio | 39035 | 66821 | 877 |
864099 | 864099 | 2020-12-25 | Cuyahoga | Ohio | 39035 | 65552 | 875 |
860854 | 860854 | 2020-12-24 | Cuyahoga | Ohio | 39035 | 65552 | 875 |
857609 | 857609 | 2020-12-23 | Cuyahoga | Ohio | 39035 | 64653 | 874 |
854364 | 854364 | 2020-12-22 | Cuyahoga | Ohio | 39035 | 63720 | 872 |
851119 | 851119 | 2020-12-21 | Cuyahoga | Ohio | 39035 | 63047 | 863 |
847874 | 847874 | 2020-12-20 | Cuyahoga | Ohio | 39035 | 62366 | 835 |
844629 | 844629 | 2020-12-19 | Cuyahoga | Ohio | 39035 | 61201 | 843 |
841383 | 841383 | 2020-12-18 | Cuyahoga | Ohio | 39035 | 60299 | 842 |
838138 | 838138 | 2020-12-17 | Cuyahoga | Ohio | 39035 | 59363 | 842 |
834892 | 834892 | 2020-12-16 | Cuyahoga | Ohio | 39035 | 58427 | 832 |
831646 | 831646 | 2020-12-15 | Cuyahoga | Ohio | 39035 | 58055 | 831 |
828399 | 828399 | 2020-12-14 | Cuyahoga | Ohio | 39035 | 57303 | 825 |
825153 | 825153 | 2020-12-13 | Cuyahoga | Ohio | 39035 | 56505 | 824 |
821906 | 821906 | 2020-12-12 | Cuyahoga | Ohio | 39035 | 55093 | 828 |
818660 | 818660 | 2020-12-11 | Cuyahoga | Ohio | 39035 | 53832 | 822 |
815414 | 815414 | 2020-12-10 | Cuyahoga | Ohio | 39035 | 52712 | 802 |
812168 | 812168 | 2020-12-09 | Cuyahoga | Ohio | 39035 | 51476 | 785 |
808924 | 808924 | 2020-12-08 | Cuyahoga | Ohio | 39035 | 50412 | 780 |
805679 | 805679 | 2020-12-07 | Cuyahoga | Ohio | 39035 | 47701 | 786 |
802434 | 802434 | 2020-12-06 | Cuyahoga | Ohio | 39035 | 46333 | 781 |
799189 | 799189 | 2020-12-05 | Cuyahoga | Ohio | 39035 | 45412 | 783 |
795944 | 795944 | 2020-12-04 | Cuyahoga | Ohio | 39035 | 44501 | 780 |
792699 | 792699 | 2020-12-03 | Cuyahoga | Ohio | 39035 | 43640 | 768 |
789454 | 789454 | 2020-12-02 | Cuyahoga | Ohio | 39035 | 42980 | 771 |
786209 | 786209 | 2020-12-01 | Cuyahoga | Ohio | 39035 | 42270 | 756 |
782965 | 782965 | 2020-11-30 | Cuyahoga | Ohio | 39035 | 41446 | 746 |
779719 | 779719 | 2020-11-29 | Cuyahoga | Ohio | 39035 | 40823 | 745 |
776474 | 776474 | 2020-11-28 | Cuyahoga | Ohio | 39035 | 39654 | 745 |
773229 | 773229 | 2020-11-27 | Cuyahoga | Ohio | 39035 | 39132 | 746 |
769984 | 769984 | 2020-11-26 | Cuyahoga | Ohio | 39035 | 37222 | 743 |
766738 | 766738 | 2020-11-25 | Cuyahoga | Ohio | 39035 | 37222 | 743 |
763493 | 763493 | 2020-11-24 | Cuyahoga | Ohio | 39035 | 36047 | 741 |
760248 | 760248 | 2020-11-23 | Cuyahoga | Ohio | 39035 | 35214 | 736 |
757003 | 757003 | 2020-11-22 | Cuyahoga | Ohio | 39035 | 34096 | 734 |
753756 | 753756 | 2020-11-21 | Cuyahoga | Ohio | 39035 | 32905 | 734 |
750510 | 750510 | 2020-11-20 | Cuyahoga | Ohio | 39035 | 32296 | 734 |
747264 | 747264 | 2020-11-19 | Cuyahoga | Ohio | 39035 | 31895 | 720 |
744018 | 744018 | 2020-11-18 | Cuyahoga | Ohio | 39035 | 31140 | 719 |
740771 | 740771 | 2020-11-17 | Cuyahoga | Ohio | 39035 | 30581 | 720 |
737525 | 737525 | 2020-11-16 | Cuyahoga | Ohio | 39035 | 29952 | 720 |
734281 | 734281 | 2020-11-15 | Cuyahoga | Ohio | 39035 | 29234 | 719 |
731035 | 731035 | 2020-11-14 | Cuyahoga | Ohio | 39035 | 28252 | 719 |
727791 | 727791 | 2020-11-13 | Cuyahoga | Ohio | 39035 | 27591 | 718 |
724547 | 724547 | 2020-11-12 | Cuyahoga | Ohio | 39035 | 26880 | 714 |
721304 | 721304 | 2020-11-11 | Cuyahoga | Ohio | 39035 | 26048 | 715 |
718061 | 718061 | 2020-11-10 | Cuyahoga | Ohio | 39035 | 25511 | 712 |
714818 | 714818 | 2020-11-09 | Cuyahoga | Ohio | 39035 | 24885 | 712 |
711574 | 711574 | 2020-11-08 | Cuyahoga | Ohio | 39035 | 24391 | 709 |
708330 | 708330 | 2020-11-07 | Cuyahoga | Ohio | 39035 | 23887 | 702 |
705087 | 705087 | 2020-11-06 | Cuyahoga | Ohio | 39035 | 23406 | 700 |
701844 | 701844 | 2020-11-05 | Cuyahoga | Ohio | 39035 | 23023 | 696 |
698600 | 698600 | 2020-11-04 | Cuyahoga | Ohio | 39035 | 22586 | 693 |
695357 | 695357 | 2020-11-03 | Cuyahoga | Ohio | 39035 | 22268 | 693 |
692115 | 692115 | 2020-11-02 | Cuyahoga | Ohio | 39035 | 21893 | 690 |
688871 | 688871 | 2020-11-01 | Cuyahoga | Ohio | 39035 | 21777 | 686 |
685626 | 685626 | 2020-10-31 | Cuyahoga | Ohio | 39035 | 21488 | 686 |
682383 | 682383 | 2020-10-30 | Cuyahoga | Ohio | 39035 | 21266 | 686 |
679140 | 679140 | 2020-10-29 | Cuyahoga | Ohio | 39035 | 21002 | 686 |
675897 | 675897 | 2020-10-28 | Cuyahoga | Ohio | 39035 | 20741 | 686 |
672654 | 672654 | 2020-10-27 | Cuyahoga | Ohio | 39035 | 20582 | 686 |
669412 | 669412 | 2020-10-26 | Cuyahoga | Ohio | 39035 | 20452 | 685 |
666168 | 666168 | 2020-10-25 | Cuyahoga | Ohio | 39035 | 20278 | 685 |
662923 | 662923 | 2020-10-24 | Cuyahoga | Ohio | 39035 | 20088 | 685 |
659679 | 659679 | 2020-10-23 | Cuyahoga | Ohio | 39035 | 19906 | 684 |
656435 | 656435 | 2020-10-22 | Cuyahoga | Ohio | 39035 | 19706 | 682 |
653190 | 653190 | 2020-10-21 | Cuyahoga | Ohio | 39035 | 19586 | 682 |
649945 | 649945 | 2020-10-20 | Cuyahoga | Ohio | 39035 | 19436 | 675 |
646701 | 646701 | 2020-10-19 | Cuyahoga | Ohio | 39035 | 19345 | 674 |
643455 | 643455 | 2020-10-18 | Cuyahoga | Ohio | 39035 | 19212 | 671 |
640207 | 640207 | 2020-10-17 | Cuyahoga | Ohio | 39035 | 19103 | 671 |
636961 | 636961 | 2020-10-16 | Cuyahoga | Ohio | 39035 | 18951 | 671 |
633715 | 633715 | 2020-10-15 | Cuyahoga | Ohio | 39035 | 18834 | 671 |
630470 | 630470 | 2020-10-14 | Cuyahoga | Ohio | 39035 | 18711 | 670 |
627226 | 627226 | 2020-10-13 | Cuyahoga | Ohio | 39035 | 18620 | 667 |
623984 | 623984 | 2020-10-12 | Cuyahoga | Ohio | 39035 | 18538 | 667 |
620741 | 620741 | 2020-10-11 | Cuyahoga | Ohio | 39035 | 18441 | 667 |
617499 | 617499 | 2020-10-10 | Cuyahoga | Ohio | 39035 | 18358 | 667 |
614257 | 614257 | 2020-10-09 | Cuyahoga | Ohio | 39035 | 18299 | 667 |
611016 | 611016 | 2020-10-08 | Cuyahoga | Ohio | 39035 | 18183 | 665 |
607774 | 607774 | 2020-10-07 | Cuyahoga | Ohio | 39035 | 18107 | 665 |
604531 | 604531 | 2020-10-06 | Cuyahoga | Ohio | 39035 | 18035 | 665 |
601289 | 601289 | 2020-10-05 | Cuyahoga | Ohio | 39035 | 17995 | 665 |
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);