Data source: Big Local News · About: Big Local

37,120 rows where state = "MO" and year = 2020 sorted by disability descending

View and edit SQL

grade

year

  • 2020 · 37,120
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
3299720 MO     school 2906120 30093   DALLAS CO. R-I 290612000150 4020 MALLORY ELEM.   Regular School No Elementary PK 04 2020   k_12_total 544 11 26 5   *       * 11           *         353   99   599 544 11 26 5             11                 353 99   599
3301619 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830000222 3000 BERNARD C. CAMPBELL MIDDLE   Regular School No Middle 05 08 2020   k_12_total 690 153 53 *   21       * 76           6         260   99   996 690 153 53     21         76           6     260 99   996
3303092 MO     school 2932100 50010   WINDSOR C-1 293210002250 4020 WINDSOR INTERMEDIATE   Regular School No Elementary 03 05 2020   k_12_total 578 16 25 *   *       * 24           5         240   99   646 578 16 25               24           5     240 99   646
3307545 MO     school 2923580 96095   PARKWAY C-2 292358001380 4040 CLAYMONT ELEM.   Regular School No Elementary KG 05 2020   k_12_total 402 48 10 *   27       * 23           *         46   99   511 402 48 10     27         23                 46 99   511
3308277 MO     school 2920410 97129   MARSHALL 292041001083 3000 BUEKER MIDDLE   Regular School No Middle 05 08 2020   k_12_total 430 48 206 *   6       28 34           46         498.4   99   755 430 48 206     6       28 34           46       99   755
3302167 MO     school 2916400 48078   KANSAS CITY 33 291640000860 1340 NORTHEAST HIGH   Regular School No High 09 12 2020   k_12_total 68 279 201 *   90       6 6           192         *   98   651 68 279 201     90       6 6           192       98   651
3306202 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002698 3400 BRYAN MIDDLE   Regular School No Middle 06 08 2020   k_12_total 641 65 36 *   17       * 49           *         146   98   812 641 65 36     17         49                 146 98   812
3306346 MO     school 2931650 92089   WENTZVILLE R-IV 293165002845 4060 CROSSROADS ELEM.   Regular School No Elementary KG 06 2020   k_12_total 564 48 47 *   20       * 47           15         137   98   727 564 48 47     20         47           15     137 98   727
3306400 MO     school 2928920 92090   ST. CHARLES R-VI 292892001851 1075 ST. CHARLES WEST HIGH   Regular School No High 09 12 2020   k_12_total 446 94 71 *   14       * 29           22         188   98   655 446 94 71     14         29           22     188 98   655
3307265 MO     school 2916770 96092   KIRKWOOD R-VII 291677000923 3000 NIPHER MIDDLE   Regular School No Middle 06 08 2020   k_12_total 542 99 31 *   13       * 41           *         106   98   728 542 99 31     13         41                 106 98   728
3307497 MO     school 2923580 96095   PARKWAY C-2 292358001540 3000 SOUTHWEST MIDDLE   Regular School No Middle 06 08 2020   k_12_total 439 62 30 *   55       * 44           *         111   98   632 439 62 30     55         44                 111 98   632
3307943 MO     school 2926640 96110   RITENOUR 292664001568 4100 IVELAND ELEM.   Regular School No Elementary KG 05 2020   k_12_total 147 191 97 *   *       * 43           65         88.4   98   481 147 191 97               43           65       98   481
3300114 MO     school 2930570 36131   UNION R-XI 293057002098 4040 CENTRAL ELEM.   Regular School No Elementary PK 03 2020   k_12_total 655 9 26 *   *       * 32           9         404   97   724 655 9 26               32           9     404 97   724
3301390 MO     school 2912290 48066   FORT OSAGE R-I 291229002284 4110 FIRE PRAIRIE MIDDLE   Regular School No Middle 05 06 2020   k_12_total 586 85 92 *   8       21 23           7         438   97   818 586 85 92     8       21 23           7     438 97   818
3301419 MO     school 2905310 48068   BLUE SPRINGS R-IV 290531000943 3000 BRITTANY HILL MIDDLE   Regular School No Middle 06 08 2020   k_12_total 597 84 78 *   10       * 63           *         235   97   839 597 84 78     10         63                 235 97   839
3302185 MO     school 2916400 48078   KANSAS CITY 33 291640003097 1670 SOUTHEAST HIGH SCHOOL   Regular School No High 09 12 2020   k_12_total 16 519 27 *   *       6 7           5         *   97   578 16 519 27             6 7           5       97   578
3303080 MO     school 2932100 50010   WINDSOR C-1 293210002253 1050 WINDSOR HIGH   Regular School No High 09 12 2020   k_12_total 824 30 31 *   6       * 21           11         285   97   913 824 30 31     6         21           11     285 97   913
3303738 MO     school 2930450 57003   TROY R-III 293045003293 3010 TROY SOUTH MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 652 16 29 *   6       * 45           *         231.4   97   748 652 16 29     6         45                   97   748
3306316 MO     school 2931650 92089   WENTZVILLE R-IV 293165002869 3050 FRONTIER MIDDLE   Regular School No Middle 07 08 2020   k_12_total 651 51 42 *   31       * 30           5         128   97   805 651 51 42     31         30           5     128 97   805
3307025 MO     school 2923700 96090   PATTONVILLE R-III 292370001415 3025 HOLMAN MIDDLE   Regular School No Middle 06 08 2020   k_12_total 212 249 81 *   24       * 52           44         360   97   620 212 249 81     24         52           44     360 97   620
3307139 MO     school 2926850 96091   ROCKWOOD R-VI 292685001614 4020 BALLWIN ELEM.   Regular School No Elementary KG 05 2020   k_12_total 329 52 28 *   63       * 26           43         110   97   498 329 52 28     63         26           43     110 97   498
3307961 MO     school 2926640 96110   RITENOUR 292664001571 4160 MARVIN ELEM.   Regular School No Elementary KG 05 2020   k_12_total 148 221 111 *   6       * 63           79         78.4   97   552 148 221 111     6         63           79       97   552
3297412 MO     school 2901000 10093   COLUMBIA 93 290100001402 2060 OAKLAND MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 256 208 67 *   13       * 56           73         394.4   96   607 256 208 67     13         56           73       96   607
3301697 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830002291 5030 PRAIRIE VIEW ELEM.   Regular School No Elementary KG 06 2020   k_12_total 543 104 38 *   27       * 92           57         307   96   811 543 104 38     27         92           57     307 96   811
3303170 MO     school 2912300 50012   FOX C-6 291230002593 4050 LONE DELL ELEM.   Regular School No Elementary KG 05 2020   k_12_total 385 * 13 *   11       * 8           11         123   96   422 385   13     11         8           11     123 96   422
3306135 MO     school 2908370 92087   FT. ZUMWALT R-II 290837002783 4150 WESTHOFF ELEM.   Regular School No Elementary KG 05 2020   k_12_total 469 32 23 *   9       * 36           13         103   96   572 469 32 23     9         36           13     103 96   572
3306238 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002447 5000 HENDERSON ELEM.   Regular School No Elementary KG 05 2020   k_12_total 476 53 68 *   26       8 49           67         180   96   682 476 53 68     26       8 49           67     180 96   682
3307649 MO     school 2902910 96098   AFFTON 101 290291000007 4040 MESNIER PRIMARY SCH.   Regular School No Elementary KG 02 2020   k_12_total 476 32 36 *   21       * 56           100         178   96   621 476 32 36     21         56           100     178 96   621
3307897 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265002850 4145 LUCAS CROSSING ELEM. COMPLEX   Regular School No Elementary 01 08 2020   k_12_total 5 645 * *   *       * 10           *         706   96   664 5 645                 10                 706 96   664
3308862 MO     school 2905760 106004   BRANSON R-IV 290576003235 4080 CEDAR RIDGE INTERMEDIATE   Regular School No Middle 04 06 2020   k_12_total 400 17 129 *   10       * 33           46         367.3   96   592 400 17 129     10         33           46       96   592
3309377 MO     school 2921510 114114   MOUNTAIN GROVE R-III 292151001181 4020 MOUNTAIN GROVE ELEM.   Regular School No Elementary PK 04 2020   k_12_total 493 * 19 *   *       * 16           *         326   96   533 493   19               16                 326 96   533
3309555 MO     school 2929280 115115   ST. LOUIS CITY 292928002789 4000 ADAMS ELEM.   Regular School No Elementary PK 06 2020   k_12_total 10 196 * *   *       * *           *         *   96   207 10 196                                     96   207
3297418 MO     school 2901000 10093   COLUMBIA 93 290100000317 2075 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 419 136 32 *   16       * 55           5         266.3   95   661 419 136 32     16         55           5       95   661
3300586 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001811 3080 PERSHING MIDDLE   Regular School No Middle 06 08 2020   k_12_total 642 34 44 *   37       * 36           25         322   95   799 642 34 44     37         36           25     322 95   799
3300604 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001818 3140 REED MIDDLE   Regular School No Middle 06 08 2020   k_12_total 511 85 42 *   15       6 59           17         531.4   95   721 511 85 42     15       6 59           17       95   721
3301850 MO     school 2926070 48073   RAYTOWN C-2 292607003085 3020 RAYTOWN CENTRAL MIDDLE   Regular School No Middle 06 08 2020   k_12_total 183 280 67 5   *       * 51           11         374   95   590 183 280 67 5             51           11     374 95   590
3307334 MO     school 2918690 96093   LINDBERGH SCHOOLS 291869003306 4060 DRESSEL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   k_12_total 557 11 28 *   32       * 42           56         122   95   671 557 11 28     32         42           56     122 95   671
3307643 MO     school 2902910 96098   AFFTON 101 290291002461 3000 ROGERS MIDDLE   Regular School No Middle 06 08 2020   k_12_total 412 62 41 *   17       * 47           31         225   95   579 412 62 41     17         47           31     225 95   579
3299157 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001258 3000 ANTIOCH MIDDLE   Regular School No Middle 07 08 2020   k_12_total 493 103 142 *   24       16 93           22         411   94   872 493 103 142     24       16 93           22     411 94   872
3301270 MO     school 2931680 46134   WEST PLAINS R-VII 293168002213 3000 WEST PLAINS MIDDLE   Regular School No Middle 05 08 2020   k_12_total 601 6 20 5   *       * 13           *         427.4   94   649 601 6 20 5             13                   94   649
3303949 MO     school 2920610 60077   MCDONALD CO. R-I 292061001100 4020 ANDERSON ELEM.   Regular School No Elementary PK 05 2020   k_12_total 356 * 50 18   8       21 16           55         316   94   470 356   50 18   8       21 16           55     316 94   470
3308055 MO     school 2930660 96112   UNIVERSITY CITY 293066002113 1050 UNIVERSITY CITY SR. HIGH   Regular School No High 09 12 2020   k_12_total 78 589 31 *   *       * 28           14         *   94   731 78 589 31               28           14       94   731
3308856 MO     school 2905760 106004   BRANSON R-IV 290576003237 4070 BUCHANAN ELEMENTARY   Regular School No Elementary KG 03 2020   k_12_total 531 10 63 *   *       * 16           32         351   94   628 531 10 63               16           32     351 94   628
3297430 MO     school 2901000 10093   COLUMBIA 93 290100001408 3040 SMITHTON MIDDLE   Regular School No Middle 06 08 2020   k_12_total 479 101 52 *   61       * 55           81         260   93   751 479 101 52     61         55           81     260 93   751
3300562 MO     school 2928860 39141   SPRINGFIELD R-XII 292886000901 3000 CARVER MIDDLE   Regular School No Middle 06 08 2020   k_12_total 492 50 93 *   28       * 59           67         406   93   727 492 50 93     28         59           67     406 93   727
3302741 MO     school 2931500 49144   WEBB CITY R-VII 293150002756 2050 WEBB CITY JR. HIGH   Regular School No Middle 07 08 2020   k_12_total 565 8 37 8   11       * 46           6         290   93   677 565 8 37 8   11         46           6     290 93   677
3308061 MO     school 2930660 96112   UNIVERSITY CITY 293066002511 2000 BRITTANY WOODS   Regular School No Middle 06 08 2020   k_12_total 44 499 25 *   *       * 18           12         *   93   590 44 499 25               18           12       93   590
3297424 MO     school 2901000 10093   COLUMBIA 93 290100000841 3000 ANN HAWKINS GENTRY MIDDLE   Regular School No Middle 06 08 2020   k_12_total 678 94 37 *   58       * 57           18         210.4   92   927 678 94 37     58         57           18       92   927
3298125 MO     school 2915600 16090   JACKSON R-II 291560000737 2050 RUSSELL HAWKINS JR. HIGH   Regular School No Middle 07 08 2020   k_12_total 772 16 19 *   6       * 37           *         311   92   852 772 16 19     6         37                 311 92   852
3306196 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895001884 3300 SAEGER MIDDLE   Regular School No Middle 06 08 2020   k_12_total 630 50 39 *   11       * 30           12         130   92   760 630 50 39     11         30           12     130 92   760
3306468 MO     school 2923160 92091   ORCHARD FARM R-V 292316001329 4020 Orchard Farm Elementary   Regular School No Elementary KG 05 2020   k_12_total 443 15 54 *   *       * 21           33         188   92   535 443 15 54               21           33     188 92   535
3308844 MO     school 2905760 106004   BRANSON R-IV 290576002851 4050 BUCHANAN INTERMEDIATE   Regular School No Middle 04 06 2020   k_12_total 436 6 49 *   *       * 25           13         292   92   524 436 6 49               25           13     292 92   524
3309231 MO     school 2909750 111087   CLEARWATER R-I 290975000280 4040 CLEARWATER ELEMENTARY   Regular School No Elementary PK 04 2020   k_12_total 325 * 5 *   *       * 9           *         245   92   341 325   5               9                 245 92   341
3297653 MO     school 2927060 11082   ST. JOSEPH 292706001674 3050 TRUMAN MIDDLE   Regular School No Middle 07 08 2020   k_12_total 357 25 49 *   *       * 47           18         *   91   485 357 25 49               47           18       91   485
3302687 MO     school 2907460 49142   CARTHAGE R-IX 290746000208 2050 CARTHAGE JR. HIGH   Regular School No Middle 07 08 2020   k_12_total 409 6 335 *   *       * 25           134         517   91   785 409 6 335               25           134     517 91   785
3303146 MO     school 2912300 50012   FOX C-6 291230000497 4010 ANTONIA ELEM.   Regular School No Elementary KG 05 2020   k_12_total 500 * 7 *   *       * 12           *         122   91   522 500   7               12                 122 91   522
3307706 MO     school 2909720 96102   CLAYTON 290972000275 1050 CLAYTON HIGH   Regular School No High 09 12 2020   k_12_total 575 140 47 *   102       * 41           9         70   91   906 575 140 47     102         41           9     70 91   906
3298812 MO     school 2909780 22092   CLEVER R-V 290978000281 4020 CLEVER ELEM.   Regular School No Elementary PK 08 2020   k_12_total 794 9 19 *   *       * 11           6         335.1   90   836 794 9 19               11           6       90   836
3299171 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280003321 3160 GATEWAY 6TH GRADE CENTER   Regular School No Middle 06 06 2020   k_12_total 582 106 111 *   24       7 98           23         334   90   930 582 106 111     24       7 98           23     334 90   930
3302986 MO     school 2914430 50003   HILLSBORO R-III 291443000673 4020 HILLSBORO ELEM.   Regular School No Elementary 03 04 2020   k_12_total 446 * 8 *   *       * 10           *         160   90   468 446   8               10                 160 90   468
3307379 MO     school 2920670 96094   MEHLVILLE R-IX 292067001114 3000 MARGARET BUERKLE MIDDLE   Regular School No Middle 06 08 2020   k_12_total 461 72 32 5   31       * 33           93         290   90   635 461 72 32 5   31         33           93     290 90   635
3308121 MO     school 2931530 96114   WEBSTER GROVES 293153002194 3000 HIXSON MIDDLE   Regular School No Middle 07 08 2020   k_12_total 541 107 35 *   8       * 43           *         107   90   738 541 107 35     8         43                 107 90   738
3309549 MO     school 2929280 115115   ST. LOUIS CITY 292928001927 3390 COMPTON-DREW ILC MIDDLE   Regular School No Middle 06 08 2020   k_12_total 30 433 30 *   26       * *           61         *   90   519 30 433 30     26                     61       90   519
3297031 MO     school 2912930 6103   GOLDEN CITY R-III 291293000541 4020 GOLDEN CITY ELEM.   Regular School No Elementary KG 06 2020   k_12_total 81 * * *   *       * 11           *         73   9   95 81                   11                 73 9   95
3297849 MO     school 2905850 13054   BRECKENRIDGE R-I 290585000128 4020 BRECKENRIDGE ELEM.   Regular School No Elementary PK 06 2020   k_12_total 31 * * *   *       * *           *         22   9   33 31                                     22 9   33
3298256 MO     school 2913500 17121   HALE R-I 291350000574 1050 HALE HIGH   Regular School No High 07 12 2020   k_12_total 68 * * *   *       * *           *         29.4   9   71 68                                       9   71
3299533 MO     school 2906150 27056   COOPER CO. R-IV 290615000153 4020 BUNCETON ELEM.   Regular School No Elementary PK 06 2020   k_12_total 49 * * *   *       * *           *         28   9   51 49                                     28 9   51
3299757 MO     school 2915630 31118   NORTH DAVIESS R-III 291563000740 4020 NORTH DAVIESS ELEM.   Regular School No Elementary PK 06 2020   k_12_total 33 * * *   *       * *           *         *   9   33 33                                       9   33
3299797 MO     school 2923250 32054   OSBORN R-O 292325001337 4020 OSBORN ELEM.   Regular School No Elementary KG 06 2020   k_12_total 69 * * *   *       * 5           *         32   9   74 69                   5                 32 9   74
3300862 MO     school 2912690 40100   GRUNDY CO. R-V 291269000532 1050 GRUNDY CO. HIGH   Regular School No High 07 12 2020   k_12_total 53 * * *   *       * *           *         23   9   54 53                                     23 9   54
3300956 MO     school 2912870 41004   GILMAN CITY R-IV 291287000538 1050 GILMAN CITY HIGH   Regular School No High 07 12 2020   k_12_total 59 * * *   *       * *           *         40   9   61 59                                     40 9   61
3301114 MO     school 2914310 43004   HERMITAGE R-IV 291431001964 3000 HERMITAGE MIDDLE   Regular School No Middle 06 08 2020   k_12_total 53 * * *   *       * *           *         37   9   56 53                                     37 9   56
3302113 MO     school 2915480 48077   INDEPENDENCE 30 291548003098 6080 SUGAR CREEK ELEM.   Regular School No Elementary PK 01 2020   k_12_total 79 15 29 *   *       * 18           12         114   9   142 79 15 29               18           12     114 9   142
3302301 MO     school 2916400 48078   KANSAS CITY 33 291640002606 5450 HOLLIDAY MONTESSORI   Regular School No Elementary PK 06 2020   k_12_total 15 148 6 *   *       * *           *         *   9   178 15 148 6                                   9   178
3302555 MO     school 2900590 48922   FRONTIER SCHOOLS 290059003180 3940 FRONTIER SCHL OF EXCELLENCE-M   Regular School Yes Middle 06 08 2020   k_12_total * 56 51 *   *       * *           32         *   9   109   56 51                           32       9   109
3303349 MO     school 2918360 51156   LEETON R-X 291836000986 4020 LEETON ELEM.   Regular School No Elementary PK 05 2020   k_12_total 109 * * *   *       * *           *         59   9   117 109                                     59 9   117
3304105 MO     school 2930870 63066   MARIES CO. R-I 293087002134 1050 VIENNA HIGH   Regular School No High 09 12 2020   k_12_total 124 * * *   *       * *           *         40   9   127 124                                     40 9   127
3304218 MO     school 2920750 65096   NORTH MERCER CO. R-III 292075001128 4020 NORTH MERCER ELEM.   Regular School No Elementary PK 06 2020   k_12_total 83 * * *   *       * 6           *         57   9   91 83                   6                 57 9   91
3304470 MO     school 2923530 69109   PARIS R-II 292353002440 3000 PARIS JR. HIGH   Regular School No Middle 07 08 2020   k_12_total 52 * * *   *       * *           *         21   9   55 52                                     21 9   55
3309683 MO     school 2929280 115115   ST. LOUIS CITY 292928003211 4990 GEORGE WASHINGTON CARVER ELEM   Regular School No Elementary PK 05 2020   k_12_total * 143 * *   *       * *           *         *   9   145   143                                     9   145
3309689 MO     school 2929280 115115   ST. LOUIS CITY 292928001950 5020 JEFFERSON ELEM.   Regular School No Elementary PK 05 2020   k_12_total * 102 * *   *       * *           *         *   9   102   102                                     9   102
3310442 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901289 1085 WATKINS MILL PARK CAMP   Regular School No High 06 12 2020   k_12_total 33 8 * *   *       * *           *         *   9   41 33 8                                     9   41
3296756 MO     school 2927570 2097   SAVANNAH R-III 292757001693 1050 SAVANNAH HIGH   Regular School No High 09 12 2020   k_12_total 655 14 12 *   *       * 13           *         160.4   89   701 655 14 12               13                   89   701
3298065 MO     school 2906990 15002   CAMDENTON R-III 290699000171 4020 DOGWOOD ELEMENTARY   Regular School No Elementary PK 02 2020   k_12_total 528 9 36 *   *       * 12           14         331   89   588 528 9 36               12           14     331 89   588
3299183 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280002730 3200 NORTHGATE MIDDLE   Regular School No Middle 07 08 2020   k_12_total 261 139 119 5   43       17 80           70         467   89   664 261 139 119 5   43       17 80           70     467 89   664
3301631 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830000982 3080 PLEASANT LEA MIDDLE   Regular School No Middle 07 08 2020   k_12_total 727 113 38 *   23       8 61           22         245   89   973 727 113 38     23       8 61           22     245 89   973
3302010 MO     school 2915480 48077   INDEPENDENCE 30 291548000709 3050 BRIDGER MIDDLE   Regular School No Middle 06 06 2020   k_12_total 482 114 131 9   8       * 80           32         576   89   827 482 114 131 9   8         80           32     576 89   827
3302998 MO     school 2914430 50003   HILLSBORO R-III 291443002598 4080 HILLSBORO PRIMARY   Regular School No Elementary KG 02 2020   k_12_total 654 * 18 6   *       * 18           *         278   89   701 654   18 6             18                 278 89   701
3306178 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002307 3000 BARNWELL MIDDLE   Regular School No Middle 06 08 2020   k_12_total 533 78 57 *   50       * 45           33         168   89   766 533 78 57     50         45           33     168 89   766
3306262 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002822 5040 WARREN ELEM.   Regular School No Elementary KG 05 2020   k_12_total 685 35 36 *   32       * 45           36         85   89   836 685 35 36     32         45           36     85 89   836
3307181 MO     school 2926850 96091   ROCKWOOD R-VI 292685001622 4120 GEGGIE ELEM.   Regular School No Elementary KG 05 2020   k_12_total 532 14 18 *   *       * 22           *         49   89   590 532 14 18               22                 49 89   590
3309006 MO     school 2921840 108142   NEVADA R-V 292184001216 3000 NEVADA MIDDLE   Regular School No Middle 06 08 2020   k_12_total 536 11 26 *   8       * 12           5         295.3   89   594 536 11 26     8         12           5       89   594
3296708 MO     school 2916740 1091   KIRKSVILLE R-III 291674002219 4030 KIRKSVILLE PRIMARY   Regular School No Elementary PK 02 2020   k_12_total 411 42 22 *   11       * 19           41         315   88   505 411 42 22     11         19           41     315 88   505
3300502 MO     school 2919170 39139   LOGAN-ROGERSVILLE R-VIII 291917001037 1050 LOGAN-ROGERSVILLE HIGH   Regular School No High 09 12 2020   k_12_total 683 * 10 *   5       * 30           5         192   88   731 683   10     5         30           5     192 88   731
3307331 MO     school 2918690 96093   LINDBERGH SCHOOLS 291869001018 4040 CRESTWOOD ELEM.   Regular School No Elementary KG 05 2020   k_12_total 370 23 22 *   13       * 33           30         99   88   461 370 23 22     13         33           30     99 88   461
3307352 MO     school 2918690 96093   LINDBERGH SCHOOLS 291869001025 5060 SAPPINGTON ELEM.   Regular School No Elementary KG 05 2020   k_12_total 442 14 28 *   26       * 13           53         87   88   523 442 14 28     26         13           53     87 88   523
3307587 MO     school 2923580 96095   PARKWAY C-2 292358001391 4180 MCKELVEY ELEM.   Regular School No Elementary KG 05 2020   k_12_total 200 92 40 8   298       * 38           123         88   88   676 200 92 40 8   298         38           123     88 88   676
3309504 MO     school 2929280 115115   ST. LOUIS CITY 292928002878 2080 YEATMAN-LIDDELL MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 7 324 * *   *       * *           *         *   88   331 7 324                                     88   331
3298059 MO     school 2906990 15002   CAMDENTON R-III 290699000173 3000 CAMDENTON MIDDLE   Regular School No Middle 07 08 2020   k_12_total 602 16 36 *   5       * 25           5         375.4   87   689 602 16 36     5         25           5       87   689
3299031 MO     school 2918540 24090   LIBERTY 53 291854002616 3050 LIBERTY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 548 27 71 *   22       * 36           *         192   87   711 548 27 71     22         36                 192 87   711

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