Data source: Big Local News · About: Big Local

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

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
855280 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 1 PK 08 2016   grade_2 0 0 0   6 0     0   0   3 3         *         *   6 0 0 0   6 0     0   0   3 3                 6
855355 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 1 01 05 2016   grade_2 0 0 0   132 0     0   0   68 64     0.0   26.0         *   132 0 0 0   132 0     0   0   68 64     0 26         132
855366 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 1 PK 08 2016   grade_2 0 0 0   27 0     0   0   17 10     0.0   4.0         *   27 0 0 0   27 0     0   0   17 10     0 4         27
856808 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001224 681 ZANEWOOD COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No 1 PK 05 2016   grade_2 0 40 20   0 15     0   1   35 41     35.0   1.0         7.0   76 0 40 20   0 15     0   1   35 41     35 1     7   76
858673 MN Saint Louis 69 school 2733720 707 Independent Districts and Schools NETT LAKE PUBLIC SCHOOL DISTRICT 273372001508 1 NETT LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 06 2016   grade_2 0 0 0   10 0     0   0   4 6     0.0   0.0     6.0   6.0   10 0 0 0   10 0     0   0   4 6     0 0   6 6   10
860767 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124002297 193 SULLIVAN ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_2 0 67 3   5 1     0   1   35 42     58.0   9.0         10.0   77 0 67 3   5 1     0   1   35 42     58 9     10   77
860787 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124004172 225 ANISHINABE ACADEMY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_2 0 1 6   28 0     0   3   19 19     0.0   10.0         3.0   38 0 1 6   28 0     0   3   19 19     0 10     3   38
860907 MN Hennepin 27 school 2700027 4004 Charter Schools CEDAR RIVERSIDE COMMUNITY SCHOOL 270002702340 10 CEDAR RIVERSIDE COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_2 0 20 0   0 0     0   0   11 9     15.0   0.0         0.0   20 0 20 0   0 0     0   0   11 9     15 0     0   20
860969 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703566 17 Banaadir Academy Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_2 0 31 0   0 0     0   0   16 15         1.0         1.0   31 0 31 0   0 0     0   0   16 15       1     1   31
861006 MN Ramsey 62 school 2700140 4027 Charter Schools HIGHER GROUND ACADEMY 270014002719 10 HIGHER GROUND ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_2 0 73 0   0 0     0   0   36 37     2.0   0.0         0.0   73 0 73 0   0 0     0   0   36 37     2 0     0   73
861016 MN Ramsey 62 school 2700142 4029 Charter Schools ST. PAUL CITY SCHOOL 270014202721 10 ST. PAUL CITY PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 05 2016   grade_2 0 9 28   1 7     0   0   25 20     34.0   2.0         4.0   45 0 9 28   1 7     0   0   25 20     34 2     4   45
861047 MN Hennepin 27 school 2700159 4038 Charter Schools SOJOURNER TRUTH ACADEMY 270015902954 10 SOJOURNER TRUTH ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2016   grade_2 0 32 13   1 0     0   1   26 21     11.0   4.0         3.0   47 0 32 13   1 0     0   1   26 21     11 4     3   47
861123 MN Hennepin 27 school 2700184 4068 Charter Schools EXCELL ACADEMY CHARTER 270018403137 10 EXCELL ACADEMY CHARTER Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2016   grade_2 0 56 1   0 0     0   0   30 27     15.0   1.0         6.0   57 0 56 1   0 0     0   0   30 27     15 1     6   57
861133 MN Ramsey 62 school 2700230 4070 Charter Schools HOPE COMMUNITY ACADEMY 270023003482 10 HOPE COMMUNITY ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_2 0 1 1   0 56     0   0   30 28     40.0   0.0     42.0   3.0   58 0 1 1   0 56     0   0   30 28     40 0   42 3   58
861151 MN Hennepin 27 school 2700188 4077 Charter Schools Twin Cities International Elementary School 270018803141 10 Twin Cities International Elementary School Elementary School (Grades PK-6) Regular School Yes 1 KG 04 2016   grade_2 0 124 0   0 0     0   0   57 67     78.0   0.0         4.0   124 0 124 0   0 0     0   0   57 67     78 0     4   124
861157 MN Hennepin 27 school 2700190 4079 Charter Schools FRIENDSHIP ACDMY OF FINE ARTS CHTR. 270019003143 10 FRIENDSHIP ACDMY OF FINE ARTS CHTR. Elementary School (Grades PK-6) Regular School Yes 1 KG 06 2016   grade_2 0 19 0   0 0     0   0   9 10     0.0   0.0         3.0   19 0 19 0   0 0     0   0   9 10     0 0     3   19
861206 MN Hennepin 27 school 2700237 4097 Charter Schools PARTNERSHIP ACADEMY, INC. 270023703278 10 PARTNERSHIP ACADEMY, INC. Elementary School (Grades PK-6) Regular School Yes 1 KG 05 2016   grade_2 0 2 42   0 0     0   1   27 18         2.0         4.0   45 0 2 42   0 0     0   1   27 18       2     4   45
861230 MN Ramsey 62 school 2700342 4103 Charter Schools HMONG COLLEGE PREP ACADEMY 270034203700 20 HMONG COLLEGE PREP MIDDLE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_2 0 0 0   0 112     0   0   60 52     56.0   1.0     89.0   12.0   112 0 0 0   0 112     0   0   60 52     56 1   89 12   112
861290 MN Hennepin 27 school 2700240 4126 Charter Schools PRAIRIE SEEDS ACADEMY 270024003340 10 Prairie Seeds Elementary School Academy Elementary School (Grades PK-6) Regular School Yes 1 KG 05 2016   grade_2 0 9 9   0 48     0   1   37 30     30.0   2.0     53.0   3.0   67 0 9 9   0 48     0   1   37 30     30 2   53 3   67
861305 MN Olmsted 55 school 2700247 4135 Charter Schools ROCHESTER MATH AND SCIENCE ACADEMY 270024703308 10 ROCHESTER MATH AND SCIENCE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_2 0 33 0   0 0     0   0   20 13         0.0         1.0   33 0 33 0   0 0     0   0   20 13       0     1   33
861329 MN Hennepin 27 school 2700273 4139 Charter Schools LOVEWORKS ACADEMY FOR ARTS 270027303575 10 LOVEWORKS ACADEMY FOR ARTS Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_2 0 22 0   0 0     0   0   12 10     0.0   1.0         2.0   22 0 22 0   0 0     0   0   12 10     0 1     2   22
861369 MN Hennepin 27 school 2700253 4143 Charter Schools NEW MILLENNIUM ACADEMY CHARTER SCH 270025303311 10 New Millenium Academy Charter School Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_2 0 0 0   1 78     0   0   48 31     69.0   0.0     70.0   4.0   79 0 0 0   1 78     0   0   48 31     69 0   70 4   79
861404 MN Ramsey 62 school 2700263 4153 Charter Schools DUGSI ACADEMY 270026303320 10 DUGSI ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_2 0 42 0   0 0     0   0   18 24         0.0         4.0   42 0 42 0   0 0     0   0   18 24       0     4   42
861414 MN Mahnomen 44 school 2700275 4155 Charter Schools NAYTAHWAUSH COMMUNITY SCHOOL 270027503580 10 NAYTAHWAUSH COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 06 2016   grade_2 0 0 0   14 0     0   0   8 6     0.0   0.0     12.0   *   14 0 0 0   14 0     0   0   8 6     0 0   12     14
861481 MN Hennepin 27 school 2700295 4171 Charter Schools NOBLE ACADEMY 270029503727 10 NOBLE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_2 0 10 0   0 67     0   0   39 38     57.0   0.0     59.0   3.0   77 0 10 0   0 67     0   0   39 38     57 0   59 3   77
861499 MN Ramsey 62 school 2700304 4181 Charter Schools COMMUNITY SCHOOL OF EXCELLENCE 270030403728 10 COMMUNITY SCHOOL OF EXCELLENCE Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_2 0 0 2   0 109     0   0   47 64     89.0   0.0     94.0   3.0   111 0 0 2   0 109     0   0   47 64     89 0   94 3   111
861564 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904261 10 Best Academy East at Olson Elementary School (Grades PK-6) Regular School Yes 1 KG 06 2016   grade_2 0 52 0   0 0     0   0   24 28         0.0         4.0   52 0 52 0   0 0     0   0   24 28       0     4   52
861590 MN Cook 16 school 2700321 4195 Charter Schools OSHKI OGIMAAG CHARTER SCHOOL 270032104293 10 OSHKI OGIMAAG CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 06 2016   grade_2 0 0 0   3 0     0   1   2 2         *         *   4 0 0 0   3 0     0   1   2 2                 4
861619 MN Hennepin 27 school 2700335 4205 Charter Schools HENNEPIN ELEMENTARY SCHOOL 270033504554 10 HENNEPIN ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 06 2016   grade_2 0 53 13   0 0     0   0   37 29     57.0   0.0         7.0   66 0 53 13   0 0     0   0   37 29     57 0     7   66
861636 MN Hennepin 27 school 2700373 4209 Charter Schools MASTERY SCHOOL 270037304602 10 MASTERY SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 04 2016   grade_2 0 46 0   0 0     0   1   19 28     0.0   1.0     31.0   3.0   47 0 46 0   0 0     0   1   19 28     0 1   31 3   47
861649 MN Unknown   school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_2 0 44 14   0 1     0   6   32 33     19.0   3.0         4.0   65 0 44 14   0 1     0   6   32 33     19 3     4   65
861671 MN Hennepin 27 school 2700381 4216 Charter Schools Freedom Academy Charter School 270038104644 10 Freedom Academy Charter School Elementary School (Grades PK-6) Regular School Yes 1 KG 03 2016   grade_2 0 8 1   0 0     0   1   4 6     0.0   0.0         1.0   10 0 8 1   0 0     0   1   4 6     0 0     1   10
861703 MN Ramsey 62 school 2700393 4225 Charter Schools Universal Academy Charter School 270039304758 10 Universal Academy Charter School Elementary School (Grades PK-6) Regular School Yes 1 KG 06 2016   grade_2 0 51 0   0 0     0   0   30 21         0.0         5.0   51 0 51 0   0 0     0   0   30 21       0     5   51
861711 MN Hennepin 27 school 2700396 4226 Charter Schools Bdote Learning Center 270039604763 10 Bdote Learning Center Elementary School (Grades PK-6) Regular School Yes 1 KG 04 2016   grade_2 0 0 1   5 0     0   2   4 4         *         *   8 0 0 1   5 0     0   2   4 4                 8
862789 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904773 20 Best Academy K-8 at Penn Middle School (Grades 5-8) Regular School Yes 1 KG 08 2016   grade_2 0 18 0   0 0     0   0   18 0         0.0         3.0   18 0 18 0   0 0     0   0   18 0       0     3   18
864706 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 4 KG 12 2016   grade_2 0 0 0   0 0     0   1   1 0         *         *   1 0 0 0   0 0     0   1   1 0                 1
864744 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002517 100 DAKOTA RIDGE SCHOOL Special Education Special Education School No 4 KG 12 2016   grade_2 0 1 0   0 0     0   0   0 1         *         *   1 0 1 0   0 0     0   0   0 1                 1
864785 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579004809 503 SUN Center Special Education Special Education School No 1 KG 08 2016   grade_2 0 2 0   0 0     0   1   3 0         *         *   3 0 2 0   0 0     0   1   3 0                 3
864853 MN Itasca 31 school 2710140 317 Independent Districts and Schools DEER RIVER PUBLIC SCHOOL DISTRICT 271014004672 6 Deer River Schools SPED Special Education Special Education School No 1 KG 05 2016   grade_2 0 0 0   0 0     0   1   1 0         *         *   1 0 0 0   0 0     0   1   1 0                 1
864923 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295002998 39 MOUNDS VIEW BRIDGES PROGRAM Special Education Special Education School No 1 KG 07 2016   grade_2 0 0 1   0 0     0   0   1 0         *         *   1 0 0 1   0 0     0   0   1 0                 1
864949 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385003374 41 Harmony Learning Center Special Education Special Education School No 4 KG 12 2016   grade_2 0 2 0   0 0     0   2   2 2         *         *   4 0 2 0   0 0     0   2   2 2                 4
864965 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243002668 732 FAIRVIEW PROGRAM Special Education Special Education School No 4 PK 12 2016   grade_2 0 0 1   0 0     0   0   1 0         *         *   1 0 0 1   0 0     0   0   1 0                 1
864990 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004275 607 RIVEREAST PROGRAM Special Education Special Education School No 1 KG 08 2016   grade_2 0 0 0   0 0     0   1   0 1         *         *   1 0 0 0   0 0     0   1   0 1                 1
865111 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805004822 155 Elementary Actions Special Education Special Education School No 1 KG 07 2016   grade_2 0 1 0   0 0     0   0   1 0         *         *   1 0 1 0   0 0     0   0   1 0                 1
865178 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124003022 625 RIVER BEND EDUCATIONAL CENTER Special Education Special Education School No 4 KG 12 2016   grade_2 0 2 0   1 0     0   0   3 0         *         *   3 0 2 0   1 0     0   0   3 0                 3
865283 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503229 480 STRIVE SECONDARY Special Education Special Education School No 4 01 12 2016   grade_2 0 1 0   0 0     0   0   1 0         *         *   1 0 1 0   0 0     0   0   1 0                 1
865296 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503234 486 CIP Special Education Special Education School No 4 01 12 2016   grade_2 0 0 1   1 0     0   0   2 0         *         *   2 0 0 1   1 0     0   0   2 0                 2
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
865458 MN Martin 46 school 2700046 915 Special Education Cooperatives SOUTHERN PLAINS EDUCATION COOP. 270004604627 45 SOUTHERN PLAINS BRIDGES Special Education Special Education School No 4 KG 12 2016   grade_2 0 1 0   0 0     0   0   1 0         *         *   1 0 1 0   0 0     0   0   1 0                 1
865558 MN Wright 86 school 2700413 6090 Special Education Cooperatives Sherburne and Northern Wright Special Education Cooperative 270041304947 80 Becker Intermediate School - SNW Special Education Special Education School No 1 KG 06 2016   grade_2 0 0 0   0 0     0   1   1 0         *         *   1 0 0 0   0 0     0   1   1 0                 1
865584 MN Meeker 47 school 2700086 991 Service Cooperative (ECSU Region) REGION 6 AND 8-SW/WC SRV COOPERATIVE 270008604236 25 COSMOS LEARNING CENTER-TRANSITIONS Special Education Special Education School No 4 KG 12 2016   grade_2 0 0 0   0 0     0   1   1 0         *         *   1 0 0 0   0 0     0   1   1 0                 1
865703 MN Nicollet 52 school 2700063 6027 Education Districts MN VALLEY EDUCATION DISTRICT 270006302389 10 Minnesota Valley School Special Education Special Education School No 4 KG 12 2016   grade_2 0 0 0   0 0     0   1   1 0         *         *   1 0 0 0   0 0     0   1   1 0                 1
865931 MN Pope 61 school 2700019 2149 Independent Districts and Schools MINNEWASKA SCHOOL DISTRICT 270001903600 101 MINNEWASKA DAY TREATMENT PROGRAM Educational Oversight to Public Care and Treatment Day Program Alternative Education School No 4 KG 12 2016   grade_2 0 0 0   1 0     0   0   0 1         *         *   1 0 0 0   1 0     0   0   0 1                 1
1713545 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 2021   grade_2 0 0 0   0 1     0   0   1 0     *   *     *   *   1 0 0 0   0 1     0   0   1 0                 1
1713578 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 2021   grade_2 0 0 1   12 0     0   0   4 9     0.0   0.0     11.0   4.0   13 0 0 1   12 0     0   0   4 9     0 0   11 4   13
1713645 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 2021   grade_2 0 0 0   111 0     0   0   57 54     0.0   7.0     *   22.0   111 0 0 0   111 0     0   0   57 54     0 7     22   111
1713655 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 2021   grade_2 0 0 0   19 0     0   0   12 7     0.0   4.0     *   2.0   19 0 0 0   19 0     0   0   12 7     0 4     2   19
1715131 MN Hennepin 27 school 2725200 279 Independent Districts and Schools Osseo Public School District 272520001210 672 Crest View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 0 25 7   1 3     0   0   15 21     11.0   *     24.0   5.0   36 0 25 7   1 3     0   0   15 21     11     24 5   36
1716877 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001593 496 Highwood Hills Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 0 15 4   0 9     0   2   14 16     17.0   0.0     25.0   1.0   30 0 15 4   0 9     0   2   14 16     17 0   25 1   30
1716945 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001619 541 Phalen Lake Hmong Studies Magnet Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 0 1 4   0 107     0   0   59 53     78.0   0.0     84.0   8.0   112 0 1 4   0 107     0   0   59 53     78 0   84 8   112
1717195 MN Saint Louis 69 school 2733720 707 Independent Districts and Schools Nett Lake Public School District 273372001508 1 Nett Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 0 0 0   7 0     0   0   5 2     *   *     *   *   7 0 0 0   7 0     0   0   5 2                 7
1719309 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004172 225 Anishinabe Academy Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 0 1 3   19 0     0   4   11 16     *   1.0     *   4.0   27 0 1 3   19 0     0   4   11 16       1     4   27
1719366 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002580 287 Hall International Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 0 28 3   1 0     0   1   17 16     1.0   0.0     *   6.0   33 0 28 3   1 0     0   1   17 16     1 0     6   33
1719440 MN Hennepin 27 school 2700027 4004 Charter Schools Cedar Riverside Community School 270002702340 10 Cedar Riverside Community School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_2 0 7 0   0 0     0   0   3 4     *   *     *   *   7 0 7 0   0 0     0   0   3 4                 7
1719504 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011704989 21 Banaadir Elementary Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2021   grade_2 0 40 0   0 0     0   0   22 18     27.0   0.0     *   4.0   40 0 40 0   0 0     0   0   22 18     27 0     4   40
1719539 MN Ramsey 62 school 2700140 4027 Charter Schools Higher Ground Academy 270014002719 10 Higher Ground Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 85 0   0 0     0   0   47 38     29.0   0.0     *   1.0   85 0 85 0   0 0     0   0   47 38     29 0     1   85
1719557 MN Ramsey 62 school 2700156 4035 Charter Schools Life Prep 270015602951 10 LIFE Prep Elementary School (Grades PK-6) Regular School Yes Elementary PK 06 2021   grade_2 0 18 3   2 8     0   0   19 12     5.0   0.0     21.0   3.0   31 0 18 3   2 8     0   0   19 12     5 0   21 3   31
1719566 MN Hennepin 27 school 2700159 4038 Charter Schools Sojourner Truth Academy 270015902954 10 Sojourner Truth Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_2 0 25 4   0 0     0   2   16 15     4.0   3.0     *   5.0   31 0 25 4   0 0     0   2   16 15     4 3     5   31
1719639 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 2021   grade_2 0 0 42   0 0     0   0   22 20     *   0.0     33.0   6.0   42 0 0 42   0 0     0   0   22 20       0   33 6   42
1719646 MN Hennepin 27 school 2700184 4068 Charter Schools Excell Academy Charter 270018403137 10 Excell Academy Charter Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_2 0 49 3   0 0     0   0   21 31     17.0   4.0     *   6.0   52 0 49 3   0 0     0   0   21 31     17 4     6   52
1719656 MN Ramsey 62 school 2700230 4070 Charter Schools HOPE Community Academy 270023003482 10 HOPE Community Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_2 0 1 1   0 70     0   0   38 34     46.0   1.0     57.0   3.0   72 0 1 1   0 70     0   0   38 34     46 1   57 3   72
1719687 MN Hennepin 27 school 2700189 4078 Charter Schools Twin Cities International Schools 270018905160 20 Twin Cities International Schools Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2021   grade_2 0 121 0   0 0     0   0   66 55     65.0   0.0     *   9.0   121 0 121 0   0 0     0   0   66 55     65 0     9   121
1719694 MN Hennepin 27 school 2700190 4079 Charter Schools Friendship Academy of Fine Arts Charter 270019005280 30 Friendship Academy of the Arts - Intermediate Elementary School (Grades PK-6) Regular School Yes Middle 02 08 2021   grade_2 0 40 2   0 0     0   0   22 20     1.0   1.0     *   7.0   42 0 40 2   0 0     0   0   22 20     1 1     7   42
1719720 MN Ramsey 62 school 2700353 4088 Charter Schools Urban Academy Charter School 270035304173 10 Urban Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 07 2021   grade_2 0 9 0   0 60     0   1   35 35     26.0   0.0     *   5.0   70 0 9 0   0 60     0   1   35 35     26 0     5   70
1719748 MN Hennepin 27 school 2700237 4097 Charter Schools Partnership Academy, Inc. 270023703278 10 Partnership Academy, Inc. Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_2 0 5 39   0 0     0   1   27 18     33.0   0.0     35.0   8.0   45 0 5 39   0 0     0   1   27 18     33 0   35 8   45
1719775 MN Ramsey 62 school 2700342 4103 Charter Schools Hmong College Prep Academy 270034205102 30 Hmong College Prep Academy ES Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2021   grade_2 0 0 0   0 180     0   0   83 97     83.0   0.0     135.0   13.0   180 0 0 0   0 180     0   0   83 97     83 0   135 13   180
1719850 MN Olmsted 55 school 2700247 4135 Charter Schools Rochester Math And Science Academy 270024703308 10 Rochester Math And Science Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_2 0 48 0   0 0     0   0   26 22     19.0   0.0     *   5.0   48 0 48 0   0 0     0   0   26 22     19 0     5   48
1719868 MN Hennepin 27 school 2700273 4139 Charter Schools LoveWorks Academy For Arts 270027303575 10 LoveWorks Academy For Arts Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_2 0 12 0   0 0     0   0   7 5     0.0   0.0     *   4.0   12 0 12 0   0 0     0   0   7 5     0 0     4   12
1719898 MN Hennepin 27 school 2700253 4143 Charter Schools New Millennium Academy Charter Sch 270025303311 10 New Millenium Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_2 0 4 2   0 92     0   1   50 49     72.0   2.0     57.0   7.0   99 0 4 2   0 92     0   1   50 49     72 2   57 7   99
1719933 MN Ramsey 62 school 2700263 4153 Charter Schools Midway Star Academy 270026303320 10 Midway Star Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_2 0 42 0   0 0     0   0   19 23     37.0   0.0     *   0.0   42 0 42 0   0 0     0   0   19 23     37 0     0   42
1719943 MN Mahnomen 44 school 2700275 4155 Charter Schools Naytahwaush Community School 270027503580 10 Naytahwaush Community School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 0 0   20 0     0   0   8 12     0.0   0.0     15.0   2.0   20 0 0 0   20 0     0   0   8 12     0 0   15 2   20
1720014 MN Hennepin 27 school 2700288 4170 Charter Schools Hiawatha Academies 270028803725 10 Hiawatha Leadership Acad-Morris Pk Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2021   grade_2 0 8 31   0 0     0   1   21 19     30.0   2.0     32.0   6.0   40 0 8 31   0 0     0   1   21 19     30 2   32 6   40
1720020 MN Hennepin 27 school 2700288 4170 Charter Schools Hiawatha Academies 270028804669 12 Hiawatha Leadership Academy-Northrop Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2021   grade_2 0 5 45   2 0     0   1   22 31     45.0   2.0     46.0   8.0   53 0 5 45   2 0     0   1   22 31     45 2   46 8   53
1720033 MN Hennepin 27 school 2700295 4171 Charter Schools Noble Academy 270029505126 20 Nompeng Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 02 2021   grade_2 0 11 0   0 74     0   0   49 36     48.0   0.0     64.0   3.0   85 0 11 0   0 74     0   0   49 36     48 0   64 3   85
1720047 MN Ramsey 62 school 2700304 4181 Charter Schools Community School of Excellence 270030403728 10 Community School of Excellence Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_2 0 0 0   0 152     0   0   80 72     128.0   1.0     119.0   8.0   152 0 0 0   0 152     0   0   80 72     128 1   119 8   152
1720116 MN Hennepin 27 school 2700308 4191 Charter Schools KIPP Minnesota Charter School 270030805286 40 KIPP Legacy Primary Elementary School (Grades PK-6) Regular School Yes Elementary KG 02 2021   grade_2 0 11 0   0 0     0   0   4 7     0.0   1.0     *   3.0   11 0 11 0   0 0     0   0   4 7     0 1     3   11
1720130 MN Ramsey 62 school 2700325 4193 Charter Schools College Preparatory Elementary 270032504338 10 College Preparatory Elementary Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 7 2   1 41     0   2   27 26     41.0   1.0     41.0   3.0   53 0 7 2   1 41     0   2   27 26     41 1   41 3   53
1720148 MN Cook 16 school 2700321 4195 Charter Schools Oshki Ogimaag Charter School 270032104293 10 Oshki Ogimaag Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 0 0   5 0     0   0   4 1     *   *     *   *   5 0 0 0   5 0     0   0   4 1                 5
1720170 MN Ramsey 62 school 2700367 4200 Charter Schools STEP Academy Charter School 270036705139 20 STEP Academy Elementary Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2021   grade_2 0 40 1   0 0     0   2   22 21     18.0   0.0     32.0   1.0   43 0 40 1   0 0     0   2   22 21     18 0   32 1   43
1720202 MN Hennepin 27 school 2700373 4209 Charter Schools Mastery School 270037304602 10 Mastery School Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2021   grade_2 0 22 0   0 0     0   0   7 15     0.0   0.0     *   2.0   22 0 22 0   0 0     0   0   7 15     0 0     2   22
1720220 MN Ramsey 62 school 2700380 4213 Charter Schools Prodeo Academy 270038005150 20 Prodeo Academy St. Paul Elementary School (Grades PK-6) Regular School Yes Elementary PK 03 2021   grade_2 0 8 1   0 31     0   0   21 19     31.0   0.0     *   *   40 0 8 1   0 31     0   0   21 19     31 0         40
1720266 MN Stearns 73 school 2700395 4223 Charter Schools Saint Cloud Math and Science Academy Charter School 270039504752 10 Saint Cloud Math and Science Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 38 0   0 0     0   0   19 19     28.0   0.0     32.0   3.0   38 0 38 0   0 0     0   0   19 19     28 0   32 3   38
1720285 MN Hennepin 27 school 2700393 4225 Charter Schools Universal Academy Charter School 270039304758 10 Universal Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_2 0 52 0   0 0     1   0   28 25     46.0   0.0     40.0   1.0   53 0 52 0   0 0     1   0   28 25     46 0   40 1   53
1720331 MN Ramsey 62 school 2700399 4231 Charter Schools Minnesota Math and Science Academy 270039904788 10 MMSA Elementary School Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2021   grade_2 0 41 0   0 0     0   0   21 20     *   0.0     *   1.0   41 0 41 0   0 0     0   0   21 20       0     1   41
1720337 MN Hennepin 27 school 2700404 4232 Charter Schools Success Academy 270040404790 10 Success Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2021   grade_2 0 22 0   0 1     0   0   13 10     15.0   0.0     18.0   2.0   23 0 22 0   0 1     0   0   13 10     15 0   18 2   23
1720362 MN Ramsey 62 school 2700410 4240 Charter Schools New Century School 270041004873 10 New Century School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_2 0 48 0   0 0     0   0   28 20     43.0   0.0     *   2.0   48 0 48 0   0 0     0   0   28 20     43 0     2   48
1720417 MN Hennepin 27 school 2700433 4255 Charter Schools Skyline Math and Science Academy 270043305067 10 Skyline Math and Science Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 36 0   0 0     0   0   21 15     *   0.0     *   3.0   36 0 36 0   0 0     0   0   21 15       0     3   36
1720425 MN Ramsey 62 school 2700438 4258 Charter Schools The Journey School 270043805258 10 The Journey School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 2 2   0 0     0   4   6 2     *   *     *   *   8 0 2 2   0 0     0   4   6 2                 8
1720433 MN Hennepin 27 school 2700439 4261 Charter Schools SciTech Academy Charter School 270043905072 10 SciTech Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2021   grade_2 0 36 0   0 0     0   0   16 20     *   0.0     *   4.0   36 0 36 0   0 0     0   0   16 20       0     4   36
1720440 MN Dakota 19 school 2700445 4264 Charter Schools Gateway STEM Academy 270044505138 10 Gateway STEM Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 39 0   0 0     0   0   16 23     23.0   0.0     *   2.0   39 0 39 0   0 0     0   0   16 23     23 0     2   39

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