Data source: Big Local News · About: Big Local

462 rows where grade = "pre_kindergarten", state = "IN" and year = 2019 sorted by male

View and edit SQL

year

  • 2019 · 462

grade

  • pre_kindergarten · 462
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
1753806 IN     school 1803270 2305   Elkhart Community Schools 180327000437 1789 Monger Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         0.0 1.0                       1.0                         0 1                 1
1759743 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801857 6647 Turkey Run Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         0.0 1.0                       1.0                         0 1                 1
1763088 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   pre_kindergarten                         0.0 5.0                       5.0                         0 5                 5
1752468 IN     school 1801290 750   Carroll Consolidated School Corp 180129002103 629 Carroll Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         1.0 1.0                       2.0                         1 1                 2
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
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 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
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
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 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
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
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
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
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
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
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
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
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
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
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 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
1759245 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001715 6269 New Market Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         10.0 11.0                       21.0                         10 11                 21
1759459 IN     school 1810470 5995   South Newton School Corp 181047000768 6431 South Newton Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         10.0 9.0                       19.0                         10 9                 19
1759679 IN     school 1810900 6260   Southwest Parke Com Sch Corp 181090002288 6629 Montezuma Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         10.0 19.0                       29.0                         10 19                 29
1760952 IN     school 1803210 7285   Shelby Eastern Schools 180321000417 7663 Morristown Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         10.0 5.0                       15.0                         10 5                 15
1761702 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000465 8293 Fairlawn Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         10.0 4.0                       14.0                         10 4                 14
1761792 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000473 8353 Evans School   Regular School No Elementary PK 06 2019   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1761948 IN     school 1812090 8030   Vigo County School Corp 181209002172 8510 Adelaide De Vaney Elementary Sch   Regular School No Elementary PK 05 2019   pre_kindergarten                         10.0 16.0                       26.0                         10 16                 26
1751814 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         11.0 7.0                       18.0                         11 7                 18
1751951 IN     school 1803630 235   Fort Wayne Community Schools 180363000524 221 Francis M Price Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         11.0 5.0                       16.0                         11 5                 16
1752131 IN     school 1800360 365   Bartholomew Con School Corp 180036002188 328 Clifty Creek Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         11.0 11.0                       22.0                         11 11                 22
1752208 IN     school 1800360 365   Bartholomew Con School Corp 180036000081 377 Taylorsville Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         11.0 8.0                       19.0                         11 8                 19
1752839 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         11.0 19.0                       30.0                         11 19                 30
1754021 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001269 1961 Green Valley Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         11.0 6.0                       17.0                         11 6                 17
1754616 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten                         11.0 4.0                       15.0                         11 4                 15
1755231 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001172 2675 Mill Creek East Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         11.0 7.0                       18.0                         11 7                 18
1755675 IN     school 1812060 3710   Crothersville Community Schools 181206001892 3122 Crothersville Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         11.0 8.0                       19.0                         11 8                 19
1756954 IN     school 1804320 4710   School City of Hammond 180432000743 4479 Lew Wallace Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         11.0 10.0                       21.0                         11 10                 21
1757298 IN     school 1805580 4945   LaPorte Community School Corp 180558001016 4757 Lincoln Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         11.0 16.0                       27.0                         11 16                 27
1758479 IN     school 1804770 5385   Indianapolis Public Schools 180477000901 5560 IPS/ Butler Lab @ William Bell 60   Regular School No Elementary PK 08 2019   pre_kindergarten                         11.0 10.0                       21.0                         11 10                 21
1758885 IN     school 1811490 5495   Triton School Corporation 181149001855 5922 Triton Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         11.0 7.0                       18.0                         11 7                 18
1759098 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000118 6173 Binford Elementary School   Regular School No Elementary 03 06 2019   pre_kindergarten                         11.0 9.0                       20.0                         11 9                 20
1759364 IN     school 1806510 5925   M S D Martinsville Schools 180651001139 6361 Poston Road Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         11.0 4.0                       15.0                         11 4                 15
1759727 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001282 6745 William Tell Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         11.0 4.0                       15.0                         11 4                 15
1761216 IN     school 1811100 7615   M S D Steuben County 181110001799 7897 Carlin Park Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         11.0 4.0                       15.0                         11 4                 15
1761300 IN     school 1811220 7775   Switzerland County School Corp 181122001808 7985 Jefferson-Craig Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         11.0 13.0                       24.0                         11 13                 24
1761584 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000482 8229 Scott Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         11.0 9.0                       20.0                         11 9                 20
1762025 IN     school 1812090 8030   Vigo County School Corp 181209002176 8575 Ouabache Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         11.0 11.0                       22.0                         11 11                 22
1755903 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189001028 3423 Sawmill Woods Elementary School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         111.0 74.0                       185.0                         111 74                 185
1752653 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         12.0 15.0                       27.0                         12 15                 27
1752669 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         12.0 13.0                       25.0                         12 13                 25
1753127 IN     school 1802610 1655   Decatur County Community Schools 180261000310 1265 South Decatur Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         12.0 2.0                       14.0                         12 2                 14
1753374 IN     school 1807320 1970   Muncie Community Schools 180732001235 1470 Grissom Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         12.0 7.0                       19.0                         12 7                 19
1753517 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2019   pre_kindergarten                         12.0 11.0                       23.0                         12 11                 23
1754573 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         12.0 2.0                       14.0                         12 2                 14
1756467 IN     school 1809690 4600   Merrillville Community School Corp 180969001582 3821 Henry P Fieler Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         12.0 22.0                       34.0                         12 22                 34
1758412 IN     school 1804770 5385   Indianapolis Public Schools 180477000904 5549 William Penn School 49   Regular School No Elementary PK 08 2019   pre_kindergarten                         12.0 7.0                       19.0                         12 7                 19
1758421 IN     school 1804770 5385   Indianapolis Public Schools 180477002404 5551 James Russell Lowell School 51   Regular School No Elementary PK 06 2019   pre_kindergarten                         12.0 8.0                       20.0                         12 8                 20
1758610 IN     school 1804770 5385   Indianapolis Public Schools 180477000873 5596 Meredith Nicholson School 96   Regular School No Elementary PK 06 2019   pre_kindergarten                         12.0 29.0                       41.0                         12 29                 41
1759598 IN     school 1808640 6155   Paoli Community School Corp 180864001439 6587 Throop Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         12.0 9.0                       21.0                         12 9                 21
1761057 IN     school 1808010 7385   North Spencer County Sch Corp 180801001373 7751 Chrisney Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         12.0 10.0                       22.0                         12 10                 22
1761694 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000463 8289 Dexter Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         12.0 8.0                       20.0                         12 8                 20
1762110 IN     school 1812180 8050   M S D Wabash County Schools 181218001947 8656 Southwood Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         12.0 6.0                       18.0                         12 6                 18
1762297 IN     school 1809810 8205   Salem Community Schools 180981000357 8864 Bradie Shrum Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         12.0 1.0                       13.0                         12 1                 13
1762331 IN     school 1812930 8220   West Washington School Corp 181293002062 8894 West Washington Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         12.0 10.0                       22.0                         12 10                 22
1763103 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   pre_kindergarten                         12.0 14.0                       26.0                         12 14                 26
1756673 IN     school 1802880 4670   School City of East Chicago 180288000365 3937 Carrie Gosch PK Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         121.0 119.0                       240.0                         121 119                 240
1752323 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002065 537 Thorntown Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         13.0 12.0                       25.0                         13 12                 25
1754657 IN     school 1801200 3060   Carmel Clay Schools 180120002332 2508 Cherry Tree Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         13.0 10.0                       23.0                         13 10                 23
1754789 IN     school 1807650 3070   Noblesville Schools 180765002546 2539 Promise Road Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         13.0 6.0                       19.0                         13 6                 19
1754801 IN     school 1807650 3070   Noblesville Schools 180765001246 2547 White River Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         13.0 3.0                       16.0                         13 3                 16
1754917 IN     school 1803120 3145   Eastern Hancock Co Com Sch Corp 180312000409 2586 Eastern Hancock Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         13.0 4.0                       17.0                         13 4                 17
1757263 IN     school 1805580 4945   LaPorte Community School Corp 180558001013 4727 Kingsbury Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         13.0 26.0                       39.0                         13 26                 39
1757862 IN     school 1808820 5340   Perry Township Schools 180882001457 5338 Douglas MacArthur Elementary Sch   Regular School No Elementary PK 05 2019   pre_kindergarten                         13.0 6.0                       19.0                         13 6                 19
1757878 IN     school 1808820 5340   Perry Township Schools 180882001466 5347 Southport Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         13.0 14.0                       27.0                         13 14                 27
1758327 IN     school 1804770 5385   Indianapolis Public Schools 180477000896 5515 Thomas D Gregg School 15   Regular School No Elementary PK 06 2019   pre_kindergarten                         13.0 4.0                       17.0                         13 4                 17
1759065 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002347 6162 Highland Park Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         13.0 13.0                       26.0                         13 13                 26
1759300 IN     school 1803330 5910   Eminence Community School Corp 180333002274 6327 Eminence Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         13.0 9.0                       22.0                         13 9                 22
1759507 IN     school 1802970 6060   East Noble School Corporation 180297000393 6465 Rome City Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         13.0 10.0                       23.0                         13 10                 23
1760176 IN     school 1810500 6705   South Putnam Community Schools 181050001724 7057 Fillmore Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         13.0 7.0                       20.0                         13 7                 20
1760578 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876000526 7383 Horizon Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         13.0 8.0                       21.0                         13 8                 21
1761002 IN     school 1810830 7360   Southwestern Con Sch Shelby Co 181083001768 7703 Southwestern Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         13.0 10.0                       23.0                         13 10                 23
1761066 IN     school 1808010 7385   North Spencer County Sch Corp 180801001375 7753 David Turnham Education Center   Regular School No Elementary PK 06 2019   pre_kindergarten                         13.0 11.0                       24.0                         13 11                 24
1761519 IN     school 1808040 7935   Tri-Central Community Schools 180804002227 8154 Tri Central Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         13.0 14.0                       27.0                         13 14                 27
1762009 IN     school 1812090 8030   Vigo County School Corp 181209001909 8549 Lost Creek Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         13.0 5.0                       18.0                         13 5                 18
1762049 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         13.0 24.0                       37.0                         13 24                 37
1762436 IN     school 1809510 8385   Richmond Community Schools 180951001556 9017 Fairview Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         13.0 16.0                       29.0                         13 16                 29
1762443 IN     school 1809510 8385   Richmond Community Schools 180951002455 9038 Starr Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         13.0 15.0                       28.0                         13 15                 28
1760848 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2019   pre_kindergarten                         132.0 87.0                       219.0                         132 87                 219
1760851 IN     school 1810290 7205   South Bend Community School Corp 181029002574 7617 Studebaker Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         134.0 90.0                       224.0                         134 90                 224
1757525 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         137.0 89.0                       226.0                         137 89                 226
1752434 IN     school 1800960 670   Brown County School Corporation 180096000173 577 Van Buren Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         14.0 7.0                       21.0                         14 7                 21
1753696 IN     school 1803270 2305   Elkhart Community Schools 180327000439 1673 Osolo Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         14.0 5.0                       19.0                         14 5                 19
1753932 IN     school 1803510 2395   Fayette County School Corporation 180351000503 1909 Frazee Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         14.0 17.0                       31.0                         14 17                 31
1754600 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         14.0 5.0                       19.0                         14 5                 19
1756251 IN     school 1812420 4415   Warsaw Community Schools 181242001992 3661 Jefferson Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         14.0 8.0                       22.0                         14 8                 22
1756931 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         14.0 26.0                       40.0                         14 26                 40
1757822 IN     school 1808820 5340   Perry Township Schools 180882001469 5321 William Henry Burkhart Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         14.0 6.0                       20.0                         14 6                 20
1759125 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000124 6189 Clear Creek Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         14.0 5.0                       19.0                         14 5                 19
1759711 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2019   pre_kindergarten                         14.0 8.0                       22.0                         14 8                 22

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