enrollments

Data source: Big Local News · About: Big Local

19,213 rows where state = "MD" sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

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 ▼
1317968 1317968 MD     school 2400720 23   Worcester 240072001333 208 Snow Hill Middle   Regular School No Middle 04 08 2021   grade_8                                                   79                                             79
1318042 1318042 MD     school 2400090 30   Baltimore City 240009000175 8 City Springs Elementary/Middle   Regular School Yes Elementary PK 08 2021   grade_8                                                   79                                             79
1318372 1318372 MD     school 2400090 30   Baltimore City 240009000334 83 William Paca Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   79                                             79
1318563 1318563 MD     school 2400090 30   Baltimore City 240009001363 203 Maree Garnett Farring Elementary/Middle   Regular School No Elementary PK 08 2021   grade_2                                                   79                                             79
1318568 1318568 MD     school 2400090 30   Baltimore City 240009001363 203 Maree Garnett Farring Elementary/Middle   Regular School No Elementary PK 08 2021   grade_7                                                   79                                             79
1318808 1318808 MD     school 2400090 30   Baltimore City 240009000222 235 Glenmount Elementary/Middle   Regular School No Elementary PK 08 2021   grade_8                                                   79                                             79
1318874 1318874 MD     school 2400090 30   Baltimore City 240009000147 243 Armistead Gardens Elementary/Middle   Regular School No Elementary PK 08 2021   grade_6                                                   79                                             79
1318945 1318945 MD     school 2400090 30   Baltimore City 240009001390 256 Calvin M. Rodwell Elementary/Middle   Regular School No Elementary PK 08 2021   grade_1                                                   79                                             79
1237221 1237221 MD     school 2400030 1   Allegany 240003001359 401 South Penn Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   80                                             80
1237472 1237472 MD     school 2400060 2   Anne Arundel 240006000116 1212 Point Pleasant Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   80                                             80
1237648 1237648 MD     school 2400060 2   Anne Arundel 240006000125 2202 Severna Park Elementary   Regular School No Elementary KG 05 2020   grade_5                                                   80                                             80
1237664 1237664 MD     school 2400060 2   Anne Arundel 240006000134 2222 Sunset Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   80                                             80
1237839 1237839 MD     school 2400060 2   Anne Arundel 240006000123 3202 Severn Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   80                                             80
1238165 1238165 MD     school 2400060 2   Anne Arundel 240006001401 6223 Chesapeake Science Point   Regular School Yes High 06 12 2020   grade_6                                                   80                                             80
1238682 1238682 MD     school 2400120 3   Baltimore County 240012090440 810 Padonia International Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   80                                             80
1238970 1238970 MD     school 2400120 3   Baltimore County 240012000347 1206 Bear Creek Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   80                                             80
1239022 1239022 MD     school 2400120 3   Baltimore County 240012000421 1217 Logan Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   80                                             80
1239062 1239062 MD     school 2400120 3   Baltimore County 240012000344 1307 Baltimore Highlands Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   80                                             80
1239207 1239207 MD     school 2400120 3   Baltimore County 240012000384 1508 Essex Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   80                                             80
1239286 1239286 MD     school 2400120 3   Baltimore County 240012000369 1525 Deep Creek Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   80                                             80
1239293 1239293 MD     school 2400120 3   Baltimore County 240012000469 1527 Sandalwood Elementary   Regular School No Elementary PK 05 2020   grade_3                                                   80                                             80
1239385 1239385 MD     school 2400150 4   Calvert 240015000778 114 St Leonard Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   80                                             80
1239387 1239387 MD     school 2400150 4   Calvert 240015000778 114 St Leonard Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   80                                             80
1239395 1239395 MD     school 2400150 4   Calvert 240015001102 115 Dowell Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   80                                             80
1239423 1239423 MD     school 2400150 4   Calvert 240015000517 207 Calvert Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   80                                             80
1239424 1239424 MD     school 2400150 4   Calvert 240015000517 207 Calvert Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   80                                             80
1239436 1239436 MD     school 2400150 4   Calvert 240015000511 209 Huntingtown Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   80                                             80
1239709 1239709 MD     school 2400210 6   Carroll 240021000554 705 William Winchester Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   80                                             80
1239905 1239905 MD     school 2400240 7   Cecil 240024000581 316 Thomson Estates Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   80                                             80
1240130 1240130 MD     school 2400270 8   Charles 240027000586 616 Eva Turner Elementary School   Regular School No Elementary PK 05 2020   grade_4                                                   80                                             80
1240237 1240237 MD     school 2400270 8   Charles 240027000591 710 Indian Head Elementary School   Regular School No Elementary PK 05 2020   grade_5                                                   80                                             80
1240240 1240240 MD     school 2400270 8   Charles 240027000606 801 T. C. Martin Elementary School   Regular School No Elementary PK 05 2020   kindergarten                                                   80                                             80
1240394 1240394 MD     school 2400330 10   Frederick 240033000645 210 North Frederick Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   80                                             80
1240424 1240424 MD     school 2400330 10   Frederick 240033090471 223 Ballenger Creek Elementary   Regular School No Elementary PK 05 2020   kindergarten                                                   80                                             80
1240648 1240648 MD     school 2400330 10   Frederick 240033000642 1604 Myersville Elementary   Regular School No Elementary KG 05 2020   grade_5                                                   80                                             80
1240862 1240862 MD     school 2400390 12   Harford 240039000715 113 William S. James Elementary   Regular School No Elementary KG 05 2020   kindergarten                                                   80                                             80
1240864 1240864 MD     school 2400390 12   Harford 240039000715 113 William S. James Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   80                                             80
1240877 1240877 MD     school 2400390 12   Harford 240039000686 120 Deerfield Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   80                                             80
1240909 1240909 MD     school 2400390 12   Harford 240039000706 131 Magnolia Elementary   Regular School No Elementary PK 05 2020   kindergarten                                                   80                                             80
1241015 1241015 MD     school 2400390 12   Harford 240039000681 314 Bel Air Elementary   Regular School No Elementary PK 05 2020   grade_3                                                   80                                             80
1241028 1241028 MD     school 2400390 12   Harford 240039002948 326 Forest Hill Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   80                                             80
1241071 1241071 MD     school 2400390 12   Harford 240039090447 345 Ring Factory Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   80                                             80
1241137 1241137 MD     school 2400390 12   Harford 240039000702 436 Jarrettsville Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   80                                             80
1241188 1241188 MD     school 2400390 12   Harford 240039000695 632 Havre de Grace Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   80                                             80
1241198 1241198 MD     school 2400390 12   Harford 240039000707 638 Meadowvale Elementary   Regular School No Elementary PK 05 2020   grade_3                                                   80                                             80
1241340 1241340 MD     school 2400420 13   Howard 240042000764 213 Worthington Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   80                                             80
1241438 1241438 MD     school 2400420 13   Howard 240042000741 407 Lisbon Elementary   Regular School No Elementary KG 05 2020   grade_5                                                   80                                             80
1241475 1241475 MD     school 2400420 13   Howard 240042000751 515 Running Brook Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   80                                             80
1241566 1241566 MD     school 2400420 13   Howard 240042000733 602 Guilford Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   80                                             80
1241577 1241577 MD     school 2400420 13   Howard 240042000758 604 Waterloo Elementary   Regular School No Elementary PK 05 2020   kindergarten                                                   80                                             80
1241613 1241613 MD     school 2400420 13   Howard 240042000756 609 Talbott Springs Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   80                                             80
1241743 1241743 MD     school 2400480 15   Montgomery 240048001494 100 Clopper Mill Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   80                                             80
1241807 1241807 MD     school 2400480 15   Montgomery 240048010502 110 S. Christa McAuliffe Elementary   Regular School No Elementary PK 05 2020   grade_3                                                   80                                             80
1242007 1242007 MD     school 2400480 15   Montgomery 240048000945 235 Wayside Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   80                                             80
1242192 1242192 MD     school 2400480 15   Montgomery 240048001673 337 William B. Gibbs, Jr. Elementary   Regular School No Elementary PK 05 2020   kindergarten                                                   80                                             80
1242244 1242244 MD     school 2400480 15   Montgomery 240048010503 360 Jones Lane Elementary   Regular School No Elementary KG 05 2020   grade_5                                                   80                                             80
1242395 1242395 MD     school 2400480 15   Montgomery 240048000796 508 Candlewood Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   80                                             80
1242417 1242417 MD     school 2400480 15   Montgomery 240048000846 512 Greenwood Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   80                                             80
1242568 1242568 MD     school 2400480 15   Montgomery 240048000931 563 Summit Hall Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   80                                             80
1242586 1242586 MD     school 2400480 15   Montgomery 240048000829 566 Fields Road Elementary   Regular School No Elementary PK 05 2020   kindergarten                                                   80                                             80
1242591 1242591 MD     school 2400480 15   Montgomery 240048000829 566 Fields Road Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   80                                             80
1242595 1242595 MD     school 2400480 15   Montgomery 240048000927 568 Stedwick Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   80                                             80
1242635 1242635 MD     school 2400480 15   Montgomery 240048000919 603 Seven Locks Elementary   Regular School No Elementary KG 05 2020   grade_5                                                   80                                             80
1242745 1242745 MD     school 2400480 15   Montgomery 240048000821 756 East Silver Spring Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   80                                             80
1242777 1242777 MD     school 2400480 15   Montgomery 240048000844 767 Glen Haven Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   80                                             80
1243182 1243182 MD     school 2400510 16   Prince George's 240051090458 211 Gladys Noon Spellman Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   80                                             80
1243322 1243322 MD     school 2400510 16   Prince George's 240051001050 617 Francis Scott Key Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   80                                             80
1243400 1243400 MD     school 2400510 16   Prince George's 240051000971 640 Arrowhead Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   80                                             80
1243579 1243579 MD     school 2400510 16   Prince George's 240051001180 914 Waldon Woods Elementary   Regular School No Elementary PK 05 2020   kindergarten                                                   80                                             80
1243633 1243633 MD     school 2400510 16   Prince George's 240051000988 1011 Bond Mill Elementary   Regular School No Elementary KG 05 2020   kindergarten                                                   80                                             80
1243871 1243871 MD     school 2400510 16   Prince George's 240051001130 1322 Phyllis E. Williams Elementary   Regular School No Elementary KG 06 2020   grade_1                                                   80                                             80
1243983 1243983 MD     school 2400510 16   Prince George's 240051001001 1414 Catherine T. Reed Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   80                                             80
1244076 1244076 MD     school 2400510 16   Prince George's 240051001106 1504 Melwood Elementary   Regular School No Elementary KG 05 2020   grade_5                                                   80                                             80
1244228 1244228 MD     school 2400510 16   Prince George's 240051000510 1725 Cool Spring Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   80                                             80
1244422 1244422 MD     school 2400510 16   Prince George's 240051000970 2008 Ardmore Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   80                                             80
1244458 1244458 MD     school 2400510 16   Prince George's 240051001085 2014 Lamont Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   80                                             80
1244534 1244534 MD     school 2400510 16   Prince George's 240051001097 2122 Magnolia Elementary   Regular School No Elementary PK 06 2020   grade_5                                                   80                                             80
1244706 1244706 MD     school 2400600 18   Saint Mary's 240060001732 308 Captain Walter Francis Duke Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   80                                             80
1244854 1244854 MD     school 2400570 19   Somerset 240057001201 702 Crisfield Academy and High School   Regular School No High 08 12 2020   grade_11                                                   80                                             80
1244941 1244941 MD     school 2400660 21   Washington 240066001674 40 Barbara Ingram School for the Arts   Regular School No High 09 12 2020   grade_9                                                   80                                             80
1244942 1244942 MD     school 2400660 21   Washington 240066001674 40 Barbara Ingram School for the Arts   Regular School No High 09 12 2020   grade_10                                                   80                                             80
1245060 1245060 MD     school 2400660 21   Washington 240066001254 603 Boonsboro Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   80                                             80
1245138 1245138 MD     school 2400660 21   Washington 240066001253 1701 Bester Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   80                                             80
1245367 1245367 MD     school 2400720 23   Worcester 240072001330 107 Pocomoke High   Regular School No High 09 12 2020   grade_10                                                   80                                             80
1245373 1245373 MD     school 2400720 23   Worcester 240072001329 108 Pocomoke Middle   Regular School No Middle 04 08 2020   grade_6                                                   80                                             80
1245388 1245388 MD     school 2400720 23   Worcester 240072001333 208 Snow Hill Middle   Regular School No Middle 04 08 2020   grade_4                                                   80                                             80
1245740 1245740 MD     school 2400090 30   Baltimore City 240009000270 64 Liberty Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   80                                             80
1245779 1245779 MD     school 2400090 30   Baltimore City 240009000164 75 Calverton Elementary/Middle   Regular School No Elementary KG 08 2020   grade_6                                                   80                                             80
1246184 1246184 MD     school 2400090 30   Baltimore City 240009000257 228 John Ruhrah Elementary/Middle   Regular School No Elementary PK 08 2020   grade_7                                                   80                                             80
1246302 1246302 MD     school 2400090 30   Baltimore City 240009000293 242 Northwood Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   80                                             80
1246679 1246679 MD     school 2400090 30   Baltimore City 240009001703 382 Baltimore Design School   Regular School No High 06 12 2020   grade_6                                                   80                                             80
1246817 1246817 MD     school 2400027 32   SEED 240002701669 1000 The Seed School of Maryland   Regular School No High 06 12 2020   grade_9                                                   80                                             80
1310100 1310100 MD     school 2400060 2   Anne Arundel 240006000038 2052 Arnold Elementary   Regular School No Elementary KG 05 2021   kindergarten                                                   80                                             80
1310113 1310113 MD     school 2400060 2   Anne Arundel 240006000044 2062 Belvedere Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   80                                             80
1310255 1310255 MD     school 2400060 2   Anne Arundel 240006001516 2372 Windsor Farm Elementary   Regular School No Elementary KG 05 2021   grade_1                                                   80                                             80
1310290 1310290 MD     school 2400060 2   Anne Arundel 240006000048 3062 Brock Bridge Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   80                                             80
1310377 1310377 MD     school 2400060 2   Anne Arundel 240006000106 3172 Odenton Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   80                                             80
1310616 1310616 MD     school 2400060 2   Anne Arundel 240006000074 4182 Germantown Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   80                                             80
1310644 1310644 MD     school 2400060 2   Anne Arundel 240006000112 4222 Walter S. Mills - Parole Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   80                                             80
1310745 1310745 MD     school 2400060 2   Anne Arundel 240006001687 6233 Monarch Academy   Regular School Yes Elementary KG 08 2021   grade_8                                                   80                                             80

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