Source document

docs/cities/miami/sources.yaml

Served verbatim from the project repository. Internal working document conventions apply: documents may reference file paths, branch names, and findings-ledger anchors from the repo.

# Source registry for the Miami-Dade build — same schema as
# docs/cities/philly/sources.yaml (and verify/sources.yaml).
# `role: ingested`  = the exact file the loader pulls (base case (ii)).
# `role: reference` = a different-publisher official figure (independent check).
#
# Every entry marked `fetched: 2026-09-15` has a provenance.json under
# data/cities/miami/sources/<source_id>/2026-09-15/ (sha256 + bytes + url +
# fetched_from). URLs are the canonical www.fldoe.org form; the discovery
# script rewrites the host to origin.fldoe.org (findings.md §E).
#
# Year encoding conventions (in addition to Philly's):
#   year_format: suffix_yyyy   -> "2425" in the file name means 2024-25
#   year_format: spring_yy     -> "Spring25" / "25" means 2024-25 (spring administration)
#   year_format: cohort_entry  -> graduation "2425" = cohort entering grade 9 in 2021-22
#   year_format: report_date   -> PDF report date; school year inferred from the file name

# ─────────────────────────────────────────────────────────────────────────────
# Directory / universe
# ─────────────────────────────────────────────────────────────────────────────

- source_id: fldoe_msid_all_schools
  role: ingested
  publisher: Florida Department of Education (Master School ID)
  url: https://eds.fldoe.org/EDS/MasterSchoolID/Downloads/All_schools.cfm
  format: txt            # tab-delimited, served as application/msexcel; needs a session cookie from index.cfm
  fetched: 2026-09-16
  year_format: snapshot
  columns:
    district: DISTRICT
    school: SCHOOL       # 4-digit
    type: TYPE
    activity: ACTIVITY_CODE   # A active / C closed / F future
    charter: CHARTER_SCHL_STAT   # Z none / R charter / H (verify: schools of hope?)
    charter_open: CHARTER_SCHL_OPEN
    magnet: MAGNET_STATUS        # Z / P / S
    choice: CS_SCHOOL_CHOICE
    title_i: TITLE_I_STATUS
    nces_district: FEDERAL_DIST_NO
    nces_school: FEDERAL_SCHL_NO
    lat: LATITUDE
    lng: LONGITUDE
    opened: DATE_OPENED
    closed: DATE_CLOSED
  join_key: [DISTRICT, SCHOOL]
  refresh: rolling (no history published)
  notes: 7,209 statewide rows x 77 fields; Dade 756 (542 active, 210 closed, 4 future). Data dictionary MSID Application Guidelines PDF (/core/fileparse.php/7574/urlt/0101172-msid.pdf).

- source_id: nces_ccd_directory_2023-24
  role: reference
  publisher: NCES Common Core of Data
  url: https://nces.ed.gov/ccd/Data/zip/ccd_sch_029_2324_w_1a_073124.zip
  format: zip
  fetched: 2026-09-15
  year: "2023-24"
  columns: { state_school_id: ST_SCHID, nces_id: NCESSCH, status: SY_STATUS_TEXT, type: SCH_TYPE_TEXT, charter: CHARTER_TEXT, level: LEVEL, grade_low: GSLO, grade_high: GSHI }
  join_key: ST_SCHID      # "FL-13-NNNN"
  refresh: annual
  notes: Filter ST_LEAID == FL-13 (LEAID 1200390). 2018-19 edition also fetched (nces_ccd_directory_2018-19).

- source_id: mdc_gis_schoolsite
  role: reference
  publisher: Miami-Dade County Open Data Hub (ArcGIS layer MDC::public-school)
  url: https://services.arcgis.com/8Pc9XBTAsYuxx9Ny/arcgis/rest/services/SchoolSite_gdb/FeatureServer/0/query?where=1%3D1&outFields=*&returnGeometry=true&outSR=4326&f=json&resultRecordCount=2000
  format: json
  fetched: 2026-09-15
  year_format: snapshot   # ENROLLMNT measured to be a 2024-25 count; CAPACITY = permanent FISH (findings.md M.5)
  columns: { school: ID, name: NAME, type: TYPE, grades: GRADES, capacity: CAPACITY, enrollment: ENROLLMNT, region: REGION, lat: LAT, lng: LON, modified: MODIFIEDDATE }
  join_key: ID
  refresh: quarterly
  metrics_backed: [fish_capacity_permanent, enrollment_gis, fish_capacity_permanent_gis]
  notes: 451 points; charter layer is a separate item (mdc_gis_charter_school_csv, 181 points, ENROLLMNT only).

# ─────────────────────────────────────────────────────────────────────────────
# Accountability (School Grades) — also the (iii-a) reference and the longitudinal roster
# ─────────────────────────────────────────────────────────────────────────────

- source_id: fldoe_school_grades_2024-25
  role: ingested
  publisher: Florida Department of Education, Accountability Reporting
  url: https://www.fldoe.org/file/18534/SchoolGrades25.xlsx
  format: xlsx
  fetched: 2026-09-15
  sheet: "School Grades 2025"
  header_row: 4
  year_format: spring_yy
  year: "2024-25"
  columns:
    district: District Number
    school: School Number            # zero-padded
    virtual_provider: Virtual Provider Number
    ela_achievement: English Language Arts Achievement
    ela_gains: English Language Arts Learning Gains
    ela_gains_l25: English Language Arts Learning Gains of the Lowest 25%
    math_achievement: Mathematics Achievement
    math_gains: Mathematics Learning Gains
    math_gains_l25: Mathematics Learning Gains of the Lowest 25%
    science: Science Achievement
    social_studies: Social Studies Achievement
    ms_acceleration: Middle School Acceleration
    grad_rate_lagged: Graduation Rate 2023-24
    ccr_lagged: College and Career Acceleration 2023-24
    grade: Grade 2025               # plus Grade 2024 ... Grade 1999 history columns
    charter: Charter School
    title_i: Title I
    school_type: School Type        # 01 Elem / 02 Middle / 03 High / 04 Combination
    pct_econ_disadv: Percent of Economically Disadvantaged Students
  join_key: [District Number, School Number]
  refresh: annual (July)
  metrics_backed: [school_grade, school_grade_points_pct, ela_achievement, math_achievement, science_achievement, social_studies_achievement, pct_econ_disadv, school_grade_letter_index, middle_school_acceleration, college_career_acceleration]
  notes: Dade 470 rows (A 300 / B 103 / C 65 / D 2); components blank when n<10. Prior years SchoolGrades{yy}.xlsx (xls before 2022); no 2020; 2023 = "Informational Baseline"; 2026 grading scale changes (GradingScalesOverview26.pdf). The graduation-rate and college-and-career-acceleration components are the state's LAGGED (prior-year) measures, stored here under the grade year they count toward.

- source_id: fldoe_ela_learning_gains_2024-25
  role: ingested
  publisher: Florida Department of Education, Accountability Reporting
  url: https://www.fldoe.org/file/18534/ELAGains25.xls
  format: xls
  fetched: 2026-09-15
  sheet: ["ELA Gains", "ELA High Gains", "ELA Low Gains"]
  year: "2024-25"
  join_key: [District Number, School Number]
  metrics_backed: [learning_gains_ela, learning_gains_ela_l25]
  notes: MathGains25.xls is the math twin (TBD fetch). Series 2017 -> 2025.

# ─────────────────────────────────────────────────────────────────────────────
# Assessments — State Report of Schools (one file per subject x grade x administration)
# ─────────────────────────────────────────────────────────────────────────────

