ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,074 rows where state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Washington · 974 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
51635 | 51635 | 2022-09-20 | Washington | 53 | 1803850 | 14247 |
51579 | 51579 | 2022-09-19 | Washington | 53 | 1803850 | 14247 |
51523 | 51523 | 2022-09-18 | Washington | 53 | 1801179 | 14233 |
51467 | 51467 | 2022-09-17 | Washington | 53 | 1801179 | 14233 |
51411 | 51411 | 2022-09-16 | Washington | 53 | 1801179 | 14233 |
51355 | 51355 | 2022-09-15 | Washington | 53 | 1796560 | 14195 |
51299 | 51299 | 2022-09-14 | Washington | 53 | 1796368 | 14195 |
51243 | 51243 | 2022-09-13 | Washington | 53 | 1796343 | 14195 |
51187 | 51187 | 2022-09-12 | Washington | 53 | 1796343 | 14195 |
51131 | 51131 | 2022-09-11 | Washington | 53 | 1794094 | 14173 |
51075 | 51075 | 2022-09-10 | Washington | 53 | 1794094 | 14173 |
51019 | 51019 | 2022-09-09 | Washington | 53 | 1794094 | 14173 |
50963 | 50963 | 2022-09-08 | Washington | 53 | 1791409 | 14149 |
50907 | 50907 | 2022-09-07 | Washington | 53 | 1791053 | 14149 |
50851 | 50851 | 2022-09-06 | Washington | 53 | 1788553 | 14114 |
50795 | 50795 | 2022-09-05 | Washington | 53 | 1787487 | 14109 |
50739 | 50739 | 2022-09-04 | Washington | 53 | 1787487 | 14109 |
50683 | 50683 | 2022-09-03 | Washington | 53 | 1787487 | 14109 |
50627 | 50627 | 2022-09-02 | Washington | 53 | 1787487 | 14109 |
50571 | 50571 | 2022-09-01 | Washington | 53 | 1784902 | 14079 |
50515 | 50515 | 2022-08-31 | Washington | 53 | 1784891 | 14079 |
50459 | 50459 | 2022-08-30 | Washington | 53 | 1783180 | 14051 |
50403 | 50403 | 2022-08-29 | Washington | 53 | 1783142 | 14051 |
50347 | 50347 | 2022-08-28 | Washington | 53 | 1779422 | 14044 |
50291 | 50291 | 2022-08-27 | Washington | 53 | 1779422 | 14044 |
50235 | 50235 | 2022-08-26 | Washington | 53 | 1779422 | 14044 |
50179 | 50179 | 2022-08-25 | Washington | 53 | 1776739 | 14019 |
50123 | 50123 | 2022-08-24 | Washington | 53 | 1776483 | 14019 |
50067 | 50067 | 2022-08-23 | Washington | 53 | 1774131 | 13978 |
50011 | 50011 | 2022-08-22 | Washington | 53 | 1774116 | 13978 |
49955 | 49955 | 2022-08-21 | Washington | 53 | 1771143 | 13960 |
49899 | 49899 | 2022-08-20 | Washington | 53 | 1771143 | 13960 |
49843 | 49843 | 2022-08-19 | Washington | 53 | 1771143 | 13960 |
49787 | 49787 | 2022-08-18 | Washington | 53 | 1767339 | 13933 |
49731 | 49731 | 2022-08-17 | Washington | 53 | 1767315 | 13933 |
49675 | 49675 | 2022-08-16 | Washington | 53 | 1764789 | 13888 |
49619 | 49619 | 2022-08-15 | Washington | 53 | 1764789 | 13888 |
49563 | 49563 | 2022-08-14 | Washington | 53 | 1761081 | 13872 |
49507 | 49507 | 2022-08-13 | Washington | 53 | 1761081 | 13872 |
49451 | 49451 | 2022-08-12 | Washington | 53 | 1761081 | 13872 |
49395 | 49395 | 2022-08-11 | Washington | 53 | 1756800 | 13816 |
49339 | 49339 | 2022-08-10 | Washington | 53 | 1756800 | 13816 |
49283 | 49283 | 2022-08-09 | Washington | 53 | 1750806 | 13772 |
49227 | 49227 | 2022-08-08 | Washington | 53 | 1750783 | 13772 |
49171 | 49171 | 2022-08-07 | Washington | 53 | 1749173 | 13769 |
49115 | 49115 | 2022-08-06 | Washington | 53 | 1749173 | 13769 |
49059 | 49059 | 2022-08-05 | Washington | 53 | 1749173 | 13769 |
49003 | 49003 | 2022-08-04 | Washington | 53 | 1744292 | 13745 |
48947 | 48947 | 2022-08-03 | Washington | 53 | 1744292 | 13745 |
48891 | 48891 | 2022-08-02 | Washington | 53 | 1740938 | 13697 |
48835 | 48835 | 2022-08-01 | Washington | 53 | 1740938 | 13697 |
48779 | 48779 | 2022-07-31 | Washington | 53 | 1732671 | 13651 |
48723 | 48723 | 2022-07-30 | Washington | 53 | 1732671 | 13651 |
48667 | 48667 | 2022-07-29 | Washington | 53 | 1732671 | 13651 |
48611 | 48611 | 2022-07-28 | Washington | 53 | 1729964 | 13643 |
48555 | 48555 | 2022-07-27 | Washington | 53 | 1729949 | 13643 |
48499 | 48499 | 2022-07-26 | Washington | 53 | 1726199 | 13600 |
48443 | 48443 | 2022-07-25 | Washington | 53 | 1726134 | 13600 |
48387 | 48387 | 2022-07-24 | Washington | 53 | 1720821 | 13572 |
48331 | 48331 | 2022-07-23 | Washington | 53 | 1720821 | 13572 |
48275 | 48275 | 2022-07-22 | Washington | 53 | 1720821 | 13572 |
48219 | 48219 | 2022-07-21 | Washington | 53 | 1713978 | 13550 |
48163 | 48163 | 2022-07-20 | Washington | 53 | 1713951 | 13550 |
48107 | 48107 | 2022-07-19 | Washington | 53 | 1709586 | 13504 |
48051 | 48051 | 2022-07-18 | Washington | 53 | 1709555 | 13504 |
47995 | 47995 | 2022-07-17 | Washington | 53 | 1702550 | 13479 |
47939 | 47939 | 2022-07-16 | Washington | 53 | 1702523 | 13479 |
47883 | 47883 | 2022-07-15 | Washington | 53 | 1702523 | 13479 |
47827 | 47827 | 2022-07-14 | Washington | 53 | 1696155 | 13450 |
47771 | 47771 | 2022-07-13 | Washington | 53 | 1695940 | 13447 |
47715 | 47715 | 2022-07-12 | Washington | 53 | 1692547 | 13402 |
47659 | 47659 | 2022-07-11 | Washington | 53 | 1692527 | 13402 |
47603 | 47603 | 2022-07-10 | Washington | 53 | 1685611 | 13384 |
47547 | 47547 | 2022-07-09 | Washington | 53 | 1685606 | 13384 |
47491 | 47491 | 2022-07-08 | Washington | 53 | 1685606 | 13384 |
47435 | 47435 | 2022-07-07 | Washington | 53 | 1678344 | 13340 |
47379 | 47379 | 2022-07-06 | Washington | 53 | 1678249 | 13340 |
47323 | 47323 | 2022-07-05 | Washington | 53 | 1670720 | 13323 |
47267 | 47267 | 2022-07-04 | Washington | 53 | 1667056 | 13313 |
47211 | 47211 | 2022-07-03 | Washington | 53 | 1667056 | 13313 |
47155 | 47155 | 2022-07-02 | Washington | 53 | 1667056 | 13313 |
47099 | 47099 | 2022-07-01 | Washington | 53 | 1667056 | 13313 |
47043 | 47043 | 2022-06-30 | Washington | 53 | 1659804 | 13277 |
46987 | 46987 | 2022-06-29 | Washington | 53 | 1659546 | 13277 |
46931 | 46931 | 2022-06-28 | Washington | 53 | 1654976 | 13239 |
46875 | 46875 | 2022-06-27 | Washington | 53 | 1654892 | 13239 |
46819 | 46819 | 2022-06-26 | Washington | 53 | 1647494 | 13227 |
46763 | 46763 | 2022-06-25 | Washington | 53 | 1647494 | 13227 |
46707 | 46707 | 2022-06-24 | Washington | 53 | 1647494 | 13227 |
46651 | 46651 | 2022-06-23 | Washington | 53 | 1640872 | 13200 |
46595 | 46595 | 2022-06-22 | Washington | 53 | 1640851 | 13200 |
46539 | 46539 | 2022-06-21 | Washington | 53 | 1633195 | 13164 |
46483 | 46483 | 2022-06-20 | Washington | 53 | 1629433 | 13156 |
46427 | 46427 | 2022-06-19 | Washington | 53 | 1629384 | 13156 |
46371 | 46371 | 2022-06-18 | Washington | 53 | 1629384 | 13156 |
46315 | 46315 | 2022-06-17 | Washington | 53 | 1629368 | 13156 |
46259 | 46259 | 2022-06-16 | Washington | 53 | 1622774 | 13132 |
46203 | 46203 | 2022-06-15 | Washington | 53 | 1622582 | 13131 |
46147 | 46147 | 2022-06-14 | Washington | 53 | 1617336 | 13103 |
46091 | 46091 | 2022-06-13 | Washington | 53 | 1617271 | 13103 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );