Data source: Big Local News · About: Big Local

44,816 rows where state = "LA" and year = 2020 sorted by school_nces_id

View and edit SQL

grade

year

  • 2020 · 44,816
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
595918 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 spring grade_1                                                   0                                             0
597318 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 spring grade_10                                                   78                                             78
598718 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 spring grade_11                                                   138                                             138
600118 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 spring grade_12                                                   114                                             114
601518 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 spring grade_2                                                   0                                             0
602918 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 spring grade_3                                                   0                                             0
604318 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 spring grade_4                                                   0                                             0
605718 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 spring grade_5                                                   0                                             0
607118 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 spring grade_6                                                   0                                             0
608518 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 spring grade_7                                                   0                                             0
609918 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 spring grade_8                                                   0                                             0
611318 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 spring grade_9                                                   0                                             0
612718 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 spring grade_9_transitional                                                   0                                             0
614118 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 spring kindergarten                                                   0                                             0
615518 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 spring pk_12_total 218.0 37.0 15.0 4.0   34.0     22.0   0.0   114.0 216.0     0.0       68.0         330 218 37 15 4   34     22   0   114 216     0   68       330
616918 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 spring pre_kindergarten                                                   0                                             0
2012342 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 fall grade_1                                                   0                                             0
2013743 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 fall grade_10                                                   86                                             86
2015144 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 fall grade_11                                                   154                                             154
2016545 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 fall grade_12                                                   118                                             118
2017946 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 fall grade_2                                                   0                                             0
2019347 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 fall grade_3                                                   0                                             0
2020748 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 fall grade_4                                                   0                                             0
2022149 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 fall grade_5                                                   0                                             0
2023550 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 fall grade_6                                                   0                                             0
2024951 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 fall grade_7                                                   0                                             0
2026352 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 fall grade_8                                                   0                                             0
2027753 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 fall grade_9                                                   0                                             0
2029154 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 fall grade_9_transitional                                                   0                                             0
2030555 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 fall kindergarten                                                   0                                             0
2031956 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 fall pk_12_total 240.0 42.0 15.0 5.0   34.0     22.0   0.0   127.0 231.0     0.0       70.0         358 240 42 15 5   34     22   0   127 231     0   70       358
2033357 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 fall pre_kindergarten                                                   0                                             0
595920 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 spring grade_1                                                   3                                             3
597320 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 spring grade_10                                                   11                                             11
598720 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 spring grade_11                                                   9                                             9
600120 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 spring grade_12                                                   8                                             8
601520 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 spring grade_2                                                   7                                             7
602920 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 spring grade_3                                                   7                                             7
604320 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 spring grade_4                                                   3                                             3
605720 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 spring grade_5                                                   1                                             1
607120 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 spring grade_6                                                   7                                             7
608520 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 spring grade_7                                                   1                                             1
609920 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 spring grade_8                                                   3                                             3
611320 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 spring grade_9                                                   8                                             8
612720 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 spring grade_9_transitional                                                   1                                             1
614120 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 spring kindergarten                                                   1                                             1
615520 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 spring pk_12_total 27.0 39.0 6.0 0.0   2.0     0.0   1.0   41.0 34.0     5.0       71.0         75 27 39 6 0   2     0   1   41 34     5   71       75
616920 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 spring pre_kindergarten                                                   0                                             0
2012344 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 fall grade_1                                                   3                                             3
2013745 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 fall grade_10                                                   11                                             11
2015146 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 fall grade_11                                                   8                                             8
2016547 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 fall grade_12                                                   8                                             8
2017948 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 fall grade_2                                                   7                                             7
2019349 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 fall grade_3                                                   7                                             7
2020750 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 fall grade_4                                                   3                                             3
2022151 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 fall grade_5                                                   1                                             1
2023552 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 fall grade_6                                                   7                                             7
2024953 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 fall grade_7                                                   1                                             1
2026354 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 fall grade_8                                                   3                                             3
2027755 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 fall grade_9                                                   8                                             8
2029156 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 fall grade_9_transitional                                                   2                                             2
2030557 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 fall kindergarten                                                   1                                             1
2031958 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 fall pk_12_total 27.0 37.0 6.0 0.0   2.0     0.0   1.0   40.0 33.0     3.0       69.0         73 27 37 6 0   2     0   1   40 33     3   69       73
2033359 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 fall pre_kindergarten                                                   0                                             0
595919 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 spring grade_1                                                   1                                             1
597319 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 spring grade_10                                                   7                                             7
598719 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 spring grade_11                                                   16                                             16
600119 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 spring grade_12                                                   19                                             19
601519 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 spring grade_2                                                   7                                             7
602919 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 spring grade_3                                                   9                                             9
604319 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 spring grade_4                                                   6                                             6
605719 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 spring grade_5                                                   11                                             11
607119 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 spring grade_6                                                   6                                             6
608519 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 spring grade_7                                                   6                                             6
609919 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 spring grade_8                                                   10                                             10
611319 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 spring grade_9                                                   8                                             8
612719 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 spring grade_9_transitional                                                   5                                             5
614119 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 spring kindergarten                                                   4                                             4
615519 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 spring pk_12_total 33.0 73.0 9.0 1.0   0.0     0.0   1.0   59.0 58.0     4.0       113.0         117 33 73 9 1   0     0   1   59 58     4   113       117
616919 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 spring pre_kindergarten                                                   0                                             0
2012343 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 fall grade_1                                                   1                                             1
2013744 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 fall grade_10                                                   7                                             7
2015145 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 fall grade_11                                                   15                                             15
2016546 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 fall grade_12                                                   19                                             19
2017947 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 fall grade_2                                                   7                                             7
2019348 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 fall grade_3                                                   9                                             9
2020749 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 fall grade_4                                                   5                                             5
2022150 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 fall grade_5                                                   10                                             10
2023551 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 fall grade_6                                                   6                                             6
2024952 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 fall grade_7                                                   6                                             6
2026353 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 fall grade_8                                                   11                                             11
2027754 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 fall grade_9                                                   8                                             8
2029155 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 fall grade_9_transitional                                                   5                                             5
2030556 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 fall kindergarten                                                   4                                             4
2031957 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 fall pk_12_total 31.0 73.0 9.0 1.0   0.0     0.0   1.0   58.0 57.0     1.0       112.0         115 31 73 9 1   0     0   1   58 57     1   112       115
2033358 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 fall pre_kindergarten                                                   0                                             0
595921 LA     school 2200020 306   Central Louisiana Supports and Services Center 220002000267 306001 Central Louisiana Supports and Services Center   Special Education School No Other PK 12 2020 spring grade_1                                                   0                                             0
597321 LA     school 2200020 306   Central Louisiana Supports and Services Center 220002000267 306001 Central Louisiana Supports and Services Center   Special Education School No Other PK 12 2020 spring grade_10                                                   3                                             3
598721 LA     school 2200020 306   Central Louisiana Supports and Services Center 220002000267 306001 Central Louisiana Supports and Services Center   Special Education School No Other PK 12 2020 spring grade_11                                                   5                                             5
600121 LA     school 2200020 306   Central Louisiana Supports and Services Center 220002000267 306001 Central Louisiana Supports and Services Center   Special Education School No Other PK 12 2020 spring grade_12                                                   12                                             12

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