home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 7d626f0a-e95f-4e9f-9712-b00fbd459cf0

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.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date amount_reported is_amendment is_no_activity is_termination raw_json
7d626f0a-e95f-4e9f-9712-b00fbd459cf0 MM 7543 THE BUSINESS ROUNDTABLE, INC. 110753 BUSINESS ROUNDTABLE INC 2007 mid_year 2007-08-13T16:15:18-04:00 4600000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/7d626f0a-e95f-4e9f-9712-b00fbd459cf0/", "filing_uuid": "7d626f0a-e95f-4e9f-9712-b00fbd459cf0", "filing_type": "MM", "filing_type_display": "Mid-Year Report", "filing_year": 2007, "filing_period": "mid_year", "filing_period_display": "Mid-Year (Jan 1 - Jun 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/7d626f0a-e95f-4e9f-9712-b00fbd459cf0/print/", "filing_document_content_type": "application/pdf", "income": null, "expenses": "4600000.00", "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2007-08-13T16:15:18-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": null, "registrant_address_2": null, "registrant_different_address": null, "registrant_city": null, "registrant_state": null, "registrant_zip": null, "registrant": {"id": 7543, "url": "https://lda.senate.gov/api/v1/registrants/7543/", "house_registrant_id": 31584, "name": "THE BUSINESS ROUNDTABLE, INC.", "description": null, "address_1": "1000 Maine Avenue, SW", "address_2": "Suite 500", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20024", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ELIZABETH DOUGHERTY", "contact_telephone": "+1 202-872-1260", "dt_updated": "2026-01-28T14:18:41.193739-05:00"}, "client": {"id": 110753, "url": "https://lda.senate.gov/api/v1/clients/110753/", "client_id": 12, "name": "BUSINESS ROUNDTABLE INC", "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-08-13"}, "lobbying_activities": [{"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "\r\nS7-10-06, SEC Proposal on Executive Compensation; all provisions\nSEC File Number 4-537, Roundtable Discussions Regarding Proxy Process; all provisions\n\r\nH.R. 1257, Shareholder Vote on Executive Compensation Act; all provisions\nS. 1181, Shareholder Vote on Executive Compensation Act; all provisions\nS7-03-05, SEC Proposal on Proxy Access; all provisions\nS7-10-05, SEC Proposal on E-Proxy; all provisions", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 4881, "prefix": null, "prefix_display": null, "first_name": "LARRY", "nickname": null, "middle_name": "D", "last_name": "BURTON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8087, "prefix": null, "prefix_display": null, "first_name": "MARIA", "nickname": null, "middle_name": null, "last_name": "GHAZAL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8998, "prefix": "ms", "prefix_display": "MS.", "first_name": "MARIAN", "nickname": null, "middle_name": "E", "last_name": "HOPKINS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 20875, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": "J", "last_name": "CASTELLANI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 21388, "prefix": null, "prefix_display": null, "first_name": "PATRICIA", "nickname": null, "middle_name": null, "last_name": "FREEMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 23918, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "HANDT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 29168, "prefix": "ms", "prefix_display": "MS.", "first_name": "BRIGITTE", "nickname": null, "middle_name": "SCHMIDT", "last_name": "GWYN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 32224, "prefix": null, "prefix_display": null, "first_name": "SUSAN", "nickname": null, "middle_name": null, "last_name": "TRAIMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 35620, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LEHNER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"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)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "\r\nH.R. 2138, Investment in America Act of 2007; provisions relating to research and development credit\nBill not yet assigned, Tax Bill; provisions relating to dividends and capital gains\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 4881, "prefix": null, "prefix_display": null, "first_name": "LARRY", "nickname": null, "middle_name": "D", "last_name": "BURTON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8087, "prefix": null, "prefix_display": null, "first_name": "MARIA", "nickname": null, "middle_name": null, "last_name": "GHAZAL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8998, "prefix": "ms", "prefix_display": "MS.", "first_name": "MARIAN", "nickname": null, "middle_name": "E", "last_name": "HOPKINS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 20875, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": "J", "last_name": "CASTELLANI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 21388, "prefix": null, "prefix_display": null, "first_name": "PATRICIA", "nickname": null, "middle_name": null, "last_name": "FREEMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 23918, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "HANDT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 29168, "prefix": "ms", "prefix_display": "MS.", "first_name": "BRIGITTE", "nickname": null, "middle_name": "SCHMIDT", "last_name": "GWYN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 32224, "prefix": null, "prefix_display": null, "first_name": "SUSAN", "nickname": null, "middle_name": null, "last_name": "TRAIMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 35620, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LEHNER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"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)"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "\r\nS. 334, Healthy Americans Act; all provisions\nS. 628, Critical Access to Health Information Technology Act of 2007; provisions relating to health information technology\nS. 1082, Prescription Drug User Fee Amendments of 2007; provisions relating to the importation of medicine into the United States and \u201cforced sale\u201d\nS. 1481, Fair and Reliable Medical Justice Act; all provisions\nS. 1544, Medicare Quality Enhancement Act of 2007; all provisions\nS. 1693, Wired for Health Care Quality Act; all provisions\nS. 1783, Ten Steps to Transform Health Care in America Act; all provisions\nBill not yet assigned, Health Care Bill; provisions relating to value-driven health care\nBill not yet assigned, Health Care Bill; provisions relating to the President\u2019s health care and tax proposal\nBill not yet assigned, Health Care Bill; provisions relating to State waivers to Employee Retirement Income Security Act preemption \nBill not yet assigned, Health Care Bill; provisions relating to regulatory pathway for follow-on biologics\n\r\nH.R. 1111, Kids Come First Act of 2007; all provisions\nH.R. 2055, Improving Children's Access to Health Care Act of 2007; all provisions\nH.R. 2497, Fair and Reliable Medical Justice Act; all provisions\nS. 95, Kids Come First Act of 2007; all provisions", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 4881, "prefix": null, "prefix_display": null, "first_name": "LARRY", "nickname": null, "middle_name": "D", "last_name": "BURTON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8087, "prefix": null, "prefix_display": null, "first_name": "MARIA", "nickname": null, "middle_name": null, "last_name": "GHAZAL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8998, "prefix": "ms", "prefix_display": "MS.", "first_name": "MARIAN", "nickname": null, "middle_name": "E", "last_name": "HOPKINS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 20875, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": "J", "last_name": "CASTELLANI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 21388, "prefix": null, "prefix_display": null, "first_name": "PATRICIA", "nickname": null, "middle_name": null, "last_name": "FREEMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 23918, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "HANDT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 29168, "prefix": "ms", "prefix_display": "MS.", "first_name": "BRIGITTE", "nickname": null, "middle_name": "SCHMIDT", "last_name": "GWYN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 32224, "prefix": null, "prefix_display": null, "first_name": "SUSAN", "nickname": null, "middle_name": null, "last_name": "TRAIMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 35620, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LEHNER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"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)"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "\r\nBill not yet assigned; Environmental Bill, provisions relating to environmental issues\nBill not yet assigned; Environmental Bill, provisions relating to global warming and climate change\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 4881, "prefix": null, "prefix_display": null, "first_name": "LARRY", "nickname": null, "middle_name": "D", "last_name": "BURTON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8087, "prefix": null, "prefix_display": null, "first_name": "MARIA", "nickname": null, "middle_name": null, "last_name": "GHAZAL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8998, "prefix": "ms", "prefix_display": "MS.", "first_name": "MARIAN", "nickname": null, "middle_name": "E", "last_name": "HOPKINS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 20875, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": "J", "last_name": "CASTELLANI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 21388, "prefix": null, "prefix_display": null, "first_name": "PATRICIA", "nickname": null, "middle_name": null, "last_name": "FREEMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 23918, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "HANDT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 29168, "prefix": "ms", "prefix_display": "MS.", "first_name": "BRIGITTE", "nickname": null, "middle_name": "SCHMIDT", "last_name": "GWYN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 32224, "prefix": null, "prefix_display": null, "first_name": "SUSAN", "nickname": null, "middle_name": null, "last_name": "TRAIMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 35620, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LEHNER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"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)"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "\r\nH.R. 6, CLEAN Energy Act of 2007; all provisions\nBill not yet assigned, Energy Bill; provisions relating to energy issues \nBill not yet assigned, Energy Bill; provisions relating to energy efficiency\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 4881, "prefix": null, "prefix_display": null, "first_name": "LARRY", "nickname": null, "middle_name": "D", "last_name": "BURTON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8087, "prefix": null, "prefix_display": null, "first_name": "MARIA", "nickname": null, "middle_name": null, "last_name": "GHAZAL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8998, "prefix": "ms", "prefix_display": "MS.", "first_name": "MARIAN", "nickname": null, "middle_name": "E", "last_name": "HOPKINS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 20875, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": "J", "last_name": "CASTELLANI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 21388, "prefix": null, "prefix_display": null, "first_name": "PATRICIA", "nickname": null, "middle_name": null, "last_name": "FREEMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 23918, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "HANDT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 29168, "prefix": "ms", "prefix_display": "MS.", "first_name": "BRIGITTE", "nickname": null, "middle_name": "SCHMIDT", "last_name": "GWYN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 32224, "prefix": null, "prefix_display": null, "first_name": "SUSAN", "nickname": null, "middle_name": null, "last_name": "TRAIMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 35620, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LEHNER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"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)"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "\r\nS. 1348, Comprehensive Immigration Reform Act of 2007; all provisions\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 4881, "prefix": null, "prefix_display": null, "first_name": "LARRY", "nickname": null, "middle_name": "D", "last_name": "BURTON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8087, "prefix": null, "prefix_display": null, "first_name": "MARIA", "nickname": null, "middle_name": null, "last_name": "GHAZAL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8998, "prefix": "ms", "prefix_display": "MS.", "first_name": "MARIAN", "nickname": null, "middle_name": "E", "last_name": "HOPKINS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 20875, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": "J", "last_name": "CASTELLANI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 21388, "prefix": null, "prefix_display": null, "first_name": "PATRICIA", "nickname": null, "middle_name": null, "last_name": "FREEMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 23918, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "HANDT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 29168, "prefix": "ms", "prefix_display": "MS.", "first_name": "BRIGITTE", "nickname": null, "middle_name": "SCHMIDT", "last_name": "GWYN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 32224, "prefix": null, "prefix_display": null, "first_name": "SUSAN", "nickname": null, "middle_name": null, "last_name": "TRAIMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 35620, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LEHNER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"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)"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "\r\nBill not yet assigned, World Trade Organization Doha Round; all provisions\nBill not yet assigned, United States-Colombia Free Trade Agreement; all provisions\nBill not yet assigned, United States-Korea Free Trade Agreement; all provisions\nBill not yet assigned, United States-Panama Free Trade Agreement; all provisions\nBill not yet assigned, United Stated-Peru Free Trade Agreement; all provisions\n\r\nH.R. 556, National Security Foreign Investment Reform and Strengthened Transparency Act of 2007; all provisions\nH.R. 1229, Nonmarket Economy Trade Remedy Act of 2007; all provisions\nS. 740, Invest USA Act of 2007; all provisions\nBill not yet assigned, Trade Promotion Authority; all provisions", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 4881, "prefix": null, "prefix_display": null, "first_name": "LARRY", "nickname": null, "middle_name": "D", "last_name": "BURTON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8087, "prefix": null, "prefix_display": null, "first_name": "MARIA", "nickname": null, "middle_name": null, "last_name": "GHAZAL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8998, "prefix": "ms", "prefix_display": "MS.", "first_name": "MARIAN", "nickname": null, "middle_name": "E", "last_name": "HOPKINS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 20875, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": "J", "last_name": "CASTELLANI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 21388, "prefix": null, "prefix_display": null, "first_name": "PATRICIA", "nickname": null, "middle_name": null, "last_name": "FREEMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 23918, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "HANDT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 29168, "prefix": "ms", "prefix_display": "MS.", "first_name": "BRIGITTE", "nickname": null, "middle_name": "SCHMIDT", "last_name": "GWYN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 32224, "prefix": null, "prefix_display": null, "first_name": "SUSAN", "nickname": null, "middle_name": null, "last_name": "TRAIMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 35620, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LEHNER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"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)"}]}, {"general_issue_code": "TOR", "general_issue_code_display": "Torts", "description": "\r\nS. 186, Attorney-Client Privilege Protection Act of 2007; all provisions\nS. 349, Small Business and Work Opportunity Act of 2007; provisions relating to deducting fines and similar penalties paid to the government due to breaking the law", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 4881, "prefix": null, "prefix_display": null, "first_name": "LARRY", "nickname": null, "middle_name": "D", "last_name": "BURTON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8087, "prefix": null, "prefix_display": null, "first_name": "MARIA", "nickname": null, "middle_name": null, "last_name": "GHAZAL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8998, "prefix": "ms", "prefix_display": "MS.", "first_name": "MARIAN", "nickname": null, "middle_name": "E", "last_name": "HOPKINS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 20875, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": "J", "last_name": "CASTELLANI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 21388, "prefix": null, "prefix_display": null, "first_name": "PATRICIA", "nickname": null, "middle_name": null, "last_name": "FREEMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 23918, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "HANDT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 29168, "prefix": "ms", "prefix_display": "MS.", "first_name": "BRIGITTE", "nickname": null, "middle_name": "SCHMIDT", "last_name": "GWYN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 32224, "prefix": null, "prefix_display": null, "first_name": "SUSAN", "nickname": null, "middle_name": null, "last_name": "TRAIMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 35620, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LEHNER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"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)"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "\r\nH.R. 1867, National Science Foundation Authorization Act of 2007; provisions relating to improving math and science education\nH.R. 2272, 21st Century Competitiveness Act of 2007; provisions relating to research in science, technology, engineering, and mathematics\nS. 761, America Creating Opportunities to Meaningfully Promote Excellence in Technology, Education, and Science Act; provisions relating to improving math and science education and basic research in the physical sciences at National Science Foundation, National Institute of Standards and Technology, and Department of Education Office of Science\nBill not yet assigned, No Child Left Behind Act Reauthorization; provisions relating to business priorities and principles\n\r\nH.R. 362, To Authorize Science Scholarships for Educating Mathematics and Science Teachers, and for Other Purposes; provisions relating to National Science Foundation programs to improve teaching of math and science\nH.R. 363, Sowing the Seeds Through Science and Engineering Research Act; provisions relating to National Science Foundation programs for graduate research in physical sciences", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 4881, "prefix": null, "prefix_display": null, "first_name": "LARRY", "nickname": null, "middle_name": "D", "last_name": "BURTON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8087, "prefix": null, "prefix_display": null, "first_name": "MARIA", "nickname": null, "middle_name": null, "last_name": "GHAZAL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8998, "prefix": "ms", "prefix_display": "MS.", "first_name": "MARIAN", "nickname": null, "middle_name": "E", "last_name": "HOPKINS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 20875, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": "J", "last_name": "CASTELLANI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 21388, "prefix": null, "prefix_display": null, "first_name": "PATRICIA", "nickname": null, "middle_name": null, "last_name": "FREEMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 23918, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "HANDT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 29168, "prefix": "ms", "prefix_display": "MS.", "first_name": "BRIGITTE", "nickname": null, "middle_name": "SCHMIDT", "last_name": "GWYN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 32224, "prefix": null, "prefix_display": null, "first_name": "SUSAN", "nickname": null, "middle_name": null, "last_name": "TRAIMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 35620, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LEHNER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"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)"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "\r\nH.R. 1684, Department of Homeland Security Authorization Act for Fiscal Year 2008; all provisions", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 4881, "prefix": null, "prefix_display": null, "first_name": "LARRY", "nickname": null, "middle_name": "D", "last_name": "BURTON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8087, "prefix": null, "prefix_display": null, "first_name": "MARIA", "nickname": null, "middle_name": null, "last_name": "GHAZAL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 8998, "prefix": "ms", "prefix_display": "MS.", "first_name": "MARIAN", "nickname": null, "middle_name": "E", "last_name": "HOPKINS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 20875, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": "J", "last_name": "CASTELLANI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 21388, "prefix": null, "prefix_display": null, "first_name": "PATRICIA", "nickname": null, "middle_name": null, "last_name": "FREEMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 23918, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "HANDT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 29168, "prefix": "ms", "prefix_display": "MS.", "first_name": "BRIGITTE", "nickname": null, "middle_name": "SCHMIDT", "last_name": "GWYN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 32224, "prefix": null, "prefix_display": null, "first_name": "SUSAN", "nickname": null, "middle_name": null, "last_name": "TRAIMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 35620, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LEHNER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"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)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 10 rows from filing_uuid in lobbying_activities
  • 9 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 7.965ms