Table 1.

Codebook list of codes and descriptions or examples.

Levela			Code name	Code description and/or examples
1			Coordinator characteristics	Characteristics or experiences shared by the coordinator about themselves
	1a		Health equity practical knowledge/experience/skills	(Ex) Experience as CPWI coordinator (Ex) Experience as a public health worker or coordinator in another position (Ex) Whether they applied the terms (“What do these mean to you: health equity, health disparity, social determinants of health”) to practical work or examples; code their answer overall as well.
	1b		Positionality	(Ex) Acknowledging race/ethnicity, multilingual or not, previous personal experience as it relates to work (e.g., one coordinator shared being intentional about pronoun use because of a military background)
	1c		Barriers (Coordinator)	Examples/times a coordinator characteristic or experience was clearly discussed as a barrier. (Ex) When coordinators have to translate materials and they aren’t multilingual. (Ex) Coordinators sharing feelings of burnout/stretched out or doing more than the position requires.
	1d		Facilitators (Coordinator)	Examples/times a coordinator characteristic or experience was clearly discussed as a facilitator. (Ex) A coordinator being new--that itself could be neutral, but if discussed as an opportunity to build new relationships that have helped it’s a facilitator. (Ex) A coordinator having experience as an “other/outsider” helping them be intentional about creating space in coalition work. (Ex) Coordinators demonstrating/applying their skills and experience to facilitate an aspect of CPWI work (e.g., educating partners facilitates engagement; framing conversations/discussions to engage community members) (Ex) Coordinators advocating for something beneficial to their community (Lots of “I” statements used)
2			Coalition	Umbrella code for logistics, administration, and functioning of CPWI coalitions
	2a		Requirements	Related to CPWI coalition requirements and planning for membership and functioning. Also code examples/factors/descriptions that are neutral--not clearly a barrier or facilitator--either here or as “unsure” for discussion.
		2a.i	Barriers (Requirements)	(Ex) Lack of data on specific subgroups “hiding” inequities and impacts (e.g., LGBTQIA+ youth in small communities) [relates to HYS and other data from DBHR that communities are expected to use] (Ex) Issues collecting data DBHR requests or requires (e.g., collecting personal information as a deterring participation; difficulties administering surveys to groups) (Ex) Strategic plan - lacking guidance on creating plans; lacking guidance using/applying plans
		2a.ii	Facilitators (Requirements)	(Ex) Coordinators and/or coalition members working within or adapting CPWI requirements to improve program delivery and/or community engagement.
	2b		Programs/Materials	Excerpts related to program implementation and adaptation (e.g., adapting delivery or translating materials). Also pertains to related materials not specific to a program (e.g., informational or promotional material).
		2b.i	Barriers (Program/Materials)	(Ex) Issues translating and/or disseminating program and/or other materials - information about community resources; radio and internet PSAs; awareness raising/promotional materials (Ex) Lacking enough information/data to implement a program/implement well.
		2b.ii	Facilitators (Programs/Materials)	(Ex) Coordinator adapts delivery of information and/or surveys to engage subgroups that would otherwise not be included (or included equitably). (e.g., Keeping surveys in paper format, not just QR codes, for older adults) (Ex) Coordinators and/or coalition members adjusting the timing/format/etc. of programs to improve implementation and/or reach.
	2c		Membership (Diversity, composition, and recruitment)	Descriptions, examples, etc. relating to coalition membership, recruitment, and engagement.
		2c.i	Barriers (Membership)	(Ex) Difficulties with outreach or engagement of subgroups
		2c.ii	Facilitators (Membership)	(Ex) Active participation from subgroups (Ex) Ways coordinators or coalitions have/will respond to or otherwise address barriers they discuss (e.g., moving meeting times; having interpreters)
	2d		Internal communication and decision-making	Descriptions, examples, etc. of communication modes/methods (within the coalition) and decision-making processes within coalitions. Also code examples/factors/descriptions that are neutral--not clearly a barrier or facilitator--either here or as “unsure.”
		2d.i	Barriers (Int communication)	[Examples needed]
		2d.ii	Facilitators (Int communication)	(Ex) Examples or discussion about bringing information to coalition members and work groups to ensure decision-making is informed and subgroups are engaged.
	2e		External communication and decision-making	Descriptions, examples, etc. of communication modes/methods with community members, partners, etc. Also code examples/factors/descriptions that are neutral--not clearly a barrier or facilitator--either here or as “unsure.”
		2e.i	Barriers (Ext communication)	[Examples needed]
		2e.ii	Facilitators (Ext communication)	[Examples needed]
	2f		Partnerships	Descriptions, examples, etc. of partnerships between CPWI coalitions and other entities (usually but not always local schools or healthcare settings).
		2f.i	Barriers (Partnerships)	(Ex) Difficulty reaching out to organizations (no response, lack of organizations, etc.)
		2f.ii	Facilitator (Partnerships)	(Ex) Leveraging existing networks, sharing data, and co-planning events
	2 g		Meetings	Excerpts that describe logistics and processes pertaining to coalition meetings or events that occur within coalition meetings.
		2 g.i	Barriers (Meetings)	(Ex) Examples of difficulty engaging coalition members during meetings (e.g., people not giving feedback/input, some members always being the one to speak while others do not, difficulties having conversations due to linguistical barriers)
		2 g.ii	Facilitators (Meetings)	(Ex) Adjusting coalition meetings (e.g., offering multiple times or formats, changing meeting times to accommodate members, reframing conversations/prompting conversations) to improve engagement (Ex) Examples of actions taken by coalition members and/or coordinator to recruit coalition members, orient them to CPWI work, or otherwise get them involved in CPWI
	2 h		Formal and informal work groups	Descriptions/Examples of formal and informal work groups/committees and respective actions/work. Use this code only for excerpts relating to work groups within the coalition, not external work groups.
	2i		Barriers (Coalition, general)	Catch-all code; Excerpts that describe barriers within coalitions and/or their work not best captured in other coalition subcodes.
	2j		Facilitators (Coalition, general)	Catch-all code; Excerpts that describe facilitators within coalitions and/or their work not best captured in other Coalition subcodes.
