Target database: US City Legislators

The U.S. City Legislators database replaces the legacy databases for individual city councils (e.g. Los Angeles Councilmembers). Clients using these legacy databases should switch to this database for the most updated information.

Name: USA / English : U.S. City Legislators

Summary

The U.S. City Legislators post code database contains 530 cities and townships, including all U.S. cities with a population over 100K. The database contains nearly 4,500 contacts.

The database is mapped at the city district level, and allows supporters to target their unique district council members (in addition to any council members at large and/or city mayors).

Name	USA / English : U.S. City Legislators
Major update schedule	Post-council elections and quarterly contact validation
Records	~4,500
Region	United States
Single or multi target?	Multi-target
Can be used for Tweet-to-Target pages?	No
Can be used for Click-to-Call pages?	No
Can be used for Political Broadcasts?	No
Can be used for Data Mapping?	No
Allows for target setting filtering?	Yes

Database filtering

The database has two filter fields, allowing supporters to target specific cities (using the filter State / City) with an option to target all contacts or only council members/mayors (by selecting a value in the Role field - Governing Board Member/Top Elected Official respectively).

From the Target settings screen, click the pencil beside “All contacts” to filter the database.

Required fields for targeting

“Address lookup: Validate address based on address details (US only)” in Page Admin settings must be checked to pull contacts for this database.

The tagged fields below must be used. You cannot substitute different tagged fields or untagged fields.

Tagged Field	Definition
Email address	Email address is the primary key and required on all Engaging Networks pages
First Name	Supporter’s First Name
Last Name	Supporter’s Last Name
Address 1	Valid street address
City	Supporter’s City
Region	Supporter's State
Postcode	Valid 5 digit Zip Code

Using the supporter's Address 1, City, State and 5 digit Zip Code, Engaging Networks will append +4 to the supporter’s Zip Code to make it a full 9 digit Zip Code. That 9 digit Zip Code is what is used to return the appropriate contacts.

Structure

Column name	What it holds
Salutation	The complete salutation of the target, e.g. “Dear Senator Smith,”
Organization	The constituency the target represents, e.g. “Los Angeles”.
Position held	The position held by the target, e.g. “Councilmember”
First name	The target’s first name
Last name	The target’s last name
Fax number	Not used
Party image	Not used
Biography 1	City or Township
Biography 2	City district, e.g. “Ward 2”
Biography 3	Target’s city council website URL, e.g. “https://dccouncil.gov/council/ward-2-councilmember-brooke-pinto/”
Biography 4	Target’s current term, e.g. “Jan 2025 - 2029”
Biography 5	State / City, e.g. “CA / Los Angeles”
Biography 6	Role/Subcommittee/s, e.g. “Governing Board Member”
Biography 7	The region, e.g. “CA”
Biography 8	Not used

If you don’t see this database enabled in your account, reach out to support@engagingnetworks.community to have it added!