johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where deaths = 5417 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 7
- US 7
- Mexico 3
- Germany 2
- Ukraine 2
- Costa Rica 1
- Peru 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1098695 | 1098695 | 2022-08-03 | US | California | San Diego | 6073 | 954080 | 5417 | 0 | 33.03484597 | -116.7365326 | 2022-08-04 04:20:58 | San Diego, California, US | |
1405620 | 1405620 | 2022-08-02 | US | California | San Diego | 6073 | 954080 | 5417 | 0 | 33.03484597 | -116.7365326 | 2022-08-03 04:20:59 | San Diego, California, US | |
3966455 | 3966455 | 2022-07-05 | Germany | Sachsen-Anhalt | 749756 | 5417 | 0 | 51.9503 | 11.6923 | 2022-07-06 04:20:58 | Sachsen-Anhalt, Germany | |||
1539853 | 1539853 | 2022-03-31 | Germany | Brandenburg | 685976 | 5417 | 0 | 52.4125 | 12.5316 | 2022-04-01 04:20:28 | Brandenburg, Germany | |||
3240578 | 3240578 | 2022-03-21 | US | New York | New York | 36061 | 407976 | 5417 | 0 | 40.76727260000001 | -73.97152637 | 2022-03-22 04:20:54 | New York, New York, US | |
26651 | 26651 | 2022-03-20 | US | New York | New York | 36061 | 407791 | 5417 | 0 | 40.76727260000001 | -73.97152637 | 2022-03-21 04:20:50 | New York, New York, US | |
1658661 | 1658661 | 2022-03-19 | US | New York | New York | 36061 | 407429 | 5417 | 0 | 40.76727260000001 | -73.97152637 | 2022-03-20 04:20:45 | New York, New York, US | |
338187 | 338187 | 2022-03-18 | US | New York | New York | 36061 | 406997 | 5417 | 0 | 40.76727260000001 | -73.97152637 | 2022-03-19 04:20:47 | New York, New York, US | |
3691130 | 3691130 | 2022-01-13 | Ukraine | Zaporizhia Oblast | 183499 | 5417 | 0 | 47.8388 | 35.1396 | 2022-01-14 04:21:54 | Zaporizhia Oblast, Ukraine | |||
3073660 | 3073660 | 2021-11-23 | Ukraine | Kharkiv Oblast | 231547 | 5417 | 0 | 49.9935 | 36.2304 | 2021-11-24 04:22:14 | Kharkiv Oblast, Ukraine | |||
682436 | 682436 | 2021-10-24 | Mexico | Oaxaca | 81025 | 5417 | 0 | 17.0732 | -96.7266 | 2021-10-25 04:22:31 | Oaxaca, Mexico | |||
770444 | 770444 | 2021-10-23 | Mexico | Oaxaca | 81025 | 5417 | 0 | 17.0732 | -96.7266 | 2021-10-24 04:21:22 | Oaxaca, Mexico | |||
1263359 | 1263359 | 2021-09-09 | US | California | San Bernardino | 6071 | 341390 | 5417 | 0 | 34.84060306 | -116.1774685 | 2021-09-10 04:21:20 | San Bernardino, California, US | |
1596076 | 1596076 | 2021-08-26 | Costa Rica | 452997 | 5417 | 0 | 9.7489 | -83.7534 | 2021-08-27 04:21:37 | Costa Rica | ||||
2371613 | 2371613 | 2021-07-20 | Mexico | Tamaulipas | 70115 | 5417 | 0 | 64698 | 24.2669 | -98.8363 | 2021-07-21 04:21:40 | Tamaulipas, Mexico | ||
126356 | 126356 | 2020-11-18 | United Kingdom | Scotland | 84523 | 5417 | 0 | 81146 | 56.4907 | -4.2026 | 2020-11-19 05:25:23 | Scotland, United Kingdom | ||
1026518 | 1026518 | 2020-10-17 | Peru | Piura | 37168 | 5417 | 0 | 31751 | -5.133361 | -80.335861 | 2020-10-18 04:24:25 | Piura, Peru |
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]);