Returns the distribution of a certain condition duration in days.
Input:
| Parameter |
Example |
Mandatory |
Notes |
| concept_id |
200219 |
Yes |
Abdominal Pain |
Sample query run:
The following is a sample run of the query. The input parameters are highlighted in blue.
SELECT ca.condition_era_end_date-condition_era_start_date + 1 AS num_condition_duration_days,
count(*) AS condition_duration_freq_count
FROM condition_era ca,
vocabulary.concept c
WHERE c.concept_id = 200219
AND ca.condition_concept_id = c.concept_id
GROUP BY c.concept_id,
c.concept_name,
ca.condition_era_end_date-condition_era_start_date
ORDER BY 1
Output:
Output field list:
| Field |
Description |
| num_condition_duration_days |
Number of days condition diagnozed |
| condition_duration_freq_count |
The frequency of the condition |
Sample output record:
| Field |
Value |
| num_condition_duration_days |
9 |
| condition_duration_freq_count |
9077 |
| 