Data source: Big Local News · About: Big Local

975 rows where grade = "grade_2", state = "MN" and year = 2020 sorted by district

View and edit SQL

year

  • 2020 · 975

grade

  • grade_2 · 975
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
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
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
1833223 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 Academia Cesar Chavez Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_2 0.0 1.0 50.0   0.0 0.0     0.0   1.0   24.0 28.0     40.0   1.0     42.0   8.0   52.0 0 1 50   0 0     0   1   24 28     40 1   42 8   52
1833062 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 2020   grade_2 5.0 5.0 26.0   0.0 9.0     0.0   3.0   26.0 22.0     26.0   0.0     43.0   7.0   48.0 5 5 26   0 9     0   3   26 22     26 0   43 7   48
1832413 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 2020   grade_2 27.0 0.0 4.0   1.0 0.0     0.0   6.0   16.0 22.0     0.0   0.0     23.0   5.0   38.0 27 0 4   1 0     0   6   16 22     0 0   23 5   38
1829610 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 2020   grade_2 30.0 0.0 5.0   0.0 1.0     0.0   1.0   16.0 21.0     3.0   0.0     15.0   4.0   37.0 30 0 5   0 1     0   1   16 21     3 0   15 4   37
1833799 MN Hennepin 27 school 2700394 4220 Charter Schools Agamim Classical Academy 270039404751 10 Agamim Classical Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 20.0 8.0 5.0   0.0 16.0     0.0   3.0   26.0 26.0     7.0   0.0     8.0   6.0   52.0 20 8 5   0 16     0   3   26 26     7 0   8 6   52
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
1831158 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 2020   grade_2 88.0 2.0 5.0   0.0 0.0     0.0   3.0   42.0 56.0     4.0   0.0     25.0   24.0   98.0 88 2 5   0 0     0   3   42 56     4 0   25 24   98
1831166 MN Stearns 73 school 2702930 745 Independent Districts and Schools Albany Public School District 270293000065 30 Avon Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 47.0 0.0 0.0   0.0 0.0     0.0   1.0   27.0 21.0     0.0   0.0     11.0   7.0   48.0 47 0 0   0 0     0   1   27 21     0 0   11 7   48
1828250 MN Freeborn 24 school 2702970 241 Independent Districts and Schools Albert Lea Public School District 270297000070 110 Halverson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 19.0 4.0 27.0   1.0 7.0     0.0   2.0   36.0 24.0     14.0   0.0     44.0   20.0   60.0 19 4 27   1 7     0   2   36 24     14 0   44 20   60
1828259 MN Freeborn 24 school 2702970 241 Independent Districts and Schools Albert Lea Public School District 270297000071 120 Hawthorne Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 39.0 2.0 8.0   0.0 5.0     0.0   8.0   36.0 26.0     *   0.0     35.0   7.0   62.0 39 2 8   0 5     0   8   36 26       0   35 7   62
1828266 MN Freeborn 24 school 2702970 241 Independent Districts and Schools Albert Lea Public School District 270297000074 130 Lakeview Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 40.0 1.0 14.0   0.0 1.0     0.0   2.0   33.0 25.0     *   0.0     30.0   14.0   58.0 40 1 14   0 1     0   2   33 25       0   30 14   58
1828273 MN Freeborn 24 school 2702970 241 Independent Districts and Schools Albert Lea Public School District 270297000077 140 Sibley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 30.0 2.0 10.0   0.0 14.0     0.0   1.0   34.0 23.0     13.0   0.0     33.0   13.0   57.0 30 2 10   0 14     0   1   34 23     13 0   33 13   57
1828280 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 2020   grade_2 34.0 0.0 0.0   0.0 0.0     0.0   0.0   18.0 16.0     0.0   0.0     7.0   6.0   34.0 34 0 0   0 0     0   0   18 16     0 0   7 6   34
1828161 MN Douglas 21 school 2703060 206 Independent Districts and Schools Alexandria Public School District 270306000082 110 Carlos Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 17.0 0.0 1.0   0.0 0.0     0.0   1.0   7.0 12.0     0.0   0.0     6.0   6.0   19.0 17 0 1   0 0     0   1   7 12     0 0   6 6   19
1828168 MN Douglas 21 school 2703060 206 Independent Districts and Schools Alexandria Public School District 270306000084 120 Garfield Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 24.0 0.0 2.0   0.0 0.0     0.0   0.0   9.0 17.0     0.0   1.0     7.0   *   26.0 24 0 2   0 0     0   0   9 17     0 1   7     26
1828175 MN Douglas 21 school 2703060 206 Independent Districts and Schools Alexandria Public School District 270306000086 130 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 66.0 3.0 3.0   0.0 0.0     0.0   7.0   48.0 31.0     0.0   0.0     21.0   12.0   79.0 66 3 3   0 0     0   7   48 31     0 0   21 12   79
1828182 MN Douglas 21 school 2703060 206 Independent Districts and Schools Alexandria Public School District 270306000087 140 Miltona Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 24.0 0.0 0.0   0.0 0.0     0.0   1.0   16.0 9.0     0.0   1.0     4.0   *   25.0 24 0 0   0 0     0   1   16 9     0 1   4     25
1828189 MN Douglas 21 school 2703060 206 Independent Districts and Schools Alexandria Public School District 270306000088 150 Woodland Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 65.0 1.0 4.0   0.0 1.0     0.0   4.0   40.0 35.0     2.0   1.0     35.0   20.0   75.0 65 1 4   0 1     0   4   40 35     2 1   35 20   75
1828196 MN Douglas 21 school 2703060 206 Independent Districts and Schools Alexandria Public School District 270306002229 160 Voyager Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 68.0 0.0 6.0   0.0 2.0     0.0   2.0   40.0 38.0     6.0   2.0     28.0   14.0   78.0 68 0 6   0 2     0   2   40 38     6 2   28 14   78
1831705 MN Wright 86 school 2703150 876 Independent Districts and Schools Annandale Public School District 270315000094 1 Annandale Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 148.0 1.0 4.0   0.0 1.0     0.0   7.0   81.0 80.0     2.0   0.0     43.0   26.0   161.0 148 1 4   0 1     0   7   81 80     2 0   43 26   161
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
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
1826823 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000105 403 Franklin Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 27.0 9.0 8.0   2.0 0.0     0.0   2.0   26.0 22.0     8.0   *     31.0   12.0   48.0 27 9 8   2 0     0   2   26 22     8     31 12   48
1826830 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000106 404 Hamilton Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 42.0 17.0 7.0   1.0 8.0     0.0   3.0   45.0 33.0     18.0   3.0     51.0   18.0   78.0 42 17 7   1 8     0   3   45 33     18 3   51 18   78
1826837 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary - Biomedical, Health Sciences and Engineering Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 39.0 10.0 11.0   0.0 9.0     0.0   13.0   36.0 46.0     15.0   3.0     45.0   6.0   82.0 39 10 11   0 9     0   13   36 46     15 3   45 6   82
1826844 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000110 406 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 56.0 9.0 7.0   0.0 9.0     0.0   12.0   46.0 47.0     8.0   1.0     31.0   21.0   93.0 56 9 7   0 9     0   12   46 47     8 1   31 21   93
1826851 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000111 407 Johnsville Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 64.0 6.0 7.0   1.0 8.0     0.0   10.0   50.0 46.0     8.0   1.0     33.0   20.0   96.0 64 6 7   1 8     0   10   50 46     8 1   33 20   96
1826858 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000112 408 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 53.0 9.0 4.0   0.0 1.0     0.0   14.0   39.0 42.0     3.0   1.0     39.0   14.0   81.0 53 9 4   0 1     0   14   39 42     3 1   39 14   81
1826865 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000113 410 Madison Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 40.0 10.0 10.0   0.0 9.0     0.0   3.0   47.0 25.0     19.0   0.0     35.0   17.0   72.0 40 10 10   0 9     0   3   47 25     19 0   35 17   72
1826872 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 81.0 1.0 0.0   1.0 3.0     0.0   9.0   49.0 46.0     3.0   0.0     13.0   15.0   95.0 81 1 0   1 3     0   9   49 46     3 0   13 15   95
1826879 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000115 412 Mississippi Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 39.0 9.0 5.0   0.0 4.0     0.0   8.0   36.0 29.0     6.0   1.0     34.0   16.0   65.0 39 9 5   0 4     0   8   36 29     6 1   34 16   65
1826886 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000116 413 Monroe Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 28.0 18.0 9.0   0.0 26.0     0.0   11.0   55.0 37.0     30.0   2.0     44.0   14.0   92.0 28 18 9   0 26     0   11   55 37     30 2   44 14   92
1826893 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000118 414 Morris Bye Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 55.0 12.0 6.0   0.0 9.0     0.0   7.0   37.0 52.0     7.0   3.0     31.0   22.0   89.0 55 12 6   0 9     0   7   37 52     7 3   31 22   89
1826900 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000123 417 Sand Creek Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 63.0 21.0 3.0   0.0 9.0     0.0   10.0   58.0 48.0     18.0   2.0     40.0   18.0   106.0 63 21 3   0 9     0   10   58 48     18 2   40 18   106
1826908 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 University Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 64.0 22.0 12.0   0.0 11.0     0.0   7.0   65.0 51.0     14.0   3.0     54.0   19.0   116.0 64 22 12   0 11     0   7   65 51     14 3   54 19   116
1826915 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000128 420 Wilson Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 44.0 11.0 9.0   0.0 4.0     0.0   7.0   35.0 40.0     8.0   2.0     31.0   13.0   75.0 44 11 9   0 4     0   7   35 40     8 2   31 13   75
1826923 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000104 421 Evergreen Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 2.0 19.0 16.0   1.0 21.0     0.0   7.0   36.0 30.0     36.0   2.0     49.0   12.0   66.0 2 19 16   1 21     0   7   36 30     36 2   49 12   66
1826930 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000103 422 Eisenhower Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 32.0 8.0 14.0   0.0 2.0     0.0   4.0   34.0 26.0     12.0   3.0     38.0   12.0   60.0 32 8 14   0 2     0   4   34 26     12 3   38 12   60
1826937 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000120 423 Ramsey Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 88.0 25.0 4.0   0.0 7.0     0.0   11.0   70.0 65.0     20.0   3.0     44.0   18.0   135.0 88 25 4   0 7     0   11   70 65     20 3   44 18   135
1826944 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000102 424 Dayton Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 54.0 8.0 7.0   0.0 2.0     1.0   5.0   40.0 37.0     8.0   0.0     20.0   12.0   77.0 54 8 7   0 2     1   5   40 37     8 0   20 12   77
1826951 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002193 425 Oxbow Creek Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 109.0 24.0 9.0   1.0 25.0     0.0   20.0   83.0 105.0     20.0   2.0     43.0   20.0   188.0 109 24 9   1 25     0   20   83 105     20 2   43 20   188
1826958 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 2020   grade_2 160.0 4.0 5.0   0.0 6.0     0.0   19.0   90.0 104.0     4.0   0.0     24.0   28.0   194.0 160 4 5   0 6     0   19   90 104     4 0   24 28   194
1826965 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318003058 427 Rum River Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 118.0 1.0 7.0   0.0 1.0     0.0   12.0   70.0 69.0     3.0   0.0     19.0   15.0   139.0 118 1 7   0 1     0   12   70 69     3 0   19 15   139
1826972 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318004406 430 Champlin/Brooklyn Pk Acd Math Env Sci Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 79.0 23.0 8.0   1.0 10.0     0.0   13.0   77.0 57.0     10.0   1.0     42.0   25.0   134.0 79 23 8   1 10     0   13   77 57     10 1   42 25   134
1826979 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318005272 431 Sunrise Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 117.0 14.0 5.0   0.0 12.0     0.0   15.0   73.0 90.0     13.0   2.0     17.0   15.0   163.0 117 14 5   0 12     0   15   73 90     13 2   17 15   163
1826986 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318005266 432 Brookside Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 92.0 3.0 7.0   1.0 5.0     0.0   8.0   53.0 63.0     10.0   2.0     21.0   21.0   116.0 92 3 7   1 5     0   8   53 63     10 2   21 21   116
1836924 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 River Trail Learning Ctr @ LO Jacob Special Education Special Education School No Other KG 12 2020   grade_2 9.0 1.0 0.0   1.0 0.0     0.0   1.0   8.0 4.0     0.0   1.0     4.0   *   12.0 9 1 0   1 0     0   1   8 4     0 1   4     12
1833857 MN Isanti 30 school 2700397 4227 Charter Schools Art and Science Academy 270039704766 10 Art and Science Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2020   grade_2 32.0 0.0 0.0   0.0 0.0     0.0   4.0   17.0 19.0     0.0   0.0     12.0   5.0   36.0 32 0 0   0 0     0   4   17 19     0 0   12 5   36
1828321 MN Grant 26 school 2703300 261 Independent Districts and Schools Ashby Public School District 270330000136 10 Ashby Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 26.0 0.0 1.0   0.0 0.0     0.0   0.0   15.0 12.0     0.0   *     11.0   3.0   27.0 26 0 1   0 0     0   0   15 12     0     11 3   27
1833608 MN Scott 70 school 2700311 4184 Charter Schools Aspen Academy 270031104282 10 Aspen Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 67.0 9.0 3.0   0.0 6.0     1.0   5.0   46.0 45.0     13.0   0.0     19.0   8.0   91.0 67 9 3   0 6     1   5   46 45     13 0   19 8   91
1833940 MN Stearns 73 school 2700430 4250 Charter Schools Athlos Academy of Saint Cloud 270043004959 10 Athlos Academy of Saint Cloud Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 16.0 43.0 8.0   0.0 0.0     0.0   5.0   32.0 40.0     29.0   1.0     55.0   4.0   72.0 16 43 8   0 0     0   5   32 40     29 1   55 4   72
1833011 MN Hennepin 27 school 2700096 4011 Charter Schools Athlos Leadership Academy 270009601892 10 Athlos Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_2 13.0 67.0 4.0   1.0 6.0     0.0   10.0   50.0 51.0     6.0   2.0     77.0   13.0   101.0 13 67 4   1 6     0   10   50 51     6 2   77 13   101
1833194 MN Hennepin 27 school 2700220 4067 Charter Schools Aurora Charter School 270022003473 10 Aurora Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 04 2020   grade_2 0.0 0.0 40.0   0.0 0.0     0.0   0.0   20.0 20.0     *   0.0     35.0   5.0   40.0 0 0 40   0 0     0   0   20 20       0   35 5   40
1834010 MN Beltrami 4 school 2700455 4271 Charter Schools Aurora Waasakone Community of Learners Charter School 270045505196 10 Aurora Waasakone Community of Learners Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2020   grade_2 5.0 1.0 0.0   4.0 0.0     0.0   0.0   3.0 7.0     0.0   0.0     6.0   *   10.0 5 1 0   4 0     0   0   3 7     0 0   6     10
1829526 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000149 10 Banfield Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2020   grade_2 63.0 8.0 26.0   0.0 8.0     1.0   5.0   61.0 50.0     29.0   0.0         27.0   111.0 63 8 26   0 8     1   5   61 50     29 0     27   111
1829531 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000153 40 Neveln Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2020   grade_2 38.0 4.0 33.0   0.0 7.0     0.0   2.0   43.0 41.0     *   *     52.0   *   84.0 38 4 33   0 7     0   2   43 41           52     84
1829536 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345002230 70 Southgate Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2020   grade_2 74.0 7.0 23.0   0.0 18.0     4.0   3.0   66.0 63.0     29.0   2.0     66.0   23.0   129.0 74 7 23   0 18     4   3   66 63     29 2   66 23   129
1829542 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000156 80 Sumner Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2020   grade_2 9.0 12.0 23.0   0.0 20.0     6.0   1.0   48.0 23.0     41.0   *     56.0   15.0   71.0 9 12 23   0 20     6   1   48 23     41     56 15   71
1839119 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345003192 450 New Dominion Academy Educational Oversight to Private Residential Care & Treatment (State approved) Alternative School No Other KG 12 2020   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
1830651 MN Roseau 68 school 2703540 676 Independent Districts and Schools Badger Public School District 270354000162 10 Badger Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 11.0 0.0 0.0   0.0 0.0     0.0   2.0   8.0 5.0     0.0   0.0     3.0   1.0   13.0 11 0 0   0 0     0   2   8 5     0 0   3 1   13
1827651 MN Clearwater 15 school 2703570 162 Independent Districts and Schools Bagley Public School District 270357000164 10 Bagley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 43.0 0.0 0.0   15.0 0.0     0.0   4.0   31.0 31.0     0.0   1.0     33.0   8.0   62.0 43 0 0   15 0     0   4   31 31     0 1   33 8   62
1827602 MN Clay 14 school 2703660 146 Independent Districts and Schools Barnesville Public School District 270366000169 10 Barnesville Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2020   grade_2 66.0 0.0 0.0   1.0 0.0     0.0   3.0   39.0 31.0     0.0   0.0     15.0   7.0   70.0 66 0 0   1 0     0   3   39 31     0 0   15 7   70
1827387 MN Carlton 9 school 2703690 91 Independent Districts and Schools Barnum Public School District 270369000171 1 Barnum Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 44.0 0.0 2.0   0.0 0.0     0.0   6.0   32.0 20.0     0.0   0.0     14.0   12.0   52.0 44 0 2   0 0     0   6   32 20     0 0   14 12   52
1829786 MN Otter Tail 56 school 2703750 542 Independent Districts and Schools Battle Lake Public School District 270375000175 10 Battle Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2020   grade_2 22.0 0.0 1.0   0.0 1.0     0.0   1.0   17.0 8.0     1.0   0.0     10.0   6.0   25.0 22 0 1   0 1     0   1   17 8     1 0   10 6   25
1833847 MN Hennepin 27 school 2700396 4226 Charter Schools Bdote Learning Center 270039604763 10 Bdote Learning Center Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 0.0 0.0 1.0   13.0 0.0     0.0   0.0   8.0 6.0     4.0   5.0         3.0   14.0 0 0 1   13 0     0   0   8 6     4 5     3   14
1833378 MN Hennepin 27 school 2700366 4124 Charter Schools Beacon Academy 270036604110 10 Beacon Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 55.0 20.0 4.0   0.0 0.0     0.0   5.0   40.0 44.0     6.0   2.0     27.0   13.0   84.0 55 20 4   0 0     0   5   40 44     6 2   27 13   84
1830979 MN Sherburne 71 school 2703870 726 Independent Districts and Schools Becker Public School District 270387003092 40 Becker Primary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_2 201.0 2.0 4.0   0.0 1.0     0.0   5.0   94.0 119.0     5.0   1.0     40.0   26.0   213.0 201 2 4   0 1     0   5   94 119     5 1   40 26   213
1832207 MN Stearns 73 school 2700105 2364 Independent Districts and Schools Belgrade-Brooten-Elrosa Public School District 270010500182 1 Belgrade-Brooten-Elrosa Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 33.0 1.0 7.0   0.0 0.0     0.0   0.0   21.0 20.0     4.0   1.0     13.0   11.0   41.0 33 1 7   0 0     0   0   21 20     4 1   13 11   41
1830853 MN Scott 70 school 2704050 716 Independent Districts and Schools Belle Plaine Public School District 270405000183 10 Chatfield Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_2 109.0 0.0 10.0   3.0 2.0     1.0   4.0   57.0 72.0     3.0   0.0     32.0   16.0   129.0 109 0 10   3 2     1   4   57 72     3 0   32 16   129
1827159 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444000194 16 Northern Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2020   grade_2 82.0 0.0 0.0   8.0 1.0     0.0   4.0   54.0 41.0     0.0   0.0     31.0   18.0   95.0 82 0 0   8 1     0   4   54 41     0 0   31 18   95
1827167 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444000196 40 J.W. Smith Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2020   grade_2 12.0 2.0 3.0   26.0 0.0     0.0   7.0   25.0 25.0     2.0   5.0     42.0   7.0   50.0 12 2 3   26 0     0   7   25 25     2 5   42 7   50
1827173 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444000191 50 Central Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2020   grade_2 16.0 0.0 1.0   6.0 0.0     0.0   4.0   12.0 15.0     0.0   2.0     21.0   9.0   27.0 16 0 1   6 0     0   4   12 15     0 2   21 9   27
1827178 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444000192 60 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2020   grade_2 73.0 0.0 0.0   16.0 1.0     0.0   15.0   72.0 33.0     0.0   3.0     47.0   23.0   105.0 73 0 0   16 1     0   15   72 33     0 3   47 23   105
1827183 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444000197 80 Solway Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2020   grade_2 25.0 1.0 2.0   4.0 0.0     0.0   2.0   20.0 14.0     0.0   1.0     17.0   6.0   34.0 25 1 2   4 0     0   2   20 14     0 1   17 6   34
1827188 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444000193 100 Horace May Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2020   grade_2 75.0 2.0 2.0   5.0 1.0     0.0   5.0   51.0 39.0     0.0   2.0     35.0   17.0   90.0 75 2 2   5 1     0   5   51 39     0 2   35 17   90
1831285 MN Swift 76 school 2704470 777 Independent Districts and Schools Benson Public School District 270447000201 103 Northside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 48.0 2.0 10.0   0.0 1.0     0.0   6.0   31.0 36.0     8.0   0.0     33.0   10.0   67.0 48 2 10   0 1     0   6   31 36     8 0   33 10   67
1831295 MN Todd 77 school 2705430 786 Independent Districts and Schools Bertha-Hewitt Public School District 270543000203 10 Bertha Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 36.0 0.0 0.0   0.0 0.0     0.0   1.0   24.0 13.0     0.0   0.0     20.0   9.0   37.0 36 0 0   0 0     0   1   24 13     0 0   20 9   37
1833673 MN Hennepin 27 school 2700309 4192 Charter Schools Best Academy 270030904261 10 Best Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 0.0 91.0 1.0   0.0 0.0     0.0   1.0   48.0 45.0     33.0   6.0         6.0   93.0 0 91 1   0 0     0   1   48 45     33 6     6   93
1830988 MN Sherburne 71 school 2705460 727 Independent Districts and Schools Big Lake Public School District 270546004180 40 Liberty Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_2 180.0 11.0 10.0   1.0 3.0     0.0   8.0   100.0 113.0     7.0   3.0     58.0   34.0   213.0 180 11 10   1 3     0   8   100 113     7 3   58 34   213
1833468 MN Cook 16 school 2700255 4145 Charter Schools Birch Grove Community School 270025503313 10 Birch Grove Community School Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2020   grade_2 3.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 3 0 0   0 0     0   0   1 2                 3
1832259 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566000144 15 BOLD-Bird Island Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2020   grade_2 46.0 1.0 9.0   0.0 0.0     0.0   0.0   31.0 25.0     4.0   0.0     27.0   9.0   56.0 46 1 9   0 0     0   0   31 25     4 0   27 9   56
1827195 MN Beltrami 4 school 2705730 32 Independent Districts and Schools Blackduck Public School District 270573000212 10 Blackduck Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 36.0 0.0 2.0   6.0 0.0     0.0   3.0   24.0 23.0     2.0   0.0     25.0   12.0   47.0 36 0 2   6 0     0   3   24 23     2 0   25 12   47
1831208 MN Steele 74 school 2705760 756 Independent Districts and Schools Blooming Prairie Public School Dist 270576000214 10 Blooming Prairie Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 57.0 1.0 2.0   0.0 0.0     0.0   1.0   25.0 36.0     2.0   0.0         11.0   61.0 57 1 2   0 0     0   1   25 36     2 0     11   61
1828404 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000640 432 Washburn Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 14.0 17.0 21.0   0.0 6.0     0.0   5.0   24.0 39.0     24.0   6.0     42.0   13.0   63.0 14 17 21   0 6     0   5   24 39     24 6   42 13   63
1828411 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579002292 443 Hillcrest Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 40.0 11.0 4.0   2.0 2.0     0.0   17.0   38.0 38.0     *   0.0     23.0   7.0   76.0 40 11 4   2 2     0   17   38 38       0   23 7   76
1828420 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000218 446 Indian Mounds Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 13.0 14.0 16.0   1.0 5.0     0.0   4.0   22.0 31.0     20.0   2.0     31.0   7.0   53.0 13 14 16   1 5     0   4   22 31     20 2   31 7   53
1828427 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000227 447 Olson Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 47.0 15.0 12.0   0.0 5.0     1.0   11.0   48.0 43.0     17.0   0.0     28.0   12.0   91.0 47 15 12   0 5     1   11   48 43     17 0   28 12   91
1828436 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000223 448 Oak Grove Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 29.0 7.0 11.0   1.0 3.0     0.0   17.0   31.0 37.0     11.0   0.0     17.0   4.0   68.0 29 7 11   1 3     0   17   31 37     11 0   17 4   68
1828443 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000225 450 Normandale Hills Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 28.0 14.0 13.0   0.0 1.0     0.0   3.0   35.0 24.0     13.0   1.0     26.0   8.0   59.0 28 14 13   0 1     0   3   35 24     13 1   26 8   59
1828450 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000232 454 Poplar Bridge Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 57.0 7.0 10.0   0.0 4.0     0.0   8.0   46.0 40.0     12.0   1.0     21.0   12.0   86.0 57 7 10   0 4     0   8   46 40     12 1   21 12   86
1828457 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000234 455 Ridgeview Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 52.0 6.0 6.0   0.0 3.0     0.0   6.0   41.0 32.0     *   1.0     11.0   8.0   73.0 52 6 6   0 3     0   6   41 32       1   11 8   73
1828466 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000238 459 Valley View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 8.0 14.0 36.0   2.0 4.0     0.0   5.0   32.0 37.0     30.0   5.0     58.0   8.0   69.0 8 14 36   2 4     0   5   32 37     30 5   58 8   69
1828473 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000240 461 Westwood Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 35.0 9.0 8.0   1.0 2.0     0.0   5.0   35.0 25.0     11.0   0.0     18.0   9.0   60.0 35 9 8   1 2     0   5   35 25     11 0   18 9   60
1832440 MN Faribault 22 school 2700130 2860 Independent Districts and Schools Blue Earth Area Public School 270013000241 10 Blue Earth Area Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 58.0 2.0 10.0   1.0 0.0     0.0   2.0   36.0 37.0     3.0   0.0     39.0   12.0   73.0 58 2 10   1 0     0   2   36 37     3 0   39 12   73
1832974 MN Winona 85 school 2705850 4001 Charter Schools Bluffview Montessori 270585000018 10 Bluffview Montessori Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 23.0 0.0 0.0   0.0 0.0     0.0   2.0   10.0 15.0     0.0   0.0     3.0   1.0   25.0 23 0 0   0 0     0   2   10 15     0 0   3 1   25
1829072 MN Isanti 30 school 2706060 314 Independent Districts and Schools Braham Public School District 270606000245 2 Braham Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 51.0 0.0 4.0   0.0 1.0     1.0   2.0   34.0 25.0     0.0   1.0     24.0   10.0   59.0 51 0 4   0 1     1   2   34 25     0 1   24 10   59
1827682 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609000248 4 Baxter Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2020   grade_2 97.0 0.0 1.0   1.0 1.0     0.0   7.0   50.0 57.0     2.0   0.0     33.0   18.0   107.0 97 0 1   1 1     0   7   50 57     2 0   33 18   107
1827688 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609000252 8 Garfield Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2020   grade_2 59.0 1.0 2.0   1.0 0.0     0.0   3.0   33.0 33.0     0.0   *     42.0   16.0   66.0 59 1 2   1 0     0   3   33 33     0     42 16   66

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