Data source: Big Local News · About: Big Local

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

View and edit SQL

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
3071241 MO     school 2928260 100063   SIKESTON R-6 292826001741 3050 5TH AND 6TH GRADE CTR.   Regular School No Middle 05 06 2021   k_12_total                                                   519                                             519
3308427 MO     school 2928260 100063   SIKESTON R-6 292826001741 3050 5TH AND 6TH GRADE CTR.   Regular School No 2 05 06 2015   k_12_total 283 176 29 *   7       * 29           *         377   55   525 283 176 29     7         29                 377 55   525
3308428 MO     school 2928260 100063   SIKESTON R-6 292826001741 3050 5TH AND 6TH GRADE CTR.   Regular School No 2 05 06 2016   k_12_total 295 169 22 *   *       * 35           *         364   59   523 295 169 22               35                 364 59   523
3308429 MO     school 2928260 100063   SIKESTON R-6 292826001741 3050 5TH AND 6TH GRADE CTR.   Regular School No Middle 05 06 2017   k_12_total 302 166 17 *   *       * 40           *         350   66   529 302 166 17               40                 350 66   529
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
3308431 MO     school 2928260 100063   SIKESTON R-6 292826001741 3050 5TH AND 6TH GRADE CTR.   Regular School No Middle 05 06 2019   k_12_total 269 197 35 *   *       * 37           *         369.2   74   539 269 197 35               37                   74   539
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
3070775 MO     school 2931440 85046   WAYNESVILLE R-VI 293144003207 3010 6TH GRADE CENTER   Regular School No Middle 06 06 2021   k_12_total                                                   473                                             473
3305666 MO     school 2931440 85046   WAYNESVILLE R-VI 293144003207 3010 6TH GRADE CENTER   Regular School No 2 06 06 2015   k_12_total 251 82 44 6   13       8 30           19         192   62   434 251 82 44 6   13       8 30           19     192 62   434
3305667 MO     school 2931440 85046   WAYNESVILLE R-VI 293144003207 3010 6TH GRADE CENTER   Regular School No 2 06 06 2016   k_12_total 228 78 47 *   10       * 44           11         200   64   412 228 78 47     10         44           11     200 64   412
3305668 MO     school 2931440 85046   WAYNESVILLE R-VI 293144003207 3010 6TH GRADE CENTER   Regular School No Middle 06 06 2017   k_12_total 229 78 55 5   11       9 37           14         194.3   66   424 229 78 55 5   11       9 37           14       66   424
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
3305670 MO     school 2931440 85046   WAYNESVILLE R-VI 293144003207 3010 6TH GRADE CENTER   Regular School No Middle 06 06 2019   k_12_total 271 67 61 9   6       * 59           19         214   77   476 271 67 61 9   6         59           19     214 77   476
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
3071240 MO     school 2928260 100063   SIKESTON R-6 292826001737 2050 7TH AND 8TH GRADE CTR.   Regular School No Middle 07 08 2021   k_12_total                                                   532                                             532
3308421 MO     school 2928260 100063   SIKESTON R-6 292826001737 2050 7TH AND 8TH GRADE CTR.   Regular School No 2 07 08 2015   k_12_total 321 162 22 *   7       * 17           *         345   48   531 321 162 22     7         17                 345 48   531
3308422 MO     school 2928260 100063   SIKESTON R-6 292826001737 2050 7TH AND 8TH GRADE CTR.   Regular School No 2 07 08 2016   k_12_total 303 172 25 *   12       * 22           *         338   44   535 303 172 25     12         22                 338 44   535
3308423 MO     school 2928260 100063   SIKESTON R-6 292826001737 2050 7TH AND 8TH GRADE CTR.   Regular School No Middle 07 08 2017   k_12_total 276 162 28 *   8       * 33           *         319   52   507 276 162 28     8         33                 319 52   507
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
3308425 MO     school 2928260 100063   SIKESTON R-6 292826001737 2050 7TH AND 8TH GRADE CTR.   Regular School No Middle 07 08 2019   k_12_total 302 153 14 *   5       * 37           *         288   47   514 302 153 14     5         37                 288 47   514
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
3307875 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265001244 3000 7th and 8th Grade Center   Regular School No 2 07 08 2016   k_12_total 7 399 * *   *       * *           *         445   68   411 7 399                                   445 68   411
3307876 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265001244 3000 7th and 8th Grade Center   Regular School No Middle 07 08 2017   k_12_total 5 409 * *   *       * *           *         498   51   419 5 409                                   498 51   419
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
3307878 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265001244 3000 7th and 8th Grade Center   Regular School No Middle 07 08 2019   k_12_total 8 422 9 *   *       * 5           8         461   59   446 8 422 9               5           8     461 59   446
3070522 MO     school 2913650 64075   HANNIBAL 60 291365000587 4020 A. D. STOWELL ELEM.   Regular School No Elementary KG 05 2021   k_12_total                                                   199                                             199
3304174 MO     school 2913650 64075   HANNIBAL 60 291365000587 4020 A. D. STOWELL ELEM.   Regular School No 1 PK 05 2015   k_12_total 275 7 9 *   *       * 9           *         207.2   55   302 275 7 9               9                   55   302
3304175 MO     school 2913650 64075   HANNIBAL 60 291365000587 4020 A. D. STOWELL ELEM.   Regular School No 1 PK 05 2016   k_12_total 247 15 9 *   *       * 11           *         218.1   58   284 247 15 9               11                   58   284
3304176 MO     school 2913650 64075   HANNIBAL 60 291365000587 4020 A. D. STOWELL ELEM.   Regular School No Elementary PK 05 2017   k_12_total 259 15 7 *   *       * 16           *         194.2   55   300 259 15 7               16                   55   300
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
3304178 MO     school 2913650 64075   HANNIBAL 60 291365000587 4020 A. D. STOWELL ELEM.   Regular School No Elementary KG 05 2019   k_12_total 216 9 6 *   *       * 10           *         173.1   30   244 216 9 6               10                   30   244
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
3304333 MO     school 2911220 67055   EAST PRAIRIE R-II 291122000385 4060 A. J. MARTIN ELEM.   Regular School No 1 03 06 2015   k_12_total 332 7 14 *   *       * 5           *         245   66   358 332 7 14               5                 245 66   358
3304334 MO     school 2911220 67055   EAST PRAIRIE R-II 291122000385 4060 A. J. MARTIN ELEM.   Regular School No 1 03 06 2016   k_12_total 336 8 13 *   *       * 7           *         249   64   364 336 8 13               7                 249 64   364
3304335 MO     school 2911220 67055   EAST PRAIRIE R-II 291122000385 4060 A. J. MARTIN ELEM.   Regular School No Elementary 03 06 2017   k_12_total 331 13 11 *   *       * 9           *         262   66   366 331 13 11               9                 262 66   366
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
3304337 MO     school 2911220 67055   EAST PRAIRIE R-II 291122000385 4060 A. J. MARTIN ELEM.   Regular School No Elementary 03 06 2019   k_12_total 327 13 7 *   *       * 11           *         240   66   361 327 13 7               11                 240 66   361
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
3070176 MO     school 2915480 48077   INDEPENDENCE 30 291548003210 6130 ABRAHAM MALLINSON ELEMENTARY   Regular School No Elementary 02 05 2021   k_12_total                                                   300                                             300
3302132 MO     school 2915480 48077   INDEPENDENCE 30 291548003210 6130 ABRAHAM MALLINSON ELEMENTARY   Regular School No 1 02 05 2015   k_12_total 203 22 89 *   *       8 23           42         310   34   348 203 22 89             8 23           42     310 34   348
3302133 MO     school 2915480 48077   INDEPENDENCE 30 291548003210 6130 ABRAHAM MALLINSON ELEMENTARY   Regular School No 1 02 05 2016   k_12_total 209 20 82 *   *       * 27           50         305   33   346 209 20 82               27           50     305 33   346
3302134 MO     school 2915480 48077   INDEPENDENCE 30 291548003210 6130 ABRAHAM MALLINSON ELEMENTARY   Regular School No Elementary 02 05 2017   k_12_total 229 25 91 *   *       * 28           43         346   41   378 229 25 91               28           43     346 41   378
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
3302136 MO     school 2915480 48077   INDEPENDENCE 30 291548003210 6130 ABRAHAM MALLINSON ELEMENTARY   Regular School No Elementary 02 05 2019   k_12_total 202 35 88 *   *       * 46           59         320   34   378 202 35 88               46           59     320 34   378
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
3070208 MO     school 2916400 48078   KANSAS CITY 33 291640001718 5670 AC PREP ELEMENTARY   Regular School No Elementary PK 08 2021   k_12_total                                                   385                                             385
3302326 MO     school 2916400 48078   KANSAS CITY 33 291640001718 5670 AC PREP ELEMENTARY   Regular School No 1 PK 06 2015   k_12_total 8 286 5 *   *       * 7           *         *   38   309 8 286 5               7                   38   309
3302327 MO     school 2916400 48078   KANSAS CITY 33 291640001718 5670 AC PREP ELEMENTARY   Regular School No 1 PK 06 2016   k_12_total 7 325 * *   *       * 7           *         *   36   345 7 325                 7                   36   345
3302328 MO     school 2916400 48078   KANSAS CITY 33 291640001718 5670 AC PREP ELEMENTARY   Regular School No Elementary PK 07 2017   k_12_total 5 343 * *   *       * *           *         *   37   355 5 343                                     37   355
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
3302330 MO     school 2916400 48078   KANSAS CITY 33 291640001718 5670 AC PREP ELEMENTARY   Regular School No Elementary PK 08 2019   k_12_total * 371 6 *   *       * 5           *         *   45   386   371 6               5                   45   386
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
3071426 MO     school 2929280 115115   ST. LOUIS CITY 292928003215 3250 ACAD OF ENTRE STDY@LOUVERTURE   Regular School No Middle 06 08 2021   k_12_total                                                   262                                             262
3309536 MO     school 2929280 115115   ST. LOUIS CITY 292928003215 3250 ACAD OF ENTRE STDY@LOUVERTURE   Regular School No Middle 06 08 2019   k_12_total 8 299 * *   5       * *           15         *   36   317 8 299       5                     15       36   317
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
3309678 MO     school 2929280 115115   ST. LOUIS CITY 292928003211 4990 ACAD OF ENVT SCI/MATH ELEM   Regular School No 1 PK 05 2015   k_12_total * 324 * *   *       * *           *         *   25   328   324                                     25   328
3309679 MO     school 2929280 115115   ST. LOUIS CITY 292928003211 4990 ACAD OF ENVT SCI/MATH ELEM   Regular School No 1 PK 05 2016   k_12_total * 261 * *   *       * *           *         *   18   261   261                                     18   261
3309680 MO     school 2929280 115115   ST. LOUIS CITY 292928003211 4990 ACAD OF ENVT SCI/MATH ELEM   Regular School No Elementary PK 05 2017   k_12_total * 237 * *   *       * *           *         *   16   238   237                                     16   238
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
3309532 MO     school 2929280 115115   ST. LOUIS CITY 292928003215 3250 ACAD OF ENVT SCI/MATH MIDDLE   Regular School No 2 06 08 2015   k_12_total 6 275 * *   *       * *           *         *   31   282 6 275                                     31   282
3309533 MO     school 2929280 115115   ST. LOUIS CITY 292928003215 3250 ACAD OF ENVT SCI/MATH MIDDLE   Regular School No 2 06 08 2016   k_12_total 7 208 * *   *       * *           *         *   28   216 7 208                                     28   216
3309534 MO     school 2929280 115115   ST. LOUIS CITY 292928003215 3250 ACAD OF ENVT SCI/MATH MIDDLE   Regular School No Middle 06 08 2017   k_12_total 5 173 * *   *       * *           *         *   31   180 5 173                                     31   180
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
3070237 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001703331 1910 ACADEMIE LAFAYETTE - ARMOUR   Regular School Yes Middle 06 09 2021   k_12_total                                                   289                                             289
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 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
3070239 MO     school 2900017 48914   ACADEMIE LAFAYETTE 290001703259 6941 ACADEMIE LAFAYETTE-CHERRY   Regular School Yes Elementary PK 04 2021   k_12_total                                                   390                                             390
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 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 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 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 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 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
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 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 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 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 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 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
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 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 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 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 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 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 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
3071205 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001588 4029 ACKERMAN   Regular School No Elementary KG 08 2021   k_12_total                                                   173                                             173
3308206 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001588 4029 ACKERMAN SCH.   Regular School No 1 KG 08 2015   k_12_total 37 81 * *   *       * *           *         103   *   123 37 81                                   103     123
3308207 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001588 4029 ACKERMAN SCH.   Regular School No 1 KG 08 2016   k_12_total 35 97 * *   *       * *           *         123   *   138 35 97                                   123     138
3308208 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001588 4029 ACKERMAN SCH.   Regular School No Elementary KG 08 2017   k_12_total 35 110 * *   *       * 5           *         *   *   152 35 110                 5                       152
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
3308210 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001588 4029 ACKERMAN SCH.   Regular School No Elementary KG 08 2019   k_12_total 30 122 * *   *       * *           *         *   *   158 30 122                                         158
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
3069961 MO     school 2928860 39141   SPRINGFIELD R-XII 292886003378 7520 ADAH FULBRIGHT EARLY CHILDHOOD   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
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
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
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 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 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 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

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