johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12 rows where deaths = 7575 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753072 | 2753072 | 2022-12-29 | Peru | Junin | 153546 | 7575 | 0 | -11.541783 | -74.876968 | 2022-12-30 04:21:04 | Junin, Peru | |||
1074078 | 1074078 | 2022-12-28 | Peru | Junin | 153546 | 7575 | 0 | -11.541783 | -74.876968 | 2022-12-29 04:21:01 | Junin, Peru | |||
328075 | 328075 | 2022-12-27 | Peru | Junin | 153546 | 7575 | 0 | -11.541783 | -74.876968 | 2022-12-28 04:21:04 | Junin, Peru | |||
218148 | 218148 | 2022-12-26 | Peru | Junin | 153546 | 7575 | 0 | -11.541783 | -74.876968 | 2022-12-27 04:21:07 | Junin, Peru | |||
3745018 | 3745018 | 2022-09-07 | Germany | Thuringen | 785265 | 7575 | 0 | 51.011 | 10.8453 | 2022-09-08 04:21:02 | Thuringen, Germany | |||
991095 | 991095 | 2022-08-16 | Mexico | San Luis Potosi | 230679 | 7575 | 0 | 22.1565 | -100.9855 | 2022-08-17 04:20:59 | San Luis Potosi, Mexico | |||
2657644 | 2657644 | 2022-01-31 | Costa Rica | 694865 | 7575 | 0 | 9.7489 | -83.7534 | 2022-02-01 04:21:11 | Costa Rica | ||||
1385907 | 1385907 | 2021-09-13 | Serbia | 823161 | 7575 | 0 | 44.0165 | 21.0059 | 2021-09-14 04:21:41 | Serbia | ||||
2255896 | 2255896 | 2021-05-19 | Peru | Lambayeque | 53673 | 7575 | 0 | 46098 | -6.353049 | -79.824113 | 2021-05-20 04:21:05 | Lambayeque, Peru | ||
3643291 | 3643291 | 2021-03-30 | Brazil | Mato Grosso | 307491 | 7575 | 282331 | 15825 | -12.6819 | -56.9211 | 2021-03-31 04:26:25 | Mato Grosso, Brazil | ||
1338611 | 1338611 | 2021-02-15 | Tunisia | 223549 | 7575 | 183530 | 32444 | 33.886917 | 9.537499 | 2021-02-16 05:24:38 | Tunisia | |||
1036605 | 1036605 | 2020-12-15 | US | New York | Kings | 36047 | 106137 | 7575 | 0 | 98562 | 40.6361825 | -73.94935552 | 2020-12-16 05:28:04 | Kings, New York, US |
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]);