ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 54077 and state = "West Virginia" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 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
- …
state 1
- West Virginia · 781 ✖
fips 1
- 54077 · 781 ✖
county 1
- Preston 781
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
10793 | 10793 | 2020-03-24 | Preston | West Virginia | 54077 | 1 | 0 |
12319 | 12319 | 2020-03-25 | Preston | West Virginia | 54077 | 2 | 0 |
13971 | 13971 | 2020-03-26 | Preston | West Virginia | 54077 | 1 | 0 |
15743 | 15743 | 2020-03-27 | Preston | West Virginia | 54077 | 1 | 0 |
17623 | 17623 | 2020-03-28 | Preston | West Virginia | 54077 | 1 | 0 |
19590 | 19590 | 2020-03-29 | Preston | West Virginia | 54077 | 1 | 0 |
21657 | 21657 | 2020-03-30 | Preston | West Virginia | 54077 | 2 | 0 |
23807 | 23807 | 2020-03-31 | Preston | West Virginia | 54077 | 3 | 0 |
26025 | 26025 | 2020-04-01 | Preston | West Virginia | 54077 | 3 | 0 |
28318 | 28318 | 2020-04-02 | Preston | West Virginia | 54077 | 3 | 0 |
30672 | 30672 | 2020-04-03 | Preston | West Virginia | 54077 | 4 | 0 |
33073 | 33073 | 2020-04-04 | Preston | West Virginia | 54077 | 5 | 0 |
35511 | 35511 | 2020-04-05 | Preston | West Virginia | 54077 | 5 | 0 |
37996 | 37996 | 2020-04-06 | Preston | West Virginia | 54077 | 4 | 0 |
40535 | 40535 | 2020-04-07 | Preston | West Virginia | 54077 | 6 | 0 |
43107 | 43107 | 2020-04-08 | Preston | West Virginia | 54077 | 6 | 0 |
45703 | 45703 | 2020-04-09 | Preston | West Virginia | 54077 | 6 | 0 |
48331 | 48331 | 2020-04-10 | Preston | West Virginia | 54077 | 6 | 0 |
50990 | 50990 | 2020-04-11 | Preston | West Virginia | 54077 | 6 | 0 |
53667 | 53667 | 2020-04-12 | Preston | West Virginia | 54077 | 6 | 0 |
56357 | 56357 | 2020-04-13 | Preston | West Virginia | 54077 | 6 | 0 |
59064 | 59064 | 2020-04-14 | Preston | West Virginia | 54077 | 6 | 0 |
61783 | 61783 | 2020-04-15 | Preston | West Virginia | 54077 | 6 | 0 |
64516 | 64516 | 2020-04-16 | Preston | West Virginia | 54077 | 6 | 0 |
67264 | 67264 | 2020-04-17 | Preston | West Virginia | 54077 | 6 | 0 |
70026 | 70026 | 2020-04-18 | Preston | West Virginia | 54077 | 10 | 0 |
72795 | 72795 | 2020-04-19 | Preston | West Virginia | 54077 | 10 | 0 |
75571 | 75571 | 2020-04-20 | Preston | West Virginia | 54077 | 10 | 0 |
78354 | 78354 | 2020-04-21 | Preston | West Virginia | 54077 | 12 | 0 |
81147 | 81147 | 2020-04-22 | Preston | West Virginia | 54077 | 12 | 0 |
83948 | 83948 | 2020-04-23 | Preston | West Virginia | 54077 | 12 | 0 |
86755 | 86755 | 2020-04-24 | Preston | West Virginia | 54077 | 12 | 0 |
89571 | 89571 | 2020-04-25 | Preston | West Virginia | 54077 | 12 | 0 |
92389 | 92389 | 2020-04-26 | Preston | West Virginia | 54077 | 13 | 0 |
95219 | 95219 | 2020-04-27 | Preston | West Virginia | 54077 | 13 | 0 |
98064 | 98064 | 2020-04-28 | Preston | West Virginia | 54077 | 13 | 0 |
100914 | 100914 | 2020-04-29 | Preston | West Virginia | 54077 | 13 | 0 |
103769 | 103769 | 2020-04-30 | Preston | West Virginia | 54077 | 13 | 0 |
106633 | 106633 | 2020-05-01 | Preston | West Virginia | 54077 | 13 | 0 |
109502 | 109502 | 2020-05-02 | Preston | West Virginia | 54077 | 13 | 0 |
112376 | 112376 | 2020-05-03 | Preston | West Virginia | 54077 | 13 | 0 |
115259 | 115259 | 2020-05-04 | Preston | West Virginia | 54077 | 13 | 0 |
118218 | 118218 | 2020-05-05 | Preston | West Virginia | 54077 | 13 | 0 |
121183 | 121183 | 2020-05-06 | Preston | West Virginia | 54077 | 14 | 0 |
124163 | 124163 | 2020-05-07 | Preston | West Virginia | 54077 | 14 | 0 |
127148 | 127148 | 2020-05-08 | Preston | West Virginia | 54077 | 14 | 0 |
130138 | 130138 | 2020-05-09 | Preston | West Virginia | 54077 | 14 | 0 |
133128 | 133128 | 2020-05-10 | Preston | West Virginia | 54077 | 14 | 0 |
136118 | 136118 | 2020-05-11 | Preston | West Virginia | 54077 | 14 | 0 |
139109 | 139109 | 2020-05-12 | Preston | West Virginia | 54077 | 14 | 0 |
142105 | 142105 | 2020-05-13 | Preston | West Virginia | 54077 | 14 | 0 |
145102 | 145102 | 2020-05-14 | Preston | West Virginia | 54077 | 15 | 0 |
148105 | 148105 | 2020-05-15 | Preston | West Virginia | 54077 | 15 | 0 |
151114 | 151114 | 2020-05-16 | Preston | West Virginia | 54077 | 15 | 0 |
154125 | 154125 | 2020-05-17 | Preston | West Virginia | 54077 | 15 | 0 |
157142 | 157142 | 2020-05-18 | Preston | West Virginia | 54077 | 15 | 0 |
160166 | 160166 | 2020-05-19 | Preston | West Virginia | 54077 | 15 | 0 |
163194 | 163194 | 2020-05-20 | Preston | West Virginia | 54077 | 15 | 0 |
166223 | 166223 | 2020-05-21 | Preston | West Virginia | 54077 | 15 | 0 |
169259 | 169259 | 2020-05-22 | Preston | West Virginia | 54077 | 19 | 0 |
172300 | 172300 | 2020-05-23 | Preston | West Virginia | 54077 | 19 | 0 |
175343 | 175343 | 2020-05-24 | Preston | West Virginia | 54077 | 20 | 0 |
178388 | 178388 | 2020-05-25 | Preston | West Virginia | 54077 | 22 | 0 |
181432 | 181432 | 2020-05-26 | Preston | West Virginia | 54077 | 22 | 1 |
190604 | 190604 | 2020-05-29 | Preston | West Virginia | 54077 | 25 | 1 |
193670 | 193670 | 2020-05-30 | Preston | West Virginia | 54077 | 25 | 1 |
196740 | 196740 | 2020-05-31 | Preston | West Virginia | 54077 | 25 | 1 |
184483 | 184483 | 2020-05-27 | Preston | West Virginia | 54077 | 22 | 2 |
187540 | 187540 | 2020-05-28 | Preston | West Virginia | 54077 | 22 | 2 |
202889 | 202889 | 2020-06-02 | Preston | West Virginia | 54077 | 24 | 2 |
205968 | 205968 | 2020-06-03 | Preston | West Virginia | 54077 | 24 | 2 |
209050 | 209050 | 2020-06-04 | Preston | West Virginia | 54077 | 24 | 2 |
212135 | 212135 | 2020-06-05 | Preston | West Virginia | 54077 | 24 | 2 |
215222 | 215222 | 2020-06-06 | Preston | West Virginia | 54077 | 24 | 2 |
218312 | 218312 | 2020-06-07 | Preston | West Virginia | 54077 | 24 | 2 |
221404 | 221404 | 2020-06-08 | Preston | West Virginia | 54077 | 24 | 2 |
224500 | 224500 | 2020-06-09 | Preston | West Virginia | 54077 | 24 | 2 |
227600 | 227600 | 2020-06-10 | Preston | West Virginia | 54077 | 24 | 2 |
230704 | 230704 | 2020-06-11 | Preston | West Virginia | 54077 | 24 | 2 |
233809 | 233809 | 2020-06-12 | Preston | West Virginia | 54077 | 24 | 2 |
236916 | 236916 | 2020-06-13 | Preston | West Virginia | 54077 | 24 | 2 |
240024 | 240024 | 2020-06-14 | Preston | West Virginia | 54077 | 24 | 2 |
243135 | 243135 | 2020-06-15 | Preston | West Virginia | 54077 | 24 | 2 |
246248 | 246248 | 2020-06-16 | Preston | West Virginia | 54077 | 25 | 2 |
249360 | 249360 | 2020-06-17 | Preston | West Virginia | 54077 | 29 | 2 |
252475 | 252475 | 2020-06-18 | Preston | West Virginia | 54077 | 36 | 2 |
255594 | 255594 | 2020-06-19 | Preston | West Virginia | 54077 | 43 | 2 |
258721 | 258721 | 2020-06-20 | Preston | West Virginia | 54077 | 48 | 2 |
261848 | 261848 | 2020-06-21 | Preston | West Virginia | 54077 | 64 | 2 |
264977 | 264977 | 2020-06-22 | Preston | West Virginia | 54077 | 63 | 2 |
268106 | 268106 | 2020-06-23 | Preston | West Virginia | 54077 | 64 | 2 |
271240 | 271240 | 2020-06-24 | Preston | West Virginia | 54077 | 64 | 2 |
274380 | 274380 | 2020-06-25 | Preston | West Virginia | 54077 | 70 | 2 |
277528 | 277528 | 2020-06-26 | Preston | West Virginia | 54077 | 74 | 2 |
280676 | 280676 | 2020-06-27 | Preston | West Virginia | 54077 | 74 | 2 |
283822 | 283822 | 2020-06-28 | Preston | West Virginia | 54077 | 75 | 2 |
286968 | 286968 | 2020-06-29 | Preston | West Virginia | 54077 | 77 | 2 |
290118 | 290118 | 2020-06-30 | Preston | West Virginia | 54077 | 78 | 2 |
293271 | 293271 | 2020-07-01 | Preston | West Virginia | 54077 | 79 | 2 |
296426 | 296426 | 2020-07-02 | Preston | West Virginia | 54077 | 82 | 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);