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
111440 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   pk_12_total                                               36.0   508.0                                         36   508
130443 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No Elementary PK 5 2017   pk_12_total                                               41.0   492.0                                         41   492
281414 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2015   pk_12_total                                               33.0   512.0                                         33   512
2432568 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   pk_12_total                                               31.0   462.0                                         31   462
2457263 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2021   pk_12_total                                               35.0   490.0                                         35   490
2738224 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2019   pk_12_total                                               38.0   469.0                                         38   469
2783274 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   pk_12_total                                               33.0   469.0                                         33   469
111465 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   pk_12_total                                               35.0   430.0                                         35   430
130468 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   pk_12_total                                               33.0   413.0                                         33   413
281439 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2015   pk_12_total                                               30.0   440.0                                         30   440
2432593 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   pk_12_total                                               25.0   352.0                                         25   352
2457288 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   pk_12_total                                               33.0   363.0                                         33   363
2738249 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2019   pk_12_total                                               29.0   353.0                                         29   353
2783299 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   pk_12_total                                               35.0   384.0                                         35   384
111466 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   pk_12_total                                               29.0   232.0                                         29   232
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
281440 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2015   pk_12_total                                               30.0   250.0                                         30   250
2432594 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2020   pk_12_total                                               21.0   239.0                                         21   239
2457289 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   pk_12_total                                               19.0   263.0                                         19   263
2738250 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2019   pk_12_total                                               20.0   231.0                                         20   231
2783300 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   pk_12_total                                               19.0   219.0                                         19   219
111467 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   pk_12_total                                               29.0   421.0                                         29   421
130470 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   pk_12_total                                               23.0   435.0                                         23   435
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
2432595 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2020   pk_12_total                                               30.0   545.0                                         30   545
2457290 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   pk_12_total                                               30.0   507.0                                         30   507
2738251 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2019   pk_12_total                                               26.0   516.0                                         26   516
2783301 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   pk_12_total                                               24.0   455.0                                         24   455
111468 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   pk_12_total                                               51.0   398.0                                         51   398
130471 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   pk_12_total                                               60.0   429.0                                         60   429
281442 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2015   pk_12_total                                               34.0   365.0                                         34   365
2432596 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2020   pk_12_total                                               48.0   399.0                                         48   399
2457291 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   pk_12_total                                               45.0   321.0                                         45   321
2738252 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   pk_12_total                                               44.0   414.0                                         44   414
2783302 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   pk_12_total                                               41.0   391.0                                         41   391
111441 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   pk_12_total                                               76.0   800.0                                         76   800
130444 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   pk_12_total                                               81.0   795.0                                         81   795
281415 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2015   pk_12_total                                               82.0   809.0                                         82   809
2432569 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2020   pk_12_total                                               78.0   710.0                                         78   710
2457264 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   pk_12_total                                               78.0   580.0                                         78   580
2738225 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   pk_12_total                                               77.0   765.0                                         77   765
2783275 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   pk_12_total                                               77.0   784.0                                         77   784
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
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
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
2432570 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2020   pk_12_total                                               208.0   2396.0                                         208   2396
2457265 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   pk_12_total                                               205.0   2365.0                                         205   2365
2738226 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2019   pk_12_total                                               217.0   2315.0                                         217   2315
2783276 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   pk_12_total                                               247.0   2309.0                                         247   2309
111443 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No 1 PK 5 2016   pk_12_total                                               30.0   508.0                                         30   508
130446 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No Elementary PK 5 2017   pk_12_total                                               33.0   454.0                                         33   454
281417 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No 1 PK 5 2015   pk_12_total                                               36.0   539.0                                         36   539
2432571 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2020   pk_12_total                                               29.0   409.0                                         29   409
2457266 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2021   pk_12_total                                               28.0   415.0                                         28   415
2738227 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2019   pk_12_total                                               33.0   445.0                                         33   445
2783277 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   pk_12_total                                               33.0   438.0                                         33   438
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
130447 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No Elementary PK 5 2017   pk_12_total                                               24.0   548.0                                         24   548
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
2432572 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2020   pk_12_total                                               37.0   561.0                                         37   561
2457267 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2021   pk_12_total                                               38.0   547.0                                         38   547
2738228 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2019   pk_12_total                                               30.0   533.0                                         30   533
2783278 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   pk_12_total                                               25.0   549.0                                         25   549
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
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
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
2432597 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2020   pk_12_total                                               15.0   329.0                                         15   329
2457292 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2021   pk_12_total                                               14.0   319.0                                         14   319
2738253 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2019   pk_12_total                                               14.0   323.0                                         14   323
2783303 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   pk_12_total                                               14.0   339.0                                         14   339
111470 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2016   pk_12_total                                               39.0   246.0                                         39   246
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
281444 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2015   pk_12_total                                               36.0   241.0                                         36   241
2432598 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2020   pk_12_total                                               42.0   274.0                                         42   274
2457293 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2021   pk_12_total                                               39.0   272.0                                         39   272
2738254 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2019   pk_12_total                                               45.0   275.0                                         45   275
2783304 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   pk_12_total                                               41.0   256.0                                         41   256
111471 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 JEFFERSON   Regular School No 1 PK 5 2016   pk_12_total                                               35.0   412.0                                         35   412
130474 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 JEFFERSON   Regular School No Elementary PK 5 2017   pk_12_total                                               39.0   407.0                                         39   407
281445 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 JEFFERSON   Regular School No 1 PK 5 2015   pk_12_total                                               38.0   432.0                                         38   432
2432599 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2020   pk_12_total                                               23.0   339.0                                         23   339
2457294 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2021   pk_12_total                                               23.0   337.0                                         23   337
2738255 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2019   pk_12_total                                               36.0   386.0                                         36   386
2783305 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   pk_12_total                                               44.0   380.0                                         44   380
111472 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 KAAHUMANU   Regular School No 1 PK 5 2016   pk_12_total                                               54.0   547.0                                         54   547
130475 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 KAAHUMANU   Regular School No Elementary PK 5 2017   pk_12_total                                               54.0   524.0                                         54   524
281446 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 KAAHUMANU   Regular School No 1 PK 5 2015   pk_12_total                                               51.0   548.0                                         51   548
2432600 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2020   pk_12_total                                               65.0   520.0                                         65   520
2457295 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2021   pk_12_total                                               67.0   470.0                                         67   470
2738256 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2019   pk_12_total                                               64.0   521.0                                         64   521
2783306 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   pk_12_total                                               60.0   526.0                                         60   526
111446 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 KAEWAI   Regular School No 1 PK 5 2016   pk_12_total                                               38.0   335.0                                         38   335
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
281420 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 KAEWAI   Regular School No 1 PK 5 2015   pk_12_total                                               36.0   354.0                                         36   354
2432574 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2020   pk_12_total                                               44.0   301.0                                         44   301
2457269 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2021   pk_12_total                                               46.0   316.0                                         46   316
2738230 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2019   pk_12_total                                               40.0   307.0                                         40   307
2783280 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2018   pk_12_total                                               44.0   315.0                                         44   315
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
130450 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 KAHALA   Regular School No Elementary PK 5 2017   pk_12_total                                               25.0   371.0                                         25   371
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