enrollments

Data source: Big Local News · About: Big Local

47,532 rows where state = "LA" and year = 2021 sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2021 · 47,532 ✖
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
1764801 1764801 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 2021 spring extension_academy                                                   0                                             0
1766198 1766198 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 2021 spring grade_1                                                   0                                             0
1767595 1767595 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 2021 spring grade_10                                                   84                                             84
1768992 1768992 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 2021 spring grade_11                                                   97                                             97
1770389 1770389 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 2021 spring grade_12                                                   130                                             130
1771786 1771786 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 2021 spring grade_2                                                   0                                             0
1773183 1773183 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 2021 spring grade_3                                                   0                                             0
1774580 1774580 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 2021 spring grade_4                                                   0                                             0
1775977 1775977 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 2021 spring grade_5                                                   0                                             0
1777374 1777374 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 2021 spring grade_6                                                   0                                             0
1778771 1778771 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 2021 spring grade_7                                                   0                                             0
1780168 1780168 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 2021 spring grade_8                                                   0                                             0
1781565 1781565 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 2021 spring grade_9                                                   0                                             0
1782962 1782962 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 2021 spring grade_9_transitional                                                   0                                             0
1784359 1784359 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 2021 spring kindergarten                                                   0                                             0
1785756 1785756 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 2021 spring pk_12_total 216.0 28.0 15.0 2.0   32.0     18.0   0.0   97.0 214.0     0.0       77.0         311 216 28 15 2   32     18   0   97 214     0   77       311
1787153 1787153 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 2021 spring pre_kindergarten                                                   0                                             0
1988555 1988555 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 2021 fall extension_academy                                                   0                                             0
1989954 1989954 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 2021 fall grade_1                                                   0                                             0
1991353 1991353 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 2021 fall grade_10                                                   89                                             89
1992752 1992752 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 2021 fall grade_11                                                   106                                             106
1994151 1994151 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 2021 fall grade_12                                                   132                                             132
1995550 1995550 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 2021 fall grade_2                                                   0                                             0
1996949 1996949 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 2021 fall grade_3                                                   0                                             0
1998348 1998348 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 2021 fall grade_4                                                   0                                             0
1999747 1999747 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 2021 fall grade_5                                                   0                                             0
2001146 2001146 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 2021 fall grade_6                                                   0                                             0
2002545 2002545 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 2021 fall grade_7                                                   0                                             0
2003944 2003944 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 2021 fall grade_8                                                   0                                             0
2005343 2005343 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 2021 fall grade_9                                                   0                                             0
2006742 2006742 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 2021 fall grade_9_transitional                                                   0                                             0
2008141 2008141 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 2021 fall kindergarten                                                   0                                             0
2009540 2009540 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 2021 fall pk_12_total 227.0 29.0 16.0 3.0   33.0     19.0   0.0   104.0 223.0     0.0       77.0         327 227 29 16 3   33     19   0   104 223     0   77       327
2010939 2010939 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 2021 fall pre_kindergarten                                                   0                                             0
1764802 1764802 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 2021 spring extension_academy                                                   0                                             0
1764803 1764803 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 2021 spring extension_academy                                                   0                                             0
1766199 1766199 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 2021 spring grade_1                                                   4                                             4
1766200 1766200 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 2021 spring grade_1                                                   2                                             2
1767596 1767596 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 2021 spring grade_10                                                   9                                             9
1767597 1767597 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 2021 spring grade_10                                                   6                                             6
1768993 1768993 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 2021 spring grade_11                                                   6                                             6
1768994 1768994 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 2021 spring grade_11                                                   11                                             11
1770390 1770390 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 2021 spring grade_12                                                   20                                             20
1770391 1770391 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 2021 spring grade_12                                                   10                                             10
1771787 1771787 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 2021 spring grade_2                                                   0                                             0
1771788 1771788 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 2021 spring grade_2                                                   4                                             4
1773184 1773184 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 2021 spring grade_3                                                   7                                             7
1773185 1773185 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 2021 spring grade_3                                                   5                                             5
1774581 1774581 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 2021 spring grade_4                                                   8                                             8
1774582 1774582 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 2021 spring grade_4                                                   7                                             7
1775978 1775978 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 2021 spring grade_5                                                   6                                             6
1775979 1775979 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 2021 spring grade_5                                                   3                                             3
1777375 1777375 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 2021 spring grade_6                                                   12                                             12
1777376 1777376 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 2021 spring grade_6                                                   4                                             4
1778772 1778772 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 2021 spring grade_7                                                   6                                             6
1778773 1778773 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 2021 spring grade_7                                                   6                                             6
1780169 1780169 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 2021 spring grade_8                                                   6                                             6
1780170 1780170 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 2021 spring grade_8                                                   0                                             0
1781566 1781566 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 2021 spring grade_9                                                   6                                             6
1781567 1781567 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 2021 spring grade_9                                                   2                                             2
1782963 1782963 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 2021 spring grade_9_transitional                                                   6                                             6
1782964 1782964 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 2021 spring grade_9_transitional                                                   1                                             1
1784360 1784360 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 2021 spring kindergarten                                                   2                                             2
1784361 1784361 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 2021 spring kindergarten                                                   2                                             2
1785757 1785757 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 2021 spring pk_12_total 26.0 64.0 10.0 1.0   0.0     0.0   2.0   51.0 52.0     5.0       98.0         103 26 64 10 1   0     0   2   51 52     5   98       103
1785758 1785758 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 2021 spring pk_12_total 18.0 38.0 7.0 0.0   1.0     0.0   4.0   39.0 29.0     4.0       64.0         68 18 38 7 0   1     0   4   39 29     4   64       68
1787154 1787154 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 2021 spring pre_kindergarten                                                   0                                             0
1787155 1787155 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 2021 spring pre_kindergarten                                                   0                                             0
1988556 1988556 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 2021 fall extension_academy                                                   0                                             0
1988557 1988557 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 2021 fall extension_academy                                                   0                                             0
1989955 1989955 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 2021 fall grade_1                                                   5                                             5
1989956 1989956 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 2021 fall grade_1                                                   2                                             2
1991354 1991354 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 2021 fall grade_10                                                   9                                             9
1991355 1991355 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 2021 fall grade_10                                                   7                                             7
1992753 1992753 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 2021 fall grade_11                                                   6                                             6
1992754 1992754 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 2021 fall grade_11                                                   9                                             9
1994152 1994152 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 2021 fall grade_12                                                   20                                             20
1994153 1994153 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 2021 fall grade_12                                                   12                                             12
1995551 1995551 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 2021 fall grade_2                                                   0                                             0
1995552 1995552 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 2021 fall grade_2                                                   4                                             4
1996950 1996950 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 2021 fall grade_3                                                   7                                             7
1996951 1996951 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 2021 fall grade_3                                                   5                                             5
1998349 1998349 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 2021 fall grade_4                                                   8                                             8
1998350 1998350 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 2021 fall grade_4                                                   7                                             7
1999748 1999748 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 2021 fall grade_5                                                   6                                             6
1999749 1999749 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 2021 fall grade_5                                                   3                                             3
2001147 2001147 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 2021 fall grade_6                                                   11                                             11
2001148 2001148 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 2021 fall grade_6                                                   4                                             4
2002546 2002546 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 2021 fall grade_7                                                   6                                             6
2002547 2002547 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 2021 fall grade_7                                                   6                                             6
2003945 2003945 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 2021 fall grade_8                                                   6                                             6
2003946 2003946 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 2021 fall grade_8                                                   0                                             0
2005344 2005344 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 2021 fall grade_9                                                   6                                             6
2005345 2005345 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 2021 fall grade_9                                                   3                                             3
2006743 2006743 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 2021 fall grade_9_transitional                                                   6                                             6
2006744 2006744 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 2021 fall grade_9_transitional                                                   1                                             1
2008142 2008142 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 2021 fall kindergarten                                                   1                                             1
2008143 2008143 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 2021 fall kindergarten                                                   2                                             2
2009541 2009541 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 2021 fall pk_12_total 25.0 61.0 9.0 1.0   0.0     0.0   2.0   48.0 50.0     5.0       94.0         98 25 61 9 1   0     0   2   48 50     5   94       98
2009542 2009542 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 2021 fall pk_12_total 20.0 39.0 6.0 0.0   1.0     0.0   4.0   42.0 28.0     4.0       66.0         70 20 39 6 0   1     0   4   42 28     4   66       70

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