enrollments

Data source: Big Local News · About: Big Local

12,044 rows where state = "IN" and year = 2015 sorted by male

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2015 · 11,944 ✖
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
1163105 1163105 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         1.0 1.0                       2.0                         1 1                 2
1163107 1163107 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         1.0 0.0                       1.0                         1 0                 1
1163206 1163206 IN     school 1810380 3415   South Henry School Corp 181038001702 2773 Tri Junior-Senior High School   Regular School No 3.0 07 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1163253 1163253 IN     school 1807440 3445   New Castle Community Sch Corp 180744002156 2832 Eastwood Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         1.0 3.0                       4.0                         1 3                 4
1163376 1163376 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   grade_6                         1.0 2.0                       3.0                         1 2                 3
1163658 1163658 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No 1.0 PK 05 2015   grade_3                         1.0 0.0                       1.0                         1 0                 1
1163659 1163659 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No 1.0 PK 05 2015   grade_4                         1.0 1.0                       2.0                         1 1                 2
1163660 1163660 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No 1.0 PK 05 2015   grade_5                         1.0 1.0                       2.0                         1 1                 2
1164280 1164280 IN     school 1809300 4515   Prairie Heights Com Sch Corp 180930001524 3686 Prairie Heights Elem Sch   Regular School No 1.0 PK 04 2015   pre_kindergarten                         1.0 1.0                       2.0                         1 1                 2
1164353 1164353 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_10                         1.0 1.0                       2.0                         1 1                 2
1164354 1164354 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_11                         1.0 1.0                       2.0                         1 1                 2
1164389 1164389 IN     school 1804620 4590   River Forest Community Sch Corp 180462000781 3791 River Forest Jr-Sr High School   Regular School No 4.0 06 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1164393 1164393 IN     school 1804620 4590   River Forest Community Sch Corp 180462000781 3791 River Forest Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_6                         1.0 0.0                       1.0                         1 0                 1
1164402 1164402 IN     school 1804620 4590   River Forest Community Sch Corp 180462000778 3797 Henry S Evans Elementary Sch   Regular School No 1.0 KG 06 2015   grade_5                         1.0 0.0                       1.0                         1 0                 1
1164414 1164414 IN     school 1804620 4590   River Forest Community Sch Corp 180462000779 3805 John I Meister Elementary School   Regular School No 1.0 KG 06 2015   grade_6                         1.0 0.0                       1.0                         1 0                 1
1164634 1164634 IN     school 1802880 4670   School City of East Chicago 180288002272 3924 East Chicago Central High Sch   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1164853 1164853 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No 4.0 06 12 2015   adult                         1.0 2.0                       3.0                         1 2                 3
1164877 1164877 IN     school 1804320 4710   School City of Hammond 180432000746 4417 Morton Senior High School   Regular School No 3.0 09 12 2015   adult                         1.0 2.0                       3.0                         1 2                 3
1165020 1165020 IN     school 1804560 4720   School Town of Highland 180456000767 4290 Mildred Merkley Elem School   Regular School No 1.0 KG 06 2015   grade_6                         1.0 1.0                       2.0                         1 1                 2
1165054 1165054 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1165068 1165068 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1165534 1165534 IN     school 1800120 5265   Alexandria Com School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No 1.0 PK 03 2015   grade_3                         1.0 1.0                       2.0                         1 1                 2
1165537 1165537 IN     school 1800120 5265   Alexandria Com School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No 1.0 PK 03 2015   pre_kindergarten                         1.0 1.0                       2.0                         1 1                 2
1165608 1165608 IN     school 1802640 5300   M S D Decatur Township 180264000312 5177 Decatur Central High School   Regular School No 3.0 09 12 2015   adult                         1.0 2.0                       3.0                         1 2                 3
1165816 1165816 IN     school 1808820 5340   Perry Township Schools 180882001464 5307 Perry Meridian High School   Regular School No 3.0 09 12 2015   adult                         1.0 2.0                       3.0                         1 2                 3
1165860 1165860 IN     school 1808820 5340   Perry Township Schools 180882001456 5325 Clinton Young Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         1.0 1.0                       2.0                         1 1                 2
1165868 1165868 IN     school 1808820 5340   Perry Township Schools 180882001459 5333 Glenns Valley Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1165920 1165920 IN     school 1808820 5340   Perry Township Schools 180882001809 5372 Rosa Parks-Edison Elem   Regular School No 1.0 PK 05 2015   pre_kindergarten                         1.0 1.0                       2.0                         1 1                 2
1165977 1165977 IN     school 1808910 5350   M S D Pike Township 180891001485 5359 Eastbrook Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1166319 1166319 IN     school 1804770 5385   Indianapolis Public Schools 180477002238 5485 Shortridge Law & Public Plcy Mg HS   Regular School No 3.0 09 12 2015   adult                         1.0 3.0                       4.0                         1 3                 4
1166620 1166620 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George W Carver School 87   Regular School No 1.0 PK 08 2015   grade_7                         1.0 6.0                       7.0                         1 6                 7
1166896 1166896 IN     school 1800900 5480   Bremen Public Schools 180090000168 5941 Bremen Senior High School   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1167039 1167039 IN     school 1808340 5625   Oak Hill United School Corp 180834001429 6069 Oak Hill High School   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1167060 1167060 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No 2.0 04 09 2015   grade_5                         1.0 0.0                       1.0                         1 0                 1
1167061 1167061 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No 2.0 04 09 2015   grade_6                         1.0 0.0                       1.0                         1 0                 1
1167610 1167610 IN     school 1802970 6060   East Noble School Corp 180297000394 6485 Wayne Center Elem Sch   Regular School No 1.0 PK 07 2015   grade_7                         1.0 1.0                       2.0                         1 1                 2
1167614 1167614 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No 3.0 09 12 2015   adult                         1.0 3.0                       4.0                         1 3                 4
1168263 1168263 IN     school 1810500 6705   South Putnam Community Schools 181050001726 7071 South Putnam High School   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1168296 1168296 IN     school   6720   Old National Trail Spec Serv Coop   7034 Old Nat'l Trail Sp Srvs             2015   grade_11                         1.0 4.0                       5.0                         1 4                 5
1168300 1168300 IN     school 1802220 6750   Cloverdale Community Schools 180222000265 7077 Cloverdale High School   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1168549 1168549 IN     school 1809120 7150   John Glenn School Corporation 180912001505 7453 John Glenn High School   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1168687 1168687 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_3                         1.0 0.0                       1.0                         1 0                 1
1168689 1168689 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_5                         1.0 0.0                       1.0                         1 0                 1
1168938 1168938 IN     school 1810290 7205   South Bend Community Sch Corp 181029002574 7617 Studebaker Center   Regular School No 4.0 PK 12 2015   grade_10                         1.0 0.0                       1.0                         1 0                 1
1168939 1168939 IN     school 1810290 7205   South Bend Community Sch Corp 181029002574 7617 Studebaker Center   Regular School No 4.0 PK 12 2015   grade_11                         1.0 1.0                       2.0                         1 1                 2
1168952 1168952 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   grade_7                         1.0 0.0                       1.0                         1 0                 1
1168953 1168953 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   grade_8                         1.0 0.0                       1.0                         1 0                 1
1168954 1168954 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   grade_9                         1.0 0.0                       1.0                         1 0                 1
1169075 1169075 IN     school 1810830 7360   Southwestern Con Sch Shelby Co 181083001769 7701 Southwestern High School   Regular School No 3.0 07 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1169091 1169091 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_1                         1.0 0.0                       1.0                         1 0                 1
1169101 1169101 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_8                         1.0 0.0                       1.0                         1 0                 1
1169102 1169102 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_9                         1.0 2.0                       3.0                         1 2                 3
1169215 1169215 IN     school 1808460 7495   Oregon-Davis School Corp 180846001435 7831 Oregon-Davis Jr-Sr High School   Regular School No 3.0 07 12 2015   adult                         1.0 2.0                       3.0                         1 2                 3
1169223 1169223 IN     school 1807800 7515   North Judson-San Pierre Sch Corp 180780001330 7849 North Judson-San Pierre High Sch   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1169289 1169289 IN     school 1811100 7615   M S D Steuben County 181110001797 7893 Angola High School   Regular School No 3.0 09 12 2015   adult                         1.0 1.0                       2.0                         1 1                 2
1169729 1169729 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 KG 12 2015   grade_2                         1.0 2.0                       3.0                         1 2                 3
1169737 1169737 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 KG 12 2015   kindergarten                         1.0 1.0                       2.0                         1 1                 2
1169913 1169913 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001735 8409 Central Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1170112 1170112 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative Education School No 3.0 09 12 2015   grade_11                         1.0 13.0                       14.0                         1 13                 14
1170115 1170115 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative Education School No 3.0 09 12 2015   pk_12_total 31.0 2.0 1.0 1.0             1.0   1.0 35.0     0.0             8.0   36.0 31 2 1 1             1   1 35     0       8   36
1170164 1170164 IN     school 1812180 8050   M S D Wabash County Schools 181218002178 8657 Sharp Creek Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         1.0 0.0                       1.0                         1 0                 1
1170168 1170168 IN     school 1812180 8050   M S D Wabash County Schools 181218002178 8657 Sharp Creek Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1170602 1170602 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No 3.0 07 12 2015   adult                         1.0 2.0                       3.0                         1 2                 3
1170743 1170743 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Fac   Regular School No 3.0 07 12 2015   grade_12                         1.0 0.0                       1.0                         1 0                 1
1170744 1170744 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Fac   Regular School No 3.0 07 12 2015   grade_7                         1.0 0.0                       1.0                         1 0                 1
1170967 1170967 IN     school 1800031 9480   University Heights Preparatory Acd 180003102223 5864 University Heights Preparatory Acd   Regular School Yes 4.0 06 12 2015   grade_6                         1.0 3.0                       4.0                         1 3                 4
1171128 1171128 IN     school 1800059 9655   Hope Academy 180005902386 5292 Hope Academy   Regular School Yes 3.0 09 12 2015   grade_10                         1.0 5.0                       6.0                         1 5                 6
1171131 1171131 IN     school 1800059 9655   Hope Academy 180005902386 5292 Hope Academy   Regular School Yes 3.0 09 12 2015   grade_9                         1.0 0.0                       1.0                         1 0                 1
1171216 1171216 IN     school 1800113 9730   Neighbors' New Vistas High School 180011302544 6864 Neighbors' New Vistas High School   Regular School Yes 3.0 09 12 2015   grade_10                         1.0 7.0                       8.0                         1 7                 8
1171233 1171233 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes 1.0 KG 08 2015   grade_5                         1.0 4.0                       5.0                         1 4                 5
1171234 1171234 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes 1.0 KG 08 2015   grade_6                         1.0 3.0                       4.0                         1 3                 4
1171336 1171336 IN     school 1800075 9830   Beacon Academy 180007502428 8411 Beacon Academy   Regular School Yes 3.0 08 12 2015   grade_8                         1.0 2.0                       3.0                         1 2                 3
1160074 1160074 IN     school 1800360 365   Bartholomew Con School Corp 180036000075 353 Mount Healthy Elementary Sch   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1160678 1160678 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_11                         10.0 1.0                       11.0                         10 1                 11
1160683 1160683 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_7                         10.0 0.0                       10.0                         10 0                 10
1160836 1160836 IN     school 1802440 1300   Crawford Co Com School Corp 180244000281 1037 Leavenworth Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         10.0 21.0                       31.0                         10 21                 31
1160856 1160856 IN     school 1802440 1300   Crawford Co Com School Corp 180244000280 1057 English School   Regular School No 1.0 PK 06 2015   grade_3                         10.0 5.0                       15.0                         10 5                 15
1160860 1160860 IN     school 1802440 1300   Crawford Co Com School Corp 180244000280 1057 English School   Regular School No 1.0 PK 06 2015   kindergarten                         10.0 10.0                       20.0                         10 10                 20
1160873 1160873 IN     school 1802440 1300   Crawford Co Com School Corp 180244000282 1061 Marengo Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         10.0 12.0                       22.0                         10 12                 22
1160884 1160884 IN     school 1802440 1300   Crawford Co Com School Corp 180244000283 1065 Milltown School   Regular School No 1.0 PK 06 2015   grade_5                         10.0 16.0                       26.0                         10 16                 26
1160933 1160933 IN     school 1812450 1405   Washington Com Schools 181245002005 1105 Veale Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         10.0 14.0                       24.0                         10 14                 24
1161335 1161335 IN     school 1807320 1970   Muncie Community Schools 180732001239 1494 Mitchell Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         10.0 23.0                       33.0                         10 23                 33
1162105 1162105 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2015   grade_5                         10.0 14.0                       24.0                         10 14                 24
1162368 1162368 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         10.0 17.0                       27.0                         10 17                 27
1162718 1162718 IN     school 1807650 3070   Noblesville Schools 180765002414 2537 Noble Crossing Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         10.0 3.0                       13.0                         10 3                 13
1162931 1162931 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elem School   Regular School No 1.0 PK 06 2015   grade_5                         10.0 15.0                       25.0                         10 15                 25
1162932 1162932 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elem School   Regular School No 1.0 PK 06 2015   grade_6                         10.0 14.0                       24.0                         10 14                 24
1163529 1163529 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No 4.0 06 12 2015   grade_10                         10.0 13.0                       23.0                         10 13                 23
1163548 1163548 IN     school 1810080 3675   Seymour Community Schools 181008001615 3105 Cortland Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         10.0 6.0                       16.0                         10 6                 16
1163549 1163549 IN     school 1810080 3675   Seymour Community Schools 181008001615 3105 Cortland Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         10.0 13.0                       23.0                         10 13                 23
1163685 1163685 IN     school 1804980 3945   Jay School Corp 180498000917 3247 Redkey Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         10.0 13.0                       23.0                         10 13                 23
1163693 1163693 IN     school 1804980 3945   Jay School Corp 180498000916 3257 Pennville Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         10.0 8.0                       18.0                         10 8                 18
1163770 1163770 IN     school 1806120 3995   Madison Consolidated Schools 180612001088 3333 Emery O Muncie Elem School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         10.0 12.0                       22.0                         10 12                 22
1164185 1164185 IN     school 1812420 4415   Warsaw Community Schools 181242001993 3613 Leesburg Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1164256 1164256 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         10.0 2.0                       12.0                         10 2                 12
1164718 1164718 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No 1.0 01 06 2015   grade_6                         10.0 14.0                       24.0                         10 14                 24
1164746 1164746 IN     school 1803870 4690   Gary Community School Corp 180387000617 4081 Dr Bernard C Watson Acad for Boys   Regular School No 1.0 KG 06 2015   kindergarten                         10.0 0.0                       10.0                         10 0                 10
1165179 1165179 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No 1.0 KG 08 2015   kindergarten                         10.0 16.0                       26.0                         10 16                 26
1165233 1165233 IN     school 1806570 4925   Michigan City Area Schools 180657001150 4821 Joy Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1165358 1165358 IN     school 1807860 5075   North Lawrence Com Schools 180786001339 4857 Fayetteville Elementary Sch   Regular School No 1.0 KG 05 2015   kindergarten                         10.0 20.0                       30.0                         10 20                 30

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