enrollments

Data source: Big Local News · About: Big Local

36,896 rows where state = "MO" and year = 2018 sorted by ccd_charter_school descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2018 · 36,896 ✖
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
3109005 3109005 MO     school 2916400 48078   KANSAS CITY 33 291640003294 6960 KANSAS CITY NEIGHBORHOOD ACAD   Regular School Yes Elementary PK 03 2018   pre_kindergarten                                                   40                                             40
3109052 3109052 MO     school 2900027 48901   UNIVERSITY ACADEMY 290002702808 1915 UNIVERSITY ACADEMY-UPPER   Regular School Yes High 09 12 2018   pre_kindergarten                                                   0                                             0
3109058 3109058 MO     school 2900027 48901   UNIVERSITY ACADEMY 290002702914 3925 UNIVERSITY ACADEMY-MIDDLE   Regular School Yes Middle 06 08 2018   pre_kindergarten                                                   0                                             0
3109064 3109064 MO     school 2900027 48901   UNIVERSITY ACADEMY 290002702915 6965 UNIVERSITY ACADEMY-LOWER   Regular School Yes Elementary KG 05 2018   pre_kindergarten                                                   0                                             0
3109070 3109070 MO     school 2900029 48902   GUADALUPE CENTERS SCHOOLS 290002902741 1925 GUADALUPE CENTERS HIGH SCHOOL   Regular School Yes High 09 12 2018   pre_kindergarten                                                   0                                             0
3109076 3109076 MO     school 2900029 48902   GUADALUPE CENTERS SCHOOLS 290002903166 3925 GUADALUPE CENTERS MIDDLE   Regular School Yes Middle 06 08 2018   pre_kindergarten                                                   0                                             0
3109082 3109082 MO     school 2900029 48902   GUADALUPE CENTERS SCHOOLS 290002903216 6905 GUADALUPE CENTERS ELEMENTARY   Regular School Yes Elementary PK 05 2018   pre_kindergarten                                                   60                                             60
3109088 3109088 MO     school 2900014 48904   HOGAN PREPARATORY ACADEMY 290001402743 1935 HOGAN PREPARATORY ACADEMY   Regular School Yes High 09 12 2018   pre_kindergarten                                                   0                                             0
3109094 3109094 MO     school 2900014 48904   HOGAN PREPARATORY ACADEMY 290001403196 3945 HOGAN PREPARATORY ACAD MIDDLE   Regular School Yes Middle 06 08 2018   pre_kindergarten                                                   0                                             0
3109100 3109100 MO     school 2900014 48904   HOGAN PREPARATORY ACADEMY 290001403222 6910 HOGAN PREPARATORY ACADEMY ELEM   Regular School Yes Elementary KG 05 2018   pre_kindergarten                                                   0                                             0
3109106 3109106 MO     school 2900016 48905   GENESIS SCHOOL INC. 290001602746 1945 GENESIS SCHOOL INC.   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   0                                             0
3109112 3109112 MO     school 2900025 48909   ALLEN VILLAGE 290002503233 1980 ALLEN VILLAGE HIGH SCHOOL   Regular School Yes High 09 12 2018   pre_kindergarten                                                   0                                             0
3109122 3109122 MO     school 2900025 48909   ALLEN VILLAGE 290002502748 6915 ALLEN VILLAGE SCHOOL   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   0                                             0
3109128 3109128 MO     school 2900028 48910   LEE A. TOLBERT COM. ACADEMY 290002802749 6920 LEE A. TOLBERT COM. ACADEMY   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   0                                             0
3109134 3109134 MO     school 2900011 48911   B. BANNEKER ACADEMY 290001102750 6925 B. BANNEKER ACADEMY   Regular School Yes Elementary PK 08 2018   pre_kindergarten                                                   27                                             27
3109138 3109138 MO     school 2900013 48912   KC INTERNATIONAL ACADEMY 290001302751 6930 KC INTERNATIONAL-WALLACE   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   0                                             0
3109146 3109146 MO     school 2900015 48913   GORDON PARKS ELEM. 290001502752 6935 GORDON PARKS ELEM.   Regular School Yes Elementary KG 04 2018   pre_kindergarten                                                   0                                             0
3109154 3109154 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001702753 6940 ACADEMIE LAFAYETTE-OAK   Regular School Yes Middle 04 08 2018   pre_kindergarten                                                   0                                             0
3109160 3109160 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001703259 6941 ACADEMIE LAFAYETTE-CHERRY   Regular School Yes Elementary KG 03 2018   pre_kindergarten                                                   0                                             0
3109166 3109166 MO     school 2900019 48915   SCUOLA VITA NUOVA 290001902754 6945 SCUOLA VITA NUOVA CHARTER   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   0                                             0
3109172 3109172 MO     school 2900024 48916   BROOKSIDE CHARTER SCH. 290002403184 3950 BROOKSIDE CHARTER MIDDLE SCHL   Regular School Yes Middle 06 08 2018   pre_kindergarten                                                   0                                             0
3109178 3109178 MO     school 2900024 48916   BROOKSIDE CHARTER SCH. 290002402838 6950 BROOKSIDE CHARTER ELEMENTARY   Regular School Yes Elementary PK 05 2018   pre_kindergarten                                                   20                                             20
3109184 3109184 MO     school 2900031 48918   KIPP: ENDEAVOR ACADEMY 290003103013 3920 KIPP ENDEAVOR ACADEMY   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   0                                             0
3109190 3109190 MO     school 2900587 48921   PATHWAY ACADEMY 290058703140 6970 PATHWAY ACADEMY ELEMENTARY   Regular School Yes Elementary PK 04 2018   pre_kindergarten                                                   10                                             10
3109195 3109195 MO     school 2900590 48922   FRONTIER SCHOOLS 290059003181 1920 FRONTIER SCHL OF EXCELLENCE-U   Regular School Yes High 09 12 2018   pre_kindergarten                                                   0                                             0
3109201 3109201 MO     school 2900590 48922   FRONTIER SCHOOLS 290059003232 1985 FRONTIER STEM HIGH SCHOOL   Regular School Yes High 09 12 2018   pre_kindergarten                                                   0                                             0
3109207 3109207 MO     school 2900590 48922   FRONTIER SCHOOLS 290059003182 3935 FRONTIER SCHL OF INNOVATION-M   Regular School Yes Middle 06 08 2018   pre_kindergarten                                                   0                                             0
3109213 3109213 MO     school 2900590 48922   FRONTIER SCHOOLS 290059003180 3940 FRONTIER SCHL OF EXCELLENCE-M   Regular School Yes Middle 06 08 2018   pre_kindergarten                                                   0                                             0
3109219 3109219 MO     school 2900590 48922   FRONTIER SCHOOLS 290059003127 6975 FRONTIER SCHOOL OF INNOVATION   Regular School Yes Elementary KG 05 2018   pre_kindergarten                                                   0                                             0
3109225 3109225 MO     school 2900593 48923   DELASALLE CHARTER SCHOOL 290059303176 1970 DeLaSalle Charter High School   Regular School Yes High 09 12 2018   pre_kindergarten                                                   0                                             0
3109230 3109230 MO     school 2900597 48924   EWING MARION KAUFFMAN SCHOOL 290059703277 1910 EWING MARION KAUFFMAN HIGH   Regular School Yes Secondary 09 11 2018   pre_kindergarten                                                   0                                             0
3109236 3109236 MO     school 2900597 48924   EWING MARION KAUFFMAN SCHOOL 290059703195 3930 EWING MARION KAUFFMAN MIDDLE   Regular School Yes Middle 05 08 2018   pre_kindergarten                                                   0                                             0
3109242 3109242 MO     school 2900601 48925   HOPE LEADERSHIP ACADEMY 290060103194 6985 HOPE LEADERSHIP ACADEMY   Regular School Yes Elementary KG 04 2018   pre_kindergarten                                                   0                                             0
3109245 3109245 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 09 09 2018   pre_kindergarten                                                   0                                             0
3109249 3109249 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303295 6905 CROSSROADS - QUALITY HILL   Regular School Yes Elementary KG 04 2018   pre_kindergarten                                                   0                                             0
3109255 3109255 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303201 6990 CROSSROADS - CENTRAL STREET   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   0                                             0
3109261 3109261 MO     school 2900604 48927   ACADEMY FOR INTEGRATED ARTS 290060403209 6995 ACADEMY FOR INTEGRATED ARTS   Regular School Yes Elementary PK 06 2018   pre_kindergarten                                                   17                                             17
3109266 3109266 MO     school 2900612 48928   CITIZENS OF THE WORLD CHARTER 290061203286 6905 CITIZENS OF THE WORLD CHARTER   Regular School Yes Elementary KG 02 2018   pre_kindergarten                                                   0                                             0
3116510 3116510 MO     school 2900574 115902   LIFT FOR LIFE ACADEMY 290057403183 1935 LIFT FOR LIFE ACADEMY HIGH SCH   Regular School Yes High 09 12 2018   pre_kindergarten                                                   0                                             0
3116516 3116516 MO     school 2900574 115902   LIFT FOR LIFE ACADEMY 290057402828 3910 LIFT FOR LIFE ACADEMY   Regular School Yes Middle 06 08 2018   pre_kindergarten                                                   0                                             0
3116523 3116523 MO     school 2900576 115903   PREMIER CHARTER SCHOOL 290057602831 6915 PREMIER CHARTER SCHOOL   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   0                                             0
3116529 3116529 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903102 1920 CONFLUENCE PREPARATORY ACADEMY   Regular School Yes High 07 12 2018   pre_kindergarten                                                   0                                             0
3116539 3116539 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903037 6930 OLD NORTH   Regular School Yes Elementary PK 06 2018   pre_kindergarten                                                   18                                             18
3116545 3116545 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903014 6931 ASPIRE ACADEMY   Regular School Yes Elementary PK 06 2018   pre_kindergarten                                                   20                                             20
3116551 3116551 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903079 6932 SOUTH CITY   Regular School Yes Elementary PK 08 2018   pre_kindergarten                                                   19                                             19
3116557 3116557 MO     school 2900585 115911   CITY GARDEN MONTESSORI 290058503101 6955 CITY GARDEN MONTESSORI SCHOOL   Regular School Yes Elementary PK 08 2018   pre_kindergarten                                                   43                                             43
3116567 3116567 MO     school 2900586 115912   ST. LOUIS LANG IMMERSION SCH 290058603124 6961 ST LOUIS LANG IMMERSION MARINE   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   0                                             0
3116579 3116579 MO     school 2900589 115913   NORTH SIDE COMMUNITY SCHOOL 290058903142 6965 NORTH SIDE COMMUNITY SCHOOL   Regular School Yes Elementary PK 05 2018   pre_kindergarten                                                   45                                             45
3116584 3116584 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 09 2018   pre_kindergarten                                                   0                                             0
3116590 3116590 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103122 6970 KIPP INSPIRE ACADEMY   Regular School Yes Middle 05 08 2018   pre_kindergarten                                                   0                                             0
3116596 3116596 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103245 6971 KIPP VICTORY ACADEMY   Regular School Yes Elementary KG 04 2018   pre_kindergarten                                                   0                                             0
3116601 3116601 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103266 6972 KIPP WISDOM ACADEMY   Regular School Yes Elementary KG 03 2018   pre_kindergarten                                                   0                                             0
3116606 3116606 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103270 6973 KIPP TRIUMPH ACADEMY   Regular School Yes Middle 05 07 2018   pre_kindergarten                                                   0                                             0
3116613 3116613 MO     school 2900594 115915   CARONDELET LEADERSHIP ACADEMY 290059403172 6975 CARONDELET LEADERSHIP ACADEMY   Regular School Yes Elementary KG 08 2018   pre_kindergarten                                                   0                                             0
3116619 3116619 MO     school 2900592 115916   GATEWAY SCIENCE ACAD/ST LOUIS 290059203205 1940 GATEWAY SCIENCE ACADEMY HIGH   Regular School Yes High 09 12 2018   pre_kindergarten                                                   0                                             0
3116625 3116625 MO     school 2900592 115916   GATEWAY SCIENCE ACAD/ST LOUIS 290059203244 3935 GATEWAY SCIENCE ACADEMY MIDDLE   Regular School Yes Middle 06 08 2018   pre_kindergarten                                                   0                                             0
3116631 3116631 MO     school 2900592 115916   GATEWAY SCIENCE ACAD/ST LOUIS 290059203174 6980 GATEWAY SCIENCE ACAD/ST LOUIS   Regular School Yes Elementary KG 05 2018   pre_kindergarten                                                   0                                             0
3116637 3116637 MO     school 2900592 115916   GATEWAY SCIENCE ACAD/ST LOUIS 290059203241 6997 GATEWAY SCIENCE ACAD-SOUTH ELE   Regular School Yes Elementary KG 05 2018   pre_kindergarten                                                   0                                             0
3116643 3116643 MO     school 2900595 115918   GRAND CENTER ARTS ACADEMY 290059503256 1945 GRAND CENTER ARTS ACADEMY HIGH   Regular School Yes High 09 12 2018   pre_kindergarten                                                   0                                             0
3116647 3116647 MO     school 2900595 115918   GRAND CENTER ARTS ACADEMY 290059503159 3920 GRAND CENTER ARTS ACAD MIDDLE   Regular School Yes Middle 06 08 2018   pre_kindergarten                                                   0                                             0
3116651 3116651 MO     school 2900598 115919   PRECLARUS MASTERY ACADEMY 290059803179 3930 PRECLARUS MASTERY ACADEMY   Regular School Yes Middle 04 08 2018   pre_kindergarten                                                   0                                             0
3116654 3116654 MO     school 2900600 115920   ST. LOUIS COLLEGE PREP 290060003264 1910 St. Louis College Prep High   Regular School Yes Secondary 09 11 2018   pre_kindergarten                                                   0                                             0
3116659 3116659 MO     school 2900600 115920   ST. LOUIS COLLEGE PREP 290060003178 3925 St. Louis College Prep Middle   Regular School Yes Middle 06 08 2018   pre_kindergarten                                                   0                                             0
3116668 3116668 MO     school 2900605 115923   EAGLE COLLEGE PREP ENDEAVOR 290060503224 6995 EAGLE TOWER GROVE SOUTH   Regular School Yes Elementary KG 07 2018   pre_kindergarten                                                   0                                             0
3116673 3116673 MO     school 2900605 115923   EAGLE COLLEGE PREP ENDEAVOR 290060503272 6996 EAGLE FOX PARK   Regular School Yes Elementary KG 04 2018   pre_kindergarten                                                   0                                             0
3116677 3116677 MO     school 2900605 115923   EAGLE COLLEGE PREP ENDEAVOR 290060503299 6997 EAGLE TOWER GROVE EAST   Regular School Yes Elementary KG 04 2018   pre_kindergarten                                                   0                                             0
3116680 3116680 MO     school 2900605 115923   EAGLE COLLEGE PREP ENDEAVOR 290060503304 6998 EAGLE GRAVOIS PARK   Regular School Yes Elementary KG 04 2018   pre_kindergarten                                                   0                                             0
3116686 3116686 MO     school 2900606 115924   LAFAYETTE PREPARATORY ACADEMY 290060603223 6993 LAFAYETTE PREPARATORY ACADEMY   Regular School Yes Elementary KG 06 2018   pre_kindergarten                                                   0                                             0
3116689 3116689 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 09 2018   pre_kindergarten                                                   0                                             0
3116694 3116694 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803274 3910 HAWTHORN MIDDLE   Regular School Yes Middle 06 08 2018   pre_kindergarten                                                   0                                             0
3116699 3116699 MO     school 2900609 115926   THE BIOME 290060903262 6905 THE BIOME   Regular School Yes Elementary KG 03 2018   pre_kindergarten                                                   0                                             0
3116704 3116704 MO     school 2900611 115928   LA SALLE CHARTER SCHOOL 290061103281 3910 LA SALLE CHARTER SCHOOL   Regular School Yes Middle 05 08 2018   pre_kindergarten                                                   0                                             0
3116707 3116707 MO     school 2900614 115930   THE ARCH COMMUNITY SCHOOL 290061403302 6905 THE ARCH COMMUNITY SCHOOL   Regular School Yes Elementary KG 03 2018   pre_kindergarten                                                   0                                             0
3122815 3122815 MO     school 2916400 48078   KANSAS CITY 33 291640003294 6960 KANSAS CITY NEIGHBORHOOD ACAD   Regular School Yes Elementary PK 03 2018   kindergarten                                                   59                                             59
3122862 3122862 MO     school 2900027 48901   UNIVERSITY ACADEMY 290002702808 1915 UNIVERSITY ACADEMY-UPPER   Regular School Yes High 09 12 2018   kindergarten                                                   0                                             0
3122868 3122868 MO     school 2900027 48901   UNIVERSITY ACADEMY 290002702914 3925 UNIVERSITY ACADEMY-MIDDLE   Regular School Yes Middle 06 08 2018   kindergarten                                                   0                                             0
3122874 3122874 MO     school 2900027 48901   UNIVERSITY ACADEMY 290002702915 6965 UNIVERSITY ACADEMY-LOWER   Regular School Yes Elementary KG 05 2018   kindergarten                                                   134                                             134
3122880 3122880 MO     school 2900029 48902   GUADALUPE CENTERS SCHOOLS 290002902741 1925 GUADALUPE CENTERS HIGH SCHOOL   Regular School Yes High 09 12 2018   kindergarten                                                   0                                             0
3122886 3122886 MO     school 2900029 48902   GUADALUPE CENTERS SCHOOLS 290002903166 3925 GUADALUPE CENTERS MIDDLE   Regular School Yes Middle 06 08 2018   kindergarten                                                   0                                             0
3122892 3122892 MO     school 2900029 48902   GUADALUPE CENTERS SCHOOLS 290002903216 6905 GUADALUPE CENTERS ELEMENTARY   Regular School Yes Elementary PK 05 2018   kindergarten                                                   91                                             91
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
3122916 3122916 MO     school 2900016 48905   GENESIS SCHOOL INC. 290001602746 1945 GENESIS SCHOOL INC.   Regular School Yes Elementary KG 08 2018   kindergarten                                                   26                                             26
3122922 3122922 MO     school 2900025 48909   ALLEN VILLAGE 290002503233 1980 ALLEN VILLAGE HIGH SCHOOL   Regular School Yes High 09 12 2018   kindergarten                                                   0                                             0
3122932 3122932 MO     school 2900025 48909   ALLEN VILLAGE 290002502748 6915 ALLEN VILLAGE SCHOOL   Regular School Yes Elementary KG 08 2018   kindergarten                                                   28                                             28
3122938 3122938 MO     school 2900028 48910   LEE A. TOLBERT COM. ACADEMY 290002802749 6920 LEE A. TOLBERT COM. ACADEMY   Regular School Yes Elementary KG 08 2018   kindergarten                                                   58                                             58
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
3122956 3122956 MO     school 2900015 48913   GORDON PARKS ELEM. 290001502752 6935 GORDON PARKS ELEM.   Regular School Yes Elementary KG 04 2018   kindergarten                                                   40                                             40
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
3122982 3122982 MO     school 2900024 48916   BROOKSIDE CHARTER SCH. 290002403184 3950 BROOKSIDE CHARTER MIDDLE SCHL   Regular School Yes Middle 06 08 2018   kindergarten                                                   0                                             0
3122988 3122988 MO     school 2900024 48916   BROOKSIDE CHARTER SCH. 290002402838 6950 BROOKSIDE CHARTER ELEMENTARY   Regular School Yes Elementary PK 05 2018   kindergarten                                                   71                                             71
3122994 3122994 MO     school 2900031 48918   KIPP: ENDEAVOR ACADEMY 290003103013 3920 KIPP ENDEAVOR ACADEMY   Regular School Yes Elementary KG 08 2018   kindergarten                                                   56                                             56
3123000 3123000 MO     school 2900587 48921   PATHWAY ACADEMY 290058703140 6970 PATHWAY ACADEMY ELEMENTARY   Regular School Yes Elementary PK 04 2018   kindergarten                                                   49                                             49
3123005 3123005 MO     school 2900590 48922   FRONTIER SCHOOLS 290059003181 1920 FRONTIER SCHL OF EXCELLENCE-U   Regular School Yes High 09 12 2018   kindergarten                                                   0                                             0
3123011 3123011 MO     school 2900590 48922   FRONTIER SCHOOLS 290059003232 1985 FRONTIER STEM HIGH SCHOOL   Regular School Yes High 09 12 2018   kindergarten                                                   0                                             0
3123017 3123017 MO     school 2900590 48922   FRONTIER SCHOOLS 290059003182 3935 FRONTIER SCHL OF INNOVATION-M   Regular School Yes Middle 06 08 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]);