List of Major Cities in each State?

Status
Not open for further replies.
P

projectv3

New member
Mar 6, 2007
506
2
0
Was just curious, short of going to wikipedia and copying 1000's of cities per state, I was curious if anyone has a list of major (or fairly major) cities listed per state?

I have a general list of US cities but want to narrow them down by state which would take just as long as going to wikipedia if I had to manually look them up.

If anyone could hook a list of that would be awesome, if not off to wikipedia i go :(
 


I copied this list from craigslist, these are the cities listed on the front page so my guess is they have to be the top cities?

atlanta
austin
boston
chicago
dallas
denver
houston
las vegas
los angeles
miami
minneapolis
new york
orange co
philadelphia
phoenix
portland
raleigh
sacramento
san diego
seattle
sf bayarea
wash dc
 
OK, I like what chatmasta posted on that other thread but you are looking for the largest cities in america. I didn't download his db and look around because I already have my own. From some of the posts over tehre, it sounds like there is a row for each zip code. Mine is that way so if that's the case just look for the city names that have the biggest number of rows (read: the largest number of zip codes). To do that run this sql query.

SELECT city, COUNT(city) as count FROM cityDB GROUP BY city ORDER BY count DESC

just add a LIMIT 0,500 to get a certain amount of cities.

If you don't hack, this post might not make sense ... if so, sorry for the confusion
 
hmm

projectv3 said:
awesome thanks!

i think i downloaded those in the past but didnt realize they were sorted :D

:bowdown:
Click to expand...


dude for your capitals and larger cities create on targeted adgroup with your keywords in the title and description...

and there is no need to use 1000's of cities along with your keywords it would be a waste use phrase match and your cities will automatically come into place for they keyword...

You'll find out a lot of super affiliates only use a few hundred keywords with very targeted adgroups and there making millions doing it..
 
Status
Not open for further replies.
Top Bottom