johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20,264 rows where country_or_region = "Italy" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2020-05-15 21
- 2020-05-16 21
- 2020-05-17 21
- 2020-05-18 21
- 2020-05-19 21
- 2020-05-20 21
- 2020-05-21 21
- 2020-05-22 21
- 2020-05-23 21
- 2020-05-24 21
- 2020-05-25 21
- 2020-05-26 21
- 2020-05-27 21
- 2020-05-28 21
- 2020-05-29 21
- 2020-05-30 21
- 2020-05-31 21
- 2020-06-01 21
- 2020-06-02 21
- 2020-06-03 21
- 2020-06-04 21
- 2020-06-05 21
- 2020-06-06 21
- 2020-06-07 21
- 2020-06-08 21
- 2020-06-09 21
- 2020-06-10 21
- 2020-06-11 21
- 2020-06-12 21
- 2020-06-13 21
- …
province_or_state 21
- Abruzzo 403
- Basilicata 403
- Calabria 403
- Campania 403
- Emilia-Romagna 403
- Friuli Venezia Giulia 403
- Lazio 403
- Liguria 403
- Lombardia 403
- Marche 403
- Molise 403
- P.A. Bolzano 403
- P.A. Trento 403
- Piemonte 403
- Puglia 403
- Sardegna 403
- Sicilia 403
- Toscana 403
- Umbria 403
- Valle d'Aosta 403
- Veneto 403
country_or_region 1
- Italy · 8,567 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2884346 | 2884346 | 2021-06-20 | Italy | Abruzzo | 74628 | 2509 | 70844 | 1275 | 42.35122196 | 13.39843823 | 2021-06-21 04:21:41 | Abruzzo, Italy | ||
2884347 | 2884347 | 2021-06-20 | Italy | Basilicata | 26827 | 589 | 24938 | 1300 | 40.63947052 | 15.80514834 | 2021-06-21 04:21:41 | Basilicata, Italy | ||
2884348 | 2884348 | 2021-06-20 | Italy | Calabria | 68659 | 1219 | 60571 | 6869 | 38.90597598 | 16.59440194 | 2021-06-21 04:21:41 | Calabria, Italy | ||
2884349 | 2884349 | 2021-06-20 | Italy | Campania | 423381 | 7386 | 405623 | 10372 | 40.83956555 | 14.25084984 | 2021-06-21 04:21:41 | Campania, Italy | ||
2884350 | 2884350 | 2021-06-20 | Italy | Emilia-Romagna | 386265 | 13246 | 367429 | 5590 | 44.49436681 | 11.3417208 | 2021-06-21 04:21:41 | Emilia-Romagna, Italy | ||
2884351 | 2884351 | 2021-06-20 | Italy | Friuli Venezia Giulia | 107476 | 3799 | 99198 | 4479 | 45.6494354 | 13.76813649 | 2021-06-21 04:21:41 | Friuli Venezia Giulia, Italy | ||
2884352 | 2884352 | 2021-06-20 | Italy | Lazio | 345214 | 8304 | 332671 | 4239 | 41.89277044 | 12.48366722 | 2021-06-21 04:21:41 | Lazio, Italy | ||
2884353 | 2884353 | 2021-06-20 | Italy | Liguria | 103151 | 4346 | 98527 | 278 | 44.41149315 | 8.9326992 | 2021-06-21 04:21:41 | Liguria, Italy | ||
2884354 | 2884354 | 2021-06-20 | Italy | Lombardia | 840689 | 33753 | 793279 | 13657 | 45.46679409 | 9.190347404 | 2021-06-21 04:21:41 | Lombardia, Italy | ||
2884355 | 2884355 | 2021-06-20 | Italy | Marche | 103539 | 3031 | 98496 | 2012 | 43.61675973 | 13.5188753 | 2021-06-21 04:21:41 | Marche, Italy | ||
2884356 | 2884356 | 2021-06-20 | Italy | Molise | 13682 | 491 | 13101 | 90 | 41.55774754 | 14.65916051 | 2021-06-21 04:21:41 | Molise, Italy | ||
2884357 | 2884357 | 2021-06-20 | Italy | P.A. Bolzano | 73254 | 1180 | 71798 | 276 | 46.49933453 | 11.35662422 | 2021-06-21 04:21:41 | P.A. Bolzano, Italy | ||
2884358 | 2884358 | 2021-06-20 | Italy | P.A. Trento | 45731 | 1361 | 44221 | 149 | 46.06893511 | 11.12123097 | 2021-06-21 04:21:41 | P.A. Trento, Italy | ||
2884359 | 2884359 | 2021-06-20 | Italy | Piemonte | 362594 | 11690 | 349206 | 1698 | 45.0732745 | 7.680687483 | 2021-06-21 04:21:41 | Piemonte, Italy | ||
2884360 | 2884360 | 2021-06-20 | Italy | Puglia | 252863 | 6605 | 237399 | 8859 | 41.12559576 | 16.86736689 | 2021-06-21 04:21:41 | Puglia, Italy | ||
2884361 | 2884361 | 2021-06-20 | Italy | Sardegna | 57118 | 1485 | 44055 | 11578 | 39.21531192 | 9.110616306 | 2021-06-21 04:21:41 | Sardegna, Italy | ||
2884362 | 2884362 | 2021-06-20 | Italy | Sicilia | 230587 | 5936 | 219091 | 5560 | 38.11569725 | 13.362356699999998 | 2021-06-21 04:21:41 | Sicilia, Italy | ||
2884363 | 2884363 | 2021-06-20 | Italy | Toscana | 243864 | 6847 | 233747 | 3270 | 43.76923077 | 11.25588885 | 2021-06-21 04:21:41 | Toscana, Italy | ||
2884364 | 2884364 | 2021-06-20 | Italy | Umbria | 56771 | 1418 | 54463 | 890 | 43.10675841 | 12.38824698 | 2021-06-21 04:21:41 | Umbria, Italy | ||
2884365 | 2884365 | 2021-06-20 | Italy | Valle d'Aosta | 11674 | 472 | 11145 | 57 | 45.73750286 | 7.320149366 | 2021-06-21 04:21:41 | Valle d'Aosta, Italy | ||
2884366 | 2884366 | 2021-06-20 | Italy | Veneto | 425009 | 11603 | 408194 | 5212 | 45.43490485 | 12.33845213 | 2021-06-21 04:21:41 | Veneto, Italy | ||
107429 | 107429 | 2021-06-19 | Italy | Abruzzo | 74601 | 2509 | 70837 | 1255 | 42.35122196 | 13.39843823 | 2021-06-20 04:21:48 | Abruzzo, Italy | ||
107430 | 107430 | 2021-06-19 | Italy | Basilicata | 26791 | 588 | 24371 | 1832 | 40.63947052 | 15.80514834 | 2021-06-20 04:21:48 | Basilicata, Italy | ||
107431 | 107431 | 2021-06-19 | Italy | Calabria | 68605 | 1219 | 60481 | 6905 | 38.90597598 | 16.59440194 | 2021-06-20 04:21:48 | Calabria, Italy | ||
107432 | 107432 | 2021-06-19 | Italy | Campania | 423299 | 7383 | 405295 | 10621 | 40.83956555 | 14.25084984 | 2021-06-20 04:21:48 | Campania, Italy | ||
107433 | 107433 | 2021-06-19 | Italy | Emilia-Romagna | 386192 | 13245 | 367185 | 5762 | 44.49436681 | 11.3417208 | 2021-06-20 04:21:48 | Emilia-Romagna, Italy | ||
107434 | 107434 | 2021-06-19 | Italy | Friuli Venezia Giulia | 107469 | 3799 | 99192 | 4478 | 45.6494354 | 13.76813649 | 2021-06-20 04:21:48 | Friuli Venezia Giulia, Italy | ||
107435 | 107435 | 2021-06-19 | Italy | Lazio | 345146 | 8304 | 332483 | 4359 | 41.89277044 | 12.48366722 | 2021-06-20 04:21:48 | Lazio, Italy | ||
107436 | 107436 | 2021-06-19 | Italy | Liguria | 103133 | 4345 | 98497 | 291 | 44.41149315 | 8.9326992 | 2021-06-20 04:21:48 | Liguria, Italy | ||
107437 | 107437 | 2021-06-19 | Italy | Lombardia | 840544 | 33751 | 793206 | 13587 | 45.46679409 | 9.190347404 | 2021-06-20 04:21:48 | Lombardia, Italy | ||
107438 | 107438 | 2021-06-19 | Italy | Marche | 103524 | 3031 | 98424 | 2069 | 43.61675973 | 13.5188753 | 2021-06-20 04:21:48 | Marche, Italy | ||
107439 | 107439 | 2021-06-19 | Italy | Molise | 13670 | 491 | 13098 | 81 | 41.55774754 | 14.65916051 | 2021-06-20 04:21:48 | Molise, Italy | ||
107440 | 107440 | 2021-06-19 | Italy | P.A. Bolzano | 73246 | 1180 | 71769 | 297 | 46.49933453 | 11.35662422 | 2021-06-20 04:21:48 | P.A. Bolzano, Italy | ||
107441 | 107441 | 2021-06-19 | Italy | P.A. Trento | 45727 | 1361 | 44200 | 166 | 46.06893511 | 11.12123097 | 2021-06-20 04:21:48 | P.A. Trento, Italy | ||
107442 | 107442 | 2021-06-19 | Italy | Piemonte | 362563 | 11688 | 349077 | 1798 | 45.0732745 | 7.680687483 | 2021-06-20 04:21:48 | Piemonte, Italy | ||
107443 | 107443 | 2021-06-19 | Italy | Puglia | 252818 | 6604 | 237305 | 8909 | 41.12559576 | 16.86736689 | 2021-06-20 04:21:48 | Puglia, Italy | ||
107444 | 107444 | 2021-06-19 | Italy | Sardegna | 57109 | 1485 | 44027 | 11597 | 39.21531192 | 9.110616306 | 2021-06-20 04:21:48 | Sardegna, Italy | ||
107445 | 107445 | 2021-06-19 | Italy | Sicilia | 230452 | 5936 | 218901 | 5615 | 38.11569725 | 13.362356699999998 | 2021-06-20 04:21:48 | Sicilia, Italy | ||
107446 | 107446 | 2021-06-19 | Italy | Toscana | 243809 | 6842 | 233679 | 3288 | 43.76923077 | 11.25588885 | 2021-06-20 04:21:48 | Toscana, Italy | ||
107447 | 107447 | 2021-06-19 | Italy | Umbria | 56744 | 1418 | 54432 | 894 | 43.10675841 | 12.38824698 | 2021-06-20 04:21:48 | Umbria, Italy | ||
107448 | 107448 | 2021-06-19 | Italy | Valle d'Aosta | 11670 | 472 | 11137 | 61 | 45.73750286 | 7.320149366 | 2021-06-20 04:21:48 | Valle d'Aosta, Italy | ||
107449 | 107449 | 2021-06-19 | Italy | Veneto | 424983 | 11602 | 408096 | 5285 | 45.43490485 | 12.33845213 | 2021-06-20 04:21:48 | Veneto, Italy | ||
1125572 | 1125572 | 2021-06-18 | Italy | Abruzzo | 74570 | 2507 | 70786 | 1277 | 42.35122196 | 13.39843823 | 2021-06-19 04:22:33 | Abruzzo, Italy | ||
1125573 | 1125573 | 2021-06-18 | Italy | Basilicata | 26778 | 587 | 23456 | 2735 | 40.63947052 | 15.80514834 | 2021-06-19 04:22:33 | Basilicata, Italy | ||
1125574 | 1125574 | 2021-06-18 | Italy | Calabria | 68494 | 1217 | 60256 | 7021 | 38.90597598 | 16.59440194 | 2021-06-19 04:22:33 | Calabria, Italy | ||
1125575 | 1125575 | 2021-06-18 | Italy | Campania | 423160 | 7379 | 405009 | 10772 | 40.83956555 | 14.25084984 | 2021-06-19 04:22:33 | Campania, Italy | ||
1125576 | 1125576 | 2021-06-18 | Italy | Emilia-Romagna | 386099 | 13245 | 366860 | 5994 | 44.49436681 | 11.3417208 | 2021-06-19 04:22:33 | Emilia-Romagna, Italy | ||
1125577 | 1125577 | 2021-06-18 | Italy | Friuli Venezia Giulia | 107454 | 3798 | 99142 | 4514 | 45.6494354 | 13.76813649 | 2021-06-19 04:22:33 | Friuli Venezia Giulia, Italy | ||
1125578 | 1125578 | 2021-06-18 | Italy | Lazio | 345045 | 8303 | 332268 | 4474 | 41.89277044 | 12.48366722 | 2021-06-19 04:22:33 | Lazio, Italy | ||
1125579 | 1125579 | 2021-06-18 | Italy | Liguria | 103119 | 4344 | 98489 | 286 | 44.41149315 | 8.9326992 | 2021-06-19 04:22:33 | Liguria, Italy | ||
1125580 | 1125580 | 2021-06-18 | Italy | Lombardia | 840361 | 33748 | 792781 | 13832 | 45.46679409 | 9.190347404 | 2021-06-19 04:22:33 | Lombardia, Italy | ||
1125581 | 1125581 | 2021-06-18 | Italy | Marche | 103508 | 3030 | 98277 | 2201 | 43.61675973 | 13.5188753 | 2021-06-19 04:22:33 | Marche, Italy | ||
1125582 | 1125582 | 2021-06-18 | Italy | Molise | 13663 | 491 | 13090 | 82 | 41.55774754 | 14.65916051 | 2021-06-19 04:22:33 | Molise, Italy | ||
1125583 | 1125583 | 2021-06-18 | Italy | P.A. Bolzano | 73238 | 1180 | 71753 | 305 | 46.49933453 | 11.35662422 | 2021-06-19 04:22:33 | P.A. Bolzano, Italy | ||
1125584 | 1125584 | 2021-06-18 | Italy | P.A. Trento | 45719 | 1361 | 44180 | 178 | 46.06893511 | 11.12123097 | 2021-06-19 04:22:33 | P.A. Trento, Italy | ||
1125585 | 1125585 | 2021-06-18 | Italy | Piemonte | 362497 | 11686 | 348906 | 1905 | 45.0732745 | 7.680687483 | 2021-06-19 04:22:33 | Piemonte, Italy | ||
1125586 | 1125586 | 2021-06-18 | Italy | Puglia | 252757 | 6601 | 236813 | 9343 | 41.12559576 | 16.86736689 | 2021-06-19 04:22:33 | Puglia, Italy | ||
1125587 | 1125587 | 2021-06-18 | Italy | Sardegna | 57096 | 1485 | 44005 | 11606 | 39.21531192 | 9.110616306 | 2021-06-19 04:22:33 | Sardegna, Italy | ||
1125588 | 1125588 | 2021-06-18 | Italy | Sicilia | 230269 | 5931 | 218636 | 5702 | 38.11569725 | 13.362356699999998 | 2021-06-19 04:22:33 | Sicilia, Italy | ||
1125589 | 1125589 | 2021-06-18 | Italy | Toscana | 243747 | 6841 | 233436 | 3470 | 43.76923077 | 11.25588885 | 2021-06-19 04:22:33 | Toscana, Italy | ||
1125590 | 1125590 | 2021-06-18 | Italy | Umbria | 56736 | 1418 | 54392 | 926 | 43.10675841 | 12.38824698 | 2021-06-19 04:22:33 | Umbria, Italy | ||
1125591 | 1125591 | 2021-06-18 | Italy | Valle d'Aosta | 11667 | 472 | 11131 | 64 | 45.73750286 | 7.320149366 | 2021-06-19 04:22:33 | Valle d'Aosta, Italy | ||
1125592 | 1125592 | 2021-06-18 | Italy | Veneto | 424925 | 11601 | 407939 | 5385 | 45.43490485 | 12.33845213 | 2021-06-19 04:22:33 | Veneto, Italy | ||
2911150 | 2911150 | 2021-06-17 | Italy | Abruzzo | 74545 | 2507 | 70736 | 1302 | 42.35122196 | 13.39843823 | 2021-06-18 04:22:16 | Abruzzo, Italy | ||
2911151 | 2911151 | 2021-06-17 | Italy | Basilicata | 26764 | 587 | 23401 | 2776 | 40.63947052 | 15.80514834 | 2021-06-18 04:22:16 | Basilicata, Italy | ||
2911152 | 2911152 | 2021-06-17 | Italy | Calabria | 68417 | 1217 | 59864 | 7336 | 38.90597598 | 16.59440194 | 2021-06-18 04:22:16 | Calabria, Italy | ||
2911153 | 2911153 | 2021-06-17 | Italy | Campania | 423053 | 7371 | 404602 | 11080 | 40.83956555 | 14.25084984 | 2021-06-18 04:22:16 | Campania, Italy | ||
2911154 | 2911154 | 2021-06-17 | Italy | Emilia-Romagna | 386028 | 13239 | 366551 | 6238 | 44.49436681 | 11.3417208 | 2021-06-18 04:22:16 | Emilia-Romagna, Italy | ||
2911155 | 2911155 | 2021-06-17 | Italy | Friuli Venezia Giulia | 107431 | 3797 | 99100 | 4534 | 45.6494354 | 13.76813649 | 2021-06-18 04:22:16 | Friuli Venezia Giulia, Italy | ||
2911156 | 2911156 | 2021-06-17 | Italy | Lazio | 344898 | 8300 | 331704 | 4894 | 41.89277044 | 12.48366722 | 2021-06-18 04:22:16 | Lazio, Italy | ||
2911157 | 2911157 | 2021-06-17 | Italy | Liguria | 103103 | 4343 | 98472 | 288 | 44.41149315 | 8.9326992 | 2021-06-18 04:22:16 | Liguria, Italy | ||
2911158 | 2911158 | 2021-06-17 | Italy | Lombardia | 840247 | 33746 | 789375 | 17126 | 45.46679409 | 9.190347404 | 2021-06-18 04:22:16 | Lombardia, Italy | ||
2911159 | 2911159 | 2021-06-17 | Italy | Marche | 103480 | 3028 | 98019 | 2433 | 43.61675973 | 13.5188753 | 2021-06-18 04:22:16 | Marche, Italy | ||
2911160 | 2911160 | 2021-06-17 | Italy | Molise | 13651 | 491 | 13087 | 73 | 41.55774754 | 14.65916051 | 2021-06-18 04:22:16 | Molise, Italy | ||
2911161 | 2911161 | 2021-06-17 | Italy | P.A. Bolzano | 73229 | 1180 | 71721 | 328 | 46.49933453 | 11.35662422 | 2021-06-18 04:22:16 | P.A. Bolzano, Italy | ||
2911162 | 2911162 | 2021-06-17 | Italy | P.A. Trento | 45711 | 1361 | 44159 | 191 | 46.06893511 | 11.12123097 | 2021-06-18 04:22:16 | P.A. Trento, Italy | ||
2911163 | 2911163 | 2021-06-17 | Italy | Piemonte | 362439 | 11684 | 348696 | 2059 | 45.0732745 | 7.680687483 | 2021-06-18 04:22:16 | Piemonte, Italy | ||
2911164 | 2911164 | 2021-06-17 | Italy | Puglia | 252651 | 6597 | 235823 | 10231 | 41.12559576 | 16.86736689 | 2021-06-18 04:22:16 | Puglia, Italy | ||
2911165 | 2911165 | 2021-06-17 | Italy | Sardegna | 57088 | 1485 | 43960 | 11643 | 39.21531192 | 9.110616306 | 2021-06-18 04:22:16 | Sardegna, Italy | ||
2911166 | 2911166 | 2021-06-17 | Italy | Sicilia | 230099 | 5928 | 218270 | 5901 | 38.11569725 | 13.362356699999998 | 2021-06-18 04:22:16 | Sicilia, Italy | ||
2911167 | 2911167 | 2021-06-17 | Italy | Toscana | 243680 | 6838 | 233201 | 3641 | 43.76923077 | 11.25588885 | 2021-06-18 04:22:16 | Toscana, Italy | ||
2911168 | 2911168 | 2021-06-17 | Italy | Umbria | 56723 | 1418 | 54352 | 953 | 43.10675841 | 12.38824698 | 2021-06-18 04:22:16 | Umbria, Italy | ||
2911169 | 2911169 | 2021-06-17 | Italy | Valle d'Aosta | 11665 | 472 | 11119 | 74 | 45.73750286 | 7.320149366 | 2021-06-18 04:22:16 | Valle d'Aosta, Italy | ||
2911170 | 2911170 | 2021-06-17 | Italy | Veneto | 424853 | 11601 | 407745 | 5507 | 45.43490485 | 12.33845213 | 2021-06-18 04:22:16 | Veneto, Italy | ||
3030268 | 3030268 | 2021-06-16 | Italy | Abruzzo | 74523 | 2506 | 70658 | 1359 | 42.35122196 | 13.39843823 | 2021-06-17 04:22:36 | Abruzzo, Italy | ||
3030269 | 3030269 | 2021-06-16 | Italy | Basilicata | 26733 | 587 | 23305 | 2841 | 40.63947052 | 15.80514834 | 2021-06-17 04:22:36 | Basilicata, Italy | ||
3030270 | 3030270 | 2021-06-16 | Italy | Calabria | 68348 | 1214 | 59717 | 7417 | 38.90597598 | 16.59440194 | 2021-06-17 04:22:36 | Calabria, Italy | ||
3030271 | 3030271 | 2021-06-16 | Italy | Campania | 422922 | 7363 | 404125 | 11434 | 40.83956555 | 14.25084984 | 2021-06-17 04:22:36 | Campania, Italy | ||
3030272 | 3030272 | 2021-06-16 | Italy | Emilia-Romagna | 385941 | 13239 | 366031 | 6671 | 44.49436681 | 11.3417208 | 2021-06-17 04:22:36 | Emilia-Romagna, Italy | ||
3030273 | 3030273 | 2021-06-16 | Italy | Friuli Venezia Giulia | 107408 | 3795 | 99073 | 4540 | 45.6494354 | 13.76813649 | 2021-06-17 04:22:36 | Friuli Venezia Giulia, Italy | ||
3030274 | 3030274 | 2021-06-16 | Italy | Lazio | 344779 | 8292 | 331243 | 5244 | 41.89277044 | 12.48366722 | 2021-06-17 04:22:36 | Lazio, Italy | ||
3030275 | 3030275 | 2021-06-16 | Italy | Liguria | 103085 | 4343 | 98425 | 317 | 44.41149315 | 8.9326992 | 2021-06-17 04:22:36 | Liguria, Italy | ||
3030276 | 3030276 | 2021-06-16 | Italy | Lombardia | 840015 | 33742 | 789029 | 17244 | 45.46679409 | 9.190347404 | 2021-06-17 04:22:36 | Lombardia, Italy | ||
3030277 | 3030277 | 2021-06-16 | Italy | Marche | 103459 | 3026 | 97783 | 2650 | 43.61675973 | 13.5188753 | 2021-06-17 04:22:36 | Marche, Italy | ||
3030278 | 3030278 | 2021-06-16 | Italy | Molise | 13647 | 491 | 13078 | 78 | 41.55774754 | 14.65916051 | 2021-06-17 04:22:36 | Molise, Italy | ||
3030279 | 3030279 | 2021-06-16 | Italy | P.A. Bolzano | 73210 | 1180 | 71672 | 358 | 46.49933453 | 11.35662422 | 2021-06-17 04:22:36 | P.A. Bolzano, Italy | ||
3030280 | 3030280 | 2021-06-16 | Italy | P.A. Trento | 45700 | 1360 | 44147 | 193 | 46.06893511 | 11.12123097 | 2021-06-17 04:22:36 | P.A. Trento, Italy | ||
3030281 | 3030281 | 2021-06-16 | Italy | Piemonte | 362367 | 11684 | 348484 | 2199 | 45.0732745 | 7.680687483 | 2021-06-17 04:22:36 | Piemonte, Italy | ||
3030282 | 3030282 | 2021-06-16 | Italy | Puglia | 252561 | 6595 | 234937 | 11029 | 41.12559576 | 16.86736689 | 2021-06-17 04:22:36 | Puglia, Italy | ||
3030283 | 3030283 | 2021-06-16 | Italy | Sardegna | 57085 | 1485 | 43836 | 11764 | 39.21531192 | 9.110616306 | 2021-06-17 04:22:36 | Sardegna, Italy |
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]);