johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10 rows where recovered = 1925 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- Ukraine 2
- Armenia 1
- China 1
- Colombia 1
- Lithuania 1
- Moldova 1
- Russia 1
- Saint Vincent and the Grenadines 1
- Saudi Arabia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2911442 | 2911442 | 2021-06-17 | Saint Vincent and the Grenadines | 2178 | 12 | 1925 | 241 | 12.9843 | -61.2872 | 2021-06-18 04:22:16 | Saint Vincent and the Grenadines | |||
3169442 | 3169442 | 2020-11-16 | China | Guangdong | 1971 | 8 | 1925 | 38 | 23.3417 | 113.4244 | 2020-11-17 05:25:54 | Guangdong, China | ||
2517797 | 2517797 | 2020-10-03 | Ukraine | Sumy Oblast | 4908 | 77 | 1925 | 2906 | 50.9077 | 34.7981 | 2020-10-04 04:23:44 | Sumy Oblast, Ukraine | ||
1523246 | 1523246 | 2020-08-28 | Lithuania | 2776 | 69 | 1925 | 810 | 55.1694 | 23.8813 | 2020-08-29 04:28:19 | Lithuania | |||
177080 | 177080 | 2020-07-27 | Colombia | Choco | 2861 | 95 | 1925 | 841 | 5.2528 | -76.82600000000002 | 2020-07-28 04:58:43 | Choco, Colombia | ||
122118 | 122118 | 2020-07-19 | Russia | Tomsk Oblast | 3435 | 26 | 1925 | 1484 | 58.6124279 | 82.04753149999998 | 2020-07-20 05:34:40 | Tomsk Oblast, Russia | ||
2158704 | 2158704 | 2020-07-14 | Ukraine | Kiev Oblast | 3090 | 58 | 1925 | 1107 | 50.053000000000004 | 30.7667 | 2020-07-15 04:34:39 | Kiev Oblast, Ukraine | ||
3416378 | 3416378 | 2020-05-17 | Armenia | 4472 | 60 | 1925 | 2487 | 40.0691 | 45.0382 | 2020-05-18 02:32:21 | Armenia | |||
2899261 | 2899261 | 2020-05-09 | Moldova | 4867 | 161 | 1925 | 2781 | 47.4116 | 28.3699 | 2020-05-10 02:32:30 | Moldova | |||
2524953 | 2524953 | 2020-04-23 | Saudi Arabia | 13930 | 121 | 1925 | 11884 | 23.885942 | 45.079162 | 2020-04-24 03:30:31 | Saudi Arabia |
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]);