enrollments
Data source: Big Local News · About: Big Local
2,320 rows where grade = "grade_4", state = "MO" and year = 2020
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3172990 | 3172990 | MO | school | 2928560 | 10087 | SOUTHERN BOONE CO. R-I | 292856002802 | 4010 | SOUTHERN BOONE PRIMARY | Regular School | No | Elementary | PK | 02 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3172996 | 3172996 | MO | school | 2928560 | 10087 | SOUTHERN BOONE CO. R-I | 292856001765 | 4020 | SOUTHERN BOONE ELEM. | Regular School | No | Elementary | 03 | 05 | 2020 | grade_4 | 151 | 151 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173002 | 3173002 | MO | school | 2913560 | 10089 | HALLSVILLE R-IV | 291356000578 | 1050 | HALLSVILLE HIGH | Regular School | No | High | 09 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173008 | 3173008 | MO | school | 2913560 | 10089 | HALLSVILLE R-IV | 291356001597 | 3000 | HALLSVILLE MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173014 | 3173014 | MO | school | 2913560 | 10089 | HALLSVILLE R-IV | 291356000577 | 4020 | HALLSVILLE INTERMEDIATE | Regular School | No | Elementary | 02 | 05 | 2020 | grade_4 | 116 | 116 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173020 | 3173020 | MO | school | 2913560 | 10089 | HALLSVILLE R-IV | 291356002975 | 4040 | HALLSVILLE PRIMARY | Regular School | No | Elementary | PK | 01 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173026 | 3173026 | MO | school | 2929700 | 10090 | STURGEON R-V | 292970002053 | 1050 | STURGEON HIGH | Regular School | No | High | 09 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173032 | 3173032 | MO | school | 2929700 | 10090 | STURGEON R-V | 292970001392 | 3000 | STURGEON MIDDLE | Regular School | No | Middle | 05 | 08 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173038 | 3173038 | MO | school | 2929700 | 10090 | STURGEON R-V | 292970002052 | 4020 | STURGEON ELEM. | Regular School | No | Elementary | PK | 04 | 2020 | grade_4 | 33 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173044 | 3173044 | MO | school | 2908400 | 10091 | CENTRALIA R-VI | 290840000244 | 1050 | CENTRALIA HIGH | Regular School | No | High | 09 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173050 | 3173050 | MO | school | 2908400 | 10091 | CENTRALIA R-VI | 290840000243 | 3000 | CHESTER BOREN MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173056 | 3173056 | MO | school | 2908400 | 10091 | CENTRALIA R-VI | 290840000242 | 4020 | CHANCE ELEM. | Regular School | No | Elementary | PK | 02 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173062 | 3173062 | MO | school | 2908400 | 10091 | CENTRALIA R-VI | 290840003092 | 4050 | CENTRALIA INTERMEDIATE | Regular School | No | Elementary | 03 | 05 | 2020 | grade_4 | 88 | 88 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173068 | 3173068 | MO | school | 2913710 | 10092 | HARRISBURG R-VIII | 291371000599 | 1050 | HARRISBURG HIGH | Regular School | No | High | 09 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173074 | 3173074 | MO | school | 2913710 | 10092 | HARRISBURG R-VIII | 291371003100 | 3000 | HARRISBURG MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173080 | 3173080 | MO | school | 2913710 | 10092 | HARRISBURG R-VIII | 291371000598 | 4020 | HARRISBURG ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 44 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173086 | 3173086 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100002577 | 1015 | JUVENILE JUSTICE CTR. | Alternative School | No | Other | 01 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173092 | 3173092 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100002281 | 1020 | FREDERICK DOUGLASS HIGH | Alternative School | No | Other | PK | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173098 | 3173098 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000300 | 1050 | DAVID H. HICKMAN HIGH | Regular School | No | High | 09 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173104 | 3173104 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100003239 | 1060 | MURIEL W. BATTLE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173110 | 3173110 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000299 | 1075 | ROCK BRIDGE SR. HIGH | Regular School | No | High | 09 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173116 | 3173116 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000304 | 2050 | JEFFERSON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173122 | 3173122 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100001402 | 2060 | OAKLAND MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173128 | 3173128 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000317 | 2075 | WEST MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173134 | 3173134 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000841 | 3000 | ANN HAWKINS GENTRY MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173140 | 3173140 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100001408 | 3040 | SMITHTON MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173146 | 3173146 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100001946 | 3060 | JOHN B. LANGE MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173152 | 3173152 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000313 | 4020 | THOMAS BENTON ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 37 | 37 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173158 | 3173158 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100003152 | 4030 | ALPHA HART LEWIS | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 63 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173164 | 3173164 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000298 | 4040 | BLUE RIDGE ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 80 | 80 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173170 | 3173170 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100002279 | 4050 | CEDAR RIDGE ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | grade_4 | 61 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173176 | 3173176 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100002665 | 4055 | DERBY RIDGE ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 87 | 87 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173182 | 3173182 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000303 | 4060 | FAIRVIEW ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 67 | 67 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173187 | 3173187 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100003271 | 4070 | ELIOT BATTLE ELEMENTARY | Regular School | No | Elementary | KG | 05 | 2020 | grade_4 | 85 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173193 | 3173193 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000315 | 5000 | ULYSSES S. GRANT ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 52 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173199 | 3173199 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100002770 | 5010 | MARY PAXTON KEELEY ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173205 | 3173205 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000308 | 5020 | Locust St Expressive Arts Elem | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 36 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173211 | 3173211 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100001142 | 5025 | MIDWAY HEIGHTS ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173217 | 3173217 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100002546 | 5030 | MILL CREEK ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173223 | 3173223 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100002280 | 5035 | NEW HAVEN ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 45 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173229 | 3173229 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000307 | 5040 | PARKADE ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 60 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173233 | 3173233 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100003292 | 5050 | BEULAH RALPH ELEMENTARY | Regular School | No | Elementary | KG | 05 | 2020 | grade_4 | 101 | 101 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173239 | 3173239 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000305 | 5060 | JOHN RIDGEWAY ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | grade_4 | 36 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173245 | 3173245 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000309 | 5080 | ROCK BRIDGE ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 84 | 84 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173251 | 3173251 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000310 | 6000 | RUSSELL BLVD. ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 63 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173257 | 3173257 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000312 | 6010 | SHEPARD BLVD. ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 73 | 73 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173263 | 3173263 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000316 | 6020 | WEST BLVD. ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 50 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173269 | 3173269 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000314 | 6040 | TWO MILE PRAIRIE ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | grade_4 | 33 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173275 | 3173275 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100001598 | 6080 | Center for Gifted Education | Regular School | No | Elementary | 01 | 05 | 2020 | grade_4 | 11 | 11 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173279 | 3173279 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100003287 | 7500 | CENTER FOR EARLY LRNING-NORTH | Regular School | No | Prekindergarten | PK | PK | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173285 | 3173285 | MO | school | 2911250 | 11076 | EAST BUCHANAN CO. C-1 | 291125000391 | 1050 | EAST BUCHANAN HIGH | Regular School | No | High | 09 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173291 | 3173291 | MO | school | 2911250 | 11076 | EAST BUCHANAN CO. C-1 | 291125002282 | 3000 | EAST BUCHANAN MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173297 | 3173297 | MO | school | 2911250 | 11076 | EAST BUCHANAN CO. C-1 | 291125000390 | 4040 | EAST BUCHANAN ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 57 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173303 | 3173303 | MO | school | 2911940 | 11078 | MID-BUCHANAN CO. R-V | 291194000445 | 1050 | MID-BUCHANAN SR. HIGH | Regular School | No | High | 07 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173309 | 3173309 | MO | school | 2911940 | 11078 | MID-BUCHANAN CO. R-V | 291194000443 | 4020 | MID-BUCHANAN ELEM. | Regular School | No | Elementary | PK | 06 | 2020 | grade_4 | 58 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173315 | 3173315 | MO | school | 2910590 | 11079 | BUCHANAN CO. R-IV | 291059000355 | 1050 | DEKALB JR.-SR. HIGH | Regular School | No | High | 07 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173321 | 3173321 | MO | school | 2910590 | 11079 | BUCHANAN CO. R-IV | 291059000356 | 4020 | RUSHVILLE ELEM. | Regular School | No | Elementary | PK | 06 | 2020 | grade_4 | 35 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173327 | 3173327 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001644 | 1050 | BENTON HIGH | Regular School | No | High | 09 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173333 | 3173333 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001648 | 1075 | CENTRAL HIGH | Regular School | No | High | 09 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173339 | 3173339 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001660 | 1080 | LAFAYETTE HIGH | Regular School | No | High | 09 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173345 | 3173345 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001670 | 3000 | ROBIDOUX MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173351 | 3173351 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001646 | 3010 | BODE MIDDLE | Regular School | No | Middle | 07 | 08 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173357 | 3173357 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001673 | 3020 | SPRING GARDEN MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173363 | 3173363 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001674 | 3050 | TRUMAN MIDDLE | Regular School | No | Middle | 07 | 08 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173369 | 3173369 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001649 | 4040 | EDISON ELEM. | Regular School | No | Elementary | PK | 06 | 2020 | grade_4 | 64 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173375 | 3173375 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001650 | 4060 | ELLISON ELEM. | Regular School | No | Elementary | KG | 06 | 2020 | grade_4 | 33 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173381 | 3173381 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706003250 | 4070 | CARDEN PARK ELEM | Regular School | No | Elementary | KG | 06 | 2020 | grade_4 | 76 | 76 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173387 | 3173387 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706003255 | 4080 | OAK GROVE ELEM | Regular School | No | Elementary | PK | 06 | 2020 | grade_4 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173393 | 3173393 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001652 | 4100 | FIELD ELEM. | Regular School | No | Elementary | KG | 06 | 2020 | grade_4 | 47 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173399 | 3173399 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001654 | 4140 | COLEMAN ELEM. | Regular School | No | Elementary | KG | 06 | 2020 | grade_4 | 43 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173405 | 3173405 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001657 | 4180 | HOSEA ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | grade_4 | 87 | 87 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173415 | 3173415 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001659 | 4220 | HYDE ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | grade_4 | 65 | 65 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173425 | 3173425 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001662 | 4260 | LINDBERGH ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | grade_4 | 90 | 90 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173431 | 3173431 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001663 | 4280 | MARK TWAIN ELEM. | Regular School | No | Elementary | KG | 06 | 2020 | grade_4 | 50 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173437 | 3173437 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001667 | 4390 | PARKWAY ELEM. | Regular School | No | Elementary | KG | 06 | 2020 | grade_4 | 61 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173443 | 3173443 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001668 | 4400 | PERSHING ELEM. | Regular School | No | Elementary | KG | 06 | 2020 | grade_4 | 39 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173449 | 3173449 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001669 | 4420 | PICKETT ELEM. | Regular School | No | Elementary | PK | 06 | 2020 | grade_4 | 40 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173455 | 3173455 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001672 | 4460 | SKAITH ELEM. | Regular School | No | Elementary | PK | 06 | 2020 | grade_4 | 60 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173461 | 3173461 | MO | school | 2921750 | 12108 | NEELYVILLE R-IV | 292175001200 | 1050 | NEELYVILLE HIGH | Regular School | No | High | 07 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173467 | 3173467 | MO | school | 2921750 | 12108 | NEELYVILLE R-IV | 292175001201 | 4040 | HILLVIEW ELEM. | Regular School | No | Elementary | PK | 02 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173473 | 3173473 | MO | school | 2921750 | 12108 | NEELYVILLE R-IV | 292175001202 | 4060 | NEELYVILLE ELEM. | Regular School | No | Elementary | 03 | 06 | 2020 | grade_4 | 45 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173479 | 3173479 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545001475 | 1050 | POPLAR BLUFF HIGH | Regular School | No | High | 09 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173485 | 3173485 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545001469 | 2050 | POPLAR BLUFF JR. HIGH | Regular School | No | Middle | 07 | 08 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173491 | 3173491 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545001467 | 4020 | EUGENE FIELD ELEM. | Regular School | No | Elementary | 01 | 03 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173497 | 3173497 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545001947 | 4040 | POPLAR BLUFF MIDDLE SCHOOL | Regular School | No | Middle | 04 | 06 | 2020 | grade_4 | 326 | 326 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173503 | 3173503 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545001471 | 4080 | LAKE ROAD ELEM. | Regular School | No | Elementary | 01 | 05 | 2020 | grade_4 | 43 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173509 | 3173509 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545001472 | 5020 | POPLAR BLUFF KINDERGARTEN CTR. | Regular School | No | Elementary | KG | KG | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173515 | 3173515 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545001474 | 5040 | OAK GROVE ELEM. | Regular School | No | Elementary | 01 | 03 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173521 | 3173521 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545001473 | 5060 | O'NEAL ELEM. | Regular School | No | Elementary | 01 | 03 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173527 | 3173527 | MO | school | 2925450 | 12109 | POPLAR BLUFF R-I | 292545002769 | 7500 | POPLAR BLUFF EARLY CHILDHOOD C | Regular School | No | Prekindergarten | PK | PK | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173533 | 3173533 | MO | school | 2930520 | 12110 | TWIN RIVERS R-X | 293052002095 | 1050 | TWIN RIVERS HIGH | Regular School | No | High | 09 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173535 | 3173535 | MO | school | 2930520 | 12110 | TWIN RIVERS R-X | 293052003337 | 3000 | QULIN MIDDLE | Regular School | No | Middle | 04 | 08 | 2020 | grade_4 | 26 | 26 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173541 | 3173541 | MO | school | 2930520 | 12110 | TWIN RIVERS R-X | 293052002093 | 4040 | FISK ELEMENTARY | Regular School | No | Elementary | PK | 08 | 2020 | grade_4 | 35 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173547 | 3173547 | MO | school | 2930520 | 12110 | TWIN RIVERS R-X | 293052002094 | 4060 | QULIN ELEMENTARY | Regular School | No | Elementary | PK | 03 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173553 | 3173553 | MO | school | 2905850 | 13054 | BRECKENRIDGE R-I | 290585000129 | 1050 | BRECKENRIDGE HIGH | Regular School | No | High | 07 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173559 | 3173559 | MO | school | 2905850 | 13054 | BRECKENRIDGE R-I | 290585000128 | 4020 | BRECKENRIDGE ELEM. | Regular School | No | Elementary | PK | 06 | 2020 | grade_4 | 5 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173565 | 3173565 | MO | school | 2913590 | 13055 | HAMILTON R-II | 291359000580 | 1050 | PENNEY HIGH | Regular School | No | High | 09 | 12 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173571 | 3173571 | MO | school | 2913590 | 13055 | HAMILTON R-II | 291359002663 | 3000 | HAMILTON MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173577 | 3173577 | MO | school | 2913590 | 13055 | HAMILTON R-II | 291359000579 | 4020 | HAMILTON ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 49 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3173583 | 3173583 | MO | school | 2922110 | 13057 | NEW YORK R-IV | 292211001227 | 4020 | NEW YORK ELEM. | Regular School | No | Elementary | KG | 08 | 2020 | grade_4 | 5 | 5 |
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]);