home / lobbying / lobbying_filings_raw

lobbying_filings_raw: cb601feb-e8ef-46bd-b6f4-9b435a74d46a

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
cb601feb-e8ef-46bd-b6f4-9b435a74d46a 3T 401103744 PHILIP S. SMITH & ASSOCIATES, INC. 200045 LAO VETERANS OF AMERICA INSTITUTE 2015 third_quarter 2015-10-11T16:26:16.617000-04:00 7500.0 0 0 1 {"url": "https://lda.senate.gov/api/v1/filings/cb601feb-e8ef-46bd-b6f4-9b435a74d46a/", "filing_uuid": "cb601feb-e8ef-46bd-b6f4-9b435a74d46a", "filing_type": "3T", "filing_type_display": "3rd Quarter - Termination", "filing_year": 2015, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/cb601feb-e8ef-46bd-b6f4-9b435a74d46a/print/", "filing_document_content_type": "text/html", "income": "7500.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Philip Smith, President", "dt_posted": "2015-10-11T16:26:16.617000-04:00", "termination_date": "2015-09-30", "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "2200 Wilson Blvd", "registrant_address_2": "No. 102-209", "registrant_different_address": false, "registrant_city": "Arlington", "registrant_state": "VA", "registrant_zip": "22201", "registrant": {"id": 401103744, "url": "https://lda.senate.gov/api/v1/registrants/401103744/", "house_registrant_id": null, "name": "PHILIP S. SMITH & ASSOCIATES, INC.", "description": "Government and public relations.", "address_1": "2200 Wilson Blvd", "address_2": "No. 102-209", "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": "PHILIP SMITH", "contact_telephone": "+1 202-543-1444", "dt_updated": "2022-04-06T16:07:49.245489-04:00"}, "client": {"id": 200045, "url": "https://lda.senate.gov/api/v1/clients/200045/", "client_id": 12, "name": "LAO VETERANS OF AMERICA INSTITUTE", "general_description": "Lao- and Hmong-American veterans organization of the Vietnam War in Laos- \"US Secret Army\"", "client_government_entity": false, "client_self_select": null, "state": "CA", "state_display": "California", "country": "US", "country_display": "United States of America", "ppb_state": "CA", "ppb_state_display": "California", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2015-06-16"}, "lobbying_activities": [{"general_issue_code": "INT", "general_issue_code_display": "Intelligence", "description": "In support of the introduction and passage of the Lao \"Hmong Veterans' Service Recognition Act\" in the U.S. House and Senate (H.R. 2327 & S. 1358). Requesting the support of the President and White House as well as the Department of Veterans Affairs, Central Intelligence Agency and U.S. Department of Defense.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 62222, "prefix": null, "prefix_display": null, "first_name": "PHILIP", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 30, "name": "Army, Dept of (Other)"}, {"id": 44, "name": "Central Intelligence Agency (CIA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "VET", "general_issue_code_display": "Veterans", "description": "In support of the introduction and passage of the Lao \"Hmong Veterans' Service Recognition Act\" in the U.S. House and Senate (H.R. 2327 & S. 1358). Requesting the support of the President and White House as well as the Department of Veterans Affairs, Central Intelligence Agency and U.S. Department of Defense. Educating Members of Congress and Administration officials about the historic contribution of Lao and Hmong veterans and their families during the U.S. \"Secret War\" in the Royal Kingdom of Laos during the Vietnam War and its aftermath.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 62222, "prefix": null, "prefix_display": null, "first_name": "PHILIP", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}], "government_entities": [{"id": 30, "name": "Army, Dept of (Other)"}, {"id": 44, "name": "Central Intelligence Agency (CIA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "In support of the introduction and passage of the Lao \"Hmong Veterans' Service Recognition Act\" in the U.S. House and Senate ((H.R. 2327 & S. 1358). Requesting the support of the President and White House as well as the Department of Veterans Affairs, Central Intelligence Agency and U.S. Department of Defense.", "foreign_entity_issues": "N/A", "lobbyists": [{"lobbyist": {"id": 62222, "prefix": null, "prefix_display": null, "first_name": "PHILIP", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 30, "name": "Army, Dept of (Other)"}, {"id": 44, "name": "Central Intelligence Agency (CIA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 3 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 13.751ms