enrollments
Data source: Big Local News · About: Big Local
4,350 rows where state = "HI" and year = 2017 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
126383 | 126383 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | kindergarten | 85.0 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126963 | 126963 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 51.0 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127253 | 127253 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_3 | 74.0 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127543 | 127543 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_4 | 86.0 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127833 | 127833 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_5 | 80.0 | 80 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128123 | 128123 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128413 | 128413 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128703 | 128703 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128993 | 128993 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129283 | 129283 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129573 | 129573 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129863 | 129863 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130153 | 130153 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | pre_kindergarten | 4.0 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130443 | 130443 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | pk_12_total | 41.0 | 492.0 | 41 | 492 | ||||||||||||||||||||||||||||||||||||||||||||||||||
126408 | 126408 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | Elementary | PK | 5 | 2017 | kindergarten | 62.0 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126988 | 126988 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 38.0 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127278 | 127278 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_3 | 71.0 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127568 | 127568 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_4 | 65.0 | 65 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127858 | 127858 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_5 | 64.0 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128148 | 128148 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128438 | 128438 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128728 | 128728 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129018 | 129018 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129308 | 129308 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129598 | 129598 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129888 | 129888 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130178 | 130178 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | Elementary | PK | 5 | 2017 | pre_kindergarten | 10.0 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130468 | 130468 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | Elementary | PK | 5 | 2017 | pk_12_total | 33.0 | 413.0 | 33 | 413 | ||||||||||||||||||||||||||||||||||||||||||||||||||
126409 | 126409 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | Elementary | PK | 5 | 2017 | kindergarten | 31.0 | 31 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126989 | 126989 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 19.0 | 19 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127279 | 127279 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_3 | 36.0 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127569 | 127569 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_4 | 35.0 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127859 | 127859 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_5 | 27.0 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128149 | 128149 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128439 | 128439 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128729 | 128729 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129019 | 129019 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129309 | 129309 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129599 | 129599 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129889 | 129889 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130179 | 130179 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | Elementary | PK | 5 | 2017 | pre_kindergarten | 7.0 | 7 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130469 | 130469 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | Elementary | PK | 5 | 2017 | pk_12_total | 23.0 | 216.0 | 23 | 216 | ||||||||||||||||||||||||||||||||||||||||||||||||||
126410 | 126410 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | Other | PK | 12 | 2017 | kindergarten | 54.0 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126990 | 126990 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | Other | PK | 12 | 2017 | grade_2 | 30.0 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127280 | 127280 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | Other | PK | 12 | 2017 | grade_3 | 48.0 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127570 | 127570 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | Other | PK | 12 | 2017 | grade_4 | 35.0 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127860 | 127860 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | Other | PK | 12 | 2017 | grade_5 | 43.0 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128150 | 128150 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | Other | PK | 12 | 2017 | grade_6 | 32.0 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128440 | 128440 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | Other | PK | 12 | 2017 | grade_7 | 28.0 | 28 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128730 | 128730 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | Other | PK | 12 | 2017 | grade_8 | 30.0 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129020 | 129020 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | Other | PK | 12 | 2017 | grade_9 | 24.0 | 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129310 | 129310 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | Other | PK | 12 | 2017 | grade_10 | 16.0 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129600 | 129600 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | Other | PK | 12 | 2017 | grade_11 | 12.0 | 12 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129890 | 129890 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | Other | PK | 12 | 2017 | grade_12 | 10.0 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130180 | 130180 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | Other | PK | 12 | 2017 | pre_kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130470 | 130470 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | Other | PK | 12 | 2017 | pk_12_total | 23.0 | 435.0 | 23 | 435 | ||||||||||||||||||||||||||||||||||||||||||||||||||
126411 | 126411 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | kindergarten | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126991 | 126991 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127281 | 127281 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_3 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127571 | 127571 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127861 | 127861 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_5 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128151 | 128151 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_6 | 138.0 | 138 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128441 | 128441 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 113.0 | 113 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128731 | 128731 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_8 | 118.0 | 118 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129021 | 129021 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129311 | 129311 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129601 | 129601 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129891 | 129891 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130181 | 130181 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | pre_kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130471 | 130471 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | pk_12_total | 60.0 | 429.0 | 60 | 429 | ||||||||||||||||||||||||||||||||||||||||||||||||||
126384 | 126384 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | kindergarten | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126964 | 126964 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127254 | 127254 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_3 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127544 | 127544 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127834 | 127834 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_5 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128124 | 128124 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_6 | 258.0 | 258 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128414 | 128414 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 255.0 | 255 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128704 | 128704 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_8 | 201.0 | 201 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128994 | 128994 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129284 | 129284 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129574 | 129574 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129864 | 129864 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130154 | 130154 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | pre_kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130444 | 130444 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | pk_12_total | 81.0 | 795.0 | 81 | 795 | ||||||||||||||||||||||||||||||||||||||||||||||||||
126385 | 126385 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | High | 09 | 12 | 2017 | kindergarten | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126965 | 126965 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127255 | 127255 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | High | 09 | 12 | 2017 | grade_3 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127545 | 127545 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | High | 09 | 12 | 2017 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127835 | 127835 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | High | 09 | 12 | 2017 | grade_5 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128125 | 128125 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | High | 09 | 12 | 2017 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128415 | 128415 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128705 | 128705 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | High | 09 | 12 | 2017 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128995 | 128995 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 645.0 | 645 |
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]);