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
2735751 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2019   grade_5                                                   59.0                                             59
2780801 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2018   grade_5                                                   49.0                                             49
108970 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2016   grade_5                                                   42.0                                             42
127973 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No Elementary PK 6 2017   grade_5                                                   28.0                                             28
278952 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   grade_5                                                   31.0                                             31
2430071 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2020   grade_5                                                   39.0                                             39
2454758 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2021   grade_5                                                   54.0                                             54
2735736 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2019   grade_5                                                   42.0                                             42
2780786 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2018   grade_5                                                   35.0                                             35
108971 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2016   grade_5                                                   61.0                                             61
127974 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No Elementary PK 6 2017   grade_5                                                   73.0                                             73
278953 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   grade_5                                                   60.0                                             60
2430072 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2020   grade_5                                                   49.0                                             49
2454759 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2021   grade_5                                                   52.0                                             52
2735737 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2019   grade_5                                                   59.0                                             59
2780787 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2018   grade_5                                                   63.0                                             63
108972 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2016   grade_5                                                   13.0                                             13
127975 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No Elementary PK 6 2017   grade_5                                                   16.0                                             16
278954 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   grade_5                                                   20.0                                             20
2430073 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2020   grade_5                                                   8.0                                             8
2454760 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2021   grade_5                                                   18.0                                             18
2735738 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   grade_5                                                   23.0                                             23
2780788 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2018   grade_5                                                   14.0                                             14
108986 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2016   grade_5                                                   25.0                                             25
127989 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No Elementary PK 6 2017   grade_5                                                   26.0                                             26
278968 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   grade_5                                                   30.0                                             30
2430087 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2020   grade_5                                                   24.0                                             24
2454774 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2021   grade_5                                                   28.0                                             28
2735752 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2019   grade_5                                                   26.0                                             26
2780802 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2018   grade_5                                                   22.0                                             22
108973 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2016   grade_5                                                   25.0                                             25
127976 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No Elementary PK 6 2017   grade_5                                                   37.0                                             37
278955 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   grade_5                                                   29.0                                             29
2430074 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2020   grade_5                                                   25.0                                             25
2454761 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2021   grade_5                                                   32.0                                             32
2735739 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2019   grade_5                                                   32.0                                             32
2780789 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2018   grade_5                                                   39.0                                             39
108975 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2016   grade_5                                                   0.0                                             0
127978 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No High 07 12 2017   grade_5                                                   0.0                                             0
278957 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2015   grade_5                                                   0.0                                             0
2430076 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2020   grade_5                                                   0.0                                             0
2454763 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2021   grade_5                                                   0.0                                             0
2735741 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   grade_5                                                   0.0                                             0
2780791 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2018   grade_5                                                   0.0                                             0
108987 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 KAILUA EL   Regular School No 1 PK 6 2016   grade_5                                                   46.0                                             46
127990 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 KAILUA EL   Regular School No Elementary PK 6 2017   grade_5                                                   48.0                                             48
278969 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 KAILUA EL   Regular School No 1 PK 6 2015   grade_5                                                   39.0                                             39
2430088 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2020   grade_5                                                   47.0                                             47
2454775 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2021   grade_5                                                   38.0                                             38
2735753 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   grade_5                                                   42.0                                             42
2780803 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2018   grade_5                                                   44.0                                             44
108988 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 KAILUA HI   Regular School No 3 09 12 2016   grade_5                                                   0.0                                             0
127991 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 KAILUA HI   Regular School No High 09 12 2017   grade_5                                                   0.0                                             0
278970 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 KAILUA HI   Regular School No 3 09 12 2015   grade_5                                                   0.0                                             0
2430089 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2454776 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2735754 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   grade_5                                                   0.0                                             0
2780804 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2018   grade_5                                                   0.0                                             0
108989 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 KAILUA INT   Regular School No 2 07 8 2016   grade_5                                                   0.0                                             0
127992 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 KAILUA INT   Regular School No Middle 07 8 2017   grade_5                                                   0.0                                             0
278971 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 KAILUA INT   Regular School No 2 07 8 2015   grade_5                                                   0.0                                             0
2430090 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2020   grade_5                                                   0.0                                             0
2454777 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2021   grade_5                                                   0.0                                             0
2735755 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   grade_5                                                   0.0                                             0
2780805 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2018   grade_5                                                   0.0                                             0
108990 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 KAINALU   Regular School No 1 PK 6 2016   grade_5                                                   47.0                                             47
127993 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 KAINALU   Regular School No Elementary PK 6 2017   grade_5                                                   51.0                                             51
278972 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 KAINALU   Regular School No 1 PK 6 2015   grade_5                                                   58.0                                             58
2430091 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2020   grade_5                                                   37.0                                             37
2454778 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2021   grade_5                                                   62.0                                             62
2735756 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   grade_5                                                   59.0                                             59
2780806 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2018   grade_5                                                   59.0                                             59
108991 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 KALAHEO HI   Regular School No 3 09 12 2016   grade_5                                                   0.0                                             0
127994 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 KALAHEO HI   Regular School No High 09 12 2017   grade_5                                                   0.0                                             0
278973 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 KALAHEO HI   Regular School No 3 09 12 2015   grade_5                                                   0.0                                             0
2430092 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2454779 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2735757 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   grade_5                                                   0.0                                             0
2780807 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2018   grade_5                                                   0.0                                             0
108976 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 KANEOHE   Regular School No 1 PK 6 2016   grade_5                                                   95.0                                             95
127979 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 KANEOHE   Regular School No Elementary PK 6 2017   grade_5                                                   91.0                                             91
278958 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 KANEOHE   Regular School No 1 PK 6 2015   grade_5                                                   76.0                                             76
2430077 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2020   grade_5                                                   62.0                                             62
2454764 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2021   grade_5                                                   87.0                                             87
2735742 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   grade_5                                                   82.0                                             82
2780792 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2018   grade_5                                                   88.0                                             88
108977 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 KAPUNAHALA   Regular School No 1 PK 6 2016   grade_5                                                   64.0                                             64
127980 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 KAPUNAHALA   Regular School No Elementary PK 6 2017   grade_5                                                   70.0                                             70
278959 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 KAPUNAHALA   Regular School No 1 PK 6 2015   grade_5                                                   67.0                                             67
2430078 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2020   grade_5                                                   51.0                                             51
2454765 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2021   grade_5                                                   61.0                                             61
2735743 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2019   grade_5                                                   66.0                                             66
2780793 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2018   grade_5                                                   82.0                                             82
108992 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No 1 PK 6 2016   grade_5                                                   18.0                                             18
127995 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No Elementary PK 6 2017   grade_5                                                   13.0                                             13
278974 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No 1 PK 6 2015   grade_5                                                   21.0                                             21
2430093 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 Keolu Elem   Regular School No Elementary PK 6 2020   grade_5                                                   7.0                                             7
2454780 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 Keolu Elem   Regular School No Elementary PK 6 2021   grade_5                                                   21.0                                             21
2735758 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 Keolu Elem   Regular School No Elementary PK 6 2019   grade_5                                                   16.0                                             16
2780808 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 Keolu Elem   Regular School No Elementary PK 6 2018   grade_5                                                   17.0                                             17
108978 HI     school 1500030 1   Hawaii Department of Education 150003000016 318 KING INT   Regular School No 2 07 8 2016   grade_5                                                   0.0                                             0