Source document

pipeline_miami/findings/fldoe_msid_all_schools.md

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.

fldoe_msid_all_schools — first-fetch findings

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:

{
  "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
}