enrollments

Data source: Big Local News · About: Big Local

1,971 rows where grade = "grade_6", state = "AZ" and year = 2019

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 1,871 ✖

grade ✖

  • grade_6 · 1,871 ✖
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
578973 578973 AZ     school 400790 4443   Apache Junction Unified District 40079000043 5925 Apache Junction High School   Regular School No High 09 12 2019   grade_6                                                   *                                              
578974 578974 AZ     school 400790 4443   Apache Junction Unified District 40079002212 79631 Peralta Trail Elementary School   Regular School No Elementary KG 06 2019   grade_6                                                   69                                             69
578975 578975 AZ     school 400318 79426   Aprender Tucson 40031802203 79432 Southside Community School   Regular School Yes Other KG 09 2019   grade_6                                                   37                                             37
578976 578976 AZ     school 400888 92312   Archway Classical Academy Arete 40088803412 92313 Great Hearts Academies - Archway Arete   Regular School Yes Elementary KG 05 2019   grade_6                                                   *                                              
578977 578977 AZ     school 400834 90917   Archway Classical Academy Chandler 40083403244 90999 Great Hearts Academies - Archway Chandler   Regular School Yes Other KG 12 2019   grade_6                                                   *                                              
578978 578978 AZ     school 400886 92314   Archway Classical Academy Cicero 40088603407 92315 Great Hearts Academies - Archway Cicero   Regular School Yes Elementary KG 05 2019   grade_6                                                   *                                              
578979 578979 AZ     school 400866 91878   Archway Classical Academy Glendale 40086603356 91879 Great Hearts Academies - Archway Glendale   Regular School Yes Elementary KG 05 2019   grade_6                                                   *                                              
578980 578980 AZ     school 400925 92656   Archway Classical Academy Lincoln 40092503464 92708 Great Hearts Academies - Archway Lincoln   Regular School Yes Elementary KG 05 2019   grade_6                                                   *                                              
578981 578981 AZ     school 400873 91758   Archway Classical Academy North Phoenix 40087303353 91785 Great Hearts Academies - Archway North Phoenix   Regular School Yes Elementary KG 06 2019   grade_6                                                   118                                             118
578982 578982 AZ     school 400841 90857   Archway Classical Academy Scottsdale 40084103259 90994 Great Hearts Academies - Archway Scottsdale   Regular School Yes Elementary KG 05 2019   grade_6                                                   *                                              
578983 578983 AZ     school 400930 92704   Archway Classical Academy Trivium East 40093003462 92707 Great Hearts Academies - Archway Trivium East   Regular School Yes Elementary KG 05 2019   grade_6                                                   *                                              
578984 578984 AZ     school 400832 90915   Archway Classical Academy Trivium West 40083203290 91001 Great Hearts Academies - Archway Trivium West   Regular School Yes Other KG 12 2019   grade_6                                                   *                                              
578985 578985 AZ     school 400833 90916   Archway Classical Academy Veritas 40083303283 91000 Great Hearts Academies - Archway Veritas   Regular School Yes Other KG 12 2019   grade_6                                                   *                                              
578986 578986 AZ     school 400757 89486   Arete Preparatory Academy 40075702820 89487 Great Hearts Academies - Arete Prep   Regular School Yes High 06 12 2019   grade_6                                                   101                                             101
578987 578987 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 2019   grade_6                                                   *                                              
578988 578988 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes High 09 12 2019   grade_6                                                   *                                              
578989 578989 AZ     school 400106 4331   Arizona Agribusiness & Equine Center, Inc. 40010601892 6344 AAEC - Paradise Valley   Regular School Yes High 09 12 2019   grade_6                                                   *                                              
578990 578990 AZ     school 400417 85816   Arizona Agribusiness & Equine Center, Inc. 40041701588 5503 AAEC - SMCC Campus   Regular School Yes High 09 12 2019   grade_6                                                   *                                              
578991 578991 AZ     school 400426 87403   Arizona Agribusiness & Equine Center, Inc. 40042602528 87404 Arizona Agribusiness & Equine Center, Inc. - Red Mountain   Regular School Yes High 09 12 2019   grade_6                                                   *                                              
578992 578992 AZ     school 400828 90779   Arizona Agribusiness & Equine Center, Inc. 40082803199 90780 Arizona Agribusiness & Equine Center - Estrella   Regular School Yes High 09 12 2019   grade_6                                                   *                                              
578993 578993 AZ     school 400838 91131   Arizona Agribusiness & Equine Center, Inc. 40083803243 91132 Arizona Agribusiness & Equine Center, Inc. - Prescott Valley   Regular School Yes High 09 12 2019   grade_6                                                   *                                              
578994 578994 AZ     school 400913 91958   Arizona Autism Charter Schools, Inc. 40091303455 92598 Arizona Autism Charter School   Regular School Yes Elementary KG 06 2019   grade_6                                                   *                                              
578995 578995 AZ     school 400913 91958   Arizona Autism Charter Schools, Inc. 40091303512 92984 Arizona Autism Charter School, Upper School Campus   Regular School Yes High 05 12 2019   grade_6                                                   21                                             21
578996 578996 AZ     school 400057 4346   Arizona Call-a-Teen Youth Resources, Inc. 40005700784 5520 City View High School   Regular School Yes High 09 12 2019   grade_6                                                   *                                              
578997 578997 AZ     school 400361 79947   Arizona Community Development Corporation 40036102299 79950 La Paloma Academy   Regular School Yes Elementary KG 08 2019   grade_6                                                   89                                             89
578998 578998 AZ     school 400361 79947   Arizona Community Development Corporation 40036103165 81187 La Paloma Academy (Lakeside)   Regular School Yes Elementary KG 08 2019   grade_6                                                   81                                             81
578999 578999 AZ     school 400361 79947   Arizona Community Development Corporation 40036103312 91805 La Paloma Academy-South   Regular School Yes Elementary KG 08 2019   grade_6                                                   52                                             52
579000 579000 AZ     school 400427 87407   Arizona Connections Academy Charter School, Inc. 40042703160 81179 Arizona Connections Academy   Regular School Yes Other KG 12 2019   grade_6                                                   210                                             210
579001 579001 AZ     school 400827 90758   Arizona Education Solutions 40082703252 91184 Valiant Academy   Regular School Yes Elementary KG 08 2019   grade_6                                                   17                                             17
579002 579002 AZ     school 400827 90758   Arizona Education Solutions 40082703309 91246 Valiant Academy   Regular School Yes High 09 12 2019   grade_6                                                   *                                              
579003 579003 AZ     school 400918 92566   Arizona Language Preparatory 40091803426 92567 Arizona Language Preparatory   Regular School Yes Elementary KG 06 2019   grade_6                                                   *                                              
579004 579004 AZ     school 400415 85749   Arizona Montessori Charter School at Anthem 40041502414 85750 AMCS at Anthem dba Caurus Academy   Regular School Yes Other KG 10 2019   grade_6                                                   62                                             62
579005 579005 AZ     school 400056 4345   Arizona School For The Arts 40005600781 5519 Arizona School For The Arts   Regular School Yes High 05 12 2019   grade_6                                                   108                                             108
579006 579006 AZ     school 400840 4274   Arlington Elementary District 40084000044 5354 Arlington Elementary School   Regular School No Elementary PK 08 2019   grade_6                                                   24                                             24
579007 579007 AZ     school 400870 4187   Ash Creek Elementary District 40087000046 4797 Ash Creek Elementary   Regular School No Elementary PK 08 2019   grade_6                                                   *                                              
579008 579008 AZ     school 400910 4471   Ash Fork Joint Unified District 40091000047 6101 Ash Fork Elementary School   Regular School No Elementary KG 05 2019   grade_6                                                   *                                              
579009 579009 AZ     school 400910 4471   Ash Fork Joint Unified District 40091001059 6102 Ash Fork Middle School   Regular School No Middle 06 08 2019   grade_6                                                   31                                             31
579010 579010 AZ     school 400910 4471   Ash Fork Joint Unified District 40091000048 6103 Ash Fork High School   Regular School No High 09 12 2019   grade_6                                                   *                                              
579011 579011 AZ     school 400764 89949   ASU Preparatory Academy 40076403051 90271 ASU Preparatory Academy- Phoenix Elementary   Regular School Yes Elementary KG 04 2019   grade_6                                                   *                                              
579012 579012 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 ASU Preparatory Academy - South Phoenix Intermediate   Regular School Yes Middle 03 07 2019   grade_6                                                   47                                             47
579013 579013 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2019   grade_6                                                   *                                              
579014 579014 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 09 12 2019   grade_6                                                   *                                              
579015 579015 AZ     school 400857 91307   ASU Preparatory Academy 40085703260 91308 ASU Preparatory Academy-Polytechnic Elementary   Regular School Yes Elementary KG 04 2019   grade_6                                                   *                                              
579016 579016 AZ     school 400890 92325   ASU Preparatory Academy 40089003367 92326 ASU Preparatory Academy - Phoenix Middle School   Regular School Yes Middle 05 08 2019   grade_6                                                   82                                             82
579017 579017 AZ     school 400884 92327   ASU Preparatory Academy 40088403264 91323 ASU Preparatory Academy-Polytechnic Middle School   Regular School Yes Middle 05 08 2019   grade_6                                                   75                                             75
579018 579018 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 ASU Preparatory Academy - South Phoenix Primary   Regular School Yes Elementary PK 04 2019   grade_6                                                   *                                              
579019 579019 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 ASU Preparatory Academy - South Phoenix High School   Regular School Yes High 08 12 2019   grade_6                                                   *                                              
579020 579020 AZ     school 400971 631426   ASU Preparatory Academy 40097103567 338609 ASU Preparatory Academy - Tempe   Regular School Yes High 09 12 2019   grade_6                                                   *                                              
579021 579021 AZ     school 400947 92987   ASU Preparatory Academy - Casa Grande 40094703526 635758 ASU Preparatory Academy - Casa Grande HS   Regular School Yes High 09 12 2019   grade_6                                                   *                                              
579022 579022 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes High 07 12 2019   grade_6                                                   *                                              
579023 579023 AZ     school 400960 4272   Avondale Elementary District 40096000049 5347 Michael Anderson   Regular School No Elementary PK 08 2019   grade_6                                                   93                                             93
579024 579024 AZ     school 400960 4272   Avondale Elementary District 40096001154 5348 Eliseo C. Felix School   Regular School No Elementary 02 05 2019   grade_6                                                   *                                              
579025 579025 AZ     school 400960 4272   Avondale Elementary District 40096000051 5349 Lattie Coor   Regular School No Elementary PK 02 2019   grade_6                                                   *                                              
579026 579026 AZ     school 400960 4272   Avondale Elementary District 40096001878 78924 Wildflower Accelerated Academy   Regular School No Elementary PK 08 2019   grade_6                                                   65                                             65
579027 579027 AZ     school 400960 4272   Avondale Elementary District 40096002255 79670 Desert Star   Regular School No Elementary KG 08 2019   grade_6                                                   82                                             82
579028 579028 AZ     school 400960 4272   Avondale Elementary District 40096002381 79792 Desert Thunder   Regular School No Elementary PK 08 2019   grade_6                                                   86                                             86
579029 579029 AZ     school 400960 4272   Avondale Elementary District 40096002494 87619 Centerra Mirage STEM Academy   Regular School No Elementary PK 08 2019   grade_6                                                   66                                             66
579030 579030 AZ     school 400960 4272   Avondale Elementary District 40096002880 90028 Copper Trails   Regular School No Elementary PK 08 2019   grade_6                                                   135                                             135
579031 579031 AZ     school 400960 4272   Avondale Elementary District 40096003387 91985 Avondale Middle School   Regular School No Middle 06 08 2019   grade_6                                                   136                                             136
579032 579032 AZ     school 400394 79929   Avondale Learning dba Precision Academy 40039402323 80006 Precision Academy   Regular School Yes High 09 12 2019   grade_6                                                   *                                              
579033 579033 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Regular School Yes High 07 12 2019   grade_6                                                   *                                              
579034 579034 AZ     school 400094 4508   Az-Tec High School 40009401109 6192 AZTEC High School   Regular School Yes High 09 12 2019   grade_6                                                   *                                              
579035 579035 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000312 5844 Indian Oasis Primary Elementary School   Regular School No Elementary PK 03 2019   grade_6                                                   *                                              
579036 579036 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000311 5846 Baboquivari Middle School   Regular School No Middle 07 08 2019   grade_6                                                   *                                              
579037 579037 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000310 5847 Baboquivari High School   Regular School No High 09 12 2019   grade_6                                                   *                                              
579038 579038 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003210 90821 Alternative Middle School (Indian Oasis Middle School)   Regular School No Middle 06 08 2019   grade_6                                                   *                                              
579039 579039 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003222 90822 Alternative High School (Indian Oasis High School)   Regular School No High 09 12 2019   grade_6                                                   *                                              
579040 579040 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003566 948673 Indian Oasis Intermediate Elementary School   Regular School No Middle 04 06 2019   grade_6                                                   62                                             62
579041 579041 AZ     school 401000 4468   Bagdad Unified District 40100000052 6088 Bagdad Elementary School   Regular School No Elementary PK 05 2019   grade_6                                                   *                                              
579042 579042 AZ     school 401000 4468   Bagdad Unified District 40100000053 6089 Bagdad Middle / Senior High School   Regular School No High 06 12 2019   grade_6                                                   40                                             40
579043 579043 AZ     school 400184 79204   Ball Charter Schools (Dobson) 40018401713 10729 Dobson Academy, The - A Ball Charter School   Regular School Yes Elementary KG 08 2019   grade_6                                                   44                                             44
579044 579044 AZ     school 400100 4294   Ball Charter Schools (Hearn) 40010001714 10730 Hearn Academy, The - A Ball Charter School   Regular School Yes Elementary KG 08 2019   grade_6                                                   75                                             75
579045 579045 AZ     school 400867 90885   Ball Charter Schools (Val Vista) 40086703342 91791 Ball Charter Schools (Val Vista)   Regular School Yes Elementary KG 08 2019   grade_6                                                   29                                             29
579046 579046 AZ     school 401050 4268   Balsz Elementary District 40105000054 5319 Pat Tillman Middle School   Regular School No Middle 06 08 2019   grade_6                                                   243                                             243
579047 579047 AZ     school 401050 4268   Balsz Elementary District 40105000055 5320 David Crockett Elementary School   Regular School No Elementary PK 06 2019   grade_6                                                   *                                              
579048 579048 AZ     school 401050 4268   Balsz Elementary District 40105000056 5321 Griffith Elementary School   Regular School No Elementary PK 06 2019   grade_6                                                   *                                              
579049 579049 AZ     school 401050 4268   Balsz Elementary District 40105003142 81141 Brunson-Lee Elementary School   Regular School No Elementary PK 06 2019   grade_6                                                   *                                              
579050 579050 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   grade_6                                                   *                                              
579051 579051 AZ     school 400134 6361   BASIS Charter Schools, Inc. 40013401786 6065 BASIS Tucson Primary   Regular School Yes Other KG 12 2019   grade_6                                                   *                                              
579052 579052 AZ     school 400608 81078   BASIS Charter Schools, Inc. 40060803115 81079 BASIS Scottsdale   Regular School Yes Other 04 12 2019   grade_6                                                   171                                             171
579053 579053 AZ     school 400818 90508   BASIS Charter Schools, Inc. 40081803197 90509 BASIS Oro Valley   Regular School Yes High 05 12 2019   grade_6                                                   130                                             130
579054 579054 AZ     school 400829 90841   BASIS Charter Schools, Inc. 40082903278 91055 BASIS Peoria   Regular School Yes High 05 12 2019   grade_6                                                   193                                             193
579055 579055 AZ     school 400830 90842   BASIS Charter Schools, Inc. 40083003253 91056 BASIS Chandler   Regular School Yes High 05 12 2019   grade_6                                                   216                                             216
579056 579056 AZ     school 400831 90862   BASIS Charter Schools, Inc. 40083103196 90863 BASIS Flagstaff   Regular School Yes Other KG 12 2019   grade_6                                                   95                                             95
579057 579057 AZ     school 400843 91280   BASIS Charter Schools, Inc. 40084303351 91343 BASIS Phoenix   Regular School Yes High 05 12 2019   grade_6                                                   151                                             151
579058 579058 AZ     school 400878 91309   BASIS Charter Schools, Inc. 40087803350 91766 BASIS Tucson North   Regular School Yes High 05 12 2019   grade_6                                                   162                                             162
579059 579059 AZ     school 400897 91339   BASIS Charter Schools, Inc. 40089703376 92030 BASIS Ahwatukee   Regular School Yes Other 04 12 2019   grade_6                                                   139                                             139
579060 579060 AZ     school 400898 91949   BASIS Charter Schools, Inc. 40089803393 91997 BASIS Mesa   Regular School Yes Other KG 12 2019   grade_6                                                   86                                             86
579061 579061 AZ     school 400905 92318   BASIS Charter Schools, Inc. 40090503419 92319 BASIS Oro Valley Primary   Regular School Yes Elementary KG 06 2019   grade_6                                                   *                                              
579062 579062 AZ     school 400903 92320   BASIS Charter Schools, Inc. 40090303418 92321 BASIS Prescott   Regular School Yes Other KG 12 2019   grade_6                                                   81                                             81
579063 579063 AZ     school 400881 92349   BASIS Charter Schools, Inc. 40088103394 92350 BASIS Phoenix Central Primary   Regular School Yes Other KG 12 2019   grade_6                                                   55                                             55
579064 579064 AZ     school 400941 92734   BASIS Charter Schools, Inc. 40094103502 92735 BASIS Goodyear   Regular School Yes High 05 12 2019   grade_6                                                   97                                             97
579065 579065 AZ     school 400943 92736   BASIS Charter Schools, Inc. 40094303498 92737 BASIS Goodyear Primary   Regular School Yes Elementary KG 05 2019   grade_6                                                   *                                              
579066 579066 AZ     school 400937 92863   BASIS Charter Schools, Inc. 40093703482 92864 BASIS Scottsdale Primary - East Campus   Regular School Yes Elementary KG 03 2019   grade_6                                                   *                                              
579067 579067 AZ     school 400936 92865   BASIS Charter Schools, Inc. 40093603484 92866 BASIS Chandler Primary- South Campus   Regular School Yes Elementary KG 05 2019   grade_6                                                   *                                              
579068 579068 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2019   grade_6                                                   *                                              
579069 579069 AZ     school 400963 273398   BASIS Charter Schools, Inc. 40096303558 103670 BASIS Peoria Primary   Regular School Yes Elementary KG 04 2019   grade_6                                                   *                                              
579070 579070 AZ     school 400961 549803   BASIS Charter Schools, Inc. 40096103550 139682 BASIS Phoenix South Primary   Regular School Yes Elementary KG 04 2019   grade_6                                                   *                                              
579071 579071 AZ     school 400980 783027   BASIS Charter Schools, Inc. 40098003607 893297 BASIS Scottsdale Primary - West Campus   Regular School Yes Elementary KG 04 2019   grade_6                                                   *                                              
579072 579072 AZ     school 401080 4481   Beaver Creek Elementary District 40108000059 6116 Beaver Creek School   Regular School No Elementary PK 08 2019   grade_6                                                   30                                             30

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