- source_id: fldoe_fast_ela_g3_srs_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/11ELA03SRSSpring25.xls
  format: xls
  fetched: 2026-09-15
  sheet: ELA
  header_row: 5
  year_format: spring_yy
  year: "2024-25"
  columns: { district: District Number, school: School Number, grade: Grade, n: Number of Students, mean_scale: "Mean  Scale Score ", value: "Percentage in\nLevel 3 or Above", level1: "1", level2: "2", level3: "3", level4: "4", level5: "5" }
  join_key: [District Number, School Number]
  refresh: "annual (results page per year: https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml)"
  metrics_backed: [fast_ela_g3_proficiency, fast_ela_g3_mean_scale]
  notes: |
    All students only; '*' n<10; state row 00/0000. File prefixes drift by year
    (11ELA03SRSSpring25, 10ELA03SRSSpring23, SPR22ELA03SRS, 9Spring19ELA04SRS ...) and
    2024-and-earlier use /core/fileparse.php/5668/urlt/ — the P1 loader scrapes each
    year page and maps names to (subject, grade, administration). Comparability
    regimes: FCAT 2.0 (<=2014), FSA (2015-2022, none in 2020), FAST/B.E.S.T. (2023->).

- source_id: fldoe_best_alg1_srs_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/35Spring25Alg1SRS.xls
  format: xls
  fetched: 2026-09-15
  sheet: "Alg1 Sch"
  header_row: 5
  year: "2024-25"
  join_key: [District Number, School Number]
  metrics_backed: [eoc_alg1_proficiency, eoc_alg1_mean_scale]
  notes: EOCs have Fall / Winter / Spring / Summer administrations, each with an SRS file; spring is canonical. Geometry (B.E.S.T.), Biology 1, Civics, US History (NGSSS) follow the same shape.

- source_id: fldoe_science_g5_srs_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/54G5SRSSpring23.xls
  format: xls
  fetched: 2026-09-15
  year: "2022-23"
  join_key: [District Number, School Number]
  metrics_backed: [science_g5_proficiency]
  notes: Older URL form; grade 8 science is 55G8SRS*.

# ─────────────────────────────────────────────────────────────────────────────
# Graduation
# ─────────────────────────────────────────────────────────────────────────────

- source_id: fldoe_fed_grad_rate_race_2024-25
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/FedGradRateRace2425.xls
  format: xls
  fetched: 2026-09-15
  sheet: "Fed GradRate by Race-School"
  header_row: 6
  year_format: cohort_entry
  year: "2024-25"
  columns: { district: District Number, school: School Number, virtual_provider: Virtual Provider Number, value: "<Group> Graduation Rate", n: "<Group> Cohort", graduates: "<Group> Graduates" }
  join_key: [District Number, School Number, Virtual Provider Number]
  refresh: annual
  metrics_backed: [graduation_rate_4yr]
  notes: Groups White / Black / Hispanic / Asian / AmInd-AK / Two+ / NH-PI. Dade 146 school rows; '*'. Series 2014-15 -> 2024-25 (2014-15 named FedGradRate_Race_14-15.xls).

- source_id: fldoe_fed_grad_rate_category_2024-25
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/FedGradRateCategory2425.xls
  format: xls
  fetched: 2026-09-15
  sheet: "Fed GradRate by Category-School"
  header_row: 6
  year: "2024-25"
  join_key: [District Number, School Number, Virtual Provider Number]
  metrics_backed: [graduation_rate_4yr]
  notes: Groups Total / ESE / Free-Reduced Lunch / ELL / Migrant / At-Risk / Male / Female.

# ─────────────────────────────────────────────────────────────────────────────
# Attendance / chronic absenteeism
# ─────────────────────────────────────────────────────────────────────────────

- source_id: fldoe_absent21_10pct_2024-25
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/2425ABS21Days10Comparison.xlsx
  format: xlsx
  fetched: 2026-09-15
  sheet: Schools_2425_FS5
  header_row: 3
  year_format: suffix_yyyy
  year: "2024-25"
  columns:
    district: "District #"
    school: "School #"              # unpadded integer
    enrollment_annual: Total Enrollment
    n_abs21: "# of Students Absent 21 or More Days"
    value_abs21: "% of Students Absent 21 or More Days"
    enrolled_10plus: "# of Students Enrolled 10 or More Days"
    n_abs10pct: "# of Students Absent 10% or More"
    value_abs10pct: "% of Students Absent 10% or More"
  join_key: ["District #", "School #"]
  refresh: annual (Survey 5, posted following fall)
  metrics_backed: [chronic_absenteeism_rate, absent_21plus_rate]
  notes: |
    Denominator = annual unduplicated enrollment (students at two schools count at each).
    10% series 2017-18 -> 2024-25 ({yy}ABS21Days10Comparison.xlsx); 21+ only 2010-11 -> 2016-17
    ({yy}ABS21DAYSTDistSchl.xlsx; 2016-17 flagged inaccurate by FLDOE). Dade 518 rows; '*'.
    2023-24 and 2016-17 editions also fetched.

- source_id: fldoe_ada_adm_school_2024-25
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/ADAADMSchl2425.xlsx
  format: xlsx
  fetched: 2026-09-15
  sheet: School
  year: "2024-25"
  join_key: ["District #", "School #"]
  metrics_backed: [attendance_rate, average_daily_attendance, average_daily_membership]
  notes: No suppression; Dade 525 rows. Series ADAADM{yy}.xlsx 2013-14 -> (xls earlier).

- source_id: eddataexpress_chronic_absenteeism_2022-23
  role: reference
  publisher: US Department of Education, EDFacts (EdDataExpress) FS195 DG814
  url: https://eddataexpress.ed.gov/sites/default/files/2024-11/SY2223%20Chronic%20Absenteeism%20EDE%20110724.zip
  format: zip
  year: "2022-23"
  columns: { nces_school: NCES_SCH, subgroup: SUBGROUP, value: "chronic absenteeism rate / counts (perturbed)" }
  join_key: NCES_SCH -> CCD NCESSCH -> ST_SCHID
  metrics_backed: [chronic_absenteeism_rate]
  notes: ESSA 10% definition with subgroups (race x sex, ECODIS, LEP, SWD, HOM, 504); Dade 508 schools; 2020-21 and 2021-22 zips alongside. Not yet fetched.

- source_id: crdc_2021-22
  role: reference
  publisher: US Department of Education, Office for Civil Rights (CRDC)
  url: https://civilrightsdata.ed.gov/assets/ocr/docs/2021-22-crdc-data.zip
  format: zip           # 832 MB; 2023-24 (100 MB) and 2017-18 (120 MB) are lighter
  join_key: COMBOKEY -> CCD
  metrics_backed: [absent_15plus_rate, oss_rate, iss_rate, expulsion_rate, arrests_referrals_rate, ap_enrollment_share, teacher_fte]
  notes: Absenteeism = 15+ days (not 10%); discipline by race x sex, IDEA, 504, EL; course access; staffing. Not yet fetched.

# ─────────────────────────────────────────────────────────────────────────────
# Safety / discipline
# ─────────────────────────────────────────────────────────────────────────────

- source_id: fldoe_sesir_school_2024-25
  role: ingested
  publisher: Florida Department of Education, Office of Safe Schools
  url: https://www.fldoe.org/file/18612/SESIR2425a-h.xlsx
  format: xlsx
  fetched: 2026-09-15
  sheet: Schools
  year: "2024-25"
  columns: { district: "District #", school: "School #", incident_type: Type of Incident, count: Total Incidents, law_enforcement: "Reported to Law Enforcement (arrest / diversion / involuntary exam / other / none)", flags: "alcohol / vaping / drug / bullying / hazing / gang / hate-crime / weapon / injury related" }
  join_key: ["District #", "School #"]
  refresh: annual (Survey 5)
  metrics_backed: [sesir_total_per_100, sesir_violence_per_100, sesir_bullying_per_100, sesir_weapons_per_100, sesir_drugs_per_100]
  notes: No suppression; Dade 14,850 rows (~550 schools x 27 types). Series 2005-06 -> (three URL forms). Definitions change over time — check Appendix P per year.

- source_id: fldoe_discipline_report_2024-25
  role: ingested
  publisher: Florida Department of Education, Office of Safe Schools
  url: https://www.fldoe.org/file/18612/2425DisciplineReport.xlsx
  format: xlsx
  fetched: 2026-09-15
  sheet: "2425 FSS SCHOOL"
  year: "2024-25"
  join_key: ["Dist #", "Discipline School #"]
  metrics_backed: [oss_students, iss_students, expulsions]
  notes: By action x race x sex; extremely heavy '*' (most Dade ISS rows suppressed) — subgroup discipline comes from CRDC.

