Data source: Big Local News · About: Big Local

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

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
3299438 MO     school 2916190 26006   JEFFERSON CITY 291619000495 3020 THOMAS JEFFERSON MIDDLE   Regular School No 2 06 08 2015   k_12_total 641 191 81 5   24       * 57           25         548.1   89   999 641 191 81 5   24         57           25       89   999
3301994 MO     school 2915480 48077   INDEPENDENCE 30 291548003096 1090 VAN HORN HIGH   Regular School No 3 09 12 2016   k_12_total 540 109 262 6   *       10 68           50         766   106   999 540 109 262 6           10 68           50     766 106   999
3307803 MO     school 2917820 96106   LADUE 291782000944 3000 LADUE MIDDLE   Regular School No 2 06 08 2015   k_12_total 621 168 41 *   130       * 36           13         117   114   999 621 168 41     130         36           13     117 114   999
3301749 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003156 1050 RUSKIN HIGH SCHOOL   Regular School No High 10 12 2018   k_12_total 92 766 97 *   13       * 23           29         *   158   997 92 766 97     13         23           29       158   997
3301619 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830000222 3000 BERNARD C. CAMPBELL MIDDLE   Regular School No Middle 05 08 2020   k_12_total 690 153 53 *   21       * 76           6         260   99   996 690 153 53     21         76           6     260 99   996
3306050 MO     school 2908370 92087   FT. ZUMWALT R-II 290837002427 3070 FT. ZUMWALT SOUTH MIDDLE   Regular School No Middle 06 08 2019   k_12_total 774 73 49 *   52       * 45           11         152.4   110   996 774 73 49     52         45           11       110   996
3069681 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001282 3180 NEW MARK MIDDLE   Regular School No Middle 07 08 2021   k_12_total                                                   995                                             995
3071138 MO     school 2917820 96106   LADUE 291782000944 3000 LADUE MIDDLE   Regular School No Middle 06 08 2021   k_12_total                                                   995                                             995
3305681 MO     school 2931440 85046   WAYNESVILLE R-VI 293144002898 4050 FREEDOM ELEM.   Regular School No Elementary KG 05 2018   k_12_total 568 142 79 7   23       16 160           64         530.2   164   995 568 142 79 7   23       16 160           64       164   995
3306312 MO     school 2931650 92089   WENTZVILLE R-IV 293165002869 3050 FRONTIER MIDDLE   Regular School No 2 06 08 2016   k_12_total 828 57 51 5   32       * 22           *         198   138   995 828 57 51 5   32         22                 198 138   995
3304167 MO     school 2913650 64075   HANNIBAL 60 291365000595 1050 HANNIBAL SR. HIGH   Regular School No High 09 12 2020   k_12_total 828 78 26 *   9       * 51           *         467   157   994 828 78 26     9         51                 467 157   994
3306047 MO     school 2908370 92087   FT. ZUMWALT R-II 290837002427 3070 FT. ZUMWALT SOUTH MIDDLE   Regular School No 2 06 08 2016   k_12_total 810 59 40 *   53       * 28           10         155   117   994 810 59 40     53         28           10     155 117   994
3306228 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895001859 4070 FAIRMOUNT ELEM.   Regular School No 1 KG 05 2016   k_12_total 830 64 35 *   13       * 52           26         243   101   994 830 64 35     13         52           26     243 101   994
3301423 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531001706 3060 MORELAND RIDGE MIDDLE   Regular School No Middle 06 08 2018   k_12_total 742 95 57 5   16       * 74           *         309   122   993 742 95 57 5   16         74                 309 122   993
3307805 MO     school 2917820 96106   LADUE 291782000944 3000 LADUE MIDDLE   Regular School No Middle 06 08 2017   k_12_total 588 156 49 *   146       * 50           16         116   115   993 588 156 49     146         50           16     116 115   993
3070183 MO     school 2916400 48078   KANSAS CITY 33 291640000880 1580 EAST HIGH SCHOOL   Regular School No High 09 12 2021   k_12_total                                                   992                                             992
3071239 MO     school 2928260 100063   SIKESTON R-6 292826001744 1050 SIKESTON SR. HIGH   Regular School No High 09 12 2021   k_12_total                                                   992                                             992
3298710 MO     school 2922530 22089   Nixa Public Schools 292253000425 3000 NIXA JUNIOR HIGH   Regular School No Middle 07 08 2020   k_12_total 852 8 55 *   7       * 68           12         308.4   117   992 852 8 55     7         68           12       117   992
3299439 MO     school 2916190 26006   JEFFERSON CITY 291619000495 3020 THOMAS JEFFERSON MIDDLE   Regular School No 2 06 08 2016   k_12_total 630 196 85 *   26       * 51           31         523.3   99   992 630 196 85     26         51           31       99   992
3300090 MO     school 2930570 36131   UNION R-XI 293057002101 1050 UNION HIGH   Regular School No High 09 12 2020   k_12_total 921 21 19 *   11       * 15           6         345   82   991 921 21 19     11         15           6     345 82   991
3301995 MO     school 2915480 48077   INDEPENDENCE 30 291548003096 1090 VAN HORN HIGH   Regular School No High 09 12 2017   k_12_total 541 120 256 6   7       7 54           60         742   115   991 541 120 256 6   7       7 54           60     742 115   991
3069354 MO     school 2932490 9079   ZALMA R-V 293249002270 1050 ZALMA HIGH   Regular School No High 07 12 2021   k_12_total                                                   99                                             99
3070013 MO     school 2921480 44083   MOUND CITY R-II 292148001179 4020 MOUND CITY ELEM.   Regular School No Elementary PK 04 2021   k_12_total                                                   99                                             99
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
3296736 MO     school 2922710 2089   NORTH ANDREW CO. R-VI 292271000006 3000 NORTH ANDREW MIDDLE   Regular School No Middle 06 08 2018   k_12_total 98 * * *   *       * *           *         49   16   99 98                                     49 16   99
3298271 MO     school 2930300 17122   TINA-AVALON R-II 293030002070 4020 TINA-AVALON ELEM.   Regular School No Elementary PK 06 2017   k_12_total 97 * * *   *       * *           *         39   14   99 97                                     39 14   99
3298314 MO     school 2922620 17126   NORBORNE R-VIII 292262001238 1050 NORBORNE HIGH   Regular School No High 06 12 2018   k_12_total 93 * * *   *       * *           *         42   15   99 93                                     42 15   99
3299722 MO     school 2923670 31116   PATTONSBURG R-II 292367001410 1050 PATTONSBURG HIGH   Regular School No 3 07 12 2015   k_12_total 97 * * *   *       * *           *         52   16   99 97                                     52 16   99
3299733 MO     school 2923670 31116   PATTONSBURG R-II 292367001409 4020 PATTONSBURG ELEM.   Regular School No Elementary PK 05 2020   k_12_total 96 * * *   *       * *           *         68   7   99 96                                     68 7   99
3299827 MO     school 2929490 32058   STEWARTSVILLE C-2 292949002042 1050 STEWARTSVILLE HIGH   Regular School No High 07 12 2020   k_12_total 94 * * *   *       * 5           *         32   16   99 94                   5                 32 16   99
3299829 MO     school 2929490 32058   STEWARTSVILLE C-2 292949002041 4020 STEWARTSVILLE ELEM.   Regular School No 1 KG 06 2016   k_12_total 97 * * *   *       * *           *         45   25   99 97                                     45 25   99
3300342 MO     school 2902970 38046   ALBANY R-III 290297001478 3000 ALBANY MIDDLE   Regular School No Middle 06 08 2019   k_12_total 96 * * *   *       * *           *         71   17   99 96                                     71 17   99
3302554 MO     school 2900590 48922   FRONTIER SCHOOLS 290059003180 3940 FRONTIER SCHL OF EXCELLENCE-M   Regular School Yes Middle 06 08 2019   k_12_total * 45 49 *   *       * *           34         *   10   99   45 49                           34       10   99
3302583 MO     school 2900601 48925   HOPE LEADERSHIP ACADEMY 290060103194 6985 HOPE LEADERSHIP ACADEMY   Regular School Yes Elementary KG 04 2019   k_12_total * 86 * *   *       * 6           *         *   19   99   86                 6                   19   99
3303291 MO     school 2908730 51153   CHILHOWEE R-IV 290873000256 4020 CHILHOWEE ELEM.   Regular School No 1 PK 06 2016   k_12_total 95 * * *   *       * *           *         60   11   99 95                                     60 11   99
3304137 MO     school 2920280 64072   MARION CO. R-II 292028001075 1050 MARION CO. HIGH   Regular School No High 07 12 2020   k_12_total 99 * * *   *       * *           *         42   12   99 99                                     42 12   99
3304209 MO     school 2920750 65096   NORTH MERCER CO. R-III 292075001129 1050 MERCER HIGH   Regular School No High 07 12 2017   k_12_total 94 * * *   *       * *           *         58   22   99 94                                     58 22   99
3304217 MO     school 2920750 65096   NORTH MERCER CO. R-III 292075001128 4020 NORTH MERCER ELEM.   Regular School No Elementary PK 06 2019   k_12_total 93 * * *   *       * *           *         62   15   99 93                                     62 15   99
3304793 MO     school 2921690 74197   NORTH NODAWAY CO. R-VI 292169001196 4020 NORTH NODAWAY ELEM.   Regular School No 1 PK 05 2016   k_12_total 98 * * *   *       * *           *         48   11   99 98                                     48 11   99
3304980 MO     school 2923760 78001   NORTH PEMISCOT CO. R-I 292376001429 4020 ROSS ELEM.   Regular School No Elementary KG 05 2019   k_12_total 88 7 * *   *       * *           *         *   23   99 88 7                                     23   99
3305799 MO     school 2914370 88075   HIGBEE R-VIII 291437000666 4020 HIGBEE ELEM.   Regular School No Elementary KG 06 2017   k_12_total 96 * * *   *       * *           *         61   21   99 96                                     61 21   99
3305937 MO     school 2906170 90077   BUNKER R-III 290617000156 1050 BUNKER HIGH   Regular School No High 07 12 2017   k_12_total 99 * * *   *       * *           *         63   13   99 99                                     63 13   99
3305957 MO     school 2918450 90078   LESTERVILLE R-IV 291845000991 1050 LESTERVILLE HIGH   Regular School No High 07 12 2019   k_12_total 96 * * *   *       * *           *         43   12   99 96                                     43 12   99
3305963 MO     school 2918450 90078   LESTERVILLE R-IV 291845000990 4020 LESTERVILLE ELEM.   Regular School No Elementary PK 06 2019   k_12_total 92 * * *   *       * *           *         53   21   99 92                                     53 21   99
3309056 MO     school 2927600 108147   NORTHEAST VERNON CO. R-I 292760001694 4020 NORTHEAST VERNON CO. R-I ELEM.   Regular School No 1 PK 06 2016   k_12_total 97 * * *   *       * *           *         76   17   99 97                                     76 17   99
3310049 MO     school 2900614 115930   THE ARCH COMMUNITY SCHOOL 290061403302 6905 THE ARCH COMMUNITY SCHOOL   Regular School Yes Elementary KG 05 2020   k_12_total * 93 * *   *       * *           *         87   21   99   93                                   87 21   99
3070091 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830000222 3000 BERNARD C. CAMPBELL MIDDLE   Regular School No Middle 05 08 2021   k_12_total                                                   989                                             989
3306037 MO     school 2908370 92087   FT. ZUMWALT R-II 290837002491 3000 FT. ZUMWALT NORTH MIDDLE   Regular School No Middle 06 08 2018   k_12_total 830 49 38 *   16       * 54           30         240   155   989 830 49 38     16         54           30     240 155   989
3307516 MO     school 2923580 96095   PARKWAY C-2 292358001555 3080 WEST MIDDLE   Regular School No 2 06 08 2015   k_12_total 699 103 37 *   118       * 29           *         145   195   987 699 103 37     118         29                 145 195   987
3069599 MO     school 2922530 22089   Nixa Public Schools 292253000425 3000 NIXA JUNIOR HIGH   Regular School No Middle 07 08 2021   k_12_total                                                   985                                             985
3303226 MO     school 2910500 50014   DESOTO 73 291050000350 1050 DESOTO SR. HIGH   Regular School No High 09 12 2017   k_12_total 958 17 * *   *       * *           *         345   142   985 958 17                                   345 142   985
3305674 MO     school 2931440 85046   WAYNESVILLE R-VI 293144002168 4040 WAYNESVILLE EAST ELEM.   Regular School No Elementary PK 02 2017   k_12_total 571 135 67 *   22       13 173           59         442   161   985 571 135 67     22       13 173           59     442 161   985
3307806 MO     school 2917820 96106   LADUE 291782000944 3000 LADUE MIDDLE   Regular School No Middle 06 08 2018   k_12_total 541 160 55 *   160       * 65           19         112   118   984 541 160 55     160         65           19     112 118   984
3301422 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531001706 3060 MORELAND RIDGE MIDDLE   Regular School No Middle 06 08 2017   k_12_total 734 74 87 *   19       * 61           5         315   102   983 734 74 87     19         61           5     315 102   983
3302176 MO     school 2916400 48078   KANSAS CITY 33 291640000880 1580 EAST HIGH SCHOOL   Regular School No High 09 12 2017   k_12_total 85 380 418 *   93       * *           465         *   111   983 85 380 418     93                     465       111   983
3303425 MO     school 2918270 53113   LEBANON R-III 291827000971 2050 LEBANON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   k_12_total 903 17 31 *   6       * 18           *         601   129   982 903 17 31     6         18                 601 129   982
3070386 MO     school 2931020 51159   WARRENSBURG R-VI 293102002145 1050 WARRENSBURG HIGH   Regular School No High 09 12 2021   k_12_total                                                   980                                             980
3306046 MO     school 2908370 92087   FT. ZUMWALT R-II 290837002427 3070 FT. ZUMWALT SOUTH MIDDLE   Regular School No 2 06 08 2015   k_12_total 825 49 30 *   45       * 25           10         135   117   980 825 49 30     45         25           10     135 117   980
3307808 MO     school 2917820 96106   LADUE 291782000944 3000 LADUE MIDDLE   Regular School No Middle 06 08 2020   k_12_total 538 160 46 *   157       * 78           10         104   113   980 538 160 46     157         78           10     104 113   980
3069792 MO     school 2929490 32058   STEWARTSVILLE C-2 292949002042 1050 STEWARTSVILLE HIGH   Regular School No High 07 12 2021   k_12_total                                                   98                                             98
3070492 MO     school 2903480 61150   ATLANTA C-3 290348000029 4020 ATLANTA ELEM.   Regular School No Elementary KG 06 2021   k_12_total                                                   98                                             98
3297228 MO     school 2918420 9078   LEOPOLD R-III 291842000988 4020 LEOPOLD ELEM.   Regular School No 1 KG 06 2016   k_12_total 98 * * *   *       * *           *         33   11   98 98                                     33 11   98
3298183 MO     school 2910620 16092   DELTA R-V 291062000357 4020 DELTA ELEM.   Regular School No Elementary PK 06 2019   k_12_total 92 * * *   *       * *           *         55   14   98 92                                     55 14   98
3300949 MO     school 2922770 41003   NORTH HARRISON R-III 292277001256 4020 NORTH HARRISON ELEM.   Regular School No Elementary PK 06 2019   k_12_total 95 * * *   *       * *           *         62   15   98 95                                     62 15   98
3300950 MO     school 2922770 41003   NORTH HARRISON R-III 292277001256 4020 NORTH HARRISON ELEM.   Regular School No Elementary PK 06 2020   k_12_total 94 * * *   *       * *           *         64   13   98 94                                     64 13   98
3303832 MO     school 2920640 58108   MEADVILLE R-IV 292064001108 1050 MEADVILLE HIGH   Regular School No 3 07 12 2016   k_12_total 93 * * *   *       * *           *         29   10   98 93                                     29 10   98
3304136 MO     school 2920280 64072   MARION CO. R-II 292028001075 1050 MARION CO. HIGH   Regular School No High 07 12 2019   k_12_total 98 * * *   *       * *           *         42   17   98 98                                     42 17   98
3304143 MO     school 2920280 64072   MARION CO. R-II 292028001074 4020 MARION CO. ELEM.   Regular School No Elementary PK 06 2020   k_12_total 97 * * *   *       * *           *         46   6   98 97                                     46 6   98
3304405 MO     school 2915660 68074   JAMESTOWN C-1 291566000742 4020 JAMESTOWN C-I ELEM.   Regular School No 1 PK 06 2015   k_12_total 95 * * *   *       * *           *         28   14   98 95                                     28 14   98
3304747 MO     school 2922560 74187   NODAWAY-HOLT R-VII 292256002816 4020 NODAWAY-HOLT ELEM.   Regular School No Elementary PK 06 2018   k_12_total 93 * * *   *       * *           *         39   14   98 93                                     39 14   98
3304829 MO     school 2928500 74202   SOUTH NODAWAY CO. R-IV 292850001760 4020 SOUTH NODAWAY ELEM.   Regular School No Elementary PK 06 2020   k_12_total 94 * * *   *       * *           *         36   7   98 94                                     36 7   98
3304835 MO     school 2910200 75084   COUCH R-I 291020000328 1050 COUCH HIGH   Regular School No High 07 12 2020   k_12_total 89 * * *   *       * 6           *         48   14   98 89                   6                 48 14   98
3305092 MO     school 2903040 79078   ALTENBURG 48 290304000014 4020 ALTENBURG ELEM.   Regular School No Elementary KG 08 2019   k_12_total 94 * * *   *       * *           *         20   21   98 94                                     20 21   98
3305093 MO     school 2903040 79078   ALTENBURG 48 290304000014 4020 ALTENBURG ELEM.   Regular School No Elementary KG 08 2020   k_12_total 97 * * *   *       * *           *         28   19   98 97                                     28 19   98
3308186 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676003168 1069 SOUTHVIEW HIGH   Regular School No High 09 12 2019   k_12_total 85 5 * *   *       * *           *         27   *   98 85 5                                   27     98
3308187 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676003168 1069 SOUTHVIEW HIGH   Regular School No High 09 12 2020   k_12_total 86 5 * *   *       * *           5         21   *   98 86 5                             5     21     98
3308661 MO     school 2915390 104041   HURLEY R-I 291539000701 1050 HURLEY HIGH   Regular School No High 07 12 2019   k_12_total 96 * * *   *       * *           *         71.1   9   98 96                                       9   98
3308907 MO     school 2929730 107151   SUCCESS R-VI 292973002054 4020 SUCCESS ELEM.   Regular School No Elementary PK 08 2017   k_12_total 96 * * *   *       * *           *         *   19   98 96                                       19   98
3309182 MO     school 2930720 110031   VALLEY R-VI 293072002117 4020 BELGRADE ELEM.   Regular School No 1 KG 02 2016   k_12_total 95 * * *   *       * *           *         59   11   98 95                                     59 11   98
3299436 MO     school 2916190 26006   JEFFERSON CITY 291619000476 3000 LEWIS AND CLARK MIDDLE   Regular School No Middle 06 08 2019   k_12_total 607 200 58 *   11       * 103           5         567   117   979 607 200 58     11         103           5     567 117   979
3302612 MO     school 2907350 49132   CARL JUNCTION R-I 290735000198 1050 Carl Junction High School   Regular School No High 09 12 2017   k_12_total 869 15 38 9   15       * 33           *         249   88   979 869 15 38 9   15         33                 249 88   979
3303224 MO     school 2910500 50014   DESOTO 73 291050000350 1050 DESOTO SR. HIGH   Regular School No 3 09 12 2015   k_12_total 949 18 5 *   *       * *           *         379   158   979 949 18 5                                 379 158   979
3309093 MO     school 2931050 109003   WARREN CO. R-III 293105002151 1050 WARRENTON HIGH   Regular School No High 09 12 2018   k_12_total 855 36 55 5   6       * 22           *         408   149   979 855 36 55 5   6         22                 408 149   979
3298547 MO     school 2904620 19152   BELTON 124 290462000055 1050 BELTON HIGH   Regular School No 3 10 12 2015   k_12_total 712 130 99 *   6       * 26           10         425   119   978 712 130 99     6         26           10     425 119   978
3305673 MO     school 2931440 85046   WAYNESVILLE R-VI 293144002168 4040 WAYNESVILLE EAST ELEM.   Regular School No 1 PK 02 2016   k_12_total 574 140 60 *   24       10 165           75         486   141   976 574 140 60     24       10 165           75     486 141   976
3309419 MO     school 2929280 115115   ST. LOUIS CITY 292928000434 1220 GATEWAY HIGH   Regular School No High 09 12 2020   k_12_total 153 616 140 *   66       * *           181         *   151   976 153 616 140     66                     181       151   976
3304165 MO     school 2913650 64075   HANNIBAL 60 291365000595 1050 HANNIBAL SR. HIGH   Regular School No High 09 12 2018   k_12_total 834 78 21 *   6       * 33           *         415   128   975 834 78 21     6         33                 415 128   975
3308415 MO     school 2928260 100063   SIKESTON R-6 292826001744 1050 SIKESTON SR. HIGH   Regular School No 3 09 12 2015   k_12_total 576 357 32 *   8       * *           *         516.3   103   975 576 357 32     8                             103   975
3070180 MO     school 2916400 48078   KANSAS CITY 33 291640000844 1220 LINCOLN COLLEGE PREP.   Regular School No High 09 12 2021   k_12_total                                                   974                                             974
3307804 MO     school 2917820 96106   LADUE 291782000944 3000 LADUE MIDDLE   Regular School No 2 06 08 2016   k_12_total 584 150 45 *   143       * 48           5         100   104   974 584 150 45     143         48           5     100 104   974
3309090 MO     school 2931050 109003   WARREN CO. R-III 293105002151 1050 WARRENTON HIGH   Regular School No 3 09 12 2015   k_12_total 874 33 33 5   *       * 25           *         441   138   974 874 33 33 5             25                 441 138   974
3301620 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830002806 3050 SUMMIT LAKES MIDDLE   Regular School No 2 07 08 2015   k_12_total 777 107 35 *   16       * 37           *         89   91   973 777 107 35     16         37                 89 91   973
3301631 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830000982 3080 PLEASANT LEA MIDDLE   Regular School No Middle 07 08 2020   k_12_total 727 113 38 *   23       8 61           22         245   89   973 727 113 38     23       8 61           22     245 89   973
3302174 MO     school 2916400 48078   KANSAS CITY 33 291640000880 1580 EAST HIGH SCHOOL   Regular School No 3 08 12 2015   k_12_total 95 290 468 *   113       * *           457         *   107   973 95 290 468     113                     457       107   973
3303354 MO     school 2931020 51159   WARRENSBURG R-VI 293102002145 1050 WARRENSBURG HIGH   Regular School No High 09 12 2019   k_12_total 766 46 54 9   18       10 70           6         234   64   973 766 46 54 9   18       10 70           6     234 64   973
3307123 MO     school 2926850 96091   ROCKWOOD R-VI 292685000706 3060 ROCKWOOD SOUTH MIDDLE   Regular School No 2 06 08 2016   k_12_total 803 92 19 *   40       * 17           6         158   147   973 803 92 19     40         17           6     158 147   973
3303227 MO     school 2910500 50014   DESOTO 73 291050000350 1050 DESOTO SR. HIGH   Regular School No High 09 12 2018   k_12_total 947 9 8 *   *       * *           *         343   149   972 947 9 8                                 343 149   972
3305248 MO     school 2926890 81096   ROLLA 31 292689001635 3000 ROLLA MIDDLE   Regular School No Middle 04 06 2018   k_12_total 817 36 42 8   29       * 39           26         477   113   972 817 36 42 8   29         39           26     477 113   972
3308226 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676002628 9990 EXTERNAL SITES   Regular School No Other KG 12 2017   k_12_total 729 201 22 *   17       * *           *         213   *   972 729 201 22     17                           213     972
3070093 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830000982 3080 PLEASANT LEA MIDDLE   Regular School No Middle 07 08 2021   k_12_total                                                   971                                             971

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