Person360 Data Query

Users can query the Person360 data from two locations in the Lumiata Health AI Platform. We support users with different levels of experience in data analysis. Our users have experience in Excel, SQL, Python, R, and SAS. Currently, we are able to provide query functionality using the user interface and through Jupyter notebooks using SQL or Python.

Query with User Interface

In the Healthcare Data Management module of the platform, there is a "Filter By" dropdown list. In this dropdown list, a user is able to query the data by:

  • Date of birth
  • Coverage start date
  • Coverage end date
  • Claim type
  • Allowed amount
  • ICD codes
  • CPT codes

Once you have selected the option you would like to filter by, then input the values to further configure your search. For example, if you want to search for all claims with an allowed amount greater than $1,000, you must select the following:

  • Filter by "Allowed Amount"
  • Select "Greater Than"
  • Type in "1000"
  • Click "Run Query"

Click on Save Query to save the query for the future. You will be prompted to add a label to your query. In this example, the label can be "AllowedAmount>1000". Click to save the query. Access the saved query by clicking on the "Saved Filter" button at the top right.

Query in Jupyter Notebook

Click on "Launch Jupyter Notebook" in the top right portion of the data management screen. This will launch you into Jupyter Hub, where you are able to explore data through a notebook using SQL.

Did this page help you?