enrollments

Data source: Big Local News · About: Big Local

1,973 rows where grade = "grade_4" and state = "NM" sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 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
2546641 2546641 NM     school 3500001 26   VAUGHN 350000100607 168 VAUGHN ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_4                                                   1                                             1
2546642 2546642 NM     school 3500001 26   VAUGHN 350000100608 169 VAUGHN HIGH Public Regular School No High 07 12 2020   grade_4                                                   0                                             0
2952779 2952779 NM     school 3500001 26   VAUGHN 350000100607 168 VAUGHN ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_4                                                   6                                             6
2952780 2952780 NM     school 3500001 26   VAUGHN 350000100608 169 VAUGHN HIGH Public - High School Regular School No High 07 12 2021   grade_4                                                   0                                             0
2546467 2546467 NM     school 3500010 83   RIO RANCHO 350001001034 21 CIELO AZUL ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_4                                                   148                                             148
2546468 2546468 NM     school 3500010 83   RIO RANCHO 350001001024 11 CLEVELAND HIGH SCHOOL Public Regular School No High 09 12 2020   grade_4                                                   0                                             0
2546469 2546469 NM     school 3500010 83   RIO RANCHO 350001000750 50 COLINAS DEL NORTE ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_4                                                   131                                             131
2546470 2546470 NM     school 3500010 83   RIO RANCHO 350001000761 1 EAGLE RIDGE MIDDLE Public Regular School No Middle 06 08 2020   grade_4                                                   0                                             0
2546471 2546471 NM     school 3500010 83   RIO RANCHO 350001030011 100 ENCHANTED HILLS ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_4                                                   137                                             137
2546472 2546472 NM     school 3500010 83   RIO RANCHO 350001000736 372 ERNEST STAPLETON ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_4                                                   136                                             136
2546473 2546473 NM     school 3500010 83   RIO RANCHO 350001000805 13 INDEPENDENCE HIGH SCHOOL Public Alternative School No High 09 12 2020   grade_4                                                   0                                             0
2546474 2546474 NM     school 3500010 83   RIO RANCHO 350001000682 481 LINCOLN MIDDLE Public Regular School No Middle 06 08 2020   grade_4                                                   0                                             0
2546475 2546475 NM     school 3500010 83   RIO RANCHO 350001000952 12 MAGGIE CORDOVA ELEMENTARY SCHOOL Public Regular School No Elementary KG 05 2020   grade_4                                                   171                                             171
2546476 2546476 NM     school 3500010 83   RIO RANCHO 350001000710 375 MARTIN KING JR ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_4                                                   160                                             160
2546478 2546478 NM     school 3500010 83   RIO RANCHO 350001000739 105 MOUNTAIN VIEW MIDDLE Public Regular School No Middle 06 08 2020   grade_4                                                   0                                             0
2546479 2546479 NM     school 3500010 83   RIO RANCHO 350001000650 319 PUESTA DEL SOL ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_4                                                   113                                             113
2546480 2546480 NM     school 3500010 83   RIO RANCHO 350001000954 18 RIO RANCHO CYBER ACADEMY Public Alternative School No High 06 12 2020   grade_4                                                   0                                             0
2546481 2546481 NM     school 3500010 83   RIO RANCHO 350001000101 340 RIO RANCHO ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_4                                                   123                                             123
2546482 2546482 NM     school 3500010 83   RIO RANCHO 350001000779 6 RIO RANCHO HIGH Public Regular School No High 09 12 2020   grade_4                                                   0                                             0
2546483 2546483 NM     school 3500010 83   RIO RANCHO 350001000865 16 RIO RANCHO MIDDLE SCHOOL Public Regular School No Middle 06 08 2020   grade_4                                                   0                                             0
2546484 2546484 NM     school 3500010 83   RIO RANCHO 350001001039 20 SANDIA VISTA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_4                                                   105                                             105
2546485 2546485 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_4                                                   0                                             0
2546486 2546486 NM     school 3500010 83   RIO RANCHO 350001000864 15 VISTA GRANDE ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_4                                                   112                                             112
2952604 2952604 NM     school 3500010 83   RIO RANCHO 350001001034 21 CIELO AZUL ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_4                                                   116                                             116
2952605 2952605 NM     school 3500010 83   RIO RANCHO 350001001024 11 CLEVELAND HIGH SCHOOL Public - High School Regular School No High 09 12 2021   grade_4                                                   0                                             0
2952606 2952606 NM     school 3500010 83   RIO RANCHO 350001000750 50 COLINAS DEL NORTE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_4                                                   116                                             116
2952607 2952607 NM     school 3500010 83   RIO RANCHO 350001000761 1 EAGLE RIDGE MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952608 2952608 NM     school 3500010 83   RIO RANCHO 350001030011 100 ENCHANTED HILLS ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_4                                                   107                                             107
2952609 2952609 NM     school 3500010 83   RIO RANCHO 350001000736 372 ERNEST STAPLETON ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_4                                                   152                                             152
2952611 2952611 NM     school 3500010 83   RIO RANCHO 350001000805 13 INDEPENDENCE HIGH SCHOOL Public - High School Alternative School No High 09 12 2021   grade_4                                                   0                                             0
2952612 2952612 NM     school 3500010 83   RIO RANCHO 350001001159 25 JOE HARRIS ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_4                                                   56                                             56
2952613 2952613 NM     school 3500010 83   RIO RANCHO 350001000682 481 LINCOLN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952614 2952614 NM     school 3500010 83   RIO RANCHO 350001000952 12 MAGGIE CORDOVA ELEMENTARY SCHOOL Public - Elementary School Regular School No Elementary KG 05 2021   grade_4                                                   104                                             104
2952615 2952615 NM     school 3500010 83   RIO RANCHO 350001000710 375 MARTIN KING JR ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_4                                                   109                                             109
2952617 2952617 NM     school 3500010 83   RIO RANCHO 350001000739 105 MOUNTAIN VIEW MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952618 2952618 NM     school 3500010 83   RIO RANCHO 350001000650 319 PUESTA DEL SOL ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_4                                                   125                                             125
2952619 2952619 NM     school 3500010 83   RIO RANCHO 350001000954 18 RIO RANCHO CYBER ACADEMY Public - High School Alternative School No High 06 12 2021   grade_4                                                   0                                             0
2952620 2952620 NM     school 3500010 83   RIO RANCHO 350001000101 340 RIO RANCHO ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_4                                                   85                                             85
2952621 2952621 NM     school 3500010 83   RIO RANCHO 350001000779 6 RIO RANCHO HIGH Public - High School Regular School No High 09 12 2021   grade_4                                                   0                                             0
2952622 2952622 NM     school 3500010 83   RIO RANCHO 350001000865 16 RIO RANCHO MIDDLE SCHOOL Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952623 2952623 NM     school 3500010 83   RIO RANCHO 350001001039 20 SANDIA VISTA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_4                                                   99                                             99
2952624 2952624 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public - Special Education Special Education School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
2952625 2952625 NM     school 3500010 83   RIO RANCHO 350001000864 15 VISTA GRANDE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_4                                                   132                                             132
2546260 2546260 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported Alternative School No High 09 12 2020   grade_4                                                   0                                             0
2546261 2546261 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported Alternative School No High 06 12 2020   grade_4                                                   0                                             0
2546262 2546262 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported Alternative School No High 06 12 2020   grade_4                                                   0                                             0
2952401 2952401 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported - State Supported Alternative School No High 09 12 2021   grade_4                                                   0                                             0
2952402 2952402 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported - State Supported Alternative School No High 06 12 2021   grade_4                                                   0                                             0
2952403 2952403 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported - State Supported Alternative School No High 06 12 2021   grade_4                                                   0                                             0
2546418 2546418 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_4                                                   0                                             0
2546419 2546419 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_4                                                   0                                             0
2546420 2546420 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_4                                                   0                                             0
2546421 2546421 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_4                                                   0                                             0
2546422 2546422 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported Alternative School No Secondary 09 11 2020   grade_4                                                   0                                             0
2546423 2546423 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported Alternative School No High 08 12 2020   grade_4                                                   0                                             0
2546424 2546424 NM     school 3500012 91   NM CORRECTIONS 350001200970 5 ROSWELL CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_4                                                   0                                             0
2546425 2546425 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_4                                                   0                                             0
2546426 2546426 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_4                                                   0                                             0
2546427 2546427 NM     school 3500012 91   NM CORRECTIONS 350001200979 8 WESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_4                                                   0                                             0
2952557 2952557 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_4                                                   0                                             0
2952558 2952558 NM     school 3500012 91   NM CORRECTIONS 350001200976 7 GUADALUPE COUNTY CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_4                                                   0                                             0
2952559 2952559 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_4                                                   0                                             0
2952560 2952560 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported - State Supported Alternative School No High 08 12 2021   grade_4                                                   0                                             0
2952561 2952561 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_4                                                   0                                             0
2952562 2952562 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported - State Supported Alternative School No High 08 12 2021   grade_4                                                   0                                             0
2952563 2952563 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_4                                                   0                                             0
2952564 2952564 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_4                                                   0                                             0
2952565 2952565 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported - State Supported Alternative School No High 08 12 2021   grade_4                                                   0                                             0
2546429 2546429 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_4                                                   2                                             2
2952567 2952567 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_4                                                   4                                             4
2546430 2546430 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_4                                                   15                                             15
2952568 2952568 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_4                                                   12                                             12
2546569 2546569 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_4                                                   0                                             0
2952704 2952704 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   grade_4                                                   0                                             0
2545983 2545983 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_4                                                   0                                             0
2952778 2952778 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   grade_4                                                   1                                             1
2545673 2545673 NM     school 3500030 46   ALAMOGORDO 350003000799 4 ACADEMY DEL SOL ALT. Public Alternative School No High 10 12 2020   grade_4                                                   0                                             0
2545674 2545674 NM     school 3500030 46   ALAMOGORDO 350003000001 15 ALAMOGORDO HIGH Public Regular School No High 09 12 2020   grade_4                                                   0                                             0
2545675 2545675 NM     school 3500030 46   ALAMOGORDO 350003000002 28 BUENA VISTA ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_4                                                   46                                             46
2545676 2545676 NM     school 3500030 46   ALAMOGORDO 350003000003 33 CHAPARRAL MIDDLE Public Regular School No Middle 06 08 2020   grade_4                                                   0                                             0
2545677 2545677 NM     school 3500030 46   ALAMOGORDO 350003000012 144 DESERT STAR ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_4                                                   92                                             92
2545678 2545678 NM     school 3500030 46   ALAMOGORDO 350003000005 57 HIGH ROLLS MOUNTAIN PARK ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_4                                                   5                                             5
2545679 2545679 NM     school 3500030 46   ALAMOGORDO 350003000006 58 HOLLOMAN ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_4                                                   53                                             53
2545680 2545680 NM     school 3500030 46   ALAMOGORDO 350003000007 37 HOLLOMAN MIDDLE Public Regular School No Middle 06 08 2020   grade_4                                                   0                                             0
2545682 2545682 NM     school 3500030 46   ALAMOGORDO 350003000008 72 LA LUZ ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_4                                                   49                                             49
2545684 2545684 NM     school 3500030 46   ALAMOGORDO 350003000798 3 MOUNTAIN VIEW MIDDLE Public Regular School No Middle 06 08 2020   grade_4                                                   0                                             0
2545685 2545685 NM     school 3500030 46   ALAMOGORDO 350003000010 114 NORTH ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_4                                                   46                                             46
2545686 2545686 NM     school 3500030 46   ALAMOGORDO 350003000013 150 SIERRA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_4                                                   59                                             59
2545687 2545687 NM     school 3500030 46   ALAMOGORDO 350003000004 56 SUNSET HILLS ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_4                                                   61                                             61
2545688 2545688 NM     school 3500030 46   ALAMOGORDO 350003000016 181 YUCCA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_4                                                   45                                             45
2951830 2951830 NM     school 3500030 46   ALAMOGORDO 350003000799 4 ACADEMY DEL SOL ALT. Public - High School Alternative School No High 10 12 2021   grade_4                                                   0                                             0
2951831 2951831 NM     school 3500030 46   ALAMOGORDO 350003000001 15 ALAMOGORDO HIGH Public - High School Regular School No High 09 12 2021   grade_4                                                   0                                             0
2951832 2951832 NM     school 3500030 46   ALAMOGORDO 350003000002 28 BUENA VISTA ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_4                                                   28                                             28
2951833 2951833 NM     school 3500030 46   ALAMOGORDO 350003000003 33 CHAPARRAL MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951834 2951834 NM     school 3500030 46   ALAMOGORDO 350003000012 144 DESERT STAR ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_4                                                   92                                             92
2951835 2951835 NM     school 3500030 46   ALAMOGORDO 350003000005 57 HIGH ROLLS MOUNTAIN PARK ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_4                                                   4                                             4
2951836 2951836 NM     school 3500030 46   ALAMOGORDO 350003000006 58 HOLLOMAN ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_4                                                   44                                             44
2951837 2951837 NM     school 3500030 46   ALAMOGORDO 350003000007 37 HOLLOMAN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951838 2951838 NM     school 3500030 46   ALAMOGORDO 350003000008 72 LA LUZ ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   grade_4                                                   34                                             34
2951840 2951840 NM     school 3500030 46   ALAMOGORDO 350003000798 3 MOUNTAIN VIEW MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   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]);