Data source: Big Local News · About: Big Local

886 rows where grade = "grade_1", state = "MD" and year = 2020 sorted by total_int

View and edit SQL

year

  • 2020 · 835

grade

  • grade_1 · 835
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 ▼
1240488 MD     school 2400330 10   Frederick 240033000659 603 Wolfsville Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   26                                             26
1243330 MD     school 2400510 16   Prince George's 240051001094 618 Longfields Elementary   Regular School No Elementary PK 06 2020   grade_1                                                   26                                             26
1242661 MD     school 2400480 15   Montgomery 240048000876 652 Monocacy Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   27                                             27
1245119 MD     school 2400660 21   Washington 240066001258 1401 Cascade Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   27                                             27
1245767 MD     school 2400090 30   Baltimore City 240009000312 73 Sarah M. Roach Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   27                                             27
1245872 MD     school 2400090 30   Baltimore City 240009000179 97 Collington Square Elementary/Middle   Regular School No Elementary PK 08 2020   grade_1                                                   27                                             27
1245988 MD     school 2400090 30   Baltimore City 240009000186 201 Dickey Hill Elementary/Middle   Regular School No Elementary PK 08 2020   grade_1                                                   27                                             27
1243804 MD     school 2400510 16   Prince George's 240051001068 1231 J. Frank Dent Elementary   Regular School No Elementary PK 06 2020   grade_1                                                   28                                             28
1246533 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2020   grade_1                                                   28                                             28
1237995 MD     school 2400060 2   Anne Arundel 240006000035 4092 Annapolis Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   29                                             29
1245127 MD     school 2400660 21   Washington 240066001268 1602 Greenbrier Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   29                                             29
1245443 MD     school 2400090 30   Baltimore City 240009000319 4 Steuart Hill Academic Academy   Regular School No Elementary PK 05 2020   grade_1                                                   29                                             29
1245949 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   29                                             29
1246086 MD     school 2400090 30   Baltimore City 240009001428 214 Guilford Elementary/Middle   Regular School No Elementary PK 08 2020   grade_1                                                   29                                             29
1240437 MD     school 2400330 10   Frederick 240033001187 226 Monocacy Valley Montessori   Regular School Yes Elementary PK 08 2020   grade_1                                                   30                                             30
1240452 MD     school 2400330 10   Frederick 240033001712 228 Carroll Creek Montessori Public Charter   Regular School Yes Elementary PK 08 2020   grade_1                                                   30                                             30
1240789 MD     school 2400360 11   Garrett 240036000668 1301 Grantsville Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   30                                             30
1241164 MD     school 2400390 12   Harford 240039000687 522 Dublin Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   30                                             30
1241730 MD     school 2400450 14   Kent 240045000770 504 Rock Hall Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   30                                             30
1246156 MD     school 2400090 30   Baltimore City 240009000331 225 Westport Academy   Regular School No Elementary PK 08 2020   grade_1                                                   30                                             30
1237209 MD     school 2400030 1   Allegany 240003000014 301 Flintstone Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   31                                             31
1244275 MD     school 2400510 16   Prince George's 240051001021 1808 Doswell E. Brooks Elementary   Regular School No Elementary PK 06 2020   grade_1                                                   31                                             31
1246167 MD     school 2400090 30   Baltimore City 240009000326 226 Violetville Elementary/Middle   Regular School No Elementary PK 08 2020   grade_1                                                   31                                             31
1240292 MD     school 2400300 9   Dorchester 240030000624 302 Vienna Elementary School   Regular School No Elementary PK 05 2020   grade_1                                                   32                                             32
1241141 MD     school 2400390 12   Harford 240039000708 441 Norrisville Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   32                                             32
1245039 MD     school 2400660 21   Washington 240066001269 502 Hancock Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   32                                             32
1245585 MD     school 2400090 30   Baltimore City 240009000239 35 Harlem Park Elementary/Middle   Regular School No Elementary PK 08 2020   grade_1                                                   32                                             32
1245694 MD     school 2400090 30   Baltimore City 240009000149 58 Dr. Nathan A. Pitts-Ashburton Elementary/Middle   Regular School No Elementary PK 08 2020   grade_1                                                   32                                             32
1245891 MD     school 2400090 30   Baltimore City 240009000309 122 The Historic Samuel Coleridge-Taylor Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   32                                             32
1237347 MD     school 2400030 1   Allegany 240003000026 2902 Parkside Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   33                                             33
1239945 MD     school 2400240 7   Cecil 240024000563 513 Charlestown Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   33                                             33
1243235 MD     school 2400510 16   Prince George's 240051001039 504 Fort Washington Forest Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   33                                             33
1243555 MD     school 2400510 16   Prince George's 240051001010 906 Clinton Grove Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   33                                             33
1245661 MD     school 2400090 30   Baltimore City 240009000276 53 Margaret Brent Elementary/Middle   Regular School No Elementary PK 08 2020   grade_1                                                   33                                             33
1237440 MD     school 2400060 2   Anne Arundel 240006000102 1172 North Glen Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   34                                             34
1243835 MD     school 2400510 16   Prince George's 240051001135 1307 Highland Park Elementary   Regular School No Elementary PK 06 2020   grade_1                                                   34                                             34
1246048 MD     school 2400090 30   Baltimore City 240009000241 210 Hazelwood Elementary/Middle   Regular School No Elementary PK 08 2020   grade_1                                                   34                                             34
1237225 MD     school 2400030 1   Allegany 240003000019 402 John Humbird Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   35                                             35
1237278 MD     school 2400030 1   Allegany 240003000005 702 Bel Air Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   35                                             35
1244725 MD     school 2400600 18   Saint Mary's 240060001240 503 White Marsh Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   35                                             35
1245531 MD     school 2400090 30   Baltimore City 240009000220 22 George Washington Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   35                                             35
1245604 MD     school 2400090 30   Baltimore City 240009000184 39 Dallas F. Nicholas, Sr., Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   35                                             35
1245721 MD     school 2400090 30   Baltimore City 240009000192 62 Edgecombe Circle Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   35                                             35
1245957 MD     school 2400090 30   Baltimore City 240009000158 150 Mary Ann Winterling Elementary at Bentalou   Regular School No Elementary PK 05 2020   grade_1                                                   35                                             35
1238400 MD     school 2400120 3   Baltimore County 240012000455 210 Powhatan Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   36                                             36
1240367 MD     school 2400330 10   Frederick 240033000646 201 Parkway Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   36                                             36
1240481 MD     school 2400330 10   Frederick 240033000631 503 Emmitsburg Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   36                                             36
1243145 MD     school 2400510 16   Prince George's 240051000414 203 Judith P. Hoyer Montessori   Regular School No Elementary PK 08 2020   grade_1                                                   36                                             36
1243736 MD     school 2400510 16   Prince George's 240051001033 1213 Fort Foote Elementary   Regular School No Elementary PK 06 2020   grade_1                                                   36                                             36
1246067 MD     school 2400090 30   Baltimore City 240009000213 212 Garrett Heights Elementary/Middle   Regular School No Elementary PK 08 2020   grade_1                                                   36                                             36
1246108 MD     school 2400090 30   Baltimore City 240009000156 217 Belmont Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   36                                             36
1238041 MD     school 2400060 2   Anne Arundel 240006000073 4162 Georgetown East Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   37                                             37
1241936 MD     school 2400480 15   Montgomery 240048000937 216 Travilah Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   37                                             37
1243124 MD     school 2400510 16   Prince George's 240051001069 109 James H. Harrison Elementary   Regular School No Elementary PK 06 2020   grade_1                                                   37                                             37
1245941 MD     school 2400090 30   Baltimore City 240009000255 144 James Mosher Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   37                                             37
1246367 MD     school 2400090 30   Baltimore City 240009000187 250 Dr. Bernard Harris, Sr., Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   37                                             37
1237339 MD     school 2400030 1   Allegany 240003001338 2901 Cash Valley Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   38                                             38
1239188 MD     school 2400120 3   Baltimore County 240012000425 1506 Martin Boulevard Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   38                                             38
1240054 MD     school 2400270 8   Charles 240027001492 302 Mt Hope/Nanjemoy Elementary School   Regular School No Elementary PK 05 2020   grade_1                                                   38                                             38
1245151 MD     school 2400660 21   Washington 240066001281 1805 Potomac Heights Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   38                                             38
1245759 MD     school 2400090 30   Baltimore City 240009000193 67 Edgewood Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   38                                             38
1246209 MD     school 2400090 30   Baltimore City 240009000322 232 Thomas Jefferson Elementary/Middle   Regular School No Elementary PK 08 2020   grade_1                                                   38                                             38
1240820 MD     school 2400360 11   Garrett 240036000852 1710 Yough Glades Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   39                                             39
1242017 MD     school 2400480 15   Montgomery 240048000809 238 Cold Spring Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   39                                             39
1244471 MD     school 2400510 16   Prince George's 240051001544 2022 Middleton Valley Academy   Regular School Yes Elementary KG 08 2020   grade_1                                                   39                                             39
1244911 MD     school 2400630 20   Talbot 240063001247 204 St. Michaels Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   39                                             39
1245922 MD     school 2400090 30   Baltimore City 240009000328 134 Walter P. Carter Elementary/Middle   Regular School No Elementary PK 08 2020   grade_1                                                   39                                             39
1237270 MD     school 2400030 1   Allegany 240003000010 701 Cresaptown Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   40                                             40
1237298 MD     school 2400030 1   Allegany 240003000017 1001 George's Creek Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   40                                             40
1237607 MD     school 2400060 2   Anne Arundel 240006000084 2152 Jones Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   40                                             40
1244338 MD     school 2400510 16   Prince George's 240051001462 1830 William W. Hall Academy   Regular School No Elementary PK 08 2020   grade_1                                                   40                                             40
1244986 MD     school 2400660 21   Washington 240066001264 302 Emma K. Doub Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   40                                             40
1246010 MD     school 2400090 30   Baltimore City 240009000277 204 Mary E. Rodman Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   40                                             40
1246413 MD     school 2400090 30   Baltimore City 240009000260 261 Lockerman Bundy Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   40                                             40
1246523 MD     school 2400090 30   Baltimore City 240009001527 328 Southwest Baltimore Charter School   Regular School Yes Elementary PK 08 2020   grade_1                                                   40                                             40
1237286 MD     school 2400030 1   Allegany 240003000033 801 Westernport Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   41                                             41
1237614 MD     school 2400060 2   Anne Arundel 240006000085 2162 Lake Shore Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   41                                             41
1240523 MD     school 2400330 10   Frederick 240033000637 801 Liberty Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   41                                             41
1244409 MD     school 2400510 16   Prince George's 240051001386 2007 Woodridge Elementary   Regular School No Elementary PK 06 2020   grade_1                                                   41                                             41
1244800 MD     school 2400600 18   Saint Mary's 240060001239 806 Town Creek Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   41                                             41
1245159 MD     school 2400660 21   Washington 240066001265 2002 Fountain Rock Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   41                                             41
1245515 MD     school 2400090 30   Baltimore City 240009000258 16 Johnston Square Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   41                                             41
1237242 MD     school 2400030 1   Allegany 240003000024 502 Northeast Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   42                                             42
1237376 MD     school 2400060 2   Anne Arundel 240006000043 1082 Belle Grove Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   42                                             42
1240608 MD     school 2400330 10   Frederick 240033001715 1301 Frederick Classical Charter   Regular School Yes Elementary KG 08 2020   grade_1                                                   42                                             42
1240804 MD     school 2400360 11   Garrett 240036000662 1501 Accident Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   42                                             42
1242407 MD     school 2400480 15   Montgomery 240048000800 511 Cashell Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   42                                             42
1243261 MD     school 2400510 16   Prince George's 240051001132 510 Potomac Landing Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   42                                             42
1244114 MD     school 2400510 16   Prince George's 240051001706 1522 Imagine Foundations at Morningside PCS   Regular School Yes Elementary KG 08 2020   grade_1                                                   42                                             42
1244948 MD     school 2400660 21   Washington 240066001284 101 Sharpsburg Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   42                                             42
1246018 MD     school 2400090 30   Baltimore City 240009000339 205 Woodhome Elementary/Middle   Regular School No Elementary PK 08 2020   grade_1                                                   42                                             42
1246059 MD     school 2400090 30   Baltimore City 240009000212 211 Gardenville Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   42                                             42
1246375 MD     school 2400090 30   Baltimore City 240009000163 251 Callaway Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   42                                             42
1238026 MD     school 2400060 2   Anne Arundel 240006000064 4142 Eastport Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   43                                             43
1241149 MD     school 2400390 12   Harford 240039090476 447 North Bend Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   43                                             43
1242619 MD     school 2400480 15   Montgomery 240048000898 601 Potomac Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   43                                             43
1243404 MD     school 2400510 16   Prince George's 240051001683 645 Andrew Jackson Academy   Regular School No Elementary PK 08 2020   grade_1                                                   43                                             43
1243695 MD     school 2400510 16   Prince George's 240051001121 1201 Oxon Hill Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   43                                             43
1243765 MD     school 2400510 16   Prince George's 240051001179 1218 Valley View Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   43                                             43
1245558 MD     school 2400090 30   Baltimore City 240009000335 28 Sandtown-Winchester Achievement Academy   Regular School No Elementary PK 08 2020   grade_1                                                   43                                             43

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