# ─────────────────────────────────────────────────────────────────────────────
# Climate survey (M-DCPS)
# ─────────────────────────────────────────────────────────────────────────────

- source_id: mdcps_climate_survey_students_2024-25
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/Survey_Results_Excels/2024-25/2025_Students_DashBoard_in_Excell_121.xlsx
  format: xlsx
  fetched: 2026-09-15
  sheet: 2025_Students_Data
  year: "2024-25"
  columns: { key: Key, school: LOC, membership: FTEFeb2025, n: TTL, suppressed: Less_10, item_id: SSQNO, item_text: SSQLabel, agree: Agree_PCT, dk: DK_PCT, disagree: Disagree_PCT, na: NA_PCT }
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_students_safety, survey_students_teaching, survey_students_leadership, survey_students_resources, survey_students_recommend, survey_students_grade_ab, survey_students_response_rate]
  notes: |
    17,748 rows, 493 schools, ~32 items. Parent and staff workbooks at the same path
    (2025_Parents_..., 2025_Staff_...). Prior years: 2023-24 (..._Nov2024_rev.xlsx),
    2022-23 (WMSFiles/244/SchoolClimateSurvey/2022-23/...), 2021-22, 2020-21 (.xlsm),
    2019-20, 2018-19. Item continuity across years to be diffed in P2.

# ─────────────────────────────────────────────────────────────────────────────
# Enrollment / demographics / staffing / spending
# ─────────────────────────────────────────────────────────────────────────────

- source_id: mdcps_climate_survey_parents_2024-25
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/Survey_Results_Excels/2024-25/2025_Parents_DashBoard_in_Excell_121.xlsx
  format: xlsx
  year: "2024-25"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_parents_safety, survey_parents_teaching, survey_parents_leadership, survey_parents_resources, survey_parents_recommend, survey_parents_grade_ab, survey_parents_response_rate]
  notes: |
    School Climate Survey dashboard workbook (parents, 2024-25), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_staff_2024-25
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/Survey_Results_Excels/2024-25/2025_Staff_DashBoard_in_Excell_121.xlsx
  format: xlsx
  year: "2024-25"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_staff_safety, survey_staff_teaching, survey_staff_leadership, survey_staff_resources, survey_staff_recommend, survey_staff_grade_ab, survey_staff_response_rate]
  notes: |
    School Climate Survey dashboard workbook (staff, 2024-25), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_students_2023-24
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/Survey_Results_Excels/2023-24/2024_Students_DashBoard_in_Excell_Nov2024_rev.xlsx
  format: xlsx
  year: "2023-24"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_students_safety, survey_students_teaching, survey_students_leadership, survey_students_resources, survey_students_recommend, survey_students_grade_ab, survey_students_response_rate]
  notes: |
    School Climate Survey dashboard workbook (students, 2023-24), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_parents_2023-24
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/Survey_Results_Excels/2023-24/2024_Parent_DashBoard_in_Excell_Nov2024_rev.xlsx
  format: xlsx
  year: "2023-24"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_parents_safety, survey_parents_teaching, survey_parents_leadership, survey_parents_resources, survey_parents_recommend, survey_parents_grade_ab, survey_parents_response_rate]
  notes: |
    School Climate Survey dashboard workbook (parents, 2023-24), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_staff_2023-24
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/Survey_Results_Excels/2023-24/2024_Staff_DashBoard_in_Excell_Nov2024_rev.xlsx
  format: xlsx
  year: "2023-24"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_staff_safety, survey_staff_teaching, survey_staff_leadership, survey_staff_resources, survey_staff_recommend, survey_staff_grade_ab, survey_staff_response_rate]
  notes: |
    School Climate Survey dashboard workbook (staff, 2023-24), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_students_2022-23
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/SchoolClimateSurvey/2022-23/2023_Students_DashBoard_23_August_2_POST.xlsx
  format: xlsx
  year: "2022-23"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_students_safety, survey_students_teaching, survey_students_leadership, survey_students_resources, survey_students_recommend, survey_students_grade_ab, survey_students_response_rate]
  notes: |
    School Climate Survey dashboard workbook (students, 2022-23), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_parents_2022-23
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/SchoolClimateSurvey/2022-23/2023_Parent_DashBoard_23_August_2_POST.xlsx
  format: xlsx
  year: "2022-23"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_parents_safety, survey_parents_teaching, survey_parents_leadership, survey_parents_resources, survey_parents_recommend, survey_parents_grade_ab, survey_parents_response_rate]
  notes: |
    School Climate Survey dashboard workbook (parents, 2022-23), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_staff_2022-23
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/SchoolClimateSurvey/2022-23/2023_Staff_DashBoard_23_August_2_POST.xlsx
  format: xlsx
  year: "2022-23"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_staff_safety, survey_staff_teaching, survey_staff_leadership, survey_staff_resources, survey_staff_recommend, survey_staff_grade_ab, survey_staff_response_rate]
  notes: |
    School Climate Survey dashboard workbook (staff, 2022-23), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_students_2021-22
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/Survey_Results_Excels/2021-22/2022-DashBoard_STUDENTS_June30.xlsx
  format: xlsx
  year: "2021-22"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_students_safety, survey_students_teaching, survey_students_leadership, survey_students_resources, survey_students_recommend, survey_students_grade_ab, survey_students_response_rate]
  notes: |
    School Climate Survey dashboard workbook (students, 2021-22), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_parents_2021-22
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/Survey_Results_Excels/2021-22/2022-DashBoard_%20PARENTS-June30.xlsx
  format: xlsx
  year: "2021-22"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_parents_safety, survey_parents_teaching, survey_parents_leadership, survey_parents_resources, survey_parents_recommend, survey_parents_grade_ab, survey_parents_response_rate]
  notes: |
    School Climate Survey dashboard workbook (parents, 2021-22), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_staff_2021-22
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/Survey_Results_Excels/2021-22/2022_DashBoard_STAFF_June30.xlsx
  format: xlsx
  year: "2021-22"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_staff_safety, survey_staff_teaching, survey_staff_leadership, survey_staff_resources, survey_staff_recommend, survey_staff_grade_ab, survey_staff_response_rate]
  notes: |
    School Climate Survey dashboard workbook (staff, 2021-22), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_students_2020-21
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/SchoolClimateSurvey/2020-21/2021-Student_DashBoard_July_21.xlsm
  format: xlsm
  year: "2020-21"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_students_safety, survey_students_teaching, survey_students_leadership, survey_students_resources, survey_students_recommend, survey_students_grade_ab, survey_students_response_rate]
  notes: |
    School Climate Survey dashboard workbook (students, 2020-21), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_parents_2020-21
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/SchoolClimateSurvey/2020-21/2021_Parent_Climate_DashBoard_Sept_2021.xlsm
  format: xlsm
  year: "2020-21"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_parents_safety, survey_parents_teaching, survey_parents_leadership, survey_parents_resources, survey_parents_recommend, survey_parents_grade_ab, survey_parents_response_rate]
  notes: |
    School Climate Survey dashboard workbook (parents, 2020-21), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_staff_2020-21
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/SchoolClimateSurvey/2020-21/2021_Staff_Climate_DashBoard_July27.xlsm
  format: xlsm
  year: "2020-21"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_staff_safety, survey_staff_teaching, survey_staff_leadership, survey_staff_resources, survey_staff_recommend, survey_staff_grade_ab, survey_staff_response_rate]
  notes: |
    School Climate Survey dashboard workbook (staff, 2020-21), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_students_2019-20
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/Survey_Results_Excels/2019-20/2020%20School%20Climate%20Dashboard-Student%20Results.xlsx
  format: xlsx
  year: "2019-20"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_students_safety, survey_students_teaching, survey_students_leadership, survey_students_resources, survey_students_recommend, survey_students_grade_ab, survey_students_response_rate]
  notes: |
    School Climate Survey dashboard workbook (students, 2019-20), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_staff_2019-20
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/Survey_Results_Excels/2019-20/2020%20School%20Climate%20Dashboard%20Teacher%20Results.xlsx
  format: xlsx
  year: "2019-20"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_staff_safety, survey_staff_teaching, survey_staff_leadership, survey_staff_resources, survey_staff_recommend, survey_staff_grade_ab, survey_staff_response_rate]
  notes: |
    School Climate Survey dashboard workbook (staff, 2019-20), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_students_2018-19
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/Survey_Results_Excels/2018-19/2019%20School%20Climate%20Dashboard-%20Student%20Results.xlsx
  format: xlsx
  year: "2018-19"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_students_safety, survey_students_teaching, survey_students_leadership, survey_students_resources, survey_students_recommend, survey_students_grade_ab, survey_students_response_rate]
  notes: |
    School Climate Survey dashboard workbook (students, 2018-19), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_parents_2018-19
  role: ingested
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/Survey_Results_Excels/2018-19/2019%20School%20Climate%20Dashboard-%20Parents%20Results.xlsx
  format: xlsx
  year: "2018-19"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: [survey_parents_safety, survey_parents_teaching, survey_parents_leadership, survey_parents_resources, survey_parents_recommend, survey_parents_grade_ab, survey_parents_response_rate]
  notes: |
    School Climate Survey dashboard workbook (parents, 2018-19), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Long-format results sheet per (school, item); layout differs by year (P2 crosswalk in
    data/cities/miami/reference/survey_items.csv). No parents workbook is published for 2019-20.

