johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where recovered = 830 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- Burkina Faso 4
- Australia 3
- China 2
- India 2
- Japan 2
- Mainland China 2
- Taiwan* 2
- Georgia 1
- Italy 1
- Jordan 1
- Monaco 1
- Mongolia 1
- Sao Tome and Principe 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015049 | 3015049 | 2021-08-01 | Australia | South Australia | 862 | 4 | 830 | 28 | -34.9285 | 138.6007 | 2021-08-02 04:21:36 | South Australia, Australia | ||
3903672 | 3903672 | 2021-07-31 | Australia | South Australia | 859 | 4 | 830 | 25 | -34.9285 | 138.6007 | 2021-08-01 04:21:50 | South Australia, Australia | ||
1527916 | 1527916 | 2021-02-09 | Japan | Kochi | 864 | 17 | 830 | 17 | 33.422519 | 133.367307 | 2021-02-10 05:22:41 | Kochi, Japan | ||
613731 | 613731 | 2021-02-08 | Japan | Toyama | 882 | 27 | 830 | 25 | 36.637464 | 137.26934599999998 | 2021-02-09 05:23:30 | Toyama, Japan | ||
1676800 | 1676800 | 2021-02-01 | Taiwan* | 912 | 8 | 830 | 74 | 23.7 | 121.0 | 2021-02-02 05:22:49 | Taiwan* | |||
1460088 | 1460088 | 2021-01-31 | Taiwan* | 911 | 8 | 830 | 73 | 23.7 | 121.0 | 2021-02-01 05:22:53 | Taiwan* | |||
3900068 | 3900068 | 2021-01-09 | Monaco | 1053 | 4 | 830 | 219 | 43.7333 | 7.4167 | 2021-01-10 05:22:12 | Monaco | |||
153809 | 153809 | 2021-01-08 | China | Sichuan | 857 | 3 | 830 | 24 | 30.6171 | 102.7103 | 2021-01-09 05:22:18 | Sichuan, China | ||
1010414 | 1010414 | 2020-12-30 | Mongolia | 1175 | 1 | 830 | 384 | 46.8625 | 103.8467 | 2020-12-31 05:22:49 | Mongolia | |||
2406535 | 2406535 | 2020-12-23 | Australia | Western Australia | 847 | 9 | 830 | 8 | -31.9505 | 115.8605 | 2020-12-24 05:23:04 | Western Australia, Australia | ||
3440794 | 3440794 | 2020-11-11 | Italy | Basilicata | 4047 | 69 | 830 | 3148 | 40.63947052 | 15.80514834 | 2020-11-12 05:25:55 | Basilicata, Italy | ||
3785518 | 3785518 | 2020-10-13 | Ukraine | Kherson Oblast | 2024 | 38 | 830 | 1156 | 46.6354 | 32.6169 | 2020-10-14 04:24:05 | Kherson Oblast, Ukraine | ||
344234 | 344234 | 2020-09-14 | India | Mizoram | 1428 | 0 | 830 | 598 | 23.309381 | 92.83822 | 2020-09-15 03:22:50 | Mizoram, India | ||
2868673 | 2868673 | 2020-09-13 | India | Mizoram | 1428 | 0 | 830 | 598 | 23.309381 | 92.83822 | 2020-09-14 04:26:00 | Mizoram, India | ||
1479823 | 1479823 | 2020-08-21 | Sao Tome and Principe | 891 | 15 | 830 | 46 | 0.1864 | 6.6131 | 2020-08-22 04:27:49 | Sao Tome and Principe | |||
2685221 | 2685221 | 2020-07-06 | Georgia | 953 | 15 | 830 | 108 | 42.3154 | 43.3569 | 2020-07-07 04:34:00 | Georgia | |||
2633215 | 2633215 | 2020-06-29 | Burkina Faso | 959 | 53 | 830 | 76 | 12.2383 | -1.5616 | 2020-06-30 04:33:48 | Burkina Faso | |||
2306778 | 2306778 | 2020-06-28 | Burkina Faso | 959 | 53 | 830 | 76 | 12.2383 | -1.5616 | 2020-06-29 04:33:44 | Burkina Faso | |||
2040113 | 2040113 | 2020-06-27 | Burkina Faso | 941 | 53 | 830 | 58 | 12.2383 | -1.5616 | 2020-06-28 04:34:04 | Burkina Faso | |||
1136448 | 1136448 | 2020-06-26 | Jordan | 1104 | 9 | 830 | 265 | 31.24 | 36.51 | 2020-06-27 04:33:35 | Jordan | |||
1136394 | 1136394 | 2020-06-26 | Burkina Faso | 941 | 53 | 830 | 58 | 12.2383 | -1.5616 | 2020-06-27 04:33:35 | Burkina Faso | |||
137369 | 137369 | 2020-04-29 | China | Hong Kong | 1037 | 4 | 830 | 203 | 22.3 | 114.2 | 2020-04-30 02:32:27 | Hong Kong, China | ||
2883910 | 2883910 | 2020-02-28 | Mainland China | Hunan | 1017 | 4 | 830 | 27.6104 | 111.7088 | 2020-02-28T09:13:10 | ||||
1085628 | 1085628 | 2020-02-22 | Mainland China | Henan | 1270 | 19 | 830 | 33.882 | 113.614 | 2020-02-22T14:13:38 |
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]);