ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 54037 and state = "West Virginia" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 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
- …
state 1
- West Virginia · 788 ✖
fips 1
- 54037 · 788 ✖
county 1
- Jefferson 788
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3745 | 3745 | 2020-03-17 | Jefferson | West Virginia | 54037 | 1 | 0 |
4380 | 4380 | 2020-03-18 | Jefferson | West Virginia | 54037 | 1 | 0 |
5137 | 5137 | 2020-03-19 | Jefferson | West Virginia | 54037 | 1 | 0 |
6042 | 6042 | 2020-03-20 | Jefferson | West Virginia | 54037 | 2 | 0 |
7073 | 7073 | 2020-03-21 | Jefferson | West Virginia | 54037 | 2 | 0 |
8211 | 8211 | 2020-03-22 | Jefferson | West Virginia | 54037 | 3 | 0 |
9436 | 9436 | 2020-03-23 | Jefferson | West Virginia | 54037 | 3 | 0 |
10788 | 10788 | 2020-03-24 | Jefferson | West Virginia | 54037 | 3 | 0 |
12311 | 12311 | 2020-03-25 | Jefferson | West Virginia | 54037 | 3 | 0 |
13962 | 13962 | 2020-03-26 | Jefferson | West Virginia | 54037 | 4 | 0 |
15733 | 15733 | 2020-03-27 | Jefferson | West Virginia | 54037 | 4 | 0 |
17613 | 17613 | 2020-03-28 | Jefferson | West Virginia | 54037 | 4 | 0 |
19579 | 19579 | 2020-03-29 | Jefferson | West Virginia | 54037 | 5 | 0 |
21646 | 21646 | 2020-03-30 | Jefferson | West Virginia | 54037 | 6 | 0 |
23796 | 23796 | 2020-03-31 | Jefferson | West Virginia | 54037 | 8 | 0 |
26014 | 26014 | 2020-04-01 | Jefferson | West Virginia | 54037 | 9 | 0 |
28306 | 28306 | 2020-04-02 | Jefferson | West Virginia | 54037 | 12 | 0 |
30659 | 30659 | 2020-04-03 | Jefferson | West Virginia | 54037 | 12 | 0 |
33060 | 33060 | 2020-04-04 | Jefferson | West Virginia | 54037 | 17 | 0 |
35498 | 35498 | 2020-04-05 | Jefferson | West Virginia | 54037 | 21 | 0 |
37982 | 37982 | 2020-04-06 | Jefferson | West Virginia | 54037 | 22 | 0 |
40519 | 40519 | 2020-04-07 | Jefferson | West Virginia | 54037 | 31 | 0 |
43091 | 43091 | 2020-04-08 | Jefferson | West Virginia | 54037 | 40 | 0 |
45687 | 45687 | 2020-04-09 | Jefferson | West Virginia | 54037 | 45 | 0 |
48315 | 48315 | 2020-04-10 | Jefferson | West Virginia | 54037 | 44 | 0 |
50973 | 50973 | 2020-04-11 | Jefferson | West Virginia | 54037 | 48 | 0 |
53649 | 53649 | 2020-04-12 | Jefferson | West Virginia | 54037 | 49 | 0 |
56339 | 56339 | 2020-04-13 | Jefferson | West Virginia | 54037 | 51 | 0 |
59045 | 59045 | 2020-04-14 | Jefferson | West Virginia | 54037 | 54 | 0 |
61764 | 61764 | 2020-04-15 | Jefferson | West Virginia | 54037 | 56 | 0 |
64497 | 64497 | 2020-04-16 | Jefferson | West Virginia | 54037 | 57 | 0 |
67245 | 67245 | 2020-04-17 | Jefferson | West Virginia | 54037 | 60 | 0 |
70007 | 70007 | 2020-04-18 | Jefferson | West Virginia | 54037 | 60 | 0 |
72776 | 72776 | 2020-04-19 | Jefferson | West Virginia | 54037 | 60 | 0 |
75552 | 75552 | 2020-04-20 | Jefferson | West Virginia | 54037 | 61 | 0 |
78335 | 78335 | 2020-04-21 | Jefferson | West Virginia | 54037 | 65 | 0 |
81128 | 81128 | 2020-04-22 | Jefferson | West Virginia | 54037 | 65 | 0 |
83929 | 83929 | 2020-04-23 | Jefferson | West Virginia | 54037 | 67 | 0 |
86736 | 86736 | 2020-04-24 | Jefferson | West Virginia | 54037 | 70 | 0 |
89552 | 89552 | 2020-04-25 | Jefferson | West Virginia | 54037 | 71 | 0 |
92370 | 92370 | 2020-04-26 | Jefferson | West Virginia | 54037 | 71 | 0 |
95199 | 95199 | 2020-04-27 | Jefferson | West Virginia | 54037 | 75 | 0 |
98044 | 98044 | 2020-04-28 | Jefferson | West Virginia | 54037 | 77 | 1 |
100894 | 100894 | 2020-04-29 | Jefferson | West Virginia | 54037 | 77 | 1 |
103749 | 103749 | 2020-04-30 | Jefferson | West Virginia | 54037 | 79 | 1 |
106613 | 106613 | 2020-05-01 | Jefferson | West Virginia | 54037 | 79 | 1 |
109482 | 109482 | 2020-05-02 | Jefferson | West Virginia | 54037 | 79 | 1 |
112356 | 112356 | 2020-05-03 | Jefferson | West Virginia | 54037 | 81 | 1 |
115239 | 115239 | 2020-05-04 | Jefferson | West Virginia | 54037 | 82 | 1 |
118198 | 118198 | 2020-05-05 | Jefferson | West Virginia | 54037 | 83 | 1 |
121163 | 121163 | 2020-05-06 | Jefferson | West Virginia | 54037 | 84 | 1 |
124143 | 124143 | 2020-05-07 | Jefferson | West Virginia | 54037 | 85 | 1 |
127128 | 127128 | 2020-05-08 | Jefferson | West Virginia | 54037 | 87 | 1 |
130118 | 130118 | 2020-05-09 | Jefferson | West Virginia | 54037 | 88 | 1 |
133108 | 133108 | 2020-05-10 | Jefferson | West Virginia | 54037 | 88 | 1 |
136098 | 136098 | 2020-05-11 | Jefferson | West Virginia | 54037 | 88 | 1 |
139089 | 139089 | 2020-05-12 | Jefferson | West Virginia | 54037 | 88 | 1 |
142085 | 142085 | 2020-05-13 | Jefferson | West Virginia | 54037 | 92 | 1 |
145082 | 145082 | 2020-05-14 | Jefferson | West Virginia | 54037 | 96 | 1 |
148085 | 148085 | 2020-05-15 | Jefferson | West Virginia | 54037 | 96 | 1 |
151094 | 151094 | 2020-05-16 | Jefferson | West Virginia | 54037 | 98 | 1 |
154105 | 154105 | 2020-05-17 | Jefferson | West Virginia | 54037 | 100 | 1 |
157122 | 157122 | 2020-05-18 | Jefferson | West Virginia | 54037 | 101 | 1 |
160146 | 160146 | 2020-05-19 | Jefferson | West Virginia | 54037 | 102 | 1 |
163174 | 163174 | 2020-05-20 | Jefferson | West Virginia | 54037 | 115 | 1 |
166203 | 166203 | 2020-05-21 | Jefferson | West Virginia | 54037 | 132 | 1 |
169239 | 169239 | 2020-05-22 | Jefferson | West Virginia | 54037 | 143 | 1 |
172280 | 172280 | 2020-05-23 | Jefferson | West Virginia | 54037 | 146 | 1 |
175323 | 175323 | 2020-05-24 | Jefferson | West Virginia | 54037 | 153 | 1 |
178368 | 178368 | 2020-05-25 | Jefferson | West Virginia | 54037 | 157 | 1 |
181412 | 181412 | 2020-05-26 | Jefferson | West Virginia | 54037 | 161 | 1 |
184463 | 184463 | 2020-05-27 | Jefferson | West Virginia | 54037 | 167 | 1 |
187520 | 187520 | 2020-05-28 | Jefferson | West Virginia | 54037 | 168 | 1 |
190584 | 190584 | 2020-05-29 | Jefferson | West Virginia | 54037 | 177 | 1 |
193650 | 193650 | 2020-05-30 | Jefferson | West Virginia | 54037 | 180 | 1 |
196720 | 196720 | 2020-05-31 | Jefferson | West Virginia | 54037 | 182 | 1 |
199793 | 199793 | 2020-06-01 | Jefferson | West Virginia | 54037 | 184 | 1 |
202869 | 202869 | 2020-06-02 | Jefferson | West Virginia | 54037 | 197 | 1 |
205948 | 205948 | 2020-06-03 | Jefferson | West Virginia | 54037 | 199 | 1 |
209030 | 209030 | 2020-06-04 | Jefferson | West Virginia | 54037 | 204 | 1 |
212115 | 212115 | 2020-06-05 | Jefferson | West Virginia | 54037 | 203 | 4 |
215202 | 215202 | 2020-06-06 | Jefferson | West Virginia | 54037 | 204 | 4 |
218292 | 218292 | 2020-06-07 | Jefferson | West Virginia | 54037 | 204 | 4 |
221384 | 221384 | 2020-06-08 | Jefferson | West Virginia | 54037 | 204 | 4 |
224480 | 224480 | 2020-06-09 | Jefferson | West Virginia | 54037 | 204 | 4 |
227580 | 227580 | 2020-06-10 | Jefferson | West Virginia | 54037 | 204 | 4 |
230684 | 230684 | 2020-06-11 | Jefferson | West Virginia | 54037 | 205 | 4 |
233789 | 233789 | 2020-06-12 | Jefferson | West Virginia | 54037 | 205 | 4 |
236896 | 236896 | 2020-06-13 | Jefferson | West Virginia | 54037 | 207 | 4 |
240004 | 240004 | 2020-06-14 | Jefferson | West Virginia | 54037 | 207 | 4 |
243115 | 243115 | 2020-06-15 | Jefferson | West Virginia | 54037 | 209 | 4 |
246228 | 246228 | 2020-06-16 | Jefferson | West Virginia | 54037 | 211 | 4 |
249340 | 249340 | 2020-06-17 | Jefferson | West Virginia | 54037 | 213 | 4 |
252455 | 252455 | 2020-06-18 | Jefferson | West Virginia | 54037 | 213 | 4 |
255574 | 255574 | 2020-06-19 | Jefferson | West Virginia | 54037 | 215 | 4 |
258701 | 258701 | 2020-06-20 | Jefferson | West Virginia | 54037 | 215 | 4 |
261828 | 261828 | 2020-06-21 | Jefferson | West Virginia | 54037 | 216 | 4 |
264957 | 264957 | 2020-06-22 | Jefferson | West Virginia | 54037 | 216 | 4 |
268086 | 268086 | 2020-06-23 | Jefferson | West Virginia | 54037 | 216 | 4 |
271220 | 271220 | 2020-06-24 | Jefferson | West Virginia | 54037 | 217 | 4 |
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);