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

16 rows where county = "Wayne" and "date" is on date 2022-04-15 sorted by date descending

✎ View and edit SQL

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

fips 16

county 1

  • Wayne · 16 ✖
Link rowid date ▲ county state fips cases deaths
2408934 2408934 2022-04-15 Wayne Georgia 13305 7769 204
2409090 2409090 2022-04-15 Wayne Illinois 17191 5295 85
2409186 2409186 2022-04-15 Wayne Indiana 18177 18836 334
2409283 2409283 2022-04-15 Wayne Iowa 19185 1265 33
2409511 2409511 2022-04-15 Wayne Kentucky 21231 6073 90
2409720 2409720 2022-04-15 Wayne Michigan 26163 401186 7914
2409887 2409887 2022-04-15 Wayne Mississippi 28153 6003 87
2410006 2410006 2022-04-15 Wayne Missouri 29223 2400 53
2410156 2410156 2022-04-15 Wayne Nebraska 31179 1825 11
2410299 2410299 2022-04-15 Wayne New York 36117 17519 173
2410398 2410398 2022-04-15 Wayne North Carolina 37191 31184 387
2410546 2410546 2022-04-15 Wayne Ohio 39169 23134 435
2410727 2410727 2022-04-15 Wayne Pennsylvania 42127 10176 169
2411019 2411019 2022-04-15 Wayne Tennessee 47181 5695 70
2411306 2411306 2022-04-15 Wayne Utah 49055 441 0
2411547 2411547 2022-04-15 Wayne West Virginia 54099 9816 122

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