johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where country_or_region = "Russia" and deaths = 667 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1802960 | 1802960 | 2021-11-25 | Russia | Kirov Oblast | 70326 | 667 | 0 | 57.9665589 | 49.4074599 | 2021-11-26 04:22:33 | Kirov Oblast, Russia | |||
495858 | 495858 | 2021-11-06 | Russia | Kalmykia Republic | 32605 | 667 | 0 | 46.2313018 | 45.3275745 | 2021-11-07 04:21:53 | Kalmykia Republic, Russia | |||
654221 | 654221 | 2021-10-22 | Russia | Mari El Republic | 21391 | 667 | 0 | 56.576750399999995 | 47.881751200000004 | 2021-10-23 04:21:32 | Mari El Republic, Russia | |||
2044046 | 2044046 | 2021-10-18 | Russia | Chechen Republic | 23910 | 667 | 0 | 43.39761470000001 | 45.6985005 | 2021-10-19 04:20:54 | Chechen Republic, Russia | |||
2044083 | 2044083 | 2021-10-18 | Russia | North Ossetia - Alania Republic | 24307 | 667 | 0 | 42.79336110000001 | 44.6324493 | 2021-10-19 04:20:54 | North Ossetia - Alania Republic, Russia | |||
3007544 | 3007544 | 2021-10-11 | Russia | Karachay-Cherkess Republic | 26083 | 667 | 0 | 43.7368326 | 41.7267991 | 2021-10-12 04:21:09 | Karachay-Cherkess Republic, Russia | |||
2618259 | 2618259 | 2021-09-17 | Russia | Kurgan Oblast | 31818 | 667 | 0 | 55.7655302 | 64.5632681 | 2021-09-18 04:21:24 | Kurgan Oblast, Russia | |||
511909 | 511909 | 2021-08-19 | Russia | Khabarovsk Krai | 71454 | 667 | 0 | 51.6312684 | 136.121524 | 2021-08-20 04:21:33 | Khabarovsk Krai, Russia | |||
296224 | 296224 | 2021-07-15 | Russia | Khakassia Republic | 27445 | 667 | 24010 | 2768 | 53.72258845 | 91.44293627 | 2021-07-16 04:21:22 | Khakassia Republic, Russia | ||
579041 | 579041 | 2021-07-13 | Russia | Karelia Republic | 52568 | 667 | 49191 | 2710 | 62.61940309999999 | 33.4920267 | 2021-07-14 04:21:35 | Karelia Republic, Russia | ||
1708544 | 1708544 | 2021-06-02 | Russia | Orel Oblast | 35751 | 667 | 33974 | 1110 | 52.96854329999999 | 36.0692477 | 2021-06-03 04:23:32 | Orel Oblast, Russia | ||
20634 | 20634 | 2021-05-28 | Russia | Zabaykalsky Krai | 43092 | 667 | 41627 | 798 | 52.248521 | 115.956325 | 2021-05-29 04:20:41 | Zabaykalsky Krai, Russia | ||
1798875 | 1798875 | 2021-03-23 | Russia | Primorsky Krai | 41922 | 667 | 37613 | 3642 | 45.0819456 | 134.726645 | 2021-03-24 05:25:40 | Primorsky Krai, Russia | ||
352541 | 352541 | 2021-03-11 | Russia | Smolensk Oblast | 26976 | 667 | 25840 | 469 | 55.03434960000001 | 33.0192065 | 2021-03-12 05:26:50 | Smolensk 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]);