lobbying_activities

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

5 rows where filing_uuid = "a505e3cb-e7f4-48da-a74a-e2c8732dc278" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 5

filing_year 1

filing_period 1

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
997414 PHYSICIANS COMMITTEE FOR RESPONSIBLE MEDICINE a505e3cb-e7f4-48da-a74a-e2c8732dc278 Q3 PHYSICIANS COMMITTEE FOR RESPONSIBLE MEDICINE 400382759 PHYSICIANS COMMITTEE FOR RESPONSIBLE MEDICINE 2010 third_quarter SCI Meeting with House and Senate offices to seek support for ending wasteful and unnecessary NASA contract to conduct radiation research on nonhuman primates, including support for an amendment in H.R. 5781, the FY 2011 NASA Authorization Act. HOUSE OF REPRESENTATIVES,SENATE   151905 0 0 2010-10-18T12:31:30.980000-04:00
997415 PHYSICIANS COMMITTEE FOR RESPONSIBLE MEDICINE a505e3cb-e7f4-48da-a74a-e2c8732dc278 Q3 PHYSICIANS COMMITTEE FOR RESPONSIBLE MEDICINE 400382759 PHYSICIANS COMMITTEE FOR RESPONSIBLE MEDICINE 2010 third_quarter MED Urging members of Congress to co-sponsor H.R. 1326 and S. 3694, the Great Ape Protection Act, which would phase out invasive research on chimpanzees and retire chimpanzees owned by the federal government to permanent sanctuaries. HOUSE OF REPRESENTATIVES,SENATE   151905 0 0 2010-10-18T12:31:30.980000-04:00
997416 PHYSICIANS COMMITTEE FOR RESPONSIBLE MEDICINE a505e3cb-e7f4-48da-a74a-e2c8732dc278 Q3 PHYSICIANS COMMITTEE FOR RESPONSIBLE MEDICINE 400382759 PHYSICIANS COMMITTEE FOR RESPONSIBLE MEDICINE 2010 third_quarter DEF Urging members of Congress to co-sponsor and support H.R.4269, the Battlefield Excellence through Superior Training Practices (BEST Practices) Act. Seeking to place language in Defense Authorization and Defense Appropriations bills to improve and enhance DOD's medical training practices for combat trauma treatment and chemical casualty management. HOUSE OF REPRESENTATIVES,SENATE   151905 0 0 2010-10-18T12:31:30.980000-04:00
997417 PHYSICIANS COMMITTEE FOR RESPONSIBLE MEDICINE a505e3cb-e7f4-48da-a74a-e2c8732dc278 Q3 PHYSICIANS COMMITTEE FOR RESPONSIBLE MEDICINE 400382759 PHYSICIANS COMMITTEE FOR RESPONSIBLE MEDICINE 2010 third_quarter CHM In legislation to reform the Toxic Substances Control Act (TSCA), including H.R. 5820, the Toxic Chemicals Safety Act, and S. 3209, the Safe Chemicals Act, seeking inclusion of language to modernize testing methods for industrial chemicals and reduce reliance on inefficient, outdated, and unreliable animal-based testing methods. HOUSE OF REPRESENTATIVES,SENATE   151905 0 0 2010-10-18T12:31:30.980000-04:00
997418 PHYSICIANS COMMITTEE FOR RESPONSIBLE MEDICINE a505e3cb-e7f4-48da-a74a-e2c8732dc278 Q3 PHYSICIANS COMMITTEE FOR RESPONSIBLE MEDICINE 400382759 PHYSICIANS COMMITTEE FOR RESPONSIBLE MEDICINE 2010 third_quarter EDU H.R. 4870, the Healthy School Meals Act of 2010, legislation to amend the Child Nutrition Act to assist schools participating in the National School Lunch and Breakfast program with additional resources to provide students healthier meals, including a pilot program to test plant-based options for the USDA commodities program. Advocating for passage of H.R. 5504, the Improving Nutrition for America's Children Act, which incorporates provisions of H.R. 4870. HOUSE OF REPRESENTATIVES,SENATE   151905 0 0 2010-10-18T12:31:30.980000-04:00

Advanced export

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

CSV options: 

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);