Data source: Big Local News · About: Big Local

6,745 rows where grade = "grade_4" and state = "MN"

View and edit SQL

year

grade

  • grade_4 · 6,645
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
691331 MN Cass 11 school 2730870 118 Independent Districts and Schools NORTHLAND COMMUNITY SCHOOLS 273087001307 10 REMER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 11.0 0.0 0.0   10.0 0.0     0.0   7.0   13.0 15.0     0.0   0.0     21.0   9.0   28.0 11 0 0   10 0     0   7   13 15     0 0   21 9   28
691348 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 KG 04 2017   grade_4 200.0 2.0 10.0   1.0 1.0     0.0   4.0   119.0 99.0     2.0   0.0     70.0   33.0   218.0 200 2 10   1 1     0   4   119 99     2 0   70 33   218
691355 MN Chisago 13 school 2732550 139 Independent Districts and Schools RUSH CITY PUBLIC SCHOOL DISTRICT 273255001405 10 C.E. JACOBSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 57.0 0.0 2.0   2.0 1.0     0.0   3.0   35.0 30.0     1.0   0.0     28.0   6.0   65.0 57 0 2   2 1     0   3   35 30     1 0   28 6   65
691363 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 2017   grade_4 62.0 0.0 3.0   0.0 0.0     0.0   1.0   36.0 30.0     0.0   0.0     13.0   9.0   66.0 62 0 3   0 0     0   1   36 30     0 0   13 9   66
691371 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 2017   grade_4 79.0 0.0 2.0   0.0 1.0     0.0   3.0   44.0 41.0         *         *   85.0 79 0 2   0 1     0   3   44 41                 85
691378 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 2017   grade_4 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 2 0 0   0 0     0   0   2 0                 2
691387 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003509 187 Robert Asp Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 117.0 12.0 8.0   7.0 8.0     0.0   21.0   87.0 86.0     12.0   7.0     72.0   36.0   173.0 117 12 8   7 8     0   21   87 86     12 7   72 36   173
691393 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003510 188 ELLEN HOPKINS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 113.0 22.0 8.0   4.0 2.0     0.0   12.0   80.0 81.0     21.0   2.0     83.0   25.0   161.0 113 22 8   4 2     0   12   80 81     21 2   83 25   161
691399 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003511 189 S.G.REINERTSEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 160.0 7.0 8.0   5.0 0.0     0.0   10.0   103.0 87.0     10.0   2.0     60.0   23.0   190.0 160 7 8   5 0     0   10   103 87     10 2   60 23   190
691408 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 2017   grade_4 74.0 2.0 0.0   17.0 1.0     0.0   9.0   43.0 60.0     0.0   0.0     58.0   13.0   103.0 74 2 0   17 1     0   9   43 60     0 0   58 13   103
691418 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 2017   grade_4 14.0 1.0 3.0   6.0 1.0     1.0   2.0   17.0 11.0     0.0   0.0     12.0   2.0   28.0 14 1 3   6 1     1   2   17 11     0 0   12 2   28
691426 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 2017   grade_4 23.0 2.0 5.0   0.0 3.0     0.0   4.0   19.0 18.0     5.0   0.0     18.0   2.0   37.0 23 2 5   0 3     0   4   19 18     5 0   18 2   37
691440 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000248 4 BAXTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_4 89.0 1.0 3.0   0.0 1.0     0.0   5.0   43.0 56.0     0.0   0.0     35.0   21.0   99.0 89 1 3   0 1     0   5   43 56     0 0   35 21   99
691446 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 2017   grade_4 78.0 2.0 2.0   3.0 0.0     0.0   0.0   41.0 44.0     0.0   0.0     46.0   16.0   85.0 78 2 2   3 0     0   0   41 44     0 0   46 16   85
691452 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000254 9 HARRISON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_4 46.0 0.0 0.0   1.0 0.0     0.0   0.0   18.0 29.0     0.0   2.0     24.0   *   47.0 46 0 0   1 0     0   0   18 29     0 2   24     47
691458 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 2017   grade_4 79.0 3.0 1.0   0.0 0.0     0.0   4.0   39.0 48.0     0.0   0.0     32.0   10.0   87.0 79 3 1   0 0     0   4   39 48     0 0   32 10   87
691464 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000259 12 RIVERSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_4 99.0 2.0 4.0   3.0 0.0     0.0   5.0   59.0 54.0     0.0   0.0     64.0   25.0   113.0 99 2 4   3 0     0   5   59 54     0 0   64 25   113
691471 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 2017   grade_4 53.0 1.0 1.0   0.0 0.0     0.0   1.0   29.0 27.0     0.0   0.0     17.0   *   56.0 53 1 1   0 0     0   1   29 27     0 0   17     56
691478 MN Crow Wing 18 school 2709750 182 Independent Districts and Schools CROSBY-IRONTON PUBLIC SCHOOL DIST. 270975000291 6 CUYUNA RANGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 70.0 1.0 2.0   0.0 0.0     0.0   3.0   45.0 31.0     0.0   0.0     49.0   18.0   76.0 70 1 2   0 0     0   3   45 31     0 0   49 18   76
691487 MN Crow Wing 18 school 2728200 186 Independent Districts and Schools PEQUOT LAKES PUBLIC SCHOOLS 272820001244 10 EAGLE VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_4 119.0 3.0 1.0   2.0 0.0     0.0   1.0   69.0 57.0     0.0   1.0     44.0   15.0   126.0 119 3 1   2 0     0   1   69 57     0 1   44 15   126
691495 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000298 482 GIDEON POND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 35.0 38.0 7.0   0.0 2.0     0.0   6.0   49.0 39.0     9.0   1.0     56.0   12.0   88.0 35 38 7   0 2     0   6   49 39     9 1   56 12   88
691502 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000296 483 EDWARD NEILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 25.0 19.0 6.0   1.0 3.0     0.0   6.0   33.0 27.0     10.0   0.0     40.0   15.0   60.0 25 19 6   1 3     0   6   33 27     10 0   40 15   60
691509 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000300 484 M.W. SAVAGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 21.0 16.0 11.0   0.0 6.0     1.0   5.0   36.0 24.0     14.0   1.0     34.0   9.0   60.0 21 16 11   0 6     1   5   36 24     14 1   34 9   60
691516 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000301 485 SIOUX TRAIL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 28.0 10.0 7.0   0.0 4.0     0.0   4.0   19.0 34.0         1.0     25.0   3.0   53.0 28 10 7   0 4     0   4   19 34       1   25 3   53
691523 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000303 486 VISTA VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 19.0 11.0 22.0   1.0 0.0     0.0   4.0   28.0 29.0     12.0   2.0     38.0   10.0   57.0 19 11 22   1 0     0   4   28 29     12 2   38 10   57
691530 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000293 487 WILLIAM BYRNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 50.0 19.0 15.0   0.0 7.0     0.0   12.0   60.0 43.0     12.0   1.0     43.0   16.0   103.0 50 19 15   0 7     0   12   60 43     12 1   43 16   103
691539 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000299 488 RAHN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 26.0 16.0 3.0   0.0 3.0     0.0   3.0   21.0 30.0         1.0     19.0   3.0   51.0 26 16 3   0 3     0   3   21 30       1   19 3   51
691548 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000302 489 SKY OAKS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 14.0 29.0 31.0   0.0 3.0     0.0   10.0   51.0 36.0     22.0   2.0     65.0   14.0   87.0 14 29 31   0 3     0   10   51 36     22 2   65 14   87
691557 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002233 490 HIDDEN VALLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 12.0 32.0 34.0   0.0 5.0     0.0   3.0   41.0 45.0     33.0   2.0     70.0   18.0   86.0 12 32 34   0 5     0   3   41 45     33 2   70 18   86
691564 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002641 491 HARRIET BISHOP ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 58.0 4.0 9.0   0.0 12.0     0.0   12.0   50.0 45.0     9.0   1.0     24.0   4.0   95.0 58 4 9   0 12     0   12   50 45     9 1   24 4   95
691572 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182000569 10 FARMINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 77.0 4.0 3.0   0.0 1.0     0.0   5.0   46.0 44.0         3.0     22.0   *   90.0 77 4 3   0 1     0   5   46 44       3   22     90
691580 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002642 40 NORTH TRAIL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 91.0 8.0 7.0   0.0 9.0     0.0   11.0   62.0 64.0     7.0   0.0     22.0   22.0   126.0 91 8 7   0 9     0   11   62 64     7 0   22 22   126
691588 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182003183 80 MEADOWVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 108.0 2.0 9.0   0.0 6.0     0.0   6.0   68.0 63.0     5.0   0.0     17.0   19.0   131.0 108 2 9   0 6     0   6   68 63     5 0   17 19   131
691596 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182004376 100 RIVERVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 103.0 2.0 7.0   1.0 3.0     0.0   6.0   60.0 62.0     3.0   *         18.0   122.0 103 2 7   1 3     0   6   60 62     3       18   122
691600 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182004816 155 Gateway Academy Elementary School (Grades PK-6) Regular School No Elementary 03 08 2017   grade_4 6.0 0.0 1.0   0.0 0.0     0.0   0.0   6.0 1.0         *         *   7.0 6 0 1   0 0     0   0   6 1                 7
691611 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002205 621 AKIN ROAD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 94.0 6.0 13.0   1.0 7.0     0.0   8.0   66.0 63.0     8.0   1.0     29.0   13.0   129.0 94 6 13   1 7     0   8   66 63     8 1   29 13   129
691618 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 2017   grade_4 82.0 4.0 6.0   0.0 5.0     1.0   4.0   56.0 46.0     3.0   0.0     13.0   12.0   102.0 82 4 6   0 5     1   4   56 46     3 0   13 12   102
691625 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002043 592 HUDDLESTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 59.0 3.0 4.0   1.0 5.0     0.0   4.0   39.0 37.0     4.0   0.0     14.0   15.0   76.0 59 3 4   1 5     0   4   39 37     4 0   14 15   76
691632 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778000818 593 Impact Academy at Orchard Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 51.0 7.0 9.0   0.0 4.0     0.0   3.0   41.0 33.0     6.0   *     20.0   10.0   74.0 51 7 9   0 4     0   3   41 33     6     20 10   74
691639 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002273 595 LAKE MARION ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 75.0 6.0 12.0   0.0 2.0     0.0   3.0   42.0 56.0     4.0   1.0     30.0   14.0   98.0 75 6 12   0 2     0   3   42 56     4 1   30 14   98
691646 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778000025 596 CHERRY VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 83.0 0.0 1.0   1.0 5.0     0.0   3.0   42.0 51.0     0.0   0.0         13.0   93.0 83 0 1   1 5     0   3   42 51     0 0     13   93
691653 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002436 597 LAKEVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 93.0 2.0 7.0   1.0 3.0     0.0   5.0   58.0 53.0         2.0     11.0   12.0   111.0 93 2 7   1 3     0   5   58 53       2   11 12   111
691660 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002643 598 EASTVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 90.0 3.0 0.0   1.0 7.0     0.0   10.0   52.0 59.0     2.0   0.0     10.0   *   111.0 90 3 0   1 7     0   10   52 59     2 0   10     111
691667 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002985 599 OAK HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 86.0 2.0 19.0   1.0 9.0     0.0   5.0   66.0 56.0     19.0   0.0     28.0   16.0   122.0 86 2 19   1 9     0   5   66 56     19 0   28 16   122
691675 MN Dakota 19 school 2730150 195 Independent Districts and Schools RANDOLPH PUBLIC SCHOOL DISTRICT 273015001286 10 RANDOLPH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 48.0 0.0 3.0   0.0 0.0     0.0   0.0   29.0 22.0     0.0   0.0     7.0   8.0   51.0 48 0 3   0 0     0   0   29 22     0 0   7 8   51
691683 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001380 705 ROSEMOUNT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 94.0 8.0 9.0   0.0 6.0     0.0   6.0   58.0 65.0     5.0   0.0     34.0   16.0   123.0 94 8 9   0 6     0   6   58 65     5 0   34 16   123
691690 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001377 706 NORTHVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 52.0 8.0 6.0   0.0 9.0     0.0   6.0   40.0 41.0     5.0   *     18.0   20.0   81.0 52 8 6   0 9     0   6   40 41     5     18 20   81
691697 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001384 707 WESTVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 37.0 11.0 10.0   0.0 8.0     0.0   10.0   39.0 37.0     9.0   0.0     37.0   14.0   76.0 37 11 10   0 8     0   10   39 37     9 0   37 14   76
691704 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001382 708 SOUTHVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 61.0 20.0 11.0   0.0 3.0     0.0   6.0   57.0 44.0     14.0   1.0     35.0   12.0   101.0 61 20 11   0 3     0   6   57 44     14 1   35 12   101
691711 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001378 709 PARKVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 101.0 12.0 8.0   0.0 13.0     0.0   8.0   72.0 70.0     8.0   0.0     36.0   22.0   142.0 101 12 8   0 13     0   8   72 70     8 0   36 22   142
691718 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001375 710 Diamond Path Elementary School of International Studies Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 95.0 14.0 6.0   0.0 9.0     0.0   15.0   58.0 81.0     6.0   1.0     34.0   7.0   139.0 95 14 6   0 9     0   15   58 81     6 1   34 7   139
691725 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001376 711 GREENLEAF ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 92.0 20.0 30.0   2.0 8.0     0.0   12.0   73.0 91.0     25.0   0.0     63.0   23.0   164.0 92 20 30   2 8     0   12   73 91     25 0   63 23   164
691732 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001374 712 Cedar Park Elementary School of Science, Technology, Engineering and Math Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 53.0 28.0 16.0   0.0 17.0     0.0   8.0   61.0 61.0     10.0   1.0     61.0   11.0   122.0 53 28 16   0 17     0   8   61 61     10 1   61 11   122
691739 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001944 713 THOMAS LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 57.0 7.0 2.0   0.0 5.0     0.0   4.0   39.0 36.0         0.0         12.0   75.0 57 7 2   0 5     0   4   39 36       0     12   75
691748 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001942 714 Echo Park Elementary School of Leadership, Engineering and Technology Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 45.0 28.0 19.0   1.0 3.0     0.0   14.0   49.0 61.0     21.0   2.0     70.0   15.0   110.0 45 28 19   1 3     0   14   49 61     21 2   70 15   110
691755 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002185 715 HIGHLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 90.0 15.0 15.0   0.0 16.0     0.0   10.0   73.0 73.0     13.0   1.0     30.0   21.0   146.0 90 15 15   0 16     0   10   73 73     13 1   30 21   146
691762 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000511 716 DEERWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 66.0 13.0 11.0   0.0 7.0     0.0   11.0   50.0 58.0     7.0   1.0     25.0   18.0   108.0 66 13 11   0 7     0   11   50 58     7 1   25 18   108
691769 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002216 717 WOODLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 77.0 9.0 7.0   0.0 10.0     0.0   5.0   60.0 48.0     5.0   1.0     17.0   15.0   108.0 77 9 7   0 10     0   5   60 48     5 1   17 15   108
691776 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002282 718 PINEWOOD EL. Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 74.0 3.0 19.0   0.0 16.0     0.0   5.0   55.0 62.0     8.0   0.0     23.0   8.0   117.0 74 3 19   0 16     0   5   55 62     8 0   23 8   117
691783 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002283 719 SHANNON PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 92.0 2.0 5.0   1.0 12.0     0.0   10.0   65.0 57.0     5.0   0.0     10.0   15.0   122.0 92 2 5   1 12     0   10   65 57     5 0   10 15   122
691790 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002302 720 Oak Ridge Elementary School of Leadership, Environmental and Health Sciences Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 32.0 32.0 11.0   0.0 7.0     0.0   8.0   46.0 44.0     9.0   1.0     49.0   21.0   90.0 32 32 11   0 7     0   8   46 44     9 1   49 21   90
691797 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000512 764 Glacier Hills Elementary School of Arts and Science Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 65.0 15.0 18.0   0.0 31.0     0.0   10.0   60.0 79.0     25.0   0.0     37.0   16.0   139.0 65 15 18   0 31     0   10   60 79     25 0   37 16   139
691804 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002519 765 RED PINE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 117.0 6.0 12.0   0.0 16.0     0.0   6.0   73.0 84.0     9.0   0.0     21.0   15.0   157.0 117 6 12   0 16     0   6   73 84     9 0   21 15   157
691811 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001776 815 MORELAND ART/HEALTH SCIENCE MAGNET Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_4 27.0 3.0 40.0   1.0 1.0     0.0   4.0   40.0 36.0     9.0   0.0     45.0   20.0   76.0 27 3 40   1 1     0   4   40 36     9 0   45 20   76
691817 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227002202 816 MENDOTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_4 56.0 1.0 7.0   0.0 3.0     0.0   3.0   36.0 34.0     4.0   0.0         19.0   70.0 56 1 7   0 3     0   3   36 34     4 0     19   70
691823 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001773 817 GARLOUGH ENVIRONMENTAL MAGNET Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_4 30.0 8.0 33.0   0.0 1.0     0.0   8.0   42.0 38.0     19.0   0.0     48.0   18.0   80.0 30 8 33   0 1     0   8   42 38     19 0   48 18   80
691829 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001780 819 SOMERSET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_4 60.0 0.0 8.0   1.0 1.0     1.0   5.0   36.0 40.0     1.0   0.0         7.0   76.0 60 0 8   1 1     1   5   36 40     1 0     7   76
691835 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001778 820 PILOT KNOB STEM MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_4 38.0 19.0 7.0   1.0 9.0     0.0   10.0   48.0 36.0     4.0   0.0     33.0   15.0   84.0 38 19 7   1 9     0   10   48 36     4 0   33 15   84
691839 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 2017   grade_4 23.0 1.0 1.0   0.0 8.0     0.0   4.0   21.0 16.0     0.0   0.0     5.0   3.0   37.0 23 1 1   0 8     0   4   21 16     0 0   5 3   37
691846 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000763 575 HILLTOP ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 48.0 18.0 28.0   0.0 2.0     0.0   8.0   59.0 45.0     13.0   1.0     53.0   25.0   104.0 48 18 28   0 2     0   8   59 45     13 1   53 25   104
691853 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000547 577 PINE BEND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 44.0 8.0 17.0   2.0 4.0     0.0   8.0   38.0 45.0     10.0   0.0     40.0   13.0   83.0 44 8 17   2 4     0   8   38 45     10 0   40 13   83
691860 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000766 578 SALEM HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 23.0 7.0 17.0   1.0 1.0     0.0   4.0   22.0 31.0     6.0   1.0     30.0   12.0   53.0 23 7 17   1 1     0   4   22 31     6 1   30 12   53
691867 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353000695 609 KENNEDY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_4 89.0 2.0 4.0   1.0 0.0     0.0   5.0   52.0 49.0     0.0   0.0     27.0   11.0   101.0 89 2 4   1 0     0   5   52 49     0 0   27 11   101
691873 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 2017   grade_4 112.0 4.0 6.0   0.0 1.0     0.0   2.0   63.0 62.0     4.0   0.0     35.0   17.0   125.0 112 4 6   0 1     0   2   63 62     4 0   35 17   125
691879 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353002239 612 CHRISTA MCAULIFFE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_4 91.0 3.0 5.0   0.0 1.0     0.0   5.0   53.0 52.0     2.0   1.0     19.0   11.0   105.0 91 3 5   0 1     0   5   53 52     2 1   19 11   105
691886 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 2017   grade_4 43.0 1.0 5.0   0.0 0.0     0.0   4.0   31.0 22.0     0.0   0.0     23.0   10.0   53.0 43 1 5   0 0     0   4   31 22     0 0   23 10   53
691894 MN Dodge 20 school 2716980 204 Independent Districts and Schools KASSON-MANTORVILLE SCHOOL DISTRICT 271698000783 10 KASSON-MANTORVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_4 135.0 1.0 9.0   0.0 1.0     0.0   6.0   79.0 73.0     5.0   0.0     32.0   15.0   152.0 135 1 9   0 1     0   6   79 73     5 0   32 15   152
691900 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 2017   grade_4 14.0 0.0 1.0   0.0 0.0     0.0   0.0   8.0 7.0     0.0   0.0     6.0   4.0   15.0 14 0 1   0 0     0   0   8 7     0 0   6 4   15
691907 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 2017   grade_4 20.0 0.0 0.0   0.0 0.0     0.0   1.0   9.0 12.0     0.0   0.0     5.0   2.0   21.0 20 0 0   0 0     0   1   9 12     0 0   5 2   21
691914 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 2017   grade_4 71.0 1.0 2.0   0.0 0.0     0.0   2.0   40.0 36.0     0.0   1.0     20.0   13.0   76.0 71 1 2   0 0     0   2   40 36     0 1   20 13   76
691921 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 2017   grade_4 26.0 0.0 0.0   0.0 0.0     0.0   2.0   16.0 12.0     0.0   0.0     8.0   4.0   28.0 26 0 0   0 0     0   2   16 12     0 0   8 4   28
691928 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 2017   grade_4 78.0 1.0 2.0   0.0 0.0     0.0   2.0   48.0 35.0     2.0   1.0     27.0   18.0   83.0 78 1 2   0 0     0   2   48 35     2 1   27 18   83
691935 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 2017   grade_4 82.0 0.0 3.0   0.0 0.0     0.0   7.0   39.0 53.0     0.0   0.0     26.0   15.0   92.0 82 0 3   0 0     0   7   39 53     0 0   26 15   92
691945 MN Douglas 21 school 2725140 213 Independent Districts and Schools OSAKIS PUBLIC SCHOOL DISTRICT 272514001203 10 OSAKIS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 65.0 0.0 3.0   0.0 1.0     0.0   0.0   32.0 37.0     0.0   0.0     27.0   11.0   69.0 65 0 3   0 1     0   0   32 37     0 0   27 11   69
691954 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 2017   grade_4 87.0 0.0 1.0   0.0 0.0     0.0   1.0   40.0 49.0     0.0   0.0     16.0   6.0   89.0 87 0 1   0 0     0   1   40 49     0 0   16 6   89
691963 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 2017   grade_4 26.0 0.0 0.0   0.0 0.0     0.0   0.0   12.0 14.0     0.0   0.0     18.0   4.0   26.0 26 0 0   0 0     0   0   12 14     0 0   18 4   26
691972 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 2017   grade_4 27.0 0.0 1.0   0.0 0.0     0.0   1.0   14.0 15.0     1.0   0.0     8.0   4.0   29.0 27 0 1   0 0     0   1   14 15     1 0   8 4   29
691981 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 2017   grade_4 44.0 0.0 0.0   0.0 0.0     0.0   1.0   25.0 20.0     0.0   0.0     17.0   4.0   45.0 44 0 0   0 0     0   1   25 20     0 0   17 4   45
691990 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000070 110 HALVERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 30.0 1.0 22.0   0.0 1.0     0.0   1.0   37.0 18.0     9.0   0.0     40.0   8.0   55.0 30 1 22   0 1     0   1   37 18     9 0   40 8   55
691999 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000071 120 HAWTHORNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 44.0 0.0 18.0   0.0 4.0     0.0   3.0   35.0 34.0     7.0   3.0     41.0   17.0   69.0 44 0 18   0 4     0   3   35 34     7 3   41 17   69
692006 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000074 130 LAKEVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 38.0 3.0 9.0   1.0 7.0     0.0   2.0   22.0 38.0     9.0   0.0     33.0   4.0   60.0 38 3 9   1 7     0   2   22 38     9 0   33 4   60
692013 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000077 140 SIBLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 55.0 1.0 7.0   1.0 5.0     0.0   4.0   32.0 41.0     9.0   2.0     30.0   8.0   73.0 55 1 7   1 5     0   4   32 41     9 2   30 8   73
692021 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 36.0 0.0 1.0   0.0 0.0     0.0   0.0   23.0 14.0     0.0   0.0     12.0   6.0   37.0 36 0 1   0 0     0   0   23 14     0 0   12 6   37
692030 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 2017   grade_4 85.0 0.0 3.0   1.0 0.0     0.0   4.0   46.0 47.0     2.0   1.0     33.0   12.0   93.0 85 0 3   1 0     0   4   46 47     2 1   33 12   93
692038 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 2017   grade_4 51.0 0.0 4.0   0.0 0.0     0.0   0.0   22.0 33.0     4.0   0.0     14.0   5.0   55.0 51 0 4   0 0     0   0   22 33     4 0   14 5   55
692047 MN Goodhue 25 school 2728950 255 Independent Districts and Schools PINE ISLAND PUBLIC SCHOOL DIST. 272895001257 10 PINE ISLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_4 87.0 0.0 4.0   0.0 0.0     0.0   2.0   39.0 54.0     0.0   0.0     18.0   8.0   93.0 87 0 4   0 0     0   2   39 54     0 0   18 8   93
692051 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001292 537 BURNSIDE ELEMENTARY. Elementary School (Grades PK-6) Regular School No Elementary 02 04 2017   grade_4 147.0 5.0 22.0   8.0 3.0     0.0   11.0   101.0 95.0     5.0   1.0     73.0   35.0   196.0 147 5 22   8 3     0   11   101 95     5 1   73 35   196
692061 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 2017   grade_4 19.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 13.0     0.0   0.0     10.0   4.0   19.0 19 0 0   0 0     0   0   6 13     0 0   10 4   19
692070 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 2017   grade_4 5.0 0.0 0.0   0.0 0.0     0.0   2.0   2.0 5.0         *         *   7.0 5 0 0   0 0     0   2   2 5                 7
692078 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001886 561 ALICE SMITH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 42.0 20.0 9.0   0.0 7.0     0.0   7.0   42.0 43.0     13.0   3.0     45.0   11.0   85.0 42 20 9   0 7     0   7   42 43     13 3   45 11   85

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