Data source: Big Local News · About: Big Local

978 rows where grade = "grade_2", state = "MN" and year = 2021 sorted by black_int

View and edit SQL

year

  • 2021 · 978

grade

  • grade_2 · 978
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
1713222 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_2 9 0 1   1 0     0   1   4 8     0.0   0.0     8.0   2.0   12 9 0 1   1 0     0   1   4 8     0 0   8 2   12
1713507 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000233 784 Cedar Creek Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 87 0 4   0 2     0   3   44 52     4.0   2.0     23.0   14.0   96 87 0 4   0 2     0   3   44 52     4 2   23 14   96
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
1713570 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_2 45 0 2   5 0     0   7   29 30     0.0   1.0     26.0   15.0   59 45 0 2   5 0     0   7   29 30     0 1   26 15   59
1713578 MN Becker 3 school 2728960 25 Independent Districts and Schools Pine Point Public School District 272896000034 70 Pine Point Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_2 0 0 1   12 0     0   0   4 9     0.0   0.0     11.0   4.0   13 0 0 1   12 0     0   0   4 9     0 0   11 4   13
1713591 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 PK 03 2021   grade_2 59 0 3   10 0     0   4   34 42     0.0   0.0     24.0   *   76 59 0 3   10 0     0   4   34 42     0 0   24     76
1713606 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444000191 50 Central Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2021   grade_2 16 0 1   8 0     0   4   16 13     0.0   3.0     *   10.0   29 16 0 1   8 0     0   4   16 13     0 3     10   29
1713616 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444000197 80 Solway Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2021   grade_2 20 0 1   3 0     0   1   15 10     0.0   1.0     *   *   25 20 0 1   3 0     0   1   15 10     0 1         25
1713621 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 03 2021   grade_2 51 0 0   8 1     0   7   29 38     0.0   2.0     22.0   18.0   67 51 0 0   8 1     0   7   29 38     0 2   22 18   67
1713628 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_2 42 0 1   7 0     0   5   26 29     0.0   *     22.0   5.0   55 42 0 1   7 0     0   5   26 29     0     22 5   55
1713638 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_2 7 0 1   11 0     0   0   13 6     0.0   0.0     14.0   4.0   19 7 0 1   11 0     0   0   13 6     0 0   14 4   19
1713645 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051001302 10 Red Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_2 0 0 0   111 0     0   0   57 54     0.0   7.0     *   22.0   111 0 0 0   111 0     0   0   57 54     0 7     22   111
1713655 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051001301 20 Ponemah Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_2 0 0 0   19 0     0   0   12 7     0.0   4.0     *   2.0   19 0 0 0   19 0     0   0   12 7     0 4     2   19
1713673 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_2 63 0 4   0 0     0   2   35 34     0.0   1.0     20.0   21.0   69 63 0 4   0 0     0   2   35 34     0 1   20 21   69
1713700 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_2 40 0 0   0 0     0   1   23 18     0.0   0.0     10.0   6.0   41 40 0 0   0 0     0   1   23 18     0 0   10 6   41
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
1713801 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_2 43 0 4   0 0     0   0   22 25     0.0   0.0     20.0   10.0   47 43 0 4   0 0     0   0   22 25     0 0   20 10   47
1713818 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_2 34 0 2   1 0     0   2   22 17     0.0   0.0     14.0   11.0   39 34 0 2   1 0     0   2   22 17     0 0   14 11   39
1713827 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_2 19 0 0   1 1     0   3   10 14     0.0   0.0     8.0   4.0   24 19 0 0   1 1     0   3   10 14     0 0   8 4   24
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
1713840 MN Carlton 9 school 2709420 94 Independent Districts and Schools Cloquet Public School District 270942000384 105 Washington Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_2 70 0 4   10 1     0   21   55 51     0.0   0.0     43.0   18.0   106 70 0 4   10 1     0   21   55 51     0 0   43 18   106
1713847 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_2 14 0 0   1 0     0   0   8 7     0.0   0.0     5.0   3.0   15 14 0 0   1 0     0   0   8 7     0 0   5 3   15
1713856 MN Carlton 9 school 2721450 97 Independent Districts and Schools Moose Lake Public School District 272145001093 20 Moose Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 30 0 1   1 0     0   1   18 15     0.0   2.0     *   8.0   33 30 0 1   1 0     0   1   18 15     0 2     8   33
1713874 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_2 16 0 0   0 0     0   2   6 12     0.0   0.0     9.0   1.0   18 16 0 0   0 0     0   2   6 12     0 0   9 1   18
1713883 MN Carver 10 school 2723910 108 Independent Districts and Schools Central Public School District 272391001187 40 Central Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 52 0 4   0 0     0   3   36 23     3.0   1.0     12.0   18.0   59 52 0 4   0 0     0   3   36 23     3 1   12 18   59
1713897 MN Carver 10 school 2741460 110 Independent Districts and Schools Waconia Public School District 274146003065 120 Bayview Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 72 0 5   1 0     0   4   39 43     3.0   0.0     6.0   25.0   82 72 0 5   1 0     0   4   39 43     3 0   6 25   82
1713904 MN Carver 10 school 2741460 110 Independent Districts and Schools Waconia Public School District 274146004916 130 Laketown Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 73 0 1   0 0     0   3   36 41     0.0   0.0     0.0   16.0   77 73 0 1   0 0     0   3   36 41     0 0   0 16   77
1713919 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819004598 501 La Academia Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 59 0 25   1 1     0   3   45 44     15.0   0.0     21.0   6.0   89 59 0 25   1 1     0   3   45 44     15 0   21 6   89
1713940 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819000346 507 East Union Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 13 0 1   0 0     0   0   11 3     0.0   0.0     3.0   1.0   14 13 0 1   0 0     0   0   11 3     0 0   3 1   14
1713979 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_2 25 0 1   15 0     0   6   28 19     0.0   3.0     23.0   10.0   47 25 0 1   15 0     0   6   28 19     0 3   23 10   47
1713988 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_2 2 0 4   64 0     0   21   41 50     0.0   0.0     59.0   18.0   91 2 0 4   64 0     0   21   41 50     0 0   59 18   91
1714003 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_2 13 0 0   5 0     0   0   8 10     0.0   0.0     14.0   3.0   18 13 0 0   5 0     0   0   8 10     0 0   14 3   18
1714019 MN Chisago 13 school 2723820 138 Independent Districts and Schools North Branch Public Schools 272382003514 45 Sunrise River Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_2 123 0 5   0 5     0   11   80 64     4.0   0.0     24.0   21.0   144 123 0 5   0 5     0   11   80 64     4 0   24 21   144
1714035 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_2 70 0 1   0 0     0   2   42 31     0.0   0.0     9.0   19.0   73 70 0 1   0 0     0   2   42 31     0 0   9 19   73
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
1714085 MN Clearwater 15 school 2703570 162 Independent Districts and Schools Bagley Public School District 270357000164 10 Bagley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 41 0 4   9 0     0   6   25 35     0.0   2.0     28.0   14.0   60 41 0 4   9 0     0   6   25 35     0 2   28 14   60
1714094 MN Cook 16 school 2713110 166 Independent Districts and Schools Cook County Public Schools 271311000658 60 Sawtooth Mountain Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 16 0 0   2 0     0   2   8 12     0.0   0.0     8.0   1.0   20 16 0 0   2 0     0   2   8 12     0 0   8 1   20
1714102 MN Cottonwood 17 school 2723010 173 Independent Districts and Schools Mountain Lake Public Schools 272301001134 10 Mountain Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 15 0 10   0 3     0   4   20 12     7.0   0.0     *   7.0   32 15 0 10   0 3     0   4   20 12     7 0     7   32
1714123 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_2 63 0 1   2 1     0   2   33 36     0.0   0.0     35.0   19.0   69 63 0 1   2 1     0   2   33 36     0 0   35 19   69
1714135 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609000256 11 Lowell Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2021   grade_2 68 0 2   0 0     0   3   39 34     0.0   0.0     29.0   16.0   73 68 0 2   0 0     0   3   39 34     0 0   29 16   73
1714150 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609000257 15 Nisswa Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_2 40 0 0   0 0     0   1   21 20     0.0   0.0     *   *   41 40 0 0   0 0     0   1   21 20     0 0         41
1714157 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_2 71 0 0   1 0     0   5   35 42     0.0   1.0     26.0   10.0   77 71 0 0   1 0     0   5   35 42     0 1   26 10   77
1714287 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778000815 591 Kennedy Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 62 0 4   0 2     0   5   35 38     2.0   0.0     11.0   13.0   73 62 0 4   0 2     0   5   35 38     2 0   11 13   73
1714518 MN Dakota 19 school 2715030 199 Independent Districts and Schools Inver Grove Heights Schools 271503003184 574 Atheneum Elementary Elementary School (Grades PK-6) Regular School No Elementary 02 05 2021   grade_2 6 0 3   0 3     0   2   11 3     0.0   0.0     4.0   1.0   14 6 0 3   0 3     0   2   11 3     0 0   4 1   14
1714556 MN Dakota 19 school 2713530 200 Independent Districts and Schools Hastings Public School District 271353000696 610 Pinecrest Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2021   grade_2 67 0 6   0 0     0   7   35 45     4.0   *     11.0   5.0   80 67 0 6   0 0     0   7   35 45     4     11 5   80
1714569 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_2 29 0 1   0 0     0   0   11 19     0.0   0.0     14.0   4.0   30 29 0 1   0 0     0   0   11 19     0 0   14 4   30
1714583 MN Douglas 21 school 2703060 206 Independent Districts and Schools Alexandria Public School District 270306000082 110 Carlos Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 18 0 1   0 0     0   1   11 9     0.0   0.0     5.0   4.0   20 18 0 1   0 0     0   1   11 9     0 0   5 4   20
1714590 MN Douglas 21 school 2703060 206 Independent Districts and Schools Alexandria Public School District 270306000084 120 Garfield Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 22 0 0   0 0     0   0   13 9     0.0   0.0     6.0   3.0   22 22 0 0   0 0     0   0   13 9     0 0   6 3   22
1714597 MN Douglas 21 school 2703060 206 Independent Districts and Schools Alexandria Public School District 270306000086 130 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 71 0 5   0 3     0   5   43 41     4.0   1.0     16.0   14.0   84 71 0 5   0 3     0   5   43 41     4 1   16 14   84
1714604 MN Douglas 21 school 2703060 206 Independent Districts and Schools Alexandria Public School District 270306000087 140 Miltona Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 23 0 0   0 0     0   1   8 16     0.0   0.0     5.0   4.0   24 23 0 0   0 0     0   1   8 16     0 0   5 4   24
1714611 MN Douglas 21 school 2703060 206 Independent Districts and Schools Alexandria Public School District 270306000088 150 Woodland Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 58 0 7   0 0     0   3   35 33     2.0   3.0     28.0   9.0   68 58 0 7   0 0     0   3   35 33     2 3   28 9   68
1714618 MN Douglas 21 school 2703060 206 Independent Districts and Schools Alexandria Public School District 270306002229 160 Voyager Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 49 0 5   0 0     0   1   26 29     0.0   0.0     18.0   11.0   55 49 0 5   0 0     0   1   26 29     0 0   18 11   55
1714637 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_2 53 0 2   0 0     0   0   28 27     0.0   0.0     10.0   6.0   55 53 0 2   0 0     0   0   28 27     0 0   10 6   55
1714646 MN Fillmore 23 school 2717910 229 Independent Districts and Schools Lanesboro Public School District 271791000823 10 Lanesboro Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 17 0 0   0 0     0   0   8 9     0.0   0.0     4.0   2.0   17 17 0 0   0 0     0   0   8 9     0 0   4 2   17
1714655 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_2 28 0 0   0 0     0   0   14 14     0.0   0.0     9.0   2.0   28 28 0 0   0 0     0   0   14 14     0 0   9 2   28
1714664 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_2 41 0 0   0 0     0   0   28 13     0.0   0.0     *   4.0   41 41 0 0   0 0     0   0   28 13     0 0     4   41
1714713 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_2 60 0 1   0 1     0   2   38 26     1.0   0.0     13.0   10.0   64 60 0 1   0 1     0   2   38 26     1 0   13 10   64
1714721 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_2 53 0 4   0 0     0   1   32 26     4.0   0.0     5.0   3.0   58 53 0 4   0 0     0   1   32 26     4 0   5 3   58
1714760 MN Goodhue 25 school 2730480 256 Independent Districts and Schools Red Wing Public School District 273048001297 541 Sunnyside Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2021   grade_2 26 0 0   1 2     0   2   13 18     1.0   0.0     13.0   8.0   31 26 0 0   1 2     0   2   13 18     1 0   13 8   31
1714770 MN Grant 26 school 2703300 261 Independent Districts and Schools Ashby Public School District 270330000136 10 Ashby Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 31 0 0   0 0     0   0   20 11     0.0   0.0     19.0   5.0   31 31 0 0   0 0     0   0   20 11     0 0   19 5   31
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
1715082 MN Hennepin 27 school 2725080 278 Independent Districts and Schools Orono Public School District 272508001200 661 Schumann Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2021   grade_2 173 0 8   0 1     0   11   107 86     5.0   2.0     9.0   18.0   193 173 0 8   0 1     0   11   107 86     5 2   9 18   193
1715264 MN Hennepin 27 school 2731750 280 Independent Districts and Schools Richfield Public School District 273175004212 705 Richfield Dual Language School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 19 0 54   0 0     0   1   36 38     38.0   5.0     43.0   *   74 19 0 54   0 0     0   1   36 38     38 5   43     74
1715475 MN Houston 28 school 2714280 294 Independent Districts and Schools Houston Public School District 271428000748 10 Houston Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 27 0 0   0 0     0   0   13 14     0.0   1.0     14.0   5.0   27 27 0 0   0 0     0   0   13 14     0 1   14 5   27
1715484 MN Houston 28 school 2733300 297 Independent Districts and Schools Spring Grove School District 273330001458 10 Spring Grove Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 27 0 1   0 0     0   2   13 17     0.0   0.0     6.0   1.0   30 27 0 1   0 0     0   2   13 17     0 0   6 1   30
1715493 MN Houston 28 school 2707380 299 Independent Districts and Schools Caledonia Public School District 270738000309 10 Caledonia Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 42 0 0   0 0     0   3   28 17     0.0   0.0     8.0   5.0   45 42 0 0   0 0     0   3   28 17     0 0   8 5   45
1715509 MN Hubbard 29 school 2717940 306 Independent Districts and Schools Laporte Public School District 271794000825 10 Laporte Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 22 0 0   6 0     0   0   10 18     0.0   0.0     15.0   5.0   28 22 0 0   6 0     0   0   10 18     0 0   15 5   28
1715518 MN Hubbard 29 school 2723370 308 Independent Districts and Schools Nevis Public School District 272337001139 10 Nevis Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 37 0 2   1 0     0   3   19 24     0.0   0.0     18.0   2.0   43 37 0 2   1 0     0   3   19 24     0 0   18 2   43
1715530 MN Hubbard 29 school 2728080 309 Independent Districts and Schools Park Rapids Public School District 272808001233 30 Park Rapids Area Century Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_2 100 0 9   0 0     0   9   64 54     3.0   0.0     58.0   17.0   118 100 0 9   0 0     0   9   64 54     3 0   58 17   118
1715547 MN Itasca 31 school 2709480 316 Independent Districts and Schools Greenway Public School District 270948000394 110 Vandyke Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_2 56 0 1   2 0     0   9   33 35     0.0   3.0     33.0   15.0   68 56 0 1   2 0     0   9   33 35     0 3   33 15   68
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
1715625 MN Kanabec 33 school 2723970 333 Independent Districts and Schools Ogilvie Public School District 272397001188 10 Ogilvie Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 30 0 0   0 0     0   0   14 16     0.0   0.0     15.0   6.0   30 30 0 0   0 0     0   0   14 16     0 0   15 6   30
1715665 MN Kittson 35 school 2717880 356 Independent Districts and Schools Lancaster Public School District 271788000821 10 Lancaster Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 16 0 0   0 0     0   0   10 6     0.0   0.0     5.0   5.0   16 16 0 0   0 0     0   0   10 6     0 0   5 5   16
1715682 MN Koochiching 36 school 2718270 362 Independent Districts and Schools Littlefork-Big Falls School Dist. 271827000847 20 Littlefork-Big Falls Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 15 0 0   0 0     0   4   12 7     0.0   0.0     8.0   0.0   19 15 0 0   0 0     0   4   12 7     0 0   8 0   19
1715691 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 2021   grade_2 7 0 0   4 0     0   0   5 6     0.0   0.0     8.0   0.0   11 7 0 0   4 0     0   0   5 6     0 0   8 0   11
1715700 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 2021   grade_2 11 0 0   0 0     0   0   5 6     0.0   0.0     5.0   2.0   11 11 0 0   0 0     0   0   5 6     0 0   5 2   11
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
1715718 MN Lake 38 school 2740740 381 Independent Districts and Schools Lake Superior Public School Dist. 274074001698 30 William Kelley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 16 0 0   0 0     0   0   10 6     0.0   *     4.0   1.0   16 16 0 0   0 0     0   0   10 6     0     4 1   16
1715727 MN Lake 38 school 2740740 381 Independent Districts and Schools Lake Superior Public School Dist. 274074001699 40 Minnehaha Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 70 0 0   0 0     0   0   35 35     0.0   *     18.0   17.0   70 70 0 0   0 0     0   0   35 35     0     18 17   70
1715745 MN Lesueur 40 school 2709330 391 Independent Districts and Schools Cleveland Public School District 270933000374 10 Cleveland Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 35 0 2   0 0     0   0   18 19     0.0   0.0     5.0   3.0   37 35 0 2   0 0     0   0   18 19     0 0   5 3   37
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
1715764 MN Lincoln 41 school 2715540 403 Independent Districts and Schools Ivanhoe Public School District 271554004539 10 Lincoln Elementary - Ivanhoe Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 14 0 0   0 1     0   0   11 4     1.0   0.0     2.0   1.0   15 14 0 0   0 1     0   0   11 4     1 0   2 1   15
1715773 MN Lincoln 41 school 2717460 404 Independent Districts and Schools Lake Benton Public School District 271746000801 10 Lake Benton Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 15 0 0   0 0     0   0   6 9     0.0   0.0     *   0.0   15 15 0 0   0 0     0   0   6 9     0 0     0   15
1715793 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_2 27 0 2   0 0     0   1   17 13     1.0   0.0     6.0   4.0   30 27 0 2   0 0     0   1   17 13     1 0   6 4   30
1715802 MN Lyon 42 school 2718390 415 Independent Districts and Schools Lynd Public School District 271839000856 10 Lynd Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 17 0 9   0 0     0   2   18 10     5.0   0.0     15.0   5.0   28 17 0 9   0 0     0   2   18 10     5 0   15 5   28
1715806 MN Mcleod 43 school 2714970 423 Independent Districts and Schools Hutchinson Public School District 271497000754 10 Hutchinson Park Elementary Elementary School (Grades PK-6) Regular School No Elementary 02 05 2021   grade_2 158 0 21   0 1     0   13   96 97     17.0   1.0     46.0   30.0   193 158 0 21   0 1     0   13   96 97     17 1   46 30   193
1715818 MN Mcleod 43 school 2702640 424 Independent Districts and Schools Lester Prairie Public School Dist. 270264000048 10 Lester Prairie Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 31 0 8   0 0     0   1   20 20     6.0   0.0     9.0   5.0   40 31 0 8   0 0     0   1   20 20     6 0   9 5   40
1715828 MN Mahnomen 44 school 2718660 432 Independent Districts and Schools Mahnomen Public School District 271866000865 10 Mahnomen Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 3 0 1   34 0     0   8   14 32     0.0   0.0     33.0   12.0   46 3 0 1   34 0     0   8   14 32     0 0   33 12   46
1715842 MN Becker 3 school 2742120 435 Independent Districts and Schools Waubun-Ogema-White Earth Public Sch 274212001754 20 Ogema Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2021   grade_2 10 0 0   36 0     0   1   26 21     0.0   2.0     29.0   3.0   47 10 0 0   36 0     0   1   26 21     0 2   29 3   47
1715852 MN Marshall 45 school 2723550 441 Independent Districts and Schools Marshall County Central Schools 272355001159 30 Viking Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2021   grade_2 27 0 0   0 0     0   1   18 10     0.0   0.0     10.0   4.0   28 27 0 0   0 0     0   1   18 10     0 0   10 4   28
1715856 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_2 11 0 1   0 0     0   1   7 6     0.0   0.0     6.0   3.0   13 11 0 1   0 0     0   1   7 6     0 0   6 3   13
1715866 MN Martin 46 school 2740680 458 Independent Districts and Schools Truman Public School District 274068001692 10 Truman Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 14 0 1   0 1     0   2   7 11     0.0   0.0     14.0   9.0   18 14 0 1   0 1     0   2   7 11     0 0   14 9   18
1715874 MN Stearns 73 school 2711190 463 Independent Districts and Schools Eden Valley-Watkins School District 271119000501 10 Eden Valley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2021   grade_2 60 0 3   0 0     0   1   32 32     1.0   0.0     22.0   10.0   64 60 0 3   0 0     0   1   32 32     1 0   22 10   64
1715892 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_2 60 0 2   1 0     0   2   37 28     1.0   0.0     12.0   9.0   65 60 0 2   1 0     0   2   37 28     1 0   12 9   65
1715907 MN Mille Lacs 48 school 2715510 473 Independent Districts and Schools Isle Public School District 271551000769 10 Isle Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 16 0 1   4 0     0   2   15 8     0.0   1.0     16.0   4.0   23 16 0 1   4 0     0   2   15 8     0 1   16 4   23
1715925 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools Onamia Public School District 272505001195 10 Onamia Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2021   grade_2 8 0 0   10 0     0   2   7 13     0.0   0.0     9.0   5.0   20 8 0 0   10 0     0   2   7 13     0 0   9 5   20
1715944 MN Morrison 49 school 2718240 482 Independent Districts and Schools Little Falls Public School District 271824000962 130 Knight Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 18 0 0   1 0     0   0   12 7     0.0   0.0     9.0   3.0   19 18 0 0   1 0     0   0   12 7     0 0   9 3   19
1715960 MN Morrison 49 school 2732520 485 Independent Districts and Schools Royalton Public School District 273252001403 10 Royalton Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 46 0 3   0 0     0   3   26 26     0.0   0.0     12.0   5.0   52 46 0 3   0 0     0   3   26 26     0 0   12 5   52

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