home / lobbying

lobbying_activities

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

980 rows where filing_period = "third_quarter", filing_year = 2009 and issue_code = "FIN" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_termination, received_date (date)

issue_code 1

  • FIN · 980 ✖

filing_year 1

  • 2009 · 980 ✖

filing_period 1

  • third_quarter · 980 ✖
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
818534 PROCESS HANDLER ET AL. FOR HIRE, INC. fcd010c8-e0af-46f4-af7c-9a2140cd37f0 Q3 PROCESS HANDLER ET AL. FOR HIRE, INC. 81830 ESTATE OF DELOIS ALBERT BRASSELL 2009 third_quarter FIN Several postage-paid postcards (dated July 11, 2009) addressed to various U.S. federal executive and military and various international et al. officials regarding many, various unfinished, outstanding investment et al. matters and concerns regarding many investment and other financial houses' ... "adversarial approaches" towards the Estate of Delois Albert Brassell via the Delois Albert Brassell Estate Administrator (i.e., Mr. Robert J. Brassell, Jr., N.P.). Several postage-paid postcards (dated July 11, 2009) addressed to all Members, inclusive, all Advisors, inclusive, all operatives, inclusive, all officers, inclusive, et al., inclusive, of the United States National Security Council (NSC), the Office of the United States Trade Representative (USTR), the World Trade Organization (WTO, via the Office of the United States Trade Representative (USTR)) and the United Nations Security Council et al., inclusive, and the current Head and Deputy Head of the Delegation of the European Commission of the European Union (EU) to the United States of America and the United Nations regarding many, various unfinished, outstanding investment et al. matters and concerns regarding Deutsche Bank AG, UBS AG, the Development Bank of Japan, Israel Discount Bank Ltd., Morgan Stanley, the Nippon Life Insurance Company, Investcorp Bank B.S.C., Oppenheimer Holdings, Inc., Rothschild North America Inc., Rockefeller and Co., Inc., Andor Capital Management, L.L.C., Lexington Partners Inc., the Boeing Capital Corporation and Merrill Lynch & Co., Inc./the Bank of America Corporation and same aforementioned investment and other financial houses' flunkies, allies, whores et al.'s ... "adversarial approaches" towards the Estate of Delois Albert Brassell via the Delois Albert Brassell Estate Administrator (i.e., Mr. Robert J. Brassell, Jr., N.P.). Central Intelligence Agency (CIA),Defense, Dept of (DOD),Director of National Intelligence (ODNI),Executive Office of the President (EOP),Joint Chiefs of Staff,Natl Security Council (NSC),President of the U.S.,State, Dept of (DOS),U.S. Trade Representative (USTR),Vice President of the U.S.,White House Office     0 0 2009-07-27T11:14:09-04:00
818554 PROCESS HANDLER ET AL. FOR HIRE, INC. 1ba17b9f-9f64-4df2-bd59-0e9c7b71e562 Q3 PROCESS HANDLER ET AL. FOR HIRE, INC. 81830 ESTATE OF ROBERT JAMES BRASSELL 2009 third_quarter FIN Several postage-paid postcards (dated July 11, 2009) addressed to various U.S. federal executive and military and various international et al. officials regarding many, various unfinished, outstanding investment et al. matters and concerns regarding many investment and other financial houses' ... "adversarial approaches" towards the Estate of Delois Albert Brassell via the Delois Albert Brassell Estate Administrator (i.e., Mr. Robert J. Brassell, Jr., N.P.). Several postage-paid postcards (dated July 11, 2009) addressed to all Members, inclusive, all Advisors, inclusive, all operatives, inclusive, all officers, inclusive, et al., inclusive, of the United States National Security Council (NSC), the Office of the United States Trade Representative (USTR), the World Trade Organization (WTO, via the Office of the United States Trade Representative (USTR)) and the United Nations Security Council et al., inclusive, and the current Head and Deputy Head of the Delegation of the European Commission of the European Union (EU) to the United States of America and the United Nations regarding many, various unfinished, outstanding investment et al. matters and concerns regarding Deutsche Bank AG, UBS AG, the Development Bank of Japan, Israel Discount Bank Ltd., Morgan Stanley, the Nippon Life Insurance Company, Investcorp Bank B.S.C., Oppenheimer Holdings, Inc., Rothschild North America Inc., Rockefeller and Co., Inc., Andor Capital Management, L.L.C., Lexington Partners Inc., the Boeing Capital Corporation and Merrill Lynch & Co., Inc./the Bank of America Corporation and same aforementioned investment and other financial houses' flunkies, allies, whores et al.'s ... "adversarial approaches" towards the Estate of Delois Albert Brassell via the Delois Albert Brassell Estate Administrator (i.e., Mr. Robert J. Brassell, Jr., N.P.). Central Intelligence Agency (CIA),Defense, Dept of (DOD),Director of National Intelligence (ODNI),Executive Office of the President (EOP),Joint Chiefs of Staff,Natl Security Council (NSC),President of the U.S.,State, Dept of (DOS),U.S. Trade Representative (USTR),Vice President of the U.S.,White House Office     0 0 2009-07-27T11:16:17-04:00
818571 PROCESS HANDLER ET AL. FOR HIRE, INC. d3605dbe-9ed5-467c-841b-a86a111bdd39 Q3 PROCESS HANDLER ET AL. FOR HIRE, INC. 81830 MR. ROBERT J. BRASSELL, JR. 2009 third_quarter FIN Several postage-paid postcards (dated July 11, 2009) addressed to various U.S. federal executive and military and various international et al. officials regarding many, various unfinished, outstanding investment et al. matters and concerns regarding many investment and other financial houses' ... "adversarial approaches" towards the Estate of Delois Albert Brassell via the Delois Albert Brassell Estate Administrator (i.e., Mr. Robert J. Brassell, Jr., N.P.). Several postage-paid postcards (dated July 11, 2009) addressed to all Members, inclusive, all Advisors, inclusive, all operatives, inclusive, all officers, inclusive, et al., inclusive, of the United States National Security Council (NSC), the Office of the United States Trade Representative (USTR), the World Trade Organization (WTO, via the Office of the United States Trade Representative (USTR)) and the United Nations Security Council et al., inclusive, and the current Head and Deputy Head of the Delegation of the European Commission of the European Union (EU) to the United States of America and the United Nations regarding many, various unfinished, outstanding investment et al. matters and concerns regarding Deutsche Bank AG, UBS AG, the Development Bank of Japan, Israel Discount Bank Ltd., Morgan Stanley, the Nippon Life Insurance Company, Investcorp Bank B.S.C., Oppenheimer Holdings, Inc., Rothschild North America Inc., Rockefeller and Co., Inc., Andor Capital Management, L.L.C., Lexington Partners Inc., the Boeing Capital Corporation and Merrill Lynch & Co., Inc./the Bank of America Corporation and same aforementioned investment and other financial houses' flunkies, allies, whores et al.'s ... "adversarial approaches" towards the Estate of Delois Albert Brassell via the Delois Albert Brassell Estate Administrator (i.e., Mr. Robert J. Brassell, Jr., N.P.). Central Intelligence Agency (CIA),Defense, Dept of (DOD),Director of National Intelligence (ODNI),Executive Office of the President (EOP),Joint Chiefs of Staff,Natl Security Council (NSC),President of the U.S.,State, Dept of (DOS),U.S. Trade Representative (USTR),Vice President of the U.S.,White House Office     0 0 2009-07-27T11:19:23-04:00
818588 PROCESS HANDLER ET AL. FOR HIRE, INC. 7951318a-6db3-4056-b43e-985f4aea086d Q3 PROCESS HANDLER ET AL. FOR HIRE, INC. 81830 PROCESS HANDLER ET AL. FOR HIRE, INC. 2009 third_quarter FIN Several postage-paid postcards (dated July 11, 2009) addressed to various U.S. federal executive and military and various international et al. officials regarding many, various unfinished, outstanding investment et al. matters and concerns regarding many investment and other financial houses' ... "adversarial approaches" towards the Estate of Delois Albert Brassell via the Delois Albert Brassell Estate Administrator (i.e., Mr. Robert J. Brassell, Jr., N.P.). Several postage-paid postcards (dated July 11, 2009) addressed to all Members, inclusive, all Advisors, inclusive, all operatives, inclusive, all officers, inclusive, et al., inclusive, of the United States National Security Council (NSC), the Office of the United States Trade Representative (USTR), the World Trade Organization (WTO, via the Office of the United States Trade Representative (USTR)) and the United Nations Security Council et al., inclusive, and the current Head and Deputy Head of the Delegation of the European Commission of the European Union (EU) to the United States of America and the United Nations regarding many, various unfinished, outstanding investment et al. matters and concerns regarding Deutsche Bank AG, UBS AG, the Development Bank of Japan, Israel Discount Bank Ltd., Morgan Stanley, the Nippon Life Insurance Company, Investcorp Bank B.S.C., Oppenheimer Holdings, Inc., Rothschild North America Inc., Rockefeller and Co., Inc., Andor Capital Management, L.L.C., Lexington Partners Inc., the Boeing Capital Corporation and Merrill Lynch & Co., Inc./the Bank of America Corporation and same aforementioned investment and other financial houses' flunkies, allies, whores et al.'s ... "adversarial approaches" towards the Estate of Delois Albert Brassell via the Delois Albert Brassell Estate Administrator (i.e., Mr. Robert J. Brassell, Jr., N.P.). Central Intelligence Agency (CIA),Defense, Dept of (DOD),Director of National Intelligence (ODNI),Executive Office of the President (EOP),Joint Chiefs of Staff,Natl Security Council (NSC),President of the U.S.,State, Dept of (DOS),U.S. Trade Representative (USTR),Vice President of the U.S.,White House Office     0 0 2009-07-27T11:21:29-04:00
821244 PROCESS HANDLER ET AL. FOR HIRE, INC. 47d4bd86-d147-49de-80f1-cec65d9cafd5 Q3 PROCESS HANDLER ET AL. FOR HIRE, INC. 81830 ESTATE OF WALTER F MCCARTHY 2009 third_quarter FIN Several written correspondence (dated June 8, 2009 and sent via United States Postal Service (USPS) First-Class Certified Mail) addressed to several senior United States federal, state and local executive officials regarding "[alleged] theft from and (assumed) misuse of the late Mr. Walter F. McCarthy's Chase Bank checking account" (directly quoted from the aforementioned June 2009 written correspondence). Several written correspondence (dated June 8, 2009 and sent via United States Postal Service (USPS) First-Class Certified Mail) addressed to the Executive Assistant Director of the Federal Bureau of Investigation of the United States federal Department of Justice (FBI) for the Criminal, Cyber, Responses, and Services Branch Thomas J. Harrington, FBI Assistant Director-in-Charge for the New York Division Joseph M. Demarest, Jr., and whomever was the then-current FBI Special Agent-in-Charge for the Criminal Division (all via the FBI - New York Division office), Richmond County/Staten Island (N.Y.) District Attorney Daniel M. Donovan, Jr., and Richmond County/Staten Island (N.Y.) Chief Assistant District Attorney Daniel L. Master, Jr. (via the Office of the District Attorney of the County of Richmond of the State of New York), Commissioner of Police of the City of New York of the State of New York Raymond W. Kelly, First Deputy Commissioner of Police of the City of New York of the State of New York George A. Grasso, Chief of Department of the Police Department of the City of New York of the State of New York Joseph Esposito and Bureau Chief of Detectives of the Police Department of the City of New York of the State of New York George F. Brown (via the New York City (N.Y.) Police Department's Commissioner's Office), New York State Attorney General Andrew Cuomo and whomever was the then-current Deputy New York State Attorney General for Public Advocacy (all via the Office of the Attorney General of the State of New York) and Chairman of the Board of Directors and Chief Executive Officer of JPMorgan Chase & Co. and J… Federal Bureau of Investigation (FBI)     0 0 2009-09-21T22:21:10-04:00
821246 PROCESS HANDLER ET AL. FOR HIRE, INC. 253fb1ab-546e-4ec6-b55b-04001c865485 Q3 PROCESS HANDLER ET AL. FOR HIRE, INC. 81830 ESTATE OF JANE CARBIS 2009 third_quarter FIN Several written correspondence (dated June 8, 2009 and sent via United States Postal Service (USPS) First-Class Certified Mail) addressed to several senior United States federal, state and local executive officials regarding "[alleged] theft from and (assumed) misuse of the late Mr. Walter F. McCarthy's Chase Bank checking account" (directly quoted from the aforementioned June 2009 written correspondence). (pro bono lobbying activities) Several written correspondence (dated June 8, 2009 and sent via United States Postal Service (USPS) First-Class Certified Mail) addressed to the Executive Assistant Director of the Federal Bureau of Investigation of the United States federal Department of Justice (FBI) for the Criminal, Cyber, Responses, and Services Branch Thomas J. Harrington, FBI Assistant Director-in-Charge for the New York Division Joseph M. Demarest, Jr., and whomever was the then-current FBI Special Agent-in-Charge for the Criminal Division (all via the FBI - New York Division office), Richmond County/Staten Island (N.Y.) District Attorney Daniel M. Donovan, Jr., and Richmond County/Staten Island (N.Y.) Chief Assistant District Attorney Daniel L. Master, Jr. (via the Office of the District Attorney of the County of Richmond of the State of New York), Commissioner of Police of the City of New York of the State of New York Raymond W. Kelly, First Deputy Commissioner of Police of the City of New York of the State of New York George A. Grasso, Chief of Department of the Police Department of the City of New York of the State of New York Joseph Esposito and Bureau Chief of Detectives of the Police Department of the City of New York of the State of New York George F. Brown (via the New York City (N.Y.) Police Department's Commissioner's Office), New York State Attorney General Andrew Cuomo and whomever was the then-current Deputy New York State Attorney General for Public Advocacy (all via the Office of the Attorney General of the State of New York) and Chairman of the Board of Directors and Chief Executive Offi… Federal Bureau of Investigation (FBI)     0 0 2009-09-21T22:44:11-04:00
821248 PROCESS HANDLER ET AL. FOR HIRE, INC. 928d30dd-3bbb-407f-a687-3253799b3851 Q3 PROCESS HANDLER ET AL. FOR HIRE, INC. 81830 ESTATE OF ALFRED WILLIAM SCHRAMMAR 2009 third_quarter FIN Several written correspondence (dated June 8, 2009 and sent via United States Postal Service (USPS) First-Class Certified Mail) addressed to several senior United States federal, state and local executive officials regarding "[alleged] theft from and (assumed) misuse of the late Mr. Walter F. McCarthy's Chase Bank checking account" (directly quoted from the aforementioned June 2009 written correspondence). (pro bono lobbying activities) Several written correspondence (dated June 8, 2009 and sent via United States Postal Service (USPS) First-Class Certified Mail) addressed to the Executive Assistant Director of the Federal Bureau of Investigation of the United States federal Department of Justice (FBI) for the Criminal, Cyber, Responses, and Services Branch Thomas J. Harrington, FBI Assistant Director-in-Charge for the New York Division Joseph M. Demarest, Jr., and whomever was the then-current FBI Special Agent-in-Charge for the Criminal Division (all via the FBI - New York Division office), Richmond County/Staten Island (N.Y.) District Attorney Daniel M. Donovan, Jr., and Richmond County/Staten Island (N.Y.) Chief Assistant District Attorney Daniel L. Master, Jr. (via the Office of the District Attorney of the County of Richmond of the State of New York), Commissioner of Police of the City of New York of the State of New York Raymond W. Kelly, First Deputy Commissioner of Police of the City of New York of the State of New York George A. Grasso, Chief of Department of the Police Department of the City of New York of the State of New York Joseph Esposito and Bureau Chief of Detectives of the Police Department of the City of New York of the State of New York George F. Brown (via the New York City (N.Y.) Police Department's Commissioner's Office), New York State Attorney General Andrew Cuomo and whomever was the then-current Deputy New York State Attorney General for Public Advocacy (all via the Office of the Attorney General of the State of New York) and Chairman of the Board of Directors and Chief Executive Offi… Federal Bureau of Investigation (FBI)     0 0 2009-09-21T22:57:14-04:00
821252 PROCESS HANDLER ET AL. FOR HIRE, INC. 99a049fd-2502-423b-a6d3-4043f4e68dc1 Q3 PROCESS HANDLER ET AL. FOR HIRE, INC. 81830 MS SCOTT SCHRAMMAR 2009 third_quarter FIN Several written correspondence (dated June 8, 2009 and sent via United States Postal Service (USPS) First-Class Certified Mail) addressed to several senior United States federal, state and local executive officials regarding "[alleged] theft from and (assumed) misuse of the late Mr. Walter F. McCarthy's Chase Bank checking account" (directly quoted from the aforementioned June 2009 written correspondence). (pro bono lobbying activities) Several written correspondence (dated June 8, 2009 and sent via United States Postal Service (USPS) First-Class Certified Mail) addressed to the Executive Assistant Director of the Federal Bureau of Investigation of the United States federal Department of Justice (FBI) for the Criminal, Cyber, Responses, and Services Branch Thomas J. Harrington, FBI Assistant Director-in-Charge for the New York Division Joseph M. Demarest, Jr., and whomever was the then-current FBI Special Agent-in-Charge for the Criminal Division (all via the FBI - New York Division office), Richmond County/Staten Island (N.Y.) District Attorney Daniel M. Donovan, Jr., and Richmond County/Staten Island (N.Y.) Chief Assistant District Attorney Daniel L. Master, Jr. (via the Office of the District Attorney of the County of Richmond of the State of New York), Commissioner of Police of the City of New York of the State of New York Raymond W. Kelly, First Deputy Commissioner of Police of the City of New York of the State of New York George A. Grasso, Chief of Department of the Police Department of the City of New York of the State of New York Joseph Esposito and Bureau Chief of Detectives of the Police Department of the City of New York of the State of New York George F. Brown (via the New York City (N.Y.) Police Department's Commissioner's Office), New York State Attorney General Andrew Cuomo and whomever was the then-current Deputy New York State Attorney General for Public Advocacy (all via the Office of the Attorney General of the State of New York) and Chairman of the Board of Directors and Chief Executive Offi… Federal Bureau of Investigation (FBI)     0 0 2009-09-21T23:05:16-04:00
821254 PROCESS HANDLER ET AL. FOR HIRE, INC. dcb5a155-fbc6-4c53-850e-e51097140d2a Q3 PROCESS HANDLER ET AL. FOR HIRE, INC. 81830 MRS JOAN A SCHRAMMAR-MCCARTHY 2009 third_quarter FIN Several written correspondence (dated June 8, 2009 and sent via United States Postal Service (USPS) First-Class Certified Mail) addressed to several senior United States federal, state and local executive officials regarding "[alleged] theft from and (assumed) misuse of the late Mr. Walter F. McCarthy's Chase Bank checking account" (directly quoted from the aforementioned June 2009 written correspondence). (pro bono lobbying activities) Several written correspondence (dated June 8, 2009 and sent via United States Postal Service (USPS) First-Class Certified Mail) addressed to the Executive Assistant Director of the Federal Bureau of Investigation of the United States federal Department of Justice (FBI) for the Criminal, Cyber, Responses, and Services Branch Thomas J. Harrington, FBI Assistant Director-in-Charge for the New York Division Joseph M. Demarest, Jr., and whomever was the then-current FBI Special Agent-in-Charge for the Criminal Division (all via the FBI - New York Division office), Richmond County/Staten Island (N.Y.) District Attorney Daniel M. Donovan, Jr., and Richmond County/Staten Island (N.Y.) Chief Assistant District Attorney Daniel L. Master, Jr. (via the Office of the District Attorney of the County of Richmond of the State of New York), Commissioner of Police of the City of New York of the State of New York Raymond W. Kelly, First Deputy Commissioner of Police of the City of New York of the State of New York George A. Grasso, Chief of Department of the Police Department of the City of New York of the State of New York Joseph Esposito and Bureau Chief of Detectives of the Police Department of the City of New York of the State of New York George F. Brown (via the New York City (N.Y.) Police Department's Commissioner's Office), New York State Attorney General Andrew Cuomo and whomever was the then-current Deputy New York State Attorney General for Public Advocacy (all via the Office of the Attorney General of the State of New York) and Chairman of the Board of Directors and Chief Executive Offi… Federal Bureau of Investigation (FBI)     0 0 2009-09-21T23:13:19-04:00
821257 PROCESS HANDLER ET AL. FOR HIRE, INC. b57a0058-5c41-487f-860d-cce2014e6c40 Q3 PROCESS HANDLER ET AL. FOR HIRE, INC. 81830 MS JOAL M SCHRAMMAR 2009 third_quarter FIN Several written correspondence (dated June 8, 2009 and sent via United States Postal Service (USPS) First-Class Certified Mail) addressed to several senior United States federal, state and local executive officials regarding "[alleged] theft from and (assumed) misuse of the late Mr. Walter F. McCarthy's Chase Bank checking account" (directly quoted from the aforementioned June 2009 written correspondence). (pro bono lobbying activities) Several written correspondence (dated June 8, 2009 and sent via United States Postal Service (USPS) First-Class Certified Mail) addressed to the Executive Assistant Director of the Federal Bureau of Investigation of the United States federal Department of Justice (FBI) for the Criminal, Cyber, Responses, and Services Branch Thomas J. Harrington, FBI Assistant Director-in-Charge for the New York Division Joseph M. Demarest, Jr., and whomever was the then-current FBI Special Agent-in-Charge for the Criminal Division (all via the FBI - New York Division office), Richmond County/Staten Island (N.Y.) District Attorney Daniel M. Donovan, Jr., and Richmond County/Staten Island (N.Y.) Chief Assistant District Attorney Daniel L. Master, Jr. (via the Office of the District Attorney of the County of Richmond of the State of New York), Commissioner of Police of the City of New York of the State of New York Raymond W. Kelly, First Deputy Commissioner of Police of the City of New York of the State of New York George A. Grasso, Chief of Department of the Police Department of the City of New York of the State of New York Joseph Esposito and Bureau Chief of Detectives of the Police Department of the City of New York of the State of New York George F. Brown (via the New York City (N.Y.) Police Department's Commissioner's Office), New York State Attorney General Andrew Cuomo and whomever was the then-current Deputy New York State Attorney General for Public Advocacy (all via the Office of the Attorney General of the State of New York) and Chairman of the Board of Directors and Chief Executive Offi… Federal Bureau of Investigation (FBI)     0 0 2009-09-21T23:23:20-04:00
821261 PROCESS HANDLER ET AL. FOR HIRE, INC. 3d51e77f-6951-48c2-9ec0-60057ddc3a04 Q3 PROCESS HANDLER ET AL. FOR HIRE, INC. 81830 MRS. MARY F. PEARSALL 2009 third_quarter FIN Several written correspondence (dated June 8, 2009 and sent via United States Postal Service (USPS) First-Class Certified Mail) addressed to several senior United States federal, state and local executive officials regarding "[alleged] theft from and (assumed) misuse of the late Mr. Walter F. McCarthy's Chase Bank checking account" (directly quoted from the aforementioned June 2009 written correspondence). (pro bono lobbying activities) Several written correspondence (dated June 8, 2009 and sent via United States Postal Service (USPS) First-Class Certified Mail) addressed to the Executive Assistant Director of the Federal Bureau of Investigation of the United States federal Department of Justice (FBI) for the Criminal, Cyber, Responses, and Services Branch Thomas J. Harrington, FBI Assistant Director-in-Charge for the New York Division Joseph M. Demarest, Jr., and whomever was the then-current FBI Special Agent-in-Charge for the Criminal Division (all via the FBI - New York Division office), Richmond County/Staten Island (N.Y.) District Attorney Daniel M. Donovan, Jr., and Richmond County/Staten Island (N.Y.) Chief Assistant District Attorney Daniel L. Master, Jr. (via the Office of the District Attorney of the County of Richmond of the State of New York), Commissioner of Police of the City of New York of the State of New York Raymond W. Kelly, First Deputy Commissioner of Police of the City of New York of the State of New York George A. Grasso, Chief of Department of the Police Department of the City of New York of the State of New York Joseph Esposito and Bureau Chief of Detectives of the Police Department of the City of New York of the State of New York George F. Brown (via the New York City (N.Y.) Police Department's Commissioner's Office), New York State Attorney General Andrew Cuomo and whomever was the then-current Deputy New York State Attorney General for Public Advocacy (all via the Office of the Attorney General of the State of New York) and Chairman of the Board of Directors and Chief Executive Offi… Federal Bureau of Investigation (FBI)     0 0 2009-09-21T23:31:21-04:00
821598 HOLLAND & KNIGHT LLP e858ad89-11fb-4b08-b5cf-d25175997b57 Q3 HOLLAND & KNIGHT LLP 18466 AMERICAN RESORT DEVELOPMENT ASSOCIATION 2009 third_quarter FIN TARP and TALF and other mortgage related bills as they effect the timeshare industry. HOUSE OF REPRESENTATIVES,SENATE     0 0 2009-09-30T14:48:02-04:00
821737 JOHN SATAGAJ c8780a4e-2287-46e5-9af7-276c68bfef18 Q3 JOHN SATAGAJ 23064 NATIONAL HOME FURNISHINGS ASSOCIATION 2009 third_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 0 2009-10-01T11:04:48-04:00
821819 DUTKO WORLDWIDE, LLC df0eb259-4a65-49ad-9509-6f84d3f8b6fb Q3 DUTKO WORLDWIDE, LLC 12868 WORLD TRADE CENTER PROPERTIES LLC (FORMERLY WACHTEL LIPTON ROSEN & KATZ) 2009 third_quarter FIN Lobby for the issues affecting the rebuilding of the World Trade Center, including tax and insurance issues. Monitored the American Recovery and Reinvestment Act of 2009 (HR1) as well as potential tax extender legislation. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2009-10-01T11:46:25-04:00
821973 BRADLEY ARANT BOULT CUMMINGS LLP 6f1b29e8-e388-4807-bc2d-ae8dfb661b8c Q3 BRADLEY ARANT BOULT CUMMINGS LLP 36914 YEAGER & BOYD LLC 2009 third_quarter FIN The Department of Housing and Urban Development (HUD) proposed rule titled Independent Public Accountant Roster and modification of HUD's existing regulations in 24 CFR Part 5 HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE     0 0 2009-10-02T10:16:00-04:00
822039 REED SMITH LLP 2dd666c8-934a-44f6-b493-637716bf0271 Q3 REED SMITH LLP 32932 FEDERATED INVESTORS INC 2009 third_quarter FIN SEC financial responsibility rules for brokers-dealers. SENATE     0 0 2009-10-02T12:45:00-04:00
822064 COMBEST, SELL & ASSOCIATES, LLC 324af293-9642-4764-88aa-80e9fa7eb8c6 Q3 COMBEST, SELL & ASSOCIATES, LLC 294198 NATIONAL RURAL ELECTRIC COOPERATIVE ASSOCIATION 2009 third_quarter FIN Financial Market regulation legislation concerning Over The Counter Derivitives. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2009-10-02T13:28:14-04:00
822260 MORRISON PUBLIC AFFAIRS GROUP 0d55d59a-a94f-4ca6-b6ff-d81dab326a65 Q3 MORRISON PUBLIC AFFAIRS GROUP 67193 ESSENT U.S. HOLDINGS, INC. 2009 third_quarter FIN Mortgage insurance regulation and related policies Federal Housing Finance Agency (FHFA),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 60000   0 0 2009-10-03T19:13:36-04:00
822359 LAWRENCE J. SMITH, P.A. 77871a7c-ee86-4ff5-a5dc-da5cf0c842f8 3T LAWRENCE J. SMITH, P.A. 35775 DAVIDSOHN GLOBAL TECHNOLOGIES, INC. 2009 third_quarter FIN ALL ISSUES PERTAINING TO FINANCIAL SERVICES LEGISLATION. HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2009-10-05T10:30:45-04:00
822370 FINANCIAL EXECUTIVES INTERNATIONAL ff8a311e-fe50-45aa-8fe4-b00a1f55d8d1 Q3 FINANCIAL EXECUTIVES INTERNATIONAL 14520 FINANCIAL EXECUTIVES INTERNATIONAL 2009 third_quarter FIN Credit Rating Agencies; Regulation of Derivatives Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of   70000 0 0 2009-10-05T11:05:50-04:00
822527 LOUIS DREYFUS COMMODITIES LLC f91643ff-c76e-4645-bbf5-b4df9b1ad57a Q3 LOUIS DREYFUS COMMODITIES LLC 12620 LOUIS DREYFUS COMMODITIES LLC 2009 third_quarter FIN Financial Reforms Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Council of Economic Advisers (CEA),Energy, Dept of,Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Natl Security Council (NSC),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Surface Transportation Board (STB),Treasury, Dept of,U.S. Agency for International Development (USAID),U.S. Customs & Border Protection,U.S. Trade Representative (USTR)   50000 0 0 2009-10-05T14:35:27-04:00
822543 HUONG C. "SUSAN" LYONS 3f9dc0a5-66e5-4ce7-b742-3f3a4e0aa39d Q3 HUONG C. "SUSAN" LYONS 71872 LOUIS DREYFUS COMMODITIES LLC (FORMERLY KNOWN AS LOUIS DREYFUS CORPORATION) 2009 third_quarter FIN Financial Reforms Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Council of Economic Advisers (CEA),Energy, Dept of,Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Natl Security Council (NSC),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Surface Transportation Board (STB),Treasury, Dept of,U.S. Agency for International Development (USAID),U.S. Customs & Border Protection,U.S. Trade Representative (USTR),White House Office 20000   0 0 2009-10-05T14:50:35-04:00
822641 WHYTE HIRSCHBOECK DUDEK S.C. 766c454c-d0b3-44f0-8900-d59b7e8c6122 3T WHYTE HIRSCHBOECK DUDEK S.C. 89953 MCKINLEY RESERVE 2009 third_quarter FIN Property Dispute with the Government of Dubai HOUSE OF REPRESENTATIVES,SENATE 20000   0 1 2009-10-05T17:12:09-04:00
822704 COLLEEN KELLY 023a7ff9-98b7-433d-a1de-19cdde0dbe4f Q3 COLLEEN KELLY 321338 WASHINGTON CREDIT UNION LEAGUE AND AFFILIATES 2009 third_quarter FIN CRA, (HR 1479) Consumer Financial Protection Agency Act, HR 3126 Credit Card Fair Fee Act of 2009, HR 2695 HOUSE OF REPRESENTATIVES,SENATE 6000   0 0 2009-10-06T07:45:01-04:00
822721 KEYCORP 217708d4-5bf9-4df7-8499-d4f25c622edb Q3 KEYCORP 400276327 KEYCORP 2009 third_quarter FIN Regulatory Reform, ENDA, NOL Carryback, NMTC, FDIC Borrowing Authority, Educational Lending/FFELP HOUSE OF REPRESENTATIVES,SENATE   30000 0 0 2009-10-06T10:09:59-04:00
822795 LONG LAW FIRM 2782c028-4b29-4699-805d-fd4c78652c39 Q3 LONG LAW FIRM 23111 RELATIONAL INVESTORS LLC 2009 third_quarter FIN Corporate governance issues HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2009-10-06T11:33:38-04:00
822859 THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) 8c2f15ea-9d75-4b25-890a-7747f4bd3665 3T THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) 33875 AMERICAN COURT AND COMMERCIAL NEWSPAPER ASSOCIATION 2009 third_quarter FIN H.R. 2727, to provide for the implementation of a system under which each financial institution will report on the financial condition of the institution to the public -- all provisions. HOUSE OF REPRESENTATIVES,SENATE 30000   0 1 2009-10-06T12:56:12-04:00
822865 LOWE'S COMPANIES INC. fa4ef735-2c95-422c-afaa-419e46bec601 Q3 LOWE'S COMPANIES INC. 312678 LOWE'S COMPANIES INC. 2009 third_quarter FIN Regulatory language re regulatory rulings on zero percent financing programs and minimum monthly payment requirements. Federal Reserve System,Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE   60000 0 0 2009-10-06T12:58:52-04:00
822928 THE MACON EDWARDS COMPANY d879b10d-de33-4d02-90e7-7a5a5e3ec80f Q3 THE MACON EDWARDS COMPANY 13200 TRADING TECHNOLOGIES INTERNATIONAL, INC. 2009 third_quarter FIN Monitor the regulatory reform issue. Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2009-10-06T13:46:58-04:00
823090 DELTA STRATEGY GROUP 41502d5a-3793-441e-8191-31fcb60c3e93 Q3 DELTA STRATEGY GROUP 310370 ADARA NETWORKS 2009 third_quarter FIN Medical health records initiative. HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2009-10-06T16:10:02-04:00
823113 BUILDING OWNERS AND MANAGERS ASSOCIATION INTERNATIONAL cfe445f2-2f04-45bd-a660-f3ead17c4a84 Q3 BUILDING OWNERS AND MANAGERS ASSOCIATION INTERNATIONAL 7394 BUILDING OWNERS AND MANAGERS ASSOCIATION INTERNATIONAL 2009 third_quarter FIN Credit/liquidity crisis - BOMA supports measures to help ease the credit crunch and restore balance to the commercial real estate industry. Federal Reserve System,HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of   50000 0 0 2009-10-06T16:35:12-04:00
823120 DELTA STRATEGY GROUP 0ab6d225-fbc6-4746-8ece-3fd5babe5e1a 3T DELTA STRATEGY GROUP 310370 ADARA NETWORKS 2009 third_quarter FIN Medical health records initiative. HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2009-10-06T16:43:15-04:00
823121 DELTA STRATEGY GROUP 29764317-a436-406c-bb0b-eaed5d32b2c6 Q3 DELTA STRATEGY GROUP 310370 MF GLOBAL 2009 third_quarter FIN Monitor CFTC regulations. Commodity Futures Trading Commission (CFTC) 20000   0 0 2009-10-06T16:51:16-04:00
823142 DELTA STRATEGY GROUP ff2d6898-c11e-49fe-b2a3-c53ce84bc4c1 Q3 DELTA STRATEGY GROUP 310370 CME GROUP 2009 third_quarter FIN Monitor legislation and regulations impacting the futures markets and regulatory reform efforts in general. Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2009-10-06T17:00:19-04:00
823213 CAPITOL HILL CONSULTING GROUP dea2a160-db85-4d39-a623-d737227c28f4 Q3 CAPITOL HILL CONSULTING GROUP 72053 INTERSECTIONS, INC 2009 third_quarter FIN Legislation pertaining to the Consumer Financial Protection Agency HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2009-10-07T10:09:48-04:00
823295 CAPITOL HILL CONSULTING GROUP 5d54905c-677a-430a-ba15-4d0a28d83284 Q3 CAPITOL HILL CONSULTING GROUP 72053 POPULUS FINANCIAL GROUP, INC. (FORMERLY ACE CASH EXPRESS, INC.) 2009 third_quarter FIN general financial services issues and issues pertaining to the company; S.3632, H.R.1214; H.R.1846; H.R.2563; H.R.1608 HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2009-10-07T11:23:35-04:00
823345 HOLLAND & KNIGHT LLP c432a0b2-36e4-4b14-9557-62c5912a9833 Q3 HOLLAND & KNIGHT LLP 18466 ALLIED AVIATION HOLDINGS CORPORATION 2009 third_quarter FIN Troubled Asset Relief Program HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of     0 0 2009-10-07T12:17:54-04:00
823348 HOLLAND & KNIGHT LLP d64952e8-aa37-42bb-ba9f-338cfe6b512d Q3 HOLLAND & KNIGHT LLP 18466 AMSCOT FINANCIAL CORPORATION 2009 third_quarter FIN Legislation and policies affecting financial services; including pay day advances and check cashing. HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2009-10-07T12:19:55-04:00
823505 ACG ADVOCACY b9e10de6-03cf-47b5-a598-28ce90158c0d Q3 ACG ADVOCACY 2057 MERCHANTS PAYMENTS COALITION INC 2009 third_quarter FIN Credit Card Inter-Change Fee Issues HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2009-10-07T15:12:04-04:00
823519 ACG ADVOCACY 7706e758-3af9-433f-8e98-b78b313a9b42 Q3 ACG ADVOCACY 2057 FORTEGRA FINANCIAL 2009 third_quarter FIN Financial Regulation Reform Credit Insurance and interest charged on installment loans; H.R. 1640: Interest Rate Reduction Act S.500: Protecting Consumers from Unreasonable Credit Rates Act of 2009 H.R. 1608: Protecting Consumers from Unreasonable Credit Rates Act of 2009 HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2009-10-07T15:23:09-04:00
823530 JAMISON AND SULLIVAN, INC. a0dcfcff-372e-434f-9d19-c6eaab72bbbf 3A JAMISON AND SULLIVAN, INC. 20414 MONTANA STATE UNIVERSITY-BILLINGS FOUNDATION 2009 third_quarter FIN To seek the ability to use "tax credits" for the development of "family student housing" coupled with child care which would address two key issues that cause the drop-out of single parent students. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2009-10-07T15:31:07-04:00
823543 EQUIPMENT LEASING AND FINANCE ASSOCIATION ce7a8f64-0090-45d0-953b-cbdbdc9f2900 Q3 EQUIPMENT LEASING AND FINANCE ASSOCIATION 13767 EQUIPMENT LEASING AND FINANCE ASSOCIATION 2009 third_quarter FIN Term Asset Backed Securities Loan Facility (TALF) Temporary Liquidity Guaranty Program (TLGP) Federal Aviation Administration (FAA),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Transportation, Dept of (DOT),Treasury, Dept of   50000 0 0 2009-10-07T15:47:23-04:00
823552 DELTA STRATEGY GROUP 1675e998-a872-477a-a7d9-5c53e0def31d Q3 DELTA STRATEGY GROUP 310370 EXELON BUSINESS SERVICES LLC (FORMERLY KNOWN AS CONSTELLATION ENERGY GROUP) 2009 third_quarter FIN Derivatives regulation and legislation. Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE 30000   0 0 2009-10-07T15:50:08-04:00
823565 DELTA STRATEGY GROUP 14e9e716-9f0d-4eb6-870b-94504607622f Q3 DELTA STRATEGY GROUP 310370 TRADING TECHNOLOGIES INTERNATIONAL, INC. 2009 third_quarter FIN Monitor derivatives related regulation and legislation. Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2009-10-07T15:59:10-04:00
823592 DELTA STRATEGY GROUP 47b8eb9b-a7f1-4c95-b528-f8488bc01967 Q3 DELTA STRATEGY GROUP 310370 D.E. SHAW & CO., L.P. 2009 third_quarter FIN Monitor derivatives and equity regulation and legislation. Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE 50000   0 0 2009-10-07T16:18:21-04:00
823618 POLSINELLI PC e508e53f-54f9-4686-aa0d-257f0e590206 Q3 POLSINELLI PC 314911 NATIONAL INSTALLMENT LENDERS ASSOCIATION 2009 third_quarter FIN Payday Loan Reform Act of 2009, H.R. 1214 Financial Product Safety Commission Act of 2009, S. 566 Protecting Consumers from Unreasonable Credit Rates Act of 2009, H.R. 1608, S. 500 Universal Default Prohibition Act of 2009, H.R. 1637 Interest Rate Reduction Act, H.R. 1640 The Consumer Credit Fairness Act, S. 257 HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2009-10-07T16:36:48-04:00
823654 KSCW, INC. ee228a03-ab55-4d90-ae01-7c8855cee502 Q3 KSCW, INC. 21596 CMFG LIFE INSURANCE COMPANY 2009 third_quarter FIN Provisions of legislation dealing with credit insurance HR3126 Consumer Financial Protection Agency Act 2009: To establish the Consumer Financial Protection Agency, and other purposes. Title V: Office of National Insurance - of the Treasury's Financial Regulatory Reform Package Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2009-10-07T16:53:58-04:00
823657 KSCW, INC. 65417432-fef6-4381-9ab4-7fa565dd4e43 Q3 KSCW, INC. 21596 FITCH, INC. 2009 third_quarter FIN Provisions of legislation related to the credit ratings industry HR3126 Consumer Financial Protection Agency Act of 2009 Title IX: Additional Improvement to Financial Markets Regulation; Subtitle C: Improvements to the Regulation of Credit Rating Agencies - of the Treasury's proposed Financial Regulatory Reform Package HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2009-10-07T16:56:00-04:00
823675 KSCW, INC. 8dc68f27-5eec-4177-9d13-a1952a9b7a7c Q3 KSCW, INC. 21596 SELECTIVE INSURANCE GROUP INC. 2009 third_quarter FIN Provisions of proposed legislation as it pertains to the regulation of the insurance industry Title V: Office of National Insurance - Of the Treasury's proposed Financial Regulatory Reform package HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2009-10-07T17:04:09-04:00
823678 KSCW, INC. a7960f8b-8209-4b7c-b1a8-42d134ded245 Q3 KSCW, INC. 21596 STARK & ROTH, INC. 2009 third_quarter FIN Provisions of legislation and regulations as related to TARP oversight, mark to market accounting, shortselling and Net Operating Loss and the registration of private funds Title IV: Registration of Advisers to Private Funds - Of the Treasury's Financial Regulatory Reform Package HR3126 Consumer Financial Protection Agency Act of 2009 HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2009-10-07T17:05:11-04:00
823713 MULTIPLE STRATEGIES LLC acd6d7bd-d6c3-40a5-85bc-3c6316af3f2e Q3 MULTIPLE STRATEGIES LLC 318254 AXA SA 2009 third_quarter FIN Holocaust Insurance Claims Accountability Act HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2009-10-07T23:35:35-04:00
823714 MULTIPLE STRATEGIES LLC a5fbf75b-0ba9-4bfa-b580-ed6d3441834b Q3 MULTIPLE STRATEGIES LLC 318254 FEDERATED INVESTORS 2009 third_quarter FIN mutual fund issues financial services regulatory reform retirement security issues HOUSE OF REPRESENTATIVES,SENATE 37500   0 0 2009-10-07T23:43:37-04:00
823715 MULTIPLE STRATEGIES LLC 1029c313-36c9-4242-997b-437e274e802f Q3 MULTIPLE STRATEGIES LLC 318254 INVESTMENT COMPANY INSTITUTE 2009 third_quarter FIN mutual fund issues retirement security issues related to mutual funds financial services regulatory reform HOUSE OF REPRESENTATIVES,SENATE 22500   0 0 2009-10-07T23:48:38-04:00
823740 HOWREY LLP 94a46efb-f9ad-40e6-a8e9-2aeccce28e3e Q3 HOWREY LLP 18752 MONEY SERVICES ROUND TABLE (FKA THE NON-BANK FUNDS TRANSMITTERS GROUP) 2009 third_quarter FIN Funds transmission disclosure       0 0 2009-10-08T10:20:54-04:00
823778 JG ASSOCIATES 79d103fd-3392-411f-a274-f4cc43d22d21 Q3 JG ASSOCIATES 287656 CHEVRON USA & SUBSIDIARIES/AFFILIATES OF CHEVRON CORP 2009 third_quarter FIN Bilateral investment treaty Commerce, Dept of (DOC),State, Dept of (DOS),Treasury, Dept of,U.S. Trade Representative (USTR)     0 0 2009-10-08T10:51:15-04:00
823881 WHYTE HIRSCHBOECK DUDEK S.C. 0bb18ed8-c350-49bc-9d06-c6761b877226 3@ WHYTE HIRSCHBOECK DUDEK S.C. 89953 MCKINLEY RESERVE 2009 third_quarter FIN Property Dispute with the Government of Dubai HOUSE OF REPRESENTATIVES,SENATE 20000   0 1 2009-10-08T13:51:10-04:00
823888 JG ASSOCIATES 4f8fc8a4-261a-4972-872b-8ea48ca97a10 Q3 JG ASSOCIATES 287656 CHEVRON USA & SUBSIDIARIES/AFFILIATES OF CHEVRON CORP 2009 third_quarter FIN Review of Model BIT Commerce, Dept of (DOC),State, Dept of (DOS),Treasury, Dept of,U.S. Trade Representative (USTR)     0 0 2009-10-08T13:57:05-04:00
823928 CALMETTO MANAGEMENT GROUP 5c4e1fc2-5cc6-4b85-8073-6224311ecb52 Q3 CALMETTO MANAGEMENT GROUP 21610 SELF-INSURANCE INSTITUTE OF AMERICA, INC. 2009 third_quarter FIN Risk Retention Act HOUSE OF REPRESENTATIVES,SENATE 125000   0 0 2009-10-08T14:16:26-04:00
824109 NAVIGANT CONSULTING, INC. 815b77dd-f2a4-459e-9c03-5cdaeb2a4ef6 Q3 NAVIGANT CONSULTING, INC. 8828 NATIONAL ASSOCIATION OF PUBLICLY TRADED PARTNERSHIPS 2009 third_quarter FIN Treatment of non-financial participants under proposals to strengthen regulation of derivatives (H.R. 2454, H.R. 2998, S.1691 and similar proposals) HOUSE OF REPRESENTATIVES,SENATE     0 0 2009-10-08T16:54:59-04:00
824127 AMERICANS FOR TAX REFORM 42659c3d-b058-4b8b-aded-0f8378a7abae Q3 AMERICANS FOR TAX REFORM 3801 AMERICANS FOR TAX REFORM 2009 third_quarter FIN H.R.1207 Federal Reserve Transparency Act of 2009 H.R.1242 To amend the Emergency Economic Stabilization Act of 2008 to provide for additional monitoring and accountability of the Troubled Assets Relief Program. S.910 To amend the Emergency Economic Stabilization Act of 2008 to provide for additional monitoring and accountability of the Troubled Assets Relief Program. H.R.3269 Corporate and Financial Institution Compensation Fairness Act H.R.3221 Student Aid and Fiscal Responsibility Act (SAFRA) Energy, Dept of,Executive Office of the President (EOP),Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)   210000 0 0 2009-10-08T17:08:28-04:00
824164 DAVID GENCARELLI bbbdaa4b-2174-417f-ac14-6c84149b8574 Q3 DAVID GENCARELLI 15918 GUARDIAN LIFE INSURANCE COMPANY OF AMERICA 2009 third_quarter FIN Financial Market Reform HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2009-10-08T18:45:12-04:00
824174 LEVINE & COMPANY 200c6eee-f41c-4387-98c9-c1412dd8b0ce Q3 LEVINE & COMPANY 46916 KOHLBERG KRAVIS & CO 2009 third_quarter FIN Tax and regulatory issues affecting private equity firms HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2009-10-08T20:03:15-04:00
824177 LEVINE & COMPANY 1b6c9391-7943-459e-8ebb-f78735bff8e0 Q3 LEVINE & COMPANY 46916 REGIONS FINANCIAL CORPORATION 2009 third_quarter FIN Issues related to existing and future regulations of banks and financial institutions HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2009-10-08T20:11:17-04:00
824179 LAWRENCE J. ROMANS & ASSOCIATES, LLC e80e51d1-3ac2-43fb-91e2-cbfd14a9732b Q3 LAWRENCE J. ROMANS & ASSOCIATES, LLC 61072 PRUDENTIAL FINANCIAL 2009 third_quarter FIN HR 3126, Consumer Financial Protection Agency Act of 2009, HR 1880, National Insurance Consumr Protection Act of 2009 HR 2609 Insurance information Act of 2009, Regulation of derivatives, financial services regulatory restructuring HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2009-10-08T21:11:16-04:00
824186 LAWRENCE J. ROMANS & ASSOCIATES, LLC 66557dcf-5b99-4307-9769-3ef4cc9f5428 Q3 LAWRENCE J. ROMANS & ASSOCIATES, LLC 61072 JPMORGAN CHASE & CO. 2009 third_quarter FIN HR 977, to amend the Commodity Exchange Act to bring greater tansparency and accountability to commodity markets; HR 627, Credit Cardholders' Bill of Rights Act of 2009; S. 414, Credit Card Act of 2009; regulation of derivatives; financial services regulatory restructuring; HR 3126, The Consumer Financial Protection Agency Act of 2009 HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2009-10-08T21:17:18-04:00
824187 LAWRENCE J. ROMANS & ASSOCIATES, LLC ee46498b-87af-4e62-b9ba-2a62d62e1fd2 Q3 LAWRENCE J. ROMANS & ASSOCIATES, LLC 61072 JOHN T O'ROURKE LAW OFFICES 2009 third_quarter FIN HR 2551, Municipal Market Liquidity Enhancement Act of 2009 HR 2589, Municipal Bond Insurance Enhancement Act of 2009 HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2009-10-08T21:19:20-04:00
824193 LAWRENCE J. ROMANS & ASSOCIATES, LLC f8cfbb70-1445-433b-af31-a4cbf0921c7b Q3 LAWRENCE J. ROMANS & ASSOCIATES, LLC 61072 CHARLES SCHWAB & CO INC 2009 third_quarter FIN Financial regulatory restructuring HR 302, To require the Securities and Exchange Commission to reinstate the uptick rule on short sales of securities HR 2552, Municiapl Market Liquidity Enhancement Act of 2009 HR 3126 Consumer Financial Protection Agency Act of 2009 HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2009-10-08T21:22:21-04:00
824201 LAWRENCE J. ROMANS & ASSOCIATES, LLC 0c79b958-34f1-40ba-bfe0-7b7d2f726bb0 Q3 LAWRENCE J. ROMANS & ASSOCIATES, LLC 61072 AMERICAN COUNCIL OF LIFE INSURERS 2009 third_quarter FIN H.R. 3126, The Consumer Financial Protection Agency Act of 2009, H.R. 1880, The National Insurance Consumer Protection Act; H.R. 2609, The Insurance Information Act of 2009; Financial Regulatory Reform, Federal Regulation of Insurance HOUSE OF REPRESENTATIVES,SENATE     0 0 2009-10-08T21:32:26-04:00
824243 DUTKO WORLDWIDE, LLC e9c30346-cce0-4529-9122-6ad66a751082 Q3 DUTKO WORLDWIDE, LLC 12868 U.S.A.A. 2009 third_quarter FIN Monitor legislation and identify for client potential problems in regulatory reform proposals, and work to address those concerns. Specific legislation monitored was HR 1 (ARRA); HR 3126 (Consumer Financial Protection Agency); Treasury Regulatory Reform Proposals (no bill number). Commodity Futures Trading Commission (CFTC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of 40000   0 0 2009-10-09T09:41:50-04:00
824247 DUTKO WORLDWIDE, LLC 1aa2bc65-4cd9-48a7-8177-a4d5fcee7f5a 3A DUTKO WORLDWIDE, LLC 12868 U.S.A.A. 2009 third_quarter FIN Monitor legislation and identify for client potential problems in regulatory reform proposals, and work to address those concerns. Specific legislation monitored was HR 1 (ARRA); HR 3126 (Consumer Financial Protection Agency); Treasury Regulatory Reform Proposals (no bill number). Commodity Futures Trading Commission (CFTC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of 40000   0 0 2009-10-09T09:41:51-04:00
824263 CAPITOL HILL CONSULTING GROUP 0047a70c-527f-43d0-a719-74cccf9ce825 Q3 CAPITOL HILL CONSULTING GROUP 72053 AMERICAN GAS ASSOCIATION 2009 third_quarter FIN Protect the interests of utilities regarding proposals to regulate the trading of energy derivative instruments; HR 2454 American Clean Energy and Security Act; S272 Derivatives Trading Integrity Act of 2009 HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2009-10-09T09:54:48-04:00
824603 OCCIDENTAL PETROLEUM CORPORATION d5d36329-f545-453c-9d85-3b9bb95469e5 Q3 OCCIDENTAL PETROLEUM CORPORATION 29994 OCCIDENTAL PETROLEUM CORPORATION 2009 third_quarter FIN S272 Derivatives Integrity Act HR 3300 Derivatives Trading Accountability Act S1691 Comprehensive Derivatives Regulations Act Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,State, Dept of (DOS)   687088 0 0 2009-10-09T15:36:23-04:00
824613 CASSIDY & ASSOCIATES, INC. cba65017-2be7-4608-a975-cee0753d4bec Q3 CASSIDY & ASSOCIATES, INC. 8453 OCEAN SPRAY CRANBERRIES 2009 third_quarter FIN Proposed sugar excise tax Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) 100000   0 0 2009-10-09T15:38:43-04:00
824747 MCPHERSON GROUP LLP 10725f7c-baf8-47ac-bfb6-6e6573bcb671 Q3 MCPHERSON GROUP LLP 288715 INSTITUTIONAL LIFE MARKETS ASSOCIATION 2009 third_quarter FIN Life Settlements HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2009-10-09T18:24:26-04:00
824834 THE VELASQUEZ GROUP, L.L.C. 8bdc9785-63e9-44f4-ad71-57eec4fd3dca Q3 THE VELASQUEZ GROUP, L.L.C. 53403 KPMG LLP 2009 third_quarter FIN H.R. 3126, Consumer Financial Protection Agency Act of 2009, all provisions and especially any language which may be interpreted to apply the legislation to accounting services or profession; S.1551, all provisions of this legislation amending section 20 of the SEC Act of 1934 to allow for a private civil action against a person that provides substantial assistance in violation of such Act. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2009-10-11T15:41:00-04:00
824837 THE VELASQUEZ GROUP, L.L.C. 66c9d4d4-f927-4fa7-8882-91015e8d8196 3A THE VELASQUEZ GROUP, L.L.C. 53403 CHARLES SCHWAB & COMPANY 2009 third_quarter FIN H.R. 3126, Consumer Financial Protection Agency Act of 2009, all provisions; any matter pertaining to FDIC insurance of money market funds and financial institution deposits; H.R. 1406, all provisons of the Stock Market Recovery Act to direct the SEC to reinstate the uptick rule on short sale of securities; draft legislation which seeks to create fiduciary liability for retail investment brokerage firms and/or advisors. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2009-10-11T16:34:03-04:00
824839 THE VELASQUEZ GROUP, L.L.C. fff5346c-d187-4af5-83e6-30387d7cd68b Q3 THE VELASQUEZ GROUP, L.L.C. 53403 VISA INC 2009 third_quarter FIN H.R. 3126, Consumer Financial Protection Agency Act of 2009, especially any provision which might be interpreted to apply defacto price contorls on electronic payment card transactions; H.R. 2382, The Credit Card Interchange Fees Act of 2009, all provisions; H.R. 2695, Credit Card Fair Fee Act of 2009, all provisions; H.R. 3639, The Expedited Card Reform for Consumers Act of 2009, especially any effort to amend the bill with defacto price contorls on electronic payment card transactions. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2009-10-11T16:58:04-04:00
824916 WGL 30f8ceab-8da6-4f31-8ad6-edb149d4a630 Q3 WGL 40544 WASHINGTON GAS LIGHT COMPANY 2009 third_quarter FIN Protect the itnerstes of utility regarding proposals to regulate the trading of energy derivative instruments HR 2454, American Clean Energy and Security Act S 272, Derivatives Trading Itegrity Act of 2009 OTC Derivatives Markerts Act of 2009, House Financial Services Committee Draft HOUSE OF REPRESENTATIVES,SENATE   7500 0 0 2009-10-12T10:19:58-04:00
824956 THE CRANE GROUP INC cd076fca-b88e-454d-8fee-320ff48360b8 Q3 THE CRANE GROUP INC 11297 CHUBB CORPORATION 2009 third_quarter FIN HR 384 TARP Reform and Accountability Act of 2009 HR 387 TARP Accountability Act of 2009 S 235 Credit Card Holders Bill of Rights Act of 2009 HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2009-10-12T11:06:20-04:00
824989 K&L GATES, LLP 07e3092a-2169-486f-b597-d7c752f2d59e Q3 K&L GATES, LLP 32098 QUADRISERV 2009 third_quarter FIN Promotion of electronic market for securities loans. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2009-10-12T11:48:40-04:00
824991 OPPORTUNITY FINANCE NETWORK-FORMERLY NATIONAL COMMUNITY CAP 051c4837-0d57-4e73-9a4f-3f265b0bebc8 Q3 OPPORTUNITY FINANCE NETWORK-FORMERLY NATIONAL COMMUNITY CAP 290013 OPPORTUNITY FINANCE NETWORK-FORMERLY NATIONAL COMMUNITY CAP 2009 third_quarter FIN Bond Guarantee HOUSE OF REPRESENTATIVES,SENATE   25000 0 0 2009-10-12T11:51:35-04:00
825157 COLLETTI & ASSOCIATES 59d5535a-34d4-40fc-bf18-222451381baa Q3 COLLETTI & ASSOCIATES 400405909 ADVANCE AMERICA CASH ADVANCE CENTERS, INC. 2009 third_quarter FIN All provisions relating to consumer lending in the following bills: HR1608 & S500 - Protecting Consumers from Unreasonal Credit Rates Act of 2009 HR1214 - Payday Loan Reform Act of 2009 HR1640 & S582 - Interest Rate Reduction Act and HR 2309 -Consumer Credit and Debt Protection Act HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2009-10-12T15:38:54-04:00
825168 CMFG LIFE INSURANCE COMPANY f40d03f5-db6b-447c-9c44-7e3ad0bbef14 Q3 CMFG LIFE INSURANCE COMPANY 80510 CMFG LIFE INSURANCE COMPANY 2009 third_quarter FIN H.R. 3126 - Worked to exclude credit insurance from the authority of the proposed Consumer Financial Protection Agency (Act). HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of   660740 0 0 2009-10-12T15:45:40-04:00
825178 SUNDQUIST GROUP (FORMERLY KNOWN AS SUNDQUIST ANTHONY) 95a17772-eeac-4e64-8105-5de016707ff7 Q3 SUNDQUIST GROUP (FORMERLY KNOWN AS SUNDQUIST ANTHONY) 87574 VISA INC. 2009 third_quarter FIN Interchange Fees/Credit Card Legislation HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2009-10-12T15:52:41-04:00
825212 HUNTINGTON BANCSHARES INCORPORATED c99d566b-fedf-46a7-ae6d-163fe0f58ecb Q3 HUNTINGTON BANCSHARES INCORPORATED 77435 HUNTINGTON BANCSHARES INCORPORATED 2009 third_quarter FIN H.R. 3126, Consumer Financial Protection Act of 2009, all provisions; H.R. 1456, Consumer Overdraft Protection Fair Practices Act, all provisions; H.R. 2897, Bank Accountability and Risk Assesment Act of 2009, all provsions; H.R. 3610 Health Savings and Affordability Act of 2009, all provisions; S. 605/H.R. 302/H.R. 1406, Stock Market Recovery Act of 2009, all provisions; H.R. 3269, Corporate and Financial Institutions Compensation Fairness Act, all provisons; foreign tax repatriation issues (no bill) HOUSE OF REPRESENTATIVES,SENATE   51275 0 0 2009-10-12T17:10:13-04:00
825287 SQUIRE PATTON BOGGS c46bdca1-12a4-4697-9e5f-73558d0ccb8d Q3 SQUIRE PATTON BOGGS 30906 CANADA PENSION PLAN INVESTMENT BOARD 2009 third_quarter FIN Investments in United States by foreign pension plans and sovereign wealth funds, including tax policy issues. Federal Communications Commission (FCC)     0 0 2009-10-13T08:13:33-04:00
825304 SQUIRE PATTON BOGGS 33487309-37dd-4e30-860d-49e329fa15e4 Q3 SQUIRE PATTON BOGGS 30906 ESL INVESTMENTS 2009 third_quarter FIN Carried interest proposals and other legislation affecting hedge funds and private equity investment funds, and other related legislataive and regulatory matters. HOUSE OF REPRESENTATIVES 10000   0 0 2009-10-13T08:31:50-04:00
825320 SQUIRE PATTON BOGGS d037860c-0758-41dc-8f25-1d8d3c069a82 Q3 SQUIRE PATTON BOGGS 30906 LONDON STOCK EXCHANGE 2009 third_quarter FIN Issues related to regulatory convergence including mutual recognition and regulatory comparability. HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE     0 0 2009-10-13T08:41:06-04:00
825448 GRANT CONSULTING GROUP cf7c4f0d-4508-4d66-bc6e-7cc5b151a610 Q3 GRANT CONSULTING GROUP 89155 NATIONAL ASSOCIATION FOR VARIABLE ANNUITIES 2009 third_quarter FIN Legislation Impacting the Regulation of Variable Annuities HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2009-10-13T10:46:02-04:00
825451 POLICY DIRECTIONS INC. bf6c18c7-c76b-4c46-b729-74a85eb92276 Q3 POLICY DIRECTIONS INC. 31747 AMERICAN FEED INDUSTRY ASSOCIATION 2009 third_quarter FIN Issues related to regulation and oversight by the Commodity Futures Trading Commission. Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office 20000   0 0 2009-10-13T10:46:20-04:00
825518 AFLAC INCORPORATED bd9d0c97-045f-4f96-accb-53768062022b Q3 AFLAC INCORPORATED 385 AFLAC INCORPORATED 2009 third_quarter FIN - HR 302, "To require the Securities and Exchange Commission to reinstate the uptick rule on short sales of securities", regarding all provisions. - S 605, "A bill to require the Securities and Exchange Commission to reinstate the uptick rule and effectively regulate abusive short selling activities", regarding all provisions. - HR 1406, "To direct the Securities and Exchange Commission to reinstate the "uptick rule" on short sales of securities and to suspend the application of mark-to-market accounting principles" a/k/a "Stock Market Recovery Act of 2009", regarding all provisions. HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,U.S. Trade Representative (USTR)   1020000 0 0 2009-10-13T10:59:53-04:00
825621 HOULIHAN INTERNATIONAL LLC f1bdc9e0-89ca-4430-8661-f8b7ea89679a Q3 HOULIHAN INTERNATIONAL LLC 42672 WORLDBUSINESS CAPITAL INC 2009 third_quarter FIN Competitive access to U.S. government loan guarantee programs for Americas small and mid-sized businesses competing in global markets through the Overseas Private Investment Corporation (OPIC), the Export-Import Bank of the United States and the U.S. Department of Energy Loan Guarantee Program for renewable energy. Reauthorization of the Overseas Private Investment Corporation. Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Energy, Dept of,Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Intl Trade Administration (ITA),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA),U.S. Trade Representative (USTR),White House Office 20000   0 0 2009-10-13T11:38:39-04:00
825641 VENABLE LLP 8480df1e-0bf5-4b62-80e8-5feb6e96ce51 Q3 VENABLE LLP 39941 PRIVATE INVESTOR COALITION 2009 third_quarter FIN S.1276, Private Fund Transparency Act of 2009 Private Fund Investment Advisors Registraton Act of 2009 (draft in the House; no bill number) HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2009-10-13T11:46:56-04:00
825648 CAPITOL HILL CONSULTING GROUP e41ce89f-7938-4ba6-8a52-892f9cc0e57f Q3 CAPITOL HILL CONSULTING GROUP 72053 AMERICAN GAS ASSOCIATION 2009 third_quarter FIN Protect the interests of utilities regarding proposals to regulate the trading of energy derivative instruments; HR 2454 American Clean Energy and Security Act; S272 Derivatives Trading Integrity Act of 2009; Over-the-Counter Derivatives Markets Act of 2009; House Financial Sercies Committee Discussion Draft HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2009-10-13T11:50:01-04:00
825660 CAPITOL HILL CONSULTING GROUP 668a9e3a-d4b0-4c33-8b78-6335949697e3 3A CAPITOL HILL CONSULTING GROUP 72053 AMERICAN GAS ASSOCIATION 2009 third_quarter FIN Protect the interests of utilities regarding proposals to regulate the trading of energy derivative instruments; HR 2454 American Clean Energy and Security Act; S272 Derivatives Trading Integrity Act of 2009; Over-the-Counter Derivatives Markets Act of 2009; House Financial Sercies Committee Discussion Draft HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2009-10-13T11:51:06-04:00
825735 VALENTE & ASSOCIATES a8ad9086-83b1-4703-bb71-cec7f813333a Q3 VALENTE & ASSOCIATES 45983 FINANCIAL PLANNING COALITION 2009 third_quarter FIN Regulation of Financial Planners HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2009-10-13T12:53:43-04:00
825759 AMERICAN ACADEMY OF ACTUARIES ec426893-f050-4285-be6e-127932ccf835 Q3 AMERICAN ACADEMY OF ACTUARIES 1318 AMERICAN ACADEMY OF ACTUARIES 2009 third_quarter FIN Systemic risk; and causes of financial crisis. Congressional Budget Office (CBO),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Pension Benefit Guaranty Corporation (PBGC),SENATE   32890 0 0 2009-10-13T13:20:58-04:00
825779 THE VELASQUEZ GROUP, L.L.C. f75e663f-6fd7-4f7f-9dee-23b032d1fb06 3A THE VELASQUEZ GROUP, L.L.C. 53403 VISA INC 2009 third_quarter FIN H.R. 3126, Consumer Financial Protection Agency Act of 2009, especially any provision which might be interpreted to apply defacto price contorls on electronic payment card transactions; H.R. 2382, The Credit Card Interchange Fees Act of 2009, all provisions; H.R. 2695, Credit Card Fair Fee Act of 2009, all provisions; H.R. 3639, The Expedited Card Reform for Consumers Act of 2009, especially any effort to amend the bill with defacto price contorls on electronic payment card transactions. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2009-10-13T13:28:01-04:00
825811 AMERICAN FINANCIAL SERVICES ASSOCIATION a2289305-af41-48d2-ac5a-f094bf0432c6 Q3 AMERICAN FINANCIAL SERVICES ASSOCIATION 2354 AMERICAN FINANCIAL SERVICES ASSOCIATION 2009 third_quarter FIN Mortgage Lending, Credit Card Billing, Electronic Payments, TARP, TALF, Industrial Loan Companies, Bankruptcy Reform, Arbitration, Data Security, Consumer Financial Protection Agency Commerce, Dept of (DOC),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of   50000 0 0 2009-10-13T13:46:03-04:00
826074 FIERCE, ISAKOWITZ & BLALOCK 3d876b5e-4a09-4684-9228-5311e949af2e Q3 FIERCE, ISAKOWITZ & BLALOCK 44812 MAGAZINE PUBLISHERS OF AMERICA 2009 third_quarter FIN H.R.3126: Consumer Financial Protection Agency Act of 2009 HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2009-10-13T15:19:54-04:00

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 2170.086ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API