Data source: Big Local News · About: Big Local

6,330 rows where state = "MS" and year = 2020 sorted by ccd_school_high_grade descending

View and edit SQL

year

  • 2020 · 6,330
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
2035027 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000289 2400020 HARRISON CO CHILD DEVELOPMENT CEN   Regular School No Ungraded UG UG 2020   pre_kindergarten_spec_ed                                                   63                                             63
2035028 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000289 2400020 HARRISON CO CHILD DEVELOPMENT CEN   Regular School No Ungraded UG UG 2020   kindergarten_spec_ed                                                   *                                              
2035029 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000289 2400020 HARRISON CO CHILD DEVELOPMENT CEN   Regular School No Ungraded UG UG 2020   elementary_spec_ed                                                   *                                              
2035030 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000289 2400020 HARRISON CO CHILD DEVELOPMENT CEN   Regular School No Ungraded UG UG 2020   secondary_spec_ed                                                   *                                              
2035031 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000289 2400020 HARRISON CO CHILD DEVELOPMENT CEN   Regular School No Ungraded UG UG 2020   pk_12_total 32 30 10     *         *   54.0 24.0                       78 32 30 10                   54 24                 78
2036178 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348001161 3022062 EXCEPTIONAL SCHOOL   Regular School No Ungraded UG UG 2020   elementary_spec_ed                                                   22                                             22
2036179 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348001161 3022062 EXCEPTIONAL SCHOOL   Regular School No Ungraded UG UG 2020   secondary_spec_ed                                                   15                                             15
2036180 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348001161 3022062 EXCEPTIONAL SCHOOL   Regular School No Ungraded UG UG 2020   pk_12_total 17 * *                   26.0 11.0                       37 17                       26 11                 37
2037275 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001318 4500002 MADISON CO PRE SCHOOL   Regular School No Ungraded UG UG 2020   pre_kindergarten_spec_ed                                                   38                                             38
2037276 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001318 4500002 MADISON CO PRE SCHOOL   Regular School No Ungraded UG UG 2020   pk_12_total 16 18 *     *             26.0 12.0                       38 16 18                     26 12                 38
2036936 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432001255 4120018 EARLY CHILDHOOD EDUCATION CENTER   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   257                                             257
2036937 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432001255 4120018 EARLY CHILDHOOD EDUCATION CENTER   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_spec_ed                                                   23                                             23
2036938 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432001255 4120018 EARLY CHILDHOOD EDUCATION CENTER   Regular School No Prekindergarten PK PK 2020   pk_12_total 102 131 *     *         22   154.0 126.0                       280 102 131                 22   154 126                 280
2037938 MS     school 2803630 5520   PICAYUNE SCHOOL DIST 280363001383 5520009 EARLY HEAD START NICHOLSON   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   40                                             40
2037939 MS     school 2803630 5520   PICAYUNE SCHOOL DIST 280363001383 5520009 EARLY HEAD START NICHOLSON   Regular School No Prekindergarten PK PK 2020   pk_12_total * 29                 *   22.0 18.0                       40   29                     22 18                 40
2037940 MS     school 2803630 5520   PICAYUNE SCHOOL DIST 280363001576 5520010 EARLY HEAD START ROSA STREET   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   187                                             187
2037941 MS     school 2803630 5520   PICAYUNE SCHOOL DIST 280363001576 5520010 EARLY HEAD START ROSA STREET   Regular School No Prekindergarten PK PK 2020   pk_12_total 53 118     * *         13   106.0 81.0                       187 53 118                 13   106 81                 187
2039498 MS     school 2801620 7620   GREENVILLE PUBLIC SCHOOLS 280162000247 7620044 MC BRIDE PRE-K ACADEMY   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   *                                              
2039499 MS     school 2801620 7620   GREENVILLE PUBLIC SCHOOLS 280162000247 7620044 MC BRIDE PRE-K ACADEMY   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_spec_ed                                                   *                                              
2039500 MS     school 2801620 7620   GREENVILLE PUBLIC SCHOOLS 280162000247 7620044 MC BRIDE PRE-K ACADEMY   Regular School No Prekindergarten PK PK 2020   pk_12_total * 156       *         *   71.0 89.0                       160   156                     71 89                 160
2034107 MS     school 2800191 1321   WEST POINT CONSOLIDATED SCHOOL DIST 280019101443 1321008 EAST SIDE ELEMENTARY SCHOOL   Regular School No Elementary PK KG 2020   pre_kindergarten                                                   60                                             60
2034108 MS     school 2800191 1321   WEST POINT CONSOLIDATED SCHOOL DIST 280019101443 1321008 EAST SIDE ELEMENTARY SCHOOL   Regular School No Elementary PK KG 2020   pre_kindergarten_spec_ed                                                   *                                              
2034109 MS     school 2800191 1321   WEST POINT CONSOLIDATED SCHOOL DIST 280019101443 1321008 EAST SIDE ELEMENTARY SCHOOL   Regular School No Elementary PK KG 2020   kindergarten                                                   181                                             181
2034110 MS     school 2800191 1321   WEST POINT CONSOLIDATED SCHOOL DIST 280019101443 1321008 EAST SIDE ELEMENTARY SCHOOL   Regular School No Elementary PK KG 2020   kindergarten_spec_ed                                                   *                                              
2034111 MS     school 2800191 1321   WEST POINT CONSOLIDATED SCHOOL DIST 280019101443 1321008 EAST SIDE ELEMENTARY SCHOOL   Regular School No Elementary PK KG 2020   pk_12_total 58 191 *     *     *   *   142.0 115.0                       257 58 191                     142 115                 257
2038103 MS     school 2802880 5720   MCCOMB SCHOOL DISTRICT 280288001061 5720002 KENNEDY ELEMENTARY SCHOOL   Regular School No Elementary PK KG 2020   pre_kindergarten                                                   15                                             15
2038104 MS     school 2802880 5720   MCCOMB SCHOOL DISTRICT 280288001061 5720002 KENNEDY ELEMENTARY SCHOOL   Regular School No Elementary PK KG 2020   pre_kindergarten_spec_ed                                                   *                                              
2038105 MS     school 2802880 5720   MCCOMB SCHOOL DISTRICT 280288001061 5720002 KENNEDY ELEMENTARY SCHOOL   Regular School No Elementary PK KG 2020   kindergarten                                                   172                                             172
2038106 MS     school 2802880 5720   MCCOMB SCHOOL DISTRICT 280288001061 5720002 KENNEDY ELEMENTARY SCHOOL   Regular School No Elementary PK KG 2020   kindergarten_spec_ed                                                   18                                             18
2038107 MS     school 2802880 5720   MCCOMB SCHOOL DISTRICT 280288001061 5720002 KENNEDY ELEMENTARY SCHOOL   Regular School No Elementary PK KG 2020   elementary_spec_ed                                                   *                                              
2038108 MS     school 2802880 5720   MCCOMB SCHOOL DISTRICT 280288001061 5720002 KENNEDY ELEMENTARY SCHOOL   Regular School No Elementary PK KG 2020   pk_12_total 14 188 *               *   116.0 95.0                       211 14 188                     116 95                 211
2039515 MS     school 2801620 7620   GREENVILLE PUBLIC SCHOOLS 280162000251 7620060 WEBB PREPARATORY SCHOOL   Regular School No Elementary KG KG 2020   kindergarten                                                   *                                              
2039516 MS     school 2801620 7620   GREENVILLE PUBLIC SCHOOLS 280162000251 7620060 WEBB PREPARATORY SCHOOL   Regular School No Elementary KG KG 2020   kindergarten_spec_ed                                                   *                                              
2039517 MS     school 2801620 7620   GREENVILLE PUBLIC SCHOOLS 280162000251 7620060 WEBB PREPARATORY SCHOOL   Regular School No Elementary KG KG 2020   pk_12_total * 321       *         *   162.0 163.0                       325   321                     162 163                 325
2033511 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303001414 130043 NATCHEZ EARLY COLLEGE@CO-LIN   Regular School No High 09 12 2020   grade_9                                                   52                                             52
2033512 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303001414 130043 NATCHEZ EARLY COLLEGE@CO-LIN   Regular School No High 09 12 2020   grade_10                                                   51                                             51
2033513 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303001414 130043 NATCHEZ EARLY COLLEGE@CO-LIN   Regular School No High 09 12 2020   grade_11                                                   42                                             42
2033514 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303001414 130043 NATCHEZ EARLY COLLEGE@CO-LIN   Regular School No High 09 12 2020   grade_12                                                   33                                             33
2033515 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303001414 130043 NATCHEZ EARLY COLLEGE@CO-LIN   Regular School No High 09 12 2020   pk_12_total * 163 *                   53.0 125.0                       178   163                     53 125                 178
2033516 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000608 130044 NATCHEZ HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   171                                             171
2033517 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000608 130044 NATCHEZ HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   171                                             171
2033518 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000608 130044 NATCHEZ HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   155                                             155
2033519 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000608 130044 NATCHEZ HIGH SCHOOL   Regular School No High 09 12 2020   secondary_spec_ed                                                   26                                             26
2033520 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000608 130044 NATCHEZ HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 26 490 *     *         *   288.0 235.0                       523 26 490                     288 235                 523
2033543 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_7                                                   36                                             36
2033544 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   29                                             29
2033545 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   41                                             41
2033546 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_10                                                   27                                             27
2033547 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   33                                             33
2033548 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_12                                                   *                                              
2033549 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   secondary_spec_ed                                                   *                                              
2033550 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   pk_12_total 144 36 *     *         *   105.0 85.0                       190 144 36                     105 85                 190
2033561 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000018 200008 ALCORN CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_9                                                   105                                             105
2033562 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000018 200008 ALCORN CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   95                                             95
2033563 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000018 200008 ALCORN CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   99                                             99
2033564 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000018 200008 ALCORN CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   *                                              
2033565 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000018 200008 ALCORN CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   secondary_spec_ed                                                   *                                              
2033566 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000018 200008 ALCORN CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 354 * *   * *         11   177.0 204.0                       381 354                   11   177 204                 381
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 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000020 200024 KOSSUTH HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   *                                              
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 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000020 200024 KOSSUTH HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   107                                             107
2033595 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000020 200024 KOSSUTH HIGH SCHOOL   Regular School No High 09 12 2020   secondary_spec_ed                                                   *                                              
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
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 MS     school 2801260 220   CORINTH SCHOOL DIST 280126000171 220004 CORINTH HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   136                                             136
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 MS     school 2801260 220   CORINTH SCHOOL DIST 280126000171 220004 CORINTH HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   165                                             165
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 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
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 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 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 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 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 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 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 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042000027 300008 AMITE COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   ged                                                   *                                              
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
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 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 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 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 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 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000036 400008 ETHEL ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_12                                                   *                                              
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 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
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 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 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 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000039 400020 MCADAMS ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_10                                                   *                                              
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 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 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000039 400020 MCADAMS ATTENDANCE CENTER   Regular School No High 07 12 2020   secondary_spec_ed                                                   *                                              
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
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                                                   *                                              

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