Data source: Big Local News · About: Big Local

2,289 rows where grade = "k_12_total", state = "MO" and year = 2016 sorted by total

View and edit SQL

year

  • 2016 · 2,289

grade

  • k_12_total · 2,289
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
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
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
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
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
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
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
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
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
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
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
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
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
3300015 MO     school 2916500 35102   KENNETT 39 291650002656 7500 EARLY CHILDHOOD CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300075 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346000881 7520 MERAMEC VALLEY EARLY CHILD.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300080 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346002278 7540 MERAMEC VALLEY COMMUNITY SCH.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300134 MO     school 2929100 36136   ST. CLAIR R-XIII 292910002568 1010 FRANKLIN CO. SPECL. ED. COOP.   Special Education School No 4 PK 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300261 MO     school 2931110 36139   WASHINGTON 293111002833 7500 EARLY LEARNING CENTER   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300442 MO     school 2926220 39134   REPUBLIC R-III 292622002733 7500 EARLY CHILDHOOD CENTER   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300834 MO     school 2928860 39141   SPRINGFIELD R-XII 292886002905 7500 SHADY DELL EARLY CHILDHOOD CTR   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300934 MO     school 2900002 41002   SOUTH HARRISON CO. R-II 290000200922 4030 SOUTH HARRISON EARLY CHILD CTR   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3301398 MO     school 2912290 48066   FORT OSAGE R-I 291229002310 7500 EARLY CHILDHOOD CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3301561 MO     school 2913080 48069   GRAIN VALLEY R-V 291308003169 7500 GRAIN VALLEY EARLY CHILDHD CTR   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3301741 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830002612 7500 GREAT BEGINNINGS EARLY ED CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3301816 MO     school 2914340 48072   HICKMAN MILLS C-1 291434002979 7500 EARLY CHILDHOOD CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3301913 MO     school 2926070 48073   RAYTOWN C-2 292607000945 7500 NEW TRAILS EARLY LEARNING CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3301952 MO     school 2913140 48074   GRANDVIEW C-4 291314000552 5000 HIGH GROVE ELEM.   Regular School No 1 PK 05 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3302139 MO     school 2915480 48077   INDEPENDENCE 30 291548001485 7500 HANTHORN EARLY EDUCATION   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3302145 MO     school 2915480 48077   INDEPENDENCE 30 291548003157 7510 SUNSHINE CENTER   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3302384 MO     school 2908250 48080   CENTER 58 290825002755 7500 EARLY CHILDHOOD EDUC. CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3302725 MO     school 2907460 49142   CARTHAGE R-IX 290746003243 7500 EARLY CHILDHOOD AND PAT CENTER   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3302941 MO     school 2922890 50001   NORTHWEST R-I 292289003192 7500 HOUSE SPRINGS EARLY CHILD CTR   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3303249 MO     school 2910500 50014   DESOTO 73 291050002993 7500 EARLY CHILDHOOD CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3303720 MO     school   57003   TROY R-III   1000 CENTRAL OFFICE             2016   k_12_total                                                   0                                             0
3303916 MO     school 2908760 59117   CHILLICOTHE R-II 290876000260 4030 GARRISON ELEM.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3304715 MO     school 2921810 73108   NEOSHO R-V 292181001205 4060 FIELD EARLY CHILD./KDGN. CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3305059 MO     school 2923780 78013   PEMISCOT CO. SPEC. SCH. DIST. 292378002382 4020 OAK VIEW LEARNING CTR.   Regular School No 4 PK 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3305084 MO     school 2924530 79077   PERRY CO. 32 292453000278 7500 EARLY CHILD. SPECIAL ED. CTR.   Special Education School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3305198 MO     school 2927830 80125   SEDALIA 200 292783002678 7500 EARLY CHILDHOOD CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3305502 MO     school 2923550 83005   PARK HILL 292355003087 7500 GERNER FAMILY EARLY ED CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3305532 MO     school 2911730 84002   FAIR PLAY R-II 291173003214 1010 EXCEPTIONAL PUPIL COOP   Special Education School No 4 PK 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306264 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895000643 7500 EARLY CHILD. FAMILY EDUC. CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306270 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002077 7520 EARLY CHILD. FAMILY EDUC. CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306276 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002108 7530 EARLY CHILD. FAMILY EDUC. CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306384 MO     school 2931650 92089   WENTZVILLE R-IV 293165003006 7500 EARLY CHILDHOOD CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306582 MO     school 2911910 94078   FARMINGTON R-VII 291191001890 7500 W. L. JOHNS EARLY CHILDHOOD   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306854 MO     school 2913830 96088   HAZELWOOD 291383003218 7500 CENTRAL EARLY CHILDHOOD CENTER   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306860 MO     school 2913830 96088   HAZELWOOD 291383003208 7510 EAST EARLY CHILDHOOD CENTER   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306866 MO     school 2913830 96088   HAZELWOOD 291383003204 7520 WEST EARLY CHILDHOOD CENTER   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307009 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201002591 7500 EARLY EDUCATION CENTER   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307069 MO     school 2923700 96090   PATTONVILLE R-III 292370000656 7500 PATTONVILLE PRE-SCHOOL   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307249 MO     school 2926850 96091   ROCKWOOD R-VI 292685002849 7500 ROCKWOOD CTR. EARLY CHILD. ED.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307303 MO     school 2916770 96092   KIRKWOOD R-VII 291677003031 7500 KIRKWOOD EARLY CHILD. CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307462 MO     school 2920670 96094   MEHLVILLE R-IX 292067002996 7500 JOHN CARY EARLY CHILDHOOD CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307732 MO     school 2909720 96102   CLAYTON 290972002583 7500 FAMILY CTR.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307839 MO     school 2917820 96106   LADUE 291782003279 7500 LADUE EARLY CHILDHOOD CENTER   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307905 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265002114 4180 EARLY CHILDHOOD CENTER   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308045 MO     school 2926670 96111   RIVERVIEW GARDENS 292667002765 7530 EARLY CHILD. EDUCATION   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308087 MO     school 2930660 96112   UNIVERSITY CITY 293066001898 7500 JULIA GOLDSTEIN EARLY CHILD.   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308135 MO     school 2931530 96114   WEBSTER GROVES 293153002651 4050 WALTER AMBROSE FAMILY CENTER   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308402 MO     school   100062   SCOTT CO. CENTRAL   1000 CENTRAL OFFICE             2016   k_12_total                                                   0                                             0
3308598 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525002578 1015 JUVENILE CTR.   Alternative Education School No 4 02 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308724 MO     school 2905280 104045   BLUE EYE R-V 290528002518 1010 TRI-LAKES SPECL. EDUC. COOP.   Special Education School No 4 PK 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308912 MO     school 2914840 107152   HOUSTON R-I 291484000686 1010 EXCEPTIONAL CHILD COOP.   Special Education School No 4 PK 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3309085 MO     school 2932310 109002   WRIGHT CITY R-II OF WARREN CO. 293231003273 7500 WRIGHT START PRESCHOOL   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3309355 MO     school 2921510 114114   MOUNTAIN GROVE R-III 292151002618 1015 OZARK REGIONAL JUVENILE DET CT   Alternative Education School No 4 KG 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3310215 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203070 9056 PRAIRIE VIEW SCHOOL   Special Education School No 4 KG 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3310113 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203052 9014 LILLIAN SCHAPER SCHOOL   Special Education School No 4 KG 12 2016   k_12_total 9 * * *   *       * *           *         *   *   10 9                                           10
3310149 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203058 9024 CITADEL SCHOOL   Special Education School No 4 KG 12 2016   k_12_total 10 * * *   *       * *           *         *   *   10 10                                           10
3310155 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203059 9027 CROWLEY RIDGE SCHOOL   Special Education School No 4 KG 12 2016   k_12_total 9 * * *   *       * *           *         *   *   10 9                                           10
3310191 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203066 9045 BRIARWOOD SCHOOL   Special Education School No 4 KG 12 2016   k_12_total 9 * * *   *       * *           *         *   *   10 9                                           10
3310227 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203072 9061 OZARK HILLS SCHOOL   Special Education School No 4 KG 12 2016   k_12_total 10 * * *   *       * *           *         *   *   10 10                                           10
3310381 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901936 1073 DATEMA HOUSE   Regular School No 4 05 12 2016   k_12_total 9 * * *   *       * *           *         *   *   10 9                                           10
3310457 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901352 1095 COMMUNITY LEARNING CTR.   Regular School No 4 06 12 2016   k_12_total 9 * * *   *       * *           *         *   *   10 9                                           10
3310463 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901358 1096 WILSON CREEK GROUP HOME   Regular School No 4 06 12 2016   k_12_total 9 * * *   *       * *           *         *   *   10 9                                           10
3299517 MO     school 2905190 27055   BLACKWATER R-II 290519000069 4020 BLACKWATER ELEM.   Regular School No 1 PK 08 2016   k_12_total 99 * * *   *       * *           *         57   18   100 99                                     57 18   100
3304133 MO     school 2920280 64072   MARION CO. R-II 292028001075 1050 MARION CO. HIGH   Regular School No 3 07 12 2016   k_12_total 99 * * *   *       * *           *         43   15   100 99                                     43 15   100
3305785 MO     school 2926190 88073   RENICK R-V 292619001537 4020 RENICK ELEM.   Regular School No 1 PK 08 2016   k_12_total 94 * * *   *       * 6           *         56   26   100 94                   6                 56 26   100
3308906 MO     school 2929730 107151   SUCCESS R-VI 292973002054 4020 SUCCESS ELEM.   Regular School No 1 PK 08 2016   k_12_total 98 * * *   *       * *           *         *   20   100 98                                       20   100
3302611 MO     school 2907350 49132   CARL JUNCTION R-I 290735000198 1050 Carl Junction High School   Regular School No 3 09 12 2016   k_12_total 898 15 40 11   13       * 29           *         282   76   1006 898 15 40 11   13         29                 282 76   1006
3299781 MO     school 2930390 31122   TRI-COUNTY R-VII 293039002081 4020 TRI-COUNTY ELEM.   Regular School No 1 PK 06 2016   k_12_total 99 * * *   *       * *           *         58   23   101 99                                     58 23   101
3301146 MO     school 2921480 44083   MOUND CITY R-II 292148001179 4020 MOUND CITY ELEM.   Regular School No 1 PK 04 2016   k_12_total 98 * * *   *       * *           *         41   13   101 98                                     41 13   101
3303999 MO     school 2903480 61150   ATLANTA C-3 290348000029 4020 ATLANTA ELEM.   Regular School No 1 KG 06 2016   k_12_total 101 * * *   *       * *           *         52   9   101 101                                     52 9   101
3304454 MO     school 2919840 69108   MADISON C-3 291984001054 4020 MADISON ELEM.   Regular School No 1 PK 06 2016   k_12_total 97 * * *   *       * *           *         69   16   101 97                                     69 16   101
3308524 MO     school 2928110 102085   SHELBY CO. R-IV 292811001724 4020 CLARENCE ELEM.   Regular School No 1 PK 05 2016   k_12_total 92 * * *   *       * 6           *         82   16   101 92                   6                 82 16   101
3300540 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001800 1080 HILLCREST HIGH   Regular School No 3 09 12 2016   k_12_total 827 108 38 *   *       5 26           *         582.3   95   1011 827 108 38             5 26                   95   1011
3307517 MO     school 2923580 96095   PARKWAY C-2 292358001555 3080 WEST MIDDLE   Regular School No 2 06 08 2016   k_12_total 705 106 39 *   131       * 33           5         143   204   1015 705 106 39     131         33           5     143 204   1015
3301152 MO     school 2923190 44084   SOUTH HOLT CO. R-I 292319001334 1050 SOUTH HOLT HIGH   Regular School No 3 07 12 2016   k_12_total 100 * * *   *       * *           *         34   8   102 100                                     34 8   102
3305791 MO     school 2914370 88075   HIGBEE R-VIII 291437000667 1050 HIGBEE HIGH   Regular School No 3 07 12 2016   k_12_total 100 * * *   *       * *           *         58   20   102 100                                     58 20   102
3304163 MO     school 2913650 64075   HANNIBAL 60 291365000595 1050 HANNIBAL SR. HIGH   Regular School No 3 09 12 2016   k_12_total 876 106 12 *   8       * 13           *         453   144   1020 876 106 12     8         13                 453 144   1020
3301621 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830002806 3050 SUMMIT LAKES MIDDLE   Regular School No 2 07 08 2016   k_12_total 809 107 46 *   15       * 39           *         93   99   1021 809 107 46     15         39                 93 99   1021
3306035 MO     school 2908370 92087   FT. ZUMWALT R-II 290837002491 3000 FT. ZUMWALT NORTH MIDDLE   Regular School No 2 06 08 2016   k_12_total 887 55 41 *   11       * 34           13         261   170   1029 887 55 41     11         34           13     261 170   1029
3299723 MO     school 2923670 31116   PATTONSBURG R-II 292367001410 1050 PATTONSBURG HIGH   Regular School No 4 06 12 2016   k_12_total 101 * * *   *       * *           *         51   15   103 101                                     51 15   103
3304208 MO     school 2920750 65096   NORTH MERCER CO. R-III 292075001129 1050 MERCER HIGH   Regular School No 3 07 12 2016   k_12_total 98 * * *   *       * *           *         61   21   103 98                                     61 21   103
3305936 MO     school 2906170 90077   BUNKER R-III 290617000156 1050 BUNKER HIGH   Regular School No 3 07 12 2016   k_12_total 103 * * *   *       * *           *         73   13   103 103                                     73 13   103
3305156 MO     school 2927830 80125   SEDALIA 200 292783003143 2000 SMITH COTTON JUNIOR HIGH SCHL   Regular School No 2 06 08 2016   k_12_total 768 58 152 6   13       * 33           80         669.4   116   1031 768 58 152 6   13         33           80       116   1031
3304739 MO     school 2922560 74187   NODAWAY-HOLT R-VII 292256001234 1050 NODAWAY-HOLT JR.-SR. HIGH   Regular School No 3 07 12 2016   k_12_total 99 * * *   *       * *           *         54   18   104 99                                     54 18   104
3305954 MO     school 2918450 90078   LESTERVILLE R-IV 291845000991 1050 LESTERVILLE HIGH   Regular School No 3 07 12 2016   k_12_total 101 * * *   *       * *           *         52   14   104 101                                     52 14   104
3308213 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001599 4069 LITZSINGER   Regular School No 1 KG 08 2016   k_12_total 49 35 5 *   *       * 12           *         57   *   104 49 35 5               12                 57     104
3308548 MO     school 2904530 103128   BELL CITY R-II 290453000047 1050 BELL CITY HIGH   Regular School No 3 07 12 2016   k_12_total 100 * * *   *       * *           *         74   10   104 100                                     74 10   104

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