ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Putnam" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419256 | 1419256 | 2021-06-14 | Putnam | Ohio | 39137 | 4334 | 103 |
1416011 | 1416011 | 2021-06-13 | Putnam | Ohio | 39137 | 4333 | 103 |
1412765 | 1412765 | 2021-06-12 | Putnam | Ohio | 39137 | 4333 | 103 |
1409520 | 1409520 | 2021-06-11 | Putnam | Ohio | 39137 | 4331 | 103 |
1406275 | 1406275 | 2021-06-10 | Putnam | Ohio | 39137 | 4331 | 103 |
1403029 | 1403029 | 2021-06-09 | Putnam | Ohio | 39137 | 4331 | 103 |
1399784 | 1399784 | 2021-06-08 | Putnam | Ohio | 39137 | 4331 | 103 |
1396539 | 1396539 | 2021-06-07 | Putnam | Ohio | 39137 | 4331 | 103 |
1393292 | 1393292 | 2021-06-06 | Putnam | Ohio | 39137 | 4331 | 103 |
1390047 | 1390047 | 2021-06-05 | Putnam | Ohio | 39137 | 4331 | 103 |
1386802 | 1386802 | 2021-06-04 | Putnam | Ohio | 39137 | 4331 | 103 |
1383557 | 1383557 | 2021-06-03 | Putnam | Ohio | 39137 | 4331 | 103 |
1380311 | 1380311 | 2021-06-02 | Putnam | Ohio | 39137 | 4329 | 103 |
1377066 | 1377066 | 2021-06-01 | Putnam | Ohio | 39137 | 4330 | 103 |
1373820 | 1373820 | 2021-05-31 | Putnam | Ohio | 39137 | 4330 | 103 |
1370575 | 1370575 | 2021-05-30 | Putnam | Ohio | 39137 | 4330 | 103 |
1367329 | 1367329 | 2021-05-29 | Putnam | Ohio | 39137 | 4329 | 103 |
1364083 | 1364083 | 2021-05-28 | Putnam | Ohio | 39137 | 4327 | 103 |
1360837 | 1360837 | 2021-05-27 | Putnam | Ohio | 39137 | 4326 | 102 |
1357591 | 1357591 | 2021-05-26 | Putnam | Ohio | 39137 | 4323 | 102 |
1354345 | 1354345 | 2021-05-25 | Putnam | Ohio | 39137 | 4321 | 102 |
1351099 | 1351099 | 2021-05-24 | Putnam | Ohio | 39137 | 4317 | 101 |
1347853 | 1347853 | 2021-05-23 | Putnam | Ohio | 39137 | 4316 | 101 |
1344605 | 1344605 | 2021-05-22 | Putnam | Ohio | 39137 | 4316 | 101 |
1341357 | 1341357 | 2021-05-21 | Putnam | Ohio | 39137 | 4314 | 101 |
1338109 | 1338109 | 2021-05-20 | Putnam | Ohio | 39137 | 4309 | 101 |
1334862 | 1334862 | 2021-05-19 | Putnam | Ohio | 39137 | 4308 | 101 |
1331615 | 1331615 | 2021-05-18 | Putnam | Ohio | 39137 | 4306 | 101 |
1328368 | 1328368 | 2021-05-17 | Putnam | Ohio | 39137 | 4301 | 101 |
1325122 | 1325122 | 2021-05-16 | Putnam | Ohio | 39137 | 4299 | 101 |
1321876 | 1321876 | 2021-05-15 | Putnam | Ohio | 39137 | 4298 | 101 |
1318630 | 1318630 | 2021-05-14 | Putnam | Ohio | 39137 | 4297 | 101 |
1315382 | 1315382 | 2021-05-13 | Putnam | Ohio | 39137 | 4297 | 100 |
1312136 | 1312136 | 2021-05-12 | Putnam | Ohio | 39137 | 4288 | 100 |
1308889 | 1308889 | 2021-05-11 | Putnam | Ohio | 39137 | 4287 | 100 |
1305643 | 1305643 | 2021-05-10 | Putnam | Ohio | 39137 | 4283 | 100 |
1302397 | 1302397 | 2021-05-09 | Putnam | Ohio | 39137 | 4278 | 100 |
1299149 | 1299149 | 2021-05-08 | Putnam | Ohio | 39137 | 4278 | 100 |
1295903 | 1295903 | 2021-05-07 | Putnam | Ohio | 39137 | 4278 | 100 |
1292657 | 1292657 | 2021-05-06 | Putnam | Ohio | 39137 | 4268 | 100 |
1289411 | 1289411 | 2021-05-05 | Putnam | Ohio | 39137 | 4263 | 100 |
1286165 | 1286165 | 2021-05-04 | Putnam | Ohio | 39137 | 4260 | 100 |
1282919 | 1282919 | 2021-05-03 | Putnam | Ohio | 39137 | 4256 | 100 |
1279672 | 1279672 | 2021-05-02 | Putnam | Ohio | 39137 | 4256 | 100 |
1276425 | 1276425 | 2021-05-01 | Putnam | Ohio | 39137 | 4256 | 100 |
1273178 | 1273178 | 2021-04-30 | Putnam | Ohio | 39137 | 4252 | 100 |
1269931 | 1269931 | 2021-04-29 | Putnam | Ohio | 39137 | 4251 | 100 |
1266684 | 1266684 | 2021-04-28 | Putnam | Ohio | 39137 | 4249 | 100 |
1263437 | 1263437 | 2021-04-27 | Putnam | Ohio | 39137 | 4247 | 100 |
1260190 | 1260190 | 2021-04-26 | Putnam | Ohio | 39137 | 4246 | 99 |
1256943 | 1256943 | 2021-04-25 | Putnam | Ohio | 39137 | 4242 | 99 |
1253696 | 1253696 | 2021-04-24 | Putnam | Ohio | 39137 | 4241 | 99 |
1250449 | 1250449 | 2021-04-23 | Putnam | Ohio | 39137 | 4239 | 99 |
1247202 | 1247202 | 2021-04-22 | Putnam | Ohio | 39137 | 4231 | 99 |
1243955 | 1243955 | 2021-04-21 | Putnam | Ohio | 39137 | 4231 | 99 |
1240708 | 1240708 | 2021-04-20 | Putnam | Ohio | 39137 | 4224 | 99 |
1237461 | 1237461 | 2021-04-19 | Putnam | Ohio | 39137 | 4217 | 99 |
1234214 | 1234214 | 2021-04-18 | Putnam | Ohio | 39137 | 4217 | 99 |
1230966 | 1230966 | 2021-04-17 | Putnam | Ohio | 39137 | 4215 | 99 |
1227718 | 1227718 | 2021-04-16 | Putnam | Ohio | 39137 | 4207 | 99 |
1224470 | 1224470 | 2021-04-15 | Putnam | Ohio | 39137 | 4202 | 98 |
1221223 | 1221223 | 2021-04-14 | Putnam | Ohio | 39137 | 4193 | 98 |
1217975 | 1217975 | 2021-04-13 | Putnam | Ohio | 39137 | 4188 | 98 |
1214727 | 1214727 | 2021-04-12 | Putnam | Ohio | 39137 | 4184 | 98 |
1211480 | 1211480 | 2021-04-11 | Putnam | Ohio | 39137 | 4176 | 98 |
1208231 | 1208231 | 2021-04-10 | Putnam | Ohio | 39137 | 4172 | 98 |
1204983 | 1204983 | 2021-04-09 | Putnam | Ohio | 39137 | 4165 | 98 |
1201735 | 1201735 | 2021-04-08 | Putnam | Ohio | 39137 | 4156 | 98 |
1198486 | 1198486 | 2021-04-07 | Putnam | Ohio | 39137 | 4143 | 98 |
1195237 | 1195237 | 2021-04-06 | Putnam | Ohio | 39137 | 4141 | 98 |
1191989 | 1191989 | 2021-04-05 | Putnam | Ohio | 39137 | 4135 | 98 |
1188740 | 1188740 | 2021-04-04 | Putnam | Ohio | 39137 | 4120 | 98 |
1185493 | 1185493 | 2021-04-03 | Putnam | Ohio | 39137 | 4120 | 98 |
1182246 | 1182246 | 2021-04-02 | Putnam | Ohio | 39137 | 4114 | 98 |
1178999 | 1178999 | 2021-04-01 | Putnam | Ohio | 39137 | 4102 | 98 |
1175752 | 1175752 | 2021-03-31 | Putnam | Ohio | 39137 | 4089 | 98 |
1172505 | 1172505 | 2021-03-30 | Putnam | Ohio | 39137 | 4079 | 98 |
1169258 | 1169258 | 2021-03-29 | Putnam | Ohio | 39137 | 4070 | 98 |
1166010 | 1166010 | 2021-03-28 | Putnam | Ohio | 39137 | 4067 | 98 |
1162762 | 1162762 | 2021-03-27 | Putnam | Ohio | 39137 | 4064 | 98 |
1159513 | 1159513 | 2021-03-26 | Putnam | Ohio | 39137 | 4061 | 98 |
1156266 | 1156266 | 2021-03-25 | Putnam | Ohio | 39137 | 4054 | 97 |
1153019 | 1153019 | 2021-03-24 | Putnam | Ohio | 39137 | 4052 | 97 |
1149772 | 1149772 | 2021-03-23 | Putnam | Ohio | 39137 | 4046 | 97 |
1146525 | 1146525 | 2021-03-22 | Putnam | Ohio | 39137 | 4044 | 97 |
1143278 | 1143278 | 2021-03-21 | Putnam | Ohio | 39137 | 4041 | 97 |
1140031 | 1140031 | 2021-03-20 | Putnam | Ohio | 39137 | 4040 | 97 |
1136785 | 1136785 | 2021-03-19 | Putnam | Ohio | 39137 | 4036 | 97 |
1133539 | 1133539 | 2021-03-18 | Putnam | Ohio | 39137 | 4034 | 96 |
1130291 | 1130291 | 2021-03-17 | Putnam | Ohio | 39137 | 4030 | 96 |
1127044 | 1127044 | 2021-03-16 | Putnam | Ohio | 39137 | 4029 | 96 |
1123798 | 1123798 | 2021-03-15 | Putnam | Ohio | 39137 | 4026 | 95 |
1120552 | 1120552 | 2021-03-14 | Putnam | Ohio | 39137 | 4020 | 95 |
1117305 | 1117305 | 2021-03-13 | Putnam | Ohio | 39137 | 4016 | 95 |
1114058 | 1114058 | 2021-03-12 | Putnam | Ohio | 39137 | 4016 | 95 |
1110812 | 1110812 | 2021-03-11 | Putnam | Ohio | 39137 | 4013 | 94 |
1107566 | 1107566 | 2021-03-10 | Putnam | Ohio | 39137 | 4011 | 94 |
1104320 | 1104320 | 2021-03-09 | Putnam | Ohio | 39137 | 4009 | 94 |
1101074 | 1101074 | 2021-03-08 | Putnam | Ohio | 39137 | 4006 | 93 |
1097828 | 1097828 | 2021-03-07 | Putnam | Ohio | 39137 | 4005 | 93 |
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);