1 | City | Full City Name | Population | Year-round Weather (ºC) | City Livability | Cost of Living | Housing | Safety | Schools | Closest Major Cities | Nearby Major Cities | Living Wages (2a+0k) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Irvine, CA | Irvine, CA, US | 256,927 | 5.0 | 15.0 | 17.7 | 21.7 | 32.2 | 76 | F | C | A+ | A+ | Los Angeles, California, United States (58km), San Diego, California, United States (123km), Tijuana, Baja California, Mexico (150km) | 4 | $81,066 |
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 | $64,755 |
4 | Raleigh, NC | Raleigh, NC, US | 451,066 | -4.9 | 12.2 | 18.4 | 23.9 | 38.9 | 84 | B | A+ | D- | B | Charlotte, North Carolina, United States (209km), Washington, D.C., Washington, D.C., United States (375km), Baltimore, Maryland, United States (430km) | 1 | $68,042 |
5 | 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 | $86,538 |
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") | |||||||||||