Data source: Big Local News · About: Big Local

36,720 rows where state = "MO" and year = 2017 sorted by black descending

View and edit SQL

grade

year

  • 2017 · 36,720
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
3297626 MO     school 2927060 11082   ST. JOSEPH 292706001660 1080 LAFAYETTE HIGH   Regular School No High 09 12 2017   k_12_total 612 99 51 *   *       5 37           12         465   124   809 612 99 51             5 37           12     465 124   809
3307530 MO     school 2923580 96095   PARKWAY C-2 292358001376 4030 BELLERIVE ELEM.   Regular School No Elementary PK 05 2017   k_12_total 196 99 14 *   52       * 24           25         94   95   386 196 99 14     52         24           25     94 95   386
3299296 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001291 4560 TOPPING ELEM.   Regular School No Elementary PK 05 2017   k_12_total 140 98 51 *   10       * 27           62         221   29   329 140 98 51     10         27           62     221 29   329
3304593 MO     school 2900004 72074   NEW MADRID CO. R-I 290000401991 3000 CENTRAL MIDDLE   Regular School No Middle 06 08 2017   k_12_total 205 98 8 *   *       * 8           *         228   80   319 205 98 8               8                 228 80   319
3306873 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201000472 1050 MCCLUER HIGH   Regular School No High 09 12 2017   k_12_total 77 970 25 *   8       * 32           19         *   216   1112 77 970 25     8         32           19       216   1112
3301628 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830000982 3080 PLEASANT LEA MIDDLE   Regular School No Middle 07 08 2017   k_12_total 647 97 49 *   27       * 51           27         233   105   878 647 97 49     27         51           27     233 105   878
3306042 MO     school 2908370 92087   FT. ZUMWALT R-II 290837001539 3050 DR. BERNARD J. DUBRAY MIDDLE   Regular School No Middle 06 08 2017   k_12_total 662 97 51 *   27       * 34           19         268   165   872 662 97 51     27         34           19     268 165   872
3307846 MO     school 2920010 96107   MAPLEWOOD-RICHMOND HEIGHTS 292001001067 1050 MAPLEWOOD-RICHMOND HGTS. HIGH   Regular School No High 09 12 2017   k_12_total 178 97 16 *   6       * 15           *         119   48   314 178 97 16     6         15                 119 48   314
3309896 MO     school 2900585 115911   CITY GARDEN MONTESSORI 290058503101 6955 CITY GARDEN MONTESSORI SCHOOL   Regular School Yes Elementary PK 08 2017   k_12_total 114 97 11 *   *       * 7           *         97   32   231 114 97 11               7                 97 32   231
3309902 MO     school 2900586 115912   ST. LOUIS LANG IMMERSION SCH 290058603126 6960 THE FRENCH SCHOOL   Regular School Yes Elementary KG 05 2017   k_12_total 63 97 6 *   *       * 7           6         110   26   174 63 97 6               7           6     110 26   174
3309976 MO     school 2900592 115916   GATEWAY SCIENCE ACAD/ST LOUIS 290059203241 6997 GATEWAY SCIENCE ACAD-SOUTH ELE   Regular School Yes Elementary KG 05 2017   k_12_total 231 97 23 *   8       * 40           63         266   43   400 231 97 23     8         40           63     266 43   400
3299260 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001277 4380 LINDEN WEST ELEM.   Regular School No Elementary PK 05 2017   k_12_total 241 96 72 6   12       15 34           71         332   34   476 241 96 72 6   12       15 34           71     332 34   476
3302013 MO     school 2915480 48077   INDEPENDENCE 30 291548003090 3060 CLIFFORD H. NOWLIN MIDDLE   Regular School No Middle 06 08 2017   k_12_total 423 96 259 *   *       6 64           86         715   112   851 423 96 259             6 64           86     715 112   851
3306012 MO     school 2908370 92087   FT. ZUMWALT R-II 290837000239 1050 FT. ZUMWALT NORTH HIGH   Regular School No High 09 12 2017   k_12_total 1286 96 52 *   18       * 48           15         251   224   1504 1286 96 52     18         48           15     251 224   1504
3306397 MO     school 2928920 92090   ST. CHARLES R-VI 292892001851 1075 ST. CHARLES WEST HIGH   Regular School No High 09 12 2017   k_12_total 528 96 27 *   13       * 9           11         180   99   674 528 96 27     13         9           11     180 99   674
3307709 MO     school 2909720 96102   CLAYTON 290972002584 3000 WYDOWN MIDDLE   Regular School No Middle 06 08 2017   k_12_total 435 96 27 *   71       * 23           8         77   73   653 435 96 27     71         23           8     77 73   653
3307670 MO     school 2904500 96099   BAYLESS 290450000043 4020 BAYLESS ELEMENTARY   Regular School No Elementary PK 05 2017   k_12_total 561 95 32 *   96       * 30           243         510   132   814 561 95 32     96         30           243     510 132   814
3300589 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001813 3100 PIPKIN MIDDLE   Regular School No Middle 06 08 2017   k_12_total 392 94 43 *   6       * 23           9         426   56   563 392 94 43     6         23           9     426 56   563
3302482 MO     school 2900013 48912   DELLA LAMB ELEM. 290001303275 6931 DELLA LAMB @ WOODLAND   Regular School Yes Elementary KG 01 2017   k_12_total 11 94 17 *   8       * *           87         *   *   132 11 94 17     8                     87           132
3305391 MO     school 2925230 83003   PLATTE CO. R-III 292523003086 4020 PATHFINDER ELEM.   Regular School No Elementary PK 04 2017   k_12_total 357 94 68 *   23       7 39           40         173   41   591 357 94 68     23       7 39           40     173 41   591
3297516 MO     school 2901000 10093   COLUMBIA 93 290100000307 5040 PARKADE ELEM.   Regular School No Elementary PK 05 2017   k_12_total 238 93 26 *   9       * 51           9         243   51   420 238 93 26     9         51           9     243 51   420
3299154 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001258 3000 ANTIOCH MIDDLE   Regular School No Middle 06 08 2017   k_12_total 604 93 113 *   27       12 80           12         423.2   84   931 604 93 113     27       12 80           12       84   931
3297421 MO     school 2901000 10093   COLUMBIA 93 290100000841 3000 ANN HAWKINS GENTRY MIDDLE   Regular School No Middle 06 08 2017   k_12_total 637 92 32 5   51       * 39           8         217   81   859 637 92 32 5   51         39           8     217 81   859
3297772 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001469 2050 POPLAR BLUFF JR. HIGH   Regular School No Middle 07 08 2017   k_12_total 654 92 22 *   *       * 17           *         503   109   792 654 92 22               17                 503 109   792
3304611 MO     school 2900004 72074   NEW MADRID CO. R-I 290000401484 4140 NEW MADRID ELEM.   Regular School No Elementary PK 05 2017   k_12_total 173 92 * *   *       * *           *         185   63   271 173 92                                   185 63   271
3298217 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712000187 4040 FRANKLIN ELEM.   Regular School No Elementary PK 04 2017   k_12_total 100 91 23 *   8       * 39           16         228   38   261 100 91 23     8         39           16     228 38   261
3299470 MO     school 2916190 26006   JEFFERSON CITY 291619002494 4050 CLARENCE LAWSON ELEM.   Regular School No Elementary KG 05 2017   k_12_total 263 91 34 *   14       * 43           17         262   54   445 263 91 34     14         43           17     262 54   445
3302344 MO     school 2916400 48078   KANSAS CITY 33 291640003294 6960 KANSAS CITY NEIGHBORHOOD ACAD   Regular School Yes Elementary PK 02 2017   k_12_total * 91 * *   *       * *           *         *   10   97   91                                     10   97
3306090 MO     school 2908370 92087   FT. ZUMWALT R-II 290837000238 4070 PROGRESS SOUTH ELEM.   Regular School No Elementary KG 05 2017   k_12_total 639 91 34 *   26       * 17           20         143   108   809 639 91 34     26         17           20     143 108   809
3307286 MO     school 2916770 96092   KIRKWOOD R-VII 291677000921 5060 GEORGE R. ROBINSON ELEM.   Regular School No Elementary KG 05 2017   k_12_total 358 91 15 *   11       * 50           *         129   64   525 358 91 15     11         50                 129 64   525
3307739 MO     school 2913620 96103   HANCOCK PLACE 291362000583 1050 HANCOCK SR. HIGH   Regular School No High 09 12 2017   k_12_total 288 91 26 *   *       * 26           10         *   54   433 288 91 26               26           10       54   433
3309818 MO     school 2929280 115115   ST. LOUIS CITY 292928002646 6030 WILKINSON EARLY CHILDHOOD CTR.   Regular School No Elementary PK 02 2017   k_12_total 48 91 * *   *       * *           *         *   32   145 48 91                                     32   145
3296849 MO     school 2930780 4109   VAN-FAR R-I 293078002125 4020 VAN-FAR ELEM.   Regular School No Elementary PK 06 2017   k_12_total 254 9 6 *   *       * 23           *         164   34   292 254 9 6               23                 164 34   292
3297130 MO     school 2906360 7129   BUTLER R-V 290636000158 1050 BUTLER HIGH   Regular School No High 07 12 2017   k_12_total 447 9 8 *   *       * 5           *         233.3   54   475 447 9 8               5                   54   475
3298169 MO     school 2915600 16090   JACKSON R-II 291560000739 4160 WEST LANE ELEM.   Regular School No Elementary 03 05 2017   k_12_total 473 9 11 *   *       * 22           *         218   52   518 473 9 11               22                 218 52   518
3298289 MO     school 2907380 17125   CARROLLTON R-VII 290738000202 1050 CARROLLTON SENIOR HIGH   Regular School No High 09 12 2017   k_12_total 261 9 6 *   *       * *           *         114   48   276 261 9 6                                 114 48   276
3298659 MO     school 2906030 21149   BRUNSWICK R-II 290603000144 4020 BRUNSWICK ELEM.   Regular School No Elementary PK 06 2017   k_12_total 111 9 * *   *       * 16           *         80   25   138 111 9                 16                 80 25   138
3298677 MO     school 2927520 21151   SALISBURY R-IV 292752001685 1050 SALISBURY HIGH   Regular School No High 07 12 2017   k_12_total 214 9 * *   *       * *           *         100.2   23   226 214 9                                     23   226
3299009 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000421 4080 WESTVIEW ELEMENTARY   Regular School No Elementary PK 05 2017   k_12_total 472 9 18 5   *       * 29           *         281   63   537 472 9 18 5             29                 281 63   537
3300661 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001794 4240 FIELD ELEM.   Regular School No Elementary KG 05 2017   k_12_total 370 9 15 *   6       * 13           5         106.3   35   414 370 9 15     6         13           5       35   414
3300679 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001797 4280 HICKORY HILLS ELEM.   Regular School No Elementary KG 05 2017   k_12_total 355 9 31 *   22       * 6           49         85   29   424 355 9 31     22         6           49     85 29   424
3300811 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001835 4800 WILDER ELEM.   Regular School No Elementary KG 05 2017   k_12_total 285 9 18 *   40       5 26           50         172   43   384 285 9 18     40       5 26           50     172 43   384
3301053 MO     school 2909860 42124   CLINTON 290986003145 4080 CLINTON INTERMEDIATE SCHOOL   Regular School No Elementary 03 05 2017   k_12_total 337 9 12 *   *       * 17           *         233   59   378 337 9 12               17                 233 59   378
3301195 MO     school 2912900 45078   GLASGOW 291290000540 1050 GLASGOW HIGH   Regular School No High 07 12 2017   k_12_total 142 9 * *   *       * *           *         60   32   161 142 9                                   60 32   161
3301303 MO     school 2928470 47060   SOUTH IRON CO. R-I 292847001759 1050 SOUTH IRON HIGH   Regular School No High 07 12 2017   k_12_total 113 9 6 *   *       * *           *         104   18   128 113 9 6                                 104 18   128
3301580 MO     school 2923010 48070   OAK GROVE R-VI 292301001316 4020 OAK GROVE ELEM.   Regular School No Elementary 03 05 2017   k_12_total 385 9 14 *   *       * 17           *         181   42   426 385 9 14               17                 181 42   426
3302894 MO     school 2922890 50001   NORTHWEST R-I 292289002378 3070 NORTHWEST VALLEY SCH.   Regular School No Middle 06 08 2017   k_12_total 779 9 14 *   5       * 12           *         311   126   822 779 9 14     5         12                 311 126   822
3302918 MO     school 2922890 50001   NORTHWEST R-I 292289001303 4060 HIGH RIDGE ELEM.   Regular School No Elementary KG 05 2017   k_12_total 452 9 6 *   *       * 10           *         231   74   479 452 9 6               10                 231 74   479
3302971 MO     school 2914430 50003   HILLSBORO R-III 291443000675 1050 HILLSBORO HIGH   Regular School No High 09 12 2017   k_12_total 1097 9 17 6   *       * *           *         327   122   1134 1097 9 17 6                               327 122   1134
3303113 MO     school 2912300 50012   FOX C-6 291230001981 1070 SECKMAN SR. HIGH   Regular School No High 09 12 2017   k_12_total 1659 9 28 5   15       * 38           *         365   242   1754 1659 9 28 5   15         38                 365 242   1754
3303475 MO     school 2914400 54039   LAFAYETTE CO. C-1 291440002596 3000 LAFAYETTE CO. MIDDLE   Regular School No Middle 06 08 2017   k_12_total 177 9 10 *   *       * 7           *         106   39   206 177 9 10               7                 106 39   206
3303505 MO     school 2923100 54041   ODESSA R-VII 292310001743 4060 ODESSA UPPER ELEM.   Regular School No Elementary 03 05 2017   k_12_total 472 9 * *   *       * *           *         253   52   486 472 9                                   253 52   486
3303785 MO     school 2932190 57004   WINFIELD R-IV 293219002257 1050 WINFIELD HIGH   Regular School No High 09 12 2017   k_12_total 439 9 8 *   *       * 11           *         188.3   52   469 439 9 8               11                   52   469
3303875 MO     school 2905940 58112   BROOKFIELD R-III 290594000137 4020 BROOKFIELD ELEM.   Regular School No Elementary PK 04 2017   k_12_total 346 9 * *   *       * 8           *         214   71   369 346 9                 8                 214 71   369
3303911 MO     school 2908760 59117   CHILLICOTHE R-II 290876000259 4020 CENTRAL ELEM.   Regular School No Elementary 04 05 2017   k_12_total 266 9 19 *   *       * 14           *         153   40   311 266 9 19               14                 153 40   311
3304329 MO     school 2911220 67055   EAST PRAIRIE R-II 291122000387 4040 R. A. DOYLE ELEM.   Regular School No Elementary PK 02 2017   k_12_total 249 9 * *   *       * 10           *         207   34   276 249 9                 10                 207 34   276
3305768 MO     school 2925710 87083   RALLS CO. R-II 292571001512 4040 RALLS COUNTY ELEMENTARY   Regular School No Elementary PK 05 2017   k_12_total 313 9 * *   *       * *           *         170   36   327 313 9                                   170 36   327
3305841 MO     school 2921100 88081   MOBERLY 292110001157 4060 NORTH PARK ELEM.   Regular School No Elementary KG 02 2017   k_12_total 201 9 6 *   *       * 30           *         153.3   40   249 201 9 6               30                   40   249
3306078 MO     school 2908370 92087   FT. ZUMWALT R-II 290837000237 4050 MOUNT HOPE ELEM.   Regular School No Elementary KG 05 2017   k_12_total 364 9 18 *   *       * 20           8         76   59   411 364 9 18               20           8     76 59   411
3307355 MO     school 2918690 96093   LINDBERGH SCHOOLS 291869002468 5070 CONCORD ELEM. SCHOOL   Regular School No Elementary KG 05 2017   k_12_total 558 9 26 *   33       * 30           53         69   111   659 558 9 26     33         30           53     69 111   659
3308220 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001608 4269 SOUTHVIEW   Regular School No Elementary KG 08 2017   k_12_total 74 9 * *   *       * *           *         30   *   87 74 9                                   30     87
3308883 MO     school 2914550 106005   HOLLISTER R-V 291455000683 4020 HOLLISTER ELEM.   Regular School No Elementary 02 05 2017   k_12_total 302 9 30 *   *       * 5           17         263   47   350 302 9 30               5           17     263 47   350
3309147 MO     school 2925500 110029   POTOSI R-III 292550001497 1050 POTOSI HIGH   Regular School No High 09 12 2017   k_12_total 671 9 9 *   *       * 14           *         *   121   706 671 9 9               14                   121   706
3310204 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203068 9049 NEW DAWN SCHOOL   Special Education School No Other KG 12 2017   k_12_total 22 9 * *   *       * *           *         12   *   34 22 9                                   12     34
3310392 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901273 1075 CAMP AVERY PARK CAMP   Regular School No Other 06 12 2017   k_12_total 13 9 * *   *       * *           *         *   9   22 13 9                                     9   22
3301434 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531002835 3090 PAUL KINDER MIDDLE SCHOOL   Regular School No Middle 06 08 2017   k_12_total 528 89 77 7   11       * 56           *         281   98   772 528 89 77 7   11         56                 281 98   772
3300601 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001818 3140 REED MIDDLE   Regular School No Middle 06 08 2017   k_12_total 502 88 24 6   6       * 28           5         495.1   89   658 502 88 24 6   6         28           5       89   658
3306199 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002698 3400 BRYAN MIDDLE   Regular School No Middle 06 08 2017   k_12_total 749 88 33 *   33       * 28           *         176   96   932 749 88 33     33         28                 176 96   932
3307124 MO     school 2926850 96091   ROCKWOOD R-VI 292685000706 3060 ROCKWOOD SOUTH MIDDLE   Regular School No Middle 06 08 2017   k_12_total 815 88 11 *   38       * 16           9         149   123   970 815 88 11     38         16           9     149 123   970
3301428 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531002736 3080 DELTA WOODS MIDDLE   Regular School No Middle 06 08 2017   k_12_total 566 87 76 6   44       * 36           *         165.1   66   815 566 87 76 6   44         36                   66   815
3305435 MO     school 2923550 83005   PARK HILL 292355001369 3050 PLAZA MIDDLE   Regular School No Middle 06 06 2017   k_12_total 562 87 84 *   27       13 31           18         225   87   807 562 87 84     27       13 31           18     225 87   807
3301351 MO     school 2912290 48066   FORT OSAGE R-I 291229000496 1050 FORT OSAGE HIGH   Regular School No High 09 12 2017   k_12_total 1108 86 125 14   18       31 27           10         730   153   1409 1108 86 125 14   18       31 27           10     730 153   1409
3302499 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001703259 6941 ACADEMIE LAFAYETTE-CHERRY   Regular School Yes Elementary KG 03 2017   k_12_total 307 86 18 *   6       * 45           10         108   22   464 307 86 18     6         45           10     108 22   464
3307262 MO     school 2916770 96092   KIRKWOOD R-VII 291677000923 3000 NIPHER MIDDLE   Regular School No Middle 06 08 2017   k_12_total 524 86 19 *   13       * 32           6         93   89   674 524 86 19     13         32           6     93 89   674
3299174 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001282 3180 NEW MARK MIDDLE   Regular School No Middle 06 08 2017   k_12_total 909 85 92 *   26       6 76           15         248   83   1197 909 85 92     26       6 76           15     248 83   1197
3304563 MO     school 2900003 72068   PORTAGEVILLE 290000302458 1050 PORTAGEVILLE HIGH   Regular School No Other 06 12 2017   k_12_total 261 85 5 *   *       * 7           *         219   40   361 261 85 5               7                 219 40   361
3306379 MO     school 2931650 92089   WENTZVILLE R-IV 293165003149 4120 LAKEVIEW ELEMENTARY   Regular School No Elementary KG 05 2017   k_12_total 620 85 40 *   6       * 58           6         251   96   811 620 85 40     6         58           6     251 96   811
3301748 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003156 1050 RUSKIN HIGH SCHOOL   Regular School No High 10 12 2017   k_12_total 114 836 94 *   12       * 18           23         *   160   1078 114 836 94     12         18           23       160   1078
3301416 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000943 3000 BRITTANY HILL MIDDLE   Regular School No Middle 06 08 2017   k_12_total 598 83 90 *   23       * 50           *         257   102   848 598 83 90     23         50                 257 102   848
3302068 MO     school 2915480 48077   INDEPENDENCE 30 291548003107 5100 KORTE ELEM.   Regular School No Elementary PK 05 2017   k_12_total 267 83 174 *   *       * 56           88         478   45   583 267 83 174               56           88     478 45   583
3306307 MO     school 2931650 92089   WENTZVILLE R-IV 293165001036 3030 WENTZVILLE SOUTH MIDDLE   Regular School No Middle 06 08 2017   k_12_total 1095 83 55 *   14       * 44           17         252   159   1294 1095 83 55     14         44           17     252 159   1294
3301472 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000078 4080 CORDILL-MASON ELEM.   Regular School No Elementary PK 05 2017   k_12_total 556 82 51 *   9       * 54           *         191   65   757 556 82 51     9         54                 191 65   757
3306241 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002681 5010 HARVEST RIDGE ELEM.   Regular School No Elementary KG 05 2017   k_12_total 418 82 64 *   84       * 54           65         240   63   704 418 82 64     84         54           65     240 63   704
3307268 MO     school 2916770 96092   KIRKWOOD R-VII 291677000925 3025 NORTH KIRKWOOD MIDDLE   Regular School No Middle 06 08 2017   k_12_total 524 82 23 *   12       * 31           *         73   103   675 524 82 23     12         31                 73 103   675
3300547 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001804 1085 KICKAPOO HIGH   Regular School No High 09 12 2017   k_12_total 1538 81 70 8   53       * 30           10         403.4   106   1782 1538 81 70 8   53         30           10       106   1782
3301393 MO     school 2912290 48066   FORT OSAGE R-I 291229003103 4130 INDIAN TRAILS ELEM.   Regular School No Elementary PK 04 2017   k_12_total 269 81 35 *   5       13 9           10         240   27   412 269 81 35     5       13 9           10     240 27   412
3305151 MO     school 2927830 80125   SEDALIA 200 292783001709 1050 SMITH-COTTON HIGH SCHOOL   Regular School No High 09 12 2017   k_12_total 1088 81 237 6   14       * 57           71         772   155   1483 1088 81 237 6   14         57           71     772 155   1483
3297486 MO     school 2901000 10093   COLUMBIA 93 290100002770 5010 MARY PAXTON KEELEY ELEM.   Regular School No Elementary PK 05 2017   k_12_total 422 80 39 *   86       * 64           119         198   61   691 422 80 39     86         64           119     198 61   691
3298421 MO     school 2923730 19142   RAYMORE-PECULIAR R-II 292373002913 4090 CREEKMOOR ELEM.   Regular School No Elementary KG 04 2017   k_12_total 361 80 23 *   5       * 39           *         109.2   28   508 361 80 23     5         39                   28   508
3300559 MO     school 2928860 39141   SPRINGFIELD R-XII 292886000901 3000 CARVER MIDDLE   Regular School No Middle 06 08 2017   k_12_total 556 80 64 *   42       * 29           53         431.1   110   778 556 80 64     42         29           53       110   778
3302569 MO     school 2900597 48924   EWING MARION KAUFFMAN SCHOOL 290059703277 1910 EWING MARION KAUFFMAN HIGH   Regular School Yes Other 09 10 2017   k_12_total * 80 16 *   6       * *           *         81   *   103   80 16     6                           81     103
3305024 MO     school 2928530 78005   SOUTH PEMISCOT CO. R-V 292853002670 4020 SOUTH PEMISCOT ELEM.   Regular School No Elementary KG 06 2017   k_12_total 223 80 14 *   *       * 21           *         *   79   342 223 80 14               21                   79   342
3306018 MO     school 2908370 92087   FT. ZUMWALT R-II 290837002490 1075 FT. ZUMWALT SOUTH HIGH   Regular School No High 09 12 2017   k_12_total 1174 80 39 *   54       5 33           10         156.2   143   1386 1174 80 39     54       5 33           10       143   1386
3308106 MO     school 2930690 96113   VALLEY PARK 293069002115 4020 VALLEY PARK ELEM.   Regular School No Elementary PK 05 2017   k_12_total 247 80 23 *   15       * 28           27         154   46   393 247 80 23     15         28           27     154 46   393
3297556 MO     school 2901000 10093   COLUMBIA 93 290100000314 6040 TWO MILE PRAIRIE ELEM.   Regular School No Elementary KG 05 2017   k_12_total 148 8 9 *   *       * 8           *         71   15   177 148 8 9               8                 71 15   177
3297912 MO     school 2905820 13061   BRAYMER C-4 290582000126 4020 BRAYMER ELEM.   Regular School No Elementary PK 06 2017   k_12_total 161 8 * *   *       * *           *         88   27   169 161 8                                   88 27   169
3298014 MO     school 2900020 14400   MO SCHOOL FOR THE DEAF 290002003021 1050 WHEELER HIGH   Special Education School No High 09 12 2017   k_12_total 15 8 * *   *       * *           *         *   *   26 15 8                                         26
3298134 MO     school 2915600 16090   JACKSON R-II 291560000732 4015 ORCHARD DRIVE ELEM.   Regular School No Elementary KG 02 2017   k_12_total 385 8 9 *   *       * 17           *         184   41   420 385 8 9               17                 184 41   420
3298653 MO     school 2906030 21149   BRUNSWICK R-II 290603000145 1050 BRUNSWICK HIGH   Regular School No High 07 12 2017   k_12_total 94 8 * *   *       * 10           *         61   32   112 94 8                 10                 61 32   112
3299367 MO     school 2925290 25003   CLINTON CO. R-III 292529000846 3000 CLINTON CO. R-III MIDDLE   Regular School No Middle 06 08 2017   k_12_total 116 8 * *   *       * 5           *         65   30   134 116 8                 5                 65 30   134

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