ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
765 rows where county = "Wayne" and state = "West Virginia" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
45712 | 45712 | 2020-04-09 | Wayne | West Virginia | 54099 | 6 | 0 |
48340 | 48340 | 2020-04-10 | Wayne | West Virginia | 54099 | 16 | 0 |
51000 | 51000 | 2020-04-11 | Wayne | West Virginia | 54099 | 17 | 0 |
53677 | 53677 | 2020-04-12 | Wayne | West Virginia | 54099 | 17 | 0 |
56367 | 56367 | 2020-04-13 | Wayne | West Virginia | 54099 | 19 | 0 |
59074 | 59074 | 2020-04-14 | Wayne | West Virginia | 54099 | 60 | 0 |
61793 | 61793 | 2020-04-15 | Wayne | West Virginia | 54099 | 69 | 1 |
64526 | 64526 | 2020-04-16 | Wayne | West Virginia | 54099 | 72 | 1 |
67274 | 67274 | 2020-04-17 | Wayne | West Virginia | 54099 | 74 | 3 |
70036 | 70036 | 2020-04-18 | Wayne | West Virginia | 54099 | 75 | 3 |
72805 | 72805 | 2020-04-19 | Wayne | West Virginia | 54099 | 78 | 3 |
75581 | 75581 | 2020-04-20 | Wayne | West Virginia | 54099 | 78 | 4 |
78364 | 78364 | 2020-04-21 | Wayne | West Virginia | 54099 | 78 | 4 |
81157 | 81157 | 2020-04-22 | Wayne | West Virginia | 54099 | 79 | 5 |
83958 | 83958 | 2020-04-23 | Wayne | West Virginia | 54099 | 81 | 6 |
86765 | 86765 | 2020-04-24 | Wayne | West Virginia | 54099 | 81 | 6 |
89581 | 89581 | 2020-04-25 | Wayne | West Virginia | 54099 | 82 | 6 |
92399 | 92399 | 2020-04-26 | Wayne | West Virginia | 54099 | 82 | 6 |
95229 | 95229 | 2020-04-27 | Wayne | West Virginia | 54099 | 83 | 6 |
98074 | 98074 | 2020-04-28 | Wayne | West Virginia | 54099 | 84 | 6 |
100924 | 100924 | 2020-04-29 | Wayne | West Virginia | 54099 | 85 | 7 |
103779 | 103779 | 2020-04-30 | Wayne | West Virginia | 54099 | 85 | 7 |
106643 | 106643 | 2020-05-01 | Wayne | West Virginia | 54099 | 86 | 7 |
109512 | 109512 | 2020-05-02 | Wayne | West Virginia | 54099 | 89 | 7 |
112387 | 112387 | 2020-05-03 | Wayne | West Virginia | 54099 | 89 | 7 |
115270 | 115270 | 2020-05-04 | Wayne | West Virginia | 54099 | 90 | 7 |
118229 | 118229 | 2020-05-05 | Wayne | West Virginia | 54099 | 91 | 7 |
121194 | 121194 | 2020-05-06 | Wayne | West Virginia | 54099 | 92 | 7 |
124174 | 124174 | 2020-05-07 | Wayne | West Virginia | 54099 | 93 | 7 |
127159 | 127159 | 2020-05-08 | Wayne | West Virginia | 54099 | 93 | 7 |
130149 | 130149 | 2020-05-09 | Wayne | West Virginia | 54099 | 93 | 7 |
133139 | 133139 | 2020-05-10 | Wayne | West Virginia | 54099 | 93 | 7 |
136129 | 136129 | 2020-05-11 | Wayne | West Virginia | 54099 | 93 | 7 |
139120 | 139120 | 2020-05-12 | Wayne | West Virginia | 54099 | 93 | 7 |
142116 | 142116 | 2020-05-13 | Wayne | West Virginia | 54099 | 93 | 7 |
145113 | 145113 | 2020-05-14 | Wayne | West Virginia | 54099 | 95 | 8 |
148116 | 148116 | 2020-05-15 | Wayne | West Virginia | 54099 | 96 | 9 |
151125 | 151125 | 2020-05-16 | Wayne | West Virginia | 54099 | 96 | 9 |
154137 | 154137 | 2020-05-17 | Wayne | West Virginia | 54099 | 96 | 9 |
157153 | 157153 | 2020-05-18 | Wayne | West Virginia | 54099 | 96 | 9 |
160177 | 160177 | 2020-05-19 | Wayne | West Virginia | 54099 | 96 | 9 |
163205 | 163205 | 2020-05-20 | Wayne | West Virginia | 54099 | 96 | 9 |
166234 | 166234 | 2020-05-21 | Wayne | West Virginia | 54099 | 96 | 9 |
169270 | 169270 | 2020-05-22 | Wayne | West Virginia | 54099 | 97 | 9 |
172311 | 172311 | 2020-05-23 | Wayne | West Virginia | 54099 | 97 | 9 |
175354 | 175354 | 2020-05-24 | Wayne | West Virginia | 54099 | 97 | 9 |
178399 | 178399 | 2020-05-25 | Wayne | West Virginia | 54099 | 97 | 9 |
181443 | 181443 | 2020-05-26 | Wayne | West Virginia | 54099 | 97 | 9 |
184494 | 184494 | 2020-05-27 | Wayne | West Virginia | 54099 | 97 | 9 |
187551 | 187551 | 2020-05-28 | Wayne | West Virginia | 54099 | 98 | 9 |
190615 | 190615 | 2020-05-29 | Wayne | West Virginia | 54099 | 98 | 9 |
193681 | 193681 | 2020-05-30 | Wayne | West Virginia | 54099 | 98 | 9 |
196751 | 196751 | 2020-05-31 | Wayne | West Virginia | 54099 | 99 | 9 |
199824 | 199824 | 2020-06-01 | Wayne | West Virginia | 54099 | 100 | 9 |
202900 | 202900 | 2020-06-02 | Wayne | West Virginia | 54099 | 102 | 9 |
205979 | 205979 | 2020-06-03 | Wayne | West Virginia | 54099 | 102 | 9 |
209061 | 209061 | 2020-06-04 | Wayne | West Virginia | 54099 | 103 | 9 |
212146 | 212146 | 2020-06-05 | Wayne | West Virginia | 54099 | 103 | 9 |
215233 | 215233 | 2020-06-06 | Wayne | West Virginia | 54099 | 103 | 9 |
218323 | 218323 | 2020-06-07 | Wayne | West Virginia | 54099 | 103 | 9 |
221415 | 221415 | 2020-06-08 | Wayne | West Virginia | 54099 | 103 | 9 |
224511 | 224511 | 2020-06-09 | Wayne | West Virginia | 54099 | 103 | 9 |
227611 | 227611 | 2020-06-10 | Wayne | West Virginia | 54099 | 103 | 9 |
230715 | 230715 | 2020-06-11 | Wayne | West Virginia | 54099 | 103 | 9 |
233820 | 233820 | 2020-06-12 | Wayne | West Virginia | 54099 | 104 | 9 |
236927 | 236927 | 2020-06-13 | Wayne | West Virginia | 54099 | 104 | 9 |
240035 | 240035 | 2020-06-14 | Wayne | West Virginia | 54099 | 105 | 9 |
243146 | 243146 | 2020-06-15 | Wayne | West Virginia | 54099 | 106 | 9 |
246259 | 246259 | 2020-06-16 | Wayne | West Virginia | 54099 | 106 | 9 |
249371 | 249371 | 2020-06-17 | Wayne | West Virginia | 54099 | 106 | 9 |
252486 | 252486 | 2020-06-18 | Wayne | West Virginia | 54099 | 106 | 9 |
255605 | 255605 | 2020-06-19 | Wayne | West Virginia | 54099 | 106 | 9 |
258732 | 258732 | 2020-06-20 | Wayne | West Virginia | 54099 | 106 | 9 |
261859 | 261859 | 2020-06-21 | Wayne | West Virginia | 54099 | 106 | 9 |
264988 | 264988 | 2020-06-22 | Wayne | West Virginia | 54099 | 106 | 9 |
268117 | 268117 | 2020-06-23 | Wayne | West Virginia | 54099 | 107 | 9 |
271251 | 271251 | 2020-06-24 | Wayne | West Virginia | 54099 | 108 | 9 |
274391 | 274391 | 2020-06-25 | Wayne | West Virginia | 54099 | 110 | 9 |
277539 | 277539 | 2020-06-26 | Wayne | West Virginia | 54099 | 110 | 9 |
280687 | 280687 | 2020-06-27 | Wayne | West Virginia | 54099 | 110 | 9 |
283833 | 283833 | 2020-06-28 | Wayne | West Virginia | 54099 | 111 | 9 |
286979 | 286979 | 2020-06-29 | Wayne | West Virginia | 54099 | 111 | 9 |
290129 | 290129 | 2020-06-30 | Wayne | West Virginia | 54099 | 111 | 9 |
293282 | 293282 | 2020-07-01 | Wayne | West Virginia | 54099 | 112 | 9 |
296437 | 296437 | 2020-07-02 | Wayne | West Virginia | 54099 | 115 | 9 |
299599 | 299599 | 2020-07-03 | Wayne | West Virginia | 54099 | 115 | 9 |
302763 | 302763 | 2020-07-04 | Wayne | West Virginia | 54099 | 115 | 9 |
305927 | 305927 | 2020-07-05 | Wayne | West Virginia | 54099 | 117 | 9 |
309095 | 309095 | 2020-07-06 | Wayne | West Virginia | 54099 | 120 | 9 |
312264 | 312264 | 2020-07-07 | Wayne | West Virginia | 54099 | 120 | 9 |
315439 | 315439 | 2020-07-08 | Wayne | West Virginia | 54099 | 120 | 9 |
318612 | 318612 | 2020-07-09 | Wayne | West Virginia | 54099 | 121 | 9 |
321791 | 321791 | 2020-07-10 | Wayne | West Virginia | 54099 | 122 | 9 |
324972 | 324972 | 2020-07-11 | Wayne | West Virginia | 54099 | 124 | 9 |
328158 | 328158 | 2020-07-12 | Wayne | West Virginia | 54099 | 124 | 9 |
331344 | 331344 | 2020-07-13 | Wayne | West Virginia | 54099 | 128 | 9 |
334537 | 334537 | 2020-07-14 | Wayne | West Virginia | 54099 | 129 | 9 |
337732 | 337732 | 2020-07-15 | Wayne | West Virginia | 54099 | 137 | 9 |
340928 | 340928 | 2020-07-16 | Wayne | West Virginia | 54099 | 143 | 9 |
344127 | 344127 | 2020-07-17 | Wayne | West Virginia | 54099 | 146 | 9 |
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);