enrollments

Data source: Big Local News · About: Big Local

14,653 rows where state = "WI" and year = 2015 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 14,553 ✖
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
121396 121396 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   42                                             42
121397 121397 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   49                                             49
121398 121398 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   48                                             48
121399 121399 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   32                                             32
121400 121400 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   30                                             30
121401 121401 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   43                                             43
118781 118781 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2015   pk_12_total 263.0 38.0 129.0 3.0   181.0       1.0 6.0   308.0 313.0             419     82   621 263 38 129 3   181       1 6   308 313         419   82   621
118782 118782 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2015   grade_1                                                   89                                             89
118783 118783 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2015   grade_2                                                   96                                             96
118784 118784 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2015   grade_3                                                   88                                             88
118785 118785 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2015   grade_4                                                   85                                             85
118786 118786 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2015   grade_5                                                   76                                             76
118787 118787 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   6                                             6
118788 118788 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   86                                             86
118789 118789 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2015   kindergarten                                                   95                                             95
121579 121579 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes 2.0 04 08 2015   pk_12_total 36.0 3.0 1.0     5.0         2.0   19.0 28.0             10     1   47 36 3 1     5         2   19 28         10   1   47
121580 121580 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes 2.0 04 08 2015   grade_4                                                   8                                             8
121581 121581 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes 2.0 04 08 2015   grade_5                                                   13                                             13
121582 121582 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes 2.0 04 08 2015   grade_6                                                   11                                             11
121583 121583 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes 2.0 04 08 2015   grade_7                                                   11                                             11
121584 121584 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes 2.0 04 08 2015   grade_8                                                   4                                             4
118790 118790 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002935 447 Achievement Center   Alternative Education School No 4.0 06 12 2015   pk_12_total 2.0 46.0 2.0 1.0                 28.0 23.0             45     26   51 2 46 2 1                 28 23         45   26   51
118791 118791 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002935 447 Achievement Center   Alternative Education School No 4.0 06 12 2015   grade_10                                                   14                                             14
118792 118792 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002935 447 Achievement Center   Alternative Education School No 4.0 06 12 2015   grade_11                                                   3                                             3
118793 118793 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002935 447 Achievement Center   Alternative Education School No 4.0 06 12 2015   grade_12                                                   4                                             4
118794 118794 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002935 447 Achievement Center   Alternative Education School No 4.0 06 12 2015   grade_7                                                   4                                             4
118795 118795 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002935 447 Achievement Center   Alternative Education School No 4.0 06 12 2015   grade_8                                                   2                                             2
118796 118796 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002935 447 Achievement Center   Alternative Education School No 4.0 06 12 2015   grade_9                                                   24                                             24
116322 116322 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 323.0 12.0 43.0 4.0   5.0       1.0 18.0   211.0 195.0             250     45   406 323 12 43 4   5       1 18   211 195         250   45   406
116323 116323 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   68                                             68
116324 116324 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   67                                             67
116325 116325 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   64                                             64
116326 116326 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   59                                             59
116327 116327 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   61                                             61
116328 116328 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   15                                             15
116329 116329 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   68                                             68
116330 116330 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   4                                             4
111757 111757 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 428.0 12.0 51.0 3.0   1.0       1.0 5.0   259.0 242.0             371     84   501 428 12 51 3   1       1 5   259 242         371   84   501
111758 111758 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   72                                             72
111759 111759 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   72                                             72
111760 111760 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   67                                             67
111761 111761 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   78                                             78
111762 111762 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   76                                             76
111763 111763 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   69                                             69
111764 111764 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   59                                             59
111765 111765 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   8                                             8
111766 111766 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2015   pk_12_total 439.0 4.0 33.0 4.0           1.0 2.0   226.0 257.0             347     103   483 439 4 33 4           1 2   226 257         347   103   483
111767 111767 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2015   grade_10                                                   140                                             140
111768 111768 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2015   grade_11                                                   123                                             123
111769 111769 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2015   grade_12                                                   117                                             117
111770 111770 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2015   grade_9                                                   103                                             103
111771 111771 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No 2.0 06 08 2015   pk_12_total 330.0 8.0 21.0 5.0           1.0 1.0   192.0 174.0             274     70   366 330 8 21 5           1 1   192 174         274   70   366
111772 111772 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No 2.0 06 08 2015   grade_6                                                   112                                             112
111773 111773 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No 2.0 06 08 2015   grade_7                                                   119                                             119
111774 111774 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No 2.0 06 08 2015   grade_8                                                   135                                             135
123650 123650 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 407.0 2.0 24.0     7.0         6.0   242.0 204.0             42     55   446 407 2 24     7         6   242 204         42   55   446
123651 123651 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   64                                             64
123652 123652 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   65                                             65
123653 123653 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   67                                             67
123654 123654 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   64                                             64
123655 123655 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   65                                             65
123656 123656 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   45                                             45
123657 123657 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   67                                             67
123658 123658 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   9                                             9
112503 112503 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2015   pk_12_total 65.0   8.0     1.0       2.0 1.0   32.0 45.0             37         77 65   8     1       2 1   32 45         37       77
112504 112504 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2015   grade_1                                                   1                                             1
112505 112505 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2015   grade_10                                                   16                                             16
112506 112506 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2015   grade_11                                                   18                                             18
112507 112507 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2015   grade_12                                                   14                                             14
112508 112508 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2015   grade_2                                                   1                                             1
112509 112509 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2015   grade_3                                                   5                                             5
112510 112510 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2015   grade_4                                                   3                                             3
112511 112511 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2015   grade_5                                                   1                                             1
112512 112512 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2015   grade_6                                                   2                                             2
112513 112513 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2015   grade_7                                                   1                                             1
112514 112514 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2015   grade_8                                                   8                                             8
112515 112515 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2015   grade_9                                                   6                                             6
112516 112516 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2015   kindergarten                                                   1                                             1
112440 112440 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 280.0 11.0 35.0 7.0   1.0         23.0   178.0 179.0             246     57   357 280 11 35 7   1         23   178 179         246   57   357
112441 112441 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   58                                             58
112442 112442 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   63                                             63
112443 112443 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   71                                             71
112444 112444 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   61                                             61
112445 112445 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   64                                             64
112446 112446 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   39                                             39
112447 112447 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   1                                             1
111792 111792 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2015   pk_12_total 99.0 1.0 4.0               1.0   45.0 60.0             32     14   105 99 1 4               1   45 60         32   14   105
111793 111793 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2015   grade_5                                                   27                                             27
111794 111794 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2015   grade_6                                                   28                                             28
111795 111795 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2015   grade_7                                                   23                                             23
111796 111796 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2015   grade_8                                                   27                                             27
111797 111797 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2015   pk_12_total 128.0 1.0 8.0     1.0         3.0   77.0 64.0             51     17   141 128 1 8     1         3   77 64         51   17   141
111798 111798 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2015   grade_1                                                   23                                             23
111799 111799 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2015   grade_2                                                   21                                             21
111800 111800 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2015   grade_3                                                   26                                             26
111801 111801 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   27                                             27
111802 111802 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2015   kindergarten_4_year_old                                                   24                                             24
111803 111803 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2015   kindergarten                                                   18                                             18
111804 111804 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   2                                             2
111805 111805 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No 3.0 09 12 2015   pk_12_total 105.0 2.0 2.0 1.0   3.0         1.0   62.0 52.0             33     17   114 105 2 2 1   3         1   62 52         33   17   114

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