home / lobbying / lobbying_filings_raw

lobbying_filings_raw: ffc335bb-84be-4e43-93ee-3e79f3ab11b8

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
ffc335bb-84be-4e43-93ee-3e79f3ab11b8 Q3 401103399 WOMEN'S REFUGEE COMMISSION, INC. 198813 WOMEN'S REFUGEE COMMISSION, INC. 2022 third_quarter 2022-10-13T11:21:12-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/ffc335bb-84be-4e43-93ee-3e79f3ab11b8/", "filing_uuid": "ffc335bb-84be-4e43-93ee-3e79f3ab11b8", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2022, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/ffc335bb-84be-4e43-93ee-3e79f3ab11b8/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "20000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Jessica Mider", "dt_posted": "2022-10-13T11:21:12-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "15 West 37th Street, 9th Floor", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "New York", "registrant_state": "NY", "registrant_zip": "10018", "registrant": {"id": 401103399, "url": "https://lda.senate.gov/api/v1/registrants/401103399/", "house_registrant_id": null, "name": "WOMEN'S REFUGEE COMMISSION, INC.", "description": "Not for Profit: Support women, children and youth displaced by conflict/crisis", "address_1": "15 West 37th Street, 9th Floor", "address_2": null, "address_3": null, "address_4": null, "city": "New York", "state": "NY", "state_display": "New York", "zip": "10018", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "JESSICA MIDER", "contact_telephone": "+1 212-551-3115", "dt_updated": "2025-01-13T10:43:06.686478-05:00"}, "client": {"id": 198813, "url": "https://lda.senate.gov/api/v1/clients/198813/", "client_id": 12, "name": "WOMEN'S REFUGEE COMMISSION, INC.", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "NY", "state_display": "New York", "country": "US", "country_display": "United States of America", "ppb_state": "NY", "ppb_state_display": "New York", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2014-08-02"}, "lobbying_activities": [{"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "Advocacy on the issues of protections for children/people seeking asylum, policies and processes around asylum and protections for families/unaccompanied children at the border, family reunification, regional refugee protection, child welfare, detention, case management and alternatives to detention, unaccompanied migrant children, legislative developments around Title 42 amendments, reception of Afghans in the US reproductive care access for pregnant unaccompanied children Legislation: FY23 Budget, FY23 and FY24 appropriations legislation, Children Safe Passage Act (S. 4529 / H.R. 8349) Title 42 amendments, H.R. 5376 Inflation Reduction Act; Budget Reconciliation Bill in summer 2022", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 106201, "prefix": null, "prefix_display": null, "first_name": "GAYATRI", "nickname": null, "middle_name": null, "last_name": "PATEL", "suffix": null, "suffix_display": null}, "covered_position": "Senior Foreign Affairs Officer, U.S. Department of State, September 2005-May 2012 and June 2013-September 2015", "new": false}], "government_entities": [{"id": 154, "name": "Bureau of Citizenship & Immigration Services (BCIS)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 251, "name": "U.S. Immigration & Customs Enforcement (ICE)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Advocacy on the issues of protections for children/people seeking asylum, policies and processes around asylum and protections for families/children at the border, family reunification, child welfare, Title 42. Legislation: FY23 and FY24 appropriations legislation; Children Safe Passage Act bill (S. 4529 / H.R. 8349)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 106201, "prefix": null, "prefix_display": null, "first_name": "GAYATRI", "nickname": null, "middle_name": null, "last_name": "PATEL", "suffix": null, "suffix_display": null}, "covered_position": "Senior Foreign Affairs Officer, U.S. Department of State, September 2005-May 2012 and June 2013-September 2015", "new": false}], "government_entities": [{"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FOR", "general_issue_code_display": "Foreign Relations", "description": "Advocacy in connection with gender equality and migration and refugee assistance, lobbying in connection with the humanitarian situation/response in Afghanistan and Ukraine, policy measures related to the U.S. Strategy to Prevent and Respond to Gender-Based Violence Globally, implementation of the executive order establishing the White House Gender Policy Council and implementation of the US national strategy on gender equity and equality, briefings on gender-based violence in humanitarian emergencies, human rights of Afghan women and girls, and on girls education in Afghanistan, Afghan refugee resettlement policy, confirmation of the Ambassador-at-Large for Global Womens Issues; policy measures related to the forthcoming Womens Economic Security Strategy; policy measures related to the draft USAID Gender Equality and Female Empowerment policy Legislation: FY23 Appropriations for State and Foreign Operations bill H.R. 8282 (sections related to gender equality), FY24 Presidents Budget Request, S. 765, Keeping Women and Girls Safe from the Start Act; forthcoming legislation regarding the status of women in Afghanistan; H.R. 571, the Safe from the Start Act, H.R. 4350, National Defense Authorization Act; forthcoming re-introduction of the International Violence Against Women Act; S. 2276, Keeping Girls in School Act; Senate Appropriations for State and Foreign Operations bill (sections related to gender equality); S. 4653, Department of State Authorization Act;", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 106201, "prefix": null, "prefix_display": null, "first_name": "GAYATRI", "nickname": null, "middle_name": null, "last_name": "PATEL", "suffix": null, "suffix_display": null}, "covered_position": "Senior Foreign Affairs Officer, U.S. Department of State, September 2005-May 2012 and June 2013-September 2015", "new": false}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 196, "name": "U.S. Agency for International Development (USAID)"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} NY US   NY NY US US   0 0           20000.0

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 0.34ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy