• ACS 1 Year Microdata Question

    Hi,

    I am a total novice using MDAT. However, for a research project I am trying to download a CSV of a custom table I've built with several recoded variables with a given state as my selected geography.

    I'm haven't been able to download a CSV that has…

  • RE: County level estimates

    Bernie, thank you for your suggestions and it's very helpful. Do you know how use the Counties in PUMS data? I have to compute the count of these veterans who would be eligible for VA healthcare using their income and disability fields in the PUMS data…
  • Educational attainment data VS CPS ASEC

    Hi everyone!

    Has anybody looked into this apparent statistically significant difference between the two surveys on educational attainment data?

    2020 CPS counts a total of 113381 thousand 18+ civilian noninstitutionalized population with at least an associates…

  • RE: Educational attainment by race/ethnicity and county - can't get totals and subtotals to match

    Using the PUMS data which allow me to get data for planning districts on attainment by race, Spanish/Hispanic/Latino, and gender for all ages, I see what I was getting wrong.   In the regular tables for educational attainment age 25+, I can get match the…

  • RE: Estimating Rental Burden (GRAPI) by Race of Householder

    While I haven't tried to retrace your steps, I think this might be a universe issue. The Census Bureau doesn't calculate cost burden for households with no income or negative income. Because Stata treats missing values as the largest possible value, your…
  • Question about the ESR Variable

    Was looking at occupation data from PUMS, and also using the ESR variable.

    If ESR=6, you are not in the labor force. I assumed that would mean that you had no OCCP value as well.

    That assumption is wrong. Can someone explain why you'd have an OCCP code…

  • Property Tax Topcodes

    Hi all,

    I am working on cross-state differences in property taxes in 2015.

    If I understand the data dictionary correctly, the ACS variable TAXAMT (PROPTX99 in IPUMS) is topcoded in all states and years at 10,000 USD (category value 68). 

    For states with high…

  • tidycensus error + SQL pseduocode

    Hello!  First time poster, so please be gentle.  I'm relatively new to unaggregated Census data, although have a solid knowledge of R, statistics, and (if dated) survey methods.

    I have spend a few hours over the long weekend trying to familiarize myself…

  • Calculating a Median From a Weighted Distribution

    I'm reading through the PDF "Understanding and Using American Community Survey Data - What State and Local Government Users Need to Know" and need help recreating the calculation for the median salary in Case Study #1 as shown in Figure 3.8…

  • RE: Does a "female householder" variable exist without the "no spouse or partner present" ?

    It looks like Table B11012 (Households by Household Type) is the best bet for what the original researcher used. That particular table doesn't indicate the sex of householder for either married couple of cohabiting couple households. It does have "female…