enrollments

Data source: Big Local News · About: Big Local

14,925 rows where state = "NM" and year = 2020 sorted by ccd_school_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
2540747 2540747 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   pre_kindergarten                                                   0                                             0
2540788 2540788 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   pre_kindergarten                                                   37                                             37
2541070 2541070 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   85                                             85
2541126 2541126 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   151                                             151
2541186 2541186 NM     school 3501110 43   GALLUP 350111000833 177 EDUCATION DEV CENTER Public Special Education School No Other PK 12 2020   pre_kindergarten                                                   1                                             1
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
2541510 2541510 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   612                                             612
2541742 2541742 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   kindergarten_full_day                                                   0                                             0
2541783 2541783 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   kindergarten_full_day                                                   0                                             0
2542065 2542065 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   kindergarten_full_day                                                   0                                             0
2542121 2542121 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   kindergarten_full_day                                                   0                                             0
2542181 2542181 NM     school 3501110 43   GALLUP 350111000833 177 EDUCATION DEV CENTER Public Special Education School No Other PK 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
2542505 2542505 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   kindergarten_full_day                                                   0                                             0
2542737 2542737 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   grade_1                                                   0                                             0
2542778 2542778 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   grade_1                                                   0                                             0
2543060 2543060 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2543116 2543116 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2543176 2543176 NM     school 3501110 43   GALLUP 350111000833 177 EDUCATION DEV CENTER Public Special Education School No Other PK 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
2543500 2543500 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2543732 2543732 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   grade_2                                                   0                                             0
2543773 2543773 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   grade_2                                                   0                                             0
2544055 2544055 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_2                                                   0                                             0
2544111 2544111 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   grade_2                                                   0                                             0
2544171 2544171 NM     school 3501110 43   GALLUP 350111000833 177 EDUCATION DEV CENTER Public Special Education School No Other PK 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
2544495 2544495 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_2                                                   0                                             0
2544727 2544727 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   grade_3                                                   0                                             0
2544768 2544768 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   grade_3                                                   3                                             3
2545050 2545050 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_3                                                   0                                             0
2545106 2545106 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   grade_3                                                   0                                             0
2545166 2545166 NM     school 3501110 43   GALLUP 350111000833 177 EDUCATION DEV CENTER Public Special Education School No Other PK 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
2545490 2545490 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_3                                                   0                                             0
2545722 2545722 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   grade_4                                                   0                                             0
2545763 2545763 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   grade_4                                                   4                                             4
2546045 2546045 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_4                                                   0                                             0
2546101 2546101 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   grade_4                                                   0                                             0
2546161 2546161 NM     school 3501110 43   GALLUP 350111000833 177 EDUCATION DEV CENTER Public Special Education School No Other PK 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
2546485 2546485 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_4                                                   0                                             0
2546717 2546717 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   grade_5                                                   0                                             0
2546758 2546758 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   grade_5                                                   1                                             1
2547040 2547040 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_5                                                   0                                             0
2547096 2547096 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   grade_5                                                   0                                             0
2547156 2547156 NM     school 3501110 43   GALLUP 350111000833 177 EDUCATION DEV CENTER Public Special Education School No Other PK 12 2020   grade_5                                                   0                                             0
2547424 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
2547425 2547425 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_5                                                   9                                             9
2547480 2547480 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_5                                                   0                                             0
2547712 2547712 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   grade_6                                                   0                                             0
2547753 2547753 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   grade_6                                                   1                                             1
2548035 2548035 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_6                                                   0                                             0
2548091 2548091 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   grade_6                                                   0                                             0
2548151 2548151 NM     school 3501110 43   GALLUP 350111000833 177 EDUCATION DEV CENTER Public Special Education School No Other PK 12 2020   grade_6                                                   0                                             0
2548419 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
2548420 2548420 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_6                                                   11                                             11
2548475 2548475 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_6                                                   0                                             0
2548707 2548707 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   grade_7                                                   0                                             0
2548748 2548748 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   grade_7                                                   3                                             3
2549030 2549030 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2549086 2549086 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2549146 2549146 NM     school 3501110 43   GALLUP 350111000833 177 EDUCATION DEV CENTER Public Special Education School No Other PK 12 2020   grade_7                                                   0                                             0
2549414 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
2549415 2549415 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_7                                                   11                                             11
2549470 2549470 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_7                                                   0                                             0
2549702 2549702 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   grade_8                                                   0                                             0
2549743 2549743 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   grade_8                                                   1                                             1
2550025 2550025 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_8                                                   0                                             0
2550081 2550081 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   grade_8                                                   0                                             0
2550141 2550141 NM     school 3501110 43   GALLUP 350111000833 177 EDUCATION DEV CENTER Public Special Education School No Other PK 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
2550465 2550465 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_8                                                   0                                             0
2550697 2550697 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   grade_9                                                   3                                             3
2550738 2550738 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   grade_9                                                   7                                             7
2551020 2551020 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2551076 2551076 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2551136 2551136 NM     school 3501110 43   GALLUP 350111000833 177 EDUCATION DEV CENTER Public Special Education School No Other PK 12 2020   grade_9                                                   0                                             0
2551404 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
2551405 2551405 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_9                                                   10                                             10
2551460 2551460 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
2551692 2551692 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   grade_10                                                   0                                             0
2551733 2551733 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   grade_10                                                   4                                             4
2552015 2552015 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_10                                                   0                                             0
2552071 2552071 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   grade_10                                                   0                                             0
2552131 2552131 NM     school 3501110 43   GALLUP 350111000833 177 EDUCATION DEV CENTER Public Special Education School No Other PK 12 2020   grade_10                                                   0                                             0
2552399 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
2552400 2552400 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_10                                                   8                                             8
2552455 2552455 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_10                                                   0                                             0
2552687 2552687 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   grade_11                                                   0                                             0
2552728 2552728 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   grade_11                                                   0                                             0
2553010 2553010 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_11                                                   0                                             0
2553066 2553066 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   grade_11                                                   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]);