ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
715 rows where county = "Edmunds" and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502066 | 2502066 | 2022-05-13 | Edmunds | South Dakota | 46045 | 949 | 16 |
2498808 | 2498808 | 2022-05-12 | Edmunds | South Dakota | 46045 | 949 | 16 |
2495550 | 2495550 | 2022-05-11 | Edmunds | South Dakota | 46045 | 949 | 16 |
2492292 | 2492292 | 2022-05-10 | Edmunds | South Dakota | 46045 | 944 | 16 |
2489034 | 2489034 | 2022-05-09 | Edmunds | South Dakota | 46045 | 944 | 16 |
2485777 | 2485777 | 2022-05-08 | Edmunds | South Dakota | 46045 | 944 | 16 |
2482519 | 2482519 | 2022-05-07 | Edmunds | South Dakota | 46045 | 944 | 16 |
2479261 | 2479261 | 2022-05-06 | Edmunds | South Dakota | 46045 | 944 | 16 |
2476003 | 2476003 | 2022-05-05 | Edmunds | South Dakota | 46045 | 944 | 16 |
2472746 | 2472746 | 2022-05-04 | Edmunds | South Dakota | 46045 | 944 | 16 |
2469490 | 2469490 | 2022-05-03 | Edmunds | South Dakota | 46045 | 942 | 16 |
2466234 | 2466234 | 2022-05-02 | Edmunds | South Dakota | 46045 | 942 | 16 |
2462979 | 2462979 | 2022-05-01 | Edmunds | South Dakota | 46045 | 942 | 16 |
2459723 | 2459723 | 2022-04-30 | Edmunds | South Dakota | 46045 | 942 | 16 |
2456467 | 2456467 | 2022-04-29 | Edmunds | South Dakota | 46045 | 942 | 16 |
2453211 | 2453211 | 2022-04-28 | Edmunds | South Dakota | 46045 | 942 | 16 |
2449955 | 2449955 | 2022-04-27 | Edmunds | South Dakota | 46045 | 942 | 16 |
2446698 | 2446698 | 2022-04-26 | Edmunds | South Dakota | 46045 | 940 | 16 |
2443443 | 2443443 | 2022-04-25 | Edmunds | South Dakota | 46045 | 940 | 16 |
2440187 | 2440187 | 2022-04-24 | Edmunds | South Dakota | 46045 | 940 | 16 |
2436931 | 2436931 | 2022-04-23 | Edmunds | South Dakota | 46045 | 940 | 16 |
2433675 | 2433675 | 2022-04-22 | Edmunds | South Dakota | 46045 | 940 | 16 |
2430419 | 2430419 | 2022-04-21 | Edmunds | South Dakota | 46045 | 940 | 16 |
2427163 | 2427163 | 2022-04-20 | Edmunds | South Dakota | 46045 | 940 | 16 |
2423907 | 2423907 | 2022-04-19 | Edmunds | South Dakota | 46045 | 940 | 16 |
2420651 | 2420651 | 2022-04-18 | Edmunds | South Dakota | 46045 | 940 | 16 |
2417395 | 2417395 | 2022-04-17 | Edmunds | South Dakota | 46045 | 940 | 16 |
2414139 | 2414139 | 2022-04-16 | Edmunds | South Dakota | 46045 | 940 | 16 |
2410883 | 2410883 | 2022-04-15 | Edmunds | South Dakota | 46045 | 940 | 16 |
2407627 | 2407627 | 2022-04-14 | Edmunds | South Dakota | 46045 | 940 | 16 |
2404371 | 2404371 | 2022-04-13 | Edmunds | South Dakota | 46045 | 940 | 16 |
2401116 | 2401116 | 2022-04-12 | Edmunds | South Dakota | 46045 | 939 | 16 |
2397861 | 2397861 | 2022-04-11 | Edmunds | South Dakota | 46045 | 939 | 16 |
2394606 | 2394606 | 2022-04-10 | Edmunds | South Dakota | 46045 | 939 | 16 |
2391350 | 2391350 | 2022-04-09 | Edmunds | South Dakota | 46045 | 939 | 16 |
2388094 | 2388094 | 2022-04-08 | Edmunds | South Dakota | 46045 | 939 | 16 |
2384839 | 2384839 | 2022-04-07 | Edmunds | South Dakota | 46045 | 939 | 16 |
2381584 | 2381584 | 2022-04-06 | Edmunds | South Dakota | 46045 | 939 | 16 |
2378329 | 2378329 | 2022-04-05 | Edmunds | South Dakota | 46045 | 939 | 16 |
2375075 | 2375075 | 2022-04-04 | Edmunds | South Dakota | 46045 | 939 | 16 |
2371823 | 2371823 | 2022-04-03 | Edmunds | South Dakota | 46045 | 939 | 16 |
2368570 | 2368570 | 2022-04-02 | Edmunds | South Dakota | 46045 | 939 | 16 |
2365317 | 2365317 | 2022-04-01 | Edmunds | South Dakota | 46045 | 939 | 16 |
2362064 | 2362064 | 2022-03-31 | Edmunds | South Dakota | 46045 | 939 | 16 |
2358810 | 2358810 | 2022-03-30 | Edmunds | South Dakota | 46045 | 939 | 16 |
2355556 | 2355556 | 2022-03-29 | Edmunds | South Dakota | 46045 | 938 | 16 |
2352303 | 2352303 | 2022-03-28 | Edmunds | South Dakota | 46045 | 938 | 16 |
2349051 | 2349051 | 2022-03-27 | Edmunds | South Dakota | 46045 | 938 | 16 |
2345798 | 2345798 | 2022-03-26 | Edmunds | South Dakota | 46045 | 938 | 16 |
2342545 | 2342545 | 2022-03-25 | Edmunds | South Dakota | 46045 | 938 | 16 |
2339292 | 2339292 | 2022-03-24 | Edmunds | South Dakota | 46045 | 938 | 16 |
2336038 | 2336038 | 2022-03-23 | Edmunds | South Dakota | 46045 | 938 | 16 |
2332784 | 2332784 | 2022-03-22 | Edmunds | South Dakota | 46045 | 938 | 16 |
2329531 | 2329531 | 2022-03-21 | Edmunds | South Dakota | 46045 | 938 | 16 |
2326279 | 2326279 | 2022-03-20 | Edmunds | South Dakota | 46045 | 938 | 16 |
2323026 | 2323026 | 2022-03-19 | Edmunds | South Dakota | 46045 | 938 | 16 |
2319772 | 2319772 | 2022-03-18 | Edmunds | South Dakota | 46045 | 938 | 16 |
2316518 | 2316518 | 2022-03-17 | Edmunds | South Dakota | 46045 | 937 | 16 |
2313265 | 2313265 | 2022-03-16 | Edmunds | South Dakota | 46045 | 937 | 16 |
2310012 | 2310012 | 2022-03-15 | Edmunds | South Dakota | 46045 | 937 | 16 |
2306759 | 2306759 | 2022-03-14 | Edmunds | South Dakota | 46045 | 937 | 16 |
2303508 | 2303508 | 2022-03-13 | Edmunds | South Dakota | 46045 | 936 | 16 |
2300256 | 2300256 | 2022-03-12 | Edmunds | South Dakota | 46045 | 936 | 16 |
2297004 | 2297004 | 2022-03-11 | Edmunds | South Dakota | 46045 | 936 | 16 |
2293752 | 2293752 | 2022-03-10 | Edmunds | South Dakota | 46045 | 936 | 16 |
2290500 | 2290500 | 2022-03-09 | Edmunds | South Dakota | 46045 | 936 | 16 |
2287248 | 2287248 | 2022-03-08 | Edmunds | South Dakota | 46045 | 936 | 16 |
2283996 | 2283996 | 2022-03-07 | Edmunds | South Dakota | 46045 | 936 | 16 |
2280744 | 2280744 | 2022-03-06 | Edmunds | South Dakota | 46045 | 936 | 16 |
2277491 | 2277491 | 2022-03-05 | Edmunds | South Dakota | 46045 | 936 | 16 |
2274238 | 2274238 | 2022-03-04 | Edmunds | South Dakota | 46045 | 936 | 16 |
2270985 | 2270985 | 2022-03-03 | Edmunds | South Dakota | 46045 | 934 | 16 |
2267733 | 2267733 | 2022-03-02 | Edmunds | South Dakota | 46045 | 933 | 16 |
2264480 | 2264480 | 2022-03-01 | Edmunds | South Dakota | 46045 | 932 | 16 |
2261230 | 2261230 | 2022-02-28 | Edmunds | South Dakota | 46045 | 932 | 16 |
2257979 | 2257979 | 2022-02-27 | Edmunds | South Dakota | 46045 | 929 | 16 |
2254728 | 2254728 | 2022-02-26 | Edmunds | South Dakota | 46045 | 929 | 16 |
2251477 | 2251477 | 2022-02-25 | Edmunds | South Dakota | 46045 | 929 | 16 |
2248226 | 2248226 | 2022-02-24 | Edmunds | South Dakota | 46045 | 925 | 16 |
2244975 | 2244975 | 2022-02-23 | Edmunds | South Dakota | 46045 | 926 | 16 |
2241724 | 2241724 | 2022-02-22 | Edmunds | South Dakota | 46045 | 925 | 16 |
2238473 | 2238473 | 2022-02-21 | Edmunds | South Dakota | 46045 | 924 | 16 |
2235222 | 2235222 | 2022-02-20 | Edmunds | South Dakota | 46045 | 924 | 16 |
2231971 | 2231971 | 2022-02-19 | Edmunds | South Dakota | 46045 | 924 | 16 |
2228720 | 2228720 | 2022-02-18 | Edmunds | South Dakota | 46045 | 924 | 16 |
2225469 | 2225469 | 2022-02-17 | Edmunds | South Dakota | 46045 | 923 | 16 |
2222218 | 2222218 | 2022-02-16 | Edmunds | South Dakota | 46045 | 922 | 16 |
2218967 | 2218967 | 2022-02-15 | Edmunds | South Dakota | 46045 | 922 | 16 |
2215716 | 2215716 | 2022-02-14 | Edmunds | South Dakota | 46045 | 922 | 16 |
2212465 | 2212465 | 2022-02-13 | Edmunds | South Dakota | 46045 | 922 | 16 |
2209212 | 2209212 | 2022-02-12 | Edmunds | South Dakota | 46045 | 922 | 16 |
2205959 | 2205959 | 2022-02-11 | Edmunds | South Dakota | 46045 | 922 | 16 |
2202706 | 2202706 | 2022-02-10 | Edmunds | South Dakota | 46045 | 920 | 16 |
2199452 | 2199452 | 2022-02-09 | Edmunds | South Dakota | 46045 | 918 | 16 |
2196198 | 2196198 | 2022-02-08 | Edmunds | South Dakota | 46045 | 914 | 16 |
2192944 | 2192944 | 2022-02-07 | Edmunds | South Dakota | 46045 | 912 | 16 |
2189690 | 2189690 | 2022-02-06 | Edmunds | South Dakota | 46045 | 909 | 16 |
2186437 | 2186437 | 2022-02-05 | Edmunds | South Dakota | 46045 | 909 | 16 |
2183185 | 2183185 | 2022-02-04 | Edmunds | South Dakota | 46045 | 909 | 16 |
2179933 | 2179933 | 2022-02-03 | Edmunds | South Dakota | 46045 | 905 | 16 |
Advanced export
JSON shape: default, array, newline-delimited
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);