Data source: Big Local News · About: Big Local

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

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
1712954 MN Ramsey 62 school 2708955 4000 Charter Schools City Academy 270895500016 10 City Academy Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   grade_9 0 0 1   0 0     0   0   0 1     *   *     *   *   1 0 0 1   0 0     0   0   0 1                 1
1712955 MN Ramsey 62 school 2708955 4000 Charter Schools City Academy 270895500016 10 City Academy Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   grade_10 1 0 1   0 0     0   0   1 1     *   *     *   *   2 1 0 1   0 0     0   0   1 1                 2
1712956 MN Ramsey 62 school 2708955 4000 Charter Schools City Academy 270895500016 10 City Academy Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   grade_11 2 3 4   0 5     0   2   7 9     2.0   0.0     *   0.0   16 2 3 4   0 5     0   2   7 9     2 0     0   16
1712957 MN Ramsey 62 school 2708955 4000 Charter Schools City Academy 270895500016 10 City Academy Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   grade_12 8 35 28   2 23     0   9   59 46     10.0   0.0     *   0.0   105 8 35 28   2 23     0   9   59 46     10 0     0   105
1712958 MN Ramsey 62 school 2708955 4000 Charter Schools City Academy 270895500016 10 City Academy Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   pk_12_total 11 38 34   2 28     0   11   67 57     12.0   0.0     *   0.0   124 11 38 34   2 28     0   11   67 57     12 0     0   124
1712959 MN Sibley 72 school 2700092 4007 Charter Schools Minnesota New Country School 270009202487 10 Minnesota New Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 15 0 1   0 0     0   0   9 7     0.0   0.0     3.0   7.0   16 15 0 1   0 0     0   0   9 7     0 0   3 7   16
1712960 MN Sibley 72 school 2700092 4007 Charter Schools Minnesota New Country School 270009202487 10 Minnesota New Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_8 18 1 1   0 0     0   1   10 11     0.0   0.0     5.0   6.0   21 18 1 1   0 0     0   1   10 11     0 0   5 6   21
1712961 MN Sibley 72 school 2700092 4007 Charter Schools Minnesota New Country School 270009202487 10 Minnesota New Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_9 17 0 0   0 0     0   1   9 9     0.0   0.0     3.0   3.0   18 17 0 0   0 0     0   1   9 9     0 0   3 3   18
1712962 MN Sibley 72 school 2700092 4007 Charter Schools Minnesota New Country School 270009202487 10 Minnesota New Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_10 29 0 3   0 0     0   3   20 15     0.0   0.0     6.0   12.0   35 29 0 3   0 0     0   3   20 15     0 0   6 12   35
1712963 MN Sibley 72 school 2700092 4007 Charter Schools Minnesota New Country School 270009202487 10 Minnesota New Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_11 21 0 1   0 0     0   1   11 12     0.0   0.0     2.0   7.0   23 21 0 1   0 0     0   1   11 12     0 0   2 7   23
1712964 MN Sibley 72 school 2700092 4007 Charter Schools Minnesota New Country School 270009202487 10 Minnesota New Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_12 18 0 0   0 0     0   4   13 9     0.0   0.0     2.0   4.0   22 18 0 0   0 0     0   4   13 9     0 0   2 4   22
1712965 MN Sibley 72 school 2700092 4007 Charter Schools Minnesota New Country School 270009202487 10 Minnesota New Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   pk_12_total 118 1 6   0 0     0   10   72 63     0.0   0.0     21.0   39.0   135 118 1 6   0 0     0   10   72 63     0 0   21 39   135
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
1712973 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703262 12 MTS High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 5 5 2   1 0     0   5   7 11     0.0   *     *   2.0   18 5 5 2   1 0     0   5   7 11     0       2   18
1712974 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703262 12 MTS High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_8 1 8 4   0 0     0   5   14 4     1.0   1.0     *   5.0   18 1 8 4   0 0     0   5   14 4     1 1     5   18
1712975 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703262 12 MTS High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_9 0 9 5   0 0     0   2   12 4     3.0   0.0     14.0   2.0   16 0 9 5   0 0     0   2   12 4     3 0   14 2   16
1712976 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703262 12 MTS High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_10 3 14 15   0 0     0   4   18 18     7.0   2.0     31.0   13.0   36 3 14 15   0 0     0   4   18 18     7 2   31 13   36
1712977 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703262 12 MTS High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_11 2 17 11   0 0     0   2   19 13     5.0   *     *   11.0   32 2 17 11   0 0     0   2   19 13     5       11   32
1712978 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703262 12 MTS High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_12 1 15 16   0 1     0   4   20 17     10.0   0.0     33.0   8.0   37 1 15 16   0 1     0   4   20 17     10 0   33 8   37
1712979 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703262 12 MTS High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   pk_12_total 12 68 53   1 1     0   22   90 67     26.0   5.0     *   41.0   157 12 68 53   1 1     0   22   90 67     26 5     41   157
1712980 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011705279 27 Banaadir Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 0 22 0   0 0     0   0   9 13     *   0.0     *   3.0   22 0 22 0   0 0     0   0   9 13       0     3   22
1712981 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011705279 27 Banaadir Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_8 0 22 0   0 0     0   0   13 9     15.0   0.0     *   *   22 0 22 0   0 0     0   0   13 9     15 0         22
1712982 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011705279 27 Banaadir Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_9 0 18 0   0 0     0   0   8 10     12.0   0.0     *   2.0   18 0 18 0   0 0     0   0   8 10     12 0     2   18
1712983 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011705279 27 Banaadir Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_10 0 17 0   0 0     0   0   12 5     12.0   0.0     *   *   17 0 17 0   0 0     0   0   12 5     12 0         17
1712984 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011705279 27 Banaadir Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_11 0 11 0   0 0     0   0   7 4     *   0.0     *   *   11 0 11 0   0 0     0   0   7 4       0         11
1712985 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011705279 27 Banaadir Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   pk_12_total 0 90 0   0 0     0   0   49 41     65.0   0.0     *   11.0   90 0 90 0   0 0     0   0   49 41     65 0     11   90
1712986 MN Ramsey 62 school 2700140 4027 Charter Schools Higher Ground Academy 270014004749 30 Higher Ground Secondary Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 0 86 0   0 0     0   0   42 44     33.0   0.0     *   3.0   86 0 86 0   0 0     0   0   42 44     33 0     3   86
1712987 MN Ramsey 62 school 2700140 4027 Charter Schools Higher Ground Academy 270014004749 30 Higher Ground Secondary Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_8 0 83 0   0 0     0   0   43 40     26.0   0.0     *   4.0   83 0 83 0   0 0     0   0   43 40     26 0     4   83
1712988 MN Ramsey 62 school 2700140 4027 Charter Schools Higher Ground Academy 270014004749 30 Higher Ground Secondary Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_9 0 88 0   0 0     0   0   47 41     35.0   0.0     *   5.0   88 0 88 0   0 0     0   0   47 41     35 0     5   88
1712989 MN Ramsey 62 school 2700140 4027 Charter Schools Higher Ground Academy 270014004749 30 Higher Ground Secondary Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_10 0 68 0   0 0     0   0   34 34     23.0   0.0     *   4.0   68 0 68 0   0 0     0   0   34 34     23 0     4   68
1712990 MN Ramsey 62 school 2700140 4027 Charter Schools Higher Ground Academy 270014004749 30 Higher Ground Secondary Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_11 0 52 0   0 0     0   0   27 25     16.0   0.0     *   2.0   52 0 52 0   0 0     0   0   27 25     16 0     2   52
1712991 MN Ramsey 62 school 2700140 4027 Charter Schools Higher Ground Academy 270014004749 30 Higher Ground Secondary Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_12 0 44 0   0 0     0   0   22 22     10.0   0.0     *   5.0   44 0 44 0   0 0     0   0   22 22     10 0     5   44
1712992 MN Ramsey 62 school 2700140 4027 Charter Schools Higher Ground Academy 270014004749 30 Higher Ground Secondary Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   pk_12_total 0 421 0   0 0     0   0   215 206     143.0   0.0     *   23.0   421 0 421 0   0 0     0   0   215 206     143 0     23   421
1712993 MN Ramsey 62 school 2700157 4036 Charter Schools Face To Face Academy 270015702952 10 Face To Face Academy Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   grade_9 1 4 0   2 0     0   0   3 4     *   *     *   *   7 1 4 0   2 0     0   0   3 4                 7
1712994 MN Ramsey 62 school 2700157 4036 Charter Schools Face To Face Academy 270015702952 10 Face To Face Academy Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   grade_10 7 9 4   1 0     0   0   10 11     *   *     18.0   11.0   21 7 9 4   1 0     0   0   10 11           18 11   21
1712995 MN Ramsey 62 school 2700157 4036 Charter Schools Face To Face Academy 270015702952 10 Face To Face Academy Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   grade_11 8 11 2   0 2     0   1   9 15     0.0   0.0     18.0   *   24 8 11 2   0 2     0   1   9 15     0 0   18     24
1712996 MN Ramsey 62 school 2700157 4036 Charter Schools Face To Face Academy 270015702952 10 Face To Face Academy Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   grade_12 11 15 7   6 6     0   0   16 29     0.0   0.0     *   13.0   45 11 15 7   6 6     0   0   16 29     0 0     13   45
1712997 MN Ramsey 62 school 2700157 4036 Charter Schools Face To Face Academy 270015702952 10 Face To Face Academy Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   pk_12_total 27 39 13   9 8     0   1   38 59     0.0   0.0     85.0   29.0   97 27 39 13   9 8     0   1   38 59     0 0   85 29   97
1712998 MN Washington 82 school 2700167 4043 Charter Schools Math And Science Academy 270016703035 10 Math And Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_6 45 19 1   1 19     0   3   45 43     1.0   0.0     6.0   3.0   88 45 19 1   1 19     0   3   45 43     1 0   6 3   88
1712999 MN Washington 82 school 2700167 4043 Charter Schools Math And Science Academy 270016703035 10 Math And Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 42 12 1   0 31     0   1   38 49     1.0   0.0     2.0   10.0   87 42 12 1   0 31     0   1   38 49     1 0   2 10   87
1713000 MN Washington 82 school 2700167 4043 Charter Schools Math And Science Academy 270016703035 10 Math And Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_8 36 25 2   0 25     0   4   42 50     0.0   0.0     8.0   3.0   92 36 25 2   0 25     0   4   42 50     0 0   8 3   92
1713001 MN Washington 82 school 2700167 4043 Charter Schools Math And Science Academy 270016703035 10 Math And Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_9 45 16 2   0 22     0   1   46 40     0.0   0.0     8.0   4.0   86 45 16 2   0 22     0   1   46 40     0 0   8 4   86
1713002 MN Washington 82 school 2700167 4043 Charter Schools Math And Science Academy 270016703035 10 Math And Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_10 37 15 1   0 16     0   4   40 33     0.0   0.0     5.0   5.0   73 37 15 1   0 16     0   4   40 33     0 0   5 5   73
1713003 MN Washington 82 school 2700167 4043 Charter Schools Math And Science Academy 270016703035 10 Math And Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_11 27 15 2   1 9     0   5   26 33     0.0   0.0     3.0   6.0   59 27 15 2   1 9     0   5   26 33     0 0   3 6   59
1713004 MN Washington 82 school 2700167 4043 Charter Schools Math And Science Academy 270016703035 10 Math And Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_12 29 9 2   0 15     0   3   25 33     0.0   0.0     0.0   5.0   58 29 9 2   0 15     0   3   25 33     0 0   0 5   58
1713005 MN Washington 82 school 2700167 4043 Charter Schools Math And Science Academy 270016703035 10 Math And Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   pk_12_total 261 111 11   2 137     0   21   262 281     2.0   0.0     32.0   36.0   543 261 111 11   2 137     0   21   262 281     2 0   32 36   543
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
1713011 MN Washington 82 school 2700177 4053 Charter Schools North Lakes Academy 270017704291 20 North Lakes Academy Upper School Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   grade_9 52 1 3   1 1     0   1   35 24     0.0   0.0     9.0   17.0   59 52 1 3   1 1     0   1   35 24     0 0   9 17   59
1713012 MN Washington 82 school 2700177 4053 Charter Schools North Lakes Academy 270017704291 20 North Lakes Academy Upper School Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   grade_10 53 1 1   1 2     0   1   39 20     1.0   1.0     9.0   17.0   59 53 1 1   1 2     0   1   39 20     1 1   9 17   59
1713013 MN Washington 82 school 2700177 4053 Charter Schools North Lakes Academy 270017704291 20 North Lakes Academy Upper School Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   grade_11 30 5 0   0 1     0   1   20 17     0.0   0.0     2.0   11.0   37 30 5 0   0 1     0   1   20 17     0 0   2 11   37
1713014 MN Washington 82 school 2700177 4053 Charter Schools North Lakes Academy 270017704291 20 North Lakes Academy Upper School Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   grade_12 38 0 2   1 1     0   0   16 26     0.0   0.0     4.0   7.0   42 38 0 2   1 1     0   0   16 26     0 0   4 7   42
1713015 MN Washington 82 school 2700177 4053 Charter Schools North Lakes Academy 270017704291 20 North Lakes Academy Upper School Secondary School (Grades 7-12) Regular School Yes High 09 12 2021   pk_12_total 173 7 6   3 5     0   3   110 87     1.0   1.0     24.0   52.0   197 173 7 6   3 5     0   3   110 87     1 1   24 52   197
1713016 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori & STEM School 270017804750 20 La Crescent Secondary Montessori & STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 10 0 0   0 0     0   0   4 6     0.0   0.0     0.0   1.0   10 10 0 0   0 0     0   0   4 6     0 0   0 1   10
1713017 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori & STEM School 270017804750 20 La Crescent Secondary Montessori & STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_8 8 0 0   0 0     0   0   6 2     *   *     *   *   8 8 0 0   0 0     0   0   6 2                 8
1713018 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori & STEM School 270017804750 20 La Crescent Secondary Montessori & STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_9 8 1 0   0 0     0   0   5 4     *   *     *   *   9 8 1 0   0 0     0   0   5 4                 9
1713019 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori & STEM School 270017804750 20 La Crescent Secondary Montessori & STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_10 2 0 0   0 1     0   0   1 2     *   *     *   *   3 2 0 0   0 1     0   0   1 2                 3
1713020 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori & STEM School 270017804750 20 La Crescent Secondary Montessori & STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_11 3 0 0   0 0     0   0   3 0     *   *     *   *   3 3 0 0   0 0     0   0   3 0                 3
1713021 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori & STEM School 270017804750 20 La Crescent Secondary Montessori & STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_12 4 0 0   0 0     0   0   1 3     *   *     *   *   4 4 0 0   0 0     0   0   1 3                 4
1713022 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori & STEM School 270017804750 20 La Crescent Secondary Montessori & STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   pk_12_total 35 1 0   0 1     0   0   20 17     0.0   0.0     3.0   9.0   37 35 1 0   0 1     0   0   20 17     0 0   3 9   37
1713023 MN Winona 85 school 2700221 4064 Charter Schools Riverway Learning Community Charter 270022103136 20 Riverway Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 7 0 0   0 0     0   3   10 0     *   *     7.0   5.0   10 7 0 0   0 0     0   3   10 0           7 5   10
1713024 MN Winona 85 school 2700221 4064 Charter Schools Riverway Learning Community Charter 270022103136 20 Riverway Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_8 8 1 1   0 0     0   0   4 6     0.0   0.0     *   7.0   10 8 1 1   0 0     0   0   4 6     0 0     7   10
1713025 MN Winona 85 school 2700221 4064 Charter Schools Riverway Learning Community Charter 270022103136 20 Riverway Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_9 7 2 0   0 0     0   1   3 7     0.0   0.0     8.0   2.0   10 7 2 0   0 0     0   1   3 7     0 0   8 2   10
1713026 MN Winona 85 school 2700221 4064 Charter Schools Riverway Learning Community Charter 270022103136 20 Riverway Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_10 8 0 1   0 0     0   1   4 6     0.0   0.0     5.0   *   10 8 0 1   0 0     0   1   4 6     0 0   5     10
1713027 MN Winona 85 school 2700221 4064 Charter Schools Riverway Learning Community Charter 270022103136 20 Riverway Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_11 7 1 0   0 0     0   0   6 2     *   *     *   *   8 7 1 0   0 0     0   0   6 2                 8
1713028 MN Winona 85 school 2700221 4064 Charter Schools Riverway Learning Community Charter 270022103136 20 Riverway Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_12 10 0 0   0 0     0   1   6 5     0.0   0.0     5.0   5.0   11 10 0 0   0 0     0   1   6 5     0 0   5 5   11
1713029 MN Winona 85 school 2700221 4064 Charter Schools Riverway Learning Community Charter 270022103136 20 Riverway Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   pk_12_total 47 4 2   0 0     0   6   33 26     0.0   0.0     39.0   23.0   59 47 4 2   0 0     0   6   33 26     0 0   39 23   59
1713030 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_6 1 1 0   1 0     0   0   2 1     *   *     *   *   3 1 1 0   1 0     0   0   2 1                 3
1713031 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 2 1 0   0 0     0   0   3 0     *   *     *   *   3 2 1 0   0 0     0   0   3 0                 3
1713032 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_8 4 1 0   0 0     0   2   3 4     *   *     *   *   7 4 1 0   0 0     0   2   3 4                 7
1713033 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_9 10 0 1   0 0     0   0   5 6     0.0   0.0     6.0   4.0   11 10 0 1   0 0     0   0   5 6     0 0   6 4   11
1713034 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_10 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1713035 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_11 4 0 0   1 0     0   1   1 5     *   *     *   *   6 4 0 0   1 0     0   1   1 5                 6
1713036 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_12 12 0 3   1 0     0   2   7 11     0.0   0.0     8.0   8.0   18 12 0 3   1 0     0   2   7 11     0 0   8 8   18
1713037 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   pk_12_total 34 3 4   3 0     0   5   22 27     0.0   2.0     29.0   22.0   49 34 3 4   3 0     0   5   22 27     0 2   29 22   49
1713038 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA High School 270018603139 10 AFSA High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_8 25 7 6   0 4     0   6   26 22     0.0   0.0     24.0   8.0   48 25 7 6   0 4     0   6   26 22     0 0   24 8   48
1713039 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA High School 270018603139 10 AFSA High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_9 29 8 7   0 2     0   0   32 14     0.0   0.0     22.0   15.0   46 29 8 7   0 2     0   0   32 14     0 0   22 15   46
1713040 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA High School 270018603139 10 AFSA High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_10 27 8 5   0 0     0   1   24 17     0.0   0.0     20.0   16.0   41 27 8 5   0 0     0   1   24 17     0 0   20 16   41
1713041 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA High School 270018603139 10 AFSA High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_11 49 7 4   0 2     0   2   35 29     0.0   0.0     21.0   13.0   64 49 7 4   0 2     0   2   35 29     0 0   21 13   64
1713042 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA High School 270018603139 10 AFSA High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_12 44 2 2   0 2     0   0   34 16     0.0   0.0     10.0   16.0   50 44 2 2   0 2     0   0   34 16     0 0   10 16   50
1713043 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA High School 270018603139 10 AFSA High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   pk_12_total 174 32 24   0 10     0   9   151 98     0.0   0.0     97.0   68.0   249 174 32 24   0 10     0   9   151 98     0 0   97 68   249
1713044 MN Cass 11 school 2700191 4080 Charter Schools Pillager Area Charter School 270019103144 10 PILLAGER AREA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1713045 MN Cass 11 school 2700191 4080 Charter Schools Pillager Area Charter School 270019103144 10 PILLAGER AREA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_8 3 0 0   0 0     0   0   3 0     *   *     *   *   3 3 0 0   0 0     0   0   3 0                 3
1713046 MN Cass 11 school 2700191 4080 Charter Schools Pillager Area Charter School 270019103144 10 PILLAGER AREA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_9 4 0 0   0 0     0   0   2 2     *   *     *   *   4 4 0 0   0 0     0   0   2 2                 4
1713047 MN Cass 11 school 2700191 4080 Charter Schools Pillager Area Charter School 270019103144 10 PILLAGER AREA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_10 5 0 0   1 0     0   0   3 3     *   *     *   *   6 5 0 0   1 0     0   0   3 3                 6
1713048 MN Cass 11 school 2700191 4080 Charter Schools Pillager Area Charter School 270019103144 10 PILLAGER AREA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_11 7 0 1   1 0     0   1   6 4     0.0   0.0     8.0   3.0   10 7 0 1   1 0     0   1   6 4     0 0   8 3   10
1713049 MN Cass 11 school 2700191 4080 Charter Schools Pillager Area Charter School 270019103144 10 PILLAGER AREA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_12 16 0 4   0 0     0   1   11 10     0.0   0.0     8.0   8.0   21 16 0 4   0 0     0   1   11 10     0 0   8 8   21
1713050 MN Cass 11 school 2700191 4080 Charter Schools Pillager Area Charter School 270019103144 10 PILLAGER AREA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   pk_12_total 36 0 5   2 0     0   2   26 19     0.0   0.0     25.0   19.0   45 36 0 5   2 0     0   2   26 19     0 0   25 19   45
1713051 MN Rice 66 school 2700192 4081 Charter Schools Discovery Public School Faribault 270019203145 10 Discovery Public School Faribault Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_6 2 0 0   0 0     0   0   1 1     *   *     *   *   2 2 0 0   0 0     0   0   1 1                 2
1713052 MN Rice 66 school 2700192 4081 Charter Schools Discovery Public School Faribault 270019203145 10 Discovery Public School Faribault Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 1 0 1   0 0     0   0   1 1     *   *     *   *   2 1 0 1   0 0     0   0   1 1                 2
1713053 MN Rice 66 school 2700192 4081 Charter Schools Discovery Public School Faribault 270019203145 10 Discovery Public School Faribault Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_8 8 1 0   0 0     0   1   7 3     0.0   0.0     7.0   5.0   10 8 1 0   0 0     0   1   7 3     0 0   7 5   10

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