enrollments

Data source: Big Local News · About: Big Local

19,213 rows where state = "MD" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
1312119 1312119 MD     school 2400180 5   Caroline 240018000519 802 Colonel Richardson Middle School   Regular School No Middle 06 08 2021   grade_8                                                   148                                             148
1312372 1312372 MD     school 2400210 6   Carroll 240021000538 1305 Mount Airy Elementary   Regular School No Elementary 03 05 2021   grade_3                                                   148                                             148
1312835 1312835 MD     school 2400300 9   Dorchester 240030000619 208 North Dorchester Middle School   Regular School No Middle 06 08 2021   grade_8                                                   148                                             148
1313560 1313560 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 06 12 2021   pk_12_total 79 48 *     *         14                             148 79 48                 14                       148
1316510 1316510 MD     school 2400510 16   Prince George's 240051001704 1350 Academy of Health Sciences at PGCC   Regular School No High 09 12 2021   grade_11                                                   148                                             148
1317097 1317097 MD     school 2400510 16   Prince George's 240051001160 2113 Springhill Lake Elementary   Regular School No Elementary KG 05 2021   grade_2                                                   148                                             148
1318995 1318995 MD     school 2400090 30   Baltimore City 240009000336 301 William S. Baer School   Special Education School No Other PK 12 2021   pk_12_total 14 112 20     *                                       148 14 112 20                                       148
1312038 1312038 MD     school 2400150 4   Calvert 240015000516 314 Northern High   Regular School No High 09 12 2021   pk_12_total 1096 166 87   * 33     *   94                             1483 1096 166 87     33         94                       1483
1239483 1239483 MD     school 2400150 4   Calvert 240015000516 314 Northern High   Regular School No High 09 12 2020   pk_12_total 1101 163 92   * 28     *   97                             1484 1101 163 92     28         97                       1484
1239826 1239826 MD     school 2400210 6   Carroll 240021000538 1305 Mount Airy Elementary   Regular School No Elementary 03 05 2020   grade_5                                                   149                                             149
1240068 1240068 MD     school 2400270 8   Charles 240027000604 503 Piccowaxen Middle School   Regular School No Middle 06 08 2020   grade_6                                                   149                                             149
1240286 1240286 MD     school 2400300 9   Dorchester 240030000619 208 North Dorchester Middle School   Regular School No Middle 06 08 2020   grade_6                                                   149                                             149
1240493 1240493 MD     school 2400330 10   Frederick 240033000659 603 Wolfsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 130 * *   *           *                             149 130                                           149
1241943 1241943 MD     school 2400480 15   Montgomery 240048000828 219 Farmland Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   149                                             149
1242610 1242610 MD     school 2400480 15   Montgomery 240048000818 570 Diamond Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   149                                             149
1243252 1243252 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2020   grade_3                                                   149                                             149
1244513 1244513 MD     school 2400510 16   Prince George's 240051001160 2113 Springhill Lake Elementary   Regular School No Elementary KG 05 2020   grade_5                                                   149                                             149
1244619 1244619 MD     school 2400540 17   Queen Anne's 240054001194 402 Kent Island Elementary School   Regular School No Elementary PK 02 2020   grade_2                                                   149                                             149
1245099 1245099 MD     school 2400660 21   Washington 240066000418 1002 Eastern Elementary   Regular School No Elementary 03 05 2020   grade_5                                                   149                                             149
1310513 1310513 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2021   pk_12_total 46 68 19     *     *   *                             149 46 68 19                                       149
1312437 1312437 MD     school 2400240 7   Cecil 240024000564 313 Cherry Hill Middle   Regular School No Middle 06 08 2021   grade_8                                                   149                                             149
1314256 1314256 MD     school 2400420 13   Howard 240042001032 625 Gorman Crossing Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   149                                             149
1315778 1315778 MD     school 2400510 16   Prince George's 240051001171 214 Templeton Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   149                                             149
1315781 1315781 MD     school 2400510 16   Prince George's 240051001171 214 Templeton Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   149                                             149
1317098 1317098 MD     school 2400510 16   Prince George's 240051001160 2113 Springhill Lake Elementary   Regular School No Elementary KG 05 2021   grade_3                                                   149                                             149
1311017 1311017 MD     school 2400120 3   Baltimore County 240012000372 254 Deer Park Middle Magnet School   Regular School No Middle 06 08 2021   pk_12_total 33 1297 88   * 34         38                             1495 33 1297 88     34         38                       1495
1243733 1243733 MD     school 2400510 16   Prince George's 240051001123 1209 Oxon Hill High   Regular School No High 09 12 2020   pk_12_total 31 859 451   * 114     *   31                             1497 31 859 451     114         31                       1497
1237976 1237976 MD     school 2400060 2   Anne Arundel 240006001729 4064 Mary Moss at Adams Academy   Alternative School No Middle 07 09 2020   grade_8                                                   15                                             15
1238145 1238145 MD     school 2400060 2   Anne Arundel 240006000056 4304 Central Special School   Special Education School No Other PK 12 2020   grade_11                                                   15                                             15
1238547 1238547 MD     school 2400120 3   Baltimore County 240012000361 404 Chatsworth School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   15                                             15
1238819 1238819 MD     school 2400120 3   Baltimore County 240012001435 923 White Oak School   Special Education School No Elementary PK 05 2020   kindergarten                                                   15                                             15
1238820 1238820 MD     school 2400120 3   Baltimore County 240012001435 923 White Oak School   Special Education School No Elementary PK 05 2020   grade_1                                                   15                                             15
1239496 1239496 MD     school 2400150 4   Calvert 240015000790 317 Windy Hill Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   15                                             15
1240298 1240298 MD     school 2400300 9   Dorchester 240030000622 508 South Dorchester School   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   15                                             15
1240781 1240781 MD     school 2400360 11   Garrett 240036000667 1202 Friendsville Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   15                                             15
1240839 1240839 MD     school 2400360 11   Garrett 240036000673 1904 Route 40 Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   15                                             15
1240841 1240841 MD     school 2400360 11   Garrett 240036000673 1904 Route 40 Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   15                                             15
1241002 1241002 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 08 12 2020   grade_10                                                   15                                             15
1241931 1241931 MD     school 2400480 15   Montgomery 240048000799 215 Carl Sandburg Center   Special Education School No Elementary KG 05 2020   grade_3                                                   15                                             15
1243115 1243115 MD     school 2400510 16   Prince George's 240051001354 108 James E. Duckworth Regional Center   Special Education School No Other KG 12 2020   grade_7                                                   15                                             15
1244573 1244573 MD     school 2400510 16   Prince George's 240051001755 2218 Career and Technical Education Evening High   Career and Technical School No Secondary 11 11 2020   grade_11                                                   15                                             15
1244574 1244574 MD     school 2400510 16   Prince George's 240051001755 2218 Career and Technical Education Evening High   Career and Technical School No Secondary 11 11 2020   pk_12_total   * 12   *           *                             15     12                                       15
1244935 1244935 MD     school 2400630 20   Talbot 240063001250 501 Tilghman Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   15                                             15
1245425 1245425 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   grade_12                                                   15                                             15
1245529 1245529 MD     school 2400090 30   Baltimore City 240009000220 22 George Washington Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   15                                             15
1246437 1246437 MD     school 2400090 30   Baltimore City 240009000336 301 William S. Baer School   Special Education School No Other PK 12 2020   grade_6                                                   15                                             15
1246478 1246478 MD     school 2400090 30   Baltimore City 240009000884 322 New Song Academy   Regular School No Elementary PK 08 2020   kindergarten                                                   15                                             15
1246479 1246479 MD     school 2400090 30   Baltimore City 240009000884 322 New Song Academy   Regular School No Elementary PK 08 2020   grade_1                                                   15                                             15
1309801 1309801 MD     school 2400030 1   Allegany 240003000024 502 Northeast Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   15                                             15
1310658 1310658 MD     school 2400060 2   Anne Arundel 240006000128 4242 Shady Side Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   15                                             15
1310755 1310755 MD     school 2400120 3   Baltimore County 240012001754 53 Northeast EDLP at Parkville High School   Alternative School No High 11 12 2021   pk_12_total * * *                                             15                                             15
1310776 1310776 MD     school 2400120 3   Baltimore County 240012000777 70 Meadowood Education Center   Alternative School No Middle 07 08 2021   pk_12_total * 12 *               *                             15   12                                         15
1310789 1310789 MD     school 2400120 3   Baltimore County 240012001649 75 Crossroads Center   Alternative School No High 07 12 2021   grade_12                                                   15                                             15
1311102 1311102 MD     school 2400120 3   Baltimore County 240012000361 404 Chatsworth School   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   15                                             15
1311302 1311302 MD     school 2400120 3   Baltimore County 240012000453 909 Pleasant Plains Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   15                                             15
1311870 1311870 MD     school 2400120 3   Baltimore County 240012001406 1534 Oliver Beach Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   15                                             15
1312138 1312138 MD     school 2400210 6   Carroll 240021000368 204 Runnymede Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   15                                             15
1312154 1312154 MD     school 2400210 6   Carroll 240021000537 406 Mechanicsville Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   15                                             15
1312300 1312300 MD     school 2400210 6   Carroll 240021001105 715 Cranberry Station Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   15                                             15
1312557 1312557 MD     school 2400240 7   Cecil 240024000559 904 Calvert Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   15                                             15
1313170 1313170 MD     school 2400330 10   Frederick 240033000653 1406 Valley Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   15                                             15
1313335 1313335 MD     school 2400360 11   Garrett 240036000667 1202 Friendsville Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   15                                             15
1313352 1313352 MD     school 2400360 11   Garrett 240036000665 1408 Crellin Elementary   Regular School No Elementary KG 05 2021   grade_4                                                   15                                             15
1313395 1313395 MD     school 2400360 11   Garrett 240036000673 1904 Route 40 Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   15                                             15
1313559 1313559 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 06 12 2021   grade_12                                                   15                                             15
1313716 1313716 MD     school 2400390 12   Harford 240039000685 518 Darlington Elementary   Regular School No Elementary KG 05 2021   grade_5                                                   15                                             15
1314158 1314158 MD     school 2400420 13   Howard 240042000754 608 Stevens Forest Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   15                                             15
1314488 1314488 MD     school 2400480 15   Montgomery 240048000799 215 Carl Sandburg Center   Special Education School No Elementary KG 05 2021   grade_1                                                   15                                             15
1314537 1314537 MD     school 2400480 15   Montgomery 240048000810 229 College Gardens Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   15                                             15
1314978 1314978 MD     school 2400480 15   Montgomery 240048000800 511 Cashell Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   15                                             15
1315766 1315766 MD     school 2400510 16   Prince George's 240051001014 213 Cooper Lane Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   15                                             15
1316120 1316120 MD     school 2400510 16   Prince George's 240051000973 802 Baden Elementary   Regular School No Elementary PK 06 2021   grade_3                                                   15                                             15
1316316 1316316 MD     school 2400510 16   Prince George's 240051001033 1213 Fort Foote Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   15                                             15
1316988 1316988 MD     school 2400510 16   Prince George's 240051001386 2007 Woodridge Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   15                                             15
1317151 1317151 MD     school 2400510 16   Prince George's 240051001755 2218 Career and Technical Education Evening High   Career and Technical School No High 11 12 2021   grade_12                                                   15                                             15
1317361 1317361 MD     school 2400600 18   Saint Mary's 240060001230 804 Lexington Park Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   15                                             15
1317453 1317453 MD     school 2400570 19   Somerset 240057001202 1401 Deal Island School   Regular School No Elementary PK 05 2021   grade_1                                                   15                                             15
1317513 1317513 MD     school 2400630 20   Talbot 240063001250 501 Tilghman Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   15                                             15
1318017 1318017 MD     school 2400090 30   Baltimore City 240009000319 4 Steuart Hill Academic Academy   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   15                                             15
1318151 1318151 MD     school 2400090 30   Baltimore City 240009000153 34 Charles Carroll Barrister Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   15                                             15
1318268 1318268 MD     school 2400090 30   Baltimore City 240009000149 58 Dr. Nathan A. Pitts-Ashburton Elementary/Middle   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   15                                             15
1318625 1318625 MD     school 2400090 30   Baltimore City 240009000213 212 Garrett Heights Elementary/Middle   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   15                                             15
1318655 1318655 MD     school 2400090 30   Baltimore City 240009000243 215 Highlandtown Elementary/Middle #215   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   15                                             15
1319028 1319028 MD     school 2400090 30   Baltimore City 240009000884 322 New Song Academy   Regular School Yes Elementary PK 08 2021   pre_kindergarten                                                   15                                             15
1319031 1319031 MD     school 2400090 30   Baltimore City 240009000884 322 New Song Academy   Regular School Yes Elementary PK 08 2021   grade_2                                                   15                                             15
1241861 1241861 MD     school 2400480 15   Montgomery 240048090455 158 Ronald McNair Elementary   Regular School No Elementary PK 05 2020   grade_3                                                   150                                             150
1241942 1241942 MD     school 2400480 15   Montgomery 240048000828 219 Farmland Elementary   Regular School No Elementary KG 05 2020   kindergarten                                                   150                                             150
1242574 1242574 MD     school 2400480 15   Montgomery 240048000924 564 South Lake Elementary   Regular School No Elementary PK 05 2020   grade_3                                                   150                                             150
1245124 1245124 MD     school 2400660 21   Washington 240066001258 1401 Cascade Elementary   Regular School No Elementary PK 05 2020   pk_12_total 139 * *     *         *                             150 139                                           150
1246728 1246728 MD     school 2400090 30   Baltimore City 240009000236 413 Achievement Academy at Harbor City High   Alternative School No High 09 12 2020   grade_10                                                   150                                             150
1312374 1312374 MD     school 2400210 6   Carroll 240021000538 1305 Mount Airy Elementary   Regular School No Elementary 03 05 2021   grade_5                                                   150                                             150
1312834 1312834 MD     school 2400300 9   Dorchester 240030000619 208 North Dorchester Middle School   Regular School No Middle 06 08 2021   grade_7                                                   150                                             150
1313623 1313623 MD     school 2400390 12   Harford 240039000701 335 Homestead/Wakefield Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   150                                             150
1314174 1314174 MD     school 2400420 13   Howard 240042000746 610 Oakland Mills Middle   Regular School No Middle 06 08 2021   grade_6                                                   150                                             150
1314269 1314269 MD     school 2400450 14   Kent 240045000768 301 Kent County High   Regular School No High 09 12 2021   grade_10                                                   150                                             150
1315440 1315440 MD     school 2400480 15   Montgomery 240048000780 780 Bel Pre Elementary   Regular School No Elementary PK 02 2021   kindergarten                                                   150                                             150
1315852 1315852 MD     school 2400510 16   Prince George's 240051001038 511 Friendly High   Regular School No High 09 12 2021   grade_12                                                   150                                             150
1316865 1316865 MD     school 2400510 16   Prince George's 240051001002 1810 Central High   Regular School No High 09 12 2021   grade_11                                                   150                                             150
1317099 1317099 MD     school 2400510 16   Prince George's 240051001160 2113 Springhill Lake Elementary   Regular School No Elementary KG 05 2021   grade_4                                                   150                                             150
1319241 1319241 MD     school 2400090 30   Baltimore City 240009001752 385 Baltimore International Academy West   Regular School Yes Elementary KG 07 2021   pk_12_total * 143 *               *                             150   143                                         150

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);