johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
249 rows where country_or_region = "US" and deaths = 745 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Pennsylvania 36
- Texas 27
- California 26
- Illinois 22
- Louisiana 16
- Ohio 14
- Colorado 11
- Indiana 9
- New Jersey 9
- New Mexico 8
- Tennessee 8
- Washington 8
- Georgia 7
- Michigan 7
- South Carolina 6
- Virginia 5
- Florida 4
- Minnesota 3
- Nebraska 3
- Arizona 2
- Kansas 2
- Maryland 2
- New York 2
- Utah 2
- Alabama 1
- Arkansas 1
- Connecticut 1
- Delaware 1
- Hawaii 1
- Massachusetts 1
- …
country_or_region 1
- US · 249 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
198925 | 198925 | 2022-10-19 | US | Colorado | Weld | 8123 | 100133 | 745 | 0 | 40.55499405 | -104.3929621 | 2022-10-20 04:22:59 | Weld, Colorado, US | |
2759596 | 2759596 | 2022-10-18 | US | Pennsylvania | Franklin | 42055 | 47099 | 745 | 0 | 39.92956518 | -77.72157791 | 2022-10-19 04:22:26 | Franklin, Pennsylvania, US | |
2027430 | 2027430 | 2022-10-17 | US | Pennsylvania | Franklin | 42055 | 47099 | 745 | 0 | 39.92956518 | -77.72157791 | 2022-10-18 04:22:42 | Franklin, Pennsylvania, US | |
2162208 | 2162208 | 2022-10-16 | US | Pennsylvania | Franklin | 42055 | 47099 | 745 | 0 | 39.92956518 | -77.72157791 | 2022-10-17 04:20:31 | Franklin, Pennsylvania, US | |
518405 | 518405 | 2022-10-15 | US | Pennsylvania | Franklin | 42055 | 47099 | 745 | 0 | 39.92956518 | -77.72157791 | 2022-10-16 04:22:39 | Franklin, Pennsylvania, US | |
2035462 | 2035462 | 2022-10-14 | US | Pennsylvania | Franklin | 42055 | 47099 | 745 | 0 | 39.92956518 | -77.72157791 | 2022-10-15 04:22:00 | Franklin, Pennsylvania, US | |
3756150 | 3756150 | 2022-10-13 | US | Pennsylvania | Franklin | 42055 | 47099 | 745 | 0 | 39.92956518 | -77.72157791 | 2022-10-14 04:22:28 | Franklin, Pennsylvania, US | |
3216975 | 3216975 | 2022-10-12 | US | Pennsylvania | Franklin | 42055 | 47099 | 745 | 0 | 39.92956518 | -77.72157791 | 2022-10-13 04:22:39 | Franklin, Pennsylvania, US | |
1406093 | 1406093 | 2022-08-02 | US | Illinois | St. Clair | 17163 | 72056 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-08-03 04:20:59 | St. Clair, Illinois, US | |
1408041 | 1408041 | 2022-08-02 | US | Tennessee | Sullivan | 47163 | 50261 | 745 | 0 | 36.51240691 | -82.30412917 | 2022-08-03 04:20:59 | Sullivan, Tennessee, US | |
3618131 | 3618131 | 2022-08-01 | US | Illinois | St. Clair | 17163 | 71967 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-08-02 04:20:53 | St. Clair, Illinois, US | |
3872611 | 3872611 | 2022-07-31 | US | Illinois | St. Clair | 17163 | 71766 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-08-01 04:21:03 | St. Clair, Illinois, US | |
675365 | 675365 | 2022-07-30 | US | Illinois | St. Clair | 17163 | 71766 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-07-31 04:21:02 | St. Clair, Illinois, US | |
1784564 | 1784564 | 2022-07-29 | US | Illinois | St. Clair | 17163 | 71766 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-07-30 04:20:42 | St. Clair, Illinois, US | |
1066927 | 1066927 | 2022-07-28 | US | Illinois | St. Clair | 17163 | 71646 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-07-29 04:20:45 | St. Clair, Illinois, US | |
2336446 | 2336446 | 2022-07-27 | US | Illinois | St. Clair | 17163 | 71494 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-07-28 04:20:56 | St. Clair, Illinois, US | |
1488636 | 1488636 | 2022-07-26 | US | Illinois | St. Clair | 17163 | 71457 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-07-27 04:21:04 | St. Clair, Illinois, US | |
1488672 | 1488672 | 2022-07-26 | US | Indiana | Elkhart | 18039 | 56159 | 745 | 0 | 41.59761169 | -85.85875695 | 2022-07-27 04:21:04 | Elkhart, Indiana, US | |
2595082 | 2595082 | 2022-07-25 | US | Illinois | St. Clair | 17163 | 71334 | 745 | 0 | 38.46996033 | -89.93063427 | 2022-07-26 04:20:58 | St. Clair, Illinois, US | |
2595118 | 2595118 | 2022-07-25 | US | Indiana | Elkhart | 18039 | 56159 | 745 | 0 | 41.59761169 | -85.85875695 | 2022-07-26 04:20:58 | Elkhart, Indiana, US | |
2597170 | 2597170 | 2022-07-25 | US | Texas | Johnson | 48251 | 46428 | 745 | 0 | 32.37877812 | -97.36615819 | 2022-07-26 04:20:58 | Johnson, Texas, US | |
897233 | 897233 | 2022-07-24 | US | Indiana | Elkhart | 18039 | 56119 | 745 | 0 | 41.59761169 | -85.85875695 | 2022-07-25 04:20:51 | Elkhart, Indiana, US | |
899285 | 899285 | 2022-07-24 | US | Texas | Johnson | 48251 | 46372 | 745 | 0 | 32.37877812 | -97.36615819 | 2022-07-25 04:20:51 | Johnson, Texas, US | |
92227 | 92227 | 2022-07-23 | US | Indiana | Elkhart | 18039 | 56119 | 745 | 0 | 41.59761169 | -85.85875695 | 2022-07-24 04:20:47 | Elkhart, Indiana, US | |
901249 | 901249 | 2022-07-22 | US | Indiana | Elkhart | 18039 | 56119 | 745 | 0 | 41.59761169 | -85.85875695 | 2022-07-23 04:20:53 | Elkhart, Indiana, US | |
3213281 | 3213281 | 2022-07-18 | US | Tennessee | Sumner | 47165 | 57316 | 745 | 0 | 36.46824103 | -86.45917204 | 2022-07-19 04:20:58 | Sumner, Tennessee, US | |
3408456 | 3408456 | 2022-07-17 | US | Tennessee | Sumner | 47165 | 57216 | 745 | 0 | 36.46824103 | -86.45917204 | 2022-07-18 04:20:59 | Sumner, Tennessee, US | |
3408657 | 3408657 | 2022-07-17 | US | Texas | Potter | 48375 | 37363 | 745 | 0 | 35.40133773 | -101.893964 | 2022-07-18 04:20:59 | Potter, Texas, US | |
2154656 | 2154656 | 2022-07-16 | US | Tennessee | Sumner | 47165 | 57192 | 745 | 0 | 36.46824103 | -86.45917204 | 2022-07-17 04:21:15 | Sumner, Tennessee, US | |
2154857 | 2154857 | 2022-07-16 | US | Texas | Potter | 48375 | 37363 | 745 | 0 | 35.40133773 | -101.893964 | 2022-07-17 04:21:15 | Potter, Texas, US | |
2421889 | 2421889 | 2022-07-15 | US | Tennessee | Sumner | 47165 | 57147 | 745 | 0 | 36.46824103 | -86.45917204 | 2022-07-16 04:21:05 | Sumner, Tennessee, US | |
2422090 | 2422090 | 2022-07-15 | US | Texas | Potter | 48375 | 37363 | 745 | 0 | 35.40133773 | -101.893964 | 2022-07-16 04:21:05 | Potter, Texas, US | |
3429531 | 3429531 | 2022-07-14 | US | California | Monterey | 6053 | 106139 | 745 | 0 | 36.21862405 | -121.2413397 | 2022-07-15 04:20:53 | Monterey, California, US | |
3431964 | 3431964 | 2022-07-14 | US | Tennessee | Sumner | 47165 | 57043 | 745 | 0 | 36.46824103 | -86.45917204 | 2022-07-15 04:20:53 | Sumner, Tennessee, US | |
3432165 | 3432165 | 2022-07-14 | US | Texas | Potter | 48375 | 37312 | 745 | 0 | 35.40133773 | -101.893964 | 2022-07-15 04:20:53 | Potter, Texas, US | |
3110051 | 3110051 | 2022-07-13 | US | California | Monterey | 6053 | 105519 | 745 | 0 | 36.21862405 | -121.2413397 | 2022-07-14 04:20:57 | Monterey, California, US | |
3112484 | 3112484 | 2022-07-13 | US | Tennessee | Sumner | 47165 | 56967 | 745 | 0 | 36.46824103 | -86.45917204 | 2022-07-14 04:20:57 | Sumner, Tennessee, US | |
3112685 | 3112685 | 2022-07-13 | US | Texas | Potter | 48375 | 37259 | 745 | 0 | 35.40133773 | -101.893964 | 2022-07-14 04:20:57 | Potter, Texas, US | |
630474 | 630474 | 2022-07-12 | US | California | Monterey | 6053 | 105431 | 745 | 0 | 36.21862405 | -121.2413397 | 2022-07-13 04:20:58 | Monterey, California, US | |
632907 | 632907 | 2022-07-12 | US | Tennessee | Sumner | 47165 | 56882 | 745 | 0 | 36.46824103 | -86.45917204 | 2022-07-13 04:20:58 | Sumner, Tennessee, US | |
1212118 | 1212118 | 2022-07-11 | US | California | Monterey | 6053 | 105362 | 745 | 0 | 36.21862405 | -121.2413397 | 2022-07-12 04:20:51 | Monterey, California, US | |
2789600 | 2789600 | 2022-07-10 | US | California | Monterey | 6053 | 104709 | 745 | 0 | 36.21862405 | -121.2413397 | 2022-07-11 04:20:46 | Monterey, California, US | |
142553 | 142553 | 2022-07-09 | US | California | Monterey | 6053 | 104659 | 745 | 0 | 36.21862405 | -121.2413397 | 2022-07-10 04:20:54 | Monterey, California, US | |
1417653 | 1417653 | 2022-07-08 | US | California | Monterey | 6053 | 104629 | 745 | 0 | 36.21862405 | -121.2413397 | 2022-07-09 04:20:59 | Monterey, California, US | |
3942543 | 3942543 | 2022-06-30 | US | Ohio | Lake | 39085 | 52065 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-07-01 04:21:10 | Lake, Ohio, US | |
2492501 | 2492501 | 2022-06-29 | US | Ohio | Lake | 39085 | 51806 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-30 04:21:01 | Lake, Ohio, US | |
2241883 | 2241883 | 2022-06-28 | US | Ohio | Lake | 39085 | 51806 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-29 04:20:59 | Lake, Ohio, US | |
2150125 | 2150125 | 2022-06-27 | US | Ohio | Lake | 39085 | 51806 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-28 04:20:58 | Lake, Ohio, US | |
477926 | 477926 | 2022-06-26 | US | Ohio | Lake | 39085 | 51806 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-27 04:21:00 | Lake, Ohio, US | |
941301 | 941301 | 2022-06-25 | US | Ohio | Lake | 39085 | 51806 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-26 04:21:02 | Lake, Ohio, US | |
3349121 | 3349121 | 2022-06-24 | US | Ohio | Lake | 39085 | 51806 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-25 04:20:57 | Lake, Ohio, US | |
1650862 | 1650862 | 2022-06-23 | US | Ohio | Lake | 39085 | 51806 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-24 04:20:58 | Lake, Ohio, US | |
2190097 | 2190097 | 2022-06-22 | US | Ohio | Lake | 39085 | 51559 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-23 04:20:55 | Lake, Ohio, US | |
168528 | 168528 | 2022-06-21 | US | Ohio | Lake | 39085 | 51559 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-22 04:20:54 | Lake, Ohio, US | |
1765811 | 1765811 | 2022-06-20 | US | Ohio | Lake | 39085 | 51559 | 745 | 0 | 41.69710807 | -81.23676539 | 2022-06-21 04:20:56 | Lake, Ohio, US | |
3585292 | 3585292 | 2022-05-17 | US | Pennsylvania | Beaver | 42007 | 40744 | 745 | 0 | 40.6825484 | -80.34921611 | 2022-05-18 04:20:50 | Beaver, Pennsylvania, US | |
1506249 | 1506249 | 2022-05-16 | US | Pennsylvania | Beaver | 42007 | 40744 | 745 | 0 | 40.6825484 | -80.34921611 | 2022-05-17 04:20:59 | Beaver, Pennsylvania, US | |
2086608 | 2086608 | 2022-05-15 | US | Pennsylvania | Beaver | 42007 | 40744 | 745 | 0 | 40.6825484 | -80.34921611 | 2022-05-16 04:20:47 | Beaver, Pennsylvania, US | |
3357318 | 3357318 | 2022-05-14 | US | Pennsylvania | Beaver | 42007 | 40744 | 745 | 0 | 40.6825484 | -80.34921611 | 2022-05-15 04:20:53 | Beaver, Pennsylvania, US | |
660963 | 660963 | 2022-05-13 | US | Pennsylvania | Beaver | 42007 | 40744 | 745 | 0 | 40.6825484 | -80.34921611 | 2022-05-14 04:20:48 | Beaver, Pennsylvania, US | |
2536046 | 2536046 | 2022-05-12 | US | Pennsylvania | Beaver | 42007 | 40744 | 745 | 0 | 40.6825484 | -80.34921611 | 2022-05-13 04:20:51 | Beaver, Pennsylvania, US | |
3447492 | 3447492 | 2022-05-11 | US | Pennsylvania | Beaver | 42007 | 40744 | 745 | 0 | 40.6825484 | -80.34921611 | 2022-05-12 04:20:54 | Beaver, Pennsylvania, US | |
3854027 | 3854027 | 2022-04-27 | US | New Mexico | San Juan | 35045 | 40786 | 745 | 0 | 36.50838318 | -108.320437 | 2022-04-28 04:20:47 | San Juan, New Mexico, US | |
3855214 | 3855214 | 2022-04-27 | US | Virginia | Prince William | 51153 | 96094 | 745 | 0 | 38.70916224 | -77.48713689 | 2022-04-28 04:20:47 | Prince William, Virginia, US | |
1328457 | 1328457 | 2022-04-26 | US | New Mexico | San Juan | 35045 | 40786 | 745 | 0 | 36.50838318 | -108.32043700000001 | 2022-04-27 04:20:52 | San Juan, New Mexico, US | |
3724411 | 3724411 | 2022-04-25 | US | New Mexico | San Juan | 35045 | 40786 | 745 | 0 | 36.50838318 | -108.32043700000001 | 2022-04-26 04:20:51 | San Juan, New Mexico, US | |
2030979 | 2030979 | 2022-04-24 | US | New Mexico | San Juan | 35045 | 40777 | 745 | 0 | 36.50838318 | -108.32043700000001 | 2022-04-25 04:20:56 | San Juan, New Mexico, US | |
748554 | 748554 | 2022-04-23 | US | New Mexico | San Juan | 35045 | 40777 | 745 | 0 | 36.50838318 | -108.32043700000001 | 2022-04-24 04:20:56 | San Juan, New Mexico, US | |
3439039 | 3439039 | 2022-04-22 | US | New Mexico | San Juan | 35045 | 40777 | 745 | 0 | 36.50838318 | -108.32043700000001 | 2022-04-23 04:20:50 | San Juan, New Mexico, US | |
2894624 | 2894624 | 2022-04-21 | US | New Mexico | San Juan | 35045 | 40771 | 745 | 0 | 36.50838318 | -108.32043700000001 | 2022-04-22 04:20:45 | San Juan, New Mexico, US | |
1847498 | 1847498 | 2022-04-18 | US | Louisiana | Ouachita | 22073 | 50582 | 745 | 0 | 32.47645559 | -92.15704172 | 2022-04-19 04:21:00 | Ouachita, Louisiana, US | |
3418442 | 3418442 | 2022-04-17 | US | Louisiana | Ouachita | 22073 | 50574 | 745 | 0 | 32.47645559 | -92.15704172 | 2022-04-18 04:21:12 | Ouachita, Louisiana, US | |
305391 | 305391 | 2022-04-16 | US | Louisiana | Ouachita | 22073 | 50574 | 745 | 0 | 32.47645559 | -92.15704172 | 2022-04-17 04:20:59 | Ouachita, Louisiana, US | |
2671336 | 2671336 | 2022-04-15 | US | Louisiana | Ouachita | 22073 | 50574 | 745 | 0 | 32.47645559 | -92.15704172 | 2022-04-16 04:20:48 | Ouachita, Louisiana, US | |
1225121 | 1225121 | 2022-04-14 | US | Louisiana | Ouachita | 22073 | 50574 | 745 | 0 | 32.47645559 | -92.15704172 | 2022-04-15 04:20:57 | Ouachita, Louisiana, US | |
3208460 | 3208460 | 2022-04-11 | US | New Mexico | Dona Ana | 35013 | 63010 | 745 | 0 | 32.35275771 | -106.83293870000001 | 2022-04-12 04:20:49 | Dona Ana, New Mexico, US | |
3320820 | 3320820 | 2022-04-07 | US | California | San Mateo | 6081 | 128514 | 745 | 0 | 37.422880799999994 | -122.32755459999998 | 2022-04-08 04:20:48 | San Mateo, California, US | |
2801356 | 2801356 | 2022-04-06 | US | California | San Mateo | 6081 | 128029 | 745 | 0 | 37.422880799999994 | -122.32755459999998 | 2022-04-07 04:20:53 | San Mateo, California, US | |
3868125 | 3868125 | 2022-04-05 | US | California | San Mateo | 6081 | 128018 | 745 | 0 | 37.422880799999994 | -122.32755459999998 | 2022-04-06 04:20:49 | San Mateo, California, US | |
2749467 | 2749467 | 2022-04-04 | US | California | San Mateo | 6081 | 128004 | 745 | 0 | 37.422880799999994 | -122.32755459999998 | 2022-04-05 04:20:48 | San Mateo, California, US | |
3730813 | 3730813 | 2022-04-03 | US | California | San Mateo | 6081 | 127673 | 745 | 0 | 37.422880799999994 | -122.32755459999998 | 2022-04-04 04:20:51 | San Mateo, California, US | |
500248 | 500248 | 2022-04-02 | US | California | San Mateo | 6081 | 127664 | 745 | 0 | 37.422880799999994 | -122.32755459999998 | 2022-04-03 04:20:48 | San Mateo, California, US | |
3351233 | 3351233 | 2022-04-01 | US | California | San Mateo | 6081 | 127658 | 745 | 0 | 37.422880799999994 | -122.32755459999998 | 2022-04-02 04:20:47 | San Mateo, California, US | |
3024944 | 3024944 | 2022-03-23 | US | Pennsylvania | Erie | 42049 | 56890 | 745 | 0 | 41.99253829 | -80.03301954 | 2022-03-24 04:20:43 | Erie, Pennsylvania, US | |
1907866 | 1907866 | 2022-03-22 | US | Pennsylvania | Erie | 42049 | 56875 | 745 | 0 | 41.99253829 | -80.03301954 | 2022-03-23 04:20:48 | Erie, Pennsylvania, US | |
3240997 | 3240997 | 2022-03-21 | US | Pennsylvania | Erie | 42049 | 56865 | 745 | 0 | 41.99253829 | -80.03301954 | 2022-03-22 04:20:54 | Erie, Pennsylvania, US | |
27070 | 27070 | 2022-03-20 | US | Pennsylvania | Erie | 42049 | 56856 | 745 | 0 | 41.99253829 | -80.03301954 | 2022-03-21 04:20:50 | Erie, Pennsylvania, US | |
1659080 | 1659080 | 2022-03-19 | US | Pennsylvania | Erie | 42049 | 56854 | 745 | 0 | 41.99253829 | -80.03301954 | 2022-03-20 04:20:45 | Erie, Pennsylvania, US | |
1659090 | 1659090 | 2022-03-19 | US | Pennsylvania | Lackawanna | 42069 | 43195 | 745 | 0 | 41.43564672 | -75.60379201 | 2022-03-20 04:20:45 | Lackawanna, Pennsylvania, US | |
338606 | 338606 | 2022-03-18 | US | Pennsylvania | Erie | 42049 | 56842 | 745 | 0 | 41.99253829 | -80.03301954 | 2022-03-19 04:20:47 | Erie, Pennsylvania, US | |
338616 | 338616 | 2022-03-18 | US | Pennsylvania | Lackawanna | 42069 | 43183 | 745 | 0 | 41.43564672 | -75.60379201 | 2022-03-19 04:20:47 | Lackawanna, Pennsylvania, US | |
697059 | 697059 | 2022-03-17 | US | Pennsylvania | Erie | 42049 | 56825 | 745 | 0 | 41.99253829 | -80.03301954 | 2022-03-18 04:20:55 | Erie, Pennsylvania, US | |
263175 | 263175 | 2022-03-15 | US | Michigan | Ingham | 26065 | 63429 | 745 | 0 | 42.59716886 | -84.37472069 | 2022-03-16 04:20:50 | Ingham, Michigan, US | |
2265534 | 2265534 | 2022-03-14 | US | Michigan | Ingham | 26065 | 63429 | 745 | 0 | 42.59716886 | -84.37472069 | 2022-03-15 04:20:47 | Ingham, Michigan, US | |
3629600 | 3629600 | 2022-03-13 | US | Michigan | Ingham | 26065 | 63384 | 745 | 0 | 42.59716886 | -84.37472069 | 2022-03-14 04:20:46 | Ingham, Michigan, US | |
952508 | 952508 | 2022-03-12 | US | Michigan | Ingham | 26065 | 63384 | 745 | 0 | 42.59716886 | -84.37472069 | 2022-03-13 04:20:49 | Ingham, Michigan, US | |
357969 | 357969 | 2022-03-11 | US | Michigan | Ingham | 26065 | 63384 | 745 | 0 | 42.59716886 | -84.37472069 | 2022-03-12 04:20:50 | Ingham, Michigan, US | |
1645120 | 1645120 | 2022-03-03 | US | Georgia | Bibb | 13021 | 36650 | 745 | 0 | 32.80904227 | -83.70489165 | 2022-03-04 04:21:09 | Bibb, Georgia, US | |
946111 | 946111 | 2022-02-28 | US | Utah | Utah | 49049 | 200655 | 745 | 0 | 40.116672200000004 | -111.66576620000001 | 2022-03-01 04:21:09 | Utah, Utah, US | |
2736494 | 2736494 | 2022-02-27 | US | Washington | Yakima | 53077 | 70246 | 745 | 0 | 46.45738486 | -120.73801259999999 | 2022-02-28 04:21:05 | 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]);