Data source: Big Local News · About: Big Local

2,294 rows where grade = "pk_12_total", state = "MN" and year = 2017 sorted by ccd_school_lvl

View and edit SQL

year

  • 2017 · 2,294

grade

  • pk_12_total · 2,294
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
690556 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 2017   pk_12_total 576.0 1.0 12.0   7.0 4.0     0.0   19.0   339.0 280.0         0.0     304.0   109.0   619.0 576 1 12   7 4     0   19   339 280       0   304 109   619
690563 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 2017   pk_12_total 86.0 0.0 5.0   0.0 0.0     0.0   5.0   46.0 50.0     0.0   0.0     61.0   30.0   96.0 86 0 5   0 0     0   5   46 50     0 0   61 30   96
690573 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 2017   pk_12_total 195.0 1.0 9.0   75.0 1.0     0.0   4.0   150.0 135.0         *     163.0   69.0   285.0 195 1 9   75 1     0   4   150 135           163 69   285
690581 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 2017   pk_12_total 328.0 78.0 36.0   5.0 35.0     0.0   36.0   261.0 257.0     68.0   6.0     320.0   79.0   518.0 328 78 36   5 35     0   36   261 257     68 6   320 79   518
690588 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 2017   pk_12_total 432.0 23.0 8.0   1.0 11.0     0.0   14.0   255.0 234.0     3.0   5.0     103.0   69.0   489.0 432 23 8   1 11     0   14   255 234     3 5   103 69   489
690595 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 2017   pk_12_total 247.0 65.0 30.0   3.0 14.0     1.0   18.0   205.0 173.0     39.0   1.0     213.0   77.0   378.0 247 65 30   3 14     1   18   205 173     39 1   213 77   378
690602 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000106 404 HAMILTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 275.0 62.0 62.0   6.0 28.0     1.0   32.0   239.0 227.0     85.0   19.0     304.0   87.0   466.0 275 62 62   6 28     1   32   239 227     85 19   304 87   466
690609 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 HOOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 317.0 67.0 35.0   4.0 29.0     0.0   35.0   255.0 232.0     45.0   12.0     238.0   79.0   487.0 317 67 35   4 29     0   35   255 232     45 12   238 79   487
690616 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000110 406 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 508.0 79.0 46.0   4.0 58.0     1.0   45.0   391.0 350.0     69.0   8.0     326.0   126.0   741.0 508 79 46   4 58     1   45   391 350     69 8   326 126   741
690623 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000111 407 JOHNSVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 680.0 34.0 21.0   5.0 49.0     1.0   23.0   409.0 404.0     29.0   3.0     150.0   91.0   813.0 680 34 21   5 49     1   23   409 404     29 3   150 91   813
690630 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000112 408 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 334.0 47.0 35.0   3.0 11.0     0.0   24.0   203.0 251.0     28.0   11.0     247.0   92.0   454.0 334 47 35   3 11     0   24   203 251     28 11   247 92   454
690637 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000113 410 MADISON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 332.0 31.0 36.0   5.0 40.0     2.0   17.0   234.0 229.0     53.0   3.0     183.0   74.0   463.0 332 31 36   5 40     2   17   234 229     53 3   183 74   463
690644 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 MCKINLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 677.0 7.0 14.0   3.0 26.0     0.0   22.0   396.0 353.0     12.0   7.0     139.0   70.0   749.0 677 7 14   3 26     0   22   396 353     12 7   139 70   749
690651 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000115 412 MISSISSIPPI ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 291.0 54.0 25.0   3.0 24.0     1.0   24.0   211.0 211.0     42.0   6.0     209.0   75.0   422.0 291 54 25   3 24     1   24   211 211     42 6   209 75   422
690658 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000116 413 MONROE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 234.0 168.0 38.0   3.0 169.0     0.0   52.0   371.0 293.0     163.0   11.0     334.0   116.0   664.0 234 168 38   3 169     0   52   371 293     163 11   334 116   664
690665 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000118 414 MORRIS BYE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 277.0 52.0 29.0   2.0 22.0     1.0   36.0   212.0 207.0     34.0   15.0     189.0   80.0   419.0 277 52 29   2 22     1   36   212 207     34 15   189 80   419
690672 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000123 417 SAND CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 567.0 79.0 34.0   5.0 57.0     2.0   40.0   408.0 376.0     70.0   9.0     258.0   128.0   784.0 567 79 34   5 57     2   40   408 376     70 9   258 128   784
690679 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 UNIVERSITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 352.0 122.0 34.0   4.0 38.0     0.0   45.0   287.0 308.0     78.0   11.0     330.0   79.0   595.0 352 122 34   4 38     0   45   287 308     78 11   330 79   595
690686 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000128 420 WILSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 496.0 51.0 26.0   6.0 16.0     1.0   48.0   334.0 310.0     42.0   25.0     312.0   112.0   644.0 496 51 26   6 16     1   48   334 310     42 25   312 112   644
690694 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000104 421 EVERGREEN PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 39.0 162.0 93.0   0.0 141.0     0.0   40.0   239.0 236.0     185.0   7.0     373.0   70.0   475.0 39 162 93   0 141     0   40   239 236     185 7   373 70   475
690701 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000103 422 EISENHOWER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 454.0 71.0 77.0   4.0 55.0     1.0   54.0   352.0 364.0     89.0   37.0     354.0   105.0   716.0 454 71 77   4 55     1   54   352 364     89 37   354 105   716
690708 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000120 423 RAMSEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 1033.0 110.0 31.0   7.0 42.0     0.0   51.0   686.0 588.0     78.0   14.0     360.0   191.0   1274.0 1033 110 31   7 42     0   51   686 588     78 14   360 191   1274
690715 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000102 424 DAYTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 337.0 17.0 84.0   1.0 8.0     0.0   22.0   234.0 235.0     59.0   6.0     143.0   77.0   469.0 337 17 84   1 8     0   22   234 235     59 6   143 77   469
690722 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002193 425 OXBOW CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 872.0 127.0 38.0   3.0 82.0     3.0   86.0   619.0 592.0     60.0   5.0     286.0   142.0   1211.0 872 127 38   3 82     3   86   619 592     60 5   286 142   1211
690729 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002203 426 ANDOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 1165.0 40.0 49.0   1.0 46.0     5.0   33.0   701.0 638.0     59.0   7.0     221.0   146.0   1339.0 1165 40 49   1 46     5   33   701 638     59 7   221 146   1339
690736 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318003058 427 RUM RIVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 915.0 22.0 30.0   2.0 18.0     2.0   29.0   535.0 483.0     22.0   4.0     191.0   158.0   1018.0 915 22 30   2 18     2   29   535 483     22 4   191 158   1018
690743 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318004406 430 CHAMPLIN/BROOKLYN PK ACD MATH ENSCI Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 575.0 119.0 42.0   5.0 73.0     1.0   66.0   444.0 437.0     68.0   2.0     301.0   107.0   881.0 575 119 42   5 73     1   66   444 437     68 2   301 107   881
690750 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810000332 510 CENTENNIAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 377.0 38.0 27.0   2.0 33.0     0.0   28.0   260.0 245.0     19.0   1.0     140.0   71.0   505.0 377 38 27   2 33     0   28   260 245     19 1   140 71   505
690757 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810000335 511 CENTERVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 440.0 5.0 10.0   4.0 25.0     0.0   28.0   259.0 253.0     7.0   1.0     48.0   64.0   512.0 440 5 10   4 25     0   28   259 253     7 1   48 64   512
690764 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810000336 512 GOLDEN LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 227.0 20.0 59.0   0.0 31.0     1.0   26.0   176.0 188.0     53.0   7.0     152.0   62.0   364.0 227 20 59   0 31     1   26   176 188     53 7   152 62   364
690771 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 2017   pk_12_total 531.0 4.0 17.0   0.0 12.0     0.0   32.0   301.0 295.0     2.0   5.0     51.0   100.0   596.0 531 4 17   0 12     0   32   301 295     2 5   51 100   596
690778 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810003172 515 BLUE HERON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 707.0 30.0 30.0   4.0 50.0     0.0   41.0   400.0 462.0     22.0   2.0     119.0   101.0   862.0 707 30 30   4 50     0   41   400 462     22 2   119 101   862
690787 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000398 515 HIGHLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 133.0 171.0 154.0   11.0 33.0     0.0   82.0   316.0 268.0     177.0   14.0     443.0   99.0   584.0 133 171 154   11 33     0   82   316 268     177 14   443 99   584
690796 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000400 517 NORTH PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 119.0 151.0 148.0   4.0 17.0     0.0   45.0   238.0 246.0     163.0   11.0     389.0   68.0   484.0 119 151 148   4 17     0   45   238 246     163 11   389 68   484
690805 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000402 520 VALLEY VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 107.0 133.0 240.0   2.0 17.0     1.0   38.0   256.0 282.0     191.0   23.0     440.0   59.0   538.0 107 133 240   2 17     1   38   256 282     191 23   440 59   538
690812 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000612 546 HAYES ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 242.0 179.0 49.0   5.0 26.0     0.0   62.0   300.0 263.0     110.0   13.0     340.0   92.0   563.0 242 179 49   5 26     0   62   300 263     110 13   340 92   563
690820 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000614 550 STEVENSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 239.0 219.0 74.0   7.0 44.0     0.0   39.0   320.0 302.0     105.0   11.0     436.0   78.0   622.0 239 219 74   7 44     0   39   320 302     105 11   436 78   622
690827 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000230 782 ST. FRANCIS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 587.0 7.0 29.0   4.0 8.0     0.0   51.0   352.0 334.0     8.0   3.0     180.0   110.0   686.0 587 7 29   4 8     0   51   352 334     8 3   180 110   686
690834 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000233 784 CEDAR CREEK COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 617.0 3.0 23.0   7.0 42.0     0.0   28.0   368.0 352.0     40.0   7.0     182.0   98.0   720.0 617 3 23   7 42     0   28   368 352     40 7   182 98   720
690841 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000258 848 EAST BETHEL COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 487.0 8.0 17.0   7.0 12.0     0.0   30.0   296.0 265.0     28.0   3.0     194.0   82.0   561.0 487 8 17   7 12     0   30   296 265     28 3   194 82   561
690846 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001461 772 NORTHPOINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   pk_12_total 510.0 49.0 48.0   2.0 59.0     0.0   63.0   399.0 332.0     60.0   1.0     185.0   81.0   731.0 510 49 48   2 59     0   63   399 332     60 1   185 81   731
690849 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001465 773 WESTWOOD INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 04 05 2017   pk_12_total 440.0 102.0 89.0   13.0 60.0     0.0   55.0   389.0 370.0     109.0   7.0     334.0   104.0   759.0 440 102 89   13 60     0   55   389 370     109 7   334 104   759
690856 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001467 774 Woodcrest Elementary Spanish Immersion Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 324.0 25.0 180.0   3.0 15.0     1.0   39.0   261.0 326.0     81.0   0.0     157.0   28.0   587.0 324 25 180   3 15     1   39   261 326     81 0   157 28   587
690861 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001462 775 Park Terrace Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   pk_12_total 355.0 106.0 102.0   2.0 62.0     1.0   83.0   363.0 348.0     133.0   6.0     418.0   102.0   711.0 355 106 102   2 62     1   83   363 348     133 6   418 102   711
690867 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333004657 787 Elementary Lighthouse Elementary School (Grades PK-6) Regular School No Elementary 01 06 2017   pk_12_total 31.0 1.0 2.0   0.0 3.0     0.0   3.0   23.0 17.0     0.0   0.0     7.0   4.0   40.0 31 1 2   0 3     0   3   23 17     0 0   7 4   40
690874 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 2017   pk_12_total 509.0 4.0 14.0   38.0 4.0     0.0   56.0   323.0 302.0     1.0   7.0     231.0   106.0   625.0 509 4 14   38 4     0   56   323 302     1 7   231 106   625
690876 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023004362 55 LINCOLN EARLY CHILDHOOD ED. CENTER Elementary School (Grades PK-6) Regular School No Elementary PK PK 2017   pk_12_total 52.0 1.0 1.0   30.0 0.0     0.0   11.0   62.0 33.0     0.0   1.0     61.0   *   95.0 52 1 1   30 0     0   11   62 33     0 1   61     95
690882 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 2017   pk_12_total 421.0 16.0 23.0   75.0 2.0     0.0   81.0   309.0 309.0     3.0   17.0     323.0   118.0   618.0 421 16 23   75 2     0   81   309 309     3 17   323 118   618
690891 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 2017   pk_12_total 439.0 3.0 17.0   7.0 0.0     0.0   31.0   248.0 249.0     0.0   7.0     237.0   99.0   497.0 439 3 17   7 0     0   31   248 249     0 7   237 99   497
690901 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 2017   pk_12_total 0.0 0.0 0.0   56.0 0.0     0.0   0.0   18.0 38.0     0.0   0.0         12.0   56.0 0 0 0   56 0     0   0   18 38     0 0     12   56
690908 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 05 2017   pk_12_total 381.0 1.0 13.0   55.0 2.0     0.0   37.0   249.0 240.0     0.0   2.0     204.0   81.0   489.0 381 1 13   55 2     0   37   249 240     0 2   204 81   489
690910 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444004454 30 PAUL BUNYAN CENTER Elementary School (Grades PK-6) Regular School No Elementary PK 01 2017   pk_12_total 174.0 2.0 4.0   19.0 2.0     0.0   12.0   115.0 98.0         0.0     88.0   27.0   213.0 174 2 4   19 2     0   12   115 98       0   88 27   213
690918 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 05 2017   pk_12_total 173.0 21.0 14.0   143.0 2.0     0.0   79.0   244.0 188.0     1.0   8.0     346.0   106.0   432.0 173 21 14   143 2     0   79   244 188     1 8   346 106   432
690926 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 05 2017   pk_12_total 132.0 2.0 8.0   70.0 1.0     0.0   39.0   151.0 101.0     1.0   21.0     193.0   49.0   252.0 132 2 8   70 1     0   39   151 101     1 21   193 49   252
690934 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 05 2017   pk_12_total 383.0 8.0 8.0   108.0 1.0     0.0   65.0   318.0 255.0     0.0   4.0     330.0   111.0   573.0 383 8 8   108 1     0   65   318 255     0 4   330 111   573
690941 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 01 05 2017   pk_12_total 135.0 1.0 3.0   10.0 0.0     1.0   20.0   88.0 82.0     1.0   7.0     91.0   32.0   170.0 135 1 3   10 0     1   20   88 82     1 7   91 32   170
690948 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000193 100 HORACE MAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   pk_12_total 386.0 6.0 8.0   42.0 4.0     0.0   33.0   263.0 216.0     2.0   6.0     195.0   106.0   479.0 386 6 8   42 4     0   33   263 216     2 6   195 106   479
690958 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 2017   pk_12_total 277.0 2.0 8.0   38.0 0.0     0.0   23.0   186.0 162.0     1.0   11.0     211.0   73.0   348.0 277 2 8   38 0     0   23   186 162     1 11   211 73   348
690968 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 2017   pk_12_total 91.0 0.0 0.0   81.0 0.0     0.0   0.0   99.0 73.0     0.0   0.0     132.0   43.0   172.0 91 0 0   81 0     0   0   99 73     0 0   132 43   172
690974 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 2017   pk_12_total 0.0 1.0 0.0   568.0 0.0     0.0   0.0   292.0 277.0         85.0     508.0   103.0   569.0 0 1 0   568 0     0   0   292 277       85   508 103   569
690977 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051003303 11 RED LAKE EARLY CHILDHOOD CENTER Elementary School (Grades PK-6) Regular School No Elementary PK KG 2017   pk_12_total 0.0 0.0 0.0   178.0 0.0     0.0   0.0   92.0 86.0     0.0   17.0     154.0   63.0   178.0 0 0 0   178 0     0   0   92 86     0 17   154 63   178
690988 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 2017   pk_12_total 0.0 0.0 0.0   210.0 0.0     0.0   0.0   115.0 95.0     0.0   35.0         55.0   210.0 0 0 0   210 0     0   0   115 95     0 35     55   210
690995 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 2017   pk_12_total 900.0 25.0 29.0   5.0 4.0     1.0   46.0   503.0 507.0     13.0   12.0     294.0   142.0   1010.0 900 25 29   5 4     1   46   503 507     13 12   294 142   1010
691003 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 2017   pk_12_total 315.0 1.0 11.0   1.0 0.0     0.0   16.0   187.0 157.0     2.0   3.0     117.0   65.0   344.0 315 1 11   1 0     0   16   187 157     2 3   117 65   344
691011 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 2017   pk_12_total 703.0 39.0 36.0   7.0 21.0     0.0   17.0   412.0 411.0     20.0   14.0     367.0   201.0   823.0 703 39 36   7 21     0   17   412 411     20 14   367 201   823
691017 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 2017   pk_12_total 547.0 1.0 3.0   4.0 1.0     0.0   4.0   295.0 265.0     0.0   1.0     172.0   102.0   560.0 547 1 3   4 1     0   4   295 265     0 1   172 102   560
691023 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224002270 30 FOLEY INTERMEDIATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   pk_12_total 744.0 1.0 5.0   2.0 0.0     0.0   12.0   397.0 367.0     0.0   1.0     214.0   119.0   764.0 744 1 5   2 0     0   12   397 367     0 1   214 119   764
691032 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 2017   pk_12_total 363.0 0.0 5.0   0.0 0.0     0.0   6.0   176.0 198.0     0.0   1.0     79.0   43.0   374.0 363 0 5   0 0     0   6   176 198     0 1   79 43   374
691041 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 2017   pk_12_total 268.0 101.0 30.0   0.0 4.0     3.0   28.0   211.0 223.0     57.0   10.0     212.0   78.0   434.0 268 101 30   0 4     3   28   211 223     57 10   212 78   434
691048 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 2017   pk_12_total 400.0 79.0 24.0   0.0 8.0     0.0   24.0   267.0 268.0     46.0   2.0     170.0   57.0   535.0 400 79 24   0 8     0   24   267 268     46 2   170 57   535
691055 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 2017   pk_12_total 183.0 30.0 14.0   3.0 3.0     0.0   21.0   126.0 128.0     13.0   11.0     100.0   28.0   254.0 183 30 14   3 3     0   21   126 128     13 11   100 28   254
691062 MN Nicollet 52 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000881 40 MONROE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 435.0 30.0 36.0   0.0 5.0     0.0   19.0   236.0 289.0     5.0   11.0     177.0   73.0   525.0 435 30 36   0 5     0   19   236 289     5 11   177 73   525
691069 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000883 50 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 308.0 44.0 24.0   0.0 3.0     0.0   18.0   209.0 188.0     31.0   2.0     152.0   57.0   397.0 308 44 24   0 3     0   18   209 188     31 2   152 57   397
691076 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 2017   pk_12_total 161.0 1.0 4.0   0.0 12.0     0.0   9.0   92.0 95.0     1.0   0.0     27.0   12.0   187.0 161 1 4   0 12     0   9   92 95     1 0   27 12   187
691083 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878004388 70 ROSA PARKS ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 369.0 61.0 41.0   5.0 17.0     0.0   34.0   302.0 225.0     43.0   5.0     236.0   93.0   527.0 369 61 41   5 17     0   34   302 225     43 5   236 93   527
691090 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 2017   pk_12_total 295.0 46.0 20.0   0.0 8.0     0.0   17.0   194.0 192.0     32.0   2.0     139.0   49.0   386.0 295 46 20   0 8     0   17   194 192     32 2   139 49   386
691097 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 2017   pk_12_total 346.0 46.0 36.0   0.0 5.0     0.0   31.0   235.0 229.0     35.0   9.0     238.0   89.0   464.0 346 46 36   0 5     0   31   235 229     35 9   238 89   464
691104 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000872 150 EAGLE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 350.0 18.0 17.0   0.0 1.0     2.0   22.0   217.0 193.0     6.0   5.0     115.0   56.0   410.0 350 18 17   0 1     2   22   217 193     6 5   115 56   410
691112 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 2017   pk_12_total 62.0 0.0 3.0   0.0 0.0     0.0   3.0   33.0 35.0     0.0   0.0     35.0   20.0   68.0 62 0 3   0 0     0   3   33 35     0 0   35 20   68
691121 MN Brown 8 school 2733210 84 Independent Districts and Schools SLEEPY EYE PUBLIC SCHOOL DISTRICT 273321001450 10 SLEEPY EYE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 178.0 4.0 117.0   0.0 5.0     0.0   5.0   160.0 149.0     37.0   12.0     162.0   55.0   309.0 178 4 117   0 5     0   5   160 149     37 12   162 55   309
691130 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 2017   pk_12_total 269.0 1.0 23.0   0.0 3.0     0.0   1.0   158.0 139.0     1.0   0.0     111.0   34.0   297.0 269 1 23   0 3     0   1   158 139     1 0   111 34   297
691135 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 2017   pk_12_total 587.0 7.0 37.0   0.0 2.0     0.0   21.0   354.0 300.0     7.0   3.0     211.0   93.0   654.0 587 7 37   0 2     0   21   354 300     7 3   211 93   654
691138 MN Brown 8 school 2723490 88 Independent Districts and Schools NEW ULM PUBLIC SCHOOL DISTRICT 272349001154 30 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK KG 2017   pk_12_total 167.0 3.0 11.0   1.0 1.0     0.0   3.0   104.0 82.0     1.0   2.0     67.0   60.0   186.0 167 3 11   1 1     0   3   104 82     1 2   67 60   186
691147 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 2017   pk_12_total 389.0 0.0 10.0   3.0 0.0     0.0   24.0   228.0 198.0     0.0   0.0     132.0   81.0   426.0 389 0 10   3 0     0   24   228 198     0 0   132 81   426
691155 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 2017   pk_12_total 166.0 2.0 2.0   26.0 0.0     0.0   9.0   103.0 102.0     0.0   *         *   205.0 166 2 2   26 0     0   9   103 102     0           205
691163 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 06 2017   pk_12_total 376.0 3.0 9.0   69.0 2.0     0.0   63.0   262.0 260.0     0.0   8.0     240.0   91.0   522.0 376 3 9   69 2     0   63   262 260     0 8   240 91   522
691170 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 2017   pk_12_total 464.0 1.0 8.0   67.0 1.0     1.0   96.0   335.0 303.0     1.0   9.0     292.0   98.0   638.0 464 1 8   67 1     1   96   335 303     1 9   292 98   638
691179 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 2017   pk_12_total 175.0 3.0 2.0   13.0 2.0     0.0   4.0   103.0 96.0     0.0   0.0     76.0   26.0   199.0 175 3 2   13 2     0   4   103 96     0 0   76 26   199
691188 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 2017   pk_12_total 343.0 2.0 0.0   4.0 2.0     0.0   20.0   189.0 182.0     0.0   13.0     148.0   63.0   371.0 343 2 0   4 2     0   20   189 182     0 13   148 63   371
691197 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 2017   pk_12_total 612.0 3.0 8.0   2.0 1.0     0.0   29.0   335.0 320.0     0.0   8.0     87.0   72.0   655.0 612 3 8   2 1     0   29   335 320     0 8   87 72   655
691206 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 2017   pk_12_total 181.0 0.0 0.0   0.0 1.0     0.0   8.0   88.0 102.0     0.0   0.0     89.0   34.0   190.0 181 0 0   0 1     0   8   88 102     0 0   89 34   190
691214 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 2017   pk_12_total 404.0 16.0 34.0   1.0 1.0     0.0   21.0   247.0 230.0     23.0   2.0     104.0   91.0   477.0 404 16 34   1 1     0   21   247 230     23 2   104 91   477
691221 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146000363 110 SOUTHVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 590.0 11.0 17.0   0.0 9.0     0.0   19.0   325.0 321.0     10.0   0.0     74.0   76.0   646.0 590 11 17   0 9     0   19   325 321     10 0   74 76   646
691228 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 PK 05 2017   pk_12_total 566.0 2.0 25.0   6.0 6.0     0.0   14.0   340.0 279.0     12.0   4.0     81.0   97.0   619.0 566 2 25   6 6     0   14   340 279     12 4   81 97   619
691235 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 2017   pk_12_total 467.0 6.0 15.0   1.0 3.0     0.0   11.0   247.0 256.0     4.0   0.0     41.0   70.0   503.0 467 6 15   1 3     0   11   247 256     4 0   41 70   503
691238 MN Carver 10 school 2741910 111 Independent Districts and Schools WATERTOWN-MAYER PUBLIC SCHOOL DIST. 274191003623 837 WATERTOWN-MAYER PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK KG 2017   pk_12_total 126.0 0.0 2.0   1.0 1.0     0.0   6.0   82.0 54.0     1.0   0.0     27.0   61.0   136.0 126 0 2   1 1     0   6   82 54     1 0   27 61   136
691244 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 01 05 2017   pk_12_total 561.0 4.0 12.0   5.0 8.0     0.0   14.0   317.0 287.0     10.0   0.0     156.0   101.0   604.0 561 4 12   5 8     0   14   317 287     10 0   156 101   604
691251 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819004598 501 LA ACADEMIA Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 175.0 3.0 131.0   0.0 2.0     0.0   8.0   148.0 171.0     92.0   2.0     109.0   21.0   319.0 175 3 131   0 2     0   8   148 171     92 2   109 21   319
691258 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000344 505 CHASKA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 384.0 58.0 74.0   0.0 13.0     0.0   33.0   284.0 278.0     59.0   9.0     210.0   71.0   562.0 384 58 74   0 13     0   33   284 278     59 9   210 71   562
691265 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000342 506 CHANHASSEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 386.0 24.0 36.0   2.0 38.0     0.0   33.0   269.0 250.0     34.0   0.0     100.0   72.0   519.0 386 24 36   2 38     0   33   269 250     34 0   100 72   519

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