home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 0bc16b07-2e71-4605-8d78-4adb185fced8

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.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date 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 income_amount expense_amount
0bc16b07-2e71-4605-8d78-4adb185fced8 Q3 400263203 OREGON FARM BUREAU FEDERATION 188550 OREGON FARM BUREAU FEDERATION 2008 third_quarter 2008-03-31T09:38:35-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/0bc16b07-2e71-4605-8d78-4adb185fced8/", "filing_uuid": "0bc16b07-2e71-4605-8d78-4adb185fced8", "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/0bc16b07-2e71-4605-8d78-4adb185fced8/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "30000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "David Dillon, Executive Vice President", "dt_posted": "2008-03-31T09:38:35-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "3415 Commercial Street", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Salem", "registrant_state": "OR", "registrant_zip": "97302", "registrant": {"id": 400263203, "url": "https://lda.senate.gov/api/v1/registrants/400263203/", "house_registrant_id": 40004, "name": "OREGON FARM BUREAU FEDERATION", "description": "Agriculture Trade Association", "address_1": "1320 Capitol Street NE", "address_2": "Suite 200", "address_3": null, "address_4": null, "city": "Salem", "state": "OR", "state_display": "Oregon", "zip": "97301", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "DAVID DILLON", "contact_telephone": "+1 503-399-1701", "dt_updated": "2022-12-08T15:09:48.672916-05:00"}, "client": {"id": 188550, "url": "https://lda.senate.gov/api/v1/clients/188550/", "client_id": 12, "name": "OREGON FARM BUREAU FEDERATION", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "OR", "state_display": "Oregon", "country": "US", "country_display": "United States of America", "ppb_state": "OR", "ppb_state_display": "Oregon", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2006-04-17"}, "lobbying_activities": [{"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "OFBF lobbied the Oregon congressional delegation in its support for the Free Trade Agreements (FTA's) in general.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 40430, "prefix": null, "prefix_display": null, "first_name": "GAIL", "nickname": null, "middle_name": null, "last_name": "GREENMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 142, "name": "U.S. Fish & Wildlife Service (USFWS)"}]}, {"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "Secure Rural Schools and Community Self-Determination Reauthorization Act of 2007 (HR 17 and S 380) was discussed. Continued active lobbying on this specific issue.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 40430, "prefix": null, "prefix_display": null, "first_name": "GAIL", "nickname": null, "middle_name": null, "last_name": "GREENMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 142, "name": "U.S. Fish & Wildlife Service (USFWS)"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "OFBF has lobbied for the need to bring comprehensive immigration language up in Congress. Have participated in conference calls regarding H2a reform and no-match rule. Actively involved with Coaltion for a Working Oregon.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 40430, "prefix": null, "prefix_display": null, "first_name": "GAIL", "nickname": null, "middle_name": null, "last_name": "GREENMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 142, "name": "U.S. Fish & Wildlife Service (USFWS)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Estate Tax legislation, H.R. 2380 was supported by the Oregon Farm Bureau Federation. The general issue of estate tax reform is regularly discussed at meetings. Also, OFBF supports the concept of permanently adjusting the alternative minimum tax for inflation. Supported HR 1424, the Emergency Economic Stabilization Act of 2008 and asked delegation to vote for the package.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 40430, "prefix": null, "prefix_display": null, "first_name": "GAIL", "nickname": null, "middle_name": null, "last_name": "GREENMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 142, "name": "U.S. Fish & Wildlife Service (USFWS)"}]}, {"general_issue_code": "FUE", "general_issue_code_display": "Fuel/Gas/Oil", "description": "Actively followed the Federal Energy Regulatory Commission and the proposed pipeline sitings in the state of Oregon.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 40430, "prefix": null, "prefix_display": null, "first_name": "GAIL", "nickname": null, "middle_name": null, "last_name": "GREENMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 142, "name": "U.S. Fish & Wildlife Service (USFWS)"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "H.R. 2421 and S.1870, the Clean Water Restoration Act of 2007 has been discussed regarding Oregon Farm Bureau's opposition to the legislation.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 40430, "prefix": null, "prefix_display": null, "first_name": "GAIL", "nickname": null, "middle_name": null, "last_name": "GREENMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 142, "name": "U.S. Fish & Wildlife Service (USFWS)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} OR US 40004 OR OR US US   0 0           30000.0

Links from other tables

  • 6 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.298ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API