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

25 rows where county = "Franklin" and "date" is on date 2021-09-19 sorted by date descending

✎ View and edit SQL

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

fips 25

county 1

  • Franklin · 25 ✖
Link rowid date ▲ county state fips cases deaths
1732167 1732167 2021-09-19 Franklin Alabama 1059 5649 97
1732272 1732272 2021-09-19 Franklin Arkansas 5047 2597 46
1732478 1732478 2021-09-19 Franklin Florida 12037 2142 35
1732587 1732587 2021-09-19 Franklin Georgia 13119 3659 65
1732716 1732716 2021-09-19 Franklin Idaho 16041 1410 19
1732767 1732767 2021-09-19 Franklin Illinois 17055 6696 106
1732866 1732866 2021-09-19 Franklin Indiana 18047 2354 38
1732969 1732969 2021-09-19 Franklin Iowa 19069 1487 24
1733064 1733064 2021-09-19 Franklin Kansas 20059 3427 52
1733176 1733176 2021-09-19 Franklin Kentucky 21073 6138 66
1733280 1733280 2021-09-19 Franklin Louisiana 22041 4116 133
1733328 1733328 2021-09-19 Franklin Maine 23007 1719 17
1733372 1733372 2021-09-19 Franklin Massachusetts 25011 3057 115
1733572 1733572 2021-09-19 Franklin Mississippi 28037 1152 27
1733671 1733671 2021-09-19 Franklin Missouri 29071 13378 198
1733839 1733839 2021-09-19 Franklin Nebraska 31061 266 4
1734001 1734001 2021-09-19 Franklin New York 36033 3444 15
1734078 1734078 2021-09-19 Franklin North Carolina 37069 8857 58
1734224 1734224 2021-09-19 Franklin Ohio 39049 150587 1556
1734430 1734430 2021-09-19 Franklin Pennsylvania 42055 18707 398
1734692 1734692 2021-09-19 Franklin Tennessee 47051 7347 95
1734842 1734842 2021-09-19 Franklin Texas 48159 1188 28
1735052 1735052 2021-09-19 Franklin Vermont 50011 2566 40
1735109 1735109 2021-09-19 Franklin Virginia 51067 5204 87
1735209 1735209 2021-09-19 Franklin Washington 53021 18129 154

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