Data source: Big Local News · About: Big Local

16,123 rows where grade = "k_12_total" and state = "MO" sorted by ell descending

View and edit SQL

year

grade

  • k_12_total · 16,123
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
3302014 MO     school 2915480 48077   INDEPENDENCE 30 291548003090 3060 CLIFFORD H. NOWLIN MIDDLE   Regular School No Middle 06 08 2018   k_12_total 468 111 290 *   *       * 68           99         814   125   945 468 111 290               68           99     814 125   945
3307231 MO     school 2926850 96091   ROCKWOOD R-VI 292685002700 4165 WILD HORSE ELEM.   Regular School No 1 KG 05 2016   k_12_total 266 51 49 *   174       * 7           99         116   68   550 266 51 49     174         7           99     116 68   550
3307232 MO     school 2926850 96091   ROCKWOOD R-VI 292685002700 4165 WILD HORSE ELEM.   Regular School No Elementary KG 05 2017   k_12_total 228 46 47 *   205       * 9           99         99   61   538 228 46 47     205         9           99     99 61   538
3307349 MO     school 2918690 96093   LINDBERGH SCHOOLS 291869001025 5060 SAPPINGTON ELEM.   Regular School No Elementary KG 05 2017   k_12_total 636 8 41 *   41       * 43           99         173   108   771 636 8 41     41         43           99     173 108   771
3307536 MO     school 2923580 96095   PARKWAY C-2 292358001377 4035 CARMAN TRAILS ELEM.   Regular School No Elementary PK 05 2017   k_12_total 232 59 87 *   44       * 30           99         191   62   453 232 59 87     44         30           99     191 62   453
3307947 MO     school 2926640 96110   RITENOUR 292664001569 4120 KRATZ ELEM.   Regular School No Elementary KG 05 2018   k_12_total 107 246 112 *   *       * 54           99         *   88   524 107 246 112               54           99       88   524
3309729 MO     school 2929280 115115   ST. LOUIS CITY 292928001930 5340 MASON ELEM.   Regular School No Elementary PK 06 2018   k_12_total 126 143 57 *   15       * *           99         *   72   343 126 143 57     15                     99       72   343
3309755 MO     school 2929280 115115   ST. LOUIS CITY 292928000798 5590 MULLANPHY BOTANICAL GARDENS   Regular School No Elementary PK 05 2020   k_12_total 32 310 41 *   14       * *           99         *   84   398 32 310 41     14                     99       84   398
3300528 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001786 1050 CENTRAL HIGH   Regular School No 4 06 12 2016   k_12_total 1258 188 135 11   110       9 37           98         854   95   1748 1258 188 135 11   110       9 37           98     854 95   1748
3301982 MO     school 2915480 48077   INDEPENDENCE 30 291548000722 1050 TRUMAN HIGH   Regular School No 3 09 12 2016   k_12_total 1014 177 266 *   33       19 92           98         776.1   126   1605 1014 177 266     33       19 92           98       126   1605
3302067 MO     school 2915480 48077   INDEPENDENCE 30 291548003107 5100 KORTE ELEM.   Regular School No 1 PK 05 2016   k_12_total 291 58 177 *   *       * 50           98         521   40   585 291 58 177               50           98     521 40   585
3302542 MO     school 2900590 48922   FRONTIER SCHOOLS 290059003232 1985 FRONTIER STEM HIGH SCHOOL   Regular School Yes High 09 12 2019   k_12_total 23 96 221 *   5       * *           98         *   16   345 23 96 221     5                     98       16   345
3307047 MO     school 2923700 96090   PATTONVILLE R-III 292370002848 5060 ROBERT DRUMMOND ELEM.   Regular School No Elementary PK 05 2018   k_12_total 239 310 90 *   19       * 61           98         510   113   722 239 310 90     19         61           98     510 113   722
3307418 MO     school 2920670 96094   MEHLVILLE R-IX 292067002420 4080 FORDER ELEM.   Regular School No Elementary KG 05 2017   k_12_total 338 29 14 *   16       * 29           98         208   72   428 338 29 14     16         29           98     208 72   428
3309730 MO     school 2929280 115115   ST. LOUIS CITY 292928001930 5340 MASON ELEM.   Regular School No Elementary PK 06 2019   k_12_total 163 141 58 *   13       * *           98         *   81   378 163 141 58     13                     98       81   378
3299187 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280003115 4040 BELL PRAIRIE ELEMENTARY   Regular School No 1 PK 05 2016   k_12_total 447 61 67 *   25       * 23           97         190   51   627 447 61 67     25         23           97     190 51   627
3302548 MO     school 2900590 48922   FRONTIER SCHOOLS 290059003182 3935 FRONTIER SCHL OF INNOVATION-M   Regular School Yes Middle 06 08 2019   k_12_total 11 51 242 *   *       * *           97         *   16   308 11 51 242                           97       16   308
3304702 MO     school 2921810 73108   NEOSHO R-V 292181001203 4020 BENTON ELEM.   Regular School No 1 KG 04 2015   k_12_total 304 * 108 11   *       29 22           97         353.4   58   478 304   108 11           29 22           97       58   478
3307416 MO     school 2920670 96094   MEHLVILLE R-IX 292067002420 4080 FORDER ELEM.   Regular School No 1 KG 05 2015   k_12_total 371 30 19 *   10       * 29           97         220   65   462 371 30 19     10         29           97     220 65   462
3307417 MO     school 2920670 96094   MEHLVILLE R-IX 292067002420 4080 FORDER ELEM.   Regular School No 1 KG 05 2016   k_12_total 351 30 16 *   16       * 24           97         212   66   439 351 30 16     16         24           97     212 66   439
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
3304711 MO     school 2921810 73108   NEOSHO SCHOOL DISTRICT 292181001204 4040 CENTRAL ELEM.   Regular School No Elementary KG 04 2018   k_12_total 106 * 70 *   *       45 13           96         175   41   238 106   70             45 13           96     175 41   238
3307420 MO     school 2920670 96094   MEHLVILLE R-IX 292067002420 4080 FORDER ELEM.   Regular School No Elementary KG 05 2019   k_12_total 277 19 13 *   21       * 16           96         165   50   347 277 19 13     21         16           96     165 50   347
3307915 MO     school 2926640 96110   RITENOUR 292664001573 1050 RITENOUR SR. HIGH   Regular School No 3 09 12 2016   k_12_total 635 795 283 5   36       * 75           96         1204   261   1830 635 795 283 5   36         75           96     1204 261   1830
3309721 MO     school 2929280 115115   ST. LOUIS CITY 292928001968 5260 MANN ELEM.   Regular School No 1 PK 06 2016   k_12_total 35 143 37 *   27       * *           96         *   40   242 35 143 37     27                     96       40   242
3302481 MO     school 2900013 48912   DELLA LAMB ELEM. 290001303275 6931 DELLA LAMB @ WOODLAND   Regular School Yes 1 KG 01 2016   k_12_total * 89 22 *   13       * *           95         *   *   131   89 22     13                     95           131
3303936 MO     school 2920610 60077   MCDONALD CO. R-I 292061001104 1050 MCDONALD COUNTY HIGH   Regular School No High 09 12 2019   k_12_total 747 12 237 31   19       33 17           95         640   180   1096 747 12 237 31   19       33 17           95     640 180   1096
3305682 MO     school 2931440 85046   WAYNESVILLE R-VI 293144002898 4050 FREEDOM ELEM.   Regular School No Elementary KG 05 2019   k_12_total 604 142 126 10   24       15 168           95         476.2   164   1089 604 142 126 10   24       15 168           95       164   1089
3297620 MO     school 2927060 11082   ST. JOSEPH 292706001648 1075 CENTRAL HIGH   Regular School No High 09 12 2017   k_12_total 1263 126 152 6   57       10 76           94         654   202   1690 1263 126 152 6   57       10 76           94     654 202   1690
3299128 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001284 1050 NORTH KANSAS CITY HIGH   Regular School No 3 09 12 2015   k_12_total 776 281 259 7   105       13 114           94         804.1   128   1555 776 281 259 7   105       13 114           94       128   1555
3304689 MO     school 2921810 73108   NEOSHO SCHOOL DISTRICT 292181001209 1050 NEOSHO HIGH   Regular School No High 09 12 2020   k_12_total 909 16 208 45   14       74 38           94         524   111   1304 909 16 208 45   14       74 38           94     524 111   1304
3297685 MO     school 2927060 11082   ST. JOSEPH 292706001654 4140 COLEMAN ELEM.   Regular School No 1 PK 06 2016   k_12_total 186 69 49 *   33       5 36           93         326   61   378 186 69 49     33       5 36           93     326 61   378
3302543 MO     school 2900590 48922   FRONTIER SCHOOLS 290059003232 1985 FRONTIER STEM HIGH SCHOOL   Regular School Yes High 09 12 2020   k_12_total 25 83 240 *   *       * *           93         *   14   350 25 83 240                           93       14   350
3305169 MO     school 2927830 80125   SEDALIA 200 292783001703 4020 HEBER HUNT ELEM.   Regular School No Elementary KG 04 2017   k_12_total 278 45 122 *   *       * 31           93         *   85   482 278 45 122               31           93       85   482
3307066 MO     school 2923700 96090   PATTONVILLE R-III 292370001423 6060 WILLOW BROOK ELEM.   Regular School No Elementary PK 05 2019   k_12_total 159 154 94 *   38       * 44           93         190   70   491 159 154 94     38         44           93     190 70   491
3307379 MO     school 2920670 96094   MEHLVILLE R-IX 292067001114 3000 MARGARET BUERKLE MIDDLE   Regular School No Middle 06 08 2020   k_12_total 461 72 32 5   31       * 33           93         290   90   635 461 72 32 5   31         33           93     290 90   635
3307535 MO     school 2923580 96095   PARKWAY C-2 292358001377 4035 CARMAN TRAILS ELEM.   Regular School No 1 PK 05 2016   k_12_total 246 63 81 *   44       * 22           93         180.2   56   458 246 63 81     44         22           93       56   458
3307944 MO     school 2926640 96110   RITENOUR 292664001569 4120 KRATZ ELEM.   Regular School No 1 KG 05 2015   k_12_total 110 263 107 *   5       * 64           93         *   65   550 110 263 107     5         64           93       65   550
3307948 MO     school 2926640 96110   RITENOUR 292664001569 4120 KRATZ ELEM.   Regular School No Elementary KG 05 2019   k_12_total 89 251 117 *   *       * 53           93         *   73   517 89 251 117               53           93       73   517
3309480 MO     school 2929280 115115   ST. LOUIS CITY 292928000790 1730 SOLDAN INTERNATIONAL STUDIES   Regular School No High 09 12 2020   k_12_total 11 451 37 *   11       * *           93         *   28   511 11 451 37     11                     93       28   511
3309725 MO     school 2929280 115115   ST. LOUIS CITY 292928001968 5260 MANN ELEM.   Regular School No Elementary PK 06 2020   k_12_total 47 136 31 *   30       * *           93         *   34   244 47 136 31     30                     93       34   244
3297450 MO     school 2901000 10093   COLUMBIA 93 290100000298 4040 BLUE RIDGE ELEM.   Regular School No 1 PK 05 2016   k_12_total 142 143 101 *   21       * 46           92         *   53   456 142 143 101     21         46           92       53   456
3297623 MO     school 2927060 11082   ST. JOSEPH 292706001648 1075 CENTRAL HIGH   Regular School No High 09 12 2020   k_12_total 1244 118 182 5   51       15 91           92         644   213   1706 1244 118 182 5   51       15 91           92     644 213   1706
3305497 MO     school 2923550 83005   PARK HILL 292355003221 5090 TIFFANY RIDGE ELEMENTARY SCHL   Regular School No Elementary KG 05 2018   k_12_total 374 120 74 *   38       * 46           92         196   41   656 374 120 74     38         46           92     196 41   656
3307035 MO     school 2923700 96090   PATTONVILLE R-III 292370001412 4060 BRIDGEWAY ELEM.   Regular School No Elementary PK 05 2018   k_12_total 164 139 96 *   10       * 33           92         249   65   443 164 139 96     10         33           92     249 65   443
3307954 MO     school 2926640 96110   RITENOUR 292664001570 4140 MARION ELEM.   Regular School No Elementary KG 05 2019   k_12_total 117 185 137 *   5       * 57           92         *   86   501 117 185 137     5         57           92       86   501
3309477 MO     school 2929280 115115   ST. LOUIS CITY 292928000790 1730 SOLDAN INTERNATIONAL STUDIES   Regular School No High 09 12 2017   k_12_total 16 496 36 *   25       * *           92         *   19   574 16 496 36     25                     92       19   574
3309722 MO     school 2929280 115115   ST. LOUIS CITY 292928001968 5260 MANN ELEM.   Regular School No Elementary PK 06 2017   k_12_total 40 149 37 *   28       * *           92         *   39   254 40 149 37     28                     92       39   254
3299166 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001278 3150 MAPLE PARK MIDDLE   Regular School No Middle 06 08 2017   k_12_total 429 150 137 8   27       * 44           91         540   130   798 429 150 137 8   27         44           91     540 130   798
3304709 MO     school 2921810 73108   NEOSHO R-V 292181001204 4040 CENTRAL ELEM.   Regular School No 1 KG 04 2016   k_12_total 138 * 76 *   *       31 15           91         210   49   261 138   76             31 15           91     210 49   261
3305167 MO     school 2927830 80125   SEDALIA 200 292783001703 4020 HEBER HUNT ELEM.   Regular School No 1 KG 04 2015   k_12_total 267 42 125 5   *       * 34           91         *   67   475 267 42 125 5             34           91       67   475
3307378 MO     school 2920670 96094   MEHLVILLE R-IX 292067001114 3000 MARGARET BUERKLE MIDDLE   Regular School No Middle 06 08 2019   k_12_total 478 63 37 5   31       * 32           91         277   91   647 478 63 37 5   31         32           91     277 91   647
3307582 MO     school 2923580 96095   PARKWAY C-2 292358001391 4180 MCKELVEY ELEM.   Regular School No 1 KG 05 2015   k_12_total 201 78 23 *   172       * 36           91         107   72   510 201 78 23     172         36           91     107 72   510
3307946 MO     school 2926640 96110   RITENOUR 292664001569 4120 KRATZ ELEM.   Regular School No Elementary KG 05 2017   k_12_total 109 255 107 *   *       * 53           91         *   76   529 109 255 107               53           91       76   529
3309825 MO     school 2929280 115115   ST. LOUIS CITY 292928002026 6120 WOODWARD ELEM.   Regular School No Elementary PK 05 2018   k_12_total 23 218 29 *   11       * *           91         *   34   281 23 218 29     11                     91       34   281
3300532 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001786 1050 CENTRAL HIGH   Regular School No High 06 12 2020   k_12_total 1203 198 150 15   96       16 64           90         815   123   1742 1203 198 150 15   96       16 64           90     815 123   1742
3305168 MO     school 2927830 80125   SEDALIA 200 292783001703 4020 HEBER HUNT ELEM.   Regular School No 1 KG 04 2016   k_12_total 277 38 116 *   *       * 35           90         *   80   473 277 38 116               35           90       80   473
3309907 MO     school 2900586 115912   ST. LOUIS LANG IMMERSION SCH 290058603124 6961 ST LOUIS LANG IMMERSION MARINE   Regular School Yes Elementary KG 08 2018   k_12_total 186 368 92 *   14       * 49           90         400.2   71   709 186 368 92     14         49           90       71   709
3296698 MO     school 2916740 1091   KIRKSVILLE R-III 291674002611 3000 WILLIAM MATTHEW MIDDLE SCHOOL   Regular School No 2 06 08 2016   k_12_total 478 20 8 *   10       * 8           9         279   73   525 478 20 8     10         8           9     279 73   525
3296853 MO     school 2920810 4110   MEXICO 59 292081001137 1050 MEXICO HIGH   Regular School No 3 09 12 2015   k_12_total 561 55 26 *   *       * 29           9         262   65   675 561 55 26               29           9     262 65   675
3296952 MO     school 2925620 5124   PURDY R-II 292562001502 1050 PURDY HIGH   Regular School No High 09 12 2018   k_12_total 131 * 24 *   *       20 *           9         87   6   180 131   24             20             9     87 6   180
3297199 MO     school 2909900 8111   COLE CAMP R-I 290990000292 4020 COLE CAMP ELEM.   Regular School No Elementary KG 04 2018   k_12_total 238 * 10 *   *       * 5           9         151   41   253 238   10               5           9     151 41   253
3297303 MO     school 2913560 10089   HALLSVILLE R-IV 291356000577 4020 HALLSVILLE INTERMEDIATE   Regular School No Elementary 02 05 2019   k_12_total 384 10 10 *   12       * 31           9         158   47   449 384 10 10     12         31           9     158 47   449
3297436 MO     school 2901000 10093   COLUMBIA 93 290100001946 3060 JOHN B. LANGE MIDDLE   Regular School No Middle 06 08 2020   k_12_total 284 206 46 *   18       * 65           9         382.3   76   626 284 206 46     18         65           9       76   626
3297446 MO     school 2901000 10093   COLUMBIA 93 290100003152 4030 ALPHA HART LEWIS   Regular School No Elementary PK 05 2018   k_12_total 180 150 22 *   *       * 59           9         *   66   419 180 150 22               59           9       66   419
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
3297661 MO     school 2927060 11082   ST. JOSEPH 292706001650 4060 ELLISON ELEM.   Regular School No 1 KG 06 2016   k_12_total 292 17 15 *   6       * 23           9         145   36   359 292 17 15     6         23           9     145 36   359
3297722 MO     school 2927060 11082   ST. JOSEPH 292706001667 4390 PARKWAY ELEM.   Regular School No 1 PK 06 2015   k_12_total 367 30 20 *   *       * 17           9         293   69   440 367 30 20               17           9     293 69   440
3297731 MO     school 2927060 11082   ST. JOSEPH 292706001668 4400 PERSHING ELEM.   Regular School No Elementary KG 06 2018   k_12_total 274 * 14 *   *       * 26           9         183   37   319 274   14               26           9     183 37   319
3298051 MO     school 2906990 15002   CAMDENTON R-III 290699000175 1050 CAMDENTON HIGH   Regular School No High 09 12 2018   k_12_total 1215 23 56 8   15       * 15           9         609   177   1336 1215 23 56 8   15         15           9     609 177   1336
3298052 MO     school 2906990 15002   CAMDENTON R-III 290699000175 1050 CAMDENTON HIGH   Regular School No High 09 12 2019   k_12_total 1165 24 75 7   15       * 32           9         582.1   171   1320 1165 24 75 7   15         32           9       171   1320
3298066 MO     school 2906990 15002   CAMDENTON R-III 290699002580 4030 OAK RIDGE INTERMEDIATE   Regular School No 2 05 06 2015   k_12_total 557 11 28 5   6       * *           9         352   76   609 557 11 28 5   6                     9     352 76   609
3298079 MO     school 2906990 15002   CAMDENTON R-III 290699002983 4050 HAWTHORN ELEM.   Regular School No 1 03 04 2016   k_12_total 448 14 24 12   *       * *           9         321.2   80   503 448 14 24 12                         9       80   503
3298082 MO     school 2906990 15002   CAMDENTON R-III 290699002983 4050 HAWTHORN ELEM.   Regular School No Elementary 03 04 2019   k_12_total 397 5 31 *   *       * 6           9         243.1   60   443 397 5 31               6           9       60   443
3298166 MO     school 2915600 16090   JACKSON R-II 291560003265 4140 EAST ELEMENTARY   Regular School No Elementary PK 04 2020   k_12_total 380 11 7 *   *       * 8           9         111   70   412 380 11 7               8           9     111 70   412
3298226 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712002722 4050 BLANCHARD ELEM.   Regular School No Elementary PK 04 2020   k_12_total 149 119 13 *   5       * 42           9         *   40   328 149 119 13     5         42           9       40   328
3298234 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712000189 4080 JEFFERSON ELEM.   Regular School No 1 PK 04 2016   k_12_total 92 147 20 *   *       * 50           9         288   55   309 92 147 20               50           9     288 55   309
3298235 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712000189 4080 JEFFERSON ELEM.   Regular School No Elementary PK 04 2017   k_12_total 76 124 19 *   *       * 37           9         256.1   41   256 76 124 19               37           9       41   256
3298376 MO     school 2923730 19142   RAYMORE-PECULIAR R-II 292373001424 1050 RAYMORE-PECULIAR SR. HIGH   Regular School No High 09 12 2020   k_12_total 1488 200 143 6   22       * 112           9         479.3   187   1971 1488 200 143 6   22         112           9       187   1971
3298500 MO     school 2913760 19149   HARRISONVILLE R-IX 291376002659 3000 HARRISONVILLE MIDDLE   Regular School No 2 06 08 2016   k_12_total 494 10 18 8   *       * 5           9         227   46   540 494 10 18 8             5           9     227 46   540
3298575 MO     school 2904620 19152   BELTON 124 290462000054 4050 SCOTT ELEM.   Regular School No Elementary KG 04 2019   k_12_total 149 34 23 *   *       * 25           9         149   37   238 149 34 23               25           9     149 37   238
3298820 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No 2 07 08 2016   k_12_total 771 7 38 14   5       * 29           9         321.3   87   868 771 7 38 14   5         29           9       87   868
3298831 MO     school 2923430 22093   OZARK R-VI 292343000470 4060 UPPER ELEM.   Regular School No 2 05 06 2015   k_12_total 745 8 39 8   *       * 25           9         300   75   830 745 8 39 8             25           9     300 75   830
3299021 MO     school 2918540 24090   LIBERTY 53 291854003148 1070 LIBERTY NORTH HIGH SCHOOL   Regular School No 3 09 12 2016   k_12_total 1439 130 118 5   43       8 21           9         338   137   1764 1439 130 118 5   43       8 21           9     338 137   1764
3299044 MO     school 2918540 24090   LIBERTY 53 291854003238 3090 HERITAGE MIDDLE SCHOOL   Regular School No 2 06 08 2015   k_12_total 567 39 35 *   24       * 12           9         161   66   685 567 39 35     24         12           9     161 66   685
3299058 MO     school 2918540 24090   LIBERTY 53 291854001005 4040 FRANKLIN ELEM.   Regular School No Elementary KG 05 2017   k_12_total 218 16 22 *   *       * 21           9         97   42   282 218 16 22               21           9     97 42   282
3299086 MO     school 2918540 24090   LIBERTY 53 291854002804 4140 SHOAL CREEK ELEM.   Regular School No 1 KG 05 2015   k_12_total 719 26 21 *   29       * 14           9         37   64   812 719 26 21     29         14           9     37 64   812
3299210 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280002731 4110 NORTHVIEW ELEM.   Regular School No 1 KG 05 2015   k_12_total 577 70 50 *   16       * 63           9         143   76   779 577 70 50     16         63           9     143 76   779
3299212 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280002731 4110 NORTHVIEW ELEM.   Regular School No Elementary KG 05 2017   k_12_total 561 49 46 *   16       * 55           9         92   55   729 561 49 46     16         55           9     92 55   729
3299434 MO     school 2916190 26006   JEFFERSON CITY 291619000476 3000 LEWIS AND CLARK MIDDLE   Regular School No Middle 06 08 2017   k_12_total 642 167 46 *   9       * 68           9         535.1   110   937 642 167 46     9         68           9       110   937
3299435 MO     school 2916190 26006   JEFFERSON CITY 291619000476 3000 LEWIS AND CLARK MIDDLE   Regular School No Middle 06 08 2018   k_12_total 632 164 57 *   10       * 82           9         526   113   949 632 164 57     10         82           9     526 113   949
3299459 MO     school 2916190 26006   JEFFERSON CITY 291619000747 4030 CEDAR HILL ELEM.   Regular School No Elementary KG 05 2018   k_12_total 271 42 24 *   13       * 39           9         166   44   392 271 42 24     13         39           9     166 44   392
3299505 MO     school 2916190 26006   JEFFERSON CITY 291619000758 5040 WEST ELEM.   Regular School No 1 KG 05 2016   k_12_total 267 73 27 *   9       * 35           9         224   29   413 267 73 27     9         35           9     224 29   413
3299508 MO     school 2916190 26006   JEFFERSON CITY 291619000758 5040 WEST ELEM.   Regular School No Elementary KG 05 2019   k_12_total 211 64 14 *   *       * 30           9         209.2   29   324 211 64 14               30           9       29   324
3299620 MO     school 2910410 28102   CRAWFORD CO. R-II 291041000018 3000 CUBA MIDDLE   Regular School No Middle 05 08 2017   k_12_total 434 6 26 *   *       * *           9         247   92   471 434 6 26                           9     247 92   471
3299951 MO     school 2909120 35097   CLARKTON C-4 290912000269 1050 CLARKTON HIGH   Regular School No High 07 12 2018   k_12_total 103 11 19 *   *       * *           9         *   19   136 103 11 19                           9       19   136
3300109 MO     school 2930570 36131   UNION R-XI 293057002098 4040 CENTRAL ELEM.   Regular School No 1 PK 03 2015   k_12_total 739 12 23 *   *       * 35           9         461   62   810 739 12 23               35           9     461 62   810
3300114 MO     school 2930570 36131   UNION R-XI 293057002098 4040 CENTRAL ELEM.   Regular School No Elementary PK 03 2020   k_12_total 655 9 26 *   *       * 32           9         404   97   724 655 9 26               32           9     404 97   724
3300231 MO     school 2931110 36139   WASHINGTON 293111002158 4060 CLEARVIEW ELEM.   Regular School No Elementary KG 06 2017   k_12_total 315 * 6 *   *       * 13           9         82   24   340 315   6               13           9     82 24   340
3300352 MO     school 2932010 39133   WILLARD R-II 293201002243 1050 WILLARD HIGH   Regular School No High 09 12 2017   k_12_total 1210 52 55 10   8       * 10           9         465   125   1345 1210 52 55 10   8         10           9     465 125   1345

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