enrollments

Data source: Big Local News · About: Big Local

2,295 rows where grade = "k_12_total", state = "MO" and year = 2017 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 2,295 ✖

grade ✖

  • k_12_total · 2,295 ✖
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
3296789 3296789 MO     school 2927570 2097   SAVANNAH R-III 292757003186 7500 EARLY CHILDHOOD LEARNING CTR   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297034 3297034 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No Other PK 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297203 3297203 MO     school 2909900 8111   COLE CAMP R-I 290990003248 7500 COLE CAMP PRESCHOOL   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297566 3297566 MO     school 2901000 10093   COLUMBIA 93 290100003287 7500 CENTER FOR EARLY LRNING-NORTH   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297814 3297814 MO     school 2925450 12109   POPLAR BLUFF R-I 292545002769 7500 POPLAR BLUFF EARLY CHILDHOOD C   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298044 3298044 MO     school 2906990 15002   CAMDENTON R-III 290699001953 1015 JUVENILE JUSTICE CTR.   Alternative School No Other 05 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298490 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
3298596 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
3298713 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 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
3298785 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
3298902 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 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
3299314 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
3299512 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
3300016 3300016 MO     school 2916500 35102   KENNETT 39 291650002656 7500 EARLY CHILDHOOD CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300076 3300076 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346000881 7520 MERAMEC VALLEY EARLY CHILD.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300081 3300081 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346002278 7540 MERAMEC VALLEY COMMUNITY SCH.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300135 3300135 MO     school 2929100 36136   ST. CLAIR R-XIII 292910002568 1010 FRANKLIN CO. SPECL. ED. COOP.   Special Education School No Other PK 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300262 3300262 MO     school 2931110 36139   WASHINGTON 293111002833 7500 EARLY LEARNING CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300443 3300443 MO     school 2926220 39134   REPUBLIC R-III 292622002733 7500 EARLY CHILDHOOD CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300835 3300835 MO     school 2928860 39141   SPRINGFIELD R-XII 292886002905 7500 SHADY DELL EARLY CHILDHOOD CTR   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3300935 3300935 MO     school 2900002 41002   SOUTH HARRISON CO. R-II 290000200922 4030 SOUTH HARRISON EARLY CHILD CTR   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3301005 3301005 MO     school 2906480 42117   CALHOUN R-VIII 290648003284 7500 CALHOUN EARLY CHILDHOOD CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3301057 3301057 MO     school 2909860 42124   CLINTON 290986003291 7500 CLINTON EARLY CHILDHOOD CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3301562 3301562 MO     school 2913080 48069   GRAIN VALLEY R-V 291308003169 7500 GRAIN VALLEY EARLY CHILDHD CTR   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3301742 3301742 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830002612 7500 GREAT BEGINNINGS EARLY ED CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3301817 3301817 MO     school 2914340 48072   HICKMAN MILLS C-1 291434002979 7500 FREDA MARKLEY EARLY CHILDHOOD   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3301911 3301911 MO     school 2926070 48073   RAYTOWN C-2 292607002984 7010 NORTHWOOD SCH.   Regular School No Other KG 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3301914 3301914 MO     school 2926070 48073   RAYTOWN C-2 292607000945 7500 NEW TRAILS EARLY LEARNING CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3301953 3301953 MO     school 2913140 48074   GRANDVIEW C-4 291314000552 5000 HIGH GROVE Early Childhood   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3302140 3302140 MO     school 2915480 48077   INDEPENDENCE 30 291548001485 7500 HANTHORN EARLY EDUCATION   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3302146 3302146 MO     school 2915480 48077   INDEPENDENCE 30 291548003157 7510 SUNSHINE CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3302385 3302385 MO     school 2908250 48080   CENTER 58 290825002755 7500 EARLY CHILDHOOD EDUC. CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3302726 3302726 MO     school 2907460 49142   CARTHAGE R-IX 290746003243 7500 EARLY CHILDHOOD AND PAT CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3302882 3302882 MO     school 2916350 49148   JOPLIN SCHOOLS 291635002778 7500 JOPLIN EARLY CHILDHOOD CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3302942 3302942 MO     school 2922890 50001   NORTHWEST R-I 292289003192 7500 HOUSE SPRINGS EARLY CHILD CTR   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3303208 3303208 MO     school 2912300 50012   FOX C-6 291230003028 7500 DON EARL EARLY CHILDHOOD CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3303250 3303250 MO     school 2910500 50014   DESOTO 73 291050002993 7500 EARLY CHILDHOOD CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3303721 3303721 MO     school   57003   TROY R-III   1000 CENTRAL OFFICE             2017   k_12_total                                                   0                                             0
3303917 3303917 MO     school 2908760 59117   CHILLICOTHE R-II 290876000260 4030 GARRISON ELEM.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3303931 3303931 MO     school   60077   MCDONALD CO. R-I   1000 CENTRAL OFFICE             2017   k_12_total                                                   0                                             0
3304716 3304716 MO     school 2921810 73108   NEOSHO SCHOOL DISTRICT 292181001205 4060 FIELD EARLY CHILD./KDGN. CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3305060 3305060 MO     school 2923780 78013   PEMISCOT CO. SPEC. SCH. DIST. 292378002382 4020 OAK VIEW LEARNING CTR.   Regular School No Other PK 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3305085 3305085 MO     school 2924530 79077   PERRY CO. 32 292453000278 7500 EARLY CHILD. SPECIAL ED. CTR.   Special Education School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3305199 3305199 MO     school 2927830 80125   SEDALIA 200 292783002678 7500 EARLY CHILDHOOD CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3305503 3305503 MO     school 2923550 83005   PARK HILL 292355003087 7500 GERNER FAMILY EARLY ED CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3305533 3305533 MO     school 2911730 84002   FAIR PLAY R-II 291173003214 1010 EXCEPTIONAL PUPIL COOP   Special Education School No Other PK 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306265 3306265 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895000643 7500 EARLY CHILD. FAMILY EDUC. CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306271 3306271 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002077 7520 EARLY CHILD. FAMILY EDUC. CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306277 3306277 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002108 7530 EARLY CHILD. FAMILY EDUC. CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306385 3306385 MO     school 2931650 92089   WENTZVILLE R-IV 293165003006 7500 EARLY CHILDHOOD CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306475 3306475 MO     school 2923160 92091   ORCHARD FARM R-V 292316003290 7500 EARLY LEARNING CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306855 3306855 MO     school 2913830 96088   HAZELWOOD 291383003218 7500 CENTRAL EARLY CHILDHOOD CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306861 3306861 MO     school 2913830 96088   HAZELWOOD 291383003208 7510 EAST EARLY CHILDHOOD CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3306867 3306867 MO     school 2913830 96088   HAZELWOOD 291383003204 7520 WEST EARLY CHILDHOOD CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307010 3307010 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201002591 7500 EARLY EDUCATION CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307070 3307070 MO     school 2923700 96090   PATTONVILLE R-III 292370000656 7500 PATTONVILLE PRE-SCHOOL   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307250 3307250 MO     school 2926850 96091   ROCKWOOD R-VI 292685002849 7500 ROCKWOOD CTR. EARLY CHILD. ED.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307304 3307304 MO     school 2916770 96092   KIRKWOOD R-VII 291677003031 7500 KIRKWOOD EARLY CHILD. CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307463 3307463 MO     school 2920670 96094   MEHLVILLE R-IX 292067002996 7500 JOHN CARY EARLY CHILDHOOD CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307733 3307733 MO     school 2909720 96102   CLAYTON 290972002583 7500 FAMILY CTR.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307840 3307840 MO     school 2917820 96106   LADUE 291782003279 7500 LADUE EARLY CHILDHOOD CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307906 3307906 MO     school 2922650 96109   NORMANDY SCHOOLS COLLABORATIVE 292265002114 4180 EARLY CHILDHOOD CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3307968 3307968 MO     school 2926640 96110   RITENOUR 292664003300 7500 RITENOUR EARLY CHILDHOOD CTR   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308046 3308046 MO     school 2926670 96111   RIVERVIEW GARDENS 292667002765 7530 EARLY CHILD. EDUCATION   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308088 3308088 MO     school 2930660 96112   UNIVERSITY CITY 293066001898 7500 JULIA GOLDSTEIN EARLY CHILD.   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308136 3308136 MO     school 2931530 96114   WEBSTER GROVES 293153002651 4050 WALTER AMBROSE FAMILY CENTER   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308599 3308599 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525002578 1015 JUVENILE CTR.   Alternative School No Other 02 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308725 3308725 MO     school 2905280 104045   BLUE EYE R-V 290528002518 1010 TRI-LAKES SPECL. EDUC. COOP.   Special Education School No Other PK 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3308913 3308913 MO     school 2914840 107152   HOUSTON R-I 291484000686 1010 EXCEPTIONAL CHILD COOP.   Special Education School No Other PK 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3309086 3309086 MO     school 2932310 109002   WRIGHT CITY R-II OF WARREN CO. 293231003273 7500 WRIGHT START PRESCHOOL   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3310452 3310452 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000902793 1091 ROSA PARKS CENTER   Regular School No Other 06 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3310156 3310156 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203059 9027 CROWLEY RIDGE SCHOOL   Special Education School No Other KG 12 2017   k_12_total 9 * * *   *       * *           *         *   *   10 9                                           10
3310388 3310388 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000903077 1074 DISCOVERY HALL   Regular School No Other 06 12 2017   k_12_total * 8 * *   *       * *           *         *   *   10   8                                         10
3310458 3310458 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000901352 1095 COMMUNITY LEARNING CTR.   Regular School No Other 06 12 2017   k_12_total 7 * * *   *       * *           *         *   *   10 7                                           10
3310476 3310476 MO     school 2900009 347347   DIVISION OF YOUTH SERVICE 290000903153 1099 MET DAY TREATMENT CENTER   Regular School No Other 06 12 2017   k_12_total * 10 * *   *       * *           *         *   *   10   10                                         10
3299724 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
3304856 3304856 MO     school 2916860 75086   OREGON-HOWELL R-III 291686000935 1050 KOSHKONONG HIGH   Regular School No High 09 12 2017   k_12_total 96 * * *   *       * *           *         36.4   11   100 96                                       11   100
3305090 3305090 MO     school 2903040 79078   ALTENBURG 48 290304000014 4020 ALTENBURG ELEM.   Regular School No Elementary KG 08 2017   k_12_total 98 * * *   *       * *           *         29   14   100 98                                     29 14   100
3305955 3305955 MO     school 2918450 90078   LESTERVILLE R-IV 291845000991 1050 LESTERVILLE HIGH   Regular School No High 07 12 2017   k_12_total 100 * * *   *       * *           *         47   13   100 100                                     47 13   100
3306036 3306036 MO     school 2908370 92087   FT. ZUMWALT R-II 290837002491 3000 FT. ZUMWALT NORTH MIDDLE   Regular School No Middle 06 08 2017   k_12_total 875 50 34 *   8       * 38           15         231.4   172   1009 875 50 34     8         38           15       172   1009
3304134 3304134 MO     school 2920280 64072   MARION CO. R-II 292028001075 1050 MARION CO. HIGH   Regular School No High 07 12 2017   k_12_total 101 * * *   *       * *           *         45   17   101 101                                     45 17   101
3304164 3304164 MO     school 2913650 64075   HANNIBAL 60 291365000595 1050 HANNIBAL SR. HIGH   Regular School No High 09 12 2017   k_12_total 861 104 17 *   5       * 20           6         446   132   1010 861 104 17     5         20           6     446 132   1010
3306048 3306048 MO     school 2908370 92087   FT. ZUMWALT R-II 290837002427 3070 FT. ZUMWALT SOUTH MIDDLE   Regular School No Middle 06 08 2017   k_12_total 811 62 42 *   59       * 37           6         151.4   105   1016 811 62 42     59         37           6       105   1016
3297028 3297028 MO     school 2912930 6103   GOLDEN CITY R-III 291293000541 4020 GOLDEN CITY ELEM.   Regular School No Elementary KG 06 2017   k_12_total 90 * * *   *       * 12           *         70   14   102 90                   12                 70 14   102
3303833 3303833 MO     school 2920640 58108   MEADVILLE R-IV 292064001108 1050 MEADVILLE HIGH   Regular School No High 07 12 2017   k_12_total 97 * * *   *       * *           *         31   11   102 97                                     31 11   102
3308549 3308549 MO     school 2904530 103128   BELL CITY R-II 290453000047 1050 BELL CITY HIGH   Regular School No High 07 12 2017   k_12_total 97 * * *   *       * *           *         66   16   102 97                                     66 16   102
3302158 3302158 MO     school 2916400 48078   KANSAS CITY 33 291640000844 1220 LINCOLN COLLEGE PREP.   Regular School No Other 06 12 2017   k_12_total 171 426 329 *   64       * 28           9         *   *   1022 171 426 329     64         28           9           1022
3300541 3300541 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001800 1080 HILLCREST HIGH   Regular School No High 09 12 2017   k_12_total 824 124 34 *   6       * 30           *         582   112   1026 824 124 34     6         30                 582 112   1026
3302569 3302569 MO     school 2900597 48924   EWING MARION KAUFFMAN SCHOOL 290059703277 1910 EWING MARION KAUFFMAN HIGH   Regular School Yes Other 09 10 2017   k_12_total * 80 16 *   6       * *           *         81   *   103   80 16     6                           81     103
3304215 3304215 MO     school 2920750 65096   NORTH MERCER CO. R-III 292075001128 4020 NORTH MERCER ELEM.   Regular School No Elementary PK 06 2017   k_12_total 103 * * *   *       * *           *         62   17   103 103                                     62 17   103
3307518 3307518 MO     school 2923580 96095   PARKWAY C-2 292358001555 3080 WEST MIDDLE   Regular School No Middle 06 08 2017   k_12_total 709 115 38 *   131       * 38           *         147   198   1032 709 115 38     131         38                 147 198   1032
3296735 3296735 MO     school 2922710 2089   NORTH ANDREW CO. R-VI 292271000006 3000 NORTH ANDREW MIDDLE   Regular School No Middle 06 08 2017   k_12_total 104 * * *   *       * *           *         47   21   104 104                                     47 21   104
3298896 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
3299824 3299824 MO     school 2929490 32058   STEWARTSVILLE C-2 292949002042 1050 STEWARTSVILLE HIGH   Regular School No High 07 12 2017   k_12_total 99 * * *   *       * *           *         27   13   104 99                                     27 13   104
3301147 3301147 MO     school 2921480 44083   MOUND CITY R-II 292148001179 4020 MOUND CITY ELEM.   Regular School No Elementary PK 04 2017   k_12_total 100 * * *   *       * *           *         37   14   104 100                                     37 14   104
3308184 3308184 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676003168 1069 SOUTHVIEW HIGH   Regular School No High 09 12 2017   k_12_total 89 10 * *   *       * *           *         30.4   *   104 89 10                                         104
3310043 3310043 MO     school 2900611 115928   LA SALLE CHARTER SCHOOL 290061103281 3910 LA SALLE CHARTER SCHOOL   Regular School Yes Middle 05 08 2017   k_12_total * 102 * *   *       * *           *         *   14   104   102                                     14   104
3300340 3300340 MO     school 2902970 38046   ALBANY R-III 290297001478 3000 ALBANY MIDDLE   Regular School No Middle 06 08 2017   k_12_total 99 * * *   *       * 6           *         66   13   105 99                   6                 66 13   105

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