home / lobbying / lobbying_filings_raw

lobbying_filings_raw: cb02284f-ddef-41d7-b122-eab14972f2ac

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
cb02284f-ddef-41d7-b122-eab14972f2ac Q3 400652960 CCAP ACTION FUND 193855 CCAP ACTION FUND 2010 third_quarter 2010-10-15T13:57:42.317000-04:00 10000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/cb02284f-ddef-41d7-b122-eab14972f2ac/", "filing_uuid": "cb02284f-ddef-41d7-b122-eab14972f2ac", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2010, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/cb02284f-ddef-41d7-b122-eab14972f2ac/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "10000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Marielle Walter", "dt_posted": "2010-10-15T13:57:42.317000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "750 1st Street, NE", "registrant_address_2": "Suite 940", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20002", "registrant": {"id": 400652960, "url": "https://lda.senate.gov/api/v1/registrants/400652960/", "house_registrant_id": null, "name": "CCAP ACTION FUND", "description": "Climate change and clean air policy", "address_1": "750 1st Street NE", "address_2": "Suite 940", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20002", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MARIELLE WALTER", "contact_telephone": "+1 202-408-9260", "dt_updated": "2022-04-06T16:06:44.756034-04:00"}, "client": {"id": 193855, "url": "https://lda.senate.gov/api/v1/clients/193855/", "client_id": 12, "name": "CCAP ACTION FUND", "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": "2010-09-01"}, "lobbying_activities": [{"general_issue_code": "FOR", "general_issue_code_display": "Foreign Relations", "description": "Providing input to the Senate Foreign Relations Committee on all sections of S. 2835 (International Climate Change Investment Act of 2009) and (the Draft American Power Act, Title V-International Climate Change Activities); General education in the Senate on the key issues in domestic legislation critical for an international agreement, as well as on actions of key developing countries and the European Union.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 52455, "prefix": null, "prefix_display": null, "first_name": "MARTIN", "nickname": null, "middle_name": null, "last_name": "SPITZER", "suffix": null, "suffix_display": null}, "covered_position": "U.S. House of Representatives", "new": true}], "government_entities": [{"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "General education on international climate negotiations, the importance of international finance for clean technology and reduced deforestation and their linkages to U.S. climate change legislation; Providing input to the draft American Power Act being prepared by Senators Kerry and Lieberman. Topics include, supplemental reductions from reduced deforestation, (Title II, Subtitle A, Part A, Sec 704); and international offsets (Part EOffset Credit Program For International Emission Reductions); International Finance (Part GDisposition Of Allowances); competitiveness for energy intensive industries (Title IV, Subtitle AProtecting American Manufacturing Jobs and Preventing Carbon Leakage); International Clean Technology Exports and developing country actions (Title VInternational Climate Change Activities); and the Renewable Electricity Standard, (Title II, Subtitle DRenewable Energy and Energy Efficiency) and (S.3464 Practical Energy and Climate Plan Act of 2010, Title III, Sec. 301, Diversified Energy Standard);", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 52455, "prefix": null, "prefix_display": null, "first_name": "MARTIN", "nickname": null, "middle_name": null, "last_name": "SPITZER", "suffix": null, "suffix_display": null}, "covered_position": "U.S. House of Representatives", "new": true}], "government_entities": [{"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "General education on international climate negotiations, the importance of international finance for clean technology and reduced deforestation and their linkages to U.S. climate change legislation; Providing input to the draft American Power Act being prepared by Senators Kerry and Lieberman. Topics include, supplemental reductions from reduced deforestation, (Title II, Subtitle A, Part A, Sec 704); and international offsets (Part EOffset Credit Program For International Emission Reductions); International Finance (Part GDisposition Of Allowances); competitiveness for energy intensive industries (Title IV, Subtitle AProtecting American Manufacturing Jobs and Preventing Carbon Leakage); International Clean Technology Exports and developing country actions (Title VInternational Climate Change Activities); and the Renewable Electricity Standard, (Title II, Subtitle DRenewable Energy and Energy Efficiency) and (S.3464 Practical Energy and Climate Plan Act of 2010, Title III, Sec. 301, Diversified Energy Standard);", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 52455, "prefix": null, "prefix_display": null, "first_name": "MARTIN", "nickname": null, "middle_name": null, "last_name": "SPITZER", "suffix": null, "suffix_display": null}, "covered_position": "U.S. House of Representatives", "new": true}], "government_entities": [{"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

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