enrollments

Data source: Big Local News · About: Big Local

1,973 rows where grade = "grade_12" and state = "NM" sorted by ccd_school_lvl descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_12 · 1,973 ✖
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
2553842 2553842 NM     school 3500120 22   ARTESIA 350012000130 187 ARTESIA PARK JUNIOR HIGH Public Regular School No Secondary 08 09 2020   grade_12                                                   0                                             0
2553963 2553963 NM     school 3500570 12   CLOVIS 350057000222 56 CLOVIS HS FRESHMAN ACADEMY Public Regular School No Secondary 09 09 2020   grade_12                                                   0                                             0
2553992 2553992 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_12                                                   0                                             0
2554185 2554185 NM     school 3501260 33   HOBBS 350126000348 55 HOBBS FRESHMAN HIGH Public Regular School No Secondary 09 10 2020   grade_12                                                   0                                             0
2554301 2554301 NM     school 3501650 41   LOS ALAMOS 350165001122 79 TOPPER FRESHMAN ACADEMY Public Regular School No Secondary 09 09 2020   grade_12                                                   0                                             0
2554330 2554330 NM     school 3501740 31   LOVINGTON 350174001044 83 LOVINGTON FRESHMAN ACADEMY Public Regular School No Secondary 09 09 2020   grade_12                                                   0                                             0
2554382 2554382 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported Alternative School No Secondary 09 11 2020   grade_12                                                   0                                             0
2959859 2959859 NM     school 3500120 22   ARTESIA 350012000130 187 ARTESIA PARK JUNIOR HIGH Public - Junior High Regular School No Secondary 08 09 2021   grade_12                                                   0                                             0
2959976 2959976 NM     school 3500570 12   CLOVIS 350057000222 56 CLOVIS HS FRESHMAN ACADEMY Public - High School Regular School No Secondary 09 09 2021   grade_12                                                   0                                             0
2960003 2960003 NM     school 3500174 562   DEAP 350017401113 1 DZIT DIT LOOL SCHOOL OF EMPOWERMENT ACTION AND PERSEVERANCE Charter - High School Regular School Yes Secondary 06 11 2021   grade_12                                                   3                                             3
2960190 2960190 NM     school 3501260 33   HOBBS 350126000348 55 HOBBS FRESHMAN HIGH Public - High School Regular School No Secondary 09 10 2021   grade_12                                                   0                                             0
2960305 2960305 NM     school 3501650 41   LOS ALAMOS 350165001122 79 TOPPER FRESHMAN ACADEMY Public - High School Regular School No Secondary 09 09 2021   grade_12                                                   0                                             0
2960333 2960333 NM     school 3501740 31   LOVINGTON 350174001044 83 LOVINGTON FRESHMAN ACADEMY Public - High School Regular School No Secondary 09 09 2021   grade_12                                                   0                                             0
2960541 2960541 NM     school 3500177 568   SIX DIRECTIONS INDIGENOUS SCHOOL 350017701126 1 SIX DIRECTIONS INDIGENOUS SCHOOL Charter - High School Regular School Yes Secondary 06 11 2021   grade_12                                                   0                                             0
2553905 2553905 NM     school 3500300 20   CARLSBAD 350030001148 58 HILLCREST PRESCHOOL Public Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2553926 2553926 NM     school 3500390 67   CENTRAL CONS. 350039000947 24 KIRTLAND PRE-K EARLY Public Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2553971 2553971 NM     school 3500570 12   CLOVIS 350057000793 3 LOS NINOS Public Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2554005 2554005 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2554061 2554061 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2554062 2554062 NM     school 3500990 65   FARMINGTON 350099001091 56 FARMINGTON PRESCHOOL ACADEMY WEST Public Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2554086 2554086 NM     school 3501080 19   GADSDEN 350108001132 60 ANTHONY ON-TRACK PREK CENTER Public Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2554091 2554091 NM     school 3501080 19   GADSDEN 350108001131 61 CHAPARRAL ON-TRACK PREK CENTER Public Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2554094 2554094 NM     school 3501080 19   GADSDEN 350108001129 62 GADSDEN ADMIN COMPLEX PREK CENTER Public Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2554099 2554099 NM     school 3501080 19   GADSDEN 350108001130 63 LA MESA ON TRACK PREK CENTER Public Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2554362 2554362 NM     school 3501890 81   MORIARTY-EDGEWOOD 350189001145 151 EARLY CHILDHOOD CENTER Public Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2554445 2554445 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2554464 2554464 NM     school 3502250 4   ROSWELL 350225000519 122 PARKVIEW EARLY LITERACY CENTER Public Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2554509 2554509 NM     school 3502370 71   SANTA FE 350237030025 168 NYE EARLY CHILDHOOD Public Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2554539 2554539 NM     school 3502430 23   SILVER CITY 350243001141 12 SILVER SCHOLARS ACADEMY Public Regular School No Prekindergarten PK PK 2020   grade_12                                                   0                                             0
2959667 2959667 NM     school 3500030 46   ALAMOGORDO 350003001158 182 STEPPING STONES PRESCHOOL Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2959923 2959923 NM     school 3500300 20   CARLSBAD 350030001148 58 HILLCREST PRESCHOOL Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2959942 2959942 NM     school 3500390 67   CENTRAL CONS. 350039000947 24 KIRTLAND PRE-K EARLY Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2959983 2959983 NM     school 3500570 12   CLOVIS 350057000793 3 LOS NINOS Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2960015 2960015 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public - Special Education Special Education School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2960069 2960069 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public - Special Education Special Education School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2960070 2960070 NM     school 3500990 65   FARMINGTON 350099001091 56 FARMINGTON PRESCHOOL ACADEMY WEST Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2960093 2960093 NM     school 3501080 19   GADSDEN 350108001132 60 ANTHONY ON-TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2960098 2960098 NM     school 3501080 19   GADSDEN 350108001131 61 CHAPARRAL ON-TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2960101 2960101 NM     school 3501080 19   GADSDEN 350108001129 62 GADSDEN ADMIN COMPLEX PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2960106 2960106 NM     school 3501080 19   GADSDEN 350108001130 63 LA MESA ON TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2960365 2960365 NM     school 3501890 81   MORIARTY-EDGEWOOD 350189001145 151 EARLY CHILDHOOD CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2960448 2960448 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public - Special Education Special Education School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2960466 2960466 NM     school 3502250 4   ROSWELL 350225000519 122 PARKVIEW EARLY LITERACY CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2960509 2960509 NM     school 3502370 71   SANTA FE 350237030025 168 NYE EARLY CHILDHOOD Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2960539 2960539 NM     school 3502430 23   SILVER CITY 350243001141 12 SILVER SCHOLARS ACADEMY Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2553631 2553631 NM     school 3500122 516   ABQ SCHOOL OF EXCELLENCE 350012201071 1 ABQ SCHOOL OF EXCELLENCE Charter Regular School Yes Other 01 12 2020   grade_12                                                   19                                             19
2553632 2553632 NM     school 3500123 517   ABQ SIGN LANGUAGE ACADEMY 350012301066 1 ABQ SIGN LANGUAGE ACADEMY Charter Regular School Yes Other KG 12 2020   grade_12                                                   6                                             6
2553682 2553682 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   grade_12                                                   0                                             0
2553686 2553686 NM     school 3500060 1   ALBUQUERQUE 350006001028 28 CORRALES INTERNATIONAL Charter Regular School Yes Other KG 12 2020   grade_12                                                   8                                             8
2553704 2553704 NM     school 3500060 1   ALBUQUERQUE 350006000854 69 EL CAMINO REAL ACADEMY Charter Regular School Yes Other KG 12 2020   grade_12                                                   11                                             11
2553705 2553705 NM     school 3500060 1   ALBUQUERQUE 350006000050 515 ELDORADO HIGH Public Regular School No Other PK 12 2020   grade_12                                                   364                                             364
2553723 2553723 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   grade_12                                                   8                                             8
2553730 2553730 NM     school 3500060 1   ALBUQUERQUE 350006001056 781 INTERNATIONAL SCHOOL AT MESA DEL SOL Charter Regular School Yes Other PK 12 2020   grade_12                                                   3                                             3
2553755 2553755 NM     school 3500060 1   ALBUQUERQUE 350006000082 530 MANZANO HIGH Public Regular School No Other PK 12 2020   grade_12                                                   293                                             293
2553773 2553773 NM     school 3500060 1   ALBUQUERQUE 350006000918 6 NATIVE AMERICAN COMMUNITY ACADEMY Charter Regular School Yes Other KG 12 2020   grade_12                                                   45                                             45
2553907 2553907 NM     school 3500300 20   CARLSBAD 350030000859 1 JEFFERSON MONTESSORI Charter Regular School Yes Other KG 12 2020   grade_12                                                   11                                             11
2553911 2553911 NM     school 3500300 20   CARLSBAD 350030001127 5 PECOS CONNECTIONS ACADEMY Charter Regular School Yes Other KG 11 2020   grade_12                                                   0                                             0
2553943 2553943 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_12                                                   2                                             2
2553965 2553965 NM     school 3500570 12   CLOVIS 350057001155 81 CMS IACADEMY AT LINCOLN JACKSON Public Regular School No Other 02 12 2020   grade_12                                                   13                                             13
2554050 2554050 NM     school 3500152 550   ESTANCIA VALLEY CLASSICAL ACADEMY 350015201085 1 ESTANCIA VALLEY CLASSICAL ACADEMY Charter Regular School Yes Other KG 12 2020   grade_12                                                   14                                             14
2554121 2554121 NM     school 3501110 43   GALLUP 350111000833 177 EDUCATION DEV CENTER Public Special Education School No Other PK 12 2020   grade_12                                                   0                                             0
2554342 2554342 NM     school 3500153 547   MCCURDY CHARTER SCHOOL 350015301083 1 MCCURDY CHARTER SCHOOL Charter Regular School Yes Other KG 12 2020   grade_12                                                   38                                             38
2554353 2554353 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_12                                                   52                                             52
2554377 2554377 NM     school 3500160 554   NEW MEXICO CONNECTIONS ACADEMY 350016001096 1 NEW MEXICO CONNECTIONS ACADEMY Charter Regular School Yes Other 04 12 2020   grade_12                                                   169                                             169
2554389 2554389 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_12                                                   3                                             3
2554390 2554390 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_12                                                   15                                             15
2554528 2554528 NM     school 3500112 505   SCHOOL OF DREAMS ACADEMY 350011201051 1 SCHOOL OF DREAMS ACADEMY Charter Regular School Yes Other PK 12 2020   grade_12                                                   42                                             42
2959651 2959651 NM     school 3500122 516   ABQ SCHOOL OF EXCELLENCE 350012201071 1 ABQ SCHOOL OF EXCELLENCE Charter - High School Regular School Yes Other KG 12 2021   grade_12                                                   17                                             17
2959652 2959652 NM     school 3500123 517   ABQ SIGN LANGUAGE ACADEMY 350012301066 1 ABQ SIGN LANGUAGE ACADEMY Charter - High School Regular School Yes Other KG 12 2021   grade_12                                                   9                                             9
2959705 2959705 NM     school 3500060 1   ALBUQUERQUE 350006001028 28 CORRALES INTERNATIONAL Charter - High School Regular School Yes Other KG 12 2021   grade_12                                                   3                                             3
2959719 2959719 NM     school 3500060 1   ALBUQUERQUE 350006001099 517 ECADEMY Public - High School Regular School No Other KG 12 2021   grade_12                                                   175                                             175
2959723 2959723 NM     school 3500060 1   ALBUQUERQUE 350006000854 69 EL CAMINO REAL ACADEMY Charter - High School Regular School Yes Other KG 12 2021   grade_12                                                   11                                             11
2959724 2959724 NM     school 3500060 1   ALBUQUERQUE 350006000050 515 ELDORADO HIGH Public - High School Regular School No Other PK 12 2021   grade_12                                                   377                                             377
2959742 2959742 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public - Special Education Special Education School No Other PK 12 2021   grade_12                                                   6                                             6
2959749 2959749 NM     school 3500060 1   ALBUQUERQUE 350006001056 781 INTERNATIONAL SCHOOL AT MESA DEL SOL Charter - High School Regular School Yes Other PK 12 2021   grade_12                                                   4                                             4
2959774 2959774 NM     school 3500060 1   ALBUQUERQUE 350006000082 530 MANZANO HIGH Public - High School Regular School No Other PK 12 2021   grade_12                                                   280                                             280
2959792 2959792 NM     school 3500060 1   ALBUQUERQUE 350006000918 6 NATIVE AMERICAN COMMUNITY ACADEMY Charter - High School Regular School Yes Other KG 12 2021   grade_12                                                   33                                             33
2959925 2959925 NM     school 3500300 20   CARLSBAD 350030000859 1 JEFFERSON MONTESSORI Charter - High School Regular School Yes Other KG 12 2021   grade_12                                                   13                                             13
2959928 2959928 NM     school 3500300 20   CARLSBAD 350030001127 5 PECOS CONNECTIONS ACADEMY Charter - High School Regular School Yes Other KG 12 2021   grade_12                                                   107                                             107
2959977 2959977 NM     school 3500570 12   CLOVIS 350057001155 81 CMS IACADEMY AT LINCOLN JACKSON Public - High School Regular School No Other 02 12 2021   grade_12                                                   23                                             23
2960058 2960058 NM     school 3500152 550   ESTANCIA VALLEY CLASSICAL ACADEMY 350015201085 1 ESTANCIA VALLEY CLASSICAL ACADEMY Charter - High School Regular School Yes Other KG 12 2021   grade_12                                                   26                                             26
2960345 2960345 NM     school 3500153 547   MCCURDY CHARTER SCHOOL 350015301083 1 MCCURDY CHARTER SCHOOL Charter - High School Regular School Yes Other KG 12 2021   grade_12                                                   32                                             32
2960356 2960356 NM     school 3500148 542   MISSION ACHIEVEMENT AND SUCCESS 350014801089 1 MISSION ACHIEVEMENT AND SUCCESS 1.0 Charter - High School Regular School Yes Other PK 12 2021   grade_12                                                   68                                             68
2960380 2960380 NM     school 3500160 554   NEW MEXICO CONNECTIONS ACADEMY 350016001096 1 NEW MEXICO CONNECTIONS ACADEMY Charter - High School Regular School Yes Other 04 12 2021   grade_12                                                   164                                             164
2960391 2960391 NM     school 3500013 94   NM SCHOOL FOR THE BLIND AND VISUALLY IMP 350001300980 15 NM SCHOOL FOR THE BLIND AND VISUALLY IMPAIRED State Supported - State Supported Special Education School No Other PK 12 2021   grade_12                                                   6                                             6
2960392 2960392 NM     school 3500014 93   NM SCHOOL FOR THE DEAF 350001400972 150 NM SCHOOL FOR THE DEAF State Supported - State Supported Special Education School No Other PK 12 2021   grade_12                                                   11                                             11
2960527 2960527 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_12                                                   35                                             35
2960602 2960602 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   grade_12                                                   4                                             4
2553683 2553683 NM     school 3500060 1   ALBUQUERQUE 350006001081 706 CORAL COMMUNITY CHARTER Charter Regular School Yes Not applicable N N 2020   grade_12                                                   0                                             0
2553713 2553713 NM     school 3500060 1   ALBUQUERQUE 350006000890 707 GILBERT L SENA CHARTER HS Charter Regular School Yes Not applicable N N 2020   grade_12                                                   29                                             29
2553775 2553775 NM     school 3500060 1   ALBUQUERQUE 350006001045 708 NEW AMERICA SCHOOL Charter Regular School Yes Not applicable N N 2020   grade_12                                                   37                                             37
2553919 2553919 NM     school 3500390 67   CENTRAL CONS. 350039001102 109 DREAM DINE Charter Regular School Yes Not applicable N N 2020   grade_12                                                   0                                             0
2553636 2553636 NM     school 3500030 46   ALAMOGORDO 350003000003 33 CHAPARRAL MIDDLE Public Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2553640 2553640 NM     school 3500030 46   ALAMOGORDO 350003000007 37 HOLLOMAN MIDDLE Public Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2553644 2553644 NM     school 3500030 46   ALAMOGORDO 350003000798 3 MOUNTAIN VIEW MIDDLE Public Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2553677 2553677 NM     school 3500060 1   ALBUQUERQUE 350006000617 407 CLEVELAND MIDDLE Public Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2553691 2553691 NM     school 3500060 1   ALBUQUERQUE 350006000764 430 DESERT RIDGE MIDDLE Public Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2553703 2553703 NM     school 3500060 1   ALBUQUERQUE 350006000049 480 EISENHOWER MIDDLE Public Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2553707 2553707 NM     school 3500060 1   ALBUQUERQUE 350006000052 450 ERNIE PYLE MIDDLE Public Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2553710 2553710 NM     school 3500060 1   ALBUQUERQUE 350006000056 410 GARFIELD MIDDLE Public Regular School No Middle 06 08 2020   grade_12                                                   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]);