enrollments

Data source: Big Local News · About: Big Local

1,973 rows where grade = "grade_7" and state = "NM" sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 1,873 ✖
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
2955637 2955637 NM     school 3500112 505   SCHOOL OF DREAMS ACADEMY 350011201051 1 SCHOOL OF DREAMS ACADEMY Charter - High School Regular School Yes Other PK 12 2021   grade_7                                                   44                                             44
2955636 2955636 NM     school   505   SCHOOL OF DREAMS ACADEMY   998 HOMEBOUND Off-Site - Central Office           2021   grade_7                                                   0                                             0
2955635 2955635 NM     school 3502400 25   SANTA ROSA 350240000558 150 SANTA ROSA MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   42                                             42
2955634 2955634 NM     school 3502400 25   SANTA ROSA 350240000557 146 SANTA ROSA HIGH Public - High School Regular School No High 09 12 2021   grade_7                                                   0                                             0
2955633 2955633 NM     school 3502400 25   SANTA ROSA 350240000556 144 SANTA ROSA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2955632 2955632 NM     school 3502400 25   SANTA ROSA 350240000555 15 RITA A. MARQUEZ ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2955631 2955631 NM     school   25   SANTA ROSA   1 EASTERN PLAINS HEADSTART Off-Site - Prekindergarten           2021   grade_7                                                   0                                             0
2955630 2955630 NM     school 3502400 25   SANTA ROSA 350240000324 20 ANTON CHICO MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   11                                             11
2955629 2955629 NM     school   71   SANTA FE   53 ZIA BEHAVIOR PROGRAM Off-Site - Elementary School           2021   grade_7                                                   1                                             1
2955628 2955628 NM     school 3502370 71   SANTA FE 350237000553 176 WOOD-GORMLEY ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   grade_7                                                   0                                             0
2955627 2955627 NM     school 3502370 71   SANTA FE 350237000552 160 TESUQUE ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_7                                                   0                                             0
2955626 2955626 NM     school   71   SANTA FE   150 SSPS/NMSD Off-Site - Special Education           2021   grade_7                                                   0                                             0
2955625 2955625 NM     school 3502370 71   SANTA FE 350237000551 165 SANTA FE HIGH Public - High School Regular School No High 09 12 2021   grade_7                                                   0                                             0
2955624 2955624 NM     school 3502370 71   SANTA FE 350237001110 169 SANTA FE ENGAGE Public - High School Regular School No High 09 12 2021   grade_7                                                   0                                             0
2955623 2955623 NM     school 3502370 71   SANTA FE 350237000550 143 SALAZAR ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_7                                                   0                                             0
2955622 2955622 NM     school 3502370 71   SANTA FE 350237000887 23 RAMIREZ THOMAS ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2955621 2955621 NM     school 3502370 71   SANTA FE 350237000645 130 R.M. SWEENEY ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2955620 2955620 NM     school 3502370 71   SANTA FE 350237000641 100 PINON ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_7                                                   0                                             0
2955619 2955619 NM     school 3502370 71   SANTA FE 350237030025 168 NYE EARLY CHILDHOOD Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955618 2955618 NM     school 3502370 71   SANTA FE 350237001107 170 NINA OTERO COMMUNITY SCHOOL Public - Middle School Regular School No Elementary PK 08 2021   grade_7                                                   95                                             95
2955617 2955617 NM     school   71   SANTA FE   997 MISC PRIVATE Private - Non-Accredited Private School           2021   grade_7                                                   9                                             9
2955616 2955616 NM     school   71   SANTA FE   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   grade_7                                                   0                                             0
2955615 2955615 NM     school 3502370 71   SANTA FE 350237001139 189 MILAGRO MIDDLE Public - Middle School Regular School No Middle 07 08 2021   grade_7                                                   211                                             211
2955614 2955614 NM     school 3502370 71   SANTA FE 350237001106 173 MANDELA INTERNATIONAL MAGNET (MIMS) Public - High School Regular School No High 07 12 2021   grade_7                                                   58                                             58
2955613 2955613 NM     school 3502370 71   SANTA FE 350237000548 70 KEARNY ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_7                                                   0                                             0
2955612 2955612 NM     school   71   SANTA FE   998 HOMEBOUND Off-Site - Central Office           2021   grade_7                                                   0                                             0
2955611 2955611 NM     school 3502370 71   SANTA FE 350237000543 57 GONZALES ELEMENTARY Public - Elementary School Regular School No Elementary KG 08 2021   grade_7                                                   71                                             71
2955610 2955610 NM     school 3502370 71   SANTA FE 350237000542 145 FRANCIS X. NAVA ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_7                                                   0                                             0
2955609 2955609 NM     school 3502370 71   SANTA FE 350237000644 135 EL DORADO COMMUNITY SCHOOL Public - Elementary School Regular School No Elementary KG 08 2021   grade_7                                                   61                                             61
2955608 2955608 NM     school 3502370 71   SANTA FE 350237000535 11 EL CAMINO REAL ACADEMY COMMUNITY Public - Elementary School Regular School No Elementary PK 08 2021   grade_7                                                   96                                             96
2955607 2955607 NM     school 3502370 71   SANTA FE 350237000610 110 EDWARD ORTIZ MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   175                                             175
2955606 2955606 NM     school 3502370 71   SANTA FE 350237001120 166 EARLY COLLEGE OPPORTUNITIES Public - High School Regular School No High 09 12 2021   grade_7                                                   0                                             0
2955605 2955605 NM     school 3502370 71   SANTA FE 350237000541 99 E.J. MARTINEZ ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_7                                                   0                                             0
2955604 2955604 NM     school 3502370 71   SANTA FE 350237000788 12 DESERT SAGE ACADEMY Public - High School Alternative School No High 06 12 2021   grade_7                                                   2                                             2
2955603 2955603 NM     school 3502370 71   SANTA FE 350237000539 146 CHAPARRAL ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   grade_7                                                   0                                             0
2955602 2955602 NM     school 3502370 71   SANTA FE 350237000759 5 CESAR CHAVEZ ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2955601 2955601 NM     school 3502370 71   SANTA FE 350237000538 22 CARLOS GILBERT ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   grade_7                                                   0                                             0
2955600 2955600 NM     school 3502370 71   SANTA FE 350237000724 20 CAPITAL HIGH Public - High School Regular School No High 09 12 2021   grade_7                                                   0                                             0
2955599 2955599 NM     school 3502370 71   SANTA FE 350237000537 33 ATALAYA ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_7                                                   0                                             0
2955598 2955598 NM     school 3502370 71   SANTA FE 350237001059 54 ASPEN COMMUNITY SCHOOL Public - Elementary School Regular School No Elementary PK 08 2021   grade_7                                                   44                                             44
2955597 2955597 NM     school 3502370 71   SANTA FE 350237001061 141 AMY BIEHL COMMUNITY SCHOOL AT RANCHO VIEJO Public - Elementary School Regular School No Elementary KG 06 2021   grade_7                                                   0                                             0
2955596 2955596 NM     school 3502370 71   SANTA FE 350237000534 8 ACEQUIA MADRE ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   grade_7                                                   0                                             0
2955595 2955595 NM     school 3502370 71   SANTA FE 350237000841 24 ACADEMY FOR TECHNOLOGY & CLASSICS Charter - High School Regular School Yes High 07 12 2021   grade_7                                                   72                                             72
2955594 2955594 NM     school 3500172 563   SANDOVAL ACADEMY OF BILINGUAL EDUCATION 350017201116 1 SANDOVAL ACADEMY OF BILINGUAL EDUCATION Charter - Elementary School Regular School Yes Elementary KG 08 2021   grade_7                                                   9                                             9
2955593 2955593 NM     school 3502340 52   SAN JON 350234000835 1 SAN JON MIDDLE SCHOOL Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   11                                             11
2955592 2955592 NM     school 3502340 52   SAN JON 350234000533 145 SAN JON HIGH Public - High School Regular School No High 09 12 2021   grade_7                                                   0                                             0
2955591 2955591 NM     school 3502340 52   SAN JON 350234000532 144 SAN JON ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2955590 2955590 NM     school 3502310 36   RUIDOSO 350231000530 160 WHITE MOUNTAIN ELEMENTARY Public - Elementary School Regular School No Elementary 03 05 2021   grade_7                                                   0                                             0
2955589 2955589 NM     school 3502310 36   RUIDOSO 350231000464 145 SIERRA VISTA PRIMARY Public - Elementary School Regular School No Elementary PK 02 2021   grade_7                                                   0                                             0
2955588 2955588 NM     school 3502310 36   RUIDOSO 350231000531 130 RUIDOSO MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   158                                             158
2955587 2955587 NM     school 3502310 36   RUIDOSO 350231000529 139 RUIDOSO HIGH Public - High School Regular School No High 09 12 2021   grade_7                                                   0                                             0
2955586 2955586 NM     school 3502280 27   ROY 350228000527 136 ROY HIGH Public - High School Regular School No High 07 12 2021   grade_7                                                   3                                             3
2955585 2955585 NM     school 3502280 27   ROY 350228000526 135 ROY ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   grade_7                                                   0                                             0
2955584 2955584 NM     school 3502250 4   ROSWELL 350225000525 175 WASHINGTON AVE ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2955583 2955583 NM     school 3502250 4   ROSWELL 350225000524 161 VALLEY VIEW ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2955582 2955582 NM     school 3502250 4   ROSWELL 350225000696 132 UNIVERSITY HIGH Public - High School Alternative School No High 09 12 2021   grade_7                                                   0                                             0
2955581 2955581 NM     school 3502250 4   ROSWELL 350225000523 120 SUNSET ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2955580 2955580 NM     school 3502250 4   ROSWELL 350225000522 125 SIERRA MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   209                                             209
2955579 2955579 NM     school 3502250 4   ROSWELL 350225000826 9 SIDNEY GUTIERREZ MIDDLE Charter - Middle School Regular School Yes Elementary KG 08 2021   grade_7                                                   22                                             22
2955578 2955578 NM     school 3502250 4   ROSWELL 350225000521 135 ROSWELL HIGH Public - High School Regular School No High 09 12 2021   grade_7                                                   0                                             0
2955577 2955577 NM     school 3502250 4   ROSWELL 350225000520 126 PECOS ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2955576 2955576 NM     school 3502250 4   ROSWELL 350225000519 122 PARKVIEW EARLY LITERACY CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955575 2955575 NM     school 3502250 4   ROSWELL 350225000512 52 NANCY LOPEZ ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2955574 2955574 NM     school 3502250 4   ROSWELL 350225000518 36 MOUNTAIN VIEW MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   179                                             179
2955573 2955573 NM     school 3502250 4   ROSWELL 350225000517 105 MONTERREY ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2955572 2955572 NM     school 3502250 4   ROSWELL 350225000516 100 MISSOURI AVE ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2955571 2955571 NM     school   4   ROSWELL   997 MISC PRIVATE Private - Non-Accredited Private School           2021   grade_7                                                   0                                             0
2955570 2955570 NM     school 3502250 4   ROSWELL 350225000515 95 MILITARY HEIGHTS ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2955569 2955569 NM     school 3502250 4   ROSWELL 350225000514 42 MESA MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   149                                             149
2955568 2955568 NM     school   4   ROSWELL   998 HOMEBOUND Off-Site - Central Office           2021   grade_7                                                   1                                             1
2955567 2955567 NM     school 3502250 4   ROSWELL 350225000513 130 GODDARD HIGH Public - High School Regular School No High 09 12 2021   grade_7                                                   0                                             0
2955566 2955566 NM     school 3502250 4   ROSWELL 350225000511 50 EL CAPITAN ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2955565 2955565 NM     school 3502250 4   ROSWELL 350225000509 44 EAST GRAND PLAINS ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2955564 2955564 NM     school 3502250 4   ROSWELL 350225001128 133 EARLY COLLEGE HIGH SCHOOL Public - High School Regular School No High 09 12 2021   grade_7                                                   0                                             0
2955563 2955563 NM     school 3502250 4   ROSWELL 350225000508 41 DEL NORTE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2955562 2955562 NM     school 3502250 4   ROSWELL 350225000506 25 BERRENDO MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   230                                             230
2955561 2955561 NM     school 3502250 4   ROSWELL 350225000505 24 BERRENDO ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2955560 2955560 NM     school 3500176 570   ROOTS AND WINGS COMMUNITY 350017600846 1 ROOTS & WINGS COMMUNITY Charter - Middle School Regular School Yes Elementary KG 08 2021   grade_7                                                   5                                             5
2955559 2955559 NM     school 3500010 83   RIO RANCHO 350001000864 15 VISTA GRANDE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2955558 2955558 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public - Special Education Special Education School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955557 2955557 NM     school 3500010 83   RIO RANCHO 350001001039 20 SANDIA VISTA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2955556 2955556 NM     school 3500010 83   RIO RANCHO 350001000865 16 RIO RANCHO MIDDLE SCHOOL Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   407                                             407
2955555 2955555 NM     school 3500010 83   RIO RANCHO 350001000779 6 RIO RANCHO HIGH Public - High School Regular School No High 09 12 2021   grade_7                                                   0                                             0
2955554 2955554 NM     school 3500010 83   RIO RANCHO 350001000101 340 RIO RANCHO ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2955553 2955553 NM     school 3500010 83   RIO RANCHO 350001000954 18 RIO RANCHO CYBER ACADEMY Public - High School Alternative School No High 06 12 2021   grade_7                                                   18                                             18
2955552 2955552 NM     school 3500010 83   RIO RANCHO 350001000650 319 PUESTA DEL SOL ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2955551 2955551 NM     school 3500010 83   RIO RANCHO 350001000739 105 MOUNTAIN VIEW MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   296                                             296
2955550 2955550 NM     school   83   RIO RANCHO   997 MISC PRIVATE Private - Non-Accredited Private School           2021   grade_7                                                   5                                             5
2955549 2955549 NM     school 3500010 83   RIO RANCHO 350001000710 375 MARTIN KING JR ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2955548 2955548 NM     school 3500010 83   RIO RANCHO 350001000952 12 MAGGIE CORDOVA ELEMENTARY SCHOOL Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2955547 2955547 NM     school 3500010 83   RIO RANCHO 350001000682 481 LINCOLN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   298                                             298
2955546 2955546 NM     school 3500010 83   RIO RANCHO 350001001159 25 JOE HARRIS ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2955545 2955545 NM     school 3500010 83   RIO RANCHO 350001000805 13 INDEPENDENCE HIGH SCHOOL Public - High School Alternative School No High 09 12 2021   grade_7                                                   0                                             0
2955544 2955544 NM     school   83   RIO RANCHO   998 HOMEBOUND Off-Site - Central Office           2021   grade_7                                                   0                                             0
2955543 2955543 NM     school 3500010 83   RIO RANCHO 350001000736 372 ERNEST STAPLETON ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2955542 2955542 NM     school 3500010 83   RIO RANCHO 350001030011 100 ENCHANTED HILLS ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2955541 2955541 NM     school 3500010 83   RIO RANCHO 350001000761 1 EAGLE RIDGE MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   310                                             310
2955540 2955540 NM     school 3500010 83   RIO RANCHO 350001000750 50 COLINAS DEL NORTE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2955539 2955539 NM     school 3500010 83   RIO RANCHO 350001001024 11 CLEVELAND HIGH SCHOOL Public - High School Regular School No High 09 12 2021   grade_7                                                   0                                             0
2955538 2955538 NM     school 3500010 83   RIO RANCHO 350001001034 21 CIELO AZUL ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0

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