enrollments
Data source: Big Local News · About: Big Local
2,040 rows where grade = "grade_1" and state = "HI" sorted by school_state_id
This data as json, CSV (advanced)
Link | rowid | state | county | county_state_id | admin_level | district_nces_id | district_state_id | district_state_type | district | school_nces_id | school_state_id ▼ | school | school_state_type | ccd_school_type | ccd_charter_school | ccd_school_lvl | ccd_school_low_grade | ccd_school_high_grade | year | term | grade | white | black | hispanic | native_american | native_american_alaskan_native | asian | native_hawaiian | asian_pacific_islander | native_hawaiian_pacific_islander | pacific_islander | multiracial | unknown_race | male | female | non_binary | unknown_gender | ell | ell_percent | homeless | homeless_percent | low_income | free_and_reduced | free_and_reduced_percent | disability | section_504 | total | white_int | black_int | hispanic_int | native_american_int | native_american_alaskan_native_int | asian_int | native_hawaiian_int | asian_pacific_islander_int | native_hawaiian_pacific_islander_int | pacific_islander_int | multiracial_int | unknown_race_int | male_int | female_int | non_binary_int | unknown_gender_int | ell_int | homeless_int | low_income_int | free_and_reduced_int | disability_int | section_504_int | total_int |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
107670 | 107670 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | 1 | PK | 5 | 2016 | grade_1 | 55.0 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126673 | 126673 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 71.0 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
277657 | 277657 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | 1 | PK | 5 | 2015 | grade_1 | 83.0 | 83 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428759 | 2428759 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_1 | 77.0 | 77 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453441 | 2453441 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_1 | 65.0 | 65 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734428 | 2734428 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_1 | 71.0 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779478 | 2779478 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_1 | 86.0 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
107695 | 107695 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | 1 | PK | 5 | 2016 | grade_1 | 45.0 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126698 | 126698 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 70.0 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
277682 | 277682 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | 1 | PK | 5 | 2015 | grade_1 | 64.0 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428784 | 2428784 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_1 | 59.0 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453466 | 2453466 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_1 | 51.0 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734453 | 2734453 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_1 | 61.0 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779503 | 2779503 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_1 | 55.0 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
107696 | 107696 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | 1 | PK | 5 | 2016 | grade_1 | 19.0 | 19 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126699 | 126699 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 38.0 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
277683 | 277683 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | 1 | PK | 5 | 2015 | grade_1 | 42.0 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428785 | 2428785 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_1 | 35.0 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453467 | 2453467 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_1 | 35.0 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734454 | 2734454 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_1 | 36.0 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779504 | 2779504 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_1 | 32.0 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
107697 | 107697 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | 4 | PK | 12 | 2016 | grade_1 | 29.0 | 29 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126700 | 126700 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | Other | PK | 12 | 2017 | grade_1 | 50.0 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
277684 | 277684 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | 4 | PK | 12 | 2015 | grade_1 | 55.0 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428786 | 2428786 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | grade_1 | 72.0 | 72 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453468 | 2453468 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | grade_1 | 51.0 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734455 | 2734455 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2019 | grade_1 | 54.0 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779505 | 2779505 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2018 | grade_1 | 56.0 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
107698 | 107698 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126701 | 126701 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
277685 | 277685 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428787 | 2428787 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453469 | 2453469 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734456 | 2734456 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779506 | 2779506 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
107671 | 107671 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126674 | 126674 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
277658 | 277658 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428760 | 2428760 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453442 | 2453442 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734429 | 2734429 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779479 | 2779479 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
107672 | 107672 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | 3 | 09 | 12 | 2016 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126675 | 126675 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | High | 09 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
277659 | 277659 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | 3 | 09 | 12 | 2015 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428761 | 2428761 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453443 | 2453443 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734430 | 2734430 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779480 | 2779480 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2018 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
107673 | 107673 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | FERN | Regular School | No | 1 | PK | 5 | 2016 | grade_1 | 48.0 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126676 | 126676 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | FERN | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 55.0 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
277660 | 277660 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | FERN | Regular School | No | 1 | PK | 5 | 2015 | grade_1 | 44.0 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428762 | 2428762 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_1 | 53.0 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453444 | 2453444 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_1 | 45.0 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734431 | 2734431 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_1 | 46.0 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779481 | 2779481 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_1 | 45.0 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
107674 | 107674 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | HAHAIONE | Regular School | No | 1 | PK | 5 | 2016 | grade_1 | 93.0 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126677 | 126677 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | HAHAIONE | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 77.0 | 77 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
277661 | 277661 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | HAHAIONE | Regular School | No | 1 | PK | 5 | 2015 | grade_1 | 75.0 | 75 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428763 | 2428763 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | Hahaione Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_1 | 83.0 | 83 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453445 | 2453445 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | Hahaione Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_1 | 92.0 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734432 | 2734432 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | Hahaione Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_1 | 78.0 | 78 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779482 | 2779482 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | Hahaione Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_1 | 83.0 | 83 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
107699 | 107699 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | HOKULANI | Regular School | No | 1 | PK | 5 | 2016 | grade_1 | 49.0 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126702 | 126702 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | HOKULANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 63.0 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
277686 | 277686 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | HOKULANI | Regular School | No | 1 | PK | 5 | 2015 | grade_1 | 66.0 | 66 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428788 | 2428788 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | Hokulani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_1 | 62.0 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453470 | 2453470 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | Hokulani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_1 | 48.0 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734457 | 2734457 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | Hokulani Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_1 | 46.0 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779507 | 2779507 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | Hokulani Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_1 | 64.0 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
107700 | 107700 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | JARRETT MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126703 | 126703 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | JARRETT MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
277687 | 277687 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | JARRETT MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428789 | 2428789 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453471 | 2453471 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734458 | 2734458 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779508 | 2779508 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
107701 | 107701 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | JEFFERSON | Regular School | No | 1 | PK | 5 | 2016 | grade_1 | 53.0 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126704 | 126704 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | JEFFERSON | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 62.0 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
277688 | 277688 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | JEFFERSON | Regular School | No | 1 | PK | 5 | 2015 | grade_1 | 76.0 | 76 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428790 | 2428790 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | Jefferson Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_1 | 62.0 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453472 | 2453472 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | Jefferson Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_1 | 40.0 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734459 | 2734459 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | Jefferson Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_1 | 57.0 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779509 | 2779509 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | Jefferson Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_1 | 46.0 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
107702 | 107702 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | KAAHUMANU | Regular School | No | 1 | PK | 5 | 2016 | grade_1 | 55.0 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126705 | 126705 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | KAAHUMANU | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 91.0 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
277689 | 277689 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | KAAHUMANU | Regular School | No | 1 | PK | 5 | 2015 | grade_1 | 90.0 | 90 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428791 | 2428791 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | Kaahumanu Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_1 | 86.0 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453473 | 2453473 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | Kaahumanu Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_1 | 67.0 | 67 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734460 | 2734460 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | Kaahumanu Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_1 | 81.0 | 81 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779510 | 2779510 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | Kaahumanu Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_1 | 60.0 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
107676 | 107676 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | KAEWAI | Regular School | No | 1 | PK | 5 | 2016 | grade_1 | 25.0 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126679 | 126679 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | KAEWAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 51.0 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
277663 | 277663 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | KAEWAI | Regular School | No | 1 | PK | 5 | 2015 | grade_1 | 57.0 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428765 | 2428765 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | Kaewai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_1 | 45.0 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453447 | 2453447 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | Kaewai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_1 | 48.0 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734434 | 2734434 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | Kaewai Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_1 | 40.0 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779484 | 2779484 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | Kaewai Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_1 | 40.0 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
107677 | 107677 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000215 | 114 | KAHALA | Regular School | No | 1 | PK | 5 | 2016 | grade_1 | 32.0 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126680 | 126680 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000215 | 114 | KAHALA | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 61.0 | 61 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "enrollments" ( [state] TEXT, [county] TEXT, [county_state_id] INTEGER, [admin_level] TEXT, [district_nces_id] INTEGER, [district_state_id] TEXT, [district_state_type] TEXT, [district] TEXT, [school_nces_id] INTEGER, [school_state_id] INTEGER, [school] TEXT, [school_state_type] TEXT, [ccd_school_type] TEXT, [ccd_charter_school] TEXT, [ccd_school_lvl] TEXT, [ccd_school_low_grade] TEXT, [ccd_school_high_grade] TEXT, [year] INTEGER, [term] TEXT, [grade] TEXT, [white] TEXT, [black] TEXT, [hispanic] TEXT, [native_american] TEXT, [native_american_alaskan_native] TEXT, [asian] TEXT, [native_hawaiian] TEXT, [asian_pacific_islander] TEXT, [native_hawaiian_pacific_islander] TEXT, [pacific_islander] TEXT, [multiracial] TEXT, [unknown_race] TEXT, [male] TEXT, [female] TEXT, [non_binary] TEXT, [unknown_gender] TEXT, [ell] TEXT, [ell_percent] TEXT, [homeless] TEXT, [homeless_percent] TEXT, [low_income] TEXT, [free_and_reduced] TEXT, [free_and_reduced_percent] TEXT, [disability] TEXT, [section_504] TEXT, [total] TEXT , [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER); CREATE INDEX [idx_enrollments_state_grade] ON [enrollments] ([state], [grade]); CREATE INDEX [idx_enrollments_grade] ON [enrollments] ([grade]); CREATE INDEX [idx_enrollments_year] ON [enrollments] ([year]); CREATE INDEX [idx_enrollments_state_year] ON [enrollments] ([state], [year]); CREATE INDEX [idx_enrollments_school_nces_id] ON [enrollments] ([school_nces_id]); CREATE INDEX [idx_enrollments_district_nces_id] ON [enrollments] ([district_nces_id]);