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
2432790 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 Maui Waena Int   Regular School No Middle 06 8 2020   pk_12_total                                               97.0   1162.0                                         97   1162
2457331 HI     school 1500030 1   Hawaii Department of Education 150003000150 224 Radford High   Regular School No High 09 12 2021   pk_12_total                                               128.0   1166.0                                         128   1166
2432815 HI     school 1500030 1   Hawaii Department of Education 150003000086 456 Kauai High   Regular School No High 09 12 2020   pk_12_total                                               114.0   1168.0                                         114   1168
2783413 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2018   pk_12_total                                               201.0   1173.0                                         201   1173
2432577 HI     school 1500030 1   Hawaii Department of Education 150003000228 154 Kaiser High   Regular School No High 09 12 2020   pk_12_total                                               104.0   1175.0                                         104   1175
2783496 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 Maui Waena Int   Regular School No Middle 06 8 2018   pk_12_total                                               106.0   1176.0                                         106   1176
2738394 HI     school 1500030 1   Hawaii Department of Education 150003000029 355 Hilo High   Regular School No High 09 12 2019   pk_12_total                                               200.0   1178.0                                         200   1178
111579 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 CASTLE HI   Regular School No 3 09 12 2016   pk_12_total                                               187.0   1179.0                                         187   1179
2457272 HI     school 1500030 1   Hawaii Department of Education 150003000228 154 Kaiser High   Regular School No High 09 12 2021   pk_12_total                                               95.0   1180.0                                         95   1180
130582 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 CASTLE HI   Regular School No High 09 12 2017   pk_12_total                                               199.0   1181.0                                         199   1181
2783374 HI     school 1500030 1   Hawaii Department of Education 150003000248 280 Holomua Elem   Regular School No Elementary PK 6 2018   pk_12_total                                               86.0   1181.0                                         86   1181
130665 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No Middle 06 8 2017   pk_12_total                                               111.0   1183.0                                         111   1183
130628 HI     school 1500030 1   Hawaii Department of Education 150003000035 363 HOOKENA   Regular School No Elementary PK 5 2017   pk_12_total                                               12.0   119.0                                         12   119
2432730 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 Keolu Elem   Regular School No Elementary PK 6 2020   pk_12_total                                               11.0   119.0                                         11   119
111618 HI     school 1500030 1   Hawaii Department of Education 150003000052 389 WAIAKEA HI   Regular School No 3 09 12 2016   pk_12_total                                               160.0   1197.0                                         160   1197
2738501 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 Hawaii Tech Acad PCS charter Regular School Yes Other KG 12 2019   pk_12_total                                               93.0   1197.0                                         93   1197
2432636 HI     school 1500030 1   Hawaii Department of Education 150003000150 224 Radford High   Regular School No High 09 12 2020   pk_12_total                                               116.0   1199.0                                         116   1199
2738497 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 Ke Kula O Kamakau Lab PCS charter Regular School Yes Other PK 12 2019   pk_12_total                                               3.0   120.0                                         3   120
130543 HI     school 1500030 1   Hawaii Department of Education 150003000248 280 HOLOMUA   Regular School No Elementary PK 6 2017   pk_12_total                                               81.0   1200.0                                         81   1200
2457449 HI     school 1500030 1   Hawaii Department of Education 150003000035 363 Hookena Elem   Regular School No Elementary PK 5 2021   pk_12_total                                               12.0   121.0                                         12   121
281552 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 CASTLE HI   Regular School No 3 09 12 2015   pk_12_total                                               194.0   1211.0                                         194   1211
281591 HI     school 1500030 1   Hawaii Department of Education 150003000052 389 WAIAKEA HI   Regular School No 3 09 12 2015   pk_12_total                                               168.0   1219.0                                         168   1219
2432738 HI     school 1500030 1   Hawaii Department of Education 150003000029 355 Hilo High   Regular School No High 09 12 2020   pk_12_total                                               185.0   1219.0                                         185   1219
111625 HI     school 1500030 1   Hawaii Department of Education 150003000035 363 HOOKENA   Regular School No 1 PK 5 2016   pk_12_total                                               11.0   122.0                                         11   122
2432710 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2020   pk_12_total                                               17.0   122.0                                         17   122
281583 HI     school 1500030 1   Hawaii Department of Education 150003000029 355 HILO HI   Regular School No 3 09 12 2015   pk_12_total                                               222.0   1224.0                                         222   1224
130605 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No Elementary PK 6 2017   pk_12_total                                               13.0   123.0                                         13   123
2738507 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   pk_12_total                                               4.0   123.0                                         4   123
2457442 HI     school 1500030 1   Hawaii Department of Education 150003000052 389 Waiakea High   Regular School No High 09 12 2021   pk_12_total                                               101.0   1233.0                                         101   1233
111629 HI     school 1500030 1   Hawaii Department of Education 150003000254 392 KEALAKEHE HI   Regular School No 3 09 12 2016   pk_12_total                                               140.0   1237.0                                         140   1237
2432844 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 Ke Kula O Kamakau Lab PCS charter Regular School Yes Other PK 12 2020   pk_12_total                                               2.0   124.0                                         2   124
2783436 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 Keolu Elem   Regular School No Elementary PK 6 2018   pk_12_total                                               12.0   124.0                                         12   124
2738402 HI     school 1500030 1   Hawaii Department of Education 150003000052 389 Waiakea High   Regular School No High 09 12 2019   pk_12_total                                               118.0   1241.0                                         118   1241
111540 HI     school 1500030 1   Hawaii Department of Education 150003000248 280 HOLOMUA   Regular School No 1 PK 6 2016   pk_12_total                                               85.0   1243.0                                         85   1243
2738292 HI     school 1500030 1   Hawaii Department of Education 150003000150 224 Radford High   Regular School No High 09 12 2019   pk_12_total                                               124.0   1244.0                                         124   1244
130585 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No Elementary PK 6 2017   pk_12_total                                               21.0   125.0                                         21   125
2783416 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2018   pk_12_total                                               20.0   125.0                                         20   125
130621 HI     school 1500030 1   Hawaii Department of Education 150003000052 389 WAIAKEA HI   Regular School No High 09 12 2017   pk_12_total                                               140.0   1253.0                                         140   1253
2457385 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 Ahrens Elem   Regular School No Elementary PK 6 2021   pk_12_total                                               83.0   1256.0                                         83   1256
2783452 HI     school 1500030 1   Hawaii Department of Education 150003000052 389 Waiakea High   Regular School No High 09 12 2018   pk_12_total                                               122.0   1256.0                                         122   1256
2783395 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2018   pk_12_total                                               75.0   1258.0                                         75   1258
281555 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   pk_12_total                                               13.0   126.0                                         13   126
281702 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes 2 06 8 2015   pk_12_total                                               19.0   126.0                                         19   126
2738500 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   pk_12_total                                               8.0   126.0                                         8   126
2738345 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               67.0   1260.0                                         67   1260
2457362 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 Ewa Makai Middle   Regular School No Middle 06 8 2021   pk_12_total                                               86.0   1262.0                                         86   1262
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
281687 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 KE KULA O KAMAKAU LAB-PCS charter Regular School Yes 4 PK 12 2015   pk_12_total                                               1.0   127.0                                         1   127
2457434 HI     school 1500030 1   Hawaii Department of Education 150003000029 355 Hilo High   Regular School No High 09 12 2021   pk_12_total                                               194.0   1272.0                                         194   1272
2738361 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 Waipahu Int   Regular School No Middle 07 8 2019   pk_12_total                                               105.0   1275.0                                         105   1275
2783342 HI     school 1500030 1   Hawaii Department of Education 150003000150 224 Radford High   Regular School No High 09 12 2018   pk_12_total                                               124.0   1275.0                                         124   1275
281425 HI     school 1500030 1   Hawaii Department of Education 150003000163 119 KALANI HI   Regular School No 3 09 12 2015   pk_12_total                                               134.0   1277.0                                         134   1277
281514 HI     school 1500030 1   Hawaii Department of Education 150003000248 280 HOLOMUA   Regular School No 1 PK 6 2015   pk_12_total                                               77.0   1279.0                                         77   1279
111582 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2016   pk_12_total                                               13.0   128.0                                         13   128
130632 HI     school 1500030 1   Hawaii Department of Education 150003000254 392 KEALAKEHE HI   Regular School No High 09 12 2017   pk_12_total                                               149.0   1281.0                                         149   1281
281550 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 WAIPAHU INT   Regular School No 2 07 8 2015   pk_12_total                                               119.0   1281.0                                         119   1281
2432746 HI     school 1500030 1   Hawaii Department of Education 150003000052 389 Waiakea High   Regular School No High 09 12 2020   pk_12_total                                               110.0   1282.0                                         110   1282
2432830 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 Hawaii Tech Acad PCS charter Regular School Yes Other KG 12 2020   pk_12_total                                               103.0   1285.0                                         103   1285
2457401 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 Waipahu Int   Regular School No Middle 07 8 2021   pk_12_total                                               96.0   1289.0                                         96   1289
2738386 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 Keolu Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               16.0   129.0                                         16   129
2432689 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2020   pk_12_total                                               74.0   1294.0                                         74   1294
2783411 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 Waipahu Int   Regular School No Middle 07 8 2018   pk_12_total                                               104.0   1294.0                                         104   1294
130511 HI     school 1500030 1   Hawaii Department of Education 150003000150 224 RADFORD HI   Regular School No High 09 12 2017   pk_12_total                                               132.0   1298.0                                         132   1298
281602 HI     school 1500030 1   Hawaii Department of Education 150003000254 392 KEALAKEHE HI   Regular School No 3 09 12 2015   pk_12_total                                               145.0   1299.0                                         145   1299
2457473 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2021   pk_12_total                                               138.0   1299.0                                         138   1299
2432777 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2020   pk_12_total                                               138.0   1304.0                                         138   1304
111561 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No 1 PK 6 2016   pk_12_total                                               85.0   1309.0                                         85   1309
2432828 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2020   pk_12_total                                               24.0   131.0                                         24   131
2783463 HI     school 1500030 1   Hawaii Department of Education 150003000254 392 Kealakehe High   Regular School No High 09 12 2018   pk_12_total                                               134.0   1311.0                                         134   1311
130580 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 WAIPAHU INT   Regular School No Middle 07 8 2017   pk_12_total                                               99.0   1314.0                                         99   1314
2738366 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               15.0   132.0                                         15   132
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
2738406 HI     school 1500030 1   Hawaii Department of Education 150003000033 359 Honaunau Elem   Regular School No Elementary PK 5 2019   pk_12_total                                               14.0   133.0                                         14   133
2783549 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 Ke Kula O Kamakau Lab PCS charter Regular School Yes Other PK 12 2018   pk_12_total                                               1.0   133.0                                         1   133
111508 HI     school 1500030 1   Hawaii Department of Education 150003000150 224 RADFORD HI   Regular School No 3 09 12 2016   pk_12_total                                               131.0   1330.0                                         131   1330
111451 HI     school 1500030 1   Hawaii Department of Education 150003000163 119 KALANI HI   Regular School No 3 09 12 2016   pk_12_total                                               140.0   1331.0                                         140   1331
2457526 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 Hawaii Tech Academy PCS charter Regular School Yes Other KG 12 2021   pk_12_total                                               114.0   1337.0                                         114   1337
111577 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 WAIPAHU INT   Regular School No 2 07 8 2016   pk_12_total                                               134.0   1339.0                                         134   1339
281680 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes 4 04 12 2015   pk_12_total                                               13.0   134.0                                         13   134
281534 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No 1 PK 6 2015   pk_12_total                                               75.0   1342.0                                         75   1342
281482 HI     school 1500030 1   Hawaii Department of Education 150003000150 224 RADFORD HI   Regular School No 3 09 12 2015   pk_12_total                                               124.0   1347.0                                         124   1347
2432705 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 Waipahu Int   Regular School No Middle 07 8 2020   pk_12_total                                               103.0   1349.0                                         103   1349
2432713 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2020   pk_12_total                                               171.0   1351.0                                         171   1351
130492 HI     school 1500030 1   Hawaii Department of Education 150003000186 146 ROOSEVELT HI   Regular School No High 09 12 2017   pk_12_total                                               141.0   1355.0                                         141   1355
2432757 HI     school 1500030 1   Hawaii Department of Education 150003000254 392 Kealakehe High   Regular School No High 09 12 2020   pk_12_total                                               153.0   1357.0                                         153   1357
111602 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No 1 PK 6 2016   pk_12_total                                               14.0   136.0                                         14   136
281598 HI     school 1500030 1   Hawaii Department of Education 150003000035 363 HOOKENA   Regular School No 1 PK 5 2015   pk_12_total                                               11.0   136.0                                         11   136
281700 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes 4 KG 12 2015   pk_12_total                                               6.0   136.0                                         6   136
2457540 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 Ke Kula O Kamakau Lab PCS charter Regular School Yes Other PK 12 2021   pk_12_total                                               3.0   136.0                                         3   136
130652 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 BALDWIN HI   Regular School No High 09 12 2017   pk_12_total                                               128.0   1361.0                                         128   1361
2783483 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2018   pk_12_total                                               145.0   1361.0                                         145   1361
2783323 HI     school 1500030 1   Hawaii Department of Education 150003000186 146 Roosevelt High   Regular School No High 09 12 2018   pk_12_total                                               140.0   1363.0                                         140   1363
111489 HI     school 1500030 1   Hawaii Department of Education 150003000186 146 ROOSEVELT HI   Regular School No 3 09 12 2016   pk_12_total                                               132.0   1368.0                                         132   1368
130454 HI     school 1500030 1   Hawaii Department of Education 150003000163 119 KALANI HI   Regular School No High 09 12 2017   pk_12_total                                               154.0   1371.0                                         154   1371
2738273 HI     school 1500030 1   Hawaii Department of Education 150003000186 146 Roosevelt High   Regular School No High 09 12 2019   pk_12_total                                               149.0   1372.0                                         149   1372
2738413 HI     school 1500030 1   Hawaii Department of Education 150003000254 392 Kealakehe High   Regular School No High 09 12 2019   pk_12_total                                               144.0   1374.0                                         144   1374
111585 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2016   pk_12_total                                               168.0   1379.0                                         168   1379
111460 HI     school 1500030 1   Hawaii Department of Education 150003000198 133 LINAPUNI   Regular School No 1 PK 1 2016   pk_12_total                                               6.0   138.0                                         6   138
281575 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No 1 PK 6 2015   pk_12_total                                               9.0   138.0                                         9   138
2738369 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   pk_12_total                                               177.0   1381.0                                         177   1381
2783285 HI     school 1500030 1   Hawaii Department of Education 150003000163 119 Kalani High   Regular School No High 09 12 2018   pk_12_total                                               140.0   1383.0                                         140   1383