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

781 rows where county = "Cedar" 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 · 781 ✖

fips 1

county 1

  • Cedar · 781 ✖
Link rowid date ▲ county state fips cases deaths
2500388 2500388 2022-05-13 Cedar Iowa 19031 4201 35
2497130 2497130 2022-05-12 Cedar Iowa 19031 4201 35
2493872 2493872 2022-05-11 Cedar Iowa 19031 4201 35
2490614 2490614 2022-05-10 Cedar Iowa 19031 4181 35
2487357 2487357 2022-05-09 Cedar Iowa 19031 4181 35
2484099 2484099 2022-05-08 Cedar Iowa 19031 4181 35
2480841 2480841 2022-05-07 Cedar Iowa 19031 4181 35
2477583 2477583 2022-05-06 Cedar Iowa 19031 4181 35
2474325 2474325 2022-05-05 Cedar Iowa 19031 4181 35
2471068 2471068 2022-05-04 Cedar Iowa 19031 4181 35
2467812 2467812 2022-05-03 Cedar Iowa 19031 4161 35
2464557 2464557 2022-05-02 Cedar Iowa 19031 4161 35
2461301 2461301 2022-05-01 Cedar Iowa 19031 4161 35
2458045 2458045 2022-04-30 Cedar Iowa 19031 4161 35
2454789 2454789 2022-04-29 Cedar Iowa 19031 4161 35
2451533 2451533 2022-04-28 Cedar Iowa 19031 4161 35
2448277 2448277 2022-04-27 Cedar Iowa 19031 4161 35
2445021 2445021 2022-04-26 Cedar Iowa 19031 4151 35
2441765 2441765 2022-04-25 Cedar Iowa 19031 4151 35
2438509 2438509 2022-04-24 Cedar Iowa 19031 4151 35
2435253 2435253 2022-04-23 Cedar Iowa 19031 4151 35
2431997 2431997 2022-04-22 Cedar Iowa 19031 4151 35
2428741 2428741 2022-04-21 Cedar Iowa 19031 4151 35
2425485 2425485 2022-04-20 Cedar Iowa 19031 4151 35
2422229 2422229 2022-04-19 Cedar Iowa 19031 4144 35
2418973 2418973 2022-04-18 Cedar Iowa 19031 4144 35
2415717 2415717 2022-04-17 Cedar Iowa 19031 4144 35
2412461 2412461 2022-04-16 Cedar Iowa 19031 4144 35
2409205 2409205 2022-04-15 Cedar Iowa 19031 4144 35
2405949 2405949 2022-04-14 Cedar Iowa 19031 4144 35
2402693 2402693 2022-04-13 Cedar Iowa 19031 4144 35
2399439 2399439 2022-04-12 Cedar Iowa 19031 4139 35
2396183 2396183 2022-04-11 Cedar Iowa 19031 4139 35
2392928 2392928 2022-04-10 Cedar Iowa 19031 4139 35
2389672 2389672 2022-04-09 Cedar Iowa 19031 4139 35
2386416 2386416 2022-04-08 Cedar Iowa 19031 4139 35
2383162 2383162 2022-04-07 Cedar Iowa 19031 4139 35
2379907 2379907 2022-04-06 Cedar Iowa 19031 4139 35
2376652 2376652 2022-04-05 Cedar Iowa 19031 4136 35
2373400 2373400 2022-04-04 Cedar Iowa 19031 4136 35
2370147 2370147 2022-04-03 Cedar Iowa 19031 4136 35
2366894 2366894 2022-04-02 Cedar Iowa 19031 4136 35
2363641 2363641 2022-04-01 Cedar Iowa 19031 4136 35
2360387 2360387 2022-03-31 Cedar Iowa 19031 4136 35
2357133 2357133 2022-03-30 Cedar Iowa 19031 4136 35
2353880 2353880 2022-03-29 Cedar Iowa 19031 4133 35
2350628 2350628 2022-03-28 Cedar Iowa 19031 4133 35
2347375 2347375 2022-03-27 Cedar Iowa 19031 4133 35
2344122 2344122 2022-03-26 Cedar Iowa 19031 4133 35
2340869 2340869 2022-03-25 Cedar Iowa 19031 4133 35
2337616 2337616 2022-03-24 Cedar Iowa 19031 4133 35
2334362 2334362 2022-03-23 Cedar Iowa 19031 4133 35
2331108 2331108 2022-03-22 Cedar Iowa 19031 4132 35
2327856 2327856 2022-03-21 Cedar Iowa 19031 4132 35
2324603 2324603 2022-03-20 Cedar Iowa 19031 4132 35
2321349 2321349 2022-03-19 Cedar Iowa 19031 4132 35
2318095 2318095 2022-03-18 Cedar Iowa 19031 4132 35
2314842 2314842 2022-03-17 Cedar Iowa 19031 4132 35
2311589 2311589 2022-03-16 Cedar Iowa 19031 4132 35
2308336 2308336 2022-03-15 Cedar Iowa 19031 4123 35
2305085 2305085 2022-03-14 Cedar Iowa 19031 4123 35
2301833 2301833 2022-03-13 Cedar Iowa 19031 4123 35
2298581 2298581 2022-03-12 Cedar Iowa 19031 4123 35
2295329 2295329 2022-03-11 Cedar Iowa 19031 4123 35
2292077 2292077 2022-03-10 Cedar Iowa 19031 4123 35
2288825 2288825 2022-03-09 Cedar Iowa 19031 4123 35
2285574 2285574 2022-03-08 Cedar Iowa 19031 4109 33
2282322 2282322 2022-03-07 Cedar Iowa 19031 4109 33
2279069 2279069 2022-03-06 Cedar Iowa 19031 4109 33
2275816 2275816 2022-03-05 Cedar Iowa 19031 4109 33
2272563 2272563 2022-03-04 Cedar Iowa 19031 4109 33
2269311 2269311 2022-03-03 Cedar Iowa 19031 4109 33
2266058 2266058 2022-03-02 Cedar Iowa 19031 4109 33
2262807 2262807 2022-03-01 Cedar Iowa 19031 4085 32
2259556 2259556 2022-02-28 Cedar Iowa 19031 4085 32
2256305 2256305 2022-02-27 Cedar Iowa 19031 4085 32
2253054 2253054 2022-02-26 Cedar Iowa 19031 4085 32
2249803 2249803 2022-02-25 Cedar Iowa 19031 4085 32
2246552 2246552 2022-02-24 Cedar Iowa 19031 4085 32
2243301 2243301 2022-02-23 Cedar Iowa 19031 4085 32
2240050 2240050 2022-02-22 Cedar Iowa 19031 4060 30
2236799 2236799 2022-02-21 Cedar Iowa 19031 4060 30
2233548 2233548 2022-02-20 Cedar Iowa 19031 4060 30
2230297 2230297 2022-02-19 Cedar Iowa 19031 4060 30
2227046 2227046 2022-02-18 Cedar Iowa 19031 4060 30
2223795 2223795 2022-02-17 Cedar Iowa 19031 4060 30
2220544 2220544 2022-02-16 Cedar Iowa 19031 4060 30
2217293 2217293 2022-02-15 Cedar Iowa 19031 3991 30
2214042 2214042 2022-02-14 Cedar Iowa 19031 3991 30
2210790 2210790 2022-02-13 Cedar Iowa 19031 3991 30
2207537 2207537 2022-02-12 Cedar Iowa 19031 3991 30
2204284 2204284 2022-02-11 Cedar Iowa 19031 3991 30
2201031 2201031 2022-02-10 Cedar Iowa 19031 3991 30
2197777 2197777 2022-02-09 Cedar Iowa 19031 3991 30
2194523 2194523 2022-02-08 Cedar Iowa 19031 3880 30
2191269 2191269 2022-02-07 Cedar Iowa 19031 3880 30
2188016 2188016 2022-02-06 Cedar Iowa 19031 3880 30
2184763 2184763 2022-02-05 Cedar Iowa 19031 3880 30
2181511 2181511 2022-02-04 Cedar Iowa 19031 3880 30
2178260 2178260 2022-02-03 Cedar Iowa 19031 3880 30

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