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 = 14959 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
2418164 2418164 2022-04-18 Blount Alabama 1009 14959 242
2414908 2414908 2022-04-17 Blount Alabama 1009 14959 242
2411652 2411652 2022-04-16 Blount Alabama 1009 14959 242
2408396 2408396 2022-04-15 Blount Alabama 1009 14959 242
2375713 2375713 2022-04-04 Marion West Virginia 54049 14959 178
2316397 2316397 2022-03-17 Guaynabo Puerto Rico 72061 14959  
2293551 2293551 2022-03-10 Columbia Pennsylvania 42037 14959 242
2188549 2188549 2022-02-06 Crow Wing Minnesota 27035 14959 154
2185296 2185296 2022-02-05 Crow Wing Minnesota 27035 14959 154
2182044 2182044 2022-02-04 Crow Wing Minnesota 27035 14959 154
2050849 2050849 2021-12-26 Sutter California 6101 14959 191
2047599 2047599 2021-12-25 Sutter California 6101 14959 191
2044349 2044349 2021-12-24 Sutter California 6101 14959 191
2029793 2029793 2021-12-19 Craven North Carolina 37049 14959 162
2026542 2026542 2021-12-18 Craven North Carolina 37049 14959 162
2023291 2023291 2021-12-17 Craven North Carolina 37049 14959 162
2020565 2020565 2021-12-16 Orangeburg South Carolina 45075 14959 340
1922127 1922127 2021-11-16 Franklin Missouri 29071 14959 228
1813904 1813904 2021-10-14 Walton Georgia 13297 14959 327
1801125 1801125 2021-10-10 Monroe Indiana 18105 14959 199
1797876 1797876 2021-10-09 Monroe Indiana 18105 14959 199
1794627 1794627 2021-10-08 Monroe Indiana 18105 14959 199
1695394 1695394 2021-09-07 Deschutes Oregon 41017 14959 94
1603427 1603427 2021-08-10 Washington Maryland 24043 14959 336
988563 988563 2021-02-01 Washington Wisconsin 55131 14959 131
969214 969214 2021-01-27 Coconino Arizona 4005 14959 266
859195 859195 2020-12-24 Cherokee Georgia 13057 14959 128
331093 331093 2020-07-13 Salt Lake Utah 49035 14959 132

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