home / lobbying / lobbying_filings_raw

lobbying_filings_raw: f8b295c0-b0d5-4781-8876-61ba7d06b1f7

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
f8b295c0-b0d5-4781-8876-61ba7d06b1f7 Q2 400410940 ANDREW COCHRAN 190357 AMERICAN ASSOCIATION FOR JUSTICE 2014 second_quarter 2014-07-18T11:34:47.117000-04:00 50000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/f8b295c0-b0d5-4781-8876-61ba7d06b1f7/", "filing_uuid": "f8b295c0-b0d5-4781-8876-61ba7d06b1f7", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2014, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/f8b295c0-b0d5-4781-8876-61ba7d06b1f7/print/", "filing_document_content_type": "text/html", "income": "50000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Andrew Cochran", "dt_posted": "2014-07-18T11:34:47.117000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "8509 Paul Revere Ct.", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Annandale", "registrant_state": "VA", "registrant_zip": "22003", "registrant": {"id": 400410940, "url": "https://lda.senate.gov/api/v1/registrants/400410940/", "house_registrant_id": 40594, "name": "ANDREW COCHRAN", "description": "Government Relations", "address_1": "8509 Paul Revere Ct.", "address_2": null, "address_3": null, "address_4": null, "city": "Annandale", "state": "VA", "state_display": "Virginia", "zip": "22003", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ANDREW COCHRAN", "contact_telephone": "+1 703-405-8769", "dt_updated": "2022-04-06T16:07:01.783680-04:00"}, "client": {"id": 190357, "url": "https://lda.senate.gov/api/v1/clients/190357/", "client_id": 12, "name": "AMERICAN ASSOCIATION FOR JUSTICE", "general_description": "Membership organization for plaintiffs' attorneys", "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": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2009-03-01"}, "lobbying_activities": [{"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "S. 1720 (Patent Transparency and Improvements Act of 2013); to promote transparency in patent ownership and make other improvements to the patent system. \n\nGeneral lobbying with regard to patent troll proposals.\n\nGeneral lobbying with regard to patent reform proposals, specific interest in proposals that would enact loser pays, mandatory sanctions, limits on discovery, fees on discovery or heightened pleading standards.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 47276, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "COCHRAN", "suffix": null, "suffix_display": null}, "covered_position": "Senior Counsel, House Financial Services Committee", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "S. 1999/H.R. 4068 (SCRA Rights Protection Act of 2014); to amend the Servicemembers Civil Relief Act to require the consent of parties to contracts for the use of arbitration to resolve controversies arising under the contracts and subject to provisions of such Act and to preserve the rights of servicemembers to bring class actions under such Act, and for other purposes. \n\nGeneral lobbying with regard to the ongoing development of a proposed TAFTA-TTIP trade agreement, specific interest in effect the trade agreement would have on state-based causes of action.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 47276, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "COCHRAN", "suffix": null, "suffix_display": null}, "covered_position": "Senior Counsel, House Financial Services Committee", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TOR", "general_issue_code_display": "Torts", "description": "Lobbying with regard to medical malpractice reform proposals generally, including issues relating to practice guidelines for providers and health courts.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 47276, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "COCHRAN", "suffix": null, "suffix_display": null}, "covered_position": "Senior Counsel, House Financial Services Committee", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} VA US 40594 DC   US US Membership organization for plaintiffs' attorneys 0 0 31800   normalized_name_state 0.9

Links from other tables

  • 3 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 1.213ms