ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2021-07-23 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 |
---|---|---|---|---|---|---|---|
1546832 | 1546832 | 2021-07-23 | Barbour | West Virginia | 54001 | 1522 | 34 |
1546833 | 1546833 | 2021-07-23 | Berkeley | West Virginia | 54003 | 12980 | 137 |
1546834 | 1546834 | 2021-07-23 | Boone | West Virginia | 54005 | 2190 | 36 |
1546835 | 1546835 | 2021-07-23 | Braxton | West Virginia | 54007 | 1035 | 4 |
1546836 | 1546836 | 2021-07-23 | Brooke | West Virginia | 54009 | 2257 | 60 |
1546837 | 1546837 | 2021-07-23 | Cabell | West Virginia | 54011 | 9011 | 179 |
1546838 | 1546838 | 2021-07-23 | Calhoun | West Virginia | 54013 | 400 | 1 |
1546839 | 1546839 | 2021-07-23 | Clay | West Virginia | 54015 | 544 | 11 |
1546840 | 1546840 | 2021-07-23 | Doddridge | West Virginia | 54017 | 649 | 6 |
1546841 | 1546841 | 2021-07-23 | Fayette | West Virginia | 54019 | 3600 | 82 |
1546842 | 1546842 | 2021-07-23 | Gilmer | West Virginia | 54021 | 891 | 7 |
1546843 | 1546843 | 2021-07-23 | Grant | West Virginia | 54023 | 1322 | 29 |
1546844 | 1546844 | 2021-07-23 | Greenbrier | West Virginia | 54025 | 2919 | 65 |
1546845 | 1546845 | 2021-07-23 | Hampshire | West Virginia | 54027 | 1935 | 36 |
1546846 | 1546846 | 2021-07-23 | Hancock | West Virginia | 54029 | 2860 | 90 |
1546847 | 1546847 | 2021-07-23 | Hardy | West Virginia | 54031 | 1588 | 24 |
1546848 | 1546848 | 2021-07-23 | Harrison | West Virginia | 54033 | 6281 | 82 |
1546849 | 1546849 | 2021-07-23 | Jackson | West Virginia | 54035 | 2283 | 62 |
1546850 | 1546850 | 2021-07-23 | Jefferson | West Virginia | 54037 | 4829 | 60 |
1546851 | 1546851 | 2021-07-23 | Kanawha | West Virginia | 54039 | 15594 | 361 |
1546852 | 1546852 | 2021-07-23 | Lewis | West Virginia | 54041 | 1325 | 22 |
1546853 | 1546853 | 2021-07-23 | Lincoln | West Virginia | 54043 | 1613 | 25 |
1546854 | 1546854 | 2021-07-23 | Logan | West Virginia | 54045 | 3318 | 96 |
1546855 | 1546855 | 2021-07-23 | Marion | West Virginia | 54049 | 4707 | 54 |
1546856 | 1546856 | 2021-07-23 | Marshall | West Virginia | 54051 | 3565 | 79 |
1546857 | 1546857 | 2021-07-23 | Mason | West Virginia | 54053 | 2094 | 37 |
1546858 | 1546858 | 2021-07-23 | McDowell | West Virginia | 54047 | 1656 | 27 |
1546859 | 1546859 | 2021-07-23 | Mercer | West Virginia | 54055 | 5248 | 129 |
1546860 | 1546860 | 2021-07-23 | Mineral | West Virginia | 54057 | 3006 | 92 |
1546861 | 1546861 | 2021-07-23 | Mingo | West Virginia | 54059 | 2797 | 44 |
1546862 | 1546862 | 2021-07-23 | Monongalia | West Virginia | 54061 | 9464 | 92 |
1546863 | 1546863 | 2021-07-23 | Monroe | West Virginia | 54063 | 1229 | 18 |
1546864 | 1546864 | 2021-07-23 | Morgan | West Virginia | 54065 | 1256 | 23 |
1546865 | 1546865 | 2021-07-23 | Nicholas | West Virginia | 54067 | 1936 | 24 |
1546866 | 1546866 | 2021-07-23 | Ohio | West Virginia | 54069 | 4340 | 87 |
1546867 | 1546867 | 2021-07-23 | Pendleton | West Virginia | 54071 | 726 | 11 |
1546868 | 1546868 | 2021-07-23 | Pleasants | West Virginia | 54073 | 961 | 12 |
1546869 | 1546869 | 2021-07-23 | Pocahontas | West Virginia | 54075 | 683 | 12 |
1546870 | 1546870 | 2021-07-23 | Preston | West Virginia | 54077 | 2971 | 47 |
1546871 | 1546871 | 2021-07-23 | Putnam | West Virginia | 54079 | 5415 | 93 |
1546872 | 1546872 | 2021-07-23 | Raleigh | West Virginia | 54081 | 7141 | 101 |
1546873 | 1546873 | 2021-07-23 | Randolph | West Virginia | 54083 | 2879 | 15 |
1546874 | 1546874 | 2021-07-23 | Ritchie | West Virginia | 54085 | 768 | 11 |
1546875 | 1546875 | 2021-07-23 | Roane | West Virginia | 54087 | 670 | 9 |
1546876 | 1546876 | 2021-07-23 | Summers | West Virginia | 54089 | 869 | 22 |
1546877 | 1546877 | 2021-07-23 | Taylor | West Virginia | 54091 | 1304 | 25 |
1546878 | 1546878 | 2021-07-23 | Tucker | West Virginia | 54093 | 549 | 10 |
1546879 | 1546879 | 2021-07-23 | Tyler | West Virginia | 54095 | 754 | 13 |
1546880 | 1546880 | 2021-07-23 | Upshur | West Virginia | 54097 | 2011 | 34 |
1546881 | 1546881 | 2021-07-23 | Wayne | West Virginia | 54099 | 3206 | 44 |
1546882 | 1546882 | 2021-07-23 | Webster | West Virginia | 54101 | 588 | 8 |
1546883 | 1546883 | 2021-07-23 | Wetzel | West Virginia | 54103 | 1405 | 32 |
1546884 | 1546884 | 2021-07-23 | Wirt | West Virginia | 54105 | 468 | 4 |
1546885 | 1546885 | 2021-07-23 | Wood | West Virginia | 54107 | 8005 | 177 |
1546886 | 1546886 | 2021-07-23 | Wyoming | West Virginia | 54109 | 2085 | 41 |
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);