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-02-10 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
2200761 2200761 2022-02-10 Wayne Georgia 13305 7519 193
2200917 2200917 2022-02-10 Wayne Illinois 17191 5156 78
2201012 2201012 2022-02-10 Wayne Indiana 18177 18863 321
2201109 2201109 2022-02-10 Wayne Iowa 19185 1215 32
2201336 2201336 2022-02-10 Wayne Kentucky 21231 4604 85
2201545 2201545 2022-02-10 Wayne Michigan 26163 387204 7373
2201711 2201711 2022-02-10 Wayne Mississippi 28153 5845 83
2201830 2201830 2022-02-10 Wayne Missouri 29223 2315 44
2201980 2201980 2022-02-10 Wayne Nebraska 31179 1665 11
2202122 2202122 2022-02-10 Wayne New York 36117 16571 162
2202221 2202221 2022-02-10 Wayne North Carolina 37191 26887 367
2202369 2202369 2022-02-10 Wayne Ohio 39169 22831 402
2202550 2202550 2022-02-10 Wayne Pennsylvania 42127 9778 156
2202842 2202842 2022-02-10 Wayne Tennessee 47181 5491 53
2203129 2203129 2022-02-10 Wayne Utah 49055 423 0
2203371 2203371 2022-02-10 Wayne West Virginia 54099 9334 100

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