home / lobbying / lobbying_filings_raw

lobbying_filings_raw: bfb415db-fb8b-40fb-b9bb-49f76fb66ebc

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
bfb415db-fb8b-40fb-b9bb-49f76fb66ebc Q2 293038 EXPERIAN NORTH AMERICA 178420 EXPERIAN NORTH AMERICA 2012 second_quarter 2012-07-17T14:00:12.983000-04:00 310000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/bfb415db-fb8b-40fb-b9bb-49f76fb66ebc/", "filing_uuid": "bfb415db-fb8b-40fb-b9bb-49f76fb66ebc", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2012, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/bfb415db-fb8b-40fb-b9bb-49f76fb66ebc/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "310000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Anthony Hadley, Senior Vice President, Government Affairs and Public Policy", "dt_posted": "2012-07-17T14:00:12.983000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1401 K STREET, NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 293038, "url": "https://lda.senate.gov/api/v1/registrants/293038/", "house_registrant_id": 37336, "name": "EXPERIAN NORTH AMERICA", "description": null, "address_1": "555 12th Street NW, Suite 504", "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": "ELIZABETH OESTERLE", "contact_telephone": "+1 202-572-8158", "dt_updated": "2026-01-27T11:04:35.109012-05:00"}, "client": {"id": 178420, "url": "https://lda.senate.gov/api/v1/clients/178420/", "client_id": 12, "name": "EXPERIAN NORTH AMERICA", "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": "Legislative and regulatory issues related to financial literacy tools. Legislative issues pertaining to identity theft and social security numbers, including H.R. 220. Legislative issues pertaining to consumer reports, including H.R. 2086. Legislative and regulatory issues pertaining to the Wall Street Reform and Consumer Protection Act of 2010.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 93, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANTHONY", "nickname": null, "middle_name": "L", "last_name": "HADLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46647, "prefix": "mr", "prefix_display": "MR.", "first_name": "MURRAY", "nickname": null, "middle_name": "L", "last_name": "JOHNSTON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46003, "prefix": null, "prefix_display": null, "first_name": "JEREMY", "nickname": null, "middle_name": null, "last_name": "HANCOCK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "Legislation related to consumer privacy and consumer marketing, including S. 799, H.R. 1528 and S. 913; legislation related to data security and data breach notification, including H.R. 2577, S. 1207, S. 1151, S. 4535, S. 1408 and S. 1434; legislation related to cybersecurity, including S. 2105, S. 2151, and H.R. 3523.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 93, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANTHONY", "nickname": null, "middle_name": "L", "last_name": "HADLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46647, "prefix": "mr", "prefix_display": "MR.", "first_name": "MURRAY", "nickname": null, "middle_name": "L", "last_name": "JOHNSTON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46003, "prefix": null, "prefix_display": null, "first_name": "JEREMY", "nickname": null, "middle_name": null, "last_name": "HANCOCK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 37336 DC DC US US   0 0 2282779   alias 0.85

Links from other tables

  • 2 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 1.536ms