ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,544 rows where county = "Pendleton" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500674 | 2500674 | 2022-05-13 | Pendleton | Kentucky | 21191 | 3498 | 38 |
2502718 | 2502718 | 2022-05-13 | Pendleton | West Virginia | 54071 | 2001 | 22 |
2497416 | 2497416 | 2022-05-12 | Pendleton | Kentucky | 21191 | 3498 | 38 |
2499460 | 2499460 | 2022-05-12 | Pendleton | West Virginia | 54071 | 1998 | 22 |
2494158 | 2494158 | 2022-05-11 | Pendleton | Kentucky | 21191 | 3498 | 38 |
2496202 | 2496202 | 2022-05-11 | Pendleton | West Virginia | 54071 | 1992 | 22 |
2490900 | 2490900 | 2022-05-10 | Pendleton | Kentucky | 21191 | 3498 | 38 |
2492944 | 2492944 | 2022-05-10 | Pendleton | West Virginia | 54071 | 1987 | 22 |
2487643 | 2487643 | 2022-05-09 | Pendleton | Kentucky | 21191 | 3498 | 38 |
2489686 | 2489686 | 2022-05-09 | Pendleton | West Virginia | 54071 | 1987 | 22 |
2484385 | 2484385 | 2022-05-08 | Pendleton | Kentucky | 21191 | 3493 | 38 |
2486429 | 2486429 | 2022-05-08 | Pendleton | West Virginia | 54071 | 1979 | 22 |
2481127 | 2481127 | 2022-05-07 | Pendleton | Kentucky | 21191 | 3493 | 38 |
2483171 | 2483171 | 2022-05-07 | Pendleton | West Virginia | 54071 | 1979 | 22 |
2477869 | 2477869 | 2022-05-06 | Pendleton | Kentucky | 21191 | 3493 | 38 |
2479913 | 2479913 | 2022-05-06 | Pendleton | West Virginia | 54071 | 1979 | 22 |
2474611 | 2474611 | 2022-05-05 | Pendleton | Kentucky | 21191 | 3493 | 38 |
2476655 | 2476655 | 2022-05-05 | Pendleton | West Virginia | 54071 | 1977 | 22 |
2471354 | 2471354 | 2022-05-04 | Pendleton | Kentucky | 21191 | 3493 | 38 |
2473397 | 2473397 | 2022-05-04 | Pendleton | West Virginia | 54071 | 1977 | 22 |
2468098 | 2468098 | 2022-05-03 | Pendleton | Kentucky | 21191 | 3493 | 38 |
2470140 | 2470140 | 2022-05-03 | Pendleton | West Virginia | 54071 | 1976 | 22 |
2464843 | 2464843 | 2022-05-02 | Pendleton | Kentucky | 21191 | 3493 | 38 |
2466884 | 2466884 | 2022-05-02 | Pendleton | West Virginia | 54071 | 1974 | 22 |
2461587 | 2461587 | 2022-05-01 | Pendleton | Kentucky | 21191 | 3484 | 38 |
2463629 | 2463629 | 2022-05-01 | Pendleton | West Virginia | 54071 | 1972 | 22 |
2458331 | 2458331 | 2022-04-30 | Pendleton | Kentucky | 21191 | 3484 | 38 |
2460373 | 2460373 | 2022-04-30 | Pendleton | West Virginia | 54071 | 1972 | 22 |
2455075 | 2455075 | 2022-04-29 | Pendleton | Kentucky | 21191 | 3484 | 38 |
2457117 | 2457117 | 2022-04-29 | Pendleton | West Virginia | 54071 | 1972 | 22 |
2451819 | 2451819 | 2022-04-28 | Pendleton | Kentucky | 21191 | 3484 | 38 |
2453861 | 2453861 | 2022-04-28 | Pendleton | West Virginia | 54071 | 1971 | 22 |
2448563 | 2448563 | 2022-04-27 | Pendleton | Kentucky | 21191 | 3484 | 38 |
2450605 | 2450605 | 2022-04-27 | Pendleton | West Virginia | 54071 | 1968 | 22 |
2445307 | 2445307 | 2022-04-26 | Pendleton | Kentucky | 21191 | 3484 | 38 |
2447349 | 2447349 | 2022-04-26 | Pendleton | West Virginia | 54071 | 1968 | 22 |
2442051 | 2442051 | 2022-04-25 | Pendleton | Kentucky | 21191 | 3484 | 38 |
2444093 | 2444093 | 2022-04-25 | Pendleton | West Virginia | 54071 | 1967 | 22 |
2438795 | 2438795 | 2022-04-24 | Pendleton | Kentucky | 21191 | 3482 | 38 |
2440837 | 2440837 | 2022-04-24 | Pendleton | West Virginia | 54071 | 1966 | 22 |
2435539 | 2435539 | 2022-04-23 | Pendleton | Kentucky | 21191 | 3482 | 38 |
2437581 | 2437581 | 2022-04-23 | Pendleton | West Virginia | 54071 | 1966 | 22 |
2432283 | 2432283 | 2022-04-22 | Pendleton | Kentucky | 21191 | 3482 | 38 |
2434325 | 2434325 | 2022-04-22 | Pendleton | West Virginia | 54071 | 1966 | 22 |
2429027 | 2429027 | 2022-04-21 | Pendleton | Kentucky | 21191 | 3482 | 38 |
2431069 | 2431069 | 2022-04-21 | Pendleton | West Virginia | 54071 | 1962 | 22 |
2425771 | 2425771 | 2022-04-20 | Pendleton | Kentucky | 21191 | 3482 | 38 |
2427813 | 2427813 | 2022-04-20 | Pendleton | West Virginia | 54071 | 1962 | 21 |
2422515 | 2422515 | 2022-04-19 | Pendleton | Kentucky | 21191 | 3482 | 38 |
2424557 | 2424557 | 2022-04-19 | Pendleton | West Virginia | 54071 | 1961 | 21 |
2419259 | 2419259 | 2022-04-18 | Pendleton | Kentucky | 21191 | 3482 | 38 |
2421301 | 2421301 | 2022-04-18 | Pendleton | West Virginia | 54071 | 1959 | 21 |
2416003 | 2416003 | 2022-04-17 | Pendleton | Kentucky | 21191 | 3478 | 38 |
2418045 | 2418045 | 2022-04-17 | Pendleton | West Virginia | 54071 | 1959 | 21 |
2412747 | 2412747 | 2022-04-16 | Pendleton | Kentucky | 21191 | 3478 | 38 |
2414789 | 2414789 | 2022-04-16 | Pendleton | West Virginia | 54071 | 1959 | 21 |
2409491 | 2409491 | 2022-04-15 | Pendleton | Kentucky | 21191 | 3478 | 38 |
2411533 | 2411533 | 2022-04-15 | Pendleton | West Virginia | 54071 | 1959 | 21 |
2406235 | 2406235 | 2022-04-14 | Pendleton | Kentucky | 21191 | 3478 | 38 |
2408277 | 2408277 | 2022-04-14 | Pendleton | West Virginia | 54071 | 1959 | 21 |
2402979 | 2402979 | 2022-04-13 | Pendleton | Kentucky | 21191 | 3478 | 38 |
2405021 | 2405021 | 2022-04-13 | Pendleton | West Virginia | 54071 | 1959 | 21 |
2399725 | 2399725 | 2022-04-12 | Pendleton | Kentucky | 21191 | 3478 | 38 |
2401766 | 2401766 | 2022-04-12 | Pendleton | West Virginia | 54071 | 1961 | 21 |
2396469 | 2396469 | 2022-04-11 | Pendleton | Kentucky | 21191 | 3478 | 38 |
2398511 | 2398511 | 2022-04-11 | Pendleton | West Virginia | 54071 | 1956 | 21 |
2393214 | 2393214 | 2022-04-10 | Pendleton | Kentucky | 21191 | 3475 | 38 |
2395256 | 2395256 | 2022-04-10 | Pendleton | West Virginia | 54071 | 1953 | 21 |
2389958 | 2389958 | 2022-04-09 | Pendleton | Kentucky | 21191 | 3475 | 38 |
2392000 | 2392000 | 2022-04-09 | Pendleton | West Virginia | 54071 | 1953 | 21 |
2386702 | 2386702 | 2022-04-08 | Pendleton | Kentucky | 21191 | 3475 | 38 |
2388744 | 2388744 | 2022-04-08 | Pendleton | West Virginia | 54071 | 1953 | 21 |
2383447 | 2383447 | 2022-04-07 | Pendleton | Kentucky | 21191 | 3475 | 38 |
2385489 | 2385489 | 2022-04-07 | Pendleton | West Virginia | 54071 | 1948 | 21 |
2380192 | 2380192 | 2022-04-06 | Pendleton | Kentucky | 21191 | 3475 | 38 |
2382234 | 2382234 | 2022-04-06 | Pendleton | West Virginia | 54071 | 1948 | 21 |
2376937 | 2376937 | 2022-04-05 | Pendleton | Kentucky | 21191 | 3475 | 38 |
2378979 | 2378979 | 2022-04-05 | Pendleton | West Virginia | 54071 | 1947 | 18 |
2373685 | 2373685 | 2022-04-04 | Pendleton | Kentucky | 21191 | 3475 | 38 |
2375725 | 2375725 | 2022-04-04 | Pendleton | West Virginia | 54071 | 1945 | 18 |
2370432 | 2370432 | 2022-04-03 | Pendleton | Kentucky | 21191 | 3471 | 37 |
2372473 | 2372473 | 2022-04-03 | Pendleton | West Virginia | 54071 | 1943 | 18 |
2367179 | 2367179 | 2022-04-02 | Pendleton | Kentucky | 21191 | 3471 | 37 |
2369220 | 2369220 | 2022-04-02 | Pendleton | West Virginia | 54071 | 1943 | 18 |
2363926 | 2363926 | 2022-04-01 | Pendleton | Kentucky | 21191 | 3471 | 37 |
2365967 | 2365967 | 2022-04-01 | Pendleton | West Virginia | 54071 | 1943 | 18 |
2360672 | 2360672 | 2022-03-31 | Pendleton | Kentucky | 21191 | 3471 | 37 |
2362714 | 2362714 | 2022-03-31 | Pendleton | West Virginia | 54071 | 1943 | 18 |
2357418 | 2357418 | 2022-03-30 | Pendleton | Kentucky | 21191 | 3471 | 37 |
2359460 | 2359460 | 2022-03-30 | Pendleton | West Virginia | 54071 | 1943 | 18 |
2354165 | 2354165 | 2022-03-29 | Pendleton | Kentucky | 21191 | 3471 | 37 |
2356206 | 2356206 | 2022-03-29 | Pendleton | West Virginia | 54071 | 1942 | 17 |
2350913 | 2350913 | 2022-03-28 | Pendleton | Kentucky | 21191 | 3471 | 37 |
2352953 | 2352953 | 2022-03-28 | Pendleton | West Virginia | 54071 | 1941 | 17 |
2347660 | 2347660 | 2022-03-27 | Pendleton | Kentucky | 21191 | 3435 | 37 |
2349701 | 2349701 | 2022-03-27 | Pendleton | West Virginia | 54071 | 1938 | 17 |
2344407 | 2344407 | 2022-03-26 | Pendleton | Kentucky | 21191 | 3435 | 37 |
2346448 | 2346448 | 2022-03-26 | Pendleton | West Virginia | 54071 | 1938 | 17 |
2341154 | 2341154 | 2022-03-25 | Pendleton | Kentucky | 21191 | 3435 | 37 |
2343195 | 2343195 | 2022-03-25 | Pendleton | West Virginia | 54071 | 1938 | 17 |
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);