ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 54087 and state = "West Virginia" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- 2020-04-27 1
- 2020-04-28 1
- …
state 1
- West Virginia · 775 ✖
fips 1
- 54087 · 775 ✖
county 1
- Roane 775
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
21661 | 21661 | 2020-03-30 | Roane | West Virginia | 54087 | 2 | 0 |
23811 | 23811 | 2020-03-31 | Roane | West Virginia | 54087 | 2 | 0 |
26029 | 26029 | 2020-04-01 | Roane | West Virginia | 54087 | 2 | 0 |
28322 | 28322 | 2020-04-02 | Roane | West Virginia | 54087 | 2 | 0 |
30676 | 30676 | 2020-04-03 | Roane | West Virginia | 54087 | 2 | 0 |
33077 | 33077 | 2020-04-04 | Roane | West Virginia | 54087 | 2 | 0 |
35515 | 35515 | 2020-04-05 | Roane | West Virginia | 54087 | 2 | 0 |
38000 | 38000 | 2020-04-06 | Roane | West Virginia | 54087 | 2 | 0 |
40539 | 40539 | 2020-04-07 | Roane | West Virginia | 54087 | 2 | 0 |
43111 | 43111 | 2020-04-08 | Roane | West Virginia | 54087 | 2 | 0 |
45707 | 45707 | 2020-04-09 | Roane | West Virginia | 54087 | 3 | 0 |
48335 | 48335 | 2020-04-10 | Roane | West Virginia | 54087 | 3 | 0 |
50994 | 50994 | 2020-04-11 | Roane | West Virginia | 54087 | 2 | 0 |
53671 | 53671 | 2020-04-12 | Roane | West Virginia | 54087 | 2 | 0 |
56361 | 56361 | 2020-04-13 | Roane | West Virginia | 54087 | 2 | 0 |
59068 | 59068 | 2020-04-14 | Roane | West Virginia | 54087 | 2 | 0 |
61787 | 61787 | 2020-04-15 | Roane | West Virginia | 54087 | 2 | 0 |
64520 | 64520 | 2020-04-16 | Roane | West Virginia | 54087 | 2 | 0 |
67268 | 67268 | 2020-04-17 | Roane | West Virginia | 54087 | 2 | 0 |
70030 | 70030 | 2020-04-18 | Roane | West Virginia | 54087 | 2 | 0 |
72799 | 72799 | 2020-04-19 | Roane | West Virginia | 54087 | 3 | 0 |
75575 | 75575 | 2020-04-20 | Roane | West Virginia | 54087 | 3 | 0 |
78358 | 78358 | 2020-04-21 | Roane | West Virginia | 54087 | 4 | 0 |
81151 | 81151 | 2020-04-22 | Roane | West Virginia | 54087 | 5 | 0 |
83952 | 83952 | 2020-04-23 | Roane | West Virginia | 54087 | 4 | 0 |
86759 | 86759 | 2020-04-24 | Roane | West Virginia | 54087 | 3 | 0 |
89575 | 89575 | 2020-04-25 | Roane | West Virginia | 54087 | 3 | 0 |
92393 | 92393 | 2020-04-26 | Roane | West Virginia | 54087 | 4 | 0 |
95223 | 95223 | 2020-04-27 | Roane | West Virginia | 54087 | 4 | 0 |
98068 | 98068 | 2020-04-28 | Roane | West Virginia | 54087 | 4 | 0 |
100918 | 100918 | 2020-04-29 | Roane | West Virginia | 54087 | 6 | 0 |
103773 | 103773 | 2020-04-30 | Roane | West Virginia | 54087 | 6 | 0 |
106637 | 106637 | 2020-05-01 | Roane | West Virginia | 54087 | 6 | 0 |
109506 | 109506 | 2020-05-02 | Roane | West Virginia | 54087 | 7 | 0 |
112381 | 112381 | 2020-05-03 | Roane | West Virginia | 54087 | 7 | 0 |
115264 | 115264 | 2020-05-04 | Roane | West Virginia | 54087 | 6 | 0 |
118223 | 118223 | 2020-05-05 | Roane | West Virginia | 54087 | 6 | 0 |
121188 | 121188 | 2020-05-06 | Roane | West Virginia | 54087 | 7 | 0 |
124168 | 124168 | 2020-05-07 | Roane | West Virginia | 54087 | 8 | 0 |
127153 | 127153 | 2020-05-08 | Roane | West Virginia | 54087 | 8 | 0 |
130143 | 130143 | 2020-05-09 | Roane | West Virginia | 54087 | 8 | 0 |
133133 | 133133 | 2020-05-10 | Roane | West Virginia | 54087 | 8 | 0 |
136123 | 136123 | 2020-05-11 | Roane | West Virginia | 54087 | 8 | 0 |
139114 | 139114 | 2020-05-12 | Roane | West Virginia | 54087 | 8 | 0 |
142110 | 142110 | 2020-05-13 | Roane | West Virginia | 54087 | 8 | 0 |
145107 | 145107 | 2020-05-14 | Roane | West Virginia | 54087 | 8 | 0 |
148110 | 148110 | 2020-05-15 | Roane | West Virginia | 54087 | 8 | 0 |
151119 | 151119 | 2020-05-16 | Roane | West Virginia | 54087 | 9 | 0 |
154130 | 154130 | 2020-05-17 | Roane | West Virginia | 54087 | 9 | 0 |
157147 | 157147 | 2020-05-18 | Roane | West Virginia | 54087 | 9 | 0 |
160171 | 160171 | 2020-05-19 | Roane | West Virginia | 54087 | 9 | 0 |
163199 | 163199 | 2020-05-20 | Roane | West Virginia | 54087 | 8 | 0 |
166228 | 166228 | 2020-05-21 | Roane | West Virginia | 54087 | 8 | 0 |
169264 | 169264 | 2020-05-22 | Roane | West Virginia | 54087 | 8 | 0 |
172305 | 172305 | 2020-05-23 | Roane | West Virginia | 54087 | 8 | 0 |
175348 | 175348 | 2020-05-24 | Roane | West Virginia | 54087 | 8 | 0 |
178393 | 178393 | 2020-05-25 | Roane | West Virginia | 54087 | 8 | 0 |
181437 | 181437 | 2020-05-26 | Roane | West Virginia | 54087 | 8 | 0 |
184488 | 184488 | 2020-05-27 | Roane | West Virginia | 54087 | 10 | 0 |
187545 | 187545 | 2020-05-28 | Roane | West Virginia | 54087 | 9 | 0 |
190609 | 190609 | 2020-05-29 | Roane | West Virginia | 54087 | 9 | 0 |
193675 | 193675 | 2020-05-30 | Roane | West Virginia | 54087 | 9 | 0 |
196745 | 196745 | 2020-05-31 | Roane | West Virginia | 54087 | 9 | 0 |
199818 | 199818 | 2020-06-01 | Roane | West Virginia | 54087 | 9 | 0 |
202894 | 202894 | 2020-06-02 | Roane | West Virginia | 54087 | 9 | 0 |
205973 | 205973 | 2020-06-03 | Roane | West Virginia | 54087 | 9 | 0 |
209055 | 209055 | 2020-06-04 | Roane | West Virginia | 54087 | 9 | 1 |
212140 | 212140 | 2020-06-05 | Roane | West Virginia | 54087 | 9 | 1 |
215227 | 215227 | 2020-06-06 | Roane | West Virginia | 54087 | 9 | 1 |
218317 | 218317 | 2020-06-07 | Roane | West Virginia | 54087 | 10 | 1 |
221409 | 221409 | 2020-06-08 | Roane | West Virginia | 54087 | 10 | 1 |
224505 | 224505 | 2020-06-09 | Roane | West Virginia | 54087 | 10 | 1 |
227605 | 227605 | 2020-06-10 | Roane | West Virginia | 54087 | 10 | 1 |
230709 | 230709 | 2020-06-11 | Roane | West Virginia | 54087 | 9 | 1 |
233814 | 233814 | 2020-06-12 | Roane | West Virginia | 54087 | 10 | 1 |
236921 | 236921 | 2020-06-13 | Roane | West Virginia | 54087 | 10 | 1 |
240029 | 240029 | 2020-06-14 | Roane | West Virginia | 54087 | 10 | 1 |
243140 | 243140 | 2020-06-15 | Roane | West Virginia | 54087 | 11 | 1 |
246253 | 246253 | 2020-06-16 | Roane | West Virginia | 54087 | 11 | 1 |
249365 | 249365 | 2020-06-17 | Roane | West Virginia | 54087 | 11 | 1 |
252480 | 252480 | 2020-06-18 | Roane | West Virginia | 54087 | 11 | 1 |
255599 | 255599 | 2020-06-19 | Roane | West Virginia | 54087 | 11 | 1 |
258726 | 258726 | 2020-06-20 | Roane | West Virginia | 54087 | 12 | 1 |
261853 | 261853 | 2020-06-21 | Roane | West Virginia | 54087 | 12 | 1 |
264982 | 264982 | 2020-06-22 | Roane | West Virginia | 54087 | 12 | 1 |
268111 | 268111 | 2020-06-23 | Roane | West Virginia | 54087 | 11 | 1 |
271245 | 271245 | 2020-06-24 | Roane | West Virginia | 54087 | 11 | 1 |
274385 | 274385 | 2020-06-25 | Roane | West Virginia | 54087 | 11 | 1 |
277533 | 277533 | 2020-06-26 | Roane | West Virginia | 54087 | 11 | 1 |
280681 | 280681 | 2020-06-27 | Roane | West Virginia | 54087 | 11 | 1 |
283827 | 283827 | 2020-06-28 | Roane | West Virginia | 54087 | 11 | 1 |
286973 | 286973 | 2020-06-29 | Roane | West Virginia | 54087 | 11 | 1 |
290123 | 290123 | 2020-06-30 | Roane | West Virginia | 54087 | 11 | 1 |
293276 | 293276 | 2020-07-01 | Roane | West Virginia | 54087 | 11 | 1 |
296431 | 296431 | 2020-07-02 | Roane | West Virginia | 54087 | 11 | 1 |
299593 | 299593 | 2020-07-03 | Roane | West Virginia | 54087 | 11 | 1 |
302757 | 302757 | 2020-07-04 | Roane | West Virginia | 54087 | 11 | 1 |
305921 | 305921 | 2020-07-05 | Roane | West Virginia | 54087 | 11 | 1 |
309089 | 309089 | 2020-07-06 | Roane | West Virginia | 54087 | 11 | 1 |
312258 | 312258 | 2020-07-07 | Roane | West Virginia | 54087 | 11 | 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);