enrollments
Data source: Big Local News · About: Big Local
367 rows where grade = "grade_7", state = "MD" and year = 2020 sorted by school_state_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1246215 | 1246215 | MD | school | 2400090 | 30 | Baltimore City | 240009000322 | 232 | Thomas Jefferson Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 55 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246226 | 1246226 | MD | school | 2400090 | 30 | Baltimore City | 240009000306 | 233 | Roland Park Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 248 | 248 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246245 | 1246245 | MD | school | 2400090 | 30 | Baltimore City | 240009000222 | 235 | Glenmount Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 78 | 78 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246256 | 1246256 | MD | school | 2400090 | 30 | Baltimore City | 240009000231 | 236 | Hamilton Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 125 | 125 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1242013 | 1242013 | MD | school | 2400480 | 15 | Montgomery | 240048001447 | 237 | Robert Frost Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 362 | 362 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246267 | 1246267 | MD | school | 2400090 | 30 | Baltimore City | 240009000244 | 237 | Highlandtown Elementary/Middle #237 | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 77 | 77 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1242023 | 1242023 | MD | school | 2400480 | 15 | Montgomery | 240048001451 | 239 | Alternative Programs | Alternative School | No | High | 07 | 12 | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
1246283 | 1246283 | MD | school | 2400090 | 30 | Baltimore City | 240009000224 | 240 | Graceland Park/O'Donnel Heights Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 58 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246294 | 1246294 | MD | school | 2400090 | 30 | Baltimore City | 240009000199 | 241 | Fallstaff Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 44 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246313 | 1246313 | MD | school | 2400090 | 30 | Baltimore City | 240009000147 | 243 | Armistead Gardens Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 95 | 95 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246324 | 1246324 | MD | school | 2400090 | 30 | Baltimore City | 240009000268 | 245 | Leith Walk Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246335 | 1246335 | MD | school | 2400090 | 30 | Baltimore City | 240009000155 | 246 | Beechfield Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 87 | 87 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1242059 | 1242059 | MD | school | 2400480 | 15 | Montgomery | 240048000861 | 247 | John H. Poole Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 115 | 115 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246346 | 1246346 | MD | school | 2400090 | 30 | Baltimore City | 240009000182 | 247 | Cross Country Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 77 | 77 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1242063 | 1242063 | MD | school | 2400480 | 15 | Montgomery | 240048000644 | 248 | Forest Oak Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 304 | 304 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1238452 | 1238452 | MD | school | 2400120 | 3 | Baltimore County | 240012001431 | 252 | Northwest Academy of Health Sciences | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 269 | 269 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1238456 | 1238456 | MD | school | 2400120 | 3 | Baltimore County | 240012000501 | 253 | Woodlawn Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 208 | 208 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1238460 | 1238460 | MD | school | 2400120 | 3 | Baltimore County | 240012000372 | 254 | Deer Park Middle Magnet School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 451 | 451 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246389 | 1246389 | MD | school | 2400090 | 30 | Baltimore City | 240009000188 | 254 | Dr. Martin Luther King, Jr., Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 27 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1238464 | 1238464 | MD | school | 2400120 | 3 | Baltimore County | 240012001574 | 256 | Windsor Mill Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 249 | 249 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246400 | 1246400 | MD | school | 2400090 | 30 | Baltimore City | 240009001390 | 256 | Calvin M. Rodwell Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 89 | 89 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246427 | 1246427 | MD | school | 2400090 | 30 | Baltimore City | 240009001558 | 262 | Empowerment Academy | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 37 | 37 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240992 | 1240992 | MD | school | 2400390 | 12 | Harford | 240039000678 | 265 | Aberdeen Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 396 | 396 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246438 | 1246438 | MD | school | 2400090 | 30 | Baltimore City | 240009000336 | 301 | William S. Baer School | Special Education School | No | Other | PK | 12 | 2020 | grade_7 | 14 | 14 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239530 | 1239530 | MD | school | 2400180 | 5 | Caroline | 240018000526 | 302 | Lockerman Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 309 | 309 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239868 | 1239868 | MD | school | 2400240 | 7 | Cecil | 240024000567 | 303 | Elkton Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 188 | 188 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1244608 | 1244608 | MD | school | 2400540 | 17 | Queen Anne's | 240054001190 | 303 | Centreville Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 187 | 187 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241390 | 1241390 | MD | school | 2400420 | 13 | Howard | 240042000403 | 304 | Mount View Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 264 | 264 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1244993 | 1244993 | MD | school | 2400660 | 21 | Washington | 240066001263 | 304 | E. Russell Hicks Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 305 | 305 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1244696 | 1244696 | MD | school | 2400600 | 18 | Saint Mary's | 240060001229 | 305 | Leonardtown Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 382 | 382 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241408 | 1241408 | MD | school | 2400420 | 13 | Howard | 240042001552 | 307 | Folly Quarter Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 226 | 226 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245394 | 1245394 | MD | school | 2400720 | 23 | Worcester | 240072000880 | 308 | Stephen Decatur Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 373 | 373 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240466 | 1240466 | MD | school | 2400330 | 10 | Frederick | 240033000640 | 311 | Middletown Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 250 | 250 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1242132 | 1242132 | MD | school | 2400480 | 15 | Montgomery | 240048090453 | 311 | Francis Scott Key Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 316 | 316 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239888 | 1239888 | MD | school | 2400240 | 7 | Cecil | 240024000564 | 313 | Cherry Hill Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 156 | 156 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246459 | 1246459 | MD | school | 2400090 | 30 | Baltimore City | 240009001364 | 313 | Lois T. Murray Elementary/Middle | Special Education School | No | Elementary | PK | 08 | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
1239485 | 1239485 | MD | school | 2400150 | 4 | Calvert | 240015000515 | 315 | Northern Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 255 | 255 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239505 | 1239505 | MD | school | 2400150 | 4 | Calvert | 240015000967 | 318 | Windy Hill Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 268 | 268 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246474 | 1246474 | MD | school | 2400090 | 30 | Baltimore City | 240009000883 | 321 | Midtown Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_7 | 22 | 22 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246485 | 1246485 | MD | school | 2400090 | 30 | Baltimore City | 240009000884 | 322 | New Song Academy | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 20 | 20 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246489 | 1246489 | MD | school | 2400090 | 30 | Baltimore City | 240009001291 | 323 | The Crossroads School | Regular School | Yes | Middle | 06 | 08 | 2020 | grade_7 | 52 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246493 | 1246493 | MD | school | 2400090 | 30 | Baltimore City | 240009001302 | 325 | ConneXions: A Community Based Arts School | Regular School | Yes | High | 06 | 12 | 2020 | grade_7 | 71 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246507 | 1246507 | MD | school | 2400090 | 30 | Baltimore City | 240009001478 | 326 | City Neighbors Charter School | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_7 | 28 | 28 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246518 | 1246518 | MD | school | 2400090 | 30 | Baltimore City | 240009001480 | 327 | Patterson Park Public Charter School | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 55 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246529 | 1246529 | MD | school | 2400090 | 30 | Baltimore City | 240009001527 | 328 | Southwest Baltimore Charter School | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 47 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1242169 | 1242169 | MD | school | 2400480 | 15 | Montgomery | 240048000783 | 333 | Benjamin Banneker Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 276 | 276 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1242181 | 1242181 | MD | school | 2400480 | 15 | Montgomery | 240048090450 | 335 | Briggs Chaney Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 316 | 316 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246551 | 1246551 | MD | school | 2400090 | 30 | Baltimore City | 240009001631 | 335 | Baltimore International Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_7 | 51 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246562 | 1246562 | MD | school | 2400090 | 30 | Baltimore City | 240009001657 | 336 | Baltimore Montessori Public Charter School | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 28 | 28 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246565 | 1246565 | MD | school | 2400090 | 30 | Baltimore City | 240009001661 | 337 | Afya Public Charter School | Regular School | Yes | Middle | 07 | 08 | 2020 | grade_7 | 118 | 118 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1242215 | 1242215 | MD | school | 2400480 | 15 | Montgomery | 240048001739 | 345 | Hallie Wells Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 276 | 276 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246574 | 1246574 | MD | school | 2400090 | 30 | Baltimore City | 240009001662 | 345 | Joseph C. Briscoe Academy | Special Education School | No | High | 06 | 12 | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
1246588 | 1246588 | MD | school | 2400090 | 30 | Baltimore City | 240009001680 | 346 | City Neighbors Hamilton | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_7 | 28 | 28 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246598 | 1246598 | MD | school | 2400090 | 30 | Baltimore City | 240009001681 | 347 | KIPP Harmony Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_7 | 188 | 188 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246602 | 1246602 | MD | school | 2400090 | 30 | Baltimore City | 240009001682 | 348 | Baltimore Leadership School for Young Women | Regular School | Yes | High | 06 | 12 | 2020 | grade_7 | 118 | 118 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246610 | 1246610 | MD | school | 2400090 | 30 | Baltimore City | 240009001678 | 349 | N.A.C.A. Freedom and Democracy Academy II | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 35 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1238519 | 1238519 | MD | school | 2400120 | 3 | Baltimore County | 240012000448 | 352 | Pikesville Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 328 | 328 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1238523 | 1238523 | MD | school | 2400120 | 3 | Baltimore County | 240012000441 | 353 | Sudbrook Magnet Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 334 | 334 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246623 | 1246623 | MD | school | 2400090 | 30 | Baltimore City | 240009001675 | 364 | Bluford Drew Jemison STEM Academy West | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246637 | 1246637 | MD | school | 2400090 | 30 | Baltimore City | 240009001670 | 368 | Elmer A. Henderson: A Johns Hopkins Partnership | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246642 | 1246642 | MD | school | 2400090 | 30 | Baltimore City | 240009001734 | 371 | Lillie May Carroll Jackson School | Regular School | Yes | Middle | 05 | 08 | 2020 | grade_7 | 70 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241092 | 1241092 | MD | school | 2400390 | 12 | Harford | 240039001397 | 372 | Bel Air Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 457 | 457 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246653 | 1246653 | MD | school | 2400090 | 30 | Baltimore City | 240009001689 | 373 | Tunbridge Public Charter School | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241101 | 1241101 | MD | school | 2400390 | 12 | Harford | 240039000682 | 374 | Southampton Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 420 | 420 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246657 | 1246657 | MD | school | 2400090 | 30 | Baltimore City | 240009001693 | 374 | Vanguard Collegiate Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 124 | 124 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246663 | 1246663 | MD | school | 2400090 | 30 | Baltimore City | 240009001736 | 375 | Baltimore Collegiate School for Boys | Regular School | Yes | Middle | 04 | 08 | 2020 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246672 | 1246672 | MD | school | 2400090 | 30 | Baltimore City | 240009001691 | 377 | Green Street Academy | Regular School | Yes | High | 06 | 12 | 2020 | grade_7 | 125 | 125 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246680 | 1246680 | MD | school | 2400090 | 30 | Baltimore City | 240009001703 | 382 | Baltimore Design School | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 81 | 81 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241115 | 1241115 | MD | school | 2400390 | 12 | Harford | 240039090475 | 386 | Fallston Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 300 | 300 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241126 | 1241126 | MD | school | 2400390 | 12 | Harford | 240039000703 | 391 | John Archer School | Special Education School | No | Other | PK | 12 | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
1245013 | 1245013 | MD | school | 2400660 | 21 | Washington | 240066001261 | 401 | Clear Spring Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 115 | 115 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245420 | 1245420 | MD | school | 2400720 | 23 | Worcester | 240072001326 | 401 | Cedar Chapel Special School | Special Education School | No | Other | PK | 12 | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
1241717 | 1241717 | MD | school | 2400450 | 14 | Kent | 240045000766 | 402 | Kent County Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 121 | 121 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1244626 | 1244626 | MD | school | 2400540 | 17 | Queen Anne's | 240054001196 | 404 | Stevensville Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 167 | 167 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1244713 | 1244713 | MD | school | 2400600 | 18 | Saint Mary's | 240060001231 | 404 | Margaret Brent Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 344 | 344 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241422 | 1241422 | MD | school | 2400420 | 13 | Howard | 240042000732 | 405 | Glenwood Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 185 | 185 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1237237 | 1237237 | MD | school | 2400030 | 1 | Allegany | 240003000031 | 406 | Washington Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 203 | 203 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245243 | 1245243 | MD | school | 2400690 | 22 | Wicomico | 240069001312 | 406 | Pittsville Elementary & Middle | Regular School | No | Middle | 04 | 08 | 2020 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1244643 | 1244643 | MD | school | 2400540 | 17 | Queen Anne's | 240054001644 | 407 | Matapeake Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 117 | 117 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1242285 | 1242285 | MD | school | 2400480 | 15 | Montgomery | 240048000949 | 412 | Westland Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 271 | 271 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1242289 | 1242289 | MD | school | 2400480 | 15 | Montgomery | 240048001118 | 413 | North Bethesda Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 401 | 401 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246753 | 1246753 | MD | school | 2400090 | 30 | Baltimore City | 240009001339 | 421 | National Academy Foundation | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 56 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246766 | 1246766 | MD | school | 2400090 | 30 | Baltimore City | 240009001381 | 427 | Academy for College and Career Exploration | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 49 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1242344 | 1242344 | MD | school | 2400480 | 15 | Montgomery | 240048009000 | 428 | Thomas W. Pyle Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 568 | 568 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1238595 | 1238595 | MD | school | 2400120 | 3 | Baltimore County | 240012000389 | 451 | Franklin Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 414 | 414 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245030 | 1245030 | MD | school | 2400660 | 21 | Washington | 240066001270 | 501 | Hancock Middle Senior High | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 35 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240069 | 1240069 | MD | school | 2400270 | 8 | Charles | 240027000604 | 503 | Piccowaxen Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 153 | 153 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1237249 | 1237249 | MD | school | 2400030 | 1 | Allegany | 240003000006 | 504 | Braddock Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 198 | 198 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239629 | 1239629 | MD | school | 2400210 | 6 | Carroll | 240021000547 | 504 | Sykesville Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 266 | 266 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239924 | 1239924 | MD | school | 2400240 | 7 | Cecil | 240024000574 | 504 | North East Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 266 | 266 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1242390 | 1242390 | MD | school | 2400480 | 15 | Montgomery | 240048000957 | 507 | William H. Farquhar Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 240 | 240 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239653 | 1239653 | MD | school | 2400210 | 6 | Carroll | 240021000835 | 508 | Oklahoma Road Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 251 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240306 | 1240306 | MD | school | 2400300 | 9 | Dorchester | 240030000622 | 508 | South Dorchester School | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 25 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1243256 | 1243256 | MD | school | 2400510 | 16 | Prince George's | 240051001686 | 509 | Accokeek Academy | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 284 | 284 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245247 | 1245247 | MD | school | 2400690 | 22 | Wicomico | 240069001319 | 510 | Wicomico Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 283 | 283 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241461 | 1241461 | MD | school | 2400420 | 13 | Howard | 240042000763 | 512 | Wilde Lake Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 217 | 217 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241494 | 1241494 | MD | school | 2400420 | 13 | Howard | 240042000737 | 518 | Harpers Choice Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 141 | 141 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241505 | 1241505 | MD | school | 2400420 | 13 | Howard | 240042000725 | 521 | Clarksville Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 226 | 226 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1242451 | 1242451 | MD | school | 2400480 | 15 | Montgomery | 240048001127 | 521 | Shady Grove Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 203 | 203 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241516 | 1241516 | MD | school | 2400420 | 13 | Howard | 240042001415 | 522 | Cedar Lane Special Center | Special Education School | No | Other | PK | 12 | 2020 | grade_7 | 12 | 12 |
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]);