enrollments
Data source: Big Local News · About: Big Local
2,040 rows where grade = "grade_2" and state = "HI" sorted by school_nces_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
278107 | 278107 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000015 | 317 | KEOLU | Regular School | No | 1 | PK | 6 | 2015 | grade_2 | 23.0 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429214 | 2429214 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000015 | 317 | Keolu Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_2 | 18.0 | 18 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453898 | 2453898 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000015 | 317 | Keolu Elem | Regular School | No | Elementary | PK | 6 | 2021 | grade_2 | 11.0 | 11 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734882 | 2734882 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000015 | 317 | Keolu Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 14.0 | 14 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779932 | 2779932 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000015 | 317 | Keolu Elem | Regular School | No | Elementary | PK | 6 | 2018 | grade_2 | 14.0 | 14 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
108108 | 108108 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000016 | 318 | KING INT | Regular School | No | 2 | 07 | 8 | 2016 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127111 | 127111 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000016 | 318 | KING INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
278093 | 278093 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000016 | 318 | KING INT | Regular School | No | 2 | 07 | 8 | 2015 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429200 | 2429200 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000016 | 318 | King Int | Regular School | No | Middle | 07 | 8 | 2020 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453884 | 2453884 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000016 | 318 | King Int | Regular School | No | Middle | 07 | 8 | 2021 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734868 | 2734868 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000016 | 318 | King Int | Regular School | No | Middle | 07 | 8 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779918 | 2779918 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000016 | 318 | King Int | Regular School | No | Middle | 07 | 8 | 2018 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
108109 | 108109 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000017 | 319 | LAIE | Regular School | No | 1 | PK | 6 | 2016 | grade_2 | 90.0 | 90 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127112 | 127112 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000017 | 319 | LAIE | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 88.0 | 88 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
278094 | 278094 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000017 | 319 | LAIE | Regular School | No | 1 | PK | 6 | 2015 | grade_2 | 86.0 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429201 | 2429201 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000017 | 319 | Laie Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_2 | 91.0 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453885 | 2453885 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000017 | 319 | Laie Elem | Regular School | No | Elementary | PK | 6 | 2021 | grade_2 | 83.0 | 83 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734869 | 2734869 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000017 | 319 | Laie Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 79.0 | 79 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779919 | 2779919 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000017 | 319 | Laie Elem | Regular School | No | Elementary | PK | 6 | 2018 | grade_2 | 86.0 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
108238 | 108238 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000018 | 320 | LANIKAI-PCS | charter | Regular School | Yes | 1 | KG | 6 | 2016 | grade_2 | 50.0 | 50 | |||||||||||||||||||||||||||||||||||||||||||||||||||
127241 | 127241 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000018 | 320 | LANIKAI-PCS | charter | Regular School | Yes | Elementary | KG | 6 | 2017 | grade_2 | 45.0 | 45 | |||||||||||||||||||||||||||||||||||||||||||||||||||
278203 | 278203 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000018 | 320 | LANIKAI-PCS | charter | Regular School | Yes | 1 | KG | 6 | 2015 | grade_2 | 48.0 | 48 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2429323 | 2429323 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000018 | 320 | Kaohao PCS | charter | Regular School | Yes | Elementary | PK | 6 | 2020 | grade_2 | 47.0 | 47 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2454007 | 2454007 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000018 | 320 | Kaohao PCS | charter | Regular School | Yes | Elementary | PK | 6 | 2021 | grade_2 | 40.0 | 40 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2734978 | 2734978 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000018 | 320 | Kaohao PCS | charter | Regular School | Yes | Elementary | PK | 6 | 2019 | grade_2 | 43.0 | 43 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2780039 | 2780039 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000018 | 320 | Kaohao PCS | charter | Regular School | Yes | Elementary | PK | 6 | 2018 | grade_2 | 44.0 | 44 | |||||||||||||||||||||||||||||||||||||||||||||||||||
108123 | 108123 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000019 | 321 | MAUNAWILI | Regular School | No | 1 | PK | 6 | 2016 | grade_2 | 53.0 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127126 | 127126 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000019 | 321 | MAUNAWILI | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 36.0 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
278108 | 278108 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000019 | 321 | MAUNAWILI | Regular School | No | 1 | PK | 6 | 2015 | grade_2 | 53.0 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429215 | 2429215 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000019 | 321 | Maunawili Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_2 | 53.0 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453899 | 2453899 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000019 | 321 | Maunawili Elem | Regular School | No | Elementary | PK | 6 | 2021 | grade_2 | 42.0 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734883 | 2734883 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000019 | 321 | Maunawili Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 50.0 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779933 | 2779933 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000019 | 321 | Maunawili Elem | Regular School | No | Elementary | PK | 6 | 2018 | grade_2 | 43.0 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
108124 | 108124 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000020 | 322 | MOKAPU | Regular School | No | 1 | PK | 6 | 2016 | grade_2 | 126.0 | 126 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127127 | 127127 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000020 | 322 | MOKAPU | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 122.0 | 122 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
278109 | 278109 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000020 | 322 | MOKAPU | Regular School | No | 1 | PK | 6 | 2015 | grade_2 | 134.0 | 134 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429216 | 2429216 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000020 | 322 | Mokapu Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_2 | 134.0 | 134 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453900 | 2453900 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000020 | 322 | Mokapu Elem | Regular School | No | Elementary | PK | 6 | 2021 | grade_2 | 102.0 | 102 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734884 | 2734884 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000020 | 322 | Mokapu Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 132.0 | 132 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779934 | 2779934 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000020 | 322 | Mokapu Elem | Regular School | No | Elementary | PK | 6 | 2018 | grade_2 | 112.0 | 112 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
108110 | 108110 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000021 | 323 | PARKER | Regular School | No | 1 | PK | 6 | 2016 | grade_2 | 43.0 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127113 | 127113 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000021 | 323 | PARKER | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 41.0 | 41 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
278095 | 278095 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000021 | 323 | PARKER | Regular School | No | 1 | PK | 6 | 2015 | grade_2 | 33.0 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429202 | 2429202 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000021 | 323 | Parker Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_2 | 40.0 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453886 | 2453886 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000021 | 323 | Parker Elem | Regular School | No | Elementary | PK | 6 | 2021 | grade_2 | 39.0 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734870 | 2734870 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000021 | 323 | Parker Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 31.0 | 31 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779920 | 2779920 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000021 | 323 | Parker Elem | Regular School | No | Elementary | PK | 6 | 2018 | grade_2 | 43.0 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
108126 | 108126 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000022 | 324 | POPE | Regular School | No | 1 | PK | 6 | 2016 | grade_2 | 21.0 | 21 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127129 | 127129 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000022 | 324 | POPE | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 35.0 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
278111 | 278111 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000022 | 324 | POPE | Regular School | No | 1 | PK | 6 | 2015 | grade_2 | 26.0 | 26 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429218 | 2429218 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000022 | 324 | Pope Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_2 | 30.0 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453902 | 2453902 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000022 | 324 | Pope Elem | Regular School | No | Elementary | PK | 6 | 2021 | grade_2 | 23.0 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734886 | 2734886 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000022 | 324 | Pope Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 27.0 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779936 | 2779936 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000022 | 324 | Pope Elem | Regular School | No | Elementary | PK | 6 | 2018 | grade_2 | 31.0 | 31 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
108111 | 108111 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000023 | 314 | PUOHALA | Regular School | No | 1 | PK | 6 | 2016 | grade_2 | 47.0 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127114 | 127114 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000023 | 314 | PUOHALA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 23.0 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
278096 | 278096 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000023 | 314 | PUOHALA | Regular School | No | 1 | PK | 6 | 2015 | grade_2 | 42.0 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429203 | 2429203 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000023 | 314 | Puohala Elem | Regular School | No | Elementary | PK | 8 | 2020 | grade_2 | 35.0 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453887 | 2453887 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000023 | 314 | Puohala Elem | Regular School | No | Elementary | PK | 8 | 2021 | grade_2 | 40.0 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734871 | 2734871 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000023 | 314 | Puohala Elem | Regular School | No | Elementary | PK | 7 | 2019 | grade_2 | 35.0 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779921 | 2779921 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000023 | 314 | Puohala Elem | Regular School | No | Elementary | PK | 6 | 2018 | grade_2 | 40.0 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
108112 | 108112 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000024 | 325 | SUNSET BEACH | Regular School | No | 1 | PK | 6 | 2016 | grade_2 | 61.0 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127115 | 127115 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000024 | 325 | SUNSET BEACH | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 67.0 | 67 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
278097 | 278097 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000024 | 325 | SUNSET BEACH | Regular School | No | 1 | PK | 6 | 2015 | grade_2 | 62.0 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429204 | 2429204 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000024 | 325 | Sunset Beach Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_2 | 62.0 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453888 | 2453888 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000024 | 325 | Sunset Beach Elem | Regular School | No | Elementary | PK | 6 | 2021 | grade_2 | 48.0 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734872 | 2734872 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000024 | 325 | Sunset Beach Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 41.0 | 41 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779922 | 2779922 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000024 | 325 | Sunset Beach Elem | Regular School | No | Elementary | PK | 6 | 2018 | grade_2 | 58.0 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
108113 | 108113 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000025 | 326 | WAIAHOLE | Regular School | No | 1 | PK | 6 | 2016 | grade_2 | 5.0 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127116 | 127116 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000025 | 326 | WAIAHOLE | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 8.0 | 8 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
278098 | 278098 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000025 | 326 | WAIAHOLE | Regular School | No | 1 | PK | 6 | 2015 | grade_2 | 15.0 | 15 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429205 | 2429205 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000025 | 326 | Waiahole Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_2 | 18.0 | 18 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453889 | 2453889 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000025 | 326 | Waiahole Elem | Regular School | No | Elementary | PK | 6 | 2021 | grade_2 | 16.0 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734873 | 2734873 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000025 | 326 | Waiahole Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 9.0 | 9 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779923 | 2779923 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000025 | 326 | Waiahole Elem | Regular School | No | Elementary | PK | 6 | 2018 | grade_2 | 16.0 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
108127 | 108127 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000026 | 327 | WAIMANALO EL & INT | Regular School | No | 1 | PK | 8 | 2016 | grade_2 | 36.0 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127130 | 127130 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000026 | 327 | WAIMANALO EL & INT | Regular School | No | Elementary | PK | 8 | 2017 | grade_2 | 34.0 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
278112 | 278112 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000026 | 327 | WAIMANALO EL & INT | Regular School | No | 1 | PK | 8 | 2015 | grade_2 | 52.0 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429219 | 2429219 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000026 | 327 | Waimanalo El & Int | Regular School | No | Elementary | PK | 8 | 2020 | grade_2 | 43.0 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453903 | 2453903 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000026 | 327 | Waimanalo El & Int | Regular School | No | Elementary | PK | 8 | 2021 | grade_2 | 26.0 | 26 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734887 | 2734887 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000026 | 327 | Waimanalo El & Int | Regular School | No | Elementary | PK | 8 | 2019 | grade_2 | 28.0 | 28 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779937 | 2779937 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000026 | 327 | Waimanalo El & Int | Regular School | No | Elementary | PK | 8 | 2018 | grade_2 | 30.0 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
108128 | 108128 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000027 | 351 | DE SILVA | Regular School | No | 1 | PK | 6 | 2016 | grade_2 | 75.0 | 75 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127131 | 127131 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000027 | 351 | DE SILVA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 56.0 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
278113 | 278113 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000027 | 351 | DE SILVA | Regular School | No | 1 | PK | 6 | 2015 | grade_2 | 57.0 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429220 | 2429220 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000027 | 351 | de Silva Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_2 | 72.0 | 72 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453904 | 2453904 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000027 | 351 | de Silva Elem | Regular School | No | Elementary | PK | 6 | 2021 | grade_2 | 56.0 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734888 | 2734888 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000027 | 351 | de Silva Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 68.0 | 68 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779938 | 2779938 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000027 | 351 | de Silva Elem | Regular School | No | Elementary | PK | 6 | 2018 | grade_2 | 64.0 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
108129 | 108129 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000028 | 352 | HAAHEO | Regular School | No | 1 | PK | 6 | 2016 | grade_2 | 25.0 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127132 | 127132 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000028 | 352 | HAAHEO | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 27.0 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
278114 | 278114 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000028 | 352 | HAAHEO | Regular School | No | 1 | PK | 6 | 2015 | grade_2 | 23.0 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429221 | 2429221 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000028 | 352 | Haaheo Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_2 | 25.0 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453905 | 2453905 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000028 | 352 | Haaheo Elem | Regular School | No | Elementary | PK | 6 | 2021 | grade_2 | 22.0 | 22 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734889 | 2734889 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000028 | 352 | Haaheo Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 25.0 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779939 | 2779939 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000028 | 352 | Haaheo Elem | Regular School | No | Elementary | PK | 6 | 2018 | grade_2 | 26.0 | 26 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
108130 | 108130 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000029 | 355 | HILO HI | Regular School | No | 3 | 09 | 12 | 2016 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127133 | 127133 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000029 | 355 | HILO HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
278115 | 278115 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000029 | 355 | HILO HI | Regular School | No | 3 | 09 | 12 | 2015 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429222 | 2429222 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000029 | 355 | Hilo High | Regular School | No | High | 09 | 12 | 2020 | grade_2 | 0.0 | 0 |
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]);