Skip to contents

Introduction

In this vignette, we explore how OmopSketch functions can serve as a valuable tool for summarising missingness in databases containing electronic health records mapped to the OMOP Common Data Model.

Create a mock cdm

To illustrate the package’s functionality, we begin by loading the required packages and connecting to a test CDM using the Eunomia GiBleed dataset.

library(dplyr)
#> 
#> Attaching package: 'dplyr'
#> The following objects are masked from 'package:stats':
#> 
#>     filter, lag
#> The following objects are masked from 'package:base':
#> 
#>     intersect, setdiff, setequal, union
library(omock)
library(OmopSketch)

cdm <- mockCdmFromDataset(datasetName = "GiBleed", source = "duckdb")
#>  Loading bundled GiBleed tables from package data.
#>  Adding drug_strength table.
#>  Creating local <cdm_reference> object.
#>  Inserting <cdm_reference> into duckdb.

cdm
#> 
#> ── # OMOP CDM reference (duckdb) of GiBleed ────────────────────────────────────
#> • omop tables: care_site, cdm_source, concept, concept_ancestor, concept_class,
#> concept_relationship, concept_synonym, condition_era, condition_occurrence,
#> cost, death, device_exposure, domain, dose_era, drug_era, drug_exposure,
#> drug_strength, fact_relationship, location, measurement, metadata, note,
#> note_nlp, observation, observation_period, payer_plan_period, person,
#> procedure_occurrence, provider, relationship, source_to_concept_map, specimen,
#> visit_detail, visit_occurrence, vocabulary
#> • cohort tables: -
#> • achilles tables: -
#> • other tables: -

Summary of missing data

A common first step in data quality assessment is to identify missing values. In this contest, missing data are defined as either NA values or concept IDs equal to 0 (counts are separated by either of the cases).

You can use the summariseMissingData() function to summarise missingness across the clinical tables in the CDM:

result_missingData <- summariseMissingData(
  cdm = cdm,
  omopTableName = "observation_period"
)
#> The person table has ≤ 1e+05 subjects; skipping sampling
#> of the CDM.

result_missingData |> 
  glimpse()
#> Rows: 16
#> Columns: 13
#> $ result_id        <int> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
#> $ cdm_name         <chr> "GiBleed", "GiBleed", "GiBleed", "GiBleed", "GiBleed"…
#> $ group_name       <chr> "omop_table", "omop_table", "omop_table", "omop_table…
#> $ group_level      <chr> "observation_period", "observation_period", "observat…
#> $ strata_name      <chr> "overall", "overall", "overall", "overall", "overall"…
#> $ strata_level     <chr> "overall", "overall", "overall", "overall", "overall"…
#> $ variable_name    <chr> "Column name", "Column name", "Column name", "Column …
#> $ variable_level   <chr> "observation_period_id", "observation_period_id", "ob…
#> $ estimate_name    <chr> "na_count", "na_percentage", "zero_count", "zero_perc…
#> $ estimate_type    <chr> "integer", "percentage", "integer", "percentage", "in…
#> $ estimate_value   <chr> "0", "0.00", "0", "0.00", "0", "0.00", "0", "0.00", "…
#> $ additional_name  <chr> "is_required", "is_required", "is_required", "is_requ…
#> $ additional_level <chr> "TRUE", "TRUE", "TRUE", "TRUE", "TRUE", "TRUE", "TRUE…

Summarise by OMOP CDM table

You can choose to summarise missing data for specific OMOP CDM tables using the argument omopTableName.

result_missingData <- summariseMissingData(
  cdm = cdm,
  omopTableName = c(
    "observation_period", "visit_occurrence", "condition_occurrence", 
    "drug_exposure", "procedure_occurrence", "device_exposure", "measurement",
    "observation", "death"
  )
)

Summarise by sex

You can choose to summarise missing data by sex by setting the argument sex to TRUE.

result_missingData <- summariseMissingData(
  cdm = cdm,
  omopTableName = c(
    "observation_period", "visit_occurrence", "condition_occurrence",
    "drug_exposure", "procedure_occurrence", "device_exposure", "measurement", 
    "observation", "death"
  ),
  sex = TRUE
)

Summarise by age group

You can choose to summarise missing data by age group by creating a list defining the age groups you want to use.

result_missingData <- summariseMissingData(
  cdm = cdm,
  omopTableName = c(
    "observation_period", "visit_occurrence", "condition_occurrence", 
    "drug_exposure", "procedure_occurrence", "device_exposure", "measurement", 
    "observation", "death"
  ),
  ageGroup = list(c(0, 17), c(18, 64), c(65, 150))
)

Summarise by date and/or time interval

You can also summarise missing data within a specific date range or across defined time intervals using the dateRange and interval arguments. The interval argument supports “overall” (no time stratification), “years”, “quarters”, or “months”.

result_missingData <- summariseMissingData(
  cdm = cdm,
  omopTableName = c(
    "observation_period", "visit_occurrence", "condition_occurrence", 
    "drug_exposure", "procedure_occurrence", "device_exposure", "measurement", 
    "observation", "death"
  ),
  interval = "years",
  dateRange = as.Date(c("2012-01-01", "2019-01-01"))
)

Summarise by column

You can also choose to summarise missing data for specific columns in the OMOP CDM tables using the argument col.

result_missingData <- summariseMissingData(
  cdm = cdm,
  omopTableName = c(
    "observation_period", "visit_occurrence", "condition_occurrence", 
    "drug_exposure", "procedure_occurrence", "device_exposure", "measurement", 
    "observation", "death"
  ),
  col = c("observation_period_start_date", "observation_period_end_date")
)

Summarise in sample of OMOP CDM

Finally, you can summarise missing data on a subset of subjects via the sample argument: provide an integer to randomly select that many person_ids from the person table, or a character string naming a cohort table to limit counts to its subject_ids.

result_missingData <- summariseMissingData(
  cdm = cdm,
  omopTableName = c(
    "observation_period", "visit_occurrence", "condition_occurrence", 
    "drug_exposure", "procedure_occurrence", "device_exposure", "measurement", 
    "observation", "death"
  ),
  sample = 1000
)

Visualise summary results

You can present these results using the function tableMissingData().

