EXEC_OUTREACH_TABLE

This table provides methods of outreach for hospital and health system executives, including email, LinkedIn and role context.

Queries that source from EXEC_OUTREACH_TABLE table

• execOutreach

What is in the EXEC_OUTREACH_TABLE table?

Results are returned as a json, pySpark DataFrame, or pandas DataFrame (default).

feature	description	example
exec_name	Full name of the executive record	daniel giang
hospital	Primary hospital/system associated with the executive record	loma linda university medical center
title	Role title associated with the hospital/system executive record	vice president of graduate medical education
department	Departmental affiliation with the role of the executive record	administrative
exec_level	Administrative level of the executive record	vice president
email1	Primary email address of the hospital/system executive record	[email protected]
email2	Secondary email address of the hospital/system executive record
address	Primary address of the hospital/system executive record	11234 anderson st
city	City for the primary address of the hospital/system executive record	loma linda
state	US State code for the primary address of the hospital/system executive record	CA
zip	Zip code for the primary address of the hospital/system executive record	92354
phone	Primary phone number of the hospital/system executive record	909-558-4000
linkedin	LinkedIn URL for the hospital/system executive record	https://www.linkedin.com/in/daniel-giang-84227085/
npi	National Provider Identifier (NPI) if executive is an NPPES registered healthcare provider	1568492635
org_url	Organizational website most closely associated with the executive record	llu.edu
system_exec	Biary indicator of whether the executive is at the hospital or health system administrative level	0
update_date	The last date in which the hospital executive contact details have been updated	2023-09-01

Helper Function within the CareQuery API to help understand the underlying EXEC_OUTREACH_TABLE dataset.

Python

# import package
from care_query.care_query import CareQuery

# instantiate and connect
cq = CareQuery(email = "your-email", 
               token = "your-api-token")

# return details 
print(cq.glossary.table_detail('EXEC_OUTREACH_TABLE'))