ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 53073 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
1158 | 1158 | 2020-03-10 | Whatcom | Washington | 53073 | 1 | 0 |
1359 | 1359 | 2020-03-11 | Whatcom | Washington | 53073 | 1 | 0 |
1613 | 1613 | 2020-03-12 | Whatcom | Washington | 53073 | 1 | 0 |
1924 | 1924 | 2020-03-13 | Whatcom | Washington | 53073 | 1 | 0 |
2298 | 2298 | 2020-03-14 | Whatcom | Washington | 53073 | 2 | 0 |
2727 | 2727 | 2020-03-15 | Whatcom | Washington | 53073 | 3 | 0 |
3201 | 3201 | 2020-03-16 | Whatcom | Washington | 53073 | 3 | 0 |
3743 | 3743 | 2020-03-17 | Whatcom | Washington | 53073 | 6 | 0 |
4378 | 4378 | 2020-03-18 | Whatcom | Washington | 53073 | 7 | 0 |
5135 | 5135 | 2020-03-19 | Whatcom | Washington | 53073 | 7 | 1 |
6039 | 6039 | 2020-03-20 | Whatcom | Washington | 53073 | 11 | 1 |
7070 | 7070 | 2020-03-21 | Whatcom | Washington | 53073 | 14 | 2 |
8207 | 8207 | 2020-03-22 | Whatcom | Washington | 53073 | 19 | 2 |
9432 | 9432 | 2020-03-23 | Whatcom | Washington | 53073 | 48 | 2 |
10782 | 10782 | 2020-03-24 | Whatcom | Washington | 53073 | 64 | 2 |
12305 | 12305 | 2020-03-25 | Whatcom | Washington | 53073 | 66 | 2 |
13956 | 13956 | 2020-03-26 | Whatcom | Washington | 53073 | 86 | 4 |
15725 | 15725 | 2020-03-27 | Whatcom | Washington | 53073 | 92 | 4 |
17605 | 17605 | 2020-03-28 | Whatcom | Washington | 53073 | 102 | 4 |
19570 | 19570 | 2020-03-29 | Whatcom | Washington | 53073 | 116 | 7 |
21637 | 21637 | 2020-03-30 | Whatcom | Washington | 53073 | 116 | 7 |
23786 | 23786 | 2020-03-31 | Whatcom | Washington | 53073 | 116 | 7 |
26003 | 26003 | 2020-04-01 | Whatcom | Washington | 53073 | 144 | 8 |
28295 | 28295 | 2020-04-02 | Whatcom | Washington | 53073 | 175 | 9 |
30648 | 30648 | 2020-04-03 | Whatcom | Washington | 53073 | 182 | 9 |
33049 | 33049 | 2020-04-04 | Whatcom | Washington | 53073 | 199 | 9 |
35487 | 35487 | 2020-04-05 | Whatcom | Washington | 53073 | 224 | 15 |
37971 | 37971 | 2020-04-06 | Whatcom | Washington | 53073 | 228 | 19 |
40506 | 40506 | 2020-04-07 | Whatcom | Washington | 53073 | 238 | 19 |
43075 | 43075 | 2020-04-08 | Whatcom | Washington | 53073 | 238 | 20 |
45671 | 45671 | 2020-04-09 | Whatcom | Washington | 53073 | 243 | 21 |
48299 | 48299 | 2020-04-10 | Whatcom | Washington | 53073 | 250 | 23 |
50957 | 50957 | 2020-04-11 | Whatcom | Washington | 53073 | 252 | 23 |
53632 | 53632 | 2020-04-12 | Whatcom | Washington | 53073 | 263 | 23 |
56322 | 56322 | 2020-04-13 | Whatcom | Washington | 53073 | 263 | 23 |
59028 | 59028 | 2020-04-14 | Whatcom | Washington | 53073 | 265 | 25 |
61747 | 61747 | 2020-04-15 | Whatcom | Washington | 53073 | 269 | 25 |
64480 | 64480 | 2020-04-16 | Whatcom | Washington | 53073 | 271 | 25 |
67228 | 67228 | 2020-04-17 | Whatcom | Washington | 53073 | 271 | 25 |
69990 | 69990 | 2020-04-18 | Whatcom | Washington | 53073 | 273 | 26 |
72759 | 72759 | 2020-04-19 | Whatcom | Washington | 53073 | 277 | 26 |
75535 | 75535 | 2020-04-20 | Whatcom | Washington | 53073 | 278 | 27 |
78318 | 78318 | 2020-04-21 | Whatcom | Washington | 53073 | 280 | 27 |
81111 | 81111 | 2020-04-22 | Whatcom | Washington | 53073 | 280 | 27 |
83912 | 83912 | 2020-04-23 | Whatcom | Washington | 53073 | 282 | 27 |
86719 | 86719 | 2020-04-24 | Whatcom | Washington | 53073 | 282 | 27 |
89534 | 89534 | 2020-04-25 | Whatcom | Washington | 53073 | 284 | 27 |
92351 | 92351 | 2020-04-26 | Whatcom | Washington | 53073 | 288 | 27 |
95180 | 95180 | 2020-04-27 | Whatcom | Washington | 53073 | 290 | 27 |
98025 | 98025 | 2020-04-28 | Whatcom | Washington | 53073 | 293 | 28 |
100875 | 100875 | 2020-04-29 | Whatcom | Washington | 53073 | 294 | 28 |
103730 | 103730 | 2020-04-30 | Whatcom | Washington | 53073 | 304 | 28 |
106594 | 106594 | 2020-05-01 | Whatcom | Washington | 53073 | 311 | 28 |
109463 | 109463 | 2020-05-02 | Whatcom | Washington | 53073 | 311 | 28 |
112337 | 112337 | 2020-05-03 | Whatcom | Washington | 53073 | 316 | 28 |
115220 | 115220 | 2020-05-04 | Whatcom | Washington | 53073 | 317 | 28 |
118179 | 118179 | 2020-05-05 | Whatcom | Washington | 53073 | 318 | 29 |
121143 | 121143 | 2020-05-06 | Whatcom | Washington | 53073 | 324 | 30 |
124123 | 124123 | 2020-05-07 | Whatcom | Washington | 53073 | 328 | 33 |
127108 | 127108 | 2020-05-08 | Whatcom | Washington | 53073 | 329 | 33 |
130098 | 130098 | 2020-05-09 | Whatcom | Washington | 53073 | 330 | 33 |
133088 | 133088 | 2020-05-10 | Whatcom | Washington | 53073 | 333 | 34 |
136078 | 136078 | 2020-05-11 | Whatcom | Washington | 53073 | 338 | 34 |
139069 | 139069 | 2020-05-12 | Whatcom | Washington | 53073 | 340 | 34 |
142065 | 142065 | 2020-05-13 | Whatcom | Washington | 53073 | 344 | 35 |
145062 | 145062 | 2020-05-14 | Whatcom | Washington | 53073 | 344 | 35 |
148065 | 148065 | 2020-05-15 | Whatcom | Washington | 53073 | 344 | 35 |
151074 | 151074 | 2020-05-16 | Whatcom | Washington | 53073 | 347 | 35 |
154085 | 154085 | 2020-05-17 | Whatcom | Washington | 53073 | 347 | 35 |
157102 | 157102 | 2020-05-18 | Whatcom | Washington | 53073 | 358 | 35 |
160126 | 160126 | 2020-05-19 | Whatcom | Washington | 53073 | 359 | 36 |
163154 | 163154 | 2020-05-20 | Whatcom | Washington | 53073 | 359 | 36 |
166183 | 166183 | 2020-05-21 | Whatcom | Washington | 53073 | 359 | 36 |
169219 | 169219 | 2020-05-22 | Whatcom | Washington | 53073 | 363 | 36 |
172260 | 172260 | 2020-05-23 | Whatcom | Washington | 53073 | 368 | 36 |
175303 | 175303 | 2020-05-24 | Whatcom | Washington | 53073 | 368 | 36 |
178348 | 178348 | 2020-05-25 | Whatcom | Washington | 53073 | 368 | 36 |
181392 | 181392 | 2020-05-26 | Whatcom | Washington | 53073 | 378 | 36 |
184443 | 184443 | 2020-05-27 | Whatcom | Washington | 53073 | 380 | 36 |
187500 | 187500 | 2020-05-28 | Whatcom | Washington | 53073 | 383 | 36 |
190564 | 190564 | 2020-05-29 | Whatcom | Washington | 53073 | 383 | 36 |
193630 | 193630 | 2020-05-30 | Whatcom | Washington | 53073 | 392 | 36 |
196700 | 196700 | 2020-05-31 | Whatcom | Washington | 53073 | 396 | 36 |
199773 | 199773 | 2020-06-01 | Whatcom | Washington | 53073 | 398 | 37 |
202849 | 202849 | 2020-06-02 | Whatcom | Washington | 53073 | 401 | 37 |
205928 | 205928 | 2020-06-03 | Whatcom | Washington | 53073 | 402 | 37 |
209010 | 209010 | 2020-06-04 | Whatcom | Washington | 53073 | 404 | 37 |
212095 | 212095 | 2020-06-05 | Whatcom | Washington | 53073 | 405 | 37 |
215182 | 215182 | 2020-06-06 | Whatcom | Washington | 53073 | 409 | 37 |
218272 | 218272 | 2020-06-07 | Whatcom | Washington | 53073 | 410 | 37 |
221364 | 221364 | 2020-06-08 | Whatcom | Washington | 53073 | 419 | 37 |
224460 | 224460 | 2020-06-09 | Whatcom | Washington | 53073 | 420 | 38 |
227560 | 227560 | 2020-06-10 | Whatcom | Washington | 53073 | 420 | 38 |
230664 | 230664 | 2020-06-11 | Whatcom | Washington | 53073 | 428 | 38 |
233769 | 233769 | 2020-06-12 | Whatcom | Washington | 53073 | 436 | 38 |
236876 | 236876 | 2020-06-13 | Whatcom | Washington | 53073 | 440 | 38 |
239984 | 239984 | 2020-06-14 | Whatcom | Washington | 53073 | 448 | 38 |
243095 | 243095 | 2020-06-15 | Whatcom | Washington | 53073 | 453 | 38 |
246208 | 246208 | 2020-06-16 | Whatcom | Washington | 53073 | 455 | 39 |
249320 | 249320 | 2020-06-17 | Whatcom | Washington | 53073 | 457 | 39 |
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);