execOutreach
Query to specify data request for executive email, phone and address data - including context around their role and seniority.
Get Started with execOutreach
If you have already setup CareQuery, run the below code to get started with your first execOutreach query.
Example:
Request contact details for finance senior executives associated with Redlands and Riverside hospitals.
# import package
from care_query.care_query import CareQuery
# instantiate and connect
cq = CareQuery(email = "your-email",
token = "your-api-token")
# construct query
query = cq.execOutreach(hospital = ["redlands community hospital",
"riverside university health system medical center"],
exec_level = ["c suite","vice president"],
department = "finance")
# estimate query size (optional)
estimate = query.estimate()
# return query sample data (optional)
sample = query.sample()
# execute query to return results
data = query.execute()
Query Parameters
The following a parameters are available within the execOutreach query, including details on the parameter values.
| parameter | description | options |
|---|---|---|
hospital | Primary hospital affiliated with the executive record | values available |
exec_level | Adiministrative level associated with the executive's role | values available |
department | Functional department associated with the executive's role | values available |
npi | National Provider Identifier (NPI) of individual and organizational provider record | Any valid National Provider Identifier (NPI) |
state | US State code of the individual provider record | values available |
division | US State Division code of the individual provider record | values available |
region | US State Region code of the individual provider record | values available |
short_zip | First three digits of zip code for the individual provider record | First three digits of any valid zip code |
limit | Number of rows returned in the data request | Integer or False |
show | Binary indicator as to whether you'd like query to be printed for review upon query creation | True or False |
Query Return Data
The execOutreach query returns the EXEC_OUTREACH_TABLE for all executives that meet the criterion specified within the query.
| 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 | [email protected] |
| 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 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 |
The EXEC_OUTREACH_TABLE offers executive contact information including descriptions, categorial mappings of their roles.
Advanced Query Logic & Recipes
execOutreach gives users categorical groupings for ease of use, as well as SQL-like capabilities to tactfully specify AND and OR logic, right within the CareQuery API!
execOutreach does not allow for nested lists within the query parameters
Please reference the following resources to better understand how to create rockstar queries!
Updated about 1 year ago