ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Mineral" and state = "West Virginia" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
30666 | 30666 | 2020-04-03 | Mineral | West Virginia | 54057 | 2 | 0 |
33067 | 33067 | 2020-04-04 | Mineral | West Virginia | 54057 | 2 | 0 |
35505 | 35505 | 2020-04-05 | Mineral | West Virginia | 54057 | 2 | 0 |
37990 | 37990 | 2020-04-06 | Mineral | West Virginia | 54057 | 2 | 0 |
40528 | 40528 | 2020-04-07 | Mineral | West Virginia | 54057 | 3 | 0 |
43100 | 43100 | 2020-04-08 | Mineral | West Virginia | 54057 | 3 | 0 |
45696 | 45696 | 2020-04-09 | Mineral | West Virginia | 54057 | 3 | 0 |
48324 | 48324 | 2020-04-10 | Mineral | West Virginia | 54057 | 3 | 0 |
50982 | 50982 | 2020-04-11 | Mineral | West Virginia | 54057 | 4 | 0 |
53658 | 53658 | 2020-04-12 | Mineral | West Virginia | 54057 | 4 | 0 |
56348 | 56348 | 2020-04-13 | Mineral | West Virginia | 54057 | 5 | 0 |
59055 | 59055 | 2020-04-14 | Mineral | West Virginia | 54057 | 5 | 0 |
61774 | 61774 | 2020-04-15 | Mineral | West Virginia | 54057 | 6 | 0 |
64507 | 64507 | 2020-04-16 | Mineral | West Virginia | 54057 | 7 | 0 |
67255 | 67255 | 2020-04-17 | Mineral | West Virginia | 54057 | 8 | 0 |
70017 | 70017 | 2020-04-18 | Mineral | West Virginia | 54057 | 8 | 0 |
72786 | 72786 | 2020-04-19 | Mineral | West Virginia | 54057 | 8 | 0 |
75562 | 75562 | 2020-04-20 | Mineral | West Virginia | 54057 | 9 | 0 |
78345 | 78345 | 2020-04-21 | Mineral | West Virginia | 54057 | 10 | 0 |
81138 | 81138 | 2020-04-22 | Mineral | West Virginia | 54057 | 10 | 0 |
83939 | 83939 | 2020-04-23 | Mineral | West Virginia | 54057 | 11 | 0 |
86746 | 86746 | 2020-04-24 | Mineral | West Virginia | 54057 | 12 | 0 |
89562 | 89562 | 2020-04-25 | Mineral | West Virginia | 54057 | 12 | 0 |
92380 | 92380 | 2020-04-26 | Mineral | West Virginia | 54057 | 15 | 0 |
95209 | 95209 | 2020-04-27 | Mineral | West Virginia | 54057 | 14 | 0 |
98054 | 98054 | 2020-04-28 | Mineral | West Virginia | 54057 | 15 | 0 |
100904 | 100904 | 2020-04-29 | Mineral | West Virginia | 54057 | 15 | 0 |
103759 | 103759 | 2020-04-30 | Mineral | West Virginia | 54057 | 17 | 0 |
106623 | 106623 | 2020-05-01 | Mineral | West Virginia | 54057 | 18 | 0 |
109492 | 109492 | 2020-05-02 | Mineral | West Virginia | 54057 | 18 | 0 |
112366 | 112366 | 2020-05-03 | Mineral | West Virginia | 54057 | 18 | 0 |
115249 | 115249 | 2020-05-04 | Mineral | West Virginia | 54057 | 18 | 0 |
118208 | 118208 | 2020-05-05 | Mineral | West Virginia | 54057 | 18 | 0 |
121173 | 121173 | 2020-05-06 | Mineral | West Virginia | 54057 | 20 | 0 |
124153 | 124153 | 2020-05-07 | Mineral | West Virginia | 54057 | 20 | 0 |
127138 | 127138 | 2020-05-08 | Mineral | West Virginia | 54057 | 20 | 0 |
130128 | 130128 | 2020-05-09 | Mineral | West Virginia | 54057 | 20 | 0 |
133118 | 133118 | 2020-05-10 | Mineral | West Virginia | 54057 | 23 | 0 |
136108 | 136108 | 2020-05-11 | Mineral | West Virginia | 54057 | 22 | 0 |
139099 | 139099 | 2020-05-12 | Mineral | West Virginia | 54057 | 23 | 0 |
142095 | 142095 | 2020-05-13 | Mineral | West Virginia | 54057 | 26 | 0 |
145092 | 145092 | 2020-05-14 | Mineral | West Virginia | 54057 | 26 | 0 |
148095 | 148095 | 2020-05-15 | Mineral | West Virginia | 54057 | 26 | 0 |
151104 | 151104 | 2020-05-16 | Mineral | West Virginia | 54057 | 27 | 0 |
154115 | 154115 | 2020-05-17 | Mineral | West Virginia | 54057 | 28 | 0 |
157132 | 157132 | 2020-05-18 | Mineral | West Virginia | 54057 | 29 | 0 |
160156 | 160156 | 2020-05-19 | Mineral | West Virginia | 54057 | 29 | 0 |
163184 | 163184 | 2020-05-20 | Mineral | West Virginia | 54057 | 34 | 0 |
166213 | 166213 | 2020-05-21 | Mineral | West Virginia | 54057 | 35 | 0 |
169249 | 169249 | 2020-05-22 | Mineral | West Virginia | 54057 | 38 | 0 |
172290 | 172290 | 2020-05-23 | Mineral | West Virginia | 54057 | 38 | 0 |
175333 | 175333 | 2020-05-24 | Mineral | West Virginia | 54057 | 38 | 0 |
178378 | 178378 | 2020-05-25 | Mineral | West Virginia | 54057 | 38 | 1 |
181422 | 181422 | 2020-05-26 | Mineral | West Virginia | 54057 | 40 | 1 |
184473 | 184473 | 2020-05-27 | Mineral | West Virginia | 54057 | 41 | 1 |
187530 | 187530 | 2020-05-28 | Mineral | West Virginia | 54057 | 44 | 1 |
190594 | 190594 | 2020-05-29 | Mineral | West Virginia | 54057 | 44 | 1 |
193660 | 193660 | 2020-05-30 | Mineral | West Virginia | 54057 | 44 | 1 |
196730 | 196730 | 2020-05-31 | Mineral | West Virginia | 54057 | 46 | 1 |
199803 | 199803 | 2020-06-01 | Mineral | West Virginia | 54057 | 47 | 1 |
202879 | 202879 | 2020-06-02 | Mineral | West Virginia | 54057 | 47 | 1 |
205958 | 205958 | 2020-06-03 | Mineral | West Virginia | 54057 | 47 | 1 |
209040 | 209040 | 2020-06-04 | Mineral | West Virginia | 54057 | 48 | 1 |
212125 | 212125 | 2020-06-05 | Mineral | West Virginia | 54057 | 50 | 1 |
215212 | 215212 | 2020-06-06 | Mineral | West Virginia | 54057 | 51 | 1 |
218302 | 218302 | 2020-06-07 | Mineral | West Virginia | 54057 | 50 | 1 |
221394 | 221394 | 2020-06-08 | Mineral | West Virginia | 54057 | 50 | 1 |
224490 | 224490 | 2020-06-09 | Mineral | West Virginia | 54057 | 51 | 1 |
227590 | 227590 | 2020-06-10 | Mineral | West Virginia | 54057 | 51 | 1 |
230694 | 230694 | 2020-06-11 | Mineral | West Virginia | 54057 | 51 | 2 |
233799 | 233799 | 2020-06-12 | Mineral | West Virginia | 54057 | 51 | 2 |
236906 | 236906 | 2020-06-13 | Mineral | West Virginia | 54057 | 51 | 2 |
240014 | 240014 | 2020-06-14 | Mineral | West Virginia | 54057 | 51 | 2 |
243125 | 243125 | 2020-06-15 | Mineral | West Virginia | 54057 | 51 | 2 |
246238 | 246238 | 2020-06-16 | Mineral | West Virginia | 54057 | 51 | 2 |
249350 | 249350 | 2020-06-17 | Mineral | West Virginia | 54057 | 52 | 2 |
252465 | 252465 | 2020-06-18 | Mineral | West Virginia | 54057 | 52 | 2 |
255584 | 255584 | 2020-06-19 | Mineral | West Virginia | 54057 | 53 | 2 |
258711 | 258711 | 2020-06-20 | Mineral | West Virginia | 54057 | 53 | 2 |
261838 | 261838 | 2020-06-21 | Mineral | West Virginia | 54057 | 53 | 2 |
264967 | 264967 | 2020-06-22 | Mineral | West Virginia | 54057 | 53 | 3 |
268096 | 268096 | 2020-06-23 | Mineral | West Virginia | 54057 | 54 | 3 |
271230 | 271230 | 2020-06-24 | Mineral | West Virginia | 54057 | 54 | 3 |
274370 | 274370 | 2020-06-25 | Mineral | West Virginia | 54057 | 54 | 3 |
277518 | 277518 | 2020-06-26 | Mineral | West Virginia | 54057 | 54 | 3 |
280666 | 280666 | 2020-06-27 | Mineral | West Virginia | 54057 | 55 | 3 |
283812 | 283812 | 2020-06-28 | Mineral | West Virginia | 54057 | 55 | 3 |
286958 | 286958 | 2020-06-29 | Mineral | West Virginia | 54057 | 56 | 3 |
290108 | 290108 | 2020-06-30 | Mineral | West Virginia | 54057 | 56 | 3 |
293261 | 293261 | 2020-07-01 | Mineral | West Virginia | 54057 | 57 | 3 |
296416 | 296416 | 2020-07-02 | Mineral | West Virginia | 54057 | 57 | 3 |
299578 | 299578 | 2020-07-03 | Mineral | West Virginia | 54057 | 57 | 3 |
302742 | 302742 | 2020-07-04 | Mineral | West Virginia | 54057 | 57 | 3 |
305906 | 305906 | 2020-07-05 | Mineral | West Virginia | 54057 | 58 | 3 |
309074 | 309074 | 2020-07-06 | Mineral | West Virginia | 54057 | 58 | 3 |
312243 | 312243 | 2020-07-07 | Mineral | West Virginia | 54057 | 58 | 3 |
315418 | 315418 | 2020-07-08 | Mineral | West Virginia | 54057 | 61 | 3 |
318591 | 318591 | 2020-07-09 | Mineral | West Virginia | 54057 | 62 | 3 |
321770 | 321770 | 2020-07-10 | Mineral | West Virginia | 54057 | 64 | 3 |
324951 | 324951 | 2020-07-11 | Mineral | West Virginia | 54057 | 65 | 3 |
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);