ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Whitman" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
8208 | 8208 | 2020-03-22 | Whitman | Washington | 53075 | 1 | 0 |
9433 | 9433 | 2020-03-23 | Whitman | Washington | 53075 | 2 | 0 |
10783 | 10783 | 2020-03-24 | Whitman | Washington | 53075 | 2 | 0 |
12306 | 12306 | 2020-03-25 | Whitman | Washington | 53075 | 2 | 0 |
13957 | 13957 | 2020-03-26 | Whitman | Washington | 53075 | 3 | 0 |
15726 | 15726 | 2020-03-27 | Whitman | Washington | 53075 | 5 | 0 |
17606 | 17606 | 2020-03-28 | Whitman | Washington | 53075 | 6 | 0 |
19571 | 19571 | 2020-03-29 | Whitman | Washington | 53075 | 6 | 0 |
21638 | 21638 | 2020-03-30 | Whitman | Washington | 53075 | 6 | 0 |
23787 | 23787 | 2020-03-31 | Whitman | Washington | 53075 | 6 | 0 |
26004 | 26004 | 2020-04-01 | Whitman | Washington | 53075 | 10 | 0 |
28296 | 28296 | 2020-04-02 | Whitman | Washington | 53075 | 11 | 0 |
30649 | 30649 | 2020-04-03 | Whitman | Washington | 53075 | 11 | 0 |
33050 | 33050 | 2020-04-04 | Whitman | Washington | 53075 | 11 | 0 |
35488 | 35488 | 2020-04-05 | Whitman | Washington | 53075 | 11 | 0 |
37972 | 37972 | 2020-04-06 | Whitman | Washington | 53075 | 13 | 0 |
40507 | 40507 | 2020-04-07 | Whitman | Washington | 53075 | 13 | 0 |
43076 | 43076 | 2020-04-08 | Whitman | Washington | 53075 | 13 | 0 |
45672 | 45672 | 2020-04-09 | Whitman | Washington | 53075 | 13 | 0 |
48300 | 48300 | 2020-04-10 | Whitman | Washington | 53075 | 13 | 0 |
50958 | 50958 | 2020-04-11 | Whitman | Washington | 53075 | 13 | 0 |
53633 | 53633 | 2020-04-12 | Whitman | Washington | 53075 | 13 | 0 |
56323 | 56323 | 2020-04-13 | Whitman | Washington | 53075 | 12 | 0 |
59029 | 59029 | 2020-04-14 | Whitman | Washington | 53075 | 13 | 0 |
61748 | 61748 | 2020-04-15 | Whitman | Washington | 53075 | 13 | 0 |
64481 | 64481 | 2020-04-16 | Whitman | Washington | 53075 | 13 | 0 |
67229 | 67229 | 2020-04-17 | Whitman | Washington | 53075 | 14 | 0 |
69991 | 69991 | 2020-04-18 | Whitman | Washington | 53075 | 15 | 0 |
72760 | 72760 | 2020-04-19 | Whitman | Washington | 53075 | 15 | 0 |
75536 | 75536 | 2020-04-20 | Whitman | Washington | 53075 | 15 | 0 |
78319 | 78319 | 2020-04-21 | Whitman | Washington | 53075 | 15 | 0 |
81112 | 81112 | 2020-04-22 | Whitman | Washington | 53075 | 15 | 0 |
83913 | 83913 | 2020-04-23 | Whitman | Washington | 53075 | 16 | 0 |
86720 | 86720 | 2020-04-24 | Whitman | Washington | 53075 | 16 | 0 |
89535 | 89535 | 2020-04-25 | Whitman | Washington | 53075 | 16 | 0 |
92352 | 92352 | 2020-04-26 | Whitman | Washington | 53075 | 16 | 0 |
95181 | 95181 | 2020-04-27 | Whitman | Washington | 53075 | 16 | 0 |
98026 | 98026 | 2020-04-28 | Whitman | Washington | 53075 | 16 | 0 |
100876 | 100876 | 2020-04-29 | Whitman | Washington | 53075 | 16 | 0 |
103731 | 103731 | 2020-04-30 | Whitman | Washington | 53075 | 16 | 0 |
106595 | 106595 | 2020-05-01 | Whitman | Washington | 53075 | 16 | 0 |
109464 | 109464 | 2020-05-02 | Whitman | Washington | 53075 | 16 | 0 |
112338 | 112338 | 2020-05-03 | Whitman | Washington | 53075 | 16 | 0 |
115221 | 115221 | 2020-05-04 | Whitman | Washington | 53075 | 16 | 0 |
118180 | 118180 | 2020-05-05 | Whitman | Washington | 53075 | 16 | 0 |
121144 | 121144 | 2020-05-06 | Whitman | Washington | 53075 | 16 | 0 |
124124 | 124124 | 2020-05-07 | Whitman | Washington | 53075 | 16 | 0 |
127109 | 127109 | 2020-05-08 | Whitman | Washington | 53075 | 16 | 0 |
130099 | 130099 | 2020-05-09 | Whitman | Washington | 53075 | 16 | 0 |
133089 | 133089 | 2020-05-10 | Whitman | Washington | 53075 | 16 | 0 |
136079 | 136079 | 2020-05-11 | Whitman | Washington | 53075 | 16 | 0 |
139070 | 139070 | 2020-05-12 | Whitman | Washington | 53075 | 16 | 0 |
142066 | 142066 | 2020-05-13 | Whitman | Washington | 53075 | 16 | 0 |
145063 | 145063 | 2020-05-14 | Whitman | Washington | 53075 | 17 | 0 |
148066 | 148066 | 2020-05-15 | Whitman | Washington | 53075 | 18 | 0 |
151075 | 151075 | 2020-05-16 | Whitman | Washington | 53075 | 18 | 0 |
154086 | 154086 | 2020-05-17 | Whitman | Washington | 53075 | 18 | 0 |
157103 | 157103 | 2020-05-18 | Whitman | Washington | 53075 | 18 | 0 |
160127 | 160127 | 2020-05-19 | Whitman | Washington | 53075 | 18 | 0 |
163155 | 163155 | 2020-05-20 | Whitman | Washington | 53075 | 19 | 0 |
166184 | 166184 | 2020-05-21 | Whitman | Washington | 53075 | 19 | 0 |
169220 | 169220 | 2020-05-22 | Whitman | Washington | 53075 | 19 | 0 |
172261 | 172261 | 2020-05-23 | Whitman | Washington | 53075 | 19 | 0 |
175304 | 175304 | 2020-05-24 | Whitman | Washington | 53075 | 19 | 0 |
178349 | 178349 | 2020-05-25 | Whitman | Washington | 53075 | 19 | 0 |
181393 | 181393 | 2020-05-26 | Whitman | Washington | 53075 | 20 | 0 |
184444 | 184444 | 2020-05-27 | Whitman | Washington | 53075 | 20 | 0 |
187501 | 187501 | 2020-05-28 | Whitman | Washington | 53075 | 20 | 0 |
190565 | 190565 | 2020-05-29 | Whitman | Washington | 53075 | 20 | 0 |
193631 | 193631 | 2020-05-30 | Whitman | Washington | 53075 | 20 | 0 |
196701 | 196701 | 2020-05-31 | Whitman | Washington | 53075 | 20 | 0 |
199774 | 199774 | 2020-06-01 | Whitman | Washington | 53075 | 20 | 0 |
202850 | 202850 | 2020-06-02 | Whitman | Washington | 53075 | 20 | 0 |
205929 | 205929 | 2020-06-03 | Whitman | Washington | 53075 | 20 | 0 |
209011 | 209011 | 2020-06-04 | Whitman | Washington | 53075 | 20 | 0 |
212096 | 212096 | 2020-06-05 | Whitman | Washington | 53075 | 20 | 0 |
215183 | 215183 | 2020-06-06 | Whitman | Washington | 53075 | 20 | 0 |
218273 | 218273 | 2020-06-07 | Whitman | Washington | 53075 | 26 | 0 |
221365 | 221365 | 2020-06-08 | Whitman | Washington | 53075 | 26 | 0 |
224461 | 224461 | 2020-06-09 | Whitman | Washington | 53075 | 26 | 0 |
227561 | 227561 | 2020-06-10 | Whitman | Washington | 53075 | 27 | 0 |
230665 | 230665 | 2020-06-11 | Whitman | Washington | 53075 | 28 | 0 |
233770 | 233770 | 2020-06-12 | Whitman | Washington | 53075 | 29 | 0 |
236877 | 236877 | 2020-06-13 | Whitman | Washington | 53075 | 29 | 0 |
239985 | 239985 | 2020-06-14 | Whitman | Washington | 53075 | 29 | 0 |
243096 | 243096 | 2020-06-15 | Whitman | Washington | 53075 | 29 | 0 |
246209 | 246209 | 2020-06-16 | Whitman | Washington | 53075 | 29 | 0 |
249321 | 249321 | 2020-06-17 | Whitman | Washington | 53075 | 30 | 0 |
252436 | 252436 | 2020-06-18 | Whitman | Washington | 53075 | 31 | 0 |
255555 | 255555 | 2020-06-19 | Whitman | Washington | 53075 | 32 | 0 |
258682 | 258682 | 2020-06-20 | Whitman | Washington | 53075 | 32 | 0 |
261809 | 261809 | 2020-06-21 | Whitman | Washington | 53075 | 32 | 0 |
264938 | 264938 | 2020-06-22 | Whitman | Washington | 53075 | 34 | 0 |
268067 | 268067 | 2020-06-23 | Whitman | Washington | 53075 | 33 | 0 |
271201 | 271201 | 2020-06-24 | Whitman | Washington | 53075 | 34 | 0 |
274341 | 274341 | 2020-06-25 | Whitman | Washington | 53075 | 35 | 0 |
277489 | 277489 | 2020-06-26 | Whitman | Washington | 53075 | 36 | 0 |
280637 | 280637 | 2020-06-27 | Whitman | Washington | 53075 | 37 | 0 |
283783 | 283783 | 2020-06-28 | Whitman | Washington | 53075 | 37 | 0 |
286929 | 286929 | 2020-06-29 | Whitman | Washington | 53075 | 38 | 0 |
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);