Data source: Big Local News · About: Big Local

960 rows where grade = "grade_4", state = "MN" and year = 2017 sorted by county_state_id descending

View and edit SQL

year

  • 2017 · 960

grade

  • grade_4 · 960
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
695443 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000321 20 CANBY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 29.0 0.0 3.0   0.0 1.0     0.0   0.0   12.0 21.0     0.0   0.0     15.0   7.0   33.0 29 0 3   0 1     0   0   12 21     0 0   15 7   33
695771 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools YELLOW MEDICINE EAST 270009900676 10 BERT RANEY ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 34.0 1.0 7.0   11.0 2.0     0.0   0.0   26.0 29.0     2.0   0.0     25.0   14.0   55.0 34 1 7   11 2     0   0   26 29     2 0   25 14   55
697237 MN Yellow Medicine 87 school 2700290 4172 Charter Schools CLARKFIELD CHARTER SCHOOL 270029003726 10 CLARKFIELD CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_4 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 3 0 0   0 0     0   0   3 0                 3
702730 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_4 5.0 0.0 0.0   1.0 0.0     0.0   0.0   2.0 4.0         *         *   6.0 5 0 0   1 0     0   0   2 4                 6
693119 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006000426 1 COKATO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_4 106.0 0.0 3.0   0.0 1.0     0.0   2.0   52.0 60.0     1.0   0.0     30.0   13.0   112.0 106 0 3   0 1     0   2   52 60     1 0   30 13   112
694645 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137002557 800 OTSEGO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 120.0 4.0 10.0   0.0 1.0     0.0   8.0   74.0 69.0     6.0   0.0     33.0   21.0   143.0 120 4 10   0 1     0   8   74 69     6 0   33 21   143
695337 MN Wright 86 school 2703150 876 Independent Districts and Schools ANNANDALE PUBLIC SCHOOL DISTRICT 270315000094 1 ANNANDALE ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 133.0 2.0 1.0   0.0 1.0     0.0   3.0   69.0 71.0     1.0   1.0     33.0   27.0   140.0 133 2 1   0 1     0   3   69 71     1 1   33 27   140
695344 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720000283 10 PARKSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 78.0 1.0 6.0   0.0 0.0     1.0   5.0   54.0 37.0     3.0   1.0     33.0   9.0   91.0 78 1 6   0 0     1   5   54 37     3 1   33 9   91
695351 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720000286 20 HANOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_4 72.0 0.0 3.0   0.0 0.0     0.0   0.0   31.0 44.0     0.0   0.0     9.0   8.0   75.0 72 0 3   0 0     0   0   31 44     0 0   9 8   75
695359 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720000287 50 MONTROSE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 44.0 1.0 4.0   0.0 0.0     0.0   2.0   28.0 23.0     2.0   0.0     17.0   9.0   51.0 44 1 4   0 0     0   2   28 23     2 0   17 9   51
695366 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720001875 60 TATANKA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 80.0 1.0 2.0   0.0 1.0     1.0   2.0   38.0 49.0     2.0   0.0     24.0   13.0   87.0 80 1 2   0 1     1   2   38 49     2 0   24 13   87
695373 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720004186 65 NORTHWINDS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 89.0 2.0 1.0   0.0 1.0     0.0   3.0   51.0 45.0     0.0   0.0     19.0   12.0   96.0 89 2 1   0 1     0   3   51 45     0 0   19 12   96
695380 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720002686 70 DISCOVERY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 41.0 0.0 1.0   0.0 1.0     0.0   2.0   23.0 22.0     0.0   0.0     8.0   4.0   45.0 41 0 1   0 1     0   2   23 22     0 0   8 4   45
695388 MN Wright 86 school 2710170 879 Independent Districts and Schools DELANO PUBLIC SCHOOL DISTRICT 271017000436 10 DELANO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_4 191.0 2.0 2.0   0.0 3.0     0.0   3.0   100.0 101.0     1.0   0.0     22.0   26.0   201.0 191 2 2   0 3     0   3   100 101     1 0   22 26   201
695395 MN Wright 86 school 2718810 881 Independent Districts and Schools MAPLE LAKE PUBLIC SCHOOL DISTRICT 271881000885 10 MAPLE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 53.0 1.0 0.0   1.0 0.0     0.0   1.0   29.0 27.0     0.0   0.0     16.0   10.0   56.0 53 1 0   1 0     0   1   29 27     0 0   16 10   56
695403 MN Wright 86 school 2721390 882 Independent Districts and Schools MONTICELLO PUBLIC SCHOOL DISTRICT 272139001078 10 PINEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 165.0 3.0 9.0   0.0 0.0     0.0   4.0   90.0 91.0     5.0   0.0     46.0   19.0   181.0 165 3 9   0 0     0   4   90 91     5 0   46 19   181
695410 MN Wright 86 school 2721390 882 Independent Districts and Schools MONTICELLO PUBLIC SCHOOL DISTRICT 272139001837 50 LITTLE MOUNTAIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 121.0 5.0 14.0   0.0 1.0     0.0   7.0   86.0 62.0     7.0   0.0     52.0   25.0   148.0 121 5 14   0 1     0   7   86 62     7 0   52 25   148
695426 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379000032 40 ST. MICHAEL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   grade_4 126.0 4.0 8.0   0.0 1.0     0.0   6.0   70.0 75.0     1.0   1.0     19.0   13.0   145.0 126 4 8   0 1     0   6   70 75     1 1   19 13   145
695431 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379004187 60 BIG WOODS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   grade_4 141.0 3.0 6.0   0.0 5.0     0.0   10.0   85.0 80.0     4.0   0.0     11.0   20.0   165.0 141 3 6   0 5     0   10   85 80     4 0   11 20   165
695436 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379003673 70 FIELDSTONE ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   grade_4 141.0 10.0 7.0   1.0 2.0     0.0   11.0   94.0 78.0     3.0   0.0     25.0   17.0   172.0 141 10 7   1 2     0   11   94 78     3 0   25 17   172
695957 MN Wright 86 school 2700123 2687 Independent Districts and Schools HOWARD LAKE-WAVERLY-WINSTED 270012302697 3 HUMPHREY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_4 57.0 0.0 0.0   0.0 0.0     0.0   0.0   33.0 24.0     0.0   0.0     19.0   3.0   57.0 57 0 0   0 0     0   0   33 24     0 0   19 3   57
697010 MN Wright 86 school 2700360 4118 Charter Schools KALEIDOSCOPE CHARTER SCHOOL 270036004104 10 KALEIDOSCOPE CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2017   grade_4 71.0 0.0 1.0   0.0 0.0     0.0   0.0   35.0 37.0     1.0   0.0     12.0   8.0   72.0 71 0 1   0 0     0   0   35 37     1 0   12 8   72
697065 MN Wright 86 school 2700249 4137 Charter Schools Swan River Montessori Charter School 270024903309 10 Swan River Montessori Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_4 25.0 1.0 0.0   1.0 0.0     0.0   0.0   12.0 15.0     0.0   0.0     3.0   7.0   27.0 25 1 0   1 0     0   0   12 15     0 0   3 7   27
701264 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004504402 10 TREK PROGRAM Special Education Special Education School No Other KG 12 2017   grade_4 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 0 1   0 0     0   0   1 0                 1
701282 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004504351 17 JOURNEYS ALTERNATIVE PROGRAM Special Education Special Education School No Elementary KG 08 2017   grade_4 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 2 0 0   0 0     0   0   2 0                 2
701289 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004502732 18 EASTERN WRIGHT PROGRAM Special Education Special Education School No Elementary KG 07 2017   grade_4 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
701338 MN Wright 86 school 2700413 6090 Special Education Cooperatives Sherburne and Northern Wright Special Education Cooperative 270041304872 10 Pinewood Elementary - SNW Special Education Special Education School No Elementary KG 05 2017   grade_4 4.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 1.0         *         *   5.0 4 0 1   0 0     0   0   4 1                 5
701354 MN Wright 86 school 2700413 6090 Special Education Cooperatives Sherburne and Northern Wright Special Education Cooperative 270041304947 80 Becker Intermediate School - SNW Special Education Special Education School No Elementary 02 06 2017   grade_4 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
695288 MN Winona 85 school 2718090 857 Independent Districts and Schools LEWISTON-ALTURA PUBLIC SCHOOL DIST. 271809000835 10 LEWISTON-ALTURA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_4 41.0 0.0 4.0   0.0 1.0     0.0   1.0   26.0 21.0     1.0   1.0     25.0   11.0   47.0 41 0 4   0 1     0   1   26 21     1 1   25 11   47
695298 MN Winona 85 school 2733450 858 Independent Districts and Schools ST. CHARLES PUBLIC SCHOOL DISTRICT 273345001475 2 ST. CHARLES ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 66.0 0.0 9.0   0.0 0.0     0.0   6.0   45.0 36.0     2.0   0.0     22.0   7.0   81.0 66 0 9   0 0     0   6   45 36     2 0   22 7   81
695306 MN Winona 85 school 2744070 861 Independent Districts and Schools WINONA AREA PUBLIC SCHOOL DISTRICT 274407001822 2 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_4 46.0 7.0 4.0   0.0 10.0     0.0   3.0   41.0 29.0     11.0   0.0     38.0   16.0   70.0 46 7 4   0 10     0   3   41 29     11 0   38 16   70
695312 MN Winona 85 school 2744070 861 Independent Districts and Schools WINONA AREA PUBLIC SCHOOL DISTRICT 274407001824 4 MADISON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_4 27.0 1.0 4.0   0.0 1.0     0.0   2.0   20.0 15.0     1.0   0.0     14.0   8.0   35.0 27 1 4   0 1     0   2   20 15     1 0   14 8   35
695318 MN Winona 85 school 2744070 861 Independent Districts and Schools WINONA AREA PUBLIC SCHOOL DISTRICT 274407001827 11 ROLLINGSTONE COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_4 12.0 1.0 0.0   1.0 0.0     0.0   0.0   9.0 5.0     0.0   0.0     3.0   2.0   14.0 12 1 0   1 0     0   0   9 5     0 0   3 2   14
695324 MN Winona 85 school 2744070 861 Independent Districts and Schools WINONA AREA PUBLIC SCHOOL DISTRICT 274407001829 12 WASHINGTON-KOSCIUSKO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_4 60.0 8.0 2.0   0.0 0.0     0.0   8.0   36.0 42.0     0.0   1.0     41.0   18.0   78.0 60 8 2   0 0     0   8   36 42     0 1   41 18   78
695330 MN Winona 85 school 2744070 861 Independent Districts and Schools WINONA AREA PUBLIC SCHOOL DISTRICT 274407001821 15 GOODVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_4 29.0 1.0 3.0   0.0 0.0     0.0   2.0   18.0 17.0     2.0   0.0     19.0   8.0   35.0 29 1 3   0 0     0   2   18 17     2 0   19 8   35
696624 MN Winona 85 school 2705850 4001 Charter Schools BLUFFVIEW MONTESSORI 270585000018 10 BLUFFVIEW MONTESSORI Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_4 24.0 0.0 1.0   0.0 0.0     0.0   1.0   10.0 16.0     0.0   0.0     4.0   3.0   26.0 24 0 1   0 0     0   1   10 16     0 0   4 3   26
696849 MN Winona 85 school 2700221 4064 Charter Schools RIVERWAY LEARNING COMMUNITY CHTR 270022103478 10 Riverway Learning Community Charter Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_4 9.0 1.0 0.0   0.0 0.0     0.0   1.0   4.0 7.0     0.0   0.0     7.0   3.0   11.0 9 1 0   0 0     0   1   4 7     0 0   7 3   11
696910 MN Winona 85 school 2700194 4083 Charter Schools RIDGEWAY COMMUNITY SCHOOL 270019403147 10 RIDGEWAY COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2017   grade_4 16.0 0.0 0.0   0.0 0.0     1.0   0.0   10.0 7.0     0.0   0.0     3.0   3.0   17.0 16 0 0   0 0     1   0   10 7     0 0   3 3   17
695261 MN Wilkin 84 school 2706150 846 Independent Districts and Schools BRECKENRIDGE PUBLIC SCHOOL DISTRICT 270615000266 10 BRECKENRIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 34.0 1.0 2.0   2.0 0.0     0.0   3.0   19.0 23.0     1.0   0.0         11.0   42.0 34 1 2   2 0     0   3   19 23     1 0     11   42
695269 MN Wilkin 84 school 2732460 850 Independent Districts and Schools ROTHSAY PUBLIC SCHOOL DISTRICT 273246001400 10 ROTHSAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 35.0 1.0 0.0   0.0 0.0     0.0   0.0   20.0 16.0     0.0   0.0     19.0   2.0   36.0 35 1 0   0 0     0   0   20 16     0 0   19 2   36
695279 MN Wilkin 84 school 2707450 852 Independent Districts and Schools CAMPBELL-TINTAH PUBLIC SCHOOL DIST. 270745000319 10 CAMPBELL-TINTAH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 12.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 5.0     0.0   0.0     5.0   0.0   12.0 12 0 0   0 0     0   0   7 5     0 0   5 0   12
695233 MN Watonwan 83 school 2707320 836 Independent Districts and Schools BUTTERFIELD PUBLIC SCHOOL DISTRICT 270732000304 10 BUTTERFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 6.0 0.0 15.0   0.0 0.0     0.0   0.0   11.0 10.0     9.0   0.0     17.0   7.0   21.0 6 0 15   0 0     0   0   11 10     9 0   17 7   21
695242 MN Watonwan 83 school 2718570 837 Independent Districts and Schools MADELIA PUBLIC SCHOOL DISTRICT 271857000859 10 MADELIA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 19.0 1.0 19.0   0.0 0.0     0.0   0.0   17.0 22.0     15.0   0.0     22.0   3.0   39.0 19 1 19   0 0     0   0   17 22     15 0   22 3   39
695249 MN Watonwan 83 school 2733600 840 Independent Districts and Schools ST. JAMES PUBLIC SCHOOL DISTRICT 273360001506 20 ST. JAMES NORTHSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   grade_4 24.0 0.0 38.0   0.0 0.0     0.0   1.0   27.0 36.0     12.0   3.0     40.0   7.0   63.0 24 0 38   0 0     0   1   27 36     12 3   40 7   63
693693 MN Washington 82 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385002182 28 CASTLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 29.0 18.0 5.0   0.0 11.0     0.0   11.0   30.0 44.0     12.0   3.0     41.0   10.0   74.0 29 18 5   0 11     0   11   30 44     12 3   41 10   74
693707 MN Washington 82 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001169 30 EAGLE POINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 37.0 10.0 11.0   0.0 15.0     0.0   4.0   40.0 37.0     6.0   1.0     26.0   *   77.0 37 10 11   0 15     0   4   40 37     6 1   26     77
693714 MN Washington 82 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001175 33 OAKDALE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 40.0 15.0 12.0   1.0 13.0     0.0   11.0   42.0 50.0     8.0   1.0     58.0   14.0   92.0 40 15 12   1 13     0   11   42 50     8 1   58 14   92
693744 MN Washington 82 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385002665 37 SKYVIEW COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 45.0 33.0 14.0   0.0 14.0     0.0   5.0   71.0 40.0     13.0   2.0     53.0   24.0   111.0 45 33 14   0 14     0   5   71 40     13 2   53 24   111
693815 MN Washington 82 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236003699 824 ONEKA ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 02 05 2017   grade_4 146.0 3.0 6.0   0.0 5.0     0.0   6.0   72.0 94.0     2.0   0.0     17.0   15.0   166.0 146 3 6   0 5     0   6   72 94     2 0   17 15   166
694980 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000593 625 COLUMBUS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_4 40.0 0.0 1.0   0.0 3.0     0.0   2.0   28.0 18.0     0.0   0.0     10.0   7.0   46.0 40 0 1   0 3     0   2   28 18     0 0   10 7   46
694984 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000594 626 FOREST LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 04 06 2017   grade_4 99.0 1.0 9.0   0.0 4.0     0.0   11.0   58.0 66.0     7.0   0.0     45.0   20.0   124.0 99 1 9   0 4     0   11   58 66     7 0   45 20   124
695005 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000598 629 Linwood Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_4 58.0 1.0 1.0   2.0 2.0     0.0   2.0   41.0 25.0     1.0   0.0     26.0   12.0   66.0 58 1 1   2 2     0   2   41 25     1 0   26 12   66
695013 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000599 630 Scandia Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_4 39.0 0.0 1.0   0.0 0.0     0.0   2.0   20.0 22.0     0.0   0.0     4.0   8.0   42.0 39 0 1   0 0     0   2   20 22     0 0   4 8   42
695021 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000601 631 Wyoming Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 80.0 1.0 1.0   0.0 3.0     0.0   5.0   48.0 42.0     1.0   0.0     17.0   21.0   90.0 80 1 1   0 3     0   5   48 42     1 0   17 21   90
695029 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227001757 633 CENTRAL MONTESSORI ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 14.0 0.0 1.0   0.0 1.0     0.0   1.0   8.0 9.0     0.0   0.0     6.0   2.0   17.0 14 0 1   0 1     0   1   8 9     0 0   6 2   17
695034 MN Washington 82 school 2718750 832 Independent Districts and Schools MAHTOMEDI PUBLIC SCHOOL DISTRICT 271875000868 10 O.H. ANDERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2017   grade_4 202.0 5.0 11.0   0.0 3.0     0.0   15.0   126.0 110.0     6.0   0.0     21.0   23.0   236.0 202 5 11   0 3     0   15   126 110     6 0   21 23   236
695045 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001537 30 ARMSTRONG ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 42.0 3.0 4.0   0.0 5.0     0.0   6.0   36.0 24.0     7.0   0.0     19.0   8.0   60.0 42 3 4   0 5     0   6   36 24     7 0   19 8   60
695052 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381004232 31 Nuevas Fronteras Spanish Immersion Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 44.0 1.0 13.0   0.0 0.0     0.0   2.0   30.0 30.0     2.0   0.0     8.0   9.0   60.0 44 1 13   0 0     0   2   30 30     2 0   8 9   60
695059 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001538 32 CRESTVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 22.0 12.0 9.0   1.0 2.0     0.0   3.0   30.0 19.0     8.0   0.0     28.0   14.0   49.0 22 12 9   1 2     0   3   30 19     8 0   28 14   49
695066 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381002305 34 GREY CLOUD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 99.0 10.0 8.0   0.0 7.0     0.0   12.0   80.0 56.0     8.0   2.0     25.0   21.0   136.0 99 10 8   0 7     0   12   80 56     8 2   25 21   136
695073 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001540 36 HILLSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 51.0 1.0 8.0   0.0 8.0     0.0   4.0   29.0 43.0     9.0   0.0     35.0   5.0   72.0 51 1 8   0 8     0   4   29 43     9 0   35 5   72
695080 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381003169 37 COTTAGE GROVE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 74.0 7.0 3.0   0.0 15.0     0.0   7.0   52.0 54.0     11.0   0.0     21.0   13.0   106.0 74 7 3   0 15     0   7   52 54     11 0   21 13   106
695089 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001541 38 NEWPORT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 25.0 4.0 8.0   1.0 3.0     0.0   2.0   21.0 22.0     5.0   2.0     24.0   7.0   43.0 25 4 8   1 3     0   2   21 22     5 2   24 7   43
695096 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001544 40 PINE HILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 32.0 11.0 14.0   0.0 7.0     0.0   4.0   38.0 30.0     14.0   0.0     29.0   6.0   68.0 32 11 14   0 7     0   4   38 30     14 0   29 6   68
695103 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381003198 41 LIBERTY RIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 115.0 12.0 20.0   0.0 25.0     0.0   6.0   81.0 97.0     10.0   0.0     11.0   16.0   178.0 115 12 20   0 25     0   6   81 97     10 0   11 16   178
695110 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001545 42 PULLMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 39.0 3.0 7.0   1.0 5.0     0.0   7.0   25.0 37.0     6.0   0.0     30.0   8.0   62.0 39 3 7   1 5     0   7   25 37     6 0   30 8   62
695117 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381003103 43 RED ROCK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 53.0 7.0 5.0   0.0 10.0     0.0   3.0   36.0 42.0     4.0   0.0     9.0   5.0   78.0 53 7 5   0 10     0   3   36 42     4 0   9 5   78
695124 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001546 44 ROYAL OAKS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 45.0 10.0 6.0   0.0 9.0     0.0   13.0   40.0 43.0     11.0   0.0     27.0   11.0   83.0 45 10 6   0 9     0   13   40 43     11 0   27 11   83
695131 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381002304 45 GORDON BAILEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 53.0 10.0 11.0   0.0 9.0     0.0   10.0   42.0 51.0     0.0   0.0     20.0   12.0   93.0 53 10 11   0 9     0   10   42 51     0 0   20 12   93
695138 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001548 46 WOODBURY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 43.0 9.0 10.0   0.0 16.0     0.0   3.0   48.0 33.0     11.0   0.0     25.0   9.0   81.0 43 9 10   0 16     0   3   48 33     11 0   25 9   81
695145 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381002306 47 MIDDLETON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 82.0 13.0 8.0   0.0 25.0     1.0   7.0   76.0 60.0     14.0   0.0     13.0   16.0   136.0 82 13 8   0 25     1   7   76 60     14 0   13 16   136
695152 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381004967 75 Valley Crossing Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_4 91.0 9.0 6.0   0.0 14.0     0.0   11.0   65.0 66.0     3.0   0.0     9.0   17.0   131.0 91 9 6   0 14     0   11   65 66     3 0   9 17   131
695159 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001654 785 AFTON-LAKELAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_4 67.0 2.0 1.0   0.0 4.0     0.0   1.0   39.0 36.0         0.0     10.0   20.0   75.0 67 2 1   0 4     0   1   39 36       0   10 20   75
695167 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001655 786 ANDERSEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_4 39.0 0.0 0.0   0.0 3.0     0.0   1.0   24.0 19.0     0.0   0.0         5.0   43.0 39 0 0   0 3     0   1   24 19     0 0     5   43
695175 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001656 787 LAKE ELMO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_4 62.0 14.0 16.0   0.0 8.0     0.0   2.0   49.0 53.0     12.0   0.0     39.0   8.0   102.0 62 14 16   0 8     0   2   49 53     12 0   39 8   102
695183 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001657 788 LILY LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_4 46.0 5.0 2.0   0.0 1.0     0.0   2.0   27.0 29.0         0.0     14.0   12.0   56.0 46 5 2   0 1     0   2   27 29       0   14 12   56
695191 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001658 789 MARINE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_4 16.0 0.0 4.0   0.0 1.0     0.0   0.0   8.0 13.0     0.0   0.0         4.0   21.0 16 0 4   0 1     0   0   8 13     0 0     4   21
695199 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001659 790 OAK PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_4 50.0 3.0 1.0   1.0 2.0     0.0   2.0   32.0 27.0     0.0   0.0     15.0   15.0   59.0 50 3 1   1 2     0   2   32 27     0 0   15 15   59
695207 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001665 792 WITHROW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_4 21.0 0.0 0.0   0.0 1.0     0.0   3.0   14.0 11.0     0.0   0.0     2.0   5.0   25.0 21 0 0   0 1     0   3   14 11     0 0   2 5   25
695215 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001663 793 STONEBRIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_4 67.0 0.0 3.0   0.0 0.0     0.0   3.0   35.0 38.0     0.0   0.0     9.0   13.0   73.0 67 0 3   0 0     0   3   35 38     0 0   9 13   73
695223 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819003004 804 RUTHERFORD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_4 80.0 0.0 0.0   0.0 0.0     0.0   7.0   40.0 47.0     0.0   1.0     7.0   15.0   87.0 80 0 0   0 0     0   7   40 47     0 1   7 15   87
697001 MN Washington 82 school 2700358 4116 Charter Schools Lakes International Language Academy 270035804102 10 Lakes International Language Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2017   grade_4 86.0 0.0 16.0   0.0 1.0     0.0   10.0   47.0 66.0     0.0   0.0     16.0   11.0   113.0 86 0 16   0 1     0   10   47 66     0 0   16 11   113
697017 MN Washington 82 school 2700362 4120 Charter Schools ST. CROIX PREPARATORY ACADEMY 270036204106 10 ST. CROIX PREPARATORY ACADEMY LOWER Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2017   grade_4 75.0 2.0 4.0   0.0 4.0     0.0   5.0   49.0 41.0     2.0   0.0     7.0   16.0   90.0 75 2 4   0 4     0   5   49 41     2 0   7 16   90
697285 MN Washington 82 school 2700310 4187 Charter Schools NATURAL SCIENCE ACADEMY 270031004276 10 NATURAL SCIENCE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2017   grade_4 5.0 1.0 4.0   0.0 1.0     0.0   0.0   6.0 5.0     0.0   0.0     0.0   0.0   11.0 5 1 4   0 1     0   0   6 5     0 0   0 0   11
697486 MN Washington 82 school 2700401 4228 Charter Schools Woodbury Leadership Academy 270040104812 10 Woodbury Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_4 20.0 2.0 1.0   0.0 9.0     0.0   2.0   14.0 20.0     2.0   0.0     3.0   5.0   34.0 20 2 1   0 9     0   2   14 20     2 0   3 5   34
701123 MN Washington 82 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226402100 50 ALP @ VCCS Special Education Special Education School No Elementary KG 06 2017   grade_4 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
702716 MN Washington 82 school 2723380 4003 Charter Schools NEW HEIGHTS SCHOOL, INC. 272338000020 10 NEW HEIGHTS SCHOOL, INC. Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_4 4.0 2.0 2.0   0.0 0.0     0.0   1.0   3.0 6.0         *         *   9.0 4 2 2   0 0     0   1   3 6                 9
694972 MN Waseca 81 school 2741880 829 Independent Districts and Schools WASECA PUBLIC SCHOOL DISTRICT 274188001746 40 WASECA INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 04 06 2017   grade_4 116.0 7.0 10.0   0.0 2.0     0.0   3.0   74.0 64.0     4.0   1.0     52.0   22.0   138.0 116 7 10   0 2     0   3   74 64     4 1   52 22   138
696044 MN Waseca 81 school 2791451 2835 Independent Districts and Schools JANESVILLE-WALDORF-PEMBERTON 279145102327 10 JANESVILLE-WALDORF-PEMBERTON EL.EM. Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 48.0 1.0 2.0   0.0 0.0     0.0   0.0   21.0 30.0     0.0   0.0     21.0   7.0   51.0 48 1 2   0 0     0   0   21 30     0 0   21 7   51
697047 MN Waseca 81 school 2700241 4127 Charter Schools TEAM ACADEMY 270024103341 10 TEAM ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_4 16.0 0.0 5.0   0.0 0.0     0.0   0.0   8.0 13.0     3.0   1.0     15.0   6.0   21.0 16 0 5   0 0     0   0   8 13     3 1   15 6   21
694946 MN Wadena 80 school 2740920 818 Independent Districts and Schools VERNDALE PUBLIC SCHOOL DISTRICT 274092001712 10 VERNDALE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 49.0 0.0 1.0   1.0 0.0     1.0   0.0   28.0 24.0     0.0   0.0     33.0   11.0   52.0 49 0 1   1 0     1   0   28 24     0 0   33 11   52
694955 MN Wadena 80 school 2732970 820 Independent Districts and Schools SEBEKA PUBLIC SCHOOL DISTRICT 273297001435 1 SEBEKA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 33.0 0.0 0.0   0.0 1.0     0.0   1.0   17.0 18.0     0.0   0.0     15.0   5.0   35.0 33 0 0   0 1     0   1   17 18     0 0   15 5   35
694964 MN Wadena 80 school 2720580 821 Independent Districts and Schools MENAHGA PUBLIC SCHOOL DISTRICT 272058000917 10 MENAHGA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_4 82.0 0.0 2.0   1.0 0.0     0.0   1.0   35.0 51.0     0.0   0.0     46.0   15.0   86.0 82 0 2   1 0     0   1   35 51     0 0   46 15   86
695629 MN Wadena 80 school 2700022 2155 Independent Districts and Schools WADENA-DEER CREEK SCHOOL DISTRICT 270002200431 2 WADENA-DEER CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_4 75.0 2.0 4.0   0.0 0.0     0.0   7.0   42.0 46.0     0.0   0.0     50.0   13.0   88.0 75 2 4   0 0     0   7   42 46     0 0   50 13   88
694928 MN Wabasha 79 school 2741060 811 Independent Districts and Schools WABASHA-KELLOGG PUBLIC SCHOOL DIST. 274106001723 30 WABASHA-KELLOGG ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 34.0 4.0 2.0   0.0 0.0     0.0   1.0   14.0 27.0     0.0   0.0     18.0   6.0   41.0 34 4 2   0 0     0   1   14 27     0 0   18 6   41
694937 MN Wabasha 79 school 2717520 813 Independent Districts and Schools LAKE CITY PUBLIC SCHOOL DISTRICT 271752000803 10 BLUFF VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 107.0 0.0 5.0   0.0 0.0     0.0   4.0   61.0 55.0     1.0   0.0     30.0   15.0   116.0 107 0 5   0 0     0   4   61 55     1 0   30 15   116
696030 MN Wabasha 79 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573500200 1 ZUMBROTA-MAZEPPA ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   grade_4 83.0 3.0 2.0   1.0 2.0     0.0   1.0   43.0 49.0     0.0   0.0     22.0   18.0   92.0 83 3 2   1 2     0   1   43 49     0 0   22 18   92
696181 MN Wabasha 79 school 2700287 2899 Independent Districts and Schools PLAINVIEW-ELGIN-MILLVILLE 270028703667 20 PLAINVIEW-ELGIN-MILLVILLE 4-6 Elementary School (Grades PK-6) Regular School No Elementary 04 06 2017   grade_4 88.0 0.0 9.0   0.0 0.0     0.0   2.0   59.0 40.0     1.0   0.0     37.0   19.0   99.0 88 0 9   0 0     0   2   59 40     1 0   37 19   99
701525 MN Wabasha 79 school 2700055 6013 Education Districts HIAWATHA VALLEY ED. DISTRICT 270005504535 31 SAIL PROGRAM Special Education Special Education School No Other PK 12 2017   grade_4 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
694912 MN Traverse 78 school 2707110 801 Independent Districts and Schools BROWNS VALLEY PUBLIC SCHOOL DIST. 270711000279 10 BROWNS VALLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_4 8.0 0.0 0.0   13.0 0.0     0.0   0.0   12.0 9.0     0.0   0.0     14.0   5.0   21.0 8 0 0   13 0     0   0   12 9     0 0   14 5   21

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