ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 54097 and state = "West Virginia" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
302762 | 302762 | 2020-07-04 | Upshur | West Virginia | 54097 | 21 | 0 |
305926 | 305926 | 2020-07-05 | Upshur | West Virginia | 54097 | 21 | 0 |
309094 | 309094 | 2020-07-06 | Upshur | West Virginia | 54097 | 21 | 0 |
312263 | 312263 | 2020-07-07 | Upshur | West Virginia | 54097 | 22 | 0 |
315438 | 315438 | 2020-07-08 | Upshur | West Virginia | 54097 | 22 | 0 |
318611 | 318611 | 2020-07-09 | Upshur | West Virginia | 54097 | 23 | 0 |
321790 | 321790 | 2020-07-10 | Upshur | West Virginia | 54097 | 23 | 0 |
324971 | 324971 | 2020-07-11 | Upshur | West Virginia | 54097 | 25 | 0 |
328157 | 328157 | 2020-07-12 | Upshur | West Virginia | 54097 | 32 | 0 |
331343 | 331343 | 2020-07-13 | Upshur | West Virginia | 54097 | 33 | 0 |
334536 | 334536 | 2020-07-14 | Upshur | West Virginia | 54097 | 33 | 0 |
337731 | 337731 | 2020-07-15 | Upshur | West Virginia | 54097 | 33 | 0 |
340927 | 340927 | 2020-07-16 | Upshur | West Virginia | 54097 | 33 | 0 |
344126 | 344126 | 2020-07-17 | Upshur | West Virginia | 54097 | 33 | 0 |
347326 | 347326 | 2020-07-18 | Upshur | West Virginia | 54097 | 33 | 0 |
350527 | 350527 | 2020-07-19 | Upshur | West Virginia | 54097 | 33 | 0 |
353729 | 353729 | 2020-07-20 | Upshur | West Virginia | 54097 | 33 | 0 |
356932 | 356932 | 2020-07-21 | Upshur | West Virginia | 54097 | 33 | 0 |
360137 | 360137 | 2020-07-22 | Upshur | West Virginia | 54097 | 34 | 0 |
363343 | 363343 | 2020-07-23 | Upshur | West Virginia | 54097 | 35 | 0 |
366550 | 366550 | 2020-07-24 | Upshur | West Virginia | 54097 | 35 | 0 |
369760 | 369760 | 2020-07-25 | Upshur | West Virginia | 54097 | 35 | 0 |
372972 | 372972 | 2020-07-26 | Upshur | West Virginia | 54097 | 35 | 0 |
376186 | 376186 | 2020-07-27 | Upshur | West Virginia | 54097 | 36 | 0 |
379402 | 379402 | 2020-07-28 | Upshur | West Virginia | 54097 | 38 | 0 |
382619 | 382619 | 2020-07-29 | Upshur | West Virginia | 54097 | 38 | 0 |
385837 | 385837 | 2020-07-30 | Upshur | West Virginia | 54097 | 38 | 0 |
389054 | 389054 | 2020-07-31 | Upshur | West Virginia | 54097 | 38 | 0 |
392271 | 392271 | 2020-08-01 | Upshur | West Virginia | 54097 | 38 | 0 |
395487 | 395487 | 2020-08-02 | Upshur | West Virginia | 54097 | 38 | 0 |
398703 | 398703 | 2020-08-03 | Upshur | West Virginia | 54097 | 38 | 0 |
401919 | 401919 | 2020-08-04 | Upshur | West Virginia | 54097 | 39 | 0 |
405137 | 405137 | 2020-08-05 | Upshur | West Virginia | 54097 | 39 | 0 |
408357 | 408357 | 2020-08-06 | Upshur | West Virginia | 54097 | 39 | 0 |
411576 | 411576 | 2020-08-07 | Upshur | West Virginia | 54097 | 39 | 0 |
414796 | 414796 | 2020-08-08 | Upshur | West Virginia | 54097 | 39 | 0 |
418017 | 418017 | 2020-08-09 | Upshur | West Virginia | 54097 | 40 | 0 |
421238 | 421238 | 2020-08-10 | Upshur | West Virginia | 54097 | 40 | 0 |
424459 | 424459 | 2020-08-11 | Upshur | West Virginia | 54097 | 40 | 0 |
427683 | 427683 | 2020-08-12 | Upshur | West Virginia | 54097 | 38 | 0 |
430911 | 430911 | 2020-08-13 | Upshur | West Virginia | 54097 | 38 | 0 |
434136 | 434136 | 2020-08-14 | Upshur | West Virginia | 54097 | 38 | 0 |
437362 | 437362 | 2020-08-15 | Upshur | West Virginia | 54097 | 38 | 0 |
440588 | 440588 | 2020-08-16 | Upshur | West Virginia | 54097 | 40 | 0 |
443814 | 443814 | 2020-08-17 | Upshur | West Virginia | 54097 | 39 | 0 |
447041 | 447041 | 2020-08-18 | Upshur | West Virginia | 54097 | 40 | 0 |
450269 | 450269 | 2020-08-19 | Upshur | West Virginia | 54097 | 40 | 0 |
453497 | 453497 | 2020-08-20 | Upshur | West Virginia | 54097 | 40 | 0 |
456725 | 456725 | 2020-08-21 | Upshur | West Virginia | 54097 | 41 | 0 |
459952 | 459952 | 2020-08-22 | Upshur | West Virginia | 54097 | 40 | 0 |
463181 | 463181 | 2020-08-23 | Upshur | West Virginia | 54097 | 40 | 0 |
466410 | 466410 | 2020-08-24 | Upshur | West Virginia | 54097 | 40 | 0 |
469639 | 469639 | 2020-08-25 | Upshur | West Virginia | 54097 | 40 | 0 |
472871 | 472871 | 2020-08-26 | Upshur | West Virginia | 54097 | 41 | 0 |
476104 | 476104 | 2020-08-27 | Upshur | West Virginia | 54097 | 43 | 0 |
479337 | 479337 | 2020-08-28 | Upshur | West Virginia | 54097 | 43 | 0 |
482571 | 482571 | 2020-08-29 | Upshur | West Virginia | 54097 | 43 | 0 |
485806 | 485806 | 2020-08-30 | Upshur | West Virginia | 54097 | 43 | 0 |
489039 | 489039 | 2020-08-31 | Upshur | West Virginia | 54097 | 43 | 0 |
492272 | 492272 | 2020-09-01 | Upshur | West Virginia | 54097 | 43 | 0 |
495506 | 495506 | 2020-09-02 | Upshur | West Virginia | 54097 | 45 | 0 |
498739 | 498739 | 2020-09-03 | Upshur | West Virginia | 54097 | 45 | 0 |
501973 | 501973 | 2020-09-04 | Upshur | West Virginia | 54097 | 45 | 0 |
505207 | 505207 | 2020-09-05 | Upshur | West Virginia | 54097 | 46 | 0 |
508439 | 508439 | 2020-09-06 | Upshur | West Virginia | 54097 | 45 | 0 |
511672 | 511672 | 2020-09-07 | Upshur | West Virginia | 54097 | 46 | 0 |
514905 | 514905 | 2020-09-08 | Upshur | West Virginia | 54097 | 50 | 0 |
518140 | 518140 | 2020-09-09 | Upshur | West Virginia | 54097 | 50 | 0 |
521377 | 521377 | 2020-09-10 | Upshur | West Virginia | 54097 | 51 | 0 |
524613 | 524613 | 2020-09-11 | Upshur | West Virginia | 54097 | 57 | 0 |
527849 | 527849 | 2020-09-12 | Upshur | West Virginia | 54097 | 58 | 0 |
531086 | 531086 | 2020-09-13 | Upshur | West Virginia | 54097 | 58 | 0 |
534321 | 534321 | 2020-09-14 | Upshur | West Virginia | 54097 | 59 | 0 |
537557 | 537557 | 2020-09-15 | Upshur | West Virginia | 54097 | 59 | 0 |
540794 | 540794 | 2020-09-16 | Upshur | West Virginia | 54097 | 60 | 0 |
544030 | 544030 | 2020-09-17 | Upshur | West Virginia | 54097 | 60 | 0 |
547267 | 547267 | 2020-09-18 | Upshur | West Virginia | 54097 | 60 | 0 |
550506 | 550506 | 2020-09-19 | Upshur | West Virginia | 54097 | 60 | 0 |
553745 | 553745 | 2020-09-20 | Upshur | West Virginia | 54097 | 60 | 0 |
556982 | 556982 | 2020-09-21 | Upshur | West Virginia | 54097 | 60 | 0 |
560218 | 560218 | 2020-09-22 | Upshur | West Virginia | 54097 | 61 | 0 |
563457 | 563457 | 2020-09-23 | Upshur | West Virginia | 54097 | 63 | 0 |
566698 | 566698 | 2020-09-24 | Upshur | West Virginia | 54097 | 64 | 0 |
569939 | 569939 | 2020-09-25 | Upshur | West Virginia | 54097 | 64 | 0 |
573181 | 573181 | 2020-09-26 | Upshur | West Virginia | 54097 | 71 | 0 |
576425 | 576425 | 2020-09-27 | Upshur | West Virginia | 54097 | 77 | 0 |
579666 | 579666 | 2020-09-28 | Upshur | West Virginia | 54097 | 81 | 0 |
582905 | 582905 | 2020-09-29 | Upshur | West Virginia | 54097 | 84 | 0 |
586145 | 586145 | 2020-09-30 | Upshur | West Virginia | 54097 | 87 | 0 |
589386 | 589386 | 2020-10-01 | Upshur | West Virginia | 54097 | 91 | 0 |
592626 | 592626 | 2020-10-02 | Upshur | West Virginia | 54097 | 97 | 0 |
595868 | 595868 | 2020-10-03 | Upshur | West Virginia | 54097 | 110 | 0 |
599111 | 599111 | 2020-10-04 | Upshur | West Virginia | 54097 | 117 | 0 |
602354 | 602354 | 2020-10-05 | Upshur | West Virginia | 54097 | 117 | 0 |
605596 | 605596 | 2020-10-06 | Upshur | West Virginia | 54097 | 127 | 0 |
608839 | 608839 | 2020-10-07 | Upshur | West Virginia | 54097 | 146 | 0 |
612081 | 612081 | 2020-10-08 | Upshur | West Virginia | 54097 | 150 | 0 |
615322 | 615322 | 2020-10-09 | Upshur | West Virginia | 54097 | 168 | 0 |
618564 | 618564 | 2020-10-10 | Upshur | West Virginia | 54097 | 175 | 0 |
621807 | 621807 | 2020-10-11 | Upshur | West Virginia | 54097 | 179 | 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);