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
132609 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten                                                   *                                              
134859 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2020   kindergarten                                                   59                                             59
137109 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2020   grade_1                                                   55                                             55
139359 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2020   grade_2                                                   55                                             55
141609 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2020   grade_3                                                   57                                             57
143859 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2020   grade_4                                                   *                                              
146109 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2020   grade_5                                                   *                                              
148359 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2020   grade_6                                                   *                                              
150609 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2020   grade_7                                                   *                                              
152859 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2020   grade_8                                                   *                                              
155109 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2020   grade_9                                                   *                                              
157359 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2020   grade_10                                                   *                                              
159609 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2020   grade_11                                                   *                                              
161859 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2020   grade_12                                                   *                                              
164109 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2020   pk_12_total 154 * 50   16 *         *   113 120     *   *         28   233 154   50   16               113 120             28   233
132611 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2020   pre_kindergarten                                                   *                                              
134861 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2020   kindergarten                                                   *                                              
137111 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2020   grade_1                                                   *                                              
139361 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2020   grade_2                                                   *                                              
141611 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2020   grade_3                                                   *                                              
143861 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2020   grade_4                                                   73                                             73
146111 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2020   grade_5                                                   65                                             65
148361 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2020   grade_6                                                   56                                             56
150611 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2020   grade_7                                                   73                                             73
152861 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2020   grade_8                                                   74                                             74
155111 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2020   grade_9                                                   *                                              
157361 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2020   grade_10                                                   *                                              
159611 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2020   grade_11                                                   *                                              
161861 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2020   grade_12                                                   *                                              
164111 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2020   pk_12_total 210 * 88   29 *         *   165 176     *   *         65   341 210   88   29               165 176             65   341
132610 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2020   pre_kindergarten                                                   *                                              
134860 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2020   kindergarten                                                   *                                              
137110 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2020   grade_1                                                   *                                              
139360 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2020   grade_2                                                   *                                              
141610 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2020   grade_3                                                   *                                              
143860 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2020   grade_4                                                   *                                              
146110 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2020   grade_5                                                   *                                              
148360 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2020   grade_6                                                   *                                              
150610 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2020   grade_7                                                   *                                              
152860 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2020   grade_8                                                   *                                              
155110 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2020   grade_9                                                   79                                             79
157360 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2020   grade_10                                                   65                                             65
159610 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2020   grade_11                                                   71                                             71
161860 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2020   grade_12                                                   71                                             71
164110 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2020   pk_12_total 173 * 78   22 *         *   153 133     *   *         41   286 173   78   22               153 133             41   286
132935 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   50                                             50
135185 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
137435 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
139685 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_2                                                   *                                              
141935 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_3                                                   *                                              
144185 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_4                                                   *                                              
146435 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_5                                                   *                                              
148685 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_6                                                   *                                              
150935 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_7                                                   *                                              
153185 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_8                                                   *                                              
155435 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
157685 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_10                                                   *                                              
159935 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_11                                                   *                                              
162185 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_12                                                   *                                              
164435 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   pk_12_total * * *   44 *         *   21 29     *   *         14   50         44               21 29             14   50
132937 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2020   pre_kindergarten                                                   *                                              
135187 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2020   kindergarten                                                   *                                              
137437 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2020   grade_1                                                   *                                              
139687 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2020   grade_2                                                   *                                              
141937 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2020   grade_3                                                   *                                              
144187 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2020   grade_4                                                   109                                             109
146437 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2020   grade_5                                                   117                                             117
148687 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2020   grade_6                                                   158                                             158
150937 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2020   grade_7                                                   *                                              
153187 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2020   grade_8                                                   *                                              
155437 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2020   grade_9                                                   *                                              
157687 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2020   grade_10                                                   *                                              
159937 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2020   grade_11                                                   *                                              
162187 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2020   grade_12                                                   *                                              
164437 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2020   pk_12_total * * *   377 *         *   220 164     28   *         47   384         377               220 164     28       47   384
132939 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2020   pre_kindergarten                                                   *                                              
135189 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2020   kindergarten                                                   89                                             89
137439 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2020   grade_1                                                   105                                             105
139689 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2020   grade_2                                                   93                                             93
141939 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2020   grade_3                                                   125                                             125
144189 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2020   grade_4                                                   *                                              
146439 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2020   grade_5                                                   *                                              
148689 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2020   grade_6                                                   *                                              
150939 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2020   grade_7                                                   *                                              
153189 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2020   grade_8                                                   *                                              
155439 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2020   grade_9                                                   *                                              
157689 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2020   grade_10                                                   *                                              
159939 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2020   grade_11                                                   *                                              
162189 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2020   grade_12                                                   *                                              
164439 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2020   pk_12_total * * *   404 *         *   207 205     36   *         43   412         404               207 205     36       43   412
132938 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2020   pre_kindergarten                                                   *                                              
135188 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2020   kindergarten                                                   *                                              
137438 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2020   grade_1                                                   *                                              
139688 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2020   grade_2                                                   *                                              
141938 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2020   grade_3                                                   *                                              
144188 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2020   grade_4                                                   *                                              
146438 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2020   grade_5                                                   *                                              
148688 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2020   grade_6                                                   *                                              
150938 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2020   grade_7                                                   155                                             155
153188 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2020   grade_8                                                   173                                             173
155438 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2020   grade_9                                                   *