ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 41023 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 265 ✖
- 1 124
- 8 32
- 10 27
- 217 16
- 2 15
- 4 15
- 552 14
- 556 13
- 567 13
- 1694 13
- 1083 9
- 170 8
- 529 8
- 1546 8
- 213 7
- 11 6
- 174 6
- 220 6
- 221 6
- 168 5
- 222 5
- 230 5
- 548 5
- 557 5
- 680 5
- 1008 5
- 1072 5
- 1134 5
- 1676 5
- 1701 5
- 66 4
- 134 4
- 164 4
- 506 4
- 527 4
- 563 4
- 753 4
- 915 4
- 944 4
- 1000 4
- 1085 4
- 1091 4
- 1109 4
- 1174 4
- 1285 4
- 1374 4
- 1469 4
- 1506 4
- 1528 4
- 1647 4
- 1692 4
- 9 3
- 12 3
- 142 3
- 158 3
- 161 3
- 218 3
- 223 3
- 493 3
- 528 3
- 538 3
- 547 3
- 550 3
- 581 3
- 635 3
- 715 3
- 867 3
- 976 3
- 1039 3
- 1095 3
- 1231 3
- 1555 3
- 1572 3
- 1609 3
- 1660 3
- 1670 3
- 14 2
- 53 2
- 65 2
- 182 2
- 248 2
- 259 2
- 262 2
- 266 2
- 272 2
- 288 2
- 300 2
- 341 2
- 412 2
- 436 2
- 480 2
- 509 2
- 522 2
- 523 2
- 536 2
- 539 2
- 545 2
- 553 2
- 565 2
- 965 2
- 995 2
- 1002 2
- 1070 2
- 1092 2
- 1096 2
- 1108 2
- 1564 2
- 1667 2
- 1673 2
- 1697 2
- 1702 2
- 1704 2
- 3 1
- 18 1
- 20 1
- 25 1
- 32 1
- 49 1
- 56 1
- 61 1
- 71 1
- 74 1
- 101 1
- 109 1
- 122 1
- 123 1
- 127 1
- 130 1
- 133 1
- 137 1
- 138 1
- 139 1
- 143 1
- 150 1
- 154 1
- 155 1
- 159 1
- 165 1
- 166 1
- 171 1
- 219 1
- 225 1
- 227 1
- 235 1
- 236 1
- 240 1
- 243 1
- 251 1
- 256 1
- 257 1
- 263 1
- 270 1
- 271 1
- 275 1
- 281 1
- 289 1
- 291 1
- 292 1
- 307 1
- 331 1
- 334 1
- 346 1
- 378 1
- 379 1
- 404 1
- 406 1
- 420 1
- 430 1
- 431 1
- 464 1
- 468 1
- 475 1
- 492 1
- 496 1
- 498 1
- 501 1
- 507 1
- 551 1
- 558 1
- 559 1
- 562 1
- 568 1
- 577 1
- 591 1
- 595 1
- 601 1
- 630 1
- 652 1
- 658 1
- 664 1
- 673 1
- 682 1
- 702 1
- 726 1
- 743 1
- 752 1
- 755 1
- 784 1
- 852 1
- 856 1
- 889 1
- 896 1
- 897 1
- 925 1
- 927 1
- 942 1
- 948 1
- 975 1
- 980 1
- 1014 1
- 1016 1
- 1021 1
- 1024 1
- 1041 1
- 1071 1
- 1073 1
- 1077 1
- 1082 1
- 1094 1
- 1125 1
- 1139 1
- 1155 1
- 1166 1
- 1177 1
- 1183 1
- 1209 1
- 1223 1
- 1239 1
- 1269 1
- 1270 1
- 1280 1
- 1306 1
- 1309 1
- 1410 1
- 1411 1
- 1452 1
- 1454 1
- 1479 1
- 1485 1
- 1491 1
- 1519 1
- 1526 1
- 1527 1
- 1533 1
- 1536 1
- 1558 1
- 1569 1
- 1585 1
- 1593 1
- 1597 1
- 1603 1
- 1626 1
- 1632 1
- 1635 1
- 1644 1
- 1652 1
- 1655 1
- 1658 1
- 1662 1
- 1669 1
- 1671 1
- 1681 1
- 1683 1
- 1687 1
- 1696 1
state 1
- Oregon · 785 ✖
fips 1
- 41023 · 785 ✖
county 1
- Grant 785
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501822 | 2501822 | 2022-05-13 | Grant | Oregon | 41023 | 1704 | 21 |
2498564 | 2498564 | 2022-05-12 | Grant | Oregon | 41023 | 1704 | 21 |
2495306 | 2495306 | 2022-05-11 | Grant | Oregon | 41023 | 1702 | 21 |
2492048 | 2492048 | 2022-05-10 | Grant | Oregon | 41023 | 1702 | 21 |
2488790 | 2488790 | 2022-05-09 | Grant | Oregon | 41023 | 1701 | 21 |
2485533 | 2485533 | 2022-05-08 | Grant | Oregon | 41023 | 1701 | 21 |
2482275 | 2482275 | 2022-05-07 | Grant | Oregon | 41023 | 1701 | 21 |
2479017 | 2479017 | 2022-05-06 | Grant | Oregon | 41023 | 1701 | 21 |
2475759 | 2475759 | 2022-05-05 | Grant | Oregon | 41023 | 1701 | 21 |
2472502 | 2472502 | 2022-05-04 | Grant | Oregon | 41023 | 1697 | 21 |
2469246 | 2469246 | 2022-05-03 | Grant | Oregon | 41023 | 1696 | 21 |
2465990 | 2465990 | 2022-05-02 | Grant | Oregon | 41023 | 1697 | 21 |
2462735 | 2462735 | 2022-05-01 | Grant | Oregon | 41023 | 1694 | 21 |
2459479 | 2459479 | 2022-04-30 | Grant | Oregon | 41023 | 1694 | 21 |
2456223 | 2456223 | 2022-04-29 | Grant | Oregon | 41023 | 1694 | 21 |
2452967 | 2452967 | 2022-04-28 | Grant | Oregon | 41023 | 1694 | 21 |
2449711 | 2449711 | 2022-04-27 | Grant | Oregon | 41023 | 1694 | 21 |
2446454 | 2446454 | 2022-04-26 | Grant | Oregon | 41023 | 1694 | 21 |
2443199 | 2443199 | 2022-04-25 | Grant | Oregon | 41023 | 1694 | 21 |
2439943 | 2439943 | 2022-04-24 | Grant | Oregon | 41023 | 1694 | 21 |
2436687 | 2436687 | 2022-04-23 | Grant | Oregon | 41023 | 1694 | 21 |
2433431 | 2433431 | 2022-04-22 | Grant | Oregon | 41023 | 1694 | 21 |
2430175 | 2430175 | 2022-04-21 | Grant | Oregon | 41023 | 1694 | 21 |
2426919 | 2426919 | 2022-04-20 | Grant | Oregon | 41023 | 1694 | 21 |
2423663 | 2423663 | 2022-04-19 | Grant | Oregon | 41023 | 1694 | 22 |
2420406 | 2420406 | 2022-04-18 | Grant | Oregon | 41023 | 1692 | 22 |
2417151 | 2417151 | 2022-04-17 | Grant | Oregon | 41023 | 1692 | 22 |
2413895 | 2413895 | 2022-04-16 | Grant | Oregon | 41023 | 1692 | 22 |
2410639 | 2410639 | 2022-04-15 | Grant | Oregon | 41023 | 1692 | 22 |
2407383 | 2407383 | 2022-04-14 | Grant | Oregon | 41023 | 1687 | 22 |
2404127 | 2404127 | 2022-04-13 | Grant | Oregon | 41023 | 1683 | 22 |
2400872 | 2400872 | 2022-04-12 | Grant | Oregon | 41023 | 1681 | 22 |
2397617 | 2397617 | 2022-04-11 | Grant | Oregon | 41023 | 1676 | 22 |
2394362 | 2394362 | 2022-04-10 | Grant | Oregon | 41023 | 1676 | 22 |
2391106 | 2391106 | 2022-04-09 | Grant | Oregon | 41023 | 1676 | 22 |
2387850 | 2387850 | 2022-04-08 | Grant | Oregon | 41023 | 1676 | 22 |
2384595 | 2384595 | 2022-04-07 | Grant | Oregon | 41023 | 1676 | 22 |
2381340 | 2381340 | 2022-04-06 | Grant | Oregon | 41023 | 1673 | 21 |
2378085 | 2378085 | 2022-04-05 | Grant | Oregon | 41023 | 1673 | 21 |
2374831 | 2374831 | 2022-04-04 | Grant | Oregon | 41023 | 1671 | 21 |
2371579 | 2371579 | 2022-04-03 | Grant | Oregon | 41023 | 1670 | 20 |
2368326 | 2368326 | 2022-04-02 | Grant | Oregon | 41023 | 1670 | 20 |
2365073 | 2365073 | 2022-04-01 | Grant | Oregon | 41023 | 1670 | 20 |
2361820 | 2361820 | 2022-03-31 | Grant | Oregon | 41023 | 1669 | 20 |
2358566 | 2358566 | 2022-03-30 | Grant | Oregon | 41023 | 1667 | 20 |
2355312 | 2355312 | 2022-03-29 | Grant | Oregon | 41023 | 1667 | 20 |
2352059 | 2352059 | 2022-03-28 | Grant | Oregon | 41023 | 1662 | 20 |
2348807 | 2348807 | 2022-03-27 | Grant | Oregon | 41023 | 1660 | 20 |
2345554 | 2345554 | 2022-03-26 | Grant | Oregon | 41023 | 1660 | 20 |
2342301 | 2342301 | 2022-03-25 | Grant | Oregon | 41023 | 1660 | 20 |
2339048 | 2339048 | 2022-03-24 | Grant | Oregon | 41023 | 1658 | 20 |
2335794 | 2335794 | 2022-03-23 | Grant | Oregon | 41023 | 1655 | 20 |
2332540 | 2332540 | 2022-03-22 | Grant | Oregon | 41023 | 1652 | 18 |
2329287 | 2329287 | 2022-03-21 | Grant | Oregon | 41023 | 1647 | 18 |
2326035 | 2326035 | 2022-03-20 | Grant | Oregon | 41023 | 1647 | 18 |
2322782 | 2322782 | 2022-03-19 | Grant | Oregon | 41023 | 1647 | 18 |
2319528 | 2319528 | 2022-03-18 | Grant | Oregon | 41023 | 1647 | 18 |
2316274 | 2316274 | 2022-03-17 | Grant | Oregon | 41023 | 1644 | 18 |
2313021 | 2313021 | 2022-03-16 | Grant | Oregon | 41023 | 1635 | 18 |
2309768 | 2309768 | 2022-03-15 | Grant | Oregon | 41023 | 1632 | 18 |
2306515 | 2306515 | 2022-03-14 | Grant | Oregon | 41023 | 1626 | 18 |
2303264 | 2303264 | 2022-03-13 | Grant | Oregon | 41023 | 1609 | 18 |
2300012 | 2300012 | 2022-03-12 | Grant | Oregon | 41023 | 1609 | 18 |
2296760 | 2296760 | 2022-03-11 | Grant | Oregon | 41023 | 1609 | 18 |
2293508 | 2293508 | 2022-03-10 | Grant | Oregon | 41023 | 1603 | 18 |
2290256 | 2290256 | 2022-03-09 | Grant | Oregon | 41023 | 1597 | 18 |
2287004 | 2287004 | 2022-03-08 | Grant | Oregon | 41023 | 1593 | 18 |
2283752 | 2283752 | 2022-03-07 | Grant | Oregon | 41023 | 1585 | 18 |
2280500 | 2280500 | 2022-03-06 | Grant | Oregon | 41023 | 1572 | 18 |
2277247 | 2277247 | 2022-03-05 | Grant | Oregon | 41023 | 1572 | 18 |
2273994 | 2273994 | 2022-03-04 | Grant | Oregon | 41023 | 1572 | 18 |
2270741 | 2270741 | 2022-03-03 | Grant | Oregon | 41023 | 1569 | 18 |
2267489 | 2267489 | 2022-03-02 | Grant | Oregon | 41023 | 1564 | 18 |
2264236 | 2264236 | 2022-03-01 | Grant | Oregon | 41023 | 1564 | 18 |
2260986 | 2260986 | 2022-02-28 | Grant | Oregon | 41023 | 1558 | 18 |
2257735 | 2257735 | 2022-02-27 | Grant | Oregon | 41023 | 1555 | 18 |
2254484 | 2254484 | 2022-02-26 | Grant | Oregon | 41023 | 1555 | 18 |
2251233 | 2251233 | 2022-02-25 | Grant | Oregon | 41023 | 1555 | 18 |
2247982 | 2247982 | 2022-02-24 | Grant | Oregon | 41023 | 1546 | 18 |
2244731 | 2244731 | 2022-02-23 | Grant | Oregon | 41023 | 1546 | 18 |
2241480 | 2241480 | 2022-02-22 | Grant | Oregon | 41023 | 1546 | 18 |
2238229 | 2238229 | 2022-02-21 | Grant | Oregon | 41023 | 1546 | 18 |
2234978 | 2234978 | 2022-02-20 | Grant | Oregon | 41023 | 1546 | 18 |
2231727 | 2231727 | 2022-02-19 | Grant | Oregon | 41023 | 1546 | 18 |
2228476 | 2228476 | 2022-02-18 | Grant | Oregon | 41023 | 1546 | 18 |
2225225 | 2225225 | 2022-02-17 | Grant | Oregon | 41023 | 1546 | 18 |
2221974 | 2221974 | 2022-02-16 | Grant | Oregon | 41023 | 1536 | 18 |
2218723 | 2218723 | 2022-02-15 | Grant | Oregon | 41023 | 1533 | 18 |
2215472 | 2215472 | 2022-02-14 | Grant | Oregon | 41023 | 1528 | 18 |
2212221 | 2212221 | 2022-02-13 | Grant | Oregon | 41023 | 1528 | 18 |
2208968 | 2208968 | 2022-02-12 | Grant | Oregon | 41023 | 1528 | 18 |
2205715 | 2205715 | 2022-02-11 | Grant | Oregon | 41023 | 1528 | 18 |
2202462 | 2202462 | 2022-02-10 | Grant | Oregon | 41023 | 1526 | 18 |
2199208 | 2199208 | 2022-02-09 | Grant | Oregon | 41023 | 1527 | 18 |
2195954 | 2195954 | 2022-02-08 | Grant | Oregon | 41023 | 1519 | 18 |
2192700 | 2192700 | 2022-02-07 | Grant | Oregon | 41023 | 1506 | 18 |
2189446 | 2189446 | 2022-02-06 | Grant | Oregon | 41023 | 1506 | 18 |
2186193 | 2186193 | 2022-02-05 | Grant | Oregon | 41023 | 1506 | 18 |
2182941 | 2182941 | 2022-02-04 | Grant | Oregon | 41023 | 1506 | 18 |
2179689 | 2179689 | 2022-02-03 | Grant | Oregon | 41023 | 1491 | 18 |
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);