Data Appendix (Structured Tab-Delimited Text)

Copy these TSV blocks directly into your data pipeline. Columns are ordered for consistency across dashboards and briefs. Replace TODO placeholders with observed values.

1) County-Year Panel Data

Unit: county-year (ages 12–17 normalization). Pool small counts across 2–3 years and annotate breaks in series when reporting changes.

state	county_fips	county_name	year	edu_exclusion_rate	detention_rate	diversion_rate	sudmh_need_rate	foster_entries_per_1k	homelessness_proxy_rate	violent_incidents_per_1k	yari_score	notes
Arkansas (AR)	05119	Pulaski	2024	TODO	TODO	TODO	TODO	TODO	TODO	TODO	TODO	Replace TODOs with actual values; pool small-n across 2–3 yrs.

2) State JJ Pipeline Fields

One row per state; narrative fields allow concise but complete pipeline snapshots used in state briefs and the Pipelines explorer.

state	intake_screening	detention_criteria	adjudication_disposition	commitment_placement	reentry_aftercare	authority_structure	statutes_policies	data_handoff_gaps	sources_semicolon	last_updated
Arkansas (AR)	Validated risk assessment (SAVRY) at intake; MH screen	Detention reserved for high-risk/violent; judges weigh tool	Diversion/probation emphasized; commit contrary-to-tool documented	DYS commitment; state facilities + therapeutic group homes	Individualized plan; 3–6 mo aftercare; school/provider packet	State-run commitments (DYS); county courts probation/detention	Ark. Code Title 9, Ch.27; Act 189 (2019)	JCP↔DYS links; limited JJ–CW–education integration; recidivism not real-time	Act 189; DYS/AOC summaries; 2019–2021	2025-01-01

3) Provider Directory

Provider/program reference for the Providers directory and case-flow pages. Sources may be semicolon-delimited citations or links.

state	provider_name	program_type	coverage	referral_path	eligibility	process_notes	contact_url	contact_phone	contact_email	sources_semicolon
Arkansas (AR)	Youth Villages — Intercept	Reentry coaching	Central AR; selected counties	Court/aftercare → intake ≤7 days → in-home services	Court-involved youth returning home; clinical screen	Coaching model; school/MH coordination	https://www.youthvillages.org/			DYS annual report 2022; Provider materials

4) Program Outcomes (What Works / Counterexamples)

Minimal outcomes schema to compare initiation, completion, and improvements with short follow-up. Add design notes (RCT/QED/PrePost) and caveats for transparency.

program_name	state	domain	cohort_n	start_year	end_year	outcome_metric	baseline_value	post_value	followup_days	effect_size	design	caveats
Arkansas Building Futures (ABF)	Arkansas (AR)	Diversion	TODO	2019	2024	Complaint recurrence (12 mo.)	TODO	TODO	365	TODO	PrePost	Small-n pooled; selection bias possible
Youth Villages Intercept	Tennessee (TN)	Reunification / Placement Prevention	TODO	2018	2024	Stable reunification (180 d)	TODO	TODO	180	TODO	QED	Regional coverage varies; fidelity monitored

Tip: Keep TSV header names stable; version schemas in the file name (e.g., county_panel.v1.tsv).