3			Community	Characteristics and factors related to CPWI communities and contexts.
	3a		Description/Context	Descriptions or explanations of context from the interview (specific data points will be pulled from strategic plans). Also code examples/factors/descriptions that are neutral--not clearly a barrier or facilitator--either here or as “unsure.”
		3a.i	Rural/Urban	(Ex) Code information in the first question of the interview (summarizing Strategic Plan information) (Ex) Code excerpts that brought up that describes the urbanicity/rurality of a community.
		3a.ii	Race/Ethnicity composition	(Ex) Code information in the first question of the interview (summarizing Strategic Plan information) (Ex) Code excerpts that discuss the racial/ethnic composition of the community.
		3a.iii	Poverty levels	(Ex) Code information in the first question of the interview (summarizing Strategic Plan information) (Ex) Code excerpts that bring up the poverty/affluence of the community.
		3a.iv	Age composition	(Ex) Code information in the first question of the interview (summarizing Strategic Plan information) (Ex) Code excerpts that discuss age composition of community members
	3b		Barriers (Community)	(Ex) Attitudes/norms resistant to DEI work as a whole or for subgroups/topics (Ex) Lack of community capacity/resources (such as community funding, number of organizations, flexibility and availability of organizations and members, distance from other supports) or lack of readiness/openness (such as knowledge of DEI/equity, willingness to learn) (Ex) Difficulty engaging with community due to intergenerational or historical trauma, mistrust, fear of perceived authority, etc.
	3c		Facilitator (community)	(Ex) Attitudes/norms supportive of DEI work as a whole or for subgroups/topics (Ex) Networking and/or leveraging existing relationships for planning, sharing data, and work (Ex) Community capacity and openness (e.g., funding, number of organizations, flexibility and availability of members, knowledge of DEI/equity, willingness to learn) (Ex) Supportive community or sector leaders
4			DBHR support/actions	Actions or strategies DBHR might employ to support CPWI coalitions.
	4a		Training/guidance support	Note - put anything related to coalition members’ training here, whether it’s a need or description of a completed activity. (Ex) Training/assistance creating and using/applying strategic plans (Ex) How to have difficult conversations about equity, community development, and related topics in a health and productive way. (Ex) How to promote readiness (e.g., knowledge/education, willingness to engage) (Ex) Increasing accessibility of trainings (e.g., having trainings recorded, trainings available in sections/chunks, having a trainer in-person, having a trainer available during meetings)
	4b		Financial support	(Ex) Funding for participation - Incentivizing participation in coalitions with families and youth for their efforts; removing practical barriers to participation (e.g., via gas cards, childcare) (Ex) Funding for food - Providing funding for food to be provided at meetings and events (discussion of food making events more welcoming and worthwhile to community members) (Ex) Funding technology and infrastructure - Examples/discussions of funding needed to devices/hardware and hardware delivery/dissemination (Ex) Funding disbursement - Examples/discussions of issues with funding being siloed (via sources, requirements, or both) and communities having to “braid” funding
	4c		Material support	(Ex) Creating materials or adapting materials for coordinators/communities (program materials or others) - Examples/discussions of coordinators having to translate materials themselves and/or find translators for hire or volunteer work (Ex) Addressing larger community needs (e.g., providing assistance to community members with bills, utilities, etc. as participation in programming is less likely until basic needs are met)
	4d		Other requirements/supports	(Ex) Changing reporting requirements (e.g., making relationship building actions and networking a “deliverable,” making a clear list of actions that promote health equity, otherwise recognizing related work coordinators are doing) (Ex) Assistance networking with organizations (e.g., providing lists of organizations and areas they serve; providing guidance on reaching out to organizations, etc.) (Ex) Understanding “bigger picture” factors as they impact coordinator work (e.g., changes in legislature may translate to changes in what sectors can do, such as law enforcement responding to mental health crisis calls)
5			Success stories and lessons learned	These are success stories and lessons learned coordinators provide throughout the interview (not just in relation to those specific questions). These can be general lessons or success stories about coordinator work, specific lessons or stories related to CPWI work (e.g., program delivery), and so on.
6			Unsure/discuss	Code any segment that seems important but difficult to categorize here.

^aIndicates the code’s level in an outline form. The left-, center-, and right-alignments in this column are intended to mimic outline style writing.