enrollments

Data source: Big Local News · About: Big Local

2,306 rows where grade = "kindergarten", state = "MO" and year = 2018 sorted by school_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 2,306 ✖

grade ✖

  • kindergarten · 2,306 ✖
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
3124599 3124599 MO     school 2900001 63067   MARIES CO. R-II 290000100048 4020 BELLE ELEM.   Regular School No Elementary PK 04 2018   kindergarten                                                   44                                             44
3124587 3124587 MO     school 2900001 63067   MARIES CO. R-II 290000100049 1050 BELLE HIGH   Regular School No High 09 12 2018   kindergarten                                                   0                                             0
3124593 3124593 MO     school 2900001 63067   MARIES CO. R-II 290000102547 3000 MARIES CO. MIDDLE   Regular School No Middle 05 08 2018   kindergarten                                                   0                                             0
3121406 3121406 MO     school 2900002 41002   SOUTH HARRISON CO. R-II 290000200922 4030 SOUTH HARRISON EARLY CHILD CTR   Regular School No Prekindergarten PK PK 2018   kindergarten                                                   0                                             0
3121400 3121400 MO     school 2900002 41002   SOUTH HARRISON CO. R-II 290000201641 4020 SOUTH HARRISON ELEM.   Regular School No Elementary KG 04 2018   kindergarten                                                   71                                             71
3121390 3121390 MO     school 2900002 41002   SOUTH HARRISON CO. R-II 290000201642 1050 SOUTH HARRISON HIGH   Regular School No High 09 12 2018   kindergarten                                                   0                                             0
3121394 3121394 MO     school 2900002 41002   SOUTH HARRISON CO. R-II 290000203297 3000 SOUTH HARRISON MIDDLE   Regular School No Middle 05 08 2018   kindergarten                                                   0                                             0
3125034 3125034 MO     school 2900003 72068   PORTAGEVILLE 290000302458 1050 PORTAGEVILLE HIGH   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3125040 3125040 MO     school 2900003 72068   PORTAGEVILLE 290000302459 4020 PORTAGEVILLE ELEM.   Regular School No Elementary PK 05 2018   kindergarten                                                   49                                             49
3125070 3125070 MO     school 2900004 72074   NEW MADRID CO. R-I 290000401482 4100 LILBOURN ELEM.   Regular School No Elementary PK 05 2018   kindergarten                                                   46                                             46
3125082 3125082 MO     school 2900004 72074   NEW MADRID CO. R-I 290000401484 4140 NEW MADRID ELEM.   Regular School No Elementary PK 05 2018   kindergarten                                                   31                                             31
3125076 3125076 MO     school 2900004 72074   NEW MADRID CO. R-I 290000401486 4120 MATTHEWS ELEM.   Regular School No Elementary PK 05 2018   kindergarten                                                   24                                             24
3125058 3125058 MO     school 2900004 72074   NEW MADRID CO. R-I 290000401488 1060 CENTRAL HIGH   Regular School No High 09 12 2018   kindergarten                                                   0                                             0
3125064 3125064 MO     school 2900004 72074   NEW MADRID CO. R-I 290000401991 3000 CENTRAL MIDDLE   Regular School No Middle 06 08 2018   kindergarten                                                   0                                             0
3130729 3130729 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901145 1010 MONTGOMERY CITY TREATMENT CTR.   Special Education School No High 06 12 2018   kindergarten                                                   0                                             0
3130735 3130735 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901178 1050 W. E. SEARS YOUTH CTR.   Regular School No High 05 12 2018   kindergarten                                                   0                                             0
3130741 3130741 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901185 1051 SIERRA-OSAGE TREATMENT CTR.   Regular School No High 05 12 2018   kindergarten                                                   0                                             0
3130747 3130747 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901192 1052 GIRARDOT CENTER FOR YOUTH   Regular School No High 05 12 2018   kindergarten                                                   0                                             0
3130753 3130753 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901193 1053 ECHO DAY TREATMENT CTR.   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130765 3130765 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901195 1055 HOGAN ST REGIONAL YOUTH CTR.   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130783 3130783 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901199 1058 BISSELL HALL   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130789 3130789 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901215 1059 TWIN RIVERS   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130795 3130795 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901226 1060 FORT BELLEFONTAINE CAMPUS   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130801 3130801 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901259 1061 SPANISH LAKE CAMPUS   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130805 3130805 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901261 1062 LEWIS AND CLARK HALL   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130811 3130811 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901265 1063 NEW DAY - DAY TREATMENT   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130817 3130817 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901270 1065 NORTHWEST REG. YOUTH CTR.   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130841 3130841 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901271 1070 BABLER LODGE   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130863 3130863 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901273 1075 CAMP AVERY PARK CAMP   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130887 3130887 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901276 1080 DELMINA WOODS YOUTH FACILITY   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130892 3130892 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901283 1082 WAVERLY REGIONAL YOUTH CTR.   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130898 3130898 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901285 1083 LANGSFORD HOUSE   Regular School No High 05 12 2018   kindergarten                                                   0                                             0
3130904 3130904 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901287 1084 ALTERNATIVE RESOURCE CTR.   Alternative School No High 06 12 2018   kindergarten                                                   0                                             0
3130910 3130910 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901289 1085 WATKINS MILL PARK CAMP   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130929 3130929 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901352 1095 COMMUNITY LEARNING CTR.   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130935 3130935 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901358 1096 WILSON CREEK GROUP HOME   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130941 3130941 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901364 1097 EXCEL SCHOOL   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130853 3130853 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901936 1073 DATEMA HOUSE   Regular School No High 05 12 2018   kindergarten                                                   0                                             0
3130759 3130759 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902172 1054 FULTON TREATMENT CTR.   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130771 3130771 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902179 1056 CORNERSTONE   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130777 3130777 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902196 1057 QUEST DAY TREATMENT   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130823 3130823 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902211 1067 GATEWAY SCHOOL   Regular School No High 05 12 2018   kindergarten                                                   0                                             0
3130829 3130829 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902710 1068 NEW MADRID BEND YOUTH CTR.   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130835 3130835 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902711 1069 SIKESTON HOPE CTR.   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130847 3130847 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902712 1071 RIVERBEND TREATMENT CTR.   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130869 3130869 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902713 1076 HILLSBORO TREATMENT CTR.   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130875 3130875 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902714 1078 RICH HILL YOUTH DEV. CTR.   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130881 3130881 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902715 1079 GENTRY RESIDENTIAL TREAT. FAC.   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130916 3130916 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902716 1086 MT. VERNON TREATMENT CTR.   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130923 3130923 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902793 1091 ROSA PARKS CENTER   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130859 3130859 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000903077 1074 DISCOVERY HALL   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3130947 3130947 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000903153 1099 MET DAY TREATMENT CENTER   Regular School No High 06 12 2018   kindergarten                                                   0                                             0
3122944 3122944 MO     school 2900011 48911   B. BANNEKER ACADEMY 290001102750 6925 B. BANNEKER ACADEMY   Regular School Yes Elementary PK 08 2018   kindergarten                                                   34                                             34
3122948 3122948 MO     school 2900013 48912   KC INTERNATIONAL ACADEMY 290001302751 6930 KC INTERNATIONAL-WALLACE   Regular School Yes Elementary KG 08 2018   kindergarten                                                   64                                             64
3122898 3122898 MO     school 2900014 48904   HOGAN PREPARATORY ACADEMY 290001402743 1935 HOGAN PREPARATORY ACADEMY   Regular School Yes High 09 12 2018   kindergarten                                                   0                                             0
3122904 3122904 MO     school 2900014 48904   HOGAN PREPARATORY ACADEMY 290001403196 3945 HOGAN PREPARATORY ACAD MIDDLE   Regular School Yes Middle 06 08 2018   kindergarten                                                   0                                             0
3122910 3122910 MO     school 2900014 48904   HOGAN PREPARATORY ACADEMY 290001403222 6910 HOGAN PREPARATORY ACADEMY ELEM   Regular School Yes Elementary KG 05 2018   kindergarten                                                   65                                             65
3122956 3122956 MO     school 2900015 48913   GORDON PARKS ELEM. 290001502752 6935 GORDON PARKS ELEM.   Regular School Yes Elementary KG 04 2018   kindergarten                                                   40                                             40
3122916 3122916 MO     school 2900016 48905   GENESIS SCHOOL INC. 290001602746 1945 GENESIS SCHOOL INC.   Regular School Yes Elementary KG 08 2018   kindergarten                                                   26                                             26
3122964 3122964 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001702753 6940 ACADEMIE LAFAYETTE-OAK   Regular School Yes Middle 04 08 2018   kindergarten                                                   0                                             0
3122970 3122970 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001703259 6941 ACADEMIE LAFAYETTE-CHERRY   Regular School Yes Elementary KG 03 2018   kindergarten                                                   132                                             132
3122976 3122976 MO     school 2900019 48915   SCUOLA VITA NUOVA 290001902754 6945 SCUOLA VITA NUOVA CHARTER   Regular School Yes Elementary KG 08 2018   kindergarten                                                   43                                             43
3118485 3118485 MO     school 2900020 14400   MO SCHOOL FOR THE DEAF 290002003021 1050 WHEELER HIGH   Special Education School No High 09 12 2018   kindergarten                                                   0                                             0
3118491 3118491 MO     school 2900020 14400   MO SCHOOL FOR THE DEAF 290002003022 3000 WHEELER MIDDLE   Special Education School No Middle 06 08 2018   kindergarten                                                   0                                             0
3118497 3118497 MO     school 2900020 14400   MO SCHOOL FOR THE DEAF 290002003023 4020 STARK ELEM.   Special Education School No Elementary KG 05 2018   kindergarten                                                   0                                             0
3130307 3130307 MO     school 2900021 115414   MO SCHOOL FOR THE BLIND 290002103038 1050 MO School for the Blind - HS   Special Education School No High 09 12 2018   kindergarten                                                   0                                             0
3130313 3130313 MO     school 2900021 115414   MO SCHOOL FOR THE BLIND 290002103039 4020 MO School for the Blind - ELEM   Special Education School No Elementary KG 08 2018   kindergarten                                                   0                                             0
3130525 3130525 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203041 9001 GREENE VALLEY SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130531 3130531 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203042 9002 MAPAVILLE SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130537 3130537 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203043 9003 H KENNETH KIRCHNER SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130543 3130543 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203044 9004 SHADY GROVE SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130549 3130549 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203045 9006 LAKEVIEW WOODS SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130555 3130555 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203046 9007 BOONSLICK SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130561 3130561 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203047 9008 DELMAR A COBBLE SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130567 3130567 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203048 9009 MAPLE VALLEY SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130573 3130573 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203049 9010 BOOTHEEL SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130579 3130579 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203050 9011 PARKVIEW SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130585 3130585 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203052 9014 LILLIAN SCHAPER SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130591 3130591 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203053 9015 SPECIAL ACRES SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130597 3130597 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203054 9018 OZARK HORIZON SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130603 3130603 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203055 9020 VERELLE PENISTON SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130609 3130609 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203056 9021 E W THOMPSON SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130615 3130615 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203057 9023 B W ROBINSON SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130621 3130621 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203058 9024 CITADEL SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130627 3130627 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203059 9027 CROWLEY RIDGE SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130633 3130633 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203060 9030 SKYVIEW SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130639 3130639 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203061 9032 HELEN M DAVIS SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130645 3130645 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203062 9034 OAKVIEW SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130651 3130651 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203063 9036 MISSISSIPPI VALLEY SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130657 3130657 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203064 9040 AUTUMN HILL SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130663 3130663 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203066 9045 BRIARWOOD SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130669 3130669 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203067 9048 COLLEGE VIEW SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130675 3130675 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203068 9049 NEW DAWN SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130681 3130681 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203069 9055 DOGWOOD HILLS SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130687 3130687 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203070 9056 PRAIRIE VIEW SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130693 3130693 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203071 9060 CURRENT RIVER SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130699 3130699 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203072 9061 OZARK HILLS SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130705 3130705 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203073 9066 CEDAR RIDGE SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130711 3130711 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203074 9070 GATEWAY/HUBERT WHEELER SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0
3130717 3130717 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203075 9071 ROLLING MEADOW SCHOOL   Special Education School No Other KG 12 2018   kindergarten                                                   0                                             0

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