johns_hopkins_csse_daily_reports

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 source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

7 rows where active = 1584, country_or_region = "US" and province_or_state = "Tennessee" sorted by day descending

✎ View and edit SQL

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

province_or_state 1

  • Tennessee · 7 ✖

country_or_region 1

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1341209 1341209 2021-02-15 US Tennessee Grundy 47061 1629 27 0 1584 35.38433717 -85.72142731 2021-02-16 05:24:38 Grundy, Tennessee, US
3981551 3981551 2021-02-10 US Tennessee Polk 47139 1610 21 0 1584 35.12245443 -84.52075859 2021-02-11 05:23:55 Polk, Tennessee, US
3981569 3981569 2021-02-10 US Tennessee Union 47173 1618 28 0 1584 36.28590426 -83.83651902 2021-02-11 05:23:55 Union, Tennessee, US
213233 213233 2020-10-29 US Tennessee Weakley 47183 1612 26 0 1584 36.29896232 -88.71990865 2020-10-30 04:24:49 Weakley, Tennessee, US
3654560 3654560 2020-10-24 US Tennessee Wayne 47181 1604 7 0 1584 35.23868267 -87.78644456 2020-10-25 04:24:36 Wayne, Tennessee, US
1999589 1999589 2020-08-26 US Tennessee Madison 47113 1700 34 0 1584 35.61181957 -88.84076036 2020-08-27 04:28:15 Madison, Tennessee, US
2684197 2684197 2020-07-06 US Tennessee Sumner 47165 1683 52 0 1584 36.46824103 -86.45917204 2020-07-07 04:34:00 Sumner, Tennessee, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] TEXT,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);