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 = 10255 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
2413971 2413971 2022-04-16 Pike Pennsylvania 42103 10255 95
2305674 2305674 2022-03-14 Steele Minnesota 27147 10255 58
2306743 2306743 2022-03-14 Brown South Dakota 46013 10255 120
2247598 2247598 2022-02-24 Cortland New York 36023 10255 113
2175553 2175553 2022-02-02 Itasca Minnesota 27061 10255 129
2087090 2087090 2022-01-06 Dearborn Indiana 18029 10255 115
1892426 1892426 2021-11-07 McCracken Kentucky 21145 10255 178
1889176 1889176 2021-11-06 McCracken Kentucky 21145 10255 178
1885926 1885926 2021-11-05 McCracken Kentucky 21145 10255 178
1802500 1802500 2021-10-10 Ross Ohio 39141 10255 188
1727764 1727764 2021-09-17 Pickaway Ohio 39129 10255 128
1659730 1659730 2021-08-27 Mercer Pennsylvania 42085 10255 271
1613761 1613761 2021-08-13 Warren New Jersey 34041 10255 242
1584496 1584496 2021-08-04 Strafford New Hampshire 33017 10255 100
1573000 1573000 2021-08-01 Lauderdale Alabama 1077 10255 254
1477094 1477094 2021-07-02 Jasper Missouri 29097 10255 132
1402421 1402421 2021-06-09 Clay Missouri 29047 10255 169
1206822 1206822 2021-04-10 Delaware Indiana 18035 10255 188
1157922 1157922 2021-03-26 Walton Georgia 13297 10255 243
1141184 1141184 2021-03-21 Houston Alabama 1069 10255 269
993676 993676 2021-02-03 Sandoval New Mexico 35043 10255 179
839987 839987 2020-12-18 Rock Island Illinois 17161 10255 216
786740 786740 2020-12-01 Sumner Tennessee 47165 10255 137
582335 582335 2020-09-29 Knox Tennessee 47093 10255 83
390305 390305 2020-08-01 Orleans Louisiana 22071 10255 560
387088 387088 2020-07-31 Orleans Louisiana 22071 10255 560
387621 387621 2020-07-31 Douglas Nebraska 31055 10255 134

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