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,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
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
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
3296885 MO     school 2931950 5120   WHEATON R-III 293195002237 1050 WHEATON HIGH   Regular School No High 07 12 2017   k_12_total 147 * 14 *   19       * *           18         117   12   182 147   14     19                     18     117 12   182
3296891 MO     school 2931950 5120   WHEATON R-III 293195002236 4020 WHEATON ELEM.   Regular School No Elementary PK 06 2017   k_12_total 157 * 21 *   25       8 *           46         152   28   214 157   21     25       8             46     152 28   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
3296921 MO     school 2911670 5122   EXETER R-VI 291167000426 4020 EXETER ELEM.   Regular School No Elementary KG 08 2017   k_12_total 195 * 9 *   12       * *           14         174   27   219 195   9     12                     14     174 27   219
3296927 MO     school 2908170 5123   CASSVILLE R-IV 290817000219 1050 CASSVILLE HIGH   Regular School No High 09 12 2017   k_12_total 520 * 35 *   8       * 10           5         275   35   578 520   35     8         10           5     275 35   578
3296933 MO     school 2908170 5123   CASSVILLE R-IV 290817002425 3000 CASSVILLE MIDDLE   Regular School No Middle 06 08 2017   k_12_total 366 * 28 7   *       * 12           10         244   33   419 366   28 7             12           10     244 33   419
3296939 MO     school 2908170 5123   CASSVILLE R-IV 290817000217 4020 EUNICE THOMAS ELEM.   Regular School No Elementary PK 02 2017   k_12_total 380 * 17 *   *       * 7           16         252   24   408 380   17               7           16     252 24   408
3296945 MO     school 2908170 5123   CASSVILLE R-IV 290817002718 4030 CASSVILLE INTERMEDIATE   Regular School No Elementary 03 05 2017   k_12_total 369 * 27 *   *       * 16           22         262   29   417 369   27               16           22     262 29   417
3296951 MO     school 2925620 5124   PURDY R-II 292562001502 1050 PURDY HIGH   Regular School No High 09 12 2017   k_12_total 126 * * *   5       54 *           12         92   15   191 126         5       54             12     92 15   191
3296957 MO     school 2925620 5124   PURDY R-II 292562002221 3000 PURDY MIDDLE   Regular School No Middle 05 08 2017   k_12_total 149 * * *   7       44 *           12         136.3   25   206 149         7       44             12       25   206
3296961 MO     school 2925620 5124   PURDY R-II 292562001501 4020 PURDY ELEM.   Regular School No Elementary KG 04 2017   k_12_total 144 * 14 *   11       74 *           78         179   47   246 144   14     11       74             78     179 47   246
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
3296986 MO     school 2921120 5128   MONETT R-I 292112003089 4000 CENTRAL PARK ELEM.   Regular School No Elementary 03 04 2017   k_12_total 202 * 138 8   5       * 5           103         235   64   359 202   138 8   5         5           103     235 64   359
3296992 MO     school 2921120 5128   MONETT R-I 292112001160 4020 MONETT ELEM.   Regular School No Elementary PK 02 2017   k_12_total 271 * 182 *   *       * 13           166         343.1   83   478 271   182               13           166       83   478
3296998 MO     school 2921120 5128   MONETT R-I 292112001595 4040 MONETT INTERMEDIATE   Regular School No Middle 05 06 2017   k_12_total 202 * 144 *   *       * 9           79         251   75   363 202   144               9           79     251 75   363
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
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
3297040 MO     school 2917850 6104   LAMAR R-I 291785000954 1050 LAMAR HIGH   Regular School No High 09 12 2017   k_12_total 350 * 18 *   *       * 26           10         182   43   398 350   18               26           10     182 43   398
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
3297052 MO     school 2917850 6104   LAMAR R-I 291785000953 4020 LAMAR ELEM.   Regular School No Elementary 03 05 2017   k_12_total 247 * 15 *   *       * 19           6         166   58   285 247   15               19           6     166 58   285
3297058 MO     school 2917850 6104   LAMAR R-I 291785002720 4040 EAST ELEM.   Regular School No Elementary PK 02 2017   k_12_total 204 * 11 *   *       * 16           6         147   30   235 204   11               16           6     147 30   235
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
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
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
3297198 MO     school 2909900 8111   COLE CAMP R-I 290990000292 4020 COLE CAMP ELEM.   Regular School No Elementary KG 04 2017   k_12_total 230 * 10 *   *       * *           12         151   28   240 230   10                           12     151 28   240
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
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
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
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
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
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
3297602 MO     school 2910590 11079   BUCHANAN CO. R-IV 291059000355 1050 DEKALB JR.-SR. HIGH   Regular School No High 07 12 2017   k_12_total 129 * * *   *       * *           *         54   15   134 129                                     54 15   134
3297608 MO     school 2910590 11079   BUCHANAN CO. R-IV 291059000356 4020 RUSHVILLE ELEM.   Regular School No Elementary PK 06 2017   k_12_total 180 * * *   *       * *           *         94   27   184 180                                     94 27   184
3297754 MO     school 2921750 12108   NEELYVILLE R-IV 292175001201 4040 HILLVIEW ELEM.   Regular School No Elementary PK 02 2017   k_12_total 115 * * *   *       * *           *         94   19   124 115                                     94 19   124
3297814 MO     school 2925450 12109   POPLAR BLUFF R-I 292545002769 7500 POPLAR BLUFF EARLY CHILDHOOD C   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297820 MO     school 2930520 12110   TWIN RIVERS R-X 293052002095 1050 TWIN RIVERS HIGH   Regular School No High 09 12 2017   k_12_total 302 * * *   *       * *           *         182   51   306 302                                     182 51   306
3297828 MO     school 2930520 12110   TWIN RIVERS R-X 293052002093 4040 FISK ELEM.   Regular School No Elementary PK 08 2017   k_12_total 352 * * *   *       * *           *         240   67   358 352                                     240 67   358
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

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