lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
15 rows where filing_uuid = "5ba5c19a-ddfa-4eb2-b1fb-e355aa670157" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1494546 | CHAMBERS, CONLON & HARTWELL, LLC 5ba5c19a-ddfa-4eb2-b1fb-e355aa670157 | Q4 | CHAMBERS, CONLON & HARTWELL, LLC | 8830 | KANSAS DEPARTMENT OF COMMERCE | 2013 | fourth_quarter | DIS | Coordination and communication on state and federal disaster declarations | Agriculture, Dept of (USDA),AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Guard,SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 30000 | 0 | 0 | 2014-01-21T11:18:44.103000-05:00 | |
| 1494547 | CHAMBERS, CONLON & HARTWELL, LLC 5ba5c19a-ddfa-4eb2-b1fb-e355aa670157 | Q4 | CHAMBERS, CONLON & HARTWELL, LLC | 8830 | KANSAS DEPARTMENT OF COMMERCE | 2013 | fourth_quarter | AGR | Coordination and communication on state and federal disaster declarations. Support for critical USDA action to avoid furloughs of Food Safety and Inspection Service personenel. | Agriculture, Dept of (USDA),AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Guard,SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 30000 | 0 | 0 | 2014-01-21T11:18:44.103000-05:00 | |
| 1494548 | CHAMBERS, CONLON & HARTWELL, LLC 5ba5c19a-ddfa-4eb2-b1fb-e355aa670157 | Q4 | CHAMBERS, CONLON & HARTWELL, LLC | 8830 | KANSAS DEPARTMENT OF COMMERCE | 2013 | fourth_quarter | TRA | FY14 Appropriations bills (HJRes59, HR2775 [PL 113-46], HR3210 [PL 113-39], HR2610, S1243): - Support for stable highway funding provisions and amendments related to infrastructure spending Appropriations Bills and support for state flexibility and funding stability. Discussions related to preservation of passenger surface transportation alternatives. | Agriculture, Dept of (USDA),AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Guard,SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 30000 | 0 | 0 | 2014-01-21T11:18:44.103000-05:00 | |
| 1494549 | CHAMBERS, CONLON & HARTWELL, LLC 5ba5c19a-ddfa-4eb2-b1fb-e355aa670157 | Q4 | CHAMBERS, CONLON & HARTWELL, LLC | 8830 | KANSAS DEPARTMENT OF COMMERCE | 2013 | fourth_quarter | MMM | No bill bumber: Support for favorable resolution of proposed deferment actions at CMS; FY14 Appropriations bills (HJRes59, HR2775 [PL 113-46], HR3210 [PL 113-39], HR2610, S1243): provisions related to implementation of PPACA. Issues related to federal approval of section 1115 program waivers by CMS. | Agriculture, Dept of (USDA),AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Guard,SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 30000 | 0 | 0 | 2014-01-21T11:18:44.103000-05:00 | |
| 1494550 | CHAMBERS, CONLON & HARTWELL, LLC 5ba5c19a-ddfa-4eb2-b1fb-e355aa670157 | Q4 | CHAMBERS, CONLON & HARTWELL, LLC | 8830 | KANSAS DEPARTMENT OF COMMERCE | 2013 | fourth_quarter | GOV | Monitoring of regulatory and legislative activities impacting the operation of state government; Federal government shutdown preparation in the context of FY14 Appropriations bills (HJRes59, HR2775 [PL 113-46], HR3210 [PL 113-39], HR2610, S1243). | Agriculture, Dept of (USDA),AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Guard,SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 30000 | 0 | 0 | 2014-01-21T11:18:44.103000-05:00 | |
| 1494551 | CHAMBERS, CONLON & HARTWELL, LLC 5ba5c19a-ddfa-4eb2-b1fb-e355aa670157 | Q4 | CHAMBERS, CONLON & HARTWELL, LLC | 8830 | KANSAS DEPARTMENT OF COMMERCE | 2013 | fourth_quarter | ENG | No bill number: Support for extension of renewable energy tax provisions; (no bill number) Monitor changes to the renewable fuel standards and advance biofuel standards. | Agriculture, Dept of (USDA),AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Guard,SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 30000 | 0 | 0 | 2014-01-21T11:18:44.103000-05:00 | |
| 1494552 | CHAMBERS, CONLON & HARTWELL, LLC 5ba5c19a-ddfa-4eb2-b1fb-e355aa670157 | Q4 | CHAMBERS, CONLON & HARTWELL, LLC | 8830 | KANSAS DEPARTMENT OF COMMERCE | 2013 | fourth_quarter | LBR | Coordination with Congressional Delegation and US DOL on the impact of Kansas Department of Labor employees furloughed as a result of delays in federal appropriations. | Agriculture, Dept of (USDA),AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Guard,SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 30000 | 0 | 0 | 2014-01-21T11:18:44.103000-05:00 | |
| 1494553 | CHAMBERS, CONLON & HARTWELL, LLC 5ba5c19a-ddfa-4eb2-b1fb-e355aa670157 | Q4 | CHAMBERS, CONLON & HARTWELL, LLC | 8830 | KANSAS DEPARTMENT OF COMMERCE | 2013 | fourth_quarter | DEF | FY14 Appropriations bills (HJRes59, HR2775 [PL 113-46], HR3210 [PL 113-39], HR2610, S1243): Support for National Guard funding and related issues in the FY2014 appropriations bills and Congressional budgets; Support for Kansas National Guard functions in the context of Sequestration. | Agriculture, Dept of (USDA),AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Guard,SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 30000 | 0 | 0 | 2014-01-21T11:18:44.103000-05:00 | |
| 1494554 | CHAMBERS, CONLON & HARTWELL, LLC 5ba5c19a-ddfa-4eb2-b1fb-e355aa670157 | Q4 | CHAMBERS, CONLON & HARTWELL, LLC | 8830 | KANSAS DEPARTMENT OF COMMERCE | 2013 | fourth_quarter | TAX | Issues related to state revenue impacts of business activity tax changes; developments related to streamlined sales tax; and other state taxation and collection issues impacted by S. 743 Marketplace Fairness Act; No bill number: Support for extension of federal renewable energy tax provisions. | Agriculture, Dept of (USDA),AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Guard,SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 30000 | 0 | 0 | 2014-01-21T11:18:44.103000-05:00 | |
| 1494555 | CHAMBERS, CONLON & HARTWELL, LLC 5ba5c19a-ddfa-4eb2-b1fb-e355aa670157 | Q4 | CHAMBERS, CONLON & HARTWELL, LLC | 8830 | KANSAS DEPARTMENT OF COMMERCE | 2013 | fourth_quarter | UNM | No Bill Number - Trade Adjustment Assistance certifications and policies related to state unemployment and worker assistance progroams. | Agriculture, Dept of (USDA),AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Guard,SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 30000 | 0 | 0 | 2014-01-21T11:18:44.103000-05:00 | |
| 1494556 | CHAMBERS, CONLON & HARTWELL, LLC 5ba5c19a-ddfa-4eb2-b1fb-e355aa670157 | Q4 | CHAMBERS, CONLON & HARTWELL, LLC | 8830 | KANSAS DEPARTMENT OF COMMERCE | 2013 | fourth_quarter | HCR | Outreach in support of state flexibility in the event of government shutdowns in order to continue timely benefits under the Special Supplemental Nutrition Program for Women, Infants and Children under the Food and Nutrition Service, USDA. | Agriculture, Dept of (USDA),AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Guard,SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 30000 | 0 | 0 | 2014-01-21T11:18:44.103000-05:00 | |
| 1494557 | CHAMBERS, CONLON & HARTWELL, LLC 5ba5c19a-ddfa-4eb2-b1fb-e355aa670157 | Q4 | CHAMBERS, CONLON & HARTWELL, LLC | 8830 | KANSAS DEPARTMENT OF COMMERCE | 2013 | fourth_quarter | NAT | Support for efforts to develop state-federal partnership for the purposes of dredging federal reservoirs with state resources. | Agriculture, Dept of (USDA),AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Guard,SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 30000 | 0 | 0 | 2014-01-21T11:18:44.103000-05:00 | |
| 1494558 | CHAMBERS, CONLON & HARTWELL, LLC 5ba5c19a-ddfa-4eb2-b1fb-e355aa670157 | Q4 | CHAMBERS, CONLON & HARTWELL, LLC | 8830 | KANSAS DEPARTMENT OF COMMERCE | 2013 | fourth_quarter | ENV | No bill numbers: Issues related to Environmental assessments of proposed State and Corps of Engineers dredging activities; Issues relating to EPA guidance on existing and new source facility permitting rules for carbon emissions. Issues related to disbursements and receipts of Mineral Leasing Act revenues in the context of sequestration. | Agriculture, Dept of (USDA),AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Guard,SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 30000 | 0 | 0 | 2014-01-21T11:18:44.103000-05:00 | |
| 1494559 | CHAMBERS, CONLON & HARTWELL, LLC 5ba5c19a-ddfa-4eb2-b1fb-e355aa670157 | Q4 | CHAMBERS, CONLON & HARTWELL, LLC | 8830 | KANSAS DEPARTMENT OF COMMERCE | 2013 | fourth_quarter | CSP | Support for adoption of a procurement contract by the Social Security Administration that adequately protects personal identifying information of Kansas citizens from unnecessary distribution and adequately compensates state Vital Records Offices for the collection of information on behalf of SSA. | Agriculture, Dept of (USDA),AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Guard,SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 30000 | 0 | 0 | 2014-01-21T11:18:44.103000-05:00 | |
| 1494560 | CHAMBERS, CONLON & HARTWELL, LLC 5ba5c19a-ddfa-4eb2-b1fb-e355aa670157 | Q4 | CHAMBERS, CONLON & HARTWELL, LLC | 8830 | KANSAS DEPARTMENT OF COMMERCE | 2013 | fourth_quarter | HOM | Coordination on state and federal disaster declarations. Interaction with DHS in furtherance of Kansas compliance with the REAL ID Act. HR 2217 (H.Rept 113-91, S.Rept.113-77): FY14 Appropriations bills (HJRes59, HR2775 [PL 113-46], HR3210 [PL 113-39], HR2610, S1243): Support for funding for National Bio and Agro-Defence Facility funding. Inquiries related to local applications for the Fiscal Year 2013 Assistance to Firefighters Grant Program (AFG) grant guidance at DHS. | Agriculture, Dept of (USDA),AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Guard,SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 30000 | 0 | 0 | 2014-01-21T11:18:44.103000-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);