Data source: Big Local News · About: Big Local

2,304 rows where grade = "pk_12_total", state = "MN" and year = 2019 sorted by district

View and edit SQL

year

  • 2019 · 2,304

grade

  • pk_12_total · 2,304
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
1945495 MN Meeker 47 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602570 300 A.C.G.C. SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   pk_12_total 341.0 0.0 29.0   3.0 0.0     0.0   6.0   205.0 174.0     6.0   0.0     152.0   68.0   379.0 341 0 29   3 0     0   6   205 174     6 0   152 68   379
1951345 MN Kandiyohi 34 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602568 100 A.C.G.C. ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   pk_12_total 281.0 2.0 23.0   2.0 1.0     0.0   6.0   160.0 155.0     5.0   0.0     153.0   71.0   315.0 281 2 23   2 1     0   6   160 155     5 0   153 71   315
1951348 MN Meeker 47 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010603647 150 ACGC ELEMENTARY GRADES 5 AND 6 Elementary School (Grades PK-6) Regular School No Middle 05 06 2019   pk_12_total 109.0 1.0 11.0   0.0 0.0     0.0   2.0   61.0 62.0     2.0   0.0     55.0   27.0   123.0 109 1 11   0 0     0   2   61 62     2 0   55 27   123
1945808 MN Dakota 19 school 2700361 4119 Charter Schools ACADEMIC ARTS HIGH SCHOOL 270036104105 10 ACADEMIC ARTS HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 09 12 2019   pk_12_total 43.0 7.0 31.0   6.0 0.0     0.0   3.0   41.0 49.0     0.0   4.0     34.0   32.0   90.0 43 7 31   6 0     0   3   41 49     0 4   34 32   90
1952203 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   pk_12_total 42.0 60.0 184.0   1.0 144.0     3.0   18.0   214.0 238.0     182.0   9.0     371.0   43.0   452.0 42 60 184   1 144     3   18   214 238     182 9   371 43   452
1945582 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600051 30 ADA-BORUP SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   pk_12_total 320.0 3.0 43.0   6.0 2.0     0.0   24.0   206.0 192.0     2.0   4.0     174.0   75.0   398.0 320 3 43   6 2     0   24   206 192     2 4   174 75   398
1951541 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600050 10 ADA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pk_12_total 241.0 0.0 38.0   3.0 0.0     0.0   29.0   160.0 151.0     7.0   3.0     169.0   61.0   311.0 241 0 38   3 0     0   29   160 151     7 3   169 61   311
1944890 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273000056 20 ADRIAN SECONDARY Secondary School (Grades 7-12) Regular School No High 09 12 2019   pk_12_total 144.0 1.0 30.0   1.0 6.0     0.0   4.0   89.0 97.0     13.0   0.0     71.0   18.0   186.0 144 1 30   1 6     0   4   89 97     13 0   71 18   186
1948730 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273000055 10 ADRIAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 209.0 0.0 27.0   1.0 4.0     0.0   13.0   125.0 129.0     15.0   0.0     97.0   47.0   254.0 209 0 27   1 4     0   13   125 129     15 0   97 47   254
1953677 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273003076 15 ADRIAN MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   pk_12_total 112.0 1.0 13.0   0.0 5.0     0.0   3.0   70.0 64.0     4.0   0.0     63.0   23.0   134.0 112 1 13   0 5     0   3   70 64     4 0   63 23   134
1945757 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018603139 10 AFSA HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   pk_12_total 229.0 24.0 16.0   0.0 17.0     0.0   10.0   170.0 126.0     0.0   0.0     101.0   84.0   296.0 229 24 16   0 17     0   10   170 126     0 0   101 84   296
1954126 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018604854 20 AFSA Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 06 2019   pk_12_total 28.0 2.0 3.0   0.0 1.0     0.0   0.0   14.0 20.0     0.0   0.0     9.0   4.0   34.0 28 2 3   0 1     0   0   14 20     0 0   9 4   34
1944374 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000057 1 AITKIN SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2019   pk_12_total 520.0 4.0 8.0   3.0 0.0     0.0   22.0   279.0 278.0     *   *         *   557.0 520 4 8   3 0     0   22   279 278                 557
1945918 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000059 2 RIPPLESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pk_12_total 577.0 11.0 10.0   4.0 5.0     0.0   17.0   342.0 282.0     1.0   0.0     301.0   126.0   624.0 577 11 10   4 5     0   17   342 282     1 0   301 126   624
1953101 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276002789 6 AITKIN ALTERNATIVE LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 07 12 2019   pk_12_total 5.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 2.0     *   *         *   5.0 5 0 0   0 0     0   0   3 2                 5
1950277 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000062 10 ALBANY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 488.0 3.0 12.0   0.0 0.0     0.0   9.0   255.0 257.0     10.0   4.0     113.0   93.0   512.0 488 3 12   0 0     0   9   255 257     10 4   113 93   512
1950285 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000065 30 AVON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 318.0 0.0 3.0   0.0 0.0     0.0   2.0   170.0 153.0     0.0   4.0     68.0   66.0   323.0 318 0 3   0 0     0   2   170 153     0 4   68 66   323
1953879 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000063 50 Albany Area Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   pk_12_total 391.0 0.0 14.0   0.0 0.0     0.0   5.0   193.0 217.0     3.0   1.0     76.0   66.0   410.0 391 0 14   0 0     0   5   193 217     3 1   76 66   410
1954870 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000064 60 Albany Area High School Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 495.0 4.0 11.0   0.0 4.0     2.0   7.0   251.0 272.0     0.0   1.0     89.0   68.0   523.0 495 4 11   0 4     2   7   251 272     0 1   89 68   523
1947379 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000070 110 HALVERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 189.0 29.0 130.0   0.0 45.0     0.0   11.0   203.0 201.0     61.0   11.0     287.0   89.0   404.0 189 29 130   0 45     0   11   203 201     61 11   287 89   404
1947388 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000071 120 HAWTHORNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 288.0 13.0 103.0   4.0 33.0     0.0   19.0   241.0 219.0     56.0   5.0     288.0   75.0   460.0 288 13 103   4 33     0   19   241 219     56 5   288 75   460
1947395 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000074 130 LAKEVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 227.0 18.0 82.0   0.0 9.0     0.0   8.0   178.0 166.0     33.0   3.0     167.0   72.0   344.0 227 18 82   0 9     0   8   178 166     33 3   167 72   344
1947402 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000077 140 SIBLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 299.0 15.0 57.0   0.0 39.0     0.0   15.0   228.0 197.0     50.0   2.0     198.0   71.0   425.0 299 15 57   0 39     0   15   228 197     50 2   198 71   425
1953470 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 Middle 06 07 2019   pk_12_total 329.0 13.0 107.0   1.0 32.0     0.0   19.0   256.0 245.0     26.0   3.0     254.0   75.0   501.0 329 13 107   1 32     0   19   256 245     26 3   254 75   501
1954459 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000068 310 ALBERT LEA SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2019   pk_12_total 853.0 36.0 258.0   4.0 91.0     0.0   41.0   671.0 612.0     71.0   5.0     582.0   196.0   1283.0 853 36 258   4 91     0   41   671 612     71 5   582 196   1283
1955477 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297002228 350 Albert Lea Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2019   pk_12_total 58.0 3.0 26.0   0.0 1.0     0.0   2.0   51.0 39.0     5.0   7.0     57.0   21.0   90.0 58 3 26   0 1     0   2   51 39     5 7   57 21   90
1956078 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297003501 111 Brookside Early Childhood Special Education Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 51.0 5.0 18.0   0.0 12.0     0.0   2.0   65.0 23.0     0.0   0.0     34.0   *   88.0 51 5 18   0 12     0   2   65 23     0 0   34     88
1944586 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000080 1 ALDEN-CONGER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   pk_12_total 214.0 1.0 14.0   0.0 1.0     0.0   8.0   110.0 128.0     0.0   2.0     68.0   45.0   238.0 214 1 14   0 1     0   8   110 128     0 2   68 45   238
1947411 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pk_12_total 246.0 1.0 17.0   0.0 0.0     0.0   5.0   138.0 131.0     0.0   2.0     83.0   44.0   269.0 246 1 17   0 0     0   5   138 131     0 2   83 44   269
1947289 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000082 110 CARLOS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 118.0 0.0 4.0   0.0 0.0     0.0   2.0   59.0 65.0     0.0   0.0     35.0   19.0   124.0 118 0 4   0 0     0   2   59 65     0 0   35 19   124
1947296 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000084 120 GARFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 120.0 0.0 3.0   0.0 0.0     0.0   1.0   60.0 64.0     0.0   2.0     21.0   *   124.0 120 0 3   0 0     0   1   60 64     0 2   21     124
1947303 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000086 130 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 436.0 3.0 13.0   2.0 3.0     0.0   19.0   242.0 234.0     1.0   5.0     118.0   90.0   476.0 436 3 13   2 3     0   19   242 234     1 5   118 90   476
1947310 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000087 140 MILTONA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 137.0 0.0 0.0   0.0 0.0     0.0   6.0   77.0 66.0     0.0   4.0     38.0   19.0   143.0 137 0 0   0 0     0   6   77 66     0 4   38 19   143
1947317 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000088 150 WOODLAND ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 401.0 8.0 25.0   0.0 4.0     0.0   13.0   243.0 208.0     2.0   9.0     177.0   93.0   451.0 401 8 25   0 4     0   13   243 208     2 9   177 93   451
1947324 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306002229 160 VOYAGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 434.0 0.0 36.0   1.0 5.0     0.0   19.0   242.0 253.0     14.0   13.0     168.0   104.0   495.0 434 0 36   1 5     0   19   242 253     14 13   168 104   495
1947326 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306003516 170 EARLY EDUCATION CENTER Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 104.0 0.0 3.0   0.0 0.0     0.0   0.0   55.0 52.0     0.0   1.0     45.0   *   107.0 104 0 3   0 0     0   0   55 52     0 1   45     107
1953463 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000083 310 Discovery Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   pk_12_total 919.0 8.0 31.0   1.0 7.0     0.0   25.0   521.0 470.0     6.0   4.0     261.0   125.0   991.0 919 8 31   1 7     0   25   521 470     6 4   261 125   991
1954448 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000085 320 Alexandria Area High School Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 1179.0 12.0 38.0   6.0 20.0     0.0   25.0   670.0 610.0     5.0   3.0     307.0   197.0   1280.0 1179 12 38   6 20     0   25   670 610     5 3   307 197   1280
1950828 MN Wright 86 school 2703150 876 Independent Districts and Schools ANNANDALE PUBLIC SCHOOL DISTRICT 270315000094 1 ANNANDALE ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 864.0 10.0 24.0   0.0 4.0     1.0   47.0   486.0 464.0     8.0   5.0     268.0   195.0   950.0 864 10 24   0 4     1   47   486 464     8 5   268 195   950
1953942 MN Wright 86 school 2703150 876 Independent Districts and Schools ANNANDALE PUBLIC SCHOOL DISTRICT 270315000093 2 ANNANDALE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   pk_12_total 450.0 6.0 12.0   0.0 1.0     0.0   16.0   236.0 249.0     1.0   1.0     120.0   80.0   485.0 450 6 12   0 1     0   16   236 249     1 1   120 80   485
1954940 MN Wright 86 school 2703150 876 Independent Districts and Schools ANNANDALE PUBLIC SCHOOL DISTRICT 270315001825 3 ANNANDALE SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 500.0 6.0 10.0   1.0 2.0     1.0   19.0   275.0 264.0     2.0   4.0     105.0   80.0   539.0 500 6 10   1 2     1   19   275 264     2 4   105 80   539
1945773 MN Rice 66 school 2700355 4091 Charter Schools ARCADIA CHARTER SCHOOL 270035504151 10 ARCADIA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   pk_12_total 103.0 2.0 5.0   1.0 1.0     0.0   4.0   66.0 50.0     0.0   0.0     11.0   42.0   116.0 103 2 5   1 1     0   4   66 50     0 0   11 42   116
1944614 MN Grant 26 school 2703300 261 Independent Districts and Schools ASHBY PUBLIC SCHOOL DISTRICT 270330000137 20 ASHBY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   pk_12_total 113.0 2.0 5.0   0.0 0.0     0.0   0.0   63.0 57.0     2.0   2.0     36.0   13.0   120.0 113 2 5   0 0     0   0   63 57     2 2   36 13   120
1947452 MN Grant 26 school 2703300 261 Independent Districts and Schools ASHBY PUBLIC SCHOOL DISTRICT 270330000136 10 ASHBY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pk_12_total 169.0 0.0 3.0   0.0 0.0     0.0   1.0   89.0 84.0     1.0   4.0     73.0   27.0   173.0 169 0 3   0 0     0   1   89 84     1 4   73 27   173
1952731 MN Scott 70 school 2700311 4184 Charter Schools ASPEN ACADEMY 270031104282 10 ASPEN ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   pk_12_total 413.0 61.0 11.0   2.0 54.0     0.0   13.0   280.0 274.0     47.0   0.0     119.0   47.0   554.0 413 61 11   2 54     0   13   280 274     47 0   119 47   554
1955249 MN Hennepin 27 school 2700350 4111 Charter Schools AUGSBURG FAIRVIEW ACADEMY 270035004097 10 AUGSBURG FAIRVIEW ACADEMY Senior High School (Grades 9-12) Regular School Yes High 09 12 2019   pk_12_total 6.0 36.0 14.0   25.0 0.0     0.0   19.0   42.0 58.0     0.0   33.0     79.0   25.0   100.0 6 36 14   25 0     0   19   42 58     0 33   79 25   100
1952328 MN Hennepin 27 school 2700220 4067 Charter Schools AURORA CHARTER SCHOOL 270022003473 10 AURORA CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary PK 04 2019   pk_12_total 1.0 0.0 226.0   0.0 0.0     0.0   0.0   108.0 119.0     *   0.0         30.0   227.0 1 0 226   0 0     0   0   108 119       0     30   227
1954123 MN Hennepin 27 school 2700220 4067 Charter Schools AURORA CHARTER SCHOOL 270022004420 20 AURORA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   pk_12_total 0.0 0.0 183.0   1.0 0.0     0.0   0.0   84.0 100.0     *   0.0         23.0   184.0 0 0 183   1 0     0   0   84 100       0     23   184
1948644 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000149 10 BANFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2019   pk_12_total 238.0 45.0 99.0   0.0 34.0     4.0   17.0   232.0 205.0     107.0   1.0     229.0   68.0   437.0 238 45 99   0 34     4   17   232 205     107 1   229 68   437
1948649 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000153 40 NEVELN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2019   pk_12_total 161.0 16.0 99.0   0.0 31.0     5.0   10.0   151.0 171.0     85.0   0.0     207.0   52.0   322.0 161 16 99   0 31     5   10   151 171     85 0   207 52   322
1948654 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345002230 70 SOUTHGATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2019   pk_12_total 265.0 28.0 145.0   0.0 47.0     2.0   26.0   252.0 261.0     117.0   *     274.0   96.0   513.0 265 28 145   0 47     2   26   252 261     117     274 96   513
1948660 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000156 80 SUMNER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2019   pk_12_total 58.0 64.0 120.0   0.0 70.0     5.0   11.0   171.0 157.0     148.0   4.0     276.0   51.0   328.0 58 64 120   0 70     5   11   171 157     148 4   276 51   328
1948663 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345005043 105 CLC - Pre-Kindergarten Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 41.0 9.0 33.0   0.0 25.0     0.0   8.0   64.0 52.0     0.0   0.0     58.0   19.0   116.0 41 9 33   0 25     0   8   64 52     0 0   58 19   116
1948666 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000968 110 WOODSON KINDERGARTEN CENTER Elementary School (Grades PK-6) Regular School No Elementary PK KG 2019   pk_12_total 177.0 29.0 101.0   0.0 43.0     3.0   8.0   197.0 164.0     107.0   5.0     213.0   60.0   361.0 177 29 101   0 43     3   8   197 164     107 5   213 60   361
1948669 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345004638 280 I.J. HOLTON INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Middle 05 06 2019   pk_12_total 401.0 64.0 264.0   0.0 59.0     6.0   25.0   394.0 425.0     155.0   3.0     483.0   130.0   819.0 401 64 264   0 59     6   25   394 425     155 3   483 130   819
1953654 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000150 300 ELLIS MIDDLE Middle School (Grades 5-8) Regular School No Middle 07 08 2019   pk_12_total 347.0 54.0 210.0   0.0 45.0     7.0   28.0   341.0 350.0     91.0   1.0     396.0   116.0   691.0 347 54 210   0 45     7   28   341 350     91 1   396 116   691
1954634 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000148 200 AUSTIN SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 767.0 103.0 337.0   1.0 104.0     10.0   34.0   710.0 646.0     158.0   4.0     649.0   204.0   1356.0 767 103 337   1 104     10   34   710 646     158 4   649 204   1356
1955600 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345002231 150 AUSTIN AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2019   pk_12_total 67.0 12.0 70.0   1.0 12.0     2.0   6.0   90.0 80.0     21.0   2.0     103.0   5.0   170.0 67 12 70   1 12     2   6   90 80     21 2   103 5   170
1956160 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345003525 120 AUSTIN COMMUNITY LEARNING CENTER Special Education Special Education School No Other PK 12 2019   pk_12_total 33.0 9.0 31.0   0.0 11.0     0.0   6.0   57.0 33.0     0.0   *     45.0   *   90.0 33 9 31   0 11     0   6   57 33     0     45     90
1958139 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345003192 450 NEW DOMINION ACADEMY Educational Oversight to Private Residential Care & Treatment (State approved) Alternative School No Other KG 12 2019   pk_12_total 52.0 15.0 7.0   7.0 0.0     0.0   9.0   46.0 44.0     0.0   1.0     0.0   71.0   90.0 52 15 7   7 0     0   9   46 44     0 1   0 71   90
1954130 MN Ramsey 62 school 2700187 4075 Charter Schools AVALON SCHOOL 270018704664 20 Avalon Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2019   pk_12_total 49.0 2.0 11.0   3.0 0.0     0.0   8.0   48.0 25.0     1.0   3.0     24.0   29.0   73.0 49 2 11   3 0     0   8   48 25     1 3   24 29   73
1955180 MN Ramsey 62 school 2700187 4075 Charter Schools AVALON SCHOOL 270018703140 10 AVALON SCHOOL Senior High School (Grades 9-12) Regular School Yes High 09 12 2019   pk_12_total 120.0 8.0 13.0   10.0 3.0     0.0   12.0   87.0 79.0     0.0   4.0     40.0   63.0   166.0 120 8 13   10 3     0   12   87 79     0 4   40 63   166
1952361 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 Academia Cesar Chavez Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   pk_12_total 17.0 7.0 507.0   0.0 3.0     0.0   7.0   247.0 294.0     286.0   33.0     475.0   73.0   541.0 17 7 507   0 3     0   7   247 294     286 33   475 73   541
1952919 MN Hennepin 27 school 2700394 4220 Charter Schools Agamim Classical Academy 270039404751 10 Agamim Classical Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   pk_12_total 147.0 62.0 14.0   0.0 62.0     0.0   25.0   161.0 149.0     45.0   0.0     75.0   39.0   310.0 147 62 14   0 62     0   25   161 149     45 0   75 39   310
1945944 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 260.0 110.0 32.0   4.0 63.0     1.0   54.0   265.0 259.0     119.0   28.0     326.0   99.0   524.0 260 110 32   4 63     1   54   265 259     119 28   326 99   524
1945951 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000101 402 CROOKED LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 411.0 30.0 12.0   3.0 12.0     1.0   24.0   264.0 229.0     8.0   3.0     99.0   85.0   493.0 411 30 12   3 12     1   24   264 229     8 3   99 85   493
1945958 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000105 403 FRANKLIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 238.0 71.0 39.0   7.0 12.0     2.0   27.0   196.0 200.0     57.0   13.0     235.0   79.0   396.0 238 71 39   7 12     2   27   196 200     57 13   235 79   396
1945965 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000106 404 HAMILTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 233.0 76.0 49.0   9.0 44.0     1.0   36.0   255.0 193.0     89.0   7.0     291.0   89.0   448.0 233 76 49   9 44     1   36   255 193     89 7   291 89   448
1945972 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary - Biomedical, Health Sciences and Engineering Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 275.0 80.0 36.0   1.0 30.0     0.0   46.0   238.0 230.0     48.0   6.0     221.0   76.0   468.0 275 80 36   1 30     0   46   238 230     48 6   221 76   468
1945979 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000110 406 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 485.0 91.0 33.0   3.0 56.0     1.0   45.0   352.0 362.0     65.0   11.0     246.0   151.0   714.0 485 91 33   3 56     1   45   352 362     65 11   246 151   714
1945986 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000111 407 JOHNSVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 707.0 53.0 22.0   2.0 51.0     0.0   43.0   435.0 443.0     46.0   19.0     166.0   103.0   878.0 707 53 22   2 51     0   43   435 443     46 19   166 103   878
1945993 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000112 408 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 308.0 41.0 27.0   6.0 17.0     1.0   25.0   204.0 221.0     34.0   8.0     201.0   90.0   425.0 308 41 27   6 17     1   25   204 221     34 8   201 90   425
1946000 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000113 410 MADISON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 307.0 51.0 36.0   5.0 46.0     1.0   15.0   251.0 210.0     69.0   3.0     176.0   82.0   461.0 307 51 36   5 46     1   15   251 210     69 3   176 82   461
1946007 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 MCKINLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 626.0 9.0 9.0   3.0 30.0     0.0   26.0   372.0 331.0     17.0   7.0     112.0   75.0   703.0 626 9 9   3 30     0   26   372 331     17 7   112 75   703
1946014 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000115 412 MISSISSIPPI ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 267.0 51.0 21.0   2.0 26.0     1.0   42.0   213.0 197.0     34.0   11.0     202.0   82.0   410.0 267 51 21   2 26     1   42   213 197     34 11   202 82   410
1946021 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000116 413 MONROE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 185.0 157.0 41.0   5.0 172.0     0.0   47.0   325.0 282.0     152.0   10.0     280.0   106.0   607.0 185 157 41   5 172     0   47   325 282     152 10   280 106   607
1946028 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000118 414 MORRIS BYE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 235.0 46.0 27.0   3.0 27.0     0.0   29.0   177.0 190.0     40.0   18.0     153.0   70.0   367.0 235 46 27   3 27     0   29   177 190     40 18   153 70   367
1946035 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000123 417 SAND CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 483.0 109.0 29.0   3.0 63.0     3.0   52.0   380.0 362.0     75.0   9.0     241.0   129.0   742.0 483 109 29   3 63     3   52   380 362     75 9   241 129   742
1946043 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 UNIVERSITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 324.0 171.0 49.0   4.0 43.0     0.0   57.0   339.0 309.0     64.0   20.0     337.0   105.0   648.0 324 171 49   4 43     0   57   339 309     64 20   337 105   648
1946050 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000128 420 WILSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 459.0 73.0 36.0   2.0 19.0     0.0   49.0   320.0 318.0     65.0   6.0     259.0   111.0   638.0 459 73 36   2 19     0   49   320 318     65 6   259 111   638
1946058 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000104 421 EVERGREEN PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 34.0 170.0 79.0   0.0 160.0     0.0   42.0   248.0 237.0     194.0   11.0     366.0   82.0   485.0 34 170 79   0 160     0   42   248 237     194 11   366 82   485
1946065 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000103 422 EISENHOWER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 421.0 72.0 93.0   4.0 61.0     1.0   57.0   335.0 374.0     111.0   18.0     309.0   131.0   709.0 421 72 93   4 61     1   57   335 374     111 18   309 131   709
1946072 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000120 423 RAMSEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 935.0 107.0 43.0   7.0 46.0     0.0   52.0   636.0 554.0     93.0   8.0     351.0   188.0   1190.0 935 107 43   7 46     0   52   636 554     93 8   351 188   1190
1946079 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000102 424 DAYTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 349.0 30.0 75.0   2.0 14.0     1.0   26.0   229.0 268.0     60.0   3.0     127.0   82.0   497.0 349 30 75   2 14     1   26   229 268     60 3   127 82   497
1946086 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002193 425 OXBOW CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 799.0 117.0 41.0   3.0 92.0     4.0   90.0   564.0 582.0     80.0   4.0     236.0   150.0   1146.0 799 117 41   3 92     4   90   564 582     80 4   236 150   1146
1946093 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002203 426 ANDOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 1097.0 50.0 52.0   1.0 48.0     4.0   69.0   682.0 639.0     75.0   5.0     226.0   193.0   1321.0 1097 50 52   1 48     4   69   682 639     75 5   226 193   1321
1946100 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318003058 427 RUM RIVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 845.0 19.0 33.0   3.0 22.0     0.0   43.0   509.0 456.0     35.0   5.0     157.0   164.0   965.0 845 19 33   3 22     0   43   509 456     35 5   157 164   965
1946107 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318004406 430 CHAMPLIN/BROOKLYN PK ACD MATH ENSCI Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 545.0 120.0 38.0   3.0 74.0     1.0   76.0   449.0 408.0     80.0   8.0     282.0   125.0   857.0 545 120 38   3 74     1   76   449 408     80 8   282 125   857
1953232 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 Middle 06 08 2019   pk_12_total 1345.0 200.0 78.0   15.0 68.0     4.0   87.0   864.0 933.0     51.0   35.0     611.0   284.0   1797.0 1345 200 78   15 68     4   87   864 933     51 35   611 284   1797
1953236 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 Middle 06 08 2019   pk_12_total 717.0 215.0 111.0   16.0 81.0     1.0   81.0   645.0 577.0     67.0   45.0     646.0   187.0   1222.0 717 215 111   16 81     1   81   645 577     67 45   646 187   1222
1953240 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 Middle 06 08 2019   pk_12_total 1138.0 380.0 169.0   12.0 282.0     2.0   133.0   1057.0 1059.0     131.0   23.0     722.0   254.0   2116.0 1138 380 169   12 282     2   133   1057 1059     131 23   722 254   2116
1953244 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 Middle 06 08 2019   pk_12_total 766.0 185.0 122.0   7.0 120.0     0.0   78.0   689.0 589.0     81.0   25.0     558.0   234.0   1278.0 766 185 122   7 120     0   78   689 589     81 25   558 234   1278
1953248 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 Middle 06 08 2019   pk_12_total 1099.0 42.0 37.0   2.0 32.0     3.0   45.0   657.0 603.0     17.0   16.0     195.0   141.0   1260.0 1099 42 37   2 32     3   45   657 603     17 16   195 141   1260
1953252 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 Middle 06 08 2019   pk_12_total 982.0 100.0 55.0   6.0 92.0     1.0   43.0   660.0 619.0     21.0   19.0     279.0   159.0   1279.0 982 100 55   6 92     1   43   660 619     21 19   279 159   1279
1954219 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000096 1 Anoka High School Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 1805.0 197.0 107.0   20.0 103.0     0.0   55.0   1170.0 1117.0     55.0   38.0     625.0   292.0   2287.0 1805 197 107   20 103     0   55   1170 1117     55 38   625 292   2287
1954224 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000100 2 Coon Rapids High School Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 1335.0 372.0 155.0   28.0 169.0     0.0   94.0   1049.0 1104.0     94.0   48.0     945.0   266.0   2153.0 1335 372 155   28 169     0   94   1049 1104     94 48   945 266   2153
1954229 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000097 91 Blaine High School Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 2107.0 287.0 134.0   16.0 279.0     3.0   112.0   1525.0 1413.0     79.0   72.0     716.0   298.0   2938.0 2107 287 134   16 279     3   112   1525 1413     79 72   716 298   2938
1954234 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318003170 94 Andover High School Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 1502.0 53.0 56.0   11.0 57.0     1.0   29.0   870.0 839.0     13.0   16.0     211.0   125.0   1709.0 1502 53 56   11 57     1   29   870 839     13 16   211 125   1709
1954239 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000021 192 Champlin Park High School Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 1540.0 519.0 192.0   18.0 436.0     2.0   129.0   1466.0 1370.0     164.0   36.0     905.0   292.0   2836.0 1540 519 192   18 436     2   129   1466 1370     164 36   905 292   2836
1955322 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002029 110 Anoka-Hennepin Regional High School Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2019   pk_12_total 87.0 20.0 24.0   6.0 3.0     0.0   10.0   90.0 60.0     6.0   13.0     76.0   17.0   150.0 87 20 24   6 3     0   10   90 60     6 13   76 17   150

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