{ "output_column_name": "onset_date", "comparison_levels": [ { "sql_condition": "`onset_date_l` IS NULL OR `onset_date_r` IS NULL", "label_for_charts": "Null", "is_null_level": true }, { "sql_condition": "`onset_date_precision_l` IS NULL OR `onset_date_precision_r` IS NULL", "label_for_charts": "Null", "is_null_level": true }, { "sql_condition": "onset_date_precision_l = 'a' OR onset_date_precision_r = 'a'", "label_for_charts": "Precision is year level", "is_null_level": true }, { "sql_condition": "((onset_date_precision_l = 'd' AND onset_date_precision_r = 'd') AND substring(onset_date_l, 1, 10) = substring(onset_date_r, 1, 10))", "label_for_charts": "Exact match", "m_probability": 0.008781686156932093, "u_probability": 0.0003800898016987395 }, { "sql_condition": "((onset_date_precision_l = 'mo' OR onset_date_precision_r = 'mo') AND substring(onset_date_l, 1, 7) = substring(onset_date_r, 1, 7))", "label_for_charts": "Exact match on month", "m_probability": 0.012227534768256604, "u_probability": 0.0006739407408271768 }, { "sql_condition": "onset_date_precision_l = 'd' AND onset_date_precision_r = 'd' AND substring(onset_date_l, 1, 7) = substring(onset_date_r, 1, 7)", "label_for_charts": "Same month different day", "m_probability": 0.17938137267318346, "u_probability": 0.009970745648461522 }, { "sql_condition": "(onset_date_precision_l IN ('mo', 'd') AND onset_date_precision_r IN ('mo', 'd') AND CAST(substring(onset_date_l, 6, 2) AS INT) - CAST(substring(onset_date_r, 6, 2) AS INT) BETWEEN -1 AND 1)", "label_for_charts": "Within one month", "m_probability": 0.17896392715687087, "u_probability": 0.22941113166127605 }, { "sql_condition": "ELSE", "label_for_charts": "All other comparisons", "m_probability": 0.620645479244757, "u_probability": 0.7595640921477365 } ], "comparison_description": "Date comparison for onset_date" }