Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2017 · 36,621
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
3297834 MO     school 2930520 12110   TWIN RIVERS R-X 293052002094 4060 QULIN ELEM.   Regular School No Elementary PK 08 2017   k_12_total 274 * * *   *       * *           *         187   51   279 274                                     187 51   279
3297840 MO     school 2905850 13054   BRECKENRIDGE R-I 290585000129 1050 BRECKENRIDGE HIGH   Regular School No High 07 12 2017   k_12_total 29 * * *   *       * *           *         22   6   31 29                                     22 6   31
3297846 MO     school 2905850 13054   BRECKENRIDGE R-I 290585000128 4020 BRECKENRIDGE ELEM.   Regular School No Elementary PK 06 2017   k_12_total 32 * * *   *       * *           *         28   14   34 32                                     28 14   34
3297852 MO     school 2913590 13055   HAMILTON R-II 291359000580 1050 PENNEY HIGH   Regular School No High 09 12 2017   k_12_total 210 * * *   *       * 5           *         75   21   220 210                   5                 75 21   220
3297858 MO     school 2913590 13055   HAMILTON R-II 291359002663 3000 HAMILTON MIDDLE   Regular School No Middle 06 08 2017   k_12_total 136 * * *   *       * *           *         76   19   142 136                                     76 19   142
3297864 MO     school 2913590 13055   HAMILTON R-II 291359000579 4020 HAMILTON ELEM.   Regular School No Elementary PK 05 2017   k_12_total 253 * * *   *       * *           *         143   36   261 253                                     143 36   261
3297870 MO     school 2922110 13057   NEW YORK R-IV 292211001227 4020 NEW YORK ELEM.   Regular School No Elementary KG 08 2017   k_12_total 18 * * *   *       * *           *         5   *   18 18                                     5     18
3297876 MO     school 2910230 13058   COWGILL R-VI 291023000329 4020 COWGILL ELEM.   Regular School No Elementary PK 08 2017   k_12_total 39 * * *   *       * *           *         31   12   39 39                                     31 12   39
3297882 MO     school 2925410 13059   POLO R-VII 292541001465 1050 POLO HIGH   Regular School No High 09 12 2017   k_12_total 137 * * *   *       * *           *         65   24   143 137                                     65 24   143
3297888 MO     school 2925410 13059   POLO R-VII 292541000227 3000 POLO MIDDLE   Regular School No Middle 05 08 2017   k_12_total 132 * * *   *       * *           *         65   33   138 132                                     65 33   138
3297894 MO     school 2925410 13059   POLO R-VII 292541001464 4020 POLO ELEM.   Regular School No Elementary PK 04 2017   k_12_total 125 * * *   *       * *           *         61   16   129 125                                     61 16   129
3297900 MO     school 2921030 13060   MIRABILE C-1 292103001150 4020 MIRABILE ELEM.   Regular School No Elementary PK 08 2017   k_12_total 50 * * *   *       * *           *         23   14   52 50                                     23 14   52
3297906 MO     school 2905820 13061   BRAYMER C-4 290582000127 1050 BRAYMER HIGH   Regular School No High 07 12 2017   k_12_total 120 * * *   *       * *           *         55   10   129 120                                     55 10   129
3297918 MO     school 2916620 13062   KINGSTON 42 291662000908 4020 KINGSTON ELEM.   Regular School No Elementary PK 08 2017   k_12_total 26 * * *   *       * *           *         11   5   27 26                                     11 5   27
3297930 MO     school 2922740 14126   NORTH CALLAWAY CO. R-I 292274001252 4020 AUXVASSE ELEM.   Regular School No Elementary PK 08 2017   k_12_total 274 * 11 *   *       * 10           *         172.4   42   299 274   11               10                   42   299
3297936 MO     school 2922740 14126   NORTH CALLAWAY CO. R-I 292274001253 4040 HATTON-MCCREDIE ELEM.   Regular School No Elementary KG 08 2017   k_12_total 270 * 6 *   *       * 21           *         149   35   301 270   6               21                 149 35   301
3297942 MO     school 2922740 14126   NORTH CALLAWAY CO. R-I 292274001255 4060 WILLIAMSBURG ELEM.   Regular School No Elementary KG 08 2017   k_12_total 143 * * *   *       * *           *         78   11   148 143                                     78 11   148
3297954 MO     school 2921875 14127   NEW BLOOMFIELD R-III 292187501218 4020 NEW BLOOMFIELD ELEM.   Regular School No Elementary PK 06 2017   k_12_total 320 * * *   *       * 8           *         156   26   337 320                   8                 156 26   337
3297990 MO     school 2928430 14130   SOUTH CALLAWAY CO. R-II 292843001757 1050 SOUTH CALLAWAY HIGH   Regular School No High 09 12 2017   k_12_total 251 * * *   *       * *           *         110   16   253 251                                     110 16   253
3297996 MO     school 2928430 14130   SOUTH CALLAWAY CO. R-II 292843002401 3000 SOUTH CALLAWAY MIDDLE   Regular School No Middle 06 08 2017   k_12_total 178 * * *   *       * *           *         92   18   186 178                                     92 18   186
3298002 MO     school 2928430 14130   SOUTH CALLAWAY CO. R-II 292843003120 4010 SOUTH CALLAWAY EARLY CHD PK-02   Regular School No Elementary PK 02 2017   k_12_total 150 * * *   *       * 5           *         67   23   160 150                   5                 67 23   160
3298008 MO     school 2928430 14130   SOUTH CALLAWAY CO. R-II 292843001756 4020 SOUTH CALLAWAY ELEM.   Regular School No Elementary 03 05 2017   k_12_total 176 * * *   *       * *           *         87   25   181 176                                     87 25   181
3298020 MO     school 2900020 14400   MO SCHOOL FOR THE DEAF 290002003022 3000 WHEELER MIDDLE   Special Education School No Middle 06 08 2017   k_12_total 12 * * *   *       * *           *         *   *   14 12                                           14
3298026 MO     school 2900020 14400   MO SCHOOL FOR THE DEAF 290002003023 4020 STARK ELEM.   Special Education School No Elementary KG 05 2017   k_12_total 14 * * *   *       * *           *         *   *   17 14                                           17
3298032 MO     school 2929580 15001   STOUTLAND R-II 292958002046 1050 STOUTLAND HIGH   Regular School No High 07 12 2017   k_12_total 198 * * *   *       * *           *         153   33   207 198                                     153 33   207
3298038 MO     school 2929580 15001   STOUTLAND R-II 292958002045 4020 STOUTLAND ELEMENTARY   Regular School No Elementary PK 06 2017   k_12_total 187 * * *   *       * 6           *         155   26   196 187                   6                 155 26   196
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
3298074 MO     school 2906990 15002   CAMDENTON R-III 290699000172 4040 HURRICANE DECK ELEM.   Regular School No Elementary PK 04 2017   k_12_total 165 * 7 *   *       * 5           *         129   30   179 165   7               5                 129 30   179
3298092 MO     school 2909810 15003   CLIMAX SPRINGS R-IV 290981000284 1050 CLIMAX SPRINGS HIGH   Regular School No High 07 12 2017   k_12_total 111 * * *   *       * *           *         78   9   114 111                                     78 9   114
3298098 MO     school 2909810 15003   CLIMAX SPRINGS R-IV 290981000283 4020 CLIMAX SPRINGS ELEM.   Regular School No Elementary PK 06 2017   k_12_total 90 * * *   *       * *           *         75   15   95 90                                     75 15   95
3298104 MO     school 2919380 15004   MACKS CREEK R-V 291938001049 1050 MACKS CREEK HIGH   Regular School No High 07 12 2017   k_12_total 114 * 9 *   *       * 5           *         *   17   131 114   9               5                   17   131
3298110 MO     school 2919380 15004   MACKS CREEK R-V 291938001048 4020 MACKS CREEK ELEM.   Regular School No Elementary PK 06 2017   k_12_total 160 * 6 *   *       * *           *         *   17   173 160   6                                   17   173
3298140 MO     school 2915600 16090   JACKSON R-II 291560000733 4060 GORDONVILLE ATTENDANCE CTR.   Regular School No Elementary KG 02 2017   k_12_total 53 * * *   *       * *           *         27   *   61 53                                     27     61
3298146 MO     school 2915600 16090   JACKSON R-II 291560000735 4100 MILLERSVILLE ATTENDANCE CTR.   Regular School No Elementary KG 03 2017   k_12_total 73 * * *   *       * *           *         43   *   79 73                                     43     79
3298152 MO     school 2915600 16090   JACKSON R-II 291560000736 4110 NORTH ELEM.   Regular School No Elementary KG 05 2017   k_12_total 268 * 7 *   *       * 11           *         119   24   291 268   7               11                 119 24   291
3298175 MO     school 2910620 16092   DELTA R-V 291062000358 1050 DELTA HIGH   Regular School No High 07 12 2017   k_12_total 115 * * *   *       * *           *         71   9   122 115                                     71 9   122
3298181 MO     school 2910620 16092   DELTA R-V 291062000357 4020 DELTA ELEM.   Regular School No Elementary KG 06 2017   k_12_total 117 * * *   *       * *           *         *   12   120 117                                       12   120
3298187 MO     school 2923070 16094   OAK RIDGE R-VI 292307001321 1050 OAK RIDGE HIGH   Regular School No High 07 12 2017   k_12_total 151 * * *   *       * *           *         55   15   153 151                                     55 15   153
3298193 MO     school 2923070 16094   OAK RIDGE R-VI 292307001320 4020 OAK RIDGE ELEM.   Regular School No Elementary PK 06 2017   k_12_total 215 * * *   *       * *           *         103   20   216 215                                     103 20   216
3298253 MO     school 2913500 17121   HALE R-I 291350000574 1050 HALE HIGH   Regular School No High 07 12 2017   k_12_total 75 * * *   *       * *           *         28   8   75 75                                     28 8   75
3298259 MO     school 2913500 17121   HALE R-I 291350000573 4020 HALE ELEM.   Regular School No Elementary PK 06 2017   k_12_total 69 * * *   *       * *           *         37   14   70 69                                     37 14   70
3298265 MO     school 2930300 17122   TINA-AVALON R-II 293030002071 1050 TINA-AVALON HIGH   Regular School No High 07 12 2017   k_12_total 63 * * *   *       * *           *         30   7   67 63                                     30 7   67
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
3298277 MO     school 2905610 17124   BOSWORTH R-V 290561000107 1050 BOSWORTH HIGH   Regular School No High 07 12 2017   k_12_total 38 * * *   *       * *           *         26   8   38 38                                     26 8   38
3298283 MO     school 2905610 17124   BOSWORTH R-V 290561000106 4020 BOSWORTH ELEM.   Regular School No Elementary PK 06 2017   k_12_total 22 * * *   *       * *           *         *   5   22 22                                       5   22
3298301 MO     school 2907380 17125   CARROLLTON R-VII 290738003131 4000 ADAMS PRIMARY SCHOOL   Regular School No Elementary PK 01 2017   k_12_total 138 * * *   *       * *           *         71   18   141 138                                     71 18   141
3298307 MO     school 2907380 17125   CARROLLTON R-VII 290738003129 4010 CARROLLTON ELEMENTARY SCHOOL   Regular School No Elementary 02 04 2017   k_12_total 189 * * *   *       * *           *         103   32   194 189                                     103 32   194
3298313 MO     school 2922620 17126   NORBORNE R-VIII 292262001238 1050 NORBORNE HIGH   Regular School No Other 06 12 2017   k_12_total 103 * * *   *       * *           *         48   14   108 103                                     48 14   108
3298319 MO     school 2922620 17126   NORBORNE R-VIII 292262001237 4020 NORBORNE ELEM.   Regular School No Elementary KG 05 2017   k_12_total 68 * * *   *       * *           *         25   12   70 68                                     25 12   70
3298325 MO     school 2911100 18047   EAST CARTER CO. R-II 291110000383 1050 EAST CARTER CO. R-II HIGH   Regular School No High 09 12 2017   k_12_total 231 * * *   *       * *           *         150.1   38   236 231                                       38   236
3298331 MO     school 2911100 18047   EAST CARTER CO. R-II 291110002916 3000 EAST CARTER CO. R-II MIDDLE   Regular School No Middle 06 08 2017   k_12_total 155 * * *   *       * *           *         114   31   157 155                                     114 31   157
3298337 MO     school 2911100 18047   EAST CARTER CO. R-II 291110000380 4020 EAST CARTER CO. R-II ELEM.   Regular School No Elementary PK 05 2017   k_12_total 305 * * *   *       * *           *         240   72   310 305                                     240 72   310
3298343 MO     school 2930750 18050   VAN BUREN R-I 293075002121 1050 VAN BUREN HIGH   Regular School No High 07 12 2017   k_12_total 218 * * *   *       * *           *         142   36   222 218                                     142 36   222
3298349 MO     school 2930750 18050   VAN BUREN R-I 293075002122 4020 VAN BUREN ELEM.   Regular School No Elementary PK 06 2017   k_12_total 266 * * *   *       * *           *         183   52   278 266                                     183 52   278
3298367 MO     school 2929670 19140   STRASBURG C-3 292967002051 4020 STRASBURG ELEM.   Regular School No Elementary KG 08 2017   k_12_total 108 * 5 *   *       * *           *         37   19   117 108   5                                 37 19   117
3298388 MO     school 2923730 19142   RAYMORE-PECULIAR R-II 292373001426 4020 PECULIAR ELEM.   Regular School No Elementary KG 04 2017   k_12_total 280 * 13 *   *       * 9           *         82   19   308 280   13               9                 82 19   308
3298400 MO     school 2923730 19142   RAYMORE-PECULIAR R-II 292373002271 4050 SHULL ELEM.   Regular School No Elementary KG 04 2017   k_12_total 239 * 19 *   *       * 9           *         83   25   272 239   19               9                 83 25   272
3298436 MO     school 2910320 19144   SHERWOOD CASS R-VIII 291032000335 1050 SHERWOOD HIGH   Regular School No High 09 12 2017   k_12_total 230 * * *   *       * *           *         84   29   236 230                                     84 29   236
3298442 MO     school 2910320 19144   SHERWOOD CASS R-VIII 291032001610 3000 SHERWOOD MIDDLE   Regular School No Middle 06 08 2017   k_12_total 175 * * *   *       * *           *         94   31   182 175                                     94 31   182
3298448 MO     school 2910320 19144   SHERWOOD CASS R-VIII 291032000334 4020 SHERWOOD ELEM.   Regular School No Elementary PK 05 2017   k_12_total 342 * 5 *   *       * 9           *         212   61   362 342   5               9                 212 61   362
3298454 MO     school 2911160 19147   EAST LYNNE 40 291116000384 4020 EAST LYNNE ELEM.   Regular School No Elementary PK 08 2017   k_12_total 114 * * *   *       * *           *         41   23   115 114                                     41 23   115
3298460 MO     school 2925330 19148   PLEASANT HILL R-III 292533001461 1050 PLEASANT HILL HIGH   Regular School No High 09 12 2017   k_12_total 610 * 32 *   *       * 20           *         108   44   669 610   32               20                 108 44   669
3298466 MO     school 2925330 19148   PLEASANT HILL R-III 292533001459 3000 PLEASANT HILL MIDDLE   Regular School No Middle 07 08 2017   k_12_total 304 * 14 *   *       * 11           *         57   31   331 304   14               11                 57 31   331
3298472 MO     school 2925330 19148   PLEASANT HILL R-III 292533001460 4020 PLEASANT HILL PRIMARY   Regular School No Elementary PK 02 2017   k_12_total 455 * 16 5   *       * 21           5         113   55   503 455   16 5             21           5     113 55   503
3298478 MO     school 2925330 19148   PLEASANT HILL R-III 292533002803 4040 PLEASANT HILL ELEM.   Regular School No Elementary 03 04 2017   k_12_total 284 * 14 *   *       * 15           *         84   33   319 284   14               15                 84 33   319
3298484 MO     school 2925330 19148   PLEASANT HILL R-III 292533002897 4060 PLEASANT HILL INTERMEDIATE   Regular School No Middle 05 06 2017   k_12_total 297 * 15 *   *       * 8           5         83.2   34   323 297   15               8           5       34   323
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
3298513 MO     school 2913760 19149   HARRISONVILLE R-IX 291376000604 4040 MCEOWEN ELEM.   Regular School No Elementary 04 05 2017   k_12_total 321 * 18 *   *       * 12           *         158   37   360 321   18               12                 158 37   360
3298519 MO     school 2913760 19149   HARRISONVILLE R-IX 291376000091 4060 EARLY CHILDHOOD CTR.   Regular School No Elementary PK KG 2017   k_12_total 152 * 7 *   *       * 7           5         89   10   170 152   7               7           5     89 10   170
3298525 MO     school 2911070 19150   DREXEL R-IV 291107000379 1050 DREXEL HIGH   Regular School No High 07 12 2017   k_12_total 143 * * *   *       * *           *         67   10   148 143                                     67 10   148
3298531 MO     school 2911070 19150   DREXEL R-IV 291107000378 4020 DREXEL ELEM.   Regular School No Elementary PK 06 2017   k_12_total 159 * * *   *       * *           *         69   14   163 159                                     69 14   163
3298537 MO     school 2931800 19151   MIDWAY R-I 293180002224 1050 MIDWAY HIGH   Regular School No High 07 12 2017   k_12_total 204 * 6 *   *       * *           *         75   21   219 204   6                                 75 21   219
3298543 MO     school 2931800 19151   MIDWAY R-I 293180002223 4020 MIDWAY ELEM.   Regular School No Elementary KG 06 2017   k_12_total 198 * * *   *       * *           *         92   36   206 198                                     92 36   206
3298596 MO     school 2904620 19152   BELTON 124 290462002725 7500 GRACE EARLY CHILD. & ED. CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298603 MO     school 2929520 20001   STOCKTON R-I 292952002044 1050 STOCKTON HIGH   Regular School No High 09 12 2017   k_12_total 302 * 6 *   *       * 7           *         136   34   317 302   6               7                 136 34   317
3298609 MO     school 2929520 20001   STOCKTON R-I 292952000089 3000 STOCKTON MIDDLE   Regular School No Middle 05 08 2017   k_12_total 286 * 8 *   *       * 9           *         168   34   308 286   8               9                 168 34   308
3298615 MO     school 2929520 20001   STOCKTON R-I 292952002043 4020 STOCKTON ELEM.   Regular School No Elementary PK 04 2017   k_12_total 321 * * *   *       * *           *         204   62   325 321                                     204 62   325
3298623 MO     school 2911310 20002   EL DORADO SPRINGS R-II 291131000398 1050 EL DORADO SPRINGS HIGH   Regular School No High 09 12 2017   k_12_total 339 * * *   *       * *           *         *   42   349 339                                       42   349
3298629 MO     school 2911310 20002   EL DORADO SPRINGS R-II 291131002660 3000 EL DORADO SPRINGS MIDDLE   Regular School No Middle 06 08 2017   k_12_total 278 * * *   *       * *           *         *   41   285 278                                       41   285
3298635 MO     school 2911310 20002   EL DORADO SPRINGS R-II 291131000400 4040 EL DORADO SPRINGS ELEM.   Regular School No Elementary PK 05 2017   k_12_total 500 * * *   *       * *           *         *   102   510 500                                       102   510
3298641 MO     school 2922920 21148   NORTHWESTERN R-I 292292001311 1050 NORTHWESTERN HIGH   Regular School No High 07 12 2017   k_12_total 80 * * *   *       * *           *         26   12   80 80                                     26 12   80
3298647 MO     school 2922920 21148   NORTHWESTERN R-I 292292001310 4020 NORTHWESTERN ELEM.   Regular School No Elementary PK 06 2017   k_12_total 72 * * *   *       * *           *         32   10   73 72                                     32 10   73
3298665 MO     school 2916530 21150   KEYTESVILLE R-III 291653000905 1050 KEYTESVILLE HIGH   Regular School No High 07 12 2017   k_12_total 69 * * *   *       * *           *         42   7   71 69                                     42 7   71
3298671 MO     school 2916530 21150   KEYTESVILLE R-III 291653000904 4020 KEYTESVILLE ELEM.   Regular School No Elementary PK 06 2017   k_12_total 59 * * *   *       * *           *         39   10   63 59                                     39 10   63
3298689 MO     school 2908430 22088   CHADWICK R-I 290843000246 1050 CHADWICK HIGH   Regular School No High 07 12 2017   k_12_total 86 * * *   *       * *           *         46   26   88 86                                     46 26   88
3298695 MO     school 2908430 22088   CHADWICK R-I 290843000245 4020 CHADWICK ELEMENTARY   Regular School No Elementary PK 06 2017   k_12_total 140 * * *   *       * *           *         101   30   141 140                                     101 30   141
3298707 MO     school 2922530 22089   Nixa Public Schools 292253000425 3000 NIXA JUNIOR HIGH   Regular School No Middle 07 08 2017   k_12_total 758 * 39 6   11       * 46           6         280   109   864 758   39 6   11         46           6     280 109   864
3298713 MO     school 2922530 22089   Nixa Public Schools 292253003132 4030 EARLY LEARNING CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298725 MO     school 2922530 22089   Nixa Public Schools 292253002771 4050 CENTURY ELEM.   Regular School No Elementary KG 04 2017   k_12_total 406 * 18 *   *       * 32           12         137   54   466 406   18               32           12     137 54   466
3298731 MO     school 2922530 22089   Nixa Public Schools 292253000463 4060 NICHOLAS A. INMAN INTERMEDIATE   Regular School No Middle 05 06 2017   k_12_total 326 * 24 *   5       * 18           10         139   42   375 326   24     5         18           10     139 42   375
3298755 MO     school 2922530 22089   Nixa Public Schools 292253003202 4100 JOHN THOMAS SCHOOL OF DISCOVER   Regular School No Elementary KG 06 2017   k_12_total 450 * 20 *   *       * 21           8         108   75   495 450   20               21           8     108 75   495
3298761 MO     school 2922530 22089   Nixa Public Schools 292253003242 7500 EARLY CHILDHOOD CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298767 MO     school 2928740 22090   SPARTA R-III 292874001776 1050 SPARTA HIGH   Regular School No High 09 12 2017   k_12_total 192 * * *   *       * *           *         117   22   198 192                                     117 22   198
3298773 MO     school 2928740 22090   SPARTA R-III 292874001430 3000 SPARTA MIDDLE   Regular School No Middle 05 08 2017   k_12_total 243 * * *   *       * 6           *         135   31   250 243                   6                 135 31   250
3298779 MO     school 2928740 22090   SPARTA R-III 292874001775 4020 SPARTA ELEM.   Regular School No Elementary KG 04 2017   k_12_total 270 * * *   *       * 14           *         174   33   287 270                   14                 174 33   287
3298785 MO     school 2928740 22090   SPARTA R-III 292874003260 7500 SPARTA PK CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298791 MO     school 2905070 22091   BILLINGS R-IV 290507000066 1050 BILLINGS SR. HIGH   Regular School No High 07 12 2017   k_12_total 182 * 5 *   *       * *           *         70   13   193 182   5                                 70 13   193
3298821 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Middle 08 08 2017   k_12_total 370 * 13 5   *       * 14           5         130.3   38   405 370   13 5             14           5       38   405
3298827 MO     school 2923430 22093   OZARK R-VI 292343002439 4040 SOUTH ELEM.   Regular School No Elementary PK 05 2017   k_12_total 569 * 42 *   *       * 21           *         281.3   64   639 569   42               21                   64   639
3298845 MO     school 2923430 22093   OZARK R-VI 292343001433 4080 EAST ELEM.   Regular School No Elementary KG 05 2017   k_12_total 606 * 32 *   7       * 29           24         245.3   74   677 606   32     7         29           24       74   677

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