lobbying_filings_raw: 932a3b2c-b9a0-432d-91c3-dff593a6b29e

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. Sortable columns (indexed): filing_type, client_name, filing_year, client_state, registrant_state, registrant_house_id, registrant_id. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date 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 income_amount expense_amount
932a3b2c-b9a0-432d-91c3-dff593a6b29e Q1 47108 CAPITOL SOLUTIONS 154421 CTIA- THE WIRELESS ASSOCIATION 2012 first_quarter 2012-04-13T13:00:06.050000-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/932a3b2c-b9a0-432d-91c3-dff593a6b29e/", "filing_uuid": "932a3b2c-b9a0-432d-91c3-dff593a6b29e", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2012, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/932a3b2c-b9a0-432d-91c3-dff593a6b29e/print/", "filing_document_content_type": "text/html", "income": "80000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "David F. Taylor Jr., Managing Partner", "dt_posted": "2012-04-13T13:00:06.050000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1455 Pennsylvania Ave NW", "registrant_address_2": "Suite 400", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 47108, "url": "https://lda.senate.gov/api/v1/registrants/47108/", "house_registrant_id": 34430, "name": "CAPITOL SOLUTIONS", "description": "Government Relations Consultants", "address_1": "1800 Diagonal Road", "address_2": "Suite 600", "address_3": null, "address_4": null, "city": "Alexandria", "state": "VA", "state_display": "Virginia", "zip": "22314", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "DAVID TAYLOR", "contact_telephone": "+1 703-647-7537", "dt_updated": "2022-04-06T16:08:08.464604-04:00"}, "client": {"id": 154421, "url": "https://lda.senate.gov/api/v1/clients/154421/", "client_id": 48, "name": "CTIA- THE WIRELESS ASSOCIATION", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "DC", "state_display": "District of Columbia", "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": "2007-07-23"}, "lobbying_activities": [{"general_issue_code": "TEC", "general_issue_code_display": "Telecommunications", "description": "American Jobs Act, spectrum-related provisions\nPotential commercial spectrum allocations and funding for federal spectrum planning and management activities. \nIssues related to FCC and NTIA funding and policies\nSpectrum-related recommendations in the FCC's National Broadband Plan (NBP) S. 911, the SPECTRUM Act; Provisions related to spectrum allocations, spectrum management, and scoring\nHouse Discussion Draft HR___ J.O.B.S. Act of 2011, Jumpstarting Opportunity Through Broadband Spectrum Act of 2011, provisions affecting spectrum allocations and auctions, spectrum planning and management, spectrum relocation process reforms, and spectrum sharing. \nP.L. 112-96, Middle Class Tax Relief and Job Creation Act of 2012, Title VI, Subtitle D (spectrum auction authority) and Subtitle G (federal spectrum relocation), inclusion of spectrum-related provisions related to incentive auctions, spectrum allocations, and relocation process reform\nSpectrum demand and valuation issues", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46265, "prefix": "mr", "prefix_display": "MR.", "first_name": "DAVID", "nickname": null, "middle_name": "F", "last_name": "TAYLOR", "suffix": "jr", "suffix_display": "JR"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55051, "prefix": "mr", "prefix_display": "MR.", "first_name": "GREGORY", "nickname": null, "middle_name": "R", "last_name": "WARING", "suffix": "jr", "suffix_display": "JR"}, "covered_position": null, "new": false}], "government_entities": [{"id": 8, "name": "Congressional Budget Office (CBO)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Spectrum-related recommendations in the FCC's National Broadband Plan (NBP)\nPotential commerical spectrum allocations, spectrum relocation process reform, funding for federal spectrum planning and management activities. \nIssues related to FCC and NTIA funding and policies. S. 911, the SPECTRUM Act; provisions related to spectrum allocation, management, and scoring issues\nP.L. 112-10, Budget Control Act, implementation issues\nAnalysis of potential future spectrum auction proceeds\nAmerican Jobs Act, Spectrum-related provisions\nHouse Discussion Draft Spectrum Legislation, provisions related to spectrum allocation, spectrum management, and scoring\nHouse Discussion Draft HR___ J.O.B.S. Act of 2011, Jumpstarting Opportunity Through Broadband Spectrum Act of 2011, provisions affecting spectrum allocations and auctions, spectrum planning and management, spectrum relocation process reforms, and spectrum sharing. \nPresident's FY13 Budget Request, provisions related to spectrum auction authority, allocation, relocation, and overall scoring\nP.L. 112-96, Middle Class Tax Relief and Job Creation Act of 2012, Title VI, Subtitle D (spectrum auction authority) and Subtitle G (federal spectrum relocation), inclusion of spectrum-related provisions related to incentive auctions, spectrum allocations, and relocation process reform", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46265, "prefix": "mr", "prefix_display": "MR.", "first_name": "DAVID", "nickname": null, "middle_name": "F", "last_name": "TAYLOR", "suffix": "jr", "suffix_display": "JR"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55051, "prefix": "mr", "prefix_display": "MR.", "first_name": "GREGORY", "nickname": null, "middle_name": "R", "last_name": "WARING", "suffix": "jr", "suffix_display": "JR"}, "covered_position": null, "new": false}], "government_entities": [{"id": 8, "name": "Congressional Budget Office (CBO)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} VA US 34430 DC   US US   0 0         80000.0  

Links from other tables