enrollments

Data source: Big Local News · About: Big Local

14,664 rows where state = "WI" and year = 2017 sorted by school_state_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
336005 336005 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No Elementary PK 01 2017   grade_1                                                   77                                             77
336006 336006 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No Elementary PK 01 2017   kindergarten_4_year_old                                                   73                                             73
336007 336007 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No Elementary PK 01 2017   kindergarten                                                   66                                             66
336008 336008 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No Elementary PK 01 2017   pre_kindergarten                                                   11                                             11
337132 337132 WI Door   school 5513500 5130 Public school Sevastopol 551350000229 10 Sevastopol Pre-School   Regular School No Elementary PK PK 2017   pk_12_total 38.0   2.0     1.0             26.0 15.0             13     9   41 38   2     1             26 15         13   9   41
337133 337133 WI Door   school 5513500 5130 Public school Sevastopol 551350000229 10 Sevastopol Pre-School   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   38                                             38
337134 337134 WI Door   school 5513500 5130 Public school Sevastopol 551350000229 10 Sevastopol Pre-School   Regular School No Elementary PK PK 2017   pre_kindergarten                                                   3                                             3
337394 337394 WI Washburn   school 5513710 5306 Public school Shell Lake 551371000507 10 Shell Lake Primary (K-2)   Regular School No Elementary PK 02 2017   pk_12_total 156.0   7.0 4.0             7.0   91.0 83.0             90     24   174 156   7 4             7   91 83         90   24   174
337395 337395 WI Washburn   school 5513710 5306 Public school Shell Lake 551371000507 10 Shell Lake Primary (K-2)   Regular School No Elementary PK 02 2017   grade_1                                                   48                                             48
337396 337396 WI Washburn   school 5513710 5306 Public school Shell Lake 551371000507 10 Shell Lake Primary (K-2)   Regular School No Elementary PK 02 2017   grade_2                                                   50                                             50
337397 337397 WI Washburn   school 5513710 5306 Public school Shell Lake 551371000507 10 Shell Lake Primary (K-2)   Regular School No Elementary PK 02 2017   kindergarten_4_year_old                                                   37                                             37
337398 337398 WI Washburn   school 5513710 5306 Public school Shell Lake 551371000507 10 Shell Lake Primary (K-2)   Regular School No Elementary PK 02 2017   kindergarten                                                   39                                             39
337504 337504 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No Elementary PK 05 2017   pk_12_total 369.0 4.0 17.0     4.0         8.0   185.0 217.0             74     47   402 369 4 17     4         8   185 217         74   47   402
337505 337505 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   70                                             70
337506 337506 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   54                                             54
337507 337507 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   58                                             58
337508 337508 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   66                                             66
337509 337509 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   53                                             53
337510 337510 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   47                                             47
337511 337511 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   53                                             53
337512 337512 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
337564 337564 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No Elementary PK 05 2017   pk_12_total 268.0 29.0 63.0     1.0         7.0   204.0 164.0             175     64   368 268 29 63     1         7   204 164         175   64   368
337565 337565 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   46                                             46
337566 337566 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   57                                             57
337567 337567 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   56                                             56
337568 337568 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   49                                             49
337569 337569 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   62                                             62
337570 337570 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   42                                             42
337571 337571 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   48                                             48
337572 337572 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   8                                             8
337811 337811 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001868 10 Benjamin Franklin Junior High   Regular School No Other 07 09 2017   pk_12_total 668.0 14.0 41.0     57.0         27.0   410.0 397.0             215     105   807 668 14 41     57         27   410 397         215   105   807
337812 337812 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001868 10 Benjamin Franklin Junior High   Regular School No Other 07 09 2017   grade_7                                                   277                                             277
337813 337813 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001868 10 Benjamin Franklin Junior High   Regular School No Other 07 09 2017   grade_8                                                   247                                             247
337814 337814 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001868 10 Benjamin Franklin Junior High   Regular School No Other 07 09 2017   grade_9                                                   283                                             283
338001 338001 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001894 10 Sturgeon Bay High   Regular School No High 09 12 2017   pk_12_total 338.0 9.0 29.0 1.0   6.0       3.0 9.0   202.0 193.0             117     46   395 338 9 29 1   6       3 9   202 193         117   46   395
338002 338002 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001894 10 Sturgeon Bay High   Regular School No High 09 12 2017   grade_10                                                   97                                             97
338003 338003 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001894 10 Sturgeon Bay High   Regular School No High 09 12 2017   grade_11                                                   93                                             93
338004 338004 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001894 10 Sturgeon Bay High   Regular School No High 09 12 2017   grade_12                                                   103                                             103
338005 338005 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001894 10 Sturgeon Bay High   Regular School No High 09 12 2017   grade_9                                                   102                                             102
338665 338665 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 05 2017   pk_12_total 214.0 4.0 7.0 30.0             6.0   147.0 114.0             116     37   261 214 4 7 30             6   147 114         116   37   261
338666 338666 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   30                                             30
338667 338667 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   44                                             44
338668 338668 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   43                                             43
338669 338669 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   34                                             34
338670 338670 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   47                                             47
338671 338671 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   29                                             29
338672 338672 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   34                                             34
338717 338717 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566001989 10 Fox River Middle   Regular School No Middle 07 08 2017   pk_12_total 326.0 4.0 17.0     2.0         6.0   174.0 181.0             38     24   355 326 4 17     2         6   174 181         38   24   355
338718 338718 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566001989 10 Fox River Middle   Regular School No Middle 07 08 2017   grade_7                                                   154                                             154
338719 338719 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566001989 10 Fox River Middle   Regular School No Middle 07 08 2017   grade_8                                                   201                                             201
339565 339565 WI Washington   school 5516290 6307 Public school West Bend 551629002125 10 Badger Middle   Regular School No Middle 07 08 2017   pk_12_total 816.0 29.0 69.0 7.0   12.0       1.0 22.0   484.0 472.0             277     118   956 816 29 69 7   12       1 22   484 472         277   118   956
339566 339566 WI Washington   school 5516290 6307 Public school West Bend 551629002125 10 Badger Middle   Regular School No Middle 07 08 2017   grade_7                                                   500                                             500
339567 339567 WI Washington   school 5516290 6307 Public school West Bend 551629002125 10 Badger Middle   Regular School No Middle 07 08 2017   grade_8                                                   456                                             456
326810 326810 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2017   pk_12_total 229.0 3.0 14.0 1.0   2.0         1.0   117.0 133.0             89     51   250 229 3 14 1   2         1   117 133         89   51   250
326811 326811 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2017   grade_10                                                   49                                             49
326812 326812 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2017   grade_11                                                   31                                             31
326813 326813 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2017   grade_12                                                   37                                             37
326814 326814 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2017   grade_7                                                   40                                             40
326815 326815 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2017   grade_8                                                   47                                             47
326816 326816 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2017   grade_9                                                   46                                             46
332747 332747 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001127 12 Bay View High   Regular School No High 09 12 2017   pk_12_total 105.0 423.0 235.0 17.0   24.0       1.0 15.0   457.0 363.0             733     212   820 105 423 235 17   24       1 15   457 363         733   212   820
332748 332748 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001127 12 Bay View High   Regular School No High 09 12 2017   grade_10                                                   204                                             204
332749 332749 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001127 12 Bay View High   Regular School No High 09 12 2017   grade_11                                                   174                                             174
332750 332750 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001127 12 Bay View High   Regular School No High 09 12 2017   grade_12                                                   133                                             133
332751 332751 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001127 12 Bay View High   Regular School No High 09 12 2017   grade_9                                                   309                                             309
332764 332764 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001218 14 Bradley Technology High   Regular School No High 09 12 2017   pk_12_total 32.0 633.0 156.0 4.0   6.0         16.0   503.0 344.0             778     221   847 32 633 156 4   6         16   503 344         778   221   847
332765 332765 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001218 14 Bradley Technology High   Regular School No High 09 12 2017   grade_10                                                   188                                             188
332766 332766 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001218 14 Bradley Technology High   Regular School No High 09 12 2017   grade_11                                                   182                                             182
332767 332767 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001218 14 Bradley Technology High   Regular School No High 09 12 2017   grade_12                                                   141                                             141
332768 332768 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001218 14 Bradley Technology High   Regular School No High 09 12 2017   grade_8                                                   1                                             1
332769 332769 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001218 14 Bradley Technology High   Regular School No High 09 12 2017   grade_9                                                   335                                             335
331643 331643 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002263 15 Lincoln Elementary   Regular School No Elementary PK 05 2017   pk_12_total 132.0 63.0 164.0 1.0   51.0         38.0   215.0 234.0             263     52   449 132 63 164 1   51         38   215 234         263   52   449
331644 331644 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002263 15 Lincoln Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   156                                             156
331645 331645 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002263 15 Lincoln Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   130                                             130
331646 331646 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002263 15 Lincoln Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   130                                             130
331647 331647 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002263 15 Lincoln Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   32                                             32
331648 331648 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002263 15 Lincoln Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   1                                             1
335618 335618 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135002274 15 Palmyra-Eagle High   Regular School No High 09 12 2017   pk_12_total 251.0   28.0 1.0   1.0         2.0   151.0 132.0             55     45   283 251   28 1   1         2   151 132         55   45   283
335619 335619 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135002274 15 Palmyra-Eagle High   Regular School No High 09 12 2017   grade_10                                                   71                                             71
335620 335620 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135002274 15 Palmyra-Eagle High   Regular School No High 09 12 2017   grade_11                                                   84                                             84
335621 335621 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135002274 15 Palmyra-Eagle High   Regular School No High 09 12 2017   grade_12                                                   66                                             66
335622 335622 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135002274 15 Palmyra-Eagle High   Regular School No High 09 12 2017   grade_9                                                   62                                             62
338708 338708 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No Elementary PK 06 2017   pk_12_total 364.0 7.0 24.0 2.0   3.0       1.0 17.0   219.0 199.0             39     71   418 364 7 24 2   3       1 17   219 199         39   71   418
338709 338709 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No Elementary PK 06 2017   grade_1                                                   47                                             47
338710 338710 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No Elementary PK 06 2017   grade_2                                                   50                                             50
338711 338711 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No Elementary PK 06 2017   grade_3                                                   47                                             47
338712 338712 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No Elementary PK 06 2017   grade_4                                                   56                                             56
338713 338713 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No Elementary PK 06 2017   grade_5                                                   54                                             54
338714 338714 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No Elementary PK 06 2017   grade_6                                                   59                                             59
338715 338715 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No Elementary PK 06 2017   kindergarten                                                   53                                             53
338716 338716 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   52                                             52
333178 333178 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001180 18 Hamilton High   Regular School No High 09 12 2017   pk_12_total 226.0 655.0 813.0 20.0   80.0         22.0   1024.0 792.0             1368     443   1816 226 655 813 20   80         22   1024 792         1368   443   1816
333179 333179 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001180 18 Hamilton High   Regular School No High 09 12 2017   grade_10                                                   468                                             468
333180 333180 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001180 18 Hamilton High   Regular School No High 09 12 2017   grade_11                                                   385                                             385
333181 333181 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001180 18 Hamilton High   Regular School No High 09 12 2017   grade_12                                                   302                                             302
333182 333182 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001180 18 Hamilton High   Regular School No High 09 12 2017   grade_9                                                   661                                             661
325608 325608 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2017   pk_12_total 170.0 7.0 197.0 1.0             2.0   201.0 176.0             197     44   377 170 7 197 1             2   201 176         197   44   377
325609 325609 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   50                                             50
325610 325610 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   55                                             55
325611 325611 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   49                                             49

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