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
2734291 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2019   kindergarten                                                   36.0                                             36
2734583 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2019   grade_1                                                   56.0                                             56
2734875 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2019   grade_2                                                   59.0                                             59
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
2735459 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2019   grade_4                                                   48.0                                             48
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
2736043 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2019   grade_6                                                   37.0                                             37
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
2736627 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2736919 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2019   grade_9                                                   0.0                                             0
2737211 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2019   grade_10                                                   0.0                                             0
2737503 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2019   grade_11                                                   0.0                                             0
2737795 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2019   grade_12                                                   0.0                                             0
2738087 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2019   pre_kindergarten                                                   3.0                                             3
2738379 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               48.0   388.0                                         48   388
2734276 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2019   kindergarten                                                   47.0                                             47
2734568 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2019   grade_1                                                   47.0                                             47
2734860 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2019   grade_2                                                   45.0                                             45
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
2735444 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2019   grade_4                                                   41.0                                             41
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
2736028 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2019   grade_6                                                   31.0                                             31
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
2736612 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2736904 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2019   grade_9                                                   0.0                                             0
2737196 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2019   grade_10                                                   0.0                                             0
2737488 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2019   grade_11                                                   0.0                                             0
2737780 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2019   grade_12                                                   0.0                                             0
2738072 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2019   pre_kindergarten                                                   9.0                                             9
2738364 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 Hauula Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               34.0   350.0                                         34   350
2734277 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2019   kindergarten                                                   45.0                                             45
2734569 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2019   grade_1                                                   51.0                                             51
2734861 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2019   grade_2                                                   50.0                                             50
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
2735445 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2019   grade_4                                                   46.0                                             46
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
2736029 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2019   grade_6                                                   63.0                                             63
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
2736613 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2736905 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2019   grade_9                                                   0.0                                             0
2737197 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2019   grade_10                                                   0.0                                             0
2737489 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2019   grade_11                                                   0.0                                             0
2737781 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2019   grade_12                                                   0.0                                             0
2738073 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2019   pre_kindergarten                                                   13.0                                             13
2738365 HI     school 1500030 1   Hawaii Department of Education 150003000003 304 Heeia Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               59.0   437.0                                         59   437
2734278 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   kindergarten                                                   21.0                                             21
2734570 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   grade_1                                                   17.0                                             17
2734862 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   grade_2                                                   12.0                                             12
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
2735446 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   grade_4                                                   6.0                                             6
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
2736030 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   grade_6                                                   15.0                                             15
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
2736614 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2736906 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   grade_9                                                   0.0                                             0
2737198 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   grade_10                                                   0.0                                             0
2737490 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   grade_11                                                   0.0                                             0
2737782 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   grade_12                                                   0.0                                             0
2738074 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   pre_kindergarten                                                   0.0                                             0
2738366 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               15.0   132.0                                         15   132
2734292 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2019   kindergarten                                                   28.0                                             28
2734584 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2019   grade_1                                                   25.0                                             25
2734876 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2019   grade_2                                                   39.0                                             39
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
2735460 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2019   grade_4                                                   24.0                                             24
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
2736044 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2019   grade_6                                                   16.0                                             16
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
2736628 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2736920 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2019   grade_9                                                   0.0                                             0
2737212 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2019   grade_10                                                   0.0                                             0
2737504 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2019   grade_11                                                   0.0                                             0
2737796 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2019   grade_12                                                   0.0                                             0
2738088 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2019   pre_kindergarten                                                   0.0                                             0
2738380 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 Kaelepulu Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               18.0   209.0                                         18   209
2734279 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2019   kindergarten                                                   35.0                                             35
2734571 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2019   grade_1                                                   25.0                                             25
2734863 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2019   grade_2                                                   39.0                                             39
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
2735447 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2019   grade_4                                                   28.0                                             28
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
2736031 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2019   grade_6                                                   36.0                                             36
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
2736615 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2736907 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2019   grade_9                                                   0.0                                             0
2737199 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2019   grade_10                                                   0.0                                             0
2737491 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2019   grade_11                                                   0.0                                             0
2737783 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2019   grade_12                                                   0.0                                             0
2738075 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2019   pre_kindergarten                                                   9.0                                             9
2738367 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 Kahaluu Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               39.0   276.0                                         39   276
2734281 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   kindergarten                                                   0.0                                             0
2734573 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   grade_1                                                   0.0                                             0
2734865 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   grade_2                                                   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
2735449 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   grade_4                                                   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
2736033 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   grade_6                                                   0.0                                             0
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
2736617 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   grade_8                                                   212.0                                             212
2736909 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   grade_9                                                   213.0                                             213
2737201 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   grade_10                                                   199.0                                             199