Data source: Big Local News · About: Big Local

14,034 rows where state = "MN" and year = 2020 sorted by county_state_id

View and edit SQL

year

  • 2020 · 14,034
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
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
1825223 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000057 1 Aitkin Secondary School Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_8 85.0 2.0 1.0   3.0 0.0     0.0   3.0   40.0 54.0     0.0   0.0     41.0   16.0   94.0 85 2 1   3 0     0   3   40 54     0 0   41 16   94
1825224 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_9 91.0 2.0 1.0   0.0 0.0     0.0   2.0   58.0 38.0     *   *         *   96.0 91 2 1   0 0     0   2   58 38                 96
1825225 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_10 97.0 0.0 3.0   0.0 0.0     0.0   6.0   56.0 50.0     *   *         *   106.0 97 0 3   0 0     0   6   56 50                 106
1825226 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_11 98.0 2.0 2.0   0.0 0.0     0.0   3.0   50.0 55.0     *   *         *   105.0 98 2 2   0 0     0   3   50 55                 105
1825227 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_12 67.0 0.0 1.0   1.0 0.0     0.0   4.0   38.0 35.0     *   *         *   73.0 67 0 1   1 0     0   4   38 35                 73
1825228 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   pk_12_total 530.0 7.0 11.0   4.0 0.0     0.0   20.0   295.0 277.0     1.0   1.0     220.0   85.0   572.0 530 7 11   4 0     0   20   295 277     1 1   220 85   572
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
1825230 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000904 40 McGregor Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_8 19.0 0.0 1.0   6.0 0.0     0.0   0.0   11.0 15.0     0.0   0.0     14.0   7.0   26.0 19 0 1   6 0     0   0   11 15     0 0   14 7   26
1825231 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_9 29.0 0.0 2.0   6.0 1.0     0.0   1.0   21.0 18.0     0.0   0.0     23.0   8.0   39.0 29 0 2   6 1     0   1   21 18     0 0   23 8   39
1825232 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_10 28.0 0.0 0.0   8.0 0.0     0.0   0.0   15.0 21.0     0.0   0.0     14.0   9.0   36.0 28 0 0   8 0     0   0   15 21     0 0   14 9   36
1825233 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_11 32.0 0.0 1.0   5.0 0.0     0.0   0.0   21.0 17.0     0.0   0.0     17.0   10.0   38.0 32 0 1   5 0     0   0   21 17     0 0   17 10   38
1825234 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_12 25.0 0.0 2.0   10.0 0.0     0.0   0.0   19.0 18.0     *   *         *   37.0 25 0 2   10 0     0   0   19 18                 37
1825235 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   pk_12_total 164.0 0.0 6.0   43.0 1.0     0.0   1.0   102.0 113.0     0.0   *         *   215.0 164 0 6   43 1     0   1   102 113     0           215
1826779 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 2020   early_childhood_special_ed 17.0 0.0 0.0   0.0 0.0     0.0   1.0   14.0 4.0     0.0   0.0     14.0   *   18.0 17 0 0   0 0     0   1   14 4     0 0   14     18
1826780 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 2020   kindergarten 55.0 1.0 2.0   0.0 0.0     0.0   6.0   32.0 32.0     0.0   1.0     25.0   12.0   64.0 55 1 2   0 0     0   6   32 32     0 1   25 12   64
1826781 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 2020   grade_1 55.0 2.0 1.0   0.0 0.0     0.0   4.0   23.0 39.0     0.0   0.0     32.0   9.0   62.0 55 2 1   0 0     0   4   23 39     0 0   32 9   62
1826782 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 2020   grade_2 86.0 1.0 4.0   1.0 1.0     0.0   5.0   56.0 42.0     0.0   0.0     36.0   16.0   98.0 86 1 4   1 1     0   5   56 42     0 0   36 16   98
1826783 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 2020   grade_3 70.0 0.0 3.0   2.0 1.0     0.0   2.0   41.0 37.0     0.0   0.0     37.0   16.0   78.0 70 0 3   2 1     0   2   41 37     0 0   37 16   78
1826784 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 2020   grade_4 80.0 1.0 1.0   1.0 1.0     0.0   2.0   49.0 37.0     0.0   1.0     45.0   13.0   86.0 80 1 1   1 1     0   2   49 37     0 1   45 13   86
1826785 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 2020   grade_5 78.0 1.0 0.0   1.0 0.0     0.0   2.0   48.0 34.0     0.0   1.0     38.0   15.0   82.0 78 1 0   1 0     0   2   48 34     0 1   38 15   82
1826786 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 2020   grade_6 91.0 2.0 1.0   1.0 2.0     0.0   3.0   47.0 53.0     1.0   0.0     41.0   21.0   100.0 91 2 1   1 2     0   3   47 53     1 0   41 21   100
1826787 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 2020   pk_12_total 532.0 8.0 12.0   6.0 5.0     0.0   25.0   310.0 278.0     1.0   3.0     268.0   120.0   588.0 532 8 12   6 5     0   25   310 278     1 3   268 120   588
1826788 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 2020   early_childhood_special_ed 2.0 0.0 0.0   0.0 0.0     0.0   1.0   3.0 0.0     *   *         *   3.0 2 0 0   0 0     0   1   3 0                 3
1826789 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 2020   pre_kindergarten 12.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 6.0     *   *         0.0   12.0 12 0 0   0 0     0   0   6 6             0   12
1826790 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 2020   kindergarten 15.0 0.0 0.0   0.0 0.0     0.0   1.0   12.0 4.0     0.0   0.0     10.0   3.0   16.0 15 0 0   0 0     0   1   12 4     0 0   10 3   16
1826791 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 2020   grade_1 10.0 0.0 1.0   1.0 0.0     0.0   1.0   5.0 8.0     0.0   0.0     11.0   2.0   13.0 10 0 1   1 0     0   1   5 8     0 0   11 2   13
1826792 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 2020   grade_2 18.0 0.0 0.0   1.0 0.0     0.0   1.0   10.0 10.0     0.0   0.0     9.0   4.0   20.0 18 0 0   1 0     0   1   10 10     0 0   9 4   20
1826793 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 2020   grade_3 15.0 0.0 1.0   0.0 0.0     0.0   0.0   8.0 8.0     0.0   0.0     10.0   4.0   16.0 15 0 1   0 0     0   0   8 8     0 0   10 4   16
1826794 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 2020   grade_4 20.0 1.0 1.0   0.0 0.0     0.0   0.0   8.0 14.0     0.0   0.0     14.0   9.0   22.0 20 1 1   0 0     0   0   8 14     0 0   14 9   22
1826795 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 2020   pk_12_total 92.0 1.0 3.0   2.0 0.0     0.0   4.0   52.0 50.0     0.0   0.0     61.0   25.0   102.0 92 1 3   2 0     0   4   52 50     0 0   61 25   102
1826796 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 2020   early_childhood_special_ed 7.0 0.0 0.0   9.0 0.0     0.0   0.0   10.0 6.0     *   0.0     4.0   *   16.0 7 0 0   9 0     0   0   10 6       0   4     16
1826797 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 2020   pre_kindergarten 17.0 0.0 0.0   1.0 0.0     0.0   0.0   9.0 9.0     0.0   0.0     3.0   0.0   18.0 17 0 0   1 0     0   0   9 9     0 0   3 0   18
1826798 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 2020   kindergarten 26.0 0.0 1.0   10.0 0.0     0.0   0.0   19.0 18.0     0.0   0.0     15.0   11.0   37.0 26 0 1   10 0     0   0   19 18     0 0   15 11   37
1826799 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 2020   grade_1 25.0 0.0 0.0   9.0 0.0     0.0   1.0   22.0 13.0     0.0   0.0     14.0   14.0   35.0 25 0 0   9 0     0   1   22 13     0 0   14 14   35
1826800 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 2020   grade_2 10.0 0.0 1.0   12.0 0.0     0.0   0.0   13.0 10.0     0.0   0.0     14.0   7.0   23.0 10 0 1   12 0     0   0   13 10     0 0   14 7   23
1826801 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 2020   grade_3 15.0 0.0 0.0   12.0 0.0     0.0   0.0   14.0 13.0     0.0   0.0     8.0   8.0   27.0 15 0 0   12 0     0   0   14 13     0 0   8 8   27
1826802 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 2020   grade_4 28.0 0.0 1.0   13.0 0.0     0.0   0.0   17.0 25.0     0.0   0.0     23.0   11.0   42.0 28 0 1   13 0     0   0   17 25     0 0   23 11   42
1826803 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 2020   grade_5 27.0 0.0 1.0   13.0 0.0     0.0   1.0   20.0 22.0     0.0   0.0     17.0   13.0   42.0 27 0 1   13 0     0   1   20 22     0 0   17 13   42
1826804 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 2020   grade_6 23.0 0.0 0.0   11.0 0.0     0.0   1.0   19.0 16.0     0.0   0.0     25.0   11.0   35.0 23 0 0   11 0     0   1   19 16     0 0   25 11   35
1826805 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 2020   pk_12_total 178.0 0.0 4.0   90.0 0.0     0.0   3.0   143.0 132.0     *   0.0     123.0   91.0   275.0 178 0 4   90 0     0   3   143 132       0   123 91   275
1834031 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 2020   grade_9 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
1834032 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 2020   grade_10 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
1834033 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 2020   grade_11 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
1834034 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 2020   grade_12 8.0 0.0 0.0   0.0 0.0     0.0   0.0   5.0 3.0     *   *         *   8.0 8 0 0   0 0     0   0   5 3                 8
1834035 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 2020   pk_12_total 12.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 5.0     0.0   0.0     1.0   2.0   12.0 12 0 0   0 0     0   0   7 5     0 0   1 2   12
1834036 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 2020   grade_12 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
1834037 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 2020   pk_12_total 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
1834148 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_5 11.0 0.0 1.0   3.0 0.0     0.0   1.0   9.0 7.0     0.0   0.0     10.0   9.0   16.0 11 0 1   3 0     0   1   9 7     0 0   10 9   16
1834149 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_6 16.0 0.0 1.0   1.0 0.0     0.0   1.0   8.0 11.0     0.0   0.0     14.0   5.0   19.0 16 0 1   1 0     0   1   8 11     0 0   14 5   19
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
1834151 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_8 12.0 0.0 1.0   2.0 0.0     0.0   2.0   10.0 7.0     0.0   0.0     11.0   1.0   17.0 12 0 1   2 0     0   2   10 7     0 0   11 1   17
1834152 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   pk_12_total 56.0 0.0 4.0   6.0 0.0     0.0   4.0   37.0 33.0     0.0   0.0     44.0   18.0   70.0 56 0 4   6 0     0   4   37 33     0 0   44 18   70
1835165 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 2020   grade_9 19.0 0.0 1.0   1.0 0.0     0.0   2.0   10.0 13.0     0.0   0.0     15.0   3.0   23.0 19 0 1   1 0     0   2   10 13     0 0   15 3   23
1835166 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 2020   grade_10 28.0 1.0 1.0   1.0 0.0     0.0   3.0   20.0 14.0     0.0   0.0     22.0   8.0   34.0 28 1 1   1 0     0   3   20 14     0 0   22 8   34
1835167 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 2020   grade_11 12.0 0.0 1.0   2.0 0.0     0.0   2.0   9.0 8.0     0.0   0.0     13.0   5.0   17.0 12 0 1   2 0     0   2   9 8     0 0   13 5   17
1835168 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 2020   grade_12 18.0 0.0 0.0   2.0 0.0     0.0   0.0   9.0 11.0     0.0   0.0     5.0   4.0   20.0 18 0 0   2 0     0   0   9 11     0 0   5 4   20
1835169 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 2020   pk_12_total 77.0 1.0 3.0   6.0 0.0     0.0   7.0   48.0 46.0     0.0   0.0     55.0   20.0   94.0 77 1 3   6 0     0   7   48 46     0 0   55 20   94
1839244 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   kindergarten 0.0 0.0 0.0   3.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 0 0 0   3 0     0   0   2 1                 3
1839245 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_2 0.0 0.0 0.0   3.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 0 0 0   3 0     0   0   1 2                 3
1839246 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_3 0.0 0.0 0.0   1.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 0 0   1 0     0   0   0 1                 1
1839247 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_4 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
1839248 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_5 0.0 0.0 0.0   3.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 0 0 0   3 0     0   0   1 2                 3
1839249 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_6 0.0 0.0 0.0   3.0 0.0     0.0   1.0   2.0 2.0     *   *         *   4.0 0 0 0   3 0     0   1   2 2                 4
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
1839251 MN Aitkin 1 school 2700300 4177 Charter Schools Minisinaakwaang Leadership Academy 270030003730 10 Minisinaakwaang Leadership Academy Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   grade_8 0.0 0.0 0.0   2.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 0 0 0   2 0     0   0   2 0                 2
1839252 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_10 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
1839253 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_11 0.0 0.0 0.0   1.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 0 0   1 0     0   0   0 1                 1
1839254 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_12 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
1839255 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   pk_12_total 0.0 0.0 0.0   24.0 0.0     0.0   1.0   11.0 14.0     0.0   1.0     15.0   9.0   25.0 0 0 0   24 0     0   1   11 14     0 1   15 9   25
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
1825237 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_8 3.0 0.0 1.0   0.0 0.0     0.0   4.0   6.0 2.0     *   *         *   8.0 3 0 1   0 0     0   4   6 2                 8
1825238 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_9 6.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 6.0     *   *         *   7.0 6 0 0   0 0     0   1   1 6                 7
1825239 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_10 3.0 0.0 0.0   0.0 0.0     0.0   1.0   3.0 1.0     *   *         *   4.0 3 0 0   0 0     0   1   3 1                 4
1825240 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_11 3.0 0.0 0.0   0.0 0.0     0.0   2.0   3.0 2.0     *   *         *   5.0 3 0 0   0 0     0   2   3 2                 5
1825241 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_12 7.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 4.0     *   *         *   7.0 7 0 0   0 0     0   0   3 4                 7
1825242 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   pk_12_total 31.0 1.0 2.0   0.0 2.0     0.0   10.0   24.0 22.0     0.0   0.0     10.0   4.0   46.0 31 1 2   0 2     0   10   24 22     0 0   10 4   46
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
1826551 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_8 47.0 2.0 3.0   0.0 0.0     0.0   2.0   21.0 33.0     6.0   0.0     11.0   10.0   54.0 47 2 3   0 0     0   2   21 33     6 0   11 10   54
1826552 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_9 45.0 1.0 3.0   0.0 0.0     0.0   1.0   26.0 24.0     2.0   0.0     6.0   8.0   50.0 45 1 3   0 0     0   1   26 24     2 0   6 8   50
1826553 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_10 44.0 1.0 2.0   1.0 1.0     0.0   4.0   31.0 22.0     1.0   0.0     9.0   2.0   53.0 44 1 2   1 1     0   4   31 22     1 0   9 2   53
1826554 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_11 43.0 1.0 5.0   0.0 2.0     0.0   1.0   28.0 24.0     1.0   0.0     4.0   5.0   52.0 43 1 5   0 2     0   1   28 24     1 0   4 5   52
1826555 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_12 34.0 2.0 2.0   0.0 1.0     0.0   3.0   15.0 27.0     0.0   0.0     4.0   7.0   42.0 34 2 2   0 1     0   3   15 27     0 0   4 7   42
1826556 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   pk_12_total 261.0 9.0 17.0   1.0 5.0     0.0   12.0   151.0 154.0     12.0   0.0     40.0   41.0   305.0 261 9 17   1 5     0   12   151 154     12 0   40 41   305
1826584 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 2020   grade_9 21.0 0.0 3.0   0.0 0.0     0.0   0.0   14.0 10.0     0.0   0.0     9.0   10.0   24.0 21 0 3   0 0     0   0   14 10     0 0   9 10   24
1826585 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 2020   grade_10 28.0 2.0 7.0   0.0 0.0     0.0   1.0   21.0 17.0     0.0   0.0     13.0   12.0   38.0 28 2 7   0 0     0   1   21 17     0 0   13 12   38
1826586 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 2020   grade_11 30.0 4.0 2.0   1.0 0.0     0.0   7.0   27.0 17.0     0.0   1.0     12.0   20.0   44.0 30 4 2   1 0     0   7   27 17     0 1   12 20   44
1826587 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 2020   grade_12 43.0 6.0 2.0   0.0 0.0     0.0   10.0   31.0 30.0     0.0   5.0     25.0   28.0   61.0 43 6 2   0 0     0   10   31 30     0 5   25 28   61
1826588 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 2020   pk_12_total 122.0 12.0 14.0   1.0 0.0     0.0   18.0   93.0 74.0     0.0   6.0     59.0   70.0   167.0 122 12 14   1 0     0   18   93 74     0 6   59 70   167
1826806 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 2020   pre_kindergarten 14.0 5.0 1.0   0.0 4.0     0.0   1.0   8.0 17.0     1.0   0.0     14.0   0.0   25.0 14 5 1   0 4     0   1   8 17     1 0   14 0   25
1826807 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 2020   kindergarten 46.0 16.0 3.0   1.0 11.0     1.0   7.0   34.0 51.0     20.0   0.0     43.0   14.0   85.0 46 16 3   1 11     1   7   34 51     20 0   43 14   85
1826808 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 2020   grade_1 39.0 20.0 2.0   0.0 16.0     0.0   13.0   51.0 39.0     18.0   4.0     48.0   18.0   90.0 39 20 2   0 16     0   13   51 39     18 4   48 18   90
1826809 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 2020   grade_2 24.0 12.0 7.0   1.0 7.0     0.0   10.0   37.0 24.0     23.0   4.0     37.0   9.0   61.0 24 12 7   1 7     0   10   37 24     23 4   37 9   61
1826810 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 2020   grade_3 39.0 29.0 8.0   0.0 6.0     0.0   10.0   50.0 42.0     15.0   6.0     61.0   17.0   92.0 39 29 8   0 6     0   10   50 42     15 6   61 17   92
1826811 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 2020   grade_4 33.0 19.0 16.0   3.0 9.0     0.0   10.0   45.0 45.0     30.0   2.0     66.0   15.0   90.0 33 19 16   3 9     0   10   45 45     30 2   66 15   90
1826812 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 2020   grade_5 36.0 20.0 6.0   1.0 9.0     0.0   6.0   33.0 45.0     13.0   3.0     44.0   22.0   78.0 36 20 6   1 9     0   6   33 45     13 3   44 22   78
1826813 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 2020   pk_12_total 231.0 121.0 43.0   6.0 62.0     1.0   57.0   258.0 263.0     120.0   19.0     313.0   95.0   521.0 231 121 43   6 62     1   57   258 263     120 19   313 95   521
1826814 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 2020   kindergarten 64.0 4.0 3.0   0.0 4.0     0.0   4.0   39.0 40.0     6.0   2.0     19.0   13.0   79.0 64 4 3   0 4     0   4   39 40     6 2   19 13   79
1826815 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 2020   grade_1 50.0 4.0 3.0   0.0 1.0     0.0   7.0   36.0 29.0     0.0   *     23.0   12.0   65.0 50 4 3   0 1     0   7   36 29     0     23 12   65
1826816 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 2020   grade_2 61.0 4.0 2.0   0.0 2.0     0.0   5.0   43.0 31.0     5.0   *     19.0   13.0   74.0 61 4 2   0 2     0   5   43 31     5     19 13   74

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