Lobbyist Directory
Dataset
| Name | Value |
|---|---|
| Catalog | Link |
| Metadata | Link |
| Data: JSON | 100 Rows |
| Data: CSV | 100 Rows |
| Host | data.sfgov.org |
| Id | exbu-si57 |
| Name | Lobbyist Directory |
| Attribution | San Francisco Ethics Commission |
| Category | City Management and Ethics |
| Tags | ethics, lobbyist, directory, registered, individual, firm, photo |
| Created | 2012-04-26T19:37:35Z |
| Publication Date | 2014-09-29T21:19:31Z |
Description
The directory of individual lobbyists contains a list of all lobbyists registered with the San Francisco Ethics Commission.This dataset updates automatically every night.
Columns
| Included | Schema Type | Field Name | Name | Data Type | Render Type |
| ======== | =========== | =============== | ================== | ============= | ============= |
| Yes | series tag | fullname | FullName | text | text |
| Yes | series tag | firmname | FirmName | text | text |
| Yes | series tag | filerid | FilerId | text | text |
| No | | addressline1 | AddressLine1 | text | text |
| No | | addressline2 | AddressLine2 | text | text |
| No | | addresscity | AddressCity | text | text |
| No | | addressstate | AddressState | text | text |
| No | | addresszip | AddressZip | text | text |
| Yes | series tag | phonebusiness | PhoneBusiness | text | text |
| Yes | series tag | email | Email | text | text |
| Yes | series tag | firstname | FirstName | text | text |
| Yes | series tag | lastname | LastName | text | text |
| Yes | series tag | picture | Picture | url | url |
| No | | report_year | Latest_Report_Year | number | text |
| Yes | time | terminationdate | TerminationDate | calendar_date | calendar_date |
Time Field
Value = terminationdate
Format & Zone = yyyy-MM-dd'T'HH:mm:ss
Series Fields
Excluded Fields = addressline1,addressline2,addresscity,addressstate,addresszip,report_year
Data Commands
series e:exbu-si57 d:0001-01-01T00:00:00.000Z t:picture=http://netfile.com/Sunlight/sf/lobbyist/picture/2017/1/SFO-112455 t:firmname="Loeven and Associates LLC" t:email=lewis@lewisloeven.com t:phonebusiness=4158605567 t:lastname=Loeven t:filerid=SFO-112455 t:firstname=Lewis t:fullname="Loeven, Lewis" m:row_number.exbu-si57=1
series e:exbu-si57 d:0001-01-01T00:00:00.000Z t:picture=http://netfile.com/Sunlight/sf/lobbyist/picture/2017/1/SFO-154186 t:firmname="Marathon Asset Management LP" t:email=cshort@marathonfund.com t:phonebusiness=2125003065 t:lastname=Short t:filerid=SFO-154186 t:firstname=Charles t:fullname="Short, Charles" m:row_number.exbu-si57=2
series e:exbu-si57 d:0001-01-01T00:00:00.000Z t:picture=http://netfile.com/Sunlight/sf/lobbyist/picture/2017/1/SFO-153485 t:firmname="Coalition for Better Housing" t:email=battime@sbcglobal.net t:phonebusiness="510 835-5103" t:lastname=Turner t:filerid=SFO-153485 t:firstname=Brook t:fullname="Turner, Brook" m:row_number.exbu-si57=3
Meta Commands
metric m:row_number.exbu-si57 p:long l:"Row Number"
entity e:exbu-si57 l:"Lobbyist Directory" t:attribution="San Francisco Ethics Commission" t:url=https://data.sfgov.org/api/views/exbu-si57
property e:exbu-si57 t:meta.view v:id=exbu-si57 v:category="City Management and Ethics" v:attributionLink=http://www.sfethics.org/ethics/2012/01/lobbyist-database-api.html v:averageRating=0 v:name="Lobbyist Directory" v:attribution="San Francisco Ethics Commission"
property e:exbu-si57 t:meta.view.license v:name="Open Data Commons Public Domain Dedication and License" v:termsLink=http://opendatacommons.org/licenses/pddl/1.0/
property e:exbu-si57 t:meta.view.owner v:id=vm9c-ykir v:profileImageUrlMedium=/api/users/vm9c-ykir/profile_images/THUMB v:profileImageUrlLarge=/api/users/vm9c-ykir/profile_images/LARGE v:screenName="Steven Massey" v:profileImageUrlSmall=/api/users/vm9c-ykir/profile_images/TINY v:displayName="Steven Massey"
property e:exbu-si57 t:meta.view.tableauthor v:id=vm9c-ykir v:profileImageUrlMedium=/api/users/vm9c-ykir/profile_images/THUMB v:profileImageUrlLarge=/api/users/vm9c-ykir/profile_images/LARGE v:screenName="Steven Massey" v:profileImageUrlSmall=/api/users/vm9c-ykir/profile_images/TINY v:roleName=publisher v:displayName="Steven Massey"
Top Records
| fullname | firmname | filerid | addressline1 | addressline2 | addresscity | addressstate | addresszip | phonebusiness | email | firstname | lastname | picture | report_year | terminationdate |
| ================ | ====================================== | ========== | =========================== | ============ | ============= | ============ | ========== | ============== | =========================== | ========= | ======== | ========================================================================= | =========== | =================== |
| Loeven, Lewis | Loeven and Associates LLC | SFO-112455 | 5140 Diamond Heights Blvd | 301A | San Francisco | CA | 94131 | 4158605567 | lewis@lewisloeven.com | Lewis | Loeven | [http://netfile.com/Sunlight/sf/lobbyist/picture/2017/1/SFO-112455, null] | 2017 | 0001-01-01T00:00:00 |
| Short, Charles | Marathon Asset Management LP | SFO-154186 | One Bryant Park | 38th Floor | Manhattan | NY | 10036 | 2125003065 | cshort@marathonfund.com | Charles | Short | [http://netfile.com/Sunlight/sf/lobbyist/picture/2017/1/SFO-154186, null] | 2017 | 0001-01-01T00:00:00 |
| Turner, Brook | Coalition for Better Housing | SFO-153485 | 906 York Street | | Oakland | CA | 94610 | 510 835-5103 | battime@sbcglobal.net | Brook | Turner | [http://netfile.com/Sunlight/sf/lobbyist/picture/2017/1/SFO-153485, null] | 2017 | 0001-01-01T00:00:00 |
| Beatty, Heather | First Eagle Investment Management, LLC | SFO-154578 | 1345 Avenue of the Americas | 48th Floor | New York | NY | 10105 | 2126983170 | heather.beatty@feim.com | Heather | Beatty | [http://netfile.com/Sunlight/sf/lobbyist/picture/2017/1/SFO-154578, null] | 2017 | 0001-01-01T00:00:00 |
| Carroll, Kevin | HOTEL COUNCIL OF SAN FRANCISCO | SFO-153768 | 323 GEARY STREET, #203 | | SAN FRANCISCO | CA | 94102 | (415) 391-5197 | kcarroll@hotelcouncilsf.org | Kevin | Carroll | [http://netfile.com/Sunlight/sf/lobbyist/picture/2017/1/SFO-153768, null] | 2017 | 0001-01-01T00:00:00 |
| Beecher, Richard | Fortress Capital Formation, Llc | SFO-153862 | 1345 Avenue of the Americas | 47th Floor | Manhattan | NY | 10105 | 2124795312 | rbeecher@fortress.com | Richard | Beecher | [http://netfile.com/Sunlight/sf/lobbyist/picture/2015/1/SFO-153862, null] | 2015 | 2015-03-31T00:00:00 |
| Ross, James | James Ross | SFO-153386 | 870 Market Street | Suite 880 | San Francisco | CA | 94102 | 4158240582 | jim@jimrossconsulting.com | James | Ross | [http://netfile.com/Sunlight/sf/lobbyist/picture/2015/1/SFO-153386, null] | 2015 | 2015-06-30T00:00:00 |
| Jordan, Taylor | Barbary Coast Consulting | SFO-153512 | 38 Mason Street | | San Francisco | CA | 94102 | 4153640000 | jordan@barcoast.com | Taylor | Jordan | [http://netfile.com/Sunlight/sf/lobbyist/picture/2016/1/SFO-153512, null] | 2016 | 2016-05-31T00:00:00 |
| Lewis, Leah | Cisco Systems, Inc. | SFO-153894 | 170 West Tasman Dr. | | San Jose | CA | 95134 | 4153896800 | llcisco@nmgovlaw.com | Leah | Lewis | [http://netfile.com/Sunlight/sf/lobbyist/picture/2015/1/SFO-153894, null] | 2015 | 2015-11-30T00:00:00 |
| Reyes, Rudolph | Verizon Corp Rsrcs Group LLC | SFO-153977 | 201 Spear Street, 7th Floor | | San Francisco | CA | 94105 | 415-228-1465 | rudy.reyes@verizon.com | Rudolph | Reyes | [http://netfile.com/Sunlight/sf/lobbyist/picture/2015/1/SFO-153977, null] | 2015 | 2015-11-30T00:00:00 |