mhm_24_raw_data <- read_excel("/Users/nehadantuluri/Downloads/MHV2024.xlsx")
View(mhm_24_raw_data)# clean column names w/ janitor
# standardizes the column names by converting them to lowercase, replacing spaces with underscores, and removing any special characters.
mhm_24_raw_data_clean<-clean_names(mhm_24_raw_data)
colnames(mhm_24_raw_data_clean) [1] "id" "clinic_id"
[3] "title" "post_type"
[5] "status" "contact_phone_number"
[7] "website" "organization_type"
[9] "organization_type_other" "source_of_funding"
[11] "organization_collaboration_other" "clinic_street_address"
[13] "clinic_address_line_2" "clinic_city"
[15] "clinic_state" "clinic_zip"
[17] "clinic_country" "clinic_geolocation_address"
[19] "clinic_geolocation_lat" "clinic_geolocation_lng"
[21] "care_delivered" "community_type"
[23] "population_served" # view full dataset with cleaned column names
View(mhm_24_raw_data_clean)
# show first 6 rows & last 6 rows of data set
head(mhm_24_raw_data_clean)tail(mhm_24_raw_data_clean)# overview of data set
glimpse(mhm_24_raw_data_clean)Rows: 1,453
Columns: 23
$ id <dbl> 11436, 11437, 11440, 11441, 11442, 11443, 11…
$ clinic_id <dbl> 55289, 55230, 55175, 55173, 55145, 55143, 55…
$ title <chr> "Great Salt Plains Health Center- Mobile Med…
$ post_type <chr> "clinic", "clinic", "clinic", "clinic", "cli…
$ status <chr> "publish", "publish", "publish", "publish", …
$ contact_phone_number <chr> "5805962800", "3013075335", "8605481593", "5…
$ website <chr> "https://www.gsphealth.org", "https://www.re…
$ organization_type <chr> NA, NA, NA, NA, "Hospital System", "Health C…
$ organization_type_other <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, …
$ source_of_funding <chr> "Federal Government|Patients Self-Pay", "Ins…
$ organization_collaboration_other <chr> NA, NA, "Hospitals", NA, "community based or…
$ clinic_street_address <chr> "405 S. Oklahoma Avenue", "12410 Milestone C…
$ clinic_address_line_2 <chr> NA, "Ste 600", NA, NA, NA, NA, NA, "unit 503…
$ clinic_city <chr> "Cherokee", "Germantown", "Hartford", "Boynt…
$ clinic_state <chr> "Oklahoma", "Maryland", "Connecticut", "Flor…
$ clinic_zip <chr> "73728", "20871", "6105", "33472", "55415", …
$ clinic_country <chr> "United States", "United States", "United St…
$ clinic_geolocation_address <chr> "405 South Oklahoma Avenue, Cherokee, OK, US…
$ clinic_geolocation_lat <dbl> 36.75417, 39.20066, 41.76835, 26.52904, 44.9…
$ clinic_geolocation_lng <dbl> -98.35932, -77.26305, -72.69135, -80.18211, …
$ care_delivered <chr> "Asthma|Behavioral Health|Dental|Pediatrics|…
$ community_type <chr> "Rural", "Rural|Suburban", "Urban", "Rural|S…
$ population_served <chr> "Homeless/Unhoused|Low-income|Uninsured", "A…# characteristics of a specific variable
length(mhm_24_raw_data_clean$title) # 1453 data points of this[1] 1453class(mhm_24_raw_data_clean$title) # chr variable[1] "character"## UNIQUENESS OF DATA POINTS
# how many unique values for post_type?
unique(mhm_24_raw_data_clean$post_type) [1] "clinic" NA # how many unique values for status?
unique(mhm_24_raw_data_clean$status) [1] "publish" "draft" "0" # how many unique values for organization_type
unique(mhm_24_raw_data_clean$organization_type)
[1] NA
[2] "Hospital System"
[3] "Health Center"
[4] "Hospital System|University"
[5] "Other"
[6] "Health Center|Hospital System|Payer/Insurer"
[7] "University"
[8] "Health Center|University"
[9] "Health Center|Other"
[10] "Health Center|Hospital System|Payer/Insurer|University"
[11] "Health Center|Hospital System"
[12] "Hospital System|Payer/Insurer"
[13] "Health Center|Hospital System|University"
[14] "Hospital System|Other"
[15] "Health Center|Hospital System|Other"
[16] "Other|Other"
[17] "Health Center|Other|Other"
[18] "new_patients\"\":\"\"\"\"" # how many unique values for organization_type_other
unique(mhm_24_raw_data_clean$organization_type_other)
[1] NA
[2] "Public Health Clinic"
[3] "Health Department"
[4] "County Health Department"
[5] "Free & Charitable Clinic"
[6] "Free and Charitable Clinic"
[7] "community-based organization"
[8] "Student project innervention plan for TB"
[9] "Public Health"
[10] "Local Health Department"
[11] "Emergency Medicine Physician Group"
[12] "Government - County Health Department"
[13] "Government"
[14] "Health Center"
[15] "State Agency"
[16] "Local Public Health Department"
[17] "K-12 Education System, 0-3 EHDI Services"
[18] "cancer center"
[19] "Community Hospital"
[20] "Behavioral Health - mental health and substance abuse services"
[21] "Behavioral Health - Mental Health and Substance Abuse Services"
[22] "Faith-based"
[23] "Independent Non-Profit"
[24] "Hospital System"
[25] "Indendent for Profit Company"
[26] "University"
[27] "No Parent Organization"
[28] "Insurer"
[29] "Other"
[30] "Fieldset\"\":\"\"\"\""
[31] "School Based Health Center" # how many unique values for source_of_funding
unique(mhm_24_raw_data_clean$source_of_funding)
[1] "Federal Government|Patients Self-Pay"
[2] "Insurance|Patients Self-Pay|State Government"
[3] "Philanthropy"
[4] "State Government"
[5] "Federal Government|Insurance|Philanthropy|State Government|Other"
[6] "Federal Government|Insurance|Parent Organization|Patients Self-Pay"
[7] "Federal Government|Parent Organization|Philanthropy|State Government"
[8] "Federal Government|Insurance|Patients Self-Pay|Philanthropy|State Government"
[9] "Parent Organization|Philanthropy|Other"
[10] "Federal Government|Insurance|Patients Self-Pay"
[11] "Insurance|Patients Self-Pay|Philanthropy|Other"
[12] "Other"
[13] "Federal Government|Insurance|Patients Self-Pay|State Government|Other"
[14] "Federal Government|State Government"
[15] "Parent Organization|State Government"
[16] "Federal Government|Insurance|Patients Self-Pay|State Government"
[17] "Federal Government|Parent Organization|Philanthropy|State Government|Other"
[18] "Federal Government|Insurance|Philanthropy"
[19] "Insurance|Parent Organization|Patients Self-Pay|State Government"
[20] "Insurance|Philanthropy"
[21] "Philanthropy|Other"
[22] "Insurance|Parent Organization|Patients Self-Pay|Philanthropy|State Government"
[23] "Insurance|Parent Organization|Patients Self-Pay|Philanthropy"
[24] "Patients Self-Pay"
[25] "Federal Government|Philanthropy|State Government"
[26] "Parent Organization|Philanthropy"
[27] "Federal Government|Insurance|Parent Organization|Patients Self-Pay|Philanthropy|State Government"
[28] "Philanthropy|State Government"
[29] "Federal Government"
[30] "Federal Government|Insurance|State Government"
[31] "Federal Government|Insurance"
[32] "Insurance"
[33] "Federal Government|Patients Self-Pay|Philanthropy"
[34] "Federal Government|Patients Self-Pay|Philanthropy|State Government"
[35] "Parent Organization"
[36] "Patients Self-Pay|Philanthropy"
[37] "Insurance|Patients Self-Pay|Philanthropy"
[38] "Federal Government|Insurance|Other"
[39] "State Government|Other"
[40] "Insurance|Parent Organization|Patients Self-Pay"
[41] "Federal Government|Insurance|Patients Self-Pay|Philanthropy"
[42] "Insurance|Philanthropy|State Government"
[43] "Insurance|Parent Organization|Patients Self-Pay|State Government|Other"
[44] "Insurance|Philanthropy|Other"
[45] "Parent Organization|Patients Self-Pay|Philanthropy"
[46] "Insurance|Parent Organization"
[47] "Insurance|Parent Organization|Philanthropy|State Government"
[48] "Federal Government|Other"
[49] "Federal Government|Insurance|Parent Organization|Patients Self-Pay|Other"
[50] "Federal Government|Insurance|Patients Self-Pay|Other"
[51] "Insurance|Parent Organization|Philanthropy"
[52] "Insurance|Patients Self-Pay"
[53] "Federal Government|Insurance|Philanthropy|State Government"
[54] "Federal Government|Insurance|Patients Self-Pay|Philanthropy|State Government|Other"
[55] "Patients Self-Pay|Other"
[56] "Federal Government|Parent Organization|Patients Self-Pay|Philanthropy|State Government"
[57] "Federal Government|Parent Organization"
[58] "Federal Government|Insurance|Parent Organization|Patients Self-Pay|State Government|Other"
[59] "Federal Government|Parent Organization|Patients Self-Pay|State Government"
[60] "Federal Government|Insurance|Philanthropy|Other"
[61] "Insurance|Patients Self-Pay|Other"
[62] "Philanthropy|State Government|Other"
[63] "Federal Government|Parent Organization|Philanthropy|Other"
[64] "Insurance|Patients Self-Pay|Philanthropy|State Government"
[65] "Federal Government|Insurance|State Government|Other"
[66] "Federal Government|State Government|Other"
[67] "Federal Government|Parent Organization|Philanthropy"
[68] "Parent Organization|Other"
[69] "Parent Organization|Philanthropy|State Government"
[70] "Insurance|State Government|Other"
[71] "Federal Government|Parent Organization|Patients Self-Pay"
[72] NA
[73] "Federal Government|Parent Organization|State Government|Other"
[74] "Insurance|Patients Self-Pay|Philanthropy|State Government|Other"
[75] "Federal Government|Insurance|Parent Organization|Patients Self-Pay|State Government"
[76] "Federal Government|Patients Self-Pay|State Government"
[77] "Parent Organization|Patients Self-Pay|Other"
[78] "Federal Government|Insurance|Parent Organization|State Government"
[79] "Federal Government|Insurance|Parent Organization|Patients Self-Pay|Philanthropy|State Government|Other"
[80] "Insurance|Parent Organization|Philanthropy|Other"
[81] "Philanthropy|Parent Organization|Other|Federal Government|State Government"
[82] "Insurance|Parent Organization|Other"
[83] "Parent Organization|Patients Self-Pay|State Government|Other"
[84] "Insurance|Other"
[85] "Patients Self-Pay|Philanthropy|Other"
[86] "Federal Government|Insurance|Patients Self-Pay|Philanthropy|Other"
[87] "Federal Government|Parent Organization|State Government"
[88] "Insurance|State Government"
[89] "Parent Organization|Patients Self-Pay|Philanthropy|Other"
[90] "Parent Organization|Patients Self-Pay"
[91] "Federal Government|Patients Self-Pay|State Government|Other"
[92] "Federal Government|Philanthropy|Other"
[93] "Parent Organization|Philanthropy|State Government|Other"
[94] "Patients Self-Pay|Philanthropy|State Government"
[95] "Patients Self-Pay|State Government" # how many unique values for organization_collaboration_other
unique(mhm_24_raw_data_clean$organization_collaboration_other)
[1] NA
[2] "Hospitals"
[3] "community based organizations and Head Start centers"
[4] "Community Agencies"
[5] "Food pantries"
[6] "Home Health, long term care facilities, memory care and assisted living facilities, outpatient healthcare locations, prisons, state schools, schools,"
[7] "FQHCs, service organizations, community clinics, health systems, prisons"
[8] "Churches, Barber shops, Neighborhood groups"
[9] "Libraries, Churches, Senior Centers, Community Aid Partners"
[10] "FQHC's Health Systems, community based organizations and social service agencies"
[11] "FQHC's, Health Systems, community based organizations and social service agencies"
[12] "FQHC's, Community Based Organizations, Health Systems and Social Service Agencies"
[13] "FQHC's, Community based organizations, social service agencies"
[14] "free clinics, large hospital systems, and community based organizations"
[15] "Saint Joesph's Monastery"
[16] "Day Labor Centers, Food Banks"
[17] "Free Clinics, large hospital systems, community based organizations"
[18] "We aim to align with community partners to reduce health disparities by providing best practice, flexible, low-barrier health services to patients unable to access the healthcare system.."
[19] "Churches, social service organizations, etc."
[20] "Places of Worship, Food Pantries, Community Centers, Health Fairs"
[21] "Dental"
[22] "Daycares"
[23] "Community Outreach Programs"
[24] "Community Centers, Mohave Mobile Library, Chamber of Commerce, Outreach Center"
[25] "Health Centers"
[26] "SBL Clinics"
[27] "Community Foundations and Community non-profit organizations"
[28] "industries in sun safety and skin cancer diagnostics"
[29] "Community centers"
[30] "Community organizations"
[31] "community organizations"
[32] "Community-based Organizations/Nonprofits"
[33] "Community Organizations"
[34] "Low-income Housing, Churches, Food Pantries"
[35] "public libraries, food pantries, churches"
[36] "local industries"
[37] "Community Based Organizations"
[38] "Community Health Center"
[39] "Community Health Center, Hospital"
[40] "non-profit agencies"
[41] "Community Organizations, Food Pantries"
[42] "Primary Care"
[43] "Community-Based Organizations"
[44] "Communities"
[45] "Early Head Start Programs and other EI providers"
[46] "SUD Treatment facilities"
[47] "Foundations"
[48] "Other medical practices"
[49] "Agriculture Serving Organizations"
[50] "Local Public and County Libraries, Community Centers, and Summer Camps."
[51] "Military, Rural communities"
[52] "community-based organizations, state/local health departments, hospitals, community health centers, addiction treatment programs"
[53] "FQHC's"
[54] "FQHC, community providers, senior centers, prisons"
[55] "Behavioral Health"
[56] "Hospitals and urgent care facilities"
[57] "Community Centres, Residential Programming, University Research"
[58] "Health Equity Zones"
[59] "Early Intervention and Head Start Programs"
[60] "Other Non-Profit Organizations that help vulnerable communities"
[61] "Nursing homes, assisted-living’s, Tv/ film production sets"
[62] "Mobile Health Provider/Clinic"
[63] "Churches and Salvation Army - community partners; funding from DOH"
[64] "Local nonprofit organizations"
[65] "Longterm current Cincinnati Childrens patients"
[66] "Pediatric Primar Care clinic, local school"
[67] "Local primary pediatric offices"
[68] "all local not for profits"
[69] "Door to door"
[70] "libraries, community center, other health providers, other non-profits"
[71] "Churches, Sports Teams and Corporate Employers for Employee Wellness"
[72] "community health centers, residential complexes"
[73] "churches"
[74] "Non profits"
[75] "Churches, Community Organizations"
[76] "Dept. of Corrections"
[77] "International NGOs and Corporate Organizations"
[78] "non-profit organizations, churches, community events, and food panty"
[79] "n/a"
[80] "Veteran Stand Down"
[81] "community centers, head starts"
[82] "Non-Profit"
[83] "Churches"
[84] "Youth Organizations"
[85] "ReligiousReligious organizations and all medical providers"
[86] "Religious organizations, all medical providers,"
[87] "Non-profit organizations"
[88] "Migrant Communities, Churches, Homeless"
[89] "Worker's Center's, Community Centers"
[90] "Libraries, churches, senior citizen complexes, businesses, factory workers, health fairs, among others."
[91] "community-based organizations, churches, libraries."
[92] "Vision"
[93] "Mammography"
[94] "Preventive"
[95] "Churches, Civic Centers, Government"
[96] "healthcare agencies"
[97] "Other Specialties"
[98] "Pediatrics"
[99] "Community Based Organizations, Health Center, Cultural Organization,"
[100] "Area Healthcare Organizations"
[101] "Maternal and Infant Health"
[102] "Faith Communities, City Council"
[103] "Health Systems"
[104] "Preschools, Early Head Start/Head Start, Community Centers, Religious Organizations,"
[105] "Refugee organizations, Undocumented serving agencies"
[106] "Tribal Communities"
[107] "Community Based Partners, CCBHCs"
[108] "covid-19_vaccinations\"\":\"\"\"\""
[109] "Places of worship"
[110] "Foundations, public health agencies, private companies"
[111] "Food programs"
[112] "Hospitals, human services organizations"
[113] "County Neighborhood centers; City after school programs"
[114] "Fire departments"
[115] "community social services"
[116] "GENERAL COMMUNITY / PUBLIC"
[117] "community-based organizations and businesses" # how many unique values for clinic_country
unique(mhm_24_raw_data_clean$clinic_country)
[1] "United States" "Pakistan" "Bolivia" "Western Sahara"
[5] "Kenya" "Canada" "South Africa" "Jordan"
[9] "Ghana" "Tanzania" "Guam" "Nigeria"
[13] "Puerto Rico" NA "Finland" "Syria"
[17] "India" "Cameroon" "Lebanon" "Australia"
[21] "Ecuador" "Mexico" "Somalia" "Gambia"
[25] "Philippines" "Greece" "Uganda" "Barbados"
[29] "Spain" # how many unique values for care_delivered
unique(mhm_24_raw_data_clean$care_delivered)
[1] "Asthma|Behavioral Health|Dental|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health"
[2] "Other Specialties|Preventive"
[3] "Primary Care"
[4] "Dental|Pediatrics|Preventive|Primary Care|Vision"
[5] "Pediatrics|Preventive|Primary Care"
[6] "Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health"
[7] "Preventive"
[8] "Asthma"
[9] "Asthma|Behavioral Health|Maternal and Infant Health|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health"
[10] "Other Specialties|Pediatrics"
[11] "Other Specialties"
[12] "Asthma|Behavioral Health|Dental|Maternal and Infant Health|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health|Vision"
[13] "Other Specialties|Preventive|Sexual and Reproductive Health"
[14] "Behavioral Health|Dental|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health"
[15] "Behavioral Health|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health"
[16] "Maternal and Infant Health"
[17] "Maternal and Infant Health|Preventive"
[18] "Sexual and Reproductive Health"
[19] "Asthma|Behavioral Health|Other Specialties|Preventive|Primary Care|Sexual and Reproductive Health"
[20] "Dental|Other Specialties"
[21] "Behavioral Health|Pediatrics|Preventive"
[22] "Asthma|Behavioral Health|Maternal and Infant Health|Other Specialties|Preventive|Primary Care|Sexual and Reproductive Health"
[23] "Behavioral Health|Maternal and Infant Health|Preventive|Primary Care|Sexual and Reproductive Health"
[24] "Asthma|Mammography|Preventive"
[25] "Asthma|Behavioral Health|Maternal and Infant Health|Preventive|Primary Care|Sexual and Reproductive Health"
[26] "Asthma|Behavioral Health|Maternal and Infant Health|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health|Vision"
[27] "Behavioral Health|Preventive|Primary Care|Sexual and Reproductive Health|Vision"
[28] "Asthma|Mammography|Other Specialties|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health"
[29] "Asthma|Preventive|Primary Care"
[30] "Preventive|Primary Care"
[31] "Asthma|Pediatrics|Preventive|Primary Care"
[32] "Behavioral Health|Other Specialties|Preventive"
[33] "Behavioral Health|Dental|Maternal and Infant Health|Pediatrics|Preventive|Primary Care|Vision"
[34] "Behavioral Health|Dental|Other Specialties|Pediatrics|Preventive"
[35] "Asthma|Behavioral Health|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health"
[36] "Behavioral Health"
[37] "Asthma|Behavioral Health|Dental|Mammography|Maternal and Infant Health|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health|Vision"
[38] "Behavioral Health|Preventive|Primary Care"
[39] "Pediatrics|Sexual and Reproductive Health"
[40] "Preventive|Primary Care|Sexual and Reproductive Health"
[41] "Behavioral Health|Other Specialties|Primary Care"
[42] "Maternal and Infant Health|Primary Care"
[43] "Maternal and Infant Health|Preventive|Primary Care|Sexual and Reproductive Health"
[44] "Asthma|Behavioral Health|Dental|Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health|Vision"
[45] "Mammography"
[46] "Asthma|Behavioral Health|Dental|Other Specialties|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health"
[47] "Behavioral Health|Preventive|Primary Care|Sexual and Reproductive Health"
[48] "Asthma|Behavioral Health|Dental|Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care|Vision"
[49] "Behavioral Health|Maternal and Infant Health|Pediatrics|Primary Care|Sexual and Reproductive Health"
[50] "Behavioral Health|Dental|Pediatrics|Preventive|Primary Care|Vision"
[51] "Dental"
[52] "Dental|Pediatrics|Preventive|Primary Care"
[53] "Other Specialties|Preventive|Primary Care"
[54] "Behavioral Health|Dental|Preventive|Primary Care"
[55] "Vision"
[56] "Other Specialties|Primary Care"
[57] "Maternal and Infant Health|Preventive|Sexual and Reproductive Health"
[58] "Maternal and Infant Health|Pediatrics|Preventive|Primary Care"
[59] "Asthma|Dental|Pediatrics|Preventive|Primary Care"
[60] "Preventive|Sexual and Reproductive Health"
[61] "Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health"
[62] "Asthma|Behavioral Health|Mammography|Preventive|Primary Care|Sexual and Reproductive Health"
[63] "Behavioral Health|Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health|Vision"
[64] "Other Specialties|Vision"
[65] "Dental|Pediatrics|Primary Care|Sexual and Reproductive Health"
[66] "Maternal and Infant Health|Other Specialties|Pediatrics|Vision"
[67] "Asthma|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health"
[68] "Asthma|Behavioral Health|Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health"
[69] "Behavioral Health|Other Specialties|Pediatrics|Preventive|Primary Care|Vision"
[70] "Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care"
[71] "Asthma|Behavioral Health|Other Specialties|Preventive|Primary Care"
[72] "Asthma|Behavioral Health|Dental|Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health"
[73] "Other Specialties|Preventive|Primary Care|Sexual and Reproductive Health"
[74] "Other Specialties|Pediatrics|Preventive|Primary Care"
[75] "Behavioral Health|Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Sexual and Reproductive Health"
[76] "Pediatrics"
[77] "Asthma|Mammography"
[78] "Asthma|Dental|Mammography|Pediatrics|Preventive"
[79] "Asthma|Dental|Mammography|Other Specialties|Preventive|Primary Care|Sexual and Reproductive Health|Vision"
[80] "Asthma|Pediatrics"
[81] "Pediatrics|Vision"
[82] "Behavioral Health|Dental|Preventive|Primary Care|Sexual and Reproductive Health"
[83] "Mammography|Other Specialties"
[84] "Other Specialties|Pediatrics|Preventive|Primary Care|Vision"
[85] "Maternal and Infant Health|Pediatrics|Preventive|Primary Care|Vision"
[86] "Asthma|Preventive|Primary Care|Sexual and Reproductive Health"
[87] "Dental|Vision"
[88] "Behavioral Health|Dental|Maternal and Infant Health|Other Specialties|Pediatrics"
[89] "Behavioral Health|Other Specialties|Pediatrics|Primary Care|Sexual and Reproductive Health|Vision"
[90] "Dental|Preventive|Primary Care"
[91] "Behavioral Health|Preventive|Primary Care|Vision"
[92] "Asthma|Maternal and Infant Health|Pediatrics|Preventive|Primary Care|Vision"
[93] "Dental|Other Specialties|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health"
[94] "Behavioral Health|Other Specialties"
[95] "Asthma|Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health"
[96] "Behavioral Health|Other Specialties|Preventive|Sexual and Reproductive Health"
[97] "Behavioral Health|Maternal and Infant Health|Preventive|Sexual and Reproductive Health"
[98] "Asthma|Behavioral Health|Dental|Mammography|Maternal and Infant Health|Pediatrics|Primary Care|Vision"
[99] "Asthma|Behavioral Health|Mammography|Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care"
[100] "Asthma|Behavioral Health|Dental|Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care"
[101] NA
[102] "Asthma|Behavioral Health|Pediatrics|Preventive|Primary Care"
[103] "Other Specialties|Preventive|Primary Care|Vision"
[104] "Behavioral Health|Dental|Other Specialties|Preventive"
[105] "Mammography|Preventive|Primary Care"
[106] "Asthma|Behavioral Health|Primary Care"
[107] "Dental|Preventive"
[108] "Asthma|Behavioral Health|Maternal and Infant Health|Pediatrics|Preventive|Primary Care"
[109] "Pediatrics|Primary Care"
[110] "Maternal and Infant Health|Pediatrics|Primary Care"
[111] "Behavioral Health|Primary Care|Vision"
[112] "Behavioral Health|Maternal and Infant Health|Preventive|Primary Care"
[113] "Behavioral Health|Other Specialties|Preventive|Primary Care"
[114] "Asthma|Behavioral Health|Dental|Other Specialties|Pediatrics|Preventive|Primary Care"
[115] "Mammography|Other Specialties|Preventive"
[116] "Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care|Vision"
[117] "Dental|Maternal and Infant Health|Pediatrics"
[118] "Other Specialties|Pediatrics|Primary Care"
[119] "Asthma|Preventive"
[120] "Asthma|Behavioral Health|Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Vision"
[121] "Asthma|Behavioral Health|Dental|Maternal and Infant Health|Pediatrics|Preventive|Primary Care"
[122] "Asthma|Dental|Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care|Vision"
[123] "Dental|Maternal and Infant Health|Pediatrics|Preventive|Primary Care|Vision"
[124] "Dental|Pediatrics"
[125] "Asthma|Dental|Maternal and Infant Health|Pediatrics|Preventive|Primary Care"
[126] "Maternal and Infant Health|Other Specialties"
[127] "Behavioral Health|Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care"
[128] "Asthma|Behavioral Health|Mammography|Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care|Vision"
[129] "Asthma|Behavioral Health|Dental|Mammography|Maternal and Infant Health"
[130] "Asthma|Maternal and Infant Health|Pediatrics|Preventive|Primary Care"
[131] "Asthma|Other Specialties|Primary Care"
[132] "Asthma|Behavioral Health|Dental|Mammography|Maternal and Infant Health|Pediatrics|Preventive|Primary Care"
[133] "Dental|Pediatrics|Primary Care|Vision"
[134] "Asthma|Behavioral Health|Dental|Pediatrics|Preventive|Primary Care|Vision"
[135] "Pediatrics|Preventive"
[136] "Behavioral Health|Primary Care"
[137] "Mammography|Preventive"
[138] "Behavioral Health|Maternal and Infant Health|Other Specialties|Preventive|Primary Care"
[139] "Dental|Primary Care"
[140] "Asthma|Other Specialties|Preventive|Primary Care"
[141] "Asthma|Behavioral Health|Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care|Vision"
[142] "Asthma|Behavioral Health|Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care"
[143] "Asthma|Behavioral Health|Mammography|Other Specialties|Preventive|Primary Care|Vision"
[144] "Asthma|Behavioral Health|Dental|Mammography|Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care|Vision"
[145] "Dental|Other Specialties|Pediatrics|Preventive|Vision"
[146] "Behavioral Health|Dental|Maternal and Infant Health|Pediatrics|Preventive|Primary Care"
[147] "Asthma|Behavioral Health|Dental|Maternal and Infant Health|Pediatrics|Preventive|Primary Care|Vision"
[148] "Asthma|Behavioral Health|Mammography|Other Specialties|Preventive|Primary Care"
[149] "Maternal and Infant Health|Preventive|Primary Care"
[150] "Dental|Maternal and Infant Health|Preventive|Primary Care"
[151] "Mammography|Pediatrics|Preventive|Primary Care|Vision"
[152] "Dental|Preventive|Vision"
[153] "Maternal and Infant Health|Sexual and Reproductive Health"
[154] "Behavioral Health|Dental|Maternal and Infant Health|Preventive|Primary Care"
[155] "Dental|Other Specialties|Preventive|Primary Care"
[156] "Maternal and Infant Health|Other Specialties|Pediatrics"
[157] "Asthma|Other Specialties|Pediatrics|Preventive|Primary Care"
[158] "Asthma|Behavioral Health|Maternal and Infant Health|Preventive|Primary Care|Vision"
[159] "Pediatrics|Preventive|Vision"
[160] "Mammography|Primary Care"
[161] "Dental|Maternal and Infant Health|Preventive|Primary Care|Vision"
[162] "Preventive|Vision"
[163] "Dental|Maternal and Infant Health|Pediatrics|Preventive|Primary Care"
[164] "Dental|Mammography|Other Specialties|Preventive|Primary Care"
[165] "Asthma|Behavioral Health|Dental|Maternal and Infant Health|Preventive|Primary Care"
[166] "Behavioral Health|Dental|Pediatrics|Preventive|Primary Care"
[167] "Dental|Other Specialties|Primary Care"
[168] "Asthma|Behavioral Health|Dental|Preventive"
[169] "Asthma|Behavioral Health|Mammography|Other Specialties|Pediatrics|Primary Care"
[170] "Behavioral Health|Dental|Primary Care"
[171] "Dental|Mammography|Maternal and Infant Health|Other Specialties|Primary Care"
[172] "Dental|Maternal and Infant Health|Pediatrics|Primary Care"
[173] "Behavioral Health|Preventive"
[174] "Dental|Other Specialties|Vision"
[175] "Dental|Pediatrics|Preventive"
[176] "Dental|Mammography"
[177] "Asthma|Pediatrics|Preventive"
[178] "Dental|Mammography|Pediatrics|Preventive|Primary Care"
[179] "Asthma|Pediatrics|Primary Care"
[180] "Asthma|Dental|Maternal and Infant Health|Primary Care"
[181] "Dental|Maternal and Infant Health|Pediatrics|Preventive"
[182] "Dental|Mammography|Maternal and Infant Health|Pediatrics|Preventive|Primary Care"
[183] "Asthma|Behavioral Health|Dental|Pediatrics|Preventive|Primary Care"
[184] "Asthma|Dental|Maternal and Infant Health|Pediatrics|Preventive|Primary Care|Vision"
[185] "Asthma|Behavioral Health|Dental|Mammography|Pediatrics|Preventive|Primary Care|Vision"
[186] "Asthma|Dental|Pediatrics|Preventive|Vision"
[187] "Dental|Preventive|Primary Care|Vision"
[188] "Behavioral Health|Dental|Mammography|Maternal and Infant Health|Preventive|Primary Care|Vision"
[189] "Behavioral Health|Dental|Maternal and Infant Health|Preventive|Primary Care|Vision"
[190] "Maternal and Infant Health|Other Specialties|Primary Care"
[191] "Maternal and Infant Health|Primary Care|Vision"
[192] "Primary Care|Vision"
[193] "Asthma|Primary Care"
[194] "Mammography|Pediatrics|Preventive"
[195] "Behavioral Health|Dental|Other Specialties|Preventive|Primary Care"
[196] "Mammography|Maternal and Infant Health|Primary Care"
[197] "Asthma|Behavioral Health|Dental|Maternal and Infant Health|Other Specialties|Preventive|Primary Care"
[198] "Dental|Mammography|Primary Care"
[199] "Dental|Primary Care|Vision"
[200] "Behavioral Health|Dental|Mammography|Other Specialties|Primary Care"
[201] "Preventive|Primary Care|Vision"
[202] "Asthma|Behavioral Health|Dental|Mammography|Maternal and Infant Health|Other Specialties|Preventive|Primary Care|Sexual and Reproductive Health|Vision"
[203] "Asthma|Maternal and Infant Health|Pediatrics|Primary Care|Sexual and Reproductive Health"
[204] "Asthma|Behavioral Health|Dental|Mammography|Preventive|Primary Care|Sexual and Reproductive Health|Vision"
[205] "Asthma|Behavioral Health|Dental|Mammography|Other Specialties|Preventive|Primary Care|Sexual and Reproductive Health|Vision"
[206] "Asthma|Behavioral Health|Dental|Mammography|Maternal and Infant Health|Other Specialties|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health|Vision"
[207] "Asthma|Behavioral Health|Dental|Preventive|Primary Care|Vision"
[208] "Asthma|Dental|Pediatrics|Preventive|Primary Care|Sexual and Reproductive Health|Vision"
[209] "Asthma|Maternal and Infant Health|Preventive|Primary Care"
[210] "Maternal and Infant Health|Other Specialties|Preventive|Primary Care" # how many unique values for community_type
unique(mhm_24_raw_data_clean$community_type)
[1] "Rural" "Rural|Suburban"
[3] "Urban" "Suburban|Urban"
[5] "Rural|Urban" "Rural|Suburban|Urban"
[7] "Suburban" NA
[9] "Frontier|Rural|Suburban|Urban" "Other"
[11] "Frontier|Rural|Suburban" # how many unique values for population_served
unique(mhm_24_raw_data_clean$population_served) [1] "Homeless/Unhoused|Low-income|Uninsured"
[2] "Agricultural Workers|Homeless/Unhoused|Immigrants|LGBTQ+|Low-income|Students|Veterans"
[3] "Uninsured"
[4] "Homeless/Unhoused|Immigrants|Low-income|Students|Uninsured"
[5] "Immigrants|LGBTQ+|Low-income|Students|Uninsured"
[6] "Agricultural Workers|Immigrants|Low-income"
[7] "Immigrants|Low-income|Students|Uninsured"
[8] "Homeless/Unhoused|Immigrants|LGBTQ+|Low-income|Students|Uninsured|Veterans"
[9] "Low-income|Other"
[10] "Other|Veterans"
[11] "Agricultural Workers|Homeless/Unhoused|Immigrants|LGBTQ+|Low-income|Other|Students|Uninsured|Veterans"
[12] "Low-income|Other|Uninsured"
[13] "Agricultural Workers|Homeless/Unhoused|Immigrants|LGBTQ+|Low-income|Students|Uninsured|Veterans"
[14] "Homeless/Unhoused|Immigrants|LGBTQ+|Low-income|Students|Uninsured"
[15] "Agricultural Workers|Homeless/Unhoused|Immigrants|Low-income|Students|Uninsured"
[16] "Homeless/Unhoused|LGBTQ+|Low-income|Students|Uninsured"
[17] "Homeless/Unhoused|LGBTQ+|Low-income|Uninsured|Veterans"
[18] "Agricultural Workers|Homeless/Unhoused|Immigrants|LGBTQ+|Low-income|Uninsured|Veterans"
[19] "Low-income|Students|Uninsured"
[20] "Homeless/Unhoused|Immigrants|LGBTQ+|Low-income|Other|Uninsured|Veterans"
[21] "Homeless/Unhoused|Immigrants|LGBTQ+|Low-income|Other|Students|Uninsured|Veterans"
[22] "Other"
[23] "Homeless/Unhoused|Low-income|Uninsured|Veterans"
[24] "Homeless/Unhoused|Immigrants|LGBTQ+|Low-income|Uninsured|Veterans"
[25] "Homeless/Unhoused|LGBTQ+|Low-income|Students|Uninsured|Veterans"
[26] "Low-income"
[27] "Immigrants|Students|Uninsured"
[28] "Homeless/Unhoused|LGBTQ+|Low-income|Uninsured"
[29] "Agricultural Workers|Homeless/Unhoused|Immigrants|Low-income|Other|Uninsured"
[30] "Low-income|Students"
[31] "Homeless/Unhoused|Immigrants|LGBTQ+|Low-income|Uninsured"
[32] "Agricultural Workers|Homeless/Unhoused|Immigrants|LGBTQ+|Low-income|Other|Uninsured"
[33] "Immigrants|Low-income|Uninsured"
[34] "Other|Uninsured"
[35] "Homeless/Unhoused|Immigrants|Low-income|Uninsured"
[36] "Homeless/Unhoused|Low-income|Students|Uninsured|Veterans"
[37] "Low-income|Other|Students|Uninsured"
[38] "Low-income|Uninsured|Veterans"
[39] "Homeless/Unhoused|Low-income|Other|Students|Uninsured|Veterans"
[40] "Agricultural Workers|Immigrants|Low-income|Uninsured"
[41] "Students"
[42] "Homeless/Unhoused|Low-income"
[43] "Homeless/Unhoused"
[44] "Agricultural Workers|Homeless/Unhoused|Immigrants|LGBTQ+|Low-income|Uninsured"
[45] "Agricultural Workers|Immigrants|Low-income|Students"
[46] "Homeless/Unhoused|LGBTQ+|Low-income|Veterans"
[47] "Agricultural Workers|Homeless/Unhoused|Low-income|Uninsured|Veterans"
[48] "Agricultural Workers|Homeless/Unhoused|Immigrants|Low-income|Students|Uninsured|Veterans"
[49] "Agricultural Workers|Homeless/Unhoused|Immigrants|LGBTQ+|Low-income|Other|Students|Uninsured"
[50] "Low-income|Uninsured"
[51] "Agricultural Workers|Low-income|Students"
[52] "Agricultural Workers|Immigrants|LGBTQ+|Low-income|Other|Students|Uninsured|Veterans"
[53] "Agricultural Workers|LGBTQ+|Low-income|Other|Students|Uninsured|Veterans"
[54] "Immigrants|LGBTQ+|Low-income|Other|Students"
[55] "Homeless/Unhoused|LGBTQ+|Low-income|Other|Students|Uninsured"
[56] "Agricultural Workers|Homeless/Unhoused|Immigrants|Low-income|Uninsured"
[57] "Agricultural Workers|Immigrants|LGBTQ+|Low-income|Students|Veterans"
[58] "Agricultural Workers|Low-income|Uninsured"
[59] "Homeless/Unhoused|Immigrants|Low-income|Other|Students|Uninsured|Veterans"
[60] "Agricultural Workers|Homeless/Unhoused|Immigrants|LGBTQ+|Low-income|Other|Students|Veterans"
[61] "Homeless/Unhoused|Low-income|Students|Uninsured"
[62] "Homeless/Unhoused|Low-income|Other|Uninsured|Veterans"
[63] "LGBTQ+|Low-income|Other|Uninsured"
[64] "LGBTQ+|Students|Uninsured"
[65] "Immigrants|Low-income|Students|Uninsured|Veterans"
[66] "LGBTQ+|Low-income|Students|Uninsured|Veterans"
[67] "Agricultural Workers|Students|Veterans"
[68] "Agricultural Workers|Other"
[69] "Immigrants|LGBTQ+|Low-income|Other|Students|Uninsured"
[70] "Homeless/Unhoused|Immigrants|Low-income|Students|Uninsured|Veterans"
[71] "Other|Students"
[72] "Immigrants"
[73] "Immigrants|Low-income"
[74] "LGBTQ+|Low-income|Veterans"
[75] "Immigrants|Low-income|Students"
[76] "Homeless/Unhoused|Immigrants|LGBTQ+|Low-income"
[77] "Homeless/Unhoused|Low-income|Other|Uninsured"
[78] "Homeless/Unhoused|Immigrants|Low-income|Other|Students|Uninsured"
[79] "LGBTQ+|Low-income|Students|Veterans"
[80] "Homeless/Unhoused|LGBTQ+|Low-income|Other|Students|Uninsured|Veterans"
[81] "Agricultural Workers|Homeless/Unhoused|Immigrants|LGBTQ+|Low-income|Students|Uninsured"
[82] "Agricultural Workers|Low-income|Students|Veterans"
[83] "Homeless/Unhoused|Immigrants|LGBTQ+|Low-income|Other|Students"
[84] NA
[85] "Agricultural Workers|Immigrants|LGBTQ+|Low-income|Uninsured|Veterans"
[86] "Homeless/Unhoused|Low-income|Veterans"
[87] "Homeless/Unhoused|Uninsured"
[88] "Low-income|Veterans"
[89] "Immigrants|LGBTQ+|Low-income|Other|Uninsured|Veterans"
[90] "LGBTQ+|Low-income|Uninsured"
[91] "Veterans"
[92] "LGBTQ+|Uninsured"
[93] "Homeless/Unhoused|LGBTQ+|Low-income"
[94] "LGBTQ+|Low-income|Uninsured|Veterans"
[95] "Uninsured|Veterans"
[96] "LGBTQ+"
[97] "Agricultural Workers|Low-income|Other|Students|Uninsured"
[98] "LGBTQ+|Other|Students|Uninsured"
[99] "Homeless/Unhoused|Immigrants|Low-income|Uninsured|Veterans"
[100] "Agricultural Workers"
# Note: did not look at the unique variables for "id", "clinic_id", "title", "contact_phone_number", "website", "clinic_street_address", "clinic_address_line_2", "clinic_city", "clinic_state", "clinic_zip", "clinic_geolocation_address", "clinic_geolocation_lat", & "clinic_geolocation_lng"
# this is because each clinic has a unique & specific value of each of the above variables. Even if some values (i.e: clinic_state, clinic_city, etc.) may be the same, it accounts for unique aspects of each row and is not largely categorically grouped like care_delivered, community_type, population_served_etc.