johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19,298 rows where country_or_region = "Spain" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2021-04-25 62
- 2020-05-20 20
- 2020-05-21 20
- 2020-05-22 20
- 2020-05-23 20
- 2020-05-24 20
- 2020-05-25 20
- 2020-05-26 20
- 2020-05-27 20
- 2020-05-28 20
- 2020-05-29 20
- 2020-05-30 20
- 2020-05-31 20
- 2020-06-01 20
- 2020-06-02 20
- 2020-06-03 20
- 2020-06-04 20
- 2020-06-05 20
- 2020-06-06 20
- 2020-06-07 20
- 2020-06-08 20
- 2020-06-09 20
- 2020-06-10 20
- 2020-06-11 20
- 2020-06-12 20
- 2020-06-13 20
- 2020-06-14 20
- 2020-06-15 20
- 2020-06-16 20
- 2020-06-17 20
- …
province_or_state 20
- Andalusia 388
- Aragon 388
- Asturias 388
- Baleares 388
- C. Valenciana 388
- Canarias 388
- Cantabria 388
- Castilla - La Mancha 388
- Castilla y Leon 388
- Catalonia 388
- Ceuta 388
- Extremadura 388
- Galicia 388
- La Rioja 388
- Madrid 388
- Melilla 388
- Murcia 388
- Navarra 388
- Pais Vasco 388
- Unknown 383
country_or_region 1
- Spain · 7,858 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2586272 | 2586272 | 2021-06-05 | Spain | Andalusia | 590684 | 9928 | 10671 | 570085 | 37.5443 | -4.7278 | 2021-06-06 04:24:03 | Andalusia, Spain | ||
2586273 | 2586273 | 2021-06-05 | Spain | Aragon | 124819 | 3517 | 3772 | 117530 | 41.5976 | -0.9057 | 2021-06-06 04:24:03 | Aragon, Spain | ||
2586274 | 2586274 | 2021-06-05 | Spain | Asturias | 52603 | 1971 | 1063 | 49569 | 43.3614 | -5.8593 | 2021-06-06 04:24:03 | Asturias, Spain | ||
2586275 | 2586275 | 2021-06-05 | Spain | Baleares | 60619 | 839 | 1533 | 58247 | 39.710358 | 2.995148 | 2021-06-06 04:24:03 | Baleares, Spain | ||
2586276 | 2586276 | 2021-06-05 | Spain | C. Valenciana | 395515 | 7399 | 9970 | 378146 | 39.484 | -0.7533 | 2021-06-06 04:24:03 | C. Valenciana, Spain | ||
2586277 | 2586277 | 2021-06-05 | Spain | Canarias | 56965 | 772 | 1537 | 54656 | 28.2916 | -16.6291 | 2021-06-06 04:24:03 | Canarias, Spain | ||
2586278 | 2586278 | 2021-06-05 | Spain | Cantabria | 30414 | 565 | 2287 | 27562 | 43.1828 | -3.9878 | 2021-06-06 04:24:03 | Cantabria, Spain | ||
2586279 | 2586279 | 2021-06-05 | Spain | Castilla - La Mancha | 193511 | 5927 | 6392 | 181192 | 39.2796 | -3.0977 | 2021-06-06 04:24:03 | Castilla - La Mancha, Spain | ||
2586280 | 2586280 | 2021-06-05 | Spain | Castilla y Leon | 232170 | 6894 | 8716 | 216560 | 41.8357 | -4.3976 | 2021-06-06 04:24:03 | Castilla y Leon, Spain | ||
2586281 | 2586281 | 2021-06-05 | Spain | Catalonia | 615478 | 14595 | 26203 | 574680 | 41.5912 | 1.5209 | 2021-06-06 04:24:03 | Catalonia, Spain | ||
2586282 | 2586282 | 2021-06-05 | Spain | Ceuta | 5909 | 116 | 163 | 5630 | 35.8894 | -5.3213 | 2021-06-06 04:24:03 | Ceuta, Spain | ||
2586283 | 2586283 | 2021-06-05 | Spain | Extremadura | 76095 | 1805 | 2652 | 71638 | 39.4937 | -6.0679 | 2021-06-06 04:24:03 | Extremadura, Spain | ||
2586284 | 2586284 | 2021-06-05 | Spain | Galicia | 127330 | 2411 | 9204 | 115715 | 42.5751 | -8.1339 | 2021-06-06 04:24:03 | Galicia, Spain | ||
2586285 | 2586285 | 2021-06-05 | Spain | La Rioja | 31141 | 773 | 3107 | 27261 | 42.2871 | -2.5396 | 2021-06-06 04:24:03 | La Rioja, Spain | ||
2586286 | 2586286 | 2021-06-05 | Spain | Madrid | 719515 | 15341 | 40736 | 663438 | 40.4168 | -3.7038 | 2021-06-06 04:24:03 | Madrid, Spain | ||
2586287 | 2586287 | 2021-06-05 | Spain | Melilla | 9165 | 97 | 125 | 8943 | 35.2923 | -2.9381 | 2021-06-06 04:24:03 | Melilla, Spain | ||
2586288 | 2586288 | 2021-06-05 | Spain | Murcia | 113352 | 1602 | 2180 | 109570 | 37.9922 | -1.1307 | 2021-06-06 04:24:03 | Murcia, Spain | ||
2586289 | 2586289 | 2021-06-05 | Spain | Navarra | 62720 | 1177 | 3905 | 57638 | 42.6954 | -1.6761 | 2021-06-06 04:24:03 | Navarra, Spain | ||
2586290 | 2586290 | 2021-06-05 | Spain | Pais Vasco | 199976 | 4467 | 16160 | 179349 | 42.9896 | -2.6189 | 2021-06-06 04:24:03 | Pais Vasco, Spain | ||
2586291 | 2586291 | 2021-06-05 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
2315586 | 2315586 | 2021-06-04 | Spain | Andalusia | 590684 | 9928 | 10671 | 570085 | 37.5443 | -4.7278 | 2021-06-05 04:23:03 | Andalusia, Spain | ||
2315587 | 2315587 | 2021-06-04 | Spain | Aragon | 124819 | 3517 | 3772 | 117530 | 41.5976 | -0.9057 | 2021-06-05 04:23:03 | Aragon, Spain | ||
2315588 | 2315588 | 2021-06-04 | Spain | Asturias | 52603 | 1971 | 1063 | 49569 | 43.3614 | -5.8593 | 2021-06-05 04:23:03 | Asturias, Spain | ||
2315589 | 2315589 | 2021-06-04 | Spain | Baleares | 60619 | 839 | 1533 | 58247 | 39.710358 | 2.995148 | 2021-06-05 04:23:03 | Baleares, Spain | ||
2315590 | 2315590 | 2021-06-04 | Spain | C. Valenciana | 395515 | 7399 | 9970 | 378146 | 39.484 | -0.7533 | 2021-06-05 04:23:03 | C. Valenciana, Spain | ||
2315591 | 2315591 | 2021-06-04 | Spain | Canarias | 56965 | 772 | 1537 | 54656 | 28.2916 | -16.6291 | 2021-06-05 04:23:03 | Canarias, Spain | ||
2315592 | 2315592 | 2021-06-04 | Spain | Cantabria | 30414 | 565 | 2287 | 27562 | 43.1828 | -3.9878 | 2021-06-05 04:23:03 | Cantabria, Spain | ||
2315593 | 2315593 | 2021-06-04 | Spain | Castilla - La Mancha | 193511 | 5927 | 6392 | 181192 | 39.2796 | -3.0977 | 2021-06-05 04:23:03 | Castilla - La Mancha, Spain | ||
2315594 | 2315594 | 2021-06-04 | Spain | Castilla y Leon | 232170 | 6894 | 8716 | 216560 | 41.8357 | -4.3976 | 2021-06-05 04:23:03 | Castilla y Leon, Spain | ||
2315595 | 2315595 | 2021-06-04 | Spain | Catalonia | 615478 | 14595 | 26203 | 574680 | 41.5912 | 1.5209 | 2021-06-05 04:23:03 | Catalonia, Spain | ||
2315596 | 2315596 | 2021-06-04 | Spain | Ceuta | 5909 | 115 | 163 | 5631 | 35.8894 | -5.3213 | 2021-06-05 04:23:03 | Ceuta, Spain | ||
2315597 | 2315597 | 2021-06-04 | Spain | Extremadura | 76095 | 1805 | 2652 | 71638 | 39.4937 | -6.0679 | 2021-06-05 04:23:03 | Extremadura, Spain | ||
2315598 | 2315598 | 2021-06-04 | Spain | Galicia | 127330 | 2411 | 9204 | 115715 | 42.5751 | -8.1339 | 2021-06-05 04:23:03 | Galicia, Spain | ||
2315599 | 2315599 | 2021-06-04 | Spain | La Rioja | 31141 | 773 | 3107 | 27261 | 42.2871 | -2.5396 | 2021-06-05 04:23:03 | La Rioja, Spain | ||
2315600 | 2315600 | 2021-06-04 | Spain | Madrid | 719515 | 15341 | 40736 | 663438 | 40.4168 | -3.7038 | 2021-06-05 04:23:03 | Madrid, Spain | ||
2315601 | 2315601 | 2021-06-04 | Spain | Melilla | 9165 | 97 | 125 | 8943 | 35.2923 | -2.9381 | 2021-06-05 04:23:03 | Melilla, Spain | ||
2315602 | 2315602 | 2021-06-04 | Spain | Murcia | 113352 | 1602 | 2180 | 109570 | 37.9922 | -1.1307 | 2021-06-05 04:23:03 | Murcia, Spain | ||
2315603 | 2315603 | 2021-06-04 | Spain | Navarra | 62720 | 1177 | 3905 | 57638 | 42.6954 | -1.6761 | 2021-06-05 04:23:03 | Navarra, Spain | ||
2315604 | 2315604 | 2021-06-04 | Spain | Pais Vasco | 199976 | 4467 | 16160 | 179349 | 42.9896 | -2.6189 | 2021-06-05 04:23:03 | Pais Vasco, Spain | ||
2315605 | 2315605 | 2021-06-04 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
1448871 | 1448871 | 2021-06-03 | Spain | Andalusia | 589198 | 9918 | 10671 | 568609 | 37.5443 | -4.7278 | 2021-06-04 04:23:37 | Andalusia, Spain | ||
1448872 | 1448872 | 2021-06-03 | Spain | Aragon | 124671 | 3511 | 3772 | 117388 | 41.5976 | -0.9057 | 2021-06-04 04:23:37 | Aragon, Spain | ||
1448873 | 1448873 | 2021-06-03 | Spain | Asturias | 52551 | 1967 | 1063 | 49521 | 43.3614 | -5.8593 | 2021-06-04 04:23:37 | Asturias, Spain | ||
1448874 | 1448874 | 2021-06-03 | Spain | Baleares | 60582 | 839 | 1533 | 58210 | 39.710358 | 2.995148 | 2021-06-04 04:23:37 | Baleares, Spain | ||
1448875 | 1448875 | 2021-06-03 | Spain | C. Valenciana | 395314 | 7393 | 9970 | 377951 | 39.484 | -0.7533 | 2021-06-04 04:23:37 | C. Valenciana, Spain | ||
1448876 | 1448876 | 2021-06-03 | Spain | Canarias | 56834 | 771 | 1537 | 54526 | 28.2916 | -16.6291 | 2021-06-04 04:23:37 | Canarias, Spain | ||
1448877 | 1448877 | 2021-06-03 | Spain | Cantabria | 30376 | 565 | 2287 | 27524 | 43.1828 | -3.9878 | 2021-06-04 04:23:37 | Cantabria, Spain | ||
1448878 | 1448878 | 2021-06-03 | Spain | Castilla - La Mancha | 193342 | 5923 | 6392 | 181027 | 39.2796 | -3.0977 | 2021-06-04 04:23:37 | Castilla - La Mancha, Spain | ||
1448879 | 1448879 | 2021-06-03 | Spain | Castilla y Leon | 231924 | 6890 | 8716 | 216318 | 41.8357 | -4.3976 | 2021-06-04 04:23:37 | Castilla y Leon, Spain | ||
1448880 | 1448880 | 2021-06-03 | Spain | Catalonia | 614471 | 14552 | 26203 | 573716 | 41.5912 | 1.5209 | 2021-06-04 04:23:37 | Catalonia, Spain | ||
1448881 | 1448881 | 2021-06-03 | Spain | Ceuta | 5909 | 115 | 163 | 5631 | 35.8894 | -5.3213 | 2021-06-04 04:23:37 | Ceuta, Spain | ||
1448882 | 1448882 | 2021-06-03 | Spain | Extremadura | 76016 | 1804 | 2652 | 71560 | 39.4937 | -6.0679 | 2021-06-04 04:23:37 | Extremadura, Spain | ||
1448883 | 1448883 | 2021-06-03 | Spain | Galicia | 127230 | 2407 | 9204 | 115619 | 42.5751 | -8.1339 | 2021-06-04 04:23:37 | Galicia, Spain | ||
1448884 | 1448884 | 2021-06-03 | Spain | La Rioja | 31097 | 771 | 3107 | 27219 | 42.2871 | -2.5396 | 2021-06-04 04:23:37 | La Rioja, Spain | ||
1448885 | 1448885 | 2021-06-03 | Spain | Madrid | 718743 | 15307 | 40736 | 662700 | 40.4168 | -3.7038 | 2021-06-04 04:23:37 | Madrid, Spain | ||
1448886 | 1448886 | 2021-06-03 | Spain | Melilla | 9156 | 97 | 125 | 8934 | 35.2923 | -2.9381 | 2021-06-04 04:23:37 | Melilla, Spain | ||
1448887 | 1448887 | 2021-06-03 | Spain | Murcia | 113278 | 1602 | 2180 | 109496 | 37.9922 | -1.1307 | 2021-06-04 04:23:37 | Murcia, Spain | ||
1448888 | 1448888 | 2021-06-03 | Spain | Navarra | 62662 | 1176 | 3905 | 57581 | 42.6954 | -1.6761 | 2021-06-04 04:23:37 | Navarra, Spain | ||
1448889 | 1448889 | 2021-06-03 | Spain | Pais Vasco | 199658 | 4441 | 16160 | 179057 | 42.9896 | -2.6189 | 2021-06-04 04:23:37 | Pais Vasco, Spain | ||
1448890 | 1448890 | 2021-06-03 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
1708595 | 1708595 | 2021-06-02 | Spain | Andalusia | 587551 | 9918 | 10671 | 566962 | 37.5443 | -4.7278 | 2021-06-03 04:23:32 | Andalusia, Spain | ||
1708596 | 1708596 | 2021-06-02 | Spain | Aragon | 124517 | 3511 | 3772 | 117234 | 41.5976 | -0.9057 | 2021-06-03 04:23:32 | Aragon, Spain | ||
1708597 | 1708597 | 2021-06-02 | Spain | Asturias | 52496 | 1967 | 1063 | 49466 | 43.3614 | -5.8593 | 2021-06-03 04:23:32 | Asturias, Spain | ||
1708598 | 1708598 | 2021-06-02 | Spain | Baleares | 60537 | 839 | 1533 | 58165 | 39.710358 | 2.995148 | 2021-06-03 04:23:32 | Baleares, Spain | ||
1708599 | 1708599 | 2021-06-02 | Spain | C. Valenciana | 395109 | 7393 | 9970 | 377746 | 39.484 | -0.7533 | 2021-06-03 04:23:32 | C. Valenciana, Spain | ||
1708600 | 1708600 | 2021-06-02 | Spain | Canarias | 56693 | 771 | 1537 | 54385 | 28.2916 | -16.6291 | 2021-06-03 04:23:32 | Canarias, Spain | ||
1708601 | 1708601 | 2021-06-02 | Spain | Cantabria | 30352 | 565 | 2287 | 27500 | 43.1828 | -3.9878 | 2021-06-03 04:23:32 | Cantabria, Spain | ||
1708602 | 1708602 | 2021-06-02 | Spain | Castilla - La Mancha | 193173 | 5923 | 6392 | 180858 | 39.2796 | -3.0977 | 2021-06-03 04:23:32 | Castilla - La Mancha, Spain | ||
1708603 | 1708603 | 2021-06-02 | Spain | Castilla y Leon | 231661 | 6890 | 8716 | 216055 | 41.8357 | -4.3976 | 2021-06-03 04:23:32 | Castilla y Leon, Spain | ||
1708604 | 1708604 | 2021-06-02 | Spain | Catalonia | 613539 | 14552 | 26203 | 572784 | 41.5912 | 1.5209 | 2021-06-03 04:23:32 | Catalonia, Spain | ||
1708605 | 1708605 | 2021-06-02 | Spain | Ceuta | 5896 | 115 | 163 | 5618 | 35.8894 | -5.3213 | 2021-06-03 04:23:32 | Ceuta, Spain | ||
1708606 | 1708606 | 2021-06-02 | Spain | Extremadura | 75960 | 1804 | 2652 | 71504 | 39.4937 | -6.0679 | 2021-06-03 04:23:32 | Extremadura, Spain | ||
1708607 | 1708607 | 2021-06-02 | Spain | Galicia | 127121 | 2407 | 9204 | 115510 | 42.5751 | -8.1339 | 2021-06-03 04:23:32 | Galicia, Spain | ||
1708608 | 1708608 | 2021-06-02 | Spain | La Rioja | 30999 | 771 | 3107 | 27121 | 42.2871 | -2.5396 | 2021-06-03 04:23:32 | La Rioja, Spain | ||
1708609 | 1708609 | 2021-06-02 | Spain | Madrid | 717880 | 15307 | 40736 | 661837 | 40.4168 | -3.7038 | 2021-06-03 04:23:32 | Madrid, Spain | ||
1708610 | 1708610 | 2021-06-02 | Spain | Melilla | 9148 | 97 | 125 | 8926 | 35.2923 | -2.9381 | 2021-06-03 04:23:32 | Melilla, Spain | ||
1708611 | 1708611 | 2021-06-02 | Spain | Murcia | 113200 | 1602 | 2180 | 109418 | 37.9922 | -1.1307 | 2021-06-03 04:23:32 | Murcia, Spain | ||
1708612 | 1708612 | 2021-06-02 | Spain | Navarra | 62583 | 1176 | 3905 | 57502 | 42.6954 | -1.6761 | 2021-06-03 04:23:32 | Navarra, Spain | ||
1708613 | 1708613 | 2021-06-02 | Spain | Pais Vasco | 199347 | 4441 | 16160 | 178746 | 42.9896 | -2.6189 | 2021-06-03 04:23:32 | Pais Vasco, Spain | ||
1708614 | 1708614 | 2021-06-02 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
2104413 | 2104413 | 2021-06-01 | Spain | Andalusia | 586178 | 9900 | 10671 | 565607 | 37.5443 | -4.7278 | 2021-06-02 04:24:34 | Andalusia, Spain | ||
2104414 | 2104414 | 2021-06-01 | Spain | Aragon | 124368 | 3511 | 3772 | 117085 | 41.5976 | -0.9057 | 2021-06-02 04:24:34 | Aragon, Spain | ||
2104415 | 2104415 | 2021-06-01 | Spain | Asturias | 52455 | 1967 | 1063 | 49425 | 43.3614 | -5.8593 | 2021-06-02 04:24:34 | Asturias, Spain | ||
2104416 | 2104416 | 2021-06-01 | Spain | Baleares | 60502 | 839 | 1533 | 58130 | 39.710358 | 2.995148 | 2021-06-02 04:24:34 | Baleares, Spain | ||
2104417 | 2104417 | 2021-06-01 | Spain | C. Valenciana | 394926 | 7393 | 9970 | 377563 | 39.484 | -0.7533 | 2021-06-02 04:24:34 | C. Valenciana, Spain | ||
2104418 | 2104418 | 2021-06-01 | Spain | Canarias | 56561 | 770 | 1537 | 54254 | 28.2916 | -16.6291 | 2021-06-02 04:24:34 | Canarias, Spain | ||
2104419 | 2104419 | 2021-06-01 | Spain | Cantabria | 30300 | 565 | 2287 | 27448 | 43.1828 | -3.9878 | 2021-06-02 04:24:34 | Cantabria, Spain | ||
2104420 | 2104420 | 2021-06-01 | Spain | Castilla - La Mancha | 193145 | 5914 | 6392 | 180839 | 39.2796 | -3.0977 | 2021-06-02 04:24:34 | Castilla - La Mancha, Spain | ||
2104421 | 2104421 | 2021-06-01 | Spain | Castilla y Leon | 231403 | 6884 | 8716 | 215803 | 41.8357 | -4.3976 | 2021-06-02 04:24:34 | Castilla y Leon, Spain | ||
2104422 | 2104422 | 2021-06-01 | Spain | Catalonia | 612377 | 14544 | 26203 | 571630 | 41.5912 | 1.5209 | 2021-06-02 04:24:34 | Catalonia, Spain | ||
2104423 | 2104423 | 2021-06-01 | Spain | Ceuta | 5879 | 115 | 163 | 5601 | 35.8894 | -5.3213 | 2021-06-02 04:24:34 | Ceuta, Spain | ||
2104424 | 2104424 | 2021-06-01 | Spain | Extremadura | 75905 | 1804 | 2652 | 71449 | 39.4937 | -6.0679 | 2021-06-02 04:24:34 | Extremadura, Spain | ||
2104425 | 2104425 | 2021-06-01 | Spain | Galicia | 127028 | 2406 | 9204 | 115418 | 42.5751 | -8.1339 | 2021-06-02 04:24:34 | Galicia, Spain | ||
2104426 | 2104426 | 2021-06-01 | Spain | La Rioja | 30942 | 771 | 3107 | 27064 | 42.2871 | -2.5396 | 2021-06-02 04:24:34 | La Rioja, Spain | ||
2104427 | 2104427 | 2021-06-01 | Spain | Madrid | 717030 | 15295 | 40736 | 660999 | 40.4168 | -3.7038 | 2021-06-02 04:24:34 | Madrid, Spain | ||
2104428 | 2104428 | 2021-06-01 | Spain | Melilla | 9137 | 97 | 125 | 8915 | 35.2923 | -2.9381 | 2021-06-02 04:24:34 | Melilla, Spain | ||
2104429 | 2104429 | 2021-06-01 | Spain | Murcia | 113144 | 1600 | 2180 | 109364 | 37.9922 | -1.1307 | 2021-06-02 04:24:34 | Murcia, Spain | ||
2104430 | 2104430 | 2021-06-01 | Spain | Navarra | 62490 | 1175 | 3905 | 57410 | 42.6954 | -1.6761 | 2021-06-02 04:24:34 | Navarra, Spain | ||
2104431 | 2104431 | 2021-06-01 | Spain | Pais Vasco | 199008 | 4433 | 16160 | 178415 | 42.9896 | -2.6189 | 2021-06-02 04:24:34 | Pais Vasco, Spain | ||
2104432 | 2104432 | 2021-06-01 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, 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]);