enrollments
Data source: Big Local News · About: Big Local
367 rows where grade = "grade_7", state = "MD" and year = 2020 sorted by total_int
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1245821 | 1245821 | MD | school | 2400090 | 30 | Baltimore City | 240009000323 | 84 | Thomas Johnson Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 63 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245678 | 1245678 | MD | school | 2400090 | 30 | Baltimore City | 240009000152 | 54 | Barclay Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 64 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1243430 | 1243430 | MD | school | 2400510 | 16 | Prince George's | 240051001555 | 648 | Samuel P. Massie Academy | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 65 | 65 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246054 | 1246054 | MD | school | 2400090 | 30 | Baltimore City | 240009000241 | 210 | Hazelwood Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 68 | 68 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245374 | 1245374 | MD | school | 2400720 | 23 | Worcester | 240072001329 | 108 | Pocomoke Middle | Regular School | No | Middle | 04 | 08 | 2020 | grade_7 | 71 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246815 | 1246815 | MD | school | 2400027 | 32 | SEED | 240002701669 | 1000 | The Seed School of Maryland | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 73 | 73 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245917 | 1245917 | MD | school | 2400090 | 30 | Baltimore City | 240009000160 | 130 | Booker T. Washington Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 75 | 75 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1238166 | 1238166 | MD | school | 2400060 | 2 | Anne Arundel | 240006001401 | 6223 | Chesapeake Science Point | Regular School | Yes | High | 06 | 12 | 2020 | grade_7 | 76 | 76 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246245 | 1246245 | MD | school | 2400090 | 30 | Baltimore City | 240009000222 | 235 | Glenmount Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 78 | 78 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245391 | 1245391 | MD | school | 2400720 | 23 | Worcester | 240072001333 | 208 | Snow Hill Middle | Regular School | No | Middle | 04 | 08 | 2020 | grade_7 | 79 | 79 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1238180 | 1238180 | MD | school | 2400060 | 2 | Anne Arundel | 240006001687 | 6233 | Monarch Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_7 | 81 | 81 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246680 | 1246680 | MD | school | 2400090 | 30 | Baltimore City | 240009001703 | 382 | Baltimore Design School | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 81 | 81 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245656 | 1245656 | MD | school | 2400090 | 30 | Baltimore City | 240009000329 | 51 | Waverly Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 82 | 82 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1243381 | 1243381 | MD | school | 2400510 | 16 | Prince George's | 240051001684 | 638 | Benjamin D. Foulois Academy | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 84 | 84 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245465 | 1245465 | MD | school | 2400090 | 30 | Baltimore City | 240009000175 | 8 | City Springs Elementary/Middle | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 84 | 84 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1237293 | 1237293 | MD | school | 2400030 | 1 | Allegany | 240003000007 | 802 | Westmar Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 86 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245637 | 1245637 | MD | school | 2400090 | 30 | Baltimore City | 240009000234 | 47 | Hampstead Hill Academy | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 86 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245856 | 1245856 | MD | school | 2400090 | 30 | Baltimore City | 240009000273 | 88 | Wildwood Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 86 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246335 | 1246335 | MD | school | 2400090 | 30 | Baltimore City | 240009000155 | 246 | Beechfield Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 87 | 87 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245618 | 1245618 | MD | school | 2400090 | 30 | Baltimore City | 240009000281 | 44 | Montebello Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 89 | 89 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245831 | 1245831 | MD | school | 2400090 | 30 | Baltimore City | 240009000204 | 85 | Fort Worthington Elementary/Middle | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 90 | 90 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245791 | 1245791 | MD | school | 2400090 | 30 | Baltimore City | 240009000205 | 76 | Francis Scott Key Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 91 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245243 | 1245243 | MD | school | 2400690 | 22 | Wicomico | 240069001312 | 406 | Pittsville Elementary & Middle | Regular School | No | Middle | 04 | 08 | 2020 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245780 | 1245780 | MD | school | 2400090 | 30 | Baltimore City | 240009000164 | 75 | Calverton Elementary/Middle | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 95 | 95 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245495 | 1245495 | MD | school | 2400090 | 30 | Baltimore City | 240009000264 | 12 | Lakeland Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 97 | 97 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246005 | 1246005 | MD | school | 2400090 | 30 | Baltimore City | 240009001363 | 203 | Maree Garnett Farring Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 97 | 97 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245225 | 1245225 | MD | school | 2400690 | 22 | Wicomico | 240069001306 | 102 | Mardela Middle & High | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 98 | 98 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246151 | 1246151 | MD | school | 2400090 | 30 | Baltimore City | 240009000299 | 223 | Pimlico Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 98 | 98 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245553 | 1245553 | MD | school | 2400090 | 30 | Baltimore City | 240009000180 | 27 | Commodore John Rogers Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1238155 | 1238155 | MD | school | 2400060 | 2 | Anne Arundel | 240006001724 | 6113 | Monarch Global Academy PCS Laurel Campus | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 101 | 101 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1244310 | 1244310 | MD | school | 2400510 | 16 | Prince George's | 240051001174 | 1814 | Thomas G. Pullen School | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 101 | 101 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1242059 | 1242059 | MD | school | 2400480 | 15 | Montgomery | 240048000861 | 247 | John H. Poole Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 115 | 115 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245013 | 1245013 | MD | school | 2400660 | 21 | Washington | 240066001261 | 401 | Clear Spring Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 115 | 115 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245967 | 1245967 | MD | school | 2400090 | 30 | Baltimore City | 240009000171 | 159 | The Historic Cherry Hill Elementary/Middle | Regular School | No | Middle | 03 | 08 | 2020 | grade_7 | 120 | 120 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241717 | 1241717 | MD | school | 2400450 | 14 | Kent | 240045000766 | 402 | Kent County Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 121 | 121 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240845 | 1240845 | MD | school | 2400360 | 11 | Garrett | 240036001351 | 2511 | Northern Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 122 | 122 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246657 | 1246657 | MD | school | 2400090 | 30 | Baltimore City | 240009001693 | 374 | Vanguard Collegiate Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 124 | 124 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246256 | 1246256 | MD | school | 2400090 | 30 | Baltimore City | 240009000231 | 236 | Hamilton Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 125 | 125 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246672 | 1246672 | MD | school | 2400090 | 30 | Baltimore City | 240009001691 | 377 | Green Street Academy | Regular School | Yes | High | 06 | 12 | 2020 | grade_7 | 125 | 125 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1237313 | 1237313 | MD | school | 2400030 | 1 | Allegany | 240003000023 | 1301 | Mount Savage Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 129 | 129 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1244581 | 1244581 | MD | school | 2400540 | 17 | Queen Anne's | 240054001198 | 101 | Sudlersville Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 131 | 131 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1243095 | 1243095 | MD | school | 2400510 | 16 | Prince George's | 240051000978 | 104 | Beltsville Academy | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 135 | 135 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1244551 | 1244551 | MD | school | 2400510 | 16 | Prince George's | 240051001718 | 2142 | College Park Academy | Regular School | Yes | High | 06 | 12 | 2020 | grade_7 | 140 | 140 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241494 | 1241494 | MD | school | 2400420 | 13 | Howard | 240042000737 | 518 | Harpers Choice Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 141 | 141 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245510 | 1245510 | MD | school | 2400090 | 30 | Baltimore City | 240009000571 | 15 | Stadium School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 142 | 142 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245754 | 1245754 | MD | school | 2400090 | 30 | Baltimore City | 240009000285 | 66 | Mount Royal Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 143 | 143 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240287 | 1240287 | MD | school | 2400300 | 9 | Dorchester | 240030000619 | 208 | North Dorchester Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 147 | 147 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240069 | 1240069 | MD | school | 2400270 | 8 | Charles | 240027000604 | 503 | Piccowaxen Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 153 | 153 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239568 | 1239568 | MD | school | 2400180 | 5 | Caroline | 240018000519 | 802 | Colonel Richardson Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 155 | 155 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239888 | 1239888 | MD | school | 2400240 | 7 | Cecil | 240024000564 | 313 | Cherry Hill Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 156 | 156 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239374 | 1239374 | MD | school | 2400150 | 4 | Calvert | 240015001392 | 111 | Southern Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 158 | 158 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241619 | 1241619 | MD | school | 2400420 | 13 | Howard | 240042000746 | 610 | Oakland Mills Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 166 | 166 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239399 | 1239399 | MD | school | 2400150 | 4 | Calvert | 240015002946 | 116 | Mill Creek Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 168 | 168 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1243656 | 1243656 | MD | school | 2400510 | 16 | Prince George's | 240051001708 | 1015 | Chesapeake Math and IT Public Charter | Regular School | Yes | Other | KG | 12 | 2020 | grade_7 | 168 | 168 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1243940 | 1243940 | MD | school | 2400510 | 16 | Prince George's | 240051001726 | 1351 | Chesapeake Math and IT South Public Charter | Regular School | Yes | Other | KG | 12 | 2020 | grade_7 | 168 | 168 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239859 | 1239859 | MD | school | 2400240 | 7 | Cecil | 240024000791 | 206 | Bohemia Manor Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 169 | 169 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240220 | 1240220 | MD | school | 2400270 | 8 | Charles | 240027000589 | 705 | General Smallwood Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 175 | 175 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240849 | 1240849 | MD | school | 2400360 | 11 | Garrett | 240036000675 | 2708 | Southern Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 175 | 175 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240432 | 1240432 | MD | school | 2400330 | 10 | Frederick | 240033001549 | 225 | Gov. Thomas Johnson Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 182 | 182 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241422 | 1241422 | MD | school | 2400420 | 13 | Howard | 240042000732 | 405 | Glenwood Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 185 | 185 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240635 | 1240635 | MD | school | 2400330 | 10 | Frederick | 240033000651 | 1510 | Thurmont Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 186 | 186 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239868 | 1239868 | MD | school | 2400240 | 7 | Cecil | 240024000567 | 303 | Elkton Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 188 | 188 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1246598 | 1246598 | MD | school | 2400090 | 30 | Baltimore City | 240009001681 | 347 | KIPP Harmony Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_7 | 188 | 188 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241216 | 1241216 | MD | school | 2400390 | 12 | Harford | 240039000696 | 679 | Havre de Grace Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 189 | 189 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239403 | 1239403 | MD | school | 2400150 | 4 | Calvert | 240015000507 | 201 | Calvert Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 195 | 195 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240310 | 1240310 | MD | school | 2400300 | 9 | Dorchester | 240030001423 | 707 | Mace's Lane Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 195 | 195 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1244874 | 1244874 | MD | school | 2400570 | 19 | Somerset | 240057001377 | 1303 | Somerset 6/7 Intermediate School | Regular School | No | Middle | 06 | 07 | 2020 | grade_7 | 196 | 196 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1237249 | 1237249 | MD | school | 2400030 | 1 | Allegany | 240003000006 | 504 | Braddock Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 198 | 198 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239977 | 1239977 | MD | school | 2400240 | 7 | Cecil | 240024000578 | 701 | Perryville Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 198 | 198 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1237968 | 1237968 | MD | school | 2400060 | 2 | Anne Arundel | 240006000041 | 4043 | Wiley H. Bates Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 199 | 199 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241651 | 1241651 | MD | school | 2400420 | 13 | Howard | 240042001700 | 617 | Lake Elkhorn Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 200 | 200 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1240550 | 1240550 | MD | school | 2400330 | 10 | Frederick | 240033001379 | 914 | New Market Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 201 | 201 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1237237 | 1237237 | MD | school | 2400030 | 1 | Allegany | 240003000031 | 406 | Washington Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 203 | 203 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1242451 | 1242451 | MD | school | 2400480 | 15 | Montgomery | 240048001127 | 521 | Shady Grove Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 203 | 203 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1245076 | 1245076 | MD | school | 2400660 | 21 | Washington | 240066001287 | 704 | Smithsburg Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 207 | 207 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1238456 | 1238456 | MD | school | 2400120 | 3 | Baltimore County | 240012000501 | 253 | Woodlawn Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 208 | 208 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239776 | 1239776 | MD | school | 2400210 | 6 | Carroll | 240021000542 | 801 | North Carroll Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 209 | 209 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1237363 | 1237363 | MD | school | 2400060 | 2 | Anne Arundel | 240006000059 | 1043 | Corkran Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 211 | 211 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239456 | 1239456 | MD | school | 2400150 | 4 | Calvert | 240015000027 | 216 | Plum Point Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 214 | 214 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239796 | 1239796 | MD | school | 2400210 | 6 | Carroll | 240021002947 | 807 | Shiloh Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 214 | 214 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1239829 | 1239829 | MD | school | 2400210 | 6 | Carroll | 240021000539 | 1306 | Mount Airy Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 215 | 215 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241331 | 1241331 | MD | school | 2400420 | 13 | Howard | 240042000727 | 211 | Dunloggin Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 215 | 215 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241461 | 1241461 | MD | school | 2400420 | 13 | Howard | 240042000763 | 512 | Wilde Lake Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 217 | 217 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1242559 | 1242559 | MD | school | 2400480 | 15 | Montgomery | 240048000901 | 562 | Redland Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 219 | 219 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
1241599 | 1241599 | MD | school | 2400420 | 13 | Howard | 240042000736 | 607 | Hammond Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 221 | 221 |
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]);