home / lobbying / lobbying_filings_raw

lobbying_filings_raw: ae1e479d-e34b-498e-88b9-e35c8fcf13f7

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
ae1e479d-e34b-498e-88b9-e35c8fcf13f7 Q3 261 THE ADVOCACY GROUP 100262 SMALL BUSINESS INVESTOR ALLIANCE (FORMERLY NASBIC) 2010 third_quarter 2010-10-19T15:44:40.067000-04:00 20000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/ae1e479d-e34b-498e-88b9-e35c8fcf13f7/", "filing_uuid": "ae1e479d-e34b-498e-88b9-e35c8fcf13f7", "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/ae1e479d-e34b-498e-88b9-e35c8fcf13f7/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Robert J. Dotchin, Partner", "dt_posted": "2010-10-19T15:44:40.067000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1333 H. Street NW", "registrant_address_2": "Suite 500 West", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 261, "url": "https://lda.senate.gov/api/v1/registrants/261/", "house_registrant_id": 30018, "name": "THE ADVOCACY GROUP", "description": "Lobbying", "address_1": "414 3rd Street S.E.", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20003", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "GEORGE A. RAMONAS", "contact_telephone": "+1 202-255-1406", "dt_updated": "2025-07-06T00:43:13.751626-04:00"}, "client": {"id": 100262, "url": "https://lda.senate.gov/api/v1/clients/100262/", "client_id": 253, "name": "SMALL BUSINESS INVESTOR ALLIANCE (FORMERLY NASBIC)", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "1950-12-30"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Provisions relating to the treatment of partnership carried interests. \nHR 4849 Small Business and Infrastructure Jobs Tax of 2010, provision relating to 100 percent exclusion of Small Business Capital Gains.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46308, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": "J", "last_name": "DOTCHIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "HR 3818 Private Fund Investment Advisors Regulation Act of 2009, Section 3.\nHR 4173 The Wall Street Reform and Consumer Protection Act of 2009, Section 5003, relating to SEC registration by Small Business Investment Companies.\nTitle VI Improvement to Regulation of Bank and Savings Associations Holding Companies and Depository\nInstitutions.\nS.3127 Restoring American Financial Stability Act of 2010, Section 403, exemption from SEC registration.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46308, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": "J", "last_name": "DOTCHIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "SMB", "general_issue_code_display": "Small Business", "description": "Reauthorization of SBIC Debenture program for FY 2010, 2011.\nEstablishment of Small Business Growth Capital Program.\nImplementation of Section 505 of HR 1, American Recovery and Reinvestment Act of 2009.\nHR 3738 Small Business Early Stage Investment Act of 2009.\nHR 3740 Small Business Investment Company Modernization Act of 2009. HR 3854 Small Business Financing and Investment Act of 2009, Title IV, Small Business Investment Company Program.\nHR 3854 Small Business Financing and Investment Act of 2009, Title VII, Small Business Early Stage Investment Program.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46308, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": "J", "last_name": "DOTCHIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"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 12.488ms