johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
455 rows where recovered = 6 sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- France 143
- United Kingdom 26
- Mauritania 25
- Netherlands 23
- South Sudan 17
- Australia 15
- Mainland China 13
- Bhutan 12
- Seychelles 12
- Angola 11
- Suriname 11
- China 9
- Colombia 9
- Japan 8
- Grenada 7
- Azerbaijan 6
- Norway 6
- US 6
- Bahamas 5
- Honduras 5
- Luxembourg 5
- Macau 5
- Namibia 5
- Austria 4
- Brazil 4
- Sierra Leone 4
- Syria 4
- Thailand 4
- Barbados 3
- Eritrea 3
- …
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
197876 | 197876 | 2020-01-29 | Thailand | 14 | 0 | 6 | 1/29/20 19:30 | |||||||
339649 | 339649 | 2020-03-21 | Czechia | 995 | 0 | 6 | 49.8175 | 15.473 | 2020-03-21T20:43:02 | |||||
339667 | 339667 | 2020-03-21 | Chile | 537 | 0 | 6 | -35.6751 | -71.543 | 2020-03-21T14:43:03 | |||||
339688 | 339688 | 2020-03-21 | Canada | Ontario | 919 | 2 | 6 | 51.2538 | -85.3232 | 2020-03-21T21:13:30 | ||||
339826 | 339826 | 2020-03-21 | French Guiana | 18 | 0 | 6 | 3.9339 | -53.1258 | 2020-03-21T21:13:30 | |||||
415869 | 415869 | 2020-01-26 | Thailand | 8 | 0 | 6 | 1/26/20 16:00 | |||||||
566691 | 566691 | 2020-02-06 | Mainland China | Guizhou | 71 | 1 | 6 | 26.8154 | 106.8748 | 2020-02-06T09:53:02 | ||||
566692 | 566692 | 2020-02-06 | Mainland China | Gansu | 62 | 0 | 6 | 36.0611 | 103.8343 | 2020-02-05T16:23:06 | ||||
1085659 | 1085659 | 2020-02-22 | Hong Kong | Hong Kong | 69 | 2 | 6 | 22.3 | 114.2 | 2020-02-22T13:23:05 | ||||
1085670 | 1085670 | 2020-02-22 | Macau | Macau | 10 | 0 | 6 | 22.1667 | 113.55 | 2020-02-20T02:13:19 | ||||
1176910 | 1176910 | 2020-03-18 | Israel | 500 | 0 | 6 | 31.0461 | 34.8516 | 2020-03-18T14:33:15 | |||||
1176946 | 1176946 | 2020-03-18 | Saudi Arabia | 171 | 0 | 6 | 23.8859 | 45.0792 | 2020-03-17T17:53:03 | |||||
1177034 | 1177034 | 2020-03-18 | Azerbaijan | 28 | 1 | 6 | 40.1431 | 47.5769 | 2020-03-17T11:53:10 | |||||
1192475 | 1192475 | 2020-02-14 | Mainland China | Inner Mongolia | 65 | 0 | 6 | 44.0935 | 113.9448 | 2020-02-14T02:03:08 | ||||
1192476 | 1192476 | 2020-02-14 | Mainland China | Xinjiang | 65 | 1 | 6 | 41.1129 | 85.2401 | 2020-02-14T01:13:06 | ||||
1305791 | 1305791 | 2020-01-28 | Thailand | 14 | 0 | 6 | 1/28/20 23:00 | |||||||
1463481 | 1463481 | 2020-03-15 | Austria | 591 | 1 | 6 | 47.5162 | 14.5501 | 2020-03-15T18:20:18 | |||||
1463492 | 1463492 | 2020-03-15 | US | California | 426 | 6 | 6 | 36.1162 | -119.6816 | 2020-03-15T18:33:03 | ||||
1463610 | 1463610 | 2020-03-15 | Azerbaijan | 23 | 1 | 6 | 40.1431 | 47.5769 | 2020-03-13T12:13:36 | |||||
1526932 | 1526932 | 2020-03-19 | Saudi Arabia | 274 | 0 | 6 | 23.8859 | 45.0792 | 2020-03-19T20:43:02 | |||||
1527021 | 1527021 | 2020-03-19 | Azerbaijan | 44 | 1 | 6 | 40.1431 | 47.5769 | 2020-03-19T16:13:36 | |||||
1559681 | 1559681 | 2020-02-13 | Mainland China | Xinjiang | 63 | 1 | 6 | 41.1129 | 85.2401 | 2020-02-13T10:33:23 | ||||
1559682 | 1559682 | 2020-02-13 | Mainland China | Inner Mongolia | 61 | 0 | 6 | 44.0935 | 113.9448 | 2020-02-13T01:23:08 | ||||
2091676 | 2091676 | 2020-02-05 | Mainland China | Shaanxi | 165 | 0 | 6 | 35.1917 | 108.8701 | 2020-02-05T08:43:01 | ||||
2091678 | 2091678 | 2020-02-05 | Mainland China | Hebei | 135 | 1 | 6 | 38.0428 | 114.5149 | 2020-02-05T11:23:18 | ||||
2091685 | 2091685 | 2020-02-05 | Mainland China | Gansu | 62 | 0 | 6 | 36.0611 | 103.8343 | 2020-02-05T16:23:06 | ||||
2111109 | 2111109 | 2020-03-14 | Austria | 409 | 1 | 6 | 47.5162 | 14.5501 | 2020-03-14T16:13:55 | |||||
2111118 | 2111118 | 2020-03-14 | US | California | 340 | 5 | 6 | 36.1162 | -119.6816 | 2020-03-14T22:13:32 | ||||
2127502 | 2127502 | 2020-03-11 | Romania | 45 | 0 | 6 | 46.0 | 25.0 | 2020-03-11T21:13:18 | |||||
2135751 | 2135751 | 2020-02-21 | Macau | Macau | 10 | 0 | 6 | 22.1667 | 113.55 | 2020-02-20T02:13:19 | ||||
2255128 | 2255128 | 2020-03-16 | Austria | 801 | 2 | 6 | 47.5162 | 14.5501 | 2020-03-16T15:13:09 | |||||
2255140 | 2255140 | 2020-03-16 | US | California | 557 | 7 | 6 | 36.1162 | -119.6816 | 2020-03-16T23:53:03 | ||||
2255275 | 2255275 | 2020-03-16 | Azerbaijan | 15 | 1 | 6 | 40.1431 | 47.5769 | 2020-03-16T14:38:45 | |||||
2263483 | 2263483 | 2020-02-20 | Hong Kong | Hong Kong | 68 | 2 | 6 | 22.3 | 114.2 | 2020-02-20T23:13:05 | ||||
2263490 | 2263490 | 2020-02-20 | Macau | Macau | 10 | 0 | 6 | 22.1667 | 113.55 | 2020-02-20T02:13:19 | ||||
2282897 | 2282897 | 2020-03-12 | US | California | 221 | 4 | 6 | 36.1162 | -119.6816 | 2020-03-12T23:44:33 | ||||
2282932 | 2282932 | 2020-03-12 | Romania | 49 | 0 | 6 | 46.0 | 25.0 | 2020-03-12T09:13:24 | |||||
2379238 | 2379238 | 2020-02-02 | Mainland China | Shandong | 230 | 0 | 6 | 36.3427 | 118.1498 | 2020-02-02T18:03:05 | ||||
2567270 | 2567270 | 2020-02-12 | Mainland China | Inner Mongolia | 60 | 0 | 6 | 44.0935 | 113.9448 | 2020-02-12T11:13:05 | ||||
2567281 | 2567281 | 2020-02-12 | Vietnam | 15 | 0 | 6 | 2020-02-11T16:43:06 | |||||||
2883947 | 2883947 | 2020-02-28 | Taiwan | Taiwan | 34 | 1 | 6 | 23.7 | 121.0 | 2020-02-28T07:13:08 | ||||
3173381 | 3173381 | 2020-02-23 | Macau | Macau | 10 | 0 | 6 | 22.1667 | 113.55 | 2020-02-20T02:13:19 | ||||
3197740 | 3197740 | 2020-02-11 | Vietnam | 15 | 0 | 6 | 2020-02-11T16:43:06 | |||||||
3222021 | 3222021 | 2020-02-07 | Mainland China | Guizhou | 81 | 1 | 6 | 26.8154 | 106.8748 | 2020-02-07T11:13:07 | ||||
3413150 | 3413150 | 2020-02-01 | Mainland China | Jiangsu | 202 | 0 | 6 | 32.9711 | 119.455 | 2/1/2020 14:03 | ||||
3551238 | 3551238 | 2020-02-24 | Macau | Macau | 10 | 0 | 6 | 22.1667 | 113.55 | 2020-02-20T02:13:19 | ||||
3733967 | 3733967 | 2020-03-20 | Chile | 434 | 0 | 6 | -35.6751 | -71.543 | 2020-03-20T20:13:17 | |||||
3734083 | 3734083 | 2020-03-20 | Azerbaijan | 44 | 1 | 6 | 40.1431 | 47.5769 | 2020-03-19T16:13:36 | |||||
3753094 | 3753094 | 2020-01-27 | Thailand | 8 | 0 | 6 | 1/27/20 23:59 | |||||||
3765351 | 3765351 | 2020-03-13 | Austria | 312 | 0 | 6 | 47.5162 | 14.5501 | 2020-03-11T20:00:00 | |||||
3765458 | 3765458 | 2020-03-13 | US | California | 282 | 4 | 6 | 36.116203 | -119.681564 | 2020-03-11T20:00:00 | ||||
3891331 | 3891331 | 2020-03-17 | US | California | 698 | 12 | 6 | 36.1162 | -119.6816 | 2020-03-17T22:53:03 | ||||
3891371 | 3891371 | 2020-03-17 | Saudi Arabia | 171 | 0 | 6 | 23.8859 | 45.0792 | 2020-03-17T17:53:03 | |||||
3891455 | 3891455 | 2020-03-17 | Azerbaijan | 28 | 1 | 6 | 40.1431 | 47.5769 | 2020-03-17T11:53:10 | |||||
271643 | 271643 | 2020-04-28 | Angola | 27 | 2 | 6 | 19 | -11.2027 | 17.8739 | 2020-04-29 02:32:29 | Angola | |||
418793 | 418793 | 2020-04-18 | Angola | 24 | 2 | 6 | 16 | -11.2027 | 17.8739 | 2020-04-18 22:32:28 | Angola | |||
522331 | 522331 | 2020-04-21 | Angola | 24 | 2 | 6 | 16 | -11.2027 | 17.8739 | 2020-04-21 23:30:30 | Angola | |||
1199265 | 1199265 | 2020-04-22 | Angola | 25 | 2 | 6 | 17 | -11.2027 | 17.8739 | 2020-04-22 23:30:32 | Angola | |||
1385105 | 1385105 | 2020-04-19 | Angola | 24 | 2 | 6 | 16 | -11.2027 | 17.8739 | 2020-04-19 23:40:41 | Angola | |||
1459226 | 1459226 | 2020-04-24 | Angola | 25 | 2 | 6 | 17 | -11.2027 | 17.8739 | 2020-04-25 06:30:33 | Angola | |||
2473413 | 2473413 | 2020-04-20 | Angola | 24 | 2 | 6 | 16 | -11.2027 | 17.8739 | 2020-04-20 23:36:27 | Angola | |||
2524815 | 2524815 | 2020-04-23 | Angola | 25 | 2 | 6 | 17 | -11.2027 | 17.8739 | 2020-04-24 03:30:31 | Angola | |||
3502825 | 3502825 | 2020-04-25 | Angola | 25 | 2 | 6 | 17 | -11.2027 | 17.8739 | 2020-04-26 02:30:31 | Angola | |||
3589298 | 3589298 | 2020-04-27 | Angola | 27 | 2 | 6 | 19 | -11.2027 | 17.8739 | 2020-04-28 02:30:32 | Angola | |||
3592476 | 3592476 | 2020-04-26 | Angola | 26 | 2 | 6 | 18 | -11.2027 | 17.8739 | 2020-04-27 02:30:33 | Angola | |||
43172 | 43172 | 2020-04-13 | Bahamas | 47 | 8 | 6 | 33 | 25.025885 | -78.035889 | 2020-04-13 23:07:34 | Bahamas | |||
50271 | 50271 | 2020-04-17 | Bahamas | 54 | 9 | 6 | 39 | 25.025885 | -78.035889 | 2020-04-17 23:30:32 | Bahamas | |||
860159 | 860159 | 2020-04-15 | Bahamas | 49 | 8 | 6 | 35 | 25.025885 | -78.035889 | 2020-04-15 22:56:32 | Bahamas | |||
934265 | 934265 | 2020-04-16 | Bahamas | 53 | 8 | 6 | 39 | 25.025885 | -78.035889 | 2020-04-16 23:30:31 | Bahamas | |||
3338075 | 3338075 | 2020-04-14 | Bahamas | 49 | 8 | 6 | 35 | 25.025885 | -78.035889 | 2020-04-14 23:33:12 | Bahamas | |||
589112 | 589112 | 2020-04-05 | Barbados | 56 | 1 | 6 | 49 | 13.1939 | -59.5432 | 2020-04-05 23:06:26 | Barbados | |||
3021742 | 3021742 | 2020-04-07 | Barbados | 63 | 3 | 6 | 54 | 13.1939 | -59.5432 | 2020-04-07 23:04:29 | Barbados | |||
3627424 | 3627424 | 2020-04-06 | Barbados | 60 | 2 | 6 | 52 | 13.1939 | -59.5432 | 4/6/20 23:21 | Barbados | |||
3589310 | 3589310 | 2020-04-27 | Belize | 18 | 2 | 6 | 10 | 17.1899 | -88.4976 | 2020-04-28 02:30:32 | Belize | |||
268457 | 268457 | 2020-05-21 | Bhutan | 21 | 0 | 6 | 15 | 27.5142 | 90.4336 | 2020-05-22 02:36:51 | Bhutan | |||
805602 | 805602 | 2020-06-01 | Bhutan | 43 | 0 | 6 | 37 | 27.5142 | 90.4336 | 2020-06-02 02:33:08 | Bhutan | |||
875737 | 875737 | 2020-05-24 | Bhutan | 24 | 0 | 6 | 18 | 27.5142 | 90.4336 | 2020-05-25 02:32:44 | Bhutan | |||
997928 | 997928 | 2020-05-23 | Bhutan | 24 | 0 | 6 | 18 | 27.5142 | 90.4336 | 2020-05-24 02:32:43 | Bhutan | |||
1041327 | 1041327 | 2020-05-26 | Bhutan | 27 | 0 | 6 | 21 | 27.5142 | 90.4336 | 2020-05-27 02:32:31 | Bhutan | |||
1105057 | 1105057 | 2020-05-25 | Bhutan | 27 | 0 | 6 | 21 | 27.5142 | 90.4336 | 2020-05-26 02:32:35 | Bhutan | |||
1790569 | 1790569 | 2020-05-29 | Bhutan | 31 | 0 | 6 | 25 | 27.5142 | 90.4336 | 2020-05-30 02:32:48 | Bhutan | |||
1794136 | 1794136 | 2020-05-31 | Bhutan | 43 | 0 | 6 | 37 | 27.5142 | 90.4336 | 2020-06-01 02:32:46 | Bhutan | |||
1864951 | 1864951 | 2020-05-22 | Bhutan | 21 | 0 | 6 | 15 | 27.5142 | 90.4336 | 2020-05-23 02:32:42 | Bhutan | |||
2548364 | 2548364 | 2020-05-27 | Bhutan | 28 | 0 | 6 | 22 | 27.5142 | 90.4336 | 2020-05-28 02:32:31 | Bhutan | |||
2712448 | 2712448 | 2020-05-28 | Bhutan | 31 | 0 | 6 | 25 | 27.5142 | 90.4336 | 2020-05-29 02:32:50 | Bhutan | |||
3639029 | 3639029 | 2020-05-30 | Bhutan | 33 | 0 | 6 | 27 | 27.5142 | 90.4336 | 2020-05-31 02:32:45 | Bhutan | |||
3338084 | 3338084 | 2020-04-14 | Bolivia | 354 | 28 | 6 | 320 | -16.2902 | -63.5887 | 2020-04-14 23:33:12 | Bolivia | |||
268244 | 268244 | 2020-05-21 | Netherlands | Bonaire, Sint Eustatius and Saba | 6 | 0 | 6 | 0 | 12.1784 | -68.2385 | 2020-05-22 02:36:51 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
875524 | 875524 | 2020-05-24 | Netherlands | Bonaire, Sint Eustatius and Saba | 6 | 0 | 6 | 0 | 12.1784 | -68.2385 | 2020-05-25 02:32:44 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
997715 | 997715 | 2020-05-23 | Netherlands | Bonaire, Sint Eustatius and Saba | 6 | 0 | 6 | 0 | 12.1784 | -68.2385 | 2020-05-24 02:32:43 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
1041114 | 1041114 | 2020-05-26 | Netherlands | Bonaire, Sint Eustatius and Saba | 6 | 0 | 6 | 0 | 12.1784 | -68.2385 | 2020-05-27 02:32:31 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
1104844 | 1104844 | 2020-05-25 | Netherlands | Bonaire, Sint Eustatius and Saba | 6 | 0 | 6 | 0 | 12.1784 | -68.2385 | 2020-05-26 02:32:35 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
1404364 | 1404364 | 2020-05-14 | Netherlands | Bonaire, Sint Eustatius and Saba | 6 | 0 | 6 | 0 | 12.1784 | -68.2385 | 2020-05-15 02:33:02 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
1431827 | 1431827 | 2020-05-20 | Netherlands | Bonaire, Sint Eustatius and Saba | 6 | 0 | 6 | 0 | 12.1784 | -68.2385 | 2020-05-21 02:32:48 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
1790264 | 1790264 | 2020-05-29 | Netherlands | Bonaire, Sint Eustatius and Saba | 6 | 0 | 6 | 0 | 12.1784 | -68.2385 | 2020-05-30 02:32:48 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
1793830 | 1793830 | 2020-05-31 | Netherlands | Bonaire, Sint Eustatius and Saba | 6 | 0 | 6 | 0 | 12.1784 | -68.2385 | 2020-06-01 02:32:46 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
1829474 | 1829474 | 2020-05-16 | Netherlands | Bonaire, Sint Eustatius and Saba | 6 | 0 | 6 | 0 | 12.1784 | -68.2385 | 2020-05-17 02:32:32 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
1864738 | 1864738 | 2020-05-22 | Netherlands | Bonaire, Sint Eustatius and Saba | 6 | 0 | 6 | 0 | 12.1784 | -68.2385 | 2020-05-23 02:32:42 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
2390107 | 2390107 | 2020-05-19 | Netherlands | Bonaire, Sint Eustatius and Saba | 6 | 0 | 6 | 0 | 12.1784 | -68.2385 | 2020-05-20 02:32:19 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
2548151 | 2548151 | 2020-05-27 | Netherlands | Bonaire, Sint Eustatius and Saba | 6 | 0 | 6 | 0 | 12.1784 | -68.2385 | 2020-05-28 02:32:31 | Bonaire, Sint Eustatius and Saba, Netherlands |
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]);