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,307 rows where county = "Todd" 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

  • Todd · 2,307 ✖
Link rowid date ▲ county state fips cases deaths
2500688 2500688 2022-05-13 Todd Kentucky 21219 2982 43
2500981 2500981 2022-05-13 Todd Minnesota 27153 6898 58
2502104 2502104 2022-05-13 Todd South Dakota 46121 2975 53
2497430 2497430 2022-05-12 Todd Kentucky 21219 2982 43
2497723 2497723 2022-05-12 Todd Minnesota 27153 6890 58
2498846 2498846 2022-05-12 Todd South Dakota 46121 2975 53
2494172 2494172 2022-05-11 Todd Kentucky 21219 2982 43
2494465 2494465 2022-05-11 Todd Minnesota 27153 6884 58
2495588 2495588 2022-05-11 Todd South Dakota 46121 2975 53
2490914 2490914 2022-05-10 Todd Kentucky 21219 2982 43
2491207 2491207 2022-05-10 Todd Minnesota 27153 6876 58
2492330 2492330 2022-05-10 Todd South Dakota 46121 2974 53
2487657 2487657 2022-05-09 Todd Kentucky 21219 2982 43
2487950 2487950 2022-05-09 Todd Minnesota 27153 6863 58
2489072 2489072 2022-05-09 Todd South Dakota 46121 2974 53
2484399 2484399 2022-05-08 Todd Kentucky 21219 2987 43
2484692 2484692 2022-05-08 Todd Minnesota 27153 6853 58
2485815 2485815 2022-05-08 Todd South Dakota 46121 2974 53
2481141 2481141 2022-05-07 Todd Kentucky 21219 2987 43
2481434 2481434 2022-05-07 Todd Minnesota 27153 6853 58
2482557 2482557 2022-05-07 Todd South Dakota 46121 2974 53
2477883 2477883 2022-05-06 Todd Kentucky 21219 2987 43
2478176 2478176 2022-05-06 Todd Minnesota 27153 6853 58
2479299 2479299 2022-05-06 Todd South Dakota 46121 2974 53
2474625 2474625 2022-05-05 Todd Kentucky 21219 2987 43
2474918 2474918 2022-05-05 Todd Minnesota 27153 6841 58
2476041 2476041 2022-05-05 Todd South Dakota 46121 2974 53
2471368 2471368 2022-05-04 Todd Kentucky 21219 2987 43
2471661 2471661 2022-05-04 Todd Minnesota 27153 6835 58
2472784 2472784 2022-05-04 Todd South Dakota 46121 2974 53
2468112 2468112 2022-05-03 Todd Kentucky 21219 2987 43
2468405 2468405 2022-05-03 Todd Minnesota 27153 6831 58
2469528 2469528 2022-05-03 Todd South Dakota 46121 2974 53
2464857 2464857 2022-05-02 Todd Kentucky 21219 2987 43
2465150 2465150 2022-05-02 Todd Minnesota 27153 6822 58
2466272 2466272 2022-05-02 Todd South Dakota 46121 2974 53
2461601 2461601 2022-05-01 Todd Kentucky 21219 2981 43
2461894 2461894 2022-05-01 Todd Minnesota 27153 6820 58
2463017 2463017 2022-05-01 Todd South Dakota 46121 2974 53
2458345 2458345 2022-04-30 Todd Kentucky 21219 2981 43
2458638 2458638 2022-04-30 Todd Minnesota 27153 6820 58
2459761 2459761 2022-04-30 Todd South Dakota 46121 2974 53
2455089 2455089 2022-04-29 Todd Kentucky 21219 2981 43
2455382 2455382 2022-04-29 Todd Minnesota 27153 6820 58
2456505 2456505 2022-04-29 Todd South Dakota 46121 2974 53
2451833 2451833 2022-04-28 Todd Kentucky 21219 2981 43
2452126 2452126 2022-04-28 Todd Minnesota 27153 6813 58
2453249 2453249 2022-04-28 Todd South Dakota 46121 2974 53
2448577 2448577 2022-04-27 Todd Kentucky 21219 2981 43
2448870 2448870 2022-04-27 Todd Minnesota 27153 6812 58
2449993 2449993 2022-04-27 Todd South Dakota 46121 2974 53
2445321 2445321 2022-04-26 Todd Kentucky 21219 2981 43
2445614 2445614 2022-04-26 Todd Minnesota 27153 6806 58
2446736 2446736 2022-04-26 Todd South Dakota 46121 2974 53
2442065 2442065 2022-04-25 Todd Kentucky 21219 2981 43
2442358 2442358 2022-04-25 Todd Minnesota 27153 6798 58
2443481 2443481 2022-04-25 Todd South Dakota 46121 2974 53
2438809 2438809 2022-04-24 Todd Kentucky 21219 2973 43
2439102 2439102 2022-04-24 Todd Minnesota 27153 6798 58
2440225 2440225 2022-04-24 Todd South Dakota 46121 2974 53
2435553 2435553 2022-04-23 Todd Kentucky 21219 2973 43
2435846 2435846 2022-04-23 Todd Minnesota 27153 6798 58
2436969 2436969 2022-04-23 Todd South Dakota 46121 2974 53
2432297 2432297 2022-04-22 Todd Kentucky 21219 2973 43
2432590 2432590 2022-04-22 Todd Minnesota 27153 6798 58
2433713 2433713 2022-04-22 Todd South Dakota 46121 2974 53
2429041 2429041 2022-04-21 Todd Kentucky 21219 2973 43
2429334 2429334 2022-04-21 Todd Minnesota 27153 6789 58
2430457 2430457 2022-04-21 Todd South Dakota 46121 2974 53
2425785 2425785 2022-04-20 Todd Kentucky 21219 2973 43
2426078 2426078 2022-04-20 Todd Minnesota 27153 6784 58
2427201 2427201 2022-04-20 Todd South Dakota 46121 2974 53
2422529 2422529 2022-04-19 Todd Kentucky 21219 2973 43
2422822 2422822 2022-04-19 Todd Minnesota 27153 6778 57
2423945 2423945 2022-04-19 Todd South Dakota 46121 2973 53
2419273 2419273 2022-04-18 Todd Kentucky 21219 2973 43
2419566 2419566 2022-04-18 Todd Minnesota 27153 6775 57
2420689 2420689 2022-04-18 Todd South Dakota 46121 2973 53
2416017 2416017 2022-04-17 Todd Kentucky 21219 2961 43
2416310 2416310 2022-04-17 Todd Minnesota 27153 6775 57
2417433 2417433 2022-04-17 Todd South Dakota 46121 2973 53
2412761 2412761 2022-04-16 Todd Kentucky 21219 2961 43
2413054 2413054 2022-04-16 Todd Minnesota 27153 6775 57
2414177 2414177 2022-04-16 Todd South Dakota 46121 2973 53
2409505 2409505 2022-04-15 Todd Kentucky 21219 2961 43
2409798 2409798 2022-04-15 Todd Minnesota 27153 6775 57
2410921 2410921 2022-04-15 Todd South Dakota 46121 2973 53
2406249 2406249 2022-04-14 Todd Kentucky 21219 2961 43
2406542 2406542 2022-04-14 Todd Minnesota 27153 6767 57
2407665 2407665 2022-04-14 Todd South Dakota 46121 2973 53
2402993 2402993 2022-04-13 Todd Kentucky 21219 2961 43
2403286 2403286 2022-04-13 Todd Minnesota 27153 6765 57
2404409 2404409 2022-04-13 Todd South Dakota 46121 2973 53
2399739 2399739 2022-04-12 Todd Kentucky 21219 2961 43
2400032 2400032 2022-04-12 Todd Minnesota 27153 6761 57
2401154 2401154 2022-04-12 Todd South Dakota 46121 2972 52
2396483 2396483 2022-04-11 Todd Kentucky 21219 2961 43
2396776 2396776 2022-04-11 Todd Minnesota 27153 6759 57
2397899 2397899 2022-04-11 Todd South Dakota 46121 2972 52
2393228 2393228 2022-04-10 Todd Kentucky 21219 2961 43

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