johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where recovered = 2283 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- Canada 2
- China 2
- Japan 2
- Russia 2
- Italy 1
- Mexico 1
- Sao Tome and Principe 1
- Slovenia 1
- Ukraine 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3659362 | 3659362 | 2021-07-11 | Canada | New Brunswick | 2336 | 46 | 2283 | 7 | 46.5653 | -66.4619 | 2021-07-12 04:21:34 | New Brunswick, Canada | ||
625646 | 625646 | 2021-07-10 | Canada | New Brunswick | 2336 | 46 | 2283 | 7 | 46.5653 | -66.4619 | 2021-07-11 04:21:43 | New Brunswick, Canada | ||
726768 | 726768 | 2021-05-22 | Sao Tome and Principe | 2338 | 36 | 2283 | 19 | 0.1864 | 6.6131 | 2021-05-23 04:20:51 | Sao Tome and Principe | |||
1872973 | 1872973 | 2021-05-15 | Japan | Kagoshima | 2842 | 28 | 2283 | 531 | 31.009484000000004 | 130.430665 | 2021-05-16 04:20:49 | Kagoshima, Japan | ||
1636119 | 1636119 | 2021-04-29 | China | Guangdong | 2337 | 8 | 2283 | 46 | 23.3417 | 113.4244 | 2021-04-30 04:21:03 | Guangdong, China | ||
3393198 | 3393198 | 2021-04-28 | China | Guangdong | 2335 | 8 | 2283 | 44 | 23.3417 | 113.4244 | 2021-04-29 04:20:55 | Guangdong, China | ||
40087 | 40087 | 2021-04-12 | United Kingdom | Turks and Caicos Islands | 2357 | 17 | 2283 | 57 | 21.694000000000006 | -71.7979 | 2021-04-13 04:20:37 | Turks and Caicos Islands, United Kingdom | ||
998475 | 998475 | 2021-03-01 | Japan | Shiga | 2470 | 47 | 2283 | 140 | 35.21582700000001 | 136.138064 | 2021-03-02 05:23:30 | Shiga, Japan | ||
2938856 | 2938856 | 2020-11-28 | Ukraine | Kirovohrad Oblast | 4941 | 153 | 2283 | 2505 | 48.5079 | 32.2623 | 2020-11-29 05:25:55 | Kirovohrad Oblast, Ukraine | ||
3932301 | 3932301 | 2020-08-30 | Slovenia | 2865 | 133 | 2283 | 449 | 46.1512 | 14.9955 | 2020-08-31 04:28:27 | Slovenia | |||
1502992 | 1502992 | 2020-07-25 | Russia | Tomsk Oblast | 3821 | 29 | 2283 | 1509 | 58.6124279 | 82.04753149999998 | 2020-07-26 04:35:00 | Tomsk Oblast, Russia | ||
2633097 | 2633097 | 2020-06-29 | Russia | Smolensk Oblast | 4544 | 65 | 2283 | 2196 | 55.03434960000001 | 33.0192065 | 2020-06-30 04:33:48 | Smolensk Oblast, Russia | ||
3638958 | 3638958 | 2020-05-30 | Mexico | Sinaloa | 3261 | 488 | 2283 | 490 | 25.1721 | -107.4795 | 2020-05-31 02:32:45 | Sinaloa, Mexico | ||
2390134 | 2390134 | 2020-05-19 | Italy | Friuli Venezia Giulia | 3203 | 320 | 2283 | 600 | 45.6494354 | 13.76813649 | 2020-05-20 02:32:19 | Friuli Venezia Giulia, Italy |
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]);