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

28 rows where cases = 13259 sorted by date descending

✎ View and edit SQL

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

These facets timed out: county, fips

Link rowid date ▲ county state fips cases deaths
2442142 2442142 2022-04-25 Aroostook Maine 23003 13259 157
2438886 2438886 2022-04-24 Aroostook Maine 23003 13259 157
2435630 2435630 2022-04-23 Aroostook Maine 23003 13259 157
2359496 2359496 2022-03-30 Dunn Wisconsin 55033 13259 74
2312384 2312384 2022-03-16 Taney Missouri 29213 13259 223
2229500 2229500 2022-02-19 Coffee Alabama 1031 13259 216
2180101 2180101 2022-02-03 Caldwell Texas 48055 13259 167
2174067 2174067 2022-02-01 Marion West Virginia 54049 13259 151
2138406 2138406 2022-01-22 Blount Alabama 1009 13259 204
1919874 1919874 2021-11-15 Anderson Tennessee 47001 13259 227
1733966 1733966 2021-09-19 Lea New Mexico 35025 13259 227
1730716 1730716 2021-09-18 Lea New Mexico 35025 13259 227
1727466 1727466 2021-09-17 Lea New Mexico 35025 13259 227
1696447 1696447 2021-09-08 Limestone Alabama 1083 13259 173
1679981 1679981 2021-09-02 Grant Washington 53025 13259 149
1668214 1668214 2021-08-30 Hardin Kentucky 21093 13259 188
1539126 1539126 2021-07-21 Schenectady New York 36093 13259 205
1470231 1470231 2021-06-30 Tangipahoa Louisiana 22105 13259 306
1188086 1188086 2021-04-04 Rankin Mississippi 28121 13259 274
1170301 1170301 2021-03-29 Fond du Lac Wisconsin 55039 13259 111
1167053 1167053 2021-03-28 Fond du Lac Wisconsin 55039 13259 111
1163805 1163805 2021-03-27 Fond du Lac Wisconsin 55039 13259 111
1127216 1127216 2021-03-16 Lebanon Pennsylvania 42075 13259 263
1122517 1122517 2021-03-15 Johnson Iowa 19103 13259 76
828623 828623 2020-12-14 Luzerne Pennsylvania 42079 13259 364
687113 687113 2020-11-01 New Castle Delaware 10003 13259 353
469933 469933 2020-08-26 Contra Costa California 6013 13259 172
204777 204777 2020-06-03 Rockland New York 36087 13259 464

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