Data source: Big Local News · About: Big Local

84,143 rows where state = "IN" sorted by ccd_school_low_grade

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
1160558 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2015   grade_1                         52.0 42.0                       94.0                         52 42                 94
1160559 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2015   grade_2                         54.0 37.0                       91.0                         54 37                 91
1160560 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2015   grade_3                         41.0 38.0                       79.0                         41 38                 79
1160561 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2015   grade_4                         36.0 40.0                       76.0                         36 40                 76
1160562 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2015   grade_5                         47.0 31.0                       78.0                         47 31                 78
1160563 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2015   kindergarten                         61.0 45.0                       106.0                         61 45                 106
1160564 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 299.0 128.0 53.0 3.0   9.0     1.0   61.0   310.0 244.0     19.0             84.0   554.0 299 128 53 3   9     1   61   310 244     19       84   554
1160565 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                         19.0 11.0                       30.0                         19 11                 30
1160587 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   grade_1                         27.0 25.0                       52.0                         27 25                 52
1160588 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   grade_2                         17.0 24.0                       41.0                         17 24                 41
1160589 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   grade_3                         29.0 25.0                       54.0                         29 25                 54
1160590 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   grade_4                         21.0 25.0                       46.0                         21 25                 46
1160591 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   grade_5                         25.0 33.0                       58.0                         25 33                 58
1160592 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   kindergarten                         23.0 30.0                       53.0                         23 30                 53
1160593 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   pk_12_total 314.0 1.0 7.0               9.0   159.0 172.0     2.0             74.0   331.0 314 1 7               9   159 172     2       74   331
1160594 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         17.0 10.0                       27.0                         17 10                 27
1160635 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         33.0 30.0                       63.0                         33 30                 63
1160636 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         39.0 34.0                       73.0                         39 34                 73
1160637 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         35.0 24.0                       59.0                         35 24                 59
1160638 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         22.0 22.0                       44.0                         22 22                 44
1160639 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         43.0 25.0                       68.0                         43 25                 68
1160640 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         39.0 26.0                       65.0                         39 26                 65
1160641 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No 1.0 PK 05 2015   pk_12_total 228.0 90.0 30.0 2.0   7.0         41.0   227.0 171.0     15.0             77.0   398.0 228 90 30 2   7         41   227 171     15       77   398
1160642 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         16.0 10.0                       26.0                         16 10                 26
1160650 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         37.0 48.0                       85.0                         37 48                 85
1160651 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         44.0 36.0                       80.0                         44 36                 80
1160652 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         35.0 42.0                       77.0                         35 42                 77
1160653 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         38.0 25.0                       63.0                         38 25                 63
1160654 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         45.0 35.0                       80.0                         45 35                 80
1160655 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         47.0 35.0                       82.0                         47 35                 82
1160656 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No 1.0 PK 05 2015   pk_12_total 329.0 85.0 35.0 4.0   3.0     1.0   39.0   264.0 232.0     11.0             115.0   496.0 329 85 35 4   3     1   39   264 232     11       115   496
1160657 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         18.0 11.0                       29.0                         18 11                 29
1160658 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         19.0 18.0                       37.0                         19 18                 37
1160659 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         19.0 17.0                       36.0                         19 17                 36
1160660 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         14.0 16.0                       30.0                         14 16                 30
1160661 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         17.0 11.0                       28.0                         17 11                 28
1160662 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         14.0 13.0                       27.0                         14 13                 27
1160663 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         20.0 18.0                       38.0                         20 18                 38
1160664 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No 1.0 PK 05 2015   pk_12_total 70.0 86.0 28.0               36.0   118.0 102.0     10.0             56.0   220.0 70 86 28               36   118 102     10       56   220
1160665 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         15.0 9.0                       24.0                         15 9                 24
1160739 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         24.0 19.0                       43.0                         24 19                 43
1160740 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         25.0 14.0                       39.0                         25 14                 39
1160741 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         27.0 20.0                       47.0                         27 20                 47
1160742 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         22.0 25.0                       47.0                         22 25                 47
1160743 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         20.0 13.0                       33.0                         20 13                 33
1160744 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         18.0 21.0                       39.0                         18 21                 39
1160745 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No 1.0 PK 05 2015   pk_12_total 269.0   4.0               1.0   147.0 127.0     1.0             69.0   274.0 269   4               1   147 127     1       69   274
1160746 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         11.0 15.0                       26.0                         11 15                 26
1160747 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 07 2015   grade_1                         27.0 27.0                       54.0                         27 27                 54
1160748 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 07 2015   grade_2                         24.0 22.0                       46.0                         24 22                 46
1160749 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 07 2015   grade_3                         29.0 17.0                       46.0                         29 17                 46
1160750 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 07 2015   grade_4                         23.0 18.0                       41.0                         23 18                 41
1160751 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 07 2015   grade_5                         21.0 19.0                       40.0                         21 19                 40
1160752 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 07 2015   grade_7                         1.0 0.0                       1.0                         1 0                 1
1160753 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 07 2015   kindergarten                         27.0 20.0                       47.0                         27 20                 47
1160754 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 07 2015   pk_12_total 285.0 2.0 9.0     2.0         8.0   171.0 135.0     1.0             122.0   306.0 285 2 9     2         8   171 135     1       122   306
1160755 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 07 2015   pre_kindergarten                         19.0 12.0                       31.0                         19 12                 31
1160756 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elem School   Regular School No 1.0 PK 05 2015   grade_1                         22.0 26.0                       48.0                         22 26                 48
1160757 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elem School   Regular School No 1.0 PK 05 2015   grade_2                         21.0 18.0                       39.0                         21 18                 39
1160758 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elem School   Regular School No 1.0 PK 05 2015   grade_3                         26.0 20.0                       46.0                         26 20                 46
1160759 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elem School   Regular School No 1.0 PK 05 2015   grade_4                         15.0 22.0                       37.0                         15 22                 37
1160760 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elem School   Regular School No 1.0 PK 05 2015   grade_5                         23.0 17.0                       40.0                         23 17                 40
1160761 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elem School   Regular School No 1.0 PK 05 2015   kindergarten                         23.0 24.0                       47.0                         23 24                 47
1160762 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elem School   Regular School No 1.0 PK 05 2015   pk_12_total 267.0 2.0 9.0 2.0   2.0         5.0   144.0 143.0     2.0             68.0   287.0 267 2 9 2   2         5   144 143     2       68   287
1160763 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elem School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         14.0 16.0                       30.0                         14 16                 30
1160771 IN     school 1802130 1150   Clinton Central School Corp 180213000256 961 Clinton Central Elem School   Regular School No 1.0 PK 06 2015   grade_1                         41.0 46.0                       87.0                         41 46                 87
1160772 IN     school 1802130 1150   Clinton Central School Corp 180213000256 961 Clinton Central Elem School   Regular School No 1.0 PK 06 2015   grade_2                         43.0 35.0                       78.0                         43 35                 78
1160773 IN     school 1802130 1150   Clinton Central School Corp 180213000256 961 Clinton Central Elem School   Regular School No 1.0 PK 06 2015   grade_3                         35.0 45.0                       80.0                         35 45                 80
1160774 IN     school 1802130 1150   Clinton Central School Corp 180213000256 961 Clinton Central Elem School   Regular School No 1.0 PK 06 2015   grade_4                         33.0 36.0                       69.0                         33 36                 69
1160775 IN     school 1802130 1150   Clinton Central School Corp 180213000256 961 Clinton Central Elem School   Regular School No 1.0 PK 06 2015   grade_5                         37.0 40.0                       77.0                         37 40                 77
1160776 IN     school 1802130 1150   Clinton Central School Corp 180213000256 961 Clinton Central Elem School   Regular School No 1.0 PK 06 2015   grade_6                         41.0 36.0                       77.0                         41 36                 77
1160777 IN     school 1802130 1150   Clinton Central School Corp 180213000256 961 Clinton Central Elem School   Regular School No 1.0 PK 06 2015   kindergarten                         32.0 31.0                       63.0                         32 31                 63
1160778 IN     school 1802130 1150   Clinton Central School Corp 180213000256 961 Clinton Central Elem School   Regular School No 1.0 PK 06 2015   pk_12_total 515.0 2.0 16.0 2.0   1.0         6.0   269.0 273.0     3.0             54.0   542.0 515 2 16 2   1         6   269 273     3       54   542
1160779 IN     school 1802130 1150   Clinton Central School Corp 180213000256 961 Clinton Central Elem School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         7.0 4.0                       11.0                         7 4                 11
1160804 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Schl   Regular School No 1.0 PK 02 2015   grade_1                         87.0 72.0                       159.0                         87 72                 159
1160805 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Schl   Regular School No 1.0 PK 02 2015   grade_2                         75.0 74.0                       149.0                         75 74                 149
1160806 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Schl   Regular School No 1.0 PK 02 2015   kindergarten                         80.0 74.0                       154.0                         80 74                 154
1160807 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Schl   Regular School No 1.0 PK 02 2015   pk_12_total 229.0 4.0 270.0 1.0   2.0         1.0   274.0 233.0     206.0             69.0   507.0 229 4 270 1   2         1   274 233     206       69   507
1160808 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Schl   Regular School No 1.0 PK 02 2015   pre_kindergarten                         32.0 13.0                       45.0                         32 13                 45
1160813 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         50.0 53.0                       103.0                         50 53                 103
1160814 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         57.0 68.0                       125.0                         57 68                 125
1160815 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         69.0 54.0                       123.0                         69 54                 123
1160816 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary Sch   Regular School No 1.0 PK 05 2015   grade_4                         49.0 47.0                       96.0                         49 47                 96
1160817 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         62.0 46.0                       108.0                         62 46                 108
1160818 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary Sch   Regular School No 1.0 PK 05 2015   kindergarten                         54.0 51.0                       105.0                         54 51                 105
1160819 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary Sch   Regular School No 1.0 PK 05 2015   pk_12_total 345.0 7.0 324.0           1.0   11.0   361.0 327.0     256.0             67.0   688.0 345 7 324           1   11   361 327     256       67   688
1160820 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         20.0 8.0                       28.0                         20 8                 28
1160836 IN     school 1802440 1300   Crawford Co Com School Corp 180244000281 1037 Leavenworth Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         10.0 21.0                       31.0                         10 21                 31
1160837 IN     school 1802440 1300   Crawford Co Com School Corp 180244000281 1037 Leavenworth Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         18.0 14.0                       32.0                         18 14                 32
1160838 IN     school 1802440 1300   Crawford Co Com School Corp 180244000281 1037 Leavenworth Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         18.0 14.0                       32.0                         18 14                 32
1160839 IN     school 1802440 1300   Crawford Co Com School Corp 180244000281 1037 Leavenworth Elementary School   Regular School No 1.0 PK 06 2015   grade_4                         20.0 19.0                       39.0                         20 19                 39
1160840 IN     school 1802440 1300   Crawford Co Com School Corp 180244000281 1037 Leavenworth Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         9.0 19.0                       28.0                         9 19                 28
1160841 IN     school 1802440 1300   Crawford Co Com School Corp 180244000281 1037 Leavenworth Elementary School   Regular School No 1.0 PK 06 2015   grade_6                         11.0 11.0                       22.0                         11 11                 22
1160842 IN     school 1802440 1300   Crawford Co Com School Corp 180244000281 1037 Leavenworth Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         9.0 6.0                       15.0                         9 6                 15
1160843 IN     school 1802440 1300   Crawford Co Com School Corp 180244000281 1037 Leavenworth Elementary School   Regular School No 1.0 PK 06 2015   pk_12_total 219.0   2.0               6.0   113.0 114.0     0.0             40.0   227.0 219   2               6   113 114     0       40   227
1160844 IN     school 1802440 1300   Crawford Co Com School Corp 180244000281 1037 Leavenworth Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         18.0 10.0                       28.0                         18 10                 28
1160845 IN     school 1802440 1300   Crawford Co Com School Corp 180244000284 1045 Patoka Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         9.0 11.0                       20.0                         9 11                 20
1160846 IN     school 1802440 1300   Crawford Co Com School Corp 180244000284 1045 Patoka Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         12.0 10.0                       22.0                         12 10                 22
1160847 IN     school 1802440 1300   Crawford Co Com School Corp 180244000284 1045 Patoka Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         12.0 12.0                       24.0                         12 12                 24
1160848 IN     school 1802440 1300   Crawford Co Com School Corp 180244000284 1045 Patoka Elementary School   Regular School No 1.0 PK 06 2015   grade_4                         11.0 7.0                       18.0                         11 7                 18

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