enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2549626 2549626 NM     school 3500001 26   VAUGHN 350000100607 168 VAUGHN ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_7                                                   0                                             0
2955713 2955713 NM     school 3500001 26   VAUGHN 350000100607 168 VAUGHN ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_7                                                   0                                             0
2549627 2549627 NM     school 3500001 26   VAUGHN 350000100608 169 VAUGHN HIGH Public Regular School No High 07 12 2020   grade_7                                                   4                                             4
2955714 2955714 NM     school 3500001 26   VAUGHN 350000100608 169 VAUGHN HIGH Public - High School Regular School No High 07 12 2021   grade_7                                                   2                                             2
2549466 2549466 NM     school 3500010 83   RIO RANCHO 350001000101 340 RIO RANCHO ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2955554 2955554 NM     school 3500010 83   RIO RANCHO 350001000101 340 RIO RANCHO ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2549464 2549464 NM     school 3500010 83   RIO RANCHO 350001000650 319 PUESTA DEL SOL ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2955552 2955552 NM     school 3500010 83   RIO RANCHO 350001000650 319 PUESTA DEL SOL ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2549459 2549459 NM     school 3500010 83   RIO RANCHO 350001000682 481 LINCOLN MIDDLE Public Regular School No Middle 06 08 2020   grade_7                                                   313                                             313
2955547 2955547 NM     school 3500010 83   RIO RANCHO 350001000682 481 LINCOLN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   298                                             298
2549461 2549461 NM     school 3500010 83   RIO RANCHO 350001000710 375 MARTIN KING JR ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2955549 2955549 NM     school 3500010 83   RIO RANCHO 350001000710 375 MARTIN KING JR ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2549457 2549457 NM     school 3500010 83   RIO RANCHO 350001000736 372 ERNEST STAPLETON ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2955543 2955543 NM     school 3500010 83   RIO RANCHO 350001000736 372 ERNEST STAPLETON ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2549463 2549463 NM     school 3500010 83   RIO RANCHO 350001000739 105 MOUNTAIN VIEW MIDDLE Public Regular School No Middle 06 08 2020   grade_7                                                   314                                             314
2955551 2955551 NM     school 3500010 83   RIO RANCHO 350001000739 105 MOUNTAIN VIEW MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   296                                             296
2549454 2549454 NM     school 3500010 83   RIO RANCHO 350001000750 50 COLINAS DEL NORTE ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2955540 2955540 NM     school 3500010 83   RIO RANCHO 350001000750 50 COLINAS DEL NORTE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2549455 2549455 NM     school 3500010 83   RIO RANCHO 350001000761 1 EAGLE RIDGE MIDDLE Public Regular School No Middle 06 08 2020   grade_7                                                   303                                             303
2955541 2955541 NM     school 3500010 83   RIO RANCHO 350001000761 1 EAGLE RIDGE MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   310                                             310
2549467 2549467 NM     school 3500010 83   RIO RANCHO 350001000779 6 RIO RANCHO HIGH Public Regular School No High 09 12 2020   grade_7                                                   0                                             0
2955555 2955555 NM     school 3500010 83   RIO RANCHO 350001000779 6 RIO RANCHO HIGH Public - High School Regular School No High 09 12 2021   grade_7                                                   0                                             0
2549458 2549458 NM     school 3500010 83   RIO RANCHO 350001000805 13 INDEPENDENCE HIGH SCHOOL Public Alternative School No High 09 12 2020   grade_7                                                   0                                             0
2955545 2955545 NM     school 3500010 83   RIO RANCHO 350001000805 13 INDEPENDENCE HIGH SCHOOL Public - High School Alternative School No High 09 12 2021   grade_7                                                   0                                             0
2549471 2549471 NM     school 3500010 83   RIO RANCHO 350001000864 15 VISTA GRANDE ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2955559 2955559 NM     school 3500010 83   RIO RANCHO 350001000864 15 VISTA GRANDE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2549468 2549468 NM     school 3500010 83   RIO RANCHO 350001000865 16 RIO RANCHO MIDDLE SCHOOL Public Regular School No Middle 06 08 2020   grade_7                                                   411                                             411
2955556 2955556 NM     school 3500010 83   RIO RANCHO 350001000865 16 RIO RANCHO MIDDLE SCHOOL Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   407                                             407
2549460 2549460 NM     school 3500010 83   RIO RANCHO 350001000952 12 MAGGIE CORDOVA ELEMENTARY SCHOOL Public Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2955548 2955548 NM     school 3500010 83   RIO RANCHO 350001000952 12 MAGGIE CORDOVA ELEMENTARY SCHOOL Public - Elementary School Regular School No Elementary KG 05 2021   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
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
2549465 2549465 NM     school 3500010 83   RIO RANCHO 350001000954 18 RIO RANCHO CYBER ACADEMY Public Alternative School No High 06 12 2020   grade_7                                                   18                                             18
2955553 2955553 NM     school 3500010 83   RIO RANCHO 350001000954 18 RIO RANCHO CYBER ACADEMY Public - High School Alternative School No High 06 12 2021   grade_7                                                   18                                             18
2549453 2549453 NM     school 3500010 83   RIO RANCHO 350001001024 11 CLEVELAND HIGH SCHOOL Public Regular School No High 09 12 2020   grade_7                                                   0                                             0
2955539 2955539 NM     school 3500010 83   RIO RANCHO 350001001024 11 CLEVELAND HIGH SCHOOL Public - High School Regular School No High 09 12 2021   grade_7                                                   0                                             0
2549452 2549452 NM     school 3500010 83   RIO RANCHO 350001001034 21 CIELO AZUL ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2955538 2955538 NM     school 3500010 83   RIO RANCHO 350001001034 21 CIELO AZUL ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2549469 2549469 NM     school 3500010 83   RIO RANCHO 350001001039 20 SANDIA VISTA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_7                                                   0                                             0
2955557 2955557 NM     school 3500010 83   RIO RANCHO 350001001039 20 SANDIA VISTA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2955546 2955546 NM     school 3500010 83   RIO RANCHO 350001001159 25 JOE HARRIS ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2549456 2549456 NM     school 3500010 83   RIO RANCHO 350001030011 100 ENCHANTED HILLS ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2955542 2955542 NM     school 3500010 83   RIO RANCHO 350001030011 100 ENCHANTED HILLS ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2549245 2549245 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported Alternative School No High 09 12 2020   grade_7                                                   0                                             0
2955335 2955335 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported - State Supported Alternative School No High 09 12 2021   grade_7                                                   0                                             0
2549247 2549247 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported Alternative School No High 06 12 2020   grade_7                                                   1                                             1
2955337 2955337 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported - State Supported Alternative School No High 06 12 2021   grade_7                                                   0                                             0
2549246 2549246 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported Alternative School No High 06 12 2020   grade_7                                                   0                                             0
2955336 2955336 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported - State Supported Alternative School No High 06 12 2021   grade_7                                                   0                                             0
2549409 2549409 NM     school 3500012 91   NM CORRECTIONS 350001200970 5 ROSWELL CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_7                                                   0                                             0
2549404 2549404 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_7                                                   0                                             0
2955493 2955493 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_7                                                   0                                             0
2955492 2955492 NM     school 3500012 91   NM CORRECTIONS 350001200976 7 GUADALUPE COUNTY CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_7                                                   0                                             0
2549408 2549408 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported Alternative School No High 08 12 2020   grade_7                                                   0                                             0
2955497 2955497 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_7                                                   0                                             0
2549412 2549412 NM     school 3500012 91   NM CORRECTIONS 350001200979 8 WESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_7                                                   0                                             0
2549410 2549410 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_7                                                   0                                             0
2955498 2955498 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_7                                                   0                                             0
2549403 2549403 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_7                                                   0                                             0
2955491 2955491 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_7                                                   0                                             0
2549406 2549406 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_7                                                   0                                             0
2955495 2955495 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_7                                                   0                                             0
2549411 2549411 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_7                                                   0                                             0
2955499 2955499 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported - State Supported Alternative School No High 08 12 2021   grade_7                                                   0                                             0
2549405 2549405 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_7                                                   0                                             0
2955494 2955494 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported - State Supported Alternative School No High 08 12 2021   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
2955496 2955496 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported - State Supported Alternative School No High 08 12 2021   grade_7                                                   0                                             0
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
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
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
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
2549554 2549554 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_7                                                   1                                             1
2955638 2955638 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   grade_7                                                   0                                             0
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
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
2548659 2548659 NM     school 3500030 46   ALAMOGORDO 350003000001 15 ALAMOGORDO HIGH Public Regular School No High 09 12 2020   grade_7                                                   0                                             0
2954765 2954765 NM     school 3500030 46   ALAMOGORDO 350003000001 15 ALAMOGORDO HIGH Public - High School Regular School No High 09 12 2021   grade_7                                                   0                                             0
2548660 2548660 NM     school 3500030 46   ALAMOGORDO 350003000002 28 BUENA VISTA ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2954766 2954766 NM     school 3500030 46   ALAMOGORDO 350003000002 28 BUENA VISTA ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   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
2954767 2954767 NM     school 3500030 46   ALAMOGORDO 350003000003 33 CHAPARRAL MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   217                                             217
2548672 2548672 NM     school 3500030 46   ALAMOGORDO 350003000004 56 SUNSET HILLS ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2954778 2954778 NM     school 3500030 46   ALAMOGORDO 350003000004 56 SUNSET HILLS ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2548663 2548663 NM     school 3500030 46   ALAMOGORDO 350003000005 57 HIGH ROLLS MOUNTAIN PARK ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2954769 2954769 NM     school 3500030 46   ALAMOGORDO 350003000005 57 HIGH ROLLS MOUNTAIN PARK ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2548664 2548664 NM     school 3500030 46   ALAMOGORDO 350003000006 58 HOLLOMAN ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_7                                                   0                                             0
2954770 2954770 NM     school 3500030 46   ALAMOGORDO 350003000006 58 HOLLOMAN ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2548665 2548665 NM     school 3500030 46   ALAMOGORDO 350003000007 37 HOLLOMAN MIDDLE Public Regular School No Middle 06 08 2020   grade_7                                                   62                                             62
2954771 2954771 NM     school 3500030 46   ALAMOGORDO 350003000007 37 HOLLOMAN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_7                                                   57                                             57
2548667 2548667 NM     school 3500030 46   ALAMOGORDO 350003000008 72 LA LUZ ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
2954772 2954772 NM     school 3500030 46   ALAMOGORDO 350003000008 72 LA LUZ ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2548670 2548670 NM     school 3500030 46   ALAMOGORDO 350003000010 114 NORTH ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_7                                                   0                                             0
2954775 2954775 NM     school 3500030 46   ALAMOGORDO 350003000010 114 NORTH ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2548662 2548662 NM     school 3500030 46   ALAMOGORDO 350003000012 144 DESERT STAR ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_7                                                   0                                             0
2954768 2954768 NM     school 3500030 46   ALAMOGORDO 350003000012 144 DESERT STAR ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2548671 2548671 NM     school 3500030 46   ALAMOGORDO 350003000013 150 SIERRA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_7                                                   0                                             0
2954776 2954776 NM     school 3500030 46   ALAMOGORDO 350003000013 150 SIERRA ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
2548673 2548673 NM     school 3500030 46   ALAMOGORDO 350003000016 181 YUCCA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_7                                                   0                                             0
2954779 2954779 NM     school 3500030 46   ALAMOGORDO 350003000016 181 YUCCA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_7                                                   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]);