About this dataset

Context

The dataset presents a breakdown of households across various income brackets in Universal City, TX, as reported by the U.S. Census Bureau. The Census Bureau classifies households into different categories, including total households, family households, and non-family households. Our analysis of U.S. Census Bureau American Community Survey data for Universal City, TX reveals how household income distribution varies among these categories. The dataset highlights the variation in number of households with income, offering valuable insights into the distribution of Universal City households based on income levels.

Key observations

• For Family Households: In Universal City, the majority of family households, representing 14.33%, earn $75,000 to $99,999, showcasing a substantial share of the community families falling within this income bracket. Conversely, the minority of family households, comprising 0.23%, have incomes falling $25,000 to $29,999, representing a smaller but still significant segment of the community.
• For Non-Family Households: In Universal City, the majority of non-family households, accounting for 15.69%, have income $60,000 to $74,999, indicating that a substantial portion of non-family households falls within this income bracket. On the other hand, the minority of non-family households, comprising 2.6%, earn $25,000 to $29,999, representing a smaller, yet notable, portion of non-family households in the community.

Content

When available, the data consists of estimates from the U.S. Census Bureau American Community Survey (ACS) 2019-2023 5-Year Estimates.

Income Levels:

• Less than $10,000
• $10,000 to $14,999
• $15,000 to $19,999
• $20,000 to $24,999
• $25,000 to $29,999
• $30,000 to $34,999
• $35,000 to $39,999
• $40,000 to $44,999
• $45,000 to $49,999
• $50,000 to $59,999
• $60,000 to $74,999
• $75,000 to $99,999
• $125,000 to $149,999
• $150,000 to $199,999
• $200,000 or more

Variables / Data Columns

• Income Level: The income level represents the income brackets ranging from Less than $10,000 to $200,000 or more in Universal City, TX (As mentioned above).
• All Households: Count of households for the specified income level
• % All Households: Percentage of households at the specified income level relative to the total households in Universal City, TX
• Family Households: Count of family households for the specified income level
• % Family Households: Percentage of family households at the specified income level relative to the total family households in Universal City, TX
• Non-Family Households: Count of non-family households for the specified income level
• % Non-Family Households: Percentage of non-family households at the specified income level relative to the total non-family households in Universal City, TX

Good to know

Margin of Error

Data in the dataset are based on the estimates and are subject to sampling variability and thus a margin of error. Neilsberg Research recommends using caution when presening these estimates in your research.

Custom data

If you do need custom data for any of your research project, report or presentation, you can contact our research staff at research@neilsberg.com for a feasibility of a custom tabulation on a fee-for-service basis.

Inspiration

Neilsberg Research Team curates, analyze and publishes demographics and economic data from a variety of public and proprietary sources, each of which often includes multiple surveys and programs. The large majority of Neilsberg Research aggregated datasets and insights is made available for free download at https://www.neilsberg.com/research/.

Recommended for further research

This dataset is a part of the main dataset for Universal City median household income. You can refer the same here

Comprehensive demographic dataset for Universal City, Los Angeles, CA, US including population statistics, household income, housing units, education levels, employment data, and transportation with year-over-year changes.

About this dataset

Context

The dataset presents the mean household income for each of the five quintiles in Universal City, TX, as reported by the U.S. Census Bureau. The dataset highlights the variation in mean household income across quintiles, offering valuable insights into income distribution and inequality.

Key observations

• Income disparities: The mean income of the lowest quintile (20% of households with the lowest income) is 24,232, while the mean income for the highest quintile (20% of households with the highest income) is 225,431. This indicates that the top earners earn 9 times compared to the lowest earners.
• *Top 5%: * The mean household income for the wealthiest population (top 5%) is 347,407, which is 154.11% higher compared to the highest quintile, and 1433.67% higher compared to the lowest quintile.

Content

When available, the data consists of estimates from the U.S. Census Bureau American Community Survey (ACS) 2019-2023 5-Year Estimates.

Income Levels:

• Lowest Quintile
• Second Quintile
• Third Quintile
• Fourth Quintile
• Highest Quintile
• Top 5 Percent

Variables / Data Columns

• Income Level: This column showcases the income levels (As mentioned above).
• Mean Household Income: Mean household income, in 2023 inflation-adjusted dollars for the specific income level.

Good to know

Margin of Error

Data in the dataset are based on the estimates and are subject to sampling variability and thus a margin of error. Neilsberg Research recommends using caution when presening these estimates in your research.

Custom data

