Data source: Big Local News · About: Big Local

1,975 rows where grade = "grade_7", state = "AZ" and year = 2018

View and edit SQL

year

  • 2018 · 1,875

grade

  • grade_7 · 1,875
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
551351 AZ     school 400680 4406   Amphitheater Unified District 40068001001 5807 Richard B Wilson Jr School   Regular School No Elementary PK 08 2018   grade_7                                                   222                                             222
551352 AZ     school 400680 4406   Amphitheater Unified District 40068000030 5803 Rillito Center   Special Education School No Other PK 12 2018   grade_7                                                   *                                              
551353 AZ     school 400680 4406   Amphitheater Unified District 40068001286 5801 Rio Vista Elementary School   Regular School No Elementary KG 05 2018   grade_7                                                   *                                              
551354 AZ     school 400680 4406   Amphitheater Unified District 40068003517 12976 The Innovation Academy   Regular School No Elementary KG 05 2018   grade_7                                                   *                                              
551355 AZ     school 400680 4406   Amphitheater Unified District 40068000031 5793 Winifred Harelson Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   *                                              
551356 AZ     school 400720 4506   Antelope Union High School District 40072003466 92739 AUHS Online Acadamy   Regular School No High 09 12 2018   grade_7                                                   *                                              
551357 AZ     school 400720 4506   Antelope Union High School District 40072000034 6188 Antelope Union High School   Regular School No High 09 12 2018   grade_7                                                   *                                              
551358 AZ     school 400819 90532   Anthem Preparatory Academy 40081903187 90635 Great Hearts Academies - Anthem Prep   Regular School Yes Other KG 12 2018   grade_7                                                   72                                             72
551359 AZ     school 400750 4178   Apache Elementary District 40075000039 4786 Apache Elementary School   Regular School No Elementary KG 08 2018   grade_7                                                   *                                              
551360 AZ     school 400790 4443   Apache Junction Unified District 40079000043 5925 Apache Junction High School   Regular School No High 09 12 2018   grade_7                                                   *                                              
551361 AZ     school 400790 4443   Apache Junction Unified District 40079000040 5923 Cactus Canyon Junior High   Regular School No Middle 07 08 2018   grade_7                                                   320                                             320
551362 AZ     school 400790 4443   Apache Junction Unified District 40079001461 5922 Desert Vista Elementary School   Regular School No Elementary PK 06 2018   grade_7                                                   *                                              
551363 AZ     school 400790 4443   Apache Junction Unified District 40079000041 5920 Four Peaks Elementary School   Regular School No Elementary PK 06 2018   grade_7                                                   *                                              
551364 AZ     school 400790 4443   Apache Junction Unified District 40079002212 79631 Peralta Trail Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   *                                              
551365 AZ     school 400790 4443   Apache Junction Unified District 40079003333 91810 Superstition Mountain On-Line School   Regular School No High 07 12 2018   grade_7                                                   *                                              
551366 AZ     school 400318 79426   Aprender Tucson 40031802203 79432 Southside Community School   Regular School Yes Other KG 09 2018   grade_7                                                   33                                             33
551367 AZ     school 400834 90917   Archway Classical Academy Chandler 40083403244 90999 Great Hearts Academies - Archway Chandler   Regular School Yes Other KG 12 2018   grade_7                                                   *                                              
551368 AZ     school 400886 92314   Archway Classical Academy Cicero 40088603407 92315 Great Hearts Academies - Archway Cicero   Regular School Yes Elementary KG 07 2018   grade_7                                                   *                                              
551369 AZ     school 400866 91878   Archway Classical Academy Glendale 40086603356 91879 Great Hearts Academies - Archway Glendale   Regular School Yes Elementary KG 05 2018   grade_7                                                   *                                              
551370 AZ     school 400925 92656   Archway Classical Academy Lincoln 40092503464 92708 Great Hearts Academies - Archway Lincoln   Regular School Yes Elementary KG 05 2018   grade_7                                                   *                                              
551371 AZ     school 400873 91758   Archway Classical Academy North Phoenix 40087303353 91785 Great Hearts Academies - Archway North Phoenix   Regular School Yes Elementary KG 06 2018   grade_7                                                   *                                              
551372 AZ     school 400841 90857   Archway Classical Academy Scottsdale 40084103259 90994 Great Hearts Academies - Archway Scottsdale   Regular School Yes Other KG 12 2018   grade_7                                                   *                                              
551373 AZ     school 400930 92704   Archway Classical Academy Trivium East 40093003462 92707 Great Hearts Academies - Archway Trivium East   Regular School Yes Elementary KG 05 2018   grade_7                                                   *                                              
551374 AZ     school 400832 90915   Archway Classical Academy Trivium West 40083203290 91001 Great Hearts Academies - Archway Trivium West   Regular School Yes Other KG 12 2018   grade_7                                                   *                                              
551375 AZ     school 400833 90916   Archway Classical Academy Veritas 40083303283 91000 Great Hearts Academies - Archway Veritas   Regular School Yes Other KG 12 2018   grade_7                                                   *                                              
551376 AZ     school 400757 89486   Arete Preparatory Academy 40075702820 89487 Great Hearts Academies - Arete Prep   Regular School Yes High 06 12 2018   grade_7                                                   98                                             98
551377 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 2018   grade_7                                                   *                                              
551378 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_7                                                   *                                              
551379 AZ     school 400106 4331   Arizona Agribusiness & Equine Center, Inc. 40010601892 6344 AAEC - Paradise Valley   Regular School Yes High 09 12 2018   grade_7                                                   *                                              
551380 AZ     school 400417 85816   Arizona Agribusiness & Equine Center, Inc. 40041701588 5503 AAEC - SMCC Campus   Regular School Yes High 09 12 2018   grade_7                                                   *                                              
551381 AZ     school 400426 87403   Arizona Agribusiness & Equine Center, Inc. 40042602528 87404 Arizona Agribusiness & Equine Center, Inc. - Red Mountain   Regular School Yes High 09 12 2018   grade_7                                                   *                                              
551382 AZ     school 400828 90779   Arizona Agribusiness & Equine Center, Inc. 40082803199 90780 Arizona Agribusiness & Equine Center - Estrella   Regular School Yes High 09 12 2018   grade_7                                                   *                                              
551383 AZ     school 400838 91131   Arizona Agribusiness & Equine Center, Inc. 40083803243 91132 Arizona Agribusiness & Equine Center, Inc. - Prescott Valley   Regular School Yes High 09 12 2018   grade_7                                                   *                                              
551384 AZ     school 400913 91958   Arizona Autism Charter Schools, Inc. 40091303455 92598 Arizona Autism Charter School   Regular School Yes Elementary KG 06 2018   grade_7                                                   *                                              
551385 AZ     school 400913 91958   Arizona Autism Charter Schools, Inc. 40091303512 92984 Arizona Autism Charter School, Upper School Campus   Regular School Yes Middle 05 08 2018   grade_7                                                   24                                             24
551386 AZ     school 400057 4346   Arizona Call-a-Teen Youth Resources, Inc. 40005700784 5520 Arizona Call-a-Teen Center for Excellence   Regular School Yes High 09 12 2018   grade_7                                                   *                                              
551387 AZ     school 400361 79947   Arizona Community Development Corporation 40036102299 79950 La Paloma Academy   Regular School Yes Elementary KG 08 2018   grade_7                                                   73                                             73
551388 AZ     school 400361 79947   Arizona Community Development Corporation 40036103165 81187 La Paloma Academy (Lakeside)   Regular School Yes Elementary KG 08 2018   grade_7                                                   68                                             68
551389 AZ     school 400361 79947   Arizona Community Development Corporation 40036103312 91805 La Paloma Academy-South   Regular School Yes Elementary KG 08 2018   grade_7                                                   45                                             45
551390 AZ     school 400427 87407   Arizona Connections Academy Charter School, Inc. 40042703160 81179 Arizona Connections Academy   Regular School Yes Other KG 12 2018   grade_7                                                   213                                             213
551391 AZ     school 400827 90758   Arizona Education Solutions 40082703252 91184 Valiant Academy   Regular School Yes Elementary KG 08 2018   grade_7                                                   14                                             14
551392 AZ     school 400827 90758   Arizona Education Solutions 40082703309 91246 Valiant Academy   Regular School Yes Other KG 12 2018   grade_7                                                   *                                              
551393 AZ     school 400918 92566   Arizona Language Preparatory 40091803426 92567 Arizona Language Preparatory   Regular School Yes Elementary KG 06 2018   grade_7                                                   *                                              
551394 AZ     school 400415 85749   Arizona Montessori Charter School at Anthem 40041502414 85750 AMCS at Anthem dba Caurus Academy   Regular School Yes Elementary KG 08 2018   grade_7                                                   31                                             31
551395 AZ     school 400056 4345   Arizona School For The Arts 40005600781 5519 Arizona School For The Arts   Regular School Yes High 05 12 2018   grade_7                                                   112                                             112
551396 AZ     school 400840 4274   Arlington Elementary District 40084000044 5354 Arlington Elementary School   Regular School No Elementary PK 08 2018   grade_7                                                   32                                             32
551397 AZ     school 400870 4187   Ash Creek Elementary District 40087000046 4797 Ash Creek Elementary   Regular School No Elementary PK 08 2018   grade_7                                                   *                                              
551398 AZ     school 400910 4471   Ash Fork Joint Unified District 40091000047 6101 Ash Fork Elementary School   Regular School No Elementary KG 05 2018   grade_7                                                   *                                              
551399 AZ     school 400910 4471   Ash Fork Joint Unified District 40091000048 6103 Ash Fork High School   Regular School No High 09 12 2018   grade_7                                                   *                                              
551400 AZ     school 400910 4471   Ash Fork Joint Unified District 40091001059 6102 Ash Fork Middle School   Regular School No Middle 06 08 2018   grade_7                                                   18                                             18
551401 AZ     school 400960 4272   Avondale Elementary District 40096003387 91985 Avondale Middle School   Regular School No Middle 06 08 2018   grade_7                                                   150                                             150
551402 AZ     school 400960 4272   Avondale Elementary District 40096002494 87619 Centerra Mirage STEM Academy   Regular School No Elementary PK 08 2018   grade_7                                                   62                                             62
551403 AZ     school 400960 4272   Avondale Elementary District 40096002880 90028 Copper Trails   Regular School No Elementary PK 08 2018   grade_7                                                   113                                             113
551404 AZ     school 400960 4272   Avondale Elementary District 40096002255 79670 Desert Star   Regular School No Elementary KG 08 2018   grade_7                                                   80                                             80
551405 AZ     school 400960 4272   Avondale Elementary District 40096002381 79792 Desert Thunder   Regular School No Elementary PK 08 2018   grade_7                                                   96                                             96
551406 AZ     school 400960 4272   Avondale Elementary District 40096001154 5348 Eliseo C. Felix School   Regular School No Elementary 02 05 2018   grade_7                                                   *                                              
551407 AZ     school 400960 4272   Avondale Elementary District 40096000051 5349 Lattie Coor   Regular School No Elementary PK 02 2018   grade_7                                                   *                                              
551408 AZ     school 400960 4272   Avondale Elementary District 40096000049 5347 Michael Anderson   Regular School No Elementary PK 08 2018   grade_7                                                   80                                             80
551409 AZ     school 400960 4272   Avondale Elementary District 40096001878 78924 Wildflower School   Regular School No Elementary PK 08 2018   grade_7                                                   59                                             59
551410 AZ     school 400394 79929   Avondale Learning dba Precision Academy 40039402323 80006 Precision Academy   Regular School Yes High 09 12 2018   grade_7                                                   *                                              
551411 AZ     school 400094 4508   Az-Tec High School 40009401109 6192 AZTEC High School   Regular School Yes High 09 12 2018   grade_7                                                   *                                              
551412 AZ     school 400134 6361   BASIS Schools, Inc. 40013401786 6065 BASIS Tucson Primary   Regular School Yes Other KG 12 2018   grade_7                                                   *                                              
551413 AZ     school 400608 81078   BASIS Schools, Inc. 40060803115 81079 BASIS Scottsdale   Regular School Yes Other 04 12 2018   grade_7                                                   167                                             167
551414 AZ     school 400818 90508   BASIS Schools, Inc. 40081803197 90509 BASIS Oro Valley   Regular School Yes High 05 12 2018   grade_7                                                   121                                             121
551415 AZ     school 400829 90841   BASIS Schools, Inc. 40082903278 91055 BASIS Peoria   Regular School Yes High 05 12 2018   grade_7                                                   153                                             153
551416 AZ     school 400830 90842   BASIS Schools, Inc. 40083003253 91056 BASIS Chandler   Regular School Yes High 05 12 2018   grade_7                                                   157                                             157
551417 AZ     school 400831 90862   BASIS Schools, Inc. 40083103196 90863 BASIS Flagstaff   Regular School Yes Other 03 12 2018   grade_7                                                   80                                             80
551418 AZ     school 400843 91280   BASIS Schools, Inc. 40084303351 91343 BASIS Phoenix   Regular School Yes High 05 12 2018   grade_7                                                   124                                             124
551419 AZ     school 400878 91309   BASIS Schools, Inc. 40087803350 91766 BASIS Tucson North   Regular School Yes High 05 12 2018   grade_7                                                   145                                             145
551420 AZ     school 400897 91339   BASIS Schools, Inc. 40089703376 92030 BASIS Ahwatukee   Regular School Yes Other 03 12 2018   grade_7                                                   133                                             133
551421 AZ     school 400898 91949   BASIS Schools, Inc. 40089803393 91997 BASIS Mesa   Regular School Yes Other 03 12 2018   grade_7                                                   109                                             109
551422 AZ     school 400905 92318   BASIS Schools, Inc. 40090503419 92319 BASIS Oro Valley Primary   Regular School Yes Elementary KG 06 2018   grade_7                                                   *                                              
551423 AZ     school 400903 92320   BASIS Schools, Inc. 40090303418 92321 BASIS Prescott   Regular School Yes Other KG 12 2018   grade_7                                                   80                                             80
551424 AZ     school 400881 92349   BASIS Schools, Inc. 40088103394 92350 BASIS Phoenix Central Primary   Regular School Yes Other KG 12 2018   grade_7                                                   36                                             36
551425 AZ     school 400941 92734   BASIS Schools, Inc. 40094103502 92735 BASIS Goodyear   Regular School Yes Middle 05 10 2018   grade_7                                                   66                                             66
551426 AZ     school 400943 92736   BASIS Schools, Inc. 40094303498 92737 BASIS Goodyear Primary   Regular School Yes Elementary KG 05 2018   grade_7                                                   *                                              
551427 AZ     school 400937 92863   BASIS Schools, Inc. 40093703482 92864 BASIS Scottsdale Primary   Regular School Yes Elementary KG 05 2018   grade_7                                                   *                                              
551428 AZ     school 400936 92865   BASIS Schools, Inc. 40093603484 92866 BASIS Chandler Primary- South Campus   Regular School Yes Elementary KG 05 2018   grade_7                                                   *                                              
551429 AZ     school 400958 92997   BASIS Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2018   grade_7                                                   *                                              
551430 AZ     school 400963 273398   BASIS Schools, Inc. 40096303558 103670 BASIS Peoria Primary   Regular School Yes Elementary KG 04 2018   grade_7                                                   *                                              
551431 AZ     school 400961 549803   BASIS Schools, Inc. 40096103550 139682 BASIS Phoenix South Primary   Regular School Yes Elementary KG 02 2018   grade_7                                                   *                                              
551432 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003222 90822 Alternative High School (Indian Oasis High School)   Regular School No High 09 12 2018   grade_7                                                   *                                              
551433 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003210 90821 Alternative Middle School (Indian Oasis Middle School)   Regular School No Middle 06 08 2018   grade_7                                                   *                                              
551434 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000310 5847 Baboquivari High School   Regular School No High 09 12 2018   grade_7                                                   *                                              
551435 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000311 5846 Baboquivari Middle School   Regular School No Middle 07 08 2018   grade_7                                                   85                                             85
551436 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003566 948673 Indian Oasis Intermediate Elementary School   Regular School No Middle 04 06 2018   grade_7                                                   *                                              
551437 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000312 5844 Indian Oasis Primary Elementary School   Regular School No Elementary PK 03 2018   grade_7                                                   *                                              
551438 AZ     school 401000 4468   Bagdad Unified District 40100000052 6088 Bagdad Elementary School   Regular School No Elementary PK 05 2018   grade_7                                                   *                                              
551439 AZ     school 401000 4468   Bagdad Unified District 40100000053 6089 Bagdad Middle / Senior High School   Regular School No High 06 12 2018   grade_7                                                   38                                             38
551440 AZ     school 400184 79204   Ball Charter Schools (Dobson) 40018401713 10729 Dobson Academy, The - A Ball Charter School   Regular School Yes Elementary KG 08 2018   grade_7                                                   33                                             33
551441 AZ     school 400100 4294   Ball Charter Schools (Hearn) 40010001714 10730 Hearn Academy, The - A Ball Charter School   Regular School Yes Elementary KG 08 2018   grade_7                                                   62                                             62
551442 AZ     school 400867 90885   Ball Charter Schools (Val Vista) 40086703342 91791 Ball Charter Schools (Val Vista)   Regular School Yes Elementary KG 08 2018   grade_7                                                   27                                             27
551443 AZ     school 401050 4268   Balsz Elementary District 40105000054 5319 Balsz Elementary School   Regular School No Elementary PK 08 2018   grade_7                                                   194                                             194
551444 AZ     school 401050 4268   Balsz Elementary District 40105003142 81141 Brunson-Lee Elementary School   Regular School No Elementary PK 06 2018   grade_7                                                   *                                              
551445 AZ     school 401050 4268   Balsz Elementary District 40105000055 5320 David Crockett Elementary School   Regular School No Elementary PK 06 2018   grade_7                                                   *                                              
551446 AZ     school 401050 4268   Balsz Elementary District 40105000056 5321 Griffith Elementary School   Regular School No Elementary PK 08 2018   grade_7                                                   *                                              
551447 AZ     school 401080 4481   Beaver Creek Elementary District 40108000059 6116 Beaver Creek School   Regular School No Elementary PK 08 2018   grade_7                                                   39                                             39
551448 AZ     school 400374 79983   Bell Canyon Charter School, Inc 40037402169 79507 Imagine Bell Canyon   Regular School Yes Elementary KG 08 2018   grade_7                                                   37                                             37
551449 AZ     school 400181 10972   Benchmark School, Inc. 40018101889 78803 Benchmark School   Regular School Yes Elementary KG 06 2018   grade_7                                                   *                                              
551450 AZ     school 400065 4355   Benjamin Franklin Charter School 40006501599 5537 Benjamin Franklin Charter School - Crismon   Regular School Yes Elementary KG 06 2018   grade_7                                                   *                                              

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