Data source: Big Local News · About: Big Local

9,615 rows where state = "MD" and year = 2020 sorted by white_int

View and edit SQL

year

  • 2020 · 9,615
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
1238085 MD     school 2400060 2   Anne Arundel 240006000112 4222 Walter S. Mills - Parole Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 233 355   * *         12                             615   233 355               12                       615
1238189 MD     school 2400120 3   Baltimore County 240012001751 52 Southwest EDLP at Woodlawn High School   Alternative School No High 09 12 2020   pk_12_total * * *     *         *                             14                                             14
1238193 MD     school 2400120 3   Baltimore County 240012001754 53 Northeast EDLP at Parkville High School   Alternative School No High 10 12 2020   pk_12_total * * *                                             18                                             18
1238197 MD     school 2400120 3   Baltimore County 240012001759 55 Southeast EDLP at Dundalk High School   Alternative School No High 10 12 2020   pk_12_total * 10 *               *                             18   10                                         18
1238199 MD     school 2400120 3   Baltimore County 240012001760 56 Central EDLP at Loch Raven High School   Alternative School No High 12 12 2020   pk_12_total * *                                               *                                              
1238210 MD     school 2400120 3   Baltimore County 240012000935 58 Home Assignments-Secondary   Alternative School No High 07 12 2020   pk_12_total * 17                 *                             26   17                                         26
1238218 MD     school 2400120 3   Baltimore County 240012000436 69 Catonsville Center for Alternative Studies   Alternative School No High 09 12 2020   pk_12_total * 45 *     *         *                             55   45                                         55
1238221 MD     school 2400120 3   Baltimore County 240012000777 70 Meadowood Education Center   Alternative School No Middle 07 08 2020   pk_12_total * 25 *   * *         *                             33   25                                         33
1238241 MD     school 2400120 3   Baltimore County 240012001711 77 BCDC Educational Center   Alternative School No High 09 12 2020   pk_12_total * 24 *                                             33   24                                         33
1238358 MD     school 2400120 3   Baltimore County 240012000457 202 Randallstown Elementary   Regular School No Elementary KG 05 2020   pk_12_total * 345 29     *     *   11                             400   345 29               11                       400
1238389 MD     school 2400120 3   Baltimore County 240012000364 207 Church Lane Elementary Technology   Regular School No Elementary PK 05 2020   pk_12_total * 319 24   * *         10                             367   319 24               10                       367
1238397 MD     school 2400120 3   Baltimore County 240012000402 209 Hebbville Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 423 72   * *         17                             527   423 72               17                       527
1238405 MD     school 2400120 3   Baltimore County 240012000455 210 Powhatan Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 206 27   *           11                             251   206 27               11                       251
1238429 MD     school 2400120 3   Baltimore County 240012000405 214 Hernwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 339 18   * *         15                             383   339 18               15                       383
1238437 MD     school 2400120 3   Baltimore County 240012000371 216 Deer Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 385 *     *         *                             404   385                                         404
1238466 MD     school 2400120 3   Baltimore County 240012001574 256 Windsor Mill Middle   Regular School No Middle 06 08 2020   pk_12_total * 617 32   * *         11                             674   617 32               11                       674
1239512 MD     school 2400150 4   Calvert 240015001344 500 Calvert County Alternative School   Alternative School No High 09 12 2020   pk_12_total * * *                                             *                                              
1239771 MD     school 2400210 6   Carroll 240021001349 718 PRIDE School   Alternative School No Elementary 01 05 2020   pk_12_total * *                                               *                                              
1239774 MD     school 2400210 6   Carroll 240021001694 726 Crossroads Middle School   Alternative School No Middle 06 08 2020   pk_12_total *   *               *                             *                                              
1242093 MD     school 2400480 15   Montgomery 240048000788 304 JoAnn Leleck at Broad Acres Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 101 739   * 21         *                             874   101 739     21                                 874
1243121 MD     school 2400510 16   Prince George's 240051001354 108 James E. Duckworth Regional Center   Special Education School No Other KG 12 2020   pk_12_total * 33 52     *         *                             93   33 52                                       93
1243130 MD     school 2400510 16   Prince George's 240051001069 109 James H. Harrison Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 136 138     26         *                             314   136 138     26                                 314
1243194 MD     school 2400510 16   Prince George's 240051001014 213 Cooper Lane Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 176 324   * 11         *                             527   176 324     11                                 527
1243224 MD     school 2400510 16   Prince George's 240051000866 304 Perrywood Elementary   Regular School No Elementary KG 05 2020   pk_12_total * 540 31   * *         *                             593   540 31                                       593
1243232 MD     school 2400510 16   Prince George's 240051001129 305 Patuxent Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 264 20   * *         *                             293   264 20                                       293
1243248 MD     school 2400510 16   Prince George's 240051001148 507 Rose Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 190 139   * *     *   *                             354   190 139                                       354
1243285 MD     school 2400510 16   Prince George's 240051000991 606 Bradbury Heights Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 395 90     *     *   *                             496   395 90                                       496
1243293 MD     school 2400510 16   Prince George's 240051001060 607 Hillcrest Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 390 72     *     *   *                             474   390 72                                       474
1243298 MD     school 2400510 16   Prince George's 240051001047 608 Green Valley Academy at Edgar Allan Poe   Alternative School No Secondary 07 10 2020   pk_12_total * 41 *   *           *                             50   41                                         50
1243307 MD     school 2400510 16   Prince George's 240051001113 610 North Forestville Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 226 113   * *     *   *                             351   226 113                                       351
1243315 MD     school 2400510 16   Prince George's 240051001019 613 District Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 335 62     *         *                             403   335 62                                       403
1243319 MD     school 2400510 16   Prince George's 240051001464 615 Benjamin Stoddert Middle   Regular School No Middle 06 08 2020   pk_12_total * 565 121     *     *                                 696   565 121                                       696
1243327 MD     school 2400510 16   Prince George's 240051001050 617 Francis Scott Key Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 384 98     *         *                             490   384 98                                       490
1243336 MD     school 2400510 16   Prince George's 240051001094 618 Longfields Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 224 59   * *     *   *                             296   224 59                                       296
1243345 MD     school 2400510 16   Prince George's 240051001136 619 Princeton Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 217 131   * *         *                             366   217 131                                       366
1243349 MD     school 2400510 16   Prince George's 240051001465 622 Thurgood Marshall Middle School   Regular School No Middle 06 08 2020   pk_12_total * 448 150   * *     *   *                             625   448 150                                       625
1243358 MD     school 2400510 16   Prince George's 240051000966 632 Allenwood Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 254 168   * *         *                             435   254 168                                       435
1243365 MD     school 2400510 16   Prince George's 240051001119 633 Overlook Elementary   Regular School No Elementary KG 05 2020   pk_12_total * 286 27   * *     *   *                             332   286 27                                       332
1243373 MD     school 2400510 16   Prince George's 240051001184 636 William Beanes Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 363 106     *     *   *                             481   363 106                                       481
1243383 MD     school 2400510 16   Prince George's 240051001684 638 Benjamin D. Foulois Academy   Regular School No Elementary KG 08 2020   pk_12_total * 502 14   * *     *   12                             538   502 14               12                       538
1243393 MD     school 2400510 16   Prince George's 240051001554 639 Maya Angelou French Immersion   Regular School No Elementary KG 08 2020   pk_12_total * 436 14     10         *                             476   436 14     10                                 476
1243412 MD     school 2400510 16   Prince George's 240051001683 645 Andrew Jackson Academy   Regular School No Elementary PK 08 2020   pk_12_total * 423 60     *     *   *                             504   423 60                                       504
1243421 MD     school 2400510 16   Prince George's 240051001013 647 Concord Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 327 29   * *         *                             365   327 29                                       365
1243432 MD     school 2400510 16   Prince George's 240051001555 648 Samuel P. Massie Academy   Regular School No Elementary PK 08 2020   pk_12_total * 576 29     *         *                             614   576 29                                       614
1243441 MD     school 2400510 16   Prince George's 240051001556 656 Panorama Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 457 95   * *     *   *                             587   457 95                                       587
1243454 MD     school 2400510 16   Prince George's 240051001453 661 Suitland Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 456 115     *         *                             578   456 115                                       578
1243464 MD     school 2400510 16   Prince George's 240051001648 662 Imagine Lincoln Public Charter   Regular School Yes Elementary KG 08 2020   pk_12_total * 389 *     *         *                             405   389                                         405
1243467 MD     school 2400510 16   Prince George's 240051001424 705 Tall Oaks High   Alternative School No High 11 12 2020   pk_12_total * 63 25   * *                                       95   63 25                                       95
1243475 MD     school 2400510 16   Prince George's 240051001188 706 Woodmore Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 406 33     20     *   *                             473   406 33     20                                 473
1243535 MD     school 2400510 16   Prince George's 240051000500 729 Kingsford Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 464 38   * *         *                             528   464 38                                       528
1243552 MD     school 2400510 16   Prince George's 240051001170 905 Tayac Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 235 93     *     *   *                             347   235 93                                       347
1243560 MD     school 2400510 16   Prince George's 240051001010 906 Clinton Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 181 69     *         *                             264   181 69                                       264
1243709 MD     school 2400510 16   Prince George's 240051001031 1204 Forest Heights Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 175 146   * *         *                             330   175 146                                       330
1243720 MD     school 2400510 16   Prince George's 240051000870 1206 John Hanson Montessori   Regular School No Elementary PK 08 2020   pk_12_total * 462 20   * 13     *   *                             511   462 20     13                                 511
1243749 MD     school 2400510 16   Prince George's 240051001042 1214 Glassmanor Elementary   Regular School No Elementary KG 05 2020   pk_12_total * 94 223                                             319   94 223                                       319
1243757 MD     school 2400510 16   Prince George's 240051001150 1216 Samuel Chase Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 222 92   * *         *                             324   222 92                                       324
1243778 MD     school 2400510 16   Prince George's 240051000974 1219 Barnaby Manor Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 326 157   * *         *                             501   326 157                                       501
1243783 MD     school 2400510 16   Prince George's 240051001133 1220 Potomac High   Regular School No High 09 12 2020   pk_12_total * 820 338   * 14         14                             1196   820 338     14         14                       1196
1243792 MD     school 2400510 16   Prince George's 240051000972 1221 Avalon Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 232 125   * *     *   *                             374   232 125                                       374
1243810 MD     school 2400510 16   Prince George's 240051001068 1231 J. Frank Dent Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 247 26     *         *                             284   247 26                                       284
1243841 MD     school 2400510 16   Prince George's 240051001135 1307 Highland Park Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 205 51   *                                         259   205 51                                       259
1243865 MD     school 2400510 16   Prince George's 240051001089 1314 Largo High   Regular School No High 09 12 2020   pk_12_total * 779 70   * *     *   11                             872   779 70               11                       872
1243885 MD     school 2400510 16   Prince George's 240051001082 1324 Kettering Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 374 31     *     *   *                             419   374 31                                       419
1243915 MD     school 2400510 16   Prince George's 240051001217 1346 Lake Arbor Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 526 12   * *         15                             559   526 12               15                       559
1243923 MD     school 2400510 16   Prince George's 240051001222 1347 Cora L. Rice Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 585 40   * *         *                             636   585 40                                       636
1243927 MD     school 2400510 16   Prince George's 240051001223 1348 Ernest Everett Just Middle   Regular School No Middle 06 08 2020   pk_12_total * 693 60   * *         10                             780   693 60               10                       780
1243950 MD     school 2400510 16   Prince George's 240051001737 1352 International High school @ Largo   Regular School No High 09 12 2020   pk_12_total * 21 342     19                                       385   21 342     19                                 385
1244065 MD     school 2400510 16   Prince George's 240051001540 1442 Excel Academy Public Charter   Regular School Yes Elementary KG 08 2020   pk_12_total * 386 35   * *     *   *                             431   386 35                                       431
1244089 MD     school 2400510 16   Prince George's 240051001100 1511 Marlton Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 271 15   * *         *                             299   271 15                                       299
1244112 MD     school 2400510 16   Prince George's 240051001637 1521 Imagine Foundations at Leeland PCS   Regular School Yes Elementary KG 08 2020   pk_12_total * 457 *   * *         *                             480   457                                         480
1244122 MD     school 2400510 16   Prince George's 240051001706 1522 Imagine Foundations at Morningside PCS   Regular School Yes Elementary KG 08 2020   pk_12_total * 407 10   * *         *                             427   407 10                                       427
1244172 MD     school 2400510 16   Prince George's 240051001009 1709 Chillum Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 141 228   * *         *                             379   141 228                                       379
1244181 MD     school 2400510 16   Prince George's 240051001138 1710 Ridgecrest Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 180 501   * *                                       690   180 501                                       690
1244190 MD     school 2400510 16   Prince George's 240051000999 1711 Carole Highlands Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 71 425     10         *                             515   71 425     10                                 515
1244198 MD     school 2400510 16   Prince George's 240051001093 1712 Lewisdale Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 61 624   * *         *                             699   61 624                                       699
1244227 MD     school 2400510 16   Prince George's 240051001087 1719 Langley Park/McCormick Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 34 837   * *     *   *                             890   34 837                                       890
1244281 MD     school 2400510 16   Prince George's 240051001021 1808 Doswell E. Brooks Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 177 61     *     *   *                             247   177 61                                       247
1244294 MD     school 2400510 16   Prince George's 240051000998 1811 Carmody Hills Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 308 108               *                             423   308 108                                       423
1244320 MD     school 2400510 16   Prince George's 240051001075 1816 John H. Bayne Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 337 48   * *     *   *                             399   337 48                                       399
1244326 MD     school 2400510 16   Prince George's 240051001053 1822 H. W. Wheatley Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   pk_12_total * 244 39     10         *                             301   244 39     10                                 301
1244335 MD     school 2400510 16   Prince George's 240051001183 1828 Robert R. Gray Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 263 123   * *     *                                 399   263 123                                       399
1244372 MD     school 2400510 16   Prince George's 240051000975 1907 Beacon Heights Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 94 352   * *         *                             461   94 352                                       461
1244389 MD     school 2400510 16   Prince George's 240051001154 2003 Seabrook Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 112 185   * 11         *                             316   112 185     11                                 316
1244415 MD     school 2400510 16   Prince George's 240051001386 2007 Woodridge Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 39 274     *     *                                 324   39 274                                       324
1244423 MD     school 2400510 16   Prince George's 240051000970 2008 Ardmore Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 340 82     *     *   *                             435   340 82                                       435
1244446 MD     school 2400510 16   Prince George's 240051001419 2012 Margaret Brent Regional Center   Special Education School No Elementary KG 08 2020   pk_12_total * 42 27                                             72   42 27                                       72
1244469 MD     school 2400510 16   Prince George's 240051001142 2016 Robert Frost Elementary   Regular School No Elementary KG 05 2020   pk_12_total * 110 160     *         *                             287   110 160                                       287
1244479 MD     school 2400510 16   Prince George's 240051001544 2022 Middleton Valley Academy   Regular School Yes Elementary KG 08 2020   pk_12_total * 355 24   * *     *   *                             390   355 24                                       390
1244562 MD     school 2400510 16   Prince George's 240051001054 2211 Northwestern Evening/Saturday High   Alternative School No High 09 12 2020   pk_12_total * 64 401   * *         *                             481   64 401                                       481
1244567 MD     school 2400510 16   Prince George's 240051001062 2213 Crossland Evening/Saturday High   Alternative School No High 09 12 2020   pk_12_total * 185 33   *           *                             228   185 33                                       228
1244576 MD     school 2400510 16   Prince George's 240051001067 2220 Community Based Classrooms   Alternative School No High 12 12 2020   pk_12_total * 49 23           *   *                             75   49 23                                       75
1244578 MD     school 2400510 16   Prince George's 240051001476 2300 Prekindergarten Offsites   Regular School No Prekindergarten PK PK 2020   pk_12_total * 12 *               *                             16   12                                         16
1244872 MD     school 2400570 19   Somerset 240057001203 1003 Ewell School   Regular School No Elementary PK 07 2020   pk_12_total *                                                 *                                              
1245456 MD     school 2400090 30   Baltimore City 240009000169 7 Cecil Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 384 *           *   *                             391   384                                         391
1245486 MD     school 2400090 30   Baltimore City 240009000196 11 Eutaw-Marshburn Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 262 *               *                             271   262                                         271
1245508 MD     school 2400090 30   Baltimore City 240009000320 13 Tench Tilghman Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 340 53               *                             398   340 53                                       398
1245512 MD     school 2400090 30   Baltimore City 240009000571 15 Stadium School   Regular School No Middle 06 08 2020   pk_12_total * 390 16           *   *                             415   390 16                                       415
1245520 MD     school 2400090 30   Baltimore City 240009000258 16 Johnston Square Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 282 *               *                             291   282                                         291
1245528 MD     school 2400090 30   Baltimore City 240009000246 21 Hilton Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 349 *                                             365   349                                         365
1245566 MD     school 2400090 30   Baltimore City 240009000335 28 Sandtown-Winchester Achievement Academy   Regular School No Elementary PK 08 2020   pk_12_total * 390 *               *                             400   390                                         400

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