Data source: Big Local News · About: Big Local

11,992 rows where state = "IN" and year = 2019 sorted by ccd_school_low_grade

View and edit SQL

grade

year

  • 2019 · 11,992
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
1752107 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2019   pk_12_total 36.0 1.0 6.0     2.0         1.0   33.0 13.0     0.0         17.0   38.0   46.0 36 1 6     2         1   33 13     0     17 38   46
1752108 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2019   pre_kindergarten                         33.0 13.0                       46.0                         33 13                 46
1754356 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2019   grade_11                         1.0 0.0                       1.0                         1 0                 1
1754357 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2019   pk_12_total 1.0                       1.0 0.0     0.0             0.0   1.0 1                       1 0     0       0   1
1758207 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_1                         6.0 0.0                       6.0                         6 0                 6
1758208 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_10                         5.0 2.0                       7.0                         5 2                 7
1758209 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_11                         6.0 0.0                       6.0                         6 0                 6
1758210 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_12                         6.0 0.0                       6.0                         6 0                 6
1758211 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_2                         7.0 1.0                       8.0                         7 1                 8
1758212 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_3                         5.0 0.0                       5.0                         5 0                 5
1758213 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_4                         3.0 0.0                       3.0                         3 0                 3
1758214 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_5                         6.0 1.0                       7.0                         6 1                 7
1758215 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_6                         7.0 4.0                       11.0                         7 4                 11
1758216 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_7                         7.0 1.0                       8.0                         7 1                 8
1758217 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_8                         5.0 1.0                       6.0                         5 1                 6
1758218 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_9                         10.0 0.0                       10.0                         10 0                 10
1758219 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1758220 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   pk_12_total 40.0 35.0 2.0               7.0   74.0 10.0     4.0         51.0   82.0   84.0 40 35 2               7   74 10     4     51 82   84
1760847 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2019   pk_12_total 86.0 47.0 39.0     2.0         45.0   132.0 87.0     0.0         12.0   99.0   219.0 86 47 39     2         45   132 87     0     12 99   219
1760848 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2019   pre_kindergarten                         132.0 87.0                       219.0                         132 87                 219
1751744 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_1                         40.0 31.0                       71.0                         40 31                 71
1751745 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_2                         31.0 35.0                       66.0                         31 35                 66
1751746 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_3                         37.0 31.0                       68.0                         37 31                 68
1751747 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_4                         41.0 35.0                       76.0                         41 35                 76
1751748 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_5                         32.0 40.0                       72.0                         32 40                 72
1751749 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_6                         33.0 40.0                       73.0                         33 40                 73
1751750 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_7                         45.0 43.0                       88.0                         45 43                 88
1751751 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_8                         43.0 42.0                       85.0                         43 42                 85
1751752 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   pk_12_total 258.0 138.0 128.0 5.0   17.0     2.0   51.0   302.0 297.0     61.0         295.0   90.0   599.0 258 138 128 5   17     2   51   302 297     61     295 90   599
1751785 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2019   grade_1                         59.0 59.0                       118.0                         59 59                 118
1751786 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2019   grade_2                         67.0 55.0                       122.0                         67 55                 122
1751787 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2019   grade_3                         62.0 60.0                       122.0                         62 60                 122
1751788 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2019   grade_4                         58.0 67.0                       125.0                         58 67                 125
1751789 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2019   grade_5                         53.0 59.0                       112.0                         53 59                 112
1751790 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2019   pk_12_total 226.0 205.0 105.0 3.0   11.0     2.0   47.0   299.0 300.0     64.0         356.0   73.0   599.0 226 205 105 3   11     2   47   299 300     64     356 73   599
1757012 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2019   grade_1                         43.0 61.0                       104.0                         43 61                 104
1757013 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2019   grade_2                         46.0 55.0                       101.0                         46 55                 101
1757014 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2019   grade_3                         48.0 38.0                       86.0                         48 38                 86
1757015 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2019   grade_4                         48.0 43.0                       91.0                         48 43                 91
1757016 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2019   grade_5                         41.0 45.0                       86.0                         41 45                 86
1757017 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2019   pk_12_total 295.0 42.0 114.0 2.0   8.0         7.0   226.0 242.0     10.0         246.0   70.0   468.0 295 42 114 2   8         7   226 242     10     246 70   468
1757018 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 05 2019   grade_1                         40.0 34.0                       74.0                         40 34                 74
1757019 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 05 2019   grade_2                         32.0 25.0                       57.0                         32 25                 57
1757020 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 05 2019   grade_3                         38.0 17.0                       55.0                         38 17                 55
1757021 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 05 2019   grade_4                         30.0 26.0                       56.0                         30 26                 56
1757022 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 05 2019   grade_5                         27.0 29.0                       56.0                         27 29                 56
1757023 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 05 2019   pk_12_total 193.0 24.0 60.0 3.0   1.0         17.0   167.0 131.0     7.0         201.0   51.0   298.0 193 24 60 3   1         17   167 131     7     201 51   298
1757581 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2019   grade_1                         55.0 33.0                       88.0                         55 33                 88
1757582 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2019   grade_2                         58.0 46.0                       104.0                         58 46                 104
1757583 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2019   grade_3                         52.0 45.0                       97.0                         52 45                 97
1757584 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2019   grade_4                         61.0 58.0                       119.0                         61 58                 119
1757585 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2019   grade_5                         61.0 51.0                       112.0                         61 51                 112
1757586 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2019   grade_6                         52.0 72.0                       124.0                         52 72                 124
1757587 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2019   pk_12_total 442.0 86.0 73.0 2.0   1.0     1.0   39.0   339.0 305.0     40.0         460.0   92.0   644.0 442 86 73 2   1     1   39   339 305     40     460 92   644
1757588 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2019   grade_1                         62.0 52.0                       114.0                         62 52                 114
1757589 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2019   grade_2                         54.0 61.0                       115.0                         54 61                 115
1757590 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2019   grade_3                         56.0 52.0                       108.0                         56 52                 108
1757591 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2019   grade_4                         57.0 68.0                       125.0                         57 68                 125
1757592 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2019   grade_5                         69.0 61.0                       130.0                         69 61                 130
1757593 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2019   grade_6                         68.0 52.0                       120.0                         68 52                 120
1757594 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2019   pk_12_total 422.0 137.0 91.0 2.0   7.0         53.0   366.0 346.0     86.0         540.0   97.0   712.0 422 137 91 2   7         53   366 346     86     540 97   712
1757598 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2019   grade_1                         36.0 45.0                       81.0                         36 45                 81
1757599 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2019   grade_2                         32.0 40.0                       72.0                         32 40                 72
1757600 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2019   grade_3                         45.0 39.0                       84.0                         45 39                 84
1757601 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2019   grade_4                         45.0 35.0                       80.0                         45 35                 80
1757602 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2019   grade_5                         35.0 42.0                       77.0                         35 42                 77
1757603 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2019   grade_6                         50.0 37.0                       87.0                         50 37                 87
1757604 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2019   pk_12_total 299.0 76.0 65.0 2.0   6.0     2.0   31.0   243.0 238.0     47.0         374.0   87.0   481.0 299 76 65 2   6     2   31   243 238     47     374 87   481
1757605 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2019   grade_1                         47.0 59.0                       106.0                         47 59                 106
1757606 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2019   grade_2                         51.0 50.0                       101.0                         51 50                 101
1757607 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2019   grade_3                         51.0 47.0                       98.0                         51 47                 98
1757608 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2019   grade_4                         65.0 58.0                       123.0                         65 58                 123
1757609 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2019   grade_5                         58.0 53.0                       111.0                         58 53                 111
1757610 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2019   grade_6                         52.0 48.0                       100.0                         52 48                 100
1757611 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2019   pk_12_total 477.0 56.0 63.0 1.0   3.0         39.0   324.0 315.0     41.0         443.0   100.0   639.0 477 56 63 1   3         39   324 315     41     443 100   639
1757617 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2019   grade_1                         60.0 43.0                       103.0                         60 43                 103
1757618 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2019   grade_2                         47.0 57.0                       104.0                         47 57                 104
1757619 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2019   grade_3                         53.0 50.0                       103.0                         53 50                 103
1757620 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2019   grade_4                         44.0 48.0                       92.0                         44 48                 92
1757621 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2019   grade_5                         49.0 55.0                       104.0                         49 55                 104
1757622 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2019   grade_6                         60.0 50.0                       110.0                         60 50                 110
1757623 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2019   pk_12_total 401.0 89.0 82.0 4.0   8.0         32.0   313.0 303.0     57.0         375.0   98.0   616.0 401 89 82 4   8         32   313 303     57     375 98   616
1757706 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2019   grade_1                         49.0 57.0                       106.0                         49 57                 106
1757707 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2019   grade_2                         55.0 55.0                       110.0                         55 55                 110
1757708 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2019   grade_3                         64.0 44.0                       108.0                         64 44                 108
1757709 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2019   grade_4                         61.0 49.0                       110.0                         61 49                 110
1757710 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2019   grade_5                         57.0 59.0                       116.0                         57 59                 116
1757711 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2019   grade_6                         57.0 57.0                       114.0                         57 57                 114
1757712 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2019   pk_12_total 60.0 444.0 130.0     2.0         28.0   343.0 321.0     98.0         523.0   69.0   664.0 60 444 130     2         28   343 321     98     523 69   664
1757713 IN     school 1805670 5330   M S D Lawrence Township 180567001032 5283 Mary Evelyn Castle Elementary Sch   Regular School No Elementary 01 06 2019   grade_1                         58.0 59.0                       117.0                         58 59                 117
1757714 IN     school 1805670 5330   M S D Lawrence Township 180567001032 5283 Mary Evelyn Castle Elementary Sch   Regular School No Elementary 01 06 2019   grade_2                         52.0 55.0                       107.0                         52 55                 107
1757715 IN     school 1805670 5330   M S D Lawrence Township 180567001032 5283 Mary Evelyn Castle Elementary Sch   Regular School No Elementary 01 06 2019   grade_3                         46.0 57.0                       103.0                         46 57                 103
1757716 IN     school 1805670 5330   M S D Lawrence Township 180567001032 5283 Mary Evelyn Castle Elementary Sch   Regular School No Elementary 01 06 2019   grade_4                         57.0 53.0                       110.0                         57 53                 110
1757717 IN     school 1805670 5330   M S D Lawrence Township 180567001032 5283 Mary Evelyn Castle Elementary Sch   Regular School No Elementary 01 06 2019   grade_5                         54.0 58.0                       112.0                         54 58                 112
1757718 IN     school 1805670 5330   M S D Lawrence Township 180567001032 5283 Mary Evelyn Castle Elementary Sch   Regular School No Elementary 01 06 2019   grade_6                         60.0 51.0                       111.0                         60 51                 111
1757719 IN     school 1805670 5330   M S D Lawrence Township 180567001032 5283 Mary Evelyn Castle Elementary Sch   Regular School No Elementary 01 06 2019   pk_12_total 202.0 208.0 174.0 1.0   16.0     1.0   58.0   327.0 333.0     138.0         397.0   63.0   660.0 202 208 174 1   16     1   58   327 333     138     397 63   660
1757723 IN     school 1805670 5330   M S D Lawrence Township 180567001026 5285 Crestview Elementary School   Regular School No Elementary 01 06 2019   grade_1                         44.0 55.0                       99.0                         44 55                 99
1757724 IN     school 1805670 5330   M S D Lawrence Township 180567001026 5285 Crestview Elementary School   Regular School No Elementary 01 06 2019   grade_2                         37.0 46.0                       83.0                         37 46                 83
1757725 IN     school 1805670 5330   M S D Lawrence Township 180567001026 5285 Crestview Elementary School   Regular School No Elementary 01 06 2019   grade_3                         62.0 48.0                       110.0                         62 48                 110
1757726 IN     school 1805670 5330   M S D Lawrence Township 180567001026 5285 Crestview Elementary School   Regular School No Elementary 01 06 2019   grade_4                         53.0 48.0                       101.0                         53 48                 101

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