Data source: Big Local News · About: Big Local

678 rows where grade = "grade_7", state = "MN" and year = 2018 sorted by ccd_school_type

View and edit SQL

year

  • 2018 · 678

grade

  • grade_7 · 678
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
1890704 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 High 06 12 2018   grade_7 1.0 2.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *     *   *   3.0 1 2 0   0 0     0   0   3 0                 3
1890718 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 2018   grade_7 7.0 14.0 5.0   0.0 1.0     0.0   4.0   16.0 15.0     1.0   3.0     27.0   3.0   31.0 7 14 5   0 1     0   4   16 15     1 3   27 3   31
1890725 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 2018   grade_7 31.0 0.0 1.0   3.0 0.0     0.0   1.0   25.0 11.0     *   0.0     12.0   *   36.0 31 0 1   3 0     0   1   25 11       0   12     36
1890737 MN Becker 3 school 2710230 22 Independent Districts and Schools Detroit Lakes Public School District 271023003061 32 Detroit Lakes Middle ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2018   grade_7 4.0 0.0 1.0   1.0 1.0     0.0   4.0   7.0 4.0     *   *     *   *   11.0 4 0 1   1 1     0   4   7 4                 11
1890755 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 2018   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
1890768 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 2018   grade_7 0.0 0.0 0.0   0.0 0.0     0.0   2.0   2.0 0.0     *   *     *   *   2.0 0 0 0   0 0     0   2   2 0                 2
1890786 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819004622 66 112 ALC Middle School Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2018   grade_7 67.0 12.0 31.0   3.0 0.0     0.0   11.0   63.0 61.0     11.0   1.0     53.0   24.0   124.0 67 12 31   3 0     0   11   63 61     11 1   53 24   124
1890791 MN Cass 11 school 2708070 115 Independent Districts and Schools Cass Lake-Bena Public Schools 270807002234 31 Cass Lake-Bena Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2018   grade_7 0.0 0.0 0.0   3.0 0.0     0.0   0.0   0.0 3.0     *   *     *   *   3.0 0 0 0   3 0     0   0   0 3                 3
1890803 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 High 05 12 2018   grade_7 1.0 0.0 1.0   0.0 0.0     0.0   1.0   2.0 1.0     *   *     *   *   3.0 1 0 1   0 0     0   1   2 1                 3
1890816 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 2018   grade_7 5.0 0.0 0.0   0.0 0.0     0.0   1.0   3.0 3.0     *   *     *   *   6.0 5 0 0   0 0     0   1   3 3                 6
1890820 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 High 06 12 2018   grade_7 118.0 107.0 81.0   3.0 27.0     3.0   35.0   189.0 185.0     51.0   1.0     233.0   70.0   374.0 118 107 81   3 27     3   35   189 185     51 1   233 70   374
1890846 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 2018   grade_7 6.0 1.0 3.0   0.0 0.0     0.0   1.0   5.0 6.0     0.0   0.0     9.0   0.0   11.0 6 1 3   0 0     0   1   5 6     0 0   9 0   11
1890880 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 2018   grade_7 13.0 4.0 4.0   0.0 3.0     0.0   2.0   13.0 13.0     2.0   1.0     10.0   0.0   26.0 13 4 4   0 3     0   2   13 13     2 1   10 0   26
1890886 MN Hennepin 27 school 2706240 286 Independent Districts and Schools Brooklyn Center School District 270624004780 16 Brooklyn Center Middle School ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2018   grade_7 1.0 3.0 4.0   0.0 5.0     0.0   2.0   4.0 11.0     *   0.0     13.0   *   15.0 1 3 4   0 5     0   2   4 11       0   13     15
1890912 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 2018   grade_7 42.0 0.0 0.0   2.0 0.0     0.0   3.0   20.0 27.0     0.0   0.0     25.0   *   47.0 42 0 0   2 0     0   3   20 27     0 0   25     47
1890919 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 2018   grade_7 1.0 0.0 5.0   0.0 0.0     0.0   1.0   5.0 2.0     *   *     *   *   7.0 1 0 5   0 0     0   1   5 2                 7
1890932 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 07 12 2018   grade_7 14.0 12.0 3.0   0.0 8.0     0.0   1.0   25.0 13.0     *   0.0     30.0   7.0   38.0 14 12 3   0 8     0   1   25 13       0   30 7   38
1890946 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 2018   grade_7 11.0 0.0 0.0   0.0 0.0     0.0   1.0   8.0 4.0     0.0   0.0     *   0.0   12.0 11 0 0   0 0     0   1   8 4     0 0     0   12
1890949 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 High 06 12 2018   grade_7 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     0   1   0 1                 1
1890984 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 2018   grade_7 6.0 1.0 12.0   0.0 4.0     0.0   0.0   12.0 11.0     0.0   0.0     *   0.0   23.0 6 1 12   0 4     0   0   12 11     0 0     0   23
1890995 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 2018   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
1891025 MN Otter Tail 56 school 2728170 548 Independent Districts and Schools Pelican Rapids Public School District 272817004487 60 Pelican Rapids Alt Center Mid-Level Public Area Learning Center ALC (State approved) Alternative School No Middle 07 08 2018   grade_7 9.0 3.0 3.0   0.0 0.0     0.0   1.0   10.0 6.0     4.0   0.0     11.0   2.0   16.0 9 3 3   0 0     0   1   10 6     4 0   11 2   16
1891086 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 High 06 12 2018   grade_7 19.0 7.0 4.0   3.0 1.0     0.0   7.0   27.0 14.0     2.0   1.0     31.0   34.0   41.0 19 7 4   3 1     0   7   27 14     2 1   31 34   41
1891143 MN Washington 82 school 2712270 831 Independent Districts and Schools Forest Lake Public School District 271227001725 113 Forest Lake Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2018   grade_7 40.0 1.0 0.0   0.0 1.0     0.0   3.0   30.0 15.0     0.0   0.0     15.0   14.0   45.0 40 1 0   0 1     0   3   30 15     0 0   15 14   45
1891168 MN Isanti 30 school 2707410 911 Independent Districts and Schools Cambridge-Isanti Public School District 270741005021 385 Riverside Academy MLP Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2018   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
1891181 MN Lesueur 40 school 2718070 2397 Independent Districts and Schools Le Sueur-Henderson School District 271807004317 33 LSH Middle School Alternative Program Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2018   grade_7 7.0 0.0 7.0   0.0 0.0     0.0   0.0   6.0 8.0     2.0   0.0     7.0   0.0   14.0 7 0 7   0 0     0   0   6 8     2 0   7 0   14
1891183 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 2018   grade_7 3.0 0.0 3.0   0.0 0.0     0.0   0.0   3.0 3.0     *   *     *   *   6.0 3 0 3   0 0     0   0   3 3                 6
1891300 MN Wadena 80 school 2700014 6004 Education Districts Freshwater Education District 270001402222 20 Freshwater Education District ALC Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2018   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
1891307 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 High 06 12 2018   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
1891323 MN Chippewa 12 school 2700058 6018 Education Districts Minnesota River Valley Education District 270005802245 20 Minnesota River Valley ALC-Seatbased Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2018   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
1891333 MN Stearns 73 school 2791455 6026 Education Districts West Central Education District 279145502388 20 West Central Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2018   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
1891345 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 2018   grade_7 1.0 0.0 1.0   1.0 0.0     0.0   1.0   3.0 1.0     *   *     *   *   4.0 1 0 1   1 0     0   1   3 1                 4
1892622 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819004659 522 Prairiecare Chaska Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2018   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
1892636 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001331 675 United Hospital Adolescent Program Hospital/Medical/Partial Hospitalization Program Alternative School No High 06 12 2018   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
1892644 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 High 06 12 2018   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
1892657 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 2018   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
1892669 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002504537 530 PraIrie Care Brooklyn Park Day Program Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2018   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
1892679 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002504532 531 Prairie Care Brooklyn Park - IHP Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2018   grade_7 2.0 0.0 0.0   0.0 1.0     0.0   0.0   2.0 1.0     *   *     *   *   3.0 2 0 0   0 1     0   0   2 1                 3
1892916 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Public School District 273354005097 852 Crossroads South Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2018   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   1.0   4.0 0.0     *   *     *   *   4.0 3 0 0   0 0     0   1   4 0                 4
1892924 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 2018   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
1892948 MN Clay 14 school 2721420 152 Independent Districts and Schools Moorhead Public School District 272142002799 970 Clay County Shelter Care Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2018   grade_7 1.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *     *   *   2.0 1 0 1   0 0     0   0   1 1                 2
1892959 MN Dakota 19 school 2713530 200 Independent Districts and Schools Hastings Public School District 271353000559 137 Harbor Educational Program Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 05 12 2018   grade_7 1.0 0.0 0.0   0.0 1.0     0.0   0.0   2.0 0.0     *   *     *   *   2.0 1 0 0   0 1     0   0   2 0                 2
1892973 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 2018   grade_7 3.0 1.0 0.0   1.0 0.0     0.0   0.0   3.0 2.0     *   *     *   *   5.0 3 1 0   1 0     0   0   3 2                 5
1892980 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 2018   grade_7 0.0 1.0 1.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *     *   *   2.0 0 1 1   0 0     0   0   2 0                 2
1892993 MN Mcleod 43 school 2714970 423 Independent Districts and Schools Hutchinson Public School District 271497003189 35 Cornerstone Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2018   grade_7 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *     *   *   1.0 0 0 1   0 0     0   0   1 0                 1
1893001 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 High 05 12 2018   grade_7 7.0 0.0 1.0   0.0 0.0     0.0   0.0   8.0 0.0     *   *     *   *   8.0 7 0 1   0 0     0   0   8 0                 8
1893008 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 High 05 12 2018   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *     *   *   2.0 1 1 0   0 0     0   0   2 0                 2
1893019 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180002823 217 Care and Treatment JDC/Von Wald Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 05 12 2018   grade_7 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0     *   *     *   *   1.0 0 0 0   0 0     0   1   1 0                 1
1893054 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 KG 12 2018   grade_7 7.0 2.0 1.0   0.0 0.0     0.0   3.0   12.0 1.0     0.0   0.0     *   10.0   13.0 7 2 1   0 0     0   3   12 1     0 0     10   13
1893066 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 2018   grade_7 4.0 1.0 0.0   0.0 1.0     0.0   1.0   5.0 2.0     *   *     *   *   7.0 4 1 0   0 1     0   1   5 2                 7
1893072 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools Duluth Public School District 271104001577 580 Rockridge Academy Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 06 12 2018   grade_7 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
1893079 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 2018   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
1893086 MN Stearns 73 school 2733510 742 Independent Districts and Schools St. Cloud Public School District 273351003368 43 St. Cloud Group Home Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2018   grade_7 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0     *   *     *   *   1.0 0 0 0   0 0     0   1   1 0                 1
1893098 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 2018   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
1893118 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001933 685 Stadium View Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 06 12 2018   grade_7 0.0 2.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *     *   *   2.0 0 2 0   0 0     0   0   2 0                 2
1893131 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 2018   grade_7 0.0 4.0 2.0   0.0 0.0     0.0   1.0   4.0 3.0     *   *     *   *   7.0 0 4 2   0 0     0   1   4 3                 7
1893176 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042005050 865 SW Metro JAF Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 06 12 2018   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
1893188 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602600 105 Riverside School Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 06 12 2018   grade_7 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     0   1   0 1                 1
1893206 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 High 05 12 2018   grade_7 1.0 0.0 1.0   0.0 0.0     0.0   1.0   3.0 0.0     *   *     *   *   3.0 1 0 1   0 0     0   1   3 0                 3
1893217 MN Wright 86 school 2700045 938 Special Education Cooperatives Meeker and Wright Special Education 270004505005 26 Sholund School For Girls Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 05 12 2018   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
1893227 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810004616 162 Pines School Day Program Miscellaneous Program (assignment is now limited) Alternative School No High 07 12 2018   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
1893243 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 03 12 2018   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   2.0   5.0 0.0     *   *     *   *   5.0 3 0 0   0 0     0   2   5 0                 5
1893302 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 High 05 12 2018   grade_7 0.0 2.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *     *   *   2.0 0 2 0   0 0     0   0   1 1                 2
1893330 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St. Paul-Maplewood Oakdale Public School District 272385004943 76 Prairiecare Maplewood Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2018   grade_7 4.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 3.0     *   *     *   *   4.0 4 0 0   0 0     0   0   1 3                 4
1893349 MN Stearns 73 school 2733510 742 Independent Districts and Schools St. Cloud Public School District 273351003369 66 St. Cloud Hospital Programs Non-Residential Educational Oversight to Public Care and Treatment Day Program Alternative School No Other PK 12 2018   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
1893362 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 2018   grade_7 9.0 2.0 0.0   0.0 0.0     0.0   1.0   6.0 6.0     0.0   1.0     *   *   12.0 9 2 0   0 0     0   1   6 6     0 1         12
1893373 MN Swift 76 school 2704470 777 Independent Districts and Schools Benson Public School District 270447003708 112 Benson Day Treatment Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2018   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
1893387 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 2018   grade_7 3.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 2.0     *   *     *   *   4.0 3 0 1   0 0     0   0   2 2                 4
1893394 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 2018   grade_7 2.0 1.0 1.0   0.0 0.0     0.0   0.0   0.0 4.0     *   *     *   *   4.0 2 1 1   0 0     0   0   0 4                 4
1893406 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 2018   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
1893422 MN Washington 82 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226403646 35 ARIS Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2018   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
1893431 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 2018   grade_7 3.0 1.0 1.0   0.0 0.0     0.0   1.0   1.0 5.0     *   *     *   *   6.0 3 1 1   0 0     0   1   1 5                 6
1893438 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 2018   grade_7 4.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 4.0     *   *     *   *   5.0 4 1 0   0 0     0   0   1 4                 5
1893547 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 2018   grade_7 4.0 1.0 0.0   2.0 0.0     0.0   2.0   3.0 6.0     *   *     *   *   9.0 4 1 0   2 0     0   2   3 6                 9
1893570 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002860 315 Ronald McDonald House Private Alternative Program Alternative School No Other KG 12 2018   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
1893587 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 2018   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
1879819 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 2018   grade_7 93.0 1.0 2.0   0.0 0.0     0.0   4.0   58.0 42.0     1.0   0.0     43.0   17.0   100.0 93 1 2   0 0     0   4   58 42     1 0   43 17   100
1879826 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 2018   grade_7 26.0 0.0 1.0   8.0 1.0     0.0   1.0   22.0 15.0     *   *     22.0   10.0   37.0 26 0 1   8 1     0   1   22 15           22 10   37
1879833 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 2018   grade_7 10.0 0.0 0.0   0.0 0.0     0.0   1.0   6.0 5.0     0.0   0.0     2.0   0.0   11.0 10 0 0   0 0     0   1   6 5     0 0   2 0   11
1879840 MN Becker 3 school 2712360 23 Independent Districts and Schools Frazee-Vergas Public School District 271236000606 20 Frazee Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 64.0 1.0 1.0   0.0 0.0     0.0   7.0   32.0 41.0     0.0   3.0     31.0   13.0   73.0 64 1 1   0 0     0   7   32 41     0 3   31 13   73
1879847 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 2018   grade_7 45.0 0.0 0.0   7.0 0.0     0.0   5.0   28.0 29.0     0.0   1.0     40.0   14.0   57.0 45 0 0   7 0     0   5   28 29     0 1   40 14   57
1879854 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 2018   grade_7 9.0 1.0 0.0   15.0 0.0     0.0   0.0   15.0 10.0     0.0   0.0     17.0   9.0   25.0 9 1 0   15 0     0   0   15 10     0 0   17 9   25
1879861 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 2018   grade_7 53.0 0.0 3.0   0.0 0.0     0.0   2.0   20.0 38.0     0.0   0.0     8.0   5.0   58.0 53 0 3   0 0     0   2   20 38     0 0   8 5   58
1879868 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 2018   grade_7 11.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 8.0     0.0   0.0     4.0   1.0   11.0 11 0 0   0 0     0   0   3 8     0 0   4 1   11
1879875 MN Brown 8 school 2733210 84 Independent Districts and Schools Sleepy Eye Public School District 273321001451 20 Sleepy Eye Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 22.0 1.0 13.0   0.0 1.0     0.0   0.0   23.0 14.0     5.0   0.0     16.0   5.0   37.0 22 1 13   0 1     0   0   23 14     5 0   16 5   37
1879882 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 2018   grade_7 33.0 0.0 5.0   0.0 0.0     0.0   0.0   22.0 16.0     1.0   0.0     15.0   2.0   38.0 33 0 5   0 0     0   0   22 16     1 0   15 2   38
1879889 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 2018   grade_7 50.0 1.0 1.0   0.0 0.0     0.0   4.0   36.0 20.0     0.0   0.0     21.0   7.0   56.0 50 1 1   0 0     0   4   36 20     0 0   21 7   56
1879897 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 High 06 12 2018   grade_7 31.0 0.0 0.0   2.0 0.0     0.0   0.0   18.0 15.0     0.0   0.0     15.0   7.0   33.0 31 0 0   2 0     0   0   18 15     0 0   15 7   33
1879904 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 2018   grade_7 25.0 0.0 0.0   2.0 0.0     0.0   0.0   15.0 12.0     0.0   0.0     11.0   4.0   27.0 25 0 0   2 0     0   0   15 12     0 0   11 4   27
1879911 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 2018   grade_7 42.0 0.0 1.0   0.0 0.0     0.0   1.0   24.0 20.0     0.0   0.0     11.0   5.0   44.0 42 0 1   0 0     0   1   24 20     0 0   11 5   44
1879918 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 2018   grade_7 77.0 0.0 1.0   0.0 0.0     0.0   3.0   47.0 34.0     0.0   0.0     8.0   6.0   81.0 77 0 1   0 0     0   3   47 34     0 0   8 6   81
1879925 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 2018   grade_7 22.0 1.0 0.0   0.0 0.0     0.0   2.0   11.0 14.0     0.0   0.0     19.0   5.0   25.0 22 1 0   0 0     0   2   11 14     0 0   19 5   25
1879932 MN Cass 11 school 2702910 113 Independent Districts and Schools Walker-Hackensack-Akeley School District 270291001737 20 Walker-Hackensack-Akeley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 42.0 2.0 3.0   11.0 0.0     0.0   3.0   31.0 30.0     0.0   3.0     33.0   15.0   61.0 42 2 3   11 0     0   3   31 30     0 3   33 15   61
1879939 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 2018   grade_7 15.0 0.0 0.0   4.0 0.0     0.0   6.0   14.0 11.0     0.0   0.0     17.0   5.0   25.0 15 0 0   4 0     0   6   14 11     0 0   17 5   25
1879946 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 2018   grade_7 62.0 0.0 1.0   1.0 2.0     0.0   0.0   38.0 28.0     0.0   1.0     23.0   8.0   66.0 62 0 1   1 2     0   0   38 28     0 1   23 8   66
1879953 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 High 06 12 2018   grade_7 65.0 0.0 0.0   0.0 0.0     0.0   2.0   38.0 29.0     0.0   0.0     4.0   3.0   67.0 65 0 0   0 0     0   2   38 29     0 0   4 3   67
1879960 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 2018   grade_7 60.0 0.0 1.0   0.0 0.0     1.0   2.0   40.0 24.0     4.0   0.0     9.0   8.0   64.0 60 0 1   0 0     1   2   40 24     4 0   9 8   64
1879967 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 2018   grade_7 51.0 1.0 1.0   22.0 1.0     0.0   4.0   43.0 37.0     0.0   0.0     44.0   15.0   80.0 51 1 1   22 1     0   4   43 37     0 0   44 15   80
1879974 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 2018   grade_7 27.0 0.0 6.0   0.0 2.0     0.0   1.0   16.0 20.0     2.0   0.0     20.0   6.0   36.0 27 0 6   0 2     0   1   16 20     2 0   20 6   36
1879981 MN Crow Wing 18 school 2709750 182 Independent Districts and Schools Crosby-Ironton Public School District 270975000417 1 Crosby-Ironton Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 76.0 0.0 1.0   0.0 0.0     0.0   4.0   46.0 35.0     0.0   0.0     41.0   16.0   81.0 76 0 1   0 0     0   4   46 35     0 0   41 16   81

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