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 = "Tama" 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

  • Tama · 783 ✖
Link rowid date ▲ county state fips cases deaths
2500458 2500458 2022-05-13 Tama Iowa 19171 3925 90
2497200 2497200 2022-05-12 Tama Iowa 19171 3925 90
2493942 2493942 2022-05-11 Tama Iowa 19171 3925 90
2490684 2490684 2022-05-10 Tama Iowa 19171 3911 90
2487427 2487427 2022-05-09 Tama Iowa 19171 3911 90
2484169 2484169 2022-05-08 Tama Iowa 19171 3911 90
2480911 2480911 2022-05-07 Tama Iowa 19171 3911 90
2477653 2477653 2022-05-06 Tama Iowa 19171 3911 90
2474395 2474395 2022-05-05 Tama Iowa 19171 3911 90
2471138 2471138 2022-05-04 Tama Iowa 19171 3911 90
2467882 2467882 2022-05-03 Tama Iowa 19171 3906 90
2464627 2464627 2022-05-02 Tama Iowa 19171 3906 90
2461371 2461371 2022-05-01 Tama Iowa 19171 3906 90
2458115 2458115 2022-04-30 Tama Iowa 19171 3906 90
2454859 2454859 2022-04-29 Tama Iowa 19171 3906 90
2451603 2451603 2022-04-28 Tama Iowa 19171 3906 90
2448347 2448347 2022-04-27 Tama Iowa 19171 3906 90
2445091 2445091 2022-04-26 Tama Iowa 19171 3888 90
2441835 2441835 2022-04-25 Tama Iowa 19171 3888 90
2438579 2438579 2022-04-24 Tama Iowa 19171 3888 90
2435323 2435323 2022-04-23 Tama Iowa 19171 3888 90
2432067 2432067 2022-04-22 Tama Iowa 19171 3888 90
2428811 2428811 2022-04-21 Tama Iowa 19171 3888 90
2425555 2425555 2022-04-20 Tama Iowa 19171 3888 90
2422299 2422299 2022-04-19 Tama Iowa 19171 3868 90
2419043 2419043 2022-04-18 Tama Iowa 19171 3868 90
2415787 2415787 2022-04-17 Tama Iowa 19171 3868 90
2412531 2412531 2022-04-16 Tama Iowa 19171 3868 90
2409275 2409275 2022-04-15 Tama Iowa 19171 3868 90
2406019 2406019 2022-04-14 Tama Iowa 19171 3868 90
2402763 2402763 2022-04-13 Tama Iowa 19171 3868 90
2399509 2399509 2022-04-12 Tama Iowa 19171 3860 90
2396253 2396253 2022-04-11 Tama Iowa 19171 3860 90
2392998 2392998 2022-04-10 Tama Iowa 19171 3860 90
2389742 2389742 2022-04-09 Tama Iowa 19171 3860 90
2386486 2386486 2022-04-08 Tama Iowa 19171 3860 90
2383232 2383232 2022-04-07 Tama Iowa 19171 3860 90
2379977 2379977 2022-04-06 Tama Iowa 19171 3860 90
2376722 2376722 2022-04-05 Tama Iowa 19171 3855 90
2373470 2373470 2022-04-04 Tama Iowa 19171 3855 90
2370217 2370217 2022-04-03 Tama Iowa 19171 3855 90
2366964 2366964 2022-04-02 Tama Iowa 19171 3855 90
2363711 2363711 2022-04-01 Tama Iowa 19171 3855 90
2360457 2360457 2022-03-31 Tama Iowa 19171 3855 90
2357203 2357203 2022-03-30 Tama Iowa 19171 3855 90
2353950 2353950 2022-03-29 Tama Iowa 19171 3849 90
2350698 2350698 2022-03-28 Tama Iowa 19171 3849 90
2347445 2347445 2022-03-27 Tama Iowa 19171 3849 90
2344192 2344192 2022-03-26 Tama Iowa 19171 3849 90
2340939 2340939 2022-03-25 Tama Iowa 19171 3849 90
2337686 2337686 2022-03-24 Tama Iowa 19171 3849 90
2334432 2334432 2022-03-23 Tama Iowa 19171 3849 90
2331178 2331178 2022-03-22 Tama Iowa 19171 3848 89
2327926 2327926 2022-03-21 Tama Iowa 19171 3848 89
2324673 2324673 2022-03-20 Tama Iowa 19171 3848 89
2321419 2321419 2022-03-19 Tama Iowa 19171 3848 89
2318165 2318165 2022-03-18 Tama Iowa 19171 3848 89
2314912 2314912 2022-03-17 Tama Iowa 19171 3848 89
2311659 2311659 2022-03-16 Tama Iowa 19171 3848 89
2308406 2308406 2022-03-15 Tama Iowa 19171 3840 88
2305155 2305155 2022-03-14 Tama Iowa 19171 3840 88
2301903 2301903 2022-03-13 Tama Iowa 19171 3840 88
2298651 2298651 2022-03-12 Tama Iowa 19171 3840 88
2295399 2295399 2022-03-11 Tama Iowa 19171 3840 88
2292147 2292147 2022-03-10 Tama Iowa 19171 3840 88
2288895 2288895 2022-03-09 Tama Iowa 19171 3840 88
2285644 2285644 2022-03-08 Tama Iowa 19171 3834 87
2282392 2282392 2022-03-07 Tama Iowa 19171 3834 87
2279139 2279139 2022-03-06 Tama Iowa 19171 3834 87
2275886 2275886 2022-03-05 Tama Iowa 19171 3834 87
2272633 2272633 2022-03-04 Tama Iowa 19171 3834 87
2269381 2269381 2022-03-03 Tama Iowa 19171 3834 87
2266128 2266128 2022-03-02 Tama Iowa 19171 3834 87
2262877 2262877 2022-03-01 Tama Iowa 19171 3813 86
2259626 2259626 2022-02-28 Tama Iowa 19171 3813 86
2256375 2256375 2022-02-27 Tama Iowa 19171 3813 86
2253124 2253124 2022-02-26 Tama Iowa 19171 3813 86
2249873 2249873 2022-02-25 Tama Iowa 19171 3813 86
2246622 2246622 2022-02-24 Tama Iowa 19171 3813 86
2243371 2243371 2022-02-23 Tama Iowa 19171 3813 86
2240120 2240120 2022-02-22 Tama Iowa 19171 3790 86
2236869 2236869 2022-02-21 Tama Iowa 19171 3790 86
2233618 2233618 2022-02-20 Tama Iowa 19171 3790 86
2230367 2230367 2022-02-19 Tama Iowa 19171 3790 86
2227116 2227116 2022-02-18 Tama Iowa 19171 3790 86
2223865 2223865 2022-02-17 Tama Iowa 19171 3790 86
2220614 2220614 2022-02-16 Tama Iowa 19171 3790 86
2217363 2217363 2022-02-15 Tama Iowa 19171 3757 86
2214112 2214112 2022-02-14 Tama Iowa 19171 3757 86
2210860 2210860 2022-02-13 Tama Iowa 19171 3757 86
2207607 2207607 2022-02-12 Tama Iowa 19171 3757 86
2204354 2204354 2022-02-11 Tama Iowa 19171 3757 86
2201101 2201101 2022-02-10 Tama Iowa 19171 3757 86
2197847 2197847 2022-02-09 Tama Iowa 19171 3757 86
2194593 2194593 2022-02-08 Tama Iowa 19171 3707 84
2191339 2191339 2022-02-07 Tama Iowa 19171 3707 84
2188086 2188086 2022-02-06 Tama Iowa 19171 3707 84
2184833 2184833 2022-02-05 Tama Iowa 19171 3707 84
2181581 2181581 2022-02-04 Tama Iowa 19171 3707 84
2178330 2178330 2022-02-03 Tama Iowa 19171 3707 84

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