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

27 rows where cases = 1491 and state = "Iowa" sorted by date descending

✎ View and edit SQL

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

fips 11

state 1

  • Iowa · 27 ✖
Link rowid date ▲ county state fips cases deaths
1580301 1580301 2021-08-03 Iowa Iowa 19095 1491 24
1577052 1577052 2021-08-02 Iowa Iowa 19095 1491 24
1573804 1573804 2021-08-01 Iowa Iowa 19095 1491 24
1570556 1570556 2021-07-31 Iowa Iowa 19095 1491 24
1567308 1567308 2021-07-30 Iowa Iowa 19095 1491 24
1564060 1564060 2021-07-29 Iowa Iowa 19095 1491 24
1560812 1560812 2021-07-28 Iowa Iowa 19095 1491 24
1346567 1346567 2021-05-23 Iowa Iowa 19095 1491 24
1343319 1343319 2021-05-22 Iowa Iowa 19095 1491 24
1340071 1340071 2021-05-21 Iowa Iowa 19095 1491 24
1336824 1336824 2021-05-20 Iowa Iowa 19095 1491 24
1333577 1333577 2021-05-19 Iowa Iowa 19095 1491 24
1236130 1236130 2021-04-19 Allamakee Iowa 19005 1491 51
1232883 1232883 2021-04-18 Allamakee Iowa 19005 1491 51
1229634 1229634 2021-04-17 Allamakee Iowa 19005 1491 51
1226386 1226386 2021-04-16 Allamakee Iowa 19005 1491 51
1223139 1223139 2021-04-15 Allamakee Iowa 19005 1491 51
1219891 1219891 2021-04-14 Allamakee Iowa 19005 1491 51
1148499 1148499 2021-03-23 Madison Iowa 19121 1491 19
1106267 1106267 2021-03-10 Floyd Iowa 19067 1491 41
969983 969983 2021-01-27 Page Iowa 19145 1491 15
927738 927738 2021-01-14 Cedar Iowa 19031 1491 19
885571 885571 2021-01-01 Hamilton Iowa 19079 1491 24
836926 836926 2020-12-17 O'Brien Iowa 19141 1491 48
797934 797934 2020-12-05 Delaware Iowa 19055 1491 22
454469 454469 2020-08-21 Pottawattamie Iowa 19155 1491 31
373944 373944 2020-07-27 Scott Iowa 19163 1491 11

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