Vote up to Idea Access Micro-data for Blocks Vote down to Idea Access Micro-data for Blocks

Rank37

Idea#220

This idea is active.
API Technical Discussions »

Access Micro-data for Blocks

I'm working on a school project with 2010 Census data.

Currently, we are getting tract-level data using codes from http://api.census.gov/data/2010/sf1/variables.json to get data.

For example, to find the white 65-year old males in a county's tracts, we make the API call:

http://api.census.gov/data/2010/sf1?key=[key]&get=PCT012I068,NAME&for=tract:*&in=state:08+county:059

However, when making the same call at a block level, the file is empty. See:

http://api.census.gov/data/2010/sf1?key=[key]&get=PCT012I068,NAME&for=block:*&in=state:08+county:059+tract:012035

We assume this is because the 2010 variables we are currently using are pre-aggregated data. It would be infeasible to compile this data for all the blocks.

How do we get access to the micro-data to get results at the block level (ex: white male 65-year-olds per block)?

Comment

Submitted by elizabeth.duncan 6 months ago

Comments (9)

  1. PCT tables are tract level up; no block data. You will need to use P tables to access block population items.

    6 months ago
  2. elizabeth.duncan Idea Submitter

    What are P tables? Can you link me to documentation that will specify how to access them?

    Thanks for the help!

    6 months ago
  3. consider using table P12 ... see SF1 TD: http://www.census.gov/prod/cen2010/doc/sf1.pdf

    6 months ago
  4. elizabeth.duncan Idea Submitter

    Sorry for the delay - my team was out on spring break.

    This was super helpful and we will change our code accordingly.

    However, does that mean it is IMPOSSIBLE to get data on age, gender, and race for a block level? Because only variables starting with PCT have that information....

    5 months ago
  5. Moderator

    Hi Elizabeth,

    Do the P12 selection of tables (as referred to by the community member above here: http://www.census.gov/prod/cen2010/doc/sf1.pdf PAGE:142) not fit your purposes? Those tables contain Sex and Age broken out by Race groups at the block level...

    Just trying to make sure I understand your needs.

    5 months ago
  6. elizabeth.duncan Idea Submitter

    We just looked at the P only codes - and those span five years (which will work for our project). For example, P012A015 gives white males from 45 to 49 years. We are currently using these codes now, and they are working great! :)

    Just out of curiosity, however, I asked in my comment if it was possible to get a specific age (ex: white males of JUST 45 years). I didn't see any P codes that had only a year age range.

    5 months ago
  7. Moderator

    There is usually a limit to the amount of granularity you get in the aggregated tables. Will the 5-year swaths suffice though? :)

    5 months ago
  8. elizabeth.duncan Idea Submitter

    5 year swaths will work perfectly - I just wanted to make sure that I was getting the best possible granularity.

    5 months ago
  9. elizabeth.duncan Idea Submitter

    Thanks all for the help!

    5 months ago

Vote Activity Show

Events

  1. The idea was posted
    6 months ago