Data source: Big Local News · About: Big Local

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

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
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
1826792 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2020   grade_2 18.0 0.0 0.0   1.0 0.0     0.0   1.0   10.0 10.0     0.0   0.0     9.0   4.0   20.0 18 0 0   1 0     0   1   10 10     0 0   9 4   20
1826800 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 10.0 0.0 1.0   12.0 0.0     0.0   0.0   13.0 10.0     0.0   0.0     14.0   7.0   23.0 10 0 1   12 0     0   0   13 10     0 0   14 7   23
1839245 MN Aitkin 1 school 2700300 4177 Charter Schools Minisinaakwaang Leadership Academy 270030003730 10 Minisinaakwaang Leadership Academy Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   grade_2 0.0 0.0 0.0   3.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 0 0 0   3 0     0   0   1 2                 3
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
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
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
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
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
1826993 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810000332 510 Centennial Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 63.0 4.0 3.0   1.0 3.0     0.0   4.0   41.0 37.0     2.0   1.0     13.0   8.0   78.0 63 4 3   1 3     0   4   41 37     2 1   13 8   78
1827000 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810000335 511 Centerville Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 85.0 1.0 3.0   0.0 1.0     0.0   7.0   48.0 49.0     3.0   0.0     6.0   10.0   97.0 85 1 3   0 1     0   7   48 49     3 0   6 10   97
1827007 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810000336 512 Golden Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 54.0 3.0 10.0   0.0 3.0     1.0   5.0   33.0 43.0     7.0   0.0     19.0   9.0   76.0 54 3 10   0 3     1   5   33 43     7 0   19 9   76
1827014 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810000022 513 Rice Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 101.0 2.0 2.0   0.0 2.0     0.0   4.0   58.0 53.0     3.0   0.0     12.0   12.0   111.0 101 2 2   0 2     0   4   58 53     3 0   12 12   111
1827021 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810003172 515 Blue Heron Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 99.0 5.0 12.0   0.0 11.0     0.0   5.0   72.0 60.0     15.0   2.0     25.0   18.0   132.0 99 5 12   0 11     0   5   72 60     15 2   25 18   132
1827030 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School Dist 270951000398 515 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 26.0 25.0 21.0   0.0 0.0     0.0   4.0   43.0 33.0     *   2.0     60.0   12.0   76.0 26 25 21   0 0     0   4   43 33       2   60 12   76
1827039 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School Dist 270951000400 517 North Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 21.0 22.0 17.0   0.0 4.0     0.0   8.0   46.0 26.0     *   5.0     53.0   11.0   72.0 21 22 17   0 4     0   8   46 26       5   53 11   72
1827048 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School Dist 270951000402 520 Valley View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 6.0 19.0 28.0   0.0 0.0     0.0   6.0   39.0 20.0     33.0   0.0     44.0   7.0   59.0 6 19 28   0 0     0   6   39 20     33 0   44 7   59
1827058 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000612 546 Hayes Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2020   grade_2 23.0 36.0 9.0   3.0 6.0     0.0   10.0   40.0 47.0     19.0   0.0     56.0   11.0   87.0 23 36 9   3 6     0   10   40 47     19 0   56 11   87
1827064 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000614 550 Stevenson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2020   grade_2 33.0 34.0 15.0   1.0 8.0     0.0   6.0   54.0 43.0     18.0   1.0     65.0   12.0   97.0 33 34 15   1 8     0   6   54 43     18 1   65 12   97
1827070 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000230 782 St. Francis Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 87.0 1.0 4.0   0.0 1.0     0.0   9.0   57.0 45.0     1.0   1.0     32.0   8.0   102.0 87 1 4   0 1     0   9   57 45     1 1   32 8   102
1827077 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000233 784 Cedar Creek Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 95.0 1.0 6.0   0.0 6.0     0.0   11.0   59.0 60.0     6.0   0.0     27.0   17.0   119.0 95 1 6   0 6     0   11   59 60     6 0   27 17   119
1827084 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000258 848 East Bethel Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 78.0 2.0 1.0   1.0 7.0     0.0   6.0   48.0 47.0     5.0   0.0     31.0   16.0   95.0 78 2 1   1 7     0   6   48 47     5 0   31 16   95
1827091 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333001461 772 Northpoint Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2020   grade_2 86.0 10.0 3.0   1.0 4.0     1.0   7.0   65.0 47.0     *   0.0         16.0   112.0 86 10 3   1 4     1   7   65 47       0     16   112
1827097 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333001467 774 Woodcrest Elementary Spanish Immersion Elementary School (Grades PK-6) Regular School No Elementary KG 04 2020   grade_2 37.0 4.0 51.0   0.0 1.0     0.0   7.0   48.0 52.0     30.0   *     34.0   *   100.0 37 4 51   0 1     0   7   48 52     30     34     100
1827104 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333001462 775 Park Terrace Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2020   grade_2 41.0 12.0 24.0   1.0 14.0     0.0   11.0   56.0 47.0     30.0   2.0     66.0   18.0   103.0 41 12 24   1 14     0   11   56 47     30 2   66 18   103
1827110 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333005028 776 Centerview Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2020   grade_2 56.0 15.0 5.0   0.0 11.0     0.0   11.0   54.0 44.0     20.0   2.0     40.0   11.0   98.0 56 15 5   0 11     0   11   54 44     20 2   40 11   98
1827114 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333004657 787 Elementary Lighthouse Elementary School (Grades PK-6) Regular School No Elementary 01 06 2020   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
1831398 MN Anoka 2 school 2712270 831 Independent Districts and Schools Forest Lake Public School District 271227000597 628 Lino Lakes Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 43.0 8.0 5.0   0.0 3.0     0.0   3.0   27.0 35.0     4.0   0.0     11.0   9.0   62.0 43 8 5   0 3     0   3   27 35     4 0   11 9   62
1833003 MN Anoka 2 school 2700093 4008 Charter Schools PACT Charter School 270009302488 10 PACT Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2020   grade_2 40.0 2.0 1.0   0.0 0.0     0.0   1.0   24.0 20.0     4.0   0.0     11.0   7.0   44.0 40 2 1   0 0     0   1   24 20     4 0   11 7   44
1833618 MN Anoka 2 school 2700320 4185 Charter Schools DaVinci Academy 270032004268 10 DaVinci Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 71.0 16.0 3.0   0.0 9.0     0.0   4.0   61.0 42.0     6.0   0.0     15.0   9.0   103.0 71 16 3   0 9     0   4   61 42     6 0   15 9   103
1833826 MN Anoka 2 school 2700390 4224 Charter Schools Star of the North Academy Charter School 270039004759 10 Star of the North Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 4.0 9.0 0.0   0.0 3.0     0.0   0.0   6.0 10.0     5.0   0.0     12.0   *   16.0 4 9 0   0 3     0   0   6 10     5 0   12     16
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
1837530 MN Anoka 2 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404643 40 Karner Blue Education Center Special Education Special Education School No Elementary KG 08 2020   grade_2 6.0 4.0 0.0   0.0 0.0     0.0   1.0   11.0 0.0     1.0   0.0     6.0   *   11.0 6 4 0   0 0     0   1   11 0     1 0   6     11
1827122 MN Becker 3 school 2710230 22 Independent Districts and Schools Detroit Lakes Public School Dist. 271023000445 10 Rossman Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 90.0 1.0 2.0   4.0 0.0     0.0   11.0   57.0 51.0     *   3.0         *   108.0 90 1 2   4 0     0   11   57 51       3         108
1827131 MN Becker 3 school 2710230 22 Independent Districts and Schools Detroit Lakes Public School Dist. 271023002268 60 Roosevelt Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2020   grade_2 74.0 2.0 4.0   27.0 0.0     0.0   2.0   50.0 59.0     *   1.0         *   109.0 74 2 4   27 0     0   2   50 59       1         109
1827138 MN Becker 3 school 2712360 23 Independent Districts and Schools Frazee-Vergas Public School Dist. 271236000607 10 Frazee Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 50.0 1.0 3.0   4.0 0.0     0.0   7.0   34.0 31.0     0.0   1.0     29.0   12.0   65.0 50 1 3   4 0     0   7   34 31     0 1   29 12   65
1827146 MN Becker 3 school 2728960 25 Independent Districts and Schools Pine Point Public School District 272896000034 70 Pine Point Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2020   grade_2 0.0 0.0 0.0   12.0 0.0     0.0   0.0   4.0 8.0     0.0   0.0         5.0   12.0 0 0 0   12 0     0   0   4 8     0 0     5   12
1829380 MN Becker 3 school 2742120 435 Independent Districts and Schools Waubun-Ogema-White Earth Public Sch 274212001754 20 Ogema Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2020   grade_2 8.0 0.0 0.0   37.0 0.0     0.0   17.0   31.0 31.0     0.0   *     46.0   4.0   62.0 8 0 0   37 0     0   17   31 31     0     46 4   62
1832474 MN Becker 3 school 2700162 2889 Independent Districts and Schools Lake Park Audubon School District 270016200142 10 Lake Park Audubon Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 43.0 0.0 2.0   1.0 0.0     0.0   4.0   24.0 26.0     0.0   6.0     21.0   10.0   50.0 43 0 2   1 0     0   4   24 26     0 6   21 10   50
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
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
1827205 MN Beltrami 4 school 2717010 36 Independent Districts and Schools Kelliher Public School District 271701000786 10 Kelliher Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 8.0 0.0 0.0   10.0 0.0     0.0   0.0   13.0 5.0     0.0   0.0     14.0   2.0   18.0 8 0 0   10 0     0   0   13 5     0 0   14 2   18
1827212 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051001302 10 Red Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2020   grade_2 0.0 0.0 0.0   127.0 0.0     0.0   0.0   72.0 55.0     0.0   15.0     104.0   34.0   127.0 0 0 0   127 0     0   0   72 55     0 15   104 34   127
1827224 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051001301 20 Ponemah Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2020   grade_2 0.0 0.0 0.0   15.0 0.0     0.0   0.0   6.0 9.0     0.0   4.0     11.0   4.0   15.0 0 0 0   15 0     0   0   6 9     0 4   11 4   15
1833163 MN Beltrami 4 school 2700225 4058 Charter Schools Schoolcraft Learning Community Chtr 270022503464 10 Schoolcraft Learning Community Chtr Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 17.0 0.0 0.0   2.0 0.0     0.0   2.0   10.0 11.0     0.0   0.0     7.0   3.0   21.0 17 0 0   2 0     0   2   10 11     0 0   7 3   21
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
1827234 MN Benton 5 school 2732880 47 Independent Districts and Schools Sauk Rapids-Rice Public Schools 273288001430 3 Mississippi Heights Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 145.0 8.0 10.0   2.0 1.0     0.0   9.0   93.0 82.0     0.0   4.0     55.0   34.0   175.0 145 8 10   2 1     0   9   93 82     0 4   55 34   175
1827242 MN Benton 5 school 2732880 47 Independent Districts and Schools Sauk Rapids-Rice Public Schools 273288001433 6 Rice Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 53.0 1.0 2.0   0.0 0.0     0.0   1.0   34.0 23.0     1.0   1.0     17.0   13.0   57.0 53 1 2   0 0     0   1   34 23     1 1   17 13   57
1827249 MN Benton 5 school 2732880 47 Independent Districts and Schools Sauk Rapids-Rice Public Schools 273288001431 7 Pleasant View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 88.0 3.0 5.0   1.0 2.0     0.0   11.0   57.0 53.0     1.0   2.0     50.0   22.0   110.0 88 3 5   1 2     0   11   57 53     1 2   50 22   110
1827257 MN Benton 5 school 2712240 51 Independent Districts and Schools Foley Public School District 271224000590 10 Foley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2020   grade_2 142.0 1.0 2.0   2.0 0.0     0.0   0.0   75.0 72.0     0.0   0.0     43.0   17.0   147.0 142 1 2   2 0     0   0   75 72     0 0   43 17   147
1832466 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools Clinton-Graceville-Beardsley 270015000378 1 Clinton-Graceville-Beardsley El. Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 16.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 9.0     *   *         *   16.0 16 0 0   0 0     0   0   7 9                 16
1832538 MN Big Stone 6 school 2700328 2903 Independent Districts and Schools Ortonville Public Schools 270032804394 10 Knoll 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   27.0 10.0     0.0   0.0     14.0   8.0   37.0 36 0 0   0 0     0   1   27 10     0 0   14 8   37
1839202 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools Clinton-Graceville-Beardsley 270015003019 6 Lismore Colony School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School No Other KG 10 2020   grade_2 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 3 0 0   0 0     0   0   2 1                 3
1827269 MN Blue Earth 7 school 2733480 75 Independent Districts and Schools St. Clair Public School District 273348001477 10 St. Clair Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 46.0 0.0 0.0   0.0 0.0     0.0   0.0   25.0 21.0     0.0   0.0     9.0   6.0   46.0 46 0 0   0 0     0   0   25 21     0 0   9 6   46
1827279 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878000877 10 Kennedy Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 44.0 12.0 6.0   0.0 0.0     0.0   6.0   33.0 35.0     9.0   0.0     28.0   13.0   68.0 44 12 6   0 0     0   6   33 35     9 0   28 13   68
1827293 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878000876 30 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 26.0 4.0 3.0   0.0 0.0     0.0   5.0   13.0 25.0     3.0   *     13.0   6.0   38.0 26 4 3   0 0     0   5   13 25     3     13 6   38
1827307 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878000883 50 Roosevelt Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 53.0 8.0 2.0   0.0 0.0     0.0   2.0   30.0 35.0     7.0   1.0     20.0   8.0   65.0 53 8 2   0 0     0   2   30 35     7 1   20 8   65
1827321 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878004388 70 Rosa Parks Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 51.0 14.0 3.0   0.0 2.0     0.0   7.0   46.0 31.0     10.0   0.0     35.0   10.0   77.0 51 14 3   0 2     0   7   46 31     10 0   35 10   77
1827328 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878000884 80 Washington Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 51.0 16.0 5.0   0.0 2.0     0.0   3.0   38.0 39.0     11.0   1.0     32.0   15.0   77.0 51 16 5   0 2     0   3   38 39     11 1   32 15   77
1827336 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878000873 90 Franklin Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 36.0 12.0 11.0   0.0 0.0     0.0   6.0   33.0 32.0     11.0   0.0     33.0   14.0   65.0 36 12 11   0 0     0   6   33 32     11 0   33 14   65
1827343 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878000872 150 Eagle Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 54.0 1.0 3.0   0.0 2.0     0.0   4.0   37.0 27.0     0.0   0.0     11.0   10.0   64.0 54 1 3   0 2     0   4   37 27     0 0   11 10   64
1831858 MN Blue Earth 7 school 2791445 2071 Independent Districts and Schools Lake Crystal-Wellcome Memorial 279144502308 10 Lake Crystal-Wellcome Memorial Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 62.0 1.0 3.0   0.0 0.0     0.0   1.0   40.0 27.0     0.0   0.0     15.0   17.0   67.0 62 1 3   0 0     0   1   40 27     0 0   15 17   67
1831891 MN Blue Earth 7 school 2700006 2135 Independent Districts and Schools Maple River School District 270000600092 35 Maple River West Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 36.0 0.0 1.0   0.0 0.0     0.0   2.0   13.0 26.0     0.0   0.0     12.0   5.0   39.0 36 0 1   0 0     0   2   13 26     0 0   12 5   39
1836972 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878004374 370 Futures Program Special Education Special Education 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
1838841 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878005116 375 Prairie Care Mankato Educational Oversight to Public Care and Treatment Day Program Alternative School No Other 02 12 2020   grade_2 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 1 0   0 0     0   0   0 1                 1
1827351 MN Brown 8 school 2709540 81 Independent Districts and Schools Comfrey Public School District 270954000403 10 Comfrey Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 6.0 0.0 1.0   0.0 0.0     0.0   0.0   3.0 4.0     *   *         *   7.0 6 0 1   0 0     0   0   3 4                 7
1827361 MN Brown 8 school 2733210 84 Independent Districts and Schools Sleepy Eye Public School District 273321001450 10 Sleepy Eye Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 27.0 1.0 20.0   0.0 0.0     0.0   1.0   22.0 27.0     6.0   2.0     27.0   8.0   49.0 27 1 20   0 0     0   1   22 27     6 2   27 8   49
1827370 MN Brown 8 school 2733390 85 Independent Districts and Schools Springfield Public School District 273339001470 2 Springfield Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 38.0 0.0 5.0   0.0 0.0     0.0   0.0   23.0 20.0     0.0   0.0     18.0   5.0   43.0 38 0 5   0 0     0   0   23 20     0 0   18 5   43
1827377 MN Brown 8 school 2723490 88 Independent Districts and Schools New Ulm Public School District 272349001150 20 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2020   grade_2 142.0 2.0 5.0   0.0 1.0     0.0   4.0   79.0 75.0     3.0   0.0     52.0   28.0   154.0 142 2 5   0 1     0   4   79 75     3 0   52 28   154
1838092 MN Brown 8 school 2791353 6049 Education Districts River Bend Education District 279135304366 35 Imprints Program Special Education Special Education School No Other KG 12 2020   grade_2 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *         *   3.0 3 0 0   0 0     0   0   3 0                 3
1838110 MN Brown 8 school 2791353 6049 Education Districts River Bend Education District 279135305074 50 R.I.S.E. Program Special Education Special Education 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
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
1827396 MN Carlton 9 school 2707590 93 Independent Districts and Schools Carlton Public School District 270759000328 2 South Terrace Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 24.0 0.0 0.0   2.0 0.0     0.0   2.0   15.0 13.0     0.0   0.0     10.0   5.0   28.0 24 0 0   2 0     0   2   15 13     0 0   10 5   28
1827403 MN Carlton 9 school 2709420 94 Independent Districts and Schools Cloquet Public School District 270942000380 101 Churchill Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 56.0 0.0 0.0   4.0 0.0     0.0   7.0   28.0 39.0     0.0   0.0     23.0   12.0   67.0 56 0 0   4 0     0   7   28 39     0 0   23 12   67
1827409 MN Carlton 9 school 2709420 94 Independent Districts and Schools Cloquet Public School District 270942000384 105 Washington Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 72.0 1.0 2.0   9.0 0.0     0.0   23.0   54.0 53.0     0.0   1.0     52.0   26.0   107.0 72 1 2   9 0     0   23   54 53     0 1   52 26   107
1827416 MN Carlton 9 school 2709690 95 Independent Districts and Schools Cromwell-Wright Public Schools 270969000410 10 Cromwell-Wright Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 13.0 0.0 1.0   1.0 0.0     0.0   0.0   10.0 5.0     0.0   0.0     9.0   5.0   15.0 13 0 1   1 0     0   0   10 5     0 0   9 5   15
1827425 MN Carlton 9 school 2721450 97 Independent Districts and Schools Moose Lake Public School District 272145001093 20 Moose Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 51.0 0.0 0.0   0.0 0.0     0.0   3.0   25.0 29.0     0.0   2.0     21.0   5.0   54.0 51 0 0   0 0     0   3   25 29     0 2   21 5   54
1827434 MN Carlton 9 school 2738880 99 Independent Districts and Schools Esko Public School District 273888001683 30 Winterquist Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 85.0 0.0 1.0   0.0 0.0     0.0   4.0   52.0 38.0     0.0   0.0     7.0   10.0   90.0 85 0 1   0 0     0   4   52 38     0 0   7 10   90
1827443 MN Carlton 9 school 2744190 100 Independent Districts and Schools Wrenshall Public School District 274419001842 1 Wrenshall Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 28.0 0.0 0.0   0.0 0.0     0.0   1.0   17.0 12.0     0.0   0.0     11.0   4.0   29.0 28 0 0   0 0     0   1   17 12     0 0   11 4   29

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