home / lobbying / lobbying_filings_raw

lobbying_filings_raw: b765064d-e0df-41b6-922e-76c0e7df05ae

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
b765064d-e0df-41b6-922e-76c0e7df05ae Q4 27536 NATIONAL COOPERATIVE BUSINESS ASSOCIATION 134298 NATIONAL COOPERATIVE BUSINESS ASSOCIATION 2018 fourth_quarter 2018-11-29T13:50:20.723000-05:00 10891.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/b765064d-e0df-41b6-922e-76c0e7df05ae/", "filing_uuid": "b765064d-e0df-41b6-922e-76c0e7df05ae", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2018, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/b765064d-e0df-41b6-922e-76c0e7df05ae/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "10891.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Valerie Roach", "dt_posted": "2018-11-29T13:50:20.723000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1775 Eye Street, NW", "registrant_address_2": "8th Floor", "registrant_different_address": true, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20006", "registrant": {"id": 27536, "url": "https://lda.senate.gov/api/v1/registrants/27536/", "house_registrant_id": 30370, "name": "NATIONAL COOPERATIVE BUSINESS ASSOCIATION", "description": null, "address_1": "1775 Eye Street NW", "address_2": "8th 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": "VALERIE ROACH", "contact_telephone": "+1 202-638-6222", "dt_updated": "2026-02-25T14:23:01.717123-05:00"}, "client": {"id": 134298, "url": "https://lda.senate.gov/api/v1/clients/134298/", "client_id": 12, "name": "NATIONAL COOPERATIVE BUSINESS ASSOCIATION", "general_description": "To promote and defend the cooperative business model in policies", "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": "2008-02-13"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "-H.R. 5961, Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations Act, 2019\n-S. 2976, Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations Act, 2019\n-H.R. 6385, Department of State, Foreign Operations, and Related Programs Appropriations Act, 2019\n-S. 3108, Department of State, Foreign Operations, and Related Programs Appropriations Act, 2019", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59898, "prefix": "mr", "prefix_display": "MR.", "first_name": "ALAN", "nickname": null, "middle_name": "PAUL", "last_name": "KNAPP", "suffix": null, "suffix_display": null}, "covered_position": "Deputy Chief of Staff (Rep. Ted Poe (2nd-TX))", "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "-H.R. 2, Agriculture and Nutrition Act of 2018\n-S. 3042, Agricultural Improvement Act of 2018\n-Interagency Working Group on Cooperative Development", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59898, "prefix": "mr", "prefix_display": "MR.", "first_name": "ALAN", "nickname": null, "middle_name": "PAUL", "last_name": "KNAPP", "suffix": null, "suffix_display": null}, "covered_position": "Deputy Chief of Staff (Rep. Ted Poe (2nd-TX))", "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "SMB", "general_issue_code_display": "Small Business", "description": "-H.R. 5236, Main Street Employee Ownership Act\n-S. 2786, Main Street Employee Ownership Act\n-H.R. 5515, John S. McCain National Defense Authorization Act for Fiscal Year 2019", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59898, "prefix": "mr", "prefix_display": "MR.", "first_name": "ALAN", "nickname": null, "middle_name": "PAUL", "last_name": "KNAPP", "suffix": null, "suffix_display": null}, "covered_position": "Deputy Chief of Staff (Rep. Ted Poe (2nd-TX))", "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "-Congressional Cooperative Business Caucus\n-Interagency Working Group on Cooperative Development\n-H. Res. 561, Commending the cooperative business model and the businesses, employees, and practitioners nationally and internationally who use it for their contributions to the economy and social impacts they make on their communities.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59898, "prefix": "mr", "prefix_display": "MR.", "first_name": "ALAN", "nickname": null, "middle_name": "PAUL", "last_name": "KNAPP", "suffix": null, "suffix_display": null}, "covered_position": "Deputy Chief of Staff (Rep. Ted Poe (2nd-TX))", "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 30370 DC DC US US To promote and defend the cooperative business model in policies 0 0 575006   alias 0.85

Links from other tables

  • 4 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 6.354ms