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

778 rows where county = "Butler" 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 · 778 ✖

fips 1

county 1

  • Butler · 778 ✖
Link rowid date ▲ county state fips cases deaths
2500384 2500384 2022-05-13 Butler Iowa 19023 3252 53
2497126 2497126 2022-05-12 Butler Iowa 19023 3252 53
2493868 2493868 2022-05-11 Butler Iowa 19023 3252 53
2490610 2490610 2022-05-10 Butler Iowa 19023 3243 53
2487353 2487353 2022-05-09 Butler Iowa 19023 3243 53
2484095 2484095 2022-05-08 Butler Iowa 19023 3243 53
2480837 2480837 2022-05-07 Butler Iowa 19023 3243 53
2477579 2477579 2022-05-06 Butler Iowa 19023 3243 53
2474321 2474321 2022-05-05 Butler Iowa 19023 3243 53
2471064 2471064 2022-05-04 Butler Iowa 19023 3243 53
2467808 2467808 2022-05-03 Butler Iowa 19023 3231 53
2464553 2464553 2022-05-02 Butler Iowa 19023 3231 53
2461297 2461297 2022-05-01 Butler Iowa 19023 3231 53
2458041 2458041 2022-04-30 Butler Iowa 19023 3231 53
2454785 2454785 2022-04-29 Butler Iowa 19023 3231 53
2451529 2451529 2022-04-28 Butler Iowa 19023 3231 53
2448273 2448273 2022-04-27 Butler Iowa 19023 3231 53
2445017 2445017 2022-04-26 Butler Iowa 19023 3223 53
2441761 2441761 2022-04-25 Butler Iowa 19023 3223 53
2438505 2438505 2022-04-24 Butler Iowa 19023 3223 53
2435249 2435249 2022-04-23 Butler Iowa 19023 3223 53
2431993 2431993 2022-04-22 Butler Iowa 19023 3223 53
2428737 2428737 2022-04-21 Butler Iowa 19023 3223 53
2425481 2425481 2022-04-20 Butler Iowa 19023 3223 53
2422225 2422225 2022-04-19 Butler Iowa 19023 3220 53
2418969 2418969 2022-04-18 Butler Iowa 19023 3220 53
2415713 2415713 2022-04-17 Butler Iowa 19023 3220 53
2412457 2412457 2022-04-16 Butler Iowa 19023 3220 53
2409201 2409201 2022-04-15 Butler Iowa 19023 3220 53
2405945 2405945 2022-04-14 Butler Iowa 19023 3220 53
2402689 2402689 2022-04-13 Butler Iowa 19023 3220 53
2399435 2399435 2022-04-12 Butler Iowa 19023 3220 53
2396179 2396179 2022-04-11 Butler Iowa 19023 3220 53
2392924 2392924 2022-04-10 Butler Iowa 19023 3220 53
2389668 2389668 2022-04-09 Butler Iowa 19023 3220 53
2386412 2386412 2022-04-08 Butler Iowa 19023 3220 53
2383158 2383158 2022-04-07 Butler Iowa 19023 3220 53
2379903 2379903 2022-04-06 Butler Iowa 19023 3220 53
2376648 2376648 2022-04-05 Butler Iowa 19023 3215 53
2373396 2373396 2022-04-04 Butler Iowa 19023 3215 53
2370143 2370143 2022-04-03 Butler Iowa 19023 3215 53
2366890 2366890 2022-04-02 Butler Iowa 19023 3215 53
2363637 2363637 2022-04-01 Butler Iowa 19023 3215 53
2360383 2360383 2022-03-31 Butler Iowa 19023 3215 53
2357129 2357129 2022-03-30 Butler Iowa 19023 3215 53
2353876 2353876 2022-03-29 Butler Iowa 19023 3209 53
2350624 2350624 2022-03-28 Butler Iowa 19023 3209 53
2347371 2347371 2022-03-27 Butler Iowa 19023 3209 53
2344118 2344118 2022-03-26 Butler Iowa 19023 3209 53
2340865 2340865 2022-03-25 Butler Iowa 19023 3209 53
2337612 2337612 2022-03-24 Butler Iowa 19023 3209 53
2334358 2334358 2022-03-23 Butler Iowa 19023 3209 53
2331104 2331104 2022-03-22 Butler Iowa 19023 3200 52
2327852 2327852 2022-03-21 Butler Iowa 19023 3200 52
2324599 2324599 2022-03-20 Butler Iowa 19023 3200 52
2321345 2321345 2022-03-19 Butler Iowa 19023 3200 52
2318091 2318091 2022-03-18 Butler Iowa 19023 3200 52
2314838 2314838 2022-03-17 Butler Iowa 19023 3200 52
2311585 2311585 2022-03-16 Butler Iowa 19023 3200 52
2308332 2308332 2022-03-15 Butler Iowa 19023 3195 52
2305081 2305081 2022-03-14 Butler Iowa 19023 3195 52
2301829 2301829 2022-03-13 Butler Iowa 19023 3195 52
2298577 2298577 2022-03-12 Butler Iowa 19023 3195 52
2295325 2295325 2022-03-11 Butler Iowa 19023 3195 52
2292073 2292073 2022-03-10 Butler Iowa 19023 3195 52
2288821 2288821 2022-03-09 Butler Iowa 19023 3195 52
2285570 2285570 2022-03-08 Butler Iowa 19023 3185 52
2282318 2282318 2022-03-07 Butler Iowa 19023 3185 52
2279065 2279065 2022-03-06 Butler Iowa 19023 3185 52
2275812 2275812 2022-03-05 Butler Iowa 19023 3185 52
2272559 2272559 2022-03-04 Butler Iowa 19023 3185 52
2269307 2269307 2022-03-03 Butler Iowa 19023 3185 52
2266054 2266054 2022-03-02 Butler Iowa 19023 3185 52
2262803 2262803 2022-03-01 Butler Iowa 19023 3174 51
2259552 2259552 2022-02-28 Butler Iowa 19023 3174 51
2256301 2256301 2022-02-27 Butler Iowa 19023 3174 51
2253050 2253050 2022-02-26 Butler Iowa 19023 3174 51
2249799 2249799 2022-02-25 Butler Iowa 19023 3174 51
2246548 2246548 2022-02-24 Butler Iowa 19023 3174 51
2243297 2243297 2022-02-23 Butler Iowa 19023 3174 51
2240046 2240046 2022-02-22 Butler Iowa 19023 3154 51
2236795 2236795 2022-02-21 Butler Iowa 19023 3154 51
2233544 2233544 2022-02-20 Butler Iowa 19023 3154 51
2230293 2230293 2022-02-19 Butler Iowa 19023 3154 51
2227042 2227042 2022-02-18 Butler Iowa 19023 3154 51
2223791 2223791 2022-02-17 Butler Iowa 19023 3154 51
2220540 2220540 2022-02-16 Butler Iowa 19023 3154 51
2217289 2217289 2022-02-15 Butler Iowa 19023 3114 49
2214038 2214038 2022-02-14 Butler Iowa 19023 3114 49
2210786 2210786 2022-02-13 Butler Iowa 19023 3114 49
2207533 2207533 2022-02-12 Butler Iowa 19023 3114 49
2204280 2204280 2022-02-11 Butler Iowa 19023 3114 49
2201027 2201027 2022-02-10 Butler Iowa 19023 3114 49
2197773 2197773 2022-02-09 Butler Iowa 19023 3114 49
2194519 2194519 2022-02-08 Butler Iowa 19023 3057 48
2191265 2191265 2022-02-07 Butler Iowa 19023 3057 48
2188012 2188012 2022-02-06 Butler Iowa 19023 3057 48
2184759 2184759 2022-02-05 Butler Iowa 19023 3057 48
2181507 2181507 2022-02-04 Butler Iowa 19023 3057 48
2178256 2178256 2022-02-03 Butler Iowa 19023 3057 48

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