home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 4cf2917a-e1a3-42cb-a46d-5c8a8b7f96e6

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
4cf2917a-e1a3-42cb-a46d-5c8a8b7f96e6 Q3 400493433 CAPITALEDGE STRATEGIES, LLC 191807 CITY OF DALLAS 2015 third_quarter 2015-10-19T14:57:36.060000-04:00 40000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/4cf2917a-e1a3-42cb-a46d-5c8a8b7f96e6/", "filing_uuid": "4cf2917a-e1a3-42cb-a46d-5c8a8b7f96e6", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2015, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/4cf2917a-e1a3-42cb-a46d-5c8a8b7f96e6/print/", "filing_document_content_type": "text/html", "income": "40000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Ralph Garboushian", "dt_posted": "2015-10-19T14:57:36.060000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1212 New York Avenue NW", "registrant_address_2": "Suite 250", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 400493433, "url": "https://lda.senate.gov/api/v1/registrants/400493433/", "house_registrant_id": null, "name": "CAPITALEDGE STRATEGIES, LLC", "description": "Federal relations for local governments and local government agencies", "address_1": "1212 New York Avenue NW", "address_2": "Suite 250", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20005", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "RALPH GARBOUSHIAN", "contact_telephone": "+1 202-842-5430", "dt_updated": "2026-01-19T12:49:29.558391-05:00"}, "client": {"id": 191807, "url": "https://lda.senate.gov/api/v1/clients/191807/", "client_id": 48, "name": "CITY OF DALLAS", "general_description": "General purpose local government", "client_government_entity": true, "client_self_select": false, "state": "TX", "state_display": "Texas", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2009-10-01"}, "lobbying_activities": [{"general_issue_code": "URB", "general_issue_code_display": "Urban Development/Municipalities", "description": "FY 2016 TranspHR 2577, ortation-HUD Appropriations, Funding for CDBG, HOME, Homeless Assistance Grants and Transportation Programs\nHR 2578, FY 2016 Commerce-Justice-Science Appropriations, Funding for local law enforcement assistance and economic development programs\nS 1619, FY 2016 Homeland Security Appropriations, Funding for Homeland Security grants programs\nHR 2028, FY 2016 Energy & Water Appropriations, Funding for local water resources programs\nS 698, Marketplace Fairness Act, Support\nHR 2775, Remote Transactions Parity Act, Support\nMaintain tax exemption for municipal bonds\nHR 22, DRIVE Act, Local highway and transit programs\nHR 3458, Connected Transportation Research and Innovation Act of 2015, Monitor\nMAP-21 re-authorization\nLocal surface transportation programs\nLocal housing and community development programs\nLocal health care programs\nTelecommunications - oppose preemption of local rights-of-way, tax and zoning authority\nLocal homeland security grant programs\nLocal water resources projects\nLocal water and sewer issues\nHigh-Speed Rail \nHomeland security funding for high-threat urban areas\nOppose preemption of local government authority\nTrinity River Corridor Project\nDallas Streetcar Project\nDallas Love Field Airport\nDallas Executive Airport\nSupport international trade expansion and the Dallas International Inland Port\nTravel and tourism/customs and entry issues\nLocal education issues\nConsumer finance issues", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 49665, "prefix": null, "prefix_display": null, "first_name": "RALPH", "nickname": null, "middle_name": null, "last_name": "GARBOUSHIAN", "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": []}

Links from other tables

  • 1 row from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 31.959ms