home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 19e29be9-b5ac-4058-92c6-07da9f64537c

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
19e29be9-b5ac-4058-92c6-07da9f64537c Q4 318094 BROOKFIELD ATLANTIC CORPORATION 186224 BROOKFIELD ATLANTIC CORPORATION 2011 fourth_quarter 2011-01-08T18:42:41.690000-05:00 550000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/19e29be9-b5ac-4058-92c6-07da9f64537c/", "filing_uuid": "19e29be9-b5ac-4058-92c6-07da9f64537c", "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/19e29be9-b5ac-4058-92c6-07da9f64537c/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "550000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Wayne C. Montgomery", "dt_posted": "2011-01-08T18:42:41.690000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United Kingdom", "registrant_address_1": "581 Boylston Street", "registrant_address_2": "Suite 707C", "registrant_different_address": false, "registrant_city": "Boston", "registrant_state": "MA", "registrant_zip": "02116", "registrant": {"id": 318094, "url": "https://lda.senate.gov/api/v1/registrants/318094/", "house_registrant_id": 39416, "name": "BROOKFIELD ATLANTIC CORPORATION", "description": "Engineering , Defense and Public Affairs firm", "address_1": "581 Boylston Street", "address_2": "Suite 707C", "address_3": "London", "address_4": "W1U4AA", "city": "Boston", "state": "MA", "state_display": "Massachusetts", "zip": "02116-3626", "country": "US", "country_display": "United States of America", "ppb_country": "GB", "ppb_country_display": "United Kingdom", "contact_name": "MR. CHRISTOPHER MONTGOMERY", "contact_telephone": "+1 617-867-9000", "dt_updated": "2022-04-06T16:08:13.481898-04:00"}, "client": {"id": 186224, "url": "https://lda.senate.gov/api/v1/clients/186224/", "client_id": 12, "name": "BROOKFIELD ATLANTIC CORPORATION", "general_description": "Engaged in the investment and management of Industrial Development projects", "client_government_entity": false, "client_self_select": true, "state": "MA", "state_display": "Massachusetts", "country": "US", "country_display": "United States of America", "ppb_state": "MA", "ppb_state_display": "Massachusetts", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-07-02"}, "lobbying_activities": [{"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "Lobbied the US Department of Defense to take over major US defense projects (R&D) that can not be completed with U.S. Public funds due to deficit reduction as well the firm lobbied the NSA & CIA to sell stakes and interest in major satellite programs.", "foreign_entity_issues": "Brookfield Atlantic Limited a British Export Management & Foreign Relations firm seeks equitable compensation for extending capital to needed projects that the US military may need access to in the future as well the firm looks to capitolize on the technology from these projects.", "lobbyists": [{"lobbyist": {"id": 49299, "prefix": "mr", "prefix_display": "MR.", "first_name": "WAYNE", "nickname": null, "middle_name": "CHRISTOPHER", "last_name": "MONTGOMERY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 52838, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "DUNN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 44, "name": "Central Intelligence Agency (CIA)"}, {"id": 116, "name": "Defense Advanced Research Projects Agency (DARPA)"}, {"id": 229, "name": "Defense Business Transformation Agency (BTA)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 215, "name": "Director of National Intelligence (ODNI)"}, {"id": 108, "name": "Economic Development Administration"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 126, "name": "Natl Geospatial Intelligence Agency"}, {"id": 127, "name": "Natl Security Agency (NSA)"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 210, "name": "U.S. Marines"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 1 row from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 39.814ms