home / lobbying

lobbying_activities

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

159,677 rows where filing_year = 2019 sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code >30

  • BUD 14,560
  • HCR 11,696
  • TAX 11,133
  • TRD 7,106
  • DEF 6,802
  • TRA 6,802
  • MMM 5,925
  • ENG 4,982
  • ENV 4,080
  • EDU 4,059
  • AGR 3,655
  • FIN 3,556
  • TEC 3,241
  • NAT 3,143
  • LBR 3,086
  • HOM 2,894
  • GOV 2,790
  • IMM 2,763
  • BAN 2,299
  • SCI 1,944
  • CSP 1,896
  • CPT 1,852
  • LAW 1,760
  • AVI 1,749
  • CAW 1,638
  • FOR 1,627
  • HOU 1,566
  • VET 1,558
  • INS 1,515
  • MAR 1,400
  • …

filing_period 4

  • fourth_quarter 40,251
  • third_quarter 40,103
  • second_quarter 39,866
  • first_quarter 39,457

filing_year 1

  • 2019 · 159,677 ✖
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
2260468 MILNE, WIENER & SHOFE GLOBAL STRATEGIES (FKA M & W GOVERNMENT AFFAIRS, LLC) 2a3d8a2e-53c0-4014-ae66-0d2af7c10353 1TY MILNE, WIENER & SHOFE GLOBAL STRATEGIES (FKA M & W GOVERNMENT AFFAIRS, LLC) 401104432 INTERNATIONAL PREMIUM CIGAR & PIPE RETAILERS ASSOCIATION (IPCPR) 2019 first_quarter           0 1 2019-01-10T13:28:37.237000-05:00
2260469 THE PRENDA GROUP LLC 8d6aa27a-bbe4-4ded-ad05-f63339968dd0 1@Y THE PRENDA GROUP LLC 401104543 EXCELERATE ENERGY LP 2019 first_quarter           0 1 2019-01-11T15:09:10-05:00
2260470 SANDLER TRADE, LLC 3ef7fe68-f54b-4ee4-ac82-a892066a90d4 1TY SANDLER TRADE, LLC 400751250 EMBASSY OF THE PLURINATIONAL STATE OF BOLIVIA 2019 first_quarter           0 1 2019-01-15T13:41:29.293000-05:00
2260471 PENN AVENUE PARTNERS d825b8cf-4fed-42a9-9ad0-648b0183f837 1T PENN AVENUE PARTNERS 400918672 PURDUE PHARMA L.P. 2019 first_quarter PHA Monitoring legislative and regulatory activities impacting the pharmaceutical industry.   20000   0 1 2019-01-16T17:34:48.747000-05:00
2260472 JAHANIAN STRATEGIES LLC 0d1ff94f-3f21-4e15-ab73-887ec7a14e58 1TY JAHANIAN STRATEGIES LLC 401104346 WTPPG ON BEHALF OF ALLIANCE FOR BIOPHARMACEUTICAL COMPETITIVENESS & INNOVATION 2019 first_quarter           0 1 2019-01-17T16:33:21.777000-05:00
2260473 JAHANIAN STRATEGIES LLC 3f2c3285-d60e-4c76-ab27-616a623351cd 1TY JAHANIAN STRATEGIES LLC 401104346 THE WASHINGTON TAX & PUBLIC POLICY GROUP ON BEHALF OF THE TAX REFORM COALITION 2019 first_quarter           0 1 2019-01-17T16:36:24.750000-05:00
2260474 JAHANIAN STRATEGIES LLC ef42d3ee-024a-445e-ac9a-ce5152653734 1TY JAHANIAN STRATEGIES LLC 401104346 INTEL CORPORATION 2019 first_quarter           0 1 2019-01-17T16:38:27.800000-05:00
2260475 WHITMER & WORRALL, LLC f2ab24f2-4c19-4d8a-8b9e-b208f9aa2603 1TY WHITMER & WORRALL, LLC 292892 HONEYWELL INTERNATIONAL INC. 2019 first_quarter           0 1 2019-01-18T10:45:43.807000-05:00
2260476 RAFFANIELLO & ASSOCIATES d432936d-278e-4b09-8bba-26b342a6835c 1TY RAFFANIELLO & ASSOCIATES 400290378 NUCLEAR ENERGY INSTITUTE 2019 first_quarter           0 1 2019-01-18T11:46:16.830000-05:00
2260477 RAFFANIELLO & ASSOCIATES c5619330-40c7-48a5-883a-fbaaaf0875a6 1TY RAFFANIELLO & ASSOCIATES 400290378 SCANA CORPORATION 2019 first_quarter           0 1 2019-01-18T11:53:42.513000-05:00
2260478 RAFFANIELLO & ASSOCIATES 3f193d85-913f-4711-99c5-0ee8a0621693 1TY RAFFANIELLO & ASSOCIATES 400290378 LEDIC REALTY COMPANY, LLC 2019 first_quarter           0 1 2019-01-18T11:56:57.973000-05:00
2260479 RISSING STRATEGIC LLC d03ab691-3bf4-45ec-aa4f-40eddf813d27 Q1 RISSING STRATEGIC LLC 71792 TXU ENERGY 2019 first_quarter BUD Low Income Home Energy Assistance Program (LIHEAP) -- appropriations Weatherization -- appropriations Administration for Children & Families (ACF),Energy, Dept of,Office of Management & Budget (OMB)     0 0 2019-01-18T12:46:22.820000-05:00
2260480 CARMEN GROUP INCORPORATED cf9dc38c-9528-4c4e-97f1-2ca5f947f760 1T CARMEN GROUP INCORPORATED 8316 PROMERICA FINANCIAL CORPORATION 2019 first_quarter BAN Legislative and administration monitoring and outreach on issues affecting the international banking industry. HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Treasury, Dept of,White House Office     0 1 2019-01-18T12:49:33.873000-05:00
2260481 CARMEN GROUP INCORPORATED a2303bb9-2c82-4bc9-a96c-e261a8dcb2f1 1TY CARMEN GROUP INCORPORATED 8316 BIOREFERENCE LABORATORIES, INC. 2019 first_quarter           0 1 2019-01-18T12:54:48.977000-05:00
2260482 CARMEN GROUP INCORPORATED a8406193-b8cd-41f0-96b4-265b03a7b7c4 1@ CARMEN GROUP INCORPORATED 8316 PROMERICA FINANCIAL CORPORATION 2019 first_quarter BAN Legislative and administration monitoring and outreach on issues affecting the international banking industry. HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Treasury, Dept of,White House Office     0 1 2019-01-23T14:14:02.057000-05:00
2260483 THE MCKEON GROUP, INC. 9ba79f8a-b4c5-49bc-a550-a05e8ca20440 1TY THE MCKEON GROUP, INC. 401103598 PREVENT CHILD ABUSE AMERICA 2019 first_quarter           0 1 2019-01-25T15:08:24.877000-05:00
2260484 EOP GROUP, INC. 81395cde-2514-4ebf-a101-df04c71677ba Q1Y EOP GROUP, INC. 13712 CROPLIFE AMERICA 2019 first_quarter       35000   0 0 2019-01-28T12:54:41.520000-05:00
2260485 EOP GROUP, INC. 0ddc0a65-41cb-4dc7-a063-87c3976b818a Q1Y EOP GROUP, INC. 13712 EDISON ELECTRIC INSTITUTE 2019 first_quarter           0 0 2019-01-28T12:56:42.397000-05:00
2260486 EOP GROUP, INC. 205bcd47-4a6f-49dc-8434-1de9e5c140bc Q1Y EOP GROUP, INC. 13712 NUCLEAR ENERGY INSTITUTE 2019 first_quarter           0 0 2019-01-28T12:59:45.013000-05:00
2260487 EOP GROUP, INC. 65b03551-04b5-49d2-9ba3-b1ca5e272f02 Q1Y EOP GROUP, INC. 13712 ENTERGY 2019 first_quarter           0 0 2019-01-28T13:01:48.517000-05:00
2260488 EOP GROUP, INC. 9bbf79db-32b0-442a-9b70-98ac7ec2faa3 Q1Y EOP GROUP, INC. 13712 SHINTECH, INC. 2019 first_quarter           0 0 2019-01-28T13:06:57.523000-05:00
2260489 EOP GROUP, INC. 0fa209a6-6518-47de-82ce-8a6e64c5f291 Q1Y EOP GROUP, INC. 13712 CONSTELLATION ENERGY 2019 first_quarter           0 0 2019-01-28T13:10:02.450000-05:00
2260490 EOP GROUP, INC. 2459c025-baa9-4fd0-b0e7-ba638150a663 Q1Y EOP GROUP, INC. 13712 GENERAL MOTORS 2019 first_quarter           0 0 2019-01-28T13:14:05.660000-05:00
2260491 EOP GROUP, INC. 9e2807bc-23f9-4681-bae8-0e3a0166ea71 Q1Y EOP GROUP, INC. 13712 ENTERGY NEW ORLEANS INC. 2019 first_quarter           0 0 2019-01-28T13:15:07.757000-05:00
2260492 EDWIN HUDDLESON 4c6c8f0d-4641-4503-a146-3c308d982dc2 1TY EDWIN HUDDLESON 53072 EQUIPMENT LEASING AND FINANCE ASSOCIATION 2019 first_quarter           0 1 2019-01-28T13:59:19.737000-05:00
2260493 B+S STRATEGIES 22ebf5fa-35ac-49c7-99b1-a5dc9bbc0aba 1TY B+S STRATEGIES 401104101 ALLIANCE OF AUTOMOBILE MANUFACTURERS 2019 first_quarter           0 1 2019-01-29T09:43:48.170000-05:00
2260494 OFF HILL STRATEGIES L.L.C. ce59f84d-1615-4331-9721-5ae6a9a0831f 1TY OFF HILL STRATEGIES L.L.C. 401103327 EBAY 2019 first_quarter           0 1 2019-01-29T14:09:24.123000-05:00
2260495 FUEL CELL AND HYDROGEN ENERGY ASSOCIATION 302e5118-3457-464b-8f63-b7b61791cc67 Q1Y FUEL CELL AND HYDROGEN ENERGY ASSOCIATION 400761273 FUEL CELL AND HYDROGEN ENERGY ASSOCIATION 2019 first_quarter           0 0 2019-01-31T13:18:25.863000-05:00
2260496 MBDA INCORPORATED 1014fee7-c162-4695-ac5d-e66ae9645675 1TY MBDA INCORPORATED 400506493 MBDA INCORPORATED 2019 first_quarter           0 1 2019-01-31T14:32:35.847000-05:00
2260497 J P FORD STRATEGIES, LLC b710261a-0fdc-45d6-b58f-15f21438b15e 1TY J P FORD STRATEGIES, LLC 401104934 NEVRO CORPORATION 2019 first_quarter           0 1 2019-01-31T14:43:39.660000-05:00
2260498 CAPITOL NETWORK LLC(FKA MR. DAVID DISTEFANO) 9179eb92-c21c-4475-8c44-abac360e37cb 1T CAPITOL NETWORK LLC(FKA MR. DAVID DISTEFANO) 78733 RAI SERVICES COMPANY (FKA REYNOLDS AMERICAN, INC.) 2019 first_quarter TOB tobacco HOUSE OF REPRESENTATIVES,SENATE     0 1 2019-01-31T15:36:46.157000-05:00
2260499 THE MCKEON GROUP, INC. 88031ed1-4393-4f88-b52c-b11d9c1d060e 1TY THE MCKEON GROUP, INC. 401103598 THE COUNCIL OF PARENT ATTORNEYS AND ADVOCATES, INC. 2019 first_quarter           0 1 2019-01-31T17:14:55.210000-05:00
2260500 LIBERTY GOVERNMENT AFFAIRS 8efe606c-3b0f-4b86-8cb6-322468880539 1T LIBERTY GOVERNMENT AFFAIRS 401104531 WEEDMAPS 2019 first_quarter BUD Appropriations rider preventing prosecution of states that allow medical marijuana. HOUSE OF REPRESENTATIVES,SENATE 5000   0 1 2019-02-01T11:14:41.910000-05:00
2260501 LIBERTY GOVERNMENT AFFAIRS 8efe606c-3b0f-4b86-8cb6-322468880539 1T LIBERTY GOVERNMENT AFFAIRS 401104531 WEEDMAPS 2019 first_quarter MED Medical marijuana research. HOUSE OF REPRESENTATIVES,SENATE 5000   0 1 2019-02-01T11:14:41.910000-05:00
2260502 LIBERTY GOVERNMENT AFFAIRS 8efe606c-3b0f-4b86-8cb6-322468880539 1T LIBERTY GOVERNMENT AFFAIRS 401104531 WEEDMAPS 2019 first_quarter LAW Criminal justice reform as it applies to marijuana prosecutions. HOUSE OF REPRESENTATIVES,SENATE 5000   0 1 2019-02-01T11:14:41.910000-05:00
2260503 A.G. KAFFES AND ASSOCIATES LLC ea5b7128-60a2-4cd8-9843-c21a1fe2d632 1T A.G. KAFFES AND ASSOCIATES LLC 317993 ORAL HEALTH AMERICA 2019 first_quarter HCR S.22, Medicare Dental Benefit Act of 2019. Support. SENATE     0 1 2019-02-01T17:34:28.130000-05:00
2260504 BROWN RUDNICK LLP c7665417-9a30-40f5-9031-ee9ad7e354c1 1TY BROWN RUDNICK LLP 287895 AMNEAL PHARMACEUTICALS 2019 first_quarter       20000   0 1 2019-02-01T18:10:35.160000-05:00
2260505 CLARISSA J MIDDLETON, LOBBYIST 7c7a5e12-cae8-4ff2-aa96-e3623faca1b7 Q1 CLARISSA J MIDDLETON, LOBBYIST 401105013 MARKETWOMEN GLOBAL DEVELOPMENT 2019 first_quarter IMM {contact_data~salutation} This is a lobbying form letter and I know your office gets flooded with them. But I have read the content and wholeheartedly agree something must be done... I lend my voice and highly urge my Georgia sons (our Georgia elected officials) to support the passage of the Visa Transparency Anti-Trafficking Act of 2018, which seeks to prevent human trafficking by bringing more openness to the foreign temporary worker visa process. We don't want to harass workers, but we need to hold their employers accountable. I worked on Capitol Hill for Congressman John Lewis and lobbyied for Labor with the Boilermakers and we lobbied in support of HB1 Visas but that was nearly twenty years ago...They HB1 and work Visa is being used as a bargaining chip now. There are people who do not hold their own passport or Visa-the business owner holds it HOSTAGE! They are threatened with deportation if they tell anyone. Millions of foreign individuals are authorized to work in the United States every year on temporary, non-immigrant visas. Abusive employers are bringing foreign workers to the United States with the expectation of legitimate jobs, only to coerce them into unbearable conditions, including sex slavery and domestic servitude. Federal data on these temporary work visas is not uniformly reported and not available to the public, impeding law enforcements efforts to crack down on this form of human trafficking. The Visa Transparency Anti-Trafficking Act provides a straightforward solution to gaps in reporting, by requiring a standardized reporting system, expanding reports to include critical information, and providing governments, advocates, and the public with the data needed to develop trafficking prevention programs. The Visa Transparency Anti-Trafficking Act is also supported by AFL-CIO, Alliance to End Slavery & Trafficking (ATEST), American Federation of Teachers, Centro de los Derechos del Migrante, Coalition of Immokalee Workers, Coalition to Abolish Slavery & Trafficking (CAST), Economic Policy I… HOUSE OF REPRESENTATIVES,SENATE     0 0 2019-02-01T18:30:38.537000-05:00
2260506 CLARISSA J MIDDLETON, LOBBYIST 7c7a5e12-cae8-4ff2-aa96-e3623faca1b7 Q1 CLARISSA J MIDDLETON, LOBBYIST 401105013 MARKETWOMEN GLOBAL DEVELOPMENT 2019 first_quarter LBR {contact_data~salutation} This is a lobbying form letter and I know your office gets flooded with them. But I have read the content and wholeheartedly agree something must be done... I lend my voice and highly urge my Georgia sons (our Georgia elected officials) to support the passage of the Visa Transparency Anti-Trafficking Act of 2018, which seeks to prevent human trafficking by bringing more openness to the foreign temporary worker visa process. We don't want to harass workers, but we need to hold their employers accountable. I worked on Capitol Hill for Congressman John Lewis and lobbyied for Labor with the Boilermakers and we lobbied in support of HB1 Visas but that was nearly twenty years ago...They HB1 and work Visa is being used as a bargaining chip now. There are people who do not hold their own passport or Visa-the business owner holds it HOSTAGE! They are threatened with deportation if they tell anyone. Millions of foreign individuals are authorized to work in the United States every year on temporary, non-immigrant visas. Abusive employers are bringing foreign workers to the United States with the expectation of legitimate jobs, only to coerce them into unbearable conditions, including sex slavery and domestic servitude. Federal data on these temporary work visas is not uniformly reported and not available to the public, impeding law enforcements efforts to crack down on this form of human trafficking. The Visa Transparency Anti-Trafficking Act provides a straightforward solution to gaps in reporting, by requiring a standardized reporting system, expanding reports to include critical information, and providing governments, advocates, and the public with the data needed to develop trafficking prevention programs. The Visa Transparency Anti-Trafficking Act is also supported by AFL-CIO, Alliance to End Slavery & Trafficking (ATEST), American Federation of Teachers, Centro de los Derechos del Migrante, Coalition of Immokalee Workers, Coalition to Abolish Slavery & Trafficking (CAST), Economic Policy I… HOUSE OF REPRESENTATIVES,SENATE     0 0 2019-02-01T18:30:38.537000-05:00
2260507 JONES WALDO HOLBROOK & MCDONOUGH d20cc9ae-e1be-48c0-b480-e33e69091b02 1TY JONES WALDO HOLBROOK & MCDONOUGH 20870 ROCKY VISTA UNIVERSITY COLLEGE OF OSTEOPATHIC MEDICINE- SOUTHERN UTAH 2019 first_quarter           0 1 2019-02-02T17:39:15.680000-05:00
2260508 MS. MELINDA RAY 1b5e344a-00d5-4283-a550-f5666af5a13e 1TY MS. MELINDA RAY 314591 NATIONAL ASSOCIATION OF CLINICAL NURSE SPECILIALISTS 2019 first_quarter           0 1 2019-02-04T13:02:40.537000-05:00
2260509 STRATACOMM LLC 5ee89cb0-af2a-4fd2-ab8d-13158b96f8bf 1TY STRATACOMM LLC 36925 UNICA (UNIAO DE INDUSTRIA DE CANA-DE-ACUCAR) BRAZILIAN SUGARCANE INDUSTRY ASSOCI 2019 first_quarter           0 1 2019-02-04T14:44:57.363000-05:00
2260510 BROWN RUDNICK LLP c80146bc-0b95-4f20-aa1c-62f6258d2aae 1T BROWN RUDNICK LLP 287895 APOTEX CORPORATION 2019 first_quarter HCR Public Law 115-52, Section 808, relating to the Competitive Generic Therapy designation; President's FY19 budget proposal relating to generic drug 180-Day exclusivity HOUSE OF REPRESENTATIVES,SENATE 50000   0 1 2019-02-05T14:05:01.903000-05:00
2260511 BROWN RUDNICK LLP a99e5dac-b22b-4fdf-abc4-ecdd93406701 1T BROWN RUDNICK LLP 287895 MEDTRONIC INC 2019 first_quarter HCR issues relating to non-pharmacology pain treatment HOUSE OF REPRESENTATIVES,SENATE 20000   0 1 2019-02-05T14:16:02.890000-05:00
2260512 BROWN RUDNICK LLP a99e5dac-b22b-4fdf-abc4-ecdd93406701 1T BROWN RUDNICK LLP 287895 MEDTRONIC INC 2019 first_quarter MMM issues relating to Medicare value-based health care HOUSE OF REPRESENTATIVES,SENATE 20000   0 1 2019-02-05T14:16:02.890000-05:00
2260513 BROWN RUDNICK LLP 328403a1-2091-4d82-a617-795379bf19b7 1T BROWN RUDNICK LLP 287895 HEALTHCARE DISTRIBUTION ALLIANCE F/K/A HEALTHCARE DISTRIBUTION MANAGEMENT ASSOC 2019 first_quarter HCR Issues relating to affordable pharmaceutical pricing HOUSE OF REPRESENTATIVES,SENATE 60000   0 1 2019-02-05T14:27:04.797000-05:00
2260514 IETAN CONSULTING, LLC 81b22910-ac83-4a8b-ace1-919bf321941c 1T IETAN CONSULTING, LLC 60537 SAN MANUEL BAND OF MISSION INDIANS 2019 first_quarter IND Fee to trust land acquisition, Tribal Labor Sovereignty Act, Tax reform Bureau of Indian Affairs (BIA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE 20000   0 1 2019-02-05T16:00:12.030000-05:00
2260515 JEFFREY J. KIMBELL & ASSOCIATES, INC. 198ee80f-db9d-4664-9cf2-08ade9bc90a4 1T JEFFREY J. KIMBELL & ASSOCIATES, INC. 46038 SUPERIOR AIR-GROUND AMBULANCE SERVICES 2019 first_quarter MMM Medicare and Medicaid policies relating to ground and air ambulance services HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2019-02-05T16:09:16.530000-05:00
2260516 JEFFREY J. KIMBELL & ASSOCIATES, INC. 70ceffa5-1de3-4f52-a3fd-7cbbaf00dfee 1T JEFFREY J. KIMBELL & ASSOCIATES, INC. 46038 ACADIAN AMBULANCE 2019 first_quarter MMM Medicare and Medicaid policies relating to ground and air ambulance services HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2019-02-05T16:14:24.303000-05:00
2260517 JEFFREY J. KIMBELL & ASSOCIATES, INC. 55977011-754c-4e4d-89e9-546231f9eea8 1T JEFFREY J. KIMBELL & ASSOCIATES, INC. 46038 FALCK USA, INC. 2019 first_quarter MMM Medicare and Medicaid policies relating to ground and air ambulance services HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2019-02-05T16:18:25.733000-05:00
2260518 HIGH STREET STRATEGIES LLC cc3dad46-528a-4de4-8a19-db15c95c18ae 1TY HIGH STREET STRATEGIES LLC 401103779 EAST COAST SHELLFISH GROWERS ASSOCIATION 2019 first_quarter           0 1 2019-02-06T14:21:20.557000-05:00
2260519 POLSINELLI PC 63e9220a-0f9d-4d9c-b6e7-4572b55fb48c 1T POLSINELLI PC 314911 AMERICAN REGISTRY OF RADIOLOGIC TECHNOLOGISTS 2019 first_quarter MMM Issues related to Medicare coverage of medical imaging services performed by radiologist assistants; Proposed CY2019 Medicare Physician Fee Schedule Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE     0 1 2019-02-06T14:48:23.210000-05:00
2260520 KAE STRATEGIC, LLC 1c81f8f4-ed28-41cf-9f7f-a03ab5abb8ab 1T KAE STRATEGIC, LLC 401104930 SIXKILLER CONSULTING, LLC OBO TRUST FOR UNIVERSITY INNOVATION IN VIETNAM (TUIV) 2019 first_quarter BUD FY19, Department of State, Foreign Operations, and Related Programs Appropriations (H.R.648); including funding for educational and cultural exchange programs. HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS) 10000   0 1 2019-02-07T09:11:56.510000-05:00
2260521 CARPI & CLAY, INC e0758987-9510-4696-9618-b6bd02e2f951 1TY CARPI & CLAY, INC 35640 VAN SCOYOC ASSOCIATION ON BEHALF OF MISSION SPRINGS WATER DISTRICT 2019 first_quarter           0 1 2019-02-07T11:51:04.650000-05:00
2260522 THE MCKEON GROUP, INC. 2759b8d5-29a6-4910-8675-bbe01c13ca0d 1TY THE MCKEON GROUP, INC. 401103598 PARENTS AS TEACHERS (PAT) 2019 first_quarter           0 1 2019-02-07T14:28:13.550000-05:00
2260523 BROWN RUDNICK LLP d5a9606a-9e59-4e82-9390-75ace304f97f 1T BROWN RUDNICK LLP 287895 PRIME THERAPEUTICS 2019 first_quarter HCR HHS Blueprint to Lower Drug Prices and Reduce Out-of-Pocket Costs. HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2019-02-08T15:13:13.777000-05:00
2260524 BROWN RUDNICK LLP d5a9606a-9e59-4e82-9390-75ace304f97f 1T BROWN RUDNICK LLP 287895 PRIME THERAPEUTICS 2019 first_quarter MMM HHS-OIG rule RIN-936-AAO8,Removal of Safe Harbor Protections for Rebates to Plans or PBMs Involving Prescription Pharmaceuticals and Creation of New Safe Harbor Protection. HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2019-02-08T15:13:13.777000-05:00
2260525 BROWN RUDNICK LLP 5d77be3e-1aab-4b82-a6a7-cce34754d549 1TY BROWN RUDNICK LLP 287895 LUPIN PHARMACEUTICALS, INC 2019 first_quarter       10000   0 1 2019-02-08T15:23:16.247000-05:00
2260526 BROWN RUDNICK LLP cd42d749-9ef3-41f7-97f9-3bcb1763e948 1T BROWN RUDNICK LLP 287895 HOOPER LUNDY & BOOKMAN P C (OBO ROCHE DIAGNOSTICS) 2019 first_quarter MED The Verifying Accurate Leading-edge IVCT Development Act. HOUSE OF REPRESENTATIVES,SENATE 5000   0 1 2019-02-08T15:40:19.023000-05:00
2260527 MEHLMAN CONSULTING, INC. 5064d0fb-a06b-4334-8311-992048df4e04 1TY MEHLMAN CONSULTING, INC. 284950 VIRTUS PHARMACEUTICALS LLC 2019 first_quarter           0 1 2019-02-12T14:01:20.460000-05:00
2260528 HARLOW GOVERNMENT RELATIONS LLC e0e541df-e14f-4e7e-86b6-d66f7aff6135 1TY HARLOW GOVERNMENT RELATIONS LLC 400745232 KOREIN TILLERY LLC 2019 first_quarter       15000   0 1 2019-02-13T11:38:13.083000-05:00
2260529 PAW AND ASSOCIATES 46f6ae70-b273-4652-96b3-31ae5b60bf35 1TY PAW AND ASSOCIATES 74875 AIRLAND ENTERPRISES LLC 2019 first_quarter           0 1 2019-02-13T11:59:16.367000-05:00
2260530 MCMILLAN & YOUNG POLICY CONSULTANTS LLC 6a499e97-1111-45d1-852d-5b2f7d35289d Q1 MCMILLAN & YOUNG POLICY CONSULTANTS LLC 401105073 AFRICAN AMERICAN AGRICULTURALIST ASSOCIATION 2019 first_quarter AGR Regarding issues of USDA grants, and Pigford lawsuits Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2019-02-13T16:21:31.980000-05:00
2260531 MCMILLAN & YOUNG POLICY CONSULTANTS LLC 6a499e97-1111-45d1-852d-5b2f7d35289d Q1 MCMILLAN & YOUNG POLICY CONSULTANTS LLC 401105073 AFRICAN AMERICAN AGRICULTURALIST ASSOCIATION 2019 first_quarter CIV Regarding Pigford lawsuits and appropriations Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2019-02-13T16:21:31.980000-05:00
2260532 MCMILLAN & YOUNG POLICY CONSULTANTS LLC 19d20a96-0098-45e1-99f0-f5fede24e205 1A MCMILLAN & YOUNG POLICY CONSULTANTS LLC 401105073 AFRICAN AMERICAN AGRICULTURALIST ASSOCIATION 2019 first_quarter CIV Regarding Pigford lawsuits and appropriations Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE     0 0 2019-02-13T16:53:36.550000-05:00
2260533 MCMILLAN & YOUNG POLICY CONSULTANTS LLC 19d20a96-0098-45e1-99f0-f5fede24e205 1A MCMILLAN & YOUNG POLICY CONSULTANTS LLC 401105073 AFRICAN AMERICAN AGRICULTURALIST ASSOCIATION 2019 first_quarter AGR Regarding issues of USDA grants, and Pigford lawsuits Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE     0 0 2019-02-13T16:53:36.550000-05:00
2260534 FORBES-TATE bb849524-5dc8-422b-bb69-7c0cb6aa9cb5 1T FORBES-TATE 400976792 GREATER YELLOWSTONE COALITION 2019 first_quarter TOU Issues related to potential hard rock mining outside Yellowstone National Park. HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2019-02-14T10:51:58.097000-05:00
2260535 FORBES-TATE bb849524-5dc8-422b-bb69-7c0cb6aa9cb5 1T FORBES-TATE 400976792 GREATER YELLOWSTONE COALITION 2019 first_quarter NAT Issues related to potential hard rock mining outside Yellowstone National Park. HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2019-02-14T10:51:58.097000-05:00
2260536 FORBES-TATE bb849524-5dc8-422b-bb69-7c0cb6aa9cb5 1T FORBES-TATE 400976792 GREATER YELLOWSTONE COALITION 2019 first_quarter ENV Issues related to potential hard rock mining outside Yellowstone National Park; Issues related to endangered species; Issues related to S. 941/H.R. 4644, Yellowstone Gateway Protection Act, all provisions. HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2019-02-14T10:51:58.097000-05:00
2260537 FORBES-TATE 175fcb8a-d232-4233-873f-13057f6c7f2e 1T FORBES-TATE 400976792 CIRCADENCE CORPORATION 2019 first_quarter LBR FY 2019 Appropriations related to cybersecurity and workforce training; H.R. 6157 and S.3159 FY 2019 Appropriations for Defense and Labor/HHS/Education Appropriations Act of 2019, and Continuing Appropriations Act, 2019. HOUSE OF REPRESENTATIVES,SENATE 15000   0 1 2019-02-14T14:07:17.937000-05:00
2260538 FORBES-TATE 175fcb8a-d232-4233-873f-13057f6c7f2e 1T FORBES-TATE 400976792 CIRCADENCE CORPORATION 2019 first_quarter INT FY 2019 Appropriations related to cybersecurity and workforce training; H.R. 6157 and S.3159 FY 2019 Appropriations for Defense and Labor/HHS/Education Appropriations Act of 2019, and Continuing Appropriations Act, 2019. HOUSE OF REPRESENTATIVES,SENATE 15000   0 1 2019-02-14T14:07:17.937000-05:00
2260539 FORBES-TATE 175fcb8a-d232-4233-873f-13057f6c7f2e 1T FORBES-TATE 400976792 CIRCADENCE CORPORATION 2019 first_quarter DEF FY 2019 Appropriations related to cybersecurity and workforce training; H.R. 6157 and S.3159 FY 2019 Appropriations for Defense and Labor/HHS/Education Appropriations Act of 2019, and Continuing Appropriations Act, 2019. HOUSE OF REPRESENTATIVES,SENATE 15000   0 1 2019-02-14T14:07:17.937000-05:00
2260540 FORBES-TATE 175fcb8a-d232-4233-873f-13057f6c7f2e 1T FORBES-TATE 400976792 CIRCADENCE CORPORATION 2019 first_quarter BUD FY 2019 Appropriations related to cybersecurity and workforce training; H.R. 6157 and S.3159 FY 2019 Appropriations for Defense and Labor/HHS/Education Appropriations Act of 2019, and Continuing Appropriations Act, 2019. HOUSE OF REPRESENTATIVES,SENATE 15000   0 1 2019-02-14T14:07:17.937000-05:00
2260541 FORBES-TATE 546ca92f-743e-4656-a167-f17d7d076714 1T FORBES-TATE 400976792 CELLEBRITE INC. 2019 first_quarter DEF Issues related to criminal justice, national security, homeland security, and digital evidence and forensics; Issues related to Commerce, Justice, Science, and Related Agencies Appropriations Act, 2019 (H.R. 5952/S. 3072). Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2019-02-14T14:15:19.510000-05:00
2260542 FORBES-TATE 546ca92f-743e-4656-a167-f17d7d076714 1T FORBES-TATE 400976792 CELLEBRITE INC. 2019 first_quarter LAW Issues related to criminal justice, national security, homeland security, and digital evidence and forensics; Issues related to Commerce, Justice, Science, and Related Agencies Appropriations Act, 2019 (H.R. 5952/S. 3072). Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2019-02-14T14:15:19.510000-05:00
2260543 FORBES-TATE 546ca92f-743e-4656-a167-f17d7d076714 1T FORBES-TATE 400976792 CELLEBRITE INC. 2019 first_quarter HOM Issues related to criminal justice, national security, homeland security, and digital evidence and forensics; Issues related to Commerce, Justice, Science, and Related Agencies Appropriations Act, 2019 (H.R. 5952/S. 3072). Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2019-02-14T14:15:19.510000-05:00
2260544 ADELINE STRATEGIES, LLC dc4eafe8-dce2-46ba-910a-8555dd9395f6 1TY ADELINE STRATEGIES, LLC 401104848 SWISS RE AMERICA HOLDING CORPORATION 2019 first_quarter           0 1 2019-02-14T16:51:37.013000-05:00
2260545 THORN RUN PARTNERS a5a7ad08-3fc2-4f2b-8b7b-e371483f31aa 1TY THORN RUN PARTNERS 400534596 EXPRESS SCRIPTS, INC. 2019 first_quarter           0 1 2019-02-15T09:20:03.623000-05:00
2260546 AMPUTEE COALITION 23c5bdcd-33ff-4420-92b6-571e2bbf728e Q1 AMPUTEE COALITION 400359662 AMPUTEE COALITION 2019 first_quarter HCR Insurance Fairness for Amputees Act (previously introduced legislation) LCD Clarification Act (previously introduced legislation) O&P Improvements Act (previously introduced legislation) Administration on Aging,Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE     0 0 2019-02-15T09:35:04.740000-05:00
2260547 AMPUTEE COALITION 23c5bdcd-33ff-4420-92b6-571e2bbf728e Q1 AMPUTEE COALITION 400359662 AMPUTEE COALITION 2019 first_quarter BUD Funding to support National Limb Loss Resource Center through Administration for Community Living Support for increased funding to NICHD and NCMRR to support rehabilitation and outcomes research Administration on Aging,Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE     0 0 2019-02-15T09:35:04.740000-05:00
2260548 AMPUTEE COALITION 23c5bdcd-33ff-4420-92b6-571e2bbf728e Q1 AMPUTEE COALITION 400359662 AMPUTEE COALITION 2019 first_quarter INS Insurance Fairness for Amputees Act (previously introduced legislation) Administration on Aging,Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE     0 0 2019-02-15T09:35:04.740000-05:00
2260549 AMPUTEE COALITION 23c5bdcd-33ff-4420-92b6-571e2bbf728e Q1 AMPUTEE COALITION 400359662 AMPUTEE COALITION 2019 first_quarter MMM Access to prosthetic care LCD Clarification Act O&P Improvements Act Administration on Aging,Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE     0 0 2019-02-15T09:35:04.740000-05:00
2260550 BROWN & FORTUNATO, P.C. a10eae4f-b44b-4d5c-9884-77fdb81f36ea 1T BROWN & FORTUNATO, P.C. 401104878 INVACARE CORPORATION 2019 first_quarter BUD FY 2019 Military Construction and Veterans Affairs Appropriations Bill Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) 15000   0 1 2019-02-15T12:01:12.350000-05:00
2260551 BROWN & FORTUNATO, P.C. a10eae4f-b44b-4d5c-9884-77fdb81f36ea 1T BROWN & FORTUNATO, P.C. 401104878 INVACARE CORPORATION 2019 first_quarter TAR Monitor and educate lawmakers about impact of proposed and final tariffs on goods from China; monitor and educate lawmakers about impact of tariffs imposed on steel and aluminum from certain countries. Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) 15000   0 1 2019-02-15T12:01:12.350000-05:00
2260552 BROWN & FORTUNATO, P.C. a10eae4f-b44b-4d5c-9884-77fdb81f36ea 1T BROWN & FORTUNATO, P.C. 401104878 INVACARE CORPORATION 2019 first_quarter MMM H.R. 750, Ensuring Access to Quality Complex Rehabilitation Technology Act of 2015; H.R. 3730 to Amend Title XVIII of the Social Security Act to provide for the non-application of Medicare competitive acquisition rates to complex rehabilitative wheelchairs and accessories; S. 486 Protecting Beneficiary Access to Complex Rehab Technology Act of 2017 and H.R. 1361 to Amend Title XVIII of the Social Security Act to provide for the non-application of Medicare competitive acquisition rates to complex rehabilitative manual wheelchairs and accessories; H.R. 4229 Protecting HOME Access Act of 2017. Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) 15000   0 1 2019-02-15T12:01:12.350000-05:00
2260553 CHRIS MCCANNELL 5667cd45-a193-474c-a336-fc25a00b7d5b 1TY CHRIS MCCANNELL 401103926 ETIHAD AIRWAYS PJSC 2019 first_quarter           0 1 2019-02-20T11:31:58.160000-05:00
2260554 CLARISSA J MIDDLETON, LOBBYIST abbe7869-19dd-478b-850a-fb31b36bc6d0 1A CLARISSA J MIDDLETON, LOBBYIST 401105013 MARKETWOMEN GLOBAL DEVELOPMENT 2019 first_quarter IMM {contact_data~salutation} This is a lobbying form letter and I know your office gets flooded with them. But I have read the content and wholeheartedly agree something must be done... I lend my voice and highly urge my Georgia sons (our Georgia elected officials) to support the passage of the Visa Transparency Anti-Trafficking Act of 2018, which seeks to prevent human trafficking by bringing more openness to the foreign temporary worker visa process. We don't want to harass workers, but we need to hold their employers accountable. I worked on Capitol Hill for Congressman John Lewis and lobbyied for Labor with the Boilermakers and we lobbied in support of HB1 Visas but that was nearly twenty years ago...They HB1 and work Visa is being used as a bargaining chip now. There are people who do not hold their own passport or Visa-the business owner holds it HOSTAGE! They are threatened with deportation if they tell anyone. Millions of foreign individuals are authorized to work in the United States every year on temporary, non-immigrant visas. Abusive employers are bringing foreign workers to the United States with the expectation of legitimate jobs, only to coerce them into unbearable conditions, including sex slavery and domestic servitude. Federal data on these temporary work visas is not uniformly reported and not available to the public, impeding law enforcements efforts to crack down on this form of human trafficking. The Visa Transparency Anti-Trafficking Act provides a straightforward solution to gaps in reporting, by requiring a standardized reporting system, expanding reports to include critical information, and providing governments, advocates, and the public with the data needed to develop trafficking prevention programs. The Visa Transparency Anti-Trafficking Act is also supported by AFL-CIO, Alliance to End Slavery & Trafficking (ATEST), American Federation of Teachers, Centro de los Derechos del Migrante, Coalition of Immokalee Workers, Coalition to Abolish Slavery & Trafficking (CAST), Economic Policy I… HOUSE OF REPRESENTATIVES,SENATE     0 0 2019-02-20T12:10:02.553000-05:00
2260555 CLARISSA J MIDDLETON, LOBBYIST abbe7869-19dd-478b-850a-fb31b36bc6d0 1A CLARISSA J MIDDLETON, LOBBYIST 401105013 MARKETWOMEN GLOBAL DEVELOPMENT 2019 first_quarter LBR {contact_data~salutation} This is a lobbying form letter and I know your office gets flooded with them. But I have read the content and wholeheartedly agree something must be done... I lend my voice and highly urge my Georgia sons (our Georgia elected officials) to support the passage of the Visa Transparency Anti-Trafficking Act of 2018, which seeks to prevent human trafficking by bringing more openness to the foreign temporary worker visa process. We don't want to harass workers, but we need to hold their employers accountable. I worked on Capitol Hill for Congressman John Lewis and lobbyied for Labor with the Boilermakers and we lobbied in support of HB1 Visas but that was nearly twenty years ago...They HB1 and work Visa is being used as a bargaining chip now. There are people who do not hold their own passport or Visa-the business owner holds it HOSTAGE! They are threatened with deportation if they tell anyone. Millions of foreign individuals are authorized to work in the United States every year on temporary, non-immigrant visas. Abusive employers are bringing foreign workers to the United States with the expectation of legitimate jobs, only to coerce them into unbearable conditions, including sex slavery and domestic servitude. Federal data on these temporary work visas is not uniformly reported and not available to the public, impeding law enforcements efforts to crack down on this form of human trafficking. The Visa Transparency Anti-Trafficking Act provides a straightforward solution to gaps in reporting, by requiring a standardized reporting system, expanding reports to include critical information, and providing governments, advocates, and the public with the data needed to develop trafficking prevention programs. The Visa Transparency Anti-Trafficking Act is also supported by AFL-CIO, Alliance to End Slavery & Trafficking (ATEST), American Federation of Teachers, Centro de los Derechos del Migrante, Coalition of Immokalee Workers, Coalition to Abolish Slavery & Trafficking (CAST), Economic Policy I… HOUSE OF REPRESENTATIVES,SENATE     0 0 2019-02-20T12:10:02.553000-05:00
2260556 KENNEDY LAW & POLICY 609632f6-0a52-4c25-8c45-5354625f2878 1T KENNEDY LAW & POLICY 401105061 INTERNATIONAL LIQUID TERMINALS ASSOCIATION 2019 first_quarter HOM Chemical Security Anti- Terrorism Statute HOUSE OF REPRESENTATIVES,SENATE 20000   0 1 2019-02-20T14:43:15.820000-05:00
2260557 DAVIS & HARMAN LLP fc666cf5-abe5-4759-9475-285f1882a9e1 1TY DAVIS & HARMAN LLP 11674 NISA INVESTMENT ADVISORS, LLC 2019 first_quarter           0 1 2019-02-22T07:24:13.967000-05:00
2260558 SMW PARTNERS, LLC f9c58b31-7c61-4454-a306-a7618e6bdba7 1T SMW PARTNERS, LLC 401104362 SCRIVNER LEON GROUP, LLC ON BEHALF OF SHELL OIL COMPANY 2019 first_quarter ENG Federal policy relating to energy, fuel issues, and natural resources. Executive Office of the President (EOP) 20000   0 1 2019-02-22T10:41:22.427000-05:00
2260559 SMW PARTNERS, LLC f9c58b31-7c61-4454-a306-a7618e6bdba7 1T SMW PARTNERS, LLC 401104362 SCRIVNER LEON GROUP, LLC ON BEHALF OF SHELL OIL COMPANY 2019 first_quarter TRD Federal policy relating to steel and offshore drilling; and implementation of the Jones Act (P.L. 66-261), provisions relating to the use of foreign tank shippers. Executive Office of the President (EOP) 20000   0 1 2019-02-22T10:41:22.427000-05:00
2260560 SMW PARTNERS, LLC f9c58b31-7c61-4454-a306-a7618e6bdba7 1T SMW PARTNERS, LLC 401104362 SCRIVNER LEON GROUP, LLC ON BEHALF OF SHELL OIL COMPANY 2019 first_quarter TAX Federal policy relating to tax reform. Executive Office of the President (EOP) 20000   0 1 2019-02-22T10:41:22.427000-05:00
2260561 HOOPER, LUNDY & BOOKMAN, P.C. 8f587f58-f79e-4deb-9550-a97dead88db2 1TY HOOPER, LUNDY & BOOKMAN, P.C. 401020884 BROWN RUDNICK, LLP, ON BEHALF OF LUPIN PHARMACEUTICALS, INC. 2019 first_quarter           0 1 2019-02-22T15:40:33.310000-05:00
2260562 HOOPER, LUNDY & BOOKMAN, P.C. 54585965-ea89-4dc5-b5ea-ca05c6955313 1T HOOPER, LUNDY & BOOKMAN, P.C. 401020884 BROWN RUDNICK, LLP, ON BEHALF OF PRIME THERAPEUTICS 2019 first_quarter MMM HHS-OIG rule RIN-936-AAO8,Removal of Safe Harbor Protections for Rebates to Plans or PBMs Involving Prescription Pharmaceuticals and Creation of New Safe Harbor Protection. Health & Human Services, Dept of (HHS)     0 1 2019-02-22T15:53:36.097000-05:00
2260563 HOOPER, LUNDY & BOOKMAN, P.C. 54585965-ea89-4dc5-b5ea-ca05c6955313 1T HOOPER, LUNDY & BOOKMAN, P.C. 401020884 BROWN RUDNICK, LLP, ON BEHALF OF PRIME THERAPEUTICS 2019 first_quarter HCR HHS Blueprint to Lower Drug Prices and Reduce Out-of-Pocket Costs. Health & Human Services, Dept of (HHS)     0 1 2019-02-22T15:53:36.097000-05:00
2260564 HOOPER, LUNDY & BOOKMAN, P.C. 61b2d2d3-5a0d-4cf5-ab00-105eba5fa3a8 1@Y HOOPER, LUNDY & BOOKMAN, P.C. 401020884 BROWN RUDNICK, LLP, ON BEHALF OF LUPIN PHARMACEUTICALS, INC. 2019 first_quarter           0 1 2019-02-22T15:56:36.867000-05:00
2260565 NATURAL RESOURCE RESULTS LLC 117ad46c-6b92-4a8c-995b-bb8d963adf63 1T NATURAL RESOURCE RESULTS LLC 321555 NEW VENTURE FUND 2019 first_quarter NAT Work on Pebble mine permit transparency and adequacy. Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE 15000   0 1 2019-02-24T14:02:27.457000-05:00
2260566 LIEBMAN & ASSOCIATES, INC. 502981fe-49a2-479e-9804-2afb54dbdca4 1TY LIEBMAN & ASSOCIATES, INC. 46585 THOR TRUCKS INC. 2019 first_quarter           0 1 2019-02-25T10:00:41.457000-05:00
2260567 THE MCKEON GROUP, INC. 3b001923-2d1d-461d-9e77-dd85854bf65c 1TY THE MCKEON GROUP, INC. 401103598 THE NATIONAL CENTER FOR SPECIAL EDUCATION IN CHARTER SCHOOLS 2019 first_quarter           0 1 2019-02-26T16:48:33.543000-05:00

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 1733.385ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API