1 | City | Full City Name | Population | Year-round Weather (ºC) | City Livability | Cost of Living | Housing | Safety | Schools | Closest Major Cities | Nearby Major Cities | Urban Area Name | Living Wages (2a+0k) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Irvine, CA | Irvine, CA, US | 256,927 | 5.0 | 15.0 | 18.2 | 22.8 | 36.7 | 79 | F | D+ | A | A+ | Los Angeles, California, United States (58km), San Diego, California, United States (123km), Tijuana, Baja California, Mexico (150km) | 4 | Los Angeles | $75,204 |
3 | New York, NY | New York City, NY, US | 8,804,190 | -7.2 | 10.6 | 14.6 | 19.4 | 35.0 | 67 | F | D+ | F | C+ | Philadelphia, Pennsylvania, United States (130km), Baltimore, Maryland, United States (273km), Boston, Massachusetts, United States (306km) | 1 | New York | $64,755 |
4 | Mountain View, CA | Mountain View, CA, US | 80,435 | -1.0 | 10.0 | 15.0 | 20.0 | 39.0 | 83 | F | B+ | C+ | A- | San Jose, California, United States (18km), San Francisco, California, United States (52km), Sacramento, California, United States (142km) | 4 | San Francisco Bay Area | $86,538 |
5 | Raleigh, NC | Raleigh, NC, US | 451,066 | -6.6 | 10.6 | 17.8 | 24.4 | 37.8 | 74 | C- | B- | C- | C- | Charlotte, North Carolina, United States (209km), Washington, D.C., Washington, D.C., United States (375km), Baltimore, Maryland, United States (430km) | 1 | Raleigh | $56,428 |
6 | |||||||||||||
7 | |||||||||||||
8 | |||||||||||||
9 | |||||||||||||
10 | You just need to populate the other highlighted cells. Column A is manually populated with cities of interest; cell B1 uses the formula below: | ||||||||||||
11 | =IMPORTXML("https://city-data-search.cbdm.app/api/multi/get-headers&" & JOIN("&", ARRAYFORMULA(LOWER(SUBSTITUTE(SUBSTITUTE(FILTER(A2:A, LEN(A2:A)), ", ", ","), " ", "+")))), "/multi/data") | ||||||||||||