Data source: Big Local News · About: Big Local

2,791 rows where grade = "pk_12_total" and state = "MD" sorted by total_int

View and edit SQL

year

grade

  • pk_12_total · 2,791
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 ▼
1238185 MD     school 2400120 3   Baltimore County 240012001756 51 Northwest EDLP at Milford Mill Academy   Alternative School No High 11 12 2020   pk_12_total   * *                                             *                                              
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 * *                                               *                                              
1238203 MD     school 2400120 3   Baltimore County 240012000925 57 Home Assignments-Elementary   Alternative School No Middle 04 06 2020   pk_12_total   *                                               *                                              
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 *   *               *                             *                                              
1244872 MD     school 2400570 19   Somerset 240057001203 1003 Ewell School   Regular School No Elementary PK 07 2020   pk_12_total *                                                 *                                              
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 * * *                                             *                                              
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 * * *                                             *                                              
1310760 MD     school 2400120 3   Baltimore County 240012001760 56 Central EDLP at Loch Raven High School   Alternative School No High 12 12 2021   pk_12_total *                                                 *                                              
1312318 MD     school 2400210 6   Carroll 240021001349 718 PRIDE School   Alternative School No Elementary 01 05 2021   pk_12_total * * *                                             *                                              
1312321 MD     school 2400210 6   Carroll 240021001694 726 Crossroads Middle School   Alternative School No Middle 07 08 2021   pk_12_total *   *                                             *                                              
1317156 MD     school 2400510 16   Prince George's 240051001476 2300 Prekindergarten Offsites   Regular School No Prekindergarten PK PK 2021   pk_12_total * * *                                             *                                              
1317447 MD     school 2400570 19   Somerset 240057001203 1003 Ewell School   Regular School No Middle 01 07 2021   pk_12_total *                                                 *                                              
1244572 MD     school   16   Prince George's   2217 Incarcerated Youth Center (JACS)             2020   pk_12_total   * *                                             10                                             10
1317149 MD     school   16   Prince George's   2217 Incarcerated Youth Center (JACS)             2021   pk_12_total   * *               *                             11                                             11
1310765 MD     school 2400120 3   Baltimore County 240012000935 58 Home Assignments-Secondary   Alternative School No High 08 12 2021   pk_12_total * *                                               12                                             12
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
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
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 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
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
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
1246466 MD     school 2400090 30   Baltimore City 240009001369 314 Sharp-Leadenhall Elementary   Special Education School No Elementary 01 05 2020   pk_12_total * 15                 *                             18   15                                         18
1239802 MD     school 2400210 6   Carroll 240021001350 903 Flexible Student Support   Alternative School No High 09 12 2020   pk_12_total 19         *         *                             22 19                                           22
1310783 MD     school 2400120 3   Baltimore County 240012000831 72 Rosedale Center   Alternative School No High 07 12 2021   pk_12_total * 17                 *                             25   17                                         25
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
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
1319017 MD     school 2400090 30   Baltimore City 240009001369 314 Sharp-Leadenhall Elementary   Special Education School No Elementary 01 05 2021   pk_12_total * 23                 *                             27   23                                         27
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
1310795 MD     school 2400120 3   Baltimore County 240012001711 77 BCDC Educational Center   Alternative School No High 09 12 2021   pk_12_total * 19 *                                             31   19                                         31
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
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
1239744 MD     school 2400210 6   Carroll 240021000527 712 Carroll Springs School   Special Education School No Other PK 12 2020   pk_12_total 26 * *     *                                       33 26                                           33
1245080 MD     school 2400660 21   Washington 240066001484 705 Washington County Job Development Center   Special Education School No High 12 12 2020   pk_12_total 23 * *               *                             33 23                                           33
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
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
1319357 MD     school 2400090 30   Baltimore City 240009000885 884 Eager Street Academy   Alternative School No High 09 12 2021   pk_12_total * 35 *           *                                 39   35                                         39
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
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
1310543 MD     school 2400060 2   Anne Arundel 240006001729 4064 Mary Moss at Adams Academy   Alternative School No Middle 07 09 2021   pk_12_total 10 19 *               *                             42 10 19                                         42
1245199 MD     school 2400660 21   Washington 240066001289 2505 Marshall Street School   Special Education School No Other KG 12 2020   pk_12_total 25 * *     *         *                             43 25                                           43
1237978 MD     school 2400060 2   Anne Arundel 240006001729 4064 Mary Moss at Adams Academy   Alternative School No Middle 07 09 2020   pk_12_total 11 21 *               *                             44 11 21                                         44
1239766 MD     school 2400210 6   Carroll 240021001348 717 Post Secondary Program   Alternative School No High 12 12 2020   pk_12_total 41 * *                                             44 41                                           44
1246461 MD     school 2400090 30   Baltimore City 240009001364 313 Lois T. Murray Elementary/Middle   Special Education School No Elementary PK 08 2020   pk_12_total * 33 *                                             44   33                                         44
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
1318543 MD     school 2400090 30   Baltimore City 240009000219 177 George W. F. McMechen High   Special Education School No High 10 12 2021   pk_12_total * 39 *               *                             44   39                                         44
1319011 MD     school 2400090 30   Baltimore City 240009001364 313 Lois T. Murray Elementary/Middle   Special Education School No Elementary KG 08 2021   pk_12_total * 34 *                                             44   34                                         44
1313388 MD     school 2400360 11   Garrett 240036000676 1812 Swan Meadow School   Regular School No Elementary KG 08 2021   pk_12_total 44   *                                             45 44                                           45
1239417 MD     school 2400150 4   Calvert 240015000509 206 Calvert Country School   Special Education School No Other 03 12 2020   pk_12_total 29 * *   * *         *                             46 29                                           46
1246813 MD     school 2400090 30   Baltimore City 240009000885 884 Eager Street Academy   Alternative School No High 08 12 2020   pk_12_total   43 *     *                                       46   43                                         46
1246450 MD     school 2400090 30   Baltimore City 240009000176 307 Claremont School   Special Education School No High 08 12 2020   pk_12_total * 44 *                                             48   44                                         48
1315797 MD     school 2400510 16   Prince George's 240051001463 303 Croom High   Alternative School No High 11 12 2021   pk_12_total * 43 *               *                             48   43                                         48
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
1245979 MD     school 2400090 30   Baltimore City 240009000219 177 George W. F. McMechen High   Special Education School No High 09 12 2020   pk_12_total * 44 *               *                             50   44                                         50
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
1318002 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   pk_12_total 27 16 *     *         *                             50 27 16                                         50
1310773 MD     school 2400120 3   Baltimore County 240012000436 69 Catonsville Center for Alternative Studies   Alternative School No High 09 12 2021   pk_12_total * 41 *     *         *                             51   41                                         51
1312312 MD     school 2400210 6   Carroll 240021001548 716 Gateway School   Alternative School No High 09 12 2021   pk_12_total 42 * *   * *         *                             51 42                                           51
1319001 MD     school 2400090 30   Baltimore City 240009000176 307 Claremont School   Special Education School No High 07 12 2021   pk_12_total * 47 *                                             51   47                                         51
1315552 MD     school 2400480 15   Montgomery 240048000496 799 Stephen Knolls School   Special Education School No Other PK 12 2021   pk_12_total 13 17 19     *         *                             52 13 17 19                                       52
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
1242467 MD     school 2400480 15   Montgomery 240048001365 525 MCPS Transitions School   Special Education School No High 12 12 2020   pk_12_total 13 21 15     *         *                             55 13 21 15                                       55
1245426 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   pk_12_total 28 19 *     *         *                             55 28 19                                         55
1240388 MD     school 2400330 10   Frederick 240033001410 208 Heather Ridge   Alternative School No High 06 12 2020   pk_12_total 21 19 *   *           *                             56 21 19                                         56
1315880 MD     school 2400510 16   Prince George's 240051001047 608 Green Valley Academy at Edgar Allan Poe   Alternative School No Secondary 07 10 2021   pk_12_total * 49 *                                             56   49                                         56
1246580 MD     school 2400090 30   Baltimore City 240009001662 345 Joseph C. Briscoe Academy   Special Education School No High 06 12 2020   pk_12_total * 50                                               57   50                                         57
1319130 MD     school 2400090 30   Baltimore City 240009001662 345 Joseph C. Briscoe Academy   Special Education School No High 06 12 2021   pk_12_total * 50 *               *                             58   50                                         58
1240835 MD     school 2400360 11   Garrett 240036000676 1812 Swan Meadow School   Regular School No Elementary KG 08 2020   pk_12_total 58   *                                             59 58                                           59
1238002 MD     school 2400060 2   Anne Arundel 240006001746 4102 Carrie Weedon Early Education Center   Regular School No Prekindergarten PK PK 2020   pk_12_total 36 * 17     *                                       61 36   17                                       61
1243071 MD     school 2400480 15   Montgomery 240048000867 951 Longview School   Special Education School No Other KG 12 2020   pk_12_total 17 16 21     *                                       61 17 16 21                                       61
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
1239008 MD     school 2400120 3   Baltimore County 240012000346 1215 Battle Monument School   Special Education School No Other PK 12 2020   pk_12_total 30 19 *     *         *                             63 30 19                                         63
1311563 MD     school 2400120 3   Baltimore County 240012000346 1215 Battle Monument School   Special Education School No Other PK 12 2021   pk_12_total 31 19 *     *         *                             63 31 19                                         63
1318401 MD     school 2400090 30   Baltimore City 240009000265 86 Lakewood Elementary   Regular School No Elementary PK KG 2021   pk_12_total * 51 *     *         *                             63   51                                         63
1238229 MD     school 2400120 3   Baltimore County 240012000831 72 Rosedale Center   Alternative School No High 06 12 2020   pk_12_total 21 36 *               *                             65 21 36                                         65
1243217 MD     school 2400510 16   Prince George's 240051001463 303 Croom High   Alternative School No High 11 12 2020   pk_12_total   62 *               *                             65   62                                         65
1312777 MD     school 2400270 8   Charles 240027001395 708 Robert D. Stethem Educational Center   Alternative School No High 07 12 2021   pk_12_total 22 34 *               *                             65 22 34                                         65
1315651 MD     school 2400480 15   Montgomery 240048000867 951 Longview School   Special Education School No Other KG 12 2021   pk_12_total 18 16 25     *                                       65 18 16 25                                       65
1239764 MD     school 2400210 6   Carroll 240021001548 716 Gateway School   Alternative School No High 09 12 2020   pk_12_total 54 * *   * *         *                             66 54                                           66
1317154 MD     school 2400510 16   Prince George's 240051001067 2220 Community Based Classrooms   Alternative School No High 12 12 2021   pk_12_total   37 27     *         *                             68   37 27                                       68
1246696 MD     school 2400090 30   Baltimore City 240009001752 385 Baltimore International Academy West   Regular School Yes Elementary 06 06 2020   pk_12_total   67 *               *                             69   67                                         69
1313151 MD     school 2400330 10   Frederick 240033000648 1001 Sabillasville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 60 * *               *                             70 60                                           70
1313289 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2021   pk_12_total 39 16 11               *                             71 39 16 11                                       71
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
1317027 MD     school 2400510 16   Prince George's 240051001419 2012 Margaret Brent Regional Center   Special Education School No Elementary KG 08 2021   pk_12_total * 40 28     *         *                             72   40 28                                       72
1240736 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   pk_12_total 43 13 12     *         *                             74 43 13 12                                       74
1241005 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 08 12 2020   pk_12_total 26 37 *     *         *                             74 26 37                                         74
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
1311380 MD     school 2400120 3   Baltimore County 240012001435 923 White Oak School   Special Education School No Elementary PK 05 2021   pk_12_total 30 33 *     *         *                             75 30 33                                         75
1242972 MD     school 2400480 15   Montgomery 240048000496 799 Stephen Knolls School   Special Education School No Other PK 12 2020   pk_12_total 15 23 33     *         *                             76 15 23 33                                       76
1240598 MD     school 2400330 10   Frederick 240033000648 1001 Sabillasville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 75 * *               *                             82 75                                           82
1245836 MD     school 2400090 30   Baltimore City 240009000265 86 Lakewood Elementary   Regular School No Elementary PK KG 2020   pk_12_total   73 *               *                             83   73                                         83
1315785 MD     school 2400510 16   Prince George's 240051000865 216 Annapolis Road Academy   Alternative School No Secondary 09 10 2021   pk_12_total   33 48     *         *                             83   33 48                                       83
1315637 MD     school 2400480 15   Montgomery 240048001460 916 Rock Terrace School   Special Education School No High 06 12 2021   pk_12_total 23 24 22     11         *                             84 23 24 22     11                                 84
1317515 MD     school 2400630 20   Talbot 240063001250 501 Tilghman Elementary   Regular School No Elementary PK 05 2021   pk_12_total 81   *               *                             86 81                                           86
1317849 MD     school 2400690 22   Wicomico 240069001088 520 Wicomico County Evening High   Alternative School No High 09 12 2021   pk_12_total 24 46 11               *                             86 24 46 11                                       86

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