enrollments
Data source: Big Local News · About: Big Local
2,322 rows where grade = "grade_7", state = "MO" and year = 2019
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3214419 | 3214419 | MO | school | 2928560 | 10087 | SOUTHERN BOONE CO. R-I | 292856002802 | 4010 | SOUTHERN BOONE PRIMARY | Regular School | No | Elementary | PK | 02 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214425 | 3214425 | MO | school | 2928560 | 10087 | SOUTHERN BOONE CO. R-I | 292856001765 | 4020 | SOUTHERN BOONE ELEM. | Regular School | No | Elementary | 03 | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214431 | 3214431 | MO | school | 2913560 | 10089 | HALLSVILLE R-IV | 291356000578 | 1050 | HALLSVILLE HIGH | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214437 | 3214437 | MO | school | 2913560 | 10089 | HALLSVILLE R-IV | 291356001597 | 3000 | HALLSVILLE MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 109 | 109 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214443 | 3214443 | MO | school | 2913560 | 10089 | HALLSVILLE R-IV | 291356000577 | 4020 | HALLSVILLE INTERMEDIATE | Regular School | No | Elementary | 02 | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214449 | 3214449 | MO | school | 2913560 | 10089 | HALLSVILLE R-IV | 291356002975 | 4040 | HALLSVILLE PRIMARY | Regular School | No | Elementary | PK | 01 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214455 | 3214455 | MO | school | 2929700 | 10090 | STURGEON R-V | 292970002053 | 1050 | STURGEON HIGH | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214461 | 3214461 | MO | school | 2929700 | 10090 | STURGEON R-V | 292970001392 | 3000 | STURGEON MIDDLE | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 32 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214467 | 3214467 | MO | school | 2929700 | 10090 | STURGEON R-V | 292970002052 | 4020 | STURGEON ELEM. | Regular School | No | Elementary | PK | 04 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214473 | 3214473 | MO | school | 2908400 | 10091 | CENTRALIA R-VI | 290840000244 | 1050 | CENTRALIA HIGH | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214479 | 3214479 | MO | school | 2908400 | 10091 | CENTRALIA R-VI | 290840000243 | 3000 | CHESTER BOREN MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 97 | 97 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214485 | 3214485 | MO | school | 2908400 | 10091 | CENTRALIA R-VI | 290840000242 | 4020 | CHANCE ELEM. | Regular School | No | Elementary | PK | 02 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214491 | 3214491 | MO | school | 2908400 | 10091 | CENTRALIA R-VI | 290840003092 | 4050 | CENTRALIA INTERMEDIATE | Regular School | No | Elementary | 03 | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214497 | 3214497 | MO | school | 2913710 | 10092 | HARRISBURG R-VIII | 291371000599 | 1050 | HARRISBURG HIGH | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214503 | 3214503 | MO | school | 2913710 | 10092 | HARRISBURG R-VIII | 291371003100 | 3000 | HARRISBURG MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214509 | 3214509 | MO | school | 2913710 | 10092 | HARRISBURG R-VIII | 291371000598 | 4020 | HARRISBURG ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214515 | 3214515 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100002577 | 1015 | JUVENILE JUSTICE CTR. | Alternative School | No | Other | 01 | 12 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214521 | 3214521 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100002281 | 1020 | FREDERICK DOUGLASS HIGH | Alternative School | No | Other | PK | 12 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214527 | 3214527 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000300 | 1050 | DAVID H. HICKMAN HIGH | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214533 | 3214533 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100003239 | 1060 | MURIEL W. BATTLE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214539 | 3214539 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000299 | 1075 | ROCK BRIDGE SR. HIGH | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214545 | 3214545 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000304 | 2050 | JEFFERSON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 216 | 216 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214551 | 3214551 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100001402 | 2060 | OAKLAND MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 203 | 203 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214557 | 3214557 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000317 | 2075 | WEST MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 205 | 205 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214563 | 3214563 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000841 | 3000 | ANN HAWKINS GENTRY MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 314 | 314 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214569 | 3214569 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100001408 | 3040 | SMITHTON MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 244 | 244 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214575 | 3214575 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100001946 | 3060 | JOHN B. LANGE MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 187 | 187 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214581 | 3214581 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000313 | 4020 | THOMAS BENTON ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214587 | 3214587 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100003152 | 4030 | ALPHA HART LEWIS | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214593 | 3214593 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000298 | 4040 | BLUE RIDGE ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214599 | 3214599 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100002279 | 4050 | CEDAR RIDGE ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214605 | 3214605 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100002665 | 4055 | DERBY RIDGE ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214611 | 3214611 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000303 | 4060 | FAIRVIEW ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214616 | 3214616 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100003271 | 4070 | ELIOT BATTLE ELEMENTARY | Regular School | No | Elementary | KG | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214622 | 3214622 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000315 | 5000 | ULYSSES S. GRANT ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214628 | 3214628 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100002770 | 5010 | MARY PAXTON KEELEY ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214634 | 3214634 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000308 | 5020 | Locust St Expressive Arts Elem | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214640 | 3214640 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100001142 | 5025 | MIDWAY HEIGHTS ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214646 | 3214646 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100002546 | 5030 | MILL CREEK ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214652 | 3214652 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100002280 | 5035 | NEW HAVEN ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214658 | 3214658 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000307 | 5040 | PARKADE ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214662 | 3214662 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100003292 | 5050 | BEULAH RALPH ELEMENTARY | Regular School | No | Elementary | KG | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214668 | 3214668 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000305 | 5060 | JOHN RIDGEWAY ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214674 | 3214674 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000309 | 5080 | ROCK BRIDGE ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214680 | 3214680 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000310 | 6000 | RUSSELL BLVD. ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214686 | 3214686 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000312 | 6010 | SHEPARD BLVD. ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214692 | 3214692 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000316 | 6020 | WEST BLVD. ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214698 | 3214698 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000314 | 6040 | TWO MILE PRAIRIE ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214704 | 3214704 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100001598 | 6080 | Center for Gifted Education | Regular School | No | Elementary | 01 | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214708 | 3214708 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100003287 | 7500 | CENTER FOR EARLY LRNING-NORTH | Regular School | No | Prekindergarten | PK | PK | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214714 | 3214714 | MO | school | 2911250 | 11076 | EAST BUCHANAN CO. C-1 | 291125000391 | 1050 | EAST BUCHANAN HIGH | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214720 | 3214720 | MO | school | 2911250 | 11076 | EAST BUCHANAN CO. C-1 | 291125002282 | 3000 | EAST BUCHANAN MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 62 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214726 | 3214726 | MO | school | 2911250 | 11076 | EAST BUCHANAN CO. C-1 | 291125000390 | 4040 | EAST BUCHANAN ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214732 | 3214732 | MO | school | 2911940 | 11078 | MID-BUCHANAN CO. R-V | 291194000445 | 1050 | MID-BUCHANAN SR. HIGH | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 58 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214738 | 3214738 | MO | school | 2911940 | 11078 | MID-BUCHANAN CO. R-V | 291194000443 | 4020 | MID-BUCHANAN ELEM. | Regular School | No | Elementary | PK | 06 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214744 | 3214744 | MO | school | 2910590 | 11079 | BUCHANAN CO. R-IV | 291059000355 | 1050 | DEKALB JR.-SR. HIGH | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 23 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214750 | 3214750 | MO | school | 2910590 | 11079 | BUCHANAN CO. R-IV | 291059000356 | 4020 | RUSHVILLE ELEM. | Regular School | No | Elementary | PK | 06 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214756 | 3214756 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001644 | 1050 | BENTON HIGH | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214762 | 3214762 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001648 | 1075 | CENTRAL HIGH | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214768 | 3214768 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001660 | 1080 | LAFAYETTE HIGH | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214774 | 3214774 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001670 | 3000 | ROBIDOUX MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 177 | 177 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214780 | 3214780 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001646 | 3010 | BODE MIDDLE | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 255 | 255 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214786 | 3214786 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001673 | 3020 | SPRING GARDEN MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 187 | 187 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214792 | 3214792 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001674 | 3050 | TRUMAN MIDDLE | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 261 | 261 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214798 | 3214798 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001649 | 4040 | EDISON ELEM. | Regular School | No | Elementary | PK | 06 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214804 | 3214804 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001650 | 4060 | ELLISON ELEM. | Regular School | No | Elementary | KG | 06 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214810 | 3214810 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706003250 | 4070 | CARDEN PARK ELEM | Regular School | No | Elementary | PK | 06 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214816 | 3214816 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706003255 | 4080 | OAK GROVE ELEM | Regular School | No | Elementary | PK | 06 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214822 | 3214822 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001652 | 4100 | FIELD ELEM. | Regular School | No | Elementary | KG | 06 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214828 | 3214828 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001654 | 4140 | COLEMAN ELEM. | Regular School | No | Elementary | KG | 06 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214834 | 3214834 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001657 | 4180 | HOSEA ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214844 | 3214844 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001659 | 4220 | HYDE ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214854 | 3214854 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001662 | 4260 | LINDBERGH ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214860 | 3214860 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001663 | 4280 | MARK TWAIN ELEM. | Regular School | No | Elementary | PK | 06 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214866 | 3214866 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001667 | 4390 | PARKWAY ELEM. | Regular School | No | Elementary | KG | 06 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214872 | 3214872 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001668 | 4400 | PERSHING ELEM. | Regular School | No | Elementary | KG | 06 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214878 | 3214878 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001669 | 4420 | PICKETT ELEM. | Regular School | No | Elementary | PK | 06 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214884 | 3214884 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001672 | 4460 | SKAITH ELEM. | Regular School | No | Elementary | PK | 06 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214890 | 3214890 | MO | school | 2921750 | 12108 | NEELYVILLE R-IV | 292175001200 | 1050 | NEELYVILLE HIGH | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 45 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214896 | 3214896 | MO | school | 2921750 | 12108 | NEELYVILLE R-IV | 292175001201 | 4040 | HILLVIEW ELEM. | Regular School | No | Elementary | PK | 02 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214902 | 3214902 | MO | school | 2921750 | 12108 | NEELYVILLE R-IV | 292175001202 | 4060 | NEELYVILLE ELEM. | Regular School | No | Elementary | 03 | 06 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214908 | 3214908 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545001475 | 1050 | POPLAR BLUFF HIGH | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214914 | 3214914 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545001469 | 2050 | POPLAR BLUFF JR. HIGH | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 383 | 383 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214920 | 3214920 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545001467 | 4020 | EUGENE FIELD ELEM. | Regular School | No | Elementary | 01 | 03 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214926 | 3214926 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545001947 | 4040 | POPLAR BLUFF MIDDLE SCHOOL | Regular School | No | Middle | 04 | 06 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214932 | 3214932 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545001471 | 4080 | LAKE ROAD ELEM. | Regular School | No | Elementary | 01 | 04 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214938 | 3214938 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545001472 | 5020 | POPLAR BLUFF KINDERGARTEN CTR. | Regular School | No | Elementary | KG | KG | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214944 | 3214944 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545001474 | 5040 | OAK GROVE ELEM. | Regular School | No | Elementary | 01 | 03 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214950 | 3214950 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545001473 | 5060 | O'NEAL ELEM. | Regular School | No | Elementary | 01 | 03 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214956 | 3214956 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545002769 | 7500 | POPLAR BLUFF EARLY CHILDHOOD C | Regular School | No | Prekindergarten | PK | PK | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214962 | 3214962 | MO | school | 2930520 | 12110 | TWIN RIVERS R-X | 293052002095 | 1050 | TWIN RIVERS HIGH | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214964 | 3214964 | MO | school | 2930520 | 12110 | TWIN RIVERS R-X | 293052003337 | 3000 | QULIN MIDDLE | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214970 | 3214970 | MO | school | 2930520 | 12110 | TWIN RIVERS R-X | 293052002093 | 4040 | FISK ELEMENTARY | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 37 | 37 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214976 | 3214976 | MO | school | 2930520 | 12110 | TWIN RIVERS R-X | 293052002094 | 4060 | QULIN ELEMENTARY | Regular School | No | Elementary | PK | 04 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214982 | 3214982 | MO | school | 2905850 | 13054 | BRECKENRIDGE R-I | 290585000129 | 1050 | BRECKENRIDGE HIGH | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214988 | 3214988 | MO | school | 2905850 | 13054 | BRECKENRIDGE R-I | 290585000128 | 4020 | BRECKENRIDGE ELEM. | Regular School | No | Elementary | PK | 06 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3214994 | 3214994 | MO | school | 2913590 | 13055 | HAMILTON R-II | 291359000580 | 1050 | PENNEY HIGH | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3215000 | 3215000 | MO | school | 2913590 | 13055 | HAMILTON R-II | 291359002663 | 3000 | HAMILTON MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3215006 | 3215006 | MO | school | 2913590 | 13055 | HAMILTON R-II | 291359000579 | 4020 | HAMILTON ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3215012 | 3215012 | MO | school | 2922110 | 13057 | NEW YORK R-IV | 292211001227 | 4020 | NEW YORK ELEM. | Regular School | No | Elementary | KG | 08 | 2019 | 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]);