Poverty Status by Town reports the number and percentage of people and children living in poverty, by race/ethnicity and age range.

In 2024, approximately 10.6 percent of the population was living below the national poverty line in the United States. This reflected a 0.5 percentage point decrease from the previous year. Most recently, poverty levels in the country peaked in 2010 at just over 15 percent. Poverty in the U.S. States The number of people living in poverty in the U.S. as well as poverty rates, vary greatly from state to state. With their large populations, California and Texas led that charts in terms of the size of their impoverished residents. On the other hand, Louisiana had the highest rates of poverty, standing at 20 percent in 2024. The state with the lowest poverty rate was New Hampshire at 5.9 percent. Vulnerable populations The poverty rate in the United States varies widely across different ethnic groups. American Indians and Alaska Natives are the ethnic group with the highest levels of poverty in 2024, with about 19 percent earning an income below the official threshold. In comparison, only about 7.5 percent of the White (non-Hispanic) and Asian populations were living below the poverty line. Children are one of the most poverty endangered population groups in the U.S. between 1990 and 2024. Child poverty peaked in 1993 with 22.7 percent of children living in poverty. Despite fluctuations, in 2024, poverty among minors reached its lowest level in decades, falling to 14.3 percent.

Content

Data was pulled from a table in the following Wikipedia article: https://en.wikipedia.org/wiki/List_of_United_States_cities_by_population I used Microsoft Excel's PowerQuery function to pull the table from Wikipedia. Lists each city, its rank (based on 2020 population), some data on its area, and population in both 2020 and 2010.

Living wages are based in US Dollars per hour, assuming 2080 hours worked per year.

In addition, living wage data from http://livingwage.mit.edu I left out the minimum wage from this dataset because it appears the data is somewhat inconsistent, and often falls back on the state minimum where localities can have a higher min wage. I also omitted the poverty wage data because for the most part it seemed to be the same for most areas. One last thing to keep in mind is some cities are grouped up into metropolitan statistical areas, and as a result you will see cities that are near each other have identical data.

Banner image source: https://unsplash.com/photos/wh-7GeXxItI

This dataset provides equity-relevant characteristics for each census tract in the Twin Cities region. Formerly known as the Areas of Concentrated Poverty dataset, it has been greatly expanded to provide a more nuanced portrait of neighborhoods, with data on: demographic and socioeconomic characteristics (including multiple income levels); racial/ethnic/cultural groups; historical data on discriminatory practices; facets of housing markets; land use, environment/climate, amenities, and employment/commuting patterns. Our intention is to call attention to broader patterns of economic segregation and their root causes, and to show that census tracts are much more multifaceted than a narrow focus on poverty rates would imply.

