lobbying_activities

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

1 row where filing_uuid = "f9ffbc32-47ca-4c41-a615-cec4e4eab3d2" and issue_code = "LAW" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 1

filing_year 1

filing_period 1

id filing_uuid filing_type registrant_name registrant_id client_name filing_year ▲ filing_period issue_code specific_issues government_entities income_amount expense_amount is_no_activity is_termination received_date
986487 PROCESS HANDLER ET AL. FOR HIRE, INC. f9ffbc32-47ca-4c41-a615-cec4e4eab3d2 Q3 PROCESS HANDLER ET AL. FOR HIRE, INC. 81830 MS. PATRICIA WOOD 2010 third_quarter LAW My firm's (i.e., Process Handler et al. For Hire, Inc.) termination (as of Tuesday, Aug. 17, 2010, at 8:06 AM EST) of each, any and all representation of, for et al. Sharp Realty LLC, Mrs. Linda Sharp, Mr. Cie Sharp and M. Sharp Construction, Inc., and their impact upon said firm's implicit, explicit et al. activities et al., continued... Duties and responsibilities: Put various tax forms and other applicable written material, including various files, in order within the IRS for further usage by various other applicable IRS personnel and officials. Membership: National Treasury Employees Union (NTEU, since 02/11/2002). 06/1999 to 11/1999; 140 hours per week (average); member of, volunteer for and chief of research and emergency campaign manager for The Team to Elect Linda Tennen Kushner (a private, not-for-profit/non-profit town board/council election campaign organization for veteran private attorney and alleged former United States federal Department of Justice official Linda Tennen Kushner), headquartered at 460 New York Avenue, Huntington, New York 11743-3432; NON-SALARIED/VOLUNTEER; supervisor: Mr. Ira Siegel (main campaign manager), (631)-549-0775. You may not contact my then supervisor. Duties and responsibilities: Full-time volunteer for and was a full-time research and emergency/back-up official for the political campaign as said described. 07/13/1998 to 08/04/1998; 40 hours per week (average); Receiver (on-call employee), Scanning Department of the Document Processing Department, Publishers Clearing House, Incorporated (PCH), 6901 Jericho Turnpike, Suite 100, Syosset, New York 11791-4450, Publishers Clearing House, Incorporated's (PCH) main headquarters' address: 382 Channel Drive, Port Washington, New York 11050-2297; $5.75 per hour (REGULAR WORKING HOURS), as of 07/31/1998; PCH's main telephone number: 1-(516)-944-6688; supervisor: Ms. Jean McQuade (manager, Scanning Department), (516)-496-0249, extension 7134 or 7110, during regular business hours (9:00 AM to 5:00 PM), (516)-496-0276 after regu… Central Intelligence Agency (CIA),Defense, Dept of (DOD),Executive Office of the President (EOP),Federal Bureau of Investigation (FBI),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Security Council (NSC),Office of the Secretary of Defense,Office of the Vice President of the United States,President of the U.S.,Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Vice President of the U.S.,White House Office     0 0 2010-08-28T11:20:21.150000-04:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE lobbying_activities (
            id INTEGER PRIMARY KEY,
            filing_uuid TEXT NOT NULL,
            filing_type TEXT NOT NULL,
            registrant_name TEXT NOT NULL,
            registrant_id INTEGER,
            client_name TEXT NOT NULL,
            filing_year INTEGER NOT NULL,
            filing_period TEXT NOT NULL,
            issue_code TEXT,
            specific_issues TEXT,
            government_entities TEXT,
            income_amount INTEGER,
            expense_amount INTEGER,
            is_no_activity INTEGER DEFAULT 0,
            is_termination INTEGER DEFAULT 0,
            received_date TEXT,
            CONSTRAINT fk_activity_filing FOREIGN KEY (filing_uuid)
                REFERENCES lobbying_filings_raw(filing_uuid)
        );
CREATE INDEX idx_act_client_name ON lobbying_activities(client_name COLLATE NOCASE);
CREATE INDEX idx_act_issue_code ON lobbying_activities(issue_code);
CREATE INDEX idx_act_filing_year ON lobbying_activities(filing_year);
CREATE INDEX idx_act_filing_uuid ON lobbying_activities(filing_uuid);