ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where fips = 54005 and state = "West Virginia" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
43080 | 43080 | 2020-04-08 | Boone | West Virginia | 54005 | 1 | 0 |
45676 | 45676 | 2020-04-09 | Boone | West Virginia | 54005 | 1 | 0 |
48304 | 48304 | 2020-04-10 | Boone | West Virginia | 54005 | 1 | 0 |
50962 | 50962 | 2020-04-11 | Boone | West Virginia | 54005 | 1 | 0 |
53637 | 53637 | 2020-04-12 | Boone | West Virginia | 54005 | 1 | 0 |
56327 | 56327 | 2020-04-13 | Boone | West Virginia | 54005 | 1 | 0 |
59033 | 59033 | 2020-04-14 | Boone | West Virginia | 54005 | 1 | 0 |
61752 | 61752 | 2020-04-15 | Boone | West Virginia | 54005 | 1 | 0 |
64485 | 64485 | 2020-04-16 | Boone | West Virginia | 54005 | 2 | 0 |
67233 | 67233 | 2020-04-17 | Boone | West Virginia | 54005 | 2 | 0 |
69995 | 69995 | 2020-04-18 | Boone | West Virginia | 54005 | 2 | 0 |
72764 | 72764 | 2020-04-19 | Boone | West Virginia | 54005 | 2 | 0 |
75540 | 75540 | 2020-04-20 | Boone | West Virginia | 54005 | 2 | 0 |
78323 | 78323 | 2020-04-21 | Boone | West Virginia | 54005 | 2 | 0 |
81116 | 81116 | 2020-04-22 | Boone | West Virginia | 54005 | 2 | 0 |
83917 | 83917 | 2020-04-23 | Boone | West Virginia | 54005 | 2 | 0 |
86724 | 86724 | 2020-04-24 | Boone | West Virginia | 54005 | 2 | 0 |
89539 | 89539 | 2020-04-25 | Boone | West Virginia | 54005 | 2 | 0 |
92356 | 92356 | 2020-04-26 | Boone | West Virginia | 54005 | 2 | 0 |
95185 | 95185 | 2020-04-27 | Boone | West Virginia | 54005 | 2 | 0 |
98030 | 98030 | 2020-04-28 | Boone | West Virginia | 54005 | 2 | 0 |
100880 | 100880 | 2020-04-29 | Boone | West Virginia | 54005 | 3 | 0 |
103735 | 103735 | 2020-04-30 | Boone | West Virginia | 54005 | 3 | 0 |
106599 | 106599 | 2020-05-01 | Boone | West Virginia | 54005 | 6 | 0 |
109468 | 109468 | 2020-05-02 | Boone | West Virginia | 54005 | 6 | 0 |
112342 | 112342 | 2020-05-03 | Boone | West Virginia | 54005 | 6 | 0 |
115225 | 115225 | 2020-05-04 | Boone | West Virginia | 54005 | 6 | 0 |
118184 | 118184 | 2020-05-05 | Boone | West Virginia | 54005 | 6 | 0 |
121148 | 121148 | 2020-05-06 | Boone | West Virginia | 54005 | 6 | 0 |
124128 | 124128 | 2020-05-07 | Boone | West Virginia | 54005 | 6 | 0 |
127113 | 127113 | 2020-05-08 | Boone | West Virginia | 54005 | 8 | 0 |
130103 | 130103 | 2020-05-09 | Boone | West Virginia | 54005 | 8 | 0 |
133093 | 133093 | 2020-05-10 | Boone | West Virginia | 54005 | 9 | 0 |
136083 | 136083 | 2020-05-11 | Boone | West Virginia | 54005 | 9 | 0 |
139074 | 139074 | 2020-05-12 | Boone | West Virginia | 54005 | 9 | 0 |
142070 | 142070 | 2020-05-13 | Boone | West Virginia | 54005 | 9 | 0 |
145067 | 145067 | 2020-05-14 | Boone | West Virginia | 54005 | 9 | 0 |
148070 | 148070 | 2020-05-15 | Boone | West Virginia | 54005 | 9 | 0 |
151079 | 151079 | 2020-05-16 | Boone | West Virginia | 54005 | 9 | 0 |
154090 | 154090 | 2020-05-17 | Boone | West Virginia | 54005 | 9 | 0 |
157107 | 157107 | 2020-05-18 | Boone | West Virginia | 54005 | 9 | 0 |
160131 | 160131 | 2020-05-19 | Boone | West Virginia | 54005 | 9 | 0 |
163159 | 163159 | 2020-05-20 | Boone | West Virginia | 54005 | 9 | 0 |
166188 | 166188 | 2020-05-21 | Boone | West Virginia | 54005 | 9 | 0 |
169224 | 169224 | 2020-05-22 | Boone | West Virginia | 54005 | 9 | 0 |
172265 | 172265 | 2020-05-23 | Boone | West Virginia | 54005 | 9 | 0 |
175308 | 175308 | 2020-05-24 | Boone | West Virginia | 54005 | 9 | 0 |
178353 | 178353 | 2020-05-25 | Boone | West Virginia | 54005 | 9 | 0 |
181397 | 181397 | 2020-05-26 | Boone | West Virginia | 54005 | 9 | 0 |
184448 | 184448 | 2020-05-27 | Boone | West Virginia | 54005 | 9 | 0 |
187505 | 187505 | 2020-05-28 | Boone | West Virginia | 54005 | 10 | 0 |
190569 | 190569 | 2020-05-29 | Boone | West Virginia | 54005 | 9 | 0 |
193635 | 193635 | 2020-05-30 | Boone | West Virginia | 54005 | 9 | 0 |
196705 | 196705 | 2020-05-31 | Boone | West Virginia | 54005 | 9 | 0 |
199778 | 199778 | 2020-06-01 | Boone | West Virginia | 54005 | 9 | 0 |
202854 | 202854 | 2020-06-02 | Boone | West Virginia | 54005 | 9 | 0 |
205933 | 205933 | 2020-06-03 | Boone | West Virginia | 54005 | 9 | 0 |
209015 | 209015 | 2020-06-04 | Boone | West Virginia | 54005 | 11 | 0 |
212100 | 212100 | 2020-06-05 | Boone | West Virginia | 54005 | 11 | 0 |
215187 | 215187 | 2020-06-06 | Boone | West Virginia | 54005 | 11 | 0 |
218277 | 218277 | 2020-06-07 | Boone | West Virginia | 54005 | 15 | 0 |
221369 | 221369 | 2020-06-08 | Boone | West Virginia | 54005 | 15 | 0 |
224465 | 224465 | 2020-06-09 | Boone | West Virginia | 54005 | 16 | 0 |
227565 | 227565 | 2020-06-10 | Boone | West Virginia | 54005 | 15 | 0 |
230669 | 230669 | 2020-06-11 | Boone | West Virginia | 54005 | 17 | 0 |
233774 | 233774 | 2020-06-12 | Boone | West Virginia | 54005 | 17 | 0 |
236881 | 236881 | 2020-06-13 | Boone | West Virginia | 54005 | 17 | 0 |
239989 | 239989 | 2020-06-14 | Boone | West Virginia | 54005 | 17 | 0 |
243100 | 243100 | 2020-06-15 | Boone | West Virginia | 54005 | 18 | 0 |
246213 | 246213 | 2020-06-16 | Boone | West Virginia | 54005 | 19 | 0 |
249325 | 249325 | 2020-06-17 | Boone | West Virginia | 54005 | 20 | 0 |
252440 | 252440 | 2020-06-18 | Boone | West Virginia | 54005 | 20 | 0 |
255559 | 255559 | 2020-06-19 | Boone | West Virginia | 54005 | 20 | 0 |
258686 | 258686 | 2020-06-20 | Boone | West Virginia | 54005 | 20 | 0 |
261813 | 261813 | 2020-06-21 | Boone | West Virginia | 54005 | 20 | 0 |
264942 | 264942 | 2020-06-22 | Boone | West Virginia | 54005 | 19 | 0 |
268071 | 268071 | 2020-06-23 | Boone | West Virginia | 54005 | 19 | 0 |
271205 | 271205 | 2020-06-24 | Boone | West Virginia | 54005 | 19 | 0 |
274345 | 274345 | 2020-06-25 | Boone | West Virginia | 54005 | 19 | 0 |
277493 | 277493 | 2020-06-26 | Boone | West Virginia | 54005 | 20 | 0 |
280641 | 280641 | 2020-06-27 | Boone | West Virginia | 54005 | 20 | 0 |
283787 | 283787 | 2020-06-28 | Boone | West Virginia | 54005 | 20 | 0 |
286933 | 286933 | 2020-06-29 | Boone | West Virginia | 54005 | 20 | 0 |
290083 | 290083 | 2020-06-30 | Boone | West Virginia | 54005 | 21 | 0 |
293236 | 293236 | 2020-07-01 | Boone | West Virginia | 54005 | 21 | 0 |
296391 | 296391 | 2020-07-02 | Boone | West Virginia | 54005 | 20 | 0 |
299553 | 299553 | 2020-07-03 | Boone | West Virginia | 54005 | 23 | 0 |
302717 | 302717 | 2020-07-04 | Boone | West Virginia | 54005 | 23 | 0 |
305881 | 305881 | 2020-07-05 | Boone | West Virginia | 54005 | 23 | 0 |
309049 | 309049 | 2020-07-06 | Boone | West Virginia | 54005 | 24 | 0 |
312218 | 312218 | 2020-07-07 | Boone | West Virginia | 54005 | 28 | 0 |
315393 | 315393 | 2020-07-08 | Boone | West Virginia | 54005 | 27 | 0 |
318566 | 318566 | 2020-07-09 | Boone | West Virginia | 54005 | 29 | 0 |
321745 | 321745 | 2020-07-10 | Boone | West Virginia | 54005 | 31 | 0 |
324926 | 324926 | 2020-07-11 | Boone | West Virginia | 54005 | 33 | 0 |
328112 | 328112 | 2020-07-12 | Boone | West Virginia | 54005 | 33 | 0 |
331298 | 331298 | 2020-07-13 | Boone | West Virginia | 54005 | 34 | 0 |
334491 | 334491 | 2020-07-14 | Boone | West Virginia | 54005 | 38 | 0 |
337686 | 337686 | 2020-07-15 | Boone | West Virginia | 54005 | 46 | 0 |
340882 | 340882 | 2020-07-16 | Boone | West Virginia | 54005 | 50 | 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);