Dear All,
Relatively new to the ACS but have managed to pull a few key variables I need at the zip code level from the API. One variable I have not been able to access, however, has been property tax payments --- the IPUMS variable PROPTX99. Can anyone point me to the API variable name or know this is available?
Many thanks in advance,
Jake
Hi Jake,
Best place to find these things is in the Table Shells file, available here: https://www2.census.gov/programs-surveys/acs/summary_file/2019/documentation/user_tools/ACS2019_Table_Shells.xlsxTable…
Best place to find these things is in the Table Shells file, available here: https://www2.census.gov/programs-surveys/acs/summary_file/2019/documentation/user_tools/ACS2019_Table_Shells.xlsxTable B25103 "MORTGAGE STATUS BY MEDIAN REAL ESTATE TAXES PAID (DOLLARS)" has as its first variable, B25103_001, Median real estate taxes paid, for all owner-occupied housing units. You can also calculate the average by using table B25090, which has the aggregate real estate taxes paid.
Since you're looking for a relatively simple variable, you don't need to use PUMS. You can use a summary file, which lets you get the data at the zip code tabulation area (ZCTA) level.
Woah-- that's awesome Bernie, exactly what I was looking for. Many thanks!
I agree, at this point I don't need the micro data and for now I will just pull the zip-code level data from the API. I hadn't heard of the summary files but I will look into these as well.