home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 615aec07-e9d8-47a4-97d9-2bf457cefdd4

Raw lobbying disclosure filings from the Senate Office of Public Records (SOPR). Each row is a single filing — registrations, quarterly reports, amendments, and terminations. Includes registrant and client names, reported income/expenses, filing period, and the full raw JSON from the API.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date amount_reported is_amendment is_no_activity is_termination raw_json registrant_state registrant_country registrant_house_id client_state client_ppb_state client_country client_ppb_country client_general_description client_government_entity affiliated_org_count client_entity_id client_government_unit_id client_match_method client_match_confidence
615aec07-e9d8-47a4-97d9-2bf457cefdd4 YY 39427 UNIVERSITY OF ILLINOIS 147155 UNIVERSITY OF ILLINOIS 2007 year_end 2008-01-30T16:45:53.473000-05:00 40000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/615aec07-e9d8-47a4-97d9-2bf457cefdd4/", "filing_uuid": "615aec07-e9d8-47a4-97d9-2bf457cefdd4", "filing_type": "YY", "filing_type_display": "Year-End Report", "filing_year": 2007, "filing_period": "year_end", "filing_period_display": "Year-End (July 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/615aec07-e9d8-47a4-97d9-2bf457cefdd4/print/", "filing_document_content_type": "application/pdf", "income": null, "expenses": "40000.00", "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2008-01-30T16:45:53.473000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": null, "registrant_address_2": null, "registrant_different_address": null, "registrant_city": null, "registrant_state": null, "registrant_zip": null, "registrant": {"id": 39427, "url": "https://lda.senate.gov/api/v1/registrants/39427/", "house_registrant_id": 30153, "name": "UNIVERSITY OF ILLINOIS", "description": null, "address_1": "207 Administrative Office Building", "address_2": "1737 West Polk Street", "address_3": null, "address_4": null, "city": "Chicago", "state": "IL", "state_display": "Illinois", "zip": "60612", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "PAUL WEINBERGER", "contact_telephone": "+1 217-300-4739", "dt_updated": "2026-01-30T11:04:00.377550-05:00"}, "client": {"id": 147155, "url": "https://lda.senate.gov/api/v1/clients/147155/", "client_id": 12, "name": "UNIVERSITY OF ILLINOIS", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "IL", "state_display": "Illinois", "country": "US", "country_display": "United States of America", "ppb_state": "IL", "ppb_state_display": "Illinois", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-07-26"}, "lobbying_activities": [{"general_issue_code": "VET", "general_issue_code_display": "Veterans", "description": "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.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "URB", "general_issue_code_display": "Urban Development/Municipalities", "description": "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.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "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;", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "AER", "general_issue_code_display": "Aerospace", "description": "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", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "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.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "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.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "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.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "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.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "*\r\n\r\n\r\n\r\nH.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.\r\nS. 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\r\nS. 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", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "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;", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "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;", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "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", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "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.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "MED", "general_issue_code_display": "Medical/Disease Research/Clinical Labs", "description": "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", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "SCI", "general_issue_code_display": "Science/Technology", "description": "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;", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "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;", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "S. 2205 - DREAM Act of 2007, Sec. 10, all provisions relating to higher education assistance.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "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.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "AVI", "general_issue_code_display": "Aviation/Airlines/Airports", "description": "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;", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 11929, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "JEPSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25759, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "M", "last_name": "SCHOELL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} IL US 30153 IL IL US US   0 0 624710   alias 0.85

Links from other tables

  • 19 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 2.895ms