home / lobbying / lobbying_filings_raw

lobbying_filings_raw: e75fb4a3-dd2c-4fe6-a1a1-178e22e4eabf

Raw lobbying disclosure filings from the Senate Office of Public Records (SOPR). Each row is a single filing — registrations, quarterly reports, amendments, and terminations. Includes registrant and client names, reported income/expenses, filing period, and the full raw JSON from the API.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date amount_reported is_amendment is_no_activity is_termination raw_json registrant_state registrant_country registrant_house_id client_state client_ppb_state client_country client_ppb_country client_general_description client_government_entity affiliated_org_count client_entity_id client_government_unit_id client_match_method client_match_confidence
e75fb4a3-dd2c-4fe6-a1a1-178e22e4eabf Q4 36856 CHICAGO BRIDGE & IRON COMPANY N.V. 145892 CHICAGO BRIDGE & IRON COMPANY N V 2011 fourth_quarter 2012-01-19T15:00:42-05:00 410000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/e75fb4a3-dd2c-4fe6-a1a1-178e22e4eabf/", "filing_uuid": "e75fb4a3-dd2c-4fe6-a1a1-178e22e4eabf", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2011, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/e75fb4a3-dd2c-4fe6-a1a1-178e22e4eabf/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "410000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Stephen M. Marlo - Vice President, Government Affairs", "dt_posted": "2012-01-19T15:00:42-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1050 K Street, NW", "registrant_address_2": "SUITE 620", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 36856, "url": "https://lda.senate.gov/api/v1/registrants/36856/", "house_registrant_id": 30588, "name": "CHICAGO BRIDGE & IRON COMPANY N.V.", "description": null, "address_1": "1050 K Street, NW", "address_2": "SUITE 620", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20001", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "STEPHEN M. MARLO", "contact_telephone": "+1 202-261-1909", "dt_updated": "2022-04-06T16:07:32.161499-04:00"}, "client": {"id": 145892, "url": "https://lda.senate.gov/api/v1/clients/145892/", "client_id": 12, "name": "CHICAGO BRIDGE & IRON COMPANY N V", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-02"}, "lobbying_activities": [{"general_issue_code": "DIS", "general_issue_code_display": "Disaster Planning/Emergencies", "description": "- Issues associated with disaster mitigation and rebuilding in Japan following earthquake and tsunami.\n- Issues associated with finalization of FEMA contract.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8377, "prefix": null, "prefix_display": null, "first_name": "STEPHEN", "nickname": null, "middle_name": null, "last_name": "MARLO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R. 3630 Temporary Payroll Tax Cut Continuation Act of 2011, H.R. 3366 a bill to amend the Internal Revenue Code of 1986 to clarify that bonus depreciation is not a cost allocated to a contract under the percentage of completion method for long-term contracts, and S. 1873 Bonus Depreciation and Small Business Expense Extension Act - Issues relating to the extension of bonus depreciation", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8377, "prefix": null, "prefix_display": null, "first_name": "STEPHEN", "nickname": null, "middle_name": null, "last_name": "MARLO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "H.R. 1540 and S. 1867 National Defense Authorization Act for Fiscal Year 2012: Issues regarding authorization of MOX FFF and related facilities, and Yucca Mountain.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8377, "prefix": null, "prefix_display": null, "first_name": "STEPHEN", "nickname": null, "middle_name": null, "last_name": "MARLO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "- Issues associated with commercial nuclear loan guarantees, commercial nuclear power, new commercial nuclear facilities in the U.S. and abroad, Clean Coal Power Initiative, storage of nuclear waste, proposed regulations that implement the Convention on Supplementary Compensation, and engineering, design, construction, operations, and maintenance of projects at the Dept. of Energy. - Issues associated with H.R. 1280 To amend the Atomic Energy Act of 1954 to require congressional approval of agreements for peaceful nuclear cooperation with foreign countries, and for other purposes.\n- Issues associated with the Department of Energy proposed rule to amend 10 CFR Part 810, Assistance to Foreign Atomic Energy Activities.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8377, "prefix": null, "prefix_display": null, "first_name": "STEPHEN", "nickname": null, "middle_name": null, "last_name": "MARLO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R. 2354 Energy & Water Appropriations for Fiscal Year 2012 and H.R. 2055 Consolidated Appropriations Act, 2012: Issues regarding funding for; Mixed Oxide Fuel Fabrication Facility and related facilities, Loan Guarantee Program, Environmental Management Program, Yucca Mountain, Army Corps of Engineers, and Nuclear Energy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8377, "prefix": null, "prefix_display": null, "first_name": "STEPHEN", "nickname": null, "middle_name": null, "last_name": "MARLO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 30588 DC DC US US   0 0        

Links from other tables

  • 5 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.97ms