ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Island" 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 |
---|---|---|---|---|---|---|---|
1348 | 1348 | 2020-03-11 | Island | Washington | 53029 | 1 | 0 |
1602 | 1602 | 2020-03-12 | Island | Washington | 53029 | 3 | 0 |
1913 | 1913 | 2020-03-13 | Island | Washington | 53029 | 3 | 0 |
2286 | 2286 | 2020-03-14 | Island | Washington | 53029 | 6 | 0 |
2713 | 2713 | 2020-03-15 | Island | Washington | 53029 | 6 | 0 |
3187 | 3187 | 2020-03-16 | Island | Washington | 53029 | 7 | 0 |
3728 | 3728 | 2020-03-17 | Island | Washington | 53029 | 14 | 0 |
4363 | 4363 | 2020-03-18 | Island | Washington | 53029 | 16 | 0 |
5120 | 5120 | 2020-03-19 | Island | Washington | 53029 | 17 | 1 |
6022 | 6022 | 2020-03-20 | Island | Washington | 53029 | 19 | 1 |
7053 | 7053 | 2020-03-21 | Island | Washington | 53029 | 19 | 1 |
8190 | 8190 | 2020-03-22 | Island | Washington | 53029 | 21 | 1 |
9415 | 9415 | 2020-03-23 | Island | Washington | 53029 | 25 | 1 |
10764 | 10764 | 2020-03-24 | Island | Washington | 53029 | 29 | 1 |
12287 | 12287 | 2020-03-25 | Island | Washington | 53029 | 38 | 1 |
13937 | 13937 | 2020-03-26 | Island | Washington | 53029 | 64 | 1 |
15705 | 15705 | 2020-03-27 | Island | Washington | 53029 | 79 | 1 |
17585 | 17585 | 2020-03-28 | Island | Washington | 53029 | 92 | 1 |
19550 | 19550 | 2020-03-29 | Island | Washington | 53029 | 95 | 1 |
21617 | 21617 | 2020-03-30 | Island | Washington | 53029 | 95 | 1 |
23766 | 23766 | 2020-03-31 | Island | Washington | 53029 | 106 | 3 |
25984 | 25984 | 2020-04-01 | Island | Washington | 53029 | 114 | 3 |
28274 | 28274 | 2020-04-02 | Island | Washington | 53029 | 119 | 4 |
30627 | 30627 | 2020-04-03 | Island | Washington | 53029 | 122 | 4 |
33027 | 33027 | 2020-04-04 | Island | Washington | 53029 | 130 | 4 |
35465 | 35465 | 2020-04-05 | Island | Washington | 53029 | 132 | 5 |
37949 | 37949 | 2020-04-06 | Island | Washington | 53029 | 142 | 5 |
40484 | 40484 | 2020-04-07 | Island | Washington | 53029 | 145 | 6 |
43053 | 43053 | 2020-04-08 | Island | Washington | 53029 | 149 | 7 |
45649 | 45649 | 2020-04-09 | Island | Washington | 53029 | 151 | 7 |
48276 | 48276 | 2020-04-10 | Island | Washington | 53029 | 155 | 7 |
50934 | 50934 | 2020-04-11 | Island | Washington | 53029 | 157 | 7 |
53609 | 53609 | 2020-04-12 | Island | Washington | 53029 | 158 | 7 |
56299 | 56299 | 2020-04-13 | Island | Washington | 53029 | 158 | 7 |
59005 | 59005 | 2020-04-14 | Island | Washington | 53029 | 162 | 8 |
61724 | 61724 | 2020-04-15 | Island | Washington | 53029 | 163 | 8 |
64457 | 64457 | 2020-04-16 | Island | Washington | 53029 | 163 | 8 |
67205 | 67205 | 2020-04-17 | Island | Washington | 53029 | 165 | 8 |
69967 | 69967 | 2020-04-18 | Island | Washington | 53029 | 166 | 8 |
72737 | 72737 | 2020-04-19 | Island | Washington | 53029 | 166 | 8 |
75513 | 75513 | 2020-04-20 | Island | Washington | 53029 | 166 | 8 |
78296 | 78296 | 2020-04-21 | Island | Washington | 53029 | 168 | 8 |
81089 | 81089 | 2020-04-22 | Island | Washington | 53029 | 168 | 9 |
83890 | 83890 | 2020-04-23 | Island | Washington | 53029 | 168 | 9 |
86697 | 86697 | 2020-04-24 | Island | Washington | 53029 | 168 | 9 |
89512 | 89512 | 2020-04-25 | Island | Washington | 53029 | 168 | 9 |
92329 | 92329 | 2020-04-26 | Island | Washington | 53029 | 168 | 9 |
95158 | 95158 | 2020-04-27 | Island | Washington | 53029 | 171 | 9 |
98003 | 98003 | 2020-04-28 | Island | Washington | 53029 | 172 | 9 |
100853 | 100853 | 2020-04-29 | Island | Washington | 53029 | 172 | 9 |
103708 | 103708 | 2020-04-30 | Island | Washington | 53029 | 172 | 9 |
106572 | 106572 | 2020-05-01 | Island | Washington | 53029 | 175 | 9 |
109441 | 109441 | 2020-05-02 | Island | Washington | 53029 | 175 | 9 |
112315 | 112315 | 2020-05-03 | Island | Washington | 53029 | 175 | 9 |
115198 | 115198 | 2020-05-04 | Island | Washington | 53029 | 175 | 9 |
118157 | 118157 | 2020-05-05 | Island | Washington | 53029 | 175 | 9 |
121121 | 121121 | 2020-05-06 | Island | Washington | 53029 | 178 | 9 |
124101 | 124101 | 2020-05-07 | Island | Washington | 53029 | 179 | 9 |
127086 | 127086 | 2020-05-08 | Island | Washington | 53029 | 179 | 9 |
130076 | 130076 | 2020-05-09 | Island | Washington | 53029 | 179 | 9 |
133066 | 133066 | 2020-05-10 | Island | Washington | 53029 | 179 | 9 |
136056 | 136056 | 2020-05-11 | Island | Washington | 53029 | 179 | 9 |
139047 | 139047 | 2020-05-12 | Island | Washington | 53029 | 181 | 9 |
142043 | 142043 | 2020-05-13 | Island | Washington | 53029 | 181 | 9 |
145040 | 145040 | 2020-05-14 | Island | Washington | 53029 | 181 | 10 |
148043 | 148043 | 2020-05-15 | Island | Washington | 53029 | 181 | 10 |
151052 | 151052 | 2020-05-16 | Island | Washington | 53029 | 181 | 10 |
154063 | 154063 | 2020-05-17 | Island | Washington | 53029 | 181 | 10 |
157080 | 157080 | 2020-05-18 | Island | Washington | 53029 | 181 | 10 |
160104 | 160104 | 2020-05-19 | Island | Washington | 53029 | 181 | 10 |
163132 | 163132 | 2020-05-20 | Island | Washington | 53029 | 181 | 10 |
166161 | 166161 | 2020-05-21 | Island | Washington | 53029 | 181 | 10 |
169197 | 169197 | 2020-05-22 | Island | Washington | 53029 | 181 | 10 |
172238 | 172238 | 2020-05-23 | Island | Washington | 53029 | 181 | 10 |
175281 | 175281 | 2020-05-24 | Island | Washington | 53029 | 181 | 10 |
178326 | 178326 | 2020-05-25 | Island | Washington | 53029 | 181 | 10 |
181370 | 181370 | 2020-05-26 | Island | Washington | 53029 | 180 | 10 |
184421 | 184421 | 2020-05-27 | Island | Washington | 53029 | 180 | 11 |
187478 | 187478 | 2020-05-28 | Island | Washington | 53029 | 180 | 11 |
190542 | 190542 | 2020-05-29 | Island | Washington | 53029 | 180 | 11 |
193608 | 193608 | 2020-05-30 | Island | Washington | 53029 | 180 | 11 |
196678 | 196678 | 2020-05-31 | Island | Washington | 53029 | 180 | 11 |
199751 | 199751 | 2020-06-01 | Island | Washington | 53029 | 181 | 11 |
202827 | 202827 | 2020-06-02 | Island | Washington | 53029 | 181 | 11 |
205906 | 205906 | 2020-06-03 | Island | Washington | 53029 | 181 | 11 |
208988 | 208988 | 2020-06-04 | Island | Washington | 53029 | 181 | 11 |
212073 | 212073 | 2020-06-05 | Island | Washington | 53029 | 181 | 11 |
215160 | 215160 | 2020-06-06 | Island | Washington | 53029 | 181 | 11 |
218250 | 218250 | 2020-06-07 | Island | Washington | 53029 | 181 | 11 |
221342 | 221342 | 2020-06-08 | Island | Washington | 53029 | 182 | 11 |
224438 | 224438 | 2020-06-09 | Island | Washington | 53029 | 181 | 11 |
227538 | 227538 | 2020-06-10 | Island | Washington | 53029 | 182 | 11 |
230642 | 230642 | 2020-06-11 | Island | Washington | 53029 | 182 | 11 |
233747 | 233747 | 2020-06-12 | Island | Washington | 53029 | 182 | 11 |
236854 | 236854 | 2020-06-13 | Island | Washington | 53029 | 182 | 11 |
239962 | 239962 | 2020-06-14 | Island | Washington | 53029 | 182 | 11 |
243073 | 243073 | 2020-06-15 | Island | Washington | 53029 | 183 | 11 |
246186 | 246186 | 2020-06-16 | Island | Washington | 53029 | 183 | 11 |
249298 | 249298 | 2020-06-17 | Island | Washington | 53029 | 184 | 11 |
252413 | 252413 | 2020-06-18 | Island | Washington | 53029 | 184 | 12 |
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);