Data source: Big Local News · About: Big Local

13,903 rows where state = "MN" and year = 2019 sorted by county_state_id

View and edit SQL

year

  • 2019 · 13,903
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
1944368 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000057 1 AITKIN SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 80.0 1.0 1.0   2.0 0.0     0.0   3.0   36.0 51.0     0.0   0.0     40.0   10.0   87.0 80 1 1   2 0     0   3   36 51     0 0   40 10   87
1944369 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000057 1 AITKIN SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_8 91.0 1.0 1.0   0.0 0.0     0.0   5.0   58.0 40.0     1.0   0.0     42.0   19.0   98.0 91 1 1   0 0     0   5   58 40     1 0   42 19   98
1944370 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000057 1 AITKIN SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_9 102.0 0.0 1.0   0.0 0.0     0.0   4.0   54.0 53.0     0.0   0.0     39.0   18.0   107.0 102 0 1   0 0     0   4   54 53     0 0   39 18   107
1944371 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000057 1 AITKIN SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_10 104.0 2.0 1.0   0.0 0.0     0.0   3.0   53.0 57.0     *   *         *   110.0 104 2 1   0 0     0   3   53 57                 110
1944372 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000057 1 AITKIN SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_11 64.0 0.0 2.0   0.0 0.0     0.0   3.0   34.0 35.0     *   *         *   69.0 64 0 2   0 0     0   3   34 35                 69
1944373 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000057 1 AITKIN SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_12 79.0 0.0 2.0   1.0 0.0     0.0   4.0   44.0 42.0     *   *         *   86.0 79 0 2   1 0     0   4   44 42                 86
1944374 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000057 1 AITKIN SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2019   pk_12_total 520.0 4.0 8.0   3.0 0.0     0.0   22.0   279.0 278.0     *   *         *   557.0 520 4 8   3 0     0   22   279 278                 557
1944375 MN Aitkin 1 school 2719170 4 Independent Districts and Schools MCGREGOR PUBLIC SCHOOL DISTRICT 271917000904 40 MCGREGOR SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 22.0 0.0 1.0   6.0 0.0     0.0   0.0   14.0 15.0     0.0   0.0     14.0   9.0   29.0 22 0 1   6 0     0   0   14 15     0 0   14 9   29
1944376 MN Aitkin 1 school 2719170 4 Independent Districts and Schools MCGREGOR PUBLIC SCHOOL DISTRICT 271917000904 40 MCGREGOR SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_8 27.0 0.0 0.0   8.0 1.0     0.0   1.0   21.0 16.0     0.0   0.0     17.0   9.0   37.0 27 0 0   8 1     0   1   21 16     0 0   17 9   37
1944377 MN Aitkin 1 school 2719170 4 Independent Districts and Schools MCGREGOR PUBLIC SCHOOL DISTRICT 271917000904 40 MCGREGOR SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_9 28.0 0.0 0.0   9.0 0.0     0.0   0.0   16.0 21.0     0.0   0.0     15.0   10.0   37.0 28 0 0   9 0     0   0   16 21     0 0   15 10   37
1944378 MN Aitkin 1 school 2719170 4 Independent Districts and Schools MCGREGOR PUBLIC SCHOOL DISTRICT 271917000904 40 MCGREGOR SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_10 31.0 0.0 1.0   7.0 0.0     0.0   0.0   23.0 16.0     0.0   0.0     11.0   9.0   39.0 31 0 1   7 0     0   0   23 16     0 0   11 9   39
1944379 MN Aitkin 1 school 2719170 4 Independent Districts and Schools MCGREGOR PUBLIC SCHOOL DISTRICT 271917000904 40 MCGREGOR SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_11 24.0 0.0 1.0   6.0 0.0     0.0   0.0   17.0 14.0     0.0   0.0     11.0   4.0   31.0 24 0 1   6 0     0   0   17 14     0 0   11 4   31
1944380 MN Aitkin 1 school 2719170 4 Independent Districts and Schools MCGREGOR PUBLIC SCHOOL DISTRICT 271917000904 40 MCGREGOR SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_12 17.0 0.0 1.0   4.0 1.0     0.0   0.0   13.0 10.0     0.0   0.0     7.0   4.0   23.0 17 0 1   4 1     0   0   13 10     0 0   7 4   23
1944381 MN Aitkin 1 school 2719170 4 Independent Districts and Schools MCGREGOR PUBLIC SCHOOL DISTRICT 271917000904 40 MCGREGOR SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   pk_12_total 149.0 0.0 4.0   40.0 2.0     0.0   1.0   104.0 92.0     0.0   0.0     75.0   45.0   196.0 149 0 4   40 2     0   1   104 92     0 0   75 45   196
1945910 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000059 2 RIPPLESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 17.0 0.0 0.0   0.0 0.0     0.0   0.0   12.0 5.0     0.0   0.0     9.0   *   17.0 17 0 0   0 0     0   0   12 5     0 0   9     17
1945911 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000059 2 RIPPLESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   kindergarten 60.0 3.0 1.0   0.0 0.0     0.0   2.0   26.0 40.0     0.0   0.0     39.0   15.0   66.0 60 3 1   0 0     0   2   26 40     0 0   39 15   66
1945912 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000059 2 RIPPLESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 86.0 2.0 3.0   1.0 1.0     0.0   4.0   55.0 42.0     0.0   0.0     36.0   17.0   97.0 86 2 3   1 1     0   4   55 42     0 0   36 17   97
1945913 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000059 2 RIPPLESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_2 74.0 1.0 1.0   2.0 1.0     0.0   2.0   46.0 35.0     0.0   0.0     39.0   19.0   81.0 74 1 1   2 1     0   2   46 35     0 0   39 19   81
1945914 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000059 2 RIPPLESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_3 83.0 1.0 1.0   0.0 1.0     0.0   2.0   54.0 34.0     0.0   0.0     46.0   11.0   88.0 83 1 1   0 1     0   2   54 34     0 0   46 11   88
1945915 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000059 2 RIPPLESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_4 77.0 1.0 1.0   1.0 0.0     0.0   2.0   50.0 32.0     0.0   0.0     43.0   18.0   82.0 77 1 1   1 0     0   2   50 32     0 0   43 18   82
1945916 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000059 2 RIPPLESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 92.0 1.0 1.0   0.0 2.0     0.0   1.0   48.0 49.0     1.0   0.0     43.0   16.0   97.0 92 1 1   0 2     0   1   48 49     1 0   43 16   97
1945917 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000059 2 RIPPLESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 88.0 2.0 2.0   0.0 0.0     0.0   4.0   51.0 45.0     0.0   0.0     46.0   13.0   96.0 88 2 2   0 0     0   4   51 45     0 0   46 13   96
1945918 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000059 2 RIPPLESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pk_12_total 577.0 11.0 10.0   4.0 5.0     0.0   17.0   342.0 282.0     1.0   0.0     301.0   126.0   624.0 577 11 10   4 5     0   17   342 282     1 0   301 126   624
1945919 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   early_childhood_special_ed 11.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 4.0     *   *     9.0   *   11.0 11 0 0   0 0     0   0   7 4           9     11
1945920 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   pre_kindergarten 5.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 1.0     *   *         *   5.0 5 0 0   0 0     0   0   4 1                 5
1945921 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   kindergarten 13.0 0.0 1.0   0.0 0.0     0.0   1.0   5.0 10.0     0.0   0.0         *   15.0 13 0 1   0 0     0   1   5 10     0 0         15
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
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
1945924 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_3 19.0 0.0 1.0   0.0 0.0     0.0   1.0   7.0 14.0     0.0   0.0     14.0   6.0   21.0 19 0 1   0 0     0   1   7 14     0 0   14 6   21
1945925 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_4 13.0 0.0 1.0   0.0 0.0     0.0   1.0   8.0 7.0     0.0   0.0     10.0   8.0   15.0 13 0 1   0 0     0   1   8 7     0 0   10 8   15
1945926 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   pk_12_total 95.0 0.0 4.0   0.0 0.0     0.0   4.0   50.0 53.0     0.0   0.0     72.0   39.0   103.0 95 0 4   0 0     0   4   50 53     0 0   72 39   103
1945927 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   early_childhood_special_ed 12.0 0.0 0.0   2.0 0.0     0.0   0.0   13.0 1.0     0.0   0.0     4.0   *   14.0 12 0 0   2 0     0   0   13 1     0 0   4     14
1945928 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   pre_kindergarten 20.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 12.0     0.0   0.0     3.0   0.0   20.0 20 0 0   0 0     0   0   8 12     0 0   3 0   20
1945929 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   kindergarten 28.0 0.0 0.0   8.0 0.0     0.0   1.0   23.0 14.0     0.0   0.0     14.0   16.0   37.0 28 0 0   8 0     0   1   23 14     0 0   14 16   37
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
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
1945932 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_3 30.0 0.0 0.0   13.0 0.0     0.0   0.0   15.0 28.0     0.0   0.0     23.0   11.0   43.0 30 0 0   13 0     0   0   15 28     0 0   23 11   43
1945933 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_4 28.0 0.0 0.0   9.0 0.0     0.0   2.0   19.0 20.0     0.0   0.0     17.0   10.0   39.0 28 0 0   9 0     0   2   19 20     0 0   17 10   39
1945934 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_5 24.0 1.0 0.0   10.0 0.0     0.0   1.0   22.0 14.0     0.0   0.0     18.0   11.0   36.0 24 1 0   10 0     0   1   22 14     0 0   18 11   36
1945935 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_6 35.0 0.0 0.0   9.0 0.0     0.0   0.0   21.0 23.0     0.0   0.0     22.0   12.0   44.0 35 0 0   9 0     0   0   21 23     0 0   22 12   44
1945936 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   pk_12_total 208.0 1.0 0.0   69.0 0.0     0.0   6.0   150.0 134.0     0.0   0.0     123.0   87.0   284.0 208 1 0   69 0     0   6   150 134     0 0   123 87   284
1953098 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276002789 6 AITKIN ALTERNATIVE LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 07 12 2019   grade_10 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 1 0 0   0 0     0   0   0 1                 1
1953099 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276002789 6 AITKIN ALTERNATIVE LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 07 12 2019   grade_11 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
1953100 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276002789 6 AITKIN ALTERNATIVE LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 07 12 2019   grade_12 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
1953101 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276002789 6 AITKIN ALTERNATIVE LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 07 12 2019   pk_12_total 5.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 2.0     *   *         *   5.0 5 0 0   0 0     0   0   3 2                 5
1953224 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_5 19.0 0.0 0.0   0.0 0.0     0.0   2.0   9.0 12.0     0.0   0.0     17.0   6.0   21.0 19 0 0   0 0     0   2   9 12     0 0   17 6   21
1953225 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_6 16.0 0.0 1.0   0.0 0.0     0.0   1.0   10.0 8.0     0.0   0.0     9.0   3.0   18.0 16 0 1   0 0     0   1   10 8     0 0   9 3   18
1953226 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 12.0 0.0 0.0   1.0 0.0     0.0   1.0   9.0 5.0     0.0   0.0     9.0   1.0   14.0 12 0 0   1 0     0   1   9 5     0 0   9 1   14
1953227 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 20.0 0.0 1.0   1.0 0.0     0.0   3.0   12.0 13.0     0.0   0.0     15.0   3.0   25.0 20 0 1   1 0     0   3   12 13     0 0   15 3   25
1953228 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   pk_12_total 67.0 0.0 2.0   2.0 0.0     0.0   7.0   40.0 38.0     0.0   0.0     50.0   13.0   78.0 67 0 2   2 0     0   7   40 38     0 0   50 13   78
1954210 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401000724 3 HILL CITY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_9 29.0 0.0 0.0   0.0 0.0     0.0   2.0   16.0 15.0     0.0   0.0     18.0   6.0   31.0 29 0 0   0 0     0   2   16 15     0 0   18 6   31
1954211 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401000724 3 HILL CITY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_10 13.0 0.0 0.0   2.0 0.0     0.0   1.0   10.0 6.0     0.0   0.0     12.0   6.0   16.0 13 0 0   2 0     0   1   10 6     0 0   12 6   16
1954212 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401000724 3 HILL CITY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_11 16.0 0.0 1.0   3.0 0.0     0.0   0.0   10.0 10.0     0.0   0.0     7.0   4.0   20.0 16 0 1   3 0     0   0   10 10     0 0   7 4   20
1954213 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401000724 3 HILL CITY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_12 17.0 0.0 0.0   2.0 0.0     0.0   0.0   7.0 12.0     0.0   0.0     9.0   4.0   19.0 17 0 0   2 0     0   0   7 12     0 0   9 4   19
1954214 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401000724 3 HILL CITY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 75.0 0.0 1.0   7.0 0.0     0.0   3.0   43.0 43.0     0.0   0.0     46.0   20.0   86.0 75 0 1   7 0     0   3   43 43     0 0   46 20   86
1958259 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2019   grade_1 0.0 0.0 0.0   3.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 0 0 0   3 0     0   0   1 2                 3
1958260 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2019   grade_2 0.0 0.0 0.0   3.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 0 0 0   3 0     0   0   1 2                 3
1958261 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2019   grade_3 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 0   1 0     0   0   1 0                 1
1958262 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2019   grade_4 0.0 0.0 0.0   3.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 0 0 0   3 0     0   0   2 1                 3
1958263 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2019   grade_5 0.0 0.0 0.0   2.0 0.0     0.0   0.0   0.0 2.0     *   *         *   2.0 0 0 0   2 0     0   0   0 2                 2
1958264 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2019   grade_6 0.0 0.0 0.0   2.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 0 0   2 0     0   0   1 1                 2
1958265 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2019   grade_7 0.0 0.0 0.0   2.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 0 0   2 0     0   0   1 1                 2
1958266 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2019   grade_8 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 0   1 0     0   0   1 0                 1
1958267 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2019   grade_9 0.0 0.0 0.0   1.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 0 0   1 0     0   0   0 1                 1
1958268 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2019   grade_10 0.0 0.0 0.0   2.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 0 0   2 0     0   0   1 1                 2
1958269 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2019   grade_12 0.0 0.0 0.0   1.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 0 0   1 0     0   0   0 1                 1
1958270 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2019   pk_12_total 0.0 0.0 0.0   21.0 0.0     0.0   0.0   9.0 12.0     0.0   0.0     10.0   6.0   21.0 0 0 0   21 0     0   0   9 12     0 0   10 6   21
1944382 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333004658 788 Secondary Lighthouse Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 5.0 0.0 1.0   0.0 1.0     0.0   4.0   8.0 3.0     0.0   0.0     1.0   0.0   11.0 5 0 1   0 1     0   4   8 3     0 0   1 0   11
1944383 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333004658 788 Secondary Lighthouse Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_8 11.0 0.0 0.0   0.0 0.0     0.0   0.0   5.0 6.0     0.0   0.0     0.0   0.0   11.0 11 0 0   0 0     0   0   5 6     0 0   0 0   11
1944384 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333004658 788 Secondary Lighthouse Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_9 6.0 0.0 0.0   0.0 0.0     0.0   1.0   4.0 3.0     *   *         *   7.0 6 0 0   0 0     0   1   4 3                 7
1944385 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333004658 788 Secondary Lighthouse Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_10 4.0 0.0 0.0   0.0 0.0     0.0   2.0   4.0 2.0     *   *         *   6.0 4 0 0   0 0     0   2   4 2                 6
1944386 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333004658 788 Secondary Lighthouse Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_11 6.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 3.0     *   *         *   6.0 6 0 0   0 0     0   0   3 3                 6
1944387 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333004658 788 Secondary Lighthouse Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_12 4.0 0.0 0.0   0.0 0.0     0.0   1.0   3.0 2.0     *   *         *   5.0 4 0 0   0 0     0   1   3 2                 5
1944388 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333004658 788 Secondary Lighthouse Secondary School (Grades 7-12) Regular School No High 07 12 2019   pk_12_total 36.0 0.0 1.0   0.0 1.0     0.0   8.0   27.0 19.0     0.0   0.0     7.0   3.0   46.0 36 0 1   0 1     0   8   27 19     0 0   7 3   46
1945692 MN Anoka 2 school 2700093 4008 Charter Schools PACT CHARTER SCHOOL 270009303030 30 PACT CHARTER SECONDARY Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_7 46.0 3.0 3.0   0.0 0.0     0.0   2.0   20.0 34.0     5.0   0.0     10.0   8.0   54.0 46 3 3   0 0     0   2   20 34     5 0   10 8   54
1945693 MN Anoka 2 school 2700093 4008 Charter Schools PACT CHARTER SCHOOL 270009303030 30 PACT CHARTER SECONDARY Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_8 43.0 1.0 4.0   0.0 1.0     0.0   4.0   30.0 23.0     6.0   0.0     8.0   13.0   53.0 43 1 4   0 1     0   4   30 23     6 0   8 13   53
1945694 MN Anoka 2 school 2700093 4008 Charter Schools PACT CHARTER SCHOOL 270009303030 30 PACT CHARTER SECONDARY Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_9 44.0 0.0 2.0   0.0 1.0     0.0   4.0   29.0 22.0     2.0   0.0     6.0   4.0   51.0 44 0 2   0 1     0   4   29 22     2 0   6 4   51
1945695 MN Anoka 2 school 2700093 4008 Charter Schools PACT CHARTER SCHOOL 270009303030 30 PACT CHARTER SECONDARY Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_10 42.0 1.0 5.0   0.0 2.0     0.0   3.0   29.0 24.0     2.0   0.0     3.0   5.0   53.0 42 1 5   0 2     0   3   29 24     2 0   3 5   53
1945696 MN Anoka 2 school 2700093 4008 Charter Schools PACT CHARTER SCHOOL 270009303030 30 PACT CHARTER SECONDARY Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_11 38.0 2.0 2.0   0.0 1.0     0.0   3.0   18.0 28.0     0.0   0.0     7.0   10.0   46.0 38 2 2   0 1     0   3   18 28     0 0   7 10   46
1945697 MN Anoka 2 school 2700093 4008 Charter Schools PACT CHARTER SCHOOL 270009303030 30 PACT CHARTER SECONDARY Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_12 48.0 2.0 2.0   0.0 0.0     0.0   4.0   26.0 30.0     0.0   0.0     8.0   10.0   56.0 48 2 2   0 0     0   4   26 30     0 0   8 10   56
1945698 MN Anoka 2 school 2700093 4008 Charter Schools PACT CHARTER SCHOOL 270009303030 30 PACT CHARTER SECONDARY Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   pk_12_total 261.0 9.0 18.0   0.0 5.0     0.0   20.0   152.0 161.0     15.0   0.0     42.0   50.0   313.0 261 9 18   0 5     0   20   152 161     15 0   42 50   313
1945719 MN Anoka 2 school 2700173 4049 Charter Schools NORTHWEST PASSAGE HIGH SCHOOL 270017303041 10 NORTHWEST PASSAGE HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 09 12 2019   grade_9 15.0 0.0 2.0   0.0 0.0     0.0   0.0   11.0 6.0     0.0   0.0     6.0   8.0   17.0 15 0 2   0 0     0   0   11 6     0 0   6 8   17
1945720 MN Anoka 2 school 2700173 4049 Charter Schools NORTHWEST PASSAGE HIGH SCHOOL 270017303041 10 NORTHWEST PASSAGE HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 09 12 2019   grade_10 22.0 2.0 1.0   0.0 0.0     0.0   7.0   20.0 12.0     0.0   1.0     9.0   16.0   32.0 22 2 1   0 0     0   7   20 12     0 1   9 16   32
1945721 MN Anoka 2 school 2700173 4049 Charter Schools NORTHWEST PASSAGE HIGH SCHOOL 270017303041 10 NORTHWEST PASSAGE HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 09 12 2019   grade_11 27.0 2.0 1.0   0.0 0.0     0.0   4.0   16.0 18.0     0.0   2.0     9.0   15.0   34.0 27 2 1   0 0     0   4   16 18     0 2   9 15   34
1945722 MN Anoka 2 school 2700173 4049 Charter Schools NORTHWEST PASSAGE HIGH SCHOOL 270017303041 10 NORTHWEST PASSAGE HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 09 12 2019   grade_12 53.0 6.0 4.0   0.0 0.0     0.0   7.0   37.0 33.0     0.0   9.0     32.0   26.0   70.0 53 6 4   0 0     0   7   37 33     0 9   32 26   70
1945723 MN Anoka 2 school 2700173 4049 Charter Schools NORTHWEST PASSAGE HIGH SCHOOL 270017303041 10 NORTHWEST PASSAGE HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 09 12 2019   pk_12_total 117.0 10.0 8.0   0.0 0.0     0.0   18.0   84.0 69.0     0.0   12.0     56.0   65.0   153.0 117 10 8   0 0     0   18   84 69     0 12   56 65   153
1945937 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 19.0 4.0 1.0   0.0 8.0     0.0   2.0   12.0 22.0     0.0   0.0     13.0   0.0   34.0 19 4 1   0 8     0   2   12 22     0 0   13 0   34
1945938 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   kindergarten 43.0 19.0 5.0   0.0 18.0     0.0   11.0   55.0 41.0     27.0   8.0     56.0   17.0   96.0 43 19 5   0 18     0   11   55 41     27 8   56 17   96
1945939 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_1 28.0 16.0 4.0   0.0 3.0     0.0   10.0   31.0 30.0     17.0   2.0     39.0   12.0   61.0 28 16 4   0 3     0   10   31 30     17 2   39 12   61
1945940 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 48.0 22.0 6.0   0.0 7.0     0.0   9.0   50.0 42.0     19.0   6.0     56.0   20.0   92.0 48 22 6   0 7     0   9   50 42     19 6   56 20   92
1945941 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_3 39.0 16.0 10.0   2.0 9.0     1.0   4.0   36.0 45.0     27.0   3.0     59.0   14.0   81.0 39 16 10   2 9     1   4   36 45     27 3   59 14   81
1945942 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 42.0 15.0 4.0   1.0 11.0     0.0   5.0   39.0 39.0     14.0   6.0     46.0   20.0   78.0 42 15 4   1 11     0   5   39 39     14 6   46 20   78
1945943 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 41.0 18.0 2.0   1.0 7.0     0.0   13.0   42.0 40.0     15.0   3.0     57.0   16.0   82.0 41 18 2   1 7     0   13   42 40     15 3   57 16   82
1945944 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 260.0 110.0 32.0   4.0 63.0     1.0   54.0   265.0 259.0     119.0   28.0     326.0   99.0   524.0 260 110 32   4 63     1   54   265 259     119 28   326 99   524
1945945 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000101 402 CROOKED LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   kindergarten 65.0 6.0 3.0   0.0 3.0     1.0   3.0   41.0 40.0     *   0.0         10.0   81.0 65 6 3   0 3     1   3   41 40       0     10   81
1945946 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000101 402 CROOKED LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 73.0 1.0 2.0   1.0 1.0     0.0   4.0   47.0 35.0     *   0.0         13.0   82.0 73 1 2   1 1     0   4   47 35       0     13   82
1945947 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000101 402 CROOKED LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 69.0 7.0 2.0   0.0 2.0     0.0   7.0   48.0 39.0     *   0.0     18.0   14.0   87.0 69 7 2   0 2     0   7   48 39       0   18 14   87
1945948 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000101 402 CROOKED LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_3 71.0 3.0 2.0   0.0 1.0     0.0   4.0   38.0 43.0     0.0   0.0     12.0   14.0   81.0 71 3 2   0 1     0   4   38 43     0 0   12 14   81
1945949 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000101 402 CROOKED LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 57.0 7.0 2.0   1.0 4.0     0.0   2.0   37.0 36.0     *   *         12.0   73.0 57 7 2   1 4     0   2   37 36             12   73
1945950 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000101 402 CROOKED LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 76.0 6.0 1.0   1.0 1.0     0.0   4.0   53.0 36.0     1.0   *     23.0   22.0   89.0 76 6 1   1 1     0   4   53 36     1     23 22   89

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