enrollments
Data source: Big Local News · About: Big Local
2,295 rows where grade = "grade_7", state = "MO" and year = 2017 sorted by school
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3225569 | 3225569 | MO | school | 2928260 | 100063 | SIKESTON R-6 | 292826001741 | 3050 | 5TH AND 6TH GRADE CTR. | Regular School | No | Middle | 05 | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3222808 | 3222808 | MO | school | 2931440 | 85046 | WAYNESVILLE R-VI | 293144003207 | 3010 | 6TH GRADE CENTER | Regular School | No | Middle | 06 | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3225563 | 3225563 | MO | school | 2928260 | 100063 | SIKESTON R-6 | 292826001737 | 2050 | 7TH AND 8TH GRADE CTR. | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 259 | 259 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3225016 | 3225016 | MO | school | 2922650 | 96109 | NORMANDY SCHOOLS COLLABORATIVE | 292265001244 | 3000 | 7th and 8th Grade Center | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 215 | 215 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3221316 | 3221316 | MO | school | 2913650 | 64075 | HANNIBAL 60 | 291365000587 | 4020 | A. D. STOWELL ELEM. | Regular School | No | Elementary | PK | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3221475 | 3221475 | MO | school | 2911220 | 67055 | EAST PRAIRIE R-II | 291122000385 | 4060 | A. J. MARTIN ELEM. | Regular School | No | Elementary | 03 | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3219274 | 3219274 | MO | school | 2915480 | 48077 | INDEPENDENCE 30 | 291548003210 | 6130 | ABRAHAM MALLINSON ELEMENTARY | Regular School | No | Elementary | 02 | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3219468 | 3219468 | MO | school | 2916400 | 48078 | KANSAS CITY 33 | 291640001718 | 5670 | AC PREP ELEMENTARY | Regular School | No | Elementary | PK | 07 | 2017 | grade_7 | 21 | 21 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3226820 | 3226820 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928003211 | 4990 | ACAD OF ENVT SCI/MATH ELEM | Regular School | No | Elementary | PK | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3226674 | 3226674 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928003215 | 3250 | ACAD OF ENVT SCI/MATH MIDDLE | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 58 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3219639 | 3219639 | MO | school | 2900017 | 48914 | ACADEMIE LAFAYETTE | 290001703259 | 6941 | ACADEMIE LAFAYETTE-CHERRY | Regular School | Yes | Elementary | KG | 03 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3219633 | 3219633 | MO | school | 2900017 | 48914 | ACADEMIE LAFAYETTE | 290001702753 | 6940 | ACADEMIE LAFAYETTE-OAK | Regular School | Yes | Elementary | 04 | 08 | 2017 | grade_7 | 87 | 87 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3219740 | 3219740 | MO | school | 2900604 | 48927 | ACADEMY FOR INTEGRATED ARTS | 290060403209 | 6995 | ACADEMY FOR INTEGRATED ARTS | Regular School | Yes | Elementary | PK | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3225348 | 3225348 | MO | school | 2926760 | 96119 | SPECL. SCH. DST. ST. LOUIS CO. | 292676001588 | 4029 | ACKERMAN SCH. | Regular School | No | Elementary | KG | 08 | 2017 | grade_7 | 23 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3213827 | 3213827 | MO | school | 2922980 | 1090 | ADAIR CO. R-I | 292298001314 | 4020 | ADAIR CO. ELEM. | Regular School | No | Elementary | PK | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3213863 | 3213863 | MO | school | 2905790 | 1092 | ADAIR CO. R-II | 290579000124 | 4020 | ADAIR CO. ELEM. | Regular School | No | Elementary | KG | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3213821 | 3213821 | MO | school | 2922980 | 1090 | ADAIR CO. R-I | 292298001315 | 1050 | ADAIR CO. HIGH | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 19 | 19 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3213857 | 3213857 | MO | school | 2905790 | 1092 | ADAIR CO. R-II | 290579000125 | 1050 | ADAIR CO. HIGH | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3226692 | 3226692 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928002789 | 4000 | ADAMS ELEM. | Regular School | No | Elementary | PK | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3215441 | 3215441 | MO | school | 2907380 | 17125 | CARROLLTON R-VII | 290738003131 | 4000 | ADAMS PRIMARY SCHOOL | Regular School | No | Elementary | PK | 01 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214234 | 3214234 | MO | school | 2902850 | 7123 | ADRIAN R-III | 290285000001 | 4020 | ADRIAN ELEM. | Regular School | No | Elementary | PK | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214228 | 3214228 | MO | school | 2902850 | 7123 | ADRIAN R-III | 290285000002 | 1050 | ADRIAN SR. HIGH | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 53 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3225707 | 3225707 | MO | school | 2902880 | 103129 | ADVANCE R-IV | 290288000003 | 4020 | ADVANCE ELEM. | Regular School | No | Elementary | PK | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3225701 | 3225701 | MO | school | 2902880 | 103129 | ADVANCE R-IV | 290288000004 | 1050 | ADVANCE HIGH | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 28 | 28 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3224774 | 3224774 | MO | school | 2902910 | 96098 | AFFTON 101 | 290291000009 | 1050 | AFFTON HIGH | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3224050 | 3224050 | MO | school | 2912010 | 96089 | FERGUSON-FLORISSANT R-II | 291201000449 | 4010 | AIRPORT ELEM. | Regular School | No | Elementary | KG | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3217474 | 3217474 | MO | school | 2902970 | 38046 | ALBANY R-III | 290297000010 | 1050 | ALBANY HIGH | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3217480 | 3217480 | MO | school | 2902970 | 38046 | ALBANY R-III | 290297001478 | 3000 | ALBANY MIDDLE | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 34 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3216192 | 3216192 | MO | school | 2918540 | 24090 | LIBERTY 53 | 291854001004 | 4020 | ALEXANDER DONIPHAN ELEM. | Regular School | No | Elementary | KG | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3225453 | 3225453 | MO | school | 2928360 | 97130 | SLATER | 292836001749 | 4020 | ALEXANDER ELEM. | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 25 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3222600 | 3222600 | MO | school | 2923550 | 83005 | PARK HILL | 292355001366 | 4080 | ALFRED L. RENNER ELEM. | Regular School | No | Elementary | KG | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3219591 | 3219591 | MO | school | 2900025 | 48909 | ALLEN VILLAGE | 290002503233 | 1980 | ALLEN VILLAGE HIGH SCHOOL | Regular School | Yes | High | 09 | 12 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3219601 | 3219601 | MO | school | 2900025 | 48909 | ALLEN VILLAGE | 290002502748 | 6915 | ALLEN VILLAGE SCHOOL | Regular School | Yes | Elementary | KG | 08 | 2017 | grade_7 | 61 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3215351 | 3215351 | MO | school | 2907120 | 16096 | CAPE GIRARDEAU 63 | 290712000184 | 4020 | ALMA SCHRADER ELEM. | Regular School | No | Elementary | KG | 04 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214585 | 3214585 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100003152 | 4030 | ALPHA HART LEWIS | Regular School | No | Elementary | PK | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3219549 | 3219549 | MO | school | 2900029 | 48902 | ALTA VISTA CHARTER SCH. | 290002902741 | 1925 | ALTA VISTA CHARTER SCHOOL | Regular School | Yes | High | 09 | 12 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3219561 | 3219561 | MO | school | 2900029 | 48902 | ALTA VISTA CHARTER SCH. | 290002903216 | 6905 | ALTA VISTA ELEMENTARY SCHOOL | Regular School | Yes | Elementary | KG | 04 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3219555 | 3219555 | MO | school | 2900029 | 48902 | ALTA VISTA CHARTER SCH. | 290002903166 | 3925 | ALTA VISTA MIDDLE SCHOOL | Regular School | Yes | Middle | 06 | 08 | 2017 | grade_7 | 79 | 79 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3222230 | 3222230 | MO | school | 2903040 | 79078 | ALTENBURG 48 | 290304000014 | 4020 | ALTENBURG ELEM. | Regular School | No | Elementary | KG | 08 | 2017 | grade_7 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3227573 | 3227573 | MO | school | 2900009 | 347347 | DIVISION OF YOUTH SERVICE | 290000901287 | 1084 | ALTERNATIVE RESOURCE CTR. | Alternative School | No | Other | 06 | 12 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3213905 | 3213905 | MO | school | 2927570 | 2097 | SAVANNAH R-III | 292757001688 | 4010 | AMAZONIA ELEM. | Regular School | No | Elementary | PK | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3226716 | 3226716 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928002570 | 4250 | AMES VISUAL/PERF. ARTS | Regular School | No | Elementary | PK | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3221086 | 3221086 | MO | school | 2920610 | 60077 | MCDONALD CO. R-I | 292061001100 | 4020 | ANDERSON ELEM. | Regular School | No | Elementary | PK | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3221080 | 3221080 | MO | school | 2920610 | 60077 | MCDONALD CO. R-I | 292061003007 | 3000 | ANDERSON MIDDLE | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 84 | 84 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214561 | 3214561 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000841 | 3000 | ANN HAWKINS GENTRY MIDDLE | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 298 | 298 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3216294 | 3216294 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280001258 | 3000 | ANTIOCH MIDDLE | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 281 | 281 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3220283 | 3220283 | MO | school | 2912300 | 50012 | FOX C-6 | 291230000497 | 4010 | ANTONIA ELEM. | Regular School | No | Elementary | KG | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3220277 | 3220277 | MO | school | 2912300 | 50012 | FOX C-6 | 291230003151 | 2200 | ANTONIA MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 165 | 165 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3223627 | 3223627 | MO | school | 2903120 | 93120 | APPLETON CITY R-II | 290312000017 | 4010 | APPLETON CITY ELEM. | Regular School | No | Elementary | PK | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3223621 | 3223621 | MO | school | 2903120 | 93120 | APPLETON CITY R-II | 290312000019 | 1050 | APPLETON CITY HIGH | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3218467 | 3218467 | MO | school | 2903150 | 47062 | ARCADIA VALLEY R-II | 290315000021 | 4020 | ARCADIA VALLEY ELEM. | Regular School | No | Elementary | PK | 04 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3218455 | 3218455 | MO | school | 2903150 | 47062 | ARCADIA VALLEY R-II | 290315000022 | 1050 | ARCADIA VALLEY HIGH | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3218461 | 3218461 | MO | school | 2903150 | 47062 | ARCADIA VALLEY R-II | 290315000023 | 3000 | ARCADIA VALLEY MIDDLE | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 73 | 73 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3215495 | 3215495 | MO | school | 2903200 | 19139 | ARCHIE R-V | 290320000025 | 1050 | ARCHIE HIGH | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 36 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3223983 | 3223983 | MO | school | 2913830 | 96088 | HAZELWOOD | 291383000613 | 4320 | ARMSTRONG ELEM. | Regular School | No | Elementary | KG | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3223989 | 3223989 | MO | school | 2913830 | 96088 | HAZELWOOD | 291383002858 | 4340 | ARROWPOINT ELEM. | Regular School | No | Elementary | PK | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3217595 | 3217595 | MO | school | 2903270 | 39135 | ASH GROVE R-IV | 290327000027 | 4020 | ASH GROVE ELEM. | Regular School | No | Elementary | PK | 03 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3217589 | 3217589 | MO | school | 2903270 | 39135 | ASH GROVE R-IV | 290327000028 | 1050 | ASH GROVE HIGH | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 58 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3226698 | 3226698 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928001877 | 4060 | ASHLAND ELEM. AND BR. | Regular School | No | Elementary | PK | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3227024 | 3227024 | MO | school | 2900579 | 115906 | CONFLUENCE ACADEMIES | 290057903014 | 6931 | ASPIRE ACADEMY | Regular School | Yes | Elementary | PK | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3220378 | 3220378 | MO | school | 2910500 | 50014 | DESOTO 73 | 291050000347 | 4010 | ATHENA ELEM. | Regular School | No | Elementary | KG | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3221140 | 3221140 | MO | school | 2903480 | 61150 | ATLANTA C-3 | 290348000029 | 4020 | ATLANTA ELEM. | Regular School | No | Elementary | KG | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3221134 | 3221134 | MO | school | 2903480 | 61150 | ATLANTA C-3 | 290348000030 | 1050 | ATLANTA HIGH | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3217359 | 3217359 | MO | school | 2931110 | 36139 | WASHINGTON | 293111002156 | 4020 | AUGUSTA ELEM. | Regular School | No | Elementary | KG | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3220765 | 3220765 | MO | school | 2904020 | 55110 | AURORA R-VIII | 290402000031 | 1050 | AURORA HIGH | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3220771 | 3220771 | MO | school | 2904020 | 55110 | AURORA R-VIII | 290402001517 | 2050 | AURORA JR. HIGH | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 164 | 164 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3227326 | 3227326 | MO | school | 2900022 | 201201 | MO SCHLS FOR THE SEV DISABLED | 290002203064 | 9040 | AUTUMN HILL SCHOOL | Special Education School | No | Other | KG | 12 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3215070 | 3215070 | MO | school | 2922740 | 14126 | NORTH CALLAWAY CO. R-I | 292274001252 | 4020 | AUXVASSE ELEM. | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 31 | 31 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3217048 | 3217048 | MO | school | 2904050 | 34124 | AVA R-I | 290405000034 | 4020 | AVA ELEM. | Regular School | No | Elementary | PK | 04 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3217036 | 3217036 | MO | school | 2904050 | 34124 | AVA R-I | 290405000036 | 1050 | AVA HIGH | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3217042 | 3217042 | MO | school | 2904050 | 34124 | AVA R-I | 290405002548 | 3000 | AVA MIDDLE | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 95 | 95 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3213887 | 3213887 | MO | school | 2904080 | 2090 | AVENUE CITY R-IX | 290408000037 | 4020 | AVENUE CITY ELEM. | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 18 | 18 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3225264 | 3225264 | MO | school | 2931530 | 96114 | WEBSTER GROVES | 293153002190 | 4020 | AVERY ELEM. | Regular School | No | Elementary | KG | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3219788 | 3219788 | MO | school | 2904110 | 49135 | AVILLA R-XIII | 290411000038 | 4020 | AVILLA ELEM. | Regular School | No | Elementary | KG | 08 | 2017 | grade_7 | 16 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3222014 | 3222014 | MO | school | 2903060 | 75087 | ALTON R-IV | 290306000015 | 4020 | Alton Elementary | Regular School | No | Elementary | PK | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3222008 | 3222008 | MO | school | 2903060 | 75087 | ALTON R-IV | 290306000016 | 1050 | Alton High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 47 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3227284 | 3227284 | MO | school | 2900022 | 201201 | MO SCHLS FOR THE SEV DISABLED | 290002203057 | 9023 | B W ROBINSON SCHOOL | Special Education School | No | Other | KG | 12 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3219613 | 3219613 | MO | school | 2900011 | 48911 | B. BANNEKER ACADEMY | 290001102750 | 6925 | B. BANNEKER ACADEMY | Regular School | Yes | Elementary | PK | 08 | 2017 | grade_7 | 32 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3219432 | 3219432 | MO | school | 2916400 | 48078 | KANSAS CITY 33 | 291640002602 | 5440 | B. BANNEKER ELEM. | Regular School | No | Elementary | PK | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3224348 | 3224348 | MO | school | 2926850 | 96091 | ROCKWOOD R-VI | 292685002566 | 4145 | BABLER ELEM. | Regular School | No | Elementary | KG | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3227510 | 3227510 | MO | school | 2900009 | 347347 | DIVISION OF YOUTH SERVICE | 290000901271 | 1070 | BABLER LODGE | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3222069 | 3222069 | MO | school | 2904140 | 77101 | BAKERSFIELD R-IV | 290414000039 | 4020 | BAKERSFIELD ELEM. | Regular School | No | Elementary | PK | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3222063 | 3222063 | MO | school | 2904140 | 77101 | BAKERSFIELD R-IV | 290414000040 | 1050 | BAKERSFIELD HIGH | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 38 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214222 | 3214222 | MO | school | 2904170 | 7122 | BALLARD R-II | 290417000041 | 4020 | BALLARD ELEM. | Regular School | No | Elementary | PK | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214216 | 3214216 | MO | school | 2904170 | 7122 | BALLARD R-II | 290417000042 | 1050 | BALLARD HIGH | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 8 | 8 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3224276 | 3224276 | MO | school | 2926850 | 96091 | ROCKWOOD R-VI | 292685001614 | 4020 | BALLWIN ELEM. | Regular School | No | Elementary | KG | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3225021 | 3225021 | MO | school | 2922650 | 96109 | NORMANDY SCHOOLS COLLABORATIVE | 292265003189 | 4010 | BARACK OBAMA ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3225204 | 3225204 | MO | school | 2930660 | 96112 | UNIVERSITY CITY | 293066002105 | 4060 | BARBARA JORDAN ELEM. | Regular School | No | Elementary | KG | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3223315 | 3223315 | MO | school | 2928950 | 92088 | FRANCIS HOWELL R-III | 292895002307 | 3000 | BARNWELL MIDDLE | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 294 | 294 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3224664 | 3224664 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001375 | 4020 | BARRETTS ELEM. | Regular School | No | Elementary | PK | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3223881 | 3223881 | MO | school | 2913830 | 96088 | HAZELWOOD | 291383000447 | 4040 | BARRINGTON ELEM. | Regular School | No | Elementary | KG | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3222525 | 3222525 | MO | school | 2925230 | 83003 | PLATTE CO. R-III | 292523001451 | 4010 | BARRY SCH. | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 88 | 88 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3215112 | 3215112 | MO | school | 2912550 | 14129 | FULTON 58 | 291255000517 | 4010 | BARTLEY ELEM. | Regular School | No | Elementary | KG | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3224810 | 3224810 | MO | school | 2904500 | 96099 | BAYLESS | 290450000043 | 4020 | BAYLESS ELEMENTARY | Regular School | No | Elementary | PK | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3224804 | 3224804 | MO | school | 2904500 | 96099 | BAYLESS | 290450000715 | 2000 | BAYLESS JUNIOR HIGH | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 126 | 126 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3224798 | 3224798 | MO | school | 2904500 | 96099 | BAYLESS | 290450000044 | 1050 | BAYLESS SENIOR HIGH | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3224540 | 3224540 | MO | school | 2920670 | 96094 | MEHLVILLE R-IX | 292067001109 | 4020 | BEASLEY ELEM. | Regular School | No | Elementary | KG | 05 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3217245 | 3217245 | MO | school | 2930570 | 36131 | UNION R-XI | 293057002097 | 4020 | BEAUFORT ELEM. | Regular School | No | Elementary | KG | 06 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3226568 | 3226568 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928001882 | 1250 | BEAUMONT CTE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3223345 | 3223345 | MO | school | 2928950 | 92088 | FRANCIS HOWELL R-III | 292895001854 | 4020 | BECKY-DAVID ELEM. | Regular School | No | Elementary | KG | 05 | 2017 | grade_7 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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]);