Data source: Big Local News · About: Big Local

257,968 rows where state = "MO" sorted by black descending

View and edit SQL

grade

year

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
3304561 MO     school 2900003 72068   PORTAGEVILLE 290000302458 1050 PORTAGEVILLE HIGH   Regular School No 4 06 12 2015   k_12_total 292 94 * *   *       * 5           *         235   49   397 292 94                 5                 235 49   397
3305047 MO     school 2907470 78012   CARUTHERSVILLE 18 290747001023 3000 CARUTHERSVILLE MIDDLE   Regular School No 2 06 08 2016   k_12_total 115 94 5 *   *       * 5           *         *   32   219 115 94 5               5                   32   219
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
3305468 MO     school 2923550 83005   PARK HILL 292355001372 5000 SOUTHEAST ELEM.   Regular School No Elementary KG 05 2019   k_12_total 316 94 53 5   7       9 43           61         178   45   527 316 94 53 5   7       9 43           61     178 45   527
3306400 MO     school 2928920 92090   ST. CHARLES R-VI 292892001851 1075 ST. CHARLES WEST HIGH   Regular School No High 09 12 2020   k_12_total 446 94 71 *   14       * 29           22         188   98   655 446 94 71     14         29           22     188 98   655
3306402 MO     school 2928920 92090   ST. CHARLES R-VI 292892001850 3000 HARDIN MIDDLE   Regular School No 2 07 08 2016   k_12_total 556 94 30 *   14       * 5           29         309   122   702 556 94 30     14         5           29     309 122   702
3307122 MO     school 2926850 96091   ROCKWOOD R-VI 292685000706 3060 ROCKWOOD SOUTH MIDDLE   Regular School No 2 06 08 2015   k_12_total 745 94 29 *   44       * 15           7         168   146   929 745 94 29     44         15           7     168 146   929
3307261 MO     school 2916770 96092   KIRKWOOD R-VII 291677000923 3000 NIPHER MIDDLE   Regular School No 2 06 08 2016   k_12_total 504 94 20 *   18       * 23           5         103   72   659 504 94 20     18         23           5     103 72   659
3307285 MO     school 2916770 96092   KIRKWOOD R-VII 291677000921 5060 GEORGE R. ROBINSON ELEM.   Regular School No 1 KG 05 2016   k_12_total 344 94 13 *   8       * 32           *         126   64   491 344 94 13     8         32                 126 64   491
3307531 MO     school 2923580 96095   PARKWAY C-2 292358001376 4030 BELLERIVE ELEM.   Regular School No Elementary KG 05 2018   k_12_total 197 94 13 *   49       * 24           21         91   92   379 197 94 13     49         24           21     91 92   379
3297422 MO     school 2901000 10093   COLUMBIA 93 290100000841 3000 ANN HAWKINS GENTRY MIDDLE   Regular School No Middle 06 08 2018   k_12_total 663 93 38 6   52       * 43           13         211   68   898 663 93 38 6   52         43           13     211 68   898
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
3297517 MO     school 2901000 10093   COLUMBIA 93 290100000307 5040 PARKADE ELEM.   Regular School No Elementary PK 05 2018   k_12_total 242 93 28 *   11       * 50           21         264   52   428 242 93 28     11         50           21     264 52   428
3297771 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001469 2050 POPLAR BLUFF JR. HIGH   Regular School No 2 07 08 2016   k_12_total 641 93 15 7   *       * 14           6         469   117   772 641 93 15 7             14           6     469 117   772
3297774 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001469 2050 POPLAR BLUFF JR. HIGH   Regular School No Middle 07 08 2019   k_12_total 626 93 18 5   *       * 23           *         471.1   131   768 626 93 18 5             23                   131   768
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
3300590 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001813 3100 PIPKIN MIDDLE   Regular School No Middle 06 08 2018   k_12_total 405 93 47 *   9       * 41           11         437.3   80   598 405 93 47     9         41           11       80   598
3302208 MO     school 2916400 48078   KANSAS CITY 33 291640003257 4270 HALE COOK ELEMENTARY   Regular School No Elementary PK 06 2019   k_12_total 156 93 22 *   5       * 17           10         *   23   296 156 93 22     5         17           10       23   296
3302209 MO     school 2916400 48078   KANSAS CITY 33 291640003257 4270 HALE COOK ELEMENTARY   Regular School No Elementary PK 06 2020   k_12_total 161 93 21 *   5       11 14           6         *   24   305 161 93 21     5       11 14           6       24   305
3304594 MO     school 2900004 72074   NEW MADRID CO. R-I 290000401991 3000 CENTRAL MIDDLE   Regular School No Middle 06 08 2018   k_12_total 201 93 10 *   *       * 6           5         222   62   310 201 93 10               6           5     222 62   310
3306010 MO     school 2908370 92087   FT. ZUMWALT R-II 290837000239 1050 FT. ZUMWALT NORTH HIGH   Regular School No 3 09 12 2015   k_12_total 1240 93 45 5   25       * 14           12         241   220   1423 1240 93 45 5   25         14           12     241 220   1423
3307054 MO     school 2923700 96090   PATTONVILLE R-III 292370001419 6000 TRADITIONAL SCH.   Regular School No Elementary KG 08 2019   k_12_total 220 93 37 *   22       * 23           29         86   69   397 220 93 37     22         23           29     86 69   397
3307669 MO     school 2904500 96099   BAYLESS 290450000043 4020 BAYLESS ELEMENTARY   Regular School No 1 PK 05 2016   k_12_total 556 93 35 *   81       * 23           233         517   129   788 556 93 35     81         23           233     517 129   788
3308433 MO     school 2928260 100063   SIKESTON R-6 292826001738 4020 SIKESTON KINDERGARTEN CTR.   Regular School No 1 PK KG 2015   k_12_total 153 93 14 *   *       * 22           *         222   25   286 153 93 14               22                 222 25   286
3309445 MO     school 2929280 115115   ST. LOUIS CITY 292928003231 1510 COLLEGIATE SCHOOL OF MED/BIO   Regular School No 4 09 11 2016   k_12_total 48 93 8 *   24       * *           *         *   *   174 48 93 8     24                                 174
3309571 MO     school 2929280 115115   ST. LOUIS CITY 292928001889 4200 BUDER ELEM.   Regular School No Elementary PK 05 2018   k_12_total 182 93 21 *   6       * *           127         *   86   303 182 93 21     6                     127       86   303
3309573 MO     school 2929280 115115   ST. LOUIS CITY 292928001889 4200 BUDER ELEM.   Regular School No Elementary PK 05 2020   k_12_total 136 93 34 *   30       * *           118         *   68   293 136 93 34     30                     118       68   293
3309714 MO     school 2929280 115115   ST. LOUIS CITY 292928001967 5240 MALLINCKRODT A.B.I. ELEM.   Regular School No 1 PK 05 2015   k_12_total 132 93 8 *   8       * *           12         *   18   241 132 93 8     8                     12       18   241
3310049 MO     school 2900614 115930   THE ARCH COMMUNITY SCHOOL 290061403302 6905 THE ARCH COMMUNITY SCHOOL   Regular School Yes Elementary KG 05 2020   k_12_total * 93 * *   *       * *           *         87   21   99   93                                   87 21   99
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
3297542 MO     school 2901000 10093   COLUMBIA 93 290100000312 6010 SHEPARD BLVD. ELEM.   Regular School No 1 PK 05 2015   k_12_total 359 92 38 *   26       * 41           47         253   49   561 359 92 38     26         41           47     253 49   561
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
3298378 MO     school 2923730 19142   RAYMORE-PECULIAR R-II 292373000088 3000 RAYMORE-PECULIAR EAST MIDDLE   Regular School No 2 07 08 2016   k_12_total 774 92 39 *   14       * 27           *         237   83   954 774 92 39     14         27                 237 83   954
3299295 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001291 4560 TOPPING ELEM.   Regular School No 1 PK 05 2016   k_12_total 152 92 55 *   10       * 20           66         230   34   333 152 92 55     10         20           66     230 34   333
3302012 MO     school 2915480 48077   INDEPENDENCE 30 291548003090 3060 CLIFFORD H. NOWLIN MIDDLE   Regular School No 2 06 08 2016   k_12_total 450 92 233 *   *       * 61           79         704.4   104   844 450 92 233               61           79       104   844
3302560 MO     school 2900590 48922   FRONTIER SCHOOLS 290059003127 6975 FRONTIER SCHOOL OF INNOVATION   Regular School Yes Elementary PK 05 2019   k_12_total 53 92 499 *   9       * *           445         *   36   653 53 92 499     9                     445       36   653
3304173 MO     school 2913650 64075   HANNIBAL 60 291365002554 3000 HANNIBAL MIDDLE   Regular School No Middle 06 08 2020   k_12_total 702 92 19 *   *       * 53           *         506.4   161   872 702 92 19               53                   161   872
3304591 MO     school 2900004 72074   NEW MADRID CO. R-I 290000401991 3000 CENTRAL MIDDLE   Regular School No 2 06 08 2015   k_12_total 206 92 7 *   *       * *           *         221   66   309 206 92 7                                 221 66   309
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
3305436 MO     school 2923550 83005   PARK HILL 292355001369 3050 PLAZA MIDDLE   Regular School No Middle 06 06 2018   k_12_total 604 92 90 6   25       8 49           27         242   83   874 604 92 90 6   25       8 49           27     242 83   874
3305494 MO     school 2923550 83005   PARK HILL 292355003221 5090 TIFFANY RIDGE ELEMENTARY SCHL   Regular School No 1 KG 05 2015   k_12_total 301 92 65 *   33       12 44           66         212   38   549 301 92 65     33       12 44           66     212 38   549
3305500 MO     school 2923550 83005   PARK HILL 292355003368 5095 HOPEWELL ELEMENTARY   Regular School No Elementary KG 05 2020   k_12_total 300 92 39 *   10       * 28           37         144   30   472 300 92 39     10         28           37     144 30   472
3306011 MO     school 2908370 92087   FT. ZUMWALT R-II 290837000239 1050 FT. ZUMWALT NORTH HIGH   Regular School No 3 09 12 2016   k_12_total 1267 92 44 *   21       * 28           12         279   224   1454 1267 92 44     21         28           12     279 224   1454
3307110 MO     school 2926850 96091   ROCKWOOD R-VI 292685000671 3040 LASALLE SPRINGS MIDDLE   Regular School No 2 06 08 2015   k_12_total 754 92 19 *   21       * 13           9         143   169   907 754 92 19     21         13           9     143 169   907
3307123 MO     school 2926850 96091   ROCKWOOD R-VI 292685000706 3060 ROCKWOOD SOUTH MIDDLE   Regular School No 2 06 08 2016   k_12_total 803 92 19 *   40       * 17           6         158   147   973 803 92 19     40         17           6     158 147   973
3307587 MO     school 2923580 96095   PARKWAY C-2 292358001391 4180 MCKELVEY ELEM.   Regular School No Elementary KG 05 2020   k_12_total 200 92 40 8   298       * 38           123         88   88   676 200 92 40 8   298         38           123     88 88   676
3297515 MO     school 2901000 10093   COLUMBIA 93 290100000307 5040 PARKADE ELEM.   Regular School No 1 PK 05 2016   k_12_total 223 91 24 *   6       * 54           5         244   50   403 223 91 24     6         54           5     244 50   403
3297543 MO     school 2901000 10093   COLUMBIA 93 290100000312 6010 SHEPARD BLVD. ELEM.   Regular School No 1 PK 05 2016   k_12_total 323 91 30 *   18       * 53           42         269   41   520 323 91 30     18         53           42     269 41   520
3297627 MO     school 2927060 11082   ST. JOSEPH 292706001660 1080 LAFAYETTE HIGH   Regular School No High 09 12 2018   k_12_total 579 91 46 *   *       11 35           23         448   118   768 579 91 46             11 35           23     448 118   768
3297628 MO     school 2927060 11082   ST. JOSEPH 292706001660 1080 LAFAYETTE HIGH   Regular School No High 09 12 2019   k_12_total 566 91 53 *   *       12 47           38         483   114   775 566 91 53             12 47           38     483 114   775
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
3304169 MO     school 2913650 64075   HANNIBAL 60 291365002554 3000 HANNIBAL MIDDLE   Regular School No 2 06 08 2016   k_12_total 658 91 19 *   7       * 21           *         471   118   798 658 91 19     7         21                 471 118   798
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
3307125 MO     school 2926850 96091   ROCKWOOD R-VI 292685000706 3060 ROCKWOOD SOUTH MIDDLE   Regular School No Middle 06 08 2018   k_12_total 788 91 21 *   38       * 21           9         160   125   960 788 91 21     38         21           9     160 125   960
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
3307529 MO     school 2923580 96095   PARKWAY C-2 292358001376 4030 BELLERIVE ELEM.   Regular School No 1 PK 05 2016   k_12_total 183 91 16 *   51       * 22           22         87   86   364 183 91 16     51         22           22     87 86   364
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
3309424 MO     school 2929280 115115   ST. LOUIS CITY 292928001926 1222 COMMUNITY ACCESS JOB TRAINING   Regular School No High 08 12 2019   k_12_total 20 91 8 *   *       * *           10         *   *   122 20 91 8                           10           122
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
3309897 MO     school 2900585 115911   CITY GARDEN MONTESSORI 290058503101 6955 CITY GARDEN MONTESSORI SCHOOL   Regular School Yes Elementary PK 08 2018   k_12_total 116 91 12 *   *       * 6           *         89   33   227 116 91 12               6                 89 33   227
3309899 MO     school 2900585 115911   CITY GARDEN MONTESSORI 290058503101 6955 CITY GARDEN MONTESSORI SCHOOL   Regular School Yes Elementary PK 08 2020   k_12_total 100 91 9 *   *       * 15           *         *   25   216 100 91 9               15                   25   216
3297423 MO     school 2901000 10093   COLUMBIA 93 290100000841 3000 ANN HAWKINS GENTRY MIDDLE   Regular School No Middle 06 08 2019   k_12_total 697 90 34 *   53       * 47           15         195.3   70   927 697 90 34     53         47           15       70   927
3298228 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712000188 4060 CLIPPARD ELEM.   Regular School No 1 PK 04 2016   k_12_total 201 90 33 *   6       * 33           39         234   42   363 201 90 33     6         33           39     234 42   363
3298380 MO     school 2923730 19142   RAYMORE-PECULIAR R-II 292373000088 3000 RAYMORE-PECULIAR EAST MIDDLE   Regular School No Middle 06 08 2018   k_12_total 607 90 50 *   5       * 52           *         202   76   804 607 90 50     5         52                 202 76   804
3299208 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001263 4100 CHOUTEAU ELEM.   Regular School No Elementary PK 05 2019   k_12_total 143 90 54 *   10       * 37           78         268   37   337 143 90 54     10         37           78     268 37   337
3299469 MO     school 2916190 26006   JEFFERSON CITY 291619002494 4050 CLARENCE LAWSON ELEM.   Regular School No 1 KG 05 2016   k_12_total 327 90 34 *   11       * 41           11         264   99   503 327 90 34     11         41           11     264 99   503
3301415 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000943 3000 BRITTANY HILL MIDDLE   Regular School No 2 06 08 2016   k_12_total 618 90 60 7   28       * 30           *         262   90   835 618 90 60 7   28         30                 262 90   835
3302000 MO     school 2915480 48077   INDEPENDENCE 30 291548002339 3000 BINGHAM MIDDLE   Regular School No 2 07 08 2016   k_12_total 549 90 121 *   5       11 71           17         632   93   851 549 90 121     5       11 71           17     632 93   851
3302006 MO     school 2915480 48077   INDEPENDENCE 30 291548000709 3050 BRIDGER MIDDLE   Regular School No 2 06 06 2016   k_12_total 498 90 114 *   9       10 46           20         519   98   770 498 90 114     9       10 46           20     519 98   770
3302378 MO     school 2908250 48080   CENTER 58 290825000228 4080 RED BRIDGE ELEM.   Regular School No 1 KG 05 2016   k_12_total 118 90 37 *   8       * 21           32         136   24   275 118 90 37     8         21           32     136 24   275
3302797 MO     school 2916350 49148   JOPLIN SCHOOLS 291635000787 1050 JOPLIN HIGH   Regular School No High 09 12 2020   k_12_total 1671 90 187 37   34       30 133           39         1091   347   2182 1671 90 187 37   34       30 133           39     1091 347   2182
3305376 MO     school 2925230 83003   PLATTE CO. R-III 292523001456 1050 PLATTE COUNTY HIGH   Regular School No High 09 12 2020   k_12_total 1004 90 99 *   29       9 39           19         201   104   1271 1004 90 99     29       9 39           19     201 104   1271
3306239 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002681 5010 HARVEST RIDGE ELEM.   Regular School No 1 KG 05 2015   k_12_total 435 90 64 *   83       * 47           80         272   71   720 435 90 64     83         47           80     272 71   720
3307287 MO     school 2916770 96092   KIRKWOOD R-VII 291677000921 5060 GEORGE R. ROBINSON ELEM.   Regular School No Elementary KG 05 2018   k_12_total 367 90 21 *   11       * 48           5         136   70   537 367 90 21     11         48           5     136 70   537
3307637 MO     school 2902910 96098   AFFTON 101 290291000009 1050 AFFTON HIGH   Regular School No High 09 12 2020   k_12_total 582 90 41 *   14       * 47           36         248.4   108   774 582 90 41     14         47           36       108   774
3296781 MO     school 2927570 2097   SAVANNAH R-III 292757001692 4040 MINNIE CLINE ELEM.   Regular School No 1 KG 05 2015   k_12_total 532 9 18 *   *       * *           *         264   89   566 532 9 18                                 264 89   566
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
3296976 MO     school 2921120 5128   MONETT R-I 292112001162 1050 MONETT HIGH   Regular School No High 09 12 2019   k_12_total 419 9 276 *   24       * 15           83         377   90   745 419 9 276     24         15           83     377 90   745
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
3297134 MO     school 2906360 7129   BUTLER R-V 290636000157 4020 BUTLER ELEM.   Regular School No 1 PK 06 2015   k_12_total 539 9 14 *   *       * 12           *         344   85   577 539 9 14               12                 344 85   577
3297293 MO     school 2913560 10089   HALLSVILLE R-IV 291356001597 3000 HALLSVILLE MIDDLE   Regular School No 2 06 08 2015   k_12_total 302 9 10 *   *       * 6           *         116   31   327 302 9 10               6                 116 31   327
3297309 MO     school 2913560 10089   HALLSVILLE R-IV 291356002975 4040 HALLSVILLE PRIMARY   Regular School No Elementary PK 01 2019   k_12_total 188 9 10 *   7       * 15           *         70   22   230 188 9 10     7         15                 70 22   230
3297707 MO     school 2927060 11082   ST. JOSEPH 292706001661 4240 LAKE ELEM.   Regular School No 1 PK 06 2016   k_12_total 224 9 38 *   *       * 16           34         263   67   290 224 9 38               16           34     263 67   290
3297733 MO     school 2927060 11082   ST. JOSEPH 292706001668 4400 PERSHING ELEM.   Regular School No Elementary KG 06 2020   k_12_total 226 9 18 *   *       * 27           18         149   42   284 226 9 18               27           18     149 42   284
3297971 MO     school 2912550 14129   FULTON 58 291255000517 4010 BARTLEY ELEM.   Regular School No 1 KG 05 2016   k_12_total 230 9 7 *   *       * 29           *         144   49   275 230 9 7               29                 144 49   275
3298065 MO     school 2906990 15002   CAMDENTON R-III 290699000171 4020 DOGWOOD ELEMENTARY   Regular School No Elementary PK 02 2020   k_12_total 528 9 36 *   *       * 12           14         331   89   588 528 9 36               12           14     331 89   588
3298067 MO     school 2906990 15002   CAMDENTON R-III 290699002580 4030 OAK RIDGE INTERMEDIATE   Regular School No 2 05 06 2016   k_12_total 575 9 34 6   *       * *           10         369   70   629 575 9 34 6                         10     369 70   629
3298087 MO     school 2906990 15002   CAMDENTON R-III 290699000174 4080 OSAGE BEACH ELEM.   Regular School No Elementary PK 04 2018   k_12_total 212 9 50 *   *       * 11           47         141   29   285 212 9 50               11           47     141 29   285
3298136 MO     school 2915600 16090   JACKSON R-II 291560000732 4015 ORCHARD DRIVE ELEM.   Regular School No Elementary KG 04 2019   k_12_total 357 9 11 *   *       * 15           *         219   39   393 357 9 11               15                 219 39   393
3298161 MO     school 2915600 16090   JACKSON R-II 291560002248 4130 SOUTH ELEM.   Regular School No Elementary KG 04 2020   k_12_total 343 9 19 *   *       * 11           15         195   69   387 343 9 19               11           15     195 69   387
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
3298294 MO     school 2907380 17125   CARROLLTON R-VII 290738000311 3000 MIDDLE SCHOOL   Regular School No 2 05 08 2016   k_12_total 237 9 * *   *       * *           *         122   41   249 237 9                                   122 41   249
3298353 MO     school 2903200 19139   ARCHIE R-V 290320000025 1050 ARCHIE HIGH   Regular School No 4 06 12 2015   k_12_total 295 9 6 *   *       * *           *         70.3   28   314 295 9 6                                   28   314
3298354 MO     school 2903200 19139   ARCHIE R-V 290320000025 1050 ARCHIE HIGH   Regular School No 4 06 12 2016   k_12_total 286 9 5 *   *       * *           *         75   30   304 286 9 5                                 75 30   304
3298494 MO     school 2913760 19149   HARRISONVILLE R-IX 291376000605 1050 HARRISONVILLE HIGH   Regular School No 3 09 12 2016   k_12_total 822 9 27 7   8       * 10           6         274   62   884 822 9 27 7   8         10           6     274 62   884
3298560 MO     school 2904620 19152   BELTON 124 290462000051 4020 CAMBRIDGE ELEM.   Regular School No 1 KG 04 2016   k_12_total 218 9 71 *   *       * 18           35         198   39   318 218 9 71               18           35     198 39   318
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

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