ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Ohio" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
638013 | 638013 | 2020-10-16 | Ohio | West Virginia | 54069 | 443 | 7 |
634768 | 634768 | 2020-10-15 | Ohio | West Virginia | 54069 | 433 | 7 |
631523 | 631523 | 2020-10-14 | Ohio | West Virginia | 54069 | 421 | 7 |
628279 | 628279 | 2020-10-13 | Ohio | West Virginia | 54069 | 417 | 7 |
625036 | 625036 | 2020-10-12 | Ohio | West Virginia | 54069 | 415 | 7 |
621793 | 621793 | 2020-10-11 | Ohio | West Virginia | 54069 | 414 | 7 |
618550 | 618550 | 2020-10-10 | Ohio | West Virginia | 54069 | 409 | 7 |
615308 | 615308 | 2020-10-09 | Ohio | West Virginia | 54069 | 408 | 7 |
612067 | 612067 | 2020-10-08 | Ohio | West Virginia | 54069 | 396 | 7 |
608825 | 608825 | 2020-10-07 | Ohio | West Virginia | 54069 | 392 | 7 |
605582 | 605582 | 2020-10-06 | Ohio | West Virginia | 54069 | 384 | 7 |
602340 | 602340 | 2020-10-05 | Ohio | West Virginia | 54069 | 381 | 7 |
599097 | 599097 | 2020-10-04 | Ohio | West Virginia | 54069 | 383 | 7 |
595854 | 595854 | 2020-10-03 | Ohio | West Virginia | 54069 | 380 | 7 |
592612 | 592612 | 2020-10-02 | Ohio | West Virginia | 54069 | 378 | 7 |
589372 | 589372 | 2020-10-01 | Ohio | West Virginia | 54069 | 375 | 7 |
586131 | 586131 | 2020-09-30 | Ohio | West Virginia | 54069 | 375 | 6 |
582891 | 582891 | 2020-09-29 | Ohio | West Virginia | 54069 | 374 | 6 |
579652 | 579652 | 2020-09-28 | Ohio | West Virginia | 54069 | 373 | 6 |
576411 | 576411 | 2020-09-27 | Ohio | West Virginia | 54069 | 373 | 6 |
573167 | 573167 | 2020-09-26 | Ohio | West Virginia | 54069 | 368 | 6 |
569925 | 569925 | 2020-09-25 | Ohio | West Virginia | 54069 | 367 | 6 |
566684 | 566684 | 2020-09-24 | Ohio | West Virginia | 54069 | 362 | 6 |
563443 | 563443 | 2020-09-23 | Ohio | West Virginia | 54069 | 359 | 6 |
560204 | 560204 | 2020-09-22 | Ohio | West Virginia | 54069 | 358 | 6 |
556968 | 556968 | 2020-09-21 | Ohio | West Virginia | 54069 | 356 | 6 |
553731 | 553731 | 2020-09-20 | Ohio | West Virginia | 54069 | 351 | 6 |
550492 | 550492 | 2020-09-19 | Ohio | West Virginia | 54069 | 349 | 6 |
547253 | 547253 | 2020-09-18 | Ohio | West Virginia | 54069 | 349 | 6 |
544016 | 544016 | 2020-09-17 | Ohio | West Virginia | 54069 | 343 | 6 |
540780 | 540780 | 2020-09-16 | Ohio | West Virginia | 54069 | 340 | 6 |
537543 | 537543 | 2020-09-15 | Ohio | West Virginia | 54069 | 334 | 6 |
534307 | 534307 | 2020-09-14 | Ohio | West Virginia | 54069 | 332 | 6 |
531072 | 531072 | 2020-09-13 | Ohio | West Virginia | 54069 | 328 | 6 |
527835 | 527835 | 2020-09-12 | Ohio | West Virginia | 54069 | 325 | 6 |
524599 | 524599 | 2020-09-11 | Ohio | West Virginia | 54069 | 313 | 6 |
521363 | 521363 | 2020-09-10 | Ohio | West Virginia | 54069 | 302 | 6 |
518126 | 518126 | 2020-09-09 | Ohio | West Virginia | 54069 | 301 | 6 |
514891 | 514891 | 2020-09-08 | Ohio | West Virginia | 54069 | 297 | 6 |
511658 | 511658 | 2020-09-07 | Ohio | West Virginia | 54069 | 297 | 6 |
508425 | 508425 | 2020-09-06 | Ohio | West Virginia | 54069 | 296 | 6 |
505193 | 505193 | 2020-09-05 | Ohio | West Virginia | 54069 | 294 | 6 |
501959 | 501959 | 2020-09-04 | Ohio | West Virginia | 54069 | 292 | 6 |
498725 | 498725 | 2020-09-03 | Ohio | West Virginia | 54069 | 291 | 6 |
495492 | 495492 | 2020-09-02 | Ohio | West Virginia | 54069 | 289 | 6 |
492258 | 492258 | 2020-09-01 | Ohio | West Virginia | 54069 | 291 | 5 |
489025 | 489025 | 2020-08-31 | Ohio | West Virginia | 54069 | 293 | 5 |
485792 | 485792 | 2020-08-30 | Ohio | West Virginia | 54069 | 290 | 5 |
482557 | 482557 | 2020-08-29 | Ohio | West Virginia | 54069 | 290 | 5 |
479323 | 479323 | 2020-08-28 | Ohio | West Virginia | 54069 | 289 | 5 |
476090 | 476090 | 2020-08-27 | Ohio | West Virginia | 54069 | 288 | 5 |
472857 | 472857 | 2020-08-26 | Ohio | West Virginia | 54069 | 289 | 5 |
469625 | 469625 | 2020-08-25 | Ohio | West Virginia | 54069 | 289 | 4 |
466396 | 466396 | 2020-08-24 | Ohio | West Virginia | 54069 | 288 | 4 |
463167 | 463167 | 2020-08-23 | Ohio | West Virginia | 54069 | 288 | 4 |
459938 | 459938 | 2020-08-22 | Ohio | West Virginia | 54069 | 286 | 4 |
456711 | 456711 | 2020-08-21 | Ohio | West Virginia | 54069 | 284 | 4 |
453483 | 453483 | 2020-08-20 | Ohio | West Virginia | 54069 | 283 | 4 |
450255 | 450255 | 2020-08-19 | Ohio | West Virginia | 54069 | 284 | 4 |
447027 | 447027 | 2020-08-18 | Ohio | West Virginia | 54069 | 285 | 4 |
443800 | 443800 | 2020-08-17 | Ohio | West Virginia | 54069 | 283 | 4 |
440574 | 440574 | 2020-08-16 | Ohio | West Virginia | 54069 | 279 | 4 |
437348 | 437348 | 2020-08-15 | Ohio | West Virginia | 54069 | 278 | 4 |
434122 | 434122 | 2020-08-14 | Ohio | West Virginia | 54069 | 275 | 4 |
430897 | 430897 | 2020-08-13 | Ohio | West Virginia | 54069 | 271 | 4 |
427669 | 427669 | 2020-08-12 | Ohio | West Virginia | 54069 | 272 | 4 |
424445 | 424445 | 2020-08-11 | Ohio | West Virginia | 54069 | 272 | 4 |
421224 | 421224 | 2020-08-10 | Ohio | West Virginia | 54069 | 269 | 4 |
418003 | 418003 | 2020-08-09 | Ohio | West Virginia | 54069 | 268 | 4 |
414782 | 414782 | 2020-08-08 | Ohio | West Virginia | 54069 | 266 | 4 |
411562 | 411562 | 2020-08-07 | Ohio | West Virginia | 54069 | 266 | 4 |
408343 | 408343 | 2020-08-06 | Ohio | West Virginia | 54069 | 265 | 4 |
405123 | 405123 | 2020-08-05 | Ohio | West Virginia | 54069 | 263 | 4 |
401905 | 401905 | 2020-08-04 | Ohio | West Virginia | 54069 | 260 | 4 |
398689 | 398689 | 2020-08-03 | Ohio | West Virginia | 54069 | 255 | 4 |
395473 | 395473 | 2020-08-02 | Ohio | West Virginia | 54069 | 252 | 4 |
392257 | 392257 | 2020-08-01 | Ohio | West Virginia | 54069 | 249 | 4 |
389040 | 389040 | 2020-07-31 | Ohio | West Virginia | 54069 | 248 | 4 |
385823 | 385823 | 2020-07-30 | Ohio | West Virginia | 54069 | 244 | 4 |
382605 | 382605 | 2020-07-29 | Ohio | West Virginia | 54069 | 243 | 3 |
379388 | 379388 | 2020-07-28 | Ohio | West Virginia | 54069 | 241 | 3 |
376172 | 376172 | 2020-07-27 | Ohio | West Virginia | 54069 | 229 | 3 |
372958 | 372958 | 2020-07-26 | Ohio | West Virginia | 54069 | 230 | 3 |
369746 | 369746 | 2020-07-25 | Ohio | West Virginia | 54069 | 228 | 3 |
366536 | 366536 | 2020-07-24 | Ohio | West Virginia | 54069 | 217 | 3 |
363329 | 363329 | 2020-07-23 | Ohio | West Virginia | 54069 | 216 | 3 |
360123 | 360123 | 2020-07-22 | Ohio | West Virginia | 54069 | 210 | 3 |
356918 | 356918 | 2020-07-21 | Ohio | West Virginia | 54069 | 181 | 3 |
353715 | 353715 | 2020-07-20 | Ohio | West Virginia | 54069 | 179 | 3 |
350513 | 350513 | 2020-07-19 | Ohio | West Virginia | 54069 | 177 | 3 |
347312 | 347312 | 2020-07-18 | Ohio | West Virginia | 54069 | 174 | 3 |
344112 | 344112 | 2020-07-17 | Ohio | West Virginia | 54069 | 173 | 3 |
340913 | 340913 | 2020-07-16 | Ohio | West Virginia | 54069 | 162 | 3 |
337717 | 337717 | 2020-07-15 | Ohio | West Virginia | 54069 | 158 | 3 |
334522 | 334522 | 2020-07-14 | Ohio | West Virginia | 54069 | 148 | 3 |
331329 | 331329 | 2020-07-13 | Ohio | West Virginia | 54069 | 147 | 3 |
328143 | 328143 | 2020-07-12 | Ohio | West Virginia | 54069 | 148 | 2 |
324957 | 324957 | 2020-07-11 | Ohio | West Virginia | 54069 | 140 | 2 |
321776 | 321776 | 2020-07-10 | Ohio | West Virginia | 54069 | 138 | 1 |
318597 | 318597 | 2020-07-09 | Ohio | West Virginia | 54069 | 122 | 1 |
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);