lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
19 rows where filing_uuid = "615aec07-e9d8-47a4-97d9-2bf457cefdd4" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 544615 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | VET | H.R. 2642 - Military Construction and Veterans Affairs Appropriations Act, 2008, Title II, all provisions relating to Department of Veterans Affairs; all provisions relating to medical services. | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544616 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | URB | H.R. 3074 - Transportation, Housing and Urban Development, and Related Agencies Appropriations Act, 2008, Title I, all provisions rel to Dept of Transportation; all provisions rel to research, engineering, and development; all prov rel to grants-in-aid for airports; all prov rel to railroad research and development; all prov rel to research and university research centers; all provisions relating to research and development; all provisions relating to Office of the Assistant Secretary for Policy Development and Research. | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544617 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | AGR | H.R. 2419 - Farm, Nutrition, and Bioenergy Act of 2007, Title VII, all provisions relating to research; Sec. 7103, all provisions relating to additional purposes of agricultural research and extension; Sec. 7105, all provisions relating to establishment of competitive grant programs under the National Institute for Food and Agriculture; | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544618 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | AER | H.R. 2272 (Pub. L. No. 110-069) - America Creating Opportunities to Meaningfully Promote Excellence in Technology, Education, and Science Act, Title I, all provisions relating to Office of Science and Technology Policy; Government-Wide Science, Sec. 1001, all provisions relating to National Science and Technology Summit; Sec. 1004, all provisions relating to semiannual science, technology, engineering, and mathematics days; Sec. 1006, all provisions relating to President's Council on | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544619 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | TRA | H.R. 3074 - Transportation, Housing and Urban Development, and Related Agencies Appropriations Act, 2008, Title I, all provisions rel to Dept of Transportation; all provisions rel to research, engineering, and development; all prov rel to grants-in-aid for airports; all prov rel to railroad research and development; all prov rel to research and university research centers; all provisions relating to research and development; all provisions relating to Office of the Assistant Secretary for Policy Development and Research. | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544620 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | CPT | H.R. 1908 - Patent Reform Act of 2007, Sec. 3, all provisions relating to right of the first inventor to file; Sec. 4, all provisions relating to inventor's oath or declaration; Sec. 5, all provisions relating to right of the inventor to obtain damages; Sec. 6, all provisions relating to post-grant procedures and other quality enhancements; Sec. 7, all provisions relating to definitions; patent trial and Appeal Board. | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544621 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | HCR | H.R. 2406 - Healthcare Information Technology Enterprise Integration Act, Sec. 5, all provisions relating to research and development programs; Sec. (4), all provisions relating to research areas; Sec. (b), all provisions relating to National Information Technology Research and Development Program - The National High-Performance Computing Program established by section 101 of the High Performance Computing Act of 1991 (15 U.S.C. 5511); Sec. 6, all provisions relating to authorization of appropriations. | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544622 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | MMM | H.R. 3162 - Children's Health and Medicare Protection Act of 2007 - Title I, all provisions relating to Children's Health Insurance Program; Subtitle A, all provisions relating to funding; Sec. 101, all provisions relating to establishment of new base chip allotments; Sec. 102, all provisions relating to 2-year initial availability of CHIP allotments; Sec. 103, all provisions relating to redistribution of unused allotments to address state funding shortfalls; Sec. 104, all provisions relating to extension of option for qualifying states. | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544623 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | BUD | * H.R. 1232 - To establish a competitive grant program to build capacity in veterinary medical education and expand the workforce of veterinarians engaged in public health practice and biomedical research, Sec. 2 (a), all provisions relating to competitive grants program; (g), all provisions relating to authorization of appropriations. S. 294 - Passenger Rail Investment and Improvement Act of 2007, Title II, all provisions relating to Amtrak reform and operational improvements; Sec. 201, all provisions relating to National Railroad Passenger Transportation System defined; Sec. 209, all provisions relating to passenger train performance; Sec. 210, all provisions relating to long distance routes; Chapter 225, all provisions relating to state rail plans and high priority projects; Sec. 305, all provisions relating to Rail Cooperative Research S. 294 - Passenger Rail Investment and Improvement Act of 2007, Title II, all provisions relating to Amtrak reform and operational improvements; Sec. 201, all provisions relating to National Railroad Passenger Transportation System defined; Sec. 209, all provisions relating to passenger train performance; Sec. 210, all provisions relating to long distance routes; Chapter 225, all provisions relating to state rail plans and high priority projects; Sec. 305, all provisions relating to Rail Cooperative Research | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544624 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | ENV | H.R. 6 (Pub. L. No. 110-140) - Energy Independence and Security Act of 2007, Sec. 207, all provisions relating to grants for production of advanced biofuels; Subtitle B, all provisions relating to biofuels research and development; Sec. 234, all provisions relating to University-Based Research and Development Grant Program; Title III, all provisions relating to energy savings through improved standards for appliance and lighting; Subtitle B, all provisions relating to lighting energy efficiency; | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544625 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | ENG | H.R. 6 (Pub. L. No. 110-140) - Energy Independence and Security Act of 2007, Sec. 207, all provisions relating to grants for production of advanced biofuels; Subtitle B, all provisions relating to biofuels research and development; Sec. 234, all provisions relating to University-Based Research and Development Grant Program; Title III, all provisions relating to energy savings through improved standards for appliance and lighting; Subtitle B, all provisions relating to lighting energy efficiency; | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544626 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | EDU | H.R. 6 (Pub. L. No. 110-140) - Energy Independence and Security Act of 2007, Sec. 207, all prov rel to grants for production of advanced biofuels; Subtitle B, all prov rel to biofuels research and develop.; Sec. 234, all prov rel to Univ-Based Research and Development Grant Program; Title III, all prov rel to energy savings through improved standards for appliance and lighting; Subtitle B, all prov rel to lighting energy efficiency; Sec. 321, all prov rel to efficient light bulbs; Sec. 322, all prov rel to incandescent | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544627 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | HOM | H.R. 2638 - Department of Homeland Security Appropriations Act, 2008, Title IV, all provisions relating to research and development, training, and services; all provisions relating to science and technology; all provisions relating to research, development, acquisition, and operations. | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544628 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | MED | H.R. 3043 - Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act, 2008, Title II, all provisions relating to Department of Health and Human Services; all provisions relating to disease control, research, and training; all provisions relating to National Institutes of Health, all provisions relating to National Cancer Institute; all provisions relating to National Heart, Lung, and Blood Institute; all provisions relating to National Institute of Dental and Craniofacial | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544629 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | SCI | H.R. 6 (Pub. L. No. 110-140) - Energy Independence and Security Act of 2007, Sec. 207, all provisions relating to grants for production of advanced biofuels; Subtitle B, all provisions relating to biofuels research and development; Sec. 234, all provisions relating to University-Based Research and Development Grant Program; Title III, all provisions relating to energy savings through improved standards for appliance and lighting; Subtitle B, all provisions relating to lighting energy efficiency; | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544630 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | LAW | H.R. 1593 - Second Chance Act of 2007, Title I, all provisions relating to amendments related to the Omnibus Crime Control and Safe Streets Act of 1968; Sec. 101, all provisions relating to reauthorization of adult and juvenile offender state and local reentry demonstration projects; Title II, all provisions relating to enhanced drug treatment and mentoring grant programs; | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544631 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | IMM | S. 2205 - DREAM Act of 2007, Sec. 10, all provisions relating to higher education assistance. | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544632 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | DEF | H.R. 1585 - National Defense Authorization Act for Fiscal Year 2008, Title II, all provisions relating to Research, Development, Test, and Evaluation; Sec. 201, all provisions relating to authorization of appropriations; Sec. 202, all provisions relating to amount for defense science and technology. | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05:00 | |
| 544633 | UNIVERSITY OF ILLINOIS 615aec07-e9d8-47a4-97d9-2bf457cefdd4 | YY | UNIVERSITY OF ILLINOIS | 39427 | UNIVERSITY OF ILLINOIS | 2007 | year_end | AVI | H.R. 2764 - Consolidated Appropriations Act, 2008, Division B, all provisions relating to Commerce, Justice, Science, and Related Agencies Appropriations Act, 2008; Division A, all provisions relating to Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations Act, 2008; all provisions relating to Agricultural Research Service; | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2008-01-30T16:45:53.473000-05: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);