ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Oregon" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 411 ✖
- 2022 41
- 2 40
- 1 25
- 794 18
- 849 16
- 6 10
- 9 9
- 803 9
- 2024 9
- 12 7
- 14 7
- 676 7
- 850 7
- 7 6
- 670 6
- 8 5
- 659 5
- 672 5
- 796 5
- 1430 5
- 4 4
- 16 4
- 25 4
- 173 4
- 795 4
- 805 4
- 843 4
- 847 4
- 856 4
- 1313 4
- 1331 4
- 1532 4
- 1562 4
- 1965 4
- 1995 4
- 2015 4
- 2018 4
- 2019 4
- 10 3
- 11 3
- 13 3
- 21 3
- 636 3
- 662 3
- 677 3
- 799 3
- 800 3
- 802 3
- 812 3
- 844 3
- 845 3
- 1303 3
- 1705 3
- 2006 3
- 2013 3
- 2017 3
- 3 2
- 47 2
- 50 2
- 64 2
- 71 2
- 99 2
- 126 2
- 152 2
- 212 2
- 223 2
- 228 2
- 314 2
- 418 2
- 485 2
- 517 2
- 554 2
- 651 2
- 663 2
- 798 2
- 810 2
- 811 2
- 818 2
- 821 2
- 846 2
- 848 2
- 851 2
- 871 2
- 1199 2
- 1293 2
- 1306 2
- 1314 2
- 1325 2
- 1328 2
- 1333 2
- 1335 2
- 1350 2
- 1365 2
- 1419 2
- 1446 2
- 1900 2
- 1941 2
- 2002 2
- 2009 2
- 2016 2
- 19 1
- 27 1
- 28 1
- 30 1
- 31 1
- 32 1
- 34 1
- 42 1
- 49 1
- 52 1
- 57 1
- 59 1
- 62 1
- 66 1
- 67 1
- 75 1
- 80 1
- 81 1
- 82 1
- 83 1
- 88 1
- 93 1
- 97 1
- 101 1
- 102 1
- 110 1
- 116 1
- 120 1
- 123 1
- 130 1
- 131 1
- 135 1
- 141 1
- 150 1
- 154 1
- 159 1
- 165 1
- 189 1
- 193 1
- 202 1
- 207 1
- 209 1
- 214 1
- 219 1
- 232 1
- 233 1
- 239 1
- 242 1
- 244 1
- 247 1
- 253 1
- 254 1
- 262 1
- 265 1
- 275 1
- 280 1
- 285 1
- 290 1
- 294 1
- 298 1
- 299 1
- 302 1
- 320 1
- 328 1
- 333 1
- 339 1
- 343 1
- 346 1
- 348 1
- 352 1
- 356 1
- 360 1
- 363 1
- 365 1
- 366 1
- 374 1
- 384 1
- 386 1
- 387 1
- 394 1
- 396 1
- 401 1
- 402 1
- 405 1
- 406 1
- 410 1
- 468 1
- 474 1
- 479 1
- 482 1
- 491 1
- 493 1
- 495 1
- 499 1
- 501 1
- 502 1
- 513 1
- 522 1
- 524 1
- 526 1
- 527 1
- 532 1
- 542 1
- 547 1
- 561 1
- 563 1
- 592 1
- 595 1
- 606 1
- 608 1
- 611 1
- 616 1
- 617 1
- 624 1
- 627 1
- 631 1
- 633 1
- 642 1
- 644 1
- 645 1
- 648 1
- 654 1
- 660 1
- 661 1
- 665 1
- 666 1
- 668 1
- 671 1
- 673 1
- 674 1
- 804 1
- 806 1
- 809 1
- 813 1
- 815 1
- 823 1
- 825 1
- 831 1
- 837 1
- 838 1
- 842 1
- 855 1
- 859 1
- 860 1
- 865 1
- 869 1
- 877 1
- 879 1
- 883 1
- 896 1
- 898 1
- 899 1
- 907 1
- 916 1
- 930 1
- 950 1
- 957 1
- 964 1
- 965 1
- 967 1
- 973 1
- 975 1
- 985 1
- 989 1
- 998 1
- 1001 1
- 1010 1
- 1016 1
- 1026 1
- 1036 1
- 1045 1
- 1053 1
- 1057 1
- 1061 1
- 1074 1
- 1077 1
- 1082 1
- 1085 1
- 1091 1
- 1092 1
- 1095 1
- 1103 1
- 1106 1
- 1115 1
- 1121 1
- 1124 1
- 1126 1
- 1133 1
- 1135 1
- 1136 1
- 1141 1
- 1152 1
- 1159 1
- 1160 1
- 1162 1
- 1168 1
- 1175 1
- 1183 1
- 1192 1
- 1196 1
- 1197 1
- 1204 1
- 1206 1
- 1210 1
- 1217 1
- 1218 1
- 1221 1
- 1222 1
- 1229 1
- 1235 1
- 1249 1
- 1256 1
- 1259 1
- 1261 1
- 1270 1
- 1277 1
- 1284 1
- 1286 1
- 1295 1
- 1300 1
- 1305 1
- 1307 1
- 1309 1
- 1316 1
- 1320 1
- 1322 1
- 1323 1
- 1327 1
- 1330 1
- 1332 1
- 1334 1
- 1337 1
- 1338 1
- 1340 1
- 1345 1
- 1352 1
- 1359 1
- 1369 1
- 1377 1
- 1380 1
- 1381 1
- 1391 1
- 1392 1
- 1409 1
- 1410 1
- 1417 1
- 1425 1
- 1439 1
- 1441 1
- 1442 1
- 1452 1
- 1454 1
- 1456 1
- 1460 1
- 1466 1
- 1474 1
- 1483 1
- 1487 1
- 1491 1
- 1495 1
- 1498 1
- 1502 1
- 1510 1
- 1514 1
- 1520 1
- 1522 1
- 1524 1
- 1527 1
- 1529 1
- 1535 1
- 1543 1
- 1554 1
- 1577 1
- 1586 1
- 1600 1
- 1601 1
- 1608 1
- 1619 1
- 1623 1
- 1629 1
- 1636 1
- 1641 1
- 1663 1
- 1675 1
- 1737 1
- 1743 1
- 1773 1
- 1774 1
- 1785 1
- 1801 1
- 1812 1
- 1818 1
- 1832 1
- 1855 1
- 1875 1
- 1890 1
- 1906 1
- 1920 1
- 1931 1
- 1933 1
- 1939 1
- 1951 1
- 1955 1
- 1978 1
- 1987 1
- 1991 1
- 1993 1
- 2005 1
- 2011 1
- 2012 1
- 2014 1
state 1
- Missouri · 767 ✖
fips 1
- 29149 767
county 1
- Oregon · 767 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501152 | 2501152 | 2022-05-13 | Oregon | Missouri | 29149 | 2024 | 33 |
2497894 | 2497894 | 2022-05-12 | Oregon | Missouri | 29149 | 2024 | 33 |
2494636 | 2494636 | 2022-05-11 | Oregon | Missouri | 29149 | 2024 | 33 |
2491378 | 2491378 | 2022-05-10 | Oregon | Missouri | 29149 | 2024 | 33 |
2488120 | 2488120 | 2022-05-09 | Oregon | Missouri | 29149 | 2024 | 33 |
2484863 | 2484863 | 2022-05-08 | Oregon | Missouri | 29149 | 2024 | 33 |
2481605 | 2481605 | 2022-05-07 | Oregon | Missouri | 29149 | 2024 | 33 |
2478347 | 2478347 | 2022-05-06 | Oregon | Missouri | 29149 | 2024 | 33 |
2475089 | 2475089 | 2022-05-05 | Oregon | Missouri | 29149 | 2024 | 33 |
2471832 | 2471832 | 2022-05-04 | Oregon | Missouri | 29149 | 2022 | 33 |
2468576 | 2468576 | 2022-05-03 | Oregon | Missouri | 29149 | 2022 | 33 |
2465320 | 2465320 | 2022-05-02 | Oregon | Missouri | 29149 | 2022 | 33 |
2462065 | 2462065 | 2022-05-01 | Oregon | Missouri | 29149 | 2022 | 33 |
2458809 | 2458809 | 2022-04-30 | Oregon | Missouri | 29149 | 2022 | 33 |
2455553 | 2455553 | 2022-04-29 | Oregon | Missouri | 29149 | 2022 | 33 |
2452297 | 2452297 | 2022-04-28 | Oregon | Missouri | 29149 | 2022 | 33 |
2449041 | 2449041 | 2022-04-27 | Oregon | Missouri | 29149 | 2022 | 33 |
2445784 | 2445784 | 2022-04-26 | Oregon | Missouri | 29149 | 2022 | 33 |
2442529 | 2442529 | 2022-04-25 | Oregon | Missouri | 29149 | 2022 | 33 |
2439273 | 2439273 | 2022-04-24 | Oregon | Missouri | 29149 | 2022 | 33 |
2436017 | 2436017 | 2022-04-23 | Oregon | Missouri | 29149 | 2022 | 33 |
2432761 | 2432761 | 2022-04-22 | Oregon | Missouri | 29149 | 2022 | 33 |
2429505 | 2429505 | 2022-04-21 | Oregon | Missouri | 29149 | 2022 | 33 |
2426249 | 2426249 | 2022-04-20 | Oregon | Missouri | 29149 | 2022 | 33 |
2422993 | 2422993 | 2022-04-19 | Oregon | Missouri | 29149 | 2022 | 33 |
2419736 | 2419736 | 2022-04-18 | Oregon | Missouri | 29149 | 2022 | 33 |
2416481 | 2416481 | 2022-04-17 | Oregon | Missouri | 29149 | 2022 | 33 |
2413225 | 2413225 | 2022-04-16 | Oregon | Missouri | 29149 | 2022 | 33 |
2409969 | 2409969 | 2022-04-15 | Oregon | Missouri | 29149 | 2022 | 33 |
2406713 | 2406713 | 2022-04-14 | Oregon | Missouri | 29149 | 2022 | 33 |
2403457 | 2403457 | 2022-04-13 | Oregon | Missouri | 29149 | 2022 | 33 |
2400202 | 2400202 | 2022-04-12 | Oregon | Missouri | 29149 | 2022 | 33 |
2396947 | 2396947 | 2022-04-11 | Oregon | Missouri | 29149 | 2022 | 33 |
2393692 | 2393692 | 2022-04-10 | Oregon | Missouri | 29149 | 2022 | 33 |
2390436 | 2390436 | 2022-04-09 | Oregon | Missouri | 29149 | 2022 | 33 |
2387180 | 2387180 | 2022-04-08 | Oregon | Missouri | 29149 | 2022 | 33 |
2383925 | 2383925 | 2022-04-07 | Oregon | Missouri | 29149 | 2022 | 33 |
2380670 | 2380670 | 2022-04-06 | Oregon | Missouri | 29149 | 2022 | 33 |
2377415 | 2377415 | 2022-04-05 | Oregon | Missouri | 29149 | 2022 | 33 |
2374162 | 2374162 | 2022-04-04 | Oregon | Missouri | 29149 | 2022 | 33 |
2370910 | 2370910 | 2022-04-03 | Oregon | Missouri | 29149 | 2022 | 33 |
2367657 | 2367657 | 2022-04-02 | Oregon | Missouri | 29149 | 2022 | 33 |
2364404 | 2364404 | 2022-04-01 | Oregon | Missouri | 29149 | 2022 | 33 |
2361150 | 2361150 | 2022-03-31 | Oregon | Missouri | 29149 | 2022 | 33 |
2357896 | 2357896 | 2022-03-30 | Oregon | Missouri | 29149 | 2022 | 33 |
2354643 | 2354643 | 2022-03-29 | Oregon | Missouri | 29149 | 2022 | 33 |
2351390 | 2351390 | 2022-03-28 | Oregon | Missouri | 29149 | 2022 | 33 |
2348138 | 2348138 | 2022-03-27 | Oregon | Missouri | 29149 | 2022 | 33 |
2344885 | 2344885 | 2022-03-26 | Oregon | Missouri | 29149 | 2022 | 33 |
2341632 | 2341632 | 2022-03-25 | Oregon | Missouri | 29149 | 2022 | 33 |
2338379 | 2338379 | 2022-03-24 | Oregon | Missouri | 29149 | 2019 | 33 |
2335125 | 2335125 | 2022-03-23 | Oregon | Missouri | 29149 | 2019 | 33 |
2331871 | 2331871 | 2022-03-22 | Oregon | Missouri | 29149 | 2019 | 33 |
2328618 | 2328618 | 2022-03-21 | Oregon | Missouri | 29149 | 2019 | 32 |
2325366 | 2325366 | 2022-03-20 | Oregon | Missouri | 29149 | 2018 | 32 |
2322112 | 2322112 | 2022-03-19 | Oregon | Missouri | 29149 | 2018 | 32 |
2318858 | 2318858 | 2022-03-18 | Oregon | Missouri | 29149 | 2018 | 32 |
2315605 | 2315605 | 2022-03-17 | Oregon | Missouri | 29149 | 2018 | 32 |
2312352 | 2312352 | 2022-03-16 | Oregon | Missouri | 29149 | 2017 | 32 |
2309099 | 2309099 | 2022-03-15 | Oregon | Missouri | 29149 | 2017 | 32 |
2305847 | 2305847 | 2022-03-14 | Oregon | Missouri | 29149 | 2016 | 32 |
2302596 | 2302596 | 2022-03-13 | Oregon | Missouri | 29149 | 2015 | 32 |
2299344 | 2299344 | 2022-03-12 | Oregon | Missouri | 29149 | 2015 | 32 |
2296092 | 2296092 | 2022-03-11 | Oregon | Missouri | 29149 | 2015 | 32 |
2292840 | 2292840 | 2022-03-10 | Oregon | Missouri | 29149 | 2017 | 32 |
2289588 | 2289588 | 2022-03-09 | Oregon | Missouri | 29149 | 2016 | 32 |
2286336 | 2286336 | 2022-03-08 | Oregon | Missouri | 29149 | 2015 | 32 |
2283084 | 2283084 | 2022-03-07 | Oregon | Missouri | 29149 | 2014 | 32 |
2279831 | 2279831 | 2022-03-06 | Oregon | Missouri | 29149 | 2013 | 32 |
2276578 | 2276578 | 2022-03-05 | Oregon | Missouri | 29149 | 2013 | 32 |
2273325 | 2273325 | 2022-03-04 | Oregon | Missouri | 29149 | 2013 | 32 |
2270073 | 2270073 | 2022-03-03 | Oregon | Missouri | 29149 | 2012 | 32 |
2266820 | 2266820 | 2022-03-02 | Oregon | Missouri | 29149 | 2011 | 32 |
2263569 | 2263569 | 2022-03-01 | Oregon | Missouri | 29149 | 2009 | 32 |
2260318 | 2260318 | 2022-02-28 | Oregon | Missouri | 29149 | 2009 | 31 |
2257067 | 2257067 | 2022-02-27 | Oregon | Missouri | 29149 | 2006 | 31 |
2253816 | 2253816 | 2022-02-26 | Oregon | Missouri | 29149 | 2006 | 31 |
2250565 | 2250565 | 2022-02-25 | Oregon | Missouri | 29149 | 2006 | 31 |
2247314 | 2247314 | 2022-02-24 | Oregon | Missouri | 29149 | 2005 | 31 |
2244063 | 2244063 | 2022-02-23 | Oregon | Missouri | 29149 | 2002 | 31 |
2240812 | 2240812 | 2022-02-22 | Oregon | Missouri | 29149 | 2002 | 31 |
2237561 | 2237561 | 2022-02-21 | Oregon | Missouri | 29149 | 1995 | 31 |
2234310 | 2234310 | 2022-02-20 | Oregon | Missouri | 29149 | 1995 | 31 |
2231059 | 2231059 | 2022-02-19 | Oregon | Missouri | 29149 | 1995 | 31 |
2227808 | 2227808 | 2022-02-18 | Oregon | Missouri | 29149 | 1995 | 31 |
2224557 | 2224557 | 2022-02-17 | Oregon | Missouri | 29149 | 1993 | 31 |
2221306 | 2221306 | 2022-02-16 | Oregon | Missouri | 29149 | 1991 | 31 |
2218055 | 2218055 | 2022-02-15 | Oregon | Missouri | 29149 | 1987 | 31 |
2214804 | 2214804 | 2022-02-14 | Oregon | Missouri | 29149 | 1978 | 29 |
2211552 | 2211552 | 2022-02-13 | Oregon | Missouri | 29149 | 1965 | 29 |
2208299 | 2208299 | 2022-02-12 | Oregon | Missouri | 29149 | 1965 | 29 |
2205046 | 2205046 | 2022-02-11 | Oregon | Missouri | 29149 | 1965 | 29 |
2201793 | 2201793 | 2022-02-10 | Oregon | Missouri | 29149 | 1965 | 29 |
2198539 | 2198539 | 2022-02-09 | Oregon | Missouri | 29149 | 1955 | 29 |
2195285 | 2195285 | 2022-02-08 | Oregon | Missouri | 29149 | 1951 | 28 |
2192031 | 2192031 | 2022-02-07 | Oregon | Missouri | 29149 | 1941 | 28 |
2188778 | 2188778 | 2022-02-06 | Oregon | Missouri | 29149 | 1941 | 28 |
2185525 | 2185525 | 2022-02-05 | Oregon | Missouri | 29149 | 1939 | 28 |
2182273 | 2182273 | 2022-02-04 | Oregon | Missouri | 29149 | 1933 | 28 |
2179021 | 2179021 | 2022-02-03 | Oregon | Missouri | 29149 | 1931 | 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);