ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Lewis" and state = "West Virginia" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
37984 | 37984 | 2020-04-06 | Lewis | West Virginia | 54041 | 1 | 0 |
40521 | 40521 | 2020-04-07 | Lewis | West Virginia | 54041 | 1 | 0 |
43093 | 43093 | 2020-04-08 | Lewis | West Virginia | 54041 | 1 | 0 |
45689 | 45689 | 2020-04-09 | Lewis | West Virginia | 54041 | 1 | 0 |
48317 | 48317 | 2020-04-10 | Lewis | West Virginia | 54041 | 2 | 0 |
50975 | 50975 | 2020-04-11 | Lewis | West Virginia | 54041 | 2 | 0 |
53651 | 53651 | 2020-04-12 | Lewis | West Virginia | 54041 | 2 | 0 |
56341 | 56341 | 2020-04-13 | Lewis | West Virginia | 54041 | 2 | 0 |
59047 | 59047 | 2020-04-14 | Lewis | West Virginia | 54041 | 2 | 0 |
61766 | 61766 | 2020-04-15 | Lewis | West Virginia | 54041 | 2 | 0 |
64499 | 64499 | 2020-04-16 | Lewis | West Virginia | 54041 | 2 | 0 |
67247 | 67247 | 2020-04-17 | Lewis | West Virginia | 54041 | 2 | 0 |
70009 | 70009 | 2020-04-18 | Lewis | West Virginia | 54041 | 2 | 0 |
72778 | 72778 | 2020-04-19 | Lewis | West Virginia | 54041 | 2 | 0 |
75554 | 75554 | 2020-04-20 | Lewis | West Virginia | 54041 | 2 | 0 |
78337 | 78337 | 2020-04-21 | Lewis | West Virginia | 54041 | 2 | 0 |
81130 | 81130 | 2020-04-22 | Lewis | West Virginia | 54041 | 2 | 0 |
83931 | 83931 | 2020-04-23 | Lewis | West Virginia | 54041 | 3 | 0 |
86738 | 86738 | 2020-04-24 | Lewis | West Virginia | 54041 | 3 | 0 |
89554 | 89554 | 2020-04-25 | Lewis | West Virginia | 54041 | 3 | 0 |
92372 | 92372 | 2020-04-26 | Lewis | West Virginia | 54041 | 3 | 0 |
95201 | 95201 | 2020-04-27 | Lewis | West Virginia | 54041 | 4 | 0 |
98046 | 98046 | 2020-04-28 | Lewis | West Virginia | 54041 | 4 | 0 |
100896 | 100896 | 2020-04-29 | Lewis | West Virginia | 54041 | 4 | 0 |
103751 | 103751 | 2020-04-30 | Lewis | West Virginia | 54041 | 4 | 0 |
106615 | 106615 | 2020-05-01 | Lewis | West Virginia | 54041 | 4 | 0 |
109484 | 109484 | 2020-05-02 | Lewis | West Virginia | 54041 | 4 | 0 |
112358 | 112358 | 2020-05-03 | Lewis | West Virginia | 54041 | 4 | 0 |
115241 | 115241 | 2020-05-04 | Lewis | West Virginia | 54041 | 4 | 0 |
118200 | 118200 | 2020-05-05 | Lewis | West Virginia | 54041 | 4 | 0 |
121165 | 121165 | 2020-05-06 | Lewis | West Virginia | 54041 | 4 | 0 |
124145 | 124145 | 2020-05-07 | Lewis | West Virginia | 54041 | 4 | 0 |
127130 | 127130 | 2020-05-08 | Lewis | West Virginia | 54041 | 4 | 0 |
130120 | 130120 | 2020-05-09 | Lewis | West Virginia | 54041 | 4 | 0 |
133110 | 133110 | 2020-05-10 | Lewis | West Virginia | 54041 | 4 | 0 |
136100 | 136100 | 2020-05-11 | Lewis | West Virginia | 54041 | 4 | 0 |
139091 | 139091 | 2020-05-12 | Lewis | West Virginia | 54041 | 4 | 0 |
142087 | 142087 | 2020-05-13 | Lewis | West Virginia | 54041 | 4 | 0 |
145084 | 145084 | 2020-05-14 | Lewis | West Virginia | 54041 | 4 | 0 |
148087 | 148087 | 2020-05-15 | Lewis | West Virginia | 54041 | 4 | 0 |
151096 | 151096 | 2020-05-16 | Lewis | West Virginia | 54041 | 4 | 0 |
154107 | 154107 | 2020-05-17 | Lewis | West Virginia | 54041 | 5 | 0 |
157124 | 157124 | 2020-05-18 | Lewis | West Virginia | 54041 | 5 | 0 |
160148 | 160148 | 2020-05-19 | Lewis | West Virginia | 54041 | 5 | 0 |
163176 | 163176 | 2020-05-20 | Lewis | West Virginia | 54041 | 5 | 0 |
166205 | 166205 | 2020-05-21 | Lewis | West Virginia | 54041 | 5 | 0 |
169241 | 169241 | 2020-05-22 | Lewis | West Virginia | 54041 | 5 | 1 |
172282 | 172282 | 2020-05-23 | Lewis | West Virginia | 54041 | 5 | 1 |
175325 | 175325 | 2020-05-24 | Lewis | West Virginia | 54041 | 5 | 1 |
178370 | 178370 | 2020-05-25 | Lewis | West Virginia | 54041 | 5 | 1 |
181414 | 181414 | 2020-05-26 | Lewis | West Virginia | 54041 | 5 | 1 |
184465 | 184465 | 2020-05-27 | Lewis | West Virginia | 54041 | 6 | 1 |
187522 | 187522 | 2020-05-28 | Lewis | West Virginia | 54041 | 6 | 1 |
190586 | 190586 | 2020-05-29 | Lewis | West Virginia | 54041 | 8 | 1 |
193652 | 193652 | 2020-05-30 | Lewis | West Virginia | 54041 | 8 | 1 |
196722 | 196722 | 2020-05-31 | Lewis | West Virginia | 54041 | 9 | 1 |
199795 | 199795 | 2020-06-01 | Lewis | West Virginia | 54041 | 9 | 1 |
202871 | 202871 | 2020-06-02 | Lewis | West Virginia | 54041 | 9 | 1 |
205950 | 205950 | 2020-06-03 | Lewis | West Virginia | 54041 | 9 | 1 |
209032 | 209032 | 2020-06-04 | Lewis | West Virginia | 54041 | 9 | 1 |
212117 | 212117 | 2020-06-05 | Lewis | West Virginia | 54041 | 9 | 1 |
215204 | 215204 | 2020-06-06 | Lewis | West Virginia | 54041 | 8 | 1 |
218294 | 218294 | 2020-06-07 | Lewis | West Virginia | 54041 | 8 | 1 |
221386 | 221386 | 2020-06-08 | Lewis | West Virginia | 54041 | 8 | 1 |
224482 | 224482 | 2020-06-09 | Lewis | West Virginia | 54041 | 8 | 1 |
227582 | 227582 | 2020-06-10 | Lewis | West Virginia | 54041 | 8 | 1 |
230686 | 230686 | 2020-06-11 | Lewis | West Virginia | 54041 | 8 | 1 |
233791 | 233791 | 2020-06-12 | Lewis | West Virginia | 54041 | 8 | 1 |
236898 | 236898 | 2020-06-13 | Lewis | West Virginia | 54041 | 8 | 1 |
240006 | 240006 | 2020-06-14 | Lewis | West Virginia | 54041 | 8 | 1 |
243117 | 243117 | 2020-06-15 | Lewis | West Virginia | 54041 | 8 | 1 |
246230 | 246230 | 2020-06-16 | Lewis | West Virginia | 54041 | 8 | 1 |
249342 | 249342 | 2020-06-17 | Lewis | West Virginia | 54041 | 8 | 1 |
252457 | 252457 | 2020-06-18 | Lewis | West Virginia | 54041 | 14 | 1 |
255576 | 255576 | 2020-06-19 | Lewis | West Virginia | 54041 | 15 | 1 |
258703 | 258703 | 2020-06-20 | Lewis | West Virginia | 54041 | 15 | 1 |
261830 | 261830 | 2020-06-21 | Lewis | West Virginia | 54041 | 15 | 1 |
264959 | 264959 | 2020-06-22 | Lewis | West Virginia | 54041 | 15 | 1 |
268088 | 268088 | 2020-06-23 | Lewis | West Virginia | 54041 | 15 | 2 |
271222 | 271222 | 2020-06-24 | Lewis | West Virginia | 54041 | 15 | 2 |
274362 | 274362 | 2020-06-25 | Lewis | West Virginia | 54041 | 15 | 2 |
277510 | 277510 | 2020-06-26 | Lewis | West Virginia | 54041 | 15 | 2 |
280658 | 280658 | 2020-06-27 | Lewis | West Virginia | 54041 | 16 | 2 |
283804 | 283804 | 2020-06-28 | Lewis | West Virginia | 54041 | 17 | 2 |
286950 | 286950 | 2020-06-29 | Lewis | West Virginia | 54041 | 17 | 2 |
290100 | 290100 | 2020-06-30 | Lewis | West Virginia | 54041 | 19 | 2 |
293253 | 293253 | 2020-07-01 | Lewis | West Virginia | 54041 | 19 | 2 |
296408 | 296408 | 2020-07-02 | Lewis | West Virginia | 54041 | 20 | 2 |
299570 | 299570 | 2020-07-03 | Lewis | West Virginia | 54041 | 20 | 2 |
302734 | 302734 | 2020-07-04 | Lewis | West Virginia | 54041 | 20 | 2 |
305898 | 305898 | 2020-07-05 | Lewis | West Virginia | 54041 | 20 | 2 |
309066 | 309066 | 2020-07-06 | Lewis | West Virginia | 54041 | 20 | 2 |
312235 | 312235 | 2020-07-07 | Lewis | West Virginia | 54041 | 20 | 2 |
315410 | 315410 | 2020-07-08 | Lewis | West Virginia | 54041 | 20 | 2 |
318583 | 318583 | 2020-07-09 | Lewis | West Virginia | 54041 | 20 | 2 |
321762 | 321762 | 2020-07-10 | Lewis | West Virginia | 54041 | 20 | 2 |
324943 | 324943 | 2020-07-11 | Lewis | West Virginia | 54041 | 22 | 2 |
328129 | 328129 | 2020-07-12 | Lewis | West Virginia | 54041 | 24 | 2 |
331315 | 331315 | 2020-07-13 | Lewis | West Virginia | 54041 | 22 | 2 |
334508 | 334508 | 2020-07-14 | Lewis | West Virginia | 54041 | 23 | 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);