enrollments
Data source: Big Local News · About: Big Local
292 rows where grade = "grade_6", state = "HI" and year = 2019 sorted by school
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2736026 | 2736026 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | Ahuimanu Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 37.0 | 37 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735941 | 2735941 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 52.0 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735942 | 2735942 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | Aiea High | Regular School | No | High | 09 | 12 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735943 | 2735943 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | Aiea Int | Regular School | No | Middle | 07 | 8 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736042 | 2736042 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | Aikahi Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 41.0 | 41 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735888 | 2735888 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735913 | 2735913 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736171 | 2736171 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000304 | 558 | Alakai O Kauai PCS | charter | Regular School | Yes | Elementary | KG | 5 | 2019 | grade_6 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735944 | 2735944 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000175 | 203 | Aliamanu Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 99.0 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735945 | 2735945 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000174 | 204 | Aliamanu Middle | Regular School | No | Middle | 07 | 8 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735914 | 2735914 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735915 | 2735915 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2019 | grade_6 | 34.0 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736009 | 2736009 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | August Ahrens Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 189.0 | 189 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736097 | 2736097 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000056 | 400 | Baldwin High | Regular School | No | High | 09 | 12 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735983 | 2735983 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000135 | 251 | Barbers Point Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735984 | 2735984 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000134 | 252 | Campbell High | Regular School | No | High | 09 | 12 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736027 | 2736027 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | Castle High | Regular School | No | High | 09 | 12 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735916 | 2735916 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 127.0 | 127 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736149 | 2736149 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000262 | 396 | Connections NCPCS | charter | Regular School | Yes | Other | KG | 12 | 2019 | grade_6 | 20.0 | 20 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735889 | 2735889 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 218.0 | 218 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736128 | 2736128 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000081 | 451 | Eleele Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736043 | 2736043 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | Enchanted Lake Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 37.0 | 37 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735985 | 2735985 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000132 | 254 | Ewa Beach Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 116.0 | 116 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735986 | 2735986 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000133 | 253 | Ewa Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 171.0 | 171 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735987 | 2735987 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | Ewa Makai Middle | Regular School | No | Middle | 07 | 8 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735890 | 2735890 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735891 | 2735891 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736057 | 2736057 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000028 | 352 | Haaheo Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 24.0 | 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735892 | 2735892 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | Hahaione Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736098 | 2736098 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000057 | 401 | Haiku Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736160 | 2736160 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000275 | 546 | Hakipuu Learning Ctr PCS | charter | Regular School | Yes | Other | 04 | 12 | 2019 | grade_6 | 3.0 | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736155 | 2736155 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000270 | 540 | Halau Ku Mana NCPCS | charter | Regular School | Yes | Other | 04 | 12 | 2019 | grade_6 | 15.0 | 15 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735963 | 2735963 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000172 | 206 | Haleiwa Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 29.0 | 29 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736117 | 2736117 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000058 | 402 | Hana High & Elem | Regular School | No | Other | PK | 12 | 2019 | grade_6 | 23.0 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736129 | 2736129 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000082 | 452 | Hanalei Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 29.0 | 29 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736028 | 2736028 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000002 | 303 | Hauula Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 31.0 | 31 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736173 | 2736173 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000282 | 561 | Hawaii Academy of Arts & Science PCS | charter | Regular School | Yes | Other | KG | 12 | 2019 | grade_6 | 49.0 | 49 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735893 | 2735893 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000096 | 470 | Hawaii School for the Deaf and Blind | Special Education School | No | Other | PK | 12 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736165 | 2736165 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000295 | 551 | Hawaii Tech Acad PCS | charter | Regular School | Yes | Other | KG | 12 | 2019 | grade_6 | 90.0 | 90 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736029 | 2736029 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000003 | 304 | Heeia Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 63.0 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735964 | 2735964 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000171 | 208 | Helemano Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735946 | 2735946 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000170 | 209 | Hickam Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 60.0 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736010 | 2736010 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000131 | 255 | Highlands Int | Regular School | No | Middle | 07 | 8 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736058 | 2736058 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000029 | 355 | Hilo High | Regular School | No | High | 09 | 12 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736059 | 2736059 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000030 | 356 | Hilo Int | Regular School | No | Middle | 07 | 8 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736060 | 2736060 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000031 | 357 | Hilo Union Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 56.0 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735917 | 2735917 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | Hokulani Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735988 | 2735988 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000248 | 280 | Holomua Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 165.0 | 165 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736069 | 2736069 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000032 | 358 | Holualoa Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736070 | 2736070 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000033 | 359 | Honaunau Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736071 | 2736071 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000249 | 361 | Honokaa Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 58.0 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736072 | 2736072 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000034 | 360 | Honokaa High & Int | Regular School | No | High | 07 | 12 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736011 | 2736011 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000130 | 276 | Honowai Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 105.0 | 105 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735989 | 2735989 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000300 | 293 | Hookele Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736073 | 2736073 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000035 | 363 | Hookena Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736099 | 2736099 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | Iao Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 340.0 | 340 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735965 | 2735965 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000169 | 210 | Iliahi Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735990 | 2735990 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000129 | 279 | Ilima Int | Regular School | No | Middle | 07 | 8 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736162 | 2736162 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000277 | 548 | Innovations PCS | charter | Regular School | Yes | Elementary | KG | 8 | 2019 | grade_6 | 23.0 | 23 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735966 | 2735966 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000173 | 207 | Inouye Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735991 | 2735991 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000128 | 256 | Iroquois Point Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 82.0 | 82 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735918 | 2735918 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 87.0 | 87 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735919 | 2735919 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | Jefferson Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736174 | 2736174 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000283 | 562 | Ka Umeke Kaeo PCS | charter | Regular School | Yes | Other | PK | 10 | 2019 | grade_6 | 22.0 | 22 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736159 | 2736159 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000286 | 545 | Ka Waihona o ka Naauao NCPCS | charter | Regular School | Yes | Elementary | KG | 8 | 2019 | grade_6 | 78.0 | 78 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736030 | 2736030 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000004 | 305 | Kaaawa Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 15.0 | 15 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735920 | 2735920 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | Kaahumanu Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735967 | 2735967 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000168 | 211 | Kaala Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736044 | 2736044 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000005 | 330 | Kaelepulu Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 16.0 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735894 | 2735894 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | Kaewai Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736074 | 2736074 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000232 | 371 | Kahakai Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735895 | 2735895 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000215 | 114 | Kahala Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736031 | 2736031 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000006 | 306 | Kahaluu Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 36.0 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736032 | 2736032 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000236 | 331 | Kahuku Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 73.0 | 73 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736033 | 2736033 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000007 | 307 | Kahuku High & Int | Regular School | No | High | 07 | 12 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736100 | 2736100 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000060 | 405 | Kahului Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736045 | 2736045 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000008 | 308 | Kailua Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 42.0 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736046 | 2736046 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000009 | 309 | Kailua High | Regular School | No | High | 09 | 12 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736047 | 2736047 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000010 | 310 | Kailua Int | Regular School | No | Middle | 07 | 8 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735992 | 2735992 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000127 | 281 | Kaimiloa Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 100.0 | 100 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735921 | 2735921 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000212 | 115 | Kaimuki High | Regular School | No | High | 09 | 12 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735896 | 2735896 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 326.0 | 326 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736048 | 2736048 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000011 | 311 | Kainalu Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 54.0 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735897 | 2735897 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000228 | 154 | Kaiser High | Regular School | No | High | 09 | 12 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735922 | 2735922 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000165 | 117 | Kaiulani Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736130 | 2736130 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000083 | 453 | Kalaheo Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736049 | 2736049 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000012 | 312 | Kalaheo High | Regular School | No | High | 09 | 12 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735898 | 2735898 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 337.0 | 337 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736101 | 2736101 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | Kalama Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 273.0 | 273 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735899 | 2735899 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000163 | 119 | Kalani High | Regular School | No | High | 09 | 12 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736061 | 2736061 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000036 | 365 | Kalanianaole El & Int | Regular School | No | Elementary | PK | 8 | 2019 | grade_6 | 32.0 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736012 | 2736012 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000239 | 287 | Kaleiopuu Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 139.0 | 139 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735900 | 2735900 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000162 | 120 | Kalihi Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735901 | 2735901 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000160 | 121 | Kalihi Kai Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735902 | 2735902 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000210 | 122 | Kalihi Uka Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735903 | 2735903 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000209 | 123 | Kalihi Waena Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736145 | 2736145 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000240 | 275 | Kamaile Academy PCS | charter | Regular School | Yes | Other | PK | 12 | 2019 | grade_6 | 80.0 | 80 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736131 | 2736131 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | Kamakahelei Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 311.0 | 311 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736166 | 2736166 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000303 | 553 | Kamalani Academy | charter | Regular School | Yes | Elementary | PK | 8 | 2019 | grade_6 | 27.0 | 27 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736102 | 2736102 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000253 | 431 | Kamalii Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_6 | 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]);