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

757 rows where fips = 40061 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 40061 · 757 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501763 2501763 2022-05-13 Haskell Oklahoma 40061 2796 41
2498505 2498505 2022-05-12 Haskell Oklahoma 40061 2796 41
2495247 2495247 2022-05-11 Haskell Oklahoma 40061 2778 41
2491989 2491989 2022-05-10 Haskell Oklahoma 40061 2778 41
2488731 2488731 2022-05-09 Haskell Oklahoma 40061 2778 41
2485474 2485474 2022-05-08 Haskell Oklahoma 40061 2778 41
2482216 2482216 2022-05-07 Haskell Oklahoma 40061 2778 41
2478958 2478958 2022-05-06 Haskell Oklahoma 40061 2778 41
2475700 2475700 2022-05-05 Haskell Oklahoma 40061 2778 41
2472443 2472443 2022-05-04 Haskell Oklahoma 40061 2776 41
2469187 2469187 2022-05-03 Haskell Oklahoma 40061 2776 41
2465931 2465931 2022-05-02 Haskell Oklahoma 40061 2776 41
2462676 2462676 2022-05-01 Haskell Oklahoma 40061 2776 41
2459420 2459420 2022-04-30 Haskell Oklahoma 40061 2776 41
2456164 2456164 2022-04-29 Haskell Oklahoma 40061 2776 41
2452908 2452908 2022-04-28 Haskell Oklahoma 40061 2776 41
2449652 2449652 2022-04-27 Haskell Oklahoma 40061 2775 41
2446395 2446395 2022-04-26 Haskell Oklahoma 40061 2775 41
2443140 2443140 2022-04-25 Haskell Oklahoma 40061 2775 41
2439884 2439884 2022-04-24 Haskell Oklahoma 40061 2775 41
2436628 2436628 2022-04-23 Haskell Oklahoma 40061 2775 41
2433372 2433372 2022-04-22 Haskell Oklahoma 40061 2775 41
2430116 2430116 2022-04-21 Haskell Oklahoma 40061 2775 41
2426860 2426860 2022-04-20 Haskell Oklahoma 40061 2776 39
2423604 2423604 2022-04-19 Haskell Oklahoma 40061 2776 39
2420347 2420347 2022-04-18 Haskell Oklahoma 40061 2776 39
2417092 2417092 2022-04-17 Haskell Oklahoma 40061 2776 39
2413836 2413836 2022-04-16 Haskell Oklahoma 40061 2776 39
2410580 2410580 2022-04-15 Haskell Oklahoma 40061 2776 39
2407324 2407324 2022-04-14 Haskell Oklahoma 40061 2776 39
2404068 2404068 2022-04-13 Haskell Oklahoma 40061 2777 39
2400813 2400813 2022-04-12 Haskell Oklahoma 40061 2777 39
2397558 2397558 2022-04-11 Haskell Oklahoma 40061 2777 39
2394303 2394303 2022-04-10 Haskell Oklahoma 40061 2777 39
2391047 2391047 2022-04-09 Haskell Oklahoma 40061 2777 39
2387791 2387791 2022-04-08 Haskell Oklahoma 40061 2777 39
2384536 2384536 2022-04-07 Haskell Oklahoma 40061 2777 39
2381281 2381281 2022-04-06 Haskell Oklahoma 40061 2776 39
2378026 2378026 2022-04-05 Haskell Oklahoma 40061 2776 39
2374772 2374772 2022-04-04 Haskell Oklahoma 40061 2776 39
2371520 2371520 2022-04-03 Haskell Oklahoma 40061 2776 39
2368267 2368267 2022-04-02 Haskell Oklahoma 40061 2776 39
2365014 2365014 2022-04-01 Haskell Oklahoma 40061 2776 39
2361761 2361761 2022-03-31 Haskell Oklahoma 40061 2776 39
2358507 2358507 2022-03-30 Haskell Oklahoma 40061 2773 39
2355253 2355253 2022-03-29 Haskell Oklahoma 40061 2773 39
2352000 2352000 2022-03-28 Haskell Oklahoma 40061 2773 39
2348748 2348748 2022-03-27 Haskell Oklahoma 40061 2773 39
2345495 2345495 2022-03-26 Haskell Oklahoma 40061 2773 39
2342242 2342242 2022-03-25 Haskell Oklahoma 40061 2773 39
2338989 2338989 2022-03-24 Haskell Oklahoma 40061 2773 39
2335735 2335735 2022-03-23 Haskell Oklahoma 40061 2777 39
2332481 2332481 2022-03-22 Haskell Oklahoma 40061 2777 39
2329228 2329228 2022-03-21 Haskell Oklahoma 40061 2777 39
2325976 2325976 2022-03-20 Haskell Oklahoma 40061 2777 39
2322723 2322723 2022-03-19 Haskell Oklahoma 40061 2777 39
2319469 2319469 2022-03-18 Haskell Oklahoma 40061 2777 39
2316215 2316215 2022-03-17 Haskell Oklahoma 40061 2777 39
2312962 2312962 2022-03-16 Haskell Oklahoma 40061 2776 39
2309709 2309709 2022-03-15 Haskell Oklahoma 40061 2776 39
2306456 2306456 2022-03-14 Haskell Oklahoma 40061 2776 39
2303205 2303205 2022-03-13 Haskell Oklahoma 40061 2776 39
2299953 2299953 2022-03-12 Haskell Oklahoma 40061 2776 39
2296701 2296701 2022-03-11 Haskell Oklahoma 40061 2776 39
2293449 2293449 2022-03-10 Haskell Oklahoma 40061 2776 39
2290197 2290197 2022-03-09 Haskell Oklahoma 40061 2767 37
2286945 2286945 2022-03-08 Haskell Oklahoma 40061 2767 37
2283693 2283693 2022-03-07 Haskell Oklahoma 40061 2767 37
2280441 2280441 2022-03-06 Haskell Oklahoma 40061 2767 37
2277188 2277188 2022-03-05 Haskell Oklahoma 40061 2767 37
2273935 2273935 2022-03-04 Haskell Oklahoma 40061 2767 37
2270682 2270682 2022-03-03 Haskell Oklahoma 40061 2767 37
2267430 2267430 2022-03-02 Haskell Oklahoma 40061 2767 37
2264177 2264177 2022-03-01 Haskell Oklahoma 40061 2760 36
2260927 2260927 2022-02-28 Haskell Oklahoma 40061 2760 36
2257676 2257676 2022-02-27 Haskell Oklahoma 40061 2760 36
2254425 2254425 2022-02-26 Haskell Oklahoma 40061 2760 36
2251174 2251174 2022-02-25 Haskell Oklahoma 40061 2760 36
2247923 2247923 2022-02-24 Haskell Oklahoma 40061 2760 36
2244672 2244672 2022-02-23 Haskell Oklahoma 40061 2760 36
2241421 2241421 2022-02-22 Haskell Oklahoma 40061 2751 35
2238170 2238170 2022-02-21 Haskell Oklahoma 40061 2751 35
2234919 2234919 2022-02-20 Haskell Oklahoma 40061 2751 35
2231668 2231668 2022-02-19 Haskell Oklahoma 40061 2751 35
2228417 2228417 2022-02-18 Haskell Oklahoma 40061 2751 35
2225166 2225166 2022-02-17 Haskell Oklahoma 40061 2751 35
2221915 2221915 2022-02-16 Haskell Oklahoma 40061 2751 35
2218664 2218664 2022-02-15 Haskell Oklahoma 40061 2723 35
2215413 2215413 2022-02-14 Haskell Oklahoma 40061 2723 35
2212162 2212162 2022-02-13 Haskell Oklahoma 40061 2723 35
2208909 2208909 2022-02-12 Haskell Oklahoma 40061 2723 35
2205656 2205656 2022-02-11 Haskell Oklahoma 40061 2723 35
2202403 2202403 2022-02-10 Haskell Oklahoma 40061 2723 35
2199149 2199149 2022-02-09 Haskell Oklahoma 40061 2723 35
2195895 2195895 2022-02-08 Haskell Oklahoma 40061 2614 33
2192641 2192641 2022-02-07 Haskell Oklahoma 40061 2614 33
2189387 2189387 2022-02-06 Haskell Oklahoma 40061 2614 33
2186134 2186134 2022-02-05 Haskell Oklahoma 40061 2614 33
2182882 2182882 2022-02-04 Haskell Oklahoma 40061 2614 33
2179630 2179630 2022-02-03 Haskell Oklahoma 40061 2614 33

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