Data source: Big Local News · About: Big Local

36,624 rows where state = "MO" and year = 2016 sorted by white_int

View and edit SQL

grade

year

  • 2016 · 36,524
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
3309451 MO     school 2929280 115115   ST. LOUIS CITY 292928002875 1540 TRANSPORTATION AND LAW   Regular School No 3 09 12 2016   k_12_total * 366 * *   *       * *           *         *   71   370   366                                     71   370
3309482 MO     school 2929280 115115   ST. LOUIS CITY 292928002009 1800 SUMNER HIGH   Regular School No 3 09 12 2016   k_12_total * 355 * *   *       * *           *         *   88   356   355                                     88   356
3309488 MO     school 2929280 115115   ST. LOUIS CITY 292928002011 1830 VASHON HIGH   Regular School No 3 09 12 2016   k_12_total * 613 * *   *       * *           *         *   127   616   613                                     127   616
3309500 MO     school 2929280 115115   ST. LOUIS CITY 292928002878 2080 YEATMAN-LIDDELL MIDDLE SCHOOL   Regular School No 2 06 08 2016   k_12_total * 345 * *   *       * *           *         *   80   350   345                                     80   350
3309530 MO     school 2929280 115115   ST. LOUIS CITY 292928001957 3240 LANGSTON MIDDLE   Regular School No 2 06 08 2016   k_12_total * 228 * *   *       * *           *         *   63   228   228                                     63   228
3309557 MO     school 2929280 115115   ST. LOUIS CITY 292928001877 4060 ASHLAND ELEM. AND BR.   Regular School No 1 PK 06 2016   k_12_total * 292 * *   *       * *           *         *   31   292   292                                     31   292
3309563 MO     school 2929280 115115   ST. LOUIS CITY 292928001888 4180 BRYAN HILL ELEM.   Regular School No 1 PK 05 2016   k_12_total * 154 * *   *       * *           *         *   20   154   154                                     20   154
3309575 MO     school 2929280 115115   ST. LOUIS CITY 292928002570 4250 AMES VISUAL/PERF. ARTS   Regular School No 1 PK 05 2016   k_12_total * 359 * *   *       * *           *         *   58   363   359                                     58   363
3309581 MO     school 2929280 115115   ST. LOUIS CITY 292928001903 4360 CLAY ELEM.   Regular School No 1 PK 05 2016   k_12_total * 114 * *   *       * *           *         *   22   116   114                                     22   116
3309587 MO     school 2929280 115115   ST. LOUIS CITY 292928001906 4400 COLE ELEM.   Regular School No 1 PK 08 2016   k_12_total * 347 * *   *       * *           *         *   53   352   347                                     53   352
3309593 MO     school 2929280 115115   ST. LOUIS CITY 292928002693 4420 COLUMBIA ELEM. COMM. ED. CTR.   Regular School No 1 PK 06 2016   k_12_total * 125 * *   *       * *           *         *   18   125   125                                     18   125
3309599 MO     school 2929280 115115   ST. LOUIS CITY 292928001911 4440 COTE BRILLIANTE ELEM.   Regular School No 1 PK 06 2016   k_12_total * 184 * *   *       * *           *         *   30   185   184                                     30   185
3309608 MO     school 2929280 115115   ST. LOUIS CITY 292928001916 4480 DUNBAR AND BR.   Regular School No 1 PK 06 2016   k_12_total * 149 * *   *       * *           *         *   13   150   149                                     13   150
3309614 MO     school 2929280 115115   ST. LOUIS CITY 292928001923 4580 FARRAGUT ELEM.   Regular School No 1 PK 06 2016   k_12_total * 144 * *   *       * *           *         *   20   144   144                                     20   144
3309620 MO     school 2929280 115115   ST. LOUIS CITY 292928002571 4630 FORD-FORD BR. ELEM. COMM. ED.   Regular School No 1 PK 06 2016   k_12_total * 232 * *   *       * *           *         *   27   233   232                                     27   233
3309638 MO     school 2929280 115115   ST. LOUIS CITY 292928001937 4780 HAMILTON ELEM. COMMUNITY ED.   Regular School No 1 PK 05 2016   k_12_total * 281 * *   *       * *           *         *   45   283   281                                     45   283
3309644 MO     school 2929280 115115   ST. LOUIS CITY 292928001942 4880 HENRY ELEM.   Regular School No 1 PK 06 2016   k_12_total * 178 * *   *       * *           *         *   20   180   178                                     20   180
3309650 MO     school 2929280 115115   ST. LOUIS CITY 292928000444 4890 HICKEY ELEM.   Regular School No 1 PK 05 2016   k_12_total * 156 * *   *       * *           *         *   25   157   156                                     25   157
3309656 MO     school 2929280 115115   ST. LOUIS CITY 292928001943 4900 HERZOG ELEM.   Regular School No 1 PK 06 2016   k_12_total * 297 * *   *       * *           *         *   25   298   297                                     25   298
3309679 MO     school 2929280 115115   ST. LOUIS CITY 292928003211 4990 ACAD OF ENVT SCI/MATH ELEM   Regular School No 1 PK 05 2016   k_12_total * 261 * *   *       * *           *         *   18   261   261                                     18   261
3309685 MO     school 2929280 115115   ST. LOUIS CITY 292928001950 5020 JEFFERSON ELEM.   Regular School No 1 PK 05 2016   k_12_total * 184 * *   *       * *           *         *   25   187   184                                     25   187
3309697 MO     school 2929280 115115   ST. LOUIS CITY 292928001955 5060 LACLEDE ELEM.   Regular School No 1 PK 05 2016   k_12_total * 205 * *   *       * *           *         *   14   206   205                                     14   206
3309703 MO     school 2929280 115115   ST. LOUIS CITY 292928001958 5100 LEXINGTON ELEM.   Regular School No 1 PK 05 2016   k_12_total * 328 * *   *       * *           *         *   48   328   328                                     48   328
3309763 MO     school 2929280 115115   ST. LOUIS CITY 292928002853 5610 EARL NANCE, SR. ELEM.   Regular School No 1 PK 06 2016   k_12_total * 290 * *   *       * *           *         *   32   293   290                                     32   293
3309769 MO     school 2929280 115115   ST. LOUIS CITY 292928002454 5620 PEABODY ELEM.   Regular School No 1 PK 05 2016   k_12_total * 190 * *   *       * *           *         *   12   191   190                                     12   191
3309799 MO     school 2929280 115115   ST. LOUIS CITY 292928002015 5960 WALBRIDGE ELEM. COMMUNITY ED.   Regular School No 1 PK 06 2016   k_12_total * 192 * *   *       * *           *         *   22   194   192                                     22   194
3309811 MO     school 2929280 115115   ST. LOUIS CITY 292928002572 6010 WASHINGTON MONTESSORI   Regular School No 1 PK 05 2016   k_12_total * 297 * 7   *       * *           *         *   22   308   297   7                                 22   308
3309829 MO     school 2929280 115115   ST. LOUIS CITY 292928002005 6340 ST. LOUIS CHILDREN'S HOSPITAL   Alternative Education School No 4 KG 12 2016   k_12_total * 14 * *   *       * *           *         *   *   18   14                                         18
3309867 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903102 1920 CONFLUENCE PREPARATORY ACADEMY   Regular School Yes 3 07 12 2016   k_12_total * 609 9 *   *       * 6           *         *   72   626   609 9               6                   72   626
3309877 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903037 6930 OLD NORTH   Regular School Yes 1 KG 08 2016   k_12_total * 796 * *   *       * 5           *         *   76   805   796                 5                   76   805
3309883 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903014 6931 ASPIRE ACADEMY   Regular School Yes 1 PK 06 2016   k_12_total * 644 * *   *       * *           *         *   53   648   644                                     53   648
3309917 MO     school 2900589 115913   NORTH SIDE COMMUNITY SCHOOL 290058903142 6965 NORTH SIDE COMMUNITY SCHOOL   Regular School Yes 1 PK 05 2016   k_12_total * 343 * *   *       * *           *         *   31   348   343                                     31   348
3309928 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103122 6970 KIPP INSPIRE ACADEMY   Regular School Yes 2 05 08 2016   k_12_total * 339 * *   *       * *           *         *   44   344   339                                     44   344
3309934 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103245 6971 KIPP VICTORY ACADEMY   Regular School Yes 1 KG 02 2016   k_12_total * 316 8 *   *       * *           *         *   30   324   316 8                                   30   324
3309939 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103266 6972 KIPP WISDOM ACADEMY   Regular School Yes 1 KG 01 2016   k_12_total * 204 * *   *       * *           *         *   17   207   204                                     17   207
3309944 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103270 6973 KIPP TRIUMPH ACADEMY   Regular School Yes 2 05 05 2016   k_12_total * 81 * *   *       * *           *         *   10   81   81                                     10   81
3309989 MO     school 2900598 115919   PRECLARUS MASTERY ACADEMY 290059803179 3930 PRECLARUS MASTERY ACADEMY   Regular School Yes 2 05 08 2016   k_12_total * 152 * *   *       * *           *         *   17   153   152                                     17   153
3310002 MO     school 2900602 115921   JAMAA LEARNING CENTER 290060203198 6985 JAMAA LEARNING CENTER   Regular School Yes 1 KG 08 2016   k_12_total * 159 * *   *       * *           *         *   23   159   159                                     23   159
3310004 MO     school 2900599 115922   BETTER LEARNING COMM ACADEMY 290059903197 6990 BETTER LEARNING COMM ACADEMY   Regular School Yes 1 KG 06 2016   k_12_total * 186 * *   *       * *           *         *   23   189   186                                     23   189
3310032 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803274 3910 HAWTHORN LEADERSHIP SCHL GIRLS   Regular School Yes 2 06 07 2016   k_12_total * 115 * *   *       * 6           *         *   *   124   115                 6                       124
3310042 MO     school 2900611 115928   LA SALLE CHARTER SCHOOL 290061103281 3910 LA SALLE CHARTER SCHOOL   Regular School Yes 2 05 08 2016   k_12_total * 87 * *   *       * *           *         *   16   88   87                                     16   88
3310215 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203070 9056 PRAIRIE VIEW SCHOOL   Special Education School No 4 KG 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3310245 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203075 9071 ROLLING MEADOW SCHOOL   Special Education School No 4 KG 12 2016   k_12_total * * * *   *       * *           *         *   *   7                                             7
3310293 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901195 1055 HOGAN ST REGIONAL YOUTH CTR.   Regular School No 4 06 12 2016   k_12_total * 27 * *   *       * *           *         *   16   31   27                                     16   31
3310329 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901259 1061 SPANISH LAKE CAMPUS   Regular School No 4 06 12 2016   k_12_total * 17 * *   *       * *           *         *   8   21   17                                     8   21
3310363 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902711 1069 SIKESTON HOPE CTR.   Regular School No 4 06 12 2016   k_12_total * * * *   *       * *           *         *   *   9                                             9
3310387 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000903077 1074 DISCOVERY HALL   Regular School No 4 06 12 2016   k_12_total * 7 * *   *       * *           *         *   *   11   7                                         11
3310397 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902713 1076 HILLSBORO TREATMENT CTR.   Regular School No 4 06 12 2016   k_12_total * 14 * *   *       * *           *         *   8   18   14                                     8   18
3310426 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901285 1083 LANGSFORD HOUSE   Regular School No 4 05 12 2016   k_12_total * * * *   *       * *           *         *   *   8                                             8
3310432 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901287 1084 ALTERNATIVE RESOURCE CTR.   Alternative Education School No 4 06 12 2016   k_12_total * * * *   *       * *           *         *   *   6                                             6
3310451 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902793 1091 ROSA PARKS CENTER   Regular School No 4 06 12 2016   k_12_total * * * *   *       * *           *         *   *   8                                             8
3310469 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901364 1097 EXCEL SCHOOL   Regular School No 4 06 12 2016   k_12_total * * * *   *       * *           *         *   *   9                                             9
3310475 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000903153 1099 MET DAY TREATMENT CENTER   Regular School No 4 06 12 2016   k_12_total * * * *   *       * *           *         *   *   8                                             8
3310486 MO     school 2900607 401401   MO VIRTUAL INSTRUCTION PROGRAM 290060703225 4020 MOVIP ELEM. SCHOOL   Alternative Education School No 1 KG 05 2016   k_12_total * * * *   *       * *           *         *   *   9                                             9
3302277 MO     school 2916400 48078   KANSAS CITY 33 291640000882 5200 WENDELL PHILLIPS ELEM.   Regular School No 1 PK 06 2016   k_12_total 5 237 7 *   *       * 16           *         *   36   268 5 237 7               16                   36   268
3302297 MO     school 2916400 48078   KANSAS CITY 33 291640002606 5450 HOLLIDAY MONTESSORI   Regular School No 1 PK 06 2016   k_12_total 5 212 7 *   *       * *           *         *   14   227 5 212 7                                   14   227
3302420 MO     school 2900029 48902   ALTA VISTA CHARTER SCH. 290002903216 6905 ALTA VISTA ELEMENTARY SCHOOL   Regular School Yes 1 KG 03 2016   k_12_total 5 8 255 *   *       * 25           235         282   48   295 5 8 255               25           235     282 48   295
3306818 MO     school 2913830 96088   HAZELWOOD 291383000635 4250 TOWNSEND ELEM.   Regular School No 1 PK 05 2016   k_12_total 5 277 * *   *       * *           *         222   49   289 5 277                                   222 49   289
3307909 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265003269 5020 NORMANDY KINDERGARTEN CENTER   Regular School No 1 KG KG 2016   k_12_total 5 309 10 *   *       * *           9         341   32   327 5 309 10                           9     341 32   327
3307985 MO     school 2926670 96111   RIVERVIEW GARDENS 292667001577 4020 DANFORTH ELEM.   Regular School No 1 KG 05 2016   k_12_total 5 325 * *   *       * *           *         377   41   332 5 325                                   377 41   332
3307997 MO     school 2926670 96111   RIVERVIEW GARDENS 292667000726 4050 GIBSON ELEM.   Regular School No 1 KG 05 2016   k_12_total 5 402 * *   *       * *           *         437   50   413 5 402                                   437 50   413
3308015 MO     school 2926670 96111   RIVERVIEW GARDENS 292667001582 5000 LEMASTERS ELEM.   Regular School No 1 KG 05 2016   k_12_total 5 325 * *   *       * *           7         *   36   335 5 325                             7       36   335
3309626 MO     school 2929280 115115   ST. LOUIS CITY 292928001928 4660 FROEBEL ELEM.   Regular School No 1 PK 05 2016   k_12_total 5 242 * *   *       * *           *         *   20   254 5 242                                     20   254
3309662 MO     school 2929280 115115   ST. LOUIS CITY 292928002170 4920 HODGEN ELEM.   Regular School No 1 PK 06 2016   k_12_total 5 217 * *   *       * *           *         *   42   223 5 217                                     42   223
3302291 MO     school 2916400 48078   KANSAS CITY 33 291640002602 5440 B. BANNEKER ELEM.   Regular School No 1 PK 06 2016   k_12_total 6 254 16 *   *       * 6           *         *   55   285 6 254 16               6                   55   285
3302309 MO     school 2916400 48078   KANSAS CITY 33 291640000879 5580 TROOST ELEM.   Regular School No 1 PK 06 2016   k_12_total 6 194 6 *   *       * 10           *         *   47   216 6 194 6               10                   47   216
3302414 MO     school 2900029 48902   ALTA VISTA CHARTER SCH. 290002903166 3925 ALTA VISTA MIDDLE SCHOOL   Regular School Yes 2 06 08 2016   k_12_total 6 11 167 *   *       * 11           129         *   11   195 6 11 167               11           129       11   195
3306734 MO     school 2913830 96088   HAZELWOOD 291383000614 4020 KEEVEN ELEM.   Regular School No 1 PK 05 2016   k_12_total 6 373 5 *   *       * *           15         318   56   388 6 373 5                           15     318 56   388
3306848 MO     school 2913830 96088   HAZELWOOD 291383002858 4340 ARROWPOINT ELEM.   Regular School No 1 PK 05 2016   k_12_total 6 539 * *   *       * 5           *         464   60   554 6 539                 5                 464 60   554
3306950 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201000466 4160 GRIFFITH ELEM.   Regular School No 1 KG 06 2016   k_12_total 6 339 * *   *       * 12           *         *   55   364 6 339                 12                   55   364
3307899 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265001249 4160 WASHINGTON ELEM.   Regular School No 1 01 06 2016   k_12_total 6 259 5 *   *       * *           *         305   40   274 6 259 5                                 305 40   274
3307979 MO     school 2926670 96111   RIVERVIEW GARDENS 292667002539 3000 R. G. CENTRAL MIDDLE   Regular School No 2 06 08 2016   k_12_total 6 641 6 *   *       * *           *         704   111   653 6 641 6                                 704 111   653
3308003 MO     school 2926670 96111   RIVERVIEW GARDENS 292667001579 4060 GLASGOW ELEM.   Regular School No 1 KG 05 2016   k_12_total 6 328 * *   *       * *           *         *   51   337 6 328                                     51   337
3308009 MO     school 2926670 96111   RIVERVIEW GARDENS 292667002627 4080 HIGHLAND ELEM.   Regular School No 1 KG 05 2016   k_12_total 6 335 * *   *       * *           *         *   49   344 6 335                                     49   344
3309551 MO     school 2929280 115115   ST. LOUIS CITY 292928002789 4000 ADAMS ELEM.   Regular School No 1 PK 06 2016   k_12_total 6 263 * *   *       * *           *         *   35   271 6 263                                     35   271
3309739 MO     school 2929280 115115   ST. LOUIS CITY 292928001917 5520 ELIAS MICHAEL ELEM.   Regular School No 1 PK 08 2016   k_12_total 6 46 * *   *       * *           *         *   *   55 6 46                                         55
3309992 MO     school 2900600 115920   SOUTH CITY PREPARATORY ACADEMY 290060003264 1910 ST LOUIS COLLEGE PREP HIGH   Regular School Yes 4 09 09 2016   k_12_total 6 67 * *   *       * *           *         *   20   76 6 67                                     20   76
3310333 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901261 1062 LEWIS AND CLARK HALL   Regular School No 4 06 12 2016   k_12_total 6 * * *   *       * *           *         *   *   11 6                                           11
3310369 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901271 1070 BABLER LODGE   Regular School No 4 06 12 2016   k_12_total 6 14 * *   *       * *           *         *   8   20 6 14                                     8   20
3302181 MO     school 2916400 48078   KANSAS CITY 33 291640003097 1670 AFRICAN CENT COLLEGE PREP ACAD   Regular School No 3 07 12 2016   k_12_total 7 362 * *   *       * *           *         *   48   376 7 362                                     48   376
3302303 MO     school 2916400 48078   KANSAS CITY 33 291640000818 5500 CARVER DUAL LANGUAGE SCHOOL   Regular School No 1 PK 06 2016   k_12_total 7 61 315 *   *       * *           264         *   27   387 7 61 315                           264       27   387
3302327 MO     school 2916400 48078   KANSAS CITY 33 291640001718 5670 AC PREP ELEMENTARY   Regular School No 1 PK 06 2016   k_12_total 7 325 * *   *       * 7           *         *   36   345 7 325                 7                   36   345
3302563 MO     school 2900593 48923   DELASALLE CHARTER SCHOOL 290059303176 1970 DELASALLE CHARTER SCHOOL   Regular School Yes 3 09 12 2016   k_12_total 7 195 23 *   *       * *           12         *   33   227 7 195 23                           12       33   227
3306824 MO     school 2913830 96088   HAZELWOOD 291383000636 4260 TWILLMAN ELEM.   Regular School No 1 PK 05 2016   k_12_total 7 327 * *   *       * *           *         294   82   338 7 327                                   294 82   338
3306939 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201000457 4100 COOL VALLEY ELEM.   Regular School No 1 KG 06 2016   k_12_total 7 225 * *   *       * 10           *         *   22   243 7 225                 10                   22   243
3307875 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265001244 3000 7th and 8th Grade Center   Regular School No 2 07 08 2016   k_12_total 7 399 * *   *       * *           *         445   68   411 7 399                                   445 68   411
3307893 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265002850 4145 LUCAS CROSSING ELEM. COMPLEX   Regular School No 1 01 06 2016   k_12_total 7 780 20 *   *       * *           20         836   91   812 7 780 20                           20     836 91   812
3308081 MO     school 2930660 96112   UNIVERSITY CITY 293066002112 4200 PERSHING ELEM.   Regular School No 1 KG 05 2016   k_12_total 7 324 * *   *       * *           *         275   39   337 7 324                                   275 39   337
3309533 MO     school 2929280 115115   ST. LOUIS CITY 292928003215 3250 ACAD OF ENVT SCI/MATH MIDDLE   Regular School No 2 06 08 2016   k_12_total 7 208 * *   *       * *           *         *   28   216 7 208                                     28   216
3309733 MO     school 2929280 115115   ST. LOUIS CITY 292928001975 5500 MERAMEC ELEM.   Regular School No 1 PK 05 2016   k_12_total 7 187 * *   *       * *           5         *   22   197 7 187                             5       22   197
3310037 MO     school 2900609 115926   THE BIOME 290060903262 6905 THE BIOME   Regular School Yes 1 KG 01 2016   k_12_total 7 44 * *   *       * 10           *         33   6   61 7 44                 10                 33 6   61
3310239 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203074 9070 GATEWAY/HUBERT WHEELER SCHOOL   Special Education School No 4 KG 12 2016   k_12_total 7 26 * *   *       * *           *         *   *   33 7 26                                         33
3310281 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901193 1053 ECHO DAY TREATMENT CTR.   Regular School No 4 06 12 2016   k_12_total 7 10 * *   *       * *           *         *   *   17 7 10                                         17
3310311 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901199 1058 BISSELL HALL   Regular School No 4 06 12 2016   k_12_total 7 12 * *   *       * *           *         *   11   19 7 12                                     11   19
3302402 MO     school 2900027 48901   UNIVERSITY ACADEMY 290002702915 6965 UNIVERSITY ACADEMY-LOWER   Regular School Yes 1 KG 05 2016   k_12_total 8 599 7 *   *       * *           *         477   26   615 8 599 7                                 477 26   615
3309787 MO     school 2929280 115115   ST. LOUIS CITY 292928002000 5860 SIGEL ELEM. COMM. ED. CTR.   Regular School No 1 PK 06 2016   k_12_total 8 225 * *   *       * *           51         *   21   236 8 225                             51       21   236
3309841 MO     school 2900021 115414   MO SCHOOL FOR THE BLIND 290002103039 4020 MO School for the Blind - ELEM   Special Education School No 1 KG 08 2016   k_12_total 8 * * *   *       * *           *         *   *   11 8                                           11
3309914 MO     school 2900586 115912   ST. LOUIS LANG IMMERSION SCH 290058603247 6963 THE INTERNATIONAL SCHOOL   Regular School Yes 2 06 07 2016   k_12_total 8 39 7 *   *       * *           6         37   6   54 8 39 7                           6     37 6   54
3310101 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203049 9010 BOOTHEEL SCHOOL   Special Education School No 4 KG 12 2016   k_12_total 8 * * *   *       * *           *         *   *   14 8                                           14
3310299 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902179 1056 CORNERSTONE   Regular School No 4 06 12 2016   k_12_total 8 * * *   *       * *           *         *   *   12 8                                           12

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