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 · 901 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
49663 | 49663 | 2022-08-16 | Oregon | 41 | 867919 | 8312 |
49607 | 49607 | 2022-08-15 | Oregon | 41 | 866763 | 8292 |
49551 | 49551 | 2022-08-14 | Oregon | 41 | 864935 | 8267 |
49495 | 49495 | 2022-08-13 | Oregon | 41 | 864935 | 8267 |
49439 | 49439 | 2022-08-12 | Oregon | 41 | 864935 | 8267 |
49383 | 49383 | 2022-08-11 | Oregon | 41 | 864083 | 8257 |
49327 | 49327 | 2022-08-10 | Oregon | 41 | 863045 | 8252 |
49271 | 49271 | 2022-08-09 | Oregon | 41 | 861994 | 8240 |
49215 | 49215 | 2022-08-08 | Oregon | 41 | 860734 | 8219 |
49159 | 49159 | 2022-08-07 | Oregon | 41 | 858796 | 8211 |
49103 | 49103 | 2022-08-06 | Oregon | 41 | 858796 | 8211 |
49047 | 49047 | 2022-08-05 | Oregon | 41 | 858796 | 8211 |
48991 | 48991 | 2022-08-04 | Oregon | 41 | 857426 | 8192 |
48935 | 48935 | 2022-08-03 | Oregon | 41 | 856231 | 8174 |
48879 | 48879 | 2022-08-02 | Oregon | 41 | 854082 | 8160 |
48823 | 48823 | 2022-08-01 | Oregon | 41 | 852951 | 8130 |
48767 | 48767 | 2022-07-31 | Oregon | 41 | 850355 | 8101 |
48711 | 48711 | 2022-07-30 | Oregon | 41 | 850355 | 8101 |
48655 | 48655 | 2022-07-29 | Oregon | 41 | 850355 | 8101 |
48599 | 48599 | 2022-07-28 | Oregon | 41 | 848903 | 8072 |
48543 | 48543 | 2022-07-27 | Oregon | 41 | 848046 | 8061 |
48487 | 48487 | 2022-07-26 | Oregon | 41 | 846692 | 8043 |
48431 | 48431 | 2022-07-25 | Oregon | 41 | 845331 | 8036 |
48375 | 48375 | 2022-07-24 | Oregon | 41 | 842352 | 8022 |
48319 | 48319 | 2022-07-23 | Oregon | 41 | 842352 | 8022 |
48263 | 48263 | 2022-07-22 | Oregon | 41 | 842352 | 8022 |
48207 | 48207 | 2022-07-21 | Oregon | 41 | 841001 | 7996 |
48151 | 48151 | 2022-07-20 | Oregon | 41 | 839295 | 7981 |
48095 | 48095 | 2022-07-19 | Oregon | 41 | 837874 | 7957 |
48039 | 48039 | 2022-07-18 | Oregon | 41 | 836353 | 7944 |
47983 | 47983 | 2022-07-17 | Oregon | 41 | 833343 | 7910 |
47927 | 47927 | 2022-07-16 | Oregon | 41 | 833343 | 7910 |
47871 | 47871 | 2022-07-15 | Oregon | 41 | 833343 | 7910 |
47815 | 47815 | 2022-07-14 | Oregon | 41 | 831173 | 7897 |
47759 | 47759 | 2022-07-13 | Oregon | 41 | 830062 | 7884 |
47703 | 47703 | 2022-07-12 | Oregon | 41 | 828442 | 7873 |
47647 | 47647 | 2022-07-11 | Oregon | 41 | 826600 | 7862 |
47591 | 47591 | 2022-07-10 | Oregon | 41 | 823249 | 7851 |
47535 | 47535 | 2022-07-09 | Oregon | 41 | 823249 | 7851 |
47479 | 47479 | 2022-07-08 | Oregon | 41 | 823249 | 7851 |
47423 | 47423 | 2022-07-07 | Oregon | 41 | 821305 | 7839 |
47367 | 47367 | 2022-07-06 | Oregon | 41 | 819681 | 7836 |
47311 | 47311 | 2022-07-05 | Oregon | 41 | 817840 | 7822 |
47255 | 47255 | 2022-07-04 | Oregon | 41 | 813051 | 7818 |
47199 | 47199 | 2022-07-03 | Oregon | 41 | 813051 | 7818 |
47143 | 47143 | 2022-07-02 | Oregon | 41 | 813051 | 7818 |
47087 | 47087 | 2022-07-01 | Oregon | 41 | 813051 | 7818 |
47031 | 47031 | 2022-06-30 | Oregon | 41 | 811693 | 7813 |
46975 | 46975 | 2022-06-29 | Oregon | 41 | 809828 | 7807 |
46919 | 46919 | 2022-06-28 | Oregon | 41 | 807890 | 7804 |
46863 | 46863 | 2022-06-27 | Oregon | 41 | 805978 | 7791 |
46807 | 46807 | 2022-06-26 | Oregon | 41 | 802157 | 7783 |
46751 | 46751 | 2022-06-25 | Oregon | 41 | 802157 | 7783 |
46695 | 46695 | 2022-06-24 | Oregon | 41 | 802157 | 7783 |
46639 | 46639 | 2022-06-23 | Oregon | 41 | 800405 | 7764 |
46583 | 46583 | 2022-06-22 | Oregon | 41 | 798053 | 7744 |
46527 | 46527 | 2022-06-21 | Oregon | 41 | 795553 | 7729 |
46471 | 46471 | 2022-06-20 | Oregon | 41 | 791281 | 7727 |
46415 | 46415 | 2022-06-19 | Oregon | 41 | 791281 | 7727 |
46359 | 46359 | 2022-06-18 | Oregon | 41 | 791281 | 7727 |
46303 | 46303 | 2022-06-17 | Oregon | 41 | 791281 | 7727 |
46247 | 46247 | 2022-06-16 | Oregon | 41 | 789698 | 7721 |
46191 | 46191 | 2022-06-15 | Oregon | 41 | 788128 | 7721 |
46135 | 46135 | 2022-06-14 | Oregon | 41 | 786609 | 7708 |
46079 | 46079 | 2022-06-13 | Oregon | 41 | 785032 | 7707 |
46023 | 46023 | 2022-06-12 | Oregon | 41 | 781128 | 7693 |
45967 | 45967 | 2022-06-11 | Oregon | 41 | 781128 | 7693 |
45911 | 45911 | 2022-06-10 | Oregon | 41 | 781128 | 7693 |
45855 | 45855 | 2022-06-09 | Oregon | 41 | 779984 | 7687 |
45799 | 45799 | 2022-06-08 | Oregon | 41 | 777700 | 7683 |
45743 | 45743 | 2022-06-07 | Oregon | 41 | 776239 | 7679 |
45687 | 45687 | 2022-06-06 | Oregon | 41 | 774426 | 7659 |
45631 | 45631 | 2022-06-05 | Oregon | 41 | 770194 | 7657 |
45575 | 45575 | 2022-06-04 | Oregon | 41 | 770194 | 7657 |
45519 | 45519 | 2022-06-03 | Oregon | 41 | 770194 | 7657 |
45463 | 45463 | 2022-06-02 | Oregon | 41 | 769081 | 7644 |
45407 | 45407 | 2022-06-01 | Oregon | 41 | 767286 | 7639 |
45351 | 45351 | 2022-05-31 | Oregon | 41 | 765449 | 7635 |
45295 | 45295 | 2022-05-30 | Oregon | 41 | 760804 | 7611 |
45239 | 45239 | 2022-05-29 | Oregon | 41 | 760804 | 7611 |
45183 | 45183 | 2022-05-28 | Oregon | 41 | 760804 | 7611 |
45127 | 45127 | 2022-05-27 | Oregon | 41 | 760804 | 7611 |
45071 | 45071 | 2022-05-26 | Oregon | 41 | 758879 | 7610 |
45015 | 45015 | 2022-05-25 | Oregon | 41 | 757210 | 7607 |
44959 | 44959 | 2022-05-24 | Oregon | 41 | 755367 | 7598 |
44903 | 44903 | 2022-05-23 | Oregon | 41 | 753576 | 7591 |
44847 | 44847 | 2022-05-22 | Oregon | 41 | 749722 | 7586 |
44791 | 44791 | 2022-05-21 | Oregon | 41 | 749722 | 7586 |
44735 | 44735 | 2022-05-20 | Oregon | 41 | 749722 | 7586 |
44679 | 44679 | 2022-05-19 | Oregon | 41 | 747342 | 7580 |
44623 | 44623 | 2022-05-18 | Oregon | 41 | 745723 | 7568 |
44567 | 44567 | 2022-05-17 | Oregon | 41 | 743781 | 7567 |
44511 | 44511 | 2022-05-16 | Oregon | 41 | 741780 | 7563 |
44455 | 44455 | 2022-05-15 | Oregon | 41 | 738830 | 7560 |
44399 | 44399 | 2022-05-14 | Oregon | 41 | 738830 | 7560 |
44343 | 44343 | 2022-05-13 | Oregon | 41 | 738830 | 7560 |
44287 | 44287 | 2022-05-12 | Oregon | 41 | 737186 | 7556 |
44231 | 44231 | 2022-05-11 | Oregon | 41 | 735464 | 7548 |
44175 | 44175 | 2022-05-10 | Oregon | 41 | 734014 | 7546 |
44119 | 44119 | 2022-05-09 | Oregon | 41 | 732382 | 7541 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );