ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Jefferson" and fips = 54037 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
389024 | 389024 | 2020-07-31 | Jefferson | West Virginia | 54037 | 288 | 4 |
385807 | 385807 | 2020-07-30 | Jefferson | West Virginia | 54037 | 286 | 4 |
382589 | 382589 | 2020-07-29 | Jefferson | West Virginia | 54037 | 285 | 4 |
379372 | 379372 | 2020-07-28 | Jefferson | West Virginia | 54037 | 285 | 4 |
376156 | 376156 | 2020-07-27 | Jefferson | West Virginia | 54037 | 284 | 4 |
372942 | 372942 | 2020-07-26 | Jefferson | West Virginia | 54037 | 284 | 4 |
369730 | 369730 | 2020-07-25 | Jefferson | West Virginia | 54037 | 280 | 4 |
366520 | 366520 | 2020-07-24 | Jefferson | West Virginia | 54037 | 278 | 4 |
363313 | 363313 | 2020-07-23 | Jefferson | West Virginia | 54037 | 277 | 4 |
360107 | 360107 | 2020-07-22 | Jefferson | West Virginia | 54037 | 276 | 4 |
356902 | 356902 | 2020-07-21 | Jefferson | West Virginia | 54037 | 274 | 4 |
353699 | 353699 | 2020-07-20 | Jefferson | West Virginia | 54037 | 274 | 4 |
350497 | 350497 | 2020-07-19 | Jefferson | West Virginia | 54037 | 273 | 4 |
347296 | 347296 | 2020-07-18 | Jefferson | West Virginia | 54037 | 269 | 4 |
344096 | 344096 | 2020-07-17 | Jefferson | West Virginia | 54037 | 267 | 4 |
340897 | 340897 | 2020-07-16 | Jefferson | West Virginia | 54037 | 262 | 4 |
337701 | 337701 | 2020-07-15 | Jefferson | West Virginia | 54037 | 261 | 4 |
334506 | 334506 | 2020-07-14 | Jefferson | West Virginia | 54037 | 258 | 4 |
331313 | 331313 | 2020-07-13 | Jefferson | West Virginia | 54037 | 258 | 4 |
328127 | 328127 | 2020-07-12 | Jefferson | West Virginia | 54037 | 256 | 4 |
324941 | 324941 | 2020-07-11 | Jefferson | West Virginia | 54037 | 253 | 4 |
321760 | 321760 | 2020-07-10 | Jefferson | West Virginia | 54037 | 253 | 4 |
318581 | 318581 | 2020-07-09 | Jefferson | West Virginia | 54037 | 252 | 4 |
315408 | 315408 | 2020-07-08 | Jefferson | West Virginia | 54037 | 249 | 4 |
312233 | 312233 | 2020-07-07 | Jefferson | West Virginia | 54037 | 249 | 4 |
309064 | 309064 | 2020-07-06 | Jefferson | West Virginia | 54037 | 245 | 4 |
305896 | 305896 | 2020-07-05 | Jefferson | West Virginia | 54037 | 243 | 4 |
302732 | 302732 | 2020-07-04 | Jefferson | West Virginia | 54037 | 241 | 4 |
299568 | 299568 | 2020-07-03 | Jefferson | West Virginia | 54037 | 238 | 4 |
296406 | 296406 | 2020-07-02 | Jefferson | West Virginia | 54037 | 234 | 4 |
293251 | 293251 | 2020-07-01 | Jefferson | West Virginia | 54037 | 232 | 4 |
290098 | 290098 | 2020-06-30 | Jefferson | West Virginia | 54037 | 229 | 4 |
286948 | 286948 | 2020-06-29 | Jefferson | West Virginia | 54037 | 224 | 4 |
283802 | 283802 | 2020-06-28 | Jefferson | West Virginia | 54037 | 224 | 4 |
280656 | 280656 | 2020-06-27 | Jefferson | West Virginia | 54037 | 222 | 4 |
277508 | 277508 | 2020-06-26 | Jefferson | West Virginia | 54037 | 219 | 4 |
274360 | 274360 | 2020-06-25 | Jefferson | West Virginia | 54037 | 219 | 4 |
271220 | 271220 | 2020-06-24 | Jefferson | West Virginia | 54037 | 217 | 4 |
268086 | 268086 | 2020-06-23 | Jefferson | West Virginia | 54037 | 216 | 4 |
264957 | 264957 | 2020-06-22 | Jefferson | West Virginia | 54037 | 216 | 4 |
261828 | 261828 | 2020-06-21 | Jefferson | West Virginia | 54037 | 216 | 4 |
258701 | 258701 | 2020-06-20 | Jefferson | West Virginia | 54037 | 215 | 4 |
255574 | 255574 | 2020-06-19 | Jefferson | West Virginia | 54037 | 215 | 4 |
252455 | 252455 | 2020-06-18 | Jefferson | West Virginia | 54037 | 213 | 4 |
249340 | 249340 | 2020-06-17 | Jefferson | West Virginia | 54037 | 213 | 4 |
246228 | 246228 | 2020-06-16 | Jefferson | West Virginia | 54037 | 211 | 4 |
243115 | 243115 | 2020-06-15 | Jefferson | West Virginia | 54037 | 209 | 4 |
240004 | 240004 | 2020-06-14 | Jefferson | West Virginia | 54037 | 207 | 4 |
236896 | 236896 | 2020-06-13 | Jefferson | West Virginia | 54037 | 207 | 4 |
233789 | 233789 | 2020-06-12 | Jefferson | West Virginia | 54037 | 205 | 4 |
230684 | 230684 | 2020-06-11 | Jefferson | West Virginia | 54037 | 205 | 4 |
227580 | 227580 | 2020-06-10 | Jefferson | West Virginia | 54037 | 204 | 4 |
224480 | 224480 | 2020-06-09 | Jefferson | West Virginia | 54037 | 204 | 4 |
221384 | 221384 | 2020-06-08 | Jefferson | West Virginia | 54037 | 204 | 4 |
218292 | 218292 | 2020-06-07 | Jefferson | West Virginia | 54037 | 204 | 4 |
215202 | 215202 | 2020-06-06 | Jefferson | West Virginia | 54037 | 204 | 4 |
212115 | 212115 | 2020-06-05 | Jefferson | West Virginia | 54037 | 203 | 4 |
209030 | 209030 | 2020-06-04 | Jefferson | West Virginia | 54037 | 204 | 1 |
205948 | 205948 | 2020-06-03 | Jefferson | West Virginia | 54037 | 199 | 1 |
202869 | 202869 | 2020-06-02 | Jefferson | West Virginia | 54037 | 197 | 1 |
199793 | 199793 | 2020-06-01 | Jefferson | West Virginia | 54037 | 184 | 1 |
196720 | 196720 | 2020-05-31 | Jefferson | West Virginia | 54037 | 182 | 1 |
193650 | 193650 | 2020-05-30 | Jefferson | West Virginia | 54037 | 180 | 1 |
190584 | 190584 | 2020-05-29 | Jefferson | West Virginia | 54037 | 177 | 1 |
187520 | 187520 | 2020-05-28 | Jefferson | West Virginia | 54037 | 168 | 1 |
184463 | 184463 | 2020-05-27 | Jefferson | West Virginia | 54037 | 167 | 1 |
181412 | 181412 | 2020-05-26 | Jefferson | West Virginia | 54037 | 161 | 1 |
178368 | 178368 | 2020-05-25 | Jefferson | West Virginia | 54037 | 157 | 1 |
175323 | 175323 | 2020-05-24 | Jefferson | West Virginia | 54037 | 153 | 1 |
172280 | 172280 | 2020-05-23 | Jefferson | West Virginia | 54037 | 146 | 1 |
169239 | 169239 | 2020-05-22 | Jefferson | West Virginia | 54037 | 143 | 1 |
166203 | 166203 | 2020-05-21 | Jefferson | West Virginia | 54037 | 132 | 1 |
163174 | 163174 | 2020-05-20 | Jefferson | West Virginia | 54037 | 115 | 1 |
160146 | 160146 | 2020-05-19 | Jefferson | West Virginia | 54037 | 102 | 1 |
157122 | 157122 | 2020-05-18 | Jefferson | West Virginia | 54037 | 101 | 1 |
154105 | 154105 | 2020-05-17 | Jefferson | West Virginia | 54037 | 100 | 1 |
151094 | 151094 | 2020-05-16 | Jefferson | West Virginia | 54037 | 98 | 1 |
148085 | 148085 | 2020-05-15 | Jefferson | West Virginia | 54037 | 96 | 1 |
145082 | 145082 | 2020-05-14 | Jefferson | West Virginia | 54037 | 96 | 1 |
142085 | 142085 | 2020-05-13 | Jefferson | West Virginia | 54037 | 92 | 1 |
139089 | 139089 | 2020-05-12 | Jefferson | West Virginia | 54037 | 88 | 1 |
136098 | 136098 | 2020-05-11 | Jefferson | West Virginia | 54037 | 88 | 1 |
133108 | 133108 | 2020-05-10 | Jefferson | West Virginia | 54037 | 88 | 1 |
130118 | 130118 | 2020-05-09 | Jefferson | West Virginia | 54037 | 88 | 1 |
127128 | 127128 | 2020-05-08 | Jefferson | West Virginia | 54037 | 87 | 1 |
124143 | 124143 | 2020-05-07 | Jefferson | West Virginia | 54037 | 85 | 1 |
121163 | 121163 | 2020-05-06 | Jefferson | West Virginia | 54037 | 84 | 1 |
118198 | 118198 | 2020-05-05 | Jefferson | West Virginia | 54037 | 83 | 1 |
115239 | 115239 | 2020-05-04 | Jefferson | West Virginia | 54037 | 82 | 1 |
112356 | 112356 | 2020-05-03 | Jefferson | West Virginia | 54037 | 81 | 1 |
109482 | 109482 | 2020-05-02 | Jefferson | West Virginia | 54037 | 79 | 1 |
106613 | 106613 | 2020-05-01 | Jefferson | West Virginia | 54037 | 79 | 1 |
103749 | 103749 | 2020-04-30 | Jefferson | West Virginia | 54037 | 79 | 1 |
100894 | 100894 | 2020-04-29 | Jefferson | West Virginia | 54037 | 77 | 1 |
98044 | 98044 | 2020-04-28 | Jefferson | West Virginia | 54037 | 77 | 1 |
95199 | 95199 | 2020-04-27 | Jefferson | West Virginia | 54037 | 75 | 0 |
92370 | 92370 | 2020-04-26 | Jefferson | West Virginia | 54037 | 71 | 0 |
89552 | 89552 | 2020-04-25 | Jefferson | West Virginia | 54037 | 71 | 0 |
86736 | 86736 | 2020-04-24 | Jefferson | West Virginia | 54037 | 70 | 0 |
83929 | 83929 | 2020-04-23 | Jefferson | West Virginia | 54037 | 67 | 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);