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

740 rows where county = "Blaine" and fips = 40011 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

  • 40011 · 740 ✖

county 1

  • Blaine · 740 ✖
Link rowid date ▲ county state fips cases deaths
2501738 2501738 2022-05-13 Blaine Oklahoma 40011 2461 43
2498480 2498480 2022-05-12 Blaine Oklahoma 40011 2461 43
2495222 2495222 2022-05-11 Blaine Oklahoma 40011 2458 42
2491964 2491964 2022-05-10 Blaine Oklahoma 40011 2458 42
2488706 2488706 2022-05-09 Blaine Oklahoma 40011 2458 42
2485449 2485449 2022-05-08 Blaine Oklahoma 40011 2458 42
2482191 2482191 2022-05-07 Blaine Oklahoma 40011 2458 42
2478933 2478933 2022-05-06 Blaine Oklahoma 40011 2458 42
2475675 2475675 2022-05-05 Blaine Oklahoma 40011 2458 42
2472418 2472418 2022-05-04 Blaine Oklahoma 40011 2454 41
2469162 2469162 2022-05-03 Blaine Oklahoma 40011 2454 41
2465906 2465906 2022-05-02 Blaine Oklahoma 40011 2454 41
2462651 2462651 2022-05-01 Blaine Oklahoma 40011 2454 41
2459395 2459395 2022-04-30 Blaine Oklahoma 40011 2454 41
2456139 2456139 2022-04-29 Blaine Oklahoma 40011 2454 41
2452883 2452883 2022-04-28 Blaine Oklahoma 40011 2454 41
2449627 2449627 2022-04-27 Blaine Oklahoma 40011 2454 41
2446370 2446370 2022-04-26 Blaine Oklahoma 40011 2454 41
2443115 2443115 2022-04-25 Blaine Oklahoma 40011 2454 41
2439859 2439859 2022-04-24 Blaine Oklahoma 40011 2454 41
2436603 2436603 2022-04-23 Blaine Oklahoma 40011 2454 41
2433347 2433347 2022-04-22 Blaine Oklahoma 40011 2454 41
2430091 2430091 2022-04-21 Blaine Oklahoma 40011 2454 41
2426835 2426835 2022-04-20 Blaine Oklahoma 40011 2455 41
2423579 2423579 2022-04-19 Blaine Oklahoma 40011 2455 41
2420322 2420322 2022-04-18 Blaine Oklahoma 40011 2455 41
2417067 2417067 2022-04-17 Blaine Oklahoma 40011 2455 41
2413811 2413811 2022-04-16 Blaine Oklahoma 40011 2455 41
2410555 2410555 2022-04-15 Blaine Oklahoma 40011 2455 41
2407299 2407299 2022-04-14 Blaine Oklahoma 40011 2455 41
2404043 2404043 2022-04-13 Blaine Oklahoma 40011 2455 41
2400788 2400788 2022-04-12 Blaine Oklahoma 40011 2455 41
2397533 2397533 2022-04-11 Blaine Oklahoma 40011 2455 41
2394278 2394278 2022-04-10 Blaine Oklahoma 40011 2455 41
2391022 2391022 2022-04-09 Blaine Oklahoma 40011 2455 41
2387766 2387766 2022-04-08 Blaine Oklahoma 40011 2455 41
2384511 2384511 2022-04-07 Blaine Oklahoma 40011 2455 41
2381256 2381256 2022-04-06 Blaine Oklahoma 40011 2452 41
2378001 2378001 2022-04-05 Blaine Oklahoma 40011 2452 41
2374747 2374747 2022-04-04 Blaine Oklahoma 40011 2452 41
2371495 2371495 2022-04-03 Blaine Oklahoma 40011 2452 41
2368242 2368242 2022-04-02 Blaine Oklahoma 40011 2452 41
2364989 2364989 2022-04-01 Blaine Oklahoma 40011 2452 41
2361736 2361736 2022-03-31 Blaine Oklahoma 40011 2452 41
2358482 2358482 2022-03-30 Blaine Oklahoma 40011 2446 40
2355228 2355228 2022-03-29 Blaine Oklahoma 40011 2446 40
2351975 2351975 2022-03-28 Blaine Oklahoma 40011 2446 40
2348723 2348723 2022-03-27 Blaine Oklahoma 40011 2446 40
2345470 2345470 2022-03-26 Blaine Oklahoma 40011 2446 40
2342217 2342217 2022-03-25 Blaine Oklahoma 40011 2446 40
2338964 2338964 2022-03-24 Blaine Oklahoma 40011 2446 40
2335710 2335710 2022-03-23 Blaine Oklahoma 40011 2441 40
2332456 2332456 2022-03-22 Blaine Oklahoma 40011 2441 40
2329203 2329203 2022-03-21 Blaine Oklahoma 40011 2441 40
2325951 2325951 2022-03-20 Blaine Oklahoma 40011 2441 40
2322698 2322698 2022-03-19 Blaine Oklahoma 40011 2441 40
2319444 2319444 2022-03-18 Blaine Oklahoma 40011 2441 40
2316190 2316190 2022-03-17 Blaine Oklahoma 40011 2441 40
2312937 2312937 2022-03-16 Blaine Oklahoma 40011 2418 38
2309684 2309684 2022-03-15 Blaine Oklahoma 40011 2418 38
2306431 2306431 2022-03-14 Blaine Oklahoma 40011 2418 38
2303180 2303180 2022-03-13 Blaine Oklahoma 40011 2418 38
2299928 2299928 2022-03-12 Blaine Oklahoma 40011 2418 38
2296676 2296676 2022-03-11 Blaine Oklahoma 40011 2418 38
2293424 2293424 2022-03-10 Blaine Oklahoma 40011 2418 38
2290172 2290172 2022-03-09 Blaine Oklahoma 40011 2405 38
2286920 2286920 2022-03-08 Blaine Oklahoma 40011 2405 38
2283668 2283668 2022-03-07 Blaine Oklahoma 40011 2405 38
2280416 2280416 2022-03-06 Blaine Oklahoma 40011 2405 38
2277163 2277163 2022-03-05 Blaine Oklahoma 40011 2405 38
2273910 2273910 2022-03-04 Blaine Oklahoma 40011 2405 38
2270657 2270657 2022-03-03 Blaine Oklahoma 40011 2405 38
2267405 2267405 2022-03-02 Blaine Oklahoma 40011 2405 38
2264152 2264152 2022-03-01 Blaine Oklahoma 40011 2397 36
2260902 2260902 2022-02-28 Blaine Oklahoma 40011 2397 36
2257651 2257651 2022-02-27 Blaine Oklahoma 40011 2397 36
2254400 2254400 2022-02-26 Blaine Oklahoma 40011 2397 36
2251149 2251149 2022-02-25 Blaine Oklahoma 40011 2397 36
2247898 2247898 2022-02-24 Blaine Oklahoma 40011 2397 36
2244647 2244647 2022-02-23 Blaine Oklahoma 40011 2397 36
2241396 2241396 2022-02-22 Blaine Oklahoma 40011 2383 34
2238145 2238145 2022-02-21 Blaine Oklahoma 40011 2383 34
2234894 2234894 2022-02-20 Blaine Oklahoma 40011 2383 34
2231643 2231643 2022-02-19 Blaine Oklahoma 40011 2383 34
2228392 2228392 2022-02-18 Blaine Oklahoma 40011 2383 34
2225141 2225141 2022-02-17 Blaine Oklahoma 40011 2383 34
2221890 2221890 2022-02-16 Blaine Oklahoma 40011 2383 34
2218639 2218639 2022-02-15 Blaine Oklahoma 40011 2362 34
2215388 2215388 2022-02-14 Blaine Oklahoma 40011 2362 34
2212137 2212137 2022-02-13 Blaine Oklahoma 40011 2362 34
2208884 2208884 2022-02-12 Blaine Oklahoma 40011 2362 34
2205631 2205631 2022-02-11 Blaine Oklahoma 40011 2362 34
2202378 2202378 2022-02-10 Blaine Oklahoma 40011 2362 34
2199124 2199124 2022-02-09 Blaine Oklahoma 40011 2362 34
2195870 2195870 2022-02-08 Blaine Oklahoma 40011 2329 34
2192616 2192616 2022-02-07 Blaine Oklahoma 40011 2329 34
2189362 2189362 2022-02-06 Blaine Oklahoma 40011 2329 34
2186109 2186109 2022-02-05 Blaine Oklahoma 40011 2329 34
2182857 2182857 2022-02-04 Blaine Oklahoma 40011 2329 34
2179605 2179605 2022-02-03 Blaine Oklahoma 40011 2329 34

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