johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
345 rows where confirmed = 2497 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 12
- US 322
- United Kingdom 9
- Colombia 3
- China 2
- South Sudan 2
- Germany 1
- Japan 1
- Malawi 1
- Monaco 1
- New Zealand 1
- Sierra Leone 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755758 | 2755758 | 2022-12-29 | US | South Dakota | Bon Homme | 46009 | 2497 | 42 | 0 | 42.98914167 | -97.88592746 | 2022-12-30 04:21:04 | Bon Homme, South Dakota, US | |
2755114 | 2755114 | 2022-12-29 | US | New Mexico | Quay | 35037 | 2497 | 70 | 0 | 35.10403332 | -103.5481727 | 2022-12-30 04:21:04 | Quay, New Mexico, US | |
1076764 | 1076764 | 2022-12-28 | US | South Dakota | Bon Homme | 46009 | 2497 | 42 | 0 | 42.98914167 | -97.88592746 | 2022-12-29 04:21:01 | Bon Homme, South Dakota, US | |
1076120 | 1076120 | 2022-12-28 | US | New Mexico | Quay | 35037 | 2497 | 69 | 0 | 35.10403332 | -103.5481727 | 2022-12-29 04:21:01 | Quay, New Mexico, US | |
330761 | 330761 | 2022-12-27 | US | South Dakota | Bon Homme | 46009 | 2497 | 41 | 0 | 42.98914167 | -97.88592746 | 2022-12-28 04:21:04 | Bon Homme, South Dakota, US | |
220834 | 220834 | 2022-12-26 | US | South Dakota | Bon Homme | 46009 | 2497 | 41 | 0 | 42.98914167 | -97.88592746 | 2022-12-27 04:21:07 | Bon Homme, South Dakota, US | |
218509 | 218509 | 2022-12-26 | US | Arkansas | Searcy | 5129 | 2497 | 52 | 0 | 35.9109364 | -92.69936482 | 2022-12-27 04:21:07 | Searcy, Arkansas, US | |
3225291 | 3225291 | 2022-12-25 | US | South Dakota | Bon Homme | 46009 | 2497 | 41 | 0 | 42.98914167 | -97.88592746 | 2022-12-26 04:21:06 | Bon Homme, South Dakota, US | |
1021205 | 1021205 | 2022-12-24 | US | South Dakota | Bon Homme | 46009 | 2497 | 41 | 0 | 42.98914167 | -97.88592746 | 2022-12-25 04:21:04 | Bon Homme, South Dakota, US | |
693228 | 693228 | 2022-12-23 | US | South Dakota | Bon Homme | 46009 | 2497 | 41 | 0 | 42.98914167 | -97.88592746 | 2022-12-24 04:21:02 | Bon Homme, South Dakota, US | |
2182438 | 2182438 | 2022-12-22 | US | South Dakota | Bon Homme | 46009 | 2497 | 41 | 0 | 42.98914167 | -97.88592746 | 2022-12-23 04:21:04 | Bon Homme, South Dakota, US | |
454242 | 454242 | 2022-12-21 | US | South Dakota | Bon Homme | 46009 | 2497 | 41 | 0 | 42.98914167 | -97.88592746 | 2022-12-22 04:20:56 | Bon Homme, South Dakota, US | |
1631644 | 1631644 | 2022-12-18 | US | Virginia | Fairfax City | 51600 | 2497 | 49 | 0 | 38.85157547 | -77.2977964 | 2022-12-19 04:21:03 | Fairfax City, Virginia, US | |
507023 | 507023 | 2022-12-17 | US | Virginia | Fairfax City | 51600 | 2497 | 49 | 0 | 38.85157547 | -77.2977964 | 2022-12-18 04:21:03 | Fairfax City, Virginia, US | |
3327595 | 3327595 | 2022-12-16 | US | Virginia | Fairfax City | 51600 | 2497 | 49 | 0 | 38.85157547 | -77.2977964 | 2022-12-17 04:21:04 | Fairfax City, Virginia, US | |
1150848 | 1150848 | 2022-12-12 | US | Missouri | DeKalb | 29063 | 2497 | 48 | 0 | 39.89201062 | -94.40476508 | 2022-12-13 04:21:01 | DeKalb, Missouri, US | |
870702 | 870702 | 2022-12-11 | US | Missouri | DeKalb | 29063 | 2497 | 48 | 0 | 39.89201062 | -94.40476508 | 2022-12-12 04:21:01 | DeKalb, Missouri, US | |
259232 | 259232 | 2022-12-10 | US | Missouri | DeKalb | 29063 | 2497 | 48 | 0 | 39.89201062 | -94.40476508 | 2022-12-11 04:20:50 | DeKalb, Missouri, US | |
3937946 | 3937946 | 2022-12-09 | US | Missouri | DeKalb | 29063 | 2497 | 48 | 0 | 39.89201062 | -94.40476508 | 2022-12-10 04:21:02 | DeKalb, Missouri, US | |
3379278 | 3379278 | 2022-12-08 | US | Missouri | DeKalb | 29063 | 2497 | 48 | 0 | 39.89201062 | -94.40476508 | 2022-12-09 04:21:05 | DeKalb, Missouri, US | |
1986549 | 1986549 | 2022-12-07 | US | Missouri | DeKalb | 29063 | 2497 | 48 | 0 | 39.89201062 | -94.40476508 | 2022-12-08 04:21:07 | DeKalb, Missouri, US | |
3716072 | 3716072 | 2022-12-06 | US | Missouri | DeKalb | 29063 | 2497 | 48 | 0 | 39.89201062 | -94.40476508 | 2022-12-07 04:20:58 | DeKalb, Missouri, US | |
2103081 | 2103081 | 2022-11-26 | US | Tennessee | Hancock | 47067 | 2497 | 42 | 0 | 36.52692871 | -83.22375847 | 2022-11-27 04:21:05 | Hancock, Tennessee, US | |
490572 | 490572 | 2022-11-25 | US | Tennessee | Hancock | 47067 | 2497 | 42 | 0 | 36.52692871 | -83.22375847 | 2022-11-26 04:21:11 | Hancock, Tennessee, US | |
3526401 | 3526401 | 2022-11-24 | US | Tennessee | Hancock | 47067 | 2497 | 42 | 0 | 36.52692871 | -83.22375847 | 2022-11-25 04:21:06 | Hancock, Tennessee, US | |
3315184 | 3315184 | 2022-11-23 | US | Tennessee | Hancock | 47067 | 2497 | 42 | 0 | 36.52692871 | -83.22375847 | 2022-11-24 04:21:09 | Hancock, Tennessee, US | |
1623225 | 1623225 | 2022-11-22 | US | Tennessee | Hancock | 47067 | 2497 | 42 | 0 | 36.52692871 | -83.22375847 | 2022-11-23 04:21:06 | Hancock, Tennessee, US | |
3286787 | 3286787 | 2022-10-31 | US | Missouri | Carroll | 29033 | 2497 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-11-01 04:22:36 | Carroll, Missouri, US | |
321820 | 321820 | 2022-10-30 | US | Missouri | Carroll | 29033 | 2497 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-10-31 04:21:36 | Carroll, Missouri, US | |
914096 | 914096 | 2022-10-29 | US | Missouri | Carroll | 29033 | 2497 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-10-30 04:22:14 | Carroll, Missouri, US | |
1368365 | 1368365 | 2022-10-28 | US | Missouri | Carroll | 29033 | 2497 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-10-29 04:21:13 | Carroll, Missouri, US | |
3040220 | 3040220 | 2022-10-27 | US | Missouri | Carroll | 29033 | 2497 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-10-28 04:22:31 | Carroll, Missouri, US | |
540640 | 540640 | 2022-10-26 | US | Missouri | Carroll | 29033 | 2497 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-10-27 04:22:01 | Carroll, Missouri, US | |
1832041 | 1832041 | 2022-10-25 | US | Missouri | Carroll | 29033 | 2497 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-10-26 04:22:19 | Carroll, Missouri, US | |
1831151 | 1831151 | 2022-10-25 | US | Illinois | Hamilton | 17065 | 2497 | 32 | 0 | 38.08163641 | -88.53883373 | 2022-10-26 04:22:19 | Hamilton, Illinois, US | |
796302 | 796302 | 2022-10-24 | US | Missouri | Carroll | 29033 | 2497 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-10-25 04:21:53 | Carroll, Missouri, US | |
3278757 | 3278757 | 2022-10-23 | US | Missouri | Carroll | 29033 | 2497 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-10-24 04:22:29 | Carroll, Missouri, US | |
2269795 | 2269795 | 2022-10-22 | US | Missouri | Carroll | 29033 | 2497 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-10-23 04:22:46 | Carroll, Missouri, US | |
1594095 | 1594095 | 2022-10-21 | US | Missouri | Carroll | 29033 | 2497 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-10-22 04:22:53 | Carroll, Missouri, US | |
1980004 | 1980004 | 2022-09-25 | US | Virginia | Northumberland | 51133 | 2497 | 44 | 0 | 37.89202088 | -76.41949732 | 2022-09-26 04:20:52 | Northumberland, Virginia, US | |
2653171 | 2653171 | 2022-09-24 | US | Virginia | Northumberland | 51133 | 2497 | 44 | 0 | 37.89202088 | -76.41949732 | 2022-09-25 04:23:31 | Northumberland, Virginia, US | |
387611 | 387611 | 2022-09-23 | US | Virginia | Northumberland | 51133 | 2497 | 44 | 0 | 37.89202088 | -76.41949732 | 2022-09-24 04:21:40 | Northumberland, Virginia, US | |
1627677 | 1627677 | 2022-09-22 | US | Virginia | Northumberland | 51133 | 2497 | 43 | 0 | 37.89202088 | -76.41949732 | 2022-09-23 04:23:13 | Northumberland, Virginia, US | |
420743 | 420743 | 2022-09-18 | US | Kentucky | Gallatin | 21077 | 2497 | 54 | 0 | 38.75398691 | -84.8558382 | 2022-09-19 04:21:49 | Gallatin, Kentucky, US | |
3374767 | 3374767 | 2022-09-17 | US | Kentucky | Gallatin | 21077 | 2497 | 54 | 0 | 38.75398691 | -84.8558382 | 2022-09-18 04:22:50 | Gallatin, Kentucky, US | |
2356875 | 2356875 | 2022-09-16 | US | Kentucky | Gallatin | 21077 | 2497 | 54 | 0 | 38.75398691 | -84.8558382 | 2022-09-17 04:20:19 | Gallatin, Kentucky, US | |
3988032 | 3988032 | 2022-09-15 | US | Kentucky | Gallatin | 21077 | 2497 | 54 | 0 | 38.75398691 | -84.8558382 | 2022-09-16 04:21:19 | Gallatin, Kentucky, US | |
3987565 | 3987565 | 2022-09-15 | US | Idaho | Franklin | 16041 | 2497 | 30 | 0 | 42.18332217 | -111.8149666 | 2022-09-16 04:21:19 | Franklin, Idaho, US | |
1890549 | 1890549 | 2022-09-14 | US | Kentucky | Gallatin | 21077 | 2497 | 54 | 0 | 38.75398691 | -84.8558382 | 2022-09-15 04:21:02 | Gallatin, Kentucky, US | |
1890082 | 1890082 | 2022-09-14 | US | Idaho | Franklin | 16041 | 2497 | 30 | 0 | 42.18332217 | -111.8149666 | 2022-09-15 04:21:02 | Franklin, Idaho, US | |
373604 | 373604 | 2022-09-13 | US | Kentucky | Gallatin | 21077 | 2497 | 54 | 0 | 38.75398691 | -84.8558382 | 2022-09-14 04:20:44 | Gallatin, Kentucky, US | |
2396206 | 2396206 | 2022-09-12 | US | Kentucky | Gallatin | 21077 | 2497 | 54 | 0 | 38.75398691 | -84.8558382 | 2022-09-13 04:20:57 | Gallatin, Kentucky, US | |
256766 | 256766 | 2022-09-08 | US | Washington | Lincoln | 53043 | 2497 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-09-09 04:21:11 | Lincoln, Washington, US | |
3748564 | 3748564 | 2022-09-07 | US | Washington | Lincoln | 53043 | 2497 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-09-08 04:21:02 | Lincoln, Washington, US | |
3747680 | 3747680 | 2022-09-07 | US | Oklahoma | Latimer | 40077 | 2497 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-08 04:21:02 | Latimer, Oklahoma, US | |
117320 | 117320 | 2022-09-06 | US | Oklahoma | Latimer | 40077 | 2497 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-07 04:20:59 | Latimer, Oklahoma, US | |
2636292 | 2636292 | 2022-09-05 | US | Oklahoma | Latimer | 40077 | 2497 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-06 04:21:02 | Latimer, Oklahoma, US | |
2989856 | 2989856 | 2022-09-04 | US | Oklahoma | Latimer | 40077 | 2497 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-05 04:21:01 | Latimer, Oklahoma, US | |
2715541 | 2715541 | 2022-09-03 | US | Oklahoma | Latimer | 40077 | 2497 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-04 04:21:22 | Latimer, Oklahoma, US | |
1396246 | 1396246 | 2022-09-02 | US | Oklahoma | Latimer | 40077 | 2497 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-03 04:21:04 | Latimer, Oklahoma, US | |
3550075 | 3550075 | 2022-09-01 | US | Oklahoma | Latimer | 40077 | 2497 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-02 04:21:07 | Latimer, Oklahoma, US | |
3547982 | 3547982 | 2022-09-01 | US | Arkansas | Cleveland | 5025 | 2497 | 39 | 0 | 33.89723187 | -92.18537045 | 2022-09-02 04:21:07 | Cleveland, Arkansas, US | |
2099042 | 2099042 | 2022-08-27 | US | Tennessee | Clay | 47027 | 2497 | 52 | 0 | 36.55151008 | -85.53930419 | 2022-08-28 04:21:02 | Clay, Tennessee, US | |
1251665 | 1251665 | 2022-08-23 | US | Georgia | Wilkinson | 13319 | 2497 | 61 | 0 | 32.80291082 | -83.17140684 | 2022-08-24 04:20:46 | Wilkinson, Georgia, US | |
2853769 | 2853769 | 2022-08-22 | US | Georgia | Wilkinson | 13319 | 2497 | 61 | 0 | 32.80291082 | -83.17140684 | 2022-08-23 04:20:56 | Wilkinson, Georgia, US | |
2403741 | 2403741 | 2022-08-21 | US | Georgia | Wilkinson | 13319 | 2497 | 61 | 0 | 32.80291082 | -83.17140684 | 2022-08-22 04:20:38 | Wilkinson, Georgia, US | |
3798819 | 3798819 | 2022-08-20 | US | Georgia | Wilkinson | 13319 | 2497 | 61 | 0 | 32.80291082 | -83.17140684 | 2022-08-21 04:20:44 | Wilkinson, Georgia, US | |
2364405 | 2364405 | 2022-08-19 | US | Georgia | Wilkinson | 13319 | 2497 | 61 | 0 | 32.80291082 | -83.17140684 | 2022-08-20 04:21:01 | Wilkinson, Georgia, US | |
1162076 | 1162076 | 2022-08-18 | US | Georgia | Wilkinson | 13319 | 2497 | 61 | 0 | 32.80291082 | -83.17140684 | 2022-08-19 04:20:54 | Wilkinson, Georgia, US | |
3951400 | 3951400 | 2022-08-17 | US | Georgia | Wilkinson | 13319 | 2497 | 61 | 0 | 32.80291082 | -83.17140684 | 2022-08-18 04:21:11 | Wilkinson, Georgia, US | |
994200 | 994200 | 2022-08-16 | US | Texas | Red River | 48387 | 2497 | 68 | 0 | 33.61886692 | -95.04841765 | 2022-08-17 04:20:59 | Red River, Texas, US | |
2497239 | 2497239 | 2022-08-15 | US | Texas | Red River | 48387 | 2497 | 68 | 0 | 33.61886692 | -95.04841765 | 2022-08-16 04:20:58 | Red River, Texas, US | |
1349471 | 1349471 | 2022-08-10 | US | Texas | La Salle | 48283 | 2497 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-08-11 04:20:49 | La Salle, Texas, US | |
1408522 | 1408522 | 2022-08-02 | US | West Virginia | Clay | 54015 | 2497 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-08-03 04:20:59 | Clay, West Virginia, US | |
3874545 | 3874545 | 2022-07-31 | US | Tennessee | Perry | 47135 | 2497 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-08-01 04:21:03 | Perry, Tennessee, US | |
2490675 | 2490675 | 2022-06-29 | US | Colorado | San Miguel | 8113 | 2497 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-06-30 04:21:01 | San Miguel, Colorado, US | |
2240057 | 2240057 | 2022-06-28 | US | Colorado | San Miguel | 8113 | 2497 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-06-29 04:20:59 | San Miguel, Colorado, US | |
167011 | 167011 | 2022-06-21 | US | Illinois | Brown | 17009 | 2497 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-06-22 04:20:54 | Brown, Illinois, US | |
3583859 | 3583859 | 2022-05-17 | US | Iowa | Louisa | 19115 | 2497 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-05-18 04:20:50 | Louisa, Iowa, US | |
1504816 | 1504816 | 2022-05-16 | US | Iowa | Louisa | 19115 | 2497 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-05-17 04:20:59 | Louisa, Iowa, US | |
2085175 | 2085175 | 2022-05-15 | US | Iowa | Louisa | 19115 | 2497 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-05-16 04:20:47 | Louisa, Iowa, US | |
3355885 | 3355885 | 2022-05-14 | US | Iowa | Louisa | 19115 | 2497 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-05-15 04:20:53 | Louisa, Iowa, US | |
659530 | 659530 | 2022-05-13 | US | Iowa | Louisa | 19115 | 2497 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-05-14 04:20:48 | Louisa, Iowa, US | |
2534613 | 2534613 | 2022-05-12 | US | Iowa | Louisa | 19115 | 2497 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-05-13 04:20:51 | Louisa, Iowa, US | |
3447564 | 3447564 | 2022-05-11 | US | Puerto Rico | Arroyo | 72015 | 2497 | 0 | 0 | 17.998457 | -66.056546 | 2022-05-12 04:20:54 | Arroyo, Puerto Rico, US | |
3446059 | 3446059 | 2022-05-11 | US | Iowa | Louisa | 19115 | 2497 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-05-12 04:20:54 | Louisa, Iowa, US | |
1573360 | 1573360 | 2022-05-03 | US | Iowa | Mitchell | 19131 | 2497 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-05-04 04:20:59 | Mitchell, Iowa, US | |
464620 | 464620 | 2022-05-02 | US | Iowa | Mitchell | 19131 | 2497 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-05-03 04:21:00 | Mitchell, Iowa, US | |
3917259 | 3917259 | 2022-05-01 | US | Iowa | Mitchell | 19131 | 2497 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-05-02 04:21:10 | Mitchell, Iowa, US | |
2842063 | 2842063 | 2022-04-30 | US | Iowa | Mitchell | 19131 | 2497 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-05-01 04:20:57 | Mitchell, Iowa, US | |
1158376 | 1158376 | 2022-04-29 | US | Iowa | Mitchell | 19131 | 2497 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-04-30 04:21:05 | Mitchell, Iowa, US | |
1697558 | 1697558 | 2022-04-28 | US | Iowa | Mitchell | 19131 | 2497 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-04-29 04:20:59 | Mitchell, Iowa, US | |
3853041 | 3853041 | 2022-04-27 | US | Iowa | Mitchell | 19131 | 2497 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-04-28 04:20:47 | Mitchell, Iowa, US | |
3420375 | 3420375 | 2022-04-17 | US | Washington | Pend Oreille | 53051 | 2497 | 36 | 0 | 48.53234021 | -117.2741804 | 2022-04-18 04:21:12 | Pend Oreille, Washington, US | |
307324 | 307324 | 2022-04-16 | US | Washington | Pend Oreille | 53051 | 2497 | 36 | 0 | 48.53234021 | -117.2741804 | 2022-04-17 04:20:59 | Pend Oreille, Washington, US | |
2673269 | 2673269 | 2022-04-15 | US | Washington | Pend Oreille | 53051 | 2497 | 36 | 0 | 48.53234021 | -117.2741804 | 2022-04-16 04:20:48 | Pend Oreille, Washington, US | |
3320957 | 3320957 | 2022-04-07 | US | Florida | Liberty | 12077 | 2497 | 30 | 0 | 30.23766008 | -84.8829258 | 2022-04-08 04:20:48 | Liberty, Florida, US | |
2801493 | 2801493 | 2022-04-06 | US | Florida | Liberty | 12077 | 2497 | 30 | 0 | 30.23766008 | -84.8829258 | 2022-04-07 04:20:53 | Liberty, Florida, US | |
2800569 | 2800569 | 2022-04-06 | China | Heilongjiang | 2497 | 13 | 0 | 47.861999999999995 | 127.7615 | 2022-04-07 04:20:53 | Heilongjiang, China | |||
3868262 | 3868262 | 2022-04-05 | US | Florida | Liberty | 12077 | 2497 | 30 | 0 | 30.23766008 | -84.8829258 | 2022-04-06 04:20:49 | Liberty, Florida, 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]);