home / lobbying / lobbying_filings_raw

lobbying_filings_raw: c8ed5d2c-555e-40c3-b33d-db8a2aa5b285

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
c8ed5d2c-555e-40c3-b33d-db8a2aa5b285 2@ 31680 PODESTA GROUP, INC. 138566 THE UNIVERSITY OF TEXAS M.D. ANDERSON CANCER CENTER 2009 second_quarter 2009-10-19T20:51:11-04:00 110000.0 0 0 1 {"url": "https://lda.senate.gov/api/v1/filings/c8ed5d2c-555e-40c3-b33d-db8a2aa5b285/", "filing_uuid": "c8ed5d2c-555e-40c3-b33d-db8a2aa5b285", "filing_type": "2@", "filing_type_display": "2nd Quarter - Termination Amendment", "filing_year": 2009, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/c8ed5d2c-555e-40c3-b33d-db8a2aa5b285/print/", "filing_document_content_type": "text/html", "income": "110000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Kimberley Fritts, CEO", "dt_posted": "2009-10-19T20:51:11-04:00", "termination_date": "2009-06-30", "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1001 G STREET, NW", "registrant_address_2": "SUITE 900 EAST", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 31680, "url": "https://lda.senate.gov/api/v1/registrants/31680/", "house_registrant_id": 31110, "name": "PODESTA GROUP, INC.", "description": "Public policy, government relations and public affairs firm", "address_1": "1001 G Street, NW", "address_2": "Suite 1000 West", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20001", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ANTHONY PODESTA", "contact_telephone": "+1 202-413-5027", "dt_updated": "2022-04-06T16:07:38.635383-04:00"}, "client": {"id": 138566, "url": "https://lda.senate.gov/api/v1/clients/138566/", "client_id": 1005294, "name": "THE UNIVERSITY OF TEXAS M.D. ANDERSON CANCER CENTER", "general_description": "Cancer Treatment Center", "client_government_entity": false, "client_self_select": false, "state": "TX", "state_display": "Texas", "country": "US", "country_display": "United States of America", "ppb_state": "TX", "ppb_state_display": "Texas", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2008-07-14"}, "lobbying_activities": [{"general_issue_code": "ANI", "general_issue_code_display": "Animals", "description": "Animal research", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 19724, "prefix": null, "prefix_display": null, "first_name": "ED", "nickname": null, "middle_name": null, "last_name": "ROTHSCHILD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 8004, "prefix": null, "prefix_display": null, "first_name": "SHARON", "nickname": null, "middle_name": null, "last_name": "COHEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 5760, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": null, "last_name": "TESSIER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46415, "prefix": "mr", "prefix_display": "MR.", "first_name": "THOMAS", "nickname": null, "middle_name": "B", "last_name": "SPARKMAN", "suffix": null, "suffix_display": null}, "covered_position": "Health Policy Intern, Senate HELP Committee", "new": false}, {"lobbyist": {"id": 27998, "prefix": null, "prefix_display": null, "first_name": "RANDALL", "nickname": null, "middle_name": null, "last_name": "GERARD", "suffix": null, "suffix_display": null}, "covered_position": "Senate Commerce, Science & Transportation Cmte", "new": false}, {"lobbyist": {"id": 27144, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "MADDOX", "suffix": null, "suffix_display": null}, "covered_position": "Communications Dir., House Republican Confer.", "new": false}, {"lobbyist": {"id": 13869, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "SCOFIELD", "suffix": null, "suffix_display": null}, "covered_position": "Assistant Press Secretary, Sen. Mark Hatfield", "new": false}, {"lobbyist": {"id": 6868, "prefix": null, "prefix_display": null, "first_name": "WALTER", "nickname": null, "middle_name": null, "last_name": "PRYOR", "suffix": null, "suffix_display": null}, "covered_position": "U.S. Senator David Pryor", "new": false}, {"lobbyist": {"id": 21981, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "KAUDERS", "suffix": null, "suffix_display": null}, "covered_position": "EPA; White House Climate Change Task Force", "new": false}, {"lobbyist": {"id": 35912, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "BRATHWAITE", "suffix": null, "suffix_display": null}, "covered_position": "DOL Emplm'nt Standards Administration (ESA)", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "The un- and underinsured, animal research, clinical trials, scientific misconduct,conflict of interest.\nS. 717 21st Century Cancer ALERT (Access to Life-Saving Early Detection, Research and Treatment) Act\nKennedy Healthcare Reform Bill\nHouse Tri Committee Healthcare Reform Bill Kennedy Healthcare Reform Bill\nHouse Tri Committee Healthcare Reform Bill", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8004, "prefix": null, "prefix_display": null, "first_name": "SHARON", "nickname": null, "middle_name": null, "last_name": "COHEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 19724, "prefix": null, "prefix_display": null, "first_name": "ED", "nickname": null, "middle_name": null, "last_name": "ROTHSCHILD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46415, "prefix": "mr", "prefix_display": "MR.", "first_name": "THOMAS", "nickname": null, "middle_name": "B", "last_name": "SPARKMAN", "suffix": null, "suffix_display": null}, "covered_position": "Health Policy Intern, Senate HELP Committee", "new": false}, {"lobbyist": {"id": 27998, "prefix": null, "prefix_display": null, "first_name": "RANDALL", "nickname": null, "middle_name": null, "last_name": "GERARD", "suffix": null, "suffix_display": null}, "covered_position": "Sen. Commerce, Science & Transportation Cmte", "new": false}, {"lobbyist": {"id": 27144, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "MADDOX", "suffix": null, "suffix_display": null}, "covered_position": "Communications Dir., House Republican Confer.", "new": false}, {"lobbyist": {"id": 5760, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": null, "last_name": "TESSIER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 13869, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "SCOFIELD", "suffix": null, "suffix_display": null}, "covered_position": "Assistant Press Secretary, Sen. Mark Hatfield", "new": false}, {"lobbyist": {"id": 6868, "prefix": null, "prefix_display": null, "first_name": "WALTER", "nickname": null, "middle_name": null, "last_name": "PRYOR", "suffix": null, "suffix_display": null}, "covered_position": "U.S. Senator David Pryor", "new": false}, {"lobbyist": {"id": 21981, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "KAUDERS", "suffix": null, "suffix_display": null}, "covered_position": "White House Climate Change Task Force; EPA", "new": false}, {"lobbyist": {"id": 35912, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "BRATHWAITE", "suffix": null, "suffix_display": null}, "covered_position": "DOT, General Counsel's Honors Program", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "The un- and underinsured, patient safety, clinical trials\nKennedy Healthcare Reform Bill\nHouse Tri Committee Healthcare Reform Bill\nTri Caucus Healthcare Reform Bill Senate Finance Healthcare Reform Bill\nS. 1110 Medicare Payment Advisory Commission (MedPAC) Reform Act of 2009\nH.R. 2502 Comparative Effectiveness Research Act of 2009\nS. 1213 Patient-Centered Outcomes Research Act of 2009", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8004, "prefix": null, "prefix_display": null, "first_name": "SHARON", "nickname": null, "middle_name": null, "last_name": "COHEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 5760, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": null, "last_name": "TESSIER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 19724, "prefix": null, "prefix_display": null, "first_name": "ED", "nickname": null, "middle_name": null, "last_name": "ROTHSCHILD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46415, "prefix": "mr", "prefix_display": "MR.", "first_name": "THOMAS", "nickname": null, "middle_name": "B", "last_name": "SPARKMAN", "suffix": null, "suffix_display": null}, "covered_position": "Health Policy Intern, Senate HELP Committee", "new": false}, {"lobbyist": {"id": 27998, "prefix": null, "prefix_display": null, "first_name": "RANDALL", "nickname": null, "middle_name": null, "last_name": "GERARD", "suffix": null, "suffix_display": null}, "covered_position": "Senate Commerce, Science & Transportation Cmte", "new": false}, {"lobbyist": {"id": 27144, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "MADDOX", "suffix": null, "suffix_display": null}, "covered_position": "Communications Dir., House Republican Conferenc", "new": false}, {"lobbyist": {"id": 13869, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "SCOFIELD", "suffix": null, "suffix_display": null}, "covered_position": "Assistant Press Secretary, Sen. Mark Hatfield", "new": false}, {"lobbyist": {"id": 6868, "prefix": null, "prefix_display": null, "first_name": "WALTER", "nickname": null, "middle_name": null, "last_name": "PRYOR", "suffix": null, "suffix_display": null}, "covered_position": "Senator David Pryor", "new": false}, {"lobbyist": {"id": 21981, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "KAUDERS", "suffix": null, "suffix_display": null}, "covered_position": "White House Climate Change Task Force; EPA", "new": false}, {"lobbyist": {"id": 35912, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "BRATHWAITE", "suffix": null, "suffix_display": null}, "covered_position": "DOT, General Counsel's Honors Program", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "The un- and underinsured\nS. 717 21st Century Cancer ALERT (Access to Life-Saving Early Detection, Research and Treatment) Act\nKennedy Healthcare Reform Bill\nHouse Tri Committee Healthcare Reform Bill Tri Caucus Healthcare Reform Bill\nSenate Finance Healthcare Reform Bill", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8004, "prefix": null, "prefix_display": null, "first_name": "SHARON", "nickname": null, "middle_name": null, "last_name": "COHEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 5760, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": null, "last_name": "TESSIER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 19724, "prefix": null, "prefix_display": null, "first_name": "ED", "nickname": null, "middle_name": null, "last_name": "ROTHSCHILD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46415, "prefix": "mr", "prefix_display": "MR.", "first_name": "THOMAS", "nickname": null, "middle_name": "B", "last_name": "SPARKMAN", "suffix": null, "suffix_display": null}, "covered_position": "Health Policy Intern, Senate HELP Committee", "new": false}, {"lobbyist": {"id": 27998, "prefix": null, "prefix_display": null, "first_name": "RANDALL", "nickname": null, "middle_name": null, "last_name": "GERARD", "suffix": null, "suffix_display": null}, "covered_position": "Sen. Commerce, Science & Transportation Cmte", "new": false}, {"lobbyist": {"id": 27144, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "MADDOX", "suffix": null, "suffix_display": null}, "covered_position": "Communications Dir., House Republican Confer.", "new": false}, {"lobbyist": {"id": 13869, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "SCOFIELD", "suffix": null, "suffix_display": null}, "covered_position": "Communication Dir., House Approps. Com'tee", "new": false}, {"lobbyist": {"id": 6868, "prefix": null, "prefix_display": null, "first_name": "WALTER", "nickname": null, "middle_name": null, "last_name": "PRYOR", "suffix": null, "suffix_display": null}, "covered_position": "Senator David Pryor", "new": false}, {"lobbyist": {"id": 21981, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "KAUDERS", "suffix": null, "suffix_display": null}, "covered_position": "White House Climate Change Task Force; EPA", "new": false}, {"lobbyist": {"id": 35912, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "BRATHWAITE", "suffix": null, "suffix_display": null}, "covered_position": "DOT, General Counsel's Honors Program", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "SCI", "general_issue_code_display": "Science/Technology", "description": "Patient safety, animal research, clinical trials, scientific misconduct, conflict of interest\nS. 717 21st Century Cancer ALERT (Access to Life Saving Early detection, Research and Treatment) Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8004, "prefix": null, "prefix_display": null, "first_name": "SHARON", "nickname": null, "middle_name": null, "last_name": "COHEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 5760, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": null, "last_name": "TESSIER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 19724, "prefix": null, "prefix_display": null, "first_name": "ED", "nickname": null, "middle_name": null, "last_name": "ROTHSCHILD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46415, "prefix": "mr", "prefix_display": "MR.", "first_name": "THOMAS", "nickname": null, "middle_name": "B", "last_name": "SPARKMAN", "suffix": null, "suffix_display": null}, "covered_position": "Health Policy Intern, Senate HELP Committee", "new": false}, {"lobbyist": {"id": 27998, "prefix": null, "prefix_display": null, "first_name": "RANDALL", "nickname": null, "middle_name": null, "last_name": "GERARD", "suffix": null, "suffix_display": null}, "covered_position": "Sen. Commerce, Science & Transportation Cmte", "new": false}, {"lobbyist": {"id": 27144, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "MADDOX", "suffix": null, "suffix_display": null}, "covered_position": "Communications Dir., House Republican Confer.", "new": false}, {"lobbyist": {"id": 13869, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "SCOFIELD", "suffix": null, "suffix_display": null}, "covered_position": "Assistant Press Secretary, Sen. Mark Hatfield", "new": false}, {"lobbyist": {"id": 6868, "prefix": null, "prefix_display": null, "first_name": "WALTER", "nickname": null, "middle_name": null, "last_name": "PRYOR", "suffix": null, "suffix_display": null}, "covered_position": "Senator David Pryor", "new": false}, {"lobbyist": {"id": 21981, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "KAUDERS", "suffix": null, "suffix_display": null}, "covered_position": "White House Climate Change Task Force; EPA", "new": false}, {"lobbyist": {"id": 35912, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "BRATHWAITE", "suffix": null, "suffix_display": null}, "covered_position": "DOT, General Counsel's Honors Program", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "PHA", "general_issue_code_display": "Pharmacy", "description": "Patient safety, animal research, clinical trials, scientific misconduct, conflict of interest\nS. 717 21st Century Cancer ALERT (Access to Life Saving Early detection, Research and Treatment) Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8004, "prefix": null, "prefix_display": null, "first_name": "SHARON", "nickname": null, "middle_name": null, "last_name": "COHEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 5760, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": null, "last_name": "TESSIER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 19724, "prefix": null, "prefix_display": null, "first_name": "ED", "nickname": null, "middle_name": null, "last_name": "ROTHSCHILD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46415, "prefix": "mr", "prefix_display": "MR.", "first_name": "THOMAS", "nickname": null, "middle_name": "B", "last_name": "SPARKMAN", "suffix": null, "suffix_display": null}, "covered_position": "Health Policy Intern, Senate HELP Committee", "new": false}, {"lobbyist": {"id": 27998, "prefix": null, "prefix_display": null, "first_name": "RANDALL", "nickname": null, "middle_name": null, "last_name": "GERARD", "suffix": null, "suffix_display": null}, "covered_position": "Sen. Commerce, Science & Transportation Com'tee", "new": false}, {"lobbyist": {"id": 27144, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "MADDOX", "suffix": null, "suffix_display": null}, "covered_position": "Communications Dir., House Republican Confer.", "new": false}, {"lobbyist": {"id": 13869, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "SCOFIELD", "suffix": null, "suffix_display": null}, "covered_position": "Ass't Press Sec'y, Sen. Mark Hatfield", "new": false}, {"lobbyist": {"id": 6868, "prefix": null, "prefix_display": null, "first_name": "WALTER", "nickname": null, "middle_name": null, "last_name": "PRYOR", "suffix": null, "suffix_display": null}, "covered_position": "U.S. Senator David Pryor", "new": false}, {"lobbyist": {"id": 21981, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "KAUDERS", "suffix": null, "suffix_display": null}, "covered_position": "White House Climate Change Task Force; EPA", "new": false}, {"lobbyist": {"id": 35912, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "BRATHWAITE", "suffix": null, "suffix_display": null}, "covered_position": "DOT, General Counsel's Honors Program", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "The un- and underinsured, executive compensation.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8004, "prefix": null, "prefix_display": null, "first_name": "SHARON", "nickname": null, "middle_name": null, "last_name": "COHEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 5760, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": null, "last_name": "TESSIER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 19724, "prefix": null, "prefix_display": null, "first_name": "ED", "nickname": null, "middle_name": null, "last_name": "ROTHSCHILD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46415, "prefix": "mr", "prefix_display": "MR.", "first_name": "THOMAS", "nickname": null, "middle_name": "B", "last_name": "SPARKMAN", "suffix": null, "suffix_display": null}, "covered_position": "Health Policy Intern, Senate HELP Committee", "new": false}, {"lobbyist": {"id": 27998, "prefix": null, "prefix_display": null, "first_name": "RANDALL", "nickname": null, "middle_name": null, "last_name": "GERARD", "suffix": null, "suffix_display": null}, "covered_position": "Sen. Commerce, Science & Transportation Cmte", "new": false}, {"lobbyist": {"id": 27144, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "MADDOX", "suffix": null, "suffix_display": null}, "covered_position": "Communications Dir., House Republican Confer.", "new": false}, {"lobbyist": {"id": 13869, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "SCOFIELD", "suffix": null, "suffix_display": null}, "covered_position": "Assistant Press Secretary, Sen. Mark Hatfield", "new": false}, {"lobbyist": {"id": 6868, "prefix": null, "prefix_display": null, "first_name": "WALTER", "nickname": null, "middle_name": null, "last_name": "PRYOR", "suffix": null, "suffix_display": null}, "covered_position": "Senator David Pryor", "new": false}, {"lobbyist": {"id": 21981, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "KAUDERS", "suffix": null, "suffix_display": null}, "covered_position": "White House Climate Change Task Force; EPA", "new": false}, {"lobbyist": {"id": 35912, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "BRATHWAITE", "suffix": null, "suffix_display": null}, "covered_position": "DOT, General Counsel's Honors Program", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MED", "general_issue_code_display": "Medical/Disease Research/Clinical Labs", "description": "The un- and underinsured, patient safety, clinical trials, conflict of interest\nS. 717 21st Century Cancer ALERT (Access to Life-Saving Detection, Research and Treatment) Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8004, "prefix": null, "prefix_display": null, "first_name": "SHARON", "nickname": null, "middle_name": null, "last_name": "COHEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 5760, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": null, "last_name": "TESSIER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 19724, "prefix": null, "prefix_display": null, "first_name": "ED", "nickname": null, "middle_name": null, "last_name": "ROTHSCHILD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46415, "prefix": "mr", "prefix_display": "MR.", "first_name": "THOMAS", "nickname": null, "middle_name": "B", "last_name": "SPARKMAN", "suffix": null, "suffix_display": null}, "covered_position": "Health Policy Intern, Senate HELP Committee", "new": false}, {"lobbyist": {"id": 27998, "prefix": null, "prefix_display": null, "first_name": "RANDALL", "nickname": null, "middle_name": null, "last_name": "GERARD", "suffix": null, "suffix_display": null}, "covered_position": "Sen. Commerce, Science & Transportation Cmte", "new": false}, {"lobbyist": {"id": 27144, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "MADDOX", "suffix": null, "suffix_display": null}, "covered_position": "Communications Director, House Republican Conf", "new": false}, {"lobbyist": {"id": 13869, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "SCOFIELD", "suffix": null, "suffix_display": null}, "covered_position": "Assistant Press Secretary, Sen. Mark Hatfield", "new": false}, {"lobbyist": {"id": 6868, "prefix": null, "prefix_display": null, "first_name": "WALTER", "nickname": null, "middle_name": null, "last_name": "PRYOR", "suffix": null, "suffix_display": null}, "covered_position": "Senator David Pryor", "new": false}, {"lobbyist": {"id": 21981, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "KAUDERS", "suffix": null, "suffix_display": null}, "covered_position": "White House Climate Change Task Force; EPA", "new": false}, {"lobbyist": {"id": 35912, "prefix": null, "prefix_display": null, "first_name": "PAUL", "nickname": null, "middle_name": null, "last_name": "BRATHWAITE", "suffix": null, "suffix_display": null}, "covered_position": "DOT, General Counsel's Honors Program", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 31110 TX TX US US Cancer Treatment Center 0 0   94830 government_unit_widen 0.85

Links from other tables

  • 8 rows from filing_uuid in lobbying_activities
  • 10 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 41.937ms