johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Spain" and province_or_state = "Aragon" sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 1
- Aragon · 860 ✖
country_or_region 1
- Spain · 860 ✖
combined_key 1 ✖
- Aragon, Spain 860
Link | rowid ▲ | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3574880 | 3574880 | 2021-05-17 | Spain | Aragon | 122063 | 3492 | 3772 | 114799 | 41.5976 | -0.9057 | 2021-05-18 04:20:33 | Aragon, Spain | ||
3570888 | 3570888 | 2022-09-19 | Spain | Aragon | 456545 | 5215 | 0 | 41.5976 | -0.9057 | 2022-09-20 04:22:48 | Aragon, Spain | |||
3566850 | 3566850 | 2020-11-29 | Spain | Aragon | 72590 | 2279 | 3772 | 66539 | 41.5976 | -0.9057 | 2020-11-30 05:26:13 | Aragon, Spain | ||
3562848 | 3562848 | 2020-08-25 | Spain | Aragon | 24752 | 1096 | 3772 | 19884 | 41.5976 | -0.9057 | 2020-08-26 04:28:11 | Aragon, Spain | ||
3555936 | 3555936 | 2021-08-21 | Spain | Aragon | 155376 | 3685 | 0 | 41.5976 | -0.9057 | 2021-08-22 04:21:29 | Aragon, Spain | |||
3551941 | 3551941 | 2022-11-27 | Spain | Aragon | 462754 | 5334 | 0 | 41.5976 | -0.9057 | 2022-11-28 04:21:02 | Aragon, Spain | |||
3547796 | 3547796 | 2022-09-01 | Spain | Aragon | 455759 | 5167 | 0 | 41.5976 | -0.9057 | 2022-09-02 04:21:07 | Aragon, Spain | |||
3543780 | 3543780 | 2022-08-08 | Spain | Aragon | 453839 | 5045 | 0 | 41.5976 | -0.9057 | 2022-08-09 04:20:34 | Aragon, Spain | |||
3539743 | 3539743 | 2021-02-12 | Spain | Aragon | 103252 | 3112 | 3772 | 96368 | 41.5976 | -0.9057 | 2021-02-13 05:22:12 | Aragon, Spain | ||
3535749 | 3535749 | 2022-05-10 | Spain | Aragon | 421321 | 4731 | 0 | 41.5976 | -0.9057 | 2022-05-11 04:20:48 | Aragon, Spain | |||
3531730 | 3531730 | 2020-08-12 | Spain | Aragon | 19418 | 991 | 3772 | 14655 | 41.5976 | -0.9057 | 2020-08-13 04:29:15 | Aragon, Spain | ||
3527755 | 3527755 | 2022-06-04 | Spain | Aragon | 430228 | 4802 | 0 | 41.5976 | -0.9057 | 2022-06-05 04:20:55 | Aragon, Spain | |||
3523741 | 3523741 | 2022-11-24 | Spain | Aragon | 462298 | 5327 | 0 | 41.5976 | -0.9057 | 2022-11-25 04:21:06 | Aragon, Spain | |||
3519721 | 3519721 | 2022-01-02 | Spain | Aragon | 214247 | 4077 | 0 | 41.5976 | -0.9057 | 2022-01-03 02:22:25 | Aragon, Spain | |||
3515686 | 3515686 | 2021-01-15 | Spain | Aragon | 87008 | 2745 | 3772 | 80491 | 41.5976 | -0.9057 | 2021-01-16 05:22:40 | Aragon, Spain | ||
3511692 | 3511692 | 2021-11-01 | Spain | Aragon | 162844 | 3900 | 0 | 41.5976 | -0.9057 | 2021-11-02 04:22:03 | Aragon, Spain | |||
3507678 | 3507678 | 2022-06-05 | Spain | Aragon | 430228 | 4802 | 0 | 41.5976 | -0.9057 | 2022-06-06 04:20:57 | Aragon, Spain | |||
3503641 | 3503641 | 2021-01-17 | Spain | Aragon | 87008 | 2745 | 3772 | 80491 | 41.5976 | -0.9057 | 2021-01-18 05:22:34 | Aragon, Spain | ||
3496477 | 3496477 | 2021-12-15 | Spain | Aragon | 180654 | 4007 | 0 | 41.5976 | -0.9057 | 2021-12-16 04:22:11 | Aragon, Spain | |||
3492461 | 3492461 | 2021-10-26 | Spain | Aragon | 162658 | 3907 | 0 | 41.5976 | -0.9057 | 2021-10-27 04:22:32 | Aragon, Spain | |||
3491152 | 3491152 | 2020-07-13 | Spain | Aragon | 6861 | 915 | 3772 | 2174 | 41.5976 | -0.9057 | 2020-07-14 04:34:46 | Aragon, Spain | ||
3484585 | 3484585 | 2020-08-20 | Spain | Aragon | 23251 | 1096 | 3772 | 18383 | 41.5976 | -0.9057 | 2020-08-21 04:27:41 | Aragon, Spain | ||
3480592 | 3480592 | 2020-10-26 | Spain | Aragon | 51502 | 1598 | 3772 | 46132 | 41.5976 | -0.9057 | 2020-10-27 04:24:45 | Aragon, Spain | ||
3476598 | 3476598 | 2021-07-22 | Spain | Aragon | 140952 | 3561 | 3772 | 133619 | 41.5976 | -0.9057 | 2021-07-23 04:21:29 | Aragon, Spain | ||
3472582 | 3472582 | 2021-06-08 | Spain | Aragon | 125159 | 3521 | 3772 | 117866 | 41.5976 | -0.9057 | 2021-06-09 04:23:31 | Aragon, Spain | ||
3468464 | 3468464 | 2021-08-03 | Spain | Aragon | 148902 | 3604 | 3772 | 141526 | 41.5976 | -0.9057 | 2021-08-04 04:21:25 | Aragon, Spain | ||
3464465 | 3464465 | 2022-01-18 | Spain | Aragon | 314724 | 4270 | 0 | 41.5976 | -0.9057 | 2022-01-19 04:21:23 | Aragon, Spain | |||
3460453 | 3460453 | 2022-11-21 | Spain | Aragon | 462298 | 5327 | 0 | 41.5976 | -0.9057 | 2022-11-22 04:20:47 | Aragon, Spain | |||
3453141 | 3453141 | 2021-03-18 | Spain | Aragon | 109093 | 3354 | 3772 | 101967 | 41.5976 | -0.9057 | 2021-03-19 05:26:09 | Aragon, Spain | ||
3449130 | 3449130 | 2021-09-10 | Spain | Aragon | 159186 | 3762 | 0 | 41.5976 | -0.9057 | 2021-09-11 04:21:30 | Aragon, Spain | |||
3445132 | 3445132 | 2022-05-11 | Spain | Aragon | 421321 | 4731 | 0 | 41.5976 | -0.9057 | 2022-05-12 04:20:54 | Aragon, Spain | |||
3441097 | 3441097 | 2020-11-11 | Spain | Aragon | 66323 | 1911 | 3772 | 60640 | 41.5976 | -0.9057 | 2020-11-12 05:25:55 | Aragon, Spain | ||
3437118 | 3437118 | 2022-04-22 | Spain | Aragon | 413634 | 4678 | 0 | 41.5976 | -0.9057 | 2022-04-23 04:20:50 | Aragon, Spain | |||
3435809 | 3435809 | 2020-07-11 | Spain | Aragon | 6632 | 915 | 3772 | 1945 | 41.5976 | -0.9057 | 2020-07-12 04:34:30 | Aragon, Spain | ||
3429255 | 3429255 | 2022-07-14 | Spain | Aragon | 446868 | 4913 | 0 | 41.5976 | -0.9057 | 2022-07-15 04:20:53 | Aragon, Spain | |||
3425237 | 3425237 | 2022-01-21 | Spain | Aragon | 330909 | 4315 | 0 | 41.5976 | -0.9057 | 2022-01-22 04:21:13 | Aragon, Spain | |||
3421203 | 3421203 | 2021-03-19 | Spain | Aragon | 109093 | 3354 | 3772 | 101967 | 41.5976 | -0.9057 | 2021-03-20 05:25:46 | Aragon, Spain | ||
3417208 | 3417208 | 2022-04-17 | Spain | Aragon | 410714 | 4649 | 0 | 41.5976 | -0.9057 | 2022-04-18 04:21:12 | Aragon, Spain | |||
3416229 | 3416229 | 2020-05-17 | Spain | Aragon | 5456 | 838 | 3655 | 963 | 41.5976 | -0.9057 | 2020-05-18 02:32:21 | Aragon, Spain | ||
3409725 | 3409725 | 2020-11-01 | Spain | Aragon | 56181 | 1654 | 3772 | 50755 | 41.5976 | -0.9057 | 2020-11-02 05:25:04 | Aragon, Spain | ||
3405747 | 3405747 | 2022-07-17 | Spain | Aragon | 448688 | 4936 | 0 | 41.5976 | -0.9057 | 2022-07-18 04:20:59 | Aragon, Spain | |||
3401729 | 3401729 | 2021-11-30 | Spain | Aragon | 169888 | 3952 | 0 | 41.5976 | -0.9057 | 2021-12-01 04:22:29 | Aragon, Spain | |||
3397715 | 3397715 | 2022-06-18 | Spain | Aragon | 434116 | 4848 | 0 | 41.5976 | -0.9057 | 2022-06-19 04:20:51 | Aragon, Spain | |||
3393679 | 3393679 | 2021-04-28 | Spain | Aragon | 117618 | 3437 | 3772 | 110409 | 41.5976 | -0.9057 | 2021-04-29 04:20:55 | Aragon, Spain | ||
3389669 | 3389669 | 2020-10-02 | Spain | Aragon | 37071 | 1411 | 3772 | 31888 | 41.5976 | -0.9057 | 2020-10-03 04:23:40 | Aragon, Spain | ||
3385676 | 3385676 | 2021-07-29 | Spain | Aragon | 144767 | 3574 | 3772 | 137421 | 41.5976 | -0.9057 | 2021-07-30 04:21:34 | Aragon, Spain | ||
3381660 | 3381660 | 2021-06-13 | Spain | Aragon | 125490 | 3530 | 3772 | 118188 | 41.5976 | -0.9057 | 2021-06-14 04:22:46 | Aragon, Spain | ||
3377667 | 3377667 | 2022-12-08 | Spain | Aragon | 463000 | 5367 | 0 | 41.5976 | -0.9057 | 2022-12-09 04:21:05 | Aragon, Spain | |||
3373651 | 3373651 | 2022-09-17 | Spain | Aragon | 456545 | 5215 | 0 | 41.5976 | -0.9057 | 2022-09-18 04:22:50 | Aragon, Spain | |||
3369613 | 3369613 | 2021-03-21 | Spain | Aragon | 109093 | 3354 | 3772 | 101967 | 41.5976 | -0.9057 | 2021-03-22 05:25:43 | Aragon, Spain | ||
3365619 | 3365619 | 2022-07-02 | Spain | Aragon | 440762 | 4885 | 0 | 41.5976 | -0.9057 | 2022-07-03 04:20:59 | Aragon, Spain | |||
3358956 | 3358956 | 2021-06-21 | Spain | Aragon | 126177 | 3537 | 3772 | 118868 | 41.5976 | -0.9057 | 2021-06-22 04:21:34 | Aragon, Spain | ||
3354958 | 3354958 | 2022-05-14 | Spain | Aragon | 423226 | 4738 | 0 | 41.5976 | -0.9057 | 2022-05-15 04:20:53 | Aragon, Spain | |||
3350942 | 3350942 | 2022-04-01 | Spain | Aragon | 408723 | 4638 | 0 | 41.5976 | -0.9057 | 2022-04-02 04:20:47 | Aragon, Spain | |||
3346927 | 3346927 | 2022-06-24 | Spain | Aragon | 436827 | 4874 | 0 | 41.5976 | -0.9057 | 2022-06-25 04:20:57 | Aragon, Spain | |||
3342909 | 3342909 | 2021-11-16 | Spain | Aragon | 164987 | 3922 | 0 | 41.5976 | -0.9057 | 2021-11-17 04:21:48 | Aragon, Spain | |||
3338875 | 3338875 | 2020-11-17 | Spain | Aragon | 69196 | 2067 | 3772 | 63357 | 41.5976 | -0.9057 | 2020-11-18 05:40:31 | Aragon, Spain | ||
3331817 | 3331817 | 2021-07-21 | Spain | Aragon | 139985 | 3563 | 3772 | 132650 | 41.5976 | -0.9057 | 2021-07-22 04:21:19 | Aragon, Spain | ||
3324548 | 3324548 | 2022-12-16 | Spain | Aragon | 463561 | 5389 | 0 | 41.5976 | -0.9057 | 2022-12-17 04:21:04 | Aragon, Spain | |||
3320529 | 3320529 | 2022-04-07 | Spain | Aragon | 409239 | 4646 | 0 | 41.5976 | -0.9057 | 2022-04-08 04:20:48 | Aragon, Spain | |||
3316498 | 3316498 | 2020-09-22 | Spain | Aragon | 33742 | 1335 | 3772 | 28635 | 41.5976 | -0.9057 | 2020-09-23 04:23:00 | Aragon, Spain | ||
3312524 | 3312524 | 2022-11-23 | Spain | Aragon | 462298 | 5327 | 0 | 41.5976 | -0.9057 | 2022-11-24 04:21:09 | Aragon, Spain | |||
3308486 | 3308486 | 2021-01-13 | Spain | Aragon | 85261 | 2724 | 3772 | 78765 | 41.5976 | -0.9057 | 2021-01-14 05:22:32 | Aragon, Spain | ||
3304476 | 3304476 | 2020-11-02 | Spain | Aragon | 59244 | 1691 | 3772 | 53781 | 41.5976 | -0.9057 | 2020-11-03 06:00:16 | Aragon, Spain | ||
3300496 | 3300496 | 2022-01-30 | Spain | Aragon | 358499 | 4430 | 0 | 41.5976 | -0.9057 | 2022-01-31 04:21:09 | Aragon, Spain | |||
3296465 | 3296465 | 2021-07-30 | Spain | Aragon | 145855 | 3580 | 3772 | 138503 | 41.5976 | -0.9057 | 2021-07-31 04:21:35 | Aragon, Spain | ||
3289203 | 3289203 | 2021-11-18 | Spain | Aragon | 165565 | 3926 | 0 | 41.5976 | -0.9057 | 2021-11-19 04:21:40 | Aragon, Spain | |||
3285191 | 3285191 | 2022-10-31 | Spain | Aragon | 460890 | 5289 | 0 | 41.5976 | -0.9057 | 2022-11-01 04:22:36 | Aragon, Spain | |||
3281156 | 3281156 | 2021-09-05 | Spain | Aragon | 158235 | 3740 | 0 | 41.5976 | -0.9057 | 2021-09-06 04:21:22 | Aragon, Spain | |||
3277161 | 3277161 | 2022-10-23 | Spain | Aragon | 460038 | 5270 | 0 | 41.5976 | -0.9057 | 2022-10-24 04:22:29 | Aragon, Spain | |||
3276179 | 3276179 | 2020-05-15 | Spain | Aragon | 5432 | 837 | 3534 | 1061 | 41.5976 | -0.9057 | 2020-05-16 02:32:19 | Aragon, Spain | ||
3269803 | 3269803 | 2022-06-19 | Spain | Aragon | 434116 | 4848 | 0 | 41.5976 | -0.9057 | 2022-06-20 04:21:01 | Aragon, Spain | |||
3265786 | 3265786 | 2022-05-04 | Spain | Aragon | 418053 | 4715 | 0 | 41.5976 | -0.9057 | 2022-05-05 04:20:55 | Aragon, Spain | |||
3264464 | 3264464 | 2020-07-31 | Spain | Aragon | 12685 | 915 | 3772 | 7998 | 41.5976 | -0.9057 | 2020-08-01 04:36:27 | Aragon, Spain | ||
3260835 | 3260835 | 2020-05-18 | Spain | Aragon | 5503 | 838 | 3772 | 893 | 41.5976 | -0.9057 | 2020-05-19 02:32:18 | Aragon, Spain | ||
3254431 | 3254431 | 2021-03-02 | Spain | Aragon | 106998 | 3281 | 3772 | 99945 | 41.5976 | -0.9057 | 2021-03-03 05:23:28 | Aragon, Spain | ||
3250439 | 3250439 | 2022-10-11 | Spain | Aragon | 458388 | 5239 | 0 | 41.5976 | -0.9057 | 2022-10-12 04:22:51 | Aragon, Spain | |||
3249129 | 3249129 | 2020-06-21 | Spain | Aragon | 5931 | 911 | 3772 | 1248 | 41.5976 | -0.9057 | 2020-06-22 04:33:20 | Aragon, Spain | ||
3242611 | 3242611 | 2021-04-21 | Spain | Aragon | 115746 | 3415 | 3772 | 108559 | 41.5976 | -0.9057 | 2021-04-22 04:20:53 | Aragon, Spain | ||
3238616 | 3238616 | 2022-03-21 | Spain | Aragon | 404159 | 4961 | 0 | 41.5976 | -0.9057 | 2022-03-22 04:20:54 | Aragon, Spain | |||
3237307 | 3237307 | 2020-07-10 | Spain | Aragon | 6632 | 915 | 3772 | 1945 | 41.5976 | -0.9057 | 2020-07-11 04:34:26 | Aragon, Spain | ||
3230734 | 3230734 | 2021-01-03 | Spain | Aragon | 80023 | 2634 | 3772 | 73617 | 41.5976 | -0.9057 | 2021-01-04 05:22:02 | Aragon, Spain | ||
3226740 | 3226740 | 2022-01-19 | Spain | Aragon | 320326 | 4282 | 0 | 41.5976 | -0.9057 | 2022-01-20 04:21:07 | Aragon, Spain | |||
3222728 | 3222728 | 2022-12-25 | Spain | Aragon | 463877 | 5401 | 0 | 41.5976 | -0.9057 | 2022-12-26 04:21:06 | Aragon, Spain | |||
3218585 | 3218585 | 2021-07-26 | Spain | Aragon | 143315 | 3562 | 3772 | 135981 | 41.5976 | -0.9057 | 2021-07-27 04:21:18 | Aragon, Spain | ||
3214590 | 3214590 | 2022-10-12 | Spain | Aragon | 458388 | 5239 | 0 | 41.5976 | -0.9057 | 2022-10-13 04:22:39 | Aragon, Spain | |||
3210572 | 3210572 | 2022-07-18 | Spain | Aragon | 448688 | 4936 | 0 | 41.5976 | -0.9057 | 2022-07-19 04:20:58 | Aragon, Spain | |||
3206555 | 3206555 | 2022-04-11 | Spain | Aragon | 409988 | 4649 | 0 | 41.5976 | -0.9057 | 2022-04-12 04:20:49 | Aragon, Spain | |||
3205078 | 3205078 | 2020-07-18 | Spain | Aragon | 7639 | 915 | 3772 | 2952 | 41.5976 | -0.9057 | 2020-07-19 04:34:58 | Aragon, Spain | ||
3198430 | 3198430 | 2022-05-29 | Spain | Aragon | 428363 | 4782 | 0 | 41.5976 | -0.9057 | 2022-05-30 04:20:50 | Aragon, Spain | |||
3194288 | 3194288 | 2021-09-06 | Spain | Aragon | 158631 | 3745 | 0 | 41.5976 | -0.9057 | 2021-09-07 04:21:35 | Aragon, Spain | |||
3190271 | 3190271 | 2020-11-22 | Spain | Aragon | 70624 | 2148 | 3772 | 64704 | 41.5976 | -0.9057 | 2020-11-23 05:25:26 | Aragon, Spain | ||
3186281 | 3186281 | 2022-05-30 | Spain | Aragon | 428363 | 4782 | 0 | 41.5976 | -0.9057 | 2022-05-31 04:20:51 | Aragon, Spain | |||
3184955 | 3184955 | 2020-07-28 | Spain | Aragon | 11377 | 915 | 3772 | 6690 | 41.5976 | -0.9057 | 2020-07-29 04:35:11 | Aragon, Spain | ||
3178288 | 3178288 | 2020-08-18 | Spain | Aragon | 22269 | 994 | 3772 | 17503 | 41.5976 | -0.9057 | 2020-08-19 04:27:00 | Aragon, Spain | ||
3174080 | 3174080 | 2022-12-19 | Spain | Aragon | 463561 | 5389 | 0 | 41.5976 | -0.9057 | 2022-12-20 04:21:04 | Aragon, Spain | |||
3169920 | 3169920 | 2020-11-16 | Spain | Aragon | 68814 | 2039 | 3772 | 63003 | 41.5976 | -0.9057 | 2020-11-17 05:25:54 | Aragon, Spain | ||
3165913 | 3165913 | 2021-08-23 | Spain | Aragon | 155973 | 3684 | 0 | 41.5976 | -0.9057 | 2021-08-24 04:21:19 | Aragon, Spain | |||
3161901 | 3161901 | 2020-09-06 | Spain | Aragon | 27493 | 1212 | 3772 | 22509 | 41.5976 | -0.9057 | 2020-09-07 04:28:30 | Aragon, Spain | ||
3157926 | 3157926 | 2022-06-09 | Spain | Aragon | 431036 | 4814 | 0 | 41.5976 | -0.9057 | 2022-06-10 04:20:55 | Aragon, Spain |
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]);