enrollments

Data source: Big Local News · About: Big Local

8,512 rows where grade = "grade_7" and state = "AZ" sorted by district

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 8,512 ✖
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
148733 148733 AZ     school 400328 79457   A Center for Creative Education 40032802228 79458 Verde Valley Montessori School - A Center for Creative Education   Regular School Yes Elementary KG 08 2020   grade_7                                                   *                                              
551251 551251 AZ     school 400328 79457   A Center for Creative Education 40032802228 79458 Verde Valley Montessori School - A Center for Creative Education   Regular School Yes Elementary KG 08 2018   grade_7                                                   *                                              
580844 580844 AZ     school 400328 79457   A Center for Creative Education 40032802228 79458 Verde Valley Montessori School - A Center for Creative Education   Regular School Yes Elementary KG 08 2019   grade_7                                                   *                                              
82702 82702 AZ     school 400998 1000166   A+ Charter Schools 40099803681 1000972 A+ Charter Schools   Regular School Yes High 07 12 2021   grade_7                                                   39                                             39
82718 82718 AZ     school   7355   ACCEL   91260 ACCEL Buckeye Learning Center             2021   grade_7                                                   *                                              
82719 82719 AZ     school   7355   ACCEL   7360 ACCEL East Campus             2021   grade_7                                                   *                                              
82720 82720 AZ     school   7355   ACCEL   7356 ACCEL Metro Campus             2021   grade_7                                                   15                                             15
148745 148745 AZ     school   7355   ACCEL   91260 ACCEL Buckeye Learning Center             2020   grade_7                                                   *                                              
148746 148746 AZ     school   7355   ACCEL   7360 ACCEL East Campus             2020   grade_7                                                   *                                              
148747 148747 AZ     school   7355   ACCEL   7356 ACCEL Metro Campus             2020   grade_7                                                   13                                             13
148748 148748 AZ     school   7355   ACCEL   1000307 ACCEL Ruth Fisher Campus             2020   grade_7                                                   *                                              
82732 82732 AZ     school 400274 79053   AIBT Non-Profit Charter High School - Phoenix 40027402020 79123 Career and College Prep   Alternative School Yes High 07 12 2021   grade_7                                                   *                                              
148760 148760 AZ     school 400274 79053   AIBT Non-Profit Charter High School - Phoenix 40027402020 79123 RCB Medical Arts Academy   Alternative School Yes High 07 12 2020   grade_7                                                   *                                              
551252 551252 AZ     school 400274 79053   AIBT Non-Profit Charter High School - Phoenix 40027402020 79123 RCB Medical Arts Academy   Regular School Yes High 07 12 2018   grade_7                                                   *                                              
580867 580867 AZ     school 400274 79053   AIBT Non-Profit Charter High School - Phoenix 40027402020 79123 RCB Medical Arts Academy   Regular School Yes High 07 12 2019   grade_7                                                   *                                              
82733 82733 AZ     school 400970 449790   AIBT Non-Profit Charter High School, Inc. 40097003546 742847 RCB College Preparatory Academy   Regular School Yes High 09 12 2021   grade_7                                                   *                                              
148761 148761 AZ     school 400970 449790   AIBT Non-Profit Charter High School, Inc. 40097003546 742847 RCB College Preparatory Academy   Regular School Yes High 09 12 2020   grade_7                                                   *                                              
551253 551253 AZ     school 400970 449790   AIBT Non-Profit Charter High School, Inc. 40097003546 742847 RCB College Preparatory Academy   Regular School Yes High 09 12 2018   grade_7                                                   *                                              
580868 580868 AZ     school 400970 449790   AIBT Non-Profit Charter High School, Inc. 40097003546 742847 RCB College Preparatory Academy   Regular School Yes High 09 12 2019   grade_7                                                   *                                              
82813 82813 AZ     school 400989 92980   ARCHES Academy 40098903642 1000276 ARCHES Academy   Regular School Yes Elementary KG 08 2021   grade_7                                                   *                                              
148840 148840 AZ     school 400989 92980   ARCHES Academy 40098903642 1000276 ARCHES Academy   Regular School Yes Elementary KG 07 2020   grade_7                                                   *                                              
82854 82854 AZ     school   89922   ASCEND (Autism Spectrum Center for Educational and Neurological Development)   89923 ASCEND (Autism Spectrum Center for Educational and Neurological Development)             2021   grade_7                                                   *                                              
148894 148894 AZ     school   89922   ASCEND (Autism Spectrum Center for Educational and Neurological Development)   89923 ASCEND (Autism Spectrum Center for Educational and Neurological Development)             2020   grade_7                                                   *                                              
82863 82863 AZ     school 400890 92325   ASU Preparatory Academy 40089003367 92326 ASU Preparatory Academy - Phoenix Middle School   Regular School Yes Middle 05 08 2021   grade_7                                                   112                                             112
82864 82864 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 ASU Preparatory Academy - South Phoenix High School   Regular School Yes High 07 12 2021   grade_7                                                   38                                             38
82865 82865 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 ASU Preparatory Academy - South Phoenix Intermediate   Regular School Yes Elementary 03 06 2021   grade_7                                                   *                                              
82866 82866 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 ASU Preparatory Academy - South Phoenix Primary   Regular School Yes Elementary PK 04 2021   grade_7                                                   *                                              
82867 82867 AZ     school 400764 89949   ASU Preparatory Academy 40076403051 90271 ASU Preparatory Academy- Phoenix Elementary   Regular School Yes Elementary KG 04 2021   grade_7                                                   *                                              
82868 82868 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2021   grade_7                                                   *                                              
82869 82869 AZ     school 400857 91307   ASU Preparatory Academy 40085703260 91308 ASU Preparatory Academy-Polytechnic Elementary   Regular School Yes Elementary KG 04 2021   grade_7                                                   *                                              
82870 82870 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 08 12 2021   grade_7                                                   *                                              
82871 82871 AZ     school 400884 92327   ASU Preparatory Academy 40088403264 91323 ASU Preparatory Academy-Polytechnic Middle School   Regular School Yes Middle 05 07 2021   grade_7                                                   118                                             118
148903 148903 AZ     school 400890 92325   ASU Preparatory Academy 40089003367 92326 ASU Preparatory Academy - Phoenix Middle School   Regular School Yes Middle 05 08 2020   grade_7                                                   123                                             123
148904 148904 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 ASU Preparatory Academy - South Phoenix High School   Regular School Yes High 07 12 2020   grade_7                                                   46                                             46
148905 148905 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 ASU Preparatory Academy - South Phoenix Intermediate   Regular School Yes Elementary 03 06 2020   grade_7                                                   *                                              
148906 148906 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 ASU Preparatory Academy - South Phoenix Primary   Regular School Yes Elementary PK 04 2020   grade_7                                                   *                                              
148907 148907 AZ     school 400971 631426   ASU Preparatory Academy 40097103567 338609 ASU Preparatory Academy - Tempe   Regular School Yes High 09 12 2020   grade_7                                                   *                                              
148908 148908 AZ     school 400764 89949   ASU Preparatory Academy 40076403051 90271 ASU Preparatory Academy- Phoenix Elementary   Regular School Yes Elementary KG 04 2020   grade_7                                                   *                                              
148909 148909 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2020   grade_7                                                   *                                              
148910 148910 AZ     school 400857 91307   ASU Preparatory Academy 40085703260 91308 ASU Preparatory Academy-Polytechnic Elementary   Regular School Yes Elementary KG 04 2020   grade_7                                                   *                                              
148911 148911 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 08 12 2020   grade_7                                                   *                                              
148912 148912 AZ     school 400884 92327   ASU Preparatory Academy 40088403264 91323 ASU Preparatory Academy-Polytechnic Middle School   Regular School Yes Middle 05 07 2020   grade_7                                                   129                                             129
551254 551254 AZ     school 400764 89949   ASU Preparatory Academy 40076403051 90271 ASU Preparatory Academy- Phoenix Elementary   Regular School Yes Elementary KG 04 2018   grade_7                                                   *                                              
551255 551255 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 Phoenix Collegiate Academy Charter School   Regular School Yes Other PK 12 2018   grade_7                                                   39                                             39
551256 551256 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2018   grade_7                                                   *                                              
551257 551257 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 09 12 2018   grade_7                                                   *                                              
551258 551258 AZ     school 400857 91307   ASU Preparatory Academy 40085703260 91308 ASU Preparatory Academy-Polytechnic Elementary   Regular School Yes Elementary KG 04 2018   grade_7                                                   *                                              
551259 551259 AZ     school 400890 92325   ASU Preparatory Academy 40089003367 92326 ASU Preparatory Academy - Phoenix Middle School   Regular School Yes Middle 05 08 2018   grade_7                                                   84                                             84
551260 551260 AZ     school 400884 92327   ASU Preparatory Academy 40088403264 91323 ASU Preparatory Academy-Polytechnic Middle School   Regular School Yes Middle 05 08 2018   grade_7                                                   74                                             74
551261 551261 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 Phoenix Collegiate Academy Elementary, LLC   Regular School Yes Elementary KG 04 2018   grade_7                                                   *                                              
551262 551262 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 Phoenix Collegiate Academy High School   Regular School Yes High 09 12 2018   grade_7                                                   *                                              
551263 551263 AZ     school 400971 631426   ASU Preparatory Academy 40097103567 338609 ASU Preparatory Academy - Tempe   Regular School Yes High 09 12 2018   grade_7                                                   *                                              
580982 580982 AZ     school 400764 89949   ASU Preparatory Academy 40076403051 90271 ASU Preparatory Academy- Phoenix Elementary   Regular School Yes Elementary KG 04 2019   grade_7                                                   *                                              
580983 580983 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 ASU Preparatory Academy - South Phoenix Intermediate   Regular School Yes Middle 03 07 2019   grade_7                                                   49                                             49
580984 580984 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2019   grade_7                                                   *                                              
580985 580985 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 09 12 2019   grade_7                                                   *                                              
580986 580986 AZ     school 400857 91307   ASU Preparatory Academy 40085703260 91308 ASU Preparatory Academy-Polytechnic Elementary   Regular School Yes Elementary KG 04 2019   grade_7                                                   *                                              
580987 580987 AZ     school 400890 92325   ASU Preparatory Academy 40089003367 92326 ASU Preparatory Academy - Phoenix Middle School   Regular School Yes Middle 05 08 2019   grade_7                                                   89                                             89
580988 580988 AZ     school 400884 92327   ASU Preparatory Academy 40088403264 91323 ASU Preparatory Academy-Polytechnic Middle School   Regular School Yes Middle 05 08 2019   grade_7                                                   74                                             74
580989 580989 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 ASU Preparatory Academy - South Phoenix Primary   Regular School Yes Elementary PK 04 2019   grade_7                                                   *                                              
580990 580990 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 ASU Preparatory Academy - South Phoenix High School   Regular School Yes High 08 12 2019   grade_7                                                   *                                              
580991 580991 AZ     school 400971 631426   ASU Preparatory Academy 40097103567 338609 ASU Preparatory Academy - Tempe   Regular School Yes High 09 12 2019   grade_7                                                   *                                              
82872 82872 AZ     school 400947 92987   ASU Preparatory Academy - Casa Grande 40094703526 635758 ASU Preparatory Academy - Casa Grande HS   Regular School Yes High 09 12 2021   grade_7                                                   *                                              
148913 148913 AZ     school 400947 92987   ASU Preparatory Academy - Casa Grande 40094703526 635758 ASU Preparatory Academy - Casa Grande HS   Regular School Yes High 09 12 2020   grade_7                                                   *                                              
551264 551264 AZ     school 400947 92987   ASU Preparatory Academy - Casa Grande 40094703526 635758 ASU Preparatory Academy - Casa Grande HS   Regular School Yes High 09 12 2018   grade_7                                                   *                                              
580992 580992 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_7                                                   *                                              
82873 82873 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes Other KG 12 2021   grade_7                                                   418                                             418
148914 148914 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes Other KG 12 2020   grade_7                                                   14                                             14
551265 551265 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes High 09 12 2018   grade_7                                                   *                                              
580993 580993 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes High 07 12 2019   grade_7                                                   *                                              
82887 82887 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Alternative School Yes High 07 12 2021   grade_7                                                   32                                             32
148928 148928 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Alternative School Yes High 07 12 2020   grade_7                                                   32                                             32
551266 551266 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Regular School Yes High 07 12 2018   grade_7                                                   37                                             37
581004 581004 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Regular School Yes High 07 12 2019   grade_7                                                   30                                             30
82703 82703 AZ     school 400797 90199   Academy Del Sol, Inc. 40079702994 90200 Academy Del Sol   Regular School Yes Elementary KG 08 2021   grade_7                                                   18                                             18
82704 82704 AZ     school 400797 90199   Academy Del Sol, Inc. 40079703230 90770 Academy Del Sol - Hope   Regular School Yes Elementary KG 08 2021   grade_7                                                   56                                             56
148734 148734 AZ     school 400797 90199   Academy Del Sol, Inc. 40079702994 90200 Academy Del Sol   Regular School Yes Elementary KG 08 2020   grade_7                                                   20                                             20
148735 148735 AZ     school 400797 90199   Academy Del Sol, Inc. 40079703230 90770 Academy Del Sol - Hope   Regular School Yes Elementary KG 08 2020   grade_7                                                   53                                             53
551267 551267 AZ     school 400797 90199   Academy Del Sol, Inc. 40079702994 90200 Academy Del Sol   Regular School Yes Elementary KG 08 2018   grade_7                                                   *                                              
551268 551268 AZ     school 400797 90199   Academy Del Sol, Inc. 40079703230 90770 Academy Del Sol - Hope   Regular School Yes Elementary KG 08 2018   grade_7                                                   56                                             56
580845 580845 AZ     school 400797 90199   Academy Del Sol, Inc. 40079702994 90200 Academy Del Sol   Regular School Yes Elementary KG 08 2019   grade_7                                                   11                                             11
580846 580846 AZ     school 400797 90199   Academy Del Sol, Inc. 40079703230 90770 Academy Del Sol - Hope   Regular School Yes Elementary KG 08 2019   grade_7                                                   60                                             60
551269 551269 AZ     school 400128 4296   Academy Of Excellence, Inc. 40012801715 5461 Academy Of Excellence   Regular School Yes Elementary KG 08 2018   grade_7                                                   *                                              
82705 82705 AZ     school 400414 85540   Academy of Building Industries, Inc. 40041402412 85541 Academy of Building Industries   Alternative School Yes High 09 12 2021   grade_7                                                   *                                              
148736 148736 AZ     school 400414 85540   Academy of Building Industries, Inc. 40041402412 85541 Academy of Building Industries   Alternative School Yes High 09 12 2020   grade_7                                                   *                                              
551270 551270 AZ     school 400414 85540   Academy of Building Industries, Inc. 40041402412 85541 Academy of Building Industries   Regular School Yes High 09 12 2018   grade_7                                                   *                                              
580847 580847 AZ     school 400414 85540   Academy of Building Industries, Inc. 40041402412 85541 Academy of Building Industries   Regular School Yes High 09 12 2019   grade_7                                                   *                                              
82706 82706 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103676 1000378 Academy of Math and Science Avondale   Regular School Yes Elementary KG 08 2021   grade_7                                                   100                                             100
82707 82707 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103581 911531 Academy of Math and Science Desert Sky   Regular School Yes Elementary KG 08 2021   grade_7                                                   173                                             173
82708 82708 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103618 1000119 Academy of Math and Science Glendale   Regular School Yes Elementary KG 08 2021   grade_7                                                   109                                             109
82709 82709 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103604 1000118 Academy of Math and Science Peoria Advanced   Regular School Yes Elementary KG 08 2021   grade_7                                                   72                                             72
82710 82710 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103677 1000379 Academy of Math and Science South Mountain   Regular School Yes Elementary KG 08 2021   grade_7                                                   66                                             66
82711 82711 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103399 92197 Academy of Mathematics and Science South   Regular School Yes Elementary KG 08 2021   grade_7                                                   58                                             58
148737 148737 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103581 911531 Academy of Math and Science Desert Sky   Regular School Yes Elementary KG 08 2020   grade_7                                                   164                                             164
148738 148738 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103399 92197 Academy of Mathematics and Science South   Regular School Yes Elementary KG 08 2020   grade_7                                                   63                                             63
551271 551271 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103399 92197 Academy of Mathematics and Science South   Regular School Yes Elementary KG 08 2018   grade_7                                                   *                                              
580848 580848 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103399 92197 Academy of Mathematics and Science South   Regular School Yes Elementary KG 08 2019   grade_7                                                   48                                             48
580849 580849 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103581 911531 Academy of Math and Science Desert Sky   Regular School Yes Elementary KG 08 2019   grade_7                                                   68                                             68
82712 82712 AZ     school 400368 79961   Academy of Mathematics and Science, Inc. 40036802037 79094 Academy of Math and Science   Regular School Yes Other KG 12 2021   grade_7                                                   54                                             54
82713 82713 AZ     school 400940 92768   Academy of Mathematics and Science, Inc. 40094003499 92769 Academy of Math and Science Camelback   Regular School Yes Elementary KG 08 2021   grade_7                                                   112                                             112

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