johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where country_or_region = "Russia" and deaths = 1989 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 9
country_or_region 1
- Russia · 14 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3285108 | 3285108 | 2022-10-31 | Russia | Kaliningrad Oblast | 190179 | 1989 | 0 | 54.7293041 | 21.1489473 | 2022-11-01 04:22:36 | Kaliningrad Oblast, Russia | |||
2533651 | 2533651 | 2022-05-12 | Russia | Tatarstan Republic | 147025 | 1989 | 0 | 55.7648572 | 52.43104273 | 2022-05-13 04:20:51 | Tatarstan Republic, Russia | |||
3445097 | 3445097 | 2022-05-11 | Russia | Tatarstan Republic | 146836 | 1989 | 0 | 55.7648572 | 52.43104273 | 2022-05-12 04:20:54 | Tatarstan Republic, Russia | |||
3535714 | 3535714 | 2022-05-10 | Russia | Tatarstan Republic | 146643 | 1989 | 0 | 55.7648572 | 52.43104273 | 2022-05-11 04:20:48 | Tatarstan Republic, Russia | |||
222249 | 222249 | 2022-05-09 | Russia | Tatarstan Republic | 146448 | 1989 | 0 | 55.7648572 | 52.43104273 | 2022-05-10 04:20:50 | Tatarstan Republic, Russia | |||
2331634 | 2331634 | 2022-05-08 | Russia | Tatarstan Republic | 146253 | 1989 | 0 | 55.7648572 | 52.43104273 | 2022-05-09 04:20:54 | Tatarstan Republic, Russia | |||
2777208 | 2777208 | 2021-12-31 | Russia | Khanty-Mansi Autonomous Okrug | 95861 | 1989 | 0 | 61.0259025 | 69.0982628 | 2022-01-01 04:22:14 | Khanty-Mansi Autonomous Okrug, Russia | |||
987240 | 987240 | 2021-10-04 | Russia | Vladimir Oblast | 55114 | 1989 | 0 | 56.0503336 | 40.656163299999996 | 2021-10-05 04:21:27 | Vladimir Oblast, Russia | |||
1274550 | 1274550 | 2021-10-03 | Russia | Vladimir Oblast | 54891 | 1989 | 0 | 56.0503336 | 40.656163299999996 | 2021-10-04 04:21:31 | Vladimir Oblast, Russia | |||
3892128 | 3892128 | 2021-08-29 | Russia | Chuvashia Republic | 31535 | 1989 | 0 | 55.4259922 | 47.0849429 | 2021-08-30 04:21:23 | Chuvashia Republic, Russia | |||
3331751 | 3331751 | 2021-07-21 | Russia | Leningrad Oblast | 53657 | 1989 | 46395 | 5273 | 60.1853296 | 32.3925325 | 2021-07-22 04:21:19 | Leningrad Oblast, Russia | ||
3667882 | 3667882 | 2021-03-06 | Russia | Voronezh Oblast | 69574 | 1989 | 63678 | 3907 | 50.9800393 | 40.15065070000001 | 2021-03-07 05:21:54 | Voronezh Oblast, Russia | ||
2482217 | 2482217 | 2021-01-28 | Russia | Sverdlovsk Oblast | 69399 | 1989 | 61948 | 5462 | 58.6414755 | 61.8021546 | 2021-01-29 05:22:23 | Sverdlovsk Oblast, Russia | ||
2467032 | 2467032 | 2021-01-22 | Russia | Nizhny Novgorod Oblast | 80161 | 1989 | 72420 | 5752 | 55.47180329999999 | 44.0911594 | 2021-01-23 05:22:03 | Nizhny Novgorod 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]);