home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 5aa38f4c-e9cb-42e5-bedc-4b2feb1f657d

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
5aa38f4c-e9cb-42e5-bedc-4b2feb1f657d Q1 12868 DUTKO WORLDWIDE, LLC 118379 CHILIAD, INC. 2012 first_quarter 2012-04-16T16:53:44.170000-04:00 60000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/5aa38f4c-e9cb-42e5-bedc-4b2feb1f657d/", "filing_uuid": "5aa38f4c-e9cb-42e5-bedc-4b2feb1f657d", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2012, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/5aa38f4c-e9cb-42e5-bedc-4b2feb1f657d/print/", "filing_document_content_type": "text/html", "income": "60000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Joshua Ian Rosenstein, Vice President and General Counsel", "dt_posted": "2012-04-16T16:53:44.170000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "412 FIRST STREET SE", "registrant_address_2": "SUITE 100", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20003", "registrant": {"id": 12868, "url": "https://lda.senate.gov/api/v1/registrants/12868/", "house_registrant_id": 32229, "name": "DUTKO WORLDWIDE, LLC", "description": "Government relations firm", "address_1": "80 M STREET SE", "address_2": "SUITE 130", "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20003", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "CHRIS ANDRESEN", "contact_telephone": "+1 202-851-3618", "dt_updated": "2026-01-26T17:43:32.412214-05:00"}, "client": {"id": 118379, "url": "https://lda.senate.gov/api/v1/clients/118379/", "client_id": 1005926, "name": "CHILIAD, INC.", "general_description": "Provider of inter and intra-enterprise information discovery solutions", "client_government_entity": false, "client_self_select": false, "state": "VA", "state_display": "Virginia", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2010-10-27"}, "lobbying_activities": [{"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "Identification of opportunities related to Chiliad's capabilities to support government in the information discovery space. Business Development of software product, including Knowledge Discovery Software. Discussion concerning FY 2012 appropriations for DHS, DOJ and ODNI pilot program. Discussions concerning information sharing/knowledge discovery pilot for DOD. FY13 Appropriations and Authorization request. Issues with National Security Agency (NSA).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42370, "prefix": null, "prefix_display": null, "first_name": "A", "nickname": null, "middle_name": "BRADFORD", "last_name": "CARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46283, "prefix": "mr", "prefix_display": "MR.", "first_name": "MATT", "nickname": null, "middle_name": "SCOTT", "last_name": "SCHRADER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 44, "name": "Central Intelligence Agency (CIA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 215, "name": "Director of National Intelligence (ODNI)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 127, "name": "Natl Security Agency (NSA)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Identification of opportunities related to Chiliad's capabilities to support government in the information discovery space. Business Development of software product, including Knowledge Discovery Software. Discussion concerning FY12 appropriations and authorizations for DHS pilot program. Discussion concerning FY13 appropriations and authorizations for DOD and DHS pilot program.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42370, "prefix": null, "prefix_display": null, "first_name": "A", "nickname": null, "middle_name": "BRADFORD", "last_name": "CARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46283, "prefix": "mr", "prefix_display": "MR.", "first_name": "MATT", "nickname": null, "middle_name": "SCOTT", "last_name": "SCHRADER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 44, "name": "Central Intelligence Agency (CIA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 215, "name": "Director of National Intelligence (ODNI)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 127, "name": "Natl Security Agency (NSA)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "Identification of opportunities related to Chiliad's capabilities to support government in the information discovery space. Business Development of software product, including Knowledge Discovery Software. Discussion concerning FY 2012 appropriations for DHS, DOJ and ODNI pilot program. Discussion concerning FY 2013 appropriations for DHS and DOD pilot program. Discussions concerning information sharing/knowledge discovery approach.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42370, "prefix": null, "prefix_display": null, "first_name": "A", "nickname": null, "middle_name": "BRADFORD", "last_name": "CARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46283, "prefix": "mr", "prefix_display": "MR.", "first_name": "MATT", "nickname": null, "middle_name": "SCOTT", "last_name": "SCHRADER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 44, "name": "Central Intelligence Agency (CIA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 215, "name": "Director of National Intelligence (ODNI)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 127, "name": "Natl Security Agency (NSA)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "Identification of opportunities related to Chiliad's capabilities to support government in the information discovery space. Business Development of software product, including Knowledge Discovery Software. Discussion concerning FY12 authorization and appropriations for DHS, and Intelligence community. Discussion concerning FY13 Authorization and Appropriations for DHS pilot program. Discussions concerning information sharing/knowledge discovery approach. Issues with National Reconnaissance Office.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42370, "prefix": null, "prefix_display": null, "first_name": "A", "nickname": null, "middle_name": "BRADFORD", "last_name": "CARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46283, "prefix": "mr", "prefix_display": "MR.", "first_name": "MATT", "nickname": null, "middle_name": "SCOTT", "last_name": "SCHRADER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 44, "name": "Central Intelligence Agency (CIA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 215, "name": "Director of National Intelligence (ODNI)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 127, "name": "Natl Security Agency (NSA)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "SCI", "general_issue_code_display": "Science/Technology", "description": "Identification of opportunities related to Chiliad's capabilities to support government in the information discovery space. Business Development of software product, including Knowledge Discovery Software. Discussion concerning FY12 authorization and appropriations for DHS, and Intelligence community. Discussion concerning FY13 authorization and appropriations for DHS pilot program. Discussions concerning information sharing/knowledge discovery approach.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42370, "prefix": null, "prefix_display": null, "first_name": "A", "nickname": null, "middle_name": "BRADFORD", "last_name": "CARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46283, "prefix": "mr", "prefix_display": "MR.", "first_name": "MATT", "nickname": null, "middle_name": "SCOTT", "last_name": "SCHRADER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 44, "name": "Central Intelligence Agency (CIA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 215, "name": "Director of National Intelligence (ODNI)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 127, "name": "Natl Security Agency (NSA)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 5 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 10.017ms