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
281665 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No 4 PK 12 2015   pk_12_total                                               0.0   9.0                                         0   9
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
281566 HI     school 1500030 1   Hawaii Department of Education 150003000025 326 WAIAHOLE   Regular School No 1 PK 6 2015   pk_12_total                                               10.0   82.0                                         10   82
281582 HI     school 1500030 1   Hawaii Department of Education 150003000028 352 HAAHEO   Regular School No 1 PK 6 2015   pk_12_total                                               10.0   192.0                                         10   192
281699 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes 4 KG 12 2015   pk_12_total                                               10.0   179.0                                         10   179
281528 HI     school 1500030 1   Hawaii Department of Education 150003000119 261 NANAIKAPONO   Regular School No 1 PK 6 2015   pk_12_total                                               100.0   868.0                                         100   868
281656 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No 2 06 8 2015   pk_12_total                                               102.0   943.0                                         102   943
281626 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No 2 06 8 2015   pk_12_total                                               103.0   822.0                                         103   822
281574 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 KALAHEO HI   Regular School No 3 09 12 2015   pk_12_total                                               105.0   916.0                                         105   916
281504 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No 2 06 8 2015   pk_12_total                                               108.0   838.0                                         108   838
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
281423 HI     school 1500030 1   Hawaii Department of Education 150003000228 154 KAISER HI   Regular School No 3 09 12 2015   pk_12_total                                               110.0   1156.0                                         110   1156
281463 HI     school 1500030 1   Hawaii Department of Education 150003000186 146 ROOSEVELT HI   Regular School No 3 09 12 2015   pk_12_total                                               118.0   1423.0                                         118   1423
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
281443 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 HOKULANI   Regular School No 1 PK 5 2015   pk_12_total                                               12.0   364.0                                         12   364
281459 HI     school 1500030 1   Hawaii Department of Education 150003000191 140 NOELANI   Regular School No 1 PK 5 2015   pk_12_total                                               12.0   441.0                                         12   441
281596 HI     school 1500030 1   Hawaii Department of Education 150003000249 361 HONOKAA EL   Regular School No 1 PK 6 2015   pk_12_total                                               12.0   344.0                                         12   344
281676 HI     school 1500030 1   Hawaii Department of Education 150003000264 398 WATERS OF LIFE-PCS charter Regular School Yes 1 KG 6 2015   pk_12_total                                               12.0   172.0                                         12   172
281647 HI     school 1500030 1   Hawaii Department of Education 150003000069 414 LAHAINALUNA HI   Regular School No 3 09 12 2015   pk_12_total                                               120.0   1014.0                                         120   1014
281658 HI     school 1500030 1   Hawaii Department of Education 150003000085 455 KAPAA HI   Regular School No 3 09 12 2015   pk_12_total                                               120.0   1067.0                                         120   1067
281561 HI     school 1500030 1   Hawaii Department of Education 150003000016 318 KING INT   Regular School No 2 07 8 2015   pk_12_total                                               122.0   677.0                                         122   677
281670 HI     school 1500030 1   Hawaii Department of Education 150003000240 275 KAMAILE ACADEMY charter Regular School Yes 4 PK 12 2015   pk_12_total                                               122.0   962.0                                         122   962
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
281597 HI     school 1500030 1   Hawaii Department of Education 150003000034 360 HONOKAA HI & INT   Regular School No 3 07 12 2015   pk_12_total                                               125.0   671.0                                         125   671
281533 HI     school 1500030 1   Hawaii Department of Education 150003000229 273 WAIANAE INT   Regular School No 2 07 8 2015   pk_12_total                                               128.0   884.0                                         128   884
281621 HI     school 1500030 1   Hawaii Department of Education 150003000050 383 PAHOA HI & INT   Regular School No 3 07 12 2015   pk_12_total                                               129.0   684.0                                         129   684
281449 HI     school 1500030 1   Hawaii Department of Education 150003000206 125 KAULUWELA   Regular School No 1 PK 5 2015   pk_12_total                                               13.0   349.0                                         13   349
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
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
281682 HI     school 1500030 1   Hawaii Department of Education 150003000272 542 HALAU LOKAHI NC-PCS charter Regular School Yes 4 KG 12 2015   pk_12_total                                               13.0   161.0                                         13   161
281701 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes 1 KG 8 2015   pk_12_total                                               13.0   236.0                                         13   236
281571 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 KAILUA HI   Regular School No 3 09 12 2015   pk_12_total                                               132.0   750.0                                         132   750
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
281468 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No 3 09 12 2015   pk_12_total                                               135.0   1111.0                                         135   1111
281595 HI     school 1500030 1   Hawaii Department of Education 150003000033 359 HONAUNAU   Regular School No 1 PK 5 2015   pk_12_total                                               14.0   153.0                                         14   153
281671 HI     school 1500030 1   Hawaii Department of Education 150003000018 320 LANIKAI-PCS charter Regular School Yes 1 KG 6 2015   pk_12_total                                               14.0   328.0                                         14   328
281677 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 WEST HI EXPLOR ACAD-PCS charter Regular School Yes 4 06 12 2015   pk_12_total                                               14.0   248.0                                         14   248
281499 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No 2 06 8 2015   pk_12_total                                               142.0   1766.0                                         142   1766
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
281622 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 BALDWIN HI   Regular School No 3 09 12 2015   pk_12_total                                               147.0   1467.0                                         147   1467
281615 HI     school 1500030 1   Hawaii Department of Education 150003000260 354 KEAAU HI   Regular School No 3 09 12 2015   pk_12_total                                               148.0   871.0                                         148   871
281569 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2015   pk_12_total                                               15.0   196.0                                         15   196
281688 HI     school 1500030 1   Hawaii Department of Education 150003000277 548 INNOVATIONS-PCS charter Regular School Yes 1 KG 8 2015   pk_12_total                                               15.0   228.0                                         15   228
281458 HI     school 1500030 1   Hawaii Department of Education 150003000193 138 MCKINLEY HI   Regular School No 3 09 12 2015   pk_12_total                                               151.0   1671.0                                         151   1671
281628 HI     school 1500030 1   Hawaii Department of Education 150003000251 435 KEKAULIKE HI   Regular School No 3 09 12 2015   pk_12_total                                               152.0   1086.0                                         152   1086
281520 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No 2 06 8 2015   pk_12_total                                               153.0   1435.0                                         153   1435
281436 HI     school 1500030 1   Hawaii Department of Education 150003000187 145 PUUHALE   Regular School No 1 PK 5 2015   pk_12_total                                               16.0   239.0                                         16   239
281475 HI     school 1500030 1   Hawaii Department of Education 150003000103 218 MOANALUA HI   Regular School No 3 09 12 2015   pk_12_total                                               161.0   1998.0                                         161   1998
281447 HI     school 1500030 1   Hawaii Department of Education 150003000212 115 KAIMUKI HI   Regular School No 3 09 12 2015   pk_12_total                                               168.0   760.0                                         168   760
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
281600 HI     school 1500030 1   Hawaii Department of Education 150003000287 378 KE KULA O EHUNUIKAIMALINO   Regular School No 4 PK 12 2015   pk_12_total                                               17.0   222.0                                         17   222
281664 HI     school 1500030 1   Hawaii Department of Education 150003000090 460 KOLOA   Regular School No 1 PK 5 2015   pk_12_total                                               17.0   369.0                                         17   369
281558 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2015   pk_12_total                                               176.0   1432.0                                         176   1432
281462 HI     school 1500030 1   Hawaii Department of Education 150003000188 143 PAUOA   Regular School No 1 PK 5 2015   pk_12_total                                               18.0   299.0                                         18   299
281610 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 PAAUILO EL & INT   Regular School No 4 PK 9 2015   pk_12_total                                               18.0   228.0                                         18   228
281636 HI     school 1500030 1   Hawaii Department of Education 150003000076 422 PAIA   Regular School No 1 PK 5 2015   pk_12_total                                               18.0   342.0                                         18   342
281428 HI     school 1500030 1   Hawaii Department of Education 150003000210 122 KALIHI-UKA   Regular School No 1 PK 5 2015   pk_12_total                                               19.0   266.0                                         19   266
281431 HI     school 1500030 1   Hawaii Department of Education 150003000207 124 KAPALAMA   Regular School No 1 PK 5 2015   pk_12_total                                               19.0   605.0                                         19   605
281452 HI     school 1500030 1   Hawaii Department of Education 150003000202 129 LANAKILA   Regular School No 1 PK 5 2015   pk_12_total                                               19.0   407.0                                         19   407
281474 HI     school 1500030 1   Hawaii Department of Education 150003000104 217 MOANALUA EL   Regular School No 1 PK 6 2015   pk_12_total                                               19.0   610.0                                         19   610
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
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
281634 HI     school 1500030 1   Hawaii Department of Education 150003000073 418 MAUI HI   Regular School No 3 09 12 2015   pk_12_total                                               194.0   1931.0                                         194   1931
281690 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 MALAMA HONUA PCS charter Regular School Yes 1 KG 2 2015   pk_12_total                                               2.0   41.0                                         2   41
281448 HI     school 1500030 1   Hawaii Department of Education 150003000165 117 KAIULANI   Regular School No 1 PK 5 2015   pk_12_total                                               20.0   388.0                                         20   388
281678 HI     school 1500030 1   Hawaii Department of Education 150003000066 411 KUALAPUU charter Regular School Yes 1 PK 6 2015   pk_12_total                                               20.0   306.0                                         20   306
281697 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes 4 KG 12 2015   pk_12_total                                               20.0   260.0                                         20   260
281429 HI     school 1500030 1   Hawaii Department of Education 150003000209 123 KALIHI-WAENA   Regular School No 1 PK 5 2015   pk_12_total                                               21.0   546.0                                         21   546
281453 HI     school 1500030 1   Hawaii Department of Education 150003000200 131 LIKELIKE   Regular School No 1 PK 5 2015   pk_12_total                                               21.0   370.0                                         21   370
281545 HI     school 1500030 1   Hawaii Department of Education 150003000114 266 PEARL CITY HI   Regular School No 3 09 12 2015   pk_12_total                                               211.0   1683.0                                         211   1683
281461 HI     school 1500030 1   Hawaii Department of Education 150003000189 142 PALOLO   Regular School No 1 PK 5 2015   pk_12_total                                               22.0   269.0                                         22   269
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
281451 HI     school 1500030 1   Hawaii Department of Education 150003000203 128 KUHIO   Regular School No 1 PK 5 2015   pk_12_total                                               23.0   289.0                                         23   289
281490 HI     school 1500030 1   Hawaii Department of Education 150003000172 206 HALEIWA   Regular School No 1 PK 6 2015   pk_12_total                                               23.0   199.0                                         23   199
281675 HI     school 1500030 1   Hawaii Department of Education 150003000263 397 KANU O KA'AINA-PCS charter Regular School Yes 4 KG 12 2015   pk_12_total                                               23.0   307.0                                         23   307
281681 HI     school 1500030 1   Hawaii Department of Education 150003000271 541 VOYAGER-PCS charter Regular School Yes 1 KG 8 2015   pk_12_total                                               23.0   282.0                                         23   282
281694 HI     school 1500030 1   Hawaii Department of Education 150003000288 557 KUA O KA LA-PCS charter Regular School Yes 4 KG 12 2015   pk_12_total                                               23.0   229.0                                         23   229
281416 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2015   pk_12_total                                               239.0   2417.0                                         239   2417
281441 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2015   pk_12_total                                               24.0   403.0                                         24   403
281588 HI     school 1500030 1   Hawaii Department of Education 150003000039 369 KAUMANA   Regular School No 1 PK 6 2015   pk_12_total                                               24.0   298.0                                         24   298
281594 HI     school 1500030 1   Hawaii Department of Education 150003000032 358 HOLUALOA   Regular School No 1 PK 5 2015   pk_12_total                                               24.0   482.0                                         24   482
281530 HI     school 1500030 1   Hawaii Department of Education 150003000117 263 NANAKULI HI & INT   Regular School No 3 07 12 2015   pk_12_total                                               246.0   1043.0                                         246   1043
281519 HI     school 1500030 1   Hawaii Department of Education 150003000261 292 KAPOLEI HI   Regular School No 3 09 12 2015   pk_12_total                                               248.0   2024.0                                         248   2024
281418 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No 1 PK 5 2015   pk_12_total                                               25.0   559.0                                         25   559
281430 HI     school 1500030 1   Hawaii Department of Education 150003000208 155 KAMILOIKI   Regular School No 1 PK 5 2015   pk_12_total                                               25.0   427.0                                         25   427
281581 HI     school 1500030 1   Hawaii Department of Education 150003000027 351 DE SILVA   Regular School No 1 PK 6 2015   pk_12_total                                               25.0   441.0                                         25   441
281651 HI     school 1500030 1   Hawaii Department of Education 150003000290 434 MOLOKAI MID   Regular School No 2 07 8 2015   pk_12_total                                               25.0   197.0                                         25   197
281654 HI     school 1500030 1   Hawaii Department of Education 150003000082 452 HANALEI   Regular School No 1 PK 6 2015   pk_12_total                                               25.0   300.0                                         25   300
281683 HI     school 1500030 1   Hawaii Department of Education 150003000273 543 EDUC LAB: A HAWAII NC-PCS charter Regular School Yes 4 KG 12 2015   pk_12_total                                               25.0   444.0                                         25   444
281495 HI     school 1500030 1   Hawaii Department of Education 150003000108 214 LEILEHUA HI   Regular School No 3 09 12 2015   pk_12_total                                               251.0   1745.0                                         251   1745
281549 HI     school 1500030 1   Hawaii Department of Education 150003000161 277 WAIPAHU HI   Regular School No 3 09 12 2015   pk_12_total                                               259.0   2494.0                                         259   2494
281421 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 KAHALA   Regular School No 1 PK 5 2015   pk_12_total                                               26.0   402.0                                         26   402
281456 HI     school 1500030 1   Hawaii Department of Education 150003000196 136 MAEMAE   Regular School No 1 PK 6 2015   pk_12_total                                               26.0   657.0                                         26   657
281578 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2015   pk_12_total                                               26.0   72.0                                         26   72
281638 HI     school 1500030 1   Hawaii Department of Education 150003000077 426 PUKALANI   Regular School No 1 PK 5 2015   pk_12_total                                               26.0   453.0                                         26   453
281663 HI     school 1500030 1   Hawaii Department of Education 150003000089 459 KILAUEA   Regular School No 1 PK 6 2015   pk_12_total                                               26.0   295.0                                         26   295
281692 HI     school 1500030 1   Hawaii Department of Education 150003000279 554 KIHEI PC SCHOOL-PCS charter Regular School Yes 4 KG 12 2015   pk_12_total                                               26.0   526.0                                         26   526
281427 HI     school 1500030 1   Hawaii Department of Education 150003000160 121 KALIHI-KAI   Regular School No 1 PK 5 2015   pk_12_total                                               27.0   600.0                                         27   600
281586 HI     school 1500030 1   Hawaii Department of Education 150003000036 365 KALANIANAOLE EL & INT   Regular School No 1 PK 8 2015   pk_12_total                                               27.0   286.0                                         27   286
281510 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 CAMPBELL HI   Regular School No 3 09 12 2015   pk_12_total                                               274.0   3024.0                                         274   3024
281433 HI     school 1500030 1   Hawaii Department of Education 150003000201 130 LIHOLIHO   Regular School No 1 PK 5 2015   pk_12_total                                               28.0   454.0                                         28   454