home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 3da3ed1a-aa38-4a5c-9d60-e699c1a9ecf7

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 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
3da3ed1a-aa38-4a5c-9d60-e699c1a9ecf7 Q2 16293 GSK (FKA GLAXOSMITHKLINE INC.) 121722 GSK (FKA GLAXOSMITHKLINE INC.) 2014 second_quarter 2014-07-18T11:57:16.510000-04:00 1020000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/3da3ed1a-aa38-4a5c-9d60-e699c1a9ecf7/", "filing_uuid": "3da3ed1a-aa38-4a5c-9d60-e699c1a9ecf7", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2014, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/3da3ed1a-aa38-4a5c-9d60-e699c1a9ecf7/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "1020000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "William J. Schuyler", "dt_posted": "2014-07-18T11:57:16.510000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United Kingdom", "registrant_address_1": "1050 K STREET, NW, #800", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 16293, "url": "https://lda.senate.gov/api/v1/registrants/16293/", "house_registrant_id": 31461, "name": "GSK (FKA GLAXOSMITHKLINE INC.)", "description": "PHARMACEUTICALS", "address_1": "1201 F STREET, NW, #480", "address_2": null, "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20004", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "BRENT FISK", "contact_telephone": "+1 703-501-8920", "dt_updated": "2026-01-30T14:26:09.773696-05:00"}, "client": {"id": 121722, "url": "https://lda.senate.gov/api/v1/clients/121722/", "client_id": 12, "name": "GSK (FKA GLAXOSMITHKLINE 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": "2011-04-01"}, "lobbying_activities": [{"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "H.R. 3830 - Bipartisan Congressional Trade Priorities Act of 2014; provisions related to trade agreeemnts\nS. 1900 - Bipartisan Congressional Trade Priorities Act of 2014; provisions related to trade agreeemnts\nNo bill # assigned - Trans-Pacific Strategic Economic Partnership Agreement (TPP);provisions related to intellectual property, market access and public health issues\nNo bill # assigned - Transatlantic Trade and Investment Partnership (TTIP); provisions related to market access intellectual property, regulatory harmonization and other issues\nNo bill # assigned - India innovation, IP and market access issues\nNo bill # assigned - International market access and intellectual property issues\nNo bill # assigned - Canada IP and market access issues\nNo bill # assigned - Turkey Market Access Issues", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 4722, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "J", "last_name": "SCHUYLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4546, "prefix": "ms", "prefix_display": "MS.", "first_name": "SARAH", "nickname": null, "middle_name": "J", "last_name": "WALSH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21720, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIMBERLY", "nickname": null, "middle_name": "A", "last_name": "WILLIAMS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57274, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "MCGOWAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 54482, "prefix": null, "prefix_display": null, "first_name": "STEPHEN", "nickname": null, "middle_name": null, "last_name": "SCANGO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44794, "prefix": null, "prefix_display": null, "first_name": "GARY", "nickname": null, "middle_name": null, "last_name": "HEIMBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 56710, "prefix": null, "prefix_display": null, "first_name": "SHIRA", "nickname": null, "middle_name": null, "last_name": "KILCOYNE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 56714, "prefix": null, "prefix_display": null, "first_name": "EDYTA", "nickname": null, "middle_name": null, "last_name": "WIESNER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R. 4438 - A bill to modify and make permanent the research and development (R&D) tax credit\nNo bill # assigned - Tax reform policy issues; provisions related to corporate tax reform and research and development tax credit", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 4722, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "J", "last_name": "SCHUYLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4546, "prefix": "ms", "prefix_display": "MS.", "first_name": "SARAH", "nickname": null, "middle_name": "J", "last_name": "WALSH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21720, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIMBERLY", "nickname": null, "middle_name": "A", "last_name": "WILLIAMS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57274, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "MCGOWAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 54482, "prefix": null, "prefix_display": null, "first_name": "STEPHEN", "nickname": null, "middle_name": null, "last_name": "SCANGO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44794, "prefix": null, "prefix_display": null, "first_name": "GARY", "nickname": null, "middle_name": null, "last_name": "HEIMBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "H.R. 2582 - PATENT Jobs Act; provisions related to patent user fees\nH.R. 2605 - Manufacturing Innovation in America Act of 2013; provisions related to patent tax boxes\nH.R. 2639 - Patent Litigation and Innovation Act; patent litigation proposals\nH.R. 2766 - STOP Act; provisions related to business method patents\nH.R. 3116 - MODDERN Cures Act of 2013; provisions related to exclusivity\nH.R. 3309 - Innovation Act; provisions related to patent litigation reform\nH.R. 3349 - Innovation Protection Act; provisions related to PTO fee diversion\nH.R. 3540 - Demand Letter Transparency Act; provisions related to patent demand letters\nH.R. 3709 - Protecting Consumer Access to Generic Drugsprovisions related to patent settlements\nH.R. 4287 - Independent Innovator and Repurposing Act; provisions related to patent term restoration\nS. 214 - The Preserve Access to Affordable Generics Act; provisions relating to patent settlements\nS. 504 - Fair and Immediate Release of Generic Drugs Act; provisions related to patent settlements\nS. 866 - Patent Quality Improvement Act of 2013; provisions related to business methods patents provisions\nS. 1013 - Patent Abuse Reduction Act of 2013; provisions related to patent litigation reform\nS. 1612 - Patent Litigation Integrity Act; Patent litigation provisions including bonding\nS. 1720 - Patent Transparency and Improvements Act\nS. 2049 - Transparency in Assertion of Patents Act; provisions related to patent demand letters\nS. 2150 - Independent Innovator and Repurposing Act; provisions related to patent term restoration\nS.2196 - Patent Fee Integrity Act; patent fee diversion prohibition\nNo bill # assigned - Biopharmaceutical innovation policy issues\nNo bill # assigned - Biologics data protection issues\nNo bill # assigned - Intellectual property issues; Additional data exclusivity request that was part of 21st Century Cures submission", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 4722, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "J", "last_name": "SCHUYLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4546, "prefix": "ms", "prefix_display": "MS.", "first_name": "SARAH", "nickname": null, "middle_name": "J", "last_name": "WALSH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21720, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIMBERLY", "nickname": null, "middle_name": "A", "last_name": "WILLIAMS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57274, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "MCGOWAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 54482, "prefix": null, "prefix_display": null, "first_name": "STEPHEN", "nickname": null, "middle_name": null, "last_name": "SCANGO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44794, "prefix": null, "prefix_display": null, "first_name": "GARY", "nickname": null, "middle_name": null, "last_name": "HEIMBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "H.R. 1074 - National Diabetes Clinical Care Commission Act \nH.R. 1248 - Family Health Care Flexibility Act; provisions relating to reimbursement of OTC drugs under flexible spending and health savings accounts \nH.R. 3204 - Drug Quality and Security Act; provisions relating to pharmacy compounding and supply chain\nH.R. 3742 - Antibiotic Development to Advance Patient Treatment Act; provisions related to antibiotics and drug approval\nH.R. 4260 - Ryan White Patient Equity and Choice Act; provisions related to ADAP\nH.R. 4847 - End Neglected Tropical Diseases Act\nS. 539 - National Diabetes Clinical Care Commission Act \nS. 610 - Family Health Care Flexibility Act; provisions relating to reimbursement of OTC drugs under flexible spending and health savings accounts \nS. 957 - Drug Supply Chain Security Act; provisions related to supply chain security\nS. 959 - Pharmaceutical Compounding Quality and Accountability Act; provisions related to pharmaceutical compounding\nS. 1165 - Access to Appropriate Immunizations for Veterans Act of 2013; provisions related to extending VA performance measure to include all federally recommended vaccine\nNo bill # assigned - Implementation issues relating to the Patient Protection and Affordable Care Act (PPACA) (Public Law 111-148), including Standards Related to Essential Health Benefits, Actuarial Value, and Accreditation rulemaking\nNo bill # assigned - FDA special medical use; issues related to limited population antibacterial drug approval pathway \nNo bill # assigned - FDA accelerated approval policy issues\nNo bill # assigned - Comparative effectiveness policy issues\nNo bill # assigned - Biopharmaceutical innovation policy issues\nNo bill # assigned - Pharmaceutical supply chain security issues\nNo bill # assigned - 340B policy issues\nNo bill # assigned - Implementation issues relating to the Physician Payment Sunshine Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 4722, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "J", "last_name": "SCHUYLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4546, "prefix": "ms", "prefix_display": "MS.", "first_name": "SARAH", "nickname": null, "middle_name": "J", "last_name": "WALSH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21720, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIMBERLY", "nickname": null, "middle_name": "A", "last_name": "WILLIAMS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57274, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "MCGOWAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 54482, "prefix": null, "prefix_display": null, "first_name": "STEPHEN", "nickname": null, "middle_name": null, "last_name": "SCANGO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44794, "prefix": null, "prefix_display": null, "first_name": "GARY", "nickname": null, "middle_name": null, "last_name": "HEIMBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "H.R. 351 - Protecting Seniors' Access to Medicare Act of 2013; provisions related to the Independent Payment Advisory Board\nH.R. 928 - Medicare Prescription Drug Savings and Choice Act of 2013; provisions related to Medicare Part D\nH.R. 1024 - Medication Therapy Empowerment Act of 2013; provisions related to Part D issues\nH.R. 1102 - Medicare Prescription Drug Price Negotiation Act of 2013; Provisions related to Part D issues and non-interference\nH.R. 1588 - Medicare Drug Savings Act of 2013; provisions related to Part D issues\nH.R. 2810 - Medicare Patient Access and Quality Improvement Act of 2013; provisions related to SGR reform\nH.R. 2827 - To amend title XVIII of the Social Security Act to allow for fair application of the exceptions process for drugs in tiers in formularies in prescription drug plans under Medicare part D; provisions related to Medicare Part D Drug Tier Formularies\nH.R. 3890 - Better Care, Lower Cost Act; provisions related to Part D, value-based insurance design, and chronic disease\nH.R 4160 - Keep the Promise to Seniors Act of 2014; provisions related to Part D\nH.R. 4187 - Developing an Innovative Strategy for Antimicrobial Resistant Microorganisms (DISARM) Act\nH.R. 4302 - Protecting Access to Medicare Act of 2014; provisions related to the biopharmaceutical industry\nS. 117 - Medicare Prescription Drug Price Negotiation Act of 2013; provisions related to Part D issues\nS. 351 - Protecting Seniors' Access to Medicare Act of 2013; provisions related to the Independent Payment Advisory Board\nS. 408 - Medicare Prescription Drug Savings and Choice Act of 2013; provisions related to Medicare Part D\nS. 557 - Medication Therapy Empowerment Act of 2013; provisions related to Part D issues\nS. 740 - Medicare Drug Savings Act of 2013; provisions related to Part D issues\nS. 1871 - SGR Repeal and Medicare Beneficiary Access Act of 2013; Provisions related to reforming Medicare physician payments\nS. 1932 - Better Care, Lower Cost Act; Provisions related to Part D, value-based insurance design, and chronic disease\nS. 2000 - SGR Repeal and Medicare Provider Payment Modernization Act of 2014; Provisions related to SGR reform\nS. 2110 - Medicare SGR Repeal and Beneficiary Access Improvement Act of 2014; Provisions related to SGR reform\nNo bill # assigned - Contract Year 2015 Policy and Technical Cganges to the Medicare Advantage and the Medicare Prescription Drug Benefits Programs; provisions related to Part D\nNo bill # assigned - Legislative proposals to increase co-payments for Part D beneficiaries receiving the low-income subsidy \nNo bill # assigned - Issues related to comprehensive medication management\nNo bill # assigned - Medicaid Program, Covered Outpatient Drugs rulemaking\nNo bill # assigned - Implementation Issues relating to the Physician Payment Sunshine Act\nNo bill # assigned - Vaccine access and coverage issues", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 4722, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "J", "last_name": "SCHUYLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4546, "prefix": "ms", "prefix_display": "MS.", "first_name": "SARAH", "nickname": null, "middle_name": "J", "last_name": "WALSH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21720, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIMBERLY", "nickname": null, "middle_name": "A", "last_name": "WILLIAMS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57274, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "MCGOWAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 54482, "prefix": null, "prefix_display": null, "first_name": "STEPHEN", "nickname": null, "middle_name": null, "last_name": "SCANGO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44794, "prefix": null, "prefix_display": null, "first_name": "GARY", "nickname": null, "middle_name": null, "last_name": "HEIMBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R. 4800 - Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations Act of 2015; provisions relating to FDA regulation and funding, sequestration, drug importation\nNo bill # assigned - Labor, Health and Human Services, Education and Related Agencies Appropriations Act of 2014; provisions related to ADAP, BARDA and Section 317", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 4722, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "J", "last_name": "SCHUYLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4546, "prefix": "ms", "prefix_display": "MS.", "first_name": "SARAH", "nickname": null, "middle_name": "J", "last_name": "WALSH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21720, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIMBERLY", "nickname": null, "middle_name": "A", "last_name": "WILLIAMS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57274, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "MCGOWAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44794, "prefix": null, "prefix_display": null, "first_name": "GARY", "nickname": null, "middle_name": null, "last_name": "HEIMBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 54482, "prefix": null, "prefix_display": null, "first_name": "STEPHEN", "nickname": null, "middle_name": null, "last_name": "SCANGO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TAR", "general_issue_code_display": "Tariff (miscellaneous tariff bills)", "description": "H.R. 6727 - U.S. Job Creation and Manufacturing Competitiveness Act of 2013; provisions related to the temporary duty suspension for preparations, such as tablets or chewing gum, intended to assist smokers to stop smoking (provided for in subheading\n2106.90.99)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 4722, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "J", "last_name": "SCHUYLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4546, "prefix": "ms", "prefix_display": "MS.", "first_name": "SARAH", "nickname": null, "middle_name": "J", "last_name": "WALSH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21720, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIMBERLY", "nickname": null, "middle_name": "A", "last_name": "WILLIAMS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57274, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "MCGOWAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 54482, "prefix": null, "prefix_display": null, "first_name": "STEPHEN", "nickname": null, "middle_name": null, "last_name": "SCANGO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44794, "prefix": null, "prefix_display": null, "first_name": "GARY", "nickname": null, "middle_name": null, "last_name": "HEIMBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 31461 DC DC US US   0 0 2242   normalized_name_dc_fallback 0.8

Links from other tables

  • 7 rows from filing_uuid in lobbying_activities
  • 8 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 1.665ms