Data source: Big Local News · About: Big Local

84,143 rows where state = "IN" sorted by ccd_school_type descending

View and edit SQL

grade

year

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
1160677 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_10                         11.0 1.0                       12.0                         11 1                 12
1160678 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_11                         10.0 1.0                       11.0                         10 1                 11
1160679 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_12                         4.0 0.0                       4.0                         4 0                 4
1160680 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_4                         1.0 0.0                       1.0                         1 0                 1
1160681 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_5                         3.0 0.0                       3.0                         3 0                 3
1160682 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_6                         3.0 1.0                       4.0                         3 1                 4
1160683 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_7                         10.0 0.0                       10.0                         10 0                 10
1160684 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_8                         8.0 0.0                       8.0                         8 0                 8
1160685 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_9                         4.0 0.0                       4.0                         4 0                 4
1160686 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   pk_12_total 39.0 6.0 2.0               10.0   54.0 3.0     0.0             54.0   57.0 39 6 2               10   54 3     0       54   57
1162673 IN     school 1807650 3070   Noblesville Schools 180765002369 2514 MOSAICS School   Special Education School No 3.0 07 12 2015   grade_10                         2.0 1.0                       3.0                         2 1                 3
1162674 IN     school 1807650 3070   Noblesville Schools 180765002369 2514 MOSAICS School   Special Education School No 3.0 07 12 2015   grade_11                         3.0 1.0                       4.0                         3 1                 4
1162675 IN     school 1807650 3070   Noblesville Schools 180765002369 2514 MOSAICS School   Special Education School No 3.0 07 12 2015   grade_12                         1.0 0.0                       1.0                         1 0                 1
1162676 IN     school 1807650 3070   Noblesville Schools 180765002369 2514 MOSAICS School   Special Education School No 3.0 07 12 2015   grade_7                         4.0 0.0                       4.0                         4 0                 4
1162677 IN     school 1807650 3070   Noblesville Schools 180765002369 2514 MOSAICS School   Special Education School No 3.0 07 12 2015   grade_8                         4.0 0.0                       4.0                         4 0                 4
1162678 IN     school 1807650 3070   Noblesville Schools 180765002369 2514 MOSAICS School   Special Education School No 3.0 07 12 2015   pk_12_total 14.0   1.0               1.0   14.0 2.0     0.0             16.0   16.0 14   1               1   14 2     0       16   16
1164351 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   adult                         24.0 14.0                       38.0                         24 14                 38
1164352 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_1                         4.0 1.0                       5.0                         4 1                 5
1164353 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_10                         1.0 1.0                       2.0                         1 1                 2
1164354 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_11                         1.0 1.0                       2.0                         1 1                 2
1164355 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_12                         3.0 0.0                       3.0                         3 0                 3
1164356 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_2                         6.0 1.0                       7.0                         6 1                 7
1164357 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_3                         5.0 0.0                       5.0                         5 0                 5
1164358 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_4                         7.0 1.0                       8.0                         7 1                 8
1164359 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_5                         6.0 1.0                       7.0                         6 1                 7
1164360 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_6                         4.0 2.0                       6.0                         4 2                 6
1164361 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_7                         5.0 2.0                       7.0                         5 2                 7
1164362 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_8                         3.0 2.0                       5.0                         3 2                 5
1164363 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_9                         2.0 2.0                       4.0                         2 2                 4
1164364 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   kindergarten                         2.0 1.0                       3.0                         2 1                 3
1164365 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   pk_12_total 53.0 32.0 7.0     1.0         9.0   73.0 29.0                       102.0 53 32 7     1         9   73 29                 102
1168684 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_10                         16.0 5.0                       21.0                         16 5                 21
1168685 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_11                         3.0 3.0                       6.0                         3 3                 6
1168686 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_12                         3.0 1.0                       4.0                         3 1                 4
1168687 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_3                         1.0 0.0                       1.0                         1 0                 1
1168688 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_4                         2.0 0.0                       2.0                         2 0                 2
1168689 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_5                         1.0 0.0                       1.0                         1 0                 1
1168690 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_6                         4.0 0.0                       4.0                         4 0                 4
1168691 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_7                         10.0 2.0                       12.0                         10 2                 12
1168692 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_8                         13.0 3.0                       16.0                         13 3                 16
1168693 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_9                         10.0 7.0                       17.0                         10 7                 17
1168694 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   pk_12_total 51.0 19.0 9.0 1.0             4.0   63.0 21.0     1.0             81.0   84.0 51 19 9 1             4   63 21     1       81   84
1169463 IN     school 1805400 7855   Lafayette School Corporation 180540000966 8125 Greater Lafayette Area SE   Special Education School No 1.0 PK PK 2015   pk_12_total 176.0 16.0 45.0     6.0         7.0   184.0 66.0     0.0             240.0   250.0 176 16 45     6         7   184 66     0       240   250
1169464 IN     school 1805400 7855   Lafayette School Corporation 180540000966 8125 Greater Lafayette Area SE   Special Education School No 1.0 PK PK 2015   pre_kindergarten                         184.0 66.0                       250.0                         184 66                 250
1170282 IN     school 1812390 8130   Warrick County School Corp 181239002512 8779 Warrick County Preschool   Special Education School No 1.0 PK PK 2015   pk_12_total 43.0   1.0     5.0         2.0   35.0 16.0     0.0             51.0   51.0 43   1     5         2   35 16     0       51   51
1170283 IN     school 1812390 8130   Warrick County School Corp 181239002512 8779 Warrick County Preschool   Special Education School No 1.0 PK PK 2015   pre_kindergarten                         35.0 16.0                       51.0                         35 16                 51
1170508 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_1                         2.0 0.0                       2.0                         2 0                 2
1170509 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_10                         6.0 3.0                       9.0                         6 3                 9
1170510 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_11                         15.0 1.0                       16.0                         15 1                 16
1170511 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_12                         8.0 1.0                       9.0                         8 1                 9
1170512 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_2                         5.0 0.0                       5.0                         5 0                 5
1170513 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_3                         5.0 0.0                       5.0                         5 0                 5
1170514 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_4                         4.0 0.0                       4.0                         4 0                 4
1170515 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_5                         2.0 0.0                       2.0                         2 0                 2
1170516 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_6                         4.0 0.0                       4.0                         4 0                 4
1170517 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_7                         9.0 0.0                       9.0                         9 0                 9
1170518 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_8                         15.0 4.0                       19.0                         15 4                 19
1170519 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_9                         10.0 3.0                       13.0                         10 3                 13
1170520 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   kindergarten                         2.0 0.0                       2.0                         2 0                 2
1170521 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   pk_12_total 66.0 14.0 5.0 1.0             13.0   87.0 12.0     1.0             61.0   99.0 66 14 5 1             13   87 12     1       61   99
1282079 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_10                         6.0 1.0                       7.0                         6 1                 7
1282080 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_11                         9.0 2.0                       11.0                         9 2                 11
1282081 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_12                         10.0 2.0                       12.0                         10 2                 12
1282082 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_5                         2.0 0.0                       2.0                         2 0                 2
1282083 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_6                         5.0 1.0                       6.0                         5 1                 6
1282084 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_7                         3.0 0.0                       3.0                         3 0                 3
1282085 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_8                         8.0 4.0                       12.0                         8 4                 12
1282086 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_9                         6.0 1.0                       7.0                         6 1                 7
1282087 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   pk_12_total 43.0 10.0 2.0               5.0   49.0 11.0     1.0             56.0   60.0 43 10 2               5   49 11     1       56   60
1284087 IN     school 1807650 3070   Noblesville Schools 180765002369 2514 MOSAICS School   Special Education School No 4.0 08 11 2016   grade_11                         2.0 1.0                       3.0                         2 1                 3
1284088 IN     school 1807650 3070   Noblesville Schools 180765002369 2514 MOSAICS School   Special Education School No 4.0 08 11 2016   grade_8                         2.0 0.0                       2.0                         2 0                 2
1284089 IN     school 1807650 3070   Noblesville Schools 180765002369 2514 MOSAICS School   Special Education School No 4.0 08 11 2016   pk_12_total 4.0                   1.0   4.0 1.0     0.0             5.0   5.0 4                   1   4 1     0       5   5
1290076 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 04 12 2016   grade_10                         14.0 7.0                       21.0                         14 7                 21
1290077 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 04 12 2016   grade_11                         10.0 3.0                       13.0                         10 3                 13
1290078 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 04 12 2016   grade_12                         3.0 3.0                       6.0                         3 3                 6
1290079 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 04 12 2016   grade_4                         1.0 0.0                       1.0                         1 0                 1
1290080 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 04 12 2016   grade_5                         4.0 0.0                       4.0                         4 0                 4
1290081 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 04 12 2016   grade_6                         5.0 0.0                       5.0                         5 0                 5
1290082 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 04 12 2016   grade_7                         4.0 0.0                       4.0                         4 0                 4
1290083 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 04 12 2016   grade_8                         9.0 2.0                       11.0                         9 2                 11
1290084 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 04 12 2016   grade_9                         13.0 10.0                       23.0                         13 10                 23
1290085 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 04 12 2016   pk_12_total 48.0 20.0 7.0               13.0   63.0 25.0     0.0             81.0   88.0 48 20 7               13   63 25     0       81   88
1290854 IN     school 1805400 7855   Lafayette School Corporation 180540000966 8125 Greater Lafayette Area SE   Special Education School No 1.0 PK PK 2016   pk_12_total 190.0 26.0 37.0     9.0         7.0   194.0 75.0     0.0             260.0   269.0 190 26 37     9         7   194 75     0       260   269
1290855 IN     school 1805400 7855   Lafayette School Corporation 180540000966 8125 Greater Lafayette Area SE   Special Education School No 1.0 PK PK 2016   pre_kindergarten                         194.0 75.0                       269.0                         194 75                 269
1291895 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_1                         1.0 1.0                       2.0                         1 1                 2
1291896 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_10                         15.0 3.0                       18.0                         15 3                 18
1291897 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_11                         2.0 1.0                       3.0                         2 1                 3
1291898 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_12                         9.0 1.0                       10.0                         9 1                 10
1291899 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_2                         4.0 0.0                       4.0                         4 0                 4
1291900 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_3                         6.0 0.0                       6.0                         6 0                 6
1291901 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_4                         3.0 0.0                       3.0                         3 0                 3
1291902 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_5                         2.0 0.0                       2.0                         2 0                 2
1291903 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_6                         2.0 0.0                       2.0                         2 0                 2
1291904 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_7                         6.0 1.0                       7.0                         6 1                 7
1291905 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_8                         9.0 4.0                       13.0                         9 4                 13
1291906 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_9                         18.0 5.0                       23.0                         18 5                 23
1291907 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1291908 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   pk_12_total 60.0 16.0 5.0               13.0   78.0 16.0     3.0             56.0   94.0 60 16 5               13   78 16     3       56   94
1294137 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No Other 04 12 2017   grade_10                         10.0 2.0                       12.0                         10 2                 12
1294138 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No Other 04 12 2017   grade_11                         9.0 0.0                       9.0                         9 0                 9

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