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
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
2782400 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   grade_11                                                   471.0                                             471
2782692 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   grade_12                                                   441.0                                             441
2782984 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   pre_kindergarten                                                   0.0                                             0
2783276 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   pk_12_total                                               247.0   2309.0                                         247   2309
2779189 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   kindergarten                                                   41.0                                             41
2779481 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   grade_1                                                   45.0                                             45
2779773 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   grade_2                                                   86.0                                             86
2780065 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   grade_3                                                   65.0                                             65
2780357 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   grade_4                                                   81.0                                             81
2780649 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   grade_5                                                   83.0                                             83
2780941 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   grade_6                                                   0.0                                             0
2781233 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   grade_7                                                   0.0                                             0
2781525 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2781817 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   grade_9                                                   0.0                                             0
2782109 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0
2782401 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0
2782693 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   grade_12                                                   0.0                                             0
2782985 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   pre_kindergarten                                                   4.0                                             4
2783277 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   pk_12_total                                               33.0   438.0                                         33   438
2779190 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   kindergarten                                                   70.0                                             70
2779482 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   grade_1                                                   83.0                                             83
2779774 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   grade_2                                                   81.0                                             81
2780066 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   grade_3                                                   94.0                                             94
2780358 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   grade_4                                                   75.0                                             75
2780650 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   grade_5                                                   110.0                                             110
2780942 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   grade_6                                                   0.0                                             0
2781234 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   grade_7                                                   0.0                                             0
2781526 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2781818 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   grade_9                                                   0.0                                             0
2782110 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0
2782402 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0
2782694 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   grade_12                                                   0.0                                             0
2782986 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   pre_kindergarten                                                   11.0                                             11
2783278 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   pk_12_total                                               25.0   549.0                                         25   549
2779215 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   kindergarten                                                   50.0                                             50
2779507 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   grade_1                                                   64.0                                             64
2779799 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   grade_2                                                   63.0                                             63
2780091 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   grade_3                                                   36.0                                             36
2780383 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   grade_4                                                   58.0                                             58
2780675 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   grade_5                                                   54.0                                             54
2780967 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   grade_6                                                   0.0                                             0
2781259 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   grade_7                                                   0.0                                             0
2781551 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2781843 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   grade_9                                                   0.0                                             0
2782135 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0
2782427 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0
2782719 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   grade_12                                                   0.0                                             0
2783011 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   pre_kindergarten                                                   0.0                                             0
2783303 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   pk_12_total                                               14.0   339.0                                         14   339
2779216 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   kindergarten                                                   0.0                                             0
2779508 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   grade_1                                                   0.0                                             0
2779800 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   grade_2                                                   0.0                                             0
2780092 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   grade_3                                                   0.0                                             0
2780384 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   grade_4                                                   0.0                                             0
2780676 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   grade_5                                                   0.0                                             0
2780968 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   grade_6                                                   72.0                                             72
2781260 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   grade_7                                                   69.0                                             69
2781552 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   grade_8                                                   74.0                                             74
2781844 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   grade_9                                                   0.0                                             0
2782136 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   grade_10                                                   0.0                                             0
2782428 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   grade_11                                                   0.0                                             0
2782720 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   grade_12                                                   0.0                                             0
2783012 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   pre_kindergarten                                                   0.0                                             0
2783304 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   pk_12_total                                               41.0   256.0                                         41   256
2779217 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   kindergarten                                                   63.0                                             63
2779509 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   grade_1                                                   46.0                                             46
2779801 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   grade_2                                                   54.0                                             54
2780093 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   grade_3                                                   50.0                                             50
2780385 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   grade_4                                                   62.0                                             62
2780677 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   grade_5                                                   50.0                                             50
2780969 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   grade_6                                                   0.0                                             0
2781261 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   grade_7                                                   0.0                                             0
2781553 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2781845 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   grade_9                                                   0.0                                             0
2782137 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0
2782429 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0
2782721 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   grade_12                                                   0.0                                             0
2783013 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   pre_kindergarten                                                   11.0                                             11
2783305 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   pk_12_total                                               44.0   380.0                                         44   380
2779218 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   kindergarten                                                   73.0                                             73
2779510 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   grade_1                                                   60.0                                             60
2779802 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   grade_2                                                   87.0                                             87
2780094 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   grade_3                                                   68.0                                             68
2780386 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   grade_4                                                   84.0                                             84
2780678 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   grade_5                                                   79.0                                             79
2780970 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   grade_6                                                   0.0                                             0
2781262 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   grade_7                                                   0.0                                             0
2781554 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2781846 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   grade_9                                                   0.0                                             0
2782138 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0
2782430 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0
2782722 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   grade_12                                                   0.0                                             0
2783014 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   pre_kindergarten                                                   15.0                                             15
2783306 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   pk_12_total                                               60.0   526.0                                         60   526
2779192 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2018   kindergarten                                                   39.0                                             39
2779484 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2018   grade_1                                                   40.0                                             40
2779776 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2018   grade_2                                                   49.0                                             49
2780068 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2018   grade_3                                                   27.0                                             27
2780360 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2018   grade_4                                                   46.0                                             46
2780652 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2018   grade_5                                                   68.0                                             68