Data source: Big Local News · About: Big Local

29,625 rows where state = "AZ" and year = 2018 sorted by ccd_school_high_grade descending

View and edit SQL

grade

year

  • 2018 · 29,625
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
536693 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   24                                             24
538668 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   kindergarten                                                   *                                              
540643 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_1                                                   *                                              
542618 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_2                                                   *                                              
544593 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_3                                                   *                                              
546568 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_4                                                   *                                              
548543 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_5                                                   *                                              
550518 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_6                                                   *                                              
552493 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_7                                                   *                                              
554468 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_8                                                   *                                              
556443 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_9                                                   *                                              
558418 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_10                                                   *                                              
560393 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_11                                                   *                                              
562368 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   grade_12                                                   *                                              
564343 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   pk_12_total 16 * *   * *     *   *   * 14     *             *   24 16                         14                 24
535578 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes Not Applicable N N 2018   pre_kindergarten                                                   *                                              
537553 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes Not Applicable N N 2018   kindergarten                                                   *                                              
539528 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes Not Applicable N N 2018   grade_1                                                   *                                              
541503 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes Not Applicable N N 2018   grade_2                                                   *                                              
543478 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes Not Applicable N N 2018   grade_3                                                   *                                              
545453 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes Not Applicable N N 2018   grade_4                                                   *                                              
547428 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes Not Applicable N N 2018   grade_5                                                   *                                              
549403 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes Not Applicable N N 2018   grade_6                                                   *                                              
551378 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes Not Applicable N N 2018   grade_7                                                   *                                              
553353 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes Not Applicable N N 2018   grade_8                                                   *                                              
555328 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes Not Applicable N N 2018   grade_9                                                   15                                             15
557303 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes Not Applicable N N 2018   grade_10                                                   12                                             12
559278 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes Not Applicable N N 2018   grade_11                                                   *                                              
561253 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes Not Applicable N N 2018   grade_12                                                   *                                              
563228 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes Not Applicable N N 2018   pk_12_total 25 * 11   * *     *   *   13 28     *             *   41 25   11                   13 28                 41
536549 AZ     school 404970 4235   Mesa Unified District 40497003377 92351 Jordan Center for Early Education   Regular School No Elementary PK KG 2018   pre_kindergarten                                                   263                                             263
536620 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2018   pre_kindergarten                                                   *                                              
538524 AZ     school 404970 4235   Mesa Unified District 40497003377 92351 Jordan Center for Early Education   Regular School No Elementary PK KG 2018   kindergarten                                                   *                                              
538595 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2018   kindergarten                                                   13                                             13
540499 AZ     school 404970 4235   Mesa Unified District 40497003377 92351 Jordan Center for Early Education   Regular School No Elementary PK KG 2018   grade_1                                                   *                                              
540570 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2018   grade_1                                                   *                                              
542474 AZ     school 404970 4235   Mesa Unified District 40497003377 92351 Jordan Center for Early Education   Regular School No Elementary PK KG 2018   grade_2                                                   *                                              
542545 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2018   grade_2                                                   *                                              
544449 AZ     school 404970 4235   Mesa Unified District 40497003377 92351 Jordan Center for Early Education   Regular School No Elementary PK KG 2018   grade_3                                                   *                                              
544520 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2018   grade_3                                                   *                                              
546424 AZ     school 404970 4235   Mesa Unified District 40497003377 92351 Jordan Center for Early Education   Regular School No Elementary PK KG 2018   grade_4                                                   *                                              
546495 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2018   grade_4                                                   *                                              
548399 AZ     school 404970 4235   Mesa Unified District 40497003377 92351 Jordan Center for Early Education   Regular School No Elementary PK KG 2018   grade_5                                                   *                                              
548470 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2018   grade_5                                                   *                                              
550374 AZ     school 404970 4235   Mesa Unified District 40497003377 92351 Jordan Center for Early Education   Regular School No Elementary PK KG 2018   grade_6                                                   *                                              
550445 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2018   grade_6                                                   *                                              
552349 AZ     school 404970 4235   Mesa Unified District 40497003377 92351 Jordan Center for Early Education   Regular School No Elementary PK KG 2018   grade_7                                                   *                                              
552420 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2018   grade_7                                                   *                                              
554324 AZ     school 404970 4235   Mesa Unified District 40497003377 92351 Jordan Center for Early Education   Regular School No Elementary PK KG 2018   grade_8                                                   *                                              
554395 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2018   grade_8                                                   *                                              
556299 AZ     school 404970 4235   Mesa Unified District 40497003377 92351 Jordan Center for Early Education   Regular School No Elementary PK KG 2018   grade_9                                                   *                                              
556370 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2018   grade_9                                                   *                                              
558274 AZ     school 404970 4235   Mesa Unified District 40497003377 92351 Jordan Center for Early Education   Regular School No Elementary PK KG 2018   grade_10                                                   *                                              
558345 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2018   grade_10                                                   *                                              
560249 AZ     school 404970 4235   Mesa Unified District 40497003377 92351 Jordan Center for Early Education   Regular School No Elementary PK KG 2018   grade_11                                                   *                                              
560320 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2018   grade_11                                                   *                                              
562224 AZ     school 404970 4235   Mesa Unified District 40497003377 92351 Jordan Center for Early Education   Regular School No Elementary PK KG 2018   grade_12                                                   *                                              
562295 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2018   grade_12                                                   *                                              
564199 AZ     school 404970 4235   Mesa Unified District 40497003377 92351 Jordan Center for Early Education   Regular School No Elementary PK KG 2018   pk_12_total 127 14 102   * *     *   14   179 88     *             218   267 127 14 102               14   179 88             218   267
564270 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2018   pk_12_total * * *   * *     *   *   * *     *             *   13                                             13
535452 AZ     school 400274 79053   AIBT Non-Profit Charter High School - Phoenix 40027402020 79123 RCB Medical Arts Academy   Regular School Yes High 07 12 2018   pre_kindergarten                                                   *                                              
535453 AZ     school 400970 449790   AIBT Non-Profit Charter High School, Inc. 40097003546 742847 RCB College Preparatory Academy   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535455 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 Phoenix Collegiate Academy Charter School   Regular School Yes Other PK 12 2018   pre_kindergarten                                                   *                                              
535456 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535457 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535462 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 Phoenix Collegiate Academy High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535463 AZ     school 400971 631426   ASU Preparatory Academy 40097103567 338609 ASU Preparatory Academy - Tempe   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535464 AZ     school 400947 92987   ASU Preparatory Academy - Casa Grande 40094703526 635758 ASU Preparatory Academy - Casa Grande HS   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535465 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535466 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Regular School Yes High 07 12 2018   pre_kindergarten                                                   *                                              
535470 AZ     school 400414 85540   Academy of Building Industries, Inc. 40041402412 85541 Academy of Building Industries   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535472 AZ     school 400368 79961   Academy of Mathematics and Science, Inc. 40036802037 79094 Academy of Math and Science   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535475 AZ     school 400202 78897   Academy of Tucson, Inc. 40020201959 78898 Academy of Tucson High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535477 AZ     school 400276 79213   Academy with Community Partners Inc 40027601841 10795 Academy with Community Partners   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535478 AZ     school 400129 6364   Accelerated Elementary and Secondary Schools 40012901790 5891 Accelerated Learning Laboratory   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535479 AZ     school 400121 4297   Accelerated Learning Center, Inc. 40012101581 5462 Accelerated Learning Center   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535483 AZ     school 400450 4289   Agua Fria Union High School District 40045000001 5454 Agua Fria High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535484 AZ     school 400450 4289   Agua Fria Union High School District 40045002273 79799 Desert Edge High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535485 AZ     school 400450 4289   Agua Fria Union High School District 40045001884 78926 Millennium High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535486 AZ     school 400450 4289   Agua Fria Union High School District 40045002592 87903 Verrado High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535489 AZ     school 400520 4409   Ajo Unified District 40052003063 6292 Ajo High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535512 AZ     school 400619 80995   American Charter Schools Foundation d.b.a. Alta Vista High School 40061903097 80996 Alta Vista High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535513 AZ     school 400357 79883   American Charter Schools Foundation d.b.a. Apache Trail High School 40035701732 6346 Apache Trail High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535514 AZ     school 400385 79874   American Charter Schools Foundation d.b.a. Crestview College Preparatory High Sc 40038502016 78813 Crestview College Preparatory High School   Regular School Yes High 07 12 2018   pre_kindergarten                                                   *                                              
535515 AZ     school 400384 79872   American Charter Schools Foundation d.b.a. Desert Hills High School 40038401899 78901 Desert Hills High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535516 AZ     school 400352 79873   American Charter Schools Foundation d.b.a. Estrella High School 40035201898 78900 Estrella High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535517 AZ     school 400353 79875   American Charter Schools Foundation d.b.a. Peoria Accelerated High School 40035301896 78817 Peoria Accelerated High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535518 AZ     school 400618 80989   American Charter Schools Foundation d.b.a. South Pointe High School 40061803095 80990 South Pointe High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535519 AZ     school 400447 88334   American Charter Schools Foundation d.b.a. South Ridge High School 40044702671 88335 South Ridge High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535520 AZ     school 400354 79877   American Charter Schools Foundation d.b.a. Sun Valley High School 40035401733 6347 Sun Valley High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535521 AZ     school 400355 79879   American Charter Schools Foundation d.b.a. West Phoenix High School 40035501734 6348 West Phoenix High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   *                                              
535523 AZ     school 400130 6365   American Heritage Academy 40013001803 6366 American Heritage Academy - Cottonwood   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535527 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203475 92885 American Leadership Academy - Ironwood   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535528 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203179 90769 American Leadership Academy - Queen Creek   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535531 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203573 509281 American Leadership Academy, Gilbert   Regular School Yes Other KG 12 2018   pre_kindergarten                                                   *                                              
535533 AZ     school 400329 79461   American Virtual Academy 40032903159 81178 Primavera - Online   Regular School Yes High 06 12 2018   pre_kindergarten                                                   *                                              
535534 AZ     school 400680 4406   Amphitheater Unified District 40068003330 91755 Amphi Academy at El Hogar   Regular School No Other KG 12 2018   pre_kindergarten                                                   *                                              
535535 AZ     school 400680 4406   Amphitheater Unified District 40068000032 6055 Amphitheater High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535537 AZ     school 400680 4406   Amphitheater Unified District 40068000033 5808 Canyon Del Oro High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              
535543 AZ     school 400680 4406   Amphitheater Unified District 40068002198 79378 Ironwood Ridge High School   Regular School No High 09 12 2018   pre_kindergarten                                                   *                                              

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);