Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 942

grade

  • grade_1 · 942
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
1945922 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_1 18.0 0.0 0.0   0.0 0.0     0.0   1.0   10.0 9.0     0.0   0.0     11.0   5.0   19.0 18 0 0   0 0     0   1   10 9     0 0   11 5   19
1945930 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_1 13.0 0.0 0.0   10.0 0.0     0.0   2.0   15.0 10.0     0.0   0.0     14.0   8.0   25.0 13 0 0   10 0     0   2   15 10     0 0   14 8   25
1946130 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810000022 513 RICE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 89.0 0.0 2.0   0.0 1.0     0.0   7.0   53.0 46.0     2.0   0.0     10.0   10.0   99.0 89 0 2   0 1     0   7   53 46     2 0   10 10   99
1946238 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023000445 10 ROSSMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_1 88.0 0.0 3.0   1.0 1.0     0.0   10.0   53.0 50.0     0.0   1.0     30.0   13.0   103.0 88 0 3   1 1     0   10   53 50     0 1   30 13   103
1946262 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_1 0.0 0.0 0.0   10.0 0.0     0.0   0.0   4.0 6.0     0.0   0.0         3.0   10.0 0 0 0   10 0     0   0   4 6     0 0     3   10
1946275 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000194 16 NORTHERN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2019   grade_1 83.0 0.0 0.0   11.0 0.0     0.0   4.0   54.0 44.0     0.0   1.0     44.0   14.0   98.0 83 0 0   11 0     0   4   54 44     0 1   44 14   98
1946291 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_1 18.0 0.0 1.0   4.0 0.0     0.0   6.0   15.0 14.0     0.0   1.0     24.0   9.0   29.0 18 0 1   4 0     0   6   15 14     0 1   24 9   29
1946297 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000192 60 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   grade_1 74.0 0.0 0.0   17.0 0.0     0.0   13.0   71.0 33.0     0.0   4.0     52.0   21.0   104.0 74 0 0   17 0     0   13   71 33     0 4   52 21   104
1946303 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_1 24.0 0.0 2.0   6.0 0.0     0.0   1.0   20.0 13.0     0.0   0.0     22.0   *   33.0 24 0 2   6 0     0   1   20 13     0 0   22     33
1946315 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_1 39.0 0.0 3.0   8.0 0.0     0.0   2.0   26.0 26.0     3.0   0.0     33.0   5.0   52.0 39 0 3   8 0     0   2   26 26     3 0   33 5   52
1946325 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_1 9.0 0.0 0.0   9.0 0.0     0.0   0.0   12.0 6.0     0.0   0.0     16.0   3.0   18.0 9 0 0   9 0     0   0   12 6     0 0   16 3   18
1946332 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_1 0.0 0.0 0.0   128.0 0.0     0.0   0.0   74.0 54.0     *   *     114.0   34.0   128.0 0 0 0   128 0     0   0   74 54           114 34   128
1946343 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_1 0.0 0.0 0.0   16.0 0.0     0.0   0.0   7.0 9.0     *   *     13.0   7.0   16.0 0 0 0   16 0     0   0   7 9           13 7   16
1946361 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_1 54.0 0.0 2.0   0.0 0.0     0.0   1.0   33.0 24.0     1.0   0.0     14.0   12.0   57.0 54 0 2   0 0     0   1   33 24     1 0   14 12   57
1946376 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_1 145.0 0.0 1.0   2.0 0.0     0.0   0.0   77.0 71.0     0.0   1.0     43.0   19.0   148.0 145 0 1   2 0     0   0   77 71     0 1   43 19   148
1946388 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_1 41.0 0.0 0.0   0.0 0.0     0.0   0.0   24.0 17.0     0.0   0.0         5.0   41.0 41 0 0   0 0     0   0   24 17     0 0     5   41
1946433 MN Nicollet 52 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002977 60 BRIDGES COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 33.0 0.0 1.0   0.0 4.0     0.0   2.0   20.0 20.0     0.0   0.0         2.0   40.0 33 0 1   0 4     0   2   20 20     0 0     2   40
1946469 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_1 5.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 4.0     *   *         *   6.0 5 0 1   0 0     0   0   2 4                 6
1946488 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_1 35.0 0.0 5.0   0.0 0.0     0.0   0.0   22.0 18.0     0.0   0.0         4.0   40.0 35 0 5   0 0     0   0   22 18     0 0     4   40
1946505 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_1 44.0 0.0 1.0   0.0 0.0     0.0   2.0   29.0 18.0     0.0   0.0         11.0   47.0 44 0 1   0 0     0   2   29 18     0 0     11   47
1946514 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_1 27.0 0.0 0.0   2.0 0.0     0.0   2.0   17.0 14.0     0.0   0.0         5.0   31.0 27 0 0   2 0     0   2   17 14     0 0     5   31
1946521 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942000380 101 CHURCHILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_1 54.0 0.0 0.0   4.0 0.0     0.0   7.0   27.0 38.0     0.0   1.0     23.0   *   65.0 54 0 0   4 0     0   7   27 38     0 1   23     65
1946534 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_1 13.0 0.0 0.0   1.0 0.0     0.0   0.0   9.0 5.0     0.0   0.0     8.0   4.0   14.0 13 0 0   1 0     0   0   9 5     0 0   8 4   14
1946543 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_1 48.0 0.0 0.0   0.0 0.0     0.0   2.0   22.0 28.0     0.0   0.0     18.0   6.0   50.0 48 0 0   0 0     0   2   22 28     0 0   18 6   50
1946552 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_1 79.0 0.0 0.0   0.0 0.0     0.0   4.0   47.0 36.0     0.0   1.0     4.0   5.0   83.0 79 0 0   0 0     0   4   47 36     0 1   4 5   83
1946561 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_1 30.0 0.0 1.0   0.0 0.0     0.0   1.0   20.0 12.0     0.0   0.0     11.0   2.0   32.0 30 0 1   0 0     0   1   20 12     0 0   11 2   32
1946584 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146003065 120 BAYVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 82.0 0.0 7.0   0.0 1.0     0.0   4.0   48.0 46.0     7.0   0.0     10.0   12.0   94.0 82 0 7   0 1     0   4   48 46     7 0   10 12   94
1946591 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_1 87.0 0.0 5.0   0.0 0.0     0.0   4.0   49.0 47.0     1.0   0.0     7.0   16.0   96.0 87 0 5   0 0     0   4   49 47     1 0   7 16   96
1946600 MN Carver 10 school 2741910 111 Independent Districts and Schools WATERTOWN-MAYER PUBLIC SCHOOL DIST. 274191003674 839 WATERTOWN-MAYER ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 99.0 0.0 0.0   1.0 0.0     0.0   2.0   50.0 52.0     1.0   0.0     19.0   14.0   102.0 99 0 0   1 0     0   2   50 52     1 0   19 14   102
1946666 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_1 39.0 0.0 2.0   19.0 0.0     0.0   10.0   43.0 27.0     0.0   2.0     45.0   12.0   70.0 39 0 2   19 0     0   10   43 27     0 2   45 12   70
1946675 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_1 3.0 0.0 4.0   75.0 0.0     0.0   13.0   52.0 43.0     0.0   1.0     82.0   25.0   95.0 3 0 4   75 0     0   13   52 43     0 1   82 25   95
1946682 MN Cass 11 school 2728350 116 Independent Districts and Schools PILLAGER PUBLIC SCHOOL DISTRICT 272835001253 10 PILLAGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 102.0 0.0 1.0   0.0 0.0     0.0   3.0   51.0 55.0     0.0   0.0     43.0   5.0   106.0 102 0 1   0 0     0   3   51 55     0 0   43 5   106
1946690 MN Cass 11 school 2730870 118 Independent Districts and Schools NORTHLAND COMMUNITY SCHOOLS 273087001307 10 REMER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 12.0 0.0 0.0   18.0 0.0     0.0   0.0   14.0 16.0     0.0   0.0     22.0   1.0   30.0 12 0 0   18 0     0   0   14 16     0 0   22 1   30
1946697 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001073 10 RAMSEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2019   grade_1 75.0 0.0 23.0   1.0 0.0     1.0   7.0   55.0 52.0     14.0   0.0     54.0   19.0   107.0 75 0 23   1 0     1   7   55 52     14 0   54 19   107
1946712 MN Chisago 13 school 2732550 139 Independent Districts and Schools RUSH CITY PUBLIC SCHOOL DISTRICT 273255001405 10 C.E. JACOBSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 52.0 0.0 1.0   2.0 0.0     0.0   0.0   17.0 38.0     0.0   0.0     15.0   6.0   55.0 52 0 1   2 0     0   0   17 38     0 0   15 6   55
1946720 MN Clay 14 school 2703660 146 Independent Districts and Schools Barnesville Public School District 270366000169 10 BARNESVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_1 63.0 0.0 0.0   0.0 0.0     0.0   1.0   35.0 29.0     0.0   0.0     11.0   7.0   64.0 63 0 0   0 0     0   1   35 29     0 0   11 7   64
1946728 MN Clay 14 school 2713560 150 Independent Districts and Schools HAWLEY PUBLIC SCHOOL DISTRICT 271356000698 10 HAWLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 72.0 0.0 2.0   0.0 0.0     0.0   1.0   41.0 34.0     *   *         *   75.0 72 0 2   0 0     0   1   41 34                 75
1946736 MN Clay 14 school 2713560 150 Independent Districts and Schools HAWLEY PUBLIC SCHOOL DISTRICT 271356002240 11 SPRING PRAIRIE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_1 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 3 0 0   0 0     0   0   2 1                 3
1946779 MN Cook 16 school 2713110 166 Independent Districts and Schools COOK COUNTY PUBLIC SCHOOLS 271311000658 60 SAWTOOTH MOUNTAIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_1 14.0 0.0 2.0   1.0 0.0     0.0   6.0   14.0 9.0     0.0   0.0     8.0   5.0   23.0 14 0 2   1 0     0   6   14 9     0 0   8 5   23
1946787 MN Cottonwood 17 school 2723010 173 Independent Districts and Schools MOUNTAIN LAKE PUBLIC SCHOOLS 272301001134 10 MOUNTAIN LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 23.0 0.0 14.0   0.0 4.0     0.0   7.0   22.0 26.0     12.0   0.0     24.0   8.0   48.0 23 0 14   0 4     0   7   22 26     12 0   24 8   48
1946800 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000248 4 BAXTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 100.0 0.0 1.0   2.0 1.0     0.0   7.0   52.0 59.0     2.0   0.0     43.0   19.0   111.0 100 0 1   2 1     0   7   52 59     2 0   43 19   111
1946812 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000254 9 HARRISON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 39.0 0.0 0.0   1.0 0.0     0.0   1.0   22.0 19.0     0.0   0.0     21.0   9.0   41.0 39 0 0   1 0     0   1   22 19     0 0   21 9   41
1946830 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000257 15 NISSWA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 50.0 0.0 1.0   0.0 0.0     0.0   1.0   30.0 22.0     0.0   0.0     20.0   9.0   52.0 50 0 1   0 0     0   1   30 22     0 0   20 9   52
1947045 MN Dakota 19 school 2730150 195 Independent Districts and Schools RANDOLPH PUBLIC SCHOOL DISTRICT 273015001286 10 RANDOLPH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 47.0 0.0 2.0   0.0 0.0     0.0   2.0   32.0 19.0     0.0   1.0         7.0   51.0 47 0 2   0 0     0   2   32 19     0 1     7   51
1947197 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227002202 816 MENDOTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 79.0 0.0 7.0   0.0 1.0     0.0   5.0   49.0 43.0     4.0   0.0     6.0   10.0   92.0 79 0 7   0 1     0   5   49 43     4 0   6 10   92
1947284 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000082 110 CARLOS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_1 23.0 0.0 1.0   0.0 0.0     0.0   1.0   11.0 14.0     0.0   0.0     6.0   6.0   25.0 23 0 1   0 0     0   1   11 14     0 0   6 6   25
1947291 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000084 120 GARFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 25.0 0.0 0.0   0.0 0.0     0.0   0.0   10.0 15.0     0.0   1.0     3.0   1.0   25.0 25 0 0   0 0     0   0   10 15     0 1   3 1   25
1947305 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000087 140 MILTONA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 23.0 0.0 0.0   0.0 0.0     0.0   1.0   17.0 7.0     0.0   0.0     4.0   5.0   24.0 23 0 0   0 0     0   1   17 7     0 0   4 5   24
1947319 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306002229 160 VOYAGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 70.0 0.0 7.0   0.0 2.0     0.0   1.0   40.0 40.0     4.0   1.0     32.0   17.0   80.0 70 0 7   0 2     0   1   40 40     4 1   32 17   80
1947338 MN Fillmore 23 school 2708220 227 Independent Districts and Schools CHATFIELD PUBLIC SCHOOLS 270822000349 2 CHATFIELD ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 60.0 0.0 1.0   1.0 0.0     0.0   1.0   30.0 33.0     0.0   0.0     7.0   7.0   63.0 60 0 1   1 0     0   1   30 33     0 0   7 7   63
1947347 MN Fillmore 23 school 2717910 229 Independent Districts and Schools LANESBORO PUBLIC SCHOOL DISTRICT 271791000823 10 LANESBORO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 27.0 0.0 0.0   0.0 0.0     0.0   0.0   16.0 11.0     0.0   0.0     8.0   2.0   27.0 27 0 0   0 0     0   0   16 11     0 0   8 2   27
1947356 MN Fillmore 23 school 2718540 238 Independent Districts and Schools MABEL-CANTON PUBLIC SCHOOL DIST. 271854000857 1 MABEL-CANTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 23.0 0.0 1.0   0.0 0.0     0.0   0.0   11.0 13.0     0.0   0.0     7.0   1.0   24.0 23 0 1   0 0     0   0   11 13     0 0   7 1   24
1947365 MN Fillmore 23 school 2728290 239 Independent Districts and Schools RUSHFORD-PETERSON PUBLIC SCHOOLS 272829001407 1 RUSHFORD-PETERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_1 33.0 0.0 3.0   0.0 0.0     0.0   2.0   22.0 16.0     3.0   0.0     16.0   2.0   38.0 33 0 3   0 0     0   2   22 16     3 0   16 2   38
1947405 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 35.0 0.0 0.0   0.0 0.0     0.0   0.0   19.0 16.0     0.0   0.0     10.0   6.0   35.0 35 0 0   0 0     0   0   19 16     0 0   10 6   35
1947414 MN Goodhue 25 school 2707500 252 Independent Districts and Schools CANNON FALLS PUBLIC SCHOOL DISTRICT 270750000323 1 CANNON FALLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_1 61.0 0.0 4.0   0.0 0.0     1.0   2.0   31.0 37.0     0.0   0.0     18.0   6.0   68.0 61 0 4   0 0     1   2   31 37     0 0   18 6   68
1947421 MN Goodhue 25 school 2712900 253 Independent Districts and Schools GOODHUE PUBLIC SCHOOL DISTRICT 271290000647 1 GOODHUE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 37.0 0.0 7.0   0.0 0.0     0.0   1.0   19.0 26.0     6.0   0.0     9.0   0.0   45.0 37 0 7   0 0     0   1   19 26     6 0   9 0   45
1947446 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_1 23.0 0.0 2.0   0.0 0.0     0.0   0.0   13.0 12.0     0.0   2.0     10.0   2.0   25.0 23 0 2   0 0     0   0   13 12     0 2   10 2   25
1947455 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_1 9.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 6.0     0.0   0.0     4.0   1.0   10.0 9 0 1   0 0     0   0   4 6     0 0   4 1   10
1947683 MN Hennepin 27 school 2711250 273 Independent Districts and Schools EDINA PUBLIC SCHOOL DISTRICT 271125000709 533 NORMANDALE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 93.0 0.0 2.0   0.0 7.0     1.0   5.0   50.0 58.0     0.0   0.0     2.0   8.0   108.0 93 0 2   0 7     1   5   50 58     0 0   2 8   108
1947718 MN Hennepin 27 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167000548 605 MINNEWASHTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 119.0 0.0 7.0   0.0 1.0     0.0   5.0   75.0 57.0     3.0   0.0     1.0   *   132.0 119 0 7   0 1     0   5   75 57     3 0   1     132
1947738 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_1 89.0 0.0 4.0   0.0 0.0     0.0   3.0   53.0 43.0     0.0   0.0     7.0   11.0   96.0 89 0 4   0 0     0   3   53 43     0 0   7 11   96
1948129 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_1 27.0 0.0 0.0   0.0 0.0     0.0   0.0   16.0 11.0     0.0   0.0     12.0   4.0   27.0 27 0 0   0 0     0   0   16 11     0 0   12 4   27
1948154 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_1 22.0 0.0 0.0   8.0 0.0     0.0   0.0   18.0 12.0     0.0   0.0     19.0   5.0   30.0 22 0 0   8 0     0   0   18 12     0 0   19 5   30
1948164 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_1 39.0 0.0 1.0   2.0 0.0     0.0   0.0   26.0 16.0     0.0   0.0     22.0   9.0   42.0 39 0 1   2 0     0   0   26 16     0 0   22 9   42
1948176 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_1 105.0 0.0 6.0   1.0 0.0     0.0   8.0   50.0 70.0     *   0.0         21.0   120.0 105 0 6   1 0     0   8   50 70       0     21   120
1948183 MN Isanti 30 school 2706060 314 Independent Districts and Schools BRAHAM PUBLIC SCHOOL DISTRICT 270606000245 2 BRAHAM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 45.0 0.0 3.0   0.0 1.0     1.0   2.0   30.0 22.0     0.0   0.0     19.0   10.0   52.0 45 0 3   0 1     1   2   30 22     0 0   19 10   52
1948203 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_1 44.0 0.0 1.0   22.0 2.0     0.0   8.0   35.0 42.0     1.0   5.0     49.0   19.0   77.0 44 0 1   22 2     0   8   35 42     1 5   49 19   77
1948210 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_1 54.0 0.0 1.0   4.0 0.0     0.0   3.0   41.0 21.0     0.0   0.0     19.0   8.0   62.0 54 0 1   4 0     0   3   41 21     0 0   19 8   62
1948218 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_1 23.0 0.0 0.0   0.0 0.0     0.0   3.0   12.0 14.0     0.0   0.0     16.0   3.0   26.0 23 0 0   0 0     0   3   12 14     0 0   16 3   26
1948226 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_1 56.0 0.0 2.0   0.0 0.0     0.0   2.0   33.0 27.0     0.0   0.0     26.0   7.0   60.0 56 0 2   0 0     0   2   33 27     0 0   26 7   60
1948232 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_1 53.0 0.0 4.0   3.0 0.0     0.0   7.0   38.0 29.0     0.0   0.0     29.0   9.0   67.0 53 0 4   3 0     0   7   38 29     0 0   29 9   67
1948238 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000915 135 SOUTHWEST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 56.0 0.0 3.0   2.0 0.0     0.0   5.0   31.0 35.0     0.0   0.0     20.0   10.0   66.0 56 0 3   2 0     0   5   31 35     0 0   20 10   66
1948246 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_1 37.0 0.0 1.0   1.0 0.0     0.0   5.0   25.0 19.0     0.0   1.0     24.0   6.0   44.0 37 0 1   1 0     0   5   25 19     0 1   24 6   44
1948256 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_1 13.0 0.0 1.0   0.0 0.0     0.0   0.0   9.0 5.0     1.0   0.0     7.0   4.0   14.0 13 0 1   0 0     0   0   9 5     1 0   7 4   14
1948274 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_1 37.0 0.0 0.0   1.0 0.0     0.0   0.0   14.0 24.0     0.0   2.0     16.0   9.0   38.0 37 0 0   1 0     0   0   14 24     0 2   16 9   38
1948281 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_1 97.0 0.0 7.0   0.0 0.0     0.0   0.0   48.0 56.0     4.0   1.0     26.0   13.0   104.0 97 0 7   0 0     0   0   48 56     4 1   26 13   104
1948315 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_1 12.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 5.0     0.0   0.0     7.0   1.0   12.0 12 0 0   0 0     0   0   7 5     0 0   7 1   12
1948324 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_1 52.0 0.0 0.0   9.0 0.0     0.0   0.0   27.0 34.0     1.0   0.0     32.0   8.0   61.0 52 0 0   9 0     0   0   27 34     1 0   32 8   61
1948331 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_1 21.0 0.0 0.0   1.0 0.0     0.0   1.0   7.0 16.0     0.0   0.0     9.0   5.0   23.0 21 0 0   1 0     0   1   7 16     0 0   9 5   23
1948340 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_1 10.0 0.0 0.0   2.0 0.0     0.0   1.0   6.0 7.0     *   *         *   13.0 10 0 0   2 0     0   1   6 7                 13
1948349 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_1 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
1948358 MN Lac qui Parle 37 school 2710090 378 Independent Districts and Schools DAWSON-BOYD PUBLIC SCHOOL DISTRICT 271009000429 10 STEVENS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 29.0 0.0 1.0   0.0 0.0     0.0   1.0   15.0 16.0     0.0   0.0         10.0   31.0 29 0 1   0 0     0   1   15 16     0 0     10   31
1948367 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_1 25.0 0.0 1.0   0.0 0.0     0.0   0.0   14.0 12.0     0.0   0.0     7.0   4.0   26.0 25 0 1   0 0     0   0   14 12     0 0   7 4   26
1948376 MN Lake 38 school 2740740 381 Independent Districts and Schools LAKE SUPERIOR PUBLIC SCHOOL DIST. 274074001699 40 MINNEHAHA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_1 52.0 0.0 2.0   0.0 0.0     0.0   4.0   27.0 31.0     0.0   2.0     17.0   5.0   58.0 52 0 2   0 0     0   4   27 31     0 2   17 5   58
1948385 MN Lake of the Woods 39 school 2717570 390 Independent Districts and Schools LAKE OF THE WOODS SCHOOL DISTRICT 271757000808 224 LAKE OF THE WOODS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 24.0 0.0 2.0   0.0 0.0     0.0   0.0   13.0 13.0     0.0   0.0     13.0   2.0   26.0 24 0 2   0 0     0   0   13 13     0 0   13 2   26
1948394 MN Lesueur 40 school 2709330 391 Independent Districts and Schools CLEVELAND PUBLIC SCHOOL DISTRICT 270933000374 10 CLEVELAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 32.0 0.0 1.0   0.0 0.0     0.0   1.0   17.0 17.0     0.0   0.0     8.0   5.0   34.0 32 0 1   0 0     0   1   17 17     0 0   8 5   34
1948403 MN Lincoln 41 school 2713680 402 Independent Districts and Schools HENDRICKS PUBLIC SCHOOL DISTRICT 271368000707 10 HENDRICKS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 11.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 5.0     0.0   0.0     6.0   3.0   11.0 11 0 0   0 0     0   0   6 5     0 0   6 3   11
1948414 MN Lincoln 41 school 2715540 403 Independent Districts and Schools IVANHOE PUBLIC SCHOOL DISTRICT 271554004539 10 Lincoln Elementary - Ivanhoe Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 8.0 0.0 1.0   0.0 0.0     0.0   0.0   5.0 4.0     *   *         *   9.0 8 0 1   0 0     0   0   5 4                 9
1948423 MN Lincoln 41 school 2717460 404 Independent Districts and Schools LAKE BENTON PUBLIC SCHOOL DISTRICT 271746000801 10 LAKE BENTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 17.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 9.0     0.0   0.0     6.0   3.0   17.0 17 0 0   0 0     0   0   8 9     0 0   6 3   17
1948443 MN Lyon 42 school 2721270 414 Independent Districts and Schools MINNEOTA PUBLIC SCHOOL DISTRICT 272127001067 1 MINNEOTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 40.0 0.0 0.0   0.0 0.0     0.0   1.0   20.0 21.0     0.0   0.0     12.0   6.0   41.0 40 0 0   0 0     0   1   20 21     0 0   12 6   41
1948452 MN Lyon 42 school 2718390 415 Independent Districts and Schools LYND PUBLIC SCHOOL DISTRICT 271839000856 10 LYND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_1 21.0 0.0 5.0   0.0 0.0     0.0   0.0   12.0 14.0     4.0   0.0     12.0   2.0   26.0 21 0 5   0 0     0   0   12 14     4 0   12 2   26
1948464 MN Mcleod 43 school 2714970 423 Independent Districts and Schools HUTCHINSON PUBLIC SCHOOL DISTRICT 271497002198 60 HUTCHINSON WEST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 01 2019   grade_1 157.0 0.0 19.0   0.0 1.0     1.0   7.0   80.0 105.0     7.0   1.0     56.0   27.0   185.0 157 0 19   0 1     1   7   80 105     7 1   56 27   185
1948468 MN Mcleod 43 school 2702640 424 Independent Districts and Schools LESTER PRAIRIE PUBLIC SCHOOL DIST. 270264000048 10 LESTER PRAIRIE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 21.0 0.0 3.0   0.0 1.0     0.0   0.0   14.0 11.0     3.0   0.0     7.0   5.0   25.0 21 0 3   0 1     0   0   14 11     3 0   7 5   25
1948478 MN Mahnomen 44 school 2718660 432 Independent Districts and Schools MAHNOMEN PUBLIC SCHOOL DISTRICT 271866000865 10 MAHNOMEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 6.0 0.0 2.0   42.0 0.0     0.0   0.0   29.0 21.0     0.0   0.0         8.0   50.0 6 0 2   42 0     0   0   29 21     0 0     8   50
1948491 MN Becker 3 school 2742120 435 Independent Districts and Schools WAUBUN-OGEMA-WHITE EARTH PUBLIC SCH 274212001754 20 OGEMA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 10.0 0.0 0.0   45.0 0.0     0.0   5.0   29.0 31.0     0.0   *     45.0   6.0   60.0 10 0 0   45 0     0   5   29 31     0     45 6   60
1948503 MN Marshall 45 school 2723550 441 Independent Districts and Schools MARSHALL COUNTY CENTRAL SCHOOLS 272355001159 30 VIKING ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2019   grade_1 28.0 0.0 0.0   0.0 0.0     0.0   1.0   11.0 18.0     0.0   0.0     10.0   3.0   29.0 28 0 0   0 0     0   1   11 18     0 0   10 3   29
1948508 MN Marshall 45 school 2718920 447 Independent Districts and Schools GRYGLA PUBLIC SCHOOL DISTRICT 271892000896 1 GRYGLA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 10.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 6.0     0.0   0.0     8.0   2.0   10.0 10 0 0   0 0     0   0   4 6     0 0   8 2   10
1948518 MN Martin 46 school 2740680 458 Independent Districts and Schools TRUMAN PUBLIC SCHOOL DISTRICT 274068001692 10 TRUMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 17.0 0.0 1.0   0.0 1.0     0.0   0.0   12.0 7.0     0.0   0.0     13.0   2.0   19.0 17 0 1   0 1     0   0   12 7     0 0   13 2   19
1948551 MN Meeker 47 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006000427 3 DASSEL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 71.0 0.0 1.0   0.0 0.0     0.0   0.0   31.0 41.0     0.0   0.0     16.0   12.0   72.0 71 0 1   0 0     0   0   31 41     0 0   16 12   72
1948559 MN Mille Lacs 48 school 2715510 473 Independent Districts and Schools ISLE PUBLIC SCHOOL DISTRICT 271551000769 10 ISLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 19.0 0.0 1.0   4.0 0.0     0.0   1.0   17.0 8.0     1.0   0.0     17.0   6.0   25.0 19 0 1   4 0     0   1   17 8     1 0   17 6   25

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