enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 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
135233 135233 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_1                                                   *                                              
539401 539401 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_1                                                   *                                              
569018 569018 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_1                                                   12                                             12
68806 68806 AZ     school 400998 1000166   A+ Charter Schools 40099803681 1000972 A+ Charter Schools   Regular School Yes High 07 12 2021   grade_1                                                   *                                              
68822 68822 AZ     school   7355   ACCEL   91260 ACCEL Buckeye Learning Center             2021   grade_1                                                   *                                              
68823 68823 AZ     school   7355   ACCEL   7360 ACCEL East Campus             2021   grade_1                                                   *                                              
68824 68824 AZ     school   7355   ACCEL   7356 ACCEL Metro Campus             2021   grade_1                                                   *                                              
135245 135245 AZ     school   7355   ACCEL   91260 ACCEL Buckeye Learning Center             2020   grade_1                                                   *                                              
135246 135246 AZ     school   7355   ACCEL   7360 ACCEL East Campus             2020   grade_1                                                   *                                              
135247 135247 AZ     school   7355   ACCEL   7356 ACCEL Metro Campus             2020   grade_1                                                   *                                              
135248 135248 AZ     school   7355   ACCEL   1000307 ACCEL Ruth Fisher Campus             2020   grade_1                                                   *                                              
68836 68836 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_1                                                   *                                              
135260 135260 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_1                                                   *                                              
539402 539402 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_1                                                   *                                              
569041 569041 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_1                                                   *                                              
68837 68837 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_1                                                   *                                              
135261 135261 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_1                                                   *                                              
539403 539403 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_1                                                   *                                              
569042 569042 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_1                                                   *                                              
68917 68917 AZ     school 400989 92980   ARCHES Academy 40098903642 1000276 ARCHES Academy   Regular School Yes Elementary KG 08 2021   grade_1                                                   *                                              
135340 135340 AZ     school 400989 92980   ARCHES Academy 40098903642 1000276 ARCHES Academy   Regular School Yes Elementary KG 07 2020   grade_1                                                   *                                              
68958 68958 AZ     school   89922   ASCEND (Autism Spectrum Center for Educational and Neurological Development)   89923 ASCEND (Autism Spectrum Center for Educational and Neurological Development)             2021   grade_1                                                   *                                              
135394 135394 AZ     school   89922   ASCEND (Autism Spectrum Center for Educational and Neurological Development)   89923 ASCEND (Autism Spectrum Center for Educational and Neurological Development)             2020   grade_1                                                   *                                              
68967 68967 AZ     school 400890 92325   ASU Preparatory Academy 40089003367 92326 ASU Preparatory Academy - Phoenix Middle School   Regular School Yes Middle 05 08 2021   grade_1                                                   *                                              
68968 68968 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 ASU Preparatory Academy - South Phoenix High School   Regular School Yes High 07 12 2021   grade_1                                                   *                                              
68969 68969 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 ASU Preparatory Academy - South Phoenix Intermediate   Regular School Yes Elementary 03 06 2021   grade_1                                                   *                                              
68970 68970 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 ASU Preparatory Academy - South Phoenix Primary   Regular School Yes Elementary PK 04 2021   grade_1                                                   25                                             25
68971 68971 AZ     school 400764 89949   ASU Preparatory Academy 40076403051 90271 ASU Preparatory Academy- Phoenix Elementary   Regular School Yes Elementary KG 04 2021   grade_1                                                   71                                             71
68972 68972 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2021   grade_1                                                   *                                              
68973 68973 AZ     school 400857 91307   ASU Preparatory Academy 40085703260 91308 ASU Preparatory Academy-Polytechnic Elementary   Regular School Yes Elementary KG 04 2021   grade_1                                                   101                                             101
68974 68974 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 08 12 2021   grade_1                                                   *                                              
68975 68975 AZ     school 400884 92327   ASU Preparatory Academy 40088403264 91323 ASU Preparatory Academy-Polytechnic Middle School   Regular School Yes Middle 05 07 2021   grade_1                                                   *                                              
135403 135403 AZ     school 400890 92325   ASU Preparatory Academy 40089003367 92326 ASU Preparatory Academy - Phoenix Middle School   Regular School Yes Middle 05 08 2020   grade_1                                                   *                                              
135404 135404 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 ASU Preparatory Academy - South Phoenix High School   Regular School Yes High 07 12 2020   grade_1                                                   *                                              
135405 135405 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 ASU Preparatory Academy - South Phoenix Intermediate   Regular School Yes Elementary 03 06 2020   grade_1                                                   *                                              
135406 135406 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 ASU Preparatory Academy - South Phoenix Primary   Regular School Yes Elementary PK 04 2020   grade_1                                                   38                                             38
135407 135407 AZ     school 400971 631426   ASU Preparatory Academy 40097103567 338609 ASU Preparatory Academy - Tempe   Regular School Yes High 09 12 2020   grade_1                                                   *                                              
135408 135408 AZ     school 400764 89949   ASU Preparatory Academy 40076403051 90271 ASU Preparatory Academy- Phoenix Elementary   Regular School Yes Elementary KG 04 2020   grade_1                                                   89                                             89
135409 135409 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2020   grade_1                                                   *                                              
135410 135410 AZ     school 400857 91307   ASU Preparatory Academy 40085703260 91308 ASU Preparatory Academy-Polytechnic Elementary   Regular School Yes Elementary KG 04 2020   grade_1                                                   74                                             74
135411 135411 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 08 12 2020   grade_1                                                   *                                              
135412 135412 AZ     school 400884 92327   ASU Preparatory Academy 40088403264 91323 ASU Preparatory Academy-Polytechnic Middle School   Regular School Yes Middle 05 07 2020   grade_1                                                   *                                              
539404 539404 AZ     school 400764 89949   ASU Preparatory Academy 40076403051 90271 ASU Preparatory Academy- Phoenix Elementary   Regular School Yes Elementary KG 04 2018   grade_1                                                   71                                             71
539405 539405 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 Phoenix Collegiate Academy Charter School   Regular School Yes Other PK 12 2018   grade_1                                                   *                                              
539406 539406 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2018   grade_1                                                   *                                              
539407 539407 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 09 12 2018   grade_1                                                   *                                              
539408 539408 AZ     school 400857 91307   ASU Preparatory Academy 40085703260 91308 ASU Preparatory Academy-Polytechnic Elementary   Regular School Yes Elementary KG 04 2018   grade_1                                                   71                                             71
539409 539409 AZ     school 400890 92325   ASU Preparatory Academy 40089003367 92326 ASU Preparatory Academy - Phoenix Middle School   Regular School Yes Middle 05 08 2018   grade_1                                                   *                                              
539410 539410 AZ     school 400884 92327   ASU Preparatory Academy 40088403264 91323 ASU Preparatory Academy-Polytechnic Middle School   Regular School Yes Middle 05 08 2018   grade_1                                                   *                                              
539411 539411 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 Phoenix Collegiate Academy Elementary, LLC   Regular School Yes Elementary KG 04 2018   grade_1                                                   40                                             40
539412 539412 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 Phoenix Collegiate Academy High School   Regular School Yes High 09 12 2018   grade_1                                                   *                                              
539413 539413 AZ     school 400971 631426   ASU Preparatory Academy 40097103567 338609 ASU Preparatory Academy - Tempe   Regular School Yes High 09 12 2018   grade_1                                                   *                                              
569156 569156 AZ     school 400764 89949   ASU Preparatory Academy 40076403051 90271 ASU Preparatory Academy- Phoenix Elementary   Regular School Yes Elementary KG 04 2019   grade_1                                                   70                                             70
569157 569157 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 ASU Preparatory Academy - South Phoenix Intermediate   Regular School Yes Middle 03 07 2019   grade_1                                                   *                                              
569158 569158 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2019   grade_1                                                   *                                              
569159 569159 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 09 12 2019   grade_1                                                   *                                              
569160 569160 AZ     school 400857 91307   ASU Preparatory Academy 40085703260 91308 ASU Preparatory Academy-Polytechnic Elementary   Regular School Yes Elementary KG 04 2019   grade_1                                                   74                                             74
569161 569161 AZ     school 400890 92325   ASU Preparatory Academy 40089003367 92326 ASU Preparatory Academy - Phoenix Middle School   Regular School Yes Middle 05 08 2019   grade_1                                                   *                                              
569162 569162 AZ     school 400884 92327   ASU Preparatory Academy 40088403264 91323 ASU Preparatory Academy-Polytechnic Middle School   Regular School Yes Middle 05 08 2019   grade_1                                                   *                                              
569163 569163 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 ASU Preparatory Academy - South Phoenix Primary   Regular School Yes Elementary PK 04 2019   grade_1                                                   56                                             56
569164 569164 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 ASU Preparatory Academy - South Phoenix High School   Regular School Yes High 08 12 2019   grade_1                                                   *                                              
569165 569165 AZ     school 400971 631426   ASU Preparatory Academy 40097103567 338609 ASU Preparatory Academy - Tempe   Regular School Yes High 09 12 2019   grade_1                                                   *                                              
68976 68976 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_1                                                   *                                              
135413 135413 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_1                                                   *                                              
539414 539414 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_1                                                   *                                              
569166 569166 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_1                                                   *                                              
68977 68977 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes Other KG 12 2021   grade_1                                                   92                                             92
135414 135414 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes Other KG 12 2020   grade_1                                                   *                                              
539415 539415 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes High 09 12 2018   grade_1                                                   *                                              
569167 569167 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes High 07 12 2019   grade_1                                                   *                                              
68991 68991 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Alternative School Yes High 07 12 2021   grade_1                                                   *                                              
135428 135428 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Alternative School Yes High 07 12 2020   grade_1                                                   *                                              
539416 539416 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Regular School Yes High 07 12 2018   grade_1                                                   *                                              
569178 569178 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Regular School Yes High 07 12 2019   grade_1                                                   *                                              
68807 68807 AZ     school 400797 90199   Academy Del Sol, Inc. 40079702994 90200 Academy Del Sol   Regular School Yes Elementary KG 08 2021   grade_1                                                   36                                             36
68808 68808 AZ     school 400797 90199   Academy Del Sol, Inc. 40079703230 90770 Academy Del Sol - Hope   Regular School Yes Elementary KG 08 2021   grade_1                                                   57                                             57
135234 135234 AZ     school 400797 90199   Academy Del Sol, Inc. 40079702994 90200 Academy Del Sol   Regular School Yes Elementary KG 08 2020   grade_1                                                   24                                             24
135235 135235 AZ     school 400797 90199   Academy Del Sol, Inc. 40079703230 90770 Academy Del Sol - Hope   Regular School Yes Elementary KG 08 2020   grade_1                                                   72                                             72
539417 539417 AZ     school 400797 90199   Academy Del Sol, Inc. 40079702994 90200 Academy Del Sol   Regular School Yes Elementary KG 08 2018   grade_1                                                   20                                             20
539418 539418 AZ     school 400797 90199   Academy Del Sol, Inc. 40079703230 90770 Academy Del Sol - Hope   Regular School Yes Elementary KG 08 2018   grade_1                                                   64                                             64
569019 569019 AZ     school 400797 90199   Academy Del Sol, Inc. 40079702994 90200 Academy Del Sol   Regular School Yes Elementary KG 08 2019   grade_1                                                   11                                             11
569020 569020 AZ     school 400797 90199   Academy Del Sol, Inc. 40079703230 90770 Academy Del Sol - Hope   Regular School Yes Elementary KG 08 2019   grade_1                                                   86                                             86
539419 539419 AZ     school 400128 4296   Academy Of Excellence, Inc. 40012801715 5461 Academy Of Excellence   Regular School Yes Elementary KG 08 2018   grade_1                                                   *                                              
68809 68809 AZ     school 400414 85540   Academy of Building Industries, Inc. 40041402412 85541 Academy of Building Industries   Alternative School Yes High 09 12 2021   grade_1                                                   *                                              
135236 135236 AZ     school 400414 85540   Academy of Building Industries, Inc. 40041402412 85541 Academy of Building Industries   Alternative School Yes High 09 12 2020   grade_1                                                   *                                              
539420 539420 AZ     school 400414 85540   Academy of Building Industries, Inc. 40041402412 85541 Academy of Building Industries   Regular School Yes High 09 12 2018   grade_1                                                   *                                              
569021 569021 AZ     school 400414 85540   Academy of Building Industries, Inc. 40041402412 85541 Academy of Building Industries   Regular School Yes High 09 12 2019   grade_1                                                   *                                              
68810 68810 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_1                                                   138                                             138
68811 68811 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_1                                                   165                                             165
68812 68812 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_1                                                   197                                             197
68813 68813 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_1                                                   98                                             98
68814 68814 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_1                                                   98                                             98
68815 68815 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_1                                                   58                                             58
135237 135237 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_1                                                   167                                             167
135238 135238 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_1                                                   68                                             68
539421 539421 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_1                                                   *                                              
569022 569022 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_1                                                   77                                             77
569023 569023 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_1                                                   96                                             96
68816 68816 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_1                                                   58                                             58
68817 68817 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_1                                                   113                                             113

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