johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

1,138 rows where country_or_region = "Spain" sorted by day descending

View and edit SQL

country_or_region

  • Spain · 1,138
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
311643 2020-07-04 Spain Andalusia     13205 1433 10671 1101 37.5443 -4.7278 2020-07-05 04:33:46 Andalusia, Spain
311652 2020-07-04 Spain Aragon     6412 912 3772 1728 41.5976 -0.9057 2020-07-05 04:33:46 Aragon, Spain
311662 2020-07-04 Spain Asturias     2435 334 1063 1038 43.3614 -5.8593 2020-07-05 04:33:46 Asturias, Spain
311673 2020-07-04 Spain Baleares     2228 224 1533 471 39.710358 2.995148 2020-07-05 04:33:46 Baleares, Spain
311694 2020-07-04 Spain C. Valenciana     11630 1432 9970 228 39.484 -0.7533 2020-07-05 04:33:46 C. Valenciana, Spain
311701 2020-07-04 Spain Canarias     2436 162 1537 737 28.2916 -16.6291 2020-07-05 04:33:46 Canarias, Spain
311702 2020-07-04 Spain Cantabria     2364 216 2287 -139 43.1828 -3.9878 2020-07-05 04:33:46 Cantabria, Spain
311706 2020-07-04 Spain Castilla - La Mancha     18209 3026 6392 8791 39.2796 -3.0977 2020-07-05 04:33:46 Castilla - La Mancha, Spain
311707 2020-07-04 Spain Castilla y Leon     19753 2787 8716 8250 41.8357 -4.3976 2020-07-05 04:33:46 Castilla y Leon, Spain
311708 2020-07-04 Spain Catalonia     62057 5673 26203 30181 41.5912 1.5209 2020-07-05 04:33:46 Catalonia, Spain
311713 2020-07-04 Spain Ceuta     163 4 163 -4 35.8894 -5.3213 2020-07-05 04:33:46 Ceuta, Spain
311752 2020-07-04 Spain Extremadura     3047 519 2652 -124 39.4937 -6.0679 2020-07-05 04:33:46 Extremadura, Spain
311762 2020-07-04 Spain Galicia     9251 619 9204 -572 42.5751 -8.1339 2020-07-05 04:33:46 Galicia, Spain
311861 2020-07-04 Spain La Rioja     4078 366 3107 605 42.2871 -2.5396 2020-07-05 04:33:46 La Rioja, Spain
311879 2020-07-04 Spain Madrid     72168 8439 40736 22993 40.4168 -3.7038 2020-07-05 04:33:46 Madrid, Spain
311896 2020-07-04 Spain Melilla     126 2 125   35.2923 -2.9381 2020-07-05 04:33:46 Melilla, Spain
311913 2020-07-04 Spain Murcia     1697 148 2180 -631 37.9922 -1.1307 2020-07-05 04:33:46 Murcia, Spain
311921 2020-07-04 Spain Navarra     5477 528 3905 1044 42.6954 -1.6761 2020-07-05 04:33:46 Navarra, Spain
311961 2020-07-04 Spain Pais Vasco     13809 1561 16160 -3912 42.9896 -2.6189 2020-07-05 04:33:46 Pais Vasco, Spain
312091 2020-07-04 Spain Unknown     0 0 0 0     2020-07-05 04:33:46 Unknown, Spain
252077 2020-07-03 Spain Andalusia     13205 1433 10671 1101 37.5443 -4.7278 2020-07-04 04:33:51 Andalusia, Spain
252086 2020-07-03 Spain Aragon     6412 912 3772 1728 41.5976 -0.9057 2020-07-04 04:33:51 Aragon, Spain
252096 2020-07-03 Spain Asturias     2435 334 1063 1038 43.3614 -5.8593 2020-07-04 04:33:51 Asturias, Spain
252107 2020-07-03 Spain Baleares     2228 224 1533 471 39.710358 2.995148 2020-07-04 04:33:51 Baleares, Spain
252128 2020-07-03 Spain C. Valenciana     11630 1432 9970 228 39.484 -0.7533 2020-07-04 04:33:51 C. Valenciana, Spain
252135 2020-07-03 Spain Canarias     2436 162 1537 737 28.2916 -16.6291 2020-07-04 04:33:51 Canarias, Spain
252136 2020-07-03 Spain Cantabria     2364 216 2287 -139 43.1828 -3.9878 2020-07-04 04:33:51 Cantabria, Spain
252140 2020-07-03 Spain Castilla - La Mancha     18209 3026 6392 8791 39.2796 -3.0977 2020-07-04 04:33:51 Castilla - La Mancha, Spain
252141 2020-07-03 Spain Castilla y Leon     19753 2787 8716 8250 41.8357 -4.3976 2020-07-04 04:33:51 Castilla y Leon, Spain
252142 2020-07-03 Spain Catalonia     62057 5673 26203 30181 41.5912 1.5209 2020-07-04 04:33:51 Catalonia, Spain
252147 2020-07-03 Spain Ceuta     163 4 163 -4 35.8894 -5.3213 2020-07-04 04:33:51 Ceuta, Spain
252186 2020-07-03 Spain Extremadura     3047 519 2652 -124 39.4937 -6.0679 2020-07-04 04:33:51 Extremadura, Spain
252196 2020-07-03 Spain Galicia     9251 619 9204 -572 42.5751 -8.1339 2020-07-04 04:33:51 Galicia, Spain
252295 2020-07-03 Spain La Rioja     4078 366 3107 605 42.2871 -2.5396 2020-07-04 04:33:51 La Rioja, Spain
252313 2020-07-03 Spain Madrid     72168 8439 40736 22993 40.4168 -3.7038 2020-07-04 04:33:51 Madrid, Spain
252330 2020-07-03 Spain Melilla     126 2 125   35.2923 -2.9381 2020-07-04 04:33:51 Melilla, Spain
252347 2020-07-03 Spain Murcia     1697 148 2180 -631 37.9922 -1.1307 2020-07-04 04:33:51 Murcia, Spain
252355 2020-07-03 Spain Navarra     5477 528 3905 1044 42.6954 -1.6761 2020-07-04 04:33:51 Navarra, Spain
252395 2020-07-03 Spain Pais Vasco     13809 1561 16160 -3912 42.9896 -2.6189 2020-07-04 04:33:51 Pais Vasco, Spain
252525 2020-07-03 Spain Unknown     0 0 0 0     2020-07-04 04:33:51 Unknown, Spain
203458 2020-07-02 Spain Andalusia     13123 1428 10671 1024 37.5443 -4.7278 2020-07-03 04:33:54 Andalusia, Spain
203467 2020-07-02 Spain Aragon     6380 912 3772 1696 41.5976 -0.9057 2020-07-03 04:33:54 Aragon, Spain
203477 2020-07-02 Spain Asturias     2435 334 1063 1038 43.3614 -5.8593 2020-07-03 04:33:54 Asturias, Spain
203488 2020-07-02 Spain Baleares     2220 224 1533 463 39.710358 2.995148 2020-07-03 04:33:54 Baleares, Spain
203509 2020-07-02 Spain C. Valenciana     11616 1432 9970 214 39.484 -0.7533 2020-07-03 04:33:54 C. Valenciana, Spain
203516 2020-07-02 Spain Canarias     2431 162 1537 732 28.2916 -16.6291 2020-07-03 04:33:54 Canarias, Spain
203517 2020-07-02 Spain Cantabria     2364 216 2287 -139 43.1828 -3.9878 2020-07-03 04:33:54 Cantabria, Spain
203521 2020-07-02 Spain Castilla - La Mancha     18187 3026 6392 8769 39.2796 -3.0977 2020-07-03 04:33:54 Castilla - La Mancha, Spain
203522 2020-07-02 Spain Castilla y Leon     19750 2787 8716 8247 41.8357 -4.3976 2020-07-03 04:33:54 Castilla y Leon, Spain
203523 2020-07-02 Spain Catalonia     61888 5673 26203 30012 41.5912 1.5209 2020-07-03 04:33:54 Catalonia, Spain
203528 2020-07-02 Spain Ceuta     163 4 163 -4 35.8894 -5.3213 2020-07-03 04:33:54 Ceuta, Spain
203567 2020-07-02 Spain Extremadura     3040 519 2652 -131 39.4937 -6.0679 2020-07-03 04:33:54 Extremadura, Spain
203577 2020-07-02 Spain Galicia     9239 619 9204 -584 42.5751 -8.1339 2020-07-03 04:33:54 Galicia, Spain
203676 2020-07-02 Spain La Rioja     4078 366 3107 605 42.2871 -2.5396 2020-07-03 04:33:54 La Rioja, Spain
203694 2020-07-02 Spain Madrid     72096 8428 40736 22932 40.4168 -3.7038 2020-07-03 04:33:54 Madrid, Spain
203711 2020-07-02 Spain Melilla     126 2 125 -1 35.2923 -2.9381 2020-07-03 04:33:54 Melilla, Spain
203728 2020-07-02 Spain Murcia     1693 148 2180 -635 37.9922 -1.1307 2020-07-03 04:33:54 Murcia, Spain
203736 2020-07-02 Spain Navarra     5476 528 3905 1043 42.6954 -1.6761 2020-07-03 04:33:54 Navarra, Spain
203776 2020-07-02 Spain Pais Vasco     13798 1560 16160 -3922 42.9896 -2.6189 2020-07-03 04:33:54 Pais Vasco, Spain
203907 2020-07-02 Spain Unknown     0 0 0 0     2020-07-03 04:33:54 Unknown, Spain
159699 2020-07-01 Spain Andalusia     13139 1428 10671 1040 37.5443 -4.7278 2020-07-02 04:33:46 Andalusia, Spain
159708 2020-07-01 Spain Aragon     6353 912 3772 1669 41.5976 -0.9057 2020-07-02 04:33:46 Aragon, Spain
159718 2020-07-01 Spain Asturias     2435 334 1063 1038 43.3614 -5.8593 2020-07-02 04:33:46 Asturias, Spain
159729 2020-07-01 Spain Baleares     2216 224 1533 459 39.710358 2.995148 2020-07-02 04:33:46 Baleares, Spain
159750 2020-07-01 Spain C. Valenciana     11588 1432 9970 186 39.484 -0.7533 2020-07-02 04:33:46 C. Valenciana, Spain
159757 2020-07-01 Spain Canarias     2432 162 1537 733 28.2916 -16.6291 2020-07-02 04:33:46 Canarias, Spain
159758 2020-07-01 Spain Cantabria     2363 216 2287 -140 43.1828 -3.9878 2020-07-02 04:33:46 Cantabria, Spain
159762 2020-07-01 Spain Castilla - La Mancha     18160 3026 6392 8742 39.2796 -3.0977 2020-07-02 04:33:46 Castilla - La Mancha, Spain
159763 2020-07-01 Spain Castilla y Leon     19730 2787 8716 8227 41.8357 -4.3976 2020-07-02 04:33:46 Castilla y Leon, Spain
159764 2020-07-01 Spain Catalonia     61639 5671 26203 29765 41.5912 1.5209 2020-07-02 04:33:46 Catalonia, Spain
159769 2020-07-01 Spain Ceuta     163 4 163 -4 35.8894 -5.3213 2020-07-02 04:33:46 Ceuta, Spain
159808 2020-07-01 Spain Extremadura     3033 519 2652 -138 39.4937 -6.0679 2020-07-02 04:33:46 Extremadura, Spain
159818 2020-07-01 Spain Galicia     9222 619 9204 -601 42.5751 -8.1339 2020-07-02 04:33:46 Galicia, Spain
159917 2020-07-01 Spain La Rioja     4077 366 3107 604 42.2871 -2.5396 2020-07-02 04:33:46 La Rioja, Spain
159935 2020-07-01 Spain Madrid     72033 8427 40736 22870 40.4168 -3.7038 2020-07-02 04:33:46 Madrid, Spain
159952 2020-07-01 Spain Melilla     126 2 125 -1 35.2923 -2.9381 2020-07-02 04:33:46 Melilla, Spain
159969 2020-07-01 Spain Murcia     1690 147 2180 -637 37.9922 -1.1307 2020-07-02 04:33:46 Murcia, Spain
159977 2020-07-01 Spain Navarra     5468 528 3905 1035 42.6954 -1.6761 2020-07-02 04:33:46 Navarra, Spain
160017 2020-07-01 Spain Pais Vasco     13792 1560 16160 -3928 42.9896 -2.6189 2020-07-02 04:33:46 Pais Vasco, Spain
160148 2020-07-01 Spain Unknown     0 0 0 0     2020-07-02 04:33:46 Unknown, Spain
325694 2020-06-30 Spain Andalusia     13102 1427 10671 1004 37.5443 -4.7278 2020-07-01 04:33:52 Andalusia, Spain
325703 2020-06-30 Spain Aragon     6330 912 3772 1646 41.5976 -0.9057 2020-07-01 04:33:52 Aragon, Spain
325713 2020-06-30 Spain Asturias     2435 334 1063 1038 43.3614 -5.8593 2020-07-01 04:33:52 Asturias, Spain
325724 2020-06-30 Spain Baleares     2209 224 1533 452 39.710358 2.995148 2020-07-01 04:33:52 Baleares, Spain
325745 2020-06-30 Spain C. Valenciana     11579 1432 9970 177 39.484 -0.7533 2020-07-01 04:33:52 C. Valenciana, Spain
325752 2020-06-30 Spain Canarias     2427 162 1537 728 28.2916 -16.6291 2020-07-01 04:33:52 Canarias, Spain
325753 2020-06-30 Spain Cantabria     2362 216 2287 -141 43.1828 -3.9878 2020-07-01 04:33:52 Cantabria, Spain
325757 2020-06-30 Spain Castilla - La Mancha     18158 3026 6392 8740 39.2796 -3.0977 2020-07-01 04:33:52 Castilla - La Mancha, Spain
325758 2020-06-30 Spain Castilla y Leon     19685 2784 8716 8185 41.8357 -4.3976 2020-07-01 04:33:52 Castilla y Leon, Spain
325759 2020-06-30 Spain Catalonia     61494 5670 26203 29621 41.5912 1.5209 2020-07-01 04:33:52 Catalonia, Spain
325764 2020-06-30 Spain Ceuta     163 4 163 -4 35.8894 -5.3213 2020-07-01 04:33:52 Ceuta, Spain
325803 2020-06-30 Spain Extremadura     3030 519 2652 -141 39.4937 -6.0679 2020-07-01 04:33:52 Extremadura, Spain
325813 2020-06-30 Spain Galicia     9215 619 9204 -608 42.5751 -8.1339 2020-07-01 04:33:52 Galicia, Spain
325912 2020-06-30 Spain La Rioja     4076 366 3107 603 42.2871 -2.5396 2020-07-01 04:33:52 La Rioja, Spain
325930 2020-06-30 Spain Madrid     71950 8425 40736 22789 40.4168 -3.7038 2020-07-01 04:33:52 Madrid, Spain
325947 2020-06-30 Spain Melilla     126 2 125 -1 35.2923 -2.9381 2020-07-01 04:33:52 Melilla, Spain
325964 2020-06-30 Spain Murcia     1684 147 2180 -643 37.9922 -1.1307 2020-07-01 04:33:52 Murcia, Spain
325972 2020-06-30 Spain Navarra     5463 528 3905 1030 42.6954 -1.6761 2020-07-01 04:33:52 Navarra, Spain
326012 2020-06-30 Spain Pais Vasco     13783 1558 16160 -3935 42.9896 -2.6189 2020-07-01 04:33:52 Pais Vasco, Spain
326143 2020-06-30 Spain Unknown     0 0 0 0     2020-07-01 04:33:52 Unknown, Spain

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
Powered by Datasette · Query took 2531.574ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette