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
2005474 2005474 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2021 fall grade_9_transitional                                                   6                                             6
2005475 2005475 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2021 fall grade_9_transitional                                                   0                                             0
2005476 2005476 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2021 fall grade_9_transitional                                                   0                                             0
2005477 2005477 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary KG 05 2021 fall grade_9_transitional                                                   0                                             0
2005478 2005478 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2021 fall grade_9_transitional                                                   0                                             0
2005479 2005479 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2021 fall grade_9_transitional                                                   0                                             0
2005480 2005480 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2021 fall grade_9_transitional                                                   0                                             0
2005481 2005481 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2021 fall grade_9_transitional                                                   0                                             0
2005482 2005482 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2021 fall grade_9_transitional                                                   0                                             0
2005483 2005483 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2021 fall grade_9_transitional                                                   0                                             0
2005484 2005484 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2021 fall grade_9_transitional                                                   4                                             4
2005485 2005485 LA     school 2200030 001   Acadia Parish 220003000017 1018 Mire Elementary School   Regular School No Elementary PK 08 2021 fall grade_9_transitional                                                   0                                             0
2005486 2005486 LA     school 2200030 001   Acadia Parish 220003000018 1019 Morse Elementary School   Regular School No Elementary PK 07 2021 fall grade_9_transitional                                                   0                                             0
2005487 2005487 LA     school 2200030 001   Acadia Parish 220003001504 1020 Martin Petitjean Elementary School   Regular School No Elementary 01 03 2021 fall grade_9_transitional                                                   0                                             0
2005488 2005488 LA     school 2200030 001   Acadia Parish 220003000019 1021 Rayne High School   Regular School No High 08 12 2021 fall grade_9_transitional                                                   0                                             0
2005489 2005489 LA     school 2200030 001   Acadia Parish 220003000020 1022 Richard Elementary School   Regular School No Elementary PK 08 2021 fall grade_9_transitional                                                   0                                             0
2005490 2005490 LA     school 2200030 001   Acadia Parish 220003000021 1023 Ross Elementary School   Regular School No Elementary KG 06 2021 fall grade_9_transitional                                                   0                                             0
2005491 2005491 LA     school 2200030 001   Acadia Parish 220003000022 1024 South Crowley Elementary School   Regular School No Elementary KG 05 2021 fall grade_9_transitional                                                   0                                             0
2005492 2005492 LA     school 2200030 001   Acadia Parish 220003000023 1025 South Rayne Elementary School   Regular School No Middle 04 06 2021 fall grade_9_transitional                                                   0                                             0
2005496 2005496 LA     school 2200030 001   Acadia Parish 220003000014 1034 Iota High School   Regular School No High 05 12 2021 fall grade_9_transitional                                                   8                                             8
2005498 2005498 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall grade_9_transitional                                                   0                                             0
2006867 2006867 LA     school 2200030 001   Acadia Parish 220003000001 1001 Armstrong Middle School   Regular School No Middle 06 08 2021 fall kindergarten                                                   0                                             0
2006868 2006868 LA     school 2200030 001   Acadia Parish 220003000002 1002 Branch Elementary School   Regular School No Elementary PK 08 2021 fall kindergarten                                                   34                                             34
2006869 2006869 LA     school 2200030 001   Acadia Parish 220003000003 1003 Central Rayne Kindergarten School   Regular School No Elementary PK KG 2021 fall kindergarten                                                   134                                             134
2006870 2006870 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2021 fall kindergarten                                                   91                                             91
2006871 2006871 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall kindergarten                                                   0                                             0
2006872 2006872 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2021 fall kindergarten                                                   0                                             0
2006873 2006873 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2021 fall kindergarten                                                   0                                             0
2006874 2006874 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2021 fall kindergarten                                                   0                                             0
2006875 2006875 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2021 fall kindergarten                                                   204                                             204
2006876 2006876 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary KG 05 2021 fall kindergarten                                                   0                                             0
2006877 2006877 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2021 fall kindergarten                                                   29                                             29
2006878 2006878 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2021 fall kindergarten                                                   25                                             25
2006879 2006879 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2021 fall kindergarten                                                   17                                             17
2006880 2006880 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2021 fall kindergarten                                                   99                                             99
2006881 2006881 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2021 fall kindergarten                                                   0                                             0
2006882 2006882 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2021 fall kindergarten                                                   20                                             20
2006883 2006883 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2021 fall kindergarten                                                   0                                             0
2006884 2006884 LA     school 2200030 001   Acadia Parish 220003000017 1018 Mire Elementary School   Regular School No Elementary PK 08 2021 fall kindergarten                                                   68                                             68
2006885 2006885 LA     school 2200030 001   Acadia Parish 220003000018 1019 Morse Elementary School   Regular School No Elementary PK 07 2021 fall kindergarten                                                   30                                             30
2006886 2006886 LA     school 2200030 001   Acadia Parish 220003001504 1020 Martin Petitjean Elementary School   Regular School No Elementary 01 03 2021 fall kindergarten                                                   0                                             0
2006887 2006887 LA     school 2200030 001   Acadia Parish 220003000019 1021 Rayne High School   Regular School No High 08 12 2021 fall kindergarten                                                   0                                             0
2006888 2006888 LA     school 2200030 001   Acadia Parish 220003000020 1022 Richard Elementary School   Regular School No Elementary PK 08 2021 fall kindergarten                                                   61                                             61
2006889 2006889 LA     school 2200030 001   Acadia Parish 220003000021 1023 Ross Elementary School   Regular School No Elementary KG 06 2021 fall kindergarten                                                   0                                             0
2006890 2006890 LA     school 2200030 001   Acadia Parish 220003000022 1024 South Crowley Elementary School   Regular School No Elementary KG 05 2021 fall kindergarten                                                   0                                             0
2006891 2006891 LA     school 2200030 001   Acadia Parish 220003000023 1025 South Rayne Elementary School   Regular School No Middle 04 06 2021 fall kindergarten                                                   0                                             0
2006895 2006895 LA     school 2200030 001   Acadia Parish 220003000014 1034 Iota High School   Regular School No High 05 12 2021 fall kindergarten                                                   0                                             0
2006897 2006897 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall kindergarten                                                   0                                             0
2008266 2008266 LA     school 2200030 001   Acadia Parish 220003000001 1001 Armstrong Middle School   Regular School No Middle 06 08 2021 fall pk_12_total 153.0 150.0 10.0 1.0   0.0     0.0   28.0   168.0 174.0     3.0       300.0         342 153 150 10 1   0     0   28   168 174     3   300       342
2008267 2008267 LA     school 2200030 001   Acadia Parish 220003000002 1002 Branch Elementary School   Regular School No Elementary PK 08 2021 fall pk_12_total 292.0 25.0 14.0 0.0   1.0     0.0   9.0   176.0 165.0     2.0       199.0         341 292 25 14 0   1     0   9   176 165     2   199       341
2008268 2008268 LA     school 2200030 001   Acadia Parish 220003000003 1003 Central Rayne Kindergarten School   Regular School No Elementary PK KG 2021 fall pk_12_total 102.0 78.0 6.0 2.0   1.0     0.0   6.0   103.0 92.0     1.0       160.0         195 102 78 6 2   1     0   6   103 92     1   160       195
2008269 2008269 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2021 fall pk_12_total 242.0 247.0 48.0 3.0   0.0     0.0   40.0   307.0 273.0     9.0       524.0         580 242 247 48 3   0     0   40   307 273     9   524       580
2008270 2008270 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall pk_12_total 320.0 152.0 22.0 0.0   0.0     0.0   30.0   263.0 261.0     1.0       372.0         524 320 152 22 0   0     0   30   263 261     1   372       524
2008271 2008271 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2021 fall pk_12_total 115.0 102.0 22.0 1.0   0.0     0.0   19.0   148.0 111.0     3.0       229.0         259 115 102 22 1   0     0   19   148 111     3   229       259
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

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