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
537083 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   *                                              
539058 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2018   kindergarten                                                   47                                             47
541033 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2018   grade_1                                                   52                                             52
543008 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2018   grade_2                                                   69                                             69
544983 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2018   grade_3                                                   62                                             62
546958 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2018   grade_4                                                   *                                              
548933 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2018   grade_5                                                   *                                              
550908 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2018   grade_6                                                   *                                              
552883 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2018   grade_7                                                   *                                              
554858 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2018   grade_8                                                   *                                              
556833 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2018   grade_9                                                   *                                              
558808 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2018   grade_10                                                   *                                              
560783 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2018   grade_11                                                   *                                              
562758 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2018   grade_12                                                   *                                              
564733 AZ     school 408080 4153   St Johns Unified District 40808000702 4517 Coronado Elementary School   Regular School No Elementary PK 03 2018   pk_12_total 144 * 57   23 *     *   *   115 120     *             31   235 144   57   23               115 120             31   235
537085 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2018   pre_kindergarten                                                   *                                              
539060 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2018   kindergarten                                                   *                                              
541035 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2018   grade_1                                                   *                                              
543010 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2018   grade_2                                                   *                                              
544985 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2018   grade_3                                                   *                                              
546960 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2018   grade_4                                                   48                                             48
548935 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2018   grade_5                                                   68                                             68
550910 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2018   grade_6                                                   63                                             63
552885 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2018   grade_7                                                   68                                             68
554860 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2018   grade_8                                                   60                                             60
556835 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2018   grade_9                                                   *                                              
558810 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2018   grade_10                                                   *                                              
560785 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2018   grade_11                                                   *                                              
562760 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2018   grade_12                                                   *                                              
564735 AZ     school 408080 4153   St Johns Unified District 40808001105 4710 St Johns Middle School   Regular School No Middle 04 08 2018   pk_12_total 181 * 69   47 *     *   *   147 160     *             50   307 181   69   47               147 160             50   307
537084 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
539059 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2018   kindergarten                                                   *                                              
541034 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2018   grade_1                                                   *                                              
543009 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2018   grade_2                                                   *                                              
544984 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2018   grade_3                                                   *                                              
546959 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2018   grade_4                                                   *                                              
548934 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2018   grade_5                                                   *                                              
550909 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2018   grade_6                                                   *                                              
552884 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2018   grade_7                                                   *                                              
554859 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2018   grade_8                                                   *                                              
556834 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2018   grade_9                                                   74                                             74
558809 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2018   grade_10                                                   87                                             87
560784 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2018   grade_11                                                   49                                             49
562759 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2018   grade_12                                                   39                                             39
564734 AZ     school 408080 4153   St Johns Unified District 40808001049 4711 St Johns High School   Regular School No High 09 12 2018   pk_12_total 165 * 58   17 *     *   *   131 118     *             36   249 165   58   17               131 118             36   249
537384 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2018   pre_kindergarten                                                   *                                              
539359 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2018   kindergarten                                                   *                                              
541334 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2018   grade_1                                                   *                                              
543309 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2018   grade_2                                                   *                                              
545284 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2018   grade_3                                                   *                                              
547259 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2018   grade_4                                                   114                                             114
549234 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2018   grade_5                                                   132                                             132
551209 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2018   grade_6                                                   153                                             153
553184 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2018   grade_7                                                   *                                              
555159 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2018   grade_8                                                   *                                              
557134 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2018   grade_9                                                   *                                              
559109 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2018   grade_10                                                   *                                              
561084 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2018   grade_11                                                   *                                              
563059 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2018   grade_12                                                   *                                              
565034 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2018   pk_12_total * * *   395 *     *   *   216 183     28             41   399         395               216 183     28       41   399
537386 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2018   pre_kindergarten                                                   *                                              
539361 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2018   kindergarten                                                   105                                             105
541336 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2018   grade_1                                                   116                                             116
543311 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2018   grade_2                                                   98                                             98
545286 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2018   grade_3                                                   109                                             109
547261 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2018   grade_4                                                   *                                              
549236 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2018   grade_5                                                   *                                              
551211 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2018   grade_6                                                   *                                              
553186 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2018   grade_7                                                   *                                              
555161 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2018   grade_8                                                   *                                              
557136 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2018   grade_9                                                   *                                              
559111 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2018   grade_10                                                   *                                              
561086 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2018   grade_11                                                   *                                              
563061 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2018   grade_12                                                   *                                              
565036 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2018   pk_12_total * * *   422 *     *   *   242 186     38             42   428         422               242 186     38       42   428
537385 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2018   pre_kindergarten                                                   *                                              
539360 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2018   kindergarten                                                   *                                              
541335 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2018   grade_1                                                   *                                              
543310 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2018   grade_2                                                   *                                              
545285 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2018   grade_3                                                   *                                              
547260 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2018   grade_4                                                   *                                              
549235 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2018   grade_5                                                   *                                              
551210 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2018   grade_6                                                   *                                              
553185 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2018   grade_7                                                   189                                             189
555160 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2018   grade_8                                                   163                                             163
557135 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2018   grade_9                                                   *                                              
559110 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2018   grade_10                                                   *                                              
561085 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2018   grade_11                                                   *                                              
563060 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2018   grade_12                                                   *                                              
565035 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2018   pk_12_total * * *   345 *     *   *   191 161     20             48   352         345               191 161     20       48   352
537387 AZ     school 409430 4154   Window Rock Unified District 40943000970 4717 Window Rock High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
539362 AZ     school 409430 4154   Window Rock Unified District 40943000970 4717 Window Rock High School   Regular School No High 09 12 2018   kindergarten                                                   *                                              
541337 AZ     school 409430 4154   Window Rock Unified District 40943000970 4717 Window Rock High School   Regular School No High 09 12 2018   grade_1                                                   *                                              
543312 AZ     school 409430 4154   Window Rock Unified District 40943000970 4717 Window Rock High School   Regular School No High 09 12 2018   grade_2                                                   *                                              
545287 AZ     school 409430 4154   Window Rock Unified District 40943000970 4717 Window Rock High School   Regular School No High 09 12 2018   grade_3                                                   *                                              
547262 AZ     school 409430 4154   Window Rock Unified District 40943000970 4717 Window Rock High School   Regular School No High 09 12 2018   grade_4                                                   *                                              
549237 AZ     school 409430 4154   Window Rock Unified District 40943000970 4717 Window Rock High School   Regular School No High 09 12 2018   grade_5                                                   *                                              
551212 AZ     school 409430 4154   Window Rock Unified District 40943000970 4717 Window Rock High School   Regular School No High 09 12 2018   grade_6                                                   *                                              
553187 AZ     school 409430 4154   Window Rock Unified District 40943000970 4717 Window Rock High School   Regular School No High 09 12 2018   grade_7                                                   *                                              
555162 AZ     school 409430 4154   Window Rock Unified District 40943000970 4717 Window Rock High School   Regular School No High 09 12 2018   grade_8                                                   *                                              
557137 AZ     school 409430 4154   Window Rock Unified District 40943000970 4717 Window Rock High School   Regular School No High 09 12 2018   grade_9                                                   144                                             144