Data source: Big Local News · About: Big Local

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

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
1713212 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_2 48 2 1   0 0     0   4   23 32     0.0   0.0     30.0   10.0   55 48 2 1   0 0     0   4   23 32     0 0   30 10   55
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
1713230 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_2 23 1 0   4 0     0   1   18 11     0.0   0.0     10.0   8.0   29 23 1 0   4 0     0   1   18 11     0 0   10 8   29
1713239 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 31 16 6   0 14     0   12   46 33     12.0   2.0     42.0   15.0   79 31 16 6   0 14     0   12   46 33     12 2   42 15   79
1713246 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000101 402 Crooked Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 52 7 5   0 1     0   6   37 34     *   2.0     21.0   14.0   71 52 7 5   0 1     0   6   37 34       2   21 14   71
1713253 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000105 403 Franklin Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 28 11 4   2 6     1   13   30 35     8.0   0.0     36.0   13.0   65 28 11 4   2 6     1   13   30 35     8 0   36 13   65
1713260 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000106 404 Hamilton Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 32 15 9   1 8     0   10   36 39     16.0   1.0     42.0   20.0   75 32 15 9   1 8     0   10   36 39     16 1   42 20   75
1713267 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary - Biomedical, Health Sciences and Engineering Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 44 13 5   0 10     0   13   46 39     12.0   0.0     37.0   18.0   85 44 13 5   0 10     0   13   46 39     12 0   37 18   85
1713274 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000110 406 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 48 14 4   1 10     0   11   44 44     12.0   5.0     28.0   20.0   88 48 14 4   1 10     0   11   44 44     12 5   28 20   88
1713281 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000111 407 Johnsville Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 67 16 7   0 9     0   12   64 47     12.0   0.0     41.0   27.0   111 67 16 7   0 9     0   12   64 47     12 0   41 27   111
1713288 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000112 408 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 45 7 3   0 2     1   6   34 30     8.0   2.0     31.0   20.0   64 45 7 3   0 2     1   6   34 30     8 2   31 20   64
1713295 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000113 410 Madison Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 43 12 6   0 6     0   3   37 33     11.0   1.0     32.0   14.0   70 43 12 6   0 6     0   3   37 33     11 1   32 14   70
1713302 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 92 1 1   0 4     0   5   47 56     *   0.0     15.0   11.0   103 92 1 1   0 4     0   5   47 56       0   15 11   103
1713309 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000115 412 Mississippi Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 39 8 4   0 7     0   11   31 38     9.0   1.0     25.0   16.0   69 39 8 4   0 7     0   11   31 38     9 1   25 16   69
1713316 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000116 413 Monroe Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 30 13 7   0 31     0   7   36 52     31.0   1.0     37.0   11.0   88 30 13 7   0 31     0   7   36 52     31 1   37 11   88
1713323 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000118 414 Morris Bye Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 38 16 5   0 9     0   5   30 43     10.0   7.0     33.0   8.0   73 38 16 5   0 9     0   5   30 43     10 7   33 8   73
1713330 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000123 417 Sand Creek Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 54 19 6   0 5     0   16   44 56     12.0   1.0     33.0   20.0   100 54 19 6   0 5     0   16   44 56     12 1   33 20   100
1713338 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 University Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 41 29 10   1 4     0   19   55 49     17.0   3.0     50.0   22.0   104 41 29 10   1 4     0   19   55 49     17 3   50 22   104
1713345 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000128 420 Wilson Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 48 7 7   0 5     0   10   40 37     7.0   3.0     31.0   10.0   77 48 7 7   0 5     0   10   40 37     7 3   31 10   77
1713353 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000104 421 Evergreen Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 6 28 7   0 31     0   8   30 50     33.0   5.0     59.0   8.0   80 6 28 7   0 31     0   8   30 50     33 5   59 8   80
1713360 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000103 422 Eisenhower Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 39 8 13   0 4     0   13   32 45     13.0   3.0     33.0   17.0   77 39 8 13   0 4     0   13   32 45     13 3   33 17   77
1713367 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000120 423 Ramsey Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 62 33 7   0 3     1   9   58 57     17.0   4.0     42.0   18.0   115 62 33 7   0 3     1   9   58 57     17 4   42 18   115
1713374 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000102 424 Dayton Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 57 7 7   2 3     0   5   39 42     9.0   0.0     19.0   12.0   81 57 7 7   2 3     0   5   39 42     9 0   19 12   81
1713381 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002193 425 Oxbow Creek Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 120 16 7   1 17     0   14   89 86     17.0   3.0     36.0   23.0   175 120 16 7   1 17     0   14   89 86     17 3   36 23   175
1713388 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002203 426 Andover Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 142 13 7   0 8     0   17   101 86     8.0   3.0     30.0   33.0   187 142 13 7   0 8     0   17   101 86     8 3   30 33   187
1713395 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318003058 427 Rum River Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 103 3 4   1 8     0   6   68 57     9.0   1.0     14.0   20.0   125 103 3 4   1 8     0   6   68 57     9 1   14 20   125
1713402 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318004406 430 Champlin/Brooklyn Park Academy for Math and Environmental Science Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 71 15 9   0 12     0   10   63 54     14.0   1.0     38.0   18.0   117 71 15 9   0 12     0   10   63 54     14 1   38 18   117
1713409 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318005272 431 Sunrise Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 129 27 4   0 17     0   12   97 92     17.0   0.0     24.0   26.0   189 129 27 4   0 17     0   12   97 92     17 0   24 26   189
1713416 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318005266 432 Brookside Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 87 6 4   1 4     0   4   56 50     10.0   0.0     16.0   19.0   106 87 6 4   1 4     0   4   56 50     10 0   16 19   106
1713423 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810000332 510 Centennial Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 74 16 3   0 5     0   2   50 50     8.0   0.0     20.0   15.0   100 74 16 3   0 5     0   2   50 50     8 0   20 15   100
1713430 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810000335 511 Centerville Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 76 2 5   0 2     0   2   40 47     2.0   0.0     4.0   6.0   87 76 2 5   0 2     0   2   40 47     2 0   4 6   87
1713437 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810000336 512 Golden Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 44 5 6   1 11     0   6   33 40     14.0   0.0     20.0   17.0   73 44 5 6   1 11     0   6   33 40     14 0   20 17   73
1713444 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810000022 513 Rice Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 75 1 3   0 3     0   4   52 34     1.0   0.0     9.0   15.0   86 75 1 3   0 3     0   4   52 34     1 0   9 15   86
1713451 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810003172 515 Blue Heron Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 95 7 2   0 10     1   12   64 63     10.0   0.0     18.0   17.0   127 95 7 2   0 10     1   12   64 63     10 0   18 17   127
1713460 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000398 515 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 15 22 19   1 5     0   6   40 28     36.0   0.0     52.0   7.0   68 15 22 19   1 5     0   6   40 28     36 0   52 7   68
1713469 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000400 517 North Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 13 18 8   1 1     0   4   21 24     14.0   3.0     36.0   6.0   45 13 18 8   1 1     0   4   21 24     14 3   36 6   45
1713478 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000402 520 Valley View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 10 16 39   3 0     0   5   44 29     42.0   2.0     60.0   5.0   73 10 16 39   3 0     0   5   44 29     42 2   60 5   73
1713488 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000612 546 Hayes Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_2 27 35 17   0 7     0   10   43 53     22.0   1.0     60.0   14.0   96 27 35 17   0 7     0   10   43 53     22 1   60 14   96
1713494 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000614 550 Stevenson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_2 21 33 20   1 6     0   11   43 49     19.0   0.0     58.0   8.0   92 21 33 20   1 6     0   11   43 49     19 0   58 8   92
1713500 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000230 782 St. Francis Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 82 1 3   0 2     0   10   56 42     2.0   0.0     29.0   18.0   98 82 1 3   0 2     0   10   56 42     2 0   29 18   98
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
1713514 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000258 848 East Bethel Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 57 1 6   1 3     0   5   43 30     7.0   1.0     15.0   14.0   73 57 1 6   1 3     0   5   43 30     7 1   15 14   73
1713521 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333001461 772 Northpoint Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2021   grade_2 63 9 3   0 15     0   8   59 39     *   0.0     *   20.0   98 63 9 3   0 15     0   8   59 39       0     20   98
1713527 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 04 2021   grade_2 53 8 45   0 3     0   10   47 72     21.0   *     26.0   *   119 53 8 45   0 3     0   10   47 72     21     26     119
1713534 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333001462 775 Park Terrace Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_2 53 19 9   2 11     1   12   52 55     25.0   *     64.0   22.0   107 53 19 9   2 11     1   12   52 55     25     64 22   107
1713540 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333005028 776 Centerview Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2021   grade_2 79 20 21   0 19     0   9   72 76     30.0   0.0     60.0   19.0   148 79 20 21   0 19     0   9   72 76     30 0   60 19   148
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
1713553 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_2 80 1 1   15 2     0   2   56 45     0.0   *     29.0   20.0   101 80 1 1   15 2     0   2   56 45     0     29 20   101
1713562 MN Becker 3 school 2710230 22 Independent Districts and Schools Detroit Lakes Public School District 271023002268 60 Roosevelt Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 65 2 2   30 2     0   1   52 50     2.0   *     37.0   23.0   102 65 2 2   30 2     0   1   52 50     2     37 23   102
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
1713600 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444000196 40 J.W. Smith Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2021   grade_2 15 1 4   28 0     0   9   29 28     0.0   3.0     37.0   15.0   57 15 1 4   28 0     0   9   29 28     0 3   37 15   57
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
1713611 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444000192 60 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2021   grade_2 49 2 1   27 0     0   6   41 44     0.0   1.0     37.0   14.0   85 49 2 1   27 0     0   6   41 44     0 1   37 14   85
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
1713665 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_2 122 7 11   0 0     0   8   73 75     1.0   1.0     38.0   20.0   148 122 7 11   0 0     0   8   73 75     1 1   38 20   148
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
1713680 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_2 95 2 11   1 2     0   10   64 57     3.0   1.0     42.0   26.0   121 95 2 11   1 2     0   10   64 57     3 1   42 26   121
1713688 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_2 147 2 0   1 0     0   5   84 71     0.0   0.0     43.0   25.0   155 147 2 0   1 0     0   5   84 71     0 0   43 25   155
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
1713710 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_2 30 16 5   0 3     0   7   39 22     8.0   1.0     31.0   14.0   61 30 16 5   0 3     0   7   39 22     8 1   31 14   61
1713717 MN Nicollet 52 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878000875 20 Hoover Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 58 10 5   0 2     0   5   43 37     10.0   0.0     22.0   11.0   80 58 10 5   0 2     0   5   43 37     10 0   22 11   80
1713724 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 2021   grade_2 22 3 4   1 2     0   2   18 16     2.0   0.0     12.0   6.0   34 22 3 4   1 2     0   2   18 16     2 0   12 6   34
1713731 MN Nicollet 52 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878000881 40 Monroe Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 57 10 2   0 0     0   6   35 40     9.0   0.0     24.0   4.0   75 57 10 2   0 0     0   6   35 40     9 0   24 4   75
1713738 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878000883 50 Roosevelt Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 40 11 4   0 1     0   2   35 23     6.0   0.0     18.0   16.0   58 40 11 4   0 1     0   2   35 23     6 0   18 16   58
1713745 MN Nicollet 52 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878002977 60 Bridges Community Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 36 2 0   0 1     0   0   22 17     3.0   0.0     5.0   *   39 36 2 0   0 1     0   0   22 17     3 0   5     39
1713752 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878004388 70 Rosa Parks Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 48 24 4   0 1     0   4   41 40     16.0   1.0     42.0   15.0   81 48 24 4   0 1     0   4   41 40     16 1   42 15   81
1713759 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878000884 80 Washington Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 50 12 5   0 1     0   4   41 31     7.0   1.0     28.0   10.0   72 50 12 5   0 1     0   4   41 31     7 1   28 10   72
1713767 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878000873 90 Franklin Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 50 18 8   0 0     0   6   45 37     5.0   2.0     35.0   17.0   82 50 18 8   0 0     0   6   45 37     5 2   35 17   82
1713774 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 2021   grade_2 51 1 2   0 1     0   5   33 27     1.0   0.0     14.0   10.0   60 51 1 2   0 1     0   5   33 27     1 0   14 10   60
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
1713792 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_2 24 1 10   0 0     0   0   16 19     4.0   1.0     16.0   7.0   35 24 1 10   0 0     0   0   16 19     4 1   16 7   35
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
1713808 MN Brown 8 school 2723490 88 Independent Districts and Schools New Ulm Public School District 272349001150 20 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_2 142 1 10   0 0     0   3   83 73     3.0   0.0     51.0   22.0   156 142 1 10   0 0     0   3   83 73     3 0   51 22   156
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
1713865 MN Carlton 9 school 2738880 99 Independent Districts and Schools Esko Public School District 273888001683 30 Winterquist Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 93 1 2   0 0     0   6   48 54     0.0   0.0     5.0   12.0   102 93 1 2   0 0     0   6   48 54     0 0   5 12   102
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
1713890 MN Carver 10 school 2741460 110 Independent Districts and Schools Waconia Public School District 274146000363 110 Southview Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 80 4 11   0 3     0   6   60 44     9.0   0.0     13.0   19.0   104 80 4 11   0 3     0   6   60 44     9 0   13 19   104
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
1713913 MN Carver 10 school 2741910 111 Independent Districts and Schools Watertown-Mayer Public School District 274191003674 839 Watertown-Mayer Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 04 2021   grade_2 105 2 3   0 0     0   1   58 53     1.0   0.0     26.0   24.0   111 105 2 3   0 0     0   1   58 53     1 0   26 24   111
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
1713926 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819005049 504 Carver Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 86 17 5   1 2     0   4   59 56     8.0   0.0     23.0   16.0   115 86 17 5   1 2     0   4   59 56     8 0   23 16   115
1713933 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819000342 506 Chanhassen Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 49 5 1   0 2     0   5   34 28     6.0   0.0     9.0   10.0   62 49 5 1   0 2     0   5   34 28     6 0   9 10   62
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
1713949 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819002509 510 Bluff Creek Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 63 3 12   0 10     0   6   53 41     7.0   0.0     17.0   7.0   94 63 3 12   0 10     0   6   53 41     7 0   17 7   94
1713956 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819003067 511 Clover Ridge Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 75 11 5   0 2     0   5   48 50     8.0   4.0     17.0   11.0   98 75 11 5   0 2     0   5   48 50     8 4   17 11   98
1713963 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 2021   grade_2 101 2 2   0 1     0   3   50 59     1.0   0.0     4.0   11.0   109 101 2 2   0 1     0   3   50 59     1 0   4 11   109

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