Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2018 · 36,896
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black ▲ hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
3302002 MO     school 2915480 48077   INDEPENDENCE 30 291548002339 3000 BINGHAM MIDDLE   Regular School No Middle 07 08 2018   k_12_total 481 99 126 7   8       12 63           24         601   105   796 481 99 126 7   8       12 63           24     601 105   796
3304588 MO     school 2900004 72074   NEW MADRID CO. R-I 290000401488 1060 CENTRAL HIGH   Regular School No High 09 12 2018   k_12_total 244 99 10 *   *       * 10           *         212   60   363 244 99 10               10                 212 60   363
3310020 MO     school 2900605 115923   EAGLE COLLEGE PREP ENDEAVOR 290060503304 6998 EAGLE GRAVOIS PARK   Regular School Yes Elementary KG 04 2018   k_12_total * 99 * *   *       * 7           *         *   10   112   99                 7                   10   112
3307671 MO     school 2904500 96099   BAYLESS 290450000043 4020 BAYLESS ELEMENTARY   Regular School No Elementary PK 05 2018   k_12_total 545 98 38 *   97       * 34           255         534   133   812 545 98 38     97         34           255     534 133   812
3306874 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201000472 1050 MCCLUER HIGH   Regular School No High 09 12 2018   k_12_total 57 970 25 *   6       * 27           17         *   193   1086 57 970 25     6         27           17       193   1086
3299175 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001282 3180 NEW MARK MIDDLE   Regular School No Middle 06 08 2018   k_12_total 885 97 122 *   26       * 103           14         276   93   1237 885 97 122     26         103           14     276 93   1237
3302020 MO     school 2915480 48077   INDEPENDENCE 30 291548002807 3070 PIONEER RIDGE MIDDLE   Regular School No Middle 07 08 2018   k_12_total 458 97 144 *   11       8 51           39         424   83   770 458 97 144     11       8 51           39     424 83   770
3302207 MO     school 2916400 48078   KANSAS CITY 33 291640003257 4270 HALE COOK ELEMENTARY   Regular School No Elementary PK 05 2018   k_12_total 141 97 20 *   *       * 18           11         *   30   280 141 97 20               18           11       30   280
3305374 MO     school 2925230 83003   PLATTE CO. R-III 292523001456 1050 PLATTE COUNTY HIGH   Regular School No High 09 12 2018   k_12_total 970 97 76 *   22       8 32           21         221   89   1206 970 97 76     22       8 32           21     221 89   1206
3309977 MO     school 2900592 115916   GATEWAY SCIENCE ACAD/ST LOUIS 290059203241 6997 GATEWAY SCIENCE ACAD-SOUTH ELE   Regular School Yes Elementary KG 05 2018   k_12_total 248 97 29 *   11       * 37           79         283   47   423 248 97 29     11         37           79     283 47   423
3297404 MO     school 2901000 10093   COLUMBIA 93 290100000304 2050 JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 08 2018   k_12_total 403 96 47 *   31       * 37           33         252   53   617 403 96 47     31         37           33     252 53   617
3301423 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531001706 3060 MORELAND RIDGE MIDDLE   Regular School No Middle 06 08 2018   k_12_total 742 95 57 5   16       * 74           *         309   122   993 742 95 57 5   16         74                 309 122   993
3302559 MO     school 2900590 48922   FRONTIER SCHOOLS 290059003127 6975 FRONTIER SCHOOL OF INNOVATION   Regular School Yes Elementary KG 05 2018   k_12_total 53 95 528 *   11       * *           473         *   38   687 53 95 528     11                     473       38   687
3307710 MO     school 2909720 96102   CLAYTON 290972002584 3000 WYDOWN MIDDLE   Regular School No Middle 06 08 2018   k_12_total 428 95 26 *   81       * 26           10         63   85   657 428 95 26     81         26           10     63 85   657
3299155 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001258 3000 ANTIOCH MIDDLE   Regular School No Middle 06 08 2018   k_12_total 600 94 139 *   25       13 87           14         458   99   959 600 94 139     25       13 87           14     458 99   959
3299261 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001277 4380 LINDEN WEST ELEM.   Regular School No Elementary PK 05 2018   k_12_total 234 94 79 *   7       22 58           65         320   36   495 234 94 79     7       22 58           65     320 36   495
3301352 MO     school 2912290 48066   FORT OSAGE R-I 291229000496 1050 FORT OSAGE HIGH   Regular School No High 09 12 2018   k_12_total 1154 94 136 11   22       24 40           13         695   159   1481 1154 94 136 11   22       24 40           13     695 159   1481
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
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
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
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
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
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
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
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
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
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
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
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
3298678 MO     school 2927520 21151   SALISBURY R-IV 292752001685 1050 SALISBURY HIGH   Regular School No High 07 12 2018   k_12_total 227 9 * *   *       * *           *         99.2   28   239 227 9                                     28   239
3298684 MO     school 2927520 21151   SALISBURY R-IV 292752001683 4040 SALISBURY ELEM.   Regular School No Elementary PK 06 2018   k_12_total 231 9 * *   *       * *           *         108   28   245 231 9                                   108 28   245
3300059 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346001359 4040 ZITZMAN ELEM.   Regular School No Elementary KG 05 2018   k_12_total 402 9 30 *   7       * 20           18         247   81   473 402 9 30     7         20           18     247 81   473
3301048 MO     school 2909860 42124   CLINTON 290986000289 4070 HENRY ELEM.   Regular School No Elementary KG 02 2018   k_12_total 333 9 11 *   *       * 12           *         251   72   365 333 9 11               12                 251 72   365
3301054 MO     school 2909860 42124   CLINTON 290986003145 4080 CLINTON INTERMEDIATE SCHOOL   Regular School No Elementary 03 05 2018   k_12_total 373 9 18 *   *       * 17           *         259   69   419 373 9 18               17                 259 69   419
3301310 MO     school 2928470 47060   SOUTH IRON CO. R-I 292847001758 4020 SOUTH IRON ELEM.   Regular School No Elementary PK 06 2018   k_12_total 152 9 * *   *       * *           *         124   33   162 152 9                                   124 33   162
3301533 MO     school 2913080 48069   GRAIN VALLEY R-V 291308003161 3010 GRAIN VALLEY NORTH MIDDLE SCHL   Regular School No Middle 06 08 2018   k_12_total 339 9 34 *   *       * 19           *         85   33   406 339 9 34               19                 85 33   406
3301972 MO     school 2919230 48075   LONE JACK C-6 291923001040 1050 LONE JACK HIGH   Regular School No High 07 12 2018   k_12_total 275 9 8 *   7       * *           *         50   33   302 275 9 8     7                           50 33   302
3302879 MO     school 2916350 49148   JOPLIN SCHOOLS 291635000793 4360 WEST CENTRAL ELEM.   Regular School No Elementary KG 05 2018   k_12_total 160 9 23 *   *       * 29           7         204   55   226 160 9 23               29           7     204 55   226
3302937 MO     school 2922890 50001   NORTHWEST R-I 292289001301 5020 BRENNAN WOODS ELEM.   Regular School No Elementary KG 05 2018   k_12_total 486 9 14 *   9       * 20           26         217   45   539 486 9 14     9         20           26     217 45   539
3302972 MO     school 2914430 50003   HILLSBORO R-III 291443000675 1050 HILLSBORO HIGH   Regular School No High 09 12 2018   k_12_total 1072 9 16 6   *       * 7           *         304   128   1112 1072 9 16 6             7                 304 128   1112
3303045 MO     school 2916230 50007   JEFFERSON CO. R-VII 291623003144 1050 JEFFERSON HIGH SCHOOL   Regular School No High 09 12 2018   k_12_total 270 9 * *   *       * 5           *         64   26   289 270 9                 5                 64 26   289
3303174 MO     school 2912300 50012   FOX C-6 291230000501 4060 MERAMEC HEIGHTS ELEM.   Regular School No Elementary KG 05 2018   k_12_total 488 9 23 *   *       * 11           10         248   103   535 488 9 23               11           10     248 103   535
3303227 MO     school 2910500 50014   DESOTO 73 291050000350 1050 DESOTO SR. HIGH   Regular School No High 09 12 2018   k_12_total 947 9 8 *   *       * *           *         343   149   972 947 9 8                                 343 149   972
3303476 MO     school 2914400 54039   LAFAYETTE CO. C-1 291440002596 3000 LAFAYETTE CO. MIDDLE   Regular School No Middle 06 08 2018   k_12_total 181 9 12 *   *       * 8           *         111   36   212 181 9 12               8                 111 36   212
3303500 MO     school 2923100 54041   ODESSA R-VII 292310001323 4040 MCQUERRY ELEM.   Regular School No Elementary PK 02 2018   k_12_total 401 9 8 5   *       * 24           *         228   53   451 401 9 8 5             24                 228 53   451
3303560 MO     school 2921000 55104   MILLER R-II 292100001146 4020 CENTRAL ELEM.   Regular School No Elementary PK 06 2018   k_12_total 263 9 5 5   *       * *           *         220.4   43   284 263 9 5 5                                 43   284
3303638 MO     school 2904020 55110   AURORA R-VIII 290402000032 4020 PATE EARLY CHILDHOOD CTR.   Regular School No Elementary PK 02 2018   k_12_total 311 9 59 9   *       * *           46         284   69   389 311 9 59 9                         46     284 69   389
3303754 MO     school 2930450 57003   TROY R-III 293045002089 4040 WM. R. CAPPEL ELEM.   Regular School No Elementary KG 05 2018   k_12_total 405 9 19 *   *       * 33           *         202   66   466 405 9 19               33                 202 66   466
3304294 MO     school 2927630 66105   SCHOOL OF THE OSAGE 292763002479 3000 OSAGE UPPER ELEM.   Regular School No Elementary 03 05 2018   k_12_total 405 9 21 *   *       * 20           *         236   49   458 405 9 21               20                 236 49   458
3305037 MO     school 2905730 78009   DELTA C-7 290573000119 4020 DELTA C-7 ELEM.   Regular School No Elementary KG 06 2018   k_12_total 85 9 * *   *       * 8           *         83   19   106 85 9                 8                 83 19   106
3305510 MO     school 2905370 84001   BOLIVAR R-I 290537000092 1050 BOLIVAR HIGH   Regular School No High 09 12 2018   k_12_total 770 9 26 7   9       * 27           *         375   115   848 770 9 26 7   9         27                 375 115   848
3306518 MO     school 2923270 93124   OSCEOLA 292327001339 4020 OSCEOLA ELEM.   Regular School No Elementary PK 06 2018   k_12_total 220 9 6 *   *       * *           *         151   55   238 220 9 6                                 151 55   238
3308624 MO     school 2910770 103132   DEXTER R-XI 291077000363 1050 DEXTER HIGH   Regular School No High 09 12 2018   k_12_total 577 9 12 *   *       * *           *         233.4   71   604 577 9 12                                   71   604
3308830 MO     school 2905760 106004   BRANSON R-IV 290576000123 2050 BRANSON JR. HIGH   Regular School No Middle 07 08 2018   k_12_total 560 9 99 *   9       * 23           35         383   95   704 560 9 99     9         23           35     383 95   704
3308998 MO     school 2921840 108142   NEVADA R-V 292184001214 1050 NEVADA HIGH   Regular School No High 09 12 2018   k_12_total 671 9 19 9   *       * 6           *         259   103   720 671 9 19 9             6                 259 103   720
3309004 MO     school 2921840 108142   NEVADA R-V 292184001216 3000 NEVADA MIDDLE   Regular School No Middle 06 08 2018   k_12_total 534 9 19 *   6       * 11           *         310.1   93   581 534 9 19     6         11                   93   581
3309082 MO     school 2932310 109002   WRIGHT CITY R-II OF WARREN CO. 293231003138 4040 WRIGHT CITY EAST ELEM   Regular School No Elementary KG 01 2018   k_12_total 198 9 36 *   *       * 19           21         134.4   42   262 198 9 36               19           21       42   262
3309148 MO     school 2925500 110029   POTOSI R-III 292550001497 1050 POTOSI HIGH   Regular School No High 09 12 2018   k_12_total 638 9 9 *   *       * 16           *         *   123   674 638 9 9               16                   123   674
3309267 MO     school 2920430 112102   MARSHFIELD R-I 292043001090 1050 MARSHFIELD HIGH   Regular School No High 09 12 2018   k_12_total 883 9 19 11   *       * 21           *         361.1   125   948 883 9 19 11             21                   125   948
3309837 MO     school 2900021 115414   MO SCHOOL FOR THE BLIND 290002103038 1050 MO School for the Blind - HS   Special Education School No High 09 12 2018   k_12_total 16 9 * *   *       * *           *         *   *   27 16 9                                         27
3310422 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901283 1082 WAVERLY REGIONAL YOUTH CTR.   Regular School No High 06 12 2018   k_12_total 28 9 * *   *       * *           *         *   16   37 28 9                                     16   37
3310434 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901287 1084 ALTERNATIVE RESOURCE CTR.   Alternative School No High 06 12 2018   k_12_total 5 9 * *   *       * *           *         *   *   14 5 9                                         14
3307263 MO     school 2916770 96092   KIRKWOOD R-VII 291677000923 3000 NIPHER MIDDLE   Regular School No Middle 06 08 2018   k_12_total 538 88 21 *   9       * 30           9         100   83   686 538 88 21     9         30           9     100 83   686
3306706 MO     school 2913830 96088   HAZELWOOD 291383003000 2070 CENTRAL MIDDLE   Regular School No Middle 06 08 2018   k_12_total 8 874 13 *   5       * 6           *         642   150   909 8 874 13     5         6                 642 150   909
3306019 MO     school 2908370 92087   FT. ZUMWALT R-II 290837002490 1075 FT. ZUMWALT SOUTH HIGH   Regular School No High 09 12 2018   k_12_total 1103 87 56 *   63       * 35           13         144   131   1348 1103 87 56     63         35           13     144 131   1348
3307859 MO     school 2920010 96107   MAPLEWOOD-RICHMOND HEIGHTS 292001002860 4040 MRH ELEMENTARY   Regular School No Elementary 03 06 2018   k_12_total 269 87 20 *   13       * 45           19         185.1   56   435 269 87 20     13         45           19       56   435
3309541 MO     school 2929280 115115   ST. LOUIS CITY 292928001960 3260 LONG MIDDLE COMMUNITY ED. CTR.   Regular School No Middle 06 08 2018   k_12_total 50 87 25 *   14       * *           69         *   50   176 50 87 25     14                     69       50   176
3302087 MO     school 2915480 48077   INDEPENDENCE 30 291548000719 6040 RANDALL ELEM.   Regular School No Elementary PK 05 2018   k_12_total 129 86 30 *   *       * 33           7         242   30   278 129 86 30               33           7     242 30   278
3302541 MO     school 2900590 48922   FRONTIER SCHOOLS 290059003232 1985 FRONTIER STEM HIGH SCHOOL   Regular School Yes High 09 12 2018   k_12_total 19 86 213 *   6       * *           96         *   16   324 19 86 213     6                     96       16   324
3306176 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002307 3000 BARNWELL MIDDLE   Regular School No Middle 06 08 2018   k_12_total 576 85 63 *   63       * 49           28         222   75   840 576 85 63     63         49           28     222 75   840
3306296 MO     school 2931650 92089   WENTZVILLE R-IV 293165003227 1070 LIBERTY HIGH SCHOOL   Regular School No High 09 12 2018   k_12_total 1119 85 67 *   31       * 26           *         187.1   143   1332 1119 85 67     31         26                   143   1332
3307585 MO     school 2923580 96095   PARKWAY C-2 292358001391 4180 MCKELVEY ELEM.   Regular School No Elementary KG 05 2018   k_12_total 183 85 31 *   287       * 35           151         95   85   625 183 85 31     287         35           151     95 85   625
3306242 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002681 5010 HARVEST RIDGE ELEM.   Regular School No Elementary KG 05 2018   k_12_total 403 84 46 *   76       * 48           62         200.3   69   662 403 84 46     76         48           62       69   662
3307740 MO     school 2913620 96103   HANCOCK PLACE 291362000583 1050 HANCOCK SR. HIGH   Regular School No High 09 12 2018   k_12_total 248 84 39 *   *       * 33           13         *   59   407 248 84 39               33           13       59   407
3299507 MO     school 2916190 26006   JEFFERSON CITY 291619000758 5040 WEST ELEM.   Regular School No Elementary KG 05 2018   k_12_total 234 83 23 *   5       * 33           11         224.3   39   378 234 83 23     5         33           11       39   378
3300548 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001804 1085 KICKAPOO HIGH   Regular School No High 09 12 2018   k_12_total 1545 83 81 9   52       * 36           9         435   123   1809 1545 83 81 9   52         36           9     435 123   1809
3306013 MO     school 2908370 92087   FT. ZUMWALT R-II 290837000239 1050 FT. ZUMWALT NORTH HIGH   Regular School No High 09 12 2018   k_12_total 1312 83 67 *   16       * 57           18         262   257   1537 1312 83 67     16         57           18     262 257   1537
3306200 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002698 3400 BRYAN MIDDLE   Regular School No Middle 06 08 2018   k_12_total 714 83 28 *   34       * 32           *         174   113   892 714 83 28     34         32                 174 113   892
3307746 MO     school 2913620 96103   HANCOCK PLACE 291362001894 3000 HANCOCK PLACE MIDDLE   Regular School No Middle 06 08 2018   k_12_total 206 83 26 *   *       * 35           12         *   45   354 206 83 26               35           12       45   354
3302500 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001703259 6941 ACADEMIE LAFAYETTE-CHERRY   Regular School Yes Elementary KG 03 2018   k_12_total 314 82 24 *   7       * 52           12         102   28   482 314 82 24     7         52           12     102 28   482
3305467 MO     school 2923550 83005   PARK HILL 292355001372 5000 SOUTHEAST ELEM.   Regular School No Elementary KG 05 2018   k_12_total 314 82 47 5   6       9 39           51         153   51   502 314 82 47 5   6       9 39           51     153 51   502
3302494 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001702753 6940 ACADEMIE LAFAYETTE-OAK   Regular School Yes Middle 04 08 2018   k_12_total 329 81 23 *   15       * 39           5         89   42   488 329 81 23     15         39           5     89 42   488
3307917 MO     school 2926640 96110   RITENOUR 292664001573 1050 RITENOUR SR. HIGH   Regular School No High 09 12 2018   k_12_total 558 802 349 *   36       * 92           131         *   282   1842 558 802 349     36         92           131       282   1842
3298986 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Career and Technical School No High 10 12 2018   k_12_total 46 80 9 *   *       * 6           *         *   *   142 46 80 9               6                       142
3302589 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303295 6905 CROSSROADS - QUALITY HILL   Regular School Yes Elementary KG 04 2018   k_12_total 71 80 51 *   *       * 22           35         134   22   229 71 80 51               22           35     134 22   229
3297131 MO     school 2906360 7129   BUTLER R-V 290636000158 1050 BUTLER HIGH   Regular School No High 07 12 2018   k_12_total 455 8 14 *   *       * 8           *         215   48   489 455 8 14               8                 215 48   489
3297290 MO     school 2913560 10089   HALLSVILLE R-IV 291356000578 1050 HALLSVILLE HIGH   Regular School No High 09 12 2018   k_12_total 363 8 19 *   *       * 9           *         121   31   401 363 8 19               9                 121 31   401
3297681 MO     school 2927060 11082   ST. JOSEPH 292706001652 4100 FIELD ELEM.   Regular School No Elementary KG 06 2018   k_12_total 266 8 23 *   27       * 20           22         108   28   344 266 8 23     27         20           22     108 28   344
3298170 MO     school 2915600 16090   JACKSON R-II 291560000739 4160 WEST LANE ELEM.   Regular School No Elementary 03 05 2018   k_12_total 444 8 12 *   *       * 18           *         199.3   57   483 444 8 12               18                   57   483
3298356 MO     school 2903200 19139   ARCHIE R-V 290320000025 1050 ARCHIE HIGH   Regular School No High 06 12 2018   k_12_total 289 8 * *   *       * *           *         71   24   305 289 8                                   71 24   305
3298428 MO     school 2923730 19142   RAYMORE-PECULIAR R-II 292373002889 5000 BRIDLE RIDGE ELEMENTARY   Regular School No Elementary KG 05 2018   k_12_total 357 8 21 *   *       * 15           *         96   47   402 357 8 21               15                 96 47   402
3298502 MO     school 2913760 19149   HARRISONVILLE R-IX 291376002659 3000 HARRISONVILLE MIDDLE   Regular School No Middle 06 08 2018   k_12_total 503 8 21 5   *       * 11           *         224   64   552 503 8 21 5             11                 224 64   552
3298744 MO     school 2922530 22089   Nixa Public Schools 292253002799 4080 SUMMIT INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2018   k_12_total 467 8 25 *   *       * 34           8         204   72   540 467 8 25               34           8     204 72   540
3298852 MO     school 2923430 22093   OZARK R-VI 292343002727 4085 NORTH ELEM.   Regular School No Elementary KG 05 2018   k_12_total 584 8 19 6   *       * 22           25         190   50   642 584 8 19 6             22           25     190 50   642
3298960 MO     school 2928410 24087   SMITHVILLE R-II 292841000070 3000 SMITHVILLE MIDDLE   Regular School No Middle 06 08 2018   k_12_total 583 8 21 7   9       * 13           *         88   70   641 583 8 21 7   9         13                 88 70   641
3300094 MO     school 2930570 36131   UNION R-XI 293057002575 3000 UNION MIDDLE   Regular School No Middle 07 08 2018   k_12_total 447 8 9 *   5       * 6           6         191   47   478 447 8 9     5         6           6     191 47   478
3300154 MO     school 2929100 36136   ST. CLAIR R-XIII 292910001865 4020 ST. CLAIR ELEM.   Regular School No Elementary PK 02 2018   k_12_total 458 8 * *   *       * 21           *         272   45   489 458 8                 21                 272 45   489
3300776 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001828 4680 SUNSHINE ELEM.   Regular School No Elementary KG 05 2018   k_12_total 155 8 12 *   5       * 14           9         110   17   199 155 8 12     5         14           9     110 17   199
3301304 MO     school 2928470 47060   SOUTH IRON CO. R-I 292847001759 1050 SOUTH IRON HIGH   Regular School No High 07 12 2018   k_12_total 111 8 7 *   *       * *           *         95   21   127 111 8 7                                 95 21   127

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