Skip to content

Instantly share code, notes, and snippets.

@asizer

asizer/DCPS racial makeup.csv

Created August 21, 2015 20:23
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save asizer/8dc36ebf1a2697905f70 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save asizer/8dc36ebf1a2697905f70 to your computer and use it in GitHub Desktop.
Download ZIP
DC Public Schools demographics
Raw
readme.MD

This dataset shows demographic data for DC Public Schools from 2012-2013. It includes the racial makeup of individual schools, as well as other populations within the student body (Special Ed, English Language Learners, Free and Reduced Lunch) and scores on standardized tests.

When I was initially looking for this data, I was just planning to visualize the integratedness of each school based on the percent of White and Asian students vs other ethnicities, but I decided to leave the rest of the data in here for more analysis potential (integrated vs test scores vs attendance rates? add a census block group layer and compare school vs neighborhood integration?).

The demographic data was culled by The Urban Institute from DCPS's School Profiles pages. The lat/long of the schools comes from DC's Open Data site.

Raw
DCPS racial makeup.csv
School Lat Lng Total Enrollment Percent of District Enrollment Percent White Percent Asian Percent W&A Percent Black Percent Hispanic Percent Pacific/Hawaiian Percent Native/Alaskan Percent Multiple Races Percent ELL Percent FRL Percent SPED Percent In-Boundary Percent Math BB Percent Math B Percent Math P Percent Math A Percent Math P&A Percent Reading BB Percent Reading B Percent Reading P Percent Reading A Percent Reading P&A Percent Math Improvement Percent Reading Improvement Attendance Rate Re-enrollment Percent Truancy
Aiton Elementary School -76.93370318 38.89700927 252 0.62 0 0 0 100 0 0 0 0 0 99 11 59 40 39 20 1 21 30 53 16 1 17 48 43 92 76 10
Amidon-Bowen Elementary School -77.01812759 38.87952285 293 0.73 2 2 4 92 5 0 0 0 3 99 12 84 44 40 14 3 17 33 46 20 2 22 30 33 93 80 15
Anacostia High School -76.98307953 38.87009151 697 1.73 0 0 0 100 0 0 0 0 0 99 36 71 52 38 9 0 9 47 40 13 0 13 33 34 65 83 67
Ballou High School -77.00097754 38.83939011 791 1.96 0 0 0 99 1 0 0 0 0 99 36 82 39 38 22 1 23 36 44 18 2 20 51 48 69 68 76
Bancroft Elementary School -77.04055574 38.93432582 473 1.17 10 7 17 8 74 0 0 1 65 76 12 52 11 40 37 13 50 18 47 30 5 35 56 63 96 90 2
Barnard Elementary School -77.01777937 38.94823841 569 1.41 3 1 4 52 41 0 0 3 31 99 14 56 12 30 41 18 59 11 33 49 7 56 44 50 94 83 7
Beers Elementary School -76.95560702 38.86435729 384 0.95 0 0 0 99 0 0 0 0 0 99 22 34 18 36 36 10 46 17 35 44 3 47 61 65 90 88 0
Benjamin Banneker High School -77.02397926 38.92384021 394 0.98 1 1 2 85 11 0 0 2 0 59 0 0 0 3 71 25 96 0 13 56 31 87 61 63 97 90 83
Brent Elementary School -77.00146213 38.88480866 358 0.89 64 2 66 22 8 0 0 5 1 11 8 52 5 24 43 29 72 3 25 58 14 72 58 63 96 79 3
Brightwood Education Campus -77.03069114 38.96054319 573 1.42 1 1 2 27 71 0 0 0 49 99 10 80 25 35 35 4 39 24 41 32 2 34 55 51 96 80 3
Brookland Education Campus @ Bunker Hill -76.98499792 38.94201993 274 0.68 0 0 0 90 10 0 0 0 7 99 15 61 17 45 33 4 37 13 49 35 2 37 41 45 94 79 3
Browne Education Campus -76.97066933 38.90260634 364 0.9 0 0 0 97 1 0 0 1 5 99 16 74 25 45 24 6 30 29 48 20 2 22 36 33 92 74 17
Bruce-Monroe Elementary School @ Park View -77.02118796 38.93442156 442 1.1 1 0 1 21 77 0 0 0 62 99 11 59 18 42 36 4 40 21 52 26 2 28 40 65 95 83 1
Burroughs Education Campus -76.97845865 38.93351012 283 0.7 1 0 1 88 10 0 0 0 6 99 25 62 12 33 45 10 55 13 34 43 10 53 58 61 96 82 0
Burrville Elementary School -76.92446144 38.90057322 357 0.89 0 0 0 99 1 0 0 0 0 99 9 57 14 38 38 10 48 17 46 35 2 37 24 26 91 82 17
C.W. Harris Elementary School -76.92611776 38.88360628 265 0.66 0 0 0 98 1 0 0 0 1 99 21 55 33 47 19 0 19 35 50 14 1 15 74 31 91 82 27
Capital Hill Montessori @ Logan -77.00256499 38.89853776 224 0.56 39 1 40 49 4 0 0 7 2 17 4 0 9 47 33 11 44 2 20 67 11 78 60 69 95 86 0
Cardozo High School @ Meyer -77.02847309 38.92217999 537 1.33 1 0 1 68 30 0 0 0 24 99 30 59 31 38 30 2 32 30 45 22 3 25 50 51 75 74 88
Cleveland Elementary School -77.02270947 38.91515274 297 0.74 2 0 2 67 29 0 0 1 21 99 10 24 1 24 40 35 75 3 30 55 12 67 55 51 95 85 2
Columbia Heights Education Campus -77.03586061 38.92955223 1262 3.13 1 2 3 33 63 0 0 0 34 87 9 32 17 35 38 9 47 13 47 34 7 41 57 59 94 90 87
Coolidge High School -77.01958054 38.96729202 490 1.21 0 0 0 87 12 0 0 0 9 99 26 47 18 51 29 3 32 16 49 28 7 35 51 45 80 83 88
Deal Middle School -77.07520138 38.9529042 1165 2.89 42 6 48 32 13 0 0 7 4 22 10 70 4 12 39 46 85 3 15 45 37 82 56 60 96 95 0
Drew Elementary School -76.91992927 38.89600143 164 0.41 0 0 0 98 2 0 0 0 2 99 15 51 52 35 11 3 14 39 36 20 5 25 23 39 91 62 3
Dunbar High School -77.01269376 38.90763401 504 1.25 0 0 0 97 2 0 0 1 2 99 25 46 29 51 20 1 21 29 41 29 1 30 31 45 76 75 82
Eaton Elementary School -77.06582344 38.93273453 459 1.14 42 6 48 33 12 0 0 7 10 18 9 36 2 15 47 36 83 2 12 64 21 85 71 66 97 90 0
Eliot-Hine Middle School -76.9789802 38.89243895 281 0.7 0 0 0 99 1 0 0 0 0 99 31 24 20 34 37 9 46 15 48 28 9 37 39 36 90 82 15
Ellington School of the Arts -77.07030987 38.91345383 531 1.32 10 2 12 76 9 0 0 2 1 36 3 0 3 39 50 8 58 1 25 49 25 74 48 60 94 90 0
Garfield Elementary School -76.97080705 38.85174082 245 0.61 0 0 0 100 0 0 0 0 0 99 16 62 47 41 9 2 11 40 51 9 0 9 44 43 94 74 2
Garrison Elementary School -77.02861485 38.91390875 228 0.57 7 1 8 69 22 0 0 1 15 89 20 45 10 39 40 10 50 16 39 43 1 44 57 41 93 77 7
H.D. Cooke Elementary School -77.03881288 38.92395054 388 0.96 4 3 7 28 63 0 0 1 46 99 8 43 23 48 28 2 30 24 45 30 1 31 41 40 94 84 4
H.D. Woodson High School -76.9223244 38.89679061 710 1.76 0 0 0 100 0 0 0 0 0 99 33 45 40 44 15 2 17 34 44 19 3 22 41 47 74 77 80
Hardy Middle School -77.0686162 38.91551649 404 1 7 4 11 69 17 0 0 3 4 56 12 11 8 24 51 17 68 6 31 49 14 63 45 48 95 88 4
Hart Middle School -76.99718103 38.83774531 517 1.28 0 0 0 99 1 0 0 0 0 99 25 80 29 42 27 2 29 28 49 22 1 23 44 35 90 77 4
Hearst Elementary School -77.07195753 38.94073011 273 0.68 28 4 32 56 6 0 1 4 4 31 10 17 6 34 41 19 60 5 32 53 10 63 49 59 96 83 2
Hendley Elementary School -76.99918712 38.82899335 339 0.84 0 0 0 100 0 0 0 0 0 99 13 94 13 43 38 6 44 24 41 35 1 36 85 70 95 77 1
Houston Elementary School -76.92994991 38.90542278 238 0.59 1 0 1 96 3 0 0 0 1 99 19 67 23 57 19 1 20 18 39 42 1 43 46 30 92 81 11
Hyde-Addison Elementary School -77.06454012 38.90802702 332 0.82 46 11 57 36 6 0 0 1 9 23 9 37 3 16 57 24 81 4 13 64 19 83 69 72 96 84 0
J.O. Wilson Elementary School -76.9965913 38.90276545 408 1.01 3 0 3 91 4 0 0 2 2 99 12 28 10 36 33 21 54 15 39 43 4 47 22 35 96 85 1
Janney Elementary School -77.08099714 38.94755788 599 1.49 74 3 77 7 8 0 0 8 4 2 6 92 0 10 43 47 90 0 7 48 45 93 55 79 97 94 0
Jefferson -77.02291295 38.87987838 279 0.69 0 6 6 91 3 0 0 0 2 99 16 42 19 31 39 11 50 21 49 28 2 30 44 48 91 92 10
Johnson Middle School -76.98370596 38.85134435 244 0.61 0 0 0 100 0 0 0 0 0 99 19 85 33 43 21 2 23 33 49 16 2 18 34 34 86 71 8
Kelly Miller Middle School -76.93245733 38.89332282 353 0.88 0 0 0 99 1 0 0 0 1 99 20 85 20 41 35 4 39 22 54 22 2 24 57 50 90 78 1
Ketcham Elementary School -76.98362344 38.86605014 260 0.64 0 0 0 99 0 0 0 0 0 99 11 41 30 43 25 2 27 28 48 23 1 24 39 44 92 71 0
Key Elementary School -77.10052963 38.92680929 375 0.93 63 5 68 10 11 0 0 10 10 9 7 84 0 8 48 45 93 1 8 61 30 91 55 68 96 82 0
Kimball Elementary School -76.95757498 38.88309054 289 0.72 0 0 0 96 2 0 0 1 0 99 10 75 19 52 25 5 30 16 57 27 1 28 55 53 94 79 0
King Elementary School -76.99824127 38.84245063 311 0.77 0 0 0 100 0 0 0 0 0 99 9 43 29 40 29 2 31 28 45 27 0 27 32 25 96 74 1
Kramer Middle School -76.98017358 38.87129385 277 0.69 0 0 0 99 0 0 0 1 0 99 23 71 31 44 25 1 26 28 55 16 1 17 38 38 90 78 3
Lafayette Elementary School -77.06803943 38.96663502 689 1.71 72 3 75 10 8 0 0 7 2 7 6 90 1 9 52 39 91 2 8 60 30 90 51 65 96 93 0
Langdon Education Campus -76.97708413 38.92471162 350 0.87 0 0 0 92 7 0 0 0 5 99 11 62 9 36 45 11 56 8 34 50 7 57 26 36 95 70 6
Langley Education Campus -77.00589268 38.91517035 417 1.03 1 0 1 93 6 0 0 0 4 99 25 66 26 37 25 11 36 18 41 26 15 41 39 47 93 80 12
LaSalle-Backus Education Campus -76.99988483 38.95997961 288 0.71 0 0 0 69 30 0 0 1 22 99 18 81 41 41 17 1 18 30 50 20 0 20 33 39 94 75 14
Leckie Elementary School -77.0128942 38.82820422 344 0.85 11 1 12 80 7 1 0 0 1 99 10 60 9 53 33 5 38 14 47 38 0 38 33 49 96 72 3
Ludlow-Taylor Elementary School -76.99649478 38.8987516 263 0.65 12 1 13 77 6 0 0 3 2 99 19 23 14 26 36 23 59 12 27 42 19 61 50 39 95 66 0
Luke C. Moore High School -76.99231861 38.93228384 366 0.91 1 0 1 97 2 0 0 0 0 99 6 0 24 68 8 0 8 24 54 19 3 22 45 67 62 0 14
Malcolm X Elementary School -76.98340085 38.84165284 220 0.55 0 0 0 100 0 0 0 0 0 99 16 51 38 45 15 1 16 32 49 18 1 19 36 40 93 62 19
Marie Reed Elementary School -77.04053225 38.9191751 362 0.9 5 9 14 20 66 0 1 0 58 91 11 27 15 27 36 22 58 13 38 46 3 49 74 59 95 85 1
Maury Elementary School -76.98865978 38.89219265 317 0.79 47 1 48 47 3 0 0 1 1 31 6 54 16 39 34 11 45 18 45 32 5 37 28 51 96 87 2
McKinley Technology High School -77.00412472 38.91522758 697 1.73 1 0 1 92 5 0 0 2 1 57 2 0 1 12 77 10 87 0 12 68 20 88 76 61 96 86 85
Miner Elementary School -76.9829066 38.89738347 475 1.18 1 0 1 96 2 0 0 0 1 99 14 32 18 49 29 4 33 23 41 33 2 35 51 54 92 79 5
Moten Elementary School -76.98294593 38.85666497 335 0.83 0 1 1 98 1 0 0 0 0 99 10 83 37 42 21 0 21 36 45 19 0 19 34 32 91 78 19
Murch Elementary School -77.07008152 38.95294098 572 1.42 65 8 73 15 8 0 0 3 9 9 7 83 2 16 42 39 81 3 12 59 27 86 48 69 97 90 0
Nalle Elementary School -76.93079877 38.88596187 335 0.83 0 0 0 94 6 0 0 0 2 99 7 51 30 41 24 5 29 19 58 21 2 23 29 36 92 80 11
Noyes Education Campus -76.99184517 38.92518544 282 0.7 0 0 0 94 5 0 0 0 4 99 13 36 22 45 31 3 34 21 47 31 1 32 42 45 94 66 5
Orr Elementary School -76.97448629 38.87180461 346 0.86 1 1 2 96 1 0 0 1 0 99 14 39 38 42 18 2 20 32 40 27 2 29 34 45 94 79 8
Oyster-Adams Bilingual School -77.04437955 38.91731699 668 1.66 25 2 27 8 60 0 0 4 16 23 12 35 1 17 50 32 82 2 15 57 26 83 55 67 96 88 2
Patterson Elementary School -77.00848699 38.8269738 330 0.82 1 0 1 98 1 0 0 0 0 99 21 74 31 50 11 8 19 32 40 23 5 28 37 42 93 76 0
Payne Elementary School -76.98419719 38.8851401 245 0.61 3 0 3 90 4 0 0 2 0 99 14 34 12 42 43 3 46 12 48 41 0 41 64 63 92 78 8
Phelps Architecture, Construction, and Engineering High School -76.97189991 38.90199948 340 0.84 0 1 1 93 4 0 0 2 2 79 12 0 12 41 44 4 48 3 40 51 6 57 37 53 90 91 78
Plummer Elementary School -76.93993694 38.88724765 263 0.65 0 0 0 89 11 0 0 0 5 99 15 76 13 31 47 9 56 11 44 42 3 45 56 62 91 78 0
Powell Elementary School -77.03122972 38.9415418 391 0.97 2 1 3 12 84 0 0 1 66 99 13 62 15 34 42 9 51 14 49 34 3 37 55 56 94 85 1
Randle Highlands Elementary School -76.96435855 38.87009919 358 0.89 0 0 0 99 0 0 0 0 0 99 15 43 26 39 27 8 35 21 39 38 2 40 51 53 90 75 7
Raymond Education Campus -77.02643495 38.93581867 451 1.12 3 2 5 44 51 0 0 0 37 99 14 52 17 41 38 4 42 14 45 37 3 40 40 47 95 88 6
Roosevelt High School -77.02777864 38.94361597 473 1.17 0 0 0 69 28 0 1 0 21 99 33 63 38 44 15 3 18 48 37 14 2 16 37 19 72 71 74
Ross Elementary School -77.03966444 38.9123986 154 0.38 47 6 53 25 13 0 0 8 18 29 5 40 4 23 42 31 73 8 27 54 10 64 77 40 97 85 1
Savoy Elementary School -76.99360654 38.86285943 387 0.96 0 0 0 99 0 0 0 1 1 99 12 72 44 40 15 1 16 35 46 19 1 20 32 39 91 81 17
School Without Walls High School -77.04818876 38.89813157 548 1.36 35 5 40 45 9 0 0 6 1 17 1 0 0 2 40 58 98 0 2 31 67 98 58 64 95 95 97
Seaton Elementary School -77.02488476 38.91062615 256 0.63 2 11 13 41 46 0 0 0 44 99 15 32 16 39 33 12 45 12 47 32 9 41 60 49 96 83 2
Shepherd Elementary School -77.03399753 38.98461075 314 0.78 5 2 7 79 8 0 0 6 5 32 7 28 7 24 50 19 69 4 19 68 8 76 66 61 96 79 2
Simon Elementary School -77.00019728 38.83598798 270 0.67 0 0 0 100 0 0 0 0 1 99 14 54 19 57 23 1 24 14 49 36 1 37 52 31 94 87 12
Smothers Elementary School -76.9384709 38.89356149 282 0.7 0 0 0 96 4 0 0 0 0 99 13 55 33 36 27 4 31 32 44 21 3 24 37 30 91 77 2
Sousa Middle School -76.95316111 38.88390186 304 0.75 0 0 0 98 2 0 0 0 1 99 21 49 13 34 43 10 53 10 50 34 6 40 37 45 91 89 1
Stanton Elementary School -76.9684925 38.85927955 391 0.97 0 0 0 98 1 0 0 0 0 99 14 59 27 45 26 2 28 39 42 18 1 19 65 56 92 91 11
Stoddert Elementary School -77.07907611 38.9230521 368 0.91 64 4 68 15 11 0 0 5 21 13 5 84 2 13 46 38 84 3 19 60 18 78 67 60 94 95 0
Stuart-Hobson Middle School -77.00000666 38.89630516 371 0.92 9 1 10 87 2 0 0 2 1 55 13 19 8 31 46 15 61 9 32 45 14 59 34 42 96 83 2
Takoma Education Campus -77.02279722 38.97505034 366 0.91 2 0 2 68 28 0 0 1 20 99 13 43 26 37 34 3 37 20 43 35 3 38 30 42 97 83 1
Thomas Elementary School -76.95211318 38.90128643 312 0.77 1 0 1 97 1 0 0 1 0 99 20 74 15 36 38 10 48 9 52 33 6 39 37 45 93 88 7
Thomson Elementary School -77.02843233 38.90350379 300 0.74 1 22 23 19 56 0 0 1 43 99 10 62 6 40 40 14 54 16 35 43 6 49 76 62 95 85 0
Truesdell Education Campus -77.02507387 38.95397616 468 1.16 1 2 3 36 60 0 0 0 32 99 17 84 12 41 40 7 47 20 42 36 3 39 54 51 93 85 1
Tubman Elementary School -77.02944559 38.92920603 506 1.25 1 4 5 42 54 0 0 0 40 99 13 55 7 28 46 19 65 8 40 46 6 52 63 62 95 84 1
Turner Elementary School -76.9803122 38.84764272 339 0.84 0 0 0 96 3 1 0 0 1 99 12 70 35 43 18 4 22 31 47 20 2 22 41 28 92 85 4
Tyler Elementary School -76.99204394 38.88109181 470 1.17 17 1 18 71 9 0 0 1 1 99 17 26 38 40 19 3 22 27 35 31 6 37 32 49 94 83 3
Walker-Jones Education Campus -77.01391815 38.90419955 426 1.06 1 1 2 95 2 0 0 0 2 99 23 68 23 46 28 3 31 22 49 27 3 30 51 53 94 76 20
Washington Metropolitan High School -77.01558696 38.92043757 282 0.7 0 0 0 97 2 0 0 0 2 99 15 0 48 44 8 0 8 29 60 10 0 10 28 44 62 0 33
Watkins Elementary School -76.98999905 38.88347446 527 1.31 22 1 23 72 2 0 0 4 1 41 8 21 8 27 44 21 65 7 34 48 11 59 59 49 96 85 6
West Education Campus -77.03225535 38.95137488 243 0.6 6 0 6 55 34 0 0 5 8 74 11 40 7 43 41 9 50 8 44 44 3 47 58 51 95 81 7
Wheatley Education Campus -76.98850305 38.9041252 465 1.15 1 0 1 95 4 0 0 1 2 99 18 80 26 44 26 4 30 29 45 24 2 26 67 56 92 80 18
Whittier Education Campus -77.0192409 38.96586474 339 0.84 1 1 2 82 15 0 0 1 12 99 15 75 18 39 33 10 43 17 44 37 3 40 47 45 94 80 8
Wilson High School -77.07777751 38.9501636 1713 4.25 22 8 30 47 19 0 0 3 7 38 11 53 13 28 40 20 60 11 29 35 25 60 49 46 90 91 83
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment