home / lobbying / lobbying_filings_raw

lobbying_filings_raw: aa5b1d07-e064-4784-85b4-e778f898d326

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
aa5b1d07-e064-4784-85b4-e778f898d326 Q2 14495 FIGHTING APARTHEID CONFRONTATION TRANSFORMATION SYSTEMS, INC. 120208 FIGHTING APARTHEID CONFRONTATION TRANSFORMATION SYSTEMS INC 2020 second_quarter 2020-06-09T21:22:38.177000-04:00   0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/aa5b1d07-e064-4784-85b4-e778f898d326/", "filing_uuid": "aa5b1d07-e064-4784-85b4-e778f898d326", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2020, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/aa5b1d07-e064-4784-85b4-e778f898d326/print/", "filing_document_content_type": "text/html", "income": null, "expenses": null, "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Harold C. Hunter, Jr.", "dt_posted": "2020-06-09T21:22:38.177000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "209 UNDERWOOD ST., NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20012", "registrant": {"id": 14495, "url": "https://lda.senate.gov/api/v1/registrants/14495/", "house_registrant_id": 33530, "name": "FIGHTING APARTHEID CONFRONTATION TRANSFORMATION SYSTEMS, INC.", "description": null, "address_1": "209 UNDERWOOD ST., NW", "address_2": null, "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20012", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "HAROLD C. HUNTER, JR.", "contact_telephone": "+1 202-997-8909", "dt_updated": "2025-06-02T20:48:00.706578-04:00"}, "client": {"id": 120208, "url": "https://lda.senate.gov/api/v1/clients/120208/", "client_id": 12, "name": "FIGHTING APARTHEID CONFRONTATION TRANSFORMATION SYSTEMS INC", "general_description": "GENTRIFICATION IN WASHINGTON, D.C., MARYLAND, AND VIRGINIA", "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": "1996-02-14"}, "lobbying_activities": [{"general_issue_code": "CIV", "general_issue_code_display": "Civil Rights/Civil Liberties", "description": "George Floyds brother will testify on June, Wednesday 10, 2020 at a congressional hearing.\nMr. Floyd will testify before the House Judiciary Committee, alongside more than half a dozen civil rights experts and activists, at a hearing designed to examine measures that Democrats unveiled on Monday, intended to reduce police misconduct and racial discrimination in law enforcement.\nHouse Republicans invited Dan Bongino, the conservative political commentator and former Secret Service agent, to testify. They also invited Angela Underwood Jacobs, whose brother, Dave Patrick Underwood, a Federal Protective Services officer, was shot and killed late last month during a night of unrest in Oakland, Calif.\nSenate Republican leaders said on Tuesday that they plan their own legislative push on the issues of racial discrimination and police brutality, to be led by Tim Scott of South Carolina, the only Republican senator who is African-American.\nThe Senate majority leader, Mitch McConnell of Kentucky, said his members would work on their own, without involving the White House, to put forward what we think is the appropriate response.\nWe are still wrestling with Americas original sin, Mr. McConnell told reporters on Capitol Hill. We try to get better, but every now and then it is perfectly clear we are a long way from the finish line.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7947, "prefix": null, "prefix_display": null, "first_name": "HAROLD", "nickname": null, "middle_name": "CARSON", "last_name": "HUNTER", "suffix": "jr", "suffix_display": "JR"}, "covered_position": "Registered Lobbyist", "new": false}], "government_entities": [{"id": 43, "name": "African Development Foundation"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 158, "name": "Bureau of Justice Statistics"}, {"id": 32, "name": "Education, Dept of"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 159, "name": "Natl Institute of Justice"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "Some Facts About Derek Chauvin: \n\nSome FACTS of Derek Chauvin:\nDerek Chauvin will remain as a lone alias, military intelligence, spiteful husband, or pre-mediated by previous association. The facts remain as an E4 military, former real estate agent and off duty police is responsible for the murder of George Floyd of this hideous act. \nVoted out of the same state as Donald Trump\nArmy man \nHe has also involved in the shooting cases of the police department.\nPart of the arrest was filmed by a bystander and streamed to Facebook Live. This video went viral.\nDerek Chauvin Was Arrested for the Death of George Floyd.\nFloyd and three of his colleagues were fired after mass protests broke out in Minneapolis. People appealed for justice for Floyd, demanding the officers be tried for his death.\nDerek Chauvin is set to appear in court on June 1. Meanwhile, he is reportedly on suicide watch while in isolation.\nDerek Chauvins spouse, Kellie Chauvin has also given her interview to the press and media upon the tragic death of George Floyd.\nThe local people of the city started the Black Lives matter movement from May 26 in their areas.\nThe protests continued in Los Angeles and Chicago. People started it peacefully and then turned violent.\nStill, people opposed the police actions; then, the officials used tear gas to stop the Protest.\nAn unknown bystander recorded video and made it viral on Facebook.\nDerek Chauvin knelt the multiracial persons neck for seven minutes resulted in his death on the roadside area.\nMedaria Arradondo (Minneapolis Police Chief) reacted on the case on May 26, 2020.\nA 10-minute video was posted to Facebook by a bystander. It paints an extremely troubling scene of what happened to George Floyd. You can watch it above, but its very disturbing.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7947, "prefix": null, "prefix_display": null, "first_name": "HAROLD", "nickname": null, "middle_name": "CARSON", "last_name": "HUNTER", "suffix": "jr", "suffix_display": "JR"}, "covered_position": "Registered Lobbyist", "new": false}], "government_entities": [{"id": 43, "name": "African Development Foundation"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 158, "name": "Bureau of Justice Statistics"}, {"id": 32, "name": "Education, Dept of"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 159, "name": "Natl Institute of Justice"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

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