johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where deaths = 7946 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
868706 | 868706 | 2022-12-11 | Germany | Thuringen | 865660 | 7946 | 0 | 51.011 | 10.8453 | 2022-12-12 04:21:01 | Thuringen, Germany | |||
257236 | 257236 | 2022-12-10 | Germany | Thuringen | 865660 | 7946 | 0 | 51.011 | 10.8453 | 2022-12-11 04:20:50 | Thuringen, Germany | |||
3935950 | 3935950 | 2022-12-09 | Germany | Thuringen | 865660 | 7946 | 0 | 51.011 | 10.8453 | 2022-12-10 04:21:02 | Thuringen, Germany | |||
3523747 | 3523747 | 2022-11-24 | Spain | Castilla - La Mancha | 601910 | 7946 | 0 | 39.2796 | -3.0977 | 2022-11-25 04:21:06 | Castilla - La Mancha, Spain | |||
3312530 | 3312530 | 2022-11-23 | Spain | Castilla - La Mancha | 601910 | 7946 | 0 | 39.2796 | -3.0977 | 2022-11-24 04:21:09 | Castilla - La Mancha, Spain | |||
1620571 | 1620571 | 2022-11-22 | Spain | Castilla - La Mancha | 601910 | 7946 | 0 | 39.2796 | -3.0977 | 2022-11-23 04:21:06 | Castilla - La Mancha, Spain | |||
3460459 | 3460459 | 2022-11-21 | Spain | Castilla - La Mancha | 601910 | 7946 | 0 | 39.2796 | -3.0977 | 2022-11-22 04:20:47 | Castilla - La Mancha, Spain | |||
1640644 | 1640644 | 2022-11-20 | Spain | Castilla - La Mancha | 601910 | 7946 | 0 | 39.2796 | -3.0977 | 2022-11-21 04:21:05 | Castilla - La Mancha, Spain | |||
2064201 | 2064201 | 2022-11-19 | Spain | Castilla - La Mancha | 601910 | 7946 | 0 | 39.2796 | -3.0977 | 2022-11-20 04:21:08 | Castilla - La Mancha, Spain | |||
1755595 | 1755595 | 2022-11-18 | Spain | Castilla - La Mancha | 601910 | 7946 | 0 | 39.2796 | -3.0977 | 2022-11-19 04:21:14 | Castilla - La Mancha, Spain | |||
1161417 | 1161417 | 2022-08-18 | Russia | Samara Oblast | 394958 | 7946 | 0 | 53.2128813 | 50.8914633 | 2022-08-19 04:20:54 | Samara Oblast, Russia | |||
2832919 | 2832919 | 2022-01-22 | Mexico | Hidalgo | 71702 | 7946 | 0 | 20.0911 | -98.7624 | 2022-01-23 04:21:13 | Hidalgo, Mexico | |||
3425037 | 3425037 | 2022-01-21 | Mexico | Hidalgo | 71702 | 7946 | 0 | 20.0911 | -98.7624 | 2022-01-22 04:21:13 | Hidalgo, Mexico | |||
582495 | 582495 | 2021-07-13 | United Kingdom | Wales | 226428 | 7946 | 0 | 220848 | 52.1307 | -3.7837 | 2021-07-14 04:21:35 | Wales, United Kingdom | ||
1568268 | 1568268 | 2021-04-22 | Peru | La Libertad | 62393 | 7946 | 0 | 54447 | -7.92139 | -78.370238 | 2021-04-23 04:20:52 | La Libertad, Peru | ||
182323 | 182323 | 2021-02-21 | Spain | Andalusia | 468648 | 7946 | 10671 | 450031 | 37.5443 | -4.7278 | 2021-02-22 05:24:21 | Andalusia, Spain | ||
742597 | 742597 | 2021-02-20 | Spain | Andalusia | 468648 | 7946 | 10671 | 450031 | 37.5443 | -4.7278 | 2021-02-21 05:24:33 | Andalusia, Spain | ||
471695 | 471695 | 2021-02-19 | Spain | Andalusia | 468648 | 7946 | 10671 | 450031 | 37.5443 | -4.7278 | 2021-02-20 05:22:51 | Andalusia, Spain | ||
1523270 | 1523270 | 2020-08-28 | Mexico | Mexico | 66875 | 7946 | 55069 | 3860 | 19.4969 | -99.7233 | 2020-08-29 04:28:19 | Mexico, Mexico | ||
1920437 | 1920437 | 2020-08-10 | Chile | Metropolitana | 262647 | 7946 | 248524 | 6177 | -33.4376 | -70.6505 | 2020-08-11 04:35:08 | Metropolitana, Chile | ||
458404 | 458404 | 2020-08-07 | Brazil | Ceara | 186563 | 7946 | 156854 | 20634 | -5.4984 | -39.3206 | 2020-08-08 04:34:53 | Ceara, Brazil |
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]);