home / lobbying / lobbying_filings_raw

lobbying_filings_raw: f03e3a25-4fdb-4d64-be72-ca3f49cfc306

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
f03e3a25-4fdb-4d64-be72-ca3f49cfc306 Q1 5222 BALL JANIK LLP 106077 CITY OF LAS VEGAS, NEVADA 2010 first_quarter 2010-04-20T13:14:02.063000-04:00 40000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/f03e3a25-4fdb-4d64-be72-ca3f49cfc306/", "filing_uuid": "f03e3a25-4fdb-4d64-be72-ca3f49cfc306", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2010, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/f03e3a25-4fdb-4d64-be72-ca3f49cfc306/print/", "filing_document_content_type": "text/html", "income": "40000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "M. Victoria Cram - Director, Government Affairs", "dt_posted": "2010-04-20T13:14:02.063000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "1455 F Street NW Suite 225", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 5222, "url": "https://lda.senate.gov/api/v1/registrants/5222/", "house_registrant_id": 32404, "name": "BALL JANIK LLP", "description": "Law/lobby firm", "address_1": "655 F Street NW Suite 225", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20005", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "GEOFFREY URBACH", "contact_telephone": "+1 202-638-3307", "dt_updated": "2022-04-06T16:04:34.518196-04:00"}, "client": {"id": 106077, "url": "https://lda.senate.gov/api/v1/clients/106077/", "client_id": 710, "name": "CITY OF LAS VEGAS, NEVADA", "general_description": null, "client_government_entity": true, "client_self_select": false, "state": "NV", "state_display": "Nevada", "country": "US", "country_display": "United States of America", "ppb_state": "NV", "ppb_state_display": "Nevada", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-13"}, "lobbying_activities": [{"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Monitor transportation of hazardous materials legislation, economic stimulus/infrastructure funding, high speed rail legislation, AMTRAK intercity rail legislation; Surface transportation reauthorization, for highway and transit funding.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7520, "prefix": null, "prefix_display": null, "first_name": "M", "nickname": null, "middle_name": "VICTORIA", "last_name": "CRAM", "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": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "No specific issues during this reporting period.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7520, "prefix": null, "prefix_display": null, "first_name": "M", "nickname": null, "middle_name": "VICTORIA", "last_name": "CRAM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 8047, "prefix": null, "prefix_display": null, "first_name": "NORA", "nickname": null, "middle_name": "BOMAR", "last_name": "KHALIL", "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": "FIR", "general_issue_code_display": "Firearms/Guns/Ammunition", "description": "No activity in this area during this reporting period.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7520, "prefix": null, "prefix_display": null, "first_name": "M", "nickname": null, "middle_name": "VICTORIA", "last_name": "CRAM", "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": "HCR", "general_issue_code_display": "Health Issues", "description": "H.R.3590, Patient Protection and Affordable Care Act; monitor for impact on city and employees.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7520, "prefix": null, "prefix_display": null, "first_name": "M", "nickname": null, "middle_name": "VICTORIA", "last_name": "CRAM", "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": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R. 1, American Recovery and Reinvestment Act of 2009, monitor funding for municipalities and agency actions; .Departments of Transportation, and Housing and Urban Development Appropriations for FY 2011; funding for conversion of hybrids, Kyle Canyon, bus turnouts, reprogramming Bonneville Clark couplet funding, post foreclosure funding. Department of Interior Appropriations Act, FY 2011, Westside school and LWCF funding.\nEnergy and Water Appropriations Act, FY 2011, sustainable neighborhoods funding.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7520, "prefix": null, "prefix_display": null, "first_name": "M", "nickname": null, "middle_name": "VICTORIA", "last_name": "CRAM", "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": "GOV", "general_issue_code_display": "Government Issues", "description": "Monitor legislation for pre-emption of local authority, unfunded mandates", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7520, "prefix": null, "prefix_display": null, "first_name": "M", "nickname": null, "middle_name": "VICTORIA", "last_name": "CRAM", "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": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "H.R. 2454, American Clean Energy and Security Act of 2009, Monitor regarding hydrogen fuel cells and alternative fuels, plug-in hybrids, climate change, cap and trade, alternative energy, energy efficiency. Monitor legislation regarding Yucca Mountain", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7520, "prefix": null, "prefix_display": null, "first_name": "M", "nickname": null, "middle_name": "VICTORIA", "last_name": "CRAM", "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": "URB", "general_issue_code_display": "Urban Development/Municipalities", "description": "Monitor developments relating to federal pre-emption, unfunded mandates, eminent domain, and sustainable communities and sustainable policies developments.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7520, "prefix": null, "prefix_display": null, "first_name": "M", "nickname": null, "middle_name": "VICTORIA", "last_name": "CRAM", "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": "WAS", "general_issue_code_display": "Waste (hazardous/solid/interstate/nuclear)", "description": "Monitor hazardous materials transportation legislation for impact on city and Department of Energy funding for Yucca Mountain.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7520, "prefix": null, "prefix_display": null, "first_name": "M", "nickname": null, "middle_name": "VICTORIA", "last_name": "CRAM", "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": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R.760, Provide an income tax credit to holders of bonds financing new advanced broadband infrastructure.\nH.R.1560, To make the moratorium on Internet access taxes and multiple and discriminatory taxes on electronic commerce permanent. S.43, To make the moratorium on Internet access taxes and multiple and discriminatory taxes on electronic commerce permanent.H.R. 1083, Business Activity Tax Simplification Act of 2009 H.R.690, Amend the Internal Revenue Code of 1986 to remove cell phones from listed property under section 280F.\nS.144, Amend the Internal Revenue Code of 1986 to remove cell phones from listed property under section 280F.\nMonitor net neutrality legislation.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7520, "prefix": null, "prefix_display": null, "first_name": "M", "nickname": null, "middle_name": "VICTORIA", "last_name": "CRAM", "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": "DIS", "general_issue_code_display": "Disaster Planning/Emergencies", "description": "Monitor legislation on homeland Security, bioterrorism, chemical and radiation threats, pandemic flu and fire, Urban Area Security Initiative, and transportation of hazardous materials.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7520, "prefix": null, "prefix_display": null, "first_name": "M", "nickname": null, "middle_name": "VICTORIA", "last_name": "CRAM", "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": "TEC", "general_issue_code_display": "Telecommunications", "description": "Monitor spectrum reallocation, municipal broadband, franchise fees, control of rights of way, cell tower siting legislation, for impact on cities.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7520, "prefix": null, "prefix_display": null, "first_name": "M", "nickname": null, "middle_name": "VICTORIA", "last_name": "CRAM", "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": "ECN", "general_issue_code_display": "Economics/Economic Development", "description": "Monitor legislation for urban economic development, CDBG, and new market tax credit. Monitor internet and offshore gaming legislation; brownfields legislation. H.R. 2847, Hiring Incentives to Restore Employment Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7520, "prefix": null, "prefix_display": null, "first_name": "M", "nickname": null, "middle_name": "VICTORIA", "last_name": "CRAM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45072, "prefix": null, "prefix_display": null, "first_name": "HEATH", "nickname": null, "middle_name": null, "last_name": "HEIKKILA", "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": "HOU", "general_issue_code_display": "Housing", "description": "Monitor affordable housing legislation, Mortgage Reform and Anti-Predatory Lending, Foreclosure Prevention, Expanding American Home Ownership, H.R.4868, Housing Preservation and Tenant Protection Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7520, "prefix": null, "prefix_display": null, "first_name": "M", "nickname": null, "middle_name": "VICTORIA", "last_name": "CRAM", "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": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "S. 787, Clean Water Restoration Act, monitor provisions for impact on municipalities. Monitor legislation on combined sewer overlow control and sewer/drinking water infrastructure legislation for impact on municipalities.\nH.R.753, Amend the Federal Water Pollution Control Act to ensure that publicly owned treatment works monitor for and report sewer overflows; H.R.895, Amend the Federal Water Pollution Control Act to reauthorize the sewer overflow control grants program\nH.R. 1262, Water Quality Investment Act of 2009", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7520, "prefix": null, "prefix_display": null, "first_name": "M", "nickname": null, "middle_name": "VICTORIA", "last_name": "CRAM", "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": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "Monitor legislation regarding COPS, Fusion centers, .Interoperability, Emergency Operations Center funding, Federal false claims.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7520, "prefix": null, "prefix_display": null, "first_name": "M", "nickname": null, "middle_name": "VICTORIA", "last_name": "CRAM", "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": "RES", "general_issue_code_display": "Real Estate/Land Use/Conservation", "description": "Monitor eminent domain legislation, public lands legislation; H.R.627, S. 235, Amend the Truth in Lending Act to establish fair and transparent practices relating to the extension of credit under an open end consumer credit plan. H.R.1885, Protect private property rights", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7520, "prefix": null, "prefix_display": null, "first_name": "M", "nickname": null, "middle_name": "VICTORIA", "last_name": "CRAM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45072, "prefix": null, "prefix_display": null, "first_name": "HEATH", "nickname": null, "middle_name": null, "last_name": "HEIKKILA", "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": []} DC US 32404 NV NV US US   1 0        

Links from other tables

  • 17 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.988ms