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

783 rows where county = "Sioux" and state = "Iowa" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Iowa · 783 ✖

fips 1

county 1

  • Sioux · 783 ✖
Link rowid date ▲ county state fips cases deaths
2500456 2500456 2022-05-13 Sioux Iowa 19167 7987 87
2497198 2497198 2022-05-12 Sioux Iowa 19167 7987 87
2493940 2493940 2022-05-11 Sioux Iowa 19167 7987 87
2490682 2490682 2022-05-10 Sioux Iowa 19167 7982 86
2487425 2487425 2022-05-09 Sioux Iowa 19167 7982 86
2484167 2484167 2022-05-08 Sioux Iowa 19167 7982 86
2480909 2480909 2022-05-07 Sioux Iowa 19167 7982 86
2477651 2477651 2022-05-06 Sioux Iowa 19167 7982 86
2474393 2474393 2022-05-05 Sioux Iowa 19167 7982 86
2471136 2471136 2022-05-04 Sioux Iowa 19167 7982 86
2467880 2467880 2022-05-03 Sioux Iowa 19167 7980 86
2464625 2464625 2022-05-02 Sioux Iowa 19167 7980 86
2461369 2461369 2022-05-01 Sioux Iowa 19167 7980 86
2458113 2458113 2022-04-30 Sioux Iowa 19167 7980 86
2454857 2454857 2022-04-29 Sioux Iowa 19167 7980 86
2451601 2451601 2022-04-28 Sioux Iowa 19167 7980 86
2448345 2448345 2022-04-27 Sioux Iowa 19167 7980 86
2445089 2445089 2022-04-26 Sioux Iowa 19167 7982 86
2441833 2441833 2022-04-25 Sioux Iowa 19167 7982 86
2438577 2438577 2022-04-24 Sioux Iowa 19167 7982 86
2435321 2435321 2022-04-23 Sioux Iowa 19167 7982 86
2432065 2432065 2022-04-22 Sioux Iowa 19167 7982 86
2428809 2428809 2022-04-21 Sioux Iowa 19167 7982 86
2425553 2425553 2022-04-20 Sioux Iowa 19167 7982 86
2422297 2422297 2022-04-19 Sioux Iowa 19167 7986 86
2419041 2419041 2022-04-18 Sioux Iowa 19167 7986 86
2415785 2415785 2022-04-17 Sioux Iowa 19167 7986 86
2412529 2412529 2022-04-16 Sioux Iowa 19167 7986 86
2409273 2409273 2022-04-15 Sioux Iowa 19167 7986 86
2406017 2406017 2022-04-14 Sioux Iowa 19167 7986 86
2402761 2402761 2022-04-13 Sioux Iowa 19167 7986 86
2399507 2399507 2022-04-12 Sioux Iowa 19167 7981 86
2396251 2396251 2022-04-11 Sioux Iowa 19167 7981 86
2392996 2392996 2022-04-10 Sioux Iowa 19167 7981 86
2389740 2389740 2022-04-09 Sioux Iowa 19167 7981 86
2386484 2386484 2022-04-08 Sioux Iowa 19167 7981 86
2383230 2383230 2022-04-07 Sioux Iowa 19167 7981 86
2379975 2379975 2022-04-06 Sioux Iowa 19167 7981 86
2376720 2376720 2022-04-05 Sioux Iowa 19167 7983 86
2373468 2373468 2022-04-04 Sioux Iowa 19167 7983 86
2370215 2370215 2022-04-03 Sioux Iowa 19167 7983 86
2366962 2366962 2022-04-02 Sioux Iowa 19167 7983 86
2363709 2363709 2022-04-01 Sioux Iowa 19167 7983 86
2360455 2360455 2022-03-31 Sioux Iowa 19167 7983 86
2357201 2357201 2022-03-30 Sioux Iowa 19167 7983 86
2353948 2353948 2022-03-29 Sioux Iowa 19167 7980 85
2350696 2350696 2022-03-28 Sioux Iowa 19167 7980 85
2347443 2347443 2022-03-27 Sioux Iowa 19167 7980 85
2344190 2344190 2022-03-26 Sioux Iowa 19167 7980 85
2340937 2340937 2022-03-25 Sioux Iowa 19167 7980 85
2337684 2337684 2022-03-24 Sioux Iowa 19167 7980 85
2334430 2334430 2022-03-23 Sioux Iowa 19167 7980 85
2331176 2331176 2022-03-22 Sioux Iowa 19167 7979 85
2327924 2327924 2022-03-21 Sioux Iowa 19167 7979 85
2324671 2324671 2022-03-20 Sioux Iowa 19167 7979 85
2321417 2321417 2022-03-19 Sioux Iowa 19167 7979 85
2318163 2318163 2022-03-18 Sioux Iowa 19167 7979 85
2314910 2314910 2022-03-17 Sioux Iowa 19167 7979 85
2311657 2311657 2022-03-16 Sioux Iowa 19167 7979 85
2308404 2308404 2022-03-15 Sioux Iowa 19167 7975 85
2305153 2305153 2022-03-14 Sioux Iowa 19167 7975 85
2301901 2301901 2022-03-13 Sioux Iowa 19167 7975 85
2298649 2298649 2022-03-12 Sioux Iowa 19167 7975 85
2295397 2295397 2022-03-11 Sioux Iowa 19167 7975 85
2292145 2292145 2022-03-10 Sioux Iowa 19167 7975 85
2288893 2288893 2022-03-09 Sioux Iowa 19167 7975 85
2285642 2285642 2022-03-08 Sioux Iowa 19167 7973 85
2282390 2282390 2022-03-07 Sioux Iowa 19167 7973 85
2279137 2279137 2022-03-06 Sioux Iowa 19167 7973 85
2275884 2275884 2022-03-05 Sioux Iowa 19167 7973 85
2272631 2272631 2022-03-04 Sioux Iowa 19167 7973 85
2269379 2269379 2022-03-03 Sioux Iowa 19167 7973 85
2266126 2266126 2022-03-02 Sioux Iowa 19167 7973 85
2262875 2262875 2022-03-01 Sioux Iowa 19167 7959 85
2259624 2259624 2022-02-28 Sioux Iowa 19167 7959 85
2256373 2256373 2022-02-27 Sioux Iowa 19167 7959 85
2253122 2253122 2022-02-26 Sioux Iowa 19167 7959 85
2249871 2249871 2022-02-25 Sioux Iowa 19167 7959 85
2246620 2246620 2022-02-24 Sioux Iowa 19167 7959 85
2243369 2243369 2022-02-23 Sioux Iowa 19167 7959 85
2240118 2240118 2022-02-22 Sioux Iowa 19167 7951 85
2236867 2236867 2022-02-21 Sioux Iowa 19167 7951 85
2233616 2233616 2022-02-20 Sioux Iowa 19167 7951 85
2230365 2230365 2022-02-19 Sioux Iowa 19167 7951 85
2227114 2227114 2022-02-18 Sioux Iowa 19167 7951 85
2223863 2223863 2022-02-17 Sioux Iowa 19167 7951 85
2220612 2220612 2022-02-16 Sioux Iowa 19167 7951 85
2217361 2217361 2022-02-15 Sioux Iowa 19167 7922 85
2214110 2214110 2022-02-14 Sioux Iowa 19167 7922 85
2210858 2210858 2022-02-13 Sioux Iowa 19167 7922 85
2207605 2207605 2022-02-12 Sioux Iowa 19167 7922 85
2204352 2204352 2022-02-11 Sioux Iowa 19167 7922 85
2201099 2201099 2022-02-10 Sioux Iowa 19167 7922 85
2197845 2197845 2022-02-09 Sioux Iowa 19167 7922 85
2194591 2194591 2022-02-08 Sioux Iowa 19167 7841 81
2191337 2191337 2022-02-07 Sioux Iowa 19167 7841 81
2188084 2188084 2022-02-06 Sioux Iowa 19167 7841 81
2184831 2184831 2022-02-05 Sioux Iowa 19167 7841 81
2181579 2181579 2022-02-04 Sioux Iowa 19167 7841 81
2178328 2178328 2022-02-03 Sioux Iowa 19167 7841 81

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