johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8 rows where confirmed = 27256 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 4
- Estonia 1
- India 1
- Luxembourg 1
- Russia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
962397 | 962397 | 2022-07-19 | US | West Virginia | Monongalia | 54061 | 27256 | 198 | 0 | 39.63218457 | -80.04766838 | 2022-07-20 04:20:59 | Monongalia, West Virginia, US | |
2803978 | 2803978 | 2022-04-06 | US | Texas | Randall | 48381 | 27256 | 489 | 0 | 34.96585996 | -101.8971322 | 2022-04-07 04:20:53 | Randall, Texas, US | |
3858275 | 3858275 | 2022-02-18 | US | Ohio | Allen | 39003 | 27256 | 472 | 0 | 40.77285242 | -84.10802343 | 2022-02-19 04:21:11 | Allen, Ohio, US | |
4555 | 4555 | 2021-10-28 | Russia | Karachay-Cherkess Republic | 27256 | 739 | 0 | 43.7368326 | 41.7267991 | 2021-10-29 04:22:03 | Karachay-Cherkess Republic, Russia | |||
3494654 | 3494654 | 2021-10-26 | US | Ohio | Lake | 39085 | 27256 | 470 | 0 | 41.69710807 | -81.23676539 | 2021-10-27 04:22:32 | Lake, Ohio, US | |
1301993 | 1301993 | 2021-04-01 | India | Chandigarh | 27256 | 380 | 23925 | 2951 | 30.733839 | 76.76827800000002 | 2021-04-02 04:20:36 | Chandigarh, India | ||
1010193 | 1010193 | 2020-12-30 | Estonia | 27256 | 226 | 17664 | 9366 | 58.5953 | 25.0136 | 2020-12-31 05:22:49 | Estonia | |||
3169701 | 3169701 | 2020-11-16 | Luxembourg | 27256 | 236 | 17734 | 9286 | 49.8153 | 6.1296 | 2020-11-17 05:25:54 | Luxembourg |
Advanced export
JSON shape: default, array, newline-delimited
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]);