Data source: Big Local News · About: Big Local

13,861 rows where state = "MN" and year = 2018 sorted by ccd_school_lvl

View and edit SQL

year

  • 2018 · 13,861
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
1881360 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 2018   early_childhood_special_ed 13.0 0.0 0.0   0.0 0.0     0.0   1.0   6.0 8.0     0.0   0.0     7.0   *   14.0 13 0 0   0 0     0   1   6 8     0 0   7     14
1881361 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 2018   kindergarten 87.0 1.0 0.0   1.0 1.0     0.0   3.0   55.0 38.0     0.0   0.0     38.0   16.0   93.0 87 1 0   1 1     0   3   55 38     0 0   38 16   93
1881362 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 2018   grade_1 70.0 0.0 1.0   2.0 1.0     0.0   3.0   43.0 34.0     0.0   0.0     36.0   15.0   77.0 70 0 1   2 1     0   3   43 34     0 0   36 15   77
1881363 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 2018   grade_2 82.0 2.0 1.0   0.0 1.0     0.0   2.0   56.0 32.0     0.0   0.0     54.0   11.0   88.0 82 2 1   0 1     0   2   56 32     0 0   54 11   88
1881364 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 2018   grade_3 72.0 0.0 0.0   1.0 0.0     0.0   2.0   46.0 29.0     0.0   0.0     37.0   16.0   75.0 72 0 0   1 0     0   2   46 29     0 0   37 16   75
1881365 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 2018   grade_4 93.0 1.0 2.0   0.0 2.0     0.0   1.0   47.0 52.0     1.0   0.0     49.0   15.0   99.0 93 1 2   0 2     0   1   47 52     1 0   49 15   99
1881366 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 2018   grade_5 90.0 1.0 2.0   0.0 0.0     0.0   4.0   53.0 44.0     0.0   0.0     50.0   11.0   97.0 90 1 2   0 0     0   4   53 44     0 0   50 11   97
1881367 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 2018   grade_6 75.0 1.0 1.0   1.0 0.0     0.0   3.0   35.0 46.0     0.0   0.0     33.0   6.0   81.0 75 1 1   1 0     0   3   35 46     0 0   33 6   81
1881368 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 2018   pk_12_total 582.0 6.0 7.0   5.0 5.0     0.0   19.0   341.0 283.0     1.0   0.0     304.0   104.0   624.0 582 6 7   5 5     0   19   341 283     1 0   304 104   624
1881369 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 2018   early_childhood_special_ed 14.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 8.0     *   *     11.0   *   14.0 14 0 0   0 0     0   0   6 8           11     14
1881370 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 2018   pre_kindergarten 8.0 0.0 1.0   0.0 0.0     0.0   0.0   6.0 3.0     *   *     *   *   9.0 8 0 1   0 0     0   0   6 3                 9
1881371 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 2018   kindergarten 16.0 0.0 0.0   0.0 0.0     0.0   1.0   9.0 8.0     0.0   0.0     *   *   17.0 16 0 0   0 0     0   1   9 8     0 0         17
1881372 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 2018   grade_1 17.0 0.0 1.0   0.0 0.0     0.0   0.0   9.0 9.0     0.0   0.0     12.0   5.0   18.0 17 0 1   0 0     0   0   9 9     0 0   12 5   18
1881373 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 2018   grade_2 16.0 0.0 1.0   0.0 0.0     0.0   1.0   6.0 12.0     0.0   0.0     11.0   4.0   18.0 16 0 1   0 0     0   1   6 12     0 0   11 4   18
1881374 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 2018   grade_3 12.0 0.0 1.0   0.0 0.0     0.0   1.0   8.0 6.0     0.0   0.0     10.0   5.0   14.0 12 0 1   0 0     0   1   8 6     0 0   10 5   14
1881375 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 2018   grade_4 20.0 0.0 0.0   0.0 0.0     0.0   2.0   9.0 13.0     0.0   0.0     15.0   4.0   22.0 20 0 0   0 0     0   2   9 13     0 0   15 4   22
1881376 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 2018   pk_12_total 103.0 0.0 4.0   0.0 0.0     0.0   5.0   53.0 59.0     0.0   0.0     76.0   36.0   112.0 103 0 4   0 0     0   5   53 59     0 0   76 36   112
1881377 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 2018   early_childhood_special_ed 10.0 0.0 2.0   6.0 0.0     0.0   0.0   16.0 2.0     *   *     5.0   *   18.0 10 0 2   6 0     0   0   16 2           5     18
1881378 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 2018   pre_kindergarten 23.0 0.0 0.0   0.0 0.0     0.0   1.0   14.0 10.0     0.0   0.0     5.0   0.0   24.0 23 0 0   0 0     0   1   14 10     0 0   5 0   24
1881379 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 2018   kindergarten 12.0 0.0 1.0   11.0 0.0     0.0   2.0   14.0 12.0     0.0   0.0     18.0   8.0   26.0 12 0 1   11 0     0   2   14 12     0 0   18 8   26
1881380 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 2018   grade_1 17.0 0.0 0.0   10.0 0.0     0.0   0.0   14.0 13.0     0.0   0.0     10.0   8.0   27.0 17 0 0   10 0     0   0   14 13     0 0   10 8   27
1881381 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 2018   grade_2 27.0 0.0 0.0   14.0 0.0     0.0   0.0   17.0 24.0     0.0   0.0     24.0   9.0   41.0 27 0 0   14 0     0   0   17 24     0 0   24 9   41
1881382 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 2018   grade_3 27.0 0.0 0.0   12.0 0.0     0.0   2.0   21.0 20.0     0.0   0.0     25.0   8.0   41.0 27 0 0   12 0     0   2   21 20     0 0   25 8   41
1881383 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 2018   grade_4 23.0 1.0 0.0   12.0 0.0     0.0   2.0   23.0 15.0     0.0   0.0     21.0   7.0   38.0 23 1 0   12 0     0   2   23 15     0 0   21 7   38
1881384 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 2018   grade_5 31.0 0.0 1.0   9.0 0.0     0.0   0.0   19.0 22.0     0.0   0.0     23.0   8.0   41.0 31 0 1   9 0     0   0   19 22     0 0   23 8   41
1881385 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 2018   grade_6 23.0 0.0 2.0   7.0 0.0     0.0   0.0   15.0 17.0     0.0   0.0     18.0   10.0   32.0 23 0 2   7 0     0   0   15 17     0 0   18 10   32
1881386 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 2018   pk_12_total 193.0 1.0 6.0   81.0 0.0     0.0   7.0   153.0 135.0     *   *     149.0   76.0   288.0 193 1 6   81 0     0   7   153 135           149 76   288
1881387 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 2018   pre_kindergarten 15.0 6.0 1.0   2.0 5.0     0.0   0.0   11.0 18.0     0.0   0.0     16.0   0.0   29.0 15 6 1   2 5     0   0   11 18     0 0   16 0   29
1881388 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 2018   kindergarten 33.0 13.0 7.0   0.0 3.0     0.0   12.0   34.0 34.0     15.0   1.0     38.0   9.0   68.0 33 13 7   0 3     0   12   34 34     15 1   38 9   68
1881389 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 2018   grade_1 48.0 17.0 6.0   1.0 6.0     0.0   8.0   46.0 40.0     12.0   3.0     48.0   16.0   86.0 48 17 6   1 6     0   8   46 40     12 3   48 16   86
1881390 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 2018   grade_2 35.0 12.0 13.0   3.0 8.0     1.0   5.0   29.0 48.0     21.0   3.0     52.0   12.0   77.0 35 12 13   3 8     1   5   29 48     21 3   52 12   77
1881391 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 2018   grade_3 44.0 14.0 4.0   1.0 7.0     0.0   3.0   34.0 39.0     14.0   3.0     44.0   19.0   73.0 44 14 4   1 7     0   3   34 39     14 3   44 19   73
1881392 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 2018   grade_4 40.0 15.0 1.0   3.0 2.0     0.0   14.0   37.0 38.0     15.0   0.0     50.0   12.0   75.0 40 15 1   3 2     0   14   37 38     15 0   50 12   75
1881393 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 2018   grade_5 48.0 15.0 6.0   1.0 6.0     0.0   5.0   51.0 30.0     7.0   2.0     45.0   14.0   81.0 48 15 6   1 6     0   5   51 30     7 2   45 14   81
1881394 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 2018   pk_12_total 263.0 92.0 38.0   11.0 37.0     1.0   47.0   242.0 247.0     84.0   12.0     293.0   82.0   489.0 263 92 38   11 37     1   47   242 247     84 12   293 82   489
1881395 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 2018   kindergarten 69.0 2.0 2.0   1.0 1.0     0.0   1.0   44.0 32.0     1.0   0.0     *   10.0   76.0 69 2 2   1 1     0   1   44 32     1 0     10   76
1881396 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 2018   grade_1 69.0 5.0 2.0   0.0 1.0     0.0   9.0   48.0 38.0     2.0   *     21.0   14.0   86.0 69 5 2   0 1     0   9   48 38     2     21 14   86
1881397 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 2018   grade_2 73.0 3.0 2.0   0.0 1.0     0.0   3.0   39.0 43.0     0.0   *     *   8.0   82.0 73 3 2   0 1     0   3   39 43     0       8   82
1881398 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 2018   grade_3 68.0 7.0 2.0   0.0 3.0     0.0   5.0   44.0 41.0     0.0   0.0     16.0   16.0   85.0 68 7 2   0 3     0   5   44 41     0 0   16 16   85
1881399 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 2018   grade_4 77.0 7.0 1.0   1.0 1.0     0.0   4.0   54.0 37.0     2.0   2.0     27.0   19.0   91.0 77 7 1   1 1     0   4   54 37     2 2   27 19   91
1881400 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 2018   grade_5 75.0 3.0 0.0   0.0 2.0     0.0   0.0   44.0 36.0     0.0   2.0     20.0   19.0   80.0 75 3 0   0 2     0   0   44 36     0 2   20 19   80
1881401 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 2018   pk_12_total 431.0 27.0 9.0   2.0 9.0     0.0   22.0   273.0 227.0     5.0   6.0     108.0   86.0   500.0 431 27 9   2 9     0   22   273 227     5 6   108 86   500
1881402 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 2018   kindergarten 43.0 10.0 9.0   0.0 1.0     0.0   4.0   36.0 31.0     11.0   1.0     36.0   10.0   67.0 43 10 9   0 1     0   4   36 31     11 1   36 10   67
1881403 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 2018   grade_1 51.0 13.0 5.0   0.0 0.0     0.0   2.0   35.0 36.0     9.0   0.0     45.0   10.0   71.0 51 13 5   0 0     0   2   35 36     9 0   45 10   71
1881404 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 2018   grade_2 39.0 9.0 6.0   1.0 2.0     0.0   6.0   34.0 29.0     9.0   0.0     39.0   13.0   63.0 39 9 6   1 2     0   6   34 29     9 0   39 13   63
1881405 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 2018   grade_3 38.0 14.0 3.0   2.0 3.0     1.0   3.0   38.0 26.0     6.0   1.0     37.0   18.0   64.0 38 14 3   2 3     1   3   38 26     6 1   37 18   64
1881406 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 2018   grade_4 27.0 12.0 6.0   1.0 1.0     0.0   6.0   28.0 25.0     5.0   0.0     36.0   11.0   53.0 27 12 6   1 1     0   6   28 25     5 0   36 11   53
1881407 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 2018   grade_5 39.0 14.0 4.0   0.0 1.0     0.0   3.0   30.0 31.0     6.0   0.0     38.0   14.0   61.0 39 14 4   0 1     0   3   30 31     6 0   38 14   61
1881408 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 2018   pk_12_total 237.0 72.0 33.0   4.0 8.0     1.0   24.0   201.0 178.0     46.0   2.0     231.0   76.0   379.0 237 72 33   4 8     1   24   201 178     46 2   231 76   379
1881409 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 2018   kindergarten 53.0 8.0 4.0   3.0 6.0     0.0   8.0   48.0 34.0     16.0   2.0     54.0   14.0   82.0 53 8 4   3 6     0   8   48 34     16 2   54 14   82
1881410 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 2018   grade_1 43.0 12.0 6.0   0.0 8.0     0.0   4.0   40.0 33.0     16.0   3.0     44.0   12.0   73.0 43 12 6   0 8     0   4   40 33     16 3   44 12   73
1881411 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 2018   grade_2 40.0 9.0 12.0   1.0 9.0     0.0   4.0   43.0 32.0     17.0   1.0     49.0   9.0   75.0 40 9 12   1 9     0   4   43 32     17 1   49 9   75
1881412 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 2018   grade_3 32.0 14.0 6.0   0.0 6.0     1.0   4.0   30.0 33.0     11.0   2.0     43.0   13.0   63.0 32 14 6   0 6     1   4   30 33     11 2   43 13   63
1881413 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 2018   grade_4 41.0 12.0 11.0   4.0 3.0     0.0   3.0   37.0 37.0     15.0   2.0     51.0   12.0   74.0 41 12 11   4 3     0   3   37 37     15 2   51 12   74
1881414 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 2018   grade_5 45.0 8.0 9.0   1.0 5.0     1.0   11.0   38.0 42.0     3.0   1.0     46.0   21.0   80.0 45 8 9   1 5     1   11   38 42     3 1   46 21   80
1881415 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 2018   pk_12_total 254.0 63.0 48.0   9.0 37.0     2.0   34.0   236.0 211.0     78.0   11.0     287.0   81.0   447.0 254 63 48   9 37     2   34   236 211     78 11   287 81   447
1881416 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   kindergarten 50.0 7.0 8.0   0.0 5.0     0.0   7.0   43.0 34.0     9.0   2.0     35.0   12.0   77.0 50 7 8   0 5     0   7   43 34     9 2   35 12   77
1881417 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_1 51.0 8.0 5.0   1.0 6.0     0.0   7.0   34.0 44.0     7.0   4.0     38.0   14.0   78.0 51 8 5   1 6     0   7   34 44     7 4   38 14   78
1881418 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_2 45.0 9.0 6.0   0.0 2.0     0.0   7.0   40.0 29.0     6.0   2.0     32.0   8.0   69.0 45 9 6   0 2     0   7   40 29     6 2   32 8   69
1881419 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_3 44.0 9.0 4.0   0.0 4.0     0.0   7.0   33.0 35.0     9.0   3.0     36.0   7.0   68.0 44 9 4   0 4     0   7   33 35     9 3   36 7   68
1881420 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_4 54.0 17.0 6.0   1.0 4.0     0.0   7.0   43.0 46.0     8.0   1.0     44.0   19.0   89.0 54 17 6   1 4     0   7   43 46     8 1   44 19   89
1881421 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_5 53.0 13.0 6.0   0.0 7.0     0.0   5.0   50.0 34.0     7.0   3.0     37.0   17.0   84.0 53 13 6   0 7     0   5   50 34     7 3   37 17   84
1881422 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   pk_12_total 297.0 63.0 35.0   2.0 28.0     0.0   40.0   243.0 222.0     46.0   15.0     222.0   77.0   465.0 297 63 35   2 28     0   40   243 222     46 15   222 77   465
1881423 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 2018   kindergarten 82.0 8.0 10.0   0.0 8.0     0.0   9.0   64.0 53.0     17.0   4.0     43.0   18.0   117.0 82 8 10   0 8     0   9   64 53     17 4   43 18   117
1881424 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 2018   grade_1 82.0 15.0 2.0   1.0 10.0     1.0   8.0   59.0 60.0     9.0   2.0     52.0   24.0   119.0 82 15 2   1 10     1   8   59 60     9 2   52 24   119
1881425 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 2018   grade_2 89.0 17.0 6.0   0.0 6.0     0.0   11.0   58.0 71.0     11.0   1.0     51.0   24.0   129.0 89 17 6   0 6     0   11   58 71     11 1   51 24   129
1881426 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 2018   grade_3 84.0 14.0 6.0   0.0 9.0     0.0   5.0   55.0 63.0     10.0   1.0     39.0   24.0   118.0 84 14 6   0 9     0   5   55 63     10 1   39 24   118
1881427 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 2018   grade_4 86.0 8.0 3.0   2.0 8.0     0.0   3.0   58.0 52.0     9.0   3.0     51.0   22.0   110.0 86 8 3   2 8     0   3   58 52     9 3   51 22   110
1881428 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 2018   grade_5 78.0 24.0 14.0   1.0 11.0     0.0   11.0   81.0 58.0     7.0   1.0     56.0   34.0   139.0 78 24 14   1 11     0   11   81 58     7 1   56 34   139
1881429 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 2018   pk_12_total 501.0 86.0 41.0   4.0 52.0     1.0   47.0   375.0 357.0     63.0   12.0     292.0   146.0   732.0 501 86 41   4 52     1   47   375 357     63 12   292 146   732
1881430 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 2018   kindergarten 126.0 6.0 4.0   0.0 7.0     0.0   10.0   66.0 87.0     5.0   2.0     25.0   17.0   153.0 126 6 4   0 7     0   10   66 87     5 2   25 17   153
1881431 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 2018   grade_1 95.0 5.0 3.0   0.0 5.0     0.0   6.0   54.0 60.0     *   0.0     21.0   *   114.0 95 5 3   0 5     0   6   54 60       0   21     114
1881432 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 2018   grade_2 112.0 5.0 1.0   1.0 7.0     0.0   7.0   59.0 74.0     4.0   1.0     19.0   8.0   133.0 112 5 1   1 7     0   7   59 74     4 1   19 8   133
1881433 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 2018   grade_3 123.0 9.0 4.0   0.0 9.0     0.0   3.0   76.0 72.0     8.0   1.0     21.0   13.0   148.0 123 9 4   0 9     0   3   76 72     8 1   21 13   148
1881434 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 2018   grade_4 112.0 10.0 3.0   2.0 7.0     0.0   3.0   78.0 59.0     9.0   4.0     33.0   20.0   137.0 112 10 3   2 7     0   3   78 59     9 4   33 20   137
1881435 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 2018   grade_5 123.0 6.0 5.0   0.0 10.0     1.0   4.0   79.0 70.0     *   0.0     25.0   15.0   149.0 123 6 5   0 10     1   4   79 70       0   25 15   149
1881436 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 2018   pk_12_total 691.0 41.0 20.0   3.0 45.0     1.0   33.0   412.0 422.0     29.0   8.0     144.0   80.0   834.0 691 41 20   3 45     1   33   412 422     29 8   144 80   834
1881437 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 2018   kindergarten 54.0 11.0 4.0   2.0 0.0     1.0   7.0   37.0 42.0     3.0   1.0     39.0   13.0   79.0 54 11 4   2 0     1   7   37 42     3 1   39 13   79
1881438 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 2018   grade_1 57.0 6.0 9.0   1.0 3.0     0.0   3.0   32.0 47.0     4.0   0.0     45.0   13.0   79.0 57 6 9   1 3     0   3   32 47     4 0   45 13   79
1881439 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 2018   grade_2 52.0 8.0 6.0   1.0 3.0     0.0   3.0   34.0 39.0     9.0   2.0     40.0   18.0   73.0 52 8 6   1 3     0   3   34 39     9 2   40 18   73
1881440 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 2018   grade_3 56.0 9.0 6.0   0.0 1.0     0.0   4.0   42.0 34.0     5.0   1.0     41.0   15.0   76.0 56 9 6   0 1     0   4   42 34     5 1   41 15   76
1881441 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 2018   grade_4 44.0 6.0 4.0   1.0 2.0     0.0   2.0   28.0 31.0     6.0   3.0     31.0   10.0   59.0 44 6 4   1 2     0   2   28 31     6 3   31 10   59
1881442 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 2018   grade_5 62.0 11.0 3.0   1.0 1.0     0.0   7.0   40.0 45.0     2.0   2.0     46.0   20.0   85.0 62 11 3   1 1     0   7   40 45     2 2   46 20   85
1881443 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 2018   pk_12_total 325.0 51.0 32.0   6.0 10.0     1.0   26.0   213.0 238.0     29.0   9.0     242.0   89.0   451.0 325 51 32   6 10     1   26   213 238     29 9   242 89   451
1881444 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 2018   kindergarten 52.0 9.0 7.0   0.0 7.0     0.0   2.0   47.0 30.0     20.0   1.0     30.0   15.0   77.0 52 9 7   0 7     0   2   47 30     20 1   30 15   77
1881445 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 2018   grade_1 57.0 9.0 7.0   2.0 4.0     0.0   3.0   43.0 39.0     15.0   2.0     32.0   14.0   82.0 57 9 7   2 4     0   3   43 39     15 2   32 14   82
1881446 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 2018   grade_2 54.0 8.0 5.0   1.0 7.0     1.0   4.0   41.0 39.0     7.0   2.0     32.0   12.0   80.0 54 8 5   1 7     1   4   41 39     7 2   32 12   80
1881447 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 2018   grade_3 52.0 2.0 9.0   2.0 4.0     0.0   6.0   38.0 37.0     8.0   2.0     28.0   13.0   75.0 52 2 9   2 4     0   6   38 37     8 2   28 13   75
1881448 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 2018   grade_4 50.0 9.0 3.0   1.0 8.0     1.0   2.0   42.0 32.0     12.0   2.0     31.0   11.0   74.0 50 9 3   1 8     1   2   42 32     12 2   31 11   74
1881449 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 2018   grade_5 61.0 3.0 8.0   1.0 11.0     0.0   5.0   44.0 45.0     7.0   1.0     34.0   12.0   89.0 61 3 8   1 11     0   5   44 45     7 1   34 12   89
1881450 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 2018   pk_12_total 326.0 40.0 39.0   7.0 41.0     2.0   22.0   255.0 222.0     69.0   10.0     187.0   77.0   477.0 326 40 39   7 41     2   22   255 222     69 10   187 77   477
1881451 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   kindergarten 91.0 2.0 2.0   1.0 0.0     0.0   2.0   50.0 48.0     *   1.0     14.0   *   98.0 91 2 2   1 0     0   2   50 48       1   14     98
1881452 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_1 113.0 2.0 1.0   0.0 6.0     0.0   4.0   63.0 63.0     3.0   3.0     36.0   13.0   126.0 113 2 1   0 6     0   4   63 63     3 3   36 13   126
1881453 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_2 101.0 1.0 2.0   0.0 3.0     0.0   4.0   55.0 56.0     *   3.0     19.0   *   111.0 101 1 2   0 3     0   4   55 56       3   19     111
1881454 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_3 129.0 0.0 3.0   1.0 3.0     0.0   3.0   85.0 54.0     3.0   1.0     21.0   11.0   139.0 129 0 3   1 3     0   3   85 54     3 1   21 11   139
1881455 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_4 101.0 3.0 1.0   1.0 5.0     0.0   6.0   59.0 58.0     3.0   1.0     24.0   15.0   117.0 101 3 1   1 5     0   6   59 58     3 1   24 15   117
1881456 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   grade_5 127.0 1.0 6.0   0.0 4.0     0.0   4.0   82.0 60.0     0.0   2.0     24.0   23.0   142.0 127 1 6   0 4     0   4   82 60     0 2   24 23   142
1881457 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2018   pk_12_total 662.0 9.0 15.0   3.0 21.0     0.0   23.0   394.0 339.0     12.0   11.0     138.0   76.0   733.0 662 9 15   3 21     0   23   394 339     12 11   138 76   733
1881458 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 2018   kindergarten 43.0 8.0 6.0   0.0 2.0     0.0   5.0   38.0 26.0     *   1.0     32.0   11.0   64.0 43 8 6   0 2     0   5   38 26       1   32 11   64
1881459 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 2018   grade_1 48.0 10.0 6.0   0.0 6.0     0.0   5.0   36.0 39.0     10.0   1.0     39.0   *   75.0 48 10 6   0 6     0   5   36 39     10 1   39     75

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