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
2428604 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   kindergarten                                                   31.0                                             31
2428897 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   grade_1                                                   39.0                                             39
2429190 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   grade_2                                                   33.0                                             33
2429483 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   grade_3                                                   39.0                                             39
2429776 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   grade_4                                                   33.0                                             33
2430069 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   grade_5                                                   34.0                                             34
2430362 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   grade_6                                                   39.0                                             39
2430655 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   grade_7                                                   0.0                                             0
2430948 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2431241 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   grade_9                                                   0.0                                             0
2431534 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   grade_10                                                   0.0                                             0
2431827 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   grade_11                                                   0.0                                             0
2432120 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   grade_12                                                   0.0                                             0
2432413 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   pre_kindergarten                                                   1.0                                             1
2432706 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   pk_12_total                                               39.0   288.0                                         39   288
2428519 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   kindergarten                                                   36.0                                             36
2428812 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   grade_1                                                   35.0                                             35
2429105 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   grade_2                                                   42.0                                             42
2429398 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   grade_3                                                   43.0                                             43
2429691 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   grade_4                                                   49.0                                             49
2429984 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   grade_5                                                   33.0                                             33
2430277 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   grade_6                                                   45.0                                             45
2430570 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   grade_7                                                   0.0                                             0
2430863 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2431156 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   grade_9                                                   0.0                                             0
2431449 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   grade_10                                                   0.0                                             0
2431742 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   grade_11                                                   0.0                                             0
2432035 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   grade_12                                                   0.0                                             0
2432328 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   pre_kindergarten                                                   7.0                                             7
2432621 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   pk_12_total                                               33.0   323.0                                         33   323
2428520 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   kindergarten                                                   0.0                                             0
2428813 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
2429106 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   grade_2                                                   0.0                                             0
2429399 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   grade_3                                                   0.0                                             0
2429692 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2429985 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2430278 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2430571 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2430864 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2431157 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   grade_9                                                   257.0                                             257
2431450 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   grade_10                                                   208.0                                             208
2431743 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   grade_11                                                   188.0                                             188
2432036 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   grade_12                                                   218.0                                             218
2432329 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
2432622 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   pk_12_total                                               129.0   1000.0                                         129   1000
2428521 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   kindergarten                                                   0.0                                             0
2428814 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   grade_1                                                   0.0                                             0
2429107 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   grade_2                                                   0.0                                             0
2429400 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   grade_3                                                   0.0                                             0
2429693 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   grade_4                                                   0.0                                             0
2429986 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   grade_5                                                   0.0                                             0
2430279 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   grade_6                                                   0.0                                             0
2430572 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   grade_7                                                   273.0                                             273
2430865 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   grade_8                                                   279.0                                             279
2431158 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   grade_9                                                   0.0                                             0
2431451 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   grade_10                                                   0.0                                             0
2431744 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   grade_11                                                   0.0                                             0
2432037 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   grade_12                                                   0.0                                             0
2432330 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   pre_kindergarten                                                   0.0                                             0
2432623 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   pk_12_total                                               53.0   605.0                                         53   605
2428620 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   kindergarten                                                   84.0                                             84
2428913 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   grade_1                                                   69.0                                             69
2429206 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   grade_2                                                   57.0                                             57
2429499 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   grade_3                                                   68.0                                             68
2429792 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   grade_4                                                   58.0                                             58
2430085 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   grade_5                                                   59.0                                             59
2430378 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   grade_6                                                   69.0                                             69
2430671 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   grade_7                                                   0.0                                             0
2430964 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2431257 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   grade_9                                                   0.0                                             0
2431550 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   grade_10                                                   0.0                                             0
2431843 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   grade_11                                                   0.0                                             0
2432136 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   grade_12                                                   0.0                                             0
2432429 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   pre_kindergarten                                                   6.0                                             6
2432722 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   pk_12_total                                               33.0   503.0                                         33   503
2428466 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   kindergarten                                                   59.0                                             59
2428759 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   grade_1                                                   77.0                                             77
2429052 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   grade_2                                                   68.0                                             68
2429345 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   grade_3                                                   91.0                                             91
2429638 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   grade_4                                                   72.0                                             72
2429931 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   grade_5                                                   60.0                                             60
2430224 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   grade_6                                                   0.0                                             0
2430517 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   grade_7                                                   0.0                                             0
2430810 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   grade_8                                                   0.0                                             0
2431103 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   grade_9                                                   0.0                                             0
2431396 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   grade_10                                                   0.0                                             0
2431689 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   grade_11                                                   0.0                                             0
2431982 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   grade_12                                                   0.0                                             0
2432275 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   pre_kindergarten                                                   4.0                                             4
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
2428491 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   kindergarten                                                   50.0                                             50
2428784 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   grade_1                                                   59.0                                             59
2429077 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   grade_2                                                   60.0                                             60
2429370 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   grade_3                                                   52.0                                             52
2429663 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   grade_4                                                   50.0                                             50
2429956 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   grade_5                                                   43.0                                             43
2430249 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   grade_6                                                   0.0                                             0
2430542 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   grade_7                                                   0.0                                             0
2430835 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   grade_8                                                   0.0                                             0
2431128 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   grade_9                                                   0.0                                             0
2431421 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   grade_10                                                   0.0                                             0