Data source: Big Local News · About: Big Local

1,971 rows where grade = "grade_9", state = "AZ" and year = 2019 sorted by school_state_id descending

View and edit SQL

year

  • 2019 · 1,971

grade

  • grade_9 · 1,971
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
585175 AZ     school   1000098   City School District of Albany   1000099 William S. Hackett Middle School             2019   grade_9                                                   *                                              
586327 AZ     school 400981 1000050   Science Technology Engineering and Math Arizona 40098103605 1000051 Da Vinci Tree Academy   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
586500 AZ     school 400976 92976   Think Through Academy 40097603624 1000047 Think Through Academy   Regular School Yes High 09 12 2019   grade_9                                                   21                                             21
584828 AZ     school 400600 4280   Alhambra Elementary District 40060003599 1000042 Valencia Newcomer School   Regular School No Elementary PK 08 2019   grade_9                                                   *                                              
584827 AZ     school 400600 4280   Alhambra Elementary District 40060003614 1000041 Madrid Neighborhood School   Regular School No Elementary PK 08 2019   grade_9                                                   *                                              
586012 AZ     school 400949 123733   Painted Desert Montessori, LLC 40094903520 991308 Painted Desert Montessori, LLC   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
585829 AZ     school 403860 4234   Maricopa County Regional School District 40386003535 969999 Hope College and Career Readiness Academy   Regular School No High 09 12 2019   grade_9                                                   *                                              
586445 AZ     school 400964 92981   Synergy Public School, Inc. 40096403553 962403 Synergy Public School   Regular School Yes Elementary KG 05 2019   grade_9                                                   *                                              
584953 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003566 948673 Indian Oasis Intermediate Elementary School   Regular School No Middle 04 06 2019   grade_9                                                   *                                              
586303 AZ     school 407300 4411   Sahuarita Unified District 40730003582 948236 Wrightson Ridge K-8 School   Regular School No Elementary KG 08 2019   grade_9                                                   *                                              
584807 AZ     school 400450 4289   Agua Fria Union High School District 40045003559 932049 Canyon View High School   Regular School No High 09 12 2019   grade_9                                                   442                                             442
585753 AZ     school 400944 92730   Leman Academy of Excellence, Inc. 40094403504 926143 Leman Academy of Excellence-Oro Valley Arizona   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
585345 AZ     school 400640 81050   Edkey, Inc. - Sequoia School for the Deaf and Hard of Hearing 40064003569 920316 KELLY   Regular School Yes Other KG 12 2019   grade_9                                                   *                                              
584791 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103581 911531 Academy of Math and Science Desert Sky   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
584984 AZ     school 400980 783027   BASIS Charter Schools, Inc. 40098003607 893297 BASIS Scottsdale Primary - West Campus   Regular School Yes Elementary KG 04 2019   grade_9                                                   *                                              
584855 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203576 865358 American Leadership Academy, Higley   Regular School Yes Elementary KG 06 2019   grade_9                                                   *                                              
584935 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes High 07 12 2019   grade_9                                                   93                                             93
586081 AZ     school 400950 92983   Pathways In Education-Arizona, Inc. 40095003508 850102 Pathways in Education   Regular School Yes High 09 12 2019   grade_9                                                   56                                             56
586653 AZ     school 400968 92985   Victory Collegiate Academy Corporation 40096803562 829726 Victory Collegiate Academy   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
585535 AZ     school 403450 4285   Glendale Union High School District 40345003510 794564 Glendale Union Online   Regular School No High 09 12 2019   grade_9                                                   *                                              
585218 AZ     school 402400 4501   Crane Elementary District 40240003521 778305 Crane iLearning Academy   Regular School No Elementary PK 08 2019   grade_9                                                   *                                              
586492 AZ     school 400977 395879   The French American Academy of Arizona 40097703580 769544 The French American Academy of Arizona   Regular School Yes Elementary KG 05 2019   grade_9                                                   *                                              
585646 AZ     school 400952 92989   Kaizen Education Foundation dba Colegio Petite Phoenix 40095203514 766437 Colegio Petite Arizona   Regular School Yes Elementary KG 05 2019   grade_9                                                   *                                              
585726 AZ     school 404290 4276   Laveen Elementary District 40429003530 756942 Paseo Pointe School   Regular School No Elementary PK 08 2019   grade_9                                                   *                                              
584810 AZ     school 400970 449790   AIBT Non-Profit Charter High School, Inc. 40097003546 742847 RCB College Preparatory Academy   Regular School Yes High 09 12 2019   grade_9                                                   *                                              
585752 AZ     school 400944 92730   Leman Academy of Excellence, Inc. 40094403586 734680 Leman Academy of Excellence East Tucson   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
585822 AZ     school 404630 4404   Marana Unified District 40463003516 713837 Gladden Farms Elementary   Regular School No Elementary PK 06 2019   grade_9                                                   *                                              
585567 AZ     school 400966 92982   Highland Prep 40096603572 703390 Highland Prep   Regular School Yes Secondary 09 11 2019   grade_9                                                   117                                             117
586493 AZ     school 400953 92978   The Grande Innovation Academy 40095303527 649230 The Grande Innovation   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
584934 AZ     school 400947 92987   ASU Preparatory Academy - Casa Grande 40094703526 635758 ASU Preparatory Academy - Casa Grande HS   Regular School Yes High 09 12 2019   grade_9                                                   61                                             61
585046 AZ     school 400633 81029   Canyon Rose Academy, Inc. 40063303536 605648 Canyon Rose Academy-East   Regular School Yes High 09 12 2019   grade_9                                                   *                                              
585751 AZ     school 400944 92730   Leman Academy of Excellence, Inc. 40094403584 573453 Leman Academy of Excellence East Mesa   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
586659 AZ     school 400887 91948   Vista College Preparatory, Inc. 40088703561 551692 Vista College Prep - Maryvale   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
585828 AZ     school 403860 4234   Maricopa County Regional School District 40386003552 549878 Esperanza Prep   Regular School No Elementary KG 08 2019   grade_9                                                   *                                              
585740 AZ     school 400962 834265   Legacy Traditional School - East Mesa 40096203551 541763 Legacy Traditional School - East Mesa   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
585790 AZ     school 404440 4278   Littleton Elementary District 40444003533 530879 Fine Arts Academy   Regular School No Elementary KG 08 2019   grade_9                                                   *                                              
585021 AZ     school 401380 4269   Buckeye Elementary District 40138003575 527220 Marionneaux Elementary School   Regular School No Elementary PK 08 2019   grade_9                                                   *                                              
584854 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203573 509281 American Leadership Academy, Gilbert   Regular School Yes Other KG 12 2019   grade_9                                                   311                                             311
584963 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   grade_9                                                   *                                              
585331 AZ     school 400978 743644   Edison Project 40097803585 465875 Edison School of Innovation   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
585376 AZ     school 400191 78783   Fit Kids, Inc. dba Champion Schools 40019103557 460111 Champion San Tan   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
585006 AZ     school 406580 4397   Blue Ridge Unified School District No. 32 40658003564 456092 Blue Ridge High School Online   Regular School No High 09 12 2019   grade_9                                                   *                                              
586385 AZ     school 401460 4175   Sierra Vista Unified District 40146003524 440989 Sierra Vista Online   Regular School No High 09 12 2019   grade_9                                                   *                                              
585743 AZ     school 400954 850101   Legacy Traditional School - North Chandler 40095403513 411380 Legacy Traditional School – North Chandler   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
586241 AZ     school 406810 4245   Queen Creek Unified District 40681003583 390026 Faith Mather Sossaman Elementary School   Regular School No Elementary PK 05 2019   grade_9                                                   *                                              
584933 AZ     school 400971 631426   ASU Preparatory Academy 40097103567 338609 ASU Preparatory Academy - Tempe   Regular School Yes High 09 12 2019   grade_9                                                   16                                             16
586203 AZ     school 400321 79439   Pinnacle Education-WMCB, Inc. 40032103565 289884 Pinnacle Online - WMCB   Regular School Yes High 09 12 2019   grade_9                                                   *                                              
585750 AZ     school 400944 92730   Leman Academy of Excellence, Inc. 40094403547 271268 Leman Virtual Academy   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
584853 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203570 242454 American Leadership Academy Signal Butte   Regular School Yes Elementary KG 06 2019   grade_9                                                   *                                              
585395 AZ     school 402860 4192   Flagstaff Unified District 40286003506 230656 Northern Arizona Distance Learning   Regular School No High 07 12 2019   grade_9                                                   *                                              
585742 AZ     school 400948 850100   Legacy Traditional School - Glendale 40094803523 229646 Legacy Traditional School – Glendale   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
585749 AZ     school 400944 92730   Leman Academy of Excellence, Inc. 40094403542 225365 Leman Academy of Excellence-Sierra Vista   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
586180 AZ     school 406330 4286   Phoenix Union High School District 40633003509 221992 Phoenix Coding Academy   Regular School No High 09 12 2019   grade_9                                                   93                                             93
586293 AZ     school 407240 4218   Safford Unified District 40724003507 216045 Henry Dunkerson Pathways Academy   Regular School No High 09 12 2019   grade_9                                                   *                                              
585371 AZ     school 400955 92988   Estrella Educational Foundation 40095503519 181823 Maricopa Institute of Technology   Regular School Yes Secondary 09 11 2019   grade_9                                                   74                                             74
584901 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes High 09 12 2019   grade_9                                                   28                                             28
584983 AZ     school 400961 549803   BASIS Charter Schools, Inc. 40096103550 139682 BASIS Phoenix South Primary   Regular School Yes Elementary KG 04 2019   grade_9                                                   *                                              
586179 AZ     school 406330 4286   Phoenix Union High School District 40633003555 128903 Phoenix Union-Wilson College Preparatory   Regular School No High 09 12 2019   grade_9                                                   63                                             63
586104 AZ     school 400945 92972   Pensar Academy 40094503518 126443 Pensar Academy   Regular School Yes Middle 04 08 2019   grade_9                                                   *                                              
585746 AZ     school 400959 873957   Legacy Traditional School - Phoenix 40095903579 112572 Legacy Traditional School - Phoenix   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
584982 AZ     school 400963 273398   BASIS Charter Schools, Inc. 40096303558 103670 BASIS Peoria Primary   Regular School Yes Elementary KG 04 2019   grade_9                                                   *                                              
584981 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2019   grade_9                                                   *                                              
585580 AZ     school 403780 4248   Higley Unified School District 40378003490 93009 Bridges Elementary School   Regular School No Elementary KG 06 2019   grade_9                                                   *                                              
586646 AZ     school 408850 4413   Vail Unified District 40885003489 93000 Copper Ridge Elementary   Regular School No Elementary PK 05 2019   grade_9                                                   *                                              
586190 AZ     school 400367 79959   Pima Prevention Partnership dba Pima Partnership School, The 40036703531 92994 Pima Prevention Partnership-Tucson   Regular School Yes High 09 12 2019   grade_9                                                   *                                              
584908 AZ     school 400913 91958   Arizona Autism Charter Schools, Inc. 40091303512 92984 Arizona Autism Charter School, Upper School Campus   Regular School Yes High 05 12 2019   grade_9                                                   17                                             17
585367 AZ     school 400877 91277   Empower College Prep 40087703522 92975 Empower Collegiate Academy   Regular School Yes Secondary 07 11 2019   grade_9                                                   82                                             82
586257 AZ     school 407020 4257   Riverside Elementary District 40702003485 92961 Maricopa Institute of Technology (MIT)   Regular School No Middle 07 08 2019   grade_9                                                   *                                              
586010 AZ     school 405820 4196   Page Unified District 40582003492 92913 Manson Mesa High School   Regular School No High 09 12 2019   grade_9                                                   *                                              
585348 AZ     school 400246 79211   Edkey, Inc. - Sequoia Village School 40024603494 92912 George Washington Academy   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
586240 AZ     school 406810 4245   Queen Creek Unified District 40681003477 92911 Gateway Polytechnic Academy   Regular School No Elementary PK 05 2019   grade_9                                                   *                                              
585276 AZ     school 407750 4246   Deer Valley Unified District 40775003463 92907 Sonoran Foothills School   Regular School No Elementary PK 08 2019   grade_9                                                   *                                              
585219 AZ     school 400938 92369   Create Academy 40093803476 92906 Create Academy   Regular School Yes Elementary KG 06 2019   grade_9                                                   *                                              
585370 AZ     school 400939 92902   Espiritu Schools 40093903495 92903 AIM Higher College Prep Academy   Regular School Yes High 07 12 2019   grade_9                                                   *                                              
585372 AZ     school 400942 92379   Ethos Academy - A Challenge Foundation Academy 40094203497 92893 Ethos Academy- A Challenge Foundation Academy   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
585155 AZ     school 401870 4242   Chandler Unified District #80 40187003483 92892 Dr. Camille Casteel High School   Regular School No High 07 12 2019   grade_9                                                   571                                             571
585154 AZ     school 401870 4242   Chandler Unified District #80 40187003479 92891 Dr. Gary and Annette Auxier Elementary School   Regular School No Elementary PK 06 2019   grade_9                                                   *                                              
586364 AZ     school 400934 92381   Self Development Academy-Phoenix 40093403493 92890 Self Development Academy-Phoenix   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
584852 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203475 92885 American Leadership Academy - Ironwood   Regular School Yes Other KG 12 2019   grade_9                                                   259                                             259
586082 AZ     school 400344 78890   Pathways KM Charter Schools, Inc 40034403467 92883 Bella Vista Academy   Regular School Yes Middle 06 08 2019   grade_9                                                   *                                              
585747 AZ     school 400933 92879   Legacy Traditional School - Surprise 40093303496 92880 Legacy Traditional School - Surprise   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
585780 AZ     school 404380 4281   Litchfield Elementary District 40438003478 92878 Verrado Heritage Elementary School   Regular School No Elementary PK 08 2019   grade_9                                                   *                                              
584980 AZ     school 400936 92865   BASIS Charter Schools, Inc. 40093603484 92866 BASIS Chandler Primary- South Campus   Regular School Yes Elementary KG 05 2019   grade_9                                                   *                                              
584979 AZ     school 400937 92863   BASIS Charter Schools, Inc. 40093703482 92864 BASIS Scottsdale Primary - East Campus   Regular School Yes Elementary KG 03 2019   grade_9                                                   *                                              
586442 AZ     school 408170 4407   Sunnyside Unified District 40817003500 92770 Gallego Intermediate Fine Arts Magnet School   Regular School No Middle 04 08 2019   grade_9                                                   *                                              
584793 AZ     school 400940 92768   Academy of Mathematics and Science, Inc. 40094003499 92769 Academy of Math and Science Camelback   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
584880 AZ     school 400720 4506   Antelope Union High School District 40072003466 92739 AUHS Online Acadamy   Regular School No High 09 12 2019   grade_9                                                   *                                              
584978 AZ     school 400943 92736   BASIS Charter Schools, Inc. 40094303498 92737 BASIS Goodyear Primary   Regular School Yes Elementary KG 05 2019   grade_9                                                   *                                              
584977 AZ     school 400941 92734   BASIS Charter Schools, Inc. 40094103502 92735 BASIS Goodyear   Regular School Yes High 05 12 2019   grade_9                                                   16                                             16
585765 AZ     school 400919 92657   Lincoln Preparatory Academy 40091903472 92732 Great Hearts Academies - Lincoln Prep   Regular School Yes Secondary 06 11 2019   grade_9                                                   71                                             71
585748 AZ     school 400944 92730   Leman Academy of Excellence, Inc. 40094403503 92731 Leman Academy of Excellence   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
584893 AZ     school 400925 92656   Archway Classical Academy Lincoln 40092503464 92708 Great Hearts Academies - Archway Lincoln   Regular School Yes Elementary KG 05 2019   grade_9                                                   *                                              
584896 AZ     school 400930 92704   Archway Classical Academy Trivium East 40093003462 92707 Great Hearts Academies - Archway Trivium East   Regular School Yes Elementary KG 05 2019   grade_9                                                   *                                              
585759 AZ     school 404320 4266   Liberty Elementary District 40432003480 92706 Las Brisas Academy   Regular School No Elementary KG 08 2019   grade_9                                                   *                                              
586280 AZ     school 407130 4155   Round Valley Unified District 40713003442 92686 White Mountain Academy   Regular School No High 09 12 2019   grade_9                                                   *                                              
586147 AZ     school 406250 4237   Peoria Unified School District 40625003447 92645 Sunflower School   Regular School No Other PK 12 2019   grade_9                                                   *                                              
586748 AZ     school 409600 4499   Yuma Elementary District 40960003430 92641 Yuma District One Digital Learning Academy   Regular School No Elementary KG 08 2019   grade_9                                                   *                                              
586146 AZ     school 406250 4237   Peoria Unified School District 40625003441 92638 Sunset Heights Elementary School   Regular School No Elementary PK 08 2019   grade_9                                                   *                                              
585170 AZ     school 400402 5186   Cholla Academy 40040203429 92637 Westland School Brighton Campus   Regular School Yes Other KG 12 2019   grade_9                                                   15                                             15
585168 AZ     school 400805 90138   Choice Academies, Inc. 40080503444 92636 Jefferson Preparatory High School   Regular School Yes High 07 12 2019   grade_9                                                   55                                             55

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