enrollments

Data source: Big Local News · About: Big Local

19,213 rows where state = "MD" sorted by ccd_school_lvl 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
1243203 1243203 MD     school 2400510 16   Prince George's 240051000865 216 Annapolis Road Academy   Alternative School No Secondary 09 10 2020   grade_9                                                   94                                             94
1243204 1243204 MD     school 2400510 16   Prince George's 240051000865 216 Annapolis Road Academy   Alternative School No Secondary 09 10 2020   grade_10                                                   26                                             26
1243205 1243205 MD     school 2400510 16   Prince George's 240051000865 216 Annapolis Road Academy   Alternative School No Secondary 09 10 2020   pk_12_total   66 51               *                             120   66 51                                       120
1243294 1243294 MD     school 2400510 16   Prince George's 240051001047 608 Green Valley Academy at Edgar Allan Poe   Alternative School No Secondary 07 10 2020   grade_7                                                   *                                              
1243295 1243295 MD     school 2400510 16   Prince George's 240051001047 608 Green Valley Academy at Edgar Allan Poe   Alternative School No Secondary 07 10 2020   grade_8                                                   *                                              
1243296 1243296 MD     school 2400510 16   Prince George's 240051001047 608 Green Valley Academy at Edgar Allan Poe   Alternative School No Secondary 07 10 2020   grade_9                                                   22                                             22
1243297 1243297 MD     school 2400510 16   Prince George's 240051001047 608 Green Valley Academy at Edgar Allan Poe   Alternative School No Secondary 07 10 2020   grade_10                                                   12                                             12
1243298 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
1244573 1244573 MD     school 2400510 16   Prince George's 240051001755 2218 Career and Technical Education Evening High   Career and Technical School No Secondary 11 11 2020   grade_11                                                   15                                             15
1244574 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
1310297 1310297 MD     school 2400060 2   Anne Arundel 240006001761 3063 Crofton High School   Regular School No Secondary 09 10 2021   grade_9                                                   419                                             419
1310298 1310298 MD     school 2400060 2   Anne Arundel 240006001761 3063 Crofton High School   Regular School No Secondary 09 10 2021   grade_10                                                   364                                             364
1310299 1310299 MD     school 2400060 2   Anne Arundel 240006001761 3063 Crofton High School   Regular School No Secondary 09 10 2021   pk_12_total 458 146 75   * 51     *   47                             783 458 146 75     51         47                       783
1315783 1315783 MD     school 2400510 16   Prince George's 240051000865 216 Annapolis Road Academy   Alternative School No Secondary 09 10 2021   grade_9                                                   27                                             27
1315784 1315784 MD     school 2400510 16   Prince George's 240051000865 216 Annapolis Road Academy   Alternative School No Secondary 09 10 2021   grade_10                                                   56                                             56
1315785 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
1315876 1315876 MD     school 2400510 16   Prince George's 240051001047 608 Green Valley Academy at Edgar Allan Poe   Alternative School No Secondary 07 10 2021   grade_7                                                   *                                              
1315877 1315877 MD     school 2400510 16   Prince George's 240051001047 608 Green Valley Academy at Edgar Allan Poe   Alternative School No Secondary 07 10 2021   grade_8                                                   12                                             12
1315878 1315878 MD     school 2400510 16   Prince George's 240051001047 608 Green Valley Academy at Edgar Allan Poe   Alternative School No Secondary 07 10 2021   grade_9                                                   22                                             22
1315879 1315879 MD     school 2400510 16   Prince George's 240051001047 608 Green Valley Academy at Edgar Allan Poe   Alternative School No Secondary 07 10 2021   grade_10                                                   21                                             21
1315880 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
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 * * *                                             *                                              
1237501 1237501 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   pre_kindergarten                                                   89                                             89
1237502 1237502 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   kindergarten                                                   16                                             16
1237503 1237503 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   grade_1                                                   *                                              
1237504 1237504 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   grade_2                                                   *                                              
1237505 1237505 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   grade_3                                                   *                                              
1237506 1237506 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   grade_4                                                   *                                              
1237507 1237507 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   grade_5                                                   *                                              
1237508 1237508 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   grade_6                                                   *                                              
1237509 1237509 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   grade_7                                                   *                                              
1237510 1237510 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   grade_8                                                   *                                              
1237511 1237511 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   grade_9                                                   *                                              
1237512 1237512 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   grade_10                                                   *                                              
1237513 1237513 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   grade_11                                                   *                                              
1237514 1237514 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   pk_12_total 91 32 15   * 11     *   *                             160 91 32 15     11                                 160
1237934 1237934 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   pre_kindergarten                                                   38                                             38
1237935 1237935 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   kindergarten                                                   17                                             17
1237936 1237936 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   grade_1                                                   12                                             12
1237937 1237937 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   grade_2                                                   *                                              
1237938 1237938 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   grade_3                                                   *                                              
1237939 1237939 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   grade_4                                                   *                                              
1237940 1237940 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   grade_5                                                   *                                              
1237941 1237941 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   grade_6                                                   14                                             14
1237942 1237942 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   grade_7                                                   *                                              
1237943 1237943 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   grade_8                                                   *                                              
1237944 1237944 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   grade_9                                                   *                                              
1237945 1237945 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   grade_10                                                   *                                              
1237946 1237946 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   grade_11                                                   11                                             11
1237947 1237947 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   grade_12                                                   *                                              
1237948 1237948 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   pk_12_total 51 63 19     *         *                             143 51 63 19                                       143
1237979 1237979 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other KG 12 2020   kindergarten                                                   *                                              
1237980 1237980 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other KG 12 2020   grade_1                                                   *                                              
1237981 1237981 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other KG 12 2020   grade_2                                                   17                                             17
1237982 1237982 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other KG 12 2020   grade_3                                                   25                                             25
1237983 1237983 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other KG 12 2020   grade_4                                                   23                                             23
1237984 1237984 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other KG 12 2020   grade_5                                                   25                                             25
1237985 1237985 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other KG 12 2020   grade_6                                                   25                                             25
1237986 1237986 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other KG 12 2020   grade_7                                                   35                                             35
1237987 1237987 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other KG 12 2020   grade_8                                                   27                                             27
1237988 1237988 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other KG 12 2020   grade_9                                                   31                                             31
1237989 1237989 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other KG 12 2020   grade_10                                                   73                                             73
1237990 1237990 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other KG 12 2020   grade_11                                                   29                                             29
1237991 1237991 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other KG 12 2020   grade_12                                                   25                                             25
1237992 1237992 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other KG 12 2020   pk_12_total 131 164 27   *           22                             347 131 164 27               22                       347
1238133 1238133 MD     school 2400060 2   Anne Arundel 240006000056 4304 Central Special School   Special Education School No Other PK 12 2020   pre_kindergarten                                                   73                                             73
1238134 1238134 MD     school 2400060 2   Anne Arundel 240006000056 4304 Central Special School   Special Education School No Other PK 12 2020   kindergarten                                                   *                                              
1238135 1238135 MD     school 2400060 2   Anne Arundel 240006000056 4304 Central Special School   Special Education School No Other PK 12 2020   grade_1                                                   *                                              
1238136 1238136 MD     school 2400060 2   Anne Arundel 240006000056 4304 Central Special School   Special Education School No Other PK 12 2020   grade_2                                                   *                                              

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