ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Sustaining Essential and Rural Community Healthcare (SEARCH)
2
3
Healthcare System and Access Data Workbook
4
Created June 2022; Finalized June 2023
5
6
7
8
General Population DemographicsPeriod Described Notes
9
Pop size2020 ACS Estimates
10
Race/ Ethnicity2020 ACS Estimates
11
Pop change by year/ decade2010 through 2050
12
Hispanic Population2010 through 2050Likely an undercount
13
Nativity and Citizenship Status2020 ACS EstimatesLikely an undercount
14
Age and Sex2020 ACS EstimatesRe: Gender Identity - The Census Bureau (currently) and NC OSBM doesn't have anything other than male and female as the choices for sex.
15
Hispanic population by age2020 ACS Estimates
16
Population Change by Age2010 through 2050
17
Birth rate2002-2006 through 2016-2020
18
Poverty2012 through 2020 ACS Estimates
19
Poverty Levels2020 ACS Estimates
20
Employment by Industry2020 ACS EstimatesOnly pulled Mitchell and Yancey
21
Households 2020 ACS EstimatesOnly pulled Mitchell and Yancey
22
Parents in the Workforce2020 ACS EstimatesOnly pulled Mitchell and Yancey
23
Households with no vehicle available2020 ACS EstimatesOnly pulled Mitchell and Yancey
24
Grandparents caring for grandchildren2020 ACS EstimatesOnly pulled Mitchell and Yancey
25
Income2012 through 2020 ACS Estimates
26
Health Insurance by Type2020 ACS Estimates
27
Uninsured2020 ACS EstimatesSmall Area Health Insurance Estimates added as it is modeled using ACS data + other data
28
Medicaid EligiblesSFY2017 through SFY2021
29
Disability Status2020 ACS Estimates
30
Disability status among ages 65 and older2020 ACS Estimates
31
Vacancy Status2020 ACS EstimatesThis is an attempt to get at Visitors. There might be some regional (Mountain area) tourism data at VisitNC but it focuses more on economic impact and behavior than it does on counts of people.
32
Educational Attainment2020 ACS EstimatesOnly pulled Mitchell and Yancey
33
34
General HealthPeriod DescribedNotes
35
Life Expectancy2016-2018 through 2018-2020Overall, male, female, white, black/ african american
36
Leading Causes of Death by Sex2016-2020
37
Satisfaction with life (self-report)2012, 2015, 2018, 2021Avery only avail for 2021
38
Poor days mental health2012, 2015, 2018, 2021Avery only avail for 2012 and 2021
39
County Health Rankings2021
40
Cancer Mortality2016-2020Lung, Breast, Prostate, Colorectal, Cervical, Melanoma
41
Opioid Dashboard Metrics
42
Older Adult Health Indicators (65+)2007-2011 through 2016-2020Alzheimer's mortality rates and number of unintentional falls deaths among those 65 and older
43
Healthy Impact Survey responses related to mental health and substance use2012, 2015, 2018, 2021
44
45
46
Access to Care - Self-ReportedPeriod DescribedNotes
47
Specific Source of Care (self-report)2015, 2018Avery not available
48
Unable to get Healthcare (self-report)2012, 2015, 2018, 2021Avery only avail for 2012, 2021
49
Unable to get mental health services (self-report)2012, 2015, 2018, 2021Avery only avail for 2012, 2021
50
Routine Checkup (self-report)2012, 2015, 2018Avery not available
51
Eye Exams (self-report)2015Avery not available
52
Dental Visits (self-report)2012, 2015, 2018Avery not available
53
Telemedicine (self-report)2021Avery not available
54
55
Provider/ Resource RelatedPeriod DescribedNotes
56
Health Professionals Ratios2015 through 2019
57
Health Professionals by Category2000 through 2020
58
Health Professionals over 652015 through 2019
59
Behavioral Health-releated providersvarious
60
NPI Registry of Addiction treatment providerscurrentOnly pulled Mitchell and Yancey
61
Medicaid Payments to Rendering Providers, 20202020Category of provider, count of providers, number of procedures/scripts, amount paid
62
Medicaid Payments to Rendering Providers, 20212021Same indicators as previous worksheet, just a different year. The data is so different from year to year it just doesn't line up in a tidy way for trend data.
63
NPI Registry Listings in Avery CountyAs of June 27, 2022You have to search by city, so the towns I used in the search are listed at the top each spreadsheet. The address listed in the spreadsheet is the Primary Practice Address, which might not be the town I searched for. The city searched for is likely a sedondary address, which you can view in the Provider's Information, which is also where you'll see additional Taxonomies. Click on the blue number to be taken to the individual's Provider Information. I added a filter so you can sort or search, especially within the Taxonomies column.
64
NPI Registry Listings in McDowell CountyAs of June 27, 2022
65
NPI Registry Listings in Mitchell CountyAs of June 27, 2022
66
NPI Registry Listings in Yancey CountyAs of June 27, 2022
67
Licensed Adult Care FacilitiesAs of August 2022Added links to inspection history from NC DHSR so they can see the star ratings and any deficiencies
68
Inspections/Investigations of Regulated Nursing Home FacilitiesAs of August 2022List of inspections or investigations conducted at licensed nursing homes and links to the documetation of what was investigated, any deficiencies found, and corrective actions required. This is to get at the quality control of facilities relevant to seniors in the SEARCH region.
69
Licensed Home Health and Hospice FacilitiesAs of August 2022
70
Licensed Mental Health FacilitiesAs of August 2022
71
Medicare Facility Ratings: Nursing HomesAs of August 2022Not sure where else to put this. But this site gives a basic run down of Medicare and how one qualifies and what the Parts are and what it costs: https://www.medicare.gov/basics/get-started-with-medicare/medicare-basics. You can enroll in Medicare if you have never worked or paid Social Security but would need to pay monthly premium for Part A. Part B costs regardless of work history.
72
Medicare Facility Ratings: HospitalsAs of August 2022No quality measures available for physicians/clinicians. Inpatient rehab facilities should have ratings but there are none in this region.
73
Medical Facilities InventoryVariousSelect data from the inventories and projections provided in the State Medical Facilities Plan.
74
75
Access to Care RelatedPeriod DescribedNotes
76
Prenatal Care in First Trimester2011 through 2019
77
Prenatal Care by Race2015 through 2019
78
Births to Medicaid and WIC Mothers2015 through 2019
79
Month Prental Care Began by Age of Mother2019 and 2020This is available by race but the numbers are small. Feel free to explore the source. Available for plenty of other years as well.
80
Teen Pregnancy Rates2016-2020 periodFor all counties and NC, sorted in descending order for perspective
81
Low Weight Births2008-2012 through 2016-2020
82
Induced Labor and Adequacy of Prenatal Care2015 through 2021
83
Condition of Newborn2015 through 2021
84
Birth Attendants and Location2018 and 2019
85
Cancer Projections2019 thorugh 2022
86
Health Department Utilization Data
87
FQHC data2016 thorugh 2020I input numbers because you're interested in measuring need. Percentages are also available at the source.
88
Mental Health Program UtilizationFY05-06 through FY19-20Avery not avail for all years presented. Nothing more recent available at this source.
89
Alcohol and Drug Treatment Center Utilization2006 through 2016Avery not avail for all years presented. Nothing more recent available at this source.
90
Psychiatric Hospital UtilizationFY05-06 through FY19-20Avery not avail for all years presented. Nothing more recent available at this source.
91
ED Discharge DataFY16 through FY20I've just pulled ED discharges; they have it for Inpatients and Outpatients but it's time consuming data to pull and ED seems like the best proxy for small practice/clinical data.
92
ED Visits by Month2018 through 2022
93
Hospital by Patient County of Residence (Inpatient)FY2019-2020This is not available for ED discharges. Available for other fiscal years.
94
Patient County of Residence by Hospital (Inpatient)FY2019-2020This is not available for ED discharges. Available for other fiscal years.
95
Top ED Disagnoistic CodesFY2019-2020There is so much data to transcribe here and it can't just be copied and pasted. So I'm providing screenshots of the data and hyperlinks to the source reports. It's available for other fiscal years as well.
96
Top Inpatient Diagnostic CodesFY2019-2020
97
Top Inpatient Major Diagnostic Category TotalsFY16 through FY20
98
Top Outpatient Procedure CodesFY2019-2020
99
Mental Health ED Visits2017 thorugh 2021New for the August update
100
Mental Health ED Visits by Insurance Coverage2017 thorugh 2021New for the August update