home / lobbying / lobbying_filings_raw

lobbying_filings_raw: ee05f463-ce83-46bf-baaa-4bada69dc7b8

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
ee05f463-ce83-46bf-baaa-4bada69dc7b8 Q4 27707 NATIONAL COURT REPORTERS ASSOCIATION 134311 NATIONAL COURT REPORTERS ASSOCIATION 2017 fourth_quarter 2018-01-02T11:30:51.517000-05:00   0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/ee05f463-ce83-46bf-baaa-4bada69dc7b8/", "filing_uuid": "ee05f463-ce83-46bf-baaa-4bada69dc7b8", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2017, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/ee05f463-ce83-46bf-baaa-4bada69dc7b8/print/", "filing_document_content_type": "text/html", "income": null, "expenses": null, "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Matthew Barusch", "dt_posted": "2018-01-02T11:30:51.517000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "12030 Sunrise Valley Drive", "registrant_address_2": "Suite 400", "registrant_different_address": false, "registrant_city": "RESTON", "registrant_state": "VA", "registrant_zip": "20191", "registrant": {"id": 27707, "url": "https://lda.senate.gov/api/v1/registrants/27707/", "house_registrant_id": 30375, "name": "NATIONAL COURT REPORTERS ASSOCIATION", "description": null, "address_1": "12355 Sunrise Valley Drive", "address_2": "Suite 610", "address_3": null, "address_4": null, "city": "RESTON", "state": "VA", "state_display": "Virginia", "zip": "20191", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "COLIN BREHM", "contact_telephone": "+1 703-584-9042", "dt_updated": "2026-01-15T14:19:17.028751-05:00"}, "client": {"id": 134311, "url": "https://lda.senate.gov/api/v1/clients/134311/", "client_id": 12, "name": "NATIONAL COURT REPORTERS ASSOCIATION", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "VA", "state_display": "Virginia", "country": "US", "country_display": "United States of America", "ppb_state": "VA", "ppb_state_display": "Virginia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2008-02-12"}, "lobbying_activities": [{"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "NCRA is currently working on several issues related to the Higher Education Act and the Perkins loan program. in particular, NCRA is lobbying for the reauthorization of the Training for Realtime Writers competitive grant program. The program allows realtime reporting and captioning programs to apply for a grant which they can use to train more realtime ready cpationers and court reporters. NCRA is also monitoring several issues related to program accreditation.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64703, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "BARUSCH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "NCRA is advocating for the Local Courthouse Safety Act, most recently introduced in the 114th Congress as H.R. 1566. This legislation will distribute surplus security equipment to courthouses that do not have metal detectors, wands or baggage screening devices. It also allows for several grants to be used for court safety training programs.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64703, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "BARUSCH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "COM", "general_issue_code_display": "Communications/Broadcasting/Radio/TV", "description": "NCRA has been working on the issue of broadcast captioning quality with the FCC. We also have been working with the FCC's Disability Advisory Committee (specifically the Video Programming Subcommittee) on issues related to accessibility for individuals who are deaf and hard of hearing. Further, NCRA is looking into how captioning will play into the newest version of the Telecommunications Act with Congress and would like to see the number of media markets that mandate closed captioning expanded beyond the top 25. Additionally, NCRA is in favor of expanding online captioning through a new version of the Telecommunications Act. NCRA is also working with the FCC on the issue of POTS lines being replaced with higher speed IP lines.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64703, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "BARUSCH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} VA US 30375 VA VA US US   0 0 575954   normalized_name_state 0.9

Links from other tables

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