lobbying_filings_raw: 005a172e-ecb8-46ca-81a7-9293e233e4e2

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
005a172e-ecb8-46ca-81a7-9293e233e4e2 Q3 237 ADVANTA CORPORATION 100206 ADVANTA CORPORATION 2008 third_quarter 2008-10-16T10:18:30-04:00 200000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/005a172e-ecb8-46ca-81a7-9293e233e4e2/", "filing_uuid": "005a172e-ecb8-46ca-81a7-9293e233e4e2", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2008, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/005a172e-ecb8-46ca-81a7-9293e233e4e2/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "200000.00", "expenses_method": "c", "expenses_method_display": "Method C - Reporting amounts under section 162(e) of the Internal Revenue Code", "posted_by_name": "Frank M. Salinger, Vice President, Government Relations", "dt_posted": "2008-10-16T10:18:30-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "1 RIGHTER PARKWAY, 2ND FLOOR", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WILMINGTON", "registrant_state": "DE", "registrant_zip": "19803", "registrant": {"id": 237, "url": "https://lda.senate.gov/api/v1/registrants/237/", "house_registrant_id": 30007, "name": "ADVANTA CORPORATION", "description": null, "address_1": "1 RIGHTER PARKWAY, 2ND FLOOR", "address_2": null, "address_3": null, "address_4": null, "city": "WILMINGTON", "state": "DE", "state_display": "Delaware", "zip": "19803", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MR. FRANK M. SALINGER", "contact_telephone": "", "dt_updated": "2022-04-06T16:06:38.048079-04:00"}, "client": {"id": 100206, "url": "https://lda.senate.gov/api/v1/clients/100206/", "client_id": 12, "name": "ADVANTA CORPORATION", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DE", "state_display": "Delaware", "country": "US", "country_display": "United States of America", "ppb_state": "DE", "ppb_state_display": "Delaware", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-06"}, "lobbying_activities": [{"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "HR 698, S. 1356, Industrial Bank Holding Company Act--which deal with commercial ownership of banks. HR 873, Credit Card Payment Fees Act, HR 1461, Credit CARD Act, HR 5244, Credit Cardholder's Bill of Rights Act, S. 1395, Stop Unfair Practices Cards Act, S. 2753, Financial Consumer Protection Act, S. 3252 Credit CARD Act--which deal with credit practices and disclosures. HR 6248, Credit Card Interchange Fee Act, HR 6620, Gas Pump Fairness Act--which deal with interchange fee disclosures.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42620, "prefix": null, "prefix_display": null, "first_name": "FRANK", "nickname": null, "middle_name": null, "last_name": "SALINGER", "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": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "HR 5546 (and the accompanying House Report 110-913) , S. 3086, Credit Card Fair Fee Act--which deal with interchange fees and create antitrust exemptions for negotiated rates and for the regulation thereof. Oversight hearings on the antirust implications of interchange pricing.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42620, "prefix": null, "prefix_display": null, "first_name": "FRANK", "nickname": null, "middle_name": null, "last_name": "SALINGER", "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": []} DE US 30007 DE DE US US   0 0 2281303   alias 0.85

Links from other tables