home / lobbying / lobbying_filings_raw

lobbying_filings_raw: e3516f4e-2bdb-4e2b-baca-6c27331b62e5

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
e3516f4e-2bdb-4e2b-baca-6c27331b62e5 Q4 400406912 ENGAGE, LLC 190245 CITY OF ST. LOUIS 2013 fourth_quarter 2014-01-16T19:25:36.313000-05:00 5000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/e3516f4e-2bdb-4e2b-baca-6c27331b62e5/", "filing_uuid": "e3516f4e-2bdb-4e2b-baca-6c27331b62e5", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2013, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/e3516f4e-2bdb-4e2b-baca-6c27331b62e5/print/", "filing_document_content_type": "text/html", "income": "5000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Paul Kalchbrenner, Partner", "dt_posted": "2014-01-16T19:25:36.313000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "525 2nd Street, NE", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20036", "registrant": {"id": 400406912, "url": "https://lda.senate.gov/api/v1/registrants/400406912/", "house_registrant_id": 40588, "name": "ENGAGE, LLC", "description": "Government Relations Consulting", "address_1": "3815 N. Albemarle St.", "address_2": null, "address_3": null, "address_4": null, "city": "Arlington", "state": "VA", "state_display": "Virginia", "zip": "22207", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "PAUL KALCHBRENNER", "contact_telephone": "+1 703-963-2475", "dt_updated": "2022-04-06T16:07:06.297014-04:00"}, "client": {"id": 190245, "url": "https://lda.senate.gov/api/v1/clients/190245/", "client_id": 24, "name": "CITY OF ST. LOUIS", "general_description": "Municipality", "client_government_entity": true, "client_self_select": false, "state": "MO", "state_display": "Missouri", "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-02-02"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Working in support of client program funding priorities in FY 2014 appropriation bills, tracking potential impact of proposed cuts on programs of importance to local government.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 47273, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "KALCHBRENNER", "suffix": null, "suffix_display": null}, "covered_position": "Senate LA", "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": "Working in support of protect tax exempt status of interest on municipal bonds to keep financing costs low for local governments; also working in support of allowing greater state and local sales tax collections on Internet transactions.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 47273, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "KALCHBRENNER", "suffix": null, "suffix_display": null}, "covered_position": "Senate LA", "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": "Tracking EPA rulemakings with potential impact to local governments and related economic development, also evaluating House and Senate Water Resources legislation and impacts to regional flood control and transportation infrastructure along Missouri and Mississippi rivers.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 47273, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "KALCHBRENNER", "suffix": null, "suffix_display": null}, "covered_position": "Senate LA", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "AVI", "general_issue_code_display": "Aviation/Airlines/Airports", "description": "Monitoring implementation of certain provisions of FAA reauthorization.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 47273, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "KALCHBRENNER", "suffix": null, "suffix_display": null}, "covered_position": "Senate LA", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} VA US 40588 MO   US US Municipality 1 0   19422 government_unit_name_state 0.9

Links from other tables

  • 4 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 1.158ms