ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 39153 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1243963 | 1243963 | 2021-04-21 | Summit | Ohio | 39153 | 45710 | 915 |
1240716 | 1240716 | 2021-04-20 | Summit | Ohio | 39153 | 45630 | 915 |
1237469 | 1237469 | 2021-04-19 | Summit | Ohio | 39153 | 45557 | 909 |
1234222 | 1234222 | 2021-04-18 | Summit | Ohio | 39153 | 45464 | 909 |
1230974 | 1230974 | 2021-04-17 | Summit | Ohio | 39153 | 45383 | 909 |
1227726 | 1227726 | 2021-04-16 | Summit | Ohio | 39153 | 45252 | 909 |
1224478 | 1224478 | 2021-04-15 | Summit | Ohio | 39153 | 45144 | 907 |
1221231 | 1221231 | 2021-04-14 | Summit | Ohio | 39153 | 45000 | 907 |
1217983 | 1217983 | 2021-04-13 | Summit | Ohio | 39153 | 44890 | 907 |
1214735 | 1214735 | 2021-04-12 | Summit | Ohio | 39153 | 44761 | 904 |
1211488 | 1211488 | 2021-04-11 | Summit | Ohio | 39153 | 44613 | 904 |
1208239 | 1208239 | 2021-04-10 | Summit | Ohio | 39153 | 44494 | 904 |
1204991 | 1204991 | 2021-04-09 | Summit | Ohio | 39153 | 44336 | 904 |
1201743 | 1201743 | 2021-04-08 | Summit | Ohio | 39153 | 44226 | 904 |
1198494 | 1198494 | 2021-04-07 | Summit | Ohio | 39153 | 44078 | 904 |
1195245 | 1195245 | 2021-04-06 | Summit | Ohio | 39153 | 43976 | 904 |
1191997 | 1191997 | 2021-04-05 | Summit | Ohio | 39153 | 43868 | 900 |
1188748 | 1188748 | 2021-04-04 | Summit | Ohio | 39153 | 43639 | 900 |
1185501 | 1185501 | 2021-04-03 | Summit | Ohio | 39153 | 43639 | 900 |
1182254 | 1182254 | 2021-04-02 | Summit | Ohio | 39153 | 43507 | 900 |
1179007 | 1179007 | 2021-04-01 | Summit | Ohio | 39153 | 43396 | 897 |
1175760 | 1175760 | 2021-03-31 | Summit | Ohio | 39153 | 43243 | 897 |
1172513 | 1172513 | 2021-03-30 | Summit | Ohio | 39153 | 43123 | 897 |
1169266 | 1169266 | 2021-03-29 | Summit | Ohio | 39153 | 42977 | 887 |
1166018 | 1166018 | 2021-03-28 | Summit | Ohio | 39153 | 42855 | 887 |
1162770 | 1162770 | 2021-03-27 | Summit | Ohio | 39153 | 42780 | 887 |
1159521 | 1159521 | 2021-03-26 | Summit | Ohio | 39153 | 42640 | 887 |
1156274 | 1156274 | 2021-03-25 | Summit | Ohio | 39153 | 42461 | 881 |
1153027 | 1153027 | 2021-03-24 | Summit | Ohio | 39153 | 42375 | 881 |
1149780 | 1149780 | 2021-03-23 | Summit | Ohio | 39153 | 42268 | 881 |
1146533 | 1146533 | 2021-03-22 | Summit | Ohio | 39153 | 42161 | 879 |
1143286 | 1143286 | 2021-03-21 | Summit | Ohio | 39153 | 42065 | 879 |
1140039 | 1140039 | 2021-03-20 | Summit | Ohio | 39153 | 41997 | 879 |
1136793 | 1136793 | 2021-03-19 | Summit | Ohio | 39153 | 41904 | 879 |
1133547 | 1133547 | 2021-03-18 | Summit | Ohio | 39153 | 41795 | 864 |
1130299 | 1130299 | 2021-03-17 | Summit | Ohio | 39153 | 41674 | 864 |
1127052 | 1127052 | 2021-03-16 | Summit | Ohio | 39153 | 41584 | 864 |
1123806 | 1123806 | 2021-03-15 | Summit | Ohio | 39153 | 41459 | 860 |
1120560 | 1120560 | 2021-03-14 | Summit | Ohio | 39153 | 41378 | 860 |
1117313 | 1117313 | 2021-03-13 | Summit | Ohio | 39153 | 41315 | 860 |
1114066 | 1114066 | 2021-03-12 | Summit | Ohio | 39153 | 41191 | 860 |
1110820 | 1110820 | 2021-03-11 | Summit | Ohio | 39153 | 41065 | 846 |
1107574 | 1107574 | 2021-03-10 | Summit | Ohio | 39153 | 40985 | 846 |
1104328 | 1104328 | 2021-03-09 | Summit | Ohio | 39153 | 40879 | 846 |
1101082 | 1101082 | 2021-03-08 | Summit | Ohio | 39153 | 40800 | 831 |
1097836 | 1097836 | 2021-03-07 | Summit | Ohio | 39153 | 40720 | 831 |
1094588 | 1094588 | 2021-03-06 | Summit | Ohio | 39153 | 40668 | 831 |
1091342 | 1091342 | 2021-03-05 | Summit | Ohio | 39153 | 40562 | 831 |
1088097 | 1088097 | 2021-03-04 | Summit | Ohio | 39153 | 40474 | 802 |
1084852 | 1084852 | 2021-03-03 | Summit | Ohio | 39153 | 40384 | 802 |
1081606 | 1081606 | 2021-03-02 | Summit | Ohio | 39153 | 40266 | 802 |
1078360 | 1078360 | 2021-03-01 | Summit | Ohio | 39153 | 40184 | 957 |
1075115 | 1075115 | 2021-02-28 | Summit | Ohio | 39153 | 40110 | 957 |
1071869 | 1071869 | 2021-02-27 | Summit | Ohio | 39153 | 40041 | 955 |
1068623 | 1068623 | 2021-02-26 | Summit | Ohio | 39153 | 39949 | 954 |
1065378 | 1065378 | 2021-02-25 | Summit | Ohio | 39153 | 39845 | 950 |
1062134 | 1062134 | 2021-02-24 | Summit | Ohio | 39153 | 39720 | 942 |
1058888 | 1058888 | 2021-02-23 | Summit | Ohio | 39153 | 39637 | 941 |
1055642 | 1055642 | 2021-02-22 | Summit | Ohio | 39153 | 39474 | 930 |
1052396 | 1052396 | 2021-02-21 | Summit | Ohio | 39153 | 39393 | 927 |
1049149 | 1049149 | 2021-02-20 | Summit | Ohio | 39153 | 39304 | 922 |
1045902 | 1045902 | 2021-02-19 | Summit | Ohio | 39153 | 39209 | 922 |
1042657 | 1042657 | 2021-02-18 | Summit | Ohio | 39153 | 39100 | 915 |
1039412 | 1039412 | 2021-02-17 | Summit | Ohio | 39153 | 38965 | 899 |
1036167 | 1036167 | 2021-02-16 | Summit | Ohio | 39153 | 38838 | 898 |
1032922 | 1032922 | 2021-02-15 | Summit | Ohio | 39153 | 38688 | 900 |
1029676 | 1029676 | 2021-02-14 | Summit | Ohio | 39153 | 38592 | 900 |
1026429 | 1026429 | 2021-02-13 | Summit | Ohio | 39153 | 38509 | 902 |
1023184 | 1023184 | 2021-02-12 | Summit | Ohio | 39153 | 38364 | 890 |
1019939 | 1019939 | 2021-02-11 | Summit | Ohio | 39153 | 38210 | 843 |
1016694 | 1016694 | 2021-02-10 | Summit | Ohio | 39153 | 38074 | 825 |
1013449 | 1013449 | 2021-02-09 | Summit | Ohio | 39153 | 37898 | 820 |
1010204 | 1010204 | 2021-02-08 | Summit | Ohio | 39153 | 37749 | 820 |
1006958 | 1006958 | 2021-02-07 | Summit | Ohio | 39153 | 37622 | 820 |
1003712 | 1003712 | 2021-02-06 | Summit | Ohio | 39153 | 37485 | 820 |
1000466 | 1000466 | 2021-02-05 | Summit | Ohio | 39153 | 37327 | 820 |
997220 | 997220 | 2021-02-04 | Summit | Ohio | 39153 | 37151 | 821 |
993974 | 993974 | 2021-02-03 | Summit | Ohio | 39153 | 36929 | 811 |
990728 | 990728 | 2021-02-02 | Summit | Ohio | 39153 | 36733 | 811 |
987482 | 987482 | 2021-02-01 | Summit | Ohio | 39153 | 36541 | 809 |
984235 | 984235 | 2021-01-31 | Summit | Ohio | 39153 | 36414 | 803 |
980988 | 980988 | 2021-01-30 | Summit | Ohio | 39153 | 36245 | 803 |
977742 | 977742 | 2021-01-29 | Summit | Ohio | 39153 | 36041 | 799 |
974497 | 974497 | 2021-01-28 | Summit | Ohio | 39153 | 35816 | 789 |
971252 | 971252 | 2021-01-27 | Summit | Ohio | 39153 | 35631 | 782 |
968007 | 968007 | 2021-01-26 | Summit | Ohio | 39153 | 35411 | 766 |
964763 | 964763 | 2021-01-25 | Summit | Ohio | 39153 | 35250 | 762 |
961518 | 961518 | 2021-01-24 | Summit | Ohio | 39153 | 35063 | 761 |
958273 | 958273 | 2021-01-23 | Summit | Ohio | 39153 | 34836 | 761 |
955027 | 955027 | 2021-01-22 | Summit | Ohio | 39153 | 34586 | 759 |
951782 | 951782 | 2021-01-21 | Summit | Ohio | 39153 | 34405 | 754 |
948537 | 948537 | 2021-01-20 | Summit | Ohio | 39153 | 34150 | 743 |
945291 | 945291 | 2021-01-19 | Summit | Ohio | 39153 | 33849 | 736 |
942044 | 942044 | 2021-01-18 | Summit | Ohio | 39153 | 33603 | 729 |
938799 | 938799 | 2021-01-17 | Summit | Ohio | 39153 | 33399 | 726 |
935554 | 935554 | 2021-01-16 | Summit | Ohio | 39153 | 33096 | 726 |
932309 | 932309 | 2021-01-15 | Summit | Ohio | 39153 | 32816 | 712 |
929064 | 929064 | 2021-01-14 | Summit | Ohio | 39153 | 32488 | 697 |
925819 | 925819 | 2021-01-13 | Summit | Ohio | 39153 | 32195 | 693 |
922573 | 922573 | 2021-01-12 | Summit | Ohio | 39153 | 31877 | 678 |
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);