johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where recovered = 3647 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1440600 | 1440600 | 2021-07-07 | Japan | Kagoshima | 3712 | 39 | 3647 | 26 | 31.009484000000004 | 130.430665 | 2021-07-08 04:21:26 | Kagoshima, Japan | ||
1580175 | 1580175 | 2021-03-13 | Japan | Miyagi | 4047 | 25 | 3647 | 375 | 38.446859 | 140.927086 | 2021-03-14 05:25:37 | Miyagi, Japan | ||
1751173 | 1751173 | 2020-12-14 | Gambia | 3782 | 123 | 3647 | 12 | 13.4432 | -15.3101 | 2020-12-15 05:26:38 | Gambia | |||
3847693 | 3847693 | 2020-12-13 | Gambia | 3782 | 123 | 3647 | 12 | 13.4432 | -15.3101 | 2020-12-14 05:26:27 | Gambia | |||
75048 | 75048 | 2020-12-03 | India | Mizoram | 3888 | 6 | 3647 | 235 | 23.309381 | 92.83822 | 2020-12-04 05:27:27 | Mizoram, India | ||
1452292 | 1452292 | 2020-10-27 | Angola | 9871 | 271 | 3647 | 5953 | -11.2027 | 17.8739 | 2020-10-28 04:24:39 | Angola | |||
2585587 | 2585587 | 2020-09-27 | Uganda | 7530 | 73 | 3647 | 3810 | 1.373333 | 32.290275 | 2020-09-28 04:23:00 | Uganda | |||
2617639 | 2617639 | 2020-09-26 | Uganda | 7364 | 71 | 3647 | 3646 | 1.373333 | 32.290275 | 2020-09-27 04:23:00 | Uganda | |||
2614290 | 2614290 | 2020-09-26 | Russia | Vologda Oblast | 4435 | 46 | 3647 | 742 | 60.0391461 | 43.1215213 | 2020-09-27 04:23:00 | Vologda Oblast, Russia | ||
2836898 | 2836898 | 2020-09-21 | Mexico | Colima | 4479 | 526 | 3647 | 306 | 19.1223 | -104.0072 | 2020-09-22 04:23:00 | Colima, Mexico | ||
3923034 | 3923034 | 2020-08-09 | Russia | Buryatia Republic | 4379 | 42 | 3647 | 690 | 52.718242599999996 | 109.492143 | 2020-08-10 04:34:55 | Buryatia Republic, Russia | ||
3264688 | 3264688 | 2020-07-31 | Russia | Lipetsk Oblast | 4550 | 22 | 3647 | 881 | 52.693517799999995 | 39.112266399999996 | 2020-08-01 04:36:27 | Lipetsk Oblast, Russia | ||
2958415 | 2958415 | 2020-07-29 | Russia | Chuvashia Republic | 6653 | 51 | 3647 | 2955 | 55.4259922 | 47.0849429 | 2020-07-30 04:35:05 | Chuvashia Republic, Russia | ||
3237590 | 3237590 | 2020-07-10 | Russia | North Ossetia - Alania Republic | 4209 | 67 | 3647 | 495 | 42.79336110000001 | 44.6324493 | 2020-07-11 04:34:26 | North Ossetia - Alania Republic, Russia | ||
1510799 | 1510799 | 2020-06-22 | Russia | Tatarstan Republic | 4231 | 11 | 3647 | 573 | 55.7648572 | 52.43104273 | 2020-06-23 04:33:22 | Tatarstan Republic, Russia |
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]);