Question: Median income and education levels by zip code for Peoria, IL

Thu 2 Sep 2010 - 5:22 pm UTC

| |

ANSWERED on Wed 23 Sep 2009 - 2:35 am UTC by easterangel

Question: Median income and education levels by zip code for Peoria, IL

Please carefully read the Disclaimer and Terms & conditions.
Priced at $60.00
The customer tipped the researcher $20.00

Actions: Add Comment

Asked by mblind on Wed 23 Sep 2009 - 12:00 am UTC:

I'm writing an article (part of a series, actually) and I need some
real-life information to help illustrate real-estate guidelines for
entrepreneurs in selecting retail locations.  Fortunately, I can give you
some leads, but this will take some time and a certain amount of internet
savvy to figure out: The information is out there; what I'm paying for is
the time and netsmarts.

For purposes of illustration (and to answer the age old question, "But Will
It Play in Peoria?") I'd like some information on the Peoria, IL market.

Here's our starting point:
http://maps.huge.info/zip.htm

Punch in 61605 for Downtown Peoria.  You can zoom in or click to get the
zip codes we need. (it's built on Google Maps, so should be familiar)

The zip codes in the area start with 616 or 615.

here's the important bit:
http://www.census.gov/epcd/www/zipstats.html

For the closest dozen or so zip codes to downtown Peoria (minimum 12, I'll
tip $20 for a full listing of all 616 and 615 zip codes), I'd like a
listing by zip code of

a. number of households
b. median income
c. number/percent of college graduates (looks like the census was tracking
"persons 25 years and older with bachelor's degree or higher)

That's it:  3 numbers times a dozen (or more) zip codes.  The 2000 census
numbers are fine.  Anyone feel like taking care of the grunt work for me?

Uclue Researcher Request for clarification by Researcher easterangel on Wed 23 Sep 2009 - 1:09 am UTC:

Hi mblind!

In the Census data, do you mean household population or housing units? The
household numbers in the map is close but not equal to the one for housing
units as described by the Census. 

Plus the definition of number of households leans more towards household
population.

Regards!

Question clarification by mblind on Wed 23 Sep 2009 - 1:28 am UTC:

I don't know where huge.info gets their numbers, but the discrepancy is
likely an official-2000-census vs subsequent-periodic-updates issue.

If you default to official census numbers you'll be right by me.  And by
'household' I was looking for housing units (actual families, more often
than not) -- but any method will work so long as it is consistent.  The
goal is a set of comparative statistics, not so much an actual accounting.

Uclue Researcher Request for clarification by Researcher easterangel on Wed 23 Sep 2009 - 1:58 am UTC:

I will be using total housing units. It has a breakdown of occupied or not.
 Will it be ok to go for the total number since I have already gone to this
path of gathering information?

Question clarification by mblind on Wed 23 Sep 2009 - 2:01 am UTC:

Yep.

Question clarification by mblind on Wed 23 Sep 2009 - 2:02 am UTC:

That is to say: Yes, that will be fine for what I asked for.  ;)

Uclue Researcher Answer by Researcher easterangel on Wed 23 Sep 2009 - 2:35 am UTC:

Hi again!

I prepared an Excel spreadsheet for the list of zip codes and the data you
needed. You can view it in the following link:

http://spreadsheets.google.com/ccc?key=0AnrlT5-dRhamdEpyN1k0QTk5RnFuaXBIaHc2NGRVb3c&hl=en

Once you have download it, I can delete it for you.

It seems the 2000 Census only has data up to the zip code 61615.

In case you have further questions as regards this answer of mine, just ask
for a clarification.

Regards,
Easterangel

Accepted and rated by mblind on Wed 23 Sep 2009 - 2:22 pm UTC:

exactly what I needed, and having it in a spreadsheet is a nice bonus! 
Thank you very much.

Accepted and rated by mblind on Wed 23 Sep 2009 - 2:23 pm UTC:

exactly what I needed, and having it in a spreadsheet is a nice bonus! 
Thank you very much.

Uclue Researcher Comment by Researcher easterangel on Wed 23 Sep 2009 - 3:05 pm UTC:

Thanks for the tip! :)

Comment by mblind on Wed 23 Sep 2009 - 4:40 pm UTC:

I double checked and zip code 61616 was added since the 2000 census and so
would be included in the data above (as part of 61614) -- so no errors
there.

I'm writing the article now; if anyone reads it and likes my methods, you
might be getting a few variations on this exact question.  Hope it goes
quicker the second time.  (& thanks again)

Uclue Researcher Comment by Researcher easterangel on Wed 23 Sep 2009 - 9:58 pm UTC:

Thanks as well mblind and I apologize for not covering 61614 and it seems I
need an improved method of gathering zip codes next time.

I would welcome the variations on this kind of work.

Regards!

Uclue Researcher Comment by Researcher admin on Thu 24 Sep 2009 - 9:29 am UTC:

Thanks for the kind comments about Uclue in your article, mblind!

"Rethinking the Box: Location, Location, Location ... Peoria"
http://www.rocketbomber.com/2009/09/23/rethinking-the-box-location-location-location-and-will-it-play-in-peoria

Uclue Researcher Answer clarification by Researcher easterangel on Fri 25 Sep 2009 - 7:40 am UTC:

Thanks for mentioning this research on your article mblind! I am really
thankful for this.

By the way I posted this as a comment since I want to ask you if you still
want to remove the spreadsheet. I promised I will do that for you but
seeing now that your readers may flock here they might be disappointed if
the link to the spreadsheet is not available anymore.

Regards!

Comment by mblind on Fri 25 Sep 2009 - 1:05 pm UTC:

I leave comments open on one of my posts for six weeks -- if it's not
clogging anything up on your end you might leave the spreadsheet up for at
least that long.  If you came across the file next year and wonder, "why
haven't I deleted this?" and then delete it, that would be fine too, at
that point.

Comment by User analyst850 on Wed 21 Oct 2009 - 3:59 am UTC:

easterangel,

I am curious as to how you came about compiling the information by zip code
for mblind's previous question. I have searched numerous sites to no
success on how to pull the information into a spreadsheet besides going zip
code by zip code for a metropolitan area. 

Unlike mblind, I need the exact same information, but for 30 metro areas
across the country. Thank you for your help and would really appreciate it
if you could briefly explain.

Actions: Add Comment

Bookmark it!