home / lobbying / lobbying_filings_raw

lobbying_filings_raw: cd096178-e644-4e55-a22e-a48cc2bc5c04

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
cd096178-e644-4e55-a22e-a48cc2bc5c04 Q4 21596 KSCW, INC. 128190 AMERICAN CORN GROWERS ASSOCIATION 2008 fourth_quarter 2009-01-05T14:15:13-05:00 10000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/cd096178-e644-4e55-a22e-a48cc2bc5c04/", "filing_uuid": "cd096178-e644-4e55-a22e-a48cc2bc5c04", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2008, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/cd096178-e644-4e55-a22e-a48cc2bc5c04/print/", "filing_document_content_type": "text/html", "income": "10000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "JOHN WEINFURTER, PRESIDENT", "dt_posted": "2009-01-05T14:15:13-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "2029 K ST. NW", "registrant_address_2": "7TH FLOOR", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20006", "registrant": {"id": 21596, "url": "https://lda.senate.gov/api/v1/registrants/21596/", "house_registrant_id": 37155, "name": "KSCW, INC.", "description": "LOBBYING AND GOVERNMENT RELATIONS", "address_1": "2029 K ST. NW", "address_2": "7TH FLOOR", "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20006", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "JOHN WEINFURTER", "contact_telephone": "+1 202-293-4761", "dt_updated": "2022-04-06T16:07:19.489065-04:00"}, "client": {"id": 128190, "url": "https://lda.senate.gov/api/v1/clients/128190/", "client_id": 191, "name": "AMERICAN CORN GROWERS ASSOCIATION", "general_description": null, "client_government_entity": false, "client_self_select": false, "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-14"}, "lobbying_activities": [{"general_issue_code": "RRR", "general_issue_code_display": "Railroads", "description": "S772/H1650: Railroad Antitrust Enforcement Act of 2007 \nS953/H2125 :Railroad Competition and Service Improvement Act of 2007", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 33232, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "WEINFURTER", "suffix": null, "suffix_display": null}, "covered_position": "Special Assistant, Rep. Tom Barrett", "new": false}, {"lobbyist": {"id": 43111, "prefix": null, "prefix_display": null, "first_name": "LARRY", "nickname": null, "middle_name": null, "last_name": "MITCHELL", "suffix": null, "suffix_display": null}, "covered_position": "Deputy Admin. of Farm Programs - FSA, USDA", "new": false}, {"lobbyist": {"id": 21733, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "SENTER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21148, "prefix": null, "prefix_display": null, "first_name": "BILLY", "nickname": null, "middle_name": null, "last_name": "SENTER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44050, "prefix": "mr", "prefix_display": "MR.", "first_name": "JONATHAN", "nickname": null, "middle_name": "J", "last_name": "HARSCH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41353, "prefix": null, "prefix_display": null, "first_name": "ADRIENNE", "nickname": null, "middle_name": null, "last_name": "HICKLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43850, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "MILES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43851, "prefix": null, "prefix_display": null, "first_name": "BRIEN", "nickname": null, "middle_name": null, "last_name": "BONNEVILLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "H.R.2419, HR6124: Food, Conservation, and Energy Act of 2008, Implimentation of the FarmBill, Section 1101D: 10 Acre Rule\nThe implimentation of the Conservation Stewardship Program", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 33232, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "WEINFURTER", "suffix": null, "suffix_display": null}, "covered_position": "Special Assistant, Rep. Tom Barrett", "new": false}, {"lobbyist": {"id": 43111, "prefix": null, "prefix_display": null, "first_name": "LARRY", "nickname": null, "middle_name": null, "last_name": "MITCHELL", "suffix": null, "suffix_display": null}, "covered_position": "Deputy Admin. of Farm Programs - FSA, USDA", "new": false}, {"lobbyist": {"id": 21733, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "SENTER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21148, "prefix": null, "prefix_display": null, "first_name": "BILLY", "nickname": null, "middle_name": null, "last_name": "SENTER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44050, "prefix": "mr", "prefix_display": "MR.", "first_name": "JONATHAN", "nickname": null, "middle_name": "J", "last_name": "HARSCH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41353, "prefix": null, "prefix_display": null, "first_name": "ADRIENNE", "nickname": null, "middle_name": null, "last_name": "HICKLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43850, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "MILES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43851, "prefix": null, "prefix_display": null, "first_name": "BRIEN", "nickname": null, "middle_name": null, "last_name": "BONNEVILLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CDT", "general_issue_code_display": "Commodities (big ticket)", "description": "H.R.2419, H.R.6124: Food, Conservation, and Energy Act of 2008, implimentation of provisions dealing with commodities\nH.R.6604: Commodity Markets Transparency and Accountability Act of 2008", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 33232, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "WEINFURTER", "suffix": null, "suffix_display": null}, "covered_position": "Special Assistant, Rep. Tom Barrett", "new": false}, {"lobbyist": {"id": 43111, "prefix": null, "prefix_display": null, "first_name": "LARRY", "nickname": null, "middle_name": null, "last_name": "MITCHELL", "suffix": null, "suffix_display": null}, "covered_position": "Deputy Admin. of Farm Programs - FSA, USDA", "new": false}, {"lobbyist": {"id": 21733, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "SENTER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21148, "prefix": null, "prefix_display": null, "first_name": "BILLY", "nickname": null, "middle_name": null, "last_name": "SENTER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44050, "prefix": "mr", "prefix_display": "MR.", "first_name": "JONATHAN", "nickname": null, "middle_name": "J", "last_name": "HARSCH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41353, "prefix": null, "prefix_display": null, "first_name": "ADRIENNE", "nickname": null, "middle_name": null, "last_name": "HICKLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43850, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "MILES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43851, "prefix": null, "prefix_display": null, "first_name": "BRIEN", "nickname": null, "middle_name": null, "last_name": "BONNEVILLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "The implimentation of the Federally Recognized Tribes Extension Program, provisions dealing with Crop Insurance", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 33232, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "WEINFURTER", "suffix": null, "suffix_display": null}, "covered_position": "Special Assistant, Rep. Tom Barrett", "new": false}, {"lobbyist": {"id": 43111, "prefix": null, "prefix_display": null, "first_name": "LARRY", "nickname": null, "middle_name": null, "last_name": "MITCHELL", "suffix": null, "suffix_display": null}, "covered_position": "Deputy Admin. of Farm Programs - FSA, USDA", "new": false}, {"lobbyist": {"id": 21733, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "SENTER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21148, "prefix": null, "prefix_display": null, "first_name": "BILLY", "nickname": null, "middle_name": null, "last_name": "SENTER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44050, "prefix": "mr", "prefix_display": "MR.", "first_name": "JONATHAN", "nickname": null, "middle_name": "J", "last_name": "HARSCH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41353, "prefix": null, "prefix_display": null, "first_name": "ADRIENNE", "nickname": null, "middle_name": null, "last_name": "HICKLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43850, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "MILES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43851, "prefix": null, "prefix_display": null, "first_name": "BRIEN", "nickname": null, "middle_name": null, "last_name": "BONNEVILLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "S.3268: Stop Excessive Energy Speculation Act of 2008\nS.3186: Warm in Winter and Cool in Summer Act, dealing with Low Income Heating and Energy Assistance Program (LIHEAP).\nLegislation dealing with tax credits for the production of renewable fuels and energy. \nLegislation dealing with Renewable Fuel Standards (RFS).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 33232, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "WEINFURTER", "suffix": null, "suffix_display": null}, "covered_position": "Special Assistant, Rep. Tom Barrett", "new": false}, {"lobbyist": {"id": 43111, "prefix": null, "prefix_display": null, "first_name": "LARRY", "nickname": null, "middle_name": null, "last_name": "MITCHELL", "suffix": null, "suffix_display": null}, "covered_position": "Deputy Admin. of Farm Programs - FSA, USDA", "new": false}, {"lobbyist": {"id": 21733, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "SENTER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21148, "prefix": null, "prefix_display": null, "first_name": "BILLY", "nickname": null, "middle_name": null, "last_name": "SENTER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44050, "prefix": "mr", "prefix_display": "MR.", "first_name": "JONATHAN", "nickname": null, "middle_name": "J", "last_name": "HARSCH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41353, "prefix": null, "prefix_display": null, "first_name": "ADRIENNE", "nickname": null, "middle_name": null, "last_name": "HICKLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43850, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "MILES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43851, "prefix": null, "prefix_display": null, "first_name": "BRIEN", "nickname": null, "middle_name": null, "last_name": "BONNEVILLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 5 rows from filing_uuid in lobbying_activities
  • 8 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 45.369ms