ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 54025 and state = "West Virginia" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
15729 | 15729 | 2020-03-27 | Greenbrier | West Virginia | 54025 | 1 | 0 |
17609 | 17609 | 2020-03-28 | Greenbrier | West Virginia | 54025 | 2 | 0 |
19575 | 19575 | 2020-03-29 | Greenbrier | West Virginia | 54025 | 2 | 0 |
21642 | 21642 | 2020-03-30 | Greenbrier | West Virginia | 54025 | 3 | 0 |
23791 | 23791 | 2020-03-31 | Greenbrier | West Virginia | 54025 | 3 | 0 |
26009 | 26009 | 2020-04-01 | Greenbrier | West Virginia | 54025 | 3 | 0 |
28301 | 28301 | 2020-04-02 | Greenbrier | West Virginia | 54025 | 3 | 0 |
30654 | 30654 | 2020-04-03 | Greenbrier | West Virginia | 54025 | 3 | 0 |
33055 | 33055 | 2020-04-04 | Greenbrier | West Virginia | 54025 | 3 | 0 |
35493 | 35493 | 2020-04-05 | Greenbrier | West Virginia | 54025 | 3 | 0 |
37977 | 37977 | 2020-04-06 | Greenbrier | West Virginia | 54025 | 3 | 0 |
40514 | 40514 | 2020-04-07 | Greenbrier | West Virginia | 54025 | 3 | 0 |
43085 | 43085 | 2020-04-08 | Greenbrier | West Virginia | 54025 | 3 | 0 |
45681 | 45681 | 2020-04-09 | Greenbrier | West Virginia | 54025 | 3 | 0 |
48309 | 48309 | 2020-04-10 | Greenbrier | West Virginia | 54025 | 3 | 0 |
50967 | 50967 | 2020-04-11 | Greenbrier | West Virginia | 54025 | 3 | 0 |
53643 | 53643 | 2020-04-12 | Greenbrier | West Virginia | 54025 | 3 | 0 |
56333 | 56333 | 2020-04-13 | Greenbrier | West Virginia | 54025 | 3 | 0 |
59039 | 59039 | 2020-04-14 | Greenbrier | West Virginia | 54025 | 3 | 0 |
61758 | 61758 | 2020-04-15 | Greenbrier | West Virginia | 54025 | 3 | 0 |
64491 | 64491 | 2020-04-16 | Greenbrier | West Virginia | 54025 | 3 | 0 |
67239 | 67239 | 2020-04-17 | Greenbrier | West Virginia | 54025 | 3 | 0 |
70001 | 70001 | 2020-04-18 | Greenbrier | West Virginia | 54025 | 3 | 0 |
72770 | 72770 | 2020-04-19 | Greenbrier | West Virginia | 54025 | 3 | 0 |
75546 | 75546 | 2020-04-20 | Greenbrier | West Virginia | 54025 | 3 | 0 |
78329 | 78329 | 2020-04-21 | Greenbrier | West Virginia | 54025 | 3 | 0 |
81122 | 81122 | 2020-04-22 | Greenbrier | West Virginia | 54025 | 3 | 0 |
83923 | 83923 | 2020-04-23 | Greenbrier | West Virginia | 54025 | 3 | 0 |
86730 | 86730 | 2020-04-24 | Greenbrier | West Virginia | 54025 | 3 | 0 |
89546 | 89546 | 2020-04-25 | Greenbrier | West Virginia | 54025 | 3 | 0 |
92364 | 92364 | 2020-04-26 | Greenbrier | West Virginia | 54025 | 3 | 0 |
95193 | 95193 | 2020-04-27 | Greenbrier | West Virginia | 54025 | 3 | 0 |
98038 | 98038 | 2020-04-28 | Greenbrier | West Virginia | 54025 | 3 | 0 |
100888 | 100888 | 2020-04-29 | Greenbrier | West Virginia | 54025 | 3 | 0 |
103743 | 103743 | 2020-04-30 | Greenbrier | West Virginia | 54025 | 3 | 0 |
106607 | 106607 | 2020-05-01 | Greenbrier | West Virginia | 54025 | 3 | 0 |
109476 | 109476 | 2020-05-02 | Greenbrier | West Virginia | 54025 | 5 | 0 |
112350 | 112350 | 2020-05-03 | Greenbrier | West Virginia | 54025 | 6 | 0 |
115233 | 115233 | 2020-05-04 | Greenbrier | West Virginia | 54025 | 7 | 0 |
118192 | 118192 | 2020-05-05 | Greenbrier | West Virginia | 54025 | 7 | 0 |
121157 | 121157 | 2020-05-06 | Greenbrier | West Virginia | 54025 | 8 | 0 |
124137 | 124137 | 2020-05-07 | Greenbrier | West Virginia | 54025 | 8 | 0 |
127122 | 127122 | 2020-05-08 | Greenbrier | West Virginia | 54025 | 8 | 0 |
130112 | 130112 | 2020-05-09 | Greenbrier | West Virginia | 54025 | 8 | 0 |
133102 | 133102 | 2020-05-10 | Greenbrier | West Virginia | 54025 | 8 | 0 |
136092 | 136092 | 2020-05-11 | Greenbrier | West Virginia | 54025 | 8 | 0 |
139083 | 139083 | 2020-05-12 | Greenbrier | West Virginia | 54025 | 8 | 0 |
142079 | 142079 | 2020-05-13 | Greenbrier | West Virginia | 54025 | 8 | 0 |
145076 | 145076 | 2020-05-14 | Greenbrier | West Virginia | 54025 | 8 | 0 |
148079 | 148079 | 2020-05-15 | Greenbrier | West Virginia | 54025 | 8 | 0 |
151088 | 151088 | 2020-05-16 | Greenbrier | West Virginia | 54025 | 8 | 0 |
154099 | 154099 | 2020-05-17 | Greenbrier | West Virginia | 54025 | 9 | 0 |
157116 | 157116 | 2020-05-18 | Greenbrier | West Virginia | 54025 | 9 | 0 |
160140 | 160140 | 2020-05-19 | Greenbrier | West Virginia | 54025 | 9 | 0 |
163168 | 163168 | 2020-05-20 | Greenbrier | West Virginia | 54025 | 9 | 0 |
166197 | 166197 | 2020-05-21 | Greenbrier | West Virginia | 54025 | 9 | 0 |
169233 | 169233 | 2020-05-22 | Greenbrier | West Virginia | 54025 | 9 | 0 |
172274 | 172274 | 2020-05-23 | Greenbrier | West Virginia | 54025 | 9 | 0 |
175317 | 175317 | 2020-05-24 | Greenbrier | West Virginia | 54025 | 9 | 0 |
178362 | 178362 | 2020-05-25 | Greenbrier | West Virginia | 54025 | 9 | 0 |
181406 | 181406 | 2020-05-26 | Greenbrier | West Virginia | 54025 | 9 | 0 |
184457 | 184457 | 2020-05-27 | Greenbrier | West Virginia | 54025 | 9 | 0 |
187514 | 187514 | 2020-05-28 | Greenbrier | West Virginia | 54025 | 9 | 0 |
190578 | 190578 | 2020-05-29 | Greenbrier | West Virginia | 54025 | 9 | 0 |
193644 | 193644 | 2020-05-30 | Greenbrier | West Virginia | 54025 | 9 | 0 |
196714 | 196714 | 2020-05-31 | Greenbrier | West Virginia | 54025 | 9 | 0 |
199787 | 199787 | 2020-06-01 | Greenbrier | West Virginia | 54025 | 9 | 0 |
202863 | 202863 | 2020-06-02 | Greenbrier | West Virginia | 54025 | 9 | 0 |
205942 | 205942 | 2020-06-03 | Greenbrier | West Virginia | 54025 | 9 | 0 |
209024 | 209024 | 2020-06-04 | Greenbrier | West Virginia | 54025 | 9 | 0 |
212109 | 212109 | 2020-06-05 | Greenbrier | West Virginia | 54025 | 9 | 0 |
215196 | 215196 | 2020-06-06 | Greenbrier | West Virginia | 54025 | 9 | 0 |
218286 | 218286 | 2020-06-07 | Greenbrier | West Virginia | 54025 | 9 | 0 |
221378 | 221378 | 2020-06-08 | Greenbrier | West Virginia | 54025 | 9 | 0 |
224474 | 224474 | 2020-06-09 | Greenbrier | West Virginia | 54025 | 9 | 0 |
227574 | 227574 | 2020-06-10 | Greenbrier | West Virginia | 54025 | 9 | 0 |
230678 | 230678 | 2020-06-11 | Greenbrier | West Virginia | 54025 | 9 | 0 |
233783 | 233783 | 2020-06-12 | Greenbrier | West Virginia | 54025 | 11 | 0 |
236890 | 236890 | 2020-06-13 | Greenbrier | West Virginia | 54025 | 13 | 0 |
239998 | 239998 | 2020-06-14 | Greenbrier | West Virginia | 54025 | 21 | 0 |
243109 | 243109 | 2020-06-15 | Greenbrier | West Virginia | 54025 | 30 | 0 |
246222 | 246222 | 2020-06-16 | Greenbrier | West Virginia | 54025 | 37 | 0 |
249334 | 249334 | 2020-06-17 | Greenbrier | West Virginia | 54025 | 37 | 0 |
252449 | 252449 | 2020-06-18 | Greenbrier | West Virginia | 54025 | 42 | 0 |
255568 | 255568 | 2020-06-19 | Greenbrier | West Virginia | 54025 | 42 | 0 |
258695 | 258695 | 2020-06-20 | Greenbrier | West Virginia | 54025 | 48 | 0 |
261822 | 261822 | 2020-06-21 | Greenbrier | West Virginia | 54025 | 50 | 0 |
264951 | 264951 | 2020-06-22 | Greenbrier | West Virginia | 54025 | 51 | 0 |
268080 | 268080 | 2020-06-23 | Greenbrier | West Virginia | 54025 | 51 | 0 |
271214 | 271214 | 2020-06-24 | Greenbrier | West Virginia | 54025 | 52 | 0 |
274354 | 274354 | 2020-06-25 | Greenbrier | West Virginia | 54025 | 57 | 0 |
277502 | 277502 | 2020-06-26 | Greenbrier | West Virginia | 54025 | 57 | 0 |
280650 | 280650 | 2020-06-27 | Greenbrier | West Virginia | 54025 | 58 | 1 |
283796 | 283796 | 2020-06-28 | Greenbrier | West Virginia | 54025 | 59 | 1 |
286942 | 286942 | 2020-06-29 | Greenbrier | West Virginia | 54025 | 58 | 1 |
290092 | 290092 | 2020-06-30 | Greenbrier | West Virginia | 54025 | 58 | 1 |
293245 | 293245 | 2020-07-01 | Greenbrier | West Virginia | 54025 | 59 | 1 |
296400 | 296400 | 2020-07-02 | Greenbrier | West Virginia | 54025 | 60 | 1 |
299562 | 299562 | 2020-07-03 | Greenbrier | West Virginia | 54025 | 60 | 1 |
302726 | 302726 | 2020-07-04 | Greenbrier | West Virginia | 54025 | 63 | 2 |
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);