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
2779186 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   kindergarten                                                   68.0                                             68
2779478 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_1                                                   86.0                                             86
2779770 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_2                                                   69.0                                             69
2780062 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_3                                                   52.0                                             52
2780354 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_4                                                   76.0                                             76
2780646 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_5                                                   82.0                                             82
2780938 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_6                                                   0.0                                             0
2781230 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_7                                                   0.0                                             0
2781522 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2781814 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_9                                                   0.0                                             0
2782106 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0
2782398 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0
2782690 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_12                                                   0.0                                             0
2782982 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   pre_kindergarten                                                   3.0                                             3
2783274 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   pk_12_total                                               33.0   469.0                                         33   469
2779211 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   kindergarten                                                   69.0                                             69
2779503 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_1                                                   55.0                                             55
2779795 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_2                                                   56.0                                             56
2780087 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_3                                                   41.0                                             41
2780379 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_4                                                   59.0                                             59
2780671 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_5                                                   63.0                                             63
2780963 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_6                                                   0.0                                             0
2781255 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_7                                                   0.0                                             0
2781547 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2781839 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_9                                                   0.0                                             0
2782131 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0
2782423 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0
2782715 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_12                                                   0.0                                             0
2783007 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   pre_kindergarten                                                   6.0                                             6
2783299 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   pk_12_total                                               35.0   384.0                                         35   384
2779212 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   kindergarten                                                   36.0                                             36
2779504 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_1                                                   32.0                                             32
2779796 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_2                                                   32.0                                             32
2780088 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_3                                                   22.0                                             22
2780380 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_4                                                   37.0                                             37
2780672 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_5                                                   34.0                                             34
2780964 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_6                                                   0.0                                             0
2781256 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_7                                                   0.0                                             0
2781548 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2781840 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_9                                                   0.0                                             0
2782132 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0
2782424 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0
2782716 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_12                                                   0.0                                             0
2783008 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   pre_kindergarten                                                   7.0                                             7
2783300 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   pk_12_total                                               19.0   219.0                                         19   219
2779213 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   kindergarten                                                   47.0                                             47
2779505 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_1                                                   56.0                                             56
2779797 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_2                                                   49.0                                             49
2780089 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_3                                                   32.0                                             32
2780381 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_4                                                   48.0                                             48
2780673 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_5                                                   35.0                                             35
2780965 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_6                                                   43.0                                             43
2781257 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_7                                                   25.0                                             25
2781549 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_8                                                   25.0                                             25
2781841 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_9                                                   24.0                                             24
2782133 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_10                                                   21.0                                             21
2782425 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_11                                                   14.0                                             14
2782717 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_12                                                   12.0                                             12
2783009 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   pre_kindergarten                                                   0.0                                             0
2783301 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   pk_12_total                                               24.0   455.0                                         24   455
2779214 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   kindergarten                                                   0.0                                             0
2779506 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   grade_1                                                   0.0                                             0
2779798 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   grade_2                                                   0.0                                             0
2780090 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   grade_3                                                   0.0                                             0
2780382 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   grade_4                                                   0.0                                             0
2780674 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   grade_5                                                   0.0                                             0
2780966 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   grade_6                                                   131.0                                             131
2781258 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   grade_7                                                   117.0                                             117
2781550 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   grade_8                                                   102.0                                             102
2781842 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   grade_9                                                   0.0                                             0
2782134 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   grade_10                                                   0.0                                             0
2782426 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   grade_11                                                   0.0                                             0
2782718 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   grade_12                                                   0.0                                             0
2783010 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   pre_kindergarten                                                   0.0                                             0
2783302 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   pk_12_total                                               41.0   391.0                                         41   391
2779187 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   kindergarten                                                   0.0                                             0
2779479 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   grade_1                                                   0.0                                             0
2779771 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   grade_2                                                   0.0                                             0
2780063 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   grade_3                                                   0.0                                             0
2780355 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   grade_4                                                   0.0                                             0
2780647 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   grade_5                                                   0.0                                             0
2780939 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   grade_6                                                   219.0                                             219
2781231 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   grade_7                                                   278.0                                             278
2781523 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   grade_8                                                   210.0                                             210
2781815 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   grade_9                                                   0.0                                             0
2782107 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   grade_10                                                   0.0                                             0
2782399 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   grade_11                                                   0.0                                             0
2782691 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   grade_12                                                   0.0                                             0
2782983 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   pre_kindergarten                                                   0.0                                             0
2783275 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   pk_12_total                                               77.0   784.0                                         77   784
2779188 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0
2779480 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   grade_1                                                   0.0                                             0
2779772 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   grade_2                                                   0.0                                             0
2780064 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   grade_3                                                   0.0                                             0
2780356 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   grade_4                                                   0.0                                             0
2780648 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   grade_5                                                   0.0                                             0
2780940 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   grade_6                                                   0.0                                             0
2781232 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
2781524 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   grade_8                                                   0.0                                             0
2781816 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   grade_9                                                   585.0                                             585
2782108 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   grade_10                                                   565.0                                             565