Skip to main content

This is for all of you election nerds and DKErs who like to do your own redistricting hypotheticals using Dave's Redistricting App.  Those of you familiar with my past redistricting diaries will notice that I like to organize the data for my districts in an excel spreadsheet, so I decided I would upload the template I use.  It makes presenting CD data very quick and easy with just a little bit of copying and pasting.  Follow me over the fold for brief instructions and examples.

Click for DRA Data Template on gdocs

What's on the template
The purpose of this template is to quickly and effortlessly turn your CD data .csv from DRA into an organized and presentable .xlsx table with excel that you can turn into a jpeg or other picture file to upload and share.  Starting from left to right, the main table displays data that is typically included in redistricting diaries here:

-CD number, color coded using DRA's standard coloring
-Population Deviation from Ideal
-Voting Age Population percentages, colored if a minority group is over or whites are under 50%.  The colors are according to DRA and are gray for majority minority, blue for blacks, green for hispanics, purple for asians, and yellow for native americans.
-Obama/McCain two party vote percentages, colored by winner
-Partisan Average percentage, colored by winner
-2008 PVI
-Partisan Average PVI comparing districts to the statewide average

Thus, with a few clicks you can turn one of these:

Into one of these:

Again, you will notice that districts won by Obama or McCain have their percentage colored blue or red, respectively.  The same goes for Dem/Rep averages and the PVI indexes.  In this map the 1st district was a black VRA seat, so it's black VAP percentage is colored Blue.  Districts that are majority-minority see their white percentage colored gray, even if whites are still a plurality such as the 12th district here.  Also of note, I used the standard district colors, but if you use something else you can of course remove the color fill.

How to use the template

1. Select the state you are working with by scrolling to the far right of the spreadsheet to the list of states.  Copy all of the data and paste it next to the cell that says "state" at the top of the empty middle section.  All 50 states plus D.C. and Puerto Rico are included with population data and partisan averages where available directly from Dave's App.  2008 presidential election data comes from Dave Leip's Atlas.

2. After you have saved your DRA file as a CD data .csv (like the one previously shown), copy the data from that .csv and paste it next to the district numbers in that same empty middle section under the state data.

3. Select the number of districts you want, from 1 to 400, in the green field just next to the main table.  This will determine the deviation (rounding if necessary), which I usually try to keep between +/-1000 so you might change the column margin if you have different parameters.

4. Your main table on the left should now be completed.  If you are using this table for a redistricting diary like I do, all that is left is to copy and paste the data you want into a program such as paint (I use GIMP) so you can upload it as an image and share.  All of the columns (A through P) from CD to avgPVI will fit within DailyKos' 600 pixel width limit for diaries.

That's it, I hope you enjoy it.

Your Email has been sent.
You must add at least one tag to this diary before publishing it.

Add keywords that describe this diary. Separate multiple keywords with commas.
Tagging tips - Search For Tags - Browse For Tags


More Tagging tips:

A tag is a way to search for this diary. If someone is searching for "Barack Obama," is this a diary they'd be trying to find?

Use a person's full name, without any title. Senator Obama may become President Obama, and Michelle Obama might run for office.

If your diary covers an election or elected official, use election tags, which are generally the state abbreviation followed by the office. CA-01 is the first district House seat. CA-Sen covers both senate races. NY-GOV covers the New York governor's race.

Tags do not compound: that is, "education reform" is a completely different tag from "education". A tag like "reform" alone is probably not meaningful.

Consider if one or more of these tags fits your diary: Civil Rights, Community, Congress, Culture, Economy, Education, Elections, Energy, Environment, Health Care, International, Labor, Law, Media, Meta, National Security, Science, Transportation, or White House. If your diary is specific to a state, consider adding the state (California, Texas, etc). Keep in mind, though, that there are many wonderful and important diaries that don't fit in any of these tags. Don't worry if yours doesn't.

You can add a private note to this diary when hotlisting it:
Are you sure you want to remove this diary from your hotlist?
Are you sure you want to remove your recommendation? You can only recommend a diary once, so you will not be able to re-recommend it afterwards.
Rescue this diary, and add a note:
Are you sure you want to remove this diary from Rescue?
Choose where to republish this diary. The diary will be added to the queue for that group. Publish it from the queue to make it appear.

You must be a member of a group to use this feature.

Add a quick update to your diary without changing the diary itself:
Are you sure you want to remove this diary?
(The diary will be removed from the site and returned to your drafts for further editing.)
(The diary will be removed.)
Are you sure you want to save these changes to the published diary?

Comment Preferences

Subscribe or Donate to support Daily Kos.

Click here for the mobile view of the site