lobbying: lobbying_activities: 968 rows where filing_period = "second_quarter", filing_year = 2011 and issue_code = "FIN" sorted by filing

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

968 rows where filing_period = "second_quarter", filing_year = 2011 and issue_code = "FIN" sorted by filing_year descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

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_termination	received_date
1106819	ASSOCIATION FOR FINANCIAL PROFESSIONALS 4bebca82-0d30-4edf-9cfd-11f89a01f324	Q2	ASSOCIATION FOR FINANCIAL PROFESSIONALS	38437	ASSOCIATION FOR FINANCIAL PROFESSIONALS	2011	second_quarter	FIN	Accounting Reforms, Credit Rating Agency Reform, Commodities Exchange Act/Derivatives Reform, Hard to Value Assets, Market-to-Market Accounting Reform, Money Market Fund Reform, Foreign Exchange, Dodd-Frank	Commodity Futures Trading Commission (CFTC),Executive Office of the President (EOP),Federal Accounting Standards Advisory Board (FASAB),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,Federal Trade Commission (FTC),Government Accountability Office (GAO),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Economic Council (NEC),Pension Benefit Guaranty Corporation (PBGC),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of		6250	0	2011-06-29T11:16:08.463000-04:00
1106844	DC LEGISLATIVE AND REGULATORY SERVICES, INC. ba4d63e3-0c37-47c7-a12b-ee30b05b5026	Q2	DC LEGISLATIVE AND REGULATORY SERVICES, INC.	11526	NATIONAL CREDIT REPORTING ASSOCAITON	2011	second_quarter	FIN	GSE reform	HOUSE OF REPRESENTATIVES,SENATE	5000		0	2011-06-29T13:20:26.820000-04:00
1106864	JOHN DUDINSKY & ASSOCIATES 20867e88-c03b-443a-8e97-412ce6c08ad7	Q2	JOHN DUDINSKY & ASSOCIATES	90534	PSCU FINANCIAL SERVICES	2011	second_quarter	FIN	Mitigation of fraud; assist in business development.	Federal Bureau of Investigation (FBI),U.S. Postal Service (USPS),U.S. Secret Service			0	2011-06-29T17:18:44.640000-04:00
1106899	TRIBUTARY LLP c7f9bcc0-6c08-41f7-a201-9fc89bad1fd1	Q2	TRIBUTARY LLP	319756	CHRO ASSOCIATION (FKA HR POLICY ASSOCIATION)	2011	second_quarter	FIN	H.R. 1062, Burdensome Data Collection Relief Act to Repeal Section 953(b) of the Dodd-Frank Act P.L. 111-203, Dodd-Frank Wall Street Reform and Consumer Protection Act of 2010, all provisions relating to executive compensation and corporate governance Comment Letter on Proposed Guidance by the Federal Reserve, OCC, SEC, OTS and FDIC related to executive compensation in large complex banking organizations under Section 956 of Dodd-Frank Act Discussions with SEC regarding implementation of Section 954 in P.L. 111-203, Dodd-Frank Wall Street Reform and Consumer Protection Act of 2010. Comment letter to SEC regarding proposed regulations implementing Section 952 of P.L. 111-203, Dodd-Frank Wall Street Return and Consumer Protection Act of 2010.	Employment Standards Administration,Equal Employment Opportunity Commission (EEOC),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of	380000		0	2011-06-30T13:43:06.140000-04:00
1106961	JOLLY/RISSLER, INC. e3c49d87-91ec-40cd-982f-a52e1d8a0820	Q2	JOLLY/RISSLER, INC.	20835	AFLAC INCORPORATED	2011	second_quarter	FIN	Issues related to insurance sales and underwriting	HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)	130000		0	2011-07-01T07:27:51.730000-04:00
1107004	JOHN SATAGAJ eb98cbe3-ab74-46c2-a6f5-2d236c91808e	Q2	JOHN SATAGAJ	23064	NATIONAL HOME FURNISHINGS ASSOCIATION	2011	second_quarter	FIN	Consumer Credit	Consumer Product Safety Commission (CPSC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Treasury, Dept of,White House Office			0	2011-07-01T10:49:14.163000-04:00
1107106	ALAN REUTHER 15d9f597-37a9-44f7-ae83-d9439eebfe06	Q2	ALAN REUTHER	400618875	UAW RETIREE MEDICAL BENEFITS TRUST	2011	second_quarter	FIN	Oversight of Financial Advisers	Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,White House Office	15000		0	2011-07-01T13:47:59.503000-04:00
1107117	MCMURRAY STRATEGY GROUP, LLC 4973f769-53a8-43b1-b208-24e27423244f	Q2	MCMURRAY STRATEGY GROUP, LLC	400339575	THE AGILE FUNDS INVESTOR COMMITTEE	2011	second_quarter	FIN	Discussed HR 1987 Ponzi Scheme Investor Protection Act of 2011 that will amend the Securities Investor Protection Act of 1970 to provide insurance coverage for certain indirect investors caught in Ponzi schemes. Monitored and discussed HR 757 Equitable Treatment of Investors Act which would amend the Securities Investor Protection Act of 1970 to revise the definition of "net equity."	HOUSE OF REPRESENTATIVES			0	2011-07-01T14:49:11.080000-04:00
1107187	MR. ROBERT ZIMMER 5b14d3c9-ceb7-4aba-acd9-1ff89f88f49c	Q2	MR. ROBERT ZIMMER	400531587	COMMUNITY HOME LENDERS OF AMERICA (FKA COMMUNITY MORTGAGE LENDERS OF AMERICA)	2011	second_quarter	FIN	Regulatory work resulting from Dodd-Frank Act; specifically the Qualifed Residential Mortgage rule; Loan Officer Compensation rule under TILA.	HOUSE OF REPRESENTATIVES,SENATE	23000		0	2011-07-03T15:16:26.937000-04:00
1107209	MORRISON PUBLIC AFFAIRS GROUP 008841a7-63d8-44d8-b37a-57e87932b73c	Q2	MORRISON PUBLIC AFFAIRS GROUP	67193	ESSENT U.S. HOLDINGS, INC.	2011	second_quarter	FIN	Mortgage insurance regulation and related policies Future structure for housing finance	Federal Housing Finance Agency (FHFA),Federal Reserve System,HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE,Treasury, Dept of	80000		0	2011-07-03T18:04:45.470000-04:00
1107352	BARLOW CONSULTING, INC e4a4cbd6-2f7b-47a2-bcc3-234890b256c4	Q2	BARLOW CONSULTING, INC	400420001	TULEPAN MANAGEMENT	2011	second_quarter	FIN	ObtainingNew Market Tax Credits for Florida	HOUSE OF REPRESENTATIVES,SENATE			0	2011-07-05T12:11:00.863000-04:00
1107378	DUTKO WORLDWIDE, LLC e072de8c-0249-4400-9291-f1f9d0a5f58c	Q2	DUTKO WORLDWIDE, LLC	12868	AMERICAN CHEMISTRY COUNCIL	2011	second_quarter	FIN	Monitored legislation affecting the financial system, including H.R. 87: To repeal the Dodd-Frank Wall Street Reform and Consumer Protection Act, and H.R. 1062: Burdensome Data Collection Relief Act.	Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE	60000		0	2011-07-05T12:35:16.313000-04:00
1107387	DUTKO WORLDWIDE, LLC 08b1bd43-9def-4d2c-aa65-9fe7971cadbc	Q2	DUTKO WORLDWIDE, LLC	12868	CITGO PETROLEUM CORPORATION	2011	second_quarter	FIN	Monitor potential derivatives-related modifications to Dodd-Frank Act (Wall Street Reform and Consumer Protection Act of 2009), including H.R. 1573 and the Business Risk Mitigation and Price Stabilization Act of 2011 (H.R. 1610).	Army, Dept of (Corps of Engineers),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT)	110000		0	2011-07-05T12:41:21.330000-04:00
1107443	MALKIN & ROSS 98719364-8404-46cc-ae73-d80ae6e9192c	Q2	MALKIN & ROSS	400390815	ELLIOTT MANAGEMENT	2011	second_quarter	FIN	H.R. 1798, Judgment Evading Foreign States Accountability Act of 2011	HOUSE OF REPRESENTATIVES	15000		0	2011-07-05T13:30:43.377000-04:00
1107568	ILLINOIS GOVERNMENTAL CONSULTING GROUP, LLC 3e62c1f9-edc2-4c24-8271-d5719f05ea58	Q2	ILLINOIS GOVERNMENTAL CONSULTING GROUP, LLC	400273263	COMMUNITY FINANCIAL SERVICES ASSOCIATION OF AMERICA ("CFSA")	2011	second_quarter	FIN	Pursue agenda as directed by client	HOUSE OF REPRESENTATIVES	5000		0	2011-07-05T17:50:49.287000-04:00
1107579	CYBER SECURITY RESEARCH CONSULTANTS, LLC 6dbe0184-4fa5-4bd4-83a1-cf919e63b446	Q2	CYBER SECURITY RESEARCH CONSULTANTS, LLC	91694	THE LIVINGSTON GROUP (ON BEHALF OF U.S. CHAMBER OF COMMERCE)	2011	second_quarter	FIN	FY 12 Financial Services Appropriations Act	HOUSE OF REPRESENTATIVES,SENATE	6000		0	2011-07-05T21:13:58.047000-04:00
1107580	CYBER SECURITY RESEARCH CONSULTANTS, LLC b223ba85-3536-4b5f-984a-ef7a156898c5	Q2	CYBER SECURITY RESEARCH CONSULTANTS, LLC	91694	U.S. CHAMBER OF COMMERCE	2011	second_quarter	FIN	FY 12 Financial Services Appropriations FY 12 CJS Appropriations	HOUSE OF REPRESENTATIVES	18000		0	2011-07-05T21:14:58.860000-04:00
1107640	MS. ELLEN MARSHALL 7f979b7e-cc12-4380-9f1b-0bf286423caa	Q2	MS. ELLEN MARSHALL	297716	BOND DEALERS OF AMERICA	2011	second_quarter	FIN	Issues relating to Dodd-Frank legislation, including proposed fiduciary standard, capital requirements, and cost-benefit analysis for proposed rulemakings	HOUSE OF REPRESENTATIVES,SENATE	20000		0	2011-07-06T11:03:33.497000-04:00
1107862	FOGNANI & FAUGHT PLLC 9799a065-68ac-4534-8bc0-bcf402d10127	2A	FOGNANI & FAUGHT PLLC	44014	IVANHOE CAPITAL CORPORATION	2011	second_quarter	FIN	Provision of information concerning Financial Institutions/Investments/Sec issues				0	2011-07-06T16:48:35.337000-04:00
1107977	CLARK & WEINSTOCK 5b5a3a5f-9603-4673-9fee-5cec6e3013f3	Q2	CLARK & WEINSTOCK	9443	AGSTAR FINANCIAL SERVICES ACA	2011	second_quarter	FIN	General representation for AgStar, primarily liaison between AgStar, Congress and agricultural trade organizations, including the Farm Credit Council.	HOUSE OF REPRESENTATIVES,SENATE	30000		0	2011-07-07T10:55:51.737000-04:00
1108068	PUBLIC AFFAIRS RESOURCES, INC. 9a90fce1-7093-47a9-a6d0-ed902f74b3c4	Q2	PUBLIC AFFAIRS RESOURCES, INC.	31270	PACKAGING CORPORATION OF AMERICA (PCA) (BOISE INC IS NOW A SUBSIDIARY OF PCA )	2011	second_quarter	FIN	Fees for Paper Statements	HOUSE OF REPRESENTATIVES,SENATE	30000		0	2011-07-07T12:58:21.857000-04:00
1108126	COMMUNITY BANKERS ASSOCIATION OF ILLINOIS 43f8e746-3643-4676-bf16-59d31de95eb0	Q2	COMMUNITY BANKERS ASSOCIATION OF ILLINOIS	400531588	COMMUNITY BANKERS ASSOCIATION OF ILLINOIS	2011	second_quarter	FIN	H.R. 4 - Comprehensive 1099 Taxpayer Protection and Repayment of Exchange Subsidy Overpayments Act of 2011 (Repeal of 1099 reporting requirements) S. 712 - Financial Takeover Repeal Act of 2011 (Repeal of Dodd Frank Act) H.R. 1081 - Consumers Payment System Protection Act (Delay and Study of debit interchange regulation) S 575 - Debit Interchange Fee Study Act of 2011(Delay and study of debit interchange regulation) S.AMDT.392 - To improve the regulatory structure for electronic debit card transactions, and for other purposes (Delay and study of debit interchange regulation) H.R. 1418 - Small Business Lending Enhancement Act of 2011 (Expansion of credit unions commercial lending powers) S. 509 - Small Business Lending Enhancement Act of 2011 (Expansion of credit unions commercial lending powers) Farm Credit Administration (FCA) - Federal Credit Service (FCS) lenders bidding on loans of failed banks from the FDIC Farm Credit Systems Rural Community Investment proposal Implementation of the Small Business Lending Fund (SBLF) including dividend restrictions and funding delays H.R. 1697 - Communities First Act (all, including tiered supervision and regulation of community banks) H.R. 1249 - Leahy-Smith America Invents Act (Section 18 only) QRM Qualified Residential Mortgages Consumer Financial Protection Bureau focus on too-big-to-fail banks and financial firms and shadow financial industry, the high standards for consumer compliance required of community banks, accommodation of community banks in serving the needs of their customers, avoid hindering product innovation and customer service, regulatory compliance and increased regulatory burden, and regulatory relief FDIC Insurance reforms - implementation of assessment base change, Deposit Insurance Fund (DIF), premium rates, restoration of target reserve ratios, permanent extension of the Transaction Account Guarantee (TAG) program Regulation of too-big-to-fail banks and financial firms and the shadow financial industry, separation of banking and com…	Federal Deposit Insurance Corporation (FDIC),Federal Housing Finance Agency (FHFA),Federal Reserve System,HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of		50000	0	2011-07-07T15:42:15.243000-04:00
1108218	JM FAMILY ENTERPRISES, INC 0183a696-5a0b-4faf-8e7f-01ba6e0ff27e	Q2	JM FAMILY ENTERPRISES, INC	20620	JM FAMILY ENTERPRISES INC	2011	second_quarter	FIN	Proposed Consumer Finance Protection Board	HOUSE OF REPRESENTATIVES,SENATE		50000	0	2011-07-07T16:43:06.633000-04:00
1108237	DUTKO WORLDWIDE, LLC 81ea8810-f053-4de7-a046-8b3ea25a85a0	Q2	DUTKO WORLDWIDE, LLC	12868	FOREX CAPITAL MARKETS LLC	2011	second_quarter	FIN	Provide strategy and advice to Forex on legislation that affects them and their industry, including implementation of the Dodd-Frank Wall Street Reform and Consumer Protection Act (Public Law No: 111-203) and other executive branch regulations affecting the retail foreign exchange business such as definitions and regulation of swap execution facilities (SEF) and the segregated funds rule.	Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of	60000		0	2011-07-07T16:51:15.350000-04:00
1108274	CRACKER BARREL OLD COUNTRY STORE, INC. 93f302b4-8a85-46ec-93cf-9d09d70811fd	Q2	CRACKER BARREL OLD COUNTRY STORE, INC.	400721169	CRACKER BARREL OLD COUNTRY STORE, INC.	2011	second_quarter	FIN	S. 575 and H.R. 1081, relating to debit card interchange fees and Federal Reserve regulation thereof Federal Reserve rulemaking on debit card interchange fees (section 1075 of the Dodd-Frank law, P.L. 111-203 Tester amendment on debit card interchange fee regulation, to Senate Economic Development Act legislation	HOUSE OF REPRESENTATIVES,SENATE		30000	0	2011-07-07T17:33:33.617000-04:00
1108347	MEHLMAN CONSULTING, INC. 3b05656e-c1b3-43e0-a26b-11fa69e5bdd3	Q2	MEHLMAN CONSULTING, INC.	284950	DAVIDSON KEMPNER CAPITAL MANAGEMENT	2011	second_quarter	FIN	Issues related to Credit Default Swaps, Credit Reporting Agencies Issues related to interchange fees on debit cards	HOUSE OF REPRESENTATIVES,SENATE	20000		0	2011-07-08T09:35:17.217000-04:00
1108438	MEHLMAN CONSULTING, INC. 343d5c3e-4979-411d-9919-9b56c9d8b904	Q2	MEHLMAN CONSULTING, INC.	284950	SLARS (STUDENT LOAN AUCTION RATE SECURITIES) COALITION	2011	second_quarter	FIN	Relief for the holders of Student Loan Auction Rate Securities S. 1068, Student Loan Simplification Opportunity Act	HOUSE OF REPRESENTATIVES,SENATE	40000		0	2011-07-08T10:38:34.183000-04:00
1108449	ACT FOR AMERICA e4a69e29-3377-45ea-bda8-b18949cb9c29	Q2	ACT FOR AMERICA	400434104	ACT FOR AMERICA	2011	second_quarter	FIN	Shariah Compliant Finance: ACT! for America opposes Shariah Compliant Finance transactions for a variety of reasons including that there is no full disclosure or transparency about these products. General Issue Lobbying only - We are not supporting or opposing any particular legislation at this time.	HOUSE OF REPRESENTATIVES,SENATE		30000	0	2011-07-08T10:43:38.950000-04:00
1108523	COLORADO SPRINGS UTILITIES 19c85039-4646-43ca-a09d-52c2576a9a35	Q2	COLORADO SPRINGS UTILITIES	40029251	COLORADO SPRINGS UTILITIES	2011	second_quarter	FIN	CFTC Rulemakings on Dodd-Frank - extend the statutory deadline for the promulgation of the derivatives rules;	HOUSE OF REPRESENTATIVES,SENATE		48000	0	2011-07-08T12:18:30.977000-04:00
1108595	COZEN O'CONNOR PUBLIC STRATEGIES 192fdc09-5647-482c-9d13-3dd5e55ec8e9	Q2	COZEN O'CONNOR PUBLIC STRATEGIES	400459252	FAMILY MANAGEMENT CORPORATION	2011	second_quarter	FIN	Treatment of losses related to Bernard L. Madoff Investment Securities, LLC	HOUSE OF REPRESENTATIVES,SENATE	20000		0	2011-07-08T14:06:16.603000-04:00
1108672	DUTKO WORLDWIDE, LLC db4e2300-082e-4fb7-9459-04f9df811ea9	2T	DUTKO WORLDWIDE, LLC	12868	HSBC (HOUSEHOLD INTL)	2011	second_quarter	FIN	Monitor and advise client on strategy related to implementation of the Dodd-Frank Wall Street Reform and Consumer Protection Act (Public Law No: 111-203) and the Basel III international financial accords; provide legislative intelligence and information to client regarding the creation of a U.S. covered bonds market; Monitor and advise client on any legislation and/or regulation affecting the U.S. mortgage market.	Commodity Futures Trading Commission (CFTC),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of			1	2011-07-08T14:24:51.757000-04:00
1108889	THE ASSOCIATION OF MORTGAGE INVESTORS 997eb7c7-309e-4ca0-8396-960d54a9f620	Q2	THE ASSOCIATION OF MORTGAGE INVESTORS	400614861	THE ASSOCIATION OF MORTGAGE INVESTORS	2011	second_quarter	FIN	GSE Reform, Securitization, Servicing Standards	Federal Reserve System,Ginnie Mae,HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of		195888	0	2011-07-08T19:24:41.807000-04:00
1108952	BEN BARNES GROUP LP ee28e294-7d76-4335-91e7-78f53128bfd1	Q2	BEN BARNES GROUP LP	5415	SHARP & BARNES LP	2011	second_quarter	FIN	Online Consumer Network - Issues pertaining to microloans aks apyday loans	HOUSE OF REPRESENTATIVES,SENATE	100000		0	2011-07-10T13:50:49.017000-04:00
1108969	ALBERTINE ENTERPRISES, INC. ccbfb4c6-2dc6-47ba-a507-46826028936d	Q2	ALBERTINE ENTERPRISES, INC.	795	AURA INC	2011	second_quarter	FIN	Consumer Financial Protection Agency Bill	HOUSE OF REPRESENTATIVES,SENATE	18000		0	2011-07-10T14:08:57.920000-04:00
1109010	INTERNATIONAL DERIVATIVES CLEARING GROUP, LLC fc6f7b9f-b958-4e3a-bb49-fbf3c2eee99a	Q2	INTERNATIONAL DERIVATIVES CLEARING GROUP, LLC	400537611	INTERNATIONAL DERIVATIVES CLEARING GROUP LLC	2011	second_quarter	FIN	issues related to the clearing of interest rate swaps	Commodity Futures Trading Commission (CFTC)			0	2011-07-11T09:11:18.723000-04:00
1109083	DEBEVOISE & PLIMPTON LLP 036fd852-78a7-467d-a45b-9e13342daacb	Q2	DEBEVOISE & PLIMPTON LLP	400708125	PRIVATE EQUITY GROWTH CAPITAL COUNCIL	2011	second_quarter	FIN	Issues under the Dodd-Frank Wall Street Reform and Consumer Protection Act of 2010 affecting private equity funds and their managers, including specifically (1) incentive-based compensation restrictions (SEC Release No. 34-64140), (2) Form PF (SEC Release No. IA-3145) and (3) investment adviser registration (including SEC Release No. IA-3110).	Securities & Exchange Commission (SEC)	90000		0	2011-07-11T11:24:11.843000-04:00
1109162	DUTKO WORLDWIDE, LLC 90e8be92-1aca-472e-bd08-c48c953fb7a1	Q2	DUTKO WORLDWIDE, LLC	12868	U.S.A.A.	2011	second_quarter	FIN	Advise client on ongoing implementation of insurance provisions as part of the Dodd-Frank Wall Street Reform and Consumer Protection Act (Public Law No: 111-203) including the creation and implementation of the Federal Insurance Office (FIO). Monitor and track any additional legislation or regulatory issue related to the insurance industry.	Commodity Futures Trading Commission (CFTC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of	50000		0	2011-07-11T12:02:56.937000-04:00
1109237	HOLLAND & KNIGHT LLP cf47c5c5-3f1b-4ead-b7ea-b91ec9587963	Q2	HOLLAND & KNIGHT LLP	18466	AMERICAN RESORT DEVELOPMENT ASSOCIATION	2011	second_quarter	FIN	Work on predatory lending issues in H.R. 4173 and conference bill text as they affect the timeshare industry.	HOUSE OF REPRESENTATIVES,SENATE			0	2011-07-11T12:29:31.577000-04:00
1109294	HOLLAND & KNIGHT LLP d4457c83-4fbd-47e7-964e-56a22f0c49f2	Q2	HOLLAND & KNIGHT LLP	18466	AMSCOT FINANCIAL CORPORATION	2011	second_quarter	FIN	Legislation and policies affecting financial services; including pay day advances and check cashing.	HOUSE OF REPRESENTATIVES,SENATE	80000		0	2011-07-11T13:19:02.810000-04:00
1109433	BECKER & POLIAKOFF, P.A. 03eaabc4-e5f1-480e-b183-accf7d3660a6	Q2	BECKER & POLIAKOFF, P.A.	283696	MARSHA PESHKIN	2011	second_quarter	FIN	Helen Davis Chaitman has worked, entirely on a pro bono basis, to obtain tax and SIPA relief for victims of Bernard L. Madoff Investment Securities, LLC.	HOUSE OF REPRESENTATIVES,SENATE			0	2011-07-11T14:45:23.747000-04:00
1109571	VENABLE LLP e68a8123-8e3b-47c4-a09d-a1e10e31b6fa	Q2	VENABLE LLP	39941	PRIVATE INVESTOR COALITION	2011	second_quarter	FIN	Reform of the Dodd-Frank Act	Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC)	50000		0	2011-07-11T16:59:44.343000-04:00
1109666	THE BUSINESS ROUNDTABLE, INC. 314d4880-bbca-43ea-9d97-a21562333455	Q2	THE BUSINESS ROUNDTABLE, INC.	7543	BUSINESS ROUNDTABLE INC	2011	second_quarter	FIN	H.R. 1610, Business Risk Mitigation and Price Stabilization Act of 2011; all provisions H.R. 1062, Burdensome Data Collection Relief Act; all provisions S. 947, A bill to provide end user exemptions from certain provisions of the Commodity Exchange Act and the Securities Exchange Act of 1934, and for other purposes; all provisions	Commodity Futures Trading Commission (CFTC),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)		2730000	0	2011-07-11T21:38:54.430000-04:00
1109836	SQUIRE PATTON BOGGS 2e2cdb0c-ea7a-4078-a1f8-532a1bc6678a	Q2	SQUIRE PATTON BOGGS	30906	AMERICAN ASSOCIATION OF RESPONSIBLE AUTO LENDERS	2011	second_quarter	FIN	Issues related to the powers and jurisdiction of the Consumer Financial Protection Bureau.	HOUSE OF REPRESENTATIVES,SENATE	90000		0	2011-07-12T10:36:02.857000-04:00
1109878	SQUIRE PATTON BOGGS 0ead9fca-9f5f-45ff-bcf0-f81dfd39f73c	Q2	SQUIRE PATTON BOGGS	30906	LONDON STOCK EXCHANGE	2011	second_quarter	FIN	Cross-border impacts of financial services reform and similar legislation; Issues related to regulatory convergence including mutual recognition and regulatory comparability.	Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of	40000		0	2011-07-12T10:43:22.310000-04:00
1109917	CASSIDY & ASSOCIATES, INC. 17039891-bef1-4ba9-a198-e2f454179b8b	Q2	CASSIDY & ASSOCIATES, INC.	8453	OCEAN SPRAY CRANBERRIES	2011	second_quarter	FIN	Proposed sugar excise tax	Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)	100000		0	2011-07-12T10:59:46.497000-04:00
1109973	AUTO CARE ASSOCIATION 39e2631f-21ad-457f-8273-d89cdf0cc67b	Q2	AUTO CARE ASSOCIATION	52696	AUTO CARE ASSOCIATION	2011	second_quarter	FIN	Supported Extension of SBA loan program stimulus provisions in the American Recovery and Reinvestment Act through the end of 2010 (H.R. 5297). Opposed Tester-Corker amendment to postpone implementation of swie fee reform in Dodd-Franks Wall Street Reform and Consumer Protection Act.	Commerce, Dept of (DOC),Environmental Protection Agency (EPA),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE		499262	0	2011-07-12T11:24:14.013000-04:00
1110055	COUNCIL OF INSTITUTIONAL INVESTORS a8ed899d-d92e-4165-a333-ebcffc8efe9c	Q2	COUNCIL OF INSTITUTIONAL INVESTORS	11082	COUNCIL OF INSTITUTIONAL INVESTORS	2011	second_quarter	FIN	Dodd-Frank Wall Street Consumer Reform and Protection Act- Implementation issues SEC and CFTC Funding Issues	Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of			0	2011-07-12T12:40:03.473000-04:00
1110266	THE MADISON GROUP 8b3d8927-dbc8-4242-8c93-c8e0cb2ca36d	Q2	THE MADISON GROUP	284050	GENWORTH FINANCIAL	2011	second_quarter	FIN	Reg. Reform, Financial Reform Risk Retention	HOUSE OF REPRESENTATIVES,SENATE	39000		0	2011-07-12T15:00:16.753000-04:00
1110288	R-CALF UNITED STOCKGROWERS OF AMERICA d7e41014-5284-4283-93d7-1043360f86aa	Q2	R-CALF UNITED STOCKGROWERS OF AMERICA	81054	R-CALF UNITED STOCKGROWERS OF AMERICA	2011	second_quarter	FIN	Reform of commodity futures markets to limit excessive speculation and increase market transparency, oversight and accountability through CFTC's rulemaking to implement the Wall Street Reform Act passed in 2010. To urge the CFTC to reject proposal by the Chicago Merchantile Exchange (CME) to change the weight catagories of cattle used to calculate the CBE Feeder Cattle Index.	Agriculture, Dept of (USDA),Bureau of Land Management (BLM),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),President of the U.S.,SENATE,Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR),White House Office		50000	0	2011-07-12T15:11:35.957000-04:00
1110420	KATE MOSS 2ec6bd20-48a2-43d6-9666-ff4a4d469a2b	Q2	KATE MOSS	25988	MORGAN STANLEY	2011	second_quarter	FIN	Implementation of Dodd/Frank	HOUSE OF REPRESENTATIVES,SENATE	20000		0	2011-07-12T16:07:06.783000-04:00
1110493	SHARP & BARNES, LP b469a8e6-2430-4d79-81ed-34d7cae83a4c	Q2	SHARP & BARNES, LP	400309445	ONLINE CONSUMERS NETWORK	2011	second_quarter	FIN	Issues pertaining to microloans, aka payday loans	HOUSE OF REPRESENTATIVES,SENATE	100000		0	2011-07-12T16:56:56.047000-04:00
1110600	STRATEGIC MARKETING INNOVATIONS 258361e5-e67f-4b65-b208-07d8c509e6e3	Q2	STRATEGIC MARKETING INNOVATIONS	60550	UNIVERSITY OF DAYTON	2011	second_quarter	FIN	Funding for non profit business assistance	Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,SENATE,Small Business Administration (SBA)	20000		0	2011-07-12T18:59:40.317000-04:00
1110672	FELICIA SMITH LAW OFFICE, P.C. b40d6b9d-3d5c-4a02-b774-03a21ce373c3	Q2	FELICIA SMITH LAW OFFICE, P.C.	400739214	THE FINANCIAL SERVICES ROUNDTABLE	2011	second_quarter	FIN	Department of Labor, Definition of the Term Fiduciary, RIN 1210-AB32, 75 FR 65263 (Oct. 22, 2010) (Proposing Release)	HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Economic Council (NEC),SENATE,Treasury, Dept of			0	2011-07-13T08:34:12.917000-04:00
1110697	NATIONAL MULTIFAMILY HOUSING COUNCIL, INC. cbbb8f25-ca1f-44dd-adef-5e5aaecb780f	Q2	NATIONAL MULTIFAMILY HOUSING COUNCIL, INC.	28220	NATIONAL MULTIFAMILY HOUSING COUNCIL INC	2011	second_quarter	FIN	GSE reform H.R. 31 - Fannie Mae and Freddie Mac Accountability and Transparency for Taxpayers Act of 2011 (all provisions) H.R. 940 - United States Covered Bond Act of 2011 (all provisions) H.R. 1221 - Equity in Government Compensation Act of 2011 (all provisions) H.R. 1082 - Small Business Capital Access and Job Preservation Act; Asked House Financial Services Committee to include report language stating the Committees intent that real estate funds would be included in bills exemption of private equity fund advisors from SEC registration and reporting. H.R. 1182 - GSE Bailout Elimination and Taxpayer Protection Act (all provisions) H.R. 1222 - GSE Subsidy Elimination Act of 2011 (all provisions) H.R. 1223 - GSE Credit Risk Equitable Treatment Act of 2011 (all provisions) H.R. 1224: GSE Portfolio Risk Reduction Act of 2011, GSE portfolio limits; Asked House Financial Services Committee to include possible amendment regarding protecting multifamily as GSE portfolios are reduced H.R. 1225 - GSE Debt Issuance Approval Act of 2011 (all provisions) H.R. 1226 - GSE Mission Improvement Act of 2011 (all provisions) H.R. 1227 - GSE Risk and Activities Limitation Act of 2011 (all provisions); Asked House Financial Services Committee to include possible amendment that would allow GSEs to offer new mortgage products if they protected taxpayers P.L. 111-203, DoddFrank Wall Street Reform and Consumer Protection Act H.R. 1610 - Business Risk Mitigation and Price Stabilization Act of 2011; To provide end user exemptions from certain provisions of the Commodity Exchange Act and the Securities Exchange Act of 1934 FHA: worked on testimony for 5/25 hearing before House Financial Services on Federal Housing Administrations FHA programs. GSE Multifamily Portfolios: Asked that House Financial Services Committee send Federal Housing Finance Agency (FHFA) a letter asking for information regarding GSE portfolio holdings and products. Fair Market Rents Transformation Rental Initiative Lease Accounting Rules: Joined coalition le…	Energy, Dept of,Environmental Protection Agency (EPA),Federal Housing Finance Agency (FHFA),Federal Reserve System,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Internal Revenue Service (IRS),Natl Economic Council (NEC),Natl Labor Relations Board (NLRB),Office of the Comptroller of the Currency (OCC),SENATE,Small Business Administration (SBA),Treasury, Dept of,White House Office		850000	0	2011-07-13T09:03:21.793000-04:00
1110756	DOWNEY MCGRATH GROUP, INC. 8d63643e-b97a-4a3d-b517-a00cf4042146	Q2	DOWNEY MCGRATH GROUP, INC.	12573	ENTRUST CAPITAL INC	2011	second_quarter	FIN	HR 1082 - Small Business Capital and Access Job Preservation Act				0	2011-07-13T09:39:00.073000-04:00
1110817	THE WALTER GROUP 44ce702e-e675-49f9-b455-72d9f2cd4869	Q2	THE WALTER GROUP	309537	JPMORGAN CHASE & CO	2011	second_quarter	FIN	Implementation of Dodd-Frank, general tax issues, deritives	HOUSE OF REPRESENTATIVES,SENATE	30000		0	2011-07-13T10:08:54.277000-04:00
1110836	THE WALTER GROUP 771fdf2a-15a2-4ab6-9c85-ca3fab753460	Q2	THE WALTER GROUP	309537	SECURITIES INDUSTRY AND FINANCIAL MARKETS ASSN (SIFMA)	2011	second_quarter	FIN	Implementation of Dodd/Frank, derivitives, and general tax issues	HOUSE OF REPRESENTATIVES,SENATE	45000		0	2011-07-13T10:17:58.463000-04:00
1110842	THE WASHINGTON TAX & PUBLIC POLICY GROUP d74b30f5-3b0a-4abf-a6dd-4f4c2bc54e5b	Q2	THE WASHINGTON TAX & PUBLIC POLICY GROUP	294930	PACIFIC INVESTMENT MANAGEMENT COMPANY LLC	2011	second_quarter	FIN	Issues relating to the treatment of derivatives.	Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,SENATE	30000		0	2011-07-13T10:20:52.493000-04:00
1110854	THE WALTER GROUP fdedeed1-8a6f-449e-9cd8-3cac798ed982	Q2	THE WALTER GROUP	309537	REGIONS FINANCIAL CORP	2011	second_quarter	FIN	Implementation of Dodd/Frank	HOUSE OF REPRESENTATIVES,SENATE	15000		0	2011-07-13T10:23:01.760000-04:00
1110877	NATIONAL ASSOCIATION OF MUTUAL INSURANCE COMPANIES 84f77d2d-fbdd-47c5-863c-ab50b44b6e89	Q2	NATIONAL ASSOCIATION OF MUTUAL INSURANCE COMPANIES	26945	NATIONAL ASSOCIATION OF MUTUAL INSURANCE COMPANIES	2011	second_quarter	FIN	To repeal the Dodd-Frank Wall Street Reform and Consumer Protection Act H.R. 87/S. 712, all provisions Responsible Consumer Financial Protection Regulations Act H.R. 1121, all provisions Bureau of Consumer Financial Protection Transfer Clarification Act H.R. 1667, all provisions Consumer Financial Protection Safety and Soundness Improvement Act H.R. 1315, all provisions	HOUSE OF REPRESENTATIVES,SENATE		262000	0	2011-07-13T10:30:14.493000-04:00
1111035	GRAY GLOBAL ADVISORS, LLC 3c1195c6-5df4-4466-8958-71c6d7581414	Q2	GRAY GLOBAL ADVISORS, LLC	295053	UNITED SERVICES AUTOMOBILE ASSOCIATION	2011	second_quarter	FIN	Matters related to insurance and financial services legislation.	Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE	50000		0	2011-07-13T11:16:49.463000-04:00
1111058	MILLER & CHEVALIER CHARTERED bd61cf00-8ebf-423f-8078-4e328d2cd351	Q2	MILLER & CHEVALIER CHARTERED	25306	AMERICAN FIDELITY CORPORATION	2011	second_quarter	FIN	Legislation affecting financial services issues.	HOUSE OF REPRESENTATIVES,SENATE	160000		0	2011-07-13T11:27:03.337000-04:00
1111080	DOWNEY MCGRATH GROUP, INC. 772473ab-b7b1-4b30-9810-078f60c5e709	Q2	DOWNEY MCGRATH GROUP, INC.	12573	INTERCONTINENTAL EXCHANGE	2011	second_quarter	FIN	Implementation of PL 111-203, Dodd-Frank Wall Street Reform and Consumer Protection Act; Title 7 - derivatives proposed acquisition of New York Stock Exchange	Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Economic Council (NEC),SENATE	40000		0	2011-07-13T11:38:15.650000-04:00
1111109	DOWNEY MCGRATH GROUP, INC. f84849ae-fa14-45c7-aaab-eadb78375054	Q2	DOWNEY MCGRATH GROUP, INC.	12573	LAZARD GROUP LLC	2011	second_quarter	FIN	Implementation of PL 111-203, Dodd-Frank Wall Street Reform and Consumer Protection Act; provisions related to securities holding companies	HOUSE OF REPRESENTATIVES,SENATE	40000		0	2011-07-13T11:50:33.993000-04:00
1111245	FIERCE, ISAKOWITZ & BLALOCK 69f4e27d-c286-44db-a2fc-d64075893ea0	Q2	FIERCE, ISAKOWITZ & BLALOCK	44812	DELTA AIR LINES, INC.	2011	second_quarter	FIN	H.R. 2072- Securing American Jobs through Exports Act of 2011, Export/Import Bank Reauthorization	HOUSE OF REPRESENTATIVES,SENATE	60000		0	2011-07-13T13:26:10.093000-04:00
1111330	KEYCORP 8faf3a76-2d56-4d2e-9754-59d84df9141e	Q2	KEYCORP	400276327	KEYCORP	2011	second_quarter	FIN	Interchange	HOUSE OF REPRESENTATIVES,SENATE		35000	0	2011-07-13T14:03:38.373000-04:00
1111367	SMITH, COSTELLO & CRAWFORD ca414dac-a264-41b4-86d0-b76b1a25d413	Q2	SMITH, COSTELLO & CRAWFORD	35742	INVESTMENT COMPANY INSTITUTE	2011	second_quarter	FIN	Financial Reorganization Legislation; Mutual Fund Issues	HOUSE OF REPRESENTATIVES,SENATE	30000		0	2011-07-13T14:29:55.920000-04:00
1111398	CORNERSTONE GOVERNMENT AFFAIRS, INC. 9faacd7d-102b-4b82-b6f7-7fd016ca92ae	Q2	CORNERSTONE GOVERNMENT AFFAIRS, INC.	75557	ICON CAPITAL CORPORATION	2011	second_quarter	FIN	Legislative proposal related to the related business income tax.	HOUSE OF REPRESENTATIVES,SENATE	60000		0	2011-07-13T14:40:14.403000-04:00
1111418	CORNERSTONE GOVERNMENT AFFAIRS, INC. b283b5f8-c91f-4dc2-a82f-b016c1d04233	Q2	CORNERSTONE GOVERNMENT AFFAIRS, INC.	75557	COBANK	2011	second_quarter	FIN	Preserve the ability to effectively hedge risks in the derivatives markets, implementation of the Dodd-Frank Act.	Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,SENATE	50000		0	2011-07-13T14:44:25.247000-04:00
1111439	CORNERSTONE GOVERNMENT AFFAIRS, INC. 39d50273-5559-4d1a-b7fb-03180055bd1f	Q2	CORNERSTONE GOVERNMENT AFFAIRS, INC.	75557	VISA	2011	second_quarter	FIN	Electronic payments	HOUSE OF REPRESENTATIVES,SENATE	60000		0	2011-07-13T14:49:34.420000-04:00
1111497	ACG ADVOCACY 4eed816e-5c85-4f59-9ade-cea4ec0eaa31	2T	ACG ADVOCACY	2057	TOYOTA MOTOR NORTH AMERICA, INC.	2011	second_quarter	FIN	Financial Regulatory Modernization Financial Regulatory Reform	HOUSE OF REPRESENTATIVES,SENATE	20000		1	2011-07-13T15:05:00.763000-04:00
1111588	ACG ADVOCACY 2ab48d4c-9340-42ba-8db5-d75b92d817d7	Q2	ACG ADVOCACY	2057	EMERSON ECOLOGICS LLC	2011	second_quarter	FIN	Regulatory Reform	HOUSE OF REPRESENTATIVES,SENATE	50000		0	2011-07-13T15:44:46.873000-04:00
1111593	ACG ADVOCACY eb2a5107-493a-4750-8fac-e388dc88881f	Q2	ACG ADVOCACY	2057	MORGAN DREXEN, INC.	2011	second_quarter	FIN	Federal regulation of the debt settlement industry.	HOUSE OF REPRESENTATIVES,SENATE	40000		0	2011-07-13T15:47:49.967000-04:00
1111741	THE BAPTISTA GROUP fb4d74ff-e620-4961-b896-bb891a02175a	Q2	THE BAPTISTA GROUP	307091	PRUDENTIAL FINANCIAL, INC.	2011	second_quarter	FIN	Monitoring issues impacting GSE's including: H.R. 1182 - GSE Bailout Elimination and Taxpayer Protection Act H.R. 1223 - GSE Credit Risk Equitable Treatment Act of 2011 H.R. 1224 - GSE Portfolio Risk Reduction Act of 2011	HOUSE OF REPRESENTATIVES	15000		0	2011-07-13T17:14:09.010000-04:00
1111808	LEVINE & COMPANY 75206370-3ad4-49bb-9656-952a367b461d	Q2	LEVINE & COMPANY	46916	KOHLBERG KRAVIS & CO	2011	second_quarter	FIN	Tax and regulatory issues affecting private equity firms	HOUSE OF REPRESENTATIVES,SENATE	30000		0	2011-07-13T19:43:41.400000-04:00
1111810	LEVINE & COMPANY 00d75bd2-0209-4b44-876f-85d6ebd9a8bd	Q2	LEVINE & COMPANY	46916	REGIONS FINANCIAL CORPORATION	2011	second_quarter	FIN	Issues related to existing and future regulations of banks and financial institutions	HOUSE OF REPRESENTATIVES,SENATE	20000		0	2011-07-13T19:50:42.337000-04:00
1111852	EQUIPMENT LEASING AND FINANCE ASSOCIATION cb464860-26b9-4bc6-91db-933203de9990	Q2	EQUIPMENT LEASING AND FINANCE ASSOCIATION	13767	EQUIPMENT LEASING AND FINANCE ASSOCIATION	2011	second_quarter	FIN	Financial Regulatory Reform/ Wall Street Reform and Consumer Protection Act of 2010 (P.L. 111-203) Securitization/ Risk Retention Rules/ ECOA	Federal Aviation Administration (FAA),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,Transportation, Dept of (DOT),Treasury, Dept of		60000	0	2011-07-14T09:04:03.627000-04:00
1111858	TORREY ADVISORY GROUP (FORMERLY MICHAEL TORREY ASSOCIATES, LLC) 47ab97c7-c60c-43bb-9e1a-3a0789671608	Q2	TORREY ADVISORY GROUP (FORMERLY MICHAEL TORREY ASSOCIATES, LLC)	297033	OPTIONS CLEARING CORPORATION	2011	second_quarter	FIN	Clearing and risk management for over-the-counter derivatives; Futures and securities regulatory restricting; Implementation of Dodd-Frank Wall Street Reform and Consumer Protection Act. Governance Requirements and Risk Management Requirements of Derivatives Clearing Organizations and Clearing Agencies.	Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,SENATE	30000		0	2011-07-14T09:10:08.703000-04:00
1111873	TORREY ADVISORY GROUP (FORMERLY MICHAEL TORREY ASSOCIATES, LLC) 8f813ce5-300e-48f1-a75f-09d2c8463aba	Q2	TORREY ADVISORY GROUP (FORMERLY MICHAEL TORREY ASSOCIATES, LLC)	297033	MOTION PICTURE ASSOCIATION OF AMERICA	2011	second_quarter	FIN	Issues related to the implementation date of Dodd-Frank Wall Street Reform and Consumer Protection Act and the impact on movie futures. H.R. 1573 - To facilitate implementation of title VII of the Dodd-Frank Wall Street Reform and Consumer Protection Act, promote regulatory coordination, and avoid market disruption.	Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,SENATE	40000		0	2011-07-14T09:28:15.890000-04:00
1111934	SQUIRE PATTON BOGGS 608262e9-d39b-4cac-95dc-205cf9fb80c6	Q2	SQUIRE PATTON BOGGS	30906	ASSURED GUARANTY	2011	second_quarter	FIN	Regulation of the over-the-counter derivatives market. H.R. 4173, the Dodd-Frank Wall Street Reform and Consumer Protection Act of 2010.	Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of	140000		0	2011-07-14T10:05:51.390000-04:00
1112039	SQUIRE PATTON BOGGS 55ced7e6-4f34-4538-bd54-51df4ecb30ac	Q2	SQUIRE PATTON BOGGS	30906	DEPOSITORY TRUST CLEARING CORPORATION	2011	second_quarter	FIN	Issues related to Financial Services Regulatory Reform generally including the clearance and settlement of securities transactions, regulation of credit default swaps, regulation of the over-the-counter derivatives market. Issues related to creation of carbon markets. H.R. 4173, Dodd-Frank Wall Street Reform and consumer Protection Act of 2010.	Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of	270000		0	2011-07-14T10:25:42.093000-04:00
1112078	SQUIRE PATTON BOGGS 073d0d91-f270-4303-8996-e2f26c7c7f95	Q2	SQUIRE PATTON BOGGS	30906	WHOLESALE MARKETS BROKERS ASSOCIATION - AMERICAS	2011	second_quarter	FIN	Regulation of the over-the-counter derivatives market. H.R. 4173, the Dodd-Frank Wall Street Reform and Consumer Protection Act of 2010.	Commodity Futures Trading Commission (CFTC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of	230000		0	2011-07-14T10:42:09.733000-04:00
1112241	EMERSON c0e3fde2-38bc-45b2-bf65-e4f8deb40907	Q2	EMERSON	13506	EMERSON	2011	second_quarter	FIN	Burdensome Data Collection Relief Act, H.R. 1062 Proxy Access Issues General Corporate Governance Reform Issues	Federal Reserve System,HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of		311750	0	2011-07-14T11:45:41.310000-04:00
1112290	PARK STRATEGIES, LLC 6247c819-09fe-482e-abcd-ded2aaec3db2	Q2	PARK STRATEGIES, LLC	58432	BETHPAGE FEDERAL CREDIT UNION	2011	second_quarter	FIN	Operation of Finacial institutions	HOUSE OF REPRESENTATIVES	30000		0	2011-07-14T11:59:07.870000-04:00
1112320	RICH FEUER ANDERSON 5876c30b-273b-47d1-94a7-c1f12c3ac9b4	Q2	RICH FEUER ANDERSON	84775	FINANCIAL INDUSTRY REGULATORY AUTHORITY ("FINRA" FORMERLY NASD)	2011	second_quarter	FIN	Implementation of the "Dodd-Frank Wall Street Reform and Consumer Protection Act of 2010," including regulation of broker-dealers and harmonziation of regulation of broker-dealers and investment advisors. Investor protection and investor education initiatives.	HOUSE OF REPRESENTATIVES,SENATE	30000		0	2011-07-14T12:14:27.450000-04:00
1112392	FORSCEY, PLLC fed358f9-1004-4e17-adbf-6e6d0989226e	Q2	FORSCEY, PLLC	52880	NATIONAL ASSOCIATION OF SHAREHOLDER AND CONSUMER ATTORNEYS	2011	second_quarter	FIN	Issues related to securities markets and regulatory reform, including the Consumer Protection Agency. Legislation to provide extraterritorial application to enhance SEC enforcement powers of U.S. Securities Law. SEC implementation of investor protection provisions of Dodd Frank.	HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE	20000		0	2011-07-14T12:52:02.260000-04:00
1112547	PRIME POLICY GROUP 8042d9d5-00de-44a8-ab96-8a038869604b	Q2	PRIME POLICY GROUP	400532589	PRAIRIE CAPITAL	2011	second_quarter	FIN	Home owner loss mitigation legislation.	HOUSE OF REPRESENTATIVES,SENATE	40000		0	2011-07-14T14:11:36.087000-04:00
1112570	KSG LLC, DBA KLEIN AND SAKS GROUP c784795c-2fa3-453d-a8b3-7db5eb75b29b	2A	KSG LLC, DBA KLEIN AND SAKS GROUP	83477	WORLD GOLD TRUST SERVICES	2011	second_quarter	FIN	Regulations promulgated by FinCEN under the Bank Secrecy Act relating to Reports of Foreign Financial Accounts (31 CFR Part 1010)	Commodity Futures Trading Commission (CFTC),Financial Crimes Enforcement Network (FinCEN),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS)	42840		0	2011-07-14T14:19:50.040000-04:00
1112642	MONSTER WORLDWIDE 009f357a-e33d-4749-ba0d-d050889c4d2c	Q2	MONSTER WORLDWIDE	299310	MONSTER WORLDWIDE	2011	second_quarter	FIN	Issues related to liquidity in the Student Loan Auction Rate Securities (SLARS) market.	HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA)		140000	0	2011-07-14T14:44:29.743000-04:00
1112685	THE AMERICAN PUBLIC GAS ASSOCIATION e515aa8a-df22-498d-9977-2aadb8ce939f	Q2	THE AMERICAN PUBLIC GAS ASSOCIATION	74077	AMERICAN PUBLIC GAS ASSOCIATION	2011	second_quarter	FIN	APGA has pushed for the passage of legislation and rulemakings that would increase natural gas market transparency and provide the CFTC with the resources needed to ensure appropriate level of market oversight. APGA has also opposed legislation/regulations that would require public gas systems to post margin for over-the-counter derivatives.	Commodity Futures Trading Commission (CFTC),Energy, Dept of,Federal Energy Regulatory Commission (FERC),HOUSE OF REPRESENTATIVES,SENATE		30000	0	2011-07-14T14:50:43.807000-04:00
1112794	THE NICKLES GROUP, LLC e882afdf-0bef-43f4-bd7b-4533fae6a669	Q2	THE NICKLES GROUP, LLC	293335	FINANCIAL SERVICES CENTER OF AMERICA INC	2011	second_quarter	FIN	HR 1121 / S. 737, Responsible Consumer Financial Protection Regulations Act; H.R. 1667, Bureau of Consumer Financial Protection Transfer Clarification Act, issues related to regulation of check cashing and other money services.	HOUSE OF REPRESENTATIVES,SENATE	60000		0	2011-07-14T15:13:37.663000-04:00
1112832	PILLSBURY WINTHROP SHAW PITTMAN LLP 2368e4bc-9bcf-4717-93b9-ef58ba7886ee	Q2	PILLSBURY WINTHROP SHAW PITTMAN LLP	35002	BLACKHAWK NETWORK	2011	second_quarter	FIN	Monitor credit card and pre-paid card legislation and impact on pre-paid card industry; monitor implementation of Dodd-Frank statute.	HOUSE OF REPRESENTATIVES,SENATE	10000		0	2011-07-14T15:30:55.570000-04:00
1112905	CONSTANTINE CANNON, LLP 001f3aa9-2011-4de4-a9df-4e3af179e0bc	Q2	CONSTANTINE CANNON, LLP	295532	CONSUMER ELECTRONICS RETAILERS COALITION (CERC)	2011	second_quarter	FIN	SEC regulations concerning Conflict Minerals.	HOUSE OF REPRESENTATIVES,SENATE			0	2011-07-14T15:47:25.490000-04:00
1112910	PILLSBURY WINTHROP SHAW PITTMAN LLP c3960195-7241-448d-89ae-d8806a6498e1	Q2	PILLSBURY WINTHROP SHAW PITTMAN LLP	35002	LOMBARD INVESTMENTS	2011	second_quarter	FIN	Financial Investments/Institutions.	HOUSE OF REPRESENTATIVES,SENATE			0	2011-07-14T15:48:27.833000-04:00
1112926	UPSTREAM CONSULTING, INC. b7ab2e3a-aa70-48c6-8e6e-dddeef3936b8	Q2	UPSTREAM CONSULTING, INC.	88278	PRUDENTIAL FINANCIAL	2011	second_quarter	FIN	H.R.31, Fannie Mae and Freddie Mac Accountability and Transparency for Taxpayers Act of 2011; H.R.1221, Equity in Government Compensation Act of 2011; H.R.830, FHA Refinance Program Termination Act; Issues related to the taxation of life insurance and retirement saving products.	HOUSE OF REPRESENTATIVES,SENATE	30000		0	2011-07-14T15:52:36-04:00
1112941	PILLSBURY WINTHROP SHAW PITTMAN LLP 34b64557-723a-42d1-855b-d7bf9579b556	Q2	PILLSBURY WINTHROP SHAW PITTMAN LLP	35002	MITSUI OIL EXPLORATION COMPANY, LTD.	2011	second_quarter	FIN	Environmental, Natural Resources and Energy issues; offshore drilling regulations; oversight of Deepwater Horizon oil spill.	HOUSE OF REPRESENTATIVES,SENATE	60000		0	2011-07-14T15:55:42.507000-04:00
1112962	VENABLE LLP b74bdf76-4b38-4cce-99d1-6000dfaa6636	Q2	VENABLE LLP	39941	FINANCIAL EDUCATION AND COUNSELING ALLIANCE	2011	second_quarter	FIN	Legislative issues pertaining to financial counseling.	HOUSE OF REPRESENTATIVES,SENATE	80000		0	2011-07-14T16:00:53.660000-04:00
1112966	THE VELASQUEZ GROUP, L.L.C. 7608d2fb-cd9e-4422-b455-8ac1281fe0c0	Q2	THE VELASQUEZ GROUP, L.L.C.	53403	VISA INC	2011	second_quarter	FIN	Legislation to delay the implementation of the proposed or final rules issued under the Dodd Frank Wall Street Reform and Consumer Protection Act including S. 575, Debit Interchange Fee Study Act of 2011, all provisions; H.R. 1081, Consumer Payment System Protection Act, all provisions; potential amendments to S. 493, Small Business Reauthorization Act; Corker-Tester amendment to S.782, Economic Development Revitalization Act of 2011 pertaining debit interchange.	HOUSE OF REPRESENTATIVES,SENATE	50000		0	2011-07-14T16:02:56.117000-04:00
1112999	THE VELASQUEZ GROUP, L.L.C. 734be970-5f6f-430b-9915-00bce59f7af4	Q2	THE VELASQUEZ GROUP, L.L.C.	53403	CHARLES SCHWAB & COMPANY	2011	second_quarter	FIN	Proposed rulemaking as relates to the Dodd Frank Wall Street Reform and Consumer Protection Act; especially any regulation pertaining to fiduciary duty of securities brokers or self review organizations.	HOUSE OF REPRESENTATIVES,SENATE	30000		0	2011-07-14T16:14:09.727000-04:00
1113041	WEYERHAEUSER COMPANY 1925b6a7-2394-4e1f-b4d2-a4e1ead389f5	Q2	WEYERHAEUSER COMPANY	41124	WEYERHAEUSER COMPANY	2011	second_quarter	FIN	PL 111-203: Dodd-Frank Wall Street Reform and Consumer Protection Act (Business Conduct Standards related to the implementation of derivatives & swaps provisions); Issues: Use of swaps by pension funds HR 1573: To facilitate implementation of Title VII of the Dodd-Frank Wall Street Reform and Consumer Protection Act, promote regulatory coordination, and avoid market disruption (Business Conduct Standards related to the implementation of derivatives & swaps provisions)	Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),General Services Administration (GSA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service,U.S. Trade Representative (USTR)		750000	0	2011-07-14T16:26:31.710000-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);