geoProcAggs

Query to specify the procedure aggregates by geography

Get Started with geoProcAggs

If you have already setup CareQuery, run the below code to get started with your first geoProcAggs query.

Example:

🔍

Robotic knee surgery volumes in the Atlanta Metro in Q4-2023


# 1) import 
from care_query.care_query import CareQuery

# 2) instantiate and connect
cq = CareQuery(email = "your-email", 
               token = "your-api-token",
               sftp_key = "path/to/your/company.PEM")

# 3) build query
query_name = cq.geoProcAggs(proc_code = ['27447', 'S2900'],
                            metro = 'atlanta-sandy springs-roswell, ga',
                            min_date = "2023-10-01",
                            max_date = "2024-01-31")

# 4A) submit query to return data
sample_data = query_name.sample()

# 4B) submit query to return data
size_estimate = query_name.estimate()

# 4C) submit query to return data
result_data = query_name.execute()

Query Parameters

The following a parameters are available within the geoProcAggs query, including details on the parameter values.

parameter

description

options

min_date

Lower threshold date within the date range
of interest, observational start date

Date String

max_date

Upper threshold date within the date range
of interest, observational end date

Date String

npi

National Provider Identifier (NPI) of individual and/or
organizational provider(s) that appear on the encounter.

Any Valid NPI

proc_code

CPT or HCPCS procedural code performed within the encounter

values available

proc_category

Category of the CPT or HCPCS
procedure performed within the encounter

values available

proc_subcategory

Sub-category of the CPT or HCPCS
procedure performed within the encounter

values available

proc_greedy

Boolean indicator for 'AND' or 'OR' when multiple
procedure parameters specified - helps users offer various
levels of specificity without confusing and/or logic

True or False

state

US State residence of the query patient population

values available

division

Nine distinct US State groupings as defined by the US Census Bureau

values available

region

Four major US State groupings as defined by the US Census Bureau

values available

metro

Metropolitan and micropolitan statistical
areas according to the US Census Bureau

values available

short_zip

First three digits the zip code of the
query patient population specified

First 3 digits of zip code(s)

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 it's creation

True or False

Query Return Data

The geoProcAggs query returns the GEO_PROC_TABLE for all aggregate totals that meet the criterion specified within the query.

featuredescriptionexample
yearYear in which the aggregated values are calculated.2022
monthInteger indicator for the month of the year in which the aggregated values are calculated5
short_zipFirst three digits of the primary patient zip code87101
statePrimary US State code code of the patient seenNM
proc_codeProcedure code performed within encounter(s). Designated by a CPT or HCPCS code.99457
proc_descDescription of the procedure performed within the encounter(s).Management using the results of remote vital sign monitoring per calendar month, first 20 minutes
proc_subcategoryProcedural sub-category related to the procedure performed.Eval. and Mgmt. - Special Eval. and Mgmt. Services
proc_categoryProcedural category related to the procedure performed.Evaluation and Management
num_patientsTotal number of patients seen within the aggregation period.25
num_visitsTotal number of visits within the aggregation period.32
num_encountersTotal number of encounters within the aggregation period.41
total_line_chargesSum of line item charges within the aggregation period. Line item charges are directly related to the procedure performed.$5,729.18
total_claim_chargesSum of the claim item charges within the aggregation period. Claim charges include the procedure charge and related facility charges.$9,103.40
total_smart_allowedSum of allowed amount estimates within the aggregation period. Smart Allowed® values are derived from multiple sources to estimate the final adjudicated amount at the line-item level.$3,958.01
mean_line_chargeAverage line item charge at the line itemwithin the aggregation period. Line item charges are directly related to the procedure performed.$139.73
mean_claim_chargeAverage claim item charge at the line item within the aggregation period. Claim charges include the procedure charge and related facility charges.$222.03
mean_smart_allowedAverage allowed amount at the line item within the aggregation period. Smart Allowed® values are derived from multiple sources to estimate the final adjudicated amount at the line-item level.$96.50
mean_claim_chargeAverage claim item charge at the line item within the aggregation period. Claim charges include the procedure charge and related facility charges.$222.03
mean_smart_allowedAverage allowed amount at the line item within the aggregation period. Smart Allowed® values are derived from multiple sources to estimate the final adjudicated amount at the line-item level.$96.50