enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
125820 125820 WI Vernon   school   6321 Public Schools-Multidistrict Charters Westby Area   9407 Vernon County Area Better Futures High charter           2015   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
125821 125821 WI Vernon   school   6321 Public Schools-Multidistrict Charters Westby Area   9407 Vernon County Area Better Futures High charter           2015   grade_12                                                   1                                             1
126305 126305 WI Juneau   school   6713 Public Schools-Multidistrict Charters Wonewoc-Union Center   9405 Juneau County Charter School charter           2015   pk_12_total   1.0                     1.0               *     *   1   1                     1                   1
126306 126306 WI Juneau   school   6713 Public Schools-Multidistrict Charters Wonewoc-Union Center   9405 Juneau County Charter School charter           2015   grade_12                                                   1                                             1
111861 111861 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond Elementary   Regular School No 1.0 01 05 2015   pk_12_total 110.0   39.0               1.0   83.0 67.0             70     30   150 110   39               1   83 67         70   30   150
111862 111862 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond Elementary   Regular School No 1.0 01 05 2015   grade_1                                                   24                                             24
111863 111863 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond Elementary   Regular School No 1.0 01 05 2015   grade_2                                                   30                                             30
111864 111864 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond Elementary   Regular School No 1.0 01 05 2015   grade_3                                                   26                                             26
111865 111865 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond Elementary   Regular School No 1.0 01 05 2015   grade_4                                                   30                                             30
111866 111866 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond Elementary   Regular School No 1.0 01 05 2015   grade_5                                                   40                                             40
112081 112081 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   pk_12_total 93.0 3.0 1.0 1.0   2.0             52.0 48.0             34     6   100 93 3 1 1   2             52 48         34   6   100
112082 112082 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   grade_1                                                   10                                             10
112083 112083 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   grade_2                                                   9                                             9
112084 112084 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   grade_3                                                   14                                             14
112085 112085 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   grade_4                                                   12                                             12
112086 112086 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   grade_5                                                   23                                             23
112087 112087 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   grade_6                                                   10                                             10
112088 112088 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   grade_7                                                   13                                             13
112089 112089 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes 1.0 01 08 2015   grade_8                                                   9                                             9
112338 112338 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000085 60 Valley View Elementary   Regular School No 1.0 01 05 2015   pk_12_total 516.0 29.0 48.0 32.0   23.0         55.0   352.0 351.0             309     101   703 516 29 48 32   23         55   352 351         309   101   703
112339 112339 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000085 60 Valley View Elementary   Regular School No 1.0 01 05 2015   grade_1                                                   136                                             136
112340 112340 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000085 60 Valley View Elementary   Regular School No 1.0 01 05 2015   grade_2                                                   151                                             151
112341 112341 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000085 60 Valley View Elementary   Regular School No 1.0 01 05 2015   grade_3                                                   122                                             122
112342 112342 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000085 60 Valley View Elementary   Regular School No 1.0 01 05 2015   grade_4                                                   141                                             141
112343 112343 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000085 60 Valley View Elementary   Regular School No 1.0 01 05 2015   grade_5                                                   153                                             153
114125 114125 WI Brown   school 5503660 1407 Public school Denmark 550366000387 60 Denmark Elementary   Regular School No 1.0 01 05 2015   pk_12_total 480.0 2.0 24.0 4.0   2.0         9.0   272.0 249.0             88     90   521 480 2 24 4   2         9   272 249         88   90   521
114126 114126 WI Brown   school 5503660 1407 Public school Denmark 550366000387 60 Denmark Elementary   Regular School No 1.0 01 05 2015   grade_1                                                   108                                             108
114127 114127 WI Brown   school 5503660 1407 Public school Denmark 550366000387 60 Denmark Elementary   Regular School No 1.0 01 05 2015   grade_2                                                   103                                             103
114128 114128 WI Brown   school 5503660 1407 Public school Denmark 550366000387 60 Denmark Elementary   Regular School No 1.0 01 05 2015   grade_3                                                   91                                             91
114129 114129 WI Brown   school 5503660 1407 Public school Denmark 550366000387 60 Denmark Elementary   Regular School No 1.0 01 05 2015   grade_4                                                   111                                             111
114130 114130 WI Brown   school 5503660 1407 Public school Denmark 550366000387 60 Denmark Elementary   Regular School No 1.0 01 05 2015   grade_5                                                   108                                             108
114433 114433 WI Rock   school 5504110 1568 Public school Edgerton 550411000446 160 Yahara Elementary   Regular School No 1.0 01 05 2015   pk_12_total 96.0   13.0               3.0   61.0 51.0             36     17   112 96   13               3   61 51         36   17   112
114434 114434 WI Rock   school 5504110 1568 Public school Edgerton 550411000446 160 Yahara Elementary   Regular School No 1.0 01 05 2015   grade_1                                                   16                                             16
114435 114435 WI Rock   school 5504110 1568 Public school Edgerton 550411000446 160 Yahara Elementary   Regular School No 1.0 01 05 2015   grade_2                                                   24                                             24
114436 114436 WI Rock   school 5504110 1568 Public school Edgerton 550411000446 160 Yahara Elementary   Regular School No 1.0 01 05 2015   grade_3                                                   23                                             23
114437 114437 WI Rock   school 5504110 1568 Public school Edgerton 550411000446 160 Yahara Elementary   Regular School No 1.0 01 05 2015   grade_4                                                   23                                             23
114438 114438 WI Rock   school 5504110 1568 Public school Edgerton 550411000446 160 Yahara Elementary   Regular School No 1.0 01 05 2015   grade_5                                                   26                                             26
115329 115329 WI Burnett   school 5505670 2233 Public school Grantsburg 550567000601 60 Grantsburg Elementary   Regular School No 1.0 01 03 2015   pk_12_total 152.0 4.0 10.0 1.0             9.0   89.0 87.0             105     31   176 152 4 10 1             9   89 87         105   31   176
115330 115330 WI Burnett   school 5505670 2233 Public school Grantsburg 550567000601 60 Grantsburg Elementary   Regular School No 1.0 01 03 2015   grade_1                                                   72                                             72
115331 115331 WI Burnett   school 5505670 2233 Public school Grantsburg 550567000601 60 Grantsburg Elementary   Regular School No 1.0 01 03 2015   grade_2                                                   52                                             52
115332 115332 WI Burnett   school 5505670 2233 Public school Grantsburg 550567000601 60 Grantsburg Elementary   Regular School No 1.0 01 03 2015   grade_3                                                   52                                             52
116549 116549 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000797 120 Haen Elementary   Regular School No 1.0 01 04 2015   pk_12_total 264.0 1.0 12.0 4.0   1.0         17.0   148.0 151.0             138     54   299 264 1 12 4   1         17   148 151         138   54   299
116550 116550 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000797 120 Haen Elementary   Regular School No 1.0 01 04 2015   grade_1                                                   69                                             69
116551 116551 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000797 120 Haen Elementary   Regular School No 1.0 01 04 2015   grade_2                                                   80                                             80
116552 116552 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000797 120 Haen Elementary   Regular School No 1.0 01 04 2015   grade_3                                                   79                                             79
116553 116553 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000797 120 Haen Elementary   Regular School No 1.0 01 04 2015   grade_4                                                   71                                             71
116571 116571 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000796 100 Quinney Elementary   Regular School No 1.0 01 04 2015   pk_12_total 328.0 3.0 36.0     15.0         10.0   208.0 184.0             99     48   392 328 3 36     15         10   208 184         99   48   392
116572 116572 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000796 100 Quinney Elementary   Regular School No 1.0 01 04 2015   grade_2                                                   136                                             136
116573 116573 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000796 100 Quinney Elementary   Regular School No 1.0 01 04 2015   grade_3                                                   130                                             130
116574 116574 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000796 100 Quinney Elementary   Regular School No 1.0 01 04 2015   grade_4                                                   126                                             126
117515 117515 WI Columbia   school 5508190 3150 Public school Lodi 550819000904 40 Lodi Elementary   Regular School No 1.0 01 05 2015   pk_12_total 399.0 1.0 25.0 4.0   3.0         4.0   228.0 208.0             99     78   436 399 1 25 4   3         4   228 208         99   78   436
117516 117516 WI Columbia   school 5508190 3150 Public school Lodi 550819000904 40 Lodi Elementary   Regular School No 1.0 01 05 2015   grade_1                                                   101                                             101
117517 117517 WI Columbia   school 5508190 3150 Public school Lodi 550819000904 40 Lodi Elementary   Regular School No 1.0 01 05 2015   grade_2                                                   110                                             110
117518 117518 WI Columbia   school 5508190 3150 Public school Lodi 550819000904 40 Lodi Elementary   Regular School No 1.0 01 05 2015   grade_3                                                   68                                             68
117519 117519 WI Columbia   school 5508190 3150 Public school Lodi 550819000904 40 Lodi Elementary   Regular School No 1.0 01 05 2015   grade_4                                                   72                                             72
117520 117520 WI Columbia   school 5508190 3150 Public school Lodi 550819000904 40 Lodi Elementary   Regular School No 1.0 01 05 2015   grade_5                                                   85                                             85
117962 117962 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000973 60 Franklin Elementary   Regular School No 1.0 01 06 2015   pk_12_total 244.0 7.0 46.0 2.0   78.0         25.0   219.0 183.0             243     68   402 244 7 46 2   78         25   219 183         243   68   402
117963 117963 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000973 60 Franklin Elementary   Regular School No 1.0 01 06 2015   grade_1                                                   83                                             83
117964 117964 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000973 60 Franklin Elementary   Regular School No 1.0 01 06 2015   grade_2                                                   64                                             64
117965 117965 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000973 60 Franklin Elementary   Regular School No 1.0 01 06 2015   grade_3                                                   64                                             64
117966 117966 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000973 60 Franklin Elementary   Regular School No 1.0 01 06 2015   grade_4                                                   68                                             68
117967 117967 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000973 60 Franklin Elementary   Regular School No 1.0 01 06 2015   grade_5                                                   69                                             69
117968 117968 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000973 60 Franklin Elementary   Regular School No 1.0 01 06 2015   grade_6                                                   54                                             54
117969 117969 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000974 100 Jackson Elementary   Regular School No 1.0 01 06 2015   pk_12_total 321.0 4.0 32.0 2.0   14.0         7.0   205.0 175.0             125     49   380 321 4 32 2   14         7   205 175         125   49   380
117970 117970 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000974 100 Jackson Elementary   Regular School No 1.0 01 06 2015   grade_1                                                   70                                             70
117971 117971 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000974 100 Jackson Elementary   Regular School No 1.0 01 06 2015   grade_2                                                   50                                             50
117972 117972 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000974 100 Jackson Elementary   Regular School No 1.0 01 06 2015   grade_3                                                   52                                             52
117973 117973 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000974 100 Jackson Elementary   Regular School No 1.0 01 06 2015   grade_4                                                   56                                             56
117974 117974 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000974 100 Jackson Elementary   Regular School No 1.0 01 06 2015   grade_5                                                   77                                             77
117975 117975 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000974 100 Jackson Elementary   Regular School No 1.0 01 06 2015   grade_6                                                   75                                             75
117976 117976 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000975 120 Jefferson Elementary   Regular School No 1.0 01 06 2015   pk_12_total 189.0 14.0 104.0 2.0   55.0         19.0   193.0 190.0             286     59   383 189 14 104 2   55         19   193 190         286   59   383
117977 117977 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000975 120 Jefferson Elementary   Regular School No 1.0 01 06 2015   grade_1                                                   80                                             80
117978 117978 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000975 120 Jefferson Elementary   Regular School No 1.0 01 06 2015   grade_2                                                   60                                             60
117979 117979 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000975 120 Jefferson Elementary   Regular School No 1.0 01 06 2015   grade_3                                                   43                                             43
117980 117980 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000975 120 Jefferson Elementary   Regular School No 1.0 01 06 2015   grade_4                                                   70                                             70
117981 117981 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000975 120 Jefferson Elementary   Regular School No 1.0 01 06 2015   grade_5                                                   66                                             66
117982 117982 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000975 120 Jefferson Elementary   Regular School No 1.0 01 06 2015   grade_6                                                   64                                             64
117987 117987 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000977 160 Madison Elementary   Regular School No 1.0 01 06 2015   pk_12_total 173.0 14.0 31.0 3.0   5.0         20.0   129.0 117.0             139     40   246 173 14 31 3   5         20   129 117         139   40   246
117988 117988 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000977 160 Madison Elementary   Regular School No 1.0 01 06 2015   grade_1                                                   47                                             47
117989 117989 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000977 160 Madison Elementary   Regular School No 1.0 01 06 2015   grade_2                                                   39                                             39
117990 117990 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000977 160 Madison Elementary   Regular School No 1.0 01 06 2015   grade_3                                                   42                                             42
117991 117991 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000977 160 Madison Elementary   Regular School No 1.0 01 06 2015   grade_4                                                   41                                             41
117992 117992 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000977 160 Madison Elementary   Regular School No 1.0 01 06 2015   grade_5                                                   36                                             36
117993 117993 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000977 160 Madison Elementary   Regular School No 1.0 01 06 2015   grade_6                                                   41                                             41
117994 117994 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002714 9120 Manitowoc County Comprehensive Charter School charter Special Education School Yes 1.0 01 08 2015   pk_12_total 5.0 3.0                     5.0 3.0             *     *   8 5 3                     5 3                 8
117995 117995 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002714 9120 Manitowoc County Comprehensive Charter School charter Special Education School Yes 1.0 01 08 2015   grade_2                                                   1                                             1
117996 117996 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002714 9120 Manitowoc County Comprehensive Charter School charter Special Education School Yes 1.0 01 08 2015   grade_3                                                   2                                             2
117997 117997 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002714 9120 Manitowoc County Comprehensive Charter School charter Special Education School Yes 1.0 01 08 2015   grade_5                                                   1                                             1
117998 117998 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002714 9120 Manitowoc County Comprehensive Charter School charter Special Education School Yes 1.0 01 08 2015   grade_6                                                   1                                             1
117999 117999 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002714 9120 Manitowoc County Comprehensive Charter School charter Special Education School Yes 1.0 01 08 2015   grade_7                                                   1                                             1
118000 118000 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002714 9120 Manitowoc County Comprehensive Charter School charter Special Education School Yes 1.0 01 08 2015   grade_8                                                   2                                             2
118006 118006 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000978 220 Monroe Elementary   Regular School No 1.0 01 06 2015   pk_12_total 301.0 17.0 29.0 1.0   42.0         16.0   204.0 202.0             192     47   406 301 17 29 1   42         16   204 202         192   47   406
118007 118007 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000978 220 Monroe Elementary   Regular School No 1.0 01 06 2015   grade_1                                                   71                                             71
118008 118008 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000978 220 Monroe Elementary   Regular School No 1.0 01 06 2015   grade_2                                                   79                                             79
118009 118009 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000978 220 Monroe Elementary   Regular School No 1.0 01 06 2015   grade_3                                                   63                                             63
118010 118010 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000978 220 Monroe Elementary   Regular School No 1.0 01 06 2015   grade_4                                                   67                                             67
118011 118011 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000978 220 Monroe Elementary   Regular School No 1.0 01 06 2015   grade_5                                                   57                                             57
118012 118012 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000978 220 Monroe Elementary   Regular School No 1.0 01 06 2015   grade_6                                                   69                                             69
118017 118017 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000979 260 Stangel Elementary   Regular School No 1.0 01 06 2015   pk_12_total 320.0 6.0 40.0     10.0         12.0   194.0 194.0             127     57   388 320 6 40     10         12   194 194         127   57   388
118018 118018 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000979 260 Stangel Elementary   Regular School No 1.0 01 06 2015   grade_1                                                   67                                             67

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