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 · 940 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
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 |
46035 | 46035 | 2022-06-12 | Washington | 53 | 1611541 | 13096 |
45979 | 45979 | 2022-06-11 | Washington | 53 | 1611537 | 13096 |
45923 | 45923 | 2022-06-10 | Washington | 53 | 1611537 | 13096 |
45867 | 45867 | 2022-06-09 | Washington | 53 | 1606101 | 13064 |
45811 | 45811 | 2022-06-08 | Washington | 53 | 1606101 | 13064 |
45755 | 45755 | 2022-06-07 | Washington | 53 | 1600769 | 13031 |
45699 | 45699 | 2022-06-06 | Washington | 53 | 1600745 | 13031 |
45643 | 45643 | 2022-06-05 | Washington | 53 | 1592579 | 13012 |
45587 | 45587 | 2022-06-04 | Washington | 53 | 1592579 | 13012 |
45531 | 45531 | 2022-06-03 | Washington | 53 | 1592579 | 13012 |
45475 | 45475 | 2022-06-02 | Washington | 53 | 1583906 | 12992 |
45419 | 45419 | 2022-06-01 | Washington | 53 | 1583850 | 12992 |
45363 | 45363 | 2022-05-31 | Washington | 53 | 1578148 | 12967 |
45307 | 45307 | 2022-05-30 | Washington | 53 | 1574288 | 12967 |
45251 | 45251 | 2022-05-29 | Washington | 53 | 1574288 | 12967 |
45195 | 45195 | 2022-05-28 | Washington | 53 | 1574288 | 12967 |
45139 | 45139 | 2022-05-27 | Washington | 53 | 1574288 | 12967 |
45083 | 45083 | 2022-05-26 | Washington | 53 | 1566509 | 12935 |
45027 | 45027 | 2022-05-25 | Washington | 53 | 1566290 | 12935 |
44971 | 44971 | 2022-05-24 | Washington | 53 | 1559783 | 12914 |
44915 | 44915 | 2022-05-23 | Washington | 53 | 1559756 | 12914 |
44859 | 44859 | 2022-05-22 | Washington | 53 | 1552956 | 12902 |
44803 | 44803 | 2022-05-21 | Washington | 53 | 1552956 | 12902 |
44747 | 44747 | 2022-05-20 | Washington | 53 | 1552956 | 12902 |
44691 | 44691 | 2022-05-19 | Washington | 53 | 1544546 | 12882 |
44635 | 44635 | 2022-05-18 | Washington | 53 | 1544522 | 12882 |
44579 | 44579 | 2022-05-17 | Washington | 53 | 1538460 | 12857 |
44523 | 44523 | 2022-05-16 | Washington | 53 | 1538330 | 12857 |
44467 | 44467 | 2022-05-15 | Washington | 53 | 1531059 | 12843 |
44411 | 44411 | 2022-05-14 | Washington | 53 | 1531059 | 12843 |
44355 | 44355 | 2022-05-13 | Washington | 53 | 1531059 | 12843 |
44299 | 44299 | 2022-05-12 | Washington | 53 | 1524791 | 12820 |
44243 | 44243 | 2022-05-11 | Washington | 53 | 1524674 | 12820 |
44187 | 44187 | 2022-05-10 | Washington | 53 | 1519577 | 12789 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );