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

15 rows where confirmed = 397, country_or_region = "US" and province_or_state = "Idaho" sorted by day descending

✎ View and edit SQL

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

province_or_state 1

  • Idaho · 15 ✖

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
3750061 3750061 2021-11-22 US Idaho Custer 16037 397 6 0   44.24186819 -114.2855494 2021-11-23 04:22:39 Custer, Idaho, US
3194914 3194914 2021-09-06 US Idaho Adams 16003 397 5 0   44.89333571 -116.4545247 2021-09-07 04:21:35 Adams, Idaho, US
3281782 3281782 2021-09-05 US Idaho Adams 16003 397 5 0   44.89333571 -116.4545247 2021-09-06 04:21:22 Adams, Idaho, US
250196 250196 2021-09-04 US Idaho Adams 16003 397 5 0   44.89333571 -116.4545247 2021-09-05 04:21:33 Adams, Idaho, US
3975477 3975477 2021-09-03 US Idaho Adams 16003 397 5 0   44.89333571 -116.4545247 2021-09-04 04:21:28 Adams, Idaho, US
1379426 1379426 2021-07-25 US Idaho Boise 16015 397 2 0   43.98829931 -115.7309284 2021-07-26 04:21:28 Boise, Idaho, US
1331166 1331166 2021-07-24 US Idaho Boise 16015 397 2 0   43.98829931 -115.7309284 2021-07-25 04:22:12 Boise, Idaho, US
3138470 3138470 2021-07-23 US Idaho Boise 16015 397 2 0   43.98829931 -115.7309284 2021-07-24 00:21:36 Boise, Idaho, US
2940264 2940264 2021-05-16 US Idaho Lewis 16061 397 9 0   46.23315327 -116.434146 2021-05-17 04:20:34 Lewis, Idaho, US
1873894 1873894 2021-05-15 US Idaho Lewis 16061 397 9 0   46.23315327 -116.434146 2021-05-16 04:20:49 Lewis, Idaho, US
1082863 1082863 2021-05-14 US Idaho Lewis 16061 397 9 0   46.23315327 -116.434146 2021-05-15 04:20:58 Lewis, Idaho, US
3055129 3055129 2021-05-13 US Idaho Lewis 16061 397 9 0   46.23315327 -116.434146 2021-05-14 04:20:41 Lewis, Idaho, US
2348339 2348339 2020-12-07 US Idaho Boundary 16021 397 4 0 393 48.76684761 -116.4630179 2020-12-08 05:27:42 Boundary, Idaho, US
818510 818510 2020-10-09 US Idaho Washington 16087 397 6 0 391 44.45275475 -116.7847688 2020-10-10 04:23:57 Washington, Idaho, US
2690600 2690600 2020-10-08 US Idaho Elmore 16039 397 4 0 393 43.3507101 -115.4701578 2020-10-09 04:23:59 Elmore, Idaho, 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]);