lobbying_filings_raw: 6fa2d4f1-7d0d-496e-bbae-e00bb7934830

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
6fa2d4f1-7d0d-496e-bbae-e00bb7934830	Q2	818	ALCALDE & FAY	101700	MARION COUNTY FLORIDA	2011	second_quarter	2011-07-18T10:44:16.917000-04:00	20000.0	0	0	0	{"url": "https://lda.senate.gov/api/v1/filings/6fa2d4f1-7d0d-496e-bbae-e00bb7934830/", "filing_uuid": "6fa2d4f1-7d0d-496e-bbae-e00bb7934830", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2011, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/6fa2d4f1-7d0d-496e-bbae-e00bb7934830/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": "2011-07-18T10:44:16.917000-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": 101700, "url": "https://lda.senate.gov/api/v1/clients/101700/", "client_id": 4415, "name": "MARION COUNTY FLORIDA", "general_description": null, "client_government_entity": true, "client_self_select": null, "state": "VA", "state_display": "Virginia", "country": "US", "country_display": "United States of America", "ppb_state": "VA", "ppb_state_display": "Virginia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-13"}, "lobbying_activities": [{"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "Seeking congressional support for the Countys pending grant application under the Department of Justice Office of Juvenile Justice and Delinquency Prevention Comprehensive Anti-Gang Strategies 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": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 108, "name": "Economic Development Administration"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 174, "name": "Federal Railroad Administration"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "RRR", "general_issue_code_display": "Railroads", "description": "Pursuing the development of a railroad spur.", "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": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 108, "name": "Economic Development Administration"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 174, "name": "Federal Railroad Administration"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ECN", "general_issue_code_display": "Economics/Economic Development", "description": "Seeking a planning grant for Silver Springs.", "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": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 108, "name": "Economic Development Administration"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 174, "name": "Federal Railroad Administration"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Seeking to change or delay the implementation of the Environmental Protection Agencys numeric nutrient criteria water quality rule for the State of Florida.", "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": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 108, "name": "Economic Development Administration"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 174, "name": "Federal Railroad Administration"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Seeking federal funding in the fiscal year 2011 and 2012 Transportation and Housing and Urban Development Appropriations Bills and from the Federal Highway Administration for the Transportation, Community and System Preservation and Interstate Maintenance program for Belleview Bypass (SE 92nd Loop) and SW 95th Street phase 3B with Interchange at I-75; Seeking federal funding in the fiscal year 2011 and 2012 Transportation and Housing and Urban Development Appropriations Bills for the Community Development Block Grant program; Seeking federal funding in the fiscal year 2011 and 2012 Interior and Environment Appropriations Bills for the State Revolving Fund and State and Tribal Assistance Grant programs for the Silver Springs pollution abatement project; Seeking an authorization in the Water Resources Development Act for the Silver Springs pollution abatement project and other County water infrastructure projects; Seeking federal funding in the fiscal year 2011 and 2012 Energy and Water Development Appropriations Bills and from the U.S. Army Corps of Engineers for a low commercial use navigation program for tree removal in the Ocklawaha River.", "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": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 108, "name": "Economic Development Administration"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 174, "name": "Federal Railroad Administration"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Pursuing funding for a thermal immersion storage project.", "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": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 108, "name": "Economic Development Administration"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 174, "name": "Federal Railroad Administration"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "NAT", "general_issue_code_display": "Natural Resources", "description": "Seeking the development of a trail from the Ocala National Forest to Silver Spring.", "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": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 108, "name": "Economic Development Administration"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 174, "name": "Federal Railroad Administration"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	VA	US	31771	VA	VA	US	US		1	0

Links from other tables

7 rows from filing_uuid in lobbying_activities
2 rows from filing_uuid in lobbying_lobbyists
0 rows from filing_uuid in lobbying_affiliated_orgs