Data source: Big Local News · About: Big Local

8,512 rows where grade = "grade_9" and state = "AZ" sorted by ccd_school_high_grade descending

View and edit SQL

year

grade

  • grade_9 · 8,512
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
87370 AZ     school 400600 4280   Alhambra Elementary District 40060003660 1000261 Alhambra Preschool Academy   Regular School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
87535 AZ     school 401050 4268   Balsz Elementary District 40105003374 92301 Orangedale Early Learning Center   Special Education School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
87636 AZ     school 401680 4282   Cartwright Elementary District 40168001054 5414 Byron A. Barry School   Regular School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
87662 AZ     school 401710 4446   Casa Grande Elementary District 40171003201 90899 Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
87674 AZ     school 401760 4410   Catalina Foothills Unified District 40176001531 5836 Catalina Foothills Valley View Early Learning Center   Regular School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
87938 AZ     school 402530 4174   Douglas Unified District 40253000184 4764 Early Learning Center   Regular School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
88077 AZ     school 403010 4405   Flowing Wells Unified District 40301002065 79249 Emily Meschter Early Learning Center   Regular School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
88121 AZ     school 403240 4505   Gadsden Elementary District 40324001108 6186 San Luis Pre-School   Regular School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
88271 AZ     school 403780 4248   Higley Unified School District 40378003417 92252 Elona P. Cooley Early Child Development Center   Special Education School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
88278 AZ     school 403780 4248   Higley Unified School District 40378003361 92264 Sue Sossaman Early Childhood Development Center   Special Education School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
88294 AZ     school 403870 4469   Humboldt Unified District 40387002926 89839 Bright Futures Preschool   Regular School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
88324 AZ     school 403960 4259   Isaac Elementary District 40396001543 5241 Bret Tarver Education Complex   Regular School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
88526 AZ     school 404630 4404   Marana Unified District 40463003663 1000279 MUSD Early Learning and Resource Center   Special Education School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
88577 AZ     school 404970 4235   Mesa Unified District 40497002337 80046 Early Education Center   Regular School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
88622 AZ     school 404970 4235   Mesa Unified District 40497002109 79687 Red Mountain Center for Early Education   Special Education School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
88652 AZ     school 405030 4211   Miami Unified District 40503002789 89583 M.U.S.D. #40 - Little Vandal Preschool   Special Education School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
88879 AZ     school 406250 4237   Peoria Unified School District 40625003643 1000302 GCC Early Childhood Learning Lab   Regular School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
88912 AZ     school 406300 4256   Phoenix Elementary District 40630003554 286779 Faith North Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
89006 AZ     school 406730 4466   Prescott Unified District 40673000352 8126 Discovery Gardens Preschool   Regular School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
89168 AZ     school 407700 4393   Show Low Unified District 40770003615 7673 Show Low Preschool   Regular School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
89188 AZ     school 407820 4391   Snowflake Unified District 40782002543 87577 Snowflake Preschool   Special Education School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
89480 AZ     school 408850 4413   Vail Unified District 40885003665 1000286 Vail Inclusive Preschool   Regular School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
89601 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2021   grade_9                                                   *                                              
153266 AZ     school 400600 4280   Alhambra Elementary District 40060003660 1000261 Alhambra Preschool Academy   Regular School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
153387 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_9                                                   *                                              
153389 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_9                                                   *                                              
153392 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_9                                                   *                                              
153444 AZ     school 401050 4268   Balsz Elementary District 40105003374 92301 Orangedale Early Learning Center   Special Education School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
153549 AZ     school 401680 4282   Cartwright Elementary District 40168001054 5414 Byron A. Barry School   Regular School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
153575 AZ     school 401710 4446   Casa Grande Elementary District 40171003201 90899 Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
153587 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_9                                                   *                                              
153751 AZ     school 402400 4501   Crane Elementary District 40240002882 87486 Great Beginnings Pre-School   Regular School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
153843 AZ     school 402530 4174   Douglas Unified District 40253000184 4764 Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
153973 AZ     school 403010 4405   Flowing Wells Unified District 40301002065 79249 Emily Meschter Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
154019 AZ     school 403240 4505   Gadsden Elementary District 40324001108 6186 San Luis Pre-School   Regular School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
154167 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_9                                                   *                                              
154174 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_9                                                   *                                              
154191 AZ     school 403870 4469   Humboldt Unified District 40387002926 89839 Bright Futures Preschool   Regular School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
154222 AZ     school 403960 4259   Isaac Elementary District 40396001543 5241 Bret Tarver Education Complex   Regular School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
154420 AZ     school 404630 4404   Marana Unified District 40463003663 1000279 MUSD Early Learning and Resource Center   Special Education School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
154472 AZ     school 404970 4235   Mesa Unified District 40497002337 80046 Early Education Center   Regular School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
154517 AZ     school 404970 4235   Mesa Unified District 40497002109 79687 Red Mountain Center for Early Education   Special Education School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
154547 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_9                                                   *                                              
154761 AZ     school 406250 4237   Peoria Unified School District 40625003643 1000302 GCC Early Childhood Learning Lab   Regular School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
154794 AZ     school 406300 4256   Phoenix Elementary District 40630003554 286779 Faith North Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
154883 AZ     school 406730 4466   Prescott Unified District 40673000352 8126 Discovery Gardens Preschool   Regular School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
155042 AZ     school 407700 4393   Show Low Unified District 40770003615 7673 Show Low Preschool   Special Education School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
155063 AZ     school 407820 4391   Snowflake Unified District 40782002543 87577 Snowflake Preschool   Special Education School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
155351 AZ     school 408850 4413   Vail Unified District 40885003665 1000286 Vail Inclusive Preschool   Regular School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
155435 AZ     school 409430 4154   Window Rock Unified District 40943000155 4713 Integrated Preschool   Regular School No Prekindergarten PK PK 2020   grade_9                                                   *                                              
556443 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_9                                                   *                                              
555328 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes Not Applicable N N 2018   grade_9                                                   15                                             15
154975 AZ     school 406960 4210   San Carlos Unified District 40696003683 1000382 San Carlos Middle School   Regular School No Not reported M M 2020   grade_9                                                   *                                              
88674 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2021   grade_9                                                   *                                              
154570 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2020   grade_9                                                   *                                              
556299 AZ     school 404970 4235   Mesa Unified District 40497003377 92351 Jordan Center for Early Education   Regular School No Elementary PK KG 2018   grade_9                                                   *                                              
556370 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2018   grade_9                                                   *                                              
585925 AZ     school 404970 4235   Mesa Unified District 40497003377 92351 Jordan Center for Early Education   Regular School No Elementary PK KG 2019   grade_9                                                   *                                              
585950 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2019   grade_9                                                   *                                              
87334 AZ     school 400998 1000166   A+ Charter Schools 40099803681 1000972 A+ Charter Schools   Regular School Yes High 07 12 2021   grade_9                                                   65                                             65
87337 AZ     school 400414 85540   Academy of Building Industries, Inc. 40041402412 85541 Academy of Building Industries   Alternative School Yes High 09 12 2021   grade_9                                                   *                                              
87344 AZ     school 400368 79961   Academy of Mathematics and Science, Inc. 40036802037 79094 Academy of Math and Science   Regular School Yes Other KG 12 2021   grade_9                                                   *                                              
87347 AZ     school 400202 78897   Academy of Tucson, Inc. 40020201959 78898 Academy of Tucson High School   Regular School Yes High 09 12 2021   grade_9                                                   63                                             63
87349 AZ     school 400276 79213   Academy with Community Partners Inc 40027601841 10795 Academy with Community Partners   Alternative School Yes High 09 12 2021   grade_9                                                   *                                              
87353 AZ     school 400129 6364   Accelerated Elementary and Secondary Schools 40012901790 5891 Accelerated Learning Laboratory   Regular School Yes Other KG 12 2021   grade_9                                                   24                                             24
87354 AZ     school 400121 4297   Accelerated Learning Center, Inc. 40012101581 5462 Accelerated Learning Center   Alternative School Yes High 09 12 2021   grade_9                                                   *                                              
87358 AZ     school 400450 4289   Agua Fria Union High School District 40045000001 5454 Agua Fria High School   Regular School No High 09 12 2021   grade_9                                                   410                                             410
87359 AZ     school 400450 4289   Agua Fria Union High School District 40045003559 932049 Canyon View High School   Regular School No High 09 12 2021   grade_9                                                   486                                             486
87360 AZ     school 400450 4289   Agua Fria Union High School District 40045002273 79799 Desert Edge High School   Regular School No High 09 12 2021   grade_9                                                   486                                             486
87361 AZ     school 400450 4289   Agua Fria Union High School District 40045001884 78926 Millennium High School   Regular School No High 09 12 2021   grade_9                                                   532                                             532
87362 AZ     school 400450 4289   Agua Fria Union High School District 40045002592 87903 Verrado High School   Regular School No High 09 12 2021   grade_9                                                   389                                             389
87364 AZ     school 400274 79053   AIBT Non-Profit Charter High School - Phoenix 40027402020 79123 Career and College Prep   Alternative School Yes High 07 12 2021   grade_9                                                   *                                              
87365 AZ     school 400970 449790   AIBT Non-Profit Charter High School, Inc. 40097003546 742847 RCB College Preparatory Academy   Regular School Yes High 09 12 2021   grade_9                                                   *                                              
87367 AZ     school 400520 4409   Ajo Unified District 40052003063 6292 Ajo High School   Regular School No High 09 12 2021   grade_9                                                   30                                             30
87393 AZ     school 400619 80995   American Charter Schools Foundation d.b.a. Alta Vista High School 40061903097 80996 Alta Vista High School   Alternative School Yes High 09 12 2021   grade_9                                                   108                                             108
87394 AZ     school 400357 79883   American Charter Schools Foundation d.b.a. Apache Trail High School 40035701732 6346 Apache Trail High School   Alternative School Yes High 09 12 2021   grade_9                                                   *                                              
87395 AZ     school 400385 79874   American Charter Schools Foundation d.b.a. Crestview College Preparatory High Sc 40038502016 78813 Crestview College Preparatory High School   Alternative School Yes High 07 12 2021   grade_9                                                   17                                             17
87396 AZ     school 400384 79872   American Charter Schools Foundation d.b.a. Desert Hills High School 40038401899 78901 Desert Hills High School   Alternative School Yes High 09 12 2021   grade_9                                                   25                                             25
87397 AZ     school 400352 79873   American Charter Schools Foundation d.b.a. Estrella High School 40035201898 78900 Estrella High School   Alternative School Yes High 09 12 2021   grade_9                                                   12                                             12
87398 AZ     school 400353 79875   American Charter Schools Foundation d.b.a. Peoria Accelerated High School 40035301896 78817 Peoria Accelerated High School   Alternative School Yes High 09 12 2021   grade_9                                                   32                                             32
87399 AZ     school 400618 80989   American Charter Schools Foundation d.b.a. South Pointe High School 40061803095 80990 South Pointe High School   Alternative School Yes High 09 12 2021   grade_9                                                   91                                             91
87400 AZ     school 400447 88334   American Charter Schools Foundation d.b.a. South Ridge High School 40044702671 88335 South Ridge High School   Regular School Yes High 09 12 2021   grade_9                                                   94                                             94
87401 AZ     school 400354 79877   American Charter Schools Foundation d.b.a. Sun Valley High School 40035401733 6347 Sun Valley High School   Alternative School Yes High 09 12 2021   grade_9                                                   18                                             18
87402 AZ     school 400355 79879   American Charter Schools Foundation d.b.a. West Phoenix High School 40035501734 6348 West Phoenix High School   Alternative School Yes High 09 12 2021   grade_9                                                   73                                             73
87406 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203573 509281 American Leadership Academy, Gilbert North K-12   Regular School Yes Other KG 12 2021   grade_9                                                   386                                             386
87408 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203475 92885 American Leadership Academy, Ironwood K12   Regular School Yes Other KG 12 2021   grade_9                                                   341                                             341
87410 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203179 90769 American Leadership Academy, Queen Creek K-12   Regular School Yes Other KG 12 2021   grade_9                                                   280                                             280
87412 AZ     school 400329 79461   American Virtual Academy 40032903159 81178 Primavera - Online   Alternative School Yes High 06 12 2021   grade_9                                                   701                                             701
87413 AZ     school 400680 4406   Amphitheater Unified District 40068003330 91755 Amphi Academy Online   Regular School No Other KG 12 2021   grade_9                                                   38                                             38
87414 AZ     school 400680 4406   Amphitheater Unified District 40068000032 6055 Amphitheater High School   Regular School No High 09 12 2021   grade_9                                                   287                                             287
87416 AZ     school 400680 4406   Amphitheater Unified District 40068000033 5808 Canyon Del Oro High School   Regular School No High 09 12 2021   grade_9                                                   443                                             443
87422 AZ     school 400680 4406   Amphitheater Unified District 40068002198 79378 Ironwood Ridge High School   Regular School No High 09 12 2021   grade_9                                                   396                                             396
87431 AZ     school 400680 4406   Amphitheater Unified District 40068000030 5803 Rillito Center   Special Education School No Other PK 12 2021   grade_9                                                   *                                              
87435 AZ     school 400720 4506   Antelope Union High School District 40072000034 6188 Antelope Union High School   Regular School No High 09 12 2021   grade_9                                                   54                                             54
87436 AZ     school 400720 4506   Antelope Union High School District 40072003466 92739 AUHS Online Acadamy   Regular School No High 09 12 2021   grade_9                                                   *                                              
87437 AZ     school 400819 90532   Anthem Preparatory Academy 40081903187 90635 Great Hearts Academies - Anthem Prep   Regular School Yes Other KG 12 2021   grade_9                                                   54                                             54
87439 AZ     school 400790 4443   Apache Junction Unified District 40079000043 5925 Apache Junction High School   Regular School No High 09 12 2021   grade_9                                                   271                                             271
87447 AZ     school 400834 90917   Archway Classical Academy Chandler 40083403244 90999 Great Hearts Academies - Archway Chandler   Regular School Yes Other KG 12 2021   grade_9                                                   *                                              
87454 AZ     school 400832 90915   Archway Classical Academy Trivium West 40083203290 91001 Great Hearts Academies - Archway Trivium West   Regular School Yes Other KG 12 2021   grade_9                                                   *                                              
87455 AZ     school 400833 90916   Archway Classical Academy Veritas 40083303283 91000 Great Hearts Academies - Archway Veritas   Regular School Yes Other KG 12 2021   grade_9                                                   *                                              

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