johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where active = 12728 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 7
- US 6
- France 3
- Azerbaijan 1
- Brazil 1
- Greece 1
- Portugal 1
- West Bank and Gaza 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3053895 | 3053895 | 2021-05-13 | Azerbaijan | 328668 | 4742 | 311198 | 12728 | 40.1431 | 47.5769 | 2021-05-14 04:20:41 | Azerbaijan | |||
1092747 | 1092747 | 2021-03-03 | US | Pennsylvania | Lebanon | 42075 | 12987 | 259 | 0 | 12728 | 40.36680311 | -76.45651841 | 2021-03-04 05:24:24 | Lebanon, Pennsylvania, US |
2370406 | 2370406 | 2021-02-28 | US | Tennessee | Bradley | 47011 | 12807 | 139 | 0 | 12728 | 35.15739424 | -84.857186 | 2021-03-01 05:23:01 | Bradley, Tennessee, US |
1861668 | 1861668 | 2021-02-25 | West Bank and Gaza | 179293 | 2008 | 164557 | 12728 | 31.9522 | 35.2332 | 2021-02-26 05:22:40 | West Bank and Gaza | |||
1093981 | 1093981 | 2021-01-20 | France | French Polynesia | 17697 | 127 | 4842 | 12728 | -17.6797 | -149.4068 | 2021-01-21 05:22:01 | French Polynesia, France | ||
908071 | 908071 | 2021-01-19 | France | French Polynesia | 17697 | 127 | 4842 | 12728 | -17.6797 | -149.4068 | 2021-01-20 05:21:54 | French Polynesia, France | ||
237134 | 237134 | 2021-01-18 | France | French Polynesia | 17697 | 127 | 4842 | 12728 | -17.6797 | -149.4068 | 2021-01-19 05:22:15 | French Polynesia, France | ||
193193 | 193193 | 2021-01-11 | US | Texas | Johnson | 48251 | 13067 | 184 | 0 | 12728 | 32.37877812 | -97.36615819 | 2021-01-12 05:22:15 | Johnson, Texas, US |
191637 | 191637 | 2021-01-11 | US | Maryland | Frederick | 24021 | 12937 | 209 | 0 | 12728 | 39.47296601 | -77.39999394 | 2021-01-12 05:22:15 | Frederick, Maryland, US |
2628996 | 2628996 | 2021-01-10 | US | Texas | Johnson | 48251 | 13067 | 184 | 0 | 12728 | 32.37877812 | -97.36615819 | 2021-01-11 05:21:50 | Johnson, Texas, US |
1795310 | 1795310 | 2020-10-19 | US | Florida | Escambia | 12033 | 12997 | 269 | 0 | 12728 | 30.67652764 | -87.37284571 | 2020-10-20 04:24:22 | Escambia, Florida, US |
1121514 | 1121514 | 2020-09-17 | Greece | 14400 | 325 | 1347 | 12728 | 39.0742 | 21.8243 | 2020-09-18 05:05:00 | Greece | |||
3178183 | 3178183 | 2020-08-18 | Portugal | 54448 | 1784 | 39936 | 12728 | 39.3999 | -8.2245 | 2020-08-19 04:27:00 | Portugal | |||
662057 | 662057 | 2020-08-11 | Brazil | Tocantins | 33766 | 482 | 19845 | 12728 | -10.1753 | -48.2982 | 2020-08-12 04:27:29 | Tocantins, Brazil |
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]);