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
2779324 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   kindergarten                                                   41.0                                             41
2779616 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   grade_1                                                   43.0                                             43
2779908 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   grade_2                                                   39.0                                             39
2780200 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   grade_3                                                   34.0                                             34
2780492 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   grade_4                                                   42.0                                             42
2780784 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   grade_5                                                   36.0                                             36
2781076 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   grade_6                                                   29.0                                             29
2781368 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   grade_7                                                   0.0                                             0
2781660 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
2781952 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   grade_9                                                   0.0                                             0
2782244 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   grade_10                                                   0.0                                             0
2782536 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   grade_11                                                   0.0                                             0
2782828 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   grade_12                                                   0.0                                             0
2783120 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   pre_kindergarten                                                   1.0                                             1
2783412 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   pk_12_total                                               43.0   308.0                                         43   308
2779239 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   kindergarten                                                   41.0                                             41
2779531 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   grade_1                                                   40.0                                             40
2779823 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   grade_2                                                   52.0                                             52
2780115 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   grade_3                                                   35.0                                             35
2780407 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   grade_4                                                   43.0                                             43
2780699 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   grade_5                                                   51.0                                             51
2780991 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   grade_6                                                   51.0                                             51
2781283 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   grade_7                                                   0.0                                             0
2781575 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
2781867 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   grade_9                                                   0.0                                             0
2782159 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   grade_10                                                   0.0                                             0
2782451 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   grade_11                                                   0.0                                             0
2782743 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   grade_12                                                   0.0                                             0
2783035 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   pre_kindergarten                                                   5.0                                             5
2783327 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   pk_12_total                                               36.0   354.0                                         36   354
2779240 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0
2779532 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   grade_1                                                   0.0                                             0
2779824 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   grade_2                                                   0.0                                             0
2780116 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   grade_3                                                   0.0                                             0
2780408 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   grade_4                                                   0.0                                             0
2780700 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   grade_5                                                   0.0                                             0
2780992 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   grade_6                                                   0.0                                             0
2781284 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
2781576 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   grade_8                                                   0.0                                             0
2781868 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   grade_9                                                   216.0                                             216
2782160 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   grade_10                                                   243.0                                             243
2782452 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   grade_11                                                   216.0                                             216
2782744 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   grade_12                                                   203.0                                             203
2783036 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   pre_kindergarten                                                   0.0                                             0
2783328 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   pk_12_total                                               119.0   997.0                                         119   997
2779241 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   kindergarten                                                   0.0                                             0
2779533 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   grade_1                                                   0.0                                             0
2779825 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   grade_2                                                   0.0                                             0
2780117 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   grade_3                                                   0.0                                             0
2780409 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   grade_4                                                   0.0                                             0
2780701 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   grade_5                                                   0.0                                             0
2780993 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   grade_6                                                   0.0                                             0
2781285 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   grade_7                                                   261.0                                             261
2781577 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   grade_8                                                   257.0                                             257
2781869 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   grade_9                                                   0.0                                             0
2782161 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   grade_10                                                   0.0                                             0
2782453 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   grade_11                                                   0.0                                             0
2782745 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   grade_12                                                   0.0                                             0
2783037 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   pre_kindergarten                                                   0.0                                             0
2783329 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   pk_12_total                                               70.0   588.0                                         70   588
2779340 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   kindergarten                                                   70.0                                             70
2779632 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   grade_1                                                   63.0                                             63
2779924 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   grade_2                                                   59.0                                             59
2780216 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   grade_3                                                   62.0                                             62
2780508 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   grade_4                                                   75.0                                             75
2780800 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   grade_5                                                   49.0                                             49
2781092 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   grade_6                                                   59.0                                             59
2781384 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   grade_7                                                   0.0                                             0
2781676 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
2781968 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   grade_9                                                   0.0                                             0
2782260 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   grade_10                                                   0.0                                             0
2782552 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   grade_11                                                   0.0                                             0
2782844 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   grade_12                                                   0.0                                             0
2783136 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   pre_kindergarten                                                   1.0                                             1
2783428 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   pk_12_total                                               36.0   474.0                                         36   474
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