Data source: Big Local News · About: Big Local

1,043 rows where grade = "grade_4", state = "IN" and year = 2019 sorted by male

View and edit SQL

year

  • 2019 · 1,043

grade

  • grade_4 · 1,043
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
1756016 IN     school 1803690 4225   Franklin Community School Corp 180369002440 3458 Custer Baker Intermediate School   Regular School No Middle 04 06 2019   grade_4                         0.0 1.0                       1.0                         0 1                 1
1756750 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No Elementary KG 05 2019   grade_4                         0.0 58.0                       58.0                         0 58                 58
1752563 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Middle 04 08 2019   grade_4                         1.0 0.0                       1.0                         1 0                 1
1753416 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 04 12 2019   grade_4                         1.0 0.0                       1.0                         1 0                 1
1755109 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No Middle 04 06 2019   grade_4                         1.0 0.0                       1.0                         1 0                 1
1755174 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2019   grade_4                         1.0 0.0                       1.0                         1 0                 1
1755713 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No Elementary PK 05 2019   grade_4                         1.0 0.0                       1.0                         1 0                 1
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
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
1759229 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001717 6258 Walnut Elementary School   Regular School No Elementary PK 05 2019   grade_4                         10.0 15.0                       25.0                         10 15                 25
1759418 IN     school 1807920 5945   North Newton School Corp 180792001361 6397 Morocco Elementary School   Regular School No Elementary KG 06 2019   grade_4                         10.0 12.0                       22.0                         10 12                 22
1759628 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001787 6605 Gosport Elementary School   Regular School No Elementary KG 06 2019   grade_4                         10.0 12.0                       22.0                         10 12                 22
1760526 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001447 7341 Madison Elementary School   Regular School No Elementary KG 05 2019   grade_4                         10.0 8.0                       18.0                         10 8                 18
1763194 IN     school 1800065 9690   Renaissance Academy Charter School 180006502415 4711 Renaissance Academy Charter School   Regular School Yes Elementary KG 08 2019   grade_4                         10.0 14.0                       24.0                         10 14                 24
1763226 IN     school 1800123 9735   Inspire Academy - A Sch of Inquiry 180012302560 1518 Inspire Academy - A Sch of Inquiry   Regular School Yes Elementary KG 08 2019   grade_4                         10.0 5.0                       15.0                         10 5                 15
1752035 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2019   grade_4                         100.0 103.0                       203.0                         100 103                 203
1760265 IN     school 1811730 6795   Union School Corporation 181173002654 7122 Indiana Digital Elementary   Regular School No Elementary KG 06 2019   grade_4                         100.0 107.0                       207.0                         100 107                 207
1755440 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2019   grade_4                         101.0 97.0                       198.0                         101 97                 198
1757680 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002499 5203 Lillie Idella Kitley Elementary   Regular School No Elementary KG 05 2019   grade_4                         103.0 96.0                       199.0                         103 96                 199
1755696 IN     school 1805280 3785   Kankakee Valley School Corp 180528001412 3198 Kankakee Valley Intermediate Sch   Regular School No Elementary 04 05 2019   grade_4                         106.0 116.0                       222.0                         106 116                 222
1759256 IN     school 1802460 5855   Crawfordsville Community Schools 180246000292 6289 Mollie B Hoover Elementary School   Regular School No Elementary 04 05 2019   grade_4                         106.0 122.0                       228.0                         106 122                 228
1758266 IN     school 1800450 5380   Beech Grove City Schools 180045000095 5461 South Grove Intermediate School   Regular School No Middle 04 06 2019   grade_4                         108.0 117.0                       225.0                         108 117                 225
1759549 IN     school 1812900 6065   West Noble School Corporation 181290002231 6510 West Noble Elementary School   Regular School No Elementary 02 04 2019   grade_4                         108.0 90.0                       198.0                         108 90                 198
1752988 IN     school 1812450 1405   Washington Community Schools 181245002005 1105 Veale Elementary School   Regular School No Elementary KG 06 2019   grade_4                         11.0 10.0                       21.0                         11 10                 21
1753425 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001388 1543 Celestine Elementary School   Regular School No Elementary KG 04 2019   grade_4                         11.0 9.0                       20.0                         11 9                 20
1754975 IN     school 1810360 3190   South Harrison Com Schools 181036001698 2649 New Middletown Elementary School   Regular School No Elementary KG 06 2019   grade_4                         11.0 4.0                       15.0                         11 4                 15
1755591 IN     school 1801230 3640   Medora Community School Corp 180123002268 3095 Medora Elementary School   Regular School No Elementary PK 06 2019   grade_4                         11.0 3.0                       14.0                         11 3                 14
1759145 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000131 6213 Marlin Elementary School   Regular School No Elementary KG 06 2019   grade_4                         11.0 9.0                       20.0                         11 9                 20
1759296 IN     school 1803330 5910   Eminence Community School Corp 180333002274 6327 Eminence Elementary School   Regular School No Elementary PK 05 2019   grade_4                         11.0 10.0                       21.0                         11 10                 21
1759409 IN     school 1807140 5930   Mooresville Con School Corp 180714001213 6393 Waverly Elementary School   Regular School No Elementary PK 06 2019   grade_4                         11.0 19.0                       30.0                         11 19                 30
1759426 IN     school 1807920 5945   North Newton School Corp 180792001359 6405 Lake Village Elementary School   Regular School No Elementary KG 06 2019   grade_4                         11.0 12.0                       23.0                         11 12                 23
1760334 IN     school 1801770 6825   Randolph Central School Corp 180177002191 7146 Deerfield Elementary School   Regular School No Elementary PK 05 2019   grade_4                         11.0 14.0                       25.0                         11 14                 25
1762979 IN     school 1800043 9465   Rural Community Schools Inc 180004302138 7951 Rural Community Academy   Regular School Yes Elementary KG 08 2019   grade_4                         11.0 10.0                       21.0                         11 10                 21
1763236 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes Elementary KG 06 2019   grade_4                         11.0 6.0                       17.0                         11 6                 17
1752284 IN     school 1800570 515   Blackford County Schools 180057000107 485 Montpelier School   Regular School No Elementary KG 06 2019   grade_4                         12.0 13.0                       25.0                         12 13                 25
1753053 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000053 1141 Dillsboro Elementary School   Regular School No Elementary KG 06 2019   grade_4                         12.0 13.0                       25.0                         12 13                 25
1753767 IN     school 1803270 2305   Elkhart Community Schools 180327000434 1769 Mary Beck Elementary School   Regular School No Elementary PK 06 2019   grade_4                         12.0 16.0                       28.0                         12 16                 28
1758643 IN     school 1804770 5385   Indianapolis Public Schools 180477000887 5606 Robert Lee Frost School 106   Regular School No Elementary PK 06 2019   grade_4                         12.0 14.0                       26.0                         12 14                 26
1760693 IN     school 1810290 7205   South Bend Community School Corp 181029001650 7425 Clay International Academy   Regular School No Elementary KG 08 2019   grade_4                         12.0 12.0                       24.0                         12 12                 24
1762148 IN     school 1806080 8115   M S D Warren County 180608001075 8729 Williamsport Elementary School   Regular School No Elementary KG 06 2019   grade_4                         12.0 14.0                       26.0                         12 14                 26
1763212 IN     school 1800129 9725   Canaan Community Academy 180012902534 3312 Canaan Community Academy   Regular School Yes Elementary KG 06 2019   grade_4                         12.0 8.0                       20.0                         12 8                 20
1752597 IN     school 1809370 940   West Clark Community Schools 180937001538 789 Silver Creek Elementary School   Regular School No Elementary 02 05 2019   grade_4                         127.0 93.0                       220.0                         127 93                 220
1752739 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No Elementary PK 05 2019   grade_4                         13.0 16.0                       29.0                         13 16                 29
1752819 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No Elementary PK 05 2019   grade_4                         13.0 18.0                       31.0                         13 18                 31
1756005 IN     school 1803690 4225   Franklin Community School Corp 180369000585 3433 Union Elementary School   Regular School No Elementary KG 04 2019   grade_4                         13.0 16.0                       29.0                         13 16                 29
1756147 IN     school 1812120 4335   Vincennes Community School Corp 181212001929 3573 James Whitcomb Riley Elem Sch   Regular School No Elementary KG 05 2019   grade_4                         13.0 15.0                       28.0                         13 15                 28
1760021 IN     school 1811970 6560   Valparaiso Community Schools 181197001882 6891 Central Elementary School   Regular School No Elementary KG 05 2019   grade_4                         13.0 14.0                       27.0                         13 14                 27
1761234 IN     school 1811100 7615   M S D Steuben County 181110001801 7905 Pleasant Lake Elementary School   Regular School No Elementary KG 05 2019   grade_4                         13.0 9.0                       22.0                         13 9                 22
1762156 IN     school 1806080 8115   M S D Warren County 180608001072 8733 Pine Village Elementary School   Regular School No Elementary KG 06 2019   grade_4                         13.0 8.0                       21.0                         13 8                 21
1763318 IN     school 1800083 9835   The Bloomington Project School 180008302446 6215 The Bloomington Project School   Regular School Yes Elementary KG 08 2019   grade_4                         13.0 14.0                       27.0                         13 14                 27
1763466 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   grade_4                         13.0 16.0                       29.0                         13 16                 29
1752924 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000284 1045 West Crawford Elementary School   Regular School No Elementary PK 05 2019   grade_4                         14.0 23.0                       37.0                         14 23                 37
1753902 IN     school 1803510 2395   Fayette County School Corporation 180351000500 1869 Everton Elementary School   Regular School No Elementary KG 06 2019   grade_4                         14.0 18.0                       32.0                         14 18                 32
1754983 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elementary School   Regular School No Elementary PK 06 2019   grade_4                         14.0 4.0                       18.0                         14 4                 18
1755739 IN     school 1804980 3945   Jay School Corporation 180498000917 3247 Redkey Elementary School   Regular School No Elementary KG 05 2019   grade_4                         14.0 18.0                       32.0                         14 18                 32
1758769 IN     school 1810920 5400   School Town of Speedway 181092001781 5897 Carl G Fisher Elementary School 1   Regular School No Elementary PK 06 2019   grade_4                         14.0 9.0                       23.0                         14 9                 23
1759216 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001714 6233 Ladoga Elementary School   Regular School No Elementary PK 05 2019   grade_4                         14.0 15.0                       29.0                         14 15                 29
1760014 IN     school 1811970 6560   Valparaiso Community Schools 181197001889 6888 Thomas Jefferson Elementary School   Regular School No Elementary KG 05 2019   grade_4                         14.0 17.0                       31.0                         14 17                 31
1761061 IN     school 1808010 7385   North Spencer County Sch Corp 180801001375 7753 David Turnham Education Center   Regular School No Elementary PK 06 2019   grade_4                         14.0 17.0                       31.0                         14 17                 31
1761194 IN     school 1804230 7610   Hamilton Community Schools 180423000723 7889 Hamilton Community Elementary Sch   Regular School No Elementary KG 06 2019   grade_4                         14.0 8.0                       22.0                         14 8                 22
1761250 IN     school 1808160 7645   Northeast School Corp 180816001400 7921 Northeast North Elementary School   Regular School No Elementary KG 05 2019   grade_4                         14.0 21.0                       35.0                         14 21                 35
1761624 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000475 8251 Lincoln School   Regular School No Elementary KG 08 2019   grade_4                         14.0 10.0                       24.0                         14 10                 24
1762659 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2019   grade_4                         14.0 22.0                       36.0                         14 22                 36
1751658 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2019   grade_4                         15.0 15.0                       30.0                         15 15                 30
1753204 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000226 1341 Waterloo Elementary School   Regular School No Elementary PK 05 2019   grade_4                         15.0 18.0                       33.0                         15 18                 33
1753394 IN     school 1807320 1970   Muncie Community Schools 180732001243 1496 North View Elementary School   Regular School No Elementary KG 05 2019   grade_4                         15.0 23.0                       38.0                         15 23                 38
1755326 IN     school 1807440 3445   New Castle Community School Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No Elementary KG 06 2019   grade_4                         15.0 27.0                       42.0                         15 27                 42
1755732 IN     school 1804980 3945   Jay School Corporation 180498000910 3241 Bloomfield Elementary School   Regular School No Elementary KG 05 2019   grade_4                         15.0 17.0                       32.0                         15 17                 32
1756302 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2019   grade_4                         15.0 34.0                       49.0                         15 34                 49
1759331 IN     school 1806510 5925   M S D Martinsville Schools 180651001129 6341 Centerton Elementary School   Regular School No Elementary PK 04 2019   grade_4                         15.0 16.0                       31.0                         15 16                 31
1760086 IN     school 1807290 6590   M S D Mount Vernon 180729001223 6965 Farmersville Elementary School   Regular School No Elementary PK 05 2019   grade_4                         15.0 20.0                       35.0                         15 20                 35
1761706 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000467 8301 Glenwood Leadership Academy   Regular School No Elementary KG 08 2019   grade_4                         15.0 21.0                       36.0                         15 21                 36
1762575 IN     school 1811430 8535   Tri-County School Corporation 181143001845 9143 Tri-County Intermediate School   Regular School No Elementary 03 06 2019   grade_4                         15.0 24.0                       39.0                         15 24                 39
1762888 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 05 2019   grade_4                         15.0 29.0                       44.0                         15 29                 44
1752260 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No Elementary PK 06 2019   grade_4                         16.0 8.0                       24.0                         16 8                 24
1752673 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No Elementary PK 05 2019   grade_4                         16.0 25.0                       41.0                         16 25                 41
1752796 IN     school 1800840 1125   Clay Community Schools 180084000162 907 Staunton Elementary School   Regular School No Elementary KG 05 2019   grade_4                         16.0 31.0                       47.0                         16 31                 47
1757134 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2019   grade_4                         16.0 7.0                       23.0                         16 7                 23
1758516 IN     school 1804770 5385   Indianapolis Public Schools 180477000893 5574 Theodore Potter School 74   Regular School No Elementary KG 06 2019   grade_4                         16.0 22.0                       38.0                         16 22                 38
1758548 IN     school 1804770 5385   Indianapolis Public Schools 180477000829 5583 Floro Torrence School 83   Regular School No Elementary PK 06 2019   grade_4                         16.0 16.0                       32.0                         16 16                 32
1758861 IN     school 1809060 5485   Plymouth Community School Corp 180906001498 5961 Jefferson Elementary School   Regular School No Elementary PK 04 2019   grade_4                         16.0 29.0                       45.0                         16 29                 45
1760908 IN     school 1810020 7255   Scott County School District 2 181002001610 7637 Lexington Elementary School   Regular School No Elementary KG 05 2019   grade_4                         16.0 13.0                       29.0                         16 13                 29
1761070 IN     school 1808010 7385   North Spencer County Sch Corp 180801000167 7755 Nancy Hanks Elementary School   Regular School No Elementary PK 06 2019   grade_4                         16.0 14.0                       30.0                         16 14                 30
1761860 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001736 8431 Ernie Pyle Elementary School   Regular School No Elementary PK 05 2019   grade_4                         16.0 13.0                       29.0                         16 13                 29
1762053 IN     school 1812090 8030   Vigo County School Corp 181209001922 8609 West Vigo Elementary School   Regular School No Elementary PK 05 2019   grade_4                         16.0 17.0                       33.0                         16 17                 33
1763434 IN     school 1800124 9925   Phalen Leadership Academy - IN Inc 180012402550 5496 Phalen Leadership Academy - IN Inc   Regular School Yes Elementary KG 06 2019   grade_4                         16.0 20.0                       36.0                         16 20                 36
1753628 IN     school 1806600 2275   Middlebury Community Schools 180660002427 1731 Heritage Intermediate School   Regular School No Middle 04 06 2019   grade_4                         169.0 175.0                       344.0                         169 175                 344
1752445 IN     school 1800960 670   Brown County School Corporation 180096000172 585 Sprunica Elementary School   Regular School No Elementary PK 04 2019   grade_4                         17.0 25.0                       42.0                         17 25                 42
1753069 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000055 1169 Moores Hill Elementary School   Regular School No Elementary KG 06 2019   grade_4                         17.0 5.0                       22.0                         17 5                 22
1753448 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001746 1563 Pine Ridge Elementary School   Regular School No Elementary PK 04 2019   grade_4                         17.0 31.0                       48.0                         17 31                 48
1754187 IN     school 1802940 2725   East Gibson School Corporation 180294000384 2237 Oakland City Elementary School   Regular School No Elementary PK 06 2019   grade_4                         17.0 22.0                       39.0                         17 22                 39
1755309 IN     school 1807440 3445   New Castle Community School Corp 180744002156 2832 Eastwood Elementary School   Regular School No Elementary PK 06 2019   grade_4                         17.0 25.0                       42.0                         17 25                 42
1755506 IN     school 1805370 3500   Kokomo School Corporation 180537000956 2993 Pettit Park School   Regular School No Elementary PK 05 2019   grade_4                         17.0 7.0                       24.0                         17 7                 24
1755788 IN     school 1806120 3995   Madison Consolidated Schools 180612001093 3321 Rykers' Ridge Elementary School   Regular School No Elementary PK 04 2019   grade_4                         17.0 14.0                       31.0                         17 14                 31
1755858 IN     school 1805190 4015   Jennings County School Corporation 180519000922 3385 Hayden Elementary School   Regular School No Elementary KG 06 2019   grade_4                         17.0 23.0                       40.0                         17 23                 40
1757294 IN     school 1805580 4945   LaPorte Community School Corp 180558001016 4757 Lincoln Elementary School   Regular School No Elementary PK 05 2019   grade_4                         17.0 15.0                       32.0                         17 15                 32
1758396 IN     school 1804770 5385   Indianapolis Public Schools 180477000867 5548 Louis B Russell Jr School 48   Regular School No Elementary PK 06 2019   grade_4                         17.0 18.0                       35.0                         17 18                 35
1758730 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry School 27   Regular School No Elementary PK 08 2019   grade_4                         17.0 25.0                       42.0                         17 25                 42
1758778 IN     school 1810920 5400   School Town of Speedway 181092001780 5901 Arthur C Newby Elementary School 2   Regular School No Elementary KG 06 2019   grade_4                         17.0 13.0                       30.0                         17 13                 30
1759503 IN     school 1802970 6060   East Noble School Corporation 180297000393 6465 Rome City Elementary School   Regular School No Elementary PK 05 2019   grade_4                         17.0 17.0                       34.0                         17 17                 34

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