ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 65 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 |
---|---|---|---|---|---|---|---|
748320 | 748320 | 2020-11-19 | Pleasants | West Virginia | 54073 | 65 | 3 |
732106 | 732106 | 2020-11-14 | Wirt | West Virginia | 54105 | 65 | 1 |
702904 | 702904 | 2020-11-05 | Ritchie | West Virginia | 54085 | 65 | 0 |
696382 | 696382 | 2020-11-03 | Clay | West Virginia | 54015 | 65 | 3 |
693140 | 693140 | 2020-11-02 | Clay | West Virginia | 54015 | 65 | 3 |
693143 | 693143 | 2020-11-02 | Gilmer | West Virginia | 54021 | 65 | 0 |
689896 | 689896 | 2020-11-01 | Clay | West Virginia | 54015 | 65 | 3 |
689899 | 689899 | 2020-11-01 | Gilmer | West Virginia | 54021 | 65 | 0 |
686651 | 686651 | 2020-10-31 | Clay | West Virginia | 54015 | 65 | 3 |
686654 | 686654 | 2020-10-31 | Gilmer | West Virginia | 54021 | 65 | 0 |
683447 | 683447 | 2020-10-30 | Tucker | West Virginia | 54093 | 65 | 0 |
676918 | 676918 | 2020-10-28 | Braxton | West Virginia | 54007 | 65 | 0 |
647728 | 647728 | 2020-10-19 | Doddridge | West Virginia | 54017 | 65 | 1 |
644482 | 644482 | 2020-10-18 | Doddridge | West Virginia | 54017 | 65 | 1 |
644494 | 644494 | 2020-10-18 | Lewis | West Virginia | 54041 | 65 | 2 |
641234 | 641234 | 2020-10-17 | Doddridge | West Virginia | 54017 | 65 | 1 |
641261 | 641261 | 2020-10-17 | Pendleton | West Virginia | 54071 | 65 | 1 |
638014 | 638014 | 2020-10-16 | Pendleton | West Virginia | 54071 | 65 | 1 |
618559 | 618559 | 2020-10-10 | Roane | West Virginia | 54087 | 65 | 2 |
615317 | 615317 | 2020-10-09 | Roane | West Virginia | 54087 | 65 | 2 |
608842 | 608842 | 2020-10-07 | Wetzel | West Virginia | 54103 | 65 | 0 |
605580 | 605580 | 2020-10-06 | Morgan | West Virginia | 54065 | 65 | 0 |
602338 | 602338 | 2020-10-05 | Morgan | West Virginia | 54065 | 65 | 0 |
595871 | 595871 | 2020-10-03 | Wetzel | West Virginia | 54103 | 65 | 0 |
466393 | 466393 | 2020-08-24 | Monroe | West Virginia | 54063 | 65 | 0 |
463164 | 463164 | 2020-08-23 | Monroe | West Virginia | 54063 | 65 | 0 |
456703 | 456703 | 2020-08-21 | McDowell | West Virginia | 54047 | 65 | 0 |
434114 | 434114 | 2020-08-14 | McDowell | West Virginia | 54047 | 65 | 0 |
353695 | 353695 | 2020-07-20 | Hancock | West Virginia | 54029 | 65 | 0 |
328133 | 328133 | 2020-07-12 | Marshall | West Virginia | 54051 | 65 | 0 |
324951 | 324951 | 2020-07-11 | Mineral | West Virginia | 54057 | 65 | 3 |
315430 | 315430 | 2020-07-08 | Raleigh | West Virginia | 54081 | 65 | 0 |
312255 | 312255 | 2020-07-07 | Raleigh | West Virginia | 54081 | 65 | 0 |
293249 | 293249 | 2020-07-01 | Harrison | West Virginia | 54033 | 65 | 1 |
81128 | 81128 | 2020-04-22 | Jefferson | West Virginia | 54037 | 65 | 0 |
78335 | 78335 | 2020-04-21 | Jefferson | West Virginia | 54037 | 65 | 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);