lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
4 rows where filing_uuid = "871b2be5-e90a-4155-9560-d3e8bf71ff1d" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: received_date (date)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | income_amount | expense_amount | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1850915 | NATIONAL RIFLE ASSOCIATION OF AMERICA 871b2be5-e90a-4155-9560-d3e8bf71ff1d | Q2 | NATIONAL RIFLE ASSOCIATION OF AMERICA | 28470 | NATIONAL RIFLE ASSOCIATION OF AMERICA | 2016 | second_quarter | CIV | H.R. 766; Financial Institution Customer Protection Act of 2015 - Prohibits a federal banking agency from formally or informally suggesting, requesting, or ordering a depository institution to terminate either a specific customer account, or group of customer accounts, or otherwise restrict or discourage it from entering into or maintaining a banking relationship with a specific customer or group of customers, unless: (1) the agency has a material reason to do so, and (2) the reason is not based solely on reputation risk. H.R. 1076 & S. 551; Denying Firearms and Explosives to Dangerous Terrorist Act of 2015 - Amends the federal criminal code to grant the Attorney General the authority to deny the transfer of firearms or the issuance of a federal firearms and explosives license to any individual if the Attorney General: (1) determines that such individual has been engaged in or has provided material support or resources for terrorist activities, and (2) has reasonable belief that such individual may use a firearm or explosive in connection with terrorism. Allows any individual whose firearm or explosives license application has been denied to bring legal action challenging the denial. H.R. 1217; Public Safety and Second Amendment Rights Protection Act of 2015 - Amends the Brady Handgun Violence Prevention Act to reauthorize for FY2016-FY2019 the grant program for improvements to the criminal history record system. H.R. 1413 & S. 477; Firearms Manufacturers and Dealers Protection Act of 2015 - Funds appropriated or otherwise made available, including amounts derived from any fee or other source, are denied to the Federal Deposit Insurance Corporation, the Department of Justice, or any other federal agency to carry out Operation Choke Point or any other program designed to discourage the provision or continuation of credit or the processing of payments by financial institutions for dealers and manufacturers of firearms and ammuntion. H.R. 1488; Protecting Gun Owners in Bankruptcy Act of 2015 - Amends federal ba… | Bureau of Alcohol Tobacco Firearms & Explosives,Bureau of Land Management (BLM),HOUSE OF REPRESENTATIVES,SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service | 810000 | 0 | 0 | 2016-07-19T13:26:03.707000-04:00 | |
| 1850916 | NATIONAL RIFLE ASSOCIATION OF AMERICA 871b2be5-e90a-4155-9560-d3e8bf71ff1d | Q2 | NATIONAL RIFLE ASSOCIATION OF AMERICA | 28470 | NATIONAL RIFLE ASSOCIATION OF AMERICA | 2016 | second_quarter | LAW | H.R. 86; Safe Students Act - Amends the federal criminal code to repeal provisions making it unlawful to possess or discharge a firearm in a school zone. H.R. 131 & S. 1308; Interstate Transportation of Firearms or Ammunition - To amend chapter 44 of title 18, United States Code, to more comprehensively address the interstate transportation of firearms or ammunition. H.R. 402; National Right-to-Carry Reciprocity Act of 2015 - Amends the federal criminal code to authorize a person who is carrying a valid, government-issued identification document containing that person's photograph and a valid permit to carry a concealed firearm in one state, and who is not prohibited from possessing, transporting, shipping, or receiving a firearm under federal law, to possess or carry a concealed handgun (other than a machine gun or destructive device) in another state in accordance with the restrictions of that state. H.R. 578 & S. 263; Recreational Lands Self-Defense Act of 2015 - Prohibits the Secretary of the Army from promulgating or enforcing any regulation that prohibits an individual from possessing a firearm at a water resources development project administered by the Chief of Engineers if: (1) the individual is not otherwise prohibited by law from possessing the firearm, and (2) the possession of the firearm is in compliance with the law of the state in which the project is located. H.R. 923 & S. 498; Constitutional Concealed Carry Reciprocity Act of 2015 - Amends the federal criminal code to authroize a person who is not prohibited from possessing, transporting, shipping, or receiving a firearm under federal law, who is entitled and not prohibited from carry a concealed firearm in his or her state of residence or who is carrying a valid state license or permit to carry a concealed weapon, and who is carrying a government-issued photographic identification document to carry a concealed handgun (which has been shipped or transported in interstate or foreign commerce, other than a machine gun or destructive device) in… | Bureau of Alcohol Tobacco Firearms & Explosives,Bureau of Land Management (BLM),HOUSE OF REPRESENTATIVES,SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service | 810000 | 0 | 0 | 2016-07-19T13:26:03.707000-04:00 | |
| 1850917 | NATIONAL RIFLE ASSOCIATION OF AMERICA 871b2be5-e90a-4155-9560-d3e8bf71ff1d | Q2 | NATIONAL RIFLE ASSOCIATION OF AMERICA | 28470 | NATIONAL RIFLE ASSOCIATION OF AMERICA | 2016 | second_quarter | FIR | H.R. 752 & S. 407; Large Capacity Ammunition Feeding Device Act - To prohibit the transfer or possession of large capacity ammunition feeding devices, and for other purposes. H.R. 1365; Ammunition and Firearms Protection Act - To prevent the reclassification of certain ammunition as armor piercing ammunition. H.R. 2613 & S. 1474; Handgun Trigger Safety Act of 2015 - To provide for the development and use of technology for personalized handguns, to require that all handguns manufactured or sold in, or imported into the United States incorporate such technology, and for other purposes. H.R. 2699 & S. 1735; Undetectable Firearms Modernization Act of 2015 - To modernize the Undetectable Firearms Act of 1988. H.R. 3802; Alternative Ammunition Manufacturing Act, To amend title 18, United States Code to provide for the disposition, within 60 days, of an application to exempt a projectile from classification as armor piercing ammunition. S. 2444; Alternative Ammunition Manufacturing Act - To amend title 18, United States Code, to provide for the disposition, within 60 days, of an application to exempt a projectile from classification as armor piercing ammunition. H.R. 4951; To amend chapter 44 of title 18, United States Code, to allow the importation of certain foreign-manufactured firearms components - To amend chapter 44 of title 18, United States Code, to allow the importation of certain foreign-manufactured firearms components | Bureau of Alcohol Tobacco Firearms & Explosives,Bureau of Land Management (BLM),HOUSE OF REPRESENTATIVES,SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service | 810000 | 0 | 0 | 2016-07-19T13:26:03.707000-04:00 | |
| 1850918 | NATIONAL RIFLE ASSOCIATION OF AMERICA 871b2be5-e90a-4155-9560-d3e8bf71ff1d | Q2 | NATIONAL RIFLE ASSOCIATION OF AMERICA | 28470 | NATIONAL RIFLE ASSOCIATION OF AMERICA | 2016 | second_quarter | NAT | H.R. 167; Wildfire Disaster Funding Act - Amends the Balanced Budget and Emergency Deficit Control Act of 1985 to require specified adjustments to discretionary spending limits in FY2015-FY2022 to accommodate appropriations for wildfire suppression operations in the Wildland Fire Management accounts at the Department of Agriculture (USDA) or the Department of the Interior. H.R. 327; Polar Bear Conservation and Fairness Act of 2015 - To amend the Marine Mammal Protection Act of 1972 to allow importation of polar bear trophies taken in sport hunts in Canada before the date the polar bear was determined to be a threatened species under the Endangered Species Act of 1973. H.R. 461; Wild Game Donation Act of 2015 - Amends the Internal Revenue Code to: (1) increase the tax deduction for charitable contributions of qualified wild game meat by the processing fees paid with respect to such contributions, and (2) exclude from the gross income of meat processors processing fees paid by a charitable organization for the processing of donated wild game meat. H.R. 528; Recreational Fishing and Hunting Heritage and Opportunities Act - To direct Federal public land management officials to exercise their authority under existing law to facilitate use of and access to Federal public lands for fishing, sport hunting, and recreational shooting, and for other purposes. H.R. 697 & S. 1769; African Elephant Conservation and Legal Ivory Possession Act of 2015 - To amend the African Elephant Conservation Act of 1988 to conserve elephants while appropriately regulating ivory in the United States. H.R. 1735; National Defense Authorization Act for Fiscal Year 2016 - To authorize appropriations for fiscal year 2016 for military activities of the Department of Defense and for military construction, to prescribe military personnel strengths for such fiscal year, and for other purposes. H.R. 2028; Energy and Water Development and Related Agencies Appropriations Act, 2016 - Making appropriations for energy and water development and related… | Bureau of Alcohol Tobacco Firearms & Explosives,Bureau of Land Management (BLM),HOUSE OF REPRESENTATIVES,SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service | 810000 | 0 | 0 | 2016-07-19T13:26:03.707000-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);