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

788 rows where county = "Calhoun", fips = 45017 and state = "South Carolina" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • South Carolina · 788 ✖

fips 1

  • 45017 · 788 ✖

county 1

  • Calhoun · 788 ✖
Link rowid date ▲ county state fips cases deaths
2502007 2502007 2022-05-13 Calhoun South Carolina 45017 2799 61
2498749 2498749 2022-05-12 Calhoun South Carolina 45017 2799 61
2495491 2495491 2022-05-11 Calhoun South Carolina 45017 2799 61
2492233 2492233 2022-05-10 Calhoun South Carolina 45017 2796 61
2488975 2488975 2022-05-09 Calhoun South Carolina 45017 2796 61
2485718 2485718 2022-05-08 Calhoun South Carolina 45017 2796 61
2482460 2482460 2022-05-07 Calhoun South Carolina 45017 2796 61
2479202 2479202 2022-05-06 Calhoun South Carolina 45017 2796 61
2475944 2475944 2022-05-05 Calhoun South Carolina 45017 2796 61
2472687 2472687 2022-05-04 Calhoun South Carolina 45017 2796 61
2469431 2469431 2022-05-03 Calhoun South Carolina 45017 2796 61
2466175 2466175 2022-05-02 Calhoun South Carolina 45017 2790 61
2462920 2462920 2022-05-01 Calhoun South Carolina 45017 2790 61
2459664 2459664 2022-04-30 Calhoun South Carolina 45017 2790 61
2456408 2456408 2022-04-29 Calhoun South Carolina 45017 2790 61
2453152 2453152 2022-04-28 Calhoun South Carolina 45017 2790 61
2449896 2449896 2022-04-27 Calhoun South Carolina 45017 2789 61
2446639 2446639 2022-04-26 Calhoun South Carolina 45017 2789 61
2443384 2443384 2022-04-25 Calhoun South Carolina 45017 2789 61
2440128 2440128 2022-04-24 Calhoun South Carolina 45017 2789 61
2436872 2436872 2022-04-23 Calhoun South Carolina 45017 2789 61
2433616 2433616 2022-04-22 Calhoun South Carolina 45017 2789 61
2430360 2430360 2022-04-21 Calhoun South Carolina 45017 2789 61
2427104 2427104 2022-04-20 Calhoun South Carolina 45017 2789 61
2423848 2423848 2022-04-19 Calhoun South Carolina 45017 2789 61
2420592 2420592 2022-04-18 Calhoun South Carolina 45017 2784 61
2417336 2417336 2022-04-17 Calhoun South Carolina 45017 2784 61
2414080 2414080 2022-04-16 Calhoun South Carolina 45017 2784 61
2410824 2410824 2022-04-15 Calhoun South Carolina 45017 2784 61
2407568 2407568 2022-04-14 Calhoun South Carolina 45017 2784 61
2404312 2404312 2022-04-13 Calhoun South Carolina 45017 2784 61
2401057 2401057 2022-04-12 Calhoun South Carolina 45017 2784 61
2397802 2397802 2022-04-11 Calhoun South Carolina 45017 2783 61
2394547 2394547 2022-04-10 Calhoun South Carolina 45017 2783 61
2391291 2391291 2022-04-09 Calhoun South Carolina 45017 2783 61
2388035 2388035 2022-04-08 Calhoun South Carolina 45017 2783 61
2384780 2384780 2022-04-07 Calhoun South Carolina 45017 2783 61
2381525 2381525 2022-04-06 Calhoun South Carolina 45017 2783 61
2378270 2378270 2022-04-05 Calhoun South Carolina 45017 2783 61
2375016 2375016 2022-04-04 Calhoun South Carolina 45017 2782 61
2371764 2371764 2022-04-03 Calhoun South Carolina 45017 2782 61
2368511 2368511 2022-04-02 Calhoun South Carolina 45017 2782 61
2365258 2365258 2022-04-01 Calhoun South Carolina 45017 2782 61
2362005 2362005 2022-03-31 Calhoun South Carolina 45017 2782 61
2358751 2358751 2022-03-30 Calhoun South Carolina 45017 2782 61
2355497 2355497 2022-03-29 Calhoun South Carolina 45017 2782 61
2352244 2352244 2022-03-28 Calhoun South Carolina 45017 2778 61
2348992 2348992 2022-03-27 Calhoun South Carolina 45017 2778 61
2345739 2345739 2022-03-26 Calhoun South Carolina 45017 2778 61
2342486 2342486 2022-03-25 Calhoun South Carolina 45017 2778 61
2339233 2339233 2022-03-24 Calhoun South Carolina 45017 2778 61
2335979 2335979 2022-03-23 Calhoun South Carolina 45017 2778 61
2332725 2332725 2022-03-22 Calhoun South Carolina 45017 2778 61
2329472 2329472 2022-03-21 Calhoun South Carolina 45017 2773 61
2326220 2326220 2022-03-20 Calhoun South Carolina 45017 2773 61
2322967 2322967 2022-03-19 Calhoun South Carolina 45017 2773 61
2319713 2319713 2022-03-18 Calhoun South Carolina 45017 2773 61
2316459 2316459 2022-03-17 Calhoun South Carolina 45017 2773 61
2313206 2313206 2022-03-16 Calhoun South Carolina 45017 2773 61
2309953 2309953 2022-03-15 Calhoun South Carolina 45017 2773 61
2306700 2306700 2022-03-14 Calhoun South Carolina 45017 2772 61
2303449 2303449 2022-03-13 Calhoun South Carolina 45017 2772 61
2300197 2300197 2022-03-12 Calhoun South Carolina 45017 2772 61
2296945 2296945 2022-03-11 Calhoun South Carolina 45017 2772 61
2293693 2293693 2022-03-10 Calhoun South Carolina 45017 2772 61
2290441 2290441 2022-03-09 Calhoun South Carolina 45017 2769 60
2287189 2287189 2022-03-08 Calhoun South Carolina 45017 2766 60
2283937 2283937 2022-03-07 Calhoun South Carolina 45017 2766 60
2280685 2280685 2022-03-06 Calhoun South Carolina 45017 2763 58
2277432 2277432 2022-03-05 Calhoun South Carolina 45017 2763 58
2274179 2274179 2022-03-04 Calhoun South Carolina 45017 2763 58
2270926 2270926 2022-03-03 Calhoun South Carolina 45017 2762 58
2267674 2267674 2022-03-02 Calhoun South Carolina 45017 2762 58
2264421 2264421 2022-03-01 Calhoun South Carolina 45017 2761 58
2261171 2261171 2022-02-28 Calhoun South Carolina 45017 2758 58
2257920 2257920 2022-02-27 Calhoun South Carolina 45017 2750 58
2254669 2254669 2022-02-26 Calhoun South Carolina 45017 2750 58
2251418 2251418 2022-02-25 Calhoun South Carolina 45017 2750 58
2248167 2248167 2022-02-24 Calhoun South Carolina 45017 2747 58
2244916 2244916 2022-02-23 Calhoun South Carolina 45017 2745 57
2241665 2241665 2022-02-22 Calhoun South Carolina 45017 2736 57
2238414 2238414 2022-02-21 Calhoun South Carolina 45017 2724 57
2235163 2235163 2022-02-20 Calhoun South Carolina 45017 2724 57
2231912 2231912 2022-02-19 Calhoun South Carolina 45017 2724 57
2228661 2228661 2022-02-18 Calhoun South Carolina 45017 2724 57
2225410 2225410 2022-02-17 Calhoun South Carolina 45017 2719 57
2222159 2222159 2022-02-16 Calhoun South Carolina 45017 2713 57
2218908 2218908 2022-02-15 Calhoun South Carolina 45017 2710 55
2215657 2215657 2022-02-14 Calhoun South Carolina 45017 2709 55
2212406 2212406 2022-02-13 Calhoun South Carolina 45017 2692 55
2209153 2209153 2022-02-12 Calhoun South Carolina 45017 2692 55
2205900 2205900 2022-02-11 Calhoun South Carolina 45017 2692 55
2202647 2202647 2022-02-10 Calhoun South Carolina 45017 2692 55
2199393 2199393 2022-02-09 Calhoun South Carolina 45017 2687 55
2196139 2196139 2022-02-08 Calhoun South Carolina 45017 2685 55
2192885 2192885 2022-02-07 Calhoun South Carolina 45017 2685 55
2189631 2189631 2022-02-06 Calhoun South Carolina 45017 2664 54
2186378 2186378 2022-02-05 Calhoun South Carolina 45017 2664 54
2183126 2183126 2022-02-04 Calhoun South Carolina 45017 2664 54
2179874 2179874 2022-02-03 Calhoun South Carolina 45017 2657 54

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