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

9 rows where filing_uuid = "472bf7d3-381c-4b73-b18c-c3ec4f76e4e6" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 9

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
955556 AMERICAN LIBRARY ASSOCIATION 472bf7d3-381c-4b73-b18c-c3ec4f76e4e6 Q2 AMERICAN LIBRARY ASSOCIATION 2786 AMERICAN LIBRARY ASSOCIATION 2010 second_quarter CIV HR780 Student Internet Saftey Act of 2009; HR1076 Internet SAFETY Act of 2009; HR1304 Free Speech Protection Act of 2009; HR1966 Megan Meier Cyberbullying Prevention Act; S. 1686 - Judicious Use of Surveillance Tools In Counterterrorism Efforts Act of 2009; S. 1692 - USA PATRIOT Act Sunset Extension Act of 2009; S. 1726 - USA PATRIOT Reauthorization and Additional Weapons Against Terrorism Act of 2009; HR 1467 - Safe and Secure America Act of 2009; HR 2765 - To amend Title 28, United States Code, to prohibit recognition and enforcement of foreign defamation judgments and certain foreign judgments against the providers of interactive computer services; S449 - Free Speech Protection Act of 2009; S.1745 - A bill to expand whistleblower protections to non-Federal employees whose disclosures involve misuse of Federal funds; HR 4892 - Enemy Belligerent Interrogation, Detention, and Prosecution Act of 2010; S3518 Securing the Protection of our Enduring and Established Constitutional Heritage (SPEECH) Act. Consumer Product Safety Commission (CPSC),HOUSE OF REPRESENTATIVES,SENATE   71572 0 0 2010-07-15T17:18:57.977000-04:00
955557 AMERICAN LIBRARY ASSOCIATION 472bf7d3-381c-4b73-b18c-c3ec4f76e4e6 Q2 AMERICAN LIBRARY ASSOCIATION 2786 AMERICAN LIBRARY ASSOCIATION 2010 second_quarter TEC HR691 Broadband Access Equality Act of 2009; HR 1910 Chief Technology Officer Act of 2009; S348/H.R.2135 A bill to amend section 254 of the Communications Act of 1934; H.R. 4619 - E-rate 2.0 Act of 2010; H.R. 3294 - Real Stimulus Act of 2009; S. 1836 - Internet Freedom Act of 2009. Consumer Product Safety Commission (CPSC),HOUSE OF REPRESENTATIVES,SENATE   71572 0 0 2010-07-15T17:18:57.977000-04:00
955558 AMERICAN LIBRARY ASSOCIATION 472bf7d3-381c-4b73-b18c-c3ec4f76e4e6 Q2 AMERICAN LIBRARY ASSOCIATION 2786 AMERICAN LIBRARY ASSOCIATION 2010 second_quarter CPT HR 801 Fair Copyright in Research Works; S379- Performance Reports Act; S 1373 Federal Research Public Access Act of 2009. Consumer Product Safety Commission (CPSC),HOUSE OF REPRESENTATIVES,SENATE   71572 0 0 2010-07-15T17:18:57.977000-04:00
955559 AMERICAN LIBRARY ASSOCIATION 472bf7d3-381c-4b73-b18c-c3ec4f76e4e6 Q2 AMERICAN LIBRARY ASSOCIATION 2786 AMERICAN LIBRARY ASSOCIATION 2010 second_quarter BUD HR 2847 - Jobs for Main Street Act, 2010; HR 3288 - Consolidated Appropriations Act, 2010; Supplemental Appropriations - Educators Jobs Amendment Consumer Product Safety Commission (CPSC),HOUSE OF REPRESENTATIVES,SENATE   71572 0 0 2010-07-15T17:18:57.977000-04:00
955560 AMERICAN LIBRARY ASSOCIATION 472bf7d3-381c-4b73-b18c-c3ec4f76e4e6 Q2 AMERICAN LIBRARY ASSOCIATION 2786 AMERICAN LIBRARY ASSOCIATION 2010 second_quarter CSP HR1692 Amendment to Product Safety Improvement Act; S389 Bill to establish conditional stay of the ban on lead in childrens products; HR 1692 a bill to exempt ordinary books from the Consumer Product Safety Improvement Act of 2008. Consumer Product Safety Commission (CPSC),HOUSE OF REPRESENTATIVES,SENATE   71572 0 0 2010-07-15T17:18:57.977000-04:00
955561 AMERICAN LIBRARY ASSOCIATION 472bf7d3-381c-4b73-b18c-c3ec4f76e4e6 Q2 AMERICAN LIBRARY ASSOCIATION 2786 AMERICAN LIBRARY ASSOCIATION 2010 second_quarter GOV S 612 OPEN FOIA Act of 2009; HR35 Presidential Records Act Amendments of 2009; HR 1692 a bill to exempt ordinary books from the Consumer Product Safety Improvement Act of 2008; HR 1323 Reducing Information Control Designations Act; HR 1387 Electronic Message Preservation Act; HR 946 Plain Language Act of 2009; HR553 Reducing Over-Classification Act of 2009; HR854 Over-Classification Reduction Act; S417 State Secrets Protection Act; S436 Internet Stopping Adults Facilitating the Exploitation of Todays Youth Act of 2009; S446 Bill to permit televising of Supreme Court proceedings; S574 Plain Writing Act of 2009; S590 Defense Communities Assistance Act of 2009; S. Res. 118 A resolution to provide Internet access to certain Congressional research Service publications; H.R. 3762 - Congressional Research Service Electronic Accessibility Act of 2009 HR 2256 Preserving the American Historical Record Act; S 372/HR 1507 Whistleblower Protection Enhancement Act of 2009; S.2872 - a bill to authorize appropriations for the National Historical Publications and Records Commission through FY 2014. Consumer Product Safety Commission (CPSC),HOUSE OF REPRESENTATIVES,SENATE   71572 0 0 2010-07-15T17:18:57.977000-04:00
955562 AMERICAN LIBRARY ASSOCIATION 472bf7d3-381c-4b73-b18c-c3ec4f76e4e6 Q2 AMERICAN LIBRARY ASSOCIATION 2786 AMERICAN LIBRARY ASSOCIATION 2010 second_quarter EDU Library Services and Technology Act Reauthorization; H.Res. 336-Suppporting the goals and ideals of National Library Week; HR 3221 - Student Aid and Fiscal Responsibility Act of 2009; HR3928 - Strengthening Kids' Interest in Learning and Libraries Act; HR 4037/S 2740 - Literacy Education for All, Results for the Nation Act; ESEA Reauthorization; Workforce Investment Act; H.Res 1222; S. 3206. Consumer Product Safety Commission (CPSC),HOUSE OF REPRESENTATIVES,SENATE   71572 0 0 2010-07-15T17:18:57.977000-04:00
955563 AMERICAN LIBRARY ASSOCIATION 472bf7d3-381c-4b73-b18c-c3ec4f76e4e6 Q2 AMERICAN LIBRARY ASSOCIATION 2786 AMERICAN LIBRARY ASSOCIATION 2010 second_quarter HOM HR122/S141 Protecting the Privacy of Social Security Numbers Act of 2009; HR220 Identity Theft Prevention Act; HR427 Notify Americans Before Outsourcing Personal Information Act; HR1467 Safe and Secure American Act of 2009; HR1617 Department of Homeland Security Component Privacy Officer Act of 2009; HR 1800 National Security Letters Reform Act of 2009; S773 Cybersecurity Act of 2009 Consumer Product Safety Commission (CPSC),HOUSE OF REPRESENTATIVES,SENATE   71572 0 0 2010-07-15T17:18:57.977000-04:00
955564 AMERICAN LIBRARY ASSOCIATION 472bf7d3-381c-4b73-b18c-c3ec4f76e4e6 Q2 AMERICAN LIBRARY ASSOCIATION 2786 AMERICAN LIBRARY ASSOCIATION 2010 second_quarter COM S3304 Equal Access to 21st Century Communications Act/HR3101 Twenty-first Century Communications and Video Accessibility Act of 2009. Consumer Product Safety Commission (CPSC),HOUSE OF REPRESENTATIVES,SENATE   71572 0 0 2010-07-15T17:18:57.977000-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);