- source_id: mdcps_climate_survey_staff_2018-19
  role: retired
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/244/Survey_Results_Excels/2018-19/2019%20School%20Climate%20Dashboard-%20Teacher%20Results.xlsx
  format: xlsx
  year: "2018-19"
  join_key: LOC
  refresh: annual (spring; results in summer)
  metrics_backed: []
  notes: |
    School Climate Survey dashboard workbook (staff, 2018-19), listed on the Research Services
    page (drs2.dadeschools.net item 3603, read via api.dadeschools.net/api/wms/getPageData/3603).
    Fetched with provenance but NOT parsed or served (retired 2026-09-16): the file publishes
    agreement and disagreement only, no don't-know column, and the two sum to a median of 83%
    (10th percentile 50%), so a response category is missing; on the negative-worded core items its
    disagreement is 25% against 65–70% in every later year while agreement is stable (18% vs 20%).
    Under the favorable-response scoring the 2018-19 staff composites would sit 13–20 pp below
    2019-20; under 100 − agreement the hidden category would count as favorable. The staff series
    therefore starts in 2019-20 (pipeline_miami/parse/climate_survey.py RETIRED_SPECS). No parents
    workbook is published for 2019-20.

- source_id: fldoe_membership_by_school_grade_2025-26
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/2526MembBySchoolByGrade.xlsx
  format: xlsx
  fetched: 2026-09-15
  sheet: ["Schl Total Enrollment", "School"]
  header_row: 2
  year_format: suffix_yyyy
  year: "2025-26"
  columns: { district: "District #", school: "School #", total: "# of Students", grades: "PK, KG, 1 .. 12" }
  join_key: ["District #", "School #"]
  refresh: annual (Survey 2, October)
  metrics_backed: [enrollment_oct, "enrollment_oct_g{PK..12}"]
  notes: |
    Series 2016-17 -> 2025-26 (1314 returns 404). Sheet order, header row and blank/zero conventions differ by year (2018-19: header row 3, '**'). 2024-25 and 2018-19 also fetched.

- source_id: fldoe_membership_by_school_grade_race_2025-26
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/2526MembBySchoolByGradeByRace.xlsx
  format: xlsx
  fetched: 2026-09-15
  sheet: School
  year: "2025-26"
  join_key: ["District #", "School #"]
  metrics_backed: [pct_white, pct_black, pct_hispanic, pct_asian, pct_two_or_more, pct_amer_indian, pct_hawaiian_pac_isl]
  notes: school x grade x race; no total column (take totals from the by-grade file); heavy '*'. Series 2014-15 ->.

- source_id: fldoe_ell_membership_2025-26
  role: ingested
  publisher: Florida Department of Education
  url: https://www.fldoe.org/file/7584/2526ELLCodeMemb.xlsx
  format: xlsx
  fetched: 2026-09-15
  sheet: School
  year: "2025-26"
  join_key: ["District #", "School #"]
  metrics_backed: [pct_ell, pct_ell_lower_bound, pct_ell_upper_bound]
  notes: Code LY by school x race; Dade 505 rows; series 2012-13 ->.

- source_id: fldoe_membership_by_school_grade_race_2024-25
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/2425MembBySchoolByGradeByRace.xlsx
  format: xlsx
  sheet: School
  year: "2024-25"
  join_key: ["District #", "School #"]
  metrics_backed: [pct_white, pct_black, pct_hispanic, pct_asian, pct_two_or_more, pct_amer_indian, pct_hawaiian_pac_isl]
  notes: Same-year race shares for the residual-z covariates (M3); school x grade x race, no total column.

- source_id: fldoe_ell_membership_2024-25
  role: ingested
  publisher: Florida Department of Education
  url: https://www.fldoe.org/file/7584/2425ELLCodeMemb.xlsx
  format: xlsx
  sheet: School
  year: "2024-25"
  join_key: ["District #", "School #"]
  metrics_backed: [pct_ell, pct_ell_lower_bound, pct_ell_upper_bound]
  notes: Same-year English-learner share for the residual-z covariates (M3); code LY by school x race.

- source_id: fldoe_membership_by_school_grade_race_2023-24
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/2324MembBySchoolByGradeByRace.xlsx
  format: xlsx
  sheet: School
  year: "2023-24"
  join_key: ["District #", "School #"]
  metrics_backed: [pct_white, pct_black, pct_hispanic, pct_asian, pct_two_or_more, pct_amer_indian, pct_hawaiian_pac_isl]
  notes: Same-year race shares for the residual-z covariates (M3); school x grade x race, no total column.

- source_id: fldoe_ell_membership_2023-24
  role: ingested
  publisher: Florida Department of Education
  url: https://www.fldoe.org/file/7584/2324ELLCodeMemb.xlsx
  format: xlsx
  sheet: School
  year: "2023-24"
  join_key: ["District #", "School #"]
  metrics_backed: [pct_ell, pct_ell_lower_bound, pct_ell_upper_bound]
  notes: Same-year English-learner share for the residual-z covariates (M3); code LY by school x race.

- source_id: fldoe_membership_by_school_grade_race_2022-23
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/2223MembBySchoolByGradeByRace.xlsx
  format: xlsx
  sheet: School
  year: "2022-23"
  join_key: ["District #", "School #"]
  metrics_backed: [pct_white, pct_black, pct_hispanic, pct_asian, pct_two_or_more, pct_amer_indian, pct_hawaiian_pac_isl]
  notes: Same-year race shares for the residual-z covariates (M3); school x grade x race, no total column.

- source_id: fldoe_ell_membership_2022-23
  role: ingested
  publisher: Florida Department of Education
  url: https://www.fldoe.org/file/7584/2223ELLCodeMemb.xlsx
  format: xlsx
  sheet: School
  year: "2022-23"
  join_key: ["District #", "School #"]
  metrics_backed: [pct_ell, pct_ell_lower_bound, pct_ell_upper_bound]
  notes: Same-year English-learner share for the residual-z covariates (M3); code LY by school x race.

- source_id: fldoe_membership_by_school_grade_race_2021-22
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/2122MembBySchoolByGradeByRace.xlsx
  format: xlsx
  sheet: School
  year: "2021-22"
  join_key: ["District #", "School #"]
  metrics_backed: [pct_white, pct_black, pct_hispanic, pct_asian, pct_two_or_more, pct_amer_indian, pct_hawaiian_pac_isl]
  notes: Same-year race shares for the residual-z covariates (M3); school x grade x race, no total column.

- source_id: fldoe_ell_membership_2021-22
  role: ingested
  publisher: Florida Department of Education
  url: https://www.fldoe.org/file/7584/2122ELLCodeMemb.xlsx
  format: xlsx
  sheet: School
  year: "2021-22"
  join_key: ["District #", "School #"]
  metrics_backed: [pct_ell, pct_ell_lower_bound, pct_ell_upper_bound]
  notes: Same-year English-learner share for the residual-z covariates (M3); code LY by school x race.

