Data source: Big Local News · About: Big Local

36,624 rows where state = "MO" and year = 2016 sorted by free_and_reduced_int

View and edit SQL

grade

year

  • 2016 · 36,624
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
3296692 MO     school 2916740 1091   KIRKSVILLE R-III 291674000916 1050 KIRKSVILLE SR. HIGH   Regular School No 3 09 12 2016   k_12_total 680 22 15 *   20       * 10           11         298.2   80   750 680 22 15     20         10           11       80   750
3296788 MO     school 2927570 2097   SAVANNAH R-III 292757003186 7500 EARLY CHILDHOOD LEARNING CTR   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3296824 MO     school 2911760 3033   FAIRFAX R-III 291176000432 4020 FAIRFAX ELEM.   Regular School No 1 PK 06 2016   k_12_total 67 * * *   *       * *           *         32.2   6   67 67                                       6   67
3296866 MO     school 2920810 4110   MEXICO 59 292081001132 4020 EUGENE FIELD ELEM.   Regular School No 1 KG 05 2016   k_12_total 329 45 22 *   *       * 47           *         *   40   445 329 45 22               47                   40   445
3296872 MO     school 2920810 4110   MEXICO 59 292081001133 4060 HAWTHORNE ELEM.   Regular School No 1 KG 05 2016   k_12_total 304 24 66 *   *       * 37           60         *   34   435 304 24 66               37           60       34   435
3296878 MO     school 2920810 4110   MEXICO 59 292081001134 4080 MCMILLAN ELEM.   Regular School No 1 PK 05 2016   k_12_total 185 7 7 *   *       * 22           *         *   29   221 185 7 7               22                   29   221
3296967 MO     school 2928200 5127   SHELL KNOB 78 292820001735 4020 SHELL KNOB ELEM.   Regular School No 1 PK 08 2016   k_12_total 111 * * *   *       * 7           *         *   19   121 111                   7                   19   121
3297003 MO     school 2918510 6101   LIBERAL R-II 291851001003 1050 LIBERAL HIGH   Regular School No 3 09 12 2016   k_12_total 142 * * *   *       * *           *         64.2   27   148 142                                       27   148
3297027 MO     school 2912930 6103   GOLDEN CITY R-III 291293000541 4020 GOLDEN CITY ELEM.   Regular School No 1 KG 06 2016   k_12_total 106 * * *   *       * 9           *         82.4   18   116 106                   9                   18   116
3297033 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No 4 PK 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297105 MO     school 2926310 7124   RICH HILL R-IV 292631001545 4020 RICH HILL ELEM.   Regular School No 1 PK 06 2016   k_12_total 176 * * *   *       * 8           *         *   23   188 176                   8                   23   188
3297156 MO     school 2931070 8107   WARSAW R-IX 293107002152 1050 WARSAW HIGH   Regular School No 3 09 12 2016   k_12_total 373 5 7 *   *       * *           *         *   68   388 373 5 7                                   68   388
3297162 MO     school 2931070 8107   WARSAW R-IX 293107002650 3000 JOHN BOISE MIDDLE   Regular School No 2 06 08 2016   k_12_total 286 * 5 *   *       * 7           *         *   44   303 286   5               7                   44   303
3297168 MO     school 2931070 8107   WARSAW R-IX 293107002153 4020 NORTH ELEM.   Regular School No 1 03 05 2016   k_12_total 127 * * *   *       * 7           *         *   24   137 127                   7                   24   137
3297174 MO     school 2931070 8107   WARSAW R-IX 293107002154 4040 SOUTH ELEM.   Regular School No 1 PK 05 2016   k_12_total 194 * * *   *       * 11           *         *   37   208 194                   11                   37   208
3297180 MO     school 2931070 8107   WARSAW R-IX 293107000834 4060 RUTH MERCER ELEM.   Regular School No 1 KG 02 2016   k_12_total 156 * * *   *       * 9           *         *   36   167 156                   9                   36   167
3297197 MO     school 2909900 8111   COLE CAMP R-I 290990000292 4020 COLE CAMP ELEM.   Regular School No 1 KG 04 2016   k_12_total 219 * 13 *   *       * *           8         148.1   32   234 219   13                           8       32   234
3297202 MO     school 2909900 8111   COLE CAMP R-I 290990003248 7500 COLE CAMP PRESCHOOL   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297208 MO     school 2923640 9077   MEADOW HEIGHTS R-II 292364001406 1050 MEADOW HEIGHTS HIGH   Regular School No 3 07 12 2016   k_12_total 226 * * *   *       * *           *         107.4   27   232 226                                       27   232
3297330 MO     school 2908400 10091   CENTRALIA R-VI 290840000244 1050 CENTRALIA HIGH   Regular School No 3 09 12 2016   k_12_total 385 5 6 *   *       * 5           *         93.2   35   405 385 5 6               5                   35   405
3297348 MO     school 2908400 10091   CENTRALIA R-VI 290840003092 4050 CENTRALIA INTERMEDIATE   Regular School No 1 03 05 2016   k_12_total 294 * 5 *   *       * 8           *         119.3   33   311 294   5               8                   33   311
3297360 MO     school 2913710 10092   HARRISBURG R-VIII 291371003100 3000 HARRISBURG MIDDLE   Regular School No 2 06 08 2016   k_12_total 102 * 5 *   *       * *           *         44.1   13   112 102   5                                   13   112
3297372 MO     school 2901000 10093   COLUMBIA 93 290100002577 1015 JUVENILE JUSTICE CTR.   Alternative Education School No 4 01 12 2016   k_12_total * * * *   *       * *           *         *   *   7                                             7
3297378 MO     school 2901000 10093   COLUMBIA 93 290100002281 1020 FREDERICK DOUGLASS HIGH   Alternative Education School No 4 PK 12 2016   k_12_total 55 53 9 *   7       * 6           22         *   14   130 55 53 9     7         6           22       14   130
3297384 MO     school 2901000 10093   COLUMBIA 93 290100000300 1050 DAVID H. HICKMAN HIGH   Regular School No 3 09 12 2016   k_12_total 1106 289 90 6   88       7 74           69         483.3   147   1660 1106 289 90 6   88       7 74           69       147   1660
3297390 MO     school 2901000 10093   COLUMBIA 93 290100003239 1060 MURIEL W. BATTLE HIGH SCHOOL   Regular School No 3 09 12 2016   k_12_total 756 408 88 7   23       5 89           15         655.4   167   1376 756 408 88 7   23       5 89           15       167   1376
3297414 MO     school 2901000 10093   COLUMBIA 93 290100000317 2075 WEST MIDDLE SCHOOL   Regular School No 2 06 08 2016   k_12_total 386 156 35 *   20       * 36           6         253.3   76   634 386 156 35     20         36           6       76   634
3297438 MO     school 2901000 10093   COLUMBIA 93 290100000313 4020 THOMAS BENTON ELEM.   Regular School No 1 PK 05 2016   k_12_total 113 138 11 *   *       * 35           *         *   32   300 113 138 11               35                   32   300
3297444 MO     school 2901000 10093   COLUMBIA 93 290100003152 4030 ALPHA HART LEWIS   Regular School No 1 PK 05 2016   k_12_total 218 172 25 *   *       * 33           6         *   57   454 218 172 25               33           6       57   454
3297450 MO     school 2901000 10093   COLUMBIA 93 290100000298 4040 BLUE RIDGE ELEM.   Regular School No 1 PK 05 2016   k_12_total 142 143 101 *   21       * 46           92         *   53   456 142 143 101     21         46           92       53   456
3297462 MO     school 2901000 10093   COLUMBIA 93 290100002665 4055 DERBY RIDGE ELEM.   Regular School No 1 PK 05 2016   k_12_total 199 198 48 *   39       * 21           84         *   73   505 199 198 48     39         21           84       73   505
3297473 MO     school 2901000 10093   COLUMBIA 93 290100003271 4070 ELIOT BATTLE ELEMENTARY   Regular School No 1 PK 05 2016   k_12_total 173 153 26 *   *       * 35           10         252.1   41   391 173 153 26               35           10       41   391
3297531 MO     school 2901000 10093   COLUMBIA 93 290100000309 5080 ROCK BRIDGE ELEM.   Regular School No 1 PK 05 2016   k_12_total 441 69 27 *   16       * 41           29         196.1   50   597 441 69 27     16         41           29       50   597
3297549 MO     school 2901000 10093   COLUMBIA 93 290100000316 6020 WEST BLVD. ELEM.   Regular School No 1 PK 05 2016   k_12_total 119 135 27 *   9       * 24           36         *   38   316 119 135 27     9         24           36       38   316
3297561 MO     school 2901000 10093   COLUMBIA 93 290100001598 6080 CENTER FOR GIFTED EDUCATION   Regular School No 1 01 05 2016   k_12_total 59 * * *   *       * *           *         *   *   65 59                                           65
3297619 MO     school 2927060 11082   ST. JOSEPH 292706001648 1075 CENTRAL HIGH   Regular School No 3 09 12 2016   k_12_total 1297 129 138 8   53       9 70           82         656.3   224   1704 1297 129 138 8   53       9 70           82       224   1704
3297637 MO     school 2927060 11082   ST. JOSEPH 292706001646 3010 BODE MIDDLE   Regular School No 2 07 08 2016   k_12_total 367 34 53 *   27       * 43           26         215.3   59   525 367 34 53     27         43           26       59   525
3297813 MO     school 2925450 12109   POPLAR BLUFF R-I 292545002769 7500 POPLAR BLUFF EARLY CHILDHOOD C   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297947 MO     school 2921875 14127   NEW BLOOMFIELD R-III 292187501219 1050 NEW BLOOMFIELD HIGH   Regular School No 4 06 12 2016   k_12_total 386 7 7 *   *       * *           *         164.1   40   402 386 7 7                                   40   402
3298013 MO     school 2900020 14400   MO SCHOOL FOR THE DEAF 290002003021 1050 WHEELER HIGH   Special Education School No 3 09 12 2016   k_12_total 15 7 * *   *       * *           *         *   *   26 15 7                                         26
3298019 MO     school 2900020 14400   MO SCHOOL FOR THE DEAF 290002003022 3000 WHEELER MIDDLE   Special Education School No 2 06 08 2016   k_12_total 10 * * *   *       * *           *         *   *   14 10                                           14
3298025 MO     school 2900020 14400   MO SCHOOL FOR THE DEAF 290002003023 4020 STARK ELEM.   Special Education School No 1 KG 05 2016   k_12_total 13 * * *   *       * *           *         *   *   17 13                                           17
3298043 MO     school 2906990 15002   CAMDENTON R-III 290699001953 1015 JUVENILE JUSTICE CTR.   Alternative Education School No 4 05 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298049 MO     school 2906990 15002   CAMDENTON R-III 290699000175 1050 CAMDENTON HIGH   Regular School No 3 09 12 2016   k_12_total 1204 12 50 5   16       * 8           7         596.3   152   1297 1204 12 50 5   16         8           7       152   1297
3298055 MO     school 2906990 15002   CAMDENTON R-III 290699000173 3000 CAMDENTON MIDDLE   Regular School No 2 07 08 2016   k_12_total 583 11 29 *   6       * 9           5         337.1   75   641 583 11 29     6         9           5       75   641
3298061 MO     school 2906990 15002   CAMDENTON R-III 290699000171 4020 DOGWOOD ELEM.   Regular School No 1 PK 02 2016   k_12_total 588 11 40 7   7       * *           24         420.1   82   653 588 11 40 7   7                     24       82   653
3298079 MO     school 2906990 15002   CAMDENTON R-III 290699002983 4050 HAWTHORN ELEM.   Regular School No 1 03 04 2016   k_12_total 448 14 24 12   *       * *           9         321.2   80   503 448 14 24 12                         9       80   503
3298103 MO     school 2919380 15004   MACKS CREEK R-V 291938001049 1050 MACKS CREEK HIGH   Regular School No 3 07 12 2016   k_12_total 121 * 8 *   *       * *           *         *   8   134 121   8                                   8   134
3298109 MO     school 2919380 15004   MACKS CREEK R-V 291938001048 4020 MACKS CREEK ELEM.   Regular School No 1 PK 06 2016   k_12_total 180 * * *   *       * *           *         *   23   191 180                                       23   191
3298162 MO     school 2915600 16090   JACKSON R-II 291560003265 4140 EAST ELEMENTARY   Regular School No 1 PK 05 2016   k_12_total 393 15 * *   5       * 12           7         149.1   56   430 393 15       5         12           7       56   430
3298204 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712000185 2050 CENTRAL JR. HIGH   Regular School No 2 07 08 2016   k_12_total 354 181 21 *   11       * 57           17         382.2   123   624 354 181 21     11         57           17       123   624
3298240 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712002798 4090 CENTRAL MIDDLE   Regular School No 2 05 06 2016   k_12_total 339 193 24 *   9       * 54           21         415.3   150   620 339 193 24     9         54           21       150   620
3298276 MO     school 2905610 17124   BOSWORTH R-V 290561000107 1050 BOSWORTH HIGH   Regular School No 3 07 12 2016   k_12_total 31 * * *   *       * *           *         *   6   31 31                                       6   31
3298288 MO     school 2907380 17125   CARROLLTON R-VII 290738000202 1050 SENIOR HIGH   Regular School No 3 09 12 2016   k_12_total 252 15 5 *   *       * *           *         104.4   41   273 252 15 5                                   41   273
3298459 MO     school 2925330 19148   PLEASANT HILL R-III 292533001461 1050 PLEASANT HILL HIGH   Regular School No 3 09 12 2016   k_12_total 589 8 24 5   *       * 10           *         98.4   54   639 589 8 24 5             10                   54   639
3298489 MO     school 2913760 19149   HARRISONVILLE R-IX 291376002594 1015 EVERETT WADE JUVENILE CTR.   Alternative Education School No 4 KG 12 2016   k_12_total * * * *   *       * *           *         *   *   6                                             6
3298506 MO     school 2913760 19149   HARRISONVILLE R-IX 291376000602 4020 HARRISONVILLE ELEM.   Regular School No 1 01 03 2016   k_12_total 426 6 19 *   *       * 12           6         210.4   35   468 426 6 19               12           6       35   468
3298536 MO     school 2931800 19151   MIDWAY R-I 293180002224 1050 MIDWAY HIGH   Regular School No 3 07 12 2016   k_12_total 215 * 6 *   *       * *           *         70.3   23   225 215   6                                   23   225
3298589 MO     school 2904620 19152   BELTON 124 290462002988 4090 KENTUCKY TRAIL ELEM.   Regular School No 1 KG 04 2016   k_12_total 366 31 42 *   *       * 31           10         249.1   54   477 366 31 42               31           10       54   477
3298595 MO     school 2904620 19152   BELTON 124 290462002725 7500 GRACE EARLY CHILD. & ED. CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298622 MO     school 2911310 20002   EL DORADO SPRINGS R-II 291131000398 1050 EL DORADO SPRINGS HIGH   Regular School No 3 09 12 2016   k_12_total 340 * * *   *       * *           *         *   45   351 340                                       45   351
3298628 MO     school 2911310 20002   EL DORADO SPRINGS R-II 291131002660 3000 EL DORADO SPRINGS MIDDLE   Regular School No 2 06 08 2016   k_12_total 267 * * *   *       * 5           *         *   40   278 267                   5                   40   278
3298634 MO     school 2911310 20002   EL DORADO SPRINGS R-II 291131000400 4040 EL DORADO SPRINGS ELEM.   Regular School No 1 PK 05 2016   k_12_total 504 * * *   *       * *           *         *   104   512 504                                       104   512
3298676 MO     school 2927520 21151   SALISBURY R-IV 292752001685 1050 SALISBURY HIGH   Regular School No 3 07 12 2016   k_12_total 210 7 * *   *       * *           *         92.1   26   220 210 7                                     26   220
3298712 MO     school 2922530 22089   Nixa Public Schools 292253003132 4030 EARLY LEARNING CENTER   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298730 MO     school 2922530 22089   Nixa Public Schools 292253000463 4060 NICHOLAS A. INMAN INTERMEDIATE   Regular School No 2 05 06 2016   k_12_total 342 * 17 5   6       * 16           *         140.1   58   387 342   17 5   6         16                   58   387
3298736 MO     school 2922530 22089   Nixa Public Schools 292253001651 4070 MATHEWS ELEM.   Regular School No 1 KG 04 2016   k_12_total 389 * 23 *   5       * 35           20         174.4   53   455 389   23     5         35           20       53   455
3298748 MO     school 2922530 22089   Nixa Public Schools 292253002998 4090 HIGH POINTE ELEM.   Regular School No 1 KG 04 2016   k_12_total 405 * 30 *   *       * 36           10         244.4   57   478 405   30               36           10       57   478
3298760 MO     school 2922530 22089   Nixa Public Schools 292253003242 7500 EARLY CHILDHOOD CENTER   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298784 MO     school 2928740 22090   SPARTA R-III 292874003260 7500 SPARTA PK CENTER   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298820 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No 2 07 08 2016   k_12_total 771 7 38 14   5       * 29           9         321.3   87   868 771 7 38 14   5         29           9       87   868
3298832 MO     school 2923430 22093   OZARK R-VI 292343000470 4060 UPPER ELEM.   Regular School No 2 05 06 2016   k_12_total 758 5 49 6   *       * 35           6         333.2   83   856 758 5 49 6             35           6       83   856
3298901 MO     school 2916380 23101   CLARK CO. R-I 291638003254 7500 EARLY CHILDHOOD CENTER   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298925 MO     school 2916450 24086   KEARNEY R-I 291645000891 4040 KEARNEY ELEM.   Regular School No 1 KG 05 2016   k_12_total 227 * 10 *   *       * 7           *         78.2   21   250 227   10               7                   21   250
3298984 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Vocational Education School No 3 10 12 2016   k_12_total 57 103 15 *   *       * 13           *         *   *   188 57 103 15               13                       188
3299015 MO     school 2918540 24090   LIBERTY 53 291854001011 1050 LIBERTY HIGH   Regular School No 3 09 12 2016   k_12_total 1459 128 93 7   47       * 29           11         267.3   133   1767 1459 128 93 7   47         29           11       133   1767
3299033 MO     school 2918540 24090   LIBERTY 53 291854002800 3070 SOUTH VALLEY MIDDLE   Regular School No 2 06 08 2016   k_12_total 567 39 44 7   20       5 15           *         95.3   67   697 567 39 44 7   20       5 15                   67   697
3299063 MO     school 2918540 24090   LIBERTY 53 291854001007 4060 LEWIS AND CLARK ELEM.   Regular School No 1 KG 05 2016   k_12_total 531 14 25 *   20       * 14           17         67.1   38   607 531 14 25     20         14           17       38   607
3299093 MO     school 2918540 24090   LIBERTY 53 291854002863 4160 LIBERTY OAKS ELEM.   Regular School No 1 KG 05 2016   k_12_total 405 47 42 *   18       * 27           18         149.2   50   545 405 47 42     18         27           18       50   545
3299099 MO     school 2918540 24090   LIBERTY 53 291854002902 4180 WARREN HILLS ELEM.   Regular School No 1 KG 05 2016   k_12_total 573 31 36 *   17       * 25           11         76.1   40   684 573 31 36     17         25           11       40   684
3299105 MO     school 2918540 24090   LIBERTY 53 291854003113 4200 KELLYBROOK ELEM SCHOOL   Regular School No 1 KG 05 2016   k_12_total 492 26 50 *   11       * 31           11         100.1   62   614 492 26 50     11         31           11       62   614
3299117 MO     school 2918540 24090   LIBERTY 53 291854002615 7500 EARLY CHILD. EDUCATION CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3299199 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001262 4080 CHAPEL HILL ELEM.   Regular School No 1 KG 05 2016   k_12_total 337 57 48 5   29       12 38           53         204.2   23   526 337 57 48 5   29       12 38           53       23   526
3299313 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280002662 7500 PLEASANT VALLEY EARLY CHILD.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3299342 MO     school 2917970 25002   LATHROP R-II 291797000960 1050 LATHROP HIGH   Regular School No 3 09 12 2016   k_12_total 279 6 5 *   *       * *           *         74.4   32   297 279 6 5                                   32   297
3299426 MO     school 2916190 26006   JEFFERSON CITY 291619000749 1050 JEFFERSON CITY HIGH   Regular School No 3 09 12 2016   k_12_total 1768 428 128 10   28       * 137           29         1085.2   227   2500 1768 428 128 10   28         137           29       227   2500
3299439 MO     school 2916190 26006   JEFFERSON CITY 291619000495 3020 THOMAS JEFFERSON MIDDLE   Regular School No 2 06 08 2016   k_12_total 630 196 85 *   26       * 51           31         523.3   99   992 630 196 85     26         51           31       99   992
3299451 MO     school 2916190 26006   JEFFERSON CITY 291619002288 4025 CALLAWAY HILLS ELEM.   Regular School No 1 KG 05 2016   k_12_total 230 19 5 *   *       * 27           *         *   33   282 230 19 5               27                   33   282
3299463 MO     school 2916190 26006   JEFFERSON CITY 291619000748 4040 EAST ELEM.   Regular School No 1 KG 05 2016   k_12_total 120 184 23 *   *       * 42           *         *   38   371 120 184 23               42                   38   371
3299487 MO     school 2916190 26006   JEFFERSON CITY 291619000755 4080 SOUTH ELEM.   Regular School No 1 KG 05 2016   k_12_total 121 137 18 *   21       * 19           15         *   38   316 121 137 18     21         19           15       38   316
3299499 MO     school 2916190 26006   JEFFERSON CITY 291619000757 5020 THORPE J. GORDON ELEM.   Regular School No 1 KG 05 2016   k_12_total 118 118 14 *   *       * 28           7         *   23   281 118 118 14               28           7       23   281
3299511 MO     school 2916190 26006   JEFFERSON CITY 291619003121 7500 SOUTHWEST EARLY CHILDHOOD CTR   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3299577 MO     school 2905580 27061   BOONVILLE R-I 290558000105 3000 LAURA SPEED ELLIOTT MIDDLE   Regular School No 2 06 08 2016   k_12_total 288 39 9 *   *       * 24           *         *   58   361 288 39 9               24                   58   361
3299583 MO     school 2905580 27061   BOONVILLE R-I 290558000102 4020 HANNAH COLE PRIMARY   Regular School No 1 PK 02 2016   k_12_total 267 26 9 *   *       * 31           *         *   51   334 267 26 9               31                   51   334
3299589 MO     school 2905580 27061   BOONVILLE R-I 290558000103 4040 DAVID BARTON ELEM.   Regular School No 1 03 05 2016   k_12_total 271 28 8 *   *       * 24           *         *   57   335 271 28 8               24                   57   335
3299613 MO     school 2910410 28102   CRAWFORD CO. R-II 291041000341 1050 CUBA HIGH   Regular School No 3 09 12 2016   k_12_total 394 * 19 *   *       * *           6         199.4   46   417 394   19                           6       46   417
3299678 MO     school 2911580 29003   EVERTON R-III 291158000413 1050 EVERTON HIGH   Regular School No 3 09 12 2016   k_12_total 53 * * *   *       * *           *         *   *   57 53                                           57
3299684 MO     school 2911580 29003   EVERTON R-III 291158003118 3000 EVERTON MIDDLE   Regular School No 2 06 08 2016   k_12_total 38 * * *   *       * *           *         *   *   39 38                                           39
3299686 MO     school 2911580 29003   EVERTON R-III 291158000412 4020 EVERTON ELEM.   Regular School No 1 PK 05 2016   k_12_total 65 * * *   *       * *           *         *   12   68 65                                       12   68
3299841 MO     school 2927090 33090   SALEM R-80 292709001677 2050 SALEM MIDDLE SCHOOL   Regular School No 2 06 08 2016   k_12_total 219 * * *   *       * *           *         *   41   232 219                                       41   232

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);