home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 1150ed30-5c16-44ec-a8c3-30e50b719e07

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.

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 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
1150ed30-5c16-44ec-a8c3-30e50b719e07 Q1 5062 CML CONSULTING SERVICES INC. (FORMERLY L.A. SKIP BAFALIS) 104939 ALCALDE & FAY (CITY OF DEERFIELD BEACH) 2022 first_quarter 2022-04-14T14:31:26-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/1150ed30-5c16-44ec-a8c3-30e50b719e07/", "filing_uuid": "1150ed30-5c16-44ec-a8c3-30e50b719e07", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2022, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/1150ed30-5c16-44ec-a8c3-30e50b719e07/print/", "filing_document_content_type": "text/html", "income": "10000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "L.A. (SKIP) BAFALIS", "dt_posted": "2022-04-14T14:31:26-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "2111 Wilson Blvd.", "registrant_address_2": "8th Floor", "registrant_different_address": false, "registrant_city": "Arlington", "registrant_state": "VA", "registrant_zip": "22201", "registrant": {"id": 5062, "url": "https://lda.senate.gov/api/v1/registrants/5062/", "house_registrant_id": 33339, "name": "CML CONSULTING SERVICES INC. (FORMERLY L.A. SKIP BAFALIS)", "description": "Lobbying & Consulting", "address_1": "2111 Wilson Blvd.", "address_2": "8th Floor", "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": "L.A. (SKIP) BAFALIS", "contact_telephone": "+1 703-841-0626", "dt_updated": "2023-04-06T11:54:34.890127-04:00"}, "client": {"id": 104939, "url": "https://lda.senate.gov/api/v1/clients/104939/", "client_id": 101, "name": "ALCALDE & FAY (CITY OF DEERFIELD BEACH)", "general_description": null, "client_government_entity": true, "client_self_select": null, "state": null, "state_display": null, "country": "", "country_display": "* Undetermined", "ppb_state": null, "ppb_state_display": null, "ppb_country": "", "ppb_country_display": "* Undetermined", "effective_date": "2008-03-26"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Seeking federal funding in the Fiscal Year 2022 Transportation and Housing and Urban Development Appropriations Bills for road improvements and for the Community Development Block Grant program; and for FEC Railroad Fencing; Seeking federal funding in the Fiscal Year 2022 Commerce, Justice, and Science appropriations bill for COPS Grant program and for Security Technology Enhancements. Seeking federal funding in the Fiscal Year 2022 Interior and Environment Appropriations Bills for water and wastewater infrastructure; and for Water Plant Conversion and Well Rehabilitation. Seeking federal funding in the Fiscal Year Energy and Water Appropriations Bill for Beach Nourishment Project. Advocating for full implementation and flexible application of ARPA State and local COVID assistance, including support for S. 3011.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 10564, "prefix": "mr", "prefix_display": "MR.", "first_name": "LOUIS", "nickname": "SKIP", "middle_name": "A", "last_name": "BAFALIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Seeking to modify or delay the implementation of proposed Waters of the US rule.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 10564, "prefix": "mr", "prefix_display": "MR.", "first_name": "LOUIS", "nickname": "SKIP", "middle_name": "A", "last_name": "BAFALIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "Seeking support and adequate disaster funding and reimbursement for response to Hurricane Irma. Advocating for appeal of FEMA de-obligation decision. Advocacy on FEMA reimbursement of International Fishing Pier repair.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 10564, "prefix": "mr", "prefix_display": "MR.", "first_name": "LOUIS", "nickname": "SKIP", "middle_name": "A", "last_name": "BAFALIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Seeking to maintain tax-exemption for municipal bonds.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 10564, "prefix": "mr", "prefix_display": "MR.", "first_name": "LOUIS", "nickname": "SKIP", "middle_name": "A", "last_name": "BAFALIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Support for full implementation of Infrastructure Investment and Jobs Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 10564, "prefix": "mr", "prefix_display": "MR.", "first_name": "LOUIS", "nickname": "SKIP", "middle_name": "A", "last_name": "BAFALIS", "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": []} VA US 33339           1 0         10000.0  

Links from other tables

  • 5 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.389ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy