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
109855 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2016   grade_8                                                   0.0                                             0
128858 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
279834 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2015   grade_8                                                   0.0                                             0
2430965 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455655 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736627 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781677 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
109840 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2016   grade_8                                                   0.0                                             0
128843 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
279819 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   grade_8                                                   0.0                                             0
2430950 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455640 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736612 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781662 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
109841 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2016   grade_8                                                   0.0                                             0
128844 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
279820 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   grade_8                                                   0.0                                             0
2430951 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455641 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736613 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781663 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
109842 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2016   grade_8                                                   0.0                                             0
128845 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
279821 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   grade_8                                                   0.0                                             0
2430952 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455642 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736614 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781664 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
109856 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2016   grade_8                                                   0.0                                             0
128859 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
279835 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   grade_8                                                   0.0                                             0
2430966 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455656 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736628 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781678 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
109843 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2016   grade_8                                                   0.0                                             0
128846 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
279822 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   grade_8                                                   0.0                                             0
2430953 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455643 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736615 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781665 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
109845 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2016   grade_8                                                   209.0                                             209
128848 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No High 07 12 2017   grade_8                                                   202.0                                             202
279824 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2015   grade_8                                                   205.0                                             205
2430955 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2020   grade_8                                                   212.0                                             212
2455645 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2021   grade_8                                                   208.0                                             208
2736617 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   grade_8                                                   212.0                                             212
2781667 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2018   grade_8                                                   195.0                                             195
109857 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 KAILUA EL   Regular School No 1 PK 6 2016   grade_8                                                   0.0                                             0
128860 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 KAILUA EL   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
279836 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 KAILUA EL   Regular School No 1 PK 6 2015   grade_8                                                   0.0                                             0
2430967 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455657 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736629 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781679 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
109858 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 KAILUA HI   Regular School No 3 09 12 2016   grade_8                                                   0.0                                             0
128861 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 KAILUA HI   Regular School No High 09 12 2017   grade_8                                                   0.0                                             0
279837 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 KAILUA HI   Regular School No 3 09 12 2015   grade_8                                                   0.0                                             0
2430968 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2455658 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2021   grade_8                                                   0.0                                             0
2736630 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   grade_8                                                   0.0                                             0
2781680 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2018   grade_8                                                   0.0                                             0
109859 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 KAILUA INT   Regular School No 2 07 8 2016   grade_8                                                   304.0                                             304
128862 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 KAILUA INT   Regular School No Middle 07 8 2017   grade_8                                                   333.0                                             333
279838 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 KAILUA INT   Regular School No 2 07 8 2015   grade_8                                                   278.0                                             278
2430969 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2020   grade_8                                                   341.0                                             341
2455659 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2021   grade_8                                                   312.0                                             312
2736631 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   grade_8                                                   323.0                                             323
2781681 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2018   grade_8                                                   317.0                                             317
109860 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 KAINALU   Regular School No 1 PK 6 2016   grade_8                                                   0.0                                             0
128863 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 KAINALU   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
279839 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 KAINALU   Regular School No 1 PK 6 2015   grade_8                                                   0.0                                             0
2430970 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455660 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736632 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781682 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
109861 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 KALAHEO HI   Regular School No 3 09 12 2016   grade_8                                                   0.0                                             0
128864 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 KALAHEO HI   Regular School No High 09 12 2017   grade_8                                                   0.0                                             0
279840 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 KALAHEO HI   Regular School No 3 09 12 2015   grade_8                                                   0.0                                             0
2430971 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2455661 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2021   grade_8                                                   0.0                                             0
2736633 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   grade_8                                                   0.0                                             0
2781683 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2018   grade_8                                                   0.0                                             0
109846 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 KANEOHE   Regular School No 1 PK 6 2016   grade_8                                                   0.0                                             0
128849 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 KANEOHE   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
279825 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 KANEOHE   Regular School No 1 PK 6 2015   grade_8                                                   0.0                                             0
2430956 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455646 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736618 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781668 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
109847 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 KAPUNAHALA   Regular School No 1 PK 6 2016   grade_8                                                   0.0                                             0
128850 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 KAPUNAHALA   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
279826 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 KAPUNAHALA   Regular School No 1 PK 6 2015   grade_8                                                   0.0                                             0
2430957 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455647 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736619 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781669 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
109862 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No 1 PK 6 2016   grade_8                                                   0.0                                             0
128865 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
279841 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No 1 PK 6 2015   grade_8                                                   0.0                                             0