enrollments

Data source: Big Local News · About: Big Local

995 rows where grade = "grade_1", state = "NM" and year = 2020 sorted by ccd_school_lvl descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 995 ✖

grade ✖

  • grade_1 · 995 ✖
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
2542897 2542897 NM     school 3500120 22   ARTESIA 350012000130 187 ARTESIA PARK JUNIOR HIGH Public Regular School No Secondary 08 09 2020   grade_1                                                   0                                             0
2543018 2543018 NM     school 3500570 12   CLOVIS 350057000222 56 CLOVIS HS FRESHMAN ACADEMY Public Regular School No Secondary 09 09 2020   grade_1                                                   0                                             0
2543047 2543047 NM     school 3500174 562   DEAP 350017401113 1 DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE Charter Regular School Yes Secondary 06 11 2020   grade_1                                                   0                                             0
2543240 2543240 NM     school 3501260 33   HOBBS 350126000348 55 HOBBS FRESHMAN HIGH Public Regular School No Secondary 09 10 2020   grade_1                                                   0                                             0
2543356 2543356 NM     school 3501650 41   LOS ALAMOS 350165001122 79 TOPPER FRESHMAN ACADEMY Public Regular School No Secondary 09 09 2020   grade_1                                                   0                                             0
2543385 2543385 NM     school 3501740 31   LOVINGTON 350174001044 83 LOVINGTON FRESHMAN ACADEMY Public Regular School No Secondary 09 09 2020   grade_1                                                   0                                             0
2543437 2543437 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported Alternative School No Secondary 09 11 2020   grade_1                                                   0                                             0
2542960 2542960 NM     school 3500300 20   CARLSBAD 350030001148 58 HILLCREST PRESCHOOL Public Regular School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2542981 2542981 NM     school 3500390 67   CENTRAL CONS. 350039000947 24 KIRTLAND PRE-K EARLY Public Regular School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2543026 2543026 NM     school 3500570 12   CLOVIS 350057000793 3 LOS NINOS Public Regular School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2543060 2543060 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2543116 2543116 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2543117 2543117 NM     school 3500990 65   FARMINGTON 350099001091 56 FARMINGTON PRESCHOOL ACADEMY WEST Public Regular School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2543141 2543141 NM     school 3501080 19   GADSDEN 350108001132 60 ANTHONY ON-TRACK PREK CENTER Public Regular School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2543146 2543146 NM     school 3501080 19   GADSDEN 350108001131 61 CHAPARRAL ON-TRACK PREK CENTER Public Regular School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2543149 2543149 NM     school 3501080 19   GADSDEN 350108001129 62 GADSDEN ADMIN COMPLEX PREK CENTER Public Regular School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2543154 2543154 NM     school 3501080 19   GADSDEN 350108001130 63 LA MESA ON TRACK PREK CENTER Public Regular School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2543417 2543417 NM     school 3501890 81   MORIARTY-EDGEWOOD 350189001145 151 EARLY CHILDHOOD CENTER Public Regular School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2543500 2543500 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2543519 2543519 NM     school 3502250 4   ROSWELL 350225000519 122 PARKVIEW EARLY LITERACY CENTER Public Regular School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2543564 2543564 NM     school 3502370 71   SANTA FE 350237030025 168 NYE EARLY CHILDHOOD Public Regular School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2543594 2543594 NM     school 3502430 23   SILVER CITY 350243001141 12 SILVER SCHOLARS ACADEMY Public Regular School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2542686 2542686 NM     school 3500122 516   ABQ SCHOOL OF EXCELLENCE 350012201071 1 ABQ SCHOOL OF EXCELLENCE Charter Regular School Yes Other 01 12 2020   grade_1                                                   57                                             57
2542687 2542687 NM     school 3500123 517   ABQ SIGN LANGUAGE ACADEMY 350012301066 1 ABQ SIGN LANGUAGE ACADEMY Charter Regular School Yes Other KG 12 2020   grade_1                                                   10                                             10
2542737 2542737 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   grade_1                                                   0                                             0
2542741 2542741 NM     school 3500060 1   ALBUQUERQUE 350006001028 28 CORRALES INTERNATIONAL Charter Regular School Yes Other KG 12 2020   grade_1                                                   20                                             20
2542759 2542759 NM     school 3500060 1   ALBUQUERQUE 350006000854 69 EL CAMINO REAL ACADEMY Charter Regular School Yes Other KG 12 2020   grade_1                                                   29                                             29
2542760 2542760 NM     school 3500060 1   ALBUQUERQUE 350006000050 515 ELDORADO HIGH Public Regular School No Other PK 12 2020   grade_1                                                   0                                             0
2542778 2542778 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   grade_1                                                   0                                             0
2542785 2542785 NM     school 3500060 1   ALBUQUERQUE 350006001056 781 INTERNATIONAL SCHOOL AT MESA DEL SOL Charter Regular School Yes Other PK 12 2020   grade_1                                                   29                                             29
2542810 2542810 NM     school 3500060 1   ALBUQUERQUE 350006000082 530 MANZANO HIGH Public Regular School No Other PK 12 2020   grade_1                                                   0                                             0
2542828 2542828 NM     school 3500060 1   ALBUQUERQUE 350006000918 6 NATIVE AMERICAN COMMUNITY ACADEMY Charter Regular School Yes Other KG 12 2020   grade_1                                                   22                                             22
2542962 2542962 NM     school 3500300 20   CARLSBAD 350030000859 1 JEFFERSON MONTESSORI Charter Regular School Yes Other KG 12 2020   grade_1                                                   24                                             24
2542966 2542966 NM     school 3500300 20   CARLSBAD 350030001127 5 PECOS CONNECTIONS ACADEMY Charter Regular School Yes Other KG 11 2020   grade_1                                                   63                                             63
2542998 2542998 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_1                                                   0                                             0
2543020 2543020 NM     school 3500570 12   CLOVIS 350057001155 81 CMS IACADEMY AT LINCOLN JACKSON Public Regular School No Other 02 12 2020   grade_1                                                   0                                             0
2543105 2543105 NM     school 3500152 550   ESTANCIA VALLEY CLASSICAL ACADEMY 350015201085 1 ESTANCIA VALLEY CLASSICAL ACADEMY Charter Regular School Yes Other KG 12 2020   grade_1                                                   57                                             57
2543176 2543176 NM     school 3501110 43   GALLUP 350111000833 177 EDUCATION DEV CENTER Public Special Education School No Other PK 12 2020   grade_1                                                   0                                             0
2543397 2543397 NM     school 3500153 547   MCCURDY CHARTER SCHOOL 350015301083 1 MCCURDY CHARTER SCHOOL Charter Regular School Yes Other KG 12 2020   grade_1                                                   35                                             35
2543408 2543408 NM     school 3500148 542   MISSION ACHIEVEMENT AND SUCCESS 350014801089 1 MISSION ACHIEVEMENT AND SUCCESS 1.0 Charter Regular School Yes Other PK 12 2020   grade_1                                                   63                                             63
2543432 2543432 NM     school 3500160 554   NEW MEXICO CONNECTIONS ACADEMY 350016001096 1 NEW MEXICO CONNECTIONS ACADEMY Charter Regular School Yes Other 04 12 2020   grade_1                                                   0                                             0
2543444 2543444 NM     school 3500013 94   NM SCHOOL FOR THE BLIND AND VISUALLY IMP 350001300980 15 NM SCHOOL FOR THE BLIND AND VISUALLY IMPAIRED State Supported Special Education School No Other PK 12 2020   grade_1                                                   3                                             3
2543445 2543445 NM     school 3500014 93   NM SCHOOL FOR THE DEAF 350001400972 150 NM SCHOOL FOR THE DEAF State Supported Special Education School No Other PK 12 2020   grade_1                                                   4                                             4
2543583 2543583 NM     school 3500112 505   SCHOOL OF DREAMS ACADEMY 350011201051 1 SCHOOL OF DREAMS ACADEMY Charter Regular School Yes Other PK 12 2020   grade_1                                                   32                                             32
2542738 2542738 NM     school 3500060 1   ALBUQUERQUE 350006001081 706 CORAL COMMUNITY CHARTER Charter Regular School Yes Not applicable N N 2020   grade_1                                                   38                                             38
2542768 2542768 NM     school 3500060 1   ALBUQUERQUE 350006000890 707 GILBERT L SENA CHARTER HS Charter Regular School Yes Not applicable N N 2020   grade_1                                                   0                                             0
2542830 2542830 NM     school 3500060 1   ALBUQUERQUE 350006001045 708 NEW AMERICA SCHOOL Charter Regular School Yes Not applicable N N 2020   grade_1                                                   0                                             0
2542974 2542974 NM     school 3500390 67   CENTRAL CONS. 350039001102 109 DREAM DINE Charter Regular School Yes Not applicable N N 2020   grade_1                                                   2                                             2
2542691 2542691 NM     school 3500030 46   ALAMOGORDO 350003000003 33 CHAPARRAL MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542695 2542695 NM     school 3500030 46   ALAMOGORDO 350003000007 37 HOLLOMAN MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542699 2542699 NM     school 3500030 46   ALAMOGORDO 350003000798 3 MOUNTAIN VIEW MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542732 2542732 NM     school 3500060 1   ALBUQUERQUE 350006000617 407 CLEVELAND MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542746 2542746 NM     school 3500060 1   ALBUQUERQUE 350006000764 430 DESERT RIDGE MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542758 2542758 NM     school 3500060 1   ALBUQUERQUE 350006000049 480 EISENHOWER MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542762 2542762 NM     school 3500060 1   ALBUQUERQUE 350006000052 450 ERNIE PYLE MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542765 2542765 NM     school 3500060 1   ALBUQUERQUE 350006000056 410 GARFIELD MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542771 2542771 NM     school 3500060 1   ALBUQUERQUE 350006000058 413 GRANT MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542773 2542773 NM     school 3500060 1   ALBUQUERQUE 350006000060 415 HARRISON MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542775 2542775 NM     school 3500060 1   ALBUQUERQUE 350006000062 416 HAYES MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542782 2542782 NM     school 3500060 1   ALBUQUERQUE 350006000066 418 HOOVER MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542786 2542786 NM     school 3500060 1   ALBUQUERQUE 350006000068 420 JACKSON MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542787 2542787 NM     school 3500060 1   ALBUQUERQUE 350006000825 490 JAMES MONROE MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542789 2542789 NM     school 3500060 1   ALBUQUERQUE 350006000069 425 JEFFERSON MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542790 2542790 NM     school 3500060 1   ALBUQUERQUE 350006000812 445 JIMMY CARTER MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542791 2542791 NM     school 3500060 1   ALBUQUERQUE 350006000019 405 JOHN ADAMS MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542793 2542793 NM     school 3500060 1   ALBUQUERQUE 350006000071 427 KENNEDY MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542796 2542796 NM     school 3500060 1   ALBUQUERQUE 350006000065 485 L.B. JOHNSON MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542809 2542809 NM     school 3500060 1   ALBUQUERQUE 350006000081 435 MADISON MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542818 2542818 NM     school 3500060 1   ALBUQUERQUE 350006000615 440 MCKINLEY MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542841 2542841 NM     school 3500060 1   ALBUQUERQUE 350006000098 448 POLK MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542846 2542846 NM     school 3500060 1   ALBUQUERQUE 350006000102 452 ROOSEVELT MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542860 2542860 NM     school 3500060 1   ALBUQUERQUE 350006000111 455 TAFT MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542861 2542861 NM     school 3500060 1   ALBUQUERQUE 350006000112 457 TAYLOR MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542866 2542866 NM     school 3500060 1   ALBUQUERQUE 350006001047 492 TONY HILLERMAN MIDDLE SCHOOL Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542869 2542869 NM     school 3500060 1   ALBUQUERQUE 350006000114 475 TRUMAN MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542870 2542870 NM     school 3500060 1   ALBUQUERQUE 350006000811 27 TWENTY-FIRST CENTURY Charter Regular School Yes Middle 05 08 2020   grade_1                                                   0                                             0
2542873 2542873 NM     school 3500060 1   ALBUQUERQUE 350006000117 460 VAN BUREN MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542875 2542875 NM     school 3500060 1   ALBUQUERQUE 350006000856 840 VISION QUEST ALTERNATIVE MIDDLE Public Alternative School No Middle 06 08 2020   grade_1                                                   0                                             0
2542877 2542877 NM     school 3500060 1   ALBUQUERQUE 350006000118 465 WASHINGTON MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542882 2542882 NM     school 3500060 1   ALBUQUERQUE 350006000122 470 WILSON MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542894 2542894 NM     school 3500090 30   ANIMAS 350009030019 20 ANIMAS MIDDLE Public Regular School No Middle 05 06 2020   grade_1                                                   0                                             0
2542898 2542898 NM     school 3500120 22   ARTESIA 350012000134 189 ARTESIA ZIA INTERMEDIATE Public Regular School No Middle 06 07 2020   grade_1                                                   0                                             0
2542907 2542907 NM     school 3500150 64   AZTEC 350015000136 17 C.V. KOOGLER MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542917 2542917 NM     school 3500180 87   BELEN 350018000141 25 BELEN MIDDLE Public Regular School No Middle 07 08 2020   grade_1                                                   0                                             0
2542918 2542918 NM     school 3500180 87   BELEN 350018000142 34 CENTRAL ELEMENTARY Public Regular School No Middle 04 06 2020   grade_1                                                   0                                             0
2542929 2542929 NM     school 3500210 61   BERNALILLO 350021000149 26 BERNALILLO MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542931 2542931 NM     school 3500210 61   BERNALILLO 350021000727 24 COCHITI MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542937 2542937 NM     school 3500210 61   BERNALILLO 350021000154 28 SANTO DOMINGO MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542944 2542944 NM     school 3500240 66   BLOOMFIELD 350024000158 95 MESA ALTA JR HIGH Public Regular School No Middle 07 08 2020   grade_1                                                   0                                             0
2542945 2542945 NM     school 3500240 66   BLOOMFIELD 350024000651 125 NAABA ANI ELEMENTARY Public Regular School No Middle 04 06 2020   grade_1                                                   0                                             0
2542948 2542948 NM     school 3500270 40   CAPITAN 350027000544 36 CAPITAN MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542954 2542954 NM     school 3500300 20   CARLSBAD 350030000169 32 CARLSBAD INTERMEDIATE SCHOOL Public Regular School No Middle 07 08 2020   grade_1                                                   0                                             0
2542955 2542955 NM     school 3500300 20   CARLSBAD 350030000162 18 CARLSBAD SIXTH GRADE ACADEMY Public Regular School No Middle 06 06 2020   grade_1                                                   0                                             0
2542970 2542970 NM     school 3500330 37   CARRIZOZO 350033000178 157 CARRIZOZO MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542980 2542980 NM     school 3500390 67   CENTRAL CONS. 350039000180 34 KIRTLAND MIDDLE Public Regular School No Middle 07 08 2020   grade_1                                                   0                                             0
2542986 2542986 NM     school 3500390 67   CENTRAL CONS. 350039000684 126 NEWCOMB MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542991 2542991 NM     school 3500390 67   CENTRAL CONS. 350039000189 160 TSE'BIT'AI MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542994 2542994 NM     school 3500420 53   CHAMA 350042000193 42 CHAMA MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2543001 2543001 NM     school 3500480 8   CIMARRON 350048000699 36 CIMARRON MIDDLE Public Regular School No Middle 05 08 2020   grade_1                                                   0                                             0
2543003 2543003 NM     school 3500480 8   CIMARRON 350048000302 48 EAGLE NEST MIDDLE Public Regular School No Middle 05 08 2020   grade_1                                                   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]);