Data source: Big Local News · About: Big Local

956 rows where grade = "grade_1", state = "MN" and year = 2021 sorted by school_state_id

View and edit SQL

year

  • 2021 · 956

grade

  • grade_1 · 956
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
1713221 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_1 13 0 0   0 0     0   1   12 2     0.0   0.0     9.0   *   14 13 0 0   0 0     0   1   12 2     0 0   9     14
1713817 MN Carlton 9 school 2703690 91 Independent Districts and Schools Barnum Public School District 270369000171 1 Barnum Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 43 0 1   1 0     0   5   26 24     0.0   0.0     11.0   15.0   50 43 0 1   1 0     0   5   26 24     0 0   11 15   50
1713873 MN Carlton 9 school 2744190 100 Independent Districts and Schools Wrenshall Public School District 274419001842 1 Wrenshall Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 18 0 1   0 0     0   0   7 12     0.0   0.0     *   2.0   19 18 0 1   0 0     0   0   7 12     0 0     2   19
1714654 MN Fillmore 23 school 2718540 238 Independent Districts and Schools Mabel-Canton Public School Dist. 271854000857 1 Mabel-Canton Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 21 0 1   0 0     0   0   9 13     *   0.0     *   1.0   22 21 0 1   0 0     0   0   9 13       0     1   22
1714663 MN Fillmore 23 school 2728290 239 Independent Districts and Schools Rushford-Peterson Public Schools 272829001407 1 Rushford-Peterson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 43 0 1   0 0     0   0   31 13     *   0.0     16.0   4.0   44 43 0 1   0 0     0   0   31 13       0   16 4   44
1714712 MN Goodhue 25 school 2707500 252 Independent Districts and Schools Cannon Falls Public School District 270750000323 1 Cannon Falls Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 75 0 0   0 0     0   2   47 30     0.0   0.0     18.0   13.0   77 75 0 0   0 0     0   2   47 30     0 0   18 13   77
1714720 MN Goodhue 25 school 2712900 253 Independent Districts and Schools Goodhue Public School District 271290000647 1 Goodhue Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 48 1 3   0 0     0   2   26 28     *   0.0     9.0   4.0   54 48 1 3   0 0     0   2   26 28       0   9 4   54
1714778 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_1 3 0 0   0 0     0   0   3 0     *   *     *   *   3 3 0 0   0 0     0   0   3 0                 3
1715792 MN Lyon 42 school 2721270 414 Independent Districts and Schools Minneota Public School District 272127001067 1 Minneota Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 29 0 0   0 0     0   2   16 15     0.0   0.0     *   4.0   31 29 0 0   0 0     0   2   16 15     0 0     4   31
1715855 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 2021   grade_1 8 0 0   0 0     0   0   4 4     *   *     *   *   8 8 0 0   0 0     0   0   4 4                 8
1715891 MN Wright 86 school 2710060 466 Independent Districts and Schools Dassel-Cokato Public School Dist. 271006000426 1 Cokato Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_1 79 1 3   1 0     0   1   46 39     1.0   0.0     19.0   14.0   85 79 1 3   1 0     0   1   46 39     1 0   19 14   85
1715914 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 KG 02 2021   grade_1 166 1 9   3 2     0   6   92 95     1.0   0.0     56.0   34.0   187 166 1 9   3 2     0   6   92 95     1 0   56 34   187
1716084 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_1 32 13 148   3 16     0   8   102 118     147.0   *     172.0   *   220 32 13 148   3 16     0   8   102 118     147     172     220
1716396 MN Polk 60 school 2712180 600 Independent Districts and Schools Fisher Public School District 271218000587 1 Fisher Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 15 1 1   0 0     0   0   10 7     0.0   0.0     4.0   0.0   17 15 1 1   0 0     0   0   10 7     0 0   4 0   17
1717020 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_1 5 0 0   0 0     0   0   4 1     *   *     *   *   5 5 0 0   0 0     0   0   4 1                 5
1717194 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_1 0 0 0   7 0     0   0   5 2     *   *     *   *   7 0 0 0   7 0     0   0   5 2                 7
1717278 MN Saint Louis 69 school 2700001 712 Independent Districts and Schools Mountain Iron-Buhl School District 270000101610 1 Merritt Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 32 0 2   0 0     0   2   14 22     0.0   0.0     13.0   9.0   36 32 0 2   0 0     0   2   14 22     0 0   13 9   36
1717490 MN Stearns 73 school 2714190 738 Independent Districts and Schools Holdingford Public School District 271419000732 1 Holdingford Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 69 0 0   0 0     0   0   33 36     0.0   0.0     7.0   10.0   69 69 0 0   0 0     0   0   33 36     0 0   7 10   69
1717515 MN Stearns 73 school 2728140 741 Independent Districts and Schools Paynesville Public School District 272814001240 1 Paynesville Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 59 0 4   0 0     0   1   27 37     0.0   0.0     11.0   9.0   64 59 0 4   0 0     0   1   27 37     0 0   11 9   64
1717750 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_1 16 0 4   0 0     0   0   12 8     2.0   0.0     4.0   2.0   20 16 0 4   0 0     0   0   12 8     2 0   4 2   20
1717785 MN Wadena 80 school 2732970 820 Independent Districts and Schools Sebeka Public School District 273297001435 1 Sebeka Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 24 0 0   0 0     0   2   11 15     0.0   0.0     11.0   7.0   26 24 0 0   0 0     0   2   11 15     0 0   11 7   26
1718132 MN Wright 86 school 2703150 876 Independent Districts and Schools Annandale Public School District 270315000094 1 Annandale Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 132 0 2   0 1     0   6   70 71     2.0   0.0     18.0   36.0   141 132 0 2   0 1     0   6   70 71     2 0   18 36   141
1718284 MN Clay 14 school 2740810 914 Independent Districts and Schools Ulen-Hitterdal Public School Dist 274081001704 1 Ulen-Hitterdal Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2021   grade_1 13 0 1   2 0     0   4   8 12     0.0   0.0     7.0   6.0   20 13 0 1   2 0     0   4   8 12     0 0   7 6   20
1718397 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 01 2021   grade_1 181 2 4   0 4     0   7   103 95     1.0   1.0     22.0   19.0   198 181 2 4   0 4     0   7   103 95     1 1   22 19   198
1718436 MN Clay 14 school 2710260 2164 Independent Districts and Schools Dilworth-Glyndon-Felton 271026000447 1 Dilworth Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_1 70 4 8   1 1     0   4   42 46     6.0   1.0     25.0   18.0   88 70 4 8   1 1     0   4   42 46     6 1   25 18   88
1718605 MN Grant 26 school 2700104 2342 Independent Districts and Schools West Central Area 270010400513 1 West Central Area N. El. Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_1 45 0 0   0 0     0   0   25 20     0.0   0.0     9.0   9.0   45 45 0 0   0 0     0   0   25 20     0 0   9 9   45
1718629 MN Stearns 73 school 2700105 2364 Independent Districts and Schools Belgrade-Brooten-Elrosa Public School District 270010500182 1 Belgrade-Brooten-Elrosa Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 47 0 0   0 0     0   0   23 24     0.0   0.0     14.0   6.0   47 47 0 0   0 0     0   0   23 24     0 0   14 6   47
1718638 MN Sibley 72 school 2712580 2365 Independent Districts and Schools G.F.W. 271258000042 1 GFW Elementary School (PreK-5th Grade) Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 33 0 11   0 0     0   1   21 24     5.0   1.0     18.0   10.0   45 33 0 11   0 0     0   1   21 24     5 1   18 10   45
1718676 MN Norman 54 school 2791448 2527 Independent Districts and Schools Norman County West School District 279144802317 1 Norman County West Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 6 0 4   0 0     0   1   4 7     1.0   0.0     9.0   1.0   11 6 0 4   0 0     0   1   4 7     1 0   9 1   11
1718725 MN Mcleod 43 school 2700123 2687 Independent Districts and Schools Howard Lake-Waverly-Winsted 270012300908 1 Winsted Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_1 25 0 3   0 0     0   0   14 14     1.0   0.0     9.0   7.0   28 25 0 3   0 0     0   0   14 14     1 0   9 7   28
1718783 MN Renville 65 school 2700110 2754 Independent Districts and Schools Cedar Mountain School District 270011001098 1 Cedar Mountain Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 16 0 2   2 0     0   2   9 13     0.0   0.0     8.0   6.0   22 16 0 2   2 0     0   2   9 13     0 0   8 6   22
1718888 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools Clinton-Graceville-Beardsley 270015000378 1 Pre-K - 5th Grade Building Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 23 0 1   0 0     0   1   14 11     0.0   0.0     10.0   7.0   25 23 0 1   0 0     0   1   14 11     0 0   10 7   25
1718919 MN Renville 65 school 2700163 2890 Independent Districts and Schools Renville County West School Dist. 270016301417 1 Renville County West Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 31 0 10   0 0     0   3   20 24     6.0   0.0     14.0   7.0   44 31 0 10   0 0     0   3   20 24     6 0   14 7   44
1719044 MN Douglas 21 school 2700382 2908 Independent Districts and Schools Brandon-Evansville Public Schools 270038204738 1 Brandon Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2021   grade_1 34 1 0   0 0     0   1   22 14     0.0   0.0     10.0   3.0   36 34 1 0   0 0     0   1   22 14     0 0   10 3   36
1713211 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 51 3 1   1 0     0   7   32 31     0.0   0.0     22.0   15.0   63 51 3 1   1 0     0   7   32 31     0 0   22 15   63
1713800 MN Brown 8 school 2733390 85 Independent Districts and Schools Springfield Public School District 273339001470 2 Springfield Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 30 0 8   0 0     0   0   18 20     0.0   0.0     24.0   5.0   38 30 0 8   0 0     0   0   18 20     0 0   24 5   38
1713826 MN Carlton 9 school 2707590 93 Independent Districts and Schools Carlton Public School District 270759000328 2 South Terrace Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 25 0 2   6 0     0   4   20 17     0.0   0.0     8.0   8.0   37 25 0 2   6 0     0   4   20 17     0 0   8 8   37
1714636 MN Fillmore 23 school 2708220 227 Independent Districts and Schools Chatfield Public Schools 270822000349 2 Chatfield Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 53 0 2   1 0     0   4   27 33     0.0   0.0     10.0   7.0   60 53 0 2   1 0     0   4   27 33     0 0   10 7   60
1714703 MN Freeborn 24 school 2703030 242 Independent Districts and Schools Alden-Conger Public School District 270303000079 2 Alden-Conger Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 26 0 0   0 0     0   3   13 16     0.0   0.0     *   4.0   29 26 0 0   0 0     0   3   13 16     0 0     4   29
1715536 MN Isanti 30 school 2706060 314 Independent Districts and Schools Braham Public School District 270606000245 2 Braham Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 54 0 2   0 1     0   1   28 30     0.0   0.0     21.0   8.0   58 54 0 2   0 1     0   1   28 30     0 0   21 8   58
1715781 MN Lyon 42 school 2718940 413 Independent Districts and Schools Marshall Public School District 271894000891 2 Park Side Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2021   grade_1 96 11 36   1 18     1   11   84 90     47.0   2.0     77.0   29.0   174 96 11 36   1 18     1   11   84 90     47 2   77 29   174
1717142 MN Saint Louis 69 school 2711520 696 Independent Districts and Schools Ely Public School District 271152000529 2 Washington Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 30 0 0   0 0     0   2   14 18     0.0   0.0     *   4.0   32 30 0 0   0 0     0   2   14 18     0 0     4   32
1718104 MN Winona 85 school 2733450 858 Independent Districts and Schools St. Charles Public School District 273345001475 2 St. Charles Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 63 1 5   0 0     0   3   46 26     4.0   2.0     18.0   13.0   72 63 1 5   0 0     0   3   46 26     4 2   18 13   72
1718112 MN Winona 85 school 2744070 861 Independent Districts and Schools Winona Area Public School District 274407001822 2 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2021   grade_1 55 10 8   1 1     0   5   46 34     3.0   *     30.0   19.0   80 55 10 8   1 1     0   5   46 34     3     30 19   80
1718219 MN Hennepin 27 school 2732070 883 Independent Districts and Schools Rockford Public School District 273207001367 2 Rockford Elementary Arts Magnet Sch Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_1 90 2 10   0 2     0   5   60 49     10.0   1.0     22.0   11.0   109 90 2 10   0 2     0   5   60 49     10 1   22 11   109
1718418 MN Wadena 80 school 2700022 2155 Independent Districts and Schools Wadena-Deer Creek School District 270002200431 2 Wadena-Deer Creek Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_1 76 0 4   1 0     0   3   42 42     0.0   1.0     38.0   27.0   84 76 0 4   1 0     0   3   42 42     0 1   38 27   84
1718442 MN Clay 14 school 2710260 2164 Independent Districts and Schools Dilworth-Glyndon-Felton 271026002690 2 Glyndon-Felton Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 30 0 3   1 0     0   2   13 23     0.0   0.0     7.0   9.0   36 30 0 3   1 0     0   2   13 23     0 0   7 9   36
1718537 MN Chippewa 12 school 2700091 2180 Independent Districts and Schools MACCRAY School District 270009100898 2 MACCRAY WEST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 23 0 2   0 0     2   1   14 14     2.0   0.0     9.0   3.0   28 23 0 2   0 0     2   1   14 14     2 0   9 3   28
1718554 MN Rock 67 school 2718330 2184 Independent Districts and Schools Luverne Public School District 271833000851 2 Luverne Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 68 0 6   0 1     0   7   43 39     0.0   0.0     25.0   14.0   82 68 0 6   0 1     0   7   43 39     0 0   25 14   82
1718612 MN Douglas 21 school 2700104 2342 Independent Districts and Schools West Central Area 270010400731 2 West Central Area S. El. Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_1 22 0 2   0 0     0   0   10 14     0.0   0.0     8.0   9.0   24 22 0 2   0 0     0   0   10 14     0 0   8 9   24
1718738 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools Pipestone Area School District 270010801261 2 Brown Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2021   grade_1 55 1 18   1 1     0   2   42 36     *   *     *   *   78 55 1 18   1 1     0   2   42 36                 78
1718938 MN Redwood 64 school 2700182 2897 Independent Districts and Schools Redwood Area School District 270018201305 2 Reede Gray Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_1 49 1 3   19 0     0   1   40 33     0.0   0.0     33.0   13.0   73 49 1 3   19 0     0   1   40 33     0 0   33 13   73
1718983 MN Lyon 42 school 2700326 2904 Independent Districts and Schools Tracy Area Public School District 270032604393 2 Tracy Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 36 2 3   0 7     0   0   33 15     6.0   0.0     25.0   5.0   48 36 2 3   0 7     0   0   33 15     6 0   25 5   48
1723897 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_1 3 1 0   0 0     0   0   2 2     *   *     *   *   4 3 1 0   0 0     0   0   2 2                 4
1713664 MN Benton 5 school 2732880 47 Independent Districts and Schools Sauk Rapids-Rice Public Schools 273288001430 3 Mississippi Heights Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_1 105 3 12   0 2     0   14   81 55     4.0   0.0     35.0   27.0   136 105 3 12   0 2     0   14   81 55     4 0   35 27   136
1714568 MN Dodge 20 school 2713590 203 Independent Districts and Schools Hayfield Public School District 271359000701 3 Hayfield Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 40 0 3   0 0     0   0   22 21     0.0   0.0     16.0   5.0   43 40 0 3   0 0     0   0   22 21     0 0   16 5   43
1715898 MN Meeker 47 school 2710060 466 Independent Districts and Schools Dassel-Cokato Public School Dist. 271006000427 3 Dassel Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_1 47 1 2   0 0     0   1   26 25     0.0   0.0     15.0   9.0   51 47 1 2   0 0     0   1   26 25     0 0   15 9   51
1717065 MN Rice 66 school 2723880 659 Independent Districts and Schools Northfield Public School District 272388001180 3 Greenvale Park Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_1 51 0 20   0 1     0   4   47 29     9.0   0.0     16.0   13.0   76 51 0 20   0 1     0   4   47 29     9 0   16 13   76
1717695 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_1 9 0 0   1 0     0   0   8 2     0.0   0.0     5.0   2.0   10 9 0 0   1 0     0   0   8 2     0 0   5 2   10
1718731 MN Wright 86 school 2700123 2687 Independent Districts and Schools Howard Lake-Waverly-Winsted 270012302697 3 Humphrey Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_1 55 0 1   0 0     0   2   33 25     0.0   0.0     7.0   12.0   58 55 0 1   0 0     0   2   33 25     0 0   7 12   58
1714116 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_1 98 0 0   1 0     0   3   47 55     0.0   0.0     33.0   26.0   102 98 0 0   1 0     0   3   47 55     0 0   33 26   102
1715272 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178001321 4 Forest Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 23 24 17   0 2     0   14   37 43     17.0   *     53.0   13.0   80 23 24 17   0 2     0   14   37 43     17     53 13   80
1715556 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 2021   grade_1 27 0 0   21 0     0   11   34 25     *   *     *   8.0   59 27 0 0   21 0     0   11   34 25             8   59
1717179 MN Saint Louis 69 school 2730090 704 Independent Districts and Schools Proctor Public School District 273009001557 4 Bay View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 84 2 3   0 0     0   13   55 47     1.0   0.0     30.0   17.0   102 84 2 3   0 0     0   13   55 47     1 0   30 17   102
1718894 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_1 3 0 0   0 0     0   0   0 3     *   *     *   *   3 3 0 0   0 0     0   0   0 3                 3
1713672 MN Benton 5 school 2732880 47 Independent Districts and Schools Sauk Rapids-Rice Public Schools 273288001433 6 Rice Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 59 1 2   0 0     0   0   35 27     0.0   0.0     17.0   17.0   62 59 1 2   0 0     0   0   35 27     0 0   17 17   62
1714156 MN Crow Wing 18 school 2709750 182 Independent Districts and Schools Crosby-Ironton Public School District 270975000291 6 Cuyuna Range Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 62 0 1   0 0     0   4   39 28     0.0   0.0     22.0   15.0   67 62 0 1   0 0     0   4   39 28     0 0   22 15   67
1715281 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178001323 6 Lakeview Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 18 20 9   0 3     0   14   36 28     10.0   0.0     42.0   13.0   64 18 20 9   0 3     0   14   36 28     10 0   42 13   64
1717186 MN Saint Louis 69 school 2730090 704 Independent Districts and Schools Proctor Public School District 273009001559 6 Pike Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_1 36 0 1   0 0     0   0   17 20     0.0   0.0     3.0   5.0   37 36 0 1   0 0     0   0   17 20     0 0   3 5   37
1718405 MN Chisago 13 school 2700017 2144 Independent Districts and Schools Chisago Lakes School District 270001701672 6 Taylors Falls Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 40 1 3   0 0     0   2   18 28     0.0   0.0     7.0   8.0   46 40 1 3   0 0     0   2   18 28     0 0   7 8   46
1718745 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_1 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1718900 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_1 3 0 0   0 0     0   0   1 2     *   *     *   *   3 3 0 0   0 0     0   0   1 2                 3
1723593 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 2021   grade_1 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1713679 MN Benton 5 school 2732880 47 Independent Districts and Schools Sauk Rapids-Rice Public Schools 273288001431 7 Pleasant View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 89 4 7   0 3     0   18   58 63     0.0   1.0     49.0   22.0   121 89 4 7   0 3     0   18   58 63     0 1   49 22   121
1715673 MN Koochiching 36 school 2715000 361 Independent Districts and Schools International Falls School District 271500000759 7 Falls Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 59 1 1   6 0     0   4   33 38     1.0   0.0     31.0   15.0   71 59 1 1   6 0     0   4   33 38     1 0   31 15   71
1717074 MN Rice 66 school 2723880 659 Independent Districts and Schools Northfield Public School District 272388002841 7 Bridgewater Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_1 70 3 11   0 0     0   1   43 42     7.0   0.0     18.0   22.0   85 70 3 11   0 0     0   1   43 42     7 0   18 22   85
1714122 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609000252 8 Garfield Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2021   grade_1 42 1 1   4 0     0   1   26 23     2.0   *     30.0   12.0   49 42 1 1   4 0     0   1   26 23     2     30 12   49
1715288 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178004548 8 School of Engineering-Arts At Olson Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_1 45 12 3   0 0     0   7   43 24     4.0   0.0     21.0   9.0   67 45 12 3   0 0     0   7   43 24     4 0   21 9   67
1717081 MN Rice 66 school 2723880 659 Independent Districts and Schools Northfield Public School District 272388001184 8 Sibley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_1 70 0 7   0 0     0   1   51 27     5.0   0.0     16.0   13.0   78 70 0 7   0 0     0   1   51 27     5 0   16 13   78
1714128 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609000254 9 Harrison Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2021   grade_1 41 3 4   1 0     0   4   25 28     0.0   1.0     40.0   16.0   53 41 3 4   1 0     0   4   25 28     0 1   40 16   53
1717302 MN Scott 70 school 2730060 719 Independent Districts and Schools Prior Lake-Savage Area Schools 273006003449 9 La Ola Del Lago at Grainwood Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_1 55 1 18   0 0     0   4   49 29     1.0   0.0     6.0   14.0   78 55 1 18   0 0     0   4   49 29     1 0   6 14   78
1713229 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 27 0 1   9 0     0   0   21 16     0.0   0.0     15.0   10.0   37 27 0 1   9 0     0   0   21 16     0 0   15 10   37
1713552 MN Becker 3 school 2710230 22 Independent Districts and Schools Detroit Lakes Public School District 271023000445 10 Rossman Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 76 0 1   13 1     0   1   54 38     0.0   *     32.0   21.0   92 76 0 1   13 1     0   1   54 38     0     32 21   92
1713569 MN Becker 3 school 2712360 23 Independent Districts and Schools Frazee-Vergas Public School District 271236000607 10 Frazee Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 46 3 1   2 0     0   6   31 27     0.0   0.0     23.0   13.0   58 46 3 1   2 0     0   6   31 27     0 0   23 13   58
1713627 MN Beltrami 4 school 2705730 32 Independent Districts and Schools Blackduck Public School District 270573000212 10 Blackduck Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 40 0 0   5 0     0   6   26 25     0.0   2.0     31.0   9.0   51 40 0 0   5 0     0   6   26 25     0 2   31 9   51
1713637 MN Beltrami 4 school 2717010 36 Independent Districts and Schools Kelliher Public School District 271701000786 10 Kelliher Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 10 0 1   9 0     0   0   10 10     0.0   0.0     *   3.0   20 10 0 1   9 0     0   0   10 10     0 0     3   20
1713644 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_1 0 0 0   109 0     0   0   41 68     *   4.0     *   25.0   109 0 0 0   109 0     0   0   41 68       4     25   109
1713687 MN Benton 5 school 2712240 51 Independent Districts and Schools Foley Public School District 271224000590 10 Foley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2021   grade_1 126 0 1   1 1     0   0   59 70     1.0   0.0     26.0   19.0   129 126 0 1   1 1     0   0   59 70     1 0   26 19   129
1713699 MN Blue Earth 7 school 2733480 75 Independent Districts and Schools St. Clair Public School District 273348001477 10 St. Clair Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 47 0 0   0 0     0   0   24 23     0.0   0.0     8.0   11.0   47 47 0 0   0 0     0   0   24 23     0 0   8 11   47
1713709 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878000877 10 Kennedy Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 38 15 11   0 1     0   4   36 33     6.0   1.0     34.0   11.0   69 38 15 11   0 1     0   4   36 33     6 1   34 11   69
1713781 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_1 6 0 0   0 0     0   0   5 1     *   *     *   *   6 6 0 0   0 0     0   0   5 1                 6
1713791 MN Brown 8 school 2733210 84 Independent Districts and Schools Sleepy Eye Public School District 273321001450 10 Sleepy Eye Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 27 0 14   0 0     0   0   19 22     2.0   1.0     16.0   7.0   41 27 0 14   0 0     0   0   19 22     2 1   16 7   41
1713846 MN Carlton 9 school 2709690 95 Independent Districts and Schools Cromwell-Wright Public Schools 270969000410 10 Cromwell-Wright Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 24 0 1   0 0     0   0   14 11     0.0   0.0     8.0   4.0   25 24 0 1   0 0     0   0   14 11     0 0   8 4   25
1713978 MN Cass 11 school 2702910 113 Independent Districts and Schools Walker-Hackensack-Akeley School District 270291001736 10 W.H.A. Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 29 0 3   13 1     0   6   21 31     *   1.0     26.0   10.0   52 29 0 3   13 1     0   6   21 31       1   26 10   52
1713987 MN Cass 11 school 2708070 115 Independent Districts and Schools Cass Lake-Bena Public Schools 270807000330 10 Cass Lake-Bena Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_1 2 0 2   43 0     0   44   53 38     0.0   0.0     70.0   21.0   91 2 0 2   43 0     0   44   53 38     0 0   70 21   91
1713994 MN Cass 11 school 2728350 116 Independent Districts and Schools Pillager Public School District 272835001253 10 Pillager Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_1 75 1 2   0 0     0   1   40 39     0.0   0.0     38.0   13.0   79 75 1 2   0 0     0   1   40 39     0 0   38 13   79
1714002 MN Cass 11 school 2730870 118 Independent Districts and Schools Northland Community Schools 273087001307 10 Northland Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 13 0 0   13 0     0   0   17 9     0.0   0.0     17.0   5.0   26 13 0 0   13 0     0   0   17 9     0 0   17 5   26
1714009 MN Chippewa 12 school 2721320 129 Independent Districts and Schools Montevideo Public School District 272132001073 10 Ramsey Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 03 2021   grade_1 67 0 24   1 0     0   3   48 47     18.0   1.0     42.0   16.0   95 67 0 24   1 0     0   3   48 47     18 1   42 16   95
1714026 MN Chisago 13 school 2732550 139 Independent Districts and Schools Rush City Public School District 273255001405 10 C.E. Jacobson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 47 0 2   1 2     0   2   32 22     0.0   0.0     17.0   8.0   54 47 0 2   1 2     0   2   32 22     0 0   17 8   54
1714034 MN Clay 14 school 2703660 146 Independent Districts and Schools Barnesville Public School District 270366000169 10 Barnesville Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2021   grade_1 64 1 2   0 0     0   1   32 36     0.0   0.0     15.0   10.0   68 64 1 2   0 0     0   1   32 36     0 0   15 10   68

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