enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 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
2548867 2548867 NM     school 3500120 22   ARTESIA 350012000130 187 ARTESIA PARK JUNIOR HIGH Public Regular School No Secondary 08 09 2020   grade_7                                                   0                                             0
2548988 2548988 NM     school 3500570 12   CLOVIS 350057000222 56 CLOVIS HS FRESHMAN ACADEMY Public Regular School No Secondary 09 09 2020   grade_7                                                   0                                             0
2549017 2549017 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_7                                                   11                                             11
2549210 2549210 NM     school 3501260 33   HOBBS 350126000348 55 HOBBS FRESHMAN HIGH Public Regular School No Secondary 09 10 2020   grade_7                                                   0                                             0
2549326 2549326 NM     school 3501650 41   LOS ALAMOS 350165001122 79 TOPPER FRESHMAN ACADEMY Public Regular School No Secondary 09 09 2020   grade_7                                                   0                                             0
2549355 2549355 NM     school 3501740 31   LOVINGTON 350174001044 83 LOVINGTON FRESHMAN ACADEMY Public Regular School No Secondary 09 09 2020   grade_7                                                   0                                             0
2549407 2549407 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported Alternative School No Secondary 09 11 2020   grade_7                                                   0                                             0
2954969 2954969 NM     school 3500120 22   ARTESIA 350012000130 187 ARTESIA PARK JUNIOR HIGH Public - Junior High Regular School No Secondary 08 09 2021   grade_7                                                   0                                             0
2955086 2955086 NM     school 3500570 12   CLOVIS 350057000222 56 CLOVIS HS FRESHMAN ACADEMY Public - High School Regular School No Secondary 09 09 2021   grade_7                                                   0                                             0
2955113 2955113 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_7                                                   4                                             4
2955300 2955300 NM     school 3501260 33   HOBBS 350126000348 55 HOBBS FRESHMAN HIGH Public - High School Regular School No Secondary 09 10 2021   grade_7                                                   0                                             0
2955415 2955415 NM     school 3501650 41   LOS ALAMOS 350165001122 79 TOPPER FRESHMAN ACADEMY Public - High School Regular School No Secondary 09 09 2021   grade_7                                                   0                                             0
2955443 2955443 NM     school 3501740 31   LOVINGTON 350174001044 83 LOVINGTON FRESHMAN ACADEMY Public - High School Regular School No Secondary 09 09 2021   grade_7                                                   0                                             0
2955651 2955651 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_7                                                   9                                             9
2548930 2548930 NM     school 3500300 20   CARLSBAD 350030001148 58 HILLCREST PRESCHOOL Public Regular School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2548951 2548951 NM     school 3500390 67   CENTRAL CONS. 350039000947 24 KIRTLAND PRE-K EARLY Public Regular School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2548996 2548996 NM     school 3500570 12   CLOVIS 350057000793 3 LOS NINOS Public Regular School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2549030 2549030 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2549086 2549086 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2549087 2549087 NM     school 3500990 65   FARMINGTON 350099001091 56 FARMINGTON PRESCHOOL ACADEMY WEST Public Regular School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2549111 2549111 NM     school 3501080 19   GADSDEN 350108001132 60 ANTHONY ON-TRACK PREK CENTER Public Regular School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2549116 2549116 NM     school 3501080 19   GADSDEN 350108001131 61 CHAPARRAL ON-TRACK PREK CENTER Public Regular School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2549119 2549119 NM     school 3501080 19   GADSDEN 350108001129 62 GADSDEN ADMIN COMPLEX PREK CENTER Public Regular School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2549124 2549124 NM     school 3501080 19   GADSDEN 350108001130 63 LA MESA ON TRACK PREK CENTER Public Regular School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2549387 2549387 NM     school 3501890 81   MORIARTY-EDGEWOOD 350189001145 151 EARLY CHILDHOOD CENTER Public Regular School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2549470 2549470 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2549489 2549489 NM     school 3502250 4   ROSWELL 350225000519 122 PARKVIEW EARLY LITERACY CENTER Public Regular School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2549534 2549534 NM     school 3502370 71   SANTA FE 350237030025 168 NYE EARLY CHILDHOOD Public Regular School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2549564 2549564 NM     school 3502430 23   SILVER CITY 350243001141 12 SILVER SCHOLARS ACADEMY Public Regular School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2954777 2954777 NM     school 3500030 46   ALAMOGORDO 350003001158 182 STEPPING STONES PRESCHOOL Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955033 2955033 NM     school 3500300 20   CARLSBAD 350030001148 58 HILLCREST PRESCHOOL Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955052 2955052 NM     school 3500390 67   CENTRAL CONS. 350039000947 24 KIRTLAND PRE-K EARLY Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955093 2955093 NM     school 3500570 12   CLOVIS 350057000793 3 LOS NINOS Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955125 2955125 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public - Special Education Special Education School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955179 2955179 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public - Special Education Special Education School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955180 2955180 NM     school 3500990 65   FARMINGTON 350099001091 56 FARMINGTON PRESCHOOL ACADEMY WEST Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955203 2955203 NM     school 3501080 19   GADSDEN 350108001132 60 ANTHONY ON-TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955208 2955208 NM     school 3501080 19   GADSDEN 350108001131 61 CHAPARRAL ON-TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955211 2955211 NM     school 3501080 19   GADSDEN 350108001129 62 GADSDEN ADMIN COMPLEX PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955216 2955216 NM     school 3501080 19   GADSDEN 350108001130 63 LA MESA ON TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955475 2955475 NM     school 3501890 81   MORIARTY-EDGEWOOD 350189001145 151 EARLY CHILDHOOD CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955558 2955558 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public - Special Education Special Education School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955576 2955576 NM     school 3502250 4   ROSWELL 350225000519 122 PARKVIEW EARLY LITERACY CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955619 2955619 NM     school 3502370 71   SANTA FE 350237030025 168 NYE EARLY CHILDHOOD Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2955649 2955649 NM     school 3502430 23   SILVER CITY 350243001141 12 SILVER SCHOLARS ACADEMY Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2548656 2548656 NM     school 3500122 516   ABQ SCHOOL OF EXCELLENCE 350012201071 1 ABQ SCHOOL OF EXCELLENCE Charter Regular School Yes Other 01 12 2020   grade_7                                                   95                                             95
2548657 2548657 NM     school 3500123 517   ABQ SIGN LANGUAGE ACADEMY 350012301066 1 ABQ SIGN LANGUAGE ACADEMY Charter Regular School Yes Other KG 12 2020   grade_7                                                   11                                             11
2548707 2548707 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   grade_7                                                   0                                             0
2548711 2548711 NM     school 3500060 1   ALBUQUERQUE 350006001028 28 CORRALES INTERNATIONAL Charter Regular School Yes Other KG 12 2020   grade_7                                                   28                                             28
2548729 2548729 NM     school 3500060 1   ALBUQUERQUE 350006000854 69 EL CAMINO REAL ACADEMY Charter Regular School Yes Other KG 12 2020   grade_7                                                   34                                             34
2548730 2548730 NM     school 3500060 1   ALBUQUERQUE 350006000050 515 ELDORADO HIGH Public Regular School No Other PK 12 2020   grade_7                                                   0                                             0
2548748 2548748 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   grade_7                                                   3                                             3
2548755 2548755 NM     school 3500060 1   ALBUQUERQUE 350006001056 781 INTERNATIONAL SCHOOL AT MESA DEL SOL Charter Regular School Yes Other PK 12 2020   grade_7                                                   38                                             38
2548780 2548780 NM     school 3500060 1   ALBUQUERQUE 350006000082 530 MANZANO HIGH Public Regular School No Other PK 12 2020   grade_7                                                   0                                             0
2548798 2548798 NM     school 3500060 1   ALBUQUERQUE 350006000918 6 NATIVE AMERICAN COMMUNITY ACADEMY Charter Regular School Yes Other KG 12 2020   grade_7                                                   56                                             56
2548932 2548932 NM     school 3500300 20   CARLSBAD 350030000859 1 JEFFERSON MONTESSORI Charter Regular School Yes Other KG 12 2020   grade_7                                                   17                                             17
2548936 2548936 NM     school 3500300 20   CARLSBAD 350030001127 5 PECOS CONNECTIONS ACADEMY Charter Regular School Yes Other KG 11 2020   grade_7                                                   149                                             149
2548968 2548968 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_7                                                   5                                             5
2548990 2548990 NM     school 3500570 12   CLOVIS 350057001155 81 CMS IACADEMY AT LINCOLN JACKSON Public Regular School No Other 02 12 2020   grade_7                                                   6                                             6
2549075 2549075 NM     school 3500152 550   ESTANCIA VALLEY CLASSICAL ACADEMY 350015201085 1 ESTANCIA VALLEY CLASSICAL ACADEMY Charter Regular School Yes Other KG 12 2020   grade_7                                                   47                                             47
2549146 2549146 NM     school 3501110 43   GALLUP 350111000833 177 EDUCATION DEV CENTER Public Special Education School No Other PK 12 2020   grade_7                                                   0                                             0
2549367 2549367 NM     school 3500153 547   MCCURDY CHARTER SCHOOL 350015301083 1 MCCURDY CHARTER SCHOOL Charter Regular School Yes Other KG 12 2020   grade_7                                                   50                                             50
2549378 2549378 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_7                                                   125                                             125
2549402 2549402 NM     school 3500160 554   NEW MEXICO CONNECTIONS ACADEMY 350016001096 1 NEW MEXICO CONNECTIONS ACADEMY Charter Regular School Yes Other 04 12 2020   grade_7                                                   127                                             127
2549414 2549414 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_7                                                   2                                             2
2549415 2549415 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_7                                                   11                                             11
2549553 2549553 NM     school 3500112 505   SCHOOL OF DREAMS ACADEMY 350011201051 1 SCHOOL OF DREAMS ACADEMY Charter Regular School Yes Other PK 12 2020   grade_7                                                   38                                             38
2954761 2954761 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_7                                                   119                                             119
2954762 2954762 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_7                                                   9                                             9
2954815 2954815 NM     school 3500060 1   ALBUQUERQUE 350006001028 28 CORRALES INTERNATIONAL Charter - High School Regular School Yes Other KG 12 2021   grade_7                                                   25                                             25
2954829 2954829 NM     school 3500060 1   ALBUQUERQUE 350006001099 517 ECADEMY Public - High School Regular School No Other KG 12 2021   grade_7                                                   233                                             233
2954833 2954833 NM     school 3500060 1   ALBUQUERQUE 350006000854 69 EL CAMINO REAL ACADEMY Charter - High School Regular School Yes Other KG 12 2021   grade_7                                                   29                                             29
2954834 2954834 NM     school 3500060 1   ALBUQUERQUE 350006000050 515 ELDORADO HIGH Public - High School Regular School No Other PK 12 2021   grade_7                                                   0                                             0
2954852 2954852 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public - Special Education Special Education School No Other PK 12 2021   grade_7                                                   2                                             2
2954859 2954859 NM     school 3500060 1   ALBUQUERQUE 350006001056 781 INTERNATIONAL SCHOOL AT MESA DEL SOL Charter - High School Regular School Yes Other PK 12 2021   grade_7                                                   35                                             35
2954884 2954884 NM     school 3500060 1   ALBUQUERQUE 350006000082 530 MANZANO HIGH Public - High School Regular School No Other PK 12 2021   grade_7                                                   0                                             0
2954902 2954902 NM     school 3500060 1   ALBUQUERQUE 350006000918 6 NATIVE AMERICAN COMMUNITY ACADEMY Charter - High School Regular School Yes Other KG 12 2021   grade_7                                                   54                                             54
2955035 2955035 NM     school 3500300 20   CARLSBAD 350030000859 1 JEFFERSON MONTESSORI Charter - High School Regular School Yes Other KG 12 2021   grade_7                                                   20                                             20
2955038 2955038 NM     school 3500300 20   CARLSBAD 350030001127 5 PECOS CONNECTIONS ACADEMY Charter - High School Regular School Yes Other KG 12 2021   grade_7                                                   172                                             172
2955087 2955087 NM     school 3500570 12   CLOVIS 350057001155 81 CMS IACADEMY AT LINCOLN JACKSON Public - High School Regular School No Other 02 12 2021   grade_7                                                   8                                             8
2955168 2955168 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_7                                                   54                                             54
2955455 2955455 NM     school 3500153 547   MCCURDY CHARTER SCHOOL 350015301083 1 MCCURDY CHARTER SCHOOL Charter - High School Regular School Yes Other KG 12 2021   grade_7                                                   49                                             49
2955466 2955466 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_7                                                   130                                             130
2955490 2955490 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_7                                                   153                                             153
2955501 2955501 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_7                                                   3                                             3
2955502 2955502 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_7                                                   11                                             11
2955637 2955637 NM     school 3500112 505   SCHOOL OF DREAMS ACADEMY 350011201051 1 SCHOOL OF DREAMS ACADEMY Charter - High School Regular School Yes Other PK 12 2021   grade_7                                                   44                                             44
2955712 2955712 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   grade_7                                                   4                                             4
2548708 2548708 NM     school 3500060 1   ALBUQUERQUE 350006001081 706 CORAL COMMUNITY CHARTER Charter Regular School Yes Not applicable N N 2020   grade_7                                                   0                                             0
2548738 2548738 NM     school 3500060 1   ALBUQUERQUE 350006000890 707 GILBERT L SENA CHARTER HS Charter Regular School Yes Not applicable N N 2020   grade_7                                                   0                                             0
2548800 2548800 NM     school 3500060 1   ALBUQUERQUE 350006001045 708 NEW AMERICA SCHOOL Charter Regular School Yes Not applicable N N 2020   grade_7                                                   0                                             0
2548944 2548944 NM     school 3500390 67   CENTRAL CONS. 350039001102 109 DREAM DINE Charter Regular School Yes Not applicable N N 2020   grade_7                                                   0                                             0
2548661 2548661 NM     school 3500030 46   ALAMOGORDO 350003000003 33 CHAPARRAL MIDDLE Public Regular School No Middle 06 08 2020   grade_7                                                   199                                             199
2548665 2548665 NM     school 3500030 46   ALAMOGORDO 350003000007 37 HOLLOMAN MIDDLE Public Regular School No Middle 06 08 2020   grade_7                                                   62                                             62
2548669 2548669 NM     school 3500030 46   ALAMOGORDO 350003000798 3 MOUNTAIN VIEW MIDDLE Public Regular School No Middle 06 08 2020   grade_7                                                   187                                             187
2548702 2548702 NM     school 3500060 1   ALBUQUERQUE 350006000617 407 CLEVELAND MIDDLE Public Regular School No Middle 06 08 2020   grade_7                                                   209                                             209
2548716 2548716 NM     school 3500060 1   ALBUQUERQUE 350006000764 430 DESERT RIDGE MIDDLE Public Regular School No Middle 06 08 2020   grade_7                                                   330                                             330
2548728 2548728 NM     school 3500060 1   ALBUQUERQUE 350006000049 480 EISENHOWER MIDDLE Public Regular School No Middle 06 08 2020   grade_7                                                   293                                             293
2548732 2548732 NM     school 3500060 1   ALBUQUERQUE 350006000052 450 ERNIE PYLE MIDDLE Public Regular School No Middle 06 08 2020   grade_7                                                   189                                             189
2548735 2548735 NM     school 3500060 1   ALBUQUERQUE 350006000056 410 GARFIELD MIDDLE Public Regular School No Middle 06 08 2020   grade_7                                                   130                                             130

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