lobbying: lobbying_activities: 37,393 rows where filing_period = "third_quarter" and filing_year = 2011 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

37,393 rows where filing_period = "third_quarter" and filing_year = 2011 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
1070515	G2G CONSULTING 0d99d387-34a3-4d92-a6b3-04e92ef29c19	Q3	G2G CONSULTING	323136	ANALIZA DX	2011	third_quarter	BUD	appropriations bills	HOUSE OF REPRESENTATIVES,SENATE			0	2011-01-11T11:36:20.917000-05:00
1107180	EICOUSIA e5e7a1fd-32fa-4dd8-a665-99e77aed1fea	Q3Y	EICOUSIA	400559673	EICOUSIA	2011	third_quarter						0	2011-07-02T23:48:13.373000-04:00
1109232	MINTZ LEVIN COHN FERRIS GLOVSKY AND POPEO, P.C. 655d0807-41eb-4cf2-a4c3-edcdc9c46bef	Q3	MINTZ LEVIN COHN FERRIS GLOVSKY AND POPEO, P.C.	25498	NAHEFFA (FORMERLY KNOWN AS NAHEFA)	2011	third_quarter	TAX	US House of Representatives US Senate IRS	HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE	31500		0	2011-07-11T12:28:29.420000-04:00
1109244	MINTZ LEVIN COHN FERRIS GLOVSKY AND POPEO, P.C. f46c2f06-8d99-4647-96b7-182bf60101e6	Q3	MINTZ LEVIN COHN FERRIS GLOVSKY AND POPEO, P.C.	25498	ASSOCIATION OF HOME APPLIANCE MANUFACTURERS (AHAM)	2011	third_quarter	MAN	Senate, House of Representatives, Department of Energy, Consumer Product Safety Commission and Environmental Protection Agency	Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE	154791		0	2011-07-11T12:30:33.467000-04:00
1109575	CHUCK ELKINS & ASSOCIATES 46923507-d720-4be4-9ce8-eb1640d44fd2	3TY	CHUCK ELKINS & ASSOCIATES	289454	AMERICAN COMPOSITES MANUFACTURERS ASSOCIATION	2011	third_quarter						1	2011-07-11T17:03:47.703000-04:00
1113977	SOLARWORLD CALIFORNIA 4d35cb6a-c005-4454-a4a9-67e63bc12ac7	3TY	SOLARWORLD CALIFORNIA	400359638	SOLARWORLD CALIFORNIA	2011	third_quarter						1	2011-07-15T12:31:01.707000-04:00
1116146	NATIONAL WATERWAYS CONFERENCE, INC. fc1aa520-73c8-4352-927d-0fbca004e496	Q3Y	NATIONAL WATERWAYS CONFERENCE, INC.	69812	NATIONAL WATERWAYS CONFERENCE, INC.	2011	third_quarter						0	2011-07-18T09:33:43.557000-04:00
1123810	CAPITALEDGE ADVOCACY INC. (FORMERLY CAPITALEDGE ADVOCACY, LLC) 882e0657-8d0b-4b72-97c7-71c505541101	Q3	CAPITALEDGE ADVOCACY INC. (FORMERLY CAPITALEDGE ADVOCACY, LLC)	400493432	CITY OF RENO, NV	2011	third_quarter	URB	No Bill Number: Transportation, Housing and Urban Development, and Independent Agencies Appropriations Act, 2012 -- support full funding for Community Development Block Grant and HOME programs Oppose federal preemption of local authority over public rights-of-way Federal surface transportation reauthorization -- support sufficient funding levels for highway, transit, trails programs	HOUSE OF REPRESENTATIVES,SENATE	20000		0	2011-07-19T15:46:35.400000-04:00
1123869	CAPEDC ADVISORS, LLC 0ffbbdbb-d9c2-4d5c-a30c-07b763e96e65	3TY	CAPEDC ADVISORS, LLC	400362688	AMERICA'S NATURAL GAS ALLIANCE	2011	third_quarter						1	2011-07-19T15:51:11.667000-04:00
1126070	CALIFORNIA HOSPITAL ASSOCIATION c0fad1f5-5c89-479b-a1b7-5e48d27d67d2	Q3	CALIFORNIA HOSPITAL ASSOCIATION	7747	CALIFORNIA HOSPITAL ASSOCIATION	2011	third_quarter	HCR	S. 778: Protecting Access to Rural Therapy Services (PARTS) Act S. 1301: Medicaid Improvement and State Empowerment Act H.R. 1: Full-Year Continuing Appropriations Act of 2011 H.R. 452: Medicare Decisions Accountability Act of 2011 H.R. 1216: Would make the Public Health Service Act's graduate medical education money no longer a direct appropriation. H.R. 1398: To amend title XVIII of the Social Security Act to treat certain provider taxes as allowable costs for purposes of Medicare reimbursements to critical access hospitals. H.R. 1546/S. 829: The Medicare Access to Rehabilitation Services Act. H.R. 1852/S. 958: Children's Hospital GME Support Reauthorization Act of 2011. H.R. 2267/S. 227: Home Health Care Planning Improvement Act of 2011. Inpatient Prospective Payment System Proposed Rule, 76 FR 25788, May 5, 2011, Medicare Program; Proposed Changes to the Hospital Inpatient Prospective Payment Systems for Acute Care Hospitals and the Long-Term Care Hospital Prospective Payment System and Fiscal Year 2012 Rates.	Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,Social Security Administration (SSA)		400000	0	2011-07-19T18:53:44.363000-04:00
1128310	MCALLISTER & QUINN, LLC d96cc887-93a4-4b51-b4be-a1f93acf9ff1	3TY	MCALLISTER & QUINN, LLC	292573	LOURDES COLLEGE	2011	third_quarter						1	2011-07-20T10:14:53.347000-04:00
1130093	JONES WALKER, LLP f66c2026-3e22-4420-83d1-1f3453ca5972	Q3	JONES WALKER, LLP	20881	NORTHROP GRUMMAN CORPORATION	2011	third_quarter	DEF	H.R.1540 FY2012 NDAA; S.1253 FY2012 NDAA; H.2219 FY2012 Defense Appropriations bill, Senate Defense Appropriations Bill monitor programs of interest in procurement and R&D accounts.		10000		0	2011-07-20T11:53:02.080000-04:00
1130094	JONES WALKER, LLP f66c2026-3e22-4420-83d1-1f3453ca5972	Q3	JONES WALKER, LLP	20881	NORTHROP GRUMMAN CORPORATION	2011	third_quarter	BUD	H.R.1540 FY2012 NDAA; S.1253 FY2012 NDAA; H.2219 FY2012 Defense Appropriations bill, Senate Defense Appropriations Bill monitor programs of interest in procurement and R&D accounts.		10000		0	2011-07-20T11:53:02.080000-04:00
1132359	THE TRADE PARTNERSHIP 1979c69d-548e-44d0-b624-d6749d124a20	Q3	THE TRADE PARTNERSHIP	38302	COALITION FOR GSP	2011	third_quarter	TRD	Renewal of the U.S. Generalized System of Preferences program	HOUSE OF REPRESENTATIVES,SENATE,U.S. International Trade Commission (ITC)	25000		0	2011-07-20T13:58:30.180000-04:00
1137349	CREDIT UNION NATIONAL ASSOCIATION. INC. DBA AMERICA'S CREDIT UNIONS 209d1a69-179c-40aa-9ed3-92fecbc9a3d8	3A	CREDIT UNION NATIONAL ASSOCIATION. INC. DBA AMERICA'S CREDIT UNIONS	11322	CREDIT UNION NATIONAL ASSOCIATION, INC. DBA AMERICA'S CREDIT UNIONS	2011	third_quarter	BAN	Please see addendum H.R. 1456, Consumer Overdraft Protection Practices Act, all provisions H.R. 1479, Community Reinvestment Modernization Act, all provisions H.R. 1728, Mortgage Reform and Anti-Predatory Lending Act of 2007, all provisions Issues related to Interchange Fees Issues related to corporate credit unions Issues related to premium assessments by the National Credit Union Share Insurance Fund H.R. 2382, the Credit Card Interchange Fees Act, all provisions Issues related to Fannie Mae and Freddie Mac Issues related to proposed rules on home-equity lines of credit Issues related to the implementation of section 106 of the Credit Card Accountability, Responsibility and Disclosure Act (CARD Act) H.R. 2695, the Credit Card Fair Fee Act, all provisions S. 1212, the Credit Card Fair Fee Act, all provisions H.R. 3126, the Consumer Financial Protection Agency Act, all provisions H.R. 3269, the Corporate and Financial Institution Compensation Fairness Act, section 4, related to enhanced compensation structure reporting to reduce perverse incentives." H.R. 3380, the Promoting Lending to America's Small Business Act, all provisions S. 1799, Fairness and Accountability in Reviewing Overdraft Coverage Act, all provisions H.R. 3904, Overdraft Protection Act of 2009, all provisions S. 2919, Small Business Lending Enhancement Act of 2009, all provisions H.R. 4173, the Dodd-Frank Wall Street Reform and Consumer Protection Act and its Senate Companion, S. 3217, the Reforming American Financial Stability Act, and Senate and Conference amendments thereto related to the following provisions: [Section numbers refer to the Conference Report on H.R. 4173, as filed in the House of Representatives on June 29, 2010] Title I, Subtitle A, Section 111. Financial Stability Oversight Council established, provision designating the Chairman of the National Credit Union Administration as a member of the Council. Title I, Subtitle B, Section 165. Enhanced supervision and prudential standards for nonbank financial com…	Executive Office of the President (EOP),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Credit Union Administration (NCUA),Office of the Vice President of the United States,SENATE,Small Business Administration (SBA),Treasury, Dept of		880000	0	2011-07-20T17:21:59.917000-04:00
1137350	CREDIT UNION NATIONAL ASSOCIATION. INC. DBA AMERICA'S CREDIT UNIONS 209d1a69-179c-40aa-9ed3-92fecbc9a3d8	3A	CREDIT UNION NATIONAL ASSOCIATION. INC. DBA AMERICA'S CREDIT UNIONS	11322	CREDIT UNION NATIONAL ASSOCIATION, INC. DBA AMERICA'S CREDIT UNIONS	2011	third_quarter	FOR	Please see addendum. Issues related to the Foreign Assistance Act of 1961. Issues related to the development of credit cooperatives in Afghanistan Issues related to the development of credit cooperatives in Haiti Issues related to the disaster relief in Haiti.	Executive Office of the President (EOP),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Credit Union Administration (NCUA),Office of the Vice President of the United States,SENATE,Small Business Administration (SBA),Treasury, Dept of		880000	0	2011-07-20T17:21:59.917000-04:00
1137351	CREDIT UNION NATIONAL ASSOCIATION. INC. DBA AMERICA'S CREDIT UNIONS 209d1a69-179c-40aa-9ed3-92fecbc9a3d8	3A	CREDIT UNION NATIONAL ASSOCIATION. INC. DBA AMERICA'S CREDIT UNIONS	11322	CREDIT UNION NATIONAL ASSOCIATION, INC. DBA AMERICA'S CREDIT UNIONS	2011	third_quarter	SMB	Issues related to the implementation of provisions of H.R. 1, the American Recovery and Reinvestment Act of 2009, related to the Small Business Administration.	Executive Office of the President (EOP),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Credit Union Administration (NCUA),Office of the Vice President of the United States,SENATE,Small Business Administration (SBA),Treasury, Dept of		880000	0	2011-07-20T17:21:59.917000-04:00
1137352	CREDIT UNION NATIONAL ASSOCIATION. INC. DBA AMERICA'S CREDIT UNIONS 209d1a69-179c-40aa-9ed3-92fecbc9a3d8	3A	CREDIT UNION NATIONAL ASSOCIATION. INC. DBA AMERICA'S CREDIT UNIONS	11322	CREDIT UNION NATIONAL ASSOCIATION, INC. DBA AMERICA'S CREDIT UNIONS	2011	third_quarter	BUD	Please see addendum. Issues related to the Central Liquidity Facility Issues related to the Community Development Revolving Loan Fund. Issues related to the Community Development Financial Institution Fund Program. S. 3677, Financial Services and General Government Aoppropriations Act for FY 2010, issues related to the National Credit Union Administration.	Executive Office of the President (EOP),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Credit Union Administration (NCUA),Office of the Vice President of the United States,SENATE,Small Business Administration (SBA),Treasury, Dept of		880000	0	2011-07-20T17:21:59.917000-04:00
1137353	CREDIT UNION NATIONAL ASSOCIATION. INC. DBA AMERICA'S CREDIT UNIONS 209d1a69-179c-40aa-9ed3-92fecbc9a3d8	3A	CREDIT UNION NATIONAL ASSOCIATION. INC. DBA AMERICA'S CREDIT UNIONS	11322	CREDIT UNION NATIONAL ASSOCIATION, INC. DBA AMERICA'S CREDIT UNIONS	2011	third_quarter	BNK	Issues related to the Bankruptcy Reform Act of 2005 H.R. 5043, Private Student Loan Bankruptcy Act of 2010, all provisions	Executive Office of the President (EOP),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Credit Union Administration (NCUA),Office of the Vice President of the United States,SENATE,Small Business Administration (SBA),Treasury, Dept of		880000	0	2011-07-20T17:21:59.917000-04:00
1137354	CREDIT UNION NATIONAL ASSOCIATION. INC. DBA AMERICA'S CREDIT UNIONS 209d1a69-179c-40aa-9ed3-92fecbc9a3d8	3A	CREDIT UNION NATIONAL ASSOCIATION. INC. DBA AMERICA'S CREDIT UNIONS	11322	CREDIT UNION NATIONAL ASSOCIATION, INC. DBA AMERICA'S CREDIT UNIONS	2011	third_quarter	TAX	Please see addendum. Issues related to the Credit Union Tax Status H.R. 4213, the American Jobs and Closing Tax Loopholes Act of 2010, provisions related to: -Sec. 603 -- extends the 2009 Stimulus Act SBA provisions -- namely the fee eliminations and increased guarantees for SBA 7(a) and 504 loans. -Sec. 601 -- National Flood Insurance Program -Sec. 226 -- Tax-free IRA Distributions for Charitable Donations -Sec. 243 -- New Markets Tax Credit -Title III, Subtitle A, all sections -- Single Employer Pension Plan Relief Presidents Economic Recovery Oversight Board Report H.R. 4646, the Debt Free America Act, all provisions	Executive Office of the President (EOP),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Credit Union Administration (NCUA),Office of the Vice President of the United States,SENATE,Small Business Administration (SBA),Treasury, Dept of		880000	0	2011-07-20T17:21:59.917000-04:00
1137355	CREDIT UNION NATIONAL ASSOCIATION. INC. DBA AMERICA'S CREDIT UNIONS 209d1a69-179c-40aa-9ed3-92fecbc9a3d8	3A	CREDIT UNION NATIONAL ASSOCIATION. INC. DBA AMERICA'S CREDIT UNIONS	11322	CREDIT UNION NATIONAL ASSOCIATION, INC. DBA AMERICA'S CREDIT UNIONS	2011	third_quarter	HCR	H.R. 3950, Patient Protection and Affordable Care Act, provisions related to small employers tax credits, HSAs and FSAs	Executive Office of the President (EOP),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Credit Union Administration (NCUA),Office of the Vice President of the United States,SENATE,Small Business Administration (SBA),Treasury, Dept of		880000	0	2011-07-20T17:21:59.917000-04:00
1137356	CREDIT UNION NATIONAL ASSOCIATION. INC. DBA AMERICA'S CREDIT UNIONS 209d1a69-179c-40aa-9ed3-92fecbc9a3d8	3A	CREDIT UNION NATIONAL ASSOCIATION. INC. DBA AMERICA'S CREDIT UNIONS	11322	CREDIT UNION NATIONAL ASSOCIATION, INC. DBA AMERICA'S CREDIT UNIONS	2011	third_quarter	GOV	Please see addendum. Issues related to Credit Union field of membership Issues related to Credit Union Service Organizations (CUSO) Issues related to credit union operations Issues related to National Credit Union Administration examination procedures Issues related to Financial Accounting Standards Board Issues related to foreign remittance payments Issues related to the implementation of the Unlawful Internet Gambling Prohibition Act Issues related to the Department of Treasury's Blueprint for a Modernized Financial Regulatory Structure Issues related to Mark-to-Market accounting H.R. 2266, Reasonable Prudence in Regulation Act, all provisions H.R. 2267, Internet Gambling Regulation, Consumer Protection, and Enforcement Act, all provisions Issues related to NCUA's Statute of Limitations Proposal Issues related to credit union indemnification, golden parachutes and other benefits	Executive Office of the President (EOP),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Credit Union Administration (NCUA),Office of the Vice President of the United States,SENATE,Small Business Administration (SBA),Treasury, Dept of		880000	0	2011-07-20T17:21:59.917000-04:00
1141318	LIEBMAN & ASSOCIATES, INC. 32022f31-1665-48a8-bfb7-2b427744f7e4	3T	LIEBMAN & ASSOCIATES, INC.	46585	LAZ PARKING LTD, LLC	2011	third_quarter	TAX	Alternative fuel vehicle refueling property tax credit	Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE			1	2011-07-22T10:43:52.840000-04:00
1141319	LIEBMAN & ASSOCIATES, INC. 32022f31-1665-48a8-bfb7-2b427744f7e4	3T	LIEBMAN & ASSOCIATES, INC.	46585	LAZ PARKING LTD, LLC	2011	third_quarter	ENG	Clean and sustainable energy technology research, development and demonstration	Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE			1	2011-07-22T10:43:52.840000-04:00
1141320	LIEBMAN & ASSOCIATES, INC. 628ca1fd-6018-499a-bd3c-d7ae688d2456	3T	LIEBMAN & ASSOCIATES, INC.	46585	LINEAGE POWER	2011	third_quarter	ENG	Clean and sustainable energy technology (power conversion systems) research, development and demonstration	Energy, Dept of			1	2011-07-22T10:48:55.463000-04:00
1141509	MARY JO HOEKSEMA 5d238a57-23b2-4910-8a6e-ad11fbb6aa86	Q3	MARY JO HOEKSEMA	400511511	POPULATION ASSOCIATION OF AMERICA/ASSOCIATION OF POPULATION CENTERS	2011	third_quarter	BUD	funding for federal research agencies	Bureau of the Census,Natl Institutes of Health (NIH),Natl Science Foundation (NSF),SENATE			0	2011-07-22T17:10:29.337000-04:00
1141510	MARY JO HOEKSEMA 5d238a57-23b2-4910-8a6e-ad11fbb6aa86	Q3	MARY JO HOEKSEMA	400511511	POPULATION ASSOCIATION OF AMERICA/ASSOCIATION OF POPULATION CENTERS	2011	third_quarter	GOV	S. . 679, the Presidential Appointment Efficiency and Streamlining Act of 2011	Bureau of the Census,Natl Institutes of Health (NIH),Natl Science Foundation (NSF),SENATE			0	2011-07-22T17:10:29.337000-04:00
1141569	WATER POLICY ASSOCIATES ddf5364f-1ef2-4ce8-94fe-4dd5640f2be4	3T	WATER POLICY ASSOCIATES	400395863	AMERICAN WATER WORKS COMPANY	2011	third_quarter	BUD	state revolving loan funds, water infrastructure, private activity bonds	HOUSE OF REPRESENTATIVES,SENATE			1	2011-07-24T09:39:08.490000-04:00
1141570	WATER POLICY ASSOCIATES ddf5364f-1ef2-4ce8-94fe-4dd5640f2be4	3T	WATER POLICY ASSOCIATES	400395863	AMERICAN WATER WORKS COMPANY	2011	third_quarter	TAX	exempt facility bonds, private activity bonds, S.939, H.R.1802	HOUSE OF REPRESENTATIVES,SENATE			1	2011-07-24T09:39:08.490000-04:00
1141571	WATER POLICY ASSOCIATES ddf5364f-1ef2-4ce8-94fe-4dd5640f2be4	3T	WATER POLICY ASSOCIATES	400395863	AMERICAN WATER WORKS COMPANY	2011	third_quarter	NAT	water supply, reuse, infrastructure	HOUSE OF REPRESENTATIVES,SENATE			1	2011-07-24T09:39:08.490000-04:00
1142394	TWENTY-FIRST CENTURY GROUP, INC. 5e478970-95a1-4785-b698-43b81bdcb4ba	3T	TWENTY-FIRST CENTURY GROUP, INC.	38687	ESCOPETA OIL	2011	third_quarter	MAR	Issues related to a Jones Act Waiver.	Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE			1	2011-07-29T14:00:25.530000-04:00
1142522	MEREDITH MCGEHEE 290fb814-82a9-428c-8d30-091ba39e3a06	3TY	MEREDITH MCGEHEE	79858	COMMUNITIES IN SCHOOLS OF CHICAGO	2011	third_quarter						1	2011-08-01T10:30:41.947000-04:00
1142590	PAUL HASTINGS LLP 8db2dd50-25ac-4308-bb22-f113a0d810c2	3T	PAUL HASTINGS LLP	30928	METROPCS COMMUNICATIONS INC	2011	third_quarter	TEC	Federal spectrum and auction policies; government spectrum reallocation; general wireless regulation issues; fair and competitive data roaming negotiations; FCC and NTIA oversight; universal service reform, Internet regulation; privacy legislation; National Broadband Plan; H.J. Res. 37/S.J. Res. 6, a "Resolution Disapproving the Rule Submitted by the Federal Communications Commission" with respect to regulating the Internet and broadband industry practices; S.28, the "Public Safety Spectrum and Wireless Innovation Act"; H.R. 607/S.1040, the "Broadband for First Responders Act of 2011"; S.415, the "Spectrum Optimization Act"; S.455, the "Reforming Airways by Developing Incentives and Opportunistic Sharing Act"; H.R. 911, the "Spectrum Relocation Improvement Act of 2011"; the staff discussion draft of the "Wireless Innovation and Spectrum Enhancement Act"; S.911, the "SPECTRUM Act"; H.R. 1622, the "Spectrum Innovation Act"; S.799, the "Commercial Bill of Rights Act of 2011"; S.913, the "Do Not Track Online Act of 2011"; S.1212/H.R. 2168, the "Geolocation Privacy and Surveillance Act"; S.1223, the "Location Privacy Protection Act of 2011"; staff discussion draft of H.R. ____, the "SAFE Data Act"; H.R. 654, the "Do Not Track Me Online Act"; H.R. 1841, the DATA of 2011"; H.R. 1895, the "Do Not Track Kids Act of 2011"; S.1151, the Personal Data Privacy and Security Act of 2011"; H.R. 2434, the "Financial Services and General Government Appropriations Act, 2012 (Sections 621 and 627)	HOUSE OF REPRESENTATIVES,SENATE	20000		1	2011-08-01T16:02:21.490000-04:00
1142624	PAUL HASTINGS LLP 7f6cabf7-02a5-44af-815e-1a00b5dbb3d0	3T	PAUL HASTINGS LLP	30928	CLEAR CHANNEL COMMUNICATIONS INC	2011	third_quarter	COM	Congressional oversight and legislation affecting local broadcast radio stations; broadcast ownership limitations; broadcast localism and diversity; the regulation of broadband programming and the Federal Communications Commission; spectrum legislation; privacy legislation; H. Con. Res. 21/S. Con. Res. 7, "A Resolution Supporting the Local Radio Freedom Act;" and H.R. 607, the "Broadband for First Responders Act of 2011" (Section 207(d))	HOUSE OF REPRESENTATIVES,SENATE	10000		1	2011-08-02T11:19:53.857000-04:00
1142625	PAUL HASTINGS LLP 7f6cabf7-02a5-44af-815e-1a00b5dbb3d0	3T	PAUL HASTINGS LLP	30928	CLEAR CHANNEL COMMUNICATIONS INC	2011	third_quarter	CPT	Congressional oversight and copyright legislation affecting local broadcast radio stations; H. Con. Res. 21/S. Con. Res. 7; and "A Resolution Supporting the Local Radio Freedom Act"	HOUSE OF REPRESENTATIVES,SENATE	10000		1	2011-08-02T11:19:53.857000-04:00
1142638	DA VINCI GROUP 63dcf3a2-ce88-43fc-8008-cb414dad9eaf	Q3Y	DA VINCI GROUP	11548	CORIZON HEALTH SERVICES	2011	third_quarter						0	2011-08-02T12:34:04.650000-04:00
1142639	DA VINCI GROUP 6a8c5e1c-74b2-4ffa-8afc-76117230d845	Q3Y	DA VINCI GROUP	11548	THE APOTHECARY SHOPS	2011	third_quarter						0	2011-08-02T12:46:05.400000-04:00
1142669	NIKE, INC b2aff272-2cbe-4277-8c30-cf27a9bb1f3d	Q3	NIKE, INC	29334	NIKE INC	2011	third_quarter	TAX	Issues related to reintroducing the Tax Equity for Domestic Partner and Health Plan Beneficiaries Act	Bureau of Indian Affairs (BIA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)		60000	0	2011-08-02T15:20:21.737000-04:00
1142670	NIKE, INC b2aff272-2cbe-4277-8c30-cf27a9bb1f3d	Q3	NIKE, INC	29334	NIKE INC	2011	third_quarter	CPT	S. 23 The Patent Reform Act of 2011 PROTECT IP Act of 2011	Bureau of Indian Affairs (BIA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)		60000	0	2011-08-02T15:20:21.737000-04:00
1142671	NIKE, INC b2aff272-2cbe-4277-8c30-cf27a9bb1f3d	Q3	NIKE, INC	29334	NIKE INC	2011	third_quarter	HCR	H.R.1057 FIT Kids Act S.576 FIT Kids Act	Bureau of Indian Affairs (BIA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)		60000	0	2011-08-02T15:20:21.737000-04:00
1142672	NIKE, INC b2aff272-2cbe-4277-8c30-cf27a9bb1f3d	Q3	NIKE, INC	29334	NIKE INC	2011	third_quarter	SPO	S. 174 HELP America Act Issues relating to the appropriations of Physical Education for Progress (PEP) grants Issues relating to Title IX	Bureau of Indian Affairs (BIA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)		60000	0	2011-08-02T15:20:21.737000-04:00
1142673	NIKE, INC b2aff272-2cbe-4277-8c30-cf27a9bb1f3d	Q3	NIKE, INC	29334	NIKE INC	2011	third_quarter	IND	Issues related to the NF Program (Federal MOU)	Bureau of Indian Affairs (BIA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)		60000	0	2011-08-02T15:20:21.737000-04:00
1142674	NIKE, INC b2aff272-2cbe-4277-8c30-cf27a9bb1f3d	Q3	NIKE, INC	29334	NIKE INC	2011	third_quarter	TRD	Trans-Pacific Partnership (TPP) Agreement Issues related to Customs Reauthorization S. 108: Affordable Footwear Act of 2011	Bureau of Indian Affairs (BIA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)		60000	0	2011-08-02T15:20:21.737000-04:00
1142675	NIKE, INC b2aff272-2cbe-4277-8c30-cf27a9bb1f3d	Q3	NIKE, INC	29334	NIKE INC	2011	third_quarter	CIV	Issues in support of athletics equity for students with disabilities. H.R. 3017 Employment Non-Discrimination Act S. 811 Employment Non-Discrimination Act	Bureau of Indian Affairs (BIA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)		60000	0	2011-08-02T15:20:21.737000-04:00
1142676	NIKE, INC b2aff272-2cbe-4277-8c30-cf27a9bb1f3d	Q3	NIKE, INC	29334	NIKE INC	2011	third_quarter	TRA	H.R.526 ON TIME Act S. 800 Safe Routes to School Program Reauthorization Act	Bureau of Indian Affairs (BIA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)		60000	0	2011-08-02T15:20:21.737000-04:00
1142688	GHAZAL & ASSOCIATES, LLC 442fc472-da07-4f55-ba90-a1690d494565	3T	GHAZAL & ASSOCIATES, LLC	45414	FORCE PROTECTION INDUSTRIES, INC.	2011	third_quarter	DEF	FY2012 Defense Authorization, Appropriations and Supplemental bills, particularly sections pertaining to MRAP vehicles, vehicle armor solutions and related soldier protection issues.	HOUSE OF REPRESENTATIVES,SENATE	10000		1	2011-08-02T22:09:32.657000-04:00
1142694	MR. MICHAEL COOPER 017843c6-e9d6-4c4d-972f-714746d19257	Q3	MR. MICHAEL COOPER	400391825	CITY OF ENID	2011	third_quarter	DEF	Military Construction Projects for Vance AFB.	Air Force, Dept of,HOUSE OF REPRESENTATIVES,SENATE	30000		0	2011-08-03T09:19:38.517000-04:00
1142727	SCHMITZ GLOBAL PARTNERS LLP 1c5ef364-ef94-4b27-ad13-2cbbabe3adfe	Q3	SCHMITZ GLOBAL PARTNERS LLP	400569708	US CHAMBER OF COMMERCE	2011	third_quarter	FIN	Implementation of Dodd-Frank legislation, whistleblower provisions, loss reporting, pleading standards. No specific legislation.	HOUSE OF REPRESENTATIVES			0	2011-08-03T15:32:01.653000-04:00
1142757	CAPITOL HILL CONSULTING GROUP 971b123c-4df6-4ba6-922d-ddb250a27733	3TY	CAPITOL HILL CONSULTING GROUP	72053	DECHRA VETERINARY PRODUCTS USA	2011	third_quarter				10000		1	2011-08-04T12:37:20.190000-04:00
1142838	MR. MICHAEL STRATTON b9352522-555c-4076-96a4-1d635f40e61f	3T	MR. MICHAEL STRATTON	46712	NEW VENTURE FUND/RESPONSIBLE TRAILS AMERICA	2011	third_quarter	NAT	Public land use and regulations	Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE	10000		1	2011-08-05T14:10:14.213000-04:00
1142918	NELSON MULLINS RILEY & SCARBOROUGH e96599e3-636b-4be6-829a-85e9e1d1b6ba	3TY	NELSON MULLINS RILEY & SCARBOROUGH	285871	RADIATION MONITORING DEVICES	2011	third_quarter						1	2011-08-09T10:41:23.130000-04:00
1142967	NEW YORK STATE IMMIGRANT ACTION FUND 403e1f69-e01e-4813-9420-18b8c83eff61	Q3Y	NEW YORK STATE IMMIGRANT ACTION FUND	400745233	NEW YORK STATE IMMIGRANT ACTION FUND	2011	third_quarter						0	2011-08-10T11:41:21.080000-04:00
1143044	WASHINGTON LINKAGE GROUP, INC da0005a6-8b24-43fa-8363-1f0082a71980	3T	WASHINGTON LINKAGE GROUP, INC	65271	LIUNA MID-ATLANTIC	2011	third_quarter	TRA	Construction practices and Transporation Reauthorization	HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Labor, Dept of (DOL),SENATE,Transportation, Dept of (DOT),White House Office			1	2011-08-10T13:36:07.500000-04:00
1143045	WASHINGTON LINKAGE GROUP, INC da0005a6-8b24-43fa-8363-1f0082a71980	3T	WASHINGTON LINKAGE GROUP, INC	65271	LIUNA MID-ATLANTIC	2011	third_quarter	ECN	General economic development and Construction practices	HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Labor, Dept of (DOL),SENATE,Transportation, Dept of (DOT),White House Office			1	2011-08-10T13:36:07.500000-04:00
1143046	WASHINGTON LINKAGE GROUP, INC da0005a6-8b24-43fa-8363-1f0082a71980	3T	WASHINGTON LINKAGE GROUP, INC	65271	LIUNA MID-ATLANTIC	2011	third_quarter	LBR	Davis Bacon Act and General Labor issues	HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Labor, Dept of (DOL),SENATE,Transportation, Dept of (DOT),White House Office			1	2011-08-10T13:36:07.500000-04:00
1143168	THE RABEN GROUP 841fa729-a94b-4083-a907-7e9cc03e4e8d	3@	THE RABEN GROUP	61458	ARENT FOX	2011	third_quarter	CIV	Discrimination cases on behalf of women and hispanic farmers.	Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,White House Office			1	2011-08-11T12:22:25.033000-04:00
1143171	MR. MICHAEL STRATTON 0131f0e8-0e9e-441f-a294-4ebb86922721	3T	MR. MICHAEL STRATTON	46712	VIAERO WIRELESS	2011	third_quarter	TEC	Representation about broadband deployment	HOUSE OF REPRESENTATIVES,SENATE			1	2011-08-11T13:05:26.687000-04:00
1143226	BELL POTTINGER USA b69ca8e2-be77-4e04-87b5-780ba9f2056e	3T	BELL POTTINGER USA	400703108	INFINIA CORP.	2011	third_quarter	DEF	Client has a pending Loan Guarantee Application under review before DoE. Client also seeks funding from other Gov agencies for R&D.	Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE	15000		1	2011-08-12T11:33:08.903000-04:00
1143227	BELL POTTINGER USA b69ca8e2-be77-4e04-87b5-780ba9f2056e	3T	BELL POTTINGER USA	400703108	INFINIA CORP.	2011	third_quarter	AUT	Client has a pending Loan Guarantee Application under review before DoE. Client also seeks funding from other Gov agencies for R&D.	Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE	15000		1	2011-08-12T11:33:08.903000-04:00
1143228	BELL POTTINGER USA b69ca8e2-be77-4e04-87b5-780ba9f2056e	3T	BELL POTTINGER USA	400703108	INFINIA CORP.	2011	third_quarter	BUD	Client has a pending Loan Guarantee Application under review before DoE. Client also seeks funding from other Gov agencies for R&D.	Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE	15000		1	2011-08-12T11:33:08.903000-04:00
1143229	BELL POTTINGER USA b69ca8e2-be77-4e04-87b5-780ba9f2056e	3T	BELL POTTINGER USA	400703108	INFINIA CORP.	2011	third_quarter	MAN	Client has a pending Loan Guarantee Application under review before DoE. Client also seeks funding from other Gov agencies for R&D.	Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE	15000		1	2011-08-12T11:33:08.903000-04:00
1143230	BELL POTTINGER USA b69ca8e2-be77-4e04-87b5-780ba9f2056e	3T	BELL POTTINGER USA	400703108	INFINIA CORP.	2011	third_quarter	ENG	Client has a pending Loan Guarantee Application under review before DoE. Client also seeks funding from other Gov agencies for R&D.	Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE	15000		1	2011-08-12T11:33:08.903000-04:00
1143231	BELL POTTINGER USA a238906b-b56d-444b-b5d0-0a72ba971ed6	3T	BELL POTTINGER USA	400703108	LEO PHARMA INC.	2011	third_quarter	PHA	Engage FDA, CDC and Hill policy-makers on behalf of the client to support regulatory and outreach efforts in the US.	HOUSE OF REPRESENTATIVES,SENATE	60000		1	2011-08-12T11:46:09.650000-04:00
1143289	TURNER GOVERNMENT & PUBLIC AFFAIRS acbb8263-63c7-4051-8f0b-47aa98e6ed16	3T	TURNER GOVERNMENT & PUBLIC AFFAIRS	80895	BUDCO HEALTH SERVICE SOLUTIONS	2011	third_quarter	BUD	Health Care Expenditures	Office of Personnel Management (OPM)	7500		1	2011-08-15T11:20:39.247000-04:00
1143407	DUANE MORRIS LLP 0a82b81b-c79c-4ccd-b1fb-5eb796d04a62	3TY	DUANE MORRIS LLP	12664	PRE-PAID LEGAL SERVICES, INC.	2011	third_quarter						1	2011-08-18T11:57:17.390000-04:00
1143410	MCALLISTER & QUINN, LLC 7daaaaa7-6ee9-4d07-a4da-29e03eb5dc05	3TY	MCALLISTER & QUINN, LLC	292573	ST. EDWARDS UNIVERSITY	2011	third_quarter				8000		1	2011-08-18T14:01:23.807000-04:00
1143466	CATALYST PARTNERS LLC 9a01c244-d2fd-4de8-8128-4d2cf97b51ff	3TY	CATALYST PARTNERS LLC	66658	AMWA - ASSOCIATION OF METROPOLITAN WATER AGENCIES	2011	third_quarter						1	2011-08-22T14:01:23.443000-04:00
1143467	CATALYST PARTNERS LLC 86359c70-1a95-4bcd-953a-6f53c670eb99	3TY	CATALYST PARTNERS LLC	66658	KENNEDY VALVE	2011	third_quarter						1	2011-08-22T14:01:24.037000-04:00
1143473	ROGER BLACKLOW b036757d-86ac-40c8-bc42-eb9be5cade84	3T	ROGER BLACKLOW	400623897	NATIONAL ASSOCIATION OF LETTER CARRIERS	2011	third_quarter	POS	Senate and House bill covering federal/postal employees' health, welfare and working conditions.	HOUSE OF REPRESENTATIVES,SENATE	20000		1	2011-08-22T15:42:29.187000-04:00
1143524	TALBERT & EITEL, PLLC 4abaed23-52d2-47ef-bf9e-471625102afe	3TY	TALBERT & EITEL, PLLC	400732198	ASSOCIATION OF AMERICAN PUBLISHERS INC	2011	third_quarter						1	2011-08-24T17:12:05.010000-04:00
1143555	LIBERTY STRATEGIES LLC d1544a8d-0607-4fe3-be53-5a65006c3f49	3TY	LIBERTY STRATEGIES LLC	289671	JOEL REISMAN	2011	third_quarter						1	2011-08-26T11:12:22.707000-04:00
1143577	THE JONES COMPANY, LLC a8819b4b-d96e-40ce-80b6-19c1fd512dbe	3TY	THE JONES COMPANY, LLC	47416	SHERIDAN BROADCASTING CORPORATION	2011	third_quarter						1	2011-08-29T01:08:38.097000-04:00
1143639	JOHNNY SATTERWHITE 4468421f-e71c-4499-b83c-6b777ccd91ef	Q3	JOHNNY SATTERWHITE	400568698	MR JOHNNY SATTERWHITE	2011	third_quarter	BAN	FOR HOMES THAT ARE ON THE FEDERAL GOVERNMENTS BOOKS TO BE SOLD AT 50% OF FACE VALUE	HOUSE OF REPRESENTATIVES			0	2011-08-31T10:27:25.027000-04:00
1143688	FRANCO GOVERNMENT RELATIONS, INC. 737600be-c7d1-40ea-b055-a52da0e97a00	3TY	FRANCO GOVERNMENT RELATIONS, INC.	400602834	LSN PARTNERS, LLC	2011	third_quarter						1	2011-09-01T15:32:04.480000-04:00
1143710	STANTON PARK GROUP f6bd77d3-37bb-4d8f-b6bd-899f53e37447	3T	STANTON PARK GROUP	83717	PARTNERSHIP FOR QUALITY HOME HEALTHCARE (FORMERLY HOME HEALTH ADVOCACY COALITION	2011	third_quarter	HCR	Home health care, health care products, health care services	HOUSE OF REPRESENTATIVES,SENATE	20000		1	2011-09-02T12:37:31.093000-04:00
1143732	MARTIN MORRIS d25d608c-36e0-4b8c-9c6c-2447be0043e4	Q3	MARTIN MORRIS	40038317	AD HOC FAIR HOTEL TAX COLLECTION COALITION	2011	third_quarter	TAX	Preserve the rights of state and local governments to collect hotel taxes	HOUSE OF REPRESENTATIVES,SENATE	30000		0	2011-09-12T10:52:24.270000-04:00
1143733	FIRST STRATEGIC 73cf1ffb-1ae8-4864-b09e-a87aaca4c5d6	3T	FIRST STRATEGIC	91091	SONORAN INSTITUTE	2011	third_quarter	NAT	Designation and management of lands in Arizona for conservation, environmental and ecological purposes.	HOUSE OF REPRESENTATIVES,SENATE			1	2011-09-12T15:19:37.887000-04:00
1143747	SONOSKY, CHAMBERS, SACHSE, ENDRESON & PERRY, LLP cc406e1f-db77-47e3-b97d-41eeb4e8e9d8	Q3	SONOSKY, CHAMBERS, SACHSE, ENDRESON & PERRY, LLP	36127	KODIAK AREA NATIVE ASSOCIATION	2011	third_quarter	BUD	FY 2011 Interior and Related Agencies Appropriations, H.R. 2584, IHS and BIA Contract Support	HOUSE OF REPRESENTATIVES,SENATE			0	2011-09-13T09:25:24.433000-04:00
1143751	MR. DEAN MARTILLI 0ab5626f-b3ac-4208-9084-405fdb3e3321	Q3	MR. DEAN MARTILLI	77550	CARING HEALTH CENTER INC	2011	third_quarter	HCR	EDA monies	Economic Development Administration,Education, Dept of,HOUSE OF REPRESENTATIVES,SENATE	16000		0	2011-09-13T13:15:28.297000-04:00
1143752	MR. DEAN MARTILLI c04726a7-d7dd-46d4-9394-06482dbdab59	Q3	MR. DEAN MARTILLI	77550	LEXINGTON HEALTHCARE, LLC	2011	third_quarter	HCR	CMS was the main area of involvement.	Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE	10000		0	2011-09-13T13:19:28.907000-04:00
1143753	MR. DEAN MARTILLI ca57a633-c6d0-45d2-b56f-181a8d300539	Q3	MR. DEAN MARTILLI	77550	LOWER PIONEER VALLEY EDUCATIONAL COLLABORATIVE	2011	third_quarter	EDU	Add funding	Education, Dept of,HOUSE OF REPRESENTATIVES,SENATE			0	2011-09-13T13:23:29.500000-04:00
1143754	MR. DEAN MARTILLI 7c8949c1-e805-4831-ac07-0fa1ec7d62b1	Q3	MR. DEAN MARTILLI	77550	NORTHAMPTON REHABILITATION& NURSING CENTER	2011	third_quarter	HCR	Problems with reimbursements.	Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE			0	2011-09-13T13:27:30.077000-04:00
1143755	MR. DEAN MARTILLI 9b32ee30-4c13-4fe1-86fe-e0968c7885a2	Q3	MR. DEAN MARTILLI	77550	THE DAVINCI CENTER	2011	third_quarter	BUD	Funding for community programs.	Education, Dept of,HOUSE OF REPRESENTATIVES,SENATE			0	2011-09-13T13:30:30.657000-04:00
1143756	MR. DEAN MARTILLI 8360eead-2474-4d60-a5a7-e46a0ed1f7c9	Q3	MR. DEAN MARTILLI	77550	TOWN OF NORTH PROVIDENCE	2011	third_quarter	BUD	Appropriations	HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)	20000		0	2011-09-13T13:34:31.233000-04:00
1143757	ALFORD & ASSOCIATES 1c4991dd-56d1-4f9d-ae21-61316d584424	Q3	ALFORD & ASSOCIATES	864	AEROMET/L-3 COMMUNICATIONS	2011	third_quarter	DEF	aircraft upgrade and modification	HOUSE OF REPRESENTATIVES,SENATE	10000		0	2011-09-13T14:19:32.420000-04:00
1143758	ALFORD & ASSOCIATES b2cb0868-2b95-4bec-a43e-527430c84613	Q3	ALFORD & ASSOCIATES	864	SPARTON ELECTRONICS	2011	third_quarter	DEF	underwater acoustic sensors sonobuoys	HOUSE OF REPRESENTATIVES,SENATE	20000		0	2011-09-13T14:23:32.997000-04:00
1143759	ALFORD & ASSOCIATES d07066a1-ec8f-463a-bffe-9b104024763f	Q3	ALFORD & ASSOCIATES	864	UNDERSEA SENSOR SYSTEMS INC	2011	third_quarter	DEF	underwater acoustic sensors acoustic hailing devices	HOUSE OF REPRESENTATIVES,SENATE	20000		0	2011-09-13T14:28:33.593000-04:00
1143760	ALFORD & ASSOCIATES a7480434-af81-4935-bb42-d3c4b3b37da5	Q3	ALFORD & ASSOCIATES	864	W L GORE & ASSOCIATES	2011	third_quarter	DEF	high performance combat clothing	HOUSE OF REPRESENTATIVES,SENATE	30000		0	2011-09-13T14:31:34.187000-04:00
1143763	LIEBMAN & ASSOCIATES, INC. b0972bf1-5870-424e-810f-dcfe1064b2ee	3T	LIEBMAN & ASSOCIATES, INC.	46585	IOWA STORED ENERGY PLANT AGENCY	2011	third_quarter	TAX	Storage Technology for Renewable and Green Energy Act of 2010	Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE			1	2011-09-13T16:12:38.473000-04:00
1143764	LIEBMAN & ASSOCIATES, INC. b0972bf1-5870-424e-810f-dcfe1064b2ee	3T	LIEBMAN & ASSOCIATES, INC.	46585	IOWA STORED ENERGY PLANT AGENCY	2011	third_quarter	ENG	Clean and sustainable energy technology research, development and demonstration	Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE			1	2011-09-13T16:12:38.473000-04:00
1143766	LIEBMAN & ASSOCIATES, INC. 183e3946-6ae7-47ec-aa8f-591d738fbd8c	3TY	LIEBMAN & ASSOCIATES, INC.	46585	CLEAN POWER FINANCE, INC.	2011	third_quarter						1	2011-09-13T16:22:39.860000-04:00
1143767	MCALLISTER & QUINN, LLC 14ff0b6d-f093-4382-8607-94d131ff2361	3TY	MCALLISTER & QUINN, LLC	292573	SOLYNDRA	2011	third_quarter						1	2011-09-14T08:38:44.020000-04:00
1143775	BIG BROTHERS BIG SISTERS OF AMERICA 07166f31-03e8-48c2-8ee9-56ca70d27f86	Q3	BIG BROTHERS BIG SISTERS OF AMERICA	83615	BIG BROTHERS BIG SISTERS OF AMERICA	2011	third_quarter	BUD	Commerce, Justice, Science Approations, Labor, HHS, Education Approppiations	Education, Dept of,HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE		58250	0	2011-09-15T14:21:10.207000-04:00
1143776	SYMMETRIX 90648808-58e5-417b-a5d3-6fc86c52fb6d	Q3	SYMMETRIX	322055	OCEAN RENEWABLE ENERGY COALITION	2011	third_quarter	ENG	Marine and Hydrokineetic Promotion Act of 2011	Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE			0	2011-09-15T14:38:11.633000-04:00
1143781	SYNERGY GROUP, LTD 2708b81f-4b51-476c-a42f-67c2409cb311	Q3Y	SYNERGY GROUP, LTD	318196	SYNERGY GROUP LTD	2011	third_quarter						0	2011-09-16T16:20:29.163000-04:00
1143796	PERFORMANCE LEADERSHIP GROUP LLC 7fe381b7-d589-4625-964a-a83d9d06da17	Q3	PERFORMANCE LEADERSHIP GROUP LLC	400377727	VIRGINIA INDIAN TRIBAL ALLIANCE FOR LIFE (VITAL)	2011	third_quarter	IND	S379 and HR 783	Congressional Budget Office (CBO),HOUSE OF REPRESENTATIVES,SENATE	10000		0	2011-09-17T07:57:40.200000-04:00
1143800	L. E. HAEFNER ENTERPRISES, INC. 8f411f28-e774-4544-af9c-b75d7b0e326d	Q3	L. E. HAEFNER ENTERPRISES, INC.	17261	TERMINAL RAILROAD ASSOCIATION OF ST. LOUIS, MISSOURI	2011	third_quarter	TRA	PUBLIC AND PRIVATE FUNDING OF SHORT-LINE TERMINAL RAILROAD CRITICAL RAILROAD BRIDGE LINKING MISSOURI AND ILLINOIS IN THE GREATER ST. LOUIS BI-STATE METROPOLITAN REGION. RRR - SEE DESCRIPTION BELOW. FIN - SEE DESCRIPTION BELOW. PUBLIC AND PRIVATE FUNDING OF SHORT-LINE TERMINAL RAILROAD CRITICAL RAILROAD BRIDGE LINKING MISSOURI AND ILLINOIS IN THE GREATER ST LOUIS BI-STATE METROPOLITAN REGION.	Transportation, Dept of (DOT)	10000		0	2011-09-18T17:14:55.140000-04:00
1143802	ROETZEL & ANDRESS, LPA 2996054b-d3ca-4b3a-9d5f-fac7f2a2f339	3TY	ROETZEL & ANDRESS, LPA	304452	ORIANA HOUSE INC	2011	third_quarter						1	2011-09-19T14:14:49.670000-04:00
1143820	YELVERTON CONSULTING LLC af93129e-f748-4559-93da-932397f7a8dc	Q3Y	YELVERTON CONSULTING LLC	400600831	NATIONAL FOREST COUNTIES AND SCHOOLS COALITION	2011	third_quarter				15000		0	2011-09-20T13:56:04.377000-04:00
1143821	AMERICAN SOCIETY OF APPRAISERS 626c2efe-5a30-40ef-b2ca-0907224d98e3	Q3	AMERICAN SOCIETY OF APPRAISERS	400561679	AMERICAN SOCIETY OF APPRAISERS	2011	third_quarter	FIN	Department of Labor "appraiser-as-fiduciary" rule Dodd-Frank Title XIV appraisal provision implementation	HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL)		40799	0	2011-09-20T15:37:09.593000-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);