To estimate county of residence of Filipinx healthcare workers who died of COVID-19, we retrieved data from the Kanlungan website during the month of December 2020.22 In deciding who to include on the website, the AF3IRM team that established the Kanlungan website set two standards in data collection. First, the team found at least one source explicitly stating that the fallen healthcare worker was of Philippine ancestry; this was mostly media articles or obituaries sharing the life stories of the deceased. In a few cases, the confirmation came directly from the deceased healthcare worker's family member who submitted a tribute. Second, the team required a minimum of two sources to identify and announce fallen healthcare workers. We retrieved 86 US tributes from Kanlungan, but only 81 of them had information on county of residence. In total, 45 US counties with at least one reported tribute to a Filipinx healthcare worker who died of COVID-19 were identified for analysis and will hereafter be referred to as “Kanlungan counties.” Mortality data by county, race, and ethnicity came from the National Center for Health Statistics (NCHS).24 Updated weekly, this dataset is based on vital statistics data for use in conducting public health surveillance in near real time to provide provisional mortality estimates based on data received and processed by a specified cutoff date, before data are finalized and publicly released.25 We used the data released on December 30, 2020, which included provisional COVID-19 death counts from February 1, 2020 to December 26, 2020—during the height of the pandemic and prior to COVID-19 vaccines being available—for counties with at least 100 total COVID-19 deaths. During this time period, 501 counties (15.9% of the total 3,142 counties in all 50 states and Washington DC)26 met this criterion. Data on COVID-19 deaths were available for six major racial/ethnic groups: Non-Hispanic White, Non-Hispanic Black, Non-Hispanic Native Hawaiian or Other Pacific Islander, Non-Hispanic American Indian or Alaska Native, Non-Hispanic Asian (hereafter referred to as Asian American), and Hispanic. People with more than one race, and those with unknown race were included in the “Other” category. NCHS suppressed county-level data by race and ethnicity if death counts are less than 10. In total, 133 US counties reported COVID-19 mortality data for Asian Americans. These data were used to calculate the percentage of all COVID-19 decedents in the county who were Asian American. We used data from the 2018 American Community Survey (ACS) five-year estimates, downloaded from the Integrated Public Use Microdata Series (IPUMS) to create county-level population demographic variables.27 IPUMS is publicly available, and the database integrates samples using ACS data from 2000 to the present using a high degree of precision.27 We applied survey weights to calculate the following variables at the county-level: median age among Asian Americans, average income to poverty ratio among Asian Americans, the percentage of the county population that is Filipinx, and the percentage of healthcare workers in the county who are Filipinx. Healthcare workers encompassed all healthcare practitioners, technical occupations, and healthcare service occupations, including nurse practitioners, physicians, surgeons, dentists, physical therapists, home health aides, personal care aides, and other medical technicians and healthcare support workers. County-level data were available for 107 out of the 133 counties (80.5%) that had NCHS data on the distribution of COVID-19 deaths among Asian Americans, and 96 counties (72.2%) with Asian American healthcare workforce data. The ACS 2018 five-year estimates were also the source of county-level percentage of the Asian American population (alone or in combination) who are Filipinx.8 In addition, the ACS provided county-level population counts26 to calculate population density (people per 1,000 people per square mile), estimated by dividing the total population by the county area, then dividing by 1,000 people. The county area was calculated in ArcGIS 10.7.1 using the county boundary shapefile and projected to Albers equal area conic (for counties in the US contiguous states), Hawai’i Albers Equal Area Conic (for Hawai’i counties), and Alaska Albers Equal Area Conic (for Alaska counties).20

About this dataset

Context

The dataset presents a breakdown of households across various income brackets in Medical Lake, WA, 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 Medical Lake, WA 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 Medical Lake households based on income levels.

Key observations

