home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 1b908301-9065-4cd6-bdc3-e83d47bf23bb

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
1b908301-9065-4cd6-bdc3-e83d47bf23bb Q4 323114 THE KEELEN GROUP, LLC 187081 PROPERTY CASUALTY INSURERS ASSOCIATION OF AMERICA (PCI) 2009 fourth_quarter 2010-01-19T12:42:13.817000-05:00 40000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/1b908301-9065-4cd6-bdc3-e83d47bf23bb/", "filing_uuid": "1b908301-9065-4cd6-bdc3-e83d47bf23bb", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2009, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/1b908301-9065-4cd6-bdc3-e83d47bf23bb/print/", "filing_document_content_type": "text/html", "income": "40000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Aimee Nichols, Account Executive", "dt_posted": "2010-01-19T12:42:13.817000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1666 K Street, NW", "registrant_address_2": "Suite 1200", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20006", "registrant": {"id": 323114, "url": "https://lda.senate.gov/api/v1/registrants/323114/", "house_registrant_id": 39832, "name": "THE KEELEN GROUP, LLC", "description": "Government Consulting and Public Affairs Firm", "address_1": "PO Box 2016", "address_2": null, "address_3": null, "address_4": null, "city": "Arlington", "state": "VA", "state_display": "Virginia", "zip": "22202", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MATT KEELEN", "contact_telephone": "+1 202-506-2061", "dt_updated": "2022-04-06T16:06:18.344606-04:00"}, "client": {"id": 187081, "url": "https://lda.senate.gov/api/v1/clients/187081/", "client_id": 137, "name": "PROPERTY CASUALTY INSURERS ASSOCIATION OF AMERICA (PCI)", "general_description": "Representing companies in the property/casualty insurance market", "client_government_entity": false, "client_self_select": false, "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-02-12"}, "lobbying_activities": [{"general_issue_code": "AVI", "general_issue_code_display": "Aviation/Airlines/Airports", "description": "Monitoring and lobbying on the entire bill of the following:\nH.R.3059 / S.1368, the Access to Repair Parts Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43243, "prefix": "mr", "prefix_display": "MR.", "first_name": "MICHAEL", "nickname": null, "middle_name": "JOSEPH", "last_name": "FALENCKI", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Chief of Staff", "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": "Tracking issues of \nH.R.1409 / S. 560, Employee Free Choice Act of 2009", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43243, "prefix": "mr", "prefix_display": "MR.", "first_name": "MICHAEL", "nickname": null, "middle_name": "JOSEPH", "last_name": "FALENCKI", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Chief of Staff", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Monitoring issues related to climate change impact on the insurance industry:\nSEC. 426 of H.R.2454, American Clean Energy and Security Act of 2009", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43239, "prefix": "mr", "prefix_display": "MR.", "first_name": "MATTHEW", "nickname": null, "middle_name": "B", "last_name": "KEELEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43243, "prefix": "mr", "prefix_display": "MR.", "first_name": "MICHAEL", "nickname": null, "middle_name": "JOSEPH", "last_name": "FALENCKI", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Chief of Staff", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "Issues related to Systemic Risk and Financial Services Regulatory reform of the following:\nH.R. 1754 / S. 664, Financial System Stabilization and Reform Act of 2009\nS. 3, Homeowner Protection and Wall Street Accountability Act of 2009 \nH.R. 4173, Wall Street Reform and Consumer Protection Act of 2009 Entire bill of the following:\nH.R.1705 / S.566, Financial Product Safety Commission Act of 2009\nH.R. 3269, the Corporate and Financial Institution Compensation Fairness Act of 2009\nH.R. 2609, Insurance Information Act of 2009\nH.R. 3126, Consumer Financial Protection Agency Act of 2009\nH.R. 3795, Over-the-Counter Derivatives Markets Act of 2009", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43243, "prefix": "mr", "prefix_display": "MR.", "first_name": "MICHAEL", "nickname": null, "middle_name": "JOSEPH", "last_name": "FALENCKI", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Chief of Staff", "new": false}, {"lobbyist": {"id": 43239, "prefix": "mr", "prefix_display": "MR.", "first_name": "MATTHEW", "nickname": null, "middle_name": "B", "last_name": "KEELEN", "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": "HCR", "general_issue_code_display": "Health Issues", "description": "Monitoring issues related to healthcare; entire bills of the following: \nH.R. 3590, Patient Protection and Affordable Care Act\nH.R. 3962, Affordable Health Care for America Act, Indian Health Care Improvement Act Amendments of 2009\nWith specific attention to: Sec. 2531, Sec. 261, Sec. 262", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43243, "prefix": "mr", "prefix_display": "MR.", "first_name": "MICHAEL", "nickname": null, "middle_name": "JOSEPH", "last_name": "FALENCKI", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Chief of Staff", "new": false}, {"lobbyist": {"id": 43239, "prefix": "mr", "prefix_display": "MR.", "first_name": "MATTHEW", "nickname": null, "middle_name": "B", "last_name": "KEELEN", "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": "INS", "general_issue_code_display": "Insurance", "description": "Entire bill of the following:\nH.R.1880, National Insurance Consumer Protection Act\nH.R. 3596 / S.1681, the Health Insurance Industry Antitrust Enforcement Act of 2009\nH.R.3059 / S.1368, the Access to Repair Parts Act Monitoring issues related to the insurance industry; \nNational Flood Insurance Program (passage in H.R. 3326, Department of Defense Appropriations Act, 2010 / Division B Sec. 1005)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43239, "prefix": "mr", "prefix_display": "MR.", "first_name": "MATTHEW", "nickname": null, "middle_name": "B", "last_name": "KEELEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43243, "prefix": "mr", "prefix_display": "MR.", "first_name": "MICHAEL", "nickname": null, "middle_name": "JOSEPH", "last_name": "FALENCKI", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Chief of Staff", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "Monitoring and lobbying on the entire bill of the following:\nH.R.3059 / S.1368, the Access to Repair Parts Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43243, "prefix": "mr", "prefix_display": "MR.", "first_name": "MICHAEL", "nickname": null, "middle_name": "JOSEPH", "last_name": "FALENCKI", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Chief of Staff", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Monitoring energy related issues impacting the insurance industry:\nSEC. 426 of H.R.2454, American Clean Energy and Security Act of 2009", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43239, "prefix": "mr", "prefix_display": "MR.", "first_name": "MATTHEW", "nickname": null, "middle_name": "B", "last_name": "KEELEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43243, "prefix": "mr", "prefix_display": "MR.", "first_name": "MICHAEL", "nickname": null, "middle_name": "JOSEPH", "last_name": "FALENCKI", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Chief of Staff", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} VA US 39832         Representing companies in the property/casualty insurance market 0 0        

Links from other tables

  • 8 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 0.938ms