enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
3303719 3303719 MO     school   57003   TROY R-III   1000 CENTRAL OFFICE             2015   k_12_total                                                   0                                             0
3303720 3303720 MO     school   57003   TROY R-III   1000 CENTRAL OFFICE             2016   k_12_total                                                   0                                             0
3303721 3303721 MO     school   57003   TROY R-III   1000 CENTRAL OFFICE             2017   k_12_total                                                   0                                             0
3303722 3303722 MO     school   57003   TROY R-III   1000 CENTRAL OFFICE             2018   k_12_total                                                   0                                             0
3303931 3303931 MO     school   60077   MCDONALD CO. R-I   1000 CENTRAL OFFICE             2017   k_12_total                                                   0                                             0
3308402 3308402 MO     school   100062   SCOTT CO. CENTRAL   1000 CENTRAL OFFICE             2016   k_12_total                                                   0                                             0
3069320 3069320 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No Other PK 12 2021   k_12_total                                                   0                                             0
3069580 3069580 MO     school 2929520 20001   STOCKTON R-I 292952003351 1010 EXCEPTIONAL PUPIL COOP. - ECSE   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069843 3069843 MO     school 2929100 36136   ST. CLAIR R-XIII 292910002568 1010 FRANKLIN CO. SPECL. ED. COOP.   Special Education School No Other PK 12 2021   k_12_total                                                   0                                             0
3071303 3071303 MO     school 2912240 106003   FORSYTH R-III 291224003391 1010 TRI LAKES SPECIAL SERV CO-OP   Regular School No Other PK 12 2021   k_12_total                                                   0                                             0
3071322 3071322 MO     school 2914840 107152   HOUSTON R-I 291484000686 1010 EXCEPTIONAL CHILD COOP.   Special Education School No Other PK 12 2021   k_12_total                                                   0                                             0
3296965 3296965 MO     school 2928200 5127   SHELL KNOB 78 292820003350 1010 TRI-LAKES SPECL. EDUC. COOP.   Regular School No Other PK 12 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297032 3297032 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No 4 PK 12 2015   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297033 3297033 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No 4 PK 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297034 3297034 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No Other PK 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297035 3297035 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No Other PK 12 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297036 3297036 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No Other PK 12 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297037 3297037 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No Other PK 12 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298600 3298600 MO     school 2929520 20001   STOCKTON R-I 292952003351 1010 EXCEPTIONAL PUPIL COOP. - ECSE   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300133 3300133 MO     school 2929100 36136   ST. CLAIR R-XIII 292910002568 1010 FRANKLIN CO. SPECL. ED. COOP.   Special Education School No 4 PK 12 2015   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300134 3300134 MO     school 2929100 36136   ST. CLAIR R-XIII 292910002568 1010 FRANKLIN CO. SPECL. ED. COOP.   Special Education School No 4 PK 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300135 3300135 MO     school 2929100 36136   ST. CLAIR R-XIII 292910002568 1010 FRANKLIN CO. SPECL. ED. COOP.   Special Education School No Other PK 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300136 3300136 MO     school 2929100 36136   ST. CLAIR R-XIII 292910002568 1010 FRANKLIN CO. SPECL. ED. COOP.   Special Education School No Other PK 12 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300137 3300137 MO     school 2929100 36136   ST. CLAIR R-XIII 292910002568 1010 FRANKLIN CO. SPECL. ED. COOP.   Special Education School No Other PK 12 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300138 3300138 MO     school 2929100 36136   ST. CLAIR R-XIII 292910002568 1010 FRANKLIN CO. SPECL. ED. COOP.   Special Education School No Other PK 12 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3305531 3305531 MO     school 2911730 84002   FAIR PLAY R-II 291173003214 1010 EXCEPTIONAL PUPIL COOP   Special Education School No 4 PK 12 2015   k_12_total * * * *   *       * *           *         *   *   0                                             0
3305532 3305532 MO     school 2911730 84002   FAIR PLAY R-II 291173003214 1010 EXCEPTIONAL PUPIL COOP   Special Education School No 4 PK 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3305533 3305533 MO     school 2911730 84002   FAIR PLAY R-II 291173003214 1010 EXCEPTIONAL PUPIL COOP   Special Education School No Other PK 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3305534 3305534 MO     school 2911730 84002   FAIR PLAY R-II 291173003214 1010 EXCEPTIONAL PUPIL COOP   Special Education School No Other PK 12 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3305535 3305535 MO     school 2911730 84002   FAIR PLAY R-II 291173003214 1010 EXCEPTIONAL PUPIL COOP   Special Education School No Other PK 12 2019   k_12_total * * * *   *       * *           *         *   *   5                                             5
3308723 3308723 MO     school 2905280 104045   BLUE EYE R-V 290528002518 1010 TRI-LAKES SPECL. EDUC. COOP.   Special Education School No 4 PK 12 2015   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308724 3308724 MO     school 2905280 104045   BLUE EYE R-V 290528002518 1010 TRI-LAKES SPECL. EDUC. COOP.   Special Education School No 4 PK 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308725 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
3308726 3308726 MO     school 2905280 104045   BLUE EYE R-V 290528002518 1010 TRI-LAKES SPECL. EDUC. COOP.   Special Education School No Other PK 12 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308727 3308727 MO     school 2905280 104045   BLUE EYE R-V 290528002518 1010 TRI-LAKES SPECL. EDUC. COOP.   Special Education School No Other PK 12 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308911 3308911 MO     school 2914840 107152   HOUSTON R-I 291484000686 1010 EXCEPTIONAL CHILD COOP.   Special Education School No 4 PK 12 2015   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308912 3308912 MO     school 2914840 107152   HOUSTON R-I 291484000686 1010 EXCEPTIONAL CHILD COOP.   Special Education School No 4 PK 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308913 3308913 MO     school 2914840 107152   HOUSTON R-I 291484000686 1010 EXCEPTIONAL CHILD COOP.   Special Education School No Other PK 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308914 3308914 MO     school 2914840 107152   HOUSTON R-I 291484000686 1010 EXCEPTIONAL CHILD COOP.   Special Education School No Other PK 12 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308915 3308915 MO     school 2914840 107152   HOUSTON R-I 291484000686 1010 EXCEPTIONAL CHILD COOP.   Special Education School No Other PK 12 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308916 3308916 MO     school 2914840 107152   HOUSTON R-I 291484000686 1010 EXCEPTIONAL CHILD COOP.   Special Education School No Other PK 12 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3310256 3310256 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901145 1010 MONTGOMERY CITY TREATMENT CTR.   Special Education School No 4 06 12 2015   k_12_total 13 13 * *   *       * *           *         *   *   26 13 13                                         26
3310257 3310257 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901145 1010 MONTGOMERY CITY TREATMENT CTR.   Special Education School No 4 06 12 2016   k_12_total 12 7 * *   *       * *           *         *   *   20 12 7                                         20
3310258 3310258 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901145 1010 MONTGOMERY CITY TREATMENT CTR.   Special Education School No Other 06 12 2017   k_12_total 12 5 * *   *       * *           *         *   *   17 12 5                                         17
3310259 3310259 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901145 1010 MONTGOMERY CITY TREATMENT CTR.   Special Education School No High 06 12 2018   k_12_total * * * *   *       * *           *         *   *   6                                             6
3310260 3310260 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901145 1010 MONTGOMERY CITY TREATMENT CTR.   Special Education School No High 06 12 2019   k_12_total * * * *   *       * *           *         *   *   9                                             9
3310261 3310261 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901145 1010 MONTGOMERY CITY TREATMENT CTR.   Special Education School No High 06 12 2020   k_12_total * * * *   *       * *           *         *   *   9                                             9
3069377 3069377 MO     school 2901000 10093   COLUMBIA 93 290100002577 1015 JUVENILE JUSTICE CTR.   Alternative School No Other 01 12 2021   k_12_total                                                   12                                             12
3069562 3069562 MO     school 2913760 19149   HARRISONVILLE R-IX 291376002594 1015 EVERETT WADE JUVENILE CTR.   Alternative School No Other KG 12 2021   k_12_total                                                   0                                             0
3070087 3070087 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830002614 1015 HILLTOP SCHOOL   Alternative School No High 05 12 2021   k_12_total                                                   21                                             21
3070926 3070926 MO     school 2911910 94078   FARMINGTON R-VII 291191002589 1015 JUVENILE DETENTION CTR.   Alternative School No Other KG 12 2021   k_12_total                                                   6                                             6
3071199 3071199 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676002630 1015 JUVENILE DETENTION CTR.   Alternative School No Other KG 12 2021   k_12_total                                                   22                                             22
3071269 3071269 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525002578 1015 JUVENILE CTR.   Alternative School No Other 02 12 2021   k_12_total                                                   0                                             0
3071397 3071397 MO     school 2921510 114114   MOUNTAIN GROVE R-III 292151002618 1015 OZARK REGIONAL JUVENILE DET CT   Alternative School No Other KG 12 2021   k_12_total                                                   5                                             5
3071405 3071405 MO     school 2929280 115115   ST. LOUIS CITY 292928003252 1015 GRISCOM JUVENILE DETENTION CTR   Alternative School No High 05 12 2021   k_12_total                                                   13                                             13
3297371 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 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 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 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 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 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
3298042 3298042 MO     school 2906990 15002   CAMDENTON R-III 290699001953 1015 JUVENILE JUSTICE CTR.   Alternative Education School No 4 05 12 2015   k_12_total * * * *   *       * *           *         *   *   6                                             6
3298043 3298043 MO     school 2906990 15002   CAMDENTON R-III 290699001953 1015 JUVENILE JUSTICE CTR.   Alternative Education School No 4 05 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298044 3298044 MO     school 2906990 15002   CAMDENTON R-III 290699001953 1015 JUVENILE JUSTICE CTR.   Alternative School No Other 05 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298045 3298045 MO     school 2906990 15002   CAMDENTON R-III 290699001953 1015 JUVENILE JUSTICE CTR.   Alternative School No High 05 12 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298046 3298046 MO     school 2906990 15002   CAMDENTON R-III 290699001953 1015 JUVENILE JUSTICE CTR.   Alternative School No High 05 12 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298047 3298047 MO     school 2906990 15002   CAMDENTON R-III 290699001953 1015 JUVENILE JUSTICE CENTER   Alternative School No High 05 12 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298488 3298488 MO     school 2913760 19149   HARRISONVILLE R-IX 291376002594 1015 EVERETT WADE JUVENILE CTR.   Alternative Education School No 4 KG 12 2015   k_12_total 8 * * *   *       * *           *         *   *   10 8                                           10
3298489 3298489 MO     school 2913760 19149   HARRISONVILLE R-IX 291376002594 1015 EVERETT WADE JUVENILE CTR.   Alternative Education School No 4 KG 12 2016   k_12_total * * * *   *       * *           *         *   *   6                                             6
3298490 3298490 MO     school 2913760 19149   HARRISONVILLE R-IX 291376002594 1015 EVERETT WADE JUVENILE CTR.   Alternative School No Other KG 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298491 3298491 MO     school 2913760 19149   HARRISONVILLE R-IX 291376002594 1015 EVERETT WADE JUVENILE CTR.   Alternative School No Other KG 12 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298492 3298492 MO     school 2913760 19149   HARRISONVILLE R-IX 291376002594 1015 EVERETT WADE JUVENILE CTR.   Alternative School No Other KG 12 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3301590 3301590 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830002614 1015 HILLTOP SCHOOL   Alternative Education School No 4 05 12 2015   k_12_total 11 14 * *   *       * *           *         6   *   27 11 14                                   6     27
3301591 3301591 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830002614 1015 HILLTOP SCHOOL   Alternative Education School No 4 05 12 2016   k_12_total 10 10 * *   *       * *           *         5   *   25 10 10                                   5     25
3301592 3301592 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830002614 1015 HILLTOP SCHOOL   Alternative School No Other 05 12 2017   k_12_total 15 6 * *   *       * *           *         7   *   26 15 6                                   7     26
3301593 3301593 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830002614 1015 HILLTOP SCHOOL   Alternative School No High 05 12 2018   k_12_total 6 16 * *   *       * *           *         *   *   23 6 16                                         23
3301594 3301594 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830002614 1015 HILLTOP SCHOOL   Alternative School No High 05 12 2019   k_12_total 9 13 * *   *       * *           *         5   7   23 9 13                                   5 7   23
3301595 3301595 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830002614 1015 HILLTOP SCHOOL   Alternative School No High 05 12 2020   k_12_total 10 17 * *   *       * *           *         *   6   33 10 17                                     6   33
3302964 3302964 MO     school 2914430 50003   HILLSBORO R-III 291443001017 1015 JUVENILE DETENTION CTR.   Alternative Education School No 4 01 12 2016   k_12_total 12 * * *   *       * *           *         *   *   13 12                                           13
3302965 3302965 MO     school 2914430 50003   HILLSBORO R-III 291443001017 1015 JUVENILE DETENTION CTR.   Alternative School No Other 01 12 2017   k_12_total 11 * * *   *       * *           *         *   *   12 11                                           12
3302966 3302966 MO     school 2914430 50003   HILLSBORO R-III 291443001017 1015 JUVENILE DETENTION CTR.   Alternative School No Other 01 12 2018   k_12_total 9 * * *   *       * *           *         *   *   10 9                                           10
3302967 3302967 MO     school 2914430 50003   HILLSBORO R-III 291443001017 1015 JUVENILE DETENTION CTR.   Alternative School No Other 01 12 2019   k_12_total * * * *   *       * *           *         *   *   7                                             7
3302968 3302968 MO     school 2914430 50003   HILLSBORO R-III 291443001017 1015 JUVENILE DETENTION CTR.   Alternative School No Other 01 12 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306533 3306533 MO     school 2911910 94078   FARMINGTON R-VII 291191002589 1015 JUVENILE DETENTION CTR.   Alternative Education School No 4 KG 12 2015   k_12_total * * * *   *       * *           *         *   *   6                                             6
3306534 3306534 MO     school 2911910 94078   FARMINGTON R-VII 291191002589 1015 JUVENILE DETENTION CTR.   Alternative Education School No 4 KG 12 2016   k_12_total 9 * * *   *       * *           *         *   *   11 9                                           11
3306535 3306535 MO     school 2911910 94078   FARMINGTON R-VII 291191002589 1015 JUVENILE DETENTION CTR.   Alternative School No Other KG 12 2017   k_12_total 11 * * *   *       * *           *         *   *   11 11                                           11
3306536 3306536 MO     school 2911910 94078   FARMINGTON R-VII 291191002589 1015 JUVENILE DETENTION CTR.   Alternative School No Other KG 12 2018   k_12_total * * * *   *       * *           *         *   *   6                                             6
3306537 3306537 MO     school 2911910 94078   FARMINGTON R-VII 291191002589 1015 JUVENILE DETENTION CTR.   Alternative School No Other KG 12 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306538 3306538 MO     school 2911910 94078   FARMINGTON R-VII 291191002589 1015 JUVENILE DETENTION CTR.   Alternative School No Other KG 12 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308170 3308170 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676002630 1015 JUVENILE DETENTION CTR.   Alternative Education School No 4 KG 12 2015   k_12_total 10 33 * *   *       * *           *         21   27   43 10 33                                   21 27   43
3308171 3308171 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676002630 1015 JUVENILE DETENTION CTR.   Alternative Education School No 4 KG 12 2016   k_12_total 12 43 * *   *       * *           *         29   14   56 12 43                                   29 14   56
3308172 3308172 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676002630 1015 JUVENILE DETENTION CTR.   Alternative School No Other KG 12 2017   k_12_total 10 50 * *   *       * *           *         48   19   61 10 50                                   48 19   61
3308173 3308173 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676002630 1015 JUVENILE DETENTION CTR.   Alternative School No Other KG 12 2018   k_12_total 5 28 * *   *       * *           *         15   *   34 5 28                                   15     34
3308174 3308174 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676002630 1015 JUVENILE DETENTION CTR.   Alternative School No Other KG 12 2019   k_12_total * 42 * *   *       * *           *         30   32   45   42                                   30 32   45
3308175 3308175 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676002630 1015 JUVENILE DETENTION CTR.   Alternative School No Other KG 12 2020   k_12_total * 37 * *   *       * *           *         23   11   38   37                                   23 11   38
3308597 3308597 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525002578 1015 JUVENILE CTR.   Alternative Education School No 4 02 12 2015   k_12_total * * * *   *       * *           *         *   *   5                                             5
3308598 3308598 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525002578 1015 JUVENILE CTR.   Alternative Education School No 4 02 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308599 3308599 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525002578 1015 JUVENILE CTR.   Alternative School No Other 02 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308600 3308600 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525002578 1015 JUVENILE CTR.   Alternative School No Other 02 12 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308601 3308601 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525002578 1015 JUVENILE CTR.   Alternative School No Other 02 12 2019   k_12_total * * * *   *       * *           *         *   *   7                                             7

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