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

743 rows where county = "Wayne" and state = "Iowa" sorted by date descending

✎ View and edit SQL

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

state 1

  • Iowa · 743 ✖

fips 1

county 1

  • Wayne · 743 ✖
Link rowid date ▲ county state fips cases deaths
2500466 2500466 2022-05-13 Wayne Iowa 19185 1271 33
2497208 2497208 2022-05-12 Wayne Iowa 19185 1271 33
2493950 2493950 2022-05-11 Wayne Iowa 19185 1271 33
2490692 2490692 2022-05-10 Wayne Iowa 19185 1269 33
2487435 2487435 2022-05-09 Wayne Iowa 19185 1269 33
2484177 2484177 2022-05-08 Wayne Iowa 19185 1269 33
2480919 2480919 2022-05-07 Wayne Iowa 19185 1269 33
2477661 2477661 2022-05-06 Wayne Iowa 19185 1269 33
2474403 2474403 2022-05-05 Wayne Iowa 19185 1269 33
2471146 2471146 2022-05-04 Wayne Iowa 19185 1269 33
2467890 2467890 2022-05-03 Wayne Iowa 19185 1267 33
2464635 2464635 2022-05-02 Wayne Iowa 19185 1267 33
2461379 2461379 2022-05-01 Wayne Iowa 19185 1267 33
2458123 2458123 2022-04-30 Wayne Iowa 19185 1267 33
2454867 2454867 2022-04-29 Wayne Iowa 19185 1267 33
2451611 2451611 2022-04-28 Wayne Iowa 19185 1267 33
2448355 2448355 2022-04-27 Wayne Iowa 19185 1267 33
2445099 2445099 2022-04-26 Wayne Iowa 19185 1266 33
2441843 2441843 2022-04-25 Wayne Iowa 19185 1266 33
2438587 2438587 2022-04-24 Wayne Iowa 19185 1266 33
2435331 2435331 2022-04-23 Wayne Iowa 19185 1266 33
2432075 2432075 2022-04-22 Wayne Iowa 19185 1266 33
2428819 2428819 2022-04-21 Wayne Iowa 19185 1266 33
2425563 2425563 2022-04-20 Wayne Iowa 19185 1266 33
2422307 2422307 2022-04-19 Wayne Iowa 19185 1265 33
2419051 2419051 2022-04-18 Wayne Iowa 19185 1265 33
2415795 2415795 2022-04-17 Wayne Iowa 19185 1265 33
2412539 2412539 2022-04-16 Wayne Iowa 19185 1265 33
2409283 2409283 2022-04-15 Wayne Iowa 19185 1265 33
2406027 2406027 2022-04-14 Wayne Iowa 19185 1265 33
2402771 2402771 2022-04-13 Wayne Iowa 19185 1265 33
2399517 2399517 2022-04-12 Wayne Iowa 19185 1264 33
2396261 2396261 2022-04-11 Wayne Iowa 19185 1264 33
2393006 2393006 2022-04-10 Wayne Iowa 19185 1264 33
2389750 2389750 2022-04-09 Wayne Iowa 19185 1264 33
2386494 2386494 2022-04-08 Wayne Iowa 19185 1264 33
2383240 2383240 2022-04-07 Wayne Iowa 19185 1264 33
2379985 2379985 2022-04-06 Wayne Iowa 19185 1264 33
2376730 2376730 2022-04-05 Wayne Iowa 19185 1264 33
2373478 2373478 2022-04-04 Wayne Iowa 19185 1264 33
2370225 2370225 2022-04-03 Wayne Iowa 19185 1264 33
2366972 2366972 2022-04-02 Wayne Iowa 19185 1264 33
2363719 2363719 2022-04-01 Wayne Iowa 19185 1264 33
2360465 2360465 2022-03-31 Wayne Iowa 19185 1264 33
2357211 2357211 2022-03-30 Wayne Iowa 19185 1264 33
2353958 2353958 2022-03-29 Wayne Iowa 19185 1263 33
2350706 2350706 2022-03-28 Wayne Iowa 19185 1263 33
2347453 2347453 2022-03-27 Wayne Iowa 19185 1263 33
2344200 2344200 2022-03-26 Wayne Iowa 19185 1263 33
2340947 2340947 2022-03-25 Wayne Iowa 19185 1263 33
2337694 2337694 2022-03-24 Wayne Iowa 19185 1263 33
2334440 2334440 2022-03-23 Wayne Iowa 19185 1263 33
2331186 2331186 2022-03-22 Wayne Iowa 19185 1263 33
2327934 2327934 2022-03-21 Wayne Iowa 19185 1263 33
2324681 2324681 2022-03-20 Wayne Iowa 19185 1263 33
2321427 2321427 2022-03-19 Wayne Iowa 19185 1263 33
2318173 2318173 2022-03-18 Wayne Iowa 19185 1263 33
2314920 2314920 2022-03-17 Wayne Iowa 19185 1263 33
2311667 2311667 2022-03-16 Wayne Iowa 19185 1263 33
2308414 2308414 2022-03-15 Wayne Iowa 19185 1263 33
2305163 2305163 2022-03-14 Wayne Iowa 19185 1263 33
2301911 2301911 2022-03-13 Wayne Iowa 19185 1263 33
2298659 2298659 2022-03-12 Wayne Iowa 19185 1263 33
2295407 2295407 2022-03-11 Wayne Iowa 19185 1263 33
2292155 2292155 2022-03-10 Wayne Iowa 19185 1263 33
2288903 2288903 2022-03-09 Wayne Iowa 19185 1263 33
2285652 2285652 2022-03-08 Wayne Iowa 19185 1262 33
2282400 2282400 2022-03-07 Wayne Iowa 19185 1262 33
2279147 2279147 2022-03-06 Wayne Iowa 19185 1262 33
2275894 2275894 2022-03-05 Wayne Iowa 19185 1262 33
2272641 2272641 2022-03-04 Wayne Iowa 19185 1262 33
2269389 2269389 2022-03-03 Wayne Iowa 19185 1262 33
2266136 2266136 2022-03-02 Wayne Iowa 19185 1262 33
2262885 2262885 2022-03-01 Wayne Iowa 19185 1250 33
2259634 2259634 2022-02-28 Wayne Iowa 19185 1250 33
2256383 2256383 2022-02-27 Wayne Iowa 19185 1250 33
2253132 2253132 2022-02-26 Wayne Iowa 19185 1250 33
2249881 2249881 2022-02-25 Wayne Iowa 19185 1250 33
2246630 2246630 2022-02-24 Wayne Iowa 19185 1250 33
2243379 2243379 2022-02-23 Wayne Iowa 19185 1250 33
2240128 2240128 2022-02-22 Wayne Iowa 19185 1229 33
2236877 2236877 2022-02-21 Wayne Iowa 19185 1229 33
2233626 2233626 2022-02-20 Wayne Iowa 19185 1229 33
2230375 2230375 2022-02-19 Wayne Iowa 19185 1229 33
2227124 2227124 2022-02-18 Wayne Iowa 19185 1229 33
2223873 2223873 2022-02-17 Wayne Iowa 19185 1229 33
2220622 2220622 2022-02-16 Wayne Iowa 19185 1229 33
2217371 2217371 2022-02-15 Wayne Iowa 19185 1215 32
2214120 2214120 2022-02-14 Wayne Iowa 19185 1215 32
2210868 2210868 2022-02-13 Wayne Iowa 19185 1215 32
2207615 2207615 2022-02-12 Wayne Iowa 19185 1215 32
2204362 2204362 2022-02-11 Wayne Iowa 19185 1215 32
2201109 2201109 2022-02-10 Wayne Iowa 19185 1215 32
2197855 2197855 2022-02-09 Wayne Iowa 19185 1215 32
2194601 2194601 2022-02-08 Wayne Iowa 19185 1186 31
2191347 2191347 2022-02-07 Wayne Iowa 19185 1186 31
2188094 2188094 2022-02-06 Wayne Iowa 19185 1186 31
2184841 2184841 2022-02-05 Wayne Iowa 19185 1186 31
2181589 2181589 2022-02-04 Wayne Iowa 19185 1186 31
2178338 2178338 2022-02-03 Wayne Iowa 19185 1186 31

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