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 deaths = 327 and state = "Alabama" sorted by date descending

✎ View and edit SQL

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

Suggested facets: cases

fips 10

state 1

  • Alabama · 27 ✖
Link rowid date ▲ county state fips cases deaths
2463768 2463768 2022-05-02 DeKalb Alabama 1049 18762 327
2460512 2460512 2022-05-01 DeKalb Alabama 1049 18762 327
2457256 2457256 2022-04-30 DeKalb Alabama 1049 18762 327
2454000 2454000 2022-04-29 DeKalb Alabama 1049 18762 327
2450744 2450744 2022-04-28 DeKalb Alabama 1049 18759 327
2310817 2310817 2022-03-16 Lee Alabama 1081 37588 327
2307564 2307564 2022-03-15 Lee Alabama 1081 37583 327
2304313 2304313 2022-03-14 Lee Alabama 1081 37578 327
2262020 2262020 2022-03-01 Elmore Alabama 1051 22872 327
2258769 2258769 2022-02-28 Elmore Alabama 1051 22862 327
2255518 2255518 2022-02-27 Elmore Alabama 1051 22855 327
2252267 2252267 2022-02-26 Elmore Alabama 1051 22848 327
2131933 2131933 2022-01-20 Lauderdale Alabama 1077 20043 327
2128679 2128679 2022-01-19 Lauderdale Alabama 1077 19702 327
1787430 1787430 2021-10-06 Shelby Alabama 1117 36924 327
1784182 1784182 2021-10-05 St. Clair Alabama 1115 15713 327
1699689 1699689 2021-09-09 Houston Alabama 1069 15488 327
1443105 1443105 2021-06-22 Calhoun Alabama 1015 14724 327
1439860 1439860 2021-06-21 Calhoun Alabama 1015 14724 327
1436613 1436613 2021-06-20 Calhoun Alabama 1015 14719 327
1433366 1433366 2021-06-19 Calhoun Alabama 1015 14719 327
1430120 1430120 2021-06-18 Calhoun Alabama 1015 14719 327
1102220 1102220 2021-03-09 Etowah Alabama 1055 13435 327
1098974 1098974 2021-03-08 Etowah Alabama 1055 13427 327
1095726 1095726 2021-03-07 Etowah Alabama 1055 13419 327
1092480 1092480 2021-03-06 Etowah Alabama 1055 13413 327
706303 706303 2020-11-07 Mobile Alabama 1097 17729 327

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