Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_1 · 1,772
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
1237503 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   grade_1                                                   *                                              
1237980 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other KG 12 2020   grade_1                                                   *                                              
1238135 MD     school 2400060 2   Anne Arundel 240006000056 4304 Central Special School   Special Education School No Other PK 12 2020   grade_1                                                   *                                              
1238284 MD     school 2400120 3   Baltimore County 240012000466 111 Maiden Choice School   Special Education School No Other PK 12 2020   grade_1                                                   *                                              
1238805 MD     school 2400120 3   Baltimore County 240012000483 922 Ridge Ruxton   Special Education School No Other PK 12 2020   grade_1                                                   *                                              
1238997 MD     school 2400120 3   Baltimore County 240012000346 1215 Battle Monument School   Special Education School No Other PK 12 2020   grade_1                                                   *                                              
1239734 MD     school 2400210 6   Carroll 240021000527 712 Carroll Springs School   Special Education School No Other PK 12 2020   grade_1                                                   *                                              
1239767 MD     school 2400210 6   Carroll 240021001349 718 PRIDE School   Alternative School No Elementary 01 05 2020   grade_1                                                   *                                              
1240724 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   grade_1                                                   *                                              
1240827 MD     school 2400360 11   Garrett 240036000676 1812 Swan Meadow School   Regular School No Elementary KG 08 2020   grade_1                                                   *                                              
1241120 MD     school 2400390 12   Harford 240039000703 391 John Archer School   Special Education School No Other PK 12 2020   grade_1                                                   *                                              
1241510 MD     school 2400420 13   Howard 240042001415 522 Cedar Lane Special Center   Special Education School No Other PK 12 2020   grade_1                                                   *                                              
1242960 MD     school 2400480 15   Montgomery 240048000496 799 Stephen Knolls School   Special Education School No Other PK 12 2020   grade_1                                                   *                                              
1243059 MD     school 2400480 15   Montgomery 240048000867 951 Longview School   Special Education School No Other KG 12 2020   grade_1                                                   *                                              
1244438 MD     school 2400510 16   Prince George's 240051001419 2012 Margaret Brent Regional Center   Special Education School No Elementary KG 08 2020   grade_1                                                   *                                              
1244867 MD     school 2400570 19   Somerset 240057001203 1003 Ewell School   Regular School No Elementary PK 07 2020   grade_1                                                   *                                              
1245187 MD     school 2400660 21   Washington 240066001289 2505 Marshall Street School   Special Education School No Other KG 12 2020   grade_1                                                   *                                              
1245414 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   grade_1                                                   *                                              
1245774 MD     school 2400090 30   Baltimore City 240009000164 75 Calverton Elementary/Middle   Regular School No Elementary KG 08 2020   grade_1                                                   *                                              
1246432 MD     school 2400090 30   Baltimore City 240009000336 301 William S. Baer School   Special Education School No Other PK 12 2020   grade_1                                                   *                                              
1246453 MD     school 2400090 30   Baltimore City 240009001364 313 Lois T. Murray Elementary/Middle   Special Education School No Elementary PK 08 2020   grade_1                                                   *                                              
1246462 MD     school 2400090 30   Baltimore City 240009001369 314 Sharp-Leadenhall Elementary   Special Education School No Elementary 01 05 2020   grade_1                                                   *                                              
1310544 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other 01 12 2021   grade_1                                                   *                                              
1310699 MD     school 2400060 2   Anne Arundel 240006000056 4304 Central Special School   Special Education School No Other PK 12 2021   grade_1                                                   *                                              
1310838 MD     school 2400120 3   Baltimore County 240012000466 111 Maiden Choice School   Special Education School No Other PK 12 2021   grade_1                                                   *                                              
1311360 MD     school 2400120 3   Baltimore County 240012000483 922 Ridge/Ruxton School   Special Education School No Other PK 12 2021   grade_1                                                   *                                              
1311552 MD     school 2400120 3   Baltimore County 240012000346 1215 Battle Monument School   Special Education School No Other PK 12 2021   grade_1                                                   *                                              
1312283 MD     school 2400210 6   Carroll 240021000527 712 Carroll Springs School   Special Education School No Other 01 12 2021   grade_1                                                   *                                              
1312315 MD     school 2400210 6   Carroll 240021001349 718 PRIDE School   Alternative School No Elementary 01 05 2021   grade_1                                                   *                                              
1313146 MD     school 2400330 10   Frederick 240033000648 1001 Sabillasville Elementary   Regular School No Elementary KG 05 2021   grade_1                                                   *                                              
1313277 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2021   grade_1                                                   *                                              
1313380 MD     school 2400360 11   Garrett 240036000676 1812 Swan Meadow School   Regular School No Elementary KG 08 2021   grade_1                                                   *                                              
1313676 MD     school 2400390 12   Harford 240039000703 391 John Archer School   Special Education School No Other PK 12 2021   grade_1                                                   *                                              
1314065 MD     school 2400420 13   Howard 240042001415 522 Cedar Lane Special Center   Special Education School No Other PK 12 2021   grade_1                                                   *                                              
1315540 MD     school 2400480 15   Montgomery 240048000496 799 Stephen Knolls School   Special Education School No Other PK 12 2021   grade_1                                                   *                                              
1315639 MD     school 2400480 15   Montgomery 240048000867 951 Longview School   Special Education School No Other KG 12 2021   grade_1                                                   *                                              
1316095 MD     school 2400510 16   Prince George's 240051001384 723 C. Elizabeth Rieg Regional Center   Special Education School No Other KG 12 2021   grade_1                                                   *                                              
1317019 MD     school 2400510 16   Prince George's 240051001419 2012 Margaret Brent Regional Center   Special Education School No Elementary KG 08 2021   grade_1                                                   *                                              
1317443 MD     school 2400570 19   Somerset 240057001203 1003 Ewell School   Regular School No Middle 01 07 2021   grade_1                                                   *                                              
1317763 MD     school 2400660 21   Washington 240066001289 2505 Marshall Street School   Special Education School No Other PK 12 2021   grade_1                                                   *                                              
1317990 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   grade_1                                                   *                                              
1319003 MD     school 2400090 30   Baltimore City 240009001364 313 Lois T. Murray Elementary/Middle   Special Education School No Elementary KG 08 2021   grade_1                                                   *                                              
1319012 MD     school 2400090 30   Baltimore City 240009001369 314 Sharp-Leadenhall Elementary   Special Education School No Elementary 01 05 2021   grade_1                                                   *                                              
1243515 MD     school 2400510 16   Prince George's 240051001384 723 C. Elizabeth Rieg Regional Center   Special Education School No Other KG 12 2020   grade_1                                                   10                                             10
1318983 MD     school 2400090 30   Baltimore City 240009000336 301 William S. Baer School   Special Education School No Other PK 12 2021   grade_1                                                   10                                             10
1239136 MD     school 2400120 3   Baltimore County 240012000459 1406 Red House Run Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   100                                             100
1240675 MD     school 2400330 10   Frederick 240033001015 2107 Whittier Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   100                                             100
1240879 MD     school 2400390 12   Harford 240039000686 120 Deerfield Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   100                                             100
1241285 MD     school 2400420 13   Howard 240042001749 111 Hanover Hills   Regular School No Elementary PK 05 2020   grade_1                                                   100                                             100
1241487 MD     school 2400420 13   Howard 240042000755 517 Swansfield Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   100                                             100
1242298 MD     school 2400480 15   Montgomery 240048000958 417 Wood Acres Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   100                                             100
1243987 MD     school 2400510 16   Prince George's 240051001245 1416 Dora Kennedy French Immersion   Regular School No Elementary KG 08 2020   grade_1                                                   100                                             100
1245429 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2020   grade_1                                                   100                                             100
1310469 MD     school 2400060 2   Anne Arundel 240006001517 3362 Crofton Meadows Elementary   Regular School No Elementary KG 05 2021   grade_1                                                   100                                             100
1310575 MD     school 2400060 2   Anne Arundel 240006000062 4122 Davidsonville Elementary   Regular School No Elementary KG 05 2021   grade_1                                                   100                                             100
1313248 MD     school 2400330 10   Frederick 240033000807 2306 Orchard Grove Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   100                                             100
1316789 MD     school 2400510 16   Prince George's 240051000965 1714 Adelphi Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   100                                             100
1317061 MD     school 2400510 16   Prince George's 240051001764 2023 Legend Public Charter School   Regular School Yes Elementary KG 05 2021   grade_1                                                   100                                             100
1317069 MD     school 2400510 16   Prince George's 240051000512 2106 Greenbelt Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   100                                             100
1238307 MD     school 2400120 3   Baltimore County 240012000357 113 Chadwick Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   101                                             101
1240695 MD     school 2400330 10   Frederick 240033000807 2306 Orchard Grove Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   101                                             101
1241056 MD     school 2400390 12   Harford 240039000698 333 Hickory Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   101                                             101
1241977 MD     school 2400480 15   Montgomery 240048000810 229 College Gardens Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   101                                             101
1242429 MD     school 2400480 15   Montgomery 240048090479 514 Judith A. Resnik Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   101                                             101
1242792 MD     school 2400480 15   Montgomery 240048000873 770 Flora M. Singer Elementary School   Regular School No Elementary PK 05 2020   grade_1                                                   101                                             101
1243934 MD     school 2400510 16   Prince George's 240051001726 1351 Chesapeake Math and IT South Public Charter   Regular School Yes Other KG 12 2020   grade_1                                                   101                                             101
1245292 MD     school 2400690 22   Wicomico 240069001317 909 West Salisbury   Regular School No Elementary PK 02 2020   grade_1                                                   101                                             101
1310385 MD     school 2400060 2   Anne Arundel 240006000114 3182 Pershing Hill Elementary   Regular School No Elementary KG 05 2021   grade_1                                                   101                                             101
1314185 MD     school 2400420 13   Howard 240042000749 612 Phelps Luck Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   101                                             101
1314947 MD     school 2400480 15   Montgomery 240048000868 505 Lucy V. Barnsley Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   101                                             101
1315799 MD     school 2400510 16   Prince George's 240051000866 304 Perrywood Elementary   Regular School No Elementary KG 05 2021   grade_1                                                   101                                             101
1316231 MD     school 2400510 16   Prince George's 240051001708 1015 Chesapeake Math and IT Public Charter   Regular School Yes Other KG 12 2021   grade_1                                                   101                                             101
1316514 MD     school 2400510 16   Prince George's 240051001726 1351 Chesapeake Math and IT South Public Charter   Regular School Yes Other KG 12 2021   grade_1                                                   101                                             101
1238276 MD     school 2400120 3   Baltimore County 240012000410 105 Johnnycake Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   102                                             102
1238926 MD     school 2400120 3   Baltimore County 240012000397 1111 Gunpowder Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   102                                             102
1239498 MD     school 2400150 4   Calvert 240015000790 317 Windy Hill Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   102                                             102
1240360 MD     school 2400330 10   Frederick 240033001355 109 Tuscarora Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   102                                             102
1240708 MD     school 2400330 10   Frederick 240033001748 2308 Butterfly Ridge Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   102                                             102
1242356 MD     school 2400480 15   Montgomery 240048000889 502 Olney Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   102                                             102
1310437 MD     school 2400060 2   Anne Arundel 240006000069 3272 Four Seasons Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   102                                             102
1310806 MD     school 2400120 3   Baltimore County 240012000936 102 Westchester Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   102                                             102
1311947 MD     school 2400150 4   Calvert 240015001102 115 Dowell Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   102                                             102
1312191 MD     school 2400210 6   Carroll 240021000529 506 Carrolltowne Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   102                                             102
1312716 MD     school 2400270 8   Charles 240027000805 622 Berry Elementary School   Regular School No Elementary PK 05 2021   grade_1                                                   102                                             102
1312729 MD     school 2400270 8   Charles 240027001565 624 William A. Diggs Elementary School   Regular School No Elementary PK 05 2021   grade_1                                                   102                                             102
1313949 MD     school 2400420 13   Howard 240042000488 305 Manor Woods Elementary   Regular School No Elementary KG 05 2021   grade_1                                                   102                                             102
1314812 MD     school 2400480 15   Montgomery 240048000785 401 Bethesda Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   102                                             102
1315139 MD     school 2400480 15   Montgomery 240048000931 563 Summit Hall Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   102                                             102
1315433 MD     school 2400480 15   Montgomery 240048001537 779 Sargent Shriver Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   102                                             102
1317710 MD     school 2400660 21   Washington 240066001253 1701 Bester Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   102                                             102
1317755 MD     school 2400660 21   Washington 240066001283 2503 Salem Avenue Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   102                                             102
1318760 MD     school 2400090 30   Baltimore City 240009000161 231 The Belair-Edison School   Regular School Yes Elementary PK 08 2021   grade_1                                                   102                                             102
1238011 MD     school 2400060 2   Anne Arundel 240006000062 4122 Davidsonville Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   103                                             103
1240375 MD     school 2400330 10   Frederick 240033000649 204 Lincoln Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   103                                             103
1242650 MD     school 2400480 15   Montgomery 240048000781 607 Bells Mill Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   103                                             103
1243650 MD     school 2400510 16   Prince George's 240051001708 1015 Chesapeake Math and IT Public Charter   Regular School Yes Other KG 12 2020   grade_1                                                   103                                             103
1245111 MD     school 2400660 21   Washington 240066001274 1301 Maugansville Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   103                                             103
1311630 MD     school 2400120 3   Baltimore County 240012000461 1310 Relay Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   103                                             103
1313042 MD     school 2400330 10   Frederick 240033000652 702 Urbana Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   103                                             103
1313439 MD     school 2400390 12   Harford 240039000485 121 Emmorton Elementary   Regular School No Elementary KG 05 2021   grade_1                                                   103                                             103

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