• For Family Households: In Medical Lake, the majority of family households, representing 18.55%, earn $60,000 to $74,999, showcasing a substantial share of the community families falling within this income bracket. Conversely, the minority of family households, comprising 0.0%, have incomes falling $20,000 to $24,999, representing a smaller but still significant segment of the community.
• For Non-Family Households: In Medical Lake, the majority of non-family households, accounting for 19.88%, 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 0.0%, earn $20,000 to $24,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 Medical Lake, WA (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 Medical Lake, WA
• 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 Medical Lake, WA
• 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 Medical Lake, WA

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 Medical Lake median household income. You can refer the same here

This feature service contains data from the American Community Survey: 5-year Estimates Subject Tables for all census tracts within Gallatin County. The attributes come from the Selected Characteristics of Health Insurance Coverage in the United States table (S2701). Processing Notes:Data was downloaded from the U.S. Census Bureau and imported into FME to create an AGOL Feature Service. Each attribute has been given an abbreviated alias name derived from the American Community Survey (ACS) categorical descriptions. The Data Dictionary below includes all given ACS attribute name aliases. For example: Pct_Uninsured_EduB is the percent of the population that is without health insurance coverage, noninstitutionalized 26 years and over, with a Bachelor's degree or higherData DictionaryACS_EST_YR: American Community Survey 5-Year Estimate Subject Tables data yearGEO_ID: Census Bureau geographic identifierNAME: Specified geographyPct_Insured: Percent of the population with health insurance coveragePct_Uninsured: Percent of the population without health insurance coverageRace/Ethinicity:A: AsianAIAN: American Indian or Alaska NativeBAA: Black or African AmericanHL: Hispanic or LatinoNHPI: Native Hawaiian or other Pacific IslanderW: WhiteOther: Some other raceTwo: Two or more racesAnnual Income:IncUnder25k: Household income below $25,000Inc25kto50k:Household income from $25,000 to $49,999Inc50kto75k: Household income from $50,000 to $74,999Inc75kto100k: Household income from $75,000 to $99,999IncOver100k: Household income $100,000 and overEducational Attainment (Civilian noninstitutionalized population 26 years and over):EduB: Bachelor's degree or higherEduHS: High school graduate (includes equivalency)EduNHS: Less than high school graduateEduA: Some college or associate's degreeDownload Selected Characteristics of Health Insurance Coverage in the United States data for Gallatin County, MT. Additional LinksU.S. Census BureauU.S. Census Bureau American Community Survey (ACS)About the American Community Survey

About this dataset

Context

The dataset illustrates the median household income in Medical Lake, spanning the years from 2010 to 2023, with all figures adjusted to 2023 inflation-adjusted dollars. Based on the latest 2019-2023 5-Year Estimates from the American Community Survey, it displays how income varied over the last decade. The dataset can be utilized to gain insights into median household income trends and explore income variations.

Key observations:

From 2010 to 2023, the median household income for Medical Lake decreased by $6,114 (7.59%), as per the American Community Survey estimates. In comparison, median household income for the United States increased by $5,602 (7.68%) between 2010 and 2023.

Analyzing the trend in median household income between the years 2010 and 2023, spanning 13 annual cycles, we observed that median household income, when adjusted for 2023 inflation using the Consumer Price Index retroactive series (R-CPI-U-RS), experienced growth year by year for 6 years and declined for 7 years.

Content

When available, the data consists of estimates from the U.S. Census Bureau American Community Survey (ACS) 2019-2023 5-Year Estimates. All incomes have been adjusting for inflation and are presented in 2022-inflation-adjusted dollars.

Years for which data is available:

• 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 0223

Variables / Data Columns

• Year: This column presents the data year from 2010 to 2023
• Median Household Income: Median household income, in 2023 inflation-adjusted dollars for the specific year
• YOY Change($): Change in median household income between the current and the previous year, in 2023 inflation-adjusted dollars
• YOY Change(%): Percent change in median household income between current and the previous year

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 Medical Lake median household income. You can refer the same here

This feature service contains data from the American Community Survey: 5-year Estimates Subject Tables for City of Bozeman, MT. The attributes come from the Selected Characteristics of Health Insurance Coverage in the United States table (S2701). Processing Notes:Data was downloaded from the U.S. Census Bureau and imported into FME to create an AGOL Feature Service. Each attribute has been given an abbreviated alias name derived from the American Community Survey (ACS) categorical descriptions. The Data Dictionary below includes all given ACS attribute name aliases. For example: Pct_Uninsured_EduB is the percent of the population that is without health insurance coverage, noninstitutionalized 26 years and over, with a Bachelor's degree or higherData DictionaryACS_EST_YR: American Community Survey 5-Year Estimate Subject Tables data yearGEO_ID: Census Bureau geographic identifierNAME: Specified geographyPct_Insured: Percent of the population with health insurance coveragePct_Uninsured: Percent of the population without health insurance coverageRace/Ethinicity:A: AsianAIAN: American Indian or Alaska NativeBAA: Black or African AmericanHL: Hispanic or LatinoNHPI: Native Hawaiian or other Pacific IslanderW: WhiteOther: Some other raceTwo: Two or more racesAnnual Income:IncUnder25k: Household income below $25,000Inc25kto50k:Household income from $25,000 to $49,999Inc50kto75k: Household income from $50,000 to $74,999Inc75kto100k: Household income from $75,000 to $99,999IncOver100k: Household income $100,000 and overEducational Attainment (Civilian noninstitutionalized population 26 years and over):EduB: Bachelor's degree or higherEduHS: High school graduate (includes equivalency)EduNHS: Less than high school graduateEduA: Some college or associate's degreeDownload Selected Characteristics of Health Insurance Coverage in the United States data for Bozeman, MT. Additional LinksU.S. Census BureauU.S. Census Bureau American Community Survey (ACS)About the American Community Survey

ImportanceThe Affordable Care Act (ACA) has expanded access to health insurance for millions of Americans, but the impact of Medicaid expansion on healthcare delivery and utilization remains uncertain.ObjectiveTo determine the early impact of the Medicaid expansion component of ACA on hospital and ED utilization in California, a state that implemented the Medicaid expansion component of ACA and Florida, a state that did not.DesignAnalyze all ED encounters and hospitalizations in California and Florida from 2009 to 2014 and evaluate trends by payer and diagnostic category. Data were collected from State Inpatient Databases, State Emergency Department Databases and the California Office of Statewide Health Planning and Development.SettingHospital and ED encounters.ParticipantsPopulation-based study of California and Florida state residents.ExposureImplementation of Medicaid expansion component of ACA in California in 2014.Main outcomes or measuresChanges in ED visits and hospitalizations by payer, percentage of patients hospitalized after an ED encounter, top diagnostic categories for ED and hospital encounters.ResultsIn California, Medicaid ED visits increased 33% after Medicaid expansion implementation and self-pay visits decreased by 25% compared with a 5.7% increase in the rate of Medicaid patient ED visits and a 5.1% decrease in rate of self-pay patient visits in Florida. In addition, California experienced a 15.4% increase in Medicaid inpatient stays and a 25% decrease in self pay stays. Trends in the percentage of patients admitted to the hospital from the ED were notable; a 5.4% decrease in hospital admissions originating from the ED in California, and a 2.1% decrease in Florida from 2013 to 2014.Conclusions and relevanceWe observed a significant shift in payer for ED visits and hospitalizations after Medicaid expansion in California without a significant change in top diagnoses or overall rate of these ED visits and hospitalizations. There appears to be a shift in reimbursement burden from patients and hospitals to the government without a dramatic shift in patterns of ED or hospital utilization.

About this dataset

Context

The dataset illustrates the median household income in Medical Lake, spanning the years from 2010 to 2021, with all figures adjusted to 2022 inflation-adjusted dollars. Based on the latest 2017-2021 5-Year Estimates from the American Community Survey, it displays how income varied over the last decade. The dataset can be utilized to gain insights into median household income trends and explore income variations.

Key observations:

From 2010 to 2021, the median household income for Medical Lake increased by $5,696 (7.36%), as per the American Community Survey estimates. In comparison, median household income for the United States increased by $4,559 (6.51%) between 2010 and 2021.

Analyzing the trend in median household income between the years 2010 and 2021, spanning 11 annual cycles, we observed that median household income, when adjusted for 2022 inflation using the Consumer Price Index retroactive series (R-CPI-U-RS), experienced growth year by year for 6 years and declined for 5 years.

https://i.neilsberg.com/ch/medical-lake-wa-median-household-income-trend.jpeg" alt="Medical Lake, WA median household income trend (2010-2021, in 2022 inflation-adjusted dollars)">

Content

When available, the data consists of estimates from the U.S. Census Bureau American Community Survey (ACS) 2017-2021 5-Year Estimates. All incomes have been adjusting for inflation and are presented in 2022-inflation-adjusted dollars.

Years for which data is available:

• 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021

Variables / Data Columns

• Year: This column presents the data year from 2010 to 2021
• Median Household Income: Median household income, in 2022 inflation-adjusted dollars for the specific year
• YOY Change($): Change in median household income between the current and the previous year, in 2022 inflation-adjusted dollars
• YOY Change(%): Percent change in median household income between current and the previous year

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 Medical Lake median household income. You can refer the same here

This table contains data on the living wage and the percent of families with incomes below the living wage for California, its counties, regions and cities/towns. Living wage is the wage needed to cover basic family expenses (basic needs budget) plus all relevant taxes; it does not include publicly provided income or housing assistance. The percent of families below the living wage was calculated using data from the Living Wage Calculator and the U.S. Census Bureau, American Community Survey. The table is part of a series of indicators in the Healthy Communities Data and Indicators Project of the Office of Health Equity. The living wage is the wage or annual income that covers the cost of the bare necessities of life for a worker and his/her family. These necessities include housing, transportation, food, childcare, health care, and payment of taxes. Low income populations and non-white race/ethnic have disproportionately lower wages, poorer housing, and higher levels of food insecurity. More information about the data table and a data dictionary can be found in the About/Attachments section.