johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
129 rows where recovered = 50 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- Chile 25
- Japan 19
- France 18
- Denmark 12
- Colombia 8
- Benin 3
- Bhutan 3
- India 3
- Malaysia 3
- Taiwan* 3
- Timor-Leste 3
- Burkina Faso 2
- Cambodia 2
- Chad 2
- Congo (Kinshasa) 2
- Ethiopia 2
- Laos 2
- South Africa 2
- Burma 1
- China 1
- Dominican Republic 1
- Georgia 1
- Lebanon 1
- Libya 1
- Mainland China 1
- Mexico 1
- Moldova 1
- Monaco 1
- New Zealand 1
- Philippines 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3740957 | 3740957 | 2021-07-12 | Denmark | Greenland | 55 | 0 | 50 | 5 | 71.7069 | -42.6043 | 2021-07-13 04:21:18 | Greenland, Denmark | ||
3659470 | 3659470 | 2021-07-11 | Denmark | Greenland | 55 | 0 | 50 | 5 | 71.7069 | -42.6043 | 2021-07-12 04:21:34 | Greenland, Denmark | ||
625754 | 625754 | 2021-07-10 | Denmark | Greenland | 52 | 0 | 50 | 2 | 71.7069 | -42.6043 | 2021-07-11 04:21:43 | Greenland, Denmark | ||
829473 | 829473 | 2021-07-09 | Denmark | Greenland | 51 | 0 | 50 | 1 | 71.7069 | -42.6043 | 2021-07-10 04:21:25 | Greenland, Denmark | ||
778237 | 778237 | 2021-07-08 | Denmark | Greenland | 51 | 0 | 50 | 1 | 71.7069 | -42.6043 | 2021-07-09 04:21:21 | Greenland, Denmark | ||
1440459 | 1440459 | 2021-07-07 | Denmark | Greenland | 51 | 0 | 50 | 1 | 71.7069 | -42.6043 | 2021-07-08 04:21:26 | Greenland, Denmark | ||
2693564 | 2693564 | 2021-07-06 | Denmark | Greenland | 51 | 0 | 50 | 1 | 71.7069 | -42.6043 | 2021-07-07 04:21:20 | Greenland, Denmark | ||
1932313 | 1932313 | 2021-07-05 | Denmark | Greenland | 51 | 0 | 50 | 1 | 71.7069 | -42.6043 | 2021-07-06 04:21:32 | Greenland, Denmark | ||
1165044 | 1165044 | 2021-07-04 | Denmark | Greenland | 50 | 0 | 50 | 0 | 71.7069 | -42.6043 | 2021-07-05 04:21:28 | Greenland, Denmark | ||
1495478 | 1495478 | 2021-07-03 | Denmark | Greenland | 50 | 0 | 50 | 0 | 71.7069 | -42.6043 | 2021-07-04 04:21:38 | Greenland, Denmark | ||
2071793 | 2071793 | 2021-07-02 | Denmark | Greenland | 50 | 0 | 50 | 0 | 71.7069 | -42.6043 | 2021-07-03 04:21:37 | Greenland, Denmark | ||
2764809 | 2764809 | 2021-07-01 | Denmark | Greenland | 50 | 0 | 50 | 0 | 71.7069 | -42.6043 | 2021-07-02 04:21:47 | Greenland, Denmark | ||
2585806 | 2585806 | 2021-06-05 | China | Macau | 51 | 0 | 50 | 1 | 22.1667 | 113.55 | 2021-06-06 04:24:03 | Macau, China | ||
1636372 | 1636372 | 2021-04-29 | Laos | 672 | 0 | 50 | 622 | 19.85627 | 102.495496 | 2021-04-30 04:21:03 | Laos | |||
3393451 | 3393451 | 2021-04-28 | Laos | 604 | 0 | 50 | 554 | 19.85627 | 102.495496 | 2021-04-29 04:20:55 | Laos | |||
279979 | 279979 | 2021-02-24 | Chile | Unknown | 50 | 1 | 50 | 0 | 2021-02-25 05:24:57 | Unknown, Chile | ||||
1936247 | 1936247 | 2021-02-23 | Chile | Unknown | 50 | 1 | 50 | 0 | 2021-02-24 05:29:16 | Unknown, Chile | ||||
530502 | 530502 | 2021-02-22 | Chile | Unknown | 50 | 1 | 50 | 0 | 2021-02-23 05:23:41 | Unknown, Chile | ||||
181937 | 181937 | 2021-02-21 | France | New Caledonia | 55 | 0 | 50 | 5 | -20.904305 | 165.618042 | 2021-02-22 05:24:21 | New Caledonia, France | ||
181836 | 181836 | 2021-02-21 | Chile | Unknown | 50 | 1 | 50 | 0 | 2021-02-22 05:24:21 | Unknown, Chile | ||||
742211 | 742211 | 2021-02-20 | France | New Caledonia | 55 | 0 | 50 | 5 | -20.904305 | 165.618042 | 2021-02-21 05:24:33 | New Caledonia, France | ||
742110 | 742110 | 2021-02-20 | Chile | Unknown | 50 | 1 | 50 | 0 | 2021-02-21 05:24:33 | Unknown, Chile | ||||
471309 | 471309 | 2021-02-19 | France | New Caledonia | 55 | 0 | 50 | 5 | -20.904305 | 165.618042 | 2021-02-20 05:22:51 | New Caledonia, France | ||
471208 | 471208 | 2021-02-19 | Chile | Unknown | 50 | 1 | 50 | 0 | 2021-02-20 05:22:51 | Unknown, Chile | ||||
1153018 | 1153018 | 2021-02-18 | France | New Caledonia | 55 | 0 | 50 | 5 | -20.904305 | 165.618042 | 2021-02-19 05:24:16 | New Caledonia, France | ||
1152918 | 1152918 | 2021-02-18 | Chile | Unknown | 50 | 1 | 50 | 0 | 2021-02-19 05:24:16 | Unknown, Chile | ||||
3600938 | 3600938 | 2021-02-17 | France | New Caledonia | 52 | 0 | 50 | 2 | -20.904305 | 165.618042 | 2021-02-18 05:22:58 | New Caledonia, France | ||
3600838 | 3600838 | 2021-02-17 | Chile | Unknown | 50 | 1 | 50 | 0 | 2021-02-18 05:22:58 | Unknown, Chile | ||||
3049973 | 3049973 | 2021-02-16 | Chile | Unknown | 50 | 1 | 50 | 0 | 2021-02-17 05:23:10 | Unknown, Chile | ||||
1338072 | 1338072 | 2021-02-15 | Chile | Unknown | 50 | 1 | 50 | 0 | 2021-02-16 05:24:38 | Unknown, Chile | ||||
2283223 | 2283223 | 2021-02-14 | Chile | Unknown | 50 | 1 | 50 | 0 | 2021-02-15 05:24:49 | Unknown, Chile | ||||
12673 | 12673 | 2021-01-26 | Timor-Leste | 67 | 0 | 50 | 17 | -8.874217 | 125.727539 | 2021-01-27 05:23:41 | Timor-Leste | |||
2567997 | 2567997 | 2021-01-25 | Timor-Leste | 67 | 0 | 50 | 17 | -8.874217 | 125.727539 | 2021-01-26 05:22:02 | Timor-Leste | |||
1759629 | 1759629 | 2021-01-24 | Timor-Leste | 67 | 0 | 50 | 17 | -8.874217 | 125.727539 | 2021-01-25 05:22:16 | Timor-Leste | |||
3105121 | 3105121 | 2021-01-16 | Malaysia | Perlis | 85 | 2 | 50 | 33 | 6.4449 | 100.2048 | 2021-01-17 05:22:17 | Perlis, Malaysia | ||
2625669 | 2625669 | 2021-01-10 | Chile | Unknown | 53 | 1 | 50 | 2 | 2021-01-11 05:21:50 | Unknown, Chile | ||||
1350333 | 1350333 | 2020-11-24 | Japan | Iwate | 155 | 1 | 50 | 104 | 39.593287 | 141.361777 | 2020-11-25 05:27:20 | Iwate, Japan | ||
210038 | 210038 | 2020-10-29 | Chile | Unknown | 50 | 1 | 50 | 0 | 2020-10-30 04:24:49 | Unknown, Chile | ||||
754100 | 754100 | 2020-10-28 | Chile | Unknown | 50 | 1 | 50 | 0 | 2020-10-29 04:24:49 | Unknown, Chile | ||||
1452385 | 1452385 | 2020-10-27 | Chile | Unknown | 50 | 1 | 50 | 0 | 2020-10-28 04:24:39 | Unknown, Chile | ||||
3480109 | 3480109 | 2020-10-26 | Chile | Unknown | 50 | 1 | 50 | 0 | 2020-10-27 04:24:45 | Unknown, Chile | ||||
8130 | 8130 | 2020-10-25 | Chile | Unknown | 50 | 1 | 50 | 0 | 2020-10-26 04:25:02 | Unknown, Chile | ||||
3651367 | 3651367 | 2020-10-24 | Chile | Unknown | 50 | 1 | 50 | 0 | 2020-10-25 04:24:36 | Unknown, Chile | ||||
1053622 | 1053622 | 2020-10-23 | Chile | Unknown | 50 | 1 | 50 | 0 | 2020-10-24 04:24:46 | Unknown, Chile | ||||
1177292 | 1177292 | 2020-10-22 | Chile | Unknown | 50 | 1 | 50 | 0 | 2020-10-23 04:24:46 | Unknown, Chile | ||||
2191397 | 2191397 | 2020-10-21 | Chile | Unknown | 50 | 1 | 50 | 0 | 2020-10-22 04:24:27 | Unknown, Chile | ||||
3990408 | 3990408 | 2020-10-20 | Chile | Unknown | 50 | 1 | 50 | 0 | 2020-10-21 04:24:14 | Unknown, Chile | ||||
1794428 | 1794428 | 2020-10-19 | Chile | Unknown | 50 | 1 | 50 | 0 | 2020-10-20 04:24:22 | Unknown, Chile | ||||
762112 | 762112 | 2020-10-18 | Chile | Unknown | 50 | 1 | 50 | 0 | 2020-10-19 04:24:16 | Unknown, Chile | ||||
1026150 | 1026150 | 2020-10-17 | Chile | Unknown | 50 | 1 | 50 | 0 | 2020-10-18 04:24:25 | Unknown, Chile | ||||
2848841 | 2848841 | 2020-09-18 | Japan | Akita | 51 | 0 | 50 | 1 | 39.748679 | 140.408228 | 2020-09-19 04:22:00 | Akita, Japan | ||
1121590 | 1121590 | 2020-09-17 | Japan | Akita | 51 | 0 | 50 | 1 | 39.748679 | 140.408228 | 2020-09-18 05:05:00 | Akita, Japan | ||
666279 | 666279 | 2020-09-16 | Japan | Akita | 51 | 0 | 50 | 1 | 39.748679 | 140.408228 | 2020-09-17 04:22:00 | Akita, Japan | ||
2729004 | 2729004 | 2020-09-15 | Japan | Akita | 51 | 0 | 50 | 1 | 39.748679 | 140.408228 | 2020-09-16 04:22:53 | Akita, Japan | ||
344276 | 344276 | 2020-09-14 | Japan | Akita | 51 | 0 | 50 | 1 | 39.748679 | 140.408228 | 2020-09-15 03:22:50 | Akita, Japan | ||
2868715 | 2868715 | 2020-09-13 | Japan | Akita | 50 | 0 | 50 | 0 | 39.748679 | 140.408228 | 2020-09-14 04:26:00 | Akita, Japan | ||
1555986 | 1555986 | 2020-08-16 | Japan | Kagawa | 65 | 1 | 50 | 14 | 34.217292 | 133.969047 | 2020-08-17 04:27:20 | Kagawa, Japan | ||
145988 | 145988 | 2020-08-15 | Japan | Kagawa | 63 | 1 | 50 | 12 | 34.217292 | 133.969047 | 2020-08-16 04:27:42 | Kagawa, Japan | ||
1612263 | 1612263 | 2020-08-14 | Japan | Kagawa | 62 | 1 | 50 | 11 | 34.217292 | 133.969047 | 2020-08-15 04:27:31 | Kagawa, Japan | ||
3923476 | 3923476 | 2020-08-09 | Japan | Yamaguchi | 76 | 0 | 50 | 26 | 34.201190000000004 | 131.573293 | 2020-08-10 04:34:55 | Yamaguchi, Japan | ||
371644 | 371644 | 2020-08-08 | Japan | Yamaguchi | 70 | 0 | 50 | 20 | 34.201190000000004 | 131.573293 | 2020-08-09 04:34:54 | Yamaguchi, Japan | ||
98404 | 98404 | 2020-08-04 | Japan | Okayama | 94 | 0 | 50 | 44 | 34.89246 | 133.826252 | 2020-08-05 04:34:43 | Okayama, Japan | ||
2740287 | 2740287 | 2020-08-03 | Japan | Okayama | 91 | 0 | 50 | 41 | 34.89246 | 133.826252 | 2020-08-04 04:41:59 | Okayama, Japan | ||
2808039 | 2808039 | 2020-08-02 | Japan | Okayama | 88 | 0 | 50 | 38 | 34.89246 | 133.826252 | 2020-08-03 04:34:35 | Okayama, Japan | ||
3264829 | 3264829 | 2020-07-31 | Japan | Saga | 82 | 0 | 50 | 32 | 33.286977 | 130.115738 | 2020-08-01 04:36:27 | Saga, Japan | ||
177262 | 177262 | 2020-07-27 | Japan | Mie | 74 | 1 | 50 | 23 | 34.508018 | 136.376013 | 2020-07-28 04:58:43 | Mie, Japan | ||
442575 | 442575 | 2020-07-26 | Japan | Mie | 70 | 1 | 50 | 19 | 34.508018 | 136.376013 | 2020-07-27 04:35:02 | Mie, Japan | ||
3237360 | 3237360 | 2020-07-10 | Colombia | Casanare | 97 | 1 | 50 | 46 | 5.7589 | -71.5724 | 2020-07-11 04:34:26 | Casanare, Colombia | ||
2234868 | 2234868 | 2020-07-03 | Bhutan | 77 | 0 | 50 | 27 | 27.5142 | 90.4336 | 2020-07-04 04:33:51 | Bhutan | |||
3045663 | 3045663 | 2020-07-02 | Bhutan | 77 | 0 | 50 | 27 | 27.5142 | 90.4336 | 2020-07-03 04:33:54 | Bhutan | |||
303354 | 303354 | 2020-07-01 | Bhutan | 77 | 0 | 50 | 27 | 27.5142 | 90.4336 | 2020-07-02 04:33:46 | Bhutan | |||
302842 | 302842 | 2020-07-01 | India | Andaman and Nicobar Islands | 100 | 0 | 50 | 50 | 11.225999 | 92.96817800000001 | 2020-07-02 04:33:46 | Andaman and Nicobar Islands, India | ||
2974220 | 2974220 | 2020-06-30 | India | Andaman and Nicobar Islands | 97 | 0 | 50 | 47 | 11.225999 | 92.96817800000001 | 2020-07-01 04:33:52 | Andaman and Nicobar Islands, India | ||
2633092 | 2633092 | 2020-06-29 | India | Sikkim | 88 | 0 | 50 | 38 | 27.571671 | 88.472712 | 2020-06-30 04:33:48 | Sikkim, India | ||
1273640 | 1273640 | 2020-06-11 | Colombia | Santander | 202 | 7 | 50 | 145 | 6.6437 | -73.6536 | 2020-06-12 05:09:52 | Santander, Colombia | ||
2864082 | 2864082 | 2020-06-10 | Colombia | Santander | 194 | 7 | 50 | 137 | 6.6437 | -73.6536 | 2020-06-11 03:33:41 | Santander, Colombia | ||
1210908 | 1210908 | 2020-06-09 | Colombia | Santander | 167 | 6 | 50 | 111 | 6.6437 | -73.6536 | 2020-06-10 04:07:00 | Santander, Colombia | ||
217335 | 217335 | 2020-06-08 | Colombia | Santander | 167 | 6 | 50 | 111 | 6.6437 | -73.6536 | 2020-06-09 03:33:03 | Santander, Colombia | ||
2800131 | 2800131 | 2020-06-07 | Colombia | Santander | 150 | 4 | 50 | 96 | 6.6437 | -73.6536 | 2020-06-08 03:33:22 | Santander, Colombia | ||
574187 | 574187 | 2020-06-06 | Colombia | Santander | 131 | 4 | 50 | 77 | 6.6437 | -73.6536 | 2020-06-07 03:53:30 | Santander, Colombia | ||
1269884 | 1269884 | 2020-06-05 | Colombia | Santander | 131 | 4 | 50 | 77 | 6.6437 | -73.6536 | 2020-06-06 02:33:00 | Santander, Colombia | ||
2556198 | 2556198 | 2020-06-02 | Syria | 123 | 6 | 50 | 67 | 34.802075 | 38.99681500000001 | 2020-06-03 02:33:13 | Syria | |||
3639102 | 3639102 | 2020-05-30 | Libya | 130 | 5 | 50 | 75 | 26.3351 | 17.228331 | 2020-05-31 02:32:45 | Libya | |||
1790308 | 1790308 | 2020-05-29 | Japan | Ehime | 82 | 4 | 50 | 28 | 33.624835 | 132.856842 | 2020-05-30 02:32:48 | Ehime, Japan | ||
875547 | 875547 | 2020-05-24 | Mexico | Colima | 112 | 14 | 50 | 48 | 19.1223 | -104.0072 | 2020-05-25 02:32:44 | Colima, Mexico | ||
2581381 | 2581381 | 2020-05-12 | United Kingdom | Cayman Islands | 85 | 1 | 50 | 34 | 19.3133 | -81.2546 | 2020-05-13 03:32:26 | Cayman Islands, United Kingdom | ||
114233 | 114233 | 2020-05-08 | Chad | 260 | 28 | 50 | 182 | 15.4542 | 18.7322 | 2020-05-09 02:32:35 | Chad | |||
3295676 | 3295676 | 2020-05-07 | Chad | 253 | 27 | 50 | 176 | 15.4542 | 18.7322 | 2020-05-08 02:32:32 | Chad | |||
2110891 | 2110891 | 2020-05-06 | Burma | 161 | 6 | 50 | 105 | 21.9162 | 95.956 | 2020-05-07 02:32:28 | Burma | |||
2110882 | 2110882 | 2020-05-06 | Benin | 96 | 2 | 50 | 44 | 9.3077 | 2.3158 | 2020-05-07 02:32:28 | Benin | |||
1931922 | 1931922 | 2020-05-05 | Benin | 96 | 2 | 50 | 44 | 9.3077 | 2.3158 | 2020-05-06 02:32:31 | Benin | |||
3084785 | 3084785 | 2020-05-04 | Benin | 96 | 2 | 50 | 44 | 9.3077 | 2.3158 | 2020-05-05 02:32:34 | Benin | |||
228606 | 228606 | 2020-04-30 | France | French Polynesia | 58 | 0 | 50 | 8 | -17.6797 | -149.4068 | 2020-05-01 02:32:28 | French Polynesia, France | ||
137353 | 137353 | 2020-04-29 | France | French Polynesia | 58 | 0 | 50 | 8 | -17.6797 | -149.4068 | 2020-04-30 02:32:27 | French Polynesia, France | ||
271748 | 271748 | 2020-04-28 | Monaco | 95 | 4 | 50 | 41 | 43.7333 | 7.4167 | 2020-04-29 02:32:29 | Monaco | |||
271694 | 271694 | 2020-04-28 | Ethiopia | 126 | 3 | 50 | 73 | 9.145 | 40.4897 | 2020-04-29 02:32:29 | Ethiopia | |||
3589349 | 3589349 | 2020-04-27 | Ethiopia | 124 | 3 | 50 | 71 | 9.145 | 40.4897 | 2020-04-28 02:30:32 | Ethiopia | |||
3589330 | 3589330 | 2020-04-27 | Congo (Kinshasa) | 459 | 28 | 50 | 381 | -4.322447 | 15.307045 | 2020-04-28 02:30:32 | Congo (Kinshasa) | |||
3592508 | 3592508 | 2020-04-26 | Congo (Kinshasa) | 442 | 28 | 50 | 364 | -4.322447 | 15.307045 | 2020-04-27 02:30:33 | Congo (Kinshasa) | |||
3338020 | 3338020 | 2020-04-14 | France | Martinique | 157 | 6 | 50 | 101 | 14.6415 | -61.0242 | 2020-04-14 23:33:12 | Martinique, France |
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]);