ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 53057 and state = "Washington" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1154 | 1154 | 2020-03-10 | Skagit | Washington | 53057 | 1 | 0 |
1354 | 1354 | 2020-03-11 | Skagit | Washington | 53057 | 1 | 0 |
1608 | 1608 | 2020-03-12 | Skagit | Washington | 53057 | 2 | 0 |
1919 | 1919 | 2020-03-13 | Skagit | Washington | 53057 | 3 | 0 |
2293 | 2293 | 2020-03-14 | Skagit | Washington | 53057 | 3 | 0 |
2722 | 2722 | 2020-03-15 | Skagit | Washington | 53057 | 4 | 0 |
3196 | 3196 | 2020-03-16 | Skagit | Washington | 53057 | 7 | 0 |
3738 | 3738 | 2020-03-17 | Skagit | Washington | 53057 | 9 | 0 |
4373 | 4373 | 2020-03-18 | Skagit | Washington | 53057 | 14 | 0 |
5130 | 5130 | 2020-03-19 | Skagit | Washington | 53057 | 18 | 0 |
6033 | 6033 | 2020-03-20 | Skagit | Washington | 53057 | 26 | 0 |
7064 | 7064 | 2020-03-21 | Skagit | Washington | 53057 | 28 | 0 |
8201 | 8201 | 2020-03-22 | Skagit | Washington | 53057 | 34 | 0 |
9426 | 9426 | 2020-03-23 | Skagit | Washington | 53057 | 45 | 1 |
10775 | 10775 | 2020-03-24 | Skagit | Washington | 53057 | 48 | 1 |
12299 | 12299 | 2020-03-25 | Skagit | Washington | 53057 | 63 | 1 |
13949 | 13949 | 2020-03-26 | Skagit | Washington | 53057 | 78 | 1 |
15717 | 15717 | 2020-03-27 | Skagit | Washington | 53057 | 91 | 1 |
17597 | 17597 | 2020-03-28 | Skagit | Washington | 53057 | 97 | 3 |
19562 | 19562 | 2020-03-29 | Skagit | Washington | 53057 | 101 | 3 |
21629 | 21629 | 2020-03-30 | Skagit | Washington | 53057 | 101 | 3 |
23778 | 23778 | 2020-03-31 | Skagit | Washington | 53057 | 101 | 3 |
25996 | 25996 | 2020-04-01 | Skagit | Washington | 53057 | 143 | 4 |
28287 | 28287 | 2020-04-02 | Skagit | Washington | 53057 | 153 | 4 |
30640 | 30640 | 2020-04-03 | Skagit | Washington | 53057 | 160 | 4 |
33040 | 33040 | 2020-04-04 | Skagit | Washington | 53057 | 161 | 4 |
35478 | 35478 | 2020-04-05 | Skagit | Washington | 53057 | 161 | 4 |
37962 | 37962 | 2020-04-06 | Skagit | Washington | 53057 | 166 | 4 |
40497 | 40497 | 2020-04-07 | Skagit | Washington | 53057 | 169 | 5 |
43066 | 43066 | 2020-04-08 | Skagit | Washington | 53057 | 169 | 5 |
45662 | 45662 | 2020-04-09 | Skagit | Washington | 53057 | 178 | 5 |
48290 | 48290 | 2020-04-10 | Skagit | Washington | 53057 | 178 | 5 |
50948 | 50948 | 2020-04-11 | Skagit | Washington | 53057 | 187 | 6 |
53623 | 53623 | 2020-04-12 | Skagit | Washington | 53057 | 191 | 6 |
56313 | 56313 | 2020-04-13 | Skagit | Washington | 53057 | 195 | 6 |
59019 | 59019 | 2020-04-14 | Skagit | Washington | 53057 | 203 | 6 |
61738 | 61738 | 2020-04-15 | Skagit | Washington | 53057 | 209 | 6 |
64471 | 64471 | 2020-04-16 | Skagit | Washington | 53057 | 218 | 6 |
67219 | 67219 | 2020-04-17 | Skagit | Washington | 53057 | 226 | 6 |
69981 | 69981 | 2020-04-18 | Skagit | Washington | 53057 | 230 | 7 |
72751 | 72751 | 2020-04-19 | Skagit | Washington | 53057 | 238 | 8 |
75527 | 75527 | 2020-04-20 | Skagit | Washington | 53057 | 255 | 8 |
78310 | 78310 | 2020-04-21 | Skagit | Washington | 53057 | 255 | 9 |
81103 | 81103 | 2020-04-22 | Skagit | Washington | 53057 | 271 | 9 |
83904 | 83904 | 2020-04-23 | Skagit | Washington | 53057 | 281 | 10 |
86711 | 86711 | 2020-04-24 | Skagit | Washington | 53057 | 283 | 10 |
89526 | 89526 | 2020-04-25 | Skagit | Washington | 53057 | 287 | 10 |
92343 | 92343 | 2020-04-26 | Skagit | Washington | 53057 | 299 | 11 |
95172 | 95172 | 2020-04-27 | Skagit | Washington | 53057 | 309 | 11 |
98017 | 98017 | 2020-04-28 | Skagit | Washington | 53057 | 309 | 11 |
100867 | 100867 | 2020-04-29 | Skagit | Washington | 53057 | 322 | 12 |
103722 | 103722 | 2020-04-30 | Skagit | Washington | 53057 | 338 | 13 |
106586 | 106586 | 2020-05-01 | Skagit | Washington | 53057 | 345 | 13 |
109455 | 109455 | 2020-05-02 | Skagit | Washington | 53057 | 345 | 13 |
112329 | 112329 | 2020-05-03 | Skagit | Washington | 53057 | 354 | 13 |
115212 | 115212 | 2020-05-04 | Skagit | Washington | 53057 | 357 | 13 |
118171 | 118171 | 2020-05-05 | Skagit | Washington | 53057 | 364 | 13 |
121135 | 121135 | 2020-05-06 | Skagit | Washington | 53057 | 379 | 13 |
124115 | 124115 | 2020-05-07 | Skagit | Washington | 53057 | 389 | 13 |
127100 | 127100 | 2020-05-08 | Skagit | Washington | 53057 | 391 | 13 |
130090 | 130090 | 2020-05-09 | Skagit | Washington | 53057 | 397 | 14 |
133080 | 133080 | 2020-05-10 | Skagit | Washington | 53057 | 401 | 14 |
136070 | 136070 | 2020-05-11 | Skagit | Washington | 53057 | 402 | 14 |
139061 | 139061 | 2020-05-12 | Skagit | Washington | 53057 | 406 | 14 |
142057 | 142057 | 2020-05-13 | Skagit | Washington | 53057 | 411 | 14 |
145054 | 145054 | 2020-05-14 | Skagit | Washington | 53057 | 411 | 14 |
148057 | 148057 | 2020-05-15 | Skagit | Washington | 53057 | 423 | 14 |
151066 | 151066 | 2020-05-16 | Skagit | Washington | 53057 | 425 | 14 |
154077 | 154077 | 2020-05-17 | Skagit | Washington | 53057 | 425 | 14 |
157094 | 157094 | 2020-05-18 | Skagit | Washington | 53057 | 426 | 14 |
160118 | 160118 | 2020-05-19 | Skagit | Washington | 53057 | 426 | 15 |
163146 | 163146 | 2020-05-20 | Skagit | Washington | 53057 | 426 | 15 |
166175 | 166175 | 2020-05-21 | Skagit | Washington | 53057 | 426 | 15 |
169211 | 169211 | 2020-05-22 | Skagit | Washington | 53057 | 426 | 15 |
172252 | 172252 | 2020-05-23 | Skagit | Washington | 53057 | 426 | 15 |
175295 | 175295 | 2020-05-24 | Skagit | Washington | 53057 | 426 | 15 |
178340 | 178340 | 2020-05-25 | Skagit | Washington | 53057 | 426 | 15 |
181384 | 181384 | 2020-05-26 | Skagit | Washington | 53057 | 427 | 15 |
184435 | 184435 | 2020-05-27 | Skagit | Washington | 53057 | 428 | 15 |
187492 | 187492 | 2020-05-28 | Skagit | Washington | 53057 | 428 | 15 |
190556 | 190556 | 2020-05-29 | Skagit | Washington | 53057 | 430 | 15 |
193622 | 193622 | 2020-05-30 | Skagit | Washington | 53057 | 432 | 15 |
196692 | 196692 | 2020-05-31 | Skagit | Washington | 53057 | 434 | 15 |
199765 | 199765 | 2020-06-01 | Skagit | Washington | 53057 | 435 | 15 |
202841 | 202841 | 2020-06-02 | Skagit | Washington | 53057 | 438 | 15 |
205920 | 205920 | 2020-06-03 | Skagit | Washington | 53057 | 443 | 15 |
209002 | 209002 | 2020-06-04 | Skagit | Washington | 53057 | 446 | 15 |
212087 | 212087 | 2020-06-05 | Skagit | Washington | 53057 | 450 | 15 |
215174 | 215174 | 2020-06-06 | Skagit | Washington | 53057 | 449 | 15 |
218264 | 218264 | 2020-06-07 | Skagit | Washington | 53057 | 449 | 15 |
221356 | 221356 | 2020-06-08 | Skagit | Washington | 53057 | 450 | 15 |
224452 | 224452 | 2020-06-09 | Skagit | Washington | 53057 | 450 | 15 |
227552 | 227552 | 2020-06-10 | Skagit | Washington | 53057 | 450 | 15 |
230656 | 230656 | 2020-06-11 | Skagit | Washington | 53057 | 452 | 15 |
233761 | 233761 | 2020-06-12 | Skagit | Washington | 53057 | 454 | 15 |
236868 | 236868 | 2020-06-13 | Skagit | Washington | 53057 | 457 | 15 |
239976 | 239976 | 2020-06-14 | Skagit | Washington | 53057 | 461 | 15 |
243087 | 243087 | 2020-06-15 | Skagit | Washington | 53057 | 463 | 15 |
246200 | 246200 | 2020-06-16 | Skagit | Washington | 53057 | 464 | 15 |
249312 | 249312 | 2020-06-17 | Skagit | Washington | 53057 | 469 | 15 |
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);