johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,033 rows where country_or_region = "Andorra" sorted by recovered descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, recovered, active, day (date), last_update (date)
country_or_region 1
- Andorra · 1,033 ✖
province_or_state 0
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▲ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331596 | 331596 | 2021-08-04 | Andorra | 14797 | 128 | 14380 | 289 | 42.5063 | 1.5218 | 2021-08-05 04:21:51 | Andorra | |||
3467867 | 3467867 | 2021-08-03 | Andorra | 14766 | 128 | 14348 | 290 | 42.5063 | 1.5218 | 2021-08-04 04:21:25 | Andorra | |||
3683141 | 3683141 | 2021-08-02 | Andorra | 14747 | 128 | 14296 | 323 | 42.5063 | 1.5218 | 2021-08-03 04:21:39 | Andorra | |||
3015040 | 3015040 | 2021-08-01 | Andorra | 14678 | 128 | 14210 | 340 | 42.5063 | 1.5218 | 2021-08-02 04:21:36 | Andorra | |||
3295868 | 3295868 | 2021-07-30 | Andorra | 14678 | 128 | 14210 | 340 | 42.5063 | 1.5218 | 2021-07-31 04:21:35 | Andorra | |||
3903663 | 3903663 | 2021-07-31 | Andorra | 14678 | 128 | 14210 | 340 | 42.5063 | 1.5218 | 2021-08-01 04:21:50 | Andorra | |||
3385079 | 3385079 | 2021-07-29 | Andorra | 14655 | 127 | 14180 | 348 | 42.5063 | 1.5218 | 2021-07-30 04:21:34 | Andorra | |||
407984 | 407984 | 2021-07-28 | Andorra | 14586 | 127 | 14113 | 346 | 42.5063 | 1.5218 | 2021-07-29 04:21:33 | Andorra | |||
1305845 | 1305845 | 2021-07-27 | Andorra | 14586 | 127 | 14113 | 346 | 42.5063 | 1.5218 | 2021-07-28 04:21:39 | Andorra | |||
3217988 | 3217988 | 2021-07-26 | Andorra | 14577 | 127 | 14077 | 373 | 42.5063 | 1.5218 | 2021-07-27 04:21:18 | Andorra | |||
1329937 | 1329937 | 2021-07-24 | Andorra | 14498 | 127 | 13988 | 383 | 42.5063 | 1.5218 | 2021-07-25 04:22:12 | Andorra | |||
1378197 | 1378197 | 2021-07-25 | Andorra | 14498 | 127 | 13988 | 383 | 42.5063 | 1.5218 | 2021-07-26 04:21:28 | Andorra | |||
3137241 | 3137241 | 2021-07-23 | Andorra | 14498 | 127 | 13988 | 383 | 42.5063 | 1.5218 | 2021-07-24 00:21:36 | Andorra | |||
3476001 | 3476001 | 2021-07-22 | Andorra | 14464 | 127 | 13988 | 349 | 42.5063 | 1.5218 | 2021-07-23 04:21:29 | Andorra | |||
2371201 | 2371201 | 2021-07-20 | Andorra | 14379 | 127 | 13930 | 322 | 42.5063 | 1.5218 | 2021-07-21 04:21:40 | Andorra | |||
3331220 | 3331220 | 2021-07-21 | Andorra | 14379 | 127 | 13930 | 322 | 42.5063 | 1.5218 | 2021-07-22 04:21:19 | Andorra | |||
483280 | 483280 | 2021-07-19 | Andorra | 14359 | 127 | 13897 | 335 | 42.5063 | 1.5218 | 2021-07-20 04:21:48 | Andorra | |||
2673503 | 2673503 | 2021-07-18 | Andorra | 14273 | 127 | 13844 | 302 | 42.5063 | 1.5218 | 2021-07-19 04:21:24 | Andorra | |||
2947046 | 2947046 | 2021-07-16 | Andorra | 14273 | 127 | 13844 | 302 | 42.5063 | 1.5218 | 2021-07-17 04:22:22 | Andorra | |||
3705815 | 3705815 | 2021-07-17 | Andorra | 14273 | 127 | 13844 | 302 | 42.5063 | 1.5218 | 2021-07-18 04:22:07 | Andorra | |||
295702 | 295702 | 2021-07-15 | Andorra | 14239 | 127 | 13829 | 283 | 42.5063 | 1.5218 | 2021-07-16 04:21:22 | Andorra | |||
578522 | 578522 | 2021-07-13 | Andorra | 14167 | 127 | 13796 | 244 | 42.5063 | 1.5218 | 2021-07-14 04:21:35 | Andorra | |||
3631647 | 3631647 | 2021-07-14 | Andorra | 14167 | 127 | 13796 | 244 | 42.5063 | 1.5218 | 2021-07-15 04:21:48 | Andorra | |||
3740771 | 3740771 | 2021-07-12 | Andorra | 14155 | 127 | 13787 | 241 | 42.5063 | 1.5218 | 2021-07-13 04:21:18 | Andorra | |||
625568 | 625568 | 2021-07-10 | Andorra | 14075 | 127 | 13770 | 178 | 42.5063 | 1.5218 | 2021-07-11 04:21:43 | Andorra | |||
829287 | 829287 | 2021-07-09 | Andorra | 14075 | 127 | 13770 | 178 | 42.5063 | 1.5218 | 2021-07-10 04:21:25 | Andorra | |||
3659284 | 3659284 | 2021-07-11 | Andorra | 14075 | 127 | 13770 | 178 | 42.5063 | 1.5218 | 2021-07-12 04:21:34 | Andorra | |||
778051 | 778051 | 2021-07-08 | Andorra | 14050 | 127 | 13760 | 163 | 42.5063 | 1.5218 | 2021-07-09 04:21:21 | Andorra | |||
1440273 | 1440273 | 2021-07-07 | Andorra | 14021 | 127 | 13757 | 137 | 42.5063 | 1.5218 | 2021-07-08 04:21:26 | Andorra | |||
2693378 | 2693378 | 2021-07-06 | Andorra | 13991 | 127 | 13752 | 112 | 42.5063 | 1.5218 | 2021-07-07 04:21:20 | Andorra | |||
1164858 | 1164858 | 2021-07-04 | Andorra | 13918 | 127 | 13721 | 70 | 42.5063 | 1.5218 | 2021-07-05 04:21:28 | Andorra | |||
1495292 | 1495292 | 2021-07-03 | Andorra | 13918 | 127 | 13721 | 70 | 42.5063 | 1.5218 | 2021-07-04 04:21:38 | Andorra | |||
1932127 | 1932127 | 2021-07-05 | Andorra | 13918 | 127 | 13721 | 70 | 42.5063 | 1.5218 | 2021-07-06 04:21:32 | Andorra | |||
2071607 | 2071607 | 2021-07-02 | Andorra | 13918 | 127 | 13721 | 70 | 42.5063 | 1.5218 | 2021-07-03 04:21:37 | Andorra | |||
2764623 | 2764623 | 2021-07-01 | Andorra | 13918 | 127 | 13721 | 70 | 42.5063 | 1.5218 | 2021-07-02 04:21:47 | Andorra | |||
1892831 | 1892831 | 2021-06-30 | Andorra | 13911 | 127 | 13720 | 64 | 42.5063 | 1.5218 | 2021-07-01 04:21:19 | Andorra | |||
399954 | 399954 | 2021-06-29 | Andorra | 13900 | 127 | 13717 | 56 | 42.5063 | 1.5218 | 2021-06-30 04:21:41 | Andorra | |||
1712015 | 1712015 | 2021-06-25 | Andorra | 13882 | 127 | 13697 | 58 | 42.5063 | 1.5218 | 2021-06-26 04:21:43 | Andorra | |||
2589692 | 2589692 | 2021-06-27 | Andorra | 13882 | 127 | 13697 | 58 | 42.5063 | 1.5218 | 2021-06-28 04:21:29 | Andorra | |||
3125197 | 3125197 | 2021-06-28 | Andorra | 13882 | 127 | 13697 | 58 | 42.5063 | 1.5218 | 2021-06-29 04:21:28 | Andorra | |||
3958196 | 3958196 | 2021-06-26 | Andorra | 13882 | 127 | 13697 | 58 | 42.5063 | 1.5218 | 2021-06-27 04:21:39 | Andorra | |||
2295140 | 2295140 | 2021-06-24 | Andorra | 13877 | 127 | 13694 | 56 | 42.5063 | 1.5218 | 2021-06-25 04:21:33 | Andorra | |||
2422580 | 2422580 | 2021-06-23 | Andorra | 13873 | 127 | 13688 | 58 | 42.5063 | 1.5218 | 2021-06-24 04:21:55 | Andorra | |||
562657 | 562657 | 2021-06-22 | Andorra | 13864 | 127 | 13665 | 72 | 42.5063 | 1.5218 | 2021-06-23 04:21:46 | Andorra | |||
3358359 | 3358359 | 2021-06-21 | Andorra | 13864 | 127 | 13665 | 72 | 42.5063 | 1.5218 | 2021-06-22 04:21:34 | Andorra | |||
107141 | 107141 | 2021-06-19 | Andorra | 13842 | 127 | 13650 | 65 | 42.5063 | 1.5218 | 2021-06-20 04:21:48 | Andorra | |||
1125284 | 1125284 | 2021-06-18 | Andorra | 13842 | 127 | 13650 | 65 | 42.5063 | 1.5218 | 2021-06-19 04:22:33 | Andorra | |||
2884058 | 2884058 | 2021-06-20 | Andorra | 13842 | 127 | 13650 | 65 | 42.5063 | 1.5218 | 2021-06-21 04:21:41 | Andorra | |||
2910862 | 2910862 | 2021-06-17 | Andorra | 13839 | 127 | 13640 | 72 | 42.5063 | 1.5218 | 2021-06-18 04:22:16 | Andorra | |||
3029980 | 3029980 | 2021-06-16 | Andorra | 13836 | 127 | 13633 | 76 | 42.5063 | 1.5218 | 2021-06-17 04:22:36 | Andorra | |||
2339086 | 2339086 | 2021-06-15 | Andorra | 13828 | 127 | 13626 | 75 | 42.5063 | 1.5218 | 2021-06-16 04:22:32 | Andorra | |||
1563782 | 1563782 | 2021-06-14 | Andorra | 13826 | 127 | 13618 | 81 | 42.5063 | 1.5218 | 2021-06-15 04:22:22 | Andorra | |||
1736199 | 1736199 | 2021-06-12 | Andorra | 13813 | 127 | 13591 | 95 | 42.5063 | 1.5218 | 2021-06-13 04:22:44 | Andorra | |||
3381065 | 3381065 | 2021-06-13 | Andorra | 13813 | 127 | 13591 | 95 | 42.5063 | 1.5218 | 2021-06-14 04:22:46 | Andorra | |||
3970240 | 3970240 | 2021-06-11 | Andorra | 13813 | 127 | 13591 | 95 | 42.5063 | 1.5218 | 2021-06-12 04:22:22 | Andorra | |||
2716662 | 2716662 | 2021-06-10 | Andorra | 13805 | 127 | 13578 | 100 | 42.5063 | 1.5218 | 2021-06-11 04:23:20 | Andorra | |||
522547 | 522547 | 2021-06-09 | Andorra | 13791 | 127 | 13569 | 95 | 42.5063 | 1.5218 | 2021-06-10 04:23:17 | Andorra | |||
3145271 | 3145271 | 2021-06-07 | Andorra | 13777 | 127 | 13557 | 93 | 42.5063 | 1.5218 | 2021-06-08 04:22:35 | Andorra | |||
3471987 | 3471987 | 2021-06-08 | Andorra | 13781 | 127 | 13557 | 97 | 42.5063 | 1.5218 | 2021-06-09 04:23:31 | Andorra | |||
825273 | 825273 | 2021-06-06 | Andorra | 13758 | 127 | 13527 | 104 | 42.5063 | 1.5218 | 2021-06-07 04:22:51 | Andorra | |||
1448277 | 1448277 | 2021-06-03 | Andorra | 13752 | 127 | 13527 | 98 | 42.5063 | 1.5218 | 2021-06-04 04:23:37 | Andorra | |||
2314992 | 2314992 | 2021-06-04 | Andorra | 13758 | 127 | 13527 | 104 | 42.5063 | 1.5218 | 2021-06-05 04:23:03 | Andorra | |||
2585678 | 2585678 | 2021-06-05 | Andorra | 13758 | 127 | 13527 | 104 | 42.5063 | 1.5218 | 2021-06-06 04:24:03 | Andorra | |||
1708001 | 1708001 | 2021-06-02 | Andorra | 13744 | 127 | 13507 | 110 | 42.5063 | 1.5218 | 2021-06-03 04:23:32 | Andorra | |||
2103819 | 2103819 | 2021-06-01 | Andorra | 13729 | 127 | 13479 | 123 | 42.5063 | 1.5218 | 2021-06-02 04:24:34 | Andorra | |||
1188435 | 1188435 | 2021-05-31 | Andorra | 13727 | 127 | 13458 | 142 | 42.5063 | 1.5218 | 2021-06-01 04:23:09 | Andorra | |||
20060 | 20060 | 2021-05-28 | Andorra | 13693 | 127 | 13416 | 150 | 42.5063 | 1.5218 | 2021-05-29 04:20:41 | Andorra | |||
50481 | 50481 | 2021-05-29 | Andorra | 13693 | 127 | 13416 | 150 | 42.5063 | 1.5218 | 2021-05-30 04:20:55 | Andorra | |||
3089112 | 3089112 | 2021-05-30 | Andorra | 13693 | 127 | 13416 | 150 | 42.5063 | 1.5218 | 2021-05-31 03:08:59 | Andorra | |||
1806435 | 1806435 | 2021-05-27 | Andorra | 13682 | 127 | 13405 | 150 | 42.5063 | 1.5218 | 2021-05-28 04:20:36 | Andorra | |||
1309859 | 1309859 | 2021-05-26 | Andorra | 13671 | 127 | 13381 | 163 | 42.5063 | 1.5218 | 2021-05-27 04:20:59 | Andorra | |||
82785 | 82785 | 2021-05-25 | Andorra | 13664 | 127 | 13263 | 274 | 42.5063 | 1.5218 | 2021-05-26 04:20:35 | Andorra | |||
726188 | 726188 | 2021-05-22 | Andorra | 13569 | 127 | 13234 | 208 | 42.5063 | 1.5218 | 2021-05-23 04:20:51 | Andorra | |||
1412747 | 1412747 | 2021-05-24 | Andorra | 13569 | 127 | 13234 | 208 | 42.5063 | 1.5218 | 2021-05-25 04:21:08 | Andorra | |||
1771033 | 1771033 | 2021-05-23 | Andorra | 13569 | 127 | 13234 | 208 | 42.5063 | 1.5218 | 2021-05-24 04:20:53 | Andorra | |||
1912902 | 1912902 | 2021-05-20 | Andorra | 13569 | 127 | 13234 | 208 | 42.5063 | 1.5218 | 2021-05-21 04:20:43 | Andorra | |||
1952203 | 1952203 | 2021-05-21 | Andorra | 13569 | 127 | 13234 | 208 | 42.5063 | 1.5218 | 2021-05-22 04:20:45 | Andorra | |||
2255423 | 2255423 | 2021-05-19 | Andorra | 13569 | 127 | 13234 | 208 | 42.5063 | 1.5218 | 2021-05-20 04:21:05 | Andorra | |||
2390461 | 2390461 | 2021-05-18 | Andorra | 13569 | 127 | 13234 | 208 | 42.5063 | 1.5218 | 2021-05-19 04:20:42 | Andorra | |||
3574286 | 3574286 | 2021-05-17 | Andorra | 13555 | 127 | 13211 | 217 | 42.5063 | 1.5218 | 2021-05-18 04:20:33 | Andorra | |||
1081615 | 1081615 | 2021-05-14 | Andorra | 13510 | 127 | 13155 | 228 | 42.5063 | 1.5218 | 2021-05-15 04:20:58 | Andorra | |||
1872646 | 1872646 | 2021-05-15 | Andorra | 13510 | 127 | 13155 | 228 | 42.5063 | 1.5218 | 2021-05-16 04:20:49 | Andorra | |||
2939016 | 2939016 | 2021-05-16 | Andorra | 13510 | 127 | 13155 | 228 | 42.5063 | 1.5218 | 2021-05-17 04:20:34 | Andorra | |||
2004351 | 2004351 | 2021-05-12 | Andorra | 13470 | 127 | 13104 | 239 | 42.5063 | 1.5218 | 2021-05-13 04:20:51 | Andorra | |||
3053881 | 3053881 | 2021-05-13 | Andorra | 13470 | 127 | 13104 | 239 | 42.5063 | 1.5218 | 2021-05-14 04:20:41 | Andorra | |||
3954182 | 3954182 | 2021-05-11 | Andorra | 13447 | 127 | 13070 | 250 | 42.5063 | 1.5218 | 2021-05-12 04:21:29 | Andorra | |||
2820461 | 2820461 | 2021-05-10 | Andorra | 13429 | 127 | 13021 | 281 | 42.5063 | 1.5218 | 2021-05-11 04:20:41 | Andorra | |||
1424793 | 1424793 | 2021-05-09 | Andorra | 13423 | 127 | 12995 | 301 | 42.5063 | 1.5218 | 2021-05-10 04:20:38 | Andorra | |||
1551661 | 1551661 | 2021-05-08 | Andorra | 13406 | 127 | 12962 | 317 | 42.5063 | 1.5218 | 2021-05-09 04:20:35 | Andorra | |||
2501719 | 2501719 | 2021-05-07 | Andorra | 13390 | 127 | 12936 | 327 | 42.5063 | 1.5218 | 2021-05-08 04:21:04 | Andorra | |||
3113175 | 3113175 | 2021-05-06 | Andorra | 13363 | 127 | 12900 | 336 | 42.5063 | 1.5218 | 2021-05-07 04:20:40 | Andorra | |||
645642 | 645642 | 2021-05-05 | Andorra | 13340 | 127 | 12884 | 329 | 42.5063 | 1.5218 | 2021-05-06 04:20:38 | Andorra | |||
3675342 | 3675342 | 2021-05-04 | Andorra | 13316 | 127 | 12818 | 371 | 42.5063 | 1.5218 | 2021-05-05 04:20:43 | Andorra | |||
2760609 | 2760609 | 2021-05-03 | Andorra | 13295 | 127 | 12793 | 375 | 42.5063 | 1.5218 | 2021-05-04 04:20:34 | Andorra | |||
2450462 | 2450462 | 2021-05-02 | Andorra | 13282 | 127 | 12753 | 402 | 42.5063 | 1.5218 | 2021-05-03 04:20:39 | Andorra | |||
379883 | 379883 | 2021-04-30 | Andorra | 13232 | 125 | 12684 | 423 | 42.5063 | 1.5218 | 2021-05-01 04:20:47 | Andorra | |||
2824475 | 2824475 | 2021-05-01 | Andorra | 13232 | 125 | 12684 | 423 | 42.5063 | 1.5218 | 2021-05-02 04:20:48 | Andorra | |||
1636006 | 1636006 | 2021-04-29 | Andorra | 13198 | 125 | 12650 | 423 | 42.5063 | 1.5218 | 2021-04-30 04:21:03 | Andorra | |||
3393085 | 3393085 | 2021-04-28 | Andorra | 13148 | 125 | 12590 | 433 | 42.5063 | 1.5218 | 2021-04-29 04:20:55 | Andorra | |||
3701801 | 3701801 | 2021-04-27 | Andorra | 13121 | 124 | 12561 | 436 | 42.5063 | 1.5218 | 2021-04-28 04:20:32 | Andorra |
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]);