Data source: Big Local News · About: Big Local

1,772 rows where grade = "grade_1" and state = "MD" sorted by total_int

View and edit SQL

year

grade

  • grade_1 · 1,672
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 ▼
1309879 MD     school 2400030 1   Allegany 240003001546 1302 Mt. Savage Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   25                                             25
1313342 MD     school 2400360 11   Garrett 240036000668 1301 Grantsville Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   25                                             25
1317303 MD     school 2400600 18   Saint Mary's 240060001240 503 White Marsh Elementary   Regular School No Elementary KG 05 2021   grade_1                                                   25                                             25
1318335 MD     school 2400090 30   Baltimore City 240009000193 67 Edgewood Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   25                                             25
1318646 MD     school 2400090 30   Baltimore City 240009001428 214 Guilford Elementary/Middle   Regular School No Elementary PK 08 2021   grade_1                                                   25                                             25
1319052 MD     school 2400090 30   Baltimore City 240009001478 326 City Neighbors Charter School   Regular School Yes Elementary KG 08 2021   grade_1                                                   25                                             25
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
1309867 MD     school 2400030 1   Allegany 240003000016 1101 Frost Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   26                                             26
1316878 MD     school 2400510 16   Prince George's 240051000997 1812 Capitol Heights Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   26                                             26
1317678 MD     school 2400660 21   Washington 240066001280 1101 Pleasant Valley Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   26                                             26
1318514 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   26                                             26
1318627 MD     school 2400090 30   Baltimore City 240009000213 212 Garrett Heights Elementary/Middle   Regular School No Elementary PK 08 2021   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
1317051 MD     school 2400510 16   Prince George's 240051001544 2022 Middleton Valley Academy   Regular School No Elementary 01 08 2021   grade_1                                                   27                                             27
1318270 MD     school 2400090 30   Baltimore City 240009000149 58 Dr. Nathan A. Pitts-Ashburton Elementary/Middle   Regular School No Elementary PK 08 2021   grade_1                                                   27                                             27
1318426 MD     school 2400090 30   Baltimore City 240009000208 95 Franklin Square Elementary/Middle   Regular School No Elementary PK 08 2021   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
1313697 MD     school 2400390 12   Harford 240039000708 441 Norrisville Elementary   Regular School No Elementary KG 05 2021   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
1309770 MD     school 2400030 1   Allegany 240003000014 301 Flintstone Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   29                                             29
1309908 MD     school 2400030 1   Allegany 240003000026 2902 Parkside Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   29                                             29
1311871 MD     school 2400120 3   Baltimore County 240012001406 1534 Oliver Beach Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   29                                             29
1312602 MD     school 2400270 8   Charles 240027001492 302 Mt Hope/Nanjemoy Elementary School   Regular School No Elementary PK 05 2021   grade_1                                                   29                                             29
1312839 MD     school 2400300 9   Dorchester 240030000624 302 Vienna Elementary School   Regular School No Elementary PK 05 2021   grade_1                                                   29                                             29
1316368 MD     school 2400510 16   Prince George's 240051000972 1221 Avalon Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   29                                             29
1316856 MD     school 2400510 16   Prince George's 240051001021 1808 Doswell E. Brooks Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   29                                             29
1317378 MD     school 2400600 18   Saint Mary's 240060001239 806 Town Creek Elementary   Regular School No Elementary KG 05 2021   grade_1                                                   29                                             29
1317702 MD     school 2400660 21   Washington 240066001268 1602 Greenbrier Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   29                                             29
1318305 MD     school 2400090 30   Baltimore City 240009000307 63 Rosemont Elementary/Middle   Regular School No Elementary PK 08 2021   grade_1                                                   29                                             29
1318498 MD     school 2400090 30   Baltimore City 240009000303 142 Robert W. Coleman Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   29                                             29
1318972 MD     school 2400090 30   Baltimore City 240009001558 262 Empowerment Academy   Regular School Yes Elementary PK 08 2021   grade_1                                                   29                                             29
1319084 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2021   grade_1                                                   29                                             29
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
1309786 MD     school 2400030 1   Allegany 240003000019 402 John Humbird Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   30                                             30
1312983 MD     school 2400330 10   Frederick 240033001187 226 Monocacy Valley Montessori   Regular School Yes Elementary PK 08 2021   grade_1                                                   30                                             30
1312998 MD     school 2400330 10   Frederick 240033001712 228 Carroll Creek Montessori Public Charter   Regular School Yes Elementary PK 08 2021   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
1309839 MD     school 2400030 1   Allegany 240003000005 702 Bel Air Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   31                                             31
1310407 MD     school 2400060 2   Anne Arundel 240006000130 3212 South Shore Elementary   Regular School No Elementary KG 05 2021   grade_1                                                   31                                             31
1314581 MD     school 2400480 15   Montgomery 240048000809 238 Cold Spring Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   31                                             31
1316385 MD     school 2400510 16   Prince George's 240051001068 1231 J. Frank Dent Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   31                                             31
1317614 MD     school 2400660 21   Washington 240066001269 502 Hancock Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   31                                             31
1318180 MD     school 2400090 30   Baltimore City 240009000184 39 Dallas F. Nicholas, Sr., Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   31                                             31
1318437 MD     school 2400090 30   Baltimore City 240009000179 97 Collington Square Elementary/Middle   Regular School No Elementary PK 08 2021   grade_1                                                   31                                             31
1318551 MD     school 2400090 30   Baltimore City 240009000186 201 Dickey Hill Elementary/Middle   Regular School No Elementary PK 08 2021   grade_1                                                   31                                             31
1318619 MD     school 2400090 30   Baltimore City 240009000212 211 Gardenville Elementary   Regular School No Elementary PK 05 2021   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
1310559 MD     school 2400060 2   Anne Arundel 240006000035 4092 Annapolis Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   32                                             32
1313357 MD     school 2400360 11   Garrett 240036000662 1501 Accident Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   32                                             32
1314287 MD     school 2400450 14   Kent 240045000770 504 Rock Hall Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   32                                             32
1316135 MD     school 2400510 16   Prince George's 240051001010 906 Clinton Grove Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   32                                             32
1316277 MD     school 2400510 16   Prince George's 240051001121 1201 Oxon Hill Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   32                                             32
1316318 MD     school 2400510 16   Prince George's 240051001033 1213 Fort Foote Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   32                                             32
1318019 MD     school 2400090 30   Baltimore City 240009000319 4 Steuart Hill Academic Academy   Regular School No Elementary PK 05 2021   grade_1                                                   32                                             32
1318727 MD     school 2400090 30   Baltimore City 240009000326 226 Violetville Elementary/Middle   Regular School No Elementary PK 08 2021   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
1311816 MD     school 2400120 3   Baltimore County 240012001372 1518 Glenmar Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   33                                             33
1315883 MD     school 2400510 16   Prince George's 240051001113 610 North Forestville Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   33                                             33
1316910 MD     school 2400510 16   Prince George's 240051001183 1828 Robert R. Gray Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   33                                             33
1318522 MD     school 2400090 30   Baltimore City 240009000158 150 Mary Ann Winterling Elementary at Bentalou   Regular School No Elementary PK 05 2021   grade_1                                                   33                                             33
1318716 MD     school 2400090 30   Baltimore City 240009000331 225 Westport Academy   Regular School No Elementary PK 08 2021   grade_1                                                   33                                             33
1319238 MD     school 2400090 30   Baltimore City 240009001752 385 Baltimore International Academy West   Regular School Yes Elementary KG 07 2021   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
1311646 MD     school 2400120 3   Baltimore County 240012000398 1313 Halethorpe Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   34                                             34
1313076 MD     school 2400330 10   Frederick 240033000637 801 Liberty Elementary   Regular School No Elementary KG 05 2021   grade_1                                                   34                                             34
1313720 MD     school 2400390 12   Harford 240039000687 522 Dublin Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   34                                             34
1318964 MD     school 2400090 30   Baltimore City 240009000260 261 Lockerman Bundy Elementary   Regular School No Elementary PK 05 2021   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

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