ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
810 rows where county = "Spokane" sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
296 | 296 | 2020-02-24 | Spokane | Washington | 53063 | 4 | 0 |
313 | 313 | 2020-02-25 | Spokane | Washington | 53063 | 4 | 0 |
333 | 333 | 2020-02-26 | Spokane | Washington | 53063 | 4 | 0 |
353 | 353 | 2020-02-27 | Spokane | Washington | 53063 | 4 | 0 |
375 | 375 | 2020-02-28 | Spokane | Washington | 53063 | 4 | 0 |
397 | 397 | 2020-02-29 | Spokane | Washington | 53063 | 4 | 0 |
424 | 424 | 2020-03-01 | Spokane | Washington | 53063 | 4 | 0 |
456 | 456 | 2020-03-02 | Spokane | Washington | 53063 | 4 | 0 |
491 | 491 | 2020-03-03 | Spokane | Washington | 53063 | 4 | 0 |
530 | 530 | 2020-03-04 | Spokane | Washington | 53063 | 4 | 0 |
579 | 579 | 2020-03-05 | Spokane | Washington | 53063 | 4 | 0 |
653 | 653 | 2020-03-06 | Spokane | Washington | 53063 | 4 | 0 |
748 | 748 | 2020-03-07 | Spokane | Washington | 53063 | 4 | 0 |
861 | 861 | 2020-03-08 | Spokane | Washington | 53063 | 4 | 0 |
992 | 992 | 2020-03-09 | Spokane | Washington | 53063 | 4 | 0 |
1156 | 1156 | 2020-03-10 | Spokane | Washington | 53063 | 4 | 0 |
1356 | 1356 | 2020-03-11 | Spokane | Washington | 53063 | 4 | 0 |
1610 | 1610 | 2020-03-12 | Spokane | Washington | 53063 | 4 | 0 |
1921 | 1921 | 2020-03-13 | Spokane | Washington | 53063 | 4 | 0 |
2295 | 2295 | 2020-03-14 | Spokane | Washington | 53063 | 7 | 0 |
2724 | 2724 | 2020-03-15 | Spokane | Washington | 53063 | 7 | 0 |
3198 | 3198 | 2020-03-16 | Spokane | Washington | 53063 | 7 | 0 |
3740 | 3740 | 2020-03-17 | Spokane | Washington | 53063 | 7 | 0 |
4375 | 4375 | 2020-03-18 | Spokane | Washington | 53063 | 7 | 0 |
5132 | 5132 | 2020-03-19 | Spokane | Washington | 53063 | 9 | 0 |
6035 | 6035 | 2020-03-20 | Spokane | Washington | 53063 | 11 | 0 |
7066 | 7066 | 2020-03-21 | Spokane | Washington | 53063 | 16 | 0 |
8203 | 8203 | 2020-03-22 | Spokane | Washington | 53063 | 20 | 0 |
9428 | 9428 | 2020-03-23 | Spokane | Washington | 53063 | 29 | 0 |
10777 | 10777 | 2020-03-24 | Spokane | Washington | 53063 | 33 | 0 |
12301 | 12301 | 2020-03-25 | Spokane | Washington | 53063 | 55 | 0 |
13951 | 13951 | 2020-03-26 | Spokane | Washington | 53063 | 67 | 0 |
15720 | 15720 | 2020-03-27 | Spokane | Washington | 53063 | 86 | 1 |
17600 | 17600 | 2020-03-28 | Spokane | Washington | 53063 | 108 | 2 |
19565 | 19565 | 2020-03-29 | Spokane | Washington | 53063 | 140 | 4 |
21632 | 21632 | 2020-03-30 | Spokane | Washington | 53063 | 140 | 4 |
23781 | 23781 | 2020-03-31 | Spokane | Washington | 53063 | 140 | 4 |
25999 | 25999 | 2020-04-01 | Spokane | Washington | 53063 | 145 | 4 |
28290 | 28290 | 2020-04-02 | Spokane | Washington | 53063 | 186 | 5 |
30643 | 30643 | 2020-04-03 | Spokane | Washington | 53063 | 194 | 7 |
33043 | 33043 | 2020-04-04 | Spokane | Washington | 53063 | 209 | 10 |
35481 | 35481 | 2020-04-05 | Spokane | Washington | 53063 | 219 | 11 |
37965 | 37965 | 2020-04-06 | Spokane | Washington | 53063 | 226 | 12 |
40500 | 40500 | 2020-04-07 | Spokane | Washington | 53063 | 231 | 13 |
43069 | 43069 | 2020-04-08 | Spokane | Washington | 53063 | 231 | 13 |
45665 | 45665 | 2020-04-09 | Spokane | Washington | 53063 | 246 | 14 |
48293 | 48293 | 2020-04-10 | Spokane | Washington | 53063 | 255 | 14 |
50951 | 50951 | 2020-04-11 | Spokane | Washington | 53063 | 255 | 14 |
53626 | 53626 | 2020-04-12 | Spokane | Washington | 53063 | 278 | 14 |
56316 | 56316 | 2020-04-13 | Spokane | Washington | 53063 | 280 | 15 |
59022 | 59022 | 2020-04-14 | Spokane | Washington | 53063 | 282 | 17 |
61741 | 61741 | 2020-04-15 | Spokane | Washington | 53063 | 290 | 17 |
64474 | 64474 | 2020-04-16 | Spokane | Washington | 53063 | 297 | 17 |
67222 | 67222 | 2020-04-17 | Spokane | Washington | 53063 | 302 | 17 |
69984 | 69984 | 2020-04-18 | Spokane | Washington | 53063 | 306 | 17 |
72754 | 72754 | 2020-04-19 | Spokane | Washington | 53063 | 311 | 17 |
75530 | 75530 | 2020-04-20 | Spokane | Washington | 53063 | 317 | 17 |
78313 | 78313 | 2020-04-21 | Spokane | Washington | 53063 | 319 | 19 |
81106 | 81106 | 2020-04-22 | Spokane | Washington | 53063 | 321 | 19 |
83907 | 83907 | 2020-04-23 | Spokane | Washington | 53063 | 326 | 19 |
86714 | 86714 | 2020-04-24 | Spokane | Washington | 53063 | 330 | 19 |
89529 | 89529 | 2020-04-25 | Spokane | Washington | 53063 | 345 | 19 |
92346 | 92346 | 2020-04-26 | Spokane | Washington | 53063 | 351 | 19 |
95175 | 95175 | 2020-04-27 | Spokane | Washington | 53063 | 353 | 19 |
98020 | 98020 | 2020-04-28 | Spokane | Washington | 53063 | 354 | 20 |
100870 | 100870 | 2020-04-29 | Spokane | Washington | 53063 | 357 | 20 |
103725 | 103725 | 2020-04-30 | Spokane | Washington | 53063 | 366 | 22 |
106589 | 106589 | 2020-05-01 | Spokane | Washington | 53063 | 371 | 22 |
109458 | 109458 | 2020-05-02 | Spokane | Washington | 53063 | 371 | 22 |
112332 | 112332 | 2020-05-03 | Spokane | Washington | 53063 | 373 | 22 |
115215 | 115215 | 2020-05-04 | Spokane | Washington | 53063 | 378 | 22 |
118174 | 118174 | 2020-05-05 | Spokane | Washington | 53063 | 379 | 23 |
121138 | 121138 | 2020-05-06 | Spokane | Washington | 53063 | 384 | 23 |
124118 | 124118 | 2020-05-07 | Spokane | Washington | 53063 | 386 | 25 |
127103 | 127103 | 2020-05-08 | Spokane | Washington | 53063 | 386 | 28 |
130093 | 130093 | 2020-05-09 | Spokane | Washington | 53063 | 386 | 28 |
133083 | 133083 | 2020-05-10 | Spokane | Washington | 53063 | 386 | 28 |
136073 | 136073 | 2020-05-11 | Spokane | Washington | 53063 | 390 | 29 |
139064 | 139064 | 2020-05-12 | Spokane | Washington | 53063 | 390 | 29 |
142060 | 142060 | 2020-05-13 | Spokane | Washington | 53063 | 390 | 29 |
145057 | 145057 | 2020-05-14 | Spokane | Washington | 53063 | 398 | 30 |
148060 | 148060 | 2020-05-15 | Spokane | Washington | 53063 | 400 | 30 |
151069 | 151069 | 2020-05-16 | Spokane | Washington | 53063 | 400 | 30 |
154080 | 154080 | 2020-05-17 | Spokane | Washington | 53063 | 404 | 30 |
157097 | 157097 | 2020-05-18 | Spokane | Washington | 53063 | 412 | 30 |
160121 | 160121 | 2020-05-19 | Spokane | Washington | 53063 | 416 | 31 |
163149 | 163149 | 2020-05-20 | Spokane | Washington | 53063 | 423 | 31 |
166178 | 166178 | 2020-05-21 | Spokane | Washington | 53063 | 436 | 31 |
169214 | 169214 | 2020-05-22 | Spokane | Washington | 53063 | 454 | 31 |
172255 | 172255 | 2020-05-23 | Spokane | Washington | 53063 | 467 | 31 |
175298 | 175298 | 2020-05-24 | Spokane | Washington | 53063 | 481 | 31 |
178343 | 178343 | 2020-05-25 | Spokane | Washington | 53063 | 498 | 31 |
181387 | 181387 | 2020-05-26 | Spokane | Washington | 53063 | 507 | 31 |
184438 | 184438 | 2020-05-27 | Spokane | Washington | 53063 | 530 | 31 |
187495 | 187495 | 2020-05-28 | Spokane | Washington | 53063 | 544 | 31 |
190559 | 190559 | 2020-05-29 | Spokane | Washington | 53063 | 574 | 32 |
193625 | 193625 | 2020-05-30 | Spokane | Washington | 53063 | 586 | 32 |
196695 | 196695 | 2020-05-31 | Spokane | Washington | 53063 | 600 | 32 |
199768 | 199768 | 2020-06-01 | Spokane | Washington | 53063 | 606 | 33 |
202844 | 202844 | 2020-06-02 | Spokane | Washington | 53063 | 619 | 34 |
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);