lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
6 rows where filing_uuid = "1992e2b3-4f84-4f06-8540-942e14f2e8a9" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: specific_issues, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 859119 | 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 | CIV | 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 | ||
| 859120 | 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 | UTI | 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 | ||
| 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 | ||
| 859122 | 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 | CSP | 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 | ||
| 859123 | 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 | LBR | As of October 26, 2009, late morning at around 09:24 AM, my firm terminated our relationships/ties to Mrs. Joan Aikman (A.) Schrammar-McCarthy due to her not reimbursing our firm's stated, stipulated et al. expenses & otherwise not paying us for services rendered since the inception of our representing her in all her various personal & professional capacities. Also, our principal separately terminated his ties (same day & time) also due to lack of any reimbursements & payments for individual svcs. he rendered. As of October 26, 2009, late morning at around 09:24 AM, my firm terminated our relationships/ties to Mrs. Joan Aikman (A.) Schrammar-McCarthy due to her not reimbursing our firm's stated, stipulated et al. expenses and otherwise not paying us for services rendered since the inception of our representing her in all her various personal and professional capacities. Also, our principal separately terminated his ties (same day and time) also due to lack of any reimbursements and payments for individual services he separately rendered. Also, due to our firm and principal temporarily moving into her house at 3905 Hylan Boulevard, Staten Island, New York 10308-3425 for all of two (2) consecutive weeks, we, by law and regulations, need and are entitled to at least 30 consecutive days to be able to moving our business belongings and the principal's belongings from her house to elsewhere when convenient and easier for all parties (i.e., the aforementioned Mrs. Schrammar-McCarthy and our firm and its principal) to do so and complete. We do regret our severing our ties and inconvenience resulting from such action. Thank you. | SENATE | 0 | 1 | 2009-10-28T17:32:44-04:00 | ||
| 859124 | 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 | WEL | 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);