ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
196 rows where deaths = 19 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 |
---|---|---|---|---|---|---|---|
1994352 | 1994352 | 2021-12-08 | Lake | Oregon | 41037 | 1065 | 19 |
1809104 | 1809104 | 2021-10-12 | Curry | Oregon | 41015 | 1770 | 19 |
1805854 | 1805854 | 2021-10-11 | Curry | Oregon | 41015 | 1769 | 19 |
1802604 | 1802604 | 2021-10-10 | Curry | Oregon | 41015 | 1756 | 19 |
1799355 | 1799355 | 2021-10-09 | Curry | Oregon | 41015 | 1756 | 19 |
1796106 | 1796106 | 2021-10-08 | Curry | Oregon | 41015 | 1756 | 19 |
1792857 | 1792857 | 2021-10-07 | Curry | Oregon | 41015 | 1750 | 19 |
1789608 | 1789608 | 2021-10-06 | Curry | Oregon | 41015 | 1747 | 19 |
1786360 | 1786360 | 2021-10-05 | Curry | Oregon | 41015 | 1740 | 19 |
1783111 | 1783111 | 2021-10-04 | Curry | Oregon | 41015 | 1729 | 19 |
1740878 | 1740878 | 2021-09-21 | Harney | Oregon | 41025 | 823 | 19 |
1724618 | 1724618 | 2021-09-16 | Baker | Oregon | 41001 | 1691 | 19 |
1721369 | 1721369 | 2021-09-15 | Baker | Oregon | 41001 | 1669 | 19 |
1718121 | 1718121 | 2021-09-14 | Baker | Oregon | 41001 | 1631 | 19 |
1714873 | 1714873 | 2021-09-13 | Baker | Oregon | 41001 | 1614 | 19 |
1711627 | 1711627 | 2021-09-12 | Baker | Oregon | 41001 | 1561 | 19 |
1711655 | 1711655 | 2021-09-12 | Tillamook | Oregon | 41057 | 1685 | 19 |
1708380 | 1708380 | 2021-09-11 | Baker | Oregon | 41001 | 1561 | 19 |
1708408 | 1708408 | 2021-09-11 | Tillamook | Oregon | 41057 | 1685 | 19 |
1705133 | 1705133 | 2021-09-10 | Baker | Oregon | 41001 | 1561 | 19 |
1705161 | 1705161 | 2021-09-10 | Tillamook | Oregon | 41057 | 1685 | 19 |
1701883 | 1701883 | 2021-09-09 | Baker | Oregon | 41001 | 1524 | 19 |
1701911 | 1701911 | 2021-09-09 | Tillamook | Oregon | 41057 | 1648 | 19 |
1698634 | 1698634 | 2021-09-08 | Baker | Oregon | 41001 | 1502 | 19 |
1695386 | 1695386 | 2021-09-07 | Baker | Oregon | 41001 | 1489 | 19 |
1692138 | 1692138 | 2021-09-06 | Baker | Oregon | 41001 | 1456 | 19 |
1688889 | 1688889 | 2021-09-05 | Baker | Oregon | 41001 | 1456 | 19 |
1685639 | 1685639 | 2021-09-04 | Baker | Oregon | 41001 | 1456 | 19 |
1682388 | 1682388 | 2021-09-03 | Baker | Oregon | 41001 | 1456 | 19 |
1679138 | 1679138 | 2021-09-02 | Baker | Oregon | 41001 | 1444 | 19 |
1675890 | 1675890 | 2021-09-01 | Baker | Oregon | 41001 | 1426 | 19 |
1672643 | 1672643 | 2021-08-31 | Baker | Oregon | 41001 | 1413 | 19 |
1669395 | 1669395 | 2021-08-30 | Baker | Oregon | 41001 | 1401 | 19 |
1666148 | 1666148 | 2021-08-29 | Baker | Oregon | 41001 | 1384 | 19 |
1662900 | 1662900 | 2021-08-28 | Baker | Oregon | 41001 | 1384 | 19 |
1659652 | 1659652 | 2021-08-27 | Baker | Oregon | 41001 | 1384 | 19 |
1656403 | 1656403 | 2021-08-26 | Baker | Oregon | 41001 | 1375 | 19 |
1653156 | 1653156 | 2021-08-25 | Baker | Oregon | 41001 | 1361 | 19 |
1649909 | 1649909 | 2021-08-24 | Baker | Oregon | 41001 | 1352 | 19 |
1646660 | 1646660 | 2021-08-23 | Baker | Oregon | 41001 | 1345 | 19 |
1643411 | 1643411 | 2021-08-22 | Baker | Oregon | 41001 | 1316 | 19 |
1640161 | 1640161 | 2021-08-21 | Baker | Oregon | 41001 | 1316 | 19 |
1636911 | 1636911 | 2021-08-20 | Baker | Oregon | 41001 | 1316 | 19 |
1633661 | 1633661 | 2021-08-19 | Baker | Oregon | 41001 | 1309 | 19 |
1315482 | 1315482 | 2021-05-13 | Benton | Oregon | 41003 | 3100 | 19 |
1312236 | 1312236 | 2021-05-12 | Benton | Oregon | 41003 | 3085 | 19 |
1308989 | 1308989 | 2021-05-11 | Benton | Oregon | 41003 | 3071 | 19 |
1305743 | 1305743 | 2021-05-10 | Benton | Oregon | 41003 | 3060 | 19 |
1302497 | 1302497 | 2021-05-09 | Benton | Oregon | 41003 | 3039 | 19 |
1299249 | 1299249 | 2021-05-08 | Benton | Oregon | 41003 | 3026 | 19 |
1296003 | 1296003 | 2021-05-07 | Benton | Oregon | 41003 | 3016 | 19 |
1292757 | 1292757 | 2021-05-06 | Benton | Oregon | 41003 | 3000 | 19 |
1289511 | 1289511 | 2021-05-05 | Benton | Oregon | 41003 | 2985 | 19 |
1286265 | 1286265 | 2021-05-04 | Benton | Oregon | 41003 | 2966 | 19 |
1283019 | 1283019 | 2021-05-03 | Benton | Oregon | 41003 | 2946 | 19 |
1279772 | 1279772 | 2021-05-02 | Benton | Oregon | 41003 | 2934 | 19 |
1276525 | 1276525 | 2021-05-01 | Benton | Oregon | 41003 | 2917 | 19 |
1273278 | 1273278 | 2021-04-30 | Benton | Oregon | 41003 | 2907 | 19 |
1270031 | 1270031 | 2021-04-29 | Benton | Oregon | 41003 | 2881 | 19 |
1270036 | 1270036 | 2021-04-29 | Crook | Oregon | 41013 | 977 | 19 |
1266784 | 1266784 | 2021-04-28 | Benton | Oregon | 41003 | 2873 | 19 |
1266789 | 1266789 | 2021-04-28 | Crook | Oregon | 41013 | 967 | 19 |
1263537 | 1263537 | 2021-04-27 | Benton | Oregon | 41003 | 2853 | 19 |
1263542 | 1263542 | 2021-04-27 | Crook | Oregon | 41013 | 957 | 19 |
1260290 | 1260290 | 2021-04-26 | Benton | Oregon | 41003 | 2833 | 19 |
1260295 | 1260295 | 2021-04-26 | Crook | Oregon | 41013 | 949 | 19 |
1257043 | 1257043 | 2021-04-25 | Benton | Oregon | 41003 | 2832 | 19 |
1257048 | 1257048 | 2021-04-25 | Crook | Oregon | 41013 | 946 | 19 |
1253796 | 1253796 | 2021-04-24 | Benton | Oregon | 41003 | 2823 | 19 |
1253801 | 1253801 | 2021-04-24 | Crook | Oregon | 41013 | 931 | 19 |
1250549 | 1250549 | 2021-04-23 | Benton | Oregon | 41003 | 2811 | 19 |
1250554 | 1250554 | 2021-04-23 | Crook | Oregon | 41013 | 923 | 19 |
1247302 | 1247302 | 2021-04-22 | Benton | Oregon | 41003 | 2802 | 19 |
1247307 | 1247307 | 2021-04-22 | Crook | Oregon | 41013 | 907 | 19 |
1244055 | 1244055 | 2021-04-21 | Benton | Oregon | 41003 | 2777 | 19 |
1244060 | 1244060 | 2021-04-21 | Crook | Oregon | 41013 | 895 | 19 |
1240813 | 1240813 | 2021-04-20 | Crook | Oregon | 41013 | 891 | 19 |
1237566 | 1237566 | 2021-04-19 | Crook | Oregon | 41013 | 881 | 19 |
1234319 | 1234319 | 2021-04-18 | Crook | Oregon | 41013 | 880 | 19 |
1231071 | 1231071 | 2021-04-17 | Crook | Oregon | 41013 | 878 | 19 |
1227823 | 1227823 | 2021-04-16 | Crook | Oregon | 41013 | 868 | 19 |
1224575 | 1224575 | 2021-04-15 | Crook | Oregon | 41013 | 853 | 19 |
1221328 | 1221328 | 2021-04-14 | Crook | Oregon | 41013 | 848 | 19 |
1218080 | 1218080 | 2021-04-13 | Crook | Oregon | 41013 | 846 | 19 |
1214832 | 1214832 | 2021-04-12 | Crook | Oregon | 41013 | 839 | 19 |
1211585 | 1211585 | 2021-04-11 | Crook | Oregon | 41013 | 839 | 19 |
1208336 | 1208336 | 2021-04-10 | Crook | Oregon | 41013 | 836 | 19 |
1205088 | 1205088 | 2021-04-09 | Crook | Oregon | 41013 | 828 | 19 |
1201840 | 1201840 | 2021-04-08 | Crook | Oregon | 41013 | 828 | 19 |
1198591 | 1198591 | 2021-04-07 | Crook | Oregon | 41013 | 824 | 19 |
1195342 | 1195342 | 2021-04-06 | Crook | Oregon | 41013 | 823 | 19 |
1107695 | 1107695 | 2021-03-10 | Union | Oregon | 41061 | 1314 | 19 |
1104449 | 1104449 | 2021-03-09 | Union | Oregon | 41061 | 1312 | 19 |
1101203 | 1101203 | 2021-03-08 | Union | Oregon | 41061 | 1305 | 19 |
1097957 | 1097957 | 2021-03-07 | Union | Oregon | 41061 | 1305 | 19 |
1094709 | 1094709 | 2021-03-06 | Union | Oregon | 41061 | 1305 | 19 |
1091463 | 1091463 | 2021-03-05 | Union | Oregon | 41061 | 1305 | 19 |
1088217 | 1088217 | 2021-03-04 | Union | Oregon | 41061 | 1303 | 19 |
1084972 | 1084972 | 2021-03-03 | Union | Oregon | 41061 | 1295 | 19 |
1081726 | 1081726 | 2021-03-02 | Union | Oregon | 41061 | 1285 | 19 |
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);