ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Washington", fips = 16087 and state = "Idaho" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
26605 | 26605 | 2020-04-02 | Washington | Idaho | 16087 | 1 | 0 |
28912 | 28912 | 2020-04-03 | Washington | Idaho | 16087 | 1 | 0 |
31274 | 31274 | 2020-04-04 | Washington | Idaho | 16087 | 1 | 0 |
33681 | 33681 | 2020-04-05 | Washington | Idaho | 16087 | 1 | 0 |
36132 | 36132 | 2020-04-06 | Washington | Idaho | 16087 | 1 | 0 |
38626 | 38626 | 2020-04-07 | Washington | Idaho | 16087 | 1 | 0 |
41170 | 41170 | 2020-04-08 | Washington | Idaho | 16087 | 1 | 0 |
43744 | 43744 | 2020-04-09 | Washington | Idaho | 16087 | 1 | 0 |
46346 | 46346 | 2020-04-10 | Washington | Idaho | 16087 | 1 | 0 |
48977 | 48977 | 2020-04-11 | Washington | Idaho | 16087 | 1 | 0 |
51639 | 51639 | 2020-04-12 | Washington | Idaho | 16087 | 1 | 0 |
54319 | 54319 | 2020-04-13 | Washington | Idaho | 16087 | 1 | 0 |
57011 | 57011 | 2020-04-14 | Washington | Idaho | 16087 | 1 | 0 |
59718 | 59718 | 2020-04-15 | Washington | Idaho | 16087 | 1 | 0 |
62438 | 62438 | 2020-04-16 | Washington | Idaho | 16087 | 1 | 0 |
65170 | 65170 | 2020-04-17 | Washington | Idaho | 16087 | 1 | 0 |
67918 | 67918 | 2020-04-18 | Washington | Idaho | 16087 | 1 | 0 |
70680 | 70680 | 2020-04-19 | Washington | Idaho | 16087 | 1 | 0 |
73449 | 73449 | 2020-04-20 | Washington | Idaho | 16087 | 1 | 0 |
76225 | 76225 | 2020-04-21 | Washington | Idaho | 16087 | 1 | 0 |
79009 | 79009 | 2020-04-22 | Washington | Idaho | 16087 | 1 | 0 |
81802 | 81802 | 2020-04-23 | Washington | Idaho | 16087 | 1 | 0 |
84602 | 84602 | 2020-04-24 | Washington | Idaho | 16087 | 2 | 0 |
87412 | 87412 | 2020-04-25 | Washington | Idaho | 16087 | 1 | 0 |
90228 | 90228 | 2020-04-26 | Washington | Idaho | 16087 | 1 | 0 |
93047 | 93047 | 2020-04-27 | Washington | Idaho | 16087 | 1 | 0 |
95879 | 95879 | 2020-04-28 | Washington | Idaho | 16087 | 1 | 0 |
98723 | 98723 | 2020-04-29 | Washington | Idaho | 16087 | 1 | 0 |
101574 | 101574 | 2020-04-30 | Washington | Idaho | 16087 | 1 | 0 |
104429 | 104429 | 2020-05-01 | Washington | Idaho | 16087 | 1 | 0 |
107294 | 107294 | 2020-05-02 | Washington | Idaho | 16087 | 1 | 0 |
110164 | 110164 | 2020-05-03 | Washington | Idaho | 16087 | 1 | 0 |
113039 | 113039 | 2020-05-04 | Washington | Idaho | 16087 | 1 | 0 |
115922 | 115922 | 2020-05-05 | Washington | Idaho | 16087 | 1 | 0 |
118882 | 118882 | 2020-05-06 | Washington | Idaho | 16087 | 1 | 0 |
121852 | 121852 | 2020-05-07 | Washington | Idaho | 16087 | 1 | 0 |
124831 | 124831 | 2020-05-08 | Washington | Idaho | 16087 | 1 | 0 |
127818 | 127818 | 2020-05-09 | Washington | Idaho | 16087 | 1 | 0 |
130809 | 130809 | 2020-05-10 | Washington | Idaho | 16087 | 1 | 0 |
133800 | 133800 | 2020-05-11 | Washington | Idaho | 16087 | 2 | 0 |
136789 | 136789 | 2020-05-12 | Washington | Idaho | 16087 | 8 | 0 |
139780 | 139780 | 2020-05-13 | Washington | Idaho | 16087 | 10 | 0 |
142776 | 142776 | 2020-05-14 | Washington | Idaho | 16087 | 13 | 0 |
145776 | 145776 | 2020-05-15 | Washington | Idaho | 16087 | 20 | 0 |
148779 | 148779 | 2020-05-16 | Washington | Idaho | 16087 | 23 | 0 |
151788 | 151788 | 2020-05-17 | Washington | Idaho | 16087 | 23 | 0 |
154800 | 154800 | 2020-05-18 | Washington | Idaho | 16087 | 30 | 0 |
157816 | 157816 | 2020-05-19 | Washington | Idaho | 16087 | 31 | 0 |
160842 | 160842 | 2020-05-20 | Washington | Idaho | 16087 | 32 | 0 |
163870 | 163870 | 2020-05-21 | Washington | Idaho | 16087 | 33 | 0 |
166903 | 166903 | 2020-05-22 | Washington | Idaho | 16087 | 34 | 0 |
169940 | 169940 | 2020-05-23 | Washington | Idaho | 16087 | 34 | 0 |
172981 | 172981 | 2020-05-24 | Washington | Idaho | 16087 | 34 | 0 |
176025 | 176025 | 2020-05-25 | Washington | Idaho | 16087 | 34 | 0 |
179069 | 179069 | 2020-05-26 | Washington | Idaho | 16087 | 34 | 0 |
182113 | 182113 | 2020-05-27 | Washington | Idaho | 16087 | 34 | 0 |
185167 | 185167 | 2020-05-28 | Washington | Idaho | 16087 | 36 | 0 |
188224 | 188224 | 2020-05-29 | Washington | Idaho | 16087 | 38 | 0 |
191289 | 191289 | 2020-05-30 | Washington | Idaho | 16087 | 38 | 0 |
194356 | 194356 | 2020-05-31 | Washington | Idaho | 16087 | 38 | 0 |
197426 | 197426 | 2020-06-01 | Washington | Idaho | 16087 | 38 | 0 |
200499 | 200499 | 2020-06-02 | Washington | Idaho | 16087 | 43 | 0 |
203575 | 203575 | 2020-06-03 | Washington | Idaho | 16087 | 44 | 0 |
206655 | 206655 | 2020-06-04 | Washington | Idaho | 16087 | 45 | 0 |
209736 | 209736 | 2020-06-05 | Washington | Idaho | 16087 | 46 | 0 |
212821 | 212821 | 2020-06-06 | Washington | Idaho | 16087 | 46 | 0 |
215908 | 215908 | 2020-06-07 | Washington | Idaho | 16087 | 46 | 0 |
218999 | 218999 | 2020-06-08 | Washington | Idaho | 16087 | 46 | 0 |
222094 | 222094 | 2020-06-09 | Washington | Idaho | 16087 | 46 | 0 |
225189 | 225189 | 2020-06-10 | Washington | Idaho | 16087 | 49 | 0 |
228291 | 228291 | 2020-06-11 | Washington | Idaho | 16087 | 49 | 0 |
231394 | 231394 | 2020-06-12 | Washington | Idaho | 16087 | 50 | 0 |
234500 | 234500 | 2020-06-13 | Washington | Idaho | 16087 | 55 | 0 |
237607 | 237607 | 2020-06-14 | Washington | Idaho | 16087 | 55 | 0 |
240715 | 240715 | 2020-06-15 | Washington | Idaho | 16087 | 57 | 0 |
243826 | 243826 | 2020-06-16 | Washington | Idaho | 16087 | 62 | 0 |
246939 | 246939 | 2020-06-17 | Washington | Idaho | 16087 | 70 | 0 |
250051 | 250051 | 2020-06-18 | Washington | Idaho | 16087 | 78 | 0 |
253166 | 253166 | 2020-06-19 | Washington | Idaho | 16087 | 84 | 0 |
256286 | 256286 | 2020-06-20 | Washington | Idaho | 16087 | 84 | 0 |
259412 | 259412 | 2020-06-21 | Washington | Idaho | 16087 | 84 | 0 |
262539 | 262539 | 2020-06-22 | Washington | Idaho | 16087 | 89 | 0 |
265667 | 265667 | 2020-06-23 | Washington | Idaho | 16087 | 96 | 0 |
268797 | 268797 | 2020-06-24 | Washington | Idaho | 16087 | 97 | 0 |
271934 | 271934 | 2020-06-25 | Washington | Idaho | 16087 | 97 | 0 |
275076 | 275076 | 2020-06-26 | Washington | Idaho | 16087 | 98 | 0 |
278224 | 278224 | 2020-06-27 | Washington | Idaho | 16087 | 98 | 0 |
281372 | 281372 | 2020-06-28 | Washington | Idaho | 16087 | 98 | 0 |
284517 | 284517 | 2020-06-29 | Washington | Idaho | 16087 | 100 | 0 |
287666 | 287666 | 2020-06-30 | Washington | Idaho | 16087 | 102 | 0 |
290816 | 290816 | 2020-07-01 | Washington | Idaho | 16087 | 107 | 0 |
293970 | 293970 | 2020-07-02 | Washington | Idaho | 16087 | 108 | 0 |
297127 | 297127 | 2020-07-03 | Washington | Idaho | 16087 | 113 | 1 |
300289 | 300289 | 2020-07-04 | Washington | Idaho | 16087 | 114 | 1 |
303453 | 303453 | 2020-07-05 | Washington | Idaho | 16087 | 118 | 1 |
306618 | 306618 | 2020-07-06 | Washington | Idaho | 16087 | 118 | 1 |
309786 | 309786 | 2020-07-07 | Washington | Idaho | 16087 | 120 | 1 |
312956 | 312956 | 2020-07-08 | Washington | Idaho | 16087 | 124 | 2 |
316130 | 316130 | 2020-07-09 | Washington | Idaho | 16087 | 129 | 2 |
319303 | 319303 | 2020-07-10 | Washington | Idaho | 16087 | 130 | 2 |
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);