johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where country_or_region = "Kyrgyzstan" and deaths = 1063 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, active, day (date), last_update (date)
country_or_region 1
- Kyrgyzstan · 17 ✖
province_or_state 0
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2582037 | 2582037 | 2020-09-27 | Kyrgyzstan | 46251 | 1063 | 42453 | 2735 | 41.20438 | 74.766098 | 2020-09-28 04:23:00 | Kyrgyzstan | |||
2614089 | 2614089 | 2020-09-26 | Kyrgyzstan | 46090 | 1063 | 42302 | 2725 | 41.20438 | 74.766098 | 2020-09-27 04:23:00 | Kyrgyzstan | |||
2812804 | 2812804 | 2020-09-25 | Kyrgyzstan | 45932 | 1063 | 42147 | 2722 | 41.20438 | 74.766098 | 2020-09-26 04:23:00 | Kyrgyzstan | |||
2606081 | 2606081 | 2020-09-24 | Kyrgyzstan | 45757 | 1063 | 42005 | 2689 | 41.20438 | 74.766098 | 2020-09-25 04:23:00 | Kyrgyzstan | |||
2653824 | 2653824 | 2020-09-23 | Kyrgyzstan | 45630 | 1063 | 41904 | 2663 | 41.20438 | 74.766098 | 2020-09-24 04:23:00 | Kyrgyzstan | |||
3316273 | 3316273 | 2020-09-22 | Kyrgyzstan | 45542 | 1063 | 41796 | 2683 | 41.20438 | 74.766098 | 2020-09-23 04:23:00 | Kyrgyzstan | |||
2836872 | 2836872 | 2020-09-21 | Kyrgyzstan | 45471 | 1063 | 41682 | 2726 | 41.20438 | 74.766098 | 2020-09-22 04:23:00 | Kyrgyzstan | |||
3093476 | 3093476 | 2020-09-20 | Kyrgyzstan | 45335 | 1063 | 41484 | 2788 | 41.20438 | 74.766098 | 2020-09-21 04:23:00 | Kyrgyzstan | |||
2454826 | 2454826 | 2020-09-19 | Kyrgyzstan | 45335 | 1063 | 41484 | 2788 | 41.20438 | 74.766098 | 2020-09-20 04:22:00 | Kyrgyzstan | |||
2848895 | 2848895 | 2020-09-18 | Kyrgyzstan | 45244 | 1063 | 41415 | 2766 | 41.20438 | 74.766098 | 2020-09-19 04:22:00 | Kyrgyzstan | |||
1121644 | 1121644 | 2020-09-17 | Kyrgyzstan | 45153 | 1063 | 41317 | 2773 | 41.20438 | 74.766098 | 2020-09-18 05:05:00 | Kyrgyzstan | |||
666333 | 666333 | 2020-09-16 | Kyrgyzstan | 45072 | 1063 | 41210 | 2799 | 41.20438 | 74.766098 | 2020-09-17 04:22:00 | Kyrgyzstan | |||
2729058 | 2729058 | 2020-09-15 | Kyrgyzstan | 44999 | 1063 | 41103 | 2833 | 41.20438 | 74.766098 | 2020-09-16 04:22:53 | Kyrgyzstan | |||
344330 | 344330 | 2020-09-14 | Kyrgyzstan | 44928 | 1063 | 41023 | 2842 | 41.20438 | 74.766098 | 2020-09-15 03:22:50 | Kyrgyzstan | |||
2868769 | 2868769 | 2020-09-13 | Kyrgyzstan | 44881 | 1063 | 40922 | 2896 | 41.20438 | 74.766098 | 2020-09-14 04:26:00 | Kyrgyzstan | |||
546808 | 546808 | 2020-09-12 | Kyrgyzstan | 44828 | 1063 | 40779 | 2986 | 41.20438 | 74.766098 | 2020-09-13 04:30:52 | Kyrgyzstan | |||
1444637 | 1444637 | 2020-09-11 | Kyrgyzstan | 44761 | 1063 | 40631 | 3067 | 41.20438 | 74.766098 | 2020-09-12 04:25:05 | Kyrgyzstan |
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]);