ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
762 rows where county = "Grant" and fips = 54023 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 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
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- 2020-04-27 1
- 2020-04-28 1
- 2020-04-29 1
- 2020-04-30 1
- 2020-05-01 1
- 2020-05-02 1
- 2020-05-03 1
- 2020-05-04 1
- 2020-05-05 1
- 2020-05-06 1
- 2020-05-07 1
- 2020-05-08 1
- 2020-05-09 1
- 2020-05-10 1
- 2020-05-11 1
- …
state 1
- West Virginia 762
fips 1
- 54023 · 762 ✖
county 1
- Grant · 762 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
53642 | 53642 | 2020-04-12 | Grant | West Virginia | 54023 | 1 | 0 |
56332 | 56332 | 2020-04-13 | Grant | West Virginia | 54023 | 1 | 0 |
59038 | 59038 | 2020-04-14 | Grant | West Virginia | 54023 | 1 | 0 |
61757 | 61757 | 2020-04-15 | Grant | West Virginia | 54023 | 1 | 0 |
64490 | 64490 | 2020-04-16 | Grant | West Virginia | 54023 | 1 | 0 |
67238 | 67238 | 2020-04-17 | Grant | West Virginia | 54023 | 1 | 0 |
70000 | 70000 | 2020-04-18 | Grant | West Virginia | 54023 | 1 | 0 |
72769 | 72769 | 2020-04-19 | Grant | West Virginia | 54023 | 1 | 0 |
75545 | 75545 | 2020-04-20 | Grant | West Virginia | 54023 | 1 | 0 |
78328 | 78328 | 2020-04-21 | Grant | West Virginia | 54023 | 1 | 0 |
81121 | 81121 | 2020-04-22 | Grant | West Virginia | 54023 | 1 | 0 |
83922 | 83922 | 2020-04-23 | Grant | West Virginia | 54023 | 1 | 0 |
86729 | 86729 | 2020-04-24 | Grant | West Virginia | 54023 | 1 | 0 |
89545 | 89545 | 2020-04-25 | Grant | West Virginia | 54023 | 1 | 0 |
92363 | 92363 | 2020-04-26 | Grant | West Virginia | 54023 | 1 | 0 |
95192 | 95192 | 2020-04-27 | Grant | West Virginia | 54023 | 1 | 0 |
98037 | 98037 | 2020-04-28 | Grant | West Virginia | 54023 | 1 | 0 |
100887 | 100887 | 2020-04-29 | Grant | West Virginia | 54023 | 1 | 0 |
103742 | 103742 | 2020-04-30 | Grant | West Virginia | 54023 | 1 | 0 |
106606 | 106606 | 2020-05-01 | Grant | West Virginia | 54023 | 1 | 0 |
109475 | 109475 | 2020-05-02 | Grant | West Virginia | 54023 | 1 | 0 |
112349 | 112349 | 2020-05-03 | Grant | West Virginia | 54023 | 1 | 0 |
115232 | 115232 | 2020-05-04 | Grant | West Virginia | 54023 | 3 | 0 |
118191 | 118191 | 2020-05-05 | Grant | West Virginia | 54023 | 3 | 0 |
121156 | 121156 | 2020-05-06 | Grant | West Virginia | 54023 | 3 | 0 |
124136 | 124136 | 2020-05-07 | Grant | West Virginia | 54023 | 3 | 0 |
127121 | 127121 | 2020-05-08 | Grant | West Virginia | 54023 | 3 | 0 |
130111 | 130111 | 2020-05-09 | Grant | West Virginia | 54023 | 3 | 0 |
133101 | 133101 | 2020-05-10 | Grant | West Virginia | 54023 | 3 | 0 |
136091 | 136091 | 2020-05-11 | Grant | West Virginia | 54023 | 3 | 0 |
139082 | 139082 | 2020-05-12 | Grant | West Virginia | 54023 | 3 | 0 |
142078 | 142078 | 2020-05-13 | Grant | West Virginia | 54023 | 6 | 0 |
145075 | 145075 | 2020-05-14 | Grant | West Virginia | 54023 | 6 | 0 |
148078 | 148078 | 2020-05-15 | Grant | West Virginia | 54023 | 6 | 0 |
151087 | 151087 | 2020-05-16 | Grant | West Virginia | 54023 | 6 | 0 |
154098 | 154098 | 2020-05-17 | Grant | West Virginia | 54023 | 6 | 0 |
157115 | 157115 | 2020-05-18 | Grant | West Virginia | 54023 | 6 | 0 |
160139 | 160139 | 2020-05-19 | Grant | West Virginia | 54023 | 6 | 0 |
163167 | 163167 | 2020-05-20 | Grant | West Virginia | 54023 | 6 | 0 |
166196 | 166196 | 2020-05-21 | Grant | West Virginia | 54023 | 6 | 0 |
169232 | 169232 | 2020-05-22 | Grant | West Virginia | 54023 | 7 | 0 |
172273 | 172273 | 2020-05-23 | Grant | West Virginia | 54023 | 9 | 0 |
175316 | 175316 | 2020-05-24 | Grant | West Virginia | 54023 | 11 | 0 |
178361 | 178361 | 2020-05-25 | Grant | West Virginia | 54023 | 11 | 0 |
181405 | 181405 | 2020-05-26 | Grant | West Virginia | 54023 | 11 | 0 |
184456 | 184456 | 2020-05-27 | Grant | West Virginia | 54023 | 11 | 0 |
187513 | 187513 | 2020-05-28 | Grant | West Virginia | 54023 | 11 | 0 |
190577 | 190577 | 2020-05-29 | Grant | West Virginia | 54023 | 12 | 0 |
193643 | 193643 | 2020-05-30 | Grant | West Virginia | 54023 | 12 | 0 |
196713 | 196713 | 2020-05-31 | Grant | West Virginia | 54023 | 12 | 0 |
199786 | 199786 | 2020-06-01 | Grant | West Virginia | 54023 | 12 | 0 |
202862 | 202862 | 2020-06-02 | Grant | West Virginia | 54023 | 12 | 0 |
205941 | 205941 | 2020-06-03 | Grant | West Virginia | 54023 | 12 | 0 |
209023 | 209023 | 2020-06-04 | Grant | West Virginia | 54023 | 12 | 0 |
212108 | 212108 | 2020-06-05 | Grant | West Virginia | 54023 | 12 | 0 |
215195 | 215195 | 2020-06-06 | Grant | West Virginia | 54023 | 12 | 0 |
218285 | 218285 | 2020-06-07 | Grant | West Virginia | 54023 | 12 | 0 |
221377 | 221377 | 2020-06-08 | Grant | West Virginia | 54023 | 14 | 0 |
224473 | 224473 | 2020-06-09 | Grant | West Virginia | 54023 | 14 | 0 |
227573 | 227573 | 2020-06-10 | Grant | West Virginia | 54023 | 14 | 0 |
230677 | 230677 | 2020-06-11 | Grant | West Virginia | 54023 | 16 | 0 |
233782 | 233782 | 2020-06-12 | Grant | West Virginia | 54023 | 16 | 0 |
236889 | 236889 | 2020-06-13 | Grant | West Virginia | 54023 | 16 | 0 |
239997 | 239997 | 2020-06-14 | Grant | West Virginia | 54023 | 16 | 0 |
243108 | 243108 | 2020-06-15 | Grant | West Virginia | 54023 | 16 | 0 |
246221 | 246221 | 2020-06-16 | Grant | West Virginia | 54023 | 16 | 0 |
249333 | 249333 | 2020-06-17 | Grant | West Virginia | 54023 | 16 | 0 |
252448 | 252448 | 2020-06-18 | Grant | West Virginia | 54023 | 16 | 0 |
255567 | 255567 | 2020-06-19 | Grant | West Virginia | 54023 | 16 | 0 |
258694 | 258694 | 2020-06-20 | Grant | West Virginia | 54023 | 16 | 0 |
261821 | 261821 | 2020-06-21 | Grant | West Virginia | 54023 | 16 | 0 |
264950 | 264950 | 2020-06-22 | Grant | West Virginia | 54023 | 16 | 0 |
268079 | 268079 | 2020-06-23 | Grant | West Virginia | 54023 | 16 | 0 |
271213 | 271213 | 2020-06-24 | Grant | West Virginia | 54023 | 16 | 0 |
274353 | 274353 | 2020-06-25 | Grant | West Virginia | 54023 | 16 | 0 |
277501 | 277501 | 2020-06-26 | Grant | West Virginia | 54023 | 16 | 0 |
280649 | 280649 | 2020-06-27 | Grant | West Virginia | 54023 | 16 | 0 |
283795 | 283795 | 2020-06-28 | Grant | West Virginia | 54023 | 16 | 0 |
286941 | 286941 | 2020-06-29 | Grant | West Virginia | 54023 | 16 | 0 |
290091 | 290091 | 2020-06-30 | Grant | West Virginia | 54023 | 16 | 0 |
293244 | 293244 | 2020-07-01 | Grant | West Virginia | 54023 | 16 | 0 |
296399 | 296399 | 2020-07-02 | Grant | West Virginia | 54023 | 16 | 0 |
299561 | 299561 | 2020-07-03 | Grant | West Virginia | 54023 | 16 | 0 |
302725 | 302725 | 2020-07-04 | Grant | West Virginia | 54023 | 16 | 0 |
305889 | 305889 | 2020-07-05 | Grant | West Virginia | 54023 | 16 | 0 |
309057 | 309057 | 2020-07-06 | Grant | West Virginia | 54023 | 16 | 0 |
312226 | 312226 | 2020-07-07 | Grant | West Virginia | 54023 | 16 | 0 |
315401 | 315401 | 2020-07-08 | Grant | West Virginia | 54023 | 16 | 0 |
318574 | 318574 | 2020-07-09 | Grant | West Virginia | 54023 | 16 | 0 |
321753 | 321753 | 2020-07-10 | Grant | West Virginia | 54023 | 19 | 0 |
324934 | 324934 | 2020-07-11 | Grant | West Virginia | 54023 | 19 | 0 |
328120 | 328120 | 2020-07-12 | Grant | West Virginia | 54023 | 20 | 0 |
331306 | 331306 | 2020-07-13 | Grant | West Virginia | 54023 | 22 | 0 |
334499 | 334499 | 2020-07-14 | Grant | West Virginia | 54023 | 21 | 0 |
337694 | 337694 | 2020-07-15 | Grant | West Virginia | 54023 | 21 | 0 |
340890 | 340890 | 2020-07-16 | Grant | West Virginia | 54023 | 22 | 0 |
344089 | 344089 | 2020-07-17 | Grant | West Virginia | 54023 | 22 | 0 |
347289 | 347289 | 2020-07-18 | Grant | West Virginia | 54023 | 22 | 0 |
350490 | 350490 | 2020-07-19 | Grant | West Virginia | 54023 | 22 | 0 |
353692 | 353692 | 2020-07-20 | Grant | West Virginia | 54023 | 26 | 0 |
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);