enrollments

Data source: Big Local News · About: Big Local

11,992 rows where state = "IN" and year = 2019 sorted by male

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2019 · 11,892 ✖
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
1755714 1755714 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No Elementary PK 05 2019   grade_5                         1.0 0.0                       1.0                         1 0                 1
1755777 1755777 IN     school 1806120 3995   Madison Consolidated Schools 180612001090 3309 Madison Consolidated High School   Regular School No High 08 12 2019   grade_8                         1.0 0.0                       1.0                         1 0                 1
1755805 1755805 IN     school 1806120 3995   Madison Consolidated Schools 180612001088 3333 Emery O Muncie Elementary School   Regular School No Elementary KG 05 2019   grade_5                         1.0 0.0                       1.0                         1 0                 1
1755889 1755889 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000246 3421 Whiteland Community High School   Regular School No High 09 12 2019   adult                         1.0 2.0                       3.0                         1 2                 3
1755978 1755978 IN     school 1803240 4215   Edinburgh Community School Corp 180324000422 3447 Edinburgh Community High School   Regular School No High 09 12 2019   adult                         1.0 0.0                       1.0                         1 0                 1
1756578 1756578 IN     school 1811460 4645   Tri-Creek School Corporation 181146001852 3865 Lowell Senior High School   Regular School No High 09 12 2019   adult                         1.0 0.0                       1.0                         1 0                 1
1756584 1756584 IN     school 1805460 4650   Lake Ridge New Tech Schools 180546000989 3869 Calumet New Tech High School   Regular School No High 09 12 2019   adult                         1.0 0.0                       1.0                         1 0                 1
1757030 1757030 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No Elementary KG 06 2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1757481 1757481 IN     school 1810440 5255   South Madison Com Sch Corp 181044001676 5064 Maple Ridge Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1758219 1758219 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1758752 1758752 IN     school 1810920 5400   School Town of Speedway 181092001785 5891 Speedway Senior High School   Regular School No High 09 12 2019   adult                         1.0 1.0                       2.0                         1 1                 2
1758816 1758816 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 07 12 2019   adult                         1.0 0.0                       1.0                         1 0                 1
1758893 1758893 IN     school 1810170 5520   Shoals Community School Corp 181017001635 5985 Shoals Community High School   Regular School No High 09 12 2019   adult                         1.0 0.0                       1.0                         1 0                 1
1758922 1758922 IN     school 1806060 5525   Loogootee Community Sch Corp 180606001067 6003 Loogootee High School   Regular School No High 09 12 2019   adult                         1.0 1.0                       2.0                         1 1                 2
1758967 1758967 IN     school 1808340 5625   Oak Hill United School Corp 180834001431 2306 Swayzee Elementary School   Regular School No Middle 05 07 2019   grade_7                         1.0 1.0                       2.0                         1 1                 2
1758981 1758981 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No Elementary KG 04 2019   grade_2                         1.0 0.0                       1.0                         1 0                 1
1758984 1758984 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1759003 1759003 IN     school 1808850 5635   Peru Community Schools 180885001471 6093 Blair Pointe Upper Elementary   Regular School No Elementary KG 06 2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1759220 1759220 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001714 6233 Ladoga Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1759307 1759307 IN     school 1806510 5925   M S D Martinsville Schools 180651001132 6309 Green Township Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1759314 1759314 IN     school 1806510 5925   M S D Martinsville Schools 180651002600 6332 John R. Wooden Middle School   Regular School No Middle 06 08 2019   grade_6                         1.0 0.0                       1.0                         1 0                 1
1759334 1759334 IN     school 1806510 5925   M S D Martinsville Schools 180651001129 6341 Centerton Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1759493 1759493 IN     school 1802970 6060   East Noble School Corporation 180297000389 6458 East Noble High School   Regular School No High 08 12 2019   grade_8                         1.0 1.0                       2.0                         1 1                 2
1759689 1759689 IN     school 1801740 6325   Perry Central Com Schools Corp 180174000234 6708 Perry Central Jr-Sr High School   Regular School No High 07 12 2019   adult                         1.0 3.0                       4.0                         1 3                 4
1759904 1759904 IN     school 1811700 6530   Union Township School Corp 181170001873 6841 Wheeler High School   Regular School No High 09 12 2019   adult                         1.0 0.0                       1.0                         1 0                 1
1760101 1760101 IN     school 1807950 6600   M S D North Posey Co Schools 180795001366 6975 North Posey High School   Regular School No High 09 12 2019   adult                         1.0 0.0                       1.0                         1 0                 1
1760223 1760223 IN     school 1803990 6755   Greencastle Community School Corp 180399000690 7089 Greencastle Senior High School   Regular School No High 09 12 2019   adult                         1.0 0.0                       1.0                         1 0                 1
1760232 1760232 IN     school 1803990 6755   Greencastle Community School Corp 180399000689 7093 Greencastle Middle School   Regular School No Middle 06 09 2019   grade_9                         1.0 0.0                       1.0                         1 0                 1
1760289 1760289 IN     school 1810740 6805   Randolph Southern School Corp 181074001763 7121 Randolph Southern Jr-Sr High Sch   Regular School No High 07 12 2019   adult                         1.0 0.0                       1.0                         1 0                 1
1760367 1760367 IN     school 1810530 6865   South Ripley Com Sch Corp 181053001729 7182 South Ripley High School   Regular School No High 09 12 2019   adult                         1.0 0.0                       1.0                         1 0                 1
1760458 1760458 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High School   Regular School No High 09 12 2019   adult                         1.0 1.0                       2.0                         1 1                 2
1760470 1760470 IN     school 1809120 7150   John Glenn School Corporation 180912001505 7453 John Glenn High School   Regular School No High 09 12 2019   adult                         1.0 0.0                       1.0                         1 0                 1
1760614 1760614 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 04 12 2019   grade_4                         1.0 0.0                       1.0                         1 0                 1
1760615 1760615 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 04 12 2019   grade_6                         1.0 0.0                       1.0                         1 0                 1
1760861 1760861 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2019   grade_12                         1.0 2.0                       3.0                         1 2                 3
1760862 1760862 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2019   grade_7                         1.0 1.0                       2.0                         1 1                 2
1760864 1760864 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2019   grade_9                         1.0 2.0                       3.0                         1 2                 3
1760969 1760969 IN     school 1808310 7350   Northwestern Con School Corp 180831001423 7689 Triton Central High School   Regular School No High 09 12 2019   adult                         1.0 0.0                       1.0                         1 0                 1
1761003 1761003 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other PK 12 2019   grade_1                         1.0 2.0                       3.0                         1 2                 3
1761004 1761004 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other PK 12 2019   grade_10                         1.0 3.0                       4.0                         1 3                 4
1761005 1761005 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other PK 12 2019   grade_11                         1.0 3.0                       4.0                         1 3                 4
1761008 1761008 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other PK 12 2019   grade_3                         1.0 0.0                       1.0                         1 0                 1
1761013 1761013 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other PK 12 2019   kindergarten                         1.0 1.0                       2.0                         1 1                 2
1761134 1761134 IN     school 1807800 7515   North Judson-San Pierre Sch Corp 180780001330 7849 N Judson-San Pierre Jr Sr High Sch   Regular School No High 07 12 2019   adult                         1.0 0.0                       1.0                         1 0                 1
1761673 1761673 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other 01 12 2019   grade_5                         1.0 0.0                       1.0                         1 0                 1
1761732 1761732 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000470 8317 Hebron Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1761849 1761849 IN     school 1808070 8010   North Vermillion Com Sch Corp 180807000184 8403 North Vermillion Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         1.0 6.0                       7.0                         1 6                 7
1761882 1761882 IN     school 1812090 8030   Vigo County School Corp 181209001917 8441 Terre Haute North Vigo High School   Regular School No High 09 12 2019   adult                         1.0 0.0                       1.0                         1 0                 1
1762061 1762061 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2019   grade_9                         1.0 4.0                       5.0                         1 4                 5
1762118 1762118 IN     school 1812180 8050   M S D Wabash County Schools 181218001951 8673 White's Jr-Sr High School   Regular School No High 07 12 2019   grade_7                         1.0 3.0                       4.0                         1 3                 4
1762494 1762494 IN     school 1808220 8435   Northern Wells Community Schools 180822001411 9081 Ossian Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1762718 1762718 IN     school 1800182 9050   Excel Center - Clarksville 180018202619 2006 Excel Center - Clarksville   Regular School Yes High 10 12 2019   grade_10                         1.0 1.0                       2.0                         1 1                 2
1762779 1762779 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 07 12 2019   grade_7                         1.0 0.0                       1.0                         1 0                 1
1762856 1762856 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2019   pre_kindergarten                         1.0 5.0                       6.0                         1 5                 6
1762876 1762876 IN     school 1800138 9335   Excel Center - Lafayette Square 180013802554 5912 Excel Center - Lafayette Square   Regular School Yes High 09 12 2019   grade_10                         1.0 0.0                       1.0                         1 0                 1
1763075 1763075 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_10                         1.0 4.0                       5.0                         1 4                 5
1763079 1763079 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_3                         1.0 2.0                       3.0                         1 2                 3
1763086 1763086 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   kindergarten                         1.0 3.0                       4.0                         1 3                 4
1763365 1763365 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes High 06 12 2019   adult                         1.0 0.0                       1.0                         1 0                 1
1763412 1763412 IN     school 1800160 9915   Marion Academy 180016002588 5903 Marion Academy   Regular School Yes High 06 12 2019   grade_6                         1.0 0.0                       1.0                         1 0                 1
1763429 1763429 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1751996 1751996 IN     school 1803630 235   Fort Wayne Community Schools 180363000948 257 Study Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1752072 1752072 IN     school 1802850 255   East Allen County Schools 180285000361 285 Woodlan Jr/Sr High School   Regular School No High 07 12 2019   adult                         10.0 3.0                       13.0                         10 3                 13
1752257 1752257 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No Elementary PK 06 2019   grade_1                         10.0 8.0                       18.0                         10 8                 18
1752261 1752261 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No Elementary PK 06 2019   grade_5                         10.0 9.0                       19.0                         10 9                 19
1752283 1752283 IN     school 1800570 515   Blackford County Schools 180057000107 485 Montpelier School   Regular School No Elementary KG 06 2019   grade_3                         10.0 10.0                       20.0                         10 10                 20
1752743 1752743 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         10.0 11.0                       21.0                         10 11                 21
1752765 1752765 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2019   grade_11                         10.0 3.0                       13.0                         10 3                 13
1752986 1752986 IN     school 1812450 1405   Washington Community Schools 181245002005 1105 Veale Elementary School   Regular School No Elementary KG 06 2019   grade_2                         10.0 14.0                       24.0                         10 14                 24
1753070 1753070 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000055 1169 Moores Hill Elementary School   Regular School No Elementary KG 06 2019   grade_5                         10.0 9.0                       19.0                         10 9                 19
1753071 1753071 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000055 1169 Moores Hill Elementary School   Regular School No Elementary KG 06 2019   grade_6                         10.0 12.0                       22.0                         10 12                 22
1753208 1753208 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000226 1341 Waterloo Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         10.0 14.0                       24.0                         10 14                 24
1753419 1753419 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 04 12 2019   grade_8                         10.0 8.0                       18.0                         10 8                 18
1753855 1753855 IN     school 1803930 2315   Goshen Community Schools 180393000654 1821 Goshen High School   Regular School No High 09 12 2019   adult                         10.0 12.0                       22.0                         10 12                 22
1754040 1754040 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001278 1981 S Ellen Jones Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         10.0 7.0                       17.0                         10 7                 17
1754122 1754122 IN     school 1803700 2475   Franklin County Community Sch Corp 180370000591 2127 Mount Carmel School   Regular School No Elementary KG 06 2019   grade_5                         10.0 20.0                       30.0                         10 20                 30
1754166 1754166 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Township Elementary   Regular School No Elementary KG 06 2019   kindergarten                         10.0 14.0                       24.0                         10 14                 24
1754177 1754177 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No Elementary KG 06 2019   kindergarten                         10.0 7.0                       17.0                         10 7                 17
1754757 1754757 IN     school 1807650 3070   Noblesville Schools 180765001311 2529 North Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         10.0 8.0                       18.0                         10 8                 18
1754972 1754972 IN     school 1810360 3190   South Harrison Com Schools 181036001698 2649 New Middletown Elementary School   Regular School No Elementary KG 06 2019   grade_1                         10.0 10.0                       20.0                         10 10                 20
1754974 1754974 IN     school 1810360 3190   South Harrison Com Schools 181036001698 2649 New Middletown Elementary School   Regular School No Elementary KG 06 2019   grade_3                         10.0 9.0                       19.0                         10 9                 19
1754980 1754980 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elementary School   Regular School No Elementary PK 06 2019   grade_1                         10.0 9.0                       19.0                         10 9                 19
1754981 1754981 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elementary School   Regular School No Elementary PK 06 2019   grade_2                         10.0 7.0                       17.0                         10 7                 17
1755333 1755333 IN     school 1807440 3445   New Castle Community School Corp 180744001289 2853 Sunnyside Elementary School   Regular School No Elementary KG 03 2019   grade_3                         10.0 1.0                       11.0                         10 1                 11
1755418 1755418 IN     school 1803150 3480   Eastern Howard School Corporation 180315000412 2909 Eastern Elementary School   Regular School No Elementary PK 07 2019   pre_kindergarten                         10.0 0.0                       10.0                         10 0                 10
1755582 1755582 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No High 07 12 2019   grade_11                         10.0 4.0                       14.0                         10 4                 14
1755672 1755672 IN     school 1812060 3710   Crothersville Community Schools 181206001892 3122 Crothersville Elementary School   Regular School No Elementary PK 05 2019   grade_5                         10.0 19.0                       29.0                         10 19                 29
1755769 1755769 IN     school 1806120 3995   Madison Consolidated Schools 180612001085 3301 Deputy Elementary School   Regular School No Elementary PK 04 2019   grade_4                         10.0 9.0                       19.0                         10 9                 19
1756366 1756366 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         10.0 4.0                       14.0                         10 4                 14
1757135 1757135 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2019   grade_5                         10.0 21.0                       31.0                         10 21                 31
1758164 1758164 IN     school 1812810 5375   M S D Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1758181 1758181 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1758218 1758218 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_9                         10.0 0.0                       10.0                         10 0                 10
1758305 1758305 IN     school 1804770 5385   Indianapolis Public Schools 180477002238 5492 Shortridge High School   Regular School No High 09 12 2019   adult                         10.0 6.0                       16.0                         10 6                 16
1758441 1758441 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2019   grade_3                         10.0 16.0                       26.0                         10 16                 26
1758443 1758443 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2019   grade_5                         10.0 25.0                       35.0                         10 25                 35
1758766 1758766 IN     school 1810920 5400   School Town of Speedway 181092001781 5897 Carl G Fisher Elementary School 1   Regular School No Elementary PK 06 2019   grade_1                         10.0 9.0                       19.0                         10 9                 19
1758767 1758767 IN     school 1810920 5400   School Town of Speedway 181092001781 5897 Carl G Fisher Elementary School 1   Regular School No Elementary PK 06 2019   grade_2                         10.0 8.0                       18.0                         10 8                 18
1758772 1758772 IN     school 1810920 5400   School Town of Speedway 181092001781 5897 Carl G Fisher Elementary School 1   Regular School No Elementary PK 06 2019   kindergarten                         10.0 9.0                       19.0                         10 9                 19
1758777 1758777 IN     school 1810920 5400   School Town of Speedway 181092001780 5901 Arthur C Newby Elementary School 2   Regular School No Elementary KG 06 2019   grade_3                         10.0 15.0                       25.0                         10 15                 25

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