- source_id: fldoe_membership_by_school_grade_race_2018-19
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/1819MembBySchoolByGradeByRace.xlsx
  format: xlsx
  sheet: School
  year: "2018-19"
  join_key: ["District #", "School #"]
  metrics_backed: [pct_white, pct_black, pct_hispanic, pct_asian, pct_two_or_more, pct_amer_indian, pct_hawaiian_pac_isl]
  notes: Same-year race shares for the residual-z covariates (M3); school x grade x race, no total column.

- source_id: fldoe_ell_membership_2018-19
  role: ingested
  publisher: Florida Department of Education
  url: https://www.fldoe.org/file/7584/1819ELLCodeMemb.xlsx
  format: xlsx
  sheet: School
  year: "2018-19"
  join_key: ["District #", "School #"]
  metrics_backed: [pct_ell, pct_ell_lower_bound, pct_ell_upper_bound]
  notes: Same-year English-learner share for the residual-z covariates (M3); code LY by school x race.

- source_id: fldoe_lunch_status_school_fs3_2025-26
  role: ingested
  publisher: Florida Department of Education
  url: https://www.fldoe.org/file/7584/2526FS3-Lunch-Status-School.xlsx
  format: xlsx
  fetched: 2026-09-15
  sheet: ["Lunch Status", "Demo", "NOTES"]
  year: "2025-26"
  join_key: ["District #", "School #"]
  metrics_backed: [pct_econ_disadv_nslp, pct_direct_cert, cep_flag]
  notes: Free / reduced / provision 2 / direct-cert CEP / CEP x 1.6 columns; the "rate with multiplier" is not comparable across CEP status (decision M.8).

- source_id: nces_ccd_membership_2023-24
  role: reference
  publisher: NCES Common Core of Data
  url: https://nces.ed.gov/ccd/Data/zip/ccd_sch_052_2324_l_1a_073124.zip
  format: zip           # 207 MB; stream-filter to ST_LEAID == FL-13
  fetched: 2026-09-15
  year: "2023-24"
  columns: { state_school_id: ST_SCHID, grade: GRADE, race: RACE_ETHNICITY, sex: SEX, count: STUDENT_COUNT, indicator: TOTAL_INDICATOR }
  join_key: ST_SCHID
  metrics_backed: [enrollment_oct_ccd]
  notes: Federal copy of the state's Survey 2 submission; used for (iii-b) on enrollment and for years before 2016-17. 2018-19 also fetched.

- source_id: nces_ccd_membership_2022-23
  role: reference
  publisher: NCES Common Core of Data
  url: https://nces.ed.gov/ccd/Data/zip/ccd_sch_052_2223_l_1a_083023.zip
  format: zip           # 207 MB; stream-filter to ST_LEAID == FL-13
  year: "2022-23"
  columns: { state_school_id: ST_SCHID, grade: GRADE, race: RACE_ETHNICITY, sex: SEX, count: STUDENT_COUNT, indicator: TOTAL_INDICATOR }
  join_key: ST_SCHID
  metrics_backed: [enrollment_oct_ccd]
  notes: Fetched to measure the race-share allocation rule in the year whose state file marks zeros with '*' (probe/race_imputation.py).

- source_id: nces_ccd_staff_2023-24
  role: ingested
  publisher: NCES Common Core of Data
  url: https://nces.ed.gov/ccd/Data/zip/ccd_sch_059_2324_l_1a_073124.zip
  format: zip
  fetched: 2026-09-15
  year: "2023-24"
  columns: { state_school_id: ST_SCHID, teachers_fte: TEACHERS }
  join_key: ST_SCHID
  metrics_backed: [teacher_fte, students_per_teacher]
  notes: Only school-level teacher count available (FLDOE staff files are district-level).

- source_id: fldoe_essa_ppe_2024-25
  role: ingested
  publisher: Florida Department of Education, Office of Funding and Financial Reporting
  url: https://www.fldoe.org/file/7507/ESSA-2025-School-Per-Pupil-Expenditures.xlsx
  format: xlsx
  fetched: 2026-09-15
  sheet: "School PPE ESSA"
  header_row: 5
  year: "2024-25"
  columns: { district: District Code, school: School Code, school_state_local: "School Costs Per Pupil / State and Local Funds", school_federal: "School Costs Per Pupil / Federal Funds", school_total: "School Costs Per Pupil / State, Local and Federal Funds", indirect_total: "District Indirect Costs Per Pupil / State, Local and Federal Funds", total: "Total Costs - State, Local and Federal" }
  join_key: [District Code, School Code]
  refresh: annual
  metrics_backed: [per_pupil_expenditure_school, per_pupil_expenditure_total, per_pupil_expenditure_school_federal]
  notes: Series 2018-19 -> 2024-25; older years use /core/fileparse.php/7507/urlt/ESSA{yy}School-PerPupil-Expend.xlsx (2022-23 fetched). Enrollment denominator to be confirmed from the page notes.

