enrollments

Data source: Big Local News · About: Big Local

14,664 rows where state = "WI" and year = 2017 sorted by ccd_charter_school descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 14,664 ✖
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
325597 325597 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   pk_12_total 75.0 229.0 152.0     2.0         41.0   234.0 265.0             362     46   499 75 229 152     2         41   234 265         362   46   499
325598 325598 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   grade_1                                                   60                                             60
325599 325599 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   grade_2                                                   48                                             48
325600 325600 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   grade_3                                                   59                                             59
325601 325601 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   grade_4                                                   51                                             51
325602 325602 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   grade_5                                                   51                                             51
325603 325603 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   grade_6                                                   38                                             38
325604 325604 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   grade_7                                                   57                                             57
325605 325605 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   grade_8                                                   37                                             37
325606 325606 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   kindergarten_4_year_old                                                   41                                             41
325607 325607 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   kindergarten                                                   57                                             57
325664 325664 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes Middle 06 08 2017   pk_12_total 68.0   5.0     1.0         1.0   38.0 37.0             32     14   75 68   5     1         1   38 37         32   14   75
325665 325665 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes Middle 06 08 2017   grade_6                                                   24                                             24
325666 325666 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes Middle 06 08 2017   grade_7                                                   29                                             29
325667 325667 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes Middle 06 08 2017   grade_8                                                   22                                             22
325851 325851 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2017   pk_12_total 44.0   114.0               7.0   78.0 87.0             79     11   165 44   114               7   78 87         79   11   165
325852 325852 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2017   grade_1                                                   28                                             28
325853 325853 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2017   grade_2                                                   27                                             27
325854 325854 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2017   grade_3                                                   26                                             26
325855 325855 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2017   grade_4                                                   19                                             19
325856 325856 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2017   grade_5                                                   22                                             22
325857 325857 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2017   grade_6                                                   15                                             15
325858 325858 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2017   kindergarten                                                   28                                             28
325863 325863 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2017   pk_12_total 15.0                       5.0 10.0             5         15 15                       5 10         5       15
325864 325864 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2017   grade_10                                                   2                                             2
325865 325865 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2017   grade_11                                                   2                                             2
325866 325866 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2017   grade_12                                                   9                                             9
325867 325867 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2017   grade_9                                                   2                                             2
325868 325868 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2017   pk_12_total 145.0 1.0 6.0     1.0         2.0   78.0 77.0             29     6   155 145 1 6     1         2   78 77         29   6   155
325869 325869 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2017   grade_1                                                   20                                             20
325870 325870 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2017   grade_2                                                   20                                             20
325871 325871 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2017   grade_3                                                   20                                             20
325872 325872 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2017   grade_4                                                   18                                             18
325873 325873 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2017   grade_5                                                   22                                             22
325874 325874 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2017   grade_6                                                   15                                             15
325875 325875 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2017   kindergarten_4_year_old                                                   20                                             20
325876 325876 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2017   kindergarten                                                   20                                             20
325877 325877 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Career and Technical School Yes High 09 12 2017   pk_12_total 57.0 1.0 9.0     1.0         1.0   64.0 5.0             24     18   69 57 1 9     1         1   64 5         24   18   69
325878 325878 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Career and Technical School Yes High 09 12 2017   grade_10                                                   22                                             22
325879 325879 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Career and Technical School Yes High 09 12 2017   grade_11                                                   23                                             23
325880 325880 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Career and Technical School Yes High 09 12 2017   grade_12                                                   10                                             10
325881 325881 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Career and Technical School Yes High 09 12 2017   grade_9                                                   14                                             14
325908 325908 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2017   pk_12_total 356.0 7.0 30.0     77.0         7.0   218.0 259.0             90     17   477 356 7 30     77         7   218 259         90   17   477
325909 325909 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2017   grade_1                                                   52                                             52
325910 325910 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2017   grade_2                                                   52                                             52
325911 325911 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2017   grade_3                                                   52                                             52
325912 325912 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2017   grade_4                                                   54                                             54
325913 325913 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2017   grade_5                                                   54                                             54
325914 325914 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2017   grade_6                                                   54                                             54
325915 325915 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2017   grade_7                                                   57                                             57
325916 325916 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2017   grade_8                                                   50                                             50
325917 325917 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2017   kindergarten                                                   52                                             52
325952 325952 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Fox Cities Leadership Academy charter Regular School Yes High 09 12 2017   pk_12_total 91.0 3.0 3.0     4.0         4.0   40.0 65.0             17     8   105 91 3 3     4         4   40 65         17   8   105
325953 325953 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Fox Cities Leadership Academy charter Regular School Yes High 09 12 2017   grade_10                                                   31                                             31
325954 325954 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Fox Cities Leadership Academy charter Regular School Yes High 09 12 2017   grade_11                                                   28                                             28
325955 325955 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Fox Cities Leadership Academy charter Regular School Yes High 09 12 2017   grade_12                                                   23                                             23
325956 325956 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Fox Cities Leadership Academy charter Regular School Yes High 09 12 2017   grade_9                                                   23                                             23
325957 325957 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2017   pk_12_total 99.0 4.0 4.0 1.0   3.0         1.0   62.0 50.0             36     12   112 99 4 4 1   3         1   62 50         36   12   112
325958 325958 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2017   grade_1                                                   12                                             12
325959 325959 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2017   grade_2                                                   11                                             11
325960 325960 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2017   grade_3                                                   17                                             17
325961 325961 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2017   grade_4                                                   6                                             6
325962 325962 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2017   grade_5                                                   18                                             18
325963 325963 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2017   grade_6                                                   17                                             17
325964 325964 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2017   grade_7                                                   9                                             9
325965 325965 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2017   grade_8                                                   7                                             7
325966 325966 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2017   kindergarten                                                   15                                             15
326026 326026 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002759 250 Kaleidoscope Academy charter Regular School Yes Middle 06 08 2017   pk_12_total 468.0 42.0 42.0 5.0   48.0       1.0 12.0   307.0 311.0             238     103   618 468 42 42 5   48       1 12   307 311         238   103   618
326027 326027 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002759 250 Kaleidoscope Academy charter Regular School Yes Middle 06 08 2017   grade_6                                                   166                                             166
326028 326028 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002759 250 Kaleidoscope Academy charter Regular School Yes Middle 06 08 2017   grade_7                                                   242                                             242
326029 326029 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002759 250 Kaleidoscope Academy charter Regular School Yes Middle 06 08 2017   grade_8                                                   210                                             210
326056 326056 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002277 210 Odyssey-Magellan charter Regular School Yes Elementary 03 08 2017   pk_12_total 135.0 1.0 3.0     18.0         2.0   97.0 62.0             12     14   159 135 1 3     18         2   97 62         12   14   159
326057 326057 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002277 210 Odyssey-Magellan charter Regular School Yes Elementary 03 08 2017   grade_3                                                   23                                             23
326058 326058 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002277 210 Odyssey-Magellan charter Regular School Yes Elementary 03 08 2017   grade_4                                                   30                                             30
326059 326059 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002277 210 Odyssey-Magellan charter Regular School Yes Elementary 03 08 2017   grade_5                                                   25                                             25
326060 326060 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002277 210 Odyssey-Magellan charter Regular School Yes Elementary 03 08 2017   grade_6                                                   28                                             28
326061 326061 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002277 210 Odyssey-Magellan charter Regular School Yes Elementary 03 08 2017   grade_7                                                   28                                             28
326062 326062 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002277 210 Odyssey-Magellan charter Regular School Yes Elementary 03 08 2017   grade_8                                                   25                                             25
326063 326063 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002282 420 Renaissance School charter Regular School Yes High 09 12 2017   pk_12_total 150.0 4.0 5.0 1.0   13.0         2.0   33.0 142.0             45     13   175 150 4 5 1   13         2   33 142         45   13   175
326064 326064 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002282 420 Renaissance School charter Regular School Yes High 09 12 2017   grade_10                                                   47                                             47
326065 326065 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002282 420 Renaissance School charter Regular School Yes High 09 12 2017   grade_11                                                   34                                             34
326066 326066 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002282 420 Renaissance School charter Regular School Yes High 09 12 2017   grade_12                                                   38                                             38
326067 326067 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002282 420 Renaissance School charter Regular School Yes High 09 12 2017   grade_9                                                   56                                             56
326076 326076 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes Elementary PK 06 2017   pk_12_total 198.0 18.0 16.0 2.0   72.0         7.0   158.0 155.0             159     49   313 198 18 16 2   72         7   158 155         159   49   313
326077 326077 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes Elementary PK 06 2017   grade_1                                                   47                                             47
326078 326078 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes Elementary PK 06 2017   grade_2                                                   58                                             58
326079 326079 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes Elementary PK 06 2017   grade_3                                                   35                                             35
326080 326080 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes Elementary PK 06 2017   grade_4                                                   48                                             48
326081 326081 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes Elementary PK 06 2017   grade_5                                                   40                                             40
326082 326082 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes Elementary PK 06 2017   grade_6                                                   39                                             39
326083 326083 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes Elementary PK 06 2017   kindergarten                                                   46                                             46
326084 326084 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002547 430 Tesla Engineering Charter School charter Regular School Yes High 09 12 2017   pk_12_total 114.0   5.0     6.0             107.0 18.0             21     3   125 114   5     6             107 18         21   3   125
326085 326085 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002547 430 Tesla Engineering Charter School charter Regular School Yes High 09 12 2017   grade_10                                                   25                                             25
326086 326086 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002547 430 Tesla Engineering Charter School charter Regular School Yes High 09 12 2017   grade_11                                                   39                                             39
326087 326087 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002547 430 Tesla Engineering Charter School charter Regular School Yes High 09 12 2017   grade_12                                                   24                                             24
326088 326088 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002547 430 Tesla Engineering Charter School charter Regular School Yes High 09 12 2017   grade_9                                                   37                                             37
326089 326089 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2017   pk_12_total 65.0   1.0 1.0   1.0         1.0   26.0 43.0             12     2   69 65   1 1   1         1   26 43         12   2   69
326090 326090 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2017   grade_10                                                   11                                             11
326091 326091 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2017   grade_11                                                   11                                             11
326092 326092 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2017   grade_12                                                   14                                             14

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