Data source: Big Local News · About: Big Local

6,592 rows where grade = "grade_1" and state = "MN"

View and edit SQL

year

grade

  • grade_1 · 6,492
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
691320 MN Cass 11 school 2728350 116 Independent Districts and Schools PILLAGER PUBLIC SCHOOL DISTRICT 272835001253 10 PILLAGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 81.0 0.0 2.0   0.0 0.0     0.0   2.0   42.0 43.0     0.0   1.0     37.0   16.0   85.0 81 0 2   0 0     0   2   42 43     0 1   37 16   85
691328 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_1 14.0 0.0 0.0   4.0 0.0     0.0   6.0   10.0 14.0     0.0   0.0     17.0   3.0   24.0 14 0 0   4 0     0   6   10 14     0 0   17 3   24
691335 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001073 10 RAMSEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2017   grade_1 85.0 2.0 25.0   2.0 0.0     0.0   3.0   64.0 53.0     16.0   0.0     69.0   25.0   117.0 85 2 25   2 0     0   3   64 53     16 0   69 25   117
691345 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_1 185.0 2.0 8.0   2.0 2.0     0.0   8.0   117.0 90.0     3.0   3.0     64.0   30.0   207.0 185 2 8   2 2     0   8   117 90     3 3   64 30   207
691352 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_1 62.0 0.0 0.0   0.0 1.0     0.0   3.0   33.0 33.0     0.0   1.0     25.0   11.0   66.0 62 0 0   0 1     0   3   33 33     0 1   25 11   66
691360 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_1 53.0 0.0 0.0   0.0 0.0     0.0   2.0   31.0 24.0     0.0   0.0     8.0   8.0   55.0 53 0 0   0 0     0   2   31 24     0 0   8 8   55
691368 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_1 57.0 0.0 3.0   0.0 0.0     0.0   3.0   29.0 34.0         *         *   63.0 57 0 3   0 0     0   3   29 34                 63
691376 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_1 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 2 0 0   0 0     0   0   1 1                 2
691384 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_1 119.0 13.0 20.0   9.0 2.0     0.0   11.0   92.0 82.0     14.0   3.0     82.0   32.0   174.0 119 13 20   9 2     0   11   92 82     14 3   82 32   174
691390 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_1 140.0 21.0 33.0   6.0 1.0     0.0   25.0   116.0 110.0     26.0   4.0     118.0   32.0   226.0 140 21 33   6 1     0   25   116 110     26 4   118 32   226
691396 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_1 164.0 6.0 14.0   1.0 1.0     0.0   12.0   113.0 85.0     15.0   1.0     63.0   19.0   198.0 164 6 14   1 1     0   12   113 85     15 1   63 19   198
691405 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_1 46.0 0.0 2.0   13.0 0.0     0.0   5.0   40.0 26.0     0.0   0.0     38.0   15.0   66.0 46 0 2   13 0     0   5   40 26     0 0   38 15   66
691415 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_1 20.0 0.0 0.0   1.0 0.0     0.0   4.0   10.0 15.0     0.0   0.0     12.0   3.0   25.0 20 0 0   1 0     0   4   10 15     0 0   12 3   25
691423 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_1 22.0 0.0 5.0   0.0 6.0     0.0   3.0   14.0 22.0     6.0   0.0     20.0   5.0   36.0 22 0 5   0 6     0   3   14 22     6 0   20 5   36
691431 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278001816 30 WINFAIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_1 60.0 0.0 13.0   0.0 1.0     2.0   5.0   40.0 41.0     11.0   0.0     43.0   12.0   81.0 60 0 13   0 1     2   5   40 41     11 0   43 12   81
691437 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_1 75.0 0.0 1.0   1.0 2.0     0.0   2.0   42.0 39.0         0.0     26.0   14.0   81.0 75 0 1   1 2     0   2   42 39       0   26 14   81
691443 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_1 73.0 0.0 1.0   4.0 0.0     0.0   1.0   28.0 51.0         3.0     38.0   16.0   79.0 73 0 1   4 0     0   1   28 51       3   38 16   79
691449 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_1 55.0 0.0 0.0   1.0 0.0     0.0   4.0   29.0 31.0     0.0   0.0     33.0   18.0   60.0 55 0 0   1 0     0   4   29 31     0 0   33 18   60
691455 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_1 77.0 1.0 0.0   0.0 0.0     0.0   2.0   36.0 44.0     0.0   0.0     37.0   10.0   80.0 77 1 0   0 0     0   2   36 44     0 0   37 10   80
691461 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_1 125.0 2.0 2.0   2.0 0.0     0.0   5.0   73.0 63.0     0.0   1.0     71.0   34.0   136.0 125 2 2   2 0     0   5   73 63     0 1   71 34   136
691468 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_1 49.0 0.0 0.0   0.0 0.0     0.0   1.0   32.0 18.0     0.0   0.0     13.0   5.0   50.0 49 0 0   0 0     0   1   32 18     0 0   13 5   50
691475 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_1 57.0 0.0 1.0   0.0 0.0     0.0   5.0   37.0 26.0     0.0   0.0     31.0   8.0   63.0 57 0 1   0 0     0   5   37 26     0 0   31 8   63
691484 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_1 114.0 2.0 0.0   3.0 0.0     0.0   0.0   69.0 50.0     0.0   0.0     40.0   20.0   119.0 114 2 0   3 0     0   0   69 50     0 0   40 20   119
691492 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_1 32.0 31.0 6.0   0.0 1.0     0.0   5.0   39.0 36.0     18.0   0.0     40.0   8.0   75.0 32 31 6   0 1     0   5   39 36     18 0   40 8   75
691499 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_1 17.0 31.0 11.0   0.0 2.0     0.0   3.0   32.0 32.0     19.0   0.0     44.0   9.0   64.0 17 31 11   0 2     0   3   32 32     19 0   44 9   64
691506 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_1 17.0 17.0 14.0   0.0 8.0     0.0   6.0   39.0 23.0     15.0   3.0     48.0   10.0   62.0 17 17 14   0 8     0   6   39 23     15 3   48 10   62
691513 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_1 22.0 12.0 5.0   0.0 3.0     0.0   4.0   24.0 22.0     5.0   0.0         3.0   46.0 22 12 5   0 3     0   4   24 22     5 0     3   46
691520 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_1 29.0 14.0 13.0   1.0 3.0     0.0   5.0   28.0 37.0     12.0   0.0     35.0   8.0   65.0 29 14 13   1 3     0   5   28 37     12 0   35 8   65
691527 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_1 33.0 17.0 8.0   0.0 3.0     0.0   8.0   40.0 29.0     13.0   0.0     34.0   7.0   69.0 33 17 8   0 3     0   8   40 29     13 0   34 7   69
691536 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_1 16.0 11.0 9.0   0.0 5.0     0.0   5.0   27.0 19.0     15.0   *     27.0   7.0   46.0 16 11 9   0 5     0   5   27 19     15     27 7   46
691545 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_1 16.0 21.0 30.0   1.0 10.0     0.0   2.0   40.0 40.0     22.0   2.0     61.0   14.0   80.0 16 21 30   1 10     0   2   40 40     22 2   61 14   80
691554 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_1 16.0 29.0 34.0   0.0 1.0     0.0   4.0   45.0 39.0     50.0   *     73.0   13.0   84.0 16 29 34   0 1     0   4   45 39     50     73 13   84
691561 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_1 49.0 6.0 6.0   0.0 12.0     0.0   7.0   38.0 42.0     13.0   0.0         8.0   80.0 49 6 6   0 12     0   7   38 42     13 0     8   80
691569 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_1 79.0 4.0 7.0   0.0 1.0     0.0   5.0   48.0 48.0     5.0   0.0     23.0   13.0   96.0 79 4 7   0 1     0   5   48 48     5 0   23 13   96
691577 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_1 65.0 2.0 3.0   0.0 7.0     0.0   9.0   49.0 37.0     6.0   0.0     9.0   *   86.0 65 2 3   0 7     0   9   49 37     6 0   9     86
691585 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_1 83.0 2.0 6.0   1.0 5.0     0.0   4.0   52.0 49.0     5.0   0.0     13.0   *   101.0 83 2 6   1 5     0   4   52 49     5 0   13     101
691593 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_1 118.0 1.0 6.0   0.0 3.0     0.0   5.0   61.0 72.0     1.0   0.0     13.0   21.0   133.0 118 1 6   0 3     0   5   61 72     1 0   13 21   133
691608 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_1 76.0 1.0 7.0   0.0 9.0     0.0   6.0   49.0 50.0     9.0   1.0     19.0   12.0   99.0 76 1 7   0 9     0   6   49 50     9 1   19 12   99
691615 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_1 77.0 4.0 4.0   0.0 3.0     0.0   6.0   51.0 43.0     1.0   0.0     12.0   13.0   94.0 77 4 4   0 3     0   6   51 43     1 0   12 13   94
691622 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_1 45.0 2.0 6.0   1.0 4.0     0.0   4.0   34.0 28.0     6.0   *     18.0   8.0   62.0 45 2 6   1 4     0   4   34 28     6     18 8   62
691629 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_1 55.0 2.0 9.0   0.0 4.0     0.0   2.0   36.0 36.0     9.0   *     18.0   2.0   72.0 55 2 9   0 4     0   2   36 36     9     18 2   72
691636 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_1 78.0 8.0 7.0   0.0 3.0     0.0   4.0   58.0 42.0     3.0   0.0     25.0   12.0   100.0 78 8 7   0 3     0   4   58 42     3 0   25 12   100
691643 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_1 70.0 1.0 6.0   0.0 5.0     0.0   6.0   41.0 47.0     1.0   0.0     9.0   18.0   88.0 70 1 6   0 5     0   6   41 47     1 0   9 18   88
691650 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_1 81.0 4.0 5.0   0.0 3.0     0.0   4.0   54.0 43.0     5.0   0.0         16.0   97.0 81 4 5   0 3     0   4   54 43     5 0     16   97
691657 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_1 88.0 4.0 7.0   0.0 6.0     0.0   5.0   65.0 45.0     7.0   0.0         10.0   110.0 88 4 7   0 6     0   5   65 45     7 0     10   110
691664 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_1 48.0 8.0 23.0   0.0 3.0     0.0   4.0   44.0 42.0     13.0   *     27.0   10.0   86.0 48 8 23   0 3     0   4   44 42     13     27 10   86
691672 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_1 52.0 1.0 3.0   0.0 0.0     0.0   2.0   22.0 36.0     0.0   0.0     12.0   5.0   58.0 52 1 3   0 0     0   2   22 36     0 0   12 5   58
691680 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_1 86.0 14.0 7.0   1.0 7.0     0.0   15.0   65.0 65.0     14.0   0.0     33.0   12.0   130.0 86 14 7   1 7     0   15   65 65     14 0   33 12   130
691687 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_1 53.0 8.0 6.0   0.0 4.0     0.0   3.0   31.0 43.0     7.0   0.0     14.0   12.0   74.0 53 8 6   0 4     0   3   31 43     7 0   14 12   74
691694 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_1 41.0 17.0 11.0   1.0 8.0     0.0   1.0   40.0 39.0     19.0   0.0     33.0   19.0   79.0 41 17 11   1 8     0   1   40 39     19 0   33 19   79
691701 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_1 76.0 13.0 12.0   0.0 4.0     0.0   2.0   58.0 49.0     17.0   0.0     28.0   10.0   107.0 76 13 12   0 4     0   2   58 49     17 0   28 10   107
691708 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_1 111.0 10.0 12.0   2.0 13.0     1.0   12.0   79.0 82.0     14.0   0.0     40.0   18.0   161.0 111 10 12   2 13     1   12   79 82     14 0   40 18   161
691715 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_1 87.0 18.0 7.0   1.0 18.0     0.0   13.0   62.0 82.0     10.0   0.0     26.0   13.0   144.0 87 18 7   1 18     0   13   62 82     10 0   26 13   144
691722 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_1 64.0 19.0 35.0   0.0 3.0     0.0   11.0   64.0 68.0     30.0   0.0     59.0   18.0   132.0 64 19 35   0 3     0   11   64 68     30 0   59 18   132
691729 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_1 49.0 32.0 11.0   0.0 16.0     0.0   6.0   61.0 53.0     10.0   0.0     37.0   9.0   114.0 49 32 11   0 16     0   6   61 53     10 0   37 9   114
691736 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_1 57.0 7.0 5.0   0.0 6.0     0.0   11.0   47.0 39.0         0.0     16.0   16.0   86.0 57 7 5   0 6     0   11   47 39       0   16 16   86
691745 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_1 45.0 33.0 23.0   1.0 3.0     0.0   9.0   60.0 54.0     36.0   *     67.0   13.0   114.0 45 33 23   1 3     0   9   60 54     36     67 13   114
691752 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_1 98.0 6.0 5.0   0.0 7.0     0.0   4.0   65.0 55.0     11.0   0.0     10.0   17.0   120.0 98 6 5   0 7     0   4   65 55     11 0   10 17   120
691759 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_1 85.0 11.0 7.0   2.0 7.0     0.0   7.0   62.0 57.0     7.0   0.0     25.0   11.0   119.0 85 11 7   2 7     0   7   62 57     7 0   25 11   119
691766 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_1 67.0 5.0 9.0   0.0 8.0     0.0   7.0   39.0 57.0         *     16.0   7.0   96.0 67 5 9   0 8     0   7   39 57           16 7   96
691773 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_1 76.0 5.0 12.0   0.0 6.0     0.0   7.0   53.0 53.0     10.0   0.0     21.0   12.0   106.0 76 5 12   0 6     0   7   53 53     10 0   21 12   106
691780 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_1 108.0 1.0 1.0   0.0 9.0     0.0   8.0   65.0 62.0     6.0   0.0     10.0   9.0   127.0 108 1 1   0 9     0   8   65 62     6 0   10 9   127
691787 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_1 42.0 22.0 10.0   1.0 7.0     0.0   10.0   48.0 44.0     19.0   1.0     45.0   17.0   92.0 42 22 10   1 7     0   10   48 44     19 1   45 17   92
691794 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_1 55.0 13.0 9.0   1.0 38.0     2.0   5.0   65.0 58.0     29.0   0.0     26.0   16.0   123.0 55 13 9   1 38     2   5   65 58     29 0   26 16   123
691801 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_1 100.0 4.0 4.0   1.0 10.0     0.0   5.0   62.0 62.0     9.0   0.0     14.0   12.0   124.0 100 4 4   1 10     0   5   62 62     9 0   14 12   124
691808 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_1 31.0 8.0 22.0   0.0 8.0     0.0   4.0   34.0 39.0     20.0   0.0     39.0   19.0   73.0 31 8 22   0 8     0   4   34 39     20 0   39 19   73
691814 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_1 68.0 3.0 2.0   0.0 0.0     0.0   7.0   40.0 40.0     1.0   0.0     16.0   10.0   80.0 68 3 2   0 0     0   7   40 40     1 0   16 10   80
691820 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_1 28.0 14.0 38.0   0.0 1.0     0.0   5.0   38.0 48.0     26.0   1.0     50.0   8.0   86.0 28 14 38   0 1     0   5   38 48     26 1   50 8   86
691826 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_1 61.0 3.0 6.0   0.0 0.0     0.0   10.0   39.0 41.0     5.0   0.0     15.0   4.0   80.0 61 3 6   0 0     0   10   39 41     5 0   15 4   80
691832 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_1 31.0 20.0 5.0   0.0 8.0     0.0   13.0   41.0 36.0     17.0   0.0     33.0   16.0   77.0 31 20 5   0 8     0   13   41 36     17 0   33 16   77
691843 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_1 50.0 12.0 20.0   0.0 1.0     0.0   10.0   39.0 54.0     11.0   0.0     44.0   12.0   93.0 50 12 20   0 1     0   10   39 54     11 0   44 12   93
691850 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_1 47.0 7.0 22.0   0.0 9.0     0.0   6.0   51.0 40.0     15.0   0.0     46.0   9.0   91.0 47 7 22   0 9     0   6   51 40     15 0   46 9   91
691857 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_1 13.0 4.0 21.0   0.0 1.0     0.0   3.0   26.0 16.0     11.0   0.0     24.0   6.0   42.0 13 4 21   0 1     0   3   26 16     11 0   24 6   42
691864 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_1 67.0 3.0 5.0   1.0 1.0     0.0   1.0   38.0 40.0     0.0   0.0     30.0   11.0   78.0 67 3 5   1 1     0   1   38 40     0 0   30 11   78
691870 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_1 88.0 2.0 5.0   2.0 2.0     0.0   3.0   53.0 49.0     3.0   0.0     26.0   11.0   102.0 88 2 5   2 2     0   3   53 49     3 0   26 11   102
691876 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_1 82.0 0.0 5.0   0.0 2.0     0.0   7.0   46.0 50.0     1.0   2.0     24.0   14.0   96.0 82 0 5   0 2     0   7   46 50     1 2   24 14   96
691883 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_1 39.0 0.0 5.0   0.0 0.0     0.0   1.0   24.0 21.0     0.0   1.0     18.0   7.0   45.0 39 0 5   0 0     0   1   24 21     0 1   18 7   45
691891 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_1 130.0 1.0 10.0   1.0 1.0     0.0   2.0   83.0 62.0     1.0   0.0     20.0   23.0   145.0 130 1 10   1 1     0   2   83 62     1 0   20 23   145
691897 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_1 18.0 0.0 2.0   0.0 0.0     0.0   0.0   6.0 14.0     0.0   0.0     7.0   3.0   20.0 18 0 2   0 0     0   0   6 14     0 0   7 3   20
691904 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_1 12.0 1.0 1.0   0.0 0.0     0.0   0.0   6.0 8.0     0.0   0.0     4.0   2.0   14.0 12 1 1   0 0     0   0   6 8     0 0   4 2   14
691911 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_1 68.0 2.0 2.0   0.0 1.0     0.0   6.0   41.0 38.0     1.0   2.0     29.0   12.0   79.0 68 2 2   0 1     0   6   41 38     1 2   29 12   79
691918 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_1 25.0 0.0 1.0   0.0 0.0     0.0   0.0   15.0 11.0     0.0   0.0     5.0   1.0   26.0 25 0 1   0 0     0   0   15 11     0 0   5 1   26
691925 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_1 64.0 0.0 4.0   0.0 0.0     0.0   2.0   32.0 38.0     0.0   0.0     35.0   14.0   70.0 64 0 4   0 0     0   2   32 38     0 0   35 14   70
691932 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_1 83.0 1.0 5.0   1.0 0.0     0.0   3.0   51.0 42.0     0.0   1.0     32.0   16.0   93.0 83 1 5   1 0     0   3   51 42     0 1   32 16   93
691942 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_1 53.0 1.0 0.0   0.0 0.0     0.0   1.0   22.0 33.0     0.0   0.0     17.0   9.0   55.0 53 1 0   0 0     0   1   22 33     0 0   17 9   55
691951 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_1 51.0 0.0 1.0   0.0 0.0     0.0   1.0   26.0 27.0     0.0   0.0     7.0   2.0   53.0 51 0 1   0 0     0   1   26 27     0 0   7 2   53
691960 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_1 23.0 0.0 0.0   0.0 0.0     0.0   0.0   13.0 10.0     0.0   0.0         2.0   23.0 23 0 0   0 0     0   0   13 10     0 0     2   23
691969 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_1 18.0 0.0 2.0   0.0 0.0     0.0   0.0   15.0 5.0     1.0   0.0     8.0   4.0   20.0 18 0 2   0 0     0   0   15 5     1 0   8 4   20
691978 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_1 53.0 0.0 0.0   0.0 0.0     0.0   0.0   30.0 23.0     0.0   0.0         5.0   53.0 53 0 0   0 0     0   0   30 23     0 0     5   53
691987 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_1 24.0 3.0 23.0   0.0 4.0     0.0   1.0   31.0 24.0     11.0   *     42.0   7.0   55.0 24 3 23   0 4     0   1   31 24     11     42 7   55
691996 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_1 47.0 1.0 16.0   0.0 1.0     0.0   1.0   29.0 37.0     10.0   *     41.0   11.0   66.0 47 1 16   0 1     0   1   29 37     10     41 11   66
692003 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_1 52.0 4.0 13.0   0.0 4.0     0.0   2.0   39.0 36.0     6.0   0.0     34.0   8.0   75.0 52 4 13   0 4     0   2   39 36     6 0   34 8   75
692010 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_1 44.0 1.0 11.0   0.0 3.0     0.0   2.0   29.0 32.0     8.0   0.0     27.0   10.0   61.0 44 1 11   0 3     0   2   29 32     8 0   27 10   61
692018 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_1 37.0 0.0 1.0   0.0 0.0     0.0   0.0   20.0 18.0     0.0   0.0     11.0   2.0   38.0 37 0 1   0 0     0   0   20 18     0 0   11 2   38
692027 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_1 80.0 1.0 2.0   0.0 0.0     0.0   1.0   50.0 34.0     0.0   0.0     24.0   9.0   84.0 80 1 2   0 0     0   1   50 34     0 0   24 9   84
692035 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_1 43.0 0.0 5.0   0.0 0.0     0.0   1.0   23.0 26.0     1.0   0.0     9.0   1.0   49.0 43 0 5   0 0     0   1   23 26     1 0   9 1   49
692044 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_1 104.0 5.0 4.0   0.0 1.0     0.0   3.0   61.0 56.0     0.0   1.0     21.0   14.0   117.0 104 5 4   0 1     0   3   61 56     0 1   21 14   117
692054 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001297 541 SUNNYSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_1 146.0 6.0 12.0   5.0 0.0     0.0   9.0   78.0 100.0     4.0   6.0     71.0   28.0   178.0 146 6 12   5 0     0   9   78 100     4 6   71 28   178
692058 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_1 27.0 0.0 0.0   0.0 0.0     0.0   0.0   12.0 15.0     0.0   0.0     14.0   5.0   27.0 27 0 0   0 0     0   0   12 15     0 0   14 5   27
692067 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_1 10.0 0.0 1.0   1.0 0.0     0.0   0.0   6.0 6.0     0.0   0.0     5.0   1.0   12.0 10 0 1   1 0     0   0   6 6     0 0   5 1   12

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