Data source: Big Local News · About: Big Local

12,592 rows where state = "MS"

View and edit SQL

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
2033680 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000458 420008 KOSCIUSKO LOWER ELEM   Regular School No Elementary PK 01 2020   pre_kindergarten_spec_ed                                                   *                                              
2033681 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000458 420008 KOSCIUSKO LOWER ELEM   Regular School No Elementary PK 01 2020   kindergarten                                                   150                                             150
2033682 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000458 420008 KOSCIUSKO LOWER ELEM   Regular School No Elementary PK 01 2020   kindergarten_spec_ed                                                   *                                              
2033683 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000458 420008 KOSCIUSKO LOWER ELEM   Regular School No Elementary PK 01 2020   elementary_spec_ed                                                   *                                              
2033684 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000458 420008 KOSCIUSKO LOWER ELEM   Regular School No Elementary PK 01 2020   grade_1                                                   159                                             159
2033685 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000458 420008 KOSCIUSKO LOWER ELEM   Regular School No Elementary PK 01 2020   pk_12_total 188 257 12     *     *   *   234.0 234.0                       468 188 257 12                   234 234                 468
2033686 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000459 420012 KOSCIUSKO MIDDLE   Regular School No Elementary 02 03 2020   elementary_spec_ed                                                   *                                              
2033687 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000459 420012 KOSCIUSKO MIDDLE   Regular School No Elementary 02 03 2020   grade_2                                                   172                                             172
2033688 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000459 420012 KOSCIUSKO MIDDLE   Regular School No Elementary 02 03 2020   grade_3                                                   *                                              
2033689 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000459 420012 KOSCIUSKO MIDDLE   Regular School No Elementary 02 03 2020   pk_12_total 120 206 *   * *         *   175.0 166.0                       341 120 206                     175 166                 341
2033690 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000460 420016 KOSCIUSKO SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_9                                                   170                                             170
2033691 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000460 420016 KOSCIUSKO SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   165                                             165
2033692 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000460 420016 KOSCIUSKO SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   *                                              
2033693 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000460 420016 KOSCIUSKO SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   142                                             142
2033694 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000460 420016 KOSCIUSKO SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   secondary_spec_ed                                                   *                                              
2033695 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000460 420016 KOSCIUSKO SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 247 332 *     *             281.0 323.0                       604 247 332                     281 323                 604
2033696 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000461 420020 KOSCIUSKO UPPER ELEM   Regular School No Elementary 04 05 2020   elementary_spec_ed                                                   *                                              
2033697 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000461 420020 KOSCIUSKO UPPER ELEM   Regular School No Elementary 04 05 2020   grade_4                                                   *                                              
2033698 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000461 420020 KOSCIUSKO UPPER ELEM   Regular School No Elementary 04 05 2020   grade_5                                                   170                                             170
2033699 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000461 420020 KOSCIUSKO UPPER ELEM   Regular School No Elementary 04 05 2020   pk_12_total 129 174 13   * *         *   162.0 162.0                       324 129 174 13                   162 162                 324
2033700 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000048 500004 ASHLAND ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   kindergarten                                                   42                                             42
2033701 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000048 500004 ASHLAND ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   elementary_spec_ed                                                   *                                              
2033702 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000048 500004 ASHLAND ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_1                                                   38                                             38
2033703 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000048 500004 ASHLAND ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2                                                   *                                              
2033704 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000048 500004 ASHLAND ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_3                                                   41                                             41
2033705 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000048 500004 ASHLAND ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_4                                                   40                                             40
2033706 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000048 500004 ASHLAND ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_5                                                   47                                             47
2033707 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000048 500004 ASHLAND ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_6                                                   32                                             32
2033708 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000048 500004 ASHLAND ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   pk_12_total 30 220 15               14   147.0 132.0                       279 30 220 15               14   147 132                 279
2033709 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000049 500006 ASHLAND MIDDLE-HIGH SCHOOL   Regular School No High 07 12 2020   elementary_spec_ed                                                   *                                              
2033710 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000049 500006 ASHLAND MIDDLE-HIGH SCHOOL   Regular School No High 07 12 2020   grade_7                                                   33                                             33
2033711 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000049 500006 ASHLAND MIDDLE-HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   39                                             39
2033712 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000049 500006 ASHLAND MIDDLE-HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   35                                             35
2033713 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000049 500006 ASHLAND MIDDLE-HIGH SCHOOL   Regular School No High 07 12 2020   grade_10                                                   28                                             28
2033714 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000049 500006 ASHLAND MIDDLE-HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   44                                             44
2033715 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000049 500006 ASHLAND MIDDLE-HIGH SCHOOL   Regular School No High 07 12 2020   grade_12                                                   36                                             36
2033716 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000049 500006 ASHLAND MIDDLE-HIGH SCHOOL   Regular School No High 07 12 2020   secondary_spec_ed                                                   *                                              
2033717 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000049 500006 ASHLAND MIDDLE-HIGH SCHOOL   Regular School No High 07 12 2020   pk_12_total 16 188 *               *   107.0 118.0                       225 16 188                     107 118                 225
2033718 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   kindergarten                                                   46                                             46
2033719 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   elementary_spec_ed                                                   *                                              
2033720 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_1                                                   43                                             43
2033721 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_2                                                   34                                             34
2033722 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_3                                                   32                                             32
2033723 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_4                                                   39                                             39
2033724 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_5                                                   40                                             40
2033725 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_6                                                   46                                             46
2033726 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_7                                                   48                                             48
2033727 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   38                                             38
2033728 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_9                                                   43                                             43
2033729 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_10                                                   41                                             41
2033730 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_11                                                   32                                             32
2033731 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_12                                                   *                                              
2033732 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   pk_12_total 426 69 *               *   269.0 246.0                       515 426 69                     269 246                 515
2033733 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001476 614003 D.M. SMITH ELEMENTARY   Regular School No Elementary 03 06 2020   grade_3                                                   93                                             93
2033734 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001476 614003 D.M. SMITH ELEMENTARY   Regular School No Elementary 03 06 2020   grade_4                                                   77                                             77
2033735 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001476 614003 D.M. SMITH ELEMENTARY   Regular School No Elementary 03 06 2020   grade_5                                                   103                                             103
2033736 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001476 614003 D.M. SMITH ELEMENTARY   Regular School No Elementary 03 06 2020   grade_6                                                   100                                             100
2033737 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001476 614003 D.M. SMITH ELEMENTARY   Regular School No Elementary 03 06 2020   pk_12_total * 361                 *   199.0 174.0                       373   361                     199 174                 373
2033738 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000075 614004 BELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   *                                              
2033739 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000075 614004 BELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   pre_kindergarten_spec_ed                                                   *                                              
2033740 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000075 614004 BELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   kindergarten                                                   45                                             45
2033741 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000075 614004 BELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_1                                                   47                                             47
2033742 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000075 614004 BELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2                                                   47                                             47
2033743 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000075 614004 BELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3                                                   46                                             46
2033744 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000075 614004 BELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_4                                                   45                                             45
2033745 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000075 614004 BELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_5                                                   42                                             42
2033746 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000075 614004 BELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_6                                                   48                                             48
2033747 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000075 614004 BELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   pk_12_total 160 176 *     10     *   15   192.0 180.0                       372 160 176       10         15   192 180                 372
2033748 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001475 614007 CLEVELAND CENTRAL MIDDLE SCHOOL   Regular School No Middle 07 08 2020   grade_7                                                   258                                             258
2033749 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001475 614007 CLEVELAND CENTRAL MIDDLE SCHOOL   Regular School No Middle 07 08 2020   grade_8                                                   265                                             265
2033750 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001475 614007 CLEVELAND CENTRAL MIDDLE SCHOOL   Regular School No Middle 07 08 2020   secondary_spec_ed                                                   20                                             20
2033751 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001475 614007 CLEVELAND CENTRAL MIDDLE SCHOOL   Regular School No Middle 07 08 2020   pk_12_total 102 403 *     *     *   24   262.0 281.0                       543 102 403                 24   262 281                 543
2033752 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001477 614009 CLEVELAND CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_9                                                   224                                             224
2033753 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001477 614009 CLEVELAND CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   221                                             221
2033754 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001477 614009 CLEVELAND CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   192                                             192
2033755 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001477 614009 CLEVELAND CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   188                                             188
2033756 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001477 614009 CLEVELAND CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   secondary_spec_ed                                                   21                                             21
2033757 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001477 614009 CLEVELAND CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 147 663 *     *         17   415.0 431.0                       846 147 663                 17   415 431                 846
2033758 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001212 614020 HAYES COOPER CENTER FOR MATH SC TEC   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   44                                             44
2033759 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001212 614020 HAYES COOPER CENTER FOR MATH SC TEC   Regular School No Elementary PK 06 2020   kindergarten                                                   43                                             43
2033760 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001212 614020 HAYES COOPER CENTER FOR MATH SC TEC   Regular School No Elementary PK 06 2020   grade_1                                                   46                                             46
2033761 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001212 614020 HAYES COOPER CENTER FOR MATH SC TEC   Regular School No Elementary PK 06 2020   grade_2                                                   46                                             46
2033762 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001212 614020 HAYES COOPER CENTER FOR MATH SC TEC   Regular School No Elementary PK 06 2020   grade_3                                                   39                                             39
2033763 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001212 614020 HAYES COOPER CENTER FOR MATH SC TEC   Regular School No Elementary PK 06 2020   grade_4                                                   40                                             40
2033764 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001212 614020 HAYES COOPER CENTER FOR MATH SC TEC   Regular School No Elementary PK 06 2020   grade_5                                                   38                                             38
2033765 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001212 614020 HAYES COOPER CENTER FOR MATH SC TEC   Regular School No Elementary PK 06 2020   grade_6                                                   41                                             41
2033766 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001212 614020 HAYES COOPER CENTER FOR MATH SC TEC   Regular School No Elementary PK 06 2020   pk_12_total 157 143 *     *         17   161.0 176.0                       337 157 143                 17   161 176                 337
2033767 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000083 614024 NAILOR ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   pre_kindergarten                                                   14                                             14
2033768 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000083 614024 NAILOR ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   kindergarten                                                   105                                             105
2033769 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000083 614024 NAILOR ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   elementary_spec_ed                                                   10                                             10
2033770 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000083 614024 NAILOR ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   grade_1                                                   101                                             101
2033771 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000083 614024 NAILOR ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   grade_2                                                   100                                             100
2033772 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000083 614024 NAILOR ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   pk_12_total * 320                 *   160.0 170.0                       330   320                     160 170                 330
2033773 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000084 614028 PARKS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   13                                             13
2033774 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000084 614028 PARKS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   kindergarten                                                   37                                             37
2033775 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000084 614028 PARKS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   elementary_spec_ed                                                   23                                             23
2033776 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000084 614028 PARKS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_1                                                   28                                             28
2033777 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000084 614028 PARKS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2                                                   30                                             30
2033778 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000084 614028 PARKS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3                                                   36                                             36
2033779 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000084 614028 PARKS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_4                                                   40                                             40

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