> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.joincandidhealth.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.joincandidhealth.com/_mcp/server.

# Candid Data Share

> Access your healthcare billing data through BigQuery

Candid Data Share is an open data platform that makes it easy to retrieve datasets out of Candid Health in a first-class way. The intention of this Data Share is to provide access to datasets that can be easily synchronized into other data platforms for customer and partner needs outside of the Candid Health platform.

Cloud-native access to these shared BigQuery datasets is provided through service account credentials. In addition to using one of [BigQuery's client libraries](https://cloud.google.com/bigquery/docs/samples/bigquery-client-json-credentials#bigquery_client_json_credentials-python), external tools such as [Fivetran](https://fivetran.com/docs/connectors/databases/bigquery) or [Airbyte](https://docs.airbyte.com/integrations/sources/bigquery) can be configured with those credentials to provide direct access to and automatically synchronize the datasets.

> **Warning**
>
> **Do Not Use For Patient Invoicing**
>
> Candid Data Share is not designed to support patient invoicing workflows. For all patient invoicing use cases, you must use the [Patient Invoicing API](/patient-collections/patient-invoicing-integration-guide). This is the only supported method for ensuring balance accuracy.
>
> Candid Data Share data are generated on a periodic basis and do not provide a live, real-time view of a patient's balance. Please be advised that Candid cannot support issues related to invoicing breaks or inaccuracies that result from using Candid Data Share for this purpose.

## Refresh Cadence

> **Refresh Cadence**
>
> Tables are refreshed on a nightly cadence.

## Additional Resources

* Available datasets and their schemas are listed in the table groups below.
* If you manage your own data ingestion pipeline, please reference this Support Center article for efficient implementation guidance: [Candid Data Share: Incremental Data Pulls](https://support.joincandidhealth.com/hc/en-us/articles/47645614050196-Candid-Data-Share-Incremental-Data-Pulls)

## Access & Support

Breaking changes to Candid Data Share will be shared with customers at least a month in advance. *A new table being created or a new field being added to an existing table is not considered a breaking change.*

> **Warning**
>
> **Planned deprecation — 2026-09-30**
>
> These fields will be removed on 2026-09-30:
>
> * `table_record_updated_at` (export\_payment\_details, export\_adjustment\_details, export\_informational\_adjustment\_details) — use `updated_at` instead.
> * `adjustment_updated_at` (export\_informational\_adjustment\_details) — use `updated_at` instead.
> * `properly_allocated` (export\_transaction).
>
> For incremental ingestion, key off `updated_at`, which is now the single source-record watermark on every table.

> **Note**
>
> Please email [support@joincandidhealth.com](mailto:support@joincandidhealth.com) for more information and access to Candid Data Share.

## Table Groups

### Encounters & Service Lines

Core encounter and service line data with associated financial summaries.

| Table                                                                                                                         | Description                                                                                                                 |
| ----------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------- |
| [export\_encounter](/data-share/encounters-service-lines/export-encounter)                                                    | Data at the encounter level                                                                                                 |
| [export\_financial\_summary](/data-share/encounters-service-lines/export-financial-summary)                                   | Persisted financial summary at the encounter level, including patient responsibility, copay, deductible, and coinsurance    |
| [export\_service\_line](/data-share/encounters-service-lines/export-service-line)                                             | Data at the service line level                                                                                              |
| [export\_service\_line\_financial\_summary](/data-share/encounters-service-lines/export-service-line-financial-summary)       | Persisted financial summary at the service line level, including patient responsibility, copay, deductible, and coinsurance |
| [export\_service\_line\_projected\_financials](/data-share/encounters-service-lines/export-service-line-projected-financials) | Projected financial data at the service line level                                                                          |

### Financial Transactions

Transaction-level data including payments, charges, and adjustments.

| Table                                                                                                                    | Description                                                         |
| ------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------------------------------- |
| [export\_adjustment\_details](/data-share/financial-transactions/export-adjustment-details)                              | Additional information related to balance-impacting adjustments     |
| [export\_batch\_details](/data-share/financial-transactions/export-batch-details)                                        | Batch period details for financial grouping                         |
| [export\_charge\_details](/data-share/financial-transactions/export-charge-details)                                      | Additional information related to charges on a claim                |
| [export\_informational\_adjustment\_details](/data-share/financial-transactions/export-informational-adjustment-details) | Additional information related to non-balance-impacting adjustments |
| [export\_payment\_details](/data-share/financial-transactions/export-payment-details)                                    | Additional information related to payments                          |
| [export\_transaction](/data-share/financial-transactions/export-transaction)                                             | Essential information related to transactions                       |

### Patients & Payers

Patient merge tracking and payer information.

| Table                                                                      | Description                                                                                                                 |
| -------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------- |
| [export\_patient\_merge](/data-share/patients-payers/export-patient-merge) | Synchronizes and tracks patient identities across multiple EMRs, ensuring a cleaner single source of truth for patient data |
| [export\_payer](/data-share/patients-payers/export-payer)                  | Essential information related to payers on Candid                                                                           |