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
111692 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No 4 PK 12 2016   pk_12_total                                               0.0   4.0                                         0   4
111720 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 MALAMA HONUA PCS charter Regular School Yes 1 KG 3 2016   pk_12_total                                               0.0   63.0                                         0   63
111555 HI     school 1500030 1   Hawaii Department of Education 150003000119 261 NANAIKAPONO   Regular School No 1 PK 6 2016   pk_12_total                                               100.0   848.0                                         100   848
111562 HI     school 1500030 1   Hawaii Department of Education 150003000131 255 HIGHLANDS INT   Regular School No 2 07 8 2016   pk_12_total                                               101.0   907.0                                         101   907
111687 HI     school 1500030 1   Hawaii Department of Education 150003000086 456 KAUAI HI   Regular School No 3 09 12 2016   pk_12_total                                               102.0   1131.0                                         102   1131
111553 HI     school 1500030 1   Hawaii Department of Education 150003000125 257 MAILI   Regular School No 1 PK 6 2016   pk_12_total                                               104.0   1022.0                                         104   1022
111651 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No 2 06 8 2016   pk_12_total                                               104.0   918.0                                         104   918
111648 HI     school 1500030 1   Hawaii Department of Education 150003000050 383 PAHOA HI & INT   Regular School No 3 07 12 2016   pk_12_total                                               105.0   576.0                                         105   576
111674 HI     school 1500030 1   Hawaii Department of Education 150003000069 414 LAHAINALUNA HI   Regular School No 3 09 12 2016   pk_12_total                                               105.0   964.0                                         105   964
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
111653 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No 2 06 8 2016   pk_12_total                                               114.0   861.0                                         114   861
111705 HI     school 1500030 1   Hawaii Department of Education 150003000240 275 KAMAILE ACADEMY charter Regular School Yes 4 PK 12 2016   pk_12_total                                               114.0   919.0                                         114   919
111624 HI     school 1500030 1   Hawaii Department of Education 150003000034 360 HONOKAA HI & INT   Regular School No 3 07 12 2016   pk_12_total                                               117.0   679.0                                         117   679
111685 HI     school 1500030 1   Hawaii Department of Education 150003000085 455 KAPAA HI   Regular School No 3 09 12 2016   pk_12_total                                               118.0   1046.0                                         118   1046
111475 HI     school 1500030 1   Hawaii Department of Education 150003000206 125 KAULUWELA   Regular School No 1 PK 5 2016   pk_12_total                                               12.0   367.0                                         12   367
111593 HI     school 1500030 1   Hawaii Department of Education 150003000025 326 WAIAHOLE   Regular School No 1 PK 6 2016   pk_12_total                                               12.0   87.0                                         12   87
111708 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes 4 KG 12 2016   pk_12_total                                               12.0   201.0                                         12   201
111588 HI     school 1500030 1   Hawaii Department of Education 150003000016 318 KING INT   Regular School No 2 07 8 2016   pk_12_total                                               127.0   668.0                                         127   668
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
111698 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes 4 04 12 2016   pk_12_total                                               13.0   66.0                                         13   66
111711 HI     school 1500030 1   Hawaii Department of Education 150003000278 549 KE ANA LA'AHANA-PCS charter Regular School Yes 3 07 12 2016   pk_12_total                                               13.0   44.0                                         13   44
111494 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No 3 09 12 2016   pk_12_total                                               130.0   1048.0                                         130   1048
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
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
111598 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 KAILUA HI   Regular School No 3 09 12 2016   pk_12_total                                               133.0   732.0                                         133   732
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
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
111627 HI     school 1500030 1   Hawaii Department of Education 150003000287 378 KE KULA O EHUNUIKAIMALINO   Regular School No 4 PK 12 2016   pk_12_total                                               14.0   225.0                                         14   225
111703 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes 4 PK 12 2016   pk_12_total                                               14.0   244.0                                         14   244
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
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
111649 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 BALDWIN HI   Regular School No 3 09 12 2016   pk_12_total                                               143.0   1398.0                                         143   1398
111655 HI     school 1500030 1   Hawaii Department of Education 150003000251 435 KEKAULIKE HI   Regular School No 3 09 12 2016   pk_12_total                                               143.0   1043.0                                         143   1043
111525 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No 2 06 8 2016   pk_12_total                                               147.0   1836.0                                         147   1836
111596 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No 1 PK 6 2016   pk_12_total                                               15.0   189.0                                         15   189
111718 HI     school 1500030 1   Hawaii Department of Education 150003000018 320 LANIKAI-PCS charter Regular School Yes 1 KG 6 2016   pk_12_total                                               15.0   316.0                                         15   316
111547 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No 2 06 8 2016   pk_12_total                                               153.0   1438.0                                         153   1438
111560 HI     school 1500030 1   Hawaii Department of Education 150003000229 273 WAIANAE INT   Regular School No 2 07 8 2016   pk_12_total                                               159.0   942.0                                         159   942
111469 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 HOKULANI   Regular School No 1 PK 5 2016   pk_12_total                                               16.0   370.0                                         16   370
111479 HI     school 1500030 1   Hawaii Department of Education 150003000200 131 LIKELIKE   Regular School No 1 PK 5 2016   pk_12_total                                               16.0   358.0                                         16   358
111500 HI     school 1500030 1   Hawaii Department of Education 150003000104 217 MOANALUA EL   Regular School No 1 PK 6 2016   pk_12_total                                               16.0   611.0                                         16   611
111691 HI     school 1500030 1   Hawaii Department of Education 150003000090 460 KOLOA   Regular School No 1 PK 5 2016   pk_12_total                                               16.0   390.0                                         16   390
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
111484 HI     school 1500030 1   Hawaii Department of Education 150003000193 138 MCKINLEY HI   Regular School No 3 09 12 2016   pk_12_total                                               161.0   1603.0                                         161   1603
111473 HI     school 1500030 1   Hawaii Department of Education 150003000212 115 KAIMUKI HI   Regular School No 3 09 12 2016   pk_12_total                                               167.0   741.0                                         167   741
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
111477 HI     school 1500030 1   Hawaii Department of Education 150003000203 128 KUHIO   Regular School No 1 PK 5 2016   pk_12_total                                               17.0   255.0                                         17   255
111622 HI     school 1500030 1   Hawaii Department of Education 150003000033 359 HONAUNAU   Regular School No 1 PK 5 2016   pk_12_total                                               17.0   159.0                                         17   159
111642 HI     school 1500030 1   Hawaii Department of Education 150003000260 354 KEAAU HI   Regular School No 3 09 12 2016   pk_12_total                                               174.0   988.0                                         174   988
111501 HI     school 1500030 1   Hawaii Department of Education 150003000103 218 MOANALUA HI   Regular School No 3 09 12 2016   pk_12_total                                               177.0   1986.0                                         177   1986
111716 HI     school 1500030 1   Hawaii Department of Education 150003000288 557 KUA O KA LA-PCS charter Regular School Yes 4 KG 12 2016   pk_12_total                                               18.0   149.0                                         18   149
111722 HI     school 1500030 1   Hawaii Department of Education 150003000264 398 NA WAI OLA PCS charter Regular School Yes 1 PK 7 2016   pk_12_total                                               18.0   211.0                                         18   211
111661 HI     school 1500030 1   Hawaii Department of Education 150003000073 418 MAUI HI   Regular School No 3 09 12 2016   pk_12_total                                               185.0   1906.0                                         185   1906
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
111462 HI     school 1500030 1   Hawaii Department of Education 150003000187 145 PUUHALE   Regular School No 1 PK 5 2016   pk_12_total                                               19.0   240.0                                         19   240
111474 HI     school 1500030 1   Hawaii Department of Education 150003000165 117 KAIULANI   Regular School No 1 PK 5 2016   pk_12_total                                               19.0   378.0                                         19   378
111485 HI     school 1500030 1   Hawaii Department of Education 150003000191 140 NOELANI   Regular School No 1 PK 5 2016   pk_12_total                                               19.0   437.0                                         19   437
111488 HI     school 1500030 1   Hawaii Department of Education 150003000188 143 PAUOA   Regular School No 1 PK 5 2016   pk_12_total                                               19.0   296.0                                         19   296
111663 HI     school 1500030 1   Hawaii Department of Education 150003000076 422 PAIA   Regular School No 1 PK 5 2016   pk_12_total                                               19.0   368.0                                         19   368
111699 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes 4 04 12 2016   pk_12_total                                               19.0   143.0                                         19   143
111702 HI     school 1500030 1   Hawaii Department of Education 150003000277 548 INNOVATIONS-PCS charter Regular School Yes 1 KG 8 2016   pk_12_total                                               19.0   240.0                                         19   240
111717 HI     school 1500030 1   Hawaii Department of Education 150003000066 411 KUALAPUU charter Regular School Yes 1 PK 6 2016   pk_12_total                                               19.0   306.0                                         19   306
111713 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 KE KULA O KAMAKAU LAB-PCS charter Regular School Yes 4 PK 12 2016   pk_12_total                                               2.0   142.0                                         2   142
111454 HI     school 1500030 1   Hawaii Department of Education 150003000210 122 KALIHI-UKA   Regular School No 1 PK 5 2016   pk_12_total                                               20.0   264.0                                         20   264
111457 HI     school 1500030 1   Hawaii Department of Education 150003000207 124 KAPALAMA   Regular School No 1 PK 5 2016   pk_12_total                                               20.0   585.0                                         20   585
111481 HI     school 1500030 1   Hawaii Department of Education 150003000195 135 LUNALILO   Regular School No 1 PK 5 2016   pk_12_total                                               20.0   412.0                                         20   412
111637 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 PAAUILO EL & INT   Regular School No 4 PK 9 2016   pk_12_total                                               20.0   213.0                                         20   213
111572 HI     school 1500030 1   Hawaii Department of Education 150003000114 266 PEARL CITY HI   Regular School No 3 09 12 2016   pk_12_total                                               200.0   1639.0                                         200   1639
111610 HI     school 1500030 1   Hawaii Department of Education 150003000029 355 HILO HI   Regular School No 3 09 12 2016   pk_12_total                                               207.0   1160.0                                         207   1160
111541 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 HOOKELE EL   Regular School No 1 PK 5 2016   pk_12_total                                               21.0   460.0                                         21   460
111615 HI     school 1500030 1   Hawaii Department of Education 150003000039 369 KAUMANA   Regular School No 1 PK 6 2016   pk_12_total                                               21.0   277.0                                         21   277
111681 HI     school 1500030 1   Hawaii Department of Education 150003000082 452 HANALEI   Regular School No 1 PK 6 2016   pk_12_total                                               21.0   296.0                                         21   296
111623 HI     school 1500030 1   Hawaii Department of Education 150003000249 361 HONOKAA EL   Regular School No 1 PK 6 2016   pk_12_total                                               22.0   368.0                                         22   368
111714 HI     school 1500030 1   Hawaii Department of Education 150003000279 554 KIHEI PC SCHOOL-PCS charter Regular School Yes 4 KG 12 2016   pk_12_total                                               22.0   560.0                                         22   560
111725 HI     school 1500030 1   Hawaii Department of Education 150003000281 560 VOLCANO SCH OF A&S-PCS charter Regular School Yes 1 KG 8 2016   pk_12_total                                               22.0   159.0                                         22   159
111678 HI     school 1500030 1   Hawaii Department of Education 150003000290 434 MOLOKAI MID   Regular School No 2 07 8 2016   pk_12_total                                               23.0   179.0                                         23   179
111724 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes 2 06 8 2016   pk_12_total                                               23.0   151.0                                         23   151
111557 HI     school 1500030 1   Hawaii Department of Education 150003000117 263 NANAKULI HI & INT   Regular School No 3 07 12 2016   pk_12_total                                               232.0   1056.0                                         232   1056
111576 HI     school 1500030 1   Hawaii Department of Education 150003000161 277 WAIPAHU HI   Regular School No 3 09 12 2016   pk_12_total                                               235.0   2475.0                                         235   2475
111447 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 KAHALA   Regular School No 1 PK 5 2016   pk_12_total                                               24.0   376.0                                         24   376
111452 HI     school 1500030 1   Hawaii Department of Education 150003000162 120 KALIHI   Regular School No 1 PK 5 2016   pk_12_total                                               24.0   269.0                                         24   269
111487 HI     school 1500030 1   Hawaii Department of Education 150003000189 142 PALOLO   Regular School No 1 PK 5 2016   pk_12_total                                               24.0   289.0                                         24   289
111707 HI     school 1500030 1   Hawaii Department of Education 150003000263 397 KANU O KA'AINA-PCS charter Regular School Yes 4 KG 12 2016   pk_12_total                                               24.0   325.0                                         24   325
111729 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 WEST HI EXPLOR ACAD-PCS charter Regular School Yes 4 06 12 2016   pk_12_total                                               24.0   286.0                                         24   286
111546 HI     school 1500030 1   Hawaii Department of Education 150003000261 292 KAPOLEI HI   Regular School No 3 09 12 2016   pk_12_total                                               244.0   2038.0                                         244   2038
111442 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2016   pk_12_total                                               245.0   2376.0                                         245   2376
111444 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No 1 PK 5 2016   pk_12_total                                               25.0   565.0                                         25   565
111521 HI     school 1500030 1   Hawaii Department of Education 150003000108 214 LEILEHUA HI   Regular School No 3 09 12 2016   pk_12_total                                               254.0   1699.0                                         254   1699
111671 HI     school 1500030 1   Hawaii Department of Education 150003000062 407 KAUNAKAKAI   Regular School No 1 PK 6 2016   pk_12_total                                               26.0   303.0                                         26   303
111697 HI     school 1500030 1   Hawaii Department of Education 150003000273 543 EDUC LAB: A HAWAII NC-PCS charter Regular School Yes 4 KG 12 2016   pk_12_total                                               26.0   442.0                                         26   442
111536 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 CAMPBELL HI   Regular School No 3 09 12 2016   pk_12_total                                               266.0   3049.0                                         266   3049
111459 HI     school 1500030 1   Hawaii Department of Education 150003000201 130 LIHOLIHO   Regular School No 1 PK 5 2016   pk_12_total                                               27.0   433.0                                         27   433
111514 HI     school 1500030 1   Hawaii Department of Education 150003000139 235 WEBLING   Regular School No 1 PK 6 2016   pk_12_total                                               27.0   510.0                                         27   510
111608 HI     school 1500030 1   Hawaii Department of Education 150003000027 351 DE SILVA   Regular School No 1 PK 6 2016   pk_12_total                                               27.0   454.0                                         27   454
111613 HI     school 1500030 1   Hawaii Department of Education 150003000036 365 KALANIANAOLE EL & INT   Regular School No 1 PK 8 2016   pk_12_total                                               27.0   315.0                                         27   315
111621 HI     school 1500030 1   Hawaii Department of Education 150003000032 358 HOLUALOA   Regular School No 1 PK 5 2016   pk_12_total                                               27.0   490.0                                         27   490
111567 HI     school 1500030 1   Hawaii Department of Education 150003000122 260 MANANA   Regular School No 1 PK 6 2016   pk_12_total                                               28.0   432.0                                         28   432
111569 HI     school 1500030 1   Hawaii Department of Education 150003000116 264 PALISADES   Regular School No 1 PK 6 2016   pk_12_total                                               28.0   451.0                                         28   451
111606 HI     school 1500030 1   Hawaii Department of Education 150003000022 324 POPE   Regular School No 1 PK 6 2016   pk_12_total                                               28.0   230.0                                         28   230
111646 HI     school 1500030 1   Hawaii Department of Education 150003000048 380 NAALEHU   Regular School No 1 PK 6 2016   pk_12_total                                               28.0   350.0                                         28   350
111690 HI     school 1500030 1   Hawaii Department of Education 150003000089 459 KILAUEA   Regular School No 1 PK 6 2016   pk_12_total                                               28.0   294.0                                         28   294