Data source: Big Local News · About: Big Local

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

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
1713246 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 2021   grade_2 52 7 5   0 1     0   6   37 34     *   2.0     21.0   14.0   71 52 7 5   0 1     0   6   37 34       2   21 14   71
1713302 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 2021   grade_2 92 1 1   0 4     0   5   47 56     *   0.0     15.0   11.0   103 92 1 1   0 4     0   5   47 56       0   15 11   103
1713521 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 2021   grade_2 63 9 3   0 15     0   8   59 39     *   0.0     *   20.0   98 63 9 3   0 15     0   8   59 39       0     20   98
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
1713782 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 2021   grade_2 5 0 1   0 0     0   0   3 3     *   *     *   *   6 5 0 1   0 0     0   0   3 3                 6
1713834 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 04 2021   grade_2 54 0 3   9 0     0   10   35 41     *   *     *   *   76 54 0 3   9 0     0   10   35 41                 76
1714043 MN Clay 14 school 2713560 150 Independent Districts and Schools Hawley Public School District 271356000698 10 Hawley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 69 0 4   1 0     0   0   33 41     *   *     *   *   74 69 0 4   1 0     0   0   33 41                 74
1714051 MN Clay 14 school 2713560 150 Independent Districts and Schools Hawley Public School District 271356002240 11 Spring Prairie Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2021   grade_2 2 0 0   0 0     0   0   2 0     *   *     *   *   2 2 0 0   0 0     0   0   2 0                 2
1714117 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 2021   grade_2 79 1 1   2 1     0   4   48 40     *   0.0     35.0   21.0   88 79 1 1   2 1     0   4   48 40       0   35 21   88
1714143 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609000259 12 Riverside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 77 2 1   4 0     0   2   44 42     *   *     45.0   30.0   86 77 2 1   4 0     0   2   44 42           45 30   86
1714359 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239001377 706 Northview Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 37 8 4   0 6     0   8   32 31     *   0.0     14.0   8.0   63 37 8 4   0 6     0   8   32 31       0   14 8   63
1714779 MN Grant 26 school 2713890 264 Independent Districts and Schools Herman-Norcross School District 271389000713 1 Herman Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 3 0 0   0 0     0   0   2 1     *   *     *   *   3 3 0 0   0 0     0   0   2 1                 3
1715000 MN Hennepin 27 school 2711250 273 Independent Districts and Schools Edina Public School District 271125000507 528 Countryside Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 72 6 8   0 3     0   1   45 45     *   0.0     11.0   7.0   90 72 6 8   0 3     0   1   45 45       0   11 7   90
1715354 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178001339 30 Zachary Lane Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 43 10 5   1 1     0   4   37 27     *   0.0     *   11.0   64 43 10 5   1 1     0   4   37 27       0     11   64
1715394 MN Hennepin 27 school 2733780 283 Independent Districts and Schools St. Louis Park Public School District 273378002653 758 Park Spanish Immersion Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 69 4 9   0 0     0   5   43 44     *   0.0     *   *   87 69 4 9   0 0     0   5   43 44       0         87
1715564 MN Itasca 31 school 2713170 318 Independent Districts and Schools Grand Rapids Public School District 271317000661 110 Cohasset Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 40 0 0   2 0     0   1   18 25     *   *     15.0   7.0   43 40 0 0   2 0     0   1   18 25           15 7   43
1715588 MN Itasca 31 school 2713170 318 Independent Districts and Schools Grand Rapids Public School District 271317005236 155 West Rapids Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 89 0 1   4 0     1   6   55 46     *   0.0     33.0   21.0   101 89 0 1   4 0     1   6   55 46       0   33 21   101
1715709 MN Lac qui Parle 37 school 2710090 378 Independent Districts and Schools Dawson-Boyd Public School District 271009000429 10 Stevens Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 31 0 3   0 0     0   0   20 14     *   0.0     17.0   5.0   34 31 0 3   0 0     0   0   20 14       0   17 5   34
1715753 MN Lincoln 41 school 2713680 402 Independent Districts and Schools Hendricks Public School District 271368000707 10 Hendricks Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 8 0 1   0 0     0   0   3 6     *   *     *   *   9 8 0 1   0 0     0   0   3 6                 9
1716076 MN Nobles 53 school 2711460 514 Independent Districts and Schools Ellsworth Public School District 271146000525 10 Ellsworth Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 7 0 0   0 0     0   0   4 3     *   *     *   *   7 7 0 0   0 0     0   0   4 3                 7
1716085 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416001836 1 Prairie Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_2 38 14 121   0 23     0   6   116 86     *   0.0     151.0   33.0   202 38 14 121   0 23     0   6   116 86       0   151 33   202
1716101 MN Olmsted 55 school 2711010 533 Independent Districts and Schools Dover-Eyota Public School District 271101000453 20 Dover-Eyota Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 74 1 0   1 0     0   0   44 32     *   0.0     23.0   12.0   76 74 1 0   1 0     0   0   44 32       0   23 12   76
1716159 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180000994 125 Montessori At Franklin Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 20 0 2   0 8     0   3   18 15     *   0.0     5.0   *   33 20 0 2   0 8     0   3   18 15       0   5     33
1716442 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001129 35 Turtle Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_2 147 4 10   0 19     0   17   100 97     *   0.0     21.0   16.0   197 147 4 10   0 19     0   17   100 97       0   21 16   197
1716473 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St. Paul-Maplewood Oakdale Public School District 272385001168 29 Cowern Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 21 13 11   1 17     0   9   36 36     *   4.0     31.0   *   72 21 13 11   1 17     0   9   36 36       4   31     72
1716851 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001590 491 Highland Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 14 26 3   0 3     0   2   27 21     *   0.0     *   5.0   48 14 26 3   0 3     0   2   27 21       0     5   48
1717021 MN Redwood 64 school 2721210 635 Independent Districts and Schools Milroy Public School District 272121000927 1 Milroy Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 4 0 0   0 0     0   0   2 2     *   *     *   *   4 4 0 0   0 0     0   0   2 2                 4
1717116 MN Roseau 68 school 2741850 690 Independent Districts and Schools Warroad Public School District 274185001744 10 Warroad Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 52 0 1   3 7     0   9   40 32     *   *     *   *   72 52 0 1   3 7     0   9   40 32                 72
1717124 MN Lake of the Woods 39 school 2741850 690 Independent Districts and Schools Warroad Public School District 274185002456 20 Angle Inlet Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2021   grade_2 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
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
1717224 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools Duluth Public School District 271104000472 510 Lester Park Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 82 1 1   1 1     0   3   41 48     *   0.0     12.0   11.0   89 82 1 1   1 1     0   3   41 48       0   12 11   89
1717359 MN Scott 70 school 2733000 720 Independent Districts and Schools Shakopee Public School District 273300001437 861 Sun Path Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 50 17 7   2 5     0   11   50 42     *   *     *   14.0   92 50 17 7   2 5     0   11   50 42             14   92
1717401 MN Scott 70 school 2723430 721 Independent Districts and Schools New Prague Area Schools 272343001144 651 Falcon Ridge Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 73 0 2   1 0     0   3   38 41     *   0.0     10.0   9.0   79 73 0 2   1 0     0   3   38 41       0   10 9   79
1717696 MN Stevens 75 school 2708940 771 Independent Districts and Schools Chokio-Alberta Public School Dist. 270894000362 3 Chokio-Alberta Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 6 0 0   0 0     0   0   5 1     *   *     *   *   6 6 0 0   0 0     0   0   5 1                 6
1717705 MN Swift 76 school 2717120 775 Independent Districts and Schools Kerkhoven-Murdock-Sunburg 271712001890 30 Murdock Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 33 1 5   0 0     0   1   22 18     *   0.0     *   3.0   40 33 1 5   0 0     0   1   22 18       0     3   40
1717751 MN Traverse 78 school 2742330 803 Independent Districts and Schools Wheaton Area Public School District 274233001783 1 Pearson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 20 0 2   0 0     0   1   12 11     *   0.0     6.0   3.0   23 20 0 2   0 0     0   1   12 11       0   6 3   23
1717777 MN Wadena 80 school 2740920 818 Independent Districts and Schools Verndale Public School District 274092001712 10 Verndale Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 34 0 0   1 1     0   1   22 15     *   0.0     21.0   11.0   37 34 0 0   1 1     0   1   22 15       0   21 11   37
1718253 MN Isanti 30 school 2707410 911 Independent Districts and Schools Cambridge-Isanti Public School District 270741003638 101 Cambridge Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2021   grade_2 129 2 6   1 5     0   10   78 75     *   0.0     37.0   34.0   153 129 2 6   1 5     0   10   78 75       0   37 34   153
1718257 MN Isanti 30 school 2707410 911 Independent Districts and Schools Cambridge-Isanti Public School District 270741003686 102 Isanti Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2021   grade_2 124 1 6   1 5     0   3   65 75     *   0.0     47.0   23.0   140 124 1 6   1 5     0   3   65 75       0   47 23   140
1718341 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools St. Louis County School District 270000800158 10 Babbitt Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 9 0 0   0 1     0   2   4 8     *   *     *   *   12 9 0 0   0 1     0   2   4 8                 12
1718351 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools St. Louis County School District 270000801684 20 Tower-Soudan Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 2 0 0   4 0     0   0   1 5     *   *     *   *   6 2 0 0   4 0     0   0   1 5                 6
1718413 MN Pope 61 school 2700019 2149 Independent Districts and Schools Minnewaska School District 270001903536 70 Minnewaska Area Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2021   grade_2 89 0 1   0 1     0   4   44 51     *   *     *   *   95 89 0 1   0 1     0   4   44 51                 95
1718452 MN Pine 58 school 2714070 2165 Independent Districts and Schools Hinckley-Finlayson School District 271407000728 10 Hinckley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 44 0 4   9 1     0   6   27 37     *   *     *   *   64 44 0 4   9 1     0   6   27 37                 64
1718461 MN Pine 58 school 2714070 2165 Independent Districts and Schools Hinckley-Finlayson School District 271407000585 30 Finlayson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 5 0 1   0 0     0   0   3 3     *   *     *   *   6 5 0 1   0 0     0   0   3 3                 6
1718571 MN Fillmore 23 school 2700100 2198 Independent Districts and Schools Fillmore Central 270010001269 10 Fillmore Central Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 44 0 0   0 0     0   1   22 23     *   0.0     9.0   6.0   45 44 0 0   0 0     0   1   22 23       0   9 6   45
1718740 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools Pipestone Area School District 270010801262 3 Hill Elementary Elementary School (Grades PK-6) Regular School No Elementary 02 04 2021   grade_2 55 0 19   0 0     0   3   41 36     *   *     *   *   77 55 0 19   0 0     0   3   41 36                 77
1718746 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools Pipestone Area School District 270010803015 6 Heartland Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2021   grade_2 2 0 0   0 0     0   0   1 1     *   *     *   *   2 2 0 0   0 0     0   0   1 1                 2
1718895 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools Clinton-Graceville-Beardsley 270015005276 4 Big Stone Colony Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1718901 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools Clinton-Graceville-Beardsley 270015003019 6 Lismore Colony Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2021   grade_2 3 0 0   0 0     0   0   2 1     *   *     *   *   3 3 0 0   0 0     0   0   2 1                 3
1719246 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001866 175 Folwell Arts Magnet Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_2 7 25 24   7 0     0   9   37 35     *   3.0     *   9.0   72 7 25 24   7 0     0   9   37 35       3     9   72
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
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
1719576 MN Nicollet 52 school 2700174 4050 Charter Schools Lafayette Public Charter School 270017403042 10 Lafayette Public Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_2 6 0 0   1 0     0   0   3 4     *   *     *   *   7 6 0 0   1 0     0   0   3 4                 7
1719593 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori & STEM School 270017803046 10 La Crescent Montessori & STEM Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 2 0 0   0 0     0   0   2 0     *   *     *   *   2 2 0 0   0 0     0   0   2 0                 2
1719629 MN Winona 85 school 2700221 4064 Charter Schools Riverway Learning Community Charter 270022103478 10 Riverway Learning Community Charter Elementary School (Grades PK-6) Regular School Yes Elementary PK 06 2021   grade_2 4 1 2   0 0     0   1   3 5     *   *     *   *   8 4 1 2   0 0     0   1   3 5                 8
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
1719908 MN Sibley 72 school 2700254 4144 Charter Schools Green Isle Community School 270025403312 10 Green Isle Community School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 8 0 1   0 0     0   0   2 7     *   *     *   *   9 8 0 1   0 0     0   0   2 7                 9
1719916 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 2021   grade_2 7 0 0   0 0     0   0   4 3     *   *     *   *   7 7 0 0   0 0     0   0   4 3                 7
1720037 MN Yellow Medicine 87 school 2700290 4172 Charter Schools Clarkfield Charter School 270029003726 10 Clarkfield Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 5 0 0   1 0     0   0   3 3     *   *     *   *   6 5 0 0   1 0     0   0   3 3                 6
1720097 MN Hennepin 27 school 2700316 4189 Charter Schools Legacy of Dr. Josie R. Johnson Montessori 270031604319 10 Legacy of Dr. Josie R. Johnson Montessori Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 2 9 1   0 0     0   2   9 5     *   3.0     *   1.0   14 2 9 1   0 0     0   2   9 5       3     1   14
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
1720192 MN Hennepin 27 school 2700378 4208 Charter Schools Nasha Shkola Charter School 270037804635 10 Nasha Shkola Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_2 10 0 0   0 0     0   0   7 3     *   0.0     *   1.0   10 10 0 0   0 0     0   0   7 3       0     1   10
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
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
1720475 MN Ramsey 62 school 2700451 4269 Charter Schools Quantum STEAM Academy Charter School 270045105182 10 Quantum STEAM Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 13 0   0 0     0   0   8 5     *   0.0     *   1.0   13 0 13 0   0 0     0   0   8 5       0     1   13
1720513 MN Hennepin 27 school 2700460 4277 Charter Schools Metro Tech Academy Charter School 270046005321 20 Metro Tech Academy Elementary Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 3 0   0 0     0   0   2 1     *   *     *   *   3 0 3 0   0 0     0   0   2 1                 3
1720521 MN Anoka 2 school 2700464 4282 Charter Schools Innovation Science and Technology Academy Charter School 270046405322 10 Innovation Science and Technology Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 05 2021   grade_2 0 7 0   0 0     0   0   3 4     *   *     *   *   7 0 7 0   0 0     0   0   3 4                 7
1723454 MN Nicollet 52 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878004374 370 Futures Program Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1723493 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 Other KG 12 2021   grade_2 1 1 0   0 0     0   0   2 0     *   *     *   *   2 1 1 0   0 0     0   0   2 0                 2
1723545 MN Hennepin 27 school 2711250 273 Independent Districts and Schools Edina Public School District 271125002649 515 Special Ed-Non Public Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1723575 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178002441 103 Early Childhood Special Education Special Education Special Education School No Elementary PK 02 2021   grade_2 0 2 1   0 0     0   0   3 0     *   *     *   *   3 0 2 1   0 0     0   0   3 0                 3
1723581 MN Hennepin 27 school 2733780 283 Independent Districts and Schools St. Louis Park Public School District 273378000833 756 St. Louis Park Special Ed. Program Special Education Special Education School No Elementary PK 06 2021   grade_2 1 1 0   0 0     0   0   2 0     *   *     *   *   2 1 1 0   0 0     0   0   2 0                 2
1723635 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180000985 342 Rochester Phoenix Academy Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1723651 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 Elementary KG 07 2021   grade_2 2 0 0   0 0     0   0   2 0     *   *     *   *   2 2 0 0   0 0     0   0   2 0                 2
1723700 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384002189 430 Bridge View Special Education Special Education Special Education School No Other KG 12 2021   grade_2 1 1 0   1 2     0   2   5 2     *   *     *   *   7 1 1 0   1 2     0   2   5 2                 7
1723712 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 Other KG 12 2021   grade_2 0 1 0   0 0     0   1   2 0     *   *     *   *   2 0 1 0   0 0     0   1   2 0                 2
1723775 MN Scott 70 school 2733000 720 Independent Districts and Schools Shakopee Public School District 273300004646 905 Special Services Special Education Special Education School No Elementary PK 08 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1723779 MN Scott 70 school 2723430 721 Independent Districts and Schools New Prague Area Schools 272343003677 510 Central Education Campus Special Education Special Education School No Elementary 02 02 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1723801 MN Stearns 73 school 2733510 742 Independent Districts and Schools St. Cloud Public School District 273351004648 62 Roosevelt Education Center Special Education Special Education School No Other KG 12 2021   grade_2 0 3 0   0 0     0   0   3 0     *   *     *   *   3 0 3 0   0 0     0   0   3 0                 3
1723870 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124003022 625 River Bend Educational Center Special Education Special Education School No Other KG 12 2021   grade_2 1 2 1   0 0     0   0   4 0     *   *     *   *   4 1 2 1   0 0     0   0   4 0                 4
1723898 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) Minnesota State Academies 270012902409 2 MN Academy For The Deaf Special Education Special Education School No Other PK 12 2021   grade_2 4 1 1   0 0     0   0   3 3     *   *     *   *   6 4 1 1   0 0     0   0   3 3                 6
1723913 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002505315 302 Tier Two Special Education Special Education School No Other KG 12 2021   grade_2 1 0 1   0 0     0   1   3 0     *   *     *   *   3 1 0 1   0 0     0   1   3 0                 3
1723927 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002505316 303 Tier Three Special Education Special Education School No Other KG 12 2021   grade_2 1 3 0   0 1     0   0   5 0     *   *     *   *   5 1 3 0   0 1     0   0   5 0                 5
1723943 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042005038 12 SW Metro Level 4 Programs Special Education Special Education School No Other KG 12 2021   grade_2 5 1 0   0 0     0   0   6 0     *   *     *   *   6 5 1 0   0 0     0   0   6 0                 6
1723977 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 2021   grade_2 2 1 2   0 2     0   1   7 1     *   *     *   *   8 2 1 2   0 2     0   1   7 1                 8
1723994 MN Washington 82 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404951 58 Pankalo Education Center Special Education Special Education School No Elementary KG 08 2021   grade_2 2 2 0   0 0     0   1   4 1     *   *     *   *   5 2 2 0   0 0     0   1   4 1                 5
1724007 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602121 51 917 Intra-Dakota Educational Alt Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724021 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602124 60 Deaf/Hard of Hearing Special Education Special Education School No Other PK 12 2021   grade_2 1 1 0   0 1     0   0   2 1     *   *     *   *   3 1 1 0   0 1     0   0   2 1                 3
1724032 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602125 61 917 Paces Special Education Special Education School No Other KG 12 2021   grade_2 2 0 0   0 1     0   0   3 0     *   *     *   *   3 2 0 0   0 1     0   0   3 0                 3
1724069 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002604371 700 TEA Special Education Special Education School No Other PK 12 2021   grade_2 2 0 0   0 0     0   0   1 1     *   *     *   *   2 2 0 0   0 0     0   0   1 1                 2
1724081 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002605108 900 Customized Alternative Solutions for Education (CASE) Special Education Special Education School No Other PK 12 2021   grade_2 0 0 0   0 1     0   0   1 0     *   *     *   *   1 0 0 0   0 1     0   0   1 0                 1
1724105 MN Martin 46 school 2700046 915 Special Education Cooperatives Southern Plains Education Cooperative 270004604627 45 Southern Plains Bridges Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724147 MN Wright 86 school 2700045 938 Special Education Cooperatives Meeker And Wright Special Education 270004504351 17 Journeys Alternative Program Special Education Special Education School No Elementary KG 08 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724162 MN Mille Lacs 48 school 2700318 6079 Special Education Cooperatives Rum River Special Education Coop 270031804296 10 RUM RIVER NORTH Special Education Special Education School No Other PK 12 2021   grade_2 3 0 0   0 0     0   0   3 0     *   *     *   *   3 3 0 0   0 0     0   0   3 0                 3
1724175 MN Mower 50 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032704983 10 Enrich Program Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1724195 MN Mower 50 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032705011 40 CARDS Program Special Education Special Education School No Other PK 12 2021   grade_2 2 0 0   0 0     0   0   2 0     *   *     *   *   2 2 0 0   0 0     0   0   2 0                 2
1724213 MN Freeborn 24 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032705152 110 Enrich Alden Special Education Special Education School No Other KG 12 2021   grade_2 2 0 1   0 0     0   0   0 3     *   *     *   *   3 2 0 1   0 0     0   0   0 3                 3
1724230 MN Freeborn 24 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032705323 160 Success West Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1

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