enrollments

Data source: Big Local News · About: Big Local

19,213 rows where state = "MD" sorted by school_nces_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

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
1317941 1317941 MD     school 2400720 23   Worcester 240072001328 102 Pocomoke Elementary   Regular School No Elementary PK 03 2021   pk_12_total 173 178 41   * *         21                             416 173 178 41               21                       416
1245434 1245434 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   88                                             88
1245435 1245435 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2020   kindergarten                                                   107                                             107
1245436 1245436 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2020   grade_1                                                   88                                             88
1245437 1245437 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   102                                             102
1245438 1245438 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2020   grade_3                                                   105                                             105
1245439 1245439 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   102                                             102
1245440 1245440 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2020   pk_12_total 455 12 76     12         37                             592 455 12 76     12         37                       592
1318010 1318010 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   72                                             72
1318011 1318011 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2021   kindergarten                                                   72                                             72
1318012 1318012 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2021   grade_1                                                   91                                             91
1318013 1318013 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2021   grade_2                                                   92                                             92
1318014 1318014 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2021   grade_3                                                   96                                             96
1318015 1318015 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2021   grade_4                                                   106                                             106
1318016 1318016 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2021   pk_12_total 400 17 72     12         28                             529 400 17 72     12         28                       529
1245412 1245412 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   pre_kindergarten                                                   *                                              
1245413 1245413 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   kindergarten                                                   *                                              
1245414 1245414 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   grade_1                                                   *                                              
1245415 1245415 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   grade_2                                                   *                                              
1245416 1245416 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   grade_3                                                   *                                              
1245417 1245417 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   grade_4                                                   *                                              
1245418 1245418 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   grade_5                                                   *                                              
1245419 1245419 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   grade_6                                                   *                                              
1245420 1245420 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   grade_7                                                   *                                              
1245421 1245421 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   grade_8                                                   *                                              
1245422 1245422 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   grade_9                                                   *                                              
1245423 1245423 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   grade_10                                                   *                                              
1245424 1245424 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   grade_11                                                   *                                              
1245425 1245425 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   grade_12                                                   15                                             15
1245426 1245426 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   pk_12_total 28 19 *     *         *                             55 28 19                                         55
1317988 1317988 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   pre_kindergarten                                                   *                                              
1317989 1317989 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   kindergarten                                                   *                                              
1317990 1317990 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   grade_1                                                   *                                              
1317991 1317991 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   grade_2                                                   *                                              
1317992 1317992 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   grade_3                                                   *                                              
1317993 1317993 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   grade_4                                                   *                                              
1317994 1317994 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   grade_5                                                   *                                              
1317995 1317995 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   grade_6                                                   *                                              
1317996 1317996 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   grade_7                                                   *                                              
1317997 1317997 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   grade_8                                                   *                                              
1317998 1317998 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   grade_9                                                   *                                              
1317999 1317999 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   grade_10                                                   *                                              
1318000 1318000 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   grade_11                                                   *                                              
1318001 1318001 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   grade_12                                                   12                                             12
1318002 1318002 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   pk_12_total 27 16 *     *         *                             50 27 16                                         50
1245427 1245427 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   88                                             88
1245428 1245428 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2020   kindergarten                                                   84                                             84
1245429 1245429 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2020   grade_1                                                   100                                             100
1245430 1245430 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   92                                             92
1245431 1245431 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2020   grade_3                                                   100                                             100
1245432 1245432 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   96                                             96
1245433 1245433 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2020   pk_12_total 296 131 70     *         55                             560 296 131 70               55                       560
1318003 1318003 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   62                                             62
1318004 1318004 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2021   kindergarten                                                   75                                             75
1318005 1318005 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2021   grade_1                                                   81                                             81
1318006 1318006 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2021   grade_2                                                   92                                             92
1318007 1318007 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2021   grade_3                                                   87                                             87
1318008 1318008 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2021   grade_4                                                   97                                             97
1318009 1318009 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2021   pk_12_total 254 130 57     *         47                             494 254 130 57               47                       494
1245402 1245402 MD     school 2400720 23   Worcester 240072001323 311 Berlin Intermediate   Regular School No Middle 04 06 2020   grade_4                                                   138                                             138
1245403 1245403 MD     school 2400720 23   Worcester 240072001323 311 Berlin Intermediate   Regular School No Middle 04 06 2020   grade_5                                                   331                                             331
1245404 1245404 MD     school 2400720 23   Worcester 240072001323 311 Berlin Intermediate   Regular School No Middle 04 06 2020   grade_6                                                   330                                             330
1245405 1245405 MD     school 2400720 23   Worcester 240072001323 311 Berlin Intermediate   Regular School No Middle 04 06 2020   pk_12_total 584 63 73   * 19         59                             799 584 63 73     19         59                       799
1317978 1317978 MD     school 2400720 23   Worcester 240072001323 311 Berlin Intermediate   Regular School No Middle 05 06 2021   grade_5                                                   329                                             329
1317979 1317979 MD     school 2400720 23   Worcester 240072001323 311 Berlin Intermediate   Regular School No Middle 05 06 2021   grade_6                                                   329                                             329
1317980 1317980 MD     school 2400720 23   Worcester 240072001323 311 Berlin Intermediate   Regular School No Middle 05 06 2021   pk_12_total 458 59 69     17         55                             658 458 59 69     17         55                       658
1245394 1245394 MD     school 2400720 23   Worcester 240072000880 308 Stephen Decatur Middle   Regular School No Middle 07 08 2020   grade_7                                                   373                                             373
1245395 1245395 MD     school 2400720 23   Worcester 240072000880 308 Stephen Decatur Middle   Regular School No Middle 07 08 2020   grade_8                                                   313                                             313
1245396 1245396 MD     school 2400720 23   Worcester 240072000880 308 Stephen Decatur Middle   Regular School No Middle 07 08 2020   pk_12_total 496 57 68   * 14         49                             686 496 57 68     14         49                       686
1317970 1317970 MD     school 2400720 23   Worcester 240072000880 308 Stephen Decatur Middle   Regular School No Middle 07 08 2021   grade_7                                                   326                                             326
1317971 1317971 MD     school 2400720 23   Worcester 240072000880 308 Stephen Decatur Middle   Regular School No Middle 07 08 2021   grade_8                                                   365                                             365
1317972 1317972 MD     school 2400720 23   Worcester 240072000880 308 Stephen Decatur Middle   Regular School No Middle 07 08 2021   pk_12_total 484 59 75   * 13         58                             691 484 59 75     13         58                       691
1245336 1245336 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2020   pre_kindergarten                                                   40                                             40
1245337 1245337 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2020   kindergarten                                                   70                                             70
1245338 1245338 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2020   grade_1                                                   66                                             66
1245339 1245339 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2020   grade_2                                                   74                                             74
1245340 1245340 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2020   grade_3                                                   73                                             73
1245341 1245341 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2020   pk_12_total 259 * 27   * *     *   27                             323 259   27               27                       323
1317912 1317912 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2021   pre_kindergarten                                                   20                                             20
1317913 1317913 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2021   kindergarten                                                   56                                             56
1317914 1317914 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2021   grade_1                                                   61                                             61
1317915 1317915 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2021   grade_2                                                   56                                             56
1317916 1317916 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2021   grade_3                                                   67                                             67
1317917 1317917 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2021   pk_12_total 209 * 23   * *     *   22                             260 209   23               22                       260
1245254 1245254 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2020   grade_9                                                   305                                             305
1245255 1245255 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2020   grade_10                                                   256                                             256
1245256 1245256 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2020   grade_11                                                   265                                             265
1245257 1245257 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2020   grade_12                                                   253                                             253
1245258 1245258 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2020   pk_12_total 323 535 112   * 31         74                             1079 323 535 112     31         74                       1079
1317830 1317830 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2021   grade_9                                                   307                                             307
1317831 1317831 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2021   grade_10                                                   330                                             330
1317832 1317832 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2021   grade_11                                                   274                                             274
1317833 1317833 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2021   grade_12                                                   279                                             279
1317834 1317834 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2021   pk_12_total 306 592 178   * 32     *   77                             1190 306 592 178     32         77                       1190
1245246 1245246 MD     school 2400690 22   Wicomico 240069001319 510 Wicomico Middle   Regular School No Middle 06 08 2020   grade_6                                                   305                                             305
1245247 1245247 MD     school 2400690 22   Wicomico 240069001319 510 Wicomico Middle   Regular School No Middle 06 08 2020   grade_7                                                   283                                             283
1245248 1245248 MD     school 2400690 22   Wicomico 240069001319 510 Wicomico Middle   Regular School No Middle 06 08 2020   grade_8                                                   287                                             287
1245249 1245249 MD     school 2400690 22   Wicomico 240069001319 510 Wicomico Middle   Regular School No Middle 06 08 2020   pk_12_total 198 419 156   * 16     *   77                             875 198 419 156     16         77                       875
1317822 1317822 MD     school 2400690 22   Wicomico 240069001319 510 Wicomico Middle   Regular School No Middle 06 08 2021   grade_6                                                   274                                             274
1317823 1317823 MD     school 2400690 22   Wicomico 240069001319 510 Wicomico Middle   Regular School No Middle 06 08 2021   grade_7                                                   281                                             281

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