enrollments

Data source: Big Local News · About: Big Local

15,920 rows where state = "AK" sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

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
1814807 1814807 AK     school 200800 10   Chugach Schools 20080000553 100030 Chenega School   Regular School No Other PK 12 2021   grade_2 0.0                   1.0                             1.0 0                   1                       1
1814808 1814808 AK     school 200800 10   Chugach Schools 20080000553 100030 Chenega School   Regular School No Other PK 12 2021   grade_3 0.0                   1.0                             1.0 0                   1                       1
1814809 1814809 AK     school 200800 10   Chugach Schools 20080000553 100030 Chenega School   Regular School No Other PK 12 2021   grade_4 0.0                   1.0                             1.0 0                   1                       1
1814810 1814810 AK     school 200800 10   Chugach Schools 20080000553 100030 Chenega School   Regular School No Other PK 12 2021   grade_5 0.0                   0.0                             0.0 0                   0                       0
1814811 1814811 AK     school 200800 10   Chugach Schools 20080000553 100030 Chenega School   Regular School No Other PK 12 2021   grade_6 1.0                   1.0                             2.0 1                   1                       2
1814812 1814812 AK     school 200800 10   Chugach Schools 20080000553 100030 Chenega School   Regular School No Other PK 12 2021   grade_7 1.0                   0.0                             1.0 1                   0                       1
1814813 1814813 AK     school 200800 10   Chugach Schools 20080000553 100030 Chenega School   Regular School No Other PK 12 2021   grade_8 0.0                   0.0                             0.0 0                   0                       0
1814814 1814814 AK     school 200800 10   Chugach Schools 20080000553 100030 Chenega School   Regular School No Other PK 12 2021   grade_9 0.0                   0.0                             0.0 0                   0                       0
1814815 1814815 AK     school 200800 10   Chugach Schools 20080000553 100030 Chenega School   Regular School No Other PK 12 2021   k_12_total 5.0                   6.0                             13.0 5                   6                       13
1814816 1814816 AK     school 200800 10   Chugach Schools 20080000553 100030 Chenega School   Regular School No Other PK 12 2021   kindergarten 1.0                   0.0                             2.0 1                   0                       2
1814817 1814817 AK     school 200800 10   Chugach Schools 20080000553 100030 Chenega School   Regular School No Other PK 12 2021   pk_12_total 6.0                   6.0                             16.0 6                   6                       16
1814818 1814818 AK     school 200800 10   Chugach Schools 20080000553 100030 Chenega School   Regular School No Other PK 12 2021   pre_kindergarten 1.0                   0.0                             3.0 1                   0                       3
1814819 1814819 AK     school 200800 10   Chugach Schools 20080000496 108010 FOCUS Homeschool   Regular School No Other PK 12 2021   grade_1 29.0 0.0 4.0 1.0   0.0     1.0   5.0                             44.0 29 0 4 1   0     1   5                       44
1814820 1814820 AK     school 200800 10   Chugach Schools 20080000496 108010 FOCUS Homeschool   Regular School No Other PK 12 2021   grade_10 27.0 0.0 2.0 0.0   0.0     1.0   6.0                             41.0 27 0 2 0   0     1   6                       41
1814821 1814821 AK     school 200800 10   Chugach Schools 20080000496 108010 FOCUS Homeschool   Regular School No Other PK 12 2021   grade_11 26.0 0.0 2.0 1.0   0.0     0.0   2.0                             33.0 26 0 2 1   0     0   2                       33
1814822 1814822 AK     school 200800 10   Chugach Schools 20080000496 108010 FOCUS Homeschool   Regular School No Other PK 12 2021   grade_12 21.0 1.0 2.0 1.0   1.0     1.0   5.0                             35.0 21 1 2 1   1     1   5                       35
1814823 1814823 AK     school 200800 10   Chugach Schools 20080000496 108010 FOCUS Homeschool   Regular School No Other PK 12 2021   grade_2 38.0 0.0 4.0 0.0   0.0     1.0   5.0                             51.0 38 0 4 0   0     1   5                       51
1814824 1814824 AK     school 200800 10   Chugach Schools 20080000496 108010 FOCUS Homeschool   Regular School No Other PK 12 2021   grade_3 31.0 1.0 0.0 1.0   0.0     1.0   7.0                             43.0 31 1 0 1   0     1   7                       43
1814825 1814825 AK     school 200800 10   Chugach Schools 20080000496 108010 FOCUS Homeschool   Regular School No Other PK 12 2021   grade_4 39.0 0.0 4.0 0.0   1.0     1.0   4.0                             50.0 39 0 4 0   1     1   4                       50
1814826 1814826 AK     school 200800 10   Chugach Schools 20080000496 108010 FOCUS Homeschool   Regular School No Other PK 12 2021   grade_5 40.0 0.0 6.0 1.0   0.0     2.0   2.0                             55.0 40 0 6 1   0     2   2                       55
1814827 1814827 AK     school 200800 10   Chugach Schools 20080000496 108010 FOCUS Homeschool   Regular School No Other PK 12 2021   grade_6 27.0 2.0 0.0 1.0   0.0     1.0   5.0                             37.0 27 2 0 1   0     1   5                       37
1814828 1814828 AK     school 200800 10   Chugach Schools 20080000496 108010 FOCUS Homeschool   Regular School No Other PK 12 2021   grade_7 30.0 0.0 4.0 1.0   1.0     0.0   5.0                             45.0 30 0 4 1   1     0   5                       45
1814829 1814829 AK     school 200800 10   Chugach Schools 20080000496 108010 FOCUS Homeschool   Regular School No Other PK 12 2021   grade_8 31.0 1.0 2.0 0.0   0.0     1.0   4.0                             40.0 31 1 2 0   0     1   4                       40
1814830 1814830 AK     school 200800 10   Chugach Schools 20080000496 108010 FOCUS Homeschool   Regular School No Other PK 12 2021   grade_9 27.0 3.0 2.0 1.0   0.0     0.0   4.0                             39.0 27 3 2 1   0     0   4                       39
1814831 1814831 AK     school 200800 10   Chugach Schools 20080000496 108010 FOCUS Homeschool   Regular School No Other PK 12 2021   k_12_total 408.0 8.0 36.0 8.0   3.0     10.0   60.0                             570.0 408 8 36 8   3     10   60                       570
1814832 1814832 AK     school 200800 10   Chugach Schools 20080000496 108010 FOCUS Homeschool   Regular School No Other PK 12 2021   kindergarten 42.0 0.0 4.0 0.0   0.0     0.0   6.0                             57.0 42 0 4 0   0     0   6                       57
1814833 1814833 AK     school 200800 10   Chugach Schools 20080000496 108010 FOCUS Homeschool   Regular School No Other PK 12 2021   pk_12_total 428.0 9.0 41.0 9.0   3.0     10.0   64.0                             607.0 428 9 41 9   3     10   64                       607
1814834 1814834 AK     school 200800 10   Chugach Schools 20080000496 108010 FOCUS Homeschool   Regular School No Other PK 12 2021   pre_kindergarten 20.0 1.0 5.0 1.0   0.0     0.0   4.0                             37.0 20 1 5 1   0     0   4                       37
1732532 1732532 AK     school 200070 11   Copper River Schools 20007000034 110060 Glennallen Elementary   Regular School No Elementary PK 6.0 2020   grade_1 7.0   0.0 1.0   0.0     0.0   0.0                             21 7   0 1   0     0   0                       21
1732533 1732533 AK     school 200070 11   Copper River Schools 20007000034 110060 Glennallen Elementary   Regular School No Elementary PK 6.0 2020   grade_10 0.0   0.0 0.0   0.0     0.0   0.0                             0 0   0 0   0     0   0                       0
1732534 1732534 AK     school 200070 11   Copper River Schools 20007000034 110060 Glennallen Elementary   Regular School No Elementary PK 6.0 2020   grade_11 0.0   0.0 0.0   0.0     0.0   0.0                             0 0   0 0   0     0   0                       0
1732535 1732535 AK     school 200070 11   Copper River Schools 20007000034 110060 Glennallen Elementary   Regular School No Elementary PK 6.0 2020   grade_12 0.0   0.0 0.0   0.0     0.0   0.0                             0 0   0 0   0     0   0                       0
1732536 1732536 AK     school 200070 11   Copper River Schools 20007000034 110060 Glennallen Elementary   Regular School No Elementary PK 6.0 2020   grade_2 6.0   0.0 0.0   1.0     0.0   0.0                             16 6   0 0   1     0   0                       16
1732537 1732537 AK     school 200070 11   Copper River Schools 20007000034 110060 Glennallen Elementary   Regular School No Elementary PK 6.0 2020   grade_3 3.0   1.0 1.0   0.0     1.0   0.0                             16 3   1 1   0     1   0                       16
1732538 1732538 AK     school 200070 11   Copper River Schools 20007000034 110060 Glennallen Elementary   Regular School No Elementary PK 6.0 2020   grade_4 5.0   0.0 1.0   0.0     0.0   0.0                             11 5   0 1   0     0   0                       11
1732539 1732539 AK     school 200070 11   Copper River Schools 20007000034 110060 Glennallen Elementary   Regular School No Elementary PK 6.0 2020   grade_5 4.0   1.0 0.0   0.0     1.0   0.0                             20 4   1 0   0     1   0                       20
1732540 1732540 AK     school 200070 11   Copper River Schools 20007000034 110060 Glennallen Elementary   Regular School No Elementary PK 6.0 2020   grade_6 8.0   1.0 0.0   0.0     0.0   0.0                             23 8   1 0   0     0   0                       23
1732541 1732541 AK     school 200070 11   Copper River Schools 20007000034 110060 Glennallen Elementary   Regular School No Elementary PK 6.0 2020   grade_7 0.0   0.0 0.0   0.0     0.0   0.0                             0 0   0 0   0     0   0                       0
1732542 1732542 AK     school 200070 11   Copper River Schools 20007000034 110060 Glennallen Elementary   Regular School No Elementary PK 6.0 2020   grade_8 0.0   0.0 0.0   0.0     0.0   0.0                             0 0   0 0   0     0   0                       0
1732543 1732543 AK     school 200070 11   Copper River Schools 20007000034 110060 Glennallen Elementary   Regular School No Elementary PK 6.0 2020   grade_9 0.0   0.0 0.0   0.0     0.0   0.0                             0 0   0 0   0     0   0                       0
1732544 1732544 AK     school 200070 11   Copper River Schools 20007000034 110060 Glennallen Elementary   Regular School No Elementary PK 6.0 2020   k_12_total 36.0   4.0 4.0   1.0     2.0   1.0                             123 36   4 4   1     2   1                       123
1732545 1732545 AK     school 200070 11   Copper River Schools 20007000034 110060 Glennallen Elementary   Regular School No Elementary PK 6.0 2020   kindergarten 3.0   1.0 1.0   0.0     0.0   1.0                             16 3   1 1   0     0   1                       16
1732546 1732546 AK     school 200070 11   Copper River Schools 20007000034 110060 Glennallen Elementary   Regular School No Elementary PK 6.0 2020   pk_12_total 36.0   4.0 4.0   1.0     2.0   1.0                             129 36   4 4   1     2   1                       129
1732547 1732547 AK     school 200070 11   Copper River Schools 20007000034 110060 Glennallen Elementary   Regular School No Elementary PK 6.0 2020   pre_kindergarten 0.0   0.0 0.0   0.0     0.0   0.0                             6 0   0 0   0     0   0                       6
1732548 1732548 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12.0 2020   grade_1 0.0   0.0     0.0     0.0   0.0                             0 0   0     0     0   0                       0
1732549 1732549 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12.0 2020   grade_10 10.0   0.0     0.0     1.0   1.0                             19 10   0     0     1   1                       19
1732550 1732550 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12.0 2020   grade_11 15.0   0.0     0.0     1.0   2.0                             27 15   0     0     1   2                       27
1732551 1732551 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12.0 2020   grade_12 14.0   0.0     1.0     2.0   1.0                             25 14   0     1     2   1                       25
1732552 1732552 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12.0 2020   grade_2 0.0   0.0     0.0     0.0   0.0                             0 0   0     0     0   0                       0
1732553 1732553 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12.0 2020   grade_3 0.0   0.0     0.0     0.0   0.0                             0 0   0     0     0   0                       0
1732554 1732554 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12.0 2020   grade_4 0.0   0.0     0.0     0.0   0.0                             0 0   0     0     0   0                       0
1732555 1732555 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12.0 2020   grade_5 0.0   0.0     0.0     0.0   0.0                             0 0   0     0     0   0                       0
1732556 1732556 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12.0 2020   grade_6 0.0   0.0     0.0     0.0   0.0                             0 0   0     0     0   0                       0
1732557 1732557 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12.0 2020   grade_7 7.0   0.0     0.0     1.0   0.0                             22 7   0     0     1   0                       22
1732558 1732558 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12.0 2020   grade_8 3.0   1.0     0.0     0.0   0.0                             20 3   1     0     0   0                       20
1732559 1732559 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12.0 2020   grade_9 8.0   1.0     0.0     1.0   0.0                             20 8   1     0     1   0                       20
1732560 1732560 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12.0 2020   k_12_total 57.0   2.0     1.0     6.0   4.0                             133 57   2     1     6   4                       133
1732561 1732561 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12.0 2020   kindergarten 0.0   0.0     0.0     0.0   0.0                             0 0   0     0     0   0                       0
1732562 1732562 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12.0 2020   pk_12_total 57.0   2.0     1.0     6.0   4.0                             133 57   2     1     6   4                       133
1732563 1732563 AK     school 200070 11   Copper River Schools 20007000039 110070 Glennallen Jr/Sr High School   Regular School No High 07 12.0 2020   pre_kindergarten 0.0   0.0     0.0     0.0   0.0                             0 0   0     0     0   0                       0
1732564 1732564 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12.0 2020   grade_1 5.0                   1.0                             6 5                   1                       6
1732565 1732565 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12.0 2020   grade_10 4.0                   0.0                             6 4                   0                       6
1732566 1732566 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12.0 2020   grade_11 4.0                   3.0                             7 4                   3                       7
1732567 1732567 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12.0 2020   grade_12 2.0                   0.0                             3 2                   0                       3
1732568 1732568 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12.0 2020   grade_2 1.0                   2.0                             4 1                   2                       4
1732569 1732569 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12.0 2020   grade_3 1.0                   2.0                             4 1                   2                       4
1732570 1732570 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12.0 2020   grade_4 1.0                   0.0                             4 1                   0                       4
1732571 1732571 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12.0 2020   grade_5 3.0                   3.0                             6 3                   3                       6
1732572 1732572 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12.0 2020   grade_6 3.0                   0.0                             6 3                   0                       6
1732573 1732573 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12.0 2020   grade_7 2.0                   2.0                             5 2                   2                       5
1732574 1732574 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12.0 2020   grade_8 1.0                   0.0                             4 1                   0                       4
1732575 1732575 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12.0 2020   grade_9 2.0                   0.0                             2 2                   0                       2
1732576 1732576 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12.0 2020   k_12_total 35.0                   15.0                             66 35                   15                       66
1732577 1732577 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12.0 2020   kindergarten 6.0                   2.0                             9 6                   2                       9
1732578 1732578 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12.0 2020   pk_12_total 35.0                   15.0                             66 35                   15                       66
1732579 1732579 AK     school 200070 11   Copper River Schools 20007000036 110100 Kenny Lake School   Regular School No Other PK 12.0 2020   pre_kindergarten 0.0                   0.0                             0 0                   0                       0
1732580 1732580 AK     school 200070 11   Copper River Schools 20007000583 110110 Slana School   Regular School No Other PK 12.0 2020   grade_1 1.0                                                 1 1                                           1
1732581 1732581 AK     school 200070 11   Copper River Schools 20007000583 110110 Slana School   Regular School No Other PK 12.0 2020   grade_10 0.0                                                 0 0                                           0
1732582 1732582 AK     school 200070 11   Copper River Schools 20007000583 110110 Slana School   Regular School No Other PK 12.0 2020   grade_11 0.0                                                 0 0                                           0
1732583 1732583 AK     school 200070 11   Copper River Schools 20007000583 110110 Slana School   Regular School No Other PK 12.0 2020   grade_12 2.0                                                 2 2                                           2
1732584 1732584 AK     school 200070 11   Copper River Schools 20007000583 110110 Slana School   Regular School No Other PK 12.0 2020   grade_2 0.0                                                 1 0                                           1
1732585 1732585 AK     school 200070 11   Copper River Schools 20007000583 110110 Slana School   Regular School No Other PK 12.0 2020   grade_3 0.0                                                 0 0                                           0
1732586 1732586 AK     school 200070 11   Copper River Schools 20007000583 110110 Slana School   Regular School No Other PK 12.0 2020   grade_4 0.0                                                 0 0                                           0
1732587 1732587 AK     school 200070 11   Copper River Schools 20007000583 110110 Slana School   Regular School No Other PK 12.0 2020   grade_5 0.0                                                 0 0                                           0
1732588 1732588 AK     school 200070 11   Copper River Schools 20007000583 110110 Slana School   Regular School No Other PK 12.0 2020   grade_6 0.0                                                 1 0                                           1
1732589 1732589 AK     school 200070 11   Copper River Schools 20007000583 110110 Slana School   Regular School No Other PK 12.0 2020   grade_7 1.0                                                 2 1                                           2
1732590 1732590 AK     school 200070 11   Copper River Schools 20007000583 110110 Slana School   Regular School No Other PK 12.0 2020   grade_8 0.0                                                 0 0                                           0
1732591 1732591 AK     school 200070 11   Copper River Schools 20007000583 110110 Slana School   Regular School No Other PK 12.0 2020   grade_9 2.0                                                 3 2                                           3
1732592 1732592 AK     school 200070 11   Copper River Schools 20007000583 110110 Slana School   Regular School No Other PK 12.0 2020   k_12_total 6.0                                                 10 6                                           10
1732593 1732593 AK     school 200070 11   Copper River Schools 20007000583 110110 Slana School   Regular School No Other PK 12.0 2020   kindergarten 0.0                                                 0 0                                           0
1732594 1732594 AK     school 200070 11   Copper River Schools 20007000583 110110 Slana School   Regular School No Other PK 12.0 2020   pk_12_total 6.0                                                 10 6                                           10
1732595 1732595 AK     school 200070 11   Copper River Schools 20007000583 110110 Slana School   Regular School No Other PK 12.0 2020   pre_kindergarten 0.0                                                 0 0                                           0
1732596 1732596 AK     school 200070 11   Copper River Schools 20007000398 118010 Upstream Learning Correspondence   Regular School No Other PK 12.0 2020   grade_1 6.0   0.0 0.0             0.0                             6 6   0 0             0                       6
1732597 1732597 AK     school 200070 11   Copper River Schools 20007000398 118010 Upstream Learning Correspondence   Regular School No Other PK 12.0 2020   grade_10 4.0   0.0 0.0             0.0                             5 4   0 0             0                       5
1732598 1732598 AK     school 200070 11   Copper River Schools 20007000398 118010 Upstream Learning Correspondence   Regular School No Other PK 12.0 2020   grade_11 7.0   0.0 0.0             0.0                             7 7   0 0             0                       7
1732599 1732599 AK     school 200070 11   Copper River Schools 20007000398 118010 Upstream Learning Correspondence   Regular School No Other PK 12.0 2020   grade_12 6.0   0.0 0.0             0.0                             6 6   0 0             0                       6
1732600 1732600 AK     school 200070 11   Copper River Schools 20007000398 118010 Upstream Learning Correspondence   Regular School No Other PK 12.0 2020   grade_2 17.0   0.0 0.0             0.0                             17 17   0 0             0                       17
1732601 1732601 AK     school 200070 11   Copper River Schools 20007000398 118010 Upstream Learning Correspondence   Regular School No Other PK 12.0 2020   grade_3 9.0   0.0 1.0             1.0                             12 9   0 1             1                       12
1732602 1732602 AK     school 200070 11   Copper River Schools 20007000398 118010 Upstream Learning Correspondence   Regular School No Other PK 12.0 2020   grade_4 12.0   0.0 1.0             0.0                             16 12   0 1             0                       16
1732603 1732603 AK     school 200070 11   Copper River Schools 20007000398 118010 Upstream Learning Correspondence   Regular School No Other PK 12.0 2020   grade_5 8.0   0.0 0.0             0.0                             8 8   0 0             0                       8

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