anywhere to get all US states + counties data

  • Thread starter Thread starter Bobby Edward
  • Start date Start date
B

Bobby Edward

I have 2 tables... States and Counties (for US).

I would HATE to fill them 1 by 1.

Anywhere to go to in order to download all states/counties in a data format?

Thanks
 
Hello Bobby,

Use Wikipedia and scrap in from there :)

---
WBR,
Michael Nemtsev [Microsoft MVP] :: blog: http://spaces.live.com/laflour
:: http://twitter.com/laflour

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo


BE> I have 2 tables... States and Counties (for US).
BE>
BE> I would HATE to fill them 1 by 1.
BE>
BE> Anywhere to go to in order to download all states/counties in a data
BE> format?
BE>
BE> Thanks
BE>
 
Did not have time earlier. For FIPS, here is a county list:
http://www.census.gov/datamap/fipslist/AllSt.txt

You will have to massage the data. Another source, which is often easier to
divide out, is postal code products. If you are interested in postal codes,
a subscription may be the best method. If not, a month should run less than
$50. You can also get cities this way.


--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://feeds.feedburner.com/GregoryBeamer#

or just read it:
http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think outside the box! |
********************************************
 
Back
Top