ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 54071 and state = "West Virginia" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
28316 | 28316 | 2020-04-02 | Pendleton | West Virginia | 54071 | 1 | 0 |
30670 | 30670 | 2020-04-03 | Pendleton | West Virginia | 54071 | 1 | 0 |
33071 | 33071 | 2020-04-04 | Pendleton | West Virginia | 54071 | 1 | 0 |
35509 | 35509 | 2020-04-05 | Pendleton | West Virginia | 54071 | 1 | 0 |
37994 | 37994 | 2020-04-06 | Pendleton | West Virginia | 54071 | 1 | 0 |
40533 | 40533 | 2020-04-07 | Pendleton | West Virginia | 54071 | 1 | 0 |
43105 | 43105 | 2020-04-08 | Pendleton | West Virginia | 54071 | 1 | 0 |
45701 | 45701 | 2020-04-09 | Pendleton | West Virginia | 54071 | 1 | 0 |
48329 | 48329 | 2020-04-10 | Pendleton | West Virginia | 54071 | 1 | 0 |
50988 | 50988 | 2020-04-11 | Pendleton | West Virginia | 54071 | 1 | 0 |
53665 | 53665 | 2020-04-12 | Pendleton | West Virginia | 54071 | 1 | 0 |
56355 | 56355 | 2020-04-13 | Pendleton | West Virginia | 54071 | 1 | 0 |
59062 | 59062 | 2020-04-14 | Pendleton | West Virginia | 54071 | 1 | 0 |
61781 | 61781 | 2020-04-15 | Pendleton | West Virginia | 54071 | 1 | 0 |
64514 | 64514 | 2020-04-16 | Pendleton | West Virginia | 54071 | 1 | 0 |
67262 | 67262 | 2020-04-17 | Pendleton | West Virginia | 54071 | 2 | 0 |
70024 | 70024 | 2020-04-18 | Pendleton | West Virginia | 54071 | 2 | 0 |
72793 | 72793 | 2020-04-19 | Pendleton | West Virginia | 54071 | 2 | 0 |
75569 | 75569 | 2020-04-20 | Pendleton | West Virginia | 54071 | 2 | 0 |
78352 | 78352 | 2020-04-21 | Pendleton | West Virginia | 54071 | 1 | 0 |
81145 | 81145 | 2020-04-22 | Pendleton | West Virginia | 54071 | 1 | 0 |
83946 | 83946 | 2020-04-23 | Pendleton | West Virginia | 54071 | 3 | 0 |
86753 | 86753 | 2020-04-24 | Pendleton | West Virginia | 54071 | 3 | 0 |
89569 | 89569 | 2020-04-25 | Pendleton | West Virginia | 54071 | 3 | 0 |
92387 | 92387 | 2020-04-26 | Pendleton | West Virginia | 54071 | 3 | 0 |
95216 | 95216 | 2020-04-27 | Pendleton | West Virginia | 54071 | 3 | 0 |
98061 | 98061 | 2020-04-28 | Pendleton | West Virginia | 54071 | 3 | 0 |
100911 | 100911 | 2020-04-29 | Pendleton | West Virginia | 54071 | 3 | 0 |
103766 | 103766 | 2020-04-30 | Pendleton | West Virginia | 54071 | 3 | 0 |
106630 | 106630 | 2020-05-01 | Pendleton | West Virginia | 54071 | 3 | 0 |
109499 | 109499 | 2020-05-02 | Pendleton | West Virginia | 54071 | 3 | 0 |
112373 | 112373 | 2020-05-03 | Pendleton | West Virginia | 54071 | 3 | 0 |
115256 | 115256 | 2020-05-04 | Pendleton | West Virginia | 54071 | 3 | 0 |
118215 | 118215 | 2020-05-05 | Pendleton | West Virginia | 54071 | 5 | 0 |
121180 | 121180 | 2020-05-06 | Pendleton | West Virginia | 54071 | 5 | 0 |
124160 | 124160 | 2020-05-07 | Pendleton | West Virginia | 54071 | 5 | 0 |
127145 | 127145 | 2020-05-08 | Pendleton | West Virginia | 54071 | 5 | 0 |
130135 | 130135 | 2020-05-09 | Pendleton | West Virginia | 54071 | 5 | 0 |
133125 | 133125 | 2020-05-10 | Pendleton | West Virginia | 54071 | 5 | 0 |
136115 | 136115 | 2020-05-11 | Pendleton | West Virginia | 54071 | 5 | 0 |
139106 | 139106 | 2020-05-12 | Pendleton | West Virginia | 54071 | 5 | 0 |
142102 | 142102 | 2020-05-13 | Pendleton | West Virginia | 54071 | 5 | 0 |
145099 | 145099 | 2020-05-14 | Pendleton | West Virginia | 54071 | 5 | 0 |
148102 | 148102 | 2020-05-15 | Pendleton | West Virginia | 54071 | 5 | 0 |
151111 | 151111 | 2020-05-16 | Pendleton | West Virginia | 54071 | 5 | 0 |
154122 | 154122 | 2020-05-17 | Pendleton | West Virginia | 54071 | 5 | 0 |
157139 | 157139 | 2020-05-18 | Pendleton | West Virginia | 54071 | 5 | 0 |
160163 | 160163 | 2020-05-19 | Pendleton | West Virginia | 54071 | 5 | 0 |
163191 | 163191 | 2020-05-20 | Pendleton | West Virginia | 54071 | 5 | 0 |
166220 | 166220 | 2020-05-21 | Pendleton | West Virginia | 54071 | 5 | 0 |
169256 | 169256 | 2020-05-22 | Pendleton | West Virginia | 54071 | 7 | 0 |
172297 | 172297 | 2020-05-23 | Pendleton | West Virginia | 54071 | 9 | 0 |
175340 | 175340 | 2020-05-24 | Pendleton | West Virginia | 54071 | 9 | 0 |
178385 | 178385 | 2020-05-25 | Pendleton | West Virginia | 54071 | 9 | 0 |
181429 | 181429 | 2020-05-26 | Pendleton | West Virginia | 54071 | 9 | 0 |
184480 | 184480 | 2020-05-27 | Pendleton | West Virginia | 54071 | 10 | 0 |
187537 | 187537 | 2020-05-28 | Pendleton | West Virginia | 54071 | 11 | 0 |
190601 | 190601 | 2020-05-29 | Pendleton | West Virginia | 54071 | 12 | 0 |
193667 | 193667 | 2020-05-30 | Pendleton | West Virginia | 54071 | 12 | 0 |
196737 | 196737 | 2020-05-31 | Pendleton | West Virginia | 54071 | 12 | 0 |
199810 | 199810 | 2020-06-01 | Pendleton | West Virginia | 54071 | 13 | 0 |
202886 | 202886 | 2020-06-02 | Pendleton | West Virginia | 54071 | 13 | 0 |
205965 | 205965 | 2020-06-03 | Pendleton | West Virginia | 54071 | 13 | 0 |
209047 | 209047 | 2020-06-04 | Pendleton | West Virginia | 54071 | 13 | 0 |
212132 | 212132 | 2020-06-05 | Pendleton | West Virginia | 54071 | 13 | 1 |
215219 | 215219 | 2020-06-06 | Pendleton | West Virginia | 54071 | 13 | 1 |
218309 | 218309 | 2020-06-07 | Pendleton | West Virginia | 54071 | 13 | 1 |
221401 | 221401 | 2020-06-08 | Pendleton | West Virginia | 54071 | 13 | 1 |
224497 | 224497 | 2020-06-09 | Pendleton | West Virginia | 54071 | 13 | 1 |
227597 | 227597 | 2020-06-10 | Pendleton | West Virginia | 54071 | 13 | 1 |
230701 | 230701 | 2020-06-11 | Pendleton | West Virginia | 54071 | 13 | 1 |
233806 | 233806 | 2020-06-12 | Pendleton | West Virginia | 54071 | 13 | 1 |
236913 | 236913 | 2020-06-13 | Pendleton | West Virginia | 54071 | 13 | 1 |
240021 | 240021 | 2020-06-14 | Pendleton | West Virginia | 54071 | 13 | 1 |
243132 | 243132 | 2020-06-15 | Pendleton | West Virginia | 54071 | 13 | 1 |
246245 | 246245 | 2020-06-16 | Pendleton | West Virginia | 54071 | 13 | 1 |
249357 | 249357 | 2020-06-17 | Pendleton | West Virginia | 54071 | 13 | 1 |
252472 | 252472 | 2020-06-18 | Pendleton | West Virginia | 54071 | 13 | 1 |
255591 | 255591 | 2020-06-19 | Pendleton | West Virginia | 54071 | 13 | 1 |
258718 | 258718 | 2020-06-20 | Pendleton | West Virginia | 54071 | 13 | 1 |
261845 | 261845 | 2020-06-21 | Pendleton | West Virginia | 54071 | 13 | 1 |
264974 | 264974 | 2020-06-22 | Pendleton | West Virginia | 54071 | 13 | 1 |
268103 | 268103 | 2020-06-23 | Pendleton | West Virginia | 54071 | 13 | 1 |
271237 | 271237 | 2020-06-24 | Pendleton | West Virginia | 54071 | 13 | 1 |
274377 | 274377 | 2020-06-25 | Pendleton | West Virginia | 54071 | 13 | 1 |
277525 | 277525 | 2020-06-26 | Pendleton | West Virginia | 54071 | 13 | 1 |
280673 | 280673 | 2020-06-27 | Pendleton | West Virginia | 54071 | 13 | 1 |
283819 | 283819 | 2020-06-28 | Pendleton | West Virginia | 54071 | 13 | 1 |
286965 | 286965 | 2020-06-29 | Pendleton | West Virginia | 54071 | 13 | 1 |
290115 | 290115 | 2020-06-30 | Pendleton | West Virginia | 54071 | 13 | 1 |
293268 | 293268 | 2020-07-01 | Pendleton | West Virginia | 54071 | 13 | 1 |
296423 | 296423 | 2020-07-02 | Pendleton | West Virginia | 54071 | 13 | 1 |
299585 | 299585 | 2020-07-03 | Pendleton | West Virginia | 54071 | 13 | 1 |
302749 | 302749 | 2020-07-04 | Pendleton | West Virginia | 54071 | 13 | 1 |
305913 | 305913 | 2020-07-05 | Pendleton | West Virginia | 54071 | 14 | 1 |
309081 | 309081 | 2020-07-06 | Pendleton | West Virginia | 54071 | 14 | 1 |
312250 | 312250 | 2020-07-07 | Pendleton | West Virginia | 54071 | 14 | 1 |
315425 | 315425 | 2020-07-08 | Pendleton | West Virginia | 54071 | 14 | 1 |
318598 | 318598 | 2020-07-09 | Pendleton | West Virginia | 54071 | 14 | 1 |
321777 | 321777 | 2020-07-10 | Pendleton | West Virginia | 54071 | 16 | 1 |
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);