johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10 rows where deaths = 9651 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- India 2
- Azerbaijan 1
- Bosnia and Herzegovina 1
- Brazil 1
- Colombia 1
- Egypt 1
- Germany 1
- Israel 1
- Italy 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2063852 | 2063852 | 2022-11-19 | India | Rajasthan | 1315103 | 9651 | 0 | 26.583423 | 73.847973 | 2022-11-20 04:21:08 | Rajasthan, India | |||
1755246 | 1755246 | 2022-11-18 | India | Rajasthan | 1315084 | 9651 | 0 | 26.583423 | 73.847973 | 2022-11-19 04:21:14 | Rajasthan, India | |||
1656099 | 1656099 | 2022-03-19 | Azerbaijan | 791404 | 9651 | 0 | 40.1431 | 47.5769 | 2022-03-20 04:20:45 | Azerbaijan | ||||
3671614 | 3671614 | 2022-02-15 | Israel | 3474120 | 9651 | 0 | 31.046051000000002 | 34.851612 | 2022-02-16 04:21:10 | Israel | ||||
903998 | 903998 | 2021-11-24 | Colombia | Atlantico | 337736 | 9651 | 0 | 10.6966 | -74.8741 | 2021-11-25 04:22:33 | Atlantico, Colombia | |||
2422616 | 2422616 | 2021-06-23 | Bosnia and Herzegovina | 204910 | 9651 | 180862 | 14397 | 43.9159 | 17.6791 | 2021-06-24 04:21:55 | Bosnia and Herzegovina | |||
1081832 | 1081832 | 2021-05-14 | Germany | Baden-Wurttemberg | 475324 | 9651 | 433100 | 33835 | 48.6616 | 9.3501 | 2021-05-15 04:20:58 | Baden-Wurttemberg, Germany | ||
1203558 | 1203558 | 2021-03-22 | Brazil | Santa Catarina | 767652 | 9651 | 720386 | 37615 | -27.2423 | -50.2189 | 2021-03-23 05:26:18 | Santa Catarina, Brazil | ||
1153119 | 1153119 | 2021-02-18 | Italy | Veneto | 323888 | 9651 | 292251 | 21986 | 45.43490485 | 12.33845213 | 2021-02-19 05:24:16 | Veneto, Italy | ||
1672340 | 1672340 | 2021-02-07 | Egypt | 169640 | 9651 | 132375 | 27614 | 26.820553000000004 | 30.802498 | 2021-02-08 05:22:39 | Egypt |
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]);