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,674
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
1720668 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 2021   grade_7 186 27 8   1 24     0   25   137 134     *   3.0     64.0   *   271 186 27 8   1 24     0   25   137 134       3   64     271
1720672 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 2021   grade_7 379 39 35   0 31     2   30   247 269     21.0   2.0     71.0   87.0   516 379 39 35   0 31     2   30   247 269     21 2   71 87   516
1720676 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000395 17 Columbia Academy Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 43 68 101   3 9     1   21   124 122     59.0   3.0     199.0   47.0   246 43 68 101   3 9     1   21   124 122     59 3   199 47   246
1720681 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 2021   grade_7 60 94 30   5 13     0   24   117 109     *   *     *   *   226 60 94 30   5 13     0   24   117 109                 226
1720685 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000013 123 St. Francis Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 233 2 14   2 15     0   15   127 154     4.0   2.0     69.0   33.0   281 233 2 14   2 15     0   15   127 154     4 2   69 33   281
1720690 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333001466 92 Westwood Intermediate and Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 276 55 77   4 38     0   36   231 255     44.0   2.0     143.0   64.0   486 276 55 77   4 38     0   36   231 255     44 2   143 64   486
1721633 MN Anoka 2 school 2700380 4213 Charter Schools Prodeo Academy 270038005319 12 Prodeo Academy Columbia Heights Middle Middle School (Grades 5-8) Regular School Yes Middle 05 07 2021   grade_7 1 32 17   0 0     0   1   25 26     7.0   6.0     38.0   7.0   51 1 32 17   0 0     0   1   25 26     7 6   38 7   51
1722801 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 2021   grade_7 0 0 0   0 0     0   1   0 1     *   *     *   *   1 0 0 0   0 0     0   1   0 1                 1
1722815 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 2021   grade_7 0 0 1   1 0     0   1   1 2     *   *     *   *   3 0 0 1   1 0     0   1   1 2                 3
1722820 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004980 18 Saints Academy Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2021   grade_7 31 0 2   0 2     0   4   23 16     *   *     *   *   39 31 0 2   0 2     0   4   23 16                 39
1723409 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 River Trail Learning Center at LO Jacob Special Education Special Education School No Other KG 12 2021   grade_7 16 1 0   0 0     0   4   18 3     0.0   *     *   *   21 16 1 0   0 0     0   4   18 3     0           21
1723982 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 2021   grade_7 10 3 1   0 0     0   0   10 4     2.0   0.0     3.0   *   14 10 3 1   0 0     0   0   10 4     2 0   3     14
1724725 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004917 15 Saints Online Distance Learning Program OLL (State approved) Regular School No Other 03 12 2021   grade_7 2 1 0   0 0     0   0   2 1     *   *     *   *   3 2 1 0   0 0     0   0   2 1                 3
1725174 MN Anoka 2 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226405176 26 Cambia Hills Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 02 12 2021   grade_7 1 0 0   0 0     0   1   0 2     *   *     *   *   2 1 0 0   0 0     0   1   0 2                 2
1825236 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 2020   grade_7 9.0 1.0 1.0   0.0 2.0     0.0   2.0   8.0 7.0     *   0.0         *   15.0 9 1 1   0 2     0   2   8 7       0         15
1826550 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 2020   grade_7 48.0 2.0 2.0   0.0 1.0     0.0   1.0   30.0 24.0     2.0   0.0     6.0   9.0   54.0 48 2 2   0 1     0   1   30 24     2 0   6 9   54
1833623 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 2020   grade_7 43.0 3.0 4.0   1.0 5.0     0.0   8.0   35.0 29.0     2.0   0.0     14.0   9.0   64.0 43 3 4   1 5     0   8   35 29     2 0   14 9   64
1833831 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 2020   grade_7 1.0 4.0 0.0   0.0 2.0     0.0   0.0   3.0 4.0     *   *         *   7.0 1 4 0   0 2     0   0   3 4                 7
1834154 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 2020   grade_7 402.0 77.0 33.0   3.0 23.0     1.0   51.0   285.0 305.0     16.0   10.0     211.0   104.0   590.0 402 77 33   3 23     1   51   285 305     16 10   211 104   590
1834158 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 2020   grade_7 271.0 105.0 49.0   3.0 38.0     2.0   52.0   271.0 249.0     37.0   24.0     286.0   91.0   520.0 271 105 49   3 38     2   52   271 249     37 24   286 91   520
1834166 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 2020   grade_7 277.0 48.0 43.0   2.0 42.0     0.0   39.0   252.0 199.0     29.0   4.0     167.0   85.0   451.0 277 48 43   2 42     0   39   252 199     29 4   167 85   451
1834170 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 2020   grade_7 364.0 23.0 18.0   1.0 13.0     0.0   25.0   233.0 211.0     8.0   0.0     69.0   *   444.0 364 23 18   1 13     0   25   233 211     8 0   69     444
1834174 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 2020   grade_7 230.0 21.0 18.0   0.0 21.0     0.0   22.0   174.0 138.0     6.0   5.0     63.0   43.0   312.0 230 21 18   0 21     0   22   174 138     6 5   63 43   312
1834178 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 2020   grade_7 417.0 29.0 30.0   2.0 31.0     0.0   33.0   260.0 282.0     *   4.0     90.0   83.0   542.0 417 29 30   2 31     0   33   260 282       4   90 83   542
1834182 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 2020   grade_7 35.0 73.0 107.0   4.0 7.0     0.0   15.0   128.0 113.0     *   *         *   241.0 35 73 107   4 7     0   15   128 113                 241
1834187 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 2020   grade_7 41.0 77.0 25.0   1.0 12.0     0.0   15.0   74.0 97.0     21.0   2.0         26.0   171.0 41 77 25   1 12     0   15   74 97     21 2     26   171
1834191 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000013 123 St. Francis Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 160.0 1.0 10.0   4.0 7.0     0.0   12.0   101.0 93.0     *   0.0         *   194.0 160 1 10   4 7     0   12   101 93       0         194
1834196 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333001466 92 Westwood Intermediate and Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 261.0 67.0 72.0   5.0 30.0     2.0   32.0   251.0 218.0     *   6.0         *   469.0 261 67 72   5 30     2   32   251 218       6         469
1836285 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 2020   grade_7 0.0 1.0 1.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 1 1   0 0     0   0   1 1                 2
1836299 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 2020   grade_7 5.0 5.0 0.0   1.0 0.0     0.0   1.0   7.0 5.0     0.0   0.0         0.0   12.0 5 5 0   1 0     0   1   7 5     0 0     0   12
1836305 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004980 18 Saints Academy Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2020   grade_7 107.0 0.0 6.0   0.0 7.0     0.0   10.0   72.0 58.0     9.0   *     43.0   *   130.0 107 0 6   0 7     0   10   72 58     9     43     130
1836929 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 2020   grade_7 5.0 1.0 1.0   0.0 0.0     0.0   0.0   6.0 1.0     *   *         *   7.0 5 1 1   0 0     0   0   6 1                 7
1837535 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 2020   grade_7 5.0 1.0 0.0   0.0 0.0     0.0   0.0   2.0 4.0     *   *         *   6.0 5 1 0   0 0     0   0   2 4                 6
1838311 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004917 15 Saints Online Distance Learning Program OLL (State approved) Regular School No Other 03 12 2020   grade_7 2.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 2 0 1   0 0     0   0   2 1                 3
1838506 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 High 07 12 2020   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
1838512 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 07 12 2020   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
1838833 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School Dist 270951005164 810 Columbia Academy Anchor Program Educational Oversight to Public Care and Treatment Day Program Alternative School No Middle 06 08 2020   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 1 0   0 0     0   0   0 1                 1
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
1881148 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 2018   grade_7 47.0 1.0 1.0   0.0 1.0     0.0   3.0   30.0 23.0     2.0   0.0     12.0   10.0   53.0 47 1 1   0 1     0   3   30 23     2 0   12 10   53
1888167 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 2018   grade_7 36.0 4.0 2.0   1.0 8.0     0.0   1.0   25.0 27.0     0.0   0.0     10.0   4.0   52.0 36 4 2   1 8     0   1   25 27     0 0   10 4   52
1888177 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 2018   grade_7 9.0 37.0 0.0   0.0 1.0     0.0   0.0   17.0 30.0     5.0   0.0     40.0   5.0   47.0 9 37 0   0 1     0   0   17 30     5 0   40 5   47
1888366 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 2018   grade_7 6.0 3.0 0.0   0.0 2.0     0.0   0.0   10.0 1.0     *   0.0     7.0   2.0   11.0 6 3 0   0 2     0   0   10 1       0   7 2   11
1888635 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 2018   grade_7 459.0 55.0 29.0   7.0 22.0     1.0   24.0   270.0 327.0     20.0   9.0     200.0   66.0   597.0 459 55 29   7 22     1   24   270 327     20 9   200 66   597
1888639 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 2018   grade_7 228.0 63.0 41.0   5.0 29.0     0.0   26.0   205.0 187.0     21.0   6.0     202.0   54.0   392.0 228 63 41   5 29     0   26   205 187     21 6   202 54   392
1888647 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 2018   grade_7 221.0 62.0 36.0   2.0 40.0     0.0   29.0   198.0 192.0     23.0   7.0     149.0   66.0   390.0 221 62 36   2 40     0   29   198 192     23 7   149 66   390
1888651 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 2018   grade_7 352.0 11.0 9.0   2.0 11.0     1.0   16.0   205.0 197.0     3.0   4.0     57.0   *   402.0 352 11 9   2 11     1   16   205 197     3 4   57     402
1888655 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 2018   grade_7 321.0 32.0 13.0   1.0 38.0     0.0   14.0   204.0 215.0     8.0   2.0     94.0   47.0   419.0 321 32 13   1 38     0   14   204 215     8 2   94 47   419
1888659 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 2018   grade_7 399.0 25.0 22.0   2.0 24.0     1.0   20.0   262.0 231.0     *   *     *   *   493.0 399 25 22   2 24     1   20   262 231                 493
1888663 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000395 17 Columbia Academy Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 48.0 91.0 88.0   7.0 14.0     0.0   19.0   130.0 137.0     59.0   8.0     205.0   31.0   267.0 48 91 88   7 14     0   19   130 137     59 8   205 31   267
1888668 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 2018   grade_7 64.0 75.0 34.0   2.0 15.0     0.0   15.0   111.0 94.0     25.0   1.0     142.0   31.0   205.0 64 75 34   2 15     0   15   111 94     25 1   142 31   205
1888672 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 2018   grade_7 266.0 1.0 13.0   1.0 8.0     0.0   18.0   144.0 163.0     5.0   2.0     72.0   35.0   307.0 266 1 13   1 8     0   18   144 163     5 2   72 35   307
1888676 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 2018   grade_7 234.0 52.0 63.0   2.0 34.0     1.0   23.0   217.0 192.0     29.0   4.0     152.0   39.0   409.0 234 52 63   2 34     1   23   217 192     29 4   152 39   409
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
1891389 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 River Trail Learning Center at Lo Jacob Special Education Special Education School No Other KG 12 2018   grade_7 4.0 1.0 0.0   0.0 0.0     0.0   1.0   5.0 1.0     *   *     *   *   6.0 4 1 0   0 0     0   1   5 1                 6
1892039 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 2018   grade_7 4.0 2.0 0.0   0.0 1.0     0.0   0.0   4.0 3.0     *   *     *   *   7.0 4 2 0   0 1     0   0   4 3                 7
1892710 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 2018   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0     *   *     *   *   2.0 2 0 0   0 0     0   0   0 2                 2
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
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
1944382 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 2019   grade_7 5.0 0.0 1.0   0.0 1.0     0.0   4.0   8.0 3.0     0.0   0.0     1.0   0.0   11.0 5 0 1   0 1     0   4   8 3     0 0   1 0   11
1945692 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 2019   grade_7 46.0 3.0 3.0   0.0 0.0     0.0   2.0   20.0 34.0     5.0   0.0     10.0   8.0   54.0 46 3 3   0 0     0   2   20 34     5 0   10 8   54
1952739 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 2019   grade_7 47.0 10.0 3.0   0.0 7.0     0.0   6.0   38.0 35.0     3.0   0.0     12.0   9.0   73.0 47 10 3   0 7     0   6   38 35     3 0   12 9   73
1952749 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 2019   grade_7 8.0 38.0 0.0   0.0 0.0     0.0   1.0   29.0 18.0     7.0   0.0     38.0   11.0   47.0 8 38 0   0 0     0   1   29 18     7 0   38 11   47
1952943 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 2019   grade_7 6.0 10.0 0.0   0.0 2.0     0.0   0.0   10.0 8.0     8.0   0.0     5.0   3.0   18.0 6 10 0   0 2     0   0   10 8     8 0   5 3   18
1953230 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 2019   grade_7 454.0 68.0 27.0   6.0 23.0     1.0   33.0   306.0 306.0     23.0   13.0     209.0   104.0   612.0 454 68 27   6 23     1   33   306 306     23 13   209 104   612
1953234 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 2019   grade_7 260.0 80.0 36.0   7.0 25.0     0.0   26.0   236.0 198.0     21.0   17.0     229.0   73.0   434.0 260 80 36   7 25     0   26   236 198     21 17   229 73   434
1953242 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 2019   grade_7 277.0 54.0 31.0   4.0 43.0     0.0   21.0   231.0 199.0     19.0   11.0     191.0   79.0   430.0 277 54 31   4 43     0   21   231 199     19 11   191 79   430
1953246 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 2019   grade_7 362.0 11.0 13.0   0.0 9.0     1.0   11.0   212.0 195.0     4.0   5.0     65.0   *   407.0 362 11 13   0 9     1   11   212 195     4 5   65     407
1953250 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 2019   grade_7 322.0 35.0 20.0   2.0 27.0     0.0   11.0   221.0 196.0     6.0   8.0     109.0   *   417.0 322 35 20   2 27     0   11   221 196     6 8   109     417
1953254 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 2019   grade_7 407.0 26.0 32.0   2.0 16.0     0.0   26.0   254.0 255.0     *   *         *   509.0 407 26 32   2 16     0   26   254 255                 509
1953258 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 2019   grade_7 39.0 84.0 94.0   5.0 8.0     0.0   15.0   127.0 118.0     39.0   5.0     182.0   32.0   245.0 39 84 94   5 8     0   15   127 118     39 5   182 32   245
1953263 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 2019   grade_7 60.0 84.0 24.0   2.0 12.0     0.0   13.0   104.0 91.0     20.0   6.0     134.0   27.0   195.0 60 84 24   2 12     0   13   104 91     20 6   134 27   195
1953267 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000013 123 ST. FRANCIS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 185.0 1.0 9.0   2.0 5.0     0.0   14.0   114.0 102.0     1.0   1.0     48.0   44.0   216.0 185 1 9   2 5     0   14   114 102     1 1   48 44   216
1953272 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001466 92 Westwood Intermediate and Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 254.0 64.0 65.0   7.0 46.0     1.0   36.0   235.0 238.0     56.0   5.0     189.0   59.0   473.0 254 64 65   7 46     1   36   235 238     56 5   189 59   473
1955344 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 2019   grade_7 2.0 10.0 3.0   1.0 0.0     0.0   0.0   12.0 4.0     0.0   0.0     13.0   0.0   16.0 2 10 3   1 0     0   0   12 4     0 0   13 0   16
1955350 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004980 18 Saints Academy Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2019   grade_7 98.0 0.0 5.0   0.0 11.0     0.0   2.0   68.0 48.0     8.0   4.0     42.0   7.0   116.0 98 0 5   0 11     0   2   68 48     8 4   42 7   116
1955973 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 2019   grade_7 9.0 1.0 1.0   0.0 0.0     0.0   1.0   12.0 0.0     0.0   0.0     7.0   *   12.0 9 1 1   0 0     0   1   12 0     0 0   7     12
1956585 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 2019   grade_7 3.0 2.0 1.0   0.0 0.0     0.0   0.0   5.0 1.0     *   *         *   6.0 3 2 1   0 0     0   0   5 1                 6
1957328 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004917 15 Saints Online Distance Learning Program OLL (State approved) Regular School No Other 03 12 2019   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
1957515 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 High 06 12 2019   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
1957528 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354005205 856 Crossroads School Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2019   grade_7 0.0 0.0 0.0   0.0 1.0     0.0   2.0   3.0 0.0     *   *         *   3.0 0 0 0   0 1     0   2   3 0                 3
1957785 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 School No High 07 12 2019   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
689031 MN Becker 3 school 2712360 23 Independent Districts and Schools FRAZEE-VERGAS PUBLIC SCHOOL DIST. 271236000606 20 FRAZEE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 59.0 0.0 1.0   2.0 0.0     0.0   3.0   30.0 35.0     0.0   0.0     33.0   16.0   65.0 59 0 1   2 0     0   3   30 35     0 0   33 16   65
690266 MN Becker 3 school 2700162 2889 Independent Districts and Schools LAKE PARK AUDUBON SCHOOL DISTRICT 270016200812 20 LAKE PARK AUDUBON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 49.0 0.0 0.0   3.0 1.0     0.0   3.0   30.0 26.0     0.0   0.0     18.0   12.0   56.0 49 0 0   3 1     0   3   30 26     0 0   18 12   56
690899 MN Becker 3 school 2728960 25 Independent Districts and Schools PINE POINT PUBLIC SCHOOL DISTRICT 272896000034 70 PINE POINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   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
697731 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023000443 4 DETROIT LAKES MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_7 151.0 5.0 7.0   21.0 1.0     0.0   34.0   109.0 110.0         *         *   219.0 151 5 7   21 1     0   34   109 110                 219
699772 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023003061 32 DETROIT LAKES MIDDLE ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   grade_7 4.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 2.0         *         *   4.0 4 0 0   0 0     0   0   2 2                 4
853436 MN Becker 3 school 2712360 23 Independent Districts and Schools FRAZEE-VERGAS PUBLIC SCHOOL DIST. 271236000606 20 FRAZEE SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 65 0 3   0 1     0   6   42 33     0.0   0.0     31.0   13.0   75 65 0 3   0 1     0   6   42 33     0 0   31 13   75
854696 MN Becker 3 school 2700162 2889 Independent Districts and Schools LAKE PARK AUDUBON SCHOOL DISTRICT 270016200812 20 LAKE PARK AUDUBON SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 39 1 3   2 1     0   3   26 23     1.0   0.0     15.0   8.0   49 39 1 3   2 1     0   3   26 23     1 0   15 8   49
855285 MN Becker 3 school 2728960 25 Independent Districts and Schools PINE POINT PUBLIC SCHOOL DISTRICT 272896000034 70 PINE POINT ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 0 0 0   3 0     0   0   1 2         *         *   3 0 0 0   3 0     0   0   1 2                 3
861930 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023000443 4 DETROIT LAKES MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 188 4 5   18 3     0   17   120 115         *         *   235 188 4 5   18 3     0   17   120 115                 235
863947 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023003061 32 DETROIT LAKES MIDDLE ALC Public Area Learning Center ALC (State approved) Alternative Education School No 2 06 08 2016   grade_7 5 0 0   1 0     0   0   6 0         *         *   6 5 0 0   1 0     0   0   6 0                 6
1146119 MN Becker 3 school 2712360 23 Independent Districts and Schools FRAZEE-VERGAS PUBLIC SCHOOL DIST. 271236000606 20 FRAZEE SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 63.0 0.0 0.0   6.0 1.0     0.0   3.0   33.0 40.0     0.0   0.0     43.0   15.0   73.0 63 0 0   6 1     0   3   33 40     0 0   43 15   73
1147386 MN Becker 3 school 2700162 2889 Independent Districts and Schools LAKE PARK AUDUBON SCHOOL DISTRICT 270016200812 20 LAKE PARK AUDUBON SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 38.0 0.0 0.0   0.0 1.0     0.0   1.0   23.0 17.0     0.0   0.0     13.0   1.0   40.0 38 0 0   0 1     0   1   23 17     0 0   13 1   40
1147951 MN Becker 3 school 2728960 25 Independent Districts and Schools PINE POINT PUBLIC SCHOOL DISTRICT 272896000034 70 PINE POINT ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 0.0 0.0 0.0   4.0 0.0     0.0   0.0   2.0 2.0         *         *   4.0 0 0 0   4 0     0   0   2 2                 4
1154608 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023000443 4 DETROIT LAKES MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 179.0 2.0 2.0   27.0 3.0     0.0   8.0   116.0 105.0         *         *   221.0 179 2 2   27 3     0   8   116 105                 221
1156585 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023003061 32 DETROIT LAKES MIDDLE ALC Public Area Learning Center ALC (State approved) Alternative Education School No 2 06 08 2015   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0         *         *   2.0 2 0 0   0 0     0   0   0 2                 2
1711674 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 2021   grade_7 66 0 1   2 0     0   5   39 35     0.0   0.0     29.0   14.0   74 66 0 1   2 0     0   5   39 35     0 0   29 14   74
1712901 MN Becker 3 school 2700162 2889 Independent Districts and Schools Lake Park Audubon School District 270016200812 20 Lake Park Audubon Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 45 0 1   2 1     0   2   26 25     1.0   2.0     10.0   8.0   51 45 0 1   2 1     0   2   26 25     1 2   10 8   51

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);