home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 566970da-d441-406e-84d4-e60aed108ea6

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
566970da-d441-406e-84d4-e60aed108ea6 Q1 52071 PENNSYLVANIA FARM BUREAU 157715 PENNSYLVANIA FARM BUREAU 2012 first_quarter 2012-04-17T08:59:30.127000-04:00 70000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/566970da-d441-406e-84d4-e60aed108ea6/", "filing_uuid": "566970da-d441-406e-84d4-e60aed108ea6", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2012, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/566970da-d441-406e-84d4-e60aed108ea6/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "70000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Samuel A. Kieffer, National Governmental Relations Director", "dt_posted": "2012-04-17T08:59:30.127000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "510 South 31st Street", "registrant_address_2": "PO Box 8736", "registrant_different_address": false, "registrant_city": "Camp Hill", "registrant_state": "PA", "registrant_zip": "17001", "registrant": {"id": 52071, "url": "https://lda.senate.gov/api/v1/registrants/52071/", "house_registrant_id": 34854, "name": "PENNSYLVANIA FARM BUREAU", "description": null, "address_1": "214 Senate Ave", "address_2": "PO BOX 8736", "address_3": null, "address_4": null, "city": "CAMP HILL", "state": "PA", "state_display": "Pennsylvania", "zip": "17001", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "BAILEY FISHER", "contact_telephone": "+1 717-761-2740", "dt_updated": "2026-01-30T07:32:47.966861-05:00"}, "client": {"id": 157715, "url": "https://lda.senate.gov/api/v1/clients/157715/", "client_id": 12, "name": "PENNSYLVANIA FARM BUREAU", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "PA", "state_display": "Pennsylvania", "country": "US", "country_display": "United States of America", "ppb_state": "PA", "ppb_state_display": "Pennsylvania", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-03"}, "lobbying_activities": [{"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "S. 1813 - Moving Ahead for Progress in the 21st Century. H.R. 7 - American Energy and Infrastructure Jobs Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 37170, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": null, "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "2012 Farm Bill. H.R. 3062 - the Dairy Security Act. H.R. 3286, Local Farms, Food, and Jobs Act. H.R. 3798, the Egg Products Inspection Act Amendments of 2012.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 37170, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": null, "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R. 1259 - Death Tax Repeal Permanency Act of 2011. H.R.1370, to repeal the annual fee on health insurance providers enacted by the Patient Protection and Affordable Care Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 37170, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": null, "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "USDA Wildlife Services/Livestock Protection Program.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 37170, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": null, "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "H.R. 2895 - Legal Agriculture Workforce Act. H.R. 2847 - American Specialty Agriculture Act. H.R. 2164 - Legal Workforce Act. H.R. 2885 - Legal Workforce Act. H.R.3443, Better Agriculture Resources Now (BARN) Act. S. 2221/H.R. 4157, the Preserving America's Family Farms Act. Proposed Agriculture Youth Employment Restrictions. H-2A program application process.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 37170, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": null, "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "H.R. 872 - Reducing Regulatory Burdens Act of 2011. S. 718 - A bill to amend the Federal Insecticide, Fungicide, and Rodenticide Act to improve the use of certain registered pesticides. H.R. 910 - the Energy Tax Prevention Act of 2011. H.R. 4153 the Chesapeake Bay Program Reauthorization and Improvement Act. H.R. 4278, the Preserving Rural Resources Act of 2012. Proposed Clean Water Act guidance. Proposed Utility MACT regulations. S. 2122, teh Defense of Environment and Property Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 37170, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": null, "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

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