home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 3dde4212-6700-4e0c-a766-e069e83aaec8

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
3dde4212-6700-4e0c-a766-e069e83aaec8 Q2 11105 THE JEWISH FEDERATIONS OF NORTH AMERICA 114921 JEWISH FEDERATIONS OF NORTH AMERICA 2016 second_quarter 2016-07-11T14:58:08.090000-04:00 252901.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/3dde4212-6700-4e0c-a766-e069e83aaec8/", "filing_uuid": "3dde4212-6700-4e0c-a766-e069e83aaec8", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2016, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/3dde4212-6700-4e0c-a766-e069e83aaec8/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "252901.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Elizabeth Leibowitz", "dt_posted": "2016-07-11T14:58:08.090000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1720 I STREET, NW, SUITE 800", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20006", "registrant": {"id": 11105, "url": "https://lda.senate.gov/api/v1/registrants/11105/", "house_registrant_id": 31857, "name": "THE JEWISH FEDERATIONS OF NORTH AMERICA", "description": null, "address_1": "800 Eighth 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": "JUAN ANDRES GILCES", "contact_telephone": "+1 202-736-5886", "dt_updated": "2026-01-21T09:38:49.071322-05:00"}, "client": {"id": 114921, "url": "https://lda.senate.gov/api/v1/clients/114921/", "client_id": 12, "name": "JEWISH FEDERATIONS OF NORTH AMERICA", "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-08-09"}, "lobbying_activities": [{"general_issue_code": "DIS", "general_issue_code_display": "Disaster Planning/Emergencies", "description": "Emergency Food & Shelter Program", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 14222, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "C", "last_name": "DAROFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44404, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": "BRUCE", "last_name": "GOLDBERG", "suffix": "esq", "suffix_display": "ESQ"}, "covered_position": null, "new": false}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 130, "name": "Administration on Aging"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Transition to Independence Act and Able to Work Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 14222, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "C", "last_name": "DAROFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 63748, "prefix": null, "prefix_display": null, "first_name": "AARON", "nickname": null, "middle_name": null, "last_name": "KAUFMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 28356, "prefix": null, "prefix_display": null, "first_name": "STEPHAN", "nickname": null, "middle_name": null, "last_name": "KLINE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 130, "name": "Administration on Aging"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "HLS Appropriations, Non-profit Security Grant Program, Emergency Food and Shelter program, Law Enforcement Terrorism Prevention Activities (LETPA), and Terrorism Risk Insurance Act Reauthorization", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 14222, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "C", "last_name": "DAROFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44404, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": "BRUCE", "last_name": "GOLDBERG", "suffix": "esq", "suffix_display": "ESQ"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 29498, "prefix": null, "prefix_display": null, "first_name": "STEVEN", "nickname": null, "middle_name": null, "last_name": "WOOLF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 130, "name": "Administration on Aging"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Defined benefit pension issues; charitable tax and donor advised fund issues; Individual Retirement Account Charitable Rollover; General Tax Exempt Organization Issues; Health reform implementation issues as they relate to the U.S. Tax Code; Dodd-Frank legislative amendment regarding endowment fund custodial investment pools; Commodity and Futures Trading Commission Reauthorization for charitable organizations; Credit for Caring Act, Able Age Adjustment Act, Able Financial Planning Act, and Able to Work Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 14222, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "C", "last_name": "DAROFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 28356, "prefix": null, "prefix_display": null, "first_name": "STEPHAN", "nickname": null, "middle_name": null, "last_name": "KLINE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 20549, "prefix": null, "prefix_display": null, "first_name": "JONATHAN", "nickname": null, "middle_name": null, "last_name": "WESTIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 29498, "prefix": null, "prefix_display": null, "first_name": "STEVEN", "nickname": null, "middle_name": null, "last_name": "WOOLF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 63748, "prefix": null, "prefix_display": null, "first_name": "AARON", "nickname": null, "middle_name": null, "last_name": "KAUFMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 130, "name": "Administration on Aging"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Breast Cancer Legislation, Chronic Care Reform, Health Information Technology and Telehealth Legislation, Health Reform, IMPACT Act Implementation/Regulations, Independence at Home Legislation, Long-Term Services and Supports, MACRA Implementation, Medicaid, Medicare, Mental Health Parity, Mental Health Reform Legislation, NOTICE Act Implementation/Regulations, RAISE Family Caregivers Act, Older Americans Act Reauthorization Act, Credit for Caring Act, The Lifespan Respite Care Reauthorization Act, Transition to Independence Act, State Health Insurance Assistance Program advocacy, Child Nutrition Program Reauthorization, economic stimulus initiatives related to healthcare, and Older Americans Act state plan guidance.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 14222, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "C", "last_name": "DAROFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 28356, "prefix": null, "prefix_display": null, "first_name": "STEPHAN", "nickname": null, "middle_name": null, "last_name": "KLINE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 20549, "prefix": null, "prefix_display": null, "first_name": "JONATHAN", "nickname": null, "middle_name": null, "last_name": "WESTIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61851, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": null, "last_name": "LEIBOWITZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 62954, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": null, "last_name": "CULLEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 63748, "prefix": null, "prefix_display": null, "first_name": "AARON", "nickname": null, "middle_name": null, "last_name": "KAUFMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 130, "name": "Administration on Aging"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "WEL", "general_issue_code_display": "Welfare", "description": "Supplemental Nutrition Assistance Program; Legislation promoting social service funding/programs for Holocaust survivors; Older Americans Act Reauthorization Act; Appropriations for FY17: EFSP, VAWA, VOCA, OAA Nutrition Programs, Holocaust Survivor Assistance Program, State Health Insurance Assistance Program, McKinney-Vento Homeless Assistance Grants program, and Human Trafficking Programs; SSBG; Reducing Duplication and Ineffective Federal Funding Act; and Child Nutrition Program Reauthorization", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 14222, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "C", "last_name": "DAROFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 28356, "prefix": null, "prefix_display": null, "first_name": "STEPHAN", "nickname": null, "middle_name": null, "last_name": "KLINE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61851, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": null, "last_name": "LEIBOWITZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44404, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": "BRUCE", "last_name": "GOLDBERG", "suffix": "esq", "suffix_display": "ESQ"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 63748, "prefix": null, "prefix_display": null, "first_name": "AARON", "nickname": null, "middle_name": null, "last_name": "KAUFMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 130, "name": "Administration on Aging"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "FOR", "general_issue_code_display": "Foreign Relations", "description": "Defense Department Authorization; U.S.-Israel Relationship; Foreign Military Financing Program in State Department Appropriations Bill (FY 17 Appropriations); Joint Missile Defense Programs in Defense Appropriations Bill (FY 17 Appropriations); Boycott, Divestment, and Sanctions Resolutions; Resolution Reaffirming Right of States to Maintain Sanctions Against Iran; Lautenberg Amendment; Refugee Program Integrity Restoration Act; Concurrent resolutions in House and Senate to urge German Government to fulfill its financial responsibility to provide for ongoing needs of Holocaust survivors; Combating BDS Act; and letter to President Obama from House supporting two-state solution;", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 14222, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "C", "last_name": "DAROFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61851, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": null, "last_name": "LEIBOWITZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 28356, "prefix": null, "prefix_display": null, "first_name": "STEPHAN", "nickname": null, "middle_name": null, "last_name": "KLINE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 130, "name": "Administration on Aging"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "Medicaid Reform, Medicare Reform, Affordable Care Act Implementation related to Medicaid & Medicare, Transition to Independence Act, Improving Medicare Post Acute Transformation (IMPACT) Act, Improving Access to Medicare Coverage Act, and Medicaid Coverage for Addiction Recovery Expansion (CARE) Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 14222, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "C", "last_name": "DAROFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 20549, "prefix": null, "prefix_display": null, "first_name": "JONATHAN", "nickname": null, "middle_name": null, "last_name": "WESTIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 62954, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": null, "last_name": "CULLEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 63748, "prefix": null, "prefix_display": null, "first_name": "AARON", "nickname": null, "middle_name": null, "last_name": "KAUFMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 28356, "prefix": null, "prefix_display": null, "first_name": "STEPHAN", "nickname": null, "middle_name": null, "last_name": "KLINE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 130, "name": "Administration on Aging"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Emergency Food and Shelter Program Funding (FY 2017 Appropriations), Non-Profit Security Grant Program Funding (FY 2017 Appropriations), Holocaust Survivor Assistance Program (FY 2017 Appropriations), Human Trafficking Programs (FY 2017 Appropriations), and Domestic Violence Programs (FY 2017 Appropriations), Older Americans Act Nutrition Programs (FY 2017 Appropriations), Lautenberg Amendment (FY 2017 Appropriations), Joint Missile Defense Programs (FY 17 Appropriations), Foreign military aid (FY 17 Appropriations), McKinney-Vento Homeless Assistance Grants Program (FY 17 Appropriations), State Health Insurance Assistance Program (FY 17 Appropriations), and Reducing Duplication and Ineffective Federal Funding Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 14222, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "C", "last_name": "DAROFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44404, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": "BRUCE", "last_name": "GOLDBERG", "suffix": "esq", "suffix_display": "ESQ"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 28356, "prefix": null, "prefix_display": null, "first_name": "STEPHAN", "nickname": null, "middle_name": null, "last_name": "KLINE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61851, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": null, "last_name": "LEIBOWITZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 63748, "prefix": null, "prefix_display": null, "first_name": "AARON", "nickname": null, "middle_name": null, "last_name": "KAUFMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 130, "name": "Administration on Aging"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Nonprofit Energy Efficiency Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 44404, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": "BRUCE", "last_name": "GOLDBERG", "suffix": "esq", "suffix_display": "ESQ"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 14222, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "C", "last_name": "DAROFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 130, "name": "Administration on Aging"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 31857 DC DC US US   0 0 84368   normalized_name_dc_fallback 0.8

Links from other tables

  • 10 rows from filing_uuid in lobbying_activities
  • 8 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 5.336ms