johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6 rows where country_or_region = "Russia", deaths = 36 and province_or_state = "Karachay-Cherkess Republic" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
860881 | 860881 | 2020-12-11 | Russia | Karachay-Cherkess Republic | 13274 | 36 | 11692 | 1546 | 43.7368326 | 41.7267991 | 2020-12-12 05:26:19 | Karachay-Cherkess Republic, Russia | ||
1600423 | 1600423 | 2020-12-10 | Russia | Karachay-Cherkess Republic | 13176 | 36 | 11495 | 1645 | 43.7368326 | 41.7267991 | 2020-12-11 05:26:59 | Karachay-Cherkess Republic, Russia | ||
2975432 | 2975432 | 2020-12-09 | Russia | Karachay-Cherkess Republic | 13081 | 36 | 11274 | 1771 | 43.7368326 | 41.7267991 | 2020-12-10 05:26:19 | Karachay-Cherkess Republic, Russia | ||
1818992 | 1818992 | 2020-12-08 | Russia | Karachay-Cherkess Republic | 12984 | 36 | 11038 | 1910 | 43.7368326 | 41.7267991 | 2020-12-09 05:28:01 | Karachay-Cherkess Republic, Russia | ||
2347628 | 2347628 | 2020-12-07 | Russia | Karachay-Cherkess Republic | 12885 | 36 | 10790 | 2059 | 43.7368326 | 41.7267991 | 2020-12-08 05:27:42 | Karachay-Cherkess Republic, Russia | ||
1006498 | 1006498 | 2020-12-06 | Russia | Karachay-Cherkess Republic | 12789 | 36 | 10544 | 2209 | 43.7368326 | 41.7267991 | 2020-12-07 05:26:14 | Karachay-Cherkess Republic, Russia |
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]);