home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 4b2ec5b0-1c4e-457a-a4e0-adcbbc5720df

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
4b2ec5b0-1c4e-457a-a4e0-adcbbc5720df Q1 1741 AMERICAN ASSOCIATION OF UNIVERSITY WOMEN 102648 AMERICAN ASSOCIATION OF UNIVERSITY WOMEN 2020 first_quarter 2020-04-17T15:05:53.507000-04:00 12200.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/4b2ec5b0-1c4e-457a-a4e0-adcbbc5720df/", "filing_uuid": "4b2ec5b0-1c4e-457a-a4e0-adcbbc5720df", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2020, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/4b2ec5b0-1c4e-457a-a4e0-adcbbc5720df/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "12200.00", "expenses_method": "b", "expenses_method_display": "Method B - Reporting amounts under section 6033(b)(8) of the Internal Revenue Code", "posted_by_name": "Katherine Nielson", "dt_posted": "2020-04-17T15:05:53.507000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1310 L Street, NW", "registrant_address_2": "Suite 1000", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 1741, "url": "https://lda.senate.gov/api/v1/registrants/1741/", "house_registrant_id": 31717, "name": "AMERICAN ASSOCIATION OF UNIVERSITY WOMEN", "description": null, "address_1": "1310 L Street, NW", "address_2": "Suite 1000", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20005", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "GLORIA BLACKWELL", "contact_telephone": "+1 202-785-7767", "dt_updated": "2023-08-29T14:25:19.411056-04:00"}, "client": {"id": 102648, "url": "https://lda.senate.gov/api/v1/clients/102648/", "client_id": 12, "name": "AMERICAN ASSOCIATION OF UNIVERSITY WOMEN", "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-15"}, "lobbying_activities": [{"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "S. 874/H.R. 6/H.R. 2820, in support of allowing undocumented students, raised in the U.S., to go to college and have a pathway to citizenship.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 73044, "prefix": null, "prefix_display": null, "first_name": "KATHERINE", "nickname": null, "middle_name": null, "last_name": "NIELSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 50, "name": "Equal Employment Opportunity Commission (EEOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "In support of funding for the U.S. Equal Employment Opportunity Commission and its EEO-1 pay data collection", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 73044, "prefix": null, "prefix_display": null, "first_name": "KATHERINE", "nickname": null, "middle_name": null, "last_name": "NIELSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 50, "name": "Equal Employment Opportunity Commission (EEOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "H.R.2500 - In support of the National Defense Authorization Act for Fiscal Year 2020\nH.R.1534 - In support of the Federal Employee Paid Leave Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 73044, "prefix": null, "prefix_display": null, "first_name": "KATHERINE", "nickname": null, "middle_name": null, "last_name": "NIELSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 50, "name": "Equal Employment Opportunity Commission (EEOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CIV", "general_issue_code_display": "Civil Rights/Civil Liberties", "description": "S.J. Res. 6/H.J. Res. 38, Removing the deadline for the ratification of the equal rights amendmentin support of removing the deadline for the ratification of the equal rights amendment;\nS.J. Res. 15/H.J. Res. 35, Proposing an amendment to the Constitution of the United States relative to equal rights for men and women, in support of a constitutional amendment prohibiting or denying equality of rights under the law by the US or by any state on the account of sex;\nS. 788/H.R. 5, Equality Act, in support of anti-discrimination protections that include gender identity and sexual orientation;\nS. 561/H.R. 4, Voting Rights Advancement Act, in support of legislation to protect voting rights\nIn support of the full inclusion of transgender peoples' participation in athletics;\nIn opposition to repealing or weakening the Johnson Amendment;\nIn support of upholding the integrity, effectiveness, and full funding of the 2020 Census; in opposition to the addition of a citizenship question in the 2020 census;\nIn support of increasing access to the ballot box; \nIn support of the restoration of voting rights.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 73044, "prefix": null, "prefix_display": null, "first_name": "KATHERINE", "nickname": null, "middle_name": null, "last_name": "NIELSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 50, "name": "Equal Employment Opportunity Commission (EEOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "S. Res. 29/H. Res. 76, A resolution expressing support for the designation of a \"Women's Health Research Day,\" in support of increasing awareness of sex and gender-based biomedical research;\nIn support of quality, affordable, and accessible health care.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 73044, "prefix": null, "prefix_display": null, "first_name": "KATHERINE", "nickname": null, "middle_name": null, "last_name": "NIELSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 50, "name": "Equal Employment Opportunity Commission (EEOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FAM", "general_issue_code_display": "Family issues/Abortion/Adoption", "description": "S. 109, No Taxpayer Funding for Abortion and Abortion Insurance Full Disclosure Act of 2019, in opposition to restricting access to abortion services;\nS. 1645/H.R. 2975, Women's Health Protection Act, in support of ensuring access to reproductive health care.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 73044, "prefix": null, "prefix_display": null, "first_name": "KATHERINE", "nickname": null, "middle_name": null, "last_name": "NIELSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 50, "name": "Equal Employment Opportunity Commission (EEOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "S. 213/H.R. 787, SOAR Reauthorization Act of 2019, in opposition to school vouchers and diverting public funds to private or religious elementary and secondary schools;\nS. 737/H.R. 1665, Building Blocks of STEM Act, in support of increasing access to science, technology, engineering, and math (STEM) for young girls;\nS. 1964/H.R. 3513, Patsy T. Mink and Louise M. Slaughter Gender Equity in Education Act (GEEA), in support of Title IX and protections against gender discrimination in education;\nS. 808/H.R. 2421, ALERT Act, in support of accountability for Title IX violations;\nS. 1492/H.R. 2747, Tyler Clementi Higher Education Anti-Harassment Act of 2019, in support of enumerated anti-harassment policies at colleges and universities;\nH.R. 3381, Hold Accountable and Lend Transparency(HALT) on Campus Sexual Violence Act, in support of additional protections for survivors of campus sexual violence;\nH.R.2528, STEM Opportunities Actof 2019, in support of increasing access to science, technology, engineering, and math (STEM) for women and other underrepresented groups;\nIn support of protecting Title IX, its regulations, and guidance, in opposition to the recission of the Department of Education's 2011 Dear Colleague Letter on Sexual Violence and the 2014 Questions and Answers on Title IX and Sexual Violence;\nIn opposition to the rollback of the 2014 joint school discipline guidance package including the Joint Dear Colleague on the Nondiscriminatory Administration of School Discipline by the U.S. Department of Education and the U.S. Department of Justice;\nIn support of increasing access to higher education to students through campus-based childcare services;\nIn support of a comprehensive Higher Education Act reauthorization that protects women's economic security, equal educational opportunities, and safety;\nIn support of promoting safe, healthy and inclusive school environments in elementary and secondary school by addressing bullying and harassment, as well as disparities in school discipline that fuel school pushout and the school to prison pipeline for students of color and students with disabilities;\nIn support of comprehensive legislation to address disparate impact across civil rights laws.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 73044, "prefix": null, "prefix_display": null, "first_name": "KATHERINE", "nickname": null, "middle_name": null, "last_name": "NIELSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 50, "name": "Equal Employment Opportunity Commission (EEOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "S. 270/H.R. 7, Paycheck Fairness Act, in support of prohibiting retaliation against workers who inquire about employers wage practices or disclose their own wages, creating incentives for employers to follow antidiscrimination laws, and empowering women to negotiate for equal pay, in favor of prohibiting the use of salary and benefit history screening for prospective employees;\nS. 463/H.R. 1185, FAMILY Act, in support of paid family and medical leave;\nS. 150/H.R. 582, Raise the Wage Act, in support of raising the minimum wage;\nS. 840/H.R. 1784, Healthy Families Act, in support of providing paid sick and safe days for all workers;\nS. 575/H.R. 1521, EMPOWER Act - Part I, in support of ending workplace harassment;\nS. 574EMPOWER Act - Part II, in support of eliminating workplace harassment;\nS. 610/H.R. 1423, Forced Arbitration Injustice Repeal (FAIR) Act, in support of prohibiting pre-dispute arbitration agreements that force arbitration as a condition of employment;\nS. 1174/H.R. 1534, Federal Employee Paid Leave Act (FEPLA), in support of parental leave and flexible workplace policies for federal employees;\nS. 1082/H.R. 2148, Bringing an End to Harassment by Enhancing Accountability and Rejecting Discrimination (BE HEARD) in the Workplace Act, in support of ending workplace harassment;\nH.R. 2694, Pregnant Workers Fairness Act, in support of ensuring that pregnant workers are not fired or denied reasonable job modifications;\nPay Equity for All Act, Fair Pay Act, WAGE Equity Act, in support of prohibiting the use of salary and benefit history screening for prospective employees, in support of comparable worth, in support of solutions to close the gender pay gap;\nIn support of a resolution recognizing the significance of Equal Pay Day;\nS. 485/H.R. 1230, Protecting Older Workers Against Discrimination Act, in support of making clear that discrimination in the workplace because of a protected characteristic or activity is unlawful;\nIn support of the U.S. Equal Employment Opportunity Commission and its EEO-1 pay data collection.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 73044, "prefix": null, "prefix_display": null, "first_name": "KATHERINE", "nickname": null, "middle_name": null, "last_name": "NIELSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 50, "name": "Equal Employment Opportunity Commission (EEOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "H.R. 1585, Violence Against Women Reauthorization Act of 2019, in support of an inclusive VAWA reauthorization that supports all victims and improves campus safety.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 73044, "prefix": null, "prefix_display": null, "first_name": "KATHERINE", "nickname": null, "middle_name": null, "last_name": "NIELSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 50, "name": "Equal Employment Opportunity Commission (EEOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 31717 DC DC US US   0 0 990479   normalized_name_state 0.9

Links from other tables

  • 9 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 112.439ms