Data source: Big Local News · About: Big Local

9,598 rows where state = "MD" and year = 2021 sorted by black_int

View and edit SQL

year

  • 2021 · 9,598
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
1309775 MD     school 2400030 1   Allegany 240003000014 301 Flintstone Elementary   Regular School No Elementary PK 05 2021   pk_12_total 193 * *               *                             205 193                                           205
1309815 MD     school 2400030 1   Allegany 240003000030 601 Center for Career & Technical Education   Career and Technical School No High 11 12 2021   pk_12_total 245 * *   *           *                             258 245                                           258
1309836 MD     school 2400030 1   Allegany 240003000010 701 Cresaptown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 251 * *   * *     *   17                             287 251                   17                       287
1309852 MD     school 2400030 1   Allegany 240003000033 801 Westernport Elementary   Regular School No Elementary PK 05 2021   pk_12_total 239 * *           *   10                             256 239                   10                       256
1309876 MD     school 2400030 1   Allegany 240003000023 1301 Mount Savage Middle   Regular School No Middle 06 08 2021   pk_12_total 355 * *   * *     *   13                             383 355                   13                       383
1309884 MD     school 2400030 1   Allegany 240003001546 1302 Mt. Savage Elementary   Regular School No Elementary PK 05 2021   pk_12_total 181 * *   *           *                             186 181                                           186
1309897 MD     school 2400030 1   Allegany 240003000003 2801 Beall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 384 * *   * *         41                             445 384                   41                       445
1310122 MD     school 2400060 2   Anne Arundel 240006000045 2072 Benfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 334 * 23   * *         23                             392 334   23               23                       392
1310129 MD     school 2400060 2   Anne Arundel 240006000046 2082 Bodkin Elementary   Regular School No Elementary KG 05 2021   pk_12_total 423 * 33     *         19                             483 423   33               19                       483
1310182 MD     school 2400060 2   Anne Arundel 240006000085 2162 Lake Shore Elementary   Regular School No Elementary PK 05 2021   pk_12_total 275 * 19               21                             317 275   19               21                       317
1310204 MD     school 2400060 2   Anne Arundel 240006000121 2192 Riviera Beach Elementary   Regular School No Elementary PK 05 2021   pk_12_total 224 * 15   * 12         19                             280 224   15     12         19                       280
1310211 MD     school 2400060 2   Anne Arundel 240006000125 2202 Severna Park Elementary   Regular School No Elementary KG 05 2021   pk_12_total 333 * 17   * 22         17                             392 333   17     22         17                       392
1310275 MD     school 2400060 2   Anne Arundel 240006001421 2432 Shipley's Choice Elementary   Regular School No Elementary KG 05 2021   pk_12_total 320 * *     13         23                             369 320         13         23                       369
1310566 MD     school 2400060 2   Anne Arundel 240006001746 4102 Carrie Weedon Early Education Center   Regular School No Prekindergarten PK PK 2021   pk_12_total 33 * 21               *                             62 33   21                                       62
1310587 MD     school 2400060 2   Anne Arundel 240006000063 4132 Deale Elementary   Regular School No Elementary KG 05 2021   pk_12_total 172 * 18     *         *                             209 172   18                                       209
1310641 MD     school 2400060 2   Anne Arundel 240006000097 4212 Mayo Elementary   Regular School No Elementary KG 05 2021   pk_12_total 286 * 39     *         18                             353 286   39               18                       353
1310749 MD     school 2400120 3   Baltimore County 240012001756 51 Northwest EDLP at Milford Mill Academy   Alternative School No High 10 12 2021   pk_12_total   *                                               *                                              
1310752 MD     school 2400120 3   Baltimore County 240012001751 52 Southwest EDLP at Woodlawn High School   Alternative School No High 11 12 2021   pk_12_total * * *                                             *                                              
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
1310758 MD     school 2400120 3   Baltimore County 240012001759 55 Southeast EDLP at Dundalk High School   Alternative School No High 10 12 2021   pk_12_total * * *                                             *                                              
1310765 MD     school 2400120 3   Baltimore County 240012000935 58 Home Assignments-Secondary   Alternative School No High 08 12 2021   pk_12_total * *                                               12                                             12
1311174 MD     school 2400120 3   Baltimore County 240012000386 501 Fifth District Elementary   Regular School No Elementary KG 05 2021   pk_12_total 247 * 19   * *         12                             281 247   19               12                       281
1311181 MD     school 2400120 3   Baltimore County 240012000456 601 Prettyboy Elementary   Regular School No Elementary KG 05 2021   pk_12_total 360 * *     *         *                             385 360                                           385
1311189 MD     school 2400120 3   Baltimore County 240012000473 701 Seventh District Elementary   Regular School No Elementary PK 05 2021   pk_12_total 295 * 14   * *         18                             337 295   14               18                       337
1311293 MD     school 2400120 3   Baltimore County 240012000465 907 Rodgers Forge Elementary   Regular School No Elementary KG 05 2021   pk_12_total 298 * 26     33     *   25                             392 298   26     33         25                       392
1311426 MD     school 2400120 3   Baltimore County 240012000352 1001 Carroll Manor Elementary   Regular School No Elementary KG 05 2021   pk_12_total 309 * 14     *         15                             351 309   14               15                       351
1311433 MD     school 2400120 3   Baltimore County 240012000467 1002 Jacksonville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 411 * 20     22         20                             480 411   20     22         20                       480
1311440 MD     school 2400120 3   Baltimore County 240012000413 1104 Kingsville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 242 * *     *     *   *                             272 242                                           272
1311773 MD     school 2400120 3   Baltimore County 240012000363 1511 Chesapeake Terrace Elementary   Regular School No Elementary PK 05 2021   pk_12_total 253 * *   * *         *                             273 253                                           273
1311876 MD     school 2400120 3   Baltimore County 240012001406 1534 Oliver Beach Elementary   Regular School No Elementary PK 05 2021   pk_12_total 147 * *     *         14                             168 147                   14                       168
1311972 MD     school 2400150 4   Calvert 240015000509 206 Calvert Country School   Special Education School No Other 03 12 2021   pk_12_total 23 *     * *         *                             38 23                                           38
1312292 MD     school 2400210 6   Carroll 240021000527 712 Carroll Springs School   Special Education School No Other 01 12 2021   pk_12_total 25 * *                                             28 25                                           28
1312312 MD     school 2400210 6   Carroll 240021001548 716 Gateway School   Alternative School No High 09 12 2021   pk_12_total 42 * *   * *         *                             51 42                                           51
1312314 MD     school 2400210 6   Carroll 240021001348 717 Post Secondary Program   Alternative School No High 12 12 2021   pk_12_total 40 * *     *         *                             50 40                                           50
1312318 MD     school 2400210 6   Carroll 240021001349 718 PRIDE School   Alternative School No Elementary 01 05 2021   pk_12_total * * *                                             *                                              
1312350 MD     school 2400210 6   Carroll 240021001350 903 Flexible Student Support   Alternative School No High 09 12 2021   pk_12_total 28 *                                               32 28                                           32
1312366 MD     school 2400210 6   Carroll 240021000532 1201 Elmer A. Wolfe Elementary   Regular School No Elementary PK 05 2021   pk_12_total 379 * 11   * *         18                             416 379   11               18                       416
1312405 MD     school 2400240 7   Cecil 240024000565 205 Chesapeake City Elementary   Regular School No Elementary PK 05 2021   pk_12_total 309 * 21               15                             349 309   21               15                       349
1312446 MD     school 2400240 7   Cecil 240024000572 315 Leeds Elementary   Regular School No Elementary PK 05 2021   pk_12_total 300 * 19               25                             350 300   19               25                       350
1312515 MD     school 2400240 7   Cecil 240024000580 606 Rising Sun Middle School   Regular School No Middle 06 08 2021   pk_12_total 618 * 42   * *         20                             685 618   42               20                       685
1312523 MD     school 2400240 7   Cecil 240024000579 607 Rising Sun Elementary   Regular School No Elementary PK 05 2021   pk_12_total 562 * 41   * *         23                             634 562   41               23                       634
1312556 MD     school 2400240 7   Cecil 240024000566 801 Conowingo Elementary   Regular School No Elementary PK 05 2021   pk_12_total 373 * 14   *           10                             407 373   14               10                       407
1312569 MD     school 2400240 7   Cecil 240024090469 905 Rising Sun High   Regular School No High 09 12 2021   pk_12_total 972 * 58   * *         27                             1076 972   58               27                       1076
1312855 MD     school 2400300 9   Dorchester 240030000622 508 South Dorchester School   Regular School No Elementary PK 08 2021   pk_12_total 189 * 10     *     *   11                             219 189   10               11                       219
1313032 MD     school 2400330 10   Frederick 240033000631 503 Emmitsburg Elementary   Regular School No Elementary PK 05 2021   pk_12_total 177 * *     *         12                             201 177                   12                       201
1313039 MD     school 2400330 10   Frederick 240033000659 603 Wolfsville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 105 * *               *                             123 105                                           123
1313081 MD     school 2400330 10   Frederick 240033000637 801 Liberty Elementary   Regular School No Elementary KG 05 2021   pk_12_total 172 * 16   * *         17                             215 172   16               17                       215
1313151 MD     school 2400330 10   Frederick 240033000648 1001 Sabillasville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 60 * *               *                             70 60                                           70
1313159 MD     school 2400330 10   Frederick 240033001442 1105 New Midway/Woodsboro Elementary   Regular School No Elementary PK 05 2021   pk_12_total 245 * 16               20                             287 245   16               20                       287
1313186 MD     school 2400330 10   Frederick 240033000629 1509 Catoctin High   Regular School No High 09 12 2021   pk_12_total 642 * 41   * *     *   19                             719 642   41               19                       719
1313190 MD     school 2400330 10   Frederick 240033000651 1510 Thurmont Middle   Regular School No Middle 06 08 2021   pk_12_total 514 * 30     *         20                             573 514   30               20                       573
1313218 MD     school 2400330 10   Frederick 240033000636 2001 Lewistown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 120 * 26               *                             161 120   26                                       161
1313370 MD     school 2400360 11   Garrett 240036000664 1707 Broad Ford Elementary   Regular School No Elementary PK 05 2021   pk_12_total 539 * *     *         *                             561 539                                           561
1313404 MD     school 2400360 11   Garrett 240036000675 2708 Southern Middle School   Regular School No Middle 06 08 2021   pk_12_total 447 * *     *         11                             468 447                   11                       468
1313414 MD     school 2400360 11   Garrett 240036000674 3709 Southern Garrett High School   Regular School No High 09 12 2021   pk_12_total 653 * *     *         16                             678 653                   16                       678
1313695 MD     school 2400390 12   Harford 240039000702 436 Jarrettsville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 383 * 17           *   18                             426 383   17               18                       426
1313710 MD     school 2400390 12   Harford 240039090476 447 North Bend Elementary   Regular School No Elementary PK 05 2021   pk_12_total 338 * 12     *         19                             378 338   12               19                       378
1313717 MD     school 2400390 12   Harford 240039000685 518 Darlington Elementary   Regular School No Elementary KG 05 2021   pk_12_total 80 * *     *         *                             98 80                                           98
1313725 MD     school 2400390 12   Harford 240039000687 522 Dublin Elementary   Regular School No Elementary PK 05 2021   pk_12_total 192 * *               12                             215 192                   12                       215
1313732 MD     school 2400390 12   Harford 240039001443 544 North Harford Elementary   Regular School No Elementary KG 05 2021   pk_12_total 310 * *     *         12                             331 310                   12                       331
1313741 MD     school 2400390 12   Harford 240039000709 583 North Harford Middle   Regular School No Middle 06 08 2021   pk_12_total 788 * 29   * *     *   37                             878 788   29               37                       878
1313994 MD     school 2400420 13   Howard 240042000741 407 Lisbon Elementary   Regular School No Elementary KG 05 2021   pk_12_total 301 * 40     14         19                             377 301   40     14         19                       377
1314842 MD     school 2400480 15   Montgomery 240048000948 408 Westbrook Elementary   Regular School No Elementary PK 05 2021   pk_12_total 234 * 48   * 18         20                             331 234   48     18         20                       331
1315194 MD     school 2400480 15   Montgomery 240048001635 587 PEP - Itinerant   Special Education School No Prekindergarten PK PK 2021   pk_12_total 14 * *     *         *                             40 14                                           40
1315245 MD     school 2400480 15   Montgomery 240048000876 652 Monocacy Elementary   Regular School No Elementary PK 05 2021   pk_12_total 95 * 21     *         *                             136 95   21                                       136
1317149 MD     school   16   Prince George's   2217 Incarcerated Youth Center (JACS)             2021   pk_12_total   * *               *                             11                                             11
1317152 MD     school 2400510 16   Prince George's 240051001755 2218 Career and Technical Education Evening High   Career and Technical School No High 11 12 2021   pk_12_total   * 21   *           *                             27     21                                       27
1317156 MD     school 2400510 16   Prince George's 240051001476 2300 Prekindergarten Offsites   Regular School No Prekindergarten PK PK 2021   pk_12_total * * *                                             *                                              
1317198 MD     school 2400540 17   Queen Anne's 240054001194 402 Kent Island Elementary School   Regular School No Elementary PK 02 2021   pk_12_total 302 * 30   * *         22                             370 302   30               22                       370
1317219 MD     school 2400540 17   Queen Anne's 240054001557 406 Matapeake Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 358 * 22     *         24                             415 358   22               24                       415
1317458 MD     school 2400570 19   Somerset 240057001202 1401 Deal Island School   Regular School No Elementary PK 05 2021   pk_12_total 98 * *     *         *                             121 98                                           121
1317507 MD     school 2400630 20   Talbot 240063001241 401 Chapel District Elementary   Regular School No Elementary PK 05 2021   pk_12_total 278 * 25     *         20                             335 278   25               20                       335
1317528 MD     school 2400660 21   Washington 240066001284 101 Sharpsburg Elementary   Regular School No Elementary PK 05 2021   pk_12_total 296 * *               *                             308 296                                           308
1317590 MD     school 2400660 21   Washington 240066001261 401 Clear Spring Middle   Regular School No Middle 06 08 2021   pk_12_total 307 * 12     *         13                             340 307   12               13                       340
1317598 MD     school 2400660 21   Washington 240066001259 402 Clear Spring Elementary   Regular School No Elementary PK 05 2021   pk_12_total 335 * *               *                             348 335                                           348
1317603 MD     school 2400660 21   Washington 240066001260 403 Clear Spring High   Regular School No High 09 12 2021   pk_12_total 424 * 22     *         14                             470 424   22               14                       470
1317619 MD     school 2400660 21   Washington 240066001269 502 Hancock Elementary   Regular School No Elementary PK 05 2021   pk_12_total 205 * *     *         *                             213 205                                           213
1317671 MD     school 2400660 21   Washington 240066001277 903 Old Forge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 265 * 17               11                             298 265   17               11                       298
1317683 MD     school 2400660 21   Washington 240066001280 1101 Pleasant Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 183 * *   * *         *                             204 183                                           204
1317699 MD     school 2400660 21   Washington 240066001258 1401 Cascade Elementary   Regular School No Elementary PK 05 2021   pk_12_total 121 * *   * *         *                             130 121                                           130
1317739 MD     school 2400660 21   Washington 240066001265 2002 Fountain Rock Elementary   Regular School No Elementary PK 05 2021   pk_12_total 219 * 21     *         *                             258 219   21                                       258
1317775 MD     school 2400660 21   Washington 240066001289 2505 Marshall Street School   Special Education School No Other PK 12 2021   pk_12_total 24 * *     *         *                             41 24                                           41
1317821 MD     school 2400690 22   Wicomico 240069001312 406 Pittsville Elementary & Middle   Regular School No Middle 04 08 2021   pk_12_total 322 * 23   * *         29                             387 322   23               29                       387
1317917 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2021   pk_12_total 209 * 23   * *     *   22                             260 209   23               22                       260
1312226 MD     school 2400210 6   Carroll 240021000536 601 Manchester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 525 10 37     *     *   17                             599 525 10 37               17                       599
1313580 MD     school 2400390 12   Harford 240039000684 316 Churchville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 284 10 15   * *         25                             338 284 10 15               25                       338
1317315 MD     school 2400600 18   Saint Mary's 240060001232 504 Mechanicsville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 232 10 13   * *     *   20                             280 232 10 13               20                       280
1317649 MD     school 2400660 21   Washington 240066001286 702 Smithsburg Elementary   Regular School No Elementary PK 05 2021   pk_12_total 270 10 17   *           22                             320 270 10 17               22                       320
1310136 MD     school 2400060 2   Anne Arundel 240006000051 2092 Cape St. Claire Elementary   Regular School No Elementary KG 05 2021   pk_12_total 427 11 68   * 16     *   41                             566 427 11 68     16         41                       566
1310412 MD     school 2400060 2   Anne Arundel 240006000130 3212 South Shore Elementary   Regular School No Elementary KG 05 2021   pk_12_total 175 11 52   * *         22                             268 175 11 52               22                       268
1312239 MD     school 2400210 6   Carroll 240021001652 603 Ebb Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 474 11 14   * 10     *   13                             527 474 11 14     10         13                       527
1312371 MD     school 2400210 6   Carroll 240021001414 1304 Parr's Ridge Elementary   Regular School No Elementary PK 02 2021   pk_12_total 292 11 57     *     *   17                             384 292 11 57               17                       384
1312934 MD     school 2400330 10   Frederick 240033001410 208 Heather Ridge   Alternative School No High 07 12 2021   pk_12_total 22 11 *   *           *                             44 22 11                                         44
1314586 MD     school 2400480 15   Montgomery 240048000809 238 Cold Spring Elementary   Regular School No Elementary PK 05 2021   pk_12_total 139 11 14     128         25                             317 139 11 14     128         25                       317
1317655 MD     school 2400660 21   Washington 240066001484 705 Washington County Job Development Center   Special Education School No High 12 12 2021   pk_12_total 18 11 *               *                             34 18 11                                         34
1317707 MD     school 2400660 21   Washington 240066001268 1602 Greenbrier Elementary   Regular School No Elementary PK 05 2021   pk_12_total 170 11 11     18         10                             220 170 11 11     18         10                       220
1310174 MD     school 2400060 2   Anne Arundel 240006000084 2152 Jones Elementary   Regular School No Elementary KG 05 2021   pk_12_total 219 12 21     21         19                             292 219 12 21     21         19                       292
1310602 MD     school 2400060 2   Anne Arundel 240006000065 4152 Edgewater Elementary   Regular School No Elementary KG 05 2021   pk_12_total 374 12 138   * 10     *   27                             563 374 12 138     10         27                       563
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
1311725 MD     school 2400120 3   Baltimore County 240012000381 1502 Edgemere Elementary   Regular School No Elementary PK 05 2021   pk_12_total 334 12 27   * *         26                             404 334 12 27               26                       404

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