enrollments

Data source: Big Local News · About: Big Local

1,031 rows where grade = "kindergarten", state = "IN" and year = 2018 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 1,031 ✖

grade ✖

  • kindergarten · 1,031 ✖
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
1794009 1794009 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1790211 1790211 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001750 2473 Fall Creek Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         48.0 52.0                       100.0                         48 52                 100
1791738 1791738 IN     school 1801440 4205   Center Grove Community School Corp 180144002333 3444 Pleasant Grove Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         53.0 47.0                       100.0                         53 47                 100
1792516 1792516 IN     school 1803870 4690   Gary Community School Corp 180387000615 4061 Beveridge Elementary School   Regular School No Elementary KG 06 2018   kindergarten                         62.0 38.0                       100.0                         62 38                 100
1793451 1793451 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002349 5200 Mary Adams Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         54.0 46.0                       100.0                         54 46                 100
1793806 1793806 IN     school 1812360 5360   M S D Warren Township 181236001966 5375 Lakeside Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         49.0 51.0                       100.0                         49 51                 100
1793860 1793860 IN     school 1812720 5370   M S D Washington Township 181272002255 5406 Crooked Creek Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         51.0 49.0                       100.0                         51 49                 100
1796568 1796568 IN     school 1810290 7205   South Bend Community School Corp 181029001646 7545 Harrison Elementary School   Regular School No Elementary PK 04 2018   kindergarten                         51.0 49.0                       100.0                         51 49                 100
1788776 1788776 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119000371 1193 Bright Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         52.0 49.0                       101.0                         52 49                 101
1790451 1790451 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         41.0 60.0                       101.0                         41 60                 101
1792461 1792461 IN     school 1802880 4670   School City of East Chicago 180288000375 3953 William McKinley Elementary School   Regular School No Elementary KG 06 2018   kindergarten                         55.0 46.0                       101.0                         55 46                 101
1796618 1796618 IN     school 1810290 7205   South Bend Community School Corp 181029001672 7577 Marquette Montessori Academy   Regular School No Elementary PK 03 2018   kindergarten                         51.0 50.0                       101.0                         51 50                 101
1788127 1788127 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2018   kindergarten                         38.0 64.0                       102.0                         38 64                 102
1788369 1788369 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2018   kindergarten                         53.0 49.0                       102.0                         53 49                 102
1789536 1789536 IN     school 1803270 2305   Elkhart Community Schools 180327000441 1785 Pinewood Elementary School   Regular School No Elementary KG 06 2018   kindergarten                         39.0 63.0                       102.0                         39 63                 102
1790574 1790574 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001407 2567 Sugar Creek Elementary Sch   Regular School No Elementary KG 06 2018   kindergarten                         62.0 40.0                       102.0                         62 40                 102
1790591 1790591 IN     school 1804050 3125   Greenfield-Central Com Schools 180405001665 2588 JB Stephens Elementary School   Regular School No Elementary PK 03 2018   kindergarten                         44.0 58.0                       102.0                         44 58                 102
1790836 1790836 IN     school 1801020 3305   Brownsburg Community School Corp 180102001570 2727 Cardinal Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         56.0 46.0                       102.0                         56 46                 102
1793969 1793969 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No Elementary PK 06 2018   kindergarten                         56.0 46.0                       102.0                         56 46                 102
1796384 1796384 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876000526 7383 Horizon Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         42.0 60.0                       102.0                         42 60                 102
1796586 1796586 IN     school 1810290 7205   South Bend Community School Corp 181029001663 7555 Kennedy Academy   Regular School No Elementary KG 04 2018   kindergarten                         47.0 55.0                       102.0                         47 55                 102
1787626 1787626 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         53.0 50.0                       103.0                         53 50                 103
1789743 1789743 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001270 1953 Greenville Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         51.0 52.0                       103.0                         51 52                 103
1797190 1797190 IN     school 1805400 7855   Lafayette School Corporation 180540000978 8117 Vinton Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         53.0 50.0                       103.0                         53 50                 103
1797862 1797862 IN     school 1806270 8045   Manchester Community Schools 180627001101 8633 Manchester Elementary School   Regular School No Elementary PK 03 2018   kindergarten                         55.0 48.0                       103.0                         55 48                 103
1798204 1798204 IN     school 1809510 8385   Richmond Community Schools 180951001553 9013 Charles Elementary School   Regular School No Elementary PK 04 2018   kindergarten                         55.0 48.0                       103.0                         55 48                 103
1787369 1787369 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   kindergarten                         57.0 47.0                       104.0                         57 47                 104
1788113 1788113 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No Elementary PK 04 2018   kindergarten                         47.0 57.0                       104.0                         47 57                 104
1791226 1791226 IN     school 1805370 3500   Kokomo School Corporation 180537000946 2961 Elwood Haynes Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         55.0 49.0                       104.0                         55 49                 104
1792407 1792407 IN     school 1802490 4660   Crown Point Community School Corp 180249000296 3903 Lake Street Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         44.0 60.0                       104.0                         44 60                 104
1793480 1793480 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000596 5205 Bunker Hill Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         54.0 50.0                       104.0                         54 50                 104
1796844 1796844 IN     school 1810140 7365   Shelbyville Central Schools 181014001627 7725 Coulston Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         58.0 46.0                       104.0                         58 46                 104
1788987 1788987 IN     school 1802660 1875   Delaware Community School Corp 180266000324 1365 Royerton Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         59.0 46.0                       105.0                         59 46                 105
1789328 1789328 IN     school 1802400 2270   Concord Community Schools 180240000270 1721 Concord East Side Elementary Sch   Regular School No Elementary KG 04 2018   kindergarten                         48.0 57.0                       105.0                         48 57                 105
1790395 1790395 IN     school 1801200 3060   Carmel Clay Schools 180120002332 2508 Cherry Tree Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         55.0 50.0                       105.0                         55 50                 105
1793881 1793881 IN     school 1812720 5370   M S D Washington Township 181272002020 5427 Nora Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         48.0 57.0                       105.0                         48 57                 105
1796399 1796399 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001148 7390 Northpoint Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         53.0 52.0                       105.0                         53 52                 105
1797196 1797196 IN     school 1805400 7855   Lafayette School Corporation 180540000545 8119 Amelia Earhart Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         51.0 54.0                       105.0                         51 54                 105
1787927 1787927 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elementary School   Regular School No Elementary KG 06 2018   kindergarten                         56.0 50.0                       106.0                         56 50                 106
1789232 1789232 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001236 1590 Huntingburg Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         53.0 53.0                       106.0                         53 53                 106
1793339 1793339 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         60.0 46.0                       106.0                         60 46                 106
1793818 1793818 IN     school 1812360 5360   M S D Warren Township 181236001969 5386 Pleasant Run Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         54.0 52.0                       106.0                         54 52                 106
1797160 1797160 IN     school 1805400 7855   Lafayette School Corporation 180540000965 8091 Glen Acres Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         69.0 37.0                       106.0                         69 37                 106
1797166 1797166 IN     school 1805400 7855   Lafayette School Corporation 180540000971 8103 Miami Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         50.0 56.0                       106.0                         50 56                 106
1797605 1797605 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000487 8365 Vogel Elementary School   Regular School No Elementary KG 06 2018   kindergarten                         58.0 48.0                       106.0                         58 48                 106
1798753 1798753 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2018   kindergarten                         48.0 58.0                       106.0                         48 58                 106
1790331 1790331 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2018   kindergarten                         59.0 48.0                       107.0                         59 48                 107
1790463 1790463 IN     school 1801200 3060   Carmel Clay Schools 180120001405 2522 Towne Meadow Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         62.0 45.0                       107.0                         62 45                 107
1790811 1790811 IN     school 1801020 3305   Brownsburg Community School Corp 180102002430 2714 Reagan Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         49.0 58.0                       107.0                         49 58                 107
1791022 1791022 IN     school 1808280 3435   Shenandoah School Corporation 180828002356 2815 Shenandoah Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         49.0 58.0                       107.0                         49 58                 107
1795549 1795549 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001282 6745 William Tell Elementary School   Regular School No Elementary KG 06 2018   kindergarten                         65.0 42.0                       107.0                         65 42                 107
1796306 1796306 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001454 7323 Walt Disney Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         49.0 58.0                       107.0                         49 58                 107
1787583 1787583 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         67.0 41.0                       108.0                         67 41                 108
1791797 1791797 IN     school 1803690 4225   Franklin Community School Corp 180369001030 3467 Creekside Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         51.0 57.0                       108.0                         51 57                 108
1793952 1793952 IN     school 1812810 5375   M S D Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No Elementary PK 06 2018   kindergarten                         57.0 51.0                       108.0                         57 51                 108
1797309 1797309 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         56.0 52.0                       108.0                         56 52                 108
1790511 1790511 IN     school 1807650 3070   Noblesville Schools 180765002414 2537 Noble Crossing Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         54.0 55.0                       109.0                         54 55                 109
1792309 1792309 IN     school 1805450 4615   Lake Central School Corporation 180545002143 4349 Homan Elementary School   Regular School No Elementary PK 04 2018   kindergarten                         70.0 39.0                       109.0                         70 39                 109
1793287 1793287 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2018   kindergarten                         62.0 47.0                       109.0                         62 47                 109
1794650 1794650 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elementary/Middle School   Regular School No Elementary KG 08 2018   kindergarten                         62.0 47.0                       109.0                         62 47                 109
1797172 1797172 IN     school 1805400 7855   Lafayette School Corporation 180540000976 8104 Thomas Miller Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         60.0 49.0                       109.0                         60 49                 109
1797224 1797224 IN     school 1811340 7865   Tippecanoe School Corp 181134001826 8007 Hershey Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         61.0 48.0                       109.0                         61 48                 109
1797259 1797259 IN     school 1811340 7865   Tippecanoe School Corp 181134001821 8024 Battle Ground Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         66.0 43.0                       109.0                         66 43                 109
1789912 1789912 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No Elementary KG 06 2018   kindergarten                         8.0 3.0                       11.0                         8 3                 11
1790470 1790470 IN     school 1801200 3060   Carmel Clay Schools 180120002185 2526 West Clay Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         52.0 58.0                       110.0                         52 58                 110
1791408 1791408 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000182 3129 Brownstown Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         56.0 54.0                       110.0                         56 54                 110
1793237 1793237 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002052 5025 Lapel Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         50.0 60.0                       110.0                         50 60                 110
1793271 1793271 IN     school 1810440 5255   South Madison Com Sch Corp 181044001676 5064 Maple Ridge Elementary School   Regular School No Elementary KG 06 2018   kindergarten                         53.0 57.0                       110.0                         53 57                 110
1797154 1797154 IN     school 1805400 7855   Lafayette School Corporation 180540000963 8089 Edgelea Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         54.0 56.0                       110.0                         54 56                 110
1787320 1787320 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2018   kindergarten                         65.0 46.0                       111.0                         65 46                 111
1790519 1790519 IN     school 1807650 3070   Noblesville Schools 180765002340 2538 Hazel Dell Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         61.0 50.0                       111.0                         61 50                 111
1790205 1790205 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001560 2471 Hoosier Road Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         56.0 56.0                       112.0                         56 56                 112
1799263 1799263 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2018   kindergarten                         44.0 68.0                       112.0                         44 68                 112
1790410 1790410 IN     school 1801200 3060   Carmel Clay Schools 180120000196 2510 College Wood Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         61.0 52.0                       113.0                         61 52                 113
1791075 1791075 IN     school 1807440 3445   New Castle Community School Corp 180744001289 2853 Sunnyside Elementary School   Regular School No Elementary KG 06 2018   kindergarten                         63.0 50.0                       113.0                         63 50                 113
1791723 1791723 IN     school 1801440 4205   Center Grove Community School Corp 180144000211 3440 North Grove Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         61.0 52.0                       113.0                         61 52                 113
1793332 1793332 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         64.0 49.0                       113.0                         64 49                 113
1793346 1793346 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         57.0 56.0                       113.0                         57 56                 113
1793701 1793701 IN     school 1808910 5350   M S D Pike Township 180891002374 5352 Deer Run Elementary   Regular School No Elementary KG 05 2018   kindergarten                         65.0 48.0                       113.0                         65 48                 113
1794017 1794017 IN     school 1812810 5375   M S D Wayne Township 181281002042 5273 Westlake Elementary School   Regular School No Elementary KG 06 2018   kindergarten                         60.0 53.0                       113.0                         60 53                 113
1787590 1787590 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         61.0 53.0                       114.0                         61 53                 114
1790198 1790198 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002168 2470 Cumberland Road Elem School   Regular School No Elementary PK 04 2018   kindergarten                         54.0 60.0                       114.0                         54 60                 114
1790503 1790503 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         67.0 47.0                       114.0                         67 47                 114
1793262 1793262 IN     school 1810440 5255   South Madison Com Sch Corp 181044001713 5061 Pendleton Elementary School   Regular School No Elementary PK 06 2018   kindergarten                         61.0 53.0                       114.0                         61 53                 114
1793935 1793935 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No Elementary PK 06 2018   kindergarten                         54.0 60.0                       114.0                         54 60                 114
1788764 1788764 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001803 1189 North Dearborn Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         54.0 61.0                       115.0                         54 61                 115
1790241 1790241 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002061 2482 Sand Creek Elementary   Regular School No Elementary PK 04 2018   kindergarten                         61.0 54.0                       115.0                         61 54                 115
1791689 1791689 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189002411 3430 Pleasant Crossing Elementary   Regular School No Elementary KG 05 2018   kindergarten                         67.0 48.0                       115.0                         67 48                 115
1793195 1793195 IN     school 1806900 5085   Mitchell Community Schools 180690001196 4863 Hatfield Elementary School   Regular School No Elementary PK 02 2018   kindergarten                         61.0 54.0                       115.0                         61 54                 115
1797245 1797245 IN     school 1811340 7865   Tippecanoe School Corp 181134001304 8019 Burnett Creek Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         60.0 55.0                       115.0                         60 55                 115
1787420 1787420 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         72.0 44.0                       116.0                         72 44                 116
1789705 1789705 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001267 1929 Georgetown Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         69.0 47.0                       116.0                         69 47                 116
1792237 1792237 IN     school 1809690 4600   Merrillville Community School Corp 180969001583 3822 Homer Iddings Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         63.0 53.0                       116.0                         63 53                 116
1793550 1793550 IN     school 1805670 5330   M S D Lawrence Township 180567000150 5294 Forest Glen Elementary School   Regular School No Elementary KG 06 2018   kindergarten                         61.0 55.0                       116.0                         61 55                 116
1793728 1793728 IN     school 1808910 5350   M S D Pike Township 180891001484 5357 Central Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         61.0 55.0                       116.0                         61 55                 116
1798057 1798057 IN     school 1812390 8130   Warrick County School Corp 181239001984 8817 Newburgh Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         61.0 55.0                       116.0                         61 55                 116
1790141 1790141 IN     school 1805910 2950   Linton-Stockton School Corporation 180591001048 2441 Linton-Stockton Elementary   Regular School No Elementary KG 05 2018   kindergarten                         43.0 74.0                       117.0                         43 74                 117
1790539 1790539 IN     school 1807650 3070   Noblesville Schools 180765001246 2547 White River Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         53.0 64.0                       117.0                         53 64                 117
1790785 1790785 IN     school 1801020 3305   Brownsburg Community School Corp 180102000994 2706 Brown Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         60.0 57.0                       117.0                         60 57                 117
1790887 1790887 IN     school 1800270 3315   Avon Community School Corp 180027002194 2738 Cedar Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         66.0 51.0                       117.0                         66 51                 117

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