home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 9feef2dc-e83d-46a7-88af-bb04324e7e5a

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
9feef2dc-e83d-46a7-88af-bb04324e7e5a YY 55325 ALLEGIANCE TELECOM, INC 159725 ALLEGIANCE TELECOM INC 2001 year_end 2002-02-01T00:00:00-05:00 60000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/9feef2dc-e83d-46a7-88af-bb04324e7e5a/", "filing_uuid": "9feef2dc-e83d-46a7-88af-bb04324e7e5a", "filing_type": "YY", "filing_type_display": "Year-End Report", "filing_year": 2001, "filing_period": "year_end", "filing_period_display": "Year-End (July 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/9feef2dc-e83d-46a7-88af-bb04324e7e5a/print/", "filing_document_content_type": "application/pdf", "income": "60000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2002-02-01T00:00:00-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": null, "registrant_address_2": null, "registrant_different_address": null, "registrant_city": null, "registrant_state": null, "registrant_zip": null, "registrant": {"id": 55325, "url": "https://lda.senate.gov/api/v1/registrants/55325/", "house_registrant_id": 35131, "name": "ALLEGIANCE TELECOM, INC", "description": null, "address_1": "111 SUNSET HILLS ROAD", "address_2": null, "address_3": null, "address_4": null, "city": "RESTON", "state": "VA", "state_display": "Virginia", "zip": "20109", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "", "contact_telephone": "", "dt_updated": "2022-01-13T14:53:06.920260-05:00"}, "client": {"id": 159725, "url": "https://lda.senate.gov/api/v1/clients/159725/", "client_id": 12, "name": "ALLEGIANCE TELECOM INC", "general_description": null, "client_government_entity": null, "client_self_select": null, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "TX", "ppb_state_display": "Texas", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2000-05-15"}, "lobbying_activities": [{"general_issue_code": "TEC", "general_issue_code_display": "Telecommunications", "description": "H.R. 1542, Internet Freedom and Broadband Deployment Act of 2001 \r\nH.R. 1765, a bill to increase penalties for common carrier violations of the Communications Act of 1934 and for other purposes\r\nH.R. 1698, American Broadband Competition Act of 2001\r\nH.R. 1697, Broadband Competition Incentives Act of 2001\r\nS. 1126, Broadband Deployment and Competition Enhancement Act of 2001\r\nS. 1127, Rural Broadband Deployment Act of 2001\r\nS. 1634, The Telecommunications Fair Competition Enforcement Act of 2001\r\nAny legislation pertaining to P.L.-104-104\r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 20986, "prefix": null, "prefix_display": null, "first_name": "MEGAN", "nickname": null, "middle_name": "M", "last_name": "DELANY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 33382, "prefix": null, "prefix_display": null, "first_name": "KEVIN", "nickname": null, "middle_name": "M", "last_name": "JOSEPH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 14, "name": "Council of Economic Advisers (CEA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 21, "name": "Office of Science & Technology Policy (OSTP)"}, {"id": 13, "name": "Office of the Vice President of the United States"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}, {"id": 10, "name": "Vice President of the U.S."}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} VA US 35131 DC TX US US     0        

Links from other tables

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