enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2033711 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 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 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 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 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 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                                                   *                                              
2033718 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 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 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 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 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 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 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 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 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 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 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 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 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 2033731 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_12                                                   *                                              
2033733 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 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 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 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
2033738 2033738 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000075 614004 BELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   *                                              
2033739 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 2033740 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000075 614004 BELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   kindergarten                                                   45                                             45
2033741 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 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 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 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 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 2033746 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000075 614004 BELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_6                                                   48                                             48
2033748 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 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 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
2033752 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 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 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 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 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
2033758 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 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 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 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 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 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 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 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
2033767 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 2033768 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000083 614024 NAILOR ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   kindergarten                                                   105                                             105
2033769 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 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 2033771 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000083 614024 NAILOR ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   grade_2                                                   100                                             100
2033773 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 2033774 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000084 614028 PARKS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   kindergarten                                                   37                                             37
2033775 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 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 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 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 2033779 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000084 614028 PARKS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_4                                                   40                                             40
2033780 2033780 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000084 614028 PARKS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_5                                                   32                                             32
2033781 2033781 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000084 614028 PARKS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_6                                                   42                                             42
2033783 2033783 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000085 614032 PEARMAN ELEMENTARY SCHOOL   Regular School No Elementary 01 06 2020   grade_1                                                   26                                             26
2033784 2033784 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000085 614032 PEARMAN ELEMENTARY SCHOOL   Regular School No Elementary 01 06 2020   grade_2                                                   42                                             42
2033785 2033785 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000085 614032 PEARMAN ELEMENTARY SCHOOL   Regular School No Elementary 01 06 2020   grade_3                                                   54                                             54
2033786 2033786 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000085 614032 PEARMAN ELEMENTARY SCHOOL   Regular School No Elementary 01 06 2020   grade_4                                                   41                                             41
2033787 2033787 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000085 614032 PEARMAN ELEMENTARY SCHOOL   Regular School No Elementary 01 06 2020   grade_5                                                   48                                             48
2033788 2033788 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000085 614032 PEARMAN ELEMENTARY SCHOOL   Regular School No Elementary 01 06 2020   grade_6                                                   59                                             59
2033790 2033790 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601416 617008 I T MONTGOMERY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   kindergarten                                                   26                                             26
2033791 2033791 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601416 617008 I T MONTGOMERY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_1                                                   39                                             39
2033792 2033792 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601416 617008 I T MONTGOMERY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2                                                   36                                             36
2033793 2033793 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601416 617008 I T MONTGOMERY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_3                                                   35                                             35
2033794 2033794 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601416 617008 I T MONTGOMERY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_4                                                   44                                             44
2033795 2033795 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601416 617008 I T MONTGOMERY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_5                                                   34                                             34
2033796 2033796 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601416 617008 I T MONTGOMERY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_6                                                   50                                             50
2033798 2033798 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601411 617010 NORTHSIDE HIGH SCHOOL   Regular School No High 07 12 2020   grade_7                                                   67                                             67
2033799 2033799 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601411 617010 NORTHSIDE HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   *                                              
2033800 2033800 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601411 617010 NORTHSIDE HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   62                                             62
2033801 2033801 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601411 617010 NORTHSIDE HIGH SCHOOL   Regular School No High 07 12 2020   grade_10                                                   56                                             56
2033802 2033802 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601411 617010 NORTHSIDE HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   64                                             64
2033803 2033803 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601411 617010 NORTHSIDE HIGH SCHOOL   Regular School No High 07 12 2020   grade_12                                                   49                                             49
2033804 2033804 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601411 617010 NORTHSIDE HIGH SCHOOL   Regular School No High 07 12 2020   secondary_spec_ed                                                   *                                              
2033806 2033806 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601404 617014 BROOKS ELEM SCHOOL   Regular School No Elementary KG 06 2020   kindergarten                                                   40                                             40
2033807 2033807 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601404 617014 BROOKS ELEM SCHOOL   Regular School No Elementary KG 06 2020   elementary_spec_ed                                                   *                                              
2033808 2033808 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601404 617014 BROOKS ELEM SCHOOL   Regular School No Elementary KG 06 2020   grade_1                                                   42                                             42
2033809 2033809 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601404 617014 BROOKS ELEM SCHOOL   Regular School No Elementary KG 06 2020   grade_2                                                   52                                             52
2033810 2033810 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601404 617014 BROOKS ELEM SCHOOL   Regular School No Elementary KG 06 2020   grade_3                                                   48                                             48
2033811 2033811 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601404 617014 BROOKS ELEM SCHOOL   Regular School No Elementary KG 06 2020   grade_4                                                   *                                              
2033812 2033812 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601404 617014 BROOKS ELEM SCHOOL   Regular School No Elementary KG 06 2020   grade_5                                                   39                                             39
2033813 2033813 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601404 617014 BROOKS ELEM SCHOOL   Regular School No Elementary KG 06 2020   grade_6                                                   46                                             46
2033815 2033815 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501401 618004 WEST BOLIVAR DIST HIGH SCHOOL   Regular School No High 09 12 2020   grade_9                                                   50                                             50
2033816 2033816 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501401 618004 WEST BOLIVAR DIST HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   36                                             36
2033817 2033817 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501401 618004 WEST BOLIVAR DIST HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   *                                              
2033818 2033818 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501401 618004 WEST BOLIVAR DIST HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   42                                             42
2033819 2033819 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501401 618004 WEST BOLIVAR DIST HIGH SCHOOL   Regular School No High 09 12 2020   secondary_spec_ed                                                   *                                              
2033821 2033821 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501432 618008 WEST BOLIVAR DISTRICT MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5                                                   43                                             43
2033822 2033822 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501432 618008 WEST BOLIVAR DISTRICT MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_6                                                   55                                             55
2033823 2033823 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501432 618008 WEST BOLIVAR DISTRICT MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7                                                   38                                             38
2033824 2033824 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501432 618008 WEST BOLIVAR DISTRICT MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_8                                                   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]);