Data source: Big Local News · About: Big Local

676 rows where grade = "grade_7", state = "MN" and year = 2017 sorted by ccd_school_type

View and edit SQL

year

  • 2017 · 676

grade

  • grade_7 · 676
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
699753 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   grade_7 8.0 12.0 1.0   0.0 0.0     0.0   2.0   13.0 10.0     2.0   *     14.0   *   23.0 8 12 1   0 0     0   2   13 10     2     14     23
699759 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   grade_7 34.0 0.0 0.0   0.0 0.0     0.0   3.0   20.0 17.0     0.0   *         *   37.0 34 0 0   0 0     0   3   20 17     0           37
699772 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   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
699791 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   grade_7 0.0 0.0 0.0   3.0 0.0     0.0   0.0   2.0 1.0         *         *   3.0 0 0 0   3 0     0   0   2 1                 3
699807 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   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 2 0 0   0 0     0   0   2 0                 2
699830 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   grade_7 88.0 11.0 29.0   1.0 2.0     0.0   16.0   85.0 62.0     21.0   1.0     65.0   29.0   147.0 88 11 29   1 2     0   16   85 62     21 1   65 29   147
699833 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   grade_7 0.0 0.0 0.0   4.0 0.0     0.0   0.0   3.0 1.0         *         *   4.0 0 0 0   4 0     0   0   3 1                 4
699840 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   grade_7 22.0 0.0 0.0   1.0 1.0     0.0   1.0   9.0 16.0     0.0   0.0         0.0   25.0 22 0 0   1 1     0   1   9 16     0 0     0   25
699858 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   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0         *         *   3.0 3 0 0   0 0     0   0   2 1                 3
699862 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   grade_7 64.0 68.0 55.0   3.0 16.0     3.0   28.0   132.0 105.0     54.0   2.0     161.0   57.0   237.0 64 68 55   3 16     3   28   132 105     54 2   161 57   237
699888 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   grade_7 5.0 0.0 3.0   0.0 1.0     0.0   0.0   5.0 4.0         *         *   9.0 5 0 3   0 1     0   0   5 4                 9
699921 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   grade_7 7.0 4.0 3.0   0.0 1.0     0.0   0.0   8.0 7.0     2.0   *         6.0   15.0 7 4 3   0 1     0   0   8 7     2       6   15
699937 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   grade_7 7.0 1.0 0.0   1.0 0.0     0.0   1.0   5.0 5.0     0.0   0.0         0.0   10.0 7 1 0   1 0     0   1   5 5     0 0     0   10
699950 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   grade_7 43.0 0.0 0.0   1.0 0.0     0.0   6.0   23.0 27.0     0.0   0.0     28.0   *   50.0 43 0 0   1 0     0   6   23 27     0 0   28     50
699957 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   grade_7 5.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 3.0         *         *   5.0 5 0 0   0 0     0   0   2 3                 5
699982 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   grade_7 12.0 0.0 1.0   0.0 0.0     0.0   0.0   7.0 6.0     0.0   0.0     9.0   *   13.0 12 0 1   0 0     0   0   7 6     0 0   9     13
700020 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 Other 06 12 2017   grade_7 3.0 2.0 10.0   0.0 2.0     1.0   1.0   12.0 7.0     2.0   0.0     15.0   0.0   19.0 3 2 10   0 2     1   1   12 7     2 0   15 0   19
700031 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416002335 6 WORTHINGTON AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   grade_7 0.0 1.0 1.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 0 1 1   0 0     0   0   1 1                 2
700064 MN Otter Tail 56 school 2728170 548 Independent Districts and Schools PELICAN RAPIDS PUBLIC SCHOOL DIST. 272817004487 60 PELICAN RAPIDS ALT CENTER MID-LEVEL Public Area Learning Center ALC (State approved) Alternative School No Middle 07 08 2017   grade_7 3.0 5.0 8.0   0.0 1.0     0.0   0.0   11.0 6.0     3.0   0.0     14.0   1.0   17.0 3 5 8   0 1     0   0   11 6     3 0   14 1   17
700094 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236003161 58 CENTRAL AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   grade_7 13.0 1.0 8.0   0.0 0.0     0.0   2.0   8.0 16.0     4.0   2.0     18.0   2.0   24.0 13 1 8   0 0     0   2   8 16     4 2   18 2   24
700098 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236003162 60 SUNRISE PARK AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   grade_7 10.0 5.0 1.0   0.0 3.0     0.0   3.0   15.0 7.0     3.0   1.0     15.0   1.0   22.0 10 5 1   0 3     0   3   15 7     3 1   15 1   22
700135 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104002237 611 DULUTH AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_7 41.0 4.0 3.0   3.0 0.0     0.0   11.0   31.0 31.0     2.0   7.0     49.0   47.0   62.0 41 4 3   3 0     0   11   31 31     2 7   49 47   62
700162 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137003363 603 IVAN SAND COMMUNITY SCHOOL-MIDDLE Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   grade_7 113.0 7.0 5.0   0.0 1.0     0.0   9.0   80.0 55.0     5.0   0.0     46.0   1.0   135.0 113 7 5   0 1     0   9   80 55     5 0   46 1   135
700183 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805003100 609 OWATONNA ALC 6-8 Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   grade_7 19.0 4.0 11.0   0.0 1.0     0.0   0.0   16.0 19.0     0.0   0.0         0.0   35.0 19 4 11   0 1     0   0   16 19     0 0     0   35
700223 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741005021 385 Riverside Academy MLP Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 1 0   0 0     0   0   1 0                 1
700239 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566004726 25 BOLD ALC Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   grade_7 3.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 0.0         *         *   4.0 3 0 1   0 0     0   0   4 0                 4
700355 MN Wadena 80 school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001402222 20 FRESHWATER ED. DIST. ALC Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   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
700363 MN Olmsted 55 school 2700054 6012 Education Districts ZUMBRO EDUCATION DISTRICT 270005402492 20 ZUMBRO AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   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
700394 MN Brown 8 school 2791353 6049 Education Districts RIVER BEND EDUCATION DISTRICT 279135302494 20 RIVER BEND AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 2 0 0   0 0     0   0   2 0                 2
700402 MN Goodhue 25 school 2791443 6051 Education Districts Goodhue County Education District 279144304717 610 Pathways Program Grades 6-7 Public Area Learning Center ALC (State approved) Alternative School No Middle 06 07 2017   grade_7 3.0 0.0 1.0   2.0 0.0     0.0   0.0   1.0 5.0         *         *   6.0 3 0 1   2 0     0   0   1 5                 6
700420 MN Saint Louis 69 school 2700224 6076 Miscellaneous Cooperatives NORTHLAND LEARNING CENTER 270022403477 10 NORTHLAND LEARNING CENTER 010 Public Area Learning Center ALC (State approved) Alternative School No Other PK 12 2017   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0         *         *   2.0 1 1 0   0 0     0   0   0 2                 2
700428 MN Koochiching 36 school 2700224 6076 Miscellaneous Cooperatives NORTHLAND LEARNING CENTER 270022404905 15 ISD 361 - ALC Program Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_7 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
701669 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272000949 899 LAKEVIEW SCHOOL Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2017   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
701687 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104001600 630 SUPERIOR ACADEMY Hospital/Medical/Partial Hospitalization Program Alternative School No Other 04 12 2017   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 2 0 0   0 0     0   0   2 0                 2
701698 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001935 688 MPS METRO HA Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2017   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 1 1 0   0 0     0   0   1 1                 2
701708 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002504537 530 PRAIRIE CARE HOSPITAL DAY PROGRAM Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2017   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0         *         *   2.0 2 0 0   0 0     0   0   0 2                 2
701719 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002504532 531 PRAIRIE CARE RESIDENT CARE-IHP Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2017   grade_7 2.0 0.0 0.0   2.0 0.0     0.0   0.0   0.0 4.0         *         *   4.0 2 0 0   2 0     0   0   0 4                 4
701730 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002504467 532 PRAIRIE CARE EDINA - PHP Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2017   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
701930 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810004656 159 Pines School - NSP Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 06 12 2017   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
701943 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000313 160 FIRST CITY SCHOOL Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2017   grade_7 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
701955 MN Cass 11 school 2730870 118 Independent Districts and Schools NORTHLAND COMMUNITY SCHOOLS 273087003507 40 LITTLE SAND Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2017   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
701961 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142000413 960 WEST CENTRAL JUVENILE CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2017   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 2 0 0   0 0     0   0   2 0                 2
701996 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317003073 227 ITASKIN EDUCATION CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2017   grade_7 2.0 0.0 0.0   4.0 0.0     0.0   0.0   3.0 3.0         *         *   6.0 2 0 0   4 0     0   0   3 3                 6
702004 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272004673 931 Prairie Lakes Education Center Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2017   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
702025 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools ONAMIA PUBLIC SCHOOL DISTRICT 272505000957 30 MILLE LACS ACADEMY (NEXUS) Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 05 12 2017   grade_7 5.0 1.0 1.0   1.0 0.0     0.0   0.0   8.0 0.0         *         *   8.0 5 1 1   1 0     0   0   8 0                 8
702032 MN Nicollet 52 school 2733870 508 Independent Districts and Schools ST. PETER PUBLIC SCHOOL DISTRICT 273387000973 60 HOFFMAN LEARNING CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 05 12 2017   grade_7 4.0 0.0 1.0   0.0 0.0     0.0   0.0   5.0 0.0         *         *   5.0 4 0 1   0 0     0   0   5 0                 5
702047 MN Polk 60 school 2709720 593 Independent Districts and Schools CROOKSTON PUBLIC SCHOOL DISTRICT 270972001030 100 Northern Lights Academy Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 06 12 2017   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 0 0   1 0     0   0   1 0                 1
702065 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001334 678 JUVENILE SERVICE CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 02 12 2017   grade_7 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
702083 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104001562 81 MERRITT CREEK ACADEMY Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 01 12 2017   grade_7 4.0 0.0 1.0   3.0 0.0     0.0   1.0   9.0 0.0         *         *   9.0 4 0 1   3 0     0   1   9 0                 9
702096 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104001574 575 CHESTER CREEK ACADEMY Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2017   grade_7 7.0 1.0 0.0   1.0 0.0     0.0   1.0   8.0 2.0     0.0   0.0         *   10.0 7 1 0   1 0     0   1   8 2     0 0         10
702103 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104001577 580 WOODLAND HILLS ACADEMY Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 06 12 2017   grade_7 0.0 1.0 0.0   1.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 0 1 0   1 0     0   0   2 0                 2
702111 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104001589 605 ARROWHEAD JUVENILE CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2017   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
702124 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351004649 67 St Cloud Hospital Progs-Residential Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2017   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
702132 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351004650 73 Riverwoods School - Residential Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2017   grade_7 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
702139 MN Swift 76 school 2704470 777 Independent Districts and Schools BENSON PUBLIC SCHOOL DISTRICT 270447004182 110 Heartland Girls Ranch Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2017   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   1.0   0.0 2.0         *         *   2.0 0 0 0   1 0     0   1   0 2                 2
702170 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001936 689 MPS METRO SJ Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2017   grade_7 1.0 3.0 0.0   0.0 0.0     0.0   0.0   2.0 2.0         *         *   4.0 1 3 0   0 0     0   0   2 2                 4
702203 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042004999 34 SW Metro Day Treatment Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 06 12 2017   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
702236 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004502964 16 VILLAGE RANCH ALTERNATIVE PROGRAM Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 05 12 2017   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 2 0 0   0 0     0   0   2 0                 2
702256 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000268 850 CROSSROADS SCHOOL & VOC. CENTER Miscellaneous Program (assignment is now limited) Alternative School No Other KG 12 2017   grade_7 1.0 6.0 0.0   0.0 0.0     0.0   0.0   7.0 0.0         *         *   7.0 1 6 0   0 0     0   0   7 0                 7
702266 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000468 17 LINCOLN EDUCATION CENTER Miscellaneous Program (assignment is now limited) Alternative School No Other 02 12 2017   grade_7 1.0 1.0 0.0   1.0 0.0     0.0   1.0   2.0 2.0         *         *   4.0 1 1 0   1 0     0   1   2 2                 4
702349 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools PRINCETON PUBLIC SCHOOL DISTRICT 273003004936 90 Princeton Alternative Services Educational Oversight to Public Care and Treatment Day Program Alternative School No Other 01 12 2017   grade_7 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
702367 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295003494 41 NETS Educational Oversight to Public Care and Treatment Day Program Alternative School No Other 05 12 2017   grade_7 2.0 2.0 0.0   0.0 0.0     0.0   0.0   1.0 3.0         *         *   4.0 2 2 0   0 0     0   0   1 3                 4
702374 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295004678 45 Options Educational Oversight to Public Care and Treatment Day Program Alternative School No Other 06 12 2017   grade_7 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
702406 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384005018 56 LS MNIC Educational Oversight to Public Care and Treatment Day Program Alternative School No Other PK 12 2017   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 1 1 0   0 0     0   0   1 1                 2
702423 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351003369 66 ST. CLOUD HOSPITAL PROGRAMS NON-RES Educational Oversight to Public Care and Treatment Day Program Alternative School No Other PK 12 2017   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
702436 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351001640 72 RIVERWOODS SCHOOL NON-RESIDENTIAL Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2017   grade_7 8.0 3.0 0.0   0.0 0.0     0.0   0.0   8.0 3.0     0.0   1.0         *   11.0 8 3 0   0 0     0   0   8 3     0 1         11
702462 MN Pope 61 school 2700019 2149 Independent Districts and Schools MINNEWASKA SCHOOL DISTRICT 270001903600 101 MINNEWASKA DAY TREATMENT PROGRAM Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2017   grade_7 3.0 1.0 0.0   0.0 0.0     0.0   0.0   4.0 0.0         *         *   4.0 3 1 0   0 0     0   0   4 0                 4
702469 MN Fillmore 23 school 2700100 2198 Independent Districts and Schools FILLMORE CENTRAL 270010004226 301 ROOT RIVER PROGRAM Educational Oversight to Public Care and Treatment Day Program Alternative School No High 07 12 2017   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
702473 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002504533 527 HEADWAY ACADEMY Educational Oversight to Public Care and Treatment Day Program Alternative School No High 07 12 2017   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0         *         *   2.0 1 1 0   0 0     0   0   0 2                 2
702486 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002504929 538 Headway Academy North Educational Oversight to Public Care and Treatment Day Program Alternative School No High 07 12 2017   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0         *         *   2.0 2 0 0   0 0     0   0   0 2                 2
702518 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002604807 100 Youth Transition Program Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2017   grade_7 3.0 1.0 2.0   0.0 0.0     0.0   1.0   4.0 3.0         *         *   7.0 3 1 2   0 0     0   1   4 3                 7
702526 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002604516 300 Options Educational Oversight to Public Care and Treatment Day Program Alternative School No Other 04 12 2017   grade_7 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
702618 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 2017   grade_7 8.0 2.0 0.0   0.0 0.0     0.0   2.0   6.0 6.0     0.0   0.0     0.0   *   12.0 8 2 0   0 0     0   2   6 6     0 0   0     12
702661 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001903 361 CENTER SCHOOL Private Alternative Program Alternative School No High 07 12 2017   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 0 0   1 0     0   0   1 0                 1
689010 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 2017   grade_7 102.0 0.0 1.0   0.0 0.0     0.0   4.0   55.0 52.0     0.0   0.0     39.0   14.0   107.0 102 0 1   0 0     0   4   55 52     0 0   39 14   107
689017 MN Aitkin 1 school 2719170 4 Independent Districts and Schools MCGREGOR PUBLIC SCHOOL DISTRICT 271917000904 40 MCGREGOR SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 25.0 0.0 0.0   6.0 0.0     0.0   1.0   12.0 20.0         *     16.0   5.0   32.0 25 0 0   6 0     0   1   12 20           16 5   32
689024 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333004658 788 Secondary Lighthouse Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 8.0 0.0 0.0   0.0 1.0     0.0   1.0   4.0 6.0     0.0   0.0     2.0   0.0   10.0 8 0 0   0 1     0   1   4 6     0 0   2 0   10
689031 MN Becker 3 school 2712360 23 Independent Districts and Schools FRAZEE-VERGAS PUBLIC SCHOOL DIST. 271236000606 20 FRAZEE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 59.0 0.0 1.0   2.0 0.0     0.0   3.0   30.0 35.0     0.0   0.0     33.0   16.0   65.0 59 0 1   2 0     0   3   30 35     0 0   33 16   65
689038 MN Beltrami 4 school 2705730 32 Independent Districts and Schools BLACKDUCK PUBLIC SCHOOL DISTRICT 270573000213 20 BLACKDUCK SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 44.0 1.0 0.0   5.0 1.0     0.0   1.0   21.0 31.0     0.0   4.0     27.0   7.0   52.0 44 1 0   5 1     0   1   21 31     0 4   27 7   52
689045 MN Beltrami 4 school 2717010 36 Independent Districts and Schools KELLIHER PUBLIC SCHOOL DISTRICT 271701000787 20 KELLIHER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 9.0 0.0 0.0   13.0 0.0     0.0   0.0   9.0 13.0     0.0   0.0     17.0   3.0   22.0 9 0 0   13 0     0   0   9 13     0 0   17 3   22
689052 MN Blue Earth 7 school 2733480 75 Independent Districts and Schools ST. CLAIR PUBLIC SCHOOL DISTRICT 273348001478 20 ST. CLAIR SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 54.0 0.0 1.0   0.0 0.0     0.0   2.0   32.0 25.0     0.0   0.0     15.0   7.0   57.0 54 0 1   0 0     0   2   32 25     0 0   15 7   57
689059 MN Brown 8 school 2709540 81 Independent Districts and Schools COMFREY PUBLIC SCHOOL DISTRICT 270954000404 20 COMFREY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 17.0 0.0 2.0   0.0 0.0     0.0   0.0   7.0 12.0     0.0   0.0     11.0   3.0   19.0 17 0 2   0 0     0   0   7 12     0 0   11 3   19
689066 MN Brown 8 school 2733210 84 Independent Districts and Schools SLEEPY EYE PUBLIC SCHOOL DISTRICT 273321001451 20 SLEEPY EYE SEC. Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 34.0 1.0 14.0   0.0 1.0     0.0   0.0   27.0 23.0     3.0   1.0     24.0   9.0   50.0 34 1 14   0 1     0   0   27 23     3 1   24 9   50
689073 MN Brown 8 school 2733390 85 Independent Districts and Schools SPRINGFIELD PUBLIC SCHOOL DISTRICT 273339001471 1 SPRINGFIELD SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 43.0 0.0 2.0   0.0 0.0     0.0   0.0   27.0 18.0     0.0   0.0     19.0   7.0   45.0 43 0 2   0 0     0   0   27 18     0 0   19 7   45
689080 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000172 2 BARNUM SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 62.0 0.0 0.0   0.0 0.0     0.0   4.0   27.0 39.0     0.0   0.0     25.0   6.0   66.0 62 0 0   0 0     0   4   27 39     0 0   25 6   66
689088 MN Carlton 9 school 2707590 93 Independent Districts and Schools CARLTON PUBLIC SCHOOL DISTRICT 270759000327 1 CARLTON SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_7 20.0 1.0 0.0   4.0 1.0     0.0   1.0   15.0 12.0     0.0   0.0     10.0   5.0   27.0 20 1 0   4 1     0   1   15 12     0 0   10 5   27
689095 MN Carlton 9 school 2709690 95 Independent Districts and Schools CROMWELL-WRIGHT PUBLIC SCHOOLS 270969000409 20 CROMWELL-WRIGHT SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 29.0 0.0 0.0   2.0 0.0     0.0   0.0   18.0 13.0     0.0   0.0     13.0   8.0   31.0 29 0 0   2 0     0   0   18 13     0 0   13 8   31
689102 MN Carlton 9 school 2721450 97 Independent Districts and Schools MOOSE LAKE PUBLIC SCHOOL DISTRICT 272145001094 10 MOOSE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 53.0 0.0 1.0   0.0 0.0     0.0   0.0   26.0 28.0     0.0   1.0     22.0   8.0   54.0 53 0 1   0 0     0   0   26 28     0 1   22 8   54
689109 MN Carlton 9 school 2738880 99 Independent Districts and Schools ESKO PUBLIC SCHOOL DISTRICT 273888001681 1 LINCOLN SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 95.0 0.0 4.0   0.0 2.0     0.0   6.0   51.0 56.0     0.0   0.0     9.0   14.0   107.0 95 0 4   0 2     0   6   51 56     0 0   9 14   107
689116 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001843 2 WRENSHALL SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 26.0 0.0 1.0   0.0 0.0     0.0   1.0   14.0 14.0     0.0   0.0     14.0   9.0   28.0 26 0 1   0 0     0   1   14 14     0 0   14 9   28
689123 MN Cass 11 school 2702910 113 Independent Districts and Schools WALKER-HACKENSACK-AKELEY SCHL. DIST 270291001737 20 WALKER-HACKENSACK-AKELEY SEC. Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 40.0 0.0 2.0   15.0 1.0     0.0   3.0   27.0 34.0     0.0   1.0     34.0   18.0   61.0 40 0 2   15 1     0   3   27 34     0 1   34 18   61
689130 MN Cass 11 school 2730870 118 Independent Districts and Schools NORTHLAND COMMUNITY SCHOOLS 273087001308 20 NORTHLAND SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 18.0 0.0 0.0   4.0 0.0     0.0   4.0   13.0 13.0         *         *   26.0 18 0 0   4 0     0   4   13 13                 26
689137 MN Chisago 13 school 2732550 139 Independent Districts and Schools RUSH CITY PUBLIC SCHOOL DISTRICT 273255001406 20 RUSH CITY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 59.0 0.0 3.0   0.0 1.0     0.0   1.0   32.0 32.0     0.0   1.0     25.0   6.0   64.0 59 0 3   0 1     0   1   32 32     0 1   25 6   64
689144 MN Clay 14 school 2703660 146 Independent Districts and Schools Barnesville Public School District 270366000170 40 BARNESVILLE SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_7 64.0 1.0 2.0   0.0 0.0     0.0   0.0   35.0 32.0     0.0   0.0     9.0   5.0   67.0 64 1 2   0 0     0   0   35 32     0 0   9 5   67
689151 MN Clay 14 school 2713560 150 Independent Districts and Schools HAWLEY PUBLIC SCHOOL DISTRICT 271356000699 20 HAWLEY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 77.0 1.0 2.0   0.0 1.0     0.0   1.0   40.0 42.0         0.0     17.0   9.0   82.0 77 1 2   0 1     0   1   40 42       0   17 9   82
689158 MN Clearwater 15 school 2703570 162 Independent Districts and Schools BAGLEY PUBLIC SCHOOL DISTRICT 270357000165 20 BAGLEY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 55.0 2.0 1.0   13.0 1.0     0.0   4.0   35.0 41.0     0.0   0.0     30.0   17.0   76.0 55 2 1   13 1     0   4   35 41     0 0   30 17   76
689165 MN Cottonwood 17 school 2723010 173 Independent Districts and Schools MOUNTAIN LAKE PUBLIC SCHOOLS 272301001135 20 MOUNTAIN LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 27.0 0.0 3.0   0.0 10.0     0.0   1.0   25.0 16.0     2.0   0.0     19.0   5.0   41.0 27 0 3   0 10     0   1   25 16     2 0   19 5   41
689172 MN Crow Wing 18 school 2709750 182 Independent Districts and Schools CROSBY-IRONTON PUBLIC SCHOOL DIST. 270975000417 1 CROSBY-IRONTON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 68.0 3.0 2.0   0.0 1.0     0.0   6.0   40.0 40.0     0.0   0.0     39.0   13.0   80.0 68 3 2   0 1     0   6   40 40     0 0   39 13   80
689179 MN Dakota 19 school 2730150 195 Independent Districts and Schools RANDOLPH PUBLIC SCHOOL DISTRICT 273015001287 20 RANDOLPH SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 44.0 1.0 0.0   0.0 0.0     0.0   2.0   27.0 20.0     0.0   1.0     11.0   6.0   47.0 44 1 0   0 0     0   2   27 20     0 1   11 6   47
689187 MN Dodge 20 school 2713590 203 Independent Districts and Schools HAYFIELD PUBLIC SCHOOL DISTRICT 271359000702 1 HAYFIELD SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_7 45.0 0.0 5.0   1.0 0.0     0.0   0.0   22.0 29.0     1.0   0.0     20.0   8.0   51.0 45 0 5   1 0     0   0   22 29     1 0   20 8   51

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