For more background on this file, please see our website ( https://metrocouncil.org/research/place-basedequity ) -- in particular, the User Guide.

This table contains data on the percentage of the total population living below 200% of the Federal Poverty Level (FPL), and the percentage of children living below 200% FPL for California, its regions, counties, cities, towns, public use microdata areas, and census tracts. Data for time periods 2011-2015 (overall poverty) and 2012-2016 (child poverty) and with race/ethnicity stratification is included in the table. The poverty rate table is part of a series of indicators in the Healthy Communities Data and Indicators Project of the Office of Health Equity. Poverty is an important social determinant of health (see http://www.healthypeople.gov/2020/topicsobjectives2020/overview.aspx?topicid=39) that can impact people’s access to basic necessities (housing, food, education, jobs, and transportation), and is associated with higher incidence and prevalence of illness, and with reduced access to quality health care. More information on the data table and a data dictionary can be found in the About/Attachments section.

This dataset contains a selection of 27 indicators of public health significance by Chicago community area, with the most updated information available. The indicators are rates, percents, or other measures related to natality, mortality, infectious disease, lead poisoning, and economic status. See the full description at https://data.cityofchicago.org/api/assets/BB7058D2-E8A1-4E11-86CE-6CF1738F0A02.

This map displays data from the Selected Economic Indicators (DP03) dataset from the 2010 American Community Survey 5-Yr Estimates, U.S. Census Bureau. Data is shown at the level of Census Tract, County, and Small Area (aggregation of Census Tracts developed by the New Mexico Department of Health). Measuring poverty is a topic of much current discussion. See the following links: A Different Way to Measure Poverty - http://www.sanders.senate.gov/imo/media/image/census.jpg"Few topics in American society have more myths and stereotypes surrounding them than poverty, misconceptions that distort both our politics and our domestic policy making."They include the notion that poverty affects a relatively small number of Americans, that the poor are impoverished for years at a time, that most of those in poverty live in inner cities, that too much welfare assistance is provided and that poverty is ultimately a result of not working hard enough. Although pervasive, each assumption is flat-out wrong." -Mark Rank, Professor of Social Welfare at Washington University: http://opinionator.blogs.nytimes.com/2013/11/02/poverty-in-america-is-mainstream/

Table from the American Community Survey (ACS) 5-year series on poverty and employment status related topics for City of Seattle Council Districts, Comprehensive Plan Growth Areas and Community Reporting Areas. Table includes B23025 Employment Status for the Population 16 years and over, B23024 Poverty Status by Disability Status by Employment Status for the Population 20 to 64 years, B17010 Poverty Status of Families by Family Type by Presence of Related Children under 18 years, C17002 Ratio of Income to Poverty Level in the Past 12 Months. Data is pulled from block group tables for the most recent ACS vintage and summarized to the neighborhoods based on block group assignment.Table created for and used in the Neighborhood Profiles application.Vintages: 2023ACS Table(s): B23025, B23024, B17010, C17002Data downloaded from: Census Bureau's Explore Census Data The United States Census Bureau's American Community Survey (ACS):About the SurveyGeography & ACSTechnical DocumentationNews & UpdatesThis ready-to-use layer can be used within ArcGIS Pro, ArcGIS Online, its configurable apps, dashboards, Story Maps, custom apps, and mobile apps. Data can also be exported for offline workflows. Please cite the Census and ACS when using this data.<d

This dataset contains a selection of six socioeconomic indicators of public health significance and a “hardship index,” by Chicago community area, for the years 2007 – 2011. The indicators are the percent of occupied housing units with more than one person per room (i.e., crowded housing); the percent of households living below the federal poverty level; the percent of persons in the labor force over the age of 16 years that are unemployed; the percent of persons over the age of 25 years without a high school diploma; the percent of the population under 18 or over 64 years of age (i.e., dependency); and per capita income. Indicators for Chicago as a whole are provided in the final row of the table. See the full dataset description for more information at https://data.cityofchicago.org/api/assets/8D10B9D1-CCA3-4E7E-92C7-5125E9AB46E9.

VITAL SIGNS INDICATOR
Poverty (EQ5)

FULL MEASURE NAME
The share of the population living in households that earn less than 200 percent of the federal poverty limit

LAST UPDATED
January 2023

DESCRIPTION
Poverty refers to the share of the population living in households that earn less than 200 percent of the federal poverty limit, which varies based on the number of individuals in a given household. It reflects the number of individuals who are economically struggling due to low household income levels.

DATA SOURCE
U.S Census Bureau: Decennial Census - http://www.nhgis.org
1980-2000

U.S. Census Bureau: American Community Survey - https://data.census.gov/
2007-2021
Form C17002

CONTACT INFORMATION
vitalsigns.info@mtc.ca.gov

METHODOLOGY NOTES (across all datasets for this indicator)
The U.S. Census Bureau defines a national poverty level (or household income) that varies by household size, number of children in a household, and age of householder. The national poverty level does not vary geographically even though cost of living is different across the United States. For the Bay Area, where cost of living is high and incomes are correspondingly high, an appropriate poverty level is 200% of poverty or twice the national poverty level, consistent with what was used for past equity work at MTC and ABAG. For comparison, however, both the national and 200% poverty levels are presented.

For Vital Signs, the poverty rate is defined as the number of people (including children) living below twice the poverty level divided by the number of people for whom poverty status is determined. The household income definitions for poverty change each year to reflect inflation. The official poverty definition uses money income before taxes and does not include capital gains or non-cash benefits (such as public housing, Medicaid and food stamps).

For the national poverty level definitions by year, see: US Census Bureau Poverty Thresholds - https://www.census.gov/data/tables/time-series/demo/income-poverty/historical-poverty-thresholds.html.

For an explanation on how the Census Bureau measures poverty, see: How the Census Bureau Measures Poverty - https://www.census.gov/topics/income-poverty/poverty/guidance/poverty-measures.html.

American Community Survey (ACS) 1-year data is used for larger geographies – Bay counties and most metropolitan area counties – while smaller geographies rely upon 5-year rolling average data due to their smaller sample sizes. Note that 2020 data uses the 5-year estimates because the ACS did not collect 1-year data for 2020.

To be consistent across metropolitan areas, the poverty definition for non-Bay Area metros is twice the national poverty level. Data were not adjusted for varying income and cost of living levels across the metropolitan areas.

Tabular data of population by age groups, race and gender, and the poverty by race is attached to the split tract geography to create this split tract with population and poverty data. Split tract data is the product of 2020 census tracts split by 2021 incorporated city boundaries and unincorporated community/countywide statistical areas (CSA) boundaries. The census tract boundaries have been altered and aligned where necessary with legal city boundaries and unincorporated areas, including shoreline/coastal areas. Census Tract:Every 10 years the Census Bureau counts the population of the United States as mandated by Constitution. The Census Bureau (https://www.census.gov/) released 2020 geographic boundaries data including census tracts for the analysis and mapping of demographic information across the United States. City Boundary:City Boundary data is the base map information for the County of Los Angeles. These City Boundaries are based on the Los Angeles County Seamless Cadastral Landbase. The Landbase is jointly maintained by the Los Angeles County Assessor and the Los Angeles County Department of Public Works (DPW). This layer represents current city boundaries within Los Angeles County. The DPW provides the most current shapefiles representing city boundaries and city annexations. True, legal boundaries are only determined on the ground by surveyors licensed in the State of California.Countywide Statistical Areas (CSA): The countywide Statistical Area (CSA) was defined to provide a common geographic boundary for reporting departmental statistics for unincorporated areas and incorporated Los Angeles city to the Board of Supervisors. The CSA boundary and CSA names are established by the CIO and the LA County Enterprise GIS group worked with the Los Angeles County Board of Supervisors Unincorporated Area and Field Deputies that reflect as best as possible the general name preferences of residents and historical names of areas. This data is primarily focused on broad statistics and reporting, not mapping of communities. This data is not designed to perfectly represent communities, nor jurisdictional boundaries such as Angeles National Forest. CSA represent board approved geographies comprised of Census block groups split by cities.Data Field:CT20: 2020 Census tractFIP21: 2021 City FIP CodeCITY: City name for incorporated cities and “Unincorporated” for unincorporated areas (as of July 1, 2021) CSA: Countywide Statistical Area (CSA) - Unincorporated area community names and LA City neighborhood names.CT20FIP21CSA: 2020 census tract with 2021 city FIPs for incorporated cities, unincorporated areas and LA neighborhoods. SPA22: 2022 Service Planning Area (SPA) number.SPA_NAME: Service Planning Area name.HD22: 2022 Health District (HD) number: HD_NAME: Health District name.POP21_AGE_0_4: 2021 population 0 to 4 years oldPOP21_AGE_5_9: 2021 population 5 to 9 years old POP21_AGE_10_14: 2021 population 10 to 14 years old POP21_AGE_15_17: 2021 population 15 to 17 years old POP21_AGE_18_19: 2021 population 18 to 19 years old POP21_AGE_20_44: 2021 population 20 to 24 years old POP21_AGE_25_29: 2021 population 25 to 29 years old POP21_AGE_30_34: 2021 population 30 to 34 years old POP21_AGE_35_44: 2021 population 35 to 44 years old POP21_AGE_45_54: 2021 population 45 to 54 years old POP21_AGE_55_64: 2021 population 55 to 64 years old POP21_AGE_65_74: 2021 population 65 to 74 years old POP21_AGE_75_84: 2021 population 75 to 84 years old POP21_AGE_85_100: 2021 population 85 years and older POP21_WHITE: 2021 Non-Hispanic White POP21_BLACK: 2021 Non-Hispanic African AmericanPOP21_AIAN: 2021 Non-Hispanic American Indian or Alaska NativePOP21_ASIAN: 2021 Non-Hispanic Asian POP21_HNPI: 2021 Non-Hispanic Hawaiian Native or Pacific IslanderPOP21_HISPANIC: 2021 HispanicPOP21_MALE: 2021 Male POP21_FEMALE: 2021 Female POV21_WHITE: 2021 Non-Hispanic White below 100% Federal Poverty Level POV21_BLACK: 2021 Non-Hispanic African American below 100% Federal Poverty Level POV21_AIAN: 2021 Non-Hispanic American Indian or Alaska Native below 100% Federal Poverty Level POV21_ASIAN: 2021 Non-Hispanic Asian below 100% Federal Poverty Level POV21_HNPI: 2021 Non-Hispanic Hawaiian Native or Pacific Islander below 100% Federal Poverty Level POV21_HISPANIC: 2021 Hispanic below 100% Federal Poverty Level POV21_TOTAL: 2021 Total population below 100% Federal Poverty Level POP21_TOTAL: 2021 Total PopulationAREA_SQMIL: Area in square milePOP21_DENSITY: Population per square mile.POV21_PERCENT: Poverty percentage.How this data created?The tabular data of population by age groups, by ethnic groups and by gender, and the poverty by ethnic groups is attributed to the split tract geography to create this data. Split tract polygon data is created by intersecting 2020 census tract polygons, LA Country City Boundary polygons and Countywide Statistical Areas (CSA) polygon data. The resulting polygon boundary aligned and matched with the legal city boundary whenever possible. Note:1. Population and poverty data estimated as of July 1, 2021. 2. 2010 Census tract and 2020 census tracts are not the same. Similarly, city and community boundary are not the same because boundary is reviewed and updated annually.

The US Family Budget Dataset provides insights into the cost of living in different US counties based on the Family Budget Calculator by the Economic Policy Institute (EPI).

This dataset offers community-specific estimates for ten family types, including one or two adults with zero to four children, in all 1877 counties and metro areas across the United States.

Interesting Task Ideas:

1. See how family budgets compare to the federal poverty line and the Supplemental Poverty Measure in different counties.
2. Look into the money challenges faced by different types of families using the budgets provided.
3. Find out which counties have the most affordable places to live, food, transportation, healthcare, childcare, and other things people need.
4. Explore how the average income of families relates to the overall cost of living in different counties.
5. Investigate how family size affects the estimated budget and find counties where bigger families have higher costs.
6. Create visuals showing how the cost of living varies across different states and big cities.
7. Check whether specific counties are affordable for families of different sizes and types.
8. Use the dataset to compare living standards and economic security in different US counties.

If you find this dataset valuable, don't forget to hit the upvote button! 😊💝

Checkout my other datasets

Employment-to-Population Ratio for USA

Productivity and Hourly Compensation

130K Kindle Books

900K TMDb Movies

USA Unemployment Rates by Demographics & Race

Photo by Alev Takil on Unsplash

This table contains data on the percent of households paying more than 30% (or 50%) of monthly household income towards housing costs for California, its regions, counties, cities/towns, and census tracts. Data is from the U.S. Department of Housing and Urban Development (HUD), Consolidated Planning Comprehensive Housing Affordability Strategy (CHAS) and the U.S. Census Bureau, American Community Survey (ACS). The table is part of a series of indicators in the [Healthy Communities Data and Indicators Project of the Office of Health Equity] Affordable, quality housing is central to health, conferring protection from the environment and supporting family life. Housing costs—typically the largest, single expense in a family's budget—also impact decisions that affect health. As housing consumes larger proportions of household income, families have less income for nutrition, health care, transportation, education, etc. Severe cost burdens may induce poverty—which is associated with developmental and behavioral problems in children and accelerated cognitive and physical decline in adults. Low-income families and minority communities are disproportionately affected by the lack of affordable, quality housing. More information about the data table and a data dictionary can be found in the Attachments.

Table from the American Community Survey (ACS) B17001 poverty status of the population. These are multiple, nonoverlapping vintages of the 5-year ACS estimates of population and housing attributes starting in 2010 shown by the corresponding census tract vintage. Also includes the most recent release annually.King County, Washington census tracts with nonoverlapping vintages of the 5-year American Community Survey (ACS) estimates starting in 2010. Vintage identified in the "ACS Vintage" field.The census tract boundaries match the vintage of the ACS data (currently 2010 and 2020) so please note the geographic changes between the decades. Tracts have been coded as being within the City of Seattle as well as assigned to neighborhood groups called "Community Reporting Areas". These areas were created after the 2000 census to provide geographically consistent neighborhoods through time for reporting U.S. Census Bureau data. This is not an attempt to identify neighborhood boundaries as defined by neighborhoods themselves.Vintages: 2010, 2015, 2020, 2021, 2022, 2023ACS Table(s): <a href='https://data.census.gov/all?q=b17001' style='font-family:inherit;'

Tabular data of population by age groups, race and gender, and the poverty by race is attached to the split tract geography to create this split tract with population and poverty data. Split tract data is the product of 2020 census tracts split by 2022 incorporated city boundaries and unincorporated community/countywide statistical areas (CSA) boundaries. The census tract boundaries have been altered and aligned where necessary with legal city boundaries and unincorporated areas, including shoreline/coastal areas. Census Tract:Every 10 years the Census Bureau counts the population of the United States as mandated by Constitution. The Census Bureau (https://www.census.gov/) released 2020 geographic boundaries data including census tracts for the analysis and mapping of demographic information across the United States. City Boundary:City Boundary data is the base map information for the County of Los Angeles. These City Boundaries are based on the Los Angeles County Seamless Cadastral Landbase. The Landbase is jointly maintained by the Los Angeles County Assessor and the Los Angeles County Department of Public Works (DPW). This layer represents current city boundaries within Los Angeles County. The DPW provides the most current shapefiles representing city boundaries and city annexations. True, legal boundaries are only determined on the ground by surveyors licensed in the State of California.Countywide Statistical Areas (CSA): The countywide Statistical Area (CSA) was defined to provide a common geographic boundary for reporting departmental statistics for unincorporated areas and incorporated Los Angeles city to the Board of Supervisors. The CSA boundary and CSA names are established by the CIO and the LA County Enterprise GIS group worked with the Los Angeles County Board of Supervisors Unincorporated Area and Field Deputies that reflect as best as possible the general name preferences of residents and historical names of areas. This data is primarily focused on broad statistics and reporting, not mapping of communities. This data is not designed to perfectly represent communities, nor jurisdictional boundaries such as Angeles National Forest. CSA represent board approved geographies comprised of Census block groups split by cities.Data Field:CT20: 2020 Census tractFIP22: 2022 City FIP CodeCITY: City name for incorporated cities and “Unincorporated” for unincorporated areas (as of July 1, 2022) CSA: Countywide Statistical Area (CSA) - Unincorporated area community names and LA City neighborhood names.CT20FIP22CSA: 2020 census tract with 2022 city FIPs for incorporated cities and unincorporated areas and LA neighborhoods. SPA22: 2022 Service Planning Area (SPA) number.SPA_NAME: Service Planning Area name.HD22: 2022 Health District (HD) number: HD_NAME: Health District name.POP22_AGE_0_4: 2022 population 0 to 4 years oldPOP22_AGE_5_9: 2022 population 5 to 9 years old POP22_AGE_10_14: 2022 population 10 to 14 years old POP22_AGE_15_17: 2022 population 15 to 17 years old POP22_AGE_18_19: 2022 population 18 to 19 years old POP22_AGE_20_44: 2022 population 20 to 24 years old POP22_AGE_25_29: 2022 population 25 to 29 years old POP22_AGE_30_34: 2022 population 30 to 34 years old POP22_AGE_35_44: 2022 population 35 to 44 years old POP22_AGE_45_54: 2022 population 45 to 54 years old POP22_AGE_55_64: 2022 population 55 to 64 years old POP22_AGE_65_74: 2022 population 65 to 74 years old POP22_AGE_75_84: 2022 population 75 to 84 years old POP22_AGE_85_100: 2022 population 85 years and older POP22_WHITE: 2022 Non-Hispanic White POP22_BLACK: 2022 Non-Hispanic African AmericanPOP22_AIAN: 2022 Non-Hispanic American Indian or Alaska NativePOP22_ASIAN: 2022 Non-Hispanic Asian POP22_HNPI: 2022 Non-Hispanic Hawaiian Native or Pacific IslanderPOP22_HISPANIC: 2022 HispanicPOP22_MALE: 2022 Male POP22_FEMALE: 2022 Female POV22_WHITE: 2022 Non-Hispanic White below 100% Federal Poverty Level POV22_BLACK: 2022 Non-Hispanic African American below 100% Federal Poverty Level POV22_AIAN: 2022 Non-Hispanic American Indian or Alaska Native below 100% Federal Poverty Level POV22_ASIAN: 2022 Non-Hispanic Asian below 100% Federal Poverty Level POV22_HNPI: 2022 Non-Hispanic Hawaiian Native or Pacific Islander below 100% Federal Poverty Level POV22_HISPANIC: 2022 Hispanic below 100% Federal Poverty Level POV22_TOTAL: 2022 Total population below 100% Federal Poverty Level POP22_TOTAL: 2022 Total PopulationAREA_SQMil: Area in square mile.POP22_DENSITY: Population per square mile.POV22_PERCENT: Poverty rate/percentage.How this data created?The tabular data of population by age groups, by ethnic groups and by gender, and the poverty by ethnic groups is attributed to the split tract geography to create this data. Split tract polygon data is created by intersecting 2020 census tract polygons, LA Country City Boundary polygons and Countywide Statistical Areas (CSA) polygon data. The resulting polygon boundary aligned and matched with the legal city boundary whenever possible. Note:1. Population and poverty data estimated as of July 1, 2022. 2. 2010 Census tract and 2020 census tracts are not the same. Similarly, city and community boundary are not the same because boundary is reviewed and updated annually.

This map was updated in April of 2022. To see the archived version of this map, click here: https://nmcdc.maps.arcgis.com/home/item.html?id=2e4c4c4cafcc49db80837f32912e66a5#overviewThis map displays data from the Selected Economic Indicators (DP03) dataset from the 2020 American Community Survey 5-Yr Estimates, U.S. Census Bureau. Data is shown at the level of Census Tract and County levels. Small Areas are not on this map at this time (aggregation of Census Tracts developed by the New Mexico Department of Health). Measuring poverty is a topic of much current discussion. See the following links: A Different Way to Measure Poverty - https://www.sanders.senate.gov/imo/media/image/census.jpg"Few topics in American society have more myths and stereotypes surrounding them than poverty, misconceptions that distort both our politics and our domestic policy making."They include the notion that poverty affects a relatively small number of Americans, that the poor are impoverished for years at a time, that most of those in poverty live in inner cities, that too much welfare assistance is provided and that poverty is ultimately a result of not working hard enough. Although pervasive, each assumption is flat-out wrong." -Mark Rank, Professor of Social Welfare at Washington University: https://opinionator.blogs.nytimes.com/2013/11/02/poverty-in-america-is-mainstream/

Tabular data of population by age groups, race and gender, and the poverty by race is attached to the split tract geography to create this split tract with population and poverty data. Split tract data is the product of 2010 census tracts split by 2018 incorporated city boundaries and unincorporated community/countywide statistical areas (CSA) boundaries. The census tract boundaries have been altered and aligned where necessary with legal city boundaries and unincorporated areas, including shoreline/coastal areas. Census Tract:Every 10 years the Census Bureau counts the population of the United States as mandated by Constitution. The Census Bureau (https://www.census.gov/) released 2010 geographic boundaries data including census tracts for the analysis and mapping of demographic information across the United States. City Boundary:City Boundary data is the base map information for the County of Los Angeles. These City Boundaries are based on the Los Angeles County Seamless Cadastral Landbase. The Landbase is jointly maintained by the Los Angeles County Assessor and the Los Angeles County Department of Public Works (DPW). This layer represents current city boundaries within Los Angeles County. The DPW provides the most current shapefiles representing city boundaries and city annexations. True, legal boundaries are only determined on the ground by surveyors licensed in the State of California.Countywide Statistical Areas (CSA): The countywide Statistical Area (CSA) was defined to provide a common geographic boundary for reporting departmental statistics for unincorporated areas and incorporated Los Angeles city to the Board of Supervisors. The CSA boundary and CSA names are established by the CIO and the LA County Enterprise GIS group worked with the Los Angeles County Board of Supervisors Unincorporated Area and Field Deputies that reflect as best as possible the general name preferences of residents and historical names of areas. This data is primarily focused on broad statistics and reporting, not mapping of communities. This data is not designed to perfectly represent communities, nor jurisdictional boundaries such as Angeles National Forest. CSA represent board approved geographies comprised of Census block groups split by cities.Data Field:CT10: 2010 Census tractFIP18: 2018 City FIP CodeCITY: City name for incorporated cities and “Unincorporated” for unincorporated areas (as of July 1, 2018) CSA: Countywide Statistical Area (CSA) - Unincorporated area community names and LA City neighborhood names.CT10FIP18CSA: 2010 census tract with 2018 city FIPs for incorporated cities, unincorporated areas and LA neighborhoods. SPA12: 2012 Service Planning Area (SPA) number.SPA_NAME: Service Planning Area name.HD12: 2012 Health District (HD) number: HD_NAME: Health District name.POP18_AGE_0_4: 2018 population 0 to 4 years oldPOP18_AGE_5_9: 2018 population 5 to 9 years old POP18_AGE_10_14: 2018 population 10 to 14 years old POP18_AGE_15_17: 2018 population 15 to 17 years old POP18_AGE_18_19: 2018 population 18 to 19 years old POP18_AGE_20_44: 2018 population 20 to 24 years old POP18_AGE_25_29: 2018 population 25 to 29 years old POP18_AGE_30_34: 2018 population 30 to 34 years old POP18_AGE_35_44: 2018 population 35 to 44 years old POP18_AGE_45_54: 2018 population 45 to 54 years old POP18_AGE_55_64: 2018 population 55 to 64 years old POP18_AGE_65_74: 2018 population 65 to 74 years old POP18_AGE_75_84: 2018 population 75 to 84 years old POP18_AGE_85_100: 2018 population 85 years and older POP18_WHITE: 2018 Non-Hispanic White POP18_BLACK: 2018 Non-Hispanic African AmericanPOP18_AIAN: 2018 Non-Hispanic American Indian or Alaska NativePOP18_ASIAN: 2018 Non-Hispanic Asian POP18_HNPI: 2018 Non-Hispanic Hawaiian Native or Pacific IslanderPOP18_HISPANIC: 2018 HispanicPOP18_MALE: 2018 Male POP18_FEMALE: 2018 Female POV18_WHITE: 2018 Non-Hispanic White below 100% Federal Poverty Level POV18_BLACK: 2018 Non-Hispanic African American below 100% Federal Poverty Level POV18_AIAN: 2018 Non-Hispanic American Indian or Alaska Native below 100% Federal Poverty Level POV18_ASIAN: 2018 Non-Hispanic Asian below 100% Federal Poverty Level POV18_HNPI: 2018 Non-Hispanic Hawaiian Native or Pacific Islander below 100% Federal Poverty Level POV18_HISPANIC: 2018 Hispanic below 100% Federal Poverty Level POV18_TOTAL: 2018 Total population below 100% Federal Poverty Level POP18_TOTAL: 2018 Total PopulationAREA_SQMIL: Area in square milePOP18_DENSITY: Population per square mile.POV18_PERCENT: Poverty percentage.How this data created?The tabular data of population by age groups, by ethnic groups and by gender, and the poverty by ethnic groups is attributed to the split tract geography to create this data. Split tract polygon data is created by intersecting 2010 census tract polygons, LA Country City Boundary polygons and Countywide Statistical Areas (CSA) polygon data. The resulting polygon boundary aligned and matched with the legal city boundary whenever possible. Note:1. Population and poverty data estimated as of July 1, 2019. 2. 2010 Census tract and 2020 census tracts are not the same. Similarly, city and community boundary are not the same because boundary is reviewed and updated annually.

Tabular data of population by age groups, race and gender, and the poverty by race is attached to the split tract geography to create this split tract with population and poverty data. Split tract data is the product of 2010 census tracts split by 2016 incorporated city boundaries and unincorporated community/countywide statistical areas (CSA) boundaries. The census tract boundaries have been altered and aligned where necessary with legal city boundaries and unincorporated areas, including shoreline/coastal areas. Census Tract:Every 10 years the Census Bureau counts the population of the United States as mandated by Constitution. The Census Bureau (https://www.census.gov/) released 2010 geographic boundaries data including census tracts for the analysis and mapping of demographic information across the United States. City Boundary:City Boundary data is the base map information for the County of Los Angeles. These City Boundaries are based on the Los Angeles County Seamless Cadastral Landbase. The Landbase is jointly maintained by the Los Angeles County Assessor and the Los Angeles County Department of Public Works (DPW). This layer represents current city boundaries within Los Angeles County. The DPW provides the most current shapefiles representing city boundaries and city annexations. True, legal boundaries are only determined on the ground by surveyors licensed in the State of California.Countywide Statistical Areas (CSA): The countywide Statistical Area (CSA) was defined to provide a common geographic boundary for reporting departmental statistics for unincorporated areas and incorporated Los Angeles city to the Board of Supervisors. The CSA boundary and CSA names are established by the CIO and the LA County Enterprise GIS group worked with the Los Angeles County Board of Supervisors Unincorporated Area and Field Deputies that reflect as best as possible the general name preferences of residents and historical names of areas. This data is primarily focused on broad statistics and reporting, not mapping of communities. This data is not designed to perfectly represent communities, nor jurisdictional boundaries such as Angeles National Forest. CSA represent board approved geographies comprised of Census block groups split by cities.Data Field:CT10: 2010 Census tractFIP16: 2016 City FIP CodeCITY: City name for incorporated cities and “Unincorporated” for unincorporated areas (as of July 1, 2016) CSA: Countywide Statistical Area (CSA) - Unincorporated area community names and LA City neighborhood names.CT10FIP16CSA: 2010 census tract with 2016 city FIPs for incorporated cities, unincorporated areas and LA neighborhoods. SPA12: 2012 Service Planning Area (SPA) number.SPA_NAME: Service Planning Area name.HD12: 2012 Health District (HD) number: HD_NAME: Health District name.POP16_AGE_0_4: 2016 population 0 to 4 years oldPOP16_AGE_5_9: 2016 population 5 to 9 years old POP16_AGE_10_14: 2016 population 10 to 14 years old POP16_AGE_15_17: 2016 population 15 to 17 years old POP16_AGE_18_19: 2016 population 18 to 19 years old POP16_AGE_20_44: 2016 population 20 to 24 years old POP16_AGE_25_29: 2016 population 25 to 29 years old POP16_AGE_30_34: 2016 population 30 to 34 years old POP16_AGE_35_44: 2016 population 35 to 44 years old POP16_AGE_45_54: 2016 population 45 to 54 years old POP16_AGE_55_64: 2016 population 55 to 64 years old POP16_AGE_65_74: 2016 population 65 to 74 years old POP16_AGE_75_84: 2016 population 75 to 84 years old POP16_AGE_85_100: 2016 population 85 years and older POP16_WHITE: 2016 Non-Hispanic White POP16_BLACK: 2016 Non-Hispanic African AmericanPOP16_AIAN: 2016 Non-Hispanic American Indian or Alaska NativePOP16_ASIAN: 2016 Non-Hispanic Asian POP16_HNPI: 2016 Non-Hispanic Hawaiian Native or Pacific IslanderPOP16_HISPANIC: 2016 HispanicPOP16_MALE: 2016 Male POP16_FEMALE: 2016 Female POV16_WHITE: 2016 Non-Hispanic White below 100% Federal Poverty Level POV16_BLACK: 2016 Non-Hispanic African American below 100% Federal Poverty Level POV16_AIAN: 2016 Non-Hispanic American Indian or Alaska Native below 100% Federal Poverty Level POV16_ASIAN: 2016 Non-Hispanic Asian below 100% Federal Poverty Level POV16_HNPI: 2016 Non-Hispanic Hawaiian Native or Pacific Islander below 100% Federal Poverty Level POV16_HISPANIC: 2016 Hispanic below 100% Federal Poverty Level POV16_TOTAL: 2016 Total population below 100% Federal Poverty Level POP16_TOTAL: 2016 Total PopulationAREA_SQMIL: Area in square milePOP16_DENSITY: Population per square mile.POV16_PERCENT: Poverty rate/percentage.How this data created?The tabular data of population by age groups, by ethnic groups and by gender, and the poverty by ethnic groups is attributed to the split tract geography to create this data. Split tract polygon data is created by intersecting 2010 census tract polygons, LA Country City Boundary polygons and Countywide Statistical Areas (CSA) polygon data. The resulting polygon boundary aligned and matched with the legal city boundary whenever possible. Note:1. Population and poverty data estimated as of July 1, 2016. 2. 2010 Census tract and 2020 census tracts are not the same. Similarly, city and community boundary are not the same because boundary is reviewed and updated annually.

Context

This dataset contains the locations found in the Kiva datasets included in an administrative or geographical region. You can also find poverty data about this region. This facilitates answering some of the tough questions about a region's poverty.

Content

In the interest of preserving the original names and spelling for the locations/countries/regions all the data is in Excel format and has no preview (I think only the Kaggle recommended file types have preview - if anyone can show me how to do this for an xlsx file, it will be greatly appreciated)

The Tables datasets contain the most recent analysis of the MPI on countries and regions. These datasets are updated regularly. In unique regions_names_from_google_api you will find 3 levels of inclusion for every geocode provided in Kiva datasets. (village/town, administrative region, sub-national region - which can be administrative or geographical). These are the results from the Google API Geocoding process.

Files:

• all_kiva_loans.csv

Dropped multiple columns, kept all the rows from loans.csv with names, tags, descriptions and got a csv file of 390MB instead of 2.13 GB. Basically is a simplified version of loans.csv (originally included in the analysis by beluga)

• country_stats.csv

1. population source: https://en.wikipedia.org/wiki/List_of_countries_by_population_(United_Nations)
2. population_below_poverty_line: Percentage
3. hdi: Human Development Index
4. life_expectancy: Life expectancy at birth
5. expected_years_of_schooling: Expected years of schooling
6. mean_years_of_schooling: Mean years of schooling
7. gni: Gross national income (GNI) per capita This dataset was originally created by [beluga][1].

• all_loan_theme_merged_with_geo_mpi_regions.xlsx

This is the loan_themes_by_region left joined with Tables_5.3_Contribution_of_Deprivations. (all the original entries from loan_themes and only the entries that match from Tables_5; for the regions that lack MPI data, you will find Nan)

These are the columns in the database:

1. Partner ID
2. Field Partner
3. Name
4. sector
5. Loan Theme ID
6. Loan Theme Type
7. Country
8. forkiva
9. number
10. amount
11. geo
12. rural_pct
13. City
14. Administrative region
15. Sub-national region
16. ISO
17. World region
18. Population Share of the Region (%)
19. region MPI
20. Education (%)
21. Health (%)
22. Living standards (%)
23. Schooling (%)
24. Child school attendance (%)
25. Child Mortality (%)
26. Nutrition (%)
27. Electricity (%)
28. Improved sanitation (%)
29. Drinking water (%)
30. Floor (%)
31. Cooking fuel (%)
32. Asset ownership (%)

• mpi_on_regions.xlsx

Matched the loans in loan_themes_by_region with the regions that have info regarding MPI. This dataset brings together the amount invested in a region and the biggest problems the said region has to deal with. It is a join between the loan_themes_by_region provided by Kiva and Tables 5.3 Contribution_of_Deprivations.

It is a subset of the all_loan_theme_merged_with_geo_mpi_regions.xlsx, which contains only the entries that I could match with poverty decomposition data. It has the same columns.

• Tables_5_SubNational_Decomposition_MPI_2017-18.xlsx

Multidimensional poverty index decomposition for over 1000 regions part of 79 countries.

Table 5.3: Contribution of deprivations to the MPI, by sub-national regions
This table shows which dimensions and indicators contribute most to a region's MPI, which is useful for understanding the major source(s) of deprivation in a sub-national region.

Source: http://ophi.org.uk/multidimensional-poverty-index/global-mpi-2016/

• Tables_7_MPI_estimations_country_levels.xlsx

MPI decomposition for 120 countries.

Table 7 All Published MPI Results since 2010
The table presents an archive of all MPI estimations published over the past 5 years, together with MPI, H, A and censored headcount ratios. For comparisons over time please use Table 6, which is strictly harmonised. The full set of data tables for each year published (Column A), is found on the 'data tables' page under 'Archive'.

The data in this file is shown in interactive plots on Oxford Poverty and Human Development Initiative website. http://www.dataforall.org/dashboard/ophi/index.php/

• unique_regions_from_kiva_loan_themes.xlsx

These are all the regions corresponding to the geocodes found in Kiva's loan_themes_by_region. There are 718 unique entries, that you can join with any database from Kiva that has either a coordinates or region column.
Columns:

• geo: pair of Lat, Lon (from loan_themes_by_region)

• City: name of the city (has the most NaN's)

• Administrative region: first level of administrative inclusion for the city/location; (the equivalent of county for US)

• Sub-national region: second lev...

Table from the American Community Survey (ACS) B17010 poverty status of families by family type. These are multiple, nonoverlapping vintages of the 5-year ACS estimates of population and housing attributes starting in 2010 shown by the corresponding census tract vintage. Also includes the most recent release annually.King County, Washington census tracts with nonoverlapping vintages of the 5-year American Community Survey (ACS) estimates starting in 2010. Vintage identified in the "ACS Vintage" field.The census tract boundaries match the vintage of the ACS data (currently 2010 and 2020) so please note the geographic changes between the decades. Tracts have been coded as being within the City of Seattle as well as assigned to neighborhood groups called "Community Reporting Areas". These areas were created after the 2000 census to provide geographically consistent neighborhoods through time for reporting U.S. Census Bureau data. This is not an attempt to identify neighborhood boundaries as defined by neighborhoods themselves.Vintages: 2010, 2015, 2020, 2021, 2022, 2023ACS Table(s): <a href='https://data.census.gov/all?q=b17010' style='font-family:i