enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2551616 2551616 NM     school 3500001 26   VAUGHN 350000100607 168 VAUGHN ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
2957669 2957669 NM     school 3500001 26   VAUGHN 350000100607 168 VAUGHN ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_9                                                   0                                             0
2551617 2551617 NM     school 3500001 26   VAUGHN 350000100608 169 VAUGHN HIGH Public Regular School No High 07 12 2020   grade_9                                                   3                                             3
2957670 2957670 NM     school 3500001 26   VAUGHN 350000100608 169 VAUGHN HIGH Public - High School Regular School No High 07 12 2021   grade_9                                                   3                                             3
2551456 2551456 NM     school 3500010 83   RIO RANCHO 350001000101 340 RIO RANCHO ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_9                                                   0                                             0
2957510 2957510 NM     school 3500010 83   RIO RANCHO 350001000101 340 RIO RANCHO ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
2551454 2551454 NM     school 3500010 83   RIO RANCHO 350001000650 319 PUESTA DEL SOL ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_9                                                   0                                             0
2957508 2957508 NM     school 3500010 83   RIO RANCHO 350001000650 319 PUESTA DEL SOL ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
2551449 2551449 NM     school 3500010 83   RIO RANCHO 350001000682 481 LINCOLN MIDDLE Public Regular School No Middle 06 08 2020   grade_9                                                   0                                             0
2957503 2957503 NM     school 3500010 83   RIO RANCHO 350001000682 481 LINCOLN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2551451 2551451 NM     school 3500010 83   RIO RANCHO 350001000710 375 MARTIN KING JR ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_9                                                   0                                             0
2957505 2957505 NM     school 3500010 83   RIO RANCHO 350001000710 375 MARTIN KING JR ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
2551447 2551447 NM     school 3500010 83   RIO RANCHO 350001000736 372 ERNEST STAPLETON ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_9                                                   0                                             0
2957499 2957499 NM     school 3500010 83   RIO RANCHO 350001000736 372 ERNEST STAPLETON ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
2551453 2551453 NM     school 3500010 83   RIO RANCHO 350001000739 105 MOUNTAIN VIEW MIDDLE Public Regular School No Middle 06 08 2020   grade_9                                                   0                                             0
2957507 2957507 NM     school 3500010 83   RIO RANCHO 350001000739 105 MOUNTAIN VIEW MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2551444 2551444 NM     school 3500010 83   RIO RANCHO 350001000750 50 COLINAS DEL NORTE ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_9                                                   0                                             0
2957496 2957496 NM     school 3500010 83   RIO RANCHO 350001000750 50 COLINAS DEL NORTE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
2551445 2551445 NM     school 3500010 83   RIO RANCHO 350001000761 1 EAGLE RIDGE MIDDLE Public Regular School No Middle 06 08 2020   grade_9                                                   0                                             0
2957497 2957497 NM     school 3500010 83   RIO RANCHO 350001000761 1 EAGLE RIDGE MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2551457 2551457 NM     school 3500010 83   RIO RANCHO 350001000779 6 RIO RANCHO HIGH Public Regular School No High 09 12 2020   grade_9                                                   725                                             725
2957511 2957511 NM     school 3500010 83   RIO RANCHO 350001000779 6 RIO RANCHO HIGH Public - High School Regular School No High 09 12 2021   grade_9                                                   702                                             702
2551448 2551448 NM     school 3500010 83   RIO RANCHO 350001000805 13 INDEPENDENCE HIGH SCHOOL Public Alternative School No High 09 12 2020   grade_9                                                   0                                             0
2957501 2957501 NM     school 3500010 83   RIO RANCHO 350001000805 13 INDEPENDENCE HIGH SCHOOL Public - High School Alternative School No High 09 12 2021   grade_9                                                   0                                             0
2551461 2551461 NM     school 3500010 83   RIO RANCHO 350001000864 15 VISTA GRANDE ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_9                                                   0                                             0
2957515 2957515 NM     school 3500010 83   RIO RANCHO 350001000864 15 VISTA GRANDE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
2551458 2551458 NM     school 3500010 83   RIO RANCHO 350001000865 16 RIO RANCHO MIDDLE SCHOOL Public Regular School No Middle 06 08 2020   grade_9                                                   0                                             0
2957512 2957512 NM     school 3500010 83   RIO RANCHO 350001000865 16 RIO RANCHO MIDDLE SCHOOL Public - Middle School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2551450 2551450 NM     school 3500010 83   RIO RANCHO 350001000952 12 MAGGIE CORDOVA ELEMENTARY SCHOOL Public Regular School No Elementary KG 05 2020   grade_9                                                   0                                             0
2957504 2957504 NM     school 3500010 83   RIO RANCHO 350001000952 12 MAGGIE CORDOVA ELEMENTARY SCHOOL Public - Elementary School Regular School No Elementary KG 05 2021   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
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
2551455 2551455 NM     school 3500010 83   RIO RANCHO 350001000954 18 RIO RANCHO CYBER ACADEMY Public Alternative School No High 06 12 2020   grade_9                                                   20                                             20
2957509 2957509 NM     school 3500010 83   RIO RANCHO 350001000954 18 RIO RANCHO CYBER ACADEMY Public - High School Alternative School No High 06 12 2021   grade_9                                                   21                                             21
2551443 2551443 NM     school 3500010 83   RIO RANCHO 350001001024 11 CLEVELAND HIGH SCHOOL Public Regular School No High 09 12 2020   grade_9                                                   661                                             661
2957495 2957495 NM     school 3500010 83   RIO RANCHO 350001001024 11 CLEVELAND HIGH SCHOOL Public - High School Regular School No High 09 12 2021   grade_9                                                   698                                             698
2551442 2551442 NM     school 3500010 83   RIO RANCHO 350001001034 21 CIELO AZUL ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_9                                                   0                                             0
2957494 2957494 NM     school 3500010 83   RIO RANCHO 350001001034 21 CIELO AZUL ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
2551459 2551459 NM     school 3500010 83   RIO RANCHO 350001001039 20 SANDIA VISTA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_9                                                   0                                             0
2957513 2957513 NM     school 3500010 83   RIO RANCHO 350001001039 20 SANDIA VISTA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_9                                                   0                                             0
2957502 2957502 NM     school 3500010 83   RIO RANCHO 350001001159 25 JOE HARRIS ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
2551446 2551446 NM     school 3500010 83   RIO RANCHO 350001030011 100 ENCHANTED HILLS ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_9                                                   0                                             0
2957498 2957498 NM     school 3500010 83   RIO RANCHO 350001030011 100 ENCHANTED HILLS ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
2551235 2551235 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported Alternative School No High 09 12 2020   grade_9                                                   10                                             10
2957291 2957291 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported - State Supported Alternative School No High 09 12 2021   grade_9                                                   5                                             5
2551237 2551237 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported Alternative School No High 06 12 2020   grade_9                                                   16                                             16
2957293 2957293 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported - State Supported Alternative School No High 06 12 2021   grade_9                                                   26                                             26
2551236 2551236 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported Alternative School No High 06 12 2020   grade_9                                                   16                                             16
2957292 2957292 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported - State Supported Alternative School No High 06 12 2021   grade_9                                                   16                                             16
2551399 2551399 NM     school 3500012 91   NM CORRECTIONS 350001200970 5 ROSWELL CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_9                                                   0                                             0
2551394 2551394 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_9                                                   6                                             6
2957449 2957449 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_9                                                   1                                             1
2957448 2957448 NM     school 3500012 91   NM CORRECTIONS 350001200976 7 GUADALUPE COUNTY CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_9                                                   1                                             1
2551398 2551398 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported Alternative School No High 08 12 2020   grade_9                                                   2                                             2
2957453 2957453 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported - State Supported Alternative School No High 08 12 2021   grade_9                                                   1                                             1
2551402 2551402 NM     school 3500012 91   NM CORRECTIONS 350001200979 8 WESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_9                                                   1                                             1
2551400 2551400 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_9                                                   3                                             3
2957454 2957454 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_9                                                   1                                             1
2551393 2551393 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_9                                                   1                                             1
2957447 2957447 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_9                                                   0                                             0
2551396 2551396 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_9                                                   2                                             2
2957451 2957451 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_9                                                   1                                             1
2551401 2551401 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_9                                                   0                                             0
2957455 2957455 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported - State Supported Alternative School No High 08 12 2021   grade_9                                                   0                                             0
2551395 2551395 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_9                                                   3                                             3
2957450 2957450 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported - State Supported Alternative School No High 08 12 2021   grade_9                                                   0                                             0
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
2957452 2957452 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported - State Supported Alternative School No High 08 12 2021   grade_9                                                   0                                             0
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
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
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
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
2551544 2551544 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_9                                                   11                                             11
2957594 2957594 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   grade_9                                                   8                                             8
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
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
2550649 2550649 NM     school 3500030 46   ALAMOGORDO 350003000001 15 ALAMOGORDO HIGH Public Regular School No High 09 12 2020   grade_9                                                   416                                             416
2956721 2956721 NM     school 3500030 46   ALAMOGORDO 350003000001 15 ALAMOGORDO HIGH Public - High School Regular School No High 09 12 2021   grade_9                                                   437                                             437
2550650 2550650 NM     school 3500030 46   ALAMOGORDO 350003000002 28 BUENA VISTA ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_9                                                   0                                             0
2956722 2956722 NM     school 3500030 46   ALAMOGORDO 350003000002 28 BUENA VISTA ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   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
2956723 2956723 NM     school 3500030 46   ALAMOGORDO 350003000003 33 CHAPARRAL MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2550662 2550662 NM     school 3500030 46   ALAMOGORDO 350003000004 56 SUNSET HILLS ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_9                                                   0                                             0
2956734 2956734 NM     school 3500030 46   ALAMOGORDO 350003000004 56 SUNSET HILLS ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
2550653 2550653 NM     school 3500030 46   ALAMOGORDO 350003000005 57 HIGH ROLLS MOUNTAIN PARK ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_9                                                   0                                             0
2956725 2956725 NM     school 3500030 46   ALAMOGORDO 350003000005 57 HIGH ROLLS MOUNTAIN PARK ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
2550654 2550654 NM     school 3500030 46   ALAMOGORDO 350003000006 58 HOLLOMAN ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_9                                                   0                                             0
2956726 2956726 NM     school 3500030 46   ALAMOGORDO 350003000006 58 HOLLOMAN ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   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
2956727 2956727 NM     school 3500030 46   ALAMOGORDO 350003000007 37 HOLLOMAN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2550657 2550657 NM     school 3500030 46   ALAMOGORDO 350003000008 72 LA LUZ ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_9                                                   0                                             0
2956728 2956728 NM     school 3500030 46   ALAMOGORDO 350003000008 72 LA LUZ ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
2550660 2550660 NM     school 3500030 46   ALAMOGORDO 350003000010 114 NORTH ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_9                                                   0                                             0
2956731 2956731 NM     school 3500030 46   ALAMOGORDO 350003000010 114 NORTH ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_9                                                   0                                             0
2550652 2550652 NM     school 3500030 46   ALAMOGORDO 350003000012 144 DESERT STAR ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_9                                                   0                                             0
2956724 2956724 NM     school 3500030 46   ALAMOGORDO 350003000012 144 DESERT STAR ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
2550661 2550661 NM     school 3500030 46   ALAMOGORDO 350003000013 150 SIERRA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_9                                                   0                                             0
2956732 2956732 NM     school 3500030 46   ALAMOGORDO 350003000013 150 SIERRA ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
2550663 2550663 NM     school 3500030 46   ALAMOGORDO 350003000016 181 YUCCA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_9                                                   0                                             0
2956735 2956735 NM     school 3500030 46   ALAMOGORDO 350003000016 181 YUCCA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   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]);