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

151,946 rows where filing_year = 2011 sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code >30

  • BUD 17,951
  • HCR 10,303
  • TAX 10,161
  • ENG 7,148
  • DEF 7,019
  • TRA 6,617
  • MMM 4,866
  • ENV 4,655
  • EDU 4,284
  • TRD 3,827
  • FIN 3,743
  • AGR 2,965
  • LBR 2,747
  • HOM 2,710
  • CPT 2,708
  • TEC 2,473
  • GOV 2,386
  • NAT 2,318
  • BAN 2,212
  • CAW 2,156
  • SCI 1,604
  • LAW 1,532
  • AVI 1,521
  • CSP 1,503
  • FOR 1,463
  • IMM 1,358
  • HOU 1,327
  • COM 1,278
  • IND 1,247
  • INS 1,227
  • …

filing_period 6

  • first_quarter 38,559
  • second_quarter 38,508
  • fourth_quarter 37,479
  • third_quarter 37,393
  • mid_year 5
  • year_end 2

filing_year 1

  • 2011 · 151,946 ✖
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
1070508 NATIONAL GROUP, LLP 557c5894-82d2-4e38-bbcb-c12223e40349 1T NATIONAL GROUP, LLP 66090 SAN MATEO COUNTY SHERIFF'S DEPARTMENT 2011 first_quarter BUD FY 11 Commerce Justice Science (Law Enforcement Technologies) HOUSE OF REPRESENTATIVES,SENATE     0 1 2010-12-07T12:44:12.233000-05:00
1070509 NATIONAL ASSOCIATION OF REAL ESTATE INVESTMENT MANAGERS 8809fb2e-88cd-4cfd-9998-611a4483fe72 Q1Y NATIONAL ASSOCIATION OF REAL ESTATE INVESTMENT MANAGERS 400375723 NATIONAL ASSOCIATION OF REAL ESTATE INVESTMENT MANAGERS 2011 first_quarter           0 0 2011-01-03T10:48:49.807000-05:00
1070510 LEVINSON & ASSOCIATES f808514b-2239-4f54-bd65-946f2c25d49c 1TY LEVINSON & ASSOCIATES 290616 ALLIANCE FOR GLOBAL FOOD SECURITY 2011 first_quarter           0 1 2011-01-04T16:11:05.977000-05:00
1070511 SIROTE & PERMUTT, P.C. d388469d-e990-4402-992d-e670c993e53b Q1 SIROTE & PERMUTT, P.C. 35491 AMERICAN FAMILY BUSINESS INSTITUTE 2011 first_quarter TAX H.R.8 H.R. 5970 H.R. 64 S.420 S. 988 HOUSE OF REPRESENTATIVES,SENATE     0 0 2011-01-05T16:51:52.450000-05:00
1070512 NATIONAL ASSOCIATION OF PROFESSIONAL EMPLOYER ORGANIZATIONS 1735f683-0348-4800-a6e6-4a727053ea9a 1T NATIONAL ASSOCIATION OF PROFESSIONAL EMPLOYER ORGANIZATIONS 400399882 NATIONAL ASSOCIATION OF PROFESSIONAL EMPLOYER ORGANIZATIONS 2011 first_quarter TAX Proposals clarifying the status of Professional Employer Organizations HR 2447 HOUSE OF REPRESENTATIVES,SENATE   50800 0 1 2011-01-06T18:19:20.810000-05:00
1070513 BROOKFIELD ATLANTIC CORPORATION 19e29be9-b5ac-4058-92c6-07da9f64537c Q4 BROOKFIELD ATLANTIC CORPORATION 318094 BROOKFIELD ATLANTIC CORPORATION 2011 fourth_quarter DEF Lobbied the US Department of Defense to take over major US defense projects (R&D) that can not be completed with U.S. Public funds due to deficit reduction as well the firm lobbied the NSA & CIA to sell stakes and interest in major satellite programs. Central Intelligence Agency (CIA),Defense Advanced Research Projects Agency (DARPA),Defense Business Transformation Agency (BTA),Defense, Dept of (DOD),Director of National Intelligence (ODNI),Economic Development Administration,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Natl Geospatial Intelligence Agency,Natl Security Agency (NSA),Natl Security Council (NSC),Navy, Dept of,SENATE,U.S. Marines,White House Office   550000 0 0 2011-01-08T18:42:41.690000-05:00
1070514 QUANTICO NORTH NFP LIMITED ff564278-5e5c-430c-92c7-8e0175299951 Q4 QUANTICO NORTH NFP LIMITED 400645945 QUANTICO NORTH NFP LIMITED 2011 fourth_quarter FOR Intelligence & Surveillance , Nuclear Energy , Defense HOUSE OF REPRESENTATIVES,Natl Security Agency (NSA),Natl Security Council (NSC),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS)   350000 0 0 2011-01-09T07:56:43.407000-05:00
1070515 G2G CONSULTING 0d99d387-34a3-4d92-a6b3-04e92ef29c19 Q3 G2G CONSULTING 323136 ANALIZA DX 2011 third_quarter BUD appropriations bills HOUSE OF REPRESENTATIVES,SENATE     0 0 2011-01-11T11:36:20.917000-05:00
1070516 AMERICAN HEALTH CARE PROFESSIONALS f3e9f347-2e26-42ae-a640-9d46286ce753 Q1 AMERICAN HEALTH CARE PROFESSIONALS 400693063 AMERICAN HEALTH CARE PROFESSIONALS 2011 first_quarter HCR HOME HEALTH CARE, HOSPICE, TELEHEALTH, PREVENTION/WELLNESS. HOUSE OF REPRESENTATIVES,SENATE,Small Business Administration (SBA),Social Security Administration (SSA)     0 0 2011-01-13T14:15:50.863000-05:00
1070517 AMERICAN LANDS ACCESS ASSN. INC. d5352d59-fe08-414a-b825-afed892f7885 Q1Y AMERICAN LANDS ACCESS ASSN. INC. 2742 AMERICAN LANDS ACCESS ASSN. INC. 2011 first_quarter           0 0 2011-01-14T12:21:03.907000-05:00
1070518 FRONTIER COMMUNICATIONS 22d92eab-1abd-4d86-bef1-32e4db543f63 Q4 FRONTIER COMMUNICATIONS 400691058 FRONTIER COMMUNICATIONS 2011 fourth_quarter TEC House and Senate: H.R. 1409 - Employee Free Choice Act of 2009; Tax Reform; monitored general telecommunications, USF, and rural broadband issues. FCC: Open Internet Proceeding; Role of the Universal Service Fund and Intercarrier Compensation in the National Broadband Plan; other FCC-related matters. Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE   175000 0 0 2011-01-14T16:18:36.097000-05:00
1070519 TRANS UNION LLC fee93372-19ab-4f2a-840e-c0541f8d0340 Q4 TRANS UNION LLC 62131 TRANS UNION LLC 2011 fourth_quarter FIN Red Flag Clarification Act HR 6420/S3987--concern that the duty to maintain identity fraud prevention and detection processes was being defined by this bill in terms of an entity's participation in the consumer credit reporting system. SENATE   50000 0 0 2011-01-17T10:27:10.957000-05:00
1070520 NORTH DAKOTA CHAMBER OF COMMERCE 7b1a7f94-fd14-4e33-afd0-6c59b80ac1bc 1TY NORTH DAKOTA CHAMBER OF COMMERCE 400441124 NORTH DAKOTA CHAMBER OF COMMERCE 2011 first_quarter           0 1 2011-01-18T09:25:53.150000-05:00
1070521 CAPITOL RESOURCES, LLC 6099802c-2d8e-421e-b095-abb0b4fb3663 4T CAPITOL RESOURCES, LLC 53174 CELLULAR SOUTH INC 2011 fourth_quarter TEC Telcommunications Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE 30000   0 1 2011-01-18T13:00:10.103000-05:00
1070522 CAPITOL RESOURCES, LLC a1229a35-280c-48b3-a7db-c14918c97baf Q4 CAPITOL RESOURCES, LLC 53174 COMCAST CORPORATION 2011 fourth_quarter TEC Telecommunications Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE 45000   0 0 2011-01-18T13:05:40.400000-05:00
1070523 GORDON THOMAS HONEYWELL GOVERNMENTAL AFFAIRS abecbaa6-4fdd-4826-998d-b84eec626dc9 Q4 GORDON THOMAS HONEYWELL GOVERNMENTAL AFFAIRS 314738 THERMO FISHER SCIENTIFIC INC 2011 fourth_quarter BUD S.3636 Commerce Justice Science and related ageny appropriations Act 2011 Omnibus Appropriations bill dealing with DNA HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2011-01-18T13:53:02.273000-05:00
1070524 GORDON THOMAS HONEYWELL GOVERNMENTAL AFFAIRS abecbaa6-4fdd-4826-998d-b84eec626dc9 Q4 GORDON THOMAS HONEYWELL GOVERNMENTAL AFFAIRS 314738 THERMO FISHER SCIENTIFIC INC 2011 fourth_quarter LAW H.R. 4614 Katie Sepich Enhances DNA Collection Act of 2010, H.R. 2736 Justice for Survivors of Sexual Assault Act of 2009, S.4114 Justice for Survivors of Sexual Assault Act of 2009, S. 3805 Katie Sepich Enhances DNA Collection Act of 2010, S.3842 Justice for all Reauthorization Act. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2011-01-18T13:53:02.273000-05:00
1070525 YMCA OF THE USA ab859b94-f1a8-4614-b510-ac735496b4f1 Q4 YMCA OF THE USA 42067 YMCA OF THE USA 2011 fourth_quarter EDU -Support for legislation that promoted increased physical activity for children, before, during and after school -Support for legislation that promotes increased physical activity, better nutrition and healthy living for all adults. -Elementary and Seconday Education Act (ESEA) aka No Child Left Behind Legislation Reauthorization (NCLB)- with a focus on promoting health and wellbeing through nutrition and physical activity for children Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Consumer Product Safety Commission (CPSC),Education, Dept of,Executive Office of the President (EOP),Federal Bureau of Investigation (FBI),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Park Service (NPS),Office of Faith-Based & Community Initiatives,SENATE,U.S. Forest Service   100000 0 0 2011-01-18T14:39:48.507000-05:00
1070526 YMCA OF THE USA ab859b94-f1a8-4614-b510-ac735496b4f1 Q4 YMCA OF THE USA 42067 YMCA OF THE USA 2011 fourth_quarter TAX - Extension of the IRA Rollover Charitable Tax Incentive -- other provisions relating to nonprofit organizations and tax incentives for charitable giving Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Consumer Product Safety Commission (CPSC),Education, Dept of,Executive Office of the President (EOP),Federal Bureau of Investigation (FBI),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Park Service (NPS),Office of Faith-Based & Community Initiatives,SENATE,U.S. Forest Service   100000 0 0 2011-01-18T14:39:48.507000-05:00
1070527 YMCA OF THE USA ab859b94-f1a8-4614-b510-ac735496b4f1 Q4 YMCA OF THE USA 42067 YMCA OF THE USA 2011 fourth_quarter HCR -- Support for the Child Protection Improvements Act of 2009, (The Background Checks Bill) to improve and provide funding for federal background checks for youth serving organizations Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Consumer Product Safety Commission (CPSC),Education, Dept of,Executive Office of the President (EOP),Federal Bureau of Investigation (FBI),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Park Service (NPS),Office of Faith-Based & Community Initiatives,SENATE,U.S. Forest Service   100000 0 0 2011-01-18T14:39:48.507000-05:00
1070528 YMCA OF THE USA ab859b94-f1a8-4614-b510-ac735496b4f1 Q4 YMCA OF THE USA 42067 YMCA OF THE USA 2011 fourth_quarter BUD FY'11 Labor/HHS/Education Appropriations - provisions related to afterschool, child care, disease prevention and health promotion FY'11 Commerce/Justice/Science Appropriations - provisions related to juvenile delinquincy prevention and gang prevention programs Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Consumer Product Safety Commission (CPSC),Education, Dept of,Executive Office of the President (EOP),Federal Bureau of Investigation (FBI),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Park Service (NPS),Office of Faith-Based & Community Initiatives,SENATE,U.S. Forest Service   100000 0 0 2011-01-18T14:39:48.507000-05:00
1070529 DENNY MILLER ASSOCIATES 3e907431-7123-4a2b-bbdf-a8755cba3524 Q4 DENNY MILLER ASSOCIATES 25328 RUBBER MANUFACTURERS ASSN 2011 fourth_quarter TRA S 3635 Department of Energy Appropriations FY 2011, issues relating to tire safety, efficiency, tire recycling, rolling resistance and consumer education. HR 5381 Motor Vehicle Safety Act of 2010, issues relating to early warning reporting. S 3302 Motor Vehicle Saftey Act of 2010, issues relating to motor vehicle safety. HR 3082, 4th Continuing Appropriations Act, 2011. Omnibus Appropriations Amendment. HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2011-01-18T15:14:25.710000-05:00
1070530 DENNY MILLER ASSOCIATES 3e907431-7123-4a2b-bbdf-a8755cba3524 Q4 DENNY MILLER ASSOCIATES 25328 RUBBER MANUFACTURERS ASSN 2011 fourth_quarter BUD S 3635 Department of Energy Appropriations FY 2011, issues relating to tire safety, efficiency, tire recycling, rolling resistance and consumer education. HR 3082, 4th Continuing Appropriations Act, 2011. Omnibus Appropriations Amendment. HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2011-01-18T15:14:25.710000-05:00
1070531 WAYNE STATE UNIVERSITY, DETROIT, MICHIGAN be121e76-e1bd-44e5-b550-9ea594899a09 Q4 WAYNE STATE UNIVERSITY, DETROIT, MICHIGAN 48805 WAYNE STATE UNIVERSITY, DETROIT, MICHIGAN 2011 fourth_quarter EDU Research CMS/GME Higher Education Issues       0 0 2011-01-18T22:59:09.467000-05:00
1070532 G3 & ASSOCIATES c193eb08-9e43-4424-9712-e5da51fa6105 4TY G3 & ASSOCIATES 400553656 PORTLAND COMMUNITY MEDIA 2011 fourth_quarter           0 1 2011-01-19T01:06:18.853000-05:00
1070533 HENGEN GROUP, LLC 258c0b6d-f244-4f87-89d8-90e0b83c8da6 Q1 HENGEN GROUP, LLC 400459260 SMURFIT STONE CONTAINER CORPORATION 2011 first_quarter AGR Biomass Crop Assistance Program (BCAP) HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2011-01-19T09:20:46.553000-05:00
1070534 HENGEN GROUP, LLC 258c0b6d-f244-4f87-89d8-90e0b83c8da6 Q1 HENGEN GROUP, LLC 400459260 SMURFIT STONE CONTAINER CORPORATION 2011 first_quarter TRA HR1799 HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2011-01-19T09:20:46.553000-05:00
1070535 HENGEN GROUP, LLC 258c0b6d-f244-4f87-89d8-90e0b83c8da6 Q1 HENGEN GROUP, LLC 400459260 SMURFIT STONE CONTAINER CORPORATION 2011 first_quarter TAX SEC 1603 ARRA HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2011-01-19T09:20:46.553000-05:00
1070536 HENGEN GROUP, LLC 258c0b6d-f244-4f87-89d8-90e0b83c8da6 Q1 HENGEN GROUP, LLC 400459260 SMURFIT STONE CONTAINER CORPORATION 2011 first_quarter ENV Climate Change legislation - including but not limited to: Kerry, Graham, Leiberman bill; Collins, Cantwell bill. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2011-01-19T09:20:46.553000-05:00
1070537 HENGEN GROUP, LLC 258c0b6d-f244-4f87-89d8-90e0b83c8da6 Q1 HENGEN GROUP, LLC 400459260 SMURFIT STONE CONTAINER CORPORATION 2011 first_quarter CAW EPA Boiler MACT EPA Tailoring Rule HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2011-01-19T09:20:46.553000-05:00
1070538 HENGEN GROUP, LLC e617bcc4-cf04-4a5b-90b7-3f8a2da6ef19 Q1Y HENGEN GROUP, LLC 400459260 SIMULMEDIA 2011 first_quarter       10000   0 0 2011-01-19T09:23:54.477000-05:00
1070539 CERES, INC. 6291b3b7-7458-43bd-9c48-3eefa2da76fd Q4 CERES, INC. 400426044 CERES, INC. 2011 fourth_quarter CAW protection of EPA authority to regulate GHG emissions under the Clean Air Act Council on Environmental Quality (CEQ),Environmental Protection Agency (EPA),SENATE   10000 0 0 2011-01-19T09:52:03.320000-05:00
1070540 KERRIGAN AND ASSOCIATES e851b6b1-33f9-4e14-89b6-74934cf91581 MMY KERRIGAN AND ASSOCIATES 21494 GCI-WISCONSIN 2011 second_quarter           0 0 2011-01-19T21:53:02.133000-05:00
1070541 CONSORTIUM FOR OCEAN LEADERSHIP 0496d7a4-5405-4d92-88a3-e1ddd2ac9fa5 1TY CONSORTIUM FOR OCEAN LEADERSHIP 10582 CONSORTIUM FOR OCEAN LEADERSHIP 2011 first_quarter           0 1 2011-01-20T09:50:45.063000-05:00
1070542 CAPITOL TAX PARTNERS, LLP d5b896ae-6ab5-475a-8992-5042e98bd554 1T CAPITOL TAX PARTNERS, LLP 65976 CLEAN COAL SOLUTIONS, LLC 2011 first_quarter TAX Legislative and regulatory services related to the tax treatment of refined coal including: H.R. 4213, the Tax Extenders Act of 2009; S. 2826, the Clean Renewable Energy Advancement Tax Extension Jobs Act of 2009; S. 3793, the Job Creation and Tax Cuts Act; H.R. 5893, the Investing in American Jobs and Closing Tax Loopholes Act of 2010; H.R. 4853, the Tax Relief, Unemployment Insurance Reauthorization, and Job Creation Act of 2010; H.R. 6467, the Middle Class Tax Relief Act of 2010; and S. 3793, the Job Creation and Tax Cuts Act. HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 150000   0 1 2011-01-20T14:58:06.697000-05:00
1070543 AMERICAN COMMUNICATIONS GROUP, INC. 1f38d63c-1daa-4d6b-81cf-3d6f5789cede 1TY AMERICAN COMMUNICATIONS GROUP, INC. 400376725 AMERICAN WIND ENERGY ASSOCIATION 2011 first_quarter           0 1 2011-01-21T12:41:05.680000-05:00
1070544 WILDFIRE PROTECTION SYSTEMS 14791741-4c81-4193-a80a-27716ffb5312 Q1Y WILDFIRE PROTECTION SYSTEMS 400511510 WILDFIRE PROTECTION SYSTEMS 2011 first_quarter           0 0 2011-01-24T14:26:25.320000-05:00
1070545 ADAM GREENSLADE 3172b642-4c86-4e96-9822-6ae6ce1869ba 1TY ADAM GREENSLADE 40041335 SANDUSKY COUNTY REGIONAL AIRPORT AUTHORITY 2011 first_quarter           0 1 2011-01-24T15:29:46.477000-05:00
1070546 UNITED ELECTRICAL RADIO & MACHINE WORKERS OF AMERICA bc1a84fd-174c-4023-b417-243622d25425 Q1 UNITED ELECTRICAL RADIO & MACHINE WORKERS OF AMERICA 39108 UNITED ELECTRICAL RADIO & MACHINE WORKERS OF AMERICA 2011 first_quarter LBR Health Care Pensions - Social Security Transportation Stimulus Relief HOUSE OF REPRESENTATIVES,SENATE     0 0 2011-01-25T15:01:16.447000-05:00
1070547 MS. CATHERINE MCCULLOUGH 596f553e-918c-4fd4-85b5-a1304d98d517 1TY MS. CATHERINE MCCULLOUGH 315832 SONOMA TECHNOLOGIES 2011 first_quarter           0 1 2011-01-25T16:01:36.837000-05:00
1070548 NATIONAL POLICY GROUP cabfb954-be77-4a22-b815-2fbbce41a17f 1@ NATIONAL POLICY GROUP 400648954 SONOMA TECHNOLOGIES, INC. 2011 first_quarter SCI Strategic communications only - educational campaign for AIRNow program       0 1 2011-01-26T12:33:41.097000-05:00
1070549 ANCHOR CONSULTING, LLC a3bcca9e-09d0-4857-a656-58f6f013ddbf 1T ANCHOR CONSULTING, LLC 310313 EXQUADRUM, INC. 2011 first_quarter DEF Defense/DoD Authorization Defense Appropriations Act HOUSE OF REPRESENTATIVES,SENATE     0 1 2011-01-27T11:36:18.393000-05:00
1070550 STRATEGIC APPLICATIONS INTERNATIONAL, LLC 5bea6311-62c7-44a2-a4a6-24de371b8325 Q1 STRATEGIC APPLICATIONS INTERNATIONAL, LLC 295337 LUKE COMMISSION 2011 first_quarter HCR Secure funding for current and new programs. Health & Human Services, Dept of (HHS),U.S. Agency for International Development (USAID)     0 0 2011-01-27T12:48:22.740000-05:00
1070551 STRATEGIC APPLICATIONS INTERNATIONAL, LLC 5bea6311-62c7-44a2-a4a6-24de371b8325 Q1 STRATEGIC APPLICATIONS INTERNATIONAL, LLC 295337 LUKE COMMISSION 2011 first_quarter MED Secure funding for current and new programs. Health & Human Services, Dept of (HHS),U.S. Agency for International Development (USAID)     0 0 2011-01-27T12:48:22.740000-05:00
1070552 NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 114631ce-8b10-4e65-90d6-cd9c291787c5 Q1 NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 85071 TRACFONE WIRELESS INC 2011 first_quarter TEC Universal Service Fund Reform, No Legislation Lifeline Service Related Issues, No Specific legislation Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2011-01-28T15:09:23.347000-05:00
1070553 NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) d1fe9ddc-8931-440b-ba3e-c38bc3dcbaa4 Q1 NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 85071 ORACLE AMERICA, INC. 2011 first_quarter IMM Immigration Reform, provisions relating to HB-1 Visas for high skilled workers HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,White House Office 40000   0 0 2011-01-28T15:13:24.380000-05:00
1070554 NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) d1fe9ddc-8931-440b-ba3e-c38bc3dcbaa4 Q1 NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 85071 ORACLE AMERICA, INC. 2011 first_quarter TAX No Specific Legislation, Corporate Tax Reform, R&D Tax Credit, Tax Repatriation, International tax reform HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,White House Office 40000   0 0 2011-01-28T15:13:24.380000-05:00
1070555 NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 117a46ce-4826-41f3-9d3f-4c8e655d5688 Q1 NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 85071 AT&T SERVICES, INC. 2011 first_quarter TEC FCC Wireless Spectrum Rules, No Legislation Issues related to Universal Services Fund Reform, No Specific Legislation Net Neutrality Rule Making Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2011-01-28T15:15:25.377000-05:00
1070556 NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 52073246-6504-4898-a276-29053f6cba6b Q1Y NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 85071 MR JAMES A KAY JR 2011 first_quarter           0 0 2011-01-28T15:15:27.893000-05:00
1070557 VERTEX, INC dce85718-e2ef-4bb8-833a-3d8b6ff47db6 1TY VERTEX, INC 64895 VERTEX INC 2011 first_quarter           0 1 2011-01-31T13:11:53.990000-05:00
1070558 THE SMITH-FREE GROUP, LLC 312ef127-e6d0-4de9-aac7-578fdfce2f7c 1TY THE SMITH-FREE GROUP, LLC 35800 XCEL ENERGY 2011 first_quarter       10000   0 1 2011-02-02T17:26:10.280000-05:00
1070559 NICO SANDERS 4ec37841-3c0c-4dbe-ab21-32e8ed9fd743 Q1 NICO SANDERS 400701096 THE CORNERSTONE HERITAGE GROUP 2011 first_quarter RES Helping to resolve land development use. Development Minority Business Development Agency     0 0 2011-02-03T11:21:33.103000-05:00
1070560 LIEBMAN & ASSOCIATES, INC. 063af7d2-7446-4efc-bccf-9e31103702f4 1TY LIEBMAN & ASSOCIATES, INC. 46585 IOWA ASSOCIATION OF MUNICIPAL UTILITIES 2011 first_quarter           0 1 2011-02-03T14:14:55.503000-05:00
1070561 FRANCO GOVERNMENT RELATIONS, INC. a9f1937b-16c1-4f7b-ae0d-fafff980be1b 1TY FRANCO GOVERNMENT RELATIONS, INC. 400602834 MICCOSUKEE TRIBE OF INDIANS OF FLORIDA 2011 first_quarter       5000   0 1 2011-02-07T10:16:57.717000-05:00
1070562 THE SMITH-FREE GROUP, LLC 9bd8ecd9-65c5-4674-bfd0-084d28b54657 1TY THE SMITH-FREE GROUP, LLC 35800 POKER PLAYERS ALLIANCE 2011 first_quarter       20000   0 1 2011-02-07T16:43:36.120000-05:00
1070563 CAMPBELL FLANNERY, P.C. 7b3a61c2-39fc-4c9f-a47d-1100deba3381 1TY CAMPBELL FLANNERY, P.C. 400610855 MANPOWER, INC. 2011 first_quarter           0 1 2011-02-07T16:48:38.120000-05:00
1070564 AMERICAN COLLEGE OF CHEST PHYSICIANS 728f224d-a8e6-4f74-ba3b-142fead667a6 1TY AMERICAN COLLEGE OF CHEST PHYSICIANS 1956 AMERICAN COLLEGE OF CHEST PHYSICIANS 2011 first_quarter           0 1 2011-02-08T14:39:02.057000-05:00
1070565 CAPITOL INTEGRITY 11cdaed3-f776-44b1-ad9e-48f38f373e34 1TY CAPITOL INTEGRITY 400311454 TECHNOLOGY MANAGMENT INCORPORATED 2011 first_quarter           0 1 2011-02-08T15:45:25.383000-05:00
1070566 JEAN BERUBE 8a451148-0525-4ebd-b829-e7ee712fdbb7 1TY JEAN BERUBE 400323517 NATIONAL ASSOCIATION OF STATE HEAD INJURY ADMINISTRATORS 2011 first_quarter           0 1 2011-02-08T23:47:27.393000-05:00
1070567 PAUL MARCONE & ASSOCIATES, LLC 78fafd8a-992d-4ab5-83f9-df265b421900 1T PAUL MARCONE & ASSOCIATES, LLC 283732 THE SALVATION ARMY - EASTERN DIVISION 2011 first_quarter BUD Discussions with House and Senate staff about federal transportation funding and possibilities to apply for federal grants. HOUSE OF REPRESENTATIVES,SENATE     0 1 2011-02-09T10:21:39.330000-05:00
1070568 PAUL MARCONE & ASSOCIATES, LLC 7039f980-d1e3-4140-8f3e-23857d6efc88 1TY PAUL MARCONE & ASSOCIATES, LLC 283732 KULANU CENTER FOR SPECIAL SERVICES 2011 first_quarter           0 1 2011-02-09T10:24:41.047000-05:00
1070569 L. E. HAEFNER ENTERPRISES, INC. 348a5c0e-cdd6-493e-9e20-804af2f8a83a 1TY L. E. HAEFNER ENTERPRISES, INC. 17261 RIVERPORT RAILROAD, LLC 2011 first_quarter           0 1 2011-02-16T10:49:58.610000-05:00
1070570 GRAY COMMUNICATIONS INC aa9fea48-3c14-42e7-8e2e-5b3b69d17520 Q1Y GRAY COMMUNICATIONS INC 400617873 GRAY COMMUNICATIONS INC 2011 first_quarter           0 0 2011-02-16T12:00:03.763000-05:00
1070571 WELCH RESOURCES, INC. 5f91518a-b34d-465c-bca6-679d1d930ea3 1T WELCH RESOURCES, INC. 83978 BALLISTICS BLOCKS, LLC 2011 first_quarter DEF Obtain funding in the appropriation bill to provide protection for the troops. Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE     0 1 2011-02-17T17:29:53.777000-05:00
1070572 WELCH RESOURCES, INC. d8a01d2a-50e9-4aa1-abbe-a675a82acecf 1T WELCH RESOURCES, INC. 83978 CORTEZ BYRD CHIPS, INC. 2011 first_quarter FOR Assisting client in seeking federal support to satisfy a United States Federal Court judgment from Corporacion Forestal y Industrial de Olancho, S. A. (CORFINO), entered in the U. S. District Court, Southern District of Mississippi, Jackson Division. HOUSE OF REPRESENTATIVES,SENATE     0 1 2011-02-17T17:34:54.560000-05:00
1070573 SABISTON CONSULTANTS, LLC b5c5f38c-8148-4b51-8dff-7861aa76844e 1TY SABISTON CONSULTANTS, LLC 323557 DURATEL 2011 first_quarter           0 1 2011-02-18T15:26:01.167000-05:00
1070574 MCALLISTER & QUINN, LLC b10d8c23-3970-4ef0-92f4-28ce98ac4ab5 1T MCALLISTER & QUINN, LLC 292573 TOWN OF DAVIDSON 2011 first_quarter TRA Surface Transportation Reauthorization; Water Resources Development Act HOUSE OF REPRESENTATIVES,SENATE     0 1 2011-02-23T08:24:06.847000-05:00
1070575 MCALLISTER & QUINN, LLC b10d8c23-3970-4ef0-92f4-28ce98ac4ab5 1T MCALLISTER & QUINN, LLC 292573 TOWN OF DAVIDSON 2011 first_quarter BUD Commerce, Justice & State Appropriations; Financial Services Appropriations HOUSE OF REPRESENTATIVES,SENATE     0 1 2011-02-23T08:24:06.847000-05:00
1070576 VENABLE LLP 32d98c7d-460b-4091-b98b-d8b74bd1562b 1TY VENABLE LLP 39941 NESTE PETROLEUM INC 2011 first_quarter           0 1 2011-02-24T10:14:30.040000-05:00
1070577 VENABLE LLP 32f6f1db-7347-4aef-8b9b-5e19421b9d37 1TY VENABLE LLP 39941 TRUST FOR ARCHITECTURAL EASEMENTS 2011 first_quarter           0 1 2011-02-24T10:16:30.823000-05:00
1070578 MCALLISTER & QUINN, LLC 32af8dc7-3d62-4cd5-b17c-e358056a847f 1TY MCALLISTER & QUINN, LLC 292573 FRIENDS OF CASA OF GREATER LOS ANGELES 2011 first_quarter           0 1 2011-02-25T09:52:52.937000-05:00
1070579 WELCH RESOURCES, INC. 91c8da41-139a-4378-a1d5-feee95c77bcb 1TY WELCH RESOURCES, INC. 83978 ASHBRITT INC 2011 first_quarter           0 1 2011-02-25T12:25:43.083000-05:00
1070580 WELCH RESOURCES, INC. 72346c85-ba7c-4bc9-9918-36b5268cc72c 1TY WELCH RESOURCES, INC. 83978 WILLOW BEND VENTURES LLC 2011 first_quarter           0 1 2011-02-25T12:32:46.040000-05:00
1070581 SAVE AMERICA'S FORESTS, INC. 5475ee27-7d4f-4b3f-911d-bb5da1306195 Q1 SAVE AMERICA'S FORESTS, INC. 34411 SAVE AMERICA'S FORESTS INC 2011 first_quarter NAT Biomass Incineration, Renewable Electricity Standand, S. 3813, S. 2895 HOUSE OF REPRESENTATIVES,SENATE     0 0 2011-02-26T07:16:19.027000-05:00
1070582 GREEN CAPITOL LLC 87673dc9-5c51-4f3a-8ccd-987fecc70a5b 1TY GREEN CAPITOL LLC 314498 ENVIRONMENTAL LAW & POLICY CENTER 2011 first_quarter           0 1 2011-02-27T13:49:24.637000-05:00
1070583 INTERNATIONAL ALTERNATIVE ENERGY RESOURCES 4fe7c84e-91fb-435b-91d8-e0e5420a4536 Q1Y INTERNATIONAL ALTERNATIVE ENERGY RESOURCES 400499461 INTERNATIONAL ALTERNATIVE ENERGY RESOURCES 2011 first_quarter           0 0 2011-02-28T10:36:26.327000-05:00
1070584 MCALLISTER & QUINN, LLC 3ecf041f-b973-469a-b075-cb642d99717f 1TY MCALLISTER & QUINN, LLC 292573 YWCA PACIFIC REGIONAL COUNCIL 2011 first_quarter       14000   0 1 2011-03-01T13:54:16.613000-05:00
1070585 BOND & COMPANY b336e43a-af45-4fc7-b5d2-f3388302dd2e 1TY BOND & COMPANY 6677 APOLLO GROUP/UNIVERSITY OF PHOENIX 2011 first_quarter       40000   0 1 2011-03-01T14:46:18.443000-05:00
1070586 NOSSAMAN LLP 98de3aa9-6648-4688-85ce-fb8d96741036 1TY NOSSAMAN LLP 29846 ST. MARYS CEMENT COMPANY 2011 first_quarter           0 1 2011-03-02T11:46:36.713000-05:00
1070587 JOHNNY SATTERWHITE 0cb9d60c-5748-4aa2-ad78-e0e057023a70 Q1 JOHNNY SATTERWHITE 400568698 MR JOHNNY SATTERWHITE 2011 first_quarter DEF As stated in an e-mail from (Johnny Satterwhite) to senator( Carl Levin) on or about ( 02/24/2011) all active and reserve military personel are due a pay increase the request is for ( 100% ) of there current pay and I am adding in this document for this to be implemented and effective before the 3rd quarter of 2011 ends, this is the request Johnny Earl Satterwhite / U.S. Defense Finance & Accounting Service (DFAS),HOUSE OF REPRESENTATIVES,SENATE     0 0 2011-03-02T16:37:44.600000-05:00
1070588 ROCKEFELLER GROUP DEVELOPMENT CORPORATION 18309f57-9ccf-42d7-b1d1-88c24be08eaf 1T ROCKEFELLER GROUP DEVELOPMENT CORPORATION 321998 INTERNATIONAL FLAVORS & FRAGRANCES 2011 first_quarter TAX regarding proposed excise tax legislation       0 1 2011-03-03T08:28:51.580000-05:00
1070589 GOVERNMENT RELATIONS INC 9f86ef41-81fc-4896-8b1f-6e623205e4c3 Q1 GOVERNMENT RELATIONS INC 16635 INRIX 2011 first_quarter TRA transportation authorization; intelligent transportation systems; performance measures and data HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) 10000   0 0 2011-03-03T10:24:52.433000-05:00
1070590 CYBER SECURITY RESEARCH CONSULTANTS, LLC a15e964c-1468-4815-b4ee-b2c36d5c0bcb 1T CYBER SECURITY RESEARCH CONSULTANTS, LLC 91694 OLIVE CREST ABUSED CHILDRENS FOUNDATION 2011 first_quarter FAM FY 11 CJS Appropriations-specific (Dept of Justice-at risk youth) FY 11 Labor Education and Health Appropriations HOUSE OF REPRESENTATIVES,SENATE 14000   0 1 2011-03-03T13:35:03.190000-05:00
1070591 GLSEN, INC. (FORMERLY KNOWN AS GAY LESBIAN & STRAIGHT EDUCATION NETWORK) 6580cd51-4384-42fc-bda4-fed83c90059b Q1 GLSEN, INC. (FORMERLY KNOWN AS GAY LESBIAN & STRAIGHT EDUCATION NETWORK) 40044354 GLSEN INC 2011 first_quarter HCR Supporting funding for the Division of Adolescent and School Health. Supporting the creation of a National Resource Center for LGBT individuals with disabilities. Supporting questions relating to sexual orientation and gender identity within the Youth Risk Behavior Survey. Centers For Disease Control & Prevention (CDC),Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   80000 0 0 2011-03-03T18:49:21.277000-05:00
1070592 GLSEN, INC. (FORMERLY KNOWN AS GAY LESBIAN & STRAIGHT EDUCATION NETWORK) 6580cd51-4384-42fc-bda4-fed83c90059b Q1 GLSEN, INC. (FORMERLY KNOWN AS GAY LESBIAN & STRAIGHT EDUCATION NETWORK) 40044354 GLSEN INC 2011 first_quarter BUD Supporting increased funding for education programs, specifically for the Office of Safe and Drug Free Schools (within the Labor-HHS-Education Appropriations bills). Centers For Disease Control & Prevention (CDC),Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   80000 0 0 2011-03-03T18:49:21.277000-05:00
1070593 GLSEN, INC. (FORMERLY KNOWN AS GAY LESBIAN & STRAIGHT EDUCATION NETWORK) 6580cd51-4384-42fc-bda4-fed83c90059b Q1 GLSEN, INC. (FORMERLY KNOWN AS GAY LESBIAN & STRAIGHT EDUCATION NETWORK) 40044354 GLSEN INC 2011 first_quarter EDU Supporting the reintroduction of the Safe Schools Improvement Act (SSIA), to prohibit bullying and harassment. Supporting the reintroduction of the Student Non-Discrimination Act (SNDA), to prohibit anti-LGBT discrimination in education. Supporting the inclusion of SSIA and SNDA in House and Senate ESEA reauthorization legislation. Requesting statements and efforts to address bullying and harassment from the U.S. Department of Education. Centers For Disease Control & Prevention (CDC),Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   80000 0 0 2011-03-03T18:49:21.277000-05:00
1070594 THE DUBERSTEIN GROUP INC. 8ee8a79c-57c0-4196-99d3-e252fd62dac1 1TY THE DUBERSTEIN GROUP INC. 12675 SANOFI-AVENTIS U.S. INC. 2011 first_quarter           0 1 2011-03-04T11:38:29.350000-05:00
1070595 MCALLISTER & QUINN, LLC 770139b2-3aee-4fc1-b269-678cdb968f11 1T MCALLISTER & QUINN, LLC 292573 COE COLLEGE 2011 first_quarter BUD Appropriations, Labor-HHS Appropriations, Transportation-HUD Appropriations HOUSE OF REPRESENTATIVES,SENATE 8000   0 1 2011-03-08T08:14:15.263000-05:00
1070596 QUANTICO NORTH NFP LIMITED e32b5bc6-d521-4544-90aa-7a16b63bc8e9 Q1 QUANTICO NORTH NFP LIMITED 400645945 QUANTICO NORTH NFP LIMITED 2011 first_quarter FOR Quantico North NFP is currenlty advocating and lobbying for a US Senate bill that will prepare the United States Armed services to deal with a possible nuclear accident and threat in the Middle East. The senate bill will allow the United States government to export & license Nuclear, Biological and Chemical equipment to allied countries in the Middle East, In a seperate bill in the US House of Representatives the company is advocating for Nuclear trainging centers that will train many in the region to use nuclear power. Air Force, Dept of,Army, Dept of (Other),Bureau of Industry and Security (BIS),Central Intelligence Agency (CIA),Defense, Dept of (DOD),Energy, Dept of,Executive Office of the President (EOP),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Joint Chiefs of Staff,Navy, Dept of,SENATE,State, Dept of (DOS),U.S. Marines,Vice President of the U.S.,White House Office   22500 0 0 2011-03-08T09:40:16.073000-05:00
1070597 CAUTHEN FORBES & WILLIAMS 44749c00-c20c-4edc-83a4-614a1efeaed9 1T CAUTHEN FORBES & WILLIAMS 284551 STYRENE INFORMATION & RESEARCH CENTER 2011 first_quarter CHM Issues related to chemical safety and production of industrial chemicals. Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE 50000   0 1 2011-03-08T10:22:18.403000-05:00
1070598 CAUTHEN FORBES & WILLIAMS 44749c00-c20c-4edc-83a4-614a1efeaed9 1T CAUTHEN FORBES & WILLIAMS 284551 STYRENE INFORMATION & RESEARCH CENTER 2011 first_quarter CSP Issues related to chemical safety and production of industrial chemicals. Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE 50000   0 1 2011-03-08T10:22:18.403000-05:00
1070599 MCALLISTER & QUINN, LLC b348878c-9003-4131-b941-fe30d4dccccb 1TY MCALLISTER & QUINN, LLC 292573 JOHN G SHEDD AQUARIUM 2011 first_quarter           0 1 2011-03-08T11:17:24.797000-05:00
1070600 MCALLISTER & QUINN, LLC c3f6cf4f-1d1c-4c8f-bcf9-4fa11df5d2a4 1TY MCALLISTER & QUINN, LLC 292573 MOTOROLA 2011 first_quarter           0 1 2011-03-08T14:12:25.597000-05:00
1070601 MCALLISTER & QUINN, LLC 0722d6e5-fbec-4875-8ccf-fed38d2a5108 1TY MCALLISTER & QUINN, LLC 292573 LYON ASSOCIATES 2011 first_quarter           0 1 2011-03-08T14:20:26.333000-05:00
1070602 JAYETTA HECKER f00cfeb9-e4e5-4b7e-a7b0-65a7d24d9699 1T JAYETTA HECKER 400489403 BIPARTISAN ADVOCACY NETWORK 2011 first_quarter TRA NTPP recommendations HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT) 20000   0 1 2011-03-09T17:54:02.357000-05:00
1070603 MAYER BROWN LLP 05c2e28c-39f0-43f5-9a9e-dbdec69e38e6 1T MAYER BROWN LLP 24123 ORCHID CELLMARK INC. 2011 first_quarter LAW Provide laboratory role in DNA testing in criminal justice system. HOUSE OF REPRESENTATIVES 9000   0 1 2011-03-10T10:21:09.060000-05:00
1070604 LIEBMAN & ASSOCIATES, INC. 89cdc853-d55f-4d13-a122-1a71b9404b06 1TY LIEBMAN & ASSOCIATES, INC. 46585 REDSEAL SYSTEMS, INC. 2011 first_quarter           0 1 2011-03-10T12:54:15.397000-05:00
1070605 K.O. STRATEGIES LLC (FORMERLY KNOWN AS CATHERINE O'MALLEY) 70fccc61-b1b7-42eb-ba37-906f64288ef4 1TY K.O. STRATEGIES LLC (FORMERLY KNOWN AS CATHERINE O'MALLEY) 400560675 NEUMANN FAMILY SERVICES 2011 first_quarter           0 1 2011-03-10T16:32:26.293000-05:00
1070606 BROOKFIELD ATLANTIC CORPORATION aaf1bf16-27fb-43a3-aab6-2da6f04ffec9 Q1 BROOKFIELD ATLANTIC CORPORATION 318094 BROOKFIELD ATLANTIC CORPORATION 2011 first_quarter DEF Brookfield Atlantic Limited has a current stake in a draft congressional bill in the United States House of Representatives that would allow American and British based corporations to invest in US military R&D technology with certain assurances from the United States government that the investors will retain their principal investment in various technology projects that can no longer be funded by the US Government or public funds. Air Force, Dept of,Central Intelligence Agency (CIA),Defense Advanced Research Projects Agency (DARPA),Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Natl Geospatial Intelligence Agency,Natl Security Agency (NSA),Navy, Dept of,SENATE   360000 0 0 2011-03-11T08:54:34.360000-05:00
1070607 BROOKFIELD ATLANTIC CORPORATION aaf1bf16-27fb-43a3-aab6-2da6f04ffec9 Q1 BROOKFIELD ATLANTIC CORPORATION 318094 BROOKFIELD ATLANTIC CORPORATION 2011 first_quarter INT Brookfield Atlantic Corporation is currently lobbying the DARPA to fund a research based Sea Mine for the US Navy and NSA Air Force, Dept of,Central Intelligence Agency (CIA),Defense Advanced Research Projects Agency (DARPA),Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Natl Geospatial Intelligence Agency,Natl Security Agency (NSA),Navy, Dept of,SENATE   360000 0 0 2011-03-11T08:54:34.360000-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 2746.028ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API