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

790 rows where county = "Allamakee" 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 · 790 ✖

fips 1

county 1

  • Allamakee · 790 ✖
Link rowid date ▲ county state fips cases deaths
2500375 2500375 2022-05-13 Allamakee Iowa 19005 2890 60
2497117 2497117 2022-05-12 Allamakee Iowa 19005 2890 60
2493859 2493859 2022-05-11 Allamakee Iowa 19005 2890 60
2490601 2490601 2022-05-10 Allamakee Iowa 19005 2881 60
2487344 2487344 2022-05-09 Allamakee Iowa 19005 2881 60
2484086 2484086 2022-05-08 Allamakee Iowa 19005 2881 60
2480828 2480828 2022-05-07 Allamakee Iowa 19005 2881 60
2477570 2477570 2022-05-06 Allamakee Iowa 19005 2881 60
2474312 2474312 2022-05-05 Allamakee Iowa 19005 2881 60
2471055 2471055 2022-05-04 Allamakee Iowa 19005 2881 60
2467799 2467799 2022-05-03 Allamakee Iowa 19005 2873 60
2464544 2464544 2022-05-02 Allamakee Iowa 19005 2873 60
2461288 2461288 2022-05-01 Allamakee Iowa 19005 2873 60
2458032 2458032 2022-04-30 Allamakee Iowa 19005 2873 60
2454776 2454776 2022-04-29 Allamakee Iowa 19005 2873 60
2451520 2451520 2022-04-28 Allamakee Iowa 19005 2873 60
2448264 2448264 2022-04-27 Allamakee Iowa 19005 2873 60
2445008 2445008 2022-04-26 Allamakee Iowa 19005 2869 59
2441752 2441752 2022-04-25 Allamakee Iowa 19005 2869 59
2438496 2438496 2022-04-24 Allamakee Iowa 19005 2869 59
2435240 2435240 2022-04-23 Allamakee Iowa 19005 2869 59
2431984 2431984 2022-04-22 Allamakee Iowa 19005 2869 59
2428728 2428728 2022-04-21 Allamakee Iowa 19005 2869 59
2425472 2425472 2022-04-20 Allamakee Iowa 19005 2869 59
2422216 2422216 2022-04-19 Allamakee Iowa 19005 2868 59
2418960 2418960 2022-04-18 Allamakee Iowa 19005 2868 59
2415704 2415704 2022-04-17 Allamakee Iowa 19005 2868 59
2412448 2412448 2022-04-16 Allamakee Iowa 19005 2868 59
2409192 2409192 2022-04-15 Allamakee Iowa 19005 2868 59
2405936 2405936 2022-04-14 Allamakee Iowa 19005 2868 59
2402680 2402680 2022-04-13 Allamakee Iowa 19005 2868 59
2399426 2399426 2022-04-12 Allamakee Iowa 19005 2866 59
2396170 2396170 2022-04-11 Allamakee Iowa 19005 2866 59
2392915 2392915 2022-04-10 Allamakee Iowa 19005 2866 59
2389659 2389659 2022-04-09 Allamakee Iowa 19005 2866 59
2386403 2386403 2022-04-08 Allamakee Iowa 19005 2866 59
2383149 2383149 2022-04-07 Allamakee Iowa 19005 2866 59
2379894 2379894 2022-04-06 Allamakee Iowa 19005 2866 59
2376639 2376639 2022-04-05 Allamakee Iowa 19005 2861 59
2373387 2373387 2022-04-04 Allamakee Iowa 19005 2861 59
2370134 2370134 2022-04-03 Allamakee Iowa 19005 2861 59
2366881 2366881 2022-04-02 Allamakee Iowa 19005 2861 59
2363628 2363628 2022-04-01 Allamakee Iowa 19005 2861 59
2360374 2360374 2022-03-31 Allamakee Iowa 19005 2861 59
2357120 2357120 2022-03-30 Allamakee Iowa 19005 2861 59
2353867 2353867 2022-03-29 Allamakee Iowa 19005 2853 59
2350615 2350615 2022-03-28 Allamakee Iowa 19005 2853 59
2347362 2347362 2022-03-27 Allamakee Iowa 19005 2853 59
2344109 2344109 2022-03-26 Allamakee Iowa 19005 2853 59
2340856 2340856 2022-03-25 Allamakee Iowa 19005 2853 59
2337603 2337603 2022-03-24 Allamakee Iowa 19005 2853 59
2334349 2334349 2022-03-23 Allamakee Iowa 19005 2853 59
2331095 2331095 2022-03-22 Allamakee Iowa 19005 2850 59
2327843 2327843 2022-03-21 Allamakee Iowa 19005 2850 59
2324590 2324590 2022-03-20 Allamakee Iowa 19005 2850 59
2321336 2321336 2022-03-19 Allamakee Iowa 19005 2850 59
2318082 2318082 2022-03-18 Allamakee Iowa 19005 2850 59
2314829 2314829 2022-03-17 Allamakee Iowa 19005 2850 59
2311576 2311576 2022-03-16 Allamakee Iowa 19005 2850 59
2308323 2308323 2022-03-15 Allamakee Iowa 19005 2846 59
2305072 2305072 2022-03-14 Allamakee Iowa 19005 2846 59
2301820 2301820 2022-03-13 Allamakee Iowa 19005 2846 59
2298568 2298568 2022-03-12 Allamakee Iowa 19005 2846 59
2295316 2295316 2022-03-11 Allamakee Iowa 19005 2846 59
2292064 2292064 2022-03-10 Allamakee Iowa 19005 2846 59
2288812 2288812 2022-03-09 Allamakee Iowa 19005 2846 59
2285561 2285561 2022-03-08 Allamakee Iowa 19005 2843 59
2282309 2282309 2022-03-07 Allamakee Iowa 19005 2843 59
2279056 2279056 2022-03-06 Allamakee Iowa 19005 2843 59
2275803 2275803 2022-03-05 Allamakee Iowa 19005 2843 59
2272550 2272550 2022-03-04 Allamakee Iowa 19005 2843 59
2269298 2269298 2022-03-03 Allamakee Iowa 19005 2843 59
2266045 2266045 2022-03-02 Allamakee Iowa 19005 2843 59
2262794 2262794 2022-03-01 Allamakee Iowa 19005 2831 59
2259543 2259543 2022-02-28 Allamakee Iowa 19005 2831 59
2256292 2256292 2022-02-27 Allamakee Iowa 19005 2831 59
2253041 2253041 2022-02-26 Allamakee Iowa 19005 2831 59
2249790 2249790 2022-02-25 Allamakee Iowa 19005 2831 59
2246539 2246539 2022-02-24 Allamakee Iowa 19005 2831 59
2243288 2243288 2022-02-23 Allamakee Iowa 19005 2831 59
2240037 2240037 2022-02-22 Allamakee Iowa 19005 2809 59
2236786 2236786 2022-02-21 Allamakee Iowa 19005 2809 59
2233535 2233535 2022-02-20 Allamakee Iowa 19005 2809 59
2230284 2230284 2022-02-19 Allamakee Iowa 19005 2809 59
2227033 2227033 2022-02-18 Allamakee Iowa 19005 2809 59
2223782 2223782 2022-02-17 Allamakee Iowa 19005 2809 59
2220531 2220531 2022-02-16 Allamakee Iowa 19005 2809 59
2217280 2217280 2022-02-15 Allamakee Iowa 19005 2779 59
2214029 2214029 2022-02-14 Allamakee Iowa 19005 2779 59
2210777 2210777 2022-02-13 Allamakee Iowa 19005 2779 59
2207524 2207524 2022-02-12 Allamakee Iowa 19005 2779 59
2204271 2204271 2022-02-11 Allamakee Iowa 19005 2779 59
2201018 2201018 2022-02-10 Allamakee Iowa 19005 2779 59
2197764 2197764 2022-02-09 Allamakee Iowa 19005 2779 59
2194510 2194510 2022-02-08 Allamakee Iowa 19005 2740 58
2191256 2191256 2022-02-07 Allamakee Iowa 19005 2740 58
2188003 2188003 2022-02-06 Allamakee Iowa 19005 2740 58
2184750 2184750 2022-02-05 Allamakee Iowa 19005 2740 58
2181498 2181498 2022-02-04 Allamakee Iowa 19005 2740 58
2178247 2178247 2022-02-03 Allamakee Iowa 19005 2740 58

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