Google Answers Logo
View Question
 
Q: Demographic Data - United States ( Answered 5 out of 5 stars,   1 Comment )
Question  
Subject: Demographic Data - United States
Category: Reference, Education and News > General Reference
Asked by: environ-ga
List Price: $150.00
Posted: 19 Nov 2006 06:27 PST
Expires: 19 Dec 2006 06:27 PST
Question ID: 783983
I need a report, by major metropolitan area ,by each state, that
contains the following in simple format. If this can be in an excel
sheet - that is preferable.

For each state, total population size, the list of all metropolitan
areas by state as a sub-catagory, the name of each metro area, total
population size of each metro area,the population size not in metro
areas for each state, income levels of residents by state and
seperate for each metro area broken dowm by levels (i.e. % or # under
$50,000; $50,000-$100,000; $100,000- $150,000; over $150,000 ). The
income breakout catagories could be different if that is what is
available.

If this is not readily available - will consider options based on what
is easily obtainable - I think the Dept of Labor or Census data may be
potential sources.

Request for Question Clarification by rainbow-ga on 19 Nov 2006 23:06 PST
Hi environ,

I have been working on your question and want to let you know of my progress.

I have compiled, in an excel sheet, the list of the states and their
corresponding Metropolitan Statistical Areas (MSA). Finding the
population for each is not a problem until some MSA's overlap into
different states.
For example:

Huntington-Ashland, W.Va.-Ky.-Ohio 

In such cases, I have to find the counties each of these MSA's consist
of and then locate the population for each county. I have begun
working on this.

The following is an example of one state I have completed so far (with
no overlapping MSA's). Please let me know if this is the information
and format you are looking for:

                                     POP.
ARIZONA	                          5,939,292
Flagstaff, Ariz. 	            123,866
Phoenix-Mesa-Scottsdale, Ariz.    3,865,077
Prescott, Ariz. 	            198,701
Tucson, Ariz. 	                    924,786
Yuma, Ariz.  	                    181,277
Remaining Areas                     645,585


I have not yet begun looking for income levels for the requested
areas. I am sure I will come across obstacles since I doubt this
information is readily available. Anyway, I will let you know as I go
along.

Looking forward to hearing your views.

Best regards,
Rainbow

Clarification of Question by environ-ga on 20 Nov 2006 04:22 PST
You are certainly on the correct track - adding income levels is
critical but you can take some liberties and can be off a county or
three.

Maybe the census or labor dept can be a source for the income levels.

Thanks you.

You can also send me the report in two phases - population and metro
areas and later the complete report that includes the income levels.

Regards

Rob Trow

Request for Question Clarification by rainbow-ga on 20 Nov 2006 06:31 PST
Hi Rob,

I have finally located the required data. Now it's a matter of
compiling and formatting as you have requested. I will hopefully have
this completed in the next day or so.

I hope this does not cause you any incovenience.

Best regards,
Rainbow

Request for Question Clarification by rainbow-ga on 20 Nov 2006 13:17 PST
Hi Rob,

I need to clarify one point with you:

Since some MSA's overlap into one or more states, the number of those
in income levels for the MSA's will not always correspond to the
number of those in the same state.

For example:
                                                 TOTAL in HOUSEHOLD
MASSACHUSETTS	                                      2448032
Barnstable Town, Mass. 		                       100254
Boston-Cambridge-Quincy, Mass.-N.H. 	               168231
Pittsfield, Mass. 		                        54580
Providence-New Bedford-Fall River, R.I.-Mass. 	       614431
Springfield, Mass.                                     265188
Worcester, Mass.   		                       284040

Therefore, please note that for the MSA of Boston-Cambridge-Quincy,
Mass.-N.H., the household number is both those located in Mass. and in
New Hampshire. The same is true for Providence-New Bedford-Fall River,
R.I.-Mass.

Best regards,
Rainbow

Clarification of Question by environ-ga on 20 Nov 2006 14:56 PST
This is fine - your are on the correct path - take the time you need.

Regards

Rob
Answer  
Subject: Re: Demographic Data - United States
Answered By: rainbow-ga on 21 Nov 2006 00:10 PST
Rated:5 out of 5 stars
 
Hi Rob,

At the following url you will find an excel file with the requested information:

http://download.yousendit.com/0DC7190C771912A1 

This file, which is available for you to save and download, will
remain on the server a limited period, so please download it as soon
as possible.


For some reason the income data for the following 3 MSA's is not available:

Hinesville-Fort Stewart, Ga. 
Lewiston, Idaho-Wash.
Carson City, Nev. 


Also please note there is a slight margin of error for the income
data. (Source: U.S. Census Bureau)


I usually describe my search strategy but to explain how I was able to
compile the information is much too complicated. :-)

However, the information was compiled mainly with the data available
at the U.S. Census Bureau from the following sites:

http://factfinder.census.gov/servlet/GCTTable?_bm=y&-geo_id=01000US&-_box_head_nbr=GCT-T1-R&-ds_name=PEP_2005_EST&-redoLog=false&-mt_name=ACS_2005_EST_G00_GCT2001_US9&-format=US-9S

http://www.census.gov/population/estimates/metro_general/List4.txt

http://www.census.gov/popest/counties/CO-EST2005-01.html

http://factfinder.census.gov/servlet/DCGeoSelectServlet?ds_name=ACS_2005_EST_G00_


I hope the information provided is helpful. If you have any questions
regarding my answer please don't hesitate to ask.

Best regards,
Rainbow

Request for Answer Clarification by environ-ga on 21 Nov 2006 05:06 PST
thank you for the wonderful work - could you make a change so I can
fit it one one landscape sheet - can you combine income levels to teh
following catagories household income under $25, 25,-50, 5o-75,
75-100; 100-150, ove150

Looking to have the report print as a one page accross fit - leave as
many income grouping as possible so long as it can firt one page
across all date

thanks]
rob

Clarification of Answer by rainbow-ga on 21 Nov 2006 09:38 PST
Hi Rob,

I have formatted the excel file the way you have requested. It is
ready for download at the following url:

http://download.yousendit.com/EB221BE72409C157 

Please let me know if this suits your purposes.

Best regards,
Rainbow
environ-ga rated this answer:5 out of 5 stars and gave an additional tip of: $50.00
wonderfully prepared

Comments  
Subject: Re: Demographic Data - United States
From: rainbow-ga on 22 Nov 2006 05:36 PST
 
I'm glad I was able to help. Thank you very much for the rating and generous tip.
Best regards,
Rainbow

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy