ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where county = "Wasco", deaths = 28, fips = 41065 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1403160 | 1403160 | 2021-06-09 | Wasco | Oregon | 41065 | 1433 | 28 |
1399915 | 1399915 | 2021-06-08 | Wasco | Oregon | 41065 | 1434 | 28 |
1396670 | 1396670 | 2021-06-07 | Wasco | Oregon | 41065 | 1434 | 28 |
1393423 | 1393423 | 2021-06-06 | Wasco | Oregon | 41065 | 1432 | 28 |
1390178 | 1390178 | 2021-06-05 | Wasco | Oregon | 41065 | 1432 | 28 |
1386933 | 1386933 | 2021-06-04 | Wasco | Oregon | 41065 | 1427 | 28 |
1383688 | 1383688 | 2021-06-03 | Wasco | Oregon | 41065 | 1425 | 28 |
1380442 | 1380442 | 2021-06-02 | Wasco | Oregon | 41065 | 1424 | 28 |
1377197 | 1377197 | 2021-06-01 | Wasco | Oregon | 41065 | 1423 | 28 |
1373951 | 1373951 | 2021-05-31 | Wasco | Oregon | 41065 | 1422 | 28 |
1370706 | 1370706 | 2021-05-30 | Wasco | Oregon | 41065 | 1418 | 28 |
1367460 | 1367460 | 2021-05-29 | Wasco | Oregon | 41065 | 1418 | 28 |
1364214 | 1364214 | 2021-05-28 | Wasco | Oregon | 41065 | 1414 | 28 |
1360968 | 1360968 | 2021-05-27 | Wasco | Oregon | 41065 | 1410 | 28 |
1357722 | 1357722 | 2021-05-26 | Wasco | Oregon | 41065 | 1409 | 28 |
1354476 | 1354476 | 2021-05-25 | Wasco | Oregon | 41065 | 1407 | 28 |
1351230 | 1351230 | 2021-05-24 | Wasco | Oregon | 41065 | 1407 | 28 |
1347984 | 1347984 | 2021-05-23 | Wasco | Oregon | 41065 | 1406 | 28 |
1344736 | 1344736 | 2021-05-22 | Wasco | Oregon | 41065 | 1405 | 28 |
1341488 | 1341488 | 2021-05-21 | Wasco | Oregon | 41065 | 1399 | 28 |
1338240 | 1338240 | 2021-05-20 | Wasco | Oregon | 41065 | 1393 | 28 |
1334993 | 1334993 | 2021-05-19 | Wasco | Oregon | 41065 | 1388 | 28 |
1331746 | 1331746 | 2021-05-18 | Wasco | Oregon | 41065 | 1384 | 28 |
1328499 | 1328499 | 2021-05-17 | Wasco | Oregon | 41065 | 1384 | 28 |
1325253 | 1325253 | 2021-05-16 | Wasco | Oregon | 41065 | 1381 | 28 |
1322007 | 1322007 | 2021-05-15 | Wasco | Oregon | 41065 | 1381 | 28 |
1318761 | 1318761 | 2021-05-14 | Wasco | Oregon | 41065 | 1379 | 28 |
1315513 | 1315513 | 2021-05-13 | Wasco | Oregon | 41065 | 1377 | 28 |
1312267 | 1312267 | 2021-05-12 | Wasco | Oregon | 41065 | 1375 | 28 |
1309020 | 1309020 | 2021-05-11 | Wasco | Oregon | 41065 | 1373 | 28 |
1305774 | 1305774 | 2021-05-10 | Wasco | Oregon | 41065 | 1371 | 28 |
1302528 | 1302528 | 2021-05-09 | Wasco | Oregon | 41065 | 1370 | 28 |
1299281 | 1299281 | 2021-05-08 | Wasco | Oregon | 41065 | 1370 | 28 |
1296034 | 1296034 | 2021-05-07 | Wasco | Oregon | 41065 | 1366 | 28 |
1292788 | 1292788 | 2021-05-06 | Wasco | Oregon | 41065 | 1364 | 28 |
1289542 | 1289542 | 2021-05-05 | Wasco | Oregon | 41065 | 1362 | 28 |
1286296 | 1286296 | 2021-05-04 | Wasco | Oregon | 41065 | 1361 | 28 |
1283050 | 1283050 | 2021-05-03 | Wasco | Oregon | 41065 | 1359 | 28 |
1279803 | 1279803 | 2021-05-02 | Wasco | Oregon | 41065 | 1359 | 28 |
1276556 | 1276556 | 2021-05-01 | Wasco | Oregon | 41065 | 1357 | 28 |
1273309 | 1273309 | 2021-04-30 | Wasco | Oregon | 41065 | 1353 | 28 |
1270062 | 1270062 | 2021-04-29 | Wasco | Oregon | 41065 | 1345 | 28 |
1266815 | 1266815 | 2021-04-28 | Wasco | Oregon | 41065 | 1340 | 28 |
1263568 | 1263568 | 2021-04-27 | Wasco | Oregon | 41065 | 1339 | 28 |
1260321 | 1260321 | 2021-04-26 | Wasco | Oregon | 41065 | 1335 | 28 |
1257074 | 1257074 | 2021-04-25 | Wasco | Oregon | 41065 | 1332 | 28 |
1253827 | 1253827 | 2021-04-24 | Wasco | Oregon | 41065 | 1329 | 28 |
1250580 | 1250580 | 2021-04-23 | Wasco | Oregon | 41065 | 1323 | 28 |
1247333 | 1247333 | 2021-04-22 | Wasco | Oregon | 41065 | 1320 | 28 |
1244086 | 1244086 | 2021-04-21 | Wasco | Oregon | 41065 | 1304 | 28 |
1240839 | 1240839 | 2021-04-20 | Wasco | Oregon | 41065 | 1302 | 28 |
1237592 | 1237592 | 2021-04-19 | Wasco | Oregon | 41065 | 1299 | 28 |
1234345 | 1234345 | 2021-04-18 | Wasco | Oregon | 41065 | 1291 | 28 |
1231097 | 1231097 | 2021-04-17 | Wasco | Oregon | 41065 | 1289 | 28 |
1227849 | 1227849 | 2021-04-16 | Wasco | Oregon | 41065 | 1286 | 28 |
1224601 | 1224601 | 2021-04-15 | Wasco | Oregon | 41065 | 1280 | 28 |
1221354 | 1221354 | 2021-04-14 | Wasco | Oregon | 41065 | 1272 | 28 |
1218106 | 1218106 | 2021-04-13 | Wasco | Oregon | 41065 | 1264 | 28 |
1214858 | 1214858 | 2021-04-12 | Wasco | Oregon | 41065 | 1261 | 28 |
1211611 | 1211611 | 2021-04-11 | Wasco | Oregon | 41065 | 1258 | 28 |
1208362 | 1208362 | 2021-04-10 | Wasco | Oregon | 41065 | 1258 | 28 |
1205114 | 1205114 | 2021-04-09 | Wasco | Oregon | 41065 | 1252 | 28 |
1201866 | 1201866 | 2021-04-08 | Wasco | Oregon | 41065 | 1251 | 28 |
1198617 | 1198617 | 2021-04-07 | Wasco | Oregon | 41065 | 1250 | 28 |
1195368 | 1195368 | 2021-04-06 | Wasco | Oregon | 41065 | 1247 | 28 |
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);