U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > U.S. Forums > General U.S.
 [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
Reply Start New Thread
 
Old 05-09-2007, 07:14 PM
 
61 posts, read 529,114 times
Reputation: 55

Advertisements

I recently decided to go about loading Census 2000 Summary File 3 (http://www2.census.gov/census_2000/d...ummary_File_3/) into a MySQL database and was able to output a CSV file containing the median household incomes of hierarchial places (constrained by state -> MSA -> county boundaries) in the United States. As a result I can anything about the median household incomes of places, counties, metro areas, states and so forth. I really wish I could display these tables in a better format...crank up your resolutions!

All geographies with a population of over 20,000: top 30

(template=place_name; county_name; metro_area; state_name; geography_type; population; median_hh_income)

Saratoga city; Santa Clara County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 29,843; $139,895
Lake Forest city; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 20,059; $136,462
Southlake city; Tarrant County; Dallas—Fort Worth, TX CMSA; Texas; Place; 21,085; $131,614
Potomac CDP; Montgomery County; Washington—Baltimore, DC—MD—VA—WV CMSA; Maryland; Place; 44,822; $128,936
Los Altos city; Santa Clara County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 27,693; $126,740
McLean CDP; Fairfax County; Washington—Baltimore, DC—MD—VA—WV CMSA; Virginia; Place; 38,929; $121,138
Westport CDP; Fairfield County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; Connecticut; Place; 25,749; $119,872

Moderator cut: Bulk of material - Post brief excerpts (links are sufficient for material of this volume)


Let me know if you would like to pull out the places, counties, metro areas, etc. within a given geography (i.e. top 30 places in New Jersey, counties in Connecticut, places in Orange County, California, places in Santa Clara County, California with a population of 10,000 and above).

For 2005 data (not all geographies are included in that survey), have a look at Irvine is the richest city in America.

Last edited by smu7070; 05-09-2007 at 08:42 PM..
Reply With Quote Quick reply to this message

 
Old 05-09-2007, 07:20 PM
 
Location: Polish Hill, Pittsburgh, PA
30,184 posts, read 67,327,076 times
Reputation: 15830
As a census junkie, you nearly gave me an orgasm here! I live, eat, and breathe demographics, and I can't wait to dive into what you just posted. Looks like I better put on the pot of coffee though! LOL!
Reply With Quote Quick reply to this message
 
Old 05-09-2007, 07:35 PM
 
70 posts, read 296,450 times
Reputation: 72
Looks like the New York, Washington, and San Francisco metros are where the serious money is at.
Reply With Quote Quick reply to this message
 
Old 05-09-2007, 07:37 PM
 
134 posts, read 401,469 times
Reputation: 79
Quote:
Originally Posted by ScrantonWilkesBarre View Post
As a census junkie, you nearly gave me an orgasm here! I live, eat, and breathe demographics, and I can't wait to dive into what you just posted. Looks like I better put on the pot of coffee though! LOL!
ME too! I can spend hours on the census website. I've also spent hours looking at the stats on this website....clicking on the counties, zipcodes, all kinds of stuff!
Reply With Quote Quick reply to this message
 
Old 05-09-2007, 07:49 PM
 
Location: Polish Hill, Pittsburgh, PA
30,184 posts, read 67,327,076 times
Reputation: 15830
Quote:
Originally Posted by markdalton View Post
ME too! I can spend hours on the census website. I've also spent hours looking at the stats on this website....clicking on the counties, zipcodes, all kinds of stuff!
Awesome! I'm not alone! Now people won't think I'm such a freak anymore! LOL!
Reply With Quote Quick reply to this message
 
Old 05-09-2007, 07:50 PM
 
Location: Hollywood/Brookfield, IL
677 posts, read 3,876,716 times
Reputation: 359
That is really interesting, thank you for sharing! I never would have guessed that New Jersey has the highest median income.

Quote:
Originally Posted by smu7070 View Post
Let me know if you would like to pull out the places, counties, metro areas, etc. within a given geography (i.e. top 30 places in New Jersey, counties in Connecticut, places in Orange County, California).
Could you do the top 30 of the Illinois portion of Chicago-Gary-Kenosha? I want to know if my town is up there
Reply With Quote Quick reply to this message
 
Old 05-09-2007, 07:51 PM
 
Location: Polish Hill, Pittsburgh, PA
30,184 posts, read 67,327,076 times
Reputation: 15830
Here's some basic population research I did for my area:

http://www.city-data.com/forum/penns...data-nepa.html

Man do I ever need to get a life! LOL!
Reply With Quote Quick reply to this message
 
Old 05-09-2007, 07:55 PM
 
61 posts, read 529,114 times
Reputation: 55
Quote:
Originally Posted by ScrantonWilkesBarre View Post
Awesome! I'm not alone! Now people won't think I'm such a freak anymore! LOL!
I also used to do that, but downloading Summary Files 1 and 3 have made that obsolete, mostly.

I'll go ahead and build the median home values CSV and will post the data on here in a bit.
Reply With Quote Quick reply to this message
 
Old 05-09-2007, 08:02 PM
 
Location: Polish Hill, Pittsburgh, PA
30,184 posts, read 67,327,076 times
Reputation: 15830
Quote:
Originally Posted by kirstenleigh View Post
That is really interesting, thank you for sharing! I never would have guessed that New Jersey has the highest median income.
I wouldn't have either. All the people on the NJ forum seem to do is whine about how little money they make.
Reply With Quote Quick reply to this message
 
Old 05-09-2007, 08:05 PM
 
61 posts, read 529,114 times
Reputation: 55
Quote:
Originally Posted by kirstenleigh View Post
That is really interesting, thank you for sharing! I never would have guessed that New Jersey has the highest median income.



Could you do the top 30 of the Illinois portion of Chicago-Gary-Kenosha? I want to know if my town is up there
(template=place_name; county_name; metro_area; state_name; geography_type; population; median_hh_income)

Barrington Hills village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 503; $200,001
Kenilworth village; Cook County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 2,494; $200,001
South Barrington village; Cook County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 3,760; $170,755
Winnetka village; Cook County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 12,419; $167,458
Glencoe village; Cook County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 8,762; $164,432
Fox River Valley Gardens village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 177; $162,500
Wayne village; Kane County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 834; $159,046
Riverwoods village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 3,843; $158,990
Deer Park village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 3,093; $150,634
Bannockburn village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 1,429; $150,415
Long Grove village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 6,735; $148,150
Barrington Hills village; McHenry County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 1,336; $147,377
Oak Brook village; DuPage County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 8,702; $146,537
North Barrington village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 2,918; $146,251
Burr Ridge village; DuPage County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 6,785; $143,362
Inverness village; Cook County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 6,749; $141,672
Barrington Hills village; Cook County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 1,979; $139,778
Kildeer village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 3,460; $137,498
Lake Forest city; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 20,059; $136,462
Lincolnshire village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 6,108; $134,259
Hawthorn Woods village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 6,002; $132,720
Golf village; Cook County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 451; $131,742
Tower Lakes village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 1,310; $130,388
Green Oaks village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 3,572; $127,905
Mettawa village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 367; $127,388
Hinsdale village; Cook County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 2,140; $116,075
Lake Bluff village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 6,056; $114,521
Lakewood village; McHenry County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 2,337; $111,172
Naperville city; Will County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 37,374; $110,832
Burr Ridge village; Cook County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 3,623; $109,030
Deerfield village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 18,109; $108,405
Fox River Grove village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 173; $107,775
Lake Barrington village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 4,757; $106,951
Wilmette village; Cook County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 27,651; $106,773
Wayne village; DuPage County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 1,303; $102,886
Hinsdale village; DuPage County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 15,209; $102,742
Highland Park city; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 31,365; $100,967
Trout Valley village; McHenry County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 599; $99,297
Western Springs village; Cook County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 12,493; $98,876
Third Lake village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 1,355; $96,719
Northbrook village; Cook County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 33,435; $95,665
St. Charles city; DuPage County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 169; $95,340
Olympia Fields village; Cook County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 4,732; $94,827
Flossmoor village; Cook County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 9,301; $94,222
Prairie Grove village; McHenry County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 960; $93,361
Barrington village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 4,461; $93,286
Bull Valley village; McHenry County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 726; $92,693
Buffalo Grove village; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 28,491; $92,442

$200,001=$200,000+
Reply With Quote Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.


Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:

Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > U.S. Forums > General U.S.
Follow City-Data.com founder on our Forum or

All times are GMT -6.

© 2005-2019, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35 - Top