lobbying_filings_raw: e52bc59b-e0b5-4db9-ab62-b3fab2610dde

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
e52bc59b-e0b5-4db9-ab62-b3fab2610dde	Q2	400472335	NATIONAL RELIGIOUS CAMPAIGN AGAINST TORTURE ACTION FUND	191524	NATIONAL RELIGIOUS CAMPAIGN AGAINST TORTURE ACTION FUND	2014	second_quarter	2014-07-08T17:33:47.787000-04:00	30000.0	0	0	0	{"url": "https://lda.senate.gov/api/v1/filings/e52bc59b-e0b5-4db9-ab62-b3fab2610dde/", "filing_uuid": "e52bc59b-e0b5-4db9-ab62-b3fab2610dde", "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/e52bc59b-e0b5-4db9-ab62-b3fab2610dde/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "30000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Tara Morrow, Director of Finance & Operations", "dt_posted": "2014-07-08T17:33:47.787000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "110 Maryland Avenue, NE", "registrant_address_2": "Suite 502", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20002", "registrant": {"id": 400472335, "url": "https://lda.senate.gov/api/v1/registrants/400472335/", "house_registrant_id": 40937, "name": "NATIONAL RELIGIOUS CAMPAIGN AGAINST TORTURE ACTION FUND", "description": "Influencing US public policy on torture through advocacy & lobbying", "address_1": "PO Box 91820", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20090", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "TARA MORROW", "contact_telephone": "+1 202-547-1920", "dt_updated": "2023-07-26T12:25:16.638712-04:00"}, "client": {"id": 191524, "url": "https://lda.senate.gov/api/v1/clients/191524/", "client_id": 12, "name": "NATIONAL RELIGIOUS CAMPAIGN AGAINST TORTURE ACTION FUND", "general_description": null, "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": "2009-08-14"}, "lobbying_activities": [{"general_issue_code": "CIV", "general_issue_code_display": "Civil Rights/Civil Liberties", "description": "The Senate Intelligence Committee investigation into CIA torture. Indefinite detention. The National Defense Authorization Act. Guantanamo/Indefinite detention related amendments to Appropriations bills. Increasing the U.S. contribution to the UN Voluntary Fund for Victims of Torture. Preserving and strengthening the Leahy Law. Ensuring that allowed interrogation techniques are legal and moral. Limiting solitary confinement including the Solitary Confinement Study and Reform Act of 2014. Closing Guantanamo.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 49187, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "HAWTHORNE", "suffix": null, "suffix_display": null}, "covered_position": "legis corresp/intern-sen dorgan;intern-sen conrad", "new": false}, {"lobbyist": {"id": 58735, "prefix": null, "prefix_display": null, "first_name": "LAURA", "nickname": null, "middle_name": null, "last_name": "MARKLE DOWNTON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "The Senate Intelligence Committee investigation into CIA torture. Indefinite detention. The National Defense Authorization Act. Guantanamo/Indefinite detention related amendments to Appropriations bills. Increasing the U.S. contribution to the UN Voluntary Fund for Victims of Torture. Preserving and strengthening the Leahy Law. Ensuring that allowed interrogation techniques are legal and moral. Limiting solitary confinement including the Solitary Confinement Study and Reform Act of 2014. Closing Guantanamo.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 49187, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "HAWTHORNE", "suffix": null, "suffix_display": null}, "covered_position": "legis corresp/intern-sen dorgan;intern-sen conrad", "new": false}, {"lobbyist": {"id": 58735, "prefix": null, "prefix_display": null, "first_name": "LAURA", "nickname": null, "middle_name": null, "last_name": "MARKLE DOWNTON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "FOR", "general_issue_code_display": "Foreign Relations", "description": "The Senate Intelligence Committee investigation into CIA torture. Indefinite detention. The National Defense Authorization Act. Guantanamo/Indefinite detention related amendments to Appropriations bills. Increasing the U.S. contribution to the UN Voluntary Fund for Victims of Torture. Preserving and strengthening the Leahy Law. Ensuring that allowed interrogation techniques are legal and moral. Limiting solitary confinement including the Solitary Confinement Study and Reform Act of 2014. Closing Guantanamo.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 49187, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "HAWTHORNE", "suffix": null, "suffix_display": null}, "covered_position": "legis corresp/intern-sen dorgan;intern-sen conrad", "new": false}, {"lobbyist": {"id": 58735, "prefix": null, "prefix_display": null, "first_name": "LAURA", "nickname": null, "middle_name": null, "last_name": "MARKLE DOWNTON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "REL", "general_issue_code_display": "Religion", "description": "The Senate Intelligence Committee investigation into CIA torture. Indefinite detention. The National Defense Authorization Act. Guantanamo/Indefinite detention related amendments to Appropriations bills. Increasing the U.S. contribution to the UN Voluntary Fund for Victims of Torture. Preserving and strengthening the Leahy Law. Ensuring that allowed interrogation techniques are legal and moral. Limiting solitary confinement including the Solitary Confinement Study and Reform Act of 2014. Closing Guantanamo.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 49187, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "HAWTHORNE", "suffix": null, "suffix_display": null}, "covered_position": "legis corresp/intern-sen dorgan;intern-sen conrad", "new": false}, {"lobbyist": {"id": 58735, "prefix": null, "prefix_display": null, "first_name": "LAURA", "nickname": null, "middle_name": null, "last_name": "MARKLE DOWNTON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "The Senate Intelligence Committee investigation into CIA torture. Indefinite detention. The National Defense Authorization Act. Guantanamo/Indefinite detention related amendments to Appropriations bills. Increasing the U.S. contribution to the UN Voluntary Fund for Victims of Torture. Preserving and strengthening the Leahy Law. Ensuring that allowed interrogation techniques are legal and moral. Limiting solitary confinement including the Solitary Confinement Study and Reform Act of 2014. Closing Guantanamo.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 49187, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "HAWTHORNE", "suffix": null, "suffix_display": null}, "covered_position": "legis corresp/intern-sen dorgan;intern-sen conrad", "new": false}, {"lobbyist": {"id": 58735, "prefix": null, "prefix_display": null, "first_name": "LAURA", "nickname": null, "middle_name": null, "last_name": "MARKLE DOWNTON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "INT", "general_issue_code_display": "Intelligence", "description": "The Senate Intelligence Committee investigation into CIA torture. Indefinite detention. The National Defense Authorization Act. Guantanamo/Indefinite detention related amendments to Appropriations bills. Increasing the U.S. contribution to the UN Voluntary Fund for Victims of Torture. Preserving and strengthening the Leahy Law. Ensuring that allowed interrogation techniques are legal and moral. Limiting solitary confinement including the Solitary Confinement Study and Reform Act of 2014. Closing Guantanamo.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 49187, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "HAWTHORNE", "suffix": null, "suffix_display": null}, "covered_position": "legis corresp/intern-sen dorgan;intern-sen conrad", "new": false}, {"lobbyist": {"id": 58735, "prefix": null, "prefix_display": null, "first_name": "LAURA", "nickname": null, "middle_name": null, "last_name": "MARKLE DOWNTON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "The Senate Intelligence Committee investigation into CIA torture. Indefinite detention. The National Defense Authorization Act. Guantanamo/Indefinite detention related amendments to Appropriations bills. Increasing the U.S. contribution to the UN Voluntary Fund for Victims of Torture. Preserving and strengthening the Leahy Law. Ensuring that allowed interrogation techniques are legal and moral. Limiting solitary confinement including the Solitary Confinement Study and Reform Act of 2014. Closing Guantanamo.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 49187, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "HAWTHORNE", "suffix": null, "suffix_display": null}, "covered_position": "legis corresp/intern-sen dorgan;intern-sen conrad", "new": false}, {"lobbyist": {"id": 58735, "prefix": null, "prefix_display": null, "first_name": "LAURA", "nickname": null, "middle_name": null, "last_name": "MARKLE DOWNTON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	DC	US	40937	DC	DC	US	US		0	0	331400		normalized_name_state	0.9

Links from other tables

7 rows from filing_uuid in lobbying_activities
2 rows from filing_uuid in lobbying_lobbyists
0 rows from filing_uuid in lobbying_affiliated_orgs