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
2737201 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   grade_10                                                   199.0                                             199
2737493 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   grade_11                                                   184.0                                             184
2737785 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   grade_12                                                   182.0                                             182
2738077 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   pre_kindergarten                                                   0.0                                             0
2738369 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   pk_12_total                                               177.0   1381.0                                         177   1381
2734293 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   kindergarten                                                   35.0                                             35
2734585 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   grade_1                                                   41.0                                             41
2734877 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   grade_2                                                   39.0                                             39
2735169 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   grade_3                                                   48.0                                             48
2735461 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   grade_4                                                   43.0                                             43
2735753 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   grade_5                                                   42.0                                             42
2736045 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   grade_6                                                   42.0                                             42
2736337 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   grade_7                                                   0.0                                             0
2736629 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2736921 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   grade_9                                                   0.0                                             0
2737213 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   grade_10                                                   0.0                                             0
2737505 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   grade_11                                                   0.0                                             0
2737797 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   grade_12                                                   0.0                                             0
2738089 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   pre_kindergarten                                                   8.0                                             8
2738381 HI     school 1500030 1   Hawaii Department of Education 150003000008 308 Kailua Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               49.0   347.0                                         49   347
2734294 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   kindergarten                                                   0.0                                             0
2734586 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   grade_1                                                   0.0                                             0
2734878 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   grade_2                                                   0.0                                             0
2735170 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   grade_3                                                   0.0                                             0
2735462 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   grade_4                                                   0.0                                             0
2735754 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   grade_5                                                   0.0                                             0
2736046 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   grade_6                                                   0.0                                             0
2736338 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   grade_7                                                   0.0                                             0
2736630 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   grade_8                                                   0.0                                             0
2736922 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   grade_9                                                   205.0                                             205
2737214 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   grade_10                                                   173.0                                             173
2737506 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   grade_11                                                   171.0                                             171
2737798 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   grade_12                                                   127.0                                             127
2738090 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   pre_kindergarten                                                   0.0                                             0
2738382 HI     school 1500030 1   Hawaii Department of Education 150003000009 309 Kailua High   Regular School No High 09 12 2019   pk_12_total                                               128.0   804.0                                         128   804
2734295 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   kindergarten                                                   0.0                                             0
2734587 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   grade_1                                                   0.0                                             0
2734879 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   grade_2                                                   0.0                                             0
2735171 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   grade_3                                                   0.0                                             0
2735463 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   grade_4                                                   0.0                                             0
2735755 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   grade_5                                                   0.0                                             0
2736047 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   grade_6                                                   0.0                                             0
2736339 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   grade_7                                                   357.0                                             357
2736631 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   grade_8                                                   323.0                                             323
2736923 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   grade_9                                                   0.0                                             0
2737215 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   grade_10                                                   0.0                                             0
2737507 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   grade_11                                                   0.0                                             0
2737799 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   grade_12                                                   0.0                                             0
2738091 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   pre_kindergarten                                                   0.0                                             0
2738383 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2019   pk_12_total                                               95.0   775.0                                         95   775
2734296 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   kindergarten                                                   62.0                                             62
2734588 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   grade_1                                                   56.0                                             56
2734880 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   grade_2                                                   54.0                                             54
2735172 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   grade_3                                                   59.0                                             59
2735464 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   grade_4                                                   37.0                                             37
2735756 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   grade_5                                                   59.0                                             59
2736048 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   grade_6                                                   54.0                                             54
2736340 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   grade_7                                                   0.0                                             0
2736632 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2736924 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   grade_9                                                   0.0                                             0
2737216 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   grade_10                                                   0.0                                             0
2737508 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   grade_11                                                   0.0                                             0
2737800 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   grade_12                                                   0.0                                             0
2738092 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   pre_kindergarten                                                   5.0                                             5
2738384 HI     school 1500030 1   Hawaii Department of Education 150003000011 311 Kainalu Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               38.0   424.0                                         38   424
2734297 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   kindergarten                                                   0.0                                             0
2734589 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   grade_1                                                   0.0                                             0
2734881 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   grade_2                                                   0.0                                             0
2735173 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   grade_3                                                   0.0                                             0
2735465 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   grade_4                                                   0.0                                             0
2735757 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   grade_5                                                   0.0                                             0
2736049 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   grade_6                                                   0.0                                             0
2736341 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   grade_7                                                   0.0                                             0
2736633 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   grade_8                                                   0.0                                             0
2736925 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   grade_9                                                   183.0                                             183
2737217 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   grade_10                                                   172.0                                             172
2737509 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   grade_11                                                   175.0                                             175
2737801 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   grade_12                                                   143.0                                             143
2738093 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   pre_kindergarten                                                   0.0                                             0
2738385 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2019   pk_12_total                                               86.0   759.0                                         86   759
2734282 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   kindergarten                                                   92.0                                             92
2734574 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   grade_1                                                   73.0                                             73
2734866 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   grade_2                                                   94.0                                             94
2735158 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   grade_3                                                   88.0                                             88
2735450 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   grade_4                                                   64.0                                             64
2735742 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   grade_5                                                   82.0                                             82
2736034 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   grade_6                                                   85.0                                             85
2736326 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   grade_7                                                   0.0                                             0
2736618 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2736910 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   grade_9                                                   0.0                                             0
2737202 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   grade_10                                                   0.0                                             0
2737494 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   grade_11                                                   0.0                                             0
2737786 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   grade_12                                                   0.0                                             0
2738078 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   pre_kindergarten                                                   4.0                                             4
2738370 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 Kaneohe Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               53.0   635.0                                         53   635
2734283 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2019   kindergarten                                                   60.0                                             60
2734575 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2019   grade_1                                                   74.0                                             74
2734867 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2019   grade_2                                                   73.0                                             73
2735159 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2019   grade_3                                                   59.0                                             59
2735451 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2019   grade_4                                                   55.0                                             55
2735743 HI     school 1500030 1   Hawaii Department of Education 150003000014 315 Kapunahala Elem   Regular School No Elementary PK 6 2019   grade_5                                                   66.0                                             66