lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "871b2be5-e90a-4155-9560-d3e8bf71ff1d", filing_year = 2016 and issue_code = "LAW" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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);