enrollments

Data source: Big Local News · About: Big Local

257,968 rows where state = "MO" sorted by free_and_reduced_int

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
3299985 3299985 MO     school 2928620 35099   SOUTHLAND C-9 292862001769 4020 SOUTHLAND ELEM.   Regular School No 1 PK 06 2016   k_12_total 125 * 21 *   *       * *           16         *   20   146 125   21                           16       20   146
3299986 3299986 MO     school 2928620 35099   SOUTHLAND C-9 292862001769 4020 SOUTHLAND ELEM.   Regular School No Elementary PK 06 2017   k_12_total 120 * 21 *   *       * *           15         *   18   142 120   21                           15       18   142
3299987 3299987 MO     school 2928620 35099   SOUTHLAND C-9 292862001769 4020 SOUTHLAND ELEM.   Regular School No Elementary PK 06 2018   k_12_total 113 * 21 *   *       * *           18         *   16   137 113   21                           18       16   137
3299988 3299988 MO     school 2928620 35099   SOUTHLAND C-9 292862001769 4020 SOUTHLAND ELEM.   Regular School No Elementary PK 06 2019   k_12_total 102 11 17 *   *       * 5           14         *   21   135 102 11 17               5           14       21   135
3299989 3299989 MO     school 2928620 35099   SOUTHLAND C-9 292862001769 4020 SOUTHLAND ELEM.   Regular School No Elementary PK 06 2020   k_12_total 100 * 24 *   *       * *           12         *   15   130 100   24                           12       15   130
3299996 3299996 MO     school 2916500 35102   KENNETT 39 291650002654 3000 KENNETT MIDDLE   Regular School No 2 06 08 2015   k_12_total 263 121 32 *   *       * *           *         313.1   56   421 263 121 32                                   56   421
3300014 3300014 MO     school 2916500 35102   KENNETT 39 291650002656 7500 EARLY CHILDHOOD CTR.   Regular School No 1 PK PK 2015   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300015 3300015 MO     school 2916500 35102   KENNETT 39 291650002656 7500 EARLY CHILDHOOD CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300016 3300016 MO     school 2916500 35102   KENNETT 39 291650002656 7500 EARLY CHILDHOOD CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300017 3300017 MO     school 2916500 35102   KENNETT 39 291650002656 7500 EARLY CHILDHOOD CTR.   Regular School No Prekindergarten PK PK 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300018 3300018 MO     school 2916500 35102   KENNETT 39 291650002656 7500 EARLY CHILDHOOD CTR.   Regular School No Prekindergarten PK PK 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300019 3300019 MO     school 2916500 35102   KENNETT 39 291650002656 7500 EARLY CHILDHOOD CTR.   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300029 3300029 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346001356 1050 PACIFIC HIGH   Regular School No High 09 12 2018   k_12_total 840 15 13 6   5       * 21           *         339.1   165   901 840 15 13 6   5         21                   165   901
3300030 3300030 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346001356 1050 PACIFIC HIGH   Regular School No High 09 12 2019   k_12_total 815 14 17 *   5       * 22           *         330.1   160   878 815 14 17     5         22                   160   878
3300031 3300031 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346001356 1050 PACIFIC HIGH   Regular School No High 09 12 2020   k_12_total 830 13 25 6   5       * 30           6         382.2   174   909 830 13 25 6   5         30           6       174   909
3300041 3300041 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346002864 3020 RIVERBEND SCH.   Regular School No Middle 08 08 2018   k_12_total 204 * 13 *   *       * 8           *         112.4   47   230 204   13               8                   47   230
3300045 3300045 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346001353 4020 COLEMAN ELEM.   Regular School No 1 KG 05 2016   k_12_total 334 * 19 5   *       * 29           *         257.4   68   391 334   19 5             29                   68   391
3300056 3300056 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346001359 4040 ZITZMAN ELEM.   Regular School No 1 KG 05 2015   k_12_total 429 11 26 *   9       * 8           7         230.3   85   485 429 11 26     9         8           7       85   485
3300057 3300057 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346001359 4040 ZITZMAN ELEM.   Regular School No 1 KG 05 2016   k_12_total 404 9 29 *   9       * 7           11         214.2   85   460 404 9 29     9         7           11       85   460
3300058 3300058 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346001359 4040 ZITZMAN ELEM.   Regular School No Elementary KG 05 2017   k_12_total 395 8 24 *   8       * 11           16         231.4   76   451 395 8 24     8         11           16       76   451
3300065 3300065 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346001357 4060 ROBERTSVILLE ELEM.   Regular School No Elementary KG 05 2018   k_12_total 115 * * *   *       * 8           *         65.4   20   127 115                   8                   20   127
3300074 3300074 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346000881 7520 MERAMEC VALLEY EARLY CHILD.   Regular School No 1 PK PK 2015   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300075 3300075 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346000881 7520 MERAMEC VALLEY EARLY CHILD.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300076 3300076 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346000881 7520 MERAMEC VALLEY EARLY CHILD.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300077 3300077 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346000881 7520 MERAMEC VALLEY EARLY CHILD.   Regular School No Prekindergarten PK PK 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300078 3300078 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346000881 7520 MERAMEC VALLEY EARLY CHILD.   Regular School No Prekindergarten PK PK 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300079 3300079 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346002278 7540 MERAMEC VALLEY COMMUNITY SCH.   Regular School No 1 PK PK 2015   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300080 3300080 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346002278 7540 MERAMEC VALLEY COMMUNITY SCH.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300081 3300081 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346002278 7540 MERAMEC VALLEY COMMUNITY SCH.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300082 3300082 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346002278 7540 MERAMEC VALLEY COMMUNITY SCH.   Regular School No Prekindergarten PK PK 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300083 3300083 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346002278 7540 DORIS HOFFMAN EARLY LEARNING C   Regular School No Prekindergarten PK PK 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300084 3300084 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346002278 7540 DORIS HOFFMAN EARLY LEARNING C   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300085 3300085 MO     school 2930570 36131   UNION R-XI 293057002101 1050 UNION HIGH   Regular School No 3 09 12 2015   k_12_total 862 20 * *   *       * *           *         295.4   55   893 862 20                                     55   893
3300086 3300086 MO     school 2930570 36131   UNION R-XI 293057002101 1050 UNION HIGH   Regular School No 3 09 12 2016   k_12_total 864 18 8 *   5       * 10           *         307.4   56   905 864 18 8     5         10                   56   905
3300093 3300093 MO     school 2930570 36131   UNION R-XI 293057002575 3000 UNION MIDDLE   Regular School No Middle 07 08 2017   k_12_total 470 8 9 *   *       * *           *         230.1   34   495 470 8 9                                   34   495
3300097 3300097 MO     school 2930570 36131   UNION R-XI 293057002096 4010 CLARK-VITT ELEM.   Regular School No 2 04 06 2015   k_12_total 531 9 12 *   *       * *           *         272.2   55   561 531 9 12                                   55   561
3300098 3300098 MO     school 2930570 36131   UNION R-XI 293057002096 4010 CLARK-VITT ELEM.   Regular School No 2 04 06 2016   k_12_total 527 14 9 *   *       * 10           5         259.4   61   567 527 14 9               10           5       61   567
3300101 3300101 MO     school 2930570 36131   UNION R-XI 293057002096 4010 CLARK-VITT ELEM.   Regular School No Middle 04 06 2019   k_12_total 514 10 22 *   *       * 28           7         290.2   89   575 514 10 22               28           7       89   575
3300102 3300102 MO     school 2930570 36131   UNION R-XI 293057002096 4010 CLARK-VITT ELEM.   Regular School No Middle 04 06 2020   k_12_total 489 17 14 *   *       * 25           6         302.4   82   548 489 17 14               25           6       82   548
3300108 3300108 MO     school 2930570 36131   UNION R-XI 293057002097 4020 BEAUFORT ELEM.   Regular School No Elementary PK 06 2020   k_12_total 371 * * *   *       * *           *         149.1   56   381 371                                       56   381
3300112 3300112 MO     school 2930570 36131   UNION R-XI 293057002098 4040 CENTRAL ELEM.   Regular School No Elementary PK 03 2018   k_12_total 595 * 19 *   *       * 49           23         355.2   99   669 595   19               49           23       99   669
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
3300141 3300141 MO     school 2929100 36136   ST. CLAIR R-XIII 292910001864 1050 ST. CLAIR HIGH   Regular School No High 09 12 2017   k_12_total 707 8 7 *   *       * 9           *         301.4   71   738 707 8 7               9                   71   738
3300152 3300152 MO     school 2929100 36136   ST. CLAIR R-XIII 292910001865 4020 ST. CLAIR ELEM.   Regular School No 1 PK 02 2016   k_12_total 452 * * *   *       * 24           *         291.1   46   480 452                   24                   46   480
3300166 3300166 MO     school 2929760 36137   SULLIVAN 292976002057 1050 SULLIVAN SR. HIGH   Regular School No High 09 12 2018   k_12_total 697 5 20 *   *       * *           *         235.2   79   733 697 5 20                                   79   733
3300170 3300170 MO     school 2929760 36137   SULLIVAN 292976002056 3000 SULLIVAN MIDDLE   Regular School No 2 06 08 2016   k_12_total 458 * 16 *   *       * *           *         264.2   76   485 458   16                                   76   485
3300173 3300173 MO     school 2929760 36137   SULLIVAN 292976002056 3000 SULLIVAN MIDDLE   Regular School No Middle 06 08 2019   k_12_total 445 5 22 *   *       * *           *         259.2   91   479 445 5 22                                   91   479
3300174 3300174 MO     school 2929760 36137   SULLIVAN 292976002056 3000 SULLIVAN MIDDLE   Regular School No Middle 06 08 2020   k_12_total 410 5 18 *   *       * *           *         233.4   84   441 410 5 18                                   84   441
3300175 3300175 MO     school 2929760 36137   SULLIVAN 292976002055 4020 SULLIVAN ELEM.   Regular School No 1 02 05 2015   k_12_total 612 * 24 7   *       * 9           14         420.4   97   656 612   24 7             9           14       97   656
3300176 3300176 MO     school 2929760 36137   SULLIVAN 292976002055 4020 SULLIVAN ELEM.   Regular School No 1 02 05 2016   k_12_total 623 5 25 7   *       * 8           14         404.4   93   669 623 5 25 7             8           14       93   669
3300180 3300180 MO     school 2929760 36137   SULLIVAN 292976002055 4020 SULLIVAN ELEM.   Regular School No Elementary 03 05 2020   k_12_total 423 * 14 *   *       * 8           *         243.3   69   449 423   14               8                   69   449
3300206 3300206 MO     school 2931110 36139   WASHINGTON 293111002163 1050 WASHINGTON HIGH   Regular School No 3 09 12 2016   k_12_total 1277 15 19 *   18       * 9           25         329.2   159   1343 1277 15 19     18         9           25       159   1343
3300207 3300207 MO     school 2931110 36139   WASHINGTON 293111002163 1050 WASHINGTON HIGH   Regular School No High 09 12 2017   k_12_total 1276 8 15 *   14       * 10           17         290.4   140   1326 1276 8 15     14         10           17       140   1326
3300208 3300208 MO     school 2931110 36139   WASHINGTON 293111002163 1050 WASHINGTON HIGH   Regular School No High 09 12 2018   k_12_total 1270 10 18 *   13       * 15           18         258.2   127   1329 1270 10 18     13         15           18       127   1329
3300210 3300210 MO     school 2931110 36139   WASHINGTON 293111002163 1050 WASHINGTON HIGH   Regular School No High 09 12 2020   k_12_total 1276 11 27 *   12       * 16           18         272.1   141   1342 1276 11 27     12         16           18       141   1342
3300211 3300211 MO     school 2931110 36139   WASHINGTON 293111002160 3000 WASHINGTON MIDDLE   Regular School No 2 07 08 2015   k_12_total 590 6 9 *   7       * *           12         212.4   58   614 590 6 9     7                     12       58   614
3300214 3300214 MO     school 2931110 36139   WASHINGTON 293111002160 3000 WASHINGTON MIDDLE   Regular School No Middle 07 08 2018   k_12_total 581 5 17 *   *       * 10           7         192.1   90   615 581 5 17               10           7       90   615
3300215 3300215 MO     school 2931110 36139   WASHINGTON 293111002160 3000 WASHINGTON MIDDLE   Regular School No Middle 07 08 2019   k_12_total 599 8 16 *   *       * 19           *         196.1   92   646 599 8 16               19                   92   646
3300216 3300216 MO     school 2931110 36139   WASHINGTON 293111002160 3000 WASHINGTON MIDDLE   Regular School No Middle 07 08 2020   k_12_total 554 * 15 *   *       * 22           *         200.2   83   600 554   15               22                   83   600
3300224 3300224 MO     school 2931110 36139   WASHINGTON 293111002157 4040 CAMPBELLTON ELEM.   Regular School No 1 PK 06 2016   k_12_total 141 * * *   *       * 6           *         42.1   10   148 141                   6                   10   148
3300225 3300225 MO     school 2931110 36139   WASHINGTON 293111002157 4040 CAMPBELLTON ELEM.   Regular School No Elementary PK 06 2017   k_12_total 147 * * *   *       * 5           *         32.1   16   153 147                   5                   16   153
3300228 3300228 MO     school 2931110 36139   WASHINGTON 293111002157 4040 CAMPBELLTON ELEM.   Regular School No Elementary PK 06 2020   k_12_total 151 * * *   *       * *           *         22.4   17   156 151                                       17   156
3300235 3300235 MO     school 2931110 36139   WASHINGTON 293111002159 4080 FIFTH STREET ELEM.   Regular School No 1 KG 06 2015   k_12_total 105 * * *   *       * *           *         60.4   10   113 105                                       10   113
3300238 3300238 MO     school 2931110 36139   WASHINGTON 293111002161 4100 LABADIE ELEM.   Regular School No Elementary PK 06 2017   k_12_total 128 * * *   *       * 5           *         29.1   7   133 128                   5                   7   133
3300239 3300239 MO     school 2931110 36139   WASHINGTON 293111002161 4100 LABADIE ELEM.   Regular School No Elementary PK 06 2018   k_12_total 133 * * *   *       * 6           *         32.1   13   139 133                   6                   13   139
3300240 3300240 MO     school 2931110 36139   WASHINGTON 293111002161 4100 LABADIE ELEM.   Regular School No Elementary PK 06 2019   k_12_total 135 * * *   *       * *           *         19.1   14   137 135                                       14   137
3300241 3300241 MO     school 2931110 36139   WASHINGTON 293111002161 4100 LABADIE ELEM.   Regular School No Elementary PK 06 2020   k_12_total 136 * * *   *       * *           *         24.1   10   139 136                                       10   139
3300242 3300242 MO     school 2931110 36139   WASHINGTON 293111002162 4120 MARTHASVILLE ELEM.   Regular School No 1 KG 06 2015   k_12_total 219 * * *   *       * 8           *         85.1   23   236 219                   8                   23   236
3300243 3300243 MO     school 2931110 36139   WASHINGTON 293111002162 4120 MARTHASVILLE ELEM.   Regular School No 1 KG 06 2016   k_12_total 197 * * *   *       * 9           *         89.1   17   213 197                   9                   17   213
3300244 3300244 MO     school 2931110 36139   WASHINGTON 293111002162 4120 MARTHASVILLE ELEM.   Regular School No Elementary KG 06 2017   k_12_total 203 * * *   *       * 6           *         76.1   20   215 203                   6                   20   215
3300249 3300249 MO     school 2931110 36139   WASHINGTON 293111002164 4140 SOUTH POINT ELEM.   Regular School No 1 KG 06 2016   k_12_total 403 7 8 *   *       * 11           5         199.4   42   431 403 7 8               11           5       42   431
3300250 3300250 MO     school 2931110 36139   WASHINGTON 293111002164 4140 SOUTH POINT ELEM.   Regular School No Elementary KG 06 2017   k_12_total 416 * * *   *       * 15           *         187.4   53   440 416                   15                   53   440
3300252 3300252 MO     school 2931110 36139   WASHINGTON 293111002164 4140 SOUTH POINT ELEM.   Regular School No Elementary KG 06 2019   k_12_total 392 * * *   *       * 32           *         164.4   68   433 392                   32                   68   433
3300253 3300253 MO     school 2931110 36139   WASHINGTON 293111002164 4140 SOUTH POINT ELEM.   Regular School No Elementary KG 06 2020   k_12_total 374 * * *   *       * 27           *         167.4   76   409 374                   27                   76   409
3300258 3300258 MO     school 2931110 36139   WASHINGTON 293111002295 4160 WASHINGTON WEST ELEM.   Regular School No Elementary KG 06 2019   k_12_total 577 * 15 *   *       * 16           14         224.1   152   613 577   15               16           14       152   613
3300259 3300259 MO     school 2931110 36139   WASHINGTON 293111002295 4160 WASHINGTON WEST ELEM.   Regular School No Elementary KG 06 2020   k_12_total 581 * 16 *   7       * 26           18         241.1   160   634 581   16     7         26           18       160   634
3300260 3300260 MO     school 2931110 36139   WASHINGTON 293111002833 7500 EARLY LEARNING CENTER   Regular School No 1 PK PK 2015   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300261 3300261 MO     school 2931110 36139   WASHINGTON 293111002833 7500 EARLY LEARNING CENTER   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300262 3300262 MO     school 2931110 36139   WASHINGTON 293111002833 7500 EARLY LEARNING CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300263 3300263 MO     school 2931110 36139   WASHINGTON 293111002833 7500 EARLY LEARNING CENTER   Regular School No Prekindergarten PK PK 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300264 3300264 MO     school 2931110 36139   WASHINGTON 293111002833 7500 EARLY LEARNING CENTER   Regular School No Prekindergarten PK PK 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300265 3300265 MO     school 2931110 36139   WASHINGTON 293111002833 7500 EARLY LEARNING CENTER   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300266 3300266 MO     school 2923340 37037   GASCONADE CO. R-II 292334001347 1050 OWENSVILLE HIGH   Regular School No 3 09 12 2015   k_12_total 556 * 12 *   *       * *           *         230.3   60   575 556   12                                   60   575
3300267 3300267 MO     school 2923340 37037   GASCONADE CO. R-II 292334001347 1050 OWENSVILLE HIGH   Regular School No 3 09 12 2016   k_12_total 571 * 12 *   *       * *           *         232.4   63   591 571   12                                   63   591
3300268 3300268 MO     school 2923340 37037   GASCONADE CO. R-II 292334001347 1050 OWENSVILLE HIGH   Regular School No High 09 12 2017   k_12_total 536 * 13 *   *       * *           *         230.4   59   562 536   13                                   59   562
3300272 3300272 MO     school 2923340 37037   GASCONADE CO. R-II 292334001477 3000 OWENSVILLE MIDDLE   Regular School No 2 06 08 2015   k_12_total 392 * 5 *   *       * 6           *         195.4   46   409 392   5               6                   46   409
3300280 3300280 MO     school 2923340 37037   GASCONADE CO. R-II 292334001343 4020 GERALD ELEM.   Regular School No Elementary PK 05 2017   k_12_total 280 * * *   *       * *           *         170.3   44   289 280                                       44   289
3300289 3300289 MO     school 2923340 37037   GASCONADE CO. R-II 292334003008 4050 OWENSVILLE ELEM.   Regular School No Elementary PK 05 2020   k_12_total 505 * * *   *       * 5           *         241.2   76   521 505                   5                   76   521
3300290 3300290 MO     school 2914280 37039   GASCONADE CO. R-I 291428000646 1050 HERMANN HIGH   Regular School No 3 09 12 2015   k_12_total 317 * * *   *       * 13           *         119.2   40   337 317                   13                   40   337
3300297 3300297 MO     school 2914280 37039   GASCONADE CO. R-I 291428002464 3000 HERMANN MIDDLE   Regular School No 2 04 08 2016   k_12_total 349 * * *   *       * 8           *         187.4   79   363 349                   8                   79   363
3300302 3300302 MO     school 2914280 37039   GASCONADE CO. R-I 291428000644 4060 HERMANN ELEM.   Regular School No 1 PK 03 2015   k_12_total 279 * * *   *       * *           *         175.3   61   286 279                                       61   286
3300303 3300303 MO     school 2914280 37039   GASCONADE CO. R-I 291428000644 4060 HERMANN ELEM.   Regular School No 1 PK 03 2016   k_12_total 265 * 5 *   *       * *           *         157.4   49   278 265   5                                   49   278
3300305 3300305 MO     school 2914280 37039   GASCONADE CO. R-I 291428000644 4060 HERMANN ELEM.   Regular School No Elementary PK 04 2018   k_12_total 298 * * *   *       * 8           *         165.2   60   314 298                   8                   60   314
3300306 3300306 MO     school 2914280 37039   GASCONADE CO. R-I 291428000644 4060 HERMANN ELEM.   Regular School No Elementary PK 04 2019   k_12_total 279 * * *   *       * 5           *         140.2   57   289 279                   5                   57   289
3300307 3300307 MO     school 2914280 37039   GASCONADE CO. R-I 291428000644 4060 HERMANN ELEM.   Regular School No Elementary PK 03 2020   k_12_total 222 * * *   *       * *           *         102.1   37   232 222                                       37   232

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