Data source: Big Local News · About: Big Local

127,680 rows where state = "AZ" sorted by ccd_school_high_grade descending

View and edit SQL

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
536693 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   24                                             24
538668 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   kindergarten                                                   *                                              
540643 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_1                                                   *                                              
542618 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_2                                                   *                                              
544593 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_3                                                   *                                              
546568 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_4                                                   *                                              
548543 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_5                                                   *                                              
550518 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_6                                                   *                                              
552493 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_7                                                   *                                              
554468 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_8                                                   *                                              
556443 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_9                                                   *                                              
558418 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_10                                                   *                                              
560393 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_11                                                   *                                              
562368 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_12                                                   *                                              
564343 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   pk_12_total 16 * *   * *     *   *   * 14     *             *   24 16                         14                 24
130766 AZ     school 400600 4280   Alhambra Elementary District 40060003660 1000261 Alhambra Preschool Academy   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   131                                             131
130887 AZ     school 400463 6393   Arizona State School for the Deaf and Blind 40046303359 90801 FBC-Preschool   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   53                                             53
130889 AZ     school 400463 6393   Arizona State School for the Deaf and Blind 40046303237 90802 Phoenix CHIC - Morton Ave   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   49                                             49
130892 AZ     school 400463 6393   Arizona State School for the Deaf and Blind 40046303236 90798 Tucson CHIC Preschool   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   27                                             27
130944 AZ     school 401050 4268   Balsz Elementary District 40105003374 92301 Orangedale Early Learning Center   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   25                                             25
131049 AZ     school 401680 4282   Cartwright Elementary District 40168001054 5414 Byron A. Barry School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   323                                             323
131075 AZ     school 401710 4446   Casa Grande Elementary District 40171003201 90899 Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   147                                             147
131087 AZ     school 401760 4410   Catalina Foothills Unified District 40176001531 5836 Catalina Foothills Valley View Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   268                                             268
131251 AZ     school 402400 4501   Crane Elementary District 40240002882 87486 Great Beginnings Pre-School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   108                                             108
131343 AZ     school 402530 4174   Douglas Unified District 40253000184 4764 Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   138                                             138
131473 AZ     school 403010 4405   Flowing Wells Unified District 40301002065 79249 Emily Meschter Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   127                                             127
131519 AZ     school 403240 4505   Gadsden Elementary District 40324001108 6186 San Luis Pre-School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   71                                             71
131667 AZ     school 403780 4248   Higley Unified School District 40378003417 92252 Elona P. Cooley Early Child Development Center   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   93                                             93
131674 AZ     school 403780 4248   Higley Unified School District 40378003361 92264 Sue Sossaman Early Childhood Development Center   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   104                                             104
131691 AZ     school 403870 4469   Humboldt Unified District 40387002926 89839 Bright Futures Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   113                                             113
131722 AZ     school 403960 4259   Isaac Elementary District 40396001543 5241 Bret Tarver Education Complex   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   208                                             208
131920 AZ     school 404630 4404   Marana Unified District 40463003663 1000279 MUSD Early Learning and Resource Center   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   104                                             104
131972 AZ     school 404970 4235   Mesa Unified District 40497002337 80046 Early Education Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   126                                             126
132017 AZ     school 404970 4235   Mesa Unified District 40497002109 79687 Red Mountain Center for Early Education   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   171                                             171
132047 AZ     school 405030 4211   Miami Unified District 40503002789 89583 M.U.S.D. #40 - Little Vandal Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   51                                             51
132261 AZ     school 406250 4237   Peoria Unified School District 40625003643 1000302 GCC Early Childhood Learning Lab   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   *                                              
132294 AZ     school 406300 4256   Phoenix Elementary District 40630003554 286779 Faith North Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   126                                             126
132383 AZ     school 406730 4466   Prescott Unified District 40673000352 8126 Discovery Gardens Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   164                                             164
132542 AZ     school 407700 4393   Show Low Unified District 40770003615 7673 Show Low Preschool   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   17                                             17
132563 AZ     school 407820 4391   Snowflake Unified District 40782002543 87577 Snowflake Preschool   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   18                                             18
132851 AZ     school 408850 4413   Vail Unified District 40885003665 1000286 Vail Inclusive Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   302                                             302
132935 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   50                                             50
133016 AZ     school 400600 4280   Alhambra Elementary District 40060003660 1000261 Alhambra Preschool Academy   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
133137 AZ     school 400463 6393   Arizona State School for the Deaf and Blind 40046303359 90801 FBC-Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
133139 AZ     school 400463 6393   Arizona State School for the Deaf and Blind 40046303237 90802 Phoenix CHIC - Morton Ave   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
133142 AZ     school 400463 6393   Arizona State School for the Deaf and Blind 40046303236 90798 Tucson CHIC Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
133194 AZ     school 401050 4268   Balsz Elementary District 40105003374 92301 Orangedale Early Learning Center   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
133299 AZ     school 401680 4282   Cartwright Elementary District 40168001054 5414 Byron A. Barry School   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
133325 AZ     school 401710 4446   Casa Grande Elementary District 40171003201 90899 Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
133337 AZ     school 401760 4410   Catalina Foothills Unified District 40176001531 5836 Catalina Foothills Valley View Early Learning Center   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
133501 AZ     school 402400 4501   Crane Elementary District 40240002882 87486 Great Beginnings Pre-School   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
133593 AZ     school 402530 4174   Douglas Unified District 40253000184 4764 Early Learning Center   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
133723 AZ     school 403010 4405   Flowing Wells Unified District 40301002065 79249 Emily Meschter Early Learning Center   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
133769 AZ     school 403240 4505   Gadsden Elementary District 40324001108 6186 San Luis Pre-School   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
133917 AZ     school 403780 4248   Higley Unified School District 40378003417 92252 Elona P. Cooley Early Child Development Center   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
133924 AZ     school 403780 4248   Higley Unified School District 40378003361 92264 Sue Sossaman Early Childhood Development Center   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
133941 AZ     school 403870 4469   Humboldt Unified District 40387002926 89839 Bright Futures Preschool   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
133972 AZ     school 403960 4259   Isaac Elementary District 40396001543 5241 Bret Tarver Education Complex   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
134170 AZ     school 404630 4404   Marana Unified District 40463003663 1000279 MUSD Early Learning and Resource Center   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
134222 AZ     school 404970 4235   Mesa Unified District 40497002337 80046 Early Education Center   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
134267 AZ     school 404970 4235   Mesa Unified District 40497002109 79687 Red Mountain Center for Early Education   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
134297 AZ     school 405030 4211   Miami Unified District 40503002789 89583 M.U.S.D. #40 - Little Vandal Preschool   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
134511 AZ     school 406250 4237   Peoria Unified School District 40625003643 1000302 GCC Early Childhood Learning Lab   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
134544 AZ     school 406300 4256   Phoenix Elementary District 40630003554 286779 Faith North Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
134633 AZ     school 406730 4466   Prescott Unified District 40673000352 8126 Discovery Gardens Preschool   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
134792 AZ     school 407700 4393   Show Low Unified District 40770003615 7673 Show Low Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
134813 AZ     school 407820 4391   Snowflake Unified District 40782002543 87577 Snowflake Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
135101 AZ     school 408850 4413   Vail Unified District 40885003665 1000286 Vail Inclusive Preschool   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
135185 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   *                                              
135266 AZ     school 400600 4280   Alhambra Elementary District 40060003660 1000261 Alhambra Preschool Academy   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
135387 AZ     school 400463 6393   Arizona State School for the Deaf and Blind 40046303359 90801 FBC-Preschool   Special Education School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
135389 AZ     school 400463 6393   Arizona State School for the Deaf and Blind 40046303237 90802 Phoenix CHIC - Morton Ave   Special Education School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
135392 AZ     school 400463 6393   Arizona State School for the Deaf and Blind 40046303236 90798 Tucson CHIC Preschool   Special Education School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
135444 AZ     school 401050 4268   Balsz Elementary District 40105003374 92301 Orangedale Early Learning Center   Special Education School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
135549 AZ     school 401680 4282   Cartwright Elementary District 40168001054 5414 Byron A. Barry School   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
135575 AZ     school 401710 4446   Casa Grande Elementary District 40171003201 90899 Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
135587 AZ     school 401760 4410   Catalina Foothills Unified District 40176001531 5836 Catalina Foothills Valley View Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
135751 AZ     school 402400 4501   Crane Elementary District 40240002882 87486 Great Beginnings Pre-School   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
135843 AZ     school 402530 4174   Douglas Unified District 40253000184 4764 Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
135973 AZ     school 403010 4405   Flowing Wells Unified District 40301002065 79249 Emily Meschter Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
136019 AZ     school 403240 4505   Gadsden Elementary District 40324001108 6186 San Luis Pre-School   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
136167 AZ     school 403780 4248   Higley Unified School District 40378003417 92252 Elona P. Cooley Early Child Development Center   Special Education School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
136174 AZ     school 403780 4248   Higley Unified School District 40378003361 92264 Sue Sossaman Early Childhood Development Center   Special Education School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
136191 AZ     school 403870 4469   Humboldt Unified District 40387002926 89839 Bright Futures Preschool   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
136222 AZ     school 403960 4259   Isaac Elementary District 40396001543 5241 Bret Tarver Education Complex   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
136420 AZ     school 404630 4404   Marana Unified District 40463003663 1000279 MUSD Early Learning and Resource Center   Special Education School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
136472 AZ     school 404970 4235   Mesa Unified District 40497002337 80046 Early Education Center   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
136517 AZ     school 404970 4235   Mesa Unified District 40497002109 79687 Red Mountain Center for Early Education   Special Education School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
136547 AZ     school 405030 4211   Miami Unified District 40503002789 89583 M.U.S.D. #40 - Little Vandal Preschool   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
136761 AZ     school 406250 4237   Peoria Unified School District 40625003643 1000302 GCC Early Childhood Learning Lab   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
136794 AZ     school 406300 4256   Phoenix Elementary District 40630003554 286779 Faith North Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
136883 AZ     school 406730 4466   Prescott Unified District 40673000352 8126 Discovery Gardens Preschool   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
137042 AZ     school 407700 4393   Show Low Unified District 40770003615 7673 Show Low Preschool   Special Education School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
137063 AZ     school 407820 4391   Snowflake Unified District 40782002543 87577 Snowflake Preschool   Special Education School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
137351 AZ     school 408850 4413   Vail Unified District 40885003665 1000286 Vail Inclusive Preschool   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
137435 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_1                                                   *                                              
137516 AZ     school 400600 4280   Alhambra Elementary District 40060003660 1000261 Alhambra Preschool Academy   Regular School No Prekindergarten PK PK 2020   grade_2                                                   *                                              
137637 AZ     school 400463 6393   Arizona State School for the Deaf and Blind 40046303359 90801 FBC-Preschool   Special Education School No Prekindergarten PK PK 2020   grade_2                                                   *                                              
137639 AZ     school 400463 6393   Arizona State School for the Deaf and Blind 40046303237 90802 Phoenix CHIC - Morton Ave   Special Education School No Prekindergarten PK PK 2020   grade_2                                                   *                                              
137642 AZ     school 400463 6393   Arizona State School for the Deaf and Blind 40046303236 90798 Tucson CHIC Preschool   Special Education School No Prekindergarten PK PK 2020   grade_2                                                   *                                              

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]);