enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1240540 1240540 MD     school 2400330 10   Frederick 240033000638 912 Linganore High   Regular School No High 09 12 2020   grade_12                                                   309                                             309
1240541 1240541 MD     school 2400330 10   Frederick 240033000638 912 Linganore High   Regular School No High 09 12 2020   pk_12_total 1131 22 97   * 12     *   46                             1311 1131 22 97     12         46                       1311
1240587 1240587 MD     school 2400330 10   Frederick 240033001688 920 Oakdale High   Regular School No High 09 12 2020   grade_9                                                   338                                             338
1240588 1240588 MD     school 2400330 10   Frederick 240033001688 920 Oakdale High   Regular School No High 09 12 2020   grade_10                                                   308                                             308
1240589 1240589 MD     school 2400330 10   Frederick 240033001688 920 Oakdale High   Regular School No High 09 12 2020   grade_11                                                   307                                             307
1240590 1240590 MD     school 2400330 10   Frederick 240033001688 920 Oakdale High   Regular School No High 09 12 2020   grade_12                                                   314                                             314
1240591 1240591 MD     school 2400330 10   Frederick 240033001688 920 Oakdale High   Regular School No High 09 12 2020   pk_12_total 961 63 116   * 68         54                             1267 961 63 116     68         54                       1267
1240629 1240629 MD     school 2400330 10   Frederick 240033000629 1509 Catoctin High   Regular School No High 09 12 2020   grade_9                                                   220                                             220
1240630 1240630 MD     school 2400330 10   Frederick 240033000629 1509 Catoctin High   Regular School No High 09 12 2020   grade_10                                                   176                                             176
1240631 1240631 MD     school 2400330 10   Frederick 240033000629 1509 Catoctin High   Regular School No High 09 12 2020   grade_11                                                   166                                             166
1240632 1240632 MD     school 2400330 10   Frederick 240033000629 1509 Catoctin High   Regular School No High 09 12 2020   grade_12                                                   187                                             187
1240633 1240633 MD     school 2400330 10   Frederick 240033000629 1509 Catoctin High   Regular School No High 09 12 2020   pk_12_total 672 * 38   * *     *   22                             749 672   38               22                       749
1240701 1240701 MD     school 2400330 10   Frederick 240033001550 2307 Tuscarora High   Regular School No High 09 12 2020   grade_9                                                   448                                             448
1240702 1240702 MD     school 2400330 10   Frederick 240033001550 2307 Tuscarora High   Regular School No High 09 12 2020   grade_10                                                   400                                             400
1240703 1240703 MD     school 2400330 10   Frederick 240033001550 2307 Tuscarora High   Regular School No High 09 12 2020   grade_11                                                   373                                             373
1240704 1240704 MD     school 2400330 10   Frederick 240033001550 2307 Tuscarora High   Regular School No High 09 12 2020   grade_12                                                   369                                             369
1240705 1240705 MD     school 2400330 10   Frederick 240033001550 2307 Tuscarora High   Regular School No High 09 12 2020   pk_12_total 701 340 338   * 112     *   92                             1590 701 340 338     112         92                       1590
1240722 1240722 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   pre_kindergarten                                                   *                                              
1240723 1240723 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   kindergarten                                                   *                                              
1240724 1240724 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   grade_1                                                   *                                              
1240725 1240725 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   grade_2                                                   *                                              
1240726 1240726 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   grade_3                                                   *                                              
1240727 1240727 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   grade_4                                                   *                                              
1240728 1240728 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   grade_5                                                   *                                              
1240729 1240729 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   grade_6                                                   *                                              
1240730 1240730 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   grade_7                                                   *                                              
1240731 1240731 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   grade_8                                                   *                                              
1240732 1240732 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   grade_9                                                   *                                              
1240733 1240733 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   grade_10                                                   *                                              
1240734 1240734 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   grade_11                                                   *                                              
1240735 1240735 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   grade_12                                                   23                                             23
1240736 1240736 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   pk_12_total 43 13 12     *         *                             74 43 13 12                                       74
1240737 1240737 MD     school 2400330 10   Frederick 240033000627 2503 Brunswick High   Regular School No High 09 12 2020   grade_9                                                   230                                             230
1240738 1240738 MD     school 2400330 10   Frederick 240033000627 2503 Brunswick High   Regular School No High 09 12 2020   grade_10                                                   197                                             197
1240739 1240739 MD     school 2400330 10   Frederick 240033000627 2503 Brunswick High   Regular School No High 09 12 2020   grade_11                                                   185                                             185
1240740 1240740 MD     school 2400330 10   Frederick 240033000627 2503 Brunswick High   Regular School No High 09 12 2020   grade_12                                                   180                                             180
1240741 1240741 MD     school 2400330 10   Frederick 240033000627 2503 Brunswick High   Regular School No High 09 12 2020   pk_12_total 604 50 74   * 13         50                             792 604 50 74     13         50                       792
1240766 1240766 MD     school 2400330 10   Frederick 240033000655 2610 Walkersville High   Regular School No High 09 12 2020   grade_9                                                   324                                             324
1240767 1240767 MD     school 2400330 10   Frederick 240033000655 2610 Walkersville High   Regular School No High 09 12 2020   grade_10                                                   307                                             307
1240768 1240768 MD     school 2400330 10   Frederick 240033000655 2610 Walkersville High   Regular School No High 09 12 2020   grade_11                                                   280                                             280
1240769 1240769 MD     school 2400330 10   Frederick 240033000655 2610 Walkersville High   Regular School No High 09 12 2020   grade_12                                                   274                                             274
1240770 1240770 MD     school 2400330 10   Frederick 240033000655 2610 Walkersville High   Regular School No High 09 12 2020   pk_12_total 747 161 145   * 39     *   86                             1185 747 161 145     39         86                       1185
1240852 1240852 MD     school 2400360 11   Garrett 240036000671 3512 Northern Garrett High School   Regular School No High 09 12 2020   grade_9                                                   123                                             123
1240853 1240853 MD     school 2400360 11   Garrett 240036000671 3512 Northern Garrett High School   Regular School No High 09 12 2020   grade_10                                                   117                                             117
1240854 1240854 MD     school 2400360 11   Garrett 240036000671 3512 Northern Garrett High School   Regular School No High 09 12 2020   grade_11                                                   109                                             109
1240855 1240855 MD     school 2400360 11   Garrett 240036000671 3512 Northern Garrett High School   Regular School No High 09 12 2020   grade_12                                                   92                                             92
1240856 1240856 MD     school 2400360 11   Garrett 240036000671 3512 Northern Garrett High School   Regular School No High 09 12 2020   pk_12_total 426   *     *         *                             441 426                                           441
1240857 1240857 MD     school 2400360 11   Garrett 240036000674 3709 Southern Garrett High School   Regular School No High 09 12 2020   grade_9                                                   178                                             178
1240858 1240858 MD     school 2400360 11   Garrett 240036000674 3709 Southern Garrett High School   Regular School No High 09 12 2020   grade_10                                                   170                                             170
1240859 1240859 MD     school 2400360 11   Garrett 240036000674 3709 Southern Garrett High School   Regular School No High 09 12 2020   grade_11                                                   175                                             175
1240860 1240860 MD     school 2400360 11   Garrett 240036000674 3709 Southern Garrett High School   Regular School No High 09 12 2020   grade_12                                                   178                                             178
1240861 1240861 MD     school 2400360 11   Garrett 240036000674 3709 Southern Garrett High School   Regular School No High 09 12 2020   pk_12_total 670 * 12     *         15                             701 670   12               15                       701
1240940 1240940 MD     school 2400390 12   Harford 240039000690 176 Edgewood High   Regular School No High 09 12 2020   grade_9                                                   456                                             456
1240941 1240941 MD     school 2400390 12   Harford 240039000690 176 Edgewood High   Regular School No High 09 12 2020   grade_10                                                   355                                             355
1240942 1240942 MD     school 2400390 12   Harford 240039000690 176 Edgewood High   Regular School No High 09 12 2020   grade_11                                                   324                                             324
1240943 1240943 MD     school 2400390 12   Harford 240039000690 176 Edgewood High   Regular School No High 09 12 2020   grade_12                                                   323                                             323
1240944 1240944 MD     school 2400390 12   Harford 240039000690 176 Edgewood High   Regular School No High 09 12 2020   pk_12_total 466 675 168   * 47     *   95                             1458 466 675 168     47         95                       1458
1240949 1240949 MD     school 2400390 12   Harford 240039000705 181 Joppatowne High   Regular School No High 09 12 2020   grade_9                                                   241                                             241
1240950 1240950 MD     school 2400390 12   Harford 240039000705 181 Joppatowne High   Regular School No High 09 12 2020   grade_10                                                   174                                             174
1240951 1240951 MD     school 2400390 12   Harford 240039000705 181 Joppatowne High   Regular School No High 09 12 2020   grade_11                                                   174                                             174
1240952 1240952 MD     school 2400390 12   Harford 240039000705 181 Joppatowne High   Regular School No High 09 12 2020   grade_12                                                   156                                             156
1240953 1240953 MD     school 2400390 12   Harford 240039000705 181 Joppatowne High   Regular School No High 09 12 2020   pk_12_total 197 383 88   * *     *   60                             745 197 383 88               60                       745
1240958 1240958 MD     school 2400390 12   Harford 240039001638 187 Patterson Mill High School   Regular School No High 09 12 2020   grade_9                                                   211                                             211
1240959 1240959 MD     school 2400390 12   Harford 240039001638 187 Patterson Mill High School   Regular School No High 09 12 2020   grade_10                                                   220                                             220
1240960 1240960 MD     school 2400390 12   Harford 240039001638 187 Patterson Mill High School   Regular School No High 09 12 2020   grade_11                                                   193                                             193
1240961 1240961 MD     school 2400390 12   Harford 240039001638 187 Patterson Mill High School   Regular School No High 09 12 2020   grade_12                                                   201                                             201
1240962 1240962 MD     school 2400390 12   Harford 240039001638 187 Patterson Mill High School   Regular School No High 09 12 2020   pk_12_total 600 73 59     54     *   37                             825 600 73 59     54         37                       825
1240995 1240995 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2020   grade_9                                                   454                                             454
1240996 1240996 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2020   grade_10                                                   331                                             331
1240997 1240997 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2020   grade_11                                                   315                                             315
1240998 1240998 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2020   grade_12                                                   331                                             331
1240999 1240999 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2020   pk_12_total 517 543 145   * 91     *   119                             1431 517 543 145     91         119                       1431
1241000 1241000 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 08 12 2020   grade_8                                                   *                                              
1241001 1241001 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 08 12 2020   grade_9                                                   35                                             35
1241002 1241002 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 08 12 2020   grade_10                                                   15                                             15
1241003 1241003 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 08 12 2020   grade_11                                                   11                                             11
1241004 1241004 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 08 12 2020   grade_12                                                   12                                             12
1241005 1241005 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 08 12 2020   pk_12_total 26 37 *     *         *                             74 26 37                                         74
1241006 1241006 MD     school 2400390 12   Harford 240039000694 304 Harford Technical High   Career and Technical School No High 09 12 2020   grade_9                                                   270                                             270
1241007 1241007 MD     school 2400390 12   Harford 240039000694 304 Harford Technical High   Career and Technical School No High 09 12 2020   grade_10                                                   246                                             246
1241008 1241008 MD     school 2400390 12   Harford 240039000694 304 Harford Technical High   Career and Technical School No High 09 12 2020   grade_11                                                   249                                             249
1241009 1241009 MD     school 2400390 12   Harford 240039000694 304 Harford Technical High   Career and Technical School No High 09 12 2020   grade_12                                                   234                                             234
1241010 1241010 MD     school 2400390 12   Harford 240039000694 304 Harford Technical High   Career and Technical School No High 09 12 2020   pk_12_total 698 145 81   * 34     *   38                             999 698 145 81     34         38                       999
1241095 1241095 MD     school 2400390 12   Harford 240039000683 373 Bel Air High   Regular School No High 09 12 2020   grade_9                                                   401                                             401
1241096 1241096 MD     school 2400390 12   Harford 240039000683 373 Bel Air High   Regular School No High 09 12 2020   grade_10                                                   395                                             395
1241097 1241097 MD     school 2400390 12   Harford 240039000683 373 Bel Air High   Regular School No High 09 12 2020   grade_11                                                   376                                             376
1241098 1241098 MD     school 2400390 12   Harford 240039000683 373 Bel Air High   Regular School No High 09 12 2020   grade_12                                                   388                                             388
1241099 1241099 MD     school 2400390 12   Harford 240039000683 373 Bel Air High   Regular School No High 09 12 2020   pk_12_total 1163 123 102   * 113     *   56                             1560 1163 123 102     113         56                       1560
1241104 1241104 MD     school 2400390 12   Harford 240039000691 382 Fallston High   Regular School No High 09 12 2020   grade_9                                                   248                                             248
1241105 1241105 MD     school 2400390 12   Harford 240039000691 382 Fallston High   Regular School No High 09 12 2020   grade_10                                                   239                                             239
1241106 1241106 MD     school 2400390 12   Harford 240039000691 382 Fallston High   Regular School No High 09 12 2020   grade_11                                                   233                                             233
1241107 1241107 MD     school 2400390 12   Harford 240039000691 382 Fallston High   Regular School No High 09 12 2020   grade_12                                                   253                                             253
1241108 1241108 MD     school 2400390 12   Harford 240039000691 382 Fallston High   Regular School No High 09 12 2020   pk_12_total 839 39 36   * 21     *   35                             973 839 39 36     21         35                       973
1241109 1241109 MD     school 2400390 12   Harford 240039001380 385 C. Milton Wright High   Regular School No High 09 12 2020   grade_9                                                   330                                             330
1241110 1241110 MD     school 2400390 12   Harford 240039001380 385 C. Milton Wright High   Regular School No High 09 12 2020   grade_10                                                   360                                             360
1241111 1241111 MD     school 2400390 12   Harford 240039001380 385 C. Milton Wright High   Regular School No High 09 12 2020   grade_11                                                   300                                             300
1241112 1241112 MD     school 2400390 12   Harford 240039001380 385 C. Milton Wright High   Regular School No High 09 12 2020   grade_12                                                   373                                             373
1241113 1241113 MD     school 2400390 12   Harford 240039001380 385 C. Milton Wright High   Regular School No High 09 12 2020   pk_12_total 1059 97 68   * 82     *   51                             1363 1059 97 68     82         51                       1363
1241118 1241118 MD     school 2400390 12   Harford 240039000703 391 John Archer School   Special Education School No Other PK 12 2020   pre_kindergarten                                                   *                                              
1241119 1241119 MD     school 2400390 12   Harford 240039000703 391 John Archer School   Special Education School No Other PK 12 2020   kindergarten                                                   *                                              

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