Data source: Big Local News · About: Big Local

954 rows where grade = "grade_2", state = "MN" and year = 2018 sorted by ell_int

View and edit SQL

year

  • 2018 · 954

grade

  • grade_2 · 954
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
1881453 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 2018   grade_2 101.0 1.0 2.0   0.0 3.0     0.0   4.0   55.0 56.0     *   3.0     19.0   *   111.0 101 1 2   0 3     0   4   55 56       3   19     111
1881668 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 05 2018   grade_2 66.0 5.0 33.0   0.0 3.0     0.0   4.0   58.0 53.0     *   1.0     *   *   111.0 66 5 33   0 3     0   4   58 53       1         111
1881678 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 2018   grade_2 2.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 1.0     *   *     *   *   3.0 2 0 0   0 0     0   1   2 1                 3
1881720 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 01 05 2018   grade_2 66.0 0.0 1.0   7.0 0.0     0.0   6.0   39.0 41.0     *   0.0     26.0   9.0   80.0 66 0 1   7 0     0   6   39 41       0   26 9   80
1881763 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 PK 05 2018   grade_2 79.0 0.0 2.0   3.0 1.0     0.0   4.0   52.0 37.0     *   *     39.0   19.0   89.0 79 0 2   3 1     0   4   52 37           39 19   89
1881871 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 2018   grade_2 30.0 6.0 4.0   0.0 0.0     0.0   4.0   22.0 22.0     *   *     22.0   4.0   44.0 30 6 4   0 0     0   4   22 22           22 4   44
1881920 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 2018   grade_2 59.0 2.0 2.0   0.0 1.0     1.0   5.0   42.0 28.0     *   0.0     16.0   9.0   70.0 59 2 2   0 1     1   5   42 28       0   16 9   70
1881927 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 2018   grade_2 6.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 2.0     *   *     *   *   6.0 6 0 0   0 0     0   0   4 2                 6
1882109 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819003506 512 Victoria Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_2 88.0 2.0 4.0   2.0 2.0     0.0   7.0   57.0 48.0     *   0.0     8.0   10.0   105.0 88 2 4   2 2     0   7   57 48       0   8 10   105
1882187 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 2018   grade_2 59.0 0.0 2.0   1.0 0.0     0.0   3.0   31.0 34.0     *   *     *   *   65.0 59 0 2   1 0     0   3   31 34                 65
1882195 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 2018   grade_2 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *     *   *   2.0 2 0 0   0 0     0   0   1 1                 2
1882395 MN Dakota 19 school 2711820 192 Independent Districts and Schools Farmington Public School District 271182000569 10 Farmington Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2018   grade_2 88.0 5.0 6.0   0.0 1.0     0.0   5.0   54.0 51.0     *   *     22.0   14.0   105.0 88 5 6   0 1     0   5   54 51           22 14   105
1882419 MN Dakota 19 school 2711820 192 Independent Districts and Schools Farmington Public School District 271182004376 100 Riverview Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2018   grade_2 121.0 1.0 6.0   0.0 3.0     0.0   6.0   63.0 74.0     *   0.0     13.0   24.0   137.0 121 1 6   0 3     0   6   63 74       0   13 24   137
1882469 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778000025 596 Cherry View Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_2 73.0 1.0 5.0   1.0 5.0     0.0   6.0   44.0 47.0     *   0.0     9.0   16.0   91.0 73 1 5   1 5     0   6   44 47       0   9 16   91
1882476 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778002436 597 Lakeview Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_2 89.0 3.0 6.0   0.0 2.0     0.0   5.0   55.0 50.0     *   0.0     9.0   17.0   105.0 89 3 6   0 2     0   5   55 50       0   9 17   105
1882606 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239002283 719 Shannon Park Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_2 85.0 0.0 1.0   0.0 10.0     0.0   4.0   53.0 47.0     *   0.0     *   8.0   100.0 85 0 1   0 10     0   4   53 47       0     8   100
1882644 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Heights-Eagan 274227001776 815 Moreland Art/Health Science Magnet Elementary School (Grades PK-6) Regular School No Elementary PK 04 2018   grade_2 31.0 8.0 21.0   0.0 8.0     0.0   3.0   36.0 35.0     *   0.0     40.0   17.0   71.0 31 8 21   0 8     0   3   36 35       0   40 17   71
1882908 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 2018   grade_2 9.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 5.0     *   *     *   *   9.0 9 0 0   0 0     0   0   4 5                 9
1882924 MN Hennepin 27 school 2714260 270 Independent Districts and Schools Hopkins Public School District 271426001881 563 Glen Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2018   grade_2 48.0 13.0 2.0   0.0 1.0     0.0   3.0   37.0 30.0     *   0.0     16.0   7.0   67.0 48 13 2   0 1     0   3   37 30       0   16 7   67
1882974 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000640 432 Washburn Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2018   grade_2 23.0 17.0 16.0   2.0 3.0     0.0   8.0   41.0 28.0     *   0.0     44.0   11.0   69.0 23 17 16   2 3     0   8   41 28       0   44 11   69
1883027 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000234 455 Ridgeview Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_2 51.0 5.0 3.0   0.0 4.0     0.0   5.0   34.0 34.0     *   0.0     12.0   9.0   68.0 51 5 3   0 4     0   5   34 34       0   12 9   68
1883133 MN Hennepin 27 school 2711250 273 Independent Districts and Schools Edina Public School District 271125000709 533 Normandale Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_2 86.0 2.0 6.0   0.0 7.0     0.0   7.0   57.0 51.0     *   0.0     *   6.0   108.0 86 2 6   0 7     0   7   57 51       0     6   108
1883650 MN Itasca 31 school 2710140 317 Independent Districts and Schools Deer River Public School District 271014000434 4 King Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2018   grade_2 33.0 0.0 1.0   21.0 0.0     0.0   4.0   36.0 23.0     *   *     *   19.0   59.0 33 0 1   21 0     0   4   36 23             19   59
1883788 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001946 80 Northome Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2018   grade_2 9.0 0.0 1.0   3.0 0.0     0.0   0.0   4.0 9.0     *   *     *   *   13.0 9 0 1   3 0     0   0   4 9                 13
1883797 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001945 90 Indus Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2018   grade_2 6.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 2.0     *   *     *   *   6.0 6 0 0   0 0     0   0   4 2                 6
1883850 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 2018   grade_2 6.0 0.0 2.0   0.0 0.0     0.0   0.0   4.0 4.0     *   *     *   *   8.0 6 0 2   0 0     0   0   4 4                 8
1883954 MN Marshall 45 school 2718920 447 Independent Districts and Schools Grygla Public School District 271892000896 1 Grygla Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2018   grade_2 8.0 0.0 1.0   0.0 0.0     0.0   0.0   5.0 4.0     *   *     *   *   9.0 8 0 1   0 0     0   0   5 4                 9
1884014 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools Princeton Public School District 273003001274 1 Princeton Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2018   grade_2 213.0 0.0 6.0   2.0 0.0     0.0   3.0   112.0 112.0     *   *     *   *   224.0 213 0 6   2 0     0   3   112 112                 224
1884152 MN Murray 51 school 2712480 505 Independent Districts and Schools Fulda Public School District 271248000617 10 Fulda Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2018   grade_2 20.0 0.0 2.0   0.0 1.0     0.0   1.0   11.0 13.0     *   0.0     15.0   4.0   24.0 20 0 2   0 1     0   1   11 13       0   15 4   24
1884244 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180000990 120 Elton Hills Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2018   grade_2 47.0 10.0 13.0   1.0 9.0     0.0   5.0   42.0 43.0     *   *     49.0   18.0   85.0 47 10 13   1 9     0   5   42 43           49 18   85
1884321 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180001009 146 Pinewood Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2018   grade_2 29.0 6.0 4.0   1.0 1.0     0.0   4.0   28.0 17.0     *   0.0     16.0   5.0   45.0 29 6 4   1 1     0   4   28 17       0   16 5   45
1884344 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180001011 152 Washington Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_2 35.0 6.0 2.0   0.0 8.0     0.0   5.0   31.0 25.0     *   0.0     14.0   7.0   56.0 35 6 2   0 8     0   5   31 25       0   14 7   56
1884551 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 2018   grade_2 147.0 3.0 2.0   0.0 31.0     0.0   11.0   106.0 88.0     *   1.0     *   17.0   194.0 147 3 2   0 31     0   11   106 88       1     17   194
1884636 MN Ramsey 62 school 2732430 623 Independent Districts and Schools Roseville Public School District 273243001046 73 Parkview Center School Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_2 51.0 13.0 4.0   0.0 10.0     0.0   4.0   46.0 36.0     *   0.0     16.0   14.0   82.0 51 13 4   0 10     0   4   46 36       0   16 14   82
1885066 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001634 578 Obama Service Learning Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2018   grade_2 0.0 30.0 5.0   0.0 2.0     0.0   4.0   22.0 19.0     *   *     *   3.0   41.0 0 30 5   0 2     0   4   22 19             3   41
1885183 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 2018   grade_2 49.0 1.0 2.0   4.0 7.0     0.0   5.0   33.0 35.0     *   *     *   *   68.0 49 1 2   4 7     0   5   33 35                 68
1885191 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 2018   grade_2 2.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0     *   *     *   *   2.0 2 0 0   0 0     0   0   0 2                 2
1885272 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 2018   grade_2 0.0 0.0 0.0   2.0 0.0     0.0   2.0   4.0 0.0     *   *     *   *   4.0 0 0 0   2 0     0   2   4 0                 4
1885422 MN Scott 70 school 2733000 720 Independent Districts and Schools Shakopee Public School District 273300001441 860 Sweeney Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_2 69.0 5.0 16.0   0.0 3.0     0.0   9.0   43.0 59.0     *   2.0     41.0   13.0   102.0 69 5 16   0 3     0   9   43 59       2   41 13   102
1885781 MN Stevens 75 school 2708940 771 Independent Districts and Schools Chokio-Alberta Public School District 270894000362 3 Chokio-Alberta Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2018   grade_2 9.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 5.0     *   *     *   *   9.0 9 0 0   0 0     0   0   4 5                 9
1885818 MN Todd 77 school 2706300 787 Independent Districts and Schools Browerville Public School District 270630000277 10 Browerville Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2018   grade_2 36.0 0.0 1.0   0.0 0.0     0.0   0.0   15.0 22.0     *   *     *   5.0   37.0 36 0 1   0 0     0   0   15 22             5   37
1886178 MN Wilkin 84 school 2707450 852 Independent Districts and Schools Campbell-Tintah Public School District 270745000319 10 Campbell-Tintah Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2018   grade_2 6.0 0.0 2.0   0.0 0.0     0.0   1.0   7.0 2.0     *   *     *   *   9.0 6 0 2   0 0     0   1   7 2                 9
1886502 MN Chisago 13 school 2700017 2144 Independent Districts and Schools Chisago Lakes School District 270001700352 1 Chisago Lakes El. Elementary School (Grades PK-6) Regular School No Elementary PK 02 2018   grade_2 191.0 0.0 4.0   0.0 1.0     0.0   4.0   102.0 98.0     *   *     46.0   14.0   200.0 191 0 4   0 1     0   4   102 98           46 14   200
1886517 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 2018   grade_2 80.0 1.0 3.0   0.0 0.0     0.0   0.0   50.0 34.0     *   *     *   *   84.0 80 1 3   0 0     0   0   50 34                 84
1886566 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 2018   grade_2 39.0 2.0 4.0   3.0 1.0     0.0   11.0   30.0 30.0     *   *     *   *   60.0 39 2 4   3 1     0   11   30 30                 60
1886574 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 2018   grade_2 7.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 3.0     *   *     *   *   7.0 7 0 0   0 0     0   0   4 3                 7
1886718 MN Grant 26 school 2700104 2342 Independent Districts and Schools West Central Area 270010400513 1 West Central Area North Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2018   grade_2 20.0 0.0 1.0   0.0 0.0     0.0   2.0   12.0 11.0     *   0.0     12.0   7.0   23.0 20 0 1   0 0     0   2   12 11       0   12 7   23
1886725 MN Douglas 21 school 2700104 2342 Independent Districts and Schools West Central Area 270010400731 2 West Central Area South Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2018   grade_2 24.0 0.0 3.0   0.0 0.0     0.0   2.0   15.0 14.0     *   0.0     13.0   6.0   29.0 24 0 3   0 0     0   2   15 14       0   13 6   29
1886833 MN Roseau 68 school 2700107 2683 Independent Districts and Schools Greenbush-Middle River School District 270010700920 10 Greenbush Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2018   grade_2 17.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 9.0     *   *     *   *   17.0 17 0 0   0 0     0   0   8 9                 17
1886841 MN Marshall 45 school 2700107 2683 Independent Districts and Schools Greenbush-Middle River School District 270010702572 11 Middle River Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2018   grade_2 5.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 1.0     *   *     *   *   5.0 5 0 0   0 0     0   0   4 1                 5
1886861 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 2018   grade_2 53.0 2.0 12.0   0.0 1.0     0.0   5.0   40.0 33.0     *   *     *   *   73.0 53 2 12   0 1     0   5   40 33                 73
1886866 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 2018   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *     *   *   1.0 1 0 0   0 0     0   0   1 0                 1
1887010 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 2018   grade_2 24.0 0.0 0.0   0.0 0.0     0.0   1.0   9.0 16.0     *   *     *   *   25.0 24 0 0   0 0     0   1   9 16                 25
1887318 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001054 165 Waite Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2018   grade_2 44.0 11.0 5.0   0.0 0.0     0.0   5.0   29.0 36.0     *   3.0     *   6.0   65.0 44 11 5   0 0     0   5   29 36       3     6   65
1887396 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004883 216 Fair Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2018   grade_2 1.0 3.0 1.0   0.0 0.0     0.0   1.0   3.0 3.0     *   *     *   *   6.0 1 3 1   0 0     0   1   3 3                 6
1887600 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703566 17 Banaadir Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 06 2018   grade_2 0.0 38.0 0.0   0.0 0.0     0.0   0.0   20.0 18.0     *   1.0     *   2.0   38.0 0 38 0   0 0     0   0   20 18       1     2   38
1887608 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011704989 21 Banaadir South Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2018   grade_2 0.0 20.0 0.0   0.0 0.0     0.0   0.0   8.0 12.0     *   0.0     *   0.0   20.0 0 20 0   0 0     0   0   8 12       0     0   20
1887689 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 2018   grade_2 6.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 6.0     *   *     *   *   6.0 6 0 0   0 0     0   0   0 6                 6
1887699 MN Nicollet 52 school 2700174 4050 Charter Schools Lafayette Public Charter School 270017404126 20 Starland Elementary Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *     *   *   1.0 1 0 0   0 0     0   0   1 0                 1
1887707 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori and STEM School 270017803046 10 La Crescent Montessori and STEM Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2018   grade_2 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *     *   *   2.0 2 0 0   0 0     0   0   2 0                 2
1887743 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 08 2018   grade_2 4.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 3.0     *   *     *   *   5.0 4 0 0   0 0     0   1   2 3                 5
1887753 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 2018   grade_2 0.0 0.0 43.0   0.0 0.0     0.0   0.0   16.0 27.0     *   0.0     *   7.0   43.0 0 0 43   0 0     0   0   16 27       0     7   43
1887847 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 KG 05 2018   grade_2 0.0 1.0 44.0   0.0 0.0     0.0   0.0   23.0 22.0     *   3.0     *   4.0   45.0 0 1 44   0 0     0   0   23 22       3     4   45
1887970 MN Redwood 64 school 2700250 4138 Charter Schools Milroy Area Charter School 270025003310 10 Milroy Area Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2018   grade_2 4.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 3.0     *   *     *   *   4.0 4 0 0   0 0     0   0   1 3                 4
1888014 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 2018   grade_2 4.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 3.0     *   *     *   *   5.0 4 0 0   0 0     0   1   2 3                 5
1888022 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 PK 05 2018   grade_2 8.0 1.0 0.0   0.0 0.0     0.0   0.0   5.0 4.0     *   *     *   *   9.0 8 1 0   0 0     0   0   5 4                 9
1888039 MN Ramsey 62 school 2700263 4153 Charter Schools Dugsi Academy 270026303320 10 Dugsi Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_2 0.0 23.0 0.0   0.0 0.0     0.0   0.0   15.0 8.0     *   0.0     *   2.0   23.0 0 23 0   0 0     0   0   15 8       0     2   23
1888134 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 2018   grade_2 7.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 4.0     *   *     *   *   7.0 7 0 0   0 0     0   0   3 4                 7
1888239 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 2018   grade_2 0.0 0.0 0.0   2.0 0.0     0.0   0.0   0.0 2.0     *   *     *   *   2.0 0 0 0   2 0     0   0   0 2                 2
1888261 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 06 2018   grade_2 0.0 20.0 0.0   0.0 0.0     0.0   0.0   12.0 8.0     *   0.0     *   0.0   20.0 0 20 0   0 0     0   0   12 8       0     0   20
1888372 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 Elementary PK 08 2018   grade_2 0.0 31.0 0.0   0.0 0.0     0.0   0.0   6.0 25.0     *   0.0     *   0.0   31.0 0 31 0   0 0     0   0   6 25       0     0   31
1888450 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 KG 06 2018   grade_2 0.0 27.0 0.0   0.0 0.0     0.0   0.0   12.0 15.0     *   0.0     *   0.0   27.0 0 27 0   0 0     0   0   12 15       0     0   27
1891384 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 River Trail Learning Center at Lo Jacob Special Education Special Education School No Other KG 12 2018   grade_2 4.0 1.0 0.0   0.0 0.0     0.0   0.0   5.0 0.0     *   *     *   *   5.0 4 1 0   0 0     0   0   5 0                 5
1891427 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 2018   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *     *   *   1.0 1 0 0   0 0     0   0   1 0                 1
1891466 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 2018   grade_2 2.0 1.0 1.0   0.0 0.0     0.0   0.0   3.0 1.0     *   *     *   *   4.0 2 1 1   0 0     0   0   3 1                 4
1891486 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Heights-Eagan 274227005008 827 Special Education Special Education Special Education School No Other KG 12 2018   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *     *   *   1.0 1 0 0   0 0     0   0   1 0                 1
1891503 MN Hennepin 27 school 2714260 270 Independent Districts and Schools Hopkins Public School District 271426005032 611 SENOPS Special Education Special Education School No Other KG 12 2018   grade_2 0.0 0.0 1.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *     *   *   1.0 0 0 1   0 0     0   0   0 1                 1
1891522 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 2018   grade_2 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *     *   *   1.0 0 0 1   0 0     0   0   1 0                 1
1891571 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 Elementary KG 05 2018   grade_2 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0     *   *     *   *   1.0 0 0 0   1 0     0   0   1 0                 1
1891607 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 2018   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 0.0     *   *     *   *   2.0 1 0 0   0 0     0   1   2 0                 2
1891632 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 2018   grade_2 1.0 2.0 0.0   0.0 0.0     0.0   2.0   5.0 0.0     *   *     *   *   5.0 1 2 0   0 0     0   2   5 0                 5
1891673 MN Ramsey 62 school 2732430 623 Independent Districts and Schools Roseville Public School District 273243002668 732 Fairview Program Special Education Special Education School No Other PK 12 2018   grade_2 1.0 0.0 0.0   0.0 1.0     0.0   0.0   1.0 1.0     *   *     *   *   2.0 1 0 0   0 1     0   0   1 1                 2
1891686 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 2018   grade_2 1.0 5.0 0.0   0.0 3.0     0.0   0.0   6.0 3.0     *   *     *   *   9.0 1 5 0   0 3     0   0   6 3                 9
1891758 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 2018   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *     *   *   1.0 1 0 0   0 0     0   0   1 0                 1
1891784 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 2018   grade_2 1.0 1.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *     *   *   2.0 1 1 0   0 0     0   0   2 0                 2
1891830 MN Chisago 13 school 2700017 2144 Independent Districts and Schools Chisago Lakes School District 270001703386 10 Level 4 Program Pathways To Change Special Education Special Education School No Other KG 12 2018   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *     *   *   1.0 1 0 0   0 0     0   0   1 0                 1
1891860 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 2018   grade_2 1.0 3.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0     *   *     *   *   4.0 1 3 0   0 0     0   0   3 1                 4
1891874 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) Minnesota State Academies 270012903056 1 Minnesota Academy for the Blind Special Education Special Education School No Other PK 12 2018   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *     *   *   1.0 1 0 0   0 0     0   0   0 1                 1
1891889 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) Minnesota State Academies 270012902409 2 Minnesota Academy for the Deaf Special Education Special Education School No Other PK 12 2018   grade_2 5.0 2.0 0.0   0.0 0.0     0.0   0.0   3.0 4.0     *   *     *   *   7.0 5 2 0   0 0     0   0   3 4                 7
1891916 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503213 440 Options Mid/Elem EBD Special Education Special Education School No Other KG 09 2018   grade_2 0.0 1.0 0.0   0.0 0.0     0.0   1.0   1.0 1.0     *   *     *   *   2.0 0 1 0   0 0     0   1   1 1                 2
1891937 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503226 465 Sun Special Education Special Education School No Other KG 12 2018   grade_2 1.0 1.0 0.0   0.0 1.0     0.0   0.0   2.0 1.0     *   *     *   *   3.0 1 1 0   0 1     0   0   2 1                 3
1891978 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503234 486 CIP Special Education Special Education School No Other 01 12 2018   grade_2 0.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *     *   *   1.0 0 1 0   0 0     0   0   1 0                 1
1891994 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 2018   grade_2 3.0 1.0 0.0   0.0 2.0     0.0   0.0   6.0 0.0     *   *     *   *   6.0 3 1 0   0 2     0   0   6 0                 6
1892051 MN Washington 82 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404951 58 Pankalo Special Education Special Education School No Elementary KG 08 2018   grade_2 4.0 2.0 1.0   0.0 0.0     0.0   0.0   6.0 1.0     *   *     *   *   7.0 4 2 1   0 0     0   0   6 1                 7
1892067 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602121 51 917 Intra-Dakota Educational Alt Special Education Special Education School No Other KG 12 2018   grade_2 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0     *   *     *   *   1.0 0 0 0   0 0     0   1   1 0                 1
1892082 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 2018   grade_2 1.0 1.0 2.0   0.0 0.0     0.0   0.0   3.0 1.0     *   *     *   *   4.0 1 1 2   0 0     0   0   3 1                 4
1892093 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602125 61 917 PACES Special Education Special Education School No Other KG 12 2018   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *     *   *   1.0 1 0 0   0 0     0   0   1 0                 1
1892106 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002604218 400 917 SUN Special Education Special Education School No Other KG 12 2018   grade_2 3.0 1.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0     *   *     *   *   4.0 3 1 0   0 0     0   0   3 1                 4
1892120 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002603897 500 917 DASH Special Education Special Education School No Other PK 12 2018   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *     *   *   1.0 1 0 0   0 0     0   0   1 0                 1
1892131 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002604371 700 TEA Special Education Special Education School No Other KG 12 2018   grade_2 1.0 1.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *     *   *   2.0 1 1 0   0 0     0   0   2 0                 2

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