Data source: Big Local News · About: Big Local

4,953 rows where grade = "grade_8" and state = "MN" sorted by county_state_id

View and edit SQL

year

grade

  • grade_8 · 4,953
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
689011 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_8 101.0 3.0 1.0   0.0 0.0     0.0   2.0   52.0 55.0     0.0   0.0     46.0   12.0   107.0 101 3 1   0 0     0   2   52 55     0 0   46 12   107
689018 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_8 35.0 0.0 1.0   5.0 0.0     0.0   1.0   23.0 19.0     0.0   0.0     28.0   12.0   42.0 35 0 1   5 0     0   1   23 19     0 0   28 12   42
697682 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 22.0 0.0 0.0   0.0 0.0     0.0   0.0   13.0 9.0     0.0   0.0     17.0   8.0   22.0 22 0 0   0 0     0   0   13 9     0 0   17 8   22
702761 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_8 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
853416 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 3 07 12 2016   grade_8 75 0 0   4 0     0   3   40 42     0.0   0.0     33.0   14.0   82 75 0 0   4 0     0   3   40 42     0 0   33 14   82
853423 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 3 07 12 2016   grade_8 24 0 0   5 0     0   0   19 10     0.0   0.0     16.0   6.0   29 24 0 0   5 0     0   0   19 10     0 0   16 6   29
861881 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_8 17 0 1   3 0     0   0   10 11     0.0   0.0     13.0   4.0   21 17 0 1   3 0     0   0   10 11     0 0   13 4   21
1146099 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 3 07 12 2015   grade_8 83.0 2.0 2.0   2.0 0.0     0.0   3.0   44.0 48.0     0.0   0.0     46.0   9.0   92.0 83 2 2   2 0     0   3   44 48     0 0   46 9   92
1146106 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 3 07 12 2015   grade_8 18.0 1.0 1.0   3.0 0.0     0.0   0.0   11.0 12.0     0.0   0.0     12.0   4.0   23.0 18 1 1   3 0     0   0   11 12     0 0   12 4   23
1154559 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_8 16.0 0.0 0.0   2.0 0.0     0.0   0.0   8.0 10.0     0.0   0.0     12.0   5.0   18.0 16 0 0   2 0     0   0   8 10     0 0   12 5   18
1159457 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes 4 KG 12 2015   grade_8 0.0 0.0 0.0   2.0 0.0     0.0   0.0   0.0 2.0         *         *   2.0 0 0 0   2 0     0   0   0 2                 2
1711654 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 2021   grade_8 91 0 3   0 0     0   2   51 45     0.0   0.0     36.0   13.0   96 91 0 3   0 0     0   2   51 45     0 0   36 13   96
1711661 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 2021   grade_8 35 1 1   5 0     0   0   16 26     0.0   0.0     20.0   9.0   42 35 1 1   5 0     0   0   16 26     0 0   20 9   42
1720645 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_8 15 0 1   1 0     0   1   9 9     0.0   0.0     5.0   2.0   18 15 0 1   1 0     0   1   9 9     0 0   5 2   18
1725561 MN Aitkin 1 school 2700300 4177 Charter Schools Minisinaakwaang Leadership Academy 270030003730 10 Minisinaakwaang Leadership Academy Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2021   grade_8 0 0 0   3 0     0   0   2 1     *   *     *   *   3 0 0 0   3 0     0   0   2 1                 3
1825223 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 2020   grade_8 85.0 2.0 1.0   3.0 0.0     0.0   3.0   40.0 54.0     0.0   0.0     41.0   16.0   94.0 85 2 1   3 0     0   3   40 54     0 0   41 16   94
1825230 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 2020   grade_8 19.0 0.0 1.0   6.0 0.0     0.0   0.0   11.0 15.0     0.0   0.0     14.0   7.0   26.0 19 0 1   6 0     0   0   11 15     0 0   14 7   26
1834151 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_8 12.0 0.0 1.0   2.0 0.0     0.0   2.0   10.0 7.0     0.0   0.0     11.0   1.0   17.0 12 0 1   2 0     0   2   10 7     0 0   11 1   17
1839251 MN Aitkin 1 school 2700300 4177 Charter Schools Minisinaakwaang Leadership Academy 270030003730 10 Minisinaakwaang Leadership Academy Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   grade_8 0.0 0.0 0.0   2.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 0 0 0   2 0     0   0   2 0                 2
1879820 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_8 103.0 0.0 1.0   0.0 0.0     0.0   3.0   54.0 53.0     0.0   0.0     40.0   15.0   107.0 103 0 1   0 0     0   3   54 53     0 0   40 15   107
1879827 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_8 28.0 0.0 0.0   6.0 0.0     0.0   0.0   12.0 22.0     0.0   0.0     19.0   8.0   34.0 28 0 0   6 0     0   0   12 22     0 0   19 8   34
1888632 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_8 31.0 0.0 0.0   0.0 0.0     0.0   3.0   17.0 17.0     0.0   0.0     20.0   3.0   34.0 31 0 0   0 0     0   3   17 17     0 0   20 3   34
1893674 MN Aitkin 1 school 2700300 4177 Charter Schools Minisinaakwaang Leadership Academy 270030003730 10 Minisinaakwaang Leadership Academy Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2018   grade_8 0.0 0.0 0.0   2.0 0.0     0.0   0.0   0.0 2.0     *   *     *   *   2.0 0 0 0   2 0     0   0   0 2                 2
1944369 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000057 1 AITKIN SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_8 91.0 1.0 1.0   0.0 0.0     0.0   5.0   58.0 40.0     1.0   0.0     42.0   19.0   98.0 91 1 1   0 0     0   5   58 40     1 0   42 19   98
1944376 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 2019   grade_8 27.0 0.0 0.0   8.0 1.0     0.0   1.0   21.0 16.0     0.0   0.0     17.0   9.0   37.0 27 0 0   8 1     0   1   21 16     0 0   17 9   37
1953227 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 20.0 0.0 1.0   1.0 0.0     0.0   3.0   12.0 13.0     0.0   0.0     15.0   3.0   25.0 20 0 1   1 0     0   3   12 13     0 0   15 3   25
1958266 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2019   grade_8 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
689025 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_8 8.0 2.0 0.0   0.0 0.0     0.0   2.0   5.0 7.0     0.0   0.0     2.0   0.0   12.0 8 2 0   0 0     0   2   5 7     0 0   2 0   12
690338 MN Anoka 2 school 2700093 4008 Charter Schools PACT CHARTER SCHOOL 270009303030 30 PACT CHARTER SECONDARY Secondary School (Grades 7-12) Regular School Yes High 07 12 2017   grade_8 42.0 0.0 5.0   0.0 3.0     0.0   2.0   33.0 19.0     1.0   0.0     8.0   10.0   52.0 42 0 5   0 3     0   2   33 19     1 0   8 10   52
697269 MN Anoka 2 school 2700320 4185 Charter Schools DAVINCI ACADEMY 270032004268 10 DAVINCI ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_8 31.0 9.0 2.0   2.0 2.0     0.0   1.0   18.0 29.0     3.0   0.0     9.0   5.0   47.0 31 9 2   2 2     0   1   18 29     3 0   9 5   47
697279 MN Anoka 2 school 2700313 4186 Charter Schools GLOBAL ACADEMY 270031304294 10 GLOBAL ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_8 6.0 34.0 1.0   0.0 0.0     0.0   1.0   22.0 20.0     5.0   0.0     33.0   3.0   42.0 6 34 1   0 0     0   1   22 20     5 0   33 3   42
697686 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 ANOKA MIDDLE SCHOOL FOR THE ARTS Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 501.0 53.0 19.0   7.0 22.0     0.0   22.0   294.0 330.0     9.0   10.0     208.0   93.0   624.0 501 53 19   7 22     0   22   294 330     9 10   208 93   624
697690 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 COON RAPIDS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 265.0 74.0 24.0   3.0 33.0     0.0   16.0   213.0 202.0     26.0   9.0     220.0   53.0   415.0 265 74 24   3 33     0   16   213 202     26 9   220 53   415
697698 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 NORTHDALE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 264.0 38.0 26.0   4.0 37.0     0.0   14.0   192.0 191.0     10.0   13.0     161.0   72.0   383.0 264 38 26   4 37     0   14   192 191     10 13   161 72   383
697702 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 OAK VIEW MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 363.0 10.0 18.0   4.0 15.0     0.0   9.0   211.0 208.0     6.0   *     57.0   *   419.0 363 10 18   4 15     0   9   211 208     6     57     419
697706 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 303.0 23.0 18.0   3.0 24.0     1.0   13.0   194.0 191.0     9.0   2.0     87.0   40.0   385.0 303 23 18   3 24     1   13   194 191     9 2   87 40   385
697710 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810002784 166 CENTENNIAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 448.0 12.0 21.0   2.0 22.0     0.0   10.0   248.0 267.0     7.0   4.0     81.0   76.0   515.0 448 12 21   2 22     0   10   248 267     7 4   81 76   515
697714 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000395 17 COLUMBIA ACADEMY Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 27.0 79.0 72.0   2.0 11.0     2.0   10.0   116.0 87.0         *         *   203.0 27 79 72   2 11     2   10   116 87                 203
697719 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000610 23 FRIDLEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 88.0 76.0 29.0   3.0 21.0     0.0   8.0   110.0 115.0         4.0         29.0   225.0 88 76 29   3 21     0   8   110 115       4     29   225
697723 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000013 123 ST. FRANCIS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 297.0 4.0 11.0   2.0 15.0     0.0   7.0   160.0 176.0     10.0   0.0     85.0   *   336.0 297 4 11   2 15     0   7   160 176     10 0   85     336
697727 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001466 92 WESTWOOD MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 224.0 43.0 61.0   1.0 32.0     2.0   26.0   194.0 195.0     30.0   2.0     176.0   45.0   389.0 224 43 61   1 32     2   26   194 195     30 2   176 45   389
698663 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000396 16 COLUMBIA HEIGHTS SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2017   grade_8 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
699740 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   grade_8 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
699754 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_8 5.0 5.0 2.0   0.0 0.0     0.0   1.0   6.0 7.0         0.0         0.0   13.0 5 5 2   0 0     0   1   6 7       0     0   13
699760 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_8 36.0 0.0 1.0   0.0 0.0     0.0   1.0   22.0 16.0     0.0   *     14.0   0.0   38.0 36 0 1   0 0     0   1   22 16     0     14 0   38
700450 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 RIVER TRAIL LEARNING CTR @ LO JACOB Special Education Special Education School No Other KG 12 2017   grade_8 8.0 4.0 1.0   1.0 0.0     0.0   3.0   16.0 1.0     0.0   1.0     12.0   *   17.0 8 4 1   1 0     0   3   16 1     0 1   12     17
701118 MN Anoka 2 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226404643 40 Karner Blue Education Center Special Education Special Education School No Elementary KG 08 2017   grade_8 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
701651 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000002 464 ANTHONY LOUIS HOUSE Hospital/Medical/Partial Hospitalization Program Alternative School No Other 03 12 2017   grade_8 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
701744 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354004917 15 Saints Online Distance Learning Program OLL (State approved) Regular School No Other 03 12 2017   grade_8 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
701923 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810004655 158 Pines School - ACS Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 08 12 2017   grade_8 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
701931 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_8 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
701937 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810004620 161 Pines School - RJC Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 08 12 2017   grade_8 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
702249 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 08 12 2017   grade_8 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
702257 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_8 3.0 2.0 1.0   1.0 0.0     0.0   1.0   8.0 0.0         *         *   8.0 3 2 1   1 0     0   1   8 0                 8
853430 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 3 07 12 2016   grade_8 17 0 0   0 0     0   0   7 10         0.0         *   17 17 0 0   0 0     0   0   7 10       0         17
854760 MN Anoka 2 school 2700093 4008 Charter Schools PACT CHARTER SCHOOL 270009303030 30 PACT CHARTER SECONDARY Secondary School (Grades 7-12) Regular School Yes 3 07 12 2016   grade_8 44 1 5   0 1     0   1   24 28     0.0   0.0     7.0   13.0   52 44 1 5   0 1     0   1   24 28     0 0   7 13   52
861525 MN Anoka 2 school 2700320 4185 Charter Schools DAVINCI ACADEMY 270032004268 10 DAVINCI ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_8 31 4 1   2 3     0   0   20 21     0.0   0.0     11.0   4.0   41 31 4 1   2 3     0   0   20 21     0 0   11 4   41
861535 MN Anoka 2 school 2700313 4186 Charter Schools GLOBAL ACADEMY 270031304294 10 GLOBAL ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_8 11 35 0   0 0     0   0   20 26     14.0   0.0         5.0   46 11 35 0   0 0     0   0   20 26     14 0     5   46
861885 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 ANOKA MIDDLE SCHOOL FOR THE ARTS Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_8 487 46 25   8 22     0   11   270 329     14.0   8.0     208.0   87.0   599 487 46 25   8 22     0   11   270 329     14 8   208 87   599
861889 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 COON RAPIDS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_8 262 52 24   7 21     0   9   192 183     19.0   4.0     175.0   43.0   375 262 52 24   7 21     0   9   192 183     19 4   175 43   375
861897 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 NORTHDALE MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_8 274 53 20   9 29     0   11   193 203     15.0   11.0     167.0   52.0   396 274 53 20   9 29     0   11   193 203     15 11   167 52   396
861901 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 OAK VIEW MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_8 389 12 16   3 15     0   3   243 195     6.0   *     74.0   *   438 389 12 16   3 15     0   3   243 195     6     74     438
861905 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_8 302 27 8   0 27     1   12   189 188     7.0   5.0     92.0   42.0   377 302 27 8   0 27     1   12   189 188     7 5   92 42   377
861909 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810002784 166 CENTENNIAL MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_8 424 13 26   7 31     0   19   268 252     9.0   3.0     99.0   84.0   520 424 13 26   7 31     0   19   268 252     9 3   99 84   520
861913 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000395 17 COLUMBIA ACADEMY Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_8 57 79 77   4 11     0   9   111 126     42.0   6.0     191.0   45.0   237 57 79 77   4 11     0   9   111 126     42 6   191 45   237
861918 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000610 23 FRIDLEY MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_8 83 66 27   6 15     0   11   114 94     20.0   5.0     140.0   30.0   208 83 66 27   6 15     0   11   114 94     20 5   140 30   208
861922 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000013 123 ST. FRANCIS MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_8 330 2 9   3 7     0   8   188 171         *         *   359 330 2 9   3 7     0   8   188 171                 359
861926 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001466 92 WESTWOOD MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_8 243 47 40   3 32     1   20   193 193         2.0         *   386 243 47 40   3 32     1   20   193 193       2         386
863924 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 Education School No 4 06 12 2016   grade_8 1 1 0   0 0     0   0   1 1         *         *   2 1 1 0   0 0     0   0   1 1                 2
863940 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 Education School No 2 05 08 2016   grade_8 9 10 3   0 3     0   0   13 12     0.0   0.0     17.0   2.0   25 9 10 3   0 3     0   0   13 12     0 0   17 2   25
864672 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 RIVER TRAIL LEARNING CTR @ LO JACOB Special Education Special Education School No 4 KG 12 2016   grade_8 5 1 0   0 0     0   0   6 0         *         *   6 5 1 0   0 0     0   0   6 0                 6
865343 MN Anoka 2 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226404643 40 Karner Blue Education Center Special Education Special Education School No 1 KG 08 2016   grade_8 3 1 0   0 0     0   0   2 2         *         *   4 3 1 0   0 0     0   0   2 2                 4
865995 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000002 464 ANTHONY LOUIS HOUSE Hospital/Medical/Partial Hospitalization Program Alternative Education School No 4 03 12 2016   grade_8 1 0 0   0 0     0   0   0 1         *         *   1 1 0 0   0 0     0   0   0 1                 1
866250 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810004655 158 Pines School - ACS Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 3 08 12 2016   grade_8 1 0 0   0 0     0   0   1 0         *         *   1 1 0 0   0 0     0   0   1 0                 1
866257 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 Education School No 3 07 12 2016   grade_8 2 0 0   0 0     0   0   2 0         *         *   2 2 0 0   0 0     0   0   2 0                 2
866264 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810004620 161 Pines School - RJC Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 3 07 12 2016   grade_8 1 0 0   0 0     0   0   1 0         *         *   1 1 0 0   0 0     0   0   1 0                 1
866540 MN Anoka 2 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226404404 31 THE WILLOWS Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 3 07 12 2016   grade_8 1 0 0   0 0     0   0   0 1         *         *   1 1 0 0   0 0     0   0   0 1                 1
866590 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 Education School No 3 07 12 2016   grade_8 0 1 0   0 0     0   0   1 0         *         *   1 0 1 0   0 0     0   0   1 0                 1
866600 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 Education School No 4 KG 12 2016   grade_8 6 0 1   1 0     0   1   9 0         *         *   9 6 0 1   1 0     0   1   9 0                 9
1146113 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 3 07 12 2015   grade_8 8.0 0.0 0.0   0.0 0.0     0.0   1.0   6.0 3.0         *         *   9.0 8 0 0   0 0     0   1   6 3                 9
1147454 MN Anoka 2 school 2700093 4008 Charter Schools PACT CHARTER SCHOOL 270009303030 30 PACT CHARTER SECONDARY Secondary School (Grades 7-12) Regular School Yes 3 07 12 2015   grade_8 45.0 1.0 4.0   0.0 0.0     0.0   2.0   24.0 28.0     0.0   0.0     7.0   12.0   52.0 45 1 4   0 0     0   2   24 28     0 0   7 12   52
1154239 MN Anoka 2 school 2700320 4185 Charter Schools DAVINCI ACADEMY 270032004268 10 DAVINCI ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_8 22.0 3.0 0.0   1.0 2.0     0.0   2.0   17.0 13.0     1.0   0.0     4.0   8.0   30.0 22 3 0   1 2     0   2   17 13     1 0   4 8   30
1154249 MN Anoka 2 school 2700313 4186 Charter Schools GLOBAL ACADEMY 270031304294 10 GLOBAL ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_8 13.0 36.0 0.0   0.0 0.0     0.0   0.0   20.0 29.0     5.0   0.0     43.0   1.0   49.0 13 36 0   0 0     0   0   20 29     5 0   43 1   49
1154448 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951004527 19 ACHIEVE Public Area Learning Program ALP (State approved) Alternative Education School No 2 06 08 2015   grade_8 4.0 4.0 1.0   0.0 1.0     0.0   2.0   9.0 3.0     2.0   0.0         3.0   12.0 4 4 1   0 1     0   2   9 3     2 0     3   12
1154563 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 ANOKA MIDDLE SCHOOL FOR THE ARTS Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_8 550.0 46.0 25.0   10.0 23.0     0.0   10.0   328.0 336.0     16.0   7.0     238.0   72.0   664.0 550 46 25   10 23     0   10   328 336     16 7   238 72   664
1154567 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 COON RAPIDS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_8 264.0 50.0 31.0   11.0 32.0     0.0   15.0   209.0 194.0     30.0   6.0     189.0   49.0   403.0 264 50 31   11 32     0   15   209 194     30 6   189 49   403
1154575 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 NORTHDALE MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_8 251.0 56.0 23.0   8.0 44.0     0.0   5.0   213.0 174.0     35.0   12.0     178.0   78.0   387.0 251 56 23   8 44     0   5   213 174     35 12   178 78   387
1154579 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 OAK VIEW MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_8 407.0 13.0 10.0   0.0 12.0     0.0   6.0   213.0 235.0     11.0   1.0     68.0   *   448.0 407 13 10   0 12     0   6   213 235     11 1   68     448
1154583 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_8 330.0 20.0 10.0   1.0 25.0     1.0   3.0   188.0 202.0     8.0   3.0     92.0   46.0   390.0 330 20 10   1 25     1   3   188 202     8 3   92 46   390
1154587 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810002784 166 CENTENNIAL MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_8 418.0 9.0 25.0   4.0 22.0     0.0   8.0   247.0 239.0     3.0   2.0     99.0   83.0   486.0 418 9 25   4 22     0   8   247 239     3 2   99 83   486
1154591 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000395 17 COLUMBIA ACADEMY Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_8 48.0 73.0 73.0   4.0 14.0     0.0   8.0   103.0 117.0     45.0   7.0         31.0   220.0 48 73 73   4 14     0   8   103 117     45 7     31   220
1154596 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000610 23 FRIDLEY MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_8 102.0 49.0 26.0   6.0 23.0     0.0   9.0   109.0 106.0     31.0   2.0     135.0   28.0   215.0 102 49 26   6 23     0   9   109 106     31 2   135 28   215
1154600 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000013 123 ST. FRANCIS MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_8 309.0 1.0 9.0   5.0 12.0     1.0   12.0   167.0 182.0         *         *   349.0 309 1 9   5 12     1   12   167 182                 349
1154604 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001466 92 WESTWOOD MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_8 251.0 36.0 50.0   0.0 42.0     0.0   15.0   189.0 205.0         *         *   394.0 251 36 50   0 42     0   15   189 205                 394
1156560 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 Education School No 4 06 12 2015   grade_8 2.0 2.0 0.0   0.0 0.0     0.0   2.0   4.0 2.0         *         *   6.0 2 2 0   0 0     0   2   4 2                 6
1156574 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 Education School No 2 05 08 2015   grade_8 7.0 3.0 1.0   1.0 0.0     0.0   2.0   10.0 4.0     0.0   2.0     10.0   0.0   14.0 7 3 1   1 0     0   2   10 4     0 2   10 0   14
1157258 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 RIVER TRAIL LEARNING CTR @ LO JACOB Special Education Special Education School No 4 KG 12 2015   grade_8 6.0 0.0 0.0   2.0 0.0     0.0   0.0   6.0 2.0         *         *   8.0 6 0 0   2 0     0   0   6 2                 8
1158609 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 Education School No 3 08 12 2015   grade_8 1.0 1.0 1.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 1 1 1   0 0     0   0   3 0                 3
1158616 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810004620 161 Pines School - RJC Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 3 07 12 2015   grade_8 2.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 1.0         *         *   3.0 2 0 0   0 0     0   1   2 1                 3
1158911 MN Anoka 2 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226404404 31 THE WILLOWS Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 3 07 12 2015   grade_8 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

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