Data source: Big Local News · About: Big Local

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

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
3303719 MO     school   57003   TROY R-III   1000 CENTRAL OFFICE             2015   k_12_total                                                   0                                             0
3303720 MO     school   57003   TROY R-III   1000 CENTRAL OFFICE             2016   k_12_total                                                   0                                             0
3303721 MO     school   57003   TROY R-III   1000 CENTRAL OFFICE             2017   k_12_total                                                   0                                             0
3303722 MO     school   57003   TROY R-III   1000 CENTRAL OFFICE             2018   k_12_total                                                   0                                             0
3303931 MO     school   60077   MCDONALD CO. R-I   1000 CENTRAL OFFICE             2017   k_12_total                                                   0                                             0
3308402 MO     school   100062   SCOTT CO. CENTRAL   1000 CENTRAL OFFICE             2016   k_12_total                                                   0                                             0
3069293 MO     school 2920810 4110   MEXICO 59 292081001132 4020 EUGENE FIELD ELEM.   Regular School No Elementary 01 05 2021   k_12_total                                                   377                                             377
3069294 MO     school 2920810 4110   MEXICO 59 292081001133 4060 HAWTHORNE ELEM.   Regular School No Elementary 01 05 2021   k_12_total                                                   420                                             420
3069377 MO     school 2901000 10093   COLUMBIA 93 290100002577 1015 JUVENILE JUSTICE CTR.   Alternative School No Other 01 12 2021   k_12_total                                                   12                                             12
3069444 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001467 4020 EUGENE FIELD ELEM.   Regular School No Elementary 01 03 2021   k_12_total                                                   284                                             284
3069446 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001471 4080 LAKE ROAD ELEM.   Regular School No Elementary 01 06 2021   k_12_total                                                   337                                             337
3069448 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001474 5040 OAK GROVE ELEM.   Regular School No Elementary 01 03 2021   k_12_total                                                   293                                             293
3069449 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001473 5060 O'NEAL ELEM.   Regular School No Elementary 01 03 2021   k_12_total                                                   326                                             326
3069565 MO     school 2913760 19149   HARRISONVILLE R-IX 291376000602 4020 HARRISONVILLE ELEM.   Regular School No Elementary 01 03 2021   k_12_total                                                   437                                             437
3070287 MO     school 2931500 49144   WEBB CITY R-VII 293150002189 4080 WEBSTER PRIMARY CTR.   Regular School No Elementary 01 02 2021   k_12_total                                                   385                                             385
3070630 MO     school 2920490 74201   MARYVILLE R-II 292049001093 4020 EUGENE FIELD ELEM.   Regular School No Elementary 01 04 2021   k_12_total                                                   345                                             345
3070667 MO     school 2928530 78005   SOUTH PEMISCOT CO. R-V 292853002670 4020 CENTRAL ELEMENTARY   Regular School No Elementary 01 06 2021   k_12_total                                                   284                                             284
3070930 MO     school 2911910 94078   FARMINGTON R-VII 291191000442 4030 WASHINGTON-FRANKLIN ELEM.   Regular School No Elementary 01 04 2021   k_12_total                                                   263                                             263
3070931 MO     school 2911910 94078   FARMINGTON R-VII 291191000438 4040 JEFFERSON ELEM.   Regular School No Elementary 01 04 2021   k_12_total                                                   282                                             282
3070933 MO     school 2911910 94078   FARMINGTON R-VII 291191002847 4060 ROOSEVELT ELEM.   Regular School No Elementary 01 04 2021   k_12_total                                                   528                                             528
3071150 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265003189 4010 BARACK OBAMA ELEMENTARY SCHOOL   Regular School No Elementary 01 08 2021   k_12_total                                                   371                                             371
3071151 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265003369 4090 BEL-NOR   Regular School No Elementary 01 05 2021   k_12_total                                                   182                                             182
3071152 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265001243 4100 JEFFERSON ELEM.   Regular School No Elementary 01 08 2021   k_12_total                                                   309                                             309
3071153 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265002850 4145 LUCAS CROSSING ELEM. COMPLEX   Regular School No Elementary 01 08 2021   k_12_total                                                   674                                             674
3071154 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265001249 4160 WASHINGTON ELEM.   Regular School No Elementary 01 08 2021   k_12_total                                                   356                                             356
3071243 MO     school 2928260 100063   SIKESTON R-6 292826001739 4040 LEE HUNTER ELEM.   Regular School No Elementary 01 04 2021   k_12_total                                                   339                                             339
3071244 MO     school 2928260 100063   SIKESTON R-6 292826001566 4050 WING ELEM.   Regular School No Elementary 01 04 2021   k_12_total                                                   354                                             354
3071245 MO     school 2928260 100063   SIKESTON R-6 292826001742 4070 SOUTHEAST ELEM.   Regular School No Elementary 01 04 2021   k_12_total                                                   285                                             285
3071309 MO     school 2905760 106004   BRANSON R-IV 290576002462 4040 CEDAR RIDGE ELEMENTARY   Regular School No Elementary 01 03 2021   k_12_total                                                   499                                             499
3296870 MO     school 2920810 4110   MEXICO 59 292081001132 4020 EUGENE FIELD ELEM.   Regular School No Elementary 01 05 2020   k_12_total 284 51 27 *   *       * 50           15         *   50   416 284 51 27               50           15       50   416
3296876 MO     school 2920810 4110   MEXICO 59 292081001133 4060 HAWTHORNE ELEM.   Regular School No Elementary 01 05 2020   k_12_total 322 30 47 *   *       * 44           28         *   53   444 322 30 47               44           28       53   444
3297170 MO     school 2931070 8107   WARSAW R-IX 293107002153 4020 NORTH ELEM.   Regular School No Elementary 01 05 2018   k_12_total 248 * 12 *   *       * 18           *         *   65   282 248   12               18                   65   282
3297171 MO     school 2931070 8107   WARSAW R-IX 293107002153 4020 NORTH ELEM.   Regular School No Elementary 01 05 2019   k_12_total 262 * 10 *   *       * 12           *         *   76   288 262   10               12                   76   288
3297371 MO     school 2901000 10093   COLUMBIA 93 290100002577 1015 JUVENILE JUSTICE CTR.   Alternative Education School No 4 01 12 2015   k_12_total 5 7 * *   *       * *           *         *   *   14 5 7                                         14
3297372 MO     school 2901000 10093   COLUMBIA 93 290100002577 1015 JUVENILE JUSTICE CTR.   Alternative Education School No 4 01 12 2016   k_12_total * * * *   *       * *           *         *   *   7                                             7
3297373 MO     school 2901000 10093   COLUMBIA 93 290100002577 1015 JUVENILE JUSTICE CTR.   Alternative School No Other 01 12 2017   k_12_total 5 7 * *   *       * *           *         *   *   12 5 7                                         12
3297374 MO     school 2901000 10093   COLUMBIA 93 290100002577 1015 JUVENILE JUSTICE CTR.   Alternative School No Other 01 12 2018   k_12_total 6 5 * *   *       * *           *         *   6   13 6 5                                     6   13
3297375 MO     school 2901000 10093   COLUMBIA 93 290100002577 1015 JUVENILE JUSTICE CTR.   Alternative School No Other 01 12 2019   k_12_total 5 7 * *   *       * *           *         *   *   14 5 7                                         14
3297376 MO     school 2901000 10093   COLUMBIA 93 290100002577 1015 JUVENILE JUSTICE CTR.   Alternative School No Other 01 12 2020   k_12_total 7 5 * *   *       * *           *         5   *   16 7 5                                   5     16
3297560 MO     school 2901000 10093   COLUMBIA 93 290100001598 6080 CENTER FOR GIFTED EDUCATION   Regular School No 1 01 05 2015   k_12_total 44 * * *   *       * *           *         *   *   50 44                                           50
3297561 MO     school 2901000 10093   COLUMBIA 93 290100001598 6080 CENTER FOR GIFTED EDUCATION   Regular School No 1 01 05 2016   k_12_total 59 * * *   *       * *           *         *   *   65 59                                           65
3297562 MO     school 2901000 10093   COLUMBIA 93 290100001598 6080 Center for Gifted Education   Regular School No Elementary 01 05 2017   k_12_total 51 * * *   *       * *           *         *   *   53 51                                           53
3297563 MO     school 2901000 10093   COLUMBIA 93 290100001598 6080 Center for Gifted Education   Regular School No Elementary 01 05 2018   k_12_total 48 * * *   *       * *           *         *   *   53 48                                           53
3297564 MO     school 2901000 10093   COLUMBIA 93 290100001598 6080 Center for Gifted Education   Regular School No Elementary 01 05 2019   k_12_total 40 5 * *   *       * *           *         *   *   48 40 5                                         48
3297565 MO     school 2901000 10093   COLUMBIA 93 290100001598 6080 Center for Gifted Education   Regular School No Elementary 01 05 2020   k_12_total 31 * * *   *       * *           *         *   *   40 31                                           40
3297776 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001467 4020 EUGENE FIELD ELEM.   Regular School No 1 01 04 2015   k_12_total 329 55 13 *   *       * 16           *         366   75   414 329 55 13               16                 366 75   414
3297777 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001467 4020 EUGENE FIELD ELEM.   Regular School No 1 01 04 2016   k_12_total 299 53 14 *   *       * 21           *         356   78   390 299 53 14               21                 356 78   390
3297778 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001467 4020 EUGENE FIELD ELEM.   Regular School No Elementary 01 03 2017   k_12_total 245 56 8 *   *       * 18           *         297   62   329 245 56 8               18                 297 62   329
3297779 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001467 4020 EUGENE FIELD ELEM.   Regular School No Elementary 01 03 2018   k_12_total 251 41 8 *   *       * 24           *         *   54   326 251 41 8               24                   54   326
3297780 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001467 4020 EUGENE FIELD ELEM.   Regular School No Elementary 01 03 2019   k_12_total 243 30 8 *   *       * 19           *         *   48   300 243 30 8               19                   48   300
3297781 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001467 4020 EUGENE FIELD ELEM.   Regular School No Elementary 01 03 2020   k_12_total 234 45 6 *   *       * 20           *         *   52   307 234 45 6               20                   52   307
3297788 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001471 4080 LAKE ROAD ELEM.   Regular School No 1 01 04 2015   k_12_total 177 62 8 *   *       * 21           *         244   53   269 177 62 8               21                 244 53   269
3297789 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001471 4080 LAKE ROAD ELEM.   Regular School No 1 01 04 2016   k_12_total 186 53 * *   *       * 35           *         242   57   278 186 53                 35                 242 57   278
3297790 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001471 4080 LAKE ROAD ELEM.   Regular School No Elementary 01 03 2017   k_12_total 124 41 6 *   *       * 25           *         168.2   51   197 124 41 6               25                   51   197
3297791 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001471 4080 LAKE ROAD ELEM.   Regular School No Elementary 01 03 2018   k_12_total 118 43 * *   *       * 25           *         *   44   191 118 43                 25                   44   191
3297792 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001471 4080 LAKE ROAD ELEM.   Regular School No Elementary 01 04 2019   k_12_total 168 44 6 *   *       * 32           *         *   56   251 168 44 6               32                   56   251
3297793 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001471 4080 LAKE ROAD ELEM.   Regular School No Elementary 01 05 2020   k_12_total 224 49 * *   *       * 34           *         *   61   310 224 49                 34                   61   310
3297800 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001474 5040 OAK GROVE ELEM.   Regular School No 1 01 04 2015   k_12_total 418 20 11 *   *       * 15           *         262   63   468 418 20 11               15                 262 63   468
3297801 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001474 5040 OAK GROVE ELEM.   Regular School No 1 01 04 2016   k_12_total 426 27 9 *   *       * 26           *         289   68   494 426 27 9               26                 289 68   494
3297802 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001474 5040 OAK GROVE ELEM.   Regular School No Elementary 01 03 2017   k_12_total 282 20 9 *   *       * 21           *         196   49   334 282 20 9               21                 196 49   334
3297803 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001474 5040 OAK GROVE ELEM.   Regular School No Elementary 01 03 2018   k_12_total 257 23 10 *   *       * 17           *         *   41   311 257 23 10               17                   41   311
3297804 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001474 5040 OAK GROVE ELEM.   Regular School No Elementary 01 03 2019   k_12_total 243 15 8 *   *       * 18           *         *   40   289 243 15 8               18                   40   289
3297805 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001474 5040 OAK GROVE ELEM.   Regular School No Elementary 01 03 2020   k_12_total 256 17 9 *   5       * 12           *         *   42   300 256 17 9     5         12                   42   300
3297806 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001473 5060 O'NEAL ELEM.   Regular School No 1 01 04 2015   k_12_total 425 40 10 *   *       * 12           *         268   94   490 425 40 10               12                 268 94   490
3297807 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001473 5060 O'NEAL ELEM.   Regular School No 1 01 04 2016   k_12_total 439 49 6 *   *       * 17           *         283   98   514 439 49 6               17                 283 98   514
3297808 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001473 5060 O'NEAL ELEM.   Regular School No Elementary 01 03 2017   k_12_total 286 35 7 *   *       * 22           *         246   72   350 286 35 7               22                 246 72   350
3297809 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001473 5060 O'NEAL ELEM.   Regular School No Elementary 01 03 2018   k_12_total 273 35 6 *   *       * 27           *         *   84   343 273 35 6               27                   84   343
3297810 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001473 5060 O'NEAL ELEM.   Regular School No Elementary 01 03 2019   k_12_total 260 39 9 *   *       * 29           *         *   83   339 260 39 9               29                   83   339
3297811 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001473 5060 O'NEAL ELEM.   Regular School No Elementary 01 03 2020   k_12_total 265 40 7 *   *       * 15           *         *   81   330 265 40 7               15                   81   330
3298505 MO     school 2913760 19149   HARRISONVILLE R-IX 291376000602 4020 HARRISONVILLE ELEM.   Regular School No 1 01 03 2015   k_12_total 460 8 23 *   *       * 18           8         249   41   513 460 8 23               18           8     249 41   513
3298506 MO     school 2913760 19149   HARRISONVILLE R-IX 291376000602 4020 HARRISONVILLE ELEM.   Regular School No 1 01 03 2016   k_12_total 426 6 19 *   *       * 12           6         210.4   35   468 426 6 19               12           6       35   468
3298507 MO     school 2913760 19149   HARRISONVILLE R-IX 291376000602 4020 HARRISONVILLE ELEM.   Regular School No Elementary 01 03 2017   k_12_total 410 6 27 *   *       * 17           7         225.3   42   464 410 6 27               17           7       42   464
3298508 MO     school 2913760 19149   HARRISONVILLE R-IX 291376000602 4020 HARRISONVILLE ELEM.   Regular School No Elementary 01 03 2018   k_12_total 457 5 26 *   *       * 19           11         242   46   510 457 5 26               19           11     242 46   510
3298509 MO     school 2913760 19149   HARRISONVILLE R-IX 291376000602 4020 HARRISONVILLE ELEM.   Regular School No Elementary 01 03 2019   k_12_total 452 10 23 *   *       * 29           11         229   40   519 452 10 23               29           11     229 40   519
3298510 MO     school 2913760 19149   HARRISONVILLE R-IX 291376000602 4020 HARRISONVILLE ELEM.   Regular School No Elementary 01 03 2020   k_12_total 428 7 22 *   *       * 33           6         222   64   495 428 7 22               33           6     222 64   495
3301763 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000651 4010 BURKE ELEM.   Regular School No 1 01 06 2015   k_12_total 34 229 39 *   *       * 11           27         *   29   313 34 229 39               11           27       29   313
3301764 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000651 4010 BURKE ELEM.   Regular School No 1 01 06 2016   k_12_total 55 352 50 *   8       * 21           38         *   38   487 55 352 50     8         21           38       38   487
3301765 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000651 4010 BURKE ELEM.   Regular School No Elementary 01 06 2017   k_12_total 42 238 36 *   12       * 17           25         *   22   345 42 238 36     12         17           25       22   345
3301766 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000651 4010 COMPASS ELEMENTARY   Regular School No Elementary 01 06 2018   k_12_total 34 249 41 *   11       * 26           21         *   30   361 34 249 41     11         26           21       30   361
3301767 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000651 4010 COMPASS ELEMENTARY   Regular School No Elementary 01 06 2019   k_12_total 31 239 48 *   9       * 28           22         *   31   355 31 239 48     9         28           22       31   355
3301769 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000652 4015 DOBBS ELEM.   Regular School No 1 01 06 2015   k_12_total 50 376 42 *   *       * 13           41         *   77   486 50 376 42               13           41       77   486
3301770 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000652 4015 DOBBS ELEM.   Regular School No 1 01 06 2016   k_12_total 34 303 41 *   *       * 15           44         *   61   396 34 303 41               15           44       61   396
3301771 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000652 4015 DOBBS ELEM.   Regular School No Elementary 01 06 2017   k_12_total 35 285 57 *   11       * 14           53         *   73   403 35 285 57     11         14           53       73   403
3301772 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000652 4015 DOBBS ELEM.   Regular School No Elementary 01 06 2018   k_12_total 40 244 51 *   9       * 17           46         *   59   362 40 244 51     9         17           46       59   362
3301773 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000652 4015 DOBBS ELEM.   Regular School No Elementary 01 06 2019   k_12_total 39 248 52 *   8       * 20           47         *   51   368 39 248 52     8         20           47       51   368
3301775 MO     school 2914340 48072   HICKMAN MILLS C-1 291434002595 4020 JOHNSON ELEM.   Regular School No 1 01 06 2015   k_12_total 33 292 30 *   *       * 11           28         *   41   370 33 292 30               11           28       41   370
3301776 MO     school 2914340 48072   HICKMAN MILLS C-1 291434002595 4020 JOHNSON ELEM.   Regular School No 1 01 06 2016   k_12_total 24 262 37 *   *       * 8           32         *   48   335 24 262 37               8           32       48   335
3301777 MO     school 2914340 48072   HICKMAN MILLS C-1 291434002595 4020 JOHNSON ELEM.   Regular School No Elementary 01 06 2017   k_12_total 27 277 42 *   *       * 6           30         *   56   355 27 277 42               6           30       56   355
3301778 MO     school 2914340 48072   HICKMAN MILLS C-1 291434002595 4020 JOHNSON ELEM.   Regular School No Elementary 01 06 2018   k_12_total 24 268 43 *   *       * 14           26         *   54   357 24 268 43               14           26       54   357
3301779 MO     school 2914340 48072   HICKMAN MILLS C-1 291434002595 4020 JOHNSON ELEM.   Regular School No Elementary 01 06 2019   k_12_total 21 245 38 *   *       * 14           23         *   64   323 21 245 38               14           23       64   323
3301780 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000662 4025 SYMINGTON ELEM.   Regular School No 1 01 06 2015   k_12_total 29 355 59 *   *       * 18           38         *   39   462 29 355 59               18           38       39   462
3301781 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000662 4025 SYMINGTON ELEM.   Regular School No 1 01 06 2016   k_12_total 28 302 45 *   *       * 16           25         *   43   391 28 302 45               16           25       43   391
3301782 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000662 4025 SYMINGTON ELEM.   Regular School No Elementary 01 06 2017   k_12_total 32 287 36 *   *       * 13           13         *   43   370 32 287 36               13           13       43   370
3301783 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000662 4025 SYMINGTON ELEM.   Regular School No Elementary 01 06 2018   k_12_total 16 245 39 *   *       * 11           20         *   41   315 16 245 39               11           20       41   315
3301784 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000662 4025 SYMINGTON ELEM.   Regular School No Elementary 01 06 2019   k_12_total 15 266 37 *   *       * 10           20         *   49   331 15 266 37               10           20       49   331
3301785 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000663 4030 TRUMAN ELEM.   Regular School No 1 01 06 2015   k_12_total 44 310 33 *   22       * 19           56         *   61   428 44 310 33     22         19           56       61   428
3301786 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000663 4030 TRUMAN ELEM.   Regular School No 1 01 06 2016   k_12_total 35 267 37 *   23       * 8           44         *   39   370 35 267 37     23         8           44       39   370
3301787 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000663 4030 TRUMAN ELEM.   Regular School No Elementary 01 06 2017   k_12_total 36 355 47 *   10       * 10           35         *   59   460 36 355 47     10         10           35       59   460
3301788 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000663 4030 TRUMAN ELEM.   Regular School No Elementary 01 06 2018   k_12_total 29 335 40 *   10       * 14           39         *   63   431 29 335 40     10         14           39       63   431
3301789 MO     school 2914340 48072   HICKMAN MILLS C-1 291434000663 4030 TRUMAN ELEM.   Regular School No Elementary 01 06 2019   k_12_total 18 298 43 *   8       * 18           37         *   58   389 18 298 43     8         18           37       58   389

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