ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Grant" and state = "Washington" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
1911 | 1911 | 2020-03-13 | Grant | Washington | 53025 | 1 | 0 |
2284 | 2284 | 2020-03-14 | Grant | Washington | 53025 | 1 | 0 |
2711 | 2711 | 2020-03-15 | Grant | Washington | 53025 | 1 | 0 |
3185 | 3185 | 2020-03-16 | Grant | Washington | 53025 | 6 | 0 |
3726 | 3726 | 2020-03-17 | Grant | Washington | 53025 | 6 | 0 |
4361 | 4361 | 2020-03-18 | Grant | Washington | 53025 | 6 | 0 |
5118 | 5118 | 2020-03-19 | Grant | Washington | 53025 | 8 | 0 |
6020 | 6020 | 2020-03-20 | Grant | Washington | 53025 | 11 | 0 |
7051 | 7051 | 2020-03-21 | Grant | Washington | 53025 | 11 | 0 |
8188 | 8188 | 2020-03-22 | Grant | Washington | 53025 | 18 | 0 |
9413 | 9413 | 2020-03-23 | Grant | Washington | 53025 | 23 | 0 |
10762 | 10762 | 2020-03-24 | Grant | Washington | 53025 | 27 | 0 |
12285 | 12285 | 2020-03-25 | Grant | Washington | 53025 | 26 | 0 |
13935 | 13935 | 2020-03-26 | Grant | Washington | 53025 | 33 | 1 |
15703 | 15703 | 2020-03-27 | Grant | Washington | 53025 | 42 | 1 |
17583 | 17583 | 2020-03-28 | Grant | Washington | 53025 | 44 | 1 |
19548 | 19548 | 2020-03-29 | Grant | Washington | 53025 | 58 | 1 |
21615 | 21615 | 2020-03-30 | Grant | Washington | 53025 | 62 | 0 |
23764 | 23764 | 2020-03-31 | Grant | Washington | 53025 | 62 | 0 |
25982 | 25982 | 2020-04-01 | Grant | Washington | 53025 | 73 | 0 |
28272 | 28272 | 2020-04-02 | Grant | Washington | 53025 | 74 | 0 |
30625 | 30625 | 2020-04-03 | Grant | Washington | 53025 | 77 | 0 |
33025 | 33025 | 2020-04-04 | Grant | Washington | 53025 | 80 | 1 |
35463 | 35463 | 2020-04-05 | Grant | Washington | 53025 | 87 | 1 |
37947 | 37947 | 2020-04-06 | Grant | Washington | 53025 | 90 | 2 |
40482 | 40482 | 2020-04-07 | Grant | Washington | 53025 | 93 | 2 |
43051 | 43051 | 2020-04-08 | Grant | Washington | 53025 | 95 | 2 |
45647 | 45647 | 2020-04-09 | Grant | Washington | 53025 | 101 | 2 |
48274 | 48274 | 2020-04-10 | Grant | Washington | 53025 | 101 | 2 |
50932 | 50932 | 2020-04-11 | Grant | Washington | 53025 | 111 | 2 |
53607 | 53607 | 2020-04-12 | Grant | Washington | 53025 | 119 | 2 |
56297 | 56297 | 2020-04-13 | Grant | Washington | 53025 | 121 | 2 |
59003 | 59003 | 2020-04-14 | Grant | Washington | 53025 | 121 | 2 |
61722 | 61722 | 2020-04-15 | Grant | Washington | 53025 | 129 | 2 |
64455 | 64455 | 2020-04-16 | Grant | Washington | 53025 | 132 | 1 |
67203 | 67203 | 2020-04-17 | Grant | Washington | 53025 | 139 | 1 |
69965 | 69965 | 2020-04-18 | Grant | Washington | 53025 | 140 | 1 |
72735 | 72735 | 2020-04-19 | Grant | Washington | 53025 | 140 | 1 |
75511 | 75511 | 2020-04-20 | Grant | Washington | 53025 | 142 | 1 |
78294 | 78294 | 2020-04-21 | Grant | Washington | 53025 | 142 | 1 |
81087 | 81087 | 2020-04-22 | Grant | Washington | 53025 | 143 | 1 |
83888 | 83888 | 2020-04-23 | Grant | Washington | 53025 | 154 | 2 |
86695 | 86695 | 2020-04-24 | Grant | Washington | 53025 | 154 | 2 |
89510 | 89510 | 2020-04-25 | Grant | Washington | 53025 | 156 | 2 |
92327 | 92327 | 2020-04-26 | Grant | Washington | 53025 | 157 | 2 |
95156 | 95156 | 2020-04-27 | Grant | Washington | 53025 | 157 | 2 |
98001 | 98001 | 2020-04-28 | Grant | Washington | 53025 | 157 | 2 |
100851 | 100851 | 2020-04-29 | Grant | Washington | 53025 | 160 | 2 |
103706 | 103706 | 2020-04-30 | Grant | Washington | 53025 | 166 | 2 |
106570 | 106570 | 2020-05-01 | Grant | Washington | 53025 | 170 | 2 |
109439 | 109439 | 2020-05-02 | Grant | Washington | 53025 | 174 | 2 |
112313 | 112313 | 2020-05-03 | Grant | Washington | 53025 | 174 | 2 |
115196 | 115196 | 2020-05-04 | Grant | Washington | 53025 | 179 | 2 |
118155 | 118155 | 2020-05-05 | Grant | Washington | 53025 | 181 | 2 |
121119 | 121119 | 2020-05-06 | Grant | Washington | 53025 | 181 | 2 |
124099 | 124099 | 2020-05-07 | Grant | Washington | 53025 | 183 | 2 |
127084 | 127084 | 2020-05-08 | Grant | Washington | 53025 | 219 | 2 |
130074 | 130074 | 2020-05-09 | Grant | Washington | 53025 | 219 | 2 |
133064 | 133064 | 2020-05-10 | Grant | Washington | 53025 | 219 | 2 |
136054 | 136054 | 2020-05-11 | Grant | Washington | 53025 | 219 | 2 |
139045 | 139045 | 2020-05-12 | Grant | Washington | 53025 | 221 | 2 |
142041 | 142041 | 2020-05-13 | Grant | Washington | 53025 | 221 | 2 |
145038 | 145038 | 2020-05-14 | Grant | Washington | 53025 | 224 | 2 |
148041 | 148041 | 2020-05-15 | Grant | Washington | 53025 | 223 | 2 |
151050 | 151050 | 2020-05-16 | Grant | Washington | 53025 | 223 | 2 |
154061 | 154061 | 2020-05-17 | Grant | Washington | 53025 | 223 | 2 |
157078 | 157078 | 2020-05-18 | Grant | Washington | 53025 | 226 | 3 |
160102 | 160102 | 2020-05-19 | Grant | Washington | 53025 | 226 | 3 |
163130 | 163130 | 2020-05-20 | Grant | Washington | 53025 | 226 | 3 |
166159 | 166159 | 2020-05-21 | Grant | Washington | 53025 | 226 | 3 |
169195 | 169195 | 2020-05-22 | Grant | Washington | 53025 | 231 | 3 |
172236 | 172236 | 2020-05-23 | Grant | Washington | 53025 | 231 | 3 |
175279 | 175279 | 2020-05-24 | Grant | Washington | 53025 | 231 | 3 |
178324 | 178324 | 2020-05-25 | Grant | Washington | 53025 | 231 | 3 |
181368 | 181368 | 2020-05-26 | Grant | Washington | 53025 | 238 | 3 |
184419 | 184419 | 2020-05-27 | Grant | Washington | 53025 | 238 | 3 |
187476 | 187476 | 2020-05-28 | Grant | Washington | 53025 | 238 | 3 |
190540 | 190540 | 2020-05-29 | Grant | Washington | 53025 | 255 | 3 |
193606 | 193606 | 2020-05-30 | Grant | Washington | 53025 | 255 | 3 |
196676 | 196676 | 2020-05-31 | Grant | Washington | 53025 | 255 | 3 |
199749 | 199749 | 2020-06-01 | Grant | Washington | 53025 | 269 | 3 |
202825 | 202825 | 2020-06-02 | Grant | Washington | 53025 | 272 | 3 |
205904 | 205904 | 2020-06-03 | Grant | Washington | 53025 | 276 | 3 |
208986 | 208986 | 2020-06-04 | Grant | Washington | 53025 | 277 | 4 |
212071 | 212071 | 2020-06-05 | Grant | Washington | 53025 | 278 | 4 |
215158 | 215158 | 2020-06-06 | Grant | Washington | 53025 | 278 | 4 |
218248 | 218248 | 2020-06-07 | Grant | Washington | 53025 | 278 | 3 |
221340 | 221340 | 2020-06-08 | Grant | Washington | 53025 | 283 | 3 |
224436 | 224436 | 2020-06-09 | Grant | Washington | 53025 | 288 | 3 |
227536 | 227536 | 2020-06-10 | Grant | Washington | 53025 | 298 | 3 |
230640 | 230640 | 2020-06-11 | Grant | Washington | 53025 | 303 | 3 |
233745 | 233745 | 2020-06-12 | Grant | Washington | 53025 | 321 | 4 |
236852 | 236852 | 2020-06-13 | Grant | Washington | 53025 | 321 | 4 |
239960 | 239960 | 2020-06-14 | Grant | Washington | 53025 | 321 | 4 |
243071 | 243071 | 2020-06-15 | Grant | Washington | 53025 | 370 | 4 |
246184 | 246184 | 2020-06-16 | Grant | Washington | 53025 | 370 | 4 |
249296 | 249296 | 2020-06-17 | Grant | Washington | 53025 | 390 | 4 |
252411 | 252411 | 2020-06-18 | Grant | Washington | 53025 | 390 | 4 |
255530 | 255530 | 2020-06-19 | Grant | Washington | 53025 | 404 | 4 |
258657 | 258657 | 2020-06-20 | Grant | Washington | 53025 | 404 | 4 |
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);