Data source: Big Local News · About: Big Local

29,595 rows where state = "NM" sorted by district_state_id descending

View and edit SQL

grade

year

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
2960228 NM     school   99   JUVENILE JUSTICE   0 JUVENILE JUSTICE DISTRICT OFFICE Central Office - Central Office           2021   grade_12                                                   0                                             0
2961203 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported - State Supported Alternative School No High 09 12 2021   pk_12_total * * 13   * *     *   *                             18     13                                       18
2961204 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported - State Supported Alternative School No High 06 12 2021   pk_12_total * 6 22   * *     *   *                             33   6 22                                       33
2961205 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported - State Supported Alternative School No High 06 12 2021   pk_12_total 6 * 24   * *     *   *                             34 6   24                                       34
2961206 NM     school   99   JUVENILE JUSTICE   0 JUVENILE JUSTICE DISTRICT OFFICE Central Office - Central Office           2021   pk_12_total * * *   * *     *   *                             1                                             1
2541594 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   pre_kindergarten                                                   0                                             0
2542589 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   kindergarten_full_day                                                   0                                             0
2543584 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_1                                                   0                                             0
2544579 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_2                                                   0                                             0
2545574 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_3                                                   0                                             0
2546569 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_4                                                   0                                             0
2547564 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_5                                                   0                                             0
2548559 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_6                                                   0                                             0
2549554 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_7                                                   1                                             1
2550549 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_8                                                   4                                             4
2551544 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_9                                                   11                                             11
2552539 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_10                                                   6                                             6
2553534 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_11                                                   3                                             3
2554529 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_12                                                   0                                             0
2555524 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   pk_12_total 7 * 15   * *     *   *                             25 7   15                                       25
2947814 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   pre_kindergarten                                                   0                                             0
2948792 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   kindergarten_full_day                                                   0                                             0
2949770 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   grade_1                                                   0                                             0
2950748 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   grade_2                                                   0                                             0
2951726 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   grade_3                                                   0                                             0
2952704 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   grade_4                                                   0                                             0
2953682 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   grade_5                                                   0                                             0
2954660 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   grade_6                                                   0                                             0
2955638 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   grade_7                                                   0                                             0
2956616 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   grade_8                                                   2                                             2
2957594 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   grade_9                                                   8                                             8
2958572 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   grade_10                                                   2                                             2
2959550 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   grade_11                                                   0                                             0
2960528 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   grade_12                                                   0                                             0
2961506 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   pk_12_total * * 8   * *     *   *                             12     8                                       12
2541008 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   pre_kindergarten                                                   0                                             0
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
2542998 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_1                                                   0                                             0
2543993 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_2                                                   1                                             1
2544988 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_3                                                   0                                             0
2545983 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_4                                                   0                                             0
2546978 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_5                                                   5                                             5
2547973 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_6                                                   7                                             7
2548968 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_7                                                   5                                             5
2549963 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_8                                                   5                                             5
2550958 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_9                                                   4                                             4
2551953 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_10                                                   8                                             8
2552948 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_11                                                   3                                             3
2553943 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_12                                                   2                                             2
2554938 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   pk_12_total 17 * 20   * *     *   *                             41 17   20                                       41
2947888 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   pre_kindergarten                                                   0                                             0
2948866 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   kindergarten_full_day                                                   1                                             1
2949844 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   grade_1                                                   1                                             1
2950822 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   grade_2                                                   0                                             0
2951800 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   grade_3                                                   4                                             4
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
2953756 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   grade_5                                                   1                                             1
2954734 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   grade_6                                                   6                                             6
2955712 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   grade_7                                                   4                                             4
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
2957668 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   grade_9                                                   3                                             3
2958646 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   grade_10                                                   9                                             9
2959624 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   grade_11                                                   0                                             0
2960602 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   grade_12                                                   4                                             4
2961580 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   pk_12_total 17 * 19   * *     *   *                             41 17   19                                       41
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
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
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
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
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
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
2547424 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_5                                                   1                                             1
2548419 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_6                                                   2                                             2
2549414 NM     school 3500013 94   NM SCHOOL FOR THE BLIND AND VISUALLY IMP 350001300980 15 NM SCHOOL FOR THE BLIND AND VISUALLY IMPAIRED State Supported Special Education School No Other PK 12 2020   grade_7                                                   2                                             2
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
2551404 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_9                                                   3                                             3
2552399 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_10                                                   3                                             3
2553394 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_11                                                   3                                             3
2554389 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_12                                                   3                                             3
2555384 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   pk_12_total 12 * 11   * *     *   *                             30 12   11                                       30
2947677 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   pre_kindergarten                                                   5                                             5
2948655 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   kindergarten_full_day                                                   4                                             4
2949633 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_1                                                   1                                             1
2950611 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_2                                                   3                                             3
2951589 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_3                                                   2                                             2
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
2953545 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_5                                                   0                                             0
2954523 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_6                                                   2                                             2
2955501 NM     school 3500013 94   NM SCHOOL FOR THE BLIND AND VISUALLY IMP 350001300980 15 NM SCHOOL FOR THE BLIND AND VISUALLY IMPAIRED State Supported - State Supported Special Education School No Other PK 12 2021   grade_7                                                   3                                             3
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
2957457 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_9                                                   0                                             0
2958435 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_10                                                   1                                             1
2959413 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_11                                                   4                                             4
2960391 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_12                                                   6                                             6
2961369 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   pk_12_total 14 * 16   * *     *   *                             37 14   16                                       37
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
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
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
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
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

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