Portal:Superdelegate Transparency Project/Help out/Chart cleanup and sourcing

From OpenCongress Wiki

Jump to: navigation, search

This page describes something you can do to further the Superdelegate Transparency Project. There's even more things to do listed at the project's main "help out" page. If you need assistance, please feel free to contact Assistant Congresspedia Editor Avelino Maestas at his talk page or via email at amaestas@sunlightfoundation.com. To begin editing Congresspedia, you'll need to briefly register (this is done to cut down on vandalism and spam). All you need is an email address—click the "Register/Log-In" link in the upper-right-hand corner of this window. You may also find the quick guide to editing useful.


Priority Tasks

Here are the top priority tasks for the project. If you complete a task, please come back to this table and mark it done. Please use the New Mexico table the model for table completion. You will find links at the bottom of the page that will help you find the correct data to enter.

If you complete any of these tasks, be sure to mark it complete in the master table below also. These tables are only to show the current work priority and not as master tracking.

Task Complete
Georgia -- Try to find source for results and enter. Delegate allocation is complete but vote tally is lacking. Updated with Green Papers data---Xscinx 16:05, 27 March 2008 (EDT)
Minnesota -- Needs lots of work on district totals. We may have to call the secretary of state office to obtain

Priority Tasks Needing more info. These are priority tasks which require more info than was available the last time they were worked. The availability of this data should be checked at least every two days and the date changed to reflect the most recent attempt to work. If the task is completed, simply note in this table and admin will archive the task.

Task Complete
Add results for Tennessee Need final votes for several districts, esp. #9 (see discussion page). Delegate allotment is done. --Caffeinated 13:15, 26 February 2008 (EST) (looked for data 3/1 --Markometer 21:00, 1 March 2008 (EST))
Add results for Nevada Partial (need better source for results, esp Dist. 1) --Caffeinated 14:07, 20 February 2008 (EST)
(pending more info)Add caucus results for Maine Updated: Need votes, but delegate allotment is done.--Caffeinated 15:32, 26 February 2008 (EST)

Completed Tasks Archive (Thank You)

Chart Cleanup Checklist

The chart is prioritized, with the most important tasks listed from left-to-right at the top. If you complete a task for a state or find that it has already been completed, please mark it off so we know which ones are finished! Click the signature button above the editing window to let people know who you are and when you finished it (if you like).

In some cases where a task is mostly completed we have noted the items remaining to be done for full completiong. When you have completed one of these tasks, you may over-write these notes.

If you are working an item, please make an indication in the cell so we don't have duplicate edits occurring.

