enrollments

Data source: Big Local News · About: Big Local

16,123 rows where grade = "k_12_total" and state = "MO" sorted by district

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • k_12_total · 16,123 ✖
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
3070237 3070237 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001703331 1910 ACADEMIE LAFAYETTE - ARMOUR   Regular School Yes Middle 06 09 2021   k_12_total                                                   289                                             289
3070238 3070238 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001702753 6940 Academie Lafayette - Oak   Regular School Yes Elementary KG 05 2021   k_12_total                                                   517                                             517
3070239 3070239 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001703259 6941 ACADEMIE LAFAYETTE-CHERRY   Regular School Yes Elementary PK 04 2021   k_12_total                                                   390                                             390
3302489 3302489 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001703331 1910 ACADEMIE LAFAYETTE - ARMOUR   Regular School Yes Middle 06 09 2019   k_12_total 187 43 18 *   6       * 18           *         54   16   273 187 43 18     6         18                 54 16   273
3302490 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
3302491 3302491 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001702753 6940 ACADEMIE LAFAYETTE-OAK   Regular School Yes 1 03 08 2015   k_12_total 342 112 29 *   22       * 16           18         109   36   523 342 112 29     22         16           18     109 36   523
3302492 3302492 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001702753 6940 ACADEMIE LAFAYETTE-OAK   Regular School Yes 2 04 08 2016   k_12_total 299 76 25 *   19       * 23           19         84   33   444 299 76 25     19         23           19     84 33   444
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
3302494 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
3302495 3302495 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001702753 6940 ACADEMIE LAFAYETTE-OAK   Regular School Yes Elementary KG 05 2019   k_12_total 287 109 13 *   *       * 46           8         101   32   461 287 109 13               46           8     101 32   461
3302496 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
3302497 3302497 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001703259 6941 ACADEMIE LAFAYETTE-CHERRY   Regular School Yes 1 KG 02 2015   k_12_total 240 64 12 *   5       * 27           *         82   9   348 240 64 12     5         27                 82 9   348
3302498 3302498 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001703259 6941 ACADEMIE LAFAYETTE-CHERRY   Regular School Yes 1 KG 03 2016   k_12_total 319 71 18 *   5       * 48           14         105   12   463 319 71 18     5         48           14     105 12   463
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
3302500 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
3302501 3302501 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001703259 6941 ACADEMIE LAFAYETTE-CHERRY   Regular School Yes Elementary KG 05 2019   k_12_total 199 60 18 *   9       * 53           6         77   18   340 199 60 18     9         53           6     77 18   340
3302502 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
3070256 3070256 MO     school 2900604 48927   ACADEMY FOR INTEGRATED ARTS 290060403209 6995 ACADEMY FOR INTEGRATED ARTS   Regular School Yes Elementary PK 06 2021   k_12_total                                                   246                                             246
3302598 3302598 MO     school 2900604 48927   ACADEMY FOR INTEGRATED ARTS 290060403209 6995 ACADEMY FOR INTEGRATED ARTS   Regular School Yes 1 KG 04 2015   k_12_total * 75 * *   *       * 9           *         82   9   88   75                 9                 82 9   88
3302599 3302599 MO     school 2900604 48927   ACADEMY FOR INTEGRATED ARTS 290060403209 6995 ACADEMY FOR INTEGRATED ARTS   Regular School Yes 1 KG 05 2016   k_12_total 10 95 * *   *       * 11           *         111   10   120 10 95                 11                 111 10   120
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
3302601 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
3302602 3302602 MO     school 2900604 48927   ACADEMY FOR INTEGRATED ARTS 290060403209 6995 ACADEMY FOR INTEGRATED ARTS   Regular School Yes Elementary PK 06 2019   k_12_total 21 186 * *   *       * *           *         *   15   219 21 186                                     15   219
3302603 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
3069262 3069262 MO     school 2922980 1090   ADAIR CO. R-I 292298001315 1050 ADAIR CO. HIGH   Regular School No High 07 12 2021   k_12_total                                                   111                                             111
3069263 3069263 MO     school 2922980 1090   ADAIR CO. R-I 292298001314 4020 ADAIR CO. ELEM.   Regular School No Elementary PK 06 2021   k_12_total                                                   97                                             97
3296679 3296679 MO     school 2922980 1090   ADAIR CO. R-I 292298001315 1050 ADAIR CO. HIGH   Regular School No 3 07 12 2015   k_12_total 126 * * *   *       * *           *         78   16   128 126                                     78 16   128
3296680 3296680 MO     school 2922980 1090   ADAIR CO. R-I 292298001315 1050 ADAIR CO. HIGH   Regular School No 3 07 12 2016   k_12_total 107 * * *   *       * *           *         59   15   109 107                                     59 15   109
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
3296682 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
3296683 3296683 MO     school 2922980 1090   ADAIR CO. R-I 292298001315 1050 ADAIR CO. HIGH   Regular School No High 07 12 2019   k_12_total 98 * * *   *       * *           *         55   9   99 98                                     55 9   99
3296684 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
3296685 3296685 MO     school 2922980 1090   ADAIR CO. R-I 292298001314 4020 ADAIR CO. ELEM.   Regular School No 1 PK 06 2015   k_12_total 129 * * *   *       * *           *         85   13   130 129                                     85 13   130
3296686 3296686 MO     school 2922980 1090   ADAIR CO. R-I 292298001314 4020 ADAIR CO. ELEM.   Regular School No 1 KG 06 2016   k_12_total 122 * * *   *       * *           *         85   9   123 122                                     85 9   123
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
3296688 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
3296689 3296689 MO     school 2922980 1090   ADAIR CO. R-I 292298001314 4020 ADAIR CO. ELEM.   Regular School No Elementary PK 06 2019   k_12_total 120 * * *   *       * *           *         81   19   120 120                                     81 19   120
3296690 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
3069268 3069268 MO     school 2905790 1092   ADAIR CO. R-II 290579000125 1050 ADAIR CO. HIGH   Regular School No High 07 12 2021   k_12_total                                                   74                                             74
3069269 3069269 MO     school 2905790 1092   ADAIR CO. R-II 290579000124 4020 ADAIR CO. ELEM.   Regular School No Elementary KG 06 2021   k_12_total                                                   71                                             71
3296715 3296715 MO     school 2905790 1092   ADAIR CO. R-II 290579000125 1050 ADAIR CO. HIGH   Regular School No 3 07 12 2015   k_12_total 90 * * *   *       * *           *         47   18   92 90                                     47 18   92
3296716 3296716 MO     school 2905790 1092   ADAIR CO. R-II 290579000125 1050 ADAIR CO. HIGH   Regular School No 3 07 12 2016   k_12_total 82 * * *   *       * *           *         45   21   84 82                                     45 21   84
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
3296718 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
3296719 3296719 MO     school 2905790 1092   ADAIR CO. R-II 290579000125 1050 ADAIR CO. HIGH   Regular School No High 07 12 2019   k_12_total 75 * * *   *       * 5           *         29   21   80 75                   5                 29 21   80
3296720 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
3296721 3296721 MO     school 2905790 1092   ADAIR CO. R-II 290579000124 4020 ADAIR CO. ELEM.   Regular School No 1 KG 06 2015   k_12_total 82 * * *   *       * 6           *         44   18   89 82                   6                 44 18   89
3296722 3296722 MO     school 2905790 1092   ADAIR CO. R-II 290579000124 4020 ADAIR CO. ELEM.   Regular School No 1 KG 06 2016   k_12_total 89 * * *   *       * 6           *         52   19   96 89                   6                 52 19   96
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
3296724 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
3296725 3296725 MO     school 2905790 1092   ADAIR CO. R-II 290579000124 4020 ADAIR CO. ELEM.   Regular School No Elementary KG 06 2019   k_12_total 68 * * *   *       * *           *         25   15   69 68                                     25 15   69
3296726 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
3069329 3069329 MO     school 2902850 7123   ADRIAN R-III 290285000002 1050 ADRIAN SR. HIGH   Regular School No High 06 12 2021   k_12_total                                                   382                                             382
3069330 3069330 MO     school 2902850 7123   ADRIAN R-III 290285000001 4020 ADRIAN ELEM.   Regular School No Elementary PK 05 2021   k_12_total                                                   300                                             300
3297086 3297086 MO     school 2902850 7123   ADRIAN R-III 290285000002 1050 ADRIAN SR. HIGH   Regular School No 4 06 12 2015   k_12_total 384 8 * *   *       * *           *         151   34   396 384 8                                   151 34   396
3297087 3297087 MO     school 2902850 7123   ADRIAN R-III 290285000002 1050 ADRIAN SR. HIGH   Regular School No 4 06 12 2016   k_12_total 373 8 * *   *       * *           *         140   36   385 373 8                                   140 36   385
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
3297089 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
3297090 3297090 MO     school 2902850 7123   ADRIAN R-III 290285000002 1050 ADRIAN SR. HIGH   Regular School No High 06 12 2019   k_12_total 343 * 7 *   *       * *           *         109.4   24   356 343   7                                   24   356
3297091 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
3297092 3297092 MO     school 2902850 7123   ADRIAN R-III 290285000001 4020 ADRIAN ELEM.   Regular School No 1 PK 05 2015   k_12_total 319 * * *   *       * *           *         146   31   322 319                                     146 31   322
3297093 3297093 MO     school 2902850 7123   ADRIAN R-III 290285000001 4020 ADRIAN ELEM.   Regular School No 1 PK 05 2016   k_12_total 309 * * *   *       * *           *         128   36   313 309                                     128 36   313
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
3297095 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
3297096 3297096 MO     school 2902850 7123   ADRIAN R-III 290285000001 4020 ADRIAN ELEM.   Regular School No Elementary PK 05 2019   k_12_total 300 * 5 *   *       * *           *         107   37   305 300   5                                 107 37   305
3297097 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
3071262 3071262 MO     school 2902880 103129   ADVANCE R-IV 290288000004 1050 ADVANCE HIGH   Regular School No High 07 12 2021   k_12_total                                                   183                                             183
3071263 3071263 MO     school 2902880 103129   ADVANCE R-IV 290288000003 4020 ADVANCE ELEM.   Regular School No Elementary KG 06 2021   k_12_total                                                   236                                             236
3071264 3071264 MO     school 2902880 103129   ADVANCE R-IV 290288003340 7500 ADVANCE PRESCHOOL   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3308559 3308559 MO     school 2902880 103129   ADVANCE R-IV 290288000004 1050 ADVANCE HIGH   Regular School No 3 07 12 2015   k_12_total 170 * * *   *       * *           *         74   9   173 170                                     74 9   173
3308560 3308560 MO     school 2902880 103129   ADVANCE R-IV 290288000004 1050 ADVANCE HIGH   Regular School No 3 07 12 2016   k_12_total 178 * * *   *       * *           *         79   10   181 178                                     79 10   181
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
3308562 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
3308563 3308563 MO     school 2902880 103129   ADVANCE R-IV 290288000004 1050 ADVANCE HIGH   Regular School No High 07 12 2019   k_12_total 201 * * *   *       * *           *         101.2   25   205 201                                       25   205
3308564 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
3308565 3308565 MO     school 2902880 103129   ADVANCE R-IV 290288000003 4020 ADVANCE ELEM.   Regular School No 1 PK 06 2015   k_12_total 249 * 8 *   *       * *           *         143   28   259 249   8                                 143 28   259
3308566 3308566 MO     school 2902880 103129   ADVANCE R-IV 290288000003 4020 ADVANCE ELEM.   Regular School No 1 PK 06 2016   k_12_total 237 * 9 *   *       * *           *         133   29   246 237   9                                 133 29   246
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
3308568 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
3308569 3308569 MO     school 2902880 103129   ADVANCE R-IV 290288000003 4020 ADVANCE ELEM.   Regular School No Elementary PK 06 2019   k_12_total 223 * * *   *       * *           *         136   20   226 223                                     136 20   226
3308570 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
3308571 3308571 MO     school 2902880 103129   ADVANCE R-IV 290288003340 7500 ADVANCE PRESCHOOL   Regular School No Prekindergarten PK PK 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308572 3308572 MO     school 2902880 103129   ADVANCE R-IV 290288003340 7500 ADVANCE PRESCHOOL   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3071109 3071109 MO     school 2902910 96098   AFFTON 101 290291000009 1050 AFFTON HIGH   Regular School No High 09 12 2021   k_12_total                                                   748                                             748
3071110 3071110 MO     school 2902910 96098   AFFTON 101 290291002461 3000 ROGERS MIDDLE   Regular School No Middle 06 08 2021   k_12_total                                                   590                                             590
3071111 3071111 MO     school 2902910 96098   AFFTON 101 290291000007 4040 MESNIER PRIMARY SCH.   Regular School No Elementary KG 02 2021   k_12_total                                                   573                                             573
3071112 3071112 MO     school 2902910 96098   AFFTON 101 290291000005 4080 GOTSCH INTERMEDIATE SCH.   Regular School No Elementary 03 05 2021   k_12_total                                                   604                                             604
3307632 3307632 MO     school 2902910 96098   AFFTON 101 290291000009 1050 AFFTON HIGH   Regular School No 3 09 12 2015   k_12_total 600 60 33 *   27       * 39           18         273   103   761 600 60 33     27         39           18     273 103   761
3307633 3307633 MO     school 2902910 96098   AFFTON 101 290291000009 1050 AFFTON HIGH   Regular School No 3 09 12 2016   k_12_total 601 70 33 *   25       * 43           17         273   106   773 601 70 33     25         43           17     273 106   773
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
3307635 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
3307636 3307636 MO     school 2902910 96098   AFFTON 101 290291000009 1050 AFFTON HIGH   Regular School No High 09 12 2019   k_12_total 590 89 38 *   18       * 47           34         245   105   783 590 89 38     18         47           34     245 105   783
3307637 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
3307638 3307638 MO     school 2902910 96098   AFFTON 101 290291002461 3000 ROGERS MIDDLE   Regular School No 2 06 08 2015   k_12_total 411 58 30 *   14       * 33           33         229.1   87   548 411 58 30     14         33           33       87   548
3307639 3307639 MO     school 2902910 96098   AFFTON 101 290291002461 3000 ROGERS MIDDLE   Regular School No 2 06 08 2016   k_12_total 448 61 29 *   14       * 33           33         237   87   586 448 61 29     14         33           33     237 87   586
3307640 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
3307641 3307641 MO     school 2902910 96098   AFFTON 101 290291002461 3000 ROGERS MIDDLE   Regular School No Middle 06 08 2018   k_12_total 420 50 37 *   12       * 33           23         219   77   553 420 50 37     12         33           23     219 77   553
3307642 3307642 MO     school 2902910 96098   AFFTON 101 290291002461 3000 ROGERS MIDDLE   Regular School No Middle 06 08 2019   k_12_total 414 47 46 *   14       * 46           24         254   77   567 414 47 46     14         46           24     254 77   567
3307643 3307643 MO     school 2902910 96098   AFFTON 101 290291002461 3000 ROGERS MIDDLE   Regular School No Middle 06 08 2020   k_12_total 412 62 41 *   17       * 47           31         225   95   579 412 62 41     17         47           31     225 95   579
3307644 3307644 MO     school 2902910 96098   AFFTON 101 290291000007 4040 MESNIER PRIMARY SCH.   Regular School No 1 PK 02 2015   k_12_total 459 34 30 *   13       * 42           119         240   66   583 459 34 30     13         42           119     240 66   583

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