Data source: Big Local News · About: Big Local

9,598 rows where state = "MD" and year = 2021 sorted by school_nces_id

View and edit SQL

year

  • 2021 · 7,437
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
1318978 MD     school 2400090 30   Baltimore City 240009001558 262 Empowerment Academy   Regular School Yes Elementary PK 08 2021   grade_7                                                   41                                             41
1318979 MD     school 2400090 30   Baltimore City 240009001558 262 Empowerment Academy   Regular School Yes Elementary PK 08 2021   grade_8                                                   36                                             36
1318980 MD     school 2400090 30   Baltimore City 240009001558 262 Empowerment Academy   Regular School Yes Elementary PK 08 2021   pk_12_total   284 *                                             287   284                                         287
1319305 MD     school 2400090 30   Baltimore City 240009001559 422 New Era Academy   Regular School No High 09 12 2021   grade_9                                                   142                                             142
1319306 MD     school 2400090 30   Baltimore City 240009001559 422 New Era Academy   Regular School No High 09 12 2021   grade_10                                                   112                                             112
1319307 MD     school 2400090 30   Baltimore City 240009001559 422 New Era Academy   Regular School No High 09 12 2021   grade_11                                                   92                                             92
1319308 MD     school 2400090 30   Baltimore City 240009001559 422 New Era Academy   Regular School No High 09 12 2021   grade_12                                                   42                                             42
1319309 MD     school 2400090 30   Baltimore City 240009001559 422 New Era Academy   Regular School No High 09 12 2021   pk_12_total 14 232 141     *                                       388 14 232 141                                       388
1319083 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2021   kindergarten                                                   27                                             27
1319084 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2021   grade_1                                                   29                                             29
1319085 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2021   grade_2                                                   27                                             27
1319086 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2021   grade_3                                                   27                                             27
1319087 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2021   grade_4                                                   27                                             27
1319088 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2021   grade_5                                                   25                                             25
1319089 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2021   pk_12_total 61 68 *               24                             162 61 68                 24                       162
1319095 MD     school 2400090 30   Baltimore City 240009001631 335 Baltimore International Academy   Regular School Yes Elementary KG 08 2021   kindergarten                                                   111                                             111
1319096 MD     school 2400090 30   Baltimore City 240009001631 335 Baltimore International Academy   Regular School Yes Elementary KG 08 2021   grade_1                                                   118                                             118
1319097 MD     school 2400090 30   Baltimore City 240009001631 335 Baltimore International Academy   Regular School Yes Elementary KG 08 2021   grade_2                                                   108                                             108
1319098 MD     school 2400090 30   Baltimore City 240009001631 335 Baltimore International Academy   Regular School Yes Elementary KG 08 2021   grade_3                                                   96                                             96
1319099 MD     school 2400090 30   Baltimore City 240009001631 335 Baltimore International Academy   Regular School Yes Elementary KG 08 2021   grade_4                                                   93                                             93
1319100 MD     school 2400090 30   Baltimore City 240009001631 335 Baltimore International Academy   Regular School Yes Elementary KG 08 2021   grade_5                                                   68                                             68
1319101 MD     school 2400090 30   Baltimore City 240009001631 335 Baltimore International Academy   Regular School Yes Elementary KG 08 2021   grade_6                                                   56                                             56
1319102 MD     school 2400090 30   Baltimore City 240009001631 335 Baltimore International Academy   Regular School Yes Elementary KG 08 2021   grade_7                                                   52                                             52
1319103 MD     school 2400090 30   Baltimore City 240009001631 335 Baltimore International Academy   Regular School Yes Elementary KG 08 2021   grade_8                                                   50                                             50
1319104 MD     school 2400090 30   Baltimore City 240009001631 335 Baltimore International Academy   Regular School Yes Elementary KG 08 2021   pk_12_total 36 645 43   * *     *   25                             752 36 645 43               25                       752
1319090 MD     school 2400090 30   Baltimore City 240009001632 333 Independence School Local I   Regular School Yes High 09 12 2021   grade_9                                                   55                                             55
1319091 MD     school 2400090 30   Baltimore City 240009001632 333 Independence School Local I   Regular School Yes High 09 12 2021   grade_10                                                   39                                             39
1319092 MD     school 2400090 30   Baltimore City 240009001632 333 Independence School Local I   Regular School Yes High 09 12 2021   grade_11                                                   30                                             30
1319093 MD     school 2400090 30   Baltimore City 240009001632 333 Independence School Local I   Regular School Yes High 09 12 2021   grade_12                                                   31                                             31
1319094 MD     school 2400090 30   Baltimore City 240009001632 333 Independence School Local I   Regular School Yes High 09 12 2021   pk_12_total 15 138 *                                             155 15 138                                         155
1319105 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2021   pre_kindergarten                                                   59                                             59
1319106 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2021   kindergarten                                                   48                                             48
1319107 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2021   grade_1                                                   61                                             61
1319108 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2021   grade_2                                                   62                                             62
1319109 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2021   grade_3                                                   53                                             53
1319110 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2021   grade_4                                                   42                                             42
1319111 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2021   grade_5                                                   45                                             45
1319112 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2021   grade_6                                                   39                                             39
1319113 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2021   grade_7                                                   40                                             40
1319114 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2021   grade_8                                                   30                                             30
1319115 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2021   pk_12_total 119 323 16   *           19                             479 119 323 16               19                       479
1319116 MD     school 2400090 30   Baltimore City 240009001661 337 Afya Public Charter School   Regular School Yes Middle 08 08 2021   grade_8                                                   112                                             112
1319117 MD     school 2400090 30   Baltimore City 240009001661 337 Afya Public Charter School   Regular School Yes Middle 08 08 2021   pk_12_total   105 *                                             112   105                                         112
1319123 MD     school 2400090 30   Baltimore City 240009001662 345 Joseph C. Briscoe Academy   Special Education School No High 06 12 2021   grade_6                                                   *                                              
1319124 MD     school 2400090 30   Baltimore City 240009001662 345 Joseph C. Briscoe Academy   Special Education School No High 06 12 2021   grade_7                                                   11                                             11
1319125 MD     school 2400090 30   Baltimore City 240009001662 345 Joseph C. Briscoe Academy   Special Education School No High 06 12 2021   grade_8                                                   *                                              
1319126 MD     school 2400090 30   Baltimore City 240009001662 345 Joseph C. Briscoe Academy   Special Education School No High 06 12 2021   grade_9                                                   *                                              
1319127 MD     school 2400090 30   Baltimore City 240009001662 345 Joseph C. Briscoe Academy   Special Education School No High 06 12 2021   grade_10                                                   *                                              
1319128 MD     school 2400090 30   Baltimore City 240009001662 345 Joseph C. Briscoe Academy   Special Education School No High 06 12 2021   grade_11                                                   10                                             10
1319129 MD     school 2400090 30   Baltimore City 240009001662 345 Joseph C. Briscoe Academy   Special Education School No High 06 12 2021   grade_12                                                   *                                              
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
1319118 MD     school 2400090 30   Baltimore City 240009001663 341 The Reach! Partnership School   Regular School No High 09 12 2021   grade_9                                                   255                                             255
1319119 MD     school 2400090 30   Baltimore City 240009001663 341 The Reach! Partnership School   Regular School No High 09 12 2021   grade_10                                                   184                                             184
1319120 MD     school 2400090 30   Baltimore City 240009001663 341 The Reach! Partnership School   Regular School No High 09 12 2021   grade_11                                                   134                                             134
1319121 MD     school 2400090 30   Baltimore City 240009001663 341 The Reach! Partnership School   Regular School No High 09 12 2021   grade_12                                                   122                                             122
1319122 MD     school 2400090 30   Baltimore City 240009001663 341 The Reach! Partnership School   Regular School No High 09 12 2021   pk_12_total * 672 14               *                             695   672 14                                       695
1319172 MD     school 2400090 30   Baltimore City 240009001670 368 Elmer A. Henderson: A Johns Hopkins Partnership   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   24                                             24
1319173 MD     school 2400090 30   Baltimore City 240009001670 368 Elmer A. Henderson: A Johns Hopkins Partnership   Regular School No Elementary PK 08 2021   kindergarten                                                   66                                             66
1319174 MD     school 2400090 30   Baltimore City 240009001670 368 Elmer A. Henderson: A Johns Hopkins Partnership   Regular School No Elementary PK 08 2021   grade_1                                                   72                                             72
1319175 MD     school 2400090 30   Baltimore City 240009001670 368 Elmer A. Henderson: A Johns Hopkins Partnership   Regular School No Elementary PK 08 2021   grade_2                                                   70                                             70
1319176 MD     school 2400090 30   Baltimore City 240009001670 368 Elmer A. Henderson: A Johns Hopkins Partnership   Regular School No Elementary PK 08 2021   grade_3                                                   70                                             70
1319177 MD     school 2400090 30   Baltimore City 240009001670 368 Elmer A. Henderson: A Johns Hopkins Partnership   Regular School No Elementary PK 08 2021   grade_4                                                   67                                             67
1319178 MD     school 2400090 30   Baltimore City 240009001670 368 Elmer A. Henderson: A Johns Hopkins Partnership   Regular School No Elementary PK 08 2021   grade_5                                                   66                                             66
1319179 MD     school 2400090 30   Baltimore City 240009001670 368 Elmer A. Henderson: A Johns Hopkins Partnership   Regular School No Elementary PK 08 2021   grade_6                                                   60                                             60
1319180 MD     school 2400090 30   Baltimore City 240009001670 368 Elmer A. Henderson: A Johns Hopkins Partnership   Regular School No Elementary PK 08 2021   grade_7                                                   51                                             51
1319181 MD     school 2400090 30   Baltimore City 240009001670 368 Elmer A. Henderson: A Johns Hopkins Partnership   Regular School No Elementary PK 08 2021   grade_8                                                   46                                             46
1319182 MD     school 2400090 30   Baltimore City 240009001670 368 Elmer A. Henderson: A Johns Hopkins Partnership   Regular School No Elementary PK 08 2021   pk_12_total * 573 11   * *         *                             592   573 11                                       592
1319164 MD     school 2400090 30   Baltimore City 240009001675 364 Bluford Drew Jemison STEM Academy West   Regular School No High 06 12 2021   grade_6                                                   28                                             28
1319165 MD     school 2400090 30   Baltimore City 240009001675 364 Bluford Drew Jemison STEM Academy West   Regular School No High 06 12 2021   grade_7                                                   39                                             39
1319166 MD     school 2400090 30   Baltimore City 240009001675 364 Bluford Drew Jemison STEM Academy West   Regular School No High 06 12 2021   grade_8                                                   37                                             37
1319167 MD     school 2400090 30   Baltimore City 240009001675 364 Bluford Drew Jemison STEM Academy West   Regular School No High 06 12 2021   grade_9                                                   72                                             72
1319168 MD     school 2400090 30   Baltimore City 240009001675 364 Bluford Drew Jemison STEM Academy West   Regular School No High 06 12 2021   grade_10                                                   25                                             25
1319169 MD     school 2400090 30   Baltimore City 240009001675 364 Bluford Drew Jemison STEM Academy West   Regular School No High 06 12 2021   grade_11                                                   14                                             14
1319170 MD     school 2400090 30   Baltimore City 240009001675 364 Bluford Drew Jemison STEM Academy West   Regular School No High 06 12 2021   grade_12                                                   11                                             11
1319171 MD     school 2400090 30   Baltimore City 240009001675 364 Bluford Drew Jemison STEM Academy West   Regular School No High 06 12 2021   pk_12_total * 220 *                                             226   220                                         226
1319131 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2021   kindergarten                                                   24                                             24
1319132 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2021   grade_1                                                   23                                             23
1319133 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2021   grade_2                                                   26                                             26
1319134 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2021   grade_3                                                   25                                             25
1319135 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2021   grade_4                                                   26                                             26
1319136 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2021   grade_5                                                   26                                             26
1319137 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2021   grade_6                                                   28                                             28
1319138 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2021   grade_7                                                   28                                             28
1319139 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2021   grade_8                                                   28                                             28
1319140 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2021   pk_12_total 77 127 11   * *         14                             234 77 127 11               14                       234
1319141 MD     school 2400090 30   Baltimore City 240009001681 347 KIPP Harmony Academy   Regular School Yes Elementary KG 08 2021   kindergarten                                                   160                                             160
1319142 MD     school 2400090 30   Baltimore City 240009001681 347 KIPP Harmony Academy   Regular School Yes Elementary KG 08 2021   grade_1                                                   167                                             167
1319143 MD     school 2400090 30   Baltimore City 240009001681 347 KIPP Harmony Academy   Regular School Yes Elementary KG 08 2021   grade_2                                                   170                                             170
1319144 MD     school 2400090 30   Baltimore City 240009001681 347 KIPP Harmony Academy   Regular School Yes Elementary KG 08 2021   grade_3                                                   168                                             168
1319145 MD     school 2400090 30   Baltimore City 240009001681 347 KIPP Harmony Academy   Regular School Yes Elementary KG 08 2021   grade_4                                                   171                                             171
1319146 MD     school 2400090 30   Baltimore City 240009001681 347 KIPP Harmony Academy   Regular School Yes Elementary KG 08 2021   grade_5                                                   180                                             180
1319147 MD     school 2400090 30   Baltimore City 240009001681 347 KIPP Harmony Academy   Regular School Yes Elementary KG 08 2021   grade_6                                                   181                                             181
1319148 MD     school 2400090 30   Baltimore City 240009001681 347 KIPP Harmony Academy   Regular School Yes Elementary KG 08 2021   grade_7                                                   189                                             189
1319149 MD     school 2400090 30   Baltimore City 240009001681 347 KIPP Harmony Academy   Regular School Yes Elementary KG 08 2021   grade_8                                                   189                                             189
1319150 MD     school 2400090 30   Baltimore City 240009001681 347 KIPP Harmony Academy   Regular School Yes Elementary KG 08 2021   pk_12_total * 1542 21   * *     *   *                             1575   1542 21                                       1575
1319151 MD     school 2400090 30   Baltimore City 240009001682 348 Baltimore Leadership School for Young Women   Regular School Yes High 06 12 2021   grade_6                                                   82                                             82
1319152 MD     school 2400090 30   Baltimore City 240009001682 348 Baltimore Leadership School for Young Women   Regular School Yes High 06 12 2021   grade_7                                                   98                                             98
1319153 MD     school 2400090 30   Baltimore City 240009001682 348 Baltimore Leadership School for Young Women   Regular School Yes High 06 12 2021   grade_8                                                   112                                             112
1319154 MD     school 2400090 30   Baltimore City 240009001682 348 Baltimore Leadership School for Young Women   Regular School Yes High 06 12 2021   grade_9                                                   75                                             75
1319155 MD     school 2400090 30   Baltimore City 240009001682 348 Baltimore Leadership School for Young Women   Regular School Yes High 06 12 2021   grade_10                                                   50                                             50

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