schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 101 rows (hide)

Query parameters

rowidstatecountycounty_state_idadmin_leveldistrict_nces_iddistrict_state_iddistrict_state_typedistrictschool_nces_idschool_state_idschoolschool_state_typeccd_school_typeccd_charter_schoolccd_school_lvlccd_school_low_gradeccd_school_high_gradeyeartermgradewhiteblackhispanicnative_americannative_american_alaskan_nativeasiannative_hawaiianasian_pacific_islandernative_hawaiian_pacific_islanderpacific_islandermultiracialunknown_racemalefemalenon_binaryunknown_genderellell_percenthomelesshomeless_percentlow_incomefree_and_reducedfree_and_reduced_percentdisabilitysection_504totalwhite_intblack_inthispanic_intnative_american_intnative_american_alaskan_native_intasian_intnative_hawaiian_intasian_pacific_islander_intnative_hawaiian_pacific_islander_intpacific_islander_intmultiracial_intunknown_race_intmale_intfemale_intnon_binary_intunknown_gender_intell_inthomeless_intlow_income_intfree_and_reduced_intdisability_intsection_504_inttotal_int
110981 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No 1 PK 6 2016   grade_12                                                   0.0                                             0
129984 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   grade_12                                                   0.0                                             0
280956 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No 1 PK 6 2015   grade_12                                                   0.0                                             0
110998 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No 1 PK 6 2016   grade_12                                                   0.0                                             0
130001 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   grade_12                                                   0.0                                             0
280973 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No 1 PK 6 2015   grade_12                                                   0.0                                             0
110913 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No 1 PK 6 2016   grade_12                                                   0.0                                             0
129916 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   grade_12                                                   0.0                                             0
280889 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No 1 PK 6 2015   grade_12                                                   0.0                                             0
110914 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No 3 09 12 2016   grade_12                                                   202.0                                             202
129917 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   grade_12                                                   172.0                                             172
280890 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No 3 09 12 2015   grade_12                                                   218.0                                             218
110915 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No 2 07 8 2016   grade_12                                                   0.0                                             0
129918 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_12                                                   0.0                                             0
280891 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No 2 07 8 2015   grade_12                                                   0.0                                             0
111014 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No 1 PK 6 2016   grade_12                                                   0.0                                             0
130017 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   grade_12                                                   0.0                                             0
280989 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No 1 PK 6 2015   grade_12                                                   0.0                                             0
110860 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   grade_12                                                   0.0                                             0
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
280836 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2015   grade_12                                                   0.0                                             0
110885 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   grade_12                                                   0.0                                             0
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
280861 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2015   grade_12                                                   0.0                                             0
110916 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 ALIAMANU EL   Regular School No 1 PK 6 2016   grade_12                                                   0.0                                             0
129919 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 ALIAMANU EL   Regular School No Elementary PK 6 2017   grade_12                                                   0.0                                             0
280892 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 ALIAMANU EL   Regular School No 1 PK 6 2015   grade_12                                                   0.0                                             0
110917 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 ALIAMANU INT   Regular School No 2 07 8 2016   grade_12                                                   0.0                                             0
129920 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 ALIAMANU INT   Regular School No Middle 07 8 2017   grade_12                                                   0.0                                             0
280893 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 ALIAMANU INT   Regular School No 2 07 8 2015   grade_12                                                   0.0                                             0
110886 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   grade_12                                                   0.0                                             0
129889 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   grade_12                                                   0.0                                             0
280862 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2015   grade_12                                                   0.0                                             0
110887 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_12                                                   15.0                                             15
129890 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_12                                                   10.0                                             10
280863 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2015   grade_12                                                   14.0                                             14
2456797 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 Ahrens Elem   Regular School No Elementary PK 6 2021   grade_12                                                   0.0                                             0
2432120 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   grade_12                                                   0.0                                             0
2456814 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2021   grade_12                                                   0.0                                             0
2737778 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2019   grade_12                                                   0.0                                             0
2782828 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   grade_12                                                   0.0                                             0
2432035 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   grade_12                                                   0.0                                             0
2456728 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2021   grade_12                                                   0.0                                             0
2737693 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2019   grade_12                                                   0.0                                             0
2782743 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   grade_12                                                   0.0                                             0
2432036 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   grade_12                                                   218.0                                             218
2456729 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2021   grade_12                                                   185.0                                             185
2737694 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2019   grade_12                                                   203.0                                             203
2782744 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   grade_12                                                   203.0                                             203
2432037 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   grade_12                                                   0.0                                             0
2456730 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2021   grade_12                                                   0.0                                             0
2737695 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2019   grade_12                                                   0.0                                             0
2782745 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   grade_12                                                   0.0                                             0
2432136 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   grade_12                                                   0.0                                             0
2456830 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2021   grade_12                                                   0.0                                             0
2737794 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2019   grade_12                                                   0.0                                             0
2782844 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   grade_12                                                   0.0                                             0
2431982 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   grade_12                                                   0.0                                             0
2456675 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2021   grade_12                                                   0.0                                             0
2737640 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2019   grade_12                                                   0.0                                             0
2782690 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_12                                                   0.0                                             0
2432007 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   grade_12                                                   0.0                                             0
2456700 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   grade_12                                                   0.0                                             0
2737665 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2019   grade_12                                                   0.0                                             0
2782715 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_12                                                   0.0                                             0
2432238 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   grade_12                                                   0.0                                             0
2456932 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2021   grade_12                                                   0.0                                             0
2737923 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   grade_12                                                   0.0                                             0
2432038 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 Aliamanu Elem   Regular School No Elementary PK 6 2020   grade_12                                                   0.0                                             0
2456731 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 Aliamanu Elem   Regular School No Elementary PK 6 2021   grade_12                                                   0.0                                             0
2737696 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 Aliamanu Elem   Regular School No Elementary PK 6 2019   grade_12                                                   0.0                                             0
2782746 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 Aliamanu Elem   Regular School No Elementary PK 6 2018   grade_12                                                   0.0                                             0
2432039 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 Aliamanu Middle   Regular School No Middle 07 8 2020   grade_12                                                   0.0                                             0
2456732 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 Aliamanu Middle   Regular School No Middle 07 8 2021   grade_12                                                   0.0                                             0
2737697 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 Aliamanu Middle   Regular School No Middle 07 8 2019   grade_12                                                   0.0                                             0
2782747 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 Aliamanu Middle   Regular School No Middle 07 8 2018   grade_12                                                   0.0                                             0
2432008 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2020   grade_12                                                   0.0                                             0
2456701 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   grade_12                                                   0.0                                             0
2737666 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2019   grade_12                                                   0.0                                             0
2782716 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_12                                                   0.0                                             0
2432009 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2020   grade_12                                                   17.0                                             17
2456702 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_12                                                   22.0                                             22
2737667 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2019   grade_12                                                   13.0                                             13
2782717 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_12                                                   12.0                                             12
2432103 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2020   grade_12                                                   0.0                                             0
2737761 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2019   grade_12                                                   0.0                                             0
2782811 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2018   grade_12                                                   0.0                                             0
111069 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 BALDWIN HI   Regular School No 3 09 12 2016   grade_12                                                   275.0                                             275
130072 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 BALDWIN HI   Regular School No High 09 12 2017   grade_12                                                   268.0                                             268
281044 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 BALDWIN HI   Regular School No 3 09 12 2015   grade_12                                                   317.0                                             317
110955 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 BARBERS POINT   Regular School No 1 PK 5 2016   grade_12                                                   0.0                                             0
129958 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 BARBERS POINT   Regular School No Elementary PK 5 2017   grade_12                                                   0.0                                             0
280931 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 BARBERS POINT   Regular School No 1 PK 5 2015   grade_12                                                   0.0                                             0
2432191 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2020   grade_12                                                   267.0                                             267
2456885 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2021   grade_12                                                   226.0                                             226
2737849 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2019   grade_12                                                   255.0                                             255
2782899 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2018   grade_12                                                   288.0                                             288
2432077 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2020   grade_12                                                   0.0                                             0
2456770 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2021   grade_12                                                   0.0                                             0
2737735 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   grade_12                                                   0.0                                             0
2782785 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2018   grade_12                                                   0.0                                             0