lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
146,876 rows where filing_year = 2015 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1655397 | FONTHEIM INTERNATIONAL, LLC 83a6c5ac-c69c-48ae-9978-5ffffef880f2 | 1T | FONTHEIM INTERNATIONAL, LLC | 15075 | AMERICAN CANCER SOCIETY CANCER ACTION NETWORK | 2015 | first_quarter | TRD | Meeting with Congressional staff and Administration official to discuss international trade and regulatory issues regarding tobacco products. | HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) | 0 | 1 | 2015-01-05T15:20:21.113000-05:00 | ||
| 1655398 | BLINDED VETERANS ASSOCIATION a96441ef-653e-46a7-91ee-313df3f9c7e9 | Q1Y | BLINDED VETERANS ASSOCIATION | 40013094 | BLINDED VETERANS ASSOCIATION | 2015 | first_quarter | 10000 | 0 | 0 | 2015-01-07T14:36:42.753000-05:00 | ||||
| 1655399 | LIEBMAN & ASSOCIATES, INC. 91b9c4a0-ce59-4dbc-8f6e-61e59fef36f2 | 1TY | LIEBMAN & ASSOCIATES, INC. | 46585 | SPRINT | 2015 | first_quarter | 0 | 1 | 2015-01-08T09:46:59.860000-05:00 | |||||
| 1655400 | ALPINE GROUP PARTNERS, LLC. 89f9563a-d10b-48bc-9a89-f4cd4cd28e57 | Q1 | ALPINE GROUP PARTNERS, LLC. | 1171 | DUN AND BRADSTREET | 2015 | first_quarter | BUD | Federal Agency funding | HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 0 | 2015-01-08T15:03:44.007000-05:00 | |
| 1655401 | COVINGTON & BURLING LLP 02db5de4-3ae0-4c9e-9456-563697969d78 | Q1 | COVINGTON & BURLING LLP | 11195 | AMERICAN BANKERS ASSOCIATION | 2015 | first_quarter | FIN | Issues affecting banks, including housing issues and GSE reform, credit card issues, amendments to the Dodd-Frank Act, and credit union issues. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2015-01-14T15:33:30.083000-05:00 | |
| 1655402 | COVINGTON & BURLING LLP ed474b55-5f58-4dba-8764-867f3fe478b7 | Q1 | COVINGTON & BURLING LLP | 11195 | BROWN BROTHERS HARRIMAN | 2015 | first_quarter | FIN | Issues affecting banking institutions, including regulation of derivatives | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2015-01-14T15:39:43.833000-05:00 | ||
| 1655403 | CITY OF HOPE NATIONAL MEDICAL CENTER 507ce84f-a72a-41e8-985c-38d9f471a944 | 1TY | CITY OF HOPE NATIONAL MEDICAL CENTER | 400282353 | CITY OF HOPE NATIONAL MEDICAL CENTER | 2015 | first_quarter | 0 | 1 | 2015-01-16T11:38:05.610000-05:00 | |||||
| 1655404 | MS. LAURA ALLENDORF e10e7d66-c80c-41e0-808a-cb24fcf8f567 | 1TY | MS. LAURA ALLENDORF | 63096 | SOCIETY OF HOSPITAL MEDICINE | 2015 | first_quarter | 0 | 1 | 2015-01-18T22:56:27.053000-05:00 | |||||
| 1655405 | CLERGY FINANCIAL STRATEGY AND TAX PLANNING INC 9a86a0b6-6aeb-4c32-91a7-a1f732ca40ae | Q1Y | CLERGY FINANCIAL STRATEGY AND TAX PLANNING INC | 400689053 | CHURCH OF GOD IN CHRIST INTL HDQTRS | 2015 | first_quarter | 0 | 0 | 2015-01-19T10:37:37.010000-05:00 | |||||
| 1655406 | PALMER POLICY GROUP, LLC 115b1e36-80c7-416e-a0a1-d31fd9ab5155 | 1TY | PALMER POLICY GROUP, LLC | 401103341 | CENTRAL RESEARCH | 2015 | first_quarter | 0 | 1 | 2015-01-19T15:04:24.873000-05:00 | |||||
| 1655407 | PALMER POLICY GROUP, LLC 7347ad6a-79a0-4a8d-82ef-c4aae4100671 | 1TY | PALMER POLICY GROUP, LLC | 401103341 | NATIONAL CORN GROWERS ASSOCIATION | 2015 | first_quarter | 0 | 1 | 2015-01-19T15:05:27.233000-05:00 | |||||
| 1655408 | SAFRAN USA, INC. (FORMERLY SNECMA USA, INC.) 2d0b3153-2cfe-4ea1-8436-31fcd906fa03 | Q1 | SAFRAN USA, INC. (FORMERLY SNECMA USA, INC.) | 72097 | SAFRAN USA, INC. (FORMERLY SNECMA USA, INC.) | 2015 | first_quarter | DEF | Authorization and appropriations | HOUSE OF REPRESENTATIVES,SENATE | 150000 | 0 | 0 | 2015-01-20T11:57:02.470000-05:00 | |
| 1655409 | SAFRAN USA, INC. (FORMERLY SNECMA USA, INC.) 2d0b3153-2cfe-4ea1-8436-31fcd906fa03 | Q1 | SAFRAN USA, INC. (FORMERLY SNECMA USA, INC.) | 72097 | SAFRAN USA, INC. (FORMERLY SNECMA USA, INC.) | 2015 | first_quarter | TRA | Authorization and appropriations | HOUSE OF REPRESENTATIVES,SENATE | 150000 | 0 | 0 | 2015-01-20T11:57:02.470000-05:00 | |
| 1655410 | PREMIER, INC. 6490d35c-9e33-4c0c-82e5-7afb20c005a5 | Q1 | PREMIER, INC. | 32054 | PREMIER, INC. | 2015 | first_quarter | HCR | Implementation of Health Reform (PPACA) The Health Information Technology for Economic and Clinical Health Act (HITECH), Regarding Implementation of Act Issues Related to the Medicare & Medicaid Protection Act of 1987 that Regulate Group Purchasing Organizations Under HHS 340B Drug Pricing ProgramMedicare Delivery System Reform 2011 Budget Control Act -- Sequestration Medicare Physician Payment Reform Observation Status "Two-Midnight" Rule CR/Debt Limit Medicare DSH Medicare Data Access E&M Site Neutral IMPACT Act of 2014 Medicare hospital quality improvement program Hospital readmissions reduction program CHIP Reauthorization (HR 5364 and S2461) Protecting the integrity of Medicare Act (Medicare/Medicaid waste, fraud and abuse) Telemedicine Veterans Access, Choice, and Accountability Act of 2016 Comprehensive Care Payment Innovation Act Flexibility in Health IT Act of 2014 Ebola/Appropriations Hospital Payment Improvements Act of 2014 21st Century Cures Initiative Biosimilars Hospital Drug Shortages | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 97394 | 0 | 0 | 2015-01-20T12:12:13.203000-05:00 | |
| 1655411 | BUCHANAN INGERSOLL & ROONEY PC 476073c6-6714-442d-a904-6f71bfe8684d | 1TY | BUCHANAN INGERSOLL & ROONEY PC | 55291 | WOCKHARDT LTD | 2015 | first_quarter | 0 | 1 | 2015-01-22T14:22:54.807000-05:00 | |||||
| 1655412 | KILPATRICK TOWNSEND AND STOCKTON 7d272d4a-0f11-4de3-9731-faecfa68d7a2 | 1TY | KILPATRICK TOWNSEND AND STOCKTON | 21563 | DOOSAN INFRACORE INTERNATIONAL, INC. | 2015 | first_quarter | 0 | 1 | 2015-01-23T15:05:00.147000-05:00 | |||||
| 1655413 | AGILENT TECHNOLOGIES, INC c1c6a314-1bb6-4f18-8589-c141c2ee698a | 1TY | AGILENT TECHNOLOGIES, INC | 54051 | AGILENT TECHNOLOGIES INC | 2015 | first_quarter | 0 | 1 | 2015-01-26T10:09:44.263000-05:00 | |||||
| 1655414 | GENTIVA HEALTH SERVICES 2b182095-8ead-4ad9-a6c2-08f07578220a | 1T | GENTIVA HEALTH SERVICES | 65156 | GENTIVA HEALTH SERVICES | 2015 | first_quarter | MMM | Any federal legislation or agency regulations impacting federal rules or regulations for home health care and hospice services. | Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Medicare Payment Advisory Commission (MedPAC),Office of Management & Budget (OMB),SENATE,White House Office | 115400 | 0 | 1 | 2015-01-26T16:59:53.337000-05:00 | |
| 1655415 | COZEN O'CONNOR PUBLIC STRATEGIES ce5eebaf-02bf-48f3-95ab-b77bd89cddcf | 1TY | COZEN O'CONNOR PUBLIC STRATEGIES | 400459252 | ADUSTON CONSULTING, LLC | 2015 | first_quarter | 0 | 1 | 2015-01-29T15:37:29.900000-05:00 | |||||
| 1655416 | KEY IMPACT STRATEGIES 832df506-5cdd-4261-933a-3db46ad0ed0f | 1TY | KEY IMPACT STRATEGIES | 400971786 | EKOSYSTEMS PARTNERS | 2015 | first_quarter | 5000 | 0 | 1 | 2015-01-30T16:35:10.637000-05:00 | ||||
| 1655417 | KEY IMPACT STRATEGIES 1b9612c4-78c9-4495-9c23-aaedfce06f8f | 1T | KEY IMPACT STRATEGIES | 400971786 | LOCAL INITIATIVES SUPPORT CORPORATION | 2015 | first_quarter | BUD | FY 16 TTHUD/Commerce Justice,Science/Agriculture Appropriations. Specifically funding for community safety initiatives, HUD Section 4, and rural housing programs. | HOUSE OF REPRESENTATIVES,SENATE | 5000 | 0 | 1 | 2015-01-30T16:45:12.060000-05:00 | |
| 1655418 | KEY IMPACT STRATEGIES 5ab7b0e5-39d2-4fab-a32c-57ffce95cfda | 1T | KEY IMPACT STRATEGIES | 400971786 | INSTITUTE FOR MARINE MAMMAL STUDIES | 2015 | first_quarter | ANI | FY 16 Commerce Justice Science Appropriations bill. Specifically, funding for the National Marine Fisheries Service (protection of marine mammals) | HOUSE OF REPRESENTATIVES,SENATE | 5000 | 0 | 1 | 2015-01-30T16:52:13.357000-05:00 | |
| 1655419 | TCH GROUP, LLC df2a09df-ba1d-445e-8935-6623ca9688d7 | 1TY | TCH GROUP, LLC | 51478 | THE WAX COMPANY, LLC | 2015 | first_quarter | 5000 | 0 | 1 | 2015-01-30T17:03:15.620000-05:00 | ||||
| 1655420 | PLS FINANCIAL SERVICES d020dd2b-6eda-4557-aefd-a8580663d3d5 | 1T | PLS FINANCIAL SERVICES | 401103142 | PLS FINANCIAL SERVICES | 2015 | first_quarter | FIN | Operation chokepoint | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2015-02-02T10:50:20.753000-05:00 | ||
| 1655421 | CUBIST PHARMACEUTICALS, INC. 19f18b81-ce4d-4718-9f55-7bc890bcccc7 | 1T | CUBIST PHARMACEUTICALS, INC. | 40026226 | CUBIST PHARMACEUTICALS | 2015 | first_quarter | HCR | Developing an Innovative Strategy for Antimicrobial Resistant Microorganisms (DISARM)Act; Ongoing discussions surrounding next steps for protecting and promoting incentives for the development of resistant pathogens including breakpoints, andtibiotic resistance, reimbursement issues for antibiotics, President's Council of Advisors on Science and Technology (PCSAT) | Health & Human Services, Dept of (HHS) | 0 | 1 | 2015-02-02T17:43:37.717000-05:00 | ||
| 1655422 | BOCKORNY GROUP, INC. 2867ea9f-b66f-4bd0-873f-5d90982632fd | 1T | BOCKORNY GROUP, INC. | 289773 | COALITION TO INSURE AGAINST TERRORISM | 2015 | first_quarter | INS | H.R. 508, The Terrorism Risk Insurance Reauthorization Act of 2013 Legislation related to the reauthorization of the reinsurance program for terrorism risk insurance H.R. 2146, Terrorism Risk Insurance Program Reauthorization Act of 2013 H.R. 1945, Fostering Resilience to Terrorism Act of 2013 H.R. 4871, TRIA Reform Act of 2014 S. 2244, Terorism Risk Insurance Program Reauthorization Act of 2014 | Council of Economic Advisers (CEA),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2015-02-05T09:27:33.273000-05:00 | |
| 1655423 | BOCKORNY GROUP, INC. 9b8f959c-a31a-4e32-87f8-ef5385385f27 | 1TY | BOCKORNY GROUP, INC. | 289773 | U S PREMIUM BEEF LLC | 2015 | first_quarter | 0 | 1 | 2015-02-06T11:30:15.377000-05:00 | |||||
| 1655424 | THE PICARD GROUP, LLC d9822315-4899-4a2c-a623-52dacb3ddecd | 1TY | THE PICARD GROUP, LLC | 400711132 | GLOBAL SECURITY SYSTEMS | 2015 | first_quarter | 0 | 1 | 2015-02-06T15:45:46.450000-05:00 | |||||
| 1655425 | ADUSTON CONSULTING, LLC 820a3acd-0744-4b5c-8ec0-7bdc7abda4c6 | 1TY | ADUSTON CONSULTING, LLC | 305098 | SARSHELA, INC. | 2015 | first_quarter | 0 | 1 | 2015-02-06T17:41:45.723000-05:00 | |||||
| 1655426 | AVENUE SOLUTIONS b648a121-c76f-459a-baf4-1965deaa8901 | 1TY | AVENUE SOLUTIONS | 72111 | CUBIST PHARMACEUTICALS, INC. | 2015 | first_quarter | 20000 | 0 | 1 | 2015-02-09T13:41:11.827000-05:00 | ||||
| 1655427 | FLEET STREET GROUP 02ad800d-fb31-49be-a11c-878c556fee35 | Q1 | FLEET STREET GROUP | 400974790 | NORTH CENTRAL MONTANA REGIONAL WATER AUTHORITY | 2015 | first_quarter | NAT | Lobbying House and Senate on increased funding the for the Rocky Boys/North Central Montana Regional Water System | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2015-02-09T14:22:01.597000-05:00 | |
| 1655428 | WIPRO, LLC 1cca9264-65c2-4927-9742-ffe45ab0c097 | 1T | WIPRO, LLC | 400619881 | WIPRO, LLC | 2015 | first_quarter | IMM | immigration reform, outsourcing, S. 153 - Immigration Innovation (I-Squared) Act of 2015; | Bureau of Citizenship & Immigration Services (BCIS),Commerce, Dept of (DOC),Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,U.S. Trade Representative (USTR) | 20000 | 0 | 1 | 2015-02-10T14:29:29.877000-05:00 | |
| 1655429 | FEDERAL SOLUTIONS, LLC 528b7c49-e0d6-471d-a2f2-6552e594d27b | 1TY | FEDERAL SOLUTIONS, LLC | 311371 | KIOR, INC. | 2015 | first_quarter | 0 | 1 | 2015-02-10T16:59:57.027000-05:00 | |||||
| 1655430 | PLS FINANCIAL SERVICES d6b22772-dab2-41ba-a89b-ab03a1164cdd | 1AY | PLS FINANCIAL SERVICES | 401103142 | PLS FINANCIAL SERVICES | 2015 | first_quarter | 0 | 0 | 2015-02-11T10:57:16.327000-05:00 | |||||
| 1655431 | PORTER GORDON SILVER COMMUNICATIONS, LLC 73d94051-637b-435d-8193-483363bd864b | 1TY | PORTER GORDON SILVER COMMUNICATIONS, LLC | 400826452 | AEROJET/ROCKETDYNE | 2015 | first_quarter | 0 | 1 | 2015-02-11T14:12:40.213000-05:00 | |||||
| 1655432 | PORTER GORDON SILVER COMMUNICATIONS, LLC 7466e8a3-054c-4c67-abb0-8b93dc199416 | 1TY | PORTER GORDON SILVER COMMUNICATIONS, LLC | 400826452 | THE CORMAC GROUP | 2015 | first_quarter | 0 | 1 | 2015-02-11T14:13:41.307000-05:00 | |||||
| 1655433 | PORTER GORDON SILVER COMMUNICATIONS, LLC 4cd5f254-149c-4e64-bed4-3bcb25cb28af | 1TY | PORTER GORDON SILVER COMMUNICATIONS, LLC | 400826452 | ASSOCIATION OF CATASTROPHE ADJUSTERS | 2015 | first_quarter | 0 | 1 | 2015-02-11T14:13:42.370000-05:00 | |||||
| 1655434 | C2 STRATEGIES ae45d67c-b9f8-41f3-84b4-4941c6bb408c | 1TY | C2 STRATEGIES | 29777 | MBDA INCORPORATED | 2015 | first_quarter | 0 | 1 | 2015-02-11T17:43:54.643000-05:00 | |||||
| 1655435 | THE NICKLES GROUP, LLC bee8e6a6-653c-4a86-a42d-eb185aea6dcc | 1TY | THE NICKLES GROUP, LLC | 293335 | CUBIST PHARMACEUTICALS, INC. | 2015 | first_quarter | 0 | 1 | 2015-02-12T12:49:12.307000-05:00 | |||||
| 1655436 | GOLDEN OAK CONSULTING c413b459-b129-41ed-97f4-9b4659336bb7 | 1TY | GOLDEN OAK CONSULTING | 401067004 | GOPRO | 2015 | first_quarter | 5000 | 0 | 1 | 2015-02-12T23:25:36.607000-05:00 | ||||
| 1655437 | MR. BRUCE NAVARRO 0b3798ee-ffbc-4b08-b98d-87d9df57001e | 1TY | MR. BRUCE NAVARRO | 28878 | NEW MEXICO INSTITUTE OF MINING AND TECHNOLOGY | 2015 | first_quarter | 0 | 1 | 2015-02-13T19:43:15.497000-05:00 | |||||
| 1655438 | MR. HENRY HOWELL cdc13047-8737-4212-9516-28d78ce94427 | 1TY | MR. HENRY HOWELL | 400746237 | GLADYS AND WALTER COUNTS | 2015 | first_quarter | 0 | 1 | 2015-02-14T11:29:43.103000-05:00 | |||||
| 1655439 | BALL JANIK LLP dce21376-260a-4755-8b38-cee225db0dc3 | 1T | BALL JANIK LLP | 5222 | COASTAL CONSERVATION ASSOCIATION | 2015 | first_quarter | MAR | Pacific salmon harvest, recovery, and hatchery reform. | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),HOUSE OF REPRESENTATIVES,Natl Oceanic & Atmospheric Administration (NOAA),SENATE | 0 | 1 | 2015-02-18T15:48:55.337000-05:00 | ||
| 1655440 | BALL JANIK LLP b72b2f48-bf9f-4277-8912-12bf00b59a10 | 1TY | BALL JANIK LLP | 5222 | AMERICAN FOREST RESOURCE COUNCIL | 2015 | first_quarter | 0 | 1 | 2015-02-18T16:13:56.707000-05:00 | |||||
| 1655441 | BALL JANIK LLP 8437e054-9c08-4ebc-99f6-5ae6d9f3163d | 1T | BALL JANIK LLP | 5222 | CLACKAMAS COUNTY OR | 2015 | first_quarter | TRA | MAP 21 Implementation. Transportation Reauthorization. | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA) | 20000 | 0 | 1 | 2015-02-18T18:19:03.583000-05:00 | |
| 1655442 | BALL JANIK LLP 8437e054-9c08-4ebc-99f6-5ae6d9f3163d | 1T | BALL JANIK LLP | 5222 | CLACKAMAS COUNTY OR | 2015 | first_quarter | BUD | Commerce, Justice, Science, and Related Agencies Appropriations, Methamphetamine funding; COPS funding; Transportation, Housing and Urban Development, and Related Agencies Appropriations; Departments of Labor, Health and Human Services, and Education Appropriations, Health Clinic funding, WFI funding, workforce training. | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA) | 20000 | 0 | 1 | 2015-02-18T18:19:03.583000-05:00 | |
| 1655443 | BALL JANIK LLP 8437e054-9c08-4ebc-99f6-5ae6d9f3163d | 1T | BALL JANIK LLP | 5222 | CLACKAMAS COUNTY OR | 2015 | first_quarter | ENV | Public Land Management, monitor for impact on County. | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA) | 20000 | 0 | 1 | 2015-02-18T18:19:03.583000-05:00 | |
| 1655444 | BALL JANIK LLP 8437e054-9c08-4ebc-99f6-5ae6d9f3163d | 1T | BALL JANIK LLP | 5222 | CLACKAMAS COUNTY OR | 2015 | first_quarter | CAW | Monitor implementation of the Water Resources Reform and Development Act of 2014. | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA) | 20000 | 0 | 1 | 2015-02-18T18:19:03.583000-05:00 | |
| 1655445 | BALL JANIK LLP 8437e054-9c08-4ebc-99f6-5ae6d9f3163d | 1T | BALL JANIK LLP | 5222 | CLACKAMAS COUNTY OR | 2015 | first_quarter | ECN | FAA Air Transportation Modernization and Safety Improvement Act; monitor funding for municipalities and implementation. | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA) | 20000 | 0 | 1 | 2015-02-18T18:19:03.583000-05:00 | |
| 1655446 | BALL JANIK LLP 1289720e-564f-491a-8f56-47f4c124001d | 1T | BALL JANIK LLP | 5222 | PORT OF CASCADE LOCKS (FORMERLY: CITY OF CASCADE LOCKS) | 2015 | first_quarter | BUD | Transportation, Housing and Urban Development, and Related Agencies Appropriations; Federal transportation funding provisions; Implementation of MAP21 | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2015-02-18T18:34:06.023000-05:00 | ||
| 1655447 | BALL JANIK LLP b6bb69cf-88db-4c91-99fa-cc346e7cba5b | 1T | BALL JANIK LLP | 5222 | CHEHALEM PARKS AND RECREATION DISTRICT | 2015 | first_quarter | TRA | Monitor MAP-21 implementation for Chehalem Historical Greenway Trail funding. | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 0 | 1 | 2015-02-18T18:48:07.160000-05:00 | ||
| 1655448 | BALL JANIK LLP b6bb69cf-88db-4c91-99fa-cc346e7cba5b | 1T | BALL JANIK LLP | 5222 | CHEHALEM PARKS AND RECREATION DISTRICT | 2015 | first_quarter | BUD | Transportation, Housing and Urban Development, and Related Agencies Appropriations Act, Greenway funding. Departments of Labor, Health and Human Services, and Education Appropriations, funding for cultural center. | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 0 | 1 | 2015-02-18T18:48:07.160000-05:00 | ||
| 1655449 | BALL JANIK LLP e47d5439-607a-4e51-803d-1cfa41f7d37a | 1T | BALL JANIK LLP | 5222 | CITY OF DAYTON, OHIO. | 2015 | first_quarter | BUD | Transportation, Housing, and Urban Development, and Related Agencies Appropriations Act, project funding; Commerce, Justice, Science, and Related Agencies Appropriations, project funding. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2015-02-18T18:57:09.160000-05:00 | |
| 1655450 | BALL JANIK LLP e47d5439-607a-4e51-803d-1cfa41f7d37a | 1T | BALL JANIK LLP | 5222 | CITY OF DAYTON, OHIO. | 2015 | first_quarter | TRA | Monitor implementation of MAP-21 project funding and FAA Modernization and Reform Act of 2012, project funding. Monitor development of surface transportation reauthorization. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2015-02-18T18:57:09.160000-05:00 | |
| 1655451 | BALL JANIK LLP 659f4b31-e35c-4a16-8c87-9ff847f9ef2f | 1T | BALL JANIK LLP | 5222 | DRIVE OREGON | 2015 | first_quarter | ENG | Federal funding supporting the development of electric vehicles and EV charging stations. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2015-02-18T19:18:10.317000-05:00 | ||
| 1655452 | BALL JANIK LLP 1dccaec0-77fa-467a-ae13-009ec79fbe8a | 1T | BALL JANIK LLP | 5222 | CITY OF TUKWILA (WA) | 2015 | first_quarter | BUD | Transportation, Housing and Urban Development, and Related Agencies Appropriations Act, FTA small starts funding; Energy and Water Development and Related Agencies Appropriations Act, Green River funding. | HOUSE OF REPRESENTATIVES,SENATE | 5000 | 0 | 1 | 2015-02-18T19:28:11.393000-05:00 | |
| 1655453 | BALL JANIK LLP 1dccaec0-77fa-467a-ae13-009ec79fbe8a | 1T | BALL JANIK LLP | 5222 | CITY OF TUKWILA (WA) | 2015 | first_quarter | TRA | MAP-21, surface transportation provisions, implementation of MAP-21. Monitoring rail yard development and federal laws affecting | HOUSE OF REPRESENTATIVES,SENATE | 5000 | 0 | 1 | 2015-02-18T19:28:11.393000-05:00 | |
| 1655454 | BALL JANIK LLP 1dccaec0-77fa-467a-ae13-009ec79fbe8a | 1T | BALL JANIK LLP | 5222 | CITY OF TUKWILA (WA) | 2015 | first_quarter | COM | Monitor developments in broadband legislation. | HOUSE OF REPRESENTATIVES,SENATE | 5000 | 0 | 1 | 2015-02-18T19:28:11.393000-05:00 | |
| 1655455 | BALL JANIK LLP d10c10ac-b470-4a84-b860-858b164cc297 | 1T | BALL JANIK LLP | 5222 | PORT OF PASCO | 2015 | first_quarter | TRA | Implementation of MAP-21, Issues associated with expansion of PSC> Monitor development of surface transportation reauthorization. Implementation of FAA Modernization and Reform Act of 2012. | HOUSE OF REPRESENTATIVES,SENATE | 5000 | 0 | 1 | 2015-02-18T19:42:12.673000-05:00 | |
| 1655456 | BALL JANIK LLP d10c10ac-b470-4a84-b860-858b164cc297 | 1T | BALL JANIK LLP | 5222 | PORT OF PASCO | 2015 | first_quarter | BUD | Transportation, Housing and Urban Development, and Related Agencies Apropriations Act, Port rail development funding. Aviation funding and AIP levels. | HOUSE OF REPRESENTATIVES,SENATE | 5000 | 0 | 1 | 2015-02-18T19:42:12.673000-05:00 | |
| 1655457 | BALL JANIK LLP 75038a08-77da-4e12-9d41-b258363c75b5 | 1TY | BALL JANIK LLP | 5222 | PORT OF RIDGEFIELD, WA | 2015 | first_quarter | 0 | 1 | 2015-02-18T20:13:13.860000-05:00 | |||||
| 1655458 | BALL JANIK LLP 0ec0a515-ab86-44ab-ba9a-f523b61cde3f | 1T | BALL JANIK LLP | 5222 | PORT OF HOOD RIVER OREGON | 2015 | first_quarter | BUD | Departments of Labor, Health and Human Services, and Education, Appropriations, Health care facility funding; Transportation, Housing and Urban Development, and Related Agencies Appropriations, transportation project funding. Monitor implementation of the Water Resources Reform and Development Act of 2014. | HOUSE OF REPRESENTATIVES,SENATE | 5000 | 0 | 1 | 2015-02-18T20:20:15.097000-05:00 | |
| 1655459 | BALL JANIK LLP d1c3a7c8-44df-4b0a-811d-8d323edf6265 | 1T | BALL JANIK LLP | 5222 | PORT OF WALLA WALLA | 2015 | first_quarter | BUD | Transportation, Housing and Urban Development, and Related Agencies Appropriations, U.S. Highway 12 and port project funding, S. 601; Water Resources Development Act of 2013, port project funding, Interior Appropriations, STAG funding, Aviation funding and implementation of the FAA Modernization and Reform Act. | Federal Highway Administration (FHA),Federal Railroad Administration,HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 0 | 1 | 2015-02-18T20:26:16.330000-05:00 | ||
| 1655460 | BALL JANIK LLP b6bd42a1-a0a3-44e2-926d-34fa5169b874 | 1T | BALL JANIK LLP | 5222 | WASHINGTON STATE DEPARTMENT OF TRANSPORTATION (FORMERLY DENNY MILLER ASSOCIATES) | 2015 | first_quarter | TRA | Federal transportation funding and policy | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 5000 | 0 | 1 | 2015-02-18T20:50:17.610000-05:00 | |
| 1655461 | BALL JANIK LLP b6bd42a1-a0a3-44e2-926d-34fa5169b874 | 1T | BALL JANIK LLP | 5222 | WASHINGTON STATE DEPARTMENT OF TRANSPORTATION (FORMERLY DENNY MILLER ASSOCIATES) | 2015 | first_quarter | ENG | Energy efficiency. | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 5000 | 0 | 1 | 2015-02-18T20:50:17.610000-05:00 | |
| 1655462 | BALL JANIK LLP 051a2d48-650f-40b1-b5de-fa0a47e6cb0e | 1T | BALL JANIK LLP | 5222 | NATIONAL FOREST HOMEOWNERS | 2015 | first_quarter | NAT | HR 4873, H.R. 1159, S. 1341, HR 5476, S. 1847, Cabin Fee Act | HOUSE OF REPRESENTATIVES,SENATE | 5000 | 0 | 1 | 2015-02-18T20:55:18.940000-05:00 | |
| 1655463 | BALL JANIK LLP f3cbd335-0797-4573-86c8-26a158ee57e6 | 1T | BALL JANIK LLP | 5222 | YAMHILL COUNTY OREGON | 2015 | first_quarter | TRA | Monitor development of Surface Transportation reauthorization. Monitor implementation of MAP-21. | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 5000 | 0 | 1 | 2015-02-18T21:24:20.173000-05:00 | |
| 1655464 | BALL JANIK LLP f3cbd335-0797-4573-86c8-26a158ee57e6 | 1T | BALL JANIK LLP | 5222 | YAMHILL COUNTY OREGON | 2015 | first_quarter | BUD | Transportation, Housing and Urban Development, and Related Agencies Appropriations, Federal highways project funding, public/private partnership provisions. | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 5000 | 0 | 1 | 2015-02-18T21:24:20.173000-05:00 | |
| 1655465 | BALL JANIK LLP 8403a0cd-f900-4074-87b1-f9203dab62cb | 1T | BALL JANIK LLP | 5222 | EB5 GLOBAL, LLC | 2015 | first_quarter | IMM | Work with USCIS to obtain certain applications and work with Oregon congressional delegation on same. | Bureau of Citizenship & Immigration Services (BCIS),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2015-02-19T09:31:24.970000-05:00 | |
| 1655466 | BALL JANIK LLP c5d5db49-9526-4319-ac77-2373e08727fa | 1T | BALL JANIK LLP | 5222 | GREENBRIER COMPANIES | 2015 | first_quarter | TRD | No activity. | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 1 | 2015-02-19T10:58:49.687000-05:00 | |
| 1655467 | BALL JANIK LLP c5d5db49-9526-4319-ac77-2373e08727fa | 1T | BALL JANIK LLP | 5222 | GREENBRIER COMPANIES | 2015 | first_quarter | RRR | Railroad tankcar safety requirements. | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 1 | 2015-02-19T10:58:49.687000-05:00 | |
| 1655468 | BALL JANIK LLP c5d5db49-9526-4319-ac77-2373e08727fa | 1T | BALL JANIK LLP | 5222 | GREENBRIER COMPANIES | 2015 | first_quarter | TRA | Monitor legislation regarding the expansion of use of longer and heavier trucks, NAFCA, Surface Transportation Reauthorization, transportation policy. | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 1 | 2015-02-19T10:58:49.687000-05:00 | |
| 1655469 | BALL JANIK LLP c5d5db49-9526-4319-ac77-2373e08727fa | 1T | BALL JANIK LLP | 5222 | GREENBRIER COMPANIES | 2015 | first_quarter | TAX | Monitor railroad track maintenance credit legislation, bonus depreciation, corporate tax simplification, foreign source income rules. | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 1 | 2015-02-19T10:58:49.687000-05:00 | |
| 1655470 | BALL JANIK LLP c5d5db49-9526-4319-ac77-2373e08727fa | 1T | BALL JANIK LLP | 5222 | GREENBRIER COMPANIES | 2015 | first_quarter | MAR | Monitor legislation relating to the Jones Act. | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 1 | 2015-02-19T10:58:49.687000-05:00 | |
| 1655471 | ROBERTSON, MONAGLE & EASTAUGH LLC 8787ea53-3da6-43eb-b9d9-7a0a93ada488 | Q1 | ROBERTSON, MONAGLE & EASTAUGH LLC | 33454 | ALASKA GROUNDFISH DATA BANK | 2015 | first_quarter | NAT | (1) Reauthorization of the Magnuson-Stevens Act; (2) Regulations governing salmon bycatch and halibut bycatch in the Gulf of Alaska; (3) Issues relating to the proposed Gulf Trawl Bycatch Management program. | HOUSE OF REPRESENTATIVES,SENATE | 7500 | 0 | 0 | 2015-02-23T13:05:36.077000-05:00 | |
| 1655472 | ROBERTSON, MONAGLE & EASTAUGH LLC eb873dea-e6d3-4eee-9e61-4a9c3f67e7bd | Q1 | ROBERTSON, MONAGLE & EASTAUGH LLC | 33454 | ALEUTIANS EAST BOROUGH | 2015 | first_quarter | TRA | King Cove-Cold Bay Road | Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,Natl Oceanic & Atmospheric Administration (NOAA),SENATE,U.S. Fish & Wildlife Service (USFWS) | 18900 | 0 | 0 | 2015-02-23T14:59:53.590000-05:00 | |
| 1655473 | ROBERTSON, MONAGLE & EASTAUGH LLC eb873dea-e6d3-4eee-9e61-4a9c3f67e7bd | Q1 | ROBERTSON, MONAGLE & EASTAUGH LLC | 33454 | ALEUTIANS EAST BOROUGH | 2015 | first_quarter | CAW | Proposed Clean Water Act rules imposing NPDES permits on fishing vessel discharges | Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,Natl Oceanic & Atmospheric Administration (NOAA),SENATE,U.S. Fish & Wildlife Service (USFWS) | 18900 | 0 | 0 | 2015-02-23T14:59:53.590000-05:00 | |
| 1655474 | ROBERTSON, MONAGLE & EASTAUGH LLC eb873dea-e6d3-4eee-9e61-4a9c3f67e7bd | Q1 | ROBERTSON, MONAGLE & EASTAUGH LLC | 33454 | ALEUTIANS EAST BOROUGH | 2015 | first_quarter | NAT | Crab Rationalization Right of First Refusal Community Protection-Pt. Moller shares | Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,Natl Oceanic & Atmospheric Administration (NOAA),SENATE,U.S. Fish & Wildlife Service (USFWS) | 18900 | 0 | 0 | 2015-02-23T14:59:53.590000-05:00 | |
| 1655475 | ROBERTSON, MONAGLE & EASTAUGH LLC eb873dea-e6d3-4eee-9e61-4a9c3f67e7bd | Q1 | ROBERTSON, MONAGLE & EASTAUGH LLC | 33454 | ALEUTIANS EAST BOROUGH | 2015 | first_quarter | BUD | Funding for Cold Bay Health Clinic Funding for King Cove, Cold Bay, and Akun harbors | Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,Natl Oceanic & Atmospheric Administration (NOAA),SENATE,U.S. Fish & Wildlife Service (USFWS) | 18900 | 0 | 0 | 2015-02-23T14:59:53.590000-05:00 | |
| 1655476 | NATIONAL PEST MANAGEMENT ASSOCIATION e8a2cae4-dc96-469d-a588-827413db26c7 | 1T | NATIONAL PEST MANAGEMENT ASSOCIATION | 28333 | NATIONAL PEST MANAGEMENT ASSOCIATION | 2015 | first_quarter | AGR | Opposed APHIS rulemaking increasing agricultural quarantine inspection fees | HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB) | 0 | 1 | 2015-02-24T11:55:23.633000-05:00 | ||
| 1655477 | THE CHWAT GROUP 22c9bb4e-cb58-4b67-889c-05f25e64f900 | 1TY | THE CHWAT GROUP | 9192 | VORSANA | 2015 | first_quarter | 10000 | 0 | 1 | 2015-02-25T14:36:51.077000-05:00 | ||||
| 1655478 | CASSIDY & ASSOCIATES, INC. 81b35fe5-fadf-4ad4-9f13-17e41b0bf17a | 1TY | CASSIDY & ASSOCIATES, INC. | 8453 | IOWA STATE UNIVERSITY | 2015 | first_quarter | 0 | 1 | 2015-02-26T11:29:04.210000-05:00 | |||||
| 1655479 | GEPHARDT GROUP GOVERNMENT AFFAIRS 92f3aae0-0150-46ab-bde3-be866ac38bc5 | 1T | GEPHARDT GROUP GOVERNMENT AFFAIRS | 315717 | PORT OF OAKLAND | 2015 | first_quarter | AVI | passenger facility charge | Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2015-02-26T17:57:38.207000-05:00 | |
| 1655480 | GEPHARDT GROUP GOVERNMENT AFFAIRS 92f3aae0-0150-46ab-bde3-be866ac38bc5 | 1T | GEPHARDT GROUP GOVERNMENT AFFAIRS | 315717 | PORT OF OAKLAND | 2015 | first_quarter | HOM | Customs and Border Protection staffing; port security grant | Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2015-02-26T17:57:38.207000-05:00 | |
| 1655481 | BALL JANIK LLP 8bbd5ca7-59dc-4758-affc-f4e931295939 | 1T | BALL JANIK LLP | 5222 | LEUPOLD & STEVENS | 2015 | first_quarter | DEF | FY 16 DOD appropriations and authorizations | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2015-02-27T15:52:52.597000-05:00 | |
| 1655482 | BALL JANIK LLP 6a68250f-0a6c-45e2-9b37-7db145f43f5f | 1T | BALL JANIK LLP | 5222 | DURANT & ZIOBRO LLC | 2015 | first_quarter | DEF | Defense authorizations, medical programs and policies. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2015-02-27T16:06:54.073000-05:00 | ||
| 1655483 | BALL JANIK LLP 855be3d6-f991-4721-a309-b42a71fe324f | 1T | BALL JANIK LLP | 5222 | LEKTRO INC | 2015 | first_quarter | DEF | DOD FY 16 Appropriation, Air Force Research and Development funding. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2015-02-27T16:18:55.417000-05:00 | ||
| 1655484 | GEPHARDT GROUP GOVERNMENT AFFAIRS fe72de14-e176-4a26-a707-abae1d945f21 | 1T | GEPHARDT GROUP GOVERNMENT AFFAIRS | 315717 | LOS ANGELES WORLD AIRPORTS (LAWA) | 2015 | first_quarter | TRA | passenger facility charge; runway modernization | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 40000 | 0 | 1 | 2015-03-01T16:52:08.870000-05:00 | |
| 1655485 | GEPHARDT GROUP GOVERNMENT AFFAIRS fe72de14-e176-4a26-a707-abae1d945f21 | 1T | GEPHARDT GROUP GOVERNMENT AFFAIRS | 315717 | LOS ANGELES WORLD AIRPORTS (LAWA) | 2015 | first_quarter | AVI | passenger facility charge; runway modernization | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 40000 | 0 | 1 | 2015-03-01T16:52:08.870000-05:00 | |
| 1655486 | ROBERTSON, MONAGLE & EASTAUGH LLC 8d0bebc3-3a3b-46a7-a58d-d77c9cbae756 | Q1 | ROBERTSON, MONAGLE & EASTAUGH LLC | 33454 | AMERICAN PRESIDENT LINES | 2015 | first_quarter | BUD | Funding for the Maritime Security Program. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2015-03-03T10:02:38.873000-05:00 | ||
| 1655487 | BOCKORNY GROUP, INC. ce5ff12e-6a56-401e-9931-e98165838ee0 | 1T | BOCKORNY GROUP, INC. | 289773 | NEWS CORPORATION | 2015 | first_quarter | MIA | Introductory meetings focused on the opening of a new Washington office and staff; no public policy or legislative issues discussed. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 1 | 2015-03-03T10:10:44.813000-05:00 | |
| 1655488 | ROBERTSON, MONAGLE & EASTAUGH LLC 85245e66-002e-4edc-844c-783293cf8bd1 | Q1 | ROBERTSON, MONAGLE & EASTAUGH LLC | 33454 | MAERSK INC. (FKA MAERSK LINES LTD) | 2015 | first_quarter | MAR | Proposed legislation authorizing changes to the Food For Peace Program and the Maritime Security Act. | HOUSE OF REPRESENTATIVES,SENATE | 11250 | 0 | 0 | 2015-03-03T11:09:59.330000-05:00 | |
| 1655489 | ROBERTSON, MONAGLE & EASTAUGH LLC 85245e66-002e-4edc-844c-783293cf8bd1 | Q1 | ROBERTSON, MONAGLE & EASTAUGH LLC | 33454 | MAERSK INC. (FKA MAERSK LINES LTD) | 2015 | first_quarter | BUD | Funding for the Maritime Security Program in Transportation Appropriations Bill | HOUSE OF REPRESENTATIVES,SENATE | 11250 | 0 | 0 | 2015-03-03T11:09:59.330000-05:00 | |
| 1655490 | ROBERTSON, MONAGLE & EASTAUGH LLC d267e83b-ba78-46e8-be9d-2dcfa26c271a | Q1 | ROBERTSON, MONAGLE & EASTAUGH LLC | 33454 | CITY OF KODIAK | 2015 | first_quarter | NAT | (1) Support for Karluk Lake Nourishment Project (2) Rural Subsistence Determination under ANILCA | HOUSE OF REPRESENTATIVES,SENATE | 7000 | 0 | 0 | 2015-03-04T09:45:14.860000-05:00 | |
| 1655491 | ROBERTSON, MONAGLE & EASTAUGH LLC d267e83b-ba78-46e8-be9d-2dcfa26c271a | Q1 | ROBERTSON, MONAGLE & EASTAUGH LLC | 33454 | CITY OF KODIAK | 2015 | first_quarter | CAW | (1) Clean Water Act proposed regulations defining "Waters of the U.S." (2) Proposed Clean Water Act rules imposing NPDES permits on fishing vessel discharges | HOUSE OF REPRESENTATIVES,SENATE | 7000 | 0 | 0 | 2015-03-04T09:45:14.860000-05:00 | |
| 1655492 | ROBERTSON, MONAGLE & EASTAUGH LLC d267e83b-ba78-46e8-be9d-2dcfa26c271a | Q1 | ROBERTSON, MONAGLE & EASTAUGH LLC | 33454 | CITY OF KODIAK | 2015 | first_quarter | BUD | Funding for Gulf of Alaska fishery surveys | HOUSE OF REPRESENTATIVES,SENATE | 7000 | 0 | 0 | 2015-03-04T09:45:14.860000-05:00 | |
| 1655493 | ROBERTSON, MONAGLE & EASTAUGH LLC 8e620f95-a9f6-4a20-a7aa-032ffee1d7bb | Q1 | ROBERTSON, MONAGLE & EASTAUGH LLC | 33454 | VT HALTER MARINE INC | 2015 | first_quarter | DEF | (1) Sale of Fast Missile Craft to the Government of Egypt under the Foreign Military Sales Program. (2) Navy procurement of the TAO-X. | HOUSE OF REPRESENTATIVES,SENATE | 19500 | 0 | 0 | 2015-03-04T09:58:21.803000-05:00 | |
| 1655494 | ROBERTSON, MONAGLE & EASTAUGH LLC 8e620f95-a9f6-4a20-a7aa-032ffee1d7bb | Q1 | ROBERTSON, MONAGLE & EASTAUGH LLC | 33454 | VT HALTER MARINE INC | 2015 | first_quarter | MAR | Amendments to the Jones Act and the cabotage laws | HOUSE OF REPRESENTATIVES,SENATE | 19500 | 0 | 0 | 2015-03-04T09:58:21.803000-05:00 | |
| 1655495 | ROBERTSON, MONAGLE & EASTAUGH LLC d5620a4c-5900-400d-be9c-d851113aae71 | Q1Y | ROBERTSON, MONAGLE & EASTAUGH LLC | 33454 | OUNALASHKA CORPORATION | 2015 | first_quarter | 0 | 0 | 2015-03-05T09:16:43.020000-05:00 | |||||
| 1655496 | ROBERTSON, MONAGLE & EASTAUGH LLC 0404359a-4ad0-49c2-8556-2f4b16880e05 | Q1 | ROBERTSON, MONAGLE & EASTAUGH LLC | 33454 | KODIAK ISLAND BOROUGH | 2015 | first_quarter | NAT | Support for Karluk Lake Nourishment Project Rural Subsistence Determination under ANILCA Reauthorization of Magnuson-Stevens Act | HOUSE OF REPRESENTATIVES,SENATE | 6750 | 0 | 0 | 2015-03-05T09:43:45.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);