enrollments

Data source: Big Local News · About: Big Local

671 rows where grade = "grade_7", state = "MN" and year = 2015 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 671 ✖

grade ✖

  • grade_7 · 671 ✖
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
1154664 1154664 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001071 30 MONTEVIDEO MIDDLE Middle School (Grades 5-8) Regular School No 2 04 07 2015   grade_7 64.0 3.0 16.0   1.0 1.0     0.0   2.0   53.0 34.0     12.0   0.0     40.0   17.0   87.0 64 3 16   1 1     0   2   53 34     12 0   40 17   87
1154772 1154772 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000078 320 SOUTHWEST MIDDLE Middle School (Grades 5-8) Regular School No 2 06 07 2015   grade_7 167.0 7.0 57.0   0.0 10.0     0.0   6.0   126.0 121.0         *         *   247.0 167 7 57   0 10     0   6   126 121                 247
1154781 1154781 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001298 109 TWIN BLUFF MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 05 07 2015   grade_7 152.0 10.0 15.0   12.0 8.0     0.0   6.0   108.0 95.0     3.0   1.0     77.0   27.0   203.0 152 10 15   12 8     0   6   108 95     3 1   77 27   203
1154818 1154818 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001109 63 GRANDVIEW MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 05 07 2015   grade_7 154.0 3.0 9.0   0.0 2.0     0.0   13.0   92.0 89.0     1.0   1.0     46.0   20.0   181.0 154 3 9   0 2     0   13   92 89     1 1   46 20   181
1155292 1155292 MN Faribault 22 school 2700130 2860 Independent Districts and Schools BLUE EARTH AREA PUBLIC SCHOOL 270013002497 23 BLUE EARTH AREA MIDDLE Middle School (Grades 5-8) Regular School No 2 06 07 2015   grade_7 75.0 1.0 10.0   0.0 0.0     0.0   0.0   53.0 33.0     2.0   0.0     38.0   12.0   86.0 75 1 10   0 0     0   0   53 33     2 0   38 12   86
1157211 1157211 MN Goodhue 25 school 2791443 6051 Education Districts Goodhue County Education District 279144304717 610 Pathways Program Public Area Learning Center ALC (State approved) Alternative Education School No 2 06 07 2015   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1157506 1157506 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295002998 39 MOUNDS VIEW BRIDGES PROGRAM Special Education Special Education School No 1 KG 07 2015   grade_7 2.0 2.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0         *         *   4.0 2 2 0   0 0     0   0   3 1                 4
1147951 1147951 MN Becker 3 school 2728960 25 Independent Districts and Schools PINE POINT PUBLIC SCHOOL DISTRICT 272896000034 70 PINE POINT ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 0.0 0.0 0.0   4.0 0.0     0.0   0.0   2.0 2.0         *         *   4.0 0 0 0   4 0     0   0   2 2                 4
1148037 1148037 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051001301 20 PONEMAH ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 0.0 0.0 0.0   12.0 0.0     0.0   0.0   5.0 7.0         0.0         *   12.0 0 0 0   12 0     0   0   5 7       0         12
1148072 1148072 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224002270 30 FOLEY INTERMEDIATE ELEMENTARY Elementary School (Grades PK-6) Regular School No 2 04 08 2015   grade_7 126.0 1.0 3.0   1.0 0.0     0.0   2.0   71.0 62.0     0.0   2.0     48.0   18.0   133.0 126 1 3   1 0     0   2   71 62     0 2   48 18   133
1150426 1150426 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001005 138 LINCOLN K-8 CHOICE ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 08 2015   grade_7 37.0 3.0 0.0   0.0 2.0     0.0   0.0   16.0 26.0         0.0     5.0   1.0   42.0 37 3 0   0 2     0   0   16 26       0   5 1   42
1150748 1150748 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243001046 73 PARKVIEW CENTER SCHOOL Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 55.0 5.0 8.0   0.0 10.0     0.0   3.0   35.0 46.0     5.0   0.0     17.0   17.0   81.0 55 5 8   0 10     0   3   35 46     5 0   17 17   81
1151023 1151023 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004457 489 HAZEL PARK PREPARATORY ACADEMY Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 8.0 46.0 22.0   0.0 39.0     0.0   2.0   64.0 53.0     44.0   6.0         16.0   117.0 8 46 22   0 39     0   2   64 53     44 6     16   117
1151046 1151046 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001594 494 CAPITOL HILL MAGNET/RONDO Elementary School (Grades PK-6) Regular School No 1 01 08 2015   grade_7 83.0 60.0 15.0   1.0 58.0     0.0   3.0   120.0 100.0     33.0   0.0     109.0   7.0   220.0 83 60 15   1 58     0   3   120 100     33 0   109 7   220
1151092 1151092 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001612 528 LINWOOD MONROE ARTS PLUS UPPER Elementary School (Grades PK-6) Regular School No 2 04 08 2015   grade_7 31.0 44.0 21.0   2.0 19.0     0.0   4.0   56.0 65.0     35.0   5.0     93.0   21.0   121.0 31 44 21   2 19     0   4   56 65     35 5   93 21   121
1151165 1151165 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002303 579 AMERICAN INDIAN MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 3.0 13.0 16.0   6.0 21.0     0.0   3.0   29.0 33.0     30.0   1.0         13.0   62.0 3 13 16   6 21     0   3   29 33     30 1     13   62
1151677 1151677 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351001485 25 KENNEDY COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 46.0 4.0 1.0   1.0 1.0     0.0   1.0   30.0 24.0     0.0   0.0     20.0   13.0   54.0 46 4 1   1 1     0   1   30 24     0 0   20 13   54
1152950 1152950 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools PIPESTONE AREA SCHOOL DISTRICT 270010803015 6 HEARTLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 08 2015   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0         *         *   3.0 3 0 0   0 0     0   0   1 2                 3
1153208 1153208 MN Lesueur 40 school 2700379 2905 Independent Districts and Schools TRI-CITY UNITED SCHOOL DISTRICT 270037904626 10 LE CENTER PRE K-8 Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 31.0 1.0 16.0   0.0 0.0     0.0   0.0   26.0 22.0     11.0   1.0     26.0   3.0   48.0 31 1 16   0 0     0   0   26 22     11 1   26 3   48
1153219 1153219 MN Lesueur 40 school 2700379 2905 Independent Districts and Schools TRI-CITY UNITED SCHOOL DISTRICT 270037904625 30 MONTGOMERY PRE K-8 Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 91.0 0.0 7.0   1.0 1.0     1.0   1.0   57.0 45.0     4.0   2.0     39.0   14.0   102.0 91 0 7   1 1     1   1   57 45     4 2   39 14   102
1153284 1153284 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000942 106 BARTON OPEN ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 08 2015   grade_7 50.0 23.0 1.0   0.0 6.0     0.0   0.0   40.0 40.0     13.0   0.0     27.0   7.0   80.0 50 23 1   0 6     0   0   40 40     13 0   27 7   80
1153304 1153304 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000969 121 LAKE HARRIET UPPER SCHOOL Elementary School (Grades PK-6) Regular School No 2 04 08 2015   grade_7 90.0 9.0 1.0   1.0 7.0     0.0   0.0   47.0 61.0     2.0   0.0     12.0   10.0   108.0 90 9 1   1 7     0   0   47 61     2 0   12 10   108
1153326 1153326 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000988 134 LK NOKOMIS COMM-KEEWAYDIN CAMPUS Elementary School (Grades PK-6) Regular School No 1 03 08 2015   grade_7 27.0 16.0 12.0   3.0 0.0     0.0   0.0   30.0 28.0     7.0   6.0     34.0   12.0   58.0 27 16 12   3 0     0   0   30 28     7 6   34 12   58
1153396 1153396 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001031 160 SEWARD ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 08 2015   grade_7 39.0 38.0 6.0   4.0 3.0     0.0   0.0   43.0 47.0     24.0   1.0     49.0   6.0   90.0 39 38 6   4 3     0   0   43 47     24 1   49 6   90
1153435 1153435 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001866 175 FOLWELL ARTS MAGNET Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 6.0 22.0 59.0   2.0 3.0     0.0   0.0   46.0 46.0     44.0   *         9.0   92.0 6 22 59   2 3     0   0   46 46     44       9   92
1153446 1153446 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000986 179 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 4.0 18.0 30.0   1.0 3.0     1.0   0.0   27.0 30.0         2.0         9.0   57.0 4 18 30   1 3     1   0   27 30       2     9   57
1153464 1153464 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000932 190 ANDERSEN COMMUNITY Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 5.0 43.0 66.0   7.0 2.0     0.0   0.0   76.0 47.0     80.0   16.0         34.0   123.0 5 43 66   7 2     0   0   76 47     80 16     34   123
1153475 1153475 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124002297 193 SULLIVAN ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 4.0 37.0 4.0   7.0 0.0     0.0   1.0   33.0 20.0     30.0   3.0         13.0   53.0 4 37 4   7 0     0   1   33 20     30 3     13   53
1153493 1153493 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124004172 225 ANISHINABE ACADEMY Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 0.0 5.0 0.0   25.0 0.0     0.0   0.0   15.0 15.0     0.0   5.0         7.0   30.0 0 5 0   25 0     0   0   15 15     0 5     7   30
1153503 1153503 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124002144 226 MARCY OPEN ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 08 2015   grade_7 27.0 21.0 5.0   3.0 4.0     0.0   0.0   25.0 35.0     7.0   1.0     32.0   10.0   60.0 27 21 5   3 4     0   0   25 35     7 1   32 10   60
1153521 1153521 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001879 256 GREEN CENTRAL PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 4.0 13.0 39.0   2.0 2.0     0.0   0.0   30.0 30.0     30.0   6.0         15.0   60.0 4 13 39   2 2     0   0   30 30     30 6     15   60
1153539 1153539 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124002476 282 LUCY LANEY @ CLEVELAND PARK ELEM. Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 0.0 52.0 1.0   1.0 2.0     0.0   0.0   25.0 31.0     2.0   9.0         22.0   56.0 0 52 1   1 2     0   0   25 31     2 9     22   56
1153558 1153558 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124002699 288 NELLIE STONE JOHNSON ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 3.0 57.0 20.0   3.0 3.0     0.0   0.0   45.0 41.0         8.0         34.0   86.0 3 57 20   3 3     0   0   45 41       8     34   86
1153576 1153576 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124004239 291 HMONG INTERNATIONAL ACADEMY Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 0.0 12.0 1.0   1.0 33.0     0.0   0.0   20.0 27.0     18.0   1.0         11.0   47.0 0 12 1   1 33     0   0   20 27     18 1     11   47
1153610 1153610 MN Winona 85 school 2705850 4001 Charter Schools BLUFFVIEW MONTESSORI 270585000018 10 BLUFFVIEW MONTESSORI Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 14.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 6.0     0.0   0.0     2.0   0.0   14.0 14 0 0   0 0     0   0   8 6     0 0   2 0   14
1153620 1153620 MN Hennepin 27 school 2700027 4004 Charter Schools CEDAR RIVERSIDE COMMUNITY SCHOOL 270002702340 10 CEDAR RIVERSIDE COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 1.0 11.0 0.0   0.0 0.0     0.0   1.0   6.0 7.0     4.0   0.0         1.0   13.0 1 11 0   0 0     0   1   6 7     4 0     1   13
1153646 1153646 MN Hennepin 27 school 2700096 4011 Charter Schools Athlos Leadership Academy 270009601892 10 Athlos Leadership Academy Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2015   grade_7 36.0 32.0 6.0   0.0 2.0     0.0   5.0   43.0 38.0     12.0   2.0     45.0   14.0   81.0 36 32 6   0 2     0   5   43 38     12 2   45 14   81
1153656 1153656 MN Ramsey 62 school 2700115 4015 Charter Schools COMMUNITY OF PEACE ACADEMY 270011502605 10 COMMUNITY OF PEACE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 3.0 18.0 18.0   1.0 33.0     0.0   2.0   33.0 42.0     12.0   2.0         8.0   75.0 3 18 18   1 33     0   2   33 42     12 2     8   75
1153665 1153665 MN Carver 10 school 2700116 4016 Charter Schools WORLD LEARNER CHARTER SCHOOL 270011602606 10 WORLD LEARNER CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 01 08 2015   grade_7 24.0 1.0 0.0   0.0 0.0     0.0   0.0   13.0 12.0     0.0   0.0     4.0   7.0   25.0 24 1 0   0 0     0   0   13 12     0 0   4 7   25
1153682 1153682 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703566 17 Banaadir Academy Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 31.0 0.0   0.0 0.0     0.0   0.0   13.0 18.0     24.0   0.0         *   31.0 0 31 0   0 0     0   0   13 18     24 0         31
1153692 1153692 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2015   grade_7 7.0 5.0 14.0   0.0 22.0     0.0   0.0   26.0 22.0     25.0   0.0     36.0   6.0   48.0 7 5 14   0 22     0   0   26 22     25 0   36 6   48
1153702 1153702 MN Saint Louis 69 school 2700133 4020 Charter Schools DULUTH PUBLIC SCHOOLS ACADEMY 270013302711 10 NORTH STAR ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 111.0 5.0 3.0   5.0 3.0     0.0   13.0   74.0 66.0     1.0   0.0     46.0   24.0   140.0 111 5 3   5 3     0   13   74 66     1 0   46 24   140
1153719 1153719 MN Ramsey 62 school 2700140 4027 Charter Schools HIGHER GROUND ACADEMY 270014002719 10 HIGHER GROUND ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 72.0 0.0   0.0 0.0     0.0   0.0   40.0 32.0     10.0   0.0         2.0   72.0 0 72 0   0 0     0   0   40 32     10 0     2   72
1153736 1153736 MN Hennepin 27 school 2700151 4030 Charter Schools ODYSSEY ACADEMY 270015102946 10 ODYSSEY ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 4.0 17.0 2.0   0.0 1.0     0.0   1.0   15.0 10.0     3.0   0.0     21.0   6.0   25.0 4 17 2   0 1     0   1   15 10     3 0   21 6   25
1153760 1153760 MN Hennepin 27 school 2700159 4038 Charter Schools SOJOURNER TRUTH ACADEMY 270015902954 10 SOJOURNER TRUTH ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 1.0 31.0 15.0   0.0 0.0     0.0   2.0   22.0 27.0     10.0   1.0         8.0   49.0 1 31 15   0 0     0   2   22 27     10 1     8   49
1153770 1153770 MN Nicollet 52 school 2700174 4050 Charter Schools LAFAYETTE PUBLIC CHARTER SCHOOL 270017403042 10 LAFAYETTE PUBLIC CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 5.0 0.0 1.0   0.0 0.0     0.0   1.0   4.0 3.0         *         *   7.0 5 0 1   0 0     0   1   4 3                 7
1153777 1153777 MN Nicollet 52 school 2700174 4050 Charter Schools LAFAYETTE PUBLIC CHARTER SCHOOL 270017404126 20 STARLAND ELEMENTARY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 4.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 2.0         *         *   4.0 4 0 0   0 0     0   0   2 2                 4
1153811 1153811 MN Crow Wing 18 school 2700218 4059 Charter Schools CROSSLAKE COMMUNITY CHARTER SCHOOL 270021803475 10 CROSSLAKE COMMUNITY CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 16.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 9.0     0.0   0.0     6.0   2.0   16.0 16 0 0   0 0     0   0   7 9     0 0   6 2   16
1153835 1153835 MN Hennepin 27 school 2700184 4068 Charter Schools EXCELL ACADEMY CHARTER 270018403137 10 EXCELL ACADEMY CHARTER Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2015   grade_7 0.0 21.0 0.0   0.0 0.0     0.0   0.0   6.0 15.0     6.0   1.0         4.0   21.0 0 21 0   0 0     0   0   6 15     6 1     4   21
1153845 1153845 MN Ramsey 62 school 2700230 4070 Charter Schools HOPE COMMUNITY ACADEMY 270023003482 10 HOPE COMMUNITY ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 1.0 2.0 0.0   0.0 37.0     0.0   0.0   24.0 16.0     16.0   0.0     35.0   7.0   40.0 1 2 0   0 37     0   0   24 16     16 0   35 7   40
1153892 1153892 MN Hennepin 27 school 2700210 4086 Charter Schools WOODSON INSTITUTE FOR EXCELLENCE CH 270021003271 10 WOODSON INSTITUTE FOR EXCELLENCE CH Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 21.0 0.0   0.0 0.0     0.0   0.0   11.0 10.0     0.0   2.0         6.0   21.0 0 21 0   0 0     0   0   11 10     0 2     6   21
1153911 1153911 MN Hennepin 27 school 2700354 4089 Charter Schools NEW CITY SCHOOL 270035404849 20 New City School - East Campus Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 9.0 3.0 1.0   0.0 1.0     0.0   1.0   9.0 6.0     1.0   0.0     8.0   2.0   15.0 9 3 1   0 1     0   1   9 6     1 0   8 2   15
1153942 1153942 MN Cook 16 school 2700339 4100 Charter Schools GREAT EXPECTATIONS 270033904177 10 GREAT EXPECTATIONS Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 10.0 0.0 1.0   0.0 0.0     0.0   0.0   7.0 4.0     0.0   0.0     3.0   2.0   11.0 10 0 1   0 0     0   0   7 4     0 0   3 2   11
1153952 1153952 MN Ramsey 62 school 2700342 4103 Charter Schools HMONG COLLEGE PREP ACADEMY 270034203700 20 HMONG COLLEGE PREP MIDDLE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 1.0 0.0   0.0 94.0     0.0   0.0   52.0 43.0     43.0   2.0     83.0   12.0   95.0 0 1 0   0 94     0   0   52 43     43 2   83 12   95
1154005 1154005 MN Hennepin 27 school 2700366 4124 Charter Schools BEACON ACADEMY 270036604110 10 BEACON ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 29.0 4.0 5.0   0.0 1.0     0.0   4.0   19.0 24.0     1.0   0.0     11.0   11.0   43.0 29 4 5   0 1     0   4   19 24     1 0   11 11   43
1154030 1154030 MN Olmsted 55 school 2700247 4135 Charter Schools ROCHESTER MATH AND SCIENCE ACADEMY 270024703308 10 ROCHESTER MATH AND SCIENCE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 27.0 0.0   0.0 0.0     0.0   0.0   12.0 15.0     22.0   0.0         0.0   27.0 0 27 0   0 0     0   0   12 15     22 0     0   27
1154054 1154054 MN Hennepin 27 school 2700273 4139 Charter Schools LOVEWORKS ACADEMY FOR ARTS 270027303575 10 LOVEWORKS ACADEMY FOR ARTS Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 21.0 0.0   0.0 0.0     0.0   0.0   10.0 11.0     0.0   0.0         7.0   21.0 0 21 0   0 0     0   0   10 11     0 0     7   21
1154064 1154064 MN Hennepin 27 school 2700281 4140 Charter Schools YINGHUA ACADEMY 270028103611 10 YINGHUA ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 11.0 0.0 0.0   1.0 13.0     0.0   0.0   11.0 14.0     0.0   0.0     4.0   5.0   25.0 11 0 0   1 13     0   0   11 14     0 0   4 5   25
1154074 1154074 MN Dakota 19 school 2700251 4141 Charter Schools PAIDEIA ACADEMY CHARTER SCHOOL 270025103576 10 PAIDEIA ACADEMY CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 20.0 3.0 0.0   0.0 2.0     0.0   4.0   11.0 18.0     0.0   0.0     6.0   7.0   29.0 20 3 0   0 2     0   4   11 18     0 0   6 7   29
1154089 1154089 MN Hennepin 27 school 2700253 4143 Charter Schools NEW MILLENNIUM ACADEMY CHARTER SCH 270025303311 10 New Millenium Academy Charter School Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 1.0 0.0   1.0 33.0     0.0   0.0   19.0 16.0     30.0   0.0         9.0   35.0 0 1 0   1 33     0   0   19 16     30 0     9   35
1154114 1154114 MN Ramsey 62 school 2700262 4152 Charter Schools Twin Cities German Immersion Charter School 270026203578 10 Twin Cities German Immersion Charter School Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 25.0 0.0 0.0   0.0 0.0     0.0   2.0   8.0 19.0     1.0   0.0     2.0   5.0   27.0 25 0 0   0 0     0   2   8 19     1 0   2 5   27
1154124 1154124 MN Ramsey 62 school 2700263 4153 Charter Schools DUGSI ACADEMY 270026303320 10 DUGSI ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 24.0 0.0   0.0 0.0     0.0   0.0   13.0 11.0     12.0   0.0         1.0   24.0 0 24 0   0 0     0   0   13 11     12 0     1   24
1154157 1154157 MN Hennepin 27 school 2700278 4162 Charter Schools SOUTHSIDE FAMILY CHARTER SCHOOL 270027803617 10 SOUTHSIDE FAMILY CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 3.0 2.0 3.0   0.0 0.0     0.0   2.0   2.0 8.0     0.0   0.0     6.0   4.0   10.0 3 2 3   0 0     0   2   2 8     0 0   6 4   10
1154200 1154200 MN Hennepin 27 school 2700295 4171 Charter Schools NOBLE ACADEMY 270029503727 10 NOBLE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 5.0 1.0   0.0 32.0     0.0   0.0   22.0 16.0     32.0   1.0     30.0   3.0   38.0 0 5 1   0 32     0   0   22 16     32 1   30 3   38
1154218 1154218 MN Ramsey 62 school 2700304 4181 Charter Schools COMMUNITY SCHOOL OF EXCELLENCE 270030403728 10 COMMUNITY SCHOOL OF EXCELLENCE Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 1.0 0.0 0.0   0.0 92.0     0.0   1.0   57.0 37.0     64.0   0.0         16.0   94.0 1 0 0   0 92     0   1   57 37     64 0     16   94
1154228 1154228 MN Scott 70 school 2700311 4184 Charter Schools ASPEN ACADEMY 270031104282 10 ASPEN ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 46.0 4.0 1.0   0.0 1.0     0.0   1.0   26.0 27.0     8.0   0.0     13.0   2.0   53.0 46 4 1   0 1     0   1   26 27     8 0   13 2   53
1154238 1154238 MN Anoka 2 school 2700320 4185 Charter Schools DAVINCI ACADEMY 270032004268 10 DAVINCI ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 31.0 4.0 1.0   1.0 4.0     0.0   0.0   21.0 20.0     0.0   0.0     8.0   4.0   41.0 31 4 1   1 4     0   0   21 20     0 0   8 4   41
1154248 1154248 MN Anoka 2 school 2700313 4186 Charter Schools GLOBAL ACADEMY 270031304294 10 GLOBAL ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 14.0 35.0 0.0   0.0 0.0     0.0   0.0   24.0 25.0     13.0   0.0         5.0   49.0 14 35 0   0 0     0   0   24 25     13 0     5   49
1154265 1154265 MN Carver 10 school 2700319 4188 Charter Schools COLOGNE ACADEMY 270031904320 10 COLOGNE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 20.0 0.0 1.0   0.0 0.0     0.0   0.0   9.0 12.0     0.0   0.0     2.0   3.0   21.0 20 0 1   0 0     0   0   9 12     0 0   2 3   21
1154283 1154283 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904261 10 BEST ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 78.0 0.0   0.0 0.0     0.0   0.0   42.0 36.0     3.0   0.0         7.0   78.0 0 78 0   0 0     0   0   42 36     3 0     7   78
1154301 1154301 MN Rice 66 school 2700324 4194 Charter Schools CANNON RIVER STEM SCHOOL 270032404271 10 CANNON RIVER STEM SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 12.0 1.0 3.0   0.0 0.0     0.0   0.0   7.0 9.0     0.0   1.0     5.0   1.0   16.0 12 1 3   0 0     0   0   7 9     0 1   5 1   16
1154346 1154346 MN Hennepin 27 school 2700378 4208 Charter Schools NASHA SHKOLA CHARTER SCHOOL 270037804635 10 NASHA SHKOLA CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 10.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 7.0         0.0     7.0   1.0   10.0 10 0 0   0 0     0   0   3 7       0   7 1   10
1154447 1154447 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951004527 19 ACHIEVE Public Area Learning Program ALP (State approved) Alternative Education School No 2 06 08 2015   grade_7 2.0 6.0 3.0   0.0 0.0     0.0   2.0   8.0 5.0     2.0   2.0         6.0   13.0 2 6 3   0 0     0   2   8 5     2 2     6   13
1154451 1154451 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444003269 171 BEMIDJI MIDDLE ALP Public Area Learning Program ALP (State approved) Alternative Education School No 2 06 08 2015   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 1 0 0   0 0     0   0   0 1                 1
1154558 1154558 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 16.0 0.0 1.0   3.0 0.0     0.0   0.0   9.0 11.0     0.0   0.0     11.0   4.0   20.0 16 0 1   3 0     0   0   9 11     0 0   11 4   20
1154562 1154562 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 ANOKA MIDDLE SCHOOL FOR THE ARTS Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 491.0 45.0 23.0   9.0 23.0     0.0   9.0   267.0 333.0     14.0   7.0     209.0   95.0   600.0 491 45 23   9 23     0   9   267 333     14 7   209 95   600
1154566 1154566 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 COON RAPIDS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 270.0 51.0 27.0   7.0 19.0     0.0   9.0   197.0 186.0     18.0   8.0     183.0   53.0   383.0 270 51 27   7 19     0   9   197 186     18 8   183 53   383
1154570 1154570 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 JACKSON MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 392.0 108.0 32.0   7.0 89.0     0.0   11.0   316.0 323.0     46.0   4.0     221.0   91.0   639.0 392 108 32   7 89     0   11   316 323     46 4   221 91   639
1154574 1154574 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 NORTHDALE MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 279.0 52.0 21.0   9.0 29.0     0.0   11.0   198.0 203.0     18.0   9.0     173.0   49.0   401.0 279 52 21   9 29     0   11   198 203     18 9   173 49   401
1154578 1154578 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 OAK VIEW MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 381.0 13.0 12.0   4.0 13.0     0.0   4.0   237.0 190.0     2.0   1.0     67.0   *   427.0 381 13 12   4 13     0   4   237 190     2 1   67     427
1154582 1154582 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 306.0 25.0 8.0   1.0 26.0     1.0   7.0   188.0 186.0     8.0   2.0     86.0   *   374.0 306 25 8   1 26     1   7   188 186     8 2   86     374
1154586 1154586 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810002784 166 CENTENNIAL MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 421.0 14.0 23.0   8.0 30.0     0.0   17.0   269.0 244.0     8.0   2.0     103.0   84.0   513.0 421 14 23   8 30     0   17   269 244     8 2   103 84   513
1154590 1154590 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000395 17 COLUMBIA ACADEMY Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 62.0 72.0 72.0   2.0 12.0     0.0   7.0   110.0 117.0     33.0   5.0         35.0   227.0 62 72 72   2 12     0   7   110 117     33 5     35   227
1154595 1154595 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000610 23 FRIDLEY MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 97.0 58.0 32.0   7.0 20.0     0.0   11.0   125.0 100.0     29.0   2.0     151.0   35.0   225.0 97 58 32   7 20     0   11   125 100     29 2   151 35   225
1154599 1154599 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000013 123 ST. FRANCIS MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 335.0 0.0 7.0   2.0 8.0     0.0   8.0   184.0 176.0         *         *   360.0 335 0 7   2 8     0   8   184 176                 360
1154603 1154603 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001466 92 WESTWOOD MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 247.0 41.0 34.0   1.0 32.0     1.0   17.0   185.0 188.0         0.0         *   373.0 247 41 34   1 32     1   17   185 188       0         373
1154608 1154608 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023000443 4 DETROIT LAKES MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 179.0 2.0 2.0   27.0 3.0     0.0   8.0   116.0 105.0         *         *   221.0 179 2 2   27 3     0   8   116 105                 221
1154612 1154612 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444002031 15 BEMIDJI MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 268.0 5.0 9.0   54.0 3.0     2.0   8.0   179.0 170.0     3.0   3.0     163.0   61.0   349.0 268 5 9   54 3     2   8   179 170     3 3   163 61   349
1154616 1154616 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051002427 40 Red Lake Middle School Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 0.0 0.0 0.0   60.0 0.0     0.0   0.0   31.0 29.0     0.0   *         11.0   60.0 0 0 0   60 0     0   0   31 29     0       11   60
1154620 1154620 MN Benton 5 school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288002246 9 SAUK RAPIDS-RICE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 287.0 9.0 8.0   5.0 8.0     0.0   11.0   154.0 174.0     4.0   3.0     107.0   63.0   328.0 287 9 8   5 8     0   11   154 174     4 3   107 63   328
1154624 1154624 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942000381 201 CLOQUET MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 134.0 1.0 2.0   26.0 2.0     0.0   22.0   92.0 95.0         3.0     78.0   *   187.0 134 1 2   26 2     0   22   92 95       3   78     187
1154628 1154628 MN Carver 10 school 2723910 108 Independent Districts and Schools CENTRAL PUBLIC SCHOOL DISTRICT 272391002507 30 CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 70.0 1.0 3.0   1.0 0.0     0.0   0.0   38.0 37.0     1.0   0.0     19.0   11.0   75.0 70 1 3   1 0     0   0   38 37     1 0   19 11   75
1154633 1154633 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146003066 220 CLEARWATER MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 283.0 3.0 9.0   1.0 1.0     0.0   8.0   155.0 150.0     2.0   1.0     37.0   29.0   305.0 283 3 9   1 1     0   8   155 150     2 1   37 29   305
1154637 1154637 MN Carver 10 school 2741910 111 Independent Districts and Schools WATERTOWN-MAYER PUBLIC SCHOOL DIST. 274191000024 841 WATERTOWN-MAYER MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 126.0 1.0 2.0   0.0 4.0     0.0   5.0   67.0 71.0     3.0   0.0     28.0   13.0   138.0 126 1 2   0 4     0   5   67 71     3 0   28 13   138
1154641 1154641 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000345 61 CHASKA MIDDLE SCHOOL EAST Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 161.0 3.0 23.0   0.0 8.0     1.0   5.0   104.0 97.0     7.0   1.0     35.0   18.0   201.0 161 3 23   0 8     1   5   104 97     7 1   35 18   201
1154645 1154645 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819002798 62 CHASKA MIDDLE SCHOOL WEST Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 205.0 6.0 18.0   0.0 13.0     0.0   6.0   133.0 115.0     8.0   0.0     43.0   31.0   248.0 205 6 18   0 13     0   6   133 115     8 0   43 31   248
1154649 1154649 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819003180 63 PIONEER RIDGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 156.0 3.0 21.0   0.0 8.0     0.0   3.0   93.0 98.0     8.0   0.0     42.0   16.0   191.0 156 3 21   0 8     0   3   93 98     8 0   42 16   191
1154654 1154654 MN Cass 11 school 2708070 115 Independent Districts and Schools CASS LAKE-BENA PUBLIC SCHOOLS 270807003181 20 CASS LAKE-BENA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 3.0 0.0 0.0   73.0 0.0     0.0   2.0   46.0 32.0         *         *   78.0 3 0 0   73 0     0   2   46 32                 78
1154658 1154658 MN Cass 11 school 2728350 116 Independent Districts and Schools PILLAGER PUBLIC SCHOOL DISTRICT 272835004841 40 Pillager Middle School Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 77.0 0.0 0.0   2.0 0.0     0.0   1.0   44.0 36.0     0.0   0.0     32.0   12.0   80.0 77 0 0   2 0     0   1   44 36     0 0   32 12   80
1154668 1154668 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382001164 20 NORTH BRANCH MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 224.0 3.0 3.0   1.0 3.0     0.0   0.0   122.0 112.0         *         *   234.0 224 3 3   1 3     0   0   122 112                 234

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