home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 6a9d120b-8f81-4bc7-add6-663b28797594

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
6a9d120b-8f81-4bc7-add6-663b28797594 Q4 400398873 LAURA BOYD 190161 FOSTER FAMILY-BASED TREATMENT ASSOCIATION 2010 fourth_quarter 2010-01-07T16:56:39.630000-05:00 10000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/6a9d120b-8f81-4bc7-add6-663b28797594/", "filing_uuid": "6a9d120b-8f81-4bc7-add6-663b28797594", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2010, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/6a9d120b-8f81-4bc7-add6-663b28797594/print/", "filing_document_content_type": "text/html", "income": "10000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Laura Boyd, Public Policy and Government Relations Consultant, FFTA", "dt_posted": "2010-01-07T16:56:39.630000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "2801 Castlewood Dr.", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Norman", "registrant_state": "OK", "registrant_zip": "73072", "registrant": {"id": 400398873, "url": "https://lda.senate.gov/api/v1/registrants/400398873/", "house_registrant_id": 40539, "name": "LAURA BOYD", "description": "Public policy consulting for Foster Family-based Treatment Association", "address_1": "2801 Castlewood Dr.", "address_2": null, "address_3": null, "address_4": null, "city": "Norman", "state": "OK", "state_display": "Oklahoma", "zip": "73072", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "LAURA BOYD", "contact_telephone": "+1 405-503-1123", "dt_updated": "2022-04-06T16:07:04.279600-04:00"}, "client": {"id": 190161, "url": "https://lda.senate.gov/api/v1/clients/190161/", "client_id": 12, "name": "FOSTER FAMILY-BASED TREATMENT ASSOCIATION", "general_description": "Professional association representing providers of therapeutic foster care.", "client_government_entity": false, "client_self_select": false, "state": "NJ", "state_display": "New Jersey", "country": "US", "country_display": "United States of America", "ppb_state": "NJ", "ppb_state_display": "New Jersey", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2009-02-14"}, "lobbying_activities": [{"general_issue_code": "MED", "general_issue_code_display": "Medical/Disease Research/Clinical Labs", "description": "Met with Staff of Senate and House offices between 11/10-12 to dicuss proposed legislation Medicaid Services Restoration Act of 2009 which is filed in Senate (S.1217) and which hope to be filed in House in future. This measure addresses the need for Medicaid reimbursement of professional treatment services provided to children in therapeutic foster care. Also discussed possible amendment to SFC bill on health care.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 48236, "prefix": "ms", "prefix_display": "MS.", "first_name": "LAURA", "nickname": null, "middle_name": "W", "last_name": "BOYD", "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

  • 1 row from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 19.049ms