Skip to contents

Fetch Florida school directory data

Source: R/fetch_directory.R
fetch_directory.Rd

Downloads and processes school directory data from the Florida Department of Education Master School ID (MSID) database. This includes all public schools and districts with contact information, principal names, addresses, charter status, and grade levels.

Usage

fetch_directory(end_year = NULL, tidy = TRUE, use_cache = TRUE)

Arguments

end_year

Currently unused. The directory data represents the current school year and is updated regularly by FLDOE. Included for API consistency with other fetch functions.

tidy

If TRUE (default), returns data in a standardized format with consistent column names. If FALSE, returns raw column names from FLDOE.

use_cache

If TRUE (default), uses locally cached data when available. Set to FALSE to force re-download from FLDOE.

Value

A tibble with school directory data. When tidy = TRUE, columns include:

  • state_district_id: 2-digit district number (zero-padded)

  • state_school_id: Combined district-school ID (format "DD-SSSS")

  • district_name: District (county) name

  • school_name: Full school name

  • entity_type: "district", "school", or "charter"

  • address: Physical street address

  • city: City

  • state: State (always "FL")

  • zip: ZIP code

  • phone: Phone number

  • county_name: County (same as district for FL)

  • grades_served: FLDOE grade code

  • principal_name: School principal name

  • principal_email: Principal email address

  • superintendent_name: NA (not in MSID data; available on FLDOE website)

  • superintendent_email: NA (not in MSID data; available on FLDOE website)

  • website: School web address

  • charter_status: Charter school status code

  • activity_code: A = Active, C = Closed, F = Future

  • latitude: Geographic latitude

  • longitude: Geographic longitude

Details

The directory data is downloaded from the FLDOE's Education Data Systems (EDS) Master School Identification (MSID) database. This file is updated regularly by FLDOE and contains every public school in Florida.

Superintendent names and emails are NOT included in the MSID download. That information is available only on the FLDOE superintendent list webpage at https://www.fldoe.org/accountability/data-sys/school-dis-data/superintendents.stml. Those columns are included as NA for schema consistency with other state packages.

Examples

if (FALSE) { # \dontrun{
# Get school directory data
dir_data <- fetch_directory()

# Get raw format (original FLDOE column names)
dir_raw <- fetch_directory(tidy = FALSE)

# Force fresh download (ignore cache)
dir_fresh <- fetch_directory(use_cache = FALSE)

# Filter to active schools only
library(dplyr)
active_schools <- dir_data |>
  filter(activity_code == "A")

# Find all schools in Miami-Dade (district 13)
miami_dade <- dir_data |>
  filter(state_district_id == "13")

# Find charter schools
charters <- dir_data |>
  filter(entity_type == "charter")
} # }