lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
31 rows where filing_uuid = "0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: received_date (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 171271 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | RRR | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171272 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | BAN | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171273 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | MAN | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171274 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | DEF | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171275 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | ALC | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171276 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | FIN | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171277 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | ROD | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171278 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | AER | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171279 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | TRA | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171280 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | WAS | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171281 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | ECN | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171282 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | HCR | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171283 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | MMM | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171284 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | MAR | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171285 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | HOU | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171286 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | BUD | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171287 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | DOC | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171288 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | ENV | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171289 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | AVI | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171290 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | GOV | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171291 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | ART | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171292 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | SCI | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171293 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | NAT | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171294 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | ADV | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171295 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | TAX | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171296 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | ENG | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171297 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | EDU | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171298 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | CPI | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171299 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | MED | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171300 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | DIS | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 171301 | VAN SCOYOC ASSOCIATES 0b25f97e-e3f9-48a5-9cbb-5a996d2b68fd | MM | VAN SCOYOC ASSOCIATES | 39837 | UNIVERSITY OF CONNECTICUT | 2002 | mid_year | TEC | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 80000 | 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,
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);