johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16 rows where recovered = 2424 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 8
- Liechtenstein 3
- Ukraine 3
- Colombia 2
- Japan 2
- New Zealand 2
- Russia 2
- Italy 1
- Malaysia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2586022 | 2586022 | 2021-06-05 | Japan | Saga | 2528 | 21 | 2424 | 83 | 33.286977 | 130.115738 | 2021-06-06 04:24:03 | Saga, Japan | ||
3003438 | 3003438 | 2021-04-06 | New Zealand | 2531 | 28 | 2424 | 81 | -40.9006 | 174.886 | 2021-04-07 04:20:53 | New Zealand | |||
3085433 | 3085433 | 2021-04-05 | New Zealand | 2524 | 28 | 2424 | 74 | -40.9006 | 174.886 | 2021-04-06 04:20:32 | New Zealand | |||
1672519 | 1672519 | 2021-02-07 | Liechtenstein | 2595 | 53 | 2424 | 118 | 47.14 | 9.55 | 2021-02-08 05:22:39 | Liechtenstein | |||
974980 | 974980 | 2021-02-06 | Liechtenstein | 2591 | 53 | 2424 | 114 | 47.14 | 9.55 | 2021-02-07 05:23:00 | Liechtenstein | |||
1588238 | 1588238 | 2021-02-05 | Liechtenstein | 2588 | 53 | 2424 | 111 | 47.14 | 9.55 | 2021-02-06 05:23:55 | Liechtenstein | |||
82695 | 82695 | 2020-10-14 | Ukraine | Cherkasy Oblast | 6047 | 66 | 2424 | 3557 | 49.4444 | 32.0598 | 2020-10-15 04:24:28 | Cherkasy Oblast, Ukraine | ||
2653781 | 2653781 | 2020-09-23 | Japan | Hyogo | 2616 | 57 | 2424 | 135 | 35.039913 | 134.828057 | 2020-09-24 04:23:00 | Hyogo, Japan | ||
2458392 | 2458392 | 2020-09-19 | Ukraine | Odessa Oblast | 11205 | 160 | 2424 | 8621 | 46.4846 | 30.7326 | 2020-09-20 04:22:00 | Odessa Oblast, Ukraine | ||
2852461 | 2852461 | 2020-09-18 | Ukraine | Odessa Oblast | 10924 | 158 | 2424 | 8342 | 46.4846 | 30.7326 | 2020-09-19 04:22:00 | Odessa Oblast, Ukraine | ||
1523393 | 1523393 | 2020-08-28 | Russia | Kostroma Oblast | 3429 | 40 | 2424 | 965 | 58.424756 | 44.2533273 | 2020-08-29 04:28:19 | Kostroma Oblast, Russia | ||
2510035 | 2510035 | 2020-08-27 | Colombia | Huila | 4303 | 109 | 2424 | 1770 | 2.5359 | -75.5277 | 2020-08-28 04:28:11 | Huila, Colombia | ||
3562557 | 3562557 | 2020-08-25 | Italy | P.A. Bolzano | 2893 | 292 | 2424 | 177 | 46.49933453 | 11.35662422 | 2020-08-26 04:28:11 | P.A. Bolzano, Italy | ||
1503255 | 1503255 | 2020-07-25 | Malaysia | W.P. Kuala Lumpur | 2454 | 18 | 2424 | 12 | 3.139 | 101.6869 | 2020-07-26 04:35:00 | W.P. Kuala Lumpur, Malaysia | ||
1691376 | 1691376 | 2020-06-19 | Russia | Chuvashia Republic | 4401 | 21 | 2424 | 1956 | 55.4259922 | 47.0849429 | 2020-06-20 04:33:19 | Chuvashia Republic, Russia | ||
114235 | 114235 | 2020-05-08 | Colombia | 10051 | 428 | 2424 | 7199 | 4.5709 | -74.2973 | 2020-05-09 02:32:35 | Colombia |
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]);