home / lobbying / lobbying_filings_raw

lobbying_filings_raw: ad66957b-8a33-4e22-8b56-e4f4751333ce

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
ad66957b-8a33-4e22-8b56-e4f4751333ce Q2 33157 RETIRED ENLISTED ASSOCIATION 141514 RETIRED ENLISTED ASSOCIATION 2011 second_quarter 2011-07-15T14:31:10.187000-04:00 100000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/ad66957b-8a33-4e22-8b56-e4f4751333ce/", "filing_uuid": "ad66957b-8a33-4e22-8b56-e4f4751333ce", "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/ad66957b-8a33-4e22-8b56-e4f4751333ce/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "100000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Deirdre Parke Holleman, Executive Director", "dt_posted": "2011-07-15T14:31:10.187000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1001 N Fairfax Street Suite 102", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "ALEXANDRIA", "registrant_state": "VA", "registrant_zip": "22314", "registrant": {"id": 33157, "url": "https://lda.senate.gov/api/v1/registrants/33157/", "house_registrant_id": 30413, "name": "RETIRED ENLISTED ASSOCIATION", "description": "veterans and defense", "address_1": "12200 E. Briarwood Ave", "address_2": null, "address_3": null, "address_4": null, "city": "Centennial", "state": "CO", "state_display": "Colorado", "zip": "80112", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "WILLIAM MCCABE", "contact_telephone": "+1 303-507-1619", "dt_updated": "2022-05-02T11:53:00.576402-04:00"}, "client": {"id": 141514, "url": "https://lda.senate.gov/api/v1/clients/141514/", "client_id": 12, "name": "RETIRED ENLISTED ASSOCIATION", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "CO", "state_display": "Colorado", "country": "US", "country_display": "United States of America", "ppb_state": "CO", "ppb_state_display": "Colorado", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2019-12-23"}, "lobbying_activities": [{"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "urging the adoption of the Flag and Rememberence flag as an official symbol (HR546)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 44919, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "DEIRDRE", "nickname": null, "middle_name": "PARKE", "last_name": "HOLLEMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44923, "prefix": "mr", "prefix_display": "MR.", "first_name": "LARRY", "nickname": null, "middle_name": "DAVID", "last_name": "MADISON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"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)"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "lobbying against proposed enrollment fee increases and medical indexing for TRICARE benefits (including HR1092, HR1285, HR1540), on behalf of continuing present qualification for enrollment and retention in USFHP program (HR1540);lobbying on behalf of improvments in TRICARE Pharmacy plan, on behalf of improvements of TRICARE, in favor of embedding mental health providers in NG units (S325 HR948), in support of ending the remaining barriers to military retirees collecting their full military retired pay and VA service connected disability pay (including HR303, HR333, S344, HR186); improving benefits for members of the National Guard and Reserves and their families including authorizing TRICARE benefits at the same age as members are granted early retirement (HR179); improving retirement benefits ( S866 HR181) in favor of granting fair credit under deployment credit system \"Reserve Retirement Deployment Correction Act\" (HR1283, S866);\n\nin favor of ending the SBP/DIC offset (Survivors Benefit Plan/Dependency Indemnity Compensation) for survivng spouses of service members who died on active duty or as a result of a service connected disability (HR178,S260); improvements in the SSIA program, allowing families of deceased retirees to retain last full month of retired pay (HR493)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 44919, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "DEIRDRE", "nickname": null, "middle_name": "PARKE", "last_name": "HOLLEMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44923, "prefix": "mr", "prefix_display": "MR.", "first_name": "LARRY", "nickname": null, "middle_name": "DAVID", "last_name": "MADISON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"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)"}]}, {"general_issue_code": "VET", "general_issue_code_display": "Veterans", "description": "lobbying for further improvements in processing claims system, lobbying on behalf of programs to aid returning veterans in finding civilian jobs and starting new businesses (S951, HR895), in favor of granting veterans status to longevity retirees of the National Guard and Reserve (HR1025, S491); in favor of the VA paying mileage to trips to the Vet Centers for appointments (S696); improvements in education for survivors of service members who died on active duty or as a result of service connected disabilities; in favor of stopping disruption of military funerals \"Sancity of Eternal Rest for Veterans Act\" (HR948, S815); in support of improvments in Post 9/11 GI Bill education program including grandfathering present Yellow Ribbon program", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 44919, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "DEIRDRE", "nickname": null, "middle_name": "PARKE", "last_name": "HOLLEMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44923, "prefix": "mr", "prefix_display": "MR.", "first_name": "LARRY", "nickname": null, "middle_name": "DAVID", "last_name": "MADISON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"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)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "in support of granting tax credits to employers who hire recently returning/ discharging veterans (HR865, S146)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 44919, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "DEIRDRE", "nickname": null, "middle_name": "PARKE", "last_name": "HOLLEMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44923, "prefix": "mr", "prefix_display": "MR.", "first_name": "LARRY", "nickname": null, "middle_name": "DAVID", "last_name": "MADISON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"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)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} CO US 30413 CO CO US US   0 0        

Links from other tables

  • 4 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 63.826ms