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
2735167 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2019   grade_3                                                   42.0                                             42
2780217 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2018   grade_3                                                   49.0                                             49
108390 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2016   grade_3                                                   39.0                                             39
127393 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No Elementary PK 6 2017   grade_3                                                   44.0                                             44
278374 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   grade_3                                                   32.0                                             32
2429485 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2020   grade_3                                                   52.0                                             52
2454170 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2021   grade_3                                                   46.0                                             46
2735152 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2019   grade_3                                                   54.0                                             54
2780202 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2018   grade_3                                                   41.0                                             41
108391 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2016   grade_3                                                   61.0                                             61
127394 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No Elementary PK 6 2017   grade_3                                                   64.0                                             64
278375 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   grade_3                                                   74.0                                             74
2429486 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2020   grade_3                                                   49.0                                             49
2454171 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2021   grade_3                                                   49.0                                             49
2735153 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2019   grade_3                                                   51.0                                             51
2780203 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2018   grade_3                                                   42.0                                             42
108392 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2016   grade_3                                                   17.0                                             17
127395 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No Elementary PK 6 2017   grade_3                                                   16.0                                             16
278376 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   grade_3                                                   13.0                                             13
2429487 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2020   grade_3                                                   12.0                                             12
2454172 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2021   grade_3                                                   11.0                                             11
2735154 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   grade_3                                                   23.0                                             23
2780204 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2018   grade_3                                                   9.0                                             9
108406 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2016   grade_3                                                   26.0                                             26
127409 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No Elementary PK 6 2017   grade_3                                                   27.0                                             27
278390 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   grade_3                                                   25.0                                             25
2429501 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2020   grade_3                                                   36.0                                             36
2454186 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2021   grade_3                                                   34.0                                             34
2735168 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2019   grade_3                                                   33.0                                             33
2780218 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2018   grade_3                                                   23.0                                             23
108393 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2016   grade_3                                                   38.0                                             38
127396 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No Elementary PK 6 2017   grade_3                                                   33.0                                             33
278377 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   grade_3                                                   40.0                                             40
2429488 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2020   grade_3                                                   34.0                                             34
2454173 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2021   grade_3                                                   28.0                                             28
2735155 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2019   grade_3                                                   33.0                                             33
2780205 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2018   grade_3                                                   28.0                                             28
108395 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2016   grade_3                                                   0.0                                             0
127398 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No High 07 12 2017   grade_3                                                   0.0                                             0
278379 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2015   grade_3                                                   0.0                                             0
2429490 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2020   grade_3                                                   0.0                                             0
2454175 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2021   grade_3                                                   0.0                                             0
2735157 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   grade_3                                                   0.0                                             0
2780207 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2018   grade_3                                                   0.0                                             0
108407 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 KAILUA EL   Regular School No 1 PK 6 2016   grade_3                                                   43.0                                             43
127410 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 KAILUA EL   Regular School No Elementary PK 6 2017   grade_3                                                   48.0                                             48
278391 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 KAILUA EL   Regular School No 1 PK 6 2015   grade_3                                                   44.0                                             44
2429502 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2020   grade_3                                                   39.0                                             39
2454187 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2021   grade_3                                                   36.0                                             36
2735169 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   grade_3                                                   48.0                                             48
2780219 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2018   grade_3                                                   40.0                                             40
108408 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 KAILUA HI   Regular School No 3 09 12 2016   grade_3                                                   0.0                                             0
127411 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 KAILUA HI   Regular School No High 09 12 2017   grade_3                                                   0.0                                             0
278392 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 KAILUA HI   Regular School No 3 09 12 2015   grade_3                                                   0.0                                             0
2429503 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2020   grade_3                                                   0.0                                             0
2454188 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2021   grade_3                                                   0.0                                             0
2735170 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   grade_3                                                   0.0                                             0
2780220 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2018   grade_3                                                   0.0                                             0
108409 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 KAILUA INT   Regular School No 2 07 8 2016   grade_3                                                   0.0                                             0
127412 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 KAILUA INT   Regular School No Middle 07 8 2017   grade_3                                                   0.0                                             0
278393 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 KAILUA INT   Regular School No 2 07 8 2015   grade_3                                                   0.0                                             0
2429504 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2020   grade_3                                                   0.0                                             0
2454189 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2021   grade_3                                                   0.0                                             0
2735171 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   grade_3                                                   0.0                                             0
2780221 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2018   grade_3                                                   0.0                                             0
108410 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 KAINALU   Regular School No 1 PK 6 2016   grade_3                                                   81.0                                             81
127413 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 KAINALU   Regular School No Elementary PK 6 2017   grade_3                                                   74.0                                             74
278394 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 KAINALU   Regular School No 1 PK 6 2015   grade_3                                                   57.0                                             57
2429505 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2020   grade_3                                                   55.0                                             55
2454190 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2021   grade_3                                                   67.0                                             67
2735172 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   grade_3                                                   59.0                                             59
2780222 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2018   grade_3                                                   47.0                                             47
108411 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 KALAHEO HI   Regular School No 3 09 12 2016   grade_3                                                   0.0                                             0
127414 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 KALAHEO HI   Regular School No High 09 12 2017   grade_3                                                   0.0                                             0
278395 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 KALAHEO HI   Regular School No 3 09 12 2015   grade_3                                                   0.0                                             0
2429506 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2020   grade_3                                                   0.0                                             0
2454191 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2021   grade_3                                                   0.0                                             0
2735173 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   grade_3                                                   0.0                                             0
2780223 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2018   grade_3                                                   0.0                                             0
108396 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 KANEOHE   Regular School No 1 PK 6 2016   grade_3                                                   87.0                                             87
127399 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 KANEOHE   Regular School No Elementary PK 6 2017   grade_3                                                   81.0                                             81
278380 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 KANEOHE   Regular School No 1 PK 6 2015   grade_3                                                   79.0                                             79
2429491 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2020   grade_3                                                   91.0                                             91
2454176 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2021   grade_3                                                   82.0                                             82
2735158 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   grade_3                                                   88.0                                             88
2780208 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2018   grade_3                                                   64.0                                             64
108397 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 KAPUNAHALA   Regular School No 1 PK 6 2016   grade_3                                                   83.0                                             83
127400 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 KAPUNAHALA   Regular School No Elementary PK 6 2017   grade_3                                                   69.0                                             69
278381 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 KAPUNAHALA   Regular School No 1 PK 6 2015   grade_3                                                   72.0                                             72
2429492 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2020   grade_3                                                   72.0                                             72
2454177 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2021   grade_3                                                   71.0                                             71
2735159 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2019   grade_3                                                   59.0                                             59
2780209 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2018   grade_3                                                   64.0                                             64
108412 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No 1 PK 6 2016   grade_3                                                   24.0                                             24
127415 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No Elementary PK 6 2017   grade_3                                                   14.0                                             14
278396 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No 1 PK 6 2015   grade_3                                                   15.0                                             15
2429507 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 Keolu Elem   Regular School No Elementary PK 6 2020   grade_3                                                   12.0                                             12
2454192 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 Keolu Elem   Regular School No Elementary PK 6 2021   grade_3                                                   19.0                                             19
2735174 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 Keolu Elem   Regular School No Elementary PK 6 2019   grade_3                                                   19.0                                             19
2780224 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 Keolu Elem   Regular School No Elementary PK 6 2018   grade_3                                                   10.0                                             10
108398 HI     school 1500030 1   Hawaii Department of Education 150003000016 318 KING INT   Regular School No 2 07 8 2016   grade_3                                                   0.0                                             0