lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
27 rows where filing_uuid = "82b9c564-1ce1-466e-90aa-bc33cd745480" sorted by filing_year descending
This data as json, CSV (advanced)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 169879 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | BUD | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169880 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | ENV | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169881 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | SPO | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169882 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | AVI | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169883 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | GOV | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169884 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | TRD | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169885 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | DEF | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169886 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | FIN | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169887 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | UTI | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169888 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | TRA | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169889 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | TAX | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169890 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | DIS | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169891 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | GAM | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169892 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | TEC | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169893 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | CPT | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169894 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | HCR | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169895 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | FOR | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169896 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | MMM | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169897 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | MAR | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169898 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | HOU | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169899 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | ENG | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169900 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | IMM | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169901 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | FOO | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169902 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | LBR | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169903 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | IND | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169904 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | NAT | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 | |
| 169905 | GREENBERG TRAURIG, LLP 82b9c564-1ce1-466e-90aa-bc33cd745480 | MMY | GREENBERG TRAURIG, LLP | 16896 | CELLAR DOOR AMPHITHEATERS | 2002 | mid_year | RES | Army, Dept of (Corps of Engineers),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Intl Trade Administration (ITA),Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 0 | 0 | 2002-08-14T00:00:00-04:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE lobbying_activities (
id INTEGER PRIMARY KEY,
filing_uuid TEXT NOT NULL,
filing_type TEXT NOT NULL,
registrant_name TEXT NOT NULL,
registrant_id INTEGER,
client_name TEXT NOT NULL,
filing_year INTEGER NOT NULL,
filing_period TEXT NOT NULL,
issue_code TEXT,
specific_issues TEXT,
government_entities TEXT,
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);