home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 82977bf8-e7f2-4fef-9197-39c3d19bc55c

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
82977bf8-e7f2-4fef-9197-39c3d19bc55c Q3 54255 ADVOCATES FOR YOUTH 158843 ADVOCATES FOR YOUTH 2012 third_quarter 2012-10-11T10:41:58.333000-04:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/82977bf8-e7f2-4fef-9197-39c3d19bc55c/", "filing_uuid": "82977bf8-e7f2-4fef-9197-39c3d19bc55c", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2012, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/82977bf8-e7f2-4fef-9197-39c3d19bc55c/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "30000.00", "expenses_method": "b", "expenses_method_display": "Method B - Reporting amounts under section 6033(b)(8) of the Internal Revenue Code", "posted_by_name": "Janine Kossen, Director of Public Policy", "dt_posted": "2012-10-11T10:41:58.333000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "2000 M STREET, NW, #750", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20036", "registrant": {"id": 54255, "url": "https://lda.senate.gov/api/v1/registrants/54255/", "house_registrant_id": 35034, "name": "ADVOCATES FOR YOUTH", "description": "Domestic and International Health Policy", "address_1": "1325 G St. NW", "address_2": "Suite 980", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20005-2000", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "DIANA RHODES", "contact_telephone": "+1 202-419-3420", "dt_updated": "2022-04-06T16:07:54.293138-04:00"}, "client": {"id": 158843, "url": "https://lda.senate.gov/api/v1/clients/158843/", "client_id": 12, "name": "ADVOCATES FOR YOUTH", "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": "2008-04-29"}, "lobbying_activities": [{"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "contraception and family planning, comprehensive sexuality education, teen pregnancy prevention, abortion, domestic HIV/AIDS, LGBTQ youth, funding for Labor-Health and Human Services-Education H.R. 3324, Real Education for Healthy Youth Act (comprehensive sexuality education)\nS. 1782, Real Education for Healthy Youth Act (comprehensive sexuality education)\nFY13 Funding for Department of Health and Human Services (Division of Adolescent School Health, Teen Pregnancy Prevention Initiative, Title X family planning, Planned Parenthood)\n\nCommunicated with federal agencies listed on issues related to contraception and family planning, comprehensive sexuality education, teen pregnancy prevention, abortion, domestic HIV/AIDS, LGBTQ youth, and school health.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 51455, "prefix": null, "prefix_display": null, "first_name": "SARAH", "nickname": null, "middle_name": null, "last_name": "AUDELO", "suffix": null, "suffix_display": null}, "covered_position": null, "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)"}]}, {"general_issue_code": "FOR", "general_issue_code_display": "Foreign Relations", "description": "international family planning, sexual and reproductive health, abortion, foreign assistance, global HIV/AIDS, LGBTQ rights, funding for State-Foreign Operations, United Nations H.R. 2639, Global Democracy Promotion Act (Mexico City Policy)\nS. 1585, Global Democracy Promotion Act (Mexico City Policy)\nFY13 Funding for State-Foreign Operations (international family planning, sexual and reproductive health, global HIV/AIDS, UNFPA, Mexico City policy, Peace Corps)\n\nCommunicated with federal agencies listed on issues related to international family planning, sexual and reproductive health, abortion, foreign assistance, global HIV/AIDS, LGBTQ rights, United Nations, and funding for State-Foreign Operations.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 51453, "prefix": "ms", "prefix_display": "MS.", "first_name": "JANINE", "nickname": null, "middle_name": null, "last_name": "KOSSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "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)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 35034 DC DC US US   0 0 971066   normalized_name_state 0.9

Links from other tables

  • 2 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.908ms