johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
46 rows where recovered = 349 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 18
- China 9
- United Kingdom 8
- Japan 6
- Canada 3
- Burma 2
- Cambodia 2
- Guyana 2
- Honduras 2
- Malaysia 2
- Ukraine 2
- El Salvador 1
- Georgia 1
- India 1
- Italy 1
- Mainland China 1
- Mexico 1
- Mozambique 1
- Russia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1639996 | 1639996 | 2021-04-29 | Malaysia | Perlis | 359 | 2 | 349 | 8 | 6.4449 | 100.2048 | 2021-04-30 04:21:03 | Perlis, Malaysia | ||
3253919 | 3253919 | 2021-03-02 | Canada | Nunavut | 359 | 1 | 349 | 9 | 70.2998 | -83.1076 | 2021-03-03 05:23:28 | Nunavut, Canada | ||
998211 | 998211 | 2021-03-01 | Canada | Nunavut | 358 | 1 | 349 | 8 | 70.2998 | -83.1076 | 2021-03-02 05:23:30 | Nunavut, Canada | ||
613728 | 613728 | 2021-02-08 | Japan | Tokushima | 395 | 15 | 349 | 31 | 33.919178 | 134.242091 | 2021-02-09 05:23:30 | Tokushima, Japan | ||
3879591 | 3879591 | 2021-01-14 | Japan | Iwate | 449 | 25 | 349 | 75 | 39.593287 | 141.361777 | 2021-01-15 05:22:24 | Iwate, Japan | ||
3879581 | 3879581 | 2021-01-14 | Japan | Fukui | 411 | 12 | 349 | 50 | 35.846614 | 136.22465400000002 | 2021-01-15 05:22:24 | Fukui, Japan | ||
3879394 | 3879394 | 2021-01-14 | China | Liaoning | 396 | 2 | 349 | 45 | 41.2956 | 122.6085 | 2021-01-15 05:22:24 | Liaoning, China | ||
2629520 | 2629520 | 2021-01-10 | United Kingdom | Isle of Man | 396 | 25 | 349 | 22 | 54.2361 | -4.5481 | 2021-01-11 05:21:50 | Isle of Man, United Kingdom | ||
2625686 | 2625686 | 2021-01-10 | China | Inner Mongolia | 366 | 1 | 349 | 16 | 44.0935 | 113.9448 | 2021-01-11 05:21:50 | Inner Mongolia, China | ||
3903608 | 3903608 | 2021-01-09 | United Kingdom | Isle of Man | 394 | 25 | 349 | 20 | 54.2361 | -4.5481 | 2021-01-10 05:22:12 | Isle of Man, United Kingdom | ||
3899774 | 3899774 | 2021-01-09 | China | Inner Mongolia | 366 | 1 | 349 | 16 | 44.0935 | 113.9448 | 2021-01-10 05:22:12 | Inner Mongolia, China | ||
157631 | 157631 | 2021-01-08 | United Kingdom | Isle of Man | 392 | 25 | 349 | 18 | 54.2361 | -4.5481 | 2021-01-09 05:22:18 | Isle of Man, United Kingdom | ||
2545055 | 2545055 | 2021-01-07 | United Kingdom | Isle of Man | 390 | 25 | 349 | 16 | 54.2361 | -4.5481 | 2021-01-08 05:22:42 | Isle of Man, United Kingdom | ||
2868364 | 2868364 | 2021-01-06 | United Kingdom | Isle of Man | 389 | 25 | 349 | 15 | 54.2361 | -4.5481 | 2021-01-07 05:22:03 | Isle of Man, United Kingdom | ||
3037951 | 3037951 | 2021-01-05 | United Kingdom | Isle of Man | 386 | 25 | 349 | 12 | 54.2361 | -4.5481 | 2021-01-06 05:22:16 | Isle of Man, United Kingdom | ||
1065496 | 1065496 | 2021-01-04 | United Kingdom | Isle of Man | 380 | 25 | 349 | 6 | 54.2361 | -4.5481 | 2021-01-05 05:21:49 | Isle of Man, United Kingdom | ||
2406594 | 2406594 | 2020-12-23 | Cambodia | 363 | 0 | 349 | 14 | 11.55 | 104.9167 | 2020-12-24 05:23:04 | Cambodia | |||
3769640 | 3769640 | 2020-12-22 | Cambodia | 363 | 0 | 349 | 14 | 11.55 | 104.9167 | 2020-12-23 05:22:03 | Cambodia | |||
678083 | 678083 | 2020-11-23 | Canada | New Brunswick | 445 | 7 | 349 | 89 | 46.5653 | -66.4619 | 2020-11-24 05:27:31 | New Brunswick, Canada | ||
2383271 | 2383271 | 2020-10-01 | United Kingdom | Gibraltar | 410 | 0 | 349 | 61 | 36.1408 | -5.3536 | 2020-10-02 04:23:51 | Gibraltar, United Kingdom | ||
2171570 | 2171570 | 2020-09-09 | Japan | Mie | 445 | 4 | 349 | 92 | 34.508018 | 136.376013 | 2020-09-10 04:29:01 | Mie, Japan | ||
1243779 | 1243779 | 2020-09-08 | Japan | Mie | 443 | 4 | 349 | 90 | 34.508018 | 136.376013 | 2020-09-09 04:28:48 | Mie, Japan | ||
1522945 | 1522945 | 2020-08-28 | Burma | 643 | 6 | 349 | 288 | 21.9162 | 95.956 | 2020-08-29 04:28:19 | Burma | |||
2509946 | 2509946 | 2020-08-27 | Burma | 602 | 6 | 349 | 247 | 21.9162 | 95.956 | 2020-08-28 04:28:11 | Burma | |||
3562392 | 3562392 | 2020-08-25 | China | Shaanxi | 364 | 3 | 349 | 12 | 35.1917 | 108.8701 | 2020-08-26 04:28:11 | Shaanxi, China | ||
2215687 | 2215687 | 2020-08-23 | Japan | Kumamoto | 471 | 7 | 349 | 115 | 32.608154 | 130.74523100000002 | 2020-08-24 04:27:56 | Kumamoto, Japan | ||
837542 | 837542 | 2020-08-17 | Guyana | 709 | 23 | 349 | 337 | 4.860416000000002 | -58.93018000000001 | 2020-08-18 04:27:56 | Guyana | |||
1555900 | 1555900 | 2020-08-16 | Guyana | 709 | 23 | 349 | 337 | 4.860416000000002 | -58.93018000000001 | 2020-08-17 04:27:20 | Guyana | |||
753708 | 753708 | 2020-08-01 | Ukraine | Sumy Oblast | 509 | 8 | 349 | 152 | 50.9077 | 34.7981 | 2020-08-02 04:34:47 | Sumy Oblast, Ukraine | ||
3436402 | 3436402 | 2020-07-11 | Mozambique | 1135 | 9 | 349 | 777 | -18.665695 | 35.529562 | 2020-07-12 04:34:30 | Mozambique | |||
2632767 | 2632767 | 2020-06-29 | India | Chandigarh | 435 | 6 | 349 | 80 | 30.733839 | 76.76827800000002 | 2020-06-30 04:33:48 | Chandigarh, India | ||
2306496 | 2306496 | 2020-06-28 | Russia | Magadan Oblast | 697 | 4 | 349 | 344 | 62.48858785 | 153.9903764 | 2020-06-29 04:33:44 | Magadan Oblast, Russia | ||
1281113 | 1281113 | 2020-06-04 | Ukraine | Dnipropetrovsk Oblast | 957 | 21 | 349 | 587 | 48.4647 | 35.0462 | 2020-06-05 02:33:06 | Dnipropetrovsk Oblast, Ukraine | ||
3866606 | 3866606 | 2020-06-03 | Italy | Basilicata | 399 | 27 | 349 | 23 | 40.63947052 | 15.80514834 | 2020-06-04 02:33:14 | Basilicata, Italy | ||
3638874 | 3638874 | 2020-05-30 | Mexico | Nayarit | 552 | 52 | 349 | 151 | 21.7514 | -104.8455 | 2020-05-31 02:32:45 | Nayarit, Mexico | ||
1432092 | 1432092 | 2020-05-20 | Honduras | 2955 | 147 | 349 | 2459 | 15.2 | -86.2419 | 2020-05-21 02:32:48 | Honduras | |||
2390311 | 2390311 | 2020-05-19 | Honduras | 2955 | 147 | 349 | 2459 | 15.2 | -86.2419 | 2020-05-20 02:32:19 | Honduras | |||
2581524 | 2581524 | 2020-05-12 | Georgia | 642 | 11 | 349 | 282 | 42.3154 | 43.3569 | 2020-05-13 03:32:26 | Georgia | |||
2581513 | 2581513 | 2020-05-12 | El Salvador | 998 | 20 | 349 | 629 | 13.7942 | -88.8965 | 2020-05-13 03:32:26 | El Salvador | |||
3589230 | 3589230 | 2020-04-27 | China | Fujian | 355 | 1 | 349 | 5 | 26.0789 | 117.9874 | 2020-04-25 01:01:53 | Fujian, China | ||
3592412 | 3592412 | 2020-04-26 | China | Fujian | 355 | 1 | 349 | 5 | 26.0789 | 117.9874 | 2020-04-25 01:01:53 | Fujian, China | ||
3502761 | 3502761 | 2020-04-25 | China | Fujian | 355 | 1 | 349 | 5 | 26.0789 | 117.9874 | 2020-04-25 01:01:53 | Fujian, China | ||
1459162 | 1459162 | 2020-04-24 | China | Fujian | 355 | 1 | 349 | 5 | 26.0789 | 117.9874 | 2020-04-25 01:01:53 | Fujian, China | ||
860334 | 860334 | 2020-04-15 | Malaysia | Johor | 604 | 14 | 349 | 241 | 1.4854 | 103.7618 | 2020-04-15 22:56:51 | Johor, Malaysia | ||
2111116 | 2111116 | 2020-03-14 | China | Beijing | 437 | 8 | 349 | 40.1824 | 116.4142 | 2020-03-14T02:13:47 | ||||
3551204 | 3551204 | 2020-02-24 | Mainland China | Chongqing | 576 | 6 | 349 | 30.0572 | 107.874 | 2020-02-24T23:23:01 |
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]);