enrollments

Data source: Big Local News · About: Big Local

964 rows where grade = "grade_2", state = "MN" and year = 2017 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 964 ✖

grade ✖

  • grade_2 · 964 ✖
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
694283 694283 MN Lake of the Woods 39 school 2741850 690 Independent Districts and Schools WARROAD PUBLIC SCHOOL DISTRICT 274185002456 20 ANGLE INLET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_2 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
700496 700496 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942004962 110 CAAEP SETTING 4 Special Education Special Education School No Other 02 12 2017   grade_2 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
700529 700529 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002517 100 DAKOTA RIDGE SCHOOL Special Education Special Education School No Other KG 12 2017   grade_2 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
700621 700621 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378000833 756 ST. LOUIS PARK SPECIAL ED. PROGRAM Special Education Special Education School No Elementary PK 06 2017   grade_2 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
700673 700673 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180000985 342 ROCHESTER PHOENIX ACADEMY Special Education Special Education School No Other KG 12 2017   grade_2 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 0 1 0   0 0     0   0   0 1                 1
700818 700818 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104002554 610 SPECIAL ED. N.P. Special Education Special Education School No Other PK 12 2017   grade_2 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
700838 700838 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004142 401 ISD 728 FOCUS/JOURNEY Special Education Special Education School No Other 02 12 2017   grade_2 0.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 1 0   0 0     0   0   1 0                 1
700855 700855 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351004648 62 Roosevelt Education Center Special Education Special Education School No Other KG 12 2017   grade_2 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0         *         *   1.0 0 0 0   0 0     0   1   1 0                 1
700965 700965 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) MINNESOTA STATE ACADEMIES 270012902409 2 MN ACADEMY FOR THE DEAF Special Education Special Education School No Other PK 12 2017   grade_2 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 0 1 0   0 0     0   0   0 1                 1
701032 701032 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503542 479 SAFE Special Education Special Education School No Other 01 12 2017   grade_2 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0         *         *   1.0 0 0 0   0 0     0   1   1 0                 1
701055 701055 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503234 486 CIP Special Education Special Education School No Other 01 12 2017   grade_2 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
701070 701070 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042005038 12 SW Metro Level 4 Programs Special Education Special Education School No Other 01 12 2017   grade_2 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
701121 701121 MN Washington 82 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226402100 50 ALP @ VCCS Special Education Special Education School No Elementary KG 06 2017   grade_2 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
701127 701127 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226402104 51 ELEMENTARY ALP @ JOHN GLENN Special Education Special Education School No Elementary KG 06 2017   grade_2 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
701171 701171 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002602125 61 917 PACES Special Education Special Education School No Other KG 12 2017   grade_2 0.0 0.0 0.0   0.0 1.0     0.0   0.0   1.0 0.0         *         *   1.0 0 0 0   0 1     0   0   1 0                 1
701287 701287 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004502732 18 EASTERN WRIGHT PROGRAM Special Education Special Education School No Elementary KG 07 2017   grade_2 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
701308 701308 MN Mower 50 school 2700327 6083 Special Education Cooperatives SOUTHERN MN EDUCATION CONSORTIUM 270032704983 10 Enrich Program Special Education Special Education School No Other KG 12 2017   grade_2 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
701326 701326 MN Mower 50 school 2700327 6083 Special Education Cooperatives SOUTHERN MN EDUCATION CONSORTIUM 270032705011 40 CARDS Program Special Education Special Education School No Other PK 12 2017   grade_2 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
701352 701352 MN Wright 86 school 2700413 6090 Special Education Cooperatives Sherburne and Northern Wright Special Education Cooperative 270041304947 80 Becker Intermediate School - SNW Special Education Special Education School No Elementary 02 06 2017   grade_2 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
701358 701358 MN Rice 66 school 2700424 6094 Special Education Cooperatives Cannon Valley Special Education Cooperative 270042404938 10 Alexander Learning Academy Special Education Special Education School No Other KG 12 2017   grade_2 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
701404 701404 MN Lyon 42 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604438 22 BELVIEW LEARNING CTR BRIDGES Special Education Special Education School No Other KG 12 2017   grade_2 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
701414 701414 MN Meeker 47 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604236 25 COSMOS LEARNING CENTER-TRANSITIONS Special Education Special Education School No Other KG 12 2017   grade_2 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
701433 701433 MN Pipestone 59 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604353 29 BLUE MOUND LEARNING CENTER Special Education Special Education School No Other KG 12 2017   grade_2 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
701442 701442 MN Kandiyohi 34 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604724 47 North Central Learning Center Special Education Special Education School No Other KG 12 2017   grade_2 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
701455 701455 MN Cottonwood 17 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604985 57 Red Rock Ridge - SUN Special Education Special Education School No Other KG 12 2017   grade_2 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
701523 701523 MN Wabasha 79 school 2700055 6013 Education Districts HIAWATHA VALLEY ED. DISTRICT 270005504535 31 SAIL PROGRAM Special Education Special Education School No Other PK 12 2017   grade_2 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
701568 701568 MN Brown 8 school 2791353 6049 Education Districts RIVER BEND EDUCATION DISTRICT 279135304366 35 IMPRINTS PROGRAM Special Education Special Education School No Other 02 12 2017   grade_2 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
701615 701615 MN Morrison 49 school 2700073 6979 Education Districts MID STATE EDUCATION DISTRICT 270007303304 10 MID STAT ED DIST. SUCCESS PROG. Special Education Special Education School No Other PK 12 2017   grade_2 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
701622 701622 MN Morrison 49 school 2700073 6979 Education Districts MID STATE EDUCATION DISTRICT 270007303604 30 MORRISON COUNTY LEARNING CENTER Special Education Special Education School No Elementary KG 08 2017   grade_2 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
701661 701661 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819004659 522 PrairieCare Chaska Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2017   grade_2 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
701674 701674 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001053 7 HOME/HOSPITAL INSTRUCTION Hospital/Medical/Partial Hospitalization Program Alternative School No Other PK 12 2017   grade_2 0.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 1 0   0 0     0   0   1 0                 1
702263 702263 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000468 17 LINCOLN EDUCATION CENTER Miscellaneous Program (assignment is now limited) Alternative School No Other 02 12 2017   grade_2 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0         *         *   1.0 0 0 0   0 0     0   1   1 0                 1
702293 702293 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004209 101 ELK RIVER DISTRICT SHARED TIME PROG Miscellaneous Program (assignment is now limited) Alternative School No Elementary KG 05 2017   grade_2 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
702431 702431 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351001640 72 RIVERWOODS SCHOOL NON-RESIDENTIAL Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2017   grade_2 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
702442 702442 MN Swift 76 school 2704470 777 Independent Districts and Schools BENSON PUBLIC SCHOOL DISTRICT 270447003708 112 Benson Day Treatment Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2017   grade_2 0.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 1 0   0 0     0   0   1 0                 1
702513 702513 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002604807 100 Youth Transition Program Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2017   grade_2 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
702613 702613 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345003192 450 NEW DOMINION ACADEMY Educational Oversight to Private Residential Care & Treatment (State approved) Alternative School No Other KG 12 2017   grade_2 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 0 1   0 0     0   0   1 0                 1
702641 702641 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002860 315 RONALD MCDONALD HOUSE Private Alternative Program Alternative School No Other KG 12 2017   grade_2 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
692978 692978 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 2017   grade_2 10.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 3.0     0.0   0.0     5.0   2.0   10.0 10 0 0   0 0     0   0   7 3     0 0   5 2   10
694864 694864 MN Stevens 75 school 2708940 771 Independent Districts and Schools CHOKIO-ALBERTA PUBLIC SCHOOL DIST. 270894000362 3 CHOKIO-ALBERTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_2 10.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 6.0     0.0   0.0     2.0   0.0   10.0 10 0 0   0 0     0   0   4 6     0 0   2 0   10
697045 697045 MN Waseca 81 school 2700241 4127 Charter Schools TEAM ACADEMY 270024103341 10 TEAM ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_2 6.0 2.0 2.0   0.0 0.0     0.0   0.0   8.0 2.0     2.0   1.0     5.0   1.0   10.0 6 2 2   0 0     0   0   8 2     2 1   5 1   10
697283 697283 MN Washington 82 school 2700310 4187 Charter Schools NATURAL SCIENCE ACADEMY 270031004276 10 NATURAL SCIENCE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2017   grade_2 6.0 0.0 3.0   0.0 1.0     0.0   0.0   5.0 5.0     0.0   0.0     0.0   *   10.0 6 0 3   0 1     0   0   5 5     0 0   0     10
700444 700444 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 RIVER TRAIL LEARNING CTR @ LO JACOB Special Education Special Education School No Other KG 12 2017   grade_2 5.0 2.0 2.0   0.0 0.0     0.0   1.0   8.0 2.0     0.0   0.0     4.0   *   10.0 5 2 2   0 0     0   1   8 2     0 0   4     10
690837 690837 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   grade_2 85.0 1.0 4.0   2.0 1.0     0.0   7.0   47.0 53.0     5.0   0.0         *   100.0 85 1 4   2 1     0   7   47 53     5 0         100
691224 691224 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   grade_2 94.0 0.0 2.0   2.0 1.0     0.0   1.0   51.0 49.0     2.0   1.0     18.0   12.0   100.0 94 0 2   2 1     0   1   51 49     2 1   18 12   100
691665 691665 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002985 599 OAK HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 64.0 1.0 24.0   0.0 9.0     0.0   2.0   55.0 45.0     15.0   *     22.0   9.0   100.0 64 1 24   0 9     0   2   55 45     15     22 9   100
691702 691702 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001382 708 SOUTHVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 55.0 17.0 13.0   0.0 5.0     0.0   10.0   46.0 54.0     12.0   2.0     35.0   13.0   100.0 55 17 13   0 5     0   10   46 54     12 2   35 13   100
691767 691767 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002216 717 WOODLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 69.0 10.0 5.0   0.0 11.0     0.0   5.0   59.0 41.0     7.0   1.0     20.0   12.0   100.0 69 10 5   0 11     0   5   59 41     7 1   20 12   100
692277 692277 MN Hennepin 27 school 2711250 273 Independent Districts and Schools EDINA PUBLIC SCHOOL DISTRICT 271125002269 529 HIGHLANDS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 73.0 3.0 3.0   1.0 17.0     0.0   3.0   56.0 44.0     7.0   0.0     7.0   14.0   100.0 73 3 3   1 17     0   3   56 44     7 0   7 14   100
694476 694476 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006001275 11 FIVE HAWKS EL. Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 85.0 5.0 3.0   1.0 3.0     0.0   3.0   54.0 46.0     4.0   1.0     18.0   23.0   100.0 85 5 3   1 3     0   3   54 46     4 1   18 23   100
694518 694518 MN Scott 70 school 2733000 720 Independent Districts and Schools SHAKOPEE PUBLIC SCHOOL DISTRICT 273300001437 861 SUN PATH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 58.0 14.0 9.0   1.0 11.0     0.0   7.0   49.0 51.0     22.0   1.0     39.0   6.0   100.0 58 14 9   1 11     0   7   49 51     22 1   39 6   100
694636 694636 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137000030 700 MEADOWVALE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 86.0 2.0 5.0   0.0 2.0     0.0   5.0   63.0 37.0     4.0   0.0     21.0   *   100.0 86 2 5   0 2     0   5   63 37     4 0   21     100
691644 691644 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778000025 596 CHERRY VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 89.0 0.0 2.0   0.0 5.0     0.0   5.0   51.0 50.0     4.0   0.0         13.0   101.0 89 0 2   0 5     0   5   51 50     4 0     13   101
692305 692305 MN Hennepin 27 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167000542 602 DEEPHAVEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 93.0 2.0 1.0   0.0 2.0     0.0   3.0   53.0 48.0     3.0   0.0     6.0   17.0   101.0 93 2 1   0 2     0   3   53 48     3 0   6 17   101
693574 693574 MN Pine 58 school 2728380 578 Independent Districts and Schools PINE CITY PUBLIC SCHOOL DISTRICT 272838001255 10 PINE CITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_2 98.0 1.0 1.0   1.0 0.0     0.0   0.0   52.0 49.0     0.0   0.0     48.0   8.0   101.0 98 1 1   1 0     0   0   52 49     0 0   48 8   101
694562 694562 MN Scott 70 school 2723430 721 Independent Districts and Schools NEW PRAGUE AREA SCHOOLS 272343001144 651 FALCON RIDGE Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 94.0 0.0 0.0   3.0 2.0     0.0   2.0   54.0 47.0         0.0         12.0   101.0 94 0 0   3 2     0   2   54 47       0     12   101
696444 696444 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001866 175 FOLWELL ARTS MAGNET Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_2 14.0 30.0 50.0   3.0 1.0     0.0   3.0   55.0 46.0     44.0   9.0     90.0   10.0   101.0 14 30 50   3 1     0   3   55 46     44 9   90 10   101
697243 697243 MN Ramsey 62 school 2700304 4181 Charter Schools COMMUNITY SCHOOL OF EXCELLENCE 270030403728 10 COMMUNITY SCHOOL OF EXCELLENCE Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_2 0.0 0.0 0.0   0.0 100.0     0.0   1.0   45.0 56.0     83.0   0.0     80.0   7.0   101.0 0 0 0   0 100     0   1   45 56     83 0   80 7   101
692620 692620 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378001530 754 PETER HOBART ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 48.0 22.0 12.0   2.0 3.0     0.0   15.0   52.0 50.0     15.0   5.0     38.0   14.0   102.0 48 22 12   2 3     0   15   52 50     15 5   38 14   102
693742 693742 MN Washington 82 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385002665 37 SKYVIEW COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 47.0 21.0 9.0   1.0 13.0     1.0   10.0   47.0 55.0     10.0   0.0     47.0   10.0   102.0 47 21 9   1 13     1   10   47 55     10 0   47 10   102
694373 694373 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104000459 435 CONGDON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 82.0 5.0 1.0   3.0 4.0     0.0   7.0   55.0 47.0     2.0   4.0     17.0   7.0   102.0 82 5 1   3 4     0   7   55 47     2 4   17 7   102
694669 694669 MN Stearns 73 school 2720550 740 Independent Districts and Schools MELROSE PUBLIC SCHOOL DISTRICT 272055000911 10 MELROSE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 65.0 0.0 35.0   0.0 1.0     0.0   1.0   53.0 49.0     32.0   2.0     53.0   14.0   102.0 65 0 35   0 1     0   1   53 49     32 2   53 14   102
696178 696178 MN Wabasha 79 school 2700287 2899 Independent Districts and Schools PLAINVIEW-ELGIN-MILLVILLE 270028703701 10 PLAINVIEW-ELGIN-MILLVILLE PK-3 Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_2 85.0 0.0 14.0   0.0 0.0     0.0   3.0   38.0 64.0     5.0   0.0     33.0   9.0   102.0 85 0 14   0 0     0   3   38 64     5 0   33 9   102
696431 696431 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001057 167 LK NOKOMIS COMM-WENONAH CAMPUS Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_2 57.0 16.0 16.0   2.0 5.0     0.0   6.0   53.0 49.0     14.0   3.0     45.0   12.0   102.0 57 16 16   2 5     0   6   53 49     14 3   45 12   102
690830 690830 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   grade_2 90.0 1.0 6.0   1.0 4.0     0.0   1.0   53.0 50.0         1.0         20.0   103.0 90 1 6   1 4     0   1   53 50       1     20   103
694340 694340 MN Saint Louis 69 school 2730090 704 Independent Districts and Schools PROCTOR PUBLIC SCHOOL DISTRICT 273009001557 4 BAY VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 94.0 0.0 2.0   1.0 0.0     0.0   6.0   47.0 56.0     0.0   0.0     44.0   *   103.0 94 0 2   1 0     0   6   47 56     0 0   44     103
697160 697160 MN Hennepin 27 school 2700284 4159 Charter Schools Seven Hills Preparatory Academy 270028403614 10 Seven Hills Preparatory Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2017   grade_2 74.0 10.0 6.0   0.0 8.0     0.0   5.0   48.0 55.0     6.0   0.0     16.0   11.0   103.0 74 10 6   0 8     0   5   48 55     6 0   16 11   103
692613 692613 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378001525 745 AQUILA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 47.0 21.0 14.0   1.0 7.0     0.0   14.0   53.0 51.0     29.0   2.0     47.0   *   104.0 47 21 14   1 7     0   14   53 51     29 2   47     104
694692 694692 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351001485 25 KENNEDY COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_2 81.0 12.0 5.0   1.0 0.0     0.0   5.0   52.0 52.0     8.0   1.0     36.0   17.0   104.0 81 12 5   1 0     0   5   52 52     8 1   36 17   104
690675 690675 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   grade_2 66.0 20.0 6.0   0.0 4.0     0.0   9.0   56.0 49.0     12.0   4.0     57.0   12.0   105.0 66 20 6   0 4     0   9   56 49     12 4   57 12   105
690746 690746 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   grade_2 76.0 3.0 8.0   1.0 10.0     0.0   7.0   56.0 49.0     4.0   0.0     24.0   7.0   105.0 76 3 8   1 10     0   7   56 49     4 0   24 7   105
691609 691609 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002205 621 AKIN ROAD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 82.0 2.0 9.0   3.0 1.0     0.0   8.0   40.0 65.0     8.0   2.0     15.0   4.0   105.0 82 2 9   3 1     0   8   40 65     8 2   15 4   105
692208 692208 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422002271 880 Oak Point Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_2 41.0 12.0 6.0   0.0 41.0     0.0   5.0   58.0 47.0     21.0   0.0     20.0   13.0   105.0 41 12 6   0 41     0   5   58 47     21 0   20 13   105
692263 692263 MN Hennepin 27 school 2711250 273 Independent Districts and Schools EDINA PUBLIC SCHOOL DISTRICT 271125000506 527 CORNELIA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 54.0 14.0 10.0   0.0 21.0     0.0   6.0   57.0 48.0     20.0   0.0     23.0   11.0   105.0 54 14 10   0 21     0   6   57 48     20 0   23 11   105
694607 694607 MN Hennepin 27 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137003534 160 HASSAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 92.0 4.0 3.0   0.0 2.0     0.0   4.0   48.0 57.0     3.0   0.0     12.0   8.0   105.0 92 4 3   0 2     0   4   48 57     3 0   12 8   105
696405 696405 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001031 160 SEWARD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2017   grade_2 41.0 54.0 3.0   3.0 4.0     0.0   0.0   49.0 56.0     35.0   4.0     59.0   6.0   105.0 41 54 3   3 4     0   0   49 56     35 4   59 6   105
693522 693522 MN Otter Tail 56 school 2728230 549 Independent Districts and Schools PERHAM-DENT PUBLIC SCHOOL DISTRICT 272823001247 10 HEART OF THE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 88.0 2.0 8.0   1.0 2.0     1.0   4.0   54.0 52.0     8.0   0.0     44.0   13.0   106.0 88 2 8   1 2     1   4   54 52     8 0   44 13   106
694823 694823 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805001226 902 MCKINLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 75.0 16.0 14.0   0.0 0.0     0.0   1.0   51.0 55.0     23.0   7.0     53.0   *   106.0 75 16 14   0 0     0   1   51 55     23 7   53     106
696726 696726 MN Saint Louis 69 school 2700133 4020 Charter Schools DULUTH PUBLIC SCHOOLS ACADEMY 270013302711 10 NORTH STAR ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_2 86.0 2.0 5.0   1.0 2.0     0.0   10.0   53.0 53.0     1.0   1.0     30.0   11.0   106.0 86 2 5   1 2     0   10   53 53     1 1   30 11   106
697225 697225 MN Hennepin 27 school 2700295 4171 Charter Schools NOBLE ACADEMY 270029503727 10 NOBLE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_2 0.0 11.0 1.0   0.0 94.0     0.0   0.0   58.0 48.0     72.0   0.0     63.0   8.0   106.0 0 11 1   0 94     0   0   58 48     72 0   63 8   106
690697 690697 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   grade_2 72.0 10.0 12.0   0.0 5.0     1.0   7.0   48.0 59.0     16.0   5.0     53.0   14.0   107.0 72 10 12   0 5     1   7   48 59     16 5   53 14   107
690817 690817 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   grade_2 46.0 35.0 11.0   2.0 8.0     0.0   5.0   51.0 56.0     17.0   3.0     75.0   11.0   107.0 46 35 11   2 8     0   5   51 56     17 3   75 11   107
691651 691651 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002436 597 LAKEVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 94.0 4.0 4.0   0.0 1.0     0.0   4.0   49.0 58.0     5.0   0.0     11.0   15.0   107.0 94 4 4   0 1     0   4   49 58     5 0   11 15   107
692407 692407 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001211 673 Weaver Lake Science, Math & Technology School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 48.0 26.0 4.0   0.0 22.0     0.0   7.0   49.0 58.0     5.0   0.0     34.0   12.0   107.0 48 26 4   0 22     0   7   49 58     5 0   34 12   107
694049 694049 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001594 494 CAPITOL HILL MAGNET/RONDO Elementary School (Grades PK-6) Regular School No Elementary 01 08 2017   grade_2 35.0 18.0 9.0   0.0 34.0     0.0   11.0   60.0 47.0     30.0   0.0     58.0   2.0   107.0 35 18 9   0 34     0   11   60 47     30 0   58 2   107
696436 696436 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001865 170 WINDOM SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 49.0 2.0 53.0   0.0 1.0     0.0   2.0   57.0 50.0     38.0   1.0     42.0   4.0   107.0 49 2 53   0 1     0   2   57 50     38 1   42 4   107
696975 696975 MN Ramsey 62 school 2700342 4103 Charter Schools HMONG COLLEGE PREP ACADEMY 270034203700 20 HMONG COLLEGE PREP MIDDLE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_2 0.0 0.0 0.0   0.0 107.0     0.0   0.0   57.0 50.0     61.0   0.0     93.0   9.0   107.0 0 0 0   0 107     0   0   57 50     61 0   93 9   107
690852 690852 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   grade_2 54.0 3.0 41.0   0.0 1.0     0.0   9.0   43.0 65.0     26.0   0.0     35.0   6.0   108.0 54 3 41   0 1     0   9   43 65     26 0   35 6   108
691336 691336 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 2017   grade_2 82.0 2.0 18.0   2.0 0.0     1.0   3.0   57.0 51.0     14.0   0.0     53.0   25.0   108.0 82 2 18   2 0     1   3   57 51     14 0   53 25   108
692291 692291 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 2017   grade_2 97.0 0.0 3.0   0.0 4.0     0.0   4.0   56.0 52.0     1.0   0.0     3.0   5.0   108.0 97 0 3   0 4     0   4   56 52     1 0   3 5   108
693166 693166 MN Morrison 49 school 2718240 482 Independent Districts and Schools LITTLE FALLS PUBLIC SCHOOL DISTRICT 271824000961 120 LINDBERGH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 94.0 1.0 6.0   0.0 4.0     0.0   3.0   57.0 51.0     5.0   2.0     54.0   17.0   108.0 94 1 6   0 4     0   3   57 51     5 2   54 17   108
693214 693214 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000149 10 BANFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   grade_2 55.0 10.0 28.0   0.0 12.0     2.0   1.0   52.0 56.0     28.0   0.0     61.0   11.0   108.0 55 10 28   0 12     2   1   52 56     28 0   61 11   108
693461 693461 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001010 150 SUNSET TERRACE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 62.0 23.0 3.0   1.0 13.0     0.0   6.0   53.0 55.0     15.0   *     44.0   17.0   108.0 62 23 3   1 13     0   6   53 55     15     44 17   108
694511 694511 MN Scott 70 school 2733000 720 Independent Districts and Schools SHAKOPEE PUBLIC SCHOOL DISTRICT 273300001441 860 SWEENEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 76.0 4.0 17.0   1.0 4.0     0.0   6.0   55.0 53.0     15.0   0.0     38.0   16.0   108.0 76 4 17   1 4     0   6   55 53     15 0   38 16   108
694742 694742 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351002285 51 OAK HILL COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 52.0 40.0 6.0   0.0 3.0     0.0   7.0   67.0 41.0     34.0   0.0     62.0   15.0   108.0 52 40 6   0 3     0   7   67 41     34 0   62 15   108
694990 694990 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000596 627 Forest View Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_2 87.0 3.0 7.0   0.0 2.0     0.0   9.0   60.0 48.0     7.0   0.0     37.0   16.0   108.0 87 3 7   0 2     0   9   60 48     7 0   37 16   108
693665 693665 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001128 34 SUNNYSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   grade_2 66.0 11.0 10.0   0.0 12.0     0.0   10.0   55.0 54.0         2.0     51.0   *   109.0 66 11 10   0 12     0   10   55 54       2   51     109
693928 693928 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001167 435 EXPO FOR EXCELLENCE ELEMENTARY SCH Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 61.0 24.0 6.0   0.0 7.0     1.0   10.0   57.0 52.0     18.0   1.0     42.0   13.0   109.0 61 24 6   0 7     1   10   57 52     18 1   42 13   109
694234 694234 MN Rice 66 school 2723880 659 Independent Districts and Schools NORTHFIELD PUBLIC SCHOOL DISTRICT 272388002841 7 BRIDGEWATER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 86.0 1.0 16.0   0.0 2.0     0.0   4.0   53.0 56.0     7.0   0.0     36.0   18.0   109.0 86 1 16   0 2     0   4   53 56     7 0   36 18   109
690894 690894 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   grade_2 0.0 0.0 0.0   11.0 0.0     0.0   0.0   3.0 8.0     0.0   0.0         1.0   11.0 0 0 0   11 0     0   0   3 8     0 0     1   11

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