home / lobbying / lobbying_filings_raw

lobbying_filings_raw: e9e4ac9e-b1f3-4bc9-85a0-67178ea33e4e

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
e9e4ac9e-b1f3-4bc9-85a0-67178ea33e4e 1A 26854 AMERICAN PROPERTY CASUALTY INSURANCE ASSOCIATION FKA PROPERTY CASUALTY INSURERS ASSOC. OF AMERICA 134234 AMERICAN PROPERTY CASUALTY INSURANCE ASSOCIATION 2008 first_quarter 2008-04-18T17:29:41-04:00 685437.45 1 0 0 {"url": "https://lda.senate.gov/api/v1/filings/e9e4ac9e-b1f3-4bc9-85a0-67178ea33e4e/", "filing_uuid": "e9e4ac9e-b1f3-4bc9-85a0-67178ea33e4e", "filing_type": "1A", "filing_type_display": "1st Quarter - Amendment", "filing_year": 2008, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/e9e4ac9e-b1f3-4bc9-85a0-67178ea33e4e/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "685437.45", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Benjamin J. McKay - Senior Vice President, Federal Government Relations", "dt_posted": "2008-04-18T17:29:41-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "444 N. CAPITOL STREET, NW, #801", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 26854, "url": "https://lda.senate.gov/api/v1/registrants/26854/", "house_registrant_id": 30265, "name": "AMERICAN PROPERTY CASUALTY INSURANCE ASSOCIATION FKA PROPERTY CASUALTY INSURERS ASSOC. OF AMERICA", "description": null, "address_1": "555 12th Street, NW", "address_2": "Suite 550", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20004", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "SAM WHITFIELD", "contact_telephone": "+1 202-639-0490", "dt_updated": "2026-01-30T18:27:22.074275-05:00"}, "client": {"id": 134234, "url": "https://lda.senate.gov/api/v1/clients/134234/", "client_id": 12, "name": "AMERICAN PROPERTY CASUALTY INSURANCE ASSOCIATION", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-09"}, "lobbying_activities": [{"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "H.R. 1081, S. 618, S. 846", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 20432, "prefix": null, "prefix_display": null, "first_name": "BENJAMIN", "nickname": null, "middle_name": null, "last_name": "MCKAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41457, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LITJEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 17945, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "KANGAS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 20930, "prefix": null, "prefix_display": null, "first_name": "KATE", "nickname": null, "middle_name": null, "last_name": "PRIBLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39405, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "HAIR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 5, "name": "Government Accountability Office (GAO)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "TOR", "general_issue_code_display": "Torts", "description": "H.R. 2183, H.R. 4040, S. 1323, S. 2041, S 2449, S. 2663", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 20432, "prefix": null, "prefix_display": null, "first_name": "BENJAMIN", "nickname": null, "middle_name": null, "last_name": "MCKAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41457, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LITJEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 17945, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "KANGAS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 20930, "prefix": null, "prefix_display": null, "first_name": "KATE", "nickname": null, "middle_name": null, "last_name": "PRIBLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39405, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "HAIR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 5, "name": "Government Accountability Office (GAO)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "AUT", "general_issue_code_display": "Automotive Industry", "description": "H.R. 1015, H.R. 1029, H.R. 1216, H.R. 2811, S. 545, S. 694", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 20432, "prefix": null, "prefix_display": null, "first_name": "BENJAMIN", "nickname": null, "middle_name": null, "last_name": "MCKAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41457, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LITJEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 17945, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "KANGAS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 20930, "prefix": null, "prefix_display": null, "first_name": "KATE", "nickname": null, "middle_name": null, "last_name": "PRIBLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39405, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "HAIR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 5, "name": "Government Accountability Office (GAO)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "DIS", "general_issue_code_display": "Disaster Planning/Emergencies", "description": "H.R. 164, H.R. 537, H.R. 846, H.R. 913, H.R. 1212, H.R. 1787, H.R. 1832, H.R. 2407, H.R. 3355, S. 292, S. 538, S. 690, S. 926, S. 927, S. 928, S. 929, S. 930, S. 931", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 20432, "prefix": null, "prefix_display": null, "first_name": "BENJAMIN", "nickname": null, "middle_name": null, "last_name": "MCKAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41457, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LITJEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 17945, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "KANGAS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 20930, "prefix": null, "prefix_display": null, "first_name": "KATE", "nickname": null, "middle_name": null, "last_name": "PRIBLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39405, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "HAIR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 5, "name": "Government Accountability Office (GAO)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "H.R. 1908, S. 694, H.R. 5638", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 20432, "prefix": null, "prefix_display": null, "first_name": "BENJAMIN", "nickname": null, "middle_name": null, "last_name": "MCKAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41457, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LITJEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 17945, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "KANGAS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 20930, "prefix": null, "prefix_display": null, "first_name": "KATE", "nickname": null, "middle_name": null, "last_name": "PRIBLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39405, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "HAIR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 5, "name": "Government Accountability Office (GAO)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "H.R. 220, H.R. 336, H.R. 958, H.R. 964, H.R. 1685, H.R. 2124, S. 1178, S. 1202, S. 1260, S. 1625", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 20432, "prefix": null, "prefix_display": null, "first_name": "BENJAMIN", "nickname": null, "middle_name": null, "last_name": "MCKAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41457, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LITJEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 17945, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "KANGAS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 20930, "prefix": null, "prefix_display": null, "first_name": "KATE", "nickname": null, "middle_name": null, "last_name": "PRIBLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39405, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "HAIR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39507, "prefix": "mr", "prefix_display": "MR.", "first_name": "DONALD", "nickname": null, "middle_name": "LEE", "last_name": "GRIFFIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 5, "name": "Government Accountability Office (GAO)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "H.R. 5633", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 20432, "prefix": null, "prefix_display": null, "first_name": "BENJAMIN", "nickname": null, "middle_name": null, "last_name": "MCKAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41457, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LITJEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 17945, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "KANGAS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 20930, "prefix": null, "prefix_display": null, "first_name": "KATE", "nickname": null, "middle_name": null, "last_name": "PRIBLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39405, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "HAIR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 5, "name": "Government Accountability Office (GAO)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "H.R. 91, H.R. 330 H.R. 920, H.R. 921, H.R. 922, H.R. 957, H.R. 1049, H.R. 1065, H.R. 1682, H.R. 2549, H.R. 2761, H.R. 3121, H.R. 3200, H.R. 3926, H.R. 3959, H.R. 4050, H.R. 4299, H.R. 4461, H.R. 4721, H.R. 5611, S. 40S. 1061, S. 1890, S. 1938, S. 2029, S. 2151, S. 2251, S. 2284, S. 2285, S. 2458, S. 2499, S 2621", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 20432, "prefix": null, "prefix_display": null, "first_name": "BENJAMIN", "nickname": null, "middle_name": null, "last_name": "MCKAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41457, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "LITJEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 17945, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "KANGAS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 20930, "prefix": null, "prefix_display": null, "first_name": "KATE", "nickname": null, "middle_name": null, "last_name": "PRIBLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39405, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "HAIR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 5, "name": "Government Accountability Office (GAO)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": [{"name": "NATIONAL INDEMNITY COPMANY", "url": null, "address_1": "3024 Harney Street", "address_2": null, "address_3": null, "address_4": null, "city": "Omaha", "state": "NE", "state_display": "Nebraska", "zip": "68131", "country": "US", "country_display": "United States of America", "ppb_city": "Omaha", "ppb_state": "NE", "ppb_state_display": "Nebraska", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "NAT. SECURITY FIRE AND CASUALTY CO.", "url": null, "address_1": "661 East Davis Street", "address_2": null, "address_3": null, "address_4": null, "city": "Elba", "state": "AL", "state_display": "Alabama", "zip": "36323", "country": "US", "country_display": "United States of America", "ppb_city": "Elba", "ppb_state": "AL", "ppb_state_display": "Alabama", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "NATIONAL TRUST INSURANCE COMPANY", "url": null, "address_1": "6300 University Parkway", "address_2": null, "address_3": null, "address_4": null, "city": "Sarasota", "state": "FL", "state_display": "Florida", "zip": "34240", "country": "US", "country_display": "United States of America", "ppb_city": "Sarasot", "ppb_state": "FL", "ppb_state_display": "Florida", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "NAVIGATORS INSURANCE COMPANY", "url": null, "address_1": "Reckson Executive Park, 6 International Dr, Suite 100", "address_2": null, "address_3": null, "address_4": null, "city": "Rye Brook", "state": "NY", "state_display": "New York", "zip": "10573", "country": "US", "country_display": "United States of America", "ppb_city": "Rye Brook", "ppb_state": "NY", "ppb_state_display": "New York", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "NEW JERSEY MANUFACTURERS INS. CO.", "url": null, "address_1": "301 Sullivan Way", "address_2": null, "address_3": null, "address_4": null, "city": "West Trenton", "state": "NJ", "state_display": "New Jersey", "zip": "08628", "country": "US", "country_display": "United States of America", "ppb_city": "West Trenton", "ppb_state": "NJ", "ppb_state_display": "New Jersey", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "NEW LONDON COUNTY MUTUAL INS. CO.", "url": null, "address_1": "101 High Street", "address_2": null, "address_3": null, "address_4": null, "city": "Norwich", "state": "CT", "state_display": "Connecticut", "zip": "06360", "country": "US", "country_display": "United States of America", "ppb_city": "Norwich", "ppb_state": "CT", "ppb_state_display": "Connecticut", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "NGM INSURANCE COMPANY", "url": null, "address_1": "4601 Touchton Road East, Suite 3400", "address_2": null, "address_3": null, "address_4": null, "city": "Jacksonville", "state": "FL", "state_display": "Florida", "zip": "32246", "country": "US", "country_display": "United States of America", "ppb_city": "Jacksonville", "ppb_state": "FL", "ppb_state_display": "Florida", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "NC FARM BUREAU MUTUAL INS. CO.", "url": null, "address_1": "5301 Glenwood Avenue", "address_2": null, "address_3": null, "address_4": null, "city": "Raliegh", "state": "NC", "state_display": "North Carolina", "zip": "27612", "country": "US", "country_display": "United States of America", "ppb_city": "Raliegh", "ppb_state": "NC", "ppb_state_display": "North Carolina", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "NORTH POINTE INSURANCE COMPANY", "url": null, "address_1": "28819 Franklin Road, Suite 300", "address_2": null, "address_3": null, "address_4": null, "city": "Southfield", "state": "MI", "state_display": "Michigan", "zip": "48034", "country": "US", "country_display": "United States of America", "ppb_city": "Southfield", "ppb_state": "MI", "ppb_state_display": "Michigan", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "NOVA CASUALTY COMPANY", "url": null, "address_1": "726 Exchange Street, Suite 1020", "address_2": null, "address_3": null, "address_4": null, "city": "Buffalo", "state": "NY", "state_display": "New York", "zip": "14210", "country": "US", "country_display": "United States of America", "ppb_city": "Buffalo", "ppb_state": "NY", "ppb_state_display": "New York", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "OCCIDENTAL FIRE AND CASUALTY OF NC", "url": null, "address_1": "702 Oberlin Road, Suite 300", "address_2": null, "address_3": null, "address_4": null, "city": "Raleigh", "state": "NC", "state_display": "North Carolina", "zip": "27605", "country": "US", "country_display": "United States of America", "ppb_city": "Raliegh", "ppb_state": "NC", "ppb_state_display": "North Carolina", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "OKLAHOMA FARM BUREAU MUTAL INS. CO", "url": null, "address_1": "2501 North Stiles Avenue", "address_2": null, "address_3": null, "address_4": null, "city": "Oklahoma City", "state": "OK", "state_display": "Oklahoma", "zip": "73105", "country": "US", "country_display": "United States of America", "ppb_city": "Oklahoma City", "ppb_state": "OK", "ppb_state_display": "Oklahoma", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "OREGON MUTUAL INSURANCE COMPANY", "url": null, "address_1": "400 NE Baker Street", "address_2": null, "address_3": null, "address_4": null, "city": "McMinnville", "state": "OR", "state_display": "Oregon", "zip": "97128", "country": "US", "country_display": "United States of America", "ppb_city": "McMinnville", "ppb_state": "OR", "ppb_state_display": "Oregon", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PACIFIC SPECIALTY INSURANCE COMPANY", "url": null, "address_1": "3601 Haven Avenue", "address_2": null, "address_3": null, "address_4": null, "city": "Menlo Park", "state": "CA", "state_display": "California", "zip": "94025", "country": "US", "country_display": "United States of America", "ppb_city": "Menlo Park", "ppb_state": "CA", "ppb_state_display": "California", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PARTNER REINSURANCE CO. OF THE U.S.", "url": null, "address_1": "One Greenwich Plaza", "address_2": null, "address_3": null, "address_4": null, "city": "Greenwich", "state": "CT", "state_display": "Connecticut", "zip": "06830", "country": "US", "country_display": "United States of America", "ppb_city": "Greenwich", "ppb_state": "CT", "ppb_state_display": "Connecticut", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PENN MILLERS INSURANCE COMPANY", "url": null, "address_1": "72 North Franklin Street", "address_2": null, "address_3": null, "address_4": null, "city": "Wlikes-Barre", "state": "PA", "state_display": "Pennsylvania", "zip": "18701", "country": "US", "country_display": "United States of America", "ppb_city": "Montpelier", "ppb_state": "VT", "ppb_state_display": "Vermont", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PENN. MANUFACTURERS ASS. INS. CO.", "url": null, "address_1": "380 Sentry Parkway", "address_2": null, "address_3": null, "address_4": null, "city": "Blue Bell", "state": "PA", "state_display": "Pennsylvania", "zip": "19422", "country": "US", "country_display": "United States of America", "ppb_city": "Blue Bell", "ppb_state": "PA", "ppb_state_display": "Pennsylvania", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PENN. NAT. MUTUAL CASUALTY INS. CO.", "url": null, "address_1": "Two North Second Street", "address_2": null, "address_3": null, "address_4": null, "city": "Harrisburg", "state": "PA", "state_display": "Pennsylvania", "zip": "17101", "country": "US", "country_display": "United States of America", "ppb_city": "Harrisburg", "ppb_state": "PA", "ppb_state_display": "Pennsylvania", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PERMANENT GENERAL ASSURANCE CORP.", "url": null, "address_1": "2636 Elm Hill Pike, Suite 510", "address_2": null, "address_3": null, "address_4": null, "city": "Nashville", "state": "TN", "state_display": "Tennessee", "zip": "37214", "country": "US", "country_display": "United States of America", "ppb_city": "Nashville", "ppb_state": "TN", "ppb_state_display": "Tennessee", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PHARMACISTS MUTUAL INSURANCE CO.", "url": null, "address_1": "808 US Highway 18 West", "address_2": null, "address_3": null, "address_4": null, "city": "Algona", "state": "IA", "state_display": "Iowa", "zip": "50511", "country": "US", "country_display": "United States of America", "ppb_city": "Algona", "ppb_state": "IA", "ppb_state_display": "Iowa", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PHILADELPHIA CONTRIBUTIONSHIP FOR INS.", "url": null, "address_1": "212 South Fourth Street", "address_2": null, "address_3": null, "address_4": null, "city": "Philadelphia", "state": "PA", "state_display": "Pennsylvania", "zip": "19106", "country": "US", "country_display": "United States of America", "ppb_city": "Philadelphia", "ppb_state": "PA", "ppb_state_display": "Pennsylvania", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PHYSICIANS INS. CO. OF WISCONSON", "url": null, "address_1": "1002 Deming Way", "address_2": null, "address_3": null, "address_4": null, "city": "Madison", "state": "WI", "state_display": "Wisconsin", "zip": "53717", "country": "US", "country_display": "United States of America", "ppb_city": "Madison", "ppb_state": "WI", "ppb_state_display": "Wisconsin", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PINNACOL INSURANCE COMPANY", "url": null, "address_1": "7501 East Lowry Boulevard", "address_2": null, "address_3": null, "address_4": null, "city": "Denver", "state": "CO", "state_display": "Colorado", "zip": "80230", "country": "US", "country_display": "United States of America", "ppb_city": "Denver", "ppb_state": "CO", "ppb_state_display": "Colorado", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PLYMOUTH ROCK ASSURANCE CORP.", "url": null, "address_1": "695 Atlantic Avenue", "address_2": null, "address_3": null, "address_4": null, "city": "Boston", "state": "MA", "state_display": "Massachusetts", "zip": "02111", "country": "US", "country_display": "United States of America", "ppb_city": "Boston", "ppb_state": "MA", "ppb_state_display": "Massachusetts", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PREFERRED PROFESSIONAL INSURANCE CO.", "url": null, "address_1": "11605 Miracle Hills Drive, Suite 200", "address_2": null, "address_3": null, "address_4": null, "city": "Omaha", "state": "NE", "state_display": "Nebraska", "zip": "68154", "country": "US", "country_display": "United States of America", "ppb_city": "Omaha", "ppb_state": "CA", "ppb_state_display": "California", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PRESERVER INSURANCE COMPANY", "url": null, "address_1": "120 Breadway, 31st Floor", "address_2": null, "address_3": null, "address_4": null, "city": "New York", "state": "NY", "state_display": "New York", "zip": "10271", "country": "US", "country_display": "United States of America", "ppb_city": "New York", "ppb_state": "NY", "ppb_state_display": "New York", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PROBUILDERS SPECIALTY INS. CO., RRG", "url": null, "address_1": "73-726 Alessandro Drive", "address_2": null, "address_3": null, "address_4": null, "city": "Palm Desert", "state": "CA", "state_display": "California", "zip": "92260", "country": "US", "country_display": "United States of America", "ppb_city": "Palm Desert", "ppb_state": "CA", "ppb_state_display": "California", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PROFORMANCE INSURANCE COMPANY", "url": null, "address_1": "4 Paragon Way", "address_2": null, "address_3": null, "address_4": null, "city": "Freehold", "state": "NJ", "state_display": "New Jersey", "zip": "07728", "country": "US", "country_display": "United States of America", "ppb_city": "Freehold", "ppb_state": "NJ", "ppb_state_display": "New Jersey", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PROGRESSIVE CASUALTY INSURANCE CO.", "url": null, "address_1": "6300 Wilson Mills Road", "address_2": null, "address_3": null, "address_4": null, "city": "Mayfield Village", "state": "OH", "state_display": "Ohio", "zip": "44143", "country": "US", "country_display": "United States of America", "ppb_city": "Mayfield Village", "ppb_state": "OH", "ppb_state_display": "Ohio", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PROTECTIVE INSURANCE COMPANY", "url": null, "address_1": "1099 North Meridian Street, Suite 700", "address_2": null, "address_3": null, "address_4": null, "city": "Indianapolis", "state": "IN", "state_display": "Indiana", "zip": "46204", "country": "US", "country_display": "United States of America", "ppb_city": "Indianapolis", "ppb_state": "IN", "ppb_state_display": "Indiana", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PROVIDENCE MUTUAL FIRE INSURANCE CO.", "url": null, "address_1": "340 East Avenue", "address_2": null, "address_3": null, "address_4": null, "city": "Warwick", "state": "RI", "state_display": "Rhode Island", "zip": "02886", "country": "US", "country_display": "United States of America", "ppb_city": "Warwick", "ppb_state": "RI", "ppb_state_display": "Rhode Island", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "PUBLIC SERVICE MUTUAL INSURANCE CO.", "url": null, "address_1": "One Park Avenue, 15th Flor", "address_2": null, "address_3": null, "address_4": null, "city": "New York", "state": "NY", "state_display": "New York", "zip": "10016", "country": "US", "country_display": "United States of America", "ppb_city": "New York", "ppb_state": "NY", "ppb_state_display": "New York", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "QBE INSURANCE CORPORATION", "url": null, "address_1": "Wall Street Plaza, 88 Pine Street, 16th Floor", "address_2": null, "address_3": null, "address_4": null, "city": "New York", "state": "NY", "state_display": "New York", "zip": "10005", "country": "US", "country_display": "United States of America", "ppb_city": "New York", "ppb_state": "NY", "ppb_state_display": "New York", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "QUINCY MUTUAL FIRE INSURANCE CO.", "url": null, "address_1": "57 Washington Street", "address_2": null, "address_3": null, "address_4": null, "city": "Quincy", "state": "MA", "state_display": "Massachusetts", "zip": "02169", "country": "US", "country_display": "United States of America", "ppb_city": "Quincy", "ppb_state": "MA", "ppb_state_display": "Massachusetts", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "REDLAND INSURANCE COMPANY", "url": null, "address_1": "7 Times Square, 37th Floor", "address_2": null, "address_3": null, "address_4": null, "city": "New York", "state": "NY", "state_display": "New York", "zip": "10036", "country": "US", "country_display": "United States of America", "ppb_city": "New York", "ppb_state": "NY", "ppb_state_display": "New York", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "REPUBLIC UNDERWRITERS INSURANCE CO.", "url": null, "address_1": "5525 LBJ Freeway", "address_2": null, "address_3": null, "address_4": null, "city": "Dallas", "state": "TX", "state_display": "Texas", "zip": "75240", "country": "US", "country_display": "United States of America", "ppb_city": "DAllas", "ppb_state": "TX", "ppb_state_display": "Texas", "ppb_country": "US", "ppb_country_display": "United States of America"}, {"name": "RESPONSE INSURANCE CORPORATION", "url": null, "address_1": "500 South Broad Street", "address_2": null, "address_3": null, "address_4": null, "city": "Meriden", "state": "CT", "state_display": "Connecticut", "zip": "06450", "country": "US", "country_display": "United States of America", "ppb_city": "Meriden", "ppb_state": "CT", "ppb_state_display": "Connecticut", "ppb_country": "US", "ppb_country_display": "United States of America"}]} DC US 30265 DC DC US US   0 37 129356   normalized_name_dc_fallback 0.8

Links from other tables

  • 8 rows from filing_uuid in lobbying_activities
  • 6 rows from filing_uuid in lobbying_lobbyists
  • 37 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 96.135ms