lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
9 rows where filing_uuid = "e01e45e2-eab3-4159-a396-5e4f14cab246" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: specific_issues, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 662345 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED e01e45e2-eab3-4159-a396-5e4f14cab246 | Q3 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 40041329 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 2008 | third_quarter | ENG | H.R. 3955, "Science Museum and National Laboratory Partnership Demonstration Act," Sec. 2.(b) (1-2), which relates to attendance figures, (d)(3), which relates to accreditation. | HOUSE OF REPRESENTATIVES,Institute of Museum and Library Services (IMLS),Natl Aeronautics & Space Administration (NASA),Natl Institutes of Health (NIH),Natl Oceanic & Atmospheric Administration (NOAA),Natl Science Foundation (NSF),SENATE | 0 | 0 | 2008-10-09T12:23:22-04:00 | ||
| 662346 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED e01e45e2-eab3-4159-a396-5e4f14cab246 | Q3 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 40041329 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 2008 | third_quarter | AER | S. 3182, Title III, Senate Report 110-397, Title III, FY 2009 Commerce, Justice, Science and Related Agencies Appropriations Act of 2009, National Aeronautics and Space Administration, Office of Education, provisions related to informal science education, provisions related to competitive grants for museums, science centers, and planetariums. | HOUSE OF REPRESENTATIVES,Institute of Museum and Library Services (IMLS),Natl Aeronautics & Space Administration (NASA),Natl Institutes of Health (NIH),Natl Oceanic & Atmospheric Administration (NOAA),Natl Science Foundation (NSF),SENATE | 0 | 0 | 2008-10-09T12:23:22-04:00 | ||
| 662347 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED e01e45e2-eab3-4159-a396-5e4f14cab246 | Q3 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 40041329 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 2008 | third_quarter | HCR | S. 3230, Title II, Senate Report 110-410, Title II, FY 2009 Labor, Health and Human Services, Education, and Related Agencies Appropriations Act of 2009, funding for the Department of Health and Human Services, National Institutes of Health, National Center for Research Resources, and the Science Education Partnership Award program. | HOUSE OF REPRESENTATIVES,Institute of Museum and Library Services (IMLS),Natl Aeronautics & Space Administration (NASA),Natl Institutes of Health (NIH),Natl Oceanic & Atmospheric Administration (NOAA),Natl Science Foundation (NSF),SENATE | 0 | 0 | 2008-10-09T12:23:22-04:00 | ||
| 662348 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED e01e45e2-eab3-4159-a396-5e4f14cab246 | Q3 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 40041329 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 2008 | third_quarter | MAR | (1) S. 3182, Title I, Senate Report 110-397, Title I, FY 2009 Commerce, Justice, Science and Related Agencies Appropriations Act of 2009, Department of Commerce, National Oceanic and Atmospheric Administration, provisions related to informal education. | HOUSE OF REPRESENTATIVES,Institute of Museum and Library Services (IMLS),Natl Aeronautics & Space Administration (NASA),Natl Institutes of Health (NIH),Natl Oceanic & Atmospheric Administration (NOAA),Natl Science Foundation (NSF),SENATE | 0 | 0 | 2008-10-09T12:23:22-04:00 | ||
| 662349 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED e01e45e2-eab3-4159-a396-5e4f14cab246 | Q3 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 40041329 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 2008 | third_quarter | BUD | (1) S. 3230, Title IV, Senate Report 110-410, Title IV, FY 2009 Labor, Health and Human Services, Education, and Related Agencies Appropriations Act of 2009, funding for the Institute of Museum and Library Services, all competitive grant programs related to museums. (2) S. 3230, Title II, Senate Report 110-410, Title II, FY 2009 Labor, Health and Human Services, Education, and Related Agencies Appropriations Act of 2009, funding for the Department of Health and Human Services, National Institutes of Health, National Center for Research Resources, and the Science Education Partnership Award program. (3) S. 3182, Title III, Senate Report 110-397, Title III, FY 2009 Commerce, Justice, Science and Related Agencies Appropriations Act of 2009, National Science Foundation, Directorate for Education and Human Resources, Division of Research on Learning in Formal and Informal Settings, Informal Science Education program, programs related to nanotechnology. (4) H.R. 2642, Supplemental Appropriations Act of 2008, Title II, Chapter 2, Commerce, Justice, and Science, Other Agencies, National Science Foundation, Directorate for Education and Human Resources, provisions related to informal and formal science education. (5) S. 3182, Title I, Senate Report 110-397, Title I, FY 2009 Commerce, Justice, Science and Related Agencies Appropriations Act of 2009, Department of Commerce, National Oceanic and Atmospheric Administration, provisions related to informal education. (6) S. 3182, Title III, Senate Report 110-397, Title III, FY 2009 Commerce, Justice, Science and Related Agencies Appropriations Act of 2009, National Aeronautics and Space Administration, Office of Education, provisions related to informal science education, provisions related to competitive grants for museums, science centers, and planetariums. (7) H.R. 2638/P.L. 110-329, Chapter 2, Commerce and Science, Consolidated Security, Disaster Assistance, and Continuing Appropriations Act, 2009, provisions related to supplemental funding for science and science educ… | HOUSE OF REPRESENTATIVES,Institute of Museum and Library Services (IMLS),Natl Aeronautics & Space Administration (NASA),Natl Institutes of Health (NIH),Natl Oceanic & Atmospheric Administration (NOAA),Natl Science Foundation (NSF),SENATE | 0 | 0 | 2008-10-09T12:23:22-04:00 | ||
| 662350 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED e01e45e2-eab3-4159-a396-5e4f14cab246 | Q3 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 40041329 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 2008 | third_quarter | EDU | (1) [Bill # Pending], "No Child Left Behind Act of 2001" reauthoriziation, "Miller-McKeon Discussion Draft," Title II, "Preparing, Training, and Recruiting High Quality Teachers and Principals," Section 2103, appropriations, inclusion of informal science education centers, eligible entities, Section 2113(c), "State Activities," inclusion of informal science education centers, Section 2123(a) "Local Use of Funds," inclusion of informal science education centers. (1 cont.) Section 2131, "Definitions," inclusion of informal science education centers, Section 2134, "Use of Funds," inclusion of informal science education centers and informal education, Section 2201, "Purpose; Definitions," inclusion of informal science education centers. (2) H.R. 4137/P.L. 110-315, Higher Education Opportunity Act, Title III, Section 315, Programs in STEM Fields, Subpart 2, Section 355, Programs in STEM Fields, Section 355, YES Partnerships Grant Program, Section 356, Promotion of Entry Into STEM Fields, Section 357, Evaluation and Accountability Plan, Section 402, Academic Competitiveness Grants, Section 404, Gaining Early Awareness and Readiness for Undergraduate Programs, Section 404D, Activities, Section 409, Robert C. Byrd Honors Scholarship Program, Section 428K (b) (14) STEM Employees, provisions related to informal and formal STEM education. | HOUSE OF REPRESENTATIVES,Institute of Museum and Library Services (IMLS),Natl Aeronautics & Space Administration (NASA),Natl Institutes of Health (NIH),Natl Oceanic & Atmospheric Administration (NOAA),Natl Science Foundation (NSF),SENATE | 0 | 0 | 2008-10-09T12:23:22-04:00 | ||
| 662351 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED e01e45e2-eab3-4159-a396-5e4f14cab246 | Q3 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 40041329 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 2008 | third_quarter | MED | S. 3230, Title II, Senate Report 110-410, Title II, FY 2009 Labor, Health and Human Services, Education, and Related Agencies Appropriations Act of 2009, funding for the Department of Health and Human Services, National Institutes of Health, National Center for Research Resources, and the Science Education Partnership Award program. | HOUSE OF REPRESENTATIVES,Institute of Museum and Library Services (IMLS),Natl Aeronautics & Space Administration (NASA),Natl Institutes of Health (NIH),Natl Oceanic & Atmospheric Administration (NOAA),Natl Science Foundation (NSF),SENATE | 0 | 0 | 2008-10-09T12:23:22-04:00 | ||
| 662352 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED e01e45e2-eab3-4159-a396-5e4f14cab246 | Q3 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 40041329 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 2008 | third_quarter | ART | (1) S. 3230, Title IV, Senate Report 110-410, Title IV, FY 2009 Labor, Health and Human Services, Education, and Related Agencies Appropriations Act of 2009, funding for the Institute of Museum and Library Services, all competitive grant programs related to museums. (2) [Bill # Pending] Reauthorization issues related to the Institute of Museum and Library Services, Chapter 72 of Title 20 of the U.S. Code (20 USC CHAPTER 72), the Museum and Library Services Act of 1996, the reauthorized Museum and Library Services Act of 2003. | HOUSE OF REPRESENTATIVES,Institute of Museum and Library Services (IMLS),Natl Aeronautics & Space Administration (NASA),Natl Institutes of Health (NIH),Natl Oceanic & Atmospheric Administration (NOAA),Natl Science Foundation (NSF),SENATE | 0 | 0 | 2008-10-09T12:23:22-04:00 | ||
| 662353 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED e01e45e2-eab3-4159-a396-5e4f14cab246 | Q3 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 40041329 | ASSOCIATION OF SCIENCE AND TECHNOLOGY CENTERS INCORPORATED | 2008 | third_quarter | SCI | (1) S. 3182, Title III, Senate Report 110-397, Title III, FY 2009 Commerce, Justice, Science and Related Agencies Appropriations Act of 2009, National Science Foundation, Directorate for Education and Human Resources, Division of Research on Learning in Formal and Informal Settings, Informal Science Education program, programs related to nanotechnology. (2) H.R. 5940, "National Nanotechnology Initiative Amendments Act of 2008," reauthorization of Public Law 108-153, "21st Century Nanotechnology Research and Development Act," provisions related to formal education, informal education, outreach. (3) H.R. 6014/S. 3047, "Enhancing Science, Technology, Engineering, and Mathematics Education Act of 2008," Section 3(6) regarding teacher preparation programs, Section 3(10) regarding partnerships, Section 5(9)(A-F) regarding annual meeting participants, and all provisions related to informal education. (4) H.R. 2642, Supplemental Appropriations Act of 2008, Title II, Chapter 2, Commerce, Justice, and Science, Other Agencies, National Science Foundation, Directorate for Education and Human Resources, provisions related to informal and formal science education. (5) H.R. 4137/P.L. 110-315, Higher Education Opportunity Act, Title III, Section 315, Programs in STEM Fields, Subpart 2, Section 355, Programs in STEM Fields, Section 355, YES Partnerships Grant Program, Section 356, Promotion of Entry Into STEM Fields, Section 357, Evaluation and Accountability Plan, Section 402, Academic Competitiveness Grants, Section 404, Gaining Early Awareness and Readiness for Undergraduate Programs, Section 404D, Activities, Section 409, Robert C. Byrd Honors Scholarship Program, Section 428K (b) (14) STEM Employees, provisions related to informal and formal STEM education. | HOUSE OF REPRESENTATIVES,Institute of Museum and Library Services (IMLS),Natl Aeronautics & Space Administration (NASA),Natl Institutes of Health (NIH),Natl Oceanic & Atmospheric Administration (NOAA),Natl Science Foundation (NSF),SENATE | 0 | 0 | 2008-10-09T12:23:22-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);