johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where deaths = 7297 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1199638 | 1199638 | 2022-07-06 | Colombia | Cundinamarca | 321346 | 7297 | 0 | 5.026 | -74.03 | 2022-07-07 04:20:55 | Cundinamarca, Colombia | |||
3966381 | 3966381 | 2022-07-05 | Colombia | Cundinamarca | 321346 | 7297 | 0 | 5.026 | -74.03 | 2022-07-06 04:20:58 | Cundinamarca, Colombia | |||
3077892 | 3077892 | 2022-07-04 | Colombia | Cundinamarca | 321346 | 7297 | 0 | 5.026 | -74.03 | 2022-07-05 04:20:45 | Cundinamarca, Colombia | |||
1767174 | 1767174 | 2022-07-03 | Colombia | Cundinamarca | 321346 | 7297 | 0 | 5.026 | -74.03 | 2022-07-04 04:20:54 | Cundinamarca, Colombia | |||
3365160 | 3365160 | 2022-07-02 | Colombia | Cundinamarca | 321346 | 7297 | 0 | 5.026 | -74.03 | 2022-07-03 04:20:59 | Cundinamarca, Colombia | |||
593489 | 593489 | 2022-07-01 | Colombia | Cundinamarca | 321346 | 7297 | 0 | 5.026 | -74.03 | 2022-07-02 04:21:16 | Cundinamarca, Colombia | |||
3939890 | 3939890 | 2022-06-30 | Colombia | Cundinamarca | 321346 | 7297 | 0 | 5.026 | -74.03 | 2022-07-01 04:21:10 | Cundinamarca, Colombia | |||
3726124 | 3726124 | 2022-06-07 | Germany | Thuringen | 711303 | 7297 | 0 | 51.011 | 10.8453 | 2022-06-08 04:20:55 | Thuringen, Germany | |||
126462 | 126462 | 2022-01-09 | Brazil | Piaui | 344523 | 7297 | 0 | -7.7183 | -42.7289 | 2022-01-10 04:22:07 | Piaui, Brazil | |||
3288586 | 3288586 | 2021-11-18 | Afghanistan | 156739 | 7297 | 0 | 33.93911 | 67.709953 | 2021-11-19 04:21:40 | Afghanistan | ||||
447042 | 447042 | 2021-11-17 | Afghanistan | 156739 | 7297 | 0 | 33.93911 | 67.709953 | 2021-11-18 04:21:33 | Afghanistan | ||||
276162 | 276162 | 2021-11-03 | Italy | Toscana | 290321 | 7297 | 0 | 43.76923077 | 11.25588885 | 2021-11-04 04:22:20 | Toscana, Italy | |||
1425266 | 1425266 | 2021-05-09 | Peru | Lambayeque | 52080 | 7297 | 0 | 44783 | -6.353049 | -79.824113 | 2021-05-10 04:20:38 | Lambayeque, Peru | ||
3452782 | 3452782 | 2021-03-18 | Greece | 230317 | 7297 | 93764 | 129256 | 39.0742 | 21.8243 | 2021-03-19 05:26:09 | Greece | |||
3306441 | 3306441 | 2020-11-02 | US | New York | Queens | 36081 | 79521 | 7297 | 0 | 72224 | 40.71088124 | -73.81684712 | 2020-11-03 06:00:16 | Queens, New York, US |
3411690 | 3411690 | 2020-11-01 | US | New York | Queens | 36081 | 79298 | 7297 | 0 | 72001 | 40.71088124 | -73.81684712 | 2020-11-02 05:25:04 | Queens, New York, US |
546482 | 546482 | 2020-09-12 | Bolivia | 125982 | 7297 | 82796 | 35889 | -16.2902 | -63.5887 | 2020-09-13 04:30:52 | Bolivia | |||
429561 | 429561 | 2020-09-07 | US | New York | Kings | 36047 | 66558 | 7297 | 0 | 59261 | 40.6361825 | -73.94935552 | 2020-09-08 04:28:25 | Kings, New York, US |
1556057 | 1556057 | 2020-08-16 | Mexico | Mexico | 61431 | 7297 | 50162 | 3972 | 19.4969 | -99.7233 | 2020-08-17 04:27:20 | 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]);