enrollments

Data source: Big Local News · About: Big Local

19,213 rows where state = "MD" sorted by ccd_school_high_grade 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
1238001 1238001 MD     school 2400060 2   Anne Arundel 240006001746 4102 Carrie Weedon Early Education Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   61                                             61
1238002 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
1242616 1242616 MD     school 2400480 15   Montgomery 240048001635 587 PEP - Itinerant   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   100                                             100
1242617 1242617 MD     school 2400480 15   Montgomery 240048001635 587 PEP - Itinerant   Special Education School No Prekindergarten PK PK 2020   pk_12_total 43 18 16   * 16         *                             100 43 18 16     16                                 100
1243106 1243106 MD     school 2400510 16   Prince George's 240051001134 107 Frances Fuchs Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   324                                             324
1243107 1243107 MD     school 2400510 16   Prince George's 240051001134 107 Frances Fuchs Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   pk_12_total 18 120 167   * 14         *                             324 18 120 167     14                                 324
1243859 1243859 MD     school 2400510 16   Prince George's 240051001731 1313 Kenmoor Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   288                                             288
1243860 1243860 MD     school 2400510 16   Prince George's 240051001731 1313 Kenmoor Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   pk_12_total 12 127 141   * *                                       288 12 127 141                                       288
1244039 1244039 MD     school 2400510 16   Prince George's 240051001003 1433 Chapel Forge Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   254                                             254
1244040 1244040 MD     school 2400510 16   Prince George's 240051001003 1433 Chapel Forge Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   pk_12_total 14 178 43   * 12         *                             254 14 178 43     12                                 254
1244325 1244325 MD     school 2400510 16   Prince George's 240051001053 1822 H. W. Wheatley Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   301                                             301
1244326 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
1244577 1244577 MD     school 2400510 16   Prince George's 240051001476 2300 Prekindergarten Offsites   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   16                                             16
1244578 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
1309951 1309951 MD     school 2400060 2   Anne Arundel 240006000066 1102 Ferndale Early Education Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   87                                             87
1309952 1309952 MD     school 2400060 2   Anne Arundel 240006000066 1102 Ferndale Early Education Center   Regular School No Prekindergarten PK PK 2021   pk_12_total 30 19 21     12         *                             87 30 19 21     12                                 87
1310565 1310565 MD     school 2400060 2   Anne Arundel 240006001746 4102 Carrie Weedon Early Education Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   62                                             62
1310566 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
1315193 1315193 MD     school 2400480 15   Montgomery 240048001635 587 PEP - Itinerant   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten                                                   40                                             40
1315194 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
1315686 1315686 MD     school 2400510 16   Prince George's 240051001134 107 Frances Fuchs Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten                                                   249                                             249
1315687 1315687 MD     school 2400510 16   Prince George's 240051001134 107 Frances Fuchs Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total 11 100 117   * 14     *   *                             249 11 100 117     14                                 249
1316187 1316187 MD     school 2400510 16   Prince George's 240051001763 918 James Ryder Randall Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten                                                   88                                             88
1316188 1316188 MD     school 2400510 16   Prince George's 240051001763 918 James Ryder Randall Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total * 57 17     *         *                             88   57 17                                       88
1316440 1316440 MD     school 2400510 16   Prince George's 240051001731 1313 Kenmoor Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten                                                   122                                             122
1316441 1316441 MD     school 2400510 16   Prince George's 240051001731 1313 Kenmoor Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total * 53 60   * *         *                             122   53 60                                       122
1316620 1316620 MD     school 2400510 16   Prince George's 240051001003 1433 Chapel Forge Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten                                                   228                                             228
1316621 1316621 MD     school 2400510 16   Prince George's 240051001003 1433 Chapel Forge Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total 17 162 31     10         *                             228 17 162 31     10                                 228
1316906 1316906 MD     school 2400510 16   Prince George's 240051001053 1822 H. W. Wheatley Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten                                                   261                                             261
1316907 1316907 MD     school 2400510 16   Prince George's 240051001053 1822 H. W. Wheatley Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total * 212 30     *         *                             261   212 30                                       261
1317155 1317155 MD     school 2400510 16   Prince George's 240051001476 2300 Prekindergarten Offsites   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   *                                              
1317156 1317156 MD     school 2400510 16   Prince George's 240051001476 2300 Prekindergarten Offsites   Regular School No Prekindergarten PK PK 2021   pk_12_total * * *                                             *                                              
1237390 1237390 MD     school 2400060 2   Anne Arundel 240006000066 1102 Ferndale Early Education Center   Regular School No Elementary PK KG 2020   pre_kindergarten                                                   98                                             98
1237391 1237391 MD     school 2400060 2   Anne Arundel 240006000066 1102 Ferndale Early Education Center   Regular School No Elementary PK KG 2020   kindergarten                                                   53                                             53
1237392 1237392 MD     school 2400060 2   Anne Arundel 240006000066 1102 Ferndale Early Education Center   Regular School No Elementary PK KG 2020   pk_12_total 76 33 28   * *         *                             151 76 33 28                                       151
1237856 1237856 MD     school 2400060 2   Anne Arundel 240006000140 3232 West Meade Early Education Center   Regular School No Elementary PK KG 2020   pre_kindergarten                                                   76                                             76
1237857 1237857 MD     school 2400060 2   Anne Arundel 240006000140 3232 West Meade Early Education Center   Regular School No Elementary PK KG 2020   kindergarten                                                   180                                             180
1237858 1237858 MD     school 2400060 2   Anne Arundel 240006000140 3232 West Meade Early Education Center   Regular School No Elementary PK KG 2020   pk_12_total 123 33 64   * 14         21                             256 123 33 64     14         21                       256
1238211 1238211 MD     school 2400120 3   Baltimore County 240012000012 62 Campfield Early Childhood Center   Regular School No Elementary PK KG 2020   pre_kindergarten                                                   264                                             264
1238212 1238212 MD     school 2400120 3   Baltimore County 240012000012 62 Campfield Early Childhood Center   Regular School No Elementary PK KG 2020   kindergarten                                                   146                                             146
1238213 1238213 MD     school 2400120 3   Baltimore County 240012000012 62 Campfield Early Childhood Center   Regular School No Elementary PK KG 2020   pk_12_total 27 273 64   * 25         19                             410 27 273 64     25         19                       410
1245834 1245834 MD     school 2400090 30   Baltimore City 240009000265 86 Lakewood Elementary   Regular School No Elementary PK KG 2020   pre_kindergarten                                                   71                                             71
1245835 1245835 MD     school 2400090 30   Baltimore City 240009000265 86 Lakewood Elementary   Regular School No Elementary PK KG 2020   kindergarten                                                   12                                             12
1245836 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
1310421 1310421 MD     school 2400060 2   Anne Arundel 240006000140 3232 West Meade Early Education Center   Regular School No Elementary PK KG 2021   pre_kindergarten                                                   64                                             64
1310422 1310422 MD     school 2400060 2   Anne Arundel 240006000140 3232 West Meade Early Education Center   Regular School No Elementary PK KG 2021   kindergarten                                                   146                                             146
1310423 1310423 MD     school 2400060 2   Anne Arundel 240006000140 3232 West Meade Early Education Center   Regular School No Elementary PK KG 2021   pk_12_total 119 29 42   * *     *   15                             210 119 29 42               15                       210
1310766 1310766 MD     school 2400120 3   Baltimore County 240012000012 62 Campfield Early Childhood Center   Regular School No Elementary PK KG 2021   pre_kindergarten                                                   209                                             209
1310767 1310767 MD     school 2400120 3   Baltimore County 240012000012 62 Campfield Early Childhood Center   Regular School No Elementary PK KG 2021   kindergarten                                                   124                                             124
1310768 1310768 MD     school 2400120 3   Baltimore County 240012000012 62 Campfield Early Childhood Center   Regular School No Elementary PK KG 2021   pk_12_total 24 235 36   * 22         15                             333 24 235 36     22         15                       333
1318399 1318399 MD     school 2400090 30   Baltimore City 240009000265 86 Lakewood Elementary   Regular School No Elementary PK KG 2021   pre_kindergarten                                                   50                                             50
1318400 1318400 MD     school 2400090 30   Baltimore City 240009000265 86 Lakewood Elementary   Regular School No Elementary PK KG 2021   kindergarten                                                   13                                             13
1318401 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
1237231 1237231 MD     school 2400030 1   Allegany 240003000015 405 Fort Hill High   Regular School No High 09 12 2020   grade_9                                                   181                                             181
1237232 1237232 MD     school 2400030 1   Allegany 240003000015 405 Fort Hill High   Regular School No High 09 12 2020   grade_10                                                   167                                             167
1237233 1237233 MD     school 2400030 1   Allegany 240003000015 405 Fort Hill High   Regular School No High 09 12 2020   grade_11                                                   154                                             154
1237234 1237234 MD     school 2400030 1   Allegany 240003000015 405 Fort Hill High   Regular School No High 09 12 2020   grade_12                                                   170                                             170
1237235 1237235 MD     school 2400030 1   Allegany 240003000015 405 Fort Hill High   Regular School No High 09 12 2020   pk_12_total 578 38 10     *         44                             672 578 38 10               44                       672
1237252 1237252 MD     school 2400030 1   Allegany 240003000030 601 Center for Career & Technical Education   Career and Technical School No High 11 12 2020   grade_11                                                   126                                             126
1237253 1237253 MD     school 2400030 1   Allegany 240003000030 601 Center for Career & Technical Education   Career and Technical School No High 11 12 2020   grade_12                                                   77                                             77
1237254 1237254 MD     school 2400030 1   Allegany 240003000030 601 Center for Career & Technical Education   Career and Technical School No High 11 12 2020   pk_12_total 193   *               *                             203 193                                           203
1237263 1237263 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2020   grade_9                                                   168                                             168
1237264 1237264 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2020   grade_10                                                   210                                             210
1237265 1237265 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2020   grade_11                                                   170                                             170
1237266 1237266 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2020   grade_12                                                   173                                             173
1237267 1237267 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2020   pk_12_total 631 21 15   * 11         41                             721 631 21 15     11         41                       721
1237324 1237324 MD     school 2400030 1   Allegany 240003001636 2404 Mountain Ridge High School   Regular School No High 09 12 2020   grade_9                                                   223                                             223
1237325 1237325 MD     school 2400030 1   Allegany 240003001636 2404 Mountain Ridge High School   Regular School No High 09 12 2020   grade_10                                                   228                                             228
1237326 1237326 MD     school 2400030 1   Allegany 240003001636 2404 Mountain Ridge High School   Regular School No High 09 12 2020   grade_11                                                   161                                             161
1237327 1237327 MD     school 2400030 1   Allegany 240003001636 2404 Mountain Ridge High School   Regular School No High 09 12 2020   grade_12                                                   172                                             172
1237328 1237328 MD     school 2400030 1   Allegany 240003001636 2404 Mountain Ridge High School   Regular School No High 09 12 2020   pk_12_total 729 17 *   * *         24                             784 729 17                 24                       784
1237357 1237357 MD     school 2400060 2   Anne Arundel 240006000075 1033 Glen Burnie High   Regular School No High 09 12 2020   grade_9                                                   580                                             580
1237358 1237358 MD     school 2400060 2   Anne Arundel 240006000075 1033 Glen Burnie High   Regular School No High 09 12 2020   grade_10                                                   558                                             558
1237359 1237359 MD     school 2400060 2   Anne Arundel 240006000075 1033 Glen Burnie High   Regular School No High 09 12 2020   grade_11                                                   522                                             522
1237360 1237360 MD     school 2400060 2   Anne Arundel 240006000075 1033 Glen Burnie High   Regular School No High 09 12 2020   grade_12                                                   416                                             416
1237361 1237361 MD     school 2400060 2   Anne Arundel 240006000075 1033 Glen Burnie High   Regular School No High 09 12 2020   pk_12_total 812 624 420   * 86     *   120                             2076 812 624 420     86         120                       2076
1237515 1237515 MD     school 2400060 2   Anne Arundel 240006090441 1323 North County High   Regular School No High 09 12 2020   grade_9                                                   635                                             635
1237516 1237516 MD     school 2400060 2   Anne Arundel 240006090441 1323 North County High   Regular School No High 09 12 2020   grade_10                                                   605                                             605
1237517 1237517 MD     school 2400060 2   Anne Arundel 240006090441 1323 North County High   Regular School No High 09 12 2020   grade_11                                                   534                                             534
1237518 1237518 MD     school 2400060 2   Anne Arundel 240006090441 1323 North County High   Regular School No High 09 12 2020   grade_12                                                   512                                             512
1237519 1237519 MD     school 2400060 2   Anne Arundel 240006090441 1323 North County High   Regular School No High 09 12 2020   pk_12_total 1017 593 414   * 119     *   133                             2286 1017 593 414     119         133                       2286
1237520 1237520 MD     school 2400060 2   Anne Arundel 240006000127 2013 Severna Park High   Regular School No High 09 12 2020   grade_9                                                   520                                             520
1237521 1237521 MD     school 2400060 2   Anne Arundel 240006000127 2013 Severna Park High   Regular School No High 09 12 2020   grade_10                                                   472                                             472
1237522 1237522 MD     school 2400060 2   Anne Arundel 240006000127 2013 Severna Park High   Regular School No High 09 12 2020   grade_11                                                   502                                             502
1237523 1237523 MD     school 2400060 2   Anne Arundel 240006000127 2013 Severna Park High   Regular School No High 09 12 2020   grade_12                                                   438                                             438
1237524 1237524 MD     school 2400060 2   Anne Arundel 240006000127 2013 Severna Park High   Regular School No High 09 12 2020   pk_12_total 1589 77 97   * 81     *   84                             1932 1589 77 97     81         84                       1932
1237525 1237525 MD     school 2400060 2   Anne Arundel 240006000103 2023 Northeast High   Regular School No High 09 12 2020   grade_9                                                   322                                             322
1237526 1237526 MD     school 2400060 2   Anne Arundel 240006000103 2023 Northeast High   Regular School No High 09 12 2020   grade_10                                                   346                                             346
1237527 1237527 MD     school 2400060 2   Anne Arundel 240006000103 2023 Northeast High   Regular School No High 09 12 2020   grade_11                                                   367                                             367
1237528 1237528 MD     school 2400060 2   Anne Arundel 240006000103 2023 Northeast High   Regular School No High 09 12 2020   grade_12                                                   332                                             332
1237529 1237529 MD     school 2400060 2   Anne Arundel 240006000103 2023 Northeast High   Regular School No High 09 12 2020   pk_12_total 996 123 133   * 34     *   72                             1367 996 123 133     34         72                       1367
1237666 1237666 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2020   grade_9                                                   20                                             20
1237667 1237667 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2020   grade_10                                                   50                                             50
1237668 1237668 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2020   grade_11                                                   79                                             79
1237669 1237669 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2020   grade_12                                                   147                                             147
1237670 1237670 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2020   pk_12_total 150 66 55   * *         22                             296 150 66 55               22                       296
1237675 1237675 MD     school 2400060 2   Anne Arundel 240006000058 2273 Chesapeake High   Regular School No High 09 12 2020   grade_9                                                   382                                             382
1237676 1237676 MD     school 2400060 2   Anne Arundel 240006000058 2273 Chesapeake High   Regular School No High 09 12 2020   grade_10                                                   357                                             357
1237677 1237677 MD     school 2400060 2   Anne Arundel 240006000058 2273 Chesapeake High   Regular School No High 09 12 2020   grade_11                                                   333                                             333
1237678 1237678 MD     school 2400060 2   Anne Arundel 240006000058 2273 Chesapeake High   Regular School No High 09 12 2020   grade_12                                                   316                                             316

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