enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 14,564 ✖
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
334101 334101 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2017   grade_3                                                   90                                             90
334102 334102 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2017   grade_4                                                   85                                             85
334103 334103 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2017   grade_5                                                   91                                             91
334104 334104 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2017   grade_6                                                   81                                             81
334105 334105 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2017   grade_7                                                   79                                             79
334106 334106 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2017   grade_8                                                   80                                             80
334107 334107 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2017   grade_9                                                   84                                             84
334108 334108 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2017   kindergarten_4_year_old                                                   61                                             61
334109 334109 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2017   kindergarten                                                   107                                             107
337070 337070 WI Milwaukee   school 5500043 8107 Non District Charter Schools School for Early Development and 550004302497 1279 School for Early Development and Achievement (SEDA) charter Regular School Yes Elementary PK 02 2017   pk_12_total 1.0 42.0 1.0               1.0   23.0 22.0             *     1   45 1 42 1               1   23 22             1   45
337071 337071 WI Milwaukee   school 5500043 8107 Non District Charter Schools School for Early Development and 550004302497 1279 School for Early Development and Achievement (SEDA) charter Regular School Yes Elementary PK 02 2017   grade_1                                                   7                                             7
337072 337072 WI Milwaukee   school 5500043 8107 Non District Charter Schools School for Early Development and 550004302497 1279 School for Early Development and Achievement (SEDA) charter Regular School Yes Elementary PK 02 2017   grade_2                                                   11                                             11
337073 337073 WI Milwaukee   school 5500043 8107 Non District Charter Schools School for Early Development and 550004302497 1279 School for Early Development and Achievement (SEDA) charter Regular School Yes Elementary PK 02 2017   kindergarten_3_year_old                                                   5                                             5
337074 337074 WI Milwaukee   school 5500043 8107 Non District Charter Schools School for Early Development and 550004302497 1279 School for Early Development and Achievement (SEDA) charter Regular School Yes Elementary PK 02 2017   kindergarten_4_year_old                                                   4                                             4
337075 337075 WI Milwaukee   school 5500043 8107 Non District Charter Schools School for Early Development and 550004302497 1279 School for Early Development and Achievement (SEDA) charter Regular School Yes Elementary PK 02 2017   kindergarten                                                   11                                             11
337076 337076 WI Milwaukee   school 5500043 8107 Non District Charter Schools School for Early Development and 550004302497 1279 School for Early Development and Achievement (SEDA) charter Regular School Yes Elementary PK 02 2017   pre_kindergarten                                                   7                                             7
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
327854 327854 WI Milwaukee   school 5500047 8109 Non District Charter Schools Darrell Lynn Hines Academy 550004702536 100 Darrell Lynn Hines Academy charter Regular School Yes Elementary PK 08 2017   pk_12_total 1.0 245.0 9.0     18.0         9.0   122.0 160.0             257     30   282 1 245 9     18         9   122 160         257   30   282
327855 327855 WI Milwaukee   school 5500047 8109 Non District Charter Schools Darrell Lynn Hines Academy 550004702536 100 Darrell Lynn Hines Academy charter Regular School Yes Elementary PK 08 2017   grade_1                                                   29                                             29
327856 327856 WI Milwaukee   school 5500047 8109 Non District Charter Schools Darrell Lynn Hines Academy 550004702536 100 Darrell Lynn Hines Academy charter Regular School Yes Elementary PK 08 2017   grade_2                                                   30                                             30
327857 327857 WI Milwaukee   school 5500047 8109 Non District Charter Schools Darrell Lynn Hines Academy 550004702536 100 Darrell Lynn Hines Academy charter Regular School Yes Elementary PK 08 2017   grade_3                                                   29                                             29
327858 327858 WI Milwaukee   school 5500047 8109 Non District Charter Schools Darrell Lynn Hines Academy 550004702536 100 Darrell Lynn Hines Academy charter Regular School Yes Elementary PK 08 2017   grade_4                                                   28                                             28
327859 327859 WI Milwaukee   school 5500047 8109 Non District Charter Schools Darrell Lynn Hines Academy 550004702536 100 Darrell Lynn Hines Academy charter Regular School Yes Elementary PK 08 2017   grade_5                                                   29                                             29
327860 327860 WI Milwaukee   school 5500047 8109 Non District Charter Schools Darrell Lynn Hines Academy 550004702536 100 Darrell Lynn Hines Academy charter Regular School Yes Elementary PK 08 2017   grade_6                                                   28                                             28
327861 327861 WI Milwaukee   school 5500047 8109 Non District Charter Schools Darrell Lynn Hines Academy 550004702536 100 Darrell Lynn Hines Academy charter Regular School Yes Elementary PK 08 2017   grade_7                                                   29                                             29
327862 327862 WI Milwaukee   school 5500047 8109 Non District Charter Schools Darrell Lynn Hines Academy 550004702536 100 Darrell Lynn Hines Academy charter Regular School Yes Elementary PK 08 2017   grade_8                                                   30                                             30
327863 327863 WI Milwaukee   school 5500047 8109 Non District Charter Schools Darrell Lynn Hines Academy 550004702536 100 Darrell Lynn Hines Academy charter Regular School Yes Elementary PK 08 2017   kindergarten_4_year_old                                                   25                                             25
327864 327864 WI Milwaukee   school 5500047 8109 Non District Charter Schools Darrell Lynn Hines Academy 550004702536 100 Darrell Lynn Hines Academy charter Regular School Yes Elementary PK 08 2017   kindergarten                                                   25                                             25
338365 338365 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2017   pk_12_total 453.0 1.0 61.0 2.0   3.0         14.0   276.0 258.0             163     54   534 453 1 61 2   3         14   276 258         163   54   534
338366 338366 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2017   grade_1                                                   53                                             53
338367 338367 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2017   grade_2                                                   53                                             53
338368 338368 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2017   grade_3                                                   43                                             43
338369 338369 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2017   grade_4                                                   66                                             66
338370 338370 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2017   grade_5                                                   59                                             59
338371 338371 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2017   grade_6                                                   63                                             63
338372 338372 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2017   grade_7                                                   42                                             42
338373 338373 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2017   grade_8                                                   60                                             60
338374 338374 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2017   kindergarten_4_year_old                                                   43                                             43
338375 338375 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2017   kindergarten                                                   44                                             44
338376 338376 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   8                                             8
329668 329668 WI Shawano   school 5500056 2415 Public school Gresham 550005602740 400 Gresham High   Regular School No Other 06 12 2017   pk_12_total 86.0   9.0 54.0             19.0   88.0 80.0             92     26   168 86   9 54             19   88 80         92   26   168
329669 329669 WI Shawano   school 5500056 2415 Public school Gresham 550005602740 400 Gresham High   Regular School No Other 06 12 2017   grade_10                                                   29                                             29
329670 329670 WI Shawano   school 5500056 2415 Public school Gresham 550005602740 400 Gresham High   Regular School No Other 06 12 2017   grade_11                                                   21                                             21
329671 329671 WI Shawano   school 5500056 2415 Public school Gresham 550005602740 400 Gresham High   Regular School No Other 06 12 2017   grade_12                                                   27                                             27
329672 329672 WI Shawano   school 5500056 2415 Public school Gresham 550005602740 400 Gresham High   Regular School No Other 06 12 2017   grade_6                                                   22                                             22
329673 329673 WI Shawano   school 5500056 2415 Public school Gresham 550005602740 400 Gresham High   Regular School No Other 06 12 2017   grade_7                                                   24                                             24
329674 329674 WI Shawano   school 5500056 2415 Public school Gresham 550005602740 400 Gresham High   Regular School No Other 06 12 2017   grade_8                                                   17                                             17
329675 329675 WI Shawano   school 5500056 2415 Public school Gresham 550005602740 400 Gresham High   Regular School No Other 06 12 2017   grade_9                                                   28                                             28
329659 329659 WI Shawano   school 5500056 2415 Public school Gresham 550005602748 100 Gresham Elementary   Regular School No Elementary PK 05 2017   pk_12_total 68.0   6.0 63.0             37.0   93.0 81.0             117     31   174 68   6 63             37   93 81         117   31   174
329660 329660 WI Shawano   school 5500056 2415 Public school Gresham 550005602748 100 Gresham Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   23                                             23
329661 329661 WI Shawano   school 5500056 2415 Public school Gresham 550005602748 100 Gresham Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   20                                             20
329662 329662 WI Shawano   school 5500056 2415 Public school Gresham 550005602748 100 Gresham Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   25                                             25
329663 329663 WI Shawano   school 5500056 2415 Public school Gresham 550005602748 100 Gresham Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   39                                             39
329664 329664 WI Shawano   school 5500056 2415 Public school Gresham 550005602748 100 Gresham Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   24                                             24
329665 329665 WI Shawano   school 5500056 2415 Public school Gresham 550005602748 100 Gresham Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   17                                             17
329666 329666 WI Shawano   school 5500056 2415 Public school Gresham 550005602748 100 Gresham Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   24                                             24
329667 329667 WI Shawano   school 5500056 2415 Public school Gresham 550005602748 100 Gresham Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   2                                             2
327316 327316 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2017   pk_12_total 35.0 1.0   2.0                 29.0 9.0             *     4   38 35 1   2                 29 9             4   38
327317 327317 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2017   grade_1                                                   7                                             7
327318 327318 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2017   grade_2                                                   5                                             5
327319 327319 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2017   grade_3                                                   11                                             11
327320 327320 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2017   kindergarten_4_year_old                                                   5                                             5
327321 327321 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2017   kindergarten                                                   10                                             10
327322 327322 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   pk_12_total 205.0   8.0 5.0   2.0       21.0 6.0   127.0 120.0             157     42   247 205   8 5   2       21 6   127 120         157   42   247
327323 327323 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   32                                             32
327324 327324 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   35                                             35
327325 327325 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   38                                             38
327326 327326 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   43                                             43
327327 327327 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   47                                             47
327328 327328 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   18                                             18
327329 327329 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   30                                             30
327330 327330 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   4                                             4
327302 327302 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2017   pk_12_total 207.0   7.0 2.0   6.0       5.0 1.0   116.0 112.0             82     31   228 207   7 2   6       5 1   116 112         82   31   228
327303 327303 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2017   grade_10                                                   41                                             41
327304 327304 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2017   grade_11                                                   59                                             59
327305 327305 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2017   grade_12                                                   59                                             59
327306 327306 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2017   grade_9                                                   69                                             69
327307 327307 WI Price   school 5500058 1071 Public school Chequamegon 550005802766 200 Chequamegon Middle   Regular School No Middle 06 08 2017   pk_12_total 156.0 2.0 2.0     3.0       8.0 1.0   94.0 78.0             74     20   172 156 2 2     3       8 1   94 78         74   20   172
327308 327308 WI Price   school 5500058 1071 Public school Chequamegon 550005802766 200 Chequamegon Middle   Regular School No Middle 06 08 2017   grade_6                                                   59                                             59
327309 327309 WI Price   school 5500058 1071 Public school Chequamegon 550005802766 200 Chequamegon Middle   Regular School No Middle 06 08 2017   grade_7                                                   54                                             54
327310 327310 WI Price   school 5500058 1071 Public school Chequamegon 550005802766 200 Chequamegon Middle   Regular School No Middle 06 08 2017   grade_8                                                   59                                             59
327311 327311 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2017   pk_12_total 10.0                   1.0   5.0 6.0             5     1   11 10                   1   5 6         5   1   11
327312 327312 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2017   grade_10                                                   2                                             2
327313 327313 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2017   grade_11                                                   3                                             3
327314 327314 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2017   grade_12                                                   4                                             4
327315 327315 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2017   grade_9                                                   2                                             2
327004 327004 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2017   pk_12_total 23.0 1.0 1209.0     1.0         1.0   600.0 635.0             1     91   1235 23 1 1209     1         1   600 635         1   91   1235
327005 327005 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2017   grade_1                                                   137                                             137
327006 327006 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2017   grade_2                                                   136                                             136
327007 327007 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2017   grade_3                                                   135                                             135

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