Data source: Big Local News · About: Big Local

127,680 rows where state = "AZ"

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
64374 AZ     school 401050 4268   Balsz Elementary District 40105000056 5321 Griffith Elementary School   Regular School No Elementary KG 05 2021   pre_kindergarten                                                   *                                              
64375 AZ     school 401050 4268   Balsz Elementary District 40105003374 92301 Orangedale Early Learning Center   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten                                                   26                                             26
64376 AZ     school 401050 4268   Balsz Elementary District 40105000054 5319 Pat Tillman Middle School   Regular School No Middle 06 08 2021   pre_kindergarten                                                   *                                              
64377 AZ     school   7340   Banner Children's Academy of Education & Development   7341 Banner Academy             2021   pre_kindergarten                                                   *                                              
64378 AZ     school 400897 91339   BASIS Charter Schools, Inc. 40089703376 92030 BASIS Ahwatukee   Regular School Yes Other 04 12 2021   pre_kindergarten                                                   *                                              
64379 AZ     school 400830 90842   BASIS Charter Schools, Inc. 40083003253 91056 BASIS Chandler   Regular School Yes High 05 12 2021   pre_kindergarten                                                   *                                              
64380 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2021   pre_kindergarten                                                   *                                              
64381 AZ     school 400936 92865   BASIS Charter Schools, Inc. 40093603484 92866 BASIS Chandler Primary- South Campus   Regular School Yes Elementary KG 05 2021   pre_kindergarten                                                   *                                              
64382 AZ     school 400831 90862   BASIS Charter Schools, Inc. 40083103196 90863 BASIS Flagstaff   Regular School Yes Other KG 12 2021   pre_kindergarten                                                   *                                              
64383 AZ     school 400941 92734   BASIS Charter Schools, Inc. 40094103502 92735 BASIS Goodyear   Regular School Yes High 05 12 2021   pre_kindergarten                                                   *                                              
64384 AZ     school 400943 92736   BASIS Charter Schools, Inc. 40094303498 92737 BASIS Goodyear Primary   Regular School Yes Elementary KG 05 2021   pre_kindergarten                                                   *                                              
64385 AZ     school 400898 91949   BASIS Charter Schools, Inc. 40089803393 91997 BASIS Mesa   Regular School Yes Other KG 12 2021   pre_kindergarten                                                   *                                              
64386 AZ     school 400818 90508   BASIS Charter Schools, Inc. 40081803197 90509 BASIS Oro Valley   Regular School Yes High 05 12 2021   pre_kindergarten                                                   *                                              
64387 AZ     school 400905 92318   BASIS Charter Schools, Inc. 40090503419 92319 BASIS Oro Valley Primary   Regular School Yes Elementary KG 06 2021   pre_kindergarten                                                   *                                              
64388 AZ     school 400829 90841   BASIS Charter Schools, Inc. 40082903278 91055 BASIS Peoria   Regular School Yes High 05 12 2021   pre_kindergarten                                                   *                                              
64389 AZ     school 400963 273398   BASIS Charter Schools, Inc. 40096303558 103670 BASIS Peoria Primary   Regular School Yes Elementary KG 04 2021   pre_kindergarten                                                   *                                              
64390 AZ     school 400843 91280   BASIS Charter Schools, Inc. 40084303351 91343 BASIS Phoenix   Regular School Yes High 05 12 2021   pre_kindergarten                                                   *                                              
64391 AZ     school 400881 92349   BASIS Charter Schools, Inc. 40088103394 92350 BASIS Phoenix Central Primary   Regular School Yes Elementary KG 05 2021   pre_kindergarten                                                   *                                              
64392 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2021   pre_kindergarten                                                   *                                              
64393 AZ     school 400961 549803   BASIS Charter Schools, Inc. 40096103550 139682 BASIS Phoenix South Primary   Regular School Yes Elementary KG 05 2021   pre_kindergarten                                                   *                                              
64394 AZ     school 400903 92320   BASIS Charter Schools, Inc. 40090303418 92321 BASIS Prescott   Regular School Yes Other KG 12 2021   pre_kindergarten                                                   *                                              
64395 AZ     school 400608 81078   BASIS Charter Schools, Inc. 40060803115 81079 BASIS Scottsdale   Regular School Yes Other 04 12 2021   pre_kindergarten                                                   *                                              
64396 AZ     school 400937 92863   BASIS Charter Schools, Inc. 40093703482 92864 BASIS Scottsdale Primary - East Campus   Regular School Yes Elementary KG 04 2021   pre_kindergarten                                                   *                                              
64397 AZ     school 400980 783027   BASIS Charter Schools, Inc. 40098003607 893297 BASIS Scottsdale Primary - West Campus   Regular School Yes Elementary KG 04 2021   pre_kindergarten                                                   *                                              
64398 AZ     school 400878 91309   BASIS Charter Schools, Inc. 40087803350 91766 BASIS Tucson North   Regular School Yes High 05 12 2021   pre_kindergarten                                                   *                                              
64399 AZ     school 400134 6361   BASIS Charter Schools, Inc. 40013401786 6065 BASIS Tucson Primary   Regular School Yes Other KG 12 2021   pre_kindergarten                                                   *                                              
64400 AZ     school 401080 4481   Beaver Creek Elementary District 40108000059 6116 Beaver Creek School   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   11                                             11
64401 AZ     school 400374 79983   Bell Canyon Charter School, Inc 40037402169 79507 Imagine Bell Canyon   Regular School Yes Elementary KG 08 2021   pre_kindergarten                                                   *                                              
64402 AZ     school 400181 10972   Benchmark School, Inc. 40018101889 78803 Benchmark School   Regular School Yes Elementary KG 06 2021   pre_kindergarten                                                   *                                              
64403 AZ     school 400065 4355   Benjamin Franklin Charter School - Queen Creek 40006501599 5537 Benjamin Franklin Charter School - Crismon   Regular School Yes Elementary KG 06 2021   pre_kindergarten                                                   *                                              
64404 AZ     school 400065 4355   Benjamin Franklin Charter School - Queen Creek 40006501600 5538 Benjamin Franklin Charter School - Gilbert   Regular School Yes Elementary KG 06 2021   pre_kindergarten                                                   *                                              
64405 AZ     school 400065 4355   Benjamin Franklin Charter School - Queen Creek 40006502685 88341 Benjamin Franklin Charter School - Power   Regular School Yes Elementary KG 06 2021   pre_kindergarten                                                   *                                              
64406 AZ     school 400065 4355   Benjamin Franklin Charter School - Queen Creek 40006503395 92270 Benjamin Franklin High School   Regular School Yes High 07 12 2021   pre_kindergarten                                                   *                                              
64407 AZ     school 400212 79226   Benson Unified School District 40021202444 85879 Benson Digital Learning Center   Alternative School No High 09 12 2021   pre_kindergarten                                                   *                                              
64408 AZ     school 400212 79226   Benson Unified School District 40021203232 90775 Benson Digital Learning Center Online   Regular School No Other KG 12 2021   pre_kindergarten                                                   *                                              
64409 AZ     school 400212 79226   Benson Unified School District 40021200061 4799 Benson High School   Regular School No High 09 12 2021   pre_kindergarten                                                   *                                              
64410 AZ     school 400212 79226   Benson Unified School District 40021201120 4794 Benson Middle School   Regular School No Middle 05 08 2021   pre_kindergarten                                                   *                                              
64411 AZ     school 400212 79226   Benson Unified School District 40021200060 4793 Benson Primary School   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   12                                             12
64412 AZ     school 401160 4515   Bicentennial Union High School District 40116000062 6203 Salome High School   Regular School No High 09 12 2021   pre_kindergarten                                                   *                                              
64413 AZ     school 401180 4169   Bisbee Unified District 40118000063 4754 Bisbee High School   Regular School No High 09 12 2021   pre_kindergarten                                                   *                                              
64414 AZ     school 401180 4169   Bisbee Unified District 40118000066 4752 Greenway Primary School   Regular School No Elementary KG 05 2021   pre_kindergarten                                                   *                                              
64415 AZ     school 401180 4169   Bisbee Unified District 40118000064 4753 Lowell School   Regular School No Middle 06 08 2021   pre_kindergarten                                                   *                                              
64416 AZ     school 400771 89871   Blue Adobe Project 40077102899 89872 Sky Islands   Regular School Yes High 09 12 2021   pre_kindergarten                                                   *                                              
64417 AZ     school 401230 4231   Blue Elementary District 40123000069 4908 Blue Elementary School   Regular School No Other KG 12 2021   pre_kindergarten                                                   *                                              
64418 AZ     school 406580 4397   Blue Ridge Unified School District No. 32 40658000560 5645 Blue Ridge Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   18                                             18
64419 AZ     school 406580 4397   Blue Ridge Unified School District No. 32 40658000561 5648 Blue Ridge High School   Regular School No High 09 12 2021   pre_kindergarten                                                   *                                              
64420 AZ     school 406580 4397   Blue Ridge Unified School District No. 32 40658003564 456092 Blue Ridge High School Online   Regular School No High 09 12 2021   pre_kindergarten                                                   *                                              
64421 AZ     school 406580 4397   Blue Ridge Unified School District No. 32 40658001140 5647 Blue Ridge Jr High School   Regular School No Middle 07 08 2021   pre_kindergarten                                                   *                                              
64422 AZ     school 400636 81041   Blueprint Education 40063603108 81042 Hope High School   Alternative School Yes High 09 12 2021   pre_kindergarten                                                   *                                              
64423 AZ     school 400636 81041   Blueprint Education 40063603163 81182 Hope High School Online   Alternative School Yes High 09 12 2021   pre_kindergarten                                                   *                                              
64424 AZ     school 401260 4224   Bonita Elementary District 40126000070 4896 Bonita Elementary School   Regular School No Elementary KG 08 2021   pre_kindergarten                                                   *                                              
64425 AZ     school 401290 4513   Bouse Elementary District 40129000071 6201 Bouse Elementary School   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   *                                              
64426 AZ     school 401330 4171   Bowie Unified District 40133000072 4758 Bowie Elementary School   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   *                                              
64427 AZ     school 401330 4171   Bowie Unified District 40133000073 4759 Bowie High School   Regular School No High 09 12 2021   pre_kindergarten                                                   *                                              
64428 AZ     school 400033 4305   Boys & Girls Clubs of the East Valley dba Mesa Arts Academy 40003300703 5470 Mesa Arts Academy   Regular School Yes Elementary KG 08 2021   pre_kindergarten                                                   *                                              
64429 AZ     school   92367   Breakthrough Academy   92914 Breakthrough Academy- East Campus             2021   pre_kindergarten                                                   *                                              
64430 AZ     school 400071 4362   Bright Beginnings School, Inc. 40007100832 5550 Bright Beginnings School #1   Regular School Yes Elementary KG 06 2021   pre_kindergarten                                                   *                                              
64431 AZ     school 401380 4269   Buckeye Elementary District 40138003123 81110 Bales Elementary School   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   *                                              
64432 AZ     school 401380 4269   Buckeye Elementary District 40138003694 1001175 BESD Virtual   Regular School No Elementary KG 08 2021   pre_kindergarten                                                   *                                              
64433 AZ     school 401380 4269   Buckeye Elementary District 40138002492 87473 Buckeye Elementary School   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   89                                             89
64434 AZ     school 401380 4269   Buckeye Elementary District 40138003052 90341 Inca Elementary School   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   *                                              
64435 AZ     school 401380 4269   Buckeye Elementary District 40138003575 527220 Marionneaux Elementary School   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   *                                              
64436 AZ     school 401380 4269   Buckeye Elementary District 40138002836 89572 Steven R. Jasinski Elementary School   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   23                                             23
64437 AZ     school 401380 4269   Buckeye Elementary District 40138002490 87471 Sundance Elementary   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   *                                              
64438 AZ     school 401380 4269   Buckeye Elementary District 40138002642 88398 Westpark Elementary School   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   *                                              
64439 AZ     school 401410 4284   Buckeye Union High School District 40141000075 5424 Buckeye Union High School   Regular School No High 09 12 2021   pre_kindergarten                                                   *                                              
64440 AZ     school 401410 4284   Buckeye Union High School District 40141003320 91826 BUHSD Institute of Online Learning   Regular School No High 09 12 2021   pre_kindergarten                                                   *                                              
64441 AZ     school 401410 4284   Buckeye Union High School District 40141002137 79376 Estrella Foothills High School   Regular School No High 09 12 2021   pre_kindergarten                                                   *                                              
64442 AZ     school 401410 4284   Buckeye Union High School District 40141002786 89573 Youngker High School   Regular School No High 09 12 2021   pre_kindergarten                                                   *                                              
64443 AZ     school 401500 4378   Bullhead City School District 40150000085 5587 Bullhead City Middle School   Regular School No Middle 05 08 2021   pre_kindergarten                                                   *                                              
64444 AZ     school 401500 4378   Bullhead City School District 40150000855 5583 Coyote Canyon School   Special Education School No Elementary PK 08 2021   pre_kindergarten                                                   16                                             16
64445 AZ     school 401500 4378   Bullhead City School District 40150001053 5584 Desert Valley School   Regular School No Elementary KG 04 2021   pre_kindergarten                                                   *                                              
64446 AZ     school 401500 4378   Bullhead City School District 40150001528 5585 Diamondback Elementary School   Regular School No Elementary KG 04 2021   pre_kindergarten                                                   *                                              
64447 AZ     school 401500 4378   Bullhead City School District 40150001757 6048 Fox Creek Jr High School   Regular School No Middle 05 08 2021   pre_kindergarten                                                   *                                              
64448 AZ     school 401500 4378   Bullhead City School District 40150002184 79655 Sunrise Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   *                                              
64449 AZ     school 400796 90328   CAFA, Inc. dba Learning Foundation and Performing Arts Alta Mesa 40079602645 88290 Learning Foundation and Performing Arts Alta Mesa   Regular School Yes Elementary KG 08 2021   pre_kindergarten                                                   *                                              
64450 AZ     school 400803 90327   CAFA, Inc. dba Learning Foundation and Performing Arts Gilbert 40080302667 88289 Learning Foundation and Performing Arts Gilbert   Regular School Yes High 07 12 2021   pre_kindergarten                                                   *                                              
64451 AZ     school 400803 90327   CAFA, Inc. dba Learning Foundation and Performing Arts Gilbert 40080303416 92235 Learning Foundation and Performing Arts Warner   Regular School Yes Elementary KG 06 2021   pre_kindergarten                                                   *                                              
64452 AZ     school 400397 79971   CAFA, Inc. dba Learning Foundation Performing Arts School 40039703119 81102 Learning Foundation   Regular School Yes Other KG 12 2021   pre_kindergarten                                                   *                                              
64453 AZ     school 400310 79055   Calibre Academy 40031002370 80463 Calibre Academy Surprise   Regular School Yes Elementary KG 08 2021   pre_kindergarten                                                   *                                              
64454 AZ     school 400182 78888   Cambridge Academy East, Inc 40018201890 78889 Cambridge Academy East   Regular School Yes Elementary KG 06 2021   pre_kindergarten                                                   *                                              
64455 AZ     school 400182 78888   Cambridge Academy East, Inc 40018202964 90325 Cambridge Academy East   Regular School Yes Elementary KG 08 2021   pre_kindergarten                                                   *                                              
64456 AZ     school 400390 79905   Camelback Education, Inc 40039002289 79906 Camelback Academy   Regular School Yes Elementary KG 08 2021   pre_kindergarten                                                   *                                              
64457 AZ     school 401600 4470   Camp Verde Unified District 40160003173 84659 Camp Verde Accommodation School   Regular School No High 06 12 2021   pre_kindergarten                                                   *                                              
64458 AZ     school 401600 4470   Camp Verde Unified District 40160000086 6098 Camp Verde Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   13                                             13
64459 AZ     school 401600 4470   Camp Verde Unified District 40160000087 6100 Camp Verde High School   Regular School No High 09 12 2021   pre_kindergarten                                                   *                                              
64460 AZ     school 401600 4470   Camp Verde Unified District 40160001529 6099 Camp Verde Middle School   Regular School No Middle 06 08 2021   pre_kindergarten                                                   *                                              
64461 AZ     school 401600 4470   Camp Verde Unified District 40160003666 1000257 Camp Verde Online   Regular School No Other KG 12 2021   pre_kindergarten                                                   *                                              
64462 AZ     school 401004 1001161   Candeo Schools, Inc. 40100403672 1000607 Candeo North Scottsdale   Regular School Yes Elementary KG 08 2021   pre_kindergarten                                                   *                                              
64463 AZ     school 400758 89758   Candeo Schools, Inc. 40075802766 89759 Candeo Peoria   Regular School Yes Elementary KG 08 2021   pre_kindergarten                                                   *                                              
64464 AZ     school 401650 4484   Canon Elementary District 40165000088 6119 Canon School   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   *                                              
64465 AZ     school 400633 81029   Canyon Rose Academy, Inc. 40063303106 81030 Canyon Rose Academy   Alternative School Yes High 09 12 2021   pre_kindergarten                                                   *                                              
64466 AZ     school 400633 81029   Canyon Rose Academy, Inc. 40063303536 605648 Canyon Rose Academy-East   Alternative School Yes High 09 12 2021   pre_kindergarten                                                   *                                              
64467 AZ     school 400258 78858   Carden of Tucson, Inc. 40025802079 78859 Carden of Tucson   Regular School Yes Elementary KG 08 2021   pre_kindergarten                                                   *                                              
64468 AZ     school 400077 4400   Career Development, Inc. 40007700943 5652 Northern AZ Academy for Career Dev. - Taylor   Alternative School Yes High 09 12 2021   pre_kindergarten                                                   *                                              
64469 AZ     school 400219 79047   Career Success Schools 40021902338 80050 Career Success School - Sage Campus   Alternative School Yes Elementary KG 08 2021   pre_kindergarten                                                   *                                              
64470 AZ     school 400219 79047   Career Success Schools 40021902328 80025 Career Success Schools - STEM Academy 7-12   Alternative School Yes High 07 12 2021   pre_kindergarten                                                   *                                              
64471 AZ     school 400219 79047   Career Success Schools 40021902367 80430 Robert L. Duffy High School   Alternative School Yes High 07 12 2021   pre_kindergarten                                                   *                                              
64472 AZ     school 400219 79047   Career Success Schools 40021902011 79129 Tech Campus   Alternative School Yes High 09 12 2021   pre_kindergarten                                                   *                                              
64473 AZ     school 400381 80001   Carpe Diem Collegiate High School 40038102319 80002 Desert View Middle & High School   Regular School Yes High 06 12 2021   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]);