ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 39055 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195196 | 1195196 | 2021-04-06 | Geauga | Ohio | 39055 | 6401 | 145 |
1191948 | 1191948 | 2021-04-05 | Geauga | Ohio | 39055 | 6389 | 144 |
1188699 | 1188699 | 2021-04-04 | Geauga | Ohio | 39055 | 6373 | 144 |
1185452 | 1185452 | 2021-04-03 | Geauga | Ohio | 39055 | 6373 | 144 |
1182205 | 1182205 | 2021-04-02 | Geauga | Ohio | 39055 | 6360 | 144 |
1178958 | 1178958 | 2021-04-01 | Geauga | Ohio | 39055 | 6350 | 144 |
1175711 | 1175711 | 2021-03-31 | Geauga | Ohio | 39055 | 6337 | 144 |
1172464 | 1172464 | 2021-03-30 | Geauga | Ohio | 39055 | 6327 | 144 |
1169217 | 1169217 | 2021-03-29 | Geauga | Ohio | 39055 | 6312 | 144 |
1165969 | 1165969 | 2021-03-28 | Geauga | Ohio | 39055 | 6303 | 144 |
1162721 | 1162721 | 2021-03-27 | Geauga | Ohio | 39055 | 6297 | 144 |
1159472 | 1159472 | 2021-03-26 | Geauga | Ohio | 39055 | 6281 | 144 |
1156225 | 1156225 | 2021-03-25 | Geauga | Ohio | 39055 | 6266 | 144 |
1152978 | 1152978 | 2021-03-24 | Geauga | Ohio | 39055 | 6260 | 144 |
1149731 | 1149731 | 2021-03-23 | Geauga | Ohio | 39055 | 6251 | 144 |
1146484 | 1146484 | 2021-03-22 | Geauga | Ohio | 39055 | 6241 | 144 |
1143237 | 1143237 | 2021-03-21 | Geauga | Ohio | 39055 | 6238 | 144 |
1139990 | 1139990 | 2021-03-20 | Geauga | Ohio | 39055 | 6235 | 144 |
1136744 | 1136744 | 2021-03-19 | Geauga | Ohio | 39055 | 6224 | 144 |
1133498 | 1133498 | 2021-03-18 | Geauga | Ohio | 39055 | 6218 | 143 |
1130250 | 1130250 | 2021-03-17 | Geauga | Ohio | 39055 | 6211 | 143 |
1127003 | 1127003 | 2021-03-16 | Geauga | Ohio | 39055 | 6207 | 143 |
1123757 | 1123757 | 2021-03-15 | Geauga | Ohio | 39055 | 6199 | 143 |
1120511 | 1120511 | 2021-03-14 | Geauga | Ohio | 39055 | 6193 | 143 |
1117264 | 1117264 | 2021-03-13 | Geauga | Ohio | 39055 | 6188 | 143 |
1114017 | 1114017 | 2021-03-12 | Geauga | Ohio | 39055 | 6173 | 143 |
1110771 | 1110771 | 2021-03-11 | Geauga | Ohio | 39055 | 6164 | 142 |
1107525 | 1107525 | 2021-03-10 | Geauga | Ohio | 39055 | 6154 | 142 |
1104279 | 1104279 | 2021-03-09 | Geauga | Ohio | 39055 | 6139 | 142 |
1101033 | 1101033 | 2021-03-08 | Geauga | Ohio | 39055 | 6129 | 142 |
1097787 | 1097787 | 2021-03-07 | Geauga | Ohio | 39055 | 6118 | 142 |
1094539 | 1094539 | 2021-03-06 | Geauga | Ohio | 39055 | 6114 | 142 |
1091293 | 1091293 | 2021-03-05 | Geauga | Ohio | 39055 | 6105 | 142 |
1088048 | 1088048 | 2021-03-04 | Geauga | Ohio | 39055 | 6097 | 136 |
1084803 | 1084803 | 2021-03-03 | Geauga | Ohio | 39055 | 6083 | 136 |
1081557 | 1081557 | 2021-03-02 | Geauga | Ohio | 39055 | 6067 | 136 |
1078311 | 1078311 | 2021-03-01 | Geauga | Ohio | 39055 | 6057 | 129 |
1075066 | 1075066 | 2021-02-28 | Geauga | Ohio | 39055 | 6051 | 128 |
1071820 | 1071820 | 2021-02-27 | Geauga | Ohio | 39055 | 6036 | 128 |
1068574 | 1068574 | 2021-02-26 | Geauga | Ohio | 39055 | 6030 | 129 |
1065329 | 1065329 | 2021-02-25 | Geauga | Ohio | 39055 | 6010 | 129 |
1062085 | 1062085 | 2021-02-24 | Geauga | Ohio | 39055 | 5996 | 129 |
1058839 | 1058839 | 2021-02-23 | Geauga | Ohio | 39055 | 5978 | 129 |
1055593 | 1055593 | 2021-02-22 | Geauga | Ohio | 39055 | 5941 | 129 |
1052347 | 1052347 | 2021-02-21 | Geauga | Ohio | 39055 | 5928 | 129 |
1049100 | 1049100 | 2021-02-20 | Geauga | Ohio | 39055 | 5914 | 128 |
1045853 | 1045853 | 2021-02-19 | Geauga | Ohio | 39055 | 5897 | 128 |
1042608 | 1042608 | 2021-02-18 | Geauga | Ohio | 39055 | 5870 | 128 |
1039363 | 1039363 | 2021-02-17 | Geauga | Ohio | 39055 | 5852 | 128 |
1036118 | 1036118 | 2021-02-16 | Geauga | Ohio | 39055 | 5822 | 126 |
1032873 | 1032873 | 2021-02-15 | Geauga | Ohio | 39055 | 5816 | 125 |
1029627 | 1029627 | 2021-02-14 | Geauga | Ohio | 39055 | 5802 | 125 |
1026380 | 1026380 | 2021-02-13 | Geauga | Ohio | 39055 | 5783 | 124 |
1023135 | 1023135 | 2021-02-12 | Geauga | Ohio | 39055 | 5765 | 110 |
1019890 | 1019890 | 2021-02-11 | Geauga | Ohio | 39055 | 5740 | 70 |
1016645 | 1016645 | 2021-02-10 | Geauga | Ohio | 39055 | 5706 | 57 |
1013400 | 1013400 | 2021-02-09 | Geauga | Ohio | 39055 | 5668 | 57 |
1010155 | 1010155 | 2021-02-08 | Geauga | Ohio | 39055 | 5656 | 56 |
1006909 | 1006909 | 2021-02-07 | Geauga | Ohio | 39055 | 5637 | 56 |
1003663 | 1003663 | 2021-02-06 | Geauga | Ohio | 39055 | 5616 | 56 |
1000417 | 1000417 | 2021-02-05 | Geauga | Ohio | 39055 | 5595 | 56 |
997171 | 997171 | 2021-02-04 | Geauga | Ohio | 39055 | 5565 | 56 |
993925 | 993925 | 2021-02-03 | Geauga | Ohio | 39055 | 5541 | 56 |
990679 | 990679 | 2021-02-02 | Geauga | Ohio | 39055 | 5491 | 56 |
987433 | 987433 | 2021-02-01 | Geauga | Ohio | 39055 | 5456 | 56 |
984186 | 984186 | 2021-01-31 | Geauga | Ohio | 39055 | 5428 | 56 |
980939 | 980939 | 2021-01-30 | Geauga | Ohio | 39055 | 5399 | 56 |
977693 | 977693 | 2021-01-29 | Geauga | Ohio | 39055 | 5355 | 56 |
974448 | 974448 | 2021-01-28 | Geauga | Ohio | 39055 | 5308 | 56 |
971203 | 971203 | 2021-01-27 | Geauga | Ohio | 39055 | 5242 | 56 |
967958 | 967958 | 2021-01-26 | Geauga | Ohio | 39055 | 5189 | 55 |
964714 | 964714 | 2021-01-25 | Geauga | Ohio | 39055 | 5159 | 55 |
961469 | 961469 | 2021-01-24 | Geauga | Ohio | 39055 | 5135 | 55 |
958224 | 958224 | 2021-01-23 | Geauga | Ohio | 39055 | 5084 | 55 |
954978 | 954978 | 2021-01-22 | Geauga | Ohio | 39055 | 5038 | 55 |
951733 | 951733 | 2021-01-21 | Geauga | Ohio | 39055 | 5011 | 55 |
948488 | 948488 | 2021-01-20 | Geauga | Ohio | 39055 | 4971 | 55 |
945242 | 945242 | 2021-01-19 | Geauga | Ohio | 39055 | 4917 | 55 |
941995 | 941995 | 2021-01-18 | Geauga | Ohio | 39055 | 4877 | 55 |
938750 | 938750 | 2021-01-17 | Geauga | Ohio | 39055 | 4835 | 55 |
935505 | 935505 | 2021-01-16 | Geauga | Ohio | 39055 | 4782 | 55 |
932260 | 932260 | 2021-01-15 | Geauga | Ohio | 39055 | 4748 | 55 |
929015 | 929015 | 2021-01-14 | Geauga | Ohio | 39055 | 4699 | 55 |
925770 | 925770 | 2021-01-13 | Geauga | Ohio | 39055 | 4668 | 55 |
922524 | 922524 | 2021-01-12 | Geauga | Ohio | 39055 | 4609 | 55 |
919279 | 919279 | 2021-01-11 | Geauga | Ohio | 39055 | 4559 | 55 |
916034 | 916034 | 2021-01-10 | Geauga | Ohio | 39055 | 4522 | 54 |
912789 | 912789 | 2021-01-09 | Geauga | Ohio | 39055 | 4465 | 54 |
909544 | 909544 | 2021-01-08 | Geauga | Ohio | 39055 | 4423 | 54 |
906299 | 906299 | 2021-01-07 | Geauga | Ohio | 39055 | 4356 | 54 |
903053 | 903053 | 2021-01-06 | Geauga | Ohio | 39055 | 4291 | 54 |
899808 | 899808 | 2021-01-05 | Geauga | Ohio | 39055 | 4242 | 53 |
896563 | 896563 | 2021-01-04 | Geauga | Ohio | 39055 | 4202 | 53 |
893317 | 893317 | 2021-01-03 | Geauga | Ohio | 39055 | 4156 | 53 |
890071 | 890071 | 2021-01-02 | Geauga | Ohio | 39055 | 4113 | 53 |
886824 | 886824 | 2021-01-01 | Geauga | Ohio | 39055 | 4022 | 53 |
883579 | 883579 | 2020-12-31 | Geauga | Ohio | 39055 | 4022 | 53 |
880334 | 880334 | 2020-12-30 | Geauga | Ohio | 39055 | 3964 | 53 |
877089 | 877089 | 2020-12-29 | Geauga | Ohio | 39055 | 3928 | 51 |
873844 | 873844 | 2020-12-28 | Geauga | Ohio | 39055 | 3882 | 51 |
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);