johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,051 rows where recovered = 2 sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- Samoa 162
- United Kingdom 104
- Holy See 59
- Australia 50
- US 40
- Colombia 37
- Mainland China 37
- Russia 25
- Gambia 23
- Lesotho 23
- Mauritania 21
- Spain 21
- Bhutan 20
- Malta 20
- Jamaica 19
- Canada 18
- Netherlands 18
- China 13
- Sudan 12
- Bosnia and Herzegovina 10
- Denmark 10
- France 10
- Taiwan 10
- Zimbabwe 10
- Bolivia 9
- Brazil 9
- Chad 9
- Malaysia 9
- Namibia 9
- Burma 8
- …
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1802376 | 1802376 | 2020-01-22 | Thailand | 4 | 0 | 2 | 1/22/2020 17:00 | |||||||
864382 | 864382 | 2020-01-23 | Mainland China | Guangdong | 32 | 0 | 2 | 23.3417 | 113.4244 | 1/23/20 17:00 | ||||
864413 | 864413 | 2020-01-23 | Thailand | 4 | 0 | 2 | 1/23/20 17:00 | |||||||
197760 | 197760 | 2020-01-24 | Mainland China | Guangdong | 53 | 0 | 2 | 23.3417 | 113.4244 | 1/24/20 17:00 | ||||
2938933 | 2938933 | 2020-01-25 | Mainland China | Guangdong | 78 | 0 | 2 | 23.3417 | 113.4244 | 1/25/20 17:00 | ||||
2938937 | 2938937 | 2020-01-25 | Mainland China | Beijing | 41 | 0 | 2 | 40.1824 | 116.4142 | 1/25/20 17:00 | ||||
415832 | 415832 | 2020-01-26 | Mainland China | Guangdong | 111 | 0 | 2 | 23.3417 | 113.4244 | 1/26/20 16:00 | ||||
415837 | 415837 | 2020-01-26 | Mainland China | Beijing | 68 | 0 | 2 | 40.1824 | 116.4142 | 1/26/20 16:00 | ||||
3753062 | 3753062 | 2020-01-27 | Mainland China | Beijing | 80 | 1 | 2 | 40.1824 | 116.4142 | 1/27/20 23:59 | ||||
3753064 | 3753064 | 2020-01-27 | Mainland China | Jiangxi | 72 | 0 | 2 | 27.614 | 115.7221 | 1/27/20 23:59 | ||||
1305767 | 1305767 | 2020-01-28 | Mainland China | Guangxi | 51 | 0 | 2 | 23.8298 | 108.7881 | 1/28/20 23:00 | ||||
197843 | 197843 | 2020-01-29 | Mainland China | Anhui | 152 | 0 | 2 | 31.8257 | 117.2264 | 1/29/20 19:30 | ||||
197852 | 197852 | 2020-01-29 | Mainland China | Guangxi | 58 | 0 | 2 | 23.8298 | 108.7881 | 1/29/20 19:30 | ||||
1527493 | 1527493 | 2020-01-30 | Mainland China | Henan | 278 | 2 | 2 | 33.882 | 113.614 | 1/30/20 16:00 | ||||
1527494 | 1527494 | 2020-01-30 | Mainland China | Hunan | 277 | 0 | 2 | 27.6104 | 111.7088 | 1/30/20 16:00 | ||||
1527495 | 1527495 | 2020-01-30 | Mainland China | Anhui | 200 | 0 | 2 | 31.8257 | 117.2264 | 1/30/20 16:00 | ||||
1527504 | 1527504 | 2020-01-30 | Mainland China | Guangxi | 78 | 0 | 2 | 23.8298 | 108.7881 | 1/30/20 16:00 | ||||
1527539 | 1527539 | 2020-01-30 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 1/30/20 16:00 | ||||
3413164 | 3413164 | 2020-02-01 | Mainland China | Guizhou | 29 | 0 | 2 | 26.8154 | 106.8748 | 1/31/2020 15:20 | ||||
3761179 | 3761179 | 2020-01-31 | Mainland China | Hunan | 332 | 0 | 2 | 27.6104 | 111.7088 | 1/31/2020 23:59 | ||||
3761183 | 3761183 | 2020-01-31 | Mainland China | Shandong | 184 | 0 | 2 | 36.3427 | 118.1498 | 1/31/2020 23:59 | ||||
3761189 | 3761189 | 2020-01-31 | Mainland China | Guangxi | 87 | 0 | 2 | 23.8298 | 108.7881 | 1/31/2020 23:59 | ||||
3761198 | 3761198 | 2020-01-31 | Mainland China | Guizhou | 29 | 0 | 2 | 26.8154 | 106.8748 | 1/31/2020 23:59 | ||||
3761215 | 3761215 | 2020-01-31 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 1/31/2020 23:59 | ||||
3413158 | 3413158 | 2020-02-01 | Mainland China | Heilongjiang | 80 | 2 | 2 | 47.862 | 127.7615 | 2/1/2020 10:33 | ||||
3413157 | 3413157 | 2020-02-01 | Mainland China | Yunnan | 93 | 0 | 2 | 24.974 | 101.487 | 2/1/2020 15:53 | ||||
3413180 | 3413180 | 2020-02-01 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 2/1/2020 18:12 | ||||
3413155 | 3413155 | 2020-02-01 | Mainland China | Guangxi | 100 | 0 | 2 | 23.8298 | 108.7881 | 2/1/2020 1:52 | ||||
2091702 | 2091702 | 2020-02-05 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 2020-02-01T18:12:49 | ||||
2379269 | 2379269 | 2020-02-02 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 2020-02-01T18:12:49 | ||||
2860583 | 2860583 | 2020-02-03 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 2020-02-01T18:12:49 | ||||
3471919 | 3471919 | 2020-02-04 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 2020-02-01T18:12:49 | ||||
2379243 | 2379243 | 2020-02-02 | Mainland China | Guangxi | 111 | 0 | 2 | 23.8298 | 108.7881 | 2020-02-02T00:23:13 | ||||
2379252 | 2379252 | 2020-02-02 | Mainland China | Guizhou | 38 | 0 | 2 | 26.8154 | 106.8748 | 2020-02-02T01:03:32 | ||||
2379246 | 2379246 | 2020-02-02 | Mainland China | Heilongjiang | 95 | 2 | 2 | 47.862 | 127.7615 | 2020-02-02T03:23:14 | ||||
2860566 | 2860566 | 2020-02-03 | Mainland China | Guizhou | 46 | 0 | 2 | 26.8154 | 106.8748 | 2020-02-03T01:03:22 | ||||
2860558 | 2860558 | 2020-02-03 | Mainland China | Heilongjiang | 121 | 2 | 2 | 47.862 | 127.7615 | 2020-02-03T07:13:19 | ||||
2860562 | 2860562 | 2020-02-03 | Mainland China | Shanxi | 74 | 0 | 2 | 37.5777 | 112.2922 | 2020-02-03T23:13:11 | ||||
3471901 | 3471901 | 2020-02-04 | Mainland China | Guizhou | 58 | 0 | 2 | 26.8154 | 106.8748 | 2020-02-04T10:43:02 | ||||
3471893 | 3471893 | 2020-02-04 | Mainland China | Shaanxi | 142 | 0 | 2 | 35.1917 | 108.8701 | 2020-02-04T12:33:02 | ||||
3471900 | 3471900 | 2020-02-04 | Mainland China | Tianjin | 67 | 0 | 2 | 39.3054 | 117.323 | 2020-02-04T13:33:02 | ||||
3471897 | 3471897 | 2020-02-04 | Mainland China | Liaoning | 81 | 0 | 2 | 41.2956 | 122.6085 | 2020-02-04T14:13:08 | ||||
2091683 | 2091683 | 2020-02-05 | Mainland China | Tianjin | 69 | 1 | 2 | 39.3054 | 117.323 | 2020-02-05T03:43:02 | ||||
2091686 | 2091686 | 2020-02-05 | Mainland China | Jilin | 54 | 0 | 2 | 43.6661 | 126.1923 | 2020-02-05T11:03:16 | ||||
566709 | 566709 | 2020-02-06 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 2020-02-06T03:13:22 | ||||
1366083 | 1366083 | 2020-02-08 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 2020-02-06T03:13:22 | ||||
2567287 | 2567287 | 2020-02-12 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 2020-02-06T03:13:22 | ||||
3089045 | 3089045 | 2020-02-10 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 2020-02-06T03:13:22 | ||||
3197746 | 3197746 | 2020-02-11 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 2020-02-06T03:13:22 | ||||
3222042 | 3222042 | 2020-02-07 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 2020-02-06T03:13:22 | ||||
3362413 | 3362413 | 2020-02-09 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 2020-02-06T03:13:22 | ||||
566690 | 566690 | 2020-02-06 | Mainland China | Tianjin | 79 | 1 | 2 | 39.3054 | 117.323 | 2020-02-06T23:43:01 | ||||
3222022 | 3222022 | 2020-02-07 | Mainland China | Tianjin | 81 | 1 | 2 | 39.3054 | 117.323 | 2020-02-07T05:43:03 | ||||
1366070 | 1366070 | 2020-02-08 | Singapore | 33 | 0 | 2 | 2020-02-08T12:53:01 | |||||||
3362400 | 3362400 | 2020-02-09 | Singapore | 40 | 0 | 2 | 2020-02-09T02:43:02 | |||||||
107081 | 107081 | 2020-02-15 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
479191 | 479191 | 2020-02-25 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
617461 | 617461 | 2020-02-27 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
1085684 | 1085684 | 2020-02-22 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
1192500 | 1192500 | 2020-02-14 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
1243402 | 1243402 | 2020-02-17 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
1559707 | 1559707 | 2020-02-13 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
1720097 | 1720097 | 2020-02-19 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
1783128 | 1783128 | 2020-02-18 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
1888755 | 1888755 | 2020-02-16 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
2135766 | 2135766 | 2020-02-21 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
2263505 | 2263505 | 2020-02-20 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
2509816 | 2509816 | 2020-02-26 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
2567297 | 2567297 | 2020-02-12 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
2883977 | 2883977 | 2020-02-28 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
3089055 | 3089055 | 2020-02-10 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
3173395 | 3173395 | 2020-02-23 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
3197756 | 3197756 | 2020-02-11 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
3205860 | 3205860 | 2020-02-29 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
3362424 | 3362424 | 2020-02-09 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
3551251 | 3551251 | 2020-02-24 | US | Chicago, IL | 2 | 0 | 2 | 41.8781 | -87.6298 | 2020-02-09T19:03:03 | ||||
3089031 | 3089031 | 2020-02-10 | Singapore | 45 | 0 | 2 | 2020-02-10T19:03:02 | |||||||
2567283 | 2567283 | 2020-02-12 | Macau | Macau | 10 | 0 | 2 | 22.1667 | 113.55 | 2020-02-12T09:53:02 | ||||
107079 | 107079 | 2020-02-15 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
479190 | 479190 | 2020-02-25 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
562579 | 562579 | 2020-03-01 | Russia | 2 | 0 | 2 | 60.0 | 90.0 | 2020-02-12T14:43:03 | |||||
617460 | 617460 | 2020-02-27 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
1085682 | 1085682 | 2020-02-22 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
1192498 | 1192498 | 2020-02-14 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
1243400 | 1243400 | 2020-02-17 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
1559705 | 1559705 | 2020-02-13 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
1720095 | 1720095 | 2020-02-19 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
1783126 | 1783126 | 2020-02-18 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
1888753 | 1888753 | 2020-02-16 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
2135764 | 2135764 | 2020-02-21 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
2263503 | 2263503 | 2020-02-20 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
2509814 | 2509814 | 2020-02-26 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
2567295 | 2567295 | 2020-02-12 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
2883976 | 2883976 | 2020-02-28 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
3173393 | 3173393 | 2020-02-23 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
3205859 | 3205859 | 2020-02-29 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
3551249 | 3551249 | 2020-02-24 | Russia | 2 | 0 | 2 | 2020-02-12T14:43:03 | |||||||
1192485 | 1192485 | 2020-02-14 | France | 11 | 0 | 2 | 2020-02-12T18:53:02 | |||||||
1559692 | 1559692 | 2020-02-13 | France | 11 | 0 | 2 | 2020-02-12T18:53:02 | |||||||
2567282 | 2567282 | 2020-02-12 | France | 11 | 0 | 2 | 2020-02-12T18:53:02 |
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]);