lobbying: lobbying_activities: 11 rows where filing_uuid = "bb3f230d-e384-4ec3-b66a-c66a5bfa5222" sorted by filing

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

11 rows where filing_uuid = "bb3f230d-e384-4ec3-b66a-c66a5bfa5222" sorted by filing_year descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id	filing_uuid	filing_type	registrant_name	registrant_id	client_name	filing_year ▲	filing_period	issue_code	specific_issues	government_entities	expense_amount	received_date
776980	NATIONAL FRATERNAL ORDER OF POLICE bb3f230d-e384-4ec3-b66a-c66a5bfa5222	Q1	NATIONAL FRATERNAL ORDER OF POLICE	27866	NATIONAL FRATERNAL ORDER OF POLICE	2009	first_quarter	CON	H.J.Res. 8/S. J. Res. 2, would amend the Constitution to give Congress the power to prohibit the physical desecration of the flag of the United States; S. 650, the Federal Death Penalty Abolition Act, would abolish the death penalty option for all Federal crimes which currently carry that penalty.	Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,Veterans Affairs, Dept of (VA),White House Office	55000	2009-04-21T13:18:21-04:00
776981	NATIONAL FRATERNAL ORDER OF POLICE bb3f230d-e384-4ec3-b66a-c66a5bfa5222	Q1	NATIONAL FRATERNAL ORDER OF POLICE	27866	NATIONAL FRATERNAL ORDER OF POLICE	2009	first_quarter	TAX	H.R. 235/S. 484, the Social Security Fairness Act, would repeal both the Windfall Elimination Provision and the Government Pension Offset in current Social Security law; H.R. 1221/S. 490, the Public Servant Retirement Protection Act, would repeal the Windfall Elimination Provision (WEP) and replace it with a more equitable, individualized calculation of Social Security benefits; and Opposition to legislation which would mandate participation in Social Security for all newly hired State and local employees.	Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,Veterans Affairs, Dept of (VA),White House Office	55000	2009-04-21T13:18:21-04:00
776982	NATIONAL FRATERNAL ORDER OF POLICE bb3f230d-e384-4ec3-b66a-c66a5bfa5222	Q1	NATIONAL FRATERNAL ORDER OF POLICE	27866	NATIONAL FRATERNAL ORDER OF POLICE	2009	first_quarter	RET	H.R. 673, the Law Enforcement Officers Equity Act, would provide 6 (c) benefits to approximately 30,000 Federal law enforcement officers who currently do not have them; H.R. 958, the Federal Employee Retirement System Sick Leave Equity Act, would allow Federal employees under FERS to be credited for unused sick time.	Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,Veterans Affairs, Dept of (VA),White House Office	55000	2009-04-21T13:18:21-04:00
776983	NATIONAL FRATERNAL ORDER OF POLICE bb3f230d-e384-4ec3-b66a-c66a5bfa5222	Q1	NATIONAL FRATERNAL ORDER OF POLICE	27866	NATIONAL FRATERNAL ORDER OF POLICE	2009	first_quarter	CIV	H.R. 59, the Ex-Offender Voting Rights Act, would restore the right to vote in Federal elections to released felons who are denied that right by the State in which they reside; H.R. 1972, the Law Enforcement Officers Procedural Bill of Rights Act, would protect the due process rights of officers during internal investigations;	Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,Veterans Affairs, Dept of (VA),White House Office	55000	2009-04-21T13:18:21-04:00
776984	NATIONAL FRATERNAL ORDER OF POLICE bb3f230d-e384-4ec3-b66a-c66a5bfa5222	Q1	NATIONAL FRATERNAL ORDER OF POLICE	27866	NATIONAL FRATERNAL ORDER OF POLICE	2009	first_quarter	VET	S. 252, the "Veterans Health Care Authorization Act," specifically, language that would expand the arrest authority of the VA Police Service.	Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,Veterans Affairs, Dept of (VA),White House Office	55000	2009-04-21T13:18:21-04:00
776985	NATIONAL FRATERNAL ORDER OF POLICE bb3f230d-e384-4ec3-b66a-c66a5bfa5222	Q1	NATIONAL FRATERNAL ORDER OF POLICE	27866	NATIONAL FRATERNAL ORDER OF POLICE	2009	first_quarter	HOU	H.R. 583, the Community Partners Next Door Act, would establish a housing program that would provide a fifty percent (50%) discount for teachers, teacher assistants, administrators, and public safety officers purchasing certain eligible asset properties for use as their primary residence, including a $100 downpayment on any related insured mortgage, and a higher Federal Housing Administration (FHA) loan limit for such purchases in high-cost areas	Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,Veterans Affairs, Dept of (VA),White House Office	55000	2009-04-21T13:18:21-04:00
776986	NATIONAL FRATERNAL ORDER OF POLICE bb3f230d-e384-4ec3-b66a-c66a5bfa5222	Q1	NATIONAL FRATERNAL ORDER OF POLICE	27866	NATIONAL FRATERNAL ORDER OF POLICE	2009	first_quarter	BUD	H.R. 1, the "American Recovery and Reinvestment Act," specifically the inclusion of additional funding for the Edward J. Byrne Justice Assistance Grant (Byrne-JAG) programs thorugh 2012; H.R. 68, the No More Tulias: Drug Law Enforcement Evidentiary Standards Improvement Act, which would significantly limit States who fund anti-drug task forces from receiving Federal funding from the Edward J. Byrne Memorial Justice Assistant Grants program; and H.R. 1139/S. 167, the COPS Improvements Act, which would provide full funding for the Office of Community Oriented Policing Services (COPS) and the programs it administers.	Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,Veterans Affairs, Dept of (VA),White House Office	55000	2009-04-21T13:18:21-04:00
776987	NATIONAL FRATERNAL ORDER OF POLICE bb3f230d-e384-4ec3-b66a-c66a5bfa5222	Q1	NATIONAL FRATERNAL ORDER OF POLICE	27866	NATIONAL FRATERNAL ORDER OF POLICE	2009	first_quarter	EDU	H.R. 959, the "Officer Daniel Faulkner Children of Fallen Heroes Scholarship Act," would provide increased Federal Pell Grants for children whose parent or guardian died as a result of performing duties of a law enforcement or other public safety officer.	Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,Veterans Affairs, Dept of (VA),White House Office	55000	2009-04-21T13:18:21-04:00
776988	NATIONAL FRATERNAL ORDER OF POLICE bb3f230d-e384-4ec3-b66a-c66a5bfa5222	Q1	NATIONAL FRATERNAL ORDER OF POLICE	27866	NATIONAL FRATERNAL ORDER OF POLICE	2009	first_quarter	LBR	H.R. 413, the Public Safety Employer-Employee Cooperation Act, would recognize the right of law enforcement and other public safety officers to bargain collectively with their employers; H.R. 1409/S. 560, the Employee Free Choice Act, which would replace the current democratic process of secret ballots in the selection or certification on a union as the bargaining units with a card check system.	Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,Veterans Affairs, Dept of (VA),White House Office	55000	2009-04-21T13:18:21-04:00
776989	NATIONAL FRATERNAL ORDER OF POLICE bb3f230d-e384-4ec3-b66a-c66a5bfa5222	Q1	NATIONAL FRATERNAL ORDER OF POLICE	27866	NATIONAL FRATERNAL ORDER OF POLICE	2009	first_quarter	COM	S. 328/S. 352, the "DTV Delay Act," legislation delaying the date for transition from broadcast to digital; Ongoing issues with respect to the rebanding of public safety spectrum in the 700/800MHz band	Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,Veterans Affairs, Dept of (VA),White House Office	55000	2009-04-21T13:18:21-04:00
776990	NATIONAL FRATERNAL ORDER OF POLICE bb3f230d-e384-4ec3-b66a-c66a5bfa5222	Q1	NATIONAL FRATERNAL ORDER OF POLICE	27866	NATIONAL FRATERNAL ORDER OF POLICE	2009	first_quarter	LAW	H.R. 18, the Powder-Crack Cocaine Penalty Equalization Act, would eliminate the disparity in sentencing between crack and powder cocaine offenses by changing the applicable amounts for powder cocaine to those currently applicable to crack cocaine; H.R. 73, the Traffic Stops Along the Border Statistics Study Act, would require the U.S. Attorney General to collect race and other data on traffic stops made by State and local law enforcement officers; H.R. 248, the Law Enforcement Officers Flag Memorial Act, would provide the families of deceased law enforcement officers with a flag that has been flown over the U.S. Capitol; H.R. 675, legislation which would grant statutory arrest authority to law enforcement officers employed by the U.S. Department of Defense; H.R. 1006/S. 418, the Secondary Metal Theft Prevention Act, would require secondary metal recycling agents to keep records of their transactions in order to deter individuals and enterprises engaged in the theft and interstate sale of stolen secondary metal; S. 132, the Gang Abatement and Prevention Act, is a comprehensive, national approach to the problem of gang violence which would establish a High Intensity Interstate Gang Activity Area (HIIGAA) program to facilitate greater cooperation between local, State and Federal law enforcement in identifying, targeting, and eliminating violent gangs in areas where gang activity is particularly prevalent and define new offenses which will enable law enforcement to fight gangs and gang-related activity more effectively; S. 256, the Combat Methamphetamine Enhancement Act, will strengthen Federal law by improving the self-certification process for retail sales of ephedrine and pseudoephedrine; S. 258, the Saving Kids from Dangerous Drugs Act, would increase penalties on those who tailor-market illegal drugs to entice children to purchase them; S. 386, the Fraud Enforcement and Recovery Act, which would strengthen the ability of law enforcement to investigate and prosecute fraudulent activity in connection wit…	Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,Veterans Affairs, Dept of (VA),White House Office	55000	2009-04-21T13:18:21-04:00

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE lobbying_activities (
            id INTEGER PRIMARY KEY,
            filing_uuid TEXT NOT NULL,
            filing_type TEXT NOT NULL,
            registrant_name TEXT NOT NULL,
            registrant_id INTEGER,
            client_name TEXT NOT NULL,
            filing_year INTEGER NOT NULL,
            filing_period TEXT NOT NULL,
            issue_code TEXT,
            specific_issues TEXT,
            government_entities TEXT,
            income_amount INTEGER,
            expense_amount INTEGER,
            is_no_activity INTEGER DEFAULT 0,
            is_termination INTEGER DEFAULT 0,
            received_date TEXT,
            CONSTRAINT fk_activity_filing FOREIGN KEY (filing_uuid)
                REFERENCES lobbying_filings_raw(filing_uuid)
        );
CREATE INDEX idx_act_client_name ON lobbying_activities(client_name COLLATE NOCASE);
CREATE INDEX idx_act_issue_code ON lobbying_activities(issue_code);
CREATE INDEX idx_act_filing_year ON lobbying_activities(filing_year);
CREATE INDEX idx_act_filing_uuid ON lobbying_activities(filing_uuid);