Data source: Big Local News · About: Big Local

6,616 rows where grade = "grade_5" and state = "MN"

View and edit SQL

year

grade

  • grade_5 · 6,516
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
691394 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_5 90.0 13.0 13.0   0.0 1.0     0.0   7.0   57.0 67.0     8.0   1.0     64.0   19.0   124.0 90 13 13   0 1     0   7   57 67     8 1   64 19   124
691400 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_5 144.0 10.0 7.0   0.0 1.0     0.0   10.0   82.0 90.0     13.0   1.0     65.0   23.0   172.0 144 10 7   0 1     0   10   82 90     13 1   65 23   172
691409 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_5 53.0 1.0 0.0   14.0 0.0     0.0   11.0   42.0 37.0     0.0   0.0     47.0   21.0   79.0 53 1 0   14 0     0   11   42 37     0 0   47 21   79
691419 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_5 28.0 1.0 2.0   3.0 0.0     0.0   0.0   21.0 13.0     0.0   0.0     15.0   4.0   34.0 28 1 2   3 0     0   0   21 13     0 0   15 4   34
691427 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_5 14.0 2.0 7.0   0.0 7.0     0.0   2.0   18.0 14.0     5.0   0.0     19.0   7.0   32.0 14 2 7   0 7     0   2   18 14     5 0   19 7   32
691479 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_5 69.0 0.0 3.0   0.0 0.0     0.0   4.0   36.0 40.0     0.0   0.0     40.0   12.0   76.0 69 0 3   0 0     0   4   36 40     0 0   40 12   76
691496 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_5 23.0 22.0 2.0   1.0 2.0     0.0   2.0   30.0 22.0     5.0   1.0     31.0   1.0   52.0 23 22 2   1 2     0   2   30 22     5 1   31 1   52
691503 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_5 17.0 22.0 9.0   2.0 2.0     0.0   6.0   28.0 30.0     5.0   0.0     35.0   7.0   58.0 17 22 9   2 2     0   6   28 30     5 0   35 7   58
691510 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_5 22.0 10.0 10.0   0.0 6.0     0.0   9.0   27.0 30.0     5.0   3.0     25.0   12.0   57.0 22 10 10   0 6     0   9   27 30     5 3   25 12   57
691517 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_5 26.0 14.0 5.0   0.0 1.0     1.0   2.0   27.0 22.0         2.0         9.0   49.0 26 14 5   0 1     1   2   27 22       2     9   49
691524 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_5 21.0 13.0 10.0   1.0 6.0     0.0   8.0   24.0 35.0     6.0   4.0     32.0   7.0   59.0 21 13 10   1 6     0   8   24 35     6 4   32 7   59
691531 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_5 29.0 18.0 12.0   0.0 4.0     0.0   5.0   34.0 34.0     8.0   1.0     34.0   7.0   68.0 29 18 12   0 4     0   5   34 34     8 1   34 7   68
691540 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_5 29.0 9.0 11.0   1.0 4.0     0.0   7.0   32.0 29.0     7.0   2.0         13.0   61.0 29 9 11   1 4     0   7   32 29     7 2     13   61
691549 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_5 12.0 23.0 20.0   0.0 5.0     0.0   2.0   33.0 29.0         1.0     44.0   10.0   62.0 12 23 20   0 5     0   2   33 29       1   44 10   62
691558 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_5 22.0 28.0 29.0   0.0 5.0     0.0   6.0   51.0 39.0         1.0     66.0   15.0   90.0 22 28 29   0 5     0   6   51 39       1   66 15   90
691565 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_5 63.0 3.0 16.0   0.0 20.0     0.0   6.0   46.0 62.0     9.0   1.0     33.0   11.0   108.0 63 3 16   0 20     0   6   46 62     9 1   33 11   108
691573 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_5 93.0 6.0 5.0   0.0 1.0     0.0   7.0   56.0 56.0         1.0     33.0   21.0   112.0 93 6 5   0 1     0   7   56 56       1   33 21   112
691581 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_5 69.0 5.0 3.0   0.0 5.0     0.0   4.0   48.0 38.0     2.0   0.0     12.0   *   86.0 69 5 3   0 5     0   4   48 38     2 0   12     86
691589 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_5 107.0 1.0 7.0   0.0 9.0     0.0   6.0   66.0 64.0         0.0     17.0   15.0   130.0 107 1 7   0 9     0   6   66 64       0   17 15   130
691597 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_5 126.0 2.0 5.0   1.0 4.0     0.0   8.0   80.0 66.0     1.0   1.0     12.0   28.0   146.0 126 2 5   1 4     0   8   80 66     1 1   12 28   146
691601 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182004816 155 Gateway Academy Elementary School (Grades PK-6) Regular School No Elementary 03 08 2017   grade_5 10.0 0.0 1.0   0.0 0.0     0.0   1.0   8.0 4.0     0.0   0.0     3.0   *   12.0 10 0 1   0 0     0   1   8 4     0 0   3     12
691612 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_5 84.0 4.0 9.0   1.0 5.0     0.0   5.0   42.0 66.0     6.0   1.0     22.0   10.0   108.0 84 4 9   1 5     0   5   42 66     6 1   22 10   108
691619 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_5 89.0 2.0 2.0   0.0 4.0     1.0   4.0   56.0 46.0     3.0   0.0     9.0   20.0   102.0 89 2 2   0 4     1   4   56 46     3 0   9 20   102
691626 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_5 64.0 6.0 7.0   0.0 4.0     0.0   10.0   48.0 43.0     3.0   *     23.0   21.0   91.0 64 6 7   0 4     0   10   48 43     3     23 21   91
691633 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_5 63.0 4.0 9.0   0.0 3.0     0.0   7.0   42.0 44.0     2.0   0.0     11.0   16.0   86.0 63 4 9   0 3     0   7   42 44     2 0   11 16   86
691640 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_5 90.0 6.0 5.0   0.0 2.0     0.0   8.0   50.0 61.0     2.0   0.0     26.0   25.0   111.0 90 6 5   0 2     0   8   50 61     2 0   26 25   111
691647 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_5 93.0 2.0 5.0   0.0 4.0     0.0   11.0   58.0 57.0     2.0   0.0         25.0   115.0 93 2 5   0 4     0   11   58 57     2 0     25   115
691654 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_5 92.0 4.0 3.0   1.0 0.0     0.0   7.0   64.0 43.0         0.0     11.0   24.0   107.0 92 4 3   1 0     0   7   64 43       0   11 24   107
691661 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_5 109.0 5.0 4.0   0.0 11.0     0.0   4.0   72.0 61.0     0.0   0.0     8.0   17.0   133.0 109 5 4   0 11     0   4   72 61     0 0   8 17   133
691668 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_5 84.0 6.0 14.0   0.0 4.0     0.0   12.0   55.0 65.0     8.0   0.0     27.0   *   120.0 84 6 14   0 4     0   12   55 65     8 0   27     120
691676 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_5 56.0 0.0 1.0   0.0 1.0     0.0   3.0   31.0 30.0     0.0   0.0     16.0   6.0   61.0 56 0 1   0 1     0   3   31 30     0 0   16 6   61
691684 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_5 94.0 13.0 13.0   0.0 6.0     0.0   11.0   67.0 70.0     3.0   0.0     29.0   18.0   137.0 94 13 13   0 6     0   11   67 70     3 0   29 18   137
691691 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_5 53.0 6.0 5.0   0.0 5.0     0.0   7.0   43.0 33.0     2.0   0.0     13.0   13.0   76.0 53 6 5   0 5     0   7   43 33     2 0   13 13   76
691698 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_5 35.0 13.0 11.0   1.0 2.0     0.0   0.0   35.0 27.0     6.0   0.0     28.0   16.0   62.0 35 13 11   1 2     0   0   35 27     6 0   28 16   62
691705 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_5 72.0 23.0 18.0   1.0 8.0     0.0   4.0   70.0 56.0     17.0   *     44.0   17.0   126.0 72 23 18   1 8     0   4   70 56     17     44 17   126
691712 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_5 108.0 8.0 8.0   1.0 8.0     0.0   6.0   64.0 75.0     5.0   0.0     27.0   22.0   139.0 108 8 8   1 8     0   6   64 75     5 0   27 22   139
691719 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_5 85.0 14.0 11.0   0.0 16.0     0.0   13.0   71.0 68.0     7.0   1.0     30.0   14.0   139.0 85 14 11   0 16     0   13   71 68     7 1   30 14   139
691726 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_5 90.0 21.0 34.0   1.0 9.0     0.0   21.0   89.0 87.0     21.0   1.0     62.0   17.0   176.0 90 21 34   1 9     0   21   89 87     21 1   62 17   176
691733 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_5 51.0 28.0 20.0   0.0 19.0     0.0   14.0   81.0 51.0     11.0   0.0     64.0   15.0   132.0 51 28 20   0 19     0   14   81 51     11 0   64 15   132
691740 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_5 52.0 9.0 3.0   0.0 7.0     2.0   4.0   46.0 31.0     8.0   0.0         15.0   77.0 52 9 3   0 7     2   4   46 31     8 0     15   77
691749 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_5 37.0 26.0 16.0   2.0 7.0     0.0   10.0   44.0 54.0         3.0     48.0   9.0   98.0 37 26 16   2 7     0   10   44 54       3   48 9   98
691756 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_5 73.0 8.0 5.0   0.0 11.0     0.0   7.0   52.0 52.0     3.0   0.0     14.0   18.0   104.0 73 8 5   0 11     0   7   52 52     3 0   14 18   104
691763 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_5 64.0 16.0 15.0   1.0 6.0     0.0   12.0   61.0 53.0     11.0   0.0     28.0   24.0   114.0 64 16 15   1 6     0   12   61 53     11 0   28 24   114
691770 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_5 72.0 8.0 8.0   0.0 10.0     0.0   3.0   63.0 38.0         2.0     13.0   15.0   101.0 72 8 8   0 10     0   3   63 38       2   13 15   101
691777 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_5 93.0 5.0 8.0   0.0 8.0     0.0   3.0   66.0 51.0     4.0   0.0     14.0   16.0   117.0 93 5 8   0 8     0   3   66 51     4 0   14 16   117
691784 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_5 134.0 5.0 7.0   0.0 16.0     0.0   9.0   84.0 87.0     5.0   0.0     11.0   23.0   171.0 134 5 7   0 16     0   9   84 87     5 0   11 23   171
691791 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_5 36.0 28.0 10.0   1.0 13.0     0.0   9.0   48.0 49.0     5.0   1.0     42.0   14.0   97.0 36 28 10   1 13     0   9   48 49     5 1   42 14   97
691798 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_5 64.0 18.0 12.0   1.0 31.0     0.0   9.0   64.0 71.0     16.0   0.0     27.0   11.0   135.0 64 18 12   1 31     0   9   64 71     16 0   27 11   135
691805 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_5 128.0 7.0 13.0   1.0 10.0     0.0   9.0   91.0 77.0     5.0   0.0     21.0   17.0   168.0 128 7 13   1 10     0   9   91 77     5 0   21 17   168
691840 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_5 17.0 0.0 2.0   0.0 5.0     0.0   3.0   15.0 12.0     0.0   0.0     2.0   1.0   27.0 17 0 2   0 5     0   3   15 12     0 0   2 1   27
691847 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_5 48.0 13.0 28.0   1.0 2.0     0.0   12.0   50.0 54.0     6.0   3.0     60.0   19.0   104.0 48 13 28   1 2     0   12   50 54     6 3   60 19   104
691854 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_5 65.0 4.0 29.0   0.0 3.0     0.0   10.0   56.0 55.0     11.0   0.0     51.0   17.0   111.0 65 4 29   0 3     0   10   56 55     11 0   51 17   111
691861 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_5 15.0 13.0 10.0   0.0 1.0     0.0   5.0   26.0 18.0     7.0   0.0     25.0   7.0   44.0 15 13 10   0 1     0   5   26 18     7 0   25 7   44
691887 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_5 48.0 1.0 1.0   1.0 0.0     0.0   0.0   31.0 20.0     0.0   1.0     16.0   8.0   51.0 48 1 1   1 0     0   0   31 20     0 1   16 8   51
691901 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_5 14.0 0.0 0.0   0.0 0.0     0.0   0.0   9.0 5.0     0.0   0.0     3.0   2.0   14.0 14 0 0   0 0     0   0   9 5     0 0   3 2   14
691908 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_5 18.0 0.0 0.0   0.0 0.0     0.0   0.0   11.0 7.0     0.0   0.0     5.0   4.0   18.0 18 0 0   0 0     0   0   11 7     0 0   5 4   18
691915 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_5 80.0 1.0 3.0   0.0 0.0     0.0   0.0   42.0 42.0     1.0   1.0     22.0   11.0   84.0 80 1 3   0 0     0   0   42 42     1 1   22 11   84
691922 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_5 25.0 0.0 0.0   0.0 0.0     0.0   0.0   16.0 9.0     0.0   1.0     12.0   5.0   25.0 25 0 0   0 0     0   0   16 9     0 1   12 5   25
691929 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_5 76.0 1.0 3.0   0.0 0.0     0.0   0.0   45.0 35.0     0.0   0.0     32.0   17.0   80.0 76 1 3   0 0     0   0   45 35     0 0   32 17   80
691936 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_5 65.0 1.0 5.0   0.0 1.0     0.0   3.0   43.0 32.0     2.0   0.0     22.0   14.0   75.0 65 1 5   0 1     0   3   43 32     2 0   22 14   75
691946 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_5 66.0 2.0 1.0   0.0 0.0     1.0   0.0   37.0 33.0     0.0   0.0     27.0   17.0   70.0 66 2 1   0 0     1   0   37 33     0 0   27 17   70
691955 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_5 69.0 0.0 2.0   0.0 1.0     0.0   1.0   41.0 32.0     0.0   0.0     13.0   8.0   73.0 69 0 2   0 1     0   1   41 32     0 0   13 8   73
691964 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_5 26.0 0.0 1.0   0.0 1.0     0.0   1.0   14.0 15.0     0.0   0.0     8.0   5.0   29.0 26 0 1   0 1     0   1   14 15     0 0   8 5   29
691973 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_5 11.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 3.0     0.0   0.0         1.0   11.0 11 0 0   0 0     0   0   8 3     0 0     1   11
691982 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_5 47.0 0.0 1.0   0.0 0.0     0.0   0.0   23.0 25.0         0.0     15.0   3.0   48.0 47 0 1   0 0     0   0   23 25       0   15 3   48
691991 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_5 39.0 2.0 17.0   0.0 1.0     0.0   2.0   33.0 28.0     4.0   2.0     42.0   15.0   61.0 39 2 17   0 1     0   2   33 28     4 2   42 15   61
692000 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_5 38.0 1.0 18.0   0.0 4.0     0.0   1.0   37.0 25.0         1.0     42.0   11.0   62.0 38 1 18   0 4     0   1   37 25       1   42 11   62
692007 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_5 45.0 0.0 9.0   0.0 1.0     0.0   2.0   27.0 30.0     2.0   0.0     26.0   7.0   57.0 45 0 9   0 1     0   2   27 30     2 0   26 7   57
692014 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_5 43.0 0.0 5.0   0.0 3.0     0.0   2.0   24.0 29.0         0.0     18.0   10.0   53.0 43 0 5   0 3     0   2   24 29       0   18 10   53
692022 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_5 31.0 0.0 2.0   0.0 0.0     0.0   0.0   18.0 15.0     0.0   0.0     11.0   6.0   33.0 31 0 2   0 0     0   0   18 15     0 0   11 6   33
692031 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_5 73.0 0.0 2.0   1.0 1.0     0.0   6.0   40.0 43.0     2.0   0.0     33.0   9.0   83.0 73 0 2   1 1     0   6   40 43     2 0   33 9   83
692039 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_5 39.0 0.0 6.0   0.0 0.0     0.0   0.0   26.0 19.0     1.0   0.0     8.0   4.0   45.0 39 0 6   0 0     0   0   26 19     1 0   8 4   45
692062 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_5 23.0 0.0 1.0   0.0 0.0     0.0   0.0   12.0 12.0     0.0   0.0     14.0   4.0   24.0 23 0 1   0 0     0   0   12 12     0 0   14 4   24
692071 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_5 9.0 0.0 0.0   0.0 0.0     0.0   1.0   6.0 4.0     0.0   0.0     3.0   1.0   10.0 9 0 0   0 0     0   1   6 4     0 0   3 1   10
692079 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001886 561 ALICE SMITH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 25.0 21.0 8.0   0.0 3.0     0.0   4.0   39.0 22.0     10.0   *     31.0   17.0   61.0 25 21 8   0 3     0   4   39 22     10     31 17   61
692087 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001881 563 GLEN LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 44.0 20.0 2.0   0.0 1.0     0.0   4.0   37.0 34.0         *     21.0   10.0   71.0 44 20 2   0 1     0   4   37 34           21 10   71
692095 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426002206 566 EISENHOWER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 17.0 23.0 9.0   0.0 0.0     0.0   4.0   26.0 27.0     10.0   0.0     36.0   11.0   53.0 17 23 9   0 0     0   4   26 27     10 0   36 11   53
692103 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001887 567 L.H. TANGLEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 27.0 24.0 12.0   1.0 9.0     0.0   5.0   36.0 42.0     13.0   1.0     39.0   7.0   78.0 27 24 12   1 9     0   5   36 42     13 1   39 7   78
692111 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426004662 568 Xinxing Academy Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_5 21.0 1.0 1.0   0.0 6.0     0.0   2.0   14.0 17.0     0.0   0.0     0.0   3.0   31.0 21 1 1   0 6     0   2   14 17     0 0   0 3   31
692119 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001880 569 GATEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 36.0 19.0 15.0   0.0 0.0     0.0   7.0   33.0 44.0     16.0   0.0     42.0   6.0   77.0 36 19 15   0 0     0   7   33 44     16 0   42 6   77
692127 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001884 570 MEADOWBROOK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 65.0 15.0 4.0   0.0 2.0     0.0   6.0   43.0 49.0     4.0   0.0         23.0   92.0 65 15 4   0 2     0   6   43 49     4 0     23   92
692137 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000640 432 WASHBURN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 28.0 30.0 15.0   1.0 6.0     0.0   11.0   49.0 42.0     14.0   0.0     53.0   19.0   91.0 28 30 15   1 6     0   11   49 42     14 0   53 19   91
692144 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579002292 443 HILLCREST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 49.0 7.0 6.0   0.0 3.0     0.0   6.0   40.0 31.0     1.0   0.0     17.0   11.0   71.0 49 7 6   0 3     0   6   40 31     1 0   17 11   71
692152 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000218 446 INDIAN MOUNDS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 33.0 10.0 24.0   0.0 0.0     0.0   8.0   43.0 32.0     11.0   1.0     47.0   14.0   75.0 33 10 24   0 0     0   8   43 32     11 1   47 14   75
692159 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000227 447 OLSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 61.0 14.0 8.0   0.0 9.0     0.0   8.0   40.0 60.0     4.0   0.0     35.0   10.0   100.0 61 14 8   0 9     0   8   40 60     4 0   35 10   100
692167 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000223 448 OAK GROVE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 38.0 9.0 15.0   0.0 13.0     0.0   4.0   46.0 33.0     9.0   0.0     38.0   13.0   79.0 38 9 15   0 13     0   4   46 33     9 0   38 13   79
692174 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000225 450 NORMANDALE HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 54.0 12.0 13.0   0.0 5.0     0.0   7.0   50.0 41.0     9.0   0.0     36.0   8.0   91.0 54 12 13   0 5     0   7   50 41     9 0   36 8   91
692181 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000232 454 POPLAR BRIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 40.0 5.0 15.0   0.0 1.0     0.0   14.0   42.0 33.0     4.0   0.0     22.0   17.0   75.0 40 5 15   0 1     0   14   42 33     4 0   22 17   75
692188 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000234 455 RIDGEVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 46.0 6.0 3.0   1.0 6.0     0.0   8.0   43.0 27.0     0.0   2.0     11.0   10.0   70.0 46 6 3   1 6     0   8   43 27     0 2   11 10   70
692197 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000238 459 VALLEY VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 11.0 17.0 44.0   0.0 8.0     0.0   7.0   49.0 38.0         3.0     66.0   12.0   87.0 11 17 44   0 8     0   7   49 38       3   66 12   87
692204 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000240 461 WESTWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 40.0 11.0 7.0   1.0 3.0     0.0   6.0   29.0 39.0     4.0   2.0     31.0   9.0   68.0 40 11 7   1 3     0   6   29 39     4 2   31 9   68
692211 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422002271 880 Oak Point Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_5 65.0 15.0 17.0   1.0 23.0     0.0   4.0   64.0 61.0     6.0   0.0     31.0   17.0   125.0 65 15 17   1 23     0   4   64 61     6 0   31 17   125
692219 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422000737 881 PRAIRIE VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_5 52.0 20.0 8.0   0.0 24.0     0.0   7.0   55.0 56.0     11.0   0.0     32.0   11.0   111.0 52 20 8   0 24     0   7   55 56     11 0   32 11   111
692227 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422000736 882 FOREST HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_5 35.0 14.0 5.0   2.0 7.0     0.0   4.0   38.0 29.0     5.0   0.0     24.0   14.0   67.0 35 14 5   2 7     0   4   38 29     5 0   24 14   67
692235 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422002197 883 EDEN LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_5 71.0 22.0 3.0   0.0 19.0     0.0   6.0   67.0 54.0     3.0   1.0     28.0   10.0   121.0 71 22 3   0 19     0   6   67 54     3 1   28 10   121
692243 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422003620 886 EAGLE HEIGHTS SPANISH IMMERSION Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_5 93.0 4.0 12.0   0.0 5.0     0.0   7.0   62.0 59.0     2.0   0.0     11.0   12.0   121.0 93 4 12   0 5     0   7   62 59     2 0   11 12   121
692251 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422002241 887 CEDAR RIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_5 61.0 5.0 4.0   1.0 12.0     0.0   5.0   47.0 41.0     2.0   1.0     11.0   14.0   88.0 61 5 4   1 12     0   5   47 41     2 1   11 14   88
692259 MN Hennepin 27 school 2711250 273 Independent Districts and Schools EDINA PUBLIC SCHOOL DISTRICT 271125000505 526 CONCORD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 103.0 4.0 7.0   0.0 8.0     0.0   8.0   67.0 63.0     1.0   0.0     7.0   16.0   130.0 103 4 7   0 8     0   8   67 63     1 0   7 16   130
692266 MN Hennepin 27 school 2711250 273 Independent Districts and Schools EDINA PUBLIC SCHOOL DISTRICT 271125000506 527 CORNELIA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 52.0 11.0 15.0   1.0 19.0     0.0   5.0   58.0 45.0     9.0   0.0     25.0   10.0   103.0 52 11 15   1 19     0   5   58 45     9 0   25 10   103
692273 MN Hennepin 27 school 2711250 273 Independent Districts and Schools EDINA PUBLIC SCHOOL DISTRICT 271125000507 528 COUNTRYSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 87.0 7.0 2.0   0.0 5.0     0.0   6.0   58.0 49.0     1.0   0.0     9.0   14.0   107.0 87 7 2   0 5     0   6   58 49     1 0   9 14   107

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