ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Brooke" 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 |
---|---|---|---|---|---|---|---|
2112234 | 2112234 | 2022-01-13 | Brooke | West Virginia | 54009 | 4116 | 87 |
2108982 | 2108982 | 2022-01-12 | Brooke | West Virginia | 54009 | 4074 | 87 |
2105731 | 2105731 | 2022-01-11 | Brooke | West Virginia | 54009 | 4040 | 87 |
2102480 | 2102480 | 2022-01-10 | Brooke | West Virginia | 54009 | 3989 | 87 |
2099229 | 2099229 | 2022-01-09 | Brooke | West Virginia | 54009 | 3962 | 87 |
2095978 | 2095978 | 2022-01-08 | Brooke | West Virginia | 54009 | 3943 | 87 |
2092726 | 2092726 | 2022-01-07 | Brooke | West Virginia | 54009 | 3916 | 87 |
2089474 | 2089474 | 2022-01-06 | Brooke | West Virginia | 54009 | 3830 | 86 |
2086223 | 2086223 | 2022-01-05 | Brooke | West Virginia | 54009 | 3797 | 86 |
2082971 | 2082971 | 2022-01-04 | Brooke | West Virginia | 54009 | 3778 | 86 |
2079719 | 2079719 | 2022-01-03 | Brooke | West Virginia | 54009 | 3746 | 86 |
2076467 | 2076467 | 2022-01-02 | Brooke | West Virginia | 54009 | 3671 | 86 |
2073216 | 2073216 | 2022-01-01 | Brooke | West Virginia | 54009 | 3671 | 86 |
2069965 | 2069965 | 2021-12-31 | Brooke | West Virginia | 54009 | 3671 | 86 |
2066714 | 2066714 | 2021-12-30 | Brooke | West Virginia | 54009 | 3671 | 86 |
2063464 | 2063464 | 2021-12-29 | Brooke | West Virginia | 54009 | 3659 | 86 |
2060214 | 2060214 | 2021-12-28 | Brooke | West Virginia | 54009 | 3647 | 86 |
2056965 | 2056965 | 2021-12-27 | Brooke | West Virginia | 54009 | 3634 | 86 |
2053716 | 2053716 | 2021-12-26 | Brooke | West Virginia | 54009 | 3605 | 86 |
2050466 | 2050466 | 2021-12-25 | Brooke | West Virginia | 54009 | 3605 | 86 |
2047216 | 2047216 | 2021-12-24 | Brooke | West Virginia | 54009 | 3605 | 86 |
2043966 | 2043966 | 2021-12-23 | Brooke | West Virginia | 54009 | 3605 | 86 |
2040717 | 2040717 | 2021-12-22 | Brooke | West Virginia | 54009 | 3603 | 86 |
2037467 | 2037467 | 2021-12-21 | Brooke | West Virginia | 54009 | 3586 | 85 |
2034217 | 2034217 | 2021-12-20 | Brooke | West Virginia | 54009 | 3570 | 85 |
2030967 | 2030967 | 2021-12-19 | Brooke | West Virginia | 54009 | 3561 | 85 |
2027716 | 2027716 | 2021-12-18 | Brooke | West Virginia | 54009 | 3553 | 85 |
2024465 | 2024465 | 2021-12-17 | Brooke | West Virginia | 54009 | 3543 | 85 |
2021214 | 2021214 | 2021-12-16 | Brooke | West Virginia | 54009 | 3537 | 82 |
2017963 | 2017963 | 2021-12-15 | Brooke | West Virginia | 54009 | 3526 | 82 |
2014713 | 2014713 | 2021-12-14 | Brooke | West Virginia | 54009 | 3514 | 81 |
2011462 | 2011462 | 2021-12-13 | Brooke | West Virginia | 54009 | 3506 | 81 |
2008211 | 2008211 | 2021-12-12 | Brooke | West Virginia | 54009 | 3503 | 81 |
2004960 | 2004960 | 2021-12-11 | Brooke | West Virginia | 54009 | 3499 | 81 |
2001709 | 2001709 | 2021-12-10 | Brooke | West Virginia | 54009 | 3477 | 81 |
1998459 | 1998459 | 2021-12-09 | Brooke | West Virginia | 54009 | 3461 | 80 |
1995208 | 1995208 | 2021-12-08 | Brooke | West Virginia | 54009 | 3449 | 80 |
1991957 | 1991957 | 2021-12-07 | Brooke | West Virginia | 54009 | 3445 | 79 |
1988706 | 1988706 | 2021-12-06 | Brooke | West Virginia | 54009 | 3437 | 79 |
1985456 | 1985456 | 2021-12-05 | Brooke | West Virginia | 54009 | 3428 | 78 |
1982206 | 1982206 | 2021-12-04 | Brooke | West Virginia | 54009 | 3417 | 78 |
1978956 | 1978956 | 2021-12-03 | Brooke | West Virginia | 54009 | 3409 | 78 |
1975706 | 1975706 | 2021-12-02 | Brooke | West Virginia | 54009 | 3388 | 78 |
1972457 | 1972457 | 2021-12-01 | Brooke | West Virginia | 54009 | 3370 | 78 |
1969207 | 1969207 | 2021-11-30 | Brooke | West Virginia | 54009 | 3350 | 78 |
1965957 | 1965957 | 2021-11-29 | Brooke | West Virginia | 54009 | 3342 | 78 |
1962705 | 1962705 | 2021-11-28 | Brooke | West Virginia | 54009 | 3309 | 78 |
1959454 | 1959454 | 2021-11-27 | Brooke | West Virginia | 54009 | 3309 | 78 |
1956203 | 1956203 | 2021-11-26 | Brooke | West Virginia | 54009 | 3309 | 78 |
1952952 | 1952952 | 2021-11-25 | Brooke | West Virginia | 54009 | 3309 | 78 |
1949701 | 1949701 | 2021-11-24 | Brooke | West Virginia | 54009 | 3309 | 78 |
1946450 | 1946450 | 2021-11-23 | Brooke | West Virginia | 54009 | 3296 | 77 |
1943199 | 1943199 | 2021-11-22 | Brooke | West Virginia | 54009 | 3280 | 75 |
1939949 | 1939949 | 2021-11-21 | Brooke | West Virginia | 54009 | 3274 | 75 |
1936699 | 1936699 | 2021-11-20 | Brooke | West Virginia | 54009 | 3266 | 75 |
1933449 | 1933449 | 2021-11-19 | Brooke | West Virginia | 54009 | 3256 | 75 |
1930197 | 1930197 | 2021-11-18 | Brooke | West Virginia | 54009 | 3235 | 75 |
1926947 | 1926947 | 2021-11-17 | Brooke | West Virginia | 54009 | 3220 | 75 |
1923697 | 1923697 | 2021-11-16 | Brooke | West Virginia | 54009 | 3209 | 74 |
1920448 | 1920448 | 2021-11-15 | Brooke | West Virginia | 54009 | 3199 | 74 |
1917198 | 1917198 | 2021-11-14 | Brooke | West Virginia | 54009 | 3196 | 74 |
1913948 | 1913948 | 2021-11-13 | Brooke | West Virginia | 54009 | 3194 | 74 |
1910698 | 1910698 | 2021-11-12 | Brooke | West Virginia | 54009 | 3180 | 74 |
1907449 | 1907449 | 2021-11-11 | Brooke | West Virginia | 54009 | 3167 | 74 |
1904200 | 1904200 | 2021-11-10 | Brooke | West Virginia | 54009 | 3157 | 74 |
1900950 | 1900950 | 2021-11-09 | Brooke | West Virginia | 54009 | 3144 | 74 |
1897700 | 1897700 | 2021-11-08 | Brooke | West Virginia | 54009 | 3140 | 74 |
1894450 | 1894450 | 2021-11-07 | Brooke | West Virginia | 54009 | 3137 | 74 |
1891200 | 1891200 | 2021-11-06 | Brooke | West Virginia | 54009 | 3132 | 74 |
1887950 | 1887950 | 2021-11-05 | Brooke | West Virginia | 54009 | 3125 | 74 |
1884700 | 1884700 | 2021-11-04 | Brooke | West Virginia | 54009 | 3114 | 74 |
1881451 | 1881451 | 2021-11-03 | Brooke | West Virginia | 54009 | 3111 | 74 |
1878202 | 1878202 | 2021-11-02 | Brooke | West Virginia | 54009 | 3095 | 74 |
1874953 | 1874953 | 2021-11-01 | Brooke | West Virginia | 54009 | 3093 | 73 |
1871704 | 1871704 | 2021-10-31 | Brooke | West Virginia | 54009 | 3089 | 73 |
1868455 | 1868455 | 2021-10-30 | Brooke | West Virginia | 54009 | 3084 | 73 |
1865206 | 1865206 | 2021-10-29 | Brooke | West Virginia | 54009 | 3077 | 73 |
1861957 | 1861957 | 2021-10-28 | Brooke | West Virginia | 54009 | 3067 | 73 |
1858708 | 1858708 | 2021-10-27 | Brooke | West Virginia | 54009 | 3057 | 73 |
1855459 | 1855459 | 2021-10-26 | Brooke | West Virginia | 54009 | 3046 | 72 |
1852210 | 1852210 | 2021-10-25 | Brooke | West Virginia | 54009 | 3041 | 71 |
1848960 | 1848960 | 2021-10-24 | Brooke | West Virginia | 54009 | 3032 | 71 |
1845710 | 1845710 | 2021-10-23 | Brooke | West Virginia | 54009 | 3024 | 71 |
1842460 | 1842460 | 2021-10-22 | Brooke | West Virginia | 54009 | 3019 | 71 |
1839211 | 1839211 | 2021-10-21 | Brooke | West Virginia | 54009 | 3010 | 71 |
1835962 | 1835962 | 2021-10-20 | Brooke | West Virginia | 54009 | 2999 | 71 |
1832713 | 1832713 | 2021-10-19 | Brooke | West Virginia | 54009 | 2995 | 69 |
1829464 | 1829464 | 2021-10-18 | Brooke | West Virginia | 54009 | 2991 | 69 |
1826215 | 1826215 | 2021-10-17 | Brooke | West Virginia | 54009 | 2989 | 69 |
1822966 | 1822966 | 2021-10-16 | Brooke | West Virginia | 54009 | 2983 | 69 |
1819717 | 1819717 | 2021-10-15 | Brooke | West Virginia | 54009 | 2979 | 69 |
1816468 | 1816468 | 2021-10-14 | Brooke | West Virginia | 54009 | 2962 | 68 |
1813220 | 1813220 | 2021-10-13 | Brooke | West Virginia | 54009 | 2960 | 68 |
1809971 | 1809971 | 2021-10-12 | Brooke | West Virginia | 54009 | 2953 | 68 |
1806722 | 1806722 | 2021-10-11 | Brooke | West Virginia | 54009 | 2948 | 67 |
1803471 | 1803471 | 2021-10-10 | Brooke | West Virginia | 54009 | 2944 | 67 |
1800222 | 1800222 | 2021-10-09 | Brooke | West Virginia | 54009 | 2939 | 67 |
1796973 | 1796973 | 2021-10-08 | Brooke | West Virginia | 54009 | 2936 | 67 |
1793724 | 1793724 | 2021-10-07 | Brooke | West Virginia | 54009 | 2923 | 67 |
1790475 | 1790475 | 2021-10-06 | Brooke | West Virginia | 54009 | 2915 | 67 |
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);