enrollments

Data source: Big Local News · About: Big Local

137,628 rows where state = "LA" sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

Link rowid state county county_state_id admin_level district_nces_id ▼ district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2008272 2008272 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2021 fall pk_12_total 263.0 228.0 20.0 0.0   2.0     0.0   33.0   267.0 279.0     4.0       467.0         546 263 228 20 0   2     0   33   267 279     4   467       546
2008273 2008273 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2021 fall pk_12_total 182.0 240.0 28.0 1.0   2.0     0.0   22.0   244.0 231.0     11.0       437.0         475 182 240 28 1   2     0   22   244 231     11   437       475
2008274 2008274 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2021 fall pk_12_total 119.0 117.0 16.0 1.0   0.0     0.0   9.0   119.0 143.0     6.0       245.0         262 119 117 16 1   0     0   9   119 143     6   245       262
2008275 2008275 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary KG 05 2021 fall pk_12_total 115.0 140.0 19.0 0.0   0.0     0.0   12.0   148.0 138.0     3.0       263.0         286 115 140 19 0   0     0   12   148 138     3   263       286
2008276 2008276 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2021 fall pk_12_total 241.0 3.0 3.0 0.0   0.0     0.0   1.0   128.0 120.0     2.0       151.0         248 241 3 3 0   0     0   1   128 120     2   151       248
2008277 2008277 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2021 fall pk_12_total 205.0 10.0 4.0 0.0   0.0     0.0   8.0   117.0 110.0     0.0       172.0         227 205 10 4 0   0     0   8   117 110     0   172       227
2008278 2008278 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2021 fall pk_12_total 184.0 3.0 7.0 2.0   0.0     0.0   7.0   102.0 101.0     0.0       139.0         203 184 3 7 2   0     0   7   102 101     0   139       203
2008279 2008279 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2021 fall pk_12_total 563.0 15.0 22.0 1.0   1.0     0.0   25.0   320.0 307.0     7.0       365.0         627 563 15 22 1   1     0   25   320 307     7   365       627
2008280 2008280 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2021 fall pk_12_total 285.0 7.0 11.0 0.0   1.0     0.0   14.0   166.0 152.0     2.0       180.0         318 285 7 11 0   1     0   14   166 152     2   180       318
2008281 2008281 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2021 fall pk_12_total 132.0 19.0 0.0 0.0   1.0     0.0   0.0   71.0 81.0     0.0       94.0         152 132 19 0 0   1     0   0   71 81     0   94       152
2008282 2008282 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2021 fall pk_12_total 260.0 11.0 2.0 0.0   0.0     0.0   10.0   144.0 139.0     0.0       194.0         283 260 11 2 0   0     0   10   144 139     0   194       283
2008283 2008283 LA     school 2200030 001   Acadia Parish 220003000017 1018 Mire Elementary School   Regular School No Elementary PK 08 2021 fall pk_12_total 565.0 42.0 24.0 1.0   0.0     0.0   31.0   322.0 340.99999999999994     2.0       401.0         663 565 42 24 1   0     0   31   322       2   401       663
2008284 2008284 LA     school 2200030 001   Acadia Parish 220003000018 1019 Morse Elementary School   Regular School No Elementary PK 07 2021 fall pk_12_total 210.0 3.0 0.0 0.0   0.0     0.0   7.0   109.0 111.0     0.0       164.0         220 210 3 0 0   0     0   7   109 111     0   164       220
2008285 2008285 LA     school 2200030 001   Acadia Parish 220003001504 1020 Martin Petitjean Elementary School   Regular School No Elementary 01 03 2021 fall pk_12_total 132.0 152.0 10.0 1.0   0.0     0.0   35.0   163.0 167.0     2.0       297.0         330 132 152 10 1   0     0   35   163 167     2   297       330
2008286 2008286 LA     school 2200030 001   Acadia Parish 220003000019 1021 Rayne High School   Regular School No High 08 12 2021 fall pk_12_total 401.0 195.0 18.0 0.0   2.0     0.0   25.0   343.0 298.0     2.0       432.0         641 401 195 18 0   2     0   25   343 298     2   432       641
2008287 2008287 LA     school 2200030 001   Acadia Parish 220003000020 1022 Richard Elementary School   Regular School No Elementary PK 08 2021 fall pk_12_total 433.0 20.0 18.0 0.0   1.0     0.0   24.0   240.0 256.0     4.0       304.0         496 433 20 18 0   1     0   24   240 256     4   304       496
2008288 2008288 LA     school 2200030 001   Acadia Parish 220003000021 1023 Ross Elementary School   Regular School No Elementary KG 06 2021 fall pk_12_total 61.0 157.0 8.0 1.0   1.0     0.0   16.0   123.0 121.0     6.0       239.0         244 61 157 8 1   1     0   16   123 121     6   239       244
2008289 2008289 LA     school 2200030 001   Acadia Parish 220003000022 1024 South Crowley Elementary School   Regular School No Elementary KG 05 2021 fall pk_12_total 139.0 85.0 25.0 0.0   0.0     0.0   30.0   135.0 144.0     6.000000000000001       255.0         279 139 85 25 0   0     0   30   135 144         255       279
2008290 2008290 LA     school 2200030 001   Acadia Parish 220003000023 1025 South Rayne Elementary School   Regular School No Middle 04 06 2021 fall pk_12_total 101.0 109.0 12.0 0.0   1.0     0.0   20.0   135.0 108.0     1.0       218.0         243 101 109 12 0   1     0   20   135 108     1   218       243
2008294 2008294 LA     school 2200030 001   Acadia Parish 220003000014 1034 Iota High School   Regular School No High 05 12 2021 fall pk_12_total 578.0 8.0 16.0 2.0   0.0     0.0   22.0   334.00000000000006 292.0     4.0       329.0         626 578 8 16 2   0     0   22     292     4   329       626
2008296 2008296 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall pk_12_total 7.0 16.0 1.0 0.0   0.0     0.0   0.0   24.0 0.0     0.0       24.0         24 7 16 1 0   0     0   0   24 0     0   24       24
2009665 2009665 LA     school 2200030 001   Acadia Parish 220003000001 1001 Armstrong Middle School   Regular School No Middle 06 08 2021 fall pre_kindergarten                                                   0                                             0
2009666 2009666 LA     school 2200030 001   Acadia Parish 220003000002 1002 Branch Elementary School   Regular School No Elementary PK 08 2021 fall pre_kindergarten                                                   19                                             19
2009667 2009667 LA     school 2200030 001   Acadia Parish 220003000003 1003 Central Rayne Kindergarten School   Regular School No Elementary PK KG 2021 fall pre_kindergarten                                                   55                                             55
2009668 2009668 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2021 fall pre_kindergarten                                                   57                                             57
2009669 2009669 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall pre_kindergarten                                                   0                                             0
2009670 2009670 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2021 fall pre_kindergarten                                                   0                                             0
2009671 2009671 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2021 fall pre_kindergarten                                                   0                                             0
2009672 2009672 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2021 fall pre_kindergarten                                                   0                                             0
2009673 2009673 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2021 fall pre_kindergarten                                                   54                                             54
2009674 2009674 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary KG 05 2021 fall pre_kindergarten                                                   0                                             0
2009675 2009675 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2021 fall pre_kindergarten                                                   20                                             20
2009676 2009676 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2021 fall pre_kindergarten                                                   14                                             14
2009677 2009677 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2021 fall pre_kindergarten                                                   13                                             13
2009678 2009678 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2021 fall pre_kindergarten                                                   63                                             63
2009679 2009679 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2021 fall pre_kindergarten                                                   0                                             0
2009680 2009680 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2021 fall pre_kindergarten                                                   13                                             13
2009681 2009681 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2021 fall pre_kindergarten                                                   0                                             0
2009682 2009682 LA     school 2200030 001   Acadia Parish 220003000017 1018 Mire Elementary School   Regular School No Elementary PK 08 2021 fall pre_kindergarten                                                   19                                             19
2009683 2009683 LA     school 2200030 001   Acadia Parish 220003000018 1019 Morse Elementary School   Regular School No Elementary PK 07 2021 fall pre_kindergarten                                                   17                                             17
2009684 2009684 LA     school 2200030 001   Acadia Parish 220003001504 1020 Martin Petitjean Elementary School   Regular School No Elementary 01 03 2021 fall pre_kindergarten                                                   0                                             0
2009685 2009685 LA     school 2200030 001   Acadia Parish 220003000019 1021 Rayne High School   Regular School No High 08 12 2021 fall pre_kindergarten                                                   0                                             0
2009686 2009686 LA     school 2200030 001   Acadia Parish 220003000020 1022 Richard Elementary School   Regular School No Elementary PK 08 2021 fall pre_kindergarten                                                   19                                             19
2009687 2009687 LA     school 2200030 001   Acadia Parish 220003000021 1023 Ross Elementary School   Regular School No Elementary KG 06 2021 fall pre_kindergarten                                                   0                                             0
2009688 2009688 LA     school 2200030 001   Acadia Parish 220003000022 1024 South Crowley Elementary School   Regular School No Elementary KG 05 2021 fall pre_kindergarten                                                   0                                             0
2009689 2009689 LA     school 2200030 001   Acadia Parish 220003000023 1025 South Rayne Elementary School   Regular School No Middle 04 06 2021 fall pre_kindergarten                                                   0                                             0
2009693 2009693 LA     school 2200030 001   Acadia Parish 220003000014 1034 Iota High School   Regular School No High 05 12 2021 fall pre_kindergarten                                                   0                                             0
2009695 2009695 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall pre_kindergarten                                                   0                                             0
2011064 2011064 LA     school 2200030 001   Acadia Parish 220003000001 1001 Armstrong Middle School   Regular School No Middle 06 08 2020 fall grade_1                                                   0                                             0
2011065 2011065 LA     school 2200030 001   Acadia Parish 220003000002 1002 Branch Elementary School   Regular School No Elementary PK 08 2020 fall grade_1                                                   35                                             35
2011066 2011066 LA     school 2200030 001   Acadia Parish 220003000003 1003 Central Rayne Kindergarten School   Regular School No Elementary PK KG 2020 fall grade_1                                                   0                                             0
2011067 2011067 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2020 fall grade_1                                                   94                                             94
2011068 2011068 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall grade_1                                                   0                                             0
2011069 2011069 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2020 fall grade_1                                                   0                                             0
2011070 2011070 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2020 fall grade_1                                                   0                                             0
2011071 2011071 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2020 fall grade_1                                                   0                                             0
2011072 2011072 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2020 fall grade_1                                                   0                                             0
2011073 2011073 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary PK 05 2020 fall grade_1                                                   56                                             56
2011074 2011074 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2020 fall grade_1                                                   27                                             27
2011075 2011075 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2020 fall grade_1                                                   27                                             27
2011076 2011076 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2020 fall grade_1                                                   14                                             14
2011077 2011077 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2020 fall grade_1                                                   90                                             90
2011078 2011078 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2020 fall grade_1                                                   0                                             0
2011079 2011079 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2020 fall grade_1                                                   19                                             19
2011080 2011080 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2020 fall grade_1                                                   0                                             0
2011081 2011081 LA     school 2200030 001   Acadia Parish 220003000017 1018 Mire Elementary School   Regular School No Elementary PK 08 2020 fall grade_1                                                   71                                             71
2011082 2011082 LA     school 2200030 001   Acadia Parish 220003000018 1019 Morse Elementary School   Regular School No Elementary PK 07 2020 fall grade_1                                                   28                                             28
2011083 2011083 LA     school 2200030 001   Acadia Parish 220003001504 1020 Martin Petitjean Elementary School   Regular School No Elementary 01 03 2020 fall grade_1                                                   122                                             122
2011084 2011084 LA     school 2200030 001   Acadia Parish 220003000019 1021 Rayne High School   Regular School No High 08 12 2020 fall grade_1                                                   0                                             0
2011085 2011085 LA     school 2200030 001   Acadia Parish 220003000020 1022 Richard Elementary School   Regular School No Elementary PK 08 2020 fall grade_1                                                   53                                             53
2011086 2011086 LA     school 2200030 001   Acadia Parish 220003000021 1023 Ross Elementary School   Regular School No Elementary PK 06 2020 fall grade_1                                                   61                                             61
2011087 2011087 LA     school 2200030 001   Acadia Parish 220003000022 1024 South Crowley Elementary School   Regular School No Elementary PK 05 2020 fall grade_1                                                   71                                             71
2011088 2011088 LA     school 2200030 001   Acadia Parish 220003000023 1025 South Rayne Elementary School   Regular School No Middle 04 06 2020 fall grade_1                                                   0                                             0
2011092 2011092 LA     school 2200030 001   Acadia Parish 220003000014 1034 Iota High School   Regular School No High 05 12 2020 fall grade_1                                                   0                                             0
2011094 2011094 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2020 fall grade_1                                                   0                                             0
2012465 2012465 LA     school 2200030 001   Acadia Parish 220003000001 1001 Armstrong Middle School   Regular School No Middle 06 08 2020 fall grade_10                                                   0                                             0
2012466 2012466 LA     school 2200030 001   Acadia Parish 220003000002 1002 Branch Elementary School   Regular School No Elementary PK 08 2020 fall grade_10                                                   0                                             0
2012467 2012467 LA     school 2200030 001   Acadia Parish 220003000003 1003 Central Rayne Kindergarten School   Regular School No Elementary PK KG 2020 fall grade_10                                                   0                                             0
2012468 2012468 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2020 fall grade_10                                                   0                                             0
2012469 2012469 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall grade_10                                                   123                                             123
2012470 2012470 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2020 fall grade_10                                                   0                                             0
2012471 2012471 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2020 fall grade_10                                                   153                                             153
2012472 2012472 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2020 fall grade_10                                                   0                                             0
2012473 2012473 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2020 fall grade_10                                                   0                                             0
2012474 2012474 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary PK 05 2020 fall grade_10                                                   0                                             0
2012475 2012475 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2020 fall grade_10                                                   0                                             0
2012476 2012476 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2020 fall grade_10                                                   0                                             0
2012477 2012477 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2020 fall grade_10                                                   0                                             0
2012478 2012478 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2020 fall grade_10                                                   0                                             0
2012479 2012479 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2020 fall grade_10                                                   0                                             0
2012480 2012480 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2020 fall grade_10                                                   0                                             0
2012481 2012481 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2020 fall grade_10                                                   58                                             58
2012482 2012482 LA     school 2200030 001   Acadia Parish 220003000017 1018 Mire Elementary School   Regular School No Elementary PK 08 2020 fall grade_10                                                   0                                             0
2012483 2012483 LA     school 2200030 001   Acadia Parish 220003000018 1019 Morse Elementary School   Regular School No Elementary PK 07 2020 fall grade_10                                                   0                                             0
2012484 2012484 LA     school 2200030 001   Acadia Parish 220003001504 1020 Martin Petitjean Elementary School   Regular School No Elementary 01 03 2020 fall grade_10                                                   0                                             0
2012485 2012485 LA     school 2200030 001   Acadia Parish 220003000019 1021 Rayne High School   Regular School No High 08 12 2020 fall grade_10                                                   178                                             178
2012486 2012486 LA     school 2200030 001   Acadia Parish 220003000020 1022 Richard Elementary School   Regular School No Elementary PK 08 2020 fall grade_10                                                   0                                             0
2012487 2012487 LA     school 2200030 001   Acadia Parish 220003000021 1023 Ross Elementary School   Regular School No Elementary PK 06 2020 fall grade_10                                                   0                                             0
2012488 2012488 LA     school 2200030 001   Acadia Parish 220003000022 1024 South Crowley Elementary School   Regular School No Elementary PK 05 2020 fall grade_10                                                   0                                             0
2012489 2012489 LA     school 2200030 001   Acadia Parish 220003000023 1025 South Rayne Elementary School   Regular School No Middle 04 06 2020 fall grade_10                                                   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]);