Data source: Big Local News · About: Big Local

7,952 rows where state = "AK" and year = 2021 sorted by district_nces_id

View and edit SQL

year

  • 2021 · 7,952
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
1817635 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   grade_1       0.0                                           9.0       0                                     9
1817636 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   grade_10       0.0                                           4.0       0                                     4
1817637 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   grade_11       0.0                                           5.0       0                                     5
1817638 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   grade_12       0.0                                           6.0       0                                     6
1817639 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   grade_2       0.0                                           13.0       0                                     13
1817640 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   grade_3       0.0                                           7.0       0                                     7
1817641 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   grade_4       0.0                                           8.0       0                                     8
1817642 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   grade_5       1.0                                           6.0       1                                     6
1817643 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   grade_6       0.0                                           3.0       0                                     3
1817644 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   grade_7       0.0                                           8.0       0                                     8
1817645 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   grade_8       0.0                                           9.0       0                                     9
1817646 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   grade_9       0.0                                           12.0       0                                     12
1817647 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   k_12_total       1.0                                           96.0       1                                     96
1817648 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   kindergarten       0.0                                           6.0       0                                     6
1817649 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   pk_12_total       1.0                                           98.0       1                                     98
1817650 AK     school 200001 31   Lower Kuskokwim Schools 20000100206 310030 Joann A. Alexie Memorial School   Regular School No Other PK 12 2021   pre_kindergarten       0.0                                           2.0       0                                     2
1817651 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   grade_1                                                   9.0                                             9
1817652 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   grade_10                                                   11.0                                             11
1817653 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   grade_11                                                   3.0                                             3
1817654 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   grade_12                                                   5.0                                             5
1817655 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   grade_2                                                   7.0                                             7
1817656 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   grade_3                                                   6.0                                             6
1817657 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   grade_4                                                   8.0                                             8
1817658 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   grade_5                                                   7.0                                             7
1817659 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   grade_6                                                   6.0                                             6
1817660 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   grade_7                                                   4.0                                             4
1817661 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   grade_8                                                   7.0                                             7
1817662 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   grade_9                                                   5.0                                             5
1817663 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   k_12_total                                                   93.0                                             93
1817664 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   kindergarten                                                   15.0                                             15
1817665 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   pk_12_total                                                   99.0                                             99
1817666 AK     school 200001 31   Lower Kuskokwim Schools 20000100474 310040 Negtemiut Elitnaurviat School   Regular School No Other PK 12 2021   pre_kindergarten                                                   6.0                                             6
1817667 AK     school 200001 31   Lower Kuskokwim Schools 20000100436 310050 Mikelnguut Elitnaurviat   Regular School No Elementary PK 2 2021   grade_1 9.0   1.0 1.0   0.0         3.0                             87.0 9   1 1   0         3                       87
1817668 AK     school 200001 31   Lower Kuskokwim Schools 20000100436 310050 Mikelnguut Elitnaurviat   Regular School No Elementary PK 2 2021   grade_10 0.0   0.0 0.0   0.0         0.0                             0.0 0   0 0   0         0                       0
1817669 AK     school 200001 31   Lower Kuskokwim Schools 20000100436 310050 Mikelnguut Elitnaurviat   Regular School No Elementary PK 2 2021   grade_11 0.0   0.0 0.0   0.0         0.0                             0.0 0   0 0   0         0                       0
1817670 AK     school 200001 31   Lower Kuskokwim Schools 20000100436 310050 Mikelnguut Elitnaurviat   Regular School No Elementary PK 2 2021   grade_12 0.0   0.0 0.0   0.0         0.0                             0.0 0   0 0   0         0                       0
1817671 AK     school 200001 31   Lower Kuskokwim Schools 20000100436 310050 Mikelnguut Elitnaurviat   Regular School No Elementary PK 2 2021   grade_2 2.0   1.0 0.0   0.0         2.0                             77.0 2   1 0   0         2                       77
1817672 AK     school 200001 31   Lower Kuskokwim Schools 20000100436 310050 Mikelnguut Elitnaurviat   Regular School No Elementary PK 2 2021   grade_3 0.0   0.0 0.0   0.0         0.0                             0.0 0   0 0   0         0                       0
1817673 AK     school 200001 31   Lower Kuskokwim Schools 20000100436 310050 Mikelnguut Elitnaurviat   Regular School No Elementary PK 2 2021   grade_4 0.0   0.0 0.0   0.0         0.0                             0.0 0   0 0   0         0                       0
1817674 AK     school 200001 31   Lower Kuskokwim Schools 20000100436 310050 Mikelnguut Elitnaurviat   Regular School No Elementary PK 2 2021   grade_5 0.0   0.0 0.0   0.0         0.0                             0.0 0   0 0   0         0                       0
1817675 AK     school 200001 31   Lower Kuskokwim Schools 20000100436 310050 Mikelnguut Elitnaurviat   Regular School No Elementary PK 2 2021   grade_6 0.0   0.0 0.0   0.0         0.0                             0.0 0   0 0   0         0                       0
1817676 AK     school 200001 31   Lower Kuskokwim Schools 20000100436 310050 Mikelnguut Elitnaurviat   Regular School No Elementary PK 2 2021   grade_7 0.0   0.0 0.0   0.0         0.0                             0.0 0   0 0   0         0                       0
1817677 AK     school 200001 31   Lower Kuskokwim Schools 20000100436 310050 Mikelnguut Elitnaurviat   Regular School No Elementary PK 2 2021   grade_8 0.0   0.0 0.0   0.0         0.0                             0.0 0   0 0   0         0                       0
1817678 AK     school 200001 31   Lower Kuskokwim Schools 20000100436 310050 Mikelnguut Elitnaurviat   Regular School No Elementary PK 2 2021   grade_9 0.0   0.0 0.0   0.0         0.0                             0.0 0   0 0   0         0                       0
1817679 AK     school 200001 31   Lower Kuskokwim Schools 20000100436 310050 Mikelnguut Elitnaurviat   Regular School No Elementary PK 2 2021   k_12_total 17.0   2.0 1.0   1.0         5.0                             242.0 17   2 1   1         5                       242
1817680 AK     school 200001 31   Lower Kuskokwim Schools 20000100436 310050 Mikelnguut Elitnaurviat   Regular School No Elementary PK 2 2021   kindergarten 6.0   0.0 0.0   1.0         0.0                             78.0 6   0 0   1         0                       78
1817681 AK     school 200001 31   Lower Kuskokwim Schools 20000100436 310050 Mikelnguut Elitnaurviat   Regular School No Elementary PK 2 2021   pk_12_total 32.0   2.0 1.0   1.0         5.0                             276.0 32   2 1   1         5                       276
1817682 AK     school 200001 31   Lower Kuskokwim Schools 20000100436 310050 Mikelnguut Elitnaurviat   Regular School No Elementary PK 2 2021   pre_kindergarten 15.0   0.0 0.0   0.0         0.0                             34.0 15   0 0   0         0                       34
1817683 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6 2021   grade_1 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817684 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6 2021   grade_10 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817685 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6 2021   grade_11 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817686 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6 2021   grade_12 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817687 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6 2021   grade_2 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817688 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6 2021   grade_3 14.0 0.0 2.0 0.0   0.0         1.0                             90.0 14 0 2 0   0         1                       90
1817689 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6 2021   grade_4 6.0 1.0 0.0 1.0   1.0         0.0                             80.0 6 1 0 1   1         0                       80
1817690 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6 2021   grade_5 7.0 1.0 1.0 1.0   1.0         1.0                             85.0 7 1 1 1   1         1                       85
1817691 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6 2021   grade_6 12.0 0.0 2.0 1.0   0.0         0.0                             89.0 12 0 2 1   0         0                       89
1817692 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6 2021   grade_7 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817693 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6 2021   grade_8 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817694 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6 2021   grade_9 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817695 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6 2021   k_12_total 39.0 2.0 5.0 3.0   2.0         2.0                             344.0 39 2 5 3   2         2                       344
1817696 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6 2021   kindergarten 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817697 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6 2021   pk_12_total 39.0 2.0 5.0 3.0   2.0         2.0                             344.0 39 2 5 3   2         2                       344
1817698 AK     school 200001 31   Lower Kuskokwim Schools 20000100207 310060 Gladys Jung Elementary   Regular School No Elementary 03 6 2021   pre_kindergarten 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817699 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   grade_1 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817700 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   grade_10 2.0 0.0 0.0 2.0   1.0         0.0                             66.0 2 0 0 2   1         0                       66
1817701 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   grade_11 6.0 0.0 1.0 0.0   3.0         0.0                             54.0 6 0 1 0   3         0                       54
1817702 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   grade_12 7.0 2.0 0.0 2.0   0.0         0.0                             52.0 7 2 0 2   0         0                       52
1817703 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   grade_2 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817704 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   grade_3 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817705 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   grade_4 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817706 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   grade_5 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817707 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   grade_6 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817708 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   grade_7 11.0 1.0 2.0 0.0   2.0         0.0                             97.0 11 1 2 0   2         0                       97
1817709 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   grade_8 7.0 0.0 0.0 1.0   1.0         0.0                             85.0 7 0 0 1   1         0                       85
1817710 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   grade_9 10.0 1.0 2.0 0.0   1.0         2.0                             136.0 10 1 2 0   1         2                       136
1817711 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   k_12_total 43.0 4.0 5.0 5.0   8.0         2.0                             490.0 43 4 5 5   8         2                       490
1817712 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   kindergarten 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817713 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   pk_12_total 43.0 4.0 5.0 5.0   8.0         2.0                             490.0 43 4 5 5   8         2                       490
1817714 AK     school 200001 31   Lower Kuskokwim Schools 20000100208 310070 Bethel Regional High School   Regular School No High 07 12 2021   pre_kindergarten 0.0 0.0 0.0 0.0   0.0         0.0                             0.0 0 0 0 0   0         0                       0
1817715 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   grade_1                                                   12.0                                             12
1817716 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   grade_10                                                   10.0                                             10
1817717 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   grade_11                                                   6.0                                             6
1817718 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   grade_12                                                   10.0                                             10
1817719 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   grade_2                                                   12.0                                             12
1817720 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   grade_3                                                   9.0                                             9
1817721 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   grade_4                                                   8.0                                             8
1817722 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   grade_5                                                   11.0                                             11
1817723 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   grade_6                                                   11.0                                             11
1817724 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   grade_7                                                   13.0                                             13
1817725 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   grade_8                                                   12.0                                             12
1817726 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   grade_9                                                   22.0                                             22
1817727 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   k_12_total                                                   147.0                                             147
1817728 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   kindergarten                                                   11.0                                             11
1817729 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   pk_12_total                                                   147.0                                             147
1817730 AK     school 200001 31   Lower Kuskokwim Schools 20000100209 310080 Chaputnguak School   Regular School No Other PK 12 2021   pre_kindergarten                                                   0.0                                             0
1817731 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12 2021   grade_1                                                   6.0                                             6
1817732 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12 2021   grade_10                                                   11.0                                             11
1817733 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12 2021   grade_11                                                   3.0                                             3
1817734 AK     school 200001 31   Lower Kuskokwim Schools 20000100392 310090 Eek School   Regular School No Other PK 12 2021   grade_12                                                   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]);