Data source: Big Local News · About: Big Local

2,294 rows where grade = "pk_12_total", state = "MN" and year = 2017 sorted by ccd_school_type

View and edit SQL

year

  • 2017 · 2,294

grade

  • pk_12_total · 2,294
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
697564 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 09 12 2017   pk_12_total 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 3 0 0   0 0     0   0   3 0                 3
697566 MN Aitkin 1 school 2719170 4 Independent Districts and Schools MCGREGOR PUBLIC SCHOOL DISTRICT 271917003432 30 MCGREGOR AREA LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 08 12 2017   pk_12_total 1.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 1 0 0   1 0     0   0   1 1                 2
697568 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000347 230 LIFE LINES ADULT CONNECTION Public Area Learning Program ALP (State approved) Alternative School No High 11 12 2017   pk_12_total 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
697573 MN Cass 11 school 2702910 113 Independent Districts and Schools WALKER-HACKENSACK-AKELEY SCHL. DIST 270291002428 25 W. H. A . ALTERNATIVE PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 8.0 0.0 0.0   7.0 0.0     0.0   1.0   13.0 3.0     0.0   0.0     10.0   0.0   16.0 8 0 0   7 0     0   1   13 3     0 0   10 0   16
697576 MN Clearwater 15 school 2703570 162 Independent Districts and Schools BAGLEY PUBLIC SCHOOL DISTRICT 270357004279 30 BAGLEY ALP Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 2 0 0   0 0     0   0   1 1                 2
697578 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002803 50 DAKOTA PRAIRIE AREA LEARNING CENTER Public Area Learning Program ALP (State approved) Alternative School No High 10 12 2017   pk_12_total 5.0 0.0 1.0   0.0 1.0     0.0   0.0   5.0 2.0         *         *   7.0 5 0 1   0 1     0   0   5 2                 7
697580 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002514 34 ABE Diploma Program Public Area Learning Program ALP (State approved) Alternative School No High 08 12 2017   pk_12_total 27.0 7.0 13.0   1.0 3.0     0.0   0.0   26.0 25.0     0.0   0.0         *   51.0 27 7 13   1 3     0   0   26 25     0 0         51
697583 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000538 226 SIMLEY ALTERNATIVE PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 10.0 4.0 9.0   0.0 0.0     0.0   3.0   16.0 10.0         0.0     17.0   2.0   26.0 10 4 9   0 0     0   3   16 10       0   17 2   26
697586 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579004531 620 Choice Alternative High School Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 43.0 33.0 20.0   1.0 3.0     0.0   6.0   56.0 50.0     1.0   3.0     26.0   5.0   106.0 43 33 20   1 3     0   6   56 50     1 3   26 5   106
697589 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579003518 629 Beacon ALP Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 2.0 0.0 3.0   0.0 1.0     0.0   1.0   5.0 2.0         *         *   7.0 2 0 3   0 1     0   1   5 2                 7
697591 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579004483 740 BEACON ALP IS Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 0 1 0   0 0     0   0   0 1                 1
697595 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175004395 820 Richfield College Experience Program Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 8.0 6.0 23.0   0.0 1.0     0.0   4.0   27.0 15.0     1.0   0.0     33.0   4.0   42.0 8 6 23   0 1     0   4   27 15     1 0   33 4   42
697599 MN Houston 28 school 2714280 294 Independent Districts and Schools HOUSTON PUBLIC SCHOOL DISTRICT 271428002993 7 SUMMIT LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 18.0 1.0 0.0   1.0 0.0     0.0   0.0   17.0 3.0     0.0   0.0     10.0   8.0   20.0 18 1 0   1 0     0   0   17 3     0 0   10 8   20
697603 MN Itasca 31 school 2723310 319 Independent Districts and Schools NASHWAUK-KEEWATIN SCHOOL DISTRICT 272331003702 70 NASHWAUK-KEEWATIN ALP Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 16.0 0.0 0.0   0.0 0.0     0.0   3.0   10.0 9.0     0.0   0.0     8.0   1.0   19.0 16 0 0   0 0     0   3   10 9     0 0   8 1   19
697606 MN Kandiyohi 34 school 2723400 345 Independent Districts and Schools NEW LONDON-SPICER SCHOOL DISTRICT 272340002766 31 NEW LONDON ALTERNATIVE SCHOOL Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 18.0 0.0 1.0   0.0 0.0     0.0   1.0   17.0 3.0     0.0   1.0     9.0   0.0   20.0 18 0 1   0 0     0   1   17 3     0 1   9 0   20
697609 MN Mahnomen 44 school 2742120 435 Independent Districts and Schools WAUBUN-OGEMA-WHITE EARTH PUBLIC SCH 274212003460 40 WAUBUN AREA LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 10 12 2017   pk_12_total 1.0 0.0 0.0   7.0 0.0     0.0   0.0   2.0 6.0         *         *   8.0 1 0 0   7 0     0   0   2 6                 8
697612 MN Meeker 47 school 2718210 465 Independent Districts and Schools LITCHFIELD PUBLIC SCHOOL DISTRICT 271821003075 50 LITCHFIELD AREA LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 10 12 2017   pk_12_total 9.0 0.0 1.0   0.0 0.0     0.0   0.0   6.0 4.0     0.0   0.0     4.0   0.0   10.0 9 0 1   0 0     0   0   6 4     0 0   4 0   10
697614 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001038 59 Mounds View Adult Education Public Area Learning Program ALP (State approved) Alternative School No High 12 12 2017   pk_12_total 5.0 1.0 3.0   0.0 0.0     0.0   1.0   7.0 3.0     0.0   0.0     3.0   0.0   10.0 5 1 3   0 0     0   1   7 3     0 0   3 0   10
697616 MN Roseau 68 school 2732250 682 Independent Districts and Schools ROSEAU PUBLIC SCHOOL DISTRICT 273225004520 60 ROSEAU DIST. AREA LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 07 12 2017   pk_12_total 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
697619 MN Saint Louis 69 school 2713920 700 Independent Districts and Schools HERMANTOWN PUBLIC SCHOOL DISTRICT 271392004370 35 Hermantown Alternative Learning Program Public Area Learning Program ALP (State approved) Alternative School No Other 05 12 2017   pk_12_total 11.0 0.0 0.0   0.0 0.0     0.0   1.0   7.0 5.0     0.0   0.0     4.0   1.0   12.0 11 0 0   0 0     0   1   7 5     0 0   4 1   12
697623 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387003533 50 BECKER ALTERNATIVE LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 20.0 0.0 0.0   0.0 0.0     0.0   0.0   16.0 4.0     0.0   0.0     4.0   1.0   20.0 20 0 0   0 0     0   0   16 4     0 0   4 1   20
697628 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001777 23 South Washington Alternative High School Public Area Learning Program ALP (State approved) Alternative School No High 08 12 2017   pk_12_total 64.0 7.0 17.0   1.0 0.0     0.0   8.0   48.0 49.0         2.0     43.0   *   97.0 64 7 17   1 0     0   8   48 49       2   43     97
697630 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001793 52 Access Public Area Learning Program ALP (State approved) Alternative School No High 10 12 2017   pk_12_total 7.0 0.0 2.0   0.0 0.0     0.0   1.0   5.0 5.0     0.0   0.0     0.0   0.0   10.0 7 0 2   0 0     0   1   5 5     0 0   0 0   10
697635 MN Wilkin 84 school 2706150 846 Independent Districts and Schools BRECKENRIDGE PUBLIC SCHOOL DISTRICT 270615004963 70 Breckenridge Area Learning Program Public Area Learning Program ALP (State approved) Alternative School No High 07 12 2017   pk_12_total 7.0 0.0 0.0   0.0 0.0     0.0   3.0   3.0 7.0     0.0   0.0     5.0   5.0   10.0 7 0 0   0 0     0   3   3 7     0 0   5 5   10
697639 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720002853 45 PHOENIX LEARNING CENTER Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 18.0 0.0 1.0   0.0 0.0     0.0   0.0   11.0 8.0     0.0   0.0     10.0   *   19.0 18 0 1   0 0     0   0   11 8     0 0   10     19
697643 MN Wright 86 school 2721390 882 Independent Districts and Schools MONTICELLO PUBLIC SCHOOL DISTRICT 272139001834 40 MONTICELLO ALTERNATIVE PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 22.0 0.0 0.0   0.0 0.0     0.0   1.0   12.0 11.0     0.0   1.0     12.0   *   23.0 22 0 0   0 0     0   1   12 11     0 1   12     23
697647 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379003105 50 KNIGHTS ACADEMY Public Area Learning Program ALP (State approved) Alternative School No High 10 12 2017   pk_12_total 22.0 2.0 1.0   0.0 0.0     0.0   0.0   19.0 6.0     0.0   1.0     6.0   7.0   25.0 22 2 1   0 0     0   0   19 6     0 1   6 7   25
697649 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001703889 14 CHISAGO LAKES HS ALT LEARNING PROG Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 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
697652 MN Saint Louis 69 school 2700021 2154 Independent Districts and Schools EVELETH-GILBERT SCHOOL DISTRICT 270002105010 80 Eveleth Gilbert HOPE Program Public Area Learning Program ALP (State approved) Alternative School No High 10 12 2017   pk_12_total 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 3 0 0   0 0     0   0   3 0                 3
697657 MN Pine 58 school 2714070 2165 Independent Districts and Schools HINCKLEY-FINLAYSON SCHOOL DISTRICT 271407004489 40 HINCKLEY-FINLAYSON ALTERNATIVE PROG Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 10.0 0.0 1.0   2.0 0.0     0.0   0.0   9.0 4.0     0.0   0.0         0.0   13.0 10 0 1   2 0     0   0   9 4     0 0     0   13
697662 MN Chippewa 12 school 2700091 2180 Independent Districts and Schools MACCRAY School District 270009102856 40 MACCRAY Area Learning Program Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 25.0 0.0 2.0   0.0 0.0     0.0   1.0   14.0 14.0     0.0   1.0     12.0   3.0   28.0 25 0 2   0 0     0   1   14 14     0 1   12 3   28
697665 MN Rock 67 school 2718330 2184 Independent Districts and Schools LUVERNE PUBLIC SCHOOL DISTRICT 271833012683 6 LUVERNE ALTERNATIVE PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 10 12 2017   pk_12_total 1.0 1.0 0.0   0.0 0.0     0.0   1.0   3.0 0.0         *         *   3.0 1 1 0   0 0     0   1   3 0                 3
697667 MN Lesueur 40 school 2718070 2397 Independent Districts and Schools LE SUEUR-HENDERSON SCHOOL DISTRICT 271807002695 30 AREA ADULT LEARNING COOPERATIVE Public Area Learning Program ALP (State approved) Alternative School No High 12 12 2017   pk_12_total 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
697671 MN Wright 86 school 2700123 2687 Independent Districts and Schools HOWARD LAKE-WAVERLY-WINSTED 270012304414 8 HLWW ALTERNATIVE LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 12.0 2.0 0.0   0.0 0.0     0.0   1.0   6.0 9.0     0.0   0.0     4.0   3.0   15.0 12 2 0   0 0     0   1   6 9     0 0   4 3   15
697673 MN Redwood 64 school 2700182 2897 Independent Districts and Schools REDWOOD AREA SCHOOL DISTRICT 270018202576 4 REDWOOD VALLEY ALTERNATIVE Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 0.0 0.0 0.0   1.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 0 0 0   1 0     0   0   0 1                 1
697678 MN Clay 14 school 2700083 926 Service Cooperative (ECSU Region) REGION 4-LAKES COUNTRY SERVICE COOP 270008302417 20 LAKES COUNTRY YOUTH EDUC SVCS Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 26.0 0.0 9.0   0.0 0.0     0.0   7.0   22.0 20.0     0.0   0.0     18.0   8.0   42.0 26 0 9   0 0     0   7   22 20     0 0   18 8   42
699731 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 2017   pk_12_total 91.0 32.0 16.0   6.0 3.0     0.0   8.0   85.0 71.0     2.0   17.0     83.0   12.0   156.0 91 32 16   6 3     0   8   85 71     2 17   83 12   156
699735 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318003057 111 Anoka-Hennepin Regional Night School Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 20.0 3.0 1.0   1.0 0.0     0.0   3.0   13.0 15.0     0.0   4.0     12.0   5.0   28.0 20 3 1   1 0     0   3   13 15     0 4   12 5   28
699737 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002629 434 Anoka-Hennepin Technical High School Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 84.0 35.0 17.0   2.0 3.0     0.0   5.0   99.0 47.0     12.0   18.0     63.0   19.0   146.0 84 35 17   2 3     0   5   99 47     12 18   63 19   146
699739 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002503 438 Anoka-Hennepin Specialty Program Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   pk_12_total 0.0 0.0 1.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 0 0 1   0 0     0   0   0 1                 1
699741 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002974 812 COMPASS-BELL CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   pk_12_total 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
699746 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810002753 167 CENTENNIAL AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   pk_12_total 34.0 0.0 3.0   0.0 3.0     0.0   3.0   25.0 18.0     0.0   6.0     24.0   16.0   43.0 34 0 3   0 3     0   3   25 18     0 6   24 16   43
699751 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242002632 552 Fridley Moore Lake Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 27.0 30.0 35.0   3.0 4.0     0.0   7.0   53.0 53.0     33.0   3.0     86.0   11.0   106.0 27 30 35   3 4     0   7   53 53     33 3   86 11   106
699755 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242003427 652 FRIDLEY MIDDLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2017   pk_12_total 15.0 19.0 5.0   0.0 1.0     0.0   4.0   23.0 21.0     3.0   0.0     31.0   1.0   44.0 15 19 5   0 1     0   4   23 21     3 0   31 1   44
699758 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354005051 16 Saints Guided Studies Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 9.0 0.0 0.0   1.0 0.0     0.0   1.0   6.0 5.0     0.0   1.0         *   11.0 9 0 0   1 0     0   1   6 5     0 1         11
699764 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354004980 18 Saints Academy Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   pk_12_total 97.0 0.0 1.0   0.0 0.0     0.0   7.0   63.0 42.0     1.0   1.0     41.0   6.0   105.0 97 0 1   0 0     0   7   63 42     1 1   41 6   105
699769 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023000294 6 Detroit Lakes Alternative Program Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 36.0 0.0 1.0   15.0 1.0     0.0   7.0   29.0 31.0     0.0   6.0     40.0   10.0   60.0 36 0 1   15 1     0   7   29 31     0 6   40 10   60
699771 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023004330 7 AFTERSCHOOL PROGRAM Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 2 0 0   0 0     0   0   1 1                 2
699774 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023003061 32 DETROIT LAKES MIDDLE ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   pk_12_total 12.0 0.0 0.0   2.0 0.0     0.0   2.0   12.0 4.0     0.0   0.0     10.0   0.0   16.0 12 0 0   2 0     0   2   12 4     0 0   10 0   16
699777 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023003062 42 DETROIT LAKES AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 3.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 2.0         *         *   4.0 3 0 0   0 0     0   1   2 2                 4
699782 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444004159 22 BEMIDJI SENIOR LUMBERJACK ALC Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 15.0 2.0 2.0   40.0 0.0     0.0   3.0   28.0 34.0     0.0   *     53.0   *   62.0 15 2 2   40 0     0   3   28 34     0     53     62
699786 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444002331 170 BEMIDJI AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other KG 12 2017   pk_12_total 50.0 0.0 2.0   13.0 0.0     0.0   3.0   28.0 40.0     0.0   0.0     24.0   15.0   68.0 50 0 2   13 0     0   3   28 40     0 0   24 15   68
699790 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051000325 35 RED LAKE ALTERNATIVE LEARNING Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 0.0 0.0 0.0   71.0 0.0     0.0   0.0   32.0 39.0     0.0   *     60.0   4.0   71.0 0 0 0   71 0     0   0   32 39     0     60 4   71
699793 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051002793 50 RED LAKE MIDDLE LEVEL ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   pk_12_total 0.0 0.0 0.0   17.0 0.0     0.0   0.0   9.0 8.0     0.0   3.0         *   17.0 0 0 0   17 0     0   0   9 8     0 3         17
699798 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000337 220 CENTRAL HIGH AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 40.0 10.0 8.0   1.0 0.0     0.0   1.0   29.0 31.0     2.0   8.0     30.0   14.0   60.0 40 10 8   1 0     0   1   29 31     2 8   30 14   60
699801 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878004517 222 MANKATO AREA NIGHT SCHOOL Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 15.0 0.0 0.0   0.0 1.0     0.0   1.0   9.0 8.0     0.0   2.0     10.0   4.0   17.0 15 0 0   0 1     0   1   9 8     0 2   10 4   17
699805 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878003678 260 CENTRAL FREEDOM SCHOOL Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   pk_12_total 6.0 1.0 0.0   0.0 0.0     0.0   0.0   4.0 3.0         *         *   7.0 6 1 0   0 0     0   0   4 3                 7
699813 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942002236 103 CLOQUET AREA ALT. ED. PROGRAMS Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 2017   pk_12_total 58.0 0.0 1.0   16.0 0.0     0.0   9.0   52.0 32.0     0.0   2.0     59.0   *   84.0 58 0 1   16 0     0   9   52 32     0 2   59     84
699816 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942003690 108 CAAEP EXTENDED DAY PROGRAM Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 3.0 1.0 1.0   0.0 0.0     0.0   1.0   3.0 3.0         *         *   6.0 3 1 1   0 0     0   1   3 3                 6
699820 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146004597 601 WACONIA ALTERNATIVE LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 2017   pk_12_total 30.0 1.0 2.0   0.0 0.0     0.0   1.0   15.0 19.0     0.0   0.0     11.0   7.0   34.0 30 1 2   0 0     0   1   15 19     0 0   11 7   34
699823 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146004586 602 WACONIA AREA LEARNING CENTER SS/AS Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 16.0 0.0 3.0   1.0 0.0     0.0   1.0   17.0 4.0     1.0   0.0         5.0   21.0 16 0 3   1 0     0   1   17 4     1 0     5   21
699828 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819004310 65 INTEGRATED ARTS ACADEMY Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 64.0 4.0 23.0   0.0 1.0     0.0   7.0   44.0 55.0         0.0     38.0   26.0   99.0 64 4 23   0 1     0   7   44 55       0   38 26   99
699832 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819004622 66 112 ALC MIDDLE SCHOOL Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   pk_12_total 233.0 30.0 82.0   4.0 9.0     0.0   28.0   208.0 178.0     48.0   1.0     160.0   79.0   386.0 233 30 82   4 9     0   28   208 178     48 1   160 79   386
699839 MN Cass 11 school 2708070 115 Independent Districts and Schools CASS LAKE-BENA PUBLIC SCHOOLS 270807002234 31 CASS LAKE-BENA AREA LRNG. CNTR. Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   pk_12_total 7.0 0.0 0.0   98.0 0.0     0.0   0.0   54.0 51.0     0.0   18.0         25.0   105.0 7 0 0   98 0     0   0   54 51     0 18     25   105
699846 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382000401 50 NORTH BRANCH LAB SCHOOL ALC Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   pk_12_total 145.0 5.0 6.0   2.0 1.0     0.0   4.0   95.0 68.0     1.0   1.0     35.0   20.0   163.0 145 5 6   2 1     0   4   95 68     1 1   35 20   163
699851 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142000462 980 Red River Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No Other 05 12 2017   pk_12_total 44.0 2.0 25.0   10.0 0.0     0.0   7.0   40.0 48.0     3.0   3.0     56.0   12.0   88.0 44 2 25   10 0     0   7   40 48     3 3   56 12   88
699856 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609001874 18 ISD 181 LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other KG 12 2017   pk_12_total 113.0 3.0 2.0   3.0 0.0     0.0   5.0   58.0 68.0     0.0   7.0     72.0   17.0   126.0 113 3 2   3 0     0   5   58 68     0 7   72 17   126
699860 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609002982 21 MIDDLE LEVEL ALTERNATIVE PROGRAM Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2017   pk_12_total 11.0 0.0 0.0   1.0 0.0     0.0   0.0   8.0 4.0     0.0   2.0         2.0   12.0 11 0 0   1 0     0   0   8 4     0 2     2   12
699864 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002640 314 BURNSVILLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   pk_12_total 217.0 222.0 201.0   4.0 40.0     8.0   81.0   391.0 382.0     164.0   6.0     523.0   171.0   773.0 217 222 201   4 40     8   81   391 382     164 6   523 171   773
699867 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000474 500 Burnsville Sr High Extended Day Program Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 5.0 9.0 2.0   0.0 1.0     0.0   0.0   8.0 9.0         0.0         2.0   17.0 5 9 2   0 1     0   0   8 9       0     2   17
699871 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000481 514 BURNSVILLE ALTERNATIVE HIGH SCHOOL Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 39.0 37.0 44.0   3.0 7.0     0.0   14.0   81.0 63.0     16.0   2.0     79.0   29.0   144.0 39 37 44   3 7     0   14   81 63     16 2   79 29   144
699877 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002804 590 LAKEVILLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   pk_12_total 45.0 4.0 12.0   4.0 2.0     0.0   4.0   38.0 33.0     1.0   0.0     27.0   5.0   71.0 45 4 12   4 2     0   4   38 33     1 0   27 5   71
699881 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000500 58 ROSEMOUNT AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 46.0 20.0 24.0   1.0 1.0     0.0   7.0   48.0 51.0         6.0     48.0   27.0   99.0 46 20 24   1 1     0   7   48 51       6   48 27   99
699886 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353002754 136 HASTINGS ALTERNATIVE CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   pk_12_total 23.0 0.0 1.0   0.0 0.0     0.0   1.0   16.0 9.0     0.0   0.0     10.0   *   25.0 23 0 1   0 0     0   1   16 9     0 0   10     25
699892 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 Other 06 12 2017   pk_12_total 72.0 4.0 25.0   0.0 3.0     0.0   2.0   57.0 49.0         0.0     73.0   *   106.0 72 4 25   0 3     0   2   57 49       0   73     106
699897 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520004529 702 ALC SENIOR HIGH Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 34.0 46.0 30.0   1.0 12.0     0.0   15.0   73.0 65.0     23.0   10.0     90.0   *   138.0 34 46 30   1 12     0   15   73 65     23 10   90     138
699899 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520004441 703 ALC INDEPENDENT STUDY Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 0.0 4.0 1.0   0.0 0.0     0.0   4.0   4.0 5.0         *         *   9.0 0 4 1   0 0     0   4   4 5                 9
699902 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178004613 200 HIGHVIEW ALC Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 42.0 69.0 23.0   4.0 5.0     0.0   8.0   77.0 74.0     1.0   2.0     91.0   15.0   151.0 42 69 23   4 5     0   8   77 74     1 2   91 15   151
699904 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178004585 648 ADULT ACADEMICS Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 3.0 3.0 0.0   0.0 1.0     0.0   0.0   6.0 1.0         *         *   7.0 3 3 0   0 1     0   0   6 1                 7
699907 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178004623 753 HIGHVIEW INDEPENDENT STUDY Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 7.0 9.0 4.0   0.0 0.0     0.0   1.0   11.0 10.0     1.0   0.0     12.0   2.0   21.0 7 9 4   0 0     0   1   11 10     1 0   12 2   21
699911 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178004630 903 ROBBINSDALE TASC ALC Public Area Learning Center ALC (State approved) Alternative School No High 08 12 2017   pk_12_total 1.0 2.0 1.0   0.0 0.0     0.0   2.0   4.0 2.0         *         *   6.0 1 2 1   0 0     0   2   4 2                 6
699914 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216003520 48 IS THE ALTERNATIVE PROGRAM (TAP) Public Area Learning Center ALC (State approved) Alternative School No High 10 12 2017   pk_12_total 3.0 1.0 0.0   0.0 0.0     0.0   0.0   2.0 2.0         *         *   4.0 3 1 0   0 0     0   0   2 2                 4
699919 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216003521 49 THE ALTERNATIVE PROGRAM (TAP) Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 62.0 40.0 17.0   1.0 1.0     0.0   12.0   67.0 66.0     4.0   *     70.0   17.0   133.0 62 40 17   1 1     0   12   67 66     4     70 17   133
699923 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216003743 952 EAST MIDDLE ALTERNATIVE (EMAP) Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   pk_12_total 15.0 5.0 4.0   0.0 2.0     0.0   3.0   12.0 17.0     4.0   0.0     12.0   *   29.0 15 5 4   0 2     0   3   12 17     4 0   12     29
699925 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216003740 953 CENTRAL MIDDLE ALTERNATIVE (CMAP) Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   pk_12_total 9.0 5.0 0.0   0.0 0.0     0.0   0.0   9.0 5.0     0.0   0.0         0.0   14.0 9 5 0   0 0     0   0   9 5     0 0     0   14
699929 MN Hennepin 27 school 2706240 286 Independent Districts and Schools BROOKLYN CENTER SCHOOL DISTRICT 270624004806 17 Brooklyn Center Independent Study Program Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 1.0 11.0 0.0   0.0 0.0     0.0   1.0   9.0 4.0     2.0   *         1.0   13.0 1 11 0   0 0     0   1   9 4     2       1   13
699934 MN Hennepin 27 school 2706240 286 Independent Districts and Schools BROOKLYN CENTER SCHOOL DISTRICT 270624004824 763 Brooklyn Center Academy Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 4.0 37.0 14.0   1.0 3.0     0.0   3.0   31.0 31.0         5.0     49.0   13.0   62.0 4 37 14   1 3     0   3   31 31       5   49 13   62
699939 MN Hubbard 29 school 2728080 309 Independent Districts and Schools PARK RAPIDS PUBLIC SCHOOL DISTRICT 272808004671 81 Century Middle School Within A School Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2017   pk_12_total 51.0 2.0 6.0   3.0 0.0     0.0   5.0   32.0 35.0     3.0   0.0     49.0   13.0   67.0 51 2 6   3 0     0   5   32 35     3 0   49 13   67
699943 MN Hubbard 29 school 2728080 309 Independent Districts and Schools PARK RAPIDS PUBLIC SCHOOL DISTRICT 272808000864 90 HEADWATERS EDUC LEARNING PROGRAM Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 34.0 2.0 1.0   4.0 0.0     0.0   0.0   17.0 24.0     0.0   1.0     27.0   15.0   41.0 34 2 1   4 0     0   0   17 24     0 1   27 15   41
699947 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317002332 365 GRAND RAPIDS AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 08 12 2017   pk_12_total 61.0 1.0 2.0   12.0 0.0     0.0   11.0   52.0 35.0     0.0   1.0     49.0   5.0   87.0 61 1 2   12 0     0   11   52 35     0 1   49 5   87
699952 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000940 375 MIDDLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2017   pk_12_total 125.0 0.0 2.0   5.0 1.0     1.0   16.0   61.0 89.0         0.0     77.0   8.0   150.0 125 0 2   5 1     1   16   61 89       0   77 8   150
699956 MN Kanabec 33 school 2721480 332 Independent Districts and Schools MORA PUBLIC SCHOOL DISTRICT 272148000946 50 MORA ALTERNATIVE LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 49.0 0.0 1.0   1.0 0.0     0.0   1.0   26.0 26.0     0.0   9.0     44.0   17.0   52.0 49 0 1   1 0     0   1   26 26     0 9   44 17   52
699959 MN Kanabec 33 school 2721480 332 Independent Districts and Schools MORA PUBLIC SCHOOL DISTRICT 272148004472 51 MORA MIDDLE LEVEL ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   pk_12_total 13.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 7.0     0.0   1.0     10.0   0.0   13.0 13 0 0   0 0     0   0   6 7     0 1   10 0   13
699964 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272000950 949 WILLMAR AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   pk_12_total 36.0 6.0 71.0   3.0 0.0     0.0   1.0   54.0 63.0     16.0   0.0     94.0   27.0   117.0 36 6 71   3 0     0   1   54 63     16 0   94 27   117
699967 MN Lake 38 school 2740740 381 Independent Districts and Schools LAKE SUPERIOR PUBLIC SCHOOL DIST. 274074002528 255 SOLO Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   pk_12_total 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 3 0 0   0 0     0   0   3 0                 3
699972 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894002816 8 MATEC Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 37.0 6.0 27.0   0.0 3.0     0.0   0.0   40.0 33.0     0.0   3.0         19.0   73.0 37 6 27   0 3     0   0   40 33     0 3     19   73
699976 MN Mcleod 43 school 2714970 423 Independent Districts and Schools HUTCHINSON PUBLIC SCHOOL DISTRICT 271497000955 70 CROW RIVER AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 4.0 1.0 1.0   0.0 0.0     0.0   0.0   5.0 1.0         *         *   6.0 4 1 1   0 0     0   0   5 1                 6
699980 MN Mcleod 43 school 2714970 423 Independent Districts and Schools HUTCHINSON PUBLIC SCHOOL DISTRICT 271497003632 72 HUTCHINSON NIGHT ALT LEARNING CTR Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 3.0 0.0 1.0   0.0 0.0     0.0   2.0   3.0 3.0         *         *   6.0 3 0 1   0 0     0   2   3 3                 6
699984 MN Mcleod 43 school 2714970 423 Independent Districts and Schools HUTCHINSON PUBLIC SCHOOL DISTRICT 271497003522 75 HUTCHINSON MIDDLE SCHOOL A.L.C. Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   pk_12_total 34.0 0.0 4.0   0.0 0.0     0.0   0.0   21.0 17.0         0.0     20.0   2.0   38.0 34 0 4   0 0     0   0   21 17       0   20 2   38
699990 MN Mahnomen 44 school 2718660 432 Independent Districts and Schools MAHNOMEN PUBLIC SCHOOL DISTRICT 271866002333 40 MAHNOMEN AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   pk_12_total 3.0 0.0 0.0   26.0 0.0     0.0   15.0   20.0 24.0     0.0   1.0         12.0   44.0 3 0 0   26 0     0   15   20 24     0 1     12   44

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