Data source: Big Local News · About: Big Local

13,914 rows where state = "MN" and year = 2021 sorted by county_state_id

View and edit SQL

year

  • 2021 · 13,914
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
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
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
1711655 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_9 82 2 1   2 0     0   3   40 50     0.0   0.0     30.0   15.0   90 82 2 1   2 0     0   3   40 50     0 0   30 15   90
1711656 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_10 93 3 1   0 0     0   4   61 40     *   *     *   *   101 93 3 1   0 0     0   4   61 40                 101
1711657 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_11 95 0 3   0 0     0   7   56 49     *   *     *   *   105 95 0 3   0 0     0   7   56 49                 105
1711658 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_12 99 2 2   0 0     0   3   54 52     *   *     *   *   106 99 2 2   0 0     0   3   54 52                 106
1711659 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   pk_12_total 545 8 11   3 2     0   22   304 287     2.0   1.0     189.0   97.0   591 545 8 11   3 2     0   22   304 287     2 1   189 97   591
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
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
1711662 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_9 24 1 2   0 0     0   0   14 13     0.0   0.0     15.0   10.0   27 24 1 2   0 0     0   0   14 13     0 0   15 10   27
1711663 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_10 27 0 3   1 1     0   1   18 15     0.0   0.0     16.0   10.0   33 27 0 3   1 1     0   1   18 15     0 0   16 10   33
1711664 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_11 31 0 0   6 0     0   0   17 20     *   *     *   *   37 31 0 0   6 0     0   0   17 20                 37
1711665 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_12 27 0 1   1 0     0   0   17 12     *   *     *   *   29 27 0 1   1 0     0   0   17 12                 29
1711666 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   pk_12_total 169 2 7   17 1     0   2   99 99     0.0   0.0     *   *   198 169 2 7   17 1     0   2   99 99     0 0         198
1713209 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   early_childhood_special_ed 14 0 0   0 0     0   0   9 5     0.0   0.0     9.0   *   14 14 0 0   0 0     0   0   9 5     0 0   9     14
1713210 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   kindergarten 60 0 0   1 0     0   3   34 30     0.0   0.0     22.0   10.0   64 60 0 0   1 0     0   3   34 30     0 0   22 10   64
1713211 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 51 3 1   1 0     0   7   32 31     0.0   0.0     22.0   15.0   63 51 3 1   1 0     0   7   32 31     0 0   22 15   63
1713212 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 48 2 1   0 0     0   4   23 32     0.0   0.0     30.0   10.0   55 48 2 1   0 0     0   4   23 32     0 0   30 10   55
1713213 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_3 78 0 4   1 1     0   4   51 37     0.0   0.0     28.0   16.0   88 78 0 4   1 1     0   4   51 37     0 0   28 16   88
1713214 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_4 64 0 1   2 1     0   4   36 36     0.0   0.0     26.0   13.0   72 64 0 1   2 1     0   4   36 36     0 0   26 13   72
1713215 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_5 77 1 1   1 1     0   3   50 34     0.0   1.0     31.0   13.0   84 77 1 1   1 1     0   3   50 34     0 1   31 13   84
1713216 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_6 75 0 0   1 0     0   2   48 30     0.0   0.0     32.0   14.0   78 75 0 0   1 0     0   2   48 30     0 0   32 14   78
1713217 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   pk_12_total 467 6 8   7 3     0   27   283 235     0.0   1.0     200.0   105.0   518 467 6 8   7 3     0   27   283 235     0 1   200 105   518
1713218 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   early_childhood_special_ed 3 0 0   0 0     0   1   4 0     *   *     *   *   4 3 0 0   0 0     0   1   4 0                 4
1713219 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   pre_kindergarten 8 0 0   0 0     0   0   3 5     *   *     *   *   8 8 0 0   0 0     0   0   3 5                 8
1713220 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   kindergarten 16 0 0   0 0     0   0   10 6     0.0   0.0     8.0   6.0   16 16 0 0   0 0     0   0   10 6     0 0   8 6   16
1713221 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_1 13 0 0   0 0     0   1   12 2     0.0   0.0     9.0   *   14 13 0 0   0 0     0   1   12 2     0 0   9     14
1713222 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_2 9 0 1   1 0     0   1   4 8     0.0   0.0     8.0   2.0   12 9 0 1   1 0     0   1   4 8     0 0   8 2   12
1713223 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_3 14 0 0   2 0     0   1   9 8     0.0   0.0     7.0   1.0   17 14 0 0   2 0     0   1   9 8     0 0   7 1   17
1713224 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_4 12 0 1   0 0     0   0   6 7     0.0   0.0     7.0   5.0   13 12 0 1   0 0     0   0   6 7     0 0   7 5   13
1713225 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   pk_12_total 75 0 2   3 0     0   4   48 36     0.0   0.0     47.0   19.0   84 75 0 2   3 0     0   4   48 36     0 0   47 19   84
1713226 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   early_childhood_special_ed 5 0 0   6 0     0   0   7 4     *   *     *   *   11 5 0 0   6 0     0   0   7 4                 11
1713227 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   pre_kindergarten 5 0 0   0 0     0   0   3 2     *   *     *   *   5 5 0 0   0 0     0   0   3 2                 5
1713228 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   kindergarten 11 0 0   4 0     0   0   10 5     0.0   0.0     6.0   6.0   15 11 0 0   4 0     0   0   10 5     0 0   6 6   15
1713229 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 27 0 1   9 0     0   0   21 16     0.0   0.0     15.0   10.0   37 27 0 1   9 0     0   0   21 16     0 0   15 10   37
1713230 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 23 1 0   4 0     0   1   18 11     0.0   0.0     10.0   8.0   29 23 1 0   4 0     0   1   18 11     0 0   10 8   29
1713231 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_3 14 0 0   7 0     0   0   11 10     0.0   0.0     8.0   7.0   21 14 0 0   7 0     0   0   11 10     0 0   8 7   21
1713232 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_4 16 0 0   8 0     0   1   14 11     0.0   0.0     6.0   *   25 16 0 0   8 0     0   1   14 11     0 0   6     25
1713233 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_5 26 0 1   9 0     0   0   15 21     0.0   0.0     19.0   12.0   36 26 0 1   9 0     0   0   15 21     0 0   19 12   36
1713234 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_6 24 0 0   9 0     0   1   17 17     0.0   0.0     13.0   9.0   34 24 0 0   9 0     0   1   17 17     0 0   13 9   34
1713235 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   pk_12_total 151 1 2   56 0     0   3   116 97     *   *     84.0   68.0   213 151 1 2   56 0     0   3   116 97           84 68   213
1720526 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276002789 6 Aitkin Alternative Learning Program Public Area Learning Program ALP (State approved) Alternative School No High 07 12 2021   grade_10 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1720527 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276002789 6 Aitkin Alternative Learning Program Public Area Learning Program ALP (State approved) Alternative School No High 07 12 2021   grade_11 4 0 0   0 0     0   0   1 3     *   *     *   *   4 4 0 0   0 0     0   0   1 3                 4
1720528 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276002789 6 Aitkin Alternative Learning Program Public Area Learning Program ALP (State approved) Alternative School No High 07 12 2021   grade_12 7 0 0   0 0     0   0   4 3     *   *     *   *   7 7 0 0   0 0     0   0   4 3                 7
1720529 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276002789 6 Aitkin Alternative Learning Program Public Area Learning Program ALP (State approved) Alternative School No High 07 12 2021   pk_12_total 12 0 0   0 0     0   0   6 6     0.0   0.0     2.0   1.0   12 12 0 0   0 0     0   0   6 6     0 0   2 1   12
1720530 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917003432 30 McGregor Area Learning Program Public Area Learning Program ALP (State approved) Alternative School No High 08 12 2021   grade_11 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1720531 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917003432 30 McGregor Area Learning Program Public Area Learning Program ALP (State approved) Alternative School No High 08 12 2021   grade_12 1 0 0   1 0     0   0   2 0     *   *     *   *   2 1 0 0   1 0     0   0   2 0                 2
1720532 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917003432 30 McGregor Area Learning Program Public Area Learning Program ALP (State approved) Alternative School No High 08 12 2021   pk_12_total 2 0 0   1 0     0   0   2 1     *   *     *   *   3 2 0 0   1 0     0   0   2 1                 3
1720642 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_5 18 1 1   0 0     0   0   7 13     0.0   0.0     10.0   6.0   20 18 1 1   0 0     0   0   7 13     0 0   10 6   20
1720643 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_6 13 0 0   2 0     0   0   10 5     0.0   0.0     9.0   8.0   15 13 0 0   2 0     0   0   10 5     0 0   9 8   15
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
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
1720646 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   pk_12_total 59 2 2   5 0     0   1   33 36     0.0   0.0     34.0   21.0   69 59 2 2   5 0     0   1   33 36     0 0   34 21   69
1721664 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000724 3 Hill City Senior High Senior High School (Grades 9-12) Regular School No High 09 12 2021   grade_9 14 0 1   1 0     0   3   9 10     0.0   0.0     6.0   3.0   19 14 0 1   1 0     0   3   9 10     0 0   6 3   19
1721665 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000724 3 Hill City Senior High Senior High School (Grades 9-12) Regular School No High 09 12 2021   grade_10 17 0 1   3 0     0   3   11 13     0.0   0.0     16.0   4.0   24 17 0 1   3 0     0   3   11 13     0 0   16 4   24
1721666 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000724 3 Hill City Senior High Senior High School (Grades 9-12) Regular School No High 09 12 2021   grade_11 22 0 1   2 0     0   4   16 13     0.0   0.0     12.0   6.0   29 22 0 1   2 0     0   4   16 13     0 0   12 6   29
1721667 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000724 3 Hill City Senior High Senior High School (Grades 9-12) Regular School No High 09 12 2021   grade_12 9 0 1   0 0     0   1   7 4     0.0   0.0     8.0   4.0   11 9 0 1   0 0     0   1   7 4     0 0   8 4   11
1721668 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000724 3 Hill City Senior High Senior High School (Grades 9-12) Regular School No High 09 12 2021   pk_12_total 62 0 4   6 0     0   11   43 40     0.0   0.0     42.0   17.0   83 62 0 4   6 0     0   11   43 40     0 0   42 17   83
1725553 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   kindergarten 0 0 0   1 0     0   0   1 0     *   *     *   *   1 0 0 0   1 0     0   0   1 0                 1
1725554 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_1 0 0 0   4 0     0   0   2 2     *   *     *   *   4 0 0 0   4 0     0   0   2 2                 4
1725555 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_2 0 0 0   1 0     0   0   1 0     *   *     *   *   1 0 0 0   1 0     0   0   1 0                 1
1725556 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_3 0 0 0   4 0     0   0   2 2     *   *     *   *   4 0 0 0   4 0     0   0   2 2                 4
1725557 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_4 0 0 0   1 0     0   0   0 1     *   *     *   *   1 0 0 0   1 0     0   0   0 1                 1
1725558 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_5 0 0 0   4 0     0   0   2 2     *   *     *   *   4 0 0 0   4 0     0   0   2 2                 4
1725559 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_6 0 0 0   2 0     0   0   0 2     *   *     *   *   2 0 0 0   2 0     0   0   0 2                 2
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
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
1725562 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_9 0 0 0   6 0     0   0   4 2     *   *     *   *   6 0 0 0   6 0     0   0   4 2                 6
1725563 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_10 0 0 0   3 0     0   0   2 1     *   *     *   *   3 0 0 0   3 0     0   0   2 1                 3
1725564 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_11 0 0 0   2 0     0   0   0 2     *   *     *   *   2 0 0 0   2 0     0   0   0 2                 2
1725565 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_12 0 0 0   1 0     0   0   0 1     *   *     *   *   1 0 0 0   1 0     0   0   0 1                 1
1725566 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   pk_12_total 0 0 0   37 0     0   1   18 20     0.0   5.0     27.0   10.0   38 0 0 0   37 0     0   1   18 20     0 5   27 10   38
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
1711668 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_8 6 1 1   0 2     0   1   7 4     0.0   0.0     3.0   2.0   11 6 1 1   0 2     0   1   7 4     0 0   3 2   11
1711669 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_9 2 0 1   0 0     0   0   1 2     *   *     *   *   3 2 0 1   0 0     0   0   1 2                 3
1711670 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_10 5 0 0   0 0     0   1   1 5     *   *     *   *   6 5 0 0   0 0     0   1   1 5                 6
1711671 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_11 2 0 0   0 0     0   1   1 2     *   *     *   *   3 2 0 0   0 0     0   1   1 2                 3
1711672 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_12 3 0 0   0 0     0   2   3 2     *   *     *   *   5 3 0 0   0 0     0   2   3 2                 5
1711673 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   pk_12_total 29 2 2   0 2     0   5   19 21     0.0   0.0     8.0   *   40 29 2 2   0 2     0   5   19 21     0 0   8     40
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
1712967 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_8 45 4 3   0 1     0   1   29 25     2.0   0.0     7.0   9.0   54 45 4 3   0 1     0   1   29 25     2 0   7 9   54
1712968 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_9 49 7 2   0 0     0   1   20 39     6.0   0.0     11.0   11.0   59 49 7 2   0 0     0   1   20 39     6 0   11 11   59
1712969 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_10 44 1 3   0 0     0   2   24 26     5.0   0.0     6.0   7.0   50 44 1 3   0 0     0   2   24 26     5 0   6 7   50
1712970 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_11 49 1 3   1 1     0   7   33 29     1.0   0.0     10.0   3.0   62 49 1 3   1 1     0   7   33 29     1 0   10 3   62
1712971 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_12 42 1 5   0 2     0   2   28 24     1.0   0.0     5.0   5.0   52 42 1 5   0 2     0   2   28 24     1 0   5 5   52
1712972 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   pk_12_total 279 15 16   1 4     0   15   157 173     17.0   0.0     44.0   45.0   330 279 15 16   1 4     0   15   157 173     17 0   44 45   330
1713006 MN Anoka 2 school 2700173 4049 Charter Schools Northwest Passage High School 270017303041 10 Northwest Passage High School Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   grade_9 14 2 0   1 0     0   0   10 7     0.0   0.0     5.0   8.0   17 14 2 0   1 0     0   0   10 7     0 0   5 8   17
1713007 MN Anoka 2 school 2700173 4049 Charter Schools Northwest Passage High School 270017303041 10 Northwest Passage High School Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   grade_10 25 0 3   0 0     0   1   17 12     1.0   0.0     9.0   11.0   29 25 0 3   0 0     0   1   17 12     1 0   9 11   29
1713008 MN Anoka 2 school 2700173 4049 Charter Schools Northwest Passage High School 270017303041 10 Northwest Passage High School Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   grade_11 30 3 6   1 0     0   4   21 23     1.0   0.0     14.0   14.0   44 30 3 6   1 0     0   4   21 23     1 0   14 14   44
1713009 MN Anoka 2 school 2700173 4049 Charter Schools Northwest Passage High School 270017303041 10 Northwest Passage High School Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   grade_12 50 6 4   1 1     0   8   39 31     2.0   6.0     24.0   27.0   70 50 6 4   1 1     0   8   39 31     2 6   24 27   70
1713010 MN Anoka 2 school 2700173 4049 Charter Schools Northwest Passage High School 270017303041 10 Northwest Passage High School Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   pk_12_total 119 11 13   3 1     0   13   87 73     4.0   6.0     52.0   60.0   160 119 11 13   3 1     0   13   87 73     4 6   52 60   160
1713236 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   pre_kindergarten 15 0 0   0 6     0   2   11 12     0.0   0.0     8.0   0.0   23 15 0 0   0 6     0   2   11 12     0 0   8 0   23
1713237 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   kindergarten 38 12 8   1 9     0   11   48 31     20.0   *     35.0   17.0   79 38 12 8   1 9     0   11   48 31     20     35 17   79
1713238 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 44 11 4   1 11     0   6   31 46     16.0   0.0     35.0   16.0   77 44 11 4   1 11     0   6   31 46     16 0   35 16   77
1713239 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 31 16 6   0 14     0   12   46 33     12.0   2.0     42.0   15.0   79 31 16 6   0 14     0   12   46 33     12 2   42 15   79
1713240 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_3 22 19 8   0 7     0   10   38 28     19.0   *     35.0   15.0   66 22 19 8   0 7     0   10   38 28     19     35 15   66
1713241 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_4 36 23 9   0 6     0   11   46 39     13.0   4.0     48.0   19.0   85 36 23 9   0 6     0   11   46 39     13 4   48 19   85
1713242 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_5 32 17 14   2 7     0   10   41 41     16.0   2.0     53.0   15.0   82 32 17 14   2 7     0   10   41 41     16 2   53 15   82
1713243 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   pk_12_total 218 98 49   4 60     0   62   261 230     96.0   10.0     256.0   97.0   491 218 98 49   4 60     0   62   261 230     96 10   256 97   491
1713244 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000101 402 Crooked Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   kindergarten 38 4 4   2 3     0   3   28 26     7.0   0.0     11.0   13.0   54 38 4 4   2 3     0   3   28 26     7 0   11 13   54

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