Data source: Big Local News · About: Big Local

6,719 rows where grade = "grade_2" and state = "MN"

View and edit SQL

year

grade

  • grade_2 · 6,619
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
691329 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_2 12.0 0.0 0.0   5.0 0.0     0.0   7.0   13.0 11.0     0.0   0.0     17.0   3.0   24.0 12 0 0   5 0     0   7   13 11     0 0   17 3   24
691336 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_2 82.0 2.0 18.0   2.0 0.0     1.0   3.0   57.0 51.0     14.0   0.0     53.0   25.0   108.0 82 2 18   2 0     1   3   57 51     14 0   53 25   108
691346 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_2 175.0 0.0 3.0   0.0 4.0     0.0   11.0   101.0 92.0     3.0   0.0     61.0   27.0   193.0 175 0 3   0 4     0   11   101 92     3 0   61 27   193
691353 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_2 62.0 0.0 4.0   0.0 0.0     0.0   0.0   40.0 26.0     2.0   0.0     26.0   4.0   66.0 62 0 4   0 0     0   0   40 26     2 0   26 4   66
691361 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_2 61.0 1.0 2.0   0.0 0.0     0.0   4.0   38.0 30.0     0.0   0.0     8.0   9.0   68.0 61 1 2   0 0     0   4   38 30     0 0   8 9   68
691369 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_2 71.0 0.0 3.0   0.0 0.0     0.0   1.0   45.0 30.0         *         *   75.0 71 0 3   0 0     0   1   45 30                 75
691377 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_2 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
691385 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_2 116.0 10.0 15.0   9.0 2.0     0.0   13.0   88.0 77.0     11.0   4.0     73.0   27.0   165.0 116 10 15   9 2     0   13   88 77     11 4   73 27   165
691391 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_2 115.0 26.0 22.0   5.0 1.0     0.0   16.0   81.0 104.0     20.0   3.0     89.0   36.0   185.0 115 26 22   5 1     0   16   81 104     20 3   89 36   185
691397 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_2 164.0 6.0 7.0   2.0 0.0     0.0   6.0   92.0 93.0     14.0   1.0     58.0   26.0   185.0 164 6 7   2 0     0   6   92 93     14 1   58 26   185
691406 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_2 63.0 4.0 1.0   15.0 0.0     0.0   9.0   50.0 42.0     0.0   0.0     51.0   9.0   92.0 63 4 1   15 0     0   9   50 42     0 0   51 9   92
691416 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_2 19.0 0.0 1.0   2.0 0.0     0.0   4.0   14.0 12.0     0.0   0.0     11.0   0.0   26.0 19 0 1   2 0     0   4   14 12     0 0   11 0   26
691424 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_2 19.0 0.0 8.0   0.0 1.0     0.0   2.0   14.0 16.0     5.0   0.0     15.0   6.0   30.0 19 0 8   0 1     0   2   14 16     5 0   15 6   30
691432 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_2 56.0 0.0 18.0   0.0 2.0     1.0   1.0   47.0 31.0     16.0   0.0     41.0   9.0   78.0 56 0 18   0 2     1   1   47 31     16 0   41 9   78
691438 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_2 87.0 0.0 2.0   0.0 1.0     0.0   2.0   51.0 41.0         0.0     28.0   14.0   92.0 87 0 2   0 1     0   2   51 41       0   28 14   92
691444 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_2 76.0 0.0 1.0   0.0 0.0     0.0   3.0   34.0 46.0     0.0   0.0     40.0   18.0   80.0 76 0 1   0 0     0   3   34 46     0 0   40 18   80
691450 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_2 61.0 0.0 1.0   0.0 0.0     0.0   2.0   33.0 31.0     0.0   0.0     47.0   *   64.0 61 0 1   0 0     0   2   33 31     0 0   47     64
691456 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_2 82.0 1.0 1.0   0.0 0.0     0.0   3.0   51.0 36.0     0.0   *     35.0   12.0   87.0 82 1 1   0 0     0   3   51 36     0     35 12   87
691462 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_2 107.0 6.0 1.0   0.0 1.0     0.0   3.0   63.0 55.0     0.0   1.0     68.0   28.0   118.0 107 6 1   0 1     0   3   63 55     0 1   68 28   118
691469 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_2 67.0 0.0 0.0   0.0 0.0     0.0   1.0   38.0 30.0     0.0   0.0         *   68.0 67 0 0   0 0     0   1   38 30     0 0         68
691476 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_2 78.0 0.0 3.0   0.0 0.0     0.0   2.0   38.0 45.0     0.0   0.0     44.0   15.0   83.0 78 0 3   0 0     0   2   38 45     0 0   44 15   83
691485 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_2 107.0 4.0 0.0   1.0 0.0     0.0   0.0   65.0 47.0     0.0   2.0     38.0   11.0   112.0 107 4 0   1 0     0   0   65 47     0 2   38 11   112
691493 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_2 25.0 31.0 7.0   0.0 2.0     0.0   4.0   40.0 29.0     26.0   *     38.0   4.0   69.0 25 31 7   0 2     0   4   40 29     26     38 4   69
691500 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_2 24.0 27.0 7.0   0.0 8.0     1.0   5.0   36.0 36.0     17.0   0.0     41.0   11.0   72.0 24 27 7   0 8     1   5   36 36     17 0   41 11   72
691507 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_2 29.0 14.0 8.0   0.0 7.0     0.0   5.0   39.0 24.0     17.0   2.0     35.0   6.0   63.0 29 14 8   0 7     0   5   39 24     17 2   35 6   63
691514 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_2 25.0 13.0 8.0   0.0 3.0     0.0   3.0   24.0 28.0     12.0   2.0     28.0   8.0   52.0 25 13 8   0 3     0   3   24 28     12 2   28 8   52
691521 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_2 16.0 16.0 19.0   0.0 4.0     0.0   8.0   35.0 28.0     17.0   2.0     39.0   9.0   63.0 16 16 19   0 4     0   8   35 28     17 2   39 9   63
691528 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_2 33.0 21.0 12.0   0.0 4.0     0.0   12.0   36.0 46.0     20.0   2.0     38.0   12.0   82.0 33 21 12   0 4     0   12   36 46     20 2   38 12   82
691537 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_2 27.0 11.0 10.0   0.0 7.0     0.0   5.0   32.0 28.0     16.0   2.0     28.0   5.0   60.0 27 11 10   0 7     0   5   32 28     16 2   28 5   60
691546 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_2 18.0 24.0 32.0   0.0 5.0     0.0   4.0   38.0 45.0     34.0   2.0     61.0   11.0   83.0 18 24 32   0 5     0   4   38 45     34 2   61 11   83
691555 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_2 13.0 29.0 30.0   1.0 6.0     0.0   4.0   38.0 45.0     48.0   *     71.0   7.0   83.0 13 29 30   1 6     0   4   38 45     48     71 7   83
691562 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_2 41.0 4.0 12.0   0.0 16.0     0.0   8.0   37.0 44.0     17.0   2.0     26.0   6.0   81.0 41 4 12   0 16     0   8   37 44     17 2   26 6   81
691570 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_2 78.0 6.0 3.0   0.0 3.0     0.0   7.0   55.0 42.0     6.0   0.0     25.0   14.0   97.0 78 6 3   0 3     0   7   55 42     6 0   25 14   97
691578 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_2 84.0 4.0 4.0   0.0 8.0     0.0   11.0   61.0 50.0     8.0   0.0     15.0   12.0   111.0 84 4 4   0 8     0   11   61 50     8 0   15 12   111
691586 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_2 103.0 2.0 0.0   0.0 9.0     0.0   2.0   54.0 62.0     5.0   0.0     15.0   14.0   116.0 103 2 0   0 9     0   2   54 62     5 0   15 14   116
691594 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_2 110.0 2.0 6.0   1.0 3.0     0.0   8.0   71.0 59.0     3.0   0.0     11.0   25.0   130.0 110 2 6   1 3     0   8   71 59     3 0   11 25   130
691609 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_2 82.0 2.0 9.0   3.0 1.0     0.0   8.0   40.0 65.0     8.0   2.0     15.0   4.0   105.0 82 2 9   3 1     0   8   40 65     8 2   15 4   105
691616 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_2 81.0 3.0 3.0   0.0 1.0     0.0   3.0   51.0 40.0     2.0   0.0     13.0   15.0   91.0 81 3 3   0 1     0   3   51 40     2 0   13 15   91
691623 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_2 61.0 6.0 7.0   1.0 5.0     0.0   4.0   47.0 37.0     11.0   0.0     23.0   17.0   84.0 61 6 7   1 5     0   4   47 37     11 0   23 17   84
691630 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_2 45.0 3.0 6.0   0.0 0.0     0.0   4.0   31.0 27.0     5.0   0.0     11.0   *   58.0 45 3 6   0 0     0   4   31 27     5 0   11     58
691637 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_2 81.0 5.0 3.0   0.0 1.0     0.0   4.0   58.0 36.0         0.0     17.0   12.0   94.0 81 5 3   0 1     0   4   58 36       0   17 12   94
691644 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_2 89.0 0.0 2.0   0.0 5.0     0.0   5.0   51.0 50.0     4.0   0.0         13.0   101.0 89 0 2   0 5     0   5   51 50     4 0     13   101
691651 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_2 94.0 4.0 4.0   0.0 1.0     0.0   4.0   49.0 58.0     5.0   0.0     11.0   15.0   107.0 94 4 4   0 1     0   4   49 58     5 0   11 15   107
691658 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_2 95.0 2.0 1.0   0.0 7.0     0.0   7.0   60.0 52.0     4.0   0.0     7.0   13.0   112.0 95 2 1   0 7     0   7   60 52     4 0   7 13   112
691665 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_2 64.0 1.0 24.0   0.0 9.0     0.0   2.0   55.0 45.0     15.0   *     22.0   9.0   100.0 64 1 24   0 9     0   2   55 45     15     22 9   100
691673 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_2 66.0 1.0 1.0   0.0 0.0     0.0   1.0   29.0 40.0     0.0   0.0     7.0   7.0   69.0 66 1 1   0 0     0   1   29 40     0 0   7 7   69
691681 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_2 84.0 7.0 11.0   0.0 7.0     0.0   9.0   61.0 57.0     6.0   0.0     18.0   7.0   118.0 84 7 11   0 7     0   9   61 57     6 0   18 7   118
691688 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_2 45.0 5.0 7.0   0.0 7.0     0.0   6.0   35.0 35.0         *     11.0   18.0   70.0 45 5 7   0 7     0   6   35 35           11 18   70
691695 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_2 44.0 10.0 9.0   0.0 5.0     0.0   6.0   34.0 40.0     5.0   0.0     32.0   18.0   74.0 44 10 9   0 5     0   6   34 40     5 0   32 18   74
691702 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_2 55.0 17.0 13.0   0.0 5.0     0.0   10.0   46.0 54.0     12.0   2.0     35.0   13.0   100.0 55 17 13   0 5     0   10   46 54     12 2   35 13   100
691709 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_2 103.0 7.0 12.0   2.0 18.0     0.0   13.0   88.0 67.0     10.0   0.0     23.0   11.0   155.0 103 7 12   2 18     0   13   88 67     10 0   23 11   155
691716 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_2 92.0 16.0 8.0   0.0 16.0     0.0   11.0   67.0 76.0     15.0   0.0     37.0   11.0   143.0 92 16 8   0 16     0   11   67 76     15 0   37 11   143
691723 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_2 100.0 18.0 34.0   1.0 9.0     0.0   22.0   101.0 83.0     37.0   1.0     66.0   15.0   184.0 100 18 34   1 9     0   22   101 83     37 1   66 15   184
691730 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_2 46.0 31.0 18.0   0.0 19.0     0.0   13.0   70.0 57.0     24.0   1.0     60.0   12.0   127.0 46 31 18   0 19     0   13   70 57     24 1   60 12   127
691737 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_2 63.0 13.0 2.0   0.0 10.0     0.0   6.0   46.0 48.0     16.0   0.0     17.0   14.0   94.0 63 13 2   0 10     0   6   46 48     16 0   17 14   94
691746 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_2 53.0 23.0 20.0   1.0 9.0     0.0   17.0   59.0 64.0     33.0   0.0     60.0   11.0   123.0 53 23 20   1 9     0   17   59 64     33 0   60 11   123
691753 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_2 79.0 11.0 5.0   0.0 17.0     0.0   8.0   57.0 63.0     11.0   0.0     16.0   14.0   120.0 79 11 5   0 17     0   8   57 63     11 0   16 14   120
691760 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_2 67.0 10.0 8.0   2.0 14.0     0.0   12.0   63.0 50.0     11.0   0.0     30.0   16.0   113.0 67 10 8   2 14     0   12   63 50     11 0   30 16   113
691767 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_2 69.0 10.0 5.0   0.0 11.0     0.0   5.0   59.0 41.0     7.0   1.0     20.0   12.0   100.0 69 10 5   0 11     0   5   59 41     7 1   20 12   100
691774 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_2 58.0 3.0 14.0   1.0 6.0     0.0   3.0   40.0 45.0     12.0   0.0     25.0   7.0   85.0 58 3 14   1 6     0   3   40 45     12 0   25 7   85
691781 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_2 105.0 4.0 9.0   0.0 20.0     0.0   10.0   76.0 72.0     11.0   0.0         17.0   148.0 105 4 9   0 20     0   10   76 72     11 0     17   148
691788 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_2 36.0 31.0 4.0   0.0 6.0     0.0   14.0   44.0 47.0     16.0   1.0     45.0   15.0   91.0 36 31 4   0 6     0   14   44 47     16 1   45 15   91
691795 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_2 59.0 12.0 16.0   0.0 41.0     0.0   13.0   69.0 72.0     48.0   1.0     33.0   9.0   141.0 59 12 16   0 41     0   13   69 72     48 1   33 9   141
691802 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_2 100.0 6.0 9.0   0.0 8.0     0.0   7.0   83.0 47.0     9.0   1.0     18.0   12.0   130.0 100 6 9   0 8     0   7   83 47     9 1   18 12   130
691809 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_2 29.0 6.0 39.0   1.0 1.0     0.0   4.0   42.0 38.0     22.0   2.0     52.0   15.0   80.0 29 6 39   1 1     0   4   42 38     22 2   52 15   80
691815 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_2 67.0 3.0 11.0   1.0 2.0     0.0   3.0   55.0 32.0     4.0   0.0         9.0   87.0 67 3 11   1 2     0   3   55 32     4 0     9   87
691821 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_2 32.0 12.0 32.0   0.0 2.0     1.0   7.0   47.0 39.0     30.0   0.0     46.0   9.0   86.0 32 12 32   0 2     1   7   47 39     30 0   46 9   86
691827 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_2 57.0 1.0 14.0   0.0 0.0     0.0   4.0   38.0 38.0     5.0   0.0         8.0   76.0 57 1 14   0 0     0   4   38 38     5 0     8   76
691833 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_2 31.0 23.0 3.0   1.0 9.0     0.0   9.0   36.0 40.0     14.0   0.0     29.0   5.0   76.0 31 23 3   1 9     0   9   36 40     14 0   29 5   76
691837 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_2 12.0 1.0 1.0   0.0 0.0     0.0   0.0   9.0 5.0         0.0     3.0   0.0   14.0 12 1 1   0 0     0   0   9 5       0   3 0   14
691844 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_2 50.0 19.0 29.0   0.0 3.0     0.0   10.0   60.0 51.0     13.0   1.0     44.0   17.0   111.0 50 19 29   0 3     0   10   60 51     13 1   44 17   111
691851 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_2 42.0 5.0 27.0   0.0 4.0     0.0   2.0   39.0 41.0     18.0   0.0     41.0   7.0   80.0 42 5 27   0 4     0   2   39 41     18 0   41 7   80
691858 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_2 21.0 7.0 17.0   0.0 4.0     0.0   8.0   28.0 29.0         0.0     31.0   6.0   57.0 21 7 17   0 4     0   8   28 29       0   31 6   57
691865 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_2 79.0 4.0 5.0   1.0 0.0     0.0   8.0   43.0 54.0     0.0   1.0     35.0   8.0   97.0 79 4 5   1 0     0   8   43 54     0 1   35 8   97
691871 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_2 103.0 1.0 2.0   2.0 0.0     0.0   9.0   51.0 66.0     2.0   0.0     36.0   11.0   117.0 103 1 2   2 0     0   9   51 66     2 0   36 11   117
691877 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_2 77.0 4.0 7.0   0.0 3.0     0.0   6.0   44.0 53.0     3.0   1.0     26.0   17.0   97.0 77 4 7   0 3     0   6   44 53     3 1   26 17   97
691884 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_2 43.0 0.0 2.0   0.0 0.0     0.0   0.0   17.0 28.0     0.0   0.0     13.0   2.0   45.0 43 0 2   0 0     0   0   17 28     0 0   13 2   45
691892 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_2 152.0 1.0 4.0   0.0 0.0     0.0   5.0   79.0 83.0     1.0   0.0     33.0   24.0   162.0 152 1 4   0 0     0   5   79 83     1 0   33 24   162
691898 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_2 20.0 0.0 2.0   0.0 0.0     0.0   0.0   17.0 5.0     0.0   0.0     8.0   7.0   22.0 20 0 2   0 0     0   0   17 5     0 0   8 7   22
691905 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_2 26.0 0.0 0.0   0.0 0.0     0.0   0.0   12.0 14.0     0.0   1.0     8.0   5.0   26.0 26 0 0   0 0     0   0   12 14     0 1   8 5   26
691912 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_2 64.0 0.0 0.0   0.0 0.0     0.0   4.0   36.0 32.0     0.0   0.0     17.0   9.0   68.0 64 0 0   0 0     0   4   36 32     0 0   17 9   68
691919 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_2 23.0 0.0 0.0   0.0 0.0     0.0   1.0   16.0 8.0     0.0   0.0     9.0   1.0   24.0 23 0 0   0 0     0   1   16 8     0 0   9 1   24
691926 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_2 63.0 0.0 2.0   0.0 2.0     0.0   0.0   32.0 35.0     1.0   0.0     22.0   8.0   67.0 63 0 2   0 2     0   0   32 35     1 0   22 8   67
691933 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_2 67.0 1.0 4.0   0.0 0.0     0.0   3.0   37.0 38.0     1.0   2.0     27.0   12.0   75.0 67 1 4   0 0     0   3   37 38     1 2   27 12   75
691943 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_2 51.0 0.0 1.0   0.0 0.0     0.0   1.0   28.0 25.0     1.0   2.0     19.0   4.0   53.0 51 0 1   0 0     0   1   28 25     1 2   19 4   53
691952 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_2 62.0 2.0 0.0   0.0 1.0     0.0   0.0   35.0 30.0     0.0   0.0     7.0   5.0   65.0 62 2 0   0 1     0   0   35 30     0 0   7 5   65
691961 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_2 21.0 1.0 0.0   0.0 0.0     0.0   1.0   16.0 7.0     0.0   0.0     11.0   1.0   23.0 21 1 0   0 0     0   1   16 7     0 0   11 1   23
691970 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_2 15.0 1.0 0.0   0.0 0.0     0.0   0.0   10.0 6.0     0.0   0.0     7.0   1.0   16.0 15 1 0   0 0     0   0   10 6     0 0   7 1   16
691979 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_2 53.0 0.0 1.0   0.0 0.0     0.0   1.0   33.0 22.0     0.0   0.0     25.0   8.0   55.0 53 0 1   0 0     0   1   33 22     0 0   25 8   55
691988 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_2 23.0 3.0 14.0   0.0 2.0     0.0   1.0   19.0 24.0     5.0   0.0     30.0   7.0   43.0 23 3 14   0 2     0   1   19 24     5 0   30 7   43
691997 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_2 38.0 1.0 19.0   1.0 7.0     0.0   3.0   36.0 33.0     12.0   0.0     49.0   10.0   69.0 38 1 19   1 7     0   3   36 33     12 0   49 10   69
692004 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_2 47.0 6.0 10.0   0.0 4.0     0.0   3.0   37.0 33.0     7.0   0.0     39.0   12.0   70.0 47 6 10   0 4     0   3   37 33     7 0   39 12   70
692011 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_2 54.0 1.0 15.0   0.0 4.0     0.0   2.0   37.0 39.0     6.0   1.0     34.0   3.0   76.0 54 1 15   0 4     0   2   37 39     6 1   34 3   76
692019 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_2 33.0 0.0 3.0   0.0 0.0     0.0   1.0   11.0 26.0     0.0   0.0     15.0   3.0   37.0 33 0 3   0 0     0   1   11 26     0 0   15 3   37
692028 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_2 80.0 0.0 0.0   0.0 3.0     0.0   3.0   40.0 46.0     3.0   0.0     21.0   3.0   86.0 80 0 0   0 3     0   3   40 46     3 0   21 3   86
692036 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_2 50.0 0.0 4.0   0.0 0.0     0.0   0.0   24.0 30.0     3.0   0.0     10.0   3.0   54.0 50 0 4   0 0     0   0   24 30     3 0   10 3   54
692045 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_2 86.0 2.0 4.0   0.0 1.0     0.0   0.0   48.0 45.0     0.0   1.0     19.0   7.0   93.0 86 2 4   0 1     0   0   48 45     0 1   19 7   93
692049 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_2 111.0 4.0 16.0   8.0 2.0     0.0   15.0   84.0 72.0     7.0   1.0     66.0   26.0   156.0 111 4 16   8 2     0   15   84 72     7 1   66 26   156
692055 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_2 38.0 1.0 4.0   1.0 0.0     0.0   5.0   24.0 25.0     0.0   0.0     16.0   2.0   49.0 38 1 4   1 0     0   5   24 25     0 0   16 2   49
692059 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_2 15.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 7.0     0.0   0.0     9.0   2.0   15.0 15 0 0   0 0     0   0   8 7     0 0   9 2   15

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