SunlightLabs API
Sunlightlabs Cross-Reference Database
A number of non-profits are working together to promote accountability and transparency in elected officials by tracking data such as campaign contributions, votes, lobbying and contracts. The problem is that different organizations use different IDs for the same person.
That is, Senator Obama is N00009638 to the Center for Responsive Politics , 400629 to GovTrack.us and o000167 to the Washington Post. So, if we want to match contributions to Senator Obama (from one site) with Senator Obama's votes (from a different site), there has been no easy way to match IDs. SunlightLabs has created a database to cross-reference all the different IDs for members of congress.
We have compiled basic biographical/clerical information about representatives and senators of the 110th Congress as well as their IDs from a number of non-profits and government data sources:
As well as tying up the IDs, The SunlightLabs have also created APIs (application programmer interfaces, i.e. a way to convert between IDs programmatically) to these data. Thus, a developer can more easily create a mashup that pulls data from one site, gets the ID for that person, coross-references to the ID for the same person but on a different site and bring those two pieces of data together, with confidence that they are the same person. No more matching names with their middle name, nick name variations. We sincerely hope that this database + API will stimulate transparency-related mashup innovation.
A Common ID
The primary key of the data is currently called "entity_id". The final form of this id has yet to be set but is currently "fakeopenID"+integer, e.g., "fakeopenID23". Ultimately, we would like to promote a common ID from the get go. That way, cross-referencing will not be needed and everybody's life will be easier. Think of it as a "social-security number" for members of congress. If everyone uses this ID we—as a community—can track their political activity far more easily.
We are looking to discuss with the community at large what common, organizationally-neutral ID form makes the most sense. A fake social security number, an OpenID-like ID (say something like "cardin.ben.senate.gov") or something else?
What's in the database?
Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/sites/sunlightlabs.com/api/masterref/index.php on line 93
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/sites/sunlightlabs.com/api/masterref/index.php on line 93
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/sites/sunlightlabs.com/api/masterref/index.php on line 94
Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/sites/sunlightlabs.com/api/masterref/index.php on line 97
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/sites/sunlightlabs.com/api/masterref/index.php on line 97
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/sites/sunlightlabs.com/api/masterref/index.php on line 98
Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/sites/sunlightlabs.com/api/masterref/index.php on line 101
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/sites/sunlightlabs.com/api/masterref/index.php on line 101
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/sites/sunlightlabs.com/api/masterref/index.php on line 102
records covering attributes about distinct entities.
The database is organized around entity IDs associated with a name / value pair. This allows us to add new columns—IDs or fields from other organizations—very easily.
These are the name fields used in the database:
Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/sites/sunlightlabs.com/api/masterref/index.php on line 113
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/sites/sunlightlabs.com/api/masterref/index.php on line 113
| Name | Description |
|---|
Data Sources
Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/sites/sunlightlabs.com/api/masterref/index.php on line 133
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/sites/sunlightlabs.com/api/masterref/index.php on line 133
| source_id | Source | Date Accessed |
|---|