home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 4e20a605-e1bf-4356-9d85-cbaa53ea087c

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.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov 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
4e20a605-e1bf-4356-9d85-cbaa53ea087c Q1 818 ALCALDE & FAY 101758 CITY OF FT. MYERS, FL 2012 first_quarter 2012-04-20T13:26:30.913000-04:00 20000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/4e20a605-e1bf-4356-9d85-cbaa53ea087c/", "filing_uuid": "4e20a605-e1bf-4356-9d85-cbaa53ea087c", "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/4e20a605-e1bf-4356-9d85-cbaa53ea087c/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "James Davenport - Partner", "dt_posted": "2012-04-20T13:26:30.913000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "2111 WILSON BOULEVARD 8TH FLOOR", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "ARLINGTON", "registrant_state": "VA", "registrant_zip": "22201", "registrant": {"id": 818, "url": "https://lda.senate.gov/api/v1/registrants/818/", "house_registrant_id": 31771, "name": "ALCALDE & FAY", "description": "Government Relations and Lobbying", "address_1": "2111 WILSON BOULEVARD 8TH FLOOR", "address_2": null, "address_3": null, "address_4": null, "city": "ARLINGTON", "state": "VA", "state_display": "Virginia", "zip": "22201", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "LOIS MOORE", "contact_telephone": "+1 571-841-0626", "dt_updated": "2026-01-30T10:06:56.283870-05:00"}, "client": {"id": 101758, "url": "https://lda.senate.gov/api/v1/clients/101758/", "client_id": 1005103, "name": "CITY OF FT. MYERS, FL", "general_description": "City Government", "client_government_entity": true, "client_self_select": false, "state": "FL", "state_display": "Florida", "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-08-01"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Funding in the Fiscal Year 2013 Transportation and Housing and Urban Development Appropriations Bill for surface transportation programs that support Hanson Street Extension, Edwards Drive, and Clemente Park Community Center projects; Funding in the Fiscal Year 2013 Transportation and Housing and Urban Development Appropriations Bill for the Community Development Block Grant program; Funding in the Fiscal Year 2013 Interior and Environment Appropriations Bill for the State Revolving Fund program for wastewater infrastructure; Funding in the The Moving Ahead for Progress in the 21st Century (MAP-21) (S.1813) and The American Energy and Infrastructure Jobs Act (H.R. 7) for surface transportation programs; Water Resources Development Act authorization for the Citys wastewater infrastructure.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 5134, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "DAVENPORT", "suffix": null, "suffix_display": null}, "covered_position": "LC,LA/Congressman Gerald Solomon", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ART", "general_issue_code_display": "Arts/Entertainment", "description": "Seeking congressional support for the Citys grant proposal under the National Endowment for the Arts Our Town Grant Program.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 5134, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "DAVENPORT", "suffix": null, "suffix_display": null}, "covered_position": "LC,LA/Congressman Gerald Solomon", "new": false}, {"lobbyist": {"id": 23637, "prefix": null, "prefix_display": null, "first_name": "TRACE", "nickname": null, "middle_name": null, "last_name": "ROLLER", "suffix": null, "suffix_display": null}, "covered_position": "Intern/Congressman Pete Sessions", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 2 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 2.444ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API