Lobbyist Client Directory

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.sfgov.org
Id u4y3-k4vs
Name Lobbyist Client Directory
Attribution San Francisco Ethics Commission
Category City Management and Ethics
Tags ethics, lobbyist, client, directory
Created 2012-04-26T21:08:06Z
Publication Date 2014-09-29T21:49:07Z

Description

Directory of Clients of Lobbyists; there are multiple records if there is more than one Lobbyist for a Client. This list includes both current and past clients for each lobbyist.Lobbyist clients are disclosed by lobbyists registered with the Ethics Commission on a monthly basis. This dataset updates automatically every night.

Columns

| Included | Schema Type | Field Name       | Name             | Data Type | Render Type |
| ======== | =========== | ================ | ================ | ========= | =========== |
| No       | time        | :updated_at      | updated_at       | meta_data | meta_data   |
| Yes      | series tag  | client           | Client           | text      | text        |
| Yes      | series tag  | lobbyist         | Lobbyist         | text      | text        |
| Yes      | series tag  | lobbyist_firm    | Lobbyist_Firm    | text      | text        |
| Yes      | series tag  | client_phone     | Client_Phone     | text      | text        |
| No       |             | client_address   | Client_Address   | text      | text        |
| No       |             | client_address_2 | Client_Address_2 | text      | text        |
| Yes      | series tag  | client_city      | Client_City      | text      | text        |
| Yes      | series tag  | client_state     | Client_State     | text      | text        |
| Yes      | series tag  | client_zip       | Client_Zip       | text      | text        |

Time Field

Value = updated_at
Format & Zone = seconds

Series Fields

Excluded Fields = client_address,client_address_2

Data Commands

series e:u4y3-k4vs d:2017-02-10T00:09:35.000Z t:client_zip=94109 t:lobbyist_firm="Sgc Strategic Communications" t:client="Alla Eddine Beddar Benhamimi" t:lobbyist="Cassolato, Stefano" t:client_phone=4153416575 t:client_state=CA t:client_city="San Francisco" m:row_number.u4y3-k4vs=1

series e:u4y3-k4vs d:2017-02-10T00:09:35.000Z t:client_zip=94109 t:lobbyist_firm="Sgc Strategic Communications" t:client="City Rent-A-Car" t:lobbyist="Cassolato, Stefano" t:client_phone=4155963734 t:client_state=CA t:client_city="San Francisco" m:row_number.u4y3-k4vs=2

series e:u4y3-k4vs d:2017-03-03T16:22:23.000Z t:client_zip=94116 t:lobbyist_firm="The Marquez Law Group" t:client="Victor Nguyen- Proposed Mcd" t:lobbyist="Marquez, Victor M." t:client_phone=4159900857 t:client_state=CA t:client_city="San Francisco" m:row_number.u4y3-k4vs=3

Meta Commands

metric m:row_number.u4y3-k4vs p:long l:"Row Number"

entity e:u4y3-k4vs l:"Lobbyist Client Directory" t:attribution="San Francisco Ethics Commission" t:url=https://data.sfgov.org/api/views/u4y3-k4vs

property e:u4y3-k4vs t:meta.view v:id=u4y3-k4vs 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 Client Directory" v:attribution="San Francisco Ethics Commission"

property e:u4y3-k4vs 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:u4y3-k4vs 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:u4y3-k4vs 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

| :updated_at | client                       | lobbyist             | lobbyist_firm                | client_phone | client_address                 | client_address_2 | client_city   | client_state | client_zip | 
| =========== | ============================ | ==================== | ============================ | ============ | ============================== | ================ | ============= | ============ | ========== | 
| 1486685375  | Alla Eddine Beddar Benhamimi | Cassolato, Stefano   | Sgc Strategic Communications | 4153416575   | 2718 Hyde St.                  |                  | San Francisco | CA           | 94109      | 
| 1486685375  | City Rent-A-Car              | Cassolato, Stefano   | Sgc Strategic Communications | 4155963734   | 1500 Van Ness Ave.             |                  | San Francisco | CA           | 94109      | 
| 1488558143  | Victor Nguyen- Proposed Mcd  | Marquez, Victor M.   | The Marquez Law Group        | 4159900857   | 563 Dewey Blvd                 |                  | San Francisco | CA           | 94116      | 
| 1488558143  | Hbk Engineering              | Lopez, Marisol       | Platinum Advisors            | 3124320076   | 921 WEST VAN BUREN STREET #100 |                  | CHICAGO       | IL           | 60607      | 
| 1488558143  | Tzk Broaway, Llc             | Anderson, Darius     | Platinum Advisors            | 916-443-8891 | 1215 K STREET, SUITE 1150      |                  | SACRAMENTO    | CA           | 95814      | 
| 1488558143  | Airbnb, Inc.                 | Middlebrook, Matt    | Airbnb                       | 4156623254   | 888 Brannan St.                |                  | San Francisco | CA           | 94103      | 
| 1488558143  | Golden State Warriors        | Lopez, Marisol       | Platinum Advisors            | 5109862200   | 1011 BROADWAY                  |                  | OAKLAND       | CA           | 94607      | 
| 1488558143  | Tcig                         | Sarjapur, Melinda A. | Reuben, Junius & Rose, Llp   | 4155679000   | 1650 Jackson, No. 505          |                  | San Francisco | CA           | 94109      | 
| 1488558143  | Brandon Muller               | Kevlin, John         | Reuben, Junius & Rose, Llp   | 949-456-0297 | 32681 Caspian Sea Dr.          |                  | Dana Point    | CA           | 92629      | 
| 1488558143  | Stricklin/john               | Frattin, Daniel      | Reuben, Junius & Rose, Llp   | 415-355-0900 | 601 Van Ness,No. 3606          |                  | San Francisco | CA           | 94102      |