enrollments

Data source: Big Local News · About: Big Local

976 rows where grade = "grade_5", state = "IN" and year = 2016 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 976 ✖

grade ✖

  • grade_5 · 976 ✖
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
1283004 1283004 IN     school 1812240 2285   Wa-Nee Community Schools 181224001958 1669 North Wood Middle School   Regular School No 2.0 05 09 2016   grade_5                         0.0 1.0                       1.0                         0 1                 1
1284513 1284513 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         0.0 1.0                       1.0                         0 1                 1
1283515 1283515 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2016   grade_5                         4.0 6.0                       10.0                         4 6                 10
1292899 1292899 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes 1.0 KG 06 2016   grade_5                         7.0 3.0                       10.0                         7 3                 10
1283198 1283198 IN     school 1803930 2315   Goshen Community Schools 180393000656 1633 Model Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         52.0 48.0                       100.0                         52 48                 100
1284381 1284381 IN     school 1808100 3295   North West Hendricks Schools 180810001386 2725 Pittsboro Elementary   Regular School No 1.0 03 05 2016   grade_5                         48.0 52.0                       100.0                         48 52                 100
1287090 1287090 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002349 5200 Mary Adams Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         53.0 47.0                       100.0                         53 47                 100
1287303 1287303 IN     school 1808820 5340   Perry Township Schools 180882001470 5351 Winchester Village Elementary   Regular School No 1.0 PK 05 2016   grade_5                         61.0 39.0                       100.0                         61 39                 100
1292909 1292909 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes 2.0 05 08 2016   grade_5                         47.0 53.0                       100.0                         47 53                 100
1281338 1281338 IN     school 1803630 235   Fort Wayne Community Schools 180363000540 270 Lincoln Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         52.0 49.0                       101.0                         52 49                 101
1286305 1286305 IN     school 1804320 4710   School City of Hammond 180432002236 4449 Thomas A Edison Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         47.0 54.0                       101.0                         47 54                 101
1287279 1287279 IN     school 1808820 5340   Perry Township Schools 180882001457 5338 Douglas MacArthur Elem School   Regular School No 1.0 PK 05 2016   grade_5                         53.0 48.0                       101.0                         53 48                 101
1288305 1288305 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elem/Middle School   Regular School No 1.0 KG 08 2016   grade_5                         51.0 50.0                       101.0                         51 50                 101
1282387 1282387 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001805 7211 Sunman Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         56.0 46.0                       102.0                         56 46                 102
1284419 1284419 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102002430 2714 Reagan Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         58.0 44.0                       102.0                         58 44                 102
1285468 1285468 IN     school 1807830 4315   North Knox School Corp 180783001335 3545 North Knox Intermediate   Regular School No 1.0 03 06 2016   grade_5                         47.0 55.0                       102.0                         47 55                 102
1286375 1286375 IN     school 1804320 4710   School City of Hammond 180432002237 4469 Morton Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         58.0 44.0                       102.0                         58 44                 102
1281103 1281103 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No 1.0 01 05 2016   grade_5                         48.0 55.0                       103.0                         48 55                 103
1284118 1284118 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         53.0 50.0                       103.0                         53 50                 103
1284563 1284563 IN     school 1808970 3330   Plainfield Community Sch Corp 180897001495 2761 Van Buren Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         54.0 49.0                       103.0                         54 49                 103
1284444 1284444 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001570 2727 Cardinal Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         49.0 55.0                       104.0                         49 55                 104
1287523 1287523 IN     school 1812720 5370   M S D Washington Township 181272002023 5430 Spring Mill Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         58.0 46.0                       104.0                         58 46                 104
1291188 1291188 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000483 8321 Stockwell Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         54.0 50.0                       104.0                         54 50                 104
1291704 1291704 IN     school 1812390 8130   Warrick County School Corp 181239001979 8813 Chandler Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         46.0 58.0                       104.0                         46 58                 104
1281195 1281195 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         59.0 46.0                       105.0                         59 46                 105
1281475 1281475 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         57.0 48.0                       105.0                         57 48                 105
1281502 1281502 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         52.0 53.0                       105.0                         52 53                 105
1281826 1281826 IN     school 1810680 815   Southeastern School Corp 181068001754 673 Galveston Elementary School   Regular School No 2.0 04 06 2016   grade_5                         54.0 51.0                       105.0                         54 51                 105
1285172 1285172 IN     school 1806120 3995   Madison Consolidated Schools 180612001088 3333 Emery O Muncie Elem School   Regular School No 1.0 PK 06 2016   grade_5                         47.0 58.0                       105.0                         47 58                 105
1287051 1287051 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No 1.0 01 06 2016   grade_5                         51.0 54.0                       105.0                         51 54                 105
1287097 1287097 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002222 5202 Arlington Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         53.0 52.0                       105.0                         53 52                 105
1287188 1287188 IN     school 1805670 5330   M S D Lawrence Township 180567002114 5295 Winding Ridge Elementary School   Regular School No 1.0 01 06 2016   grade_5                         46.0 59.0                       105.0                         46 59                 105
1287399 1287399 IN     school 1808910 5350   M S D Pike Township 180891001275 5378 New Augusta Pub Aca-South   Regular School No 1.0 KG 05 2016   grade_5                         48.0 57.0                       105.0                         48 57                 105
1290455 1290455 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No 2.0 05 08 2016   grade_5                         56.0 49.0                       105.0                         56 49                 105
1291278 1291278 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000489 8381 West Terrace Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         49.0 56.0                       105.0                         49 56                 105
1291486 1291486 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         60.0 45.0                       105.0                         60 45                 105
1291711 1291711 IN     school 1812390 8130   Warrick County School Corp 181239001984 8817 Newburgh Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         45.0 60.0                       105.0                         45 60                 105
1282220 1282220 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         56.0 50.0                       106.0                         56 50                 106
1284426 1284426 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001567 2718 Delaware Trail Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         59.0 47.0                       106.0                         59 47                 106
1286925 1286925 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2016   grade_5                         47.0 59.0                       106.0                         47 59                 106
1287335 1287335 IN     school 1808910 5350   M S D Pike Township 180891002374 5352 Deer Run Elementary   Regular School No 1.0 KG 05 2016   grade_5                         55.0 51.0                       106.0                         55 51                 106
1287376 1287376 IN     school 1808910 5350   M S D Pike Township 180891001485 5359 Eastbrook Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         55.0 51.0                       106.0                         55 51                 106
1287516 1287516 IN     school 1812720 5370   M S D Washington Township 181272002020 5427 Nora Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         55.0 51.0                       106.0                         55 51                 106
1287875 1287875 IN     school 1804770 5385   Indianapolis Public Schools 180477000904 5549 William Penn School 49   Regular School No 1.0 PK 06 2016   grade_5                         56.0 50.0                       106.0                         56 50                 106
1289376 1289376 IN     school 1809180 6520   Porter Township School Corp 180918001520 6837 Boone Grove Elementary School   Regular School No 2.0 04 05 2016   grade_5                         53.0 53.0                       106.0                         53 53                 106
1291748 1291748 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle School   Regular School No 2.0 05 08 2016   grade_5                         51.0 55.0                       106.0                         51 55                 106
1280999 1280999 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         52.0 55.0                       107.0                         52 55                 107
1284058 1284058 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         57.0 50.0                       107.0                         57 50                 107
1284141 1284141 IN     school 1807650 3070   Noblesville Schools 180765002546 2539 Promise Road Elementary   Regular School No 1.0 KG 05 2016   grade_5                         43.0 64.0                       107.0                         43 64                 107
1285247 1285247 IN     school 1805190 4015   Jennings County School Corporation 180519000924 3397 North Vernon Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         56.0 51.0                       107.0                         56 51                 107
1285978 1285978 IN     school 1802490 4660   Crown Point Community Sch Corp 180249000295 3773 Dwight D Eisenhower Elem School   Regular School No 1.0 PK 05 2016   grade_5                         57.0 50.0                       107.0                         57 50                 107
1286861 1286861 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002049 5009 Frankton Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         60.0 47.0                       107.0                         60 47                 107
1291929 1291929 IN     school 1808220 8435   Northern Wells Com Schools 180822001411 9081 Ossian Elementary   Regular School No 1.0 PK 05 2016   grade_5                         56.0 51.0                       107.0                         56 51                 107
1280874 1280874 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2016   grade_5                         44.0 64.0                       108.0                         44 64                 108
1282644 1282644 IN     school 1805880 1895   Liberty-Perry Com School Corp 180588001045 1381 Selma Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         55.0 53.0                       108.0                         55 53                 108
1290519 1290519 IN     school 1810140 7365   Shelbyville Central Schools 181014001633 7733 William F Loper Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         62.0 46.0                       108.0                         62 46                 108
1286879 1286879 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002052 5025 Lapel Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         47.0 62.0                       109.0                         47 62                 109
1288748 1288748 IN     school 1804140 5900   Monroe-Gregg School District 180414000715 6323 Monrovia Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         60.0 49.0                       109.0                         60 49                 109
1292374 1292374 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2016   grade_5                         58.0 51.0                       109.0                         58 51                 109
1291599 1291599 IN     school 1806080 8115   M S D Warren County 180608001072 8733 Pine Village Elementary Sch   Regular School No 1.0 KG 06 2016   grade_5                         6.0 5.0                       11.0                         6 5                 11
1292578 1292578 IN     school 1800129 9725   Canaan Community Academy 180012902534 3312 Canaan Community Academy   Regular School Yes 1.0 KG 06 2016   grade_5                         5.0 6.0                       11.0                         5 6                 11
1292843 1292843 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2016   grade_5                         9.0 2.0                       11.0                         9 2                 11
1281182 1281182 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         48.0 62.0                       110.0                         48 62                 110
1284185 1284185 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001407 2567 Sugar Creek Elementary Sch   Regular School No 1.0 KG 06 2016   grade_5                         60.0 50.0                       110.0                         60 50                 110
1285186 1285186 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080001766 3341 Southwestern Elementary Sch   Regular School No 1.0 PK 05 2016   grade_5                         60.0 50.0                       110.0                         60 50                 110
1287132 1287132 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No 1.0 01 06 2016   grade_5                         55.0 55.0                       110.0                         55 55                 110
1290511 1290511 IN     school 1810140 7365   Shelbyville Central Schools 181014001632 7729 Thomas A Hendricks Elementary Sch   Regular School No 1.0 PK 05 2016   grade_5                         58.0 52.0                       110.0                         58 52                 110
1281806 1281806 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         54.0 57.0                       111.0                         54 57                 111
1282574 1282574 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000225 1357 McKenney-Harrison Elementary Sch   Regular School No 1.0 KG 05 2016   grade_5                         66.0 45.0                       111.0                         66 45                 111
1283150 1283150 IN     school 1803270 2305   Elkhart Community Schools 180327000441 1785 Pinewood Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         67.0 44.0                       111.0                         67 44                 111
1284152 1284152 IN     school 1807650 3070   Noblesville Schools 180765001246 2547 White River Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         64.0 47.0                       111.0                         64 47                 111
1285911 1285911 IN     school 1811460 4645   Tri-Creek School Corporation 181146001853 3753 Oak Hill Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         58.0 53.0                       111.0                         58 53                 111
1287247 1287247 IN     school 1808820 5340   Perry Township Schools 180882002280 5322 Mary Bryan Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         58.0 53.0                       111.0                         58 53                 111
1290202 1290202 IN     school 1810290 7205   South Bend Community Sch Corp 181029002296 7521 Brown Intermediate Center   Regular School No 2.0 04 08 2016   grade_5                         47.0 64.0                       111.0                         47 64                 111
1287173 1287173 IN     school 1805670 5330   M S D Lawrence Township 180567002278 5293 Indian Creek Elementary School   Regular School No 1.0 01 06 2016   grade_5                         58.0 54.0                       112.0                         58 54                 112
1287195 1287195 IN     school 1805670 5330   M S D Lawrence Township 180567001033 5296 Oaklandon Elementary School   Regular School No 1.0 01 06 2016   grade_5                         60.0 52.0                       112.0                         60 52                 112
1287585 1287585 IN     school 1812810 5375   M S D Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         56.0 56.0                       112.0                         56 56                 112
1291575 1291575 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No 2.0 05 08 2016   grade_5                         60.0 52.0                       112.0                         60 52                 112
1284764 1284764 IN     school 1803150 3480   Eastern Howard School Corporation 180315000412 2909 Eastern Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         56.0 57.0                       113.0                         56 57                 113
1285010 1285010 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000182 3129 Brownstown Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         60.0 53.0                       113.0                         60 53                 113
1289074 1289074 IN     school 1808640 6155   Paoli Community School Corp 180864001439 6587 Throop Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         51.0 62.0                       113.0                         51 62                 113
1291398 1291398 IN     school 1812090 8030   Vigo County School Corp 181209001903 8511 Dixie Bee Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         52.0 61.0                       113.0                         52 61                 113
1283752 1283752 IN     school 1805910 2950   Linton-Stockton School Corp 180591001048 2441 Linton-Stockton Elementary   Regular School No 1.0 KG 05 2016   grade_5                         62.0 52.0                       114.0                         62 52                 114
1284408 1284408 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000045 2711 Eagle Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         57.0 57.0                       114.0                         57 57                 114
1286834 1286834 IN     school 1806900 5085   Mitchell Community Schools 180690001194 4861 Burris Elementary School   Regular School No 1.0 03 05 2016   grade_5                         53.0 61.0                       114.0                         53 61                 114
1287083 1287083 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002113 5198 Thompson Crossing Elementary Sch   Regular School No 1.0 KG 05 2016   grade_5                         53.0 61.0                       114.0                         53 61                 114
1287495 1287495 IN     school 1812720 5370   M S D Washington Township 181272002255 5406 Crooked Creek Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         64.0 50.0                       114.0                         64 50                 114
1291449 1291449 IN     school 1812090 8030   Vigo County School Corp 181209001909 8549 Lost Creek Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         62.0 52.0                       114.0                         62 52                 114
1287255 1287255 IN     school 1808820 5340   Perry Township Schools 180882001456 5325 Clinton Young Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         64.0 51.0                       115.0                         64 51                 115
1290907 1290907 IN     school 1811340 7865   Tippecanoe School Corp 181134001305 8021 Wea Ridge Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         66.0 49.0                       115.0                         66 49                 115
1291718 1291718 IN     school 1812390 8130   Warrick County School Corp 181239002179 8819 Sharon Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         59.0 56.0                       115.0                         59 56                 115
1282368 1282368 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001803 1189 North Dearborn Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         57.0 59.0                       116.0                         57 59                 116
1285060 1285060 IN     school 1809420 3815   Rensselaer Central School Corp 180942001545 3205 Van Rensselaer Elementary School   Regular School No 1.0 03 05 2016   grade_5                         62.0 55.0                       117.0                         62 55                 117
1286493 1286493 IN     school 1807350 4740   School Town of Munster 180735001254 4343 Frank H Hammond Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         60.0 57.0                       117.0                         60 57                 117
1287594 1287594 IN     school 1812810 5375   M S D Wayne Township 181281002035 5257 McClelland Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         57.0 60.0                       117.0                         57 60                 117
1284632 1284632 IN     school 1808280 3435   Shenandoah School Corporation 180828002356 2815 Shenandoah Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         61.0 57.0                       118.0                         61 57                 118
1285300 1285300 IN     school 1801440 4205   Center Grove Com Sch Corp 180144000208 3435 Center Grove Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         63.0 55.0                       118.0                         63 55                 118
1285335 1285335 IN     school 1801440 4205   Center Grove Com Sch Corp 180144002333 3444 Pleasant Grove Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         54.0 64.0                       118.0                         54 64                 118
1286969 1286969 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         70.0 48.0                       118.0                         70 48                 118
1284035 1284035 IN     school 1801200 3060   Carmel Clay Schools 180120000036 2512 Smoky Row Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         55.0 64.0                       119.0                         55 64                 119

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