home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 0fbe320b-3dfd-4ff1-bb35-2a95420b116e

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
0fbe320b-3dfd-4ff1-bb35-2a95420b116e Q2 31747 POLICY DIRECTIONS INC. 138914 NESTLE USA 2009 second_quarter 2009-07-15T15:12:27-04:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/0fbe320b-3dfd-4ff1-bb35-2a95420b116e/", "filing_uuid": "0fbe320b-3dfd-4ff1-bb35-2a95420b116e", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2009, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/0fbe320b-3dfd-4ff1-bb35-2a95420b116e/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "FRANKIE L. TRULL, PRESIDENT & CEO", "dt_posted": "2009-07-15T15:12:27-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "818 CONNECTICUT AVENUE, NW, #950", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON, DC", "registrant_state": "DC", "registrant_zip": "20006", "registrant": {"id": 31747, "url": "https://lda.senate.gov/api/v1/registrants/31747/", "house_registrant_id": 32112, "name": "POLICY DIRECTIONS INC.", "description": "Government Relations", "address_1": "1100 Vermont Avenue, NW, Suite 1100", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20005", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "FRANKIE L. TRULL", "contact_telephone": "", "dt_updated": "2022-04-06T16:06:15.150422-04:00"}, "client": {"id": 138914, "url": "https://lda.senate.gov/api/v1/clients/138914/", "client_id": 36, "name": "NESTLE USA", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-07-30"}, "lobbying_activities": [{"general_issue_code": "BEV", "general_issue_code_display": "Beverage Industry", "description": "Supplemental Nutrition Program for Women, Infants and Children (WIC); implementation of new food packages.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 34078, "prefix": null, "prefix_display": null, "first_name": "STEPHEN", "nickname": null, "middle_name": null, "last_name": "MICHAEL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "FOO", "general_issue_code_display": "Food Industry (safety, labeling, etc.)", "description": "Safety and Labeling; Food Safety legislation including, the Food and Drug Import Safety Act, S. 510, the FDA Food Safety Modernization Act, draft legislation by Rep. John Dingell known as the Food and Drug Globalization Act of 2009, to reform FDA regulation of domestic and imported food safety; all titles relating to FDA regulation of the food processing industry, including section related to country-of-origin labeling on imported ingredients and foods.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 40454, "prefix": null, "prefix_display": null, "first_name": "FRANKIE", "nickname": null, "middle_name": "L", "last_name": "TRULL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34078, "prefix": null, "prefix_display": null, "first_name": "STEPHEN", "nickname": null, "middle_name": null, "last_name": "MICHAEL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 42544, "prefix": null, "prefix_display": null, "first_name": "STEVE", "nickname": null, "middle_name": null, "last_name": "KOPPERUD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 20682, "prefix": "ms", "prefix_display": "MS.", "first_name": "NICOLE", "nickname": null, "middle_name": "SUZANNE", "last_name": "CHURCHILL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 38835, "prefix": null, "prefix_display": null, "first_name": "JILL", "nickname": null, "middle_name": "HOMER", "last_name": "STEWART", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Legislation and regulatory actions related to greenhouse gas emission caps, as well as action to create a carbon credit cap-and-trade program.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42544, "prefix": null, "prefix_display": null, "first_name": "STEVE", "nickname": null, "middle_name": null, "last_name": "KOPPERUD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 38835, "prefix": null, "prefix_display": null, "first_name": "JILL", "nickname": null, "middle_name": "HOMER", "last_name": "STEWART", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48220, "prefix": null, "prefix_display": null, "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": "1989-91 Rep. Pat Roberts, Leg. Assistant, 1991-96 House Ag Committee, Leg. Director, Minority/Majority, 2001-01/09/09 USDA, Chief of Staff to, Sec. of Agriculture", "new": true}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "Issues relating to planting of vegetables on program crop acres for the purpose of processing; issues relating to reform of the Conservation Reserve Program; and issues relating to research and programs fostering development of alternative feedstocks for biofuel manufacture.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42544, "prefix": null, "prefix_display": null, "first_name": "STEVE", "nickname": null, "middle_name": null, "last_name": "KOPPERUD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Ingredients and imports;\nMonitor issues related to truck size and weight allowed on interstate highways.\nMonitor issues related to reauthorization of Federal Highway Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 40454, "prefix": null, "prefix_display": null, "first_name": "FRANKIE", "nickname": null, "middle_name": "L", "last_name": "TRULL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 42544, "prefix": null, "prefix_display": null, "first_name": "STEVE", "nickname": null, "middle_name": null, "last_name": "KOPPERUD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 38835, "prefix": null, "prefix_display": null, "first_name": "JILL", "nickname": null, "middle_name": "HOMER", "last_name": "STEWART", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "FUE", "general_issue_code_display": "Fuel/Gas/Oil", "description": "Issues related to extend various federal tax incentives for the production of alternative fuels and the blending of alternative fuels with diesel", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42544, "prefix": null, "prefix_display": null, "first_name": "STEVE", "nickname": null, "middle_name": null, "last_name": "KOPPERUD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 32112 DC   US US   0 0 2258694   normalized_name_dc_fallback 0.8

Links from other tables

  • 6 rows from filing_uuid in lobbying_activities
  • 6 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 4.203ms