Data source: Big Local News · About: Big Local

942 rows where grade = "grade_1", state = "MN" and year = 2019

View and edit SQL

year

  • 2019 · 842

grade

  • grade_1 · 842
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
1946682 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 2019   grade_1 102.0 0.0 1.0   0.0 0.0     0.0   3.0   51.0 55.0     0.0   0.0     43.0   5.0   106.0 102 0 1   0 0     0   3   51 55     0 0   43 5   106
1946690 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 2019   grade_1 12.0 0.0 0.0   18.0 0.0     0.0   0.0   14.0 16.0     0.0   0.0     22.0   1.0   30.0 12 0 0   18 0     0   0   14 16     0 0   22 1   30
1946697 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 2019   grade_1 75.0 0.0 23.0   1.0 0.0     1.0   7.0   55.0 52.0     14.0   0.0     54.0   19.0   107.0 75 0 23   1 0     1   7   55 52     14 0   54 19   107
1946705 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 2019   grade_1 141.0 1.0 9.0   2.0 6.0     0.0   4.0   87.0 76.0     9.0   2.0     61.0   22.0   163.0 141 1 9   2 6     0   4   87 76     9 2   61 22   163
1946712 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 2019   grade_1 52.0 0.0 1.0   2.0 0.0     0.0   0.0   17.0 38.0     0.0   0.0     15.0   6.0   55.0 52 0 1   2 0     0   0   17 38     0 0   15 6   55
1946720 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 2019   grade_1 63.0 0.0 0.0   0.0 0.0     0.0   1.0   35.0 29.0     0.0   0.0     11.0   7.0   64.0 63 0 0   0 0     0   1   35 29     0 0   11 7   64
1946728 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 2019   grade_1 72.0 0.0 2.0   0.0 0.0     0.0   1.0   41.0 34.0     *   *         *   75.0 72 0 2   0 0     0   1   41 34                 75
1946736 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 2019   grade_1 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 3 0 0   0 0     0   0   2 1                 3
1946743 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142005026 185 Dorothy Dodds Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 97.0 15.0 14.0   4.0 1.0     0.0   8.0   83.0 56.0     11.0   0.0     53.0   23.0   139.0 97 15 14   4 1     0   8   83 56     11 0   53 23   139
1946749 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 04 2019   grade_1 83.0 8.0 15.0   8.0 0.0     1.0   13.0   62.0 66.0     7.0   6.0     71.0   29.0   128.0 83 8 15   8 0     1   13   62 66     7 6   71 29   128
1946755 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 04 2019   grade_1 101.0 17.0 10.0   3.0 3.0     0.0   9.0   75.0 68.0     7.0   0.0     44.0   22.0   143.0 101 17 10   3 3     0   9   75 68     7 0   44 22   143
1946761 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 04 2019   grade_1 104.0 15.0 4.0   1.0 0.0     0.0   4.0   69.0 59.0     21.0   0.0     51.0   18.0   128.0 104 15 4   1 0     0   4   69 59     21 0   51 18   128
1946769 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 2019   grade_1 41.0 1.0 0.0   16.0 0.0     0.0   3.0   32.0 29.0     0.0   0.0     30.0   9.0   61.0 41 1 0   16 0     0   3   32 29     0 0   30 9   61
1946779 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 2019   grade_1 14.0 0.0 2.0   1.0 0.0     0.0   6.0   14.0 9.0     0.0   0.0     8.0   5.0   23.0 14 0 2   1 0     0   6   14 9     0 0   8 5   23
1946787 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 2019   grade_1 23.0 0.0 14.0   0.0 4.0     0.0   7.0   22.0 26.0     12.0   0.0     24.0   8.0   48.0 23 0 14   0 4     0   7   22 26     12 0   24 8   48
1946795 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 2019   grade_1 56.0 1.0 21.0   0.0 3.0     1.0   2.0   45.0 39.0     18.0   0.0     40.0   15.0   84.0 56 1 21   0 3     1   2   45 39     18 0   40 15   84
1946800 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 2019   grade_1 100.0 0.0 1.0   2.0 1.0     0.0   7.0   52.0 59.0     2.0   0.0     43.0   19.0   111.0 100 0 1   2 1     0   7   52 59     2 0   43 19   111
1946806 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 2019   grade_1 59.0 1.0 1.0   2.0 0.0     0.0   3.0   35.0 31.0     0.0   0.0     39.0   17.0   66.0 59 1 1   2 0     0   3   35 31     0 0   39 17   66
1946812 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 2019   grade_1 39.0 0.0 0.0   1.0 0.0     0.0   1.0   22.0 19.0     0.0   0.0     21.0   9.0   41.0 39 0 0   1 0     0   1   22 19     0 0   21 9   41
1946818 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 2019   grade_1 89.0 1.0 1.0   3.0 1.0     0.0   4.0   46.0 53.0     1.0   2.0     40.0   14.0   99.0 89 1 1   3 1     0   4   46 53     1 2   40 14   99
1946824 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 2019   grade_1 104.0 1.0 5.0   1.0 0.0     0.0   7.0   63.0 55.0     1.0   0.0     64.0   29.0   118.0 104 1 5   1 0     0   7   63 55     1 0   64 29   118
1946830 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 2019   grade_1 50.0 0.0 1.0   0.0 0.0     0.0   1.0   30.0 22.0     0.0   0.0     20.0   9.0   52.0 50 0 1   0 0     0   1   30 22     0 0   20 9   52
1946837 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 2019   grade_1 65.0 1.0 2.0   0.0 0.0     0.0   4.0   40.0 32.0     0.0   1.0     33.0   8.0   72.0 65 1 2   0 0     0   4   40 32     0 1   33 8   72
1946846 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 2019   grade_1 109.0 2.0 1.0   3.0 0.0     0.0   0.0   66.0 49.0     1.0   0.0     40.0   19.0   115.0 109 2 1   3 0     0   0   66 49     1 0   40 19   115
1946857 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 PK 05 2019   grade_1 29.0 40.0 7.0   0.0 2.0     0.0   10.0   46.0 42.0     20.0   0.0     50.0   11.0   88.0 29 40 7   0 2     0   10   46 42     20 0   50 11   88
1946866 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 PK 05 2019   grade_1 22.0 24.0 5.0   0.0 1.0     0.0   7.0   29.0 30.0     16.0   1.0     37.0   14.0   59.0 22 24 5   0 1     0   7   29 30     16 1   37 14   59
1946875 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 PK 05 2019   grade_1 16.0 14.0 7.0   1.0 7.0     0.0   2.0   25.0 22.0     10.0   0.0     19.0   10.0   47.0 16 14 7   1 7     0   2   25 22     10 0   19 10   47
1946884 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 PK 05 2019   grade_1 16.0 20.0 4.0   0.0 9.0     0.0   3.0   28.0 24.0     10.0   0.0     31.0   7.0   52.0 16 20 4   0 9     0   3   28 24     10 0   31 7   52
1946893 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 PK 05 2019   grade_1 19.0 25.0 13.0   1.0 3.0     0.0   5.0   37.0 29.0     18.0   6.0     45.0   13.0   66.0 19 25 13   1 3     0   5   37 29     18 6   45 13   66
1946900 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 2019   grade_1 40.0 23.0 4.0   0.0 3.0     1.0   5.0   40.0 36.0     15.0   0.0     33.0   8.0   76.0 40 23 4   0 3     1   5   40 36     15 0   33 8   76
1946909 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 2019   grade_1 8.0 11.0 5.0   1.0 6.0     0.0   4.0   16.0 19.0     11.0   0.0     18.0   6.0   35.0 8 11 5   1 6     0   4   16 19     11 0   18 6   35
1946918 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 2019   grade_1 11.0 16.0 19.0   0.0 5.0     0.0   3.0   27.0 27.0     16.0   0.0     42.0   4.0   54.0 11 16 19   0 5     0   3   27 27     16 0   42 4   54
1946927 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 2019   grade_1 14.0 21.0 25.0   0.0 6.0     0.0   2.0   31.0 37.0     38.0   1.0     48.0   9.0   68.0 14 21 25   0 6     0   2   31 37     38 1   48 9   68
1946934 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 2019   grade_1 36.0 9.0 10.0   0.0 10.0     0.0   6.0   28.0 43.0     15.0   1.0     21.0   8.0   71.0 36 9 10   0 10     0   6   28 43     15 1   21 8   71
1946942 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 2019   grade_1 70.0 7.0 5.0   0.0 1.0     0.0   7.0   45.0 45.0     3.0   0.0     16.0   14.0   90.0 70 7 5   0 1     0   7   45 45     3 0   16 14   90
1946950 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 2019   grade_1 66.0 8.0 8.0   0.0 6.0     0.0   6.0   42.0 52.0     8.0   1.0     21.0   11.0   94.0 66 8 8   0 6     0   6   42 52     8 1   21 11   94
1946958 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 2019   grade_1 80.0 2.0 13.0   0.0 7.0     0.0   13.0   60.0 55.0     15.0   2.0     22.0   20.0   115.0 80 2 13   0 7     0   13   60 55     15 2   22 20   115
1946966 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 06 2019   grade_1 99.0 2.0 3.0   1.0 3.0     0.0   7.0   68.0 47.0     0.0   0.0     12.0   22.0   115.0 99 2 3   1 3     0   7   68 47     0 0   12 22   115
1946981 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 2019   grade_1 65.0 1.0 15.0   0.0 3.0     0.0   2.0   52.0 34.0     11.0   2.0     16.0   15.0   86.0 65 1 15   0 3     0   2   52 34     11 2   16 15   86
1946988 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 2019   grade_1 96.0 2.0 2.0   0.0 3.0     1.0   7.0   64.0 47.0     3.0   *     13.0   *   111.0 96 2 2   0 3     1   7   64 47     3     13     111
1946995 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 2019   grade_1 52.0 4.0 4.0   0.0 6.0     0.0   3.0   35.0 34.0     9.0   0.0     14.0   13.0   69.0 52 4 4   0 6     0   3   35 34     9 0   14 13   69
1947002 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 2019   grade_1 56.0 2.0 6.0   0.0 3.0     0.0   8.0   34.0 41.0     8.0   0.0     11.0   *   75.0 56 2 6   0 3     0   8   34 41     8 0   11     75
1947009 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 2019   grade_1 79.0 7.0 10.0   0.0 7.0     1.0   7.0   56.0 55.0     7.0   0.0     23.0   16.0   111.0 79 7 10   0 7     1   7   56 55     7 0   23 16   111
1947016 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 2019   grade_1 92.0 2.0 5.0   1.0 8.0     0.0   6.0   63.0 51.0     4.0   0.0         17.0   114.0 92 2 5   1 8     0   6   63 51     4 0     17   114
1947023 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 2019   grade_1 74.0 4.0 9.0   0.0 1.0     1.0   3.0   46.0 46.0     *   0.0         13.0   92.0 74 4 9   0 1     1   3   46 46       0     13   92
1947030 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 2019   grade_1 79.0 2.0 5.0   0.0 4.0     1.0   6.0   57.0 40.0     5.0   0.0     9.0   6.0   97.0 79 2 5   0 4     1   6   57 40     5 0   9 6   97
1947037 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 2019   grade_1 69.0 3.0 8.0   0.0 8.0     0.0   4.0   52.0 40.0     10.0   0.0     11.0   8.0   92.0 69 3 8   0 8     0   4   52 40     10 0   11 8   92
1947045 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 2019   grade_1 47.0 0.0 2.0   0.0 0.0     0.0   2.0   32.0 19.0     0.0   1.0         7.0   51.0 47 0 2   0 0     0   2   32 19     0 1     7   51
1947053 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 2019   grade_1 83.0 13.0 3.0   0.0 6.0     0.0   10.0   58.0 57.0     *   0.0     20.0   17.0   115.0 83 13 3   0 6     0   10   58 57       0   20 17   115
1947060 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 2019   grade_1 64.0 5.0 6.0   0.0 3.0     0.0   6.0   39.0 45.0     3.0   0.0     10.0   16.0   84.0 64 5 6   0 3     0   6   39 45     3 0   10 16   84
1947067 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 2019   grade_1 50.0 9.0 12.0   1.0 4.0     0.0   10.0   43.0 43.0     11.0   0.0     34.0   13.0   86.0 50 9 12   1 4     0   10   43 43     11 0   34 13   86
1947074 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 2019   grade_1 60.0 24.0 12.0   0.0 0.0     0.0   9.0   64.0 41.0     7.0   0.0     30.0   20.0   105.0 60 24 12   0 0     0   9   64 41     7 0   30 20   105
1947081 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 2019   grade_1 105.0 11.0 20.0   0.0 5.0     0.0   10.0   84.0 67.0     12.0   0.0     35.0   20.0   151.0 105 11 20   0 5     0   10   84 67     12 0   35 20   151
1947088 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 2019   grade_1 66.0 6.0 13.0   2.0 14.0     0.0   10.0   59.0 52.0     10.0   0.0     17.0   8.0   111.0 66 6 13   2 14     0   10   59 52     10 0   17 8   111
1947095 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 2019   grade_1 82.0 14.0 24.0   0.0 6.0     0.0   7.0   76.0 57.0     34.0   0.0     53.0   21.0   133.0 82 14 24   0 6     0   7   76 57     34 0   53 21   133
1947102 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 2019   grade_1 49.0 31.0 11.0   0.0 14.0     0.0   13.0   64.0 54.0     20.0   0.0     45.0   10.0   118.0 49 31 11   0 14     0   13   64 54     20 0   45 10   118
1947109 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 2019   grade_1 54.0 7.0 3.0   1.0 5.0     0.0   8.0   38.0 40.0     13.0   0.0     10.0   11.0   78.0 54 7 3   1 5     0   8   38 40     13 0   10 11   78
1947118 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 2019   grade_1 42.0 41.0 29.0   0.0 5.0     0.0   16.0   69.0 64.0     39.0   *     67.0   21.0   133.0 42 41 29   0 5     0   16   69 64     39     67 21   133
1947125 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 2019   grade_1 93.0 9.0 9.0   0.0 8.0     1.0   6.0   59.0 67.0     14.0   0.0     17.0   12.0   126.0 93 9 9   0 8     1   6   59 67     14 0   17 12   126
1947132 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 2019   grade_1 84.0 8.0 9.0   1.0 6.0     0.0   13.0   67.0 54.0     5.0   0.0     19.0   17.0   121.0 84 8 9   1 6     0   13   67 54     5 0   19 17   121
1947139 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 2019   grade_1 78.0 6.0 7.0   1.0 14.0     0.0   6.0   57.0 55.0     4.0   0.0     12.0   14.0   112.0 78 6 7   1 14     0   6   57 55     4 0   12 14   112
1947146 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 2019   grade_1 72.0 1.0 12.0   0.0 11.0     0.0   2.0   59.0 39.0     14.0   0.0     16.0   17.0   98.0 72 1 12   0 11     0   2   59 39     14 0   16 17   98
1947153 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 2019   grade_1 83.0 4.0 5.0   0.0 8.0     0.0   7.0   57.0 50.0     6.0   0.0         14.0   107.0 83 4 5   0 8     0   7   57 50     6 0     14   107
1947162 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 PK 05 2019   grade_1 34.0 23.0 11.0   0.0 10.0     0.0   13.0   41.0 50.0     23.0   0.0     41.0   13.0   91.0 34 23 11   0 10     0   13   41 50     23 0   41 13   91
1947169 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239004981 721 East Lake Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_1 101.0 10.0 8.0   0.0 10.0     0.0   8.0   66.0 71.0     12.0   0.0     18.0   14.0   137.0 101 10 8   0 10     0   8   66 71     12 0   18 14   137
1947176 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 2019   grade_1 45.0 15.0 10.0   0.0 37.0     0.0   8.0   65.0 50.0     26.0   0.0     19.0   6.0   115.0 45 15 10   0 37     0   8   65 50     26 0   19 6   115
1947183 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 2019   grade_1 85.0 4.0 10.0   0.0 7.0     1.0   7.0   66.0 48.0     11.0   0.0     16.0   9.0   114.0 85 4 10   0 7     1   7   66 48     11 0   16 9   114
1947191 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 PK 04 2019   grade_1 29.0 10.0 37.0   0.0 4.0     0.0   6.0   53.0 33.0     27.0   0.0     54.0   17.0   86.0 29 10 37   0 4     0   6   53 33     27 0   54 17   86
1947197 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 2019   grade_1 79.0 0.0 7.0   0.0 1.0     0.0   5.0   49.0 43.0     4.0   0.0     6.0   10.0   92.0 79 0 7   0 1     0   5   49 43     4 0   6 10   92
1947203 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 2019   grade_1 41.0 6.0 42.0   2.0 1.0     0.0   5.0   40.0 57.0     27.0   0.0     55.0   12.0   97.0 41 6 42   2 1     0   5   40 57     27 0   55 12   97
1947209 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 2019   grade_1 61.0 4.0 13.0   0.0 1.0     0.0   10.0   45.0 44.0     4.0   0.0     18.0   11.0   89.0 61 4 13   0 1     0   10   45 44     4 0   18 11   89
1947215 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 2019   grade_1 25.0 29.0 3.0   0.0 18.0     0.0   8.0   38.0 45.0     9.0   0.0     42.0   15.0   83.0 25 29 3   0 18     0   8   38 45     9 0   42 15   83
1947226 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 2019   grade_1 52.0 11.0 19.0   0.0 2.0     1.0   6.0   52.0 39.0     15.0   0.0     42.0   15.0   91.0 52 11 19   0 2     1   6   52 39     15 0   42 15   91
1947235 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 PK 05 2019   grade_1 63.0 9.0 20.0   0.0 3.0     0.0   3.0   45.0 53.0     9.0   0.0         11.0   98.0 63 9 20   0 3     0   3   45 53     9 0     11   98
1947244 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 PK 05 2019   grade_1 19.0 5.0 8.0   0.0 5.0     0.0   2.0   20.0 19.0     5.0   0.0         0.0   39.0 19 5 8   0 5     0   2   20 19     5 0     0   39
1947251 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 2019   grade_1 70.0 2.0 7.0   1.0 0.0     0.0   4.0   41.0 43.0     0.0   0.0     27.0   12.0   84.0 70 2 7   1 0     0   4   41 43     0 0   27 12   84
1947257 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 2019   grade_1 89.0 1.0 9.0   0.0 2.0     0.0   7.0   55.0 53.0     2.0   0.0     27.0   15.0   108.0 89 1 9   0 2     0   7   55 53     2 0   27 15   108
1947263 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 2019   grade_1 96.0 2.0 4.0   0.0 1.0     1.0   8.0   58.0 54.0     3.0   2.0     31.0   15.0   112.0 96 2 4   0 1     1   8   58 54     3 2   31 15   112
1947270 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 2019   grade_1 49.0 1.0 1.0   0.0 0.0     0.0   0.0   23.0 28.0     0.0   *     17.0   8.0   51.0 49 1 1   0 0     0   0   23 28     0     17 8   51
1947278 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 2019   grade_1 154.0 1.0 11.0   0.0 0.0     0.0   6.0   99.0 73.0     5.0   0.0     32.0   21.0   172.0 154 1 11   0 0     0   6   99 73     5 0   32 21   172
1947284 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 2019   grade_1 23.0 0.0 1.0   0.0 0.0     0.0   1.0   11.0 14.0     0.0   0.0     6.0   6.0   25.0 23 0 1   0 0     0   1   11 14     0 0   6 6   25
1947291 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 2019   grade_1 25.0 0.0 0.0   0.0 0.0     0.0   0.0   10.0 15.0     0.0   1.0     3.0   1.0   25.0 25 0 0   0 0     0   0   10 15     0 1   3 1   25
1947298 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 2019   grade_1 63.0 2.0 2.0   2.0 0.0     0.0   4.0   43.0 30.0     0.0   2.0     20.0   12.0   73.0 63 2 2   2 0     0   4   43 30     0 2   20 12   73
1947305 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 2019   grade_1 23.0 0.0 0.0   0.0 0.0     0.0   1.0   17.0 7.0     0.0   0.0     4.0   5.0   24.0 23 0 0   0 0     0   1   17 7     0 0   4 5   24
1947312 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 2019   grade_1 60.0 1.0 4.0   0.0 0.0     0.0   4.0   40.0 29.0     1.0   1.0     23.0   15.0   69.0 60 1 4   0 0     0   4   40 29     1 1   23 15   69
1947319 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 2019   grade_1 70.0 0.0 7.0   0.0 2.0     0.0   1.0   40.0 40.0     4.0   1.0     32.0   17.0   80.0 70 0 7   0 2     0   1   40 40     4 1   32 17   80
1947329 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 2019   grade_1 54.0 1.0 0.0   0.0 0.0     0.0   0.0   30.0 25.0     0.0   0.0     18.0   8.0   55.0 54 1 0   0 0     0   0   30 25     0 0   18 8   55
1947338 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 2019   grade_1 60.0 0.0 1.0   1.0 0.0     0.0   1.0   30.0 33.0     0.0   0.0     7.0   7.0   63.0 60 0 1   1 0     0   1   30 33     0 0   7 7   63
1947347 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 2019   grade_1 27.0 0.0 0.0   0.0 0.0     0.0   0.0   16.0 11.0     0.0   0.0     8.0   2.0   27.0 27 0 0   0 0     0   0   16 11     0 0   8 2   27
1947356 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 2019   grade_1 23.0 0.0 1.0   0.0 0.0     0.0   0.0   11.0 13.0     0.0   0.0     7.0   1.0   24.0 23 0 1   0 0     0   0   11 13     0 0   7 1   24
1947365 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 2019   grade_1 33.0 0.0 3.0   0.0 0.0     0.0   2.0   22.0 16.0     3.0   0.0     16.0   2.0   38.0 33 0 3   0 0     0   2   22 16     3 0   16 2   38
1947374 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 2019   grade_1 21.0 4.0 28.0   0.0 5.0     0.0   0.0   34.0 24.0     11.0   0.0     43.0   18.0   58.0 21 4 28   0 5     0   0   34 24     11 0   43 18   58
1947383 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 2019   grade_1 42.0 1.0 9.0   1.0 4.0     0.0   8.0   36.0 29.0     *   0.0     38.0   8.0   65.0 42 1 9   1 4     0   8   36 29       0   38 8   65
1947390 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 2019   grade_1 26.0 3.0 10.0   0.0 0.0     0.0   3.0   23.0 19.0     *   1.0     24.0   10.0   42.0 26 3 10   0 0     0   3   23 19       1   24 10   42
1947397 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 2019   grade_1 44.0 2.0 5.0   0.0 12.0     0.0   4.0   41.0 26.0     12.0   0.0     33.0   15.0   67.0 44 2 5   0 12     0   4   41 26     12 0   33 15   67
1947405 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 2019   grade_1 35.0 0.0 0.0   0.0 0.0     0.0   0.0   19.0 16.0     0.0   0.0     10.0   6.0   35.0 35 0 0   0 0     0   0   19 16     0 0   10 6   35
1947414 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 2019   grade_1 61.0 0.0 4.0   0.0 0.0     1.0   2.0   31.0 37.0     0.0   0.0     18.0   6.0   68.0 61 0 4   0 0     1   2   31 37     0 0   18 6   68
1947421 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 2019   grade_1 37.0 0.0 7.0   0.0 0.0     0.0   1.0   19.0 26.0     6.0   0.0     9.0   0.0   45.0 37 0 7   0 0     0   1   19 26     6 0   9 0   45
1947430 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 2019   grade_1 120.0 4.0 1.0   0.0 2.0     0.0   2.0   69.0 60.0     0.0   0.0     20.0   11.0   129.0 120 4 1   0 2     0   2   69 60     0 0   20 11   129
1947440 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 2019   grade_1 168.0 10.0 18.0   6.0 1.0     0.0   21.0   120.0 104.0     9.0   5.0     84.0   43.0   224.0 168 10 18   6 1     0   21   120 104     9 5   84 43   224

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