Data source: Big Local News · About: Big Local

1,046 rows where grade = "grade_2", state = "IN" and year = 2020 sorted by female

View and edit SQL

year

  • 2020 · 1,046

grade

  • grade_2 · 1,046
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
1907998 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 02 09 2020   grade_2                         1.0 0.0                       1.0                         1 0                 1
1918107 IN     school 1800205 8690   Dynamic Minds Academy 180020502673 8692 Dynamic Minds Academy   Regular School Yes Other KG 12 2020   grade_2                         1.0 0.0                       1.0                         1 0                 1
1918840 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other 01 12 2020   grade_2                         4.0 0.0                       4.0                         4 0                 4
1913639 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_2                         7.0 1.0                       8.0                         7 1                 8
1914399 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No Elementary KG 04 2020   grade_2                         0.0 1.0                       1.0                         0 1                 1
1916416 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 01 12 2020   grade_2                         1.0 1.0                       2.0                         1 1                 2
1917882 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2020   grade_2                         4.0 1.0                       5.0                         4 1                 5
1907696 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No Elementary PK 06 2020   grade_2                         19.0 10.0                       29.0                         19 10                 29
1910427 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elementary School   Regular School No Elementary PK 06 2020   grade_2                         10.0 10.0                       20.0                         10 10                 20
1914644 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001717 6258 Walnut Elementary School   Regular School No Elementary PK 05 2020   grade_2                         9.0 10.0                       19.0                         9 10                 19
1914710 IN     school 1803330 5910   Eminence Community School Corp 180333002274 6327 Eminence Elementary School   Regular School No Elementary PK 05 2020   grade_2                         13.0 10.0                       23.0                         13 10                 23
1915428 IN     school 1811970 6560   Valparaiso Community Schools 181197001882 6891 Central Elementary School   Regular School No Elementary KG 05 2020   grade_2                         7.0 10.0                       17.0                         7 10                 17
1915463 IN     school 1811970 6560   Valparaiso Community Schools 181197001887 6917 Northview Elementary School   Regular School No Elementary KG 05 2020   grade_2                         16.0 10.0                       26.0                         16 10                 26
1915935 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001447 7341 Madison Elementary School   Regular School No Elementary KG 05 2020   grade_2                         15.0 10.0                       25.0                         15 10                 25
1918751 IN     school 1800083 9835   The Bloomington Project School 180008302446 6215 The Bloomington Project School   Regular School Yes Elementary KG 08 2020   grade_2                         15.0 10.0                       25.0                         15 10                 25
1908034 IN     school   940   West Clark Community Schools   789 Silver Creek Elementary School             2020   grade_2                         97.0 101.0                       198.0                         97 101                 198
1908767 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2020   grade_2                         106.0 102.0                       208.0                         106 102                 208
1910893 IN     school 1804470 3490   Western School Corporation 180447000755 2935 Western Primary School   Regular School No Elementary KG 03 2020   grade_2                         94.0 102.0                       196.0                         94 102                 196
1909198 IN     school 1803270 2305   Elkhart Community Schools 180327000434 1769 Mary Beck Elementary School   Regular School No Elementary PK 06 2020   grade_2                         22.0 11.0                       33.0                         22 11                 33
1910419 IN     school 1810360 3190   South Harrison Com Schools 181036001698 2649 New Middletown Elementary School   Regular School No Elementary KG 06 2020   grade_2                         8.0 11.0                       19.0                         8 11                 19
1912740 IN     school 1807860 5075   North Lawrence Com Schools 180786001339 4857 Fayetteville Elementary School   Regular School No Elementary KG 05 2020   grade_2                         11.0 11.0                       22.0                         11 11                 22
1913909 IN     school 1804770 5385   Indianapolis Public Schools 180477000884 5565 Raymond F Brandes School 65   Regular School No Elementary PK 06 2020   grade_2                         20.0 11.0                       31.0                         20 11                 31
1913973 IN     school 1804770 5385   Indianapolis Public Schools 180477000829 5583 Floro Torrence School 83   Regular School No Elementary PK 06 2020   grade_2                         20.0 11.0                       31.0                         20 11                 31
1914031 IN     school 1804770 5385   Indianapolis Public Schools 180477002577 5597 Emma Donnan Elementary School   Regular School No Elementary KG 06 2020   grade_2                         18.0 11.0                       29.0                         18 11                 29
1914448 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000136 6123 Unionville Elementary School   Regular School No Elementary PK 06 2020   grade_2                         20.0 11.0                       31.0                         20 11                 31
1914631 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001714 6233 Ladoga Elementary School   Regular School No Elementary PK 05 2020   grade_2                         17.0 11.0                       28.0                         17 11                 28
1917028 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000475 8251 Lincoln School   Regular School No Elementary KG 08 2020   grade_2                         13.0 11.0                       24.0                         13 11                 24
1914440 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001707 6151 Edgewood Primary School   Regular School No Elementary KG 02 2020   grade_2                         88.0 111.0                       199.0                         88 111                 199
1907438 IN     school 1803630 235   Fort Wayne Community Schools 180363000567 265 Washington Elementary School   Regular School No Elementary PK 05 2020   grade_2                         20.0 12.0                       32.0                         20 12                 32
1908262 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elementary School   Regular School No Elementary PK 05 2020   grade_2                         23.0 12.0                       35.0                         23 12                 35
1908344 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000281 1037 South Crawford Elementary School   Regular School No Elementary PK 05 2020   grade_2                         14.0 12.0                       26.0                         14 12                 26
1909352 IN     school 1803510 2395   Fayette County School Corporation 180351000503 1909 Frazee Elementary School   Regular School No Elementary KG 06 2020   grade_2                         30.0 12.0                       42.0                         30 12                 42
1909587 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Township Elementary   Regular School No Elementary KG 06 2020   grade_2                         4.0 12.0                       16.0                         4 12                 16
1914077 IN     school 1804770 5385   Indianapolis Public Schools 180477000858 5609 Jonathan Jennings School 109   Regular School No Elementary KG 06 2020   grade_2                         22.0 12.0                       34.0                         22 12                 34
1914718 IN     school 1806510 5925   M S D Martinsville Schools 180651001132 6309 Green Township Elementary School   Regular School No Elementary KG 04 2020   grade_2                         24.0 12.0                       36.0                         24 12                 36
1917614 IN     school 1812390 8130   Warrick County School Corp 181239001980 8769 Elberfeld Elementary School   Regular School No Elementary KG 05 2020   grade_2                         11.0 12.0                       23.0                         11 12                 23
1908246 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No Elementary PK 05 2020   grade_2                         19.0 13.0                       32.0                         19 13                 32
1908633 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000226 1341 Waterloo Elementary School   Regular School No Elementary PK 05 2020   grade_2                         12.0 13.0                       25.0                         12 13                 25
1909360 IN     school 1803510 2395   Fayette County School Corporation 180351000504 1913 Grandview Elementary School   Regular School No Elementary PK 06 2020   grade_2                         23.0 13.0                       36.0                         23 13                 36
1910465 IN     school 1808100 3295   North West Hendricks Schools 180810001385 2685 North Salem Elementary School   Regular School No Elementary KG 05 2020   grade_2                         19.0 13.0                       32.0                         19 13                 32
1911213 IN     school 1806120 3995   Madison Consolidated Schools 180612001085 3301 Deputy Elementary School   Regular School No Elementary PK 04 2020   grade_2                         7.0 13.0                       20.0                         7 13                 20
1911283 IN     school 1805190 4015   Jennings County School Corporation 180519000927 3357 Scipio Elementary School   Regular School No Elementary KG 06 2020   grade_2                         18.0 13.0                       31.0                         18 13                 31
1912321 IN     school 1804320 4710   School City of Hammond 180432000731 4451 Benjamin Franklin Elementary Sch   Regular School No Elementary KG 05 2020   grade_2                         23.0 13.0                       36.0                         23 13                 36
1914737 IN     school 1806510 5925   M S D Martinsville Schools 180651001128 6337 Brooklyn STEM Academy   Regular School No Elementary PK 04 2020   grade_2                         27.0 13.0                       40.0                         27 13                 40
1914772 IN     school 1806510 5925   M S D Martinsville Schools 180651001139 6361 Poston Road Elementary School   Regular School No Elementary PK 04 2020   grade_2                         38.0 13.0                       51.0                         38 13                 51
1915148 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801857 6647 Turkey Run Elementary School   Regular School No Elementary KG 05 2020   grade_2                         16.0 13.0                       29.0                         16 13                 29
1915557 IN     school 1809360 6630   West Central School Corp 180936002213 7027 West Central Elementary School   Regular School No Elementary KG 05 2020   grade_2                         22.0 13.0                       35.0                         22 13                 35
1915845 IN     school 1809750 6995   Rush County Schools 180975001591 7253 Arlington Elementary School   Regular School No Elementary KG 06 2020   grade_2                         18.0 13.0                       31.0                         18 13                 31
1916458 IN     school 1808010 7385   North Spencer County Sch Corp 180801001373 7751 Chrisney Elementary School   Regular School No Elementary PK 06 2020   grade_2                         12.0 13.0                       25.0                         12 13                 25
1916602 IN     school 1804230 7610   Hamilton Community Schools 180423000723 7889 Hamilton Community Elementary Sch   Regular School No Elementary KG 06 2020   grade_2                         8.0 13.0                       21.0                         8 13                 21
1916641 IN     school 1811100 7615   M S D Steuben County 181110001801 7905 Pleasant Lake Elementary School   Regular School No Elementary KG 05 2020   grade_2                         8.0 13.0                       21.0                         8 13                 21
1907097 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2020   grade_2                         13.0 14.0                       27.0                         13 14                 27
1909611 IN     school 1802940 2725   East Gibson School Corporation 180294000384 2237 Oakland City Elementary School   Regular School No Elementary PK 06 2020   grade_2                         19.0 14.0                       33.0                         19 14                 33
1909718 IN     school 1806240 2825   Madison-Grant United School Corp 180624001100 5037 Summitville School   Regular School No Elementary PK 06 2020   grade_2                         16.0 14.0                       30.0                         16 14                 30
1911183 IN     school 1804980 3945   Jay School Corporation 180498000917 3247 Redkey Elementary School   Regular School No Elementary KG 05 2020   grade_2                         20.0 14.0                       34.0                         20 14                 34
1911453 IN     school 1803690 4225   Franklin Community School Corp 180369000585 3433 Union Elementary School   Regular School No Elementary KG 04 2020   grade_2                         17.0 14.0                       31.0                         17 14                 31
1912772 IN     school 1807860 5075   North Lawrence Com Schools 180786001344 4885 Dollens Elementary School   Regular School No Elementary KG 05 2020   grade_2                         25.0 14.0                       39.0                         25 14                 39
1913760 IN     school 1804770 5385   Indianapolis Public Schools 180477000866 5531 James A Garfield School 31   Regular School No Elementary KG 08 2020   grade_2                         13.0 14.0                       27.0                         13 14                 27
1914002 IN     school 1804770 5385   Indianapolis Public Schools 180477000826 5590 Ernie Pyle School 90   Regular School No Elementary PK 06 2020   grade_2                         15.0 14.0                       29.0                         15 14                 29
1914744 IN     school 1806510 5925   M S D Martinsville Schools 180651001129 6341 Centerton Elementary School   Regular School No Elementary KG 04 2020   grade_2                         10.0 14.0                       24.0                         10 14                 24
1914836 IN     school 1807920 5945   North Newton School Corp 180792001359 6405 Lake Village Elementary School   Regular School No Elementary KG 06 2020   grade_2                         19.0 14.0                       33.0                         19 14                 33
1915743 IN     school 1801770 6825   Randolph Central School Corp 180177002191 7146 Deerfield Elementary School   Regular School No Elementary PK 05 2020   grade_2                         18.0 14.0                       32.0                         18 14                 32
1916314 IN     school 1810020 7255   Scott County School District 2 181002001610 7637 Lexington Elementary School   Regular School No Elementary PK 05 2020   grade_2                         18.0 14.0                       32.0                         18 14                 32
1918181 IN     school 1800196 9060   Paramount Community Heights 180019602643 139 Paramount Community Heights   Regular School Yes Elementary KG 05 2020   grade_2                         10.0 14.0                       24.0                         10 14                 24
1918883 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2020   grade_2                         17.0 14.0                       31.0                         17 14                 31
1907720 IN     school 1800570 515   Blackford County Schools 180057000107 485 Montpelier School   Regular School No Elementary KG 06 2020   grade_2                         18.0 15.0                       33.0                         18 15                 33
1910950 IN     school 1805370 3500   Kokomo School Corporation 180537000956 2993 Pettit Park School   Regular School No Elementary PK 05 2020   grade_2                         19.0 15.0                       34.0                         19 15                 34
1913868 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2020   grade_2                         24.0 15.0                       39.0                         24 15                 39
1914146 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry School 27   Regular School No Elementary PK 08 2020   grade_2                         30.0 15.0                       45.0                         30 15                 45
1914765 IN     school 1806510 5925   M S D Martinsville Schools 180651001138 6357 Paragon Elementary School   Regular School No Elementary PK 04 2020   grade_2                         16.0 15.0                       31.0                         16 15                 31
1914819 IN     school 1807140 5930   Mooresville Con School Corp 180714001213 6393 Waverly Elementary School   Regular School No Elementary PK 06 2020   grade_2                         26.0 15.0                       41.0                         26 15                 41
1914844 IN     school 1807920 5945   North Newton School Corp 180792001360 6409 Lincoln Elementary School   Regular School No Elementary KG 06 2020   grade_2                         23.0 15.0                       38.0                         23 15                 38
1917858 IN     school 1809510 8385   Richmond Community Schools 180951002455 9038 Starr Elementary School   Regular School No Elementary PK 04 2020   grade_2                         23.0 15.0                       38.0                         23 15                 38
1918465 IN     school 1800037 9495   Joshua Academy 180003702146 8203 Joshua Academy   Regular School Yes Elementary KG 07 2020   grade_2                         19.0 15.0                       34.0                         19 15                 34
1918680 IN     school 1800129 9725   Canaan Community Academy 180012902534 3312 Canaan Community Academy   Regular School Yes Elementary KG 06 2020   grade_2                         5.0 15.0                       20.0                         5 15                 20
1918941 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2020   grade_2                         12.0 15.0                       27.0                         12 15                 27
1908158 IN     school 1803940 1010   Greater Clark County Schools 180394000668 869 Maple Elementary School   Regular School No Elementary KG 05 2020   grade_2                         12.0 16.0                       28.0                         12 16                 28
1908902 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001776 1529 Holland Elementary School   Regular School No Elementary PK 05 2020   grade_2                         22.0 16.0                       38.0                         22 16                 38
1910703 IN     school 1800660 3405   Blue River Valley Schools 180066000140 2803 Blue River Valley Elementary Sch   Regular School No Elementary PK 06 2020   grade_2                         23.0 16.0                       39.0                         23 16                 39
1910754 IN     school 1807440 3445   New Castle Community School Corp 180744002156 2832 Eastwood Elementary School   Regular School No Elementary PK 06 2020   grade_2                         16.0 16.0                       32.0                         16 16                 32
1911114 IN     school 1812060 3710   Crothersville Community Schools 181206001892 3122 Crothersville Elementary School   Regular School No Elementary PK 05 2020   grade_2                         19.0 16.0                       35.0                         19 16                 35
1911206 IN     school 1804980 3945   Jay School Corporation 180498000919 3289 Westlawn Elementary School   Regular School No Elementary KG 05 2020   grade_2                         26.0 16.0                       42.0                         26 16                 42
1911231 IN     school 1806120 3995   Madison Consolidated Schools 180612001093 3321 Rykers' Ridge Elementary School   Regular School No Elementary PK 04 2020   grade_2                         16.0 16.0                       32.0                         16 16                 32
1912579 IN     school 1806570 4925   Michigan City Area Schools 180657001143 4373 Coolspring Elementary School   Regular School No Elementary KG 06 2020   grade_2                         17.0 16.0                       33.0                         17 16                 33
1913889 IN     school 1804770 5385   Indianapolis Public Schools 180477000883 5558 Ralph Waldo Emerson School 58   Regular School No Elementary PK 06 2020   grade_2                         20.0 16.0                       36.0                         20 16                 36
1914202 IN     school 1810920 5400   School Town of Speedway 181092001782 5905 Frank H Wheeler Elementary Sch 4   Regular School No Elementary KG 06 2020   grade_2                         19.0 16.0                       35.0                         19 16                 35
1914278 IN     school 1809060 5485   Plymouth Community School Corp 180906001498 5961 Jefferson Elementary School   Regular School No Elementary PK 04 2020   grade_2                         29.0 16.0                       45.0                         29 16                 45
1914318 IN     school 1810170 5520   Shoals Community School Corp 181017001634 5989 Shoals Community Elementary School   Regular School No Elementary PK 05 2020   grade_2                         20.0 16.0                       36.0                         20 16                 36
1914750 IN     school 1806510 5925   M S D Martinsville Schools 180651002355 6344 South Elementary School   Regular School No Elementary PK 05 2020   grade_2                         27.0 16.0                       43.0                         27 16                 43
1916089 IN     school 1810290 7205   South Bend Community School Corp 181029001683 7417 Warren Elementary School   Regular School No Elementary KG 05 2020   grade_2                         18.0 16.0                       34.0                         18 16                 34
1916503 IN     school 1810560 7445   South Spencer County Sch Corp 181056001731 7789 Luce Elementary School   Regular School No Elementary KG 05 2020   grade_2                         20.0 16.0                       36.0                         20 16                 36
1916619 IN     school 1811100 7615   M S D Steuben County 181110001799 7897 Carlin Park Elementary School   Regular School No Elementary PK 05 2020   grade_2                         25.0 16.0                       41.0                         25 16                 41
1916672 IN     school 1810860 7715   Southwest School Corporation 181086001770 7953 Carlisle Elementary School   Regular School No Elementary PK 05 2020   grade_2                         18.0 16.0                       34.0                         18 16                 34
1917281 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001741 8435 Van Duyn Elementary School   Regular School No Elementary PK 05 2020   grade_2                         25.0 16.0                       41.0                         25 16                 41
1918872 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2020   grade_2                         18.0 16.0                       34.0                         18 16                 34
1908048 IN     school   940   West Clark Community Schools   815 William W Borden Elementary School             2020   grade_2                         24.0 17.0                       41.0                         24 17                 41
1908173 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No Elementary PK 05 2020   grade_2                         14.0 17.0                       31.0                         14 17                 31
1911044 IN     school 1810080 3675   Seymour Community Schools 181008001615 3105 Cortland Elementary School   Regular School No Elementary KG 05 2020   grade_2                         9.0 17.0                       26.0                         9 17                 26
1911601 IN     school 1812120 4335   Vincennes Community School Corp 181212001929 3573 James Whitcomb Riley Elem Sch   Regular School No Elementary KG 05 2020   grade_2                         17.0 17.0                       34.0                         17 17                 34
1913740 IN     school 1804770 5385   Indianapolis Public Schools 180477000814 5498 Cold Spring School   Regular School No Elementary KG 06 2020   grade_2                         27.0 17.0                       44.0                         27 17                 44

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