# fldoe_msid_all_schools — first-fetch findings

- publisher: Florida Department of Education (Master School ID)
- url: https://eds.fldoe.org/EDS/MasterSchoolID/Downloads/All_schools.cfm
- format: txt
- local path: `data/cities/miami/sources/fldoe_msid_all_schools/2026-09-15/All_schools.txt`

## Table — 7,209 rows × 77 columns

- `DISTRICT`
- `SCHOOL`
- `LOCATION_DISTRICT`
- `OFFR_DISTRICT`
- `GM_AGENCY_CODE`
- `TYPE`
- `ROI_TYPE`
- `YEAR_ROUND_SCHOOL`
- `ACC_TYPE`
- `ACTIVITY_CODE`
- `DISTRICT_NAME`
- `LOC_DISTRICT_NAME`
- `SCHOOL_NAME_LONG`
- `SCHOOL_NAME_SHORT`
- `GRADE_CODE`
- `NEG_DEL_IND`
- `NEG_DEL_CLASS`
- `ACCREDITED_SACS`
- `PHONE_NUMBER`
- `SUNCOM_NUMBER`
- `FAX_NUMBER`
- `MAGNET_STATUS`
- `MAGNET_SPECIALTY`
- `MAGNET_PURPOSE`
- `CS_SCHOOL_CHOICE`
- `PHYSICAL_ADDRESS`
- `PHYSICAL_CITY`
- `PHYSICAL_STATE`
- `PHYSICAL_ZIP`
- `MAILING_ADDRESS1`
- `MAILING_ADDRESS2`
- `MAILING_CITY`
- `MAILING_STATE`
- `MAILING_ZIP`
- `PRINCIPAL_LAST`
- `PRINCIPAL_FIRST`
- `PRINCIPAL_MI`
- `PRINCIPAL_TITLE`
- `FEDERAL_DIST_NO`
- `FEDERAL_SCHL_NO`
- `ETS_CEEB_NO`
- `COMMENTS`
- `REGION_CODE`
- `CHARTER_SCHL_STAT`
- `CHARTER_SCHL_OPEN`
- `SCHL_FUNC_SETTING`
- `TITLE_I_STATUS`
- `PRIMARY_SERV_TYPE`
- `DATE_OPENED`
- `DATE_CLOSED`
- `LATITUDE`
- `LONGITUDE`
- `SCHOOL_GRADE`
- `IMPROVEMENT_RATING`
- `AYP`
- `WEB_ADDRESS`
- `EMAIL_ADDRESS_PRI`
- `PROJECTED_OPENING`
- `SUPERINTENDENT_IND`
- `SCHOOL_IMPROVEMENT`
- `SI_TURNAROUND_STATUS`
- `SI_TURNAROUND_YEAR_STATUS`
- `SI_TURNAROUND_CYCLE`
- `SI_TURNAROUND_OPT`
- `SI_REGION_CODE`
- `ACCOUNTABILITY_ESE_CTR`
- `NINE_HUNDRED_ANNUALLY`
- `DJJ_IMPROV_YEAR_STATUS`
- `DJJ_PROV_OPTIONS`
- `CLASSICAL_SCHOOL`
- `ADDED_DATE`
- `ADDED_USERID`
- `CHANGED_DATE`
- `CHANGED_USERID`
- `ACC_CHA_DATE`
- `ACC_CHA_USERID`
- `Unnamed: 76`

Sample first row:

```json
{
  "DISTRICT": "1",
  "SCHOOL": "21",
  "LOCATION_DISTRICT": "1",
  "OFFR_DISTRICT": "1",
  "GM_AGENCY_CODE": "'010",
  "TYPE": "1",
  "ROI_TYPE": "0",
  "YEAR_ROUND_SCHOOL": "N",
  "ACC_TYPE": "00",
  "ACTIVITY_CODE": "C",
  "DISTRICT_NAME": "ALACHUA",
  "LOC_DISTRICT_NAME": "ALACHUA",
  "SCHOOL_NAME_LONG": "CHARLES W. DUVAL ELEMENTARY SCHOOL",
  "SCHOOL_NAME_SHORT": "CHARLES W. DUVAL ELEMENTARY SCHOOL",
  "GRADE_CODE": "15",
  "NEG_DEL_IND": "Z",
  "NEG_DEL_CLASS": null,
  "ACCREDITED_SACS": "N",
  "PHONE_NUMBER": "3529556703",
  "SUNCOM_NUMBER": "6256703",
  "FAX_NUMBER": "3529556967",
  "MAGNET_STATUS": "P",
  "MAGNET_SPECIALTY": "O",
  "MAGNET_PURPOSE": "N",
  "CS_SCHOOL_CHOICE": "Y",
  "PHYSICAL_ADDRESS": "2106 NE 8TH AVE",
  "PHYSICAL_CITY": "GAINESVILLE",
  "PHYSICAL_STATE": "FL",
  "PHYSICAL_ZIP": "32641-4735",
  "MAILING_ADDRESS1": "2106 NE 8TH AVE",
  "MAILING_ADDRESS2": null,
  "MAILING_CITY": "GAINESVILLE",
  "MAILING_STATE": "FL",
  "MAILING_ZIP": "32641-4735",
  "PRINCIPAL_LAST": "BROWN",
  "PRINCIPAL_FIRST": "LAWSON",
  "PRINCIPAL_MI": null,
  "PRINCIPAL_TITLE": "1",
  "FEDERAL_DIST_NO": "1200030",
  "FEDERAL_SCHL_NO": "1",
  "ETS_CEEB_NO": "000000",
  "COMMENTS": null,
  "REGION_CODE": "2",
  "CHARTER_SCHL_STAT": "Z",
  "CHARTER_SCHL_OPEN": null,
  "SCHL_FUNC_SETTING": "Z",
  "TITLE_I_STATUS": null,
  "PRIMARY_SERV_TYPE": "R",
  "DATE_OPENED": null,
  "DATE_CLOSED": "06/30/2015",
  "LATITUDE": "29.66065",
  "LONGITUDE": "-82.29745",
  "SCHOOL_GRADE": null,
  "IMPROVEMENT_RATING": null,
  "AYP": null,
  "WEB_ADDRESS": "http://www.sbac.edu/pages/ACPS",
  "EMAIL_ADDRESS_PRI": "lawson.brown.jr.@gm.sbac.edu",
  "PROJECTED_OPENING": null,
  "SUPERINTENDENT_IND": "Z",
  "SCHOOL_IMPROVEMENT": "0",
  "SI_TURNAROUND_STATUS": "0",
  "SI_TURNAROUND_YEAR_STATUS": "0",
  "SI_TURNAROUND_CYCLE": "0",
  "SI_TURNAROUND_OPT": "0",
  "SI_REGION_CODE": "0",
  "ACCOUNTABILITY_ESE_CTR": "N",
  "NINE_HUNDRED_ANNUALLY": "N",
  "DJJ_IMPROV_YEAR_STATUS": null,
  "DJJ_PROV_OPTIONS": null,
  "CLASSICAL_SCHOOL": null,
  "ADDED_DATE": "07/22/2005",
  "ADDED_USERID": "0",
  "CHANGED_DATE": "07/03/2020",
  "CHANGED_USERID": "1",
  "ACC_CHA_DATE": null,
  "ACC_CHA_USERID": null,
  "Unnamed: 76": null
}
```