Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2021 · 9,598
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
1318017 MD     school 2400090 30   Baltimore City 240009000319 4 Steuart Hill Academic Academy   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   15                                             15
1318018 MD     school 2400090 30   Baltimore City 240009000319 4 Steuart Hill Academic Academy   Regular School No Elementary PK 05 2021   kindergarten                                                   35                                             35
1318019 MD     school 2400090 30   Baltimore City 240009000319 4 Steuart Hill Academic Academy   Regular School No Elementary PK 05 2021   grade_1                                                   32                                             32
1318020 MD     school 2400090 30   Baltimore City 240009000319 4 Steuart Hill Academic Academy   Regular School No Elementary PK 05 2021   grade_2                                                   19                                             19
1318021 MD     school 2400090 30   Baltimore City 240009000319 4 Steuart Hill Academic Academy   Regular School No Elementary PK 05 2021   grade_3                                                   34                                             34
1318022 MD     school 2400090 30   Baltimore City 240009000319 4 Steuart Hill Academic Academy   Regular School No Elementary PK 05 2021   grade_4                                                   28                                             28
1318023 MD     school 2400090 30   Baltimore City 240009000319 4 Steuart Hill Academic Academy   Regular School No Elementary PK 05 2021   grade_5                                                   24                                             24
1318024 MD     school 2400090 30   Baltimore City 240009000319 4 Steuart Hill Academic Academy   Regular School No Elementary PK 05 2021   pk_12_total 13 163 *     *         *                             187 13 163                                         187
1318025 MD     school 2400090 30   Baltimore City 240009000169 7 Cecil Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   47                                             47
1318026 MD     school 2400090 30   Baltimore City 240009000169 7 Cecil Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   60                                             60
1318027 MD     school 2400090 30   Baltimore City 240009000169 7 Cecil Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   50                                             50
1318028 MD     school 2400090 30   Baltimore City 240009000169 7 Cecil Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   56                                             56
1318029 MD     school 2400090 30   Baltimore City 240009000169 7 Cecil Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   44                                             44
1318030 MD     school 2400090 30   Baltimore City 240009000169 7 Cecil Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   49                                             49
1318031 MD     school 2400090 30   Baltimore City 240009000169 7 Cecil Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   48                                             48
1318032 MD     school 2400090 30   Baltimore City 240009000169 7 Cecil Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 341 *           *   *                             354   341                                         354
1318033 MD     school 2400090 30   Baltimore City 240009000175 8 City Springs Elementary/Middle   Regular School Yes Elementary PK 08 2021   pre_kindergarten                                                   18                                             18
1318034 MD     school 2400090 30   Baltimore City 240009000175 8 City Springs Elementary/Middle   Regular School Yes Elementary PK 08 2021   kindergarten                                                   58                                             58
1318035 MD     school 2400090 30   Baltimore City 240009000175 8 City Springs Elementary/Middle   Regular School Yes Elementary PK 08 2021   grade_1                                                   52                                             52
1318036 MD     school 2400090 30   Baltimore City 240009000175 8 City Springs Elementary/Middle   Regular School Yes Elementary PK 08 2021   grade_2                                                   72                                             72
1318037 MD     school 2400090 30   Baltimore City 240009000175 8 City Springs Elementary/Middle   Regular School Yes Elementary PK 08 2021   grade_3                                                   49                                             49
1318038 MD     school 2400090 30   Baltimore City 240009000175 8 City Springs Elementary/Middle   Regular School Yes Elementary PK 08 2021   grade_4                                                   59                                             59
1318039 MD     school 2400090 30   Baltimore City 240009000175 8 City Springs Elementary/Middle   Regular School Yes Elementary PK 08 2021   grade_5                                                   76                                             76
1318040 MD     school 2400090 30   Baltimore City 240009000175 8 City Springs Elementary/Middle   Regular School Yes Elementary PK 08 2021   grade_6                                                   82                                             82
1318041 MD     school 2400090 30   Baltimore City 240009000175 8 City Springs Elementary/Middle   Regular School Yes Elementary PK 08 2021   grade_7                                                   88                                             88
1318042 MD     school 2400090 30   Baltimore City 240009000175 8 City Springs Elementary/Middle   Regular School Yes Elementary PK 08 2021   grade_8                                                   79                                             79
1318043 MD     school 2400090 30   Baltimore City 240009000175 8 City Springs Elementary/Middle   Regular School Yes Elementary PK 08 2021   pk_12_total 10 594 24   *           *                             633 10 594 24                                       633
1318044 MD     school 2400090 30   Baltimore City 240009000253 10 James McHenry Elementary/Middle   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   25                                             25
1318045 MD     school 2400090 30   Baltimore City 240009000253 10 James McHenry Elementary/Middle   Regular School No Elementary PK 08 2021   kindergarten                                                   60                                             60
1318046 MD     school 2400090 30   Baltimore City 240009000253 10 James McHenry Elementary/Middle   Regular School No Elementary PK 08 2021   grade_1                                                   56                                             56
1318047 MD     school 2400090 30   Baltimore City 240009000253 10 James McHenry Elementary/Middle   Regular School No Elementary PK 08 2021   grade_2                                                   69                                             69
1318048 MD     school 2400090 30   Baltimore City 240009000253 10 James McHenry Elementary/Middle   Regular School No Elementary PK 08 2021   grade_3                                                   53                                             53
1318049 MD     school 2400090 30   Baltimore City 240009000253 10 James McHenry Elementary/Middle   Regular School No Elementary PK 08 2021   grade_4                                                   59                                             59
1318050 MD     school 2400090 30   Baltimore City 240009000253 10 James McHenry Elementary/Middle   Regular School No Elementary PK 08 2021   grade_5                                                   56                                             56
1318051 MD     school 2400090 30   Baltimore City 240009000253 10 James McHenry Elementary/Middle   Regular School No Elementary PK 08 2021   grade_6                                                   132                                             132
1318052 MD     school 2400090 30   Baltimore City 240009000253 10 James McHenry Elementary/Middle   Regular School No Elementary PK 08 2021   grade_7                                                   105                                             105
1318053 MD     school 2400090 30   Baltimore City 240009000253 10 James McHenry Elementary/Middle   Regular School No Elementary PK 08 2021   grade_8                                                   55                                             55
1318054 MD     school 2400090 30   Baltimore City 240009000253 10 James McHenry Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 24 601 31     *         11                             670 24 601 31               11                       670
1318055 MD     school 2400090 30   Baltimore City 240009000196 11 Eutaw-Marshburn Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   10                                             10
1318056 MD     school 2400090 30   Baltimore City 240009000196 11 Eutaw-Marshburn Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   35                                             35
1318057 MD     school 2400090 30   Baltimore City 240009000196 11 Eutaw-Marshburn Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   38                                             38
1318058 MD     school 2400090 30   Baltimore City 240009000196 11 Eutaw-Marshburn Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   50                                             50
1318059 MD     school 2400090 30   Baltimore City 240009000196 11 Eutaw-Marshburn Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   40                                             40
1318060 MD     school 2400090 30   Baltimore City 240009000196 11 Eutaw-Marshburn Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   46                                             46
1318061 MD     school 2400090 30   Baltimore City 240009000196 11 Eutaw-Marshburn Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   29                                             29
1318062 MD     school 2400090 30   Baltimore City 240009000196 11 Eutaw-Marshburn Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 243 *   *                                         248   243                                         248
1318063 MD     school 2400090 30   Baltimore City 240009000264 12 Lakeland Elementary/Middle   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   69                                             69
1318064 MD     school 2400090 30   Baltimore City 240009000264 12 Lakeland Elementary/Middle   Regular School No Elementary PK 08 2021   kindergarten                                                   91                                             91
1318065 MD     school 2400090 30   Baltimore City 240009000264 12 Lakeland Elementary/Middle   Regular School No Elementary PK 08 2021   grade_1                                                   115                                             115
1318066 MD     school 2400090 30   Baltimore City 240009000264 12 Lakeland Elementary/Middle   Regular School No Elementary PK 08 2021   grade_2                                                   106                                             106
1318067 MD     school 2400090 30   Baltimore City 240009000264 12 Lakeland Elementary/Middle   Regular School No Elementary PK 08 2021   grade_3                                                   92                                             92
1318068 MD     school 2400090 30   Baltimore City 240009000264 12 Lakeland Elementary/Middle   Regular School No Elementary PK 08 2021   grade_4                                                   112                                             112
1318069 MD     school 2400090 30   Baltimore City 240009000264 12 Lakeland Elementary/Middle   Regular School No Elementary PK 08 2021   grade_5                                                   90                                             90
1318070 MD     school 2400090 30   Baltimore City 240009000264 12 Lakeland Elementary/Middle   Regular School No Elementary PK 08 2021   grade_6                                                   103                                             103
1318071 MD     school 2400090 30   Baltimore City 240009000264 12 Lakeland Elementary/Middle   Regular School No Elementary PK 08 2021   grade_7                                                   106                                             106
1318072 MD     school 2400090 30   Baltimore City 240009000264 12 Lakeland Elementary/Middle   Regular School No Elementary PK 08 2021   grade_8                                                   100                                             100
1318073 MD     school 2400090 30   Baltimore City 240009000264 12 Lakeland Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 37 288 642   * *         10                             984 37 288 642               10                       984
1318074 MD     school 2400090 30   Baltimore City 240009000320 13 Tench Tilghman Elementary/Middle   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   20                                             20
1318075 MD     school 2400090 30   Baltimore City 240009000320 13 Tench Tilghman Elementary/Middle   Regular School No Elementary PK 08 2021   kindergarten                                                   39                                             39
1318076 MD     school 2400090 30   Baltimore City 240009000320 13 Tench Tilghman Elementary/Middle   Regular School No Elementary PK 08 2021   grade_1                                                   43                                             43
1318077 MD     school 2400090 30   Baltimore City 240009000320 13 Tench Tilghman Elementary/Middle   Regular School No Elementary PK 08 2021   grade_2                                                   43                                             43
1318078 MD     school 2400090 30   Baltimore City 240009000320 13 Tench Tilghman Elementary/Middle   Regular School No Elementary PK 08 2021   grade_3                                                   39                                             39
1318079 MD     school 2400090 30   Baltimore City 240009000320 13 Tench Tilghman Elementary/Middle   Regular School No Elementary PK 08 2021   grade_4                                                   49                                             49
1318080 MD     school 2400090 30   Baltimore City 240009000320 13 Tench Tilghman Elementary/Middle   Regular School No Elementary PK 08 2021   grade_5                                                   40                                             40
1318081 MD     school 2400090 30   Baltimore City 240009000320 13 Tench Tilghman Elementary/Middle   Regular School No Elementary PK 08 2021   grade_6                                                   34                                             34
1318082 MD     school 2400090 30   Baltimore City 240009000320 13 Tench Tilghman Elementary/Middle   Regular School No Elementary PK 08 2021   grade_7                                                   33                                             33
1318083 MD     school 2400090 30   Baltimore City 240009000320 13 Tench Tilghman Elementary/Middle   Regular School No Elementary PK 08 2021   grade_8                                                   31                                             31
1318084 MD     school 2400090 30   Baltimore City 240009000320 13 Tench Tilghman Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 319 48               *                             371   319 48                                       371
1318085 MD     school 2400090 30   Baltimore City 240009000571 15 Stadium School   Regular School No Middle 06 08 2021   grade_6                                                   192                                             192
1318086 MD     school 2400090 30   Baltimore City 240009000571 15 Stadium School   Regular School No Middle 06 08 2021   grade_7                                                   165                                             165
1318087 MD     school 2400090 30   Baltimore City 240009000571 15 Stadium School   Regular School No Middle 06 08 2021   grade_8                                                   143                                             143
1318088 MD     school 2400090 30   Baltimore City 240009000571 15 Stadium School   Regular School No Middle 06 08 2021   pk_12_total * 471 20           *   *                             500   471 20                                       500
1318089 MD     school 2400090 30   Baltimore City 240009000258 16 Johnston Square Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   10                                             10
1318090 MD     school 2400090 30   Baltimore City 240009000258 16 Johnston Square Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   39                                             39
1318091 MD     school 2400090 30   Baltimore City 240009000258 16 Johnston Square Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   55                                             55
1318092 MD     school 2400090 30   Baltimore City 240009000258 16 Johnston Square Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   44                                             44
1318093 MD     school 2400090 30   Baltimore City 240009000258 16 Johnston Square Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   42                                             42
1318094 MD     school 2400090 30   Baltimore City 240009000258 16 Johnston Square Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   41                                             41
1318095 MD     school 2400090 30   Baltimore City 240009000258 16 Johnston Square Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   42                                             42
1318096 MD     school 2400090 30   Baltimore City 240009000258 16 Johnston Square Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 263 *               *                             273   263                                         273
1318097 MD     school 2400090 30   Baltimore City 240009000246 21 Hilton Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   17                                             17
1318098 MD     school 2400090 30   Baltimore City 240009000246 21 Hilton Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   51                                             51
1318099 MD     school 2400090 30   Baltimore City 240009000246 21 Hilton Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   49                                             49
1318100 MD     school 2400090 30   Baltimore City 240009000246 21 Hilton Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   59                                             59
1318101 MD     school 2400090 30   Baltimore City 240009000246 21 Hilton Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   52                                             52
1318102 MD     school 2400090 30   Baltimore City 240009000246 21 Hilton Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   57                                             57
1318103 MD     school 2400090 30   Baltimore City 240009000246 21 Hilton Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   43                                             43
1318104 MD     school 2400090 30   Baltimore City 240009000246 21 Hilton Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 313 *                                             328   313                                         328
1318105 MD     school 2400090 30   Baltimore City 240009000220 22 George Washington Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   *                                              
1318106 MD     school 2400090 30   Baltimore City 240009000220 22 George Washington Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   25                                             25
1318107 MD     school 2400090 30   Baltimore City 240009000220 22 George Washington Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   24                                             24
1318108 MD     school 2400090 30   Baltimore City 240009000220 22 George Washington Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   37                                             37
1318109 MD     school 2400090 30   Baltimore City 240009000220 22 George Washington Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   34                                             34
1318110 MD     school 2400090 30   Baltimore City 240009000220 22 George Washington Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   25                                             25
1318111 MD     school 2400090 30   Baltimore City 240009000220 22 George Washington Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   31                                             31
1318112 MD     school 2400090 30   Baltimore City 240009000220 22 George Washington Elementary   Regular School No Elementary PK 05 2021   pk_12_total 10 153 13           *   *                             184 10 153 13                                       184
1318113 MD     school 2400090 30   Baltimore City 240009000215 23 Wolfe Street Academy   Regular School Yes Elementary PK 05 2021   pre_kindergarten                                                   22                                             22
1318114 MD     school 2400090 30   Baltimore City 240009000215 23 Wolfe Street Academy   Regular School Yes Elementary PK 05 2021   kindergarten                                                   32                                             32
1318115 MD     school 2400090 30   Baltimore City 240009000215 23 Wolfe Street Academy   Regular School Yes Elementary PK 05 2021   grade_1                                                   44                                             44
1318116 MD     school 2400090 30   Baltimore City 240009000215 23 Wolfe Street Academy   Regular School Yes Elementary PK 05 2021   grade_2                                                   44                                             44

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