enrollments

Data source: Big Local News · About: Big Local

103,197 rows where state = "WI" sorted by ccd_charter_school descending

✎ 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
111730 111730 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   pk_12_total 87.0 224.0 107.0     1.0         27.0   222.0 224.0             272     56   446 87 224 107     1         27   222 224         272   56   446
111731 111731 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   grade_1                                                   56                                             56
111732 111732 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   grade_2                                                   54                                             54
111733 111733 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   grade_3                                                   46                                             46
111734 111734 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   grade_4                                                   42                                             42
111735 111735 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   grade_5                                                   52                                             52
111736 111736 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   grade_6                                                   35                                             35
111737 111737 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   grade_7                                                   32                                             32
111738 111738 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   grade_8                                                   40                                             40
111739 111739 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   33                                             33
111740 111740 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   kindergarten                                                   56                                             56
111792 111792 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2015   pk_12_total 99.0 1.0 4.0               1.0   45.0 60.0             32     14   105 99 1 4               1   45 60         32   14   105
111793 111793 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2015   grade_5                                                   27                                             27
111794 111794 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2015   grade_6                                                   28                                             28
111795 111795 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2015   grade_7                                                   23                                             23
111796 111796 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2015   grade_8                                                   27                                             27
111982 111982 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes 1.0 KG 04 2015   pk_12_total 40.0 1.0 73.0     2.0         3.0   54.0 65.0             53     8   119 40 1 73     2         3   54 65         53   8   119
111983 111983 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes 1.0 KG 04 2015   grade_1                                                   28                                             28
111984 111984 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes 1.0 KG 04 2015   grade_2                                                   17                                             17
111985 111985 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes 1.0 KG 04 2015   grade_3                                                   26                                             26
111986 111986 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes 1.0 KG 04 2015   grade_4                                                   21                                             21
111987 111987 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes 1.0 KG 04 2015   kindergarten                                                   27                                             27
111988 111988 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Appleton Career Academy charter Regular School Yes 3.0 09 12 2015   pk_12_total 92.0 1.0 4.0     5.0         2.0   42.0 62.0             29     10   104 92 1 4     5         2   42 62         29   10   104
111989 111989 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Appleton Career Academy charter Regular School Yes 3.0 09 12 2015   grade_10                                                   24                                             24
111990 111990 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Appleton Career Academy charter Regular School Yes 3.0 09 12 2015   grade_11                                                   25                                             25
111991 111991 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Appleton Career Academy charter Regular School Yes 3.0 09 12 2015   grade_12                                                   31                                             31
111992 111992 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Appleton Career Academy charter Regular School Yes 3.0 09 12 2015   grade_9                                                   24                                             24
111993 111993 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000692 400 Appleton Central High charter Regular School Yes 4.0 06 12 2015   pk_12_total 67.0 13.0 20.0 2.0   1.0             60.0 43.0             74     1   103 67 13 20 2   1             60 43         74   1   103
111994 111994 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000692 400 Appleton Central High charter Regular School Yes 4.0 06 12 2015   grade_10                                                   2                                             2
111995 111995 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000692 400 Appleton Central High charter Regular School Yes 4.0 06 12 2015   grade_11                                                   25                                             25
111996 111996 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000692 400 Appleton Central High charter Regular School Yes 4.0 06 12 2015   grade_12                                                   75                                             75
111997 111997 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000692 400 Appleton Central High charter Regular School Yes 4.0 06 12 2015   grade_8                                                   1                                             1
112000 112000 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes 3.0 07 12 2015   pk_12_total 24.0 1.0 2.0                   5.0 22.0             6         27 24 1 2                   5 22         6       27
112001 112001 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes 3.0 07 12 2015   grade_10                                                   7                                             7
112002 112002 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes 3.0 07 12 2015   grade_11                                                   8                                             8
112003 112003 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes 3.0 07 12 2015   grade_12                                                   9                                             9
112004 112004 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes 3.0 07 12 2015   grade_7                                                   1                                             1
112005 112005 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes 3.0 07 12 2015   grade_9                                                   2                                             2
112006 112006 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   pk_12_total 153.0 1.0 2.0     1.0             76.0 81.0             25     4   157 153 1 2     1             76 81         25   4   157
112007 112007 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   grade_1                                                   20                                             20
112008 112008 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   grade_2                                                   20                                             20
112009 112009 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   grade_3                                                   20                                             20
112010 112010 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   grade_4                                                   19                                             19
112011 112011 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   grade_5                                                   22                                             22
112012 112012 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   grade_6                                                   16                                             16
112013 112013 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   kindergarten_4_year_old                                                   20                                             20
112014 112014 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   kindergarten                                                   20                                             20
112015 112015 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2015   pk_12_total 39.0   17.0                   53.0 3.0             27     16   56 39   17                   53 3         27   16   56
112016 112016 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2015   grade_10                                                   14                                             14
112017 112017 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2015   grade_11                                                   17                                             17
112018 112018 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2015   grade_12                                                   17                                             17
112019 112019 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2015   grade_9                                                   8                                             8
112037 112037 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes 1.0 KG 08 2015   pk_12_total 354.0 16.0 22.0 1.0   85.0             225.0 253.0             76     11   478 354 16 22 1   85             225 253         76   11   478
112038 112038 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes 1.0 KG 08 2015   grade_1                                                   52                                             52
112039 112039 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes 1.0 KG 08 2015   grade_2                                                   52                                             52
112040 112040 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes 1.0 KG 08 2015   grade_3                                                   52                                             52
112041 112041 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes 1.0 KG 08 2015   grade_4                                                   54                                             54
112042 112042 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes 1.0 KG 08 2015   grade_5                                                   54                                             54
112043 112043 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes 1.0 KG 08 2015   grade_6                                                   54                                             54
112044 112044 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes 1.0 KG 08 2015   grade_7                                                   53                                             53
112045 112045 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes 1.0 KG 08 2015   grade_8                                                   55                                             55
112046 112046 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes 1.0 KG 08 2015   kindergarten                                                   52                                             52
112081 112081 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   pk_12_total 93.0 3.0 1.0 1.0   2.0             52.0 48.0             34     6   100 93 3 1 1   2             52 48         34   6   100
112082 112082 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   grade_1                                                   10                                             10
112083 112083 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   grade_2                                                   9                                             9
112084 112084 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   grade_3                                                   14                                             14
112085 112085 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   grade_4                                                   12                                             12
112086 112086 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   grade_5                                                   23                                             23
112087 112087 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   grade_6                                                   10                                             10
112088 112088 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   grade_7                                                   13                                             13
112089 112089 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   grade_8                                                   9                                             9
112150 112150 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002759 250 Kaleidoscope Academy charter Regular School Yes 2.0 06 08 2015   pk_12_total 302.0 17.0 12.0 1.0   12.0             155.0 189.0             94     21   344 302 17 12 1   12             155 189         94   21   344
112151 112151 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002759 250 Kaleidoscope Academy charter Regular School Yes 2.0 06 08 2015   grade_6                                                   115                                             115
112152 112152 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002759 250 Kaleidoscope Academy charter Regular School Yes 2.0 06 08 2015   grade_7                                                   114                                             114
112153 112153 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002759 250 Kaleidoscope Academy charter Regular School Yes 2.0 06 08 2015   grade_8                                                   115                                             115
112180 112180 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002277 210 Odyssey-Magellan charter Regular School Yes 1.0 03 08 2015   pk_12_total 138.0 3.0 4.0 1.0   18.0             108.0 56.0             13     7   164 138 3 4 1   18             108 56         13   7   164
112181 112181 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002277 210 Odyssey-Magellan charter Regular School Yes 1.0 03 08 2015   grade_3                                                   20                                             20
112182 112182 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002277 210 Odyssey-Magellan charter Regular School Yes 1.0 03 08 2015   grade_4                                                   27                                             27
112183 112183 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002277 210 Odyssey-Magellan charter Regular School Yes 1.0 03 08 2015   grade_5                                                   29                                             29
112184 112184 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002277 210 Odyssey-Magellan charter Regular School Yes 1.0 03 08 2015   grade_6                                                   31                                             31
112185 112185 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002277 210 Odyssey-Magellan charter Regular School Yes 1.0 03 08 2015   grade_7                                                   30                                             30
112186 112186 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002277 210 Odyssey-Magellan charter Regular School Yes 1.0 03 08 2015   grade_8                                                   27                                             27
112187 112187 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002282 420 Renaissance School charter Regular School Yes 3.0 09 12 2015   pk_12_total 158.0 8.0 5.0 1.0   29.0       1.0     42.0 160.0             63     12   202 158 8 5 1   29       1     42 160         63   12   202
112188 112188 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002282 420 Renaissance School charter Regular School Yes 3.0 09 12 2015   grade_10                                                   61                                             61
112189 112189 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002282 420 Renaissance School charter Regular School Yes 3.0 09 12 2015   grade_11                                                   51                                             51
112190 112190 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002282 420 Renaissance School charter Regular School Yes 3.0 09 12 2015   grade_12                                                   36                                             36
112191 112191 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002282 420 Renaissance School charter Regular School Yes 3.0 09 12 2015   grade_9                                                   54                                             54
112204 112204 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes 1.0 PK 06 2015   pk_12_total 196.0 16.0 21.0 2.0   80.0         6.0   158.0 163.0             159     49   321 196 16 21 2   80         6   158 163         159   49   321
112205 112205 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes 1.0 PK 06 2015   grade_1                                                   39                                             39
112206 112206 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes 1.0 PK 06 2015   grade_2                                                   52                                             52
112207 112207 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes 1.0 PK 06 2015   grade_3                                                   42                                             42
112208 112208 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes 1.0 PK 06 2015   grade_4                                                   43                                             43
112209 112209 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes 1.0 PK 06 2015   grade_5                                                   45                                             45
112210 112210 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes 1.0 PK 06 2015   grade_6                                                   45                                             45
112211 112211 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes 1.0 PK 06 2015   kindergarten                                                   55                                             55
112212 112212 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002547 430 Tesla Engineering Charter School charter Regular School Yes 3.0 09 12 2015   pk_12_total 105.0   5.0     7.0             98.0 19.0             19     1   117 105   5     7             98 19         19   1   117
112213 112213 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002547 430 Tesla Engineering Charter School charter Regular School Yes 3.0 09 12 2015   grade_10                                                   31                                             31
112214 112214 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002547 430 Tesla Engineering Charter School charter Regular School Yes 3.0 09 12 2015   grade_11                                                   33                                             33
112215 112215 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002547 430 Tesla Engineering Charter School charter Regular School Yes 3.0 09 12 2015   grade_12                                                   10                                             10
112216 112216 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002547 430 Tesla Engineering Charter School charter Regular School Yes 3.0 09 12 2015   grade_9                                                   43                                             43

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