Data source: Big Local News · About: Big Local

9,615 rows where state = "MD" and year = 2020 sorted by school

View and edit SQL

year

  • 2020 · 9,615
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
1242893 MD     school 2400480 15   Montgomery 240048001446 787 A. Mario Loiederman Middle   Regular School No Middle 06 08 2020   grade_6                                                   324                                             324
1242894 MD     school 2400480 15   Montgomery 240048001446 787 A. Mario Loiederman Middle   Regular School No Middle 06 08 2020   grade_7                                                   354                                             354
1242895 MD     school 2400480 15   Montgomery 240048001446 787 A. Mario Loiederman Middle   Regular School No Middle 06 08 2020   grade_8                                                   321                                             321
1242896 MD     school 2400480 15   Montgomery 240048001446 787 A. Mario Loiederman Middle   Regular School No Middle 06 08 2020   pk_12_total 142 154 626   * 43         30                             999 142 154 626     43         30                       999
1245640 MD     school 2400090 30   Baltimore City 240009000143 50 Abbottston Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   45                                             45
1245641 MD     school 2400090 30   Baltimore City 240009000143 50 Abbottston Elementary   Regular School No Elementary PK 05 2020   kindergarten                                                   58                                             58
1245642 MD     school 2400090 30   Baltimore City 240009000143 50 Abbottston Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   64                                             64
1245643 MD     school 2400090 30   Baltimore City 240009000143 50 Abbottston Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   61                                             61
1245644 MD     school 2400090 30   Baltimore City 240009000143 50 Abbottston Elementary   Regular School No Elementary PK 05 2020   grade_3                                                   65                                             65
1245645 MD     school 2400090 30   Baltimore City 240009000143 50 Abbottston Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   60                                             60
1245646 MD     school 2400090 30   Baltimore City 240009000143 50 Abbottston Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   56                                             56
1245647 MD     school 2400090 30   Baltimore City 240009000143 50 Abbottston Elementary   Regular School No Elementary PK 05 2020   pk_12_total 10 373 19     *     *   *                             409 10 373 19                                       409
1240995 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2020   grade_9                                                   454                                             454
1240996 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2020   grade_10                                                   331                                             331
1240997 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2020   grade_11                                                   315                                             315
1240998 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2020   grade_12                                                   331                                             331
1240999 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2020   pk_12_total 517 543 145   * 91     *   119                             1431 517 543 145     91         119                       1431
1240991 MD     school 2400390 12   Harford 240039000678 265 Aberdeen Middle   Regular School No Middle 06 08 2020   grade_6                                                   401                                             401
1240992 MD     school 2400390 12   Harford 240039000678 265 Aberdeen Middle   Regular School No Middle 06 08 2020   grade_7                                                   396                                             396
1240993 MD     school 2400390 12   Harford 240039000678 265 Aberdeen Middle   Regular School No Middle 06 08 2020   grade_8                                                   406                                             406
1240994 MD     school 2400390 12   Harford 240039000678 265 Aberdeen Middle   Regular School No Middle 06 08 2020   pk_12_total 411 488 131   * 26     *   139                             1203 411 488 131     26         139                       1203
1240892 MD     school 2400390 12   Harford 240039000162 123 Abingdon Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   39                                             39
1240893 MD     school 2400390 12   Harford 240039000162 123 Abingdon Elementary   Regular School No Elementary PK 05 2020   kindergarten                                                   123                                             123
1240894 MD     school 2400390 12   Harford 240039000162 123 Abingdon Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   113                                             113
1240895 MD     school 2400390 12   Harford 240039000162 123 Abingdon Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   110                                             110
1240896 MD     school 2400390 12   Harford 240039000162 123 Abingdon Elementary   Regular School No Elementary PK 05 2020   grade_3                                                   113                                             113
1240897 MD     school 2400390 12   Harford 240039000162 123 Abingdon Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   104                                             104
1240898 MD     school 2400390 12   Harford 240039000162 123 Abingdon Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   122                                             122
1240899 MD     school 2400390 12   Harford 240039000162 123 Abingdon Elementary   Regular School No Elementary PK 05 2020   pk_12_total 416 161 55   * 24     *   66                             724 416 161 55     24         66                       724
1246765 MD     school 2400090 30   Baltimore City 240009001381 427 Academy for College and Career Exploration   Regular School No High 06 12 2020   grade_6                                                   37                                             37
1246766 MD     school 2400090 30   Baltimore City 240009001381 427 Academy for College and Career Exploration   Regular School No High 06 12 2020   grade_7                                                   49                                             49
1246767 MD     school 2400090 30   Baltimore City 240009001381 427 Academy for College and Career Exploration   Regular School No High 06 12 2020   grade_8                                                   44                                             44
1246768 MD     school 2400090 30   Baltimore City 240009001381 427 Academy for College and Career Exploration   Regular School No High 06 12 2020   grade_9                                                   227                                             227
1246769 MD     school 2400090 30   Baltimore City 240009001381 427 Academy for College and Career Exploration   Regular School No High 06 12 2020   grade_10                                                   127                                             127
1246770 MD     school 2400090 30   Baltimore City 240009001381 427 Academy for College and Career Exploration   Regular School No High 06 12 2020   grade_11                                                   73                                             73
1246771 MD     school 2400090 30   Baltimore City 240009001381 427 Academy for College and Career Exploration   Regular School No High 06 12 2020   grade_12                                                   59                                             59
1246772 MD     school 2400090 30   Baltimore City 240009001381 427 Academy for College and Career Exploration   Regular School No High 06 12 2020   pk_12_total 29 500 74   * *     *   *                             616 29 500 74                                       616
1243928 MD     school 2400510 16   Prince George's 240051001704 1350 Academy of Health Sciences at PGCC   Regular School No High 09 12 2020   grade_9                                                   164                                             164
1243929 MD     school 2400510 16   Prince George's 240051001704 1350 Academy of Health Sciences at PGCC   Regular School No High 09 12 2020   grade_10                                                   152                                             152
1243930 MD     school 2400510 16   Prince George's 240051001704 1350 Academy of Health Sciences at PGCC   Regular School No High 09 12 2020   grade_11                                                   136                                             136
1243931 MD     school 2400510 16   Prince George's 240051001704 1350 Academy of Health Sciences at PGCC   Regular School No High 09 12 2020   grade_12                                                   111                                             111
1243932 MD     school 2400510 16   Prince George's 240051001704 1350 Academy of Health Sciences at PGCC   Regular School No High 09 12 2020   pk_12_total 22 394 70   * 66     *   *                             563 22 394 70     66                                 563
1240802 MD     school 2400360 11   Garrett 240036000662 1501 Accident Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   37                                             37
1240803 MD     school 2400360 11   Garrett 240036000662 1501 Accident Elementary   Regular School No Elementary PK 05 2020   kindergarten                                                   38                                             38
1240804 MD     school 2400360 11   Garrett 240036000662 1501 Accident Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   42                                             42
1240805 MD     school 2400360 11   Garrett 240036000662 1501 Accident Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   44                                             44
1240806 MD     school 2400360 11   Garrett 240036000662 1501 Accident Elementary   Regular School No Elementary PK 05 2020   grade_3                                                   40                                             40
1240807 MD     school 2400360 11   Garrett 240036000662 1501 Accident Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   39                                             39
1240808 MD     school 2400360 11   Garrett 240036000662 1501 Accident Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   41                                             41
1240809 MD     school 2400360 11   Garrett 240036000662 1501 Accident Elementary   Regular School No Elementary PK 05 2020   pk_12_total 266   *               *                             281 266                                           281
1243249 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2020   kindergarten                                                   91                                             91
1243250 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2020   grade_1                                                   120                                             120
1243251 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2020   grade_2                                                   148                                             148
1243252 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2020   grade_3                                                   149                                             149
1243253 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2020   grade_4                                                   120                                             120
1243254 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2020   grade_5                                                   154                                             154
1243255 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2020   grade_6                                                   281                                             281
1243256 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2020   grade_7                                                   284                                             284
1243257 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2020   grade_8                                                   290                                             290
1243258 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2020   pk_12_total 63 1236 209   * 68     12   44                             1637 63 1236 209     68     12   44                       1637
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 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 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 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 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
1244206 MD     school 2400510 16   Prince George's 240051000965 1714 Adelphi Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   37                                             37
1244207 MD     school 2400510 16   Prince George's 240051000965 1714 Adelphi Elementary   Regular School No Elementary PK 06 2020   kindergarten                                                   111                                             111
1244208 MD     school 2400510 16   Prince George's 240051000965 1714 Adelphi Elementary   Regular School No Elementary PK 06 2020   grade_1                                                   110                                             110
1244209 MD     school 2400510 16   Prince George's 240051000965 1714 Adelphi Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   123                                             123
1244210 MD     school 2400510 16   Prince George's 240051000965 1714 Adelphi Elementary   Regular School No Elementary PK 06 2020   grade_3                                                   95                                             95
1244211 MD     school 2400510 16   Prince George's 240051000965 1714 Adelphi Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   109                                             109
1244212 MD     school 2400510 16   Prince George's 240051000965 1714 Adelphi Elementary   Regular School No Elementary PK 06 2020   grade_5                                                   86                                             86
1244213 MD     school 2400510 16   Prince George's 240051000965 1714 Adelphi Elementary   Regular School No Elementary PK 06 2020   grade_6                                                   104                                             104
1244214 MD     school 2400510 16   Prince George's 240051000965 1714 Adelphi Elementary   Regular School No Elementary PK 06 2020   pk_12_total 17 128 615   * 11         *                             775 17 128 615     11                                 775
1246565 MD     school 2400090 30   Baltimore City 240009001661 337 Afya Public Charter School   Regular School Yes Middle 07 08 2020   grade_7                                                   118                                             118
1246566 MD     school 2400090 30   Baltimore City 240009001661 337 Afya Public Charter School   Regular School Yes Middle 07 08 2020   grade_8                                                   110                                             110
1246567 MD     school 2400090 30   Baltimore City 240009001661 337 Afya Public Charter School   Regular School Yes Middle 07 08 2020   pk_12_total   215 12               *                             228   215 12                                       228
1242905 MD     school 2400480 15   Montgomery 240048000773 789 Albert Einstein High   Regular School No High 09 12 2020   grade_9                                                   555                                             555
1242906 MD     school 2400480 15   Montgomery 240048000773 789 Albert Einstein High   Regular School No High 09 12 2020   grade_10                                                   476                                             476
1242907 MD     school 2400480 15   Montgomery 240048000773 789 Albert Einstein High   Regular School No High 09 12 2020   grade_11                                                   405                                             405
1242908 MD     school 2400480 15   Montgomery 240048000773 789 Albert Einstein High   Regular School No High 09 12 2020   grade_12                                                   382                                             382
1242909 MD     school 2400480 15   Montgomery 240048000773 789 Albert Einstein High   Regular School No High 09 12 2020   pk_12_total 407 321 882   * 139         65                             1818 407 321 882     139         65                       1818
1245947 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   21                                             21
1245948 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2020   kindergarten                                                   25                                             25
1245949 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   29                                             29
1245950 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   17                                             17
1245951 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2020   grade_3                                                   17                                             17
1245952 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   34                                             34
1245953 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   17                                             17
1245954 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2020   pk_12_total   157 *               *                             160   157                                         160
1237263 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2020   grade_9                                                   168                                             168
1237264 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2020   grade_10                                                   210                                             210
1237265 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2020   grade_11                                                   170                                             170
1237266 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2020   grade_12                                                   173                                             173
1237267 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2020   pk_12_total 631 21 15   * 11         41                             721 631 21 15     11         41                       721
1243350 MD     school 2400510 16   Prince George's 240051000966 632 Allenwood Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   20                                             20
1243351 MD     school 2400510 16   Prince George's 240051000966 632 Allenwood Elementary   Regular School No Elementary PK 06 2020   kindergarten                                                   63                                             63
1243352 MD     school 2400510 16   Prince George's 240051000966 632 Allenwood Elementary   Regular School No Elementary PK 06 2020   grade_1                                                   62                                             62
1243353 MD     school 2400510 16   Prince George's 240051000966 632 Allenwood Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   58                                             58
1243354 MD     school 2400510 16   Prince George's 240051000966 632 Allenwood Elementary   Regular School No Elementary PK 06 2020   grade_3                                                   53                                             53

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