enrollments

Data source: Big Local News · About: Big Local

419 rows where grade = "grade_12", state = "IN" and year = 2018 sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 419 ✖

grade ✖

  • grade_12 · 419 ✖
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 ▼
1789572 1789572 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Middle 05 12 2018   grade_12                         0.0 1.0                       1.0                         0 1                 1
1796666 1796666 IN     school 1810290 7205   South Bend Community School Corp 181029002574 7617 Studebaker Center   Regular School No High 12 12 2018   grade_12                         1.0 0.0                       1.0                         1 0                 1
1796676 1796676 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 08 12 2018   grade_12                         2.0 0.0                       2.0                         2 0                 2
1791394 1791394 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105001408 3108 Jackson Co Juvenile Detention Cntr   Alternative School No High 08 12 2018   grade_12                         3.0 0.0                       3.0                         3 0                 3
1798523 1798523 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 Madison Juvenile Correctional   Regular School No High 09 12 2018   grade_12                         0.0 4.0                       4.0                         0 4                 4
1788498 1788498 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 05 12 2018   grade_12                         5.0 0.0                       5.0                         5 0                 5
1794000 1794000 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_12                         5.0 0.0                       5.0                         5 0                 5
1798517 1798517 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2018   grade_12                         5.0 0.0                       5.0                         5 0                 5
1798992 1798992 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2018   grade_12                         5.0 0.0                       5.0                         5 0                 5
1798503 1798503 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2018   grade_12                         6.0 0.0                       6.0                         6 0                 6
1789153 1789153 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_12                         3.0 4.0                       7.0                         3 4                 7
1798245 1798245 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2018   grade_12                         5.0 2.0                       7.0                         5 2                 7
1798884 1798884 IN     school 1800059 9655   Hope Academy 180005902386 5292 Hope Academy   Regular School Yes High 09 12 2018   grade_12                         4.0 3.0                       7.0                         4 3                 7
1799212 1799212 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes High 09 12 2018   grade_12                         4.0 4.0                       8.0                         4 4                 8
1798511 1798511 IN     school 1800006 9100   Indiana Department of Correction 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 09 12 2018   grade_12                         9.0 0.0                       9.0                         9 0                 9
1799049 1799049 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2018   grade_12                         5.0 4.0                       9.0                         5 4                 9
1796421 1796421 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 03 12 2018   grade_12                         9.0 2.0                       11.0                         9 2                 11
1795524 1795524 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2018   grade_12                         5.0 7.0                       12.0                         5 7                 12
1796819 1796819 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 02 12 2018   grade_12                         7.0 6.0                       13.0                         7 6                 13
1798807 1798807 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 2018   grade_12                         11.0 3.0                       14.0                         11 3                 14
1798681 1798681 IN     school 1800166 9440   Christel House DORS West 180016602586 5873 Christel House DORS West   Regular School Yes High 09 12 2018   grade_12                         5.0 11.0                       16.0                         5 11                 16
1797136 1797136 IN     school 1805400 7855   Lafayette School Corporation 180540002518 8015 Oakland High School   Regular School No High 09 12 2018   grade_12                         7.0 10.0                       17.0                         7 10                 17
1794974 1794974 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002498 6220 Bloomington Graduation School   Regular School No High 09 12 2018   grade_12                         13.0 7.0                       20.0                         13 7                 20
1797002 1797002 IN     school 1804230 7610   Hamilton Community Schools 180423000724 7885 Hamilton Community High School   Regular School No High 07 12 2018   grade_12                         9.0 11.0                       20.0                         9 11                 20
1797842 1797842 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2018   grade_12                         3.0 18.0                       21.0                         3 18                 21
1797847 1797847 IN     school 1812090 8030   Vigo County School Corp 181209000926 8612 McLean Education Center (Alt)   Regular School No High 07 12 2018   grade_12                         14.0 7.0                       21.0                         14 7                 21
1791328 1791328 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No High 07 12 2018   grade_12                         9.0 13.0                       22.0                         9 13                 22
1791413 1791413 IN     school 1812060 3710   Crothersville Community Schools 181206001893 3121 Crothersville Jr-Sr High School   Regular School No High 06 12 2018   grade_12                         10.0 12.0                       22.0                         10 12                 22
1792920 1792920 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702511 4692 LaCrosse School   Regular School No High 09 12 2018   grade_12                         11.0 12.0                       23.0                         11 12                 23
1795103 1795103 IN     school 1803330 5910   Eminence Community School Corp 180333000454 6325 Eminence Jr-Sr High School   Regular School No High 06 12 2018   grade_12                         12.0 11.0                       23.0                         12 11                 23
1798943 1798943 IN     school 1800167 9710   Carpe Diem - Northwest 180016702579 5977 Carpe Diem - Northwest   Regular School Yes High 06 12 2018   grade_12                         8.0 18.0                       26.0                         8 18                 26
1794957 1794957 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002467 6202 The Acad of Sci & Entrepreneurship   Regular School No High 09 12 2018   grade_12                         12.0 15.0                       27.0                         12 15                 27
1798633 1798633 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   grade_12                         13.0 14.0                       27.0                         13 14                 27
1799182 1799182 IN     school 1800160 9915   Marion Academy 180016002588 5903 Marion Academy   Regular School Yes High 06 12 2018   grade_12                         16.0 13.0                       29.0                         16 13                 29
1798571 1798571 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_12                         14.0 16.0                       30.0                         14 16                 30
1799116 1799116 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2018   grade_12                         18.0 12.0                       30.0                         18 12                 30
1788507 1788507 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2018   grade_12                         16.0 17.0                       33.0                         16 17                 33
1796768 1796768 IN     school 1803210 7285   Shelby Eastern Schools 180321000420 7665 Waldron Jr-Sr High School   Regular School No High 06 12 2018   grade_12                         14.0 20.0                       34.0                         14 20                 34
1798646 1798646 IN     school 1800122 9385   Christel House DORS 180012202538 5532 Christel House DORS   Regular School Yes High 09 12 2018   grade_12                         21.0 13.0                       34.0                         21 13                 34
1798822 1798822 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2018   grade_12                         22.0 12.0                       34.0                         22 12                 34
1799148 1799148 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2018   grade_12                         21.0 13.0                       34.0                         21 13                 34
1799191 1799191 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2018   grade_12                         25.0 10.0                       35.0                         25 10                 35
1794708 1794708 IN     school 1810170 5520   Shoals Community School Corp 181017001635 5985 Shoals Community High School   Regular School No High 09 12 2018   grade_12                         21.0 18.0                       39.0                         21 18                 39
1788419 1788419 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2018   grade_12                         15.0 26.0                       41.0                         15 26                 41
1798339 1798339 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         20.0 21.0                       41.0                         20 21                 41
1788689 1788689 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No High 06 12 2018   grade_12                         20.0 22.0                       42.0                         20 22                 42
1795576 1795576 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801858 6649 Turkey Run Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         26.0 16.0                       42.0                         26 16                 42
1799304 1799304 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2018   grade_12                         12.0 31.0                       43.0                         12 31                 43
1796086 1796086 IN     school 1811730 6795   Union School Corporation 181173001875 7119 Union Junior & High School   Regular School No High 07 12 2018   grade_12                         14.0 30.0                       44.0                         14 30                 44
1796101 1796101 IN     school 1810740 6805   Randolph Southern School Corp 181074001763 7121 Randolph Southern Jr-Sr High Sch   Regular School No High 07 12 2018   grade_12                         20.0 24.0                       44.0                         20 24                 44
1799239 1799239 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2018   grade_12                         24.0 20.0                       44.0                         24 20                 44
1789779 1789779 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 07 12 2018   grade_12                         18.0 27.0                       45.0                         18 27                 45
1790145 1790145 IN     school 1810110 2960   M S D Shakamak Schools 181011001623 2445 Shakamak Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         16.0 30.0                       46.0                         16 30                 46
1790748 1790748 IN     school 1810360 3190   South Harrison Com Schools 181036002285 2670 South Central Jr & Sr High School   Regular School No High 06 12 2018   grade_12                         20.0 26.0                       46.0                         20 26                 46
1794632 1794632 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         21.0 25.0                       46.0                         21 25                 46
1798847 1798847 IN     school 1800038 9620   Burris Laboratory School 180003800185 1441 Burris Laboratory School   Regular School No Other KG 12 2018   grade_12                         26.0 20.0                       46.0                         26 20                 46
1790104 1790104 IN     school 1800600 2920   Bloomfield School District 180060000113 2419 Bloomfield Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         30.0 17.0                       47.0                         30 17                 47
1796752 1796752 IN     school 1803210 7285   Shelby Eastern Schools 180321000418 7661 Morristown Jr-Sr High School   Regular School No High 06 12 2018   grade_12                         27.0 21.0                       48.0                         27 21                 48
1796803 1796803 IN     school 1810830 7360   Southwestern Con Sch Shelby Co 181083001769 7701 Southwestern High School   Regular School No High 07 12 2018   grade_12                         21.0 27.0                       48.0                         21 27                 48
1796943 1796943 IN     school 1808460 7495   Oregon-Davis School Corp 180846001435 7831 Oregon-Davis Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         26.0 22.0                       48.0                         26 22                 48
1798101 1798101 IN     school 1812930 8220   West Washington School Corp 181293002063 8869 West Washington Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         21.0 27.0                       48.0                         21 27                 48
1799027 1799027 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2018   grade_12                         25.0 23.0                       48.0                         25 23                 48
1788342 1788342 IN     school 1809370 940   West Clark Community Schools 180937001540 813 William W Borden High School   Regular School No High 07 12 2018   grade_12                         26.0 24.0                       50.0                         26 24                 50
1788583 1788583 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2018   grade_12                         28.0 22.0                       50.0                         28 22                 50
1794519 1794519 IN     school 1804770 5385   Indianapolis Public Schools 180477001446 5643 George Washington Community HS   Regular School No High 09 12 2018   grade_12                         27.0 23.0                       50.0                         27 23                 50
1790988 1790988 IN     school 1800660 3405   Blue River Valley Schools 180066000141 2801 Blue River Valley Jr-Sr High Sch   Regular School No High 07 12 2018   grade_12                         25.0 26.0                       51.0                         25 26                 51
1795389 1795389 IN     school 1809600 6080   Rising Sun-Ohio Co Com 180960001573 6513 Rising Sun High School   Regular School No High 09 12 2018   grade_12                         25.0 26.0                       51.0                         25 26                 51
1789916 1789916 IN     school 1802940 2725   East Gibson School Corporation 180294000386 2233 Waldo J Wood Memorial High   Regular School No High 09 12 2018   grade_12                         30.0 22.0                       52.0                         30 22                 52
1795394 1795394 IN     school 1808490 6145   Orleans Community Schools 180849001437 6573 Orleans Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         28.0 24.0                       52.0                         28 24                 52
1794607 1794607 IN     school 1802520 5455   Culver Community Schools Corp 180252000301 5245 Culver Community Middle/High Sch   Regular School No High 06 12 2018   grade_12                         32.0 21.0                       53.0                         32 21                 53
1798266 1798266 IN     school 1810770 8425   Southern Wells Com Schools 181077001765 9058 Southern Wells Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         29.0 26.0                       55.0                         29 26                 55
1798935 1798935 IN     school 1800082 9705   Hammond Academy of Science & Tech 180008202466 4486 Hammond Academy of Science & Tech   Regular School Yes High 06 12 2018   grade_12                         28.0 28.0                       56.0                         28 28                 56
1789055 1789055 IN     school 1807020 1900   Cowan Community School Corp 180702001200 1386 Cowan High School   Regular School No High 07 12 2018   grade_12                         22.0 35.0                       57.0                         22 35                 57
1795553 1795553 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801579 6637 Rockville Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         28.0 29.0                       57.0                         28 29                 57
1794737 1794737 IN     school 1806060 5525   Loogootee Community Sch Corp 180606001067 6003 Loogootee High School   Regular School No High 09 12 2018   grade_12                         33.0 26.0                       59.0                         33 26                 59
1791742 1791742 IN     school 1803240 4215   Edinburgh Community School Corp 180324000422 3447 Edinburgh Community High School   Regular School No High 09 12 2018   grade_12                         27.0 33.0                       60.0                         27 33                 60
1798758 1798758 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   grade_12                         31.0 29.0                       60.0                         31 29                 60
1798782 1798782 IN     school 1800051 9575   Indpls Lighthouse Charter School 180005102165 5523 Indpls Lighthouse Charter School   Regular School Yes Other KG 12 2018   grade_12                         27.0 33.0                       60.0                         27 33                 60
1799129 1799129 IN     school 1800101 9880   Career Academy High School 180010102521 7567 Career Academy High School   Regular School Yes High 09 12 2018   grade_12                         33.0 27.0                       60.0                         33 27                 60
1789890 1789890 IN     school 1801410 2650   Caston School Corporation 180141000207 2159 Caston Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         30.0 31.0                       61.0                         30 31                 61
1797628 1797628 IN     school 1808070 8010   North Vermillion Com Sch Corp 180807001384 8394 North Vermillion High School   Regular School No High 07 12 2018   grade_12                         31.0 30.0                       61.0                         31 30                 61
1798686 1798686 IN     school 1800045 9445   Charles A Tindley Accelerated Sch 180004502137 6208 Charles A Tindley Accelerated Sch   Regular School Yes High 09 12 2018   grade_12                         25.0 36.0                       61.0                         25 36                 61
1790672 1790672 IN     school 1803720 3160   Lanesville Community School Corp 180372000593 2613 Lanesville Jr-Sr HS   Regular School No High 07 12 2018   grade_12                         30.0 32.0                       62.0                         30 32                 62
1792562 1792562 IN     school 1803870 4690   Gary Community School Corp 180387002199 4168 Wm A Wirt/Emerson VPA   Regular School No High 06 12 2018   grade_12                         17.0 45.0                       62.0                         17 45                 62
1795490 1795490 IN     school 1810900 6260   Southwest Parke Com Sch Corp 181090002287 6627 Riverton Parke Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         25.0 37.0                       62.0                         25 37                 62
1795670 1795670 IN     school 1809000 6510   East Porter County School Corp 180900001214 6825 Morgan Township Middle/High School   Regular School No High 06 12 2018   grade_12                         34.0 28.0                       62.0                         34 28                 62
1795972 1795972 IN     school 1809360 6630   West Central School Corp 180936001529 7025 West Central Senior High School   Regular School No High 09 12 2018   grade_12                         38.0 25.0                       63.0                         38 25                 63
1797338 1797338 IN     school 1808040 7935   Tri-Central Community Schools 180804001379 8155 Tri Central Middle-High School   Regular School No High 06 12 2018   grade_12                         40.0 23.0                       63.0                         40 23                 63
1795425 1795425 IN     school 1810980 6160   Springs Valley Com School Corp 181098001795 6589 Springs Valley Comm High School   Regular School No High 06 12 2018   grade_12                         32.0 32.0                       64.0                         32 32                 64
1797060 1797060 IN     school 1808160 7645   Northeast School Corp 180816001402 7917 North Central High School   Regular School No High 09 12 2018   grade_12                         34.0 30.0                       64.0                         34 30                 64
1798117 1798117 IN     school 1807380 8305   Nettle Creek School Corporation 180738001261 8985 Hagerstown Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         38.0 26.0                       64.0                         38 26                 64
1798565 1798565 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2018   grade_12                         31.0 33.0                       64.0                         31 33                 64
1787865 1787865 IN     school 1802850 255   East Allen County Schools 180285002532 394 East Allen University   Regular School No High 09 12 2018   grade_12                         16.0 49.0                       65.0                         16 49                 65
1788522 1788522 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         29.0 36.0                       65.0                         29 36                 65
1794701 1794701 IN     school 1811490 5495   Triton School Corporation 181149001856 5923 Triton Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         30.0 35.0                       65.0                         30 35                 65
1795265 1795265 IN     school 1810470 5995   South Newton School Corp 181047001722 6417 South Newton Senior High School   Regular School No High 09 12 2018   grade_12                         37.0 28.0                       65.0                         37 28                 65
1796202 1796202 IN     school 1804800 6900   Jac-Cen-Del Community Sch Corp 180480000907 7193 Jac-Cen-Del MS/HS   Regular School No High 07 12 2018   grade_12                         29.0 36.0                       65.0                         29 36                 65
1789080 1789080 IN     school 1809840 1940   Daleville Community Schools 180984001603 1401 Daleville Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         33.0 33.0                       66.0                         33 33                 66
1790160 1790160 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2018   grade_12                         40.0 26.0                       66.0                         40 26                 66
1788853 1788853 IN     school 1802610 1655   Decatur County Community Schools 180261000311 1263 South Decatur Jr-Sr High School   Regular School No High 07 12 2018   grade_12                         37.0 30.0                       67.0                         37 30                 67

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