How you created the visualization: I created the visualization in Adobe Illustrator. The dripping black fluid is meant to symbolize the veil that W.E.B. DuBois invokes repeatedly in "The Souls of Black Folks." Each "drip" is proportional to the number of students studying each educational field.
The United States educational system has long been inequitable, and my visualization is meant to connect the inequitable educational opportunities presented to Black students to DuBois' veil by highlighting how even educational opportunities are determined by one's race.
How I created the visualization: I keyed in the acreage values from Du Bois's Georgia map, and found historical shape files and county areas from the Atlas of Historical County Boundaries at Newberry Library. From there I was able to create a map colored by the percent of land owned by blacks. I used percents instead of raw values for the color to account for the differing county sizes. I sampled the dark and light red colors from Du Bois's map to create the color gradient. I added his city annotations after looking up their coordinates on Wikipedia.
How I created the visualization: I received a copy of “W.E.B. Du Bois’s Data Portraits” for Christmas, and when I saw this contest, I immediately knew that I wanted to create an intensity map for the Georgia map visualization, Plate 20. I downloaded the map shape files for Georgia counties from The Newberry Library, Atlas of Historical Records. Then, I used Tableau to map the counties. I looked up the ICPSR county codes for Georgia to find the corresponding county names. I used the high res file of Du Bois’s Plate 20 from the Library of Congress to record the acres of land owned by Blacks in 1899 in each county. Finally, in Tableau, I made the interactive intensity map. The interactive graph can be seen here: https://public.tableau.com/views/BlackDataProject2019/Plate20 . The iframe code and embed code can also be found there.
How I created the visualization: I received a copy of “W.E.B. Du Bois’s Data Portraits” for Christmas, and when I saw this contest, I knew that I wanted to use the Georgia map visualization, Plate 20. I also wanted to pull in data from Du Bois’s Plate 5 on the Black population in each county, but those were given as ranges rather than as specific numbers. I decided to try to track down Census data from that time. Because 1890 Census data is unavailable, I used 1880 Census data. I accessed this on IPUMS-USA, where I created a data extract that included State and County ICP, farm status, and race. Because I requested the full Census, this data is not allowed to be republished. I used the ipumsr package in R to read in the data from the extract and take the relevant subset of it. Then, I used Excel to make pivot tables to get the number of black individuals and households, farm and nonfarm, for each county code. I looked up the ICPSR county codes for Georgia to find the corresponding county names. I downloaded the map shapefiles for Georgia counties from The Newberry Library, Atlas of Historical Records. Then, I used Tableau to map the counties. I used the high res file of Du Bois’s Plate 20 from the Library of Congress to record the acres of land owned by Blacks in 1899 in each county. After having done this, I came across the Bulletin of the Department of Labor No. 35 - July, 1901, and on page 661 there are estimates for the Black population in each county in 1890. I used these values instead of the 1880 Census values, since they are much closer in date to the data from Plate 20 (1899). I decided to keep the percent farm / nonfarm data, even though it is for 1880, as it seemed interesting and relevant. Finally, in Tableau, I made the interactive maps based on the user’s choice of variable. The interactive maps can be seen here: https://public.tableau.com/profile/leah.dorazio#!/vizhome/BlackDataProject2019/Plate20_plus . The iframe and embed codes can also be found there.
How I created the visualization: First, I analyzed the chart Conjugal Condition of Blacks According to Age Periods published on the blackdataproject website. Next, I extracted each data point from the chart and entered it into an Excel spreadsheet. The file contained four columns (AGE, STATUS, % MALE, % FEMALE) and 28 data rows (including the column header row).
Then, I imported the .xlsx file in Tableau in order to recreate the tornado (aka butterfly chart) originally published by W.E.B. Du Bois in 1900. To create the tornado chart, I used the dual axis bar chart type in Tableau. I used the same colors from the original chart to indicate the conjugal condition of person.
How I created the visualization: I used the blocks of different businesses from the original visualization and applied it into modern business style as stack market screen.
How I created the visualization: Followed its visual title 'study project', I created a visualization to mimic a campus map, every blocks in the campus means the portion of study projects from the original visualization.
How I created the visualization: The original visualization shows the data in a very simple way so that I hope to follow the simplicity but also show a touch of modernism.
How I created the visualization: When W.E.B. Du Bois showcased various graphs, charts, and photographs depicting the lives of Black Americans at the 1900 Paris World’s Fair – he showed the world a snapshot of what it meant to be Black in America following emancipation. This was, and will always remain, a challenging, complex, and undeniably beautiful premise to capture – as blackness exists as both a collective and individualistic experience. Since Du Bois displayed his collection, numerous artists have taken to endless mediums to capture some of the same stories and realities of Black America.
I have taken a collection of artwork from various classic and contemporary Black artists and used these pieces as the backdrop for a reimagining of Du Bois chart “Income and expenditure of 150 Negro families in Atlanta, Ga.” – which gives the viewer an intimate glimpse into the monetary habits of Black families – in an effort to bring further meaning to the boundless variation of what it means to be Black in America. All work was completed in MS Excel (creating a dataset based off of the original chart) and Tableau (visualizing data).
How I created the visualization: W.E.B.. DuBois' original infographic showed the black population of Georgia by county in 1870 and 1880. My version shows the black population of Georgia by county in 1880 and 2010. However, instead of raw population figures, I show it two ways. First based on the black percent of the total population of each county and second based on each county's share of the black population of Georgia. I created my visualization with Tableau, which enabled me to use a range of shades of the same color to illustrate the percents, rather than discrete colors as DuBois used (which were not fully ordered dark to light). My interactive dashboard is published on Tableau Public. The github repository linked above contains a screenshot of my dashboard and a link to the viz on Tableau Public. A button on the right side of the title bar links to my list of sources, including the DuBois infographic mine is based on (which per Kenisha's permission is not one of the ones published on the black data project site) and the various U.S Census data sources I used. There is a small image of DuBois' infographic on the left side of the title bar.
How I created the visualization: I used the Income and Expenses visualization to make a stacked bar graph in Tableau with each income range (class) as a category, and it broken out into the percentage of total income each category is spent on.
How I created the visualization: Based on an article published by the Federal Reserve Bank of Cleveland (https://www.clevelandfed.org/newsroom-and-events/publications/economic-trends/2015-economic-trends/et-20150331-racial-and-ethnic-differences-in-college-major-choice.aspx), I made this stacked bar chart that shows the percentage of each racial group that major in the displayed majors. The selected majors are 4 of the top 5 across racial and ethnic groups.
How I created the visualization: Using Census Data, I created a dynamic pie chart in Microsoft Power BI where one can view both the overall and industry-specific ethnic makeup of business ownership (using five of the major Census racial categories). By default, shown is the overall distribution. In "Filters", click on the checkbox of an industry to view its distribution.
How I created the visualization: Using BLS Consumer Expenditure Survey (CES) Data, I made a dynamic bar graph that shows how much different income groups have spent on housing. You can click on the year to see how these expenditures have changed over time. Note that not all income groups were collected in every year.