enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
535551 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 535552 AZ     school 400680 4406   Amphitheater Unified District 40068000030 5803 Rillito Center   Special Education School No Other PK 12 2018   pre_kindergarten                                                   *                                              
535553 535553 AZ     school 400680 4406   Amphitheater Unified District 40068001286 5801 Rio Vista Elementary School   Regular School No Elementary KG 05 2018   pre_kindergarten                                                   *                                              
535554 535554 AZ     school 400680 4406   Amphitheater Unified District 40068003517 12976 The Innovation Academy   Regular School No Elementary KG 05 2018   pre_kindergarten                                                   *                                              
535555 535555 AZ     school 400680 4406   Amphitheater Unified District 40068000031 5793 Winifred Harelson Elementary School   Regular School No Elementary KG 06 2018   pre_kindergarten                                                   *                                              
535556 535556 AZ     school 400720 4506   Antelope Union High School District 40072003466 92739 AUHS Online Acadamy   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535557 535557 AZ     school 400720 4506   Antelope Union High School District 40072000034 6188 Antelope Union High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535558 535558 AZ     school 400819 90532   Anthem Preparatory Academy 40081903187 90635 Great Hearts Academies - Anthem Prep   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535559 535559 AZ     school 400750 4178   Apache Elementary District 40075000039 4786 Apache Elementary School   Regular School No Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535560 535560 AZ     school 400790 4443   Apache Junction Unified District 40079000043 5925 Apache Junction High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535561 535561 AZ     school 400790 4443   Apache Junction Unified District 40079000040 5923 Cactus Canyon Junior High   Regular School No Middle 07 08 2018   pre_kindergarten                                                   *                                              
535562 535562 AZ     school 400790 4443   Apache Junction Unified District 40079001461 5922 Desert Vista Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   53                                             53
535563 535563 AZ     school 400790 4443   Apache Junction Unified District 40079000041 5920 Four Peaks Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   *                                              
535564 535564 AZ     school 400790 4443   Apache Junction Unified District 40079002212 79631 Peralta Trail Elementary School   Regular School No Elementary KG 06 2018   pre_kindergarten                                                   *                                              
535565 535565 AZ     school 400790 4443   Apache Junction Unified District 40079003333 91810 Superstition Mountain On-Line School   Regular School No High 07 12 2018   pre_kindergarten                                                   *                                              
535566 535566 AZ     school 400318 79426   Aprender Tucson 40031802203 79432 Southside Community School   Regular School Yes Other KG 09 2018   pre_kindergarten                                                   *                                              
535567 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                                                   *                                              
535568 535568 AZ     school 400886 92314   Archway Classical Academy Cicero 40088603407 92315 Great Hearts Academies - Archway Cicero   Regular School Yes Elementary KG 07 2018   pre_kindergarten                                                   *                                              
535569 535569 AZ     school 400866 91878   Archway Classical Academy Glendale 40086603356 91879 Great Hearts Academies - Archway Glendale   Regular School Yes Elementary KG 05 2018   pre_kindergarten                                                   *                                              
535570 535570 AZ     school 400925 92656   Archway Classical Academy Lincoln 40092503464 92708 Great Hearts Academies - Archway Lincoln   Regular School Yes Elementary KG 05 2018   pre_kindergarten                                                   *                                              
535571 535571 AZ     school 400873 91758   Archway Classical Academy North Phoenix 40087303353 91785 Great Hearts Academies - Archway North Phoenix   Regular School Yes Elementary KG 06 2018   pre_kindergarten                                                   *                                              
535572 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                                                   *                                              
535573 535573 AZ     school 400930 92704   Archway Classical Academy Trivium East 40093003462 92707 Great Hearts Academies - Archway Trivium East   Regular School Yes Elementary KG 05 2018   pre_kindergarten                                                   *                                              
535574 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 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                                                   *                                              
535576 535576 AZ     school 400757 89486   Arete Preparatory Academy 40075702820 89487 Great Hearts Academies - Arete Prep   Regular School Yes High 06 12 2018   pre_kindergarten                                                   *                                              
535577 535577 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   pre_kindergarten                                                   *                                              
535578 535578 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   pre_kindergarten                                                   *                                              
535579 535579 AZ     school 400106 4331   Arizona Agribusiness & Equine Center, Inc. 40010601892 6344 AAEC - Paradise Valley   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535580 535580 AZ     school 400417 85816   Arizona Agribusiness & Equine Center, Inc. 40041701588 5503 AAEC - SMCC Campus   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535581 535581 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   pre_kindergarten                                                   *                                              
535582 535582 AZ     school 400828 90779   Arizona Agribusiness & Equine Center, Inc. 40082803199 90780 Arizona Agribusiness & Equine Center - Estrella   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535583 535583 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   pre_kindergarten                                                   *                                              
535584 535584 AZ     school 400913 91958   Arizona Autism Charter Schools, Inc. 40091303455 92598 Arizona Autism Charter School   Regular School Yes Elementary KG 06 2018   pre_kindergarten                                                   *                                              
535585 535585 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   pre_kindergarten                                                   *                                              
535586 535586 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   pre_kindergarten                                                   *                                              
535587 535587 AZ     school 400361 79947   Arizona Community Development Corporation 40036102299 79950 La Paloma Academy   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535588 535588 AZ     school 400361 79947   Arizona Community Development Corporation 40036103165 81187 La Paloma Academy (Lakeside)   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535589 535589 AZ     school 400361 79947   Arizona Community Development Corporation 40036103312 91805 La Paloma Academy-South   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535590 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                                                   *                                              
535591 535591 AZ     school 400827 90758   Arizona Education Solutions 40082703252 91184 Valiant Academy   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535592 535592 AZ     school 400827 90758   Arizona Education Solutions 40082703309 91246 Valiant Academy   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535593 535593 AZ     school 400918 92566   Arizona Language Preparatory 40091803426 92567 Arizona Language Preparatory   Regular School Yes Elementary KG 06 2018   pre_kindergarten                                                   *                                              
535594 535594 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   pre_kindergarten                                                   *                                              
535595 535595 AZ     school 400056 4345   Arizona School For The Arts 40005600781 5519 Arizona School For The Arts   Regular School Yes High 05 12 2018   pre_kindergarten                                                   *                                              
535596 535596 AZ     school 400840 4274   Arlington Elementary District 40084000044 5354 Arlington Elementary School   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   *                                              
535597 535597 AZ     school 400870 4187   Ash Creek Elementary District 40087000046 4797 Ash Creek Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   *                                              
535598 535598 AZ     school 400910 4471   Ash Fork Joint Unified District 40091000047 6101 Ash Fork Elementary School   Regular School No Elementary KG 05 2018   pre_kindergarten                                                   *                                              
535599 535599 AZ     school 400910 4471   Ash Fork Joint Unified District 40091000048 6103 Ash Fork High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535600 535600 AZ     school 400910 4471   Ash Fork Joint Unified District 40091001059 6102 Ash Fork Middle School   Regular School No Middle 06 08 2018   pre_kindergarten                                                   *                                              
535601 535601 AZ     school 400960 4272   Avondale Elementary District 40096003387 91985 Avondale Middle School   Regular School No Middle 06 08 2018   pre_kindergarten                                                   *                                              
535602 535602 AZ     school 400960 4272   Avondale Elementary District 40096002494 87619 Centerra Mirage STEM Academy   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   *                                              
535603 535603 AZ     school 400960 4272   Avondale Elementary District 40096002880 90028 Copper Trails   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   *                                              
535604 535604 AZ     school 400960 4272   Avondale Elementary District 40096002255 79670 Desert Star   Regular School No Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535605 535605 AZ     school 400960 4272   Avondale Elementary District 40096002381 79792 Desert Thunder   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   *                                              
535606 535606 AZ     school 400960 4272   Avondale Elementary District 40096001154 5348 Eliseo C. Felix School   Regular School No Elementary 02 05 2018   pre_kindergarten                                                   *                                              
535607 535607 AZ     school 400960 4272   Avondale Elementary District 40096000051 5349 Lattie Coor   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   *                                              
535608 535608 AZ     school 400960 4272   Avondale Elementary District 40096000049 5347 Michael Anderson   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   *                                              
535609 535609 AZ     school 400960 4272   Avondale Elementary District 40096001878 78924 Wildflower School   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   30                                             30
535610 535610 AZ     school 400394 79929   Avondale Learning dba Precision Academy 40039402323 80006 Precision Academy   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535611 535611 AZ     school 400094 4508   Az-Tec High School 40009401109 6192 AZTEC High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535612 535612 AZ     school 400134 6361   BASIS Schools, Inc. 40013401786 6065 BASIS Tucson Primary   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535613 535613 AZ     school 400608 81078   BASIS Schools, Inc. 40060803115 81079 BASIS Scottsdale   Regular School Yes Other 04 12 2018   pre_kindergarten                                                   *                                              
535614 535614 AZ     school 400818 90508   BASIS Schools, Inc. 40081803197 90509 BASIS Oro Valley   Regular School Yes High 05 12 2018   pre_kindergarten                                                   *                                              
535615 535615 AZ     school 400829 90841   BASIS Schools, Inc. 40082903278 91055 BASIS Peoria   Regular School Yes High 05 12 2018   pre_kindergarten                                                   *                                              
535616 535616 AZ     school 400830 90842   BASIS Schools, Inc. 40083003253 91056 BASIS Chandler   Regular School Yes High 05 12 2018   pre_kindergarten                                                   *                                              
535617 535617 AZ     school 400831 90862   BASIS Schools, Inc. 40083103196 90863 BASIS Flagstaff   Regular School Yes Other 03 12 2018   pre_kindergarten                                                   *                                              
535618 535618 AZ     school 400843 91280   BASIS Schools, Inc. 40084303351 91343 BASIS Phoenix   Regular School Yes High 05 12 2018   pre_kindergarten                                                   *                                              
535619 535619 AZ     school 400878 91309   BASIS Schools, Inc. 40087803350 91766 BASIS Tucson North   Regular School Yes High 05 12 2018   pre_kindergarten                                                   *                                              
535620 535620 AZ     school 400897 91339   BASIS Schools, Inc. 40089703376 92030 BASIS Ahwatukee   Regular School Yes Other 03 12 2018   pre_kindergarten                                                   *                                              
535621 535621 AZ     school 400898 91949   BASIS Schools, Inc. 40089803393 91997 BASIS Mesa   Regular School Yes Other 03 12 2018   pre_kindergarten                                                   *                                              
535622 535622 AZ     school 400905 92318   BASIS Schools, Inc. 40090503419 92319 BASIS Oro Valley Primary   Regular School Yes Elementary KG 06 2018   pre_kindergarten                                                   *                                              
535623 535623 AZ     school 400903 92320   BASIS Schools, Inc. 40090303418 92321 BASIS Prescott   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535624 535624 AZ     school 400881 92349   BASIS Schools, Inc. 40088103394 92350 BASIS Phoenix Central Primary   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535625 535625 AZ     school 400941 92734   BASIS Schools, Inc. 40094103502 92735 BASIS Goodyear   Regular School Yes Middle 05 10 2018   pre_kindergarten                                                   *                                              
535626 535626 AZ     school 400943 92736   BASIS Schools, Inc. 40094303498 92737 BASIS Goodyear Primary   Regular School Yes Elementary KG 05 2018   pre_kindergarten                                                   *                                              
535627 535627 AZ     school 400937 92863   BASIS Schools, Inc. 40093703482 92864 BASIS Scottsdale Primary   Regular School Yes Elementary KG 05 2018   pre_kindergarten                                                   *                                              
535628 535628 AZ     school 400936 92865   BASIS Schools, Inc. 40093603484 92866 BASIS Chandler Primary- South Campus   Regular School Yes Elementary KG 05 2018   pre_kindergarten                                                   *                                              
535629 535629 AZ     school 400958 92997   BASIS Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2018   pre_kindergarten                                                   *                                              
535630 535630 AZ     school 400963 273398   BASIS Schools, Inc. 40096303558 103670 BASIS Peoria Primary   Regular School Yes Elementary KG 04 2018   pre_kindergarten                                                   *                                              
535631 535631 AZ     school 400961 549803   BASIS Schools, Inc. 40096103550 139682 BASIS Phoenix South Primary   Regular School Yes Elementary KG 02 2018   pre_kindergarten                                                   *                                              
535632 535632 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   pre_kindergarten                                                   *                                              
535633 535633 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   pre_kindergarten                                                   *                                              
535634 535634 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000310 5847 Baboquivari High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535635 535635 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000311 5846 Baboquivari Middle School   Regular School No Middle 07 08 2018   pre_kindergarten                                                   *                                              
535636 535636 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003566 948673 Indian Oasis Intermediate Elementary School   Regular School No Middle 04 06 2018   pre_kindergarten                                                   *                                              
535637 535637 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000312 5844 Indian Oasis Primary Elementary School   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   *                                              
535638 535638 AZ     school 401000 4468   Bagdad Unified District 40100000052 6088 Bagdad Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   11                                             11
535639 535639 AZ     school 401000 4468   Bagdad Unified District 40100000053 6089 Bagdad Middle / Senior High School   Regular School No High 06 12 2018   pre_kindergarten                                                   *                                              
535640 535640 AZ     school 400184 79204   Ball Charter Schools (Dobson) 40018401713 10729 Dobson Academy, The - A Ball Charter School   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535641 535641 AZ     school 400100 4294   Ball Charter Schools (Hearn) 40010001714 10730 Hearn Academy, The - A Ball Charter School   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535642 535642 AZ     school 400867 90885   Ball Charter Schools (Val Vista) 40086703342 91791 Ball Charter Schools (Val Vista)   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535643 535643 AZ     school 401050 4268   Balsz Elementary District 40105000054 5319 Balsz Elementary School   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   *                                              
535644 535644 AZ     school 401050 4268   Balsz Elementary District 40105003142 81141 Brunson-Lee Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   *                                              
535645 535645 AZ     school 401050 4268   Balsz Elementary District 40105000055 5320 David Crockett Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   *                                              
535646 535646 AZ     school 401050 4268   Balsz Elementary District 40105000056 5321 Griffith Elementary School   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   *                                              
535647 535647 AZ     school 401080 4481   Beaver Creek Elementary District 40108000059 6116 Beaver Creek School   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   14                                             14
535648 535648 AZ     school 400374 79983   Bell Canyon Charter School, Inc 40037402169 79507 Imagine Bell Canyon   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   *                                              
535649 535649 AZ     school 400181 10972   Benchmark School, Inc. 40018101889 78803 Benchmark School   Regular School Yes Elementary KG 06 2018   pre_kindergarten                                                   *                                              
535650 535650 AZ     school 400065 4355   Benjamin Franklin Charter School 40006501599 5537 Benjamin Franklin Charter School - Crismon   Regular School Yes Elementary KG 06 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]);