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

41,966 rows where filing_period = "first_quarter" and filing_year = 2010 sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filing_type, received_date (date)

issue_code >30

  • BUD 5,670
  • HCR 3,239
  • TAX 2,558
  • DEF 2,160
  • ENG 2,043
  • TRA 1,724
  • MMM 1,333
  • ENV 1,282
  • EDU 1,172
  • FIN 1,154
  • TRD 878
  • LBR 847
  • AGR 766
  • HOM 733
  • TEC 624
  • CAW 614
  • BAN 600
  • CPT 593
  • GOV 584
  • NAT 532
  • LAW 460
  • SCI 459
  • AVI 388
  • FOR 378
  • CSP 374
  • INS 359
  • HOU 356
  • IMM 352
  • ECN 349
  • FOO 340
  • …

filing_year 1

  • 2010 · 41,966 ✖

filing_period 1

  • first_quarter · 41,966 ✖
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
907047 ALTERN ACCESS d569ad7b-c255-40a8-a858-5351e0363d96 1TY ALTERN ACCESS 400454175 ALTERN ACCESS 2010 first_quarter           0 1 2010-01-04T06:35:08.717000-05:00
907055 MCALLISTER & QUINN, LLC 4a23d91a-c7db-4d43-ba86-c856cfb988c7 1TY MCALLISTER & QUINN, LLC 292573 UNIVERSITY OF FINDLAY 2010 first_quarter           0 1 2010-01-08T16:09:56.920000-05:00
907058 FAMILY COURT WATCH 9c53dbbb-cccb-4569-be6e-064852cfca62 Q1Y FAMILY COURT WATCH 400299412 FAMILY COURT WATCH 2010 first_quarter           0 0 2010-01-15T09:41:39.973000-05:00
907067 POWERS PYLES SUTTER & VERVILLE, P.C. d08920df-5aa3-4bb5-9295-6212732ec0a2 Q1 POWERS PYLES SUTTER & VERVILLE, P.C. 32008 ASSOCIATION OF METROPOLITAN WATER AGENCIES 2010 first_quarter ENV Safe Drinking Water Act Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES 7622   0 0 2010-01-15T17:15:00.517000-05:00
907068 POWERS PYLES SUTTER & VERVILLE, P.C. 1ef14429-8016-4e27-876a-261233310ec5 Q1 POWERS PYLES SUTTER & VERVILLE, P.C. 32008 MEDICAL GROUP MANAGEMENT ASSOCIATION 2010 first_quarter MMM Stark Law Medicare Reform HOUSE OF REPRESENTATIVES,SENATE 22740   0 0 2010-01-15T17:20:27.720000-05:00
907069 POWERS PYLES SUTTER & VERVILLE, P.C. cc396bde-675a-4df7-964a-17a2cb4c2529 Q1 POWERS PYLES SUTTER & VERVILLE, P.C. 32008 PAIN CARE COALITION 2010 first_quarter HCR Pain Care Legislation NIH Appropriations Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ) 36786   0 0 2010-01-15T17:25:28.653000-05:00
907070 PAUL MARCONE & ASSOCIATES, LLC f0ea618f-761b-4e65-b3c5-87185a749922 1TY PAUL MARCONE & ASSOCIATES, LLC 283732 VALIDAS INC 2010 first_quarter           0 1 2010-01-15T18:59:39.673000-05:00
907072 THE TINKLENBERG GROUP da0803b0-4fbe-492f-90d6-f3c3aa5549db 1T THE TINKLENBERG GROUP 400270240 CITY OF RAMSEY 2010 first_quarter TRA None       0 1 2010-01-18T13:44:11.773000-05:00
907076 MH STRATEGIES, LLC 94b8f62a-8a32-4e36-b886-bb0eb5563253 Q1 MH STRATEGIES, LLC 40022161 NATIONAL CENTER FOR STATE COURTS 2010 first_quarter TAX State Court Tax Intercept Legislation to allow for federal income tax intercepts for state judicial debts. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2010-01-18T18:37:12.390000-05:00
907077 MH STRATEGIES, LLC 94b8f62a-8a32-4e36-b886-bb0eb5563253 Q1 MH STRATEGIES, LLC 40022161 NATIONAL CENTER FOR STATE COURTS 2010 first_quarter BUD FY2010 Commerce, Justice, Science and Related Agencies Appropriations Bill for State Courts Improvement Initiative and court security funding; HR 1515 to seek an authorization for NCSC funding for increased research, education and technical assistance services for the state courts. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2010-01-18T18:37:12.390000-05:00
907112 ACA INTERNATIONAL 9db4dc6d-2519-481a-a838-29a24444f307 Q1 ACA INTERNATIONAL 81431 ACA INTERNATIONAL 2010 first_quarter TAX 1099-C reporting requirements Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Treasury, Dept of   50000 0 0 2010-01-20T10:43:52.893000-05:00
907113 ACA INTERNATIONAL 9db4dc6d-2519-481a-a838-29a24444f307 Q1 ACA INTERNATIONAL 81431 ACA INTERNATIONAL 2010 first_quarter FIN Fair Debt Collection Practices Act; Consumer Financial Protection Agency; Financial account record Keeping; Truth in Lending Act Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Treasury, Dept of   50000 0 0 2010-01-20T10:43:52.893000-05:00
907114 ACA INTERNATIONAL 9db4dc6d-2519-481a-a838-29a24444f307 Q1 ACA INTERNATIONAL 81431 ACA INTERNATIONAL 2010 first_quarter HCR Health care billing and collections; Health Insurance Portability and Accountability Act (HIPAA) Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Treasury, Dept of   50000 0 0 2010-01-20T10:43:52.893000-05:00
907115 ACA INTERNATIONAL 9db4dc6d-2519-481a-a838-29a24444f307 Q1 ACA INTERNATIONAL 81431 ACA INTERNATIONAL 2010 first_quarter CSP Fair Debt Collection Practices Act; Data Security; Fair Credit Reporting Act; Consumer Financial Protection Agency; Gramm-Leach-Bliley Act Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Treasury, Dept of   50000 0 0 2010-01-20T10:43:52.893000-05:00
907116 ACA INTERNATIONAL 9db4dc6d-2519-481a-a838-29a24444f307 Q1 ACA INTERNATIONAL 81431 ACA INTERNATIONAL 2010 first_quarter COM Telephone Consumer Protection Act Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Treasury, Dept of   50000 0 0 2010-01-20T10:43:52.893000-05:00
907132 KENTUCKY FARM BUREAU FEDERATION 512eb7d1-ad4e-437a-bca2-7277843143f6 1TY KENTUCKY FARM BUREAU FEDERATION 21450 KENTUCKY FARM BUREAU FEDERATION 2010 first_quarter           0 1 2010-01-20T13:14:25.397000-05:00
907133 KENTUCKY FARM BUREAU FEDERATION 608bdb59-ed3d-4f84-a0a3-d1956deb1e8d 1@Y KENTUCKY FARM BUREAU FEDERATION 21450 KENTUCKY FARM BUREAU FEDERATION 2010 first_quarter           0 1 2010-01-20T13:18:55.177000-05:00
907134 DEFENSE STRATEGY CORP d6383c5b-199e-49c4-8aba-3bf0499e8389 1TY DEFENSE STRATEGY CORP 400498458 BIMBA TEXTILE STUDO AND BIMBA TRADING 2010 first_quarter           0 1 2010-01-20T13:21:21.990000-05:00
907148 LOWER COLORADO RIVER AUTHORITY 2ffa1b29-ee12-496a-a58e-c3fbae695118 Q1 LOWER COLORADO RIVER AUTHORITY 40026215 LOWER COLORADO RIVER AUTHORITY 2010 first_quarter BUD Energy and Water Appropriations. Seeking federal funding through the Corps of Engineers for communities in our baisn. Army, Dept of (Corps of Engineers),Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Surface Transportation Board (STB),U.S. Fish & Wildlife Service (USFWS)   30000 0 0 2010-01-20T14:38:30.820000-05:00
907149 LOWER COLORADO RIVER AUTHORITY 2ffa1b29-ee12-496a-a58e-c3fbae695118 Q1 LOWER COLORADO RIVER AUTHORITY 40026215 LOWER COLORADO RIVER AUTHORITY 2010 first_quarter TRA Monitor legislative proposals and federal agency actions regarding railroad transportation and the delivery of coal supplies. Specific legislation includes the railroad Competition and Service Improvement Act and the Railroad Antitrust act. Army, Dept of (Corps of Engineers),Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Surface Transportation Board (STB),U.S. Fish & Wildlife Service (USFWS)   30000 0 0 2010-01-20T14:38:30.820000-05:00
907150 LOWER COLORADO RIVER AUTHORITY 2ffa1b29-ee12-496a-a58e-c3fbae695118 Q1 LOWER COLORADO RIVER AUTHORITY 40026215 LOWER COLORADO RIVER AUTHORITY 2010 first_quarter TAX Clean Renewable Energy Bonds, Production tax credit and other proposals that affect public power entities' ability to utilize tax-exempt financing. Army, Dept of (Corps of Engineers),Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Surface Transportation Board (STB),U.S. Fish & Wildlife Service (USFWS)   30000 0 0 2010-01-20T14:38:30.820000-05:00
907151 LOWER COLORADO RIVER AUTHORITY 2ffa1b29-ee12-496a-a58e-c3fbae695118 Q1 LOWER COLORADO RIVER AUTHORITY 40026215 LOWER COLORADO RIVER AUTHORITY 2010 first_quarter ENV Clean water and air issues, water supply issues, renewable energy issues, climate change, emissions issues, land management and endangered species. Army, Dept of (Corps of Engineers),Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Surface Transportation Board (STB),U.S. Fish & Wildlife Service (USFWS)   30000 0 0 2010-01-20T14:38:30.820000-05:00
907152 LOWER COLORADO RIVER AUTHORITY 2ffa1b29-ee12-496a-a58e-c3fbae695118 Q1 LOWER COLORADO RIVER AUTHORITY 40026215 LOWER COLORADO RIVER AUTHORITY 2010 first_quarter CAW Monitor congressional and federal agency actions regarding air quality, renewable energy portfolio, climate change, clean water and endangered species. Army, Dept of (Corps of Engineers),Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Surface Transportation Board (STB),U.S. Fish & Wildlife Service (USFWS)   30000 0 0 2010-01-20T14:38:30.820000-05:00
907153 LOWER COLORADO RIVER AUTHORITY 2ffa1b29-ee12-496a-a58e-c3fbae695118 Q1 LOWER COLORADO RIVER AUTHORITY 40026215 LOWER COLORADO RIVER AUTHORITY 2010 first_quarter ENG Monitor congressional and federal agency action in the areas of renewable energy, emmissions standards, tax incentives for public power, climate change, coal delivery issues,coal ash disposal, transmission and other issues. Army, Dept of (Corps of Engineers),Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Surface Transportation Board (STB),U.S. Fish & Wildlife Service (USFWS)   30000 0 0 2010-01-20T14:38:30.820000-05:00
907174 CAPITOL HILL STRATEGIES, LLC bfbcbf7f-1be2-43f2-bdca-5708652284bb 1TY CAPITOL HILL STRATEGIES, LLC 91774 NATIONAL ASSOCIATION OF HOME BUILDERS 2010 first_quarter       70000   0 1 2010-01-20T16:23:48.060000-05:00
907175 AMEREN SERVICES 73d8fc03-97c6-40f2-9317-f72a138e096a Q1 AMEREN SERVICES 38962 AMEREN SERVICES 2010 first_quarter ENG S. 1462--American Clean Energy Leadership Act--all sections including RES Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,President of the U.S.,SENATE   1640000 0 0 2010-01-20T16:33:05.150000-05:00
907176 AMEREN SERVICES 73d8fc03-97c6-40f2-9317-f72a138e096a Q1 AMEREN SERVICES 38962 AMEREN SERVICES 2010 first_quarter BUD H.R. 2996--FY '10 Department of Interior/Environment and Related Agencies Appropriations Act--Senate Amendment # 2530, Murkowski Amendment re: EPA endangerment--preventing EPA from regulating Co2 emissions Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,President of the U.S.,SENATE   1640000 0 0 2010-01-20T16:33:05.150000-05:00
907177 AMEREN SERVICES 73d8fc03-97c6-40f2-9317-f72a138e096a Q1 AMEREN SERVICES 38962 AMEREN SERVICES 2010 first_quarter FIN S. 272--Derivatives Trading Integrity Act of 2009--all sections H.R. 2454-- Amereican Clean Energy and Security Act--Sec 342--Carbon Derivative Markets; Sec 351--Regulation of Certain Transactions Involving Energy Commodities H. R. 977--Derivatives Market and Transparency and Accountability Act of 2009 (All sections on OTC derivatives); H.R. 3300--Dervivative Trading Accountability and Disclosure Act--all sections on OTC derivatives H.R. 3795--Over-the Counter Derivatives Markets Act of 2009--all sections on OTC derivatives H.R. 4173-- Wall Street Reform and Consumer Protection Act of 2009--Title III--Derivatives Markets Transparency and Accountability Act--all sections Murphy Amendment # 129--narrows the definition of Major swap participant to focus on systemic risk Frank Amendment # 66--would have given the CFTC the authority to impose margin requirements on end user transactions Stupak Amendment # 47--requiring all non-cleared swaps to be executed on a registered swap execution facility Stupak Amendment # 48--would have given the CFTC the discretion to ban abusive swaps S. 1074--Shareholder Bill of Rights Act of 2009--all sections Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,President of the U.S.,SENATE   1640000 0 0 2010-01-20T16:33:05.150000-05:00
907178 AMEREN SERVICES 73d8fc03-97c6-40f2-9317-f72a138e096a Q1 AMEREN SERVICES 38962 AMEREN SERVICES 2010 first_quarter CHM HR 2868--The Chemical Facility Anti-Terrorism Act--Sections 2101, 2102, 2103, 2105, 2107, 2111 and 2116 McCaul Amendment # 1--would strike the citizen enforcement section of this bill Dent Amendment # 5--would strike section 2111, requiring assessments and implementation methods to reduce consequences of terrorist attacks; Dent Amendment # 4--would strike Title I, affecting chemical facilities and replace it with an extension of the Department of Homeland Security's current regulatory authority under section 550(b) of the Department of Homeland Security Appropriations Act of 2007 Barton Amendment # 14--would replace provisions in this bill allowing new federal chemical facility regulations enacted by this bill to preempt state and local laws that hinder, pose obstacles to, conflict with, or frustrate the purpose of the federal program Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,President of the U.S.,SENATE   1640000 0 0 2010-01-20T16:33:05.150000-05:00
907179 AMEREN SERVICES 73d8fc03-97c6-40f2-9317-f72a138e096a Q1 AMEREN SERVICES 38962 AMEREN SERVICES 2010 first_quarter ENV HR 2454--The American Clean Energy and Security Act--(climate change bill--all titles and sections) S. 1733--The Clean Energy Jobs And American Power Act (climate change bill---all titles and sections) Proposed Coal Ash Regulation by EPA under RCRA and CWA Coal Ash issues, generally Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,President of the U.S.,SENATE   1640000 0 0 2010-01-20T16:33:05.150000-05:00
907180 AMEREN SERVICES 73d8fc03-97c6-40f2-9317-f72a138e096a Q1 AMEREN SERVICES 38962 AMEREN SERVICES 2010 first_quarter CAW S. 787 The Clean Water Restoration Act--Baucus-Klobuchar Substitute--all sections--removal of "navigable waters" language Clean Water Act Enforcement Issues Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,President of the U.S.,SENATE   1640000 0 0 2010-01-20T16:33:05.150000-05:00
907182 NATIONAL ORGANIZATION FOR THE REFORM OF MARIJUANA LAWS e1f1cfa9-6952-42ff-842a-2395d1cfd49b Q1 NATIONAL ORGANIZATION FOR THE REFORM OF MARIJUANA LAWS 48188 NATIONAL ORGANIZATION FOR THE REFORM OF MARIJUANA LAWS 2010 first_quarter LAW Support HR 2943, a bill to eliminate federal penalties for possession of marijuana for personal use. Support HR 2835, a bill to provide for the medical use of marijuana in accordance with the laws of the various states. Support HR 1866, the Industrial Hemp Farming Act. HOUSE OF REPRESENTATIVES,SENATE     0 0 2010-01-20T17:31:05.267000-05:00
907201 RAY BILLUPS 8fce2780-f040-4e15-8466-7adb5abf27a0 1T RAY BILLUPS 6223 USEC INC 2010 first_quarter ENG None       0 1 2010-01-22T19:42:26.573000-05:00
907202 WORLD SHIPPING COUNCIL 39ca9044-b750-4385-b859-8ac038cc3767 Q1 WORLD SHIPPING COUNCIL 58090 WORLD SHIPPING COUNCIL 2010 first_quarter TRA Vessel emissions reduction; Climate change policy; Maritime and cargo security regulations and legislation (10 plus 2 rule; Piracy; C-TPAT; eNAO/D; ACE; AES); Ship discharges and ballast water management (EPA VGP; USCG ballast water rule; ship discharges legislation); Intermodal infrastructure legislation; Animal and plant inspections; Whale ship strikes; Shipping Act of 1984; Federal Aviation Administration Authorization Act. Bureau of the Census,Defense, Dept of (DOD),Environmental Protection Agency (EPA),Federal Maritime Commission,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Maritime Administration (MARAD),Natl Oceanic & Atmospheric Administration (NOAA),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Coast Guard (USCG),U.S. Customs & Border Protection   79000 0 0 2010-01-25T07:15:57.183000-05:00
907203 HOWREY LLP 6825dad4-a335-4c97-9a26-c50984dbadbe 1T HOWREY LLP 18752 MONEY SERVICES ROUND TABLE (FKA THE NON-BANK FUNDS TRANSMITTERS GROUP) 2010 first_quarter FIN Funds transmission disclosure       0 1 2010-01-25T10:12:59.037000-05:00
907204 FOXLEY & PIGNANELLI 38381220-e7f2-470b-b896-4441e078944f Q1 FOXLEY & PIGNANELLI 400323516 REGENCE BLUE CROSS BLUE SHIELD 2010 first_quarter INS Health Insurance HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2010-01-25T11:19:27.770000-05:00
907212 LIEBMAN & ASSOCIATES, INC. 45a9d016-d615-4ac1-b791-401f31fcd900 1TY LIEBMAN & ASSOCIATES, INC. 46585 SOLEXANT CORP. 2010 first_quarter           0 1 2010-01-27T08:28:13.877000-05:00
907215 J & E CONSULTANTS e6d2458e-5498-4e34-b827-de6399857e1e Q1Y J & E CONSULTANTS 400498455 SOUTH TEXAS REDEVELOPMENT, INC. 2010 first_quarter           0 0 2010-01-27T14:01:11.250000-05:00
907217 BROYDRICK & ASSOCIATES 22dfdd19-4511-4c33-86f6-e97d7d29ea79 1TY BROYDRICK & ASSOCIATES 7268 NATIONAL ASSOCIATION OF CLEAN WATER AGENCIES 2010 first_quarter       10000   0 1 2010-01-27T17:51:13.440000-05:00
907218 BINGHAM MCCUTCHEN LLP 1fe82a09-b4d9-4c7d-ad49-7c87c6ec8a8f 1T BINGHAM MCCUTCHEN LLP 51560 MICROSOFT CORPORATION 2010 first_quarter TAX Tax issues of interest to the U.S. software industry, including the R&D tax credit; international tax reforms included in the Budget of the U.S. Government for Fiscal Year 2010; H.R. 422 and S. 1203, to amend the Internal Revenue Code to extend the research credit through 2010 and to increase and make permanent the alternative simplified research credit; and H.R. 4213, Tax Extenders Act of 2009. HOUSE OF REPRESENTATIVES,SENATE 30000   0 1 2010-01-28T11:26:52.873000-05:00
907219 BINGHAM MCCUTCHEN LLP 27ae1601-3c63-4ad9-950d-6e06177ca177 1T BINGHAM MCCUTCHEN LLP 51560 REUSABLE INDUSTRIAL PACKAGING ASSOCIATION 2010 first_quarter ENV Energy and environment, including climate change, issues affecting the industrial packaging industry; H.R. 2454, American Clean Energy and Security Act of 2009; S. 1733, Clean Energy Jobs and American Power Act. HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-01-28T11:30:53.827000-05:00
907221 CAMPAIGN FOR AMERICA'S WILDERNESS 7dc7261c-ae84-4d97-9f44-a83bc733a116 1T CAMPAIGN FOR AMERICA'S WILDERNESS 84992 CAMPAIGN FOR AMERICA'S WILDERNESS 2010 first_quarter ENV HR 192 Central Idaho National Forest Public Lands Management Act S. 881 Alaska Native land claims Tongass National Forest conservation issues Colville National Forest conservation issues S 1470 Montana Forest Jobs and Recreation Act S 2762 San Juan Mountains Wilderness Act of 2009 HR 3914 San Juan Mountains Wilderness Act of 2009 S 874 - Rio Grande del Norte National Conservation Area Establishment Act S 1689 Organ Mountains-Desert Peaks Wilderness Act S 2921 California Desert Protection Act of 2010 HR 3444 Pinnacles National Park Act HR 4040 Big Sur Forest Service Management Unit Act of 2009 HR 4304 Beauty Mountain and Agua Tibia Wilderness Act of 2009 Bureau of Land Management (BLM),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Park Service (NPS),SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service     0 1 2010-01-30T09:42:15.820000-05:00
907222 KERRIGAN AND ASSOCIATES 2d4a251b-f1af-4145-ac8b-078e013d5bda Q1Y KERRIGAN AND ASSOCIATES 21494 GCI-WISCONSIN 2010 first_quarter           0 0 2010-01-30T17:16:16.830000-05:00
907223 SUN MICROSYSTEMS, INC ea5e26a3-316d-410d-ae53-7a5c3fb84214 1T SUN MICROSYSTEMS, INC 37323 SUN MICROSYSTEMS INC 2010 first_quarter ENV Energy Efficiency Guidance for drafting EPA Energy Star for ICT products and data centers HR 2454, American Clean Energy And Security Act of 2009 Commerce, Dept of (DOC),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-01T09:04:29.620000-05:00
907224 SUN MICROSYSTEMS, INC ea5e26a3-316d-410d-ae53-7a5c3fb84214 1T SUN MICROSYSTEMS, INC 37323 SUN MICROSYSTEMS INC 2010 first_quarter CSP Data breach notification legislation and issues Commerce, Dept of (DOC),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-01T09:04:29.620000-05:00
907225 SUN MICROSYSTEMS, INC ea5e26a3-316d-410d-ae53-7a5c3fb84214 1T SUN MICROSYSTEMS, INC 37323 SUN MICROSYSTEMS INC 2010 first_quarter GOV promotion of stateless thin clients, Open IT, and energy efficient IT in federal facilities Commerce, Dept of (DOC),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-01T09:04:29.620000-05:00
907226 SUN MICROSYSTEMS, INC ea5e26a3-316d-410d-ae53-7a5c3fb84214 1T SUN MICROSYSTEMS, INC 37323 SUN MICROSYSTEMS INC 2010 first_quarter ACC Investor Communications Commerce, Dept of (DOC),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-01T09:04:29.620000-05:00
907227 SUN MICROSYSTEMS, INC ea5e26a3-316d-410d-ae53-7a5c3fb84214 1T SUN MICROSYSTEMS, INC 37323 SUN MICROSYSTEMS INC 2010 first_quarter IMM Increasing the availability of green cards and H!-B visas for highly skilled foreign professionals Commerce, Dept of (DOC),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-01T09:04:29.620000-05:00
907228 SUN MICROSYSTEMS, INC ea5e26a3-316d-410d-ae53-7a5c3fb84214 1T SUN MICROSYSTEMS, INC 37323 SUN MICROSYSTEMS INC 2010 first_quarter SCI Promoting further steps on cyber security Promote Open IT Promote transparency of IP in standards setting organizations Commerce, Dept of (DOC),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-01T09:04:29.620000-05:00
907229 SUN MICROSYSTEMS, INC ea5e26a3-316d-410d-ae53-7a5c3fb84214 1T SUN MICROSYSTEMS, INC 37323 SUN MICROSYSTEMS INC 2010 first_quarter LBR education on competition, consumer choice, and trends in the computer industry promoting the adoption of increased use of stateless thin clients, open IT, and telework in the federal workplace Commerce, Dept of (DOC),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-01T09:04:29.620000-05:00
907230 SUN MICROSYSTEMS, INC ea5e26a3-316d-410d-ae53-7a5c3fb84214 1T SUN MICROSYSTEMS, INC 37323 SUN MICROSYSTEMS INC 2010 first_quarter TRD China trade policy Export control policy Commerce, Dept of (DOC),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-01T09:04:29.620000-05:00
907231 SUN MICROSYSTEMS, INC ea5e26a3-316d-410d-ae53-7a5c3fb84214 1T SUN MICROSYSTEMS, INC 37323 SUN MICROSYSTEMS INC 2010 first_quarter HCR President's eHealth Initiative Promote use of open IT and interoperability in ehealth Commerce, Dept of (DOC),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-01T09:04:29.620000-05:00
907232 AKERMAN LLP e7ec3aea-01da-4c3c-9762-3dfd94b5105f 1T AKERMAN LLP 287270 KABA MAS CORPORATION 2010 first_quarter BUD Work to gain support for lock upgrades for defense and homeland security contractors, including provisions regarding upgrades and supplemental security savings. Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-01T11:45:13.533000-05:00
907233 AKERMAN LLP e7ec3aea-01da-4c3c-9762-3dfd94b5105f 1T AKERMAN LLP 287270 KABA MAS CORPORATION 2010 first_quarter GOV Work to gain support for classified storage and upgrades for various agencies and contractors; gain possible support for provisions regarding supplemental security savings and measures in authorization process. Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-01T11:45:13.533000-05:00
907234 AKERMAN LLP e7ec3aea-01da-4c3c-9762-3dfd94b5105f 1T AKERMAN LLP 287270 KABA MAS CORPORATION 2010 first_quarter HOM Follow development and implementation of appropriate classified storage policies throughout the Department of Homeland Security and its contractors; work to gain support for classified upgrades throughout the Department of Homeland Security and its contractors Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-01T11:45:13.533000-05:00
907235 AKERMAN LLP e7ec3aea-01da-4c3c-9762-3dfd94b5105f 1T AKERMAN LLP 287270 KABA MAS CORPORATION 2010 first_quarter DEF Work to gain support for classified storage and upgrades for various agencies and contractors; gain possible support for provisions regarding supplemental security savings and measures in authorization process. Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-01T11:45:13.533000-05:00
907236 STEPTOE LLP c2774cdf-32b6-403b-bea7-c3c86ac415fa 1T STEPTOE LLP 36710 LEHMAN BROTHERS HOLDINGS INC. 2010 first_quarter TAX H.R. 4169, Tax Technical Corrections Act of 2009; H.R. 3458 (Worker, Homeownership, and Business Assistance Act of 2009), section 13, net operating loss rules HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 50000   0 1 2010-02-01T12:01:49.650000-05:00
907237 OWEN EVANS INGOLS 04332014-54b7-4e53-92cc-919e33c8c9cd 1T OWEN EVANS INGOLS 82135 AREVA INC 2010 first_quarter ENG issues related to the nuclear fuel cycle SENATE     0 1 2010-02-01T16:11:43.467000-05:00
907238 BRUCE LEHMAN d3dc18dd-2e9d-42b2-8f25-31c917b23eb2 1T BRUCE LEHMAN 400456195 ARTISTS RIGHTS SOCIETY 2010 first_quarter CPT Copyright Legislation HOUSE OF REPRESENTATIVES,Patent & Trademark Office (PTO),SENATE,U.S. Copyright Office 20000   0 1 2010-02-02T12:32:43.073000-05:00
907239 COVINGTON & BURLING LLP fe38f8f4-967f-42af-a4a4-59f3f4dc62f9 1TY COVINGTON & BURLING LLP 11195 GABRIEL RESOURCES LTD 2010 first_quarter           0 1 2010-02-02T15:44:33.027000-05:00
907254 NATIONAL ASSOCIATION OF REAL ESTATE INVESTMENT MANAGERS 7bdb16dc-ec6e-44ae-9365-62607bec89ff Q1Y NATIONAL ASSOCIATION OF REAL ESTATE INVESTMENT MANAGERS 400375723 NATIONAL ASSOCIATION OF REAL ESTATE INVESTMENT MANAGERS 2010 first_quarter           0 0 2010-02-04T10:51:12.093000-05:00
907255 MARSHALL BRACHMAN 9a729884-d873-43e5-a43e-cc916463798f 1T MARSHALL BRACHMAN 6848 TOWN OF MARANA ARIZONA 2010 first_quarter URB funding for regional interchange and for airport tower HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-04T12:06:16.053000-05:00
907256 MARSHALL BRACHMAN 9a729884-d873-43e5-a43e-cc916463798f 1T MARSHALL BRACHMAN 6848 TOWN OF MARANA ARIZONA 2010 first_quarter BUD funding for regional highway exchanges funding for airport tower HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-04T12:06:16.053000-05:00
907257 MARSHALL BRACHMAN 9a729884-d873-43e5-a43e-cc916463798f 1T MARSHALL BRACHMAN 6848 TOWN OF MARANA ARIZONA 2010 first_quarter RES Development of regional endangered species habitat conservation plans local airport expansion issues HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-04T12:06:16.053000-05:00
907258 MR. WILLIAM P. BLAIR III 30b5a8d0-9708-433b-8907-2630c7fa9aed 1TY MR. WILLIAM P. BLAIR III 75295 HANNA PERKINS CENTER FOR CHILD DEVELOPMENT 2010 first_quarter           0 1 2010-02-05T14:53:17.863000-05:00
907259 MR. WILLIAM P. BLAIR III 99086c20-4a55-4f29-8960-a9773d53079e 1TY MR. WILLIAM P. BLAIR III 75295 MOBILEMED 1 FOUNDATION 2010 first_quarter           0 1 2010-02-05T14:59:18.817000-05:00
907260 MR. WILLIAM P. BLAIR III 261dd95a-99a8-44ca-910f-ec6bbee5e658 1TY MR. WILLIAM P. BLAIR III 75295 NORTHEAST OHIO ARTS EDUCATION COLLABORATIVE 2010 first_quarter           0 1 2010-02-05T15:04:19.770000-05:00
907261 JASON LARRABEE VENTURES, LLC abc398d2-a2bb-403a-87c6-6f5616898375 1T JASON LARRABEE VENTURES, LLC 400304424 PACIFIC RENEWABLE FUELS, INC. 2010 first_quarter ENG Biofuels HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-07T00:11:59.077000-05:00
907262 ROBERT GIROUX 876b92fd-47b4-4e70-8fc1-0aa127213718 1TY ROBERT GIROUX 317138 SERVICE EMPLOYEES INTERNATIONAL UNION 2010 first_quarter           0 1 2010-02-09T14:24:54.880000-05:00
907263 TOWNSEND PUBLIC AFFAIRS, INC c4340f33-fda2-4822-b0f0-b8917c31da1d 1TY TOWNSEND PUBLIC AFFAIRS, INC 54734 CITY OF TORRANCE 2010 first_quarter       7500   0 1 2010-02-09T19:25:58.617000-05:00
907264 TOWNSEND PUBLIC AFFAIRS, INC 35fb7be9-65f7-4dd4-9010-0f11449011df 1TY TOWNSEND PUBLIC AFFAIRS, INC 54734 ENVISION SCHOOL 2010 first_quarter           0 1 2010-02-09T20:00:00.450000-05:00
907265 TOWNSEND PUBLIC AFFAIRS, INC 90aad1dc-eb41-4e56-9e39-345e9a532ac9 1TY TOWNSEND PUBLIC AFFAIRS, INC 54734 TECHVISION 21 ON BEHALF OF FIREFLY ENERGY 2010 first_quarter           0 1 2010-02-09T20:42:02.263000-05:00
907266 TOWNSEND PUBLIC AFFAIRS, INC 52776994-3c81-4e24-bf1d-e198b4d48aea 1TY TOWNSEND PUBLIC AFFAIRS, INC 54734 TECHVISION 21 ON BEHALF OF PVT SOLAR 2010 first_quarter           0 1 2010-02-09T20:47:03.213000-05:00
907267 FIDELIS GOVERNMENT RELATIONS 31afa5d0-fb0e-4b14-80ce-5a2e657d4a6c 1T FIDELIS GOVERNMENT RELATIONS 306011 FEDERAL STRATEGY GROUP 2010 first_quarter INS Bail Issues; pre-trial release regulations HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2010-02-12T10:50:13.727000-05:00
907268 FIDELIS GOVERNMENT RELATIONS 31afa5d0-fb0e-4b14-80ce-5a2e657d4a6c 1T FIDELIS GOVERNMENT RELATIONS 306011 FEDERAL STRATEGY GROUP 2010 first_quarter LAW Bail issues: Pre-trial release regulations HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2010-02-12T10:50:13.727000-05:00
907269 SISTERS OF MERCY HEALTH SYSTEM 47bcab41-bfc7-4af2-b774-a147d5415e6e 1T SISTERS OF MERCY HEALTH SYSTEM 400327543 SISTERS OF MERCY HEALTH SYSTEM 2010 first_quarter MMM n/a       0 1 2010-02-12T12:03:20.413000-05:00
907278 21ST CENTURY SYSTEMS, INC> (21CSI) 8c09045e-9373-4a1e-b130-f60f2a104531 1T 21ST CENTURY SYSTEMS, INC> (21CSI) 303690 21ST CENTURY SYSTEMS INC (21CSI) 2010 first_quarter BUD National Defense Authorization and Apporpriations bills for Fiscal Year 2011.       0 1 2010-02-15T16:36:07.933000-05:00
907279 PUBLIC KNOWLEDGE 0457cb5b-3bd2-44ea-96bf-6605b6d64937 Q1Y PUBLIC KNOWLEDGE 315012 PUBLIC KNOWLEDGE 2010 first_quarter           0 0 2010-02-16T21:57:14.180000-05:00
907280 LIEBMAN & ASSOCIATES, INC. fc86f6af-1391-4d4c-8bd9-6b4836715510 1TY LIEBMAN & ASSOCIATES, INC. 46585 FOREST CITY HAWAII LLC 2010 first_quarter           0 1 2010-02-17T13:51:21.447000-05:00
907281 VALUE PLACE LLC fb5666e7-a7f9-48b4-8269-72f9c3e669db 1TY VALUE PLACE LLC 400402901 VALUE PLACE LLC 2010 first_quarter           0 1 2010-02-18T11:15:34.743000-05:00
907282 BSA IMPACT 85ec6f9e-bb57-4ca9-a00f-c09ca935bd8d 1TY BSA IMPACT 400484393 VALUE PLACE LLC 2010 first_quarter           0 1 2010-02-18T13:32:48.773000-05:00
907283 QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES) 3adbb3a2-9a6f-4131-8e87-8b7ffdf5342b 1T QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES) 54197 TOYOTA MOTOR NORTH AMERICA, INC. 2010 first_quarter FIN Regulatory Overhaul of Financial System Senate Banking Committee Draft - Restoring American Financial Stability Act of 2009 HOUSE OF REPRESENTATIVES,SENATE 30000   0 1 2010-02-19T11:10:58.180000-05:00
907284 QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES) 3adbb3a2-9a6f-4131-8e87-8b7ffdf5342b 1T QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES) 54197 TOYOTA MOTOR NORTH AMERICA, INC. 2010 first_quarter CSP Issues related to the vehicle recall HOUSE OF REPRESENTATIVES,SENATE 30000   0 1 2010-02-19T11:10:58.180000-05:00
907285 QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES) 3adbb3a2-9a6f-4131-8e87-8b7ffdf5342b 1T QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES) 54197 TOYOTA MOTOR NORTH AMERICA, INC. 2010 first_quarter AUT Issues related to the vehicle recall HOUSE OF REPRESENTATIVES,SENATE 30000   0 1 2010-02-19T11:10:58.180000-05:00
907286 AVINEON, INC. 12f394df-6049-4012-ac4e-5d0eb89a56a1 1T AVINEON, INC. 400432092 AVINEON, INC. 2010 first_quarter BUD None HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-02-19T11:53:59.350000-05:00
907288 WINSTON & STRAWN LLP ada47236-47e1-4487-9b46-a727c8ce1232 1TY WINSTON & STRAWN LLP 41682 THE BOEING COMPANY 2010 first_quarter           0 1 2010-02-22T17:38:28.640000-05:00
907289 LAURA MURPHY & ASSOCIATES, LLC 9c32b58a-08ec-4b5d-b003-36fd91a9427b 1T LAURA MURPHY & ASSOCIATES, LLC 324013 CAMPAIGN FOR A NEW DOMESTIC HUMAN RIGHTS AGENDA ("INFORMAL COALITION") 2010 first_quarter CIV Proposed Executive Order to revive Interagency Working Group on Human Rights Proposal to reform the U.S. Commission on Civil (and Human) Rights Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS) 20000   0 1 2010-02-24T12:23:51.060000-05:00
907290 LAURA MURPHY & ASSOCIATES, LLC 9c32b58a-08ec-4b5d-b003-36fd91a9427b 1T LAURA MURPHY & ASSOCIATES, LLC 324013 CAMPAIGN FOR A NEW DOMESTIC HUMAN RIGHTS AGENDA ("INFORMAL COALITION") 2010 first_quarter FOR Proposed Executive Order to revive Interagency Working Group on Human Rights Proposal to reform the U.S. Commission on Civil (and Human) Rights Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS) 20000   0 1 2010-02-24T12:23:51.060000-05:00
907291 LAURA MURPHY & ASSOCIATES, LLC f76d8330-3b51-48ff-ab10-c701d764eeae 1T LAURA MURPHY & ASSOCIATES, LLC 324013 FAMILY MATTERS OF GREATER WASHINGTON 2010 first_quarter BUD Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act, FY2011, Social service related issues and initiatives. Executive Office of the President (EOP) 10000   0 1 2010-02-24T12:25:52.197000-05:00
907292 LAURA MURPHY & ASSOCIATES, LLC f76d8330-3b51-48ff-ab10-c701d764eeae 1T LAURA MURPHY & ASSOCIATES, LLC 324013 FAMILY MATTERS OF GREATER WASHINGTON 2010 first_quarter FAM Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act, FY2011, Social service related issues and initiatives. Executive Office of the President (EOP) 10000   0 1 2010-02-24T12:25:52.197000-05:00
907293 WATSON GREEN LLC (FORMERLY WATSON/MULHERN, LLC) 1bcece80-f99a-40c1-be99-9502ae3c4281 1T WATSON GREEN LLC (FORMERLY WATSON/MULHERN, LLC) 318356 PFIZER ANIMAL HEALTH 2010 first_quarter AGR N/A       0 1 2010-02-25T10:31:06.210000-05:00
907294 FOLEY HOAG LLP b11ca512-9719-40d0-8591-c5bad1a1fc46 1T FOLEY HOAG LLP 79610 XDX INC 2010 first_quarter MMM Medicare payment for molecular diagnostics SENATE     0 1 2010-02-26T08:57:15.107000-05:00
907295 BATES & BYRNE, LLC f0503237-2fd3-4ebe-98d3-2b5ad51552a7 1T BATES & BYRNE, LLC 400359645 BUILDING INDUSTRY COALITION FOR ECONOMIC RECOVERY 2010 first_quarter HOU Homebuilder Industruy Difficulties       0 1 2010-02-26T10:28:21.343000-05:00
907296 BATES & BYRNE, LLC da04d660-c56f-430d-b16b-584f1120128b 1TY BATES & BYRNE, LLC 400359645 CALIFORNIA BUILDING INDUSTRY ASSOCIATION 2010 first_quarter           0 1 2010-02-26T10:35:24.293000-05:00
907297 BATES & BYRNE, LLC b7404746-c0bc-42f1-ad3f-ba9014392331 1TY BATES & BYRNE, LLC 400359645 TRUTH IN LABELING COALITION 2010 first_quarter           0 1 2010-02-26T10:38:25.247000-05:00
907298 NOSSAMAN LLP 3c097b8f-1aab-4354-aa60-f31570b058f7 1T NOSSAMAN LLP 29846 CAPITAL TECHNOLOGY GROUP INC 2010 first_quarter DEF FY 2010 Department of Defense Appropriations Act (H.R. 3326); Environmental cleanup; Single Platform Initiative for Efficient Energy. HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2010-03-01T10:06:34.763000-05:00
907299 NOSSAMAN LLP 3c097b8f-1aab-4354-aa60-f31570b058f7 1T NOSSAMAN LLP 29846 CAPITAL TECHNOLOGY GROUP INC 2010 first_quarter BUD FY 2010 Department of Defense Appropriations Act (H.R. 3326); Environmental cleanup; Single Platform Initiative for Efficient Energy. HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2010-03-01T10:06:34.763000-05:00
907300 NOSSAMAN LLP c27bd0f8-1f20-4b92-9361-2e702b07c541 1T NOSSAMAN LLP 29846 LOCAL INITIATIVES SUPPORT CORPORATION 2010 first_quarter LAW FY 2010 Commerce, Justice, Science and Related Agencies Appropriations Act (H.R. 2847); funding for community safety initiatives. HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-03-01T10:08:35.887000-05:00
907301 NOSSAMAN LLP c27bd0f8-1f20-4b92-9361-2e702b07c541 1T NOSSAMAN LLP 29846 LOCAL INITIATIVES SUPPORT CORPORATION 2010 first_quarter BUD FY 2010 Commerce, Justice, Science and Related Agencies Appropriations Act (H.R. 2847); funding for community safety initatives. HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-03-01T10:08:35.887000-05:00
907302 NOSSAMAN LLP 6d515aaf-fecf-4005-9eb5-65817601a7b8 1T NOSSAMAN LLP 29846 ROCKWELL COLLINS INC (FORMALLY INFORMATION TECHNOLOGY AND APPLICATION CO ) 2010 first_quarter DEF FY 2010 Department of Defense Appropriations (H.R. 3326); Satellite technology. HOUSE OF REPRESENTATIVES,SENATE 20000   0 1 2010-03-01T10:09:36.997000-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 1729.157ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API