StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POVisualizing Textual Data: Members of Congress and their affiliations
primarykey
Id
3249112
data
AcceptedAnswerId
3289893
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-07-14T18:12:52.643
FavoriteCount
0
LastActivityDate
2010-07-20T17:35:47.117
LastEditDate
2010-07-20T17:35:47.117
LastEditorUserId
240566
OwnerUserId
340648
ParentId
0
PostTypeId
1
Score
2
ViewCount
230
LastEditorDisplayName
text
Body
I am having a hard time getting started with some way to visualize some data consisting largely of congressional members and their political affiliations. As such it is mostly text data and doesn't lend itself immediately to something like ManyEyes, Google Charts etc. More to the point, I have spreadsheets of data on senators and representatives including their stance on a few relevant legislations and more importantly their membership in certain committees and caucuses. As a spreadsheet, this data is not very informative, I am trying to visualize tangible relationships btw members in terms of most active/salient members across various legislative actions (bills, letters of support) and affiliations (again, committees and caucuses) as well as other useful connections or "networks" that aren't immediately apparent in spreadsheet form. I am at a point where I don't know how to proceed further and was hoping someone could suggest a good start for coming up with a solution. EDIT 1: I've been drawn to SQLite as a tool for this, but I have no interest in copying word for word the spreadsheets I am trying to input into this database into the terminal. EDIT 2: If possible this database needs to be accessible to many different people across a number of different organizations, so not looking for something that is OS or software specific. EDIT 3: Looking at SQLite as a backend, I am interested in a lightweight frontend / database management program that will allow me and others (non-techies) to perform queries that get at defining the value network between entities (congresspeople and the lobbyists that fund them, for example).
Tags
<visualization><relational-database><data-visualization><spreadsheet>
Title
Visualizing Textual Data: Members of Congress and their affiliations
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USJay Askren
UserOwnerUserId
1. USroy
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POVisualizing Textual Data: Members of Congress and their affiliations
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POVisualizing Textual Data: Members of Congress and their affiliations
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.