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 = "d06d1c97-d9e3-4aa6-af92-a7b55152ea2a" and issue_code = "AGR" 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
1580280 NATIONAL ASSOCIATION FOR THE ADVANCEMENT OF COLORED PEOPLE d06d1c97-d9e3-4aa6-af92-a7b55152ea2a 2A NATIONAL ASSOCIATION FOR THE ADVANCEMENT OF COLORED PEOPLE 48975 NATIONAL ASSOCIATION FOR THE ADVANCEMENT OF COLORED PEOPLE 2014 second_quarter AGR Supported the plight of African American farmerswho were not part of the Pigford I or Pigford II settlement. Support the inclusion of the Healthy Food Financing Initiative (HFFI) amendment in H. R. 1947 / S. 954 Oppose Senator Vitters amendment 1056 to S.954, the Agriculture Reform, Food, and Jobs Act. Oppose Representative Reeds amendment #103 to H.R. 1947.Oppose Rep. Hudsons Amendment #22 to H.R. 1947 Oppose H.R. 1947. Oppose amendment #131 by Congressman Austin Scott (GA) to H.R. 1947. Oppose cuts to Supplemental Nutrition Assistance Program (SNAP) (Food Stamps) in H.R. 1947. Support the Gillibrand amendment to S. 954 to expand eligibility for the SNAP program, formerlly known as food stamps. Oppose the Roberts amendment to S. 954 to make it harder to qualify for the SNAP program, formerlly known as food stamps. Oppose Inhofe amendment to S. 954, which would repeal the SNAP program and make it a block grant to states and add a work requirement and drug testing requirements for recipients. Oppose amendment by Congressman Southerland to H.R. 1947 mandating work requirements of SNAP recipients. Oppose Huelskamp amendment to H.R. 1947 which would create a work requirement for SNAP recipients and repeal the nutrition education and obesity prevention programs. Oppose Schweikert amendment to H.R. 1947 striking funds for the Healthy Food Financing Inititative. Support the concerns of black, Southern farmers who may have been left out of the Pigford I or Pigford II settlement. Oppose H.R. 3102. Support current funding levels and eligibility standards for the Supplemental Nutrition Assistance Program (SNAP, formerly known as food stamps). Oppose proposed USDA rule to increase the line speed at poultry processing plants and to reduce the number of federal inspecters at poultry processing plants. Support the DeLauro (CT) amendment to H.R. 4800, the Appropriations bill for the U.S. Department of Agriculture (USDA) for Fiscal Year 2015, prohibiting the USDA from spending any funds to implement the Modernizat… Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Environmental Protection Agency (EPA),Equal Employment Opportunity Commission (EEOC),Federal Communications Commission (FCC),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Credit Union Administration (NCUA),Office of Personnel Management (OPM),Office of the Comptroller of the Currency (OCC),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),Treasury, Dept of,U.S. Commission on Civil Rights,Veterans Affairs, Dept of (VA),White House Office   68750 0 0 2014-08-15T12:47:59.567000-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);