enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2029281 2029281 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall kindergarten                                                   0                                             0
2029282 2029282 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2020 fall kindergarten                                                   0                                             0
2029283 2029283 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2020 fall kindergarten                                                   0                                             0
2029284 2029284 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2020 fall kindergarten                                                   0                                             0
2029285 2029285 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2020 fall kindergarten                                                   190                                             190
2029286 2029286 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary PK 05 2020 fall kindergarten                                                   0                                             0
2029287 2029287 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2020 fall kindergarten                                                   31                                             31
2029288 2029288 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2020 fall kindergarten                                                   22                                             22
2029289 2029289 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2020 fall kindergarten                                                   21                                             21
2029290 2029290 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2020 fall kindergarten                                                   98                                             98
2029291 2029291 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2020 fall kindergarten                                                   0                                             0
2029292 2029292 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2020 fall kindergarten                                                   20                                             20
2029293 2029293 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2020 fall kindergarten                                                   0                                             0
2029294 2029294 LA     school 2200030 001   Acadia Parish 220003000017 1018 Mire Elementary School   Regular School No Elementary PK 08 2020 fall kindergarten                                                   60                                             60
2029295 2029295 LA     school 2200030 001   Acadia Parish 220003000018 1019 Morse Elementary School   Regular School No Elementary PK 07 2020 fall kindergarten                                                   29                                             29
2029296 2029296 LA     school 2200030 001   Acadia Parish 220003001504 1020 Martin Petitjean Elementary School   Regular School No Elementary 01 03 2020 fall kindergarten                                                   0                                             0
2029297 2029297 LA     school 2200030 001   Acadia Parish 220003000019 1021 Rayne High School   Regular School No High 08 12 2020 fall kindergarten                                                   0                                             0
2029298 2029298 LA     school 2200030 001   Acadia Parish 220003000020 1022 Richard Elementary School   Regular School No Elementary PK 08 2020 fall kindergarten                                                   74                                             74
2029299 2029299 LA     school 2200030 001   Acadia Parish 220003000021 1023 Ross Elementary School   Regular School No Elementary PK 06 2020 fall kindergarten                                                   0                                             0
2029300 2029300 LA     school 2200030 001   Acadia Parish 220003000022 1024 South Crowley Elementary School   Regular School No Elementary PK 05 2020 fall kindergarten                                                   0                                             0
2029301 2029301 LA     school 2200030 001   Acadia Parish 220003000023 1025 South Rayne Elementary School   Regular School No Middle 04 06 2020 fall kindergarten                                                   0                                             0
2029302 2029302 LA     school   001   Acadia Parish   1030 Church Point Head Start Center             2020 fall kindergarten                                                   0                                             0
2029303 2029303 LA     school   001   Acadia Parish   1031 Rayne Head Start Center             2020 fall kindergarten                                                   0                                             0
2029304 2029304 LA     school   001   Acadia Parish   1032 Ross Head Start Center             2020 fall kindergarten                                                   0                                             0
2029305 2029305 LA     school 2200030 001   Acadia Parish 220003000014 1034 Iota High School   Regular School No High 05 12 2020 fall kindergarten                                                   0                                             0
2029306 2029306 LA     school   001   Acadia Parish   1035 Estherwood Head Start Center             2020 fall kindergarten                                                   0                                             0
2029307 2029307 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2020 fall kindergarten                                                   0                                             0
2029308 2029308 LA     school   001   Acadia Parish   1700 Acadia Parish Central Office             2020 fall kindergarten                                                   0                                             0
2030678 2030678 LA     school 2200030 001   Acadia Parish 220003000001 1001 Armstrong Middle School   Regular School No Middle 06 08 2020 fall pk_12_total 146.0 139.0 11.0 0.0   0.0     0.0   23.0   167.0 152.0     2.0       258.0         319 146 139 11 0   0     0   23   167 152     2   258       319
2030679 2030679 LA     school 2200030 001   Acadia Parish 220003000002 1002 Branch Elementary School   Regular School No Elementary PK 08 2020 fall pk_12_total 275.0 22.0 11.0 0.0   1.0     0.0   9.0   155.0 163.0     4.0       174.0         318 275 22 11 0   1     0   9   155 163     4   174       318
2030680 2030680 LA     school 2200030 001   Acadia Parish 220003000003 1003 Central Rayne Kindergarten School   Regular School No Elementary PK KG 2020 fall pk_12_total 111.0 83.0 9.0 0.0   1.0     0.0   18.0   128.0 94.0     0.0       175.0         222 111 83 9 0   1     0   18   128 94     0   175       222
2030681 2030681 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2020 fall pk_12_total 251.0 235.0 40.0 3.0   0.0     0.0   46.0   307.0 268.0     3.0000000000000004       504.0         575 251 235 40 3   0     0   46   307 268         504       575
2030682 2030682 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall pk_12_total 342.0 143.0 18.0 0.0   1.0     0.0   29.0   276.0 257.0     2.0       336.0         533 342 143 18 0   1     0   29   276 257     2   336       533
2030683 2030683 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2020 fall pk_12_total 108.0 122.0 19.0 1.0   0.0     0.0   19.0   126.0 143.0     2.0       222.0         269 108 122 19 1   0     0   19   126 143     2   222       269
2030684 2030684 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2020 fall pk_12_total 281.0 267.0 24.0 1.0   1.0     0.0   32.0   300.0 306.0     9.999999999999998       481.0         606 281 267 24 1   1     0   32   300 306         481       606
2030685 2030685 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2020 fall pk_12_total 194.0 245.0 26.0 0.0   3.0     0.0   22.0   251.00000000000003 239.0     11.0       422.0         490 194 245 26 0   3     0   22     239     11   422       490
2030686 2030686 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2020 fall pk_12_total 114.0 112.0 13.0 0.0   0.0     0.0   11.0   121.0 129.0     6.0       233.0         250 114 112 13 0   0     0   11   121 129     6   233       250
2030687 2030687 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary PK 05 2020 fall pk_12_total 118.0 136.0 24.0 0.0   0.0     0.0   14.0   147.0 145.0     6.0       258.0         292 118 136 24 0   0     0   14   147 145     6   258       292
2030688 2030688 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2020 fall pk_12_total 234.0 3.0 3.0 0.0   0.0     0.0   2.0   124.0 118.0     1.0       119.0         242 234 3 3 0   0     0   2   124 118     1   119       242
2030689 2030689 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2020 fall pk_12_total 208.0 11.0 6.0 0.0   0.0     0.0   5.0   113.0 117.0     2.0       169.0         230 208 11 6 0   0     0   5   113 117     2   169       230
2030690 2030690 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2020 fall pk_12_total 188.0 5.0 9.0 2.0   0.0     0.0   9.0   107.0 106.0     0.0       125.0         213 188 5 9 2   0     0   9   107 106     0   125       213
2030691 2030691 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2020 fall pk_12_total 562.0 17.0 21.0 0.0   2.0     0.0   29.0   316.0 315.0     3.0       327.0         631 562 17 21 0   2     0   29   316 315     3   327       631
2030692 2030692 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2020 fall pk_12_total 277.0 7.0 11.0 0.0   0.0     0.0   12.0   161.0 146.0     2.0       166.0         307 277 7 11 0   0     0   12   161 146     2   166       307
2030693 2030693 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2020 fall pk_12_total 133.0 19.0 2.0 0.0   0.0     0.0   5.0   77.0 82.0     0.0       87.0         159 133 19 2 0   0     0   5   77 82     0   87       159
2030694 2030694 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2020 fall pk_12_total 260.0 10.0 3.0 0.0   0.0     0.0   12.0   130.0 155.0     0.0       172.0         285 260 10 3 0   0     0   12   130 155     0   172       285
2030695 2030695 LA     school 2200030 001   Acadia Parish 220003000017 1018 Mire Elementary School   Regular School No Elementary PK 08 2020 fall pk_12_total 536.0 37.0 26.0 1.0   0.0     0.0   23.0   301.0 322.0     3.0       333.0         623 536 37 26 1   0     0   23   301 322     3   333       623
2030696 2030696 LA     school 2200030 001   Acadia Parish 220003000018 1019 Morse Elementary School   Regular School No Elementary PK 07 2020 fall pk_12_total 195.0 3.0 1.0 0.0   0.0     0.0   6.0   109.0 96.0     0.0       135.0         205 195 3 1 0   0     0   6   109 96     0   135       205
2030697 2030697 LA     school 2200030 001   Acadia Parish 220003001504 1020 Martin Petitjean Elementary School   Regular School No Elementary 01 03 2020 fall pk_12_total 154.0 141.0 12.0 1.0   0.0     0.0   28.0   163.0 172.99999999999997     0.0       288.0         336 154 141 12 1   0     0   28   163       0   288       336
2030698 2030698 LA     school 2200030 001   Acadia Parish 220003000019 1021 Rayne High School   Regular School No High 08 12 2020 fall pk_12_total 433.0 199.0 18.0 0.0   2.0     0.0   24.0   360.00000000000006 316.0     4.0       438.0         676 433 199 18 0   2     0   24     316     4   438       676
2030699 2030699 LA     school 2200030 001   Acadia Parish 220003000020 1022 Richard Elementary School   Regular School No Elementary PK 08 2020 fall pk_12_total 419.0 22.0 20.0 0.0   1.0     0.0   21.0   232.0 251.0     4.0       263.0         483 419 22 20 0   1     0   21   232 251     4   263       483
2030700 2030700 LA     school 2200030 001   Acadia Parish 220003000021 1023 Ross Elementary School   Regular School No Elementary PK 06 2020 fall pk_12_total 105.0 165.0 7.0 2.0   1.0     0.0   22.0   145.0 157.0     3.0       282.0         302 105 165 7 2   1     0   22   145 157     3   282       302
2030701 2030701 LA     school 2200030 001   Acadia Parish 220003000022 1024 South Crowley Elementary School   Regular School No Elementary PK 05 2020 fall pk_12_total 159.0 79.0 26.0 0.0   0.0     0.0   28.0   146.0 146.0     10.0       261.0         292 159 79 26 0   0     0   28   146 146     10   261       292
2030702 2030702 LA     school 2200030 001   Acadia Parish 220003000023 1025 South Rayne Elementary School   Regular School No Middle 04 06 2020 fall pk_12_total 131.0 138.0 8.0 1.0   1.0     0.0   26.0   165.0 140.0     1.0       267.0         305 131 138 8 1   1     0   26   165 140     1   267       305
2030703 2030703 LA     school   001   Acadia Parish   1030 Church Point Head Start Center             2020 fall pk_12_total 1.0 3.0 0.0 0.0   0.0     0.0   2.0   6.0 0.0     0.0       6.0         6 1 3 0 0   0     0   2   6 0     0   6       6
2030704 2030704 LA     school   001   Acadia Parish   1031 Rayne Head Start Center             2020 fall pk_12_total 3.0 5.0 0.0 0.0   0.0     0.0   0.0   8.0 0.0     0.0       7.0         8 3 5 0 0   0     0   0   8 0     0   7       8
2030705 2030705 LA     school   001   Acadia Parish   1032 Ross Head Start Center             2020 fall pk_12_total 5.0 8.0 0.0 0.0   0.0     0.0   0.0   8.0 5.0     0.0       13.0         13 5 8 0 0   0     0   0   8 5     0   13       13
2030706 2030706 LA     school 2200030 001   Acadia Parish 220003000014 1034 Iota High School   Regular School No High 05 12 2020 fall pk_12_total 538.0 9.0 13.0 2.0   2.0     0.0   17.0   315.0 266.0     3.0000000000000004       234.0         581 538 9 13 2   2     0   17   315 266         234       581
2030707 2030707 LA     school   001   Acadia Parish   1035 Estherwood Head Start Center             2020 fall pk_12_total 3.0 0.0 0.0 0.0   0.0     0.0   0.0   3.0 0.0     0.0       1.0         3 3 0 0 0   0     0   0   3 0     0   1       3
2030708 2030708 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2020 fall pk_12_total 6.0 29.0 0.0 0.0   0.0     0.0   1.0   36.0 0.0     0.0       35.0         36 6 29 0 0   0     0   1   36 0     0   35       36
2030709 2030709 LA     school   001   Acadia Parish   1700 Acadia Parish Central Office             2020 fall pk_12_total 22.0 10.0 1.0 0.0   0.0     0.0   1.0   15.0 19.0     0.0       26.0         34 22 10 1 0   0     0   1   15 19     0   26       34
2032079 2032079 LA     school 2200030 001   Acadia Parish 220003000001 1001 Armstrong Middle School   Regular School No Middle 06 08 2020 fall pre_kindergarten                                                   0                                             0
2032080 2032080 LA     school 2200030 001   Acadia Parish 220003000002 1002 Branch Elementary School   Regular School No Elementary PK 08 2020 fall pre_kindergarten                                                   19                                             19
2032081 2032081 LA     school 2200030 001   Acadia Parish 220003000003 1003 Central Rayne Kindergarten School   Regular School No Elementary PK KG 2020 fall pre_kindergarten                                                   72                                             72
2032082 2032082 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2020 fall pre_kindergarten                                                   58                                             58
2032083 2032083 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall pre_kindergarten                                                   0                                             0
2032084 2032084 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2020 fall pre_kindergarten                                                   0                                             0
2032085 2032085 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2020 fall pre_kindergarten                                                   0                                             0
2032086 2032086 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2020 fall pre_kindergarten                                                   0                                             0
2032087 2032087 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2020 fall pre_kindergarten                                                   55                                             55
2032088 2032088 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary PK 05 2020 fall pre_kindergarten                                                   0                                             0
2032089 2032089 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2020 fall pre_kindergarten                                                   20                                             20
2032090 2032090 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2020 fall pre_kindergarten                                                   16                                             16
2032091 2032091 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2020 fall pre_kindergarten                                                   18                                             18
2032092 2032092 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2020 fall pre_kindergarten                                                   68                                             68
2032093 2032093 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2020 fall pre_kindergarten                                                   0                                             0
2032094 2032094 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2020 fall pre_kindergarten                                                   17                                             17
2032095 2032095 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2020 fall pre_kindergarten                                                   0                                             0
2032096 2032096 LA     school 2200030 001   Acadia Parish 220003000017 1018 Mire Elementary School   Regular School No Elementary PK 08 2020 fall pre_kindergarten                                                   18                                             18
2032097 2032097 LA     school 2200030 001   Acadia Parish 220003000018 1019 Morse Elementary School   Regular School No Elementary PK 07 2020 fall pre_kindergarten                                                   15                                             15
2032098 2032098 LA     school 2200030 001   Acadia Parish 220003001504 1020 Martin Petitjean Elementary School   Regular School No Elementary 01 03 2020 fall pre_kindergarten                                                   0                                             0
2032099 2032099 LA     school 2200030 001   Acadia Parish 220003000019 1021 Rayne High School   Regular School No High 08 12 2020 fall pre_kindergarten                                                   0                                             0
2032100 2032100 LA     school 2200030 001   Acadia Parish 220003000020 1022 Richard Elementary School   Regular School No Elementary PK 08 2020 fall pre_kindergarten                                                   20                                             20
2032101 2032101 LA     school 2200030 001   Acadia Parish 220003000021 1023 Ross Elementary School   Regular School No Elementary PK 06 2020 fall pre_kindergarten                                                   0                                             0
2032102 2032102 LA     school 2200030 001   Acadia Parish 220003000022 1024 South Crowley Elementary School   Regular School No Elementary PK 05 2020 fall pre_kindergarten                                                   0                                             0
2032103 2032103 LA     school 2200030 001   Acadia Parish 220003000023 1025 South Rayne Elementary School   Regular School No Middle 04 06 2020 fall pre_kindergarten                                                   0                                             0
2032104 2032104 LA     school   001   Acadia Parish   1030 Church Point Head Start Center             2020 fall pre_kindergarten                                                   0                                             0
2032105 2032105 LA     school   001   Acadia Parish   1031 Rayne Head Start Center             2020 fall pre_kindergarten                                                   0                                             0
2032106 2032106 LA     school   001   Acadia Parish   1032 Ross Head Start Center             2020 fall pre_kindergarten                                                   0                                             0
2032107 2032107 LA     school 2200030 001   Acadia Parish 220003000014 1034 Iota High School   Regular School No High 05 12 2020 fall pre_kindergarten                                                   0                                             0
2032108 2032108 LA     school   001   Acadia Parish   1035 Estherwood Head Start Center             2020 fall pre_kindergarten                                                   0                                             0
2032109 2032109 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2020 fall pre_kindergarten                                                   0                                             0
2032110 2032110 LA     school   001   Acadia Parish   1700 Acadia Parish Central Office             2020 fall pre_kindergarten                                                   0                                             0
2283669 2283669 LA     school 2200030 001   Acadia Parish 220003000001 1001 Armstrong Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2283670 2283670 LA     school 2200030 001   Acadia Parish 220003000002 1002 Branch Elementary School   Regular School No Elementary PK 08 2019 spring grade_1                                                   28                                             28
2283671 2283671 LA     school 2200030 001   Acadia Parish 220003000003 1003 Central Rayne Kindergarten School   Regular School No Elementary PK KG 2019 spring grade_1                                                   0                                             0
2283672 2283672 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   79                                             79
2283673 2283673 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2019 spring grade_1                                                   0                                             0
2283674 2283674 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2283675 2283675 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2019 spring grade_1                                                   0                                             0
2283676 2283676 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   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]);