ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 53005 and state = "Washington" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4356 | 4356 | 2020-03-18 | Benton | Washington | 53005 | 1 | 1 |
5112 | 5112 | 2020-03-19 | Benton | Washington | 53005 | 2 | 1 |
6013 | 6013 | 2020-03-20 | Benton | Washington | 53005 | 3 | 1 |
7044 | 7044 | 2020-03-21 | Benton | Washington | 53005 | 8 | 2 |
8181 | 8181 | 2020-03-22 | Benton | Washington | 53005 | 8 | 2 |
9405 | 9405 | 2020-03-23 | Benton | Washington | 53005 | 8 | 2 |
10754 | 10754 | 2020-03-24 | Benton | Washington | 53005 | 12 | 2 |
12276 | 12276 | 2020-03-25 | Benton | Washington | 53005 | 10 | 2 |
13926 | 13926 | 2020-03-26 | Benton | Washington | 53005 | 19 | 4 |
15694 | 15694 | 2020-03-27 | Benton | Washington | 53005 | 42 | 5 |
17574 | 17574 | 2020-03-28 | Benton | Washington | 53005 | 56 | 5 |
19539 | 19539 | 2020-03-29 | Benton | Washington | 53005 | 101 | 5 |
21606 | 21606 | 2020-03-30 | Benton | Washington | 53005 | 101 | 5 |
23755 | 23755 | 2020-03-31 | Benton | Washington | 53005 | 101 | 6 |
25973 | 25973 | 2020-04-01 | Benton | Washington | 53005 | 108 | 6 |
28263 | 28263 | 2020-04-02 | Benton | Washington | 53005 | 133 | 9 |
30616 | 30616 | 2020-04-03 | Benton | Washington | 53005 | 136 | 13 |
33016 | 33016 | 2020-04-04 | Benton | Washington | 53005 | 151 | 13 |
35454 | 35454 | 2020-04-05 | Benton | Washington | 53005 | 166 | 13 |
37938 | 37938 | 2020-04-06 | Benton | Washington | 53005 | 175 | 17 |
40473 | 40473 | 2020-04-07 | Benton | Washington | 53005 | 179 | 19 |
43042 | 43042 | 2020-04-08 | Benton | Washington | 53005 | 190 | 19 |
45638 | 45638 | 2020-04-09 | Benton | Washington | 53005 | 215 | 25 |
48265 | 48265 | 2020-04-10 | Benton | Washington | 53005 | 234 | 25 |
50923 | 50923 | 2020-04-11 | Benton | Washington | 53005 | 246 | 26 |
53598 | 53598 | 2020-04-12 | Benton | Washington | 53005 | 250 | 28 |
56288 | 56288 | 2020-04-13 | Benton | Washington | 53005 | 261 | 29 |
58994 | 58994 | 2020-04-14 | Benton | Washington | 53005 | 266 | 29 |
61713 | 61713 | 2020-04-15 | Benton | Washington | 53005 | 273 | 30 |
64446 | 64446 | 2020-04-16 | Benton | Washington | 53005 | 284 | 34 |
67194 | 67194 | 2020-04-17 | Benton | Washington | 53005 | 295 | 34 |
69956 | 69956 | 2020-04-18 | Benton | Washington | 53005 | 306 | 34 |
72726 | 72726 | 2020-04-19 | Benton | Washington | 53005 | 314 | 34 |
75502 | 75502 | 2020-04-20 | Benton | Washington | 53005 | 334 | 34 |
78285 | 78285 | 2020-04-21 | Benton | Washington | 53005 | 338 | 35 |
81078 | 81078 | 2020-04-22 | Benton | Washington | 53005 | 348 | 35 |
83879 | 83879 | 2020-04-23 | Benton | Washington | 53005 | 365 | 38 |
86686 | 86686 | 2020-04-24 | Benton | Washington | 53005 | 383 | 38 |
89501 | 89501 | 2020-04-25 | Benton | Washington | 53005 | 399 | 38 |
92318 | 92318 | 2020-04-26 | Benton | Washington | 53005 | 405 | 38 |
95147 | 95147 | 2020-04-27 | Benton | Washington | 53005 | 409 | 39 |
97992 | 97992 | 2020-04-28 | Benton | Washington | 53005 | 415 | 39 |
100842 | 100842 | 2020-04-29 | Benton | Washington | 53005 | 418 | 41 |
103697 | 103697 | 2020-04-30 | Benton | Washington | 53005 | 430 | 41 |
106561 | 106561 | 2020-05-01 | Benton | Washington | 53005 | 461 | 44 |
109430 | 109430 | 2020-05-02 | Benton | Washington | 53005 | 494 | 43 |
112304 | 112304 | 2020-05-03 | Benton | Washington | 53005 | 518 | 44 |
115187 | 115187 | 2020-05-04 | Benton | Washington | 53005 | 532 | 44 |
118146 | 118146 | 2020-05-05 | Benton | Washington | 53005 | 537 | 46 |
121110 | 121110 | 2020-05-06 | Benton | Washington | 53005 | 660 | 50 |
124090 | 124090 | 2020-05-07 | Benton | Washington | 53005 | 665 | 51 |
127075 | 127075 | 2020-05-08 | Benton | Washington | 53005 | 675 | 51 |
130065 | 130065 | 2020-05-09 | Benton | Washington | 53005 | 695 | 51 |
133055 | 133055 | 2020-05-10 | Benton | Washington | 53005 | 705 | 51 |
136045 | 136045 | 2020-05-11 | Benton | Washington | 53005 | 719 | 54 |
139036 | 139036 | 2020-05-12 | Benton | Washington | 53005 | 723 | 55 |
142032 | 142032 | 2020-05-13 | Benton | Washington | 53005 | 732 | 55 |
145029 | 145029 | 2020-05-14 | Benton | Washington | 53005 | 752 | 56 |
148032 | 148032 | 2020-05-15 | Benton | Washington | 53005 | 760 | 57 |
151041 | 151041 | 2020-05-16 | Benton | Washington | 53005 | 773 | 57 |
154052 | 154052 | 2020-05-17 | Benton | Washington | 53005 | 775 | 57 |
157069 | 157069 | 2020-05-18 | Benton | Washington | 53005 | 791 | 58 |
160093 | 160093 | 2020-05-19 | Benton | Washington | 53005 | 801 | 58 |
163121 | 163121 | 2020-05-20 | Benton | Washington | 53005 | 808 | 60 |
166150 | 166150 | 2020-05-21 | Benton | Washington | 53005 | 811 | 60 |
169186 | 169186 | 2020-05-22 | Benton | Washington | 53005 | 826 | 61 |
172227 | 172227 | 2020-05-23 | Benton | Washington | 53005 | 826 | 61 |
175270 | 175270 | 2020-05-24 | Benton | Washington | 53005 | 825 | 61 |
178315 | 178315 | 2020-05-25 | Benton | Washington | 53005 | 868 | 61 |
181359 | 181359 | 2020-05-26 | Benton | Washington | 53005 | 890 | 61 |
184410 | 184410 | 2020-05-27 | Benton | Washington | 53005 | 899 | 64 |
187467 | 187467 | 2020-05-28 | Benton | Washington | 53005 | 910 | 65 |
190531 | 190531 | 2020-05-29 | Benton | Washington | 53005 | 925 | 65 |
193597 | 193597 | 2020-05-30 | Benton | Washington | 53005 | 944 | 65 |
196667 | 196667 | 2020-05-31 | Benton | Washington | 53005 | 962 | 65 |
199740 | 199740 | 2020-06-01 | Benton | Washington | 53005 | 980 | 67 |
202816 | 202816 | 2020-06-02 | Benton | Washington | 53005 | 999 | 67 |
205895 | 205895 | 2020-06-03 | Benton | Washington | 53005 | 1017 | 67 |
208977 | 208977 | 2020-06-04 | Benton | Washington | 53005 | 1029 | 67 |
212062 | 212062 | 2020-06-05 | Benton | Washington | 53005 | 1065 | 69 |
215149 | 215149 | 2020-06-06 | Benton | Washington | 53005 | 1076 | 69 |
218239 | 218239 | 2020-06-07 | Benton | Washington | 53005 | 1100 | 69 |
221331 | 221331 | 2020-06-08 | Benton | Washington | 53005 | 1153 | 69 |
224427 | 224427 | 2020-06-09 | Benton | Washington | 53005 | 1165 | 69 |
227527 | 227527 | 2020-06-10 | Benton | Washington | 53005 | 1185 | 71 |
230631 | 230631 | 2020-06-11 | Benton | Washington | 53005 | 1221 | 71 |
233736 | 233736 | 2020-06-12 | Benton | Washington | 53005 | 1263 | 72 |
236843 | 236843 | 2020-06-13 | Benton | Washington | 53005 | 1263 | 73 |
239951 | 239951 | 2020-06-14 | Benton | Washington | 53005 | 1263 | 73 |
243062 | 243062 | 2020-06-15 | Benton | Washington | 53005 | 1341 | 73 |
246175 | 246175 | 2020-06-16 | Benton | Washington | 53005 | 1389 | 74 |
249287 | 249287 | 2020-06-17 | Benton | Washington | 53005 | 1407 | 74 |
252402 | 252402 | 2020-06-18 | Benton | Washington | 53005 | 1438 | 75 |
255521 | 255521 | 2020-06-19 | Benton | Washington | 53005 | 1495 | 75 |
258648 | 258648 | 2020-06-20 | Benton | Washington | 53005 | 1495 | 76 |
261775 | 261775 | 2020-06-21 | Benton | Washington | 53005 | 1495 | 76 |
264904 | 264904 | 2020-06-22 | Benton | Washington | 53005 | 1608 | 76 |
268033 | 268033 | 2020-06-23 | Benton | Washington | 53005 | 1634 | 76 |
271167 | 271167 | 2020-06-24 | Benton | Washington | 53005 | 1692 | 76 |
274307 | 274307 | 2020-06-25 | Benton | Washington | 53005 | 1725 | 76 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);