enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 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
137483 137483 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_2                                                   *                                              
541376 541376 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_2                                                   *                                              
570989 570989 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_2                                                   *                                              
71122 71122 AZ     school 400998 1000166   A+ Charter Schools 40099803681 1000972 A+ Charter Schools   Regular School Yes High 07 12 2021   grade_2                                                   *                                              
71138 71138 AZ     school   7355   ACCEL   91260 ACCEL Buckeye Learning Center             2021   grade_2                                                   *                                              
71139 71139 AZ     school   7355   ACCEL   7360 ACCEL East Campus             2021   grade_2                                                   *                                              
71140 71140 AZ     school   7355   ACCEL   7356 ACCEL Metro Campus             2021   grade_2                                                   *                                              
137495 137495 AZ     school   7355   ACCEL   91260 ACCEL Buckeye Learning Center             2020   grade_2                                                   *                                              
137496 137496 AZ     school   7355   ACCEL   7360 ACCEL East Campus             2020   grade_2                                                   *                                              
137497 137497 AZ     school   7355   ACCEL   7356 ACCEL Metro Campus             2020   grade_2                                                   *                                              
137498 137498 AZ     school   7355   ACCEL   1000307 ACCEL Ruth Fisher Campus             2020   grade_2                                                   *                                              
71152 71152 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_2                                                   *                                              
137510 137510 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_2                                                   *                                              
541377 541377 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_2                                                   *                                              
571012 571012 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_2                                                   *                                              
71153 71153 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_2                                                   *                                              
137511 137511 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_2                                                   *                                              
541378 541378 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_2                                                   *                                              
571013 571013 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_2                                                   *                                              
71233 71233 AZ     school 400989 92980   ARCHES Academy 40098903642 1000276 ARCHES Academy   Regular School Yes Elementary KG 08 2021   grade_2                                                   *                                              
137590 137590 AZ     school 400989 92980   ARCHES Academy 40098903642 1000276 ARCHES Academy   Regular School Yes Elementary KG 07 2020   grade_2                                                   *                                              
71274 71274 AZ     school   89922   ASCEND (Autism Spectrum Center for Educational and Neurological Development)   89923 ASCEND (Autism Spectrum Center for Educational and Neurological Development)             2021   grade_2                                                   *                                              
137644 137644 AZ     school   89922   ASCEND (Autism Spectrum Center for Educational and Neurological Development)   89923 ASCEND (Autism Spectrum Center for Educational and Neurological Development)             2020   grade_2                                                   *                                              
71283 71283 AZ     school 400890 92325   ASU Preparatory Academy 40089003367 92326 ASU Preparatory Academy - Phoenix Middle School   Regular School Yes Middle 05 08 2021   grade_2                                                   *                                              
71284 71284 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 ASU Preparatory Academy - South Phoenix High School   Regular School Yes High 07 12 2021   grade_2                                                   *                                              
71285 71285 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 ASU Preparatory Academy - South Phoenix Intermediate   Regular School Yes Elementary 03 06 2021   grade_2                                                   *                                              
71286 71286 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 ASU Preparatory Academy - South Phoenix Primary   Regular School Yes Elementary PK 04 2021   grade_2                                                   34                                             34
71287 71287 AZ     school 400764 89949   ASU Preparatory Academy 40076403051 90271 ASU Preparatory Academy- Phoenix Elementary   Regular School Yes Elementary KG 04 2021   grade_2                                                   102                                             102
71288 71288 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2021   grade_2                                                   *                                              
71289 71289 AZ     school 400857 91307   ASU Preparatory Academy 40085703260 91308 ASU Preparatory Academy-Polytechnic Elementary   Regular School Yes Elementary KG 04 2021   grade_2                                                   98                                             98
71290 71290 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 08 12 2021   grade_2                                                   *                                              
71291 71291 AZ     school 400884 92327   ASU Preparatory Academy 40088403264 91323 ASU Preparatory Academy-Polytechnic Middle School   Regular School Yes Middle 05 07 2021   grade_2                                                   *                                              
137653 137653 AZ     school 400890 92325   ASU Preparatory Academy 40089003367 92326 ASU Preparatory Academy - Phoenix Middle School   Regular School Yes Middle 05 08 2020   grade_2                                                   *                                              
137654 137654 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 ASU Preparatory Academy - South Phoenix High School   Regular School Yes High 07 12 2020   grade_2                                                   *                                              
137655 137655 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 ASU Preparatory Academy - South Phoenix Intermediate   Regular School Yes Elementary 03 06 2020   grade_2                                                   *                                              
137656 137656 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 ASU Preparatory Academy - South Phoenix Primary   Regular School Yes Elementary PK 04 2020   grade_2                                                   49                                             49
137657 137657 AZ     school 400971 631426   ASU Preparatory Academy 40097103567 338609 ASU Preparatory Academy - Tempe   Regular School Yes High 09 12 2020   grade_2                                                   *                                              
137658 137658 AZ     school 400764 89949   ASU Preparatory Academy 40076403051 90271 ASU Preparatory Academy- Phoenix Elementary   Regular School Yes Elementary KG 04 2020   grade_2                                                   108                                             108
137659 137659 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2020   grade_2                                                   *                                              
137660 137660 AZ     school 400857 91307   ASU Preparatory Academy 40085703260 91308 ASU Preparatory Academy-Polytechnic Elementary   Regular School Yes Elementary KG 04 2020   grade_2                                                   73                                             73
137661 137661 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 08 12 2020   grade_2                                                   *                                              
137662 137662 AZ     school 400884 92327   ASU Preparatory Academy 40088403264 91323 ASU Preparatory Academy-Polytechnic Middle School   Regular School Yes Middle 05 07 2020   grade_2                                                   *                                              
541379 541379 AZ     school 400764 89949   ASU Preparatory Academy 40076403051 90271 ASU Preparatory Academy- Phoenix Elementary   Regular School Yes Elementary KG 04 2018   grade_2                                                   72                                             72
541380 541380 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 Phoenix Collegiate Academy Charter School   Regular School Yes Other PK 12 2018   grade_2                                                   *                                              
541381 541381 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2018   grade_2                                                   *                                              
541382 541382 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 09 12 2018   grade_2                                                   *                                              
541383 541383 AZ     school 400857 91307   ASU Preparatory Academy 40085703260 91308 ASU Preparatory Academy-Polytechnic Elementary   Regular School Yes Elementary KG 04 2018   grade_2                                                   76                                             76
541384 541384 AZ     school 400890 92325   ASU Preparatory Academy 40089003367 92326 ASU Preparatory Academy - Phoenix Middle School   Regular School Yes Middle 05 08 2018   grade_2                                                   *                                              
541385 541385 AZ     school 400884 92327   ASU Preparatory Academy 40088403264 91323 ASU Preparatory Academy-Polytechnic Middle School   Regular School Yes Middle 05 08 2018   grade_2                                                   *                                              
541386 541386 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 Phoenix Collegiate Academy Elementary, LLC   Regular School Yes Elementary KG 04 2018   grade_2                                                   35                                             35
541387 541387 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 Phoenix Collegiate Academy High School   Regular School Yes High 09 12 2018   grade_2                                                   *                                              
541388 541388 AZ     school 400971 631426   ASU Preparatory Academy 40097103567 338609 ASU Preparatory Academy - Tempe   Regular School Yes High 09 12 2018   grade_2                                                   *                                              
571127 571127 AZ     school 400764 89949   ASU Preparatory Academy 40076403051 90271 ASU Preparatory Academy- Phoenix Elementary   Regular School Yes Elementary KG 04 2019   grade_2                                                   74                                             74
571128 571128 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 ASU Preparatory Academy - South Phoenix Intermediate   Regular School Yes Middle 03 07 2019   grade_2                                                   *                                              
571129 571129 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2019   grade_2                                                   *                                              
571130 571130 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 09 12 2019   grade_2                                                   *                                              
571131 571131 AZ     school 400857 91307   ASU Preparatory Academy 40085703260 91308 ASU Preparatory Academy-Polytechnic Elementary   Regular School Yes Elementary KG 04 2019   grade_2                                                   73                                             73
571132 571132 AZ     school 400890 92325   ASU Preparatory Academy 40089003367 92326 ASU Preparatory Academy - Phoenix Middle School   Regular School Yes Middle 05 08 2019   grade_2                                                   *                                              
571133 571133 AZ     school 400884 92327   ASU Preparatory Academy 40088403264 91323 ASU Preparatory Academy-Polytechnic Middle School   Regular School Yes Middle 05 08 2019   grade_2                                                   *                                              
571134 571134 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 ASU Preparatory Academy - South Phoenix Primary   Regular School Yes Elementary PK 04 2019   grade_2                                                   45                                             45
571135 571135 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 ASU Preparatory Academy - South Phoenix High School   Regular School Yes High 08 12 2019   grade_2                                                   *                                              
571136 571136 AZ     school 400971 631426   ASU Preparatory Academy 40097103567 338609 ASU Preparatory Academy - Tempe   Regular School Yes High 09 12 2019   grade_2                                                   *                                              
71292 71292 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_2                                                   *                                              
137663 137663 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_2                                                   *                                              
541389 541389 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_2                                                   *                                              
571137 571137 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_2                                                   *                                              
71293 71293 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes Other KG 12 2021   grade_2                                                   126                                             126
137664 137664 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes Other KG 12 2020   grade_2                                                   *                                              
541390 541390 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes High 09 12 2018   grade_2                                                   *                                              
571138 571138 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes High 07 12 2019   grade_2                                                   *                                              
71307 71307 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Alternative School Yes High 07 12 2021   grade_2                                                   *                                              
137678 137678 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Alternative School Yes High 07 12 2020   grade_2                                                   *                                              
541391 541391 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Regular School Yes High 07 12 2018   grade_2                                                   *                                              
571149 571149 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Regular School Yes High 07 12 2019   grade_2                                                   *                                              
71123 71123 AZ     school 400797 90199   Academy Del Sol, Inc. 40079702994 90200 Academy Del Sol   Regular School Yes Elementary KG 08 2021   grade_2                                                   17                                             17
71124 71124 AZ     school 400797 90199   Academy Del Sol, Inc. 40079703230 90770 Academy Del Sol - Hope   Regular School Yes Elementary KG 08 2021   grade_2                                                   62                                             62
137484 137484 AZ     school 400797 90199   Academy Del Sol, Inc. 40079702994 90200 Academy Del Sol   Regular School Yes Elementary KG 08 2020   grade_2                                                   17                                             17
137485 137485 AZ     school 400797 90199   Academy Del Sol, Inc. 40079703230 90770 Academy Del Sol - Hope   Regular School Yes Elementary KG 08 2020   grade_2                                                   65                                             65
541392 541392 AZ     school 400797 90199   Academy Del Sol, Inc. 40079702994 90200 Academy Del Sol   Regular School Yes Elementary KG 08 2018   grade_2                                                   14                                             14
541393 541393 AZ     school 400797 90199   Academy Del Sol, Inc. 40079703230 90770 Academy Del Sol - Hope   Regular School Yes Elementary KG 08 2018   grade_2                                                   60                                             60
570990 570990 AZ     school 400797 90199   Academy Del Sol, Inc. 40079702994 90200 Academy Del Sol   Regular School Yes Elementary KG 08 2019   grade_2                                                   19                                             19
570991 570991 AZ     school 400797 90199   Academy Del Sol, Inc. 40079703230 90770 Academy Del Sol - Hope   Regular School Yes Elementary KG 08 2019   grade_2                                                   72                                             72
541394 541394 AZ     school 400128 4296   Academy Of Excellence, Inc. 40012801715 5461 Academy Of Excellence   Regular School Yes Elementary KG 08 2018   grade_2                                                   *                                              
71125 71125 AZ     school 400414 85540   Academy of Building Industries, Inc. 40041402412 85541 Academy of Building Industries   Alternative School Yes High 09 12 2021   grade_2                                                   *                                              
137486 137486 AZ     school 400414 85540   Academy of Building Industries, Inc. 40041402412 85541 Academy of Building Industries   Alternative School Yes High 09 12 2020   grade_2                                                   *                                              
541395 541395 AZ     school 400414 85540   Academy of Building Industries, Inc. 40041402412 85541 Academy of Building Industries   Regular School Yes High 09 12 2018   grade_2                                                   *                                              
570992 570992 AZ     school 400414 85540   Academy of Building Industries, Inc. 40041402412 85541 Academy of Building Industries   Regular School Yes High 09 12 2019   grade_2                                                   *                                              
71126 71126 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_2                                                   116                                             116
71127 71127 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_2                                                   161                                             161
71128 71128 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_2                                                   170                                             170
71129 71129 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_2                                                   90                                             90
71130 71130 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_2                                                   93                                             93
71131 71131 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_2                                                   61                                             61
137487 137487 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_2                                                   135                                             135
137488 137488 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_2                                                   67                                             67
541396 541396 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_2                                                   *                                              
570993 570993 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_2                                                   78                                             78
570994 570994 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_2                                                   117                                             117
71132 71132 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_2                                                   99                                             99
71133 71133 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_2                                                   132                                             132

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