ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Nicholas" and state = "West Virginia" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
40531 | 40531 | 2020-04-07 | Nicholas | West Virginia | 54067 | 2 | 0 |
43103 | 43103 | 2020-04-08 | Nicholas | West Virginia | 54067 | 2 | 0 |
45699 | 45699 | 2020-04-09 | Nicholas | West Virginia | 54067 | 2 | 0 |
48327 | 48327 | 2020-04-10 | Nicholas | West Virginia | 54067 | 2 | 0 |
50986 | 50986 | 2020-04-11 | Nicholas | West Virginia | 54067 | 2 | 0 |
53663 | 53663 | 2020-04-12 | Nicholas | West Virginia | 54067 | 2 | 0 |
56353 | 56353 | 2020-04-13 | Nicholas | West Virginia | 54067 | 2 | 0 |
59060 | 59060 | 2020-04-14 | Nicholas | West Virginia | 54067 | 3 | 0 |
61779 | 61779 | 2020-04-15 | Nicholas | West Virginia | 54067 | 3 | 0 |
64512 | 64512 | 2020-04-16 | Nicholas | West Virginia | 54067 | 3 | 0 |
67260 | 67260 | 2020-04-17 | Nicholas | West Virginia | 54067 | 3 | 0 |
70022 | 70022 | 2020-04-18 | Nicholas | West Virginia | 54067 | 3 | 0 |
72791 | 72791 | 2020-04-19 | Nicholas | West Virginia | 54067 | 4 | 0 |
75567 | 75567 | 2020-04-20 | Nicholas | West Virginia | 54067 | 4 | 0 |
78350 | 78350 | 2020-04-21 | Nicholas | West Virginia | 54067 | 4 | 0 |
81143 | 81143 | 2020-04-22 | Nicholas | West Virginia | 54067 | 4 | 0 |
83944 | 83944 | 2020-04-23 | Nicholas | West Virginia | 54067 | 5 | 0 |
86751 | 86751 | 2020-04-24 | Nicholas | West Virginia | 54067 | 6 | 0 |
89567 | 89567 | 2020-04-25 | Nicholas | West Virginia | 54067 | 6 | 0 |
92385 | 92385 | 2020-04-26 | Nicholas | West Virginia | 54067 | 6 | 0 |
95214 | 95214 | 2020-04-27 | Nicholas | West Virginia | 54067 | 6 | 0 |
98059 | 98059 | 2020-04-28 | Nicholas | West Virginia | 54067 | 6 | 0 |
100909 | 100909 | 2020-04-29 | Nicholas | West Virginia | 54067 | 6 | 0 |
103764 | 103764 | 2020-04-30 | Nicholas | West Virginia | 54067 | 6 | 0 |
106628 | 106628 | 2020-05-01 | Nicholas | West Virginia | 54067 | 6 | 0 |
109497 | 109497 | 2020-05-02 | Nicholas | West Virginia | 54067 | 6 | 0 |
112371 | 112371 | 2020-05-03 | Nicholas | West Virginia | 54067 | 6 | 0 |
115254 | 115254 | 2020-05-04 | Nicholas | West Virginia | 54067 | 6 | 0 |
118213 | 118213 | 2020-05-05 | Nicholas | West Virginia | 54067 | 8 | 0 |
121178 | 121178 | 2020-05-06 | Nicholas | West Virginia | 54067 | 8 | 0 |
124158 | 124158 | 2020-05-07 | Nicholas | West Virginia | 54067 | 8 | 0 |
127143 | 127143 | 2020-05-08 | Nicholas | West Virginia | 54067 | 8 | 0 |
130133 | 130133 | 2020-05-09 | Nicholas | West Virginia | 54067 | 8 | 0 |
133123 | 133123 | 2020-05-10 | Nicholas | West Virginia | 54067 | 8 | 0 |
136113 | 136113 | 2020-05-11 | Nicholas | West Virginia | 54067 | 8 | 1 |
139104 | 139104 | 2020-05-12 | Nicholas | West Virginia | 54067 | 8 | 1 |
142100 | 142100 | 2020-05-13 | Nicholas | West Virginia | 54067 | 8 | 1 |
145097 | 145097 | 2020-05-14 | Nicholas | West Virginia | 54067 | 9 | 1 |
148100 | 148100 | 2020-05-15 | Nicholas | West Virginia | 54067 | 9 | 1 |
151109 | 151109 | 2020-05-16 | Nicholas | West Virginia | 54067 | 9 | 1 |
154120 | 154120 | 2020-05-17 | Nicholas | West Virginia | 54067 | 9 | 1 |
157137 | 157137 | 2020-05-18 | Nicholas | West Virginia | 54067 | 9 | 1 |
160161 | 160161 | 2020-05-19 | Nicholas | West Virginia | 54067 | 9 | 1 |
163189 | 163189 | 2020-05-20 | Nicholas | West Virginia | 54067 | 9 | 1 |
166218 | 166218 | 2020-05-21 | Nicholas | West Virginia | 54067 | 9 | 1 |
169254 | 169254 | 2020-05-22 | Nicholas | West Virginia | 54067 | 10 | 1 |
172295 | 172295 | 2020-05-23 | Nicholas | West Virginia | 54067 | 10 | 1 |
175338 | 175338 | 2020-05-24 | Nicholas | West Virginia | 54067 | 10 | 1 |
178383 | 178383 | 2020-05-25 | Nicholas | West Virginia | 54067 | 10 | 1 |
181427 | 181427 | 2020-05-26 | Nicholas | West Virginia | 54067 | 10 | 1 |
184478 | 184478 | 2020-05-27 | Nicholas | West Virginia | 54067 | 10 | 1 |
187535 | 187535 | 2020-05-28 | Nicholas | West Virginia | 54067 | 8 | 1 |
190599 | 190599 | 2020-05-29 | Nicholas | West Virginia | 54067 | 8 | 1 |
193665 | 193665 | 2020-05-30 | Nicholas | West Virginia | 54067 | 8 | 1 |
196735 | 196735 | 2020-05-31 | Nicholas | West Virginia | 54067 | 8 | 1 |
199808 | 199808 | 2020-06-01 | Nicholas | West Virginia | 54067 | 8 | 1 |
202884 | 202884 | 2020-06-02 | Nicholas | West Virginia | 54067 | 8 | 1 |
205963 | 205963 | 2020-06-03 | Nicholas | West Virginia | 54067 | 9 | 1 |
209045 | 209045 | 2020-06-04 | Nicholas | West Virginia | 54067 | 9 | 1 |
212130 | 212130 | 2020-06-05 | Nicholas | West Virginia | 54067 | 8 | 1 |
215217 | 215217 | 2020-06-06 | Nicholas | West Virginia | 54067 | 8 | 1 |
218307 | 218307 | 2020-06-07 | Nicholas | West Virginia | 54067 | 8 | 1 |
221399 | 221399 | 2020-06-08 | Nicholas | West Virginia | 54067 | 7 | 1 |
224495 | 224495 | 2020-06-09 | Nicholas | West Virginia | 54067 | 7 | 1 |
227595 | 227595 | 2020-06-10 | Nicholas | West Virginia | 54067 | 7 | 1 |
230699 | 230699 | 2020-06-11 | Nicholas | West Virginia | 54067 | 7 | 1 |
233804 | 233804 | 2020-06-12 | Nicholas | West Virginia | 54067 | 7 | 1 |
236911 | 236911 | 2020-06-13 | Nicholas | West Virginia | 54067 | 7 | 1 |
240019 | 240019 | 2020-06-14 | Nicholas | West Virginia | 54067 | 7 | 1 |
243130 | 243130 | 2020-06-15 | Nicholas | West Virginia | 54067 | 7 | 1 |
246243 | 246243 | 2020-06-16 | Nicholas | West Virginia | 54067 | 7 | 1 |
249355 | 249355 | 2020-06-17 | Nicholas | West Virginia | 54067 | 7 | 1 |
252470 | 252470 | 2020-06-18 | Nicholas | West Virginia | 54067 | 7 | 1 |
255589 | 255589 | 2020-06-19 | Nicholas | West Virginia | 54067 | 7 | 1 |
258716 | 258716 | 2020-06-20 | Nicholas | West Virginia | 54067 | 7 | 1 |
261843 | 261843 | 2020-06-21 | Nicholas | West Virginia | 54067 | 7 | 1 |
264972 | 264972 | 2020-06-22 | Nicholas | West Virginia | 54067 | 7 | 1 |
268101 | 268101 | 2020-06-23 | Nicholas | West Virginia | 54067 | 7 | 1 |
271235 | 271235 | 2020-06-24 | Nicholas | West Virginia | 54067 | 8 | 1 |
274375 | 274375 | 2020-06-25 | Nicholas | West Virginia | 54067 | 8 | 1 |
277523 | 277523 | 2020-06-26 | Nicholas | West Virginia | 54067 | 8 | 1 |
280671 | 280671 | 2020-06-27 | Nicholas | West Virginia | 54067 | 8 | 1 |
283817 | 283817 | 2020-06-28 | Nicholas | West Virginia | 54067 | 8 | 1 |
286963 | 286963 | 2020-06-29 | Nicholas | West Virginia | 54067 | 10 | 1 |
290113 | 290113 | 2020-06-30 | Nicholas | West Virginia | 54067 | 10 | 1 |
293266 | 293266 | 2020-07-01 | Nicholas | West Virginia | 54067 | 11 | 1 |
296421 | 296421 | 2020-07-02 | Nicholas | West Virginia | 54067 | 12 | 1 |
299583 | 299583 | 2020-07-03 | Nicholas | West Virginia | 54067 | 13 | 1 |
302747 | 302747 | 2020-07-04 | Nicholas | West Virginia | 54067 | 14 | 1 |
305911 | 305911 | 2020-07-05 | Nicholas | West Virginia | 54067 | 15 | 1 |
309079 | 309079 | 2020-07-06 | Nicholas | West Virginia | 54067 | 15 | 1 |
312248 | 312248 | 2020-07-07 | Nicholas | West Virginia | 54067 | 15 | 1 |
315423 | 315423 | 2020-07-08 | Nicholas | West Virginia | 54067 | 15 | 1 |
318596 | 318596 | 2020-07-09 | Nicholas | West Virginia | 54067 | 16 | 1 |
321775 | 321775 | 2020-07-10 | Nicholas | West Virginia | 54067 | 16 | 1 |
324956 | 324956 | 2020-07-11 | Nicholas | West Virginia | 54067 | 21 | 1 |
328142 | 328142 | 2020-07-12 | Nicholas | West Virginia | 54067 | 21 | 1 |
331328 | 331328 | 2020-07-13 | Nicholas | West Virginia | 54067 | 20 | 1 |
334521 | 334521 | 2020-07-14 | Nicholas | West Virginia | 54067 | 20 | 1 |
337716 | 337716 | 2020-07-15 | Nicholas | West Virginia | 54067 | 20 | 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);