enrollments

Data source: Big Local News · About: Big Local

127,680 rows where state = "AZ" sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id ▼ school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
78021 78021 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2021   grade_4                                                   *                                              
80337 80337 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2021   grade_5                                                   *                                              
82653 82653 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2021   grade_6                                                   *                                              
84969 84969 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2021   grade_7                                                   *                                              
87285 87285 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2021   grade_8                                                   *                                              
89601 89601 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
91917 91917 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2021   grade_10                                                   *                                              
94233 94233 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2021   grade_11                                                   *                                              
96549 96549 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2021   grade_12                                                   *                                              
98865 98865 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2021   pk_12_total * * *   23 *     *   *   16 11     *   *         *   27         23               16 11                 27
132935 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 135185 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
137435 137435 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
139685 139685 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_2                                                   *                                              
141935 141935 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_3                                                   *                                              
144185 144185 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_4                                                   *                                              
146435 146435 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_5                                                   *                                              
148685 148685 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_6                                                   *                                              
150935 150935 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_7                                                   *                                              
153185 153185 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_8                                                   *                                              
155435 155435 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
157685 157685 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_10                                                   *                                              
159935 159935 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_11                                                   *                                              
162185 162185 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_12                                                   *                                              
164435 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
66443 66443 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2021   pre_kindergarten                                                   *                                              
68759 68759 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2021   kindergarten                                                   *                                              
71075 71075 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2021   grade_1                                                   *                                              
73391 73391 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2021   grade_2                                                   *                                              
75707 75707 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2021   grade_3                                                   *                                              
78023 78023 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2021   grade_4                                                   128                                             128
80339 80339 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2021   grade_5                                                   100                                             100
82655 82655 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2021   grade_6                                                   122                                             122
84971 84971 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2021   grade_7                                                   *                                              
87287 87287 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2021   grade_8                                                   *                                              
89603 89603 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2021   grade_9                                                   *                                              
91919 91919 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2021   grade_10                                                   *                                              
94235 94235 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2021   grade_11                                                   *                                              
96551 96551 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2021   grade_12                                                   *                                              
98867 98867 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2021   pk_12_total * * *   345 *     *   *   204 146     22   *         46   350         345               204 146     22       46   350
132937 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 135187 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2020   kindergarten                                                   *                                              
137437 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 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 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 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 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 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 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 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 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 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 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 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 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
537384 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 539359 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2018   kindergarten                                                   *                                              
541334 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 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 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 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 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 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 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 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 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 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 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 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 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
567005 567005 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2019   pre_kindergarten                                                   *                                              
568976 568976 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2019   kindergarten                                                   *                                              
570947 570947 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2019   grade_1                                                   *                                              
572918 572918 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2019   grade_2                                                   *                                              
574889 574889 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2019   grade_3                                                   *                                              
576860 576860 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2019   grade_4                                                   107                                             107
578831 578831 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2019   grade_5                                                   113                                             113
580802 580802 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2019   grade_6                                                   139                                             139
582773 582773 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2019   grade_7                                                   *                                              
584744 584744 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2019   grade_8                                                   *                                              
586715 586715 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2019   grade_9                                                   *                                              
588686 588686 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2019   grade_10                                                   *                                              
590657 590657 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2019   grade_11                                                   *                                              
592628 592628 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2019   grade_12                                                   *                                              
594599 594599 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2019   pk_12_total * * *   358 *     *   *   199 160     22             43   359         358               199 160     22       43   359
66445 66445 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2021   pre_kindergarten                                                   *                                              
68761 68761 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2021   kindergarten                                                   109                                             109
71077 71077 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2021   grade_1                                                   96                                             96
73393 73393 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2021   grade_2                                                   107                                             107
75709 75709 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2021   grade_3                                                   91                                             91
78025 78025 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2021   grade_4                                                   *                                              
80341 80341 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2021   grade_5                                                   *                                              
82657 82657 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2021   grade_6                                                   *                                              
84973 84973 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2021   grade_7                                                   *                                              
87289 87289 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2021   grade_8                                                   *                                              
89605 89605 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2021   grade_9                                                   *                                              
91921 91921 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2021   grade_10                                                   *                                              
94237 94237 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2021   grade_11                                                   *                                              
96553 96553 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2021   grade_12                                                   *                                              
98869 98869 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2021   pk_12_total * * *   398 *     *   *   205 198     31   *         43   403         398               205 198     31       43   403

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);