enrollments

Data source: Big Local News · About: Big Local

1,041 rows where grade = "grade_3", state = "IN" and year = 2021 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,041 ✖

grade ✖

  • grade_3 · 1,041 ✖
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
1930040 1930040 IN     school 1800205 8690   Dynamic Minds Academy 180020502673 8692 Dynamic Minds Academy   Regular School Yes Other KG 12 2021   grade_3                         1.0 0.0                       1.0                         1 0                 1
1930142 1930142 IN     school 1800199 9065   Allegiant Preparatory Academy 180019902648 1002 Allegiant Preparatory Academy   Regular School Yes Elementary KG 03 2021   grade_3                         6.0 4.0                       10.0                         6 4                 10
1919420 1919420 IN     school 1803630 235   Fort Wayne Community Schools 180363000540 270 Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_3                         47.0 53.0                       100.0                         47 53                 100
1919581 1919581 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elementary School   Regular School No Elementary PK 06 2021   grade_3                         52.0 48.0                       100.0                         52 48                 100
1921244 1921244 IN     school 1803930 2315   Goshen Community Schools 180393000656 1633 Model Elementary School   Regular School No Elementary KG 05 2021   grade_3                         56.0 44.0                       100.0                         56 44                 100
1922783 1922783 IN     school 1811250 3460   Taylor Community School Corp 181125001812 2895 Taylor Elementary School   Regular School No Elementary PK 04 2021   grade_3                         57.0 43.0                       100.0                         57 43                 100
1923293 1923293 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000244 3401 Clark Elementary School   Regular School No Elementary KG 05 2021   grade_3                         51.0 49.0                       100.0                         51 49                 100
1923340 1923340 IN     school 1801440 4205   Center Grove Community School Corp 180144000662 3434 Sugar Grove Elementary School   Regular School No Elementary PK 05 2021   grade_3                         51.0 49.0                       100.0                         51 49                 100
1925001 1925001 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002222 5202 Arlington Elementary School   Regular School No Elementary KG 03 2021   grade_3                         47.0 53.0                       100.0                         47 53                 100
1925036 1925036 IN     school 1805670 5330   MSD Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2021   grade_3                         46.0 54.0                       100.0                         46 54                 100
1925093 1925093 IN     school 1805670 5330   MSD Lawrence Township 180567002114 5295 Winding Ridge Elementary School   Regular School No Elementary 01 06 2021   grade_3                         44.0 56.0                       100.0                         44 56                 100
1928319 1928319 IN     school 1808310 7350   Northwestern Con School Corp 180831001424 7691 Triton Central Elementary School   Regular School No Elementary PK 04 2021   grade_3                         57.0 43.0                       100.0                         57 43                 100
1929395 1929395 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No Elementary KG 05 2021   grade_3                         55.0 45.0                       100.0                         55 45                 100
1929616 1929616 IN     school 1812390 8130   Warrick County School Corp 181239001984 8817 Newburgh Elementary School   Regular School No Elementary KG 05 2021   grade_3                         49.0 51.0                       100.0                         49 51                 100
1930398 1930398 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes Elementary KG 05 2021   grade_3                         60.0 40.0                       100.0                         60 40                 100
1919775 1919775 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2021   grade_3                         50.0 51.0                       101.0                         50 51                 101
1922278 1922278 IN     school 1807260 3135   Mt Vernon Community School Corp 180726001220 2561 Mt Comfort Elementary School   Regular School No Elementary KG 05 2021   grade_3                         45.0 56.0                       101.0                         45 56                 101
1924277 1924277 IN     school 1804320 4710   School City of Hammond 180432000750 4453 Warren G Harding Elementary School   Regular School No Elementary PK 05 2021   grade_3                         52.0 49.0                       101.0                         52 49                 101
1925535 1925535 IN     school 1812810 5375   MSD Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No Elementary PK 06 2021   grade_3                         53.0 48.0                       101.0                         53 48                 101
1928778 1928778 IN     school 1811340 7865   Tippecanoe School Corp 181134001821 8024 Battle Ground Elementary School   Regular School No Elementary KG 05 2021   grade_3                         54.0 47.0                       101.0                         54 47                 101
1929648 1929648 IN     school 1803000 8215   East Washington School Corp 180300002195 8904 East Washington Elementary School   Regular School No Elementary PK 04 2021   grade_3                         52.0 49.0                       101.0                         52 49                 101
1921999 1921999 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2021   grade_3                         57.0 45.0                       102.0                         57 45                 102
1922048 1922048 IN     school 1801200 3060   Carmel Clay Schools 180120002332 2508 Cherry Tree Elementary School   Regular School No Elementary PK 05 2021   grade_3                         48.0 54.0                       102.0                         48 54                 102
1922421 1922421 IN     school 1808100 3295   North West Hendricks Schools 180810001386 2725 Pittsboro Elementary School   Regular School No Elementary 03 05 2021   grade_3                         53.0 49.0                       102.0                         53 49                 102
1922800 1922800 IN     school 1802040 3470   Northwestern School Corp 180204000254 2904 Northwestern Elementary School   Regular School No Elementary KG 06 2021   grade_3                         51.0 51.0                       102.0                         51 51                 102
1923016 1923016 IN     school 1810080 3675   Seymour Community Schools 181008001617 3135 Margaret R Brown Elementary School   Regular School No Elementary KG 05 2021   grade_3                         55.0 47.0                       102.0                         55 47                 102
1923034 1923034 IN     school 1810080 3675   Seymour Community Schools 181008001619 3153 Seymour-Jackson Elementary School   Regular School No Elementary PK 05 2021   grade_3                         50.0 52.0                       102.0                         50 52                 102
1925116 1925116 IN     school 1805670 5330   MSD Lawrence Township 180567001066 5299 Sunnyside Elementary School   Regular School No Elementary 01 06 2021   grade_3                         51.0 51.0                       102.0                         51 51                 102
1921009 1921009 IN     school 1802400 2270   Concord Community Schools 180240000274 1729 Concord West Side Elem School   Regular School No Elementary KG 04 2021   grade_3                         51.0 52.0                       103.0                         51 52                 103
1921399 1921399 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001268 1957 Grant Line Elementary School   Regular School No Elementary KG 04 2021   grade_3                         54.0 49.0                       103.0                         54 49                 103
1922097 1922097 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary School   Regular School No Elementary KG 05 2021   grade_3                         57.0 46.0                       103.0                         57 46                 103
1923098 1923098 IN     school 1805280 3785   Kankakee Valley School Corp 180528000935 3197 Wheatfield Elementary School   Regular School No Elementary KG 03 2021   grade_3                         57.0 46.0                       103.0                         57 46                 103
1923489 1923489 IN     school 1804110 4245   Greenwood Community Sch Corp 180411000712 3483 Southwest Elementary School   Regular School No Elementary KG 05 2021   grade_3                         52.0 51.0                       103.0                         52 51                 103
1924009 1924009 IN     school 1805460 4650   Lake Ridge New Tech Schools 180546000993 3885 Longfellow New Tech Elementary Sch   Regular School No Elementary KG 04 2021   grade_3                         56.0 47.0                       103.0                         56 47                 103
1925357 1925357 IN     school 1812360 5360   MSD Warren Township 181236001967 5377 Lowell Elementary School   Regular School No Elementary KG 04 2021   grade_3                         58.0 45.0                       103.0                         58 45                 103
1929067 1929067 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000470 8317 Hebron Elementary School   Regular School No Elementary PK 05 2021   grade_3                         54.0 49.0                       103.0                         54 49                 103
1919242 1919242 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2021   grade_3                         62.0 42.0                       104.0                         62 42                 104
1920997 1920997 IN     school 1802400 2270   Concord Community Schools 180240000272 1723 Concord Ox Bow Elementary School   Regular School No Elementary KG 04 2021   grade_3                         56.0 48.0                       104.0                         56 48                 104
1922155 1922155 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No Elementary PK 05 2021   grade_3                         53.0 51.0                       104.0                         53 51                 104
1923360 1923360 IN     school 1801440 4205   Center Grove Community School Corp 180144002677 3438 Walnut Grove Elementary School   Regular School No Elementary KG 05 2021   grade_3                         54.0 50.0                       104.0                         54 50                 104
1924056 1924056 IN     school 1802490 4660   Crown Point Community School Corp 180249000298 3905 Solon Robinson Elementary School   Regular School No Elementary KG 05 2021   grade_3                         48.0 56.0                       104.0                         48 56                 104
1924169 1924169 IN     school 1803870 4690   Gary Community School Corp 180387002102 4155 Glen Park Acad for Excel in Lrn   Regular School No Elementary KG 05 2021   grade_3                         60.0 44.0                       104.0                         60 44                 104
1924796 1924796 IN     school 1810440 5255   South Madison Com Sch Corp 181044002167 4935 East Elementary School   Regular School No Elementary KG 06 2021   grade_3                         52.0 52.0                       104.0                         52 52                 104
1924908 1924908 IN     school 1803300 5280   Elwood Community School Corp 180330002309 5151 Elwood Intermediate School   Regular School No Elementary 03 06 2021   grade_3                         52.0 52.0                       104.0                         52 52                 104
1925084 1925084 IN     school 1805670 5330   MSD Lawrence Township 180567000150 5294 Forest Glen Elementary School   Regular School No Elementary PK 06 2021   grade_3                         56.0 48.0                       104.0                         56 48                 104
1928145 1928145 IN     school 1810290 7205   South Bend Community School Corp 181029001658 7573 Madison S.T.E.A.M. Academy   Regular School No Elementary KG 05 2021   grade_3                         56.0 48.0                       104.0                         56 48                 104
1928750 1928750 IN     school 1811340 7865   Tippecanoe School Corp 181134001831 8009 Mintonye Elementary School   Regular School No Elementary KG 05 2021   grade_3                         51.0 53.0                       104.0                         51 53                 104
1919782 1919782 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary KG 04 2021   grade_3                         40.0 65.0                       105.0                         40 65                 105
1922687 1922687 IN     school 1808280 3435   Shenandoah School Corporation 180828002356 2815 Shenandoah Elementary School   Regular School No Elementary PK 05 2021   grade_3                         45.0 60.0                       105.0                         45 60                 105
1924836 1924836 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria Monroe Elementary Schoo   Regular School No Elementary PK 06 2021   grade_3                         65.0 40.0                       105.0                         65 40                 105
1925053 1925053 IN     school 1805670 5330   MSD Lawrence Township 180567001026 5285 Crestview Elementary School   Regular School No Elementary 01 06 2021   grade_3                         50.0 55.0                       105.0                         50 55                 105
1925266 1925266 IN     school 1808910 5350   MSD Pike Township 180891001484 5357 Central Elementary School   Regular School No Elementary KG 05 2021   grade_3                         54.0 51.0                       105.0                         54 51                 105
1925440 1925440 IN     school 1812720 5370   MSD Washington Township 181272002376 5436 Fox Hill Elementary School   Regular School No Elementary KG 05 2021   grade_3                         52.0 53.0                       105.0                         52 53                 105
1928868 1928868 IN     school 1811400 7945   Tipton Community School Corp 181140001844 8163 Tipton Elementary School   Regular School No Elementary PK 05 2021   grade_3                         51.0 54.0                       105.0                         51 54                 105
1921786 1921786 IN     school 1805910 2950   Linton-Stockton School Corporation 180591001048 2441 Linton-Stockton Elementary   Regular School No Elementary PK 05 2021   grade_3                         40.0 66.0                       106.0                         40 66                 106
1922601 1922601 IN     school 1808970 3330   Plainfield Community School Corp 180897001493 2751 Central Elementary School   Regular School No Elementary KG 05 2021   grade_3                         59.0 47.0                       106.0                         59 47                 106
1924821 1924821 IN     school 1810440 5255   South Madison Com Sch Corp 181044001676 5064 Maple Ridge Elementary School   Regular School No Elementary KG 06 2021   grade_3                         55.0 51.0                       106.0                         55 51                 106
1929487 1929487 IN     school 1812150 8060   Wabash City Schools 181215001937 8706 O J Neighbours Elementary School   Regular School No Elementary PK 04 2021   grade_3                         51.0 55.0                       106.0                         51 55                 106
1921197 1921197 IN     school 1803270 2305   Elkhart Community Schools 180327000441 1785 Pinewood Elementary School   Regular School No Elementary KG 06 2021   grade_3                         47.0 60.0                       107.0                         47 60                 107
1921826 1921826 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No Elementary PK 04 2021   grade_3                         51.0 56.0                       107.0                         51 56                 107
1922090 1922090 IN     school 1801200 3060   Carmel Clay Schools 180120000991 2515 Prairie Trace Elementary School   Regular School No Elementary KG 05 2021   grade_3                         59.0 48.0                       107.0                         59 48                 107
1924285 1924285 IN     school 1804320 4710   School City of Hammond 180432000751 4455 Washington Irving Elementary Sch   Regular School No Elementary PK 05 2021   grade_3                         53.0 54.0                       107.0                         53 54                 107
1924962 1924962 IN     school 1802640 5300   MSD Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2021   grade_3                         62.0 45.0                       107.0                         62 45                 107
1929609 1929609 IN     school 1812390 8130   Warrick County School Corp 181239001979 8813 Chandler Elementary School   Regular School No Elementary KG 05 2021   grade_3                         67.0 40.0                       107.0                         67 40                 107
1930892 1930892 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2021   grade_3                         54.0 53.0                       107.0                         54 53                 107
1919099 1919099 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   grade_3                         50.0 58.0                       108.0                         50 58                 108
1919113 1919113 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   grade_3                         51.0 57.0                       108.0                         51 57                 108
1920425 1920425 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001803 1189 North Dearborn Elementary School   Regular School No Elementary PK 05 2021   grade_3                         53.0 55.0                       108.0                         53 55                 108
1921851 1921851 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001560 2471 Hoosier Road Elementary School   Regular School No Elementary PK 04 2021   grade_3                         46.0 62.0                       108.0                         46 62                 108
1921985 1921985 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2021   grade_3                         58.0 50.0                       108.0                         58 50                 108
1922179 1922179 IN     school 1807650 3070   Noblesville Schools 180765002546 2539 Promise Road Elementary   Regular School No Elementary PK 05 2021   grade_3                         44.0 64.0                       108.0                         44 64                 108
1923389 1923389 IN     school 1801440 4205   Center Grove Community School Corp 180144002333 3444 Pleasant Grove Elementary School   Regular School No Elementary KG 05 2021   grade_3                         59.0 49.0                       108.0                         59 49                 108
1925493 1925493 IN     school 1812810 5375   MSD Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No Elementary PK 06 2021   grade_3                         57.0 51.0                       108.0                         57 51                 108
1925527 1925527 IN     school 1812810 5375   MSD Wayne Township 181281000238 5267 North Wayne Elementary School   Regular School No Elementary KG 06 2021   grade_3                         53.0 55.0                       108.0                         53 55                 108
1919272 1919272 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary School   Regular School No Elementary PK 05 2021   grade_3                         55.0 54.0                       109.0                         55 54                 109
1922104 1922104 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No Elementary PK 05 2021   grade_3                         54.0 55.0                       109.0                         54 55                 109
1924742 1924742 IN     school 1806900 5085   Mitchell Community Schools 180690001194 4861 Burris Elementary School   Regular School No Elementary 03 05 2021   grade_3                         61.0 48.0                       109.0                         61 48                 109
1925006 1925006 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000596 5205 Bunker Hill Elementary School   Regular School No Elementary KG 03 2021   grade_3                         55.0 54.0                       109.0                         55 54                 109
1925578 1925578 IN     school 1812810 5375   MSD Wayne Township 181281002123 5446 Bridgeport Elementary School   Regular School No Elementary KG 06 2021   grade_3                         60.0 49.0                       109.0                         60 49                 109
1926387 1926387 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000118 6173 Binford Elementary School   Regular School No Elementary 03 06 2021   grade_3                         62.0 47.0                       109.0                         62 47                 109
1928680 1928680 IN     school 1805400 7855   Lafayette School Corporation 180540000965 8091 Glen Acres Elementary School   Regular School No Elementary KG 04 2021   grade_3                         67.0 42.0                       109.0                         67 42                 109
1929356 1929356 IN     school 1812090 8030   Vigo County School Corp 181209001909 8549 Lost Creek Elementary School   Regular School No Elementary PK 05 2021   grade_3                         66.0 43.0                       109.0                         66 43                 109
1930442 1930442 IN     school 1800043 9465   Rural Community Schools Inc 180004302138 7951 Rural Community Academy   Regular School Yes Elementary KG 08 2021   grade_3                         6.0 5.0                       11.0                         6 5                 11
1921845 1921845 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002168 2470 Cumberland Road Elem School   Regular School No Elementary KG 04 2021   grade_3                         54.0 56.0                       110.0                         54 56                 110
1923223 1923223 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080001766 3341 Southwestern Elementary School   Regular School No Elementary PK 05 2021   grade_3                         59.0 51.0                       110.0                         59 51                 110
1924412 1924412 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No Elementary KG 06 2021   grade_3                         53.0 57.0                       110.0                         53 57                 110
1924949 1924949 IN     school 1802640 5300   MSD Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2021   grade_3                         57.0 53.0                       110.0                         57 53                 110
1925145 1925145 IN     school 1808820 5340   Perry Township Schools 180882001469 5321 William Henry Burkhart Elementary   Regular School No Elementary PK 05 2021   grade_3                         44.0 66.0                       110.0                         44 66                 110
1928743 1928743 IN     school 1811340 7865   Tippecanoe School Corp 181134001826 8007 Hershey Elementary School   Regular School No Elementary KG 05 2021   grade_3                         50.0 60.0                       110.0                         50 60                 110
1929303 1929303 IN     school 1812090 8030   Vigo County School Corp 181209001903 8511 Dixie Bee Elementary School   Regular School No Elementary KG 05 2021   grade_3                         60.0 50.0                       110.0                         60 50                 110
1921871 1921871 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000373 2475 Lantern Road Elementary School   Regular School No Elementary KG 04 2021   grade_3                         55.0 56.0                       111.0                         55 56                 111
1922082 1922082 IN     school 1801200 3060   Carmel Clay Schools 180120002267 2513 Orchard Park Elementary School   Regular School No Elementary PK 05 2021   grade_3                         56.0 55.0                       111.0                         56 55                 111
1922448 1922448 IN     school 1801020 3305   Brownsburg Community School Corp 180102000045 2711 Eagle Elementary School   Regular School No Elementary KG 05 2021   grade_3                         55.0 56.0                       111.0                         55 56                 111
1922557 1922557 IN     school 1800270 3315   Avon Community School Corp 180027001675 2740 Hickory Elementary School   Regular School No Elementary KG 04 2021   grade_3                         59.0 52.0                       111.0                         59 52                 111
1925363 1925363 IN     school 1812360 5360   MSD Warren Township 181236001969 5386 Pleasant Run Elementary School   Regular School No Elementary KG 04 2021   grade_3                         55.0 56.0                       111.0                         55 56                 111
1925375 1925375 IN     school 1812360 5360   MSD Warren Township 181236001959 5391 Brookview Elementary School   Regular School No Elementary KG 04 2021   grade_3                         53.0 58.0                       111.0                         53 58                 111
1928385 1928385 IN     school 1810140 7365   Shelbyville Central Schools 181014001633 7733 William F Loper Elementary School   Regular School No Elementary KG 05 2021   grade_3                         59.0 52.0                       111.0                         59 52                 111
1928946 1928946 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002627 8242 McCutchanville Elementary School   Regular School No Elementary PK 06 2021   grade_3                         61.0 50.0                       111.0                         61 50                 111
1929623 1929623 IN     school 1812390 8130   Warrick County School Corp 181239002179 8819 Sharon Elementary School   Regular School No Elementary KG 05 2021   grade_3                         58.0 53.0                       111.0                         58 53                 111
1922008 1922008 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2021   grade_3                         51.0 61.0                       112.0                         51 61                 112

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