Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2017 · 36,620
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
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
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
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
3298247 MO     school 2907320 16097   NELL HOLCOMB R-IV 290732000194 4020 NELL HOLCOMB ELEM.   Regular School No Elementary KG 08 2017   k_12_total 243 25 * *   *       * *           *         146   35   272 243 25                                   146 35   272
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
3298295 MO     school 2907380 17125   CARROLLTON R-VII 290738000311 3000 MIDDLE SCHOOL   Regular School No Middle 05 08 2017   k_12_total 223 7 * *   *       * *           *         121   32   234 223 7                                   121 32   234
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
3298355 MO     school 2903200 19139   ARCHIE R-V 290320000025 1050 ARCHIE HIGH   Regular School No Other 06 12 2017   k_12_total 282 7 * *   *       * *           *         66   26   297 282 7                                   66 26   297
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
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
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
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
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
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
3298653 MO     school 2906030 21149   BRUNSWICK R-II 290603000145 1050 BRUNSWICK HIGH   Regular School No High 07 12 2017   k_12_total 94 8 * *   *       * 10           *         61   32   112 94 8                 10                 61 32   112
3298659 MO     school 2906030 21149   BRUNSWICK R-II 290603000144 4020 BRUNSWICK ELEM.   Regular School No Elementary PK 06 2017   k_12_total 111 9 * *   *       * 16           *         80   25   138 111 9                 16                 80 25   138
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
3298677 MO     school 2927520 21151   SALISBURY R-IV 292752001685 1050 SALISBURY HIGH   Regular School No High 07 12 2017   k_12_total 214 9 * *   *       * *           *         100.2   23   226 214 9                                     23   226
3298683 MO     school 2927520 21151   SALISBURY R-IV 292752001683 4040 SALISBURY ELEM.   Regular School No Elementary KG 06 2017   k_12_total 219 14 * *   *       * *           *         121   34   236 219 14                                   121 34   236
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
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
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
3298878 MO     school 2916380 23101   CLARK CO. R-I 291638000797 1050 CLARK CO. HIGH   Regular School No High 09 12 2017   k_12_total 292 * * *   *       * *           *         116   34   297 292                                     116 34   297
3298884 MO     school 2916380 23101   CLARK CO. R-I 291638001656 3000 CLARK CO. MIDDLE   Regular School No Middle 06 08 2017   k_12_total 226 * * *   *       * *           *         112   45   232 226                                     112 45   232
3298890 MO     school 2916380 23101   CLARK CO. R-I 291638000794 4040 BLACK HAWK ELEM.   Regular School No Elementary KG 05 2017   k_12_total 367 * * *   *       * *           *         218.1   59   375 367                                       59   375
3298896 MO     school 2916380 23101   CLARK CO. R-I 291638000796 4060 RUNNING FOX ELEM.   Regular School No Elementary KG 05 2017   k_12_total 97 * * *   *       * *           *         53   11   104 97                                     53 11   104
3298902 MO     school 2916380 23101   CLARK CO. R-I 291638003254 7500 EARLY CHILDHOOD CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3299118 MO     school 2918540 24090   LIBERTY 53 291854002615 7500 EARLY CHILD. EDUCATION CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3299124 MO     school 2921060 24091   MISSOURI CITY 56 292106001151 4020 MISSOURI CITY ELEM.   Regular School No Elementary KG 08 2017   k_12_total 22 * * *   *       * *           *         9   7   22 22                                     9 7   22
3299314 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280002662 7500 PLEASANT VALLEY EARLY CHILD.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3299349 MO     school 2917970 25002   LATHROP R-II 291797001684 3000 LATHROP MIDDLE   Regular School No Middle 06 08 2017   k_12_total 204 * * *   *       * *           *         75   18   215 204                                     75 18   215
3299367 MO     school 2925290 25003   CLINTON CO. R-III 292529000846 3000 CLINTON CO. R-III MIDDLE   Regular School No Middle 06 08 2017   k_12_total 116 8 * *   *       * 5           *         65   30   134 116 8                 5                 65 30   134
3299379 MO     school 2926970 26001   COLE CO. R-I 292697001639 1050 RUSSELLVILLE HIGH   Regular School No High 09 12 2017   k_12_total 182 * * *   *       * *           *         68   18   190 182                                     68 18   190
3299385 MO     school 2926970 26001   COLE CO. R-I 292697000847 3000 COLE CO. R-I MIDDLE   Regular School No Middle 06 08 2017   k_12_total 124 * * *   *       * *           *         47   12   132 124                                     47 12   132
3299391 MO     school 2926970 26001   COLE CO. R-I 292697001638 4020 COLE CO. R-I ELEM.   Regular School No Elementary PK 05 2017   k_12_total 220 * * *   *       * 6           *         88   33   231 220                   6                 88 33   231
3299397 MO     school 2909930 26002   BLAIR OAKS R-II 290993000295 1050 BLAIR OAKS HIGH   Regular School No High 09 12 2017   k_12_total 432 * * *   *       * *           *         44   39   440 432                                     44 39   440
3299403 MO     school 2909930 26002   BLAIR OAKS R-II 290993003117 3000 BLAIR OAKS MIDDLE SCHOOL   Regular School No Middle 05 08 2017   k_12_total 372 * * *   *       * 5           *         47   49   385 372                   5                 47 49   385
3299409 MO     school 2909930 26002   BLAIR OAKS R-II 290993000294 4020 BLAIR OAKS ELEM.   Regular School No Elementary KG 04 2017   k_12_total 373 * * *   *       * 6           *         42   55   384 373                   6                 42 55   384
3299415 MO     school 2911550 26005   COLE CO. R-V 291155000411 1050 EUGENE HIGH   Regular School No High 07 12 2017   k_12_total 271 * * *   *       * *           *         80   10   275 271                                     80 10   275
3299421 MO     school 2911550 26005   COLE CO. R-V 291155000410 4020 EUGENE ELEM.   Regular School No Elementary PK 06 2017   k_12_total 304 * * *   *       * *           *         132   24   313 304                                     132 24   313
3299512 MO     school 2916190 26006   JEFFERSON CITY 291619003121 7500 SOUTHWEST EARLY CHILDHOOD CTR   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3299518 MO     school 2905190 27055   BLACKWATER R-II 290519000069 4020 BLACKWATER ELEM.   Regular School No Elementary PK 08 2017   k_12_total 101 5 * *   *       * *           *         58   18   106 101 5                                   58 18   106
3299524 MO     school 2906150 27056   COOPER CO. R-IV 290615000154 1050 BUNCETON HIGH   Regular School No High 07 12 2017   k_12_total 71 * * *   *       * *           *         42   *   71 71                                     42     71
3299530 MO     school 2906150 27056   COOPER CO. R-IV 290615000153 4020 BUNCETON ELEM.   Regular School No Elementary KG 06 2017   k_12_total 43 * * *   *       * *           *         32   5   44 43                                     32 5   44
3299536 MO     school 2925530 27057   PRAIRIE HOME R-V 292553001500 1050 PRAIRIE HOME HIGH   Regular School No High 07 12 2017   k_12_total 68 * * *   *       * *           *         32   6   75 68                                     32 6   75
3299542 MO     school 2925530 27057   PRAIRIE HOME R-V 292553001499 4020 PRAIRIE HOME ELEM.   Regular School No Elementary PK 06 2017   k_12_total 78 * * *   *       * *           *         35   12   83 78                                     35 12   83
3299548 MO     school 2923310 27058   OTTERVILLE R-VI 292331001342 1050 OTTERVILLE HIGH   Regular School No High 07 12 2017   k_12_total 122 6 * *   *       * *           *         61   12   130 122 6                                   61 12   130
3299554 MO     school 2923310 27058   OTTERVILLE R-VI 292331001341 4020 OTTERVILLE ELEM.   Regular School No Elementary KG 06 2017   k_12_total 127 * * *   *       * *           *         66   20   129 127                                     66 20   129
3299560 MO     school 2925170 27059   PILOT GROVE C-4 292517001448 1050 PILOT GROVE HIGH   Regular School No High 07 12 2017   k_12_total 136 * * *   *       * *           *         50.1   15   139 136                                       15   139
3299566 MO     school 2925170 27059   PILOT GROVE C-4 292517001447 4020 PILOT GROVE ELEM.   Regular School No Elementary PK 06 2017   k_12_total 123 * * *   *       * *           *         61   20   127 123                                     61 20   127
3299602 MO     school 2905640 28101   CRAWFORD CO. R-I 290564001699 3000 BOURBON MIDDLE SCHOOL   Regular School No Middle 05 08 2017   k_12_total 284 * * *   *       * *           *         186   51   297 284                                     186 51   297
3299632 MO     school 2929430 28103   STEELVILLE R-III 292943002037 1050 STEELVILLE HIGH   Regular School No High 09 12 2017   k_12_total 246 * * *   *       * *           *         127   34   253 246                                     127 34   253
3299650 MO     school 2919140 29001   LOCKWOOD R-I 291914001033 1050 LOCKWOOD HIGH   Regular School No High 09 12 2017   k_12_total 117 * * *   *       * *           *         70   13   127 117                                     70 13   127
3299655 MO     school 2919140 29001   LOCKWOOD R-I 291914003283 3000 LOCKWOOD MIDDLE SCHOOL   Regular School No Middle 06 08 2017   k_12_total 65 * * *   *       * *           *         44   9   69 65                                     44 9   69
3299661 MO     school 2919140 29001   LOCKWOOD R-I 291914001032 4020 LOCKWOOD ELEM.   Regular School No Elementary PK 05 2017   k_12_total 125 * * *   *       * *           *         80   9   130 125                                     80 9   130
3299667 MO     school 2910440 29002   DADEVILLE R-II 291044000345 1050 DADEVILLE SR. HIGH   Regular School No Other 06 12 2017   k_12_total 57 * * *   *       * *           *         26   *   57 57                                     26     57
3299673 MO     school 2910440 29002   DADEVILLE R-II 291044000344 4020 DADEVILLE ELEM.   Regular School No Elementary KG 05 2017   k_12_total 80 * * *   *       * *           *         42   10   80 80                                     42 10   80
3299679 MO     school 2911580 29003   EVERTON R-III 291158000413 1050 EVERTON HIGH   Regular School No High 08 12 2017   k_12_total 52 * * *   *       * *           *         *   *   55 52                                           55
3299687 MO     school 2911580 29003   EVERTON R-III 291158000412 4020 EVERTON ELEM.   Regular School No Elementary PK 07 2017   k_12_total 107 * * *   *       * *           *         *   21   110 107                                       21   110
3299699 MO     school 2913320 29004   GREENFIELD R-IV 291332000565 4020 GREENFIELD ELEM.   Regular School No Elementary PK 06 2017   k_12_total 220 * * *   *       * 8           *         180   28   231 220                   8                 180 28   231
3299711 MO     school 2906120 30093   DALLAS CO. R-I 290612000858 3000 BUFFALO MIDDLE   Regular School No Middle 05 08 2017   k_12_total 486 * * *   *       * 8           *         301   62   504 486                   8                 301 62   504
3299724 MO     school 2923670 31116   PATTONSBURG R-II 292367001410 1050 PATTONSBURG HIGH   Regular School No Other 06 12 2017   k_12_total 98 * * *   *       * *           *         48   17   100 98                                     48 17   100
3299730 MO     school 2923670 31116   PATTONSBURG R-II 292367001409 4020 PATTONSBURG ELEM.   Regular School No Elementary PK 05 2017   k_12_total 90 * * *   *       * *           *         57   10   90 90                                     57 10   90
3299736 MO     school 2932250 31117   WINSTON R-VI 293225002262 1050 WINSTON HIGH   Regular School No High 07 12 2017   k_12_total 85 * * *   *       * *           *         43   8   86 85                                     43 8   86
3299742 MO     school 2932250 31117   WINSTON R-VI 293225002261 4020 WINSTON ELEM.   Regular School No Elementary PK 06 2017   k_12_total 83 * * *   *       * *           *         57   14   89 83                                     57 14   89
3299748 MO     school 2915630 31118   NORTH DAVIESS R-III 291563000741 1050 NORTH DAVIESS HIGH   Regular School No High 07 12 2017   k_12_total 33 * * *   *       * *           *         *   11   33 33                                       11   33
3299754 MO     school 2915630 31118   NORTH DAVIESS R-III 291563000740 4020 NORTH DAVIESS ELEM.   Regular School No Elementary PK 06 2017   k_12_total 46 * * *   *       * *           *         35   7   47 46                                     35 7   47
3299764 MO     school 2912660 31121   GALLATIN R-V 291266003296 3000 GALLATIN MIDDLE SCHOOL   Regular School No Middle 05 08 2017   k_12_total 185 5 * *   *       * *           *         86.3   52   194 185 5                                     52   194
3299770 MO     school 2912660 31121   GALLATIN R-V 291266000529 4020 COVEL D. SEARCY ELEM.   Regular School No Elementary PK 04 2017   k_12_total 197 * * *   *       * *           *         113   40   206 197                                     113 40   206

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