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

15 rows where cases = 1824 and state = "Illinois" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date

fips 9

state 1

  • Illinois · 15 ✖
Link rowid date ▲ county state fips cases deaths
2129276 2129276 2022-01-19 Hamilton Illinois 17065 1824 29
1563897 1563897 2021-07-29 Richland Illinois 17159 1824 49
1459998 1459998 2021-06-27 Pike Illinois 17149 1824 56
1456753 1456753 2021-06-26 Pike Illinois 17149 1824 56
1453508 1453508 2021-06-25 Pike Illinois 17149 1824 56
1369060 1369060 2021-05-30 Clark Illinois 17023 1824 41
1362599 1362599 2021-05-28 Jo Daviess Illinois 17085 1824 27
1362651 1362651 2021-05-28 Warren Illinois 17187 1824 50
1359352 1359352 2021-05-27 Jo Daviess Illinois 17085 1824 27
1356106 1356106 2021-05-26 Jo Daviess Illinois 17085 1824 27
1352860 1352860 2021-05-25 Jo Daviess Illinois 17085 1824 27
1349614 1349614 2021-05-24 Jo Daviess Illinois 17085 1824 27
998932 998932 2021-02-05 Bond Illinois 17005 1824 27
716633 716633 2020-11-10 Knox Illinois 17095 1824 34
518886 518886 2020-09-10 Kendall Illinois 17093 1824 26

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