ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
677 rows where fips = 54101 and state = "West Virginia" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
309096 | 309096 | 2020-07-06 | Webster | West Virginia | 54101 | 1 | 0 |
312265 | 312265 | 2020-07-07 | Webster | West Virginia | 54101 | 1 | 0 |
315440 | 315440 | 2020-07-08 | Webster | West Virginia | 54101 | 1 | 0 |
318613 | 318613 | 2020-07-09 | Webster | West Virginia | 54101 | 1 | 0 |
321792 | 321792 | 2020-07-10 | Webster | West Virginia | 54101 | 1 | 0 |
324973 | 324973 | 2020-07-11 | Webster | West Virginia | 54101 | 1 | 0 |
328159 | 328159 | 2020-07-12 | Webster | West Virginia | 54101 | 1 | 0 |
331345 | 331345 | 2020-07-13 | Webster | West Virginia | 54101 | 1 | 0 |
334538 | 334538 | 2020-07-14 | Webster | West Virginia | 54101 | 1 | 0 |
337733 | 337733 | 2020-07-15 | Webster | West Virginia | 54101 | 1 | 0 |
340929 | 340929 | 2020-07-16 | Webster | West Virginia | 54101 | 1 | 0 |
344128 | 344128 | 2020-07-17 | Webster | West Virginia | 54101 | 2 | 0 |
347328 | 347328 | 2020-07-18 | Webster | West Virginia | 54101 | 2 | 0 |
350529 | 350529 | 2020-07-19 | Webster | West Virginia | 54101 | 2 | 0 |
353731 | 353731 | 2020-07-20 | Webster | West Virginia | 54101 | 2 | 0 |
356934 | 356934 | 2020-07-21 | Webster | West Virginia | 54101 | 2 | 0 |
360139 | 360139 | 2020-07-22 | Webster | West Virginia | 54101 | 3 | 0 |
363345 | 363345 | 2020-07-23 | Webster | West Virginia | 54101 | 3 | 0 |
366552 | 366552 | 2020-07-24 | Webster | West Virginia | 54101 | 3 | 0 |
369762 | 369762 | 2020-07-25 | Webster | West Virginia | 54101 | 3 | 0 |
372974 | 372974 | 2020-07-26 | Webster | West Virginia | 54101 | 3 | 0 |
376188 | 376188 | 2020-07-27 | Webster | West Virginia | 54101 | 3 | 0 |
379404 | 379404 | 2020-07-28 | Webster | West Virginia | 54101 | 3 | 0 |
382621 | 382621 | 2020-07-29 | Webster | West Virginia | 54101 | 3 | 0 |
385839 | 385839 | 2020-07-30 | Webster | West Virginia | 54101 | 3 | 0 |
389056 | 389056 | 2020-07-31 | Webster | West Virginia | 54101 | 3 | 0 |
392273 | 392273 | 2020-08-01 | Webster | West Virginia | 54101 | 3 | 0 |
395489 | 395489 | 2020-08-02 | Webster | West Virginia | 54101 | 3 | 0 |
398705 | 398705 | 2020-08-03 | Webster | West Virginia | 54101 | 3 | 0 |
401921 | 401921 | 2020-08-04 | Webster | West Virginia | 54101 | 3 | 0 |
405139 | 405139 | 2020-08-05 | Webster | West Virginia | 54101 | 3 | 0 |
408359 | 408359 | 2020-08-06 | Webster | West Virginia | 54101 | 4 | 0 |
411578 | 411578 | 2020-08-07 | Webster | West Virginia | 54101 | 4 | 0 |
414798 | 414798 | 2020-08-08 | Webster | West Virginia | 54101 | 4 | 0 |
418019 | 418019 | 2020-08-09 | Webster | West Virginia | 54101 | 4 | 0 |
421240 | 421240 | 2020-08-10 | Webster | West Virginia | 54101 | 4 | 0 |
424461 | 424461 | 2020-08-11 | Webster | West Virginia | 54101 | 4 | 0 |
427685 | 427685 | 2020-08-12 | Webster | West Virginia | 54101 | 4 | 0 |
430913 | 430913 | 2020-08-13 | Webster | West Virginia | 54101 | 4 | 0 |
434138 | 434138 | 2020-08-14 | Webster | West Virginia | 54101 | 4 | 0 |
437364 | 437364 | 2020-08-15 | Webster | West Virginia | 54101 | 4 | 0 |
440590 | 440590 | 2020-08-16 | Webster | West Virginia | 54101 | 4 | 0 |
443816 | 443816 | 2020-08-17 | Webster | West Virginia | 54101 | 4 | 0 |
447043 | 447043 | 2020-08-18 | Webster | West Virginia | 54101 | 6 | 0 |
450271 | 450271 | 2020-08-19 | Webster | West Virginia | 54101 | 7 | 0 |
453499 | 453499 | 2020-08-20 | Webster | West Virginia | 54101 | 7 | 0 |
456727 | 456727 | 2020-08-21 | Webster | West Virginia | 54101 | 7 | 0 |
459954 | 459954 | 2020-08-22 | Webster | West Virginia | 54101 | 7 | 0 |
463183 | 463183 | 2020-08-23 | Webster | West Virginia | 54101 | 7 | 0 |
466412 | 466412 | 2020-08-24 | Webster | West Virginia | 54101 | 7 | 0 |
469641 | 469641 | 2020-08-25 | Webster | West Virginia | 54101 | 7 | 0 |
472873 | 472873 | 2020-08-26 | Webster | West Virginia | 54101 | 7 | 0 |
476106 | 476106 | 2020-08-27 | Webster | West Virginia | 54101 | 7 | 0 |
479339 | 479339 | 2020-08-28 | Webster | West Virginia | 54101 | 7 | 0 |
482573 | 482573 | 2020-08-29 | Webster | West Virginia | 54101 | 7 | 0 |
485808 | 485808 | 2020-08-30 | Webster | West Virginia | 54101 | 7 | 0 |
489041 | 489041 | 2020-08-31 | Webster | West Virginia | 54101 | 7 | 0 |
492274 | 492274 | 2020-09-01 | Webster | West Virginia | 54101 | 7 | 0 |
495508 | 495508 | 2020-09-02 | Webster | West Virginia | 54101 | 7 | 0 |
498741 | 498741 | 2020-09-03 | Webster | West Virginia | 54101 | 7 | 0 |
501975 | 501975 | 2020-09-04 | Webster | West Virginia | 54101 | 7 | 0 |
505209 | 505209 | 2020-09-05 | Webster | West Virginia | 54101 | 7 | 0 |
508441 | 508441 | 2020-09-06 | Webster | West Virginia | 54101 | 7 | 0 |
511674 | 511674 | 2020-09-07 | Webster | West Virginia | 54101 | 7 | 0 |
514907 | 514907 | 2020-09-08 | Webster | West Virginia | 54101 | 7 | 0 |
518142 | 518142 | 2020-09-09 | Webster | West Virginia | 54101 | 7 | 0 |
521379 | 521379 | 2020-09-10 | Webster | West Virginia | 54101 | 7 | 0 |
524615 | 524615 | 2020-09-11 | Webster | West Virginia | 54101 | 7 | 0 |
527851 | 527851 | 2020-09-12 | Webster | West Virginia | 54101 | 7 | 0 |
531088 | 531088 | 2020-09-13 | Webster | West Virginia | 54101 | 7 | 0 |
534323 | 534323 | 2020-09-14 | Webster | West Virginia | 54101 | 7 | 0 |
537559 | 537559 | 2020-09-15 | Webster | West Virginia | 54101 | 7 | 0 |
540796 | 540796 | 2020-09-16 | Webster | West Virginia | 54101 | 7 | 0 |
544032 | 544032 | 2020-09-17 | Webster | West Virginia | 54101 | 7 | 0 |
547269 | 547269 | 2020-09-18 | Webster | West Virginia | 54101 | 7 | 0 |
550508 | 550508 | 2020-09-19 | Webster | West Virginia | 54101 | 7 | 0 |
553747 | 553747 | 2020-09-20 | Webster | West Virginia | 54101 | 7 | 0 |
556984 | 556984 | 2020-09-21 | Webster | West Virginia | 54101 | 7 | 0 |
560220 | 560220 | 2020-09-22 | Webster | West Virginia | 54101 | 7 | 0 |
563459 | 563459 | 2020-09-23 | Webster | West Virginia | 54101 | 7 | 0 |
566700 | 566700 | 2020-09-24 | Webster | West Virginia | 54101 | 7 | 0 |
569941 | 569941 | 2020-09-25 | Webster | West Virginia | 54101 | 7 | 0 |
573183 | 573183 | 2020-09-26 | Webster | West Virginia | 54101 | 8 | 0 |
576427 | 576427 | 2020-09-27 | Webster | West Virginia | 54101 | 8 | 0 |
579668 | 579668 | 2020-09-28 | Webster | West Virginia | 54101 | 8 | 0 |
582907 | 582907 | 2020-09-29 | Webster | West Virginia | 54101 | 8 | 0 |
586147 | 586147 | 2020-09-30 | Webster | West Virginia | 54101 | 7 | 0 |
589388 | 589388 | 2020-10-01 | Webster | West Virginia | 54101 | 7 | 0 |
592628 | 592628 | 2020-10-02 | Webster | West Virginia | 54101 | 8 | 0 |
595870 | 595870 | 2020-10-03 | Webster | West Virginia | 54101 | 8 | 0 |
599113 | 599113 | 2020-10-04 | Webster | West Virginia | 54101 | 8 | 0 |
602356 | 602356 | 2020-10-05 | Webster | West Virginia | 54101 | 8 | 0 |
605598 | 605598 | 2020-10-06 | Webster | West Virginia | 54101 | 9 | 0 |
608841 | 608841 | 2020-10-07 | Webster | West Virginia | 54101 | 9 | 0 |
612083 | 612083 | 2020-10-08 | Webster | West Virginia | 54101 | 9 | 0 |
615324 | 615324 | 2020-10-09 | Webster | West Virginia | 54101 | 9 | 0 |
618566 | 618566 | 2020-10-10 | Webster | West Virginia | 54101 | 9 | 0 |
621809 | 621809 | 2020-10-11 | Webster | West Virginia | 54101 | 13 | 0 |
625052 | 625052 | 2020-10-12 | Webster | West Virginia | 54101 | 13 | 0 |
628295 | 628295 | 2020-10-13 | Webster | West Virginia | 54101 | 14 | 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);