Data source: Big Local News · About: Big Local

37,152 rows where state = "MO" and year = 2019 sorted by white_int

View and edit SQL

grade

year

  • 2019 · 37,015
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
3309485 MO     school 2929280 115115   ST. LOUIS CITY 292928002009 1800 SUMNER HIGH   Regular School No High 09 12 2019   k_12_total * 262 * *   *       * *           *         *   69   267   262                                     69   267
3309491 MO     school 2929280 115115   ST. LOUIS CITY 292928002011 1830 VASHON HIGH   Regular School No High 09 12 2019   k_12_total * 434 * *   *       * *           *         *   103   440   434                                     103   440
3309503 MO     school 2929280 115115   ST. LOUIS CITY 292928002878 2080 YEATMAN-LIDDELL MIDDLE SCHOOL   Regular School No Middle 06 08 2019   k_12_total * 386 * *   *       * *           *         *   97   390   386                                     97   390
3309560 MO     school 2929280 115115   ST. LOUIS CITY 292928001877 4060 ASHLAND ELEM. AND BR.   Regular School No Elementary PK 06 2019   k_12_total * 184 * *   *       * *           *         *   23   184   184                                     23   184
3309566 MO     school 2929280 115115   ST. LOUIS CITY 292928001888 4180 BRYAN HILL ELEM.   Regular School No Elementary PK 05 2019   k_12_total * 150 * *   *       * *           *         *   24   150   150                                     24   150
3309584 MO     school 2929280 115115   ST. LOUIS CITY 292928001903 4360 CLAY ELEM.   Regular School No Elementary PK 05 2019   k_12_total * 124 * *   *       * *           *         *   15   131   124                                     15   131
3309590 MO     school 2929280 115115   ST. LOUIS CITY 292928001906 4400 COLE ELEM.   Regular School No Elementary PK 08 2019   k_12_total * 329 5 *   *       * *           *         *   44   336   329 5                                   44   336
3309596 MO     school 2929280 115115   ST. LOUIS CITY 292928002693 4420 COLUMBIA ELEM. COMM. ED. CTR.   Regular School No Elementary PK 06 2019   k_12_total * 173 * *   *       * *           *         *   14   175   173                                     14   175
3309611 MO     school 2929280 115115   ST. LOUIS CITY 292928001916 4480 DUNBAR AND BR.   Regular School No Elementary PK 06 2019   k_12_total * 119 * *   *       * *           *         *   14   119   119                                     14   119
3309617 MO     school 2929280 115115   ST. LOUIS CITY 292928001923 4580 FARRAGUT ELEM.   Regular School No Elementary PK 06 2019   k_12_total * 115 * *   *       * *           *         *   17   115   115                                     17   115
3309623 MO     school 2929280 115115   ST. LOUIS CITY 292928002571 4630 FORD-FORD BR. ELEM. COMM. ED.   Regular School No Elementary PK 06 2019   k_12_total * 167 * *   *       * *           *         *   20   167   167                                     20   167
3309641 MO     school 2929280 115115   ST. LOUIS CITY 292928001937 4780 HAMILTON ELEM. COMMUNITY ED.   Regular School No Elementary PK 05 2019   k_12_total * 238 * *   *       * *           *         *   33   241   238                                     33   241
3309647 MO     school 2929280 115115   ST. LOUIS CITY 292928001942 4880 HENRY ELEM.   Regular School No Elementary PK 06 2019   k_12_total * 199 * *   *       * *           *         *   26   199   199                                     26   199
3309653 MO     school 2929280 115115   ST. LOUIS CITY 292928000444 4890 HICKEY ELEM.   Regular School No Elementary PK 05 2019   k_12_total * 175 * *   *       * *           *         *   13   175   175                                     13   175
3309659 MO     school 2929280 115115   ST. LOUIS CITY 292928001943 4900 HERZOG ELEM.   Regular School No Elementary PK 06 2019   k_12_total * 233 * *   *       * *           *         *   24   234   233                                     24   234
3309665 MO     school 2929280 115115   ST. LOUIS CITY 292928002170 4920 HODGEN ELEM.   Regular School No Elementary PK 06 2019   k_12_total * 194 * *   *       * *           7         *   40   198   194                             7       40   198
3309682 MO     school 2929280 115115   ST. LOUIS CITY 292928003211 4990 GEORGE WASHINGTON CARVER ELEM   Regular School No Elementary PK 05 2019   k_12_total * 164 * *   *       * *           *         *   8   167   164                                     8   167
3309688 MO     school 2929280 115115   ST. LOUIS CITY 292928001950 5020 JEFFERSON ELEM.   Regular School No Elementary PK 05 2019   k_12_total * 139 * *   *       * *           *         *   8   139   139                                     8   139
3309700 MO     school 2929280 115115   ST. LOUIS CITY 292928001955 5060 LACLEDE ELEM.   Regular School No Elementary PK 07 2019   k_12_total * 185 * *   *       * *           *         *   19   188   185                                     19   188
3309706 MO     school 2929280 115115   ST. LOUIS CITY 292928001958 5100 LEXINGTON ELEM.   Regular School No Elementary PK 05 2019   k_12_total * 311 * *   *       * *           *         *   36   312   311                                     36   312
3309742 MO     school 2929280 115115   ST. LOUIS CITY 292928001917 5520 ELIAS MICHAEL ELEM.   Regular School No Elementary PK 08 2019   k_12_total * 40 * *   *       * *           11         *   43   48   40                             11       43   48
3309766 MO     school 2929280 115115   ST. LOUIS CITY 292928002853 5610 EARL NANCE, SR. ELEM.   Regular School No Elementary PK 06 2019   k_12_total * 320 * *   *       * *           *         *   37   323   320                                     37   323
3309772 MO     school 2929280 115115   ST. LOUIS CITY 292928002454 5620 PEABODY ELEM.   Regular School No Elementary PK 05 2019   k_12_total * 134 * *   *       * *           *         *   22   135   134                                     22   135
3309802 MO     school 2929280 115115   ST. LOUIS CITY 292928002015 5960 WALBRIDGE ELEM. COMMUNITY ED.   Regular School No Elementary PK 06 2019   k_12_total * 178 * *   *       * *           *         *   21   178   178                                     21   178
3309814 MO     school 2929280 115115   ST. LOUIS CITY 292928002572 6010 WASHINGTON MONTESSORI   Regular School No Elementary PK 05 2019   k_12_total * 259 * *   *       * *           *         *   24   262   259                                     24   262
3309857 MO     school 2900574 115902   LIFT FOR LIFE ACADEMY 290057402828 3910 LIFT FOR LIFE ACADEMY   Regular School Yes Middle 06 08 2019   k_12_total * 242 5 *   *       * 8           *         *   35   260   242 5               8                   35   260
3309880 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903037 6930 OLD NORTH   Regular School Yes Elementary PK 06 2019   k_12_total * 410 * *   *       * *           *         *   33   417   410                                     33   417
3309886 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903014 6931 ASPIRE ACADEMY   Regular School Yes Elementary PK 06 2019   k_12_total * 363 * *   *       * *           *         *   40   366   363                                     40   366
3309920 MO     school 2900589 115913   NORTH SIDE COMMUNITY SCHOOL 290058903142 6965 NORTH SIDE COMMUNITY SCHOOL   Regular School Yes Elementary PK 04 2019   k_12_total * 344 * *   *       * *           *         *   30   349   344                                     30   349
3309922 MO     school 2900589 115913   NORTH SIDE COMMUNITY SCHOOL 290058903344 6970 NORTH SIDE COMMUNITY-GRAND CTR   Regular School Yes Middle 05 06 2019   k_12_total * 75 * *   *       * *           *         *   11   75   75                                     11   75
3309925 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   k_12_total * 202 9 *   *       * *           9         *   33   214   202 9                           9       33   214
3309937 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103245 6971 KIPP VICTORY ACADEMY   Regular School Yes Elementary KG 04 2019   k_12_total * 539 5 *   *       * 5           *         *   45   550   539 5               5                   45   550
3309942 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103266 6972 KIPP WISDOM ACADEMY   Regular School Yes Elementary KG 04 2019   k_12_total * 491 17 *   *       * *           18         *   32   511   491 17                           18       32   511
3309947 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103270 6973 KIPP TRIUMPH ACADEMY   Regular School Yes Middle 05 08 2019   k_12_total * 413 * *   *       * *           *         *   60   417   413                                     60   417
3310014 MO     school 2900605 115923   EAGLE COLLEGE PREP ENDEAVOR 290060503272 6996 EAGLE FOX PARK   Regular School Yes Elementary KG 05 2019   k_12_total * 137 * *   *       * 5           *         *   17   146   137                 5                   17   146
3310021 MO     school 2900605 115923   EAGLE COLLEGE PREP ENDEAVOR 290060503304 6998 EAGLE GRAVOIS PARK   Regular School Yes Elementary KG 05 2019   k_12_total * 115 * *   *       * 7           *         *   14   127   115                 7                   14   127
3310030 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 10 2019   k_12_total * 53 * *   *       * *           *         *   11   60   53                                     11   60
3310035 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803274 3910 HAWTHORN MIDDLE   Regular School Yes Middle 06 08 2019   k_12_total * 120 * *   *       * *           *         *   14   130   120                                     14   130
3310045 MO     school 2900611 115928   LA SALLE CHARTER SCHOOL 290061103281 3910 LA SALLE CHARTER SCHOOL   Regular School Yes Middle 05 08 2019   k_12_total * 123 * *   *       * *           *         123   20   125   123                                   123 20   125
3310048 MO     school 2900614 115930   THE ARCH COMMUNITY SCHOOL 290061403302 6905 THE ARCH COMMUNITY SCHOOL   Regular School Yes Elementary KG 04 2019   k_12_total * 81 * *   *       * *           *         *   13   88   81                                     13   88
3310116 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203052 9014 LILLIAN SCHAPER SCHOOL   Special Education School No Other KG 12 2019   k_12_total * * * *   *       * *           *         *   *   9                                             9
3310152 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203058 9024 CITADEL SCHOOL   Special Education School No Other KG 12 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3310218 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203070 9056 PRAIRIE VIEW SCHOOL   Special Education School No Other KG 12 2019   k_12_total * * * *   *       * *           *         *   *   6                                             6
3310242 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203074 9070 GATEWAY/HUBERT WHEELER SCHOOL   Special Education School No Other KG 12 2019   k_12_total * 14 * *   *       * *           *         *   *   19   14                                         19
3310260 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901145 1010 MONTGOMERY CITY TREATMENT CTR.   Special Education School No High 06 12 2019   k_12_total * * * *   *       * *           *         *   *   9                                             9
3310284 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901193 1053 ECHO DAY TREATMENT CTR.   Regular School No High 06 12 2019   k_12_total * * * *   *       * *           *         *   *   9                                             9
3310296 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901195 1055 HOGAN ST REGIONAL YOUTH CTR.   Regular School No High 06 12 2019   k_12_total * 17 * *   *       * *           *         *   *   21   17                                         21
3310348 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901270 1065 NORTHWEST REG. YOUTH CTR.   Regular School No High 06 12 2019   k_12_total * 21 * *   *       * *           *         *   5   25   21                                     5   25
3310354 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902211 1067 GATEWAY SCHOOL   Regular School No High 05 12 2019   k_12_total * * * *   *       * *           *         *   *   9                                             9
3310360 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902710 1068 NEW MADRID BEND YOUTH CTR.   Regular School No High 06 12 2019   k_12_total * * * *   *       * *           *         *   *   6                                             6
3310366 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902711 1069 SIKESTON HOPE CTR.   Regular School No High 06 12 2019   k_12_total * 5 * *   *       * *           *         *   *   10   5                                         10
3310372 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901271 1070 BABLER LODGE   Regular School No High 06 12 2019   k_12_total * * * *   *       * *           *         *   *   9                                             9
3310400 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902713 1076 HILLSBORO TREATMENT CTR.   Regular School No High 06 12 2019   k_12_total * * * *   *       * *           *         *   *   8                                             8
3310429 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901285 1083 LANGSFORD HOUSE   Regular School No High 05 12 2019   k_12_total * * * *   *       * *           *         *   *   9                                             9
3310435 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901287 1084 ALTERNATIVE RESOURCE CTR.   Alternative School No High 06 12 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3310454 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902793 1091 ROSA PARKS CENTER   Regular School No High 06 12 2019   k_12_total * * * *   *       * *           *         *   *   5                                             5
3310478 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000903153 1099 MET DAY TREATMENT CENTER   Regular School No High 06 12 2019   k_12_total * 12 * *   *       * *           *         *   *   15   12                                         15
3297375 MO     school 2901000 10093   COLUMBIA 93 290100002577 1015 JUVENILE JUSTICE CTR.   Alternative School No Other 01 12 2019   k_12_total 5 7 * *   *       * *           *         *   *   14 5 7                                         14
3302346 MO     school 2916400 48078   KANSAS CITY 33 291640003294 6960 KANSAS CITY NEIGHBORHOOD ACAD   Regular School Yes Elementary PK 04 2019   k_12_total 5 184 12 *   *       * 5           7         *   32   208 5 184 12               5           7       32   208
3302531 MO     school 2900587 48921   PATHWAY ACADEMY 290058703140 6970 PATHWAY ACADEMY ELEMENTARY   Regular School Yes Elementary PK 04 2019   k_12_total 5 145 6 *   *       * 16           5         *   23   173 5 145 6               16           5       23   173
3306773 MO     school 2913830 96088   HAZELWOOD 291383000621 4150 GRANNEMANN ELEM.   Regular School No Elementary PK 05 2019   k_12_total 5 334 * *   *       * *           *         *   63   343 5 334                                     63   343
3306791 MO     school 2913830 96088   HAZELWOOD 291383000630 4180 LARIMORE ELEM.   Regular School No Elementary PK 05 2019   k_12_total 5 358 * *   *       * *           *         *   47   368 5 358                                     47   368
3308018 MO     school 2926670 96111   RIVERVIEW GARDENS 292667001582 5000 LEMASTERS ELEM.   Regular School No Elementary KG 05 2019   k_12_total 5 305 * *   *       * *           *         *   46   313 5 305                                     46   313
3309578 MO     school 2929280 115115   ST. LOUIS CITY 292928002570 4250 AMES VISUAL/PERF. ARTS   Regular School No Elementary PK 05 2019   k_12_total 5 273 * *   *       * *           *         *   22   283 5 273                                     22   283
3309870 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903102 1920 CONFLUENCE PREPARATORY ACADEMY   Regular School Yes High 07 12 2019   k_12_total 5 664 * *   *       * *           *         *   104   673 5 664                                     104   673
3309931 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103122 6970 KIPP INSPIRE ACADEMY   Regular School Yes Middle 05 08 2019   k_12_total 5 376 9 *   *       * *           7         *   55   393 5 376 9                           7       55   393
3310000 MO     school 2900600 115920   ST. LOUIS COLLEGE PREP 290060003178 3925 St. Louis College Prep Middle   Regular School Yes Middle 06 08 2019   k_12_total 5 97 * *   *       * *           *         *   13   104 5 97                                     13   104
3302294 MO     school 2916400 48078   KANSAS CITY 33 291640002602 5440 B. BANNEKER ELEM.   Regular School No Elementary PK 06 2019   k_12_total 6 333 20 *   *       * 7           11         *   52   367 6 333 20               7           11       52   367
3302453 MO     school 2900025 48909   ALLEN VILLAGE 290002503233 1980 ALLEN VILLAGE HIGH SCHOOL   Regular School Yes High 09 12 2019   k_12_total 6 57 103 *   8       * 5           19         152   21   179 6 57 103     8         5           19     152 21   179
3302455 MO     school 2900025 48909   ALLEN VILLAGE 290002503325 3930 ALLEN VILLAGE JUNIOR   Regular School Yes Middle 06 08 2019   k_12_total 6 58 85 *   6       * *           20         139   9   159 6 58 85     6                     20     139 9   159
3302536 MO     school 2900590 48922   FRONTIER SCHOOLS 290059003181 1920 FRONTIER SCHL OF EXCELLENCE-U   Regular School Yes High 09 12 2019   k_12_total 6 123 72 *   *       * *           49         *   22   201 6 123 72                           49       22   201
3302566 MO     school 2900593 48923   DELASALLE CHARTER SCHOOL 290059303176 1970 DeLaSalle Charter High School   Regular School Yes High 09 12 2019   k_12_total 6 97 9 *   *       * *           *         *   11   113 6 97 9                                   11   113
3306737 MO     school 2913830 96088   HAZELWOOD 291383000614 4020 KEEVEN ELEM.   Regular School No Elementary PK 05 2019   k_12_total 6 340 * *   *       * *           12         *   61   354 6 340                             12       61   354
3309635 MO     school 2929280 115115   ST. LOUIS CITY 292928001587 4730 GATEWAY ELEM.   Regular School No Elementary PK 05 2019   k_12_total 6 488 15 *   *       * *           23         *   46   512 6 488 15                           23       46   512
3309784 MO     school 2929280 115115   ST. LOUIS CITY 292928001997 5800 SHENANDOAH ELEM.   Regular School No Elementary PK 06 2019   k_12_total 6 132 * *   *       * *           *         *   17   144 6 132                                     17   144
3309832 MO     school 2929280 115115   ST. LOUIS CITY 292928002005 6340 ST. LOUIS CHILDREN'S HOSPITAL   Alternative School No Other KG 12 2019   k_12_total 6 7 * *   *       * *           *         *   *   13 6 7                                         13
3309844 MO     school 2900021 115414   MO SCHOOL FOR THE BLIND 290002103039 4020 MO School for the Blind - ELEM   Special Education School No Elementary KG 08 2019   k_12_total 6 * * *   *       * *           *         *   *   10 6                                           10
3309851 MO     school 2900574 115902   LIFT FOR LIFE ACADEMY 290057403183 1935 LIFT FOR LIFE ACADEMY HIGH SCH   Regular School Yes High 09 12 2019   k_12_total 6 290 6 *   *       * 19           *         *   30   325 6 290 6               19                   30   325
3309995 MO     school 2900600 115920   ST. LOUIS COLLEGE PREP 290060003264 1910 St. Louis College Prep High   Regular School Yes High 09 12 2019   k_12_total 6 175 6 *   *       * *           *         *   47   190 6 175 6                                   47   190
3310272 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901185 1051 SIERRA-OSAGE TREATMENT CTR.   Regular School No High 05 12 2019   k_12_total 6 * * *   *       * *           *         *   *   10 6                                           10
3302423 MO     school 2900029 48902   GUADALUPE CENTERS SCHOOLS 290002903216 6905 GUADALUPE CENTERS ELEMENTARY   Regular School Yes Elementary PK 05 2019   k_12_total 7 10 508 *   *       * 15           488         484   44   542 7 10 508               15           488     484 44   542
3306707 MO     school 2913830 96088   HAZELWOOD 291383003000 2070 CENTRAL MIDDLE   Regular School No Middle 06 08 2019   k_12_total 7 764 11 *   *       * *           *         518   130   792 7 764 11                                 518 130   792
3306731 MO     school 2913830 96088   HAZELWOOD 291383003005 2170 SOUTHEAST MIDDLE   Regular School No Middle 06 08 2019   k_12_total 7 651 * *   *       * *           *         *   120   665 7 651                                     120   665
3306785 MO     school 2913830 96088   HAZELWOOD 291383000626 4170 JAMESTOWN ELEM.   Regular School No Elementary KG 05 2019   k_12_total 7 330 * *   *       * 11           *         226   53   355 7 330                 11                 226 53   355
3306894 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201000354 3000 BERKELEY MIDDLE   Regular School No Middle 06 08 2019   k_12_total 7 307 14 *   *       * 12           *         *   54   340 7 307 14               12                   54   340
3306917 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201000452 4020 BERMUDA ELEM.   Regular School No Elementary KG 05 2019   k_12_total 7 199 6 *   *       * 13           *         *   28   227 7 199 6               13                   28   227
3306977 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201002784 4210 JOHNSON WABASH ELEM.   Regular School No Elementary KG 06 2019   k_12_total 7 343 6 *   *       * 5           *         *   77   361 7 343 6               5                   77   361
3308012 MO     school 2926670 96111   RIVERVIEW GARDENS 292667002627 4080 HIGHLAND ELEM.   Regular School No Elementary KG 05 2019   k_12_total 7 304 * *   *       * *           *         *   41   313 7 304                                     41   313
3308066 MO     school 2930660 96112   UNIVERSITY CITY 293066002105 4060 BARBARA JORDAN ELEM.   Regular School No Elementary KG 05 2019   k_12_total 7 307 24 *   *       * 7           25         348   43   349 7 307 24               7           25     348 43   349
3309412 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Career and Technical School No High 09 12 2019   k_12_total 7 530 5 *   *       * *           8         *   39   543 7 530 5                           8       39   543
3309629 MO     school 2929280 115115   ST. LOUIS CITY 292928001928 4660 FROEBEL ELEM.   Regular School No Elementary PK 05 2019   k_12_total 7 149 * *   *       * *           *         *   22   164 7 149                                     22   164
3309790 MO     school 2929280 115115   ST. LOUIS CITY 292928002000 5860 SIGEL ELEM. COMM. ED. CTR.   Regular School No Elementary PK 06 2019   k_12_total 7 200 6 *   *       * *           65         *   34   213 7 200 6                           65       34   213
3310308 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902196 1057 QUEST DAY TREATMENT   Regular School No High 06 12 2019   k_12_total 7 7 * *   *       * *           *         *   *   14 7 7                                         14
3310336 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901261 1062 LEWIS AND CLARK HALL   Regular School No High 06 12 2019   k_12_total 7 * * *   *       * *           *         *   *   10 7                                           10
3306713 MO     school 2913830 96088   HAZELWOOD 291383000629 2100 EAST MIDDLE   Regular School No Middle 08 08 2019   k_12_total 8 159 * *   *       * *           *         *   36   170 8 159                                     36   170
3306851 MO     school 2913830 96088   HAZELWOOD 291383002858 4340 ARROWPOINT ELEM.   Regular School No Elementary PK 05 2019   k_12_total 8 465 5 *   *       * 9           *         *   101   488 8 465 5               9                   101   488
3307878 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265001244 3000 7th and 8th Grade Center   Regular School No Middle 07 08 2019   k_12_total 8 422 9 *   *       * 5           8         461   59   446 8 422 9               5           8     461 59   446
3307982 MO     school 2926670 96111   RIVERVIEW GARDENS 292667002539 3000 R. G. CENTRAL MIDDLE   Regular School No Middle 06 08 2019   k_12_total 8 697 * *   *       * *           5         *   126   708 8 697                             5       126   708
3309536 MO     school 2929280 115115   ST. LOUIS CITY 292928003215 3250 ACAD OF ENTRE STDY@LOUVERTURE   Regular School No Middle 06 08 2019   k_12_total 8 299 * *   5       * *           15         *   36   317 8 299       5                     15       36   317
3310248 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203075 9071 ROLLING MEADOW SCHOOL   Special Education School No Other KG 12 2019   k_12_total 8 * * *   *       * *           *         *   *   10 8                                           10

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