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 = 3094, country_or_region = "US" and province_or_state = "Iowa" sorted by day descending

✎ View and edit SQL

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

These facets timed out: province_or_state

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
1251920 1251920 2022-08-23 US Iowa Appanoose 19007 3094 70 0   40.74324454 -92.86865906 2022-08-24 04:20:46 Appanoose, Iowa, US
2854024 2854024 2022-08-22 US Iowa Appanoose 19007 3094 70 0   40.74324454 -92.86865906 2022-08-23 04:20:56 Appanoose, Iowa, US
2403996 2403996 2022-08-21 US Iowa Appanoose 19007 3094 70 0   40.74324454 -92.86865906 2022-08-22 04:20:38 Appanoose, Iowa, US
3799074 3799074 2022-08-20 US Iowa Appanoose 19007 3094 70 0   40.74324454 -92.86865906 2022-08-21 04:20:44 Appanoose, Iowa, US
2364660 2364660 2022-08-19 US Iowa Appanoose 19007 3094 70 0   40.74324454 -92.86865906 2022-08-20 04:21:01 Appanoose, Iowa, US
1162331 1162331 2022-08-18 US Iowa Appanoose 19007 3094 70 0   40.74324454 -92.86865906 2022-08-19 04:20:54 Appanoose, Iowa, US
3951655 3951655 2022-08-17 US Iowa Appanoose 19007 3094 70 0   40.74324454 -92.86865906 2022-08-18 04:21:11 Appanoose, Iowa, US
3106661 3106661 2021-08-24 US Iowa Jones 19105 3094 57 0   42.12118609 -91.13139641 2021-08-25 04:21:41 Jones, Iowa, US
3166832 3166832 2021-08-23 US Iowa Jones 19105 3094 57 0   42.12118609 -91.13139641 2021-08-24 04:21:19 Jones, Iowa, US
2176759 2176759 2021-08-22 US Iowa Jones 19105 3094 57 0   42.12118609 -91.13139641 2021-08-23 04:21:27 Jones, Iowa, US
3556855 3556855 2021-08-21 US Iowa Jones 19105 3094 57 0   42.12118609 -91.13139641 2021-08-22 04:21:29 Jones, Iowa, US
1855197 1855197 2021-08-20 US Iowa Jones 19105 3094 57 0   42.12118609 -91.13139641 2021-08-21 04:21:38 Jones, Iowa, US
512904 512904 2021-08-19 US Iowa Jones 19105 3094 57 0   42.12118609 -91.13139641 2021-08-20 04:21:33 Jones, Iowa, US
2519383 2519383 2021-08-18 US Iowa Jones 19105 3094 57 0   42.12118609 -91.13139641 2021-08-19 04:21:15 Jones, Iowa, US
846791 846791 2020-12-12 US Iowa Plymouth 19149 3094 40 0 3054 42.737633 -96.21366621 2020-12-13 05:27:20 Plymouth, Iowa, 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]);