lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
12 rows where filing_uuid = "d0d2357f-6df4-4dd0-bfa9-2f93d26d0c65" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49252 | ERVIN GRAVES STRATEGY GROUP, LLC d0d2357f-6df4-4dd0-bfa9-2f93d26d0c65 | MM | ERVIN GRAVES STRATEGY GROUP, LLC | 13836 | LOCKHEED MARTIN CORPORATION | 2000 | mid_year | TRD | Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Postal Service (USPS) | 0 | 0 | 2000-07-26T00:00:00-04:00 | |
| 49253 | ERVIN GRAVES STRATEGY GROUP, LLC d0d2357f-6df4-4dd0-bfa9-2f93d26d0c65 | MM | ERVIN GRAVES STRATEGY GROUP, LLC | 13836 | LOCKHEED MARTIN CORPORATION | 2000 | mid_year | DEF | Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Postal Service (USPS) | 0 | 0 | 2000-07-26T00:00:00-04:00 | |
| 49254 | ERVIN GRAVES STRATEGY GROUP, LLC d0d2357f-6df4-4dd0-bfa9-2f93d26d0c65 | MM | ERVIN GRAVES STRATEGY GROUP, LLC | 13836 | LOCKHEED MARTIN CORPORATION | 2000 | mid_year | AER | Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Postal Service (USPS) | 0 | 0 | 2000-07-26T00:00:00-04:00 | |
| 49255 | ERVIN GRAVES STRATEGY GROUP, LLC d0d2357f-6df4-4dd0-bfa9-2f93d26d0c65 | MM | ERVIN GRAVES STRATEGY GROUP, LLC | 13836 | LOCKHEED MARTIN CORPORATION | 2000 | mid_year | TRA | Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Postal Service (USPS) | 0 | 0 | 2000-07-26T00:00:00-04:00 | |
| 49256 | ERVIN GRAVES STRATEGY GROUP, LLC d0d2357f-6df4-4dd0-bfa9-2f93d26d0c65 | MM | ERVIN GRAVES STRATEGY GROUP, LLC | 13836 | LOCKHEED MARTIN CORPORATION | 2000 | mid_year | MAR | Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Postal Service (USPS) | 0 | 0 | 2000-07-26T00:00:00-04:00 | |
| 49257 | ERVIN GRAVES STRATEGY GROUP, LLC d0d2357f-6df4-4dd0-bfa9-2f93d26d0c65 | MM | ERVIN GRAVES STRATEGY GROUP, LLC | 13836 | LOCKHEED MARTIN CORPORATION | 2000 | mid_year | ENV | Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Postal Service (USPS) | 0 | 0 | 2000-07-26T00:00:00-04:00 | |
| 49258 | ERVIN GRAVES STRATEGY GROUP, LLC d0d2357f-6df4-4dd0-bfa9-2f93d26d0c65 | MM | ERVIN GRAVES STRATEGY GROUP, LLC | 13836 | LOCKHEED MARTIN CORPORATION | 2000 | mid_year | ENG | Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Postal Service (USPS) | 0 | 0 | 2000-07-26T00:00:00-04:00 | |
| 49259 | ERVIN GRAVES STRATEGY GROUP, LLC d0d2357f-6df4-4dd0-bfa9-2f93d26d0c65 | MM | ERVIN GRAVES STRATEGY GROUP, LLC | 13836 | LOCKHEED MARTIN CORPORATION | 2000 | mid_year | CPI | Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Postal Service (USPS) | 0 | 0 | 2000-07-26T00:00:00-04:00 | |
| 49260 | ERVIN GRAVES STRATEGY GROUP, LLC d0d2357f-6df4-4dd0-bfa9-2f93d26d0c65 | MM | ERVIN GRAVES STRATEGY GROUP, LLC | 13836 | LOCKHEED MARTIN CORPORATION | 2000 | mid_year | SCI | Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Postal Service (USPS) | 0 | 0 | 2000-07-26T00:00:00-04:00 | |
| 49261 | ERVIN GRAVES STRATEGY GROUP, LLC d0d2357f-6df4-4dd0-bfa9-2f93d26d0c65 | MM | ERVIN GRAVES STRATEGY GROUP, LLC | 13836 | LOCKHEED MARTIN CORPORATION | 2000 | mid_year | TEC | Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Postal Service (USPS) | 0 | 0 | 2000-07-26T00:00:00-04:00 | |
| 49262 | ERVIN GRAVES STRATEGY GROUP, LLC d0d2357f-6df4-4dd0-bfa9-2f93d26d0c65 | MM | ERVIN GRAVES STRATEGY GROUP, LLC | 13836 | LOCKHEED MARTIN CORPORATION | 2000 | mid_year | HCR | Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Postal Service (USPS) | 0 | 0 | 2000-07-26T00:00:00-04:00 | |
| 49263 | ERVIN GRAVES STRATEGY GROUP, LLC d0d2357f-6df4-4dd0-bfa9-2f93d26d0c65 | MM | ERVIN GRAVES STRATEGY GROUP, LLC | 13836 | LOCKHEED MARTIN CORPORATION | 2000 | mid_year | POS | Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Postal Service (USPS) | 0 | 0 | 2000-07-26T00: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);