enrollments
Data source: Big Local News · About: Big Local
733 rows where grade = "grade_7" and state = "MD" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1240412 | 1240412 | MD | school | 2400330 | 10 | Frederick | 240033001413 | 219 | Monocacy Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 320 | 320 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1312958 | 1312958 | MD | school | 2400330 | 10 | Frederick | 240033001413 | 219 | Monocacy Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 332 | 332 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246130 | 1246130 | MD | school | 2400090 | 30 | Baltimore City | 240009000284 | 220 | Morrell Park Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 55 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318690 | 1318690 | MD | school | 2400090 | 30 | Baltimore City | 240009000284 | 220 | Morrell Park Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 68 | 68 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246140 | 1246140 | MD | school | 2400090 | 30 | Baltimore City | 240009000286 | 221 | The Mount Washington School | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 78 | 78 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318700 | 1318700 | MD | school | 2400090 | 30 | Baltimore City | 240009000286 | 221 | The Mount Washington School | Regular School | No | Elementary | KG | 08 | 2021 | grade_7 | 56 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246151 | 1246151 | MD | school | 2400090 | 30 | Baltimore City | 240009000299 | 223 | Pimlico Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 98 | 98 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318711 | 1318711 | MD | school | 2400090 | 30 | Baltimore City | 240009000299 | 223 | Pimlico Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 139 | 139 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240432 | 1240432 | MD | school | 2400330 | 10 | Frederick | 240033001549 | 225 | Gov. Thomas Johnson Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 182 | 182 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246162 | 1246162 | MD | school | 2400090 | 30 | Baltimore City | 240009000331 | 225 | Westport Academy | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 36 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1312978 | 1312978 | MD | school | 2400330 | 10 | Frederick | 240033001549 | 225 | Gov. Thomas Johnson Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 197 | 197 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318722 | 1318722 | MD | school | 2400090 | 30 | Baltimore City | 240009000331 | 225 | Westport Academy | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 32 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240443 | 1240443 | MD | school | 2400330 | 10 | Frederick | 240033001187 | 226 | Monocacy Valley Montessori | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 27 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246173 | 1246173 | MD | school | 2400090 | 30 | Baltimore City | 240009000326 | 226 | Violetville Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 47 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1312989 | 1312989 | MD | school | 2400330 | 10 | Frederick | 240033001187 | 226 | Monocacy Valley Montessori | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_7 | 32 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318733 | 1318733 | MD | school | 2400090 | 30 | Baltimore City | 240009000326 | 226 | Violetville Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240447 | 1240447 | MD | school | 2400330 | 10 | Frederick | 240033001357 | 227 | Crestwood Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 230 | 230 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1312993 | 1312993 | MD | school | 2400330 | 10 | Frederick | 240033001357 | 227 | Crestwood Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 223 | 223 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240458 | 1240458 | MD | school | 2400330 | 10 | Frederick | 240033001712 | 228 | Carroll Creek Montessori Public Charter | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 33 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241972 | 1241972 | MD | school | 2400480 | 15 | Montgomery | 240048000849 | 228 | Herbert Hoover Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 354 | 354 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246184 | 1246184 | MD | school | 2400090 | 30 | Baltimore City | 240009000257 | 228 | John Ruhrah Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 80 | 80 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1313004 | 1313004 | MD | school | 2400330 | 10 | Frederick | 240033001712 | 228 | Carroll Creek Montessori Public Charter | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_7 | 31 | 31 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1314534 | 1314534 | MD | school | 2400480 | 15 | Montgomery | 240048000849 | 228 | Herbert Hoover Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 351 | 351 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318744 | 1318744 | MD | school | 2400090 | 30 | Baltimore City | 240009000257 | 228 | John Ruhrah Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 75 | 75 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246195 | 1246195 | MD | school | 2400090 | 30 | Baltimore City | 240009000247 | 229 | Holabird Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318755 | 1318755 | MD | school | 2400090 | 30 | Baltimore City | 240009000247 | 229 | Holabird Academy | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318766 | 1318766 | MD | school | 2400090 | 30 | Baltimore City | 240009000161 | 231 | The Belair-Edison School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_7 | 132 | 132 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241989 | 1241989 | MD | school | 2400480 | 15 | Montgomery | 240048001450 | 232 | Tilden Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 366 | 366 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1314551 | 1314551 | MD | school | 2400480 | 15 | Montgomery | 240048001450 | 232 | Tilden Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 317 | 317 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318777 | 1318777 | MD | school | 2400090 | 30 | Baltimore City | 240009000322 | 232 | Thomas Jefferson Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 50 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318788 | 1318788 | MD | school | 2400090 | 30 | Baltimore City | 240009000306 | 233 | Roland Park Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 233 | 233 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246245 | 1246245 | MD | school | 2400090 | 30 | Baltimore City | 240009000222 | 235 | Glenmount Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 78 | 78 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318807 | 1318807 | MD | school | 2400090 | 30 | Baltimore City | 240009000222 | 235 | Glenmount Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 83 | 83 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246256 | 1246256 | MD | school | 2400090 | 30 | Baltimore City | 240009000231 | 236 | Hamilton Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 125 | 125 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318818 | 1318818 | MD | school | 2400090 | 30 | Baltimore City | 240009000231 | 236 | Hamilton Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 137 | 137 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1314576 | 1314576 | MD | school | 2400480 | 15 | Montgomery | 240048001447 | 237 | Robert Frost Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 340 | 340 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318829 | 1318829 | MD | school | 2400090 | 30 | Baltimore City | 240009000244 | 237 | Highlandtown Elementary/Middle #237 | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 110 | 110 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318845 | 1318845 | MD | school | 2400090 | 30 | Baltimore City | 240009000224 | 240 | Graceland Park/O'Donnell Heights Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 50 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246294 | 1246294 | MD | school | 2400090 | 30 | Baltimore City | 240009000199 | 241 | Fallstaff Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 44 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318856 | 1318856 | MD | school | 2400090 | 30 | Baltimore City | 240009000199 | 241 | Fallstaff Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 77 | 77 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318875 | 1318875 | MD | school | 2400090 | 30 | Baltimore City | 240009000147 | 243 | Armistead Gardens Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 82 | 82 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318886 | 1318886 | MD | school | 2400090 | 30 | Baltimore City | 240009000268 | 245 | Leith Walk Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 116 | 116 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246335 | 1246335 | MD | school | 2400090 | 30 | Baltimore City | 240009000155 | 246 | Beechfield Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 87 | 87 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318897 | 1318897 | MD | school | 2400090 | 30 | Baltimore City | 240009000155 | 246 | Beechfield Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 64 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1314617 | 1314617 | MD | school | 2400480 | 15 | Montgomery | 240048000861 | 247 | John H. Poole Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 141 | 141 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318908 | 1318908 | MD | school | 2400090 | 30 | Baltimore City | 240009000182 | 247 | Cross Country Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 88 | 88 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1242063 | 1242063 | MD | school | 2400480 | 15 | Montgomery | 240048000644 | 248 | Forest Oak Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 304 | 304 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1314621 | 1314621 | MD | school | 2400480 | 15 | Montgomery | 240048000644 | 248 | Forest Oak Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 312 | 312 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1311007 | 1311007 | MD | school | 2400120 | 3 | Baltimore County | 240012001431 | 252 | Northwest Academy of Health Sciences | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 249 | 249 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1238456 | 1238456 | MD | school | 2400120 | 3 | Baltimore County | 240012000501 | 253 | Woodlawn Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 208 | 208 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1311011 | 1311011 | MD | school | 2400120 | 3 | Baltimore County | 240012000501 | 253 | Woodlawn Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 224 | 224 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1311015 | 1311015 | MD | school | 2400120 | 3 | Baltimore County | 240012000372 | 254 | Deer Park Middle Magnet School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 500 | 500 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1311019 | 1311019 | MD | school | 2400120 | 3 | Baltimore County | 240012001574 | 256 | Windsor Mill Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 240 | 240 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318951 | 1318951 | MD | school | 2400090 | 30 | Baltimore City | 240009001390 | 256 | Calvin M. Rodwell Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 93 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246427 | 1246427 | MD | school | 2400090 | 30 | Baltimore City | 240009001558 | 262 | Empowerment Academy | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 37 | 37 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318978 | 1318978 | MD | school | 2400090 | 30 | Baltimore City | 240009001558 | 262 | Empowerment Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_7 | 41 | 41 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240992 | 1240992 | MD | school | 2400390 | 12 | Harford | 240039000678 | 265 | Aberdeen Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 396 | 396 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1313545 | 1313545 | MD | school | 2400390 | 12 | Harford | 240039000678 | 265 | Aberdeen Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 402 | 402 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1313554 | 1313554 | MD | school | 2400390 | 12 | Harford | 240039000480 | 292 | Center for Educational Opportunity | Alternative School | No | High | 06 | 12 | 2021 | grade_7 | 11 | 11 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318989 | 1318989 | MD | school | 2400090 | 30 | Baltimore City | 240009000336 | 301 | William S. Baer School | Special Education School | No | Other | PK | 12 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1312080 | 1312080 | MD | school | 2400180 | 5 | Caroline | 240018000526 | 302 | Lockerman Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 321 | 321 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1312416 | 1312416 | MD | school | 2400240 | 7 | Cecil | 240024000567 | 303 | Elkton Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 192 | 192 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1317186 | 1317186 | MD | school | 2400540 | 17 | Queen Anne's | 240054001190 | 303 | Centreville Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 184 | 184 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1313945 | 1313945 | MD | school | 2400420 | 13 | Howard | 240042000403 | 304 | Mount View Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 286 | 286 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1317568 | 1317568 | MD | school | 2400660 | 21 | Washington | 240066001263 | 304 | E. Russell Hicks Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 293 | 293 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1244696 | 1244696 | MD | school | 2400600 | 18 | Saint Mary's | 240060001229 | 305 | Leonardtown Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 382 | 382 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1317274 | 1317274 | MD | school | 2400600 | 18 | Saint Mary's | 240060001229 | 305 | Leonardtown Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 308 | 308 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241408 | 1241408 | MD | school | 2400420 | 13 | Howard | 240042001552 | 307 | Folly Quarter Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 226 | 226 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1313963 | 1313963 | MD | school | 2400420 | 13 | Howard | 240042001552 | 307 | Folly Quarter Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 237 | 237 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1318996 | 1318996 | MD | school | 2400090 | 30 | Baltimore City | 240009000176 | 307 | Claremont School | Special Education School | No | High | 07 | 12 | 2021 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
1245394 | 1245394 | MD | school | 2400720 | 23 | Worcester | 240072000880 | 308 | Stephen Decatur Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 373 | 373 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1317970 | 1317970 | MD | school | 2400720 | 23 | Worcester | 240072000880 | 308 | Stephen Decatur Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 326 | 326 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1313012 | 1313012 | MD | school | 2400330 | 10 | Frederick | 240033000640 | 311 | Middletown Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 277 | 277 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1314691 | 1314691 | MD | school | 2400480 | 15 | Montgomery | 240048090453 | 311 | Francis Scott Key Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 339 | 339 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
1312436 | 1312436 | MD | school | 2400240 | 7 | Cecil | 240024000564 | 313 | Cherry Hill Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 131 | 131 |
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]);