enrollments

Data source: Big Local News · About: Big Local

2,295 rows where grade = "k_12_total", state = "MO" and year = 2017 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 2,295 ✖

grade ✖

  • k_12_total · 2,295 ✖
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
3308429 3308429 MO     school 2928260 100063   SIKESTON R-6 292826001741 3050 5TH AND 6TH GRADE CTR.   Regular School No Middle 05 06 2017   k_12_total 302 166 17 *   *       * 40           *         350   66   529 302 166 17               40                 350 66   529
3305668 3305668 MO     school 2931440 85046   WAYNESVILLE R-VI 293144003207 3010 6TH GRADE CENTER   Regular School No Middle 06 06 2017   k_12_total 229 78 55 5   11       9 37           14         194.3   66   424 229 78 55 5   11       9 37           14       66   424
3308423 3308423 MO     school 2928260 100063   SIKESTON R-6 292826001737 2050 7TH AND 8TH GRADE CTR.   Regular School No Middle 07 08 2017   k_12_total 276 162 28 *   8       * 33           *         319   52   507 276 162 28     8         33                 319 52   507
3307876 3307876 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265001244 3000 7th and 8th Grade Center   Regular School No Middle 07 08 2017   k_12_total 5 409 * *   *       * *           *         498   51   419 5 409                                   498 51   419
3304176 3304176 MO     school 2913650 64075   HANNIBAL 60 291365000587 4020 A. D. STOWELL ELEM.   Regular School No Elementary PK 05 2017   k_12_total 259 15 7 *   *       * 16           *         194.2   55   300 259 15 7               16                   55   300
3304335 3304335 MO     school 2911220 67055   EAST PRAIRIE R-II 291122000385 4060 A. J. MARTIN ELEM.   Regular School No Elementary 03 06 2017   k_12_total 331 13 11 *   *       * 9           *         262   66   366 331 13 11               9                 262 66   366
3302134 3302134 MO     school 2915480 48077   INDEPENDENCE 30 291548003210 6130 ABRAHAM MALLINSON ELEMENTARY   Regular School No Elementary 02 05 2017   k_12_total 229 25 91 *   *       * 28           43         346   41   378 229 25 91               28           43     346 41   378
3302328 3302328 MO     school 2916400 48078   KANSAS CITY 33 291640001718 5670 AC PREP ELEMENTARY   Regular School No Elementary PK 07 2017   k_12_total 5 343 * *   *       * *           *         *   37   355 5 343                                     37   355
3309680 3309680 MO     school 2929280 115115   ST. LOUIS CITY 292928003211 4990 ACAD OF ENVT SCI/MATH ELEM   Regular School No Elementary PK 05 2017   k_12_total * 237 * *   *       * *           *         *   16   238   237                                     16   238
3309534 3309534 MO     school 2929280 115115   ST. LOUIS CITY 292928003215 3250 ACAD OF ENVT SCI/MATH MIDDLE   Regular School No Middle 06 08 2017   k_12_total 5 173 * *   *       * *           *         *   31   180 5 173                                     31   180
3302499 3302499 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001703259 6941 ACADEMIE LAFAYETTE-CHERRY   Regular School Yes Elementary KG 03 2017   k_12_total 307 86 18 *   6       * 45           10         108   22   464 307 86 18     6         45           10     108 22   464
3302493 3302493 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001702753 6940 ACADEMIE LAFAYETTE-OAK   Regular School Yes Elementary 04 08 2017   k_12_total 315 78 26 *   17       * 35           18         89   31   472 315 78 26     17         35           18     89 31   472
3302600 3302600 MO     school 2900604 48927   ACADEMY FOR INTEGRATED ARTS 290060403209 6995 ACADEMY FOR INTEGRATED ARTS   Regular School Yes Elementary PK 06 2017   k_12_total 14 132 5 8   *       * 12           *         *   11   172 14 132 5 8             12                   11   172
3308208 3308208 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001588 4029 ACKERMAN SCH.   Regular School No Elementary KG 08 2017   k_12_total 35 110 * *   *       * 5           *         *   *   152 35 110                 5                       152
3296687 3296687 MO     school 2922980 1090   ADAIR CO. R-I 292298001314 4020 ADAIR CO. ELEM.   Regular School No Elementary PK 06 2017   k_12_total 113 * * *   *       * *           *         72   11   114 113                                     72 11   114
3296723 3296723 MO     school 2905790 1092   ADAIR CO. R-II 290579000124 4020 ADAIR CO. ELEM.   Regular School No Elementary KG 06 2017   k_12_total 89 * * *   *       * *           *         45   15   95 89                                     45 15   95
3296681 3296681 MO     school 2922980 1090   ADAIR CO. R-I 292298001315 1050 ADAIR CO. HIGH   Regular School No High 07 12 2017   k_12_total 115 * * *   *       * *           *         65   18   116 115                                     65 18   116
3296717 3296717 MO     school 2905790 1092   ADAIR CO. R-II 290579000125 1050 ADAIR CO. HIGH   Regular School No High 07 12 2017   k_12_total 76 * * *   *       * *           *         33   19   80 76                                     33 19   80
3309552 3309552 MO     school 2929280 115115   ST. LOUIS CITY 292928002789 4000 ADAMS ELEM.   Regular School No Elementary PK 06 2017   k_12_total 7 243 * *   *       * *           *         *   35   250 7 243                                     35   250
3298301 3298301 MO     school 2907380 17125   CARROLLTON R-VII 290738003131 4000 ADAMS PRIMARY SCHOOL   Regular School No Elementary PK 01 2017   k_12_total 138 * * *   *       * *           *         71   18   141 138                                     71 18   141
3297094 3297094 MO     school 2902850 7123   ADRIAN R-III 290285000001 4020 ADRIAN ELEM.   Regular School No Elementary PK 05 2017   k_12_total 325 * * *   *       * *           *         145   36   328 325                                     145 36   328
3297088 3297088 MO     school 2902850 7123   ADRIAN R-III 290285000002 1050 ADRIAN SR. HIGH   Regular School No Other 06 12 2017   k_12_total 346 * * *   *       * *           *         107   33   353 346                                     107 33   353
3308567 3308567 MO     school 2902880 103129   ADVANCE R-IV 290288000003 4020 ADVANCE ELEM.   Regular School No Elementary PK 06 2017   k_12_total 220 * 8 *   *       * *           *         141   32   228 220   8                                 141 32   228
3308561 3308561 MO     school 2902880 103129   ADVANCE R-IV 290288000004 1050 ADVANCE HIGH   Regular School No High 07 12 2017   k_12_total 187 * * *   *       * *           *         93   9   191 187                                     93 9   191
3307634 3307634 MO     school 2902910 96098   AFFTON 101 290291000009 1050 AFFTON HIGH   Regular School No High 09 12 2017   k_12_total 613 78 32 *   22       * 53           22         267   86   799 613 78 32     22         53           22     267 86   799
3306910 3306910 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201000449 4010 AIRPORT ELEM.   Regular School No Elementary KG 05 2017   k_12_total * 226 * *   *       * *           *         *   33   229   226                                     33   229
3300334 3300334 MO     school 2902970 38046   ALBANY R-III 290297000010 1050 ALBANY HIGH   Regular School No High 09 12 2017   k_12_total 104 * * *   *       * *           *         62.4   13   107 104                                       13   107
3300340 3300340 MO     school 2902970 38046   ALBANY R-III 290297001478 3000 ALBANY MIDDLE   Regular School No Middle 06 08 2017   k_12_total 99 * * *   *       * 6           *         66   13   105 99                   6                 66 13   105
3299052 3299052 MO     school 2918540 24090   LIBERTY 53 291854001004 4020 ALEXANDER DONIPHAN ELEM.   Regular School No Elementary KG 05 2017   k_12_total 281 11 19 *   8       * 13           *         54   38   333 281 11 19     8         13                 54 38   333
3308313 3308313 MO     school 2928360 97130   SLATER 292836001749 4020 ALEXANDER ELEM.   Regular School No Elementary PK 08 2017   k_12_total 187 12 9 *   *       * 18           *         *   29   226 187 12 9               18                   29   226
3305460 3305460 MO     school 2923550 83005   PARK HILL 292355001366 4080 ALFRED L. RENNER ELEM.   Regular School No Elementary KG 05 2017   k_12_total 269 44 57 *   22       13 35           40         165   74   442 269 44 57     22       13 35           40     165 74   442
3302451 3302451 MO     school 2900025 48909   ALLEN VILLAGE 290002503233 1980 ALLEN VILLAGE HIGH SCHOOL   Regular School Yes High 09 12 2017   k_12_total * 58 94 *   5       * *           5         145   10   162   58 94     5                     5     145 10   162
3302461 3302461 MO     school 2900025 48909   ALLEN VILLAGE 290002502748 6915 ALLEN VILLAGE SCHOOL   Regular School Yes Elementary KG 08 2017   k_12_total 16 152 258 *   15       * 10           105         416   32   451 16 152 258     15         10           105     416 32   451
3298211 3298211 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712000184 4020 ALMA SCHRADER ELEM.   Regular School No Elementary KG 04 2017   k_12_total 314 40 11 *   14       * 22           12         133   53   401 314 40 11     14         22           12     133 53   401
3297445 3297445 MO     school 2901000 10093   COLUMBIA 93 290100003152 4030 ALPHA HART LEWIS   Regular School No Elementary PK 05 2017   k_12_total 204 153 21 *   *       * 55           *         *   61   441 204 153 21               55                   61   441
3302409 3302409 MO     school 2900029 48902   ALTA VISTA CHARTER SCH. 290002902741 1925 ALTA VISTA CHARTER SCHOOL   Regular School Yes High 09 12 2017   k_12_total * 23 334 *   *       * 7           254         332   31   370   23 334               7           254     332 31   370
3302421 3302421 MO     school 2900029 48902   ALTA VISTA CHARTER SCH. 290002903216 6905 ALTA VISTA ELEMENTARY SCHOOL   Regular School Yes Elementary KG 04 2017   k_12_total * 7 320 *   *       * 20           301         330   54   351   7 320               20           301     330 54   351
3302415 3302415 MO     school 2900029 48902   ALTA VISTA CHARTER SCH. 290002903166 3925 ALTA VISTA MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   k_12_total 5 * 186 *   *       * 7           152         *   17   202 5   186               7           152       17   202
3305090 3305090 MO     school 2903040 79078   ALTENBURG 48 290304000014 4020 ALTENBURG ELEM.   Regular School No Elementary KG 08 2017   k_12_total 98 * * *   *       * *           *         29   14   100 98                                     29 14   100
3310433 3310433 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901287 1084 ALTERNATIVE RESOURCE CTR.   Alternative School No Other 06 12 2017   k_12_total * * * *   *       * *           *         *   *   5                                             5
3296765 3296765 MO     school 2927570 2097   SAVANNAH R-III 292757001688 4010 AMAZONIA ELEM.   Regular School No Elementary PK 05 2017   k_12_total 90 * * *   *       * *           *         52   13   93 90                                     52 13   93
3309576 3309576 MO     school 2929280 115115   ST. LOUIS CITY 292928002570 4250 AMES VISUAL/PERF. ARTS   Regular School No Elementary PK 05 2017   k_12_total * 332 * *   *       * *           *         *   42   338   332                                     42   338
3303946 3303946 MO     school 2920610 60077   MCDONALD CO. R-I 292061001100 4020 ANDERSON ELEM.   Regular School No Elementary PK 05 2017   k_12_total 382 * 50 14   *       18 9           43         308   99   478 382   50 14           18 9           43     308 99   478
3303940 3303940 MO     school 2920610 60077   MCDONALD CO. R-I 292061003007 3000 ANDERSON MIDDLE   Regular School No Middle 06 08 2017   k_12_total 216 * 22 7   *       * 6           8         140   54   255 216   22 7             6           8     140 54   255
3297421 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
3299154 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
3303143 3303143 MO     school 2912300 50012   FOX C-6 291230000497 4010 ANTONIA ELEM.   Regular School No Elementary KG 05 2017   k_12_total 551 * 9 *   *       * 12           *         159   75   573 551   9               12                 159 75   573
3303137 3303137 MO     school 2912300 50012   FOX C-6 291230003151 2200 ANTONIA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   k_12_total 461 * 5 *   *       * 13           *         142   67   483 461   5               13                 142 67   483
3306487 3306487 MO     school 2903120 93120   APPLETON CITY R-II 290312000017 4010 APPLETON CITY ELEM.   Regular School No Elementary PK 05 2017   k_12_total 135 * * *   *       * *           *         91   27   142 135                                     91 27   142
3306481 3306481 MO     school 2903120 93120   APPLETON CITY R-II 290312000019 1050 APPLETON CITY HIGH   Regular School No Other 06 12 2017   k_12_total 180 * 8 5   *       * *           *         112   28   196 180   8 5                               112 28   196
3301327 3301327 MO     school 2903150 47062   ARCADIA VALLEY R-II 290315000021 4020 ARCADIA VALLEY ELEM.   Regular School No Elementary PK 04 2017   k_12_total 319 7 * *   *       * 6           *         226.4   74   335 319 7                 6                   74   335
3301315 3301315 MO     school 2903150 47062   ARCADIA VALLEY R-II 290315000022 1050 ARCADIA VALLEY HIGH   Regular School No High 09 12 2017   k_12_total 330 * * *   *       * 5           *         193   54   344 330                   5                 193 54   344
3301321 3301321 MO     school 2903150 47062   ARCADIA VALLEY R-II 290315000023 3000 ARCADIA VALLEY MIDDLE   Regular School No Middle 05 08 2017   k_12_total 277 6 * *   *       * *           *         186   63   290 277 6                                   186 63   290
3298355 3298355 MO     school 2903200 19139   ARCHIE R-V 290320000025 1050 ARCHIE HIGH   Regular School No Other 06 12 2017   k_12_total 282 7 * *   *       * *           *         66   26   297 282 7                                   66 26   297
3306843 3306843 MO     school 2913830 96088   HAZELWOOD 291383000613 4320 ARMSTRONG ELEM.   Regular School No Elementary KG 05 2017   k_12_total 101 333 14 *   *       * 17           19         318   53   468 101 333 14               17           19     318 53   468
3306849 3306849 MO     school 2913830 96088   HAZELWOOD 291383002858 4340 ARROWPOINT ELEM.   Regular School No Elementary PK 05 2017   k_12_total 8 543 5 *   *       * 10           *         488   83   568 8 543 5               10                 488 83   568
3300455 3300455 MO     school 2903270 39135   ASH GROVE R-IV 290327000027 4020 ASH GROVE ELEM.   Regular School No Elementary PK 03 2017   k_12_total 182 * * *   *       * *           *         97   20   190 182                                     97 20   190
3300449 3300449 MO     school 2903270 39135   ASH GROVE R-IV 290327000028 1050 ASH GROVE HIGH   Regular School No High 07 12 2017   k_12_total 334 * 6 *   *       * *           *         148   45   349 334   6                                 148 45   349
3309558 3309558 MO     school 2929280 115115   ST. LOUIS CITY 292928001877 4060 ASHLAND ELEM. AND BR.   Regular School No Elementary PK 06 2017   k_12_total * 264 * *   *       * *           *         *   28   267   264                                     28   267
3309884 3309884 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903014 6931 ASPIRE ACADEMY   Regular School Yes Elementary PK 06 2017   k_12_total * 552 * *   *       * *           *         *   40   558   552                                     40   558
3303238 3303238 MO     school 2910500 50014   DESOTO 73 291050000347 4010 ATHENA ELEM.   Regular School No Elementary KG 06 2017   k_12_total 576 8 12 *   *       * *           *         337   107   602 576 8 12                                 337 107   602
3304000 3304000 MO     school 2903480 61150   ATLANTA C-3 290348000029 4020 ATLANTA ELEM.   Regular School No Elementary KG 06 2017   k_12_total 106 * * *   *       * *           *         59   9   106 106                                     59 9   106
3303994 3303994 MO     school 2903480 61150   ATLANTA C-3 290348000030 1050 ATLANTA HIGH   Regular School No High 07 12 2017   k_12_total 82 * * *   *       * *           *         35   11   82 82                                     35 11   82
3300219 3300219 MO     school 2931110 36139   WASHINGTON 293111002156 4020 AUGUSTA ELEM.   Regular School No Elementary KG 06 2017   k_12_total 134 * * *   *       * *           *         42   11   141 134                                     42 11   141
3303625 3303625 MO     school 2904020 55110   AURORA R-VIII 290402000031 1050 AURORA HIGH   Regular School No High 09 12 2017   k_12_total 539 7 61 5   *       * *           9         336   72   616 539 7 61 5                         9     336 72   616
3303631 3303631 MO     school 2904020 55110   AURORA R-VIII 290402001517 2050 AURORA JR. HIGH   Regular School No Middle 07 08 2017   k_12_total 258 5 37 5   *       * *           9         205   43   308 258 5 37 5                         9     205 43   308
3310186 3310186 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203064 9040 AUTUMN HILL SCHOOL   Special Education School No Other KG 12 2017   k_12_total 26 * * *   *       * *           *         *   *   28 26                                           28
3297930 3297930 MO     school 2922740 14126   NORTH CALLAWAY CO. R-I 292274001252 4020 AUXVASSE ELEM.   Regular School No Elementary PK 08 2017   k_12_total 274 * 11 *   *       * 10           *         172.4   42   299 274   11               10                   42   299
3299908 3299908 MO     school 2904050 34124   AVA R-I 290405000034 4020 AVA ELEM.   Regular School No Elementary PK 04 2017   k_12_total 448 * 8 *   *       * 6           *         343   73   462 448   8               6                 343 73   462
3299896 3299896 MO     school 2904050 34124   AVA R-I 290405000036 1050 AVA HIGH   Regular School No High 09 12 2017   k_12_total 393 * 7 *   *       * *           *         220   52   405 393   7                                 220 52   405
3299902 3299902 MO     school 2904050 34124   AVA R-I 290405002548 3000 AVA MIDDLE   Regular School No Middle 05 08 2017   k_12_total 381 * 10 *   *       * *           *         282   55   396 381   10                                 282 55   396
3296747 3296747 MO     school 2904080 2090   AVENUE CITY R-IX 290408000037 4020 AVENUE CITY ELEM.   Regular School No Elementary PK 08 2017   k_12_total 141 * * *   *       * 6           *         24   7   151 141                   6                 24 7   151
3308124 3308124 MO     school 2931530 96114   WEBSTER GROVES 293153002190 4020 AVERY ELEM.   Regular School No Elementary KG 05 2017   k_12_total 398 78 8 *   7       * 25           5         105   66   517 398 78 8     7         25           5     105 66   517
3302648 3302648 MO     school 2904110 49135   AVILLA R-XIII 290411000038 4020 AVILLA ELEM.   Regular School No Elementary KG 08 2017   k_12_total 117 * 9 *   *       * 7           7         83   11   134 117   9               7           7     83 11   134
3304874 3304874 MO     school 2903060 75087   ALTON R-IV 290306000015 4020 Alton Elementary   Regular School No Elementary PK 06 2017   k_12_total 336 * 7 5   *       * *           *         232.4   69   351 336   7 5                                 69   351
3304868 3304868 MO     school 2903060 75087   ALTON R-IV 290306000016 1050 Alton High   Regular School No High 07 12 2017   k_12_total 294 * * *   *       * *           *         170   62   301 294                                     170 62   301
3310144 3310144 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203057 9023 B W ROBINSON SCHOOL   Special Education School No Other KG 12 2017   k_12_total 39 * * *   *       * *           *         17   *   47 39                                     17     47
3302473 3302473 MO     school 2900011 48911   B. BANNEKER ACADEMY 290001102750 6925 B. BANNEKER ACADEMY   Regular School Yes Elementary PK 08 2017   k_12_total * 340 * *   *       * 7           *         *   27   348   340                 7                   27   348
3302292 3302292 MO     school 2916400 48078   KANSAS CITY 33 291640002602 5440 B. BANNEKER ELEM.   Regular School No Elementary PK 06 2017   k_12_total 11 319 13 *   *       * *           5         *   59   350 11 319 13                           5       59   350
3307208 3307208 MO     school 2926850 96091   ROCKWOOD R-VI 292685002566 4145 BABLER ELEM.   Regular School No Elementary KG 05 2017   k_12_total 427 52 16 *   34       * 16           15         63   78   545 427 52 16     34         16           15     63 78   545
3310370 3310370 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901271 1070 BABLER LODGE   Regular School No Other 06 12 2017   k_12_total * 8 * *   *       * *           *         *   *   12   8                                         12
3304929 3304929 MO     school 2904140 77101   BAKERSFIELD R-IV 290414000039 4020 BAKERSFIELD ELEM.   Regular School No Elementary PK 05 2017   k_12_total 143 * * *   *       * *           *         111   34   148 143                                     111 34   148
3304923 3304923 MO     school 2904140 77101   BAKERSFIELD R-IV 290414000040 1050 BAKERSFIELD HIGH   Regular School No Other 06 12 2017   k_12_total 193 * * *   *       * *           *         116   43   195 193                                     116 43   195
3297082 3297082 MO     school 2904170 7122   BALLARD R-II 290417000041 4020 BALLARD ELEM.   Regular School No Elementary PK 06 2017   k_12_total 66 * * *   *       * *           *         43   14   72 66                                     43 14   72
3297076 3297076 MO     school 2904170 7122   BALLARD R-II 290417000042 1050 BALLARD HIGH   Regular School No High 07 12 2017   k_12_total 52 * * *   *       * *           *         22.3   9   56 52                                       9   56
3307136 3307136 MO     school 2926850 96091   ROCKWOOD R-VI 292685001614 4020 BALLWIN ELEM.   Regular School No Elementary KG 05 2017   k_12_total 338 53 36 *   54       * 25           26         112   93   507 338 53 36     54         25           26     112 93   507
3307881 3307881 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265003189 4010 BARACK OBAMA ELEMENTARY SCHOOL   Regular School No Elementary 01 06 2017   k_12_total * 398 * *   *       * *           *         459   41   406   398                                   459 41   406
3308064 3308064 MO     school 2930660 96112   UNIVERSITY CITY 293066002105 4060 BARBARA JORDAN ELEM.   Regular School No Elementary KG 05 2017   k_12_total 8 321 25 *   5       * *           20         *   32   363 8 321 25     5                     20       32   363
3306175 3306175 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002307 3000 BARNWELL MIDDLE   Regular School No Middle 06 08 2017   k_12_total 614 112 60 *   44       * 34           21         226   101   867 614 112 60     44         34           21     226 101   867
3307524 3307524 MO     school 2923580 96095   PARKWAY C-2 292358001375 4020 BARRETTS ELEM.   Regular School No Elementary PK 05 2017   k_12_total 290 69 8 *   14       * 17           *         73   71   398 290 69 8     14         17                 73 71   398
3306741 3306741 MO     school 2913830 96088   HAZELWOOD 291383000447 4040 BARRINGTON ELEM.   Regular School No Elementary KG 05 2017   k_12_total 46 329 * *   6       * 16           28         198   45   399 46 329       6         16           28     198 45   399
3305385 3305385 MO     school 2925230 83003   PLATTE CO. R-III 292523001451 4010 BARRY SCH.   Regular School No Middle 05 08 2017   k_12_total 192 76 46 *   20       * 18           14         122   29   355 192 76 46     20         18           14     122 29   355
3297972 3297972 MO     school 2912550 14129   FULTON 58 291255000517 4010 BARTLEY ELEM.   Regular School No Elementary KG 05 2017   k_12_total 221 11 8 *   *       * 26           *         137   42   266 221 11 8               26                 137 42   266
3307670 3307670 MO     school 2904500 96099   BAYLESS 290450000043 4020 BAYLESS ELEMENTARY   Regular School No Elementary PK 05 2017   k_12_total 561 95 32 *   96       * 30           243         510   132   814 561 95 32     96         30           243     510 132   814
3307664 3307664 MO     school 2904500 96099   BAYLESS 290450000715 2000 BAYLESS JUNIOR HIGH   Regular School No Middle 06 08 2017   k_12_total 229 63 17 *   47       * 17           38         258   77   374 229 63 17     47         17           38     258 77   374
3307658 3307658 MO     school 2904500 96099   BAYLESS 290450000044 1050 BAYLESS SENIOR HIGH   Regular School No High 09 12 2017   k_12_total 304 64 18 *   64       * 17           25         271.3   73   467 304 64 18     64         17           25       73   467
3307400 3307400 MO     school 2920670 96094   MEHLVILLE R-IX 292067001109 4020 BEASLEY ELEM.   Regular School No Elementary KG 05 2017   k_12_total 310 59 33 *   10       * 19           60         217   53   433 310 59 33     10         19           60     217 53   433
3300105 3300105 MO     school 2930570 36131   UNION R-XI 293057002097 4020 BEAUFORT ELEM.   Regular School No Elementary KG 06 2017   k_12_total 399 * 7 *   *       * *           *         157   33   412 399   7                                 157 33   412
3309428 3309428 MO     school 2929280 115115   ST. LOUIS CITY 292928001882 1250 BEAUMONT CTE HIGH SCHOOL   Regular School No High 09 12 2017   k_12_total 94 424 39 *   18       * *           143         *   86   575 94 424 39     18                     143       86   575
3306205 3306205 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895001854 4020 BECKY-DAVID ELEM.   Regular School No Elementary KG 05 2017   k_12_total 679 48 36 *   35       * 42           58         137   68   841 679 48 36     35         42           58     137 68   841

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