enrollments

Data source: Big Local News · About: Big Local

995 rows where grade = "grade_1", state = "NM" and year = 2020 sorted by school_state_type 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
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
2543275 2543275 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported Alternative School No High 09 12 2020   grade_1                                                   0                                             0
2543276 2543276 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported Alternative School No High 06 12 2020   grade_1                                                   0                                             0
2543277 2543277 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported Alternative School No High 06 12 2020   grade_1                                                   0                                             0
2543433 2543433 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_1                                                   0                                             0
2543434 2543434 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_1                                                   0                                             0
2543435 2543435 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_1                                                   0                                             0
2543436 2543436 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 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
2543438 2543438 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported Alternative School No High 08 12 2020   grade_1                                                   0                                             0
2543439 2543439 NM     school 3500012 91   NM CORRECTIONS 350001200970 5 ROSWELL CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_1                                                   0                                             0
2543440 2543440 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_1                                                   0                                             0
2543441 2543441 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_1                                                   0                                             0
2543442 2543442 NM     school 3500012 91   NM CORRECTIONS 350001200979 8 WESTERN NM CORRECTIONS State Supported Alternative School No High 08 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
2543584 2543584 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_1                                                   0                                             0
2542688 2542688 NM     school 3500030 46   ALAMOGORDO 350003000799 4 ACADEMY DEL SOL ALT. Public Alternative School No High 10 12 2020   grade_1                                                   0                                             0
2542689 2542689 NM     school 3500030 46   ALAMOGORDO 350003000001 15 ALAMOGORDO HIGH Public Regular School No High 09 12 2020   grade_1                                                   0                                             0
2542690 2542690 NM     school 3500030 46   ALAMOGORDO 350003000002 28 BUENA VISTA ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_1                                                   31                                             31
2542691 2542691 NM     school 3500030 46   ALAMOGORDO 350003000003 33 CHAPARRAL MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542692 2542692 NM     school 3500030 46   ALAMOGORDO 350003000012 144 DESERT STAR ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   74                                             74
2542693 2542693 NM     school 3500030 46   ALAMOGORDO 350003000005 57 HIGH ROLLS MOUNTAIN PARK ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_1                                                   4                                             4
2542694 2542694 NM     school 3500030 46   ALAMOGORDO 350003000006 58 HOLLOMAN ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   87                                             87
2542695 2542695 NM     school 3500030 46   ALAMOGORDO 350003000007 37 HOLLOMAN MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542697 2542697 NM     school 3500030 46   ALAMOGORDO 350003000008 72 LA LUZ ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_1                                                   43                                             43
2542699 2542699 NM     school 3500030 46   ALAMOGORDO 350003000798 3 MOUNTAIN VIEW MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542700 2542700 NM     school 3500030 46   ALAMOGORDO 350003000010 114 NORTH ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   45                                             45
2542701 2542701 NM     school 3500030 46   ALAMOGORDO 350003000013 150 SIERRA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   48                                             48
2542702 2542702 NM     school 3500030 46   ALAMOGORDO 350003000004 56 SUNSET HILLS ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_1                                                   81                                             81
2542703 2542703 NM     school 3500030 46   ALAMOGORDO 350003000016 181 YUCCA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   61                                             61
2542704 2542704 NM     school 3500060 1   ALBUQUERQUE 350006000017 321 A. MONTOYA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   78                                             78
2542707 2542707 NM     school 3500060 1   ALBUQUERQUE 350006000020 206 ADOBE ACRES ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   45                                             45
2542708 2542708 NM     school 3500060 1   ALBUQUERQUE 350006000021 207 ALAMEDA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   40                                             40
2542709 2542709 NM     school 3500060 1   ALBUQUERQUE 350006000022 210 ALAMOSA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   55                                             55
2542710 2542710 NM     school 3500060 1   ALBUQUERQUE 350006000024 590 ALBUQUERQUE HIGH Public Regular School No High 09 12 2020   grade_1                                                   0                                             0
2542712 2542712 NM     school 3500060 1   ALBUQUERQUE 350006000025 213 ALVARADO ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_1                                                   59                                             59
2542713 2542713 NM     school 3500060 1   ALBUQUERQUE 350006000026 214 APACHE ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   49                                             49
2542714 2542714 NM     school 3500060 1   ALBUQUERQUE 350006000027 215 ARMIJO ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   45                                             45
2542715 2542715 NM     school 3500060 1   ALBUQUERQUE 350006000028 329 ARROYO DEL OSO ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   71                                             71
2542716 2542716 NM     school 3500060 1   ALBUQUERQUE 350006000029 216 ATRISCO ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   44                                             44
2542717 2542717 NM     school 3500060 1   ALBUQUERQUE 350006001037 576 ATRISCO HERITAGE ACADEMY HS Public Regular School No High 09 12 2020   grade_1                                                   0                                             0
2542718 2542718 NM     school 3500060 1   ALBUQUERQUE 350006000030 222 BANDELIER ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_1                                                   86                                             86
2542719 2542719 NM     school 3500060 1   ALBUQUERQUE 350006000031 225 BARCELONA ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_1                                                   60                                             60
2542720 2542720 NM     school 3500060 1   ALBUQUERQUE 350006000032 228 BEL-AIR ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   36                                             36
2542721 2542721 NM     school 3500060 1   ALBUQUERQUE 350006000033 229 BELLEHAVEN ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   62                                             62
2542724 2542724 NM     school 3500060 1   ALBUQUERQUE 350006000035 339 CARLOS REY ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   79                                             79
2542725 2542725 NM     school 3500060 1   ALBUQUERQUE 350006000642 295 CHAMIZA ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_1                                                   61                                             61
2542726 2542726 NM     school 3500060 1   ALBUQUERQUE 350006000036 234 CHAPARRAL ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   99                                             99
2542727 2542727 NM     school 3500060 1   ALBUQUERQUE 350006000037 236 CHELWOOD ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_1                                                   90                                             90
2542730 2542730 NM     school 3500060 1   ALBUQUERQUE 350006000038 580 CIBOLA HIGH Public Regular School No High 09 12 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
2542733 2542733 NM     school 3500060 1   ALBUQUERQUE 350006000040 237 COCHITI ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   35                                             35
2542734 2542734 NM     school 3500060 1   ALBUQUERQUE 350006001100 591 COLLEGE AND CAREER HIGH SCHOOL Public Regular School No High 09 12 2020   grade_1                                                   0                                             0
2542735 2542735 NM     school 3500060 1   ALBUQUERQUE 350006000041 240 COLLET PARK ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   51                                             51
2542736 2542736 NM     school 3500060 1   ALBUQUERQUE 350006000042 241 COMANCHE ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   58                                             58
2542737 2542737 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   grade_1                                                   0                                             0
2542739 2542739 NM     school 3500060 1   ALBUQUERQUE 350006001054 243 CORONADO ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_1                                                   45                                             45
2542740 2542740 NM     school 3500060 1   ALBUQUERQUE 350006000107 351 CORRALES ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_1                                                   60                                             60
2542743 2542743 NM     school 3500060 1   ALBUQUERQUE 350006001133 952 COYOTE WILLOW FAMILY SCHOOL Public Alternative School No Elementary KG 08 2020   grade_1                                                   26                                             26
2542744 2542744 NM     school 3500060 1   ALBUQUERQUE 350006000044 514 DEL NORTE HIGH Public Regular School No High 09 12 2020   grade_1                                                   0                                             0
2542745 2542745 NM     school 3500060 1   ALBUQUERQUE 350006000681 203 DENNIS CHAVEZ ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   102                                             102
2542746 2542746 NM     school 3500060 1   ALBUQUERQUE 350006000764 430 DESERT RIDGE MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542747 2542747 NM     school 3500060 1   ALBUQUERQUE 350006000273 900 DESERT WILLOW FAMILY SCHOOL Public Alternative School No Elementary KG 08 2020   grade_1                                                   39                                             39
2542749 2542749 NM     school 3500060 1   ALBUQUERQUE 350006000045 244 DOLORES GONZALES ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   59                                             59
2542750 2542750 NM     school 3500060 1   ALBUQUERQUE 350006000752 350 DOUBLE EAGLE ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   85                                             85
2542751 2542751 NM     school 3500060 1   ALBUQUERQUE 350006000047 249 DURANES ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_1                                                   18                                             18
2542752 2542752 NM     school 3500060 1   ALBUQUERQUE 350006000916 593 EARLY COLLEGE ACADEMY Public Alternative School No High 09 12 2020   grade_1                                                   0                                             0
2542754 2542754 NM     school 3500060 1   ALBUQUERQUE 350006000048 252 EAST SAN JOSE ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   66                                             66
2542755 2542755 NM     school 3500060 1   ALBUQUERQUE 350006001099 517 ECADEMY VIRTUAL HIGH SCHOOL Public Regular School No High 09 12 2020   grade_1                                                   0                                             0
2542756 2542756 NM     school 3500060 1   ALBUQUERQUE 350006000647 219 EDMUND G ROSS ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   73                                             73
2542757 2542757 NM     school 3500060 1   ALBUQUERQUE 350006000896 262 EDWARD GONZALES ELEMENTARY Public Regular School No Elementary 03 05 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
2542760 2542760 NM     school 3500060 1   ALBUQUERQUE 350006000050 515 ELDORADO HIGH Public Regular School No Other PK 12 2020   grade_1                                                   0                                             0
2542761 2542761 NM     school 3500060 1   ALBUQUERQUE 350006000051 255 EMERSON ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   70                                             70
2542762 2542762 NM     school 3500060 1   ALBUQUERQUE 350006000052 450 ERNIE PYLE MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542763 2542763 NM     school 3500060 1   ALBUQUERQUE 350006000054 261 EUGENE FIELD ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   22                                             22
2542764 2542764 NM     school 3500060 1   ALBUQUERQUE 350006000055 596 FREEDOM HIGH Public Alternative School No High 09 12 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
2542766 2542766 NM     school 3500060 1   ALBUQUERQUE 350006001114 496 GEORGE I SANCHEZ Public Regular School No Elementary PK 08 2020   grade_1                                                   81                                             81
2542767 2542767 NM     school 3500060 1   ALBUQUERQUE 350006000726 328 GEORGIA O'KEEFFE ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_1                                                   110                                             110
2542770 2542770 NM     school 3500060 1   ALBUQUERQUE 350006000057 230 GOV BENT ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   70                                             70
2542771 2542771 NM     school 3500060 1   ALBUQUERQUE 350006000058 413 GRANT MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542772 2542772 NM     school 3500060 1   ALBUQUERQUE 350006000059 267 GRIEGOS ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_1                                                   56                                             56
2542773 2542773 NM     school 3500060 1   ALBUQUERQUE 350006000060 415 HARRISON MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542774 2542774 NM     school 3500060 1   ALBUQUERQUE 350006000061 270 HAWTHORNE ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   50                                             50
2542775 2542775 NM     school 3500060 1   ALBUQUERQUE 350006000062 416 HAYES MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542777 2542777 NM     school 3500060 1   ALBUQUERQUE 350006001043 395 HELEN CORDERO PRIMARY Public Regular School No Elementary PK 02 2020   grade_1                                                   135                                             135
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
2542779 2542779 NM     school 3500060 1   ALBUQUERQUE 350006000063 520 HIGHLAND HIGH Public Regular School No High 09 12 2020   grade_1                                                   0                                             0
2542780 2542780 NM     school 3500060 1   ALBUQUERQUE 350006000064 273 HODGIN ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   81                                             81
2542782 2542782 NM     school 3500060 1   ALBUQUERQUE 350006000066 418 HOOVER MIDDLE Public Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2542783 2542783 NM     school 3500060 1   ALBUQUERQUE 350006000616 221 HUBERT H HUMPHREY ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   92                                             92
2542784 2542784 NM     school 3500060 1   ALBUQUERQUE 350006000067 276 INEZ ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_1                                                   64                                             64
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
2542788 2542788 NM     school 3500060 1   ALBUQUERQUE 350006000053 258 JANET KAHN FINE ARTS ACADEMY Public Regular School No Elementary PK 05 2020   grade_1                                                   68                                             68
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

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