johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15,048 rows where country_or_region = "US" and deaths = 50 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
province_or_state >30
- Texas 1,115
- Iowa 1,041
- Virginia 982
- Georgia 954
- Kentucky 902
- Missouri 721
- Arkansas 580
- Tennessee 567
- Illinois 558
- Ohio 548
- Indiana 538
- Nebraska 464
- Minnesota 451
- North Carolina 443
- Mississippi 411
- Michigan 358
- Louisiana 353
- Wisconsin 318
- Kansas 309
- West Virginia 298
- South Carolina 264
- Montana 253
- California 232
- Oregon 212
- Oklahoma 203
- South Dakota 188
- Alabama 180
- Idaho 179
- New York 177
- Utah 169
- …
country_or_region 1
- US · 15,048 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753511 | 2753511 | 2022-12-29 | US | Colorado | Bent | 8011 | 2923 | 50 | 0 | 37.95474293 | -103.0720195 | 2022-12-30 04:21:04 | Bent, Colorado, US | |
2754106 | 2754106 | 2022-12-29 | US | Iowa | Hancock | 19081 | 3225 | 50 | 0 | 43.08178477 | -93.73454884 | 2022-12-30 04:21:04 | Hancock, Iowa, US | |
2754131 | 2754131 | 2022-12-29 | US | Iowa | Mitchell | 19131 | 2780 | 50 | 0 | 43.35638371 | -92.78887719 | 2022-12-30 04:21:04 | Mitchell, Iowa, US | |
2754371 | 2754371 | 2022-12-29 | US | Kentucky | Powell | 21197 | 6236 | 50 | 0 | 37.83218794 | -83.82553961 | 2022-12-30 04:21:04 | Powell, Kentucky, US | |
2754763 | 2754763 | 2022-12-29 | US | Mississippi | Tunica | 28143 | 2984 | 50 | 0 | 34.64967704 | -90.37481167 | 2022-12-30 04:21:04 | Tunica, Mississippi, US | |
2754844 | 2754844 | 2022-12-29 | US | Missouri | Monroe | 29137 | 2473 | 50 | 0 | 39.49593978 | -92.00043978 | 2022-12-30 04:21:04 | Monroe, Missouri, US | |
2754849 | 2754849 | 2022-12-29 | US | Missouri | Nodaway | 29147 | 7165 | 50 | 0 | 40.36079813 | -94.88133008 | 2022-12-30 04:21:04 | Nodaway, Missouri, US | |
2754961 | 2754961 | 2022-12-29 | US | Nebraska | Cass | 31025 | 6985 | 50 | 0 | 40.90899107 | -96.13971217 | 2022-12-30 04:21:04 | Cass, Nebraska, US | |
2755028 | 2755028 | 2022-12-29 | US | Nebraska | Seward | 31159 | 3650 | 50 | 0 | 40.87241834 | -97.139673 | 2022-12-30 04:21:04 | Seward, Nebraska, US | |
2755213 | 2755213 | 2022-12-29 | US | North Carolina | Clay | 37043 | 3233 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-12-30 04:21:04 | Clay, North Carolina, US | |
2756057 | 2756057 | 2022-12-29 | US | Texas | La Salle | 48283 | 2563 | 50 | 0 | 28.34453111 | -99.09908775 | 2022-12-30 04:21:04 | La Salle, Texas, US | |
2756078 | 2756078 | 2022-12-29 | US | Texas | McCulloch | 48307 | 1759 | 50 | 0 | 31.1925468 | -99.34682807 | 2022-12-30 04:21:04 | McCulloch, Texas, US | |
2756086 | 2756086 | 2022-12-29 | US | Texas | Mitchell | 48335 | 2082 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-12-30 04:21:04 | Mitchell, Texas, US | |
1074517 | 1074517 | 2022-12-28 | US | Colorado | Bent | 8011 | 2922 | 50 | 0 | 37.95474293 | -103.0720195 | 2022-12-29 04:21:01 | Bent, Colorado, US | |
1075112 | 1075112 | 2022-12-28 | US | Iowa | Hancock | 19081 | 3225 | 50 | 0 | 43.08178477 | -93.73454884 | 2022-12-29 04:21:01 | Hancock, Iowa, US | |
1075137 | 1075137 | 2022-12-28 | US | Iowa | Mitchell | 19131 | 2780 | 50 | 0 | 43.35638371 | -92.78887719 | 2022-12-29 04:21:01 | Mitchell, Iowa, US | |
1075377 | 1075377 | 2022-12-28 | US | Kentucky | Powell | 21197 | 6236 | 50 | 0 | 37.83218794 | -83.82553961 | 2022-12-29 04:21:01 | Powell, Kentucky, US | |
1075769 | 1075769 | 2022-12-28 | US | Mississippi | Tunica | 28143 | 2984 | 50 | 0 | 34.64967704 | -90.37481167 | 2022-12-29 04:21:01 | Tunica, Mississippi, US | |
1075850 | 1075850 | 2022-12-28 | US | Missouri | Monroe | 29137 | 2473 | 50 | 0 | 39.49593978 | -92.00043978 | 2022-12-29 04:21:01 | Monroe, Missouri, US | |
1075855 | 1075855 | 2022-12-28 | US | Missouri | Nodaway | 29147 | 7165 | 50 | 0 | 40.36079813 | -94.88133008 | 2022-12-29 04:21:01 | Nodaway, Missouri, US | |
1075967 | 1075967 | 2022-12-28 | US | Nebraska | Cass | 31025 | 6985 | 50 | 0 | 40.90899107 | -96.13971217 | 2022-12-29 04:21:01 | Cass, Nebraska, US | |
1076034 | 1076034 | 2022-12-28 | US | Nebraska | Seward | 31159 | 3650 | 50 | 0 | 40.87241834 | -97.139673 | 2022-12-29 04:21:01 | Seward, Nebraska, US | |
1076219 | 1076219 | 2022-12-28 | US | North Carolina | Clay | 37043 | 3233 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-12-29 04:21:01 | Clay, North Carolina, US | |
1077063 | 1077063 | 2022-12-28 | US | Texas | La Salle | 48283 | 2563 | 50 | 0 | 28.34453111 | -99.09908775 | 2022-12-29 04:21:01 | La Salle, Texas, US | |
1077084 | 1077084 | 2022-12-28 | US | Texas | McCulloch | 48307 | 1759 | 50 | 0 | 31.1925468 | -99.34682807 | 2022-12-29 04:21:01 | McCulloch, Texas, US | |
1077092 | 1077092 | 2022-12-28 | US | Texas | Mitchell | 48335 | 2082 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-12-29 04:21:01 | Mitchell, Texas, US | |
329109 | 329109 | 2022-12-27 | US | Iowa | Hancock | 19081 | 3221 | 50 | 0 | 43.08178477 | -93.73454884 | 2022-12-28 04:21:04 | Hancock, Iowa, US | |
329134 | 329134 | 2022-12-27 | US | Iowa | Mitchell | 19131 | 2767 | 50 | 0 | 43.35638371 | -92.78887719 | 2022-12-28 04:21:04 | Mitchell, Iowa, US | |
329374 | 329374 | 2022-12-27 | US | Kentucky | Powell | 21197 | 6236 | 50 | 0 | 37.83218794 | -83.82553961 | 2022-12-28 04:21:04 | Powell, Kentucky, US | |
329766 | 329766 | 2022-12-27 | US | Mississippi | Tunica | 28143 | 2984 | 50 | 0 | 34.64967704 | -90.37481167 | 2022-12-28 04:21:04 | Tunica, Mississippi, US | |
329847 | 329847 | 2022-12-27 | US | Missouri | Monroe | 29137 | 2473 | 50 | 0 | 39.49593978 | -92.00043978 | 2022-12-28 04:21:04 | Monroe, Missouri, US | |
329852 | 329852 | 2022-12-27 | US | Missouri | Nodaway | 29147 | 7165 | 50 | 0 | 40.36079813 | -94.88133008 | 2022-12-28 04:21:04 | Nodaway, Missouri, US | |
329964 | 329964 | 2022-12-27 | US | Nebraska | Cass | 31025 | 6985 | 50 | 0 | 40.90899107 | -96.13971217 | 2022-12-28 04:21:04 | Cass, Nebraska, US | |
330031 | 330031 | 2022-12-27 | US | Nebraska | Seward | 31159 | 3650 | 50 | 0 | 40.87241834 | -97.139673 | 2022-12-28 04:21:04 | Seward, Nebraska, US | |
330216 | 330216 | 2022-12-27 | US | North Carolina | Clay | 37043 | 3233 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-12-28 04:21:04 | Clay, North Carolina, US | |
331060 | 331060 | 2022-12-27 | US | Texas | La Salle | 48283 | 2560 | 50 | 0 | 28.34453111 | -99.09908775 | 2022-12-28 04:21:04 | La Salle, Texas, US | |
331081 | 331081 | 2022-12-27 | US | Texas | McCulloch | 48307 | 1737 | 50 | 0 | 31.1925468 | -99.34682807 | 2022-12-28 04:21:04 | McCulloch, Texas, US | |
331089 | 331089 | 2022-12-27 | US | Texas | Mitchell | 48335 | 2077 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-12-28 04:21:04 | Mitchell, Texas, US | |
219182 | 219182 | 2022-12-26 | US | Iowa | Hancock | 19081 | 3221 | 50 | 0 | 43.08178477 | -93.73454884 | 2022-12-27 04:21:07 | Hancock, Iowa, US | |
219207 | 219207 | 2022-12-26 | US | Iowa | Mitchell | 19131 | 2767 | 50 | 0 | 43.35638371 | -92.78887719 | 2022-12-27 04:21:07 | Mitchell, Iowa, US | |
219839 | 219839 | 2022-12-26 | US | Mississippi | Tunica | 28143 | 2970 | 50 | 0 | 34.64967704 | -90.37481167 | 2022-12-27 04:21:07 | Tunica, Mississippi, US | |
219920 | 219920 | 2022-12-26 | US | Missouri | Monroe | 29137 | 2470 | 50 | 0 | 39.49593978 | -92.00043978 | 2022-12-27 04:21:07 | Monroe, Missouri, US | |
219925 | 219925 | 2022-12-26 | US | Missouri | Nodaway | 29147 | 7165 | 50 | 0 | 40.36079813 | -94.88133008 | 2022-12-27 04:21:07 | Nodaway, Missouri, US | |
220037 | 220037 | 2022-12-26 | US | Nebraska | Cass | 31025 | 6985 | 50 | 0 | 40.90899107 | -96.13971217 | 2022-12-27 04:21:07 | Cass, Nebraska, US | |
220104 | 220104 | 2022-12-26 | US | Nebraska | Seward | 31159 | 3650 | 50 | 0 | 40.87241834 | -97.139673 | 2022-12-27 04:21:07 | Seward, Nebraska, US | |
220289 | 220289 | 2022-12-26 | US | North Carolina | Clay | 37043 | 3233 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-12-27 04:21:07 | Clay, North Carolina, US | |
221133 | 221133 | 2022-12-26 | US | Texas | La Salle | 48283 | 2560 | 50 | 0 | 28.34453111 | -99.09908775 | 2022-12-27 04:21:07 | La Salle, Texas, US | |
221154 | 221154 | 2022-12-26 | US | Texas | McCulloch | 48307 | 1737 | 50 | 0 | 31.1925468 | -99.34682807 | 2022-12-27 04:21:07 | McCulloch, Texas, US | |
221162 | 221162 | 2022-12-26 | US | Texas | Mitchell | 48335 | 2077 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-12-27 04:21:07 | Mitchell, Texas, US | |
3223639 | 3223639 | 2022-12-25 | US | Iowa | Hancock | 19081 | 3221 | 50 | 0 | 43.08178477 | -93.73454884 | 2022-12-26 04:21:06 | Hancock, Iowa, US | |
3223664 | 3223664 | 2022-12-25 | US | Iowa | Mitchell | 19131 | 2767 | 50 | 0 | 43.35638371 | -92.78887719 | 2022-12-26 04:21:06 | Mitchell, Iowa, US | |
3224296 | 3224296 | 2022-12-25 | US | Mississippi | Tunica | 28143 | 2970 | 50 | 0 | 34.64967704 | -90.37481167 | 2022-12-26 04:21:06 | Tunica, Mississippi, US | |
3224377 | 3224377 | 2022-12-25 | US | Missouri | Monroe | 29137 | 2470 | 50 | 0 | 39.49593978 | -92.00043978 | 2022-12-26 04:21:06 | Monroe, Missouri, US | |
3224382 | 3224382 | 2022-12-25 | US | Missouri | Nodaway | 29147 | 7165 | 50 | 0 | 40.36079813 | -94.88133008 | 2022-12-26 04:21:06 | Nodaway, Missouri, US | |
3224494 | 3224494 | 2022-12-25 | US | Nebraska | Cass | 31025 | 6985 | 50 | 0 | 40.90899107 | -96.13971217 | 2022-12-26 04:21:06 | Cass, Nebraska, US | |
3224561 | 3224561 | 2022-12-25 | US | Nebraska | Seward | 31159 | 3650 | 50 | 0 | 40.87241834 | -97.139673 | 2022-12-26 04:21:06 | Seward, Nebraska, US | |
3224746 | 3224746 | 2022-12-25 | US | North Carolina | Clay | 37043 | 3233 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-12-26 04:21:06 | Clay, North Carolina, US | |
3225590 | 3225590 | 2022-12-25 | US | Texas | La Salle | 48283 | 2560 | 50 | 0 | 28.34453111 | -99.09908775 | 2022-12-26 04:21:06 | La Salle, Texas, US | |
3225611 | 3225611 | 2022-12-25 | US | Texas | McCulloch | 48307 | 1737 | 50 | 0 | 31.1925468 | -99.34682807 | 2022-12-26 04:21:06 | McCulloch, Texas, US | |
3225619 | 3225619 | 2022-12-25 | US | Texas | Mitchell | 48335 | 2077 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-12-26 04:21:06 | Mitchell, Texas, US | |
1019553 | 1019553 | 2022-12-24 | US | Iowa | Hancock | 19081 | 3221 | 50 | 0 | 43.08178477 | -93.73454884 | 2022-12-25 04:21:04 | Hancock, Iowa, US | |
1019578 | 1019578 | 2022-12-24 | US | Iowa | Mitchell | 19131 | 2767 | 50 | 0 | 43.35638371 | -92.78887719 | 2022-12-25 04:21:04 | Mitchell, Iowa, US | |
1020210 | 1020210 | 2022-12-24 | US | Mississippi | Tunica | 28143 | 2970 | 50 | 0 | 34.64967704 | -90.37481167 | 2022-12-25 04:21:04 | Tunica, Mississippi, US | |
1020291 | 1020291 | 2022-12-24 | US | Missouri | Monroe | 29137 | 2470 | 50 | 0 | 39.49593978 | -92.00043978 | 2022-12-25 04:21:04 | Monroe, Missouri, US | |
1020296 | 1020296 | 2022-12-24 | US | Missouri | Nodaway | 29147 | 7165 | 50 | 0 | 40.36079813 | -94.88133008 | 2022-12-25 04:21:04 | Nodaway, Missouri, US | |
1020408 | 1020408 | 2022-12-24 | US | Nebraska | Cass | 31025 | 6985 | 50 | 0 | 40.90899107 | -96.13971217 | 2022-12-25 04:21:04 | Cass, Nebraska, US | |
1020475 | 1020475 | 2022-12-24 | US | Nebraska | Seward | 31159 | 3650 | 50 | 0 | 40.87241834 | -97.139673 | 2022-12-25 04:21:04 | Seward, Nebraska, US | |
1020660 | 1020660 | 2022-12-24 | US | North Carolina | Clay | 37043 | 3233 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-12-25 04:21:04 | Clay, North Carolina, US | |
1021504 | 1021504 | 2022-12-24 | US | Texas | La Salle | 48283 | 2560 | 50 | 0 | 28.34453111 | -99.09908775 | 2022-12-25 04:21:04 | La Salle, Texas, US | |
1021525 | 1021525 | 2022-12-24 | US | Texas | McCulloch | 48307 | 1737 | 50 | 0 | 31.1925468 | -99.34682807 | 2022-12-25 04:21:04 | McCulloch, Texas, US | |
1021533 | 1021533 | 2022-12-24 | US | Texas | Mitchell | 48335 | 2077 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-12-25 04:21:04 | Mitchell, Texas, US | |
691576 | 691576 | 2022-12-23 | US | Iowa | Hancock | 19081 | 3221 | 50 | 0 | 43.08178477 | -93.73454884 | 2022-12-24 04:21:02 | Hancock, Iowa, US | |
691601 | 691601 | 2022-12-23 | US | Iowa | Mitchell | 19131 | 2767 | 50 | 0 | 43.35638371 | -92.78887719 | 2022-12-24 04:21:02 | Mitchell, Iowa, US | |
692233 | 692233 | 2022-12-23 | US | Mississippi | Tunica | 28143 | 2970 | 50 | 0 | 34.64967704 | -90.37481167 | 2022-12-24 04:21:02 | Tunica, Mississippi, US | |
692314 | 692314 | 2022-12-23 | US | Missouri | Monroe | 29137 | 2470 | 50 | 0 | 39.49593978 | -92.00043978 | 2022-12-24 04:21:02 | Monroe, Missouri, US | |
692319 | 692319 | 2022-12-23 | US | Missouri | Nodaway | 29147 | 7165 | 50 | 0 | 40.36079813 | -94.88133008 | 2022-12-24 04:21:02 | Nodaway, Missouri, US | |
692431 | 692431 | 2022-12-23 | US | Nebraska | Cass | 31025 | 6985 | 50 | 0 | 40.90899107 | -96.13971217 | 2022-12-24 04:21:02 | Cass, Nebraska, US | |
692498 | 692498 | 2022-12-23 | US | Nebraska | Seward | 31159 | 3650 | 50 | 0 | 40.87241834 | -97.139673 | 2022-12-24 04:21:02 | Seward, Nebraska, US | |
692683 | 692683 | 2022-12-23 | US | North Carolina | Clay | 37043 | 3233 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-12-24 04:21:02 | Clay, North Carolina, US | |
693527 | 693527 | 2022-12-23 | US | Texas | La Salle | 48283 | 2560 | 50 | 0 | 28.34453111 | -99.09908775 | 2022-12-24 04:21:02 | La Salle, Texas, US | |
693548 | 693548 | 2022-12-23 | US | Texas | McCulloch | 48307 | 1737 | 50 | 0 | 31.1925468 | -99.34682807 | 2022-12-24 04:21:02 | McCulloch, Texas, US | |
693556 | 693556 | 2022-12-23 | US | Texas | Mitchell | 48335 | 2077 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-12-24 04:21:02 | Mitchell, Texas, US | |
2180222 | 2180222 | 2022-12-22 | US | Colorado | Las Animas | 8071 | 4305 | 50 | 0 | 37.3153406 | -104.0376458 | 2022-12-23 04:21:04 | Las Animas, Colorado, US | |
2180786 | 2180786 | 2022-12-22 | US | Iowa | Hancock | 19081 | 3221 | 50 | 0 | 43.08178477 | -93.73454884 | 2022-12-23 04:21:04 | Hancock, Iowa, US | |
2180811 | 2180811 | 2022-12-22 | US | Iowa | Mitchell | 19131 | 2767 | 50 | 0 | 43.35638371 | -92.78887719 | 2022-12-23 04:21:04 | Mitchell, Iowa, US | |
2181443 | 2181443 | 2022-12-22 | US | Mississippi | Tunica | 28143 | 2970 | 50 | 0 | 34.64967704 | -90.37481167 | 2022-12-23 04:21:04 | Tunica, Mississippi, US | |
2181524 | 2181524 | 2022-12-22 | US | Missouri | Monroe | 29137 | 2470 | 50 | 0 | 39.49593978 | -92.00043978 | 2022-12-23 04:21:04 | Monroe, Missouri, US | |
2181529 | 2181529 | 2022-12-22 | US | Missouri | Nodaway | 29147 | 7165 | 50 | 0 | 40.36079813 | -94.88133008 | 2022-12-23 04:21:04 | Nodaway, Missouri, US | |
2181641 | 2181641 | 2022-12-22 | US | Nebraska | Cass | 31025 | 6985 | 50 | 0 | 40.90899107 | -96.13971217 | 2022-12-23 04:21:04 | Cass, Nebraska, US | |
2181708 | 2181708 | 2022-12-22 | US | Nebraska | Seward | 31159 | 3650 | 50 | 0 | 40.87241834 | -97.139673 | 2022-12-23 04:21:04 | Seward, Nebraska, US | |
2181893 | 2181893 | 2022-12-22 | US | North Carolina | Clay | 37043 | 3233 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-12-23 04:21:04 | Clay, North Carolina, US | |
2182737 | 2182737 | 2022-12-22 | US | Texas | La Salle | 48283 | 2560 | 50 | 0 | 28.34453111 | -99.09908775 | 2022-12-23 04:21:04 | La Salle, Texas, US | |
2182758 | 2182758 | 2022-12-22 | US | Texas | McCulloch | 48307 | 1737 | 50 | 0 | 31.1925468 | -99.34682807 | 2022-12-23 04:21:04 | McCulloch, Texas, US | |
2182766 | 2182766 | 2022-12-22 | US | Texas | Mitchell | 48335 | 2077 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-12-23 04:21:04 | Mitchell, Texas, US | |
452026 | 452026 | 2022-12-21 | US | Colorado | Las Animas | 8071 | 4304 | 50 | 0 | 37.3153406 | -104.0376458 | 2022-12-22 04:20:56 | Las Animas, Colorado, US | |
452590 | 452590 | 2022-12-21 | US | Iowa | Hancock | 19081 | 3221 | 50 | 0 | 43.08178477 | -93.73454884 | 2022-12-22 04:20:56 | Hancock, Iowa, US | |
452615 | 452615 | 2022-12-21 | US | Iowa | Mitchell | 19131 | 2767 | 50 | 0 | 43.35638371 | -92.78887719 | 2022-12-22 04:20:56 | Mitchell, Iowa, US | |
453247 | 453247 | 2022-12-21 | US | Mississippi | Tunica | 28143 | 2970 | 50 | 0 | 34.64967704 | -90.37481167 | 2022-12-22 04:20:56 | Tunica, Mississippi, US | |
453328 | 453328 | 2022-12-21 | US | Missouri | Monroe | 29137 | 2470 | 50 | 0 | 39.49593978 | -92.00043978 | 2022-12-22 04:20:56 | Monroe, Missouri, US | |
453333 | 453333 | 2022-12-21 | US | Missouri | Nodaway | 29147 | 7165 | 50 | 0 | 40.36079813 | -94.88133008 | 2022-12-22 04:20:56 | Nodaway, Missouri, 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]);