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

40,147 rows where filing_period = "first_quarter" and filing_year = 2009 sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filing_type, is_termination, received_date (date)

issue_code >30

  • BUD 5,872
  • HCR 2,551
  • TAX 2,353
  • DEF 2,230
  • ENG 1,824
  • TRA 1,497
  • MMM 1,300
  • ENV 1,217
  • EDU 1,027
  • TRD 929
  • LBR 882
  • FIN 800
  • AGR 747
  • HOM 743
  • TEC 640
  • CPT 613
  • GOV 595
  • NAT 533
  • CAW 523
  • BAN 507
  • ECN 474
  • LAW 440
  • SCI 411
  • AVI 387
  • HOU 386
  • IMM 373
  • COM 363
  • FOR 362
  • IND 346
  • MED 329
  • …

filing_year 1

  • 2009 · 40,147 ✖

filing_period 1

  • first_quarter · 40,147 ✖
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
743475 CHRISTINE STABERG 274cb091-2ecb-43f4-a6da-9d10b89dc346 Q1 CHRISTINE STABERG 40006034 ST MARYS HOSPITAL AND REGIONAL MEDICAL CENTER 2009 first_quarter HCR Appropriations Health & Human Services, Dept of (HHS)     0 0 2009-01-02T11:05:07-05:00
743480 WILLIAM LEWIS 8225104f-df13-4d80-85c2-0c9d99456cdd 1T WILLIAM LEWIS 400297402 MR. WILLIAM LEWIS 2009 first_quarter IND None       0 1 2009-01-06T12:57:26-05:00
743483 LIEBMAN & ASSOCIATES, INC. f1ea626c-b7cf-4ae8-932d-18a2af46d70b 1TY LIEBMAN & ASSOCIATES, INC. 46585 DC POWER ARCHITECTURES LLC 2009 first_quarter           0 1 2009-01-07T10:27:33-05:00
743484 UNITED ELECTRICAL RADIO & MACHINE WORKERS OF AMERICA ec61c878-54ca-4418-bee6-bbfe49ca562a Q1 UNITED ELECTRICAL RADIO & MACHINE WORKERS OF AMERICA 39108 UNITED ELECTRICAL RADIO & MACHINE WORKERS OF AMERICA 2009 first_quarter LBR HR 676 HR 800 HOUSE OF REPRESENTATIVES,SENATE     0 0 2009-01-07T13:54:23-05:00
743495 WELCH RESOURCES, INC. ae5989b7-c43c-4ee6-a711-8f4177beb175 1T WELCH RESOURCES, INC. 83978 BNSF RAILWAY COMPANY 2009 first_quarter RRR Coordinate government permitting processes for BNSF with the Army Corps of Engineers. Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,SENATE     0 1 2009-01-12T17:37:55-05:00
743499 WINSTEAD PC 4a00ef40-f4d4-4aa0-bb48-851e209203bc 1@Y WINSTEAD PC 42741 NATIONAL TURFGRASS EVALUATION PROGRAM 2009 first_quarter       10000   0 1 2009-01-14T13:49:52-05:00
743502 LIEBMAN & ASSOCIATES, INC. f33dffa7-efd7-4dcf-aa91-de7793753d5c 1TY LIEBMAN & ASSOCIATES, INC. 46585 AERONET INC (FORMERLY KR WINDPOWER INC ) 2009 first_quarter           0 1 2009-01-15T14:01:30-05:00
743513 BUCHANAN INGERSOLL & ROONEY PC 36614433-a400-42d1-a7ff-d2a123f43bf2 Q1 BUCHANAN INGERSOLL & ROONEY PC 55291 44 HARRISBURG HOTEL, LLC 2009 first_quarter TAX New Market Tax Program expansion HOUSE OF REPRESENTATIVES,SENATE 15000   0 0 2009-01-15T16:31:56-05:00
743521 CAPITOL ASSOCIATES, INC. e452c91b-dab2-438b-aadd-4d138d6be768 1T CAPITOL ASSOCIATES, INC. 8101 NORTHWESTERN MEMORIAL HOSPITAL (NMH) 2009 first_quarter BUD S. 3230 - Labor, Health and Human Services Appropriations Subcommittee Bill, Title II, targeted funding through the HRSA Account H.R. 7110: Job Creation and Unemployment Relief Act of 2008, track health funding. S. 3604 and S. 3689: Economic Recovery Act, 2008, track health funding. Army, Dept of (Other),Centers For Disease Control & Prevention (CDC),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,SENATE 30000   0 1 2009-01-16T15:43:17-05:00
743522 CAPITOL ASSOCIATES, INC. b6787c97-67d5-4c31-9374-864fe57c21fe 1T CAPITOL ASSOCIATES, INC. 8101 CHESTER COUNTY HOSPITAL 2009 first_quarter BUD S. 3230: Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act for 2009, Title II, targeted funding through the Health Resources and Services Administration. HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2009-01-16T15:44:30-05:00
743523 CAPITOL ASSOCIATES, INC. e105c3cd-5c8b-4310-a043-36e3ace06d8e 1T CAPITOL ASSOCIATES, INC. 8101 GREYSTONE GROUP LLC ON BEHALF OF NATIONAL COUNCIL OF SOCIAL SECURITY MANAGMENT 2009 first_quarter BUD S.3230, Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act for 2009, Title II, funding for Social Security Administration Limitation on Administrative Expenses. H.R. 7110: Job Creation and Unemployment Relief Act of 2008, track potential supplemental funding for SSA Administrative Expenses. S. 3604 and S. 3689: Economic Recovery Act, 2008, track potential supplemental funding for SSA Administrative Expenses HOUSE OF REPRESENTATIVES,SENATE     0 1 2009-01-16T15:49:08-05:00
743524 CAPITOL ASSOCIATES, INC. 74f70d36-89a1-4334-a753-cdd94e0f0be4 1T CAPITOL ASSOCIATES, INC. 8101 GREYSTONE GROUP LLC ON BEHALF OF UNIVERSITY OF NORTH DAKOTA 2009 first_quarter BUD S.3230, Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act for 2009, Title II, targeted funding through Health Resources and Services Administration; Title I, targeted funding through Labor, Employment Trainining Administration ; Title III, targeted funding through the Fund for Innovation in Postsecondary Education. S.3289, Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations Act, 2009, Title I, targeted funding within USDA S. 3182 , Commerce, Justice, Science, and Related Agencies Appropriations Act, 2009, Title IV, targeted funding within NASA, Earth Science Applications; Title II, targeted funding within the Office of Justice Programs. S.3258, Energy and Water Development and Related Agencies Appropriations Act, 2009, Title III, targeted funding within Fossil Energy Research and Development , Biomedical Sciences and Office of Energy Efficiency and Renewble Energy. Department of the Interior, Environment, and Related Agencies Appropriations Act, 2009, Title III, targeted funding within the Indian Health Services. S.3288, Making appropriations for the Department of State, foreign operations, and related programs for the fiscal year ending September 30, 2009, Title I, Educational and Cultural Exchange Programs H.R. 7110: Job Creation and Unemployment Relief Act of 2008. S. 3604 and S. 3689: Economic Recovery Act, 2008. HOUSE OF REPRESENTATIVES,SENATE     0 1 2009-01-16T15:50:10-05:00
743525 CAPITOL ASSOCIATES, INC. 3ac3d85f-5f03-46d6-9d06-d191e728e07d 1T CAPITOL ASSOCIATES, INC. 8101 NEW YORK UNIVERSITY MEDICAL CENTER 2009 first_quarter BUD S. 3230 - Labor, Health and Human Services Appropriations Subcommittee Bill, Title II, specifically targeted funding through the HRSA Account. H.R. 7110: Job Creation and Unemployment Relief Act of 2008, track funding for Medicaid and NIH. S. 3604 and S. 3689: Economic Recovery Act, 2008, track funding for Medicaid and NIH. Centers For Disease Control & Prevention (CDC),Defense, Dept of (DOD),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE 40000   0 1 2009-01-16T15:51:32-05:00
743526 CAPITOL ASSOCIATES, INC. 0ae74390-e42c-4dcd-b785-60ab8f8294d1 1T CAPITOL ASSOCIATES, INC. 8101 AUTISM SPEAKS 2009 first_quarter BUD S. 3230 - Labor, Health and Human Services Appropriations Subcommittee Bill, Title II, specifically targeted funding through the CDC's Developmental Disabilities Surveillance and Research program; the HHS's Secretary's Account; and, the NIH, specifically the NIMH all for autism research. H.R. 7110: Job Creation and Unemployment Relief Act of 2008, track funding for NIH. S. 3604 and S. 3689: Economic Recovery Act, 2008, track funding for NIH. Centers For Disease Control & Prevention (CDC),Defense, Dept of (DOD),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Institute of Mental Health (NIMH),Natl Institutes of Health (NIH),SENATE 20000   0 1 2009-01-16T15:52:35-05:00
743532 I STREET ADVOCATES da0f8d32-de87-43d5-a882-f8e1bfa1d215 1TY I STREET ADVOCATES 51753 POST ACUTE AND LONG TERM CARE MEDICINE FORMERLY AMDA 2009 first_quarter           0 1 2009-01-17T04:54:42-05:00
743533 ACADEMY OF INTERNET BROADCASTERS 057a9780-f249-4352-912d-e0b564cb0520 Q1Y ACADEMY OF INTERNET BROADCASTERS 400296392 ACADEMY OF INTERNET BROADCASTERS 2009 first_quarter           0 0 2009-01-17T14:50:18-05:00
743610 AMERICAN FOUNDATION FOR THE BLIND 40e6a55f-0084-4781-9dd6-fda2b44a56c5 Q1Y AMERICAN FOUNDATION FOR THE BLIND 2401 AMERICAN FOUNDATION FOR THE BLIND 2009 first_quarter           0 0 2009-01-22T08:01:03-05:00
743613 PATRICIA LYNCH ASSOCIATES 5c3d9b22-2d88-42fb-b79c-4ad1a1b002af 1TY PATRICIA LYNCH ASSOCIATES 76616 INSCAP MANAGEMENT LLC 2009 first_quarter           0 1 2009-01-22T13:31:32-05:00
743614 NATIONAL COALITION OF ABORTION PROVIDERS 36c1cdb6-786c-4ca1-ae65-997f4bbb548e Q1Y NATIONAL COALITION OF ABORTION PROVIDERS 27445 NATL COALITION OF ABORTION PROVIDERS 2009 first_quarter           0 0 2009-01-22T13:59:35-05:00
743615 SQUIRE SANDERS PUBLIC ADVOCACY, LLC 089e40de-fd8a-40ac-b211-ee114ed9c478 1T SQUIRE SANDERS PUBLIC ADVOCACY, LLC 318072 JAMES DELANEY 2009 first_quarter GOV Attempt to secure a Presidential pardon for John Delaney. HOUSE OF REPRESENTATIVES,SENATE,Vice President of the U.S.     0 1 2009-01-23T09:37:44-05:00
743616 CAPITOL ASSOCIATES, INC. 32dafa48-945c-4dc9-a053-bcd39bf37bf7 1T CAPITOL ASSOCIATES, INC. 8101 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 2009 first_quarter BUD S. 3230: Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act for 2009, Title II, all provisions relating to community health centers. H.R. 7110: Job Creation and Unemployment Relief Act of 2008, provisions relating to community health centers. S. 3604 and S. 3689: Economic Recovery Act, 2008, provisions relating to commuity health centers. HOUSE OF REPRESENTATIVES,SENATE 20000   0 1 2009-01-23T11:44:18-05:00
743617 CAPITOL ASSOCIATES, INC. 32dafa48-945c-4dc9-a053-bcd39bf37bf7 1T CAPITOL ASSOCIATES, INC. 8101 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 2009 first_quarter HCR H.R. 1343 - Health Centers Renewal Act of 2007. H.R. 1518 - To allow employees of Federally-qualified health centers to obtain health coverage under chapter 89 of title 5. S. 2186 - Community Health Center Employee Health Coverage Act of 2007. H.R. 2897/S. 2188 - To amend title XVIII of the Social Security Act to establish a prospective payment system instead of the reasonable cost-based reimbursement method for Medicare-covered services provided by Federally qualified health centers and to expand the scope of such covered services to account for expansions in the scope of services provided by Federally qualified health centers since the inclusion of such services for coverage under the Medicare Program. HOUSE OF REPRESENTATIVES,SENATE 20000   0 1 2009-01-23T11:44:18-05:00
743618 MINTZ LEVIN COHN FERRIS GLOVSKY AND POPEO, P.C. 4de8e047-3ca6-4692-87dc-6412e3ca644c Q1 MINTZ LEVIN COHN FERRIS GLOVSKY AND POPEO, P.C. 25498 NAHEFFA (FORMERLY KNOWN AS NAHEFA) 2009 first_quarter TAX US House of Representatives US Senate IRS HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE 30750   0 0 2009-01-23T11:54:27-05:00
743619 CAPITOL ASSOCIATES, INC. 78f4b188-4596-408b-a401-637b334942e6 1T CAPITOL ASSOCIATES, INC. 8101 NATIONAL FEDERATION OF HIGH SCHOOL ASSOCIATIONS 2009 first_quarter SPO S. 1470 Drug Free Varsity Sports Act H.R. 901 High School Athletics Accountability Act of 2007 S. 518 High School Sports Information Act of 2007 H.R. 6281 High School Sports Anti-Drug Act Centers For Disease Control & Prevention (CDC),Consumer Product Safety Commission (CPSC),HOUSE OF REPRESENTATIVES,Natl Endowment for the Arts,Natl Endowment for the Humanities,SENATE 10000   0 1 2009-01-23T12:05:22-05:00
743620 CAPITOL ASSOCIATES, INC. f35ce288-e637-465c-982f-736c83aaee7c 1T CAPITOL ASSOCIATES, INC. 8101 NATURAL PRODUCTS ASSOCIATION 2009 first_quarter HCR S. 770: Food Stamp Vitamin and Mineral Improvement Act; entire bill as it relates to dietary supplements. S. 771/ H.R. 1363: The Child Nutrition Promotion and School Lunch Protection Act; entire bill as it relates to dietary supplements. S. 762/H.R. 1249: A bill to include dehydroepiandrosterone as an anabolic steroid; entire bill as it relates to dietary supplements. H.R. 1107: Dietary Supplement and Healthy Meal Replacement Tax Parity Act; entire bill as it relates to dietary supplements. S. 2470: Dehydroepiandrosterone Abuse Reduction Act of 2007; entire bill as it relates to dietary supplements. H.R. 3610: Food and Drug Import Safety Act of 2007; all provisions affecting the dietary supplement industry. S. 1274/H.R. 2108: Human and Pet Food Safety Act of 2007; all provisions affecting the dietary supplement industry. S. 1776: Imported Food Security Act of 2007; all provisions affecting the dietary supplement industry. S. 2245: Food Safety Authority Modernization Act; all provisions affecting the dietary supplement industry. H.R. 3937: Food Import Safety Act of 2007; all provisions affecting the dietary supplement industry. H.R. 3624: Consumer Food Safety Act of 2007; all provisions affecting the dietary supplement industry. S. 654/H.R. 1148: Safe Food Act of 2007; all provisions affecting the dietary supplement industry. H.R. 5904: Safe Food Enforcement, Assessment, Standards and Targeting Act of 2008; all provisions affecting the dietary supplement industry. S. 3385: FDA Food Safety Modernization Act; entire bill as it relates to dietary supplements. Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE 20000   0 1 2009-01-23T12:19:27-05:00
743621 CAPITOL ASSOCIATES, INC. f35ce288-e637-465c-982f-736c83aaee7c 1T CAPITOL ASSOCIATES, INC. 8101 NATURAL PRODUCTS ASSOCIATION 2009 first_quarter BUD S. 3230: Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act for 2009, Title II, all provisions relating to dietary supplements, and complementary and alternative medicine. S. 3289: Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations Act for 2009, all provisions relating to dietary supplements. Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE 20000   0 1 2009-01-23T12:19:27-05:00
743622 CAPITOL ASSOCIATES, INC. 2d770cf9-030f-4422-9831-5d57830cad0d 1T CAPITOL ASSOCIATES, INC. 8101 SUSQUEHANNA UNIVERSITY 2009 first_quarter BUD S. 3230: Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act for 2009, Title III, targeted funding through the Fund for the Improvement of Postsecondary Education. S. 3258/H.R. 7324: Energy and Water Development and Related Agencies Appropriations Act, 2009, targeted funding through the Office of Science. HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2009-01-23T12:42:35-05:00
743623 GORDON WALGREN CONSULTING SERVICES 9773af43-2250-445a-b67e-64617e7316e0 Q1Y GORDON WALGREN CONSULTING SERVICES 62676 PORT OF BREMERTON 2009 first_quarter           0 0 2009-01-25T15:59:11-05:00
743624 MINTZ LEVIN COHN FERRIS GLOVSKY AND POPEO, P.C. 399d2808-6eed-4387-b6a2-16477ecd9951 Q1 MINTZ LEVIN COHN FERRIS GLOVSKY AND POPEO, P.C. 25498 ASSOCIATION OF HOME APPLIANCE MANUFACTURERS (AHAM) 2009 first_quarter MAN Senate, House of Representatives, Department of Energy, Consumer Product Safety Commission and Environmental Protection Agency Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE 49140   0 0 2009-01-26T09:43:49-05:00
743625 CAPITOL ASSOCIATES, INC. 857ead50-8b72-4a1c-ab4c-b6be4fad9343 1T CAPITOL ASSOCIATES, INC. 8101 NEUROFIBROMATOSIS INC NORTHEAST 2009 first_quarter BUD S. 3230: Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act for 2009, Title II, provisions relating to the National Institutes of Health. H.R. 7110: Job Creation and Unemployment Relief Act of 2008, all provisions relating to medical research funding. S. 3604 and S. 3689: Economic Recovery Act, 2008, all provisions relating to medical research funding. Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE 20000   0 1 2009-01-26T15:52:24-05:00
743626 PATRICIA LYNCH ASSOCIATES bb4bae18-b596-40be-9ae9-af5f73c35dec 1TY PATRICIA LYNCH ASSOCIATES 76616 DELAWARE NORTH COMPANIES INC 2009 first_quarter           0 1 2009-01-26T16:13:26-05:00
743627 CAPITOL ASSOCIATES, INC. eb1cb285-cf27-4337-9123-b7af69dd3b1e 1T CAPITOL ASSOCIATES, INC. 8101 ASSOCIATION OF UNIVERSITY PROGRAMS IN OCCUPATIONAL HEALTH AND SAFETY 2009 first_quarter BUD S. 3230 Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act for 2009, Title II, provisions relating to occupational health and safety. Centers For Disease Control & Prevention (CDC),HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2009-01-27T15:05:45-05:00
743629 MCDERMOTT WILL & SCHULTE LLP 10d82ad7-ae8c-4ee9-ad98-e9cd0bdab74f 1TY MCDERMOTT WILL & SCHULTE LLP 24338 COOKEVILLE REGIONAL MEDICAL CENTER 2009 first_quarter           0 1 2009-01-28T09:13:12-05:00
743630 CAPITOL ASSOCIATES, INC. b8dd3415-6a39-4e46-ae5d-8b9badc88be3 1T CAPITOL ASSOCIATES, INC. 8101 TEXAS NF FOUNDATION 2009 first_quarter BUD S. 3230: Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act for 2009, Title II, provisions relating to the National Institutes of Health. H.R. 7110: Job Creation and Unemployment Relief Act of 2008, all provisions relating to medical research funding. S. 3604 and S. 3689: Economic Recovery Act, 2008, all provisions relating to medical research funding. Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE     0 1 2009-01-29T11:27:34-05:00
743631 CAPITOL ASSOCIATES, INC. 3dff1b0a-4042-4237-9990-ce8c4448027d 1T CAPITOL ASSOCIATES, INC. 8101 MELANOMA RESEARCH FOUNDATION 2009 first_quarter BUD S. 3230: Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act for 2009, Title II, provisions relating to cancer research and skin cancer prevention. H.R. 7110: Job Creation and Unemployment Relief Act of 2008, all provisions relating to medical research funding. S. 3604 and S. 3689: Economic Recovery Act, 2008, all provisions relating to medical research funding. HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE 20000   0 1 2009-01-29T13:34:47-05:00
743633 GRAYROBINSON, P.A. 5ee385eb-4d11-4e70-b508-3f061ede7453 Q1Y GRAYROBINSON, P.A. 54186 ACCREDITED SURETY & CASUALTY CO INC 2009 first_quarter           0 0 2009-01-29T17:13:21-05:00
743634 ASSN. OF STATE AND TERRITORIAL HEALTH OFFICIALS 5c595fee-806a-4ebc-a25b-1e8046a92013 Q1 ASSN. OF STATE AND TERRITORIAL HEALTH OFFICIALS 4711 ASSN. OF STATE AND TERRITORIAL HEALTH OFFICIALS 2009 first_quarter HCR FY09 Labor HHS and Education Appropriations Bill HOUSE OF REPRESENTATIVES,SENATE     0 0 2009-01-29T17:47:27-05:00
743639 BOOK HILL PARTNERS fa015d50-1f7a-42ef-91d7-ee35633967f9 1TY BOOK HILL PARTNERS 40041330 JEFFERSON COUNTY 2009 first_quarter           0 1 2009-01-30T18:25:57-05:00
743640 CUNEO GILBERT & LADUCA 9d1d7a24-a201-4919-acd8-e67c6daa9da9 1T CUNEO GILBERT & LADUCA 11481 AMERICAN ASSOCIATION FOR JUSTICE 2009 first_quarter FIN No lobbying this session       0 1 2009-02-02T11:41:00-05:00
743641 MARTIN MORRIS f31dfa48-c3de-4f8c-92a7-cdbb3c329016 1T MARTIN MORRIS 40038317 STREAMLINED SALES TAX GOVERNING BOARD 2009 first_quarter TAX Seek federal legislation to make the collection of state sales taxes mandatory when goods are sold from an out of state seller. HOUSE OF REPRESENTATIVES,SENATE     0 1 2009-02-02T13:27:30-05:00
743642 BINGHAM MCCUTCHEN LLP a1356361-4e62-46f9-bfe4-aaf04e2202b8 1T BINGHAM MCCUTCHEN LLP 51560 CHARLES SCHWAB & CO INC 2009 first_quarter FIN Legislation involving Securities and Exchange broker-dealer issues Securities & Exchange Commission (SEC)     0 1 2009-02-02T16:26:39-05:00
743643 CAPITOL ASSOCIATES, INC. b39e268e-5098-4652-b110-3abe4fcbd3c3 1T CAPITOL ASSOCIATES, INC. 8101 NEUROFIBROMATOSIS INC MIDWEST 2009 first_quarter BUD S. 3230: Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act for 2009, Title II, provisions relating to the National Institutes of Health. H.R. 7110: Job Creation and Unemployment Relief Act of 2008, all provisions relating to medical research funding. S. 3604 and S. 3689: Economic Recovery Act, 2008, all provisions relating to medical research funding. Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE 10000   0 1 2009-02-02T17:24:05-05:00
743645 MARTIN MORRIS 6e1371b7-d035-42e3-83d9-7b2b51d51e48 1T MARTIN MORRIS 40038317 STREAMLINED SALES TAX GOVERNING BOARD 2009 first_quarter TAX Seek enactment of legislation to require the collection of state sales taxes from out-of-state sellers. HOUSE OF REPRESENTATIVES,SENATE     0 1 2009-02-03T09:54:45-05:00
743646 LEWIS-BURKE ASSOCIATES, LLC f661dee9-ae16-401c-8c9e-069d166c559b 1TY LEWIS-BURKE ASSOCIATES, LLC 22781 SEA GRANT ASSOCIATION 2009 first_quarter       30000   0 1 2009-02-03T12:45:05-05:00
743647 CAPITOL ASSOCIATES, INC. a65c99fe-7251-49f6-98af-393a24607b1e 1T CAPITOL ASSOCIATES, INC. 8101 COLLEGE ON PROBLEMS OF DRUG DEPENDENCE 2009 first_quarter BUD Request for report language in S. 3230 FY 2009 Labor, Health and Human Services Appropriations Bill, Title II, specifically in the bill report under the National Institute on Drug Abuse H.R. 7110: Job Creation and Unemployment Relief Act of 2008, track funding for NIH. S. 3604 and S. 3689: Economic Recovery Act, 2008, track funding for NIH. Defense, Dept of (DOD),Drug Court Program Office,Executive Office of the President (EOP),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),Office of Natl Drug Control Policy (NDCP),SENATE,Substance Abuse & Mental Health Services Administration (SAMHSA) 20000   0 1 2009-02-03T14:55:21-05:00
743648 CAPITOL ASSOCIATES, INC. 7cc14f0d-095f-44ba-880d-cd98fbbf0bfe 1T CAPITOL ASSOCIATES, INC. 8101 WILLS EYE HEALTH SYSTEM 2009 first_quarter BUD S. 3230: Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act for 2009, Title II, targeted funding through the Health Resources and Services Administration. H.R. 7110: Job Creation and Unemployment Relief Act of 2008, targeted funding. S. 3604 and S. 3689: Economic Recovery Act, 2008, targeted funding. HOUSE OF REPRESENTATIVES,SENATE 30000   0 1 2009-02-03T15:05:25-05:00
743651 LOGAN ENTERPRISE INC. 873d7223-5724-4e14-a15c-02efc0ed1c4f 1TY LOGAN ENTERPRISE INC. 40033287 SOLIDICA 2009 first_quarter           0 1 2009-02-03T16:05:24-05:00
743652 CAPITOL ASSOCIATES, INC. 76430f40-9e5e-4b73-9dfe-0c240f89451d 1T CAPITOL ASSOCIATES, INC. 8101 NEW YORK BOTANICAL GARDEN 2009 first_quarter BUD S. 3289 - Agriculture Appropriations Subcommittee Bill, specifically targeted funding through the Office of the Under Secretary for Research, Education, and Economics, ARS; ; Interior Appropriations Subcommittee Bill, specifically targeted funding through the State and Tribal Assistant Grants. S. 3230 - Labor, Health and Human Services Appropriations Subcommittee Bill, Title II, targeted funding through the Institute of Museum and Library Services Transportation Appropriations Subcommittee Bill, specifically targeted funding through the Intermodal Infrastructure, Enhancement Program H.R. 7110: Job Creation and Unemployment Relief Act of 2008, general. S. 3604 and S. 3689: Economic Recovery Act, 2008, general. Agriculture, Dept of (USDA),Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Institute of Museum and Library Services (IMLS),Interior, Dept of (DOI),SENATE,Transportation, Dept of (DOT) 20000   0 1 2009-02-04T09:19:56-05:00
743654 PAMELA RAY a1a62e4f-a4a8-4a12-98e8-75dd9b066c39 1T PAMELA RAY 32761 DARK ELEGY 2009 first_quarter ART None       0 1 2009-02-04T10:09:55-05:00
743655 CAPITOL ASSOCIATES, INC. 9ae4c82a-f135-4e63-9b6b-347a8bf2d6bb 1T CAPITOL ASSOCIATES, INC. 8101 FROM THE TOP 2009 first_quarter BUD S. 3230: Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act for 2009, Title III, targeted funding through the Fund for Innovation in Education. HOUSE OF REPRESENTATIVES,SENATE 20000   0 1 2009-02-04T10:56:59-05:00
743656 MALONEY GOVERNMENT RELATIONS, LLC 825861a7-8273-430e-8664-244f143b92e2 1TY MALONEY GOVERNMENT RELATIONS, LLC 315991 THE HAROLD FORD GROUP, LLC 2009 first_quarter           0 1 2009-02-04T13:39:13-05:00
743657 MALONEY GOVERNMENT RELATIONS, LLC 87840b4f-c4ac-4b85-bdcf-8d53a2b30395 1TY MALONEY GOVERNMENT RELATIONS, LLC 315991 FRANKLIN D. RAINES 2009 first_quarter           0 1 2009-02-04T13:40:14-05:00
743658 ARNOLD & PORTER KAYE SCHOLER LLP 48b0fed0-c5aa-4bb3-a5a3-381f70e98eb7 1T ARNOLD & PORTER KAYE SCHOLER LLP 4301 CONSORTIUM FOR PLANT BIOTECHNOLOGY 2009 first_quarter BUD Issues related to university-based research HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2009-02-05T09:40:48-05:00
743659 STEVENS & LEE 185a7884-0140-4801-9688-ccef5d94604f 1TY STEVENS & LEE 295931 TECHNOLGOY COUNCIL OF CENTRAL PENNSYLVANIA 2009 first_quarter           0 1 2009-02-05T16:01:23-05:00
743660 STEVENS & LEE a39d44b5-ac5a-446c-8274-0be760b3d4d8 1TY STEVENS & LEE 295931 LEHIGH VALLEY HOSPITAL & HEALTH NETWORK INC 2009 first_quarter           0 1 2009-02-05T16:17:30-05:00
743661 LIEBMAN & ASSOCIATES, INC. 86a8a06f-5a52-4e2e-93b0-21485fa14ee6 1T LIEBMAN & ASSOCIATES, INC. 46585 ROLLS-ROYCE NORTH AMERICA 2009 first_quarter ENG Clean and sustainable energy technology research, development and demonstration Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE     0 1 2009-02-05T17:32:39-05:00
743662 LIEBMAN & ASSOCIATES, INC. 86a8a06f-5a52-4e2e-93b0-21485fa14ee6 1T LIEBMAN & ASSOCIATES, INC. 46585 ROLLS-ROYCE NORTH AMERICA 2009 first_quarter TAX Energy Tax Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE     0 1 2009-02-05T17:32:39-05:00
743664 BINGHAM MCCUTCHEN LLP 749f9361-63b7-410f-85b2-5e1347e35749 1T BINGHAM MCCUTCHEN LLP 51560 BINGHAM CONSULTING GROUP LLC (ON BEHALF OF THE PRINCE GROUP) 2009 first_quarter DEF Matters pertaining to private security contractors. HOUSE OF REPRESENTATIVES,SENATE 20000   0 1 2009-02-06T15:07:27-05:00
743666 BRACEWELL LLP 62b483f5-551d-45e7-8e25-a606d006c6a8 1T BRACEWELL LLP 6837 THAI UNION GROUP PCL 2009 first_quarter LBR Issues relating to wages and economic sustainability in American Samoa HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),SENATE 10000   0 1 2009-02-07T13:27:58-05:00
743667 BRACEWELL LLP 62b483f5-551d-45e7-8e25-a606d006c6a8 1T BRACEWELL LLP 6837 THAI UNION GROUP PCL 2009 first_quarter ECN Issues relating to economic development in American Samoa HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),SENATE 10000   0 1 2009-02-07T13:27:58-05:00
743668 BRACEWELL LLP 62b483f5-551d-45e7-8e25-a606d006c6a8 1T BRACEWELL LLP 6837 THAI UNION GROUP PCL 2009 first_quarter TAX Issues relating to tax treatment of businesses in American Samoa HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),SENATE 10000   0 1 2009-02-07T13:27:58-05:00
743669 KILPATRICK TOWNSEND AND STOCKTON 748c53e4-5035-4ecd-95d8-a96edef8cf8c Q1 KILPATRICK TOWNSEND AND STOCKTON 21563 AGUA CALIENTE BAND OF CAHUILLA INDIANS 2009 first_quarter IND General Native American affairs. HOUSE OF REPRESENTATIVES,SENATE     0 0 2009-02-09T13:11:19-05:00
743670 INNOVATIVE FEDERAL STRATEGIES, LLC 88c3fa1d-c30d-45f8-af44-23fb493ce797 1T INNOVATIVE FEDERAL STRATEGIES, LLC 10800 MOUNTAINTOP TECHNOLOGIES INC 2009 first_quarter BUD HR ____, Department of Defense Appropriations Act, 2010, Title II, all provisions relating to distance learning and training; and Title IV, all provisions relating to emergency response, physical security, training, aircraft maintenance systems, ground support systems, and process improvement.   10000   0 1 2009-02-10T09:55:18-05:00
743671 INNOVATIVE FEDERAL STRATEGIES, LLC 60c59d58-8449-4c9f-afa1-965d05d94100 1T INNOVATIVE FEDERAL STRATEGIES, LLC 10800 COALSTAR INDUSTRIES, INCORPORATED 2009 first_quarter ENG No lobbying issues during this reporting period.       0 1 2009-02-10T09:56:20-05:00
743672 INNOVATIVE FEDERAL STRATEGIES, LLC 60c59d58-8449-4c9f-afa1-965d05d94100 1T INNOVATIVE FEDERAL STRATEGIES, LLC 10800 COALSTAR INDUSTRIES, INCORPORATED 2009 first_quarter DEF No lobbying issues during this reporting period.       0 1 2009-02-10T09:56:20-05:00
743673 INNOVATIVE FEDERAL STRATEGIES, LLC 60c59d58-8449-4c9f-afa1-965d05d94100 1T INNOVATIVE FEDERAL STRATEGIES, LLC 10800 COALSTAR INDUSTRIES, INCORPORATED 2009 first_quarter BUD No lobbying issues during this reporting period.       0 1 2009-02-10T09:56:20-05:00
743674 CAPITOL SOLUTIONS 811317ab-c007-4288-89ad-eea48202e501 1T CAPITOL SOLUTIONS 47108 THE ALLIANCE FOR CONNECTING FIRST RESPONDERS 2009 first_quarter HOM Federal funding and policies to support broadband and IP-based networking technologies and services for federal, state and local first responders and emergency management personnel. HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE 10000   0 1 2009-02-10T10:41:03-05:00
743675 CAPITOL SOLUTIONS 811317ab-c007-4288-89ad-eea48202e501 1T CAPITOL SOLUTIONS 47108 THE ALLIANCE FOR CONNECTING FIRST RESPONDERS 2009 first_quarter LAW Federal funding and policies to support broadband and IP-based networking technologies and services for federal, state and local first responders and emergency management personnel. HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE 10000   0 1 2009-02-10T10:41:03-05:00
743676 CAPITOL SOLUTIONS 811317ab-c007-4288-89ad-eea48202e501 1T CAPITOL SOLUTIONS 47108 THE ALLIANCE FOR CONNECTING FIRST RESPONDERS 2009 first_quarter COM Federal funding and policies to support broadband and IP-based networking technologies and services for federal, state and local first responders and emergency management personnel. HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE 10000   0 1 2009-02-10T10:41:03-05:00
743677 CAPITOL SOLUTIONS 811317ab-c007-4288-89ad-eea48202e501 1T CAPITOL SOLUTIONS 47108 THE ALLIANCE FOR CONNECTING FIRST RESPONDERS 2009 first_quarter BUD Federal funding and policies to support broadband and IP-based networking technologies and services for federal, state and local first responders and emergency management personnel. H.R. 1, Title VI HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE 10000   0 1 2009-02-10T10:41:03-05:00
743678 LAWLER, METZGER, MILKMAN & KEENEY, LLC d47f9561-6596-4a96-9956-d4d3b1b100e5 1T LAWLER, METZGER, MILKMAN & KEENEY, LLC 22278 BROTHERHOOD OF MAINTENANCE WAY EMPLOYEES 2009 first_quarter TRA Railroad collective bargaining and Amtrak. HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),White House Office     0 1 2009-02-10T11:23:24-05:00
743679 BINGHAM CONSULTING GROUP LLC c30be1e8-a499-4799-b7d1-e373272e941e 1T BINGHAM CONSULTING GROUP LLC 73910 PRINCE GROUP LLC 2009 first_quarter DEF Matters pertaining to private security contractors. HOUSE OF REPRESENTATIVES,SENATE 20000   0 1 2009-02-10T14:58:30-05:00
743681 RUBICON ADVISORS, LLC c15a1a3d-82cb-416d-ab9d-0ae3f39c4b25 1A RUBICON ADVISORS, LLC 315091 GILEAD SCIENCES 2009 first_quarter PHA H.R. 822, H.R. 1943, H.R. 6114, S-2969   75000   0 0 2009-02-10T20:08:50-05:00
743683 AMERICAN BUSINESS DEVELOPMENT GROUP 453c50ec-9e26-4822-bf57-d547d74ec742 Q1 AMERICAN BUSINESS DEVELOPMENT GROUP 91353 COUNTY OF GREENVILLE 2009 first_quarter TRA FY10 Transportation Appropriations bill, FY10 Interior and Environment Appropriations bill, FY10 Homeland Security Appropriations bill, FY10 Commerce Justice State Appropriations bill 1) Fairview Street/I-385 2) Salters Road 3) Water Lines 4) Stormwater Mangement 5) Joint Dispatch Center Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2009-02-12T09:04:00-05:00
743684 KSCW, INC. 87d531e4-a02c-4a87-a251-c741e7cd286b 1T KSCW, INC. 21596 ADVERTISING PHOTOGRAPHERS OF AMERICA 2009 first_quarter CPT Copyright/Patent oversight issues in the House and Senate Judiciary and Small Business Committees.       0 1 2009-02-12T13:07:28-05:00
743685 KSCW, INC. a5a31f10-3017-43e6-addb-b60587086a89 1T KSCW, INC. 21596 ARTIST RIGHTS SOCIETY 2009 first_quarter CPT Copyright/Patent oversight issues       0 1 2009-02-12T13:09:29-05:00
743686 KSCW, INC. 7ef0e295-718e-4587-b672-a37d3271e73d 1T KSCW, INC. 21596 ILLUSTRATOR'S PARTNERSHIP OF AMERICA 2009 first_quarter CPT Copyright/Patent oversight issues       0 1 2009-02-12T13:11:30-05:00
743687 WILLIAM CUNNINGHAM acc0606d-3024-4ec2-8845-4f42a1e2f57d 1T WILLIAM CUNNINGHAM 400316480 BERKSHIRE THEATRE FESTIVAL 2009 first_quarter ART Advocation of the arts HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2009-02-12T14:09:48-05:00
743688 STEVENS & LEE 283f70b1-2684-4b21-8437-de96045c235a 1TY STEVENS & LEE 295931 CARPENTER TECHNOLOGY CORPORATION 2009 first_quarter           0 1 2009-02-12T16:00:58-05:00
743689 CAPITOL TAX PARTNERS, LLP 5e6e275d-e0d8-4ab5-ad49-60ccf5a14365 1TY CAPITOL TAX PARTNERS, LLP 65976 PUDGET SOUND ENERGY 2009 first_quarter           0 1 2009-02-12T16:30:50-05:00
743690 MR. THAD HUGULEY 50eb468b-3443-412f-8470-54d6a0da5b6b 1T MR. THAD HUGULEY 313750 ENVIRONMENTAL DEFENSE ACTION FUND 2009 first_quarter ENV Climate Change HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2009-02-13T11:33:30-05:00
743691 ROBERTI ASSOCIATES GLOBAL, LLC FORMERLY KNOWN AS VAR II, LLC 3c1e8dd9-9418-4c6d-b2e7-4c7c1eaef5ed 1TY ROBERTI ASSOCIATES GLOBAL, LLC FORMERLY KNOWN AS VAR II, LLC 308013 CITIGROUP MANAGEMENT CORPORATION 2009 first_quarter           0 1 2009-02-14T11:36:16-05:00
743692 ROBERTI ASSOCIATES GLOBAL, LLC FORMERLY KNOWN AS VAR II, LLC 12cc95c7-f638-451d-869d-06a4c8730c73 1TY ROBERTI ASSOCIATES GLOBAL, LLC FORMERLY KNOWN AS VAR II, LLC 308013 CONCORD ASSOCIATES, LP 2009 first_quarter       20000   0 1 2009-02-14T11:49:17-05:00
743693 ROBERTI ASSOCIATES GLOBAL, LLC FORMERLY KNOWN AS VAR II, LLC 77a38603-be2f-4c20-b4fb-04f7a4660d0c 1TY ROBERTI ASSOCIATES GLOBAL, LLC FORMERLY KNOWN AS VAR II, LLC 308013 ORACLE USA INC 2009 first_quarter       80000   0 1 2009-02-14T11:56:18-05:00
743694 ROBERTI ASSOCIATES GLOBAL, LLC FORMERLY KNOWN AS VAR II, LLC 9278334b-d4bc-447f-8be0-371efcdeab63 1TY ROBERTI ASSOCIATES GLOBAL, LLC FORMERLY KNOWN AS VAR II, LLC 308013 UNITED PARCEL SERVICE 2009 first_quarter           0 1 2009-02-14T12:01:18-05:00
743695 ROBERTI ASSOCIATES 9c2803a4-0393-425e-a392-1678055a8685 1TY ROBERTI ASSOCIATES 315513 AT&T SERVICES, INC. 2009 first_quarter           0 1 2009-02-14T12:09:19-05:00
743696 AUTHENTEC INC. c69b4870-35f4-4ec8-b62a-2033f415de13 1T AUTHENTEC INC. 314090 AUTHENTEC INC 2009 first_quarter CPI Promotion of commercial off-the-shelf embedded biometric security technology for various government applications. HOUSE OF REPRESENTATIVES,SENATE     0 1 2009-02-16T13:16:40-05:00
743697 ERNST & YOUNG LLP (WASHINGTON COUNCIL ERNST & YOUNG) 552c4f61-7bf5-4c11-8977-2a15a849df6c 1TY ERNST & YOUNG LLP (WASHINGTON COUNCIL ERNST & YOUNG) 57475 RECAPTURE BOND COALITION 2009 first_quarter           0 1 2009-02-16T14:27:41-05:00
743698 KERRIGAN AND ASSOCIATES ee287c96-0862-4d20-ab56-83fb94b4cc6b Q1Y KERRIGAN AND ASSOCIATES 21494 GCI-WISCONSIN 2009 first_quarter           0 0 2009-02-16T17:42:08-05:00
743699 KERRIGAN AND ASSOCIATES 75562937-3c90-4bf2-a2c3-bbef661b0641 Q1 KERRIGAN AND ASSOCIATES 21494 JOHNSON CONTROLS 507 MICHIGAN STREET MILWAUKEE WI 53202 2009 first_quarter ENG energy efficiency       0 0 2009-02-16T18:22:51-05:00
743700 TUGGEY ROSENTHAL PAUERSTEIN SANDOLOSKI AGATHER LLP 82d1e571-66a9-489f-88db-05b62fe908b4 1T TUGGEY ROSENTHAL PAUERSTEIN SANDOLOSKI AGATHER LLP 323331 ALAMO REGIONAL MOBILITY AUTHORITY 2009 first_quarter TRA Issues regarding financing for the improvement of State Highway 281 North of San Antonio, Texas; and ARMA generally regarding transportation, roads and environmental issues. Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2009-02-17T11:24:14-05:00
743701 TUGGEY ROSENTHAL PAUERSTEIN SANDOLOSKI AGATHER LLP 82d1e571-66a9-489f-88db-05b62fe908b4 1T TUGGEY ROSENTHAL PAUERSTEIN SANDOLOSKI AGATHER LLP 323331 ALAMO REGIONAL MOBILITY AUTHORITY 2009 first_quarter ROD Issues regarding financing for the improvement of State Highway 281 North of San Antonio, Texas; and ARMA generally regarding transportation, roads and environmental issues. Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2009-02-17T11:24:14-05:00
743702 TUGGEY ROSENTHAL PAUERSTEIN SANDOLOSKI AGATHER LLP 82d1e571-66a9-489f-88db-05b62fe908b4 1T TUGGEY ROSENTHAL PAUERSTEIN SANDOLOSKI AGATHER LLP 323331 ALAMO REGIONAL MOBILITY AUTHORITY 2009 first_quarter ENV Issues regarding financing for the improvement of State Highway 281 North of San Antonio, Texas; and ARMA generally regarding transportation, roads and environmental issues. Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2009-02-17T11:24:14-05:00
743703 IAN PFEIFFER GOVERNMENT RELATIONS 4d9260f4-1080-45c9-88c5-51007cc6a9ef 1T IAN PFEIFFER GOVERNMENT RELATIONS 318790 CITY OF CALEXICO 2009 first_quarter BUD Fiscal Year 2009 Department of Transporation Appropriations bill HOUSE OF REPRESENTATIVES,SENATE     0 1 2009-02-17T12:35:58-05:00
743704 GSP CONSULTING CORP 6ec05d46-a4bc-46b3-a37a-fdafba7c4946 1TY GSP CONSULTING CORP 72372 ELECTRIC MOTOR AND SUPPLY 2009 first_quarter           0 1 2009-02-17T14:56:33-05:00
743705 EMORD & ASSOCIATES, PC dc32c8be-a676-4749-9ed6-352f67c23fb9 1TY EMORD & ASSOCIATES, PC 42524 NOVELTY INC 2009 first_quarter           0 1 2009-02-17T20:06:31-05:00
743706 EMORD & ASSOCIATES, PC f8599156-b5b8-4c7e-a568-e8c5f8231d16 1TY EMORD & ASSOCIATES, PC 42524 NUTRACEUTICAL CORPORATION 2009 first_quarter           0 1 2009-02-17T20:09:32-05:00
743707 MAURA MELLEY 43ba3034-2e5a-42aa-bbf4-3d924294fead 1TY MAURA MELLEY 76718 PHOENIX COMPANIES INC 2009 first_quarter           0 1 2009-02-17T21:18:54-05:00
743708 MAURA MELLEY 5e82ec1c-a89a-4bdd-9b2a-29686f8b08bf 1TY MAURA MELLEY 76718 PHOENIX COMPANIES INC 2009 first_quarter           0 1 2009-02-17T21:19:19-05:00
743709 GSP CONSULTING CORP 2352610b-d6c6-4deb-a5d0-bf98209b3b7a 1TY GSP CONSULTING CORP 72372 MONONA FARMS 2009 first_quarter           0 1 2009-02-18T15:37:02-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 1611.099ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API