ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

767 rows where county = "Beaver" and fips = 40007 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: deaths, date (date)

state 1

fips 1

  • 40007 · 767 ✖

county 1

  • Beaver · 767 ✖
Link rowid date ▲ county state fips cases deaths
2501736 2501736 2022-05-13 Beaver Oklahoma 40007 969 11
2498478 2498478 2022-05-12 Beaver Oklahoma 40007 969 11
2495220 2495220 2022-05-11 Beaver Oklahoma 40007 968 11
2491962 2491962 2022-05-10 Beaver Oklahoma 40007 968 11
2488704 2488704 2022-05-09 Beaver Oklahoma 40007 968 11
2485447 2485447 2022-05-08 Beaver Oklahoma 40007 968 11
2482189 2482189 2022-05-07 Beaver Oklahoma 40007 968 11
2478931 2478931 2022-05-06 Beaver Oklahoma 40007 968 11
2475673 2475673 2022-05-05 Beaver Oklahoma 40007 968 11
2472416 2472416 2022-05-04 Beaver Oklahoma 40007 968 11
2469160 2469160 2022-05-03 Beaver Oklahoma 40007 968 11
2465904 2465904 2022-05-02 Beaver Oklahoma 40007 968 11
2462649 2462649 2022-05-01 Beaver Oklahoma 40007 968 11
2459393 2459393 2022-04-30 Beaver Oklahoma 40007 968 11
2456137 2456137 2022-04-29 Beaver Oklahoma 40007 968 11
2452881 2452881 2022-04-28 Beaver Oklahoma 40007 968 11
2449625 2449625 2022-04-27 Beaver Oklahoma 40007 968 11
2446368 2446368 2022-04-26 Beaver Oklahoma 40007 968 11
2443113 2443113 2022-04-25 Beaver Oklahoma 40007 968 11
2439857 2439857 2022-04-24 Beaver Oklahoma 40007 968 11
2436601 2436601 2022-04-23 Beaver Oklahoma 40007 968 11
2433345 2433345 2022-04-22 Beaver Oklahoma 40007 968 11
2430089 2430089 2022-04-21 Beaver Oklahoma 40007 968 11
2426833 2426833 2022-04-20 Beaver Oklahoma 40007 967 11
2423577 2423577 2022-04-19 Beaver Oklahoma 40007 967 11
2420320 2420320 2022-04-18 Beaver Oklahoma 40007 967 11
2417065 2417065 2022-04-17 Beaver Oklahoma 40007 967 11
2413809 2413809 2022-04-16 Beaver Oklahoma 40007 967 11
2410553 2410553 2022-04-15 Beaver Oklahoma 40007 967 11
2407297 2407297 2022-04-14 Beaver Oklahoma 40007 967 11
2404041 2404041 2022-04-13 Beaver Oklahoma 40007 966 11
2400786 2400786 2022-04-12 Beaver Oklahoma 40007 966 11
2397531 2397531 2022-04-11 Beaver Oklahoma 40007 966 11
2394276 2394276 2022-04-10 Beaver Oklahoma 40007 966 11
2391020 2391020 2022-04-09 Beaver Oklahoma 40007 966 11
2387764 2387764 2022-04-08 Beaver Oklahoma 40007 966 11
2384509 2384509 2022-04-07 Beaver Oklahoma 40007 966 11
2381254 2381254 2022-04-06 Beaver Oklahoma 40007 965 11
2377999 2377999 2022-04-05 Beaver Oklahoma 40007 965 11
2374745 2374745 2022-04-04 Beaver Oklahoma 40007 965 11
2371493 2371493 2022-04-03 Beaver Oklahoma 40007 965 11
2368240 2368240 2022-04-02 Beaver Oklahoma 40007 965 11
2364987 2364987 2022-04-01 Beaver Oklahoma 40007 965 11
2361734 2361734 2022-03-31 Beaver Oklahoma 40007 965 11
2358480 2358480 2022-03-30 Beaver Oklahoma 40007 963 11
2355226 2355226 2022-03-29 Beaver Oklahoma 40007 963 11
2351973 2351973 2022-03-28 Beaver Oklahoma 40007 963 11
2348721 2348721 2022-03-27 Beaver Oklahoma 40007 963 11
2345468 2345468 2022-03-26 Beaver Oklahoma 40007 963 11
2342215 2342215 2022-03-25 Beaver Oklahoma 40007 963 11
2338962 2338962 2022-03-24 Beaver Oklahoma 40007 963 11
2335708 2335708 2022-03-23 Beaver Oklahoma 40007 963 11
2332454 2332454 2022-03-22 Beaver Oklahoma 40007 963 11
2329201 2329201 2022-03-21 Beaver Oklahoma 40007 963 11
2325949 2325949 2022-03-20 Beaver Oklahoma 40007 963 11
2322696 2322696 2022-03-19 Beaver Oklahoma 40007 963 11
2319442 2319442 2022-03-18 Beaver Oklahoma 40007 963 11
2316188 2316188 2022-03-17 Beaver Oklahoma 40007 963 11
2312935 2312935 2022-03-16 Beaver Oklahoma 40007 959 10
2309682 2309682 2022-03-15 Beaver Oklahoma 40007 959 10
2306429 2306429 2022-03-14 Beaver Oklahoma 40007 959 10
2303178 2303178 2022-03-13 Beaver Oklahoma 40007 959 10
2299926 2299926 2022-03-12 Beaver Oklahoma 40007 959 10
2296674 2296674 2022-03-11 Beaver Oklahoma 40007 959 10
2293422 2293422 2022-03-10 Beaver Oklahoma 40007 959 10
2290170 2290170 2022-03-09 Beaver Oklahoma 40007 949 10
2286918 2286918 2022-03-08 Beaver Oklahoma 40007 949 10
2283666 2283666 2022-03-07 Beaver Oklahoma 40007 949 10
2280414 2280414 2022-03-06 Beaver Oklahoma 40007 949 10
2277161 2277161 2022-03-05 Beaver Oklahoma 40007 949 10
2273908 2273908 2022-03-04 Beaver Oklahoma 40007 949 10
2270655 2270655 2022-03-03 Beaver Oklahoma 40007 949 10
2267403 2267403 2022-03-02 Beaver Oklahoma 40007 949 10
2264150 2264150 2022-03-01 Beaver Oklahoma 40007 946 10
2260900 2260900 2022-02-28 Beaver Oklahoma 40007 946 10
2257649 2257649 2022-02-27 Beaver Oklahoma 40007 946 10
2254398 2254398 2022-02-26 Beaver Oklahoma 40007 946 10
2251147 2251147 2022-02-25 Beaver Oklahoma 40007 946 10
2247896 2247896 2022-02-24 Beaver Oklahoma 40007 946 10
2244645 2244645 2022-02-23 Beaver Oklahoma 40007 946 10
2241394 2241394 2022-02-22 Beaver Oklahoma 40007 944 10
2238143 2238143 2022-02-21 Beaver Oklahoma 40007 944 10
2234892 2234892 2022-02-20 Beaver Oklahoma 40007 944 10
2231641 2231641 2022-02-19 Beaver Oklahoma 40007 944 10
2228390 2228390 2022-02-18 Beaver Oklahoma 40007 944 10
2225139 2225139 2022-02-17 Beaver Oklahoma 40007 944 10
2221888 2221888 2022-02-16 Beaver Oklahoma 40007 944 10
2218637 2218637 2022-02-15 Beaver Oklahoma 40007 929 10
2215386 2215386 2022-02-14 Beaver Oklahoma 40007 929 10
2212135 2212135 2022-02-13 Beaver Oklahoma 40007 929 10
2208882 2208882 2022-02-12 Beaver Oklahoma 40007 929 10
2205629 2205629 2022-02-11 Beaver Oklahoma 40007 929 10
2202376 2202376 2022-02-10 Beaver Oklahoma 40007 929 10
2199122 2199122 2022-02-09 Beaver Oklahoma 40007 929 10
2195868 2195868 2022-02-08 Beaver Oklahoma 40007 894 10
2192614 2192614 2022-02-07 Beaver Oklahoma 40007 894 10
2189360 2189360 2022-02-06 Beaver Oklahoma 40007 894 10
2186107 2186107 2022-02-05 Beaver Oklahoma 40007 894 10
2182855 2182855 2022-02-04 Beaver Oklahoma 40007 894 10
2179603 2179603 2022-02-03 Beaver Oklahoma 40007 894 10

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);