Data source: Big Local News · About: Big Local

2,791 rows where grade = "pk_12_total" and state = "MD" sorted by native_american_alaskan_native

View and edit SQL

grade

  • pk_12_total · 2,691
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
1239603 MD     school 2400210 6   Carroll 240021000545 404 Sandymount Elementary   Regular School No Elementary PK 05 2020   pk_12_total 409 28 38     13     *   *                             497 409 28 38     13                                 497
1239611 MD     school 2400210 6   Carroll 240021000537 406 Mechanicsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 412 17 14     10     *   27                             483 412 17 14     10         27                       483
1239619 MD     school 2400210 6   Carroll 240021000531 501 Eldersburg Elementary   Regular School No Elementary PK 05 2020   pk_12_total 335 28 28     35         23                             449 335 28 28     35         23                       449
1239638 MD     school 2400210 6   Carroll 240021000534 505 Freedom District Elementary   Regular School No Elementary KG 05 2020   pk_12_total 485 17 28     22     *   23                             576 485 17 28     22         23                       576
1239676 MD     school 2400210 6   Carroll 240021000536 601 Manchester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 595 * 39     10     *   10                             663 595   39     10         10                       663
1239693 MD     school 2400210 6   Carroll 240021000550 701 Westminster East Middle   Regular School No Middle 06 08 2020   pk_12_total 554 56 77     18     *   41                             748 554 56 77     18         41                       748
1239710 MD     school 2400210 6   Carroll 240021000554 705 William Winchester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 347 34 102     10         30                             523 347 34 102     10         30                       523
1239715 MD     school 2400210 6   Carroll 240021000552 707 Westminster High   Regular School No High 09 12 2020   pk_12_total 1289 60 69     48     *   55                             1522 1289 60 69     48         55                       1522
1239723 MD     school 2400210 6   Carroll 240021000551 710 Westminster Elementary   Regular School No Elementary PK 05 2020   pk_12_total 382 24 65     29     *   36                             538 382 24 65     29         36                       538
1239744 MD     school 2400210 6   Carroll 240021000527 712 Carroll Springs School   Special Education School No Other PK 12 2020   pk_12_total 26 * *     *                                       33 26                                           33
1239751 MD     school 2400210 6   Carroll 240021000052 714 Friendship Valley Elementary   Regular School No Elementary KG 05 2020   pk_12_total 381 22 53     *     *   22                             488 381 22 53               22                       488
1239766 MD     school 2400210 6   Carroll 240021001348 717 Post Secondary Program   Alternative School No High 12 12 2020   pk_12_total 41 * *                                             44 41                                           44
1239771 MD     school 2400210 6   Carroll 240021001349 718 PRIDE School   Alternative School No Elementary 01 05 2020   pk_12_total * *                                               *                                              
1239774 MD     school 2400210 6   Carroll 240021001694 726 Crossroads Middle School   Alternative School No Middle 06 08 2020   pk_12_total *   *               *                             *                                              
1239786 MD     school 2400210 6   Carroll 240021000535 804 Hampstead Elementary   Regular School No Elementary PK 05 2020   pk_12_total 345 11 19     *         16                             393 345 11 19               16                       393
1239794 MD     school 2400210 6   Carroll 240021090467 806 Spring Garden Elementary   Regular School No Elementary PK 05 2020   pk_12_total 351 15 29     *         16                             416 351 15 29               16                       416
1239798 MD     school 2400210 6   Carroll 240021002947 807 Shiloh Middle   Regular School No Middle 06 08 2020   pk_12_total 553 34 38     15     *   17                             658 553 34 38     15         17                       658
1239802 MD     school 2400210 6   Carroll 240021001350 903 Flexible Student Support   Alternative School No High 09 12 2020   pk_12_total 19         *         *                             22 19                                           22
1239823 MD     school 2400210 6   Carroll 240021001414 1304 Parr's Ridge Elementary   Regular School No Elementary PK 02 2020   pk_12_total 367 * 63     *     *   15                             459 367   63               15                       459
1239857 MD     school 2400240 7   Cecil 240024000565 205 Chesapeake City Elementary   Regular School No Elementary PK 05 2020   pk_12_total 306 * 20               18                             349 306   20               18                       349
1239878 MD     school 2400240 7   Cecil 240024000569 310 Gilpin Manor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 175 139 53     *         52                             425 175 139 53               52                       425
1239890 MD     school 2400240 7   Cecil 240024000564 313 Cherry Hill Middle   Regular School No Middle 06 08 2020   pk_12_total 301 55 50           *   24                             431 301 55 50               24                       431
1239898 MD     school 2400240 7   Cecil 240024000572 315 Leeds Elementary   Regular School No Elementary PK 05 2020   pk_12_total 351 * 26               39                             423 351   26               39                       423
1239914 MD     school 2400240 7   Cecil 240024001491 317 Kenmore Elementary   Regular School No Elementary PK 05 2020   pk_12_total 240 13 33               19                             305 240 13 33               19                       305
1239922 MD     school 2400240 7   Cecil 240024000560 401 Cecil Manor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 191 108 61     *         47                             408 191 108 61               47                       408
1239942 MD     school 2400240 7   Cecil 240024000557 510 Bay View Elementary   Regular School No Elementary PK 05 2020   pk_12_total 346 33 33     10     *   41                             464 346 33 33     10         41                       464
1239950 MD     school 2400240 7   Cecil 240024000563 513 Charlestown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 196 35 *           *   15                             257 196 35                 15                       257
1239963 MD     school 2400240 7   Cecil 240024090468 515 Elk Neck Elementary   Regular School No Elementary PK 05 2020   pk_12_total 399 * 12     *         25                             443 399   12               25                       443
1239975 MD     school 2400240 7   Cecil 240024000579 607 Rising Sun Elementary   Regular School No Elementary PK 05 2020   pk_12_total 602 * 46     *         26                             681 602   46               26                       681
1239987 MD     school 2400240 7   Cecil 240024000576 703 Perryville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 295 36 24     *         35                             393 295 36 24               35                       393
1240067 MD     school 2400270 8   Charles 240027000610 501 Dr. Thomas L. Higdon Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 313 60 14     *         33                             426 313 60 14               33                       426
1240120 MD     school 2400270 8   Charles 240027000582 612 Arthur Middleton Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 57 313 107     19         55                             551 57 313 107     19         55                       551
1240186 MD     school 2400270 8   Charles 240027001565 624 William A. Diggs Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 94 523 58     30     *   66                             775 94 523 58     30         66                       775
1240238 MD     school 2400270 8   Charles 240027000591 710 Indian Head Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 117 251 39     *         59                             473 117 251 39               59                       473
1240259 MD     school 2400270 8   Charles 240027000598 902 Malcolm Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 158 156 59     *     *   55                             436 158 156 59               55                       436
1240267 MD     school 2400270 8   Charles 240027000588 1001 Gale-Bailey Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 192 132 29     *         39                             395 192 132 29               39                       395
1240280 MD     school 2400300 9   Dorchester 240030000625 205 Warwick Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 294 27 18     *         19                             361 294 27 18               19                       361
1240285 MD     school 2400300 9   Dorchester 240030000618 207 North Dorchester High School   Regular School No High 09 12 2020   pk_12_total 349 112 39     *         28                             533 349 112 39               28                       533
1240289 MD     school 2400300 9   Dorchester 240030000619 208 North Dorchester Middle School   Regular School No Middle 06 08 2020   pk_12_total 277 117 34     *         40                             477 277 117 34               40                       477
1240297 MD     school 2400300 9   Dorchester 240030000624 302 Vienna Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 131 26 *     *         18                             183 131 26                 18                       183
1240308 MD     school 2400300 9   Dorchester 240030000622 508 South Dorchester School   Regular School No Elementary PK 08 2020   pk_12_total 196 * 15     *     *   12                             231 196   15               12                       231
1240312 MD     school 2400300 9   Dorchester 240030001423 707 Mace's Lane Middle School   Regular School No Middle 06 08 2020   pk_12_total 72 400 55     *     *   41                             576 72 400 55               41                       576
1240320 MD     school 2400300 9   Dorchester 240030000621 710 Sandy Hill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 77 241 35     *         34                             395 77 241 35               34                       395
1240328 MD     school 2400300 9   Dorchester 240030000617 711 Maple Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 86 265 68     13         46                             478 86 265 68     13         46                       478
1240341 MD     school 2400300 9   Dorchester 240030000841 716 Choptank Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 35 238 62               22                             357 35 238 62               22                       357
1240349 MD     school 2400300 9   Dorchester 240030000614 1503 Hurlock Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 163 133 38     *     *   32                             374 163 133 38               32                       374
1240401 MD     school 2400330 10   Frederick 240033000645 210 North Frederick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 250 122 182     31     *   83                             669 250 122 182     31         83                       669
1240405 MD     school 2400330 10   Frederick 240033000658 211 West Frederick Middle   Regular School No Middle 06 08 2020   pk_12_total 242 229 374     47     *   52                             947 242 229 374     47         52                       947
1240478 MD     school 2400330 10   Frederick 240033001566 314 Middletown Primary   Regular School No Elementary PK 02 2020   pk_12_total 377 16 40     14         30                             477 377 16 40     14         30                       477
1240486 MD     school 2400330 10   Frederick 240033000631 503 Emmitsburg Elementary   Regular School No Elementary PK 05 2020   pk_12_total 193 * *     *         12                             220 193                   12                       220
1240510 MD     school 2400330 10   Frederick 240033000392 714 Windsor Knolls Middle   Regular School No Middle 06 08 2020   pk_12_total 588 32 82     35     *   26                             764 588 32 82     35         26                       764
1240575 MD     school 2400330 10   Frederick 240033000847 917 Deer Crossing Elementary   Regular School No Elementary PK 05 2020   pk_12_total 674 27 55     21     *   28                             806 674 27 55     21         28                       806
1240598 MD     school 2400330 10   Frederick 240033000648 1001 Sabillasville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 75 * *               *                             82 75                                           82
1240606 MD     school 2400330 10   Frederick 240033001442 1105 New Midway/Woodsboro Elementary   Regular School No Elementary PK 05 2020   pk_12_total 251 * 20               16                             292 251   20               16                       292
1240642 MD     school 2400330 10   Frederick 240033001166 1511 Thurmont Primary   Regular School No Elementary PK 02 2020   pk_12_total 301   17     *     *   16                             336 301   17               16                       336
1240665 MD     school 2400330 10   Frederick 240033000636 2001 Lewistown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 139 * 35               14                             195 139   35               14                       195
1240688 MD     school 2400330 10   Frederick 240033090473 2302 Hillcrest Elementary   Regular School No Elementary PK 05 2020   pk_12_total 41 70 561     46         31                             749 41 70 561     46         31                       749
1240713 MD     school 2400330 10   Frederick 240033001748 2308 Butterfly Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 147 201 274     22     *   30                             675 147 201 274     22         30                       675
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
1240757 MD     school 2400330 10   Frederick 240033000656 2606 Walkersville Middle   Regular School No Middle 06 08 2020   pk_12_total 570 108 117     24     *   56                             876 570 108 117     24         56                       876
1240786 MD     school 2400360 11   Garrett 240036000667 1202 Friendsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 133 * *               *                             142 133                                           142
1240794 MD     school 2400360 11   Garrett 240036000668 1301 Grantsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 187   *                                             188 187                                           188
1240801 MD     school 2400360 11   Garrett 240036000665 1408 Crellin Elementary   Regular School No Elementary KG 05 2020   pk_12_total 127   *               *                             135 127                                           135
1240809 MD     school 2400360 11   Garrett 240036000662 1501 Accident Elementary   Regular School No Elementary PK 05 2020   pk_12_total 266   *               *                             281 266                                           281
1240817 MD     school 2400360 11   Garrett 240036000664 1707 Broad Ford Elementary   Regular School No Elementary PK 05 2020   pk_12_total 561 * *               *                             582 561                                           582
1240825 MD     school 2400360 11   Garrett 240036000852 1710 Yough Glades Elementary   Regular School No Elementary PK 05 2020   pk_12_total 295 * *               *                             308 295                                           308
1240835 MD     school 2400360 11   Garrett 240036000676 1812 Swan Meadow School   Regular School No Elementary KG 08 2020   pk_12_total 58   *                                             59 58                                           59
1240843 MD     school 2400360 11   Garrett 240036000673 1904 Route 40 Elementary   Regular School No Elementary PK 05 2020   pk_12_total 130   *               *                             133 130                                           133
1240847 MD     school 2400360 11   Garrett 240036001351 2511 Northern Middle School   Regular School No Middle 06 08 2020   pk_12_total 340   *               *                             357 340                                           357
1240851 MD     school 2400360 11   Garrett 240036000675 2708 Southern Middle School   Regular School No Middle 06 08 2020   pk_12_total 487 * *     *         12                             507 487                   12                       507
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
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
1240891 MD     school 2400390 12   Harford 240039000485 121 Emmorton Elementary   Regular School No Elementary KG 05 2020   pk_12_total 383 59 38     71         41                             592 383 59 38     71         41                       592
1240907 MD     school 2400390 12   Harford 240039000468 125 Church Creek Elementary   Regular School No Elementary PK 05 2020   pk_12_total 273 263 58     24     *   77                             697 273 263 58     24         77                       697
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
1240974 MD     school 2400390 12   Harford 240039000700 211 G. Lisby Elementary at Hillsdale   Regular School No Elementary PK 05 2020   pk_12_total 145 168 34     *     *   57                             413 145 168 34               57                       413
1240982 MD     school 2400390 12   Harford 240039000680 212 Bakerfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 143 141 82     15         45                             426 143 141 82     15         45                       426
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
1241032 MD     school 2400390 12   Harford 240039002948 326 Forest Hill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 429 13 28     13         24                             507 429 13 28     13         24                       507
1241039 MD     school 2400390 12   Harford 240039000394 327 Fountain Green Elementary   Regular School No Elementary KG 05 2020   pk_12_total 374 32 28     29         21                             484 374 32 28     29         21                       484
1241046 MD     school 2400390 12   Harford 240039000692 328 Forest Lakes Elementary   Regular School No Elementary KG 05 2020   pk_12_total 383 * 25     *         22                             445 383   25               22                       445
1241054 MD     school 2400390 12   Harford 240039000712 329 Prospect Mill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 399 62 43     44         43                             591 399 62 43     44         43                       591
1241061 MD     school 2400390 12   Harford 240039000698 333 Hickory Elementary   Regular School No Elementary KG 05 2020   pk_12_total 546 34 41     31     *   37                             691 546 34 41     31         37                       691
1241076 MD     school 2400390 12   Harford 240039090447 345 Ring Factory Elementary   Regular School No Elementary KG 05 2020   pk_12_total 426 31 24     20         38                             539 426 31 24     20         38                       539
1241090 MD     school 2400390 12   Harford 240039001698 349 Red Pump Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 660 25 35     12         40                             772 660 25 35     12         40                       772
1241132 MD     school 2400390 12   Harford 240039000703 391 John Archer School   Special Education School No Other PK 12 2020   pk_12_total 64 36 11     *         *                             123 64 36 11                                       123
1241139 MD     school 2400390 12   Harford 240039000702 436 Jarrettsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 408 * 14     *     *   18                             450 408   14               18                       450
1241146 MD     school 2400390 12   Harford 240039000708 441 Norrisville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 203   *     *     *   *                             218 203                                           218
1241154 MD     school 2400390 12   Harford 240039090476 447 North Bend Elementary   Regular School No Elementary PK 05 2020   pk_12_total 365 * 14     *         17                             402 365   14               17                       402
1241161 MD     school 2400390 12   Harford 240039000685 518 Darlington Elementary   Regular School No Elementary KG 05 2020   pk_12_total 91 * *     *         *                             104 91                                           104
1241169 MD     school 2400390 12   Harford 240039000687 522 Dublin Elementary   Regular School No Elementary PK 05 2020   pk_12_total 199 * 12               16                             230 199   12               16                       230
1241176 MD     school 2400390 12   Harford 240039001443 544 North Harford Elementary   Regular School No Elementary KG 05 2020   pk_12_total 353 * *     *         12                             373 353                   12                       373
1241193 MD     school 2400390 12   Harford 240039000695 632 Havre de Grace Elementary   Regular School No Elementary PK 05 2020   pk_12_total 326 130 60     14     *   78                             609 326 130 60     14         78                       609
1241322 MD     school 2400420 13   Howard 240042000748 209 Patapsco Middle   Regular School No Middle 06 08 2020   pk_12_total 306 96 77     247     *   17                             746 306 96 77     247         17                       746
1241333 MD     school 2400420 13   Howard 240042000727 211 Dunloggin Middle   Regular School No Middle 06 08 2020   pk_12_total 237 105 40     217     *   27                             628 237 105 40     217         27                       628
1241388 MD     school 2400420 13   Howard 240042000760 302 West Friendship Elementary   Regular School No Elementary KG 05 2020   pk_12_total 251 21 16     79     *   25                             393 251 21 16     79         25                       393
1241399 MD     school 2400420 13   Howard 240042000488 305 Manor Woods Elementary   Regular School No Elementary KG 05 2020   pk_12_total 215 44 33     314         21                             627 215 44 33     314         21                       627
1241439 MD     school 2400420 13   Howard 240042000741 407 Lisbon Elementary   Regular School No Elementary KG 05 2020   pk_12_total 353 * 40     16         29                             443 353   40     16         29                       443
1241446 MD     school 2400420 13   Howard 240042000724 505 Clarksville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 129 47 19     224         17                             436 129 47 19     224         17                       436
1241479 MD     school 2400420 13   Howard 240042000751 515 Running Brook Elementary   Regular School No Elementary PK 05 2020   pk_12_total 102 256 52     27     *   46                             484 102 256 52     27         46                       484

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