Data source: Big Local News · About: Big Local

12,592 rows where state = "MS" sorted by district_state_id

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
2034003 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   *                                              
2034004 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2020   kindergarten                                                   70                                             70
2034005 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2020   elementary_spec_ed                                                   *                                              
2034006 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2020   grade_1                                                   52                                             52
2034007 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2020   grade_2                                                   55                                             55
2034008 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2020   grade_3                                                   78                                             78
2034009 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2020   grade_4                                                   69                                             69
2034010 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2020   grade_5                                                   65                                             65
2034011 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2020   grade_6                                                   67                                             67
2034012 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2020   pk_12_total 335 154 *     *         10   269.0 235.0                       504 335 154                 10   269 235                 504
2034013 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_7                                                   101                                             101
2034014 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   79                                             79
2034015 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   82                                             82
2034016 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_10                                                   77                                             77
2034017 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   *                                              
2034018 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_12                                                   70                                             70
2034019 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   secondary_spec_ed                                                   *                                              
2034020 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   pk_12_total 267 183 *     *         14   264.0 204.0                       468 267 183                 14   264 204                 468
2034021 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   *                                              
2034022 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2020   kindergarten                                                   *                                              
2034023 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2020   grade_1                                                   19                                             19
2034024 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2020   grade_2                                                   11                                             11
2034025 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2020   grade_3                                                   11                                             11
2034026 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2020   grade_4                                                   21                                             21
2034027 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2020   grade_5                                                   25                                             25
2034028 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2020   grade_6                                                   25                                             25
2034029 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2020   pk_12_total 105 * *                   70.0 64.0                       134 105                       70 64                 134
2034030 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   *                                              
2034031 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   kindergarten                                                   *                                              
2034032 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_1                                                   14                                             14
2034033 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2                                                   20                                             20
2034034 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3                                                   23                                             23
2034035 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_4                                                   23                                             23
2034036 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_5                                                   33                                             33
2034037 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_6                                                   28                                             28
2034038 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   pk_12_total 50 118 *               *   91.0 81.0                       172 50 118                     91 81                 172
2240539 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   *                                              
2240540 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2021   kindergarten                                                   63                                             63
2240541 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2021   elementary_spec_ed                                                   *                                              
2240542 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2021   grade_1                                                   63                                             63
2240543 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2021   grade_2                                                   55                                             55
2240544 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2021   grade_3                                                   52                                             52
2240545 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2021   grade_4                                                   77                                             77
2240546 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2021   grade_5                                                   65                                             65
2240547 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2021   grade_6                                                   63                                             63
2240548 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2021   pk_12_total 323 145 *     *         14   269 219                       488 323 145                 14   269 219                 488
2240549 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   89                                             89
2240550 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_8                                                   97                                             97
2240551 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   75                                             75
2240552 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_10                                                   79                                             79
2240553 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_11                                                   71                                             71
2240554 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_12                                                   *                                              
2240555 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   secondary_spec_ed                                                   *                                              
2240556 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   pk_12_total 241 202 *     *         14   258 206                       464 241 202                 14   258 206                 464
2240557 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   12                                             12
2240558 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2021   kindergarten                                                   *                                              
2240559 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2021   grade_1                                                   17                                             17
2240560 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2021   grade_2                                                   14                                             14
2240561 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2021   grade_3                                                   *                                              
2240562 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2021   grade_4                                                   11                                             11
2240563 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2021   grade_5                                                   14                                             14
2240564 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2021   grade_6                                                   24                                             24
2240565 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2021   pk_12_total 94 * *                   61 51                       112 94                       61 51                 112
2240566 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   16                                             16
2240567 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten                                                   18                                             18
2240568 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1                                                   18                                             18
2240569 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2                                                   *                                              
2240570 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_3                                                   21                                             21
2240571 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_4                                                   *                                              
2240572 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5                                                   16                                             16
2240573 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6                                                   24                                             24
2240574 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   pk_12_total 35 99 *               *   73 64                       137 35 99                     73 64                 137
2034039 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   40                                             40
2034040 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 06 2020   kindergarten                                                   97                                             97
2034041 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 06 2020   elementary_spec_ed                                                   29                                             29
2034042 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 06 2020   grade_1                                                   85                                             85
2034043 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 06 2020   grade_2                                                   92                                             92
2034044 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 06 2020   grade_3                                                   99                                             99
2034045 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 06 2020   grade_4                                                   107                                             107
2034046 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 06 2020   grade_5                                                   98                                             98
2034047 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 06 2020   grade_6                                                   105                                             105
2034048 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 06 2020   pk_12_total * 741       *         *   366.0 386.0                       752   741                     366 386                 752
2034049 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102000115 1100004 PORT GIBSON MIDDLE SCHOOL   Regular School No Middle 07 08 2020   elementary_spec_ed                                                   *                                              
2034050 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102000115 1100004 PORT GIBSON MIDDLE SCHOOL   Regular School No Middle 07 08 2020   grade_7                                                   126                                             126
2034051 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102000115 1100004 PORT GIBSON MIDDLE SCHOOL   Regular School No Middle 07 08 2020   grade_8                                                   *                                              
2034052 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102000115 1100004 PORT GIBSON MIDDLE SCHOOL   Regular School No Middle 07 08 2020   pk_12_total   *       *             104.0 99.0                       203                         104 99                 203
2034053 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102000116 1100008 PORT GIBSON HIGH SCHOOL   Regular School No High 09 12 2020   grade_9                                                   107                                             107
2034054 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102000116 1100008 PORT GIBSON HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   117                                             117
2034055 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102000116 1100008 PORT GIBSON HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   83                                             83
2034056 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102000116 1100008 PORT GIBSON HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   96                                             96
2034057 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102000116 1100008 PORT GIBSON HIGH SCHOOL   Regular School No High 09 12 2020   secondary_spec_ed                                                   16                                             16
2034058 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102000116 1100008 PORT GIBSON HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total * 416       *             227.0 192.0                       419   416                     227 192                 419
2240575 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   40                                             40
2240576 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 05 2021   kindergarten                                                   85                                             85
2240577 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   19                                             19
2240578 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 05 2021   grade_1                                                   96                                             96
2240579 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 05 2021   grade_2                                                   85                                             85
2240580 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 05 2021   grade_3                                                   88                                             88
2240581 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 05 2021   grade_4                                                   94                                             94
2240582 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 05 2021   grade_5                                                   106                                             106

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