enrollments

Data source: Big Local News · About: Big Local

14,925 rows where state = "NM" and year = 2020 sorted by school_state_type descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 14,925 ✖
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
2541008 2541008 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   pre_kindergarten                                                   0                                             0
2541285 2541285 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported Alternative School No High 09 12 2020   pre_kindergarten                                                   0                                             0
2541286 2541286 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported Alternative School No High 06 12 2020   pre_kindergarten                                                   0                                             0
2541287 2541287 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported Alternative School No High 06 12 2020   pre_kindergarten                                                   0                                             0
2541443 2541443 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2541444 2541444 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2541445 2541445 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2541446 2541446 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2541447 2541447 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported Alternative School No Secondary 09 11 2020   pre_kindergarten                                                   0                                             0
2541448 2541448 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2541449 2541449 NM     school 3500012 91   NM CORRECTIONS 350001200970 5 ROSWELL CORRECTIONS State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2541450 2541450 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2541451 2541451 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2541452 2541452 NM     school 3500012 91   NM CORRECTIONS 350001200979 8 WESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2541454 2541454 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   pre_kindergarten                                                   2                                             2
2541455 2541455 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   pre_kindergarten                                                   7                                             7
2541594 2541594 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   pre_kindergarten                                                   0                                             0
2542003 2542003 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   kindergarten_full_day                                                   1                                             1
2542280 2542280 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported Alternative School No High 09 12 2020   kindergarten_full_day                                                   0                                             0
2542281 2542281 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported Alternative School No High 06 12 2020   kindergarten_full_day                                                   0                                             0
2542282 2542282 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported Alternative School No High 06 12 2020   kindergarten_full_day                                                   0                                             0
2542438 2542438 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported Alternative School No High 08 12 2020   kindergarten_full_day                                                   0                                             0
2542439 2542439 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported Alternative School No High 08 12 2020   kindergarten_full_day                                                   0                                             0
2542440 2542440 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   kindergarten_full_day                                                   0                                             0
2542441 2542441 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   kindergarten_full_day                                                   0                                             0
2542442 2542442 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported Alternative School No Secondary 09 11 2020   kindergarten_full_day                                                   0                                             0
2542443 2542443 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported Alternative School No High 08 12 2020   kindergarten_full_day                                                   0                                             0
2542444 2542444 NM     school 3500012 91   NM CORRECTIONS 350001200970 5 ROSWELL CORRECTIONS State Supported Alternative School No High 08 12 2020   kindergarten_full_day                                                   0                                             0
2542445 2542445 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   kindergarten_full_day                                                   0                                             0
2542446 2542446 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   kindergarten_full_day                                                   0                                             0
2542447 2542447 NM     school 3500012 91   NM CORRECTIONS 350001200979 8 WESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   kindergarten_full_day                                                   0                                             0
2542449 2542449 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   kindergarten_full_day                                                   2                                             2
2542450 2542450 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   kindergarten_full_day                                                   5                                             5
2542589 2542589 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   kindergarten_full_day                                                   0                                             0
2542998 2542998 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_1                                                   0                                             0
2543275 2543275 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported Alternative School No High 09 12 2020   grade_1                                                   0                                             0
2543276 2543276 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported Alternative School No High 06 12 2020   grade_1                                                   0                                             0
2543277 2543277 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported Alternative School No High 06 12 2020   grade_1                                                   0                                             0
2543433 2543433 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_1                                                   0                                             0
2543434 2543434 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_1                                                   0                                             0
2543435 2543435 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_1                                                   0                                             0
2543436 2543436 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_1                                                   0                                             0
2543437 2543437 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported Alternative School No Secondary 09 11 2020   grade_1                                                   0                                             0
2543438 2543438 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported Alternative School No High 08 12 2020   grade_1                                                   0                                             0
2543439 2543439 NM     school 3500012 91   NM CORRECTIONS 350001200970 5 ROSWELL CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_1                                                   0                                             0
2543440 2543440 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_1                                                   0                                             0
2543441 2543441 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_1                                                   0                                             0
2543442 2543442 NM     school 3500012 91   NM CORRECTIONS 350001200979 8 WESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_1                                                   0                                             0
2543444 2543444 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_1                                                   3                                             3
2543445 2543445 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_1                                                   4                                             4
2543584 2543584 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_1                                                   0                                             0
2543993 2543993 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_2                                                   1                                             1
2544270 2544270 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported Alternative School No High 09 12 2020   grade_2                                                   0                                             0
2544271 2544271 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported Alternative School No High 06 12 2020   grade_2                                                   0                                             0
2544272 2544272 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported Alternative School No High 06 12 2020   grade_2                                                   0                                             0
2544428 2544428 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_2                                                   0                                             0
2544429 2544429 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_2                                                   0                                             0
2544430 2544430 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_2                                                   0                                             0
2544431 2544431 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_2                                                   0                                             0
2544432 2544432 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported Alternative School No Secondary 09 11 2020   grade_2                                                   0                                             0
2544433 2544433 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported Alternative School No High 08 12 2020   grade_2                                                   0                                             0
2544434 2544434 NM     school 3500012 91   NM CORRECTIONS 350001200970 5 ROSWELL CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_2                                                   0                                             0
2544435 2544435 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_2                                                   0                                             0
2544436 2544436 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_2                                                   0                                             0
2544437 2544437 NM     school 3500012 91   NM CORRECTIONS 350001200979 8 WESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_2                                                   0                                             0
2544439 2544439 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_2                                                   0                                             0
2544440 2544440 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_2                                                   11                                             11
2544579 2544579 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_2                                                   0                                             0
2544988 2544988 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_3                                                   0                                             0
2545265 2545265 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported Alternative School No High 09 12 2020   grade_3                                                   0                                             0
2545266 2545266 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported Alternative School No High 06 12 2020   grade_3                                                   0                                             0
2545267 2545267 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported Alternative School No High 06 12 2020   grade_3                                                   0                                             0
2545423 2545423 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545424 2545424 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545425 2545425 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545426 2545426 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545427 2545427 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported Alternative School No Secondary 09 11 2020   grade_3                                                   0                                             0
2545428 2545428 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545429 2545429 NM     school 3500012 91   NM CORRECTIONS 350001200970 5 ROSWELL CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545430 2545430 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545431 2545431 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545432 2545432 NM     school 3500012 91   NM CORRECTIONS 350001200979 8 WESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545434 2545434 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_3                                                   2                                             2
2545435 2545435 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_3                                                   11                                             11
2545574 2545574 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_3                                                   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
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

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