States Election Returns and Endorsement Sourcing Solidify Lists Campaign Contributions Summarize Data
Alabama Up to date --Steve Voght 13:33, 26 February 2008 (EST) Done Done Done
Alaska Up-to-date --Caffeinated 18:38, 23 February 2008 (EST) Done Done Done
Arizona Up to date --Steve Voght 17:38, 22 February 2008 (EST) Done Done Done
Arkansas Left to Do -- One pledged PLEO still to be allocated. Remainder up to date --Steve Voght 17:53, 22 February 2008 (EST) Done Done Done
California State totals need to be fixed --Markometer 11:21, 16 March 2008 (EDT) Done Done Done
Colorado Left to Do -- Vote totals not available yet. Done Done Done
Connecticut Up-to-date --Caffeinated 15:21, 21 February 2008 (EST) Done Done Done
Delaware up to date --Puzzler28 22:01, 14 February 2008 (EST) Presentation Issue Done Done
Florida Up to date --Markometer 14:55, 21 February 2008 (EST) Done Done
Georgia Left to Do -- Delegate tally is complete but vote values for many districts either missing or incomplete. Update state roll-up values once missing or incomplete districts are added. Done Done Done
Hawaii Up to date --Steve Voght 15:43, 22 February 2008 (EST) Done Done Done
Idaho Up to date --Markometer 23:53, 27 February 2008 (EST) Done Done Done
Illinois Up to date --Markometer 22:59, 17 March 2008 (EDT) Might be missing one row Done Done
Indiana Left to Do - up to date pending primary. --Steve Voght 16:28, 22 February 2008 (EST) Done Done
Iowa Current --Markometer 21:38, 1 March 2008 (EST) Done Done Done
Kansas Up to date --Markometer 07:38, 21 February 2008 (EST) Done Done Done
Kentucky Left to Do primary not held yet. Done Done Done
Louisiana Up to Date --Markometer 08:23, 21 February 2008 (EST) Done Done Done
Maine Left to Do - Delegate totals are provided from caucuses, but not raw vote totals. Check back with source later in case they release this information. One DNC superdelegate position is up for election on March 16 -- re-verify position after election. Done Done
Maryland Up to date (vote values from state SoS) --Markometer 00:44, 12 March 2008 (EDT) Up to date Done Done
Massachusetts up-to-date Xscinx 08:20, 15 February 2008 (EST) Done Done Done
Michigan Left to Do - Possible extra row on table. Some superdelegate statuses need to be determined and/or sourced.
Minnesota Left to Do -- Source Vote values.
Mississippi Up to date but primary not held yet --Markometer 13:51, 21 February 2008 (EST)
Missouri Up to date --Markometer 21:48, 1 March 2008 (EST) Done Done Done
Montana Current and pending returns --Markometer 13:54, 21 February 2008 (EST)
Nebraska Up-to-date --Caffeinated 16:26, 21 February 2008 (EST) Done Done Done
Nevada Left to Do -- Need results for Cong Districts 1 and 3 Done Done Done
New Hampshire Done --Steve Voght 14:47, 23 February 2008 (EST) Done
New Jersey Currently on hold --Markometer 15:03, 21 February 2008 (EST) Done Done Done
New Mexico Up to date --Markometer 07:40, 21 February 2008 (EST) Done Done Done
New York Left to do -- Need proper sourcing for most superdelegate pledges (currently most only point to the DemConWatch list, which is not a primary source) Done Done Done
North Carolina current and pending returns --Markometer 14:00, 21 February 2008 (EST)
North Dakota Up-to-date --Caffeinated 18:34, 21 February 2008 (EST) Done Done Done
Ohio up-to-date --Xscinx 11:41, 25 March 2008 (EDT) Done Done Done
Oklahoma Vote totals are very close but final returns are in and this should be updated when possible --Markometer 23:36, 17 March 2008 (EDT) Done Done Done
Oregon current and pending returns --Markometer 22:51, 21 February 2008 (EST) Done Done
Pennsylvania All current except for vote totals (primary in April) Done
Rhode Island up-to-date - Xscinx 13:31, 15 February 2008 (EST) Done
South Carolina up-to-date --Xscinx 08:55, 3 March 2008 (EST) Done Done Done
South Dakota up-to-date --Xscinx 11:41, 25 March 2008 (EDT) Done Done Done
Tennessee Up to date --Steve Voght 16:00, 23 February 2008 (EST) Done
Texas Left to do -- primary/caucus results coming after March 4 Done Done Done
Utah Up to date --Markometer 22:28, 21 February 2008 (EST) Done Done Done
Vermont Up to Date --Markometer 23:14, 15 March 2008 (EDT) Done Done Done
Virginia Up to Date --Markometer 22:28, 21 February 2008 (EST) Done Done Done
Washington Need district-level results for several CDs, but final delegate tallies are up-to-date --Steve Voght 16:14, 22 February 2008 (EST) Done
West Virginia Up to date pending primary --16:47, 22 February 2008 (EST) Done
Wisconsin Current --Markometer 22:03, 9 March 2008 (EDT) Done Done Done
Wyoming Current --Markometer 00:51, 17 March 2008 (EDT) Done Done Done
Non States
American Samoa up-to-date --Dataspig 00:13, 17 February 2008 (EST) Done Done Done
District of Columbia up-to-date --Steve Voght 17:31, 26 February 2008 (EST) Done
Guam up-to-date pending primary --Steve Voght 15:30, 22 February 2008 (EST) Done
Puerto Rico up-to-date, pending primary results --Steve Voght 15:21, 22 February 2008 (EST) Done
Virgin Islands up-to-date --Steve Voght 15:08, 22 February 2008 (EST) Done

