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 · 1,036 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
57223 | 57223 | 2022-12-29 | Oregon | 41 | 939303 | 8967 |
57167 | 57167 | 2022-12-28 | Oregon | 41 | 939303 | 8967 |
57111 | 57111 | 2022-12-27 | Oregon | 41 | 936721 | 8953 |
57055 | 57055 | 2022-12-26 | Oregon | 41 | 936721 | 8953 |
56999 | 56999 | 2022-12-25 | Oregon | 41 | 936721 | 8953 |
56943 | 56943 | 2022-12-24 | Oregon | 41 | 936721 | 8953 |
56887 | 56887 | 2022-12-23 | Oregon | 41 | 936721 | 8953 |
56831 | 56831 | 2022-12-22 | Oregon | 41 | 936721 | 8953 |
56775 | 56775 | 2022-12-21 | Oregon | 41 | 936721 | 8953 |
56719 | 56719 | 2022-12-20 | Oregon | 41 | 933108 | 8940 |
56663 | 56663 | 2022-12-19 | Oregon | 41 | 933108 | 8940 |
56607 | 56607 | 2022-12-18 | Oregon | 41 | 933108 | 8940 |
56551 | 56551 | 2022-12-17 | Oregon | 41 | 933108 | 8940 |
56495 | 56495 | 2022-12-16 | Oregon | 41 | 933108 | 8940 |
56439 | 56439 | 2022-12-15 | Oregon | 41 | 933108 | 8940 |
56383 | 56383 | 2022-12-14 | Oregon | 41 | 933108 | 8940 |
56327 | 56327 | 2022-12-13 | Oregon | 41 | 929127 | 8898 |
56271 | 56271 | 2022-12-12 | Oregon | 41 | 929127 | 8898 |
56215 | 56215 | 2022-12-11 | Oregon | 41 | 929127 | 8898 |
56159 | 56159 | 2022-12-10 | Oregon | 41 | 929127 | 8898 |
56103 | 56103 | 2022-12-09 | Oregon | 41 | 929127 | 8898 |
56047 | 56047 | 2022-12-08 | Oregon | 41 | 929127 | 8898 |
55991 | 55991 | 2022-12-07 | Oregon | 41 | 929127 | 8898 |
55935 | 55935 | 2022-12-06 | Oregon | 41 | 924632 | 8870 |
55879 | 55879 | 2022-12-05 | Oregon | 41 | 924632 | 8870 |
55823 | 55823 | 2022-12-04 | Oregon | 41 | 924632 | 8870 |
55767 | 55767 | 2022-12-03 | Oregon | 41 | 924632 | 8870 |
55711 | 55711 | 2022-12-02 | Oregon | 41 | 924632 | 8870 |
55655 | 55655 | 2022-12-01 | Oregon | 41 | 924632 | 8870 |
55599 | 55599 | 2022-11-30 | Oregon | 41 | 924632 | 8870 |
55543 | 55543 | 2022-11-29 | Oregon | 41 | 920718 | 8831 |
55487 | 55487 | 2022-11-28 | Oregon | 41 | 920718 | 8831 |
55431 | 55431 | 2022-11-27 | Oregon | 41 | 920718 | 8831 |
55375 | 55375 | 2022-11-26 | Oregon | 41 | 920718 | 8831 |
55319 | 55319 | 2022-11-25 | Oregon | 41 | 920718 | 8831 |
55263 | 55263 | 2022-11-24 | Oregon | 41 | 920718 | 8831 |
55207 | 55207 | 2022-11-23 | Oregon | 41 | 920718 | 8831 |
55151 | 55151 | 2022-11-22 | Oregon | 41 | 917164 | 8794 |
55095 | 55095 | 2022-11-21 | Oregon | 41 | 917164 | 8794 |
55039 | 55039 | 2022-11-20 | Oregon | 41 | 917164 | 8794 |
54983 | 54983 | 2022-11-19 | Oregon | 41 | 917164 | 8794 |
54927 | 54927 | 2022-11-18 | Oregon | 41 | 917164 | 8794 |
54871 | 54871 | 2022-11-17 | Oregon | 41 | 917164 | 8794 |
54815 | 54815 | 2022-11-16 | Oregon | 41 | 917164 | 8794 |
54759 | 54759 | 2022-11-15 | Oregon | 41 | 913809 | 8750 |
54703 | 54703 | 2022-11-14 | Oregon | 41 | 913809 | 8750 |
54647 | 54647 | 2022-11-13 | Oregon | 41 | 913809 | 8750 |
54591 | 54591 | 2022-11-12 | Oregon | 41 | 913809 | 8750 |
54535 | 54535 | 2022-11-11 | Oregon | 41 | 913809 | 8750 |
54479 | 54479 | 2022-11-10 | Oregon | 41 | 913809 | 8743 |
54423 | 54423 | 2022-11-09 | Oregon | 41 | 913809 | 8743 |
54367 | 54367 | 2022-11-08 | Oregon | 41 | 910693 | 8726 |
54311 | 54311 | 2022-11-07 | Oregon | 41 | 910693 | 8726 |
54255 | 54255 | 2022-11-06 | Oregon | 41 | 910693 | 8726 |
54199 | 54199 | 2022-11-05 | Oregon | 41 | 910693 | 8726 |
54143 | 54143 | 2022-11-04 | Oregon | 41 | 910693 | 8726 |
54087 | 54087 | 2022-11-03 | Oregon | 41 | 910693 | 8726 |
54031 | 54031 | 2022-11-02 | Oregon | 41 | 910693 | 8726 |
53975 | 53975 | 2022-11-01 | Oregon | 41 | 908188 | 8680 |
53919 | 53919 | 2022-10-31 | Oregon | 41 | 908188 | 8680 |
53863 | 53863 | 2022-10-30 | Oregon | 41 | 908188 | 8680 |
53807 | 53807 | 2022-10-29 | Oregon | 41 | 908188 | 8680 |
53751 | 53751 | 2022-10-28 | Oregon | 41 | 908188 | 8680 |
53695 | 53695 | 2022-10-27 | Oregon | 41 | 908188 | 8680 |
53639 | 53639 | 2022-10-26 | Oregon | 41 | 908188 | 8680 |
53583 | 53583 | 2022-10-25 | Oregon | 41 | 905882 | 8645 |
53527 | 53527 | 2022-10-24 | Oregon | 41 | 905882 | 8645 |
53471 | 53471 | 2022-10-23 | Oregon | 41 | 905882 | 8645 |
53415 | 53415 | 2022-10-22 | Oregon | 41 | 905882 | 8645 |
53359 | 53359 | 2022-10-21 | Oregon | 41 | 905882 | 8645 |
53303 | 53303 | 2022-10-20 | Oregon | 41 | 905882 | 8645 |
53247 | 53247 | 2022-10-19 | Oregon | 41 | 905882 | 8645 |
53191 | 53191 | 2022-10-18 | Oregon | 41 | 902319 | 8622 |
53135 | 53135 | 2022-10-17 | Oregon | 41 | 902319 | 8622 |
53079 | 53079 | 2022-10-16 | Oregon | 41 | 902319 | 8622 |
53023 | 53023 | 2022-10-15 | Oregon | 41 | 902319 | 8622 |
52967 | 52967 | 2022-10-14 | Oregon | 41 | 902319 | 8622 |
52911 | 52911 | 2022-10-13 | Oregon | 41 | 902319 | 8622 |
52855 | 52855 | 2022-10-12 | Oregon | 41 | 902319 | 8622 |
52799 | 52799 | 2022-10-11 | Oregon | 41 | 899013 | 8590 |
52743 | 52743 | 2022-10-10 | Oregon | 41 | 899013 | 8590 |
52687 | 52687 | 2022-10-09 | Oregon | 41 | 899013 | 8590 |
52631 | 52631 | 2022-10-08 | Oregon | 41 | 899013 | 8590 |
52575 | 52575 | 2022-10-07 | Oregon | 41 | 899013 | 8590 |
52519 | 52519 | 2022-10-06 | Oregon | 41 | 899013 | 8590 |
52463 | 52463 | 2022-10-05 | Oregon | 41 | 899013 | 8590 |
52407 | 52407 | 2022-10-04 | Oregon | 41 | 894776 | 8561 |
52351 | 52351 | 2022-10-03 | Oregon | 41 | 894776 | 8561 |
52295 | 52295 | 2022-10-02 | Oregon | 41 | 894776 | 8561 |
52239 | 52239 | 2022-10-01 | Oregon | 41 | 894776 | 8561 |
52183 | 52183 | 2022-09-30 | Oregon | 41 | 894776 | 8561 |
52127 | 52127 | 2022-09-29 | Oregon | 41 | 894776 | 8561 |
52071 | 52071 | 2022-09-28 | Oregon | 41 | 894776 | 8561 |
52015 | 52015 | 2022-09-27 | Oregon | 41 | 890507 | 8520 |
51959 | 51959 | 2022-09-26 | Oregon | 41 | 890507 | 8520 |
51903 | 51903 | 2022-09-25 | Oregon | 41 | 890507 | 8520 |
51847 | 51847 | 2022-09-24 | Oregon | 41 | 890507 | 8520 |
51791 | 51791 | 2022-09-23 | Oregon | 41 | 890507 | 8520 |
51735 | 51735 | 2022-09-22 | Oregon | 41 | 890507 | 8520 |
51679 | 51679 | 2022-09-21 | Oregon | 41 | 890507 | 8520 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );