lobbying_filings_raw: 405e3ca3-578e-41af-a989-27df651be691

Raw lobbying disclosure filings from the Senate Office of Public Records (SOPR). Each row is a single filing — registrations, quarterly reports, amendments, and terminations. Includes registrant and client names, reported income/expenses, filing period, and the full raw JSON from the API.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

This data as json

filing_uuid	filing_type	registrant_id	registrant_name	client_id	client_name	filing_year	filing_period	received_date	is_amendment	is_no_activity	is_termination	raw_json	registrant_state	registrant_country	registrant_house_id	client_state	client_ppb_state	client_country	client_ppb_country	client_general_description	client_government_entity	affiliated_org_count	client_entity_id	client_government_unit_id	client_match_method	client_match_confidence	income_amount	expense_amount
405e3ca3-578e-41af-a989-27df651be691	Q1	317914	SECURITIES INDUSTRY AND FINANCIAL MARKETS ASSOCIATION	186169	SECURITIES INDUSTRY AND FINANCIAL MARKETS ASSOCIATION	2008	first_quarter	2008-04-17T14:49:09-04:00	0	0	0	{"url": "https://lda.senate.gov/api/v1/filings/405e3ca3-578e-41af-a989-27df651be691/", "filing_uuid": "405e3ca3-578e-41af-a989-27df651be691", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2008, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/405e3ca3-578e-41af-a989-27df651be691/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "1360000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Scott DeFife, Senior Managing Director", "dt_posted": "2008-04-17T14:49:09-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1101 New York Avenue, NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 317914, "url": "https://lda.senate.gov/api/v1/registrants/317914/", "house_registrant_id": 39343, "name": "SECURITIES INDUSTRY AND FINANCIAL MARKETS ASSOCIATION", "description": null, "address_1": "1099 New York Ave. NW", "address_2": "6th Floor", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20001", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "KENNETH E. BENTSEN, JR.", "contact_telephone": "+1 202-962-7300", "dt_updated": "2026-01-23T14:55:24.405197-05:00"}, "client": {"id": 186169, "url": "https://lda.senate.gov/api/v1/clients/186169/", "client_id": 12, "name": "SECURITIES INDUSTRY AND FINANCIAL MARKETS ASSOCIATION", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-07-27"}, "lobbying_activities": [{"general_issue_code": "CDT", "general_issue_code_display": "Commodities (big ticket)", "description": "HR 4626 (CFTC Reauthorization Act); S. 577 (Oil and Gas Traders Oversight Act of 2007)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 15873, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "SCOTT", "last_name": "DEFIFE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 32941, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "HUNT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 25443, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "ANDERSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 27735, "prefix": null, "prefix_display": null, "first_name": "MARGARET", "nickname": null, "middle_name": null, "last_name": "SIMMONS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 192, "name": "Office of Thrift Supervision (OTS)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "HR 2761/HR 4299/S. 2285 (Terrorism Risk Insurance); PL. 110-160 (Terrorism Risk Insurance Revisions and Extension Act of 2007)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 15873, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "SCOTT", "last_name": "DEFIFE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 32941, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "HUNT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 25443, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "ANDERSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 27735, "prefix": null, "prefix_display": null, "first_name": "MARGARET", "nickname": null, "middle_name": null, "last_name": "SIMMONS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 192, "name": "Office of Thrift Supervision (OTS)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "S. 1145/HR 1908 (Patent Reform)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 15873, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "SCOTT", "last_name": "DEFIFE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 32941, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "HUNT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 27735, "prefix": null, "prefix_display": null, "first_name": "MARGARET", "nickname": null, "middle_name": null, "last_name": "SIMMONS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 192, "name": "Office of Thrift Supervision (OTS)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "Immigration/H1-B Visas, Visa facilitation", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 15873, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "SCOTT", "last_name": "DEFIFE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 32941, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "HUNT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 25443, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "ANDERSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 16463, "prefix": null, "prefix_display": null, "first_name": "JOSIE", "nickname": null, "middle_name": null, "last_name": "STORRS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 38303, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "STRONGIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 192, "name": "Office of Thrift Supervision (OTS)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "HR 2347/S. 1430 (International Sanctions)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 15873, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "SCOTT", "last_name": "DEFIFE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 32941, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "HUNT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 25443, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "ANDERSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 38303, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "STRONGIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 192, "name": "Office of Thrift Supervision (OTS)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "HR 2419 (Farm, Nutrition, and Bioenergy Act of 2007); Senate 2007 Farm Bill, The Food and Energy Security Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 15873, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "SCOTT", "last_name": "DEFIFE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 32941, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "HUNT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 25443, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "ANDERSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 27735, "prefix": null, "prefix_display": null, "first_name": "MARGARET", "nickname": null, "middle_name": null, "last_name": "SIMMONS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 192, "name": "Office of Thrift Supervision (OTS)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "BNK", "general_issue_code_display": "Bankruptcy", "description": "S. 2136 (Helping Families Save their Homes in Bankruptcy Act); S. 2133 (Homeowners Mortgage and Equity Savings Act); HR 3609 (Emergency Homeownership and Mortgage Equity Protection Act) (treatment of mortgages in bankruptcy)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 15873, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "SCOTT", "last_name": "DEFIFE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 32941, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "HUNT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 25443, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "ANDERSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 27735, "prefix": null, "prefix_display": null, "first_name": "MARGARET", "nickname": null, "middle_name": null, "last_name": "SIMMONS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 29438, "prefix": null, "prefix_display": null, "first_name": "JILL", "nickname": null, "middle_name": null, "last_name": "HERSHEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 192, "name": "Office of Thrift Supervision (OTS)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "HR 556 (Foreign Investment and National Security Act of 2007); Foreign Trade Agreements; HR 888 (Business Travel Facilitation Act of 2007); China financial services market access and currency issues; HR 3688 (United States-Peru Trade Promotion Agreement Implementation Act); S. 2271 (Sudan Accountability and Divestment Act of 2007); HR 594 (Prevent Unfair Manipulation of Prices Act of 2007); Strategic Economic Development; Transatlantic Economic Counsel", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 15873, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "SCOTT", "last_name": "DEFIFE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 32941, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "HUNT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 25443, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "ANDERSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 16463, "prefix": null, "prefix_display": null, "first_name": "JOSIE", "nickname": null, "middle_name": null, "last_name": "STORRS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 38303, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "STRONGIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 192, "name": "Office of Thrift Supervision (OTS)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "HR 1685 (Protect Information Relating to Consumers to Require Notice of Security Breaches); S. 1260 (Data Security Act); HR 958 (Data Accountability and Trust Act); S. 1202 (Personal Data Act of 2007); S. 239 (Notification of Risk to Personal Data Act of 2007); S. 495 (Personal Privacy Data and Security Act); S. 1178 (Identity Theft Prevention Act); HR 948 (Social Security Number Protection Act); HR 3915 (Mortgage Reform and Anti-Predatory Lending Act); S. 2452 (Homeownership Preservation Act); S. 1299 (Subprime Lending); S. 1208 (Social Security Account Number Protection Act); HR 3837 (Escrow, Appraisal and Mortgage Servicing Improvements); HR 3012 (Fair Mortgage Practices Act); S. 1926 (National Infrastructure Bank); HR 4178 (Emergency Mortgage Loan Modification Act); HR 5579 (Emergency Loan Modification Act of 2008); Servicer safe harbor for debt restructuring of residential mortgages; S. 2338/HR 1852 (Expanding American Homeownership Act) (FHA Reform); HR 1427/S. 1100 (GSE Reform); HR 3648 Mortgage Forgiveness Debt Relief Act of 2007 with Senate Amendment); S. 2517 (Mortgage revenue bonds); S. 1356/HR 698 (Industrial Bank Holding Company Act) (Industrial Loan Companies); S. 238 (Social Security Number Misuse Prevention Act); S. 2636 (Foreclosure Prevention Act of 2008); HR 5140 (Economic Stimulus/MRBs/FHA & GSE Loan Limits) (Economic Stimulus Act of 2008, with Senate Amendment); S. 2737 (Security Against Foreclosures and Education Act - \"Safe Act\"); S. 1691 (Social Security Number Online Protection Act); S. 2168 (Identity Theft Enforcement and Restitution Bill); HR 3046 (Social Security Number and Identity Theft Prevention Act); Federal Family Education Loan Program/Private Student Lending Secondary Market Issues", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 15873, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "SCOTT", "last_name": "DEFIFE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 32941, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "HUNT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 27735, "prefix": null, "prefix_display": null, "first_name": "MARGARET", "nickname": null, "middle_name": null, "last_name": "SIMMONS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 16463, "prefix": null, "prefix_display": null, "first_name": "JOSIE", "nickname": null, "middle_name": null, "last_name": "STORRS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 25443, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "ANDERSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 29438, "prefix": null, "prefix_display": null, "first_name": "JILL", "nickname": null, "middle_name": null, "last_name": "HERSHEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 29029, "prefix": null, "prefix_display": null, "first_name": "SHAHIRA", "nickname": null, "middle_name": null, "last_name": "KNIGHT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 192, "name": "Office of Thrift Supervision (OTS)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "S. 1677 (International Economic Coordination/Market Access); S. 577 (OTC Derivatives); Fee Based Brokerage Accounts; Soft Dollars; Client Commission Arrangements; 12B-1 Fees; Global Capital Markets Competitiveness; Hedge Funds, private pools of capital, asset management issues; S. 1782/HR 3010 (Arbitration Fairness); HR 3225 (Mutual Fund Fee Reform Act); Sovereign Wealth Funds; Auction Rate Securities Market; Mutual Recognition; Rule 15a-6; Municipal bonds", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 15873, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "SCOTT", "last_name": "DEFIFE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 32941, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "HUNT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 27735, "prefix": null, "prefix_display": null, "first_name": "MARGARET", "nickname": null, "middle_name": null, "last_name": "SIMMONS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 25443, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "ANDERSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 29438, "prefix": null, "prefix_display": null, "first_name": "JILL", "nickname": null, "middle_name": null, "last_name": "HERSHEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 16463, "prefix": null, "prefix_display": null, "first_name": "JOSIE", "nickname": null, "middle_name": null, "last_name": "STORRS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 38303, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "STRONGIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 192, "name": "Office of Thrift Supervision (OTS)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "S. 2242/HR 2419 (Settlement and deductibility) (Denial of deduction for certain settlement payments); HR 3996/HR3970/HR 6/HR 878/ S. 601 (Discussion draft released by Senate Finance Committee (adjusted basis reporting requirements for brokers); S. 2242/HR 2419/HR 3970/HR 4351 (Codification of economic substance doctrine); HR 1509; S. 902; permanence of active financing exception under Subpart F; Basis reporting by brokers; Issuer reporting of tax consequences of corporate actions under IRC sections 6043(c) and 6043 A; S. 636 relating to change in due date for providing payee statements to investors; De minimis exception to requirement to provide 1099 to investors; Subpart F exemption for active financing income; Low rate on dividends of individuals; Business tax reform; Valuation safe harbor under IRC section 475 mark-to-market requirements; Valuation of CDOs and related securities for purposes of section 475; IRS Notice 2006-97 concerning excess inclusion income of REIT taxable mortgage pools; Exchange traded notes/prepaid forwards (Notice 2008-2); Taxation of credit default swaps; taxation of notional principal contracts; Tax treatment of derivatives generally; Tax patent reporting; Foreign tax credit rules (including proposed \"technical taxpayer\" rule, noncompulsory payment rules, and treatment of UK manufactured overseas dividends tax); Allocation of income and deductions from global securities dealing operations; OECD project on attribution of profits to permanent establishments; Withholding tax consequences of self tenders and other distributions analyzed under IRC section 302; OECD Forum on Tax Administration's project on tax intermediaries; OECD and EU projects on provision of treaty withholding tax relief when investment is made through collective investment vehicles or other intermediate structures; Arbitration provisions in OECD Model Tax Convention, U.S. bilateral tax treaties, U.S. Model Treaty; International reform generally, including importance of interest expense allocation rule; IRS Form W-8 and instructions; Currency gains and losses of qualified business units under IRC section 987; Application of FIRPTA to debt exchangeable into REIT shares; Cross-border equity swaps; HR 3996/HR 4351/HR 3970/HR 3920 (Temporary Tax relief Act of 2007) (The AMT Relief Act of 2007) (delay in effective date of worldwide interest allocation election); HR 3996/S. 636/HR 3970/HR 6 (delay in filing deadline for 1099 statements; HR 4912 (Tax treatment of prepaid derivatives contracts) (prepaid derivative contracts and exchange traded notes); Basis Reporting; Active Financing Exception; Extension of capital gains and dividend rates; HR 2091/S. 1963 (Federal home loan bank bonds to tax exempt)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 15873, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "SCOTT", "last_name": "DEFIFE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 32941, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "HUNT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 29029, "prefix": null, "prefix_display": null, "first_name": "SHAHIRA", "nickname": null, "middle_name": null, "last_name": "KNIGHT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 17022, "prefix": null, "prefix_display": null, "first_name": "PATRICIA", "nickname": null, "middle_name": null, "last_name": "MCCLANAHAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 35193, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": null, "last_name": "VARLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 27735, "prefix": null, "prefix_display": null, "first_name": "MARGARET", "nickname": null, "middle_name": null, "last_name": "SIMMONS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 25443, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "ANDERSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 29438, "prefix": null, "prefix_display": null, "first_name": "JILL", "nickname": null, "middle_name": null, "last_name": "HERSHEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 192, "name": "Office of Thrift Supervision (OTS)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "RET", "general_issue_code_display": "Retirement", "description": "S. 819/HR 1419 (Public Good IRA Rollover Act of 2007); S. 1141/HR 2167 (Automatic IRA Act of 2007); S. 1010/HR 2205 (Retirement Security for Life Act of 2007); S. 2 (Fair Minimum Wage Act of 2007); S. 1725 (Restoring Pension Promises to Workers Act); S. 1288 (Women's Retirement Security Act of 2007); HR 2669 (College Cost Reduction Act of 2007); HR 2831 (Ledbetter Fair Pay Act of 2007); Pension technicals; Fee disclosure and transparency; Small business pension coverage; Pension Protection Act implementation; Wrap fee revenue ruling request; 529 plan regulatory project; PRM on Sec. 408(b)(2) of ERISA; RFI on disclosure to participants; Form 5500 revisions; HR 3923/S. 2199 (Offshore Deferred Compensation Act of 2007); S. 2473 (Deferred Contribution Fee Disclosure Act of 2007); HR 3185 (The 4019K) Fair Disclosure for Retirement Security Act of 2007)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 15873, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "SCOTT", "last_name": "DEFIFE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 32941, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "HUNT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 35193, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": null, "last_name": "VARLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 16463, "prefix": null, "prefix_display": null, "first_name": "JOSIE", "nickname": null, "middle_name": null, "last_name": "STORRS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 192, "name": "Office of Thrift Supervision (OTS)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "CPI", "general_issue_code_display": "Computer Industry", "description": "HR 964 (Securely Protect Yourself Against Cyber Trespass or SPY Act); HR 1525 (Internet Spyware (I-SPY) Prevention Act); S. 1625 (Counter Spy Act)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 15873, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "SCOTT", "last_name": "DEFIFE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 32941, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "HUNT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 16463, "prefix": null, "prefix_display": null, "first_name": "JOSIE", "nickname": null, "middle_name": null, "last_name": "STORRS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 192, "name": "Office of Thrift Supervision (OTS)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	DC	US	39343	DC	DC	US	US		0	0						1360000.0

Links from other tables

13 rows from filing_uuid in lobbying_activities
10 rows from filing_uuid in lobbying_lobbyists
0 rows from filing_uuid in lobbying_affiliated_orgs