Data source: Big Local News · About: Big Local

37,152 rows where state = "MO" and year = 2019 sorted by ell descending

View and edit SQL

grade

year

  • 2019 · 37,152
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
3300735 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001814 4500 PITTMAN ELEM.   Regular School No Elementary KG 05 2019   k_12_total 210 21 22 *   *       * 27           9         190   48   287 210 21 22               27           9     190 48   287
3300747 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001817 4520 PORTLAND ELEM.   Regular School No Elementary KG 05 2019   k_12_total 167 24 23 5   *       * 33           9         185.1   30   254 167 24 23 5             33           9       30   254
3300985 MO     school 2932110 42111   HENRY CO. R-I 293211002254 4020 WINDSOR ELEM.   Regular School No Elementary PK 06 2019   k_12_total 355 * 12 *   5       * *           9         233.3   72   380 355   12     5                     9       72   380
3301359 MO     school 2912290 48066   FORT OSAGE R-I 291229000494 3000 OSAGE TRAIL MIDDLE   Regular School No Middle 07 08 2019   k_12_total 598 80 85 7   7       15 17           9         427   109   809 598 80 85 7   7       15 17           9     427 109   809
3301450 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000080 4040 FRANKLIN SMITH ELEM.   Regular School No Elementary PK 05 2019   k_12_total 317 44 50 *   8       * 55           9         231   62   478 317 44 50     8         55           9     231 62   478
3301618 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830000222 3000 BERNARD C. CAMPBELL MIDDLE   Regular School No Middle 05 08 2019   k_12_total 653 148 54 *   15       * 66           9         238   91   942 653 148 54     15         66           9     238 91   942
3302130 MO     school 2915480 48077   INDEPENDENCE 30 291548003213 6120 LITTLE BLUE ELEMENTARY   Regular School No Elementary PK 05 2019   k_12_total 195 31 27 *   *       * 38           9         152   43   296 195 31 27               38           9     152 43   296
3302513 MO     school 2900024 48916   BROOKSIDE CHARTER SCH. 290002403184 3950 BROOKSIDE CHARTER MIDDLE SCHL   Regular School Yes Middle 06 08 2019   k_12_total * 181 9 *   *       * 5           9         *   24   200   181 9               5           9       24   200
3302740 MO     school 2931500 49144   WEBB CITY R-VII 293150002756 2050 WEBB CITY JR. HIGH   Regular School No Middle 07 08 2019   k_12_total 558 9 49 10   9       * 36           9         287   88   674 558 9 49 10   9         36           9     287 88   674
3302758 MO     school 2931500 49144   WEBB CITY R-VII 293150002185 4040 MADGE T. JAMES KIND. CTR.   Regular School No Elementary KG KG 2019   k_12_total 145 9 15 *   *       * 20           9         109   19   195 145 9 15               20           9     109 19   195
3302890 MO     school 2922890 50001   NORTHWEST R-I 292289001309 1050 NORTHWEST HIGH   Regular School No High 09 12 2019   k_12_total 1690 18 51 *   14       * 38           9         627   239   1815 1690 18 51     14         38           9     627 239   1815
3303109 MO     school 2912300 50012   FOX C-6 291230000506 1050 FOX SR. HIGH   Regular School No High 09 12 2019   k_12_total 1550 30 57 6   33       * 41           9         487   306   1717 1550 30 57 6   33         41           9     487 306   1717
3303199 MO     school 2912300 50012   FOX C-6 291230000507 5000 SHERWOOD ELEM.   Regular School No Elementary KG 05 2019   k_12_total 359 11 19 *   5       * 19           9         171   84   413 359 11 19     5         19           9     171 84   413
3303330 MO     school 2916830 51155   KNOB NOSTER R-VIII 291683000933 4040 WHITEMAN A.F.B. ELEM.   Regular School No Elementary PK 04 2019   k_12_total 262 23 51 *   6       * 23           9         149   55   367 262 23 51     6         23           9     149 55   367
3303427 MO     school 2918270 53113   LEBANON R-III 291827000971 2050 LEBANON MIDDLE SCHOOL   Regular School No Middle 06 08 2019   k_12_total 943 16 47 *   9       * 42           9         582   166   1058 943 16 47     9         42           9     582 166   1058
3303633 MO     school 2904020 55110   AURORA R-VIII 290402001517 2050 AURORA JR. HIGH   Regular School No Middle 07 08 2019   k_12_total 217 * 43 7   *       * 6           9         165   41   279 217   43 7             6           9     165 41   279
3303923 MO     school 2908760 59117   CHILLICOTHE R-II 290876000261 4040 CHILLICOTHE ELEM   Regular School No Elementary PK 01 2019   k_12_total 213 6 11 *   6       * 20           9         138   36   256 213 6 11     6         20           9     138 36   256
3305068 MO     school 2924530 79077   PERRY CO. 32 292453002387 1050 PERRYVILLE SR. HIGH   Regular School No High 09 12 2019   k_12_total 713 * 21 *   6       * 9           9         254   119   755 713   21     6         9           9     254 119   755
3306146 MO     school 2908370 92087   FT. ZUMWALT R-II 290837002843 4170 OSTMANN ELEM.   Regular School No Elementary KG 05 2019   k_12_total 305 11 14 *   18       * 16           9         25   151   365 305 11 14     18         16           9     25 151   365
3306839 MO     school 2913830 96088   HAZELWOOD 291383000627 4300 JANA ELEM.   Regular School No Elementary KG 05 2019   k_12_total 46 270 5 *   *       * *           9         166   56   329 46 270 5                           9     166 56   329
3307258 MO     school 2916770 96092   KIRKWOOD R-VII 291677000926 1050 KIRKWOOD SR. HIGH   Regular School No High 09 12 2019   k_12_total 1339 225 71 *   41       * 68           9         207.3   242   1747 1339 225 71     41         68           9       242   1747
3307483 MO     school 2923580 96095   PARKWAY C-2 292358001404 1080 WEST HIGH   Regular School No High 09 12 2019   k_12_total 988 146 53 *   173       * 46           9         168.1   229   1407 988 146 53     173         46           9       229   1407
3307592 MO     school 2923580 96095   PARKWAY C-2 292358002626 4190 OAK BROOK ELEM.   Regular School No Elementary PK 05 2019   k_12_total 350 23 13 *   64       * 39           9         59   64   492 350 23 13     64         39           9     59 64   492
3307705 MO     school 2909720 96102   CLAYTON 290972000275 1050 CLAYTON HIGH   Regular School No High 09 12 2019   k_12_total 552 162 39 *   109       * 38           9         80   93   900 552 162 39     109         38           9     80 93   900
3309820 MO     school 2929280 115115   ST. LOUIS CITY 292928002646 6030 WILKINSON EARLY CHILDHOOD CTR.   Regular School No Elementary PK 02 2019   k_12_total 47 107 8 *   *       * *           9         *   28   165 47 107 8                           9       28   165
3309925 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   k_12_total * 202 9 *   *       * *           9         *   33   214   202 9                           9       33   214
3309724 MO     school 2929280 115115   ST. LOUIS CITY 292928001968 5260 MANN ELEM.   Regular School No Elementary PK 06 2019   k_12_total 47 144 36 *   26       * *           89         *   43   253 47 144 36     26                     89       43   253
3307562 MO     school 2923580 96095   PARKWAY C-2 292358001386 4110 HANNA WOODS ELEM.   Regular School No Elementary PK 05 2019   k_12_total 274 50 25 *   75       * 33           88         121   79   458 274 50 25     75         33           88     121 79   458
3307924 MO     school 2926640 96110   RITENOUR 292664001567 3000 HOECH MIDDLE   Regular School No Middle 06 08 2019   k_12_total 205 322 166 *   15       * 65           88         *   143   774 205 322 166     15         65           88       143   774
3309473 MO     school 2929280 115115   ST. LOUIS CITY 292928001994 1680 ROOSEVELT HIGH   Regular School No High 09 12 2019   k_12_total 54 343 38 *   9       * *           88         *   92   444 54 343 38     9                     88       92   444
3309430 MO     school 2929280 115115   ST. LOUIS CITY 292928001882 1250 BEAUMONT CTE HIGH SCHOOL   Regular School No High 09 12 2019   k_12_total 37 323 37 *   15       * *           86         *   32   412 37 323 37     15                     86       32   412
3296982 MO     school 2921120 5128   MONETT R-I 292112000183 3000 MONETT MIDDLE   Regular School No Middle 07 08 2019   k_12_total 211 * 159 *   14       * 7           85         270   83   400 211   159     14         7           85     270 83   400
3297622 MO     school 2927060 11082   ST. JOSEPH 292706001648 1075 CENTRAL HIGH   Regular School No High 09 12 2019   k_12_total 1245 118 160 *   55       15 84           84         634.3   232   1681 1245 118 160     55       15 84           84       232   1681
3302716 MO     school 2907460 49142   CARTHAGE R-IX 290746000209 5000 MARK TWAIN ELEM.   Regular School No Elementary KG 04 2019   k_12_total 192 5 90 *   *       * 8           84         189   30   303 192 5 90               8           84     189 30   303
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
3301997 MO     school 2915480 48077   INDEPENDENCE 30 291548003096 1090 VAN HORN HIGH   Regular School No High 09 12 2019   k_12_total 491 135 319 5   7       6 73           83         751   103   1036 491 135 319 5   7       6 73           83     751 103   1036
3307048 MO     school 2923700 96090   PATTONVILLE R-III 292370002848 5060 ROBERT DRUMMOND ELEM.   Regular School No Elementary PK 05 2019   k_12_total 225 343 93 *   13       * 68           83         494   109   746 225 343 93     13         68           83     494 109   746
3309754 MO     school 2929280 115115   ST. LOUIS CITY 292928000798 5590 MULLANPHY BOTANICAL GARDENS   Regular School No Elementary PK 05 2019   k_12_total 33 294 40 *   14       * *           83         *   69   381 33 294 40     14                     83       69   381
3309978 MO     school 2900592 115916   GATEWAY SCIENCE ACAD/ST LOUIS 290059203241 6997 GATEWAY SCIENCE ACAD-SOUTH ELE   Regular School Yes Elementary KG 05 2019   k_12_total 256 115 30 *   17       * 42           83         285   60   460 256 115 30     17         42           83     285 60   460
3304688 MO     school 2921810 73108   NEOSHO SCHOOL DISTRICT 292181001209 1050 NEOSHO HIGH   Regular School No High 09 12 2019   k_12_total 902 15 180 42   17       68 52           82         557.1   113   1276 902 15 180 42   17       68 52           82       113   1276
3299182 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280002730 3200 NORTHGATE MIDDLE   Regular School No Middle 07 08 2019   k_12_total 233 103 131 *   47       24 73           81         423.4   67   613 233 103 131     47       24 73           81       67   613
3304712 MO     school 2921810 73108   NEOSHO SCHOOL DISTRICT 292181001204 4040 CENTRAL ELEM.   Regular School No Elementary KG 04 2019   k_12_total 92 * 68 *   *       40 21           81         185   43   222 92   68             40 21           81     185 43   222
3299190 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280003115 4040 BELL PRAIRIE ELEMENTARY   Regular School No Elementary PK 05 2019   k_12_total 426 66 75 *   29       10 49           80         144   43   658 426 66 75     29       10 49           80     144 43   658
3302124 MO     school 2915480 48077   INDEPENDENCE 30 291548003091 6100 THREE TRAILS ELEM.   Regular School No Elementary PK 05 2019   k_12_total 189 65 138 *   *       * 27           80         342   34   424 189 65 138               27           80     342 34   424
3297054 MO     school 2917850 6104   LAMAR R-I 291785000953 4020 LAMAR ELEM.   Regular School No Elementary 03 05 2019   k_12_total 216 * 14 5   *       * 16           8         156   50   254 216   14 5             16           8     156 50   254
3297200 MO     school 2909900 8111   COLE CAMP R-I 290990000292 4020 COLE CAMP ELEM.   Regular School No Elementary KG 04 2019   k_12_total 245 * 10 *   *       * 8           8         158   49   263 245   10               8           8     158 49   263
3297435 MO     school 2901000 10093   COLUMBIA 93 290100001946 3060 JOHN B. LANGE MIDDLE   Regular School No Middle 06 08 2019   k_12_total 285 222 45 *   17       * 65           8         398   66   640 285 222 45     17         65           8     398 66   640
3297664 MO     school 2927060 11082   ST. JOSEPH 292706001650 4060 ELLISON ELEM.   Regular School No Elementary KG 06 2019   k_12_total 271 21 11 *   7       * 24           8         146   30   335 271 21 11     7         24           8     146 30   335
3298811 MO     school 2909780 22092   CLEVER R-V 290978000281 4020 CLEVER ELEM.   Regular School No Elementary PK 08 2019   k_12_total 762 11 21 *   *       * 16           8         372   84   815 762 11 21               16           8     372 84   815
3299090 MO     school 2918540 24090   LIBERTY 53 291854002804 4140 SHOAL CREEK ELEM.   Regular School No Elementary KG 05 2019   k_12_total 783 27 32 *   27       * 44           8         62   53   914 783 27 32     27         44           8     62 53   914
3299176 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001282 3180 NEW MARK MIDDLE   Regular School No Middle 07 08 2019   k_12_total 576 83 76 *   17       * 78           8         198.1   58   833 576 83 76     17         78           8       58   833
3299238 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280002621 4200 FOX HILL ELEM.   Regular School No Elementary KG 05 2019   k_12_total 414 75 67 *   6       * 87           8         229   64   653 414 75 67     6         87           8     229 64   653
3299952 MO     school 2909120 35097   CLARKTON C-4 290912000269 1050 CLARKTON HIGH   Regular School No High 06 12 2019   k_12_total 121 15 30 *   *       * 5           8         *   24   172 121 15 30               5           8       24   172
3300384 MO     school 2932010 39133   WILLARD R-II 293201002773 4060 WILLARD EAST ELEM.   Regular School No Elementary PK 04 2019   k_12_total 304 6 7 *   *       * 7           8         124   39   326 304 6 7               7           8     124 39   326
3300597 MO     school 2928860 39141   SPRINGFIELD R-XII 292886002680 3120 PLEASANT VIEW MIDDLE   Regular School No Middle 06 08 2019   k_12_total 267 18 20 *   *       * 18           8         179   42   327 267 18 20               18           8     179 42   327
3300759 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001821 4580 ROUNTREE ELEM.   Regular School No Elementary KG 05 2019   k_12_total 205 17 9 *   9       * 17           8         121   28   257 205 17 9     9         17           8     121 28   257
3300831 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001838 4840 YORK ELEM.   Regular School No Elementary PK 05 2019   k_12_total 176 17 11 *   *       * 21           8         187   23   230 176 17 11               21           8     187 23   230
3301666 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830000979 4080 MASON ELEM.   Regular School No Elementary KG 06 2019   k_12_total 424 30 10 *   8       * 18           8         72   52   490 424 30 10     8         18           8     72 52   490
3301702 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830000544 5035 TRAILRIDGE ELEM.   Regular School No Elementary KG 06 2019   k_12_total 375 67 9 *   13       * 19           8         70   45   488 375 67 9     13         19           8     70 45   488
3302186 MO     school 2916400 48078   KANSAS CITY 33 291640003322 3050 LINCOLN COLLEGE ACADEMY MIDDLE   Regular School No Middle 06 08 2019   k_12_total 75 121 122 *   30       9 8           8         *   5   367 75 121 122     30       9 8           8       5   367
3302495 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001702753 6940 ACADEMIE LAFAYETTE-OAK   Regular School Yes Elementary KG 05 2019   k_12_total 287 109 13 *   *       * 46           8         101   32   461 287 109 13               46           8     101 32   461
3303097 MO     school 2932100 50010   WINDSOR C-1 293210002868 4030 WINDSOR ELEM.   Regular School No Elementary KG 02 2019   k_12_total 376 10 5 *   *       * *           8         140   55   392 376 10 5                           8     140 55   392
3303121 MO     school 2912300 50012   FOX C-6 291230000500 2050 FOX MIDDLE   Regular School No Middle 06 08 2019   k_12_total 638 13 21 *   7       * 27           8         249   141   706 638 13 21     7         27           8     249 141   706
3303324 MO     school 2916830 51155   KNOB NOSTER R-VIII 291683000931 4020 KNOB NOSTER ELEM.   Regular School No Elementary KG 04 2019   k_12_total 293 20 13 *   *       * 16           8         144   45   352 293 20 13               16           8     144 45   352
3303433 MO     school 2918270 53113   LEBANON R-III 291827000975 4020 JOE D. ESTHER ELEM.   Regular School No Elementary PK 01 2019   k_12_total 546 8 11 *   *       * 25           8         390   102   594 546 8 11               25           8     390 102   594
3303513 MO     school 2903000 54042   SANTA FE R-X 290300000013 1050 SANTA FE HIGH   Regular School No High 07 12 2019   k_12_total 143 * 19 *   *       * *           8         58   13   162 143   19                           8     58 13   162
3304301 MO     school 2927630 66105   SCHOOL OF THE OSAGE 292763001696 4020 HERITAGE ELEMENTARY   Regular School No Elementary PK 02 2019   k_12_total 379 5 16 *   *       * 23           8         217   82   430 379 5 16               23           8     217 82   430
3305407 MO     school 2925230 83003   PLATTE CO. R-III 292523003288 4060 COMPASS ELEMENTARY   Regular School No Elementary PK 05 2019   k_12_total 521 17 46 *   *       11 35           8         151   67   632 521 17 46             11 35           8     151 67   632
3305594 MO     school 2920160 84005   MARION C. EARLY R-V 292016001072 4020 MARION C. EARLY ELEM.   Regular School No Elementary PK 05 2019   k_12_total 245 * * *   *       * 6           8         156   30   256 245                   6           8     156 30   256
3306195 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895001884 3300 SAEGER MIDDLE   Regular School No Middle 06 08 2019   k_12_total 602 53 28 *   12       * 24           8         143   95   719 602 53 28     12         24           8     143 95   719
3306369 MO     school 2931650 92089   WENTZVILLE R-IV 293165002903 4100 PEINE RIDGE ELEM.   Regular School No Elementary KG 06 2019   k_12_total 520 85 17 *   8       * 35           8         128   94   665 520 85 17     8         35           8     128 94   665
3306579 MO     school 2911910 94078   FARMINGTON R-VII 291191002847 4060 ROOSEVELT ELEM.   Regular School No Elementary 01 04 2019   k_12_total 413 10 13 *   *       * 9           8         252   44   449 413 10 13               9           8     252 44   449
3306827 MO     school 2913830 96088   HAZELWOOD 291383000636 4260 TWILLMAN ELEM.   Regular School No Elementary PK 05 2019   k_12_total * 386 5 *   *       * *           8         *   77   394   386 5                           8       77   394
3306845 MO     school 2913830 96088   HAZELWOOD 291383000613 4320 ARMSTRONG ELEM.   Regular School No Elementary KG 05 2019   k_12_total 67 303 14 *   *       * 16           8         292   53   402 67 303 14               16           8     292 53   402
3307168 MO     school 2926850 96091   ROCKWOOD R-VI 292685001619 4100 EUREKA ELEM.   Regular School No Elementary KG 05 2019   k_12_total 353 24 9 *   5       * 9           8         52   67   401 353 24 9     5         9           8     52 67   401
3307300 MO     school 2916770 96092   KIRKWOOD R-VII 291677000928 6020 WESTCHESTER ELEM.   Regular School No Elementary KG 05 2019   k_12_total 425 31 24 *   9       * 29           8         40   78   521 425 31 24     9         29           8     40 78   521
3307453 MO     school 2920670 96094   MEHLVILLE R-IX 292067003320 5080 MOSAIC ELEMENTARY   Regular School No Elementary KG 05 2019   k_12_total 220 * 6 *   7       * 16           8         36   33   253 220   6     7         16           8     36 33   253
3307544 MO     school 2923580 96095   PARKWAY C-2 292358001380 4040 CLAYMONT ELEM.   Regular School No Elementary PK 05 2019   k_12_total 395 60 11 *   19       * 20           8         68   88   505 395 60 11     19         20           8     68 88   505
3307684 MO     school 2905880 96101   BRENTWOOD 290588001113 3000 BRENTWOOD MIDDLE   Regular School No Middle 06 08 2019   k_12_total 106 41 12 *   8       * 11           8         51   23   178 106 41 12     8         11           8     51 23   178
3307711 MO     school 2909720 96102   CLAYTON 290972002584 3000 WYDOWN MIDDLE   Regular School No Middle 06 08 2019   k_12_total 417 102 29 *   81       * 41           8         52   78   671 417 102 29     81         41           8     52 78   671
3307878 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265001244 3000 7th and 8th Grade Center   Regular School No Middle 07 08 2019   k_12_total 8 422 9 *   *       * 5           8         461   59   446 8 422 9               5           8     461 59   446
3307976 MO     school 2926670 96111   RIVERVIEW GARDENS 292667001586 1050 RIVERVIEW GARDENS SR. HIGH   Regular School No High 09 12 2019   k_12_total 9 1153 5 *   *       * *           8         1114.2   211   1171 9 1153 5                           8       211   1171
3307994 MO     school 2926670 96111   RIVERVIEW GARDENS 292667002687 4040 WESTVIEW MIDDLE   Regular School No Middle 06 08 2019   k_12_total * 536 5 *   *       * *           8         *   105   546   536 5                           8       105   546
3308114 MO     school 2931530 96114   WEBSTER GROVES 293153002197 1050 WEBSTER GROVES HIGH   Regular School No High 09 12 2019   k_12_total 1027 252 54 *   32       * 47           8         215   200   1414 1027 252 54     32         47           8     215 200   1414
3308715 MO     school 2926160 104044   REEDS SPRING R-IV 292616003034 4030 REEDS SPRING ELEM.   Regular School No Elementary 02 04 2019   k_12_total 364 * 18 *   *       * 13           8         255   65   397 364   18               13           8     255 65   397

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