lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "1992e2b3-4f84-4f06-8540-942e14f2e8a9" and issue_code = "BUD" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: received_date (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 859121 | PROCESS HANDLER ET AL. FOR HIRE, INC. 1992e2b3-4f84-4f06-8540-942e14f2e8a9 | 4T | PROCESS HANDLER ET AL. FOR HIRE, INC. | 81830 | MRS JOAN A SCHRAMMAR-MCCARTHY | 2009 | fourth_quarter | BUD | Three written-and-signed official firm stationaries (dated 10/23/2009) separately and respectively addressed to a senior federal legislative official, several senior New York City executive officials and the New York State Governor's Office regarding HEAP/OTDA/HRA allegedly not helping, if not outright impeding, indirectly hurting the residents at and the house on 3905 Hylan Boulevard, Staten Island, New York 10308-3425 for at least two to three consecutive years. (pro bono lobbying) Three written-and-signed official firm stationaries (dated October 23, 2009) separately and respectively addressed to current United States federal Senator (Senior Senator, Democrat) Charles E. "Chuck" Schumer (via Maxine), current New York City Mayor Michael R. Bloomberg, several of his New York City (NYC) Deputy Mayors, the NYC Commissioners of Investigation (i.e., Rose Gill Hearn), her Deputy, several senior Deputy NYC Human Resources Commissioners (including the one responsible for ACCO) and several other senior NYC executive branch officials (collectively all via the Office of the New York City Mayor), and current New York State Governor David A. Paterson and several other senior New York State (NYS) executive branch officials (all via the NYS Governor's Mansion) regarding the federally-funded Home Energy Assistance Program (HEAP) via the NYS Office of Temporary and Disability Assistance (OTDA) and subcontracted via the NYC Human Resources Administration (HRA) allegedly not helping, if not outright impeding, hurting the residents at and the house on 3905 Hylan Boulevard, Staten Island, New York 10308-3425 for at least two to three consecutive years by not okaying any heating assistance coming, if not otherwise wanting to go favorably in Mrs. Joan A. Schrammar-McCarthy and 3905 Hylan Boulevard's way, allegedly from a senior female NYC/NYS bureaucrat (according to direct verbal statements of the aforementioned Mrs. Schrammar-McCarthy and her accompanying/co-residing/tenant daughter Ms. Joal M. Schrammar). (pro bono lobbying) | SENATE | 0 | 1 | 2009-10-28T17:32:44-04:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);