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

2,240 rows where county = "Haskell" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 3

fips 3

county 1

  • Haskell · 2,240 ✖
Link rowid date ▲ county state fips cases deaths
2500513 2500513 2022-05-13 Haskell Kansas 20081 964 11
2501763 2501763 2022-05-13 Haskell Oklahoma 40061 2796 41
2502310 2502310 2022-05-13 Haskell Texas 48207 897 39
2497255 2497255 2022-05-12 Haskell Kansas 20081 963 11
2498505 2498505 2022-05-12 Haskell Oklahoma 40061 2796 41
2499052 2499052 2022-05-12 Haskell Texas 48207 897 39
2493997 2493997 2022-05-11 Haskell Kansas 20081 963 11
2495247 2495247 2022-05-11 Haskell Oklahoma 40061 2778 41
2495794 2495794 2022-05-11 Haskell Texas 48207 897 39
2490739 2490739 2022-05-10 Haskell Kansas 20081 963 11
2491989 2491989 2022-05-10 Haskell Oklahoma 40061 2778 41
2492536 2492536 2022-05-10 Haskell Texas 48207 897 39
2487482 2487482 2022-05-09 Haskell Kansas 20081 963 11
2488731 2488731 2022-05-09 Haskell Oklahoma 40061 2778 41
2489278 2489278 2022-05-09 Haskell Texas 48207 897 39
2484224 2484224 2022-05-08 Haskell Kansas 20081 963 11
2485474 2485474 2022-05-08 Haskell Oklahoma 40061 2778 41
2486021 2486021 2022-05-08 Haskell Texas 48207 897 39
2480966 2480966 2022-05-07 Haskell Kansas 20081 963 11
2482216 2482216 2022-05-07 Haskell Oklahoma 40061 2778 41
2482763 2482763 2022-05-07 Haskell Texas 48207 897 39
2477708 2477708 2022-05-06 Haskell Kansas 20081 963 11
2478958 2478958 2022-05-06 Haskell Oklahoma 40061 2778 41
2479505 2479505 2022-05-06 Haskell Texas 48207 897 39
2474450 2474450 2022-05-05 Haskell Kansas 20081 962 11
2475700 2475700 2022-05-05 Haskell Oklahoma 40061 2778 41
2476247 2476247 2022-05-05 Haskell Texas 48207 897 39
2471193 2471193 2022-05-04 Haskell Kansas 20081 962 11
2472443 2472443 2022-05-04 Haskell Oklahoma 40061 2776 41
2472990 2472990 2022-05-04 Haskell Texas 48207 897 39
2467937 2467937 2022-05-03 Haskell Kansas 20081 962 11
2469187 2469187 2022-05-03 Haskell Oklahoma 40061 2776 41
2469734 2469734 2022-05-03 Haskell Texas 48207 896 39
2464682 2464682 2022-05-02 Haskell Kansas 20081 962 11
2465931 2465931 2022-05-02 Haskell Oklahoma 40061 2776 41
2466478 2466478 2022-05-02 Haskell Texas 48207 896 39
2461426 2461426 2022-05-01 Haskell Kansas 20081 962 11
2462676 2462676 2022-05-01 Haskell Oklahoma 40061 2776 41
2463223 2463223 2022-05-01 Haskell Texas 48207 896 39
2458170 2458170 2022-04-30 Haskell Kansas 20081 962 11
2459420 2459420 2022-04-30 Haskell Oklahoma 40061 2776 41
2459967 2459967 2022-04-30 Haskell Texas 48207 896 39
2454914 2454914 2022-04-29 Haskell Kansas 20081 962 11
2456164 2456164 2022-04-29 Haskell Oklahoma 40061 2776 41
2456711 2456711 2022-04-29 Haskell Texas 48207 896 39
2451658 2451658 2022-04-28 Haskell Kansas 20081 962 11
2452908 2452908 2022-04-28 Haskell Oklahoma 40061 2776 41
2453455 2453455 2022-04-28 Haskell Texas 48207 896 39
2448402 2448402 2022-04-27 Haskell Kansas 20081 962 11
2449652 2449652 2022-04-27 Haskell Oklahoma 40061 2775 41
2450199 2450199 2022-04-27 Haskell Texas 48207 896 39
2445146 2445146 2022-04-26 Haskell Kansas 20081 962 11
2446395 2446395 2022-04-26 Haskell Oklahoma 40061 2775 41
2446942 2446942 2022-04-26 Haskell Texas 48207 896 39
2441890 2441890 2022-04-25 Haskell Kansas 20081 962 11
2443140 2443140 2022-04-25 Haskell Oklahoma 40061 2775 41
2443687 2443687 2022-04-25 Haskell Texas 48207 896 39
2438634 2438634 2022-04-24 Haskell Kansas 20081 962 11
2439884 2439884 2022-04-24 Haskell Oklahoma 40061 2775 41
2440431 2440431 2022-04-24 Haskell Texas 48207 896 39
2435378 2435378 2022-04-23 Haskell Kansas 20081 962 11
2436628 2436628 2022-04-23 Haskell Oklahoma 40061 2775 41
2437175 2437175 2022-04-23 Haskell Texas 48207 896 39
2432122 2432122 2022-04-22 Haskell Kansas 20081 962 11
2433372 2433372 2022-04-22 Haskell Oklahoma 40061 2775 41
2433919 2433919 2022-04-22 Haskell Texas 48207 896 39
2428866 2428866 2022-04-21 Haskell Kansas 20081 962 11
2430116 2430116 2022-04-21 Haskell Oklahoma 40061 2775 41
2430663 2430663 2022-04-21 Haskell Texas 48207 896 39
2425610 2425610 2022-04-20 Haskell Kansas 20081 962 11
2426860 2426860 2022-04-20 Haskell Oklahoma 40061 2776 39
2427407 2427407 2022-04-20 Haskell Texas 48207 896 39
2422354 2422354 2022-04-19 Haskell Kansas 20081 962 11
2423604 2423604 2022-04-19 Haskell Oklahoma 40061 2776 39
2424151 2424151 2022-04-19 Haskell Texas 48207 896 39
2419098 2419098 2022-04-18 Haskell Kansas 20081 962 11
2420347 2420347 2022-04-18 Haskell Oklahoma 40061 2776 39
2420895 2420895 2022-04-18 Haskell Texas 48207 896 39
2415842 2415842 2022-04-17 Haskell Kansas 20081 962 11
2417092 2417092 2022-04-17 Haskell Oklahoma 40061 2776 39
2417639 2417639 2022-04-17 Haskell Texas 48207 896 39
2412586 2412586 2022-04-16 Haskell Kansas 20081 962 11
2413836 2413836 2022-04-16 Haskell Oklahoma 40061 2776 39
2414383 2414383 2022-04-16 Haskell Texas 48207 896 39
2409330 2409330 2022-04-15 Haskell Kansas 20081 962 11
2410580 2410580 2022-04-15 Haskell Oklahoma 40061 2776 39
2411127 2411127 2022-04-15 Haskell Texas 48207 896 39
2406074 2406074 2022-04-14 Haskell Kansas 20081 961 11
2407324 2407324 2022-04-14 Haskell Oklahoma 40061 2776 39
2407871 2407871 2022-04-14 Haskell Texas 48207 896 39
2402818 2402818 2022-04-13 Haskell Kansas 20081 961 11
2404068 2404068 2022-04-13 Haskell Oklahoma 40061 2777 39
2404615 2404615 2022-04-13 Haskell Texas 48207 896 39
2399564 2399564 2022-04-12 Haskell Kansas 20081 961 11
2400813 2400813 2022-04-12 Haskell Oklahoma 40061 2777 39
2401360 2401360 2022-04-12 Haskell Texas 48207 895 39
2396308 2396308 2022-04-11 Haskell Kansas 20081 961 11
2397558 2397558 2022-04-11 Haskell Oklahoma 40061 2777 39
2398105 2398105 2022-04-11 Haskell Texas 48207 895 39
2393053 2393053 2022-04-10 Haskell Kansas 20081 961 11

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