home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 6e33db91-02de-4aed-a7bd-9d86d6f5cbae

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
6e33db91-02de-4aed-a7bd-9d86d6f5cbae Q1 77355 WASHINGTON PARTNERS 169871 AFTERSCHOOL ALLIANCE 2012 first_quarter 2012-04-10T16:30:40.310000-04:00 10000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/6e33db91-02de-4aed-a7bd-9d86d6f5cbae/", "filing_uuid": "6e33db91-02de-4aed-a7bd-9d86d6f5cbae", "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/6e33db91-02de-4aed-a7bd-9d86d6f5cbae/print/", "filing_document_content_type": "text/html", "income": "10000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Ellin Nolan, President", "dt_posted": "2012-04-10T16:30:40.310000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1101 VERMONT AVENUE, NW, #400", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 77355, "url": "https://lda.senate.gov/api/v1/registrants/77355/", "house_registrant_id": 36144, "name": "WASHINGTON PARTNERS", "description": "A public relations lobbying firm focused on early, intermediate, and higher education.", "address_1": "777 6th Street, NW", "address_2": "Suite 510", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20001", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "HARRISON WADSWORTH", "contact_telephone": "+1 202-289-3900", "dt_updated": "2022-04-06T16:06:44.358556-04:00"}, "client": {"id": 169871, "url": "https://lda.senate.gov/api/v1/clients/169871/", "client_id": 277, "name": "AFTERSCHOOL ALLIANCE", "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": "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": "EDU", "general_issue_code_display": "Education", "description": "HR 3989/HR 3990- The Student Success Act/Encouraging Innovation and Effective Teachers Act: House reauthorization of the Elementary and Secondary Education Act- provisions related to Title IV, 21st Century Community Learning, extended learning, and STEM education\nBill to reauthorize 21st Century Community Learning Center Program HR 3821 and S. 1370 Afterschool for Americas Children Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 6818, "prefix": null, "prefix_display": null, "first_name": "ELLIN", "nickname": null, "middle_name": null, "last_name": "NOLAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 18376, "prefix": null, "prefix_display": null, "first_name": "ELLEN", "nickname": null, "middle_name": null, "last_name": "FERN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "President's FY2013 Budget Proposal- funding for 21st Century Learning Center Program\nH.Res 112 - FY2013 Budget Resolution- funding for 21st Century Learning Center Program\nFY 2013 LHHS and ED appropriations bill in House RE: funding for 21st Century Learning Center Program\nFY 2013 LHHS and ED appropriations bill in Senate RE: funding for 21st Century Learning Center Program", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 6818, "prefix": null, "prefix_display": null, "first_name": "ELLIN", "nickname": null, "middle_name": null, "last_name": "NOLAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 18376, "prefix": null, "prefix_display": null, "first_name": "ELLEN", "nickname": null, "middle_name": null, "last_name": "FERN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 2 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 7.345ms