ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
150 rows where deaths = 28 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 |
---|---|---|---|---|---|---|---|
2439950 | 2439950 | 2022-04-24 | Lake | Oregon | 41037 | 1417 | 28 |
2436694 | 2436694 | 2022-04-23 | Lake | Oregon | 41037 | 1417 | 28 |
2433438 | 2433438 | 2022-04-22 | Lake | Oregon | 41037 | 1417 | 28 |
2430182 | 2430182 | 2022-04-21 | Lake | Oregon | 41037 | 1413 | 28 |
2426926 | 2426926 | 2022-04-20 | Lake | Oregon | 41037 | 1412 | 28 |
1880580 | 1880580 | 2021-11-03 | Clatsop | Oregon | 41007 | 2483 | 28 |
1877331 | 1877331 | 2021-11-02 | Clatsop | Oregon | 41007 | 2478 | 28 |
1874082 | 1874082 | 2021-11-01 | Clatsop | Oregon | 41007 | 2475 | 28 |
1870833 | 1870833 | 2021-10-31 | Clatsop | Oregon | 41007 | 2467 | 28 |
1870842 | 1870842 | 2021-10-31 | Harney | Oregon | 41025 | 1158 | 28 |
1867584 | 1867584 | 2021-10-30 | Clatsop | Oregon | 41007 | 2467 | 28 |
1867593 | 1867593 | 2021-10-30 | Harney | Oregon | 41025 | 1158 | 28 |
1864335 | 1864335 | 2021-10-29 | Clatsop | Oregon | 41007 | 2467 | 28 |
1864344 | 1864344 | 2021-10-29 | Harney | Oregon | 41025 | 1158 | 28 |
1861086 | 1861086 | 2021-10-28 | Clatsop | Oregon | 41007 | 2461 | 28 |
1857837 | 1857837 | 2021-10-27 | Clatsop | Oregon | 41007 | 2455 | 28 |
1854588 | 1854588 | 2021-10-26 | Clatsop | Oregon | 41007 | 2448 | 28 |
1851339 | 1851339 | 2021-10-25 | Clatsop | Oregon | 41007 | 2447 | 28 |
1848089 | 1848089 | 2021-10-24 | Clatsop | Oregon | 41007 | 2443 | 28 |
1844839 | 1844839 | 2021-10-23 | Clatsop | Oregon | 41007 | 2443 | 28 |
1841589 | 1841589 | 2021-10-22 | Clatsop | Oregon | 41007 | 2443 | 28 |
1835088 | 1835088 | 2021-10-20 | Baker | Oregon | 41001 | 2015 | 28 |
1831839 | 1831839 | 2021-10-19 | Baker | Oregon | 41001 | 1999 | 28 |
1828590 | 1828590 | 2021-10-18 | Baker | Oregon | 41001 | 1992 | 28 |
1825341 | 1825341 | 2021-10-17 | Baker | Oregon | 41001 | 1980 | 28 |
1825369 | 1825369 | 2021-10-17 | Tillamook | Oregon | 41057 | 1933 | 28 |
1822092 | 1822092 | 2021-10-16 | Baker | Oregon | 41001 | 1980 | 28 |
1822120 | 1822120 | 2021-10-16 | Tillamook | Oregon | 41057 | 1933 | 28 |
1818843 | 1818843 | 2021-10-15 | Baker | Oregon | 41001 | 1980 | 28 |
1818871 | 1818871 | 2021-10-15 | Tillamook | Oregon | 41057 | 1933 | 28 |
1815594 | 1815594 | 2021-10-14 | Baker | Oregon | 41001 | 1974 | 28 |
1815597 | 1815597 | 2021-10-14 | Clatsop | Oregon | 41007 | 2389 | 28 |
1812346 | 1812346 | 2021-10-13 | Baker | Oregon | 41001 | 1963 | 28 |
1812349 | 1812349 | 2021-10-13 | Clatsop | Oregon | 41007 | 2382 | 28 |
1809097 | 1809097 | 2021-10-12 | Baker | Oregon | 41001 | 1956 | 28 |
1757111 | 1757111 | 2021-09-26 | Benton | Oregon | 41003 | 4742 | 28 |
1753863 | 1753863 | 2021-09-25 | Benton | Oregon | 41003 | 4742 | 28 |
1750615 | 1750615 | 2021-09-24 | Benton | Oregon | 41003 | 4742 | 28 |
1747365 | 1747365 | 2021-09-23 | Benton | Oregon | 41003 | 4706 | 28 |
1744116 | 1744116 | 2021-09-22 | Benton | Oregon | 41003 | 4678 | 28 |
1740867 | 1740867 | 2021-09-21 | Benton | Oregon | 41003 | 4637 | 28 |
1630420 | 1630420 | 2021-08-18 | Crook | Oregon | 41013 | 1624 | 28 |
1627173 | 1627173 | 2021-08-17 | Crook | Oregon | 41013 | 1587 | 28 |
1623926 | 1623926 | 2021-08-16 | Crook | Oregon | 41013 | 1560 | 28 |
1607710 | 1607710 | 2021-08-11 | Union | Oregon | 41061 | 1863 | 28 |
1604461 | 1604461 | 2021-08-10 | Union | Oregon | 41061 | 1847 | 28 |
1601212 | 1601212 | 2021-08-09 | Union | Oregon | 41061 | 1830 | 28 |
1597964 | 1597964 | 2021-08-08 | Union | Oregon | 41061 | 1784 | 28 |
1594715 | 1594715 | 2021-08-07 | Union | Oregon | 41061 | 1784 | 28 |
1591466 | 1591466 | 2021-08-06 | Union | Oregon | 41061 | 1784 | 28 |
1588217 | 1588217 | 2021-08-05 | Union | Oregon | 41061 | 1765 | 28 |
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 |
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);