Data source: Big Local News · About: Big Local

2,306 rows where grade = "k_12_total", state = "MO" and year = 2018 sorted by school

View and edit SQL

year

  • 2018 · 2,306

grade

  • k_12_total · 2,306
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
3308430 MO     school 2928260 100063   SIKESTON R-6 292826001741 3050 5TH AND 6TH GRADE CTR.   Regular School No Middle 05 06 2018   k_12_total 282 195 26 *   7       * 28           *         364   72   538 282 195 26     7         28                 364 72   538
3305669 MO     school 2931440 85046   WAYNESVILLE R-VI 293144003207 3010 6TH GRADE CENTER   Regular School No Middle 06 06 2018   k_12_total 281 61 36 6   10       12 50           11         220   67   456 281 61 36 6   10       12 50           11     220 67   456
3308424 MO     school 2928260 100063   SIKESTON R-6 292826001737 2050 7TH AND 8TH GRADE CTR.   Regular School No Middle 07 08 2018   k_12_total 285 158 18 *   *       * 43           *         317   51   505 285 158 18               43                 317 51   505
3307877 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265001244 3000 7th and 8th Grade Center   Regular School No Middle 07 08 2018   k_12_total 7 416 5 *   *       * *           *         474   57   433 7 416 5                                 474 57   433
3304177 MO     school 2913650 64075   HANNIBAL 60 291365000587 4020 A. D. STOWELL ELEM.   Regular School No Elementary KG 05 2018   k_12_total 231 12 7 *   *       * 15           *         190.2   45   269 231 12 7               15                   45   269
3304336 MO     school 2911220 67055   EAST PRAIRIE R-II 291122000385 4060 A. J. MARTIN ELEM.   Regular School No Elementary 03 06 2018   k_12_total 333 15 8 *   *       * 10           *         275   70   370 333 15 8               10                 275 70   370
3302135 MO     school 2915480 48077   INDEPENDENCE 30 291548003210 6130 ABRAHAM MALLINSON ELEMENTARY   Regular School No Elementary 02 05 2018   k_12_total 205 15 91 *   *       * 29           40         326   28   344 205 15 91               29           40     326 28   344
3302329 MO     school 2916400 48078   KANSAS CITY 33 291640001718 5670 AC PREP ELEMENTARY   Regular School No Elementary PK 08 2018   k_12_total * 306 * *   *       * *           *         *   18   314   306                                     18   314
3309681 MO     school 2929280 115115   ST. LOUIS CITY 292928003211 4990 ACAD OF ENVT SCI/MATH ELEM   Regular School No Elementary PK 05 2018   k_12_total * 216 * *   *       * *           *         *   15   216   216                                     15   216
3309535 MO     school 2929280 115115   ST. LOUIS CITY 292928003215 3250 ACAD OF ENVT SCI/MATH MIDDLE   Regular School No Middle 06 08 2018   k_12_total 11 268 * *   *       * *           12         *   36   286 11 268                             12       36   286
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
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
3302601 MO     school 2900604 48927   ACADEMY FOR INTEGRATED ARTS 290060403209 6995 ACADEMY FOR INTEGRATED ARTS   Regular School Yes Elementary PK 06 2018   k_12_total 14 159 * *   *       * 6           *         *   12   190 14 159                 6                   12   190
3308209 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001588 4029 ACKERMAN SCH.   Regular School No Elementary KG 08 2018   k_12_total 31 112 * *   *       * 5           *         *   *   151 31 112                 5                       151
3296688 MO     school 2922980 1090   ADAIR CO. R-I 292298001314 4020 ADAIR CO. ELEM.   Regular School No Elementary PK 06 2018   k_12_total 108 * * *   *       * *           *         78   15   109 108                                     78 15   109
3296724 MO     school 2905790 1092   ADAIR CO. R-II 290579000124 4020 ADAIR CO. ELEM.   Regular School No Elementary KG 06 2018   k_12_total 75 * * *   *       * *           *         34   13   77 75                                     34 13   77
3296682 MO     school 2922980 1090   ADAIR CO. R-I 292298001315 1050 ADAIR CO. HIGH   Regular School No High 07 12 2018   k_12_total 111 * * *   *       * *           *         66   14   112 111                                     66 14   112
3296718 MO     school 2905790 1092   ADAIR CO. R-II 290579000125 1050 ADAIR CO. HIGH   Regular School No High 07 12 2018   k_12_total 73 * * *   *       * 5           *         32   18   78 73                   5                 32 18   78
3309553 MO     school 2929280 115115   ST. LOUIS CITY 292928002789 4000 ADAMS ELEM.   Regular School No Elementary PK 06 2018   k_12_total 8 225 * *   *       * *           *         *   30   234 8 225                                     30   234
3298302 MO     school 2907380 17125   CARROLLTON R-VII 290738003131 4000 ADAMS PRIMARY SCHOOL   Regular School No Elementary PK 01 2018   k_12_total 143 * * *   *       * *           *         69   20   145 143                                     69 20   145
3297095 MO     school 2902850 7123   ADRIAN R-III 290285000001 4020 ADRIAN ELEM.   Regular School No Elementary PK 05 2018   k_12_total 303 * * *   *       * *           *         139   38   306 303                                     139 38   306
3297089 MO     school 2902850 7123   ADRIAN R-III 290285000002 1050 ADRIAN SR. HIGH   Regular School No High 06 12 2018   k_12_total 348 * * *   *       * *           *         122   24   357 348                                     122 24   357
3308568 MO     school 2902880 103129   ADVANCE R-IV 290288000003 4020 ADVANCE ELEM.   Regular School No Elementary PK 06 2018   k_12_total 226 * 7 *   *       * *           *         135   30   233 226   7                                 135 30   233
3308562 MO     school 2902880 103129   ADVANCE R-IV 290288000004 1050 ADVANCE HIGH   Regular School No High 07 12 2018   k_12_total 196 * * *   *       * *           *         88   16   201 196                                     88 16   201
3307635 MO     school 2902910 96098   AFFTON 101 290291000009 1050 AFFTON HIGH   Regular School No High 09 12 2018   k_12_total 590 78 41 *   19       * 47           33         272   86   776 590 78 41     19         47           33     272 86   776
3306911 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201000449 4010 AIRPORT ELEM.   Regular School No Elementary KG 05 2018   k_12_total * 199 * *   *       * *           *         *   24   206   199                                     24   206
3300335 MO     school 2902970 38046   ALBANY R-III 290297000010 1050 ALBANY HIGH   Regular School No High 09 12 2018   k_12_total 110 * * *   *       * *           *         61   12   114 110                                     61 12   114
3300341 MO     school 2902970 38046   ALBANY R-III 290297001478 3000 ALBANY MIDDLE   Regular School No Middle 06 08 2018   k_12_total 97 * * *   *       * *           *         61   18   100 97                                     61 18   100
3299053 MO     school 2918540 24090   LIBERTY 53 291854001004 4020 ALEXANDER DONIPHAN ELEM.   Regular School No Elementary KG 05 2018   k_12_total 293 6 18 *   8       * 10           *         47   46   336 293 6 18     8         10                 47 46   336
3308314 MO     school 2928360 97130   SLATER 292836001749 4020 ALEXANDER ELEM.   Regular School No Elementary PK 08 2018   k_12_total 183 16 5 *   *       * 15           *         *   32   219 183 16 5               15                   32   219
3305461 MO     school 2923550 83005   PARK HILL 292355001366 4080 ALFRED L. RENNER ELEM.   Regular School No Elementary KG 05 2018   k_12_total 263 51 65 *   17       11 35           40         144   72   443 263 51 65     17       11 35           40     144 72   443
3302452 MO     school 2900025 48909   ALLEN VILLAGE 290002503233 1980 ALLEN VILLAGE HIGH SCHOOL   Regular School Yes High 09 12 2018   k_12_total 5 68 100 *   9       * *           13         *   14   186 5 68 100     9                     13       14   186
3302462 MO     school 2900025 48909   ALLEN VILLAGE 290002502748 6915 ALLEN VILLAGE SCHOOL   Regular School Yes Elementary KG 08 2018   k_12_total 14 151 225 *   15       * 14           118         362   30   419 14 151 225     15         14           118     362 30   419
3298212 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712000184 4020 ALMA SCHRADER ELEM.   Regular School No Elementary KG 04 2018   k_12_total 327 39 11 *   13       * 21           13         121   59   411 327 39 11     13         21           13     121 59   411
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
3305091 MO     school 2903040 79078   ALTENBURG 48 290304000014 4020 ALTENBURG ELEM.   Regular School No Elementary KG 08 2018   k_12_total 91 * * *   *       * *           *         23   17   93 91                                     23 17   93
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
3296766 MO     school 2927570 2097   SAVANNAH R-III 292757001688 4010 AMAZONIA ELEM.   Regular School No Elementary KG 05 2018   k_12_total 88 * * *   *       * *           *         45   14   93 88                                     45 14   93
3309577 MO     school 2929280 115115   ST. LOUIS CITY 292928002570 4250 AMES VISUAL/PERF. ARTS   Regular School No Elementary PK 05 2018   k_12_total 8 326 * *   *       * *           *         *   44   336 8 326                                     44   336
3303947 MO     school 2920610 60077   MCDONALD CO. R-I 292061001100 4020 ANDERSON ELEM.   Regular School No Elementary PK 05 2018   k_12_total 373 * 49 13   *       17 8           50         324   93   465 373   49 13           17 8           50     324 93   465
3303941 MO     school 2920610 60077   MCDONALD CO. R-I 292061003007 3000 ANDERSON MIDDLE   Regular School No Middle 06 08 2018   k_12_total 218 * 25 6   *       * 6           9         156   54   260 218   25 6             6           9     156 54   260
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
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
3303144 MO     school 2912300 50012   FOX C-6 291230000497 4010 ANTONIA ELEM.   Regular School No Elementary KG 05 2018   k_12_total 514 * 10 *   *       * 11           *         128   74   537 514   10               11                 128 74   537
3303138 MO     school 2912300 50012   FOX C-6 291230003151 2200 ANTONIA MIDDLE SCHOOL   Regular School No Middle 06 08 2018   k_12_total 510 * 9 *   *       * 21           *         171   79   546 510   9               21                 171 79   546
3306488 MO     school 2903120 93120   APPLETON CITY R-II 290312000017 4010 APPLETON CITY ELEM.   Regular School No Elementary PK 05 2018   k_12_total 147 * * *   *       * *           *         88   30   153 147                                     88 30   153
3306482 MO     school 2903120 93120   APPLETON CITY R-II 290312000019 1050 APPLETON CITY HIGH   Regular School No High 06 12 2018   k_12_total 184 * 5 *   *       * *           *         109   21   195 184   5                                 109 21   195
3301328 MO     school 2903150 47062   ARCADIA VALLEY R-II 290315000021 4020 ARCADIA VALLEY ELEM.   Regular School No Elementary PK 04 2018   k_12_total 309 6 * *   *       * 5           *         230.3   69   323 309 6                 5                   69   323
3301316 MO     school 2903150 47062   ARCADIA VALLEY R-II 290315000022 1050 ARCADIA VALLEY HIGH   Regular School No High 09 12 2018   k_12_total 318 * * *   *       * 6           *         167   52   329 318                   6                 167 52   329
3301322 MO     school 2903150 47062   ARCADIA VALLEY R-II 290315000023 3000 ARCADIA VALLEY MIDDLE   Regular School No Middle 05 08 2018   k_12_total 284 * * *   *       * 6           *         182   63   297 284                   6                 182 63   297
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
3306844 MO     school 2913830 96088   HAZELWOOD 291383000613 4320 ARMSTRONG ELEM.   Regular School No Elementary KG 05 2018   k_12_total 93 324 15 *   *       * 16           16         311   51   452 93 324 15               16           16     311 51   452
3306850 MO     school 2913830 96088   HAZELWOOD 291383002858 4340 ARROWPOINT ELEM.   Regular School No Elementary PK 05 2018   k_12_total 5 516 * *   *       * 9           *         424   85   535 5 516                 9                 424 85   535
3300456 MO     school 2903270 39135   ASH GROVE R-IV 290327000027 4020 ASH GROVE ELEM.   Regular School No Elementary PK 03 2018   k_12_total 182 * * *   *       * *           5         105   22   192 182                               5     105 22   192
3300450 MO     school 2903270 39135   ASH GROVE R-IV 290327000028 1050 ASH GROVE HIGH   Regular School No High 07 12 2018   k_12_total 324 * * *   *       * *           *         135   42   334 324                                     135 42   334
3309559 MO     school 2929280 115115   ST. LOUIS CITY 292928001877 4060 ASHLAND ELEM. AND BR.   Regular School No Elementary PK 06 2018   k_12_total * 240 * *   *       * *           *         *   23   242   240                                     23   242
3309885 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903014 6931 ASPIRE ACADEMY   Regular School Yes Elementary PK 06 2018   k_12_total * 377 * *   *       * *           *         *   31   381   377                                     31   381
3303239 MO     school 2910500 50014   DESOTO 73 291050000347 4010 ATHENA ELEM.   Regular School No Elementary KG 06 2018   k_12_total 519 6 12 *   *       * *           5         296   99   544 519 6 12                           5     296 99   544
3304001 MO     school 2903480 61150   ATLANTA C-3 290348000029 4020 ATLANTA ELEM.   Regular School No Elementary KG 06 2018   k_12_total 105 * * *   *       * *           *         56   12   105 105                                     56 12   105
3303995 MO     school 2903480 61150   ATLANTA C-3 290348000030 1050 ATLANTA HIGH   Regular School No High 07 12 2018   k_12_total 93 * * *   *       * *           *         37   12   93 93                                     37 12   93
3300220 MO     school 2931110 36139   WASHINGTON 293111002156 4020 AUGUSTA ELEM.   Regular School No Elementary KG 06 2018   k_12_total 141 * * *   *       * *           *         42   14   145 141                                     42 14   145
3303626 MO     school 2904020 55110   AURORA R-VIII 290402000031 1050 AURORA HIGH   Regular School No High 09 12 2018   k_12_total 486 7 61 *   *       * *           12         285   70   562 486 7 61                           12     285 70   562
3303632 MO     school 2904020 55110   AURORA R-VIII 290402001517 2050 AURORA JR. HIGH   Regular School No Middle 07 08 2018   k_12_total 266 6 42 6   *       * *           9         199.3   52   322 266 6 42 6                         9       52   322
3310187 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203064 9040 AUTUMN HILL SCHOOL   Special Education School No Other KG 12 2018   k_12_total 23 * * *   *       * *           *         *   *   25 23                                           25
3297931 MO     school 2922740 14126   NORTH CALLAWAY CO. R-I 292274001252 4020 AUXVASSE ELEM.   Regular School No Elementary PK 08 2018   k_12_total 298 * 6 *   *       * 9           *         157   39   314 298   6               9                 157 39   314
3299909 MO     school 2904050 34124   AVA R-I 290405000034 4020 AVA ELEM.   Regular School No Elementary PK 04 2018   k_12_total 430 * 6 *   *       * 11           *         355   78   447 430   6               11                 355 78   447
3299897 MO     school 2904050 34124   AVA R-I 290405000036 1050 AVA HIGH   Regular School No High 09 12 2018   k_12_total 422 * 9 *   *       * *           *         221   56   437 422   9                                 221 56   437
3299903 MO     school 2904050 34124   AVA R-I 290405002548 3000 AVA MIDDLE   Regular School No Middle 05 08 2018   k_12_total 400 * 10 *   *       * *           *         287   54   415 400   10                                 287 54   415
3296748 MO     school 2904080 2090   AVENUE CITY R-IX 290408000037 4020 AVENUE CITY ELEM.   Regular School No Elementary PK 08 2018   k_12_total 148 * * *   *       * 5           *         25   8   158 148                   5                 25 8   158
3308125 MO     school 2931530 96114   WEBSTER GROVES 293153002190 4020 AVERY ELEM.   Regular School No Elementary KG 05 2018   k_12_total 418 73 15 *   5       * 19           *         80   55   531 418 73 15     5         19                 80 55   531
3302649 MO     school 2904110 49135   AVILLA R-XIII 290411000038 4020 AVILLA ELEM.   Regular School No Elementary KG 08 2018   k_12_total 126 * 9 *   *       * 11           11         81   17   150 126   9               11           11     81 17   150
3304875 MO     school 2903060 75087   ALTON R-IV 290306000015 4020 Alton Elementary   Regular School No Elementary PK 06 2018   k_12_total 337 * 7 *   *       * *           *         250   69   347 337   7                                 250 69   347
3304869 MO     school 2903060 75087   ALTON R-IV 290306000016 1050 Alton High   Regular School No High 07 12 2018   k_12_total 293 * 5 *   *       * *           *         169.4   57   300 293   5                                   57   300
3310145 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203057 9023 B W ROBINSON SCHOOL   Special Education School No Other KG 12 2018   k_12_total 37 * * *   *       * *           *         17   *   45 37                                     17     45
3302474 MO     school 2900011 48911   B. BANNEKER ACADEMY 290001102750 6925 B. BANNEKER ACADEMY   Regular School Yes Elementary PK 08 2018   k_12_total * 317 * *   *       * 11           *         *   40   330   317                 11                   40   330
3302293 MO     school 2916400 48078   KANSAS CITY 33 291640002602 5440 B. BANNEKER ELEM.   Regular School No Elementary PK 06 2018   k_12_total 11 365 22 *   *       * *           12         *   72   401 11 365 22                           12       72   401
3307209 MO     school 2926850 96091   ROCKWOOD R-VI 292685002566 4145 BABLER ELEM.   Regular School No Elementary KG 05 2018   k_12_total 430 43 18 *   25       * 22           12         44   70   538 430 43 18     25         22           12     44 70   538
3310371 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901271 1070 BABLER LODGE   Regular School No High 06 12 2018   k_12_total 6 * * *   *       * *           *         *   *   10 6                                           10
3304930 MO     school 2904140 77101   BAKERSFIELD R-IV 290414000039 4020 BAKERSFIELD ELEM.   Regular School No Elementary PK 05 2018   k_12_total 132 * * *   *       * *           *         104   25   138 132                                     104 25   138
3304924 MO     school 2904140 77101   BAKERSFIELD R-IV 290414000040 1050 BAKERSFIELD HIGH   Regular School No High 06 12 2018   k_12_total 189 * * *   *       * *           *         117   48   192 189                                     117 48   192
3297083 MO     school 2904170 7122   BALLARD R-II 290417000041 4020 BALLARD ELEM.   Regular School No Elementary KG 06 2018   k_12_total 64 * * *   *       * *           *         41   12   70 64                                     41 12   70
3297077 MO     school 2904170 7122   BALLARD R-II 290417000042 1050 BALLARD HIGH   Regular School No High 07 12 2018   k_12_total 53 * * *   *       * *           *         28   11   56 53                                     28 11   56
3307137 MO     school 2926850 96091   ROCKWOOD R-VI 292685001614 4020 BALLWIN ELEM.   Regular School No Elementary KG 05 2018   k_12_total 330 49 32 *   62       * 27           46         112   88   500 330 49 32     62         27           46     112 88   500
3307882 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265003189 4010 BARACK OBAMA ELEMENTARY SCHOOL   Regular School No Elementary 01 06 2018   k_12_total * 408 * *   *       * 8           *         450   49   418   408                 8                 450 49   418
3308065 MO     school 2930660 96112   UNIVERSITY CITY 293066002105 4060 BARBARA JORDAN ELEM.   Regular School No Elementary KG 05 2018   k_12_total 8 317 25 *   7       * *           33         *   43   360 8 317 25     7                     33       43   360
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
3307525 MO     school 2923580 96095   PARKWAY C-2 292358001375 4020 BARRETTS ELEM.   Regular School No Elementary PK 05 2018   k_12_total 283 60 11 *   14       * 19           7         64   67   387 283 60 11     14         19           7     64 67   387
3306742 MO     school 2913830 96088   HAZELWOOD 291383000447 4040 BARRINGTON ELEM.   Regular School No Elementary KG 05 2018   k_12_total 43 341 * *   *       * 18           24         196   66   409 43 341                 18           24     196 66   409
3305386 MO     school 2925230 83003   PLATTE CO. R-III 292523001451 4010 BARRY SCH.   Regular School No Middle 05 08 2018   k_12_total 219 78 47 *   16       5 17           13         118   30   382 219 78 47     16       5 17           13     118 30   382
3297973 MO     school 2912550 14129   FULTON 58 291255000517 4010 BARTLEY ELEM.   Regular School No Elementary KG 05 2018   k_12_total 220 10 8 *   *       * 22           *         116   35   260 220 10 8               22                 116 35   260
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
3307665 MO     school 2904500 96099   BAYLESS 290450000715 2000 BAYLESS JUNIOR HIGH   Regular School No Middle 06 08 2018   k_12_total 266 56 14 *   45       * 17           55         273   84   399 266 56 14     45         17           55     273 84   399
3307659 MO     school 2904500 96099   BAYLESS 290450000044 1050 BAYLESS SENIOR HIGH   Regular School No High 09 12 2018   k_12_total 297 61 17 *   73       * 16           42         278   70   464 297 61 17     73         16           42     278 70   464
3307401 MO     school 2920670 96094   MEHLVILLE R-IX 292067001109 4020 BEASLEY ELEM.   Regular School No Elementary KG 05 2018   k_12_total 246 56 15 *   7       * 25           41         196   52   350 246 56 15     7         25           41     196 52   350
3300106 MO     school 2930570 36131   UNION R-XI 293057002097 4020 BEAUFORT ELEM.   Regular School No Elementary KG 06 2018   k_12_total 415 * 7 *   *       * *           6         166   46   425 415   7                           6     166 46   425
3309429 MO     school 2929280 115115   ST. LOUIS CITY 292928001882 1250 BEAUMONT CTE HIGH SCHOOL   Regular School No High 09 12 2018   k_12_total 79 454 40 *   10       * *           121         *   83   583 79 454 40     10                     121       83   583
3306206 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895001854 4020 BECKY-DAVID ELEM.   Regular School No Elementary KG 05 2018   k_12_total 683 50 36 *   35       * 39           47         119.4   81   844 683 50 36     35         39           47       81   844
3299447 MO     school 2916190 26006   JEFFERSON CITY 291619000746 4020 BELAIR ELEM.   Regular School No Elementary KG 05 2018   k_12_total 245 68 39 *   6       * 42           22         201   48   402 245 68 39     6         42           22     201 48   402
3308556 MO     school 2904530 103128   BELL CITY R-II 290453000046 4020 BELL CITY ELEM.   Regular School No Elementary KG 06 2018   k_12_total 114 * * *   *       * *           *         86   16   121 114                                     86 16   121
3308550 MO     school 2904530 103128   BELL CITY R-II 290453000047 1050 BELL CITY HIGH   Regular School No High 07 12 2018   k_12_total 95 5 * *   *       * *           *         63   14   103 95 5                                   63 14   103

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