lobbying_filings_raw: a7d486ef-d4d9-4d9a-a04d-e6ccd2489d9e
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| a7d486ef-d4d9-4d9a-a04d-e6ccd2489d9e | Q2 | 401103542 | HETTINGER STRATEGY GROUP LLC | 199449 | RED HAT, INC. | 2021 | second_quarter | 2021-07-13T16:26:56.643000-04:00 | 20000.0 | 0 | 0 | 0 | {"url": "https://lda.senate.gov/api/v1/filings/a7d486ef-d4d9-4d9a-a04d-e6ccd2489d9e/", "filing_uuid": "a7d486ef-d4d9-4d9a-a04d-e6ccd2489d9e", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2021, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/a7d486ef-d4d9-4d9a-a04d-e6ccd2489d9e/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Michael J Hettinger", "dt_posted": "2021-07-13T16:26:56.643000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "47484 Saulty Drive", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Potomac Falls", "registrant_state": "VA", "registrant_zip": "20165", "registrant": {"id": 401103542, "url": "https://lda.senate.gov/api/v1/registrants/401103542/", "house_registrant_id": null, "name": "HETTINGER STRATEGY GROUP LLC", "description": "Lobbying and market advisory firm.", "address_1": "47484 Saulty Drive", "address_2": null, "address_3": null, "address_4": null, "city": "Potomac Falls", "state": "VA", "state_display": "Virginia", "zip": "20165", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MICHAEL HETTINGER", "contact_telephone": "+1 703-254-6257", "dt_updated": "2026-01-20T11:00:38.928263-05:00"}, "client": {"id": 199449, "url": "https://lda.senate.gov/api/v1/clients/199449/", "client_id": 137, "name": "RED HAT, INC.", "general_description": "Application and Software Development.", "client_government_entity": false, "client_self_select": null, "state": "NC", "state_display": "North Carolina", "country": "US", "country_display": "United States of America", "ppb_state": "NC", "ppb_state_display": "North Carolina", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2019-06-15"}, "lobbying_activities": [{"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "Issues related to government's use of enterprise open source software\nImplementation of FITARA\nIssues related to government's adoption of cloud computing\nIssues related to government acquisition (no specific legislation)\nHR21 the FedRAMP Authorization Act of 2021", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138345, "prefix": "mr", "prefix_display": "MR.", "first_name": "MICHAEL", "nickname": null, "middle_name": "J", "last_name": "HETTINGER", "suffix": null, "suffix_display": null}, "covered_position": "Staff Director, House Committee on Oversight, Subcommittee on Government Management (2003-07); Chief of Staff, former Rep. Tom Davis (VA) (1998-99).", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} | VA | US | NC | NC | US | US | Application and Software Development. | 0 | 0 | 1943738 | normalized_name | 0.7 |