ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,524 rows where county = "Gilmer" sorted by fips descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date | county | state | fips ▲ | cases | deaths |
---|---|---|---|---|---|---|---|
89544 | 89544 | 2020-04-25 | Gilmer | West Virginia | 54021 | 1 | 0 |
92362 | 92362 | 2020-04-26 | Gilmer | West Virginia | 54021 | 2 | 0 |
95191 | 95191 | 2020-04-27 | Gilmer | West Virginia | 54021 | 2 | 0 |
98036 | 98036 | 2020-04-28 | Gilmer | West Virginia | 54021 | 2 | 0 |
100886 | 100886 | 2020-04-29 | Gilmer | West Virginia | 54021 | 2 | 0 |
103741 | 103741 | 2020-04-30 | Gilmer | West Virginia | 54021 | 2 | 0 |
106605 | 106605 | 2020-05-01 | Gilmer | West Virginia | 54021 | 2 | 0 |
109474 | 109474 | 2020-05-02 | Gilmer | West Virginia | 54021 | 2 | 0 |
112348 | 112348 | 2020-05-03 | Gilmer | West Virginia | 54021 | 2 | 0 |
115231 | 115231 | 2020-05-04 | Gilmer | West Virginia | 54021 | 3 | 0 |
118190 | 118190 | 2020-05-05 | Gilmer | West Virginia | 54021 | 3 | 0 |
121155 | 121155 | 2020-05-06 | Gilmer | West Virginia | 54021 | 3 | 0 |
124135 | 124135 | 2020-05-07 | Gilmer | West Virginia | 54021 | 4 | 0 |
127120 | 127120 | 2020-05-08 | Gilmer | West Virginia | 54021 | 4 | 0 |
130110 | 130110 | 2020-05-09 | Gilmer | West Virginia | 54021 | 8 | 0 |
133100 | 133100 | 2020-05-10 | Gilmer | West Virginia | 54021 | 8 | 0 |
136090 | 136090 | 2020-05-11 | Gilmer | West Virginia | 54021 | 8 | 0 |
139081 | 139081 | 2020-05-12 | Gilmer | West Virginia | 54021 | 8 | 0 |
142077 | 142077 | 2020-05-13 | Gilmer | West Virginia | 54021 | 8 | 0 |
145074 | 145074 | 2020-05-14 | Gilmer | West Virginia | 54021 | 8 | 0 |
148077 | 148077 | 2020-05-15 | Gilmer | West Virginia | 54021 | 8 | 0 |
151086 | 151086 | 2020-05-16 | Gilmer | West Virginia | 54021 | 8 | 0 |
154097 | 154097 | 2020-05-17 | Gilmer | West Virginia | 54021 | 8 | 0 |
157114 | 157114 | 2020-05-18 | Gilmer | West Virginia | 54021 | 8 | 0 |
160138 | 160138 | 2020-05-19 | Gilmer | West Virginia | 54021 | 8 | 0 |
163166 | 163166 | 2020-05-20 | Gilmer | West Virginia | 54021 | 9 | 0 |
166195 | 166195 | 2020-05-21 | Gilmer | West Virginia | 54021 | 9 | 0 |
169231 | 169231 | 2020-05-22 | Gilmer | West Virginia | 54021 | 9 | 0 |
172272 | 172272 | 2020-05-23 | Gilmer | West Virginia | 54021 | 9 | 0 |
175315 | 175315 | 2020-05-24 | Gilmer | West Virginia | 54021 | 10 | 0 |
178360 | 178360 | 2020-05-25 | Gilmer | West Virginia | 54021 | 10 | 0 |
181404 | 181404 | 2020-05-26 | Gilmer | West Virginia | 54021 | 10 | 0 |
184455 | 184455 | 2020-05-27 | Gilmer | West Virginia | 54021 | 10 | 0 |
187512 | 187512 | 2020-05-28 | Gilmer | West Virginia | 54021 | 10 | 0 |
190576 | 190576 | 2020-05-29 | Gilmer | West Virginia | 54021 | 10 | 0 |
193642 | 193642 | 2020-05-30 | Gilmer | West Virginia | 54021 | 10 | 0 |
196712 | 196712 | 2020-05-31 | Gilmer | West Virginia | 54021 | 10 | 0 |
199785 | 199785 | 2020-06-01 | Gilmer | West Virginia | 54021 | 10 | 0 |
202861 | 202861 | 2020-06-02 | Gilmer | West Virginia | 54021 | 10 | 0 |
205940 | 205940 | 2020-06-03 | Gilmer | West Virginia | 54021 | 10 | 0 |
209022 | 209022 | 2020-06-04 | Gilmer | West Virginia | 54021 | 10 | 0 |
212107 | 212107 | 2020-06-05 | Gilmer | West Virginia | 54021 | 10 | 0 |
215194 | 215194 | 2020-06-06 | Gilmer | West Virginia | 54021 | 10 | 0 |
218284 | 218284 | 2020-06-07 | Gilmer | West Virginia | 54021 | 10 | 0 |
221376 | 221376 | 2020-06-08 | Gilmer | West Virginia | 54021 | 10 | 0 |
224472 | 224472 | 2020-06-09 | Gilmer | West Virginia | 54021 | 10 | 0 |
227572 | 227572 | 2020-06-10 | Gilmer | West Virginia | 54021 | 10 | 0 |
230676 | 230676 | 2020-06-11 | Gilmer | West Virginia | 54021 | 10 | 0 |
233781 | 233781 | 2020-06-12 | Gilmer | West Virginia | 54021 | 10 | 0 |
236888 | 236888 | 2020-06-13 | Gilmer | West Virginia | 54021 | 10 | 0 |
239996 | 239996 | 2020-06-14 | Gilmer | West Virginia | 54021 | 10 | 0 |
243107 | 243107 | 2020-06-15 | Gilmer | West Virginia | 54021 | 10 | 0 |
246220 | 246220 | 2020-06-16 | Gilmer | West Virginia | 54021 | 10 | 0 |
249332 | 249332 | 2020-06-17 | Gilmer | West Virginia | 54021 | 10 | 0 |
252447 | 252447 | 2020-06-18 | Gilmer | West Virginia | 54021 | 10 | 0 |
255566 | 255566 | 2020-06-19 | Gilmer | West Virginia | 54021 | 10 | 0 |
258693 | 258693 | 2020-06-20 | Gilmer | West Virginia | 54021 | 10 | 0 |
261820 | 261820 | 2020-06-21 | Gilmer | West Virginia | 54021 | 10 | 0 |
264949 | 264949 | 2020-06-22 | Gilmer | West Virginia | 54021 | 10 | 0 |
268078 | 268078 | 2020-06-23 | Gilmer | West Virginia | 54021 | 10 | 0 |
271212 | 271212 | 2020-06-24 | Gilmer | West Virginia | 54021 | 10 | 0 |
274352 | 274352 | 2020-06-25 | Gilmer | West Virginia | 54021 | 11 | 0 |
277500 | 277500 | 2020-06-26 | Gilmer | West Virginia | 54021 | 12 | 0 |
280648 | 280648 | 2020-06-27 | Gilmer | West Virginia | 54021 | 12 | 0 |
283794 | 283794 | 2020-06-28 | Gilmer | West Virginia | 54021 | 12 | 0 |
286940 | 286940 | 2020-06-29 | Gilmer | West Virginia | 54021 | 12 | 0 |
290090 | 290090 | 2020-06-30 | Gilmer | West Virginia | 54021 | 13 | 0 |
293243 | 293243 | 2020-07-01 | Gilmer | West Virginia | 54021 | 13 | 0 |
296398 | 296398 | 2020-07-02 | Gilmer | West Virginia | 54021 | 13 | 0 |
299560 | 299560 | 2020-07-03 | Gilmer | West Virginia | 54021 | 13 | 0 |
302724 | 302724 | 2020-07-04 | Gilmer | West Virginia | 54021 | 13 | 0 |
305888 | 305888 | 2020-07-05 | Gilmer | West Virginia | 54021 | 13 | 0 |
309056 | 309056 | 2020-07-06 | Gilmer | West Virginia | 54021 | 13 | 0 |
312225 | 312225 | 2020-07-07 | Gilmer | West Virginia | 54021 | 13 | 0 |
315400 | 315400 | 2020-07-08 | Gilmer | West Virginia | 54021 | 13 | 0 |
318573 | 318573 | 2020-07-09 | Gilmer | West Virginia | 54021 | 13 | 0 |
321752 | 321752 | 2020-07-10 | Gilmer | West Virginia | 54021 | 13 | 0 |
324933 | 324933 | 2020-07-11 | Gilmer | West Virginia | 54021 | 13 | 0 |
328119 | 328119 | 2020-07-12 | Gilmer | West Virginia | 54021 | 13 | 0 |
331305 | 331305 | 2020-07-13 | Gilmer | West Virginia | 54021 | 13 | 0 |
334498 | 334498 | 2020-07-14 | Gilmer | West Virginia | 54021 | 13 | 0 |
337693 | 337693 | 2020-07-15 | Gilmer | West Virginia | 54021 | 13 | 0 |
340889 | 340889 | 2020-07-16 | Gilmer | West Virginia | 54021 | 13 | 0 |
344088 | 344088 | 2020-07-17 | Gilmer | West Virginia | 54021 | 13 | 0 |
347288 | 347288 | 2020-07-18 | Gilmer | West Virginia | 54021 | 13 | 0 |
350489 | 350489 | 2020-07-19 | Gilmer | West Virginia | 54021 | 13 | 0 |
353691 | 353691 | 2020-07-20 | Gilmer | West Virginia | 54021 | 13 | 0 |
356894 | 356894 | 2020-07-21 | Gilmer | West Virginia | 54021 | 13 | 0 |
360099 | 360099 | 2020-07-22 | Gilmer | West Virginia | 54021 | 13 | 0 |
363305 | 363305 | 2020-07-23 | Gilmer | West Virginia | 54021 | 13 | 0 |
366512 | 366512 | 2020-07-24 | Gilmer | West Virginia | 54021 | 14 | 0 |
369722 | 369722 | 2020-07-25 | Gilmer | West Virginia | 54021 | 14 | 0 |
372934 | 372934 | 2020-07-26 | Gilmer | West Virginia | 54021 | 14 | 0 |
376148 | 376148 | 2020-07-27 | Gilmer | West Virginia | 54021 | 14 | 0 |
379364 | 379364 | 2020-07-28 | Gilmer | West Virginia | 54021 | 14 | 0 |
382581 | 382581 | 2020-07-29 | Gilmer | West Virginia | 54021 | 14 | 0 |
385799 | 385799 | 2020-07-30 | Gilmer | West Virginia | 54021 | 16 | 0 |
389016 | 389016 | 2020-07-31 | Gilmer | West Virginia | 54021 | 16 | 0 |
392233 | 392233 | 2020-08-01 | Gilmer | West Virginia | 54021 | 16 | 0 |
395449 | 395449 | 2020-08-02 | Gilmer | West Virginia | 54021 | 16 | 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);