home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 3e6123af-e02f-4ab8-8fea-8bb2d7155e1c

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
3e6123af-e02f-4ab8-8fea-8bb2d7155e1c Q1 7691 CALIFORNIA ASSOCIATION OF REALTORS 110899 CALIFORNIA ASSOCIATION OF REALTORS 2021 first_quarter 2021-04-20T02:43:59.240000-04:00 45521.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/3e6123af-e02f-4ab8-8fea-8bb2d7155e1c/", "filing_uuid": "3e6123af-e02f-4ab8-8fea-8bb2d7155e1c", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2021, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/3e6123af-e02f-4ab8-8fea-8bb2d7155e1c/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "45521.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Matthew Roberts", "dt_posted": "2021-04-20T02:43:59.240000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "525 SOUTH VIRGIL AVENUE", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "LOS ANGELES", "registrant_state": "CA", "registrant_zip": "90020", "registrant": {"id": 7691, "url": "https://lda.senate.gov/api/v1/registrants/7691/", "house_registrant_id": 33287, "name": "CALIFORNIA ASSOCIATION OF REALTORS", "description": null, "address_1": "915 L. Street, Suite 1460", "address_2": null, "address_3": null, "address_4": null, "city": "Sacramento", "state": "CA", "state_display": "California", "zip": "95814", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MR. MATTHEW ROBERTS", "contact_telephone": "+1 213-739-8284", "dt_updated": "2026-01-20T13:50:40.189443-05:00"}, "client": {"id": 110899, "url": "https://lda.senate.gov/api/v1/clients/110899/", "client_id": 12, "name": "CALIFORNIA ASSOCIATION OF REALTORS", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "CA", "state_display": "California", "country": "US", "country_display": "United States of America", "ppb_state": "CA", "ppb_state_display": "California", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-03"}, "lobbying_activities": [{"general_issue_code": "CIV", "general_issue_code_display": "Civil Rights/Civil Liberties", "description": "H.R. 5 - The Equality Act - C.A.R. advocated on expanding the Fair Housing Act to cover sexual orientation and sexual identity.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 28330, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "ROBERTS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 57, "name": "Federal Housing Finance Agency (FHFA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R. 613 - the SALT Deductibility Act - Would eliminate the cap on state and local tax deductions.\n\nC.A.R. advocated for a first time homebuyer tax credit with members of Congress.\n\nC.A.R. advocated for a tax credit for commercial property owners to convert their properties to residential units.\n\nC.A.R. discussed the issue of 1031 exchanges and their importance in the California real estate market with members of Congress.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 28330, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "ROBERTS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 57, "name": "Federal Housing Finance Agency (FHFA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "SMB", "general_issue_code_display": "Small Business", "description": "H.R. 842 - Protecting the Right to Organize Act (PRO Act) - C.A.R. advocated on the bill's possible preemption of state law in determining the ability of real estate agents to choose to be independent contractors.\n\nH.R. 1799 - PPP Extension Act - The bill would extend the PPP to allow for two more months of applications. \n\nC.A.R. submitted comments to the House Financial Services Committee on the hearing entitled: Supporting Small Minority Owned Businesses Through the Pandemic", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 28330, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "ROBERTS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 57, "name": "Federal Housing Finance Agency (FHFA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HOU", "general_issue_code_display": "Housing", "description": "H.R. 1319 - The American Rescue Plan Act - C.A.R. advocated for financial support for mom-and-pop landlords, the paycheck protection program, and assistance for struggling homeowners.\n\nC.A.R. submitted comments for the House Financial Services Committee Hearing, Justice for All: Achieving Racial Equity Through Fair Access to Housing and Financial Services\n\nC.A.R. advocated on the topic of making housing a part of infrastructure and transportation. \n\nC.A.R. advocated to Congress and has submitted comments to HUD asking the FHA and HUD to reduce the FHA mortgage insurance premium.\n\nC.A.R. submitted comments to the FHFA for their Request for Information on Appraisal-Related Policies, Practices, and Processes.\n\nC.A.R. advocated for the elimination of risk based pricing by Fannie Mae and Freddie Mac.\n\nC.A.R. advocated for the reform of Fannie Mae and Freddie Mac to bring them out of conservatorship.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 28330, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "ROBERTS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 57, "name": "Federal Housing Finance Agency (FHFA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "C.A.R. commented on HUD Proposed Rule, Acceptance of Private Flood Insurance for FHA-Insured Mortgages (Docket Number HUD-2020-0078; RIN 2502-AJ43)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 28330, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "ROBERTS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 57, "name": "Federal Housing Finance Agency (FHFA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 5 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 11.47ms