Data source: Big Local News · About: Big Local

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

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
1148391 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 1 KG 04 2015   grade_4 193.0 0.0 5.0   4.0 3.0     0.0   1.0   109.0 97.0         *         *   206.0 193 0 5   4 3     0   1   109 97                 206
1148398 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 1 PK 06 2015   grade_4 64.0 0.0 1.0   1.0 2.0     0.0   0.0   41.0 27.0     2.0   0.0     23.0   7.0   68.0 64 0 1   1 2     0   0   41 27     2 0   23 7   68
1148406 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 1 KG 06 2015   grade_4 70.0 0.0 0.0   1.0 0.0     0.0   4.0   41.0 34.0     0.0   0.0     12.0   8.0   75.0 70 0 0   1 0     0   4   41 34     0 0   12 8   75
1148414 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 1 PK 06 2015   grade_4 52.0 0.0 2.0   0.0 0.0     1.0   2.0   35.0 22.0         *         *   57.0 52 0 2   0 0     1   2   35 22                 57
1148421 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 1 KG 06 2015   grade_4 4.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 2.0         *         *   4.0 4 0 0   0 0     0   0   2 2                 4
1148431 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003509 187 R. ASP ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2015   grade_4 94.0 7.0 13.0   9.0 1.0     0.0   13.0   76.0 61.0     12.0   4.0     68.0   21.0   137.0 94 7 13   9 1     0   13   76 61     12 4   68 21   137
1148438 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 1 KG 05 2015   grade_4 84.0 11.0 16.0   6.0 1.0     0.0   11.0   67.0 62.0     11.0   3.0     63.0   26.0   129.0 84 11 16   6 1     0   11   67 62     11 3   63 26   129
1148444 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 1 KG 05 2015   grade_4 151.0 3.0 9.0   0.0 1.0     0.0   10.0   89.0 85.0     12.0   0.0     51.0   26.0   174.0 151 3 9   0 1     0   10   89 85     12 0   51 26   174
1148452 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 1 PK 06 2015   grade_4 58.0 2.0 0.0   19.0 1.0     0.0   5.0   44.0 41.0     0.0   0.0     51.0   15.0   85.0 58 2 0   19 1     0   5   44 41     0 0   51 15   85
1148461 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 1 PK 05 2015   grade_4 18.0 0.0 2.0   4.0 0.0     0.0   1.0   11.0 14.0     0.0   0.0         4.0   25.0 18 0 2   4 0     0   1   11 14     0 0     4   25
1148469 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 1 PK 06 2015   grade_4 25.0 0.0 4.0   0.0 3.0     0.0   1.0   13.0 20.0     3.0   0.0     20.0   3.0   33.0 25 0 4   0 3     0   1   13 20     3 0   20 3   33
1148483 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 1 PK 04 2015   grade_4 92.0 1.0 1.0   0.0 0.0     0.0   1.0   52.0 43.0         0.0     28.0   16.0   95.0 92 1 1   0 0     0   1   52 43       0   28 16   95
1148489 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 1 KG 04 2015   grade_4 77.0 2.0 1.0   0.0 1.0     0.0   1.0   42.0 40.0     0.0   *     40.0   17.0   82.0 77 2 1   0 1     0   1   42 40     0     40 17   82
1148495 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 1 KG 04 2015   grade_4 39.0 1.0 1.0   1.0 1.0     0.0   1.0   21.0 23.0     0.0   *     31.0   *   44.0 39 1 1   1 1     0   1   21 23     0     31     44
1148501 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 1 KG 04 2015   grade_4 73.0 2.0 0.0   1.0 0.0     1.0   3.0   39.0 41.0     0.0   3.0     37.0   13.0   80.0 73 2 0   1 0     1   3   39 41     0 3   37 13   80
1148507 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 1 KG 04 2015   grade_4 128.0 4.0 1.0   1.0 1.0     0.0   5.0   67.0 73.0     0.0   0.0     79.0   29.0   140.0 128 4 1   1 1     0   5   67 73     0 0   79 29   140
1148514 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 1 PK 04 2015   grade_4 48.0 0.0 0.0   0.0 0.0     0.0   0.0   22.0 26.0     0.0   0.0         10.0   48.0 48 0 0   0 0     0   0   22 26     0 0     10   48
1148521 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 1 PK 06 2015   grade_4 71.0 1.0 2.0   1.0 0.0     0.0   4.0   40.0 39.0     0.0   0.0     49.0   13.0   79.0 71 1 2   1 0     0   4   40 39     0 0   49 13   79
1148530 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 1 PK 04 2015   grade_4 126.0 3.0 0.0   1.0 0.0     0.0   1.0   61.0 70.0     0.0   1.0     38.0   13.0   131.0 126 3 0   1 0     0   1   61 70     0 1   38 13   131
1148536 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 1 KG 06 2015   grade_4 33.0 12.0 2.0   0.0 3.0     0.0   4.0   32.0 22.0     7.0   2.0     28.0   7.0   54.0 33 12 2   0 3     0   4   32 22     7 2   28 7   54
1148544 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 1 KG 06 2015   grade_4 22.0 20.0 9.0   1.0 7.0     0.0   11.0   39.0 31.0     21.0   1.0     44.0   11.0   70.0 22 20 9   1 7     0   11   39 31     21 1   44 11   70
1148552 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 1 KG 06 2015   grade_4 34.0 7.0 12.0   0.0 13.0     1.0   5.0   41.0 31.0     17.0   0.0     32.0   13.0   72.0 34 7 12   0 13     1   5   41 31     17 0   32 13   72
1148560 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 1 KG 06 2015   grade_4 21.0 17.0 5.0   0.0 4.0     1.0   6.0   26.0 28.0     17.0   0.0     28.0   8.0   54.0 21 17 5   0 4     1   6   26 28     17 0   28 8   54
1148568 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 1 KG 06 2015   grade_4 30.0 11.0 15.0   1.0 4.0     0.0   5.0   38.0 28.0     13.0   1.0     41.0   16.0   66.0 30 11 15   1 4     0   5   38 28     13 1   41 16   66
1148576 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 1 KG 06 2015   grade_4 42.0 17.0 5.0   0.0 6.0     0.0   10.0   31.0 49.0     8.0   1.0     28.0   9.0   80.0 42 17 5   0 6     0   10   31 49     8 1   28 9   80
1148584 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 1 KG 06 2015   grade_4 24.0 9.0 7.0   0.0 8.0     0.0   5.0   24.0 29.0     11.0   1.0     24.0   11.0   53.0 24 9 7   0 8     0   5   24 29     11 1   24 11   53
1148592 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 1 KG 06 2015   grade_4 22.0 25.0 34.0   1.0 2.0     1.0   7.0   40.0 52.0     38.0   2.0     71.0   13.0   92.0 22 25 34   1 2     1   7   40 52     38 2   71 13   92
1148600 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 1 KG 06 2015   grade_4 16.0 21.0 25.0   0.0 3.0     0.0   5.0   33.0 37.0     16.0   0.0     53.0   14.0   70.0 16 21 25   0 3     0   5   33 37     16 0   53 14   70
1148608 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 1 KG 06 2015   grade_4 59.0 7.0 9.0   0.0 11.0     0.0   6.0   46.0 46.0     19.0   1.0     19.0   6.0   92.0 59 7 9   0 11     0   6   46 46     19 1   19 6   92
1148617 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 1 PK 05 2015   grade_4 68.0 3.0 8.0   0.0 1.0     0.0   3.0   46.0 37.0     8.0   0.0     27.0   14.0   83.0 68 3 8   0 1     0   3   46 37     8 0   27 14   83
1148625 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 1 PK 05 2015   grade_4 91.0 3.0 3.0   0.0 8.0     0.0   6.0   56.0 55.0     2.0   0.0         16.0   111.0 91 3 3   0 8     0   6   56 55     2 0     16   111
1148633 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 1 PK 05 2015   grade_4 94.0 1.0 4.0   0.0 5.0     0.0   4.0   57.0 51.0         0.0     14.0   16.0   108.0 94 1 4   0 5     0   4   57 51       0   14 16   108
1148641 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 1 PK 06 2015   grade_4 113.0 0.0 3.0   2.0 4.0     0.0   5.0   62.0 65.0         0.0     15.0   21.0   127.0 113 0 3   2 4     0   5   62 65       0   15 21   127
1148645 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 2 04 06 2015   grade_4 17.0 2.0 0.0   0.0 1.0     0.0   2.0   14.0 8.0     0.0   0.0         *   22.0 17 2 0   0 1     0   2   14 8     0 0         22
1148654 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 1 PK 05 2015   grade_4 78.0 5.0 8.0   1.0 3.0     0.0   5.0   56.0 44.0     5.0   0.0     24.0   *   100.0 78 5 8   1 3     0   5   56 44     5 0   24     100
1148661 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 1 KG 05 2015   grade_4 81.0 3.0 1.0   1.0 3.0     1.0   7.0   46.0 51.0         0.0     14.0   16.0   97.0 81 3 1   1 3     1   7   46 51       0   14 16   97
1148668 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 1 KG 05 2015   grade_4 61.0 2.0 6.0   1.0 5.0     0.0   3.0   41.0 37.0     8.0   0.0     16.0   19.0   78.0 61 2 6   1 5     0   3   41 37     8 0   16 19   78
1148675 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778000818 593 ORCHARD LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2015   grade_4 77.0 5.0 10.0   0.0 5.0     0.0   3.0   45.0 55.0     6.0   2.0     20.0   11.0   100.0 77 5 10   0 5     0   3   45 55     6 2   20 11   100
1148682 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 1 KG 05 2015   grade_4 66.0 5.0 3.0   0.0 5.0     0.0   2.0   42.0 39.0     3.0   0.0     19.0   16.0   81.0 66 5 3   0 5     0   2   42 39     3 0   19 16   81
1148689 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 1 KG 05 2015   grade_4 73.0 0.0 2.0   2.0 3.0     1.0   0.0   45.0 36.0         0.0     6.0   16.0   81.0 73 0 2   2 3     1   0   45 36       0   6 16   81
1148696 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 1 KG 05 2015   grade_4 88.0 2.0 3.0   0.0 7.0     0.0   3.0   52.0 51.0     3.0   0.0     5.0   18.0   103.0 88 2 3   0 7     0   3   52 51     3 0   5 18   103
1148703 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 1 KG 05 2015   grade_4 87.0 4.0 3.0   1.0 5.0     0.0   4.0   52.0 52.0     2.0   0.0     11.0   14.0   104.0 87 4 3   1 5     0   4   52 52     2 0   11 14   104
1148710 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 1 KG 05 2015   grade_4 89.0 6.0 11.0   0.0 4.0     1.0   6.0   65.0 52.0     9.0   0.0     19.0   12.0   117.0 89 6 11   0 4     1   6   65 52     9 0   19 12   117
1148718 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 1 PK 06 2015   grade_4 44.0 0.0 0.0   0.0 0.0     0.0   2.0   24.0 22.0     0.0   0.0         5.0   46.0 44 0 0   0 0     0   2   24 22     0 0     5   46
1148726 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 1 KG 05 2015   grade_4 85.0 7.0 6.0   0.0 6.0     0.0   6.0   59.0 51.0         2.0     24.0   18.0   110.0 85 7 6   0 6     0   6   59 51       2   24 18   110
1148733 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 1 KG 05 2015   grade_4 41.0 8.0 4.0   0.0 7.0     0.0   2.0   28.0 34.0     2.0   0.0     11.0   10.0   62.0 41 8 4   0 7     0   2   28 34     2 0   11 10   62
1148740 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 1 KG 05 2015   grade_4 47.0 10.0 4.0   1.0 3.0     0.0   3.0   35.0 33.0         0.0     20.0   16.0   68.0 47 10 4   1 3     0   3   35 33       0   20 16   68
1148747 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 1 KG 05 2015   grade_4 82.0 14.0 14.0   1.0 8.0     1.0   5.0   61.0 64.0     11.0   0.0     36.0   23.0   125.0 82 14 14   1 8     1   5   61 64     11 0   36 23   125
1148754 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 1 KG 05 2015   grade_4 92.0 8.0 12.0   0.0 8.0     0.0   8.0   69.0 59.0     7.0   0.0     36.0   26.0   128.0 92 8 12   0 8     0   8   69 59     7 0   36 26   128
1148761 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001375 710 DIAMOND PATH ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2015   grade_4 89.0 11.0 8.0   1.0 12.0     0.0   11.0   60.0 72.0     4.0   2.0     25.0   17.0   132.0 89 11 8   1 12     0   11   60 72     4 2   25 17   132
1148768 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 1 KG 05 2015   grade_4 109.0 17.0 19.0   0.0 9.0     0.0   14.0   98.0 70.0     17.0   0.0     51.0   23.0   168.0 109 17 19   0 9     0   14   98 70     17 0   51 23   168
1148775 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001374 712 CEDAR PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2015   grade_4 48.0 28.0 15.0   2.0 12.0     2.0   14.0   54.0 67.0     9.0   0.0     53.0   12.0   121.0 48 28 15   2 12     2   14   54 67     9 0   53 12   121
1148782 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 1 KG 05 2015   grade_4 50.0 4.0 4.0   0.0 7.0     0.0   6.0   35.0 36.0     8.0   0.0     14.0   15.0   71.0 50 4 4   0 7     0   6   35 36     8 0   14 15   71
1148789 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001942 714 ECHO PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2015   grade_4 34.0 34.0 18.0   0.0 6.0     1.0   16.0   52.0 57.0     25.0   *     73.0   11.0   109.0 34 34 18   0 6     1   16   52 57     25     73 11   109
1148796 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 1 KG 05 2015   grade_4 85.0 10.0 6.0   1.0 11.0     0.0   8.0   67.0 54.0     5.0   0.0     25.0   25.0   121.0 85 10 6   1 11     0   8   67 54     5 0   25 25   121
1148803 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 1 KG 05 2015   grade_4 72.0 11.0 9.0   0.0 12.0     0.0   15.0   61.0 58.0     12.0   0.0     33.0   18.0   119.0 72 11 9   0 12     0   15   61 58     12 0   33 18   119
1148810 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 1 KG 05 2015   grade_4 52.0 7.0 9.0   0.0 9.0     1.0   9.0   51.0 36.0         1.0     13.0   13.0   87.0 52 7 9   0 9     1   9   51 36       1   13 13   87
1148817 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 1 KG 05 2015   grade_4 83.0 3.0 10.0   0.0 10.0     0.0   3.0   53.0 56.0     5.0   0.0     12.0   10.0   109.0 83 3 10   0 10     0   3   53 56     5 0   12 10   109
1148824 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 1 KG 05 2015   grade_4 127.0 3.0 5.0   0.0 7.0     0.0   9.0   78.0 73.0         0.0         23.0   151.0 127 3 5   0 7     0   9   78 73       0     23   151
1148831 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002302 720 OAK RIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2015   grade_4 44.0 33.0 6.0   0.0 8.0     0.0   12.0   47.0 56.0     7.0   0.0     53.0   16.0   103.0 44 33 6   0 8     0   12   47 56     7 0   53 16   103
1148838 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000512 764 GLACIER HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2015   grade_4 64.0 13.0 15.0   0.0 14.0     0.0   8.0   53.0 61.0     16.0   0.0     29.0   14.0   114.0 64 13 15   0 14     0   8   53 61     16 0   29 14   114
1148845 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 1 KG 05 2015   grade_4 116.0 3.0 10.0   0.0 12.0     0.0   4.0   82.0 63.0     6.0   0.0     20.0   27.0   145.0 116 3 10   0 12     0   4   82 63     6 0   20 27   145
1148852 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 1 KG 04 2015   grade_4 25.0 5.0 35.0   0.0 3.0     0.0   4.0   34.0 38.0     26.0   0.0     50.0   17.0   72.0 25 5 35   0 3     0   4   34 38     26 0   50 17   72
1148858 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 1 PK 04 2015   grade_4 54.0 1.0 5.0   0.0 4.0     0.0   3.0   37.0 30.0     1.0   0.0     5.0   8.0   67.0 54 1 5   0 4     0   3   37 30     1 0   5 8   67
1148864 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 1 KG 04 2015   grade_4 25.0 10.0 34.0   0.0 0.0     0.0   4.0   41.0 32.0     18.0   1.0     46.0   6.0   73.0 25 10 34   0 0     0   4   41 32     18 1   46 6   73
1148870 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 1 PK 04 2015   grade_4 59.0 1.0 10.0   0.0 1.0     0.0   5.0   36.0 40.0     1.0   0.0     13.0   8.0   76.0 59 1 10   0 1     0   5   36 40     1 0   13 8   76
1148876 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 1 KG 04 2015   grade_4 32.0 15.0 14.0   0.0 9.0     0.0   9.0   39.0 40.0     18.0   0.0     38.0   14.0   79.0 32 15 14   0 9     0   9   39 40     18 0   38 14   79
1148880 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 1 02 05 2015   grade_4 17.0 0.0 0.0   0.0 2.0     0.0   1.0   11.0 9.0     0.0   0.0     1.0   2.0   20.0 17 0 0   0 2     0   1   11 9     0 0   1 2   20
1148887 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 1 KG 05 2015   grade_4 58.0 12.0 18.0   0.0 4.0     0.0   10.0   53.0 49.0     8.0   1.0     43.0   16.0   102.0 58 12 18   0 4     0   10   53 49     8 1   43 16   102
1148894 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 1 KG 05 2015   grade_4 54.0 2.0 22.0   0.0 2.0     0.0   9.0   42.0 47.0     14.0   1.0     33.0   10.0   89.0 54 2 22   0 2     0   9   42 47     14 1   33 10   89
1148901 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 1 KG 05 2015   grade_4 21.0 4.0 15.0   0.0 1.0     0.0   6.0   23.0 24.0     8.0   0.0     25.0   7.0   47.0 21 4 15   0 1     0   6   23 24     8 0   25 7   47
1148908 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 1 KG 04 2015   grade_4 95.0 3.0 1.0   0.0 2.0     0.0   5.0   53.0 53.0         *     29.0   9.0   106.0 95 3 1   0 2     0   5   53 53           29 9   106
1148914 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 1 KG 04 2015   grade_4 83.0 0.0 3.0   0.0 0.0     0.0   3.0   50.0 39.0     2.0   0.0         9.0   89.0 83 0 3   0 0     0   3   50 39     2 0     9   89
1148920 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 1 KG 04 2015   grade_4 79.0 1.0 7.0   0.0 1.0     0.0   4.0   55.0 37.0     3.0   0.0     23.0   13.0   92.0 79 1 7   0 1     0   4   55 37     3 0   23 13   92
1148931 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 1 PK 06 2015   grade_4 51.0 1.0 7.0   0.0 0.0     0.0   2.0   28.0 33.0     2.0   0.0     16.0   3.0   61.0 51 1 7   0 0     0   2   28 33     2 0   16 3   61
1148940 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 1 PK 04 2015   grade_4 159.0 0.0 4.0   0.0 0.0     0.0   2.0   82.0 83.0     2.0   1.0     29.0   19.0   165.0 159 0 4   0 0     0   2   82 83     2 1   29 19   165
1148946 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 1 KG 05 2015   grade_4 22.0 0.0 0.0   0.0 1.0     0.0   0.0   9.0 14.0     0.0   0.0     9.0   7.0   23.0 22 0 0   0 1     0   0   9 14     0 0   9 7   23
1148953 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 1 KG 05 2015   grade_4 21.0 0.0 0.0   0.0 0.0     0.0   1.0   9.0 13.0     0.0   0.0     4.0   1.0   22.0 21 0 0   0 0     0   1   9 13     0 0   4 1   22
1148960 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 1 KG 05 2015   grade_4 74.0 0.0 1.0   1.0 0.0     0.0   2.0   41.0 37.0     0.0   1.0     21.0   12.0   78.0 74 0 1   1 0     0   2   41 37     0 1   21 12   78
1148967 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 1 KG 05 2015   grade_4 17.0 0.0 2.0   0.0 0.0     0.0   0.0   10.0 9.0     0.0   1.0     10.0   3.0   19.0 17 0 2   0 0     0   0   10 9     0 1   10 3   19
1148974 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 1 KG 05 2015   grade_4 64.0 0.0 0.0   0.0 0.0     0.0   2.0   35.0 31.0     0.0   1.0     31.0   11.0   66.0 64 0 0   0 0     0   2   35 31     0 1   31 11   66
1148981 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 1 KG 05 2015   grade_4 65.0 0.0 3.0   1.0 4.0     0.0   3.0   35.0 41.0     0.0   1.0     19.0   13.0   76.0 65 0 3   1 4     0   3   35 41     0 1   19 13   76
1148991 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 1 PK 06 2015   grade_4 64.0 1.0 1.0   0.0 1.0     0.0   0.0   42.0 25.0     1.0   1.0     25.0   12.0   67.0 64 1 1   0 1     0   0   42 25     1 1   25 12   67
1149000 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 1 PK 06 2015   grade_4 83.0 1.0 1.0   0.0 0.0     0.0   0.0   38.0 47.0     0.0   0.0     22.0   9.0   85.0 83 1 1   0 0     0   0   38 47     0 0   22 9   85
1149009 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 1 PK 06 2015   grade_4 21.0 0.0 1.0   0.0 0.0     0.0   0.0   13.0 9.0     0.0   0.0     13.0   4.0   22.0 21 0 1   0 0     0   0   13 9     0 0   13 4   22
1149018 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 1 PK 06 2015   grade_4 17.0 0.0 0.0   0.0 0.0     0.0   0.0   10.0 7.0     0.0   0.0     8.0   3.0   17.0 17 0 0   0 0     0   0   10 7     0 0   8 3   17
1149027 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 1 PK 05 2015   grade_4 51.0 1.0 1.0   0.0 0.0     0.0   0.0   24.0 29.0     0.0   0.0     22.0   4.0   53.0 51 1 1   0 0     0   0   24 29     0 0   22 4   53
1149034 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 1 KG 05 2015   grade_4 26.0 2.0 20.0   0.0 1.0     0.0   5.0   23.0 31.0     5.0   1.0     43.0   9.0   54.0 26 2 20   0 1     0   5   23 31     5 1   43 9   54
1149041 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 1 KG 05 2015   grade_4 40.0 2.0 9.0   0.0 4.0     0.0   1.0   29.0 27.0     4.0   1.0     37.0   9.0   56.0 40 2 9   0 4     0   1   29 27     4 1   37 9   56
1149048 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 1 KG 05 2015   grade_4 56.0 5.0 14.0   0.0 4.0     0.0   3.0   49.0 33.0     7.0   0.0     41.0   15.0   82.0 56 5 14   0 4     0   3   49 33     7 0   41 15   82
1149055 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 1 KG 05 2015   grade_4 43.0 0.0 12.0   0.0 0.0     0.0   0.0   26.0 29.0     1.0   0.0     18.0   11.0   55.0 43 0 12   0 0     0   0   26 29     1 0   18 11   55
1149063 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 1 PK 06 2015   grade_4 41.0 0.0 2.0   0.0 0.0     0.0   1.0   16.0 28.0     0.0   0.0     17.0   8.0   44.0 41 0 2   0 0     0   1   16 28     0 0   17 8   44
1149072 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 1 PK 05 2015   grade_4 76.0 0.0 4.0   1.0 0.0     0.0   4.0   42.0 43.0     0.0   0.0     20.0   6.0   85.0 76 0 4   1 0     0   4   42 43     0 0   20 6   85
1149080 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 1 PK 06 2015   grade_4 44.0 0.0 3.0   0.0 0.0     0.0   0.0   25.0 22.0     3.0   0.0     17.0   3.0   47.0 44 0 3   0 0     0   0   25 22     3 0   17 3   47
1149089 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 1 PK 04 2015   grade_4 83.0 0.0 2.0   0.0 1.0     0.0   1.0   46.0 41.0     0.0   0.0     18.0   9.0   87.0 83 0 2   0 1     0   1   46 41     0 0   18 9   87
1149093 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 1 02 04 2015   grade_4 162.0 4.0 18.0   5.0 3.0     0.0   13.0   99.0 106.0     4.0   0.0     95.0   31.0   205.0 162 4 18   5 3     0   13   99 106     4 0   95 31   205
1149104 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 1 PK 06 2015   grade_4 14.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 8.0     0.0   0.0         4.0   14.0 14 0 0   0 0     0   0   6 8     0 0     4   14
1149113 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 1 PK 06 2015   grade_4 7.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 3.0         *         *   7.0 7 0 0   0 0     0   0   4 3                 7
1149121 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 1 PK 06 2015   grade_4 32.0 22.0 14.0   0.0 3.0     0.0   7.0   39.0 39.0     13.0   0.0     44.0   7.0   78.0 32 22 14   0 3     0   7   39 39     13 0   44 7   78
1149129 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001881 563 GLEN LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 06 2015   grade_4 40.0 13.0 4.0   0.0 6.0     0.0   3.0   33.0 33.0     5.0   1.0     12.0   7.0   66.0 40 13 4   0 6     0   3   33 33     5 1   12 7   66

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