Data source: Big Local News · About: Big Local

29,625 rows where state = "AZ" and year = 2018 sorted by ccd_school_lvl descending

View and edit SQL

grade

year

  • 2018 · 29,625
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
536036 AZ     school 400877 91277   Empower College Prep 40087703522 92975 Empower Collegiate Academy   Regular School Yes Secondary 08 10 2018   pre_kindergarten                                                   *                                              
536237 AZ     school 400966 92982   Highland Prep 40096603572 703390 Highland Prep   Regular School Yes Secondary 09 09 2018   pre_kindergarten                                                   *                                              
538011 AZ     school 400877 91277   Empower College Prep 40087703522 92975 Empower Collegiate Academy   Regular School Yes Secondary 08 10 2018   kindergarten                                                   *                                              
538212 AZ     school 400966 92982   Highland Prep 40096603572 703390 Highland Prep   Regular School Yes Secondary 09 09 2018   kindergarten                                                   *                                              
539986 AZ     school 400877 91277   Empower College Prep 40087703522 92975 Empower Collegiate Academy   Regular School Yes Secondary 08 10 2018   grade_1                                                   *                                              
540187 AZ     school 400966 92982   Highland Prep 40096603572 703390 Highland Prep   Regular School Yes Secondary 09 09 2018   grade_1                                                   *                                              
541961 AZ     school 400877 91277   Empower College Prep 40087703522 92975 Empower Collegiate Academy   Regular School Yes Secondary 08 10 2018   grade_2                                                   *                                              
542162 AZ     school 400966 92982   Highland Prep 40096603572 703390 Highland Prep   Regular School Yes Secondary 09 09 2018   grade_2                                                   *                                              
543936 AZ     school 400877 91277   Empower College Prep 40087703522 92975 Empower Collegiate Academy   Regular School Yes Secondary 08 10 2018   grade_3                                                   *                                              
544137 AZ     school 400966 92982   Highland Prep 40096603572 703390 Highland Prep   Regular School Yes Secondary 09 09 2018   grade_3                                                   *                                              
545911 AZ     school 400877 91277   Empower College Prep 40087703522 92975 Empower Collegiate Academy   Regular School Yes Secondary 08 10 2018   grade_4                                                   *                                              
546112 AZ     school 400966 92982   Highland Prep 40096603572 703390 Highland Prep   Regular School Yes Secondary 09 09 2018   grade_4                                                   *                                              
547886 AZ     school 400877 91277   Empower College Prep 40087703522 92975 Empower Collegiate Academy   Regular School Yes Secondary 08 10 2018   grade_5                                                   *                                              
548087 AZ     school 400966 92982   Highland Prep 40096603572 703390 Highland Prep   Regular School Yes Secondary 09 09 2018   grade_5                                                   *                                              
549861 AZ     school 400877 91277   Empower College Prep 40087703522 92975 Empower Collegiate Academy   Regular School Yes Secondary 08 10 2018   grade_6                                                   *                                              
550062 AZ     school 400966 92982   Highland Prep 40096603572 703390 Highland Prep   Regular School Yes Secondary 09 09 2018   grade_6                                                   *                                              
551836 AZ     school 400877 91277   Empower College Prep 40087703522 92975 Empower Collegiate Academy   Regular School Yes Secondary 08 10 2018   grade_7                                                   *                                              
552037 AZ     school 400966 92982   Highland Prep 40096603572 703390 Highland Prep   Regular School Yes Secondary 09 09 2018   grade_7                                                   *                                              
553811 AZ     school 400877 91277   Empower College Prep 40087703522 92975 Empower Collegiate Academy   Regular School Yes Secondary 08 10 2018   grade_8                                                   110                                             110
554012 AZ     school 400966 92982   Highland Prep 40096603572 703390 Highland Prep   Regular School Yes Secondary 09 09 2018   grade_8                                                   *                                              
555786 AZ     school 400877 91277   Empower College Prep 40087703522 92975 Empower Collegiate Academy   Regular School Yes Secondary 08 10 2018   grade_9                                                   92                                             92
555987 AZ     school 400966 92982   Highland Prep 40096603572 703390 Highland Prep   Regular School Yes Secondary 09 09 2018   grade_9                                                   75                                             75
557761 AZ     school 400877 91277   Empower College Prep 40087703522 92975 Empower Collegiate Academy   Regular School Yes Secondary 08 10 2018   grade_10                                                   88                                             88
557962 AZ     school 400966 92982   Highland Prep 40096603572 703390 Highland Prep   Regular School Yes Secondary 09 09 2018   grade_10                                                   *                                              
559736 AZ     school 400877 91277   Empower College Prep 40087703522 92975 Empower Collegiate Academy   Regular School Yes Secondary 08 10 2018   grade_11                                                   *                                              
559937 AZ     school 400966 92982   Highland Prep 40096603572 703390 Highland Prep   Regular School Yes Secondary 09 09 2018   grade_11                                                   *                                              
561711 AZ     school 400877 91277   Empower College Prep 40087703522 92975 Empower Collegiate Academy   Regular School Yes Secondary 08 10 2018   grade_12                                                   *                                              
561912 AZ     school 400966 92982   Highland Prep 40096603572 703390 Highland Prep   Regular School Yes Secondary 09 09 2018   grade_12                                                   *                                              
563686 AZ     school 400877 91277   Empower College Prep 40087703522 92975 Empower Collegiate Academy   Regular School Yes Secondary 08 10 2018   pk_12_total 11 16 254   * *     *   *   146 144     59             30   290 11 16 254                   146 144     59       30   290
563887 AZ     school 400966 92982   Highland Prep 40096603572 703390 Highland Prep   Regular School Yes Secondary 09 09 2018   pk_12_total 38 * 23   * *     *   *   49 26     *             11   75 38   23                   49 26             11   75
536693 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   24                                             24
538668 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   kindergarten                                                   *                                              
540643 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_1                                                   *                                              
542618 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_2                                                   *                                              
544593 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_3                                                   *                                              
546568 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_4                                                   *                                              
548543 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_5                                                   *                                              
550518 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_6                                                   *                                              
552493 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_7                                                   *                                              
554468 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_8                                                   *                                              
556443 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_9                                                   *                                              
558418 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_10                                                   *                                              
560393 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_11                                                   *                                              
562368 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_12                                                   *                                              
564343 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   pk_12_total 16 * *   * *     *   *   * 14     *             *   24 16                         14                 24
535455 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 Phoenix Collegiate Academy Charter School   Regular School Yes Other PK 12 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                                                   *                                              
535478 AZ     school 400129 6364   Accelerated Elementary and Secondary Schools 40012901790 5891 Accelerated Learning Laboratory   Regular School Yes Other KG 12 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                                                   *                                              
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                                                   *                                              
535531 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203573 509281 American Leadership Academy, Gilbert   Regular School Yes Other KG 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                                                   *                                              
535552 AZ     school 400680 4406   Amphitheater Unified District 40068000030 5803 Rillito Center   Special Education School No Other PK 12 2018   pre_kindergarten                                                   *                                              
535558 AZ     school 400819 90532   Anthem Preparatory Academy 40081903187 90635 Great Hearts Academies - Anthem Prep   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535566 AZ     school 400318 79426   Aprender Tucson 40031802203 79432 Southside Community School   Regular School Yes Other KG 09 2018   pre_kindergarten                                                   *                                              
535567 AZ     school 400834 90917   Archway Classical Academy Chandler 40083403244 90999 Great Hearts Academies - Archway Chandler   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535572 AZ     school 400841 90857   Archway Classical Academy Scottsdale 40084103259 90994 Great Hearts Academies - Archway Scottsdale   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535574 AZ     school 400832 90915   Archway Classical Academy Trivium West 40083203290 91001 Great Hearts Academies - Archway Trivium West   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535575 AZ     school 400833 90916   Archway Classical Academy Veritas 40083303283 91000 Great Hearts Academies - Archway Veritas   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535590 AZ     school 400427 87407   Arizona Connections Academy Charter School, Inc. 40042703160 81179 Arizona Connections Academy   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535592 AZ     school 400827 90758   Arizona Education Solutions 40082703309 91246 Valiant Academy   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535612 AZ     school 400134 6361   BASIS Schools, Inc. 40013401786 6065 BASIS Tucson Primary   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535613 AZ     school 400608 81078   BASIS Schools, Inc. 40060803115 81079 BASIS Scottsdale   Regular School Yes Other 04 12 2018   pre_kindergarten                                                   *                                              
535617 AZ     school 400831 90862   BASIS Schools, Inc. 40083103196 90863 BASIS Flagstaff   Regular School Yes Other 03 12 2018   pre_kindergarten                                                   *                                              
535620 AZ     school 400897 91339   BASIS Schools, Inc. 40089703376 92030 BASIS Ahwatukee   Regular School Yes Other 03 12 2018   pre_kindergarten                                                   *                                              
535621 AZ     school 400898 91949   BASIS Schools, Inc. 40089803393 91997 BASIS Mesa   Regular School Yes Other 03 12 2018   pre_kindergarten                                                   *                                              
535623 AZ     school 400903 92320   BASIS Schools, Inc. 40090303418 92321 BASIS Prescott   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535624 AZ     school 400881 92349   BASIS Schools, Inc. 40088103394 92350 BASIS Phoenix Central Primary   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535664 AZ     school 401230 4231   Blue Elementary District 40123000069 4908 Blue Elementary School   Regular School No Other KG 12 2018   pre_kindergarten                                                   *                                              
535695 AZ     school 400397 79971   CAFA, Inc. dba Learning Foundation Performing Arts School 40039703119 81102 Learning Foundation   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535782 AZ     school 400440 88299   Chandler Preparatory Academy 40044002681 88300 Great Hearts Academies - Chandler Prep   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535839 AZ     school 400402 5186   Cholla Academy 40040201860 10801 Westland School   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535840 AZ     school 400402 5186   Cholla Academy 40040203429 92637 Westland School Brighton Campus   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535843 AZ     school 400632 81027   Cochise Community Development Corporation 40063203105 81028 Berean Academy   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535846 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention Education Program   Regular School No Other 04 12 2018   pre_kindergarten                                                   *                                              
535851 AZ     school 400021 4370   Colorado City Unified District 40002101276 5567 El Capitan Public School   Regular School No Other 04 12 2018   pre_kindergarten                                                   *                                              
535873 AZ     school 400429 79074   Country Gardens Charter Schools 40042901994 79102 Country Gardens Charter School   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535898 AZ     school 400778 89917   Daisy Education Corporation dba Paragon Science Academy 40077802902 89918 Paragon Science Academy   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535899 AZ     school 400223 79049   Daisy Education Corporation dba Sonoran Science Academy 40022302199 79127 Sonoran Science Academy - Tucson   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535900 AZ     school 400776 89914   Daisy Education Corporation dba Sonoran Science Academy - Phoenix 40077602387 80974 Sonoran Science Academy - Phoenix   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535903 AZ     school 400822 90541   Daisy Education Corporation dba. Sonoran Science Academy Peoria 40082203221 90639 Sonoran Science Academy-Peoria   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535942 AZ     school 407750 4246   Deer Valley Unified District 40775003454 92525 Vista Peak   Regular School No Other PK 12 2018   pre_kindergarten                                                   *                                              
536013 AZ     school 400157 4329   Edkey, Inc. - Sequoia Choice Schools 40015703046 90322 Edkey, Inc. - Sequoia Choice Precision School   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
536014 AZ     school 400157 4329   Edkey, Inc. - Sequoia Choice Schools 40015701728 5500 Sequoia Choice School Arizona Distance Learning School   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
536015 AZ     school 400904 92226   Edkey, Inc. - Sequoia Pathway Academy 40090403048 90377 Sequoia Pathway Academy   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
536016 AZ     school 400641 81052   Edkey, Inc. - Sequoia Ranch School 40064102881 89920 Children First Leadership Academy   Regular School Yes Other KG 09 2018   pre_kindergarten                                                   *                                              
536017 AZ     school 400640 81050   Edkey, Inc. - Sequoia School for the Deaf and Hard of Hearing 40064002031 79219 Edkey, Inc. - Sequoia Deaf School   Special Education School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
536018 AZ     school 400640 81050   Edkey, Inc. - Sequoia School for the Deaf and Hard of Hearing 40064003569 920316 KELLY   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
536027 AZ     school 400746 89412   Eduprize Schools, LLC 40074600717 5479 EDUPRIZE SCHOOL Gilbert   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
536066 AZ     school 402920 4437   Florence Unified School District 40292002637 88400 Anthem Elementary School   Regular School No Other PK 09 2018   pre_kindergarten                                                   12                                             12
536072 AZ     school 402920 4437   Florence Unified School District 40292003389 92280 Mountain Vista Academy   Regular School No Other PK 12 2018   pre_kindergarten                                                   44                                             44
536077 AZ     school 402920 4437   Florence Unified School District 40292002987 90393 Summit School   Regular School No Other KG 12 2018   pre_kindergarten                                                   *                                              
536089 AZ     school 400036 4309   Foothills Academy 40003600709 5474 Foothills Academy   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
536135 AZ     school 400419 87600   Gila County Regional School District 40041902897 90038 Biyaagozhoo Center   Regular School No Other 03 12 2018   pre_kindergarten                                                   *                                              
536209 AZ     school 402480 4217   Graham County Special Services 40248001210 4879 Dan Hinton Accommodation School   Special Education School No Other PK 12 2018   pre_kindergarten                                                   46                                             46
536220 AZ     school 400282 79501   Harvest Power Community Development Group, Inc. 40028202232 79513 Harvest Preparatory Academy   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
536289 AZ     school 400650 5174   Integrity Education Incorporated 40065001846 10811 Integrity Education Centre   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
536337 AZ     school 400165 10878   Keystone Montessori Charter School, Inc. 40016501755 10884 Keystone Montessori Charter School   Regular School Yes Other 01 09 2018   pre_kindergarten                                                   *                                              
536405 AZ     school 400927 92610   Legacy Traditional Charter School 40092703190 90534 Legacy Traditional School - Queen Creek   Regular School Yes Other KG 09 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]);