Data source: Big Local News · About: Big Local

1,971 rows where grade = "grade_9", state = "AZ" and year = 2019

View and edit SQL

year

  • 2019 · 1,871

grade

  • grade_9 · 1,871
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
584886 AZ     school 400790 4443   Apache Junction Unified District 40079000043 5925 Apache Junction High School   Regular School No High 09 12 2019   grade_9                                                   261                                             261
584887 AZ     school 400790 4443   Apache Junction Unified District 40079002212 79631 Peralta Trail Elementary School   Regular School No Elementary KG 06 2019   grade_9                                                   *                                              
584888 AZ     school 400318 79426   Aprender Tucson 40031802203 79432 Southside Community School   Regular School Yes Other KG 09 2019   grade_9                                                   *                                              
584889 AZ     school 400888 92312   Archway Classical Academy Arete 40088803412 92313 Great Hearts Academies - Archway Arete   Regular School Yes Elementary KG 05 2019   grade_9                                                   *                                              
584890 AZ     school 400834 90917   Archway Classical Academy Chandler 40083403244 90999 Great Hearts Academies - Archway Chandler   Regular School Yes Other KG 12 2019   grade_9                                                   *                                              
584891 AZ     school 400886 92314   Archway Classical Academy Cicero 40088603407 92315 Great Hearts Academies - Archway Cicero   Regular School Yes Elementary KG 05 2019   grade_9                                                   *                                              
584892 AZ     school 400866 91878   Archway Classical Academy Glendale 40086603356 91879 Great Hearts Academies - Archway Glendale   Regular School Yes Elementary KG 05 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                                                   *                                              
584894 AZ     school 400873 91758   Archway Classical Academy North Phoenix 40087303353 91785 Great Hearts Academies - Archway North Phoenix   Regular School Yes Elementary KG 06 2019   grade_9                                                   *                                              
584895 AZ     school 400841 90857   Archway Classical Academy Scottsdale 40084103259 90994 Great Hearts Academies - Archway Scottsdale   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                                                   *                                              
584897 AZ     school 400832 90915   Archway Classical Academy Trivium West 40083203290 91001 Great Hearts Academies - Archway Trivium West   Regular School Yes Other KG 12 2019   grade_9                                                   *                                              
584898 AZ     school 400833 90916   Archway Classical Academy Veritas 40083303283 91000 Great Hearts Academies - Archway Veritas   Regular School Yes Other KG 12 2019   grade_9                                                   *                                              
584899 AZ     school 400757 89486   Arete Preparatory Academy 40075702820 89487 Great Hearts Academies - Arete Prep   Regular School Yes High 06 12 2019   grade_9                                                   86                                             86
584900 AZ     school 400164 6378   Arizona Academy of Science And Technology, Inc. 40016401726 10755 Arizona Academy of Science and Technology   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
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
584902 AZ     school 400106 4331   Arizona Agribusiness & Equine Center, Inc. 40010601892 6344 AAEC - Paradise Valley   Regular School Yes High 09 12 2019   grade_9                                                   91                                             91
584903 AZ     school 400417 85816   Arizona Agribusiness & Equine Center, Inc. 40041701588 5503 AAEC - SMCC Campus   Regular School Yes High 09 12 2019   grade_9                                                   181                                             181
584904 AZ     school 400426 87403   Arizona Agribusiness & Equine Center, Inc. 40042602528 87404 Arizona Agribusiness & Equine Center, Inc. - Red Mountain   Regular School Yes High 09 12 2019   grade_9                                                   22                                             22
584905 AZ     school 400828 90779   Arizona Agribusiness & Equine Center, Inc. 40082803199 90780 Arizona Agribusiness & Equine Center - Estrella   Regular School Yes High 09 12 2019   grade_9                                                   143                                             143
584906 AZ     school 400838 91131   Arizona Agribusiness & Equine Center, Inc. 40083803243 91132 Arizona Agribusiness & Equine Center, Inc. - Prescott Valley   Regular School Yes High 09 12 2019   grade_9                                                   87                                             87
584907 AZ     school 400913 91958   Arizona Autism Charter Schools, Inc. 40091303455 92598 Arizona Autism Charter School   Regular School Yes Elementary KG 06 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
584909 AZ     school 400057 4346   Arizona Call-a-Teen Youth Resources, Inc. 40005700784 5520 City View High School   Regular School Yes High 09 12 2019   grade_9                                                   *                                              
584910 AZ     school 400361 79947   Arizona Community Development Corporation 40036102299 79950 La Paloma Academy   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
584911 AZ     school 400361 79947   Arizona Community Development Corporation 40036103165 81187 La Paloma Academy (Lakeside)   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
584912 AZ     school 400361 79947   Arizona Community Development Corporation 40036103312 91805 La Paloma Academy-South   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
584913 AZ     school 400427 87407   Arizona Connections Academy Charter School, Inc. 40042703160 81179 Arizona Connections Academy   Regular School Yes Other KG 12 2019   grade_9                                                   257                                             257
584914 AZ     school 400827 90758   Arizona Education Solutions 40082703252 91184 Valiant Academy   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
584915 AZ     school 400827 90758   Arizona Education Solutions 40082703309 91246 Valiant Academy   Regular School Yes High 09 12 2019   grade_9                                                   *                                              
584916 AZ     school 400918 92566   Arizona Language Preparatory 40091803426 92567 Arizona Language Preparatory   Regular School Yes Elementary KG 06 2019   grade_9                                                   *                                              
584917 AZ     school 400415 85749   Arizona Montessori Charter School at Anthem 40041502414 85750 AMCS at Anthem dba Caurus Academy   Regular School Yes Other KG 10 2019   grade_9                                                   44                                             44
584918 AZ     school 400056 4345   Arizona School For The Arts 40005600781 5519 Arizona School For The Arts   Regular School Yes High 05 12 2019   grade_9                                                   119                                             119
584919 AZ     school 400840 4274   Arlington Elementary District 40084000044 5354 Arlington Elementary School   Regular School No Elementary PK 08 2019   grade_9                                                   *                                              
584920 AZ     school 400870 4187   Ash Creek Elementary District 40087000046 4797 Ash Creek Elementary   Regular School No Elementary PK 08 2019   grade_9                                                   *                                              
584921 AZ     school 400910 4471   Ash Fork Joint Unified District 40091000047 6101 Ash Fork Elementary School   Regular School No Elementary KG 05 2019   grade_9                                                   *                                              
584922 AZ     school 400910 4471   Ash Fork Joint Unified District 40091001059 6102 Ash Fork Middle School   Regular School No Middle 06 08 2019   grade_9                                                   *                                              
584923 AZ     school 400910 4471   Ash Fork Joint Unified District 40091000048 6103 Ash Fork High School   Regular School No High 09 12 2019   grade_9                                                   17                                             17
584924 AZ     school 400764 89949   ASU Preparatory Academy 40076403051 90271 ASU Preparatory Academy- Phoenix Elementary   Regular School Yes Elementary KG 04 2019   grade_9                                                   *                                              
584925 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 ASU Preparatory Academy - South Phoenix Intermediate   Regular School Yes Middle 03 07 2019   grade_9                                                   *                                              
584926 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2019   grade_9                                                   100                                             100
584927 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 09 12 2019   grade_9                                                   97                                             97
584928 AZ     school 400857 91307   ASU Preparatory Academy 40085703260 91308 ASU Preparatory Academy-Polytechnic Elementary   Regular School Yes Elementary KG 04 2019   grade_9                                                   *                                              
584929 AZ     school 400890 92325   ASU Preparatory Academy 40089003367 92326 ASU Preparatory Academy - Phoenix Middle School   Regular School Yes Middle 05 08 2019   grade_9                                                   *                                              
584930 AZ     school 400884 92327   ASU Preparatory Academy 40088403264 91323 ASU Preparatory Academy-Polytechnic Middle School   Regular School Yes Middle 05 08 2019   grade_9                                                   *                                              
584931 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 ASU Preparatory Academy - South Phoenix Primary   Regular School Yes Elementary PK 04 2019   grade_9                                                   *                                              
584932 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 ASU Preparatory Academy - South Phoenix High School   Regular School Yes High 08 12 2019   grade_9                                                   43                                             43
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
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
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
584936 AZ     school 400960 4272   Avondale Elementary District 40096000049 5347 Michael Anderson   Regular School No Elementary PK 08 2019   grade_9                                                   *                                              
584937 AZ     school 400960 4272   Avondale Elementary District 40096001154 5348 Eliseo C. Felix School   Regular School No Elementary 02 05 2019   grade_9                                                   *                                              
584938 AZ     school 400960 4272   Avondale Elementary District 40096000051 5349 Lattie Coor   Regular School No Elementary PK 02 2019   grade_9                                                   *                                              
584939 AZ     school 400960 4272   Avondale Elementary District 40096001878 78924 Wildflower Accelerated Academy   Regular School No Elementary PK 08 2019   grade_9                                                   *                                              
584940 AZ     school 400960 4272   Avondale Elementary District 40096002255 79670 Desert Star   Regular School No Elementary KG 08 2019   grade_9                                                   *                                              
584941 AZ     school 400960 4272   Avondale Elementary District 40096002381 79792 Desert Thunder   Regular School No Elementary PK 08 2019   grade_9                                                   *                                              
584942 AZ     school 400960 4272   Avondale Elementary District 40096002494 87619 Centerra Mirage STEM Academy   Regular School No Elementary PK 08 2019   grade_9                                                   *                                              
584943 AZ     school 400960 4272   Avondale Elementary District 40096002880 90028 Copper Trails   Regular School No Elementary PK 08 2019   grade_9                                                   *                                              
584944 AZ     school 400960 4272   Avondale Elementary District 40096003387 91985 Avondale Middle School   Regular School No Middle 06 08 2019   grade_9                                                   *                                              
584945 AZ     school 400394 79929   Avondale Learning dba Precision Academy 40039402323 80006 Precision Academy   Regular School Yes High 09 12 2019   grade_9                                                   17                                             17
584946 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Regular School Yes High 07 12 2019   grade_9                                                   23                                             23
584947 AZ     school 400094 4508   Az-Tec High School 40009401109 6192 AZTEC High School   Regular School Yes High 09 12 2019   grade_9                                                   *                                              
584948 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000312 5844 Indian Oasis Primary Elementary School   Regular School No Elementary PK 03 2019   grade_9                                                   *                                              
584949 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000311 5846 Baboquivari Middle School   Regular School No Middle 07 08 2019   grade_9                                                   *                                              
584950 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000310 5847 Baboquivari High School   Regular School No High 09 12 2019   grade_9                                                   47                                             47
584951 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003210 90821 Alternative Middle School (Indian Oasis Middle School)   Regular School No Middle 06 08 2019   grade_9                                                   *                                              
584952 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003222 90822 Alternative High School (Indian Oasis High School)   Regular School No High 09 12 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                                                   *                                              
584954 AZ     school 401000 4468   Bagdad Unified District 40100000052 6088 Bagdad Elementary School   Regular School No Elementary PK 05 2019   grade_9                                                   *                                              
584955 AZ     school 401000 4468   Bagdad Unified District 40100000053 6089 Bagdad Middle / Senior High School   Regular School No High 06 12 2019   grade_9                                                   33                                             33
584956 AZ     school 400184 79204   Ball Charter Schools (Dobson) 40018401713 10729 Dobson Academy, The - A Ball Charter School   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
584957 AZ     school 400100 4294   Ball Charter Schools (Hearn) 40010001714 10730 Hearn Academy, The - A Ball Charter School   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
584958 AZ     school 400867 90885   Ball Charter Schools (Val Vista) 40086703342 91791 Ball Charter Schools (Val Vista)   Regular School Yes Elementary KG 08 2019   grade_9                                                   *                                              
584959 AZ     school 401050 4268   Balsz Elementary District 40105000054 5319 Pat Tillman Middle School   Regular School No Middle 06 08 2019   grade_9                                                   *                                              
584960 AZ     school 401050 4268   Balsz Elementary District 40105000055 5320 David Crockett Elementary School   Regular School No Elementary PK 06 2019   grade_9                                                   *                                              
584961 AZ     school 401050 4268   Balsz Elementary District 40105000056 5321 Griffith Elementary School   Regular School No Elementary PK 06 2019   grade_9                                                   *                                              
584962 AZ     school 401050 4268   Balsz Elementary District 40105003142 81141 Brunson-Lee Elementary School   Regular School No Elementary PK 06 2019   grade_9                                                   *                                              
584963 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   grade_9                                                   *                                              
584964 AZ     school 400134 6361   BASIS Charter Schools, Inc. 40013401786 6065 BASIS Tucson Primary   Regular School Yes Other KG 12 2019   grade_9                                                   *                                              
584965 AZ     school 400608 81078   BASIS Charter Schools, Inc. 40060803115 81079 BASIS Scottsdale   Regular School Yes Other 04 12 2019   grade_9                                                   93                                             93
584966 AZ     school 400818 90508   BASIS Charter Schools, Inc. 40081803197 90509 BASIS Oro Valley   Regular School Yes High 05 12 2019   grade_9                                                   66                                             66
584967 AZ     school 400829 90841   BASIS Charter Schools, Inc. 40082903278 91055 BASIS Peoria   Regular School Yes High 05 12 2019   grade_9                                                   86                                             86
584968 AZ     school 400830 90842   BASIS Charter Schools, Inc. 40083003253 91056 BASIS Chandler   Regular School Yes High 05 12 2019   grade_9                                                   107                                             107
584969 AZ     school 400831 90862   BASIS Charter Schools, Inc. 40083103196 90863 BASIS Flagstaff   Regular School Yes Other KG 12 2019   grade_9                                                   54                                             54
584970 AZ     school 400843 91280   BASIS Charter Schools, Inc. 40084303351 91343 BASIS Phoenix   Regular School Yes High 05 12 2019   grade_9                                                   102                                             102
584971 AZ     school 400878 91309   BASIS Charter Schools, Inc. 40087803350 91766 BASIS Tucson North   Regular School Yes High 05 12 2019   grade_9                                                   92                                             92
584972 AZ     school 400897 91339   BASIS Charter Schools, Inc. 40089703376 92030 BASIS Ahwatukee   Regular School Yes Other 04 12 2019   grade_9                                                   46                                             46
584973 AZ     school 400898 91949   BASIS Charter Schools, Inc. 40089803393 91997 BASIS Mesa   Regular School Yes Other KG 12 2019   grade_9                                                   51                                             51
584974 AZ     school 400905 92318   BASIS Charter Schools, Inc. 40090503419 92319 BASIS Oro Valley Primary   Regular School Yes Elementary KG 06 2019   grade_9                                                   *                                              
584975 AZ     school 400903 92320   BASIS Charter Schools, Inc. 40090303418 92321 BASIS Prescott   Regular School Yes Other KG 12 2019   grade_9                                                   36                                             36
584976 AZ     school 400881 92349   BASIS Charter Schools, Inc. 40088103394 92350 BASIS Phoenix Central Primary   Regular School Yes Other KG 12 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
584978 AZ     school 400943 92736   BASIS Charter Schools, Inc. 40094303498 92737 BASIS Goodyear Primary   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                                                   *                                              
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                                                   *                                              
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                                                   *                                              
584982 AZ     school 400963 273398   BASIS Charter Schools, Inc. 40096303558 103670 BASIS Peoria Primary   Regular School Yes Elementary KG 04 2019   grade_9                                                   *                                              
584983 AZ     school 400961 549803   BASIS Charter Schools, Inc. 40096103550 139682 BASIS Phoenix South Primary   Regular School Yes Elementary KG 04 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                                                   *                                              
584985 AZ     school 401080 4481   Beaver Creek Elementary District 40108000059 6116 Beaver Creek School   Regular School No Elementary PK 08 2019   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]);