home / lobbying / lobbying_filings_raw

lobbying_filings_raw: ca9c3979-e31e-49cd-b9e1-cfda1d130fc1

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
ca9c3979-e31e-49cd-b9e1-cfda1d130fc1 Q3 306658 NATIONAL LGBTQ TASK FORCE FORMERLY KNOW AS: NATIONAL GAY AND LESBIAN TASK FORCE 182141 NATIONAL LGBTQ TASK FORCE FORMERLY KNOW AS NATIONAL GAY AND LESBIAN TASK FORCE 2012 third_quarter 2013-01-14T17:01:43.733000-05:00 391108.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/ca9c3979-e31e-49cd-b9e1-cfda1d130fc1/", "filing_uuid": "ca9c3979-e31e-49cd-b9e1-cfda1d130fc1", "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/ca9c3979-e31e-49cd-b9e1-cfda1d130fc1/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "391108.00", "expenses_method": "b", "expenses_method_display": "Method B - Reporting amounts under section 6033(b)(8) of the Internal Revenue Code", "posted_by_name": "Julie Childs, Executive Assistant", "dt_posted": "2013-01-14T17:01:43.733000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1325 MASSACHUSETTS AVENUE NW, 6TH FLOOR", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 306658, "url": "https://lda.senate.gov/api/v1/registrants/306658/", "house_registrant_id": 38253, "name": "NATIONAL LGBTQ TASK FORCE FORMERLY KNOW AS: NATIONAL GAY AND LESBIAN TASK FORCE", "description": "grassroots civil rights for gay, lesbian, bisexual and transgender community", "address_1": "1050 Connecticut Ave, NW Suite 65500", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20035", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "TIFFANY TRAN", "contact_telephone": "+1 202-639-6301", "dt_updated": "2023-12-11T17:00:10.741765-05:00"}, "client": {"id": 182141, "url": "https://lda.senate.gov/api/v1/clients/182141/", "client_id": 12, "name": "NATIONAL LGBTQ TASK FORCE FORMERLY KNOW AS NATIONAL GAY AND LESBIAN TASK FORCE", "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-16"}, "lobbying_activities": [{"general_issue_code": "ECN", "general_issue_code_display": "Economics/Economic Development", "description": "HR 4609 Social Security Equality Act. Lobbied in support of this bill.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 50938, "prefix": "ms", "prefix_display": "MS.", "first_name": "STACEY", "nickname": null, "middle_name": "LONG", "last_name": "SIMMONS", "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": "Uniting American Families Act HR 1024 and SB 424. Lobbied for allowing lesbian, gay, bisexual and transgender people in the United States who cannot get married and who's marriages are not recognized under federal law to sponsor partners for citizenship. and permanent resideny.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 50938, "prefix": "ms", "prefix_display": "MS.", "first_name": "STACEY", "nickname": null, "middle_name": "LONG", "last_name": "SIMMONS", "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": "IMM", "general_issue_code_display": "Immigration", "description": "The Dream Act HR 6497. Lobbied in support of a path to citizenship, higher education and the military.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 50938, "prefix": "ms", "prefix_display": "MS.", "first_name": "STACEY", "nickname": null, "middle_name": "LONG", "last_name": "SIMMONS", "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": "CIV", "general_issue_code_display": "Civil Rights/Civil Liberties", "description": "HR 3618 End Racial Profiling Act. Lobbied in support of this bill on the house side.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 50938, "prefix": "ms", "prefix_display": "MS.", "first_name": "STACEY", "nickname": null, "middle_name": "LONG", "last_name": "SIMMONS", "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": "Student Non Discrimination Act HR4530. Lobbied in support of prohibiting discrimination based on actual or percieved sexual orienation or gender identity in public schools and requring schools to address harrrassment against LGBT students and allowing schools to be sued or lose funding if they fail to comply.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 50938, "prefix": "ms", "prefix_display": "MS.", "first_name": "STACEY", "nickname": null, "middle_name": "LONG", "last_name": "SIMMONS", "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": []}

Links from other tables

  • 5 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 0.903ms