ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Warren", fips = 39165 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1045908 | 1045908 | 2021-02-19 | Warren | Ohio | 39165 | 21875 | 264 |
1042663 | 1042663 | 2021-02-18 | Warren | Ohio | 39165 | 21806 | 264 |
1039418 | 1039418 | 2021-02-17 | Warren | Ohio | 39165 | 21748 | 260 |
1036173 | 1036173 | 2021-02-16 | Warren | Ohio | 39165 | 21702 | 259 |
1032928 | 1032928 | 2021-02-15 | Warren | Ohio | 39165 | 21634 | 257 |
1029682 | 1029682 | 2021-02-14 | Warren | Ohio | 39165 | 21596 | 256 |
1026435 | 1026435 | 2021-02-13 | Warren | Ohio | 39165 | 21573 | 256 |
1023190 | 1023190 | 2021-02-12 | Warren | Ohio | 39165 | 21499 | 226 |
1019945 | 1019945 | 2021-02-11 | Warren | Ohio | 39165 | 21427 | 173 |
1016700 | 1016700 | 2021-02-10 | Warren | Ohio | 39165 | 21375 | 160 |
1013455 | 1013455 | 2021-02-09 | Warren | Ohio | 39165 | 21307 | 160 |
1010210 | 1010210 | 2021-02-08 | Warren | Ohio | 39165 | 21220 | 155 |
1006964 | 1006964 | 2021-02-07 | Warren | Ohio | 39165 | 21162 | 155 |
1003718 | 1003718 | 2021-02-06 | Warren | Ohio | 39165 | 21112 | 155 |
1000472 | 1000472 | 2021-02-05 | Warren | Ohio | 39165 | 21020 | 155 |
997226 | 997226 | 2021-02-04 | Warren | Ohio | 39165 | 20929 | 154 |
993980 | 993980 | 2021-02-03 | Warren | Ohio | 39165 | 20836 | 152 |
990734 | 990734 | 2021-02-02 | Warren | Ohio | 39165 | 20726 | 150 |
987488 | 987488 | 2021-02-01 | Warren | Ohio | 39165 | 20618 | 149 |
984241 | 984241 | 2021-01-31 | Warren | Ohio | 39165 | 20531 | 149 |
980994 | 980994 | 2021-01-30 | Warren | Ohio | 39165 | 20444 | 149 |
977748 | 977748 | 2021-01-29 | Warren | Ohio | 39165 | 20356 | 149 |
974503 | 974503 | 2021-01-28 | Warren | Ohio | 39165 | 20222 | 148 |
971258 | 971258 | 2021-01-27 | Warren | Ohio | 39165 | 20053 | 147 |
968013 | 968013 | 2021-01-26 | Warren | Ohio | 39165 | 19939 | 144 |
964769 | 964769 | 2021-01-25 | Warren | Ohio | 39165 | 19830 | 142 |
961524 | 961524 | 2021-01-24 | Warren | Ohio | 39165 | 19746 | 141 |
958279 | 958279 | 2021-01-23 | Warren | Ohio | 39165 | 19671 | 140 |
955033 | 955033 | 2021-01-22 | Warren | Ohio | 39165 | 19552 | 140 |
951788 | 951788 | 2021-01-21 | Warren | Ohio | 39165 | 19436 | 140 |
948543 | 948543 | 2021-01-20 | Warren | Ohio | 39165 | 19222 | 140 |
945297 | 945297 | 2021-01-19 | Warren | Ohio | 39165 | 19083 | 140 |
942050 | 942050 | 2021-01-18 | Warren | Ohio | 39165 | 18974 | 139 |
938805 | 938805 | 2021-01-17 | Warren | Ohio | 39165 | 18917 | 139 |
935560 | 935560 | 2021-01-16 | Warren | Ohio | 39165 | 18792 | 139 |
932315 | 932315 | 2021-01-15 | Warren | Ohio | 39165 | 18659 | 138 |
929070 | 929070 | 2021-01-14 | Warren | Ohio | 39165 | 18471 | 135 |
925825 | 925825 | 2021-01-13 | Warren | Ohio | 39165 | 18268 | 135 |
922579 | 922579 | 2021-01-12 | Warren | Ohio | 39165 | 18095 | 130 |
919334 | 919334 | 2021-01-11 | Warren | Ohio | 39165 | 17861 | 128 |
916089 | 916089 | 2021-01-10 | Warren | Ohio | 39165 | 17737 | 128 |
912844 | 912844 | 2021-01-09 | Warren | Ohio | 39165 | 17562 | 128 |
909599 | 909599 | 2021-01-08 | Warren | Ohio | 39165 | 17396 | 127 |
906354 | 906354 | 2021-01-07 | Warren | Ohio | 39165 | 17135 | 124 |
903108 | 903108 | 2021-01-06 | Warren | Ohio | 39165 | 16873 | 124 |
899863 | 899863 | 2021-01-05 | Warren | Ohio | 39165 | 16620 | 124 |
896618 | 896618 | 2021-01-04 | Warren | Ohio | 39165 | 16387 | 122 |
893372 | 893372 | 2021-01-03 | Warren | Ohio | 39165 | 16262 | 122 |
890126 | 890126 | 2021-01-02 | Warren | Ohio | 39165 | 16139 | 121 |
886879 | 886879 | 2021-01-01 | Warren | Ohio | 39165 | 15752 | 121 |
883634 | 883634 | 2020-12-31 | Warren | Ohio | 39165 | 15752 | 121 |
880389 | 880389 | 2020-12-30 | Warren | Ohio | 39165 | 15502 | 120 |
877144 | 877144 | 2020-12-29 | Warren | Ohio | 39165 | 15242 | 119 |
873899 | 873899 | 2020-12-28 | Warren | Ohio | 39165 | 15023 | 116 |
870654 | 870654 | 2020-12-27 | Warren | Ohio | 39165 | 14921 | 116 |
867409 | 867409 | 2020-12-26 | Warren | Ohio | 39165 | 14742 | 116 |
864164 | 864164 | 2020-12-25 | Warren | Ohio | 39165 | 14490 | 113 |
860919 | 860919 | 2020-12-24 | Warren | Ohio | 39165 | 14490 | 113 |
857674 | 857674 | 2020-12-23 | Warren | Ohio | 39165 | 14279 | 109 |
854429 | 854429 | 2020-12-22 | Warren | Ohio | 39165 | 14104 | 109 |
851184 | 851184 | 2020-12-21 | Warren | Ohio | 39165 | 13918 | 106 |
847939 | 847939 | 2020-12-20 | Warren | Ohio | 39165 | 13800 | 105 |
844694 | 844694 | 2020-12-19 | Warren | Ohio | 39165 | 13610 | 105 |
841448 | 841448 | 2020-12-18 | Warren | Ohio | 39165 | 13372 | 103 |
838203 | 838203 | 2020-12-17 | Warren | Ohio | 39165 | 13156 | 101 |
834957 | 834957 | 2020-12-16 | Warren | Ohio | 39165 | 12889 | 100 |
831711 | 831711 | 2020-12-15 | Warren | Ohio | 39165 | 12739 | 100 |
828464 | 828464 | 2020-12-14 | Warren | Ohio | 39165 | 12501 | 95 |
825218 | 825218 | 2020-12-13 | Warren | Ohio | 39165 | 12362 | 95 |
821971 | 821971 | 2020-12-12 | Warren | Ohio | 39165 | 12189 | 95 |
818725 | 818725 | 2020-12-11 | Warren | Ohio | 39165 | 11970 | 95 |
815479 | 815479 | 2020-12-10 | Warren | Ohio | 39165 | 11705 | 92 |
812233 | 812233 | 2020-12-09 | Warren | Ohio | 39165 | 11480 | 90 |
808989 | 808989 | 2020-12-08 | Warren | Ohio | 39165 | 11240 | 89 |
805744 | 805744 | 2020-12-07 | Warren | Ohio | 39165 | 10708 | 88 |
802499 | 802499 | 2020-12-06 | Warren | Ohio | 39165 | 10573 | 87 |
799254 | 799254 | 2020-12-05 | Warren | Ohio | 39165 | 10404 | 86 |
796009 | 796009 | 2020-12-04 | Warren | Ohio | 39165 | 10193 | 86 |
792764 | 792764 | 2020-12-03 | Warren | Ohio | 39165 | 9943 | 81 |
789519 | 789519 | 2020-12-02 | Warren | Ohio | 39165 | 9704 | 79 |
786274 | 786274 | 2020-12-01 | Warren | Ohio | 39165 | 9500 | 79 |
783030 | 783030 | 2020-11-30 | Warren | Ohio | 39165 | 9263 | 77 |
779784 | 779784 | 2020-11-29 | Warren | Ohio | 39165 | 9090 | 77 |
776539 | 776539 | 2020-11-28 | Warren | Ohio | 39165 | 8921 | 77 |
773294 | 773294 | 2020-11-27 | Warren | Ohio | 39165 | 8787 | 77 |
770049 | 770049 | 2020-11-26 | Warren | Ohio | 39165 | 8419 | 76 |
766803 | 766803 | 2020-11-25 | Warren | Ohio | 39165 | 8419 | 76 |
763558 | 763558 | 2020-11-24 | Warren | Ohio | 39165 | 8191 | 75 |
760313 | 760313 | 2020-11-23 | Warren | Ohio | 39165 | 7989 | 75 |
757068 | 757068 | 2020-11-22 | Warren | Ohio | 39165 | 7703 | 75 |
753821 | 753821 | 2020-11-21 | Warren | Ohio | 39165 | 7543 | 75 |
750575 | 750575 | 2020-11-20 | Warren | Ohio | 39165 | 7373 | 74 |
747329 | 747329 | 2020-11-19 | Warren | Ohio | 39165 | 7169 | 74 |
744083 | 744083 | 2020-11-18 | Warren | Ohio | 39165 | 7031 | 73 |
740836 | 740836 | 2020-11-17 | Warren | Ohio | 39165 | 6912 | 72 |
737590 | 737590 | 2020-11-16 | Warren | Ohio | 39165 | 6751 | 72 |
734346 | 734346 | 2020-11-15 | Warren | Ohio | 39165 | 6538 | 72 |
731100 | 731100 | 2020-11-14 | Warren | Ohio | 39165 | 6387 | 72 |
727856 | 727856 | 2020-11-13 | Warren | Ohio | 39165 | 6225 | 72 |
724612 | 724612 | 2020-11-12 | Warren | Ohio | 39165 | 6039 | 72 |
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);