enrollments

Data source: Big Local News · About: Big Local

19,213 rows where state = "MD" sorted by ccd_school_type

✎ 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
1240224 1240224 MD     school 2400270 8   Charles 240027001395 708 Robert D. Stethem Educational Center   Alternative School No High 06 12 2020   grade_7                                                   *                                              
1240225 1240225 MD     school 2400270 8   Charles 240027001395 708 Robert D. Stethem Educational Center   Alternative School No High 06 12 2020   grade_8                                                   10                                             10
1240226 1240226 MD     school 2400270 8   Charles 240027001395 708 Robert D. Stethem Educational Center   Alternative School No High 06 12 2020   grade_9                                                   *                                              
1240227 1240227 MD     school 2400270 8   Charles 240027001395 708 Robert D. Stethem Educational Center   Alternative School No High 06 12 2020   grade_10                                                   20                                             20
1240228 1240228 MD     school 2400270 8   Charles 240027001395 708 Robert D. Stethem Educational Center   Alternative School No High 06 12 2020   grade_11                                                   17                                             17
1240229 1240229 MD     school 2400270 8   Charles 240027001395 708 Robert D. Stethem Educational Center   Alternative School No High 06 12 2020   grade_12                                                   31                                             31
1240230 1240230 MD     school 2400270 8   Charles 240027001395 708 Robert D. Stethem Educational Center   Alternative School No High 06 12 2020   pk_12_total 25 53 *   *       *   *                             88 25 53                                         88
1240381 1240381 MD     school 2400330 10   Frederick 240033001410 208 Heather Ridge   Alternative School No High 06 12 2020   grade_6                                                   *                                              
1240382 1240382 MD     school 2400330 10   Frederick 240033001410 208 Heather Ridge   Alternative School No High 06 12 2020   grade_7                                                   *                                              
1240383 1240383 MD     school 2400330 10   Frederick 240033001410 208 Heather Ridge   Alternative School No High 06 12 2020   grade_8                                                   *                                              
1240384 1240384 MD     school 2400330 10   Frederick 240033001410 208 Heather Ridge   Alternative School No High 06 12 2020   grade_9                                                   18                                             18
1240385 1240385 MD     school 2400330 10   Frederick 240033001410 208 Heather Ridge   Alternative School No High 06 12 2020   grade_10                                                   *                                              
1240386 1240386 MD     school 2400330 10   Frederick 240033001410 208 Heather Ridge   Alternative School No High 06 12 2020   grade_11                                                   *                                              
1240387 1240387 MD     school 2400330 10   Frederick 240033001410 208 Heather Ridge   Alternative School No High 06 12 2020   grade_12                                                   *                                              
1240388 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
1241000 1241000 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 08 12 2020   grade_8                                                   *                                              
1241001 1241001 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 08 12 2020   grade_9                                                   35                                             35
1241002 1241002 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 08 12 2020   grade_10                                                   15                                             15
1241003 1241003 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 08 12 2020   grade_11                                                   11                                             11
1241004 1241004 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 08 12 2020   grade_12                                                   12                                             12
1241005 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
1241219 1241219 MD     school 2400420 13   Howard 240042001189 80 Homewood School   Alternative School No High 06 12 2020   grade_6                                                   *                                              
1241220 1241220 MD     school 2400420 13   Howard 240042001189 80 Homewood School   Alternative School No High 06 12 2020   grade_7                                                   *                                              
1241221 1241221 MD     school 2400420 13   Howard 240042001189 80 Homewood School   Alternative School No High 06 12 2020   grade_8                                                   12                                             12
1241222 1241222 MD     school 2400420 13   Howard 240042001189 80 Homewood School   Alternative School No High 06 12 2020   grade_9                                                   34                                             34
1241223 1241223 MD     school 2400420 13   Howard 240042001189 80 Homewood School   Alternative School No High 06 12 2020   grade_10                                                   38                                             38
1241224 1241224 MD     school 2400420 13   Howard 240042001189 80 Homewood School   Alternative School No High 06 12 2020   grade_11                                                   19                                             19
1241225 1241225 MD     school 2400420 13   Howard 240042001189 80 Homewood School   Alternative School No High 06 12 2020   grade_12                                                   13                                             13
1241226 1241226 MD     school 2400420 13   Howard 240042001189 80 Homewood School   Alternative School No High 06 12 2020   pk_12_total 30 70 14   * *         *                             122 30 70 14                                       122
1242023 1242023 MD     school 2400480 15   Montgomery 240048001451 239 Alternative Programs   Alternative School No High 07 12 2020   grade_7                                                   *                                              
1242024 1242024 MD     school 2400480 15   Montgomery 240048001451 239 Alternative Programs   Alternative School No High 07 12 2020   grade_8                                                   *                                              
1242025 1242025 MD     school 2400480 15   Montgomery 240048001451 239 Alternative Programs   Alternative School No High 07 12 2020   grade_9                                                   35                                             35
1242026 1242026 MD     school 2400480 15   Montgomery 240048001451 239 Alternative Programs   Alternative School No High 07 12 2020   grade_10                                                   32                                             32
1242027 1242027 MD     school 2400480 15   Montgomery 240048001451 239 Alternative Programs   Alternative School No High 07 12 2020   grade_11                                                   27                                             27
1242028 1242028 MD     school 2400480 15   Montgomery 240048001451 239 Alternative Programs   Alternative School No High 07 12 2020   grade_12                                                   24                                             24
1242029 1242029 MD     school 2400480 15   Montgomery 240048001451 239 Alternative Programs   Alternative School No High 07 12 2020   pk_12_total 10 63 43     *         *                             126 10 63 43                                       126
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
1243215 1243215 MD     school 2400510 16   Prince George's 240051001463 303 Croom High   Alternative School No High 11 12 2020   grade_11                                                   *                                              
1243216 1243216 MD     school 2400510 16   Prince George's 240051001463 303 Croom High   Alternative School No High 11 12 2020   grade_12                                                   58                                             58
1243217 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
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
1243465 1243465 MD     school 2400510 16   Prince George's 240051001424 705 Tall Oaks High   Alternative School No High 11 12 2020   grade_11                                                   27                                             27
1243466 1243466 MD     school 2400510 16   Prince George's 240051001424 705 Tall Oaks High   Alternative School No High 11 12 2020   grade_12                                                   68                                             68
1243467 1243467 MD     school 2400510 16   Prince George's 240051001424 705 Tall Oaks High   Alternative School No High 11 12 2020   pk_12_total * 63 25   * *                                       95   63 25                                       95
1244558 1244558 MD     school 2400510 16   Prince George's 240051001054 2211 Northwestern Evening/Saturday High   Alternative School No High 09 12 2020   grade_9                                                   132                                             132
1244559 1244559 MD     school 2400510 16   Prince George's 240051001054 2211 Northwestern Evening/Saturday High   Alternative School No High 09 12 2020   grade_10                                                   133                                             133
1244560 1244560 MD     school 2400510 16   Prince George's 240051001054 2211 Northwestern Evening/Saturday High   Alternative School No High 09 12 2020   grade_11                                                   96                                             96
1244561 1244561 MD     school 2400510 16   Prince George's 240051001054 2211 Northwestern Evening/Saturday High   Alternative School No High 09 12 2020   grade_12                                                   120                                             120
1244562 1244562 MD     school 2400510 16   Prince George's 240051001054 2211 Northwestern Evening/Saturday High   Alternative School No High 09 12 2020   pk_12_total * 64 401   * *         *                             481   64 401                                       481
1244563 1244563 MD     school 2400510 16   Prince George's 240051001062 2213 Crossland Evening/Saturday High   Alternative School No High 09 12 2020   grade_9                                                   30                                             30
1244564 1244564 MD     school 2400510 16   Prince George's 240051001062 2213 Crossland Evening/Saturday High   Alternative School No High 09 12 2020   grade_10                                                   49                                             49
1244565 1244565 MD     school 2400510 16   Prince George's 240051001062 2213 Crossland Evening/Saturday High   Alternative School No High 09 12 2020   grade_11                                                   31                                             31
1244566 1244566 MD     school 2400510 16   Prince George's 240051001062 2213 Crossland Evening/Saturday High   Alternative School No High 09 12 2020   grade_12                                                   118                                             118
1244567 1244567 MD     school 2400510 16   Prince George's 240051001062 2213 Crossland Evening/Saturday High   Alternative School No High 09 12 2020   pk_12_total * 185 33   *           *                             228   185 33                                       228
1244575 1244575 MD     school 2400510 16   Prince George's 240051001067 2220 Community Based Classrooms   Alternative School No High 12 12 2020   grade_12                                                   75                                             75
1244576 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
1245269 1245269 MD     school 2400690 22   Wicomico 240069001088 520 Wicomico County Evening High   Alternative School No High 09 12 2020   grade_9                                                   20                                             20
1245270 1245270 MD     school 2400690 22   Wicomico 240069001088 520 Wicomico County Evening High   Alternative School No High 09 12 2020   grade_10                                                   23                                             23
1245271 1245271 MD     school 2400690 22   Wicomico 240069001088 520 Wicomico County Evening High   Alternative School No High 09 12 2020   grade_11                                                   28                                             28
1245272 1245272 MD     school 2400690 22   Wicomico 240069001088 520 Wicomico County Evening High   Alternative School No High 09 12 2020   grade_12                                                   36                                             36
1245273 1245273 MD     school 2400690 22   Wicomico 240069001088 520 Wicomico County Evening High   Alternative School No High 09 12 2020   pk_12_total 38 55 10     *         *                             107 38 55 10                                       107
1245980 1245980 MD     school 2400090 30   Baltimore City 240009001343 178 Excel Academy at Francis M. Wood High   Alternative School No High 08 12 2020   grade_8                                                   *                                              
1245981 1245981 MD     school 2400090 30   Baltimore City 240009001343 178 Excel Academy at Francis M. Wood High   Alternative School No High 08 12 2020   grade_9                                                   179                                             179
1245982 1245982 MD     school 2400090 30   Baltimore City 240009001343 178 Excel Academy at Francis M. Wood High   Alternative School No High 08 12 2020   grade_10                                                   200                                             200
1245983 1245983 MD     school 2400090 30   Baltimore City 240009001343 178 Excel Academy at Francis M. Wood High   Alternative School No High 08 12 2020   grade_11                                                   125                                             125
1245984 1245984 MD     school 2400090 30   Baltimore City 240009001343 178 Excel Academy at Francis M. Wood High   Alternative School No High 08 12 2020   grade_12                                                   134                                             134
1245985 1245985 MD     school 2400090 30   Baltimore City 240009001343 178 Excel Academy at Francis M. Wood High   Alternative School No High 08 12 2020   pk_12_total * 620 10   *           *                             642   620 10                                       642
1246727 1246727 MD     school 2400090 30   Baltimore City 240009000236 413 Achievement Academy at Harbor City High   Alternative School No High 09 12 2020   grade_9                                                   133                                             133
1246728 1246728 MD     school 2400090 30   Baltimore City 240009000236 413 Achievement Academy at Harbor City High   Alternative School No High 09 12 2020   grade_10                                                   150                                             150
1246729 1246729 MD     school 2400090 30   Baltimore City 240009000236 413 Achievement Academy at Harbor City High   Alternative School No High 09 12 2020   grade_11                                                   79                                             79
1246730 1246730 MD     school 2400090 30   Baltimore City 240009000236 413 Achievement Academy at Harbor City High   Alternative School No High 09 12 2020   grade_12                                                   71                                             71
1246731 1246731 MD     school 2400090 30   Baltimore City 240009000236 413 Achievement Academy at Harbor City High   Alternative School No High 09 12 2020   pk_12_total * 404 26   *                                         433   404 26                                       433
1246808 1246808 MD     school 2400090 30   Baltimore City 240009000885 884 Eager Street Academy   Alternative School No High 08 12 2020   grade_8                                                   *                                              
1246809 1246809 MD     school 2400090 30   Baltimore City 240009000885 884 Eager Street Academy   Alternative School No High 08 12 2020   grade_9                                                   19                                             19
1246810 1246810 MD     school 2400090 30   Baltimore City 240009000885 884 Eager Street Academy   Alternative School No High 08 12 2020   grade_10                                                   16                                             16
1246811 1246811 MD     school 2400090 30   Baltimore City 240009000885 884 Eager Street Academy   Alternative School No High 08 12 2020   grade_11                                                   *                                              
1246812 1246812 MD     school 2400090 30   Baltimore City 240009000885 884 Eager Street Academy   Alternative School No High 08 12 2020   grade_12                                                   *                                              
1246813 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
1310228 1310228 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2021   grade_9                                                   13                                             13
1310229 1310229 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2021   grade_10                                                   36                                             36
1310230 1310230 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2021   grade_11                                                   71                                             71
1310231 1310231 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2021   grade_12                                                   107                                             107
1310232 1310232 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2021   pk_12_total 106 55 54     *         *                             227 106 55 54                                       227
1310540 1310540 MD     school 2400060 2   Anne Arundel 240006001729 4064 Mary Moss at Adams Academy   Alternative School No Middle 07 09 2021   grade_7                                                   *                                              
1310541 1310541 MD     school 2400060 2   Anne Arundel 240006001729 4064 Mary Moss at Adams Academy   Alternative School No Middle 07 09 2021   grade_8                                                   *                                              
1310542 1310542 MD     school 2400060 2   Anne Arundel 240006001729 4064 Mary Moss at Adams Academy   Alternative School No Middle 07 09 2021   grade_9                                                   30                                             30
1310543 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
1310747 1310747 MD     school 2400120 3   Baltimore County 240012001756 51 Northwest EDLP at Milford Mill Academy   Alternative School No High 10 12 2021   grade_10                                                   *                                              
1310748 1310748 MD     school 2400120 3   Baltimore County 240012001756 51 Northwest EDLP at Milford Mill Academy   Alternative School No High 10 12 2021   grade_12                                                   *                                              
1310749 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   *                                               *                                              
1310750 1310750 MD     school 2400120 3   Baltimore County 240012001751 52 Southwest EDLP at Woodlawn High School   Alternative School No High 11 12 2021   grade_11                                                   *                                              
1310751 1310751 MD     school 2400120 3   Baltimore County 240012001751 52 Southwest EDLP at Woodlawn High School   Alternative School No High 11 12 2021   grade_12                                                   *                                              
1310752 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 * * *                                             *                                              
1310753 1310753 MD     school 2400120 3   Baltimore County 240012001754 53 Northeast EDLP at Parkville High School   Alternative School No High 11 12 2021   grade_11                                                   *                                              

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