# fldoe_absent21_10pct_2017-18 — first-fetch findings

- publisher: Florida Department of Education, PK-12 Education Information Services
- url: https://www.fldoe.org/file/7584/1718ABS21Days10Comparison.xlsx
- format: xlsx
- local path: `data/cities/miami/sources/fldoe_absent21_10pct_2017-18/2026-09-15/1718ABS21Days10Comparison.xlsx`

## Sheets (3)
- `District`
- `Schools`
- `NOTES`

### `District` (header row None)
No header detected in the first 15 rows; first rows:
```json
[
 [
  "Students Absent 21 or More Days and Absent 10% or More Compa",
  null,
  null,
  null,
  null,
  null,
  null,
  null
 ],
 [
  "*Note:  Beginning with the 2017-18 academic year, students p",
  null,
  null,
  null,
  null,
  null,
  null,
  null
 ],
 [
  "Please see NOTES for Comparsion Methodology\nThis report incl",
  null,
  null,
  null,
  null,
  null,
  null,
  null
 ],
 [
  "District #",
  "District Name",
  "Total Enrollment",
  "# of Students Absent 21 or More Days",
  "% of Students Absent 21 or More Days",
  "# of Students Enrolled 10 or More Days",
  "# of Students Absent 10% or More",
  "% of Students Absent 10% or More"
 ]
]
```

### `Schools` (header row 1)
- `Students Absent 21 or More Days and Absent 10% or More Comparison by School
2017-18, Final Survey 5`
- `Unnamed: 1`
- `Unnamed: 2`
- `Unnamed: 3`
- `Unnamed: 4`
- `Unnamed: 5`
- `Unnamed: 6`
- `Unnamed: 7`
- `Unnamed: 8`
- `Unnamed: 9`

Sample first row:

```json
{
  "Students Absent 21 or More Days and Absent 10% or More Comparison by School\n2017-18, Final Survey 5": "Note:  Beginning with the 2017-18 academic year, students previously reported under Washington Special (District 69)/Okeechobee Youth Develop Center (School 0011) are reported under Washington (District 67) /Okeechobee Youth Development Center (School 6911).\n*To provide meaningful results and to protect the privacy of individual students, data are displayed only when the total number of students in a group is at least 10 \nand when the performance of individuals would not be disclosed. Data for groups less than 10 are displayed with an asterisk (*).",
  "Unnamed: 1": null,
  "Unnamed: 2": null,
  "Unnamed: 3": null,
  "Unnamed: 4": null,
  "Unnamed: 5": null,
  "Unnamed: 6": null,
  "Unnamed: 7": null,
  "Unnamed: 8": null,
  "Unnamed: 9": null
}
```

### `NOTES` (header row 2)
- `NOTES:

This report includes public PK-12 and grades 30 and 31.

Absent 21 or more days: 

• Total Enrollment (unduplicated count of all students enrolled in each school during the school year)
• # of Students Absent 21 or more days = Sum of Days Absent, annual is 21 or more days
• % of students absent 21 or more Days 
     o  # of Students Absent 21 or more days/Total Enrollment

Absent 10 % or more

• Total Enrollment for Students Enrolled 10 or more Days (unduplicated count of students enrolled at least 10 days in each school during the school year)
     o Days Enrolled = Sum of Days Absent, annual + Sum of Days Present, annual;
• # of students Absent 10% or more days
     o Percent Absent = Sum of Days Absent, annual/Days Enrolled 
• % of students Absent 10% or more days
     o # of students Absent 10% or more days/Total Enrollment for Students Enrolled 10 or more days


`