ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Morgan" and state = "West Virginia" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 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
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- 2020-04-27 1
- …
state 1
- West Virginia · 776 ✖
fips 1
- 54065 776
county 1
- Morgan · 776 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
19587 | 19587 | 2020-03-29 | Morgan | West Virginia | 54065 | 1 | 0 |
21654 | 21654 | 2020-03-30 | Morgan | West Virginia | 54065 | 1 | 0 |
23804 | 23804 | 2020-03-31 | Morgan | West Virginia | 54065 | 1 | 0 |
26022 | 26022 | 2020-04-01 | Morgan | West Virginia | 54065 | 1 | 0 |
28314 | 28314 | 2020-04-02 | Morgan | West Virginia | 54065 | 1 | 0 |
30668 | 30668 | 2020-04-03 | Morgan | West Virginia | 54065 | 1 | 0 |
33069 | 33069 | 2020-04-04 | Morgan | West Virginia | 54065 | 1 | 0 |
35507 | 35507 | 2020-04-05 | Morgan | West Virginia | 54065 | 3 | 0 |
37992 | 37992 | 2020-04-06 | Morgan | West Virginia | 54065 | 3 | 0 |
40530 | 40530 | 2020-04-07 | Morgan | West Virginia | 54065 | 4 | 0 |
43102 | 43102 | 2020-04-08 | Morgan | West Virginia | 54065 | 4 | 0 |
45698 | 45698 | 2020-04-09 | Morgan | West Virginia | 54065 | 4 | 0 |
48326 | 48326 | 2020-04-10 | Morgan | West Virginia | 54065 | 4 | 0 |
50985 | 50985 | 2020-04-11 | Morgan | West Virginia | 54065 | 6 | 0 |
53662 | 53662 | 2020-04-12 | Morgan | West Virginia | 54065 | 6 | 0 |
56352 | 56352 | 2020-04-13 | Morgan | West Virginia | 54065 | 6 | 0 |
59059 | 59059 | 2020-04-14 | Morgan | West Virginia | 54065 | 6 | 0 |
61778 | 61778 | 2020-04-15 | Morgan | West Virginia | 54065 | 7 | 0 |
64511 | 64511 | 2020-04-16 | Morgan | West Virginia | 54065 | 7 | 0 |
67259 | 67259 | 2020-04-17 | Morgan | West Virginia | 54065 | 8 | 0 |
70021 | 70021 | 2020-04-18 | Morgan | West Virginia | 54065 | 8 | 0 |
72790 | 72790 | 2020-04-19 | Morgan | West Virginia | 54065 | 8 | 0 |
75566 | 75566 | 2020-04-20 | Morgan | West Virginia | 54065 | 8 | 0 |
78349 | 78349 | 2020-04-21 | Morgan | West Virginia | 54065 | 7 | 0 |
81142 | 81142 | 2020-04-22 | Morgan | West Virginia | 54065 | 7 | 0 |
83943 | 83943 | 2020-04-23 | Morgan | West Virginia | 54065 | 7 | 0 |
86750 | 86750 | 2020-04-24 | Morgan | West Virginia | 54065 | 9 | 0 |
89566 | 89566 | 2020-04-25 | Morgan | West Virginia | 54065 | 9 | 0 |
92384 | 92384 | 2020-04-26 | Morgan | West Virginia | 54065 | 9 | 0 |
95213 | 95213 | 2020-04-27 | Morgan | West Virginia | 54065 | 9 | 0 |
98058 | 98058 | 2020-04-28 | Morgan | West Virginia | 54065 | 9 | 0 |
100908 | 100908 | 2020-04-29 | Morgan | West Virginia | 54065 | 10 | 0 |
103763 | 103763 | 2020-04-30 | Morgan | West Virginia | 54065 | 11 | 0 |
106627 | 106627 | 2020-05-01 | Morgan | West Virginia | 54065 | 12 | 0 |
109496 | 109496 | 2020-05-02 | Morgan | West Virginia | 54065 | 13 | 0 |
112370 | 112370 | 2020-05-03 | Morgan | West Virginia | 54065 | 13 | 0 |
115253 | 115253 | 2020-05-04 | Morgan | West Virginia | 54065 | 13 | 0 |
118212 | 118212 | 2020-05-05 | Morgan | West Virginia | 54065 | 14 | 0 |
121177 | 121177 | 2020-05-06 | Morgan | West Virginia | 54065 | 14 | 0 |
124157 | 124157 | 2020-05-07 | Morgan | West Virginia | 54065 | 17 | 0 |
127142 | 127142 | 2020-05-08 | Morgan | West Virginia | 54065 | 16 | 0 |
130132 | 130132 | 2020-05-09 | Morgan | West Virginia | 54065 | 16 | 0 |
133122 | 133122 | 2020-05-10 | Morgan | West Virginia | 54065 | 16 | 0 |
136112 | 136112 | 2020-05-11 | Morgan | West Virginia | 54065 | 17 | 0 |
139103 | 139103 | 2020-05-12 | Morgan | West Virginia | 54065 | 17 | 0 |
142099 | 142099 | 2020-05-13 | Morgan | West Virginia | 54065 | 17 | 0 |
145096 | 145096 | 2020-05-14 | Morgan | West Virginia | 54065 | 17 | 0 |
148099 | 148099 | 2020-05-15 | Morgan | West Virginia | 54065 | 17 | 0 |
151108 | 151108 | 2020-05-16 | Morgan | West Virginia | 54065 | 17 | 0 |
154119 | 154119 | 2020-05-17 | Morgan | West Virginia | 54065 | 17 | 0 |
157136 | 157136 | 2020-05-18 | Morgan | West Virginia | 54065 | 17 | 0 |
160160 | 160160 | 2020-05-19 | Morgan | West Virginia | 54065 | 17 | 0 |
163188 | 163188 | 2020-05-20 | Morgan | West Virginia | 54065 | 17 | 0 |
166217 | 166217 | 2020-05-21 | Morgan | West Virginia | 54065 | 17 | 0 |
169253 | 169253 | 2020-05-22 | Morgan | West Virginia | 54065 | 17 | 0 |
172294 | 172294 | 2020-05-23 | Morgan | West Virginia | 54065 | 17 | 0 |
175337 | 175337 | 2020-05-24 | Morgan | West Virginia | 54065 | 17 | 0 |
178382 | 178382 | 2020-05-25 | Morgan | West Virginia | 54065 | 18 | 0 |
181426 | 181426 | 2020-05-26 | Morgan | West Virginia | 54065 | 18 | 0 |
184477 | 184477 | 2020-05-27 | Morgan | West Virginia | 54065 | 18 | 0 |
187534 | 187534 | 2020-05-28 | Morgan | West Virginia | 54065 | 18 | 0 |
190598 | 190598 | 2020-05-29 | Morgan | West Virginia | 54065 | 18 | 0 |
193664 | 193664 | 2020-05-30 | Morgan | West Virginia | 54065 | 18 | 0 |
196734 | 196734 | 2020-05-31 | Morgan | West Virginia | 54065 | 18 | 0 |
199807 | 199807 | 2020-06-01 | Morgan | West Virginia | 54065 | 18 | 0 |
202883 | 202883 | 2020-06-02 | Morgan | West Virginia | 54065 | 19 | 0 |
205962 | 205962 | 2020-06-03 | Morgan | West Virginia | 54065 | 19 | 0 |
209044 | 209044 | 2020-06-04 | Morgan | West Virginia | 54065 | 19 | 0 |
212129 | 212129 | 2020-06-05 | Morgan | West Virginia | 54065 | 19 | 0 |
215216 | 215216 | 2020-06-06 | Morgan | West Virginia | 54065 | 19 | 0 |
218306 | 218306 | 2020-06-07 | Morgan | West Virginia | 54065 | 19 | 0 |
221398 | 221398 | 2020-06-08 | Morgan | West Virginia | 54065 | 19 | 0 |
224494 | 224494 | 2020-06-09 | Morgan | West Virginia | 54065 | 19 | 0 |
227594 | 227594 | 2020-06-10 | Morgan | West Virginia | 54065 | 19 | 0 |
230698 | 230698 | 2020-06-11 | Morgan | West Virginia | 54065 | 19 | 0 |
233803 | 233803 | 2020-06-12 | Morgan | West Virginia | 54065 | 19 | 0 |
236910 | 236910 | 2020-06-13 | Morgan | West Virginia | 54065 | 19 | 0 |
240018 | 240018 | 2020-06-14 | Morgan | West Virginia | 54065 | 19 | 0 |
243129 | 243129 | 2020-06-15 | Morgan | West Virginia | 54065 | 19 | 0 |
246242 | 246242 | 2020-06-16 | Morgan | West Virginia | 54065 | 19 | 0 |
249354 | 249354 | 2020-06-17 | Morgan | West Virginia | 54065 | 19 | 0 |
252469 | 252469 | 2020-06-18 | Morgan | West Virginia | 54065 | 19 | 0 |
255588 | 255588 | 2020-06-19 | Morgan | West Virginia | 54065 | 20 | 0 |
258715 | 258715 | 2020-06-20 | Morgan | West Virginia | 54065 | 20 | 0 |
261842 | 261842 | 2020-06-21 | Morgan | West Virginia | 54065 | 20 | 0 |
264971 | 264971 | 2020-06-22 | Morgan | West Virginia | 54065 | 20 | 0 |
268100 | 268100 | 2020-06-23 | Morgan | West Virginia | 54065 | 20 | 0 |
271234 | 271234 | 2020-06-24 | Morgan | West Virginia | 54065 | 20 | 0 |
274374 | 274374 | 2020-06-25 | Morgan | West Virginia | 54065 | 20 | 0 |
277522 | 277522 | 2020-06-26 | Morgan | West Virginia | 54065 | 20 | 0 |
280670 | 280670 | 2020-06-27 | Morgan | West Virginia | 54065 | 20 | 0 |
283816 | 283816 | 2020-06-28 | Morgan | West Virginia | 54065 | 20 | 0 |
286962 | 286962 | 2020-06-29 | Morgan | West Virginia | 54065 | 20 | 0 |
290112 | 290112 | 2020-06-30 | Morgan | West Virginia | 54065 | 20 | 0 |
293265 | 293265 | 2020-07-01 | Morgan | West Virginia | 54065 | 20 | 0 |
296420 | 296420 | 2020-07-02 | Morgan | West Virginia | 54065 | 20 | 0 |
299582 | 299582 | 2020-07-03 | Morgan | West Virginia | 54065 | 20 | 0 |
302746 | 302746 | 2020-07-04 | Morgan | West Virginia | 54065 | 20 | 0 |
305910 | 305910 | 2020-07-05 | Morgan | West Virginia | 54065 | 20 | 0 |
309078 | 309078 | 2020-07-06 | Morgan | West Virginia | 54065 | 20 | 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);