Data source: Big Local News · About: Big Local

4,774 rows where grade = "grade_7" and state = "MN" sorted by county_state_id

View and edit SQL

year

grade

  • grade_7 · 4,774
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
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
697681 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_7 30.0 0.0 0.0   0.0 0.0     0.0   3.0   17.0 16.0     0.0   0.0     21.0   4.0   33.0 30 0 0   0 0     0   3   17 16     0 0   21 4   33
702760 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_7 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
853415 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_7 96 2 1   1 0     0   2   49 53     0.0   0.0     45.0   8.0   102 96 2 1   1 0     0   2   49 53     0 0   45 8   102
853422 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_7 36 1 2   6 0     0   1   27 19     0.0   4.0     34.0   15.0   46 36 1 2   6 0     0   1   27 19     0 4   34 15   46
861880 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_7 19 0 0   0 0     0   1   11 9     0.0   0.0     16.0   5.0   20 19 0 0   0 0     0   1   11 9     0 0   16 5   20
1146098 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_7 73.0 0.0 0.0   2.0 0.0     0.0   2.0   38.0 39.0     0.0   0.0     29.0   10.0   77.0 73 0 0   2 0     0   2   38 39     0 0   29 10   77
1146105 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_7 23.0 0.0 1.0   8.0 0.0     0.0   0.0   20.0 12.0         0.0     19.0   7.0   32.0 23 0 1   8 0     0   0   20 12       0   19 7   32
1154558 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_7 16.0 0.0 1.0   3.0 0.0     0.0   0.0   9.0 11.0     0.0   0.0     11.0   4.0   20.0 16 0 1   3 0     0   0   9 11     0 0   11 4   20
1159456 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_7 1.0 0.0 0.0   2.0 0.0     0.0   1.0   3.0 1.0         *         *   4.0 1 0 0   2 0     0   1   3 1                 4
1711653 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_7 85 1 1   1 2     0   3   42 51     1.0   0.0     29.0   16.0   93 85 1 1   1 2     0   3   42 51     1 0   29 16   93
1711660 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_7 25 0 0   4 0     0   1   17 13     0.0   0.0     9.0   8.0   30 25 0 0   4 0     0   1   17 13     0 0   9 8   30
1720644 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_7 13 1 0   2 0     0   0   7 9     0.0   0.0     10.0   5.0   16 13 1 0   2 0     0   0   7 9     0 0   10 5   16
1725560 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_7 0 0 0   5 0     0   1   2 4     *   *     *   *   6 0 0 0   5 0     0   1   2 4                 6
1825222 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_7 92.0 1.0 3.0   0.0 0.0     0.0   2.0   53.0 45.0     0.0   1.0     43.0   13.0   98.0 92 1 3   0 0     0   2   53 45     0 1   43 13   98
1825229 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_7 31.0 0.0 0.0   8.0 0.0     0.0   0.0   15.0 24.0     *   0.0     19.0   7.0   39.0 31 0 0   8 0     0   0   15 24       0   19 7   39
1834150 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_7 17.0 0.0 1.0   0.0 0.0     0.0   0.0   10.0 8.0     0.0   0.0     9.0   3.0   18.0 17 0 1   0 0     0   0   10 8     0 0   9 3   18
1839250 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_7 0.0 0.0 0.0   2.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 0 0   2 0     0   0   1 1                 2
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
1888631 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_7 19.0 0.0 0.0   1.0 0.0     0.0   2.0   12.0 10.0     0.0   0.0     12.0   2.0   22.0 19 0 0   1 0     0   2   12 10     0 0   12 2   22
1944368 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_7 80.0 1.0 1.0   2.0 0.0     0.0   3.0   36.0 51.0     0.0   0.0     40.0   10.0   87.0 80 1 1   2 0     0   3   36 51     0 0   40 10   87
1944375 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_7 22.0 0.0 1.0   6.0 0.0     0.0   0.0   14.0 15.0     0.0   0.0     14.0   9.0   29.0 22 0 1   6 0     0   0   14 15     0 0   14 9   29
1953226 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_7 12.0 0.0 0.0   1.0 0.0     0.0   1.0   9.0 5.0     0.0   0.0     9.0   1.0   14.0 12 0 0   1 0     0   1   9 5     0 0   9 1   14
1958265 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_7 0.0 0.0 0.0   2.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 0 0   2 0     0   0   1 1                 2
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
690337 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_7 45.0 0.0 2.0   1.0 1.0     0.0   3.0   26.0 26.0     0.0   0.0     6.0   5.0   52.0 45 0 2   1 1     0   3   26 26     0 0   6 5   52
697268 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_7 32.0 7.0 2.0   1.0 5.0     0.0   3.0   26.0 24.0     0.0   0.0     9.0   10.0   50.0 32 7 2   1 5     0   3   26 24     0 0   9 10   50
697278 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_7 11.0 37.0 0.0   0.0 1.0     0.0   0.0   20.0 29.0     5.0   0.0         1.0   49.0 11 37 0   0 1     0   0   20 29     5 0     1   49
697454 MN Anoka 2 school 2700390 4224 Charter Schools Star of the North Academy Charter School 270039004759 10 Star of the North Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 6.0 5.0 0.0   0.0 1.0     0.0   0.0   6.0 6.0     3.0   0.0     10.0   0.0   12.0 6 5 0   0 1     0   0   6 6     3 0   10 0   12
697685 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_7 480.0 58.0 39.0   9.0 35.0     0.0   16.0   320.0 317.0     21.0   8.0     218.0   106.0   637.0 480 58 39   9 35     0   16   320 317     21 8   218 106   637
697689 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_7 254.0 54.0 36.0   5.0 20.0     0.0   16.0   174.0 211.0     20.0   4.0     179.0   48.0   385.0 254 54 36   5 20     0   16   174 211     20 4   179 48   385
697697 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_7 258.0 46.0 43.0   7.0 31.0     0.0   25.0   224.0 186.0     25.0   7.0     186.0   69.0   410.0 258 46 43   7 31     0   25   224 186     25 7   186 69   410
697701 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_7 376.0 14.0 11.0   5.0 13.0     1.0   5.0   228.0 197.0         *         48.0   425.0 376 14 11   5 13     1   5   228 197             48   425
697705 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_7 324.0 35.0 21.0   0.0 32.0     0.0   28.0   223.0 217.0     12.0   8.0     113.0   52.0   440.0 324 35 21   0 32     0   28   223 217     12 8   113 52   440
697709 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_7 441.0 13.0 26.0   4.0 22.0     0.0   24.0   264.0 266.0         *         *   530.0 441 13 26   4 22     0   24   264 266                 530
697713 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_7 45.0 90.0 107.0   1.0 8.0     0.0   18.0   131.0 138.0         *         41.0   269.0 45 90 107   1 8     0   18   131 138             41   269
697718 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_7 98.0 71.0 26.0   1.0 18.0     1.0   21.0   118.0 118.0     18.0   *     148.0   *   236.0 98 71 26   1 18     1   21   118 118     18     148     236
697722 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_7 261.0 5.0 13.0   2.0 10.0     0.0   20.0   162.0 149.0         0.0         50.0   311.0 261 5 13   2 10     0   20   162 149       0     50   311
697726 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_7 257.0 37.0 68.0   2.0 30.0     0.0   29.0   193.0 230.0     29.0   3.0     169.0   47.0   423.0 257 37 68   2 30     0   29   193 230     29 3   169 47   423
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
700449 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_7 8.0 1.0 0.0   0.0 0.0     0.0   0.0   6.0 3.0         *         *   9.0 8 1 0   0 0     0   0   6 3                 9
701117 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_7 4.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0         *         *   4.0 4 0 0   0 0     0   0   3 1                 4
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
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
853429 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_7 10 1 0   0 0     0   2   6 7     0.0   *     1.0   0.0   13 10 1 0   0 0     0   2   6 7     0     1 0   13
854759 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_7 42 0 5   0 3     0   2   31 21     1.0   0.0     9.0   12.0   52 42 0 5   0 3     0   2   31 21     1 0   9 12   52
861524 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_7 33 5 3   1 4     0   2   19 29     1.0   0.0     9.0   5.0   48 33 5 3   1 4     0   2   19 29     1 0   9 5   48
861534 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_7 11 37 1   0 0     0   1   23 27     7.0   0.0     40.0   3.0   50 11 37 1   0 0     0   1   23 27     7 0   40 3   50
861884 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_7 490 50 16   7 23     0   19   281 324     15.0   4.0     215.0   100.0   605 490 50 16   7 23     0   19   281 324     15 4   215 100   605
861888 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_7 258 72 27   2 31     0   16   206 200     29.0   6.0     205.0   54.0   406 258 72 27   2 31     0   16   206 200     29 6   205 54   406
861896 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_7 246 39 29   5 36     0   16   187 184     9.0   9.0     153.0   65.0   371 246 39 29   5 36     0   16   187 184     9 9   153 65   371
861900 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_7 357 9 18   3 15     0   8   210 200         *     62.0   *   410 357 9 18   3 15     0   8   210 200           62     410
861904 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_7 306 22 17   2 21     1   11   193 187     6.0   2.0     78.0   45.0   380 306 22 17   2 21     1   11   193 187     6 2   78 45   380
861908 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_7 445 10 23   2 20     0   8   240 268     7.0   4.0     88.0   81.0   508 445 10 23   2 20     0   8   240 268     7 4   88 81   508
861912 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_7 38 69 71   5 12     2   15   118 94     28.0   4.0     180.0   35.0   212 38 69 71   5 12     2   15   118 94     28 4   180 35   212
861917 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_7 95 68 33   3 20     0   7   113 113         *         *   226 95 68 33   3 20     0   7   113 113                 226
861921 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_7 342 4 10   3 15     0   8   190 192         *         *   382 342 4 10   3 15     0   8   190 192                 382
861925 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_7 231 45 55   1 34     2   25   197 196     30.0   *     174.0   57.0   393 231 45 55   1 34     2   25   197 196     30     174 57   393
863923 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_7 2 0 0   0 0     0   0   2 0         *         *   2 2 0 0   0 0     0   0   2 0                 2
863939 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_7 7 6 2   0 0     0   0   5 10         *         *   15 7 6 2   0 0     0   0   5 10                 15
864671 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_7 11 1 2   1 0     0   3   15 3     0.0   2.0         *   18 11 1 2   1 0     0   3   15 3     0 2         18
865342 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_7 6 3 1   0 0     0   0   8 2     0.0   0.0     3.0   *   10 6 3 1   0 0     0   0   8 2     0 0   3     10
866256 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_7 0 1 0   0 0     0   0   0 1         *         *   1 0 1 0   0 0     0   0   0 1                 1
866263 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_7 1 0 0   0 0     0   0   1 0         *         *   1 1 0 0   0 0     0   0   1 0                 1
866589 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_7 1 0 0   0 0     0   0   1 0         *         *   1 1 0 0   0 0     0   0   1 0                 1
866599 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_7 3 4 0   1 0     0   1   9 0         *         *   9 3 4 0   1 0     0   1   9 0                 9
1146112 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_7 14.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 8.0         0.0         *   14.0 14 0 0   0 0     0   0   6 8       0         14
1147453 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_7 46.0 1.0 4.0   0.0 1.0     0.0   1.0   27.0 26.0     0.0   0.0     8.0   11.0   53.0 46 1 4   0 1     0   1   27 26     0 0   8 11   53
1154238 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_7 31.0 4.0 1.0   1.0 4.0     0.0   0.0   21.0 20.0     0.0   0.0     8.0   4.0   41.0 31 4 1   1 4     0   0   21 20     0 0   8 4   41
1154248 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_7 14.0 35.0 0.0   0.0 0.0     0.0   0.0   24.0 25.0     13.0   0.0         5.0   49.0 14 35 0   0 0     0   0   24 25     13 0     5   49
1154447 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_7 2.0 6.0 3.0   0.0 0.0     0.0   2.0   8.0 5.0     2.0   2.0         6.0   13.0 2 6 3   0 0     0   2   8 5     2 2     6   13
1154562 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_7 491.0 45.0 23.0   9.0 23.0     0.0   9.0   267.0 333.0     14.0   7.0     209.0   95.0   600.0 491 45 23   9 23     0   9   267 333     14 7   209 95   600
1154566 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_7 270.0 51.0 27.0   7.0 19.0     0.0   9.0   197.0 186.0     18.0   8.0     183.0   53.0   383.0 270 51 27   7 19     0   9   197 186     18 8   183 53   383
1154574 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_7 279.0 52.0 21.0   9.0 29.0     0.0   11.0   198.0 203.0     18.0   9.0     173.0   49.0   401.0 279 52 21   9 29     0   11   198 203     18 9   173 49   401
1154578 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_7 381.0 13.0 12.0   4.0 13.0     0.0   4.0   237.0 190.0     2.0   1.0     67.0   *   427.0 381 13 12   4 13     0   4   237 190     2 1   67     427
1154582 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_7 306.0 25.0 8.0   1.0 26.0     1.0   7.0   188.0 186.0     8.0   2.0     86.0   *   374.0 306 25 8   1 26     1   7   188 186     8 2   86     374
1154586 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_7 421.0 14.0 23.0   8.0 30.0     0.0   17.0   269.0 244.0     8.0   2.0     103.0   84.0   513.0 421 14 23   8 30     0   17   269 244     8 2   103 84   513
1154590 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_7 62.0 72.0 72.0   2.0 12.0     0.0   7.0   110.0 117.0     33.0   5.0         35.0   227.0 62 72 72   2 12     0   7   110 117     33 5     35   227
1154595 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_7 97.0 58.0 32.0   7.0 20.0     0.0   11.0   125.0 100.0     29.0   2.0     151.0   35.0   225.0 97 58 32   7 20     0   11   125 100     29 2   151 35   225
1154599 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_7 335.0 0.0 7.0   2.0 8.0     0.0   8.0   184.0 176.0         *         *   360.0 335 0 7   2 8     0   8   184 176                 360
1154603 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_7 247.0 41.0 34.0   1.0 32.0     1.0   17.0   185.0 188.0         0.0         *   373.0 247 41 34   1 32     1   17   185 188       0         373
1156559 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_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
1156573 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_7 4.0 7.0 0.0   0.0 0.0     0.0   0.0   5.0 6.0     0.0   0.0     9.0   0.0   11.0 4 7 0   0 0     0   0   5 6     0 0   9 0   11
1157257 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_7 4.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0         *         *   4.0 4 0 0   0 0     0   0   3 1                 4
1157915 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 2015   grade_7 3.0 1.0 0.0   0.0 0.0     0.0   1.0   3.0 2.0         *         *   5.0 3 1 0   0 0     0   1   3 2                 5
1158615 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_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
1158961 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 2015   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
1158970 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 2015   grade_7 2.0 2.0 2.0   0.0 0.0     0.0   1.0   7.0 0.0         *         *   7.0 2 2 2   0 0     0   1   7 0                 7
1159279 MN Anoka 2 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226404775 27 LIFESPAN Educational Oversight to Public Care and Treatment Day Program Alternative Education School No 4 KG 12 2015   grade_7 5.0 2.0 0.0   1.0 0.0     0.0   0.0   4.0 4.0         *         *   8.0 5 2 0   1 0     0   0   4 4                 8
1711667 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 2021   grade_7 11 1 0   0 0     0   0   6 6     0.0   0.0     1.0   0.0   12 11 1 0   0 0     0   0   6 6     0 0   1 0   12
1712966 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 2021   grade_7 50 1 0   0 0     0   2   23 30     2.0   0.0     5.0   10.0   53 50 1 0   0 0     0   2   23 30     2 0   5 10   53
1720072 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 2021   grade_7 50 12 2   0 6     0   4   34 40     1.0   0.0     11.0   8.0   74 50 12 2   0 6     0   4   34 40     1 0   11 8   74
1720279 MN Anoka 2 school 2700390 4224 Charter Schools Star of the North Academy Charter School 270039004759 10 Star of the North Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 8 5 0   0 0     0   0   5 8     4.0   0.0     8.0   0.0   13 8 5 0   0 0     0   0   5 8     4 0   8 0   13
1720648 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 2021   grade_7 398 77 48   1 32     0   43   307 292     26.0   3.0     185.0   87.0   599 398 77 48   1 32     0   43   307 292     26 3   185 87   599
1720652 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 2021   grade_7 281 106 40   6 37     1   58   258 271     35.0   19.0     248.0   91.0   529 281 106 40   6 37     1   58   258 271     35 19   248 91   529
1720660 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 2021   grade_7 249 56 30   2 41     2   35   216 199     24.0   7.0     118.0   46.0   415 249 56 30   2 41     2   35   216 199     24 7   118 46   415
1720664 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 2021   grade_7 331 17 13   3 16     0   24   226 178     9.0   4.0     65.0   *   404 331 17 13   3 16     0   24   226 178     9 4   65     404

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