johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where recovered = 1219 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- China 3
- Japan 3
- Italy 2
- Colombia 1
- Cote d'Ivoire 1
- India 1
- Kyrgyzstan 1
- Liberia 1
- Mexico 1
- Niger 1
- Sierra Leone 1
- Togo 1
- Uruguay 1
- Yemen 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2426910 | 2426910 | 2021-01-23 | Japan | Fukushima | 1585 | 35 | 1219 | 331 | 37.378867 | 140.223295 | 2021-01-24 05:22:35 | Fukushima, Japan | ||
1093935 | 1093935 | 2021-01-20 | Colombia | Guainia | 1252 | 20 | 1219 | 13 | 2.5854 | -68.5247 | 2021-01-21 05:22:01 | Guainia, Colombia | ||
3515439 | 3515439 | 2021-01-15 | Japan | Shiga | 1698 | 18 | 1219 | 461 | 35.21582700000001 | 136.138064 | 2021-01-16 05:22:40 | Shiga, Japan | ||
1751295 | 1751295 | 2020-12-14 | Japan | Nara | 1475 | 15 | 1219 | 241 | 34.317451 | 135.871644 | 2020-12-15 05:26:38 | Nara, Japan | ||
2537529 | 2537529 | 2020-12-01 | Niger | 1586 | 75 | 1219 | 292 | 17.607789 | 8.081666 | 2020-12-02 05:27:41 | Niger | |||
122692 | 122692 | 2020-11-18 | Italy | Molise | 3366 | 80 | 1219 | 2067 | 41.55774754 | 14.65916051 | 2020-11-19 05:25:23 | Molise, Italy | ||
2653829 | 2653829 | 2020-09-23 | Liberia | 1336 | 82 | 1219 | 35 | 6.428055 | -9.429499 | 2020-09-24 04:23:00 | Liberia | |||
2732657 | 2732657 | 2020-09-15 | Yemen | 2016 | 583 | 1219 | 214 | 15.552727 | 48.516388 | 2020-09-16 04:22:53 | Yemen | |||
2729333 | 2729333 | 2020-09-15 | Togo | 1595 | 40 | 1219 | 336 | 8.6195 | 0.8248 | 2020-09-16 04:22:53 | Togo | |||
3181650 | 3181650 | 2020-08-18 | Uruguay | 1485 | 40 | 1219 | 226 | -32.5228 | -55.7658 | 2020-08-19 04:27:00 | Uruguay | |||
2709013 | 2709013 | 2020-07-17 | Sierra Leone | 1688 | 65 | 1219 | 404 | 8.460555000000001 | -11.779889 | 2020-07-18 04:34:45 | Sierra Leone | |||
2685102 | 2685102 | 2020-07-06 | India | Tripura | 1680 | 1 | 1219 | 460 | 23.746782999999997 | 91.743565 | 2020-07-07 04:34:00 | Tripura, India | ||
2974600 | 2974600 | 2020-06-30 | Italy | Sardegna | 1366 | 133 | 1219 | 14 | 39.21531192 | 9.110616306 | 2020-07-01 04:33:52 | Sardegna, Italy | ||
3249466 | 3249466 | 2020-06-21 | Mexico | Queretaro | 1713 | 227 | 1219 | 267 | 20.5888 | -100.3899 | 2020-06-22 04:33:20 | Queretaro, Mexico | ||
2556132 | 2556132 | 2020-06-02 | Kyrgyzstan | 1845 | 17 | 1219 | 609 | 41.20438 | 74.766098 | 2020-06-03 02:33:13 | Kyrgyzstan | |||
875756 | 875756 | 2020-05-24 | Cote d'Ivoire | 2376 | 30 | 1219 | 1127 | 7.54 | -5.5471 | 2020-05-25 02:32:44 | Cote d'Ivoire | |||
2910620 | 2910620 | 2020-03-22 | China | Zhejiang | 1237 | 1 | 1219 | 17 | 29.1832 | 120.0934 | 3/22/20 7:20 | Zhejiang, China | ||
339645 | 339645 | 2020-03-21 | China | Zhejiang | 1236 | 1 | 1219 | 29.1832 | 120.0934 | 2020-03-21T03:43:03 | ||||
3733939 | 3733939 | 2020-03-20 | China | Zhejiang | 1234 | 1 | 1219 | 29.1832 | 120.0934 | 2020-03-20T02:43:09 |
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]);