johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where country_or_region = "Russia" and deaths = 1107 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 9
country_or_region 1
- Russia · 9 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
979181 | 979181 | 2022-02-01 | Russia | North Ossetia - Alania Republic | 33879 | 1107 | 0 | 42.79336110000001 | 44.6324493 | 2022-02-02 04:21:09 | North Ossetia - Alania Republic, Russia | |||
2777211 | 2777211 | 2021-12-31 | Russia | Kostroma Oblast | 48636 | 1107 | 0 | 58.424756 | 44.253327299999995 | 2022-01-01 04:22:14 | Kostroma Oblast, Russia | |||
686610 | 686610 | 2021-11-13 | Russia | Tatarstan Republic | 33654 | 1107 | 0 | 55.7648572 | 52.43104273 | 2021-11-14 04:21:31 | Tatarstan Republic, Russia | |||
3904162 | 3904162 | 2021-07-31 | Russia | Astrakhan Oblast | 43388 | 1107 | 36524 | 5757 | 47.1878186 | 47.608851 | 2021-08-01 04:21:50 | Astrakhan Oblast, Russia | ||
3706340 | 3706340 | 2021-07-17 | Russia | Komi Republic | 51257 | 1107 | 46215 | 3935 | 63.9881421 | 54.3326073 | 2021-07-18 04:22:07 | Komi Republic, Russia | ||
1165405 | 1165405 | 2021-07-04 | Russia | Penza Oblast | 50369 | 1107 | 45587 | 3675 | 53.1655415 | 44.78791810000001 | 2021-07-05 04:21:28 | Penza Oblast, Russia | ||
2586248 | 2586248 | 2021-06-05 | Russia | Vologda Oblast | 46327 | 1107 | 43168 | 2052 | 60.0391461 | 43.1215213 | 2021-06-06 04:24:03 | Vologda Oblast, Russia | ||
380451 | 380451 | 2021-04-30 | Russia | Volgograd Oblast | 56888 | 1107 | 54354 | 1427 | 49.6048339 | 44.29035820000001 | 2021-05-01 04:20:47 | Volgograd Oblast, Russia | ||
1302295 | 1302295 | 2021-04-01 | Russia | Samara Oblast | 55930 | 1107 | 52644 | 2179 | 53.2128813 | 50.8914633 | 2021-04-02 04:20:36 | Samara Oblast, 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]);