lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
17 rows where filing_uuid = "3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1393337 | AMERICAN BAR ASSOCIATION 3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa | Q1 | AMERICAN BAR ASSOCIATION | 1808 | AMERICAN BAR ASSOCIATION | 2013 | first_quarter | BNK | H.R. 982, Furthering Asbestos Claim Transparency (FACT) Actprovisions relating to proposals to amend the U.S. Bankruptcy Code to increase the transparency of Section 524(g) asbestos trusts and reduce the risk of fraud by certain claimants | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Legal Services Corporation,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Copyright Office,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office | 240000 | 0 | 0 | 2013-04-22T15:22:40.213000-04:00 | |
| 1393338 | AMERICAN BAR ASSOCIATION 3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa | Q1 | AMERICAN BAR ASSOCIATION | 1808 | AMERICAN BAR ASSOCIATION | 2013 | first_quarter | CSP | Draft legislation, Arbitration Fairness Act Proposals regarding the state of antitrust enforcement and prospective antitrust policies and initiatives for the President's second term | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Legal Services Corporation,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Copyright Office,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office | 240000 | 0 | 0 | 2013-04-22T15:22:40.213000-04:00 | |
| 1393339 | AMERICAN BAR ASSOCIATION 3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa | Q1 | AMERICAN BAR ASSOCIATION | 1808 | AMERICAN BAR ASSOCIATION | 2013 | first_quarter | TRD | Arms export controls, specifically the Administrations export reform initiative. General discussions on issues relating to international trade in legal services and market access initiatives | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Legal Services Corporation,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Copyright Office,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office | 240000 | 0 | 0 | 2013-04-22T15:22:40.213000-04:00 | |
| 1393340 | AMERICAN BAR ASSOCIATION 3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa | Q1 | AMERICAN BAR ASSOCIATION | 1808 | AMERICAN BAR ASSOCIATION | 2013 | first_quarter | FIN | Draft legislation, Incorporation Transparency and Law Enforcement Assistance Actprovisions requiring states, certain businesses, and company formation agents to obtain and disclose beneficial ownership information regarding new companies and subjecting lawyers that act as formation agents to the anti-money laundering and suspicious activity reporting requirements of the Bank Secrecy ActDepartment of the Treasury Financial Crimes Enforcement Network Advance Notice of Proposed Rulemaking on Customer Due Diligence Requirements for Financial Institutions, RIN 1506-AB15, 77 Fed. Reg. 13046 (March 5, 2012)provisions requiring law firms that establish accounts at financial institutions on behalf of clients to disclose the identity and beneficial ownership information regarding those clients Draft legislation, Stop Tax Haven Abuse Actprovisions subjecting lawyers that act as formation agents to the anti-money laundering and suspicious activity reporting requirements of the Bank Secrecy Act S. 268, Cut Unjustified Tax Loopholes Actprovisions subjecting lawyers that act as formation agents to the anti-money laundering and suspicious activity reporting requirements of the Bank Secrecy Act | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Legal Services Corporation,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Copyright Office,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office | 240000 | 0 | 0 | 2013-04-22T15:22:40.213000-04:00 | |
| 1393341 | AMERICAN BAR ASSOCIATION 3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa | Q1 | AMERICAN BAR ASSOCIATION | 1808 | AMERICAN BAR ASSOCIATION | 2013 | first_quarter | CIV | H.R. 377, S. 84, the Paycheck Fairness Act; S.RES.60: Provisions related to womens rights H.R. 11, S. 47 Violence Against Women Reauthorization Act of 2013 Enforcement and prevention of peer-to-peer violence and bullying based on actual or perceived sexual orientation or gender identity S.372, H.R. 725 Real Education for Healthy Youth Act of 2013: Provisions related to sexual orientation and gender identity. | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Legal Services Corporation,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Copyright Office,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office | 240000 | 0 | 0 | 2013-04-22T15:22:40.213000-04:00 | |
| 1393342 | AMERICAN BAR ASSOCIATION 3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa | Q1 | AMERICAN BAR ASSOCIATION | 1808 | AMERICAN BAR ASSOCIATION | 2013 | first_quarter | TAX | Proposal that the President promptly consider and address the issue of reappointing the Honorable Michael Thornton as Chief Judge of the U.S. Tax Court to avoid any unnecessary disruptions in the administration of the Tax Court Communications regarding Options for Tax Reform in Real Estate | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Legal Services Corporation,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Copyright Office,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office | 240000 | 0 | 0 | 2013-04-22T15:22:40.213000-04:00 | |
| 1393343 | AMERICAN BAR ASSOCIATION 3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa | Q1 | AMERICAN BAR ASSOCIATION | 1808 | AMERICAN BAR ASSOCIATION | 2013 | first_quarter | CPT | H.R. 1123, the ''Unlocking Consumer Choice and Wireless Competition Act''. S. 467, the ''Wireless Device Independence Act of 2013''. S. 517, the ''Unlocking Consumer Choice and Wireless Competition Act''. H.R. 1278, the ''Non-Disparagement of Native American Persons or Peoples in Trademark Registration Act of 2013''.S. 214, the Preserve Access to Affordable Generics Act. S. 350, the Fair Access to Science and Technology Research Act of 2013. H.R. 845, the Saving High-Tech Innovators from Egregious Legal Disputes Act of 2013. H.R. 22, the Foreign Counterfeit Merchandise Prevention Act. | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Legal Services Corporation,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Copyright Office,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office | 240000 | 0 | 0 | 2013-04-22T15:22:40.213000-04:00 | |
| 1393344 | AMERICAN BAR ASSOCIATION 3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa | Q1 | AMERICAN BAR ASSOCIATION | 1808 | AMERICAN BAR ASSOCIATION | 2013 | first_quarter | VET | Activity in support the establishment of veteran treatment courts, including S. 162, the Justice and Mental Health Collaboration Act of 2013. General activity in support of preservation of funding for key veteran homelessness programs and the authorization of legal services funding.General activity in support of improved administration of claims and the enforcement of rights under the Uniformed Services Employment and Re-employment Rights Act. General activity supporting clarification of the Servicemembers Civil Relief Act to make explicit that the Act covers proceedings involving dependent support, custody and visitation. Activity in support of preserving the attorney-client relationship during the veterans claims process. | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Legal Services Corporation,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Copyright Office,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office | 240000 | 0 | 0 | 2013-04-22T15:22:40.213000-04:00 | |
| 1393345 | AMERICAN BAR ASSOCIATION 3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa | Q1 | AMERICAN BAR ASSOCIATION | 1808 | AMERICAN BAR ASSOCIATION | 2013 | first_quarter | FOR | Treaty Doc. 112-7, Convention on the Rights of Persons with Disabilities. Treaty Doc. 96-53, Convention on the Elimination of All Forms of Discrimination Against Women Issues relating to funding for democracy and rule of law programs, particularly in the Middle East | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Legal Services Corporation,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Copyright Office,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office | 240000 | 0 | 0 | 2013-04-22T15:22:40.213000-04:00 | |
| 1393346 | AMERICAN BAR ASSOCIATION 3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa | Q1 | AMERICAN BAR ASSOCIATION | 1808 | AMERICAN BAR ASSOCIATION | 2013 | first_quarter | MMM | Discussions on draft legislation regarding the Medicare Secondary Payer and Workers' Compensation Settlement Agreements Act | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Legal Services Corporation,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Copyright Office,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office | 240000 | 0 | 0 | 2013-04-22T15:22:40.213000-04:00 | |
| 1393347 | AMERICAN BAR ASSOCIATION 3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa | Q1 | AMERICAN BAR ASSOCIATION | 1808 | AMERICAN BAR ASSOCIATION | 2013 | first_quarter | FIR | H.R.332, Equal Access to Justice for Victims of Gun Violence Act H.R.452, Gun Trafficking Prevention Act of 2013 S.54, Stop Illegal Trafficking in Firearms Act of 2013 S.146, School and Campus Safety Enhancements Act of 2013S.150/H.R.437, Assault Weapons Ban of 2013 S.374/H.R.137, Fix Gun Checks Act of 2013 S.480, NICS Reporting Improvement Act S.649, Safe Communities, Safe Schools Act of 2013 | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Legal Services Corporation,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Copyright Office,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office | 240000 | 0 | 0 | 2013-04-22T15:22:40.213000-04:00 | |
| 1393348 | AMERICAN BAR ASSOCIATION 3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa | Q1 | AMERICAN BAR ASSOCIATION | 1808 | AMERICAN BAR ASSOCIATION | 2013 | first_quarter | BUD | FY 2014 Labor, Health and Human Services and Education Appropriations funding for programs authorized under the Preserving Safe and Stable Families Act, funding for programs authorized under the federal Child Abuse Prevention and Treatment Act (CAPTA). Discussion of Legal Services Corporations funding in H.R. 152 (Hurricane Sandy Supplemental), H.R. 933 (funding for FY13), and for FY14 (no bill number yet)FY 2014 Financial Services and General Government Appropriations funding for Defender Services. FY 2014 Department of Commerce and Justice, Science, and Related Agencies Appropriations Act funding for reentry programs under the Second Chance Act; juvenile justice programs, Bureau of Prison programs and indigent defense services administered by the Department of Justice; funding for the Legal Orientation Program. | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Legal Services Corporation,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Copyright Office,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office | 240000 | 0 | 0 | 2013-04-22T15:22:40.213000-04:00 | |
| 1393349 | AMERICAN BAR ASSOCIATION 3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa | Q1 | AMERICAN BAR ASSOCIATION | 1808 | AMERICAN BAR ASSOCIATION | 2013 | first_quarter | GOV | S. 699, Court Efficiency Act of 2013 H.R. 144, Ninth Circuit Court of Appeals Judgeship and Reorganization Act of 2013 H.R.862, Supreme Court Transparency and Disclosure Act H.R. 312, Juror Non-Discrimination ActS. Res. 4, S. Res. 28, reforming the Senate rules S.575, H.R. 1203, Judicial Transparency and Ethics Reform Act H.R. 917, S. 405, Sunshine in the Courtroom Act of 2013 H. R. 1181, Sequestration of Pay for Members of Congress H.R 933, Consolidated and further Appropriations Act of 2013, Title V, provisions affecting judiciary Draft bills, Crime Victim Restitution and Court Fee Intercept Act S. 716, legislation repealing the website disclosure and transaction reporting provisions contained in Sections 11, 8, and 6 of P.L. 112-105 (S. 2038), the STOCK Act of 2012, applicable to career federal employees Draft legislation amending 28 U.S.C. 1500 to clarify the respective jurisdiction of the U.S. Court of Federal Claims and the U.S. District Court and allowing plaintiffs with claims against the U.S. government to bring simultaneous claims in both courts, with a presumptive stay of the first-filed action | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Legal Services Corporation,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Copyright Office,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office | 240000 | 0 | 0 | 2013-04-22T15:22:40.213000-04:00 | |
| 1393350 | AMERICAN BAR ASSOCIATION 3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa | Q1 | AMERICAN BAR ASSOCIATION | 1808 | AMERICAN BAR ASSOCIATION | 2013 | first_quarter | IMM | Issues related to reforming the immigration system, particularly in providing government appointed counsel to children and the mentally ill and disabled in immigration proceedings, decreasing use of detention and expanding alternatives to detention, and increasing resources for the immigration court system.Issues relating to implementation and enforcement of the National Detention Standards and general communications regarding conditions in immigration detention, including proposed regulations to prevent, detect, and respond to sexual abuse and assault in detention facilities. | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Legal Services Corporation,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Copyright Office,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office | 240000 | 0 | 0 | 2013-04-22T15:22:40.213000-04:00 | |
| 1393351 | AMERICAN BAR ASSOCIATION 3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa | Q1 | AMERICAN BAR ASSOCIATION | 1808 | AMERICAN BAR ASSOCIATION | 2013 | first_quarter | EDU | Discussions on potential legislation regarding federal student loans for higher education, including to simplify and improve the federal student loan program through income-contingent repayment to provide stronger protections for borrowers, encourage responsible borrowing, particularly that relate to law school student loans, and proposals to require schools to counsel students before they sign onto expensive private student loan debt and inform them if they have any untapped federal loan eligibility. | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Legal Services Corporation,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Copyright Office,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office | 240000 | 0 | 0 | 2013-04-22T15:22:40.213000-04:00 | |
| 1393352 | AMERICAN BAR ASSOCIATION 3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa | Q1 | AMERICAN BAR ASSOCIATION | 1808 | AMERICAN BAR ASSOCIATION | 2013 | first_quarter | LBR | Department of Labor Proposed Rule on the Labor-Management Reporting and Disclosure Act, Interpretation of the Advice Exemption, RIN 1215-AB79 and 1245-AA03, 76 Fed. Reg. 36178 (June 21, 2011) | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Legal Services Corporation,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Copyright Office,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office | 240000 | 0 | 0 | 2013-04-22T15:22:40.213000-04:00 | |
| 1393353 | AMERICAN BAR ASSOCIATION 3bdfdf8e-13f5-4e9b-8fa5-aed3fbafc7aa | Q1 | AMERICAN BAR ASSOCIATION | 1808 | AMERICAN BAR ASSOCIATION | 2013 | first_quarter | LAW | H.R. 1199, S. 403 Safe Schools Improvement Act of 2013 - Provisions related to bullying, specifically of LGBT students. S.619, Justice Safety Valve Act of 2013 Bureau of Consumer Financial Protection Proposed Rule on Confidential Treatment of Privileged Information, Docket No. CFPB-2012-0010; RIN 3170-AA20, 77 Fed. Reg. 15286 (March 15, 2012) and related Final Rule, 77 Fed. Reg. 39617 (July 5, 2012) | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Legal Services Corporation,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Copyright Office,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office | 240000 | 0 | 0 | 2013-04-22T15:22:40.213000-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);