result_missingData <- summariseMissingData(
  cdm = cdm,
  omopTableName = c("condition_occurrence", "drug_exposure", "procedure_occurrence"),
  sex = TRUE,
  ageGroup = list(c(0, 17), c(18, 64), c(65, 150)),
  interval = "years",
  dateRange = as.Date(c("2012-01-01", "2019-01-01")),
  sample = 1000
)
result_missingData |> tableMissingData()
Summary of missingness in condition_occurrence, drug_exposure, procedure_occurrence tables
Column name Time interval Estimate name
Database name
GiBleed
condition_occurrence; overall; overall
condition_occurrence_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2012-01-01 to 2012-12-31 N missing data (%) 70 (19.07%)
condition_end_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 70 (19.07%)
condition_type_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 367 (100.00%)
stop_reason (not required) 2012-01-01 to 2012-12-31 N missing data (%) 367 (100.00%)
provider_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 367 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 367 (100.00%)
condition_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 367 (100.00%)
condition_occurrence_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2013-01-01 to 2013-12-31 N missing data (%) 61 (16.44%)
condition_end_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 61 (16.44%)
condition_type_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 371 (100.00%)
stop_reason (not required) 2013-01-01 to 2013-12-31 N missing data (%) 371 (100.00%)
provider_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 371 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 371 (100.00%)
condition_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 371 (100.00%)
condition_occurrence_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2014-01-01 to 2014-12-31 N missing data (%) 76 (19.79%)
condition_end_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 76 (19.79%)
condition_type_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 384 (100.00%)
stop_reason (not required) 2014-01-01 to 2014-12-31 N missing data (%) 384 (100.00%)
provider_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 384 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 384 (100.00%)
condition_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 384 (100.00%)
condition_occurrence_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2015-01-01 to 2015-12-31 N missing data (%) 81 (21.77%)
condition_end_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 81 (21.77%)
condition_type_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 372 (100.00%)
stop_reason (not required) 2015-01-01 to 2015-12-31 N missing data (%) 372 (100.00%)
provider_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 372 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 372 (100.00%)
condition_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 372 (100.00%)
condition_occurrence_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2016-01-01 to 2016-12-31 N missing data (%) 75 (20.38%)
condition_end_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 75 (20.38%)
condition_type_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 368 (100.00%)
stop_reason (not required) 2016-01-01 to 2016-12-31 N missing data (%) 368 (100.00%)
provider_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 368 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 368 (100.00%)
condition_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 368 (100.00%)
condition_occurrence_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2017-01-01 to 2017-12-31 N missing data (%) 73 (20.28%)
condition_end_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 73 (20.28%)
condition_type_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 360 (100.00%)
stop_reason (not required) 2017-01-01 to 2017-12-31 N missing data (%) 360 (100.00%)
provider_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 360 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 1 (0.28%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 360 (100.00%)
condition_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 360 (100.00%)
condition_occurrence_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2018-01-01 to 2018-12-31 N missing data (%) 59 (16.71%)
condition_end_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 59 (16.71%)
condition_type_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 353 (100.00%)
stop_reason (not required) 2018-01-01 to 2018-12-31 N missing data (%) 353 (100.00%)
provider_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 353 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 353 (100.00%)
condition_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 353 (100.00%)
condition_occurrence_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_end_datetime (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_type_concept_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 1 (100.00%)
stop_reason (not required) 2019-01-01 to 2019-12-31 N missing data (%) 1 (100.00%)
provider_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 1 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 1 (100.00%)
condition_source_value (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2019-01-01 to 2019-12-31 N missing data (%) 1 (100.00%)
condition_occurrence_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) overall N missing data (%) 0 (0.00%)
condition_start_datetime (not required) overall N missing data (%) 0 (0.00%)
condition_end_date (not required) overall N missing data (%) 495 (19.22%)
condition_end_datetime (not required) overall N missing data (%) 495 (19.22%)
condition_type_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 2,576 (100.00%)
stop_reason (not required) overall N missing data (%) 2,576 (100.00%)
provider_id (not required) overall N missing data (%) 2,576 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) overall N missing data (%) 1 (0.04%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 2,576 (100.00%)
condition_source_value (not required) overall N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) overall N missing data (%) 2,576 (100.00%)
condition_occurrence; 65 to 150; overall
condition_occurrence_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2012-01-01 to 2012-12-31 N missing data (%) 12 (19.67%)
condition_end_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 12 (19.67%)
condition_type_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 61 (100.00%)
stop_reason (not required) 2012-01-01 to 2012-12-31 N missing data (%) 61 (100.00%)
provider_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 61 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 61 (100.00%)
condition_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 61 (100.00%)
condition_occurrence_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2013-01-01 to 2013-12-31 N missing data (%) 7 (10.77%)
condition_end_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 7 (10.77%)
condition_type_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 65 (100.00%)
stop_reason (not required) 2013-01-01 to 2013-12-31 N missing data (%) 65 (100.00%)
provider_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 65 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 65 (100.00%)
condition_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 65 (100.00%)
condition_occurrence_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2014-01-01 to 2014-12-31 N missing data (%) 9 (15.00%)
condition_end_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 9 (15.00%)
condition_type_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 60 (100.00%)
stop_reason (not required) 2014-01-01 to 2014-12-31 N missing data (%) 60 (100.00%)
provider_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 60 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 60 (100.00%)
condition_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 60 (100.00%)
condition_occurrence_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2015-01-01 to 2015-12-31 N missing data (%) 18 (23.68%)
condition_end_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 18 (23.68%)
condition_type_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 76 (100.00%)
stop_reason (not required) 2015-01-01 to 2015-12-31 N missing data (%) 76 (100.00%)
provider_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 76 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 76 (100.00%)
condition_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 76 (100.00%)
condition_occurrence_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2016-01-01 to 2016-12-31 N missing data (%) 14 (16.67%)
condition_end_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 14 (16.67%)
condition_type_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 84 (100.00%)
stop_reason (not required) 2016-01-01 to 2016-12-31 N missing data (%) 84 (100.00%)
provider_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 84 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 84 (100.00%)
condition_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 84 (100.00%)
condition_occurrence_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2017-01-01 to 2017-12-31 N missing data (%) 19 (19.79%)
condition_end_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 19 (19.79%)
condition_type_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 96 (100.00%)
stop_reason (not required) 2017-01-01 to 2017-12-31 N missing data (%) 96 (100.00%)
provider_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 96 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 96 (100.00%)
condition_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 96 (100.00%)
condition_occurrence_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2018-01-01 to 2018-12-31 N missing data (%) 8 (9.76%)
condition_end_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 8 (9.76%)
condition_type_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 82 (100.00%)
stop_reason (not required) 2018-01-01 to 2018-12-31 N missing data (%) 82 (100.00%)
provider_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 82 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 82 (100.00%)
condition_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 82 (100.00%)
condition_occurrence_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) overall N missing data (%) 0 (0.00%)
condition_start_datetime (not required) overall N missing data (%) 0 (0.00%)
condition_end_date (not required) overall N missing data (%) 87 (16.60%)
condition_end_datetime (not required) overall N missing data (%) 87 (16.60%)
condition_type_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 524 (100.00%)
stop_reason (not required) overall N missing data (%) 524 (100.00%)
provider_id (not required) overall N missing data (%) 524 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 524 (100.00%)
condition_source_value (not required) overall N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) overall N missing data (%) 524 (100.00%)
condition_occurrence; 18 to 64; overall
condition_occurrence_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2012-01-01 to 2012-12-31 N missing data (%) 58 (18.95%)
condition_end_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 58 (18.95%)
condition_type_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 306 (100.00%)
stop_reason (not required) 2012-01-01 to 2012-12-31 N missing data (%) 306 (100.00%)
provider_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 306 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 306 (100.00%)
condition_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 306 (100.00%)
condition_occurrence_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2013-01-01 to 2013-12-31 N missing data (%) 54 (17.65%)
condition_end_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 54 (17.65%)
condition_type_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 306 (100.00%)
stop_reason (not required) 2013-01-01 to 2013-12-31 N missing data (%) 306 (100.00%)
provider_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 306 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 306 (100.00%)
condition_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 306 (100.00%)
condition_occurrence_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2014-01-01 to 2014-12-31 N missing data (%) 67 (20.68%)
condition_end_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 67 (20.68%)
condition_type_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 324 (100.00%)
stop_reason (not required) 2014-01-01 to 2014-12-31 N missing data (%) 324 (100.00%)
provider_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 324 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 324 (100.00%)
condition_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 324 (100.00%)
condition_occurrence_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2015-01-01 to 2015-12-31 N missing data (%) 63 (21.28%)
condition_end_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 63 (21.28%)
condition_type_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 296 (100.00%)
stop_reason (not required) 2015-01-01 to 2015-12-31 N missing data (%) 296 (100.00%)
provider_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 296 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 296 (100.00%)
condition_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 296 (100.00%)
condition_occurrence_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2016-01-01 to 2016-12-31 N missing data (%) 61 (21.48%)
condition_end_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 61 (21.48%)
condition_type_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 284 (100.00%)
stop_reason (not required) 2016-01-01 to 2016-12-31 N missing data (%) 284 (100.00%)
provider_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 284 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 284 (100.00%)
condition_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 284 (100.00%)
condition_occurrence_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2017-01-01 to 2017-12-31 N missing data (%) 54 (20.45%)
condition_end_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 54 (20.45%)
condition_type_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 264 (100.00%)
stop_reason (not required) 2017-01-01 to 2017-12-31 N missing data (%) 264 (100.00%)
provider_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 264 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 1 (0.38%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 264 (100.00%)
condition_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 264 (100.00%)
condition_occurrence_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2018-01-01 to 2018-12-31 N missing data (%) 51 (18.82%)
condition_end_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 51 (18.82%)
condition_type_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 271 (100.00%)
stop_reason (not required) 2018-01-01 to 2018-12-31 N missing data (%) 271 (100.00%)
provider_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 271 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 271 (100.00%)
condition_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 271 (100.00%)
condition_occurrence_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_end_datetime (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_type_concept_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 1 (100.00%)
stop_reason (not required) 2019-01-01 to 2019-12-31 N missing data (%) 1 (100.00%)
provider_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 1 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 1 (100.00%)
condition_source_value (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2019-01-01 to 2019-12-31 N missing data (%) 1 (100.00%)
condition_occurrence_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) overall N missing data (%) 0 (0.00%)
condition_start_datetime (not required) overall N missing data (%) 0 (0.00%)
condition_end_date (not required) overall N missing data (%) 408 (19.88%)
condition_end_datetime (not required) overall N missing data (%) 408 (19.88%)
condition_type_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 2,052 (100.00%)
stop_reason (not required) overall N missing data (%) 2,052 (100.00%)
provider_id (not required) overall N missing data (%) 2,052 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) overall N missing data (%) 1 (0.05%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 2,052 (100.00%)
condition_source_value (not required) overall N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) overall N missing data (%) 2,052 (100.00%)
condition_occurrence; overall; Male
condition_occurrence_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2012-01-01 to 2012-12-31 N missing data (%) 41 (22.53%)
condition_end_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 41 (22.53%)
condition_type_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 182 (100.00%)
stop_reason (not required) 2012-01-01 to 2012-12-31 N missing data (%) 182 (100.00%)
provider_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 182 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 182 (100.00%)
condition_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 182 (100.00%)
condition_occurrence_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2013-01-01 to 2013-12-31 N missing data (%) 30 (16.76%)
condition_end_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 30 (16.76%)
condition_type_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 179 (100.00%)
stop_reason (not required) 2013-01-01 to 2013-12-31 N missing data (%) 179 (100.00%)
provider_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 179 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 179 (100.00%)
condition_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 179 (100.00%)
condition_occurrence_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2014-01-01 to 2014-12-31 N missing data (%) 34 (20.12%)
condition_end_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 34 (20.12%)
condition_type_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 169 (100.00%)
stop_reason (not required) 2014-01-01 to 2014-12-31 N missing data (%) 169 (100.00%)
provider_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 169 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 169 (100.00%)
condition_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 169 (100.00%)
condition_occurrence_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2015-01-01 to 2015-12-31 N missing data (%) 43 (23.24%)
condition_end_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 43 (23.24%)
condition_type_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 185 (100.00%)
stop_reason (not required) 2015-01-01 to 2015-12-31 N missing data (%) 185 (100.00%)
provider_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 185 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 185 (100.00%)
condition_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 185 (100.00%)
condition_occurrence_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2016-01-01 to 2016-12-31 N missing data (%) 40 (22.86%)
condition_end_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 40 (22.86%)
condition_type_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 175 (100.00%)
stop_reason (not required) 2016-01-01 to 2016-12-31 N missing data (%) 175 (100.00%)
provider_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 175 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 175 (100.00%)
condition_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 175 (100.00%)
condition_occurrence_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2017-01-01 to 2017-12-31 N missing data (%) 36 (22.50%)
condition_end_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 36 (22.50%)
condition_type_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 160 (100.00%)
stop_reason (not required) 2017-01-01 to 2017-12-31 N missing data (%) 160 (100.00%)
provider_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 160 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 160 (100.00%)
condition_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 160 (100.00%)
condition_occurrence_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2018-01-01 to 2018-12-31 N missing data (%) 26 (15.38%)
condition_end_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 26 (15.38%)
condition_type_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 169 (100.00%)
stop_reason (not required) 2018-01-01 to 2018-12-31 N missing data (%) 169 (100.00%)
provider_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 169 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 169 (100.00%)
condition_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 169 (100.00%)
condition_occurrence_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_end_datetime (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_type_concept_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 1 (100.00%)
stop_reason (not required) 2019-01-01 to 2019-12-31 N missing data (%) 1 (100.00%)
provider_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 1 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 1 (100.00%)
condition_source_value (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2019-01-01 to 2019-12-31 N missing data (%) 1 (100.00%)
condition_occurrence_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) overall N missing data (%) 0 (0.00%)
condition_start_datetime (not required) overall N missing data (%) 0 (0.00%)
condition_end_date (not required) overall N missing data (%) 250 (20.49%)
condition_end_datetime (not required) overall N missing data (%) 250 (20.49%)
condition_type_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 1,220 (100.00%)
stop_reason (not required) overall N missing data (%) 1,220 (100.00%)
provider_id (not required) overall N missing data (%) 1,220 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 1,220 (100.00%)
condition_source_value (not required) overall N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) overall N missing data (%) 1,220 (100.00%)
condition_occurrence; overall; Female
condition_occurrence_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2012-01-01 to 2012-12-31 N missing data (%) 29 (15.68%)
condition_end_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 29 (15.68%)
condition_type_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 185 (100.00%)
stop_reason (not required) 2012-01-01 to 2012-12-31 N missing data (%) 185 (100.00%)
provider_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 185 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 185 (100.00%)
condition_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 185 (100.00%)
condition_occurrence_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2013-01-01 to 2013-12-31 N missing data (%) 31 (16.15%)
condition_end_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 31 (16.15%)
condition_type_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 192 (100.00%)
stop_reason (not required) 2013-01-01 to 2013-12-31 N missing data (%) 192 (100.00%)
provider_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 192 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 192 (100.00%)
condition_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 192 (100.00%)
condition_occurrence_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2014-01-01 to 2014-12-31 N missing data (%) 42 (19.53%)
condition_end_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 42 (19.53%)
condition_type_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 215 (100.00%)
stop_reason (not required) 2014-01-01 to 2014-12-31 N missing data (%) 215 (100.00%)
provider_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 215 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 215 (100.00%)
condition_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 215 (100.00%)
condition_occurrence_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2015-01-01 to 2015-12-31 N missing data (%) 38 (20.32%)
condition_end_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 38 (20.32%)
condition_type_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 187 (100.00%)
stop_reason (not required) 2015-01-01 to 2015-12-31 N missing data (%) 187 (100.00%)
provider_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 187 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 187 (100.00%)
condition_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 187 (100.00%)
condition_occurrence_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2016-01-01 to 2016-12-31 N missing data (%) 35 (18.13%)
condition_end_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 35 (18.13%)
condition_type_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 193 (100.00%)
stop_reason (not required) 2016-01-01 to 2016-12-31 N missing data (%) 193 (100.00%)
provider_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 193 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 193 (100.00%)
condition_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 193 (100.00%)
condition_occurrence_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2017-01-01 to 2017-12-31 N missing data (%) 37 (18.50%)
condition_end_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 37 (18.50%)
condition_type_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 200 (100.00%)
stop_reason (not required) 2017-01-01 to 2017-12-31 N missing data (%) 200 (100.00%)
provider_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 200 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 1 (0.50%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 200 (100.00%)
condition_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 200 (100.00%)
condition_occurrence_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2018-01-01 to 2018-12-31 N missing data (%) 33 (17.93%)
condition_end_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 33 (17.93%)
condition_type_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 184 (100.00%)
stop_reason (not required) 2018-01-01 to 2018-12-31 N missing data (%) 184 (100.00%)
provider_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 184 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 184 (100.00%)
condition_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 184 (100.00%)
condition_occurrence_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) overall N missing data (%) 0 (0.00%)
condition_start_datetime (not required) overall N missing data (%) 0 (0.00%)
condition_end_date (not required) overall N missing data (%) 245 (18.07%)
condition_end_datetime (not required) overall N missing data (%) 245 (18.07%)
condition_type_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 1,356 (100.00%)
stop_reason (not required) overall N missing data (%) 1,356 (100.00%)
provider_id (not required) overall N missing data (%) 1,356 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) overall N missing data (%) 1 (0.07%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 1,356 (100.00%)
condition_source_value (not required) overall N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) overall N missing data (%) 1,356 (100.00%)
condition_occurrence; 65 to 150; Female
condition_occurrence_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2012-01-01 to 2012-12-31 N missing data (%) 3 (11.11%)
condition_end_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 3 (11.11%)
condition_type_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 27 (100.00%)
stop_reason (not required) 2012-01-01 to 2012-12-31 N missing data (%) 27 (100.00%)
provider_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 27 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 27 (100.00%)
condition_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 27 (100.00%)
condition_occurrence_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2013-01-01 to 2013-12-31 N missing data (%) 2 (6.06%)
condition_end_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 2 (6.06%)
condition_type_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 33 (100.00%)
stop_reason (not required) 2013-01-01 to 2013-12-31 N missing data (%) 33 (100.00%)
provider_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 33 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 33 (100.00%)
condition_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 33 (100.00%)
condition_occurrence_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2014-01-01 to 2014-12-31 N missing data (%) 3 (9.38%)
condition_end_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 3 (9.38%)
condition_type_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 32 (100.00%)
stop_reason (not required) 2014-01-01 to 2014-12-31 N missing data (%) 32 (100.00%)
provider_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 32 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 32 (100.00%)
condition_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 32 (100.00%)
condition_occurrence_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2015-01-01 to 2015-12-31 N missing data (%) 9 (20.93%)
condition_end_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 9 (20.93%)
condition_type_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 43 (100.00%)
stop_reason (not required) 2015-01-01 to 2015-12-31 N missing data (%) 43 (100.00%)
provider_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 43 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 43 (100.00%)
condition_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 43 (100.00%)
condition_occurrence_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2016-01-01 to 2016-12-31 N missing data (%) 8 (17.39%)
condition_end_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 8 (17.39%)
condition_type_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 46 (100.00%)
stop_reason (not required) 2016-01-01 to 2016-12-31 N missing data (%) 46 (100.00%)
provider_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 46 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 46 (100.00%)
condition_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 46 (100.00%)
condition_occurrence_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2017-01-01 to 2017-12-31 N missing data (%) 8 (15.69%)
condition_end_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 8 (15.69%)
condition_type_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 51 (100.00%)
stop_reason (not required) 2017-01-01 to 2017-12-31 N missing data (%) 51 (100.00%)
provider_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 51 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 51 (100.00%)
condition_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 51 (100.00%)
condition_occurrence_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2018-01-01 to 2018-12-31 N missing data (%) 5 (10.87%)
condition_end_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 5 (10.87%)
condition_type_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 46 (100.00%)
stop_reason (not required) 2018-01-01 to 2018-12-31 N missing data (%) 46 (100.00%)
provider_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 46 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 46 (100.00%)
condition_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 46 (100.00%)
condition_occurrence_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) overall N missing data (%) 0 (0.00%)
condition_start_datetime (not required) overall N missing data (%) 0 (0.00%)
condition_end_date (not required) overall N missing data (%) 38 (13.67%)
condition_end_datetime (not required) overall N missing data (%) 38 (13.67%)
condition_type_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 278 (100.00%)
stop_reason (not required) overall N missing data (%) 278 (100.00%)
provider_id (not required) overall N missing data (%) 278 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 278 (100.00%)
condition_source_value (not required) overall N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) overall N missing data (%) 278 (100.00%)
condition_occurrence; 18 to 64; Female
condition_occurrence_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2012-01-01 to 2012-12-31 N missing data (%) 26 (16.46%)
condition_end_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 26 (16.46%)
condition_type_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 158 (100.00%)
stop_reason (not required) 2012-01-01 to 2012-12-31 N missing data (%) 158 (100.00%)
provider_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 158 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 158 (100.00%)
condition_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 158 (100.00%)
condition_occurrence_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2013-01-01 to 2013-12-31 N missing data (%) 29 (18.24%)
condition_end_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 29 (18.24%)
condition_type_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 159 (100.00%)
stop_reason (not required) 2013-01-01 to 2013-12-31 N missing data (%) 159 (100.00%)
provider_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 159 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 159 (100.00%)
condition_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 159 (100.00%)
condition_occurrence_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2014-01-01 to 2014-12-31 N missing data (%) 39 (21.31%)
condition_end_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 39 (21.31%)
condition_type_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 183 (100.00%)
stop_reason (not required) 2014-01-01 to 2014-12-31 N missing data (%) 183 (100.00%)
provider_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 183 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 183 (100.00%)
condition_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 183 (100.00%)
condition_occurrence_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2015-01-01 to 2015-12-31 N missing data (%) 29 (20.14%)
condition_end_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 29 (20.14%)
condition_type_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 144 (100.00%)
stop_reason (not required) 2015-01-01 to 2015-12-31 N missing data (%) 144 (100.00%)
provider_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 144 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 144 (100.00%)
condition_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 144 (100.00%)
condition_occurrence_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2016-01-01 to 2016-12-31 N missing data (%) 27 (18.37%)
condition_end_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 27 (18.37%)
condition_type_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 147 (100.00%)
stop_reason (not required) 2016-01-01 to 2016-12-31 N missing data (%) 147 (100.00%)
provider_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 147 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 147 (100.00%)
condition_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 147 (100.00%)
condition_occurrence_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2017-01-01 to 2017-12-31 N missing data (%) 29 (19.46%)
condition_end_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 29 (19.46%)
condition_type_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 149 (100.00%)
stop_reason (not required) 2017-01-01 to 2017-12-31 N missing data (%) 149 (100.00%)
provider_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 149 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 1 (0.67%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 149 (100.00%)
condition_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 149 (100.00%)
condition_occurrence_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2018-01-01 to 2018-12-31 N missing data (%) 28 (20.29%)
condition_end_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 28 (20.29%)
condition_type_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 138 (100.00%)
stop_reason (not required) 2018-01-01 to 2018-12-31 N missing data (%) 138 (100.00%)
provider_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 138 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 138 (100.00%)
condition_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 138 (100.00%)
condition_occurrence_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) overall N missing data (%) 0 (0.00%)
condition_start_datetime (not required) overall N missing data (%) 0 (0.00%)
condition_end_date (not required) overall N missing data (%) 207 (19.20%)
condition_end_datetime (not required) overall N missing data (%) 207 (19.20%)
condition_type_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 1,078 (100.00%)
stop_reason (not required) overall N missing data (%) 1,078 (100.00%)
provider_id (not required) overall N missing data (%) 1,078 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) overall N missing data (%) 1 (0.09%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 1,078 (100.00%)
condition_source_value (not required) overall N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) overall N missing data (%) 1,078 (100.00%)
condition_occurrence; 18 to 64; Male
condition_occurrence_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2012-01-01 to 2012-12-31 N missing data (%) 32 (21.62%)
condition_end_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 32 (21.62%)
condition_type_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 148 (100.00%)
stop_reason (not required) 2012-01-01 to 2012-12-31 N missing data (%) 148 (100.00%)
provider_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 148 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 148 (100.00%)
condition_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 148 (100.00%)
condition_occurrence_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2013-01-01 to 2013-12-31 N missing data (%) 25 (17.01%)
condition_end_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 25 (17.01%)
condition_type_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 147 (100.00%)
stop_reason (not required) 2013-01-01 to 2013-12-31 N missing data (%) 147 (100.00%)
provider_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 147 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 147 (100.00%)
condition_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 147 (100.00%)
condition_occurrence_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2014-01-01 to 2014-12-31 N missing data (%) 28 (19.86%)
condition_end_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 28 (19.86%)
condition_type_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 141 (100.00%)
stop_reason (not required) 2014-01-01 to 2014-12-31 N missing data (%) 141 (100.00%)
provider_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 141 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 141 (100.00%)
condition_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 141 (100.00%)
condition_occurrence_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2015-01-01 to 2015-12-31 N missing data (%) 34 (22.37%)
condition_end_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 34 (22.37%)
condition_type_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 152 (100.00%)
stop_reason (not required) 2015-01-01 to 2015-12-31 N missing data (%) 152 (100.00%)
provider_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 152 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 152 (100.00%)
condition_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 152 (100.00%)
condition_occurrence_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2016-01-01 to 2016-12-31 N missing data (%) 34 (24.82%)
condition_end_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 34 (24.82%)
condition_type_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 137 (100.00%)
stop_reason (not required) 2016-01-01 to 2016-12-31 N missing data (%) 137 (100.00%)
provider_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 137 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 137 (100.00%)
condition_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 137 (100.00%)
condition_occurrence_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2017-01-01 to 2017-12-31 N missing data (%) 25 (21.74%)
condition_end_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 25 (21.74%)
condition_type_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 115 (100.00%)
stop_reason (not required) 2017-01-01 to 2017-12-31 N missing data (%) 115 (100.00%)
provider_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 115 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 115 (100.00%)
condition_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 115 (100.00%)
condition_occurrence_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2018-01-01 to 2018-12-31 N missing data (%) 23 (17.29%)
condition_end_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 23 (17.29%)
condition_type_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 133 (100.00%)
stop_reason (not required) 2018-01-01 to 2018-12-31 N missing data (%) 133 (100.00%)
provider_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 133 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 133 (100.00%)
condition_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 133 (100.00%)
condition_occurrence_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_end_datetime (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_type_concept_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 1 (100.00%)
stop_reason (not required) 2019-01-01 to 2019-12-31 N missing data (%) 1 (100.00%)
provider_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 1 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 1 (100.00%)
condition_source_value (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2019-01-01 to 2019-12-31 N missing data (%) 1 (100.00%)
condition_occurrence_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) overall N missing data (%) 0 (0.00%)
condition_start_datetime (not required) overall N missing data (%) 0 (0.00%)
condition_end_date (not required) overall N missing data (%) 201 (20.64%)
condition_end_datetime (not required) overall N missing data (%) 201 (20.64%)
condition_type_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 974 (100.00%)
stop_reason (not required) overall N missing data (%) 974 (100.00%)
provider_id (not required) overall N missing data (%) 974 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 974 (100.00%)
condition_source_value (not required) overall N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) overall N missing data (%) 974 (100.00%)
condition_occurrence; 65 to 150; Male
condition_occurrence_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2012-01-01 to 2012-12-31 N missing data (%) 9 (26.47%)
condition_end_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 9 (26.47%)
condition_type_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 34 (100.00%)
stop_reason (not required) 2012-01-01 to 2012-12-31 N missing data (%) 34 (100.00%)
provider_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 34 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 34 (100.00%)
condition_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 34 (100.00%)
condition_occurrence_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2013-01-01 to 2013-12-31 N missing data (%) 5 (15.62%)
condition_end_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 5 (15.62%)
condition_type_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 32 (100.00%)
stop_reason (not required) 2013-01-01 to 2013-12-31 N missing data (%) 32 (100.00%)
provider_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 32 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 32 (100.00%)
condition_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 32 (100.00%)
condition_occurrence_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2014-01-01 to 2014-12-31 N missing data (%) 6 (21.43%)
condition_end_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 6 (21.43%)
condition_type_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 28 (100.00%)
stop_reason (not required) 2014-01-01 to 2014-12-31 N missing data (%) 28 (100.00%)
provider_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 28 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 28 (100.00%)
condition_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 28 (100.00%)
condition_occurrence_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2015-01-01 to 2015-12-31 N missing data (%) 9 (27.27%)
condition_end_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 9 (27.27%)
condition_type_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 33 (100.00%)
stop_reason (not required) 2015-01-01 to 2015-12-31 N missing data (%) 33 (100.00%)
provider_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 33 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 33 (100.00%)
condition_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 33 (100.00%)
condition_occurrence_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2016-01-01 to 2016-12-31 N missing data (%) 6 (15.79%)
condition_end_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 6 (15.79%)
condition_type_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 38 (100.00%)
stop_reason (not required) 2016-01-01 to 2016-12-31 N missing data (%) 38 (100.00%)
provider_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 38 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 38 (100.00%)
condition_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 38 (100.00%)
condition_occurrence_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2017-01-01 to 2017-12-31 N missing data (%) 11 (24.44%)
condition_end_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 11 (24.44%)
condition_type_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 45 (100.00%)
stop_reason (not required) 2017-01-01 to 2017-12-31 N missing data (%) 45 (100.00%)
provider_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 45 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 45 (100.00%)
condition_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 45 (100.00%)
condition_occurrence_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_start_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_end_date (not required) 2018-01-01 to 2018-12-31 N missing data (%) 3 (8.33%)
condition_end_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 3 (8.33%)
condition_type_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 36 (100.00%)
stop_reason (not required) 2018-01-01 to 2018-12-31 N missing data (%) 36 (100.00%)
provider_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 36 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 36 (100.00%)
condition_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 36 (100.00%)
condition_occurrence_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_start_date (required) overall N missing data (%) 0 (0.00%)
condition_start_datetime (not required) overall N missing data (%) 0 (0.00%)
condition_end_date (not required) overall N missing data (%) 49 (19.92%)
condition_end_datetime (not required) overall N missing data (%) 49 (19.92%)
condition_type_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 246 (100.00%)
stop_reason (not required) overall N missing data (%) 246 (100.00%)
provider_id (not required) overall N missing data (%) 246 (100.00%)
N zeros (%) 0 (0.00%)
visit_occurrence_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 246 (100.00%)
condition_source_value (not required) overall N missing data (%) 0 (0.00%)
condition_source_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
condition_status_source_value (not required) overall N missing data (%) 246 (100.00%)
drug_exposure; overall; overall
drug_exposure_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2012-01-01 to 2012-12-31 N missing data (%) 43 (9.17%)
drug_type_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2012-01-01 to 2012-12-31 N missing data (%) 469 (100.00%)
refills (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2012-01-01 to 2012-12-31 N missing data (%) 469 (100.00%)
route_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 469 (100.00%)
lot_number (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 469 (100.00%)
visit_occurrence_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 3 (0.64%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 469 (100.00%)
drug_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 469 (100.00%)
dose_unit_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 469 (100.00%)
drug_exposure_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2013-01-01 to 2013-12-31 N missing data (%) 56 (11.45%)
drug_type_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2013-01-01 to 2013-12-31 N missing data (%) 489 (100.00%)
refills (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2013-01-01 to 2013-12-31 N missing data (%) 489 (100.00%)
route_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 489 (100.00%)
lot_number (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 489 (100.00%)
visit_occurrence_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 3 (0.61%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 489 (100.00%)
drug_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 489 (100.00%)
dose_unit_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 489 (100.00%)
drug_exposure_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2014-01-01 to 2014-12-31 N missing data (%) 62 (13.30%)
drug_type_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2014-01-01 to 2014-12-31 N missing data (%) 466 (100.00%)
refills (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2014-01-01 to 2014-12-31 N missing data (%) 466 (100.00%)
route_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 466 (100.00%)
lot_number (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 466 (100.00%)
visit_occurrence_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 5 (1.07%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 466 (100.00%)
drug_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 466 (100.00%)
dose_unit_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 466 (100.00%)
drug_exposure_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2015-01-01 to 2015-12-31 N missing data (%) 48 (11.91%)
drug_type_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2015-01-01 to 2015-12-31 N missing data (%) 403 (100.00%)
refills (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2015-01-01 to 2015-12-31 N missing data (%) 403 (100.00%)
route_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 403 (100.00%)
lot_number (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 403 (100.00%)
visit_occurrence_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 3 (0.74%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 403 (100.00%)
drug_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 403 (100.00%)
dose_unit_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 403 (100.00%)
drug_exposure_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2016-01-01 to 2016-12-31 N missing data (%) 58 (13.09%)
drug_type_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2016-01-01 to 2016-12-31 N missing data (%) 443 (100.00%)
refills (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2016-01-01 to 2016-12-31 N missing data (%) 443 (100.00%)
route_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 443 (100.00%)
lot_number (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 443 (100.00%)
visit_occurrence_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 2 (0.45%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 443 (100.00%)
drug_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 443 (100.00%)
dose_unit_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 443 (100.00%)
drug_exposure_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2017-01-01 to 2017-12-31 N missing data (%) 68 (15.11%)
drug_type_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2017-01-01 to 2017-12-31 N missing data (%) 450 (100.00%)
refills (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2017-01-01 to 2017-12-31 N missing data (%) 450 (100.00%)
route_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 450 (100.00%)
lot_number (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 450 (100.00%)
visit_occurrence_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 6 (1.33%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 450 (100.00%)
drug_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 450 (100.00%)
dose_unit_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 450 (100.00%)
drug_exposure_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2018-01-01 to 2018-12-31 N missing data (%) 61 (14.84%)
drug_type_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2018-01-01 to 2018-12-31 N missing data (%) 411 (100.00%)
refills (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2018-01-01 to 2018-12-31 N missing data (%) 411 (100.00%)
route_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 411 (100.00%)
lot_number (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 411 (100.00%)
visit_occurrence_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 5 (1.22%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 411 (100.00%)
drug_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 411 (100.00%)
dose_unit_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 411 (100.00%)
drug_exposure_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
drug_type_concept_id (required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2019-01-01 to 2019-12-31 N missing data (%) 3 (100.00%)
refills (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2019-01-01 to 2019-12-31 N missing data (%) 3 (100.00%)
route_concept_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 3 (100.00%)
lot_number (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 3 (100.00%)
visit_occurrence_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 3 (100.00%)
drug_source_value (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2019-01-01 to 2019-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2019-01-01 to 2019-12-31 N missing data (%) 3 (100.00%)
dose_unit_source_value (not required) 2019-01-01 to 2019-12-31 N missing data (%) 3 (100.00%)
drug_exposure_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) overall N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) overall N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) overall N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) overall N missing data (%) 0 (0.00%)
verbatim_end_date (not required) overall N missing data (%) 396 (12.64%)
drug_type_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) overall N missing data (%) 3,134 (100.00%)
refills (not required) overall N missing data (%) 0 (0.00%)
quantity (not required) overall N missing data (%) 0 (0.00%)
days_supply (not required) overall N missing data (%) 0 (0.00%)
sig (not required) overall N missing data (%) 3,134 (100.00%)
route_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 3,134 (100.00%)
lot_number (not required) overall N missing data (%) 0 (0.00%)
provider_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 3,134 (100.00%)
visit_occurrence_id (not required) overall N missing data (%) 27 (0.86%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 3,134 (100.00%)
drug_source_value (not required) overall N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) overall N missing data (%) 3,134 (100.00%)
dose_unit_source_value (not required) overall N missing data (%) 3,134 (100.00%)
drug_exposure; 65 to 150; overall
drug_exposure_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2012-01-01 to 2012-12-31 N missing data (%) 10 (13.16%)
drug_type_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2012-01-01 to 2012-12-31 N missing data (%) 76 (100.00%)
refills (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2012-01-01 to 2012-12-31 N missing data (%) 76 (100.00%)
route_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 76 (100.00%)
lot_number (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 76 (100.00%)
visit_occurrence_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 1 (1.32%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 76 (100.00%)
drug_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 76 (100.00%)
dose_unit_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 76 (100.00%)
drug_exposure_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2013-01-01 to 2013-12-31 N missing data (%) 18 (22.22%)
drug_type_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2013-01-01 to 2013-12-31 N missing data (%) 81 (100.00%)
refills (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2013-01-01 to 2013-12-31 N missing data (%) 81 (100.00%)
route_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 81 (100.00%)
lot_number (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 81 (100.00%)
visit_occurrence_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 81 (100.00%)
drug_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 81 (100.00%)
dose_unit_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 81 (100.00%)
drug_exposure_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2014-01-01 to 2014-12-31 N missing data (%) 15 (20.55%)
drug_type_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2014-01-01 to 2014-12-31 N missing data (%) 73 (100.00%)
refills (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2014-01-01 to 2014-12-31 N missing data (%) 73 (100.00%)
route_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 73 (100.00%)
lot_number (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 73 (100.00%)
visit_occurrence_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 73 (100.00%)
drug_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 73 (100.00%)
dose_unit_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 73 (100.00%)
drug_exposure_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2015-01-01 to 2015-12-31 N missing data (%) 17 (20.48%)
drug_type_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2015-01-01 to 2015-12-31 N missing data (%) 83 (100.00%)
refills (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2015-01-01 to 2015-12-31 N missing data (%) 83 (100.00%)
route_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 83 (100.00%)
lot_number (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 83 (100.00%)
visit_occurrence_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 83 (100.00%)
drug_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 83 (100.00%)
dose_unit_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 83 (100.00%)
drug_exposure_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2016-01-01 to 2016-12-31 N missing data (%) 17 (13.60%)
drug_type_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2016-01-01 to 2016-12-31 N missing data (%) 125 (100.00%)
refills (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2016-01-01 to 2016-12-31 N missing data (%) 125 (100.00%)
route_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 125 (100.00%)
lot_number (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 125 (100.00%)
visit_occurrence_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 1 (0.80%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 125 (100.00%)
drug_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 125 (100.00%)
dose_unit_source_value (not required) 2016-01-01 to 2016-12-31 N missing data (%) 125 (100.00%)
drug_exposure_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2017-01-01 to 2017-12-31 N missing data (%) 29 (21.32%)
drug_type_concept_id (required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2017-01-01 to 2017-12-31 N missing data (%) 136 (100.00%)
refills (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2017-01-01 to 2017-12-31 N missing data (%) 136 (100.00%)
route_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 136 (100.00%)
lot_number (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 136 (100.00%)
visit_occurrence_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 2 (1.47%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 136 (100.00%)
drug_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2017-01-01 to 2017-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 136 (100.00%)
dose_unit_source_value (not required) 2017-01-01 to 2017-12-31 N missing data (%) 136 (100.00%)
drug_exposure_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2018-01-01 to 2018-12-31 N missing data (%) 17 (14.91%)
drug_type_concept_id (required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2018-01-01 to 2018-12-31 N missing data (%) 114 (100.00%)
refills (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2018-01-01 to 2018-12-31 N missing data (%) 114 (100.00%)
route_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 114 (100.00%)
lot_number (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 114 (100.00%)
visit_occurrence_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 1 (0.88%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 114 (100.00%)
drug_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2018-01-01 to 2018-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 114 (100.00%)
dose_unit_source_value (not required) 2018-01-01 to 2018-12-31 N missing data (%) 114 (100.00%)
drug_exposure_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) overall N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) overall N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) overall N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) overall N missing data (%) 0 (0.00%)
verbatim_end_date (not required) overall N missing data (%) 123 (17.88%)
drug_type_concept_id (required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) overall N missing data (%) 688 (100.00%)
refills (not required) overall N missing data (%) 0 (0.00%)
quantity (not required) overall N missing data (%) 0 (0.00%)
days_supply (not required) overall N missing data (%) 0 (0.00%)
sig (not required) overall N missing data (%) 688 (100.00%)
route_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 688 (100.00%)
lot_number (not required) overall N missing data (%) 0 (0.00%)
provider_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 688 (100.00%)
visit_occurrence_id (not required) overall N missing data (%) 5 (0.73%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 688 (100.00%)
drug_source_value (not required) overall N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) overall N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) overall N missing data (%) 688 (100.00%)
dose_unit_source_value (not required) overall N missing data (%) 688 (100.00%)
drug_exposure; 18 to 64; overall
drug_exposure_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2012-01-01 to 2012-12-31 N missing data (%) 33 (8.40%)
drug_type_concept_id (required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2012-01-01 to 2012-12-31 N missing data (%) 393 (100.00%)
refills (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2012-01-01 to 2012-12-31 N missing data (%) 393 (100.00%)
route_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 393 (100.00%)
lot_number (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 393 (100.00%)
visit_occurrence_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 2 (0.51%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 393 (100.00%)
drug_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2012-01-01 to 2012-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 393 (100.00%)
dose_unit_source_value (not required) 2012-01-01 to 2012-12-31 N missing data (%) 393 (100.00%)
drug_exposure_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2013-01-01 to 2013-12-31 N missing data (%) 38 (9.31%)
drug_type_concept_id (required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2013-01-01 to 2013-12-31 N missing data (%) 408 (100.00%)
refills (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2013-01-01 to 2013-12-31 N missing data (%) 408 (100.00%)
route_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 408 (100.00%)
lot_number (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 408 (100.00%)
visit_occurrence_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 3 (0.74%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 408 (100.00%)
drug_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2013-01-01 to 2013-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 408 (100.00%)
dose_unit_source_value (not required) 2013-01-01 to 2013-12-31 N missing data (%) 408 (100.00%)
drug_exposure_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2014-01-01 to 2014-12-31 N missing data (%) 47 (11.96%)
drug_type_concept_id (required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2014-01-01 to 2014-12-31 N missing data (%) 393 (100.00%)
refills (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2014-01-01 to 2014-12-31 N missing data (%) 393 (100.00%)
route_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 393 (100.00%)
lot_number (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 393 (100.00%)
visit_occurrence_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 5 (1.27%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 393 (100.00%)
drug_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2014-01-01 to 2014-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 393 (100.00%)
dose_unit_source_value (not required) 2014-01-01 to 2014-12-31 N missing data (%) 393 (100.00%)
drug_exposure_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2015-01-01 to 2015-12-31 N missing data (%) 31 (9.69%)
drug_type_concept_id (required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2015-01-01 to 2015-12-31 N missing data (%) 320 (100.00%)
refills (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2015-01-01 to 2015-12-31 N missing data (%) 320 (100.00%)
route_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 320 (100.00%)
lot_number (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
provider_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 320 (100.00%)
visit_occurrence_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 3 (0.94%)
N zeros (%) 0 (0.00%)
visit_detail_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 320 (100.00%)
drug_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
drug_source_concept_id (not required) 2015-01-01 to 2015-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
route_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 320 (100.00%)
dose_unit_source_value (not required) 2015-01-01 to 2015-12-31 N missing data (%) 320 (100.00%)
drug_exposure_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
person_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
drug_exposure_start_date (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
drug_exposure_start_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_date (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
drug_exposure_end_datetime (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
verbatim_end_date (not required) 2016-01-01 to 2016-12-31 N missing data (%) 41 (12.89%)
drug_type_concept_id (required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 0 (0.00%)
stop_reason (not required) 2016-01-01 to 2016-12-31 N missing data (%) 318 (100.00%)
refills (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
quantity (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
days_supply (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
sig (not required) 2016-01-01 to 2016-12-31 N missing data (%) 318 (100.00%)
route_concept_id (not required) 2016-01-01 to 2016-12-31 N missing data (%) 0 (0.00%)
N zeros (%) 318 (100.00%)