Democrats Abroad all vote totals and pledged delegates are complete --Steve Voght 14:04, 21 February 2008 (EST) Done

Find sources for the election returns and superdelegates

One of the basic rules of Congresspedia and its parent wiki, SourceWatch, is that all factual assertions need to be sourced. As such, we need to add references for the pledged (elected) delegate counts and the superdelegate endorsements. At the bottom of each state, district and territory page you will find a list of links under the heading 'External Resources' that will help you to find most of the data needed to fill out the table. You should check a page's talk section by clicking the "Discussion" tab, and check if anybody has recently updated a superdelegate's status.

There's two style of referencing, the beginner's method and the standard method. The standard method is nicer, but the beginner's method will suffice. If you're citing the same reference more than once, you'll save a lot of time by using the standard method and this trick.

See the Alabama page for an example of what a fully-sourced chart should look like. The "Pledged Clinton" column was done using the standard method and the "Pledged Obama" column was made using the beginner's method.

Election returns and delegate allotment

In the past, we relied on USA Today's election results page. However, we've lately noticed this information is not necessarily up-to-date, and we feel more reliable sources are available. The best source of information on election results will likely be Secretaries of State and/or a state's Board of Elections. In addition, in many states (such as New Mexico) political parties funded and organized caucuses and primaries. Try to find an "official" source of information for the returns, and use it.

Remember that most, but not all, of the Secretary of State offices certify the Congressional District-level results, but the delegate allotment is always handled by the state party.


2008 Democratic Convention Watch has one of the most complete lists, which also links to the original sources, so the best place to start is probably that page.

Data Hierarchy

In some cases, superdelegates are officially listed on the roster as the 'DNC' type or 'Distinguished Party Member' type when they are also current members of Congress. One such example is Maxine Waters. In such cases, the superdelegate should be listed in a manner consistent with his or her elected office. This will require the removal of a row from their official type (DNC or Distinguished Party Member).

The Politico has a useful listing of the twenty Distinguished Party Leaders, which can be viewed here.

Solidify Lists

The data in the state/district/territory tables has come from several sources. As a result, some tables might not be complete or might have incorrect information. Specifically, we need to:

  • Fix vacant rows for types "DNC" and "Distinguished Party Leader." To fix you can either delete the row, add name or mark it vacant—whichever is appropriate. You can use the "External Resources" links at the bottom of the state page, which shows the names of the supers will help here. The data hierarchy rules for Distinguished Party Leaders (and perhaps DNC delegates) listed above also apply here. You can check the tables against this list.
  • Check the number of delegates for each congressional district, and also At Large and PLEOs. First preference for sourcing here is the state party site and second preference is The Green Papers.
  • Tally the superdelegates by adding "1" (and, for congressional districts, "+1") in the appropriate column for indicating superdelegate endorsements (see the Iowa page for an example).

Campaign Contributions

Recent reports have indicated that the candidates have given campaign contributions to some Superdelegates. Columns should be added to the tables to track this type of interaction. You can see the columns on the New Mexico page for an example.

Once the columns are there, you can identify contributions made by either campaign to superdelegates. Use Capital Eye as a source, and be sure to follow the referencing guidelines mentioned above.

Summarizing Data

There are rows on each table designated for totaling the number of delegates and superdelegates that are confirmed for each candidate. This data needs to be compiled based on the information located within the table. Summarizing data is putting whatever tallies are possible in the three rows at the bottom of the table, even if some superdelegates are undeclared. Again, use the New Mexico page as an example.