johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10,151 rows where deaths = 78 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
These facets timed out: province_or_state
country_or_region >30
- US 9,740
- Japan 68
- Russia 54
- Sweden 38
- Chile 34
- United Kingdom 33
- Malaysia 13
- India 12
- Liechtenstein 11
- Australia 10
- Ukraine 10
- Congo (Brazzaville) 9
- Andorra 8
- Colombia 7
- Netherlands 7
- Spain 7
- Peru 6
- Italy 5
- Liberia 5
- Pakistan 5
- Tajikistan 5
- France 4
- Brazil 3
- Canada 3
- Mexico 3
- Burkina Faso 2
- Germany 2
- Guyana 2
- Iraq 2
- Lebanon 2
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756494 | 2756494 | 2022-12-29 | US | Wisconsin | Taylor | 55119 | 5671 | 78 | 0 | 45.21179252 | -90.5004405 | 2022-12-30 04:21:04 | Taylor, Wisconsin, US | |
2755437 | 2755437 | 2022-12-29 | US | Oklahoma | Adair | 40001 | 9531 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-12-30 04:21:04 | Adair, Oklahoma, US | |
2755287 | 2755287 | 2022-12-29 | US | North Carolina | Watauga | 37189 | 14537 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-12-30 04:21:04 | Watauga, North Carolina, US | |
2755118 | 2755118 | 2022-12-29 | US | New Mexico | San Miguel | 35047 | 7539 | 78 | 0 | 35.48014807 | -104.8163562 | 2022-12-30 04:21:04 | San Miguel, New Mexico, US | |
2754839 | 2754839 | 2022-12-29 | US | Missouri | McDonald | 29119 | 6085 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-30 04:21:04 | McDonald, Missouri, US | |
2754698 | 2754698 | 2022-12-29 | US | Mississippi | Calhoun | 28013 | 5472 | 78 | 0 | 33.93683395 | -89.33686647 | 2022-12-30 04:21:04 | Calhoun, Mississippi, US | |
2754496 | 2754496 | 2022-12-29 | US | Maryland | Somerset | 24039 | 6039 | 78 | 0 | 38.1163542 | -75.75118623 | 2022-12-30 04:21:04 | Somerset, Maryland, US | |
2754334 | 2754334 | 2022-12-29 | US | Kentucky | Larue | 21123 | 4679 | 78 | 0 | 37.54567114 | -85.70138352 | 2022-12-30 04:21:04 | Larue, Kentucky, US | |
2754069 | 2754069 | 2022-12-29 | US | Iowa | Appanoose | 19007 | 3368 | 78 | 0 | 40.74324454 | -92.86865906 | 2022-12-30 04:21:04 | Appanoose, Iowa, US | |
2753910 | 2753910 | 2022-12-29 | US | Illinois | Jersey | 17083 | 7682 | 78 | 0 | 39.08869046 | -90.35393073 | 2022-12-30 04:21:04 | Jersey, Illinois, US | |
2753308 | 2753308 | 2022-12-29 | US | Alabama | Randolph | 1111 | 6161 | 78 | 0 | 33.29526734 | -85.45708831 | 2022-12-30 04:21:04 | Randolph, Alabama, US | |
1077500 | 1077500 | 2022-12-28 | US | Wisconsin | Taylor | 55119 | 5667 | 78 | 0 | 45.21179252 | -90.5004405 | 2022-12-29 04:21:01 | Taylor, Wisconsin, US | |
1076443 | 1076443 | 2022-12-28 | US | Oklahoma | Adair | 40001 | 9502 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-12-29 04:21:01 | Adair, Oklahoma, US | |
1076293 | 1076293 | 2022-12-28 | US | North Carolina | Watauga | 37189 | 14537 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-12-29 04:21:01 | Watauga, North Carolina, US | |
1076124 | 1076124 | 2022-12-28 | US | New Mexico | San Miguel | 35047 | 7533 | 78 | 0 | 35.48014807 | -104.8163562 | 2022-12-29 04:21:01 | San Miguel, New Mexico, US | |
1075845 | 1075845 | 2022-12-28 | US | Missouri | McDonald | 29119 | 6085 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-29 04:21:01 | McDonald, Missouri, US | |
1075704 | 1075704 | 2022-12-28 | US | Mississippi | Calhoun | 28013 | 5472 | 78 | 0 | 33.93683395 | -89.33686647 | 2022-12-29 04:21:01 | Calhoun, Mississippi, US | |
1075502 | 1075502 | 2022-12-28 | US | Maryland | Somerset | 24039 | 6033 | 78 | 0 | 38.1163542 | -75.75118623 | 2022-12-29 04:21:01 | Somerset, Maryland, US | |
1075340 | 1075340 | 2022-12-28 | US | Kentucky | Larue | 21123 | 4679 | 78 | 0 | 37.54567114 | -85.70138352 | 2022-12-29 04:21:01 | Larue, Kentucky, US | |
1075075 | 1075075 | 2022-12-28 | US | Iowa | Appanoose | 19007 | 3368 | 78 | 0 | 40.74324454 | -92.86865906 | 2022-12-29 04:21:01 | Appanoose, Iowa, US | |
1074314 | 1074314 | 2022-12-28 | US | Alabama | Randolph | 1111 | 6161 | 78 | 0 | 33.29526734 | -85.45708831 | 2022-12-29 04:21:01 | Randolph, Alabama, US | |
331497 | 331497 | 2022-12-27 | US | Wisconsin | Taylor | 55119 | 5666 | 78 | 0 | 45.21179252 | -90.5004405 | 2022-12-28 04:21:04 | Taylor, Wisconsin, US | |
330440 | 330440 | 2022-12-27 | US | Oklahoma | Adair | 40001 | 9502 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-12-28 04:21:04 | Adair, Oklahoma, US | |
330290 | 330290 | 2022-12-27 | US | North Carolina | Watauga | 37189 | 14537 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-12-28 04:21:04 | Watauga, North Carolina, US | |
330121 | 330121 | 2022-12-27 | US | New Mexico | San Miguel | 35047 | 7531 | 78 | 0 | 35.48014807 | -104.8163562 | 2022-12-28 04:21:04 | San Miguel, New Mexico, US | |
329842 | 329842 | 2022-12-27 | US | Missouri | McDonald | 29119 | 6085 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-28 04:21:04 | McDonald, Missouri, US | |
329701 | 329701 | 2022-12-27 | US | Mississippi | Calhoun | 28013 | 5472 | 78 | 0 | 33.93683395 | -89.33686647 | 2022-12-28 04:21:04 | Calhoun, Mississippi, US | |
329499 | 329499 | 2022-12-27 | US | Maryland | Somerset | 24039 | 6024 | 78 | 0 | 38.1163542 | -75.75118623 | 2022-12-28 04:21:04 | Somerset, Maryland, US | |
329337 | 329337 | 2022-12-27 | US | Kentucky | Larue | 21123 | 4679 | 78 | 0 | 37.54567114 | -85.70138352 | 2022-12-28 04:21:04 | Larue, Kentucky, US | |
328311 | 328311 | 2022-12-27 | US | Alabama | Randolph | 1111 | 6161 | 78 | 0 | 33.29526734 | -85.45708831 | 2022-12-28 04:21:04 | Randolph, Alabama, US | |
221570 | 221570 | 2022-12-26 | US | Wisconsin | Taylor | 55119 | 5663 | 78 | 0 | 45.21179252 | -90.5004405 | 2022-12-27 04:21:07 | Taylor, Wisconsin, US | |
220513 | 220513 | 2022-12-26 | US | Oklahoma | Adair | 40001 | 9502 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-12-27 04:21:07 | Adair, Oklahoma, US | |
220363 | 220363 | 2022-12-26 | US | North Carolina | Watauga | 37189 | 14537 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-12-27 04:21:07 | Watauga, North Carolina, US | |
220194 | 220194 | 2022-12-26 | US | New Mexico | San Miguel | 35047 | 7528 | 78 | 0 | 35.48014807 | -104.8163562 | 2022-12-27 04:21:07 | San Miguel, New Mexico, US | |
219915 | 219915 | 2022-12-26 | US | Missouri | McDonald | 29119 | 6071 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-27 04:21:07 | McDonald, Missouri, US | |
219774 | 219774 | 2022-12-26 | US | Mississippi | Calhoun | 28013 | 5442 | 78 | 0 | 33.93683395 | -89.33686647 | 2022-12-27 04:21:07 | Calhoun, Mississippi, US | |
219572 | 219572 | 2022-12-26 | US | Maryland | Somerset | 24039 | 6024 | 78 | 0 | 38.1163542 | -75.75118623 | 2022-12-27 04:21:07 | Somerset, Maryland, US | |
219410 | 219410 | 2022-12-26 | US | Kentucky | Larue | 21123 | 4664 | 78 | 0 | 37.54567114 | -85.70138352 | 2022-12-27 04:21:07 | Larue, Kentucky, US | |
218384 | 218384 | 2022-12-26 | US | Alabama | Randolph | 1111 | 6161 | 78 | 0 | 33.29526734 | -85.45708831 | 2022-12-27 04:21:07 | Randolph, Alabama, US | |
3226027 | 3226027 | 2022-12-25 | US | Wisconsin | Taylor | 55119 | 5658 | 78 | 0 | 45.21179252 | -90.5004405 | 2022-12-26 04:21:06 | Taylor, Wisconsin, US | |
3224970 | 3224970 | 2022-12-25 | US | Oklahoma | Adair | 40001 | 9502 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-12-26 04:21:06 | Adair, Oklahoma, US | |
3224820 | 3224820 | 2022-12-25 | US | North Carolina | Watauga | 37189 | 14537 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-12-26 04:21:06 | Watauga, North Carolina, US | |
3224651 | 3224651 | 2022-12-25 | US | New Mexico | San Miguel | 35047 | 7528 | 78 | 0 | 35.48014807 | -104.8163562 | 2022-12-26 04:21:06 | San Miguel, New Mexico, US | |
3224372 | 3224372 | 2022-12-25 | US | Missouri | McDonald | 29119 | 6071 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-26 04:21:06 | McDonald, Missouri, US | |
3224231 | 3224231 | 2022-12-25 | US | Mississippi | Calhoun | 28013 | 5442 | 78 | 0 | 33.93683395 | -89.33686647 | 2022-12-26 04:21:06 | Calhoun, Mississippi, US | |
3224029 | 3224029 | 2022-12-25 | US | Maryland | Somerset | 24039 | 6024 | 78 | 0 | 38.1163542 | -75.75118623 | 2022-12-26 04:21:06 | Somerset, Maryland, US | |
3223867 | 3223867 | 2022-12-25 | US | Kentucky | Larue | 21123 | 4664 | 78 | 0 | 37.54567114 | -85.70138352 | 2022-12-26 04:21:06 | Larue, Kentucky, US | |
3222841 | 3222841 | 2022-12-25 | US | Alabama | Randolph | 1111 | 6161 | 78 | 0 | 33.29526734 | -85.45708831 | 2022-12-26 04:21:06 | Randolph, Alabama, US | |
1021941 | 1021941 | 2022-12-24 | US | Wisconsin | Taylor | 55119 | 5658 | 78 | 0 | 45.21179252 | -90.5004405 | 2022-12-25 04:21:04 | Taylor, Wisconsin, US | |
1020884 | 1020884 | 2022-12-24 | US | Oklahoma | Adair | 40001 | 9502 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-12-25 04:21:04 | Adair, Oklahoma, US | |
1020734 | 1020734 | 2022-12-24 | US | North Carolina | Watauga | 37189 | 14537 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-12-25 04:21:04 | Watauga, North Carolina, US | |
1020565 | 1020565 | 2022-12-24 | US | New Mexico | San Miguel | 35047 | 7528 | 78 | 0 | 35.48014807 | -104.8163562 | 2022-12-25 04:21:04 | San Miguel, New Mexico, US | |
1020286 | 1020286 | 2022-12-24 | US | Missouri | McDonald | 29119 | 6071 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-25 04:21:04 | McDonald, Missouri, US | |
1020145 | 1020145 | 2022-12-24 | US | Mississippi | Calhoun | 28013 | 5442 | 78 | 0 | 33.93683395 | -89.33686647 | 2022-12-25 04:21:04 | Calhoun, Mississippi, US | |
1019943 | 1019943 | 2022-12-24 | US | Maryland | Somerset | 24039 | 6024 | 78 | 0 | 38.1163542 | -75.75118623 | 2022-12-25 04:21:04 | Somerset, Maryland, US | |
1019781 | 1019781 | 2022-12-24 | US | Kentucky | Larue | 21123 | 4664 | 78 | 0 | 37.54567114 | -85.70138352 | 2022-12-25 04:21:04 | Larue, Kentucky, US | |
1018755 | 1018755 | 2022-12-24 | US | Alabama | Randolph | 1111 | 6161 | 78 | 0 | 33.29526734 | -85.45708831 | 2022-12-25 04:21:04 | Randolph, Alabama, US | |
693964 | 693964 | 2022-12-23 | US | Wisconsin | Taylor | 55119 | 5658 | 78 | 0 | 45.21179252 | -90.5004405 | 2022-12-24 04:21:02 | Taylor, Wisconsin, US | |
692907 | 692907 | 2022-12-23 | US | Oklahoma | Adair | 40001 | 9502 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-12-24 04:21:02 | Adair, Oklahoma, US | |
692757 | 692757 | 2022-12-23 | US | North Carolina | Watauga | 37189 | 14537 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-12-24 04:21:02 | Watauga, North Carolina, US | |
692588 | 692588 | 2022-12-23 | US | New Mexico | San Miguel | 35047 | 7528 | 78 | 0 | 35.48014807 | -104.8163562 | 2022-12-24 04:21:02 | San Miguel, New Mexico, US | |
692309 | 692309 | 2022-12-23 | US | Missouri | McDonald | 29119 | 6071 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-24 04:21:02 | McDonald, Missouri, US | |
692168 | 692168 | 2022-12-23 | US | Mississippi | Calhoun | 28013 | 5442 | 78 | 0 | 33.93683395 | -89.33686647 | 2022-12-24 04:21:02 | Calhoun, Mississippi, US | |
691966 | 691966 | 2022-12-23 | US | Maryland | Somerset | 24039 | 6024 | 78 | 0 | 38.1163542 | -75.75118623 | 2022-12-24 04:21:02 | Somerset, Maryland, US | |
691804 | 691804 | 2022-12-23 | US | Kentucky | Larue | 21123 | 4664 | 78 | 0 | 37.54567114 | -85.70138352 | 2022-12-24 04:21:02 | Larue, Kentucky, US | |
690778 | 690778 | 2022-12-23 | US | Alabama | Randolph | 1111 | 6161 | 78 | 0 | 33.29526734 | -85.45708831 | 2022-12-24 04:21:02 | Randolph, Alabama, US | |
2183174 | 2183174 | 2022-12-22 | US | Wisconsin | Taylor | 55119 | 5655 | 78 | 0 | 45.21179252 | -90.5004405 | 2022-12-23 04:21:04 | Taylor, Wisconsin, US | |
2182117 | 2182117 | 2022-12-22 | US | Oklahoma | Adair | 40001 | 9502 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-12-23 04:21:04 | Adair, Oklahoma, US | |
2181967 | 2181967 | 2022-12-22 | US | North Carolina | Watauga | 37189 | 14537 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-12-23 04:21:04 | Watauga, North Carolina, US | |
2181798 | 2181798 | 2022-12-22 | US | New Mexico | San Miguel | 35047 | 7524 | 78 | 0 | 35.48014807 | -104.8163562 | 2022-12-23 04:21:04 | San Miguel, New Mexico, US | |
2181519 | 2181519 | 2022-12-22 | US | Missouri | McDonald | 29119 | 6071 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-23 04:21:04 | McDonald, Missouri, US | |
2181378 | 2181378 | 2022-12-22 | US | Mississippi | Calhoun | 28013 | 5442 | 78 | 0 | 33.93683395 | -89.33686647 | 2022-12-23 04:21:04 | Calhoun, Mississippi, US | |
2181176 | 2181176 | 2022-12-22 | US | Maryland | Somerset | 24039 | 6022 | 78 | 0 | 38.1163542 | -75.75118623 | 2022-12-23 04:21:04 | Somerset, Maryland, US | |
2181014 | 2181014 | 2022-12-22 | US | Kentucky | Larue | 21123 | 4664 | 78 | 0 | 37.54567114 | -85.70138352 | 2022-12-23 04:21:04 | Larue, Kentucky, US | |
2179988 | 2179988 | 2022-12-22 | US | Alabama | Randolph | 1111 | 6161 | 78 | 0 | 33.29526734 | -85.45708831 | 2022-12-23 04:21:04 | Randolph, Alabama, US | |
454978 | 454978 | 2022-12-21 | US | Wisconsin | Taylor | 55119 | 5655 | 78 | 0 | 45.21179252 | -90.5004405 | 2022-12-22 04:20:56 | Taylor, Wisconsin, US | |
453921 | 453921 | 2022-12-21 | US | Oklahoma | Adair | 40001 | 9477 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-12-22 04:20:56 | Adair, Oklahoma, US | |
453771 | 453771 | 2022-12-21 | US | North Carolina | Watauga | 37189 | 14537 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-12-22 04:20:56 | Watauga, North Carolina, US | |
453602 | 453602 | 2022-12-21 | US | New Mexico | San Miguel | 35047 | 7521 | 78 | 0 | 35.48014807 | -104.8163562 | 2022-12-22 04:20:56 | San Miguel, New Mexico, US | |
453323 | 453323 | 2022-12-21 | US | Missouri | McDonald | 29119 | 6071 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-22 04:20:56 | McDonald, Missouri, US | |
453182 | 453182 | 2022-12-21 | US | Mississippi | Calhoun | 28013 | 5442 | 78 | 0 | 33.93683395 | -89.33686647 | 2022-12-22 04:20:56 | Calhoun, Mississippi, US | |
452980 | 452980 | 2022-12-21 | US | Maryland | Somerset | 24039 | 6020 | 78 | 0 | 38.1163542 | -75.75118623 | 2022-12-22 04:20:56 | Somerset, Maryland, US | |
452818 | 452818 | 2022-12-21 | US | Kentucky | Larue | 21123 | 4664 | 78 | 0 | 37.54567114 | -85.70138352 | 2022-12-22 04:20:56 | Larue, Kentucky, US | |
451792 | 451792 | 2022-12-21 | US | Alabama | Randolph | 1111 | 6161 | 78 | 0 | 33.29526734 | -85.45708831 | 2022-12-22 04:20:56 | Randolph, Alabama, US | |
2954977 | 2954977 | 2022-12-20 | US | Wisconsin | Taylor | 55119 | 5649 | 78 | 0 | 45.21179252 | -90.5004405 | 2022-12-21 04:21:03 | Taylor, Wisconsin, US | |
2954448 | 2954448 | 2022-12-20 | US | Texas | Comanche | 48093 | 3925 | 78 | 0 | 31.94854689 | -98.55876441 | 2022-12-21 04:21:03 | Comanche, Texas, US | |
2953920 | 2953920 | 2022-12-20 | US | Oklahoma | Adair | 40001 | 9477 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-12-21 04:21:03 | Adair, Oklahoma, US | |
2953770 | 2953770 | 2022-12-20 | US | North Carolina | Watauga | 37189 | 14429 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-12-21 04:21:03 | Watauga, North Carolina, US | |
2953601 | 2953601 | 2022-12-20 | US | New Mexico | San Miguel | 35047 | 7519 | 78 | 0 | 35.48014807 | -104.8163562 | 2022-12-21 04:21:03 | San Miguel, New Mexico, US | |
2953322 | 2953322 | 2022-12-20 | US | Missouri | McDonald | 29119 | 6071 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-21 04:21:03 | McDonald, Missouri, US | |
2953181 | 2953181 | 2022-12-20 | US | Mississippi | Calhoun | 28013 | 5416 | 78 | 0 | 33.93683395 | -89.33686647 | 2022-12-21 04:21:03 | Calhoun, Mississippi, US | |
2952979 | 2952979 | 2022-12-20 | US | Maryland | Somerset | 24039 | 6013 | 78 | 0 | 38.1163542 | -75.75118623 | 2022-12-21 04:21:03 | Somerset, Maryland, US | |
2952817 | 2952817 | 2022-12-20 | US | Kentucky | Larue | 21123 | 4664 | 78 | 0 | 37.54567114 | -85.70138352 | 2022-12-21 04:21:03 | Larue, Kentucky, US | |
2951791 | 2951791 | 2022-12-20 | US | Alabama | Randolph | 1111 | 6129 | 78 | 0 | 33.29526734 | -85.45708831 | 2022-12-21 04:21:03 | Randolph, Alabama, US | |
3176850 | 3176850 | 2022-12-19 | US | Texas | Comanche | 48093 | 3925 | 78 | 0 | 31.94854689 | -98.55876441 | 2022-12-20 04:21:04 | Comanche, Texas, US | |
3176322 | 3176322 | 2022-12-19 | US | Oklahoma | Adair | 40001 | 9477 | 78 | 0 | 35.88494195 | -94.65859267 | 2022-12-20 04:21:04 | Adair, Oklahoma, US | |
3176172 | 3176172 | 2022-12-19 | US | North Carolina | Watauga | 37189 | 14429 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-12-20 04:21:04 | Watauga, North Carolina, US | |
3176003 | 3176003 | 2022-12-19 | US | New Mexico | San Miguel | 35047 | 7518 | 78 | 0 | 35.48014807 | -104.8163562 | 2022-12-20 04:21:04 | San Miguel, New Mexico, US | |
3175724 | 3175724 | 2022-12-19 | US | Missouri | McDonald | 29119 | 6054 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-20 04:21:04 | McDonald, Missouri, US | |
3175583 | 3175583 | 2022-12-19 | US | Mississippi | Calhoun | 28013 | 5416 | 78 | 0 | 33.93683395 | -89.33686647 | 2022-12-20 04:21:04 | Calhoun, Mississippi, US |
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]);