Data source: Big Local News · About: Big Local

36,720 rows where state = "MO" and year = 2017 sorted by ell_int

View and edit SQL

grade

year

  • 2017 · 36,720
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
3296681 MO     school 2922980 1090   ADAIR CO. R-I 292298001315 1050 ADAIR CO. HIGH   Regular School No High 07 12 2017   k_12_total 115 * * *   *       * *           *         65   18   116 115                                     65 18   116
3296687 MO     school 2922980 1090   ADAIR CO. R-I 292298001314 4020 ADAIR CO. ELEM.   Regular School No Elementary PK 06 2017   k_12_total 113 * * *   *       * *           *         72   11   114 113                                     72 11   114
3296717 MO     school 2905790 1092   ADAIR CO. R-II 290579000125 1050 ADAIR CO. HIGH   Regular School No High 07 12 2017   k_12_total 76 * * *   *       * *           *         33   19   80 76                                     33 19   80
3296723 MO     school 2905790 1092   ADAIR CO. R-II 290579000124 4020 ADAIR CO. ELEM.   Regular School No Elementary KG 06 2017   k_12_total 89 * * *   *       * *           *         45   15   95 89                                     45 15   95
3296729 MO     school 2922710 2089   NORTH ANDREW CO. R-VI 292271001251 1050 NORTH ANDREW HIGH   Regular School No High 09 12 2017   k_12_total 111 * * *   *       * *           *         48   19   113 111                                     48 19   113
3296735 MO     school 2922710 2089   NORTH ANDREW CO. R-VI 292271000006 3000 NORTH ANDREW MIDDLE   Regular School No Middle 06 08 2017   k_12_total 104 * * *   *       * *           *         47   21   104 104                                     47 21   104
3296741 MO     school 2922710 2089   NORTH ANDREW CO. R-VI 292271001250 4020 NORTH ANDREW ELEM.   Regular School No Elementary KG 05 2017   k_12_total 153 * * *   *       * *           *         57   14   153 153                                     57 14   153
3296747 MO     school 2904080 2090   AVENUE CITY R-IX 290408000037 4020 AVENUE CITY ELEM.   Regular School No Elementary PK 08 2017   k_12_total 141 * * *   *       * 6           *         24   7   151 141                   6                 24 7   151
3296753 MO     school 2927570 2097   SAVANNAH R-III 292757001693 1050 SAVANNAH HIGH   Regular School No High 09 12 2017   k_12_total 703 12 13 *   6       * 10           *         201   77   750 703 12 13     6         10                 201 77   750
3296759 MO     school 2927570 2097   SAVANNAH R-III 292757001691 3000 SAVANNAH MIDDLE   Regular School No Middle 06 08 2017   k_12_total 503 13 17 *   *       * *           *         202   77   541 503 13 17                                 202 77   541
3296765 MO     school 2927570 2097   SAVANNAH R-III 292757001688 4010 AMAZONIA ELEM.   Regular School No Elementary PK 05 2017   k_12_total 90 * * *   *       * *           *         52   13   93 90                                     52 13   93
3296771 MO     school 2927570 2097   SAVANNAH R-III 292757001689 4015 HELENA ELEM.   Regular School No Elementary PK 05 2017   k_12_total 90 * * *   *       * *           *         31   11   97 90                                     31 11   97
3296777 MO     school 2927570 2097   SAVANNAH R-III 292757001690 4020 JOHN GLENN ELEM.   Regular School No Elementary PK 05 2017   k_12_total 250 15 14 *   *       * *           *         86   31   282 250 15 14                                 86 31   282
3296783 MO     school 2927570 2097   SAVANNAH R-III 292757001692 4040 MINNIE CLINE ELEM.   Regular School No Elementary PK 05 2017   k_12_total 522 6 9 *   *       * 8           *         232.3   84   549 522 6 9               8                   84   549
3296789 MO     school 2927570 2097   SAVANNAH R-III 292757003186 7500 EARLY CHILDHOOD LEARNING CTR   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3296795 MO     school 2929940 3031   TARKIO R-I 292994002067 1050 TARKIO HIGH   Regular School No High 07 12 2017   k_12_total 118 * * *   *       * *           *         50   24   122 118                                     50 24   122
3296801 MO     school 2929940 3031   TARKIO R-I 292994002066 4020 TARKIO ELEM.   Regular School No Elementary PK 06 2017   k_12_total 157 * 7 *   *       * *           *         86   20   168 157   7                                 86 20   168
3296807 MO     school 2926790 3032   ROCK PORT R-II 292679001613 1050 ROCK PORT HIGH   Regular School No High 07 12 2017   k_12_total 158 * * *   *       * *           *         38   14   159 158                                     38 14   159
3296813 MO     school 2926790 3032   ROCK PORT R-II 292679001612 4020 ROCK PORT ELEM.   Regular School No Elementary PK 06 2017   k_12_total 178 * * *   *       * *           *         78   16   182 178                                     78 16   182
3296819 MO     school 2911760 3033   FAIRFAX R-III 291176000433 1050 FAIRFAX HIGH   Regular School No High 07 12 2017   k_12_total 71 * * *   *       * *           *         37   *   74 71                                     37     74
3296825 MO     school 2911760 3033   FAIRFAX R-III 291176000432 4020 FAIRFAX ELEM.   Regular School No Elementary PK 06 2017   k_12_total 65 * * *   *       * *           *         29.2   8   67 65                                       8   67
3296831 MO     school 2910020 4106   COMMUNITY R-VI 291002000319 1050 COMMUNITY HIGH   Regular School No Other 06 12 2017   k_12_total 166 * * *   *       * *           *         64   16   169 166                                     64 16   169
3296837 MO     school 2910020 4106   COMMUNITY R-VI 291002000318 4020 COMMUNITY ELEM.   Regular School No Elementary PK 05 2017   k_12_total 115 * * *   *       * 6           *         75   25   122 115                   6                 75 25   122
3296843 MO     school 2930780 4109   VAN-FAR R-I 293078002124 1050 VAN-FAR JR./SR. HIGH   Regular School No High 07 12 2017   k_12_total 234 5 7 *   *       * 21           *         112   33   269 234 5 7               21                 112 33   269
3296849 MO     school 2930780 4109   VAN-FAR R-I 293078002125 4020 VAN-FAR ELEM.   Regular School No Elementary PK 06 2017   k_12_total 254 9 6 *   *       * 23           *         164   34   292 254 9 6               23                 164 34   292
3296867 MO     school 2920810 4110   MEXICO 59 292081001132 4020 EUGENE FIELD ELEM.   Regular School No Elementary KG 05 2017   k_12_total 325 43 23 *   *       * 43           *         *   37   435 325 43 23               43                   37   435
3296879 MO     school 2920810 4110   MEXICO 59 292081001134 4080 MCMILLAN ELEM.   Regular School No Elementary PK 05 2017   k_12_total 181 10 * *   *       * 19           *         *   23   214 181 10                 19                   23   214
3296897 MO     school 2928710 5121   SOUTHWEST R-V 292871001774 1050 SOUTHWEST HIGH   Regular School No High 09 12 2017   k_12_total 217 * 8 8   *       * *           *         139   28   239 217   8 8                               139 28   239
3296903 MO     school 2928710 5121   SOUTHWEST R-V 292871002801 3000 SOUTHWEST MIDDLE   Regular School No Middle 05 08 2017   k_12_total 247 * 12 *   *       * 8           *         163   35   270 247   12               8                 163 35   270
3296909 MO     school 2928710 5121   SOUTHWEST R-V 292871001773 4020 SOUTHWEST ELEM.   Regular School No Elementary PK 04 2017   k_12_total 283 * 12 5   *       * 6           *         206   40   306 283   12 5             6                 206 40   306
3296915 MO     school 2911670 5122   EXETER R-VI 291167000427 1050 EXETER HIGH   Regular School No High 09 12 2017   k_12_total 87 * * *   *       * *           *         66   7   92 87                                     66 7   92
3296968 MO     school 2928200 5127   SHELL KNOB 78 292820001735 4020 SHELL KNOB ELEM.   Regular School No Elementary PK 08 2017   k_12_total 112 * * *   *       * 8           *         *   22   123 112                   8                   22   123
3297004 MO     school 2918510 6101   LIBERAL R-II 291851001003 1050 LIBERAL HIGH   Regular School No High 09 12 2017   k_12_total 145 * 5 *   *       * *           *         70   17   154 145   5                                 70 17   154
3297010 MO     school 2918510 6101   LIBERAL R-II 291851002719 3000 LIBERAL MIDDLE   Regular School No Middle 06 08 2017   k_12_total 85 * * *   *       * *           *         53   8   90 85                                     53 8   90
3297016 MO     school 2918510 6101   LIBERAL R-II 291851001002 4020 LIBERAL ELEM.   Regular School No Elementary PK 05 2017   k_12_total 166 7 * *   *       * *           *         104   22   181 166 7                                   104 22   181
3297022 MO     school 2912930 6103   GOLDEN CITY R-III 291293000542 1050 GOLDEN CITY HIGH   Regular School No High 07 12 2017   k_12_total 77 * 6 *   *       * 7           *         59   16   91 77   6               7                 59 16   91
3297028 MO     school 2912930 6103   GOLDEN CITY R-III 291293000541 4020 GOLDEN CITY ELEM.   Regular School No Elementary KG 06 2017   k_12_total 90 * * *   *       * 12           *         70   14   102 90                   12                 70 14   102
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
3297046 MO     school 2917850 6104   LAMAR R-I 291785002467 3000 LAMAR MIDDLE   Regular School No Middle 06 08 2017   k_12_total 265 * 15 *   *       * 17           *         159   46   300 265   15               17                 159 46   300
3297064 MO     school 2920820 7121   MIAMI R-I 292082001139 1050 MIAMI HIGH   Regular School No High 07 12 2017   k_12_total 73 * 5 6   *       * *           *         36   8   87 73   5 6                               36 8   87
3297070 MO     school 2920820 7121   MIAMI R-I 292082001138 4020 MIAMI ELEM.   Regular School No Elementary PK 06 2017   k_12_total 73 * 6 *   *       * *           *         39   8   85 73   6                                 39 8   85
3297076 MO     school 2904170 7122   BALLARD R-II 290417000042 1050 BALLARD HIGH   Regular School No High 07 12 2017   k_12_total 52 * * *   *       * *           *         22.3   9   56 52                                       9   56
3297082 MO     school 2904170 7122   BALLARD R-II 290417000041 4020 BALLARD ELEM.   Regular School No Elementary PK 06 2017   k_12_total 66 * * *   *       * *           *         43   14   72 66                                     43 14   72
3297088 MO     school 2902850 7123   ADRIAN R-III 290285000002 1050 ADRIAN SR. HIGH   Regular School No Other 06 12 2017   k_12_total 346 * * *   *       * *           *         107   33   353 346                                     107 33   353
3297094 MO     school 2902850 7123   ADRIAN R-III 290285000001 4020 ADRIAN ELEM.   Regular School No Elementary PK 05 2017   k_12_total 325 * * *   *       * *           *         145   36   328 325                                     145 36   328
3297100 MO     school 2926310 7124   RICH HILL R-IV 292631001544 1050 RICH HILL HIGH   Regular School No High 07 12 2017   k_12_total 156 * * *   *       * *           *         99   19   158 156                                     99 19   158
3297106 MO     school 2926310 7124   RICH HILL R-IV 292631001545 4020 RICH HILL ELEM.   Regular School No Elementary PK 06 2017   k_12_total 150 * * *   *       * 7           *         *   23   161 150                   7                   23   161
3297112 MO     school 2915330 7125   HUME R-VIII 291533000699 1050 HUME HIGH   Regular School No High 07 12 2017   k_12_total 59 * * *   *       * *           *         31   5   60 59                                     31 5   60
3297118 MO     school 2915330 7125   HUME R-VIII 291533000698 4020 HUME ELEM.   Regular School No Elementary PK 06 2017   k_12_total 82 * * *   *       * *           *         62   13   85 82                                     62 13   85
3297124 MO     school 2915240 7126   HUDSON R-IX 291524000693 4020 HUDSON ELEM.   Regular School No Elementary PK 08 2017   k_12_total 40 * * *   *       * *           *         6   5   40 40                                     6 5   40
3297130 MO     school 2906360 7129   BUTLER R-V 290636000158 1050 BUTLER HIGH   Regular School No High 07 12 2017   k_12_total 447 9 8 *   *       * 5           *         233.3   54   475 447 9 8               5                   54   475
3297136 MO     school 2906360 7129   BUTLER R-V 290636000157 4020 BUTLER ELEM.   Regular School No Elementary PK 06 2017   k_12_total 491 7 12 *   *       * 24           *         330   82   536 491 7 12               24                 330 82   536
3297145 MO     school 2918670 8106   LINCOLN R-II 291867001016 1050 LINCOLN HIGH   Regular School No High 07 12 2017   k_12_total 211 * * *   *       * *           *         115   26   222 211                                     115 26   222
3297151 MO     school 2918670 8106   LINCOLN R-II 291867001015 4020 LINCOLN ELEM.   Regular School No Elementary KG 06 2017   k_12_total 251 * 6 *   *       * *           *         177   47   264 251   6                                 177 47   264
3297157 MO     school 2931070 8107   WARSAW R-IX 293107002152 1050 WARSAW HIGH   Regular School No High 09 12 2017   k_12_total 353 5 6 *   *       * *           *         *   60   371 353 5 6                                   60   371
3297163 MO     school 2931070 8107   WARSAW R-IX 293107002650 3000 JOHN BOISE MIDDLE   Regular School No Middle 06 08 2017   k_12_total 263 * 6 *   *       * *           *         *   50   275 263   6                                   50   275
3297169 MO     school 2931070 8107   WARSAW R-IX 293107002153 4020 NORTH ELEM.   Regular School No Elementary 03 05 2017   k_12_total 142 * * *   *       * 10           *         *   33   154 142                   10                   33   154
3297175 MO     school 2931070 8107   WARSAW R-IX 293107002154 4040 SOUTH ELEM.   Regular School No Elementary PK 05 2017   k_12_total 196 * * *   *       * 5           *         *   36   203 196                   5                   36   203
3297181 MO     school 2931070 8107   WARSAW R-IX 293107000834 4060 RUTH MERCER ELEM.   Regular School No Elementary KG 02 2017   k_12_total 144 * * *   *       * 10           *         *   39   159 144                   10                   39   159
3297186 MO     school 2909900 8111   COLE CAMP R-I 290990000293 1050 COLE CAMP HIGH   Regular School No High 09 12 2017   k_12_total 238 * 5 *   *       * *           *         103.3   28   246 238   5                                   28   246
3297192 MO     school 2909900 8111   COLE CAMP R-I 290990001389 3000 COLE CAMP MIDDLE   Regular School No Middle 05 08 2017   k_12_total 197 * * *   *       * *           *         104.3   21   204 197                                       21   204
3297203 MO     school 2909900 8111   COLE CAMP R-I 290990003248 7500 COLE CAMP PRESCHOOL   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297209 MO     school 2923640 9077   MEADOW HEIGHTS R-II 292364001406 1050 MEADOW HEIGHTS HIGH   Regular School No High 07 12 2017   k_12_total 224 * 6 *   *       * *           *         107   31   233 224   6                                 107 31   233
3297217 MO     school 2923640 9077   MEADOW HEIGHTS R-II 292364001407 4020 MEADOW HEIGHTS ELEM.   Regular School No Elementary PK 06 2017   k_12_total 305 * * *   *       * *           *         172.1   44   312 305                                       44   312
3297223 MO     school 2918420 9078   LEOPOLD R-III 291842000989 1050 LEOPOLD HIGH   Regular School No High 07 12 2017   k_12_total 86 * * *   *       * *           *         19   10   86 86                                     19 10   86
3297229 MO     school 2918420 9078   LEOPOLD R-III 291842000988 4020 LEOPOLD ELEM.   Regular School No Elementary KG 06 2017   k_12_total 113 * * *   *       * *           *         36   15   113 113                                     36 15   113
3297235 MO     school 2932490 9079   ZALMA R-V 293249002270 1050 ZALMA HIGH   Regular School No High 07 12 2017   k_12_total 113 * * *   *       * *           *         75   14   116 113                                     75 14   116
3297241 MO     school 2932490 9079   ZALMA R-V 293249002269 4020 ZALMA ELEM.   Regular School No Elementary KG 06 2017   k_12_total 128 * * *   *       * *           *         98   25   130 128                                     98 25   130
3297247 MO     school 2919350 9080   WOODLAND R-IV 291935001046 1050 WOODLAND HIGH   Regular School No High 09 12 2017   k_12_total 272 * * *   *       * *           *         142   30   276 272                                     142 30   276
3297253 MO     school 2919350 9080   WOODLAND R-IV 291935002985 3000 WOODLAND MIDDLE   Regular School No Middle 05 08 2017   k_12_total 255 * * *   *       * *           *         159   34   256 255                                     159 34   256
3297259 MO     school 2919350 9080   WOODLAND R-IV 291935001045 4040 WOODLAND ELEM.   Regular School No Elementary PK 04 2017   k_12_total 350 * * *   *       * *           *         252   42   353 350                                     252 42   353
3297265 MO     school 2928560 10087   SOUTHERN BOONE CO. R-I 292856001766 1050 SOUTHERN BOONE HIGH   Regular School No High 09 12 2017   k_12_total 442 6 12 *   *       * 11           *         55   34   476 442 6 12               11                 55 34   476
3297271 MO     school 2928560 10087   SOUTHERN BOONE CO. R-I 292856001596 3000 SOUTHERN BOONE MIDDLE   Regular School No Middle 06 08 2017   k_12_total 352 * * *   *       * 7           *         64   36   367 352                   7                 64 36   367
3297277 MO     school 2928560 10087   SOUTHERN BOONE CO. R-I 292856002802 4010 SOUTHERN BOONE PRIMARY   Regular School No Elementary PK 02 2017   k_12_total 367 5 7 *   *       * 18           *         97   33   399 367 5 7               18                 97 33   399
3297283 MO     school 2928560 10087   SOUTHERN BOONE CO. R-I 292856001765 4020 SOUTHERN BOONE ELEM.   Regular School No Elementary 03 05 2017   k_12_total 338 * 8 *   *       * 13           *         75   26   365 338   8               13                 75 26   365
3297289 MO     school 2913560 10089   HALLSVILLE R-IV 291356000578 1050 HALLSVILLE HIGH   Regular School No High 09 12 2017   k_12_total 347 10 15 *   *       * 13           *         93.4   29   389 347 10 15               13                   29   389
3297295 MO     school 2913560 10089   HALLSVILLE R-IV 291356001597 3000 HALLSVILLE MIDDLE   Regular School No Middle 06 08 2017   k_12_total 287 * 9 *   *       * 10           *         96   29   313 287   9               10                 96 29   313
3297301 MO     school 2913560 10089   HALLSVILLE R-IV 291356000577 4020 HALLSVILLE INTERMEDIATE   Regular School No Elementary 02 05 2017   k_12_total 398 11 14 6   *       * 23           *         181.4   35   456 398 11 14 6             23                   35   456
3297307 MO     school 2913560 10089   HALLSVILLE R-IV 291356002975 4040 HALLSVILLE PRIMARY   Regular School No Elementary PK 01 2017   k_12_total 192 6 * *   *       * 15           *         90.4   23   220 192 6                 15                   23   220
3297313 MO     school 2929700 10090   STURGEON R-V 292970002053 1050 STURGEON HIGH   Regular School No High 09 12 2017   k_12_total 136 * 6 *   *       * *           *         47   23   146 136   6                                 47 23   146
3297319 MO     school 2929700 10090   STURGEON R-V 292970001392 3000 STURGEON MIDDLE   Regular School No Middle 05 08 2017   k_12_total 136 * * *   *       * *           *         62   22   141 136                                     62 22   141
3297325 MO     school 2929700 10090   STURGEON R-V 292970002052 4020 STURGEON ELEM.   Regular School No Elementary KG 04 2017   k_12_total 162 * * *   *       * 9           *         83   28   175 162                   9                 83 28   175
3297331 MO     school 2908400 10091   CENTRALIA R-VI 290840000244 1050 CENTRALIA HIGH   Regular School No High 09 12 2017   k_12_total 397 * 6 *   *       * 12           *         90   42   421 397   6               12                 90 42   421
3297337 MO     school 2908400 10091   CENTRALIA R-VI 290840000243 3000 CHESTER BOREN MIDDLE   Regular School No Middle 06 08 2017   k_12_total 315 * 7 *   *       * 10           *         101   35   338 315   7               10                 101 35   338
3297343 MO     school 2908400 10091   CENTRALIA R-VI 290840000242 4020 CHANCE ELEM.   Regular School No Elementary PK 02 2017   k_12_total 269 * 5 *   *       * 13           *         103   24   291 269   5               13                 103 24   291
3297349 MO     school 2908400 10091   CENTRALIA R-VI 290840003092 4050 CENTRALIA INTERMEDIATE   Regular School No Elementary 03 05 2017   k_12_total 305 * 6 *   *       * 6           *         115.3   38   320 305   6               6                   38   320
3297355 MO     school 2913710 10092   HARRISBURG R-VIII 291371000599 1050 HARRISBURG HIGH   Regular School No High 09 12 2017   k_12_total 158 * * *   *       * *           *         50   18   168 158                                     50 18   168
3297361 MO     school 2913710 10092   HARRISBURG R-VIII 291371003100 3000 HARRISBURG MIDDLE   Regular School No Middle 06 08 2017   k_12_total 123 7 * *   *       * *           *         59.3   20   132 123 7                                     20   132
3297367 MO     school 2913710 10092   HARRISBURG R-VIII 291371000598 4020 HARRISBURG ELEM.   Regular School No Elementary PK 05 2017   k_12_total 237 7 5 *   *       * *           *         119   48   252 237 7 5                                 119 48   252
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
3297445 MO     school 2901000 10093   COLUMBIA 93 290100003152 4030 ALPHA HART LEWIS   Regular School No Elementary PK 05 2017   k_12_total 204 153 21 *   *       * 55           *         *   61   441 204 153 21               55                   61   441
3297498 MO     school 2901000 10093   COLUMBIA 93 290100001142 5025 MIDWAY HEIGHTS ELEM.   Regular School No Elementary PK 05 2017   k_12_total 196 5 10 *   *       * 13           *         61   15   225 196 5 10               13                 61 15   225
3297556 MO     school 2901000 10093   COLUMBIA 93 290100000314 6040 TWO MILE PRAIRIE ELEM.   Regular School No Elementary KG 05 2017   k_12_total 148 8 9 *   *       * 8           *         71   15   177 148 8 9               8                 71 15   177
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
3297566 MO     school 2901000 10093   COLUMBIA 93 290100003287 7500 CENTER FOR EARLY LRNING-NORTH   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297572 MO     school 2911250 11076   EAST BUCHANAN CO. C-1 291125000391 1050 EAST BUCHANAN HIGH   Regular School No High 09 12 2017   k_12_total 217 * * *   *       * 9           *         45   28   227 217                   9                 45 28   227
3297578 MO     school 2911250 11076   EAST BUCHANAN CO. C-1 291125002282 3000 EAST BUCHANAN MIDDLE   Regular School No Middle 06 08 2017   k_12_total 150 * * *   *       * *           *         33   22   153 150                                     33 22   153
3297584 MO     school 2911250 11076   EAST BUCHANAN CO. C-1 291125000390 4040 EAST BUCHANAN ELEM.   Regular School No Elementary KG 05 2017   k_12_total 305 * * *   *       * 12           *         83   66   319 305                   12                 83 66   319
3297590 MO     school 2911940 11078   MID-BUCHANAN CO. R-V 291194000445 1050 MID-BUCHANAN SR. HIGH   Regular School No High 07 12 2017   k_12_total 311 * 5 *   *       * 8           *         71   27   327 311   5               8                 71 27   327
3297596 MO     school 2911940 11078   MID-BUCHANAN CO. R-V 291194000443 4020 MID-BUCHANAN ELEM.   Regular School No Elementary PK 06 2017   k_12_total 366 5 * *   *       * 8           *         95   49   384 366 5                 8                 95 49   384

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