Data source: Big Local News · About: Big Local

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

View and edit SQL

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
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
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
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
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
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
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
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
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
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
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
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
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
3307640 MO     school 2902910 96098   AFFTON 101 290291002461 3000 ROGERS MIDDLE   Regular School No Middle 06 08 2017   k_12_total 432 57 43 *   12       * 31           26         233   79   576 432 57 43     12         31           26     233 79   576
3307646 MO     school 2902910 96098   AFFTON 101 290291000007 4040 MESNIER PRIMARY SCH.   Regular School No Elementary PK 02 2017   k_12_total 484 44 40 *   22       * 50           118         231   63   643 484 44 40     22         50           118     231 63   643
3307652 MO     school 2902910 96098   AFFTON 101 290291000005 4080 GOTSCH INTERMEDIATE SCH.   Regular School No Elementary 03 05 2017   k_12_total 419 46 45 *   14       * 45           65         248   92   571 419 46 45     14         45           65     248 92   571
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 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
3300346 MO     school 2902970 38046   ALBANY R-III 290297000011 4020 VIRGINIA E. GEORGE ELEM.   Regular School No Elementary PK 05 2017   k_12_total 193 * * *   *       * *           *         135   28   197 193                                     135 28   197
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 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
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
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
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
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
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
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
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
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
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 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
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
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
3298361 MO     school 2903200 19139   ARCHIE R-V 290320000024 4020 CASS CO. ELEM.   Regular School No Elementary PK 05 2017   k_12_total 229 5 6 *   *       * *           *         96   26   245 229 5 6                                 96 26   245
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
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
3300461 MO     school 2903270 39135   ASH GROVE R-IV 290327000026 4040 BOIS D'ARC ELEM.   Regular School No Elementary 04 06 2017   k_12_total 134 * * *   *       * *           *         57   15   138 134                                     57 15   138
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
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
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 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
3303637 MO     school 2904020 55110   AURORA R-VIII 290402000032 4020 PATE EARLY CHILDHOOD CTR.   Regular School No Elementary PK 02 2017   k_12_total 329 15 59 6   *       * *           44         288   76   411 329 15 59 6                         44     288 76   411
3303643 MO     school 2904020 55110   AURORA R-VIII 290402000033 4040 ROBINSON ELEM.   Regular School No Elementary 03 04 2017   k_12_total 240 6 41 *   *       * *           20         221   71   295 240 6 41                           20     221 71   295
3303649 MO     school 2904020 55110   AURORA R-VIII 290402002981 4060 ROBINSON INTERMEDIATE   Regular School No Middle 05 06 2017   k_12_total 236 7 37 7   *       * *           10         198.4   52   290 236 7 37 7                         10       52   290
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 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
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
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
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
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
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
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
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
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
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
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
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
3308549 MO     school 2904530 103128   BELL CITY R-II 290453000047 1050 BELL CITY HIGH   Regular School No High 07 12 2017   k_12_total 97 * * *   *       * *           *         66   16   102 97                                     66 16   102
3308555 MO     school 2904530 103128   BELL CITY R-II 290453000046 4020 BELL CITY ELEM.   Regular School No Elementary KG 06 2017   k_12_total 115 * * *   *       * *           *         77   15   121 115                                     77 15   121
3301333 MO     school 2904590 47064   BELLEVIEW R-III 290459000050 4020 BELLEVIEW ELEM.   Regular School No Elementary PK 08 2017   k_12_total 120 * * *   *       * *           *         80   14   122 120                                     80 14   122
3298549 MO     school 2904620 19152   BELTON 124 290462000055 1050 BELTON HIGH   Regular School No High 09 12 2017   k_12_total 981 134 179 *   6       5 65           24         645   179   1372 981 134 179     6       5 65           24     645 179   1372
3298555 MO     school 2904620 19152   BELTON 124 290462003025 1055 BELTON MIDDLE SCHOOL/FC   Regular School No Middle 07 08 2017   k_12_total 506 62 114 *   7       5 53           17         398   133   749 506 62 114     7       5 53           17     398 133   749
3298561 MO     school 2904620 19152   BELTON 124 290462000051 4020 CAMBRIDGE ELEM.   Regular School No Elementary KG 04 2017   k_12_total 211 13 75 *   *       * 23           39         205   44   323 211 13 75               23           39     205 44   323
3298567 MO     school 2904620 19152   BELTON 124 290462000053 4040 HILLCREST STEAM ACADEMY   Regular School No Elementary KG 06 2017   k_12_total 340 21 98 *   *       * 38           59         222   58   503 340 21 98               38           59     222 58   503
3298573 MO     school 2904620 19152   BELTON 124 290462000054 4050 SCOTT ELEM.   Regular School No Elementary KG 04 2017   k_12_total 188 35 23 *   *       * 25           *         168   37   278 188 35 23               25                 168 37   278
3298578 MO     school 2904620 19152   BELTON 124 290462000052 4060 GLADDEN ELEM.   Regular School No Elementary KG 04 2017   k_12_total 236 19 63 *   *       * 25           19         193   59   351 236 19 63               25           19     193 59   351
3298584 MO     school 2904620 19152   BELTON 124 290462002724 4080 MILL CREEK UPPER ELEM.   Regular School No Middle 05 06 2017   k_12_total 429 57 89 *   5       * 28           27         355   96   615 429 57 89     5         28           27     355 96   615
3298590 MO     school 2904620 19152   BELTON 124 290462002988 4090 KENTUCKY TRAIL ELEM.   Regular School No Elementary KG 04 2017   k_12_total 335 29 44 *   5       * 35           11         222.1   73   450 335 29 44     5         35           11       73   450
3298596 MO     school 2904620 19152   BELTON 124 290462002725 7500 GRACE EARLY CHILD. & ED. CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308647 MO     school 2904950 103135   BERNIE R-XIII 290495000061 1050 BERNIE HIGH   Regular School No High 07 12 2017   k_12_total 209 * 5 *   *       * 5           *         117   26   221 209   5               5                 117 26   221
3308653 MO     school 2904950 103135   BERNIE R-XIII 290495000060 4020 BERNIE ELEM.   Regular School No Elementary PK 06 2017   k_12_total 249 * 6 *   *       * 8           *         203   46   269 249   6               8                 203 46   269
3304006 MO     school 2904980 61151   BEVIER C-4 290498000063 1050 BEVIER HIGH   Regular School No High 09 12 2017   k_12_total 76 * * *   *       * *           *         35   14   79 76                                     35 14   79
3304012 MO     school 2904980 61151   BEVIER C-4 290498000062 4020 BEVIER ELEM.   Regular School No Elementary KG 08 2017   k_12_total 116 5 * *   *       * *           *         78   28   123 116 5                                   78 28   123
3298791 MO     school 2905070 22091   BILLINGS R-IV 290507000066 1050 BILLINGS SR. HIGH   Regular School No High 07 12 2017   k_12_total 182 * 5 *   *       * *           *         70   13   193 182   5                                 70 13   193
3298797 MO     school 2905070 22091   BILLINGS R-IV 290507000065 4020 BILLINGS ELEM.   Regular School No Elementary PK 06 2017   k_12_total 193 5 5 *   *       * *           *         96   33   205 193 5 5                                 96 33   205
3306523 MO     school 2905130 94076   BISMARCK R-V 290513000068 1050 BISMARCK R-V HIGH   Regular School No Other 06 12 2017   k_12_total 275 * 6 *   *       * *           *         *   47   286 275   6                                   47   286
3306529 MO     school 2905130 94076   BISMARCK R-V 290513000067 4020 BISMARCK R-V ELEM.   Regular School No Elementary PK 05 2017   k_12_total 199 * 5 *   *       * *           *         *   38   206 199   5                                   38   206
3299518 MO     school 2905190 27055   BLACKWATER R-II 290519000069 4020 BLACKWATER ELEM.   Regular School No Elementary PK 08 2017   k_12_total 101 5 * *   *       * *           *         58   18   106 101 5                                   58 18   106
3299397 MO     school 2909930 26002   BLAIR OAKS R-II 290993000295 1050 BLAIR OAKS HIGH   Regular School No High 09 12 2017   k_12_total 432 * * *   *       * *           *         44   39   440 432                                     44 39   440
3299403 MO     school 2909930 26002   BLAIR OAKS R-II 290993003117 3000 BLAIR OAKS MIDDLE SCHOOL   Regular School No Middle 05 08 2017   k_12_total 372 * * *   *       * 5           *         47   49   385 372                   5                 47 49   385
3299409 MO     school 2909930 26002   BLAIR OAKS R-II 290993000294 4020 BLAIR OAKS ELEM.   Regular School No Elementary KG 04 2017   k_12_total 373 * * *   *       * 6           *         42   55   384 373                   6                 42 55   384
3308599 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525002578 1015 JUVENILE CTR.   Alternative School No Other 02 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308605 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525000073 1050 BLOOMFIELD HIGH   Regular School No High 09 12 2017   k_12_total 196 * * *   *       * *           *         91   19   200 196                                     91 19   200
3308611 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525003104 3000 BLOOMFIELD MIDDLE   Regular School No Middle 05 08 2017   k_12_total 211 * * *   *       * *           *         115   26   215 211                                     115 26   215
3308617 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525000072 4020 BLOOMFIELD ELEM.   Regular School No Elementary PK 04 2017   k_12_total 236 * * *   *       * *           *         140   29   240 236                                     140 29   240
3308725 MO     school 2905280 104045   BLUE EYE R-V 290528002518 1010 TRI-LAKES SPECL. EDUC. COOP.   Special Education School No Other PK 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308730 MO     school 2905280 104045   BLUE EYE R-V 290528000076 1050 BLUE EYE HIGH   Regular School No High 09 12 2017   k_12_total 186 * * *   *       * *           *         84   37   195 186                                     84 37   195
3308736 MO     school 2905280 104045   BLUE EYE R-V 290528001900 3000 BLUE EYE MIDDLE   Regular School No Middle 05 08 2017   k_12_total 143 * * *   *       * 7           *         95   40   158 143                   7                 95 40   158
3308742 MO     school 2905280 104045   BLUE EYE R-V 290528000075 4020 BLUE EYE ELEM.   Regular School No Elementary PK 04 2017   k_12_total 178 * * *   *       * 9           *         142   31   191 178                   9                 142 31   191
3301404 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000085 1050 BLUE SPRINGS HIGH   Regular School No High 09 12 2017   k_12_total 1709 286 279 11   51       13 145           5         673.4   235   2494 1709 286 279 11   51       13 145           5       235   2494
3301410 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000170 1075 BLUE SPRINGS SOUTH HIGH   Regular School No High 09 12 2017   k_12_total 1476 225 196 6   41       7 104           5         380   160   2055 1476 225 196 6   41       7 104           5     380 160   2055
3301416 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000943 3000 BRITTANY HILL MIDDLE   Regular School No Middle 06 08 2017   k_12_total 598 83 90 *   23       * 50           *         257   102   848 598 83 90     23         50                 257 102   848
3301422 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531001706 3060 MORELAND RIDGE MIDDLE   Regular School No Middle 06 08 2017   k_12_total 734 74 87 *   19       * 61           5         315   102   983 734 74 87     19         61           5     315 102   983
3301428 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531002736 3080 DELTA WOODS MIDDLE   Regular School No Middle 06 08 2017   k_12_total 566 87 76 6   44       * 36           *         165.1   66   815 566 87 76 6   44         36                   66   815
3301434 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531002835 3090 PAUL KINDER MIDDLE SCHOOL   Regular School No Middle 06 08 2017   k_12_total 528 89 77 7   11       * 56           *         281   98   772 528 89 77 7   11         56                 281 98   772
3301442 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000086 4020 THOMAS J. ULTICAN ELEM.   Regular School No Elementary PK 05 2017   k_12_total 329 55 58 *   6       * 55           6         234   67   506 329 55 58     6         55           6     234 67   506
3301448 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000080 4040 FRANKLIN SMITH ELEM.   Regular School No Elementary PK 05 2017   k_12_total 329 59 64 *   *       * 54           5         277   56   512 329 59 64               54           5     277 56   512
3301454 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000082 4050 JAMES LEWIS ELEM.   Regular School No Elementary PK 05 2017   k_12_total 346 32 42 *   6       * 30           *         124   58   458 346 32 42     6         30                 124 58   458
3301460 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000087 4060 WILLIAM YATES ELEM.   Regular School No Elementary PK 05 2017   k_12_total 239 29 66 *   14       * 38           20         179   36   387 239 29 66     14         38           20     179 36   387
3301466 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531002549 4070 LUCY FRANKLIN ELEM.   Regular School No Elementary PK 05 2017   k_12_total 429 33 73 *   5       * 43           *         127   73   587 429 33 73     5         43                 127 73   587
3301472 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000078 4080 CORDILL-MASON ELEM.   Regular School No Elementary PK 05 2017   k_12_total 556 82 51 *   9       * 54           *         191   65   757 556 82 51     9         54                 191 65   757

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