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 2021-03-12 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
1112472 1112472 2021-03-12 Wayne Georgia 13305 3360 79
1112627 1112627 2021-03-12 Wayne Illinois 17191 1695 50
1112722 1112722 2021-03-12 Wayne Indiana 18177 7075 195
1112819 1112819 2021-03-12 Wayne Iowa 19185 489 21
1113047 1113047 2021-03-12 Wayne Kentucky 21231 2117 44
1113255 1113255 2021-03-12 Wayne Michigan 26163 105618 4188
1113421 1113421 2021-03-12 Wayne Mississippi 28153 2576 41
1113540 1113540 2021-03-12 Wayne Missouri 29223 1020 11
1113689 1113689 2021-03-12 Wayne Nebraska 31179 1001 7
1113830 1113830 2021-03-12 Wayne New York 36117 4598 65
1113929 1113929 2021-03-12 Wayne North Carolina 37191 10388 227
1114075 1114075 2021-03-12 Wayne Ohio 39169 8017 203
1114256 1114256 2021-03-12 Wayne Pennsylvania 42127 3162 68
1114548 1114548 2021-03-12 Wayne Tennessee 47181 2896 30
1114835 1114835 2021-03-12 Wayne Utah 49055 122 0
1115076 1115076 2021-03-12 Wayne West Virginia 54099 2616 32

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