enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
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
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
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
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
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
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
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
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
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
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
2546569 2546569 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_4                                                   0                                             0
2951918 2951918 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public - Special Education Special Education School No Other PK 12 2021   grade_4                                                   2                                             2
2952191 2952191 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public - Special Education Special Education School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
2952245 2952245 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public - Special Education Special Education School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
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
2951843 2951843 NM     school 3500030 46   ALAMOGORDO 350003001158 182 STEPPING STONES PRESCHOOL Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
2952099 2952099 NM     school 3500300 20   CARLSBAD 350030001148 58 HILLCREST PRESCHOOL Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
2952118 2952118 NM     school 3500390 67   CENTRAL CONS. 350039000947 24 KIRTLAND PRE-K EARLY Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
2952159 2952159 NM     school 3500570 12   CLOVIS 350057000793 3 LOS NINOS Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
2952246 2952246 NM     school 3500990 65   FARMINGTON 350099001091 56 FARMINGTON PRESCHOOL ACADEMY WEST Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
2952269 2952269 NM     school 3501080 19   GADSDEN 350108001132 60 ANTHONY ON-TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
2952274 2952274 NM     school 3501080 19   GADSDEN 350108001131 61 CHAPARRAL ON-TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
2952277 2952277 NM     school 3501080 19   GADSDEN 350108001129 62 GADSDEN ADMIN COMPLEX PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
2952282 2952282 NM     school 3501080 19   GADSDEN 350108001130 63 LA MESA ON TRACK PREK CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
2952541 2952541 NM     school 3501890 81   MORIARTY-EDGEWOOD 350189001145 151 EARLY CHILDHOOD CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
2952642 2952642 NM     school 3502250 4   ROSWELL 350225000519 122 PARKVIEW EARLY LITERACY CENTER Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
2952685 2952685 NM     school 3502370 71   SANTA FE 350237030025 168 NYE EARLY CHILDHOOD Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
2952715 2952715 NM     school 3502430 23   SILVER CITY 350243001141 12 SILVER SCHOLARS ACADEMY Public - Prekindergarten Regular School No Prekindergarten PK PK 2021   grade_4                                                   0                                             0
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
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
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
2951873 2951873 NM     school 3500060 1   ALBUQUERQUE 350006000617 407 CLEVELAND MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951886 2951886 NM     school 3500060 1   ALBUQUERQUE 350006000764 430 DESERT RIDGE MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951898 2951898 NM     school 3500060 1   ALBUQUERQUE 350006000049 480 EISENHOWER MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951902 2951902 NM     school 3500060 1   ALBUQUERQUE 350006000052 450 ERNIE PYLE MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951905 2951905 NM     school 3500060 1   ALBUQUERQUE 350006000056 410 GARFIELD MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951911 2951911 NM     school 3500060 1   ALBUQUERQUE 350006000058 413 GRANT MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951913 2951913 NM     school 3500060 1   ALBUQUERQUE 350006000060 415 HARRISON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951915 2951915 NM     school 3500060 1   ALBUQUERQUE 350006000062 416 HAYES MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951922 2951922 NM     school 3500060 1   ALBUQUERQUE 350006000066 418 HOOVER MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951926 2951926 NM     school 3500060 1   ALBUQUERQUE 350006000068 420 JACKSON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951927 2951927 NM     school 3500060 1   ALBUQUERQUE 350006000825 490 JAMES MONROE MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951929 2951929 NM     school 3500060 1   ALBUQUERQUE 350006000069 425 JEFFERSON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951930 2951930 NM     school 3500060 1   ALBUQUERQUE 350006000812 445 JIMMY CARTER MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951931 2951931 NM     school 3500060 1   ALBUQUERQUE 350006000019 405 JOHN ADAMS MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951933 2951933 NM     school 3500060 1   ALBUQUERQUE 350006000071 427 KENNEDY MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951936 2951936 NM     school 3500060 1   ALBUQUERQUE 350006000065 485 L.B. JOHNSON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951949 2951949 NM     school 3500060 1   ALBUQUERQUE 350006000081 435 MADISON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951958 2951958 NM     school 3500060 1   ALBUQUERQUE 350006000615 440 MCKINLEY MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951981 2951981 NM     school 3500060 1   ALBUQUERQUE 350006000098 448 POLK MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2951986 2951986 NM     school 3500060 1   ALBUQUERQUE 350006000102 452 ROOSEVELT MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952000 2952000 NM     school 3500060 1   ALBUQUERQUE 350006000111 455 TAFT MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952001 2952001 NM     school 3500060 1   ALBUQUERQUE 350006000112 457 TAYLOR MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952006 2952006 NM     school 3500060 1   ALBUQUERQUE 350006001047 492 TONY HILLERMAN MIDDLE SCHOOL Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952009 2952009 NM     school 3500060 1   ALBUQUERQUE 350006000114 475 TRUMAN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952012 2952012 NM     school 3500060 1   ALBUQUERQUE 350006000117 460 VAN BUREN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952015 2952015 NM     school 3500060 1   ALBUQUERQUE 350006000118 465 WASHINGTON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952020 2952020 NM     school 3500060 1   ALBUQUERQUE 350006000122 470 WILSON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952032 2952032 NM     school 3500090 30   ANIMAS 350009030019 20 ANIMAS MIDDLE Public - Middle School Regular School No Middle 05 06 2021   grade_4                                                   0                                             0
2952036 2952036 NM     school 3500120 22   ARTESIA 350012000134 189 ARTESIA ZIA INTERMEDIATE Public - Middle School Regular School No Middle 06 07 2021   grade_4                                                   0                                             0
2952047 2952047 NM     school 3500150 64   AZTEC 350015000136 17 C.V. KOOGLER MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952055 2952055 NM     school 3500180 87   BELEN 350018000141 25 BELEN MIDDLE Public - Middle School Regular School No Middle 07 08 2021   grade_4                                                   0                                             0
2952067 2952067 NM     school 3500210 61   BERNALILLO 350021000149 26 BERNALILLO MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952069 2952069 NM     school 3500210 61   BERNALILLO 350021000727 24 COCHITI MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952075 2952075 NM     school 3500210 61   BERNALILLO 350021000154 28 SANTO DOMINGO MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952087 2952087 NM     school 3500270 40   CAPITAN 350027000544 36 CAPITAN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952094 2952094 NM     school 3500300 20   CARLSBAD 350030000169 32 CARLSBAD INTERMEDIATE SCHOOL Public - Middle School Regular School No Middle 07 08 2021   grade_4                                                   0                                             0
2952095 2952095 NM     school 3500300 20   CARLSBAD 350030000162 18 CARLSBAD SIXTH GRADE ACADEMY Public - Middle School Regular School No Middle 06 06 2021   grade_4                                                   0                                             0
2952108 2952108 NM     school 3500330 37   CARRIZOZO 350033000178 157 CARRIZOZO MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952117 2952117 NM     school 3500390 67   CENTRAL CONS. 350039000180 34 KIRTLAND MIDDLE Public - Middle School Regular School No Middle 07 08 2021   grade_4                                                   0                                             0
2952123 2952123 NM     school 3500390 67   CENTRAL CONS. 350039000684 126 NEWCOMB MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952128 2952128 NM     school 3500390 67   CENTRAL CONS. 350039000189 160 TSE'BIT'AI MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952131 2952131 NM     school 3500420 53   CHAMA 350042000193 42 CHAMA MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952136 2952136 NM     school 3500480 8   CIMARRON 350048000699 36 CIMARRON MIDDLE Public - Middle School Regular School No Middle 05 08 2021   grade_4                                                   0                                             0
2952138 2952138 NM     school 3500480 8   CIMARRON 350048000302 48 EAGLE NEST MIDDLE Public - Middle School Regular School No Middle 05 08 2021   grade_4                                                   0                                             0
2952142 2952142 NM     school 3500510 84   CLAYTON 350051000204 38 CLAYTON JUNIOR HIGH Public - Middle School Regular School No Middle 07 08 2021   grade_4                                                   0                                             0
2952146 2952146 NM     school 3500540 48   CLOUDCROFT 350054030005 42 CLOUDCROFT MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2952160 2952160 NM     school 3500570 12   CLOVIS 350057000218 91 MARSHALL 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]);