MyJSQLView GUI
- Became a project on
- September 10, 2010
MyJSQLView GUI for access to Sunlight LABS legislators data set. Easy sorting, searching, import, export and data profiling.
January 15, 2011
Last night update the Legislator Dump data to my site's database. That data looks to have all the new Congressional members that were sworn in this month. Since I'm sure some of that information is going to be updated periodically because of members adding various contact information, Twitter etc., I will continue to check Sunlight Labs Data for at least the next month or so to try and keep up to date.
December 16, 2010
Recently updated the latest Sunlight Labs Legislator dump to my site's database for Congress. Will do so again in January once the new Congress is seated. Though the MyJSQLView GUI is a desktop application users may use it to generate a DML dump from my site's database to a local system. MyJSQLView can also be used to generated the required SQL data structure to create your own local database. MyJSQLView works with several databases, including SQLite which essentially means you can have a local file of the legislators to use on your PC. Then use MyJSQLView locally to search the data set. Still planning a plug-in too be exclusively used with Sunlight Labs Legislator data set.
Project Participants
Lead
Dana Proctor