johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where country_or_region = "Russia", deaths = 1441 and province_or_state = "Kurgan Oblast" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2789256 | 2789256 | 2022-07-10 | Russia | Kurgan Oblast | 105263 | 1441 | 0 | 55.7655302 | 64.5632681 | 2022-07-11 04:20:46 | Kurgan Oblast, Russia | |||
142209 | 142209 | 2022-07-09 | Russia | Kurgan Oblast | 105250 | 1441 | 0 | 55.7655302 | 64.5632681 | 2022-07-10 04:20:54 | Kurgan Oblast, Russia | |||
1417309 | 1417309 | 2022-07-08 | Russia | Kurgan Oblast | 105235 | 1441 | 0 | 55.7655302 | 64.5632681 | 2022-07-09 04:20:59 | Kurgan Oblast, Russia | |||
2741234 | 2741234 | 2022-07-07 | Russia | Kurgan Oblast | 105221 | 1441 | 0 | 55.7655302 | 64.5632681 | 2022-07-08 04:20:56 | Kurgan Oblast, Russia | |||
1200029 | 1200029 | 2022-07-06 | Russia | Kurgan Oblast | 105205 | 1441 | 0 | 55.7655302 | 64.5632681 | 2022-07-07 04:20:55 | Kurgan Oblast, Russia | |||
3966772 | 3966772 | 2022-07-05 | Russia | Kurgan Oblast | 105191 | 1441 | 0 | 55.7655302 | 64.5632681 | 2022-07-06 04:20:58 | Kurgan Oblast, Russia | |||
3078283 | 3078283 | 2022-07-04 | Russia | Kurgan Oblast | 105178 | 1441 | 0 | 55.7655302 | 64.5632681 | 2022-07-05 04:20:45 | Kurgan Oblast, Russia | |||
1767565 | 1767565 | 2022-07-03 | Russia | Kurgan Oblast | 105166 | 1441 | 0 | 55.7655302 | 64.5632681 | 2022-07-04 04:20:54 | Kurgan Oblast, Russia | |||
3365551 | 3365551 | 2022-07-02 | Russia | Kurgan Oblast | 105152 | 1441 | 0 | 55.7655302 | 64.5632681 | 2022-07-03 04:20:59 | Kurgan Oblast, Russia | |||
593880 | 593880 | 2022-07-01 | Russia | Kurgan Oblast | 105137 | 1441 | 0 | 55.7655302 | 64.5632681 | 2022-07-02 04:21:16 | Kurgan Oblast, Russia | |||
3940281 | 3940281 | 2022-06-30 | Russia | Kurgan Oblast | 105121 | 1441 | 0 | 55.7655302 | 64.5632681 | 2022-07-01 04:21:10 | Kurgan Oblast, Russia | |||
2490239 | 2490239 | 2022-06-29 | Russia | Kurgan Oblast | 105106 | 1441 | 0 | 55.7655302 | 64.5632681 | 2022-06-30 04:21:01 | Kurgan Oblast, Russia | |||
2239621 | 2239621 | 2022-06-28 | Russia | Kurgan Oblast | 105090 | 1441 | 0 | 55.7655302 | 64.5632681 | 2022-06-29 04:20:59 | Kurgan 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]);