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
277522 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2015   kindergarten                                                   51.0                                             51
277811 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2015   grade_1                                                   77.0                                             77
278100 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2015   grade_2                                                   57.0                                             57
278389 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2015   grade_3                                                   53.0                                             53
278678 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2015   grade_4                                                   71.0                                             71
278967 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2015   grade_5                                                   61.0                                             61
279256 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2015   grade_6                                                   57.0                                             57
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
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
280123 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2015   grade_9                                                   0.0                                             0
280412 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2015   grade_10                                                   0.0                                             0
280701 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2015   grade_11                                                   0.0                                             0
280990 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2015   grade_12                                                   0.0                                             0
281279 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2015   pre_kindergarten                                                   5.0                                             5
281568 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2015   pk_12_total                                               42.0   474.0                                         42   474
277507 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   kindergarten                                                   49.0                                             49
277796 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   grade_1                                                   50.0                                             50
278085 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   grade_2                                                   37.0                                             37
278374 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   grade_3                                                   32.0                                             32
278663 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   grade_4                                                   40.0                                             40
278952 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   grade_5                                                   31.0                                             31
279241 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   grade_6                                                   28.0                                             28
279530 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   grade_7                                                   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
280108 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   grade_9                                                   0.0                                             0
280397 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   grade_10                                                   0.0                                             0
280686 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   grade_11                                                   0.0                                             0
280975 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   grade_12                                                   0.0                                             0
281264 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   pre_kindergarten                                                   3.0                                             3
281553 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No 1 PK 6 2015   pk_12_total                                               49.0   319.0                                         49   319
277508 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   kindergarten                                                   29.0                                             29
277797 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   grade_1                                                   61.0                                             61
278086 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   grade_2                                                   62.0                                             62
278375 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   grade_3                                                   74.0                                             74
278664 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   grade_4                                                   58.0                                             58
278953 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   grade_5                                                   60.0                                             60
279242 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   grade_6                                                   68.0                                             68
279531 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   grade_7                                                   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
280109 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   grade_9                                                   0.0                                             0
280398 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   grade_10                                                   0.0                                             0
280687 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   grade_11                                                   0.0                                             0
280976 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   grade_12                                                   0.0                                             0
281265 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   pre_kindergarten                                                   13.0                                             13
281554 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 HEEIA   Regular School No 1 PK 6 2015   pk_12_total                                               38.0   463.0                                         38   463
277509 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   kindergarten                                                   13.0                                             13
277798 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   grade_1                                                   20.0                                             20
278087 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   grade_2                                                   11.0                                             11
278376 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   grade_3                                                   13.0                                             13
278665 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   grade_4                                                   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
279243 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   grade_6                                                   20.0                                             20
279532 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   grade_7                                                                                                  
279821 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   grade_8                                                   0.0                                             0
280110 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   grade_9                                                   0.0                                             0
280399 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   grade_10                                                   0.0                                             0
280688 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   grade_11                                                   0.0                                             0
280977 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   grade_12                                                   0.0                                             0
281266 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   pre_kindergarten                                                   0.0                                             0
281555 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   pk_12_total                                               13.0   126.0                                         13   126
277523 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   kindergarten                                                   20.0                                             20
277812 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   grade_1                                                   24.0                                             24
278101 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   grade_2                                                   28.0                                             28
278390 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   grade_3                                                   25.0                                             25
278679 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   grade_4                                                   29.0                                             29
278968 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   grade_5                                                   30.0                                             30
279257 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   grade_6                                                   25.0                                             25
279546 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   grade_7                                                   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
280124 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   grade_9                                                   0.0                                             0
280413 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   grade_10                                                   0.0                                             0
280702 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   grade_11                                                   0.0                                             0
280991 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   grade_12                                                   0.0                                             0
281280 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   pre_kindergarten                                                   0.0                                             0
281569 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   pk_12_total                                               15.0   196.0                                         15   196
277510 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   kindergarten                                                   35.0                                             35
277799 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   grade_1                                                   29.0                                             29
278088 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   grade_2                                                   49.0                                             49
278377 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   grade_3                                                   40.0                                             40
278666 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   grade_4                                                   26.0                                             26
278955 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   grade_5                                                   29.0                                             29
279244 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   grade_6                                                   28.0                                             28
279533 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   grade_7                                                   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
280111 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   grade_9                                                   0.0                                             0
280400 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   grade_10                                                   0.0                                             0
280689 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   grade_11                                                   0.0                                             0
280978 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   grade_12                                                   0.0                                             0
281267 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   pre_kindergarten                                                   15.0                                             15
281556 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No 1 PK 6 2015   pk_12_total                                               40.0   291.0                                         40   291
277512 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2015   kindergarten                                                   0.0                                             0
277801 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2015   grade_1                                                   0.0                                             0
278090 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2015   grade_2                                                   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
278668 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2015   grade_4                                                   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
279246 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2015   grade_6                                                   0.0                                             0
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
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
280113 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2015   grade_9                                                   221.0                                             221
280402 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2015   grade_10                                                   216.0                                             216