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
109565 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2016   grade_7                                                   0.0                                             0
128568 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No Elementary PK 6 2017   grade_7                                                   0.0                                             0
279545 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2015   grade_7                                                   0.0                                             0
2430672 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2020   grade_7                                                   0.0                                             0
2455361 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2021   grade_7                                                   0.0                                             0
2736335 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2019   grade_7                                                   0.0                                             0
2781385 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2018   grade_7                                                   0.0                                             0
109550 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2016   grade_7                                                   0.0                                             0
128553 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No Elementary PK 6 2017   grade_7                                                   0.0                                             0
279530 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   grade_7                                                   0.0                                             0
2430657 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2020   grade_7                                                   0.0                                             0
2455346 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2021   grade_7                                                   0.0                                             0
2736320 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2019   grade_7                                                   0.0                                             0
2781370 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2018   grade_7                                                   0.0                                             0
109551 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2016   grade_7                                                   0.0                                             0
128554 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No Elementary PK 6 2017   grade_7                                                   0.0                                             0
279531 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   grade_7                                                   0.0                                             0
2430658 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2020   grade_7                                                   0.0                                             0
2455347 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2021   grade_7                                                   0.0                                             0
2736321 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2019   grade_7                                                   0.0                                             0
2781371 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2018   grade_7                                                   0.0                                             0
109552 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2016   grade_7                                                   0.0                                             0
128555 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No Elementary PK 6 2017   grade_7                                                   0.0                                             0
279532 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   grade_7                                                                                                  
2430659 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2020   grade_7                                                   0.0                                             0
2455348 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2021   grade_7                                                   0.0                                             0
2736322 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   grade_7                                                   0.0                                             0
2781372 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2018   grade_7                                                   0.0                                             0
109566 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2016   grade_7                                                   0.0                                             0
128569 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No Elementary PK 6 2017   grade_7                                                   0.0                                             0
279546 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   grade_7                                                   0.0                                             0
2430673 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2020   grade_7                                                   0.0                                             0
2455362 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2021   grade_7                                                   0.0                                             0
2736336 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2019   grade_7                                                   0.0                                             0
2781386 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2018   grade_7                                                   0.0                                             0
109553 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2016   grade_7                                                   0.0                                             0
128556 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No Elementary PK 6 2017   grade_7                                                   0.0                                             0
279533 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   grade_7                                                   0.0                                             0
2430660 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2020   grade_7                                                   0.0                                             0
2455349 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2021   grade_7                                                   0.0                                             0
2736323 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2019   grade_7                                                   0.0                                             0
2781373 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2018   grade_7                                                   0.0                                             0
109555 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2016   grade_7                                                   224.0                                             224
128558 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No High 07 12 2017   grade_7                                                   208.0                                             208
279535 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2015   grade_7                                                   223.0                                             223
2430662 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2020   grade_7                                                   201.0                                             201
2455351 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2021   grade_7                                                   226.0                                             226
2736325 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   grade_7                                                   214.0                                             214
2781375 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2018   grade_7                                                   214.0                                             214
109567 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 KAILUA EL   Regular School No 1 PK 6 2016   grade_7                                                   0.0                                             0
128570 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 KAILUA EL   Regular School No Elementary PK 6 2017   grade_7                                                   0.0                                             0
279547 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 KAILUA EL   Regular School No 1 PK 6 2015   grade_7                                                   0.0                                             0
2430674 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2020   grade_7                                                   0.0                                             0
2455363 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2021   grade_7                                                   0.0                                             0
2736337 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   grade_7                                                   0.0                                             0
2781387 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2018   grade_7                                                   0.0                                             0
109568 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 KAILUA HI   Regular School No 3 09 12 2016   grade_7                                                   0.0                                             0
128571 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 KAILUA HI   Regular School No High 09 12 2017   grade_7                                                   0.0                                             0
279548 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 KAILUA HI   Regular School No 3 09 12 2015   grade_7                                                   0.0                                             0
2430675 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2455364 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2736338 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   grade_7                                                   0.0                                             0
2781388 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
109569 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 KAILUA INT   Regular School No 2 07 8 2016   grade_7                                                   334.0                                             334
128572 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 KAILUA INT   Regular School No Middle 07 8 2017   grade_7                                                   348.0                                             348
279549 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 KAILUA INT   Regular School No 2 07 8 2015   grade_7                                                   322.0                                             322
2430676 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2020   grade_7                                                   329.0                                             329
2455365 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2021   grade_7                                                   370.0                                             370
2736339 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   grade_7                                                   357.0                                             357
2781389 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2018   grade_7                                                   323.0                                             323
109570 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 KAINALU   Regular School No 1 PK 6 2016   grade_7                                                   0.0                                             0
128573 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 KAINALU   Regular School No Elementary PK 6 2017   grade_7                                                   0.0                                             0
279550 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 KAINALU   Regular School No 1 PK 6 2015   grade_7                                                   0.0                                             0
2430677 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2020   grade_7                                                   0.0                                             0
2455366 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2021   grade_7                                                   0.0                                             0
2736340 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   grade_7                                                   0.0                                             0
2781390 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2018   grade_7                                                   0.0                                             0
109571 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 KALAHEO HI   Regular School No 3 09 12 2016   grade_7                                                   0.0                                             0
128574 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 KALAHEO HI   Regular School No High 09 12 2017   grade_7                                                   0.0                                             0
279551 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 KALAHEO HI   Regular School No 3 09 12 2015   grade_7                                                   0.0                                             0
2430678 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2455367 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2736341 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   grade_7                                                   0.0                                             0
2781391 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
109556 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 KANEOHE   Regular School No 1 PK 6 2016   grade_7                                                   0.0                                             0
128559 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 KANEOHE   Regular School No Elementary PK 6 2017   grade_7                                                   0.0                                             0
279536 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 KANEOHE   Regular School No 1 PK 6 2015   grade_7                                                   0.0                                             0
2430663 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2020   grade_7                                                   0.0                                             0
2455352 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2021   grade_7                                                   0.0                                             0
2736326 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   grade_7                                                   0.0                                             0
2781376 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2018   grade_7                                                   0.0                                             0
109557 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 KAPUNAHALA   Regular School No 1 PK 6 2016   grade_7                                                   0.0                                             0
128560 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 KAPUNAHALA   Regular School No Elementary PK 6 2017   grade_7                                                   0.0                                             0
279537 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 KAPUNAHALA   Regular School No 1 PK 6 2015   grade_7                                                   0.0                                             0
2430664 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2020   grade_7                                                   0.0                                             0
2455353 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2021   grade_7                                                   0.0                                             0
2736327 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2019   grade_7                                                   0.0                                             0
2781377 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2018   grade_7                                                   0.0                                             0
109572 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No 1 PK 6 2016   grade_7                                                   0.0                                             0
128575 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No Elementary PK 6 2017   grade_7                                                   0.0                                             0
279552 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No 1 PK 6 2015   grade_7                                                   0.0                                             0