home / lobbying / lobbying_filings_raw

lobbying_filings_raw: e7eb0abe-e7b6-4acf-a75f-950d29bd5460

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
e7eb0abe-e7b6-4acf-a75f-950d29bd5460 Q3 400493433 CAPITALEDGE STRATEGIES, LLC 191807 CITY OF DALLAS 2016 third_quarter 2016-10-19T17:35:26.313000-04:00 40000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/e7eb0abe-e7b6-4acf-a75f-950d29bd5460/", "filing_uuid": "e7eb0abe-e7b6-4acf-a75f-950d29bd5460", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2016, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/e7eb0abe-e7b6-4acf-a75f-950d29bd5460/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": "2016-10-19T17:35:26.313000-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": "HR 5394/S 2844, FY 2017 Transportation-HUD Appropriations, Funding for CDBG, HOME, Homeless Assistance Grants and Transportation Programs\nHR 5393/S 2837, FY 2017 Commerce-Justice-Science Appropriations, Funding for local law enforcement assistance and economic development programs\nFY 2017 Homeland Security Appropriations, Funding for Homeland Security grants programs\nFY 2017 Energy & Water Appropriations, Funding for local water resources programs\nS 698, Marketplace Fairness Act, Support\nSupplemental FY 2016 funding for Zika, Support\nS 2828/HR 5303, WRDA, Local water resources projects and water utility funding and issues\nHR 2775, Remote Transactions Parity Act, Support\n S 2123, Sentencing Reform & Corrections Act, Support\nHR 4833, Food Deserts Act of 2016, Support\nS 2555, MOBILE NOW Act, Oppose preemption of local zoning authority\nHR 636, FAA Reauthorization, Contract Tower Program and local airport issues, oppose preemption of local authority re: drones\nHR 2209, To require the appropriate Federal banking agencies to treat certain municipal obligations as level 2A liquid assets, and for other purposes, Support\nS 1501, American Job Creation and Investment Promotion Reform Act of 2015, Local economic development programs\nMaintain tax exemption for municipal bonds\nOppose permanent extension of the Internet Tax Freedom Act\nHR 3437, Protecting American Lives Act, Local law enforcement issues \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\nLewisville Lake Dam\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\nClean water and clean air issues\nCity grant applications", "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": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 157, "name": "Bureau of Justice Assistance"}, {"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}], "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 26.513ms