Data source: Big Local News · About: Big Local

12,058 rows where state = "IN" and year = 2017 sorted by ccd_school_low_grade

View and edit SQL

grade

year

  • 2017 · 12,058
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
1293484 IN     school   255   East Allen County Schools   318 Park Hill Learning Center             2017   pk_12_total 47.0 7.0 6.0     1.0         1.0   37.0 25.0     0.0             47.0   62.0 47 7 6     1         1   37 25     0       47   62
1293485 IN     school   255   East Allen County Schools   318 Park Hill Learning Center             2017   pre_kindergarten                         37.0 25.0                       62.0                         37 25                 62
1299669 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_1                         3.0 0.0                       3.0                         3 0                 3
1299670 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_10                         8.0 0.0                       8.0                         8 0                 8
1299671 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_11                         5.0 0.0                       5.0                         5 0                 5
1299672 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_12                         6.0 1.0                       7.0                         6 1                 7
1299673 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_2                         6.0 0.0                       6.0                         6 0                 6
1299674 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_3                         6.0 1.0                       7.0                         6 1                 7
1299675 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_4                         5.0 1.0                       6.0                         5 1                 6
1299676 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_5                         7.0 1.0                       8.0                         7 1                 8
1299677 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_6                         4.0 1.0                       5.0                         4 1                 5
1299678 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_7                         10.0 2.0                       12.0                         10 2                 12
1299679 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_8                         6.0 1.0                       7.0                         6 1                 7
1299680 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_9                         19.0 1.0                       20.0                         19 1                 20
1299681 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   kindergarten                         1.0 2.0                       3.0                         1 2                 3
1299682 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   pk_12_total 48.0 35.0 6.0               8.0   86.0 11.0     5.0             89.0   97.0 48 35 6               8   86 11     5       89   97
1302344 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2017   pk_12_total 95.0 28.0 26.0               8.0   102.0 55.0     0.0             113.0   157.0 95 28 26               8   102 55     0       113   157
1302345 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2017   pre_kindergarten                         102.0 55.0                       157.0                         102 55                 157
1293119 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_1                         41.0 29.0                       70.0                         41 29                 70
1293120 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_2                         36.0 39.0                       75.0                         36 39                 75
1293121 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_3                         33.0 37.0                       70.0                         33 37                 70
1293122 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_4                         31.0 37.0                       68.0                         31 37                 68
1293123 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_5                         37.0 40.0                       77.0                         37 40                 77
1293124 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_6                         38.0 38.0                       76.0                         38 38                 76
1293125 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_7                         44.0 34.0                       78.0                         44 34                 78
1293126 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_8                         37.0 45.0                       82.0                         37 45                 82
1293127 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   pk_12_total 249.0 146.0 138.0 4.0   15.0         44.0   297.0 299.0     50.0             79.0   596.0 249 146 138 4   15         44   297 299     50       79   596
1293160 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2017   grade_1                         62.0 55.0                       117.0                         62 55                 117
1293161 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2017   grade_2                         55.0 65.0                       120.0                         55 65                 120
1293162 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2017   grade_3                         49.0 58.0                       107.0                         49 58                 107
1293163 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2017   grade_4                         62.0 48.0                       110.0                         62 48                 110
1293164 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2017   grade_5                         61.0 46.0                       107.0                         61 46                 107
1293165 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2017   pk_12_total 222.0 184.0 96.0 3.0   13.0     3.0   40.0   289.0 272.0     34.0             69.0   561.0 222 184 96 3   13     3   40   289 272     34       69   561
1295129 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_1                         0.0 1.0                       1.0                         0 1                 1
1295130 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_10                         39.0 32.0                       71.0                         39 32                 71
1295131 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_11                         42.0 47.0                       89.0                         42 47                 89
1295132 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_12                         66.0 101.0                       167.0                         66 101                 167
1295133 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_2                         3.0 0.0                       3.0                         3 0                 3
1295134 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_3                         2.0 0.0                       2.0                         2 0                 2
1295135 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_4                         3.0 1.0                       4.0                         3 1                 4
1295136 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_5                         3.0 0.0                       3.0                         3 0                 3
1295137 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1295138 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_7                         5.0 1.0                       6.0                         5 1                 6
1295139 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_8                         10.0 7.0                       17.0                         10 7                 17
1295140 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_9                         7.0 10.0                       17.0                         7 10                 17
1295141 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   pk_12_total 172.0 86.0 80.0     4.0     1.0   38.0   181.0 200.0     28.0             98.0   381.0 172 86 80     4     1   38   181 200     28       98   381
1295589 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No Elementary 01 05 2017   grade_1                         3.0 1.0                       4.0                         3 1                 4
1295590 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No Elementary 01 05 2017   grade_3                         90.0 84.0                       174.0                         90 84                 174
1295591 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No Elementary 01 05 2017   grade_4                         80.0 75.0                       155.0                         80 75                 155
1295592 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No Elementary 01 05 2017   grade_5                         76.0 66.0                       142.0                         76 66                 142
1295593 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No Elementary 01 05 2017   pk_12_total 399.0 18.0 14.0 1.0   5.0         38.0   249.0 226.0     6.0             133.0   475.0 399 18 14 1   5         38   249 226     6       133   475
1296707 IN     school 1807440 3445   New Castle Community School Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No Elementary 01 06 2017   grade_1                         19.0 19.0                       38.0                         19 19                 38
1296708 IN     school 1807440 3445   New Castle Community School Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No Elementary 01 06 2017   grade_2                         17.0 25.0                       42.0                         17 25                 42
1296709 IN     school 1807440 3445   New Castle Community School Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No Elementary 01 06 2017   grade_3                         19.0 21.0                       40.0                         19 21                 40
1296710 IN     school 1807440 3445   New Castle Community School Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No Elementary 01 06 2017   grade_4                         20.0 29.0                       49.0                         20 29                 49
1296711 IN     school 1807440 3445   New Castle Community School Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No Elementary 01 06 2017   grade_5                         24.0 22.0                       46.0                         24 22                 46
1296712 IN     school 1807440 3445   New Castle Community School Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No Elementary 01 06 2017   grade_6                         20.0 19.0                       39.0                         20 19                 39
1296713 IN     school 1807440 3445   New Castle Community School Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No Elementary 01 06 2017   pk_12_total 227.0 3.0 9.0     6.0         9.0   119.0 135.0     2.0             36.0   254.0 227 3 9     6         9   119 135     2       36   254
1296722 IN     school 1807440 3445   New Castle Community School Corp 180744001291 2861 Westwood Elementary School   Regular School No Elementary 01 06 2017   grade_1                         15.0 24.0                       39.0                         15 24                 39
1296723 IN     school 1807440 3445   New Castle Community School Corp 180744001291 2861 Westwood Elementary School   Regular School No Elementary 01 06 2017   grade_2                         16.0 26.0                       42.0                         16 26                 42
1296724 IN     school 1807440 3445   New Castle Community School Corp 180744001291 2861 Westwood Elementary School   Regular School No Elementary 01 06 2017   grade_3                         18.0 13.0                       31.0                         18 13                 31
1296725 IN     school 1807440 3445   New Castle Community School Corp 180744001291 2861 Westwood Elementary School   Regular School No Elementary 01 06 2017   grade_4                         20.0 21.0                       41.0                         20 21                 41
1296726 IN     school 1807440 3445   New Castle Community School Corp 180744001291 2861 Westwood Elementary School   Regular School No Elementary 01 06 2017   grade_5                         22.0 28.0                       50.0                         22 28                 50
1296727 IN     school 1807440 3445   New Castle Community School Corp 180744001291 2861 Westwood Elementary School   Regular School No Elementary 01 06 2017   grade_6                         19.0 20.0                       39.0                         19 20                 39
1296728 IN     school 1807440 3445   New Castle Community School Corp 180744001291 2861 Westwood Elementary School   Regular School No Elementary 01 06 2017   pk_12_total 220.0 2.0 9.0     2.0         9.0   110.0 132.0     0.0             24.0   242.0 220 2 9     2         9   110 132     0       24   242
1298131 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary 01 06 2017   grade_1                         18.0 17.0                       35.0                         18 17                 35
1298132 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary 01 06 2017   grade_2                         26.0 16.0                       42.0                         26 16                 42
1298133 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary 01 06 2017   grade_3                         28.0 14.0                       42.0                         28 14                 42
1298134 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary 01 06 2017   grade_4                         20.0 20.0                       40.0                         20 20                 40
1298135 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary 01 06 2017   grade_5                         23.0 18.0                       41.0                         23 18                 41
1298136 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary 01 06 2017   grade_6                         17.0 11.0                       28.0                         17 11                 28
1298137 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary 01 06 2017   pk_12_total 93.0 22.0 110.0               3.0   132.0 96.0     20.0             37.0   228.0 93 22 110               3   132 96     20       37   228
1298146 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No Elementary 01 06 2017   grade_1                         17.0 6.0                       23.0                         17 6                 23
1298147 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No Elementary 01 06 2017   grade_2                         19.0 9.0                       28.0                         19 9                 28
1298148 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No Elementary 01 06 2017   grade_3                         13.0 19.0                       32.0                         13 19                 32
1298149 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No Elementary 01 06 2017   grade_4                         13.0 10.0                       23.0                         13 10                 23
1298150 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No Elementary 01 06 2017   grade_5                         11.0 13.0                       24.0                         11 13                 24
1298151 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No Elementary 01 06 2017   grade_6                         13.0 10.0                       23.0                         13 10                 23
1298152 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No Elementary 01 06 2017   pk_12_total 76.0 9.0 60.0 1.0             7.0   86.0 67.0     14.0             36.0   153.0 76 9 60 1             7   86 67     14       36   153
1298483 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 06 2017   grade_1                         55.0 39.0                       94.0                         55 39                 94
1298484 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 06 2017   grade_2                         50.0 42.0                       92.0                         50 42                 92
1298485 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 06 2017   grade_3                         38.0 48.0                       86.0                         38 48                 86
1298486 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 06 2017   grade_4                         47.0 37.0                       84.0                         47 37                 84
1298487 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 06 2017   grade_5                         41.0 41.0                       82.0                         41 41                 82
1298488 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 06 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1298489 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 06 2017   pk_12_total 276.0 39.0 102.0     8.0     2.0   12.0   232.0 207.0     10.0             56.0   439.0 276 39 102     8     2   12   232 207     10       56   439
1298490 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 06 2017   grade_1                         33.0 22.0                       55.0                         33 22                 55
1298491 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 06 2017   grade_2                         43.0 28.0                       71.0                         43 28                 71
1298492 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 06 2017   grade_3                         29.0 28.0                       57.0                         29 28                 57
1298493 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 06 2017   grade_4                         26.0 32.0                       58.0                         26 32                 58
1298494 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 06 2017   grade_5                         33.0 38.0                       71.0                         33 38                 71
1298495 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 06 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1298496 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 06 2017   pk_12_total 200.0 24.0 72.0 1.0             16.0   165.0 148.0     7.0             50.0   313.0 200 24 72 1             16   165 148     7       50   313
1298497 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No Elementary 01 06 2017   grade_1                         59.0 70.0                       129.0                         59 70                 129
1298498 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No Elementary 01 06 2017   grade_2                         67.0 76.0                       143.0                         67 76                 143
1298499 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No Elementary 01 06 2017   grade_3                         82.0 77.0                       159.0                         82 77                 159
1298500 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No Elementary 01 06 2017   grade_4                         72.0 71.0                       143.0                         72 71                 143
1298501 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No Elementary 01 06 2017   grade_5                         78.0 73.0                       151.0                         78 73                 151
1298502 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No Elementary 01 06 2017   grade_6                         0.0 1.0                       1.0                         0 1                 1
1298503 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No Elementary 01 06 2017   pk_12_total 510.0 40.0 150.0 3.0   5.0     1.0   17.0   358.0 368.0     10.0             76.0   726.0 510 40 150 3   5     1   17   358 368     10       76   726

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