R/x_print_concept_siblings.R
print_concept_siblings.RdPrint all of a concept's parents and siblings.
print_concept_siblings( concept_obj, level_of_separation_type = c("max", "min"), write_schema = "patelm9", vocab_schema = "omop_vocabulary", conn, conn_fun = "connectAthena()", cache_only = FALSE, skip_cache = FALSE, override_cache = FALSE, verbose = TRUE, render_sql = TRUE, render_only = FALSE )
| concept_obj | Concept class object or a concept id. |
|---|
#> [2021-05-26 16:07:23] Connected to 'athena'#>#>#> ✓ Concept Id is a valid integer#>#> ── Lookup Concept Id in Concept Table ──────────────────────────────────────────#> ✓ Concept Id `1308216` found in Concept Table#>#> ── Lookup Synonyms ─────────────────────────────────────────────────────────────#>#> ── Lookup 'Maps to' Concept Names ──────────────────────────────────────────────concept_obj#> An object of class "concept" #> Slot "concept_id": #> [1] 1308216 #> #> Slot "concept_name": #> [1] "lisinopril" #> #> Slot "concept_synonym_names": #> [1] "" #> #> Slot "maps_to_concept_names": #> [1] "lisinopril" #> #> Slot "domain_id": #> [1] "Drug" #> #> Slot "vocabulary_id": #> [1] "RxNorm" #> #> Slot "concept_class_id": #> [1] "Ingredient" #> #> Slot "standard_concept": #> [1] "S" #> #> Slot "concept_code": #> [1] "29046" #> #> Slot "valid_start_date": #> [1] "1970-01-01" #> #> Slot "valid_end_date": #> [1] "2099-12-31" #> #> Slot "invalid_reason": #> [1] NA #>print_concept_siblings(conn = conn, concept_obj = concept_obj)#> [2021-05-26 16:07:24] Loading Cache... #> [2021-05-26 16:07:24] Cached SQL: SELECT * FROM omop_vocabulary.concept c WHERE c.concept_id IN (1308216) #> [2021-05-26 16:07:24] Cached resultset found... #> [2021-05-26 16:07:24] Target column: concept_hierarchy_id #> [2021-05-26 16:07:24] Dropping patelm9.V20210526160724... #> [2021-05-26 16:07:24] ✓ Open connection #> [2021-05-26 16:07:24] ✓ JDBC connection #> [2021-05-26 16:07:24] SQL: DROP TABLE IF EXISTS patelm9.V20210526160724; #> [2021-05-26 16:07:24] Sending... #> [2021-05-26 16:07:24] Sending...complete #> [2021-05-26 16:07:24] Dropping patelm9.V20210526160724...complete #> [2021-05-26 16:07:24] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:24] Writing patelm9.V20210526160724... #> [2021-05-26 16:07:24] Writing patelm9.V20210526160724...complete #> [2021-05-26 16:07:24] ✓ Open connection #> [2021-05-26 16:07:24] ✓ JDBC connection #> [2021-05-26 16:07:24] SQL: SELECT a.*, b.ancestor_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160724 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.concept_hierarchy_id = b.descendant_concept_id #> [2021-05-26 16:07:24] Querying... #> [2021-05-26 16:07:24] Querying...complete #> [2021-05-26 16:07:24] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:24] Dropping patelm9.V20210526160724... #> [2021-05-26 16:07:24] ✓ Open connection #> [2021-05-26 16:07:24] ✓ JDBC connection #> [2021-05-26 16:07:24] SQL: DROP TABLE IF EXISTS patelm9.V20210526160724; #> [2021-05-26 16:07:24] Sending... #> [2021-05-26 16:07:24] Sending...complete #> [2021-05-26 16:07:24] Dropping patelm9.V20210526160724...complete #> [2021-05-26 16:07:24] Target column: ancestor_concept_id #> [2021-05-26 16:07:24] Dropping patelm9.V20210526160724... #> [2021-05-26 16:07:24] ✓ Open connection #> [2021-05-26 16:07:24] ✓ JDBC connection #> [2021-05-26 16:07:24] SQL: DROP TABLE IF EXISTS patelm9.V20210526160724; #> [2021-05-26 16:07:24] Sending... #> [2021-05-26 16:07:24] Sending...complete #> [2021-05-26 16:07:24] Dropping patelm9.V20210526160724...complete #> [2021-05-26 16:07:24] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:24] Writing patelm9.V20210526160724... #> [2021-05-26 16:07:24] Writing patelm9.V20210526160724...complete #> [2021-05-26 16:07:24] ✓ Open connection #> [2021-05-26 16:07:24] ✓ JDBC connection #> [2021-05-26 16:07:24] SQL: SELECT a.*, b.* FROM patelm9.V20210526160724 a LEFT JOIN omop_vocabulary.concept b ON a.ancestor_concept_id = b.concept_id WHERE b.invalid_reason IS NULL #> [2021-05-26 16:07:24] Querying... #> [2021-05-26 16:07:24] Querying...complete #> [2021-05-26 16:07:24] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:24] Dropping patelm9.V20210526160724... #> [2021-05-26 16:07:24] ✓ Open connection #> [2021-05-26 16:07:24] ✓ JDBC connection #> [2021-05-26 16:07:24] SQL: DROP TABLE IF EXISTS patelm9.V20210526160724; #> [2021-05-26 16:07:24] Sending... #> [2021-05-26 16:07:24] Sending...complete #> [2021-05-26 16:07:24] Dropping patelm9.V20210526160724...complete #> [2021-05-26 16:07:24] Target column: parent_id #> [2021-05-26 16:07:24] Dropping patelm9.V20210526160724... #> [2021-05-26 16:07:24] ✓ Open connection #> [2021-05-26 16:07:24] ✓ JDBC connection #> [2021-05-26 16:07:24] SQL: DROP TABLE IF EXISTS patelm9.V20210526160724; #> [2021-05-26 16:07:24] Sending... #> [2021-05-26 16:07:24] Sending...complete #> [2021-05-26 16:07:24] Dropping patelm9.V20210526160724...complete #> [2021-05-26 16:07:24] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:24] Writing patelm9.V20210526160724... #> [2021-05-26 16:07:24] Writing patelm9.V20210526160724...complete #> [2021-05-26 16:07:24] ✓ Open connection #> [2021-05-26 16:07:24] ✓ JDBC connection #> [2021-05-26 16:07:24] SQL: SELECT a.*, b.descendant_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160724 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.parent_id = b.ancestor_concept_id #> [2021-05-26 16:07:24] Querying... #> [2021-05-26 16:07:24] Querying...complete #> [2021-05-26 16:07:24] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:24] Dropping patelm9.V20210526160724... #> [2021-05-26 16:07:24] ✓ Open connection #> [2021-05-26 16:07:24] ✓ JDBC connection #> [2021-05-26 16:07:24] SQL: DROP TABLE IF EXISTS patelm9.V20210526160724; #> [2021-05-26 16:07:24] Sending... #> [2021-05-26 16:07:24] Sending...complete #> [2021-05-26 16:07:24] Dropping patelm9.V20210526160724...complete #> [2021-05-26 16:07:24] Target column: descendant_concept_id #> [2021-05-26 16:07:24] Dropping patelm9.V20210526160724... #> [2021-05-26 16:07:24] ✓ Open connection #> [2021-05-26 16:07:24] ✓ JDBC connection #> [2021-05-26 16:07:24] SQL: DROP TABLE IF EXISTS patelm9.V20210526160724; #> [2021-05-26 16:07:24] Sending... #> [2021-05-26 16:07:24] Sending...complete #> [2021-05-26 16:07:24] Dropping patelm9.V20210526160724...complete #> [2021-05-26 16:07:24] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:24] Writing patelm9.V20210526160724... #> [2021-05-26 16:07:25] Writing patelm9.V20210526160724...complete #> [2021-05-26 16:07:25] ✓ Open connection #> [2021-05-26 16:07:25] ✓ JDBC connection #> [2021-05-26 16:07:25] SQL: SELECT a.*, b.* FROM patelm9.V20210526160724 a LEFT JOIN omop_vocabulary.concept b ON a.descendant_concept_id = b.concept_id WHERE b.invalid_reason IS NULL #> [2021-05-26 16:07:25] Querying... #> [2021-05-26 16:07:26] Querying...complete #> [2021-05-26 16:07:26] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:26] Dropping patelm9.V20210526160724... #> [2021-05-26 16:07:26] ✓ Open connection #> [2021-05-26 16:07:26] ✓ JDBC connection #> [2021-05-26 16:07:26] SQL: DROP TABLE IF EXISTS patelm9.V20210526160724; #> [2021-05-26 16:07:26] Sending... #> [2021-05-26 16:07:26] Sending...complete #> [2021-05-26 16:07:26] Dropping patelm9.V20210526160724...complete #> [V] [C] 21601488 hydrochlorothiazide, combinations [ATC C03AX01] [Drug] [ATC 5th] #> *[V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [S] 902427 timolol [RxNorm 10600] [Drug] [Ingredient] #> [V] [S] 970250 spironolactone [RxNorm 9997] [Drug] [Ingredient] #> [V] [S] 1307863 verapamil [RxNorm 11170] [Drug] [Ingredient] #> [V] [S] 1310756 moexipril [RxNorm 30131] [Drug] [Ingredient] #> [V] [S] 1335471 benazepril [RxNorm 18867] [Drug] [Ingredient] #> [V] [S] 1353766 propranolol [RxNorm 8787] [Drug] [Ingredient] #> [V] [S] 1362225 reserpine [RxNorm 9260] [Drug] [Ingredient] #> [V] [S] 1367500 losartan [RxNorm 52175] [Drug] [Ingredient] #> [V] [S] 1386957 labetalol [RxNorm 6185] [Drug] [Ingredient] #> [V] [S] 19005147 methotrimeprazine [RxNorm 6852] [Drug] [Ingredient] #> [V] [S] 19062195 rescinnamine [RxNorm 9259] [Drug] [Ingredient] #> [V] [S] 19081284 alprenolol [RxNorm 597] [Drug] [Ingredient] #> [V] [S] 19081429 hydrochlorothiazide 100 MG [RxNorm 316045] [Drug] [Clinical Drug Comp] #> [V] [S] 19081454 hydrochlorothiazide 30 MG [RxNorm 316050] [Drug] [Clinical Drug Comp] #> [V] [S] 19102107 zofenopril [RxNorm 39990] [Drug] [Ingredient] #> [V] [S] 40161710 european olive pollen extract [RxNorm 852653] [Drug] [Ingredient] #> [V] [S] 40174794 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Hydrap-ES] [RxNorm 905398] [Drug] [Branded Drug Comp] #> [V] [S] 40174796 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Ser-Ap-Es] [RxNorm 905366] [Drug] [Branded Drug Comp] #> [V] [S] 40174798 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Serpazide] [RxNorm 905404] [Drug] [Branded Drug Comp] #> [V] [S] 40828862 Hydralazine 25 MG / Hydrochlorothiazide 12.5 MG / Metoprolol 100 MG [Triloc] [RxNorm Extension OMOP2026824] [Drug] [Branded Drug Comp] #> [V] [S] 40954046 Dihydralazine 10 MG / Hydrochlorothiazide 10 MG / Reserpine 0.1 MG [Triniton] [RxNorm Extension OMOP2152008] [Drug] [Branded Drug Comp] #> [V] [S] 40984746 Hydrochlorothiazide 8.33 MG / Propranolol 50 MG / Triamterene 15 MG [Dociton] [RxNorm Extension OMOP2182708] [Drug] [Branded Drug Comp] #> [V] [S] 41015891 Hydrochlorothiazide 12.5 MG / mepindolol 5 MG [Corindocomb] [RxNorm Extension OMOP2213853] [Drug] [Branded Drug Comp] #> [V] [S] 41079799 Aesculus hippocastanum bark extract 18000 MG / Hydrochlorothiazide 250 MG / Triamterene 500 MG [Diu Venostasi] [RxNorm Extension OMOP2277761] [Drug] [Branded Drug Comp] #> [V] [S] 41141753 Dihydralazine 10 MG / Hydrochlorothiazide 15 MG / Reserpine 0.1 MG [Adelfan] [RxNorm Extension OMOP2339715] [Drug] [Branded Drug Comp] #> [V] [S] 42898418 Aesculus hippocastanum bark extract [RxNorm 1309398] [Drug] [Ingredient] #> [V] [S] 42898958 Crataegus laevigata fruit [RxNorm 1310259] [Drug] [Ingredient] #> [V] [S] 43744013 Hydrochlorothiazide 12.5 MG / Propranolol 80 MG / Triamterene 25 MG [Dociteren] [RxNorm Extension OMOP781218] [Drug] [Branded Drug Comp] #> [V] [S] 43761841 Hydrochlorothiazide 12.5 MG / Verapamil 240 MG [Isoptin Rr] [RxNorm Extension OMOP780565] [Drug] [Branded Drug Comp] #> [V] [S] 44080227 Hydrochlorothiazide 25 MG / Pindolol 10 MG [Viskazide] [RxNorm Extension OMOP1074858] [Drug] [Branded Drug Comp] #> [V] [S] 1307046 metoprolol [RxNorm 6918] [Drug] [Ingredient] #> [V] [S] 1308842 valsartan [RxNorm 69749] [Drug] [Ingredient] #> [V] [S] 1332418 amlodipine [RxNorm 17767] [Drug] [Ingredient] #> [V] [S] 1338005 bisoprolol [RxNorm 19484] [Drug] [Ingredient] #> [V] [S] 1341927 enalapril [RxNorm 3827] [Drug] [Ingredient] #> [V] [S] 1363749 fosinopril [RxNorm 50166] [Drug] [Ingredient] #> [V] [S] 42938512 Amlodipine 10 MG / Hydrochlorothiazide 12.5 MG / telmisartan 80 MG [TWOTOPS PLUS] [RxNorm Extension OMOP4665185] [Drug] [Branded Drug Comp] #> [V] [S] 41267046 Aesculus hippocastanum bark extract 7200 MG / Hydrochlorothiazide 100 MG / Triamterene 200 MG [Diu Venostasi] [RxNorm Extension OMOP2465008] [Drug] [Branded Drug Comp] #> [V] [S] 41266184 Dihydralazine 11.6 MG / Hydrochlorothiazide 10 MG / Reserpine 0.1 MG [Adelfan] [RxNorm Extension OMOP2464146] [Drug] [Branded Drug Comp] #> [V] [S] 41265707 Hydrochlorothiazide 12.5 MG / Propranolol 80 MG / Triamterene 25 MG [Manimon] [RxNorm Extension OMOP2463669] [Drug] [Branded Drug Comp] #> [V] [S] 41263674 Hydrochlorothiazide 8.33 MG [RxNorm Extension OMOP2461636] [Drug] [Clinical Drug Comp] #> [V] [S] 41048070 Bunitrolol 30 MG / Hydrochlorothiazide 12.5 MG / Triamterene 25 MG [Salcant] [RxNorm Extension OMOP2246032] [Drug] [Branded Drug Comp] #> [V] [S] 41047124 Hydrochlorothiazide 12.5 MG / Propranolol 80 MG / Triamterene 25 MG [Beta Turfa] [RxNorm Extension OMOP2245086] [Drug] [Branded Drug Comp] #> [V] [S] 41016284 Dihydralazine 10 MG / Hydrochlorothiazide 10 MG / Reserpine 0.1 MG [Adelphan] [RxNorm Extension OMOP2214246] [Drug] [Branded Drug Comp] #> [V] [S] 40982713 Hydrochlorothiazide 150 MG [RxNorm Extension OMOP2180675] [Drug] [Clinical Drug Comp] #> [V] [S] 40954047 Dihydralazine 10 MG / Hydrochlorothiazide 10 MG / Potassium 300 MG / Reserpine 0.1 MG [Elfanex] [RxNorm Extension OMOP2152009] [Drug] [Branded Drug Comp] #> [V] [S] 40922379 Hydrochlorothiazide 10 MG / Potassium 250 MG / Rauwolfia preparation 1 MG / rescinnamine 0.19 MG / Reserpine 0.025 MG / Vitamin A 15000 UNT / Vitamin E 5 MG [Regulaserp] [RxNorm Extension OMOP2120341] [Drug] [Branded Drug Comp] #> [V] [S] 40858139 Hydrochlorothiazide 17 MG [RxNorm Extension OMOP2056101] [Drug] [Clinical Drug Comp] #> [V] [S] 40174800 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Tri-Hydroserpine] [RxNorm 905408] [Drug] [Branded Drug Comp] #> [V] [S] 40174792 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Diuretic Ap-Es] [RxNorm 905354] [Drug] [Branded Drug Comp] #> [V] [S] 19072028 mepindolol [RxNorm 29518] [Drug] [Ingredient] #> [V] [S] 19008339 vitamin A [RxNorm 11246] [Drug] [Ingredient] #> [V] [S] 1370109 sotalol [RxNorm 9947] [Drug] [Ingredient] #> [V] [S] 44028483 Hydrochlorothiazide 50 MG / Pindolol 10 MG [Viskazide] [RxNorm Extension OMOP1023114] [Drug] [Branded Drug Comp] #> [V] [S] 991382 amiloride [RxNorm 644] [Drug] [Ingredient] #> [V] [S] 1305447 methyldopa [RxNorm 6876] [Drug] [Ingredient] #> [V] [S] 1317640 telmisartan [RxNorm 73494] [Drug] [Ingredient] #> [V] [S] 1319998 acebutolol [RxNorm 149] [Drug] [Ingredient] #> [V] [S] 1326378 Rauwolfia preparation [RxNorm 78678] [Drug] [Ingredient] #> [V] [S] 1328165 diltiazem [RxNorm 3443] [Drug] [Ingredient] #> [V] [S] 1331235 quinapril [RxNorm 35208] [Drug] [Ingredient] #> [V] [S] 1387219 deserpidine [RxNorm 62174] [Drug] [Ingredient] #> [V] [S] 19024904 oxprenolol [RxNorm 7801] [Drug] [Ingredient] #> [V] [S] 19049024 potassium [RxNorm 8588] [Drug] [Ingredient] #> [V] [S] 19050216 cilazapril [RxNorm 21102] [Drug] [Ingredient] #> [V] [S] 19081455 hydrochlorothiazide 50 MG [RxNorm 316051] [Drug] [Clinical Drug Comp] #> [V] [S] 19109563 hydrochlorothiazide 10 MG [RxNorm 439014] [Drug] [Clinical Drug Comp] #> [V] [S] 40174795 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Marpres] [RxNorm 905400] [Drug] [Branded Drug Comp] #> [V] [S] 40174799 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Serpex] [RxNorm 905406] [Drug] [Branded Drug Comp] #> [V] [S] 40798588 6-(Diethylaminomethyl)Rutin [RxNorm Extension OMOP2720931] [Drug] [Ingredient] #> [V] [S] 40861405 Aesculus hippocastanum bark extract 18000 MG / Hydrochlorothiazide 250 MG / Triamterene 500 MG [Diu Venostasin] [RxNorm Extension OMOP2059367] [Drug] [Branded Drug Comp] #> [V] [S] 40922378 Hydrochlorothiazide 12.5 MG / Propranolol 80 MG / Triamterene 25 MG [Beta Nephral] [RxNorm Extension OMOP2120340] [Drug] [Branded Drug Comp] #> [V] [S] 40922390 Hydralazine 25 MG / Hydrochlorothiazide 12.5 MG / Metoprolol 50 MG [Treloc] [RxNorm Extension OMOP2120352] [Drug] [Branded Drug Comp] #> [V] [S] 40984748 european olive pollen extract 14 MG / Hydrochlorothiazide 10 MG / Potassium 150 MG [Olivysat] [RxNorm Extension OMOP2182710] [Drug] [Branded Drug Comp] #> [V] [S] 41015869 Hydrochlorothiazide 12.5 MG / Verapamil 240 MG [Isoptin] [RxNorm Extension OMOP2213831] [Drug] [Branded Drug Comp] #> [V] [S] 41111245 6-(Diethylaminomethyl)Rutin 17 MG / CRATAEGUS LAEVIGATA FRUIT 20 MG / Hexamethonium Hydroxide 40 MG / Hydrochlorothiazide 17 MG / Potassium 145 MG / Rauwolfia preparation 0.5 MG / Reserpine 0.075 MG [Raucombin] [RxNorm Extension OMOP2309207] [Drug] [Branded Drug Comp] #> [V] [S] 41204375 Dihydralazine 10 MG / Hydrochlorothiazide 10 MG / Reserpine 0.1 MG [Adelfan] [RxNorm Extension OMOP2402337] [Drug] [Branded Drug Comp] #> [V] [S] 42938508 Amlodipine 10 MG / Hydrochlorothiazide 25 MG / telmisartan 80 MG [TWOTOPS PLUS] [RxNorm Extension OMOP4665182] [Drug] [Branded Drug Comp] #> [V] [S] 42938518 Amlodipine 5 MG / Hydrochlorothiazide 12.5 MG / telmisartan 40 MG [TWOTOPS PLUS] [RxNorm Extension OMOP4665191] [Drug] [Branded Drug Comp] #> [V] [S] 43009001 fimasartan potassium [RxNorm Extension OMOP4700427] [Drug] [Ingredient] #> [V] [S] 43744011 Hydrochlorothiazide 25 MG / Triamterene 50 MG / Verapamil 160 MG [Veratide] [RxNorm Extension OMOP780625] [Drug] [Branded Drug Comp] #> [V] [S] 44818465 Aesculus hippocastanum seed oil [RxNorm 1535452] [Drug] [Ingredient] #> [V] [S] 904542 triamterene [RxNorm 10763] [Drug] [Ingredient] #> [V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [S] 1314002 atenolol [RxNorm 1202] [Drug] [Ingredient] #> [V] [S] 1314577 nebivolol [RxNorm 31555] [Drug] [Ingredient] #> [V] [S] 1334456 ramipril [RxNorm 35296] [Drug] [Ingredient] #> [V] [S] 1340128 captopril [RxNorm 1998] [Drug] [Ingredient] #> [V] [S] 1345858 pindolol [RxNorm 8332] [Drug] [Ingredient] #> [V] [S] 1346686 eprosartan [RxNorm 83515] [Drug] [Ingredient] #> [V] [S] 1347384 irbesartan [RxNorm 83818] [Drug] [Ingredient] #> [V] [S] 1351557 candesartan [RxNorm 214354] [Drug] [Ingredient] #> [V] [S] 1366279 guanethidine [RxNorm 5036] [Drug] [Ingredient] #> [V] [S] 1373928 hydralazine [RxNorm 5470] [Drug] [Ingredient] #> [V] [S] 1398937 clonidine [RxNorm 2599] [Drug] [Ingredient] #> [V] [S] 19009540 vitamin E [RxNorm 11256] [Drug] [Ingredient] #> [V] [S] 19026448 dihydralazine [RxNorm 3409] [Drug] [Ingredient] #> [V] [S] 19081451 hydrochlorothiazide 12.5 MG [RxNorm 316047] [Drug] [Clinical Drug Comp] #> [V] [S] 19081452 hydrochlorothiazide 15 MG [RxNorm 316048] [Drug] [Clinical Drug Comp] #> [V] [S] 19081453 hydrochlorothiazide 25 MG [RxNorm 316049] [Drug] [Clinical Drug Comp] #> [V] [S] 19092849 magnesium chloride [RxNorm 6579] [Drug] [Ingredient] #> [V] [S] 40174793 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [HHR] [RxNorm 966590] [Drug] [Branded Drug Comp] #> [V] [S] 40174797 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Serathide] [RxNorm 905402] [Drug] [Branded Drug Comp] #> [V] [S] 40174801 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Uni Serp] [RxNorm 905410] [Drug] [Branded Drug Comp] #> [V] [S] 40174802 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Unipres] [RxNorm 905412] [Drug] [Branded Drug Comp] #> [V] [S] 40226742 olmesartan [RxNorm 321064] [Drug] [Ingredient] #> [V] [S] 40798674 Bunitrolol [RxNorm Extension OMOP2721027] [Drug] [Ingredient] #> [V] [S] 40798879 Hexamethonium Hydroxide [RxNorm Extension OMOP2721212] [Drug] [Ingredient] #> [V] [S] 40828848 Hydrochlorothiazide 12.5 MG / Propranolol 160 MG / Triamterene 25 MG [Tripranol] [RxNorm Extension OMOP2026810] [Drug] [Branded Drug Comp] #> [V] [S] 40860143 Hydrochlorothiazide 12.5 MG / Propranolol 80 MG / Triamterene 25 MG [Betathiazid] [RxNorm Extension OMOP2058105] [Drug] [Branded Drug Comp] #> [V] [S] 40860157 Hydralazine 25 MG / Hydrochlorothiazide 12.5 MG / Metoprolol 100 MG [Treloc] [RxNorm Extension OMOP2058119] [Drug] [Branded Drug Comp] #> [V] [S] 40892546 Alprenolol 130 MG / Hydrochlorothiazide 10 MG [Antra] [RxNorm Extension OMOP2090508] [Drug] [Branded Drug Comp] #> [V] [S] 40954885 Aesculus hippocastanum bark extract 7200 MG / Hydrochlorothiazide 100 MG / Triamterene 200 MG [Diu Venostasin] [RxNorm Extension OMOP2152847] [Drug] [Branded Drug Comp] #> [V] [S] 40984736 Hydrochlorothiazide 25 MG / Triamterene 50 MG / Verapamil 160 MG [Confit] [RxNorm Extension OMOP2182698] [Drug] [Branded Drug Comp] #> [V] [S] 41047123 Hydrochlorothiazide 12.5 MG / Propranolol 80 MG / Triamterene 25 MG [Propra] [RxNorm Extension OMOP2245085] [Drug] [Branded Drug Comp] #> [V] [S] 41079798 Aesculus hippocastanum bark extract 3600 MG / Hydrochlorothiazide 150 MG / Triamterene 300 MG [Diu Venostasi] [RxNorm Extension OMOP2277760] [Drug] [Branded Drug Comp] #> [V] [S] 41232930 Hydrochlorothiazide 250 MG [RxNorm Extension OMOP2430892] [Drug] [Clinical Drug Comp] #> [V] [S] 41265708 Hydrochlorothiazide 12.5 MG / Propranolol 80 MG / Triamterene 25 MG [Diutensat] [RxNorm Extension OMOP2463670] [Drug] [Branded Drug Comp] #> [V] [S] 41298032 Aesculus hippocastanum bark extract 3600 MG / Hydrochlorothiazide 150 MG / Triamterene 300 MG [Diu Venostasin] [RxNorm Extension OMOP2495994] [Drug] [Branded Drug Comp] #> [V] [S] 42938515 Amlodipine 5 MG / Hydrochlorothiazide 12.5 MG / telmisartan 80 MG [TWOTOPS PLUS] [RxNorm Extension OMOP4665188] [Drug] [Branded Drug Comp] #> [V] [S] 43654119 Hydrochlorothiazide 12.5 MG / Propranolol 80 MG / Triamterene 25 MG [Beta-Turfa Gamma] [RxNorm Extension OMOP781229] [Drug] [Branded Drug Comp] #> [V] [C] 21601784 ACE inhibitors, plain [ATC C09AA] [Drug] [ATC 4th] #> *[V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [C] 21601792 cilazapril; oral [ATC C09AA08] [Drug] [ATC 5th] #> [V] [C] 21601786 enalapril; systemic [ATC C09AA02] [Drug] [ATC 5th] #> [V] [C] 21601797 moexipril; oral [ATC C09AA13] [Drug] [ATC 5th] #> [V] [C] 21601799 zofenopril; oral [ATC C09AA15] [Drug] [ATC 5th] #> [V] [C] 21601788 perindopril; oral [ATC C09AA04] [Drug] [ATC 5th] #> [V] [S] 43009010 temocapril hydrochloride [RxNorm Extension OMOP4700436] [Drug] [Ingredient] #> [V] [S] 19122327 imidapril [RxNorm 60245] [Drug] [Ingredient] #> [V] [S] 19102107 zofenopril [RxNorm 39990] [Drug] [Ingredient] #> [V] [S] 1335471 benazepril [RxNorm 18867] [Drug] [Ingredient] #> [V] [S] 1310756 moexipril [RxNorm 30131] [Drug] [Ingredient] #> [V] [S] 1331235 quinapril [RxNorm 35208] [Drug] [Ingredient] #> [V] [S] 19040051 spirapril [RxNorm 36908] [Drug] [Ingredient] #> [V] [S] 19050216 cilazapril [RxNorm 21102] [Drug] [Ingredient] #> [V] [S] 36878917 delapril hydrochloride [RxNorm Extension OMOP1000254] [Drug] [Ingredient] #> [V] [C] 21601791 benazepril; oral [ATC C09AA07] [Drug] [ATC 5th] #> [V] [C] 21601787 lisinopril; oral [ATC C09AA03] [Drug] [ATC 5th] #> [V] [C] 21601796 delapril; oral [ATC C09AA12] [Drug] [ATC 5th] #> [V] [C] 21601794 trandolapril; oral [ATC C09AA10] [Drug] [ATC 5th] #> [V] [C] 21601789 ramipril; oral [ATC C09AA05] [Drug] [ATC 5th] #> [V] [C] 21601793 fosinopril; oral [ATC C09AA09] [Drug] [ATC 5th] #> [V] [C] 21601800 imidapril; oral [ATC C09AA16] [Drug] [ATC 5th] #> [V] [C] 21601790 quinapril; systemic [ATC C09AA06] [Drug] [ATC 5th] #> [V] [C] 21601785 captopril; oral [ATC C09AA01] [Drug] [ATC 5th] #> [V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [S] 1334456 ramipril [RxNorm 35296] [Drug] [Ingredient] #> [V] [S] 1340128 captopril [RxNorm 1998] [Drug] [Ingredient] #> [V] [S] 1342439 trandolapril [RxNorm 38454] [Drug] [Ingredient] #> [V] [S] 1341927 enalapril [RxNorm 3827] [Drug] [Ingredient] #> [V] [S] 1342001 enalaprilat [RxNorm 3829] [Drug] [Ingredient] #> [V] [S] 1363749 fosinopril [RxNorm 50166] [Drug] [Ingredient] #> [V] [S] 1373225 perindopril [RxNorm 54552] [Drug] [Ingredient] #> [V] [C] 21601795 spirapril; oral [ATC C09AA11] [Drug] [ATC 5th] #> [V] [C] 21601798 temocapril; oral [ATC C09AA14] [Drug] [ATC 5th] #> [V] [C] 21601802 ACE inhibitors and diuretics [ATC C09BA] [Drug] [ATC 4th] #> *[V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [C] 21601807 ramipril and diuretics [ATC C09BA05] [Drug] [ATC 5th] #> [V] [C] 21601803 captopril and diuretics [ATC C09BA01] [Drug] [ATC 5th] #> [V] [C] 21601809 benazepril and diuretics; oral [ATC C09BA07] [Drug] [ATC 5th] #> [V] [C] 21601805 lisinopril and diuretics [ATC C09BA03] [Drug] [ATC 5th] #> [V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [S] 1334456 ramipril [RxNorm 35296] [Drug] [Ingredient] #> [V] [S] 1340128 captopril [RxNorm 1998] [Drug] [Ingredient] #> [V] [S] 36878917 delapril hydrochloride [RxNorm Extension OMOP1000254] [Drug] [Ingredient] #> [V] [S] 19050216 cilazapril [RxNorm 21102] [Drug] [Ingredient] #> [V] [S] 1331235 quinapril [RxNorm 35208] [Drug] [Ingredient] #> [V] [C] 21601810 cilazapril and diuretics [ATC C09BA08] [Drug] [ATC 5th] #> [V] [C] 21601813 moexipril and diuretics [ATC C09BA13] [Drug] [ATC 5th] #> [V] [C] 21601812 delapril and diuretics [ATC C09BA12] [Drug] [ATC 5th] #> [V] [C] 21601804 enalapril and diuretics [ATC C09BA02] [Drug] [ATC 5th] #> [V] [S] 1310756 moexipril [RxNorm 30131] [Drug] [Ingredient] #> [V] [S] 1335471 benazepril [RxNorm 18867] [Drug] [Ingredient] #> [V] [S] 19102107 zofenopril [RxNorm 39990] [Drug] [Ingredient] #> [V] [S] 1341927 enalapril [RxNorm 3827] [Drug] [Ingredient] #> [V] [S] 1342001 enalaprilat [RxNorm 3829] [Drug] [Ingredient] #> [V] [S] 1363749 fosinopril [RxNorm 50166] [Drug] [Ingredient] #> [V] [S] 1373225 perindopril [RxNorm 54552] [Drug] [Ingredient] #> [V] [C] 21601811 fosinopril and diuretics [ATC C09BA09] [Drug] [ATC 5th] #> [V] [C] 21601808 quinapril and diuretics [ATC C09BA06] [Drug] [ATC 5th] #> [V] [C] 21601814 zofenopril and diuretics [ATC C09BA15] [Drug] [ATC 5th] #> [V] [C] 21601806 perindopril and diuretics [ATC C09BA04] [Drug] [ATC 5th] #> [V] [C] 21601815 ACE inhibitors and calcium channel blockers [ATC C09BB] [Drug] [ATC 4th] #> *[V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [S] 36878917 delapril hydrochloride [RxNorm Extension OMOP1000254] [Drug] [Ingredient] #> [V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [S] 1334456 ramipril [RxNorm 35296] [Drug] [Ingredient] #> [V] [S] 1342439 trandolapril [RxNorm 38454] [Drug] [Ingredient] #> [V] [S] 19015802 lercanidipine [RxNorm 135056] [Drug] [Ingredient] #> [V] [C] 40256150 ramipril and amlodipine [ATC C09BB07] [Drug] [ATC 5th] #> [V] [C] 21601819 ramipril and felodipine [ATC C09BB05] [Drug] [ATC 5th] #> [V] [C] 21601818 perindopril and amlodipine [ATC C09BB04] [Drug] [ATC 5th] #> [V] [C] 21601820 trandolapril and verapamil [ATC C09BB10] [Drug] [ATC 5th] #> [V] [C] 21601821 delapril and manidipine [ATC C09BB12] [Drug] [ATC 5th] #> [V] [S] 1332418 amlodipine [RxNorm 17767] [Drug] [Ingredient] #> [V] [S] 1341927 enalapril [RxNorm 3827] [Drug] [Ingredient] #> [V] [S] 1342001 enalaprilat [RxNorm 3829] [Drug] [Ingredient] #> [V] [S] 1353776 felodipine [RxNorm 4316] [Drug] [Ingredient] #> [V] [S] 1373225 perindopril [RxNorm 54552] [Drug] [Ingredient] #> [V] [C] 21601817 lisinopril and amlodipine [ATC C09BB03] [Drug] [ATC 5th] #> [V] [C] 21601816 enalapril and lercanidipine [ATC C09BB02] [Drug] [ATC 5th] #> [V] [C] 40256149 enalapril and nitrendipine [ATC C09BB06] [Drug] [ATC 5th] #> [V] [S] 1307863 verapamil [RxNorm 11170] [Drug] [Ingredient] #> [V] [S] 19020061 nitrendipine [RxNorm 7441] [Drug] [Ingredient] #> [V] [S] 19071995 manidipine [RxNorm 29275] [Drug] [Ingredient] #> [V] [C] 21601903 HMG CoA reductase inhibitors, other combinations [ATC C10BX] [Drug] [ATC 4th] #> *[V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [C] 40251722 simvastatin, acetylsalicylic acid and ramipril [ATC C10BX04] [Drug] [ATC 5th] #> [V] [C] 45893492 rosuvastatin and amlodipine [ATC C10BX09] [Drug] [ATC 5th] #> [V] [C] 1502051 atorvastatin and perindopril [ATC C10BX15] [Drug] [ATC 5th] #> [V] [C] 715861 rosuvastatin and ramipril [ATC C10BX17] [Drug] [ATC 5th] #> [V] [C] 21601905 pravastatin and acetylsalicylic acid [ATC C10BX02] [Drug] [ATC 5th] #> [V] [S] 1510813 rosuvastatin [RxNorm 301542] [Drug] [Ingredient] #> [V] [S] 1539403 simvastatin [RxNorm 36567] [Drug] [Ingredient] #> [V] [S] 1551860 pravastatin [RxNorm 42463] [Drug] [Ingredient] #> [V] [C] 21601906 atorvastatin and amlodipine [ATC C10BX03] [Drug] [ATC 5th] #> [V] [C] 43534778 rosuvastatin and acetylsalicylic acid [ATC C10BX05] [Drug] [ATC 5th] #> [V] [C] 45893493 rosuvastatin, amlodipine and lisinopril [ATC C10BX07] [Drug] [ATC 5th] #> [V] [C] 1588687 rosuvastatin and valsartan [ATC C10BX10] [Drug] [ATC 5th] #> [V] [S] 1545958 atorvastatin [RxNorm 83367] [Drug] [Ingredient] #> [V] [S] 1373225 perindopril [RxNorm 54552] [Drug] [Ingredient] #> [V] [S] 1332418 amlodipine [RxNorm 17767] [Drug] [Ingredient] #> [V] [S] 1308842 valsartan [RxNorm 69749] [Drug] [Ingredient] #> [V] [S] 978555 indapamide [RxNorm 5764] [Drug] [Ingredient] #> [V] [S] 1112807 aspirin [RxNorm 1191] [Drug] [Ingredient] #> [V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [S] 1334456 ramipril [RxNorm 35296] [Drug] [Ingredient] #> [V] [C] 1588653 atorvastatin, amlodipine and perindopril [ATC C10BX11] [Drug] [ATC 5th] #> [V] [C] 1123623 atorvastatin, acetylsalicylic acid and perindopril [ATC C10BX12] [Drug] [ATC 5th] #> [V] [C] 1501780 rosuvastatin, amlodipine and perindopril [ATC C10BX14] [Drug] [ATC 5th] #> [V] [C] 45893500 atorvastatin, acetylsalicylic acid and ramipril [ATC C10BX06] [Drug] [ATC 5th] #> [V] [C] 21601904 simvastatin and acetylsalicylic acid; oral [ATC C10BX01] [Drug] [ATC 5th] #> [V] [C] 1501791 rosuvastatin, perindopril and indapamide [ATC C10BX13] [Drug] [ATC 5th] #> [V] [C] 45893511 atorvastatin and acetylsalicylic acid [ATC C10BX08] [Drug] [ATC 5th] #> [V] [C] 715859 rosuvastatin and fimasartan [ATC C10BX16] [Drug] [ATC 5th]print_concept_siblings(conn = conn, concept_obj = concept_obj, level_of_separation_type = "min")#> [2021-05-26 16:07:26] Loading Cache... #> [2021-05-26 16:07:26] Cached SQL: SELECT * FROM omop_vocabulary.concept c WHERE c.concept_id IN (1308216) #> [2021-05-26 16:07:26] Cached resultset found... #> [2021-05-26 16:07:26] Target column: concept_hierarchy_id #> [2021-05-26 16:07:26] Dropping patelm9.V20210526160726... #> [2021-05-26 16:07:26] ✓ Open connection #> [2021-05-26 16:07:26] ✓ JDBC connection #> [2021-05-26 16:07:26] SQL: DROP TABLE IF EXISTS patelm9.V20210526160726; #> [2021-05-26 16:07:26] Sending... #> [2021-05-26 16:07:26] Sending...complete #> [2021-05-26 16:07:26] Dropping patelm9.V20210526160726...complete #> [2021-05-26 16:07:26] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:26] Writing patelm9.V20210526160726... #> [2021-05-26 16:07:26] Writing patelm9.V20210526160726...complete #> [2021-05-26 16:07:26] ✓ Open connection #> [2021-05-26 16:07:26] ✓ JDBC connection #> [2021-05-26 16:07:26] SQL: SELECT a.*, b.ancestor_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160726 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.concept_hierarchy_id = b.descendant_concept_id #> [2021-05-26 16:07:26] Querying... #> [2021-05-26 16:07:26] Querying...complete #> [2021-05-26 16:07:26] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:26] Dropping patelm9.V20210526160726... #> [2021-05-26 16:07:26] ✓ Open connection #> [2021-05-26 16:07:26] ✓ JDBC connection #> [2021-05-26 16:07:26] SQL: DROP TABLE IF EXISTS patelm9.V20210526160726; #> [2021-05-26 16:07:26] Sending... #> [2021-05-26 16:07:26] Sending...complete #> [2021-05-26 16:07:26] Dropping patelm9.V20210526160726...complete #> [2021-05-26 16:07:26] Target column: ancestor_concept_id #> [2021-05-26 16:07:26] Dropping patelm9.V20210526160726... #> [2021-05-26 16:07:26] ✓ Open connection #> [2021-05-26 16:07:26] ✓ JDBC connection #> [2021-05-26 16:07:26] SQL: DROP TABLE IF EXISTS patelm9.V20210526160726; #> [2021-05-26 16:07:26] Sending... #> [2021-05-26 16:07:26] Sending...complete #> [2021-05-26 16:07:26] Dropping patelm9.V20210526160726...complete #> [2021-05-26 16:07:26] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:26] Writing patelm9.V20210526160726... #> [2021-05-26 16:07:26] Writing patelm9.V20210526160726...complete #> [2021-05-26 16:07:26] ✓ Open connection #> [2021-05-26 16:07:26] ✓ JDBC connection #> [2021-05-26 16:07:26] SQL: SELECT a.*, b.* FROM patelm9.V20210526160726 a LEFT JOIN omop_vocabulary.concept b ON a.ancestor_concept_id = b.concept_id WHERE b.invalid_reason IS NULL #> [2021-05-26 16:07:26] Querying... #> [2021-05-26 16:07:26] Querying...complete #> [2021-05-26 16:07:26] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:26] Dropping patelm9.V20210526160726... #> [2021-05-26 16:07:26] ✓ Open connection #> [2021-05-26 16:07:26] ✓ JDBC connection #> [2021-05-26 16:07:26] SQL: DROP TABLE IF EXISTS patelm9.V20210526160726; #> [2021-05-26 16:07:26] Sending... #> [2021-05-26 16:07:26] Sending...complete #> [2021-05-26 16:07:26] Dropping patelm9.V20210526160726...complete #> [2021-05-26 16:07:26] Target column: parent_id #> [2021-05-26 16:07:26] Dropping patelm9.V20210526160726... #> [2021-05-26 16:07:26] ✓ Open connection #> [2021-05-26 16:07:26] ✓ JDBC connection #> [2021-05-26 16:07:26] SQL: DROP TABLE IF EXISTS patelm9.V20210526160726; #> [2021-05-26 16:07:26] Sending... #> [2021-05-26 16:07:26] Sending...complete #> [2021-05-26 16:07:26] Dropping patelm9.V20210526160726...complete #> [2021-05-26 16:07:26] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:26] Writing patelm9.V20210526160726... #> [2021-05-26 16:07:26] Writing patelm9.V20210526160726...complete #> [2021-05-26 16:07:26] ✓ Open connection #> [2021-05-26 16:07:26] ✓ JDBC connection #> [2021-05-26 16:07:26] SQL: SELECT a.*, b.descendant_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160726 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.parent_id = b.ancestor_concept_id #> [2021-05-26 16:07:26] Querying... #> [2021-05-26 16:07:27] Querying...complete #> [2021-05-26 16:07:27] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:27] Dropping patelm9.V20210526160726... #> [2021-05-26 16:07:27] ✓ Open connection #> [2021-05-26 16:07:27] ✓ JDBC connection #> [2021-05-26 16:07:27] SQL: DROP TABLE IF EXISTS patelm9.V20210526160726; #> [2021-05-26 16:07:27] Sending... #> [2021-05-26 16:07:27] Sending...complete #> [2021-05-26 16:07:27] Dropping patelm9.V20210526160726...complete #> [2021-05-26 16:07:27] Target column: descendant_concept_id #> [2021-05-26 16:07:27] Dropping patelm9.V20210526160727... #> [2021-05-26 16:07:27] ✓ Open connection #> [2021-05-26 16:07:27] ✓ JDBC connection #> [2021-05-26 16:07:27] SQL: DROP TABLE IF EXISTS patelm9.V20210526160727; #> [2021-05-26 16:07:27] Sending... #> [2021-05-26 16:07:27] Sending...complete #> [2021-05-26 16:07:27] Dropping patelm9.V20210526160727...complete #> [2021-05-26 16:07:27] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:27] Writing patelm9.V20210526160727... #> [2021-05-26 16:07:27] Writing patelm9.V20210526160727...complete #> [2021-05-26 16:07:27] ✓ Open connection #> [2021-05-26 16:07:27] ✓ JDBC connection #> [2021-05-26 16:07:27] SQL: SELECT a.*, b.* FROM patelm9.V20210526160727 a LEFT JOIN omop_vocabulary.concept b ON a.descendant_concept_id = b.concept_id WHERE b.invalid_reason IS NULL #> [2021-05-26 16:07:27] Querying... #> [2021-05-26 16:07:27] Querying...complete #> [2021-05-26 16:07:27] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:27] Dropping patelm9.V20210526160727... #> [2021-05-26 16:07:27] ✓ Open connection #> [2021-05-26 16:07:27] ✓ JDBC connection #> [2021-05-26 16:07:27] SQL: DROP TABLE IF EXISTS patelm9.V20210526160727; #> [2021-05-26 16:07:27] Sending... #> [2021-05-26 16:07:27] Sending...complete #> [2021-05-26 16:07:27] Dropping patelm9.V20210526160727...complete #> [V] [C] 21601488 hydrochlorothiazide, combinations [ATC C03AX01] [Drug] [ATC 5th] #> *[V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [S] 902427 timolol [RxNorm 10600] [Drug] [Ingredient] #> [V] [S] 970250 spironolactone [RxNorm 9997] [Drug] [Ingredient] #> [V] [S] 1307863 verapamil [RxNorm 11170] [Drug] [Ingredient] #> [V] [S] 1310756 moexipril [RxNorm 30131] [Drug] [Ingredient] #> [V] [S] 1335471 benazepril [RxNorm 18867] [Drug] [Ingredient] #> [V] [S] 1353766 propranolol [RxNorm 8787] [Drug] [Ingredient] #> [V] [S] 1362225 reserpine [RxNorm 9260] [Drug] [Ingredient] #> [V] [S] 1367500 losartan [RxNorm 52175] [Drug] [Ingredient] #> [V] [S] 1386957 labetalol [RxNorm 6185] [Drug] [Ingredient] #> [V] [S] 19005147 methotrimeprazine [RxNorm 6852] [Drug] [Ingredient] #> [V] [S] 19062195 rescinnamine [RxNorm 9259] [Drug] [Ingredient] #> [V] [S] 19081284 alprenolol [RxNorm 597] [Drug] [Ingredient] #> [V] [S] 19081429 hydrochlorothiazide 100 MG [RxNorm 316045] [Drug] [Clinical Drug Comp] #> [V] [S] 19081454 hydrochlorothiazide 30 MG [RxNorm 316050] [Drug] [Clinical Drug Comp] #> [V] [S] 19102107 zofenopril [RxNorm 39990] [Drug] [Ingredient] #> [V] [S] 35154940 Amlodipine / Hydrochlorothiazide / telmisartan Oral Tablet [Micatrio] [RxNorm Extension OMOP4811961] [Drug] [Branded Drug Form] #> [V] [S] 40044450 hydralazine / hydrochlorothiazide / reserpine Oral Tablet [RxNorm 374694] [Drug] [Clinical Drug Form] #> [V] [S] 40044454 hydralazine / hydrochlorothiazide / reserpine Oral Tablet [Marpres] [RxNorm 369324] [Drug] [Branded Drug Form] #> [V] [S] 40044456 hydralazine / hydrochlorothiazide / reserpine Oral Tablet [Serathide] [RxNorm 369322] [Drug] [Branded Drug Form] #> [V] [S] 40044457 hydralazine / hydrochlorothiazide / reserpine Oral Tablet [Serpazide] [RxNorm 369321] [Drug] [Branded Drug Form] #> [V] [S] 40161710 european olive pollen extract [RxNorm 852653] [Drug] [Ingredient] #> [V] [S] 40174794 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Hydrap-ES] [RxNorm 905398] [Drug] [Branded Drug Comp] #> [V] [S] 40174796 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Ser-Ap-Es] [RxNorm 905366] [Drug] [Branded Drug Comp] #> [V] [S] 40174798 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Serpazide] [RxNorm 905404] [Drug] [Branded Drug Comp] #> [V] [S] 40828862 Hydralazine 25 MG / Hydrochlorothiazide 12.5 MG / Metoprolol 100 MG [Triloc] [RxNorm Extension OMOP2026824] [Drug] [Branded Drug Comp] #> [V] [S] 40830513 european olive pollen extract / Hydrochlorothiazide / Potassium Oral Tablet [RxNorm Extension OMOP2028475] [Drug] [Clinical Drug Form] #> [V] [S] 40833441 Alprenolol / Hydrochlorothiazide Oral Tablet [Antra] [RxNorm Extension OMOP2031403] [Drug] [Branded Drug Form] #> [V] [S] 40925600 Hydrochlorothiazide / Propranolol / Triamterene Oral Tablet [Betathiazid] [RxNorm Extension OMOP2123562] [Drug] [Branded Drug Form] #> [V] [S] 40954046 Dihydralazine 10 MG / Hydrochlorothiazide 10 MG / Reserpine 0.1 MG [Triniton] [RxNorm Extension OMOP2152008] [Drug] [Branded Drug Comp] #> [V] [S] 40984746 Hydrochlorothiazide 8.33 MG / Propranolol 50 MG / Triamterene 15 MG [Dociton] [RxNorm Extension OMOP2182708] [Drug] [Branded Drug Comp] #> [V] [S] 40986369 Hydrochlorothiazide / Propranolol / Triamterene Oral Capsule [RxNorm Extension OMOP2184331] [Drug] [Clinical Drug Form] #> [V] [S] 41015891 Hydrochlorothiazide 12.5 MG / mepindolol 5 MG [Corindocomb] [RxNorm Extension OMOP2213853] [Drug] [Branded Drug Comp] #> [V] [S] 41079799 Aesculus hippocastanum bark extract 18000 MG / Hydrochlorothiazide 250 MG / Triamterene 500 MG [Diu Venostasi] [RxNorm Extension OMOP2277761] [Drug] [Branded Drug Comp] #> [V] [S] 41113073 Hydrochlorothiazide / Potassium / Rauwolfia preparation / rescinnamine / Reserpine / Vitamin A / Vitamin E Oral Tablet [Regulaserp] [RxNorm Extension OMOP2311035] [Drug] [Branded Drug Form] #> [V] [S] 41141753 Dihydralazine 10 MG / Hydrochlorothiazide 15 MG / Reserpine 0.1 MG [Adelfan] [RxNorm Extension OMOP2339715] [Drug] [Branded Drug Comp] #> [V] [S] 41176013 Dihydralazine / Hydrochlorothiazide / Reserpine Oral Tablet [Triniton] [RxNorm Extension OMOP2373975] [Drug] [Branded Drug Form] #> [V] [S] 41176859 Aesculus hippocastanum bark extract / Hydrochlorothiazide / Triamterene Oral Tablet [Diu Venostasi] [RxNorm Extension OMOP2374821] [Drug] [Branded Drug Form] #> [V] [S] 41207573 Dihydralazine / Hydrochlorothiazide / Reserpine Oral Tablet [Adelphan] [RxNorm Extension OMOP2405535] [Drug] [Branded Drug Form] #> [V] [S] 41236983 6-(Diethylaminomethyl)Rutin / Hydrochlorothiazide Oral Tablet [RxNorm Extension OMOP2434945] [Drug] [Clinical Drug Form] #> [V] [S] 41238107 Hydrochlorothiazide / Propranolol / Triamterene Oral Capsule [Beta Nephral] [RxNorm Extension OMOP2436069] [Drug] [Branded Drug Form] #> [V] [S] 42898418 Aesculus hippocastanum bark extract [RxNorm 1309398] [Drug] [Ingredient] #> [V] [S] 42898958 Crataegus laevigata fruit [RxNorm 1310259] [Drug] [Ingredient] #> [V] [S] 42938520 Amlodipine / Hydrochlorothiazide / telmisartan Oral Tablet [TWOTOPS PLUS] [RxNorm Extension OMOP4665193] [Drug] [Branded Drug Form] #> [V] [S] 43744013 Hydrochlorothiazide 12.5 MG / Propranolol 80 MG / Triamterene 25 MG [Dociteren] [RxNorm Extension OMOP781218] [Drug] [Branded Drug Comp] #> [V] [S] 43761841 Hydrochlorothiazide 12.5 MG / Verapamil 240 MG [Isoptin Rr] [RxNorm Extension OMOP780565] [Drug] [Branded Drug Comp] #> [V] [S] 44069971 Hydrochlorothiazide / Pindolol Oral Tablet [Viskazide] [RxNorm Extension OMOP1064602] [Drug] [Branded Drug Form] #> [V] [S] 44080227 Hydrochlorothiazide 25 MG / Pindolol 10 MG [Viskazide] [RxNorm Extension OMOP1074858] [Drug] [Branded Drug Comp] #> [V] [S] 1307046 metoprolol [RxNorm 6918] [Drug] [Ingredient] #> [V] [S] 1308842 valsartan [RxNorm 69749] [Drug] [Ingredient] #> [V] [S] 1332418 amlodipine [RxNorm 17767] [Drug] [Ingredient] #> [V] [S] 1338005 bisoprolol [RxNorm 19484] [Drug] [Ingredient] #> [V] [S] 1341927 enalapril [RxNorm 3827] [Drug] [Ingredient] #> [V] [S] 1363749 fosinopril [RxNorm 50166] [Drug] [Ingredient] #> [V] [S] 42938512 Amlodipine 10 MG / Hydrochlorothiazide 12.5 MG / telmisartan 80 MG [TWOTOPS PLUS] [RxNorm Extension OMOP4665185] [Drug] [Branded Drug Comp] #> [V] [S] 41300063 Hydrochlorothiazide / Propranolol / Triamterene Oral Capsule [Tripranol] [RxNorm Extension OMOP2498025] [Drug] [Branded Drug Form] #> [V] [S] 41267046 Aesculus hippocastanum bark extract 7200 MG / Hydrochlorothiazide 100 MG / Triamterene 200 MG [Diu Venostasi] [RxNorm Extension OMOP2465008] [Drug] [Branded Drug Comp] #> [V] [S] 41266184 Dihydralazine 11.6 MG / Hydrochlorothiazide 10 MG / Reserpine 0.1 MG [Adelfan] [RxNorm Extension OMOP2464146] [Drug] [Branded Drug Comp] #> [V] [S] 41265707 Hydrochlorothiazide 12.5 MG / Propranolol 80 MG / Triamterene 25 MG [Manimon] [RxNorm Extension OMOP2463669] [Drug] [Branded Drug Comp] #> [V] [S] 41263674 Hydrochlorothiazide 8.33 MG [RxNorm Extension OMOP2461636] [Drug] [Clinical Drug Comp] #> [V] [S] 41113072 Hydrochlorothiazide / Propranolol / Triamterene Oral Tablet [Manimon] [RxNorm Extension OMOP2311034] [Drug] [Branded Drug Form] #> [V] [S] 41048070 Bunitrolol 30 MG / Hydrochlorothiazide 12.5 MG / Triamterene 25 MG [Salcant] [RxNorm Extension OMOP2246032] [Drug] [Branded Drug Comp] #> [V] [S] 41047124 Hydrochlorothiazide 12.5 MG / Propranolol 80 MG / Triamterene 25 MG [Beta Turfa] [RxNorm Extension OMOP2245086] [Drug] [Branded Drug Comp] #> [V] [S] 41016284 Dihydralazine 10 MG / Hydrochlorothiazide 10 MG / Reserpine 0.1 MG [Adelphan] [RxNorm Extension OMOP2214246] [Drug] [Branded Drug Comp] #> [V] [S] 40989474 6-(Diethylaminomethyl)Rutin / CRATAEGUS LAEVIGATA FRUIT / Hexamethonium Hydroxide / Hydrochlorothiazide / Potassium / Rauwolfia preparation / Reserpine Oral Tablet [Raucombin] [RxNorm Extension OMOP2187436] [Drug] [Branded Drug Form] #> [V] [S] 40988118 Hydrochlorothiazide / Propranolol / Triamterene Oral Tablet [Propra] [RxNorm Extension OMOP2186080] [Drug] [Branded Drug Form] #> [V] [S] 40982713 Hydrochlorothiazide 150 MG [RxNorm Extension OMOP2180675] [Drug] [Clinical Drug Comp] #> [V] [S] 40955187 Hydrochlorothiazide / Potassium / Rauwolfia preparation / rescinnamine / Reserpine / Vitamin A / Vitamin E Oral Tablet [RxNorm Extension OMOP2153149] [Drug] [Clinical Drug Form] #> [V] [S] 40954047 Dihydralazine 10 MG / Hydrochlorothiazide 10 MG / Potassium 300 MG / Reserpine 0.1 MG [Elfanex] [RxNorm Extension OMOP2152009] [Drug] [Branded Drug Comp] #> [V] [S] 40925605 Hydrochlorothiazide / mepindolol Oral Tablet [Corindocomb] [RxNorm Extension OMOP2123567] [Drug] [Branded Drug Form] #> [V] [S] 40925594 Hydrochlorothiazide / Verapamil Extended Release Oral Capsule [Isoptin] [RxNorm Extension OMOP2123556] [Drug] [Branded Drug Form] #> [V] [S] 40922379 Hydrochlorothiazide 10 MG / Potassium 250 MG / Rauwolfia preparation 1 MG / rescinnamine 0.19 MG / Reserpine 0.025 MG / Vitamin A 15000 UNT / Vitamin E 5 MG [Regulaserp] [RxNorm Extension OMOP2120341] [Drug] [Branded Drug Comp] #> [V] [S] 40893011 Dihydralazine / Hydrochlorothiazide / Potassium / Reserpine Oral Tablet [RxNorm Extension OMOP2090973] [Drug] [Clinical Drug Form] #> [V] [S] 40858139 Hydrochlorothiazide 17 MG [RxNorm Extension OMOP2056101] [Drug] [Clinical Drug Comp] #> [V] [S] 40174800 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Tri-Hydroserpine] [RxNorm 905408] [Drug] [Branded Drug Comp] #> [V] [S] 40174792 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Diuretic Ap-Es] [RxNorm 905354] [Drug] [Branded Drug Comp] #> [V] [S] 40044455 hydralazine / hydrochlorothiazide / reserpine Oral Tablet [Ser-Ap-Es] [RxNorm 369323] [Drug] [Branded Drug Form] #> [V] [S] 40034892 diltiazem / hydrochlorothiazide Extended Release Oral Capsule [RxNorm 385943] [Drug] [Clinical Drug Form] #> [V] [S] 19072028 mepindolol [RxNorm 29518] [Drug] [Ingredient] #> [V] [S] 19008339 vitamin A [RxNorm 11246] [Drug] [Ingredient] #> [V] [S] 1370109 sotalol [RxNorm 9947] [Drug] [Ingredient] #> [V] [S] 44028483 Hydrochlorothiazide 50 MG / Pindolol 10 MG [Viskazide] [RxNorm Extension OMOP1023114] [Drug] [Branded Drug Comp] #> [V] [S] 991382 amiloride [RxNorm 644] [Drug] [Ingredient] #> [V] [S] 1305447 methyldopa [RxNorm 6876] [Drug] [Ingredient] #> [V] [S] 1317640 telmisartan [RxNorm 73494] [Drug] [Ingredient] #> [V] [S] 1319998 acebutolol [RxNorm 149] [Drug] [Ingredient] #> [V] [S] 1326378 Rauwolfia preparation [RxNorm 78678] [Drug] [Ingredient] #> [V] [S] 1328165 diltiazem [RxNorm 3443] [Drug] [Ingredient] #> [V] [S] 1331235 quinapril [RxNorm 35208] [Drug] [Ingredient] #> [V] [S] 1387219 deserpidine [RxNorm 62174] [Drug] [Ingredient] #> [V] [S] 19024904 oxprenolol [RxNorm 7801] [Drug] [Ingredient] #> [V] [S] 19049024 potassium [RxNorm 8588] [Drug] [Ingredient] #> [V] [S] 19050216 cilazapril [RxNorm 21102] [Drug] [Ingredient] #> [V] [S] 19081455 hydrochlorothiazide 50 MG [RxNorm 316051] [Drug] [Clinical Drug Comp] #> [V] [S] 19109563 hydrochlorothiazide 10 MG [RxNorm 439014] [Drug] [Clinical Drug Comp] #> [V] [S] 40044449 hydralazine / hydrochlorothiazide / metoprolol Oral Tablet [RxNorm 440425] [Drug] [Clinical Drug Form] #> [V] [S] 40044453 hydralazine / hydrochlorothiazide / reserpine Oral Tablet [Hydrap-ES] [RxNorm 369325] [Drug] [Branded Drug Form] #> [V] [S] 40044458 hydralazine / hydrochlorothiazide / reserpine Oral Tablet [Serpex] [RxNorm 369320] [Drug] [Branded Drug Form] #> [V] [S] 40044459 hydralazine / hydrochlorothiazide / reserpine Oral Tablet [Tri-Hydroserpine] [RxNorm 369319] [Drug] [Branded Drug Form] #> [V] [S] 40044461 hydralazine / hydrochlorothiazide / reserpine Oral Tablet [Unipres] [RxNorm 369317] [Drug] [Branded Drug Form] #> [V] [S] 40044836 hydrochlorothiazide / pindolol Oral Tablet [RxNorm 373459] [Drug] [Clinical Drug Form] #> [V] [S] 40045121 hydrochlorothiazide / mepindolol Oral Tablet [RxNorm 446301] [Drug] [Clinical Drug Form] #> [V] [S] 40174795 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Marpres] [RxNorm 905400] [Drug] [Branded Drug Comp] #> [V] [S] 40174799 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Serpex] [RxNorm 905406] [Drug] [Branded Drug Comp] #> [V] [S] 40798588 6-(Diethylaminomethyl)Rutin [RxNorm Extension OMOP2720931] [Drug] [Ingredient] #> [V] [S] 40832236 Hydralazine / Hydrochlorothiazide / Metoprolol Oral Tablet [Treloc] [RxNorm Extension OMOP2030198] [Drug] [Branded Drug Form] #> [V] [S] 40861405 Aesculus hippocastanum bark extract 18000 MG / Hydrochlorothiazide 250 MG / Triamterene 500 MG [Diu Venostasin] [RxNorm Extension OMOP2059367] [Drug] [Branded Drug Comp] #> [V] [S] 40894607 european olive pollen extract / Hydrochlorothiazide / Potassium Oral Tablet [Olivysat] [RxNorm Extension OMOP2092569] [Drug] [Branded Drug Form] #> [V] [S] 40922378 Hydrochlorothiazide 12.5 MG / Propranolol 80 MG / Triamterene 25 MG [Beta Nephral] [RxNorm Extension OMOP2120340] [Drug] [Branded Drug Comp] #> [V] [S] 40922390 Hydralazine 25 MG / Hydrochlorothiazide 12.5 MG / Metoprolol 50 MG [Treloc] [RxNorm Extension OMOP2120352] [Drug] [Branded Drug Comp] #> [V] [S] 40925601 Hydrochlorothiazide / Propranolol / Triamterene Oral Tablet [Diutensat] [RxNorm Extension OMOP2123563] [Drug] [Branded Drug Form] #> [V] [S] 40955683 Alprenolol / Hydrochlorothiazide Oral Tablet [RxNorm Extension OMOP2153645] [Drug] [Clinical Drug Form] #> [V] [S] 40958111 Aesculus hippocastanum bark extract / Hydrochlorothiazide / Triamterene Oral Tablet [Diu Venostasin] [RxNorm Extension OMOP2156073] [Drug] [Branded Drug Form] #> [V] [S] 40984748 european olive pollen extract 14 MG / Hydrochlorothiazide 10 MG / Potassium 150 MG [Olivysat] [RxNorm Extension OMOP2182710] [Drug] [Branded Drug Comp] #> [V] [S] 40986688 Bunitrolol / Hydrochlorothiazide / Triamterene Extended Release Oral Capsule [RxNorm Extension OMOP2184650] [Drug] [Clinical Drug Form] #> [V] [S] 41015869 Hydrochlorothiazide 12.5 MG / Verapamil 240 MG [Isoptin] [RxNorm Extension OMOP2213831] [Drug] [Branded Drug Comp] #> [V] [S] 41050356 Hydrochlorothiazide / Triamterene / Verapamil Oral Tablet [Confit] [RxNorm Extension OMOP2248318] [Drug] [Branded Drug Form] #> [V] [S] 41050744 Dihydralazine / Hydrochlorothiazide / Potassium / Reserpine Oral Tablet [Elfanex] [RxNorm Extension OMOP2248706] [Drug] [Branded Drug Form] #> [V] [S] 41111245 6-(Diethylaminomethyl)Rutin 17 MG / CRATAEGUS LAEVIGATA FRUIT 20 MG / Hexamethonium Hydroxide 40 MG / Hydrochlorothiazide 17 MG / Potassium 145 MG / Rauwolfia preparation 0.5 MG / Reserpine 0.075 MG [Raucombin] [RxNorm Extension OMOP2309207] [Drug] [Branded Drug Comp] #> [V] [S] 41204375 Dihydralazine 10 MG / Hydrochlorothiazide 10 MG / Reserpine 0.1 MG [Adelfan] [RxNorm Extension OMOP2402337] [Drug] [Branded Drug Comp] #> [V] [S] 41298962 6-(Diethylaminomethyl)Rutin / CRATAEGUS LAEVIGATA FRUIT / Hexamethonium Hydroxide / Hydrochlorothiazide / Potassium / Rauwolfia preparation / Reserpine Oral Tablet [RxNorm Extension OMOP2496924] [Drug] [Clinical Drug Form] #> [V] [S] 42938508 Amlodipine 10 MG / Hydrochlorothiazide 25 MG / telmisartan 80 MG [TWOTOPS PLUS] [RxNorm Extension OMOP4665182] [Drug] [Branded Drug Comp] #> [V] [S] 42938518 Amlodipine 5 MG / Hydrochlorothiazide 12.5 MG / telmisartan 40 MG [TWOTOPS PLUS] [RxNorm Extension OMOP4665191] [Drug] [Branded Drug Comp] #> [V] [S] 43009001 fimasartan potassium [RxNorm Extension OMOP4700427] [Drug] [Ingredient] #> [V] [S] 43654117 Hydrochlorothiazide / Triamterene / Verapamil Oral Tablet [Veratide] [RxNorm Extension OMOP780615] [Drug] [Branded Drug Form] #> [V] [S] 43744011 Hydrochlorothiazide 25 MG / Triamterene 50 MG / Verapamil 160 MG [Veratide] [RxNorm Extension OMOP780625] [Drug] [Branded Drug Comp] #> [V] [S] 43834111 Hydrochlorothiazide / Propranolol / Triamterene Oral Tablet [Dociteren] [RxNorm Extension OMOP781195] [Drug] [Branded Drug Form] #> [V] [S] 44818465 Aesculus hippocastanum seed oil [RxNorm 1535452] [Drug] [Ingredient] #> [V] [S] 43672256 Hydrochlorothiazide / Propranolol / Triamterene Oral Tablet [RxNorm Extension OMOP781184] [Drug] [Clinical Drug Form] #> [V] [S] 904542 triamterene [RxNorm 10763] [Drug] [Ingredient] #> [V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [S] 1314002 atenolol [RxNorm 1202] [Drug] [Ingredient] #> [V] [S] 1314577 nebivolol [RxNorm 31555] [Drug] [Ingredient] #> [V] [S] 1334456 ramipril [RxNorm 35296] [Drug] [Ingredient] #> [V] [S] 1340128 captopril [RxNorm 1998] [Drug] [Ingredient] #> [V] [S] 1345858 pindolol [RxNorm 8332] [Drug] [Ingredient] #> [V] [S] 1346686 eprosartan [RxNorm 83515] [Drug] [Ingredient] #> [V] [S] 1347384 irbesartan [RxNorm 83818] [Drug] [Ingredient] #> [V] [S] 1351557 candesartan [RxNorm 214354] [Drug] [Ingredient] #> [V] [S] 1366279 guanethidine [RxNorm 5036] [Drug] [Ingredient] #> [V] [S] 1373928 hydralazine [RxNorm 5470] [Drug] [Ingredient] #> [V] [S] 1398937 clonidine [RxNorm 2599] [Drug] [Ingredient] #> [V] [S] 19009540 vitamin E [RxNorm 11256] [Drug] [Ingredient] #> [V] [S] 19026448 dihydralazine [RxNorm 3409] [Drug] [Ingredient] #> [V] [S] 19081451 hydrochlorothiazide 12.5 MG [RxNorm 316047] [Drug] [Clinical Drug Comp] #> [V] [S] 19081452 hydrochlorothiazide 15 MG [RxNorm 316048] [Drug] [Clinical Drug Comp] #> [V] [S] 19081453 hydrochlorothiazide 25 MG [RxNorm 316049] [Drug] [Clinical Drug Comp] #> [V] [S] 19092849 magnesium chloride [RxNorm 6579] [Drug] [Ingredient] #> [V] [S] 40033920 dihydralazine / hydrochlorothiazide / reserpine Oral Tablet [RxNorm 439015] [Drug] [Clinical Drug Form] #> [V] [S] 40044451 hydralazine / hydrochlorothiazide / reserpine Oral Tablet [Diuretic Ap-Es] [RxNorm 369326] [Drug] [Branded Drug Form] #> [V] [S] 40044452 hydralazine / hydrochlorothiazide / reserpine Oral Tablet [HHR] [RxNorm 369556] [Drug] [Branded Drug Form] #> [V] [S] 40044460 hydralazine / hydrochlorothiazide / reserpine Oral Tablet [Uni Serp] [RxNorm 369318] [Drug] [Branded Drug Form] #> [V] [S] 40044824 hydrochlorothiazide / magnesium chloride / methotrimeprazine Oral Tablet [RxNorm 440593] [Drug] [Clinical Drug Form] #> [V] [S] 40044856 hydrochlorothiazide / triamterene / verapamil Oral Tablet [RxNorm 452537] [Drug] [Clinical Drug Form] #> [V] [S] 40045118 hydrochlorothiazide / verapamil Extended Release Oral Capsule [RxNorm 452536] [Drug] [Clinical Drug Form] #> [V] [S] 40174793 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [HHR] [RxNorm 966590] [Drug] [Branded Drug Comp] #> [V] [S] 40174797 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Serathide] [RxNorm 905402] [Drug] [Branded Drug Comp] #> [V] [S] 40174801 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Uni Serp] [RxNorm 905410] [Drug] [Branded Drug Comp] #> [V] [S] 40174802 hydralazine hydrochloride 25 MG / hydrochlorothiazide 15 MG / reserpine 0.1 MG [Unipres] [RxNorm 905412] [Drug] [Branded Drug Comp] #> [V] [S] 40226742 olmesartan [RxNorm 321064] [Drug] [Ingredient] #> [V] [S] 40798674 Bunitrolol [RxNorm Extension OMOP2721027] [Drug] [Ingredient] #> [V] [S] 40798879 Hexamethonium Hydroxide [RxNorm Extension OMOP2721212] [Drug] [Ingredient] #> [V] [S] 40828848 Hydrochlorothiazide 12.5 MG / Propranolol 160 MG / Triamterene 25 MG [Tripranol] [RxNorm Extension OMOP2026810] [Drug] [Branded Drug Comp] #> [V] [S] 40860143 Hydrochlorothiazide 12.5 MG / Propranolol 80 MG / Triamterene 25 MG [Betathiazid] [RxNorm Extension OMOP2058105] [Drug] [Branded Drug Comp] #> [V] [S] 40860157 Hydralazine 25 MG / Hydrochlorothiazide 12.5 MG / Metoprolol 100 MG [Treloc] [RxNorm Extension OMOP2058119] [Drug] [Branded Drug Comp] #> [V] [S] 40863410 Hydrochlorothiazide / Propranolol / Triamterene Oral Tablet [Beta Turfa] [RxNorm Extension OMOP2061372] [Drug] [Branded Drug Form] #> [V] [S] 40892546 Alprenolol 130 MG / Hydrochlorothiazide 10 MG [Antra] [RxNorm Extension OMOP2090508] [Drug] [Branded Drug Comp] #> [V] [S] 40895458 Bunitrolol / Hydrochlorothiazide / Triamterene Extended Release Oral Capsule [Salcant] [RxNorm Extension OMOP2093420] [Drug] [Branded Drug Form] #> [V] [S] 40954885 Aesculus hippocastanum bark extract 7200 MG / Hydrochlorothiazide 100 MG / Triamterene 200 MG [Diu Venostasin] [RxNorm Extension OMOP2152847] [Drug] [Branded Drug Comp] #> [V] [S] 40984736 Hydrochlorothiazide 25 MG / Triamterene 50 MG / Verapamil 160 MG [Confit] [RxNorm Extension OMOP2182698] [Drug] [Branded Drug Comp] #> [V] [S] 41019068 Hydrochlorothiazide / Propranolol / Triamterene Oral Tablet [Dociton] [RxNorm Extension OMOP2217030] [Drug] [Branded Drug Form] #> [V] [S] 41019465 Dihydralazine / Hydrochlorothiazide / Reserpine Oral Tablet [Adelfan] [RxNorm Extension OMOP2217427] [Drug] [Branded Drug Form] #> [V] [S] 41047123 Hydrochlorothiazide 12.5 MG / Propranolol 80 MG / Triamterene 25 MG [Propra] [RxNorm Extension OMOP2245085] [Drug] [Branded Drug Comp] #> [V] [S] 41079798 Aesculus hippocastanum bark extract 3600 MG / Hydrochlorothiazide 150 MG / Triamterene 300 MG [Diu Venostasi] [RxNorm Extension OMOP2277760] [Drug] [Branded Drug Comp] #> [V] [S] 41174481 Aesculus hippocastanum bark extract / Hydrochlorothiazide / Triamterene Oral Tablet [RxNorm Extension OMOP2372443] [Drug] [Clinical Drug Form] #> [V] [S] 41175631 Hydralazine / Hydrochlorothiazide / Metoprolol Oral Tablet [Triloc] [RxNorm Extension OMOP2373593] [Drug] [Branded Drug Form] #> [V] [S] 41232930 Hydrochlorothiazide 250 MG [RxNorm Extension OMOP2430892] [Drug] [Clinical Drug Comp] #> [V] [S] 41265708 Hydrochlorothiazide 12.5 MG / Propranolol 80 MG / Triamterene 25 MG [Diutensat] [RxNorm Extension OMOP2463670] [Drug] [Branded Drug Comp] #> [V] [S] 41298032 Aesculus hippocastanum bark extract 3600 MG / Hydrochlorothiazide 150 MG / Triamterene 300 MG [Diu Venostasin] [RxNorm Extension OMOP2495994] [Drug] [Branded Drug Comp] #> [V] [S] 42938515 Amlodipine 5 MG / Hydrochlorothiazide 12.5 MG / telmisartan 80 MG [TWOTOPS PLUS] [RxNorm Extension OMOP4665188] [Drug] [Branded Drug Comp] #> [V] [S] 42938519 Amlodipine / Hydrochlorothiazide / telmisartan Oral Tablet [RxNorm Extension OMOP4665192] [Drug] [Clinical Drug Form] #> [V] [S] 43599941 Hydrochlorothiazide / Propranolol / Triamterene Oral Tablet [Beta-Turfa Gamma] [RxNorm Extension OMOP781206] [Drug] [Branded Drug Form] #> [V] [S] 43654119 Hydrochlorothiazide 12.5 MG / Propranolol 80 MG / Triamterene 25 MG [Beta-Turfa Gamma] [RxNorm Extension OMOP781229] [Drug] [Branded Drug Comp] #> [V] [S] 43744010 Hydrochlorothiazide / Verapamil Extended Release Oral Capsule [Isoptin Rr] [RxNorm Extension OMOP780554] [Drug] [Branded Drug Form] #> [V] [C] 21601784 ACE inhibitors, plain [ATC C09AA] [Drug] [ATC 4th] #> *[V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [C] 21601792 cilazapril; oral [ATC C09AA08] [Drug] [ATC 5th] #> [V] [C] 21601786 enalapril; systemic [ATC C09AA02] [Drug] [ATC 5th] #> [V] [C] 21601797 moexipril; oral [ATC C09AA13] [Drug] [ATC 5th] #> [V] [C] 21601799 zofenopril; oral [ATC C09AA15] [Drug] [ATC 5th] #> [V] [C] 21601788 perindopril; oral [ATC C09AA04] [Drug] [ATC 5th] #> [V] [S] 43009010 temocapril hydrochloride [RxNorm Extension OMOP4700436] [Drug] [Ingredient] #> [V] [S] 19122327 imidapril [RxNorm 60245] [Drug] [Ingredient] #> [V] [S] 19102107 zofenopril [RxNorm 39990] [Drug] [Ingredient] #> [V] [S] 1335471 benazepril [RxNorm 18867] [Drug] [Ingredient] #> [V] [S] 1310756 moexipril [RxNorm 30131] [Drug] [Ingredient] #> [V] [S] 1331235 quinapril [RxNorm 35208] [Drug] [Ingredient] #> [V] [S] 19040051 spirapril [RxNorm 36908] [Drug] [Ingredient] #> [V] [S] 19050216 cilazapril [RxNorm 21102] [Drug] [Ingredient] #> [V] [S] 36878917 delapril hydrochloride [RxNorm Extension OMOP1000254] [Drug] [Ingredient] #> [V] [C] 21601791 benazepril; oral [ATC C09AA07] [Drug] [ATC 5th] #> [V] [C] 21601787 lisinopril; oral [ATC C09AA03] [Drug] [ATC 5th] #> [V] [C] 21601796 delapril; oral [ATC C09AA12] [Drug] [ATC 5th] #> [V] [C] 21601794 trandolapril; oral [ATC C09AA10] [Drug] [ATC 5th] #> [V] [C] 21601789 ramipril; oral [ATC C09AA05] [Drug] [ATC 5th] #> [V] [C] 21601793 fosinopril; oral [ATC C09AA09] [Drug] [ATC 5th] #> [V] [C] 21601800 imidapril; oral [ATC C09AA16] [Drug] [ATC 5th] #> [V] [C] 21601790 quinapril; systemic [ATC C09AA06] [Drug] [ATC 5th] #> [V] [C] 21601785 captopril; oral [ATC C09AA01] [Drug] [ATC 5th] #> [V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [S] 1334456 ramipril [RxNorm 35296] [Drug] [Ingredient] #> [V] [S] 1340128 captopril [RxNorm 1998] [Drug] [Ingredient] #> [V] [S] 1342439 trandolapril [RxNorm 38454] [Drug] [Ingredient] #> [V] [S] 1341927 enalapril [RxNorm 3827] [Drug] [Ingredient] #> [V] [S] 1342001 enalaprilat [RxNorm 3829] [Drug] [Ingredient] #> [V] [S] 1363749 fosinopril [RxNorm 50166] [Drug] [Ingredient] #> [V] [S] 1373225 perindopril [RxNorm 54552] [Drug] [Ingredient] #> [V] [C] 21601795 spirapril; oral [ATC C09AA11] [Drug] [ATC 5th] #> [V] [C] 21601798 temocapril; oral [ATC C09AA14] [Drug] [ATC 5th] #> [V] [C] 21601802 ACE inhibitors and diuretics [ATC C09BA] [Drug] [ATC 4th] #> *[V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [C] 21601807 ramipril and diuretics [ATC C09BA05] [Drug] [ATC 5th] #> [V] [C] 21601803 captopril and diuretics [ATC C09BA01] [Drug] [ATC 5th] #> [V] [C] 21601809 benazepril and diuretics; oral [ATC C09BA07] [Drug] [ATC 5th] #> [V] [C] 21601805 lisinopril and diuretics [ATC C09BA03] [Drug] [ATC 5th] #> [V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [S] 1334456 ramipril [RxNorm 35296] [Drug] [Ingredient] #> [V] [S] 1340128 captopril [RxNorm 1998] [Drug] [Ingredient] #> [V] [S] 36878917 delapril hydrochloride [RxNorm Extension OMOP1000254] [Drug] [Ingredient] #> [V] [S] 19050216 cilazapril [RxNorm 21102] [Drug] [Ingredient] #> [V] [S] 1331235 quinapril [RxNorm 35208] [Drug] [Ingredient] #> [V] [C] 21601810 cilazapril and diuretics [ATC C09BA08] [Drug] [ATC 5th] #> [V] [C] 21601813 moexipril and diuretics [ATC C09BA13] [Drug] [ATC 5th] #> [V] [C] 21601812 delapril and diuretics [ATC C09BA12] [Drug] [ATC 5th] #> [V] [C] 21601804 enalapril and diuretics [ATC C09BA02] [Drug] [ATC 5th] #> [V] [S] 1310756 moexipril [RxNorm 30131] [Drug] [Ingredient] #> [V] [S] 1335471 benazepril [RxNorm 18867] [Drug] [Ingredient] #> [V] [S] 19102107 zofenopril [RxNorm 39990] [Drug] [Ingredient] #> [V] [S] 1341927 enalapril [RxNorm 3827] [Drug] [Ingredient] #> [V] [S] 1342001 enalaprilat [RxNorm 3829] [Drug] [Ingredient] #> [V] [S] 1363749 fosinopril [RxNorm 50166] [Drug] [Ingredient] #> [V] [S] 1373225 perindopril [RxNorm 54552] [Drug] [Ingredient] #> [V] [C] 21601811 fosinopril and diuretics [ATC C09BA09] [Drug] [ATC 5th] #> [V] [C] 21601808 quinapril and diuretics [ATC C09BA06] [Drug] [ATC 5th] #> [V] [C] 21601814 zofenopril and diuretics [ATC C09BA15] [Drug] [ATC 5th] #> [V] [C] 21601806 perindopril and diuretics [ATC C09BA04] [Drug] [ATC 5th] #> [V] [C] 21601815 ACE inhibitors and calcium channel blockers [ATC C09BB] [Drug] [ATC 4th] #> *[V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [S] 36878917 delapril hydrochloride [RxNorm Extension OMOP1000254] [Drug] [Ingredient] #> [V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [S] 1334456 ramipril [RxNorm 35296] [Drug] [Ingredient] #> [V] [S] 1342439 trandolapril [RxNorm 38454] [Drug] [Ingredient] #> [V] [S] 19015802 lercanidipine [RxNorm 135056] [Drug] [Ingredient] #> [V] [C] 40256150 ramipril and amlodipine [ATC C09BB07] [Drug] [ATC 5th] #> [V] [C] 21601819 ramipril and felodipine [ATC C09BB05] [Drug] [ATC 5th] #> [V] [C] 21601818 perindopril and amlodipine [ATC C09BB04] [Drug] [ATC 5th] #> [V] [C] 21601820 trandolapril and verapamil [ATC C09BB10] [Drug] [ATC 5th] #> [V] [C] 21601821 delapril and manidipine [ATC C09BB12] [Drug] [ATC 5th] #> [V] [S] 1332418 amlodipine [RxNorm 17767] [Drug] [Ingredient] #> [V] [S] 1341927 enalapril [RxNorm 3827] [Drug] [Ingredient] #> [V] [S] 1342001 enalaprilat [RxNorm 3829] [Drug] [Ingredient] #> [V] [S] 1353776 felodipine [RxNorm 4316] [Drug] [Ingredient] #> [V] [S] 1373225 perindopril [RxNorm 54552] [Drug] [Ingredient] #> [V] [C] 21601817 lisinopril and amlodipine [ATC C09BB03] [Drug] [ATC 5th] #> [V] [C] 21601816 enalapril and lercanidipine [ATC C09BB02] [Drug] [ATC 5th] #> [V] [C] 40256149 enalapril and nitrendipine [ATC C09BB06] [Drug] [ATC 5th] #> [V] [S] 1307863 verapamil [RxNorm 11170] [Drug] [Ingredient] #> [V] [S] 19020061 nitrendipine [RxNorm 7441] [Drug] [Ingredient] #> [V] [S] 19071995 manidipine [RxNorm 29275] [Drug] [Ingredient] #> [V] [C] 21601903 HMG CoA reductase inhibitors, other combinations [ATC C10BX] [Drug] [ATC 4th] #> *[V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [C] 40251722 simvastatin, acetylsalicylic acid and ramipril [ATC C10BX04] [Drug] [ATC 5th] #> [V] [C] 45893492 rosuvastatin and amlodipine [ATC C10BX09] [Drug] [ATC 5th] #> [V] [C] 1502051 atorvastatin and perindopril [ATC C10BX15] [Drug] [ATC 5th] #> [V] [C] 715861 rosuvastatin and ramipril [ATC C10BX17] [Drug] [ATC 5th] #> [V] [C] 21601905 pravastatin and acetylsalicylic acid [ATC C10BX02] [Drug] [ATC 5th] #> [V] [S] 1510813 rosuvastatin [RxNorm 301542] [Drug] [Ingredient] #> [V] [S] 1539403 simvastatin [RxNorm 36567] [Drug] [Ingredient] #> [V] [S] 1551860 pravastatin [RxNorm 42463] [Drug] [Ingredient] #> [V] [C] 21601906 atorvastatin and amlodipine [ATC C10BX03] [Drug] [ATC 5th] #> [V] [C] 43534778 rosuvastatin and acetylsalicylic acid [ATC C10BX05] [Drug] [ATC 5th] #> [V] [C] 45893493 rosuvastatin, amlodipine and lisinopril [ATC C10BX07] [Drug] [ATC 5th] #> [V] [C] 1588687 rosuvastatin and valsartan [ATC C10BX10] [Drug] [ATC 5th] #> [V] [S] 1545958 atorvastatin [RxNorm 83367] [Drug] [Ingredient] #> [V] [S] 1373225 perindopril [RxNorm 54552] [Drug] [Ingredient] #> [V] [S] 1332418 amlodipine [RxNorm 17767] [Drug] [Ingredient] #> [V] [S] 1308842 valsartan [RxNorm 69749] [Drug] [Ingredient] #> [V] [S] 978555 indapamide [RxNorm 5764] [Drug] [Ingredient] #> [V] [S] 1112807 aspirin [RxNorm 1191] [Drug] [Ingredient] #> [V] [S] 1308216 lisinopril [RxNorm 29046] [Drug] [Ingredient] #> [V] [S] 1334456 ramipril [RxNorm 35296] [Drug] [Ingredient] #> [V] [C] 1588653 atorvastatin, amlodipine and perindopril [ATC C10BX11] [Drug] [ATC 5th] #> [V] [C] 1123623 atorvastatin, acetylsalicylic acid and perindopril [ATC C10BX12] [Drug] [ATC 5th] #> [V] [C] 1501780 rosuvastatin, amlodipine and perindopril [ATC C10BX14] [Drug] [ATC 5th] #> [V] [C] 45893500 atorvastatin, acetylsalicylic acid and ramipril [ATC C10BX06] [Drug] [ATC 5th] #> [V] [C] 21601904 simvastatin and acetylsalicylic acid; oral [ATC C10BX01] [Drug] [ATC 5th] #> [V] [C] 1501791 rosuvastatin, perindopril and indapamide [ATC C10BX13] [Drug] [ATC 5th] #> [V] [C] 45893511 atorvastatin and acetylsalicylic acid [ATC C10BX08] [Drug] [ATC 5th] #> [V] [C] 715859 rosuvastatin and fimasartan [ATC C10BX16] [Drug] [ATC 5th]#>#> ── Is Concept Id Valid Integer? ────────────────────────────────────────────────#> ✓ Concept Id is a valid integer#>#> ── Lookup Concept Id in Concept Table ──────────────────────────────────────────#> ✓ Concept Id `4187868` found in Concept Table#>#> ── Lookup Synonyms ─────────────────────────────────────────────────────────────#>#> ── Lookup 'Maps to' Concept Names ──────────────────────────────────────────────concept_obj#> An object of class "concept" #> Slot "concept_id": #> [1] 4187868 #> #> Slot "concept_name": #> [1] "pTis: Ductal carcinoma in situ (breast)" #> #> Slot "concept_synonym_names": #> [1] "Ductal carcinoma in situ (breast)|pTis: Ductal carcinoma in situ (breast) (finding)" #> #> Slot "maps_to_concept_names": #> [1] "pTis: Ductal carcinoma in situ (breast)" #> #> Slot "domain_id": #> [1] "Condition" #> #> Slot "vocabulary_id": #> [1] "SNOMED" #> #> Slot "concept_class_id": #> [1] "Clinical Finding" #> #> Slot "standard_concept": #> [1] "S" #> #> Slot "concept_code": #> [1] "373176000" #> #> Slot "valid_start_date": #> [1] "2002-07-31" #> #> Slot "valid_end_date": #> [1] "2099-12-31" #> #> Slot "invalid_reason": #> [1] NA #>print_concept_siblings(conn = conn, concept_obj = concept_obj)#> [2021-05-26 16:07:28] Loading Cache... #> [2021-05-26 16:07:28] Cached SQL: SELECT * FROM omop_vocabulary.concept c WHERE c.concept_id IN (4187868) #> [2021-05-26 16:07:28] Cached resultset found... #> [2021-05-26 16:07:28] Target column: concept_hierarchy_id #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728... #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: DROP TABLE IF EXISTS patelm9.V20210526160728; #> [2021-05-26 16:07:28] Sending... #> [2021-05-26 16:07:28] Sending...complete #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:28] Writing patelm9.V20210526160728... #> [2021-05-26 16:07:28] Writing patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: SELECT a.*, b.ancestor_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160728 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.concept_hierarchy_id = b.descendant_concept_id #> [2021-05-26 16:07:28] Querying... #> [2021-05-26 16:07:28] Querying...complete #> [2021-05-26 16:07:28] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728... #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: DROP TABLE IF EXISTS patelm9.V20210526160728; #> [2021-05-26 16:07:28] Sending... #> [2021-05-26 16:07:28] Sending...complete #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] Target column: ancestor_concept_id #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728... #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: DROP TABLE IF EXISTS patelm9.V20210526160728; #> [2021-05-26 16:07:28] Sending... #> [2021-05-26 16:07:28] Sending...complete #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:28] Writing patelm9.V20210526160728... #> [2021-05-26 16:07:28] Writing patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: SELECT a.*, b.* FROM patelm9.V20210526160728 a LEFT JOIN omop_vocabulary.concept b ON a.ancestor_concept_id = b.concept_id WHERE b.invalid_reason IS NULL #> [2021-05-26 16:07:28] Querying... #> [2021-05-26 16:07:28] Querying...complete #> [2021-05-26 16:07:28] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728... #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: DROP TABLE IF EXISTS patelm9.V20210526160728; #> [2021-05-26 16:07:28] Sending... #> [2021-05-26 16:07:28] Sending...complete #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] Target column: parent_id #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728... #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: DROP TABLE IF EXISTS patelm9.V20210526160728; #> [2021-05-26 16:07:28] Sending... #> [2021-05-26 16:07:28] Sending...complete #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:28] Writing patelm9.V20210526160728... #> [2021-05-26 16:07:28] Writing patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: SELECT a.*, b.descendant_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160728 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.parent_id = b.ancestor_concept_id #> [2021-05-26 16:07:28] Querying... #> [2021-05-26 16:07:28] Querying...complete #> [2021-05-26 16:07:28] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728... #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: DROP TABLE IF EXISTS patelm9.V20210526160728; #> [2021-05-26 16:07:28] Sending... #> [2021-05-26 16:07:28] Sending...complete #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] Target column: descendant_concept_id #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728... #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: DROP TABLE IF EXISTS patelm9.V20210526160728; #> [2021-05-26 16:07:28] Sending... #> [2021-05-26 16:07:28] Sending...complete #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:28] Writing patelm9.V20210526160728... #> [2021-05-26 16:07:28] Writing patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: SELECT a.*, b.* FROM patelm9.V20210526160728 a LEFT JOIN omop_vocabulary.concept b ON a.descendant_concept_id = b.concept_id WHERE b.invalid_reason IS NULL #> [2021-05-26 16:07:28] Querying... #> [2021-05-26 16:07:28] Querying...complete #> [2021-05-26 16:07:28] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728... #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: DROP TABLE IF EXISTS patelm9.V20210526160728; #> [2021-05-26 16:07:28] Sending... #> [2021-05-26 16:07:28] Sending...complete #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728...complete #> [V] [S] 4225738 pTis category [SNOMED 84921008] [Condition] [Clinical Finding] #> *[V] [S] 4187868 pTis: Ductal carcinoma in situ (breast) [SNOMED 373176000] [Condition] [Clinical Finding] #> [V] [S] 4306969 pTis: Carcinoma in situ, intraepithelial (appendix) [SNOMED 422901001] [Condition] [Clinical Finding] #> [V] [S] 4310299 pTis: Carcinoma in situ, invasion of lamina propria (appendix) [SNOMED 423055005] [Condition] [Clinical Finding] #> [V] [S] 4263661 pTis: Flat carcinoma in situ (urinary bladder, ureter, renal pelvis) [SNOMED 396668003] [Condition] [Clinical Finding] #> [V] [S] 4216800 pTis: Carcinoma in situ, intraepithelial (colon/rectum) [SNOMED 395705003] [Condition] [Clinical Finding] #> [V] [S] 4187868 pTis: Ductal carcinoma in situ (breast) [SNOMED 373176000] [Condition] [Clinical Finding] #> [V] [S] 4263128 pTis: Intratubular germ cell neoplasia (carcinoma in situ) (testis) [SNOMED 396727002] [Condition] [Clinical Finding] #> [V] [S] 4160909 pTis: Lobular carcinoma in situ (breast) [SNOMED 373177009] [Condition] [Clinical Finding] #> [V] [S] 4188645 pTis: Tumor invades muscularis mucosae (colon/rectum) [SNOMED 373199001] [Condition] [Clinical Finding] #> [V] [S] 4158688 pTis: Carcinoma in situ (breast) [SNOMED 373175001] [Condition] [Clinical Finding] #> [V] [S] 4262735 pTis: Melanoma in situ (melanoma of the skin) [SNOMED 396369000] [Condition] [Clinical Finding] #> [V] [S] 4188646 pTis: Carcinoma in situ, invasion of lamina propria [SNOMED 373201004] [Condition] [Clinical Finding] #> [V] [S] 4187869 pTis: Paget disease without invasive carcinoma (breast) [SNOMED 373178004] [Condition] [Clinical Finding] #> [V] [S] 4300154 Breast TNM finding [SNOMED 385417002] [Condition] [Clinical Finding] #> *[V] [S] 4187868 pTis: Ductal carcinoma in situ (breast) [SNOMED 373176000] [Condition] [Clinical Finding] #> [V] [S] 763114 Neoplasm of breast regional lymph node staging category pN0 as per American Joint Committee on Cancer 7th edition [SNOMED 436231000124107] [Condition] [Clinical Finding] #> [V] [S] 763113 Neoplasm of breast distant metastasis staging category cM0(i+) as per American Joint Committee on Cancer 7th edition [SNOMED 436221000124109] [Condition] [Clinical Finding] #> [V] [S] 4158682 pN0: No regional lymph node metastasis histologically (i.e., none greater than 0.2 mm), no additional examination for isolated tumor cells (breast) [SNOMED 373151001] [Condition] [Clinical Finding] #> [V] [S] 763109 Neoplasm of breast primary tumor staging category TX: Primary tumor cannot be assessed [SNOMED 436181000124100] [Condition] [Clinical Finding] #> [V] [S] 765662 Neoplasm of breast regional lymph node staging category pN0(mol+): Positive molecular findings, but no regional lymph node metastasis detected by histology or immunohistochemistry [SNOMED 436101000124109] [Condition] [Clinical Finding] #> [V] [S] 762891 Neoplasm of breast primary tumor staging category T4: Direct extension to chest wall and/or skin beyond dermis [SNOMED 433401000124109] [Condition] [Clinical Finding] #> [V] [S] 4158683 pN1mi: Micrometastasis (greater than 0.2 mm, none greater than 2.0 mm) (breast) [SNOMED 373157002] [Condition] [Clinical Finding] #> [V] [S] 763108 Neoplasm of breast primary tumor staging category Tis (Paget's) [SNOMED 436171000124103] [Condition] [Clinical Finding] #> [V] [S] 4187869 pTis: Paget disease without invasive carcinoma (breast) [SNOMED 373178004] [Condition] [Clinical Finding] #> [V] [S] 762889 Neoplasm of breast primary tumor staging category T1mi: Tumor <=1 mm in greatest dimension [SNOMED 433381000124109] [Condition] [Clinical Finding] #> [V] [S] 4188643 pT3: Tumor more than 5 cm in greatest dimension (breast) [SNOMED 373184001] [Condition] [Clinical Finding] #> [V] [S] 4230028 pN0(i+): No regional lymph node metastasis histologically, positive morphologic findings for isolated tumor cells, no cluster greater than 0.2 mm (breast) [SNOMED 406089009] [Condition] [Clinical Finding] #> [V] [S] 4187868 pTis: Ductal carcinoma in situ (breast) [SNOMED 373176000] [Condition] [Clinical Finding] #> [V] [S] 762888 Neoplasm of breast primary tumor staging category T0: No evidence of primary tumor [SNOMED 433371000124106] [Condition] [Clinical Finding] #> [V] [S] 4158688 pTis: Carcinoma in situ (breast) [SNOMED 373175001] [Condition] [Clinical Finding] #> [V] [S] 763110 Neoplasm of breast regional lymph node staging category NX: Regional lymph nodes cannot be assessed [SNOMED 436191000124102] [Condition] [Clinical Finding] #> [V] [S] 763102 Neoplasm of breast regional lymph node staging category pN0(i+): Regional lymph node isolated tumor cell clusters detected by hematoxylin and eosin stain or immunohistochemical methods [SNOMED 436111000124107] [Condition] [Clinical Finding] #> [V] [S] 762894 Neoplasm of breast regional lymph node staging category N3 as per American Joint Committee on Cancer 7th edition [SNOMED 433431000124101] [Condition] [Clinical Finding] #> [V] [S] 4188642 pT2: Tumor more than 2 cm but not more than 5 cm in greatest dimension (breast) [SNOMED 373182002] [Condition] [Clinical Finding] #> [V] [S] 4160906 pN3c: Metastasis in ipsilateral supraclavicular lymph nodes (breast) [SNOMED 373166003] [Condition] [Clinical Finding] #> [V] [S] 762895 Neoplasm of breast regional lymph node staging category N0: No regional lymph node metastasis [SNOMED 433441000124106] [Condition] [Clinical Finding] #> [V] [S] 4187866 pN2: Metastasis in 4 to 9 axillary lymph nodes, or in clinically apparent internal mammary lymph nodes in the absence of axillary lymph node metastasis (breast) [SNOMED 373162001] [Condition] [Clinical Finding] #> [V] [S] 763100 Neoplasm of breast regional lymph node staging category pN3 as per American Joint Committee on Cancer 7th edition [SNOMED 436091000124103] [Condition] [Clinical Finding] #> [V] [S] 763103 Neoplasm of breast regional lymph node staging category pN0(i-): No regional lymph node metastasis histologically, negative immunohistochemically [SNOMED 436121000124104] [Condition] [Clinical Finding] #> [V] [S] 4160793 pN1: Metastasis in 1 to 3 axillary lymph nodes, and/or in internal mammary nodes with microscopic disease detected by sentinel lymph node dissection but not clinically apparent (breast) [SNOMED 373156006] [Condition] [Clinical Finding] #> [V] [S] 762892 Neoplasm of breast distant metastasis staging category M0: No clinical or radiographic evidence of distant metastasis [SNOMED 433411000124107] [Condition] [Clinical Finding] #> [V] [S] 4235556 pN0(mol+): No regional lymph node metastasis histologically, positive nonmorphologic (molecular) findings for isolated tumor cells (breast) [SNOMED 406091001] [Condition] [Clinical Finding] #> [V] [S] 4158686 pT1: Tumor 2 cm or less in greatest dimension (breast) [SNOMED 373172003] [Condition] [Clinical Finding] #> [V] [S] 4158690 pT4: Tumor of any size with direct extension to chest wall or skin (breast) [SNOMED 373185000] [Condition] [Clinical Finding] #> [V] [S] 4230027 pN0(i-): No regional lymph node metastasis histologically, negative morphologic findings for isolated tumor cells (breast) [SNOMED 406088001] [Condition] [Clinical Finding] #> [V] [S] 4160909 pTis: Lobular carcinoma in situ (breast) [SNOMED 373177009] [Condition] [Clinical Finding] #> [V] [S] 762896 Neoplasm of breast regional lymph node staging category N1: Metastasis to movable ipsilateral level I, II axillary lymph node(s) [SNOMED 433451000124108] [Condition] [Clinical Finding] #> [V] [S] 762893 Neoplasm of breast regional lymph node staging category N2 as per American Joint Committee on Cancer 7th edition [SNOMED 433421000124104] [Condition] [Clinical Finding] #> [V] [S] 4230150 pN0(mol-): No regional lymph node metastasis histologically, negative nonmorphologic (molecular) findings for isolated tumor cells (breast) [SNOMED 406090000] [Condition] [Clinical Finding] #> [V] [S] 4160794 pN1mi(i+): Micrometastasis detected only by IHC (breast) [SNOMED 373158007] [Condition] [Clinical Finding] #> [V] [S] 4158684 pN3a: Metastasis in 10 or more axillary lymph nodes (at least one tumor deposit greater than 2.0 mm), or metastasis to infraclavicular lymph nodes (breast) [SNOMED 373165004] [Condition] [Clinical Finding] #> [V] [S] 763111 Neoplasm of breast distant metastasis staging category M1: Distant detectable metastasis found by clinical and radiographic means and/or histologically proven larger than 0.2 mm [SNOMED 436201000124104] [Condition] [Clinical Finding] #> [V] [S] 763107 Neoplasm of breast primary tumor staging category Tis (LCIS): Lobar carcinoma in situ [SNOMED 436161000124105] [Condition] [Clinical Finding] #> [V] [S] 4158685 pN3b: Tumor of breast with metastasis as per AJCC 6th Edition definition (breast) [SNOMED 373167007] [Condition] [Clinical Finding] #> [V] [S] 762890 Neoplasm of breast primary tumor staging category T1c: Tumor >10 mm but <=20 mm in greatest dimension [SNOMED 433391000124107] [Condition] [Clinical Finding] #> [V] [S] 763112 Neoplasm of breast primary tumor staging category Tis (DCIS): Ductal carcinoma in situ [SNOMED 436211000124101] [Condition] [Clinical Finding]print_concept_siblings(conn = conn, concept_obj = concept_obj, level_of_separation_type = "min")#> [2021-05-26 16:07:28] Loading Cache... #> [2021-05-26 16:07:28] Cached SQL: SELECT * FROM omop_vocabulary.concept c WHERE c.concept_id IN (4187868) #> [2021-05-26 16:07:28] Cached resultset found... #> [2021-05-26 16:07:28] Target column: concept_hierarchy_id #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728... #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: DROP TABLE IF EXISTS patelm9.V20210526160728; #> [2021-05-26 16:07:28] Sending... #> [2021-05-26 16:07:28] Sending...complete #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:28] Writing patelm9.V20210526160728... #> [2021-05-26 16:07:28] Writing patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: SELECT a.*, b.ancestor_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160728 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.concept_hierarchy_id = b.descendant_concept_id #> [2021-05-26 16:07:28] Querying... #> [2021-05-26 16:07:28] Querying...complete #> [2021-05-26 16:07:28] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728... #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: DROP TABLE IF EXISTS patelm9.V20210526160728; #> [2021-05-26 16:07:28] Sending... #> [2021-05-26 16:07:28] Sending...complete #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] Target column: ancestor_concept_id #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728... #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: DROP TABLE IF EXISTS patelm9.V20210526160728; #> [2021-05-26 16:07:28] Sending... #> [2021-05-26 16:07:28] Sending...complete #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:28] Writing patelm9.V20210526160728... #> [2021-05-26 16:07:28] Writing patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: SELECT a.*, b.* FROM patelm9.V20210526160728 a LEFT JOIN omop_vocabulary.concept b ON a.ancestor_concept_id = b.concept_id WHERE b.invalid_reason IS NULL #> [2021-05-26 16:07:28] Querying... #> [2021-05-26 16:07:28] Querying...complete #> [2021-05-26 16:07:28] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728... #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: DROP TABLE IF EXISTS patelm9.V20210526160728; #> [2021-05-26 16:07:28] Sending... #> [2021-05-26 16:07:28] Sending...complete #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] Target column: parent_id #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728... #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: DROP TABLE IF EXISTS patelm9.V20210526160728; #> [2021-05-26 16:07:28] Sending... #> [2021-05-26 16:07:28] Sending...complete #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:28] Writing patelm9.V20210526160728... #> [2021-05-26 16:07:28] Writing patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: SELECT a.*, b.descendant_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160728 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.parent_id = b.ancestor_concept_id #> [2021-05-26 16:07:28] Querying... #> [2021-05-26 16:07:28] Querying...complete #> [2021-05-26 16:07:28] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728... #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: DROP TABLE IF EXISTS patelm9.V20210526160728; #> [2021-05-26 16:07:28] Sending... #> [2021-05-26 16:07:28] Sending...complete #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] Target column: descendant_concept_id #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728... #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: DROP TABLE IF EXISTS patelm9.V20210526160728; #> [2021-05-26 16:07:28] Sending... #> [2021-05-26 16:07:28] Sending...complete #> [2021-05-26 16:07:28] Dropping patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:28] Writing patelm9.V20210526160728... #> [2021-05-26 16:07:28] Writing patelm9.V20210526160728...complete #> [2021-05-26 16:07:28] ✓ Open connection #> [2021-05-26 16:07:28] ✓ JDBC connection #> [2021-05-26 16:07:28] SQL: SELECT a.*, b.* FROM patelm9.V20210526160728 a LEFT JOIN omop_vocabulary.concept b ON a.descendant_concept_id = b.concept_id WHERE b.invalid_reason IS NULL #> [2021-05-26 16:07:28] Querying... #> [2021-05-26 16:07:29] Querying...complete #> [2021-05-26 16:07:29] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160728... #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: DROP TABLE IF EXISTS patelm9.V20210526160728; #> [2021-05-26 16:07:29] Sending... #> [2021-05-26 16:07:29] Sending...complete #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160728...complete #> [V] [S] 4225738 pTis category [SNOMED 84921008] [Condition] [Clinical Finding] #> *[V] [S] 4187868 pTis: Ductal carcinoma in situ (breast) [SNOMED 373176000] [Condition] [Clinical Finding] #> [V] [S] 4306969 pTis: Carcinoma in situ, intraepithelial (appendix) [SNOMED 422901001] [Condition] [Clinical Finding] #> [V] [S] 4310299 pTis: Carcinoma in situ, invasion of lamina propria (appendix) [SNOMED 423055005] [Condition] [Clinical Finding] #> [V] [S] 4263661 pTis: Flat carcinoma in situ (urinary bladder, ureter, renal pelvis) [SNOMED 396668003] [Condition] [Clinical Finding] #> [V] [S] 4216800 pTis: Carcinoma in situ, intraepithelial (colon/rectum) [SNOMED 395705003] [Condition] [Clinical Finding] #> [V] [S] 4187868 pTis: Ductal carcinoma in situ (breast) [SNOMED 373176000] [Condition] [Clinical Finding] #> [V] [S] 4263128 pTis: Intratubular germ cell neoplasia (carcinoma in situ) (testis) [SNOMED 396727002] [Condition] [Clinical Finding] #> [V] [S] 4160909 pTis: Lobular carcinoma in situ (breast) [SNOMED 373177009] [Condition] [Clinical Finding] #> [V] [S] 4188645 pTis: Tumor invades muscularis mucosae (colon/rectum) [SNOMED 373199001] [Condition] [Clinical Finding] #> [V] [S] 4158688 pTis: Carcinoma in situ (breast) [SNOMED 373175001] [Condition] [Clinical Finding] #> [V] [S] 4262735 pTis: Melanoma in situ (melanoma of the skin) [SNOMED 396369000] [Condition] [Clinical Finding] #> [V] [S] 4188646 pTis: Carcinoma in situ, invasion of lamina propria [SNOMED 373201004] [Condition] [Clinical Finding] #> [V] [S] 4187869 pTis: Paget disease without invasive carcinoma (breast) [SNOMED 373178004] [Condition] [Clinical Finding] #> [V] [S] 4300154 Breast TNM finding [SNOMED 385417002] [Condition] [Clinical Finding] #> *[V] [S] 4187868 pTis: Ductal carcinoma in situ (breast) [SNOMED 373176000] [Condition] [Clinical Finding] #> [V] [S] 763114 Neoplasm of breast regional lymph node staging category pN0 as per American Joint Committee on Cancer 7th edition [SNOMED 436231000124107] [Condition] [Clinical Finding] #> [V] [S] 763113 Neoplasm of breast distant metastasis staging category cM0(i+) as per American Joint Committee on Cancer 7th edition [SNOMED 436221000124109] [Condition] [Clinical Finding] #> [V] [S] 4158682 pN0: No regional lymph node metastasis histologically (i.e., none greater than 0.2 mm), no additional examination for isolated tumor cells (breast) [SNOMED 373151001] [Condition] [Clinical Finding] #> [V] [S] 763109 Neoplasm of breast primary tumor staging category TX: Primary tumor cannot be assessed [SNOMED 436181000124100] [Condition] [Clinical Finding] #> [V] [S] 765662 Neoplasm of breast regional lymph node staging category pN0(mol+): Positive molecular findings, but no regional lymph node metastasis detected by histology or immunohistochemistry [SNOMED 436101000124109] [Condition] [Clinical Finding] #> [V] [S] 762891 Neoplasm of breast primary tumor staging category T4: Direct extension to chest wall and/or skin beyond dermis [SNOMED 433401000124109] [Condition] [Clinical Finding] #> [V] [S] 4158683 pN1mi: Micrometastasis (greater than 0.2 mm, none greater than 2.0 mm) (breast) [SNOMED 373157002] [Condition] [Clinical Finding] #> [V] [S] 763108 Neoplasm of breast primary tumor staging category Tis (Paget's) [SNOMED 436171000124103] [Condition] [Clinical Finding] #> [V] [S] 4187869 pTis: Paget disease without invasive carcinoma (breast) [SNOMED 373178004] [Condition] [Clinical Finding] #> [V] [S] 762889 Neoplasm of breast primary tumor staging category T1mi: Tumor <=1 mm in greatest dimension [SNOMED 433381000124109] [Condition] [Clinical Finding] #> [V] [S] 4188643 pT3: Tumor more than 5 cm in greatest dimension (breast) [SNOMED 373184001] [Condition] [Clinical Finding] #> [V] [S] 4230028 pN0(i+): No regional lymph node metastasis histologically, positive morphologic findings for isolated tumor cells, no cluster greater than 0.2 mm (breast) [SNOMED 406089009] [Condition] [Clinical Finding] #> [V] [S] 4187868 pTis: Ductal carcinoma in situ (breast) [SNOMED 373176000] [Condition] [Clinical Finding] #> [V] [S] 762888 Neoplasm of breast primary tumor staging category T0: No evidence of primary tumor [SNOMED 433371000124106] [Condition] [Clinical Finding] #> [V] [S] 4158688 pTis: Carcinoma in situ (breast) [SNOMED 373175001] [Condition] [Clinical Finding] #> [V] [S] 763110 Neoplasm of breast regional lymph node staging category NX: Regional lymph nodes cannot be assessed [SNOMED 436191000124102] [Condition] [Clinical Finding] #> [V] [S] 763102 Neoplasm of breast regional lymph node staging category pN0(i+): Regional lymph node isolated tumor cell clusters detected by hematoxylin and eosin stain or immunohistochemical methods [SNOMED 436111000124107] [Condition] [Clinical Finding] #> [V] [S] 762894 Neoplasm of breast regional lymph node staging category N3 as per American Joint Committee on Cancer 7th edition [SNOMED 433431000124101] [Condition] [Clinical Finding] #> [V] [S] 4188642 pT2: Tumor more than 2 cm but not more than 5 cm in greatest dimension (breast) [SNOMED 373182002] [Condition] [Clinical Finding] #> [V] [S] 4160906 pN3c: Metastasis in ipsilateral supraclavicular lymph nodes (breast) [SNOMED 373166003] [Condition] [Clinical Finding] #> [V] [S] 762895 Neoplasm of breast regional lymph node staging category N0: No regional lymph node metastasis [SNOMED 433441000124106] [Condition] [Clinical Finding] #> [V] [S] 4187866 pN2: Metastasis in 4 to 9 axillary lymph nodes, or in clinically apparent internal mammary lymph nodes in the absence of axillary lymph node metastasis (breast) [SNOMED 373162001] [Condition] [Clinical Finding] #> [V] [S] 763100 Neoplasm of breast regional lymph node staging category pN3 as per American Joint Committee on Cancer 7th edition [SNOMED 436091000124103] [Condition] [Clinical Finding] #> [V] [S] 763103 Neoplasm of breast regional lymph node staging category pN0(i-): No regional lymph node metastasis histologically, negative immunohistochemically [SNOMED 436121000124104] [Condition] [Clinical Finding] #> [V] [S] 4160793 pN1: Metastasis in 1 to 3 axillary lymph nodes, and/or in internal mammary nodes with microscopic disease detected by sentinel lymph node dissection but not clinically apparent (breast) [SNOMED 373156006] [Condition] [Clinical Finding] #> [V] [S] 762892 Neoplasm of breast distant metastasis staging category M0: No clinical or radiographic evidence of distant metastasis [SNOMED 433411000124107] [Condition] [Clinical Finding] #> [V] [S] 4235556 pN0(mol+): No regional lymph node metastasis histologically, positive nonmorphologic (molecular) findings for isolated tumor cells (breast) [SNOMED 406091001] [Condition] [Clinical Finding] #> [V] [S] 4158686 pT1: Tumor 2 cm or less in greatest dimension (breast) [SNOMED 373172003] [Condition] [Clinical Finding] #> [V] [S] 4158690 pT4: Tumor of any size with direct extension to chest wall or skin (breast) [SNOMED 373185000] [Condition] [Clinical Finding] #> [V] [S] 4230027 pN0(i-): No regional lymph node metastasis histologically, negative morphologic findings for isolated tumor cells (breast) [SNOMED 406088001] [Condition] [Clinical Finding] #> [V] [S] 4160909 pTis: Lobular carcinoma in situ (breast) [SNOMED 373177009] [Condition] [Clinical Finding] #> [V] [S] 762896 Neoplasm of breast regional lymph node staging category N1: Metastasis to movable ipsilateral level I, II axillary lymph node(s) [SNOMED 433451000124108] [Condition] [Clinical Finding] #> [V] [S] 762893 Neoplasm of breast regional lymph node staging category N2 as per American Joint Committee on Cancer 7th edition [SNOMED 433421000124104] [Condition] [Clinical Finding] #> [V] [S] 4230150 pN0(mol-): No regional lymph node metastasis histologically, negative nonmorphologic (molecular) findings for isolated tumor cells (breast) [SNOMED 406090000] [Condition] [Clinical Finding] #> [V] [S] 4160794 pN1mi(i+): Micrometastasis detected only by IHC (breast) [SNOMED 373158007] [Condition] [Clinical Finding] #> [V] [S] 4158684 pN3a: Metastasis in 10 or more axillary lymph nodes (at least one tumor deposit greater than 2.0 mm), or metastasis to infraclavicular lymph nodes (breast) [SNOMED 373165004] [Condition] [Clinical Finding] #> [V] [S] 763111 Neoplasm of breast distant metastasis staging category M1: Distant detectable metastasis found by clinical and radiographic means and/or histologically proven larger than 0.2 mm [SNOMED 436201000124104] [Condition] [Clinical Finding] #> [V] [S] 763107 Neoplasm of breast primary tumor staging category Tis (LCIS): Lobar carcinoma in situ [SNOMED 436161000124105] [Condition] [Clinical Finding] #> [V] [S] 4158685 pN3b: Tumor of breast with metastasis as per AJCC 6th Edition definition (breast) [SNOMED 373167007] [Condition] [Clinical Finding] #> [V] [S] 762890 Neoplasm of breast primary tumor staging category T1c: Tumor >10 mm but <=20 mm in greatest dimension [SNOMED 433391000124107] [Condition] [Clinical Finding] #> [V] [S] 763112 Neoplasm of breast primary tumor staging category Tis (DCIS): Ductal carcinoma in situ [SNOMED 436211000124101] [Condition] [Clinical Finding]#>#> ── Is Concept Id Valid Integer? ────────────────────────────────────────────────#> ✓ Concept Id is a valid integer#>#> ── Lookup Concept Id in Concept Table ──────────────────────────────────────────#> ✓ Concept Id `319835` found in Concept Table#>#> ── Lookup Synonyms ─────────────────────────────────────────────────────────────#>#> ── Lookup 'Maps to' Concept Names ──────────────────────────────────────────────concept_obj#> An object of class "concept" #> Slot "concept_id": #> [1] 319835 #> #> Slot "concept_name": #> [1] "Congestive heart failure" #> #> Slot "concept_synonym_names": #> [1] "CCF - Congestive cardiac failure|CHF - Congestive heart failure|Congestive cardiac failure|Congestive heart disease|Congestive heart failure (disorder)" #> #> Slot "maps_to_concept_names": #> [1] "Congestive heart failure" #> #> Slot "domain_id": #> [1] "Condition" #> #> Slot "vocabulary_id": #> [1] "SNOMED" #> #> Slot "concept_class_id": #> [1] "Clinical Finding" #> #> Slot "standard_concept": #> [1] "S" #> #> Slot "concept_code": #> [1] "42343007" #> #> Slot "valid_start_date": #> [1] "2002-01-31" #> #> Slot "valid_end_date": #> [1] "2099-12-31" #> #> Slot "invalid_reason": #> [1] NA #>print_concept_siblings(conn = conn, concept_obj = concept_obj)#> [2021-05-26 16:07:29] Loading Cache... #> [2021-05-26 16:07:29] Cached SQL: SELECT * FROM omop_vocabulary.concept c WHERE c.concept_id IN (319835) #> [2021-05-26 16:07:29] Cached resultset found... #> [2021-05-26 16:07:29] Target column: concept_hierarchy_id #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729... #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: DROP TABLE IF EXISTS patelm9.V20210526160729; #> [2021-05-26 16:07:29] Sending... #> [2021-05-26 16:07:29] Sending...complete #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:29] Writing patelm9.V20210526160729... #> [2021-05-26 16:07:29] Writing patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: SELECT a.*, b.ancestor_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160729 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.concept_hierarchy_id = b.descendant_concept_id #> [2021-05-26 16:07:29] Querying... #> [2021-05-26 16:07:29] Querying...complete #> [2021-05-26 16:07:29] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729... #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: DROP TABLE IF EXISTS patelm9.V20210526160729; #> [2021-05-26 16:07:29] Sending... #> [2021-05-26 16:07:29] Sending...complete #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] Target column: ancestor_concept_id #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729... #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: DROP TABLE IF EXISTS patelm9.V20210526160729; #> [2021-05-26 16:07:29] Sending... #> [2021-05-26 16:07:29] Sending...complete #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:29] Writing patelm9.V20210526160729... #> [2021-05-26 16:07:29] Writing patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: SELECT a.*, b.* FROM patelm9.V20210526160729 a LEFT JOIN omop_vocabulary.concept b ON a.ancestor_concept_id = b.concept_id WHERE b.invalid_reason IS NULL #> [2021-05-26 16:07:29] Querying... #> [2021-05-26 16:07:29] Querying...complete #> [2021-05-26 16:07:29] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729... #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: DROP TABLE IF EXISTS patelm9.V20210526160729; #> [2021-05-26 16:07:29] Sending... #> [2021-05-26 16:07:29] Sending...complete #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] Target column: parent_id #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729... #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: DROP TABLE IF EXISTS patelm9.V20210526160729; #> [2021-05-26 16:07:29] Sending... #> [2021-05-26 16:07:29] Sending...complete #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:29] Writing patelm9.V20210526160729... #> [2021-05-26 16:07:29] Writing patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: SELECT a.*, b.descendant_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160729 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.parent_id = b.ancestor_concept_id #> [2021-05-26 16:07:29] Querying... #> [2021-05-26 16:07:29] Querying...complete #> [2021-05-26 16:07:29] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729... #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: DROP TABLE IF EXISTS patelm9.V20210526160729; #> [2021-05-26 16:07:29] Sending... #> [2021-05-26 16:07:29] Sending...complete #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] Target column: descendant_concept_id #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729... #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: DROP TABLE IF EXISTS patelm9.V20210526160729; #> [2021-05-26 16:07:29] Sending... #> [2021-05-26 16:07:29] Sending...complete #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:29] Writing patelm9.V20210526160729... #> [2021-05-26 16:07:29] Writing patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: SELECT a.*, b.* FROM patelm9.V20210526160729 a LEFT JOIN omop_vocabulary.concept b ON a.descendant_concept_id = b.concept_id WHERE b.invalid_reason IS NULL #> [2021-05-26 16:07:29] Querying... #> [2021-05-26 16:07:29] Querying...complete #> [2021-05-26 16:07:29] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729... #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: DROP TABLE IF EXISTS patelm9.V20210526160729; #> [2021-05-26 16:07:29] Sending... #> [2021-05-26 16:07:29] Sending...complete #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729...complete #> [V] [S] 316139 Heart failure [SNOMED 84114007] [Condition] [Clinical Finding] #> *[V] [S] 319835 Congestive heart failure [SNOMED 42343007] [Condition] [Clinical Finding] #> [V] [S] 4111554 Decompensated cardiac failure [SNOMED 195111005] [Condition] [Clinical Finding] #> [V] [S] 4259490 Cardiorespiratory failure [SNOMED 410431009] [Condition] [Clinical Finding] #> [V] [S] 4071869 Congenital cardiac failure [SNOMED 206586007] [Condition] [Clinical Finding] #> [V] [S] 319835 Congestive heart failure [SNOMED 42343007] [Condition] [Clinical Finding] #> [V] [S] 37311948 Heart failure with mid range ejection fraction [SNOMED 788950000] [Condition] [Clinical Finding] #> [V] [S] 4205558 Cardiac failure after obstetrical surgery AND/OR other procedure including delivery [SNOMED 55565007] [Condition] [Clinical Finding] #> [V] [S] 443587 Diastolic heart failure [SNOMED 418304008] [Condition] [Clinical Finding] #> [V] [S] 4273632 Right ventricular failure [SNOMED 367363000] [Condition] [Clinical Finding] #> [V] [S] 442310 Acute heart failure [SNOMED 56675007] [Condition] [Clinical Finding] #> [V] [S] 4004279 High output heart failure [SNOMED 10091002] [Condition] [Clinical Finding] #> [V] [S] 444031 Chronic heart failure [SNOMED 48447003] [Condition] [Clinical Finding] #> [V] [S] 45766164 Heart failure with reduced ejection fraction [SNOMED 703272007] [Condition] [Clinical Finding] #> [V] [S] 43020657 Heart failure due to end stage congenital heart disease [SNOMED 471880001] [Condition] [Clinical Finding] #> [V] [S] 42598803 Spontaneous cardiomyopathy [SNOMED Veterinary 339881000009101] [Condition] [Clinical Finding] #> [V] [S] 4124705 Heart failure as a complication of care [SNOMED 233924009] [Condition] [Clinical Finding] #> [V] [S] 43530961 Induced termination of pregnancy complicated by cardiac failure [SNOMED 609507007] [Condition] [Clinical Finding] #> [V] [S] 40486933 Heart failure with normal ejection fraction [SNOMED 446221000] [Condition] [Clinical Finding] #> [V] [S] 4108244 Compensated cardiac failure [SNOMED 195112003] [Condition] [Clinical Finding] #> [V] [S] 4233224 Cardiac insufficiency during AND/OR resulting from a procedure [SNOMED 89819002] [Condition] [Clinical Finding] #> [V] [S] 4199500 Refractory heart failure [SNOMED 314206003] [Condition] [Clinical Finding] #> [V] [S] 43021735 Fetal heart failure [SNOMED 462172006] [Condition] [Clinical Finding] #> [V] [S] 439846 Left heart failure [SNOMED 85232009] [Condition] [Clinical Finding] #> [V] [S] 3184320 Heart failure exacerbated by Sotalol [Nebraska Lexicon 12610001000004104] [Condition] [Clinical Finding] #> [V] [S] 443580 Systolic heart failure [SNOMED 417996009] [Condition] [Clinical Finding] #> [V] [S] 40482857 Cardiorenal syndrome [SNOMED 445236007] [Condition] [Clinical Finding] #> [V] [S] 444101 Hypertensive heart failure [SNOMED 46113002] [Condition] [Clinical Finding] #> [V] [S] 4172864 Neonatal cardiac failure [SNOMED 276514007] [Condition] [Clinical Finding] #> [V] [S] 4103448 Low output heart failure [SNOMED 25544003] [Condition] [Clinical Finding] #> [V] [S] 4166245 Disorder of cardiac ventricle [SNOMED 415991003] [Condition] [Clinical Finding] #> *[V] [S] 319835 Congestive heart failure [SNOMED 42343007] [Condition] [Clinical Finding] #> [V] [S] 4108680 Thrombosis of atrium, auricular appendage, and ventricle due to and following acute myocardial infarction [SNOMED 194868001] [Condition] [Clinical Finding] #> [V] [S] 43020893 Fetal ventricular dysfunction [SNOMED 472773007] [Condition] [Clinical Finding] #> [V] [S] 314059 Right bundle branch block [SNOMED 59118001] [Condition] [Clinical Finding] #> [V] [S] 4305862 Fascicular ventricular tachycardia [SNOMED 418872003] [Condition] [Clinical Finding] #> [V] [S] 42536632 Acquired abnormality of cardiac ventricle [SNOMED 735570002] [Condition] [Clinical Finding] #> [V] [S] 42537639 Congenital anomaly of atrioventricular septum [SNOMED 737156006] [Condition] [Clinical Finding] #> [V] [S] 319835 Congestive heart failure [SNOMED 42343007] [Condition] [Clinical Finding] #> [V] [S] 316998 Left bundle branch block [SNOMED 63467002] [Condition] [Clinical Finding] #> [V] [S] 40482921 Common atrioventricular orifice in double inlet ventricle [SNOMED 445294008] [Condition] [Clinical Finding] #> [V] [S] 42599765 Segmental hypokinesis of ventricular septum [SNOMED Veterinary 359061000009104] [Condition] [Clinical Finding] #> [V] [S] 42536643 Disorder of cardiac ventricle following procedure [SNOMED 735582006] [Condition] [Clinical Finding] #> [V] [S] 4145489 Ventricular hypertrophy [SNOMED 266249003] [Condition] [Clinical Finding] #> [V] [S] 4165905 Disorder of right cardiac ventricle [SNOMED 415992005] [Condition] [Clinical Finding] #> [V] [S] 4167693 Disorder of left cardiac ventricle [SNOMED 415993000] [Condition] [Clinical Finding] #> [V] [S] 40487550 Atrioventricular septal defect associated with tetralogy of Fallot [SNOMED 448007000] [Condition] [Clinical Finding] #> [V] [S] 319039 Acute posterior myocardial infarction [SNOMED 233838001] [Condition] [Clinical Finding] #> [V] [S] 4265190 Cardiac ventricular dilatation [SNOMED 6210001] [Condition] [Clinical Finding] #> [V] [S] 4236169 Ventricular aneurysm [SNOMED 90539001] [Condition] [Clinical Finding] #> [V] [S] 4178129 Acute anteroapical myocardial infarction [SNOMED 52035003] [Condition] [Clinical Finding] #> [V] [S] 4147223 Rupture of ventricle due to acute myocardial infarction [SNOMED 30277009] [Condition] [Clinical Finding] #> [V] [S] 40487092 Thin ventricular septum [SNOMED 447923000] [Condition] [Clinical Finding] #> [V] [S] 4068745 Anomalous ventricular bands [SNOMED 204409004] [Condition] [Clinical Finding] #> [V] [S] 36676316 Congenital abnormality of cardiac ventricle [SNOMED 773139006] [Condition] [Clinical Finding] #> [V] [S] 40457757 Ventricular septal abnormality [SNOMED 253549006] [Condition] [Clinical Finding]print_concept_siblings(conn = conn, concept_obj = concept_obj, level_of_separation_type = "min")#> [2021-05-26 16:07:29] Loading Cache... #> [2021-05-26 16:07:29] Cached SQL: SELECT * FROM omop_vocabulary.concept c WHERE c.concept_id IN (319835) #> [2021-05-26 16:07:29] Cached resultset found... #> [2021-05-26 16:07:29] Target column: concept_hierarchy_id #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729... #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: DROP TABLE IF EXISTS patelm9.V20210526160729; #> [2021-05-26 16:07:29] Sending... #> [2021-05-26 16:07:29] Sending...complete #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:29] Writing patelm9.V20210526160729... #> [2021-05-26 16:07:29] Writing patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: SELECT a.*, b.ancestor_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160729 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.concept_hierarchy_id = b.descendant_concept_id #> [2021-05-26 16:07:29] Querying... #> [2021-05-26 16:07:29] Querying...complete #> [2021-05-26 16:07:29] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729... #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: DROP TABLE IF EXISTS patelm9.V20210526160729; #> [2021-05-26 16:07:29] Sending... #> [2021-05-26 16:07:29] Sending...complete #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] Target column: ancestor_concept_id #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729... #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: DROP TABLE IF EXISTS patelm9.V20210526160729; #> [2021-05-26 16:07:29] Sending... #> [2021-05-26 16:07:29] Sending...complete #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:29] Writing patelm9.V20210526160729... #> [2021-05-26 16:07:29] Writing patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: SELECT a.*, b.* FROM patelm9.V20210526160729 a LEFT JOIN omop_vocabulary.concept b ON a.ancestor_concept_id = b.concept_id WHERE b.invalid_reason IS NULL #> [2021-05-26 16:07:29] Querying... #> [2021-05-26 16:07:29] Querying...complete #> [2021-05-26 16:07:29] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729... #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: DROP TABLE IF EXISTS patelm9.V20210526160729; #> [2021-05-26 16:07:29] Sending... #> [2021-05-26 16:07:29] Sending...complete #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] Target column: parent_id #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729... #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: DROP TABLE IF EXISTS patelm9.V20210526160729; #> [2021-05-26 16:07:29] Sending... #> [2021-05-26 16:07:29] Sending...complete #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:29] Writing patelm9.V20210526160729... #> [2021-05-26 16:07:29] Writing patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: SELECT a.*, b.descendant_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160729 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.parent_id = b.ancestor_concept_id #> [2021-05-26 16:07:29] Querying... #> [2021-05-26 16:07:29] Querying...complete #> [2021-05-26 16:07:29] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729... #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: DROP TABLE IF EXISTS patelm9.V20210526160729; #> [2021-05-26 16:07:29] Sending... #> [2021-05-26 16:07:29] Sending...complete #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] Target column: descendant_concept_id #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729... #> [2021-05-26 16:07:29] ✓ Open connection #> [2021-05-26 16:07:29] ✓ JDBC connection #> [2021-05-26 16:07:29] SQL: DROP TABLE IF EXISTS patelm9.V20210526160729; #> [2021-05-26 16:07:29] Sending... #> [2021-05-26 16:07:29] Sending...complete #> [2021-05-26 16:07:29] Dropping patelm9.V20210526160729...complete #> [2021-05-26 16:07:29] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:29] Writing patelm9.V20210526160729... #> [2021-05-26 16:07:30] Writing patelm9.V20210526160729...complete #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: SELECT a.*, b.* FROM patelm9.V20210526160729 a LEFT JOIN omop_vocabulary.concept b ON a.descendant_concept_id = b.concept_id WHERE b.invalid_reason IS NULL #> [2021-05-26 16:07:30] Querying... #> [2021-05-26 16:07:30] Querying...complete #> [2021-05-26 16:07:30] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160729... #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: DROP TABLE IF EXISTS patelm9.V20210526160729; #> [2021-05-26 16:07:30] Sending... #> [2021-05-26 16:07:30] Sending...complete #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160729...complete #> [V] [C] 500002601 OMOP Congestive Heart Failure 1 [Cohort 500002601] [Condition] [Cohort] #> *[V] [S] 319835 Congestive heart failure [SNOMED 42343007] [Condition] [Clinical Finding] #> [V] [S] 141038 Diastolic dysfunction [SNOMED 3545003] [Condition] [Clinical Finding] #> [V] [S] 443587 Diastolic heart failure [SNOMED 418304008] [Condition] [Clinical Finding] #> [V] [S] 40479192 Chronic systolic heart failure [SNOMED 441481004] [Condition] [Clinical Finding] #> [V] [S] 319835 Congestive heart failure [SNOMED 42343007] [Condition] [Clinical Finding] #> [V] [S] 444031 Chronic heart failure [SNOMED 48447003] [Condition] [Clinical Finding] #> [V] [S] 442310 Acute heart failure [SNOMED 56675007] [Condition] [Clinical Finding] #> [V] [S] 139036 Systolic dysfunction [SNOMED 371037005] [Condition] [Clinical Finding] #> [V] [S] 316139 Heart failure [SNOMED 84114007] [Condition] [Clinical Finding] #> [V] [S] 443580 Systolic heart failure [SNOMED 417996009] [Condition] [Clinical Finding] #> [V] [S] 439846 Left heart failure [SNOMED 85232009] [Condition] [Clinical Finding] #> [V] [S] 316139 Heart failure [SNOMED 84114007] [Condition] [Clinical Finding] #> *[V] [S] 319835 Congestive heart failure [SNOMED 42343007] [Condition] [Clinical Finding] #> [V] [S] 4111554 Decompensated cardiac failure [SNOMED 195111005] [Condition] [Clinical Finding] #> [V] [S] 4259490 Cardiorespiratory failure [SNOMED 410431009] [Condition] [Clinical Finding] #> [V] [S] 4071869 Congenital cardiac failure [SNOMED 206586007] [Condition] [Clinical Finding] #> [V] [S] 319835 Congestive heart failure [SNOMED 42343007] [Condition] [Clinical Finding] #> [V] [S] 37311948 Heart failure with mid range ejection fraction [SNOMED 788950000] [Condition] [Clinical Finding] #> [V] [S] 4205558 Cardiac failure after obstetrical surgery AND/OR other procedure including delivery [SNOMED 55565007] [Condition] [Clinical Finding] #> [V] [S] 443587 Diastolic heart failure [SNOMED 418304008] [Condition] [Clinical Finding] #> [V] [S] 4273632 Right ventricular failure [SNOMED 367363000] [Condition] [Clinical Finding] #> [V] [S] 442310 Acute heart failure [SNOMED 56675007] [Condition] [Clinical Finding] #> [V] [S] 4004279 High output heart failure [SNOMED 10091002] [Condition] [Clinical Finding] #> [V] [S] 444031 Chronic heart failure [SNOMED 48447003] [Condition] [Clinical Finding] #> [V] [S] 45766164 Heart failure with reduced ejection fraction [SNOMED 703272007] [Condition] [Clinical Finding] #> [V] [S] 43020657 Heart failure due to end stage congenital heart disease [SNOMED 471880001] [Condition] [Clinical Finding] #> [V] [S] 42598803 Spontaneous cardiomyopathy [SNOMED Veterinary 339881000009101] [Condition] [Clinical Finding] #> [V] [S] 4124705 Heart failure as a complication of care [SNOMED 233924009] [Condition] [Clinical Finding] #> [V] [S] 43530961 Induced termination of pregnancy complicated by cardiac failure [SNOMED 609507007] [Condition] [Clinical Finding] #> [V] [S] 40486933 Heart failure with normal ejection fraction [SNOMED 446221000] [Condition] [Clinical Finding] #> [V] [S] 4108244 Compensated cardiac failure [SNOMED 195112003] [Condition] [Clinical Finding] #> [V] [S] 4233224 Cardiac insufficiency during AND/OR resulting from a procedure [SNOMED 89819002] [Condition] [Clinical Finding] #> [V] [S] 4199500 Refractory heart failure [SNOMED 314206003] [Condition] [Clinical Finding] #> [V] [S] 43021735 Fetal heart failure [SNOMED 462172006] [Condition] [Clinical Finding] #> [V] [S] 439846 Left heart failure [SNOMED 85232009] [Condition] [Clinical Finding] #> [V] [S] 3184320 Heart failure exacerbated by Sotalol [Nebraska Lexicon 12610001000004104] [Condition] [Clinical Finding] #> [V] [S] 443580 Systolic heart failure [SNOMED 417996009] [Condition] [Clinical Finding] #> [V] [S] 40482857 Cardiorenal syndrome [SNOMED 445236007] [Condition] [Clinical Finding] #> [V] [S] 444101 Hypertensive heart failure [SNOMED 46113002] [Condition] [Clinical Finding] #> [V] [S] 4172864 Neonatal cardiac failure [SNOMED 276514007] [Condition] [Clinical Finding] #> [V] [S] 4103448 Low output heart failure [SNOMED 25544003] [Condition] [Clinical Finding] #> [V] [S] 4166245 Disorder of cardiac ventricle [SNOMED 415991003] [Condition] [Clinical Finding] #> *[V] [S] 319835 Congestive heart failure [SNOMED 42343007] [Condition] [Clinical Finding] #> [V] [S] 4108680 Thrombosis of atrium, auricular appendage, and ventricle due to and following acute myocardial infarction [SNOMED 194868001] [Condition] [Clinical Finding] #> [V] [S] 43020893 Fetal ventricular dysfunction [SNOMED 472773007] [Condition] [Clinical Finding] #> [V] [S] 314059 Right bundle branch block [SNOMED 59118001] [Condition] [Clinical Finding] #> [V] [S] 4305862 Fascicular ventricular tachycardia [SNOMED 418872003] [Condition] [Clinical Finding] #> [V] [S] 42536632 Acquired abnormality of cardiac ventricle [SNOMED 735570002] [Condition] [Clinical Finding] #> [V] [S] 42537639 Congenital anomaly of atrioventricular septum [SNOMED 737156006] [Condition] [Clinical Finding] #> [V] [S] 319835 Congestive heart failure [SNOMED 42343007] [Condition] [Clinical Finding] #> [V] [S] 316998 Left bundle branch block [SNOMED 63467002] [Condition] [Clinical Finding] #> [V] [S] 40482921 Common atrioventricular orifice in double inlet ventricle [SNOMED 445294008] [Condition] [Clinical Finding] #> [V] [S] 42599765 Segmental hypokinesis of ventricular septum [SNOMED Veterinary 359061000009104] [Condition] [Clinical Finding] #> [V] [S] 42536643 Disorder of cardiac ventricle following procedure [SNOMED 735582006] [Condition] [Clinical Finding] #> [V] [S] 4145489 Ventricular hypertrophy [SNOMED 266249003] [Condition] [Clinical Finding] #> [V] [S] 4165905 Disorder of right cardiac ventricle [SNOMED 415992005] [Condition] [Clinical Finding] #> [V] [S] 4167693 Disorder of left cardiac ventricle [SNOMED 415993000] [Condition] [Clinical Finding] #> [V] [S] 40487550 Atrioventricular septal defect associated with tetralogy of Fallot [SNOMED 448007000] [Condition] [Clinical Finding] #> [V] [S] 319039 Acute posterior myocardial infarction [SNOMED 233838001] [Condition] [Clinical Finding] #> [V] [S] 4265190 Cardiac ventricular dilatation [SNOMED 6210001] [Condition] [Clinical Finding] #> [V] [S] 4236169 Ventricular aneurysm [SNOMED 90539001] [Condition] [Clinical Finding] #> [V] [S] 4178129 Acute anteroapical myocardial infarction [SNOMED 52035003] [Condition] [Clinical Finding] #> [V] [S] 4147223 Rupture of ventricle due to acute myocardial infarction [SNOMED 30277009] [Condition] [Clinical Finding] #> [V] [S] 40487092 Thin ventricular septum [SNOMED 447923000] [Condition] [Clinical Finding] #> [V] [S] 4068745 Anomalous ventricular bands [SNOMED 204409004] [Condition] [Clinical Finding] #> [V] [S] 36676316 Congenital abnormality of cardiac ventricle [SNOMED 773139006] [Condition] [Clinical Finding] #> [V] [S] 40457757 Ventricular septal abnormality [SNOMED 253549006] [Condition] [Clinical Finding]#>#> ── Is Concept Id Valid Integer? ────────────────────────────────────────────────#> ✓ Concept Id is a valid integer#>#> ── Lookup Concept Id in Concept Table ──────────────────────────────────────────#> ✓ Concept Id `4298431` found in Concept Table#>#> ── Lookup Synonyms ─────────────────────────────────────────────────────────────#>#> ── Lookup 'Maps to' Concept Names ──────────────────────────────────────────────concept_obj#> An object of class "concept" #> Slot "concept_id": #> [1] 4298431 #> #> Slot "concept_name": #> [1] "White blood cell count" #> #> Slot "concept_synonym_names": #> [1] "WBC - White blood cell count|WBC count|WCC - White blood cell count|White blood cell count (procedure)|White blood cell count - observation" #> #> Slot "maps_to_concept_names": #> [1] "White blood cell count" #> #> Slot "domain_id": #> [1] "Measurement" #> #> Slot "vocabulary_id": #> [1] "SNOMED" #> #> Slot "concept_class_id": #> [1] "Procedure" #> #> Slot "standard_concept": #> [1] "S" #> #> Slot "concept_code": #> [1] "767002" #> #> Slot "valid_start_date": #> [1] "2002-01-31" #> #> Slot "valid_end_date": #> [1] "2099-12-31" #> #> Slot "invalid_reason": #> [1] NA #>print_concept_siblings(conn = conn, concept_obj = concept_obj)#> [2021-05-26 16:07:30] Loading Cache... #> [2021-05-26 16:07:30] Cached SQL: SELECT * FROM omop_vocabulary.concept c WHERE c.concept_id IN (4298431) #> [2021-05-26 16:07:30] Cached resultset found... #> [2021-05-26 16:07:30] Target column: concept_hierarchy_id #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730... #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: DROP TABLE IF EXISTS patelm9.V20210526160730; #> [2021-05-26 16:07:30] Sending... #> [2021-05-26 16:07:30] Sending...complete #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730...complete #> [2021-05-26 16:07:30] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:30] Writing patelm9.V20210526160730... #> [2021-05-26 16:07:30] Writing patelm9.V20210526160730...complete #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: SELECT a.*, b.ancestor_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160730 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.concept_hierarchy_id = b.descendant_concept_id #> [2021-05-26 16:07:30] Querying... #> [2021-05-26 16:07:30] Querying...complete #> [2021-05-26 16:07:30] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730... #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: DROP TABLE IF EXISTS patelm9.V20210526160730; #> [2021-05-26 16:07:30] Sending... #> [2021-05-26 16:07:30] Sending...complete #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730...complete #> [2021-05-26 16:07:30] Target column: ancestor_concept_id #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730... #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: DROP TABLE IF EXISTS patelm9.V20210526160730; #> [2021-05-26 16:07:30] Sending... #> [2021-05-26 16:07:30] Sending...complete #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730...complete #> [2021-05-26 16:07:30] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:30] Writing patelm9.V20210526160730... #> [2021-05-26 16:07:30] Writing patelm9.V20210526160730...complete #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: SELECT a.*, b.* FROM patelm9.V20210526160730 a LEFT JOIN omop_vocabulary.concept b ON a.ancestor_concept_id = b.concept_id WHERE b.invalid_reason IS NULL #> [2021-05-26 16:07:30] Querying... #> [2021-05-26 16:07:30] Querying...complete #> [2021-05-26 16:07:30] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730... #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: DROP TABLE IF EXISTS patelm9.V20210526160730; #> [2021-05-26 16:07:30] Sending... #> [2021-05-26 16:07:30] Sending...complete #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730...complete #> [2021-05-26 16:07:30] Target column: parent_id #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730... #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: DROP TABLE IF EXISTS patelm9.V20210526160730; #> [2021-05-26 16:07:30] Sending... #> [2021-05-26 16:07:30] Sending...complete #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730...complete #> [2021-05-26 16:07:30] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:30] Writing patelm9.V20210526160730... #> [2021-05-26 16:07:30] Writing patelm9.V20210526160730...complete #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: SELECT a.*, b.descendant_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160730 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.parent_id = b.ancestor_concept_id #> [2021-05-26 16:07:30] Querying... #> [2021-05-26 16:07:30] Querying...complete #> [2021-05-26 16:07:30] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730... #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: DROP TABLE IF EXISTS patelm9.V20210526160730; #> [2021-05-26 16:07:30] Sending... #> [2021-05-26 16:07:30] Sending...complete #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730...complete #> [2021-05-26 16:07:30] Target column: descendant_concept_id #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730... #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: DROP TABLE IF EXISTS patelm9.V20210526160730; #> [2021-05-26 16:07:30] Sending... #> [2021-05-26 16:07:30] Sending...complete #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730...complete #> [2021-05-26 16:07:30] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:30] Writing patelm9.V20210526160730... #> [2021-05-26 16:07:30] Writing patelm9.V20210526160730...complete #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: SELECT a.*, b.* FROM patelm9.V20210526160730 a LEFT JOIN omop_vocabulary.concept b ON a.descendant_concept_id = b.concept_id WHERE b.invalid_reason IS NULL #> [2021-05-26 16:07:30] Querying... #> [2021-05-26 16:07:30] Querying...complete #> [2021-05-26 16:07:30] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730... #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: DROP TABLE IF EXISTS patelm9.V20210526160730; #> [2021-05-26 16:07:30] Sending... #> [2021-05-26 16:07:30] Sending...complete #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730...complete #> [V] [S] 4339397 Blood cell count [SNOMED 88308000] [Measurement] [Procedure] #> *[V] [S] 4298431 White blood cell count [SNOMED 767002] [Measurement] [Procedure] #> [V] [S] 4035541 Blood cell count, automated [SNOMED 117356000] [Measurement] [Procedure] #> [V] [S] 4035540 Blood cell count, manual [SNOMED 117355001] [Measurement] [Procedure] #> [V] [S] 4030871 Red blood cell count [SNOMED 14089001] [Measurement] [Procedure] #> [V] [S] 4270019 Percentage reticulated platelet count [SNOMED 401296001] [Measurement] [Procedure] #> [V] [S] 4254487 Large unstained cell count [SNOMED 409087007] [Measurement] [Procedure] #> [V] [S] 4298431 White blood cell count [SNOMED 767002] [Measurement] [Procedure] #> [V] [S] 4132152 Complete blood count [SNOMED 26604007] [Measurement] [Procedure] #> [V] [S] 44806871 Immature platelet fraction count [SNOMED 803431000000106] [Measurement] [Procedure] #> [V] [S] 4267147 Platelet count [SNOMED 61928009] [Measurement] [Procedure] #> [V] [S] 2212651 Blood count; manual cell count (erythrocyte, leukocyte, or platelet) each [CPT4 85032] [Measurement] [CPT4] #> [V] [S] 4133662 Peritoneal dialysis fluid cell count [SNOMED 412897006] [Measurement] [Procedure] #> [V] [S] 4016230 Blast count, blood [SNOMED 104102000] [Measurement] [Procedure]print_concept_siblings(conn = conn, concept_obj = concept_obj, level_of_separation_type = "min")#> [2021-05-26 16:07:30] Loading Cache... #> [2021-05-26 16:07:30] Cached SQL: SELECT * FROM omop_vocabulary.concept c WHERE c.concept_id IN (4298431) #> [2021-05-26 16:07:30] Cached resultset found... #> [2021-05-26 16:07:30] Target column: concept_hierarchy_id #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730... #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: DROP TABLE IF EXISTS patelm9.V20210526160730; #> [2021-05-26 16:07:30] Sending... #> [2021-05-26 16:07:30] Sending...complete #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730...complete #> [2021-05-26 16:07:30] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:30] Writing patelm9.V20210526160730... #> [2021-05-26 16:07:30] Writing patelm9.V20210526160730...complete #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: SELECT a.*, b.ancestor_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160730 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.concept_hierarchy_id = b.descendant_concept_id #> [2021-05-26 16:07:30] Querying... #> [2021-05-26 16:07:30] Querying...complete #> [2021-05-26 16:07:30] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730... #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: DROP TABLE IF EXISTS patelm9.V20210526160730; #> [2021-05-26 16:07:30] Sending... #> [2021-05-26 16:07:30] Sending...complete #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730...complete #> [2021-05-26 16:07:30] Target column: ancestor_concept_id #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730... #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: DROP TABLE IF EXISTS patelm9.V20210526160730; #> [2021-05-26 16:07:30] Sending... #> [2021-05-26 16:07:30] Sending...complete #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730...complete #> [2021-05-26 16:07:30] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:30] Writing patelm9.V20210526160730... #> [2021-05-26 16:07:30] Writing patelm9.V20210526160730...complete #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: SELECT a.*, b.* FROM patelm9.V20210526160730 a LEFT JOIN omop_vocabulary.concept b ON a.ancestor_concept_id = b.concept_id WHERE b.invalid_reason IS NULL #> [2021-05-26 16:07:30] Querying... #> [2021-05-26 16:07:30] Querying...complete #> [2021-05-26 16:07:30] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730... #> [2021-05-26 16:07:30] ✓ Open connection #> [2021-05-26 16:07:30] ✓ JDBC connection #> [2021-05-26 16:07:30] SQL: DROP TABLE IF EXISTS patelm9.V20210526160730; #> [2021-05-26 16:07:30] Sending... #> [2021-05-26 16:07:30] Sending...complete #> [2021-05-26 16:07:30] Dropping patelm9.V20210526160730...complete #> [2021-05-26 16:07:31] Target column: parent_id #> [2021-05-26 16:07:31] Dropping patelm9.V20210526160731... #> [2021-05-26 16:07:31] ✓ Open connection #> [2021-05-26 16:07:31] ✓ JDBC connection #> [2021-05-26 16:07:31] SQL: DROP TABLE IF EXISTS patelm9.V20210526160731; #> [2021-05-26 16:07:31] Sending... #> [2021-05-26 16:07:31] Sending...complete #> [2021-05-26 16:07:31] Dropping patelm9.V20210526160731...complete #> [2021-05-26 16:07:31] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:31] Writing patelm9.V20210526160731... #> [2021-05-26 16:07:31] Writing patelm9.V20210526160731...complete #> [2021-05-26 16:07:31] ✓ Open connection #> [2021-05-26 16:07:31] ✓ JDBC connection #> [2021-05-26 16:07:31] SQL: SELECT a.*, b.descendant_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160731 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.parent_id = b.ancestor_concept_id #> [2021-05-26 16:07:31] Querying... #> [2021-05-26 16:07:31] Querying...complete #> [2021-05-26 16:07:31] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:31] Dropping patelm9.V20210526160731... #> [2021-05-26 16:07:31] ✓ Open connection #> [2021-05-26 16:07:31] ✓ JDBC connection #> [2021-05-26 16:07:31] SQL: DROP TABLE IF EXISTS patelm9.V20210526160731; #> [2021-05-26 16:07:31] Sending... #> [2021-05-26 16:07:31] Sending...complete #> [2021-05-26 16:07:31] Dropping patelm9.V20210526160731...complete #> [2021-05-26 16:07:31] Target column: descendant_concept_id #> [2021-05-26 16:07:31] Dropping patelm9.V20210526160731... #> [2021-05-26 16:07:31] ✓ Open connection #> [2021-05-26 16:07:31] ✓ JDBC connection #> [2021-05-26 16:07:31] SQL: DROP TABLE IF EXISTS patelm9.V20210526160731; #> [2021-05-26 16:07:31] Sending... #> [2021-05-26 16:07:31] Sending...complete #> [2021-05-26 16:07:31] Dropping patelm9.V20210526160731...complete #> [2021-05-26 16:07:31] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:31] Writing patelm9.V20210526160731... #> [2021-05-26 16:07:31] Writing patelm9.V20210526160731...complete #> [2021-05-26 16:07:31] ✓ Open connection #> [2021-05-26 16:07:31] ✓ JDBC connection #> [2021-05-26 16:07:31] SQL: SELECT a.*, b.* FROM patelm9.V20210526160731 a LEFT JOIN omop_vocabulary.concept b ON a.descendant_concept_id = b.concept_id WHERE b.invalid_reason IS NULL #> [2021-05-26 16:07:31] Querying... #> [2021-05-26 16:07:31] Querying...complete #> [2021-05-26 16:07:31] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:31] Dropping patelm9.V20210526160731... #> [2021-05-26 16:07:31] ✓ Open connection #> [2021-05-26 16:07:31] ✓ JDBC connection #> [2021-05-26 16:07:31] SQL: DROP TABLE IF EXISTS patelm9.V20210526160731; #> [2021-05-26 16:07:31] Sending... #> [2021-05-26 16:07:31] Sending...complete #> [2021-05-26 16:07:31] Dropping patelm9.V20210526160731...complete #> [V] [S] 4339397 Blood cell count [SNOMED 88308000] [Measurement] [Procedure] #> *[V] [S] 4298431 White blood cell count [SNOMED 767002] [Measurement] [Procedure] #> [V] [S] 4035541 Blood cell count, automated [SNOMED 117356000] [Measurement] [Procedure] #> [V] [S] 2212649 Blood count; complete (CBC), automated (Hgb, Hct, RBC, WBC and platelet count) [CPT4 85027] [Measurement] [CPT4] #> [V] [S] 4035540 Blood cell count, manual [SNOMED 117355001] [Measurement] [Procedure] #> [V] [S] 4030871 Red blood cell count [SNOMED 14089001] [Measurement] [Procedure] #> [V] [S] 2213329 Leukocyte assessment, fecal, qualitative or semiquantitative [CPT4 89055] [Measurement] [CPT4] #> [V] [S] 4270019 Percentage reticulated platelet count [SNOMED 401296001] [Measurement] [Procedure] #> [V] [S] 2212652 Blood count; red blood cell (RBC), automated [CPT4 85041] [Measurement] [CPT4] #> [V] [S] 2212654 Blood count; reticulocyte, automated [CPT4 85045] [Measurement] [CPT4] #> [V] [S] 2212656 Blood count; leukocyte (WBC), automated [CPT4 85048] [Measurement] [CPT4] #> [V] [S] 4254487 Large unstained cell count [SNOMED 409087007] [Measurement] [Procedure] #> [V] [S] 4298431 White blood cell count [SNOMED 767002] [Measurement] [Procedure] #> [V] [S] 4132152 Complete blood count [SNOMED 26604007] [Measurement] [Procedure] #> [V] [S] 2212640 Blood count; manual differential WBC count, buffy coat [CPT4 85009] [Measurement] [CPT4] #> [V] [S] 44806871 Immature platelet fraction count [SNOMED 803431000000106] [Measurement] [Procedure] #> [V] [S] 4267147 Platelet count [SNOMED 61928009] [Measurement] [Procedure] #> [V] [S] 2212651 Blood count; manual cell count (erythrocyte, leukocyte, or platelet) each [CPT4 85032] [Measurement] [CPT4] #> [V] [S] 4133662 Peritoneal dialysis fluid cell count [SNOMED 412897006] [Measurement] [Procedure] #> [V] [S] 4016230 Blast count, blood [SNOMED 104102000] [Measurement] [Procedure]#> [2021-05-26 16:07:31] Postgres connection to 'athena' closed