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

23 rows where county = "Jackson" and "date" is on date 2020-06-10 sorted by date descending

✎ View and edit SQL

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

fips 23

county 1

  • Jackson · 23 ✖
Link rowid date ▲ county state fips cases deaths
224646 224646 2020-06-10 Jackson Alabama 1071 104 3
224748 224748 2020-06-10 Jackson Arkansas 5067 14 0
224952 224952 2020-06-10 Jackson Florida 12063 311 1
225067 225067 2020-06-10 Jackson Georgia 13157 239 7
225228 225228 2020-06-10 Jackson Illinois 17077 307 11
225327 225327 2020-06-10 Jackson Indiana 18071 411 3
225432 225432 2020-06-10 Jackson Iowa 19097 14 0
225521 225521 2020-06-10 Jackson Kansas 20085 102 1
225628 225628 2020-06-10 Jackson Kentucky 21109 61 13
225717 225717 2020-06-10 Jackson Louisiana 22049 148 15
225852 225852 2020-06-10 Jackson Michigan 26075 2051 52
225928 225928 2020-06-10 Jackson Minnesota 27063 43 0
226012 226012 2020-06-10 Jackson Mississippi 28059 339 16
226109 226109 2020-06-10 Jackson Missouri 29095 752 22
226468 226468 2020-06-10 Jackson North Carolina 37099 55 1
226606 226606 2020-06-10 Jackson Ohio 39079 16 0
226685 226685 2020-06-10 Jackson Oklahoma 40065 30 3
226742 226742 2020-06-10 Jackson Oregon 41029 77 0
226990 226990 2020-06-10 Jackson South Dakota 46071 4 0
227061 227061 2020-06-10 Jackson Tennessee 47087 19 0
227229 227229 2020-06-10 Jackson Texas 48239 19 1
227579 227579 2020-06-10 Jackson West Virginia 54035 141 18
227642 227642 2020-06-10 Jackson Wisconsin 55053 20 1

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