enrollments

Data source: Big Local News · About: Big Local

1,973 rows where grade = "grade_8" and state = "NM" sorted by school_state_type descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 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
2956313 2956313 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported - State Supported Alternative School No High 09 12 2021   grade_8                                                   1                                             1
2956314 2956314 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported - State Supported Alternative School No High 06 12 2021   grade_8                                                   0                                             0
2956315 2956315 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported - State Supported Alternative School No High 06 12 2021   grade_8                                                   0                                             0
2956469 2956469 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_8                                                   0                                             0
2956470 2956470 NM     school 3500012 91   NM CORRECTIONS 350001200976 7 GUADALUPE COUNTY CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_8                                                   0                                             0
2956471 2956471 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_8                                                   0                                             0
2956472 2956472 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported - State Supported Alternative School No High 08 12 2021   grade_8                                                   0                                             0
2956473 2956473 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_8                                                   0                                             0
2956474 2956474 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported - State Supported Alternative School No High 08 12 2021   grade_8                                                   0                                             0
2956475 2956475 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_8                                                   0                                             0
2956476 2956476 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_8                                                   0                                             0
2956477 2956477 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported - State Supported Alternative School No High 08 12 2021   grade_8                                                   0                                             0
2956479 2956479 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_8                                                   2                                             2
2956480 2956480 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_8                                                   13                                             13
2956616 2956616 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   grade_8                                                   2                                             2
2956690 2956690 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   grade_8                                                   7                                             7
2549963 2549963 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_8                                                   5                                             5
2550240 2550240 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported Alternative School No High 09 12 2020   grade_8                                                   0                                             0
2550241 2550241 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported Alternative School No High 06 12 2020   grade_8                                                   1                                             1
2550242 2550242 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported Alternative School No High 06 12 2020   grade_8                                                   1                                             1
2550398 2550398 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_8                                                   0                                             0
2550399 2550399 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_8                                                   0                                             0
2550400 2550400 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_8                                                   0                                             0
2550401 2550401 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_8                                                   0                                             0
2550402 2550402 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported Alternative School No Secondary 09 11 2020   grade_8                                                   0                                             0
2550403 2550403 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported Alternative School No High 08 12 2020   grade_8                                                   0                                             0
2550404 2550404 NM     school 3500012 91   NM CORRECTIONS 350001200970 5 ROSWELL CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_8                                                   0                                             0
2550405 2550405 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_8                                                   0                                             0
2550406 2550406 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_8                                                   0                                             0
2550407 2550407 NM     school 3500012 91   NM CORRECTIONS 350001200979 8 WESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_8                                                   0                                             0
2550409 2550409 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_8                                                   2                                             2
2550410 2550410 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_8                                                   9                                             9
2550549 2550549 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_8                                                   4                                             4
2955830 2955830 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public - Special Education Special Education School No Other PK 12 2021   grade_8                                                   4                                             4
2956103 2956103 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public - Special Education Special Education School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2956157 2956157 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public - Special Education Special Education School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2956536 2956536 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public - Special Education Special Education School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2955755 2955755 NM     school 3500030 46   ALAMOGORDO 350003001158 182 STEPPING STONES PRESCHOOL Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2956011 2956011 NM     school 3500300 20   CARLSBAD 350030001148 58 HILLCREST PRESCHOOL Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2956030 2956030 NM     school 3500390 67   CENTRAL CONS. 350039000947 24 KIRTLAND PRE-K EARLY Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2956071 2956071 NM     school 3500570 12   CLOVIS 350057000793 3 LOS NINOS Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2956158 2956158 NM     school 3500990 65   FARMINGTON 350099001091 56 FARMINGTON PRESCHOOL ACADEMY WEST Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2956181 2956181 NM     school 3501080 19   GADSDEN 350108001132 60 ANTHONY ON-TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2956186 2956186 NM     school 3501080 19   GADSDEN 350108001131 61 CHAPARRAL ON-TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2956189 2956189 NM     school 3501080 19   GADSDEN 350108001129 62 GADSDEN ADMIN COMPLEX PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2956194 2956194 NM     school 3501080 19   GADSDEN 350108001130 63 LA MESA ON TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2956453 2956453 NM     school 3501890 81   MORIARTY-EDGEWOOD 350189001145 151 EARLY CHILDHOOD CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2956554 2956554 NM     school 3502250 4   ROSWELL 350225000519 122 PARKVIEW EARLY LITERACY CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2956597 2956597 NM     school 3502370 71   SANTA FE 350237030025 168 NYE EARLY CHILDHOOD Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2956627 2956627 NM     school 3502430 23   SILVER CITY 350243001141 12 SILVER SCHOLARS ACADEMY Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2955745 2955745 NM     school 3500030 46   ALAMOGORDO 350003000003 33 CHAPARRAL MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   193                                             193
2955749 2955749 NM     school 3500030 46   ALAMOGORDO 350003000007 37 HOLLOMAN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   57                                             57
2955752 2955752 NM     school 3500030 46   ALAMOGORDO 350003000798 3 MOUNTAIN VIEW MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   177                                             177
2955785 2955785 NM     school 3500060 1   ALBUQUERQUE 350006000617 407 CLEVELAND MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   186                                             186
2955798 2955798 NM     school 3500060 1   ALBUQUERQUE 350006000764 430 DESERT RIDGE MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   289                                             289
2955810 2955810 NM     school 3500060 1   ALBUQUERQUE 350006000049 480 EISENHOWER MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   273                                             273
2955814 2955814 NM     school 3500060 1   ALBUQUERQUE 350006000052 450 ERNIE PYLE MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   182                                             182
2955817 2955817 NM     school 3500060 1   ALBUQUERQUE 350006000056 410 GARFIELD MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   125                                             125
2955823 2955823 NM     school 3500060 1   ALBUQUERQUE 350006000058 413 GRANT MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   132                                             132
2955825 2955825 NM     school 3500060 1   ALBUQUERQUE 350006000060 415 HARRISON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   133                                             133
2955827 2955827 NM     school 3500060 1   ALBUQUERQUE 350006000062 416 HAYES MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   137                                             137
2955834 2955834 NM     school 3500060 1   ALBUQUERQUE 350006000066 418 HOOVER MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   172                                             172
2955838 2955838 NM     school 3500060 1   ALBUQUERQUE 350006000068 420 JACKSON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   169                                             169
2955839 2955839 NM     school 3500060 1   ALBUQUERQUE 350006000825 490 JAMES MONROE MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   333                                             333
2955841 2955841 NM     school 3500060 1   ALBUQUERQUE 350006000069 425 JEFFERSON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   228                                             228
2955842 2955842 NM     school 3500060 1   ALBUQUERQUE 350006000812 445 JIMMY CARTER MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   246                                             246
2955843 2955843 NM     school 3500060 1   ALBUQUERQUE 350006000019 405 JOHN ADAMS MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   168                                             168
2955845 2955845 NM     school 3500060 1   ALBUQUERQUE 350006000071 427 KENNEDY MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   150                                             150
2955848 2955848 NM     school 3500060 1   ALBUQUERQUE 350006000065 485 L.B. JOHNSON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   215                                             215
2955861 2955861 NM     school 3500060 1   ALBUQUERQUE 350006000081 435 MADISON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   208                                             208
2955870 2955870 NM     school 3500060 1   ALBUQUERQUE 350006000615 440 MCKINLEY MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   143                                             143
2955893 2955893 NM     school 3500060 1   ALBUQUERQUE 350006000098 448 POLK MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   103                                             103
2955898 2955898 NM     school 3500060 1   ALBUQUERQUE 350006000102 452 ROOSEVELT MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   128                                             128
2955912 2955912 NM     school 3500060 1   ALBUQUERQUE 350006000111 455 TAFT MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   103                                             103
2955913 2955913 NM     school 3500060 1   ALBUQUERQUE 350006000112 457 TAYLOR MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   109                                             109
2955918 2955918 NM     school 3500060 1   ALBUQUERQUE 350006001047 492 TONY HILLERMAN MIDDLE SCHOOL Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   372                                             372
2955921 2955921 NM     school 3500060 1   ALBUQUERQUE 350006000114 475 TRUMAN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   314                                             314
2955924 2955924 NM     school 3500060 1   ALBUQUERQUE 350006000117 460 VAN BUREN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   180                                             180
2955927 2955927 NM     school 3500060 1   ALBUQUERQUE 350006000118 465 WASHINGTON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   156                                             156
2955932 2955932 NM     school 3500060 1   ALBUQUERQUE 350006000122 470 WILSON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   157                                             157
2955944 2955944 NM     school 3500090 30   ANIMAS 350009030019 20 ANIMAS MIDDLE Public - Middle School Regular School No Middle 05 06 2021   grade_8                                                   0                                             0
2955948 2955948 NM     school 3500120 22   ARTESIA 350012000134 189 ARTESIA ZIA INTERMEDIATE Public - Middle School Regular School No Middle 06 07 2021   grade_8                                                   0                                             0
2955959 2955959 NM     school 3500150 64   AZTEC 350015000136 17 C.V. KOOGLER MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   195                                             195
2955967 2955967 NM     school 3500180 87   BELEN 350018000141 25 BELEN MIDDLE Public - Middle School Regular School No Middle 07 08 2021   grade_8                                                   281                                             281
2955979 2955979 NM     school 3500210 61   BERNALILLO 350021000149 26 BERNALILLO MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   149                                             149
2955981 2955981 NM     school 3500210 61   BERNALILLO 350021000727 24 COCHITI MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   21                                             21
2955987 2955987 NM     school 3500210 61   BERNALILLO 350021000154 28 SANTO DOMINGO MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   26                                             26
2955999 2955999 NM     school 3500270 40   CAPITAN 350027000544 36 CAPITAN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   30                                             30
2956006 2956006 NM     school 3500300 20   CARLSBAD 350030000169 32 CARLSBAD INTERMEDIATE SCHOOL Public - Middle School Regular School No Middle 07 08 2021   grade_8                                                   465                                             465
2956007 2956007 NM     school 3500300 20   CARLSBAD 350030000162 18 CARLSBAD SIXTH GRADE ACADEMY Public - Middle School Regular School No Middle 06 06 2021   grade_8                                                   0                                             0
2956020 2956020 NM     school 3500330 37   CARRIZOZO 350033000178 157 CARRIZOZO MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   10                                             10
2956029 2956029 NM     school 3500390 67   CENTRAL CONS. 350039000180 34 KIRTLAND MIDDLE Public - Middle School Regular School No Middle 07 08 2021   grade_8                                                   218                                             218
2956035 2956035 NM     school 3500390 67   CENTRAL CONS. 350039000684 126 NEWCOMB MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   66                                             66
2956040 2956040 NM     school 3500390 67   CENTRAL CONS. 350039000189 160 TSE'BIT'AI MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   146                                             146
2956043 2956043 NM     school 3500420 53   CHAMA 350042000193 42 CHAMA MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   7                                             7
2956048 2956048 NM     school 3500480 8   CIMARRON 350048000699 36 CIMARRON MIDDLE Public - Middle School Regular School No Middle 05 08 2021   grade_8                                                   10                                             10
2956050 2956050 NM     school 3500480 8   CIMARRON 350048000302 48 EAGLE NEST MIDDLE Public - Middle School Regular School No Middle 05 08 2021   grade_8                                                   18                                             18
2956054 2956054 NM     school 3500510 84   CLAYTON 350051000204 38 CLAYTON JUNIOR HIGH Public - Middle School Regular School No Middle 07 08 2021   grade_8                                                   37                                             37
2956058 2956058 NM     school 3500540 48   CLOUDCROFT 350054030005 42 CLOUDCROFT MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   35                                             35
2956072 2956072 NM     school 3500570 12   CLOVIS 350057000218 91 MARSHALL MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_8                                                   200                                             200

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