Data source: Big Local News · About: Big Local

3,050 rows where grade = "pre_kindergarten" and state = "IN" sorted by school_nces_id

View and edit SQL

year

grade

  • pre_kindergarten · 3,050
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
1162383 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         18.0 8.0                       26.0                         18 8                 26
1283793 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         18.0 15.0                       33.0                         18 15                 33
1295828 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2017   pre_kindergarten                         18.0 19.0                       37.0                         18 19                 37
1754437 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2019   pre_kindergarten                         31.0 15.0                       46.0                         31 15                 46
1790174 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   pre_kindergarten                         27.0 12.0                       39.0                         27 12                 39
1909870 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2020   pre_kindergarten                         24.0 16.0                       40.0                         24 16                 40
1921823 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   pre_kindergarten                         19.0 16.0                       35.0                         19 16                 35
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
1918319 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2020   pre_kindergarten                         4.0 3.0                       7.0                         4 3                 7
1930295 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   pre_kindergarten                         3.0 0.0                       3.0                         3 0                 3
1171066 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   pre_kindergarten                         3.0 3.0                       6.0                         3 3                 6
1292443 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2016   pre_kindergarten                         3.0 4.0                       7.0                         3 4                 7
1304476 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   pre_kindergarten                         4.0 2.0                       6.0                         4 2                 6
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
1798818 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2018   pre_kindergarten                         1.0 3.0                       4.0                         1 3                 4
1918557 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 2020   pre_kindergarten                         3.0 5.0                       8.0                         3 5                 8
1930552 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 2021   pre_kindergarten                         3.0 2.0                       5.0                         3 2                 5
1171081 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   pre_kindergarten                         18.0 20.0                       38.0                         18 20                 38
1292458 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2016   pre_kindergarten                         19.0 21.0                       40.0                         19 21                 40
1304491 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   pre_kindergarten                         3.0 13.0                       16.0                         3 13                 16
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
1798833 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2018   pre_kindergarten                         13.0 14.0                       27.0                         13 14                 27
1918572 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   pre_kindergarten                         15.0 11.0                       26.0                         15 11                 26
1930568 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   pre_kindergarten                         11.0 10.0                       21.0                         11 10                 21
1159529 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         17.0 8.0                       25.0                         17 8                 25
1280919 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2016   pre_kindergarten                         15.0 5.0                       20.0                         15 5                 20
1292981 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2017   pre_kindergarten                         19.0 8.0                       27.0                         19 8                 27
1751613 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2019   pre_kindergarten                         28.0 8.0                       36.0                         28 8                 36
1787354 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2018   pre_kindergarten                         20.0 10.0                       30.0                         20 10                 30
1907054 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2020   pre_kindergarten                         23.0 10.0                       33.0                         23 10                 33
1919020 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   pre_kindergarten                         23.0 7.0                       30.0                         23 7                 30
1292925 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         2.0 2.0                       4.0                         2 2                 4
1751557 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         4.0 1.0                       5.0                         4 1                 5
1787298 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         1.0 3.0                       4.0                         1 3                 4
1906998 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         13.0 13.0                       26.0                         13 13                 26
1918964 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         33.0 28.0                       61.0                         33 28                 61
1757141 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2019   pre_kindergarten                         8.0 5.0                       13.0                         8 5                 13
1792933 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2018   pre_kindergarten                         5.0 1.0                       6.0                         5 1                 6
1912577 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2020   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1924527 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2021   pre_kindergarten                         6.0 5.0                       11.0                         6 5                 11
1167822 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801578 6645 Rockville Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         11.0 1.0                       12.0                         11 1                 12
1289220 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801578 6645 Rockville Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         6.0 1.0                       7.0                         6 1                 7
1759735 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801578 6645 Rockville Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         5.0 2.0                       7.0                         5 2                 7
1915146 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801578 6645 Rockville Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         12.0 3.0                       15.0                         12 3                 15
1927023 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801578 6645 Rockville Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         16.0 4.0                       20.0                         16 4                 20
1167831 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801857 6647 Turkey Run Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         3.0 1.0                       4.0                         3 1                 4
1289229 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801857 6647 Turkey Run Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 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
1927031 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801857 6647 Turkey Run Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         0.0 1.0                       1.0                         0 1                 1
1165537 IN     school 1800120 5265   Alexandria Com School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No 1.0 PK 03 2015   pre_kindergarten                         1.0 1.0                       2.0                         1 1                 2
1286932 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No 1.0 PK 02 2016   pre_kindergarten                         11.0 9.0                       20.0                         11 9                 20
1298967 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2017   pre_kindergarten                         20.0 11.0                       31.0                         20 11                 31
1757498 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2019   pre_kindergarten                         22.0 20.0                       42.0                         22 20                 42
1793289 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                         17.0 18.0                       35.0                         17 18                 35
1912921 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2020   pre_kindergarten                         24.0 12.0                       36.0                         24 12                 36
1924842 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria Monroe Elementary Schoo   Regular School No Elementary PK 06 2021   pre_kindergarten                         21.0 15.0                       36.0                         21 15                 36
1165558 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No 1.0 PK PK 2015   pre_kindergarten                         195.0 118.0                       313.0                         195 118                 313
1286953 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No 1.0 PK PK 2016   pre_kindergarten                         206.0 137.0                       343.0                         206 137                 343
1298988 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         199.0 126.0                       325.0                         199 126                 325
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
1793315 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         190.0 129.0                       319.0                         190 129                 319
1912948 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         135.0 108.0                       243.0                         135 108                 243
1924873 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                         103.0 64.0                       167.0                         103 64                 167
1288288 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No 1.0 PK 06 2016   pre_kindergarten                         3.0 3.0                       6.0                         3 3                 6
1300311 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                         16.0 13.0                       29.0                         16 13                 29
1758815 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                         21.0 15.0                       36.0                         21 15                 36
1794628 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                         14.0 20.0                       34.0                         14 20                 34
1914232 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                         13.0 17.0                       30.0                         13 17                 30
1926114 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                         11.0 9.0                       20.0                         11 9                 20
1161995 IN     school 1800210 2435   Attica Consolidated Sch Corp 180021000049 2057 Attica Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         35.0 31.0                       66.0                         35 31                 66
1283406 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         33.0 25.0                       58.0                         33 25                 58
1295450 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten                         26.0 22.0                       48.0                         26 22                 48
1754058 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         33.0 24.0                       57.0                         33 24                 57
1789792 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         33.0 26.0                       59.0                         33 26                 59
1909484 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         40.0 25.0                       65.0                         40 25                 65
1921446 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         23.0 15.0                       38.0                         23 15                 38
1919989 IN     school 1800212 935   Borden-Henryville School Corp 180021201530 767 Henryville Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         14.0 3.0                       17.0                         14 3                 17
1920024 IN     school 1800213 945   Silver Creek School Corporation 180021302469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2021   pre_kindergarten                         18.0 9.0                       27.0                         18 9                 27
1161035 IN     school 1800240 1600   South Dearborn Com School Corp 180024000051 1197 Aurora Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         16.0 6.0                       22.0                         16 6                 22
1282438 IN     school 1800240 1600   South Dearborn Com School Corp 180024000051 1197 Aurora Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         7.0 11.0                       18.0                         7 11                 18
1294473 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000051 1197 Aurora Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten                         13.0 8.0                       21.0                         13 8                 21
1753091 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000051 1197 Aurora Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         4.0 1.0                       5.0                         4 1                 5
1788831 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000051 1197 Aurora Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         9.0 3.0                       12.0                         9 3                 12
1908522 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000051 1197 Aurora Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         12.0 7.0                       19.0                         12 7                 19
1920495 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000051 1197 Aurora Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         5.0 2.0                       7.0                         5 2                 7
1163069 IN     school 1800270 3315   Avon Community School Corp 180027000058 2734 White Oak Elementary School   Regular School No 1.0 PK 04 2015   pre_kindergarten                         66.0 49.0                       115.0                         66 49                 115
1284475 IN     school 1800270 3315   Avon Community School Corp 180027000058 2734 White Oak Elementary School   Regular School No 1.0 PK 04 2016   pre_kindergarten                         71.0 44.0                       115.0                         71 44                 115
1296513 IN     school 1800270 3315   Avon Community School Corp 180027000058 2734 White Oak Elementary School   Regular School No Elementary PK 04 2017   pre_kindergarten                         54.0 17.0                       71.0                         54 17                 71
1755129 IN     school 1800270 3315   Avon Community School Corp 180027000058 2734 White Oak Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         43.0 11.0                       54.0                         43 11                 54
1790867 IN     school 1800270 3315   Avon Community School Corp 180027000058 2734 White Oak Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         22.0 17.0                       39.0                         22 17                 39
1910574 IN     school 1800270 3315   Avon Community School Corp 180027000058 2734 White Oak Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         37.0 8.0                       45.0                         37 8                 45
1922526 IN     school 1800270 3315   Avon Community School Corp 180027000058 2734 White Oak Elementary School   Regular School No Elementary PK 04 2021   pre_kindergarten                         32.0 11.0                       43.0                         32 11                 43
1755122 IN     school 1800270 3315   Avon Community School Corp 180027000059 2733 Maple Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         28.0 12.0                       40.0                         28 12                 40
1790860 IN     school 1800270 3315   Avon Community School Corp 180027000059 2733 Maple Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         26.0 7.0                       33.0                         26 7                 33
1910567 IN     school 1800270 3315   Avon Community School Corp 180027000059 2733 Maple Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         3.0 1.0                       4.0                         3 1                 4
1922519 IN     school 1800270 3315   Avon Community School Corp 180027000059 2733 Maple Elementary School   Regular School No Elementary PK 04 2021   pre_kindergarten                         13.0 20.0                       33.0                         13 20                 33
1910602 IN     school 1800270 3315   Avon Community School Corp 180027002330 2739 Pine Tree Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         42.0 6.0                       48.0                         42 6                 48
1922554 IN     school 1800270 3315   Avon Community School Corp 180027002330 2739 Pine Tree Elementary School   Regular School No Elementary PK 04 2021   pre_kindergarten                         47.0 13.0                       60.0                         47 13                 60
1160120 IN     school 1800360 365   Bartholomew Con School Corp 180036000070 371 L F Smith Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                         12.0 15.0                       27.0                         12 15                 27
1281514 IN     school 1800360 365   Bartholomew Con School Corp 180036000070 371 L F Smith Elementary   Regular School No 1.0 PK 06 2016   pre_kindergarten                         17.0 12.0                       29.0                         17 12                 29

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