daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where deaths = 4214 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 11
- Mexico 3
- India 2
- United Kingdom 2
- Chile 1
- Colombia 1
- Dominican Republic 1
- El Salvador 1
- Honduras 1
- Serbia 1
- Slovenia 1
- Venezuela 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-08-08 | El Salvador | 190818 | 4214 | 0 | 13.7942 | -88.8965 | 2022-08-09 04:20:34 | El Salvador | ||||
2022-03-20 | Chile | Valparaiso | 289881 | 4214 | 0 | -33.0472 | -71.6127 | 2022-03-21 04:20:50 | Valparaiso, Chile | |||
2022-01-31 | United Kingdom | Northern Ireland | 542855 | 4214 | 0 | 54.7877 | -6.4923 | 2022-02-01 04:21:11 | Northern Ireland, United Kingdom | |||
2022-01-31 | Mexico | Quintana Roo | 84890 | 4214 | 0 | 19.1817 | -88.4791 | 2022-02-01 04:21:11 | Quintana Roo, Mexico | |||
2021-12-09 | Dominican Republic | 409490 | 4214 | 0 | 18.7357 | -70.1627 | 2021-12-10 04:22:28 | Dominican Republic | ||||
2021-09-14 | Venezuela | 348873 | 4214 | 0 | 6.4238 | -66.5897 | 2021-09-15 03:22:37 | Venezuela | ||||
2021-06-13 | Mexico | Tabasco | 71479 | 4214 | 0 | 67265 | 17.8409 | -92.6189 | 2021-06-14 04:22:46 | Tabasco, Mexico | ||
2021-04-26 | Slovenia | 237219 | 4214 | 222643 | 10362 | 46.1512 | 14.9955 | 2021-04-27 04:20:52 | Slovenia | |||
2021-03-03 | Honduras | 172100 | 4214 | 67239 | 100647 | 15.2 | -86.2419 | 2021-03-04 05:24:24 | Honduras | |||
2021-02-16 | Mexico | Tamaulipas | 50501 | 4214 | 0 | 46287 | 24.2669 | -98.8363 | 2021-02-17 05:23:10 | Tamaulipas, Mexico | ||
2021-02-13 | Serbia | 419493 | 4214 | 0 | 415279 | 44.0165 | 21.0059 | 2021-02-14 05:23:43 | Serbia | |||
2020-12-29 | Colombia | Valle del Cauca | 135455 | 4214 | 122990 | 8251 | 3.8009 | -76.6413 | 2020-12-30 05:22:34 | Valle del Cauca, Colombia | ||
2020-11-01 | India | Punjab | 133975 | 4214 | 125566 | 4195 | 30.841465000000003 | 75.40879 | 2020-11-02 05:25:04 | Punjab, India | ||
2020-08-17 | India | Delhi | 153367 | 4214 | 138301 | 10852 | 28.646519 | 77.10898 | 2020-08-18 04:27:56 | Delhi, India | ||
2020-08-03 | United Kingdom | Scotland | 18694 | 4214 | 0 | 16203 | 56.4907 | -4.2026 | 2020-08-04 04:41:59 | Scotland, United Kingdom |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;