enrollments

Data source: Big Local News · About: Big Local

12,019 rows where state = "IN" and year = 2018 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2018 · 12,019 ✖
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
1787852 1787852 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2018   pk_12_total 36.0 4.0 6.0     2.0             32.0 16.0     0.0         24.0   43.0   48.0 36 4 6     2             32 16     0     24 43   48
1787853 1787853 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2018   pre_kindergarten                         32.0 16.0                       48.0                         32 16                 48
1790091 1790091 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2018   grade_10                         1.0 0.0                       1.0                         1 0                 1
1790092 1790092 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2018   pk_12_total 1.0                       1.0 0.0     0.0             0.0   1.0 1                       1 0     0       0   1
1793997 1793997 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_1                         2.0 2.0                       4.0                         2 2                 4
1793998 1793998 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_10                         12.0 1.0                       13.0                         12 1                 13
1793999 1793999 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_11                         8.0 0.0                       8.0                         8 0                 8
1794000 1794000 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_12                         5.0 0.0                       5.0                         5 0                 5
1794001 1794001 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_2                         7.0 0.0                       7.0                         7 0                 7
1794002 1794002 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_3                         3.0 0.0                       3.0                         3 0                 3
1794003 1794003 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_4                         11.0 2.0                       13.0                         11 2                 13
1794004 1794004 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_5                         5.0 2.0                       7.0                         5 2                 7
1794005 1794005 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_6                         5.0 1.0                       6.0                         5 1                 6
1794006 1794006 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_7                         4.0 1.0                       5.0                         4 1                 5
1794007 1794007 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_8                         7.0 1.0                       8.0                         7 1                 8
1794008 1794008 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_9                         10.0 1.0                       11.0                         10 1                 11
1794009 1794009 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1794010 1794010 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   pk_12_total 46.0 30.0 7.0               8.0   80.0 11.0     6.0         58.0   88.0   91.0 46 30 7               8   80 11     6     58 88   91
1796657 1796657 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2018   pk_12_total 90.0 38.0 33.0               17.0   120.0 58.0     0.0         87.0   119.0   178.0 90 38 33               17   120 58     0     87 119   178
1796658 1796658 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2018   pre_kindergarten                         120.0 58.0                       178.0                         120 58                 178
1787488 1787488 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_1                         30.0 31.0                       61.0                         30 31                 61
1787489 1787489 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_2                         43.0 33.0                       76.0                         43 33                 76
1787490 1787490 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_3                         39.0 39.0                       78.0                         39 39                 78
1787491 1787491 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_4                         30.0 35.0                       65.0                         30 35                 65
1787492 1787492 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_5                         32.0 38.0                       70.0                         32 38                 70
1787493 1787493 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_6                         46.0 40.0                       86.0                         46 40                 86
1787494 1787494 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_7                         41.0 43.0                       84.0                         41 43                 84
1787495 1787495 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_8                         39.0 38.0                       77.0                         39 38                 77
1787496 1787496 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   pk_12_total 249.0 136.0 135.0 4.0   18.0     1.0   54.0   300.0 297.0     58.0         331.0   82.0   597.0 249 136 135 4   18     1   54   300 297     58     331 82   597
1787529 1787529 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2018   grade_1                         67.0 56.0                       123.0                         67 56                 123
1787530 1787530 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2018   grade_2                         62.0 58.0                       120.0                         62 58                 120
1787531 1787531 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2018   grade_3                         57.0 66.0                       123.0                         57 66                 123
1787532 1787532 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2018   grade_4                         50.0 56.0                       106.0                         50 56                 106
1787533 1787533 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2018   grade_5                         61.0 49.0                       110.0                         61 49                 110
1787534 1787534 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2018   pk_12_total 229.0 195.0 104.0 3.0   7.0     3.0   41.0   297.0 285.0     46.0         365.0   77.0   582.0 229 195 104 3   7     3   41   297 285     46     365 77   582
1789473 1789473 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   adult                         1.0 0.0                       1.0                         1 0                 1
1789474 1789474 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_1                         0.0 1.0                       1.0                         0 1                 1
1789475 1789475 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_10                         25.0 19.0                       44.0                         25 19                 44
1789476 1789476 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_11                         44.0 43.0                       87.0                         44 43                 87
1789477 1789477 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_12                         58.0 82.0                       140.0                         58 82                 140
1789478 1789478 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_2                         1.0 2.0                       3.0                         1 2                 3
1789479 1789479 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_3                         3.0 0.0                       3.0                         3 0                 3
1789480 1789480 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_4                         5.0 0.0                       5.0                         5 0                 5
1789481 1789481 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_5                         3.0 0.0                       3.0                         3 0                 3
1789482 1789482 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_6                         4.0 3.0                       7.0                         4 3                 7
1789483 1789483 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_7                         3.0 2.0                       5.0                         3 2                 5
1789484 1789484 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_8                         8.0 8.0                       16.0                         8 8                 16
1789485 1789485 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_9                         12.0 9.0                       21.0                         12 9                 21
1789486 1789486 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   pk_12_total 136.0 90.0 78.0     1.0         31.0   167.0 169.0     32.0         215.0   89.0   336.0 136 90 78     1         31   167 169     32     215 89   336
1791062 1791062 IN     school 1807440 3445   New Castle Community School Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No Elementary 01 06 2018   grade_1                         18.0 17.0                       35.0                         18 17                 35
1791063 1791063 IN     school 1807440 3445   New Castle Community School Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No Elementary 01 06 2018   grade_2                         19.0 19.0                       38.0                         19 19                 38
1791064 1791064 IN     school 1807440 3445   New Castle Community School Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No Elementary 01 06 2018   grade_3                         12.0 29.0                       41.0                         12 29                 41
1791065 1791065 IN     school 1807440 3445   New Castle Community School Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No Elementary 01 06 2018   grade_4                         18.0 19.0                       37.0                         18 19                 37
1791066 1791066 IN     school 1807440 3445   New Castle Community School Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No Elementary 01 06 2018   grade_5                         26.0 31.0                       57.0                         26 31                 57
1791067 1791067 IN     school 1807440 3445   New Castle Community School Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No Elementary 01 06 2018   grade_6                         25.0 20.0                       45.0                         25 20                 45
1791068 1791068 IN     school 1807440 3445   New Castle Community School Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No Elementary 01 06 2018   pk_12_total 216.0 5.0 13.0     4.0         15.0   118.0 135.0     3.0         113.0   35.0   253.0 216 5 13     4         15   118 135     3     113 35   253
1791077 1791077 IN     school 1807440 3445   New Castle Community School Corp 180744001291 2861 Westwood Elementary School   Regular School No Elementary 01 06 2018   grade_1                         21.0 17.0                       38.0                         21 17                 38
1791078 1791078 IN     school 1807440 3445   New Castle Community School Corp 180744001291 2861 Westwood Elementary School   Regular School No Elementary 01 06 2018   grade_2                         15.0 25.0                       40.0                         15 25                 40
1791079 1791079 IN     school 1807440 3445   New Castle Community School Corp 180744001291 2861 Westwood Elementary School   Regular School No Elementary 01 06 2018   grade_3                         14.0 31.0                       45.0                         14 31                 45
1791080 1791080 IN     school 1807440 3445   New Castle Community School Corp 180744001291 2861 Westwood Elementary School   Regular School No Elementary 01 06 2018   grade_4                         16.0 13.0                       29.0                         16 13                 29
1791081 1791081 IN     school 1807440 3445   New Castle Community School Corp 180744001291 2861 Westwood Elementary School   Regular School No Elementary 01 06 2018   grade_5                         20.0 24.0                       44.0                         20 24                 44
1791082 1791082 IN     school 1807440 3445   New Castle Community School Corp 180744001291 2861 Westwood Elementary School   Regular School No Elementary 01 06 2018   grade_6                         22.0 28.0                       50.0                         22 28                 50
1791083 1791083 IN     school 1807440 3445   New Castle Community School Corp 180744001291 2861 Westwood Elementary School   Regular School No Elementary 01 06 2018   pk_12_total 222.0 2.0 9.0     2.0         11.0   108.0 138.0     0.0         91.0   27.0   246.0 222 2 9     2         11   108 138     0     91 27   246
1792804 1792804 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2018   grade_1                         45.0 56.0                       101.0                         45 56                 101
1792805 1792805 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2018   grade_2                         48.0 43.0                       91.0                         48 43                 91
1792806 1792806 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2018   grade_3                         49.0 38.0                       87.0                         49 38                 87
1792807 1792807 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2018   grade_4                         40.0 50.0                       90.0                         40 50                 90
1792808 1792808 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2018   grade_5                         42.0 37.0                       79.0                         42 37                 79
1792809 1792809 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2018   pk_12_total 281.0 39.0 106.0 1.0   9.0         12.0   224.0 224.0     11.0         241.0   65.0   448.0 281 39 106 1   9         12   224 224     11     241 65   448
1792810 1792810 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 05 2018   grade_1                         30.0 25.0                       55.0                         30 25                 55
1792811 1792811 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 05 2018   grade_2                         35.0 20.0                       55.0                         35 20                 55
1792812 1792812 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 05 2018   grade_3                         29.0 28.0                       57.0                         29 28                 57
1792813 1792813 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 05 2018   grade_4                         28.0 29.0                       57.0                         28 29                 57
1792814 1792814 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 05 2018   grade_5                         29.0 28.0                       57.0                         29 28                 57
1792815 1792815 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 05 2018   pk_12_total 186.0 15.0 63.0 1.0   1.0         15.0   151.0 130.0     8.0         197.0   53.0   281.0 186 15 63 1   1         15   151 130     8     197 53   281
1793372 1793372 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2018   grade_1                         60.0 48.0                       108.0                         60 48                 108
1793373 1793373 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2018   grade_2                         48.0 38.0                       86.0                         48 38                 86
1793374 1793374 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2018   grade_3                         63.0 55.0                       118.0                         63 55                 118
1793375 1793375 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2018   grade_4                         57.0 46.0                       103.0                         57 46                 103
1793376 1793376 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2018   grade_5                         47.0 62.0                       109.0                         47 62                 109
1793377 1793377 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2018   grade_6                         51.0 58.0                       109.0                         51 58                 109
1793378 1793378 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2018   pk_12_total 441.0 80.0 66.0 2.0         1.0   43.0   326.0 307.0     37.0         461.0   107.0   633.0 441 80 66 2         1   43   326 307     37     461 107   633
1793379 1793379 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2018   grade_1                         57.0 63.0                       120.0                         57 63                 120
1793380 1793380 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2018   grade_2                         56.0 52.0                       108.0                         56 52                 108
1793381 1793381 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2018   grade_3                         57.0 58.0                       115.0                         57 58                 115
1793382 1793382 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2018   grade_4                         60.0 56.0                       116.0                         60 56                 116
1793383 1793383 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2018   grade_5                         61.0 51.0                       112.0                         61 51                 112
1793384 1793384 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2018   grade_6                         58.0 56.0                       114.0                         58 56                 114
1793385 1793385 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2018   pk_12_total 432.0 110.0 86.0 3.0   5.0     1.0   48.0   349.0 336.0     78.0         467.0   82.0   685.0 432 110 86 3   5     1   48   349 336     78     467 82   685
1793389 1793389 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2018   grade_1                         36.0 40.0                       76.0                         36 40                 76
1793390 1793390 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2018   grade_2                         40.0 43.0                       83.0                         40 43                 83
1793391 1793391 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2018   grade_3                         40.0 44.0                       84.0                         40 44                 84
1793392 1793392 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2018   grade_4                         43.0 43.0                       86.0                         43 43                 86
1793393 1793393 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2018   grade_5                         59.0 38.0                       97.0                         59 38                 97
1793394 1793394 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2018   grade_6                         50.0 30.0                       80.0                         50 30                 80
1793395 1793395 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2018   pk_12_total 320.0 83.0 66.0     2.0         35.0   268.0 238.0     28.0         377.0   89.0   506.0 320 83 66     2         35   268 238     28     377 89   506
1793396 1793396 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2018   grade_1                         41.0 43.0                       84.0                         41 43                 84
1793397 1793397 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2018   grade_2                         48.0 46.0                       94.0                         48 46                 94
1793398 1793398 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2018   grade_3                         54.0 58.0                       112.0                         54 58                 112
1793399 1793399 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2018   grade_4                         53.0 54.0                       107.0                         53 54                 107

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