Data source: Big Local News · About: Big Local

127,680 rows where state = "AZ" sorted by total

View and edit SQL

grade

year

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total ▼ white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
535451 AZ     school 400328 79457   A Center for Creative Education 40032802228 79458 Verde Valley Montessori School - A Center for Creative Education   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535452 AZ     school 400274 79053   AIBT Non-Profit Charter High School - Phoenix 40027402020 79123 RCB Medical Arts Academy   Regular School Yes High 07 12 2018   pre_kindergarten                                                   *                                              
535453 AZ     school 400970 449790   AIBT Non-Profit Charter High School, Inc. 40097003546 742847 RCB College Preparatory Academy   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535454 AZ     school 400764 89949   ASU Preparatory Academy 40076403051 90271 ASU Preparatory Academy- Phoenix Elementary   Regular School Yes Elementary KG 04 2018   pre_kindergarten                                                   *                                              
535455 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 Phoenix Collegiate Academy Charter School   Regular School Yes Other PK 12 2018   pre_kindergarten                                                   *                                              
535456 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535457 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535458 AZ     school 400857 91307   ASU Preparatory Academy 40085703260 91308 ASU Preparatory Academy-Polytechnic Elementary   Regular School Yes Elementary KG 04 2018   pre_kindergarten                                                   *                                              
535459 AZ     school 400890 92325   ASU Preparatory Academy 40089003367 92326 ASU Preparatory Academy - Phoenix Middle School   Regular School Yes Middle 05 08 2018   pre_kindergarten                                                   *                                              
535460 AZ     school 400884 92327   ASU Preparatory Academy 40088403264 91323 ASU Preparatory Academy-Polytechnic Middle School   Regular School Yes Middle 05 08 2018   pre_kindergarten                                                   *                                              
535461 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 Phoenix Collegiate Academy Elementary, LLC   Regular School Yes Elementary KG 04 2018   pre_kindergarten                                                   *                                              
535462 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 Phoenix Collegiate Academy High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535463 AZ     school 400971 631426   ASU Preparatory Academy 40097103567 338609 ASU Preparatory Academy - Tempe   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535464 AZ     school 400947 92987   ASU Preparatory Academy - Casa Grande 40094703526 635758 ASU Preparatory Academy - Casa Grande HS   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535465 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535466 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Regular School Yes High 07 12 2018   pre_kindergarten                                                   *                                              
535467 AZ     school 400797 90199   Academy Del Sol, Inc. 40079702994 90200 Academy Del Sol   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535468 AZ     school 400797 90199   Academy Del Sol, Inc. 40079703230 90770 Academy Del Sol - Hope   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535469 AZ     school 400128 4296   Academy Of Excellence, Inc. 40012801715 5461 Academy Of Excellence   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535470 AZ     school 400414 85540   Academy of Building Industries, Inc. 40041402412 85541 Academy of Building Industries   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535471 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103399 92197 Academy of Mathematics and Science South   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535472 AZ     school 400368 79961   Academy of Mathematics and Science, Inc. 40036802037 79094 Academy of Math and Science   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535473 AZ     school 400940 92768   Academy of Mathematics and Science, Inc. 40094003499 92769 Academy of Math and Science Camelback   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535474 AZ     school 400202 78897   Academy of Tucson, Inc. 40020203141 81130 Academy of Tucson Elementary School   Regular School Yes Elementary KG 04 2018   pre_kindergarten                                                   *                                              
535475 AZ     school 400202 78897   Academy of Tucson, Inc. 40020201959 78898 Academy of Tucson High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535476 AZ     school 400202 78897   Academy of Tucson, Inc. 40020202312 79986 Academy of Tucson Middle School   Regular School Yes Middle 05 08 2018   pre_kindergarten                                                   *                                              
535477 AZ     school 400276 79213   Academy with Community Partners Inc 40027601841 10795 Academy with Community Partners   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535478 AZ     school 400129 6364   Accelerated Elementary and Secondary Schools 40012901790 5891 Accelerated Learning Laboratory   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535479 AZ     school 400121 4297   Accelerated Learning Center, Inc. 40012101581 5462 Accelerated Learning Center   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535480 AZ     school 400122 4325   Acclaim Charter School 40012201585 5496 ACCLAIM Academy   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535481 AZ     school 400320 79437   Acorn Montessori Charter School 40032002227 79438 Acorn Montessori Charter School   Regular School Yes Middle 02 08 2018   pre_kindergarten                                                   *                                              
535482 AZ     school 400320 79437   Acorn Montessori Charter School 40032002576 88180 Acorn Montessori Charter School, Inc. - West   Regular School Yes Elementary KG 01 2018   pre_kindergarten                                                   *                                              
535483 AZ     school 400450 4289   Agua Fria Union High School District 40045000001 5454 Agua Fria High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535484 AZ     school 400450 4289   Agua Fria Union High School District 40045002273 79799 Desert Edge High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535485 AZ     school 400450 4289   Agua Fria Union High School District 40045001884 78926 Millennium High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535486 AZ     school 400450 4289   Agua Fria Union High School District 40045002592 87903 Verrado High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535487 AZ     school 400480 4249   Aguila Elementary District 40048000002 5187 Aguila Elementary School   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   *                                              
535488 AZ     school 400520 4409   Ajo Unified District 40052000003 5831 Ajo Elementary School   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   *                                              
535489 AZ     school 400520 4409   Ajo Unified District 40052003063 6292 Ajo High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535490 AZ     school 400403 5978   Akimel O Otham Pee Posh Charter School, Inc. 40040301989 10797 Akimel O'Otham Pee Posh (K-2)   Regular School Yes Elementary KG 02 2018   pre_kindergarten                                                   *                                              
535491 AZ     school 400404 78966   Akimel O'Otham Pee Posh Charter School, Inc. 40040401993 78967 Akimel O'Otham Pee Posh (3-5)   Regular School Yes Elementary 03 05 2018   pre_kindergarten                                                   *                                              
535492 AZ     school 400600 4280   Alhambra Elementary District 40060001283 5381 Alhambra Traditional School   Regular School No Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535493 AZ     school 400600 4280   Alhambra Elementary District 40060000302 5382 Andalucia Middle School   Regular School No Middle 04 08 2018   pre_kindergarten                                                   *                                              
535495 AZ     school 400600 4280   Alhambra Elementary District 40060001707 6030 Carol G. Peck Elementary School   Regular School No Elementary KG 03 2018   pre_kindergarten                                                   *                                              
535496 AZ     school 400600 4280   Alhambra Elementary District 40060000009 5385 Catalina Ventura School   Regular School No Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535497 AZ     school 400600 4280   Alhambra Elementary District 40060000010 5386 Cordova Elementary School   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   *                                              
535498 AZ     school 400600 4280   Alhambra Elementary District 40060000012 5387 Granada East School   Regular School No Middle 04 08 2018   pre_kindergarten                                                   *                                              
535499 AZ     school 400600 4280   Alhambra Elementary District 40060001486 5388 Granada Primary School   Regular School No Elementary KG 03 2018   pre_kindergarten                                                   *                                              
535500 AZ     school 400600 4280   Alhambra Elementary District 40060000007 5383 James W. Rice Primary School   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   *                                              
535501 AZ     school 400600 4280   Alhambra Elementary District 40060001418 5389 Montebello School   Regular School No Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535502 AZ     school 400600 4280   Alhambra Elementary District 40060000015 5391 R E Simpson School   Regular School No Middle 04 08 2018   pre_kindergarten                                                   *                                              
535503 AZ     school 400600 4280   Alhambra Elementary District 40060000016 5390 Sevilla Primary School   Regular School No Elementary KG 03 2018   pre_kindergarten                                                   *                                              
535504 AZ     school 400600 4280   Alhambra Elementary District 40060002002 79203 Sevilla West School   Regular School No Middle 04 08 2018   pre_kindergarten                                                   *                                              
535505 AZ     school 400600 4280   Alhambra Elementary District 40060000018 5392 Westwood Primary School   Regular School No Elementary KG 03 2018   pre_kindergarten                                                   *                                              
535506 AZ     school 400396 79969   All Aboard Charter School 40039602306 79970 All Aboard Charter School   Regular School Yes Elementary KG 05 2018   pre_kindergarten                                                   *                                              
535507 AZ     school 400111 4347   Allen-Cochran Enterprises, Inc. 40011101594 5521 Center for Educational Excellence   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535508 AZ     school 400630 4161   Alpine Elementary District 40063000019 4743 Alpine Elementary School   Regular School No Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535509 AZ     school 404770 4418   Altar Valley Elementary District 40477001005 5859 Altar Valley Middle School   Regular School No Middle 05 08 2018   pre_kindergarten                                                   *                                              
535511 AZ     school 400218 79215   American Basic Schools LLC 40021801913 78788 Burke Basic School   Regular School Yes Elementary KG 06 2018   pre_kindergarten                                                   *                                              
535512 AZ     school 400619 80995   American Charter Schools Foundation d.b.a. Alta Vista High School 40061903097 80996 Alta Vista High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535513 AZ     school 400357 79883   American Charter Schools Foundation d.b.a. Apache Trail High School 40035701732 6346 Apache Trail High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535514 AZ     school 400385 79874   American Charter Schools Foundation d.b.a. Crestview College Preparatory High Sc 40038502016 78813 Crestview College Preparatory High School   Regular School Yes High 07 12 2018   pre_kindergarten                                                   *                                              
535515 AZ     school 400384 79872   American Charter Schools Foundation d.b.a. Desert Hills High School 40038401899 78901 Desert Hills High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535516 AZ     school 400352 79873   American Charter Schools Foundation d.b.a. Estrella High School 40035201898 78900 Estrella High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535517 AZ     school 400353 79875   American Charter Schools Foundation d.b.a. Peoria Accelerated High School 40035301896 78817 Peoria Accelerated High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535518 AZ     school 400618 80989   American Charter Schools Foundation d.b.a. South Pointe High School 40061803095 80990 South Pointe High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535519 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 2018   pre_kindergarten                                                   *                                              
535520 AZ     school 400354 79877   American Charter Schools Foundation d.b.a. Sun Valley High School 40035401733 6347 Sun Valley High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535521 AZ     school 400355 79879   American Charter Schools Foundation d.b.a. West Phoenix High School 40035501734 6348 West Phoenix High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535522 AZ     school 400130 6365   American Heritage Academy 40013002569 88201 American Heritage Academy - Camp Verde   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535523 AZ     school 400130 6365   American Heritage Academy 40013001803 6366 American Heritage Academy - Cottonwood   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535524 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203340 91778 ALA Mesa   Regular School Yes Elementary KG 06 2018   pre_kindergarten                                                   *                                              
535525 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203279 91173 ALA San Tan   Regular School Yes Elementary KG 06 2018   pre_kindergarten                                                   *                                              
535526 AZ     school 400112 4348   American Leadership Academy, Inc. 40011201595 5522 American Leadership Academy   Regular School Yes Elementary KG 06 2018   pre_kindergarten                                                   *                                              
535527 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203475 92885 American Leadership Academy - Ironwood   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535528 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203179 90769 American Leadership Academy - Queen Creek   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535529 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203365 92348 American Leadership Academy Anthem South Campus   Regular School Yes Elementary KG 06 2018   pre_kindergarten                                                   *                                              
535530 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203570 242454 American Leadership Academy Signal Butte   Regular School Yes Elementary KG 06 2018   pre_kindergarten                                                   *                                              
535531 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203573 509281 American Leadership Academy, Gilbert   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535532 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203576 865358 American Leadership Academy, Higley   Regular School Yes Elementary KG 06 2018   pre_kindergarten                                                   *                                              
535533 AZ     school 400329 79461   American Virtual Academy 40032903159 81178 Primavera - Online   Regular School Yes High 06 12 2018   pre_kindergarten                                                   *                                              
535534 AZ     school 400680 4406   Amphitheater Unified District 40068003330 91755 Amphi Academy at El Hogar   Regular School No Other KG 12 2018   pre_kindergarten                                                   *                                              
535535 AZ     school 400680 4406   Amphitheater Unified District 40068000032 6055 Amphitheater High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535536 AZ     school 400680 4406   Amphitheater Unified District 40068000020 5805 Amphitheater Middle School   Regular School No Middle 06 08 2018   pre_kindergarten                                                   *                                              
535537 AZ     school 400680 4406   Amphitheater Unified District 40068000033 5808 Canyon Del Oro High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535539 AZ     school 400680 4406   Amphitheater Unified District 40068000021 5799 Coronado K-8 School   Regular School No Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535540 AZ     school 400680 4406   Amphitheater Unified District 40068000023 5796 E C Nash School   Regular School No Elementary KG 05 2018   pre_kindergarten                                                   *                                              
535542 AZ     school 400680 4406   Amphitheater Unified District 40068000026 5795 Helen Keeling Elementary School   Regular School No Elementary KG 05 2018   pre_kindergarten                                                   *                                              
535543 AZ     school 400680 4406   Amphitheater Unified District 40068002198 79378 Ironwood Ridge High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535544 AZ     school 400680 4406   Amphitheater Unified District 40068000027 5797 L M Prince School   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   *                                              
535545 AZ     school 400680 4406   Amphitheater Unified District 40068001525 5804 La Cima Middle School   Regular School No Middle 06 08 2018   pre_kindergarten                                                   *                                              
535546 AZ     school 400680 4406   Amphitheater Unified District 40068000028 5806 Lawrence W Cross Middle School   Regular School No Middle 06 08 2018   pre_kindergarten                                                   *                                              
535549 AZ     school 400680 4406   Amphitheater Unified District 40068001031 5800 Mesa Verde Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   *                                              
535550 AZ     school 400680 4406   Amphitheater Unified District 40068002066 79282 Painted Sky Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   *                                              
535551 AZ     school 400680 4406   Amphitheater Unified District 40068001001 5807 Richard B Wilson Jr School   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   *                                              
535552 AZ     school 400680 4406   Amphitheater Unified District 40068000030 5803 Rillito Center   Special Education School No Other PK 12 2018   pre_kindergarten                                                   *                                              
535553 AZ     school 400680 4406   Amphitheater Unified District 40068001286 5801 Rio Vista Elementary School   Regular School No Elementary KG 05 2018   pre_kindergarten                                                   *                                              
535554 AZ     school 400680 4406   Amphitheater Unified District 40068003517 12976 The Innovation Academy   Regular School No Elementary KG 05 2018   pre_kindergarten                                                   *                                              
535555 AZ     school 400680 4406   Amphitheater Unified District 40068000031 5793 Winifred Harelson Elementary School   Regular School No Elementary KG 06 2018   pre_kindergarten                                                   *                                              
535556 AZ     school 400720 4506   Antelope Union High School District 40072003466 92739 AUHS Online Acadamy   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              

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