johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
239 rows where country_or_region = "US" and deaths = 766 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- California 62
- Texas 25
- Pennsylvania 24
- Louisiana 13
- Florida 11
- Washington 9
- Indiana 8
- Kansas 8
- Ohio 8
- Virginia 8
- New York 7
- Tennessee 7
- Colorado 6
- South Carolina 6
- West Virginia 6
- Nebraska 4
- Maryland 3
- Minnesota 3
- North Carolina 3
- Alabama 2
- Illinois 2
- Massachusetts 2
- New Mexico 2
- Arizona 1
- Georgia 1
- Hawaii 1
- Kentucky 1
- Michigan 1
- Mississippi 1
- New Jersey 1
- …
country_or_region 1
- US · 239 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753570 | 2753570 | 2022-12-29 | US | Colorado | Weld | 8123 | 104312 | 766 | 0 | 40.55499405 | -104.3929621 | 2022-12-30 04:21:04 | Weld, Colorado, US | |
1074576 | 1074576 | 2022-12-28 | US | Colorado | Weld | 8123 | 104263 | 766 | 0 | 40.55499405 | -104.3929621 | 2022-12-29 04:21:01 | Weld, Colorado, US | |
3715258 | 3715258 | 2022-12-06 | US | Indiana | Elkhart | 18039 | 59728 | 766 | 0 | 41.59761169 | -85.85875695 | 2022-12-07 04:20:58 | Elkhart, Indiana, US | |
2415963 | 2415963 | 2022-12-05 | US | Indiana | Elkhart | 18039 | 59728 | 766 | 0 | 41.59761169 | -85.85875695 | 2022-12-06 04:21:03 | Elkhart, Indiana, US | |
719571 | 719571 | 2022-12-04 | US | Indiana | Elkhart | 18039 | 59728 | 766 | 0 | 41.59761169 | -85.85875695 | 2022-12-05 04:20:58 | Elkhart, Indiana, US | |
2817860 | 2817860 | 2022-12-03 | US | Indiana | Elkhart | 18039 | 59728 | 766 | 0 | 41.59761169 | -85.85875695 | 2022-12-04 04:20:56 | Elkhart, Indiana, US | |
834716 | 834716 | 2022-12-02 | US | Indiana | Elkhart | 18039 | 59728 | 766 | 0 | 41.59761169 | -85.85875695 | 2022-12-03 04:21:02 | Elkhart, Indiana, US | |
2137246 | 2137246 | 2022-12-01 | US | Indiana | Elkhart | 18039 | 59728 | 766 | 0 | 41.59761169 | -85.85875695 | 2022-12-02 04:21:07 | Elkhart, Indiana, US | |
1965662 | 1965662 | 2022-11-30 | US | Indiana | Elkhart | 18039 | 59728 | 766 | 0 | 41.59761169 | -85.85875695 | 2022-12-01 04:21:03 | Elkhart, Indiana, US | |
2559728 | 2559728 | 2022-11-29 | US | Texas | Johnson | 48251 | 50051 | 766 | 0 | 32.37877812 | -97.36615819 | 2022-11-30 04:21:07 | Johnson, Texas, US | |
1242802 | 1242802 | 2022-11-28 | US | Texas | Johnson | 48251 | 50051 | 766 | 0 | 32.37877812 | -97.36615819 | 2022-11-29 04:21:05 | Johnson, Texas, US | |
3554790 | 3554790 | 2022-11-27 | US | Texas | Johnson | 48251 | 49966 | 766 | 0 | 32.37877812 | -97.36615819 | 2022-11-28 04:21:02 | Johnson, Texas, US | |
2103270 | 2103270 | 2022-11-26 | US | Texas | Johnson | 48251 | 49966 | 766 | 0 | 32.37877812 | -97.36615819 | 2022-11-27 04:21:05 | Johnson, Texas, US | |
490761 | 490761 | 2022-11-25 | US | Texas | Johnson | 48251 | 49966 | 766 | 0 | 32.37877812 | -97.36615819 | 2022-11-26 04:21:11 | Johnson, Texas, US | |
3526590 | 3526590 | 2022-11-24 | US | Texas | Johnson | 48251 | 49966 | 766 | 0 | 32.37877812 | -97.36615819 | 2022-11-25 04:21:06 | Johnson, Texas, US | |
3315373 | 3315373 | 2022-11-23 | US | Texas | Johnson | 48251 | 49966 | 766 | 0 | 32.37877812 | -97.36615819 | 2022-11-24 04:21:09 | Johnson, Texas, US | |
1623414 | 1623414 | 2022-11-22 | US | Texas | Johnson | 48251 | 49928 | 766 | 0 | 32.37877812 | -97.36615819 | 2022-11-23 04:21:06 | Johnson, Texas, US | |
3463302 | 3463302 | 2022-11-21 | US | Texas | Johnson | 48251 | 49928 | 766 | 0 | 32.37877812 | -97.36615819 | 2022-11-22 04:20:47 | Johnson, Texas, US | |
1643487 | 1643487 | 2022-11-20 | US | Texas | Johnson | 48251 | 49886 | 766 | 0 | 32.37877812 | -97.36615819 | 2022-11-21 04:21:05 | Johnson, Texas, US | |
2067044 | 2067044 | 2022-11-19 | US | Texas | Johnson | 48251 | 49886 | 766 | 0 | 32.37877812 | -97.36615819 | 2022-11-20 04:21:08 | Johnson, Texas, US | |
1758438 | 1758438 | 2022-11-18 | US | Texas | Johnson | 48251 | 49886 | 766 | 0 | 32.37877812 | -97.36615819 | 2022-11-19 04:21:14 | Johnson, Texas, US | |
3214867 | 3214867 | 2022-10-12 | US | California | Monterey | 6053 | 115388 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-10-13 04:22:39 | Monterey, California, US | |
3250716 | 3250716 | 2022-10-11 | US | California | Monterey | 6053 | 115380 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-10-12 04:22:51 | Monterey, California, US | |
2967975 | 2967975 | 2022-10-10 | US | California | Monterey | 6053 | 115304 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-10-11 04:23:05 | Monterey, California, US | |
3098011 | 3098011 | 2022-10-09 | US | California | Monterey | 6053 | 115293 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-10-10 04:22:32 | Monterey, California, US | |
4003236 | 4003236 | 2022-10-08 | US | California | Monterey | 6053 | 115291 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-10-09 04:21:16 | Monterey, California, US | |
396833 | 396833 | 2022-10-07 | US | California | Monterey | 6053 | 115287 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-10-08 04:22:56 | Monterey, California, US | |
2529950 | 2529950 | 2022-10-06 | US | California | Monterey | 6053 | 115278 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-10-07 04:23:08 | Monterey, California, US | |
1811344 | 1811344 | 2022-10-05 | US | California | Monterey | 6053 | 115273 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-10-06 04:21:22 | Monterey, California, US | |
131318 | 131318 | 2022-10-04 | US | California | Monterey | 6053 | 115268 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-10-05 04:23:06 | Monterey, California, US | |
2686265 | 2686265 | 2022-10-03 | US | California | Monterey | 6053 | 115133 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-10-04 04:22:55 | Monterey, California, US | |
2260332 | 2260332 | 2022-10-02 | US | California | Monterey | 6053 | 115120 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-10-03 04:23:11 | Monterey, California, US | |
2995858 | 2995858 | 2022-10-01 | US | California | Monterey | 6053 | 115113 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-10-02 04:21:23 | Monterey, California, US | |
854184 | 854184 | 2022-09-30 | US | California | Monterey | 6053 | 115107 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-10-01 04:23:01 | Monterey, California, US | |
2376110 | 2376110 | 2022-09-29 | US | California | Monterey | 6053 | 115100 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-09-30 04:23:09 | Monterey, California, US | |
1560661 | 1560661 | 2022-09-28 | US | California | Monterey | 6053 | 115092 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-09-29 04:22:34 | Monterey, California, US | |
1562579 | 1562579 | 2022-09-28 | US | Ohio | Lake | 39085 | 56664 | 766 | 0 | 41.69710807 | -81.23676539 | 2022-09-29 04:22:34 | Lake, Ohio, US | |
3995204 | 3995204 | 2022-09-27 | US | California | Monterey | 6053 | 115076 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-09-28 04:23:01 | Monterey, California, US | |
2769532 | 2769532 | 2022-09-26 | US | California | Monterey | 6053 | 114891 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-09-27 04:23:01 | Monterey, California, US | |
1977185 | 1977185 | 2022-09-25 | US | California | Monterey | 6053 | 114878 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-09-26 04:20:52 | Monterey, California, US | |
1979617 | 1979617 | 2022-09-25 | US | Tennessee | Sullivan | 47163 | 54425 | 766 | 0 | 36.51240691 | -82.30412917 | 2022-09-26 04:20:52 | Sullivan, Tennessee, US | |
1979618 | 1979618 | 2022-09-25 | US | Tennessee | Sumner | 47165 | 61170 | 766 | 0 | 36.46824103 | -86.45917204 | 2022-09-26 04:20:52 | Sumner, Tennessee, US | |
2650352 | 2650352 | 2022-09-24 | US | California | Monterey | 6053 | 114873 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-09-25 04:23:31 | Monterey, California, US | |
2652784 | 2652784 | 2022-09-24 | US | Tennessee | Sullivan | 47163 | 54408 | 766 | 0 | 36.51240691 | -82.30412917 | 2022-09-25 04:23:31 | Sullivan, Tennessee, US | |
2652785 | 2652785 | 2022-09-24 | US | Tennessee | Sumner | 47165 | 61161 | 766 | 0 | 36.46824103 | -86.45917204 | 2022-09-25 04:23:31 | Sumner, Tennessee, US | |
384792 | 384792 | 2022-09-23 | US | California | Monterey | 6053 | 114863 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-09-24 04:21:40 | Monterey, California, US | |
387224 | 387224 | 2022-09-23 | US | Tennessee | Sullivan | 47163 | 54400 | 766 | 0 | 36.51240691 | -82.30412917 | 2022-09-24 04:21:40 | Sullivan, Tennessee, US | |
387225 | 387225 | 2022-09-23 | US | Tennessee | Sumner | 47165 | 61151 | 766 | 0 | 36.46824103 | -86.45917204 | 2022-09-24 04:21:40 | Sumner, Tennessee, US | |
1624858 | 1624858 | 2022-09-22 | US | California | Monterey | 6053 | 114854 | 766 | 0 | 36.21862405 | -121.2413397 | 2022-09-23 04:23:13 | Monterey, California, US | |
1627290 | 1627290 | 2022-09-22 | US | Tennessee | Sullivan | 47163 | 54364 | 766 | 0 | 36.51240691 | -82.30412917 | 2022-09-23 04:23:13 | Sullivan, Tennessee, US | |
993644 | 993644 | 2022-08-16 | US | Pennsylvania | Beaver | 42007 | 44237 | 766 | 0 | 40.6825484 | -80.34921611 | 2022-08-17 04:20:59 | Beaver, Pennsylvania, US | |
993650 | 993650 | 2022-08-16 | US | Pennsylvania | Butler | 42019 | 49375 | 766 | 0 | 40.91152759 | -79.91351055 | 2022-08-17 04:20:59 | Butler, Pennsylvania, US | |
994485 | 994485 | 2022-08-16 | US | West Virginia | Kanawha | 54039 | 53723 | 766 | 0 | 38.33860077 | -81.52857054 | 2022-08-17 04:20:59 | Kanawha, West Virginia, US | |
2496683 | 2496683 | 2022-08-15 | US | Pennsylvania | Beaver | 42007 | 44237 | 766 | 0 | 40.6825484 | -80.34921611 | 2022-08-16 04:20:58 | Beaver, Pennsylvania, US | |
2496689 | 2496689 | 2022-08-15 | US | Pennsylvania | Butler | 42019 | 49375 | 766 | 0 | 40.91152759 | -79.91351055 | 2022-08-16 04:20:58 | Butler, Pennsylvania, US | |
2497431 | 2497431 | 2022-08-15 | US | Virginia | Prince William | 51153 | 112664 | 766 | 0 | 38.70916224 | -77.48713689 | 2022-08-16 04:20:58 | Prince William, Virginia, US | |
2497524 | 2497524 | 2022-08-15 | US | West Virginia | Kanawha | 54039 | 53687 | 766 | 0 | 38.33860077 | -81.52857054 | 2022-08-16 04:20:58 | Kanawha, West Virginia, US | |
3650233 | 3650233 | 2022-08-14 | US | Pennsylvania | Beaver | 42007 | 44237 | 766 | 0 | 40.6825484 | -80.34921611 | 2022-08-15 04:20:59 | Beaver, Pennsylvania, US | |
3650239 | 3650239 | 2022-08-14 | US | Pennsylvania | Butler | 42019 | 49375 | 766 | 0 | 40.91152759 | -79.91351055 | 2022-08-15 04:20:59 | Butler, Pennsylvania, US | |
3650981 | 3650981 | 2022-08-14 | US | Virginia | Prince William | 51153 | 112387 | 766 | 0 | 38.70916224 | -77.48713689 | 2022-08-15 04:20:59 | Prince William, Virginia, US | |
3651074 | 3651074 | 2022-08-14 | US | West Virginia | Kanawha | 54039 | 53515 | 766 | 0 | 38.33860077 | -81.52857054 | 2022-08-15 04:20:59 | Kanawha, West Virginia, US | |
1971239 | 1971239 | 2022-08-13 | US | Pennsylvania | Beaver | 42007 | 44237 | 766 | 0 | 40.6825484 | -80.34921611 | 2022-08-14 04:20:55 | Beaver, Pennsylvania, US | |
1971245 | 1971245 | 2022-08-13 | US | Pennsylvania | Butler | 42019 | 49375 | 766 | 0 | 40.91152759 | -79.91351055 | 2022-08-14 04:20:55 | Butler, Pennsylvania, US | |
1971987 | 1971987 | 2022-08-13 | US | Virginia | Prince William | 51153 | 112387 | 766 | 0 | 38.70916224 | -77.48713689 | 2022-08-14 04:20:55 | Prince William, Virginia, US | |
1972080 | 1972080 | 2022-08-13 | US | West Virginia | Kanawha | 54039 | 53515 | 766 | 0 | 38.33860077 | -81.52857054 | 2022-08-14 04:20:55 | Kanawha, West Virginia, US | |
2891048 | 2891048 | 2022-08-12 | US | Pennsylvania | Beaver | 42007 | 44237 | 766 | 0 | 40.6825484 | -80.34921611 | 2022-08-13 04:20:52 | Beaver, Pennsylvania, US | |
2891054 | 2891054 | 2022-08-12 | US | Pennsylvania | Butler | 42019 | 49375 | 766 | 0 | 40.91152759 | -79.91351055 | 2022-08-13 04:20:52 | Butler, Pennsylvania, US | |
2891796 | 2891796 | 2022-08-12 | US | Virginia | Prince William | 51153 | 112387 | 766 | 0 | 38.70916224 | -77.48713689 | 2022-08-13 04:20:52 | Prince William, Virginia, US | |
2891889 | 2891889 | 2022-08-12 | US | West Virginia | Kanawha | 54039 | 53515 | 766 | 0 | 38.33860077 | -81.52857054 | 2022-08-13 04:20:52 | Kanawha, West Virginia, US | |
3910653 | 3910653 | 2022-08-11 | US | Pennsylvania | Beaver | 42007 | 44237 | 766 | 0 | 40.6825484 | -80.34921611 | 2022-08-12 04:20:54 | Beaver, Pennsylvania, US | |
3910659 | 3910659 | 2022-08-11 | US | Pennsylvania | Butler | 42019 | 49375 | 766 | 0 | 40.91152759 | -79.91351055 | 2022-08-12 04:20:54 | Butler, Pennsylvania, US | |
3911401 | 3911401 | 2022-08-11 | US | Virginia | Prince William | 51153 | 112220 | 766 | 0 | 38.70916224 | -77.48713689 | 2022-08-12 04:20:54 | Prince William, Virginia, US | |
3911494 | 3911494 | 2022-08-11 | US | West Virginia | Kanawha | 54039 | 53411 | 766 | 0 | 38.33860077 | -81.52857054 | 2022-08-12 04:20:54 | Kanawha, West Virginia, US | |
1348970 | 1348970 | 2022-08-10 | US | Pennsylvania | Beaver | 42007 | 44237 | 766 | 0 | 40.6825484 | -80.34921611 | 2022-08-11 04:20:49 | Beaver, Pennsylvania, US | |
1348976 | 1348976 | 2022-08-10 | US | Pennsylvania | Butler | 42019 | 49375 | 766 | 0 | 40.91152759 | -79.91351055 | 2022-08-11 04:20:49 | Butler, Pennsylvania, US | |
1349718 | 1349718 | 2022-08-10 | US | Virginia | Prince William | 51153 | 112072 | 766 | 0 | 38.70916224 | -77.48713689 | 2022-08-11 04:20:49 | Prince William, Virginia, US | |
3618605 | 3618605 | 2022-08-01 | US | Louisiana | Ouachita | 22073 | 55876 | 766 | 0 | 32.47645559 | -92.15704172 | 2022-08-02 04:20:53 | Ouachita, Louisiana, US | |
3873085 | 3873085 | 2022-07-31 | US | Louisiana | Ouachita | 22073 | 55709 | 766 | 0 | 32.47645559 | -92.15704172 | 2022-08-01 04:21:03 | Ouachita, Louisiana, US | |
675839 | 675839 | 2022-07-30 | US | Louisiana | Ouachita | 22073 | 55709 | 766 | 0 | 32.47645559 | -92.15704172 | 2022-07-31 04:21:02 | Ouachita, Louisiana, US | |
1785038 | 1785038 | 2022-07-29 | US | Louisiana | Ouachita | 22073 | 55709 | 766 | 0 | 32.47645559 | -92.15704172 | 2022-07-30 04:20:42 | Ouachita, Louisiana, US | |
1651701 | 1651701 | 2022-06-23 | US | Virginia | Chesterfield | 51041 | 80758 | 766 | 0 | 37.37373208 | -77.5868014 | 2022-06-24 04:20:58 | Chesterfield, Virginia, US | |
559387 | 559387 | 2022-06-16 | US | California | San Mateo | 6081 | 153105 | 766 | 0 | 37.4228808 | -122.3275546 | 2022-06-17 04:20:56 | San Mateo, California, US | |
3983189 | 3983189 | 2022-06-15 | US | California | San Mateo | 6081 | 152487 | 766 | 0 | 37.4228808 | -122.3275546 | 2022-06-16 04:20:55 | San Mateo, California, US | |
947430 | 947430 | 2022-06-14 | US | California | San Mateo | 6081 | 152473 | 766 | 0 | 37.4228808 | -122.3275546 | 2022-06-15 04:20:54 | San Mateo, California, US | |
2979838 | 2979838 | 2022-06-13 | US | California | San Mateo | 6081 | 152451 | 766 | 0 | 37.4228808 | -122.3275546 | 2022-06-14 04:20:52 | San Mateo, California, US | |
2235964 | 2235964 | 2022-06-12 | US | California | San Mateo | 6081 | 150851 | 766 | 0 | 37.4228808 | -122.3275546 | 2022-06-13 04:21:14 | San Mateo, California, US | |
3142162 | 3142162 | 2022-06-11 | US | California | San Mateo | 6081 | 150829 | 766 | 0 | 37.4228808 | -122.3275546 | 2022-06-12 04:20:53 | San Mateo, California, US | |
1945078 | 1945078 | 2022-06-10 | US | California | San Mateo | 6081 | 150816 | 766 | 0 | 37.4228808 | -122.3275546 | 2022-06-11 04:21:01 | San Mateo, California, US | |
1574330 | 1574330 | 2022-05-03 | US | New Mexico | Dona Ana | 35013 | 63341 | 766 | 0 | 32.35275771 | -106.8329387 | 2022-05-04 04:20:59 | Dona Ana, New Mexico, US | |
465590 | 465590 | 2022-05-02 | US | New Mexico | Dona Ana | 35013 | 63335 | 766 | 0 | 32.35275771 | -106.8329387 | 2022-05-03 04:21:00 | Dona Ana, New Mexico, US | |
3208395 | 3208395 | 2022-04-11 | US | Nebraska | Unassigned | 90031 | 3776 | 766 | 0 | 42.8997274 | 0.0 | 2022-04-12 04:20:49 | Unassigned, Nebraska, US | |
1578281 | 1578281 | 2022-04-10 | US | Nebraska | Unassigned | 90031 | 3638 | 766 | 0 | 42.8997274 | 0.0 | 2022-04-11 04:21:02 | Unassigned, Nebraska, US | |
1654523 | 1654523 | 2022-04-09 | US | Nebraska | Unassigned | 90031 | 3638 | 766 | 0 | 42.8997274 | 0.0 | 2022-04-10 04:20:52 | Unassigned, Nebraska, US | |
2117845 | 2117845 | 2022-04-08 | US | Nebraska | Unassigned | 90031 | 3638 | 766 | 0 | 42.8997274 | 0.0 | 2022-04-09 04:20:42 | Unassigned, Nebraska, US | |
3730641 | 3730641 | 2022-04-03 | US | Alabama | Tuscaloosa | 1125 | 55840 | 766 | 0 | 33.28726072 | -87.52556818 | 2022-04-04 04:20:51 | Tuscaloosa, Alabama, US | |
3731948 | 3731948 | 2022-04-03 | US | Minnesota | Dakota | 27037 | 109704 | 766 | 0 | 44.67172617 | -93.06299363 | 2022-04-04 04:20:51 | Dakota, Minnesota, US | |
500076 | 500076 | 2022-04-02 | US | Alabama | Tuscaloosa | 1125 | 55840 | 766 | 0 | 33.28726072 | -87.52556818 | 2022-04-03 04:20:48 | Tuscaloosa, Alabama, US | |
501383 | 501383 | 2022-04-02 | US | Minnesota | Dakota | 27037 | 109704 | 766 | 0 | 44.67172617 | -93.06299363 | 2022-04-03 04:20:48 | Dakota, Minnesota, US | |
3352368 | 3352368 | 2022-04-01 | US | Minnesota | Dakota | 27037 | 109704 | 766 | 0 | 44.67172617 | -93.06299363 | 2022-04-02 04:20:47 | Dakota, Minnesota, US | |
1471570 | 1471570 | 2022-03-24 | US | Washington | Yakima | 53077 | 71337 | 766 | 0 | 46.45738486 | -120.73801259999999 | 2022-03-25 04:20:46 | Yakima, Washington, 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]);