lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
17 rows where filing_uuid = "dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 764257 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb | Q1 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS | 35070 | INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS | 2009 | first_quarter | MMM | medicare rx coverage S.1/H.R. 1 minimum wage bill H.R. 2429/S.2725 raising the minimum wage minimum wge/tax relief H.R. 1591, H.R. 976 & H.R. 2 | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2009-04-20T11:23:56-04:00 | |
| 764258 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb | Q1 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS | 35070 | INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS | 2009 | first_quarter | MAR | united states cruise vessel acat S.127/H.R. 2901 | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2009-04-20T11:23:56-04:00 | |
| 764259 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb | Q1 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS | 35070 | INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS | 2009 | first_quarter | DEF | coast guard authorization bill S. 951 natural defense authorization acat for 2004 H.R. 1588 marad authorization S. 1262 navel vessel delivery method of account S.774, H.R. 1479 fy2005 defense authorization bill (miliatry vase security) fy2005 departmetn fo defense appropriation(helmets to hardhats) appropriations for department of defense - 2006 navy shipbuilgin budget naval force structure police act-H.R. 375/S.902 naval vessel delivery method of accounting S. 774 | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2009-04-20T11:23:56-04:00 | |
| 764260 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb | Q1 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS | 35070 | INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS | 2009 | first_quarter | RET | pension preservation & savings expansion acat 2003 H.R. 1776/S.2264/S.2233/H.R. 3108 employee retirment security action of 1974 H.R. 525/S.406 pension system overhaul-multi employer pension fund reform H.R. 2830 pension reform bills H.R. 280/S.1783 pension bill H.R. 2830/H.R. 4/S. 1783 | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2009-04-20T11:23:56-04:00 | |
| 764261 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb | Q1 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS | 35070 | INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS | 2009 | first_quarter | GOV | reform act H.R. 1316/S.271 | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2009-04-20T11:23:56-04:00 | |
| 764262 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb | Q1 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS | 35070 | INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS | 2009 | first_quarter | ENG | energy bill H.R. 4 energy employers occupational illness compensation illness act comprehensive energy legislation H.R. 6 energy bille H.R. 6 | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2009-04-20T11:23:56-04:00 | |
| 764263 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb | Q1 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS | 35070 | INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS | 2009 | first_quarter | IMM | foreign workers H.R. 2899/S.1461 secure america & orderly immigration of 205 S.1033/H.R. 230 immigration S.2611 & H.R. 4437 immigration S.1639 & H.R. 1645 & S. 1348 H-1B Visas s.32,S.1083,S.1092,S.1351 & H.R. 1930 | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2009-04-20T11:23:56-04:00 | |
| 764264 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb | Q1 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS | 35070 | INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS | 2009 | first_quarter | LBR | training & eduction for american workers act H.R. 4402 prevention OSHA action of ergonomics H.R. 987/S.1070 barring OSHA home office inspections H.R. 4098 bid shopping repeal H.R. 4012 minimum wage act H.R. 655/S.277 fair acat H.R. 19 national labaor relations act H.R. 1696/S.842 occupational safety & helath small employer of justice act H.R. 739/H.R. 741/H.R.740 & H.R. 742 keller bill - recreational marine employment act of 2005 H.R. 940 truth in employment act H.R. 1816 employee right to choose act S. 1513/H.R. 3763 davis bacon act S.187/S.1749/H.R. 3763 reveiw of OSHA citation H.R. 741 deadline flexibility - OSHA review commission H.R. 739 job training S.1021/H.R. 27 (reauthoirize workforce investment act) employee free choice act H.R. 800 & S. 1041 | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2009-04-20T11:23:56-04:00 | |
| 764265 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb | Q1 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS | 35070 | INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS | 2009 | first_quarter | CAW | water quality financial act H.R. 3930 clean water infrastructure and security improvement act H.R. 3792 energy & water development H.R. 2765 calfed -bay/delta H.R. 2828 | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2009-04-20T11:23:56-04:00 | |
| 764266 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb | Q1 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS | 35070 | INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS | 2009 | first_quarter | TRD | central american freetrade agreement | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2009-04-20T11:23:56-04:00 | |
| 764267 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb | Q1 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS | 35070 | INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS | 2009 | first_quarter | RRR | railroad track modernization bill S. 1220 national defense rail acat S. 1991 house rail bills H.R. 1020/Ride 21/H.R. 2950 railroad safety improvement H.R. 2095 | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2009-04-20T11:23:56-04:00 | |
| 764268 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb | Q1 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS | 35070 | INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS | 2009 | first_quarter | MAN | fsc repeal/manufacaturing tax act credit H.R. 1769 | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2009-04-20T11:23:56-04:00 | |
| 764269 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb | Q1 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS | 35070 | INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS | 2009 | first_quarter | ACC | Accounting Issues (no specific bill) | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2009-04-20T11:23:56-04:00 | |
| 764270 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb | Q1 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS | 35070 | INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS | 2009 | first_quarter | GAM | H.R. 4115 & J.R. 2176- Indian Land Swap Bill | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2009-04-20T11:23:56-04:00 | |
| 764271 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb | Q1 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS | 35070 | INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS | 2009 | first_quarter | TRA | transportation equity act of teh 21st century- ISTEA surface transportaion law (TEA-21) TWIC /port security highway & mass transit reauthorization act H.R. 3 | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2009-04-20T11:23:56-04:00 | |
| 764272 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb | Q1 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS | 35070 | INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS | 2009 | first_quarter | HCR | radiation exposure compensation S.1515 health care safety net amendments S,.1281 assocation health plans H.R. 660/S.545 asbestos compensation reform S.2290 asbestos litigation S.853 & H.R.1360 asbestos litigation S.3274 & H.R. 1360 | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2009-04-20T11:23:56-04:00 | |
| 764273 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb | Q1 | INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS | 35070 | INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS | 2009 | first_quarter | EDU | school construction H.R. 1076 | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2009-04-20T11:23:56-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);