johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where recovered = 1946 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2649419 | 2649419 | 2021-04-08 | Yemen | 5133 | 1004 | 1946 | 2183 | 15.552727 | 48.516388 | 2021-04-09 04:21:13 | Yemen | |||
1094121 | 1094121 | 2021-01-20 | Japan | Port Quarantine | 2108 | 1 | 1946 | 161 | 2021-01-21 05:22:01 | Port Quarantine, Japan | ||||
2625720 | 2625720 | 2021-01-10 | Colombia | Guaviare | 2027 | 37 | 1946 | 44 | 1.0654 | -73.2603 | 2021-01-11 05:21:50 | Guaviare, Colombia | ||
272152 | 272152 | 2020-11-10 | Italy | Valle d'Aosta | 4463 | 218 | 1946 | 2299 | 45.73750286 | 7.320149366 | 2020-11-11 05:25:30 | Valle d'Aosta, Italy | ||
1026131 | 1026131 | 2020-10-17 | Canada | Saskatchewan | 2306 | 25 | 1946 | 299 | 52.9399 | -106.4509 | 2020-10-18 04:24:25 | Saskatchewan, Canada | ||
2856626 | 2856626 | 2020-10-16 | Canada | Saskatchewan | 2270 | 25 | 1946 | 299 | 52.9399 | -106.4509 | 2020-10-17 04:24:12 | Saskatchewan, Canada | ||
3932089 | 3932089 | 2020-08-30 | Lithuania | 2848 | 69 | 1946 | 853 | 55.1694 | 23.8813 | 2020-08-31 04:28:27 | Lithuania | |||
2991207 | 2991207 | 2020-08-24 | Iceland | 2073 | 10 | 1946 | 117 | 64.9631 | -19.0208 | 2020-08-25 04:28:02 | Iceland | |||
98692 | 98692 | 2020-08-04 | Mali | 2543 | 124 | 1946 | 473 | 17.570692 | -3.996166000000001 | 2020-08-05 04:34:43 | Mali | |||
177475 | 177475 | 2020-07-27 | Ukraine | Vinnytsia Oblast | 2589 | 46 | 1946 | 597 | 49.2331 | 28.4682 | 2020-07-28 04:58:43 | Vinnytsia Oblast, Ukraine | ||
442788 | 442788 | 2020-07-26 | Ukraine | Vinnytsia Oblast | 2549 | 46 | 1946 | 557 | 49.2331 | 28.4682 | 2020-07-27 04:35:02 | Vinnytsia Oblast, Ukraine | ||
2708500 | 2708500 | 2020-07-17 | India | Goa | 3304 | 21 | 1946 | 1337 | 15.359682000000001 | 74.057396 | 2020-07-18 04:34:45 | Goa, India | ||
3737901 | 3737901 | 2020-07-12 | Albania | 3454 | 93 | 1946 | 1415 | 41.1533 | 20.1683 | 2020-07-13 04:43:04 | Albania | |||
887684 | 887684 | 2020-07-07 | Kosovo | 3703 | 79 | 1946 | 1678 | 42.602636 | 20.902977 | 2020-07-08 05:33:48 | Kosovo | |||
302837 | 302837 | 2020-07-01 | Colombia | Amazonas | 2299 | 90 | 1946 | 263 | -1.4429 | -71.5724 | 2020-07-02 04:33:46 | Amazonas, Colombia | ||
2701183 | 2701183 | 2020-06-24 | Malaysia | Selangor | 2033 | 24 | 1946 | 63 | 3.0738 | 101.5183 | 2020-06-25 05:26:54 | Selangor, Malaysia | ||
1522268 | 1522268 | 2020-06-23 | Mexico | Chihuahua | 2665 | 577 | 1946 | 142 | 28.63300000000001 | -106.0691 | 2020-06-24 04:33:28 | Chihuahua, Mexico | ||
1837117 | 1837117 | 2020-06-14 | Russia | Khanty-Mansi Autonomous Okrug | 4569 | 27 | 1946 | 2596 | 61.0259025 | 69.0982628 | 2020-06-15 03:33:14 | Khanty-Mansi Autonomous Okrug, Russia | ||
3261017 | 3261017 | 2020-05-18 | Croatia | 2228 | 95 | 1946 | 187 | 45.1 | 15.2 | 2020-05-19 02:32:18 | Croatia |
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]);