enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1319157 1319157 MD     school 2400090 30   Baltimore City 240009001682 348 Baltimore Leadership School for Young Women   Regular School Yes High 06 12 2021   grade_12                                                   50                                             50
1319191 1319191 MD     school 2400090 30   Baltimore City 240009001689 373 Tunbridge Public Charter School   Regular School Yes Elementary PK 08 2021   grade_2                                                   50                                             50
1319193 1319193 MD     school 2400090 30   Baltimore City 240009001689 373 Tunbridge Public Charter School   Regular School Yes Elementary PK 08 2021   grade_4                                                   50                                             50
1242363 1242363 MD     school 2400480 15   Montgomery 240048000921 503 Sherwood High   Regular School No High 09 12 2020   grade_10                                                   499                                             499
1242388 1242388 MD     school 2400480 15   Montgomery 240048000830 506 Flower Valley Elementary   Regular School No Elementary KG 05 2020   pk_12_total 202 85 134   * 35         42                             499 202 85 134     35         42                       499
1310827 1310827 MD     school 2400120 3   Baltimore County 240012000382 104 Edmondson Heights Elementary   Regular School No Elementary PK 05 2021   pk_12_total 40 336 71   * 28     *   16                             499 40 336 71     28         16                       499
1311499 1311499 MD     school 2400120 3   Baltimore County 240012000446 1171 Perry Hall High   Regular School No High 09 12 2021   grade_9                                                   499                                             499
1312652 1312652 MD     school 2400270 8   Charles 240027000594 609 Dr. James Craik Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 215 179 45   * *         49                             499 215 179 45               49                       499
1315992 1315992 MD     school 2400510 16   Prince George's 240051001683 645 Andrew Jackson Academy   Regular School No Elementary PK 08 2021   pk_12_total * 427 50     *     *   *                             499   427 50                                       499
1317442 1317442 MD     school 2400570 19   Somerset 240057001535 705 Carter G Woodson Elementary   Regular School No Elementary PK 05 2021   pk_12_total 246 156 62     *         33                             499 246 156 62               33                       499
1319268 1319268 MD     school 2400090 30   Baltimore City 240009000280 410 Mergenthaler Vocational-Technical High   Career and Technical School No High 09 12 2021   grade_10                                                   499                                             499
1241621 1241621 MD     school 2400420 13   Howard 240042000746 610 Oakland Mills Middle   Regular School No Middle 06 08 2020   pk_12_total 134 183 121     19         41                             498 134 183 121     19         41                       498
1242345 1242345 MD     school 2400480 15   Montgomery 240048009000 428 Thomas W. Pyle Middle School   Regular School No Middle 06 08 2020   grade_8                                                   498                                             498
1242731 1242731 MD     school 2400480 15   Montgomery 240048090480 747 Dr. Charles R. Drew Elementary   Regular School No Elementary PK 05 2020   pk_12_total 57 236 120   * 63     *   20                             498 57 236 120     63         20                       498
1312952 1312952 MD     school 2400330 10   Frederick 240033000634 213 Gov. Thomas Johnson High   Regular School No High 09 12 2021   grade_9                                                   498                                             498
1313225 1313225 MD     school 2400330 10   Frederick 240033000661 2103 Yellow Springs Elementary   Regular School No Elementary KG 05 2021   pk_12_total 266 112 65   * 22     *   31                             498 266 112 65     22         31                       498
1239603 1239603 MD     school 2400210 6   Carroll 240021000545 404 Sandymount Elementary   Regular School No Elementary PK 05 2020   pk_12_total 409 28 38     13     *   *                             497 409 28 38     13                                 497
1241649 1241649 MD     school 2400420 13   Howard 240042001699 616 Cradlerock Elementary   Regular School No Elementary PK 05 2020   pk_12_total 97 231 88   * 36         44                             497 97 231 88     36         44                       497
1242492 1242492 MD     school 2400480 15   Montgomery 240048000838 551 Gaithersburg High   Regular School No High 09 12 2020   grade_12                                                   497                                             497
1242752 1242752 MD     school 2400480 15   Montgomery 240048000821 756 East Silver Spring Elementary   Regular School No Elementary PK 05 2020   pk_12_total 87 266 109   * 13     *   19                             497 87 266 109     13         19                       497
1244583 1244583 MD     school 2400540 17   Queen Anne's 240054001198 101 Sudlersville Middle School   Regular School No Middle 05 08 2020   pk_12_total 341 36 87   * *         26                             497 341 36 87               26                       497
1309783 1309783 MD     school 2400030 1   Allegany 240003001359 401 South Penn Elementary   Regular School No Elementary PK 05 2021   pk_12_total 361 40 *     *         85                             497 361 40                 85                       497
1314850 1314850 MD     school 2400480 15   Montgomery 240048000787 410 Bradley Hills Elementary   Regular School No Elementary PK 05 2021   pk_12_total 309 13 44     82         49                             497 309 13 44     82         49                       497
1316551 1316551 MD     school 2400510 16   Prince George's 240051001041 1411 Gaywood Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 122 350   * 11         *                             497   122 350     11                                 497
1237534 1237534 MD     school 2400060 2   Anne Arundel 240006000126 2043 Severna Park Middle   Regular School No Middle 06 08 2020   grade_6                                                   496                                             496
1242068 1242068 MD     school 2400480 15   Montgomery 240048001541 249 Clarksburg High   Regular School No High 09 12 2020   grade_11                                                   496                                             496
1243285 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
1311044 1311044 MD     school 2400120 3   Baltimore County 240012000492 304 Wellwood International School   Regular School No Elementary KG 05 2021   pk_12_total 81 308 42   * 46         16                             496 81 308 42     46         16                       496
1311980 1311980 MD     school 2400150 4   Calvert 240015000517 207 Calvert Elementary   Regular School No Elementary PK 05 2021   pk_12_total 307 100 25   *           61                             496 307 100 25               61                       496
1238070 1238070 MD     school 2400060 2   Anne Arundel 240006000089 4202 Lothian Elementary   Regular School No Elementary PK 05 2020   pk_12_total 247 37 164   * *     *   40                             495 247 37 164               40                       495
1238972 1238972 MD     school 2400120 3   Baltimore County 240012000347 1206 Bear Creek Elementary   Regular School No Elementary PK 05 2020   pk_12_total 296 62 56   * 10         65                             495 296 62 56     10         65                       495
1239376 1239376 MD     school 2400150 4   Calvert 240015001392 111 Southern Middle   Regular School No Middle 06 08 2020   pk_12_total 315 87 43     *         46                             495 315 87 43               46                       495
1239861 1239861 MD     school 2400240 7   Cecil 240024000791 206 Bohemia Manor Middle   Regular School No Middle 06 08 2020   pk_12_total 385 34 43   * *     *   28                             495 385 34 43               28                       495
1246034 1246034 MD     school 2400090 30   Baltimore City 240009000210 206 Furley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 21 437 26   * *     *                                 495 21 437 26                                       495
1316115 1316115 MD     school 2400510 16   Prince George's 240051000500 729 Kingsford Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 433 33   * *         13                             495   433 33               13                       495
1244681 1244681 MD     school 2400600 18   Saint Mary's 240060001228 301 Leonardtown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 358 73 21     *         34                             494 358 73 21               34                       494
1311486 1311486 MD     school 2400120 3   Baltimore County 240012000397 1111 Gunpowder Elementary   Regular School No Elementary KG 05 2021   pk_12_total 297 88 15   * 74         19                             494 297 88 15     74         19                       494
1314722 1314722 MD     school 2400480 15   Montgomery 240048000929 316 Stonegate Elementary   Regular School No Elementary PK 05 2021   pk_12_total 80 181 111     81     *   39                             494 80 181 111     81         39                       494
1315484 1315484 MD     school 2400480 15   Montgomery 240048000952 788 Wheaton Woods Elementary   Regular School No Elementary PK 05 2021   pk_12_total 15 127 302   * 35         14                             494 15 127 302     35         14                       494
1318009 1318009 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2021   pk_12_total 254 130 57     *         47                             494 254 130 57               47                       494
1238413 1238413 MD     school 2400120 3   Baltimore County 240012000498 211 Winfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 14 425 32   * *         15                             493 14 425 32               15                       493
1239209 1239209 MD     school 2400120 3   Baltimore County 240012000384 1508 Essex Elementary   Regular School No Elementary PK 05 2020   pk_12_total 293 67 75   11 17     *   28                             493 293 67 75   11 17         28                       493
1239906 1239906 MD     school 2400240 7   Cecil 240024000581 316 Thomson Estates Elementary   Regular School No Elementary PK 05 2020   pk_12_total 214 116 88   * 13     *   59                             493 214 116 88     13         59                       493
1241496 1241496 MD     school 2400420 13   Howard 240042000737 518 Harpers Choice Middle   Regular School No Middle 06 08 2020   pk_12_total 91 236 80   * 36         47                             493 91 236 80     36         47                       493
1242338 1242338 MD     school 2400480 15   Montgomery 240048000941 427 Walt Whitman High   Regular School No High 09 12 2020   grade_9                                                   493                                             493
1245804 1245804 MD     school 2400090 30   Baltimore City 240009000602 81 North Bend Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 457 24   *       *   *                             493   457 24                                       493
1311317 1311317 MD     school 2400120 3   Baltimore County 240012000435 910 Oakleigh Elementary   Regular School No Elementary PK 05 2021   pk_12_total 85 277 66   * 24         39                             493 85 277 66     24         39                       493
1316743 1316743 MD     school 2400510 16   Prince George's 240051001114 1708 Northwestern High   Regular School No High 09 12 2021   grade_11                                                   493                                             493
1317043 1317043 MD     school 2400510 16   Prince George's 240051001085 2014 Lamont Elementary   Regular School No Elementary PK 05 2021   pk_12_total 27 116 333   * 10         *                             493 27 116 333     10                                 493
1241298 1241298 MD     school 2400420 13   Howard 240042000738 203 Howard High   Regular School No High 09 12 2020   grade_12                                                   492                                             492
1243893 1243893 MD     school 2400510 16   Prince George's 240051002951 1327 Charles Herbert Flowers High   Regular School No High 09 12 2020   grade_12                                                   492                                             492
1245355 1245355 MD     school 2400690 22   Wicomico 240069001151 1601 Fruitland Primary   Regular School No Elementary PK 02 2020   pk_12_total 251 119 50   * 19     *   50                             492 251 119 50     19         50                       492
1310085 1310085 MD     school 2400060 2   Anne Arundel 240006000127 2013 Severna Park High   Regular School No High 09 12 2021   grade_12                                                   492                                             492
1310098 1310098 MD     school 2400060 2   Anne Arundel 240006000126 2043 Severna Park Middle   Regular School No Middle 06 08 2021   grade_8                                                   492                                             492
1238947 1238947 MD     school 2400120 3   Baltimore County 240012000446 1171 Perry Hall High   Regular School No High 09 12 2020   grade_12                                                   491                                             491
1238978 1238978 MD     school 2400120 3   Baltimore County 240012000434 1207 Norwood Elementary   Regular School No Elementary PK 03 2020   pk_12_total 207 42 164     43     *   34                             491 207 42 164     43         34                       491
1244432 1244432 MD     school 2400510 16   Prince George's 240051001043 2010 Glenarden Woods Elementary   Regular School No Elementary 02 05 2020   pk_12_total 51 311 75   * 41     *   11                             491 51 311 75     41         11                       491
1310390 1310390 MD     school 2400060 2   Anne Arundel 240006000114 3182 Pershing Hill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 216 99 97   * 14     *   60                             491 216 99 97     14         60                       491
1315580 1315580 MD     school 2400480 15   Montgomery 240048000814 808 Cresthaven Elementary   Regular School No Elementary 03 05 2021   pk_12_total 11 185 252     37     *   *                             491 11 185 252     37                                 491
1315621 1315621 MD     school 2400480 15   Montgomery 240048000930 822 Strathmore Elementary   Regular School No Elementary 03 05 2021   pk_12_total 38 174 242     25         12                             491 38 174 242     25         12                       491
1317636 1317636 MD     school 2400660 21   Washington 240066001254 603 Boonsboro Elementary   Regular School No Elementary PK 05 2021   pk_12_total 438 17 22     *     *   10                             491 438 17 22               10                       491
1317715 1317715 MD     school 2400660 21   Washington 240066001253 1701 Bester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 176 131 85   * *         94                             491 176 131 85               94                       491
1318369 1318369 MD     school 2400090 30   Baltimore City 240009000602 81 North Bend Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 10 446 28   *       *   *                             491 10 446 28                                       491
1241209 1241209 MD     school 2400390 12   Harford 240039000711 639 Roye-Williams Elementary   Regular School No Elementary PK 05 2020   pk_12_total 202 126 90   * 10     *   59                             490 202 126 90     10         59                       490
1243327 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
1244006 1244006 MD     school 2400510 16   Prince George's 240051001251 1417 Robert Goddard Montessori   Regular School No Elementary PK 08 2020   pk_12_total 106 314 31   * 26     *   10                             490 106 314 31     26         10                       490
1314051 1314051 MD     school 2400420 13   Howard 240042000737 518 Harpers Choice Middle   Regular School No Middle 06 08 2021   pk_12_total 92 241 74   * 38     *   43                             490 92 241 74     38         43                       490
1314909 1314909 MD     school 2400480 15   Montgomery 240048000941 427 Walt Whitman High   Regular School No High 09 12 2021   grade_11                                                   490                                             490
1315418 1315418 MD     school 2400480 15   Montgomery 240048000878 776 Montgomery Knolls Elementary   Regular School No Elementary PK 02 2021   pk_12_total 94 127 215     25         29                             490 94 127 215     25         29                       490
1237269 1237269 MD     school 2400030 1   Allegany 240003000010 701 Cresaptown Elementary   Regular School No Elementary PK 05 2020   kindergarten                                                   49                                             49
1237271 1237271 MD     school 2400030 1   Allegany 240003000010 701 Cresaptown Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   49                                             49
1237273 1237273 MD     school 2400030 1   Allegany 240003000010 701 Cresaptown Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   49                                             49
1237393 1237393 MD     school 2400060 2   Anne Arundel 240006000071 1112 George T. Cromwell Elementary   Regular School No Elementary 01 05 2020   grade_1                                                   49                                             49
1237449 1237449 MD     school 2400060 2   Anne Arundel 240006000105 1182 Oakwood Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   49                                             49
1237482 1237482 MD     school 2400060 2   Anne Arundel 240006000117 1232 Quarterfield Elementary   Regular School No Elementary PK 05 2020   grade_3                                                   49                                             49
1237609 1237609 MD     school 2400060 2   Anne Arundel 240006000084 2152 Jones Elementary   Regular School No Elementary KG 05 2020   grade_3                                                   49                                             49
1238171 1238171 MD     school 2400060 2   Anne Arundel 240006001401 6223 Chesapeake Science Point   Regular School Yes High 06 12 2020   grade_12                                                   49                                             49
1238384 1238384 MD     school 2400120 3   Baltimore County 240012000364 207 Church Lane Elementary Technology   Regular School No Elementary PK 05 2020   grade_1                                                   49                                             49
1239212 1239212 MD     school 2400120 3   Baltimore County 240012000363 1511 Chesapeake Terrace Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   49                                             49
1239256 1239256 MD     school 2400120 3   Baltimore County 240012000345 1517 Battle Grove Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   49                                             49
1239279 1239279 MD     school 2400120 3   Baltimore County 240012000429 1520 Middleborough Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   49                                             49
1239838 1239838 MD     school 2400240 7   Cecil 240024000562 104 Cecilton Elementary   Regular School No Elementary PK 05 2020   kindergarten                                                   49                                             49
1239910 1239910 MD     school 2400240 7   Cecil 240024001491 317 Kenmore Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   49                                             49
1239994 1239994 MD     school 2400240 7   Cecil 240024000556 704 Bainbridge Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   49                                             49
1240133 1240133 MD     school 2400270 8   Charles 240027010501 617 Daniel of St. Thomas Jenifer Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   49                                             49
1240277 1240277 MD     school 2400300 9   Dorchester 240030000625 205 Warwick Elementary School   Regular School No Elementary PK 05 2020   grade_3                                                   49                                             49
1241131 1241131 MD     school 2400390 12   Harford 240039000703 391 John Archer School   Special Education School No Other PK 12 2020   grade_12                                                   49                                             49
1241723 1241723 MD     school 2400450 14   Kent 240045000765 403 H. H. Garnett Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   49                                             49
1242368 1242368 MD     school 2400480 15   Montgomery 240048000950 504 Westover Elementary   Regular School No Elementary PK 05 2020   kindergarten                                                   49                                             49
1242373 1242373 MD     school 2400480 15   Montgomery 240048000950 504 Westover Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   49                                             49
1242411 1242411 MD     school 2400480 15   Montgomery 240048000800 511 Cashell Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   49                                             49
1242701 1242701 MD     school 2400480 15   Montgomery 240048000959 704 Woodfield Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   49                                             49
1242882 1242882 MD     school 2400480 15   Montgomery 240048000851 784 Highland View Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   49                                             49
1243236 1243236 MD     school 2400510 16   Prince George's 240051001039 504 Fort Washington Forest Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   49                                             49
1243239 1243239 MD     school 2400510 16   Prince George's 240051001039 504 Fort Washington Forest Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   49                                             49
1243244 1243244 MD     school 2400510 16   Prince George's 240051001148 507 Rose Valley Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   49                                             49
1243331 1243331 MD     school 2400510 16   Prince George's 240051001094 618 Longfields Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   49                                             49
1243344 1243344 MD     school 2400510 16   Prince George's 240051001136 619 Princeton Elementary   Regular School No Elementary PK 06 2020   grade_6                                                   49                                             49
1243410 1243410 MD     school 2400510 16   Prince George's 240051001683 645 Andrew Jackson Academy   Regular School No Elementary PK 08 2020   grade_7                                                   49                                             49
1243548 1243548 MD     school 2400510 16   Prince George's 240051001170 905 Tayac Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   49                                             49

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