Data source: Big Local News · About: Big Local

2,320 rows where grade = "k_12_total", state = "MO" and year = 2020 sorted by school

View and edit SQL

year

  • 2020 · 2,320

grade

  • k_12_total · 2,320
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
3308432 MO     school 2928260 100063   SIKESTON R-6 292826001741 3050 5TH AND 6TH GRADE CTR.   Regular School No Middle 05 06 2020   k_12_total 286 194 26 *   5       * 39           *         *   76   550 286 194 26     5         39                   76   550
3305671 MO     school 2931440 85046   WAYNESVILLE R-VI 293144003207 3010 6TH GRADE CENTER   Regular School No Middle 06 06 2020   k_12_total 269 67 59 *   10       8 64           20         221   75   480 269 67 59     10       8 64           20     221 75   480
3308426 MO     school 2928260 100063   SIKESTON R-6 292826001737 2050 7TH AND 8TH GRADE CTR.   Regular School No Middle 07 08 2020   k_12_total 293 185 31 *   5       * 24           *         *   52   539 293 185 31     5         24                   52   539
3304179 MO     school 2913650 64075   HANNIBAL 60 291365000587 4020 A. D. STOWELL ELEM.   Regular School No Elementary KG 05 2020   k_12_total 225 9 5 *   *       * 8           *         170.2   22   248 225 9 5               8                   22   248
3304338 MO     school 2911220 67055   EAST PRAIRIE R-II 291122000385 4060 A. J. MARTIN ELEM.   Regular School No Elementary 03 06 2020   k_12_total 306 13 7 *   *       * 14           *         240   66   341 306 13 7               14                 240 66   341
3302137 MO     school 2915480 48077   INDEPENDENCE 30 291548003210 6130 ABRAHAM MALLINSON ELEMENTARY   Regular School No Elementary 02 05 2020   k_12_total 164 43 77 *   *       * 36           46         272   23   325 164 43 77               36           46     272 23   325
3302331 MO     school 2916400 48078   KANSAS CITY 33 291640001718 5670 AC PREP ELEMENTARY   Regular School No Elementary PK 08 2020   k_12_total * 375 10 *   *       5 *           *         *   52   397   375 10             5                     52   397
3309537 MO     school 2929280 115115   ST. LOUIS CITY 292928003215 3250 ACAD OF ENTRE STDY@LOUVERTURE   Regular School No Middle 06 08 2020   k_12_total 5 338 * *   *       * *           6         *   58   348 5 338                             6       58   348
3302490 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001703331 1910 ACADEMIE LAFAYETTE - ARMOUR   Regular School Yes Middle 06 09 2020   k_12_total 182 41 13 *   5       * 27           *         45   23   269 182 41 13     5         27                 45 23   269
3302502 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001703259 6941 ACADEMIE LAFAYETTE-CHERRY   Regular School Yes Elementary KG 05 2020   k_12_total 159 67 18 *   8       * 43           5         69   30   299 159 67 18     8         43           5     69 30   299
3302496 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001702753 6940 ACADEMIE LAFAYETTE-OAK   Regular School Yes Elementary KG 05 2020   k_12_total 338 123 19 *   6       * 60           6         116   41   552 338 123 19     6         60           6     116 41   552
3302603 MO     school 2900604 48927   ACADEMY FOR INTEGRATED ARTS 290060403209 6995 ACADEMY FOR INTEGRATED ARTS   Regular School Yes Elementary PK 06 2020   k_12_total 23 205 9 *   6       * *           *         *   20   248 23 205 9     6                             20   248
3308211 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001588 4029 ACKERMAN SCH.   Regular School No Elementary KG 08 2020   k_12_total 32 130 * *   *       * *           *         *   *   166 32 130                                         166
3296690 MO     school 2922980 1090   ADAIR CO. R-I 292298001314 4020 ADAIR CO. ELEM.   Regular School No Elementary PK 06 2020   k_12_total 121 * * *   *       * *           *         79   24   121 121                                     79 24   121
3296726 MO     school 2905790 1092   ADAIR CO. R-II 290579000124 4020 ADAIR CO. ELEM.   Regular School No Elementary KG 06 2020   k_12_total 69 * * *   *       * *           *         28   14   70 69                                     28 14   70
3296684 MO     school 2922980 1090   ADAIR CO. R-I 292298001315 1050 ADAIR CO. HIGH   Regular School No High 07 12 2020   k_12_total 103 * * *   *       * *           *         54   *   104 103                                     54     104
3296720 MO     school 2905790 1092   ADAIR CO. R-II 290579000125 1050 ADAIR CO. HIGH   Regular School No High 07 12 2020   k_12_total 73 * * *   *       * 6           *         18   15   79 73                   6                 18 15   79
3309555 MO     school 2929280 115115   ST. LOUIS CITY 292928002789 4000 ADAMS ELEM.   Regular School No Elementary PK 06 2020   k_12_total 10 196 * *   *       * *           *         *   96   207 10 196                                     96   207
3298304 MO     school 2907380 17125   CARROLLTON R-VII 290738003131 4000 ADAMS PRIMARY SCHOOL   Regular School No Elementary PK 01 2020   k_12_total 143 * * *   *       * 9           *         82   21   156 143                   9                 82 21   156
3297097 MO     school 2902850 7123   ADRIAN R-III 290285000001 4020 ADRIAN ELEM.   Regular School No Elementary PK 05 2020   k_12_total 296 * 6 *   *       * *           *         105   41   303 296   6                                 105 41   303
3297091 MO     school 2902850 7123   ADRIAN R-III 290285000002 1050 ADRIAN SR. HIGH   Regular School No High 06 12 2020   k_12_total 369 * 8 *   5       * *           *         103   23   387 369   8     5                           103 23   387
3308570 MO     school 2902880 103129   ADVANCE R-IV 290288000003 4020 ADVANCE ELEM.   Regular School No Elementary KG 06 2020   k_12_total 242 * * *   *       * *           *         137   22   244 242                                     137 22   244
3308564 MO     school 2902880 103129   ADVANCE R-IV 290288000004 1050 ADVANCE HIGH   Regular School No High 07 12 2020   k_12_total 195 * * *   *       * *           *         95   26   198 195                                     95 26   198
3308572 MO     school 2902880 103129   ADVANCE R-IV 290288003340 7500 ADVANCE PRESCHOOL   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307637 MO     school 2902910 96098   AFFTON 101 290291000009 1050 AFFTON HIGH   Regular School No High 09 12 2020   k_12_total 582 90 41 *   14       * 47           36         248.4   108   774 582 90 41     14         47           36       108   774
3300337 MO     school 2902970 38046   ALBANY R-III 290297000010 1050 ALBANY HIGH   Regular School No High 09 12 2020   k_12_total 116 * * *   *       * 7           *         62.1   15   124 116                   7                   15   124
3300343 MO     school 2902970 38046   ALBANY R-III 290297001478 3000 ALBANY MIDDLE   Regular School No Middle 06 08 2020   k_12_total 89 * * *   *       * *           *         56   15   91 89                                     56 15   91
3299055 MO     school 2918540 24090   LIBERTY 53 291854001004 4020 ALEXANDER DONIPHAN ELEM.   Regular School No Elementary KG 05 2020   k_12_total 299 * 30 *   6       * 24           6         78   65   363 299   30     6         24           6     78 65   363
3308316 MO     school 2928360 97130   SLATER 292836001749 4020 ALEXANDER ELEM.   Regular School No Elementary PK 08 2020   k_12_total 185 17 * *   *       * 23           *         *   28   230 185 17                 23                   28   230
3305463 MO     school 2923550 83005   PARK HILL 292355001366 4080 ALFRED L. RENNER ELEM.   Regular School No Elementary KG 05 2020   k_12_total 250 58 88 *   17       11 29           55         186.1   57   454 250 58 88     17       11 29           55       57   454
3302464 MO     school 2900025 48909   ALLEN VILLAGE 290002502748 6915 ALLEN VILLAGE ELEMENTARY   Regular School Yes Elementary 03 05 2020   k_12_total * 39 75 *   *       * *           47         111   7   123   39 75                           47     111 7   123
3302454 MO     school 2900025 48909   ALLEN VILLAGE 290002503233 1980 ALLEN VILLAGE HIGH SCHOOL   Regular School Yes High 09 12 2020   k_12_total * 63 104 *   6       * 5           24         162   21   182   63 104     6         5           24     162 21   182
3302456 MO     school 2900025 48909   ALLEN VILLAGE 290002503325 3930 ALLEN VILLAGE JUNIOR   Regular School Yes Middle 06 08 2020   k_12_total 7 41 94 *   5       * *           24         137   8   149 7 41 94     5                     24     137 8   149
3302458 MO     school 2900025 48909   ALLEN VILLAGE 290002503327 6905 ALLEN VILLAGE PRIMARY   Regular School Yes Elementary KG 02 2020   k_12_total * 28 56 *   *       * *           49         85   7   94   28 56                           49     85 7   94
3298214 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712000184 4020 ALMA SCHRADER ELEM.   Regular School No Elementary KG 04 2020   k_12_total 292 41 13 *   17       * 24           16         *   51   387 292 41 13     17         24           16       51   387
3297448 MO     school 2901000 10093   COLUMBIA 93 290100003152 4030 ALPHA HART LEWIS   Regular School No Elementary PK 05 2020   k_12_total 147 135 13 *   6       * 76           13         *   49   380 147 135 13     6         76           13       49   380
3305093 MO     school 2903040 79078   ALTENBURG 48 290304000014 4020 ALTENBURG ELEM.   Regular School No Elementary KG 08 2020   k_12_total 97 * * *   *       * *           *         28   19   98 97                                     28 19   98
3310436 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901287 1084 ALTERNATIVE RESOURCE CTR.   Alternative School No High 06 12 2020   k_12_total 10 14 * *   *       * *           *         *   5   26 10 14                                     5   26
3296768 MO     school 2927570 2097   SAVANNAH R-III 292757001688 4010 AMAZONIA ELEM.   Regular School No Elementary KG 05 2020   k_12_total 88 * * *   *       * *           *         39   18   93 88                                     39 18   93
3309579 MO     school 2929280 115115   ST. LOUIS CITY 292928002570 4250 AMES VISUAL/PERF. ARTS   Regular School No Elementary PK 05 2020   k_12_total 5 201 * *   *       * *           *         *   14   210 5 201                                     14   210
3303949 MO     school 2920610 60077   MCDONALD CO. R-I 292061001100 4020 ANDERSON ELEM.   Regular School No Elementary PK 05 2020   k_12_total 356 * 50 18   8       21 16           55         316   94   470 356   50 18   8       21 16           55     316 94   470
3303943 MO     school 2920610 60077   MCDONALD CO. R-I 292061003007 3000 ANDERSON MIDDLE   Regular School No Middle 06 08 2020   k_12_total 195 * 29 6   *       12 11           13         167   53   253 195   29 6           12 11           13     167 53   253
3297424 MO     school 2901000 10093   COLUMBIA 93 290100000841 3000 ANN HAWKINS GENTRY MIDDLE   Regular School No Middle 06 08 2020   k_12_total 678 94 37 *   58       * 57           18         210.4   92   927 678 94 37     58         57           18       92   927
3299157 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001258 3000 ANTIOCH MIDDLE   Regular School No Middle 07 08 2020   k_12_total 493 103 142 *   24       16 93           22         411   94   872 493 103 142     24       16 93           22     411 94   872
3303146 MO     school 2912300 50012   FOX C-6 291230000497 4010 ANTONIA ELEM.   Regular School No Elementary KG 05 2020   k_12_total 500 * 7 *   *       * 12           *         122   91   522 500   7               12                 122 91   522
3303140 MO     school 2912300 50012   FOX C-6 291230003151 2200 ANTONIA MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 500 * 14 *   *       * 18           *         169   61   536 500   14               18                 169 61   536
3306490 MO     school 2903120 93120   APPLETON CITY R-II 290312000017 4010 APPLETON CITY ELEM.   Regular School No Elementary PK 05 2020   k_12_total 145 * * *   *       * *           *         69   20   149 145                                     69 20   149
3306484 MO     school 2903120 93120   APPLETON CITY R-II 290312000019 1050 APPLETON CITY HIGH   Regular School No High 06 12 2020   k_12_total 163 * 5 6   *       * *           *         78   19   177 163   5 6                               78 19   177
3301330 MO     school 2903150 47062   ARCADIA VALLEY R-II 290315000021 4020 ARCADIA VALLEY ELEM.   Regular School No Elementary PK 04 2020   k_12_total 302 7 * *   *       * *           *         218.4   64   317 302 7                                     64   317
3301318 MO     school 2903150 47062   ARCADIA VALLEY R-II 290315000022 1050 ARCADIA VALLEY HIGH   Regular School No High 09 12 2020   k_12_total 275 * * *   *       * 6           *         125   38   291 275                   6                 125 38   291
3301324 MO     school 2903150 47062   ARCADIA VALLEY R-II 290315000023 3000 ARCADIA VALLEY MIDDLE   Regular School No Middle 05 08 2020   k_12_total 272 * 7 *   *       * 5           *         183   38   290 272   7               5                 183 38   290
3298358 MO     school 2903200 19139   ARCHIE R-V 290320000025 1050 ARCHIE HIGH   Regular School No High 06 12 2020   k_12_total 260 7 6 *   *       * *           *         64   22   278 260 7 6                                 64 22   278
3306846 MO     school 2913830 96088   HAZELWOOD 291383000613 4320 ARMSTRONG ELEM.   Regular School No Elementary PK 05 2020   k_12_total 64 284 14 *   *       * 19           9         269   54   383 64 284 14               19           9     269 54   383
3306852 MO     school 2913830 96088   HAZELWOOD 291383002858 4340 ARROWPOINT ELEM.   Regular School No Elementary PK 05 2020   k_12_total 6 328 * *   *       * 8           *         *   65   346 6 328                 8                   65   346
3300458 MO     school 2903270 39135   ASH GROVE R-IV 290327000027 4020 ASH GROVE ELEM.   Regular School No Elementary PK 03 2020   k_12_total 187 * * *   *       * *           8         121   34   199 187                               8     121 34   199
3300452 MO     school 2903270 39135   ASH GROVE R-IV 290327000028 1050 ASH GROVE HIGH   Regular School No High 07 12 2020   k_12_total 314 * * *   *       * *           *         129   41   327 314                                     129 41   327
3309561 MO     school 2929280 115115   ST. LOUIS CITY 292928001877 4060 ASHLAND ELEM. AND BR.   Regular School No Elementary PK 06 2020   k_12_total * 167 * *   *       * *           *         *   29   167   167                                     29   167
3309887 MO     school 2900579 115906   CONFLUENCE ACADEMIES 290057903014 6931 ASPIRE ACADEMY   Regular School Yes Elementary PK 08 2020   k_12_total * 434 * *   *       * *           *         *   50   439   434                                     50   439
3303241 MO     school 2910500 50014   DESOTO 73 291050000347 4010 ATHENA ELEM.   Regular School No Elementary KG 06 2020   k_12_total 489 * 8 *   *       * 11           *         262   79   513 489   8               11                 262 79   513
3304003 MO     school 2903480 61150   ATLANTA C-3 290348000029 4020 ATLANTA ELEM.   Regular School No Elementary KG 06 2020   k_12_total 102 * * *   *       * *           *         54   8   107 102                                     54 8   107
3303997 MO     school 2903480 61150   ATLANTA C-3 290348000030 1050 ATLANTA HIGH   Regular School No High 07 12 2020   k_12_total 103 * * *   *       * *           *         45   13   103 103                                     45 13   103
3300222 MO     school 2931110 36139   WASHINGTON 293111002156 4020 AUGUSTA ELEM.   Regular School No Elementary KG 06 2020   k_12_total 114 * * *   *       * *           *         41   16   117 114                                     41 16   117
3303628 MO     school 2904020 55110   AURORA R-VIII 290402000031 1050 AURORA HIGH   Regular School No High 09 12 2020   k_12_total 425 5 69 8   *       * 11           16         270   73   522 425 5 69 8             11           16     270 73   522
3303634 MO     school 2904020 55110   AURORA R-VIII 290402001517 2050 AURORA JR. HIGH   Regular School No Middle 07 08 2020   k_12_total 207 * 39 *   *       * 13           10         147   47   264 207   39               13           10     147 47   264
3310189 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203064 9040 AUTUMN HILL SCHOOL   Special Education School No Other KG 12 2020   k_12_total 32 * * *   *       * *           *         29   *   34 32                                     29     34
3297933 MO     school 2922740 14126   NORTH CALLAWAY CO. R-I 292274001252 4020 AUXVASSE ELEM.   Regular School No Elementary PK 08 2020   k_12_total 269 * 7 *   *       * 14           *         161   39   290 269   7               14                 161 39   290
3299911 MO     school 2904050 34124   AVA R-I 290405000034 4020 AVA ELEM.   Regular School No Elementary PK 04 2020   k_12_total 427 * 15 *   *       * 16           *         328.1   87   462 427   15               16                   87   462
3299899 MO     school 2904050 34124   AVA R-I 290405000036 1050 AVA HIGH   Regular School No High 09 12 2020   k_12_total 409 * 10 5   *       * *           *         218   49   429 409   10 5                               218 49   429
3299905 MO     school 2904050 34124   AVA R-I 290405002548 3000 AVA MIDDLE   Regular School No Middle 05 08 2020   k_12_total 393 * 9 *   *       * 11           *         273.3   64   414 393   9               11                   64   414
3296750 MO     school 2904080 2090   AVENUE CITY R-IX 290408000037 4020 AVENUE CITY ELEM.   Regular School No Elementary PK 08 2020   k_12_total 154 * * *   *       * 5           *         21   15   163 154                   5                 21 15   163
3308127 MO     school 2931530 96114   WEBSTER GROVES 293153002190 4020 AVERY ELEM.   Regular School No Elementary KG 05 2020   k_12_total 397 57 16 *   *       * 17           *         75   57   491 397 57 16               17                 75 57   491
3302651 MO     school 2904110 49135   AVILLA R-XIII 290411000038 4020 AVILLA ELEM.   Regular School No Elementary KG 08 2020   k_12_total 114 * 13 *   6       * 5           12         81   14   138 114   13     6         5           12     81 14   138
3304877 MO     school 2903060 75087   ALTON R-IV 290306000015 4020 Alton Elementary   Regular School No Elementary KG 06 2020   k_12_total 354 * * *   *       * *           *         234.3   63   368 354                                       63   368
3304871 MO     school 2903060 75087   ALTON R-IV 290306000016 1050 Alton High   Regular School No High 07 12 2020   k_12_total 300 * * 7   *       * *           *         181.1   48   313 300     7                                 48   313
3310147 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203057 9023 B W ROBINSON SCHOOL   Special Education School No Other KG 12 2020   k_12_total 34 * * *   *       * *           *         18   *   43 34                                     18     43
3302295 MO     school 2916400 48078   KANSAS CITY 33 291640002602 5440 B. BANNEKER ELEMENTARY   Regular School No Elementary PK 06 2020   k_12_total 10 369 26 *   *       5 5           13         *   42   417 10 369 26             5 5           13       42   417
3307211 MO     school 2926850 96091   ROCKWOOD R-VI 292685002566 4145 BABLER ELEM.   Regular School No Elementary KG 05 2020   k_12_total 415 33 21 *   20       * 28           16         39   58   518 415 33 21     20         28           16     39 58   518
3310373 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901271 1070 BABLER LODGE   Regular School No High 06 12 2020   k_12_total * * * *   *       * *           *         *   *   9                                             9
3304932 MO     school 2904140 77101   BAKERSFIELD R-IV 290414000039 4020 BAKERSFIELD ELEM.   Regular School No Elementary PK 05 2020   k_12_total 135 * * *   *       * *           *         86   22   135 135                                     86 22   135
3304926 MO     school 2904140 77101   BAKERSFIELD R-IV 290414000040 1050 BAKERSFIELD HIGH   Regular School No High 06 12 2020   k_12_total 212 * * *   *       * 6           *         119   46   221 212                   6                 119 46   221
3297085 MO     school 2904170 7122   BALLARD R-II 290417000041 4020 BALLARD ELEM.   Regular School No Elementary KG 06 2020   k_12_total 60 * * *   *       * *           *         29   13   67 60                                     29 13   67
3297079 MO     school 2904170 7122   BALLARD R-II 290417000042 1050 BALLARD HIGH   Regular School No High 07 12 2020   k_12_total 42 * * *   *       * *           *         22   7   46 42                                     22 7   46
3307139 MO     school 2926850 96091   ROCKWOOD R-VI 292685001614 4020 BALLWIN ELEM.   Regular School No Elementary KG 05 2020   k_12_total 329 52 28 *   63       * 26           43         110   97   498 329 52 28     63         26           43     110 97   498
3307884 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265003189 4010 BARACK OBAMA ELEMENTARY SCHOOL   Regular School No Elementary 01 08 2020   k_12_total * 373 9 *   *       * *           *         422   53   387   373 9                                 422 53   387
3308067 MO     school 2930660 96112   UNIVERSITY CITY 293066002105 4060 BARBARA JORDAN ELEM.   Regular School No Elementary KG 05 2020   k_12_total 5 299 29 *   *       * *           27         *   49   342 5 299 29                           27       49   342
3306178 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002307 3000 BARNWELL MIDDLE   Regular School No Middle 06 08 2020   k_12_total 533 78 57 *   50       * 45           33         168   89   766 533 78 57     50         45           33     168 89   766
3307527 MO     school 2923580 96095   PARKWAY C-2 292358001375 4020 BARRETTS ELEM.   Regular School No Elementary KG 05 2020   k_12_total 289 41 11 *   12       * 17           *         45   61   370 289 41 11     12         17                 45 61   370
3306744 MO     school 2913830 96088   HAZELWOOD 291383000447 4040 BARRINGTON ELEM.   Regular School No Elementary KG 05 2020   k_12_total 43 392 * *   *       * 10           16         234   63   453 43 392                 10           16     234 63   453
3305388 MO     school 2925230 83003   PLATTE CO. R-III 292523001451 4010 BARRY SCH.   Regular School No Middle 05 08 2020   k_12_total 245 85 49 *   17       6 27           11         139.1   30   430 245 85 49     17       6 27           11       30   430
3297975 MO     school 2912550 14129   FULTON 58 291255000517 4010 BARTLEY ELEM.   Regular School No Elementary KG 05 2020   k_12_total 217 12 5 *   *       * 16           *         108   48   252 217 12 5               16                 108 48   252
3307673 MO     school 2904500 96099   BAYLESS 290450000043 4020 BAYLESS ELEMENTARY   Regular School No Elementary PK 05 2020   k_12_total 522 89 46 *   99       * 37           203         480   119   793 522 89 46     99         37           203     480 119   793
3307667 MO     school 2904500 96099   BAYLESS 290450000715 2000 BAYLESS JUNIOR HIGH   Regular School No Middle 06 08 2020   k_12_total 282 48 21 *   48       * 15           50         255   76   414 282 48 21     48         15           50     255 76   414
3307661 MO     school 2904500 96099   BAYLESS 290450000044 1050 BAYLESS SENIOR HIGH   Regular School No High 09 12 2020   k_12_total 322 72 23 *   67       * 23           55         307.4   85   508 322 72 23     67         23           55       85   508
3307403 MO     school 2920670 96094   MEHLVILLE R-IX 292067001109 4020 BEASLEY ELEM.   Regular School No Elementary KG 05 2020   k_12_total 201 47 13 *   11       * 37           42         168   56   310 201 47 13     11         37           42     168 56   310
3300108 MO     school 2930570 36131   UNION R-XI 293057002097 4020 BEAUFORT ELEM.   Regular School No Elementary PK 06 2020   k_12_total 371 * * *   *       * *           *         149.1   56   381 371                                       56   381
3309431 MO     school 2929280 115115   ST. LOUIS CITY 292928001882 1250 BEAUMONT CTE HIGH SCHOOL   Regular School No High 09 12 2020   k_12_total 36 277 56 *   22       * *           102         *   76   391 36 277 56     22                     102       76   391
3306208 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895001854 4020 BECKY-DAVID ELEM.   Regular School No Elementary PK 05 2020   k_12_total 655 22 47 *   34       * 34           58         85   75   793 655 22 47     34         34           58     85 75   793
3307885 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265003369 4090 BEL-NOR   Regular School No Elementary 01 08 2020   k_12_total 5 312 14 *   *       * 15           16         *   55   349 5 312 14               15           16       55   349
3299449 MO     school 2916190 26006   JEFFERSON CITY 291619000746 4020 BELAIR ELEM.   Regular School No Elementary KG 05 2020   k_12_total 268 69 41 *   8       * 43           24         200   39   430 268 69 41     8         43           24     200 39   430
3308558 MO     school 2904530 103128   BELL CITY R-II 290453000046 4020 BELL CITY ELEM.   Regular School No Elementary KG 06 2020   k_12_total 103 8 * *   *       * *           *         87   12   114 103 8                                   87 12   114

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