johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where deaths = 6245 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2394818 | 2394818 | 2022-09-12 | Japan | Osaka | 2011964 | 6245 | 0 | 34.620965 | 135.507481 | 2022-09-13 04:20:57 | Osaka, Japan | |||
1405142 | 1405142 | 2022-08-02 | Mexico | Queretaro | 169628 | 6245 | 0 | 20.5888 | -100.3899 | 2022-08-03 04:20:59 | Queretaro, Mexico | |||
3718448 | 3718448 | 2022-02-21 | Russia | Volgograd Oblast | 175906 | 6245 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-02-22 04:21:01 | Volgograd Oblast, Russia | |||
2905410 | 2905410 | 2021-12-19 | US | Michigan | Wayne | 26163 | 251556 | 6245 | 0 | 42.28098405 | -83.281255 | 2021-12-20 04:21:43 | Wayne, Michigan, US | |
1260483 | 1260483 | 2021-12-18 | US | Michigan | Wayne | 26163 | 251556 | 6245 | 0 | 42.28098405 | -83.281255 | 2021-12-19 04:21:11 | Wayne, Michigan, US | |
2400511 | 2400511 | 2021-12-17 | US | Michigan | Wayne | 26163 | 251556 | 6245 | 0 | 42.28098405 | -83.281255 | 2021-12-18 02:22:20 | Wayne, Michigan, US | |
1956617 | 1956617 | 2021-08-05 | Mexico | Michoacan | 55253 | 6245 | 0 | 19.5665 | -101.7068 | 2021-08-06 04:21:18 | Michoacan, Mexico | |||
3218407 | 3218407 | 2021-07-26 | Moldova | 258713 | 6245 | 251553 | 915 | 47.4116 | 28.3699 | 2021-07-27 04:21:18 | Moldova | |||
2947202 | 2947202 | 2021-07-16 | Colombia | Cundinamarca | 245352 | 6245 | 232050 | 7057 | 5.026 | -74.03 | 2021-07-17 04:22:22 | Cundinamarca, Colombia | ||
1448333 | 1448333 | 2021-06-03 | Brazil | Rio Grande do Norte | 272885 | 6245 | 150649 | 115296 | -5.4026 | -36.9541 | 2021-06-04 04:23:37 | Rio Grande do Norte, Brazil | ||
3105097 | 3105097 | 2021-01-16 | United Kingdom | Wales | 178989 | 6245 | 0 | 174763 | 52.1307 | -3.7837 | 2021-01-17 05:22:17 | Wales, United Kingdom | ||
1006405 | 1006405 | 2020-12-06 | Morocco | 379657 | 6245 | 331301 | 42111 | 31.7917 | -7.0926 | 2020-12-07 05:26:14 | Morocco | |||
3189727 | 3189727 | 2020-11-22 | Brazil | Goias | 273308 | 6245 | 263598 | 3438 | -15.827 | -49.8362 | 2020-11-23 05:25:26 | Goias, Brazil | ||
1054001 | 1054001 | 2020-10-23 | Romania | 201032 | 6245 | 144429 | 50358 | 45.9432 | 24.9668 | 2020-10-24 04:24:46 | Romania | |||
2689652 | 2689652 | 2020-10-08 | India | Uttar Pradesh | 427459 | 6245 | 378662 | 42552 | 26.925425 | 80.560982 | 2020-10-09 04:23:59 | Uttar Pradesh, India | ||
1523516 | 1523516 | 2020-08-28 | Turkey | 265515 | 6245 | 241809 | 17461 | 38.9637 | 35.2433 | 2020-08-29 04:28:19 | Turkey | |||
1135961 | 1135961 | 2020-06-26 | Mexico | Ciudad de Mexico | 45977 | 6245 | 35837 | 3895 | 19.4326 | -99.1332 | 2020-06-27 04:33:35 | Ciudad de Mexico, Mexico |
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]);