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

1 row where filing_uuid = "9d3b4443-cd62-41e2-afef-e76c8f1d49e4" and issue_code = "HCR" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 1

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
1214220 JAMES BACKLIN 9d3b4443-cd62-41e2-afef-e76c8f1d49e4 Q4 JAMES BACKLIN 400624898 CHRISTIAN COALITION OF AMERICA 2011 fourth_quarter HCR Protect Life Act, H.R. 358 Protect Life Act, S Title X Abortion Provider Prohibition Act, H.R. 217 No Taxpayer Funding for Abortion Act, H.R.3 Foxx Amendment on abortion funding and conscience protection in qualified teaching health centers, to H.R. 1216 H. Con Res 34, Establishing the budget for the United States Government for fiscal year 2012 and setting forth appropriate budgetary levels for fiscal years 2013 through 2021 Opposition to the Medicare Physicians Fairness Act called the Doc Fix bill Opposition to Democrat Health Care bill, H.R. 3962, in the House and the Senate Support for preventing tax dollars from being used for abortions in Democrat Health Care bill, H.R. 3962. Support for Congressman Pete Sessions resolution, H.Res.874, which would require that all roll-call votes in House committees be posted on their respective websites within 48 hours of each vote Support for Senator Orrin Hatchs amendments to restore abstinence funding ($50 million) in the Senate Financial Services Committees debate on their health care reform bill; and to prevent federal tax dollars from being used to fund abortions; and to protect the conscience rights of health care workers not to be forced to do abortions Congressman Doug Lanborns Schoolchildrens Health Protection Act, H.R. 2458 Support for Genetic Discrimination Ban Opposition to the expansion of the Childrens Health Insurance Program (SCHIP) H.R. 322, Alternative Pluripotent Stem Cell Act S. 51, Pluripotent Stem Cell Therapy Enhancement Act Opposition to H.R.3 and S.5, the Embryonic Stem Cell Destruction bill H.R.2564, Human Cloning Prohibition Act and opposed the phony ban (H.R. 2560) S.1036, Human Cloning Prohibition Act OPPOSITION to H.R. 1964 and S. 1173, Freedom of Choice Act H.R.618, Right to Life Act H.R.2597, Sanctity of Life Act H. J. Res. 20, Opposition to language in Continuing (Omnibus) Appropriations Bill, which would cut funding (Section 20613 [b]) for the early diagnosis of babies with AIDS. Opposition to legislation deleting $50 million in absti… HOUSE OF REPRESENTATIVES,SENATE     0 0 2012-01-21T00:13:33.700000-05: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);