lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
384 rows where filing_period = "fourth_quarter", filing_year = 2017 and issue_code = "LAW" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: filing_type, is_termination
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2056187 | CARPI & CLAY, INC dabc0a7d-a5dd-44f0-b473-360a15606767 | Q4 | CARPI & CLAY, INC | 35640 | CITY OF ANAHEIM | 2017 | fourth_quarter | LAW | Grant funding for local law enforcement; regulations regarding sanctuary cities. | Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE,Transportation, Dept of (DOT) | 20000 | 0 | 0 | 2017-12-04T13:18:56.350000-05:00 | |
| 2056193 | CARPI & CLAY, INC c0af8f56-4ea3-44ed-8aff-deae45cf9943 | Q4 | CARPI & CLAY, INC | 35640 | COUNTY OF TULARE | 2017 | fourth_quarter | LAW | Marijuana cultivation on public lands; appropriations for the State Criminal Alien Assistance Program; FY18 - Commerce, Justice, State Appropriations Bill; FY18 Department of Interior - Environment Appropriations Bill | Agriculture, Dept of (USDA),Bureau of Justice Assistance,Bureau of Reclamation,Drug Enforcement Administration (DEA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Office of Natl Drug Control Policy (NDCP),SENATE,U.S. Forest Service | 20000 | 0 | 0 | 2017-12-04T13:31:58.830000-05:00 | |
| 2056262 | CARPI & CLAY, INC 6aec218e-bb0f-41da-93af-55595e0abe63 | Q4 | CARPI & CLAY, INC | 35640 | COUNTY OF KERN | 2017 | fourth_quarter | LAW | State Criminal Alien Assistance program (SCAAP) reimbursement rules & formula; FY18 Commerce-State-Justice Appropriations Bill; regulations regarding sanctuary cities. | Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Forest Service | 20000 | 0 | 0 | 2017-12-05T13:19:26.323000-05:00 | |
| 2056536 | NATIONAL COALITION AGAINST DOMESTIC VIOLENCE b4a6ada8-eec4-45c3-9c8d-d30e132bc3c0 | Q4 | NATIONAL COALITION AGAINST DOMESTIC VIOLENCE | 401103457 | NATIONAL COALITION AGAINST DOMESTIC VIOLENCE | 2017 | fourth_quarter | LAW | Support increased funding for VAWA and other programs that impact victims and survivors; support legislation to keep firearms out of the hands of abusers | Bureau of Alcohol Tobacco Firearms & Explosives,HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),SENATE,White House Office | 16200 | 0 | 0 | 2017-12-11T09:03:32.510000-05:00 | |
| 2056758 | SPECIAL OLYMPICS, INC. bd87ec05-af11-4456-a919-cd5be48020c6 | Q4 | SPECIAL OLYMPICS, INC. | 291435 | SPECIAL OLYMPICS, INC. | 2017 | fourth_quarter | LAW | Law Enforcement Torch Run for Special Olympics | Centers For Disease Control & Prevention (CDC),Defense, Dept of (DOD),Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,State, Dept of (DOS) | 30000 | 0 | 0 | 2017-12-15T11:18:03.367000-05:00 | |
| 2056952 | SONOSKY, CHAMBERS, SACHSE, ENDRESON & PERRY, LLP ead5c24c-7ca7-4b04-9b83-0aaa8df877b6 | Q4 | SONOSKY, CHAMBERS, SACHSE, ENDRESON & PERRY, LLP | 36127 | ASSINIBOINE AND SIOUX TRIBES OF THE FORT PECK RESERVATION | 2017 | fourth_quarter | LAW | Public Safety Issues in Indian Country | Bureau of Indian Affairs (BIA),Federal Highway Administration (FHA),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2017-12-21T10:55:57.727000-05:00 | |
| 2057042 | THE CHILDREN'S DEFENSE FUND 9c3b5cfe-3683-44d6-9245-5cbfa5825bfb | Q4 | THE CHILDREN'S DEFENSE FUND | 9055 | CHILDREN'S DEFENSE FUND | 2017 | fourth_quarter | LAW | H.R. 1809 Juvenile Justice Reform Act S. 860 Juvenile Justice and Delinquency Prevention Reauthorization Act | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2017-12-21T16:38:18.173000-05:00 | ||
| 2057349 | RUFFALO AND ASSOCIATES, LLC 4f515689-238c-4d8b-afd6-fa8ce0ce3f7c | Q4 | RUFFALO AND ASSOCIATES, LLC | 291572 | VIGILANT SOLUTIONS | 2017 | fourth_quarter | LAW | Senate - FY2018 Department of Homeland Security appropriations bill - no bill number at this time House - HR 3354 - the Making America Secure and Prosperous Appropriations Act | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2018-01-01T17:23:00.903000-05:00 | |
| 2057478 | NATIONAL COURT REPORTERS ASSOCIATION ee05f463-ce83-46bf-baaa-4bada69dc7b8 | Q4 | NATIONAL COURT REPORTERS ASSOCIATION | 27707 | NATIONAL COURT REPORTERS ASSOCIATION | 2017 | fourth_quarter | LAW | NCRA is advocating for the Local Courthouse Safety Act, most recently introduced in the 114th Congress as H.R. 1566. This legislation will distribute surplus security equipment to courthouses that do not have metal detectors, wands or baggage screening devices. It also allows for several grants to be used for court safety training programs. | Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2018-01-02T11:30:51.517000-05:00 | ||
| 2057884 | AMERICAN ASSOCIATION OF CHILD & ADOLESCENT PSYCHIATRY b68e666d-ecf1-443e-ae0c-ba8ed44f13c8 | Q4 | AMERICAN ASSOCIATION OF CHILD & ADOLESCENT PSYCHIATRY | 401103274 | AMERICAN ASSOCIATION OF CHILD & ADOLESCENT PSYCHIATRY | 2017 | fourth_quarter | LAW | S. 1803 - MEDS Act H.R. 1809: Juvenile Justice Reform Act of 2017 S. 860: A bill to reauthorize and improve the Juvenile Justice and Delinquency Prevention Act of 1974, and for other purposes. H.Res. 250: Expressing the need to eliminate life without parole for children. H.R. 1926: Protecting Youth from Solitary Confinement Act H.R. 1885 Prohibiting Detention of Youth Status Offenders Act of 2017 S. 874: A bill to amend title XIX of the Social Security Act to protect the enrollment of incarcerated youth for medical assistance under S. 866 A bill to amend the Juvenile Justice and Delinquency Prevention Act of 1974 to eliminate the use of valid court orders to secure lockup of status offenders, and for other purposes. HR 1757 Trauma-Informed Care for Children and Families Act of 2017 S. 774 Trauma-Informed Care for Children and Families Act of 2017 H.R. 3440/S. 1615 - DREAM Act Reject the inclusion of marijuana policy amendments in FY18 Appropriations Act | HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,Substance Abuse & Mental Health Services Administration (SAMHSA),White House Office | 55000 | 0 | 0 | 2018-01-03T15:16:15.407000-05:00 | |
| 2057945 | ADVANCED POLICY CONSULTING, LLC 896e2002-9929-4efb-a243-107f34b33849 | Q4 | ADVANCED POLICY CONSULTING, LLC | 401103524 | MICROSOFT | 2017 | fourth_quarter | LAW | Legislative issues related to the Law Enforcement Access to Data Stored Abroad Act - (bill numbers from last Congress - H.R. 1174 and S. 512). | HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),SENATE,Small Business Administration (SBA),Treasury, Dept of | 30000 | 0 | 0 | 2018-01-04T09:05:37.827000-05:00 | |
| 2057967 | AMERICAN MOTORCYCLIST ASSOCIATION 6b347788-9f3b-43fe-bfe3-613fda0f60d3 | Q4 | AMERICAN MOTORCYCLIST ASSOCIATION | 2913 | AMERICAN MOTORCYCLIST ASSOCIATION | 2017 | fourth_quarter | LAW | H.R.1033, Equal Access to Justice Act in the 115th Congress by U.S. Rep. Doug Collins, (R-GA9), amends the Equal Access to Justice Act and the federal judicial code to require the Administrative Conference of the United States to create and maintain online searchable databases with information about the attorney's fees and other expenses awarded to prevailing parties other than the United States in certain: (1) agency-conducted adversary adjudication proceedings, and (2) civil action court cases (excluding tort cases) or settlement agreements to which the United States is a party. AMA is interested in how it applies to environmental law. S 378-This bill amends the Equal Access to Justice Act and the federal judicial code to require the Administrative Conference of the United States to create and maintain online searchable databases with information about the attorney's fees and other expenses awarded to prevailing parties other than the United States in certain: (1) agency-conducted adversary adjudication proceedings, and (2) civil action court cases (excluding tort cases) or settlement agreements to which the United States is a party. With respect to each award, the information must include: (1) the name of the agency involved, (2) the name of each party to whom the award was made, (3) a description of the claims, (4) the amount of the award, and (5) the basis for finding that the position of the agency concerned was not substantially justified. Under current law, the awards are made unless the position of the agency was substantially justified or special circumstances make an award unjust. HR3131 by U.S. Rep. Bill Huizenga (R-MI2) amends the Endangered Species Act of 1973 to replace the current standard for awarding court costs, including attorney fees, in citizen suits with the federal judicial code standard for awarding costs to a prevailing party. | Environmental Protection Agency (EPA),Federal Highway Administration (FHA),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR) | 338500 | 0 | 0 | 2018-01-04T09:53:46.210000-05:00 | |
| 2058274 | NATIONAL RELIGIOUS CAMPAIGN AGAINST TORTURE ACTION FUND 4da2c862-36a7-47dc-8628-ad1a5995d7e1 | Q4 | NATIONAL RELIGIOUS CAMPAIGN AGAINST TORTURE ACTION FUND | 400472335 | NATIONAL RELIGIOUS CAMPAIGN AGAINST TORTURE ACTION FUND | 2017 | fourth_quarter | LAW | The National Defense Authorization Act. Refugees. Bigotry against Muslims. Executive branch nominations. Guantanamo. Increasing the U.S. contribution to the UN Voluntary Fund for Victims of Torture. Preserving and strengthening the Leahy Law. Limiting solitary confinement. Sentencing reform. Supporting reforms that lead to a reduction in overcrowding in our corrections systems, and restorative alternatives to restricted housing. Increasing transparency around the use of drones. Ending the CIA's authority to carry out lethal drone strikes. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,State, Dept of (DOS),White House Office | 30000 | 0 | 0 | 2018-01-05T14:46:05.487000-05:00 | |
| 2058283 | NATIONAL RELIGIOUS CAMPAIGN AGAINST TORTURE b6ca8ed3-885e-4193-bb87-eda0dfcc5f09 | Q4 | NATIONAL RELIGIOUS CAMPAIGN AGAINST TORTURE | 400279346 | NATIONAL RELIGIOUS CAMPAIGN AGAINST TORTURE | 2017 | fourth_quarter | LAW | The National Defense Authorization Act. Refugees. Bigotry against Muslims. Executive branch nominations. Guantanamo. Increasing the U.S. contribution to the UN Voluntary Fund for Victims of Torture. Preserving and strengthening the Leahy Law. Increasing transparency around the use of drones. Ending the CIA's authority to carry out lethal drone strikes. Limiting solitary confinement. Sentencing reform. Supporting reforms that lead to a reduction in overcrowding in our corrections systems, and restorative alternatives to restricted housing. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,State, Dept of (DOS),White House Office | 10000 | 0 | 0 | 2018-01-05T14:57:08.007000-05:00 | |
| 2058437 | AMERICAN MOTORCYCLIST ASSOCIATION 6162d57a-f960-4b04-a98c-8ab0e447f316 | 4A | AMERICAN MOTORCYCLIST ASSOCIATION | 2913 | AMERICAN MOTORCYCLIST ASSOCIATION | 2017 | fourth_quarter | LAW | H.R.1033, Equal Access to Justice Act in the 115th Congress by U.S. Rep. Doug Collins, (R-GA9), amends the Equal Access to Justice Act and the federal judicial code to require the Administrative Conference of the United States to create and maintain online searchable databases with information about the attorney's fees and other expenses awarded to prevailing parties other than the United States in certain: (1) agency-conducted adversary adjudication proceedings, and (2) civil action court cases (excluding tort cases) or settlement agreements to which the United States is a party. AMA is interested in how it applies to environmental law. S 378-This bill amends the Equal Access to Justice Act and the federal judicial code to require the Administrative Conference of the United States to create and maintain online searchable databases with information about the attorney's fees and other expenses awarded to prevailing parties other than the United States in certain: (1) agency-conducted adversary adjudication proceedings, and (2) civil action court cases (excluding tort cases) or settlement agreements to which the United States is a party. With respect to each award, the information must include: (1) the name of the agency involved, (2) the name of each party to whom the award was made, (3) a description of the claims, (4) the amount of the award, and (5) the basis for finding that the position of the agency concerned was not substantially justified. Under current law, the awards are made unless the position of the agency was substantially justified or special circumstances make an award unjust. HR3131 by U.S. Rep. Bill Huizenga (R-MI2) amends the Endangered Species Act of 1973 to replace the current standard for awarding court costs, including attorney fees, in citizen suits with the federal judicial code standard for awarding costs to a prevailing party. | Environmental Protection Agency (EPA),Federal Highway Administration (FHA),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR) | 338500 | 0 | 0 | 2018-01-08T10:26:31.770000-05:00 | |
| 2058848 | FEDERAL SOLUTIONS, LLC 80eb965d-9e04-4eb8-8676-d53f4f9d1101 | Q4 | FEDERAL SOLUTIONS, LLC | 311371 | MISSISSIPPI STATE UNIVERSITY | 2017 | fourth_quarter | LAW | Commerce/Justice/Science Appropriation Bill: Provisions relating to research and development in DoJ. | Education, Dept of,HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Oceanic & Atmospheric Administration (NOAA),SENATE | 50000 | 0 | 0 | 2018-01-09T11:48:01.687000-05:00 | |
| 2058870 | FEDERAL SOLUTIONS, LLC 2bab0b98-c920-4fe1-8c1b-c0ad3528c8e7 | Q4 | FEDERAL SOLUTIONS, LLC | 311371 | MARSHALL UNIVERSITY RESEARCH CORPORATION | 2017 | fourth_quarter | LAW | Commerce/Justice/Science Appropriations Bill: Provisions relating to research and development | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2018-01-09T12:03:13.320000-05:00 | |
| 2059150 | NATIONAL ORGANIZATION FOR THE REFORM OF MARIJUANA LAWS 5d91403b-9fe3-4926-844a-17afd58199f8 | Q4 | NATIONAL ORGANIZATION FOR THE REFORM OF MARIJUANA LAWS | 48188 | NATIONAL ORGANIZATION FOR THE REFORM OF MARIJUANA LAWS | 2017 | fourth_quarter | LAW | NORML supports the ending of marijuana prohibition and the establishment of a legally regulated market for adults. Support HR 1227, the Ending Marijuana Prohibition Act of 2017 Support HR 714, the Compassionate Access Act Support HR 975, the Respect States' Marijuana Laws Act Support S 1374/HR 2920, the CAREERS Act Support HR 1841, HR 1823/S 776, Regulate Marijuana Like Alcohol Act Support HR 1820, the Veterans Equal Access Act Support HR 1952, the Better Drive Act Support HR 1810/SB 777, the Small Business Tax Equity Act Support HR 331, the States' Medical Marijuana Property Rights Protection Act | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2018-01-10T08:41:48.840000-05:00 | ||
| 2059200 | SMITH GARSON FKA SMITH DAWSON & ANDREWS f0b66a96-6f6f-4e87-8d28-3d7ffadf0f6c | Q4 | SMITH GARSON FKA SMITH DAWSON & ANDREWS | 35707 | INTERNET PROBATION AND PAROLE CONTROL, INC | 2017 | fourth_quarter | LAW | Criminal justice reform and sentencing reform and corrections act Internet monitoring of inmates | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE | 0 | 0 | 2018-01-10T09:50:20.233000-05:00 | ||
| 2059384 | MS. ELIZABETH LAVACH 311c6cad-2bd8-4373-964e-5584d195fee3 | Q4 | MS. ELIZABETH LAVACH | 290811 | FORENSICS CONSORTIUM | 2017 | fourth_quarter | LAW | Funding for DNA, the Coverdell Act and all forensics | Defense, Dept of (DOD),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE | 13125 | 0 | 0 | 2018-01-10T12:11:21.783000-05:00 | |
| 2059474 | THE PRENDA GROUP LLC dcb6a558-d740-4dc3-9473-1c1d7b6f35a2 | Q4 | THE PRENDA GROUP LLC | 401104543 | LEONARDO US CYBER AND SECURITY SOLUTIONS LLC. (FORMERLY SELEX ES INC.) | 2017 | fourth_quarter | LAW | Monitoring legislation and Congressional initiatives concerning the use of new technologies for law enforcement in particular Leading edge License Plate Readers (LPR) H.R.3354 Make America Secure and Prosperous Appropriations Act. | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2018-01-10T12:41:40-05:00 | |
| 2059599 | BALLARD PARTNERS 04a46ae0-856d-424b-aa09-1b9d0743c503 | Q4 | BALLARD PARTNERS | 401104288 | THE GEO GROUP, INC | 2017 | fourth_quarter | LAW | The registrant will advise and advocate for the client on general government policies and regulations. | Justice, Dept of (DOJ),White House Office | 150000 | 0 | 0 | 2018-01-10T14:07:19.327000-05:00 | |
| 2059618 | BROOKS BAWDEN MOORE, LLC, FORMERLY REPORTED AS BROOKS BAWDEN, LLC 49b513ae-5e8b-44d2-83f6-9501b7f54ead | Q4 | BROOKS BAWDEN MOORE, LLC, FORMERLY REPORTED AS BROOKS BAWDEN, LLC | 401031906 | ASSOCIATION OF STATE CRIMINAL INVESTIGATIVE AGENCIES | 2017 | fourth_quarter | LAW | Electronic Communications Privacy Act reform; forensic science; FY 2018 Department of Justice appropriations; state and local law enforcement assistance programs; asset forfeiture reform; investigative technology; criminal justice reform legislation; digital evidence access issues | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE | 0 | 0 | 2018-01-10T14:24:37.740000-05:00 | ||
| 2059626 | BROOKS BAWDEN MOORE, LLC, FORMERLY REPORTED AS BROOKS BAWDEN, LLC 337988e6-7316-4687-ae57-fef32821fbe0 | Q4 | BROOKS BAWDEN MOORE, LLC, FORMERLY REPORTED AS BROOKS BAWDEN, LLC | 401031906 | VIGILANT SOLUTIONS | 2017 | fourth_quarter | LAW | Federal agency use of license plate recognition technology and facial recognition technology in criminal investigations; FY 2018 Homeland Security appropriations, THUD Appropriations, and CJS Appropriations | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2018-01-10T14:27:49.243000-05:00 | |
| 2059629 | BROOKS BAWDEN MOORE, LLC, FORMERLY REPORTED AS BROOKS BAWDEN, LLC 78f5a5fc-3358-411c-adc5-7a824c9c6a19 | Q4 | BROOKS BAWDEN MOORE, LLC, FORMERLY REPORTED AS BROOKS BAWDEN, LLC | 401031906 | MAJOR COUNTY SHERIFFS OF AMERICA (FORMERLY MAJOR COUNTY SHERIFFS' ASSOCIATION) | 2017 | fourth_quarter | LAW | Electronic Communications Privacy Act reform; mental health in incarceration settings; immigration reform, detainers, and sanctuary city issues; FY 2018 appropriations for Department of Justice grant programs; asset forfeiture; forensic science in law enforcement; law enforcement access to digital evidence; investigative technology issues; Deaths in Custody Reporting Act issues; criminal justice reform issues | Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Immigration & Customs Enforcement (ICE) | 20000 | 0 | 0 | 2018-01-10T14:35:54.870000-05:00 | |
| 2059642 | BROOKS BAWDEN MOORE, LLC, FORMERLY REPORTED AS BROOKS BAWDEN, LLC 638e6cf5-adb4-4bbf-9eea-36af179e8961 | Q4 | BROOKS BAWDEN MOORE, LLC, FORMERLY REPORTED AS BROOKS BAWDEN, LLC | 401031906 | ANDE, INC. (FORMERLY ANDE DIVISION OF NETBIO, INC.) | 2017 | fourth_quarter | LAW | Use of Rapid DNA technology in criminal investigations | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2018-01-10T14:42:01.500000-05:00 | |
| 2059667 | PATRICIA JORDAN & ASSOCIATES, INC. 50040358-b34a-45b4-81ae-ed87af0c7562 | Q4 | PATRICIA JORDAN & ASSOCIATES, INC. | 20937 | CITY OF TRACY, CALIFORNIA | 2017 | fourth_quarter | LAW | COPS Application for Tracy | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 10000 | 0 | 0 | 2018-01-10T15:11:34.953000-05:00 | |
| 2059684 | LUNGREN LOPINA LLC adcf78ad-7875-4ecc-b4e2-54bb68553c22 | Q4 | LUNGREN LOPINA LLC | 401103314 | U.S. CHAMBER OF COMMERCE INSTITUTE FOR LEGAL REFORM | 2017 | fourth_quarter | LAW | Civil justice reform | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 2018-01-10T15:31:02.087000-05:00 | |
| 2059692 | CONSORTIUM OF SOCIAL SCIENCE ASSOCIATIONS (COSSA) ca872bb1-e880-4acd-bf17-102df516d65a | Q4 | CONSORTIUM OF SOCIAL SCIENCE ASSOCIATIONS (COSSA) | 10605 | CONSORTIUM OF SOCIAL SCIENCE ASSOCIATIONS | 2017 | fourth_quarter | LAW | H.R. 38, Conceal Carry Reciprocity Act of 2017 - Provisions pertaining to the reauthorization of the National Institute of Justice and Bureau of Justice Statistics. | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 2018-01-10T15:38:11.387000-05:00 | |
| 2059940 | AMERICAN GAMING ASSOCIATION 37a60bf7-cc10-4439-a632-2a43a19a632f | Q4 | AMERICAN GAMING ASSOCIATION | 2434 | AMERICAN GAMING ASSOCIATION | 2017 | fourth_quarter | LAW | Illegal Gambling | Financial Crimes Enforcement Network (FinCEN),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),SENATE,Treasury, Dept of | 340000 | 0 | 0 | 2018-01-11T08:40:08.147000-05:00 | |
| 2060030 | MONSTER WORLDWIDE f90e9de7-b700-4529-8804-d147d1942545 | Q4 | MONSTER WORLDWIDE | 299310 | MONSTER WORLDWIDE | 2017 | fourth_quarter | LAW | Issues related to preventing real online threats to economic creativity and theft of intellectual property. Issues related to combating online piracy and additional enhancements to combat intellectual property theft. Issues related to enhancing punishment for identity theft and other violations of data and privacy and security. | HOUSE OF REPRESENTATIVES,SENATE | 110000 | 0 | 0 | 2018-01-11T10:32:17.920000-05:00 | |
| 2060064 | TREMONT STRATEGIES GROUP LLC (F/K/A ADS VENTURES) 73a337d3-bc58-4761-bd25-1e144f594492 | Q4 | TREMONT STRATEGIES GROUP LLC (F/K/A ADS VENTURES) | 90250 | BENCHMADE KNIFE COMPANY | 2017 | fourth_quarter | LAW | Company business overview for members and staff, NDAA, small business, trade. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2018-01-11T10:53:54.240000-05:00 | |
| 2060416 | HOGAN LOVELLS US LLP 9b565b56-e7f9-4c79-b8e5-17a89b004b1b | Q4 | HOGAN LOVELLS US LLP | 18422 | UNIVERSITY OF MARYLAND EASTERN SHORE | 2017 | fourth_quarter | LAW | FY 2018 Commerce, State, Justice Appropriations | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2018-01-11T14:40:03.597000-05:00 | |
| 2060552 | CAPITOL CONNECTIONS, LLC 46d19bda-7d73-40a7-b3f2-7d52bcf17ff9 | Q4 | CAPITOL CONNECTIONS, LLC | 303597 | KELLEY DRYE & WARREN | 2017 | fourth_quarter | LAW | Issues related to the AETA. | Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE | 30000 | 0 | 0 | 2018-01-11T15:39:56.643000-05:00 | |
| 2060623 | GIFFORDS 98fc5213-960f-4ef0-8e51-5a0f3e0b7e98 | Q4 | GIFFORDS | 401103180 | GIFFORDS | 2017 | fourth_quarter | LAW | Background checks; Improving the National Instant Criminal Background Check System; Intimate partner violence and violence against women, as related to firearms; Mental health, as related to firearms; Trafficking of firearms; National concealed carry reciprocity; Preventing terrorists from acquiring firearms; Hate crimes with firearms; National Firearms Act; Supreme Court of the United States; Presidential Cabinet appointments; ATF white paper - Options to Reduce or Modify Firearms Regulations; Deregulation of silencers; Interstate transport of firearms; Federal firearm licensee break-ins; Appropriations; Guns in schools; Microstamping; Smart gun technology; Bump stocks; Semiautomatic firearms; Firearm accessories; H.R. 38, Concealed Carry Reciprocity Act of 2017; H.R. 367, Hearing Protection Act; S. 59, Hearing Protection Act; S. 446, Constitutional Concealed Carry Reciprocity Act of 2017; H.R. 1181, Veterans 2nd Amendment Protection Act; H.R. 1475, Gun Trafficking Prevention Act of 2017 S. 1185, Stop Illegal Trafficking in Arms Act; H.R. 2598, Gun Violence Restraining Order Act of 2017; S. 1212, Gun Violence Prevention Order Act of 2017; H.R. 2841, Disarm Hate Act; S. 1321, Disarm Hate Act; Sportsmens Heritage and Recreational Enhancement Act (SHARE Act), Discussion Draft; H.R 2909, D.C Personal Protection Reciprocity Act; H.R.1537, Second Amendment Enforcement Act of 2017; HR 2490, To allow Members of Congress to carry a concealed firearm anywhere in the United States, with certain exceptions; H.R.2945, To grant Members of Congress the right to carry a firearm anywhere in the United States, except in the United States Capitol; H.R.2951, To allow Members of Congress to carry a concealed handgun anywhere in the United States, with exceptions. H.R. 3668, Sportsmens Heritage and Recreational Enhancement (SHARE) Act; H.R. 3207, Zero Tolerance for Domestic Abusers Act; S. 1539, Protecting Domestic… | Bureau of Alcohol Tobacco Firearms & Explosives,HOUSE OF REPRESENTATIVES,SENATE | 140000 | 0 | 0 | 2018-01-11T16:01:00.843000-05:00 | |
| 2060742 | THE JEWISH FEDERATIONS OF NORTH AMERICA e1e7127e-533d-460c-9e9b-adc0780f9686 | Q4 | THE JEWISH FEDERATIONS OF NORTH AMERICA | 11105 | JEWISH FEDERATIONS OF NORTH AMERICA | 2017 | fourth_quarter | LAW | Protecting Religiously Affiliated Institutions Act of 2017 (HR 1730), broaden and enhance criminal penalties under Church Arson Prevention Act | Administration for Children & Families (ACF),Administration on Aging,Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE,State, Dept of (DOS),Treasury, Dept of,White House Office | 186845 | 0 | 0 | 2018-01-11T17:14:04.207000-05:00 | |
| 2061023 | ULTRA MARITIME LLC (FORMERLY REPORTED AS ULTRA ELECTRONICS DEFENSE INC) 253a4e97-bf16-4762-b206-1af23763e2b5 | Q4 | ULTRA MARITIME LLC (FORMERLY REPORTED AS ULTRA ELECTRONICS DEFENSE INC) | 401102072 | ULTRA MARITIME LLC (FORMERLY REPORTED AS ULTRA ELECTRONICS DEFENSE INC) | 2017 | fourth_quarter | LAW | FY2018 Commerce Justice State Appropriations Bill: FY2018 funding for the NIBIN program. | HOUSE OF REPRESENTATIVES,SENATE | 120000 | 0 | 0 | 2018-01-12T10:25:42.907000-05:00 | |
| 2061026 | SIFF & ASSOCIATES PLLC 5cf0c78f-ace3-4c7e-b8fa-384ffbfd37c9 | Q4 | SIFF & ASSOCIATES PLLC | 400665998 | SERGEANTS BENEVOLENT ASSOCIATION OF NEW YORK CITY | 2017 | fourth_quarter | LAW | S. 782, the "PROTECT Our Children Act of 2017," legislation to reauthorize the National Internet Crimes Against Children Task Force Program; entire bill. | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE | 30000 | 0 | 0 | 2018-01-12T10:27:44.250000-05:00 | |
| 2061039 | SIFF & ASSOCIATES PLLC 3e9057f6-bbbd-43ed-aea6-9f413e28f283 | Q4 | SIFF & ASSOCIATES PLLC | 400665998 | FEDERAL LAW ENFORCEMENT OFFICERS ASSOCIATION | 2017 | fourth_quarter | LAW | H.R. 1039, the "Probation Officer Protection Act of 2017," legislation to grant probation officers authority to arrest hostile third parties who obstruct or impede a probation officer in the performance of official duties; entire bill. S. 367, the "Probation Officer Protection Act of 2017," legislation to grant probation officers authority to arrest hostile third parties who obstruct or impede a probation officer in the performance of official duties; entire bill. | HOUSE OF REPRESENTATIVES,SENATE,Transportation Security Administration (TSA) | 30000 | 0 | 0 | 2018-01-12T10:32:47.147000-05:00 | |
| 2061043 | NATIONAL ASSOCIATION TO PROTECT CHILDREN EDUCATION FUND d5f0cd46-620a-439a-b8a7-ed8f83ea46fc | Q4 | NATIONAL ASSOCIATION TO PROTECT CHILDREN EDUCATION FUND | 401104024 | NATIONAL ASSOCIATION TO PROTECT CHILDREN EDUCATION FUND | 2017 | fourth_quarter | LAW | Abolish Human Trafficking Act, S 1311 (includes HERO Act expansion) Allow State and Victims to Fight Online Sex Trafficking Act of 2017, HR 1865 Child Abuse Accountability Enhancement Act, HR 1103 Child Abuse Prevention & Treatment Act (CAPTA) Empowering Law Enforcement to Fight Sex Trafficking Demand Act, HR 2480 Extending Justice For Sex Crime Victims Act of 2017, HR 1034, S 30 Frederick Douglass Trafficking Victims Prevention and Protection Reauthorization Act of 2017, HR 2200 Human Exploitation Rescue Operative (HERO) Act expansion, S1517 Intimate Privacy Protection, H.R. 1588 Protect Our Children Reauthorization Act, S 782, HR 1846: Reauthorization for Internet Crimes Against Children Reauthorization Protecting Against Child Exploitation Act of 2017, HR 1761 Protecting Young Victims from Sexual Abuse Act of 2017, S 534 Trafficking Victims Protection Act (TVPA) Trafficking Victims Protections Reauthorization Act (TVPRA), S 1312 Senate Judiciary Committee DOJ oversight hearing, questions for Attorney General Sessions | Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE | 10000 | 0 | 0 | 2018-01-12T10:35:50.960000-05:00 | |
| 2061361 | AMERICAN PSYCHOLOGICAL ASSOCIATION d1a9a1f7-e663-49ce-99ec-a765897ba2d2 | Q4 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2017 | fourth_quarter | LAW | S. 329/H.R. 901 MERCY Act Draft legislation on pregnant incarcerated women Draft House Legislation: Pregnancy in Correctional Institutions | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 150000 | 0 | 0 | 2018-01-12T15:08:36.900000-05:00 | |
| 2061447 | HOLLAND & KNIGHT LLP 64150696-6e28-46e3-979e-16cbec1d8241 | Q4 | HOLLAND & KNIGHT LLP | 18466 | PURSUIT RESPONSE | 2017 | fourth_quarter | LAW | Funding for high-speed pursuit mitigation implementation and equipment; H.R. 3267, Commerce, Justice, Science Appropriations, Title II, State and Local Law Enforcement Assistance. | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE | 10000 | 0 | 0 | 2018-01-12T15:55:25.283000-05:00 | |
| 2061455 | HOLLAND & KNIGHT LLP 5770bb74-df8c-474e-b4c1-67564a6cb3c4 | Q4 | HOLLAND & KNIGHT LLP | 18466 | CITY OF ATLANTA, GA | 2017 | fourth_quarter | LAW | Justice Assistance Grant | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 100000 | 0 | 0 | 2018-01-12T15:58:27.970000-05:00 | |
| 2061689 | INTERNATIONAL UNION OF POLICE ASSOCIATIONS, AFL-CIO 217cba21-4423-4531-8440-5e0adaaac2fd | Q4 | INTERNATIONAL UNION OF POLICE ASSOCIATIONS, AFL-CIO | 50400 | INTERNATIONAL UNION OF POLICE ASSOCIATIONS AFL-CIO | 2017 | fourth_quarter | LAW | HR124, HR426, HR510, HR115, S 708 S867, HR 2228 | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE | 20000 | 0 | 0 | 2018-01-13T14:44:24.173000-05:00 | |
| 2061819 | THE ESTELL GROUP LLC 8dd5b8ea-b20d-43f6-a866-ff0869cbcacb | Q4 | THE ESTELL GROUP LLC | 401103520 | WAYNE STATE UNIVERSITY | 2017 | fourth_quarter | LAW | Promoting legislation that will enhance campus safety. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2018-01-15T10:29:09.343000-05:00 | |
| 2061860 | ISEMAN & ASSOCIATES LLC 403550d7-73ee-43d8-8fa5-60b2ccac15bb | Q4 | ISEMAN & ASSOCIATES LLC | 401103582 | LOS ANGELES AIRPORT PEACE OFFICERS ASSOCIATION | 2017 | fourth_quarter | LAW | Airport security; TSA issues; and monitoring drone legislation | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2018-01-15T10:51:25.697000-05:00 | |
| 2061864 | ISEMAN & ASSOCIATES LLC a0919d3d-7d7c-4f9e-bc65-5dcc3ee736d5 | Q4 | ISEMAN & ASSOCIATES LLC | 401103582 | PORT AUTHORITY POLICE BENEVOLENT ASSOCIATION, INC. | 2017 | fourth_quarter | LAW | Aviation security and TSA issues; airport safety and security funding; aircraft rescue and firefighting issues; monitoring drone legislation. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2018-01-15T10:52:28.150000-05:00 | |
| 2061880 | CFM STRATEGIC COMMUNICATIONS (CONKLING FISKUM & MCCORMICK) 32fd9710-82ff-492d-9756-bd5ca9c68ef9 | Q4 | CFM STRATEGIC COMMUNICATIONS (CONKLING FISKUM & MCCORMICK) | 10478 | MARION COUNTY OREGON | 2017 | fourth_quarter | LAW | Support Second Chance Act legislation pending in Congress; Support law enforcement patrol and equipment provisions within Secure Rural Schools Legislation. | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE | 20000 | 0 | 0 | 2018-01-15T11:23:43.063000-05:00 | |
| 2061884 | CFM STRATEGIC COMMUNICATIONS (CONKLING FISKUM & MCCORMICK) 240097f3-0180-4b83-b1e2-19630e193952 | Q4 | CFM STRATEGIC COMMUNICATIONS (CONKLING FISKUM & MCCORMICK) | 10478 | CITY OF BATTLE GROUND WASHINGTON | 2017 | fourth_quarter | LAW | Issues related to police grant and coordination with local teen suicide prevention efforts. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2018-01-15T11:25:44.407000-05:00 | |
| 2061926 | THE ESTELL GROUP LLC da0f7e0f-345e-4ac2-98a4-df42777d4aa6 | Q4 | THE ESTELL GROUP LLC | 401103520 | BEXAR COUNTY | 2017 | fourth_quarter | LAW | Support adequate SCAAP funding | Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,White House Office | 30000 | 0 | 0 | 2018-01-15T11:43:05.607000-05:00 | |
| 2062086 | MCCAULLEY&COMPANY 6935f653-38d3-4da0-bb90-c9abb039a9bf | Q4 | MCCAULLEY&COMPANY | 401103348 | NOTRE DAME COLLEGE | 2017 | fourth_quarter | LAW | Grants and Budget | Education, Dept of,HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2018-01-15T13:12:11.050000-05:00 | |
| 2062334 | LOCKRIDGE, GRINDAL, NAUEN, PLLP e9ff8e89-d845-4979-ba03-e59d9ec4bd40 | Q4 | LOCKRIDGE, GRINDAL, NAUEN, PLLP | 23053 | CITY OF ST PAUL | 2017 | fourth_quarter | LAW | FY2018 Authorizations, Appropriations, and Budget Policy | Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE,Transportation, Dept of (DOT) | 10000 | 0 | 0 | 2018-01-15T19:22:58.707000-05:00 | |
| 2062357 | LOCKRIDGE, GRINDAL, NAUEN, PLLP 5d869c42-5bb4-44ae-ac2a-5e6a14a5c89d | Q4 | LOCKRIDGE, GRINDAL, NAUEN, PLLP | 23053 | MINNESOTA POLICE AND PEACE OFFICERS ASSN | 2017 | fourth_quarter | LAW | FY2018 Authorizations, Appropriations, and Budget Policy | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2018-01-15T19:40:08.310000-05:00 | ||
| 2062364 | LOCKRIDGE, GRINDAL, NAUEN, PLLP 548cabda-dc0a-4b61-aedf-a0cae4bf4b5c | Q4 | LOCKRIDGE, GRINDAL, NAUEN, PLLP | 23053 | POLICE OFFICERS ASSOCIATION OF MICHIGAN | 2017 | fourth_quarter | LAW | FY2018 Authorizations, Appropriations, and Budget Policy | Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2018-01-15T19:42:10.530000-05:00 | ||
| 2062394 | LOCKRIDGE, GRINDAL, NAUEN, PLLP 37506570-75d4-43a5-a5d3-0cc1af8b2387 | Q4 | LOCKRIDGE, GRINDAL, NAUEN, PLLP | 23053 | MINNESOTA STATE ASSOCIATION OF NARCOTICS OFFICERS | 2017 | fourth_quarter | LAW | FY2018 Authorizations, Appropriations, and Budget Policy | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2018-01-15T20:20:37.893000-05:00 | ||
| 2062439 | LOCKRIDGE, GRINDAL, NAUEN, PLLP c884f581-008e-44dd-863a-e6aa735658bb | Q4 | LOCKRIDGE, GRINDAL, NAUEN, PLLP | 23053 | CITY OF BLOOMINGTON | 2017 | fourth_quarter | LAW | Public Safety and Criminal Justice | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2018-01-15T21:07:19.337000-05:00 | |
| 2062470 | WASHINGTON PARTNERS e939c057-5de3-4707-b57d-1f6074dd1a1f | Q4 | WASHINGTON PARTNERS | 77355 | NATIONAL COUNCIL OF JUVENILE AND FAMILY COURT JUDGES | 2017 | fourth_quarter | LAW | S.860 Juvenile Justice and Delinquency Prevention Reauthorization Act of 2017 re: judicial training and valid court order exemption H.R.1809 Juvenile Justice Reform Act of 2017 re: judicial training and valid court order exemption | HOUSE OF REPRESENTATIVES,SENATE | 7800 | 0 | 0 | 2018-01-15T22:55:53.527000-05:00 | |
| 2062541 | PAUL MARCONE & ASSOCIATES, LLC 2abe17df-e523-45d5-a30a-f46f2949ef59 | Q4 | PAUL MARCONE & ASSOCIATES, LLC | 283732 | NATIONAL LAW ENFORCEMENT OFFICERS MEMORIAL FUND | 2017 | fourth_quarter | LAW | Outreach to House and Senate offices to provide information on the progress of the National Law Enforcement Museum project and NLEOMF's outreach and education programs related to law enforcement and homeland security. Outreach to House offices in support of H.R. 1417, the National Law Enforcement Museum Exhibits Act. | HOUSE OF REPRESENTATIVES,SENATE | 15000 | 0 | 0 | 2018-01-16T09:31:48.910000-05:00 | |
| 2062776 | CASSIDY & ASSOCIATES, INC. e9e9f3ec-a7dd-4ac3-9ece-723f32bacb7a | Q4 | CASSIDY & ASSOCIATES, INC. | 8453 | ARGENTUM | 2017 | fourth_quarter | LAW | Olmstead Act Interpretation | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 0 | 2018-01-16T11:12:28.677000-05:00 | |
| 2062947 | CASSIDY & ASSOCIATES, INC. e74c9c21-3d48-46ec-ae58-e4777f493c92 | Q4 | CASSIDY & ASSOCIATES, INC. | 8453 | WATCH SYSTEMS, LLC | 2017 | fourth_quarter | LAW | Federal law enforcement technology solutions Adam Walsh Act Reauthorization International Megan's Law implementation | Army, Dept of (Other),HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2018-01-16T12:10:06.287000-05:00 | |
| 2063073 | ATLANTIC STRATEGIES GROUP LLC b98d7448-1e2c-4cc2-a259-5f25355e0e85 | Q4 | ATLANTIC STRATEGIES GROUP LLC | 401057985 | SIERRA NEVADA COMPANY | 2017 | fourth_quarter | LAW | Educated staff on SNC jamming technologies. | HOUSE OF REPRESENTATIVES,SENATE | 80000 | 0 | 0 | 2018-01-16T13:14:17.017000-05:00 | |
| 2063394 | FIDELITY NATIONAL FINANCIAL, INC. 6debf896-03b9-492a-bc40-09938aa4f1f7 | Q4 | FIDELITY NATIONAL FINANCIAL, INC. | 401103297 | FIDELITY NATIONAL FINANCIAL, INC. | 2017 | fourth_quarter | LAW | Advocate that comprehensive data security legislation that protects consumers from cyber theft should be a priority for Congress. | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 2018-01-16T14:44:36.447000-05:00 | |
| 2063466 | PRISON FELLOWSHIP MINISTRIES dd1c9858-6471-40d8-b963-4631b61d9185 | Q4 | PRISON FELLOWSHIP MINISTRIES | 20983 | PRISON FELLOWSHIP MINISTRIES | 2017 | fourth_quarter | LAW | Federal prison and sentencing reform (CORRECTIONS Act and Sentencing Reform and Corrections Act), reentry program funding (Second Chance Reauthorization), Second Chance Month resolution, prison rape elimination act implementation and funding. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2018-01-16T15:07:28.800000-05:00 | ||
| 2063472 | MULTISTATE ASSOCIATES INC. 16ad3ded-e8df-40ab-87af-7e0cfe29581d | Q4 | MULTISTATE ASSOCIATES INC. | 401103865 | MOBILE WORKFORCE COALITION | 2017 | fourth_quarter | LAW | H.R. 1393/S. 540 Mobile Workforce State Tax Simplification Act of 2017. | HOUSE OF REPRESENTATIVES,SENATE | 45000 | 0 | 0 | 2018-01-16T15:08:32.440000-05:00 | |
| 2063495 | DOWNS GOVERNMENT AFFAIRS 36d29ecb-39f5-408f-bf2a-c7acb5729c9f | Q4 | DOWNS GOVERNMENT AFFAIRS | 401103955 | NORTHCENTRAL TECHNICAL COLLEGE | 2017 | fourth_quarter | LAW | Community college law enforcement education and workforce training | Bureau of Alcohol Tobacco Firearms & Explosives,Bureau of Justice Assistance,Federal Emergency Management Agency (FEMA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Customs & Border Protection | 0 | 0 | 2018-01-16T15:13:45.097000-05:00 | ||
| 2063572 | HOLLAND & KNIGHT LLP e5908d16-0b09-47d4-b2c6-5dc6feca0288 | Q4 | HOLLAND & KNIGHT LLP | 18466 | CITY OF NORFOLK VIRGINIA | 2017 | fourth_quarter | LAW | COPS grant program. | Army, Dept of (Corps of Engineers),Federal Emergency Management Agency (FEMA),General Services Administration (GSA),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE,U.S. Customs & Border Protection | 40000 | 0 | 0 | 2018-01-16T15:29:25.717000-05:00 | |
| 2063648 | HOLLAND & KNIGHT LLP 02893e88-e3a1-4495-a41d-ed4d3fb62fa1 | Q4 | HOLLAND & KNIGHT LLP | 18466 | PCI SECURITY STANDARDS COUNCIL, LLC | 2017 | fourth_quarter | LAW | Policy issues related to data breach and cyber security. | Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 2018-01-16T15:58:33.380000-05:00 | |
| 2063822 | INSIGHTS ASSOCIATION (FKA: MARKETING RESEARCH ASSOCIATION) 76b0d51b-8886-4a76-a427-f5b5a976e2ef | Q4 | INSIGHTS ASSOCIATION (FKA: MARKETING RESEARCH ASSOCIATION) | 286256 | INSIGHTS ASSOCIATION (FKA: MARKETING RESEARCH ASSOCIATION) | 2017 | fourth_quarter | LAW | Support for FICALA (H.R. 985) and LARA (H.R. 720) and class action lawsuit reform efforts, particularly as they impact TCPA lawsuits against Insights Association members. | Commerce, Dept of (DOC),Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE | 20000 | 0 | 0 | 2018-01-16T17:13:14.377000-05:00 | |
| 2063909 | MCGUIREWOODS CONSULTING (A SUBSIDIARY OF MCGUIREWOODS LLP) 33e805c5-0e81-4eeb-bbbb-4da4c9488527 | Q4 | MCGUIREWOODS CONSULTING (A SUBSIDIARY OF MCGUIREWOODS LLP) | 24486 | VICTIMS OF TERRORISM - EAST AFRICA | 2017 | fourth_quarter | LAW | Secure compensation for United States Government Employees killed and injured in Bombing of U.S. Embassies in Africa in 1998 | HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS) | 0 | 0 | 2018-01-16T17:52:06.507000-05:00 | ||
| 2063970 | ERIK MILMAN 606c1e9b-ed7c-4977-a923-82b380703d2b | Q4 | ERIK MILMAN | 400459250 | CORRECTIONS USA | 2017 | fourth_quarter | LAW | Funding for Correctional Officers | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2018-01-16T18:31:38.107000-05:00 | ||
| 2064073 | CONGRESSIONAL SOLUTIONS, INC (CSI) a6161709-c84c-49a8-b539-63427ac3e580 | Q4 | CONGRESSIONAL SOLUTIONS, INC (CSI) | 297237 | UNIVERSITY OF NORTH TEXAS SYSTEM | 2017 | fourth_quarter | LAW | Bureau of Prisons Federal Medical Center | Army, Dept of (Other),HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 0 | 2018-01-16T21:51:42.757000-05:00 | |
| 2064241 | THE CHWAT GROUP a4b90e9e-2ca2-4d11-a811-23d9b6a8b4fb | Q4 | THE CHWAT GROUP | 9192 | ELECTRONIC SECURITY ASSOCIATION | 2017 | fourth_quarter | LAW | Federal Background Checks | Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2018-01-17T09:40:32.743000-05:00 | |
| 2064304 | JENKINS HILL CONSULTING, LLC 7ae45f22-c6a5-43e5-ab7d-0543a0804ad6 | Q4 | JENKINS HILL CONSULTING, LLC | 303575 | CODE 3 ASSOCIATION | 2017 | fourth_quarter | LAW | Law Enforcement related issues in Community Policing Services | HOUSE OF REPRESENTATIVES,SENATE | 15000 | 0 | 0 | 2018-01-17T10:02:24.597000-05:00 | |
| 2064502 | NATIONAL GROUP, LLP fb3604be-8fa3-4c31-bcc2-55778b78115a | Q4 | NATIONAL GROUP, LLP | 66090 | MCHENRY COUNTY, ILLINOIS | 2017 | fourth_quarter | LAW | Federal Funding for Law Enforcement/Public Safety | Economic Development Administration,HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2018-01-17T10:50:25.833000-05:00 | |
| 2064717 | NATIONAL GROUP, LLP 4eb4497a-1ac6-46b7-8627-77b42b16838f | Q4 | NATIONAL GROUP, LLP | 66090 | VIGILANT SOLUTIONS | 2017 | fourth_quarter | LAW | Federal Agency use of license plate recognition technology in criminal investigations | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2018-01-17T11:47:51.317000-05:00 | |
| 2064942 | THE CONSILIO GROUP 697b0cc7-4327-4728-aea7-f29ac3a9b9e5 | Q4 | THE CONSILIO GROUP | 400374717 | INTEGENX | 2017 | fourth_quarter | LAW | H.R. 320, The Rapid DNA Act of 2015; Support passage in the House. S.2348, The Rapid DNA Act of 2015; Support and passage in the Senate. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE | 16000 | 0 | 0 | 2018-01-17T12:59:02.080000-05:00 | |
| 2065090 | AMERICAN CONSERVATIVE UNION 74c5c464-e0e9-491f-83e3-86ef49f5941f | Q4 | AMERICAN CONSERVATIVE UNION | 62712 | AMERICAN CONSERVATIVE UNION | 2017 | fourth_quarter | LAW | - H.R.3356 "Prison Reform and Redemption Act of 2017" - S.1917, "Sentencing Reform and Corrections Act of 2017" | Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office | 10000 | 0 | 0 | 2018-01-17T13:29:16.920000-05:00 | |
| 2065235 | ENTERTAINMENT MERCHANTS ASSOCIATION d623693b-696a-4505-ab67-c54e96504e62 | Q4 | ENTERTAINMENT MERCHANTS ASSOCIATION | 68890 | ENTERTAINMENT MERCHANTS ASSOCIATION | 2017 | fourth_quarter | LAW | Combating organized retail crime generally. | 10000 | 0 | 0 | 2018-01-17T13:58:28.927000-05:00 | ||
| 2065781 | KOCH GOVERNMENT AFFAIRS, LLC de14170c-3cb0-4680-932c-764566dfd94e | Q4 | KOCH GOVERNMENT AFFAIRS, LLC | 400390816 | KOCH GOVERNMENT AFFAIRS, LLC | 2017 | fourth_quarter | LAW | Issues related to criminal justice reform | Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE,White House Office | 1830000 | 0 | 0 | 2018-01-17T15:50:36.383000-05:00 | |
| 2065865 | MARRIOTT INTERNATIONAL, INC. a01dbab3-eee3-4e19-b432-01004362c7c8 | Q4 | MARRIOTT INTERNATIONAL, INC. | 23873 | MARRIOTT INTERNATIONAL INC | 2017 | fourth_quarter | LAW | Monitor legislation to combat Human Trafficking; S.1862, Trafficking Victims Protection Reauthorization Act of 2017; H.R. 2200, Frederick Douglass Trafficking Victims Prevention and Protection Reauthorization Act; S.1693, Stop Enabling Sex Traffickers Act of 2017. | Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT) | 145000 | 0 | 0 | 2018-01-17T16:11:28.407000-05:00 | |
| 2066182 | DUNKEL GOVERNMENT RELATIONS f2b9fd1b-21b7-4bf6-ae68-bc476357da76 | Q4 | DUNKEL GOVERNMENT RELATIONS | 304337 | SECURITY INDUSTRY ASSOCIATION | 2017 | fourth_quarter | LAW | The School Safety Act. School security grants. | HOUSE OF REPRESENTATIVES,SENATE | 22500 | 0 | 0 | 2018-01-17T18:00:27.427000-05:00 | |
| 2066410 | CORNERSTONE GOVERNMENT AFFAIRS, INC. e8e42697-bb7a-4032-924c-0196e8f1a6a0 | Q4 | CORNERSTONE GOVERNMENT AFFAIRS, INC. | 75557 | HUNT DEVELOPMENT GROUP LLC | 2017 | fourth_quarter | LAW | Public/Private Partnerships | HOUSE OF REPRESENTATIVES,SENATE | 150000 | 0 | 0 | 2018-01-17T22:48:39.793000-05:00 | |
| 2066516 | NATIONAL EMPLOYMENT LAW PROJECT 2b45a12d-f346-48a8-9980-5707c2aba5c6 | Q4 | NATIONAL EMPLOYMENT LAW PROJECT | 400462295 | NATIONAL EMPLOYMENT LAW PROJECT | 2017 | fourth_quarter | LAW | Fair Chance Act; REDEEM Act; REAL Act | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE | 15000 | 0 | 0 | 2018-01-18T06:04:51.397000-05:00 | |
| 2066529 | TIMOTHY LOVAIN bbbf1137-df5c-4470-8ca8-a9265801d47e | Q4 | TIMOTHY LOVAIN | 401104490 | CROSSROADS STRATEGIES, LLC ON BEHALF OF INTOXALOCK | 2017 | fourth_quarter | LAW | Issues related to drunk driving prevention and enforcement; H.R.3353/S.1655, Transportation, Housing and Urban Development, and Related Agencies Appropriations Act, 2018; H.J.Res.123, Making further continuing appropriations for fiscal year 2018, and for other purposes (P.L.115-90); H.J.Res.124, Making further additional continuing appropriations for fiscal year 2018, and for other purposes; H.R.1370, Further Additional Continuing Appropriations Act, 2018 (P.L.115-96).​ | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 0 | 0 | 2018-01-18T06:16:56.393000-05:00 | ||
| 2066572 | MATTOON & ASSOCIATES, LLC b22a573d-0c21-4b56-bc89-10136187fbf0 | Q4 | MATTOON & ASSOCIATES, LLC | 314215 | ZEBRA TECHNOLOGIES CORPORATION | 2017 | fourth_quarter | LAW | Issues relating to the collection and transmission of transportation and law enforcement data. | HOUSE OF REPRESENTATIVES | 40000 | 0 | 0 | 2018-01-18T07:38:15.713000-05:00 | |
| 2066764 | WINNING STRATEGIES WASHINGTON 81bd0957-4c4c-4438-ab11-b14cc784ccad | 4T | WINNING STRATEGIES WASHINGTON | 50796 | MARYMOUNT MANHATTAN COLLEGE | 2017 | fourth_quarter | LAW | Criminal justice reform | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2018-01-18T09:44:00.727000-05:00 | |
| 2066844 | WINNING STRATEGIES WASHINGTON 9cf2b666-928c-42fa-988b-08b0f9f4f29c | Q4 | WINNING STRATEGIES WASHINGTON | 50796 | NATIONAL TROOPERS COALITION | 2017 | fourth_quarter | LAW | Thin Blue Line Act; Concealed Carry Reciprocity Act (H.R. 38) , Public Safety Officers' Benefits Improvements Act (S.419); American Law Enforcement Heroes Act of 2017 (H.R. 1428) , Mental Health and Wellness Act of 2017 (H.R. 2288) FY18 Appropriations for law enforcement programs; Law Enforcement Officers' Equity Act (S.424); National Right to Work Act (H.R. 785); The Sportsmen's Heritage and recreational Enhancement Act (H.R. 3668); POLICE Act (H.R. 2561); Preventing Tragedies Between Police and Communities Act (H.R. 3060); Protecting Lives Using Surplus Equipment Act of 2017 (H.R. 426); Walter Patterson and Werner Foerster Justice and Extradition Act (H.R. 1744); Honoring Hometown Heroes Act (H.R. 1892), Children of Fallen Heroes Scholarship Act (H.R. 949), Closing the Bump-Stock Loophole Act (H.R. 4168), Public Safety and Second Amendment Rights Protection Act of 2017 (H.R. 4240), Gun Safety: Not Sorry Act of 2017 (H.R. 4268), Federal Firearms Licensee Protection Act of 2017 (S.1854 ), Police CAMERA Act of 2017, To amend title 18, United States Code, to prohibit the manufacture, possession, or transfer of any part or combination of parts that is designed and functions to increase the rate of fire of a semiautomatic rifle but does not convert the semiautomatic rifle into a machinegun, and for other purposes (H. R. 3999) | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2018-01-18T09:57:41.237000-05:00 | |
| 2066913 | CARDINAL INFRASTRUCTURE LLC 684c4517-7869-49e4-9b78-13180b92e390 | Q4 | CARDINAL INFRASTRUCTURE LLC | 299913 | BLOOMINGTON NORMAL ECONOMIC DEVELOPMENT COUNCIL (FKA ECON DEV CNSL OF BLOOMIN) | 2017 | fourth_quarter | LAW | Mental health | Education, Dept of,Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,Transportation, Dept of (DOT) | 0 | 0 | 2018-01-18T10:14:17.170000-05:00 | ||
| 2067112 | WINNING STRATEGIES WASHINGTON fa558510-c5dd-474c-9688-96b5866f1492 | Q4 | WINNING STRATEGIES WASHINGTON | 50796 | SIMS METAL MANAGEMENT | 2017 | fourth_quarter | LAW | metal theft legislation | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2018-01-18T10:59:05.597000-05:00 | |
| 2067221 | MR. BALTAZAR SERNA, JR. 1b9f591e-18f8-4156-baca-1a614478d7cd | Q4 | MR. BALTAZAR SERNA, JR. | 40009064 | BEXAR COUNTY, TEXAS | 2017 | fourth_quarter | LAW | Support adequate SCAAP funding | Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,White House Office | 12000 | 0 | 0 | 2018-01-18T11:23:08.827000-05:00 | |
| 2067237 | THE RABEN GROUP eef5332a-7dd5-48dc-8fe4-6a5a78efb106 | Q4 | THE RABEN GROUP | 61458 | PROTEUS FUND | 2017 | fourth_quarter | LAW | Advocating for constitutional, statutory, and administrative protections for people accused or convicted of crimes. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2018-01-18T11:25:16.263000-05:00 | ||
| 2067247 | NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. ba2f5816-7a81-49f0-9a9c-37e8f8418f5e | Q4 | NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. | 26980 | NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. | 2017 | fourth_quarter | LAW | Public Safety Officers' Benefits (PSOB) Program proposed rulemaking, improving the PSOB death, disability and education benefits for survivors, Community Oriented Policing Services (COPS) Program, Honoring Hometown Heroes Act; Thin Blue Line Act; increased penalties for violent crimes against law enforcement officers; Email Privacy Act; protecting civil asset forfeiture; Law Enforcement Mental Health and Wellness Act; Allow States and Victims to Fight Online Sex Trafficking Act; Stop Enabling Sex Traffickers Act; Sentencing Reform and Corrections Act; INTERDICT Act; Law Enforcement Officers Procedural Bill of Rights; PROTECT Our Children Act; Skylar's Law; Fix NICS Act; CORRECTIONS Act; Combating Money Laundering, Terrorist Financing, and Counterfeiting Act; Cooling-Off Period Elimination Act; Police Accountability Act; Grand Jury Reform Act; Intimate Privacy Protection Act; a dedicated National Blue Alert Emergency Alert System event code; support for Steven Losquadro to be the U.S. Attorney for the Eastern District of New York. | Bureau of Justice Assistance,Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Justice Program,SENATE,White House Office | 40000 | 0 | 0 | 2018-01-18T11:27:19.510000-05:00 | |
| 2067313 | THE DLM GROUP 067bdf65-6b62-4a87-9841-164cdafe1db0 | Q4 | THE DLM GROUP | 313794 | ATADA | 2017 | fourth_quarter | LAW | Congressional and Executive Branch activities involving commerce of cultural items, lobbying issues and agencies interest. | Bureau of Indian Affairs (BIA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),SENATE,State, Dept of (DOS),U.S. Customs & Border Protection,U.S. Immigration & Customs Enforcement (ICE) | 10000 | 0 | 0 | 2018-01-18T11:37:59.710000-05:00 | |
| 2067395 | THE DLM GROUP 4eb51719-2386-4bc6-92ac-87f80e3fbc46 | Q4 | THE DLM GROUP | 313794 | GLOBAL HERITAGE ALLIANCE, INC. | 2017 | fourth_quarter | LAW | Congressional and Executive Branch activities involving commerce of cultural items, lobbying issues and agencies'interests. | Bureau of Indian Affairs (BIA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),SENATE,State, Dept of (DOS),U.S. Customs & Border Protection,U.S. Immigration & Customs Enforcement (ICE) | 10000 | 0 | 0 | 2018-01-18T11:51:55.287000-05:00 | |
| 2067602 | FEDERAL ADVOCATES, INC. 168aa63c-1fed-4fe4-b305-394cd58f7c84 | Q4 | FEDERAL ADVOCATES, INC. | 308172 | THE NATIONAL CANNABIS INDUSTRY ASSOCIATION | 2017 | fourth_quarter | LAW | Potential enforcement activities in regard to the legalized cannabis industry. | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,White House Office | 40000 | 0 | 0 | 2018-01-18T12:37:23.773000-05:00 | |
| 2067628 | TECHNOLOGY NETWORK AKA TECHNET 16f15877-18c0-4776-b3d2-c8e07428c52e | Q4 | TECHNOLOGY NETWORK AKA TECHNET | 69116 | TECHNOLOGY NETWORK AKA TECHNET | 2017 | fourth_quarter | LAW | Electronic Communications Privacy Act reform; H.R. 3718, International Communications Privacy Act | Commerce, Dept of (DOC),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),SENATE,Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR),White House Office | 60000 | 0 | 0 | 2018-01-18T12:46:41.600000-05:00 | |
| 2067821 | MORGAN, LEWIS & BOCKIUS, LLP 669f2c39-7715-4ab4-b82f-cadc96c54b23 | Q4 | MORGAN, LEWIS & BOCKIUS, LLP | 25818 | ALLIED UNIVERSAL "FKA" ALLIEDBARTON SECURITY SERVICES | 2017 | fourth_quarter | LAW | Background checks for private security officers, including S. 705, the Child Protection Improvements Act of 2017. | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2018-01-18T13:35:50.790000-05:00 | |
| 2067947 | BRENNAN CENTER FOR JUSTICE AT NYU SCHOOL OF LAW d48c3498-c93e-4e2e-8596-fc2b5579b8c4 | Q4 | BRENNAN CENTER FOR JUSTICE AT NYU SCHOOL OF LAW | 400263201 | BRENNAN CENTER FOR JUSTICE AT NEW YORK UNIVERSITY SCHOOL OF LAW | 2017 | fourth_quarter | LAW | Domestic Terrorism Prevention Act Sentencing Reform Safe Justice Reinvestment Act Criminal Justice Reform | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2018-01-18T14:03:25.407000-05:00 | |
| 2068010 | THE RABEN GROUP 22c56fe6-123d-4e22-b401-82683fd71e2c | Q4 | THE RABEN GROUP | 61458 | INNOCENCE PROJECT | 2017 | fourth_quarter | LAW | Conducted outreach regarding the need for forensic science reform, including the establishment of and support for a federal entity to develop research, establish standards, and oversee conduct in the field of forensic sciences. Advocated for appropriations to support the expansion of forensic science research and standard-setting. | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE | 30000 | 0 | 0 | 2018-01-18T14:12:59.107000-05:00 | |
| 2068059 | THE RABEN GROUP 1e49f978-daaa-4459-8512-58040b609625 | Q4 | THE RABEN GROUP | 61458 | KUYKENDALL & ASSOCIATES, PC | 2017 | fourth_quarter | LAW | Lobbied House, Senate, and Administration on the issue of a Congressional response to the Supreme Courts decision in Medellin v. Texas to implement the judgment of the International Court of Justice in Avena and other Mexican Nationals. Lobbied House, Senate, and Administration on the issue of encouraging state compliance with consular notification responsibilities. Presidents Proposed Budget for FY2018, Department of State and Other International Programs, Sec. 7052: we support this provision, adopted by the Senate Appropriations Committee in the FY18 State, Foreign Operations and Related Programs Appropriations Act (S. 1788), which would provide for full implementation of U.S. obligations pursuant to the Vienna Convention on Consular Relations and the Avena case before the International Court of Justice. | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,State, Dept of (DOS),White House Office | 10000 | 0 | 0 | 2018-01-18T14:21:25.480000-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);