home / lobbying / lobbying_filings_raw

lobbying_filings_raw: e82eaa57-b10a-4cea-a2cc-fbdb94cbf34a

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
e82eaa57-b10a-4cea-a2cc-fbdb94cbf34a Q4 304554 D&P CREATIVE STRATEGIES, LLC 181252 WAL-MART 701 8TH STREET NW #200 WASHINGTON DC 20001 2008 fourth_quarter 2009-01-15T07:07:38-05:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/e82eaa57-b10a-4cea-a2cc-fbdb94cbf34a/", "filing_uuid": "e82eaa57-b10a-4cea-a2cc-fbdb94cbf34a", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2008, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/e82eaa57-b10a-4cea-a2cc-fbdb94cbf34a/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Ingrid M. Duran Co-Founder & Principal", "dt_posted": "2009-01-15T07:07:38-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "3520 Maple Ct", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Falls Church", "registrant_state": "VA", "registrant_zip": "22041", "registrant": {"id": 304554, "url": "https://lda.senate.gov/api/v1/registrants/304554/", "house_registrant_id": 37994, "name": "D&P CREATIVE STRATEGIES, LLC", "description": "Consulting, Government Relations, Public Affairs Firm", "address_1": "6601 Rannoch Rd.", "address_2": null, "address_3": null, "address_4": null, "city": "Bethesda", "state": "MD", "state_display": "Maryland", "zip": "20817", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "INGRID M. DURAN", "contact_telephone": "+1 301-312-6298", "dt_updated": "2026-01-06T14:24:00.862046-05:00"}, "client": {"id": 181252, "url": "https://lda.senate.gov/api/v1/clients/181252/", "client_id": 12, "name": "WAL-MART 701 8TH STREET NW #200 WASHINGTON DC 20001", "general_description": "Retail", "client_government_entity": false, "client_self_select": false, "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": "2005-08-11"}, "lobbying_activities": [{"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "HR 4040, Consumer Product Safety Modernization Act of 2007, and S. 2045, CPSC Reform Act of 2007,\nPublic Law No. 110-314, The Consumer Product Safety Improvement Act of 2008. \nHR 5635, Digital Television Transition Consumer Relief Act, a bill to eliminate duties on Digital TV Converter Boxes.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 38213, "prefix": null, "prefix_display": null, "first_name": "INGRID", "nickname": null, "middle_name": "M", "last_name": "DURAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 14642, "prefix": null, "prefix_display": null, "first_name": "CATHERINE", "nickname": null, "middle_name": "M", "last_name": "PINO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "S. 2191, Americas Climate Security Act of 2007", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 38213, "prefix": null, "prefix_display": null, "first_name": "INGRID", "nickname": null, "middle_name": "M", "last_name": "DURAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 14642, "prefix": null, "prefix_display": null, "first_name": "CATHERINE", "nickname": null, "middle_name": "M", "last_name": "PINO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "H.R. 800 and S. 1041, Employee Free Choice Act of 2007, H.R. 1644 and S. 969, Re-Empowerment of Skilled and Professional Employees and Constructions Tradeworkers (RESPECT) Act, HR 6617 and S. 3334 Strengthening Communities Through English and Integration Act of 2008", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 38213, "prefix": null, "prefix_display": null, "first_name": "INGRID", "nickname": null, "middle_name": "M", "last_name": "DURAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 14642, "prefix": null, "prefix_display": null, "first_name": "CATHERINE", "nickname": null, "middle_name": "M", "last_name": "PINO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "H.R. 6491 Organized Retail Crime Act to combat, deter, and punish individuals and enterprises engaged in organized crime involving theft and fencing of retail merchandise.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 38213, "prefix": null, "prefix_display": null, "first_name": "INGRID", "nickname": null, "middle_name": "M", "last_name": "DURAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 14642, "prefix": null, "prefix_display": null, "first_name": "CATHERINE", "nickname": null, "middle_name": "M", "last_name": "PINO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "H.R. 5274, U.S.-Colombia Trade Promotion Agreement Implementation Act, H.R. 5635 - Digital Television Transition Consumer Relief Act, a bill to eliminate duties on Digital TV converter boxes, H.R. 4040, Consumer Product Safety Modernization Act of 2007, and S. 2045, CPSC Reform Act of 2007, Public Law No. 110-314, The Consumer Product Safety Improvement Act of 2008, H.R. 3934 & S. 2372, Affordable Footwear Act of 2007. H.R. 3610, to amend Food Drug and Cosmetic Act to place new requirements on imported food, drugs and devices; FDA restructuring, ban on closing FDA labs, user fees, country of origin labeling, and adding carbon monoxide to a list of additives, Introduction of Wal-Marts international labor practices and ethical sourcing program.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 38213, "prefix": null, "prefix_display": null, "first_name": "INGRID", "nickname": null, "middle_name": "M", "last_name": "DURAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 14642, "prefix": null, "prefix_display": null, "first_name": "CATHERINE", "nickname": null, "middle_name": "M", "last_name": "PINO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R. 3970, Tax Reduction & Reform Act of 2007, H.R. 6, Energy Independence & Security Act of 2007,\nH.R. 1591, the Small Business Work Opportunity & Tax Act of 2007, H.R.3220, New Direction for Energy Independence, National Security, and Consumer Protection Act Titles 4 & 9 H.R. 3221, Renewable Energy and Energy Conservation Tax Act of 2007 -- efficiency standards for appliances, lighting, and buildings S. 2886, Alternative Minimum Tax and Extenders Tax Relief Act of 2008, H.R. 6049, \nEnergy Improvement & Ext. Act of 2008 S. 3098, Alternative Min.Tax & Extenders Tax Relief Act of 2008.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 38213, "prefix": null, "prefix_display": null, "first_name": "INGRID", "nickname": null, "middle_name": "M", "last_name": "DURAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 14642, "prefix": null, "prefix_display": null, "first_name": "CATHERINE", "nickname": null, "middle_name": "M", "last_name": "PINO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "H.R. 3221, Renewable Energy and Energy Conservation Tax Act of 2007 efficiency standards for appliances, lighting, and buildings, H.R. 3220, New Direction for Energy Independence, National Security, and Consumer Protection Act, Titles 4 & 9, H.R. 6, Energy Independence and Security Act of 2007.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 38213, "prefix": null, "prefix_display": null, "first_name": "INGRID", "nickname": null, "middle_name": "M", "last_name": "DURAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 14642, "prefix": null, "prefix_display": null, "first_name": "CATHERINE", "nickname": null, "middle_name": "M", "last_name": "PINO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Educational outreach and information sharing on Companys health care benefits, open enrollment online tools, $4 generic prescriptions, health clinics and health information technology.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 38213, "prefix": null, "prefix_display": null, "first_name": "INGRID", "nickname": null, "middle_name": "M", "last_name": "DURAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 14642, "prefix": null, "prefix_display": null, "first_name": "CATHERINE", "nickname": null, "middle_name": "M", "last_name": "PINO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FOO", "general_issue_code_display": "Food Industry (safety, labeling, etc.)", "description": "H.R. 3610 to amend Food Drug and Cosmetic Act to improve food safety systems, H.R. 5904 to establish new procedures and requirements to improve food safety; applies to domestic and imported food products.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 38213, "prefix": null, "prefix_display": null, "first_name": "INGRID", "nickname": null, "middle_name": "M", "last_name": "DURAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 14642, "prefix": null, "prefix_display": null, "first_name": "CATHERINE", "nickname": null, "middle_name": "M", "last_name": "PINO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "PHA", "general_issue_code_display": "Pharmacy", "description": "H.R. 3700 & S. 1951, Legislation amending title XIX of the Society Security Act to ensure that individuals eligible for medical assistances under the Medicaid Program continue to have access to prescription drugs, and for other purposes Average Manufacturers Price, H.R. 5839, a bill to amend the Federal Food, Drug, and Cosmetic Act to improve the safety of drugs.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 38213, "prefix": null, "prefix_display": null, "first_name": "INGRID", "nickname": null, "middle_name": "M", "last_name": "DURAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 14642, "prefix": null, "prefix_display": null, "first_name": "CATHERINE", "nickname": null, "middle_name": "M", "last_name": "PINO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} MD US 37994 DC DC US US Retail 0 0        

Links from other tables

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