Using the
Wikipedia for missions in the U.S. as the source:
- Washington, D.C.: 177 (all embassies)
- New York City: 116 (9 embassies)
- Los Angeles: 66
- Chicago: 55
- Miami: 44
- Houston: 44
- San Francisco: 42
- Atlanta: 27
- Boston: 25
- Seattle: 9
- Honolulu: 8
- Dallas: 7
- Denver: 7
- Detroit: 7
- San Juan: 7
- New Orleans: 6
- Minneapolis-St. Paul: 5
- Philadelphia: 5
- Phoenix: 4
- Orlando: 3
- Portland: 3
- San Diego: 3
- Tucson: 3
- Anchorage: 2
- Austin: 2
- Charlotte: 2
- El Paso: 2
- Hartford: 2
- Las Vegas: 2
- Providence: 2
- Raleigh: 2
- San Bernadino: 2
- San Jose: 2 (includes Danish consulate in Palo Alto)
- Tampa: 2
- Cleveland: 1
- Columbus: 1
- Des Moines: 1
- Fresno: 1
- Indianapolis: 1
- Kansas City: 1
- Milwaukee: 1
- Nashville: 1
- Oklahoma City: 1
- Sacramento: 1
- Salt Lake City: 1
- San Antonio: 1
- Sacramento: 1
Average: 15
Median: 2
This is only counting major cities having their own MSA/metro area with population of +1 million. Major cities without consulates: Baltimore, Birmingham, Buffalo, Cincinnati, Grand Rapids, Jacksonville, Louisville, Memphis, Pittsburgh, Richmond, Rochester, St. Louis, Tulsa, and Virginia Beach.
I only looked up the U.S. because of time, but feel free to add other countries.