home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 1c6762fa-a14d-47b1-9bcf-2625fd99ab12

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. Sortable columns (indexed): filing_type, client_name, filing_year, client_state, registrant_state, registrant_house_id, registrant_id. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date 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 income_amount expense_amount
1c6762fa-a14d-47b1-9bcf-2625fd99ab12 Q1 14110 FAMILY RESEARCH COUNCIL 119516 FAMILY RESEARCH COUNCIL 2014 first_quarter 2014-04-16T10:56:28.913000-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/1c6762fa-a14d-47b1-9bcf-2625fd99ab12/", "filing_uuid": "1c6762fa-a14d-47b1-9bcf-2625fd99ab12", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2014, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/1c6762fa-a14d-47b1-9bcf-2625fd99ab12/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "10000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "PAUL J. TRIPODI - VICE PRESIDENT ADMINISTRATION", "dt_posted": "2014-04-16T10:56:28.913000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "801 G STREET NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 14110, "url": "https://lda.senate.gov/api/v1/registrants/14110/", "house_registrant_id": 32426, "name": "FAMILY RESEARCH COUNCIL", "description": "Provide educational material concerning traditional Judeo-Christian family values & ethics", "address_1": "801 G STREET NW", "address_2": null, "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": "ENOCH LI", "contact_telephone": "+1 202-637-4618", "dt_updated": "2026-01-06T17:27:01.692829-05:00"}, "client": {"id": 119516, "url": "https://lda.senate.gov/api/v1/clients/119516/", "client_id": 12, "name": "FAMILY RESEARCH COUNCIL", "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": "2007-07-25"}, "lobbying_activities": [{"general_issue_code": "GAM", "general_issue_code_display": "Gaming/Gambling/Casino", "description": "H.R.4301, Restoration of America's Wire Act, Restricts on-line gambling specifcally related to the internet. S. 2159, Restoration of America's Wire Act, Restricts on-line gambling specifcally related to the internet.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43792, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "CHRISTENSEN", "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": "HCR", "general_issue_code_display": "Health Issues", "description": "H.R. 940, Health Care Conscience Rights Act, Protections against discrimination due to religious or moral objections to certain services in health care plans. S. 1204 Health Care Conscience Rights Act, Protections against discrimination due to religious or moral objections to certain services in health care plans. H.R. 7, No Taxpayer Funding for Abortion Act, Prevents funding of elective abortion, including in health care plans.H.R. 4302, Protecting Access to Medicare Act of 2014, Reauthorizes Title V abstinence block grants", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43792, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "CHRISTENSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59687, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "MINICK", "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": "VET", "general_issue_code_display": "Veterans", "description": "H.R. 2529, Veteran Spouses Equal Treatment Act, Amends definition of \"spouse\" for purposes of veteran benefits.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43792, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "CHRISTENSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59270, "prefix": null, "prefix_display": null, "first_name": "LEANNA", "nickname": null, "middle_name": null, "last_name": "BAUMER", "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": "FOR", "general_issue_code_display": "Foreign Relations", "description": "S. 653, Special Envoy Bill, Creates Special Envoy at State Dept. for religious freedom in Near East and So. Central Asia", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43792, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "CHRISTENSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59270, "prefix": null, "prefix_display": null, "first_name": "LEANNA", "nickname": null, "middle_name": null, "last_name": "BAUMER", "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": "FAM", "general_issue_code_display": "Family issues/Abortion/Adoption", "description": "S 1670, Pain Capable Unborn Child Protection Act, Bans late term abortions after 20 weeks gestation due to pain for the unborn. H.R. 3601, Parental Notification and Intervention Act of 2013, Requires parental notification and 96 hour waiting period before abortion on a minor.HR 3279, Abortion Insurance Full Disclosure Act, Requires full disclosure as to whether insurance plan covers abortion. S. 1848, Abortion Insurance Full Disclosure Act, Requires full disclosure as to whether insurance plan covers abortion. S. 2024, State Marriage Defense Act of 2014, Clarifies meaning of \"marriage\" and \"spouse for Federal purposes and ensures respect for State regulation of marriage. H.R. 3829, State Marriage Defense Act of 2014, Clarifies meaning of \"marriage\" and \"spouse\" for Federal purposes and ensures respect for State regulation of marriage. H.R. 51, Marrriage Protection Amendment, Proposes constitutional amendment defining marriage as the union of one man and one woman.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43792, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "CHRISTENSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59270, "prefix": null, "prefix_display": null, "first_name": "LEANNA", "nickname": null, "middle_name": null, "last_name": "BAUMER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59687, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "MINICK", "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": "REL", "general_issue_code_display": "Religion", "description": "S.1808 Marriage and Religious Freedom Act, Upholds religious freedom re: traditional view of marriage. H.R. 3133, Marriage and Religious Freedom Act, Upholds religious freedom re: traditional view of marriage.H.R. 127, Restore the Free Speech and First Amendment Rights of Churches and Exempt Organizations by Repealing the 1954 Johnson Amendment, Repeals Johnson Amdt. that restricts free speech rights of churches.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43792, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "CHRISTENSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59270, "prefix": null, "prefix_display": null, "first_name": "LEANNA", "nickname": null, "middle_name": null, "last_name": "BAUMER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59687, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "MINICK", "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": "EDU", "general_issue_code_display": "Education", "description": "S.345, Common Core Resolution, Restoration and protection of State authority in establishing student academic standards and opposition to Common Core State Standards. H.R. 47, Common Core Resolution, Restoration and protection of State authority in establishing student academic standards and opposition to Common Core State Standards.H.R. 4008, Education Freedom Act of 2014, Forbids federal government from incentivizing states to adopt multi standards for education such as Common Core via federal funds. H.R. 3339, The One Size Does Not Fit All in Education Act, Prohibits use of funds by the Dept. of Education to implement multi state academic standards.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43792, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "CHRISTENSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59687, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "MINICK", "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": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "H.R. 1755, Employment Non-Discrimination Act, Impact of anti-discrimination laws related to sexual orientation and identity of religious groups, persons, and businesses.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59270, "prefix": null, "prefix_display": null, "first_name": "LEANNA", "nickname": null, "middle_name": null, "last_name": "BAUMER", "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": []} DC US 32426 DC DC US US   0 0           10000.0

Links from other tables

  • 8 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.349ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy