johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where deaths = 4254 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3436600 | 3436600 | 2022-04-22 | Chile | Biobio | 352215 | 4254 | 0 | -37.4464 | -72.1416 | 2022-04-23 04:20:50 | Biobio, Chile | |||
3206409 | 3206409 | 2022-04-11 | Oman | 388709 | 4254 | 0 | 21.512583 | 55.92325500000001 | 2022-04-12 04:20:49 | Oman | ||||
1576295 | 1576295 | 2022-04-10 | Oman | 388686 | 4254 | 0 | 21.512583 | 55.92325500000001 | 2022-04-11 04:21:02 | Oman | ||||
1366015 | 1366015 | 2022-02-08 | United Kingdom | Northern Ireland | 573241 | 4254 | 0 | 54.7877 | -6.4923 | 2022-02-09 04:21:04 | Northern Ireland, United Kingdom | |||
4001346 | 4001346 | 2021-12-30 | US | Pennsylvania | Philadelphia | 42101 | 224017 | 4254 | 0 | 40.00338507 | -75.1379271 | 2021-12-31 04:21:50 | Philadelphia, Pennsylvania, US | |
2963581 | 2963581 | 2021-12-24 | Russia | Bashkortostan Republic | 119562 | 4254 | 0 | 54.8573563 | 57.1439682 | 2021-12-25 04:21:37 | Bashkortostan Republic, Russia | |||
2131860 | 2131860 | 2021-10-01 | Colombia | Norte de Santander | 90547 | 4254 | 0 | 7.9463 | -72.8988 | 2021-10-02 04:21:25 | Norte de Santander, Colombia | |||
1265810 | 1265810 | 2021-09-09 | US | Texas | Bexar | 48029 | 298567 | 4254 | 0 | 29.44928723 | -98.52019748 | 2021-09-10 04:21:20 | Bexar, Texas, US | |
1342384 | 1342384 | 2021-08-11 | Mexico | Oaxaca | 58783 | 4254 | 0 | 17.0732 | -96.7266 | 2021-08-12 04:21:25 | Oaxaca, Mexico | |||
3903662 | 3903662 | 2021-07-31 | Algeria | 171392 | 4254 | 115276 | 51862 | 28.0339 | 1.6596 | 2021-08-01 04:21:50 | Algeria | |||
50855 | 50855 | 2021-05-29 | Lithuania | 274257 | 4254 | 254322 | 15299 | 55.1694 | 23.8813 | 2021-05-30 04:20:55 | Lithuania | |||
2359461 | 2359461 | 2021-03-08 | Italy | Sicilia | 156903 | 4254 | 137250 | 15399 | 38.11569725 | 13.362356699999998 | 2021-03-09 05:28:19 | Sicilia, Italy | ||
2406777 | 2406777 | 2020-12-23 | India | Gujarat | 238205 | 4254 | 222911 | 11040 | 22.694884 | 71.590923 | 2020-12-24 05:23:04 | Gujarat, India | ||
2975062 | 2975062 | 2020-12-09 | Colombia | Antioquia | 224441 | 4254 | 209118 | 11069 | 7.1986 | -75.3412 | 2020-12-10 05:26:19 | Antioquia, Colombia | ||
1972749 | 1972749 | 2020-11-25 | Peru | Lambayeque | 30381 | 4254 | 0 | 26127 | -6.353049 | -79.824113 | 2020-11-26 05:27:44 | Lambayeque, Peru | ||
3781637 | 3781637 | 2020-10-13 | Brazil | Amazonas | 147864 | 4254 | 120012 | 23598 | -3.4168 | -65.8561 | 2020-10-14 04:24:05 | Amazonas, Brazil | ||
3097066 | 3097066 | 2020-09-20 | United Kingdom | Scotland | 24371 | 4254 | 0 | 21866 | 56.4907 | -4.2026 | 2020-09-21 04:23:00 | Scotland, United Kingdom |
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]);