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

795 rows where county = "Charles Mix" and state = "South Dakota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • South Dakota · 795 ✖

fips 1

county 1

  • Charles Mix · 795 ✖
Link rowid date ▲ county state fips cases deaths
2502055 2502055 2022-05-13 Charles Mix South Dakota 46023 2942 35
2498797 2498797 2022-05-12 Charles Mix South Dakota 46023 2942 35
2495539 2495539 2022-05-11 Charles Mix South Dakota 46023 2942 35
2492281 2492281 2022-05-10 Charles Mix South Dakota 46023 2941 35
2489023 2489023 2022-05-09 Charles Mix South Dakota 46023 2941 35
2485766 2485766 2022-05-08 Charles Mix South Dakota 46023 2941 35
2482508 2482508 2022-05-07 Charles Mix South Dakota 46023 2941 35
2479250 2479250 2022-05-06 Charles Mix South Dakota 46023 2941 35
2475992 2475992 2022-05-05 Charles Mix South Dakota 46023 2941 35
2472735 2472735 2022-05-04 Charles Mix South Dakota 46023 2941 35
2469479 2469479 2022-05-03 Charles Mix South Dakota 46023 2934 35
2466223 2466223 2022-05-02 Charles Mix South Dakota 46023 2934 35
2462968 2462968 2022-05-01 Charles Mix South Dakota 46023 2934 35
2459712 2459712 2022-04-30 Charles Mix South Dakota 46023 2934 35
2456456 2456456 2022-04-29 Charles Mix South Dakota 46023 2934 35
2453200 2453200 2022-04-28 Charles Mix South Dakota 46023 2934 35
2449944 2449944 2022-04-27 Charles Mix South Dakota 46023 2934 35
2446687 2446687 2022-04-26 Charles Mix South Dakota 46023 2931 35
2443432 2443432 2022-04-25 Charles Mix South Dakota 46023 2931 35
2440176 2440176 2022-04-24 Charles Mix South Dakota 46023 2931 35
2436920 2436920 2022-04-23 Charles Mix South Dakota 46023 2931 35
2433664 2433664 2022-04-22 Charles Mix South Dakota 46023 2931 35
2430408 2430408 2022-04-21 Charles Mix South Dakota 46023 2931 35
2427152 2427152 2022-04-20 Charles Mix South Dakota 46023 2931 35
2423896 2423896 2022-04-19 Charles Mix South Dakota 46023 2927 35
2420640 2420640 2022-04-18 Charles Mix South Dakota 46023 2927 35
2417384 2417384 2022-04-17 Charles Mix South Dakota 46023 2927 35
2414128 2414128 2022-04-16 Charles Mix South Dakota 46023 2927 35
2410872 2410872 2022-04-15 Charles Mix South Dakota 46023 2927 35
2407616 2407616 2022-04-14 Charles Mix South Dakota 46023 2927 35
2404360 2404360 2022-04-13 Charles Mix South Dakota 46023 2927 35
2401105 2401105 2022-04-12 Charles Mix South Dakota 46023 2927 35
2397850 2397850 2022-04-11 Charles Mix South Dakota 46023 2927 35
2394595 2394595 2022-04-10 Charles Mix South Dakota 46023 2927 35
2391339 2391339 2022-04-09 Charles Mix South Dakota 46023 2927 35
2388083 2388083 2022-04-08 Charles Mix South Dakota 46023 2927 35
2384828 2384828 2022-04-07 Charles Mix South Dakota 46023 2927 35
2381573 2381573 2022-04-06 Charles Mix South Dakota 46023 2927 35
2378318 2378318 2022-04-05 Charles Mix South Dakota 46023 2926 35
2375064 2375064 2022-04-04 Charles Mix South Dakota 46023 2926 35
2371812 2371812 2022-04-03 Charles Mix South Dakota 46023 2926 35
2368559 2368559 2022-04-02 Charles Mix South Dakota 46023 2926 35
2365306 2365306 2022-04-01 Charles Mix South Dakota 46023 2926 35
2362053 2362053 2022-03-31 Charles Mix South Dakota 46023 2926 35
2358799 2358799 2022-03-30 Charles Mix South Dakota 46023 2926 35
2355545 2355545 2022-03-29 Charles Mix South Dakota 46023 2924 35
2352292 2352292 2022-03-28 Charles Mix South Dakota 46023 2924 35
2349040 2349040 2022-03-27 Charles Mix South Dakota 46023 2924 35
2345787 2345787 2022-03-26 Charles Mix South Dakota 46023 2924 35
2342534 2342534 2022-03-25 Charles Mix South Dakota 46023 2924 35
2339281 2339281 2022-03-24 Charles Mix South Dakota 46023 2924 35
2336027 2336027 2022-03-23 Charles Mix South Dakota 46023 2924 35
2332773 2332773 2022-03-22 Charles Mix South Dakota 46023 2924 35
2329520 2329520 2022-03-21 Charles Mix South Dakota 46023 2924 35
2326268 2326268 2022-03-20 Charles Mix South Dakota 46023 2924 35
2323015 2323015 2022-03-19 Charles Mix South Dakota 46023 2924 35
2319761 2319761 2022-03-18 Charles Mix South Dakota 46023 2924 35
2316507 2316507 2022-03-17 Charles Mix South Dakota 46023 2924 35
2313254 2313254 2022-03-16 Charles Mix South Dakota 46023 2924 35
2310001 2310001 2022-03-15 Charles Mix South Dakota 46023 2923 34
2306748 2306748 2022-03-14 Charles Mix South Dakota 46023 2923 34
2303497 2303497 2022-03-13 Charles Mix South Dakota 46023 2923 34
2300245 2300245 2022-03-12 Charles Mix South Dakota 46023 2923 34
2296993 2296993 2022-03-11 Charles Mix South Dakota 46023 2923 34
2293741 2293741 2022-03-10 Charles Mix South Dakota 46023 2923 34
2290489 2290489 2022-03-09 Charles Mix South Dakota 46023 2923 33
2287237 2287237 2022-03-08 Charles Mix South Dakota 46023 2921 33
2283985 2283985 2022-03-07 Charles Mix South Dakota 46023 2918 33
2280733 2280733 2022-03-06 Charles Mix South Dakota 46023 2917 33
2277480 2277480 2022-03-05 Charles Mix South Dakota 46023 2917 33
2274227 2274227 2022-03-04 Charles Mix South Dakota 46023 2917 33
2270974 2270974 2022-03-03 Charles Mix South Dakota 46023 2915 33
2267722 2267722 2022-03-02 Charles Mix South Dakota 46023 2916 33
2264469 2264469 2022-03-01 Charles Mix South Dakota 46023 2914 33
2261219 2261219 2022-02-28 Charles Mix South Dakota 46023 2912 33
2257968 2257968 2022-02-27 Charles Mix South Dakota 46023 2909 33
2254717 2254717 2022-02-26 Charles Mix South Dakota 46023 2909 33
2251466 2251466 2022-02-25 Charles Mix South Dakota 46023 2909 33
2248215 2248215 2022-02-24 Charles Mix South Dakota 46023 2910 33
2244964 2244964 2022-02-23 Charles Mix South Dakota 46023 2909 33
2241713 2241713 2022-02-22 Charles Mix South Dakota 46023 2908 33
2238462 2238462 2022-02-21 Charles Mix South Dakota 46023 2908 33
2235211 2235211 2022-02-20 Charles Mix South Dakota 46023 2908 33
2231960 2231960 2022-02-19 Charles Mix South Dakota 46023 2908 33
2228709 2228709 2022-02-18 Charles Mix South Dakota 46023 2908 33
2225458 2225458 2022-02-17 Charles Mix South Dakota 46023 2905 33
2222207 2222207 2022-02-16 Charles Mix South Dakota 46023 2904 32
2218956 2218956 2022-02-15 Charles Mix South Dakota 46023 2902 32
2215705 2215705 2022-02-14 Charles Mix South Dakota 46023 2898 32
2212454 2212454 2022-02-13 Charles Mix South Dakota 46023 2890 32
2209201 2209201 2022-02-12 Charles Mix South Dakota 46023 2890 32
2205948 2205948 2022-02-11 Charles Mix South Dakota 46023 2890 32
2202695 2202695 2022-02-10 Charles Mix South Dakota 46023 2886 32
2199441 2199441 2022-02-09 Charles Mix South Dakota 46023 2882 32
2196187 2196187 2022-02-08 Charles Mix South Dakota 46023 2866 32
2192933 2192933 2022-02-07 Charles Mix South Dakota 46023 2860 32
2189679 2189679 2022-02-06 Charles Mix South Dakota 46023 2852 32
2186426 2186426 2022-02-05 Charles Mix South Dakota 46023 2852 32
2183174 2183174 2022-02-04 Charles Mix South Dakota 46023 2852 32
2179922 2179922 2022-02-03 Charles Mix South Dakota 46023 2837 32

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