Data source: Big Local News · About: Big Local

6,719 rows where grade = "grade_2" and state = "MN" sorted by school

View and edit SQL

year

grade

  • grade_2 · 6,719
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
1157956 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002602124 60 917 D/HH GIDEON POND ELEMENTARY Special Education Special Education School No 4 PK 12 2015   grade_2 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 2 0 0   0 0     0   0   1 1                 2
865423 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002603897 500 917 DASH Special Education Special Education School No 4 PK 12 2016   grade_2 1 0 0   0 0     0   0   1 0         *         *   1 1 0 0   0 0     0   0   1 0                 1
1892120 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002603897 500 917 DASH Special Education Special Education School No Other PK 12 2018   grade_2 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
1956661 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002603897 500 917 DASH Special Education Special Education School No Other PK 12 2019   grade_2 1.0 1.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 1 1 0   0 0     0   0   2 0                 2
701148 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002602121 51 917 INTRA-DAKOTA EDUCATIONAL ALT Special Education Special Education School No Other KG 12 2017   grade_2 0.0 2.0 0.0   0.0 0.0     0.0   1.0   3.0 0.0         *         *   3.0 0 2 0   0 0     0   1   3 0                 3
1157943 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002602121 51 917 INTRA-DAKOTA EDUCATIONAL ALT Special Education Special Education School No 4 KG 12 2015   grade_2 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0         *         *   1.0 0 0 0   0 0     0   1   1 0                 1
1956610 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002602121 51 917 INTRA-DAKOTA EDUCATIONAL ALT Special Education Special Education School No Other KG 12 2019   grade_2 0.0 0.0 1.0   0.0 0.0     0.0   1.0   1.0 1.0     *   *         *   2.0 0 0 1   0 0     0   1   1 1                 2
1724007 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602121 51 917 Intra-Dakota Educational Alt Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1837560 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602121 51 917 Intra-Dakota Educational Alt Special Education Special Education School No Other KG 12 2020   grade_2 2.0 0.0 1.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *         *   3.0 2 0 1   0 0     0   0   3 0                 3
1892067 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602121 51 917 Intra-Dakota Educational Alt Special Education Special Education School No Other KG 12 2018   grade_2 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0     *   *     *   *   1.0 0 0 0   0 0     0   1   1 0                 1
701171 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002602125 61 917 PACES Special Education Special Education School No Other KG 12 2017   grade_2 0.0 0.0 0.0   0.0 1.0     0.0   0.0   1.0 0.0         *         *   1.0 0 0 0   0 1     0   0   1 0                 1
865397 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002602125 61 917 PACES Special Education Special Education School No 4 KG 12 2016   grade_2 1 0 0   0 1     0   0   2 0         *         *   2 1 0 0   0 1     0   0   2 0                 2
1157965 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002602125 61 917 PACES Special Education Special Education School No 4 KG 12 2015   grade_2 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
1892093 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602125 61 917 PACES Special Education Special Education School No Other KG 12 2018   grade_2 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
1956636 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002602125 61 917 PACES Special Education Special Education School No Other KG 12 2019   grade_2 0.0 0.0 1.0   0.0 0.0     0.0   1.0   2.0 0.0     *   *         *   2.0 0 0 1   0 0     0   1   2 0                 2
1724032 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602125 61 917 Paces Special Education Special Education School No Other KG 12 2021   grade_2 2 0 0   0 1     0   0   3 0     *   *     *   *   3 2 0 0   0 1     0   0   3 0                 3
1837587 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602125 61 917 Paces Special Education Special Education School No Other KG 12 2020   grade_2 2.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 1.0     *   *         *   3.0 2 0 0   0 0     0   1   2 1                 3
701185 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002604218 400 917 SUN Special Education Special Education School No Other KG 12 2017   grade_2 6.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 2.0         *         *   6.0 6 0 0   0 0     0   0   4 2                 6
865410 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002604218 400 917 SUN Special Education Special Education School No 4 KG 12 2016   grade_2 3 1 0   0 0     0   0   3 1         *         *   4 3 1 0   0 0     0   0   3 1                 4
1157977 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002604218 400 917 SUN Special Education Special Education School No 4 KG 12 2015   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 0.0         *         *   2.0 1 0 0   0 0     0   1   2 0                 2
1892106 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002604218 400 917 SUN Special Education Special Education School No Other KG 12 2018   grade_2 3.0 1.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0     *   *     *   *   4.0 3 1 0   0 0     0   0   3 1                 4
1956649 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002604218 400 917 SUN Special Education Special Education School No Other KG 12 2019   grade_2 4.0 3.0 1.0   0.0 1.0     0.0   0.0   8.0 1.0     *   *         *   9.0 4 3 1   0 1     0   0   8 1                 9
1724045 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002604218 400 917 Sun Special Education Special Education School No Other KG 12 2021   grade_2 6 1 2   0 1     0   1   10 1     0.0   0.0     6.0   *   11 6 1 2   0 1     0   1   10 1     0 0   6     11
1837601 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002604218 400 917 Sun Special Education Special Education School No Other KG 12 2020   grade_2 3.0 2.0 0.0   0.0 0.0     0.0   0.0   3.0 2.0     *   *         *   5.0 3 2 0   0 0     0   0   3 2                 5
695861 MN Kandiyohi 34 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602568 100 A.C.G.C. ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 64.0 0.0 8.0   1.0 1.0     0.0   1.0   43.0 32.0     2.0   0.0     36.0   9.0   75.0 64 0 8   1 1     0   1   43 32     2 0   36 9   75
860155 MN Kandiyohi 34 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602568 100 A.C.G.C. ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 04 2016   grade_2 46 1 5   0 0     0   1   23 30     2.0   0.0     21.0   8.0   53 46 1 5   0 0     0   1   23 30     2 0   21 8   53
1152839 MN Kandiyohi 34 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602568 100 A.C.G.C. ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 04 2015   grade_2 53.0 1.0 4.0   0.0 0.0     0.0   0.0   34.0 24.0     0.0   0.0     31.0   7.0   58.0 53 1 4   0 0     0   0   34 24     0 0   31 7   58
1951342 MN Kandiyohi 34 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602568 100 A.C.G.C. ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_2 44.0 0.0 6.0   1.0 0.0     0.0   3.0   26.0 28.0     1.0   0.0     27.0   8.0   54.0 44 0 6   1 0     0   3   26 28     1 0   27 8   54
1718647 MN Kandiyohi 34 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602568 100 A.C.G.C. Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_2 52 0 4   0 0     0   3   30 29     1.0   0.0     20.0   10.0   59 52 0 4   0 0     0   3   30 29     1 0   20 10   59
1832222 MN Kandiyohi 34 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602568 100 A.C.G.C. Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2020   grade_2 56.0 0.0 4.0   0.0 1.0     0.0   1.0   36.0 26.0     2.0   0.0     36.0   15.0   62.0 56 0 4   0 1     0   1   36 26     2 0   36 15   62
1886758 MN Kandiyohi 34 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602568 100 A.C.G.C. Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2018   grade_2 53.0 0.0 3.0   0.0 0.0     0.0   1.0   30.0 27.0     1.0   0.0     26.0   7.0   57.0 53 0 3   0 0     0   1   30 27     1 0   26 7   57
861143 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 ACADEMIA CESAR CHAVEZ CHARTER SCH. Elementary School (Grades PK-6) Regular School Yes 1 PK 06 2016   grade_2 2 2 46   1 0     0   1   25 27     35.0   2.0         6.0   52 2 2 46   1 0     0   1   25 27     35 2     6   52
1153850 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 ACADEMIA CESAR CHAVEZ CHARTER SCH. Elementary School (Grades PK-6) Regular School Yes 1 PK 06 2015   grade_2 1.0 0.0 56.0   1.0 2.0     0.0   1.0   39.0 22.0     44.0   1.0         5.0   61.0 1 0 56   1 2     0   1   39 22     44 1     5   61
696716 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_2 1.0 9.0 18.0   1.0 10.0     0.0   4.0   20.0 23.0     25.0   1.0     33.0   3.0   43.0 1 9 18   1 10     0   4   20 23     25 1   33 3   43
860979 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2016   grade_2 8 1 17   0 21     0   1   23 25     32.0   2.0     41.0   5.0   48 8 1 17   0 21     0   1   23 25     32 2   41 5   48
1153687 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2015   grade_2 7.0 7.0 14.0   0.0 21.0     0.0   1.0   26.0 24.0     31.0   0.0     40.0   2.0   50.0 7 7 14   0 21     0   1   26 24     31 0   40 2   50
1952196 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_2 6.0 6.0 18.0   1.0 13.0     0.0   2.0   15.0 31.0     30.0   1.0     40.0   2.0   46.0 6 6 18   1 13     0   2   15 31     30 1   40 2   46
696066 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600050 10 ADA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_2 24.0 0.0 2.0   0.0 0.0     0.0   2.0   19.0 9.0     0.0   1.0     16.0   3.0   28.0 24 0 2   0 0     0   2   19 9     0 1   16 3   28
860354 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600050 10 ADA ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 06 2016   grade_2 34 0 7   1 0     0   4   21 25     0.0   0.0     27.0   6.0   46 34 0 7   1 0     0   4   21 25     0 0   27 6   46
1153040 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600050 10 ADA ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 06 2015   grade_2 30.0 0.0 2.0   1.0 0.0     0.0   1.0   16.0 18.0     0.0   0.0     12.0   4.0   34.0 30 0 2   1 0     0   1   16 18     0 0   12 4   34
1951537 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600050 10 ADA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 29.0 0.0 4.0   0.0 0.0     0.0   4.0   18.0 19.0     1.0   1.0     23.0   7.0   37.0 29 0 4   0 0     0   4   18 19     1 1   23 7   37
690577 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 2017   grade_2 47.0 15.0 5.0   0.0 6.0     0.0   4.0   33.0 44.0     16.0   0.0     45.0   14.0   77.0 47 15 5   0 6     0   4   33 44     16 0   45 14   77
693483 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188000571 130 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 02 2017   grade_2 174.0 7.0 4.0   1.0 1.0     1.0   10.0   104.0 94.0         *     68.0   *   198.0 174 7 4   1 1     1   10   104 94           68     198
854972 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 1 KG 05 2016   grade_2 47 12 4   2 4     0   10   40 39     7.0   3.0     52.0   15.0   79 47 12 4   2 4     0   10   40 39     7 3   52 15   79
857799 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188000571 130 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 01 02 2016   grade_2 170 5 4   3 1     1   3   96 91     6.0   0.0     81.0   18.0   187 170 5 4   3 1     1   3   96 91     6 0   81 18   187
1147637 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 1 KG 05 2015   grade_2 71.0 13.0 6.0   2.0 5.0     0.0   3.0   56.0 44.0     19.0   1.0     58.0   13.0   100.0 71 13 6   2 5     0   3   56 44     19 1   58 13   100
1150478 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188000571 130 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 01 02 2015   grade_2 171.0 3.0 5.0   1.0 2.0     0.0   5.0   93.0 94.0         0.0         17.0   187.0 171 3 5   1 2     0   5   93 94       0     17   187
1945940 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 2019   grade_2 48.0 22.0 6.0   0.0 7.0     0.0   9.0   50.0 42.0     19.0   6.0     56.0   20.0   92.0 48 22 6   0 7     0   9   50 42     19 6   56 20   92
1948911 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188000571 130 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 02 2019   grade_2 158.0 7.0 2.0   0.0 0.0     2.0   3.0   84.0 88.0     *   *     64.0   7.0   172.0 158 7 2   0 0     2   3   84 88           64 7   172
693872 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001133 410 ADAMS MAGNET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 24.0 16.0 60.0   1.0 1.0     0.0   11.0   50.0 63.0     29.0   1.0     64.0   2.0   113.0 24 16 60   1 1     0   11   50 63     29 1   64 2   113
858187 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001133 410 ADAMS MAGNET ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2016   grade_2 36 20 74   0 1     0   11   70 72     40.0   *     73.0   10.0   142 36 20 74   0 1     0   11   70 72     40     73 10   142
1150866 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001133 410 ADAMS MAGNET ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2015   grade_2 33.0 28.0 68.0   2.0 0.0     0.0   3.0   71.0 63.0     25.0   1.0     79.0   6.0   134.0 33 28 68   2 0     0   3   71 63     25 1   79 6   134
1949327 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001133 410 ADAMS MAGNET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 28.0 17.0 54.0   0.0 0.0     0.0   8.0   56.0 51.0     28.0   0.0     52.0   8.0   107.0 28 17 54   0 0     0   8   56 51     28 0   52 8   107
693302 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273000055 10 ADRIAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 34.0 0.0 1.0   0.0 0.0     0.0   0.0   20.0 15.0     0.0   0.0         2.0   35.0 34 0 1   0 0     0   0   20 15     0 0     2   35
857619 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273000055 10 ADRIAN ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 05 2016   grade_2 29 0 2   0 0     0   1   20 12         0.0         3.0   32 29 0 2   0 0     0   1   20 12       0     3   32
1150297 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273000055 10 ADRIAN ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 05 2015   grade_2 31.0 0.0 3.0   0.0 1.0     0.0   2.0   17.0 20.0     0.0   0.0     13.0   4.0   37.0 31 0 3   0 1     0   2   17 20     0 0   13 4   37
1948726 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273000055 10 ADRIAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 37.0 0.0 4.0   0.0 0.0     0.0   6.0   20.0 27.0     3.0   0.0     21.0   11.0   47.0 37 0 4   0 0     0   6   20 27     3 0   21 11   47
1719678 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA High School 270018604854 20 AFSA Middle School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_2 7 3 0   0 1     0   4   7 8     0.0   0.0     10.0   3.0   15 7 3 0   0 1     0   4   7 8     0 0   10 3   15
1833233 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA High School 270018604854 20 AFSA Middle School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 6.0 1.0 2.0   0.0 0.0     0.0   3.0   6.0 6.0     0.0   0.0     5.0   *   12.0 6 1 2   0 0     0   3   6 6     0 0   5     12
695157 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001654 785 AFTON-LAKELAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_2 56.0 4.0 1.0   0.0 4.0     0.0   5.0   36.0 34.0         0.0     8.0   4.0   70.0 56 4 1   0 4     0   5   36 34       0   8 4   70
859448 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001654 785 AFTON-LAKELAND ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 06 2016   grade_2 59 5 4   0 4     0   4   29 47     0.0   *     9.0   13.0   76 59 5 4   0 4     0   4   29 47     0     9 13   76
1152127 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001654 785 AFTON-LAKELAND ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 06 2015   grade_2 58.0 4.0 3.0   0.0 4.0     0.0   1.0   34.0 36.0     2.0   0.0     12.0   6.0   70.0 58 4 3   0 4     0   1   34 36     2 0   12 6   70
1950674 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001654 785 AFTON-LAKELAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 55.0 0.0 5.0   0.0 5.0     0.0   4.0   32.0 37.0     4.0   0.0     11.0   9.0   69.0 55 0 5   0 5     0   4   32 37     4 0   11 9   69
691609 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002205 621 AKIN ROAD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 82.0 2.0 9.0   3.0 1.0     0.0   8.0   40.0 65.0     8.0   2.0     15.0   4.0   105.0 82 2 9   3 1     0   8   40 65     8 2   15 4   105
855985 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002205 621 AKIN ROAD ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 05 2016   grade_2 90 2 5   2 8     0   10   65 52     9.0   0.0     25.0   10.0   117 90 2 5   2 8     0   10   65 52     9 0   25 10   117
1148652 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002205 621 AKIN ROAD ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 05 2015   grade_2 102.0 3.0 11.0   1.0 8.0     0.0   7.0   64.0 68.0     16.0   0.0     29.0   11.0   132.0 102 3 11   1 8     0   7   64 68     16 0   29 11   132
1946982 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002205 621 AKIN ROAD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 74.0 4.0 5.0   1.0 3.0     0.0   7.0   53.0 41.0     6.0   0.0     14.0   *   94.0 74 4 5   1 3     0   7   53 41     6 0   14     94
694757 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000062 10 ALBANY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 06 2017   grade_2 89.0 0.0 1.0   0.0 0.0     0.0   0.0   53.0 37.0     1.0   1.0     21.0   14.0   90.0 89 0 1   0 0     0   0   53 37     1 1   21 14   90
859056 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000062 10 ALBANY ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 01 06 2016   grade_2 66 0 4   0 0     0   3   36 37     3.0   1.0         11.0   73 66 0 4   0 0     0   3   36 37     3 1     11   73
1151734 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000062 10 ALBANY ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 06 2015   grade_2 73.0 0.0 2.0   0.0 0.0     0.0   1.0   42.0 34.0         0.0     25.0   17.0   76.0 73 0 2   0 0     0   1   42 34       0   25 17   76
1950273 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000062 10 ALBANY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 77.0 0.0 1.0   0.0 0.0     0.0   1.0   43.0 36.0     0.0   1.0     13.0   13.0   79.0 77 0 1   0 0     0   1   43 36     0 1   13 13   79
692019 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_2 33.0 0.0 3.0   0.0 0.0     0.0   1.0   11.0 26.0     0.0   0.0     15.0   3.0   37.0 33 0 3   0 0     0   1   11 26     0 0   15 3   37
856395 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 06 2016   grade_2 38 0 0   0 0     0   0   18 20     0.0   0.0     13.0   8.0   38 38 0 0   0 0     0   0   18 20     0 0   13 8   38
1149061 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 06 2015   grade_2 31.0 0.0 1.0   0.0 0.0     0.0   0.0   18.0 14.0     0.0   0.0     11.0   1.0   32.0 31 0 1   0 0     0   0   18 14     0 0   11 1   32
1947406 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 30.0 0.0 3.0   0.0 0.0     0.0   0.0   19.0 14.0     0.0   0.0     10.0   4.0   33.0 30 0 3   0 0     0   0   19 14     0 0   10 4   33
692076 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001886 561 ALICE SMITH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_2 19.0 19.0 14.0   0.0 10.0     0.0   6.0   41.0 27.0     15.0   2.0     40.0   5.0   68.0 19 19 14   0 10     0   6   41 27     15 2   40 5   68
856453 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001886 561 ALICE SMITH ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 06 2016   grade_2 41 25 16   0 8     0   9   52 47     17.0   1.0     48.0   9.0   99 41 25 16   0 8     0   9   52 47     17 1   48 9   99
1149119 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001886 561 ALICE SMITH ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 06 2015   grade_2 33.0 24.0 10.0   0.0 7.0     1.0   7.0   38.0 44.0     21.0   0.0     45.0   5.0   82.0 33 24 10   0 7     1   7   38 44     21 0   45 5   82
1947464 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001886 561 ALICE SMITH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 34.0 11.0 6.0   0.0 4.0     0.0   11.0   40.0 26.0     7.0   0.0     23.0   8.0   66.0 34 11 6   0 4     0   11   40 26     7 0   23 8   66
701121 MN Washington 82 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226402100 50 ALP @ VCCS Special Education Special Education School No Elementary KG 06 2017   grade_2 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
865345 MN Washington 82 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226402100 50 ALP @ VCCS Special Education Special Education School No 1 KG 06 2016   grade_2 0 1 1   0 0     0   0   2 0         *         *   2 0 1 1   0 0     0   0   2 0                 2
1157917 MN Washington 82 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226402100 50 ALP @ VCCS Special Education Special Education School No 1 KG 06 2015   grade_2 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
694170 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002303 579 AMERICAN INDIAN MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_2 5.0 14.0 10.0   7.0 17.0     0.0   13.0   37.0 29.0     20.0   1.0         7.0   66.0 5 14 10   7 17     0   13   37 29     20 1     7   66
858482 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002303 579 AMERICAN INDIAN MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_2 5 14 16   9 21     0   10   40 35     31.0   4.0         10.0   75 5 14 16   9 21     0   10   40 35     31 4     10   75
1151160 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002303 579 AMERICAN INDIAN MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_2 8.0 15.0 16.0   11.0 14.0     0.0   10.0   37.0 37.0     16.0   4.0         14.0   74.0 8 15 16   11 14     0   10   37 37     16 4     14   74
1949666 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002303 579 AMERICAN INDIAN MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   grade_2 3.0 3.0 20.0   5.0 15.0     1.0   13.0   30.0 30.0     21.0   *     53.0   10.0   60.0 3 3 20   5 15     1   13   30 30     21     53 10   60
696474 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000932 190 ANDERSEN COMMUNITY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_2 6.0 39.0 55.0   5.0 1.0     0.0   4.0   62.0 48.0     79.0   13.0         11.0   110.0 6 39 55   5 1     0   4   62 48     79 13     11   110
860756 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000932 190 ANDERSEN COMMUNITY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_2 3 34 69   3 1     0   0   58 52     83.0   13.0         14.0   110 3 34 69   3 1     0   0   58 52     83 13     14   110
1153459 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000932 190 ANDERSEN COMMUNITY Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_2 10.0 37.0 84.0   6.0 4.0     0.0   1.0   76.0 66.0     117.0   18.0         16.0   142.0 10 37 84   6 4     0   1   76 66     117 18     16   142
1951952 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000932 190 ANDERSEN COMMUNITY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   grade_2 1.0 33.0 35.0   3.0 2.0     0.0   1.0   32.0 43.0     56.0   7.0         8.0   75.0 1 33 35   3 2     0   1   32 43     56 7     8   75
695165 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001655 786 ANDERSEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_2 57.0 0.0 1.0   0.0 2.0     0.0   6.0   35.0 31.0         1.0     9.0   7.0   66.0 57 0 1   0 2     0   6   35 31       1   9 7   66
859456 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001655 786 ANDERSEN ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 06 2016   grade_2 43 0 2   1 2     0   1   27 22     2.0   0.0     6.0   3.0   49 43 0 2   1 2     0   1   27 22     2 0   6 3   49
1152135 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001655 786 ANDERSEN ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 06 2015   grade_2 40.0 0.0 0.0   0.0 1.0     0.0   1.0   21.0 21.0     1.0   0.0     5.0   5.0   42.0 40 0 0   0 1     0   1   21 21     1 0   5 5   42
1950681 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001655 786 ANDERSEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 51.0 0.0 1.0   0.0 1.0     0.0   5.0   22.0 36.0     1.0   0.0     8.0   7.0   58.0 51 0 1   0 1     0   5   22 36     1 0   8 7   58
690725 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002203 426 ANDOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 185.0 9.0 11.0   0.0 1.0     0.0   4.0   105.0 105.0     9.0   1.0     29.0   27.0   210.0 185 9 11   0 1     0   4   105 105     9 1   29 27   210
855119 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002203 426 ANDOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2016   grade_2 177 4 5   0 15     0   4   110 95     13.0   1.0     42.0   18.0   205 177 4 5   0 15     0   4   110 95     13 1   42 18   205
1147784 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002203 426 ANDOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2015   grade_2 214.0 4.0 8.0   0.0 5.0     0.0   4.0   116.0 119.0     12.0   1.0     41.0   17.0   235.0 214 4 8   0 5     0   4   116 119     12 1   41 17   235
1946089 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002203 426 ANDOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 194.0 10.0 7.0   0.0 6.0     1.0   10.0   130.0 98.0     14.0   2.0     41.0   30.0   228.0 194 10 7   0 6     1   10   130 98     14 2   41 30   228
694283 MN Lake of the Woods 39 school 2741850 690 Independent Districts and Schools WARROAD PUBLIC SCHOOL DISTRICT 274185002456 20 ANGLE INLET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_2 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
858593 MN Lake of the Woods 39 school 2741850 690 Independent Districts and Schools WARROAD PUBLIC SCHOOL DISTRICT 274185002456 20 ANGLE INLET ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 06 2016   grade_2 1 0 0   1 0     0   0   2 0         *         *   2 1 0 0   1 0     0   0   2 0                 2

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