Integrating legislative Data in your relational database
Know you Legislators And the Schools they serve
A simple example of how you can add legislator data to your current CRM based on “Contacts” and “Organizations”. This was built to help educate both schools and legislators on who they serve or whom is being served.
Starting with and intergration of the Legislator data into a CRM leads to the ability to then produce a great visualization for both partys
Contact ID
First Name
Last Name
Email
Phone #
Legislative Type
District
Contact Data
School Data ( Obviously )
State
State Senate District
State House District
Congressional District
ORg Data
This is a data object that requires no fancy formulas as it was built into a CRM with a few Dropdowns which allow the management of the data. It is a manual process to add new contacts to the CRM but the Orgs will never change.
