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
2735805 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2019   grade_5                                                   0.0                                             0
2736097 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2019   grade_6                                                   0.0                                             0
2736389 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2019   grade_7                                                   0.0                                             0
2736681 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2019   grade_8                                                   0.0                                             0
2736973 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2019   grade_9                                                   351.0                                             351
2737265 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2019   grade_10                                                   277.0                                             277
2737557 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2019   grade_11                                                   300.0                                             300
2737849 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2019   grade_12                                                   255.0                                             255
2738141 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2019   pre_kindergarten                                                   0.0                                             0
2738433 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2019   pk_12_total                                               139.0   1322.0                                         139   1322
2734231 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   kindergarten                                                   82.0                                             82
2734523 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   grade_1                                                   75.0                                             75
2734815 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   grade_2                                                   79.0                                             79
2735107 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   grade_3                                                   69.0                                             69
2735399 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   grade_4                                                   70.0                                             70
2735691 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   grade_5                                                   84.0                                             84
2735983 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   grade_6                                                   0.0                                             0
2736275 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   grade_7                                                   0.0                                             0
2736567 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   grade_8                                                   0.0                                             0
2736859 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   grade_9                                                   0.0                                             0
2737151 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   grade_10                                                   0.0                                             0
2737443 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   grade_11                                                   0.0                                             0
2737735 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   grade_12                                                   0.0                                             0
2738027 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   pre_kindergarten                                                   22.0                                             22
2738319 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   pk_12_total                                               59.0   540.0                                         59   540
2734232 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2019   kindergarten                                                   0.0                                             0
2734524 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2019   grade_1                                                   0.0                                             0
2734816 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2019   grade_2                                                   0.0                                             0
2735108 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2019   grade_3                                                   0.0                                             0
2735400 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2019   grade_4                                                   0.0                                             0
2735692 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2019   grade_5                                                   0.0                                             0
2735984 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2019   grade_6                                                   0.0                                             0
2736276 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2019   grade_7                                                   0.0                                             0
2736568 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2019   grade_8                                                   0.0                                             0
2736860 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2019   grade_9                                                   776.0                                             776
2737152 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2019   grade_10                                                   710.0                                             710
2737444 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2019   grade_11                                                   692.0                                             692
2737736 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2019   grade_12                                                   623.0                                             623
2738028 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2019   pre_kindergarten                                                   0.0                                             0
2738320 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2019   pk_12_total                                               294.0   3095.0                                         294   3095
2734275 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2019   kindergarten                                                   0.0                                             0
2734567 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2019   grade_1                                                   0.0                                             0
2734859 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2019   grade_2                                                   0.0                                             0
2735151 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2019   grade_3                                                   0.0                                             0
2735443 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2019   grade_4                                                   0.0                                             0
2735735 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2019   grade_5                                                   0.0                                             0
2736027 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2019   grade_6                                                   0.0                                             0
2736319 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2019   grade_7                                                   0.0                                             0
2736611 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2019   grade_8                                                   0.0                                             0
2736903 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2019   grade_9                                                   239.0                                             239
2737195 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2019   grade_10                                                   245.0                                             245
2737487 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2019   grade_11                                                   239.0                                             239
2737779 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2019   grade_12                                                   206.0                                             206
2738071 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2019   pre_kindergarten                                                   0.0                                             0
2738363 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2019   pk_12_total                                               200.0   1129.0                                         200   1129
2734164 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   kindergarten                                                   0.0                                             0
2734456 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   grade_1                                                   0.0                                             0
2734748 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   grade_2                                                   0.0                                             0
2735040 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   grade_3                                                   0.0                                             0
2735332 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   grade_4                                                   0.0                                             0
2735624 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   grade_5                                                   0.0                                             0
2735916 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   grade_6                                                   127.0                                             127
2736208 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   grade_7                                                   125.0                                             125
2736500 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   grade_8                                                   118.0                                             118
2736792 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   grade_9                                                   0.0                                             0
2737084 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   grade_10                                                   0.0                                             0
2737376 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   grade_11                                                   0.0                                             0
2737668 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   grade_12                                                   0.0                                             0
2737960 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   pre_kindergarten                                                   0.0                                             0
2738252 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   pk_12_total                                               44.0   414.0                                         44   414
2734397 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2019   kindergarten                                                   17.0                                             17
2734689 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2019   grade_1                                                   17.0                                             17
2734981 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2019   grade_2                                                   12.0                                             12
2735273 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2019   grade_3                                                   21.0                                             21
2735565 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2019   grade_4                                                   22.0                                             22
2735857 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2019   grade_5                                                   19.0                                             19
2736149 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2019   grade_6                                                   20.0                                             20
2736441 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2019   grade_7                                                   29.0                                             29
2736733 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2019   grade_8                                                   29.0                                             29
2737025 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2019   grade_9                                                   27.0                                             27
2737317 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2019   grade_10                                                   25.0                                             25
2737609 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2019   grade_11                                                   25.0                                             25
2737901 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2019   grade_12                                                   12.0                                             12
2738193 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2019   pre_kindergarten                                                   0.0                                             0
2738485 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2019   pk_12_total                                               60.0   335.0                                         60   335
2734137 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   kindergarten                                                   0.0                                             0
2734429 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   grade_1                                                   0.0                                             0
2734721 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   grade_2                                                   0.0                                             0
2735013 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   grade_3                                                   0.0                                             0
2735305 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   grade_4                                                   0.0                                             0
2735597 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   grade_5                                                   0.0                                             0
2735889 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   grade_6                                                   218.0                                             218
2736181 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   grade_7                                                   268.0                                             268
2736473 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   grade_8                                                   202.0                                             202
2736765 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   grade_9                                                   0.0                                             0
2737057 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   grade_10                                                   0.0                                             0
2737349 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   grade_11                                                   0.0                                             0
2737641 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   grade_12                                                   0.0                                             0
2737933 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   pre_kindergarten                                                   0.0                                             0
2738225 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   pk_12_total                                               77.0   765.0                                         77   765
2734376 HI     school 1500030 1   Hawaii Department of Education 150003000081 451 Eleele Elem   Regular School No Elementary PK 5 2019   kindergarten                                                   70.0                                             70