ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 54067 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502716 | 2502716 | 2022-05-13 | Nicholas | West Virginia | 54067 | 7378 | 97 |
2499458 | 2499458 | 2022-05-12 | Nicholas | West Virginia | 54067 | 7376 | 97 |
2496200 | 2496200 | 2022-05-11 | Nicholas | West Virginia | 54067 | 7371 | 97 |
2492942 | 2492942 | 2022-05-10 | Nicholas | West Virginia | 54067 | 7364 | 97 |
2489684 | 2489684 | 2022-05-09 | Nicholas | West Virginia | 54067 | 7364 | 97 |
2486427 | 2486427 | 2022-05-08 | Nicholas | West Virginia | 54067 | 7344 | 97 |
2483169 | 2483169 | 2022-05-07 | Nicholas | West Virginia | 54067 | 7344 | 97 |
2479911 | 2479911 | 2022-05-06 | Nicholas | West Virginia | 54067 | 7344 | 97 |
2476653 | 2476653 | 2022-05-05 | Nicholas | West Virginia | 54067 | 7339 | 97 |
2473395 | 2473395 | 2022-05-04 | Nicholas | West Virginia | 54067 | 7334 | 97 |
2470138 | 2470138 | 2022-05-03 | Nicholas | West Virginia | 54067 | 7334 | 97 |
2466882 | 2466882 | 2022-05-02 | Nicholas | West Virginia | 54067 | 7333 | 97 |
2463627 | 2463627 | 2022-05-01 | Nicholas | West Virginia | 54067 | 7326 | 97 |
2460371 | 2460371 | 2022-04-30 | Nicholas | West Virginia | 54067 | 7326 | 97 |
2457115 | 2457115 | 2022-04-29 | Nicholas | West Virginia | 54067 | 7326 | 97 |
2453859 | 2453859 | 2022-04-28 | Nicholas | West Virginia | 54067 | 7324 | 97 |
2450603 | 2450603 | 2022-04-27 | Nicholas | West Virginia | 54067 | 7321 | 96 |
2447347 | 2447347 | 2022-04-26 | Nicholas | West Virginia | 54067 | 7316 | 96 |
2444091 | 2444091 | 2022-04-25 | Nicholas | West Virginia | 54067 | 7313 | 96 |
2440835 | 2440835 | 2022-04-24 | Nicholas | West Virginia | 54067 | 7311 | 96 |
2437579 | 2437579 | 2022-04-23 | Nicholas | West Virginia | 54067 | 7311 | 96 |
2434323 | 2434323 | 2022-04-22 | Nicholas | West Virginia | 54067 | 7311 | 96 |
2431067 | 2431067 | 2022-04-21 | Nicholas | West Virginia | 54067 | 7311 | 96 |
2427811 | 2427811 | 2022-04-20 | Nicholas | West Virginia | 54067 | 7309 | 96 |
2424555 | 2424555 | 2022-04-19 | Nicholas | West Virginia | 54067 | 7306 | 96 |
2421299 | 2421299 | 2022-04-18 | Nicholas | West Virginia | 54067 | 7307 | 96 |
2418043 | 2418043 | 2022-04-17 | Nicholas | West Virginia | 54067 | 7304 | 96 |
2414787 | 2414787 | 2022-04-16 | Nicholas | West Virginia | 54067 | 7304 | 96 |
2411531 | 2411531 | 2022-04-15 | Nicholas | West Virginia | 54067 | 7304 | 96 |
2408275 | 2408275 | 2022-04-14 | Nicholas | West Virginia | 54067 | 7304 | 96 |
2405019 | 2405019 | 2022-04-13 | Nicholas | West Virginia | 54067 | 7303 | 96 |
2401764 | 2401764 | 2022-04-12 | Nicholas | West Virginia | 54067 | 7301 | 96 |
2398509 | 2398509 | 2022-04-11 | Nicholas | West Virginia | 54067 | 7301 | 95 |
2395254 | 2395254 | 2022-04-10 | Nicholas | West Virginia | 54067 | 7300 | 95 |
2391998 | 2391998 | 2022-04-09 | Nicholas | West Virginia | 54067 | 7300 | 95 |
2388742 | 2388742 | 2022-04-08 | Nicholas | West Virginia | 54067 | 7300 | 95 |
2385487 | 2385487 | 2022-04-07 | Nicholas | West Virginia | 54067 | 7299 | 95 |
2382232 | 2382232 | 2022-04-06 | Nicholas | West Virginia | 54067 | 7299 | 95 |
2378977 | 2378977 | 2022-04-05 | Nicholas | West Virginia | 54067 | 7298 | 93 |
2375723 | 2375723 | 2022-04-04 | Nicholas | West Virginia | 54067 | 7298 | 93 |
2372471 | 2372471 | 2022-04-03 | Nicholas | West Virginia | 54067 | 7296 | 93 |
2369218 | 2369218 | 2022-04-02 | Nicholas | West Virginia | 54067 | 7296 | 93 |
2365965 | 2365965 | 2022-04-01 | Nicholas | West Virginia | 54067 | 7296 | 93 |
2362712 | 2362712 | 2022-03-31 | Nicholas | West Virginia | 54067 | 7294 | 93 |
2359458 | 2359458 | 2022-03-30 | Nicholas | West Virginia | 54067 | 7295 | 92 |
2356204 | 2356204 | 2022-03-29 | Nicholas | West Virginia | 54067 | 7294 | 92 |
2352951 | 2352951 | 2022-03-28 | Nicholas | West Virginia | 54067 | 7290 | 92 |
2349699 | 2349699 | 2022-03-27 | Nicholas | West Virginia | 54067 | 7287 | 92 |
2346446 | 2346446 | 2022-03-26 | Nicholas | West Virginia | 54067 | 7287 | 92 |
2343193 | 2343193 | 2022-03-25 | Nicholas | West Virginia | 54067 | 7287 | 92 |
2339940 | 2339940 | 2022-03-24 | Nicholas | West Virginia | 54067 | 7287 | 92 |
2336687 | 2336687 | 2022-03-23 | Nicholas | West Virginia | 54067 | 7284 | 92 |
2333433 | 2333433 | 2022-03-22 | Nicholas | West Virginia | 54067 | 7281 | 92 |
2330179 | 2330179 | 2022-03-21 | Nicholas | West Virginia | 54067 | 7281 | 92 |
2326927 | 2326927 | 2022-03-20 | Nicholas | West Virginia | 54067 | 7273 | 92 |
2323674 | 2323674 | 2022-03-19 | Nicholas | West Virginia | 54067 | 7273 | 92 |
2320420 | 2320420 | 2022-03-18 | Nicholas | West Virginia | 54067 | 7273 | 92 |
2317166 | 2317166 | 2022-03-17 | Nicholas | West Virginia | 54067 | 7272 | 92 |
2313913 | 2313913 | 2022-03-16 | Nicholas | West Virginia | 54067 | 7268 | 92 |
2310660 | 2310660 | 2022-03-15 | Nicholas | West Virginia | 54067 | 7263 | 92 |
2307407 | 2307407 | 2022-03-14 | Nicholas | West Virginia | 54067 | 7260 | 92 |
2304156 | 2304156 | 2022-03-13 | Nicholas | West Virginia | 54067 | 7248 | 92 |
2300904 | 2300904 | 2022-03-12 | Nicholas | West Virginia | 54067 | 7248 | 92 |
2297652 | 2297652 | 2022-03-11 | Nicholas | West Virginia | 54067 | 7248 | 92 |
2294400 | 2294400 | 2022-03-10 | Nicholas | West Virginia | 54067 | 7239 | 92 |
2291148 | 2291148 | 2022-03-09 | Nicholas | West Virginia | 54067 | 7234 | 91 |
2287896 | 2287896 | 2022-03-08 | Nicholas | West Virginia | 54067 | 7226 | 91 |
2284644 | 2284644 | 2022-03-07 | Nicholas | West Virginia | 54067 | 7217 | 91 |
2281392 | 2281392 | 2022-03-06 | Nicholas | West Virginia | 54067 | 7190 | 90 |
2278139 | 2278139 | 2022-03-05 | Nicholas | West Virginia | 54067 | 7190 | 90 |
2274886 | 2274886 | 2022-03-04 | Nicholas | West Virginia | 54067 | 7190 | 90 |
2271633 | 2271633 | 2022-03-03 | Nicholas | West Virginia | 54067 | 7177 | 90 |
2268381 | 2268381 | 2022-03-02 | Nicholas | West Virginia | 54067 | 7133 | 90 |
2265128 | 2265128 | 2022-03-01 | Nicholas | West Virginia | 54067 | 7124 | 90 |
2261878 | 2261878 | 2022-02-28 | Nicholas | West Virginia | 54067 | 7118 | 90 |
2258627 | 2258627 | 2022-02-27 | Nicholas | West Virginia | 54067 | 7065 | 89 |
2255376 | 2255376 | 2022-02-26 | Nicholas | West Virginia | 54067 | 7065 | 89 |
2252125 | 2252125 | 2022-02-25 | Nicholas | West Virginia | 54067 | 7065 | 89 |
2248874 | 2248874 | 2022-02-24 | Nicholas | West Virginia | 54067 | 7053 | 89 |
2245623 | 2245623 | 2022-02-23 | Nicholas | West Virginia | 54067 | 7039 | 88 |
2242372 | 2242372 | 2022-02-22 | Nicholas | West Virginia | 54067 | 7028 | 88 |
2239121 | 2239121 | 2022-02-21 | Nicholas | West Virginia | 54067 | 7008 | 87 |
2235870 | 2235870 | 2022-02-20 | Nicholas | West Virginia | 54067 | 6958 | 87 |
2232619 | 2232619 | 2022-02-19 | Nicholas | West Virginia | 54067 | 6958 | 87 |
2229368 | 2229368 | 2022-02-18 | Nicholas | West Virginia | 54067 | 6958 | 87 |
2226117 | 2226117 | 2022-02-17 | Nicholas | West Virginia | 54067 | 6940 | 87 |
2222866 | 2222866 | 2022-02-16 | Nicholas | West Virginia | 54067 | 6906 | 86 |
2219615 | 2219615 | 2022-02-15 | Nicholas | West Virginia | 54067 | 6886 | 86 |
2216365 | 2216365 | 2022-02-14 | Nicholas | West Virginia | 54067 | 6862 | 86 |
2213114 | 2213114 | 2022-02-13 | Nicholas | West Virginia | 54067 | 6844 | 86 |
2209861 | 2209861 | 2022-02-12 | Nicholas | West Virginia | 54067 | 6821 | 86 |
2206608 | 2206608 | 2022-02-11 | Nicholas | West Virginia | 54067 | 6789 | 86 |
2203355 | 2203355 | 2022-02-10 | Nicholas | West Virginia | 54067 | 6752 | 85 |
2200101 | 2200101 | 2022-02-09 | Nicholas | West Virginia | 54067 | 6705 | 85 |
2196847 | 2196847 | 2022-02-08 | Nicholas | West Virginia | 54067 | 6678 | 83 |
2193592 | 2193592 | 2022-02-07 | Nicholas | West Virginia | 54067 | 6650 | 82 |
2190339 | 2190339 | 2022-02-06 | Nicholas | West Virginia | 54067 | 6623 | 81 |
2187086 | 2187086 | 2022-02-05 | Nicholas | West Virginia | 54067 | 6600 | 81 |
2183833 | 2183833 | 2022-02-04 | Nicholas | West Virginia | 54067 | 6540 | 81 |
2180581 | 2180581 | 2022-02-03 | Nicholas | West Virginia | 54067 | 6501 | 80 |
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);