- source_id: fldoe_course_enrollment_dade_fs3_2025-26
  role: ingested
  publisher: Florida Department of Education
  url: https://www.fldoe.org/file/7584/Schl2526S3Dade-Highlands.xlsx
  format: xlsx
  fetched: 2026-09-15
  year: "2025-26"
  join_key: [District, School Number]
  metrics_backed: [ap_course_count, ib_aice_course_count, dual_enrollment_count, hs_course_access_index]
  notes: 80,906 rows of school x course x enrollment (Dade + Highlands split file); source for the derived course-access index (NYC's HS directory analogue). Series 2019-20 ->.

- source_id: mdcps_statistical_highlights_2025-26
  role: reference
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/171/MDCPS%20Highlights/SH2526.pdf
  format: pdf
  fetched: 2026-09-15
  year: "2025-26"
  metrics_backed: [district_enrollment_oct, district_school_count, district_teacher_count]
  notes: District-level only; 10-year table; charter vs traditional counts (162 / 341). Series SH{yy}.pdf back to 1974-75 (index page unreachable from cloud; file URLs work).

# ─────────────────────────────────────────────────────────────────────────────
# Facilities, projections, closures (06 track)
# ─────────────────────────────────────────────────────────────────────────────

- source_id: fldoe_fish_los_dade_2024-25
  role: ingested
  publisher: Florida Department of Education, Office of Educational Facilities
  url: https://www.fldoe.org/core/fileparse.php/20080/urlt/2425Dade.pdf
  format: pdf            # 20 pages; report date 3/6/2025
  fetched: 2026-09-15
  year_format: report_date
  year: "2024-25"
  columns: { facility: FACILITY NAME, school_capacity: SCHOOL CAPACITY, permanent_capacity: PERMANENT CAPACITY, dining_capacity: DINING CAPACITY, year_round_capacity: YEAR ROUND CAPACITY, utilization_factor: UTILIZATION FACTOR, utilization_pct: PERCENTAGE UTILIZATION, primary_use: PRIMARY USE, cofte: TOTAL COFTE, available: AVAILABLE CAPACITY (SURPLUS) }
  join_key: FACILITY NAME -> school number via MSID / GIS name match (no number in the PDF — verify)
  refresh: annual
  metrics_backed: [fish_capacity_school, fish_capacity_permanent, cofte, utilization_school_capacity_pct]
  notes: PERCENTAGE UTILIZATION = COFTE / SCHOOL CAPACITY (verified on two rows). 2023-24 and 2022-23 editions fetched. Two-parser agreement gate (05_validation_spec.md).

- source_id: mdcps_abc_book_2026-27
  role: ingested
  publisher: Miami-Dade County Public Schools, School Board (item D-67, 2026-06-17)
  url: https://pdfs.dadeschools.net/Bdarch/2026/Bd061726/agenda/ATTENDANCE-ZONE-RECOMMENDATIONS-AND-RELATED-ADMINISTRATIVE-ACTIONS-2026-2027-FINAL-READING.pdf
  format: pdf            # 78 pages
  fetched: 2026-09-15
  year: "2026-27"
  columns: { school: "NNNN - Name header", enrollment: Student Enrollment, perm_fish: Perm FISH Cap, util_perm: "% Utilization Perm FISH Cap", perm_temp_fish: "Perm & Temp FISH Cap", util_perm_temp: "% Utilization Perm & Temp", projected: "2026-2027 / 2027-2028 columns" }
  join_key: school number in block header
  metrics_backed: [fish_capacity_permanent, fish_capacity_perm_temp, projected_enrollment_y1, projected_enrollment_y2, enrollment_abc, fish_capacity_permanent_abc, utilization_permanent_pct_abc]
  events_backed: [CLOSED, CONSOLIDATED_INTO, RECEIVED_CONSOLIDATION, BOUNDARY_CHANGE]
  notes: Prior editions 2024-25 (Bd061824/agenda/D67-...pdf, different layout) and 2019-20 (schoolboard/060719/...pdf) listed; each year covers only targeted schools.

- source_id: fldoe_defp_work_plan_dade_2024-25
  role: ingested
  publisher: Florida Department of Education, Office of Educational Facilities (filed by M-DCPS)
  url: https://www.fldoe.org/core/fileparse.php/9948/urlt/DADE2025.pdf
  format: pdf
  fetched: 2026-09-15
  year: "2024-25"
  metrics_backed: [projected_enrollment_5yr, fish_capacity_permanent]
  notes: District Educational Facilities Plan; per-school capacity and projected COFTE over the 5-year window; table layout to be parsed in C0. Prior year DADE2024.pdf.

- source_id: fldoe_cofte_2023-24
  role: reference
  publisher: Florida Department of Education (Education Estimating Conference)
  url: https://www.fldoe.org/file/7507/2324COFTE-PFP.pdf
  format: pdf
  fetched: 2026-09-15
  year: "2023-24"
  metrics_backed: [district_projected_cofte]
  notes: District x grade cohort-survival projections, 10-year horizon.

- source_id: mdcps_budget_exec_summary_2026-27
  role: reference
  publisher: Miami-Dade County Public Schools, Office of Budget Management
  url: https://api.dadeschools.net/WMSFiles/145/Executive%20Summary/2026/Executive%20Summary%202026-27.pdf
  format: pdf            # 331 pages
  fetched: 2026-09-15
  year: "2026-27"
  metrics_backed: [district_uwfte_total, district_uwfte_charter, district_uwfte_fes]
  notes: Unweighted FTE trends incl. charter and FES scholarship FTE (the voucher series).

- source_id: mdcps_school_events
  role: ingested
  publisher: Miami-Dade County Public Schools, School Board (hand-curated from ABC books 2019-20 -> 2026-27 and the 2026-08-25 letters)
  url: TBD    # curated CSV committed under data/cities/miami/reference/school_events.csv, each row citing its PDF + page
  format: csv
  year_format: passthrough
  columns: { school: school_number, year: school_year, action: action, detail: detail, source_url: source_doc_url, board_item: board_item, decided_at: decided_at }
  join_key: school_number
  events_backed: [CLOSED, CONSOLIDATED_INTO, RECEIVED_CONSOLIDATION, REPURPOSED, BOUNDARY_CHANGE, REASSESSED, UNDER_REVIEW, CO_LOCATION]
  notes: The reference layer for the closure track; built in C1.

# ─────────────────────────────────────────────────────────────────────────────
# Additional years / companions registered 2026-09-15 (C0), URLs verified by HEAD
# ─────────────────────────────────────────────────────────────────────────────

- source_id: fldoe_membership_by_school_grade_2016-17
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/1617MembBySchoolByGrade.xlsx
  format: xlsx
  year: 2016-17
  notes: October (Survey 2) membership by school x grade. Sheet order / header row / blank-vs-zero conventions vary by year;
    the loader detects the header row.
  year_format: suffix_yyyy
  join_key:
  - 'District #'
  - 'School #'
  metrics_backed:
  - enrollment_oct
  - enrollment_oct_g{PK..12}
- source_id: fldoe_membership_by_school_grade_2017-18
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/1718MembBySchoolByGrade.xlsx
  format: xlsx
  year: 2017-18
  notes: October (Survey 2) membership by school x grade. Sheet order / header row / blank-vs-zero conventions vary by year;
    the loader detects the header row.
  year_format: suffix_yyyy
  join_key:
  - 'District #'
  - 'School #'
  metrics_backed:
  - enrollment_oct
  - enrollment_oct_g{PK..12}
- source_id: fldoe_membership_by_school_grade_2019-20
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/1920MembBySchoolByGrade.xlsx
  format: xlsx
  year: 2019-20
  notes: October (Survey 2) membership by school x grade. Sheet order / header row / blank-vs-zero conventions vary by year;
    the loader detects the header row.
  year_format: suffix_yyyy
  join_key:
  - 'District #'
  - 'School #'
  metrics_backed:
  - enrollment_oct
  - enrollment_oct_g{PK..12}
- source_id: fldoe_membership_by_school_grade_2020-21
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/2021MembBySchoolByGrade.xlsx
  format: xlsx
  year: 2020-21
  notes: October (Survey 2) membership by school x grade. Sheet order / header row / blank-vs-zero conventions vary by year;
    the loader detects the header row.
  year_format: suffix_yyyy
  join_key:
  - 'District #'
  - 'School #'
  metrics_backed:
  - enrollment_oct
  - enrollment_oct_g{PK..12}
- source_id: fldoe_membership_by_school_grade_2021-22
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/2122MembBySchoolByGrade.xlsx
  format: xlsx
  year: 2021-22
  notes: October (Survey 2) membership by school x grade. Sheet order / header row / blank-vs-zero conventions vary by year;
    the loader detects the header row.
  year_format: suffix_yyyy
  join_key:
  - 'District #'
  - 'School #'
  metrics_backed:
  - enrollment_oct
  - enrollment_oct_g{PK..12}
- source_id: fldoe_membership_by_school_grade_2022-23
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/2223MembBySchoolByGrade.xlsx
  format: xlsx
  year: 2022-23
  notes: October (Survey 2) membership by school x grade. Sheet order / header row / blank-vs-zero conventions vary by year;
    the loader detects the header row.
  year_format: suffix_yyyy
  join_key:
  - 'District #'
  - 'School #'
  metrics_backed:
  - enrollment_oct
  - enrollment_oct_g{PK..12}
- source_id: fldoe_membership_by_school_grade_2023-24
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/2324MembBySchoolByGrade.xlsx
  format: xlsx
  year: 2023-24
  notes: October (Survey 2) membership by school x grade. Sheet order / header row / blank-vs-zero conventions vary by year;
    the loader detects the header row.
  year_format: suffix_yyyy
  join_key:
  - 'District #'
  - 'School #'
  metrics_backed:
  - enrollment_oct
  - enrollment_oct_g{PK..12}
- source_id: fldoe_absent21_10pct_2017-18
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/1718ABS21Days10Comparison.xlsx
  format: xlsx
  year: 2017-18
  notes: Absent 21+ days and absent 10%+ by school (Survey 5). Same shape as the 2024-25 file.
  year_format: suffix_yyyy
  join_key:
  - 'District #'
  - 'School #'
  metrics_backed:
  - chronic_absenteeism_rate
  - absent_21plus_rate
- source_id: fldoe_absent21_10pct_2018-19
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/1819ABS21Days10Comparison.xlsx
  format: xlsx
  year: 2018-19
  notes: Absent 21+ days and absent 10%+ by school (Survey 5). Same shape as the 2024-25 file.
  year_format: suffix_yyyy
  join_key:
  - 'District #'
  - 'School #'
  metrics_backed:
  - chronic_absenteeism_rate
  - absent_21plus_rate
- source_id: fldoe_absent21_10pct_2019-20
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/1920ABS21Days10Comparison.xlsx
  format: xlsx
  year: 2019-20
  notes: Absent 21+ days and absent 10%+ by school (Survey 5). Same shape as the 2024-25 file.
  year_format: suffix_yyyy
  join_key:
  - 'District #'
  - 'School #'
  metrics_backed:
  - chronic_absenteeism_rate
  - absent_21plus_rate
- source_id: fldoe_absent21_10pct_2020-21
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/2021ABS21Days10Comparison.xlsx
  format: xlsx
  year: 2020-21
  notes: Absent 21+ days and absent 10%+ by school (Survey 5). Same shape as the 2024-25 file.
  year_format: suffix_yyyy
  join_key:
  - 'District #'
  - 'School #'
  metrics_backed:
  - chronic_absenteeism_rate
  - absent_21plus_rate
- source_id: fldoe_absent21_10pct_2021-22
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/2122ABS21Days10Comparison.xlsx
  format: xlsx
  year: 2021-22
  notes: Absent 21+ days and absent 10%+ by school (Survey 5). Same shape as the 2024-25 file.
  year_format: suffix_yyyy
  join_key:
  - 'District #'
  - 'School #'
  metrics_backed:
  - chronic_absenteeism_rate
  - absent_21plus_rate
- source_id: fldoe_absent21_10pct_2022-23
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/2223ABS21Days10Comparison.xlsx
  format: xlsx
  year: 2022-23
  notes: Absent 21+ days and absent 10%+ by school (Survey 5). Same shape as the 2024-25 file.
  year_format: suffix_yyyy
  join_key:
  - 'District #'
  - 'School #'
  metrics_backed:
  - chronic_absenteeism_rate
  - absent_21plus_rate
- source_id: fldoe_ada_adm_school_2023-24
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/ADAADM2324.xlsx
  format: xlsx
  year: 2023-24
  notes: Prior-year ADA/ADM file (older naming ADAADM{yy}.xlsx).
  metrics_backed:
  - attendance_rate
- source_id: fldoe_essa_ppe_2023-24
  role: ingested
  publisher: Florida Department of Education, Office of Funding and Financial Reporting
  url: https://www.fldoe.org/core/fileparse.php/7507/urlt/ESSA24School-PerPupil-Expend.xlsx
  format: xlsx
  year: 2023-24
  notes: ESSA school per-pupil expenditures, older URL form.
  metrics_backed:
  - per_pupil_expenditure_school
  - per_pupil_expenditure_total
  - per_pupil_expenditure_school_federal
- source_id: fldoe_essa_ppe_2021-22
  role: ingested
  publisher: Florida Department of Education, Office of Funding and Financial Reporting
  url: https://www.fldoe.org/file/7507/ESSA22School-PerPupil-Expend.xlsx
  format: xlsx
  year: 2021-22
  notes: ESSA school per-pupil expenditures. 2018-19 -> 2020-21 file names not yet resolved (404 on the guessed names).
  metrics_backed:
  - per_pupil_expenditure_school
  - per_pupil_expenditure_total
  - per_pupil_expenditure_school_federal
- source_id: fldoe_defp_work_plan_dade_2023-24
  role: ingested
  publisher: Florida Department of Education, Office of Educational Facilities (filed by M-DCPS)
  url: https://www.fldoe.org/core/fileparse.php/9948/urlt/DADE2024.pdf
  format: pdf
  year: 2023-24
  notes: Prior-year District Educational Facilities Plan.
- source_id: fldoe_math_learning_gains_2024-25
  role: ingested
  publisher: Florida Department of Education, Accountability Reporting
  url: https://www.fldoe.org/file/18534/MathGains25.xls
  format: xls
  year: 2024-25
  notes: Math twin of ELAGains25.xls.
  metrics_backed:
  - learning_gains_math
  - learning_gains_math_l25
- source_id: fldoe_school_grades_2023-24
  role: ingested
  publisher: Florida Department of Education, Accountability Reporting
  url: https://www.fldoe.org/file/18534/SchoolGrades24.xlsx
  format: xlsx
  year: 2023-24
  notes: Prior-year School Grades file (2023 = informational baseline; no 2020; 2021 opt-in).
  metrics_backed:
  - school_grade
  - ela_achievement
  - math_achievement
  - pct_econ_disadv
  - school_grade_letter_index
  - middle_school_acceleration
- source_id: fldoe_school_grades_2022-23
  role: ingested
  publisher: Florida Department of Education, Accountability Reporting
  url: https://www.fldoe.org/file/18534/SchoolGrades23.xlsx
  format: xlsx
  year: 2022-23
  notes: Prior-year School Grades file (2023 = informational baseline; no 2020; 2021 opt-in).
  metrics_backed:
  - school_grade
  - ela_achievement
  - math_achievement
  - pct_econ_disadv
  - school_grade_letter_index
  - middle_school_acceleration
- source_id: fldoe_school_grades_2021-22
  role: ingested
  publisher: Florida Department of Education, Accountability Reporting
  url: https://www.fldoe.org/file/18534/SchoolGrades22.xlsx
  format: xlsx
  year: 2021-22
  notes: Prior-year School Grades file (2023 = informational baseline; no 2020; 2021 opt-in).
  metrics_backed:
  - school_grade
  - ela_achievement
  - math_achievement
  - pct_econ_disadv
  - school_grade_letter_index
  - middle_school_acceleration
- source_id: fldoe_school_grades_2018-19
  role: ingested
  publisher: Florida Department of Education, Accountability Reporting
  url: https://www.fldoe.org/file/18534/SchoolGrades19.xls
  format: xls
  year: 2018-19
  notes: Prior-year School Grades file (2023 = informational baseline; no 2020; 2021 opt-in).
  metrics_backed:
  - school_grade
  - ela_achievement
  - math_achievement
  - pct_econ_disadv
  - school_grade_letter_index
  - middle_school_acceleration
- source_id: fldoe_fed_grad_rate_race_2023-24
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/FedGradRateRace2324.xls
  format: xls
  year: 2023-24
  notes: Prior-year federal graduation rate by race.
  year_format: cohort_entry
  metrics_backed:
  - graduation_rate_4yr
- source_id: fldoe_fed_grad_rate_race_2022-23
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/FedGradRateRace2223.xls
  format: xls
  year: 2022-23
  notes: Prior-year federal graduation rate by race.
  year_format: cohort_entry
  metrics_backed:
  - graduation_rate_4yr
- source_id: fldoe_fed_grad_rate_race_2018-19
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/FedGradRateRace1819.xls
  format: xls
  year: 2018-19
  notes: Prior-year federal graduation rate by race.
  year_format: cohort_entry
  metrics_backed:
  - graduation_rate_4yr
- source_id: fldoe_fed_grad_rate_category_2023-24
  role: ingested
  publisher: Florida Department of Education, PK-12 Education Information Services
  url: https://www.fldoe.org/file/7584/FedGradRateCategory2324.xls
  format: xls
  year: 2023-24
  notes: Prior-year federal graduation rate by category.
  year_format: cohort_entry
  metrics_backed:
  - graduation_rate_4yr
- source_id: fldoe_msid_guidelines
  role: reference
  publisher: Florida Department of Education (Master School ID)
  url: https://www.fldoe.org/core/fileparse.php/7574/urlt/0101172-msid.pdf
  format: pdf
  year: n/a
  notes: 'MSID Application Guidelines: Appendix A data elements, Appendix B grade codes / school types / function settings.'
- source_id: mdcps_abc_book_2024-25
  role: ingested
  publisher: Miami-Dade County Public Schools, School Board
  url: https://pdfs.dadeschools.net/Bdarch/2024/Bd061824/agenda/D67-ATTENDANCE-ZONE-RECOMMENDATIONS-RELATED-ADMINISTRATIVE-ACTIONS%202024-2025(revised%206.17.24).pdf
  format: pdf
  year: 2024-25
  notes: 'Attendance Zone Recommendations 2024-25 (different layout: Perm & Temp FISH only, current + 1 projected year).'
  events_backed:
  - CLOSED
  - CONSOLIDATED_INTO
  - BOUNDARY_CHANGE
- source_id: mdcps_abc_book_2019-20
  role: ingested
  publisher: Miami-Dade County Public Schools, School Board
  url: https://pdfs.dadeschools.net/schoolboard/060719/Attendance%20Zone%20Recommendations%20and%20Related%20Administrative%20Actions%202019-2020.pdf
  format: pdf
  year: 2019-20
  notes: Attendance Zone Recommendations 2019-20.
  events_backed:
  - CLOSED
  - CONSOLIDATED_INTO
  - BOUNDARY_CHANGE
- source_id: mdcps_statistical_highlights_2023-24
  role: reference
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/171/MDCPS%20Highlights/SH2324.pdf
  format: pdf
  year: 2023-24
  notes: District-level Statistical Highlights (10-year table; charter vs traditional counts).
  metrics_backed:
  - district_enrollment_oct
  - district_school_count
- source_id: mdcps_statistical_highlights_2022-23
  role: reference
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/171/MDCPS%20Highlights/SH2223.pdf
  format: pdf
  year: 2022-23
  notes: District-level Statistical Highlights (10-year table; charter vs traditional counts).
  metrics_backed:
  - district_enrollment_oct
  - district_school_count
- source_id: mdcps_statistical_highlights_2021-22
  role: reference
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/171/MDCPS%20Highlights/SH2122.pdf
  format: pdf
  year: 2021-22
  notes: District-level Statistical Highlights (10-year table; charter vs traditional counts).
  metrics_backed:
  - district_enrollment_oct
  - district_school_count
- source_id: mdcps_statistical_highlights_2020-21
  role: reference
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/171/MDCPS%20Highlights/SH2021.pdf
  format: pdf
  year: 2020-21
  notes: District-level Statistical Highlights (10-year table; charter vs traditional counts).
  metrics_backed:
  - district_enrollment_oct
  - district_school_count
- source_id: mdcps_statistical_highlights_2019-20
  role: reference
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/171/MDCPS%20Highlights/SH1920.pdf
  format: pdf
  year: 2019-20
  notes: District-level Statistical Highlights (10-year table; charter vs traditional counts).
  metrics_backed:
  - district_enrollment_oct
  - district_school_count
- source_id: mdcps_statistical_highlights_2017-18
  role: reference
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/171/MDCPS%20Highlights/SH1718.pdf
  format: pdf
  year: 2017-18
  notes: District-level Statistical Highlights (10-year table; charter vs traditional counts).
  metrics_backed:
  - district_enrollment_oct
  - district_school_count
- source_id: mdcps_statistical_highlights_2016-17
  role: reference
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/171/MDCPS%20Highlights/SH1617.pdf
  format: pdf
  year: 2016-17
  notes: District-level Statistical Highlights (10-year table; charter vs traditional counts).
  metrics_backed:
  - district_enrollment_oct
  - district_school_count
- source_id: mdcps_statistical_highlights_2015-16
  role: reference
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/171/MDCPS%20Highlights/SH1516.pdf
  format: pdf
  year: 2015-16
  notes: District-level Statistical Highlights (10-year table; charter vs traditional counts).
  metrics_backed:
  - district_enrollment_oct
  - district_school_count
- source_id: mdcps_statistical_highlights_2014-15
  role: reference
  publisher: Miami-Dade County Public Schools, Research Services
  url: https://api.dadeschools.net/WMSFiles/171/MDCPS%20Highlights/SH1415.pdf
  format: pdf
  year: 2014-15
  notes: District-level Statistical Highlights (10-year table; charter vs traditional counts).
  metrics_backed:
  - district_enrollment_oct
  - district_school_count

# ─────────────────────────────────────────────────────────────────────────────
# Assessment SRS files discovered from the FLDOE results pages (discover_srs.py)
# ─────────────────────────────────────────────────────────────────────────────

- source_id: fldoe_srs_fast_ela_g4_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/12ELA04SRSSpring25.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g4_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g5_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/13ELA05SRSSpring25.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g5_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g6_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/14ELA06SRSSpring25.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g6_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g7_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/15ELA07SRSSpring25.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g7_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g8_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/16ELA08SRSSpring25.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g8_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g9_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/17ELA09SRSSpring25.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g9_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g10_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/18ELA10SRSSpring25.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g10_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g3_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/27Math03SRSSpring25.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g3_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g4_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/28Math04SRSSpring25.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g4_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g5_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/29Math05SRSSpring25.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g5_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g6_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/30Math06SRSSpring25.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g6_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g7_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/31Math07SRSSpring25.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g7_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g8_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/32Math08SRSSpring25.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g8_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_eoc_geometry_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/44Spring25GeoSRS.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - eoc_geometry_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_science_g5_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/54G5SRSSpring25.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - science_g5_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_science_g8_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/55G8SRSSpring25.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - science_g8_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_eoc_biology_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/58Spring25Bio1SRS.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - eoc_biology_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_eoc_civics_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/68Spring25CivSRS.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - eoc_civics_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_eoc_ushistory_spring2025
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/file/5668/77Spring25USHSRS.xls
  format: xls
  year_format: spring_yy
  year: 2024-25
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - eoc_ushistory_proficiency
  notes: State Report of Schools, spring 2025 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2025.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g3_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/11ELA03SRSSpring24.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g3_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g4_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/12ELA04SRSSpring24.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g4_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g5_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/13ELA05SRSSpring24.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g5_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g6_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/14ELA06SRSSpring24.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g6_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g7_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/15ELA07SRSSpring24.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g7_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g8_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/16ELA08SRSSpring24.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g8_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g9_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/17ELA09SRSSpring24.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g9_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g10_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/18ELA10SRSSpring24.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g10_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g3_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/27Math03SRSSpring24.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g3_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g4_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/28Math04SRSSpring24.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g4_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g5_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/29Math05SRSSpring24.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g5_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g6_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/30Math06SRSSpring24.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g6_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g7_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/31Math07SRSSpring24.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g7_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g8_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/32Math08SRSSpring24.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g8_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_eoc_alg1_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/35Spring24Alg1SRS.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - eoc_alg1_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_eoc_geometry_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/44Spring24GeoSRS.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - eoc_geometry_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_science_g5_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/54G5SRSSpring24.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - science_g5_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_science_g8_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/55G8SRSSpring24.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - science_g8_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_eoc_biology_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/58Spring24Bio1SRS.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - eoc_biology_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_eoc_civics_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/68Spring24CivSRS.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - eoc_civics_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_eoc_ushistory_spring2024
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/77Spring24USHSRS.xls
  format: xls
  year_format: spring_yy
  year: 2023-24
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - eoc_ushistory_proficiency
  notes: State Report of Schools, spring 2024 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2024.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g3_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/10ELA03SRSSpring23.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g3_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g4_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/11ELA04SRSSpring23.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g4_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g5_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/12ELA05SRSSpring23.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g5_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g6_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/13ELA06SRSSpring23.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g6_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g7_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/14ELA07SRSSpring23.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g7_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g8_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/15ELA08SRSSpring23.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g8_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g9_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/16ELA09SRSSpring23.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g9_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_ela_g10_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/17ELA10SRSSpring23.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_ela_g10_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g3_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/25Math03SRSSpring23.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g3_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g4_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/26Math04SRSSpring23.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g4_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g5_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/27Math05SRSSpring23.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g5_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g6_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/28Math06SRSSpring23.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g6_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g7_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/29Math07SRSSpring23.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g7_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_fast_math_g8_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/30Math08SRSSpring23.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - fast_math_g8_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_eoc_alg1_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/34Spring23Alg1SRS.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - eoc_alg1_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_eoc_geometry_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/43Spring23GeoSRS.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - eoc_geometry_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_science_g8_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/55G8SRSSpring23.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - science_g8_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_eoc_biology_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/58Spring23Bio1SRS.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - eoc_biology_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_eoc_civics_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/68Spring23CivSRS.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - eoc_civics_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.
- source_id: fldoe_srs_eoc_ushistory_spring2023
  role: ingested
  publisher: Florida Department of Education, Bureau of K-12 Student Assessment
  url: https://www.fldoe.org/core/fileparse.php/5668/urlt/77Spring23USHSRS.xls
  format: xls
  year_format: spring_yy
  year: 2022-23
  header_row: 5
  join_key:
  - District Number
  - School Number
  metrics_backed:
  - eoc_ushistory_proficiency
  notes: State Report of Schools, spring 2023 administration; discovered from https://www.fldoe.org/accountability/assessments/k-12-student-assessment/results/2023.stml
    by pipeline_miami/discover_srs.py. All students only; '*' n<10.