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
126504 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   kindergarten                                                   167.0                                             167
126794 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   grade_1                                                   159.0                                             159
127084 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   grade_2                                                   132.0                                             132
127374 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   grade_3                                                   171.0                                             171
127664 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   grade_4                                                   184.0                                             184
127954 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   grade_5                                                   173.0                                             173
128244 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   grade_6                                                   196.0                                             196
128534 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   grade_7                                                   0.0                                             0
128824 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
129114 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   grade_9                                                   0.0                                             0
129404 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   grade_10                                                   0.0                                             0
129694 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   grade_11                                                   0.0                                             0
129984 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   grade_12                                                   0.0                                             0
130274 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   7.0                                             7
130564 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   pk_12_total                                               80.0   1269.0                                         80   1269
126521 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   kindergarten                                                   42.0                                             42
126811 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   grade_1                                                   44.0                                             44
127101 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   grade_2                                                   31.0                                             31
127391 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   grade_3                                                   40.0                                             40
127681 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   grade_4                                                   35.0                                             35
127971 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   grade_5                                                   31.0                                             31
128261 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   grade_6                                                   38.0                                             38
128551 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   grade_7                                                   0.0                                             0
128841 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
129131 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   grade_9                                                   0.0                                             0
129421 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   grade_10                                                   0.0                                             0
129711 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   grade_11                                                   0.0                                             0
130001 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   grade_12                                                   0.0                                             0
130291 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   0.0                                             0
130581 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   pk_12_total                                               39.0   300.0                                         39   300
126436 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   kindergarten                                                   49.0                                             49
126726 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   grade_1                                                   54.0                                             54
127016 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   grade_2                                                   33.0                                             33
127306 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   grade_3                                                   44.0                                             44
127596 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   grade_4                                                   61.0                                             61
127886 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   grade_5                                                   48.0                                             48
128176 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   grade_6                                                   39.0                                             39
128466 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   grade_7                                                   0.0                                             0
128756 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
129046 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   grade_9                                                   0.0                                             0
129336 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   grade_10                                                   0.0                                             0
129626 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   grade_11                                                   0.0                                             0
129916 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   grade_12                                                   0.0                                             0
130206 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   3.0                                             3
130496 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   pk_12_total                                               42.0   373.0                                         42   373
126437 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   kindergarten                                                   0.0                                             0
126727 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   grade_1                                                   0.0                                             0
127017 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   grade_2                                                   0.0                                             0
127307 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   grade_3                                                   0.0                                             0
127597 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   grade_4                                                   0.0                                             0
127887 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   grade_5                                                   0.0                                             0
128177 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   grade_6                                                   0.0                                             0
128467 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   grade_7                                                   0.0                                             0
128757 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   grade_8                                                   0.0                                             0
129047 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   grade_9                                                   262.0                                             262
129337 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   grade_10                                                   241.0                                             241
129627 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   grade_11                                                   218.0                                             218
129917 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   grade_12                                                   172.0                                             172
130207 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   pre_kindergarten                                                   0.0                                             0
130497 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   pk_12_total                                               138.0   1031.0                                         138   1031
126438 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   kindergarten                                                   0.0                                             0
126728 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_1                                                   0.0                                             0
127018 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_2                                                   0.0                                             0
127308 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_3                                                   0.0                                             0
127598 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_4                                                   0.0                                             0
127888 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_5                                                   0.0                                             0
128178 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_6                                                   0.0                                             0
128468 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_7                                                   258.0                                             258
128758 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_8                                                   261.0                                             261
129048 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_9                                                   0.0                                             0
129338 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_10                                                   0.0                                             0
129628 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_11                                                   0.0                                             0
129918 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_12                                                   0.0                                             0
130208 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   pre_kindergarten                                                   0.0                                             0
130498 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   pk_12_total                                               67.0   586.0                                         67   586
126537 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   kindergarten                                                   74.0                                             74
126827 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   grade_1                                                   64.0                                             64
127117 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   grade_2                                                   62.0                                             62
127407 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   grade_3                                                   63.0                                             63
127697 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   grade_4                                                   59.0                                             59
127987 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   grade_5                                                   61.0                                             61
128277 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   grade_6                                                   43.0                                             43
128567 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   grade_7                                                   0.0                                             0
128857 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   grade_8                                                   0.0                                             0
129147 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   grade_9                                                   0.0                                             0
129437 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   grade_10                                                   0.0                                             0
129727 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   grade_11                                                   0.0                                             0
130017 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   grade_12                                                   0.0                                             0
130307 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   6.0                                             6
130597 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   pk_12_total                                               35.0   467.0                                         35   467
126383 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No Elementary PK 5 2017   kindergarten                                                   85.0                                             85
126673 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No Elementary PK 5 2017   grade_1                                                   71.0                                             71
126963 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No Elementary PK 5 2017   grade_2                                                   51.0                                             51
127253 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No Elementary PK 5 2017   grade_3                                                   74.0                                             74
127543 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No Elementary PK 5 2017   grade_4                                                   86.0                                             86
127833 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No Elementary PK 5 2017   grade_5                                                   80.0                                             80
128123 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No Elementary PK 5 2017   grade_6                                                   0.0                                             0
128413 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No Elementary PK 5 2017   grade_7                                                   0.0                                             0
128703 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No Elementary PK 5 2017   grade_8                                                   0.0                                             0
128993 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No Elementary PK 5 2017   grade_9                                                   0.0                                             0
129283 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No Elementary PK 5 2017   grade_10                                                   0.0                                             0