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
109821 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No 1 PK 6 2016   grade_8                                                   0.0                                             0
128824 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
279800 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No 1 PK 6 2015   grade_8                                                   0.0                                             0
109838 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No 1 PK 6 2016   grade_8                                                   0.0                                             0
128841 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
279817 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No 1 PK 6 2015   grade_8                                                   0.0                                             0
109753 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No 1 PK 6 2016   grade_8                                                   0.0                                             0
128756 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
279733 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No 1 PK 6 2015   grade_8                                                   0.0                                             0
109754 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No 3 09 12 2016   grade_8                                                   0.0                                             0
128757 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   grade_8                                                   0.0                                             0
279734 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No 3 09 12 2015   grade_8                                                   0.0                                             0
109755 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No 2 07 8 2016   grade_8                                                   275.0                                             275
128758 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_8                                                   261.0                                             261
279735 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No 2 07 8 2015   grade_8                                                   270.0                                             270
109854 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No 1 PK 6 2016   grade_8                                                   0.0                                             0
128857 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
279833 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No 1 PK 6 2015   grade_8                                                   0.0                                             0
109700 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   grade_8                                                   0.0                                             0
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
279680 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2015   grade_8                                                   0.0                                             0
109725 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   grade_8                                                   0.0                                             0
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
279705 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2015   grade_8                                                   0.0                                             0
109756 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 ALIAMANU EL   Regular School No 1 PK 6 2016   grade_8                                                   0.0                                             0
128759 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 ALIAMANU EL   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
279736 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 ALIAMANU EL   Regular School No 1 PK 6 2015   grade_8                                                   0.0                                             0
109757 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 ALIAMANU INT   Regular School No 2 07 8 2016   grade_8                                                   311.0                                             311
128760 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 ALIAMANU INT   Regular School No Middle 07 8 2017   grade_8                                                   271.0                                             271
279737 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 ALIAMANU INT   Regular School No 2 07 8 2015   grade_8                                                   297.0                                             297
109726 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   grade_8                                                   0.0                                             0
128729 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   grade_8                                                   0.0                                             0
279706 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2015   grade_8                                                   0.0                                             0
109727 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_8                                                   31.0                                             31
128730 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_8                                                   30.0                                             30
279707 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2015   grade_8                                                   22.0                                             22
2455621 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 Ahrens Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2430948 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455638 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736610 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781660 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
2430863 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455552 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736525 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781575 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
2430864 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2455553 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2021   grade_8                                                   0.0                                             0
2736526 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2019   grade_8                                                   0.0                                             0
2781576 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   grade_8                                                   0.0                                             0
2430865 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   grade_8                                                   279.0                                             279
2455554 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2021   grade_8                                                   253.0                                             253
2736527 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2019   grade_8                                                   262.0                                             262
2781577 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   grade_8                                                   257.0                                             257
2430964 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455654 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736626 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781676 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
2430810 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   grade_8                                                   0.0                                             0
2455499 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2021   grade_8                                                   0.0                                             0
2736472 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2019   grade_8                                                   0.0                                             0
2781522 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2430835 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   grade_8                                                   0.0                                             0
2455524 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   grade_8                                                   0.0                                             0
2736497 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2019   grade_8                                                   0.0                                             0
2781547 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2431066 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   grade_8                                                   0.0                                             0
2455756 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2021   grade_8                                                   0.0                                             0
2736755 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   grade_8                                                   0.0                                             0
2430866 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 Aliamanu Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455555 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 Aliamanu Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736528 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 Aliamanu Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781578 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 Aliamanu Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
2430867 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 Aliamanu Middle   Regular School No Middle 07 8 2020   grade_8                                                   312.0                                             312
2455556 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 Aliamanu Middle   Regular School No Middle 07 8 2021   grade_8                                                   345.0                                             345
2736529 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 Aliamanu Middle   Regular School No Middle 07 8 2019   grade_8                                                   308.0                                             308
2781579 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 Aliamanu Middle   Regular School No Middle 07 8 2018   grade_8                                                   302.0                                             302
2430836 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2020   grade_8                                                   0.0                                             0
2455525 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   grade_8                                                   0.0                                             0
2736498 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2019   grade_8                                                   0.0                                             0
2781548 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2430837 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2020   grade_8                                                   38.0                                             38
2455526 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_8                                                   32.0                                             32
2736499 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2019   grade_8                                                   24.0                                             24
2781549 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_8                                                   25.0                                             25
2430931 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2736593 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781643 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
109909 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 BALDWIN HI   Regular School No 3 09 12 2016   grade_8                                                   0.0                                             0
128912 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 BALDWIN HI   Regular School No High 09 12 2017   grade_8                                                   0.0                                             0
279888 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 BALDWIN HI   Regular School No 3 09 12 2015   grade_8                                                   0.0                                             0
109795 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 BARBERS POINT   Regular School No 1 PK 5 2016   grade_8                                                   0.0                                             0
128798 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 BARBERS POINT   Regular School No Elementary PK 5 2017   grade_8                                                   0.0                                             0
279775 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 BARBERS POINT   Regular School No 1 PK 5 2015   grade_8                                                   0.0                                             0
2431019 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2455709 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2021   grade_8                                                   0.0                                             0
2736681 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2019   grade_8                                                   0.0                                             0
2781731 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2018   grade_8                                                   0.0                                             0
2430905 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2020   grade_8                                                   0.0                                             0
2455594 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2021   grade_8                                                   0.0                                             0
2736567 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   grade_8                                                   0.0                                             0
2781617 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0