Data source: Big Local News · About: Big Local

963 rows where grade = "grade_2", state = "MN" and year = 2019 sorted by asian

View and edit SQL

year

  • 2019 · 963

grade

  • grade_2 · 963
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
1945923 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401000723 1 HILL CITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_2 16.0 0.0 1.0   0.0 0.0     0.0   0.0   9.0 8.0     0.0   0.0     12.0   5.0   17.0 16 0 1   0 0     0   0   9 8     0 0   12 5   17
1945931 MN Aitkin 1 school 2719170 4 Independent Districts and Schools MCGREGOR PUBLIC SCHOOL DISTRICT 271917000903 10 MCGREGOR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 18.0 0.0 0.0   8.0 0.0     0.0   0.0   14.0 12.0     0.0   0.0     8.0   5.0   26.0 18 0 0   8 0     0   0   14 12     0 0   8 5   26
1945954 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000105 403 FRANKLIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 48.0 17.0 5.0   1.0 0.0     0.0   4.0   34.0 41.0     10.0   2.0     42.0   *   75.0 48 17 5   1 0     0   4   34 41     10 2   42     75
1946248 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023002268 60 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_2 74.0 2.0 3.0   18.0 0.0     0.0   12.0   57.0 52.0     0.0   1.0     47.0   24.0   109.0 74 2 3   18 0     0   12   57 52     0 1   47 24   109
1946255 MN Becker 3 school 2712360 23 Independent Districts and Schools FRAZEE-VERGAS PUBLIC SCHOOL DIST. 271236000607 10 FRAZEE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 59.0 0.0 3.0   4.0 0.0     0.0   3.0   28.0 41.0     0.0   0.0     34.0   10.0   69.0 59 0 3   4 0     0   3   28 41     0 0   34 10   69
1946263 MN Becker 3 school 2728960 25 Independent Districts and Schools PINE POINT PUBLIC SCHOOL DISTRICT 272896000034 70 PINE POINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   grade_2 0.0 0.0 0.0   7.0 0.0     0.0   0.0   4.0 3.0     *   *         *   7.0 0 0 0   7 0     0   0   4 3                 7
1946285 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000196 40 J.W. SMITH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   grade_2 23.0 4.0 1.0   20.0 0.0     0.0   12.0   28.0 32.0     0.0   0.0     39.0   15.0   60.0 23 4 1   20 0     0   12   28 32     0 0   39 15   60
1946292 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000191 50 CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   grade_2 20.0 2.0 3.0   13.0 0.0     0.0   3.0   24.0 17.0     1.0   3.0     34.0   10.0   41.0 20 2 3   13 0     0   3   24 17     1 3   34 10   41
1946304 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000197 80 SOLWAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   grade_2 27.0 0.0 0.0   1.0 0.0     0.0   2.0   18.0 12.0     0.0   0.0     16.0   4.0   30.0 27 0 0   1 0     0   2   18 12     0 0   16 4   30
1946316 MN Beltrami 4 school 2705730 32 Independent Districts and Schools BLACKDUCK PUBLIC SCHOOL DISTRICT 270573000212 10 BLACKDUCK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 31.0 0.0 1.0   3.0 0.0     0.0   1.0   22.0 14.0     1.0   0.0     25.0   10.0   36.0 31 0 1   3 0     0   1   22 14     1 0   25 10   36
1946326 MN Beltrami 4 school 2717010 36 Independent Districts and Schools KELLIHER PUBLIC SCHOOL DISTRICT 271701000786 10 KELLIHER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 12.0 0.0 0.0   7.0 0.0     0.0   0.0   8.0 11.0     0.0   0.0     14.0   3.0   19.0 12 0 0   7 0     0   0   8 11     0 0   14 3   19
1946333 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051001302 10 RED LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2019   grade_2 0.0 0.0 0.0   129.0 0.0     0.0   0.0   65.0 64.0     0.0   14.0         25.0   129.0 0 0 0   129 0     0   0   65 64     0 14     25   129
1946344 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051001301 20 PONEMAH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   grade_2 0.0 0.0 0.0   19.0 0.0     0.0   0.0   8.0 11.0     0.0   7.0         5.0   19.0 0 0 0   19 0     0   0   8 11     0 7     5   19
1946354 MN Benton 5 school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288001430 3 MISSISSIPPI HEIGHTS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 153.0 4.0 10.0   2.0 0.0     0.0   14.0   90.0 93.0     2.0   1.0     45.0   26.0   183.0 153 4 10   2 0     0   14   90 93     2 1   45 26   183
1946362 MN Benton 5 school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288001433 6 RICE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 62.0 1.0 2.0   0.0 0.0     0.0   2.0   41.0 26.0     0.0   0.0     19.0   16.0   67.0 62 1 2   0 0     0   2   41 26     0 0   19 16   67
1946369 MN Benton 5 school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288001431 7 PLEASANT VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 104.0 5.0 6.0   0.0 0.0     0.0   4.0   56.0 63.0     1.0   0.0     47.0   34.0   119.0 104 5 6   0 0     0   4   56 63     1 0   47 34   119
1946377 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224000590 10 FOLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   grade_2 140.0 0.0 0.0   1.0 0.0     0.0   1.0   63.0 79.0     0.0   0.0     40.0   17.0   142.0 140 0 0   1 0     0   1   63 79     0 0   40 17   142
1946389 MN Blue Earth 7 school 2733480 75 Independent Districts and Schools ST. CLAIR PUBLIC SCHOOL DISTRICT 273348001477 10 ST. CLAIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 49.0 0.0 0.0   0.0 0.0     0.0   0.0   23.0 26.0     0.0   *     11.0   6.0   49.0 49 0 0   0 0     0   0   23 26     0     11 6   49
1946399 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000877 10 KENNEDY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 38.0 14.0 8.0   1.0 0.0     0.0   5.0   34.0 32.0     12.0   2.0     32.0   11.0   66.0 38 14 8   1 0     0   5   34 32     12 2   32 11   66
1946406 MN Nicollet 52 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000875 20 HOOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 52.0 16.0 6.0   0.0 0.0     0.0   4.0   46.0 32.0     9.0   1.0     22.0   9.0   78.0 52 16 6   0 0     0   4   46 32     9 1   22 9   78
1946413 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000876 30 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 35.0 1.0 1.0   0.0 0.0     0.0   0.0   21.0 16.0     1.0   0.0     8.0   5.0   37.0 35 1 1   0 0     0   0   21 16     1 0   8 5   37
1946448 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000884 80 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 51.0 13.0 5.0   3.0 0.0     1.0   3.0   39.0 37.0     7.0   1.0     29.0   5.0   76.0 51 13 5   3 0     1   3   39 37     7 1   29 5   76
1946455 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000873 90 FRANKLIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 47.0 8.0 7.0   0.0 0.0     0.0   3.0   30.0 35.0     8.0   0.0     30.0   12.0   65.0 47 8 7   0 0     0   3   30 35     8 0   30 12   65
1946470 MN Brown 8 school 2709540 81 Independent Districts and Schools COMFREY PUBLIC SCHOOL DISTRICT 270954000403 10 COMFREY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 10.0 0.0 0.0   0.0 0.0     0.0   1.0   7.0 4.0     0.0   0.0     3.0   2.0   11.0 10 0 0   0 0     0   1   7 4     0 0   3 2   11
1946489 MN Brown 8 school 2733390 85 Independent Districts and Schools SPRINGFIELD PUBLIC SCHOOL DISTRICT 273339001470 2 SPRINGFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 36.0 0.0 7.0   0.0 0.0     0.0   0.0   23.0 20.0     *   0.0     30.0   7.0   43.0 36 0 7   0 0     0   0   23 20       0   30 7   43
1946496 MN Brown 8 school 2723490 88 Independent Districts and Schools NEW ULM PUBLIC SCHOOL DISTRICT 272349001150 20 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2019   grade_2 130.0 1.0 9.0   0.0 0.0     0.0   6.0   66.0 80.0     1.0   0.0     55.0   33.0   146.0 130 1 9   0 0     0   6   66 80     1 0   55 33   146
1946506 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000171 1 BARNUM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 55.0 0.0 2.0   0.0 0.0     0.0   0.0   25.0 32.0     0.0   0.0     20.0   16.0   57.0 55 0 2   0 0     0   0   25 32     0 0   20 16   57
1946515 MN Carlton 9 school 2707590 93 Independent Districts and Schools CARLTON PUBLIC SCHOOL DISTRICT 270759000328 2 SOUTH TERRACE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 22.0 0.0 0.0   4.0 0.0     0.0   1.0   16.0 11.0     0.0   0.0     11.0   5.0   27.0 22 0 0   4 0     0   1   16 11     0 0   11 5   27
1946528 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942000384 105 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 74.0 0.0 2.0   21.0 0.0     0.0   16.0   61.0 52.0     0.0   1.0     54.0   19.0   113.0 74 0 2   21 0     0   16   61 52     0 1   54 19   113
1946535 MN Carlton 9 school 2709690 95 Independent Districts and Schools CROMWELL-WRIGHT PUBLIC SCHOOLS 270969000410 10 CROMWELL-WRIGHT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 18.0 0.0 0.0   0.0 0.0     0.0   0.0   9.0 9.0     0.0   0.0         1.0   18.0 18 0 0   0 0     0   0   9 9     0 0     1   18
1946544 MN Carlton 9 school 2721450 97 Independent Districts and Schools MOOSE LAKE PUBLIC SCHOOL DISTRICT 272145001093 20 MOOSE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 36.0 0.0 1.0   1.0 0.0     0.0   1.0   18.0 21.0     *   2.0     17.0   8.0   39.0 36 0 1   1 0     0   1   18 21       2   17 8   39
1946553 MN Carlton 9 school 2738880 99 Independent Districts and Schools ESKO PUBLIC SCHOOL DISTRICT 273888001683 30 WINTERQUIST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 85.0 0.0 2.0   0.0 0.0     0.0   5.0   44.0 48.0     0.0   4.0     13.0   12.0   92.0 85 0 2   0 0     0   5   44 48     0 4   13 12   92
1946562 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001842 1 WRENSHALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 17.0 1.0 0.0   0.0 0.0     0.0   3.0   6.0 15.0     *   0.0         3.0   21.0 17 1 0   0 0     0   3   6 15       0     3   21
1946571 MN Carver 10 school 2723910 108 Independent Districts and Schools CENTRAL PUBLIC SCHOOL DISTRICT 272391001187 40 CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 61.0 4.0 4.0   0.0 0.0     1.0   2.0   31.0 41.0     2.0   0.0     23.0   10.0   72.0 61 4 4   0 0     1   2   31 41     2 0   23 10   72
1946592 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146004916 130 Laketown Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 86.0 1.0 2.0   0.0 0.0     0.0   5.0   49.0 45.0     1.0   0.0     5.0   14.0   94.0 86 1 2   0 0     0   5   49 45     1 0   5 14   94
1946628 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000346 507 EAST UNION ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 23.0 0.0 3.0   0.0 0.0     0.0   2.0   18.0 10.0     0.0   0.0     5.0   4.0   28.0 23 0 3   0 0     0   2   18 10     0 0   5 4   28
1946667 MN Cass 11 school 2702910 113 Independent Districts and Schools WALKER-HACKENSACK-AKELEY SCHL. DIST 270291001736 10 W.H.A. ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 33.0 0.0 3.0   19.0 0.0     0.0   5.0   34.0 26.0     0.0   4.0     35.0   14.0   60.0 33 0 3   19 0     0   5   34 26     0 4   35 14   60
1946676 MN Cass 11 school 2708070 115 Independent Districts and Schools CASS LAKE-BENA PUBLIC SCHOOLS 270807000330 10 CASS LAKE-BENA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_2 8.0 0.0 6.0   60.0 0.0     1.0   15.0   40.0 50.0     0.0   0.0     75.0   21.0   90.0 8 0 6   60 0     1   15   40 50     0 0   75 21   90
1946683 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_2 89.0 1.0 3.0   0.0 0.0     0.0   2.0   54.0 41.0     0.0   0.0     44.0   14.0   95.0 89 1 3   0 0     0   2   54 41     0 0   44 14   95
1946691 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_2 9.0 0.0 0.0   12.0 0.0     0.0   0.0   11.0 10.0     0.0   0.0     16.0   4.0   21.0 9 0 0   12 0     0   0   11 10     0 0   16 4   21
1946698 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_2 81.0 3.0 23.0   0.0 0.0     1.0   8.0   61.0 55.0     17.0   0.0     53.0   25.0   116.0 81 3 23   0 0     1   8   61 55     17 0   53 25   116
1946721 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_2 56.0 0.0 2.0   0.0 0.0     0.0   2.0   36.0 24.0     0.0   0.0     12.0   9.0   60.0 56 0 2   0 0     0   2   36 24     0 0   12 9   60
1946729 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_2 76.0 0.0 2.0   0.0 0.0     0.0   0.0   43.0 35.0     *   *         *   78.0 76 0 2   0 0     0   0   43 35                 78
1946737 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_2 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 2 0 0   0 0     0   0   1 1                 2
1946750 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_2 76.0 9.0 15.0   6.0 0.0     0.0   7.0   64.0 49.0     10.0   6.0     62.0   24.0   113.0 76 9 15   6 0     0   7   64 49     10 6   62 24   113
1946762 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_2 103.0 18.0 5.0   0.0 0.0     0.0   5.0   66.0 65.0     24.0   0.0     50.0   14.0   131.0 103 18 5   0 0     0   5   66 65     24 0   50 14   131
1946770 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_2 64.0 1.0 1.0   8.0 0.0     0.0   8.0   43.0 39.0     0.0   0.0     40.0   11.0   82.0 64 1 1   8 0     0   8   43 39     0 0   40 11   82
1946780 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_2 23.0 0.0 6.0   1.0 0.0     0.0   1.0   22.0 9.0     0.0   0.0     11.0   4.0   31.0 23 0 6   1 0     0   1   22 9     0 0   11 4   31
1946801 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_2 87.0 1.0 1.0   2.0 0.0     0.0   3.0   42.0 52.0     0.0   *         16.0   94.0 87 1 1   2 0     0   3   42 52     0       16   94
1946807 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_2 79.0 1.0 0.0   4.0 0.0     0.0   6.0   39.0 51.0     0.0   0.0     53.0   19.0   90.0 79 1 0   4 0     0   6   39 51     0 0   53 19   90
1946813 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_2 48.0 2.0 0.0   0.0 0.0     0.0   1.0   23.0 28.0     0.0   2.0     35.0   12.0   51.0 48 2 0   0 0     0   1   23 28     0 2   35 12   51
1946819 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_2 79.0 0.0 1.0   1.0 0.0     0.0   7.0   41.0 47.0     0.0   0.0     32.0   8.0   88.0 79 0 1   1 0     0   7   41 47     0 0   32 8   88
1946825 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_2 91.0 0.0 1.0   2.0 0.0     0.0   3.0   45.0 52.0     0.0   *     51.0   28.0   97.0 91 0 1   2 0     0   3   45 52     0     51 28   97
1946831 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_2 60.0 0.0 2.0   0.0 0.0     0.0   3.0   38.0 27.0     0.0   0.0         8.0   65.0 60 0 2   0 0     0   3   38 27     0 0     8   65
1946838 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_2 65.0 0.0 1.0   1.0 0.0     0.0   1.0   31.0 37.0     0.0   0.0     31.0   13.0   68.0 65 0 1   1 0     0   1   31 37     0 0   31 13   68
1946847 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_2 106.0 0.0 0.0   3.0 0.0     0.0   0.0   47.0 62.0     0.0   0.0     29.0   8.0   109.0 106 0 0   3 0     0   0   47 62     0 0   29 8   109
1947024 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_2 80.0 1.0 1.0   1.0 0.0     0.0   5.0   42.0 46.0     *   0.0         11.0   88.0 80 1 1   1 0     0   5   42 46       0     11   88
1947046 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_2 51.0 0.0 3.0   0.0 0.0     0.0   0.0   26.0 28.0     0.0   0.0     7.0   11.0   54.0 51 0 3   0 0     0   0   26 28     0 0   7 11   54
1947252 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_2 93.0 2.0 5.0   0.0 0.0     0.0   10.0   50.0 60.0     *   0.0     36.0   14.0   110.0 93 2 5   0 0     0   10   50 60       0   36 14   110
1947264 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_2 83.0 5.0 4.0   1.0 0.0     0.0   5.0   52.0 46.0     4.0   2.0     34.0   18.0   98.0 83 5 4   1 0     0   5   52 46     4 2   34 18   98
1947271 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_2 38.0 2.0 3.0   0.0 0.0     0.0   1.0   24.0 20.0     0.0   1.0     15.0   10.0   44.0 38 2 3   0 0     0   1   24 20     0 1   15 10   44
1947285 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_2 21.0 0.0 0.0   0.0 0.0     0.0   0.0   11.0 10.0     0.0   0.0     6.0   *   21.0 21 0 0   0 0     0   0   11 10     0 0   6     21
1947292 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_2 24.0 0.0 1.0   0.0 0.0     0.0   0.0   10.0 15.0     0.0   0.0     5.0   2.0   25.0 24 0 1   0 0     0   0   10 15     0 0   5 2   25
1947306 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_2 22.0 0.0 0.0   0.0 0.0     0.0   2.0   14.0 10.0     0.0   0.0     5.0   *   24.0 22 0 0   0 0     0   2   14 10     0 0   5     24
1947313 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_2 61.0 2.0 1.0   0.0 0.0     0.0   3.0   34.0 33.0     0.0   3.0     29.0   11.0   67.0 61 2 1   0 0     0   3   34 33     0 3   29 11   67
1947330 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_2 52.0 0.0 1.0   0.0 0.0     0.0   1.0   21.0 33.0     0.0   2.0     22.0   8.0   54.0 52 0 1   0 0     0   1   21 33     0 2   22 8   54
1947348 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_2 29.0 0.0 0.0   0.0 0.0     1.0   0.0   14.0 16.0     0.0   0.0     14.0   7.0   30.0 29 0 0   0 0     1   0   14 16     0 0   14 7   30
1947357 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_2 20.0 0.0 0.0   0.0 0.0     0.0   1.0   9.0 12.0     0.0   0.0         3.0   21.0 20 0 0   0 0     0   1   9 12     0 0     3   21
1947366 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_2 42.0 0.0 0.0   0.0 0.0     0.0   5.0   27.0 20.0     0.0   0.0     17.0   4.0   47.0 42 0 0   0 0     0   5   27 20     0 0   17 4   47
1947406 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_2 30.0 0.0 3.0   0.0 0.0     0.0   0.0   19.0 14.0     0.0   0.0     10.0   4.0   33.0 30 0 3   0 0     0   0   19 14     0 0   10 4   33
1947415 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_2 76.0 0.0 2.0   0.0 0.0     0.0   2.0   38.0 42.0     1.0   0.0     22.0   10.0   80.0 76 0 2   0 0     0   2   38 42     1 0   22 10   80
1947422 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_2 47.0 0.0 1.0   0.0 0.0     0.0   0.0   24.0 24.0     1.0   0.0     3.0   0.0   48.0 47 0 1   0 0     0   0   24 24     1 0   3 0   48
1947447 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 2019   grade_2 21.0 0.0 0.0   0.0 0.0     0.0   1.0   13.0 9.0     0.0   *     9.0   3.0   22.0 21 0 0   0 0     0   1   13 9     0     9 3   22
1947456 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 2019   grade_2 6.0 0.0 1.0   0.0 0.0     0.0   3.0   7.0 3.0     0.0   0.0     6.0   4.0   10.0 6 0 1   0 0     0   3   7 3     0 0   6 4   10
1947739 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001110 616 HILLTOP PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_2 72.0 1.0 4.0   0.0 0.0     0.0   3.0   43.0 37.0     1.0   0.0     5.0   18.0   80.0 72 1 4   0 0     0   3   43 37     1 0   5 18   80
1947918 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175004212 705 RICHFIELD DUAL LANGUAGE SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 12.0 1.0 48.0   0.0 0.0     0.0   3.0   28.0 36.0     36.0   2.0     49.0   5.0   64.0 12 1 48   0 0     0   3   28 36     36 2   49 5   64
1948121 MN Houston 28 school 2714280 294 Independent Districts and Schools HOUSTON PUBLIC SCHOOL DISTRICT 271428000748 10 HOUSTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 27.0 0.0 1.0   0.0 0.0     0.0   0.0   11.0 17.0     0.0   0.0     12.0   6.0   28.0 27 0 1   0 0     0   0   11 17     0 0   12 6   28
1948130 MN Houston 28 school 2733300 297 Independent Districts and Schools SPRING GROVE SCHOOL DISTRICT 273330001458 10 SPRING GROVE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 18.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 10.0     0.0   0.0         3.0   18.0 18 0 0   0 0     0   0   8 10     0 0     3   18
1948139 MN Houston 28 school 2707380 299 Independent Districts and Schools CALEDONIA PUBLIC SCHOOL DISTRICT 270738000309 10 CALEDONIA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 39.0 0.0 0.0   0.0 0.0     0.0   1.0   18.0 22.0     0.0   1.0     16.0   9.0   40.0 39 0 0   0 0     0   1   18 22     0 1   16 9   40
1948147 MN Houston 28 school 2717250 300 Independent Districts and Schools LA CRESCENT-HOKAH SCHOOL DISTRICT 271725000799 10 LA CRESCENT-HOKAH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_2 55.0 2.0 2.0   0.0 0.0     0.0   3.0   35.0 27.0     0.0   0.0     17.0   10.0   62.0 55 2 2   0 0     0   3   35 27     0 0   17 10   62
1948155 MN Hubbard 29 school 2717940 306 Independent Districts and Schools LAPORTE PUBLIC SCHOOL DISTRICT 271794000825 10 LAPORTE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 14.0 0.0 0.0   3.0 0.0     0.0   2.0   8.0 11.0     0.0   0.0     12.0   2.0   19.0 14 0 0   3 0     0   2   8 11     0 0   12 2   19
1948165 MN Hubbard 29 school 2723370 308 Independent Districts and Schools NEVIS PUBLIC SCHOOL DISTRICT 272337001139 10 NEVIS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 40.0 1.0 3.0   0.0 0.0     0.0   2.0   28.0 18.0     0.0   0.0     22.0   10.0   46.0 40 1 3   0 0     0   2   28 18     0 0   22 10   46
1948177 MN Hubbard 29 school 2728080 309 Independent Districts and Schools PARK RAPIDS PUBLIC SCHOOL DISTRICT 272808001233 30 PARK RAPIDS AREA CENTURY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_2 104.0 0.0 10.0   2.0 0.0     0.0   10.0   60.0 66.0     4.0   0.0     67.0   16.0   126.0 104 0 10   2 0     0   10   60 66     4 0   67 16   126
1948194 MN Itasca 31 school 2709480 316 Independent Districts and Schools GREENWAY PUBLIC SCHOOL DISTRICT 270948000394 110 VANDYKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_2 55.0 2.0 3.0   11.0 0.0     0.0   0.0   39.0 32.0     1.0   3.0     42.0   17.0   71.0 55 2 3   11 0     0   0   39 32     1 3   42 17   71
1948204 MN Itasca 31 school 2710140 317 Independent Districts and Schools DEER RIVER PUBLIC SCHOOL DISTRICT 271014000434 4 KING ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 36.0 0.0 1.0   26.0 0.0     0.0   2.0   29.0 36.0     *   *         11.0   65.0 36 0 1   26 0     0   2   29 36             11   65
1948211 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000661 110 COHASSET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_2 31.0 2.0 0.0   1.0 0.0     0.0   1.0   20.0 15.0     0.0   0.0     14.0   9.0   35.0 31 2 0   1 0     0   1   20 15     0 0   14 9   35
1948219 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000882 115 BIGFORK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 19.0 0.0 0.0   1.0 0.0     0.0   4.0   10.0 14.0     0.0   0.0     12.0   2.0   24.0 19 0 0   1 0     0   4   10 14     0 0   12 2   24
1948227 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000662 120 FOREST LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_2 53.0 0.0 2.0   0.0 0.0     0.0   4.0   24.0 35.0     0.0   0.0     29.0   8.0   59.0 53 0 2   0 0     0   4   24 35     0 0   29 8   59
1948233 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000907 125 MURPHY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_2 60.0 0.0 2.0   0.0 0.0     0.0   3.0   23.0 42.0     0.0   0.0     33.0   5.0   65.0 60 0 2   0 0     0   3   23 42     0 0   33 5   65
1948247 MN Itasca 31 school 2723310 319 Independent Districts and Schools NASHWAUK-KEEWATIN SCHOOL DISTRICT 272331001136 20 Keewatin-Nashwauk Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 32.0 0.0 1.0   1.0 0.0     0.0   3.0   17.0 20.0     0.0   0.0     17.0   5.0   37.0 32 0 1   1 0     0   3   17 20     0 0   17 5   37
1948257 MN Jackson 32 school 2713930 330 Independent Districts and Schools HERON LAKE-OKABENA SCHOOL DISTRICT 271393000015 10 HERON LAKE-OKABENA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 12.0 0.0 2.0   0.0 0.0     0.0   0.0   9.0 5.0     1.0   0.0     6.0   4.0   14.0 12 0 2   0 0     0   0   9 5     1 0   6 4   14
1948266 MN Kanabec 33 school 2721480 332 Independent Districts and Schools MORA PUBLIC SCHOOL DISTRICT 272148001097 30 Mora Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 101.0 0.0 1.0   0.0 0.0     0.0   4.0   60.0 46.0     0.0   1.0     48.0   15.0   106.0 101 0 1   0 0     0   4   60 46     0 1   48 15   106
1948275 MN Kanabec 33 school 2723970 333 Independent Districts and Schools OGILVIE PUBLIC SCHOOL DISTRICT 272397001188 10 OGILVIE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 32.0 0.0 0.0   0.0 0.0     0.0   0.0   13.0 19.0     0.0   0.0     10.0   8.0   32.0 32 0 0   0 0     0   0   13 19     0 0   10 8   32
1948282 MN Kandiyohi 34 school 2723400 345 Independent Districts and Schools NEW LONDON-SPICER SCHOOL DISTRICT 272340001141 10 PRAIRIE WOODS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_2 111.0 1.0 9.0   1.0 0.0     0.0   0.0   73.0 49.0     3.0   0.0     37.0   21.0   122.0 111 1 9   1 0     0   0   73 49     3 0   37 21   122
1948316 MN Kittson 35 school 2717880 356 Independent Districts and Schools LANCASTER PUBLIC SCHOOL DISTRICT 271788000821 10 LANCASTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 13.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 5.0     0.0   0.0     3.0   5.0   13.0 13 0 0   0 0     0   0   8 5     0 0   3 5   13
1948325 MN Koochiching 36 school 2715000 361 Independent Districts and Schools INTERNATIONAL FALLS SCHOOL DISTRICT 271500000759 7 FALLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 63.0 0.0 2.0   11.0 0.0     0.0   2.0   41.0 37.0     3.0   2.0     40.0   14.0   78.0 63 0 2   11 0     0   2   41 37     3 2   40 14   78
1948332 MN Koochiching 36 school 2718270 362 Independent Districts and Schools LITTLEFORK-BIG FALLS SCHOOL DIST. 271827000847 20 LITTLEFORK-BIG FALLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 23.0 0.0 1.0   2.0 0.0     0.0   1.0   20.0 7.0     0.0   0.0     9.0   5.0   27.0 23 0 1   2 0     0   1   20 7     0 0   9 5   27
1948341 MN Koochiching 36 school 2732700 363 Independent Districts and Schools SOUTH KOOCHICHING SCHOOL DISTRICT 273270001946 80 NORTHOME ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 10.0 0.0 0.0   5.0 0.0     1.0   0.0   9.0 7.0     *   *         *   16.0 10 0 0   5 0     1   0   9 7                 16
1948350 MN Koochiching 36 school 2732700 363 Independent Districts and Schools SOUTH KOOCHICHING SCHOOL DISTRICT 273270001945 90 INDUS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 5.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 3.0     *   *         *   5.0 5 0 0   0 0     0   0   2 3                 5
1948368 MN Lake 38 school 2740740 381 Independent Districts and Schools LAKE SUPERIOR PUBLIC SCHOOL DIST. 274074001698 30 WILLIAM KELLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 21.0 0.0 0.0   0.0 0.0     0.0   0.0   11.0 10.0     0.0   *         3.0   21.0 21 0 0   0 0     0   0   11 10     0       3   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]);