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
130451 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 KAIMUKI MID   Regular School No Middle 06 8 2017   pk_12_total                                               85.0   1004.0                                         85   1004
130677 HI     school 1500030 1   Hawaii Department of Education 150003000069 414 LAHAINALUNA HI   Regular School No High 09 12 2017   pk_12_total                                               104.0   1007.0                                         104   1007
130453 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 KALAKAUA MID   Regular School No Middle 06 8 2017   pk_12_total                                               56.0   1017.0                                         56   1017
130578 HI     school 1500030 1   Hawaii Department of Education 150003000159 274 WAIPAHU EL   Regular School No Elementary PK 6 2017   pk_12_total                                               70.0   1030.0                                         70   1030
130497 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   pk_12_total                                               138.0   1031.0                                         138   1031
130688 HI     school 1500030 1   Hawaii Department of Education 150003000085 455 KAPAA HI   Regular School No High 09 12 2017   pk_12_total                                               119.0   1041.0                                         119   1041
130703 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 HAWAII TECHNOLOGY ACADEMY charter Regular School Yes Other KG 12 2017   pk_12_total                                               82.0   1062.0                                         82   1062
130560 HI     school 1500030 1   Hawaii Department of Education 150003000117 263 NANAKULI HI & INT   Regular School No High 07 12 2017   pk_12_total                                               242.0   1069.0                                         242   1069
130658 HI     school 1500030 1   Hawaii Department of Education 150003000251 435 KEKAULIKE HI   Regular School No High 09 12 2017   pk_12_total                                               152.0   1085.0                                         152   1085
130695 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No Other PK 12 2017   pk_12_total                                               0.0   11.0                                         0   11
130541 HI     school 1500030 1   Hawaii Department of Education 150003000133 253 EWA EL   Regular School No Elementary PK 6 2017   pk_12_total                                               51.0   1108.0                                         51   1108
130690 HI     school 1500030 1   Hawaii Department of Education 150003000086 456 KAUAI HI   Regular School No High 09 12 2017   pk_12_total                                               102.0   1130.0                                         102   1130
130452 HI     school 1500030 1   Hawaii Department of Education 150003000228 154 KAISER HI   Regular School No High 09 12 2017   pk_12_total                                               85.0   1134.0                                         85   1134
130613 HI     school 1500030 1   Hawaii Department of Education 150003000029 355 HILO HI   Regular School No High 09 12 2017   pk_12_total                                               195.0   1134.0                                         195   1134
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
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
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
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
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
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
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
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
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
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
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
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
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
130588 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No High 07 12 2017   pk_12_total                                               179.0   1386.0                                         179   1386
130702 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes Other 04 12 2017   pk_12_total                                               17.0   140.0                                         17   140
130550 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No Middle 06 8 2017   pk_12_total                                               167.0   1402.0                                         167   1402
130716 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 KE KULA O KAMAKAU LAB-PCS charter Regular School Yes Other PK 12 2017   pk_12_total                                               2.0   141.0                                         2   141
130713 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   pk_12_total                                               6.0   150.0                                         6   150
130575 HI     school 1500030 1   Hawaii Department of Education 150003000114 266 PEARL CITY HI   Regular School No High 09 12 2017   pk_12_total                                               180.0   1561.0                                         180   1561
130487 HI     school 1500030 1   Hawaii Department of Education 150003000193 138 MCKINLEY HI   Regular School No High 09 12 2017   pk_12_total                                               155.0   1570.0                                         155   1570
130463 HI     school 1500030 1   Hawaii Department of Education 150003000198 133 LINAPUNI   Regular School No Elementary PK 1 2017   pk_12_total                                               5.0   160.0                                         5   160
130727 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   pk_12_total                                               22.0   160.0                                         22   160
130524 HI     school 1500030 1   Hawaii Department of Education 150003000108 214 LEILEHUA HI   Regular School No High 09 12 2017   pk_12_total                                               229.0   1644.0                                         229   1644
130681 HI     school 1500030 1   Hawaii Department of Education 150003000290 434 MOLOKAI MID   Regular School No Middle 07 8 2017   pk_12_total                                               31.0   168.0                                         31   168
130625 HI     school 1500030 1   Hawaii Department of Education 150003000033 359 HONAUNAU   Regular School No Elementary PK 5 2017   pk_12_total                                               10.0   170.0                                         10   170
130728 HI     school 1500030 1   Hawaii Department of Education 150003000281 560 VOLCANO SCH OF A&S-PCS charter Regular School Yes Elementary KG 8 2017   pk_12_total                                               17.0   170.0                                         17   170
130636 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 KOHALA MID   Regular School No Middle 06 8 2017   pk_12_total                                               29.0   178.0                                         29   178
130725 HI     school 1500030 1   Hawaii Department of Education 150003000264 398 NA WAI OLA PCS charter Regular School Yes Elementary PK 6 2017   pk_12_total                                               9.0   178.0                                         9   178
130562 HI     school 1500030 1   Hawaii Department of Education 150003000110 272 WAIANAE HI   Regular School No High 09 12 2017   pk_12_total                                               292.0   1788.0                                         292   1788
130528 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No Middle 06 8 2017   pk_12_total                                               159.0   1837.0                                         159   1837
130711 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   pk_12_total                                               8.0   186.0                                         8   186
130599 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No Elementary PK 6 2017   pk_12_total                                               11.0   189.0                                         11   189
130612 HI     school 1500030 1   Hawaii Department of Education 150003000028 352 HAAHEO   Regular School No Elementary PK 6 2017   pk_12_total                                               11.0   190.0                                         11   190
130664 HI     school 1500030 1   Hawaii Department of Education 150003000073 418 MAUI HI   Regular School No High 09 12 2017   pk_12_total                                               187.0   1941.0                                         187   1941
130504 HI     school 1500030 1   Hawaii Department of Education 150003000103 218 MOANALUA HI   Regular School No High 09 12 2017   pk_12_total                                               187.0   1972.0                                         187   1972
130640 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 PAAUILO EL & INT   Regular School No Other PK 9 2017   pk_12_total                                               21.0   198.0                                         21   198
130719 HI     school 1500030 1   Hawaii Department of Education 150003000288 557 KUA O KA LA-PCS charter Regular School Yes Other KG 12 2017   pk_12_total                                               24.0   202.0                                         24   202
130549 HI     school 1500030 1   Hawaii Department of Education 150003000261 292 KAPOLEI HI   Regular School No High 09 12 2017   pk_12_total                                               235.0   2020.0                                         235   2020
130706 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   pk_12_total                                               8.0   215.0                                         8   215
130469 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   pk_12_total                                               23.0   216.0                                         23   216
130630 HI     school 1500030 1   Hawaii Department of Education 150003000287 378 KE KULA O EHUNUIKAIMALINO   Regular School No Other PK 12 2017   pk_12_total                                               12.0   218.0                                         12   218
130718 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes Elementary KG 8 2017   pk_12_total                                               18.0   223.0                                         18   223
130465 HI     school 1500030 1   Hawaii Department of Education 150003000187 145 PUUHALE   Regular School No Elementary PK 5 2017   pk_12_total                                               19.0   227.0                                         19   227
130519 HI     school 1500030 1   Hawaii Department of Education 150003000172 206 HALEIWA   Regular School No Elementary PK 6 2017   pk_12_total                                               35.0   229.0                                         35   229
130457 HI     school 1500030 1   Hawaii Department of Education 150003000210 122 KALIHI-UKA   Regular School No Elementary PK 5 2017   pk_12_total                                               16.0   230.0                                         16   230
130705 HI     school 1500030 1   Hawaii Department of Education 150003000277 548 INNOVATIONS-PCS charter Regular School Yes Elementary KG 8 2017   pk_12_total                                               15.0   237.0                                         15   237
130445 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   pk_12_total                                               255.0   2370.0                                         255   2370
130609 HI     school 1500030 1   Hawaii Department of Education 150003000022 324 POPE   Regular School No Elementary PK 6 2017   pk_12_total                                               32.0   238.0                                         32   238
130480 HI     school 1500030 1   Hawaii Department of Education 150003000203 128 KUHIO   Regular School No Elementary PK 5 2017   pk_12_total                                               26.0   241.0                                         26   241
130579 HI     school 1500030 1   Hawaii Department of Education 150003000161 277 WAIPAHU HI   Regular School No High 09 12 2017   pk_12_total                                               259.0   2463.0                                         259   2463
130635 HI     school 1500030 1   Hawaii Department of Education 150003000043 373 KOHALA HI   Regular School No High 09 12 2017   pk_12_total                                               48.0   249.0                                         48   249
130455 HI     school 1500030 1   Hawaii Department of Education 150003000162 120 KALIHI   Regular School No Elementary PK 5 2017   pk_12_total                                               25.0   251.0                                         25   251
130473 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No Middle 06 8 2017   pk_12_total                                               42.0   251.0                                         42   251
130731 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 WAIMEA MID-PCCS charter Regular School Yes Middle 06 8 2017   pk_12_total                                               28.0   254.0                                         28   254
130525 HI     school 1500030 1   Hawaii Department of Education 150003000102 216 MILILANI HI   Regular School No High 09 12 2017   pk_12_total                                               264.0   2556.0                                         264   2556
130732 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 WEST HI EXPLOR ACAD-PCS charter Regular School Yes Other 06 12 2017   pk_12_total                                               16.0   266.0                                         16   266
130722 HI     school 1500030 1   Hawaii Department of Education 150003000046 377 LAUPAHOEHOE COMMUNITY - PCS charter Regular School Yes Other PK 12 2017   pk_12_total                                               50.0   272.0                                         50   272
130569 HI     school 1500030 1   Hawaii Department of Education 150003000126 268 LEHUA   Regular School No Elementary PK 6 2017   pk_12_total                                               30.0   277.0                                         30   277
130618 HI     school 1500030 1   Hawaii Department of Education 150003000039 369 KAUMANA   Regular School No Elementary PK 6 2017   pk_12_total                                               29.0   278.0                                         29   278
130674 HI     school 1500030 1   Hawaii Department of Education 150003000062 407 KAUNAKAKAI   Regular School No Elementary PK 6 2017   pk_12_total                                               36.0   284.0                                         36   284
130586 HI     school 1500030 1   Hawaii Department of Education 150003000006 306 KAHALUU   Regular School No Elementary PK 6 2017   pk_12_total                                               44.0   286.0                                         44   286
130693 HI     school 1500030 1   Hawaii Department of Education 150003000089 459 KILAUEA   Regular School No Elementary PK 6 2017   pk_12_total                                               30.0   291.0                                         30   291
130490 HI     school 1500030 1   Hawaii Department of Education 150003000189 142 PALOLO   Regular School No Elementary PK 5 2017   pk_12_total                                               19.0   293.0                                         19   293
130594 HI     school 1500030 1   Hawaii Department of Education 150003000023 314 PUOHALA   Regular School No Elementary PK 6 2017   pk_12_total                                               30.0   295.0                                         30   295
130491 HI     school 1500030 1   Hawaii Department of Education 150003000188 143 PAUOA   Regular School No Elementary PK 5 2017   pk_12_total                                               17.0   296.0                                         17   296
130684 HI     school 1500030 1   Hawaii Department of Education 150003000082 452 HANALEI   Regular School No Elementary PK 6 2017   pk_12_total                                               18.0   296.0                                         18   296
130729 HI     school 1500030 1   Hawaii Department of Education 150003000271 541 VOYAGER-PCS charter Regular School Yes Elementary KG 8 2017   pk_12_total                                               34.0   299.0                                         34   299
130581 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   pk_12_total                                               39.0   300.0                                         39   300
130461 HI     school 1500030 1   Hawaii Department of Education 150003000204 127 KOKO HEAD   Regular School No Elementary PK 5 2017   pk_12_total                                               29.0   310.0                                         29   310
130720 HI     school 1500030 1   Hawaii Department of Education 150003000066 411 KUALAPUU charter Regular School Yes Elementary PK 6 2017   pk_12_total                                               30.0   310.0                                         30   310
130616 HI     school 1500030 1   Hawaii Department of Education 150003000036 365 KALANIANAOLE EL & INT   Regular School No Elementary PK 8 2017   pk_12_total                                               30.0   312.0                                         30   312
130539 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 CAMPBELL HI   Regular School No High 09 12 2017   pk_12_total                                               290.0   3125.0                                         290   3125
130721 HI     school 1500030 1   Hawaii Department of Education 150003000018 320 LANIKAI-PCS charter Regular School Yes Elementary KG 6 2017   pk_12_total                                               19.0   327.0                                         19   327
130449 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 KAEWAI   Regular School No Elementary PK 5 2017   pk_12_total                                               42.0   331.0                                         42   331
130680 HI     school 1500030 1   Hawaii Department of Education 150003000075 421 MOLOKAI HI   Regular School No High 09 12 2017   pk_12_total                                               48.0   335.0                                         48   335
130482 HI     school 1500030 1   Hawaii Department of Education 150003000200 131 LIKELIKE   Regular School No Elementary PK 5 2017   pk_12_total                                               14.0   336.0                                         14   336
130483 HI     school 1500030 1   Hawaii Department of Education 150003000197 134 LINCOLN   Regular School No Elementary PK 5 2017   pk_12_total                                               41.0   342.0                                         41   342
130649 HI     school 1500030 1   Hawaii Department of Education 150003000048 380 NAALEHU   Regular School No Elementary PK 6 2017   pk_12_total                                               25.0   344.0                                         25   344
130634 HI     school 1500030 1   Hawaii Department of Education 150003000250 395 KOHALA EL   Regular School No Elementary PK 5 2017   pk_12_total                                               30.0   345.0                                         30   345
130583 HI     school 1500030 1   Hawaii Department of Education 150003000002 303 HAUULA   Regular School No Elementary PK 6 2017   pk_12_total                                               42.0   346.0                                         42   346
130606 HI     school 1500030 1   Hawaii Department of Education 150003000019 321 MAUNAWILI   Regular School No Elementary PK 6 2017   pk_12_total                                               38.0   348.0                                         38   348
130672 HI     school 1500030 1   Hawaii Department of Education 150003000058 402 HANA HI & EL   Regular School No Other PK 12 2017   pk_12_total                                               46.0   349.0                                         46   349
130692 HI     school 1500030 1   Hawaii Department of Education 150003000088 458 KEKAHA   Regular School No Elementary PK 5 2017   pk_12_total                                               35.0   350.0                                         35   350
130593 HI     school 1500030 1   Hawaii Department of Education 150003000021 323 PARKER   Regular School No Elementary PK 6 2017   pk_12_total                                               59.0   351.0                                         59   351
130617 HI     school 1500030 1   Hawaii Department of Education 150003000037 367 KAPIOLANI   Regular School No Elementary PK 6 2017   pk_12_total                                               27.0   351.0                                         27   351
130472 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 HOKULANI   Regular School No Elementary PK 5 2017   pk_12_total                                               18.0   359.0                                         18   359