enrollments

Data source: Big Local News · About: Big Local

12,592 rows where state = "MS"

✎ 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
2033580 2033580 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_2                                                   72                                             72
2033581 2033581 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_3                                                   106                                             106
2033582 2033582 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_4                                                   97                                             97
2033583 2033583 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   pk_12_total 565 * *               *   296.0 284.0                       580 565                       296 284                 580
2033584 2033584 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   elementary_spec_ed                                                   *                                              
2033585 2033585 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5                                                   97                                             97
2033586 2033586 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_6                                                   99                                             99
2033587 2033587 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7                                                   116                                             116
2033588 2033588 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_8                                                   122                                             122
2033589 2033589 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   secondary_spec_ed                                                   *                                              
2033590 2033590 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   pk_12_total 428 * *               *   207.0 236.0                       443 428                       207 236                 443
2033591 2033591 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000020 200024 KOSSUTH HIGH SCHOOL   Regular School No High 09 12 2020   grade_9                                                   101                                             101
2033592 2033592 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000020 200024 KOSSUTH HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   *                                              
2033593 2033593 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000020 200024 KOSSUTH HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   104                                             104
2033594 2033594 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000020 200024 KOSSUTH HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   107                                             107
2033595 2033595 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000020 200024 KOSSUTH HIGH SCHOOL   Regular School No High 09 12 2020   secondary_spec_ed                                                   *                                              
2033596 2033596 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000020 200024 KOSSUTH HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 395 * *   * *         *   212.0 200.0                       412 395                       212 200                 412
2033597 2033597 MS     school 2801260 220   CORINTH SCHOOL DIST 280126001368 220002 CORINTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   138                                             138
2033598 2033598 MS     school 2801260 220   CORINTH SCHOOL DIST 280126001368 220002 CORINTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   pre_kindergarten_spec_ed                                                   11                                             11
2033599 2033599 MS     school 2801260 220   CORINTH SCHOOL DIST 280126001368 220002 CORINTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   kindergarten                                                   200                                             200
2033600 2033600 MS     school 2801260 220   CORINTH SCHOOL DIST 280126001368 220002 CORINTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   kindergarten_spec_ed                                                   11                                             11
2033601 2033601 MS     school 2801260 220   CORINTH SCHOOL DIST 280126001368 220002 CORINTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   elementary_spec_ed                                                   18                                             18
2033602 2033602 MS     school 2801260 220   CORINTH SCHOOL DIST 280126001368 220002 CORINTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_1                                                   221                                             221
2033603 2033603 MS     school 2801260 220   CORINTH SCHOOL DIST 280126001368 220002 CORINTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_2                                                   242                                             242
2033604 2033604 MS     school 2801260 220   CORINTH SCHOOL DIST 280126001368 220002 CORINTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_3                                                   221                                             221
2033605 2033605 MS     school 2801260 220   CORINTH SCHOOL DIST 280126001368 220002 CORINTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_4                                                   199                                             199
2033606 2033606 MS     school 2801260 220   CORINTH SCHOOL DIST 280126001368 220002 CORINTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   pk_12_total 666 359 125     11         100   646.0 615.0                       1261 666 359 125     11         100   646 615                 1261
2033607 2033607 MS     school 2801260 220   CORINTH SCHOOL DIST 280126000171 220004 CORINTH HIGH SCHOOL   Regular School No High 09 12 2020   grade_9                                                   171                                             171
2033608 2033608 MS     school 2801260 220   CORINTH SCHOOL DIST 280126000171 220004 CORINTH HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   136                                             136
2033609 2033609 MS     school 2801260 220   CORINTH SCHOOL DIST 280126000171 220004 CORINTH HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   133                                             133
2033610 2033610 MS     school 2801260 220   CORINTH SCHOOL DIST 280126000171 220004 CORINTH HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   165                                             165
2033611 2033611 MS     school 2801260 220   CORINTH SCHOOL DIST 280126000171 220004 CORINTH HIGH SCHOOL   Regular School No High 09 12 2020   secondary_spec_ed                                                   12                                             12
2033612 2033612 MS     school 2801260 220   CORINTH SCHOOL DIST 280126000171 220004 CORINTH HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 340 176 73     10         18   304.0 313.0                       617 340 176 73     10         18   304 313                 617
2033613 2033613 MS     school 2801260 220   CORINTH SCHOOL DIST 280126000006 220006 CORINTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   elementary_spec_ed                                                   *                                              
2033614 2033614 MS     school 2801260 220   CORINTH SCHOOL DIST 280126000006 220006 CORINTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5                                                   175                                             175
2033615 2033615 MS     school 2801260 220   CORINTH SCHOOL DIST 280126000006 220006 CORINTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_6                                                   212                                             212
2033616 2033616 MS     school 2801260 220   CORINTH SCHOOL DIST 280126000006 220006 CORINTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7                                                   216                                             216
2033617 2033617 MS     school 2801260 220   CORINTH SCHOOL DIST 280126000006 220006 CORINTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_8                                                   187                                             187
2033618 2033618 MS     school 2801260 220   CORINTH SCHOOL DIST 280126000006 220006 CORINTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   secondary_spec_ed                                                   *                                              
2033619 2033619 MS     school 2801260 220   CORINTH SCHOOL DIST 280126000006 220006 CORINTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   pk_12_total 423 236 88     11         42   405.0 395.0                       800 423 236 88     11         42   405 395                 800
2033620 2033620 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042000027 300008 AMITE COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_7                                                   94                                             94
2033621 2033621 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042000027 300008 AMITE COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   65                                             65
2033622 2033622 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042000027 300008 AMITE COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   76                                             76
2033623 2033623 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042000027 300008 AMITE COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_10                                                   79                                             79
2033624 2033624 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042000027 300008 AMITE COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   51                                             51
2033625 2033625 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042000027 300008 AMITE COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_12                                                   56                                             56
2033626 2033626 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042000027 300008 AMITE COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   secondary_spec_ed                                                   *                                              
2033627 2033627 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042000027 300008 AMITE COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   ged                                                   *                                              
2033628 2033628 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042000027 300008 AMITE COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   pk_12_total 65 361 *               *   222.0 212.0                       434 65 361                     222 212                 434
2033629 2033629 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042001375 300014 AMITE COUNTY ELEMENTARY   Regular School No Elementary KG 06 2020   kindergarten                                                   79                                             79
2033630 2033630 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042001375 300014 AMITE COUNTY ELEMENTARY   Regular School No Elementary KG 06 2020   elementary_spec_ed                                                   *                                              
2033631 2033631 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042001375 300014 AMITE COUNTY ELEMENTARY   Regular School No Elementary KG 06 2020   grade_1                                                   72                                             72
2033632 2033632 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042001375 300014 AMITE COUNTY ELEMENTARY   Regular School No Elementary KG 06 2020   grade_2                                                   68                                             68
2033633 2033633 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042001375 300014 AMITE COUNTY ELEMENTARY   Regular School No Elementary KG 06 2020   grade_3                                                   73                                             73
2033634 2033634 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042001375 300014 AMITE COUNTY ELEMENTARY   Regular School No Elementary KG 06 2020   grade_4                                                   *                                              
2033635 2033635 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042001375 300014 AMITE COUNTY ELEMENTARY   Regular School No Elementary KG 06 2020   grade_5                                                   71                                             71
2033636 2033636 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042001375 300014 AMITE COUNTY ELEMENTARY   Regular School No Elementary KG 06 2020   grade_6                                                   78                                             78
2033637 2033637 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042001375 300014 AMITE COUNTY ELEMENTARY   Regular School No Elementary KG 06 2020   pk_12_total 79 406 *   *           *   259.0 236.0                       495 79 406                     259 236                 495
2033638 2033638 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000036 400008 ETHEL ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_7                                                   49                                             49
2033639 2033639 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000036 400008 ETHEL ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_8                                                   48                                             48
2033640 2033640 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000036 400008 ETHEL ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_9                                                   49                                             49
2033641 2033641 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000036 400008 ETHEL ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_10                                                   44                                             44
2033642 2033642 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000036 400008 ETHEL ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_11                                                   38                                             38
2033643 2033643 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000036 400008 ETHEL ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_12                                                   *                                              
2033644 2033644 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000036 400008 ETHEL ATTENDANCE CENTER   Regular School No High 07 12 2020   secondary_spec_ed                                                   *                                              
2033645 2033645 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000036 400008 ETHEL ATTENDANCE CENTER   Regular School No High 07 12 2020   pk_12_total 207 56 *               *   143.0 123.0                       266 207 56                     143 123                 266
2033646 2033646 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000037 400012 GREENLEE ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   *                                              
2033647 2033647 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000037 400012 GREENLEE ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   kindergarten                                                   31                                             31
2033648 2033648 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000037 400012 GREENLEE ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   elementary_spec_ed                                                   *                                              
2033649 2033649 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000037 400012 GREENLEE ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   grade_1                                                   43                                             43
2033650 2033650 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000037 400012 GREENLEE ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   grade_2                                                   33                                             33
2033651 2033651 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000037 400012 GREENLEE ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   grade_3                                                   29                                             29
2033652 2033652 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000037 400012 GREENLEE ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   grade_4                                                   51                                             51
2033653 2033653 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000037 400012 GREENLEE ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   grade_5                                                   52                                             52
2033654 2033654 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000037 400012 GREENLEE ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   grade_6                                                   54                                             54
2033655 2033655 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000037 400012 GREENLEE ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   pk_12_total 242 77 *     *         *   168.0 157.0                       325 242 77                     168 157                 325
2033656 2033656 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000038 400016 LONG CREEK ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   31                                             31
2033657 2033657 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000038 400016 LONG CREEK ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   kindergarten                                                   32                                             32
2033658 2033658 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000038 400016 LONG CREEK ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   elementary_spec_ed                                                   *                                              
2033659 2033659 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000038 400016 LONG CREEK ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   grade_1                                                   33                                             33
2033660 2033660 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000038 400016 LONG CREEK ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   grade_2                                                   35                                             35
2033661 2033661 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000038 400016 LONG CREEK ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   grade_3                                                   40                                             40
2033662 2033662 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000038 400016 LONG CREEK ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   grade_4                                                   31                                             31
2033663 2033663 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000038 400016 LONG CREEK ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   grade_5                                                   41                                             41
2033664 2033664 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000038 400016 LONG CREEK ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   grade_6                                                   *                                              
2033665 2033665 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000038 400016 LONG CREEK ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   pk_12_total * 262                 *   146.0 128.0                       274   262                     146 128                 274
2033666 2033666 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000039 400020 MCADAMS ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_7                                                   30                                             30
2033667 2033667 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000039 400020 MCADAMS ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_8                                                   35                                             35
2033668 2033668 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000039 400020 MCADAMS ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_9                                                   34                                             34
2033669 2033669 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000039 400020 MCADAMS ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_10                                                   *                                              
2033670 2033670 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000039 400020 MCADAMS ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_11                                                   26                                             26
2033671 2033671 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000039 400020 MCADAMS ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_12                                                   26                                             26
2033672 2033672 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000039 400020 MCADAMS ATTENDANCE CENTER   Regular School No High 07 12 2020   secondary_spec_ed                                                   *                                              
2033673 2033673 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000039 400020 MCADAMS ATTENDANCE CENTER   Regular School No High 07 12 2020   pk_12_total * *                     87.0 94.0                       181                         87 94                 181
2033674 2033674 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000457 420004 KOSCIUSKO JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2033675 2033675 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000457 420004 KOSCIUSKO JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2020   grade_6                                                   202                                             202
2033676 2033676 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000457 420004 KOSCIUSKO JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2020   grade_7                                                   *                                              
2033677 2033677 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000457 420004 KOSCIUSKO JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2020   grade_8                                                   180                                             180
2033678 2033678 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000457 420004 KOSCIUSKO JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2020   pk_12_total 199 329 17   * *     *   *   270.0 285.0                       555 199 329 17                   270 285                 555
2033679 2033679 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000458 420008 KOSCIUSKO LOWER ELEM   Regular School No Elementary PK 01 2020   pre_kindergarten                                                   151                                             151

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