If you do need custom data for any of your research project, report or presentation, you can contact our research staff at research@neilsberg.com for a feasibility of a custom tabulation on a fee-for-service basis.

Inspiration

Neilsberg Research Team curates, analyze and publishes demographics and economic data from a variety of public and proprietary sources, each of which often includes multiple surveys and programs. The large majority of Neilsberg Research aggregated datasets and insights is made available for free download at https://www.neilsberg.com/research/.

Recommended for further research

This dataset is a part of the main dataset for Universal City median household income. You can refer the same here

As the renewable energy transition accelerates, housing, due to its high energy demand, can play a critical role in the clean energy shift. Specifically, multifamily housing provides a unique opportunity for solar photovoltaic (PV) system adoption, given the existing competing interests between landlords and tenants which has historically slowed this transition. To address this transition gap, this project identified and ranked Metropolitan Statistical Areas (MSAs) in the United States for ZNE Capital (the client) to acquire multifamily housing to install solar PV systems. The group identified seven criteria to determine favorable markets for rooftop solar PV on multifamily housing: landlord policy favorability, real estate market potential, CO2 abatement potential, electricity generation potential, solar installation internal rate of return, climate risk avoidance, and health costs associated with primary air pollutants. A total investment favorability score is calculated based on criteria importance assigned by the user. Investment favorability scores were investigated for different preferences to demonstrate the robustness and generalizability of the framework. The data analysis and criteria calculations were conducted using RStudio, ultimately to provide reproducible code to be used for future projects. The results are presented in a ranked list from best to worst metro areas to invest in. Future studies can utilize the reproducible code to inform decisions on where to invest in solar PV on multifamily housing anywhere in the United States by changing weights within the model depending on preferences. Methods

Collecting real estate and landlord data for metropolitan statistical areas (MSAs) from federal agency databases.

Real estate metrics: Six indicator metrics were selected to represent areas with growing housing demands. The metrics included were population growth, employment growth, average annual occupancy, annual rent change, the ratios of median annual rent to median income, and median income to median home price. The population estimates and median income data was downloaded from the Census Bureau. Median rent data was downloaded from HUDuser. Median home price data was downloaded from National Association of REALTORS®. Students were provided temporary memberships to Yardi Systems Matrix to obtain multifamily occupancy rates, and this data will not be redistributed. All the real estate metrics were combined into a single dataset using CBSA codes, which each MSA has a unique 5-digit identifier. Income-to-home price and rent-to-income ratios were calculated in R Studio.

Landlord data: the minimum security deposit and eviction notice data was collected for each state and manually compiled into an Excel. Security deposit information was provided as the number of months of rent. States with no maximum deposit limit received a score of 1.0, meaning it was the most favorable. Two month's rent was scored as 0.5, and one month's rent was given a score of 0.

Using NREL's REopt web tool to 1) model solar PV system on multifamily buildings in various cities and 2) obtain data to represent energy generation, CO2 abatement potential, avoided health costs from emissions, and solar project financial criteria.

An anchor city was identified within each MSA as the city with the highest population to input into the REopt tool. Default inputs were changed based on information provided by industry experts and changes in federal funding programs. Detailed instructions of inputs were created to ensure consistency when running the model for each city. The four outputs collected from the tool include: annual energy generation from renewables (%), lifecycle total CO2 emissions, health costs associated with primary air pollutants, and internal rate of return(%). The group divided up a list of cities, input the respective data for each one, obtained the outputs, then compiled it into a Google sheet. Outputs were checked by other members to ensure accuracy.

Collecting climate risk data from FEMA's National Risk Index Map.

Climate risk data was downloaded as a CSV file. The risk score was used to represent impacts of climate variability on long-term real estate investments. Risk scores were provided at the county level. The group identified the county each city resided in, to associate the correct score to each city in R Studio

Normalizing the data

Metrics were normalized by subtracting the minimum value for the metric from each value and dividing by the difference between the maximum and minimum values. This resulted in scores between 0 and 1 that were relative to the MSAs included in the analysis.

Weighing the data

Real Estate and Landlord Criteria metrics: these two criteria contained more than one metric, so the metrics within these criteria were weighted to produce real estate and landlord scores. Weights for each criterion sum to 1, in which higher weights indicate greater importance for multifamily real estate investments. Each weight was multiplied by the respective metric, then all weighted metrics within each criterion were summed to produce the criteria score. Investment Favorability Score: seven criteria were multiplied by respective weights based on the stakeholder's preferences. Weights sum to 1 to ensure consistency throughout the project. The sum of the seven weighted criteria is the investment favorability score.