ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,036 rows where state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Oregon · 330 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
17929 | 17929 | 2021-01-22 | Oregon | 41 | 136839 | 1874 |
17874 | 17874 | 2021-01-21 | Oregon | 41 | 135973 | 1850 |
17819 | 17819 | 2021-01-20 | Oregon | 41 | 135143 | 1841 |
17764 | 17764 | 2021-01-19 | Oregon | 41 | 134468 | 1816 |
17709 | 17709 | 2021-01-18 | Oregon | 41 | 133851 | 1811 |
17654 | 17654 | 2021-01-17 | Oregon | 41 | 133205 | 1801 |
17599 | 17599 | 2021-01-16 | Oregon | 41 | 132412 | 1800 |
17544 | 17544 | 2021-01-15 | Oregon | 41 | 131296 | 1763 |
17489 | 17489 | 2021-01-14 | Oregon | 41 | 130246 | 1737 |
17434 | 17434 | 2021-01-13 | Oregon | 41 | 129109 | 1716 |
17379 | 17379 | 2021-01-12 | Oregon | 41 | 127791 | 1669 |
17324 | 17324 | 2021-01-11 | Oregon | 41 | 126607 | 1628 |
17269 | 17269 | 2021-01-10 | Oregon | 41 | 125683 | 1607 |
17214 | 17214 | 2021-01-09 | Oregon | 41 | 124476 | 1607 |
17159 | 17159 | 2021-01-08 | Oregon | 41 | 122847 | 1590 |
17104 | 17104 | 2021-01-07 | Oregon | 41 | 121087 | 1577 |
17049 | 17049 | 2021-01-06 | Oregon | 41 | 120243 | 1571 |
16994 | 16994 | 2021-01-05 | Oregon | 41 | 119508 | 1550 |
16939 | 16939 | 2021-01-04 | Oregon | 41 | 118473 | 1517 |
16884 | 16884 | 2021-01-03 | Oregon | 41 | 117745 | 1510 |
16829 | 16829 | 2021-01-02 | Oregon | 41 | 116348 | 1503 |
16774 | 16774 | 2021-01-01 | Oregon | 41 | 115377 | 1501 |
16719 | 16719 | 2020-12-31 | Oregon | 41 | 113929 | 1485 |
16664 | 16664 | 2020-12-30 | Oregon | 41 | 112301 | 1478 |
16609 | 16609 | 2020-12-29 | Oregon | 41 | 111258 | 1457 |
16554 | 16554 | 2020-12-28 | Oregon | 41 | 110303 | 1438 |
16499 | 16499 | 2020-12-27 | Oregon | 41 | 109734 | 1436 |
16444 | 16444 | 2020-12-26 | Oregon | 41 | 108348 | 1431 |
16389 | 16389 | 2020-12-25 | Oregon | 41 | 107833 | 1431 |
16334 | 16334 | 2020-12-24 | Oregon | 41 | 106822 | 1417 |
16279 | 16279 | 2020-12-23 | Oregon | 41 | 106020 | 1409 |
16224 | 16224 | 2020-12-22 | Oregon | 41 | 105091 | 1382 |
16169 | 16169 | 2020-12-21 | Oregon | 41 | 103880 | 1351 |
16114 | 16114 | 2020-12-20 | Oregon | 41 | 102930 | 1341 |
16059 | 16059 | 2020-12-19 | Oregon | 41 | 101814 | 1340 |
16004 | 16004 | 2020-12-18 | Oregon | 41 | 100309 | 1306 |
15949 | 15949 | 2020-12-17 | Oregon | 41 | 98937 | 1284 |
15894 | 15894 | 2020-12-16 | Oregon | 41 | 97625 | 1267 |
15839 | 15839 | 2020-12-15 | Oregon | 41 | 96093 | 1213 |
15784 | 15784 | 2020-12-14 | Oregon | 41 | 95042 | 1168 |
15729 | 15729 | 2020-12-13 | Oregon | 41 | 93853 | 1158 |
15674 | 15674 | 2020-12-12 | Oregon | 41 | 92839 | 1155 |
15619 | 15619 | 2020-12-11 | Oregon | 41 | 91434 | 1147 |
15564 | 15564 | 2020-12-10 | Oregon | 41 | 89838 | 1124 |
15509 | 15509 | 2020-12-09 | Oregon | 41 | 88308 | 1112 |
15454 | 15454 | 2020-12-08 | Oregon | 41 | 87082 | 1082 |
15399 | 15399 | 2020-12-07 | Oregon | 41 | 85803 | 1049 |
15344 | 15344 | 2020-12-06 | Oregon | 41 | 84496 | 1033 |
15289 | 15289 | 2020-12-05 | Oregon | 41 | 83243 | 1027 |
15234 | 15234 | 2020-12-04 | Oregon | 41 | 81441 | 1004 |
15179 | 15179 | 2020-12-03 | Oregon | 41 | 79294 | 974 |
15124 | 15124 | 2020-12-02 | Oregon | 41 | 78206 | 962 |
15069 | 15069 | 2020-12-01 | Oregon | 41 | 76655 | 938 |
15014 | 15014 | 2020-11-30 | Oregon | 41 | 75454 | 919 |
14959 | 14959 | 2020-11-29 | Oregon | 41 | 74120 | 907 |
14904 | 14904 | 2020-11-28 | Oregon | 41 | 72506 | 899 |
14849 | 14849 | 2020-11-27 | Oregon | 41 | 70833 | 890 |
14794 | 14794 | 2020-11-26 | Oregon | 41 | 70006 | 884 |
14739 | 14739 | 2020-11-25 | Oregon | 41 | 68504 | 871 |
14684 | 14684 | 2020-11-24 | Oregon | 41 | 67337 | 848 |
14629 | 14629 | 2020-11-23 | Oregon | 41 | 66334 | 830 |
14574 | 14574 | 2020-11-22 | Oregon | 41 | 65170 | 822 |
14519 | 14519 | 2020-11-21 | Oregon | 41 | 63668 | 822 |
14464 | 14464 | 2020-11-20 | Oregon | 41 | 62176 | 815 |
14409 | 14409 | 2020-11-19 | Oregon | 41 | 60874 | 809 |
14354 | 14354 | 2020-11-18 | Oregon | 41 | 59670 | 791 |
14299 | 14299 | 2020-11-17 | Oregon | 41 | 58570 | 779 |
14244 | 14244 | 2020-11-16 | Oregon | 41 | 57646 | 772 |
14189 | 14189 | 2020-11-15 | Oregon | 41 | 56880 | 762 |
14134 | 14134 | 2020-11-14 | Oregon | 41 | 56018 | 760 |
14079 | 14079 | 2020-11-13 | Oregon | 41 | 54937 | 759 |
14024 | 14024 | 2020-11-12 | Oregon | 41 | 53879 | 748 |
13969 | 13969 | 2020-11-11 | Oregon | 41 | 52770 | 746 |
13914 | 13914 | 2020-11-10 | Oregon | 41 | 51909 | 741 |
13859 | 13859 | 2020-11-09 | Oregon | 41 | 51155 | 738 |
13804 | 13804 | 2020-11-08 | Oregon | 41 | 50448 | 730 |
13749 | 13749 | 2020-11-07 | Oregon | 41 | 49587 | 729 |
13694 | 13694 | 2020-11-06 | Oregon | 41 | 48608 | 716 |
13639 | 13639 | 2020-11-05 | Oregon | 41 | 47839 | 710 |
13584 | 13584 | 2020-11-04 | Oregon | 41 | 47049 | 707 |
13529 | 13529 | 2020-11-03 | Oregon | 41 | 46460 | 701 |
13474 | 13474 | 2020-11-02 | Oregon | 41 | 45978 | 694 |
13419 | 13419 | 2020-11-01 | Oregon | 41 | 45419 | 691 |
13364 | 13364 | 2020-10-31 | Oregon | 41 | 44923 | 690 |
13309 | 13309 | 2020-10-30 | Oregon | 41 | 44388 | 677 |
13254 | 13254 | 2020-10-29 | Oregon | 41 | 43793 | 674 |
13199 | 13199 | 2020-10-28 | Oregon | 41 | 43228 | 673 |
13144 | 13144 | 2020-10-27 | Oregon | 41 | 42821 | 665 |
13089 | 13089 | 2020-10-26 | Oregon | 41 | 42454 | 657 |
13034 | 13034 | 2020-10-25 | Oregon | 41 | 42101 | 654 |
12979 | 12979 | 2020-10-24 | Oregon | 41 | 41739 | 654 |
12924 | 12924 | 2020-10-23 | Oregon | 41 | 41357 | 651 |
12869 | 12869 | 2020-10-22 | Oregon | 41 | 40825 | 647 |
12814 | 12814 | 2020-10-21 | Oregon | 41 | 40458 | 638 |
12759 | 12759 | 2020-10-20 | Oregon | 41 | 40149 | 636 |
12704 | 12704 | 2020-10-19 | Oregon | 41 | 39799 | 630 |
12649 | 12649 | 2020-10-18 | Oregon | 41 | 39532 | 622 |
12594 | 12594 | 2020-10-17 | Oregon | 41 | 39316 | 622 |
12539 | 12539 | 2020-10-16 | Oregon | 41 | 38947 | 620 |
12484 | 12484 | 2020-10-15 | Oregon | 41 | 38536 | 613 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );