enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 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
2550857 2550857 NM     school 3500120 22   ARTESIA 350012000130 187 ARTESIA PARK JUNIOR HIGH Public Regular School No Secondary 08 09 2020   grade_9                                                   297                                             297
2550978 2550978 NM     school 3500570 12   CLOVIS 350057000222 56 CLOVIS HS FRESHMAN ACADEMY Public Regular School No Secondary 09 09 2020   grade_9                                                   545                                             545
2551007 2551007 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_9                                                   13                                             13
2551200 2551200 NM     school 3501260 33   HOBBS 350126000348 55 HOBBS FRESHMAN HIGH Public Regular School No Secondary 09 10 2020   grade_9                                                   761                                             761
2551316 2551316 NM     school 3501650 41   LOS ALAMOS 350165001122 79 TOPPER FRESHMAN ACADEMY Public Regular School No Secondary 09 09 2020   grade_9                                                   305                                             305
2551345 2551345 NM     school 3501740 31   LOVINGTON 350174001044 83 LOVINGTON FRESHMAN ACADEMY Public Regular School No Secondary 09 09 2020   grade_9                                                   320                                             320
2551397 2551397 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported Alternative School No Secondary 09 11 2020   grade_9                                                   1                                             1
2956925 2956925 NM     school 3500120 22   ARTESIA 350012000130 187 ARTESIA PARK JUNIOR HIGH Public - Junior High Regular School No Secondary 08 09 2021   grade_9                                                   272                                             272
2957042 2957042 NM     school 3500570 12   CLOVIS 350057000222 56 CLOVIS HS FRESHMAN ACADEMY Public - High School Regular School No Secondary 09 09 2021   grade_9                                                   613                                             613
2957069 2957069 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_9                                                   8                                             8
2957256 2957256 NM     school 3501260 33   HOBBS 350126000348 55 HOBBS FRESHMAN HIGH Public - High School Regular School No Secondary 09 10 2021   grade_9                                                   744                                             744
2957371 2957371 NM     school 3501650 41   LOS ALAMOS 350165001122 79 TOPPER FRESHMAN ACADEMY Public - High School Regular School No Secondary 09 09 2021   grade_9                                                   276                                             276
2957399 2957399 NM     school 3501740 31   LOVINGTON 350174001044 83 LOVINGTON FRESHMAN ACADEMY Public - High School Regular School No Secondary 09 09 2021   grade_9                                                   279                                             279
2957607 2957607 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_9                                                   18                                             18
2550920 2550920 NM     school 3500300 20   CARLSBAD 350030001148 58 HILLCREST PRESCHOOL Public Regular School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2550941 2550941 NM     school 3500390 67   CENTRAL CONS. 350039000947 24 KIRTLAND PRE-K EARLY Public Regular School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2550986 2550986 NM     school 3500570 12   CLOVIS 350057000793 3 LOS NINOS Public Regular School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2551020 2551020 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2551076 2551076 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2551077 2551077 NM     school 3500990 65   FARMINGTON 350099001091 56 FARMINGTON PRESCHOOL ACADEMY WEST Public Regular School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2551101 2551101 NM     school 3501080 19   GADSDEN 350108001132 60 ANTHONY ON-TRACK PREK CENTER Public Regular School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2551106 2551106 NM     school 3501080 19   GADSDEN 350108001131 61 CHAPARRAL ON-TRACK PREK CENTER Public Regular School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2551109 2551109 NM     school 3501080 19   GADSDEN 350108001129 62 GADSDEN ADMIN COMPLEX PREK CENTER Public Regular School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2551114 2551114 NM     school 3501080 19   GADSDEN 350108001130 63 LA MESA ON TRACK PREK CENTER Public Regular School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2551377 2551377 NM     school 3501890 81   MORIARTY-EDGEWOOD 350189001145 151 EARLY CHILDHOOD CENTER Public Regular School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2551460 2551460 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2551479 2551479 NM     school 3502250 4   ROSWELL 350225000519 122 PARKVIEW EARLY LITERACY CENTER Public Regular School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2551524 2551524 NM     school 3502370 71   SANTA FE 350237030025 168 NYE EARLY CHILDHOOD Public Regular School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2551554 2551554 NM     school 3502430 23   SILVER CITY 350243001141 12 SILVER SCHOLARS ACADEMY Public Regular School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2956733 2956733 NM     school 3500030 46   ALAMOGORDO 350003001158 182 STEPPING STONES PRESCHOOL Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2956989 2956989 NM     school 3500300 20   CARLSBAD 350030001148 58 HILLCREST PRESCHOOL Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2957008 2957008 NM     school 3500390 67   CENTRAL CONS. 350039000947 24 KIRTLAND PRE-K EARLY Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2957049 2957049 NM     school 3500570 12   CLOVIS 350057000793 3 LOS NINOS Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2957081 2957081 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public - Special Education Special Education School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2957135 2957135 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public - Special Education Special Education School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2957136 2957136 NM     school 3500990 65   FARMINGTON 350099001091 56 FARMINGTON PRESCHOOL ACADEMY WEST Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2957159 2957159 NM     school 3501080 19   GADSDEN 350108001132 60 ANTHONY ON-TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2957164 2957164 NM     school 3501080 19   GADSDEN 350108001131 61 CHAPARRAL ON-TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2957167 2957167 NM     school 3501080 19   GADSDEN 350108001129 62 GADSDEN ADMIN COMPLEX PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2957172 2957172 NM     school 3501080 19   GADSDEN 350108001130 63 LA MESA ON TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2957431 2957431 NM     school 3501890 81   MORIARTY-EDGEWOOD 350189001145 151 EARLY CHILDHOOD CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2957514 2957514 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public - Special Education Special Education School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2957532 2957532 NM     school 3502250 4   ROSWELL 350225000519 122 PARKVIEW EARLY LITERACY CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2957575 2957575 NM     school 3502370 71   SANTA FE 350237030025 168 NYE EARLY CHILDHOOD Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2957605 2957605 NM     school 3502430 23   SILVER CITY 350243001141 12 SILVER SCHOLARS ACADEMY Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2550646 2550646 NM     school 3500122 516   ABQ SCHOOL OF EXCELLENCE 350012201071 1 ABQ SCHOOL OF EXCELLENCE Charter Regular School Yes Other 01 12 2020   grade_9                                                   37                                             37
2550647 2550647 NM     school 3500123 517   ABQ SIGN LANGUAGE ACADEMY 350012301066 1 ABQ SIGN LANGUAGE ACADEMY Charter Regular School Yes Other KG 12 2020   grade_9                                                   2                                             2
2550697 2550697 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   grade_9                                                   3                                             3
2550701 2550701 NM     school 3500060 1   ALBUQUERQUE 350006001028 28 CORRALES INTERNATIONAL Charter Regular School Yes Other KG 12 2020   grade_9                                                   24                                             24
2550719 2550719 NM     school 3500060 1   ALBUQUERQUE 350006000854 69 EL CAMINO REAL ACADEMY Charter Regular School Yes Other KG 12 2020   grade_9                                                   22                                             22
2550720 2550720 NM     school 3500060 1   ALBUQUERQUE 350006000050 515 ELDORADO HIGH Public Regular School No Other PK 12 2020   grade_9                                                   553                                             553
2550738 2550738 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   grade_9                                                   7                                             7
2550745 2550745 NM     school 3500060 1   ALBUQUERQUE 350006001056 781 INTERNATIONAL SCHOOL AT MESA DEL SOL Charter Regular School Yes Other PK 12 2020   grade_9                                                   14                                             14
2550770 2550770 NM     school 3500060 1   ALBUQUERQUE 350006000082 530 MANZANO HIGH Public Regular School No Other PK 12 2020   grade_9                                                   456                                             456
2550788 2550788 NM     school 3500060 1   ALBUQUERQUE 350006000918 6 NATIVE AMERICAN COMMUNITY ACADEMY Charter Regular School Yes Other KG 12 2020   grade_9                                                   56                                             56
2550922 2550922 NM     school 3500300 20   CARLSBAD 350030000859 1 JEFFERSON MONTESSORI Charter Regular School Yes Other KG 12 2020   grade_9                                                   18                                             18
2550926 2550926 NM     school 3500300 20   CARLSBAD 350030001127 5 PECOS CONNECTIONS ACADEMY Charter Regular School Yes Other KG 11 2020   grade_9                                                   151                                             151
2550958 2550958 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_9                                                   4                                             4
2550980 2550980 NM     school 3500570 12   CLOVIS 350057001155 81 CMS IACADEMY AT LINCOLN JACKSON Public Regular School No Other 02 12 2020   grade_9                                                   14                                             14
2551065 2551065 NM     school 3500152 550   ESTANCIA VALLEY CLASSICAL ACADEMY 350015201085 1 ESTANCIA VALLEY CLASSICAL ACADEMY Charter Regular School Yes Other KG 12 2020   grade_9                                                   50                                             50
2551136 2551136 NM     school 3501110 43   GALLUP 350111000833 177 EDUCATION DEV CENTER Public Special Education School No Other PK 12 2020   grade_9                                                   0                                             0
2551357 2551357 NM     school 3500153 547   MCCURDY CHARTER SCHOOL 350015301083 1 MCCURDY CHARTER SCHOOL Charter Regular School Yes Other KG 12 2020   grade_9                                                   45                                             45
2551368 2551368 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_9                                                   109                                             109
2551392 2551392 NM     school 3500160 554   NEW MEXICO CONNECTIONS ACADEMY 350016001096 1 NEW MEXICO CONNECTIONS ACADEMY Charter Regular School Yes Other 04 12 2020   grade_9                                                   234                                             234
2551404 2551404 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_9                                                   3                                             3
2551405 2551405 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_9                                                   10                                             10
2551543 2551543 NM     school 3500112 505   SCHOOL OF DREAMS ACADEMY 350011201051 1 SCHOOL OF DREAMS ACADEMY Charter Regular School Yes Other PK 12 2020   grade_9                                                   57                                             57
2956717 2956717 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_9                                                   59                                             59
2956718 2956718 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_9                                                   6                                             6
2956771 2956771 NM     school 3500060 1   ALBUQUERQUE 350006001028 28 CORRALES INTERNATIONAL Charter - High School Regular School Yes Other KG 12 2021   grade_9                                                   16                                             16
2956785 2956785 NM     school 3500060 1   ALBUQUERQUE 350006001099 517 ECADEMY Public - High School Regular School No Other KG 12 2021   grade_9                                                   174                                             174
2956789 2956789 NM     school 3500060 1   ALBUQUERQUE 350006000854 69 EL CAMINO REAL ACADEMY Charter - High School Regular School Yes Other KG 12 2021   grade_9                                                   23                                             23
2956790 2956790 NM     school 3500060 1   ALBUQUERQUE 350006000050 515 ELDORADO HIGH Public - High School Regular School No Other PK 12 2021   grade_9                                                   487                                             487
2956808 2956808 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public - Special Education Special Education School No Other PK 12 2021   grade_9                                                   2                                             2
2956815 2956815 NM     school 3500060 1   ALBUQUERQUE 350006001056 781 INTERNATIONAL SCHOOL AT MESA DEL SOL Charter - High School Regular School Yes Other PK 12 2021   grade_9                                                   18                                             18
2956840 2956840 NM     school 3500060 1   ALBUQUERQUE 350006000082 530 MANZANO HIGH Public - High School Regular School No Other PK 12 2021   grade_9                                                   469                                             469
2956858 2956858 NM     school 3500060 1   ALBUQUERQUE 350006000918 6 NATIVE AMERICAN COMMUNITY ACADEMY Charter - High School Regular School Yes Other KG 12 2021   grade_9                                                   73                                             73
2956991 2956991 NM     school 3500300 20   CARLSBAD 350030000859 1 JEFFERSON MONTESSORI Charter - High School Regular School Yes Other KG 12 2021   grade_9                                                   14                                             14
2956994 2956994 NM     school 3500300 20   CARLSBAD 350030001127 5 PECOS CONNECTIONS ACADEMY Charter - High School Regular School Yes Other KG 12 2021   grade_9                                                   160                                             160
2957043 2957043 NM     school 3500570 12   CLOVIS 350057001155 81 CMS IACADEMY AT LINCOLN JACKSON Public - High School Regular School No Other 02 12 2021   grade_9                                                   7                                             7
2957124 2957124 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_9                                                   41                                             41
2957411 2957411 NM     school 3500153 547   MCCURDY CHARTER SCHOOL 350015301083 1 MCCURDY CHARTER SCHOOL Charter - High School Regular School Yes Other KG 12 2021   grade_9                                                   47                                             47
2957422 2957422 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_9                                                   102                                             102
2957446 2957446 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_9                                                   237                                             237
2957457 2957457 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_9                                                   0                                             0
2957458 2957458 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_9                                                   9                                             9
2957593 2957593 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_9                                                   50                                             50
2957668 2957668 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   grade_9                                                   3                                             3
2550698 2550698 NM     school 3500060 1   ALBUQUERQUE 350006001081 706 CORAL COMMUNITY CHARTER Charter Regular School Yes Not applicable N N 2020   grade_9                                                   0                                             0
2550728 2550728 NM     school 3500060 1   ALBUQUERQUE 350006000890 707 GILBERT L SENA CHARTER HS Charter Regular School Yes Not applicable N N 2020   grade_9                                                   73                                             73
2550790 2550790 NM     school 3500060 1   ALBUQUERQUE 350006001045 708 NEW AMERICA SCHOOL Charter Regular School Yes Not applicable N N 2020   grade_9                                                   41                                             41
2550934 2550934 NM     school 3500390 67   CENTRAL CONS. 350039001102 109 DREAM DINE Charter Regular School Yes Not applicable N N 2020   grade_9                                                   0                                             0
2550651 2550651 NM     school 3500030 46   ALAMOGORDO 350003000003 33 CHAPARRAL MIDDLE Public Regular School No Middle 06 08 2020   grade_9                                                   0                                             0
2550655 2550655 NM     school 3500030 46   ALAMOGORDO 350003000007 37 HOLLOMAN MIDDLE Public Regular School No Middle 06 08 2020   grade_9                                                   0                                             0
2550659 2550659 NM     school 3500030 46   ALAMOGORDO 350003000798 3 MOUNTAIN VIEW MIDDLE Public Regular School No Middle 06 08 2020   grade_9                                                   0                                             0
2550692 2550692 NM     school 3500060 1   ALBUQUERQUE 350006000617 407 CLEVELAND MIDDLE Public Regular School No Middle 06 08 2020   grade_9                                                   0                                             0
2550706 2550706 NM     school 3500060 1   ALBUQUERQUE 350006000764 430 DESERT RIDGE MIDDLE Public Regular School No Middle 06 08 2020   grade_9                                                   0                                             0
2550718 2550718 NM     school 3500060 1   ALBUQUERQUE 350006000049 480 EISENHOWER MIDDLE Public Regular School No Middle 06 08 2020   grade_9                                                   0                                             0
2550722 2550722 NM     school 3500060 1   ALBUQUERQUE 350006000052 450 ERNIE PYLE MIDDLE Public Regular School No Middle 06 08 2020   grade_9                                                   0                                             0
2550725 2550725 NM     school 3500060 1   ALBUQUERQUE 350006000056 410 GARFIELD MIDDLE Public Regular School No Middle 06 08 2020   grade_9                                                   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]);