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 · 7,650
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
1312018 MD     school 2400150 4   Calvert 240015001342 217 Huntingtown High School   Regular School No High 09 12 2021   pk_12_total 1060 134 80   * 22         100                             1398 1060 134 80     22         100                       1398
1313914 MD     school 2400420 13   Howard 240042000856 217 Hollifield Station Elementary   Regular School No Elementary KG 05 2021   kindergarten                                                   114                                             114
1313915 MD     school 2400420 13   Howard 240042000856 217 Hollifield Station Elementary   Regular School No Elementary KG 05 2021   grade_1                                                   139                                             139
1313916 MD     school 2400420 13   Howard 240042000856 217 Hollifield Station Elementary   Regular School No Elementary KG 05 2021   grade_2                                                   128                                             128
1313917 MD     school 2400420 13   Howard 240042000856 217 Hollifield Station Elementary   Regular School No Elementary KG 05 2021   grade_3                                                   117                                             117
1313918 MD     school 2400420 13   Howard 240042000856 217 Hollifield Station Elementary   Regular School No Elementary KG 05 2021   grade_4                                                   135                                             135
1313919 MD     school 2400420 13   Howard 240042000856 217 Hollifield Station Elementary   Regular School No Elementary KG 05 2021   grade_5                                                   135                                             135
1313920 MD     school 2400420 13   Howard 240042000856 217 Hollifield Station Elementary   Regular School No Elementary KG 05 2021   pk_12_total 172 105 100   * 359     *   26                             768 172 105 100     359         26                       768
1315786 MD     school 2400510 16   Prince George's 240051001368 217 Port Towns Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   53                                             53
1315787 MD     school 2400510 16   Prince George's 240051001368 217 Port Towns Elementary   Regular School No Elementary PK 06 2021   kindergarten                                                   123                                             123
1315788 MD     school 2400510 16   Prince George's 240051001368 217 Port Towns Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   122                                             122
1315789 MD     school 2400510 16   Prince George's 240051001368 217 Port Towns Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   129                                             129
1315790 MD     school 2400510 16   Prince George's 240051001368 217 Port Towns Elementary   Regular School No Elementary PK 06 2021   grade_3                                                   141                                             141
1315791 MD     school 2400510 16   Prince George's 240051001368 217 Port Towns Elementary   Regular School No Elementary PK 06 2021   grade_4                                                   135                                             135
1315792 MD     school 2400510 16   Prince George's 240051001368 217 Port Towns Elementary   Regular School No Elementary PK 06 2021   grade_5                                                   142                                             142
1315793 MD     school 2400510 16   Prince George's 240051001368 217 Port Towns Elementary   Regular School No Elementary PK 06 2021   grade_6                                                   137                                             137
1315794 MD     school 2400510 16   Prince George's 240051001368 217 Port Towns Elementary   Regular School No Elementary PK 06 2021   pk_12_total 14 310 652   * *     *   *                             982 14 310 652                                       982
1318666 MD     school 2400090 30   Baltimore City 240009000156 217 Belmont Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   17                                             17
1318667 MD     school 2400090 30   Baltimore City 240009000156 217 Belmont Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   36                                             36
1318668 MD     school 2400090 30   Baltimore City 240009000156 217 Belmont Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   35                                             35
1318669 MD     school 2400090 30   Baltimore City 240009000156 217 Belmont Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   36                                             36
1318670 MD     school 2400090 30   Baltimore City 240009000156 217 Belmont Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   42                                             42
1318671 MD     school 2400090 30   Baltimore City 240009000156 217 Belmont Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   36                                             36
1318672 MD     school 2400090 30   Baltimore City 240009000156 217 Belmont Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   39                                             39
1318673 MD     school 2400090 30   Baltimore City 240009000156 217 Belmont Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 231 *   *           *                             241   231                                         241
1313921 MD     school 2400420 13   Howard 240042001551 218 Bellows Spring Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   66                                             66
1313922 MD     school 2400420 13   Howard 240042001551 218 Bellows Spring Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   113                                             113
1313923 MD     school 2400420 13   Howard 240042001551 218 Bellows Spring Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   96                                             96
1313924 MD     school 2400420 13   Howard 240042001551 218 Bellows Spring Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   105                                             105
1313925 MD     school 2400420 13   Howard 240042001551 218 Bellows Spring Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   97                                             97
1313926 MD     school 2400420 13   Howard 240042001551 218 Bellows Spring Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   95                                             95
1313927 MD     school 2400420 13   Howard 240042001551 218 Bellows Spring Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   104                                             104
1313928 MD     school 2400420 13   Howard 240042001551 218 Bellows Spring Elementary   Regular School No Elementary PK 05 2021   pk_12_total 154 187 65   * 221     *   42                             676 154 187 65     221         42                       676
1311000 MD     school 2400120 3   Baltimore County 240012001753 219 Watershed Public Charter   Regular School Yes Elementary KG 04 2021   kindergarten                                                   65                                             65
1311001 MD     school 2400120 3   Baltimore County 240012001753 219 Watershed Public Charter   Regular School Yes Elementary KG 04 2021   grade_1                                                   49                                             49
1311002 MD     school 2400120 3   Baltimore County 240012001753 219 Watershed Public Charter   Regular School Yes Elementary KG 04 2021   grade_2                                                   44                                             44
1311003 MD     school 2400120 3   Baltimore County 240012001753 219 Watershed Public Charter   Regular School Yes Elementary KG 04 2021   grade_3                                                   46                                             46
1311004 MD     school 2400120 3   Baltimore County 240012001753 219 Watershed Public Charter   Regular School Yes Elementary KG 04 2021   grade_4                                                   27                                             27
1311005 MD     school 2400120 3   Baltimore County 240012001753 219 Watershed Public Charter   Regular School Yes Elementary KG 04 2021   pk_12_total 53 128 15   * *         31                             231 53 128 15               31                       231
1312957 MD     school 2400330 10   Frederick 240033001413 219 Monocacy Middle   Regular School No Middle 06 08 2021   grade_6                                                   317                                             317
1312958 MD     school 2400330 10   Frederick 240033001413 219 Monocacy Middle   Regular School No Middle 06 08 2021   grade_7                                                   332                                             332
1312959 MD     school 2400330 10   Frederick 240033001413 219 Monocacy Middle   Regular School No Middle 06 08 2021   grade_8                                                   329                                             329
1312960 MD     school 2400330 10   Frederick 240033001413 219 Monocacy Middle   Regular School No Middle 06 08 2021   pk_12_total 246 226 388   * 42     *   64                             978 246 226 388     42         64                       978
1313929 MD     school 2400420 13   Howard 240042001646 219 Veterans Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   62                                             62
1313930 MD     school 2400420 13   Howard 240042001646 219 Veterans Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   140                                             140
1313931 MD     school 2400420 13   Howard 240042001646 219 Veterans Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   139                                             139
1313932 MD     school 2400420 13   Howard 240042001646 219 Veterans Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   136                                             136
1313933 MD     school 2400420 13   Howard 240042001646 219 Veterans Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   153                                             153
1313934 MD     school 2400420 13   Howard 240042001646 219 Veterans Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   153                                             153
1313935 MD     school 2400420 13   Howard 240042001646 219 Veterans Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   168                                             168
1313936 MD     school 2400420 13   Howard 240042001646 219 Veterans Elementary   Regular School No Elementary PK 05 2021   pk_12_total 225 146 70   * 449     *   49                             951 225 146 70     449         49                       951
1314502 MD     school 2400480 15   Montgomery 240048000828 219 Farmland Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   *                                              
1314503 MD     school 2400480 15   Montgomery 240048000828 219 Farmland Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   102                                             102
1314504 MD     school 2400480 15   Montgomery 240048000828 219 Farmland Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   140                                             140
1314505 MD     school 2400480 15   Montgomery 240048000828 219 Farmland Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   142                                             142
1314506 MD     school 2400480 15   Montgomery 240048000828 219 Farmland Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   123                                             123
1314507 MD     school 2400480 15   Montgomery 240048000828 219 Farmland Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   131                                             131
1314508 MD     school 2400480 15   Montgomery 240048000828 219 Farmland Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   129                                             129
1314509 MD     school 2400480 15   Montgomery 240048000828 219 Farmland Elementary   Regular School No Elementary PK 05 2021   pk_12_total 326 76 84   * 255         32                             774 326 76 84     255         32                       774
1318674 MD     school 2400090 30   Baltimore City 240009000340 219 Yorkwood Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   33                                             33
1318675 MD     school 2400090 30   Baltimore City 240009000340 219 Yorkwood Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   51                                             51
1318676 MD     school 2400090 30   Baltimore City 240009000340 219 Yorkwood Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   53                                             53
1318677 MD     school 2400090 30   Baltimore City 240009000340 219 Yorkwood Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   59                                             59
1318678 MD     school 2400090 30   Baltimore City 240009000340 219 Yorkwood Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   54                                             54
1318679 MD     school 2400090 30   Baltimore City 240009000340 219 Yorkwood Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   61                                             61
1318680 MD     school 2400090 30   Baltimore City 240009000340 219 Yorkwood Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   52                                             52
1318681 MD     school 2400090 30   Baltimore City 240009000340 219 Yorkwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 348 *   * *     *                                 363   348                                         363
1314510 MD     school 2400480 15   Montgomery 240048000869 220 Luxmanor Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   45                                             45
1314511 MD     school 2400480 15   Montgomery 240048000869 220 Luxmanor Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   79                                             79
1314512 MD     school 2400480 15   Montgomery 240048000869 220 Luxmanor Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   131                                             131
1314513 MD     school 2400480 15   Montgomery 240048000869 220 Luxmanor Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   95                                             95
1314514 MD     school 2400480 15   Montgomery 240048000869 220 Luxmanor Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   114                                             114
1314515 MD     school 2400480 15   Montgomery 240048000869 220 Luxmanor Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   96                                             96
1314516 MD     school 2400480 15   Montgomery 240048000869 220 Luxmanor Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   96                                             96
1314517 MD     school 2400480 15   Montgomery 240048000869 220 Luxmanor Elementary   Regular School No Elementary PK 05 2021   pk_12_total 193 108 143     170         42                             656 193 108 143     170         42                       656
1318682 MD     school 2400090 30   Baltimore City 240009000284 220 Morrell Park Elementary/Middle   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   22                                             22
1318683 MD     school 2400090 30   Baltimore City 240009000284 220 Morrell Park Elementary/Middle   Regular School No Elementary PK 08 2021   kindergarten                                                   33                                             33
1318684 MD     school 2400090 30   Baltimore City 240009000284 220 Morrell Park Elementary/Middle   Regular School No Elementary PK 08 2021   grade_1                                                   37                                             37
1318685 MD     school 2400090 30   Baltimore City 240009000284 220 Morrell Park Elementary/Middle   Regular School No Elementary PK 08 2021   grade_2                                                   38                                             38
1318686 MD     school 2400090 30   Baltimore City 240009000284 220 Morrell Park Elementary/Middle   Regular School No Elementary PK 08 2021   grade_3                                                   48                                             48
1318687 MD     school 2400090 30   Baltimore City 240009000284 220 Morrell Park Elementary/Middle   Regular School No Elementary PK 08 2021   grade_4                                                   50                                             50
1318688 MD     school 2400090 30   Baltimore City 240009000284 220 Morrell Park Elementary/Middle   Regular School No Elementary PK 08 2021   grade_5                                                   33                                             33
1318689 MD     school 2400090 30   Baltimore City 240009000284 220 Morrell Park Elementary/Middle   Regular School No Elementary PK 08 2021   grade_6                                                   54                                             54
1318690 MD     school 2400090 30   Baltimore City 240009000284 220 Morrell Park Elementary/Middle   Regular School No Elementary PK 08 2021   grade_7                                                   68                                             68
1318691 MD     school 2400090 30   Baltimore City 240009000284 220 Morrell Park Elementary/Middle   Regular School No Elementary PK 08 2021   grade_8                                                   60                                             60
1318692 MD     school 2400090 30   Baltimore City 240009000284 220 Morrell Park Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 166 146 91   * 14     *   22                             443 166 146 91     14         22                       443
1318693 MD     school 2400090 30   Baltimore City 240009000286 221 The Mount Washington School   Regular School No Elementary KG 08 2021   kindergarten                                                   40                                             40
1318694 MD     school 2400090 30   Baltimore City 240009000286 221 The Mount Washington School   Regular School No Elementary KG 08 2021   grade_1                                                   50                                             50
1318695 MD     school 2400090 30   Baltimore City 240009000286 221 The Mount Washington School   Regular School No Elementary KG 08 2021   grade_2                                                   54                                             54
1318696 MD     school 2400090 30   Baltimore City 240009000286 221 The Mount Washington School   Regular School No Elementary KG 08 2021   grade_3                                                   60                                             60
1318697 MD     school 2400090 30   Baltimore City 240009000286 221 The Mount Washington School   Regular School No Elementary KG 08 2021   grade_4                                                   69                                             69
1318698 MD     school 2400090 30   Baltimore City 240009000286 221 The Mount Washington School   Regular School No Elementary KG 08 2021   grade_5                                                   81                                             81
1318699 MD     school 2400090 30   Baltimore City 240009000286 221 The Mount Washington School   Regular School No Elementary KG 08 2021   grade_6                                                   65                                             65
1318700 MD     school 2400090 30   Baltimore City 240009000286 221 The Mount Washington School   Regular School No Elementary KG 08 2021   grade_7                                                   56                                             56
1318701 MD     school 2400090 30   Baltimore City 240009000286 221 The Mount Washington School   Regular School No Elementary KG 08 2021   grade_8                                                   77                                             77
1318702 MD     school 2400090 30   Baltimore City 240009000286 221 The Mount Washington School   Regular School No Elementary KG 08 2021   pk_12_total 142 352 29     12     *   16                             552 142 352 29     12         16                       552
1312961 MD     school 2400330 10   Frederick 240033001521 222 Monocacy Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   30                                             30
1312962 MD     school 2400330 10   Frederick 240033001521 222 Monocacy Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   97                                             97
1312963 MD     school 2400330 10   Frederick 240033001521 222 Monocacy Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   75                                             75
1312964 MD     school 2400330 10   Frederick 240033001521 222 Monocacy Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   101                                             101

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