Join On Concept Synonym Name
join_on_concept_synonym_name( kind = c("LEFT", "RIGHT", "INNER", "FULL"), data, column = NULL, select_data_columns = "*", distinct = FALSE, write_schema = "patelm9", vocab_schema = "omop_vocabulary", where_in_concept_synonym_field, where_in_concept_synonym_field_value, where_not_in_concept_synonym_field, where_not_in_concept_synonym_field_value, where_is_null_concept_synonym_field, where_is_not_null_concept_synonym_field, case_insensitive = TRUE, conn, conn_fun = "connectAthena()", verbose = TRUE, render_sql = TRUE, render_only = FALSE )
| where_in_concept_synonym_field | PARAM_DESCRIPTION |
|---|---|
| where_in_concept_synonym_field_value | PARAM_DESCRIPTION |
| where_not_in_concept_synonym_field | PARAM_DESCRIPTION |
| where_not_in_concept_synonym_field_value | PARAM_DESCRIPTION |
| where_is_null_concept_synonym_field | PARAM_DESCRIPTION |
| where_is_not_null_concept_synonym_field | PARAM_DESCRIPTION |
#> [2021-05-26 16:06:56] Connected to 'athena'test_data <- queryAthena( conn = conn, sql_statement = " SELECT concept_id AS test_concept_id, concept_name AS test_concept_name, concept_code AS test_concept_code FROM omop_vocabulary.concept ORDER BY RANDOM() LIMIT 20;")#> [2021-05-26 16:06:56] Loading Cache... #> [2021-05-26 16:06:56] Cached SQL: #> SELECT #> concept_id AS test_concept_id, #> concept_name AS test_concept_name, #> concept_code AS test_concept_code #> FROM omop_vocabulary.concept #> ORDER BY RANDOM() #> LIMIT 20; #> [2021-05-26 16:06:56] Cached resultset found...test_data#> # A tibble: 20 x 3 #> test_concept_id test_concept_name test_concept_code #> <int> <chr> <chr> #> 1 822160 titanium dioxide and zinc oxide 35mg/… c7a2c97a-8fa7-463b-b0… #> 2 41264590 topiramate 50 MG [Topiramat Basics] OMOP2462552 #> 3 21453274 Haddenham Veni class 1 (18-21mmHg) ti… 26196011000001108 #> 4 4100962 Megaloblastic anemia due to impaired … 27798002 #> 5 21221431 Piroxicam 20mg capsules 13244211000001106 #> 6 37293276 ethanol 0.7 ML/ML Topical Gel 78072050047 #> 7 2749194 Removal of Intraluminal Device from L… 0CPSXDZ #> 8 42918353 500 ML Glucose 50 MG/ML Injectable So… OMOP4645243 #> 9 43869022 81.9 ML Clarithromycin 25 MG/ML Oral … OMOP820089 #> 10 36711737 Gloria Med Soft class 2 (23-32mmHg) t… 33842011000001103 #> 11 45095380 Ascorbic Acid 100 MG / Biotin 0.15 MG… 00256023302 #> 12 36879604 LEVOMENTHOL 0.1 MG/MG OMOP992836 #> 13 3580563 Zadstat 200mg tablet 408001000001109 #> 14 41134095 olmesartan 20 MG Oral Tablet [Olmetec… OMOP2332057 #> 15 3106614 Pemphigoid 156356009 #> 16 36274507 Bisoprolol 5 MG / Hydrochlorothiazide… OMOP3125382 #> 17 43217420 Cefuroxime 250 MG [CEFUROXIME ACTAVIS] OMOP498261 #> 18 37052466 Neoplastic cells/100 leukocytes LP286639-2 #> 19 41261741 Cetirizine 10 MG Extended Release Ora… OMOP2459703 #> 20 4110027 Chronic infective rhinitis 195770009# `Join On` functions point to the true column that is being joined on join_on_concept_id( conn = conn, data = test_data, column = "test_concept_id" )#> [2021-05-26 16:06:56] Target column: test_concept_id #> [2021-05-26 16:06:56] Dropping patelm9.V20210526160656... #> [2021-05-26 16:06:56] ✓ Open connection #> [2021-05-26 16:06:56] ✓ JDBC connection #> [2021-05-26 16:06:56] SQL: DROP TABLE IF EXISTS patelm9.V20210526160656; #> [2021-05-26 16:06:56] Sending... #> [2021-05-26 16:06:56] Sending...complete #> [2021-05-26 16:06:56] Dropping patelm9.V20210526160656...complete #> [2021-05-26 16:06:56] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:06:56] Writing patelm9.V20210526160656... #> [2021-05-26 16:06:56] Writing patelm9.V20210526160656...complete #> [2021-05-26 16:06:56] ✓ Open connection #> [2021-05-26 16:06:56] ✓ JDBC connection #> [2021-05-26 16:06:56] SQL: SELECT a.*, b.* FROM patelm9.V20210526160656 a LEFT JOIN omop_vocabulary.concept b ON a.test_concept_id = b.concept_id WHERE b.invalid_reason IS NULL #> [2021-05-26 16:06:56] Querying... #> [2021-05-26 16:06:56] Querying...complete #> [2021-05-26 16:06:56] ✓ Returned data has more than 0 rows #> [2021-05-26 16:06:56] Dropping patelm9.V20210526160656... #> [2021-05-26 16:06:56] ✓ Open connection #> [2021-05-26 16:06:56] ✓ JDBC connection #> [2021-05-26 16:06:56] SQL: DROP TABLE IF EXISTS patelm9.V20210526160656; #> [2021-05-26 16:06:56] Sending... #> [2021-05-26 16:06:56] Sending...complete #> [2021-05-26 16:06:56] Dropping patelm9.V20210526160656...complete#> test_concept_id #> 1 822160 #> 2 41264590 #> 3 21453274 #> 4 4100962 #> 5 21221431 #> 6 37293276 #> 7 2749194 #> 8 42918353 #> 9 43869022 #> 10 36711737 #> 11 36879604 #> 12 41134095 #> 13 36274507 #> 14 43217420 #> 15 37052466 #> 16 41261741 #> 17 4110027 #> test_concept_name #> 1 titanium dioxide and zinc oxide 35mg/mL / 45.5mg/mL TOPICAL LIQUID [sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen deep, sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen light, sugar r... #> 2 topiramate 50 MG [Topiramat Basics] #> 3 Haddenham Veni class 1 (18-21mmHg) tights open toe lymphoedema garment extra wide short size V #> 4 Megaloblastic anemia due to impaired absorption of folate #> 5 Piroxicam 20mg capsules #> 6 ethanol 0.7 ML/ML Topical Gel #> 7 Removal of Intraluminal Device from Larynx, External Approach #> 8 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 9 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 10 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 11 LEVOMENTHOL 0.1 MG/MG #> 12 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 13 Bisoprolol 5 MG / Hydrochlorothiazide 12.5 MG [BISOPROLOL/HYDROCHLOROTHIAZIDE TEVA] #> 14 Cefuroxime 250 MG [CEFUROXIME ACTAVIS] #> 15 Neoplastic cells/100 leukocytes #> 16 Cetirizine 10 MG Extended Release Oral Tablet [Zyrtec] Box of 100 by Diaprax #> 17 Chronic infective rhinitis #> test_concept_code concept_id #> 1 c7a2c97a-8fa7-463b-b024-b199bc7cf469 822160 #> 2 OMOP2462552 41264590 #> 3 26196011000001108 21453274 #> 4 27798002 4100962 #> 5 13244211000001106 21221431 #> 6 78072050047 37293276 #> 7 0CPSXDZ 2749194 #> 8 OMOP4645243 42918353 #> 9 OMOP820089 43869022 #> 10 33842011000001103 36711737 #> 11 OMOP992836 36879604 #> 12 OMOP2332057 41134095 #> 13 OMOP3125382 36274507 #> 14 OMOP498261 43217420 #> 15 LP286639-2 37052466 #> 16 OMOP2459703 41261741 #> 17 195770009 4110027 #> concept_name #> 1 titanium dioxide and zinc oxide 35mg/mL / 45.5mg/mL TOPICAL LIQUID [sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen deep, sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen light, sugar r... #> 2 topiramate 50 MG [Topiramat Basics] #> 3 Haddenham Veni class 1 (18-21mmHg) tights open toe lymphoedema garment extra wide short size V #> 4 Megaloblastic anemia due to impaired absorption of folate #> 5 Piroxicam 20mg capsules #> 6 ethanol 0.7 ML/ML Topical Gel #> 7 Removal of Intraluminal Device from Larynx, External Approach #> 8 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 9 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 10 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 11 LEVOMENTHOL 0.1 MG/MG #> 12 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 13 Bisoprolol 5 MG / Hydrochlorothiazide 12.5 MG [BISOPROLOL/HYDROCHLOROTHIAZIDE TEVA] #> 14 Cefuroxime 250 MG [CEFUROXIME ACTAVIS] #> 15 Neoplastic cells/100 leukocytes #> 16 Cetirizine 10 MG Extended Release Oral Tablet [Zyrtec] Box of 100 by Diaprax #> 17 Chronic infective rhinitis #> domain_id vocabulary_id concept_class_id standard_concept #> 1 Drug SPL OTC Drug C #> 2 Drug RxNorm Extension Branded Drug Comp S #> 3 Device dm+d AMP <NA> #> 4 Condition SNOMED Clinical Finding S #> 5 Drug dm+d AMP <NA> #> 6 Drug NDC 11-digit NDC <NA> #> 7 Procedure ICD10PCS ICD10PCS S #> 8 Drug RxNorm Extension Quant Branded Drug S #> 9 Drug RxNorm Extension Marketed Product S #> 10 Device SNOMED Physical Object S #> 11 Drug RxNorm Extension Clinical Drug Comp S #> 12 Drug RxNorm Extension Marketed Product S #> 13 Drug RxNorm Extension Branded Drug Comp S #> 14 Drug RxNorm Extension Branded Drug Comp S #> 15 Observation LOINC LOINC Component <NA> #> 16 Drug RxNorm Extension Marketed Product S #> 17 Condition SNOMED Clinical Finding S #> concept_code valid_start_date valid_end_date #> 1 c7a2c97a-8fa7-463b-b024-b199bc7cf469 2019-05-13 2099-12-31 #> 2 OMOP2462552 2017-08-24 2099-12-31 #> 3 26196011000001108 1970-01-01 2099-12-31 #> 4 27798002 2002-01-31 2099-12-31 #> 5 13244211000001106 1970-01-01 2099-12-31 #> 6 78072050047 2020-08-01 2099-12-31 #> 7 0CPSXDZ 2014-04-22 2099-12-31 #> 8 OMOP4645243 2018-08-21 2099-12-31 #> 9 OMOP820089 2017-08-24 2099-12-31 #> 10 33842011000001103 2017-03-01 2099-12-31 #> 11 OMOP992836 2017-08-24 2099-12-31 #> 12 OMOP2332057 2017-08-24 2099-12-31 #> 13 OMOP3125382 2017-10-01 2099-12-31 #> 14 OMOP498261 2017-08-24 2099-12-31 #> 15 LP286639-2 1970-01-01 2099-12-31 #> 16 OMOP2459703 2017-08-24 2099-12-31 #> 17 195770009 2002-01-31 2099-12-31 #> invalid_reason #> 1 <NA> #> 2 <NA> #> 3 <NA> #> 4 <NA> #> 5 <NA> #> 6 <NA> #> 7 <NA> #> 8 <NA> #> 9 <NA> #> 10 <NA> #> 11 <NA> #> 12 <NA> #> 13 <NA> #> 14 <NA> #> 15 <NA> #> 16 <NA> #> 17 <NA>#> [2021-05-26 16:06:56] Target column: test_concept_code #> [2021-05-26 16:06:56] Dropping patelm9.V20210526160656... #> [2021-05-26 16:06:56] ✓ Open connection #> [2021-05-26 16:06:56] ✓ JDBC connection #> [2021-05-26 16:06:56] SQL: DROP TABLE IF EXISTS patelm9.V20210526160656; #> [2021-05-26 16:06:56] Sending... #> [2021-05-26 16:06:56] Sending...complete #> [2021-05-26 16:06:56] Dropping patelm9.V20210526160656...complete #> [2021-05-26 16:06:56] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:06:56] Writing patelm9.V20210526160656... #> [2021-05-26 16:06:56] Writing patelm9.V20210526160656...complete #> [2021-05-26 16:06:56] ✓ Open connection #> [2021-05-26 16:06:56] ✓ JDBC connection #> [2021-05-26 16:06:56] SQL: SELECT a.*, b.* FROM patelm9.V20210526160656 a LEFT JOIN omop_vocabulary.concept b ON a.test_concept_code = b.concept_code WHERE b.invalid_reason IS NULL #> [2021-05-26 16:06:56] Querying... #> [2021-05-26 16:06:56] Querying...complete #> [2021-05-26 16:06:56] ✓ Returned data has more than 0 rows #> [2021-05-26 16:06:56] Dropping patelm9.V20210526160656... #> [2021-05-26 16:06:56] ✓ Open connection #> [2021-05-26 16:06:56] ✓ JDBC connection #> [2021-05-26 16:06:56] SQL: DROP TABLE IF EXISTS patelm9.V20210526160656; #> [2021-05-26 16:06:56] Sending... #> [2021-05-26 16:06:56] Sending...complete #> [2021-05-26 16:06:56] Dropping patelm9.V20210526160656...complete#> test_concept_id #> 1 822160 #> 2 41264590 #> 3 21453274 #> 4 21453274 #> 5 4100962 #> 6 4100962 #> 7 21221431 #> 8 21221431 #> 9 37293276 #> 10 2749194 #> 11 42918353 #> 12 43869022 #> 13 36711737 #> 14 36711737 #> 15 36879604 #> 16 41134095 #> 17 36274507 #> 18 43217420 #> 19 37052466 #> 20 41261741 #> 21 4110027 #> 22 4110027 #> test_concept_name #> 1 titanium dioxide and zinc oxide 35mg/mL / 45.5mg/mL TOPICAL LIQUID [sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen deep, sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen light, sugar r... #> 2 topiramate 50 MG [Topiramat Basics] #> 3 Haddenham Veni class 1 (18-21mmHg) tights open toe lymphoedema garment extra wide short size V #> 4 Haddenham Veni class 1 (18-21mmHg) tights open toe lymphoedema garment extra wide short size V #> 5 Megaloblastic anemia due to impaired absorption of folate #> 6 Megaloblastic anemia due to impaired absorption of folate #> 7 Piroxicam 20mg capsules #> 8 Piroxicam 20mg capsules #> 9 ethanol 0.7 ML/ML Topical Gel #> 10 Removal of Intraluminal Device from Larynx, External Approach #> 11 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 12 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 13 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 14 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 15 LEVOMENTHOL 0.1 MG/MG #> 16 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 17 Bisoprolol 5 MG / Hydrochlorothiazide 12.5 MG [BISOPROLOL/HYDROCHLOROTHIAZIDE TEVA] #> 18 Cefuroxime 250 MG [CEFUROXIME ACTAVIS] #> 19 Neoplastic cells/100 leukocytes #> 20 Cetirizine 10 MG Extended Release Oral Tablet [Zyrtec] Box of 100 by Diaprax #> 21 Chronic infective rhinitis #> 22 Chronic infective rhinitis #> test_concept_code concept_id #> 1 c7a2c97a-8fa7-463b-b024-b199bc7cf469 822160 #> 2 OMOP2462552 41264590 #> 3 26196011000001108 21453274 #> 4 26196011000001108 46065851 #> 5 27798002 3459901 #> 6 27798002 4100962 #> 7 13244211000001106 21221431 #> 8 13244211000001106 46015101 #> 9 78072050047 37293276 #> 10 0CPSXDZ 2749194 #> 11 OMOP4645243 42918353 #> 12 OMOP820089 43869022 #> 13 33842011000001103 36711737 #> 14 33842011000001103 40682343 #> 15 OMOP992836 36879604 #> 16 OMOP2332057 41134095 #> 17 OMOP3125382 36274507 #> 18 OMOP498261 43217420 #> 19 LP286639-2 37052466 #> 20 OMOP2459703 41261741 #> 21 195770009 3368617 #> 22 195770009 4110027 #> concept_name #> 1 titanium dioxide and zinc oxide 35mg/mL / 45.5mg/mL TOPICAL LIQUID [sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen deep, sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen light, sugar r... #> 2 topiramate 50 MG [Topiramat Basics] #> 3 Haddenham Veni class 1 (18-21mmHg) tights open toe lymphoedema garment extra wide short size V #> 4 Haddenham Veni class 1 (18-21mmHg) tights open toe lymphoedema garment extra wide short size V Navy (Haddenham Healthcare Ltd) #> 5 Megaloblastic anaemia due to impaired absorption of folate #> 6 Megaloblastic anemia due to impaired absorption of folate #> 7 Piroxicam 20mg capsules #> 8 Piroxicam 20mg capsules (Dowelhurst Ltd) #> 9 ethanol 0.7 ML/ML Topical Gel #> 10 Removal of Intraluminal Device from Larynx, External Approach #> 11 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 12 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 13 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 14 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 15 LEVOMENTHOL 0.1 MG/MG #> 16 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 17 Bisoprolol 5 MG / Hydrochlorothiazide 12.5 MG [BISOPROLOL/HYDROCHLOROTHIAZIDE TEVA] #> 18 Cefuroxime 250 MG [CEFUROXIME ACTAVIS] #> 19 Neoplastic cells/100 leukocytes #> 20 Cetirizine 10 MG Extended Release Oral Tablet [Zyrtec] Box of 100 by Diaprax #> 21 Chronic infective rhinitis #> 22 Chronic infective rhinitis #> domain_id vocabulary_id concept_class_id standard_concept #> 1 Drug SPL OTC Drug C #> 2 Drug RxNorm Extension Branded Drug Comp S #> 3 Device dm+d AMP <NA> #> 4 Device SNOMED Physical Object S #> 5 Condition Nebraska Lexicon Clinical Finding <NA> #> 6 Condition SNOMED Clinical Finding S #> 7 Drug dm+d AMP <NA> #> 8 Drug SNOMED Pharma/Biol Product <NA> #> 9 Drug NDC 11-digit NDC <NA> #> 10 Procedure ICD10PCS ICD10PCS S #> 11 Drug RxNorm Extension Quant Branded Drug S #> 12 Drug RxNorm Extension Marketed Product S #> 13 Device SNOMED Physical Object S #> 14 Device dm+d AMPP <NA> #> 15 Drug RxNorm Extension Clinical Drug Comp S #> 16 Drug RxNorm Extension Marketed Product S #> 17 Drug RxNorm Extension Branded Drug Comp S #> 18 Drug RxNorm Extension Branded Drug Comp S #> 19 Observation LOINC LOINC Component <NA> #> 20 Drug RxNorm Extension Marketed Product S #> 21 Condition Nebraska Lexicon Clinical Finding <NA> #> 22 Condition SNOMED Clinical Finding S #> concept_code valid_start_date valid_end_date #> 1 c7a2c97a-8fa7-463b-b024-b199bc7cf469 2019-05-13 2099-12-31 #> 2 OMOP2462552 2017-08-24 2099-12-31 #> 3 26196011000001108 1970-01-01 2099-12-31 #> 4 26196011000001108 2014-10-15 2099-12-31 #> 5 27798002 2002-01-31 2099-12-31 #> 6 27798002 2002-01-31 2099-12-31 #> 7 13244211000001106 1970-01-01 2099-12-31 #> 8 13244211000001106 2008-10-01 2099-12-31 #> 9 78072050047 2020-08-01 2099-12-31 #> 10 0CPSXDZ 2014-04-22 2099-12-31 #> 11 OMOP4645243 2018-08-21 2099-12-31 #> 12 OMOP820089 2017-08-24 2099-12-31 #> 13 33842011000001103 2017-03-01 2099-12-31 #> 14 33842011000001103 1970-01-01 2099-12-31 #> 15 OMOP992836 2017-08-24 2099-12-31 #> 16 OMOP2332057 2017-08-24 2099-12-31 #> 17 OMOP3125382 2017-10-01 2099-12-31 #> 18 OMOP498261 2017-08-24 2099-12-31 #> 19 LP286639-2 1970-01-01 2099-12-31 #> 20 OMOP2459703 2017-08-24 2099-12-31 #> 21 195770009 2002-07-31 2099-12-31 #> 22 195770009 2002-01-31 2099-12-31 #> invalid_reason #> 1 <NA> #> 2 <NA> #> 3 <NA> #> 4 <NA> #> 5 <NA> #> 6 <NA> #> 7 <NA> #> 8 <NA> #> 9 <NA> #> 10 <NA> #> 11 <NA> #> 12 <NA> #> 13 <NA> #> 14 <NA> #> 15 <NA> #> 16 <NA> #> 17 <NA> #> 18 <NA> #> 19 <NA> #> 20 <NA> #> 21 <NA> #> 22 <NA>#> [2021-05-26 16:06:56] Target column: test_concept_name #> [2021-05-26 16:06:56] Dropping patelm9.V20210526160656... #> [2021-05-26 16:06:56] ✓ Open connection #> [2021-05-26 16:06:56] ✓ JDBC connection #> [2021-05-26 16:06:56] SQL: DROP TABLE IF EXISTS patelm9.V20210526160656; #> [2021-05-26 16:06:56] Sending... #> [2021-05-26 16:06:56] Sending...complete #> [2021-05-26 16:06:56] Dropping patelm9.V20210526160656...complete #> [2021-05-26 16:06:56] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:06:56] Writing patelm9.V20210526160656... #> [2021-05-26 16:06:56] Writing patelm9.V20210526160656...complete #> [2021-05-26 16:06:56] ✓ Open connection #> [2021-05-26 16:06:56] ✓ JDBC connection #> [2021-05-26 16:06:56] SQL: SELECT a.*, b.* FROM patelm9.V20210526160656 a LEFT JOIN omop_vocabulary.concept b ON a.test_concept_name = b.concept_name WHERE b.invalid_reason IS NULL #> [2021-05-26 16:06:56] Querying... #> [2021-05-26 16:06:59] Querying...complete #> [2021-05-26 16:06:59] ✓ Returned data has more than 0 rows #> [2021-05-26 16:06:59] Dropping patelm9.V20210526160656... #> [2021-05-26 16:06:59] ✓ Open connection #> [2021-05-26 16:06:59] ✓ JDBC connection #> [2021-05-26 16:06:59] SQL: DROP TABLE IF EXISTS patelm9.V20210526160656; #> [2021-05-26 16:06:59] Sending... #> [2021-05-26 16:06:59] Sending...complete #> [2021-05-26 16:06:59] Dropping patelm9.V20210526160656...complete#> test_concept_id #> 1 3106614 #> 2 37293276 #> 3 37293276 #> 4 37293276 #> 5 37293276 #> 6 37293276 #> 7 37293276 #> 8 37293276 #> 9 37293276 #> 10 37293276 #> 11 37293276 #> 12 37293276 #> 13 37293276 #> 14 37293276 #> 15 37293276 #> 16 37293276 #> 17 37293276 #> 18 37293276 #> 19 37293276 #> 20 37293276 #> 21 37293276 #> 22 37293276 #> 23 37293276 #> 24 37293276 #> 25 37293276 #> 26 37293276 #> 27 37293276 #> 28 37293276 #> 29 822160 #> 30 37293276 #> 31 37293276 #> 32 37293276 #> 33 37293276 #> 34 37293276 #> 35 37293276 #> 36 37293276 #> 37 37293276 #> 38 37293276 #> 39 37293276 #> 40 37293276 #> 41 37293276 #> 42 37293276 #> 43 37293276 #> 44 37293276 #> 45 37293276 #> 46 37293276 #> 47 37293276 #> 48 37293276 #> 49 37293276 #> 50 37293276 #> 51 37293276 #> 52 37293276 #> 53 37293276 #> 54 37293276 #> 55 37293276 #> 56 37293276 #> 57 37293276 #> 58 37293276 #> 59 37293276 #> 60 37293276 #> 61 37293276 #> 62 37293276 #> 63 37293276 #> 64 37293276 #> 65 37293276 #> 66 37293276 #> 67 37293276 #> 68 37293276 #> 69 37293276 #> 70 37293276 #> 71 37293276 #> 72 37293276 #> 73 37293276 #> 74 37293276 #> 75 37293276 #> 76 37293276 #> test_concept_name #> 1 Pemphigoid #> 2 ethanol 0.7 ML/ML Topical Gel #> 3 ethanol 0.7 ML/ML Topical Gel #> 4 ethanol 0.7 ML/ML Topical Gel #> 5 ethanol 0.7 ML/ML Topical Gel #> 6 ethanol 0.7 ML/ML Topical Gel #> 7 ethanol 0.7 ML/ML Topical Gel #> 8 ethanol 0.7 ML/ML Topical Gel #> 9 ethanol 0.7 ML/ML Topical Gel #> 10 ethanol 0.7 ML/ML Topical Gel #> 11 ethanol 0.7 ML/ML Topical Gel #> 12 ethanol 0.7 ML/ML Topical Gel #> 13 ethanol 0.7 ML/ML Topical Gel #> 14 ethanol 0.7 ML/ML Topical Gel #> 15 ethanol 0.7 ML/ML Topical Gel #> 16 ethanol 0.7 ML/ML Topical Gel #> 17 ethanol 0.7 ML/ML Topical Gel #> 18 ethanol 0.7 ML/ML Topical Gel #> 19 ethanol 0.7 ML/ML Topical Gel #> 20 ethanol 0.7 ML/ML Topical Gel #> 21 ethanol 0.7 ML/ML Topical Gel #> 22 ethanol 0.7 ML/ML Topical Gel #> 23 ethanol 0.7 ML/ML Topical Gel #> 24 ethanol 0.7 ML/ML Topical Gel #> 25 ethanol 0.7 ML/ML Topical Gel #> 26 ethanol 0.7 ML/ML Topical Gel #> 27 ethanol 0.7 ML/ML Topical Gel #> 28 ethanol 0.7 ML/ML Topical Gel #> 29 titanium dioxide and zinc oxide 35mg/mL / 45.5mg/mL TOPICAL LIQUID [sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen deep, sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen light, sugar r... #> 30 ethanol 0.7 ML/ML Topical Gel #> 31 ethanol 0.7 ML/ML Topical Gel #> 32 ethanol 0.7 ML/ML Topical Gel #> 33 ethanol 0.7 ML/ML Topical Gel #> 34 ethanol 0.7 ML/ML Topical Gel #> 35 ethanol 0.7 ML/ML Topical Gel #> 36 ethanol 0.7 ML/ML Topical Gel #> 37 ethanol 0.7 ML/ML Topical Gel #> 38 ethanol 0.7 ML/ML Topical Gel #> 39 ethanol 0.7 ML/ML Topical Gel #> 40 ethanol 0.7 ML/ML Topical Gel #> 41 ethanol 0.7 ML/ML Topical Gel #> 42 ethanol 0.7 ML/ML Topical Gel #> 43 ethanol 0.7 ML/ML Topical Gel #> 44 ethanol 0.7 ML/ML Topical Gel #> 45 ethanol 0.7 ML/ML Topical Gel #> 46 ethanol 0.7 ML/ML Topical Gel #> 47 ethanol 0.7 ML/ML Topical Gel #> 48 ethanol 0.7 ML/ML Topical Gel #> 49 ethanol 0.7 ML/ML Topical Gel #> 50 ethanol 0.7 ML/ML Topical Gel #> 51 ethanol 0.7 ML/ML Topical Gel #> 52 ethanol 0.7 ML/ML Topical Gel #> 53 ethanol 0.7 ML/ML Topical Gel #> 54 ethanol 0.7 ML/ML Topical Gel #> 55 ethanol 0.7 ML/ML Topical Gel #> 56 ethanol 0.7 ML/ML Topical Gel #> 57 ethanol 0.7 ML/ML Topical Gel #> 58 ethanol 0.7 ML/ML Topical Gel #> 59 ethanol 0.7 ML/ML Topical Gel #> 60 ethanol 0.7 ML/ML Topical Gel #> 61 ethanol 0.7 ML/ML Topical Gel #> 62 ethanol 0.7 ML/ML Topical Gel #> 63 ethanol 0.7 ML/ML Topical Gel #> 64 ethanol 0.7 ML/ML Topical Gel #> 65 ethanol 0.7 ML/ML Topical Gel #> 66 ethanol 0.7 ML/ML Topical Gel #> 67 ethanol 0.7 ML/ML Topical Gel #> 68 ethanol 0.7 ML/ML Topical Gel #> 69 ethanol 0.7 ML/ML Topical Gel #> 70 ethanol 0.7 ML/ML Topical Gel #> 71 ethanol 0.7 ML/ML Topical Gel #> 72 ethanol 0.7 ML/ML Topical Gel #> 73 ethanol 0.7 ML/ML Topical Gel #> 74 ethanol 0.7 ML/ML Topical Gel #> 75 ethanol 0.7 ML/ML Topical Gel #> 76 ethanol 0.7 ML/ML Topical Gel #> test_concept_code concept_id #> 1 156356009 139899 #> 2 78072050047 593046 #> 3 78072050047 593047 #> 4 78072050047 593048 #> 5 78072050047 593114 #> 6 78072050047 593115 #> 7 78072050047 800338 #> 8 78072050047 800339 #> 9 78072050047 800340 #> 10 78072050047 819459 #> 11 78072050047 819961 #> 12 78072050047 819962 #> 13 78072050047 819963 #> 14 78072050047 819964 #> 15 78072050047 819965 #> 16 78072050047 819966 #> 17 78072050047 819967 #> 18 78072050047 819968 #> 19 78072050047 819969 #> 20 78072050047 819970 #> 21 78072050047 819971 #> 22 78072050047 819972 #> 23 78072050047 819983 #> 24 78072050047 819984 #> 25 78072050047 819985 #> 26 78072050047 819986 #> 27 78072050047 819987 #> 28 78072050047 819988 #> 29 c7a2c97a-8fa7-463b-b024-b199bc7cf469 822160 #> 30 78072050047 822359 #> 31 78072050047 822552 #> 32 78072050047 823483 #> 33 78072050047 823487 #> 34 78072050047 823489 #> 35 78072050047 823490 #> 36 78072050047 823491 #> 37 78072050047 823492 #> 38 78072050047 823493 #> 39 78072050047 823494 #> 40 78072050047 823495 #> 41 78072050047 823496 #> 42 78072050047 823497 #> 43 78072050047 823501 #> 44 78072050047 823502 #> 45 78072050047 823503 #> 46 78072050047 823504 #> 47 78072050047 823505 #> 48 78072050047 823506 #> 49 78072050047 823507 #> 50 78072050047 823508 #> 51 78072050047 823509 #> 52 78072050047 823510 #> 53 78072050047 823511 #> 54 78072050047 823512 #> 55 78072050047 823513 #> 56 78072050047 823514 #> 57 78072050047 823515 #> 58 78072050047 823516 #> 59 78072050047 823547 #> 60 78072050047 823548 #> 61 78072050047 823832 #> 62 78072050047 823833 #> 63 78072050047 823834 #> 64 78072050047 823835 #> 65 78072050047 823836 #> 66 78072050047 823837 #> 67 78072050047 824081 #> 68 78072050047 824082 #> 69 78072050047 824083 #> 70 78072050047 824084 #> 71 78072050047 824085 #> 72 78072050047 824086 #> 73 78072050047 824087 #> 74 78072050047 824088 #> 75 78072050047 824089 #> 76 78072050047 824180 #> concept_name #> 1 Pemphigoid #> 2 ethanol 0.7 ML/ML Topical Gel #> 3 ethanol 0.7 ML/ML Topical Gel #> 4 ethanol 0.7 ML/ML Topical Gel #> 5 ethanol 0.7 ML/ML Topical Gel #> 6 ethanol 0.7 ML/ML Topical Gel #> 7 ethanol 0.7 ML/ML Topical Gel #> 8 ethanol 0.7 ML/ML Topical Gel #> 9 ethanol 0.7 ML/ML Topical Gel #> 10 ethanol 0.7 ML/ML Topical Gel #> 11 ethanol 0.7 ML/ML Topical Gel #> 12 ethanol 0.7 ML/ML Topical Gel #> 13 ethanol 0.7 ML/ML Topical Gel #> 14 ethanol 0.7 ML/ML Topical Gel #> 15 ethanol 0.7 ML/ML Topical Gel #> 16 ethanol 0.7 ML/ML Topical Gel #> 17 ethanol 0.7 ML/ML Topical Gel #> 18 ethanol 0.7 ML/ML Topical Gel #> 19 ethanol 0.7 ML/ML Topical Gel #> 20 ethanol 0.7 ML/ML Topical Gel #> 21 ethanol 0.7 ML/ML Topical Gel #> 22 ethanol 0.7 ML/ML Topical Gel #> 23 ethanol 0.7 ML/ML Topical Gel #> 24 ethanol 0.7 ML/ML Topical Gel #> 25 ethanol 0.7 ML/ML Topical Gel #> 26 ethanol 0.7 ML/ML Topical Gel #> 27 ethanol 0.7 ML/ML Topical Gel #> 28 ethanol 0.7 ML/ML Topical Gel #> 29 titanium dioxide and zinc oxide 35mg/mL / 45.5mg/mL TOPICAL LIQUID [sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen deep, sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen light, sugar r... #> 30 ethanol 0.7 ML/ML Topical Gel #> 31 ethanol 0.7 ML/ML Topical Gel #> 32 ethanol 0.7 ML/ML Topical Gel #> 33 ethanol 0.7 ML/ML Topical Gel #> 34 ethanol 0.7 ML/ML Topical Gel #> 35 ethanol 0.7 ML/ML Topical Gel #> 36 ethanol 0.7 ML/ML Topical Gel #> 37 ethanol 0.7 ML/ML Topical Gel #> 38 ethanol 0.7 ML/ML Topical Gel #> 39 ethanol 0.7 ML/ML Topical Gel #> 40 ethanol 0.7 ML/ML Topical Gel #> 41 ethanol 0.7 ML/ML Topical Gel #> 42 ethanol 0.7 ML/ML Topical Gel #> 43 ethanol 0.7 ML/ML Topical Gel #> 44 ethanol 0.7 ML/ML Topical Gel #> 45 ethanol 0.7 ML/ML Topical Gel #> 46 ethanol 0.7 ML/ML Topical Gel #> 47 ethanol 0.7 ML/ML Topical Gel #> 48 ethanol 0.7 ML/ML Topical Gel #> 49 ethanol 0.7 ML/ML Topical Gel #> 50 ethanol 0.7 ML/ML Topical Gel #> 51 ethanol 0.7 ML/ML Topical Gel #> 52 ethanol 0.7 ML/ML Topical Gel #> 53 ethanol 0.7 ML/ML Topical Gel #> 54 ethanol 0.7 ML/ML Topical Gel #> 55 ethanol 0.7 ML/ML Topical Gel #> 56 ethanol 0.7 ML/ML Topical Gel #> 57 ethanol 0.7 ML/ML Topical Gel #> 58 ethanol 0.7 ML/ML Topical Gel #> 59 ethanol 0.7 ML/ML Topical Gel #> 60 ethanol 0.7 ML/ML Topical Gel #> 61 ethanol 0.7 ML/ML Topical Gel #> 62 ethanol 0.7 ML/ML Topical Gel #> 63 ethanol 0.7 ML/ML Topical Gel #> 64 ethanol 0.7 ML/ML Topical Gel #> 65 ethanol 0.7 ML/ML Topical Gel #> 66 ethanol 0.7 ML/ML Topical Gel #> 67 ethanol 0.7 ML/ML Topical Gel #> 68 ethanol 0.7 ML/ML Topical Gel #> 69 ethanol 0.7 ML/ML Topical Gel #> 70 ethanol 0.7 ML/ML Topical Gel #> 71 ethanol 0.7 ML/ML Topical Gel #> 72 ethanol 0.7 ML/ML Topical Gel #> 73 ethanol 0.7 ML/ML Topical Gel #> 74 ethanol 0.7 ML/ML Topical Gel #> 75 ethanol 0.7 ML/ML Topical Gel #> 76 ethanol 0.7 ML/ML Topical Gel #> domain_id vocabulary_id concept_class_id standard_concept #> 1 Condition SNOMED Clinical Finding S #> 2 Drug NDC 11-digit NDC <NA> #> 3 Drug NDC 11-digit NDC <NA> #> 4 Drug NDC 11-digit NDC <NA> #> 5 Drug NDC 11-digit NDC <NA> #> 6 Drug NDC 11-digit NDC <NA> #> 7 Drug NDC 11-digit NDC <NA> #> 8 Drug NDC 11-digit NDC <NA> #> 9 Drug NDC 11-digit NDC <NA> #> 10 Drug NDC 11-digit NDC <NA> #> 11 Drug NDC 11-digit NDC <NA> #> 12 Drug NDC 11-digit NDC <NA> #> 13 Drug NDC 11-digit NDC <NA> #> 14 Drug NDC 11-digit NDC <NA> #> 15 Drug NDC 11-digit NDC <NA> #> 16 Drug NDC 11-digit NDC <NA> #> 17 Drug NDC 11-digit NDC <NA> #> 18 Drug NDC 11-digit NDC <NA> #> 19 Drug NDC 11-digit NDC <NA> #> 20 Drug NDC 11-digit NDC <NA> #> 21 Drug NDC 11-digit NDC <NA> #> 22 Drug NDC 11-digit NDC <NA> #> 23 Drug NDC 11-digit NDC <NA> #> 24 Drug NDC 11-digit NDC <NA> #> 25 Drug NDC 11-digit NDC <NA> #> 26 Drug NDC 11-digit NDC <NA> #> 27 Drug NDC 11-digit NDC <NA> #> 28 Drug NDC 11-digit NDC <NA> #> 29 Drug SPL OTC Drug C #> 30 Drug NDC 11-digit NDC <NA> #> 31 Drug NDC 11-digit NDC <NA> #> 32 Drug NDC 11-digit NDC <NA> #> 33 Drug NDC 11-digit NDC <NA> #> 34 Drug NDC 11-digit NDC <NA> #> 35 Drug NDC 11-digit NDC <NA> #> 36 Drug NDC 11-digit NDC <NA> #> 37 Drug NDC 11-digit NDC <NA> #> 38 Drug NDC 11-digit NDC <NA> #> 39 Drug NDC 11-digit NDC <NA> #> 40 Drug NDC 11-digit NDC <NA> #> 41 Drug NDC 11-digit NDC <NA> #> 42 Drug NDC 11-digit NDC <NA> #> 43 Drug NDC 11-digit NDC <NA> #> 44 Drug NDC 11-digit NDC <NA> #> 45 Drug NDC 11-digit NDC <NA> #> 46 Drug NDC 11-digit NDC <NA> #> 47 Drug NDC 11-digit NDC <NA> #> 48 Drug NDC 11-digit NDC <NA> #> 49 Drug NDC 11-digit NDC <NA> #> 50 Drug NDC 11-digit NDC <NA> #> 51 Drug NDC 11-digit NDC <NA> #> 52 Drug NDC 11-digit NDC <NA> #> 53 Drug NDC 11-digit NDC <NA> #> 54 Drug NDC 11-digit NDC <NA> #> 55 Drug NDC 11-digit NDC <NA> #> 56 Drug NDC 11-digit NDC <NA> #> 57 Drug NDC 11-digit NDC <NA> #> 58 Drug NDC 11-digit NDC <NA> #> 59 Drug NDC 11-digit NDC <NA> #> 60 Drug NDC 11-digit NDC <NA> #> 61 Drug NDC 11-digit NDC <NA> #> 62 Drug NDC 11-digit NDC <NA> #> 63 Drug NDC 11-digit NDC <NA> #> 64 Drug NDC 11-digit NDC <NA> #> 65 Drug NDC 11-digit NDC <NA> #> 66 Drug NDC 11-digit NDC <NA> #> 67 Drug NDC 11-digit NDC <NA> #> 68 Drug NDC 11-digit NDC <NA> #> 69 Drug NDC 11-digit NDC <NA> #> 70 Drug NDC 11-digit NDC <NA> #> 71 Drug NDC 11-digit NDC <NA> #> 72 Drug NDC 11-digit NDC <NA> #> 73 Drug NDC 11-digit NDC <NA> #> 74 Drug NDC 11-digit NDC <NA> #> 75 Drug NDC 11-digit NDC <NA> #> 76 Drug NDC 11-digit NDC <NA> #> concept_code valid_start_date valid_end_date #> 1 86142006 2002-01-31 2099-12-31 #> 2 33992302901 2019-01-01 2099-12-31 #> 3 33992303101 2019-01-01 2099-12-31 #> 4 33992303201 2019-01-01 2099-12-31 #> 5 58503010801 2019-01-01 2099-12-31 #> 6 58503011001 2019-01-01 2099-12-31 #> 7 11084002727 2020-03-01 2099-12-31 #> 8 50302000200 2020-03-01 2099-12-31 #> 9 50302000300 2020-03-01 2099-12-31 #> 10 74446033402 2021-04-01 2099-12-31 #> 11 81309000501 2021-04-01 2099-12-31 #> 12 81309000502 2021-04-01 2099-12-31 #> 13 81309000503 2021-04-01 2099-12-31 #> 14 81309000504 2021-04-01 2099-12-31 #> 15 81309000505 2021-04-01 2099-12-31 #> 16 81309000506 2021-04-01 2099-12-31 #> 17 81309000507 2021-04-01 2099-12-31 #> 18 81309000508 2021-04-01 2099-12-31 #> 19 81309000509 2021-04-01 2099-12-31 #> 20 80269010212 2021-04-01 2099-12-31 #> 21 80269010218 2021-04-01 2099-12-31 #> 22 80269010291 2021-04-01 2099-12-31 #> 23 79821000201 2021-04-01 2099-12-31 #> 24 79821000301 2021-04-01 2099-12-31 #> 25 79821000401 2021-04-01 2099-12-31 #> 26 79821000402 2021-04-01 2099-12-31 #> 27 79821000501 2021-04-01 2099-12-31 #> 28 79821000601 2021-04-01 2099-12-31 #> 29 c7a2c97a-8fa7-463b-b024-b199bc7cf469 2019-05-13 2099-12-31 #> 30 00096051104 2021-03-01 2099-12-31 #> 31 50066060902 2021-04-01 2099-12-31 #> 32 76605011901 2021-04-01 2099-12-31 #> 33 63374032301 2021-04-01 2099-12-31 #> 34 75682060001 2021-04-01 2099-12-31 #> 35 75682060002 2021-04-01 2099-12-31 #> 36 75682060004 2021-04-01 2099-12-31 #> 37 75682060008 2021-04-01 2099-12-31 #> 38 75682060016 2021-04-01 2099-12-31 #> 39 75682060025 2021-04-01 2099-12-31 #> 40 75682060032 2021-04-01 2099-12-31 #> 41 75682060055 2021-04-01 2099-12-31 #> 42 75682060064 2021-04-01 2099-12-31 #> 43 80457000201 2021-04-01 2099-12-31 #> 44 80457000301 2021-04-01 2099-12-31 #> 45 80457000401 2021-04-01 2099-12-31 #> 46 80457000501 2021-04-01 2099-12-31 #> 47 80457000601 2021-04-01 2099-12-31 #> 48 80457000701 2021-04-01 2099-12-31 #> 49 80457000801 2021-04-01 2099-12-31 #> 50 80607092101 2021-04-01 2099-12-31 #> 51 80607092102 2021-04-01 2099-12-31 #> 52 80607092103 2021-04-01 2099-12-31 #> 53 80607092104 2021-04-01 2099-12-31 #> 54 80607092105 2021-04-01 2099-12-31 #> 55 81432000101 2021-04-01 2099-12-31 #> 56 81432000201 2021-04-01 2099-12-31 #> 57 81432000301 2021-04-01 2099-12-31 #> 58 81517010101 2021-04-01 2099-12-31 #> 59 81349000001 2021-04-01 2099-12-31 #> 60 81349000002 2021-04-01 2099-12-31 #> 61 64942183801 2021-04-01 2099-12-31 #> 62 64942184101 2021-04-01 2099-12-31 #> 63 64942184401 2021-04-01 2099-12-31 #> 64 64942184001 2021-04-01 2099-12-31 #> 65 64942183901 2021-04-01 2099-12-31 #> 66 64942184201 2021-04-01 2099-12-31 #> 67 75742000801 2021-04-01 2099-12-31 #> 68 75742000802 2021-04-01 2099-12-31 #> 69 75742000803 2021-04-01 2099-12-31 #> 70 75742000804 2021-04-01 2099-12-31 #> 71 75742000805 2021-04-01 2099-12-31 #> 72 75742000806 2021-04-01 2099-12-31 #> 73 75742000807 2021-04-01 2099-12-31 #> 74 81639010112 2021-04-01 2099-12-31 #> 75 81639010116 2021-04-01 2099-12-31 #> 76 65692206301 2021-04-01 2099-12-31 #> invalid_reason #> 1 <NA> #> 2 <NA> #> 3 <NA> #> 4 <NA> #> 5 <NA> #> 6 <NA> #> 7 <NA> #> 8 <NA> #> 9 <NA> #> 10 <NA> #> 11 <NA> #> 12 <NA> #> 13 <NA> #> 14 <NA> #> 15 <NA> #> 16 <NA> #> 17 <NA> #> 18 <NA> #> 19 <NA> #> 20 <NA> #> 21 <NA> #> 22 <NA> #> 23 <NA> #> 24 <NA> #> 25 <NA> #> 26 <NA> #> 27 <NA> #> 28 <NA> #> 29 <NA> #> 30 <NA> #> 31 <NA> #> 32 <NA> #> 33 <NA> #> 34 <NA> #> 35 <NA> #> 36 <NA> #> 37 <NA> #> 38 <NA> #> 39 <NA> #> 40 <NA> #> 41 <NA> #> 42 <NA> #> 43 <NA> #> 44 <NA> #> 45 <NA> #> 46 <NA> #> 47 <NA> #> 48 <NA> #> 49 <NA> #> 50 <NA> #> 51 <NA> #> 52 <NA> #> 53 <NA> #> 54 <NA> #> 55 <NA> #> 56 <NA> #> 57 <NA> #> 58 <NA> #> 59 <NA> #> 60 <NA> #> 61 <NA> #> 62 <NA> #> 63 <NA> #> 64 <NA> #> 65 <NA> #> 66 <NA> #> 67 <NA> #> 68 <NA> #> 69 <NA> #> 70 <NA> #> 71 <NA> #> 72 <NA> #> 73 <NA> #> 74 <NA> #> 75 <NA> #> 76 <NA> #> [ reached 'max' / getOption("max.print") -- omitted 8830 rows ]# Join on the `concept_synonym_name` field in the Concept Synonym table join_on_concept_synonym_name( conn = conn, data = test_data, column = "test_concept_name" )#> [2021-05-26 16:06:59] Target column: test_concept_name #> [2021-05-26 16:06:59] Dropping patelm9.V20210526160659... #> [2021-05-26 16:06:59] ✓ Open connection #> [2021-05-26 16:06:59] ✓ JDBC connection #> [2021-05-26 16:06:59] SQL: DROP TABLE IF EXISTS patelm9.V20210526160659; #> [2021-05-26 16:06:59] Sending... #> [2021-05-26 16:06:59] Sending...complete #> [2021-05-26 16:06:59] Dropping patelm9.V20210526160659...complete #> [2021-05-26 16:06:59] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:06:59] Writing patelm9.V20210526160659... #> [2021-05-26 16:06:59] Writing patelm9.V20210526160659...complete #> [2021-05-26 16:06:59] ✓ Open connection #> [2021-05-26 16:06:59] ✓ JDBC connection #> [2021-05-26 16:06:59] SQL: SELECT a.*, b.* FROM patelm9.V20210526160659 a LEFT JOIN omop_vocabulary.concept_synonym b ON a.test_concept_name = b.concept_synonym_name #> [2021-05-26 16:06:59] Querying... #> [2021-05-26 16:07:00] Querying...complete #> [2021-05-26 16:07:00] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:00] Dropping patelm9.V20210526160659... #> [2021-05-26 16:07:00] ✓ Open connection #> [2021-05-26 16:07:00] ✓ JDBC connection #> [2021-05-26 16:07:00] SQL: DROP TABLE IF EXISTS patelm9.V20210526160659; #> [2021-05-26 16:07:00] Sending... #> [2021-05-26 16:07:00] Sending...complete #> [2021-05-26 16:07:00] Dropping patelm9.V20210526160659...complete#> test_concept_id #> 1 21221431 #> 2 3106614 #> 3 3106614 #> 4 45095380 #> 5 41134095 #> 6 43217420 #> 7 42918353 #> 8 21453274 #> 9 41264590 #> 10 36711737 #> 11 3580563 #> 12 43869022 #> 13 4110027 #> 14 37293276 #> 15 41261741 #> 16 4100962 #> 17 2749194 #> 18 822160 #> 19 37052466 #> 20 36274507 #> 21 36879604 #> test_concept_name #> 1 Piroxicam 20mg capsules #> 2 Pemphigoid #> 3 Pemphigoid #> 4 Ascorbic Acid 100 MG / Biotin 0.15 MG / Cholecalciferol 1750 UNT / Folic Acid 1 MG / Niacin 20 MG / Pantothenic Acid 5 MG / pyridoxine 10 MG / Riboflavin 1.7 MG / Thiamine 1.5 MG / Vitamin B 12 0.006 MG Disintegrating Tablet [Nephrocaps QT] #> 5 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 6 Cefuroxime 250 MG [CEFUROXIME ACTAVIS] #> 7 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 8 Haddenham Veni class 1 (18-21mmHg) tights open toe lymphoedema garment extra wide short size V #> 9 topiramate 50 MG [Topiramat Basics] #> 10 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 11 Zadstat 200mg tablet #> 12 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 13 Chronic infective rhinitis #> 14 ethanol 0.7 ML/ML Topical Gel #> 15 Cetirizine 10 MG Extended Release Oral Tablet [Zyrtec] Box of 100 by Diaprax #> 16 Megaloblastic anemia due to impaired absorption of folate #> 17 Removal of Intraluminal Device from Larynx, External Approach #> 18 titanium dioxide and zinc oxide 35mg/mL / 45.5mg/mL TOPICAL LIQUID [sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen deep, sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen light, sugar r... #> 19 Neoplastic cells/100 leukocytes #> 20 Bisoprolol 5 MG / Hydrochlorothiazide 12.5 MG [BISOPROLOL/HYDROCHLOROTHIAZIDE TEVA] #> 21 LEVOMENTHOL 0.1 MG/MG #> test_concept_code concept_id concept_synonym_name #> 1 13244211000001106 4220722 Piroxicam 20mg capsules #> 2 156356009 4344526 Pemphigoid #> 3 156356009 45614435 Pemphigoid #> 4 00256023302 NA <NA> #> 5 OMOP2332057 NA <NA> #> 6 OMOP498261 NA <NA> #> 7 OMOP4645243 NA <NA> #> 8 26196011000001108 NA <NA> #> 9 OMOP2462552 NA <NA> #> 10 33842011000001103 NA <NA> #> 11 408001000001109 NA <NA> #> 12 OMOP820089 NA <NA> #> 13 195770009 NA <NA> #> 14 78072050047 NA <NA> #> 15 OMOP2459703 NA <NA> #> 16 27798002 NA <NA> #> 17 0CPSXDZ NA <NA> #> 18 c7a2c97a-8fa7-463b-b024-b199bc7cf469 NA <NA> #> 19 LP286639-2 NA <NA> #> 20 OMOP3125382 NA <NA> #> 21 OMOP992836 NA <NA> #> language_concept_id #> 1 4180186 #> 2 4180186 #> 3 4180186 #> 4 NA #> 5 NA #> 6 NA #> 7 NA #> 8 NA #> 9 NA #> 10 NA #> 11 NA #> 12 NA #> 13 NA #> 14 NA #> 15 NA #> 16 NA #> 17 NA #> 18 NA #> 19 NA #> 20 NA #> 21 NA# Reconfigure the kind of join join_on_concept_synonym_name( conn = conn, data = test_data, column = "test_concept_name", kind = "INNER" )#> [2021-05-26 16:07:00] Target column: test_concept_name #> [2021-05-26 16:07:00] Dropping patelm9.V20210526160700... #> [2021-05-26 16:07:00] ✓ Open connection #> [2021-05-26 16:07:00] ✓ JDBC connection #> [2021-05-26 16:07:00] SQL: DROP TABLE IF EXISTS patelm9.V20210526160700; #> [2021-05-26 16:07:00] Sending... #> [2021-05-26 16:07:00] Sending...complete #> [2021-05-26 16:07:00] Dropping patelm9.V20210526160700...complete #> [2021-05-26 16:07:00] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:00] Writing patelm9.V20210526160700... #> [2021-05-26 16:07:00] Writing patelm9.V20210526160700...complete #> [2021-05-26 16:07:00] ✓ Open connection #> [2021-05-26 16:07:00] ✓ JDBC connection #> [2021-05-26 16:07:00] SQL: SELECT a.*, b.* FROM patelm9.V20210526160700 a INNER JOIN omop_vocabulary.concept_synonym b ON a.test_concept_name = b.concept_synonym_name #> [2021-05-26 16:07:00] Querying... #> [2021-05-26 16:07:01] Querying...complete #> [2021-05-26 16:07:01] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:01] Dropping patelm9.V20210526160700... #> [2021-05-26 16:07:01] ✓ Open connection #> [2021-05-26 16:07:01] ✓ JDBC connection #> [2021-05-26 16:07:01] SQL: DROP TABLE IF EXISTS patelm9.V20210526160700; #> [2021-05-26 16:07:01] Sending... #> [2021-05-26 16:07:01] Sending...complete #> [2021-05-26 16:07:01] Dropping patelm9.V20210526160700...complete#> test_concept_id test_concept_name test_concept_code concept_id #> 1 21221431 Piroxicam 20mg capsules 13244211000001106 4220722 #> 2 3106614 Pemphigoid 156356009 4344526 #> 3 3106614 Pemphigoid 156356009 45614435 #> concept_synonym_name language_concept_id #> 1 Piroxicam 20mg capsules 4180186 #> 2 Pemphigoid 4180186 #> 3 Pemphigoid 4180186# Return only distinct rows join_on_concept_synonym_name( conn = conn, data = test_data, column = "test_concept_name", kind = "INNER", distinct = TRUE )#> [2021-05-26 16:07:01] Target column: test_concept_name #> [2021-05-26 16:07:01] Dropping patelm9.V20210526160701... #> [2021-05-26 16:07:01] ✓ Open connection #> [2021-05-26 16:07:01] ✓ JDBC connection #> [2021-05-26 16:07:01] SQL: DROP TABLE IF EXISTS patelm9.V20210526160701; #> [2021-05-26 16:07:01] Sending... #> [2021-05-26 16:07:01] Sending...complete #> [2021-05-26 16:07:01] Dropping patelm9.V20210526160701...complete #> [2021-05-26 16:07:01] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:01] Writing patelm9.V20210526160701... #> [2021-05-26 16:07:02] Writing patelm9.V20210526160701...complete #> [2021-05-26 16:07:02] ✓ Open connection #> [2021-05-26 16:07:02] ✓ JDBC connection #> [2021-05-26 16:07:02] SQL: SELECT DISTINCT a.*, b.* FROM patelm9.V20210526160701 a INNER JOIN omop_vocabulary.concept_synonym b ON a.test_concept_name = b.concept_synonym_name #> [2021-05-26 16:07:02] Querying... #> [2021-05-26 16:07:02] Querying...complete #> [2021-05-26 16:07:02] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:02] Dropping patelm9.V20210526160701... #> [2021-05-26 16:07:02] ✓ Open connection #> [2021-05-26 16:07:02] ✓ JDBC connection #> [2021-05-26 16:07:02] SQL: DROP TABLE IF EXISTS patelm9.V20210526160701; #> [2021-05-26 16:07:02] Sending... #> [2021-05-26 16:07:02] Sending...complete #> [2021-05-26 16:07:02] Dropping patelm9.V20210526160701...complete#> test_concept_id test_concept_name test_concept_code concept_id #> 1 3106614 Pemphigoid 156356009 4344526 #> 2 3106614 Pemphigoid 156356009 45614435 #> 3 21221431 Piroxicam 20mg capsules 13244211000001106 4220722 #> concept_synonym_name language_concept_id #> 1 Pemphigoid 4180186 #> 2 Pemphigoid 4180186 #> 3 Piroxicam 20mg capsules 4180186# Return only the `test_concept_code` column join_on_concept_synonym_name( conn = conn, data = test_data, column = "test_concept_name", kind = "INNER", distinct = TRUE, select_data_columns = "test_concept_name" )#> [2021-05-26 16:07:02] Target column: test_concept_name #> [2021-05-26 16:07:02] Dropping patelm9.V20210526160702... #> [2021-05-26 16:07:02] ✓ Open connection #> [2021-05-26 16:07:02] ✓ JDBC connection #> [2021-05-26 16:07:02] SQL: DROP TABLE IF EXISTS patelm9.V20210526160702; #> [2021-05-26 16:07:02] Sending... #> [2021-05-26 16:07:02] Sending...complete #> [2021-05-26 16:07:02] Dropping patelm9.V20210526160702...complete #> [2021-05-26 16:07:02] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:02] Writing patelm9.V20210526160702... #> [2021-05-26 16:07:03] Writing patelm9.V20210526160702...complete #> [2021-05-26 16:07:03] ✓ Open connection #> [2021-05-26 16:07:03] ✓ JDBC connection #> [2021-05-26 16:07:03] SQL: SELECT DISTINCT a.test_concept_name, b.* FROM patelm9.V20210526160702 a INNER JOIN omop_vocabulary.concept_synonym b ON a.test_concept_name = b.concept_synonym_name #> [2021-05-26 16:07:03] Querying... #> [2021-05-26 16:07:03] Querying...complete #> [2021-05-26 16:07:03] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:03] Dropping patelm9.V20210526160702... #> [2021-05-26 16:07:03] ✓ Open connection #> [2021-05-26 16:07:03] ✓ JDBC connection #> [2021-05-26 16:07:04] SQL: DROP TABLE IF EXISTS patelm9.V20210526160702; #> [2021-05-26 16:07:04] Sending... #> [2021-05-26 16:07:04] Sending...complete #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160702...complete#> test_concept_name concept_id concept_synonym_name #> 1 Pemphigoid 4344526 Pemphigoid #> 2 Pemphigoid 45614435 Pemphigoid #> 3 Piroxicam 20mg capsules 4220722 Piroxicam 20mg capsules #> language_concept_id #> 1 4180186 #> 2 4180186 #> 3 4180186# Filter can be applied to the vocabulary tables join_on_concept_synonym_name( conn = conn, data = test_data, column = "test_concept_name", where_not_in_concept_synonym_field = "language_concept_id", where_not_in_concept_synonym_field_value = 4180186 )#> [2021-05-26 16:07:04] Target column: test_concept_name #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704... #> [2021-05-26 16:07:04] ✓ Open connection #> [2021-05-26 16:07:04] ✓ JDBC connection #> [2021-05-26 16:07:04] SQL: DROP TABLE IF EXISTS patelm9.V20210526160704; #> [2021-05-26 16:07:04] Sending... #> [2021-05-26 16:07:04] Sending...complete #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704...complete #> [2021-05-26 16:07:04] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:04] Writing patelm9.V20210526160704... #> [2021-05-26 16:07:04] Writing patelm9.V20210526160704...complete #> [2021-05-26 16:07:04] ✓ Open connection #> [2021-05-26 16:07:04] ✓ JDBC connection #> [2021-05-26 16:07:04] SQL: SELECT a.*, b.* FROM patelm9.V20210526160704 a LEFT JOIN omop_vocabulary.concept_synonym b ON a.test_concept_name = b.concept_synonym_name WHERE b.language_concept_id NOT IN (4180186) #> [2021-05-26 16:07:04] Querying... #> [2021-05-26 16:07:04] Querying...complete #> [2021-05-26 16:07:04] ! Returned data has 0 rows #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704... #> [2021-05-26 16:07:04] ✓ Open connection #> [2021-05-26 16:07:04] ✓ JDBC connection #> [2021-05-26 16:07:04] SQL: DROP TABLE IF EXISTS patelm9.V20210526160704; #> [2021-05-26 16:07:04] Sending... #> [2021-05-26 16:07:04] Sending...complete #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704...complete#> [1] test_concept_id test_concept_name test_concept_code #> [4] concept_id concept_synonym_name language_concept_id #> <0 rows> (or 0-length row.names)# `Join For` functions join on a predetermined vocabulary field for the addition # of the specified column in the source data # Get all the synonyms for a concept by concept_id join_for_concept_synonym_name( conn = conn, data = test_data, concept_id_column = "test_concept_id" )#> [2021-05-26 16:07:04] Target column: test_concept_id #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704... #> [2021-05-26 16:07:04] ✓ Open connection #> [2021-05-26 16:07:04] ✓ JDBC connection #> [2021-05-26 16:07:04] SQL: DROP TABLE IF EXISTS patelm9.V20210526160704; #> [2021-05-26 16:07:04] Sending... #> [2021-05-26 16:07:04] Sending...complete #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704...complete #> [2021-05-26 16:07:04] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:04] Writing patelm9.V20210526160704... #> [2021-05-26 16:07:04] Writing patelm9.V20210526160704...complete #> [2021-05-26 16:07:04] ✓ Open connection #> [2021-05-26 16:07:04] ✓ JDBC connection #> [2021-05-26 16:07:04] SQL: SELECT a.*, b.concept_id,b.concept_synonym_name FROM patelm9.V20210526160704 a LEFT JOIN omop_vocabulary.concept_synonym b ON a.test_concept_id = b.concept_id WHERE b.language_concept_id IN (4180186) #> [2021-05-26 16:07:04] Querying... #> [2021-05-26 16:07:04] Querying...complete #> [2021-05-26 16:07:04] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704... #> [2021-05-26 16:07:04] ✓ Open connection #> [2021-05-26 16:07:04] ✓ JDBC connection #> [2021-05-26 16:07:04] SQL: DROP TABLE IF EXISTS patelm9.V20210526160704; #> [2021-05-26 16:07:04] Sending... #> [2021-05-26 16:07:04] Sending...complete #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704...complete#> test_concept_id #> 1 822160 #> 2 4100962 #> 3 4100962 #> 4 2749194 #> 5 2749194 #> 6 36711737 #> 7 4110027 #> test_concept_name #> 1 titanium dioxide and zinc oxide 35mg/mL / 45.5mg/mL TOPICAL LIQUID [sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen deep, sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen light, sugar r... #> 2 Megaloblastic anemia due to impaired absorption of folate #> 3 Megaloblastic anemia due to impaired absorption of folate #> 4 Removal of Intraluminal Device from Larynx, External Approach #> 5 Removal of Intraluminal Device from Larynx, External Approach #> 6 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 7 Chronic infective rhinitis #> test_concept_code concept_id #> 1 c7a2c97a-8fa7-463b-b024-b199bc7cf469 822160 #> 2 27798002 4100962 #> 3 27798002 4100962 #> 4 0CPSXDZ 2749194 #> 5 0CPSXDZ 2749194 #> 6 33842011000001103 36711737 #> 7 195770009 4110027 #> concept_synonym_name #> 1 titanium dioxide and zinc oxide 35mg/mL / 45.5mg/mL TOPICAL LIQUID [sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen deep, sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen light, sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sun...] #> 2 Megaloblastic anaemia due to impaired absorption of folate #> 3 Megaloblastic anemia due to impaired absorption of folate (disorder) #> 4 Medical and Surgical @ Mouth and Throat @ Removal @ Larynx @ External @ Intraluminal Device @ No Qualifier #> 5 Removal of Intraluminal Device from Larynx, Extern Approach #> 6 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device (physical object) #> 7 Chronic infective rhinitis (disorder)# Get the descendant concept ids join_for_descendant_ids( conn = conn, data = test_data, ancestor_id_column = "test_concept_id" )#> [2021-05-26 16:07:04] Target column: test_concept_id #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704... #> [2021-05-26 16:07:04] ✓ Open connection #> [2021-05-26 16:07:04] ✓ JDBC connection #> [2021-05-26 16:07:04] SQL: DROP TABLE IF EXISTS patelm9.V20210526160704; #> [2021-05-26 16:07:04] Sending... #> [2021-05-26 16:07:04] Sending...complete #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704...complete #> [2021-05-26 16:07:04] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:04] Writing patelm9.V20210526160704... #> [2021-05-26 16:07:04] Writing patelm9.V20210526160704...complete #> [2021-05-26 16:07:04] ✓ Open connection #> [2021-05-26 16:07:04] ✓ JDBC connection #> [2021-05-26 16:07:04] SQL: SELECT a.*, b.descendant_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160704 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.test_concept_id = b.ancestor_concept_id #> [2021-05-26 16:07:04] Querying... #> [2021-05-26 16:07:04] Querying...complete #> [2021-05-26 16:07:04] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704... #> [2021-05-26 16:07:04] ✓ Open connection #> [2021-05-26 16:07:04] ✓ JDBC connection #> [2021-05-26 16:07:04] SQL: DROP TABLE IF EXISTS patelm9.V20210526160704; #> [2021-05-26 16:07:04] Sending... #> [2021-05-26 16:07:04] Sending...complete #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704...complete#> test_concept_id #> 1 822160 #> 2 41264590 #> 3 41264590 #> 4 41264590 #> 5 41264590 #> 6 41264590 #> 7 41264590 #> 8 41264590 #> 9 41264590 #> 10 41264590 #> 11 21453274 #> 12 4100962 #> 13 4100962 #> 14 4100962 #> 15 4100962 #> 16 4100962 #> 17 21221431 #> 18 37293276 #> 19 2749194 #> 20 42918353 #> 21 43869022 #> 22 36711737 #> 23 45095380 #> 24 36879604 #> 25 36879604 #> 26 36879604 #> 27 36879604 #> 28 36879604 #> 29 36879604 #> 30 36879604 #> 31 36879604 #> 32 36879604 #> 33 36879604 #> 34 36879604 #> 35 36879604 #> 36 36879604 #> 37 36879604 #> 38 36879604 #> 39 36879604 #> 40 36879604 #> 41 36879604 #> 42 36879604 #> 43 36879604 #> 44 36879604 #> 45 36879604 #> 46 36879604 #> 47 36879604 #> 48 36879604 #> 49 36879604 #> 50 36879604 #> 51 36879604 #> 52 36879604 #> 53 36879604 #> 54 36879604 #> 55 36879604 #> 56 36879604 #> 57 36879604 #> 58 36879604 #> 59 36879604 #> 60 36879604 #> 61 36879604 #> 62 36879604 #> 63 3580563 #> 64 41134095 #> 65 3106614 #> 66 36274507 #> 67 36274507 #> 68 36274507 #> 69 36274507 #> 70 43217420 #> 71 43217420 #> 72 43217420 #> 73 43217420 #> 74 37052466 #> 75 41261741 #> 76 4110027 #> test_concept_name #> 1 titanium dioxide and zinc oxide 35mg/mL / 45.5mg/mL TOPICAL LIQUID [sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen deep, sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen light, sugar r... #> 2 topiramate 50 MG [Topiramat Basics] #> 3 topiramate 50 MG [Topiramat Basics] #> 4 topiramate 50 MG [Topiramat Basics] #> 5 topiramate 50 MG [Topiramat Basics] #> 6 topiramate 50 MG [Topiramat Basics] #> 7 topiramate 50 MG [Topiramat Basics] #> 8 topiramate 50 MG [Topiramat Basics] #> 9 topiramate 50 MG [Topiramat Basics] #> 10 topiramate 50 MG [Topiramat Basics] #> 11 Haddenham Veni class 1 (18-21mmHg) tights open toe lymphoedema garment extra wide short size V #> 12 Megaloblastic anemia due to impaired absorption of folate #> 13 Megaloblastic anemia due to impaired absorption of folate #> 14 Megaloblastic anemia due to impaired absorption of folate #> 15 Megaloblastic anemia due to impaired absorption of folate #> 16 Megaloblastic anemia due to impaired absorption of folate #> 17 Piroxicam 20mg capsules #> 18 ethanol 0.7 ML/ML Topical Gel #> 19 Removal of Intraluminal Device from Larynx, External Approach #> 20 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 21 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 22 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 23 Ascorbic Acid 100 MG / Biotin 0.15 MG / Cholecalciferol 1750 UNT / Folic Acid 1 MG / Niacin 20 MG / Pantothenic Acid 5 MG / pyridoxine 10 MG / Riboflavin 1.7 MG / Thiamine 1.5 MG / Vitamin B 12 0.006 MG Disintegrating Tablet [Nephrocaps QT] #> 24 LEVOMENTHOL 0.1 MG/MG #> 25 LEVOMENTHOL 0.1 MG/MG #> 26 LEVOMENTHOL 0.1 MG/MG #> 27 LEVOMENTHOL 0.1 MG/MG #> 28 LEVOMENTHOL 0.1 MG/MG #> 29 LEVOMENTHOL 0.1 MG/MG #> 30 LEVOMENTHOL 0.1 MG/MG #> 31 LEVOMENTHOL 0.1 MG/MG #> 32 LEVOMENTHOL 0.1 MG/MG #> 33 LEVOMENTHOL 0.1 MG/MG #> 34 LEVOMENTHOL 0.1 MG/MG #> 35 LEVOMENTHOL 0.1 MG/MG #> 36 LEVOMENTHOL 0.1 MG/MG #> 37 LEVOMENTHOL 0.1 MG/MG #> 38 LEVOMENTHOL 0.1 MG/MG #> 39 LEVOMENTHOL 0.1 MG/MG #> 40 LEVOMENTHOL 0.1 MG/MG #> 41 LEVOMENTHOL 0.1 MG/MG #> 42 LEVOMENTHOL 0.1 MG/MG #> 43 LEVOMENTHOL 0.1 MG/MG #> 44 LEVOMENTHOL 0.1 MG/MG #> 45 LEVOMENTHOL 0.1 MG/MG #> 46 LEVOMENTHOL 0.1 MG/MG #> 47 LEVOMENTHOL 0.1 MG/MG #> 48 LEVOMENTHOL 0.1 MG/MG #> 49 LEVOMENTHOL 0.1 MG/MG #> 50 LEVOMENTHOL 0.1 MG/MG #> 51 LEVOMENTHOL 0.1 MG/MG #> 52 LEVOMENTHOL 0.1 MG/MG #> 53 LEVOMENTHOL 0.1 MG/MG #> 54 LEVOMENTHOL 0.1 MG/MG #> 55 LEVOMENTHOL 0.1 MG/MG #> 56 LEVOMENTHOL 0.1 MG/MG #> 57 LEVOMENTHOL 0.1 MG/MG #> 58 LEVOMENTHOL 0.1 MG/MG #> 59 LEVOMENTHOL 0.1 MG/MG #> 60 LEVOMENTHOL 0.1 MG/MG #> 61 LEVOMENTHOL 0.1 MG/MG #> 62 LEVOMENTHOL 0.1 MG/MG #> 63 Zadstat 200mg tablet #> 64 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 65 Pemphigoid #> 66 Bisoprolol 5 MG / Hydrochlorothiazide 12.5 MG [BISOPROLOL/HYDROCHLOROTHIAZIDE TEVA] #> 67 Bisoprolol 5 MG / Hydrochlorothiazide 12.5 MG [BISOPROLOL/HYDROCHLOROTHIAZIDE TEVA] #> 68 Bisoprolol 5 MG / Hydrochlorothiazide 12.5 MG [BISOPROLOL/HYDROCHLOROTHIAZIDE TEVA] #> 69 Bisoprolol 5 MG / Hydrochlorothiazide 12.5 MG [BISOPROLOL/HYDROCHLOROTHIAZIDE TEVA] #> 70 Cefuroxime 250 MG [CEFUROXIME ACTAVIS] #> 71 Cefuroxime 250 MG [CEFUROXIME ACTAVIS] #> 72 Cefuroxime 250 MG [CEFUROXIME ACTAVIS] #> 73 Cefuroxime 250 MG [CEFUROXIME ACTAVIS] #> 74 Neoplastic cells/100 leukocytes #> 75 Cetirizine 10 MG Extended Release Oral Tablet [Zyrtec] Box of 100 by Diaprax #> 76 Chronic infective rhinitis #> test_concept_code descendant_concept_id #> 1 c7a2c97a-8fa7-463b-b024-b199bc7cf469 822160 #> 2 OMOP2462552 40901821 #> 3 OMOP2462552 40839627 #> 4 OMOP2462552 41226154 #> 5 OMOP2462552 44170553 #> 6 OMOP2462552 44161617 #> 7 OMOP2462552 44169209 #> 8 OMOP2462552 40995481 #> 9 OMOP2462552 41288043 #> 10 OMOP2462552 41264590 #> 11 26196011000001108 NA #> 12 27798002 4282785 #> 13 27798002 4238731 #> 14 27798002 4338976 #> 15 27798002 4221567 #> 16 27798002 4100962 #> 17 13244211000001106 NA #> 18 78072050047 NA #> 19 0CPSXDZ 2749194 #> 20 OMOP4645243 42918353 #> 21 OMOP820089 43869022 #> 22 33842011000001103 36711737 #> 23 00256023302 NA #> 24 OMOP992836 36283195 #> 25 OMOP992836 42719097 #> 26 OMOP992836 43681771 #> 27 OMOP992836 36882084 #> 28 OMOP992836 40931000 #> 29 OMOP992836 41484176 #> 30 OMOP992836 40899902 #> 31 OMOP992836 36268143 #> 32 OMOP992836 43617433 #> 33 OMOP992836 43652691 #> 34 OMOP992836 36879604 #> 35 OMOP992836 43663961 #> 36 OMOP992836 43832558 #> 37 OMOP992836 41484179 #> 38 OMOP992836 43743517 #> 39 OMOP992836 36283197 #> 40 OMOP992836 41048040 #> 41 OMOP992836 41484196 #> 42 OMOP992836 43706507 #> 43 OMOP992836 43753020 #> 44 OMOP992836 41098762 #> 45 OMOP992836 42717260 #> 46 OMOP992836 43743525 #> 47 OMOP992836 41036021 #> 48 OMOP992836 43581420 #> 49 OMOP992836 41484198 #> 50 OMOP992836 42719464 #> 51 OMOP992836 43771604 #> 52 OMOP992836 36283166 #> 53 OMOP992836 43833539 #> 54 OMOP992836 43717517 #> 55 OMOP992836 43663373 #> 56 OMOP992836 43591145 #> 57 OMOP992836 43843760 #> 58 OMOP992836 42715897 #> 59 OMOP992836 42718155 #> 60 OMOP992836 36271886 #> 61 OMOP992836 36269924 #> 62 OMOP992836 43753560 #> 63 408001000001109 NA #> 64 OMOP2332057 41134095 #> 65 156356009 NA #> 66 OMOP3125382 36268400 #> 67 OMOP3125382 36265808 #> 68 OMOP3125382 36273742 #> 69 OMOP3125382 36274507 #> 70 OMOP498261 43217420 #> 71 OMOP498261 43206451 #> 72 OMOP498261 43217426 #> 73 OMOP498261 43206452 #> 74 LP286639-2 NA #> 75 OMOP2459703 41261741 #> 76 195770009 4110027 #> min_levels_of_separation max_levels_of_separation #> 1 0 0 #> 2 1 1 #> 3 2 2 #> 4 2 3 #> 5 2 3 #> 6 1 1 #> 7 2 2 #> 8 2 2 #> 9 2 3 #> 10 0 0 #> 11 NA NA #> 12 2 2 #> 13 1 1 #> 14 2 2 #> 15 1 1 #> 16 0 0 #> 17 NA NA #> 18 NA NA #> 19 0 0 #> 20 0 0 #> 21 0 0 #> 22 0 0 #> 23 NA NA #> 24 1 1 #> 25 0 0 #> 26 2 2 #> 27 1 1 #> 28 2 2 #> 29 1 1 #> 30 1 1 #> 31 1 1 #> 32 1 1 #> 33 2 2 #> 34 0 0 #> 35 2 2 #> 36 1 1 #> 37 2 2 #> 38 1 1 #> 39 2 2 #> 40 0 0 #> 41 2 2 #> 42 1 1 #> 43 1 1 #> 44 1 1 #> 45 2 2 #> 46 0 0 #> 47 2 2 #> 48 0 0 #> 49 1 1 #> 50 1 1 #> 51 1 1 #> 52 1 1 #> 53 1 1 #> 54 1 1 #> 55 2 2 #> 56 1 1 #> 57 1 1 #> 58 1 1 #> 59 2 2 #> 60 0 0 #> 61 1 1 #> 62 1 1 #> 63 NA NA #> 64 0 0 #> 65 NA NA #> 66 2 2 #> 67 1 1 #> 68 2 3 #> 69 0 0 #> 70 0 0 #> 71 1 1 #> 72 2 2 #> 73 2 3 #> 74 NA NA #> 75 0 0 #> 76 0 0# Get the ancestor concept ids join_for_ancestor_ids( conn = conn, data = test_data, descendant_id_column = "test_concept_id" )#> [2021-05-26 16:07:04] Target column: test_concept_id #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704... #> [2021-05-26 16:07:04] ✓ Open connection #> [2021-05-26 16:07:04] ✓ JDBC connection #> [2021-05-26 16:07:04] SQL: DROP TABLE IF EXISTS patelm9.V20210526160704; #> [2021-05-26 16:07:04] Sending... #> [2021-05-26 16:07:04] Sending...complete #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704...complete #> [2021-05-26 16:07:04] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:04] Writing patelm9.V20210526160704... #> [2021-05-26 16:07:04] Writing patelm9.V20210526160704...complete #> [2021-05-26 16:07:04] ✓ Open connection #> [2021-05-26 16:07:04] ✓ JDBC connection #> [2021-05-26 16:07:04] SQL: SELECT a.*, b.ancestor_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160704 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.test_concept_id = b.descendant_concept_id #> [2021-05-26 16:07:04] Querying... #> [2021-05-26 16:07:04] Querying...complete #> [2021-05-26 16:07:04] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704... #> [2021-05-26 16:07:04] ✓ Open connection #> [2021-05-26 16:07:04] ✓ JDBC connection #> [2021-05-26 16:07:04] SQL: DROP TABLE IF EXISTS patelm9.V20210526160704; #> [2021-05-26 16:07:04] Sending... #> [2021-05-26 16:07:04] Sending...complete #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704...complete#> test_concept_id #> 1 822160 #> 2 41264590 #> 3 41264590 #> 4 41264590 #> 5 41264590 #> 6 41264590 #> 7 41264590 #> 8 41264590 #> 9 41264590 #> 10 21453274 #> 11 4100962 #> 12 4100962 #> 13 4100962 #> 14 4100962 #> 15 4100962 #> 16 4100962 #> 17 4100962 #> 18 4100962 #> 19 4100962 #> 20 4100962 #> 21 4100962 #> 22 4100962 #> 23 4100962 #> 24 4100962 #> 25 4100962 #> 26 4100962 #> 27 4100962 #> 28 4100962 #> 29 4100962 #> 30 4100962 #> 31 4100962 #> 32 4100962 #> 33 4100962 #> 34 4100962 #> 35 4100962 #> 36 21221431 #> 37 37293276 #> 38 2749194 #> 39 2749194 #> 40 2749194 #> 41 2749194 #> 42 2749194 #> 43 2749194 #> 44 2749194 #> 45 2749194 #> 46 2749194 #> 47 2749194 #> 48 2749194 #> 49 2749194 #> 50 2749194 #> 51 2749194 #> 52 2749194 #> 53 2749194 #> 54 2749194 #> 55 2749194 #> 56 2749194 #> 57 2749194 #> 58 2749194 #> 59 2749194 #> 60 2749194 #> 61 2749194 #> 62 2749194 #> 63 2749194 #> 64 2749194 #> 65 2749194 #> 66 2749194 #> 67 2749194 #> 68 42918353 #> 69 42918353 #> 70 42918353 #> 71 42918353 #> 72 42918353 #> 73 42918353 #> 74 42918353 #> 75 42918353 #> 76 42918353 #> 77 42918353 #> 78 42918353 #> 79 42918353 #> 80 42918353 #> 81 42918353 #> 82 42918353 #> 83 42918353 #> 84 42918353 #> 85 42918353 #> 86 42918353 #> 87 42918353 #> 88 42918353 #> 89 42918353 #> 90 42918353 #> 91 42918353 #> 92 42918353 #> 93 42918353 #> 94 42918353 #> 95 42918353 #> 96 42918353 #> 97 42918353 #> 98 42918353 #> 99 42918353 #> 100 42918353 #> 101 42918353 #> 102 42918353 #> 103 42918353 #> 104 42918353 #> 105 42918353 #> 106 42918353 #> 107 42918353 #> 108 43869022 #> 109 43869022 #> 110 43869022 #> 111 43869022 #> 112 43869022 #> 113 43869022 #> 114 43869022 #> 115 43869022 #> 116 43869022 #> 117 43869022 #> 118 43869022 #> 119 43869022 #> 120 43869022 #> 121 43869022 #> 122 43869022 #> 123 43869022 #> 124 43869022 #> 125 43869022 #> 126 43869022 #> 127 43869022 #> 128 43869022 #> 129 43869022 #> 130 36711737 #> 131 36711737 #> 132 36711737 #> 133 36711737 #> 134 36711737 #> 135 36711737 #> 136 36711737 #> 137 45095380 #> 138 36879604 #> 139 36879604 #> 140 3580563 #> 141 41134095 #> 142 41134095 #> 143 41134095 #> 144 41134095 #> 145 41134095 #> 146 41134095 #> 147 41134095 #> 148 41134095 #> 149 41134095 #> 150 41134095 #> 151 41134095 #> 152 41134095 #> 153 41134095 #> 154 41134095 #> 155 41134095 #> 156 41134095 #> 157 41134095 #> 158 41134095 #> 159 41134095 #> 160 41134095 #> 161 41134095 #> 162 41134095 #> 163 41134095 #> 164 41134095 #> 165 41134095 #> 166 41134095 #> test_concept_name #> 1 titanium dioxide and zinc oxide 35mg/mL / 45.5mg/mL TOPICAL LIQUID [sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen deep, sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen light, sugar r... #> 2 topiramate 50 MG [Topiramat Basics] #> 3 topiramate 50 MG [Topiramat Basics] #> 4 topiramate 50 MG [Topiramat Basics] #> 5 topiramate 50 MG [Topiramat Basics] #> 6 topiramate 50 MG [Topiramat Basics] #> 7 topiramate 50 MG [Topiramat Basics] #> 8 topiramate 50 MG [Topiramat Basics] #> 9 topiramate 50 MG [Topiramat Basics] #> 10 Haddenham Veni class 1 (18-21mmHg) tights open toe lymphoedema garment extra wide short size V #> 11 Megaloblastic anemia due to impaired absorption of folate #> 12 Megaloblastic anemia due to impaired absorption of folate #> 13 Megaloblastic anemia due to impaired absorption of folate #> 14 Megaloblastic anemia due to impaired absorption of folate #> 15 Megaloblastic anemia due to impaired absorption of folate #> 16 Megaloblastic anemia due to impaired absorption of folate #> 17 Megaloblastic anemia due to impaired absorption of folate #> 18 Megaloblastic anemia due to impaired absorption of folate #> 19 Megaloblastic anemia due to impaired absorption of folate #> 20 Megaloblastic anemia due to impaired absorption of folate #> 21 Megaloblastic anemia due to impaired absorption of folate #> 22 Megaloblastic anemia due to impaired absorption of folate #> 23 Megaloblastic anemia due to impaired absorption of folate #> 24 Megaloblastic anemia due to impaired absorption of folate #> 25 Megaloblastic anemia due to impaired absorption of folate #> 26 Megaloblastic anemia due to impaired absorption of folate #> 27 Megaloblastic anemia due to impaired absorption of folate #> 28 Megaloblastic anemia due to impaired absorption of folate #> 29 Megaloblastic anemia due to impaired absorption of folate #> 30 Megaloblastic anemia due to impaired absorption of folate #> 31 Megaloblastic anemia due to impaired absorption of folate #> 32 Megaloblastic anemia due to impaired absorption of folate #> 33 Megaloblastic anemia due to impaired absorption of folate #> 34 Megaloblastic anemia due to impaired absorption of folate #> 35 Megaloblastic anemia due to impaired absorption of folate #> 36 Piroxicam 20mg capsules #> 37 ethanol 0.7 ML/ML Topical Gel #> 38 Removal of Intraluminal Device from Larynx, External Approach #> 39 Removal of Intraluminal Device from Larynx, External Approach #> 40 Removal of Intraluminal Device from Larynx, External Approach #> 41 Removal of Intraluminal Device from Larynx, External Approach #> 42 Removal of Intraluminal Device from Larynx, External Approach #> 43 Removal of Intraluminal Device from Larynx, External Approach #> 44 Removal of Intraluminal Device from Larynx, External Approach #> 45 Removal of Intraluminal Device from Larynx, External Approach #> 46 Removal of Intraluminal Device from Larynx, External Approach #> 47 Removal of Intraluminal Device from Larynx, External Approach #> 48 Removal of Intraluminal Device from Larynx, External Approach #> 49 Removal of Intraluminal Device from Larynx, External Approach #> 50 Removal of Intraluminal Device from Larynx, External Approach #> 51 Removal of Intraluminal Device from Larynx, External Approach #> 52 Removal of Intraluminal Device from Larynx, External Approach #> 53 Removal of Intraluminal Device from Larynx, External Approach #> 54 Removal of Intraluminal Device from Larynx, External Approach #> 55 Removal of Intraluminal Device from Larynx, External Approach #> 56 Removal of Intraluminal Device from Larynx, External Approach #> 57 Removal of Intraluminal Device from Larynx, External Approach #> 58 Removal of Intraluminal Device from Larynx, External Approach #> 59 Removal of Intraluminal Device from Larynx, External Approach #> 60 Removal of Intraluminal Device from Larynx, External Approach #> 61 Removal of Intraluminal Device from Larynx, External Approach #> 62 Removal of Intraluminal Device from Larynx, External Approach #> 63 Removal of Intraluminal Device from Larynx, External Approach #> 64 Removal of Intraluminal Device from Larynx, External Approach #> 65 Removal of Intraluminal Device from Larynx, External Approach #> 66 Removal of Intraluminal Device from Larynx, External Approach #> 67 Removal of Intraluminal Device from Larynx, External Approach #> 68 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 69 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 70 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 71 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 72 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 73 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 74 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 75 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 76 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 77 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 78 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 79 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 80 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 81 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 82 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 83 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 84 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 85 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 86 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 87 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 88 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 89 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 90 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 91 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 92 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 93 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 94 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 95 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 96 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 97 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 98 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 99 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 100 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 101 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 102 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 103 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 104 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 105 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 106 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 107 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 108 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 109 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 110 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 111 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 112 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 113 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 114 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 115 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 116 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 117 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 118 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 119 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 120 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 121 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 122 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 123 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 124 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 125 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 126 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 127 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 128 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 129 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 130 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 131 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 132 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 133 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 134 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 135 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 136 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 137 Ascorbic Acid 100 MG / Biotin 0.15 MG / Cholecalciferol 1750 UNT / Folic Acid 1 MG / Niacin 20 MG / Pantothenic Acid 5 MG / pyridoxine 10 MG / Riboflavin 1.7 MG / Thiamine 1.5 MG / Vitamin B 12 0.006 MG Disintegrating Tablet [Nephrocaps QT] #> 138 LEVOMENTHOL 0.1 MG/MG #> 139 LEVOMENTHOL 0.1 MG/MG #> 140 Zadstat 200mg tablet #> 141 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 142 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 143 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 144 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 145 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 146 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 147 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 148 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 149 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 150 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 151 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 152 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 153 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 154 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 155 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 156 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 157 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 158 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 159 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 160 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 161 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 162 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 163 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 164 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 165 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 166 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> test_concept_code ancestor_concept_id #> 1 c7a2c97a-8fa7-463b-b024-b199bc7cf469 822160 #> 2 OMOP2462552 742267 #> 3 OMOP2462552 742343 #> 4 OMOP2462552 21604180 #> 5 OMOP2462552 21604389 #> 6 OMOP2462552 21604390 #> 7 OMOP2462552 21604428 #> 8 OMOP2462552 21604433 #> 9 OMOP2462552 41264590 #> 10 26196011000001108 NA #> 11 27798002 435789 #> 12 27798002 439777 #> 13 27798002 440977 #> 14 27798002 441840 #> 15 27798002 443723 #> 16 27798002 4013074 #> 17 27798002 4013518 #> 18 27798002 4013842 #> 19 27798002 4021915 #> 20 27798002 4022198 #> 21 27798002 4041436 #> 22 27798002 4100962 #> 23 27798002 4179922 #> 24 27798002 4181204 #> 25 27798002 4267432 #> 26 27798002 4274025 #> 27 27798002 4276572 #> 28 27798002 4280354 #> 29 27798002 4308125 #> 30 27798002 37203927 #> 31 27798002 40480457 #> 32 27798002 40480513 #> 33 27798002 40481841 #> 34 27798002 40484533 #> 35 27798002 42538830 #> 36 13244211000001106 NA #> 37 78072050047 NA #> 38 0CPSXDZ 2749167 #> 39 0CPSXDZ 2749194 #> 40 0CPSXDZ 2799259 #> 41 0CPSXDZ 2801516 #> 42 0CPSXDZ 2860756 #> 43 0CPSXDZ 2889378 #> 44 0CPSXDZ 2897108 #> 45 0CPSXDZ 4029205 #> 46 0CPSXDZ 4040390 #> 47 0CPSXDZ 4040400 #> 48 0CPSXDZ 4040721 #> 49 0CPSXDZ 4042150 #> 50 0CPSXDZ 4042518 #> 51 0CPSXDZ 4043017 #> 52 0CPSXDZ 4043021 #> 53 0CPSXDZ 4043022 #> 54 0CPSXDZ 4043023 #> 55 0CPSXDZ 4046265 #> 56 0CPSXDZ 4046266 #> 57 0CPSXDZ 4047655 #> 58 0CPSXDZ 4134423 #> 59 0CPSXDZ 4142040 #> 60 0CPSXDZ 4180627 #> 61 0CPSXDZ 4180941 #> 62 0CPSXDZ 4304477 #> 63 0CPSXDZ 4306074 #> 64 0CPSXDZ 4322976 #> 65 0CPSXDZ 36675054 #> 66 0CPSXDZ 40486576 #> 67 0CPSXDZ 43531532 #> 68 OMOP4645243 1560524 #> 69 OMOP4645243 1560651 #> 70 OMOP4645243 19076324 #> 71 OMOP4645243 21089160 #> 72 OMOP4645243 21605212 #> 73 OMOP4645243 21605342 #> 74 OMOP4645243 21605348 #> 75 OMOP4645243 21605351 #> 76 OMOP4645243 21605352 #> 77 OMOP4645243 36217210 #> 78 OMOP4645243 36221206 #> 79 OMOP4645243 40045801 #> 80 OMOP4645243 42918353 #> 81 OMOP4645243 42937940 #> 82 OMOP4645243 42937945 #> 83 OMOP4645243 42937968 #> 84 OMOP4645243 45627478 #> 85 OMOP4645243 45631086 #> 86 OMOP4645243 45644500 #> 87 OMOP4645243 45659765 #> 88 OMOP4645243 45661333 #> 89 OMOP4645243 45671539 #> 90 OMOP4645243 45675819 #> 91 OMOP4645243 45676555 #> 92 OMOP4645243 45680874 #> 93 OMOP4645243 45685561 #> 94 OMOP4645243 45705627 #> 95 OMOP4645243 45706114 #> 96 OMOP4645243 45778057 #> 97 OMOP4645243 45778726 #> 98 OMOP4645243 45779710 #> 99 OMOP4645243 45780482 #> 100 OMOP4645243 45780934 #> 101 OMOP4645243 45793993 #> 102 OMOP4645243 45798776 #> 103 OMOP4645243 45801326 #> 104 OMOP4645243 45801357 #> 105 OMOP4645243 45804073 #> 106 OMOP4645243 45896548 #> 107 OMOP4645243 46242501 #> 108 OMOP820089 1750500 #> 109 OMOP820089 1750722 #> 110 OMOP820089 21602795 #> 111 OMOP820089 21602796 #> 112 OMOP820089 21602968 #> 113 OMOP820089 21602969 #> 114 OMOP820089 21602977 #> 115 OMOP820089 35807271 #> 116 OMOP820089 35807328 #> 117 OMOP820089 35807476 #> 118 OMOP820089 36882746 #> 119 OMOP820089 40923006 #> 120 OMOP820089 43623351 #> 121 OMOP820089 43641540 #> 122 OMOP820089 43767331 #> 123 OMOP820089 43785378 #> 124 OMOP820089 43796624 #> 125 OMOP820089 43796627 #> 126 OMOP820089 43803334 #> 127 OMOP820089 43814717 #> 128 OMOP820089 43869021 #> 129 OMOP820089 43869022 #> 130 33842011000001103 4126705 #> 131 33842011000001103 4169265 #> 132 33842011000001103 35626951 #> 133 33842011000001103 36708232 #> 134 33842011000001103 36711737 #> 135 33842011000001103 37209199 #> 136 33842011000001103 37209201 #> 137 00256023302 NA #> 138 OMOP992836 19056157 #> 139 OMOP992836 36879604 #> 140 408001000001109 NA #> 141 OMOP2332057 590836 #> 142 OMOP2332057 970643 #> 143 OMOP2332057 1203065 #> 144 OMOP2332057 1312749 #> 145 OMOP2332057 1560891 #> 146 OMOP2332057 19096740 #> 147 OMOP2332057 21032918 #> 148 OMOP2332057 21052613 #> 149 OMOP2332057 21091799 #> 150 OMOP2332057 21601237 #> 151 OMOP2332057 21601782 #> 152 OMOP2332057 21601822 #> 153 OMOP2332057 21601823 #> 154 OMOP2332057 21601831 #> 155 OMOP2332057 35502912 #> 156 OMOP2332057 35507544 #> 157 OMOP2332057 35508194 #> 158 OMOP2332057 35508519 #> 159 OMOP2332057 35902974 #> 160 OMOP2332057 36003320 #> 161 OMOP2332057 36153511 #> 162 OMOP2332057 36154390 #> 163 OMOP2332057 36156013 #> 164 OMOP2332057 36158118 #> 165 OMOP2332057 36217214 #> 166 OMOP2332057 36217216 #> min_levels_of_separation max_levels_of_separation #> 1 0 0 #> 2 1 1 #> 3 0 0 #> 4 5 5 #> 5 4 4 #> 6 3 3 #> 7 2 2 #> 8 1 1 #> 9 0 0 #> 10 NA NA #> 11 2 2 #> 12 3 4 #> 13 1 1 #> 14 4 12 #> 15 4 5 #> 16 4 5 #> 17 6 7 #> 18 5 6 #> 19 6 7 #> 20 3 3 #> 21 7 10 #> 22 0 0 #> 23 5 6 #> 24 2 2 #> 25 4 5 #> 26 3 6 #> 27 6 7 #> 28 2 2 #> 29 3 3 #> 30 7 8 #> 31 7 11 #> 32 5 6 #> 33 6 9 #> 34 5 7 #> 35 6 8 #> 36 NA NA #> 37 NA NA #> 38 4 4 #> 39 0 0 #> 40 2 2 #> 41 6 6 #> 42 3 3 #> 43 1 1 #> 44 5 5 #> 45 5 5 #> 46 6 6 #> 47 3 3 #> 48 4 4 #> 49 4 4 #> 50 3 3 #> 51 5 5 #> 52 3 3 #> 53 3 3 #> 54 2 2 #> 55 3 3 #> 56 2 2 #> 57 2 2 #> 58 3 3 #> 59 1 1 #> 60 4 7 #> 61 4 4 #> 62 2 2 #> 63 4 4 #> 64 5 8 #> 65 4 5 #> 66 1 1 #> 67 2 2 #> 68 2 3 #> 69 1 1 #> 70 0 0 #> 71 0 0 #> 72 6 7 #> 73 5 6 #> 74 4 5 #> 75 3 4 #> 76 2 3 #> 77 2 3 #> 78 1 2 #> 79 1 1 #> 80 0 0 #> 81 0 0 #> 82 1 1 #> 83 1 1 #> 84 1 1 #> 85 1 1 #> 86 1 1 #> 87 1 1 #> 88 1 1 #> 89 1 1 #> 90 1 1 #> 91 1 1 #> 92 1 1 #> 93 1 1 #> 94 1 1 #> 95 1 1 #> 96 1 1 #> 97 1 1 #> 98 1 1 #> 99 1 1 #> 100 1 1 #> 101 1 1 #> 102 1 1 #> 103 1 1 #> 104 1 1 #> 105 1 1 #> 106 1 1 #> 107 1 1 #> 108 3 4 #> 109 2 3 #> 110 7 8 #> 111 6 7 #> 112 5 6 #> 113 4 5 #> 114 3 4 #> 115 6 7 #> 116 4 5 #> 117 5 6 #> 118 2 3 #> 119 2 3 #> 120 1 2 #> 121 2 3 #> 122 1 1 #> 123 1 1 #> 124 1 1 #> 125 1 1 #> 126 1 2 #> 127 1 2 #> 128 1 2 #> 129 0 0 #> 130 4 5 #> 131 3 4 #> 132 2 2 #> 133 1 1 #> 134 0 0 #> 135 1 1 #> 136 2 3 #> 137 NA NA #> 138 1 1 #> 139 0 0 #> 140 NA NA #> 141 2 3 #> 142 2 3 #> 143 2 3 #> 144 2 3 #> 145 2 3 #> 146 1 2 #> 147 1 2 #> 148 2 3 #> 149 2 3 #> 150 7 9 #> 151 6 8 #> 152 5 7 #> 153 4 6 #> 154 3 5 #> 155 2 3 #> 156 2 3 #> 157 2 3 #> 158 2 3 #> 159 2 3 #> 160 2 3 #> 161 2 3 #> 162 2 3 #> 163 2 3 #> 164 2 3 #> 165 3 5 #> 166 3 5 #> [ reached 'max' / getOption("max.print") -- omitted 128 rows ]# To retrieve all the attributes for either the ancestor or descendants, use # the following functions join_for_descendants( conn = conn, data = test_data, ancestor_id_column = "test_concept_id" )#> [2021-05-26 16:07:04] Target column: test_concept_id #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704... #> [2021-05-26 16:07:04] ✓ Open connection #> [2021-05-26 16:07:04] ✓ JDBC connection #> [2021-05-26 16:07:04] SQL: DROP TABLE IF EXISTS patelm9.V20210526160704; #> [2021-05-26 16:07:04] Sending... #> [2021-05-26 16:07:04] Sending...complete #> [2021-05-26 16:07:04] Dropping patelm9.V20210526160704...complete #> [2021-05-26 16:07:04] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:04] Writing patelm9.V20210526160704... #> [2021-05-26 16:07:05] Writing patelm9.V20210526160704...complete #> [2021-05-26 16:07:05] ✓ Open connection #> [2021-05-26 16:07:05] ✓ JDBC connection #> [2021-05-26 16:07:05] SQL: SELECT a.*, b.descendant_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160704 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.test_concept_id = b.ancestor_concept_id #> [2021-05-26 16:07:05] Querying... #> [2021-05-26 16:07:05] Querying...complete #> [2021-05-26 16:07:05] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:05] Dropping patelm9.V20210526160704... #> [2021-05-26 16:07:05] ✓ Open connection #> [2021-05-26 16:07:05] ✓ JDBC connection #> [2021-05-26 16:07:05] SQL: DROP TABLE IF EXISTS patelm9.V20210526160704; #> [2021-05-26 16:07:05] Sending... #> [2021-05-26 16:07:05] Sending...complete #> [2021-05-26 16:07:05] Dropping patelm9.V20210526160704...complete #> [2021-05-26 16:07:05] Target column: descendant_concept_id #> [2021-05-26 16:07:05] Dropping patelm9.V20210526160705... #> [2021-05-26 16:07:05] ✓ Open connection #> [2021-05-26 16:07:05] ✓ JDBC connection #> [2021-05-26 16:07:05] SQL: DROP TABLE IF EXISTS patelm9.V20210526160705; #> [2021-05-26 16:07:05] Sending... #> [2021-05-26 16:07:05] Sending...complete #> [2021-05-26 16:07:05] Dropping patelm9.V20210526160705...complete #> [2021-05-26 16:07:05] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:05] Writing patelm9.V20210526160705... #> [2021-05-26 16:07:05] Writing patelm9.V20210526160705...complete #> [2021-05-26 16:07:05] ✓ Open connection #> [2021-05-26 16:07:05] ✓ JDBC connection #> [2021-05-26 16:07:05] SQL: SELECT a.*, b.* FROM patelm9.V20210526160705 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:05] Querying... #> [2021-05-26 16:07:05] Querying...complete #> [2021-05-26 16:07:05] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:05] Dropping patelm9.V20210526160705... #> [2021-05-26 16:07:05] ✓ Open connection #> [2021-05-26 16:07:05] ✓ JDBC connection #> [2021-05-26 16:07:05] SQL: DROP TABLE IF EXISTS patelm9.V20210526160705; #> [2021-05-26 16:07:05] Sending... #> [2021-05-26 16:07:05] Sending...complete #> [2021-05-26 16:07:05] Dropping patelm9.V20210526160705...complete#> test_concept_id #> 1 822160 #> 2 41264590 #> 3 41264590 #> 4 41264590 #> 5 41264590 #> 6 41264590 #> 7 41264590 #> 8 41264590 #> 9 41264590 #> 10 41264590 #> 11 21453274 #> 12 4100962 #> 13 4100962 #> 14 4100962 #> 15 4100962 #> 16 4100962 #> 17 21221431 #> 18 37293276 #> 19 2749194 #> 20 42918353 #> 21 43869022 #> 22 36711737 #> 23 45095380 #> 24 36879604 #> 25 36879604 #> 26 36879604 #> 27 36879604 #> 28 36879604 #> 29 36879604 #> 30 36879604 #> 31 36879604 #> 32 36879604 #> 33 36879604 #> 34 36879604 #> 35 36879604 #> 36 36879604 #> 37 36879604 #> 38 36879604 #> 39 36879604 #> 40 36879604 #> 41 36879604 #> 42 36879604 #> 43 36879604 #> 44 36879604 #> 45 36879604 #> 46 36879604 #> 47 36879604 #> 48 36879604 #> 49 36879604 #> 50 36879604 #> 51 36879604 #> 52 36879604 #> 53 36879604 #> 54 36879604 #> 55 36879604 #> 56 36879604 #> 57 36879604 #> 58 36879604 #> 59 36879604 #> 60 36879604 #> 61 36879604 #> 62 36879604 #> 63 3580563 #> 64 41134095 #> 65 3106614 #> 66 36274507 #> test_concept_name #> 1 titanium dioxide and zinc oxide 35mg/mL / 45.5mg/mL TOPICAL LIQUID [sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen deep, sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen light, sugar r... #> 2 topiramate 50 MG [Topiramat Basics] #> 3 topiramate 50 MG [Topiramat Basics] #> 4 topiramate 50 MG [Topiramat Basics] #> 5 topiramate 50 MG [Topiramat Basics] #> 6 topiramate 50 MG [Topiramat Basics] #> 7 topiramate 50 MG [Topiramat Basics] #> 8 topiramate 50 MG [Topiramat Basics] #> 9 topiramate 50 MG [Topiramat Basics] #> 10 topiramate 50 MG [Topiramat Basics] #> 11 Haddenham Veni class 1 (18-21mmHg) tights open toe lymphoedema garment extra wide short size V #> 12 Megaloblastic anemia due to impaired absorption of folate #> 13 Megaloblastic anemia due to impaired absorption of folate #> 14 Megaloblastic anemia due to impaired absorption of folate #> 15 Megaloblastic anemia due to impaired absorption of folate #> 16 Megaloblastic anemia due to impaired absorption of folate #> 17 Piroxicam 20mg capsules #> 18 ethanol 0.7 ML/ML Topical Gel #> 19 Removal of Intraluminal Device from Larynx, External Approach #> 20 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 21 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 22 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 23 Ascorbic Acid 100 MG / Biotin 0.15 MG / Cholecalciferol 1750 UNT / Folic Acid 1 MG / Niacin 20 MG / Pantothenic Acid 5 MG / pyridoxine 10 MG / Riboflavin 1.7 MG / Thiamine 1.5 MG / Vitamin B 12 0.006 MG Disintegrating Tablet [Nephrocaps QT] #> 24 LEVOMENTHOL 0.1 MG/MG #> 25 LEVOMENTHOL 0.1 MG/MG #> 26 LEVOMENTHOL 0.1 MG/MG #> 27 LEVOMENTHOL 0.1 MG/MG #> 28 LEVOMENTHOL 0.1 MG/MG #> 29 LEVOMENTHOL 0.1 MG/MG #> 30 LEVOMENTHOL 0.1 MG/MG #> 31 LEVOMENTHOL 0.1 MG/MG #> 32 LEVOMENTHOL 0.1 MG/MG #> 33 LEVOMENTHOL 0.1 MG/MG #> 34 LEVOMENTHOL 0.1 MG/MG #> 35 LEVOMENTHOL 0.1 MG/MG #> 36 LEVOMENTHOL 0.1 MG/MG #> 37 LEVOMENTHOL 0.1 MG/MG #> 38 LEVOMENTHOL 0.1 MG/MG #> 39 LEVOMENTHOL 0.1 MG/MG #> 40 LEVOMENTHOL 0.1 MG/MG #> 41 LEVOMENTHOL 0.1 MG/MG #> 42 LEVOMENTHOL 0.1 MG/MG #> 43 LEVOMENTHOL 0.1 MG/MG #> 44 LEVOMENTHOL 0.1 MG/MG #> 45 LEVOMENTHOL 0.1 MG/MG #> 46 LEVOMENTHOL 0.1 MG/MG #> 47 LEVOMENTHOL 0.1 MG/MG #> 48 LEVOMENTHOL 0.1 MG/MG #> 49 LEVOMENTHOL 0.1 MG/MG #> 50 LEVOMENTHOL 0.1 MG/MG #> 51 LEVOMENTHOL 0.1 MG/MG #> 52 LEVOMENTHOL 0.1 MG/MG #> 53 LEVOMENTHOL 0.1 MG/MG #> 54 LEVOMENTHOL 0.1 MG/MG #> 55 LEVOMENTHOL 0.1 MG/MG #> 56 LEVOMENTHOL 0.1 MG/MG #> 57 LEVOMENTHOL 0.1 MG/MG #> 58 LEVOMENTHOL 0.1 MG/MG #> 59 LEVOMENTHOL 0.1 MG/MG #> 60 LEVOMENTHOL 0.1 MG/MG #> 61 LEVOMENTHOL 0.1 MG/MG #> 62 LEVOMENTHOL 0.1 MG/MG #> 63 Zadstat 200mg tablet #> 64 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 65 Pemphigoid #> 66 Bisoprolol 5 MG / Hydrochlorothiazide 12.5 MG [BISOPROLOL/HYDROCHLOROTHIAZIDE TEVA] #> test_concept_code min_levels_of_separation #> 1 c7a2c97a-8fa7-463b-b024-b199bc7cf469 0 #> 2 OMOP2462552 1 #> 3 OMOP2462552 2 #> 4 OMOP2462552 2 #> 5 OMOP2462552 2 #> 6 OMOP2462552 1 #> 7 OMOP2462552 2 #> 8 OMOP2462552 2 #> 9 OMOP2462552 2 #> 10 OMOP2462552 0 #> 11 26196011000001108 NA #> 12 27798002 2 #> 13 27798002 1 #> 14 27798002 2 #> 15 27798002 1 #> 16 27798002 0 #> 17 13244211000001106 NA #> 18 78072050047 NA #> 19 0CPSXDZ 0 #> 20 OMOP4645243 0 #> 21 OMOP820089 0 #> 22 33842011000001103 0 #> 23 00256023302 NA #> 24 OMOP992836 1 #> 25 OMOP992836 0 #> 26 OMOP992836 2 #> 27 OMOP992836 1 #> 28 OMOP992836 2 #> 29 OMOP992836 1 #> 30 OMOP992836 1 #> 31 OMOP992836 1 #> 32 OMOP992836 1 #> 33 OMOP992836 2 #> 34 OMOP992836 0 #> 35 OMOP992836 2 #> 36 OMOP992836 1 #> 37 OMOP992836 2 #> 38 OMOP992836 1 #> 39 OMOP992836 2 #> 40 OMOP992836 0 #> 41 OMOP992836 2 #> 42 OMOP992836 1 #> 43 OMOP992836 1 #> 44 OMOP992836 1 #> 45 OMOP992836 2 #> 46 OMOP992836 0 #> 47 OMOP992836 2 #> 48 OMOP992836 0 #> 49 OMOP992836 1 #> 50 OMOP992836 1 #> 51 OMOP992836 1 #> 52 OMOP992836 1 #> 53 OMOP992836 1 #> 54 OMOP992836 1 #> 55 OMOP992836 2 #> 56 OMOP992836 1 #> 57 OMOP992836 1 #> 58 OMOP992836 1 #> 59 OMOP992836 2 #> 60 OMOP992836 0 #> 61 OMOP992836 1 #> 62 OMOP992836 1 #> 63 408001000001109 NA #> 64 OMOP2332057 0 #> 65 156356009 NA #> 66 OMOP3125382 2 #> max_levels_of_separation descendant_concept_id #> 1 0 822160 #> 2 1 40901821 #> 3 2 40839627 #> 4 3 41226154 #> 5 3 44170553 #> 6 1 44161617 #> 7 2 44169209 #> 8 2 40995481 #> 9 3 41288043 #> 10 0 41264590 #> 11 NA NA #> 12 2 4282785 #> 13 1 4238731 #> 14 2 4338976 #> 15 1 4221567 #> 16 0 4100962 #> 17 NA NA #> 18 NA NA #> 19 0 2749194 #> 20 0 42918353 #> 21 0 43869022 #> 22 0 36711737 #> 23 NA NA #> 24 1 36283195 #> 25 0 42719097 #> 26 2 43681771 #> 27 1 36882084 #> 28 2 40931000 #> 29 1 41484176 #> 30 1 40899902 #> 31 1 36268143 #> 32 1 43617433 #> 33 2 43652691 #> 34 0 36879604 #> 35 2 43663961 #> 36 1 43832558 #> 37 2 41484179 #> 38 1 43743517 #> 39 2 36283197 #> 40 0 41048040 #> 41 2 41484196 #> 42 1 43706507 #> 43 1 43753020 #> 44 1 41098762 #> 45 2 42717260 #> 46 0 43743525 #> 47 2 41036021 #> 48 0 43581420 #> 49 1 41484198 #> 50 1 42719464 #> 51 1 43771604 #> 52 1 36283166 #> 53 1 43833539 #> 54 1 43717517 #> 55 2 43663373 #> 56 1 43591145 #> 57 1 43843760 #> 58 1 42715897 #> 59 2 42718155 #> 60 0 36271886 #> 61 1 36269924 #> 62 1 43753560 #> 63 NA NA #> 64 0 41134095 #> 65 NA NA #> 66 2 36268400 #> descendant_concept_name #> 1 titanium dioxide and zinc oxide 35mg/mL / 45.5mg/mL TOPICAL LIQUID [sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen deep, sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen light, sugar r... #> 2 topiramate 50 MG Oral Tablet [Topiramat Basics] #> 3 topiramate 50 MG Oral Tablet [Topiramat Basics] Box of 100 #> 4 topiramate 50 MG Oral Tablet [Topiramat Basics] Box of 100 by Basics #> 5 topiramate 50 MG Delayed Release Oral Tablet [Topiramat Basics] Box of 200 by Basics #> 6 topiramate 50 MG Delayed Release Oral Tablet [Topiramat Basics] #> 7 topiramate 50 MG Delayed Release Oral Tablet [Topiramat Basics] Box of 200 #> 8 topiramate 50 MG Oral Tablet [Topiramat Basics] Box of 200 #> 9 topiramate 50 MG Oral Tablet [Topiramat Basics] Box of 200 by Basics #> 10 topiramate 50 MG [Topiramat Basics] #> 11 <NA> #> 12 Megaloblastic anemia due to nontropical sprue #> 13 Megaloblastic anemia due to pregnancy #> 14 Megaloblastic anemia due to tropical sprue #> 15 Megaloblastic anemia due to disease of small intestine #> 16 Megaloblastic anemia due to impaired absorption of folate #> 17 <NA> #> 18 <NA> #> 19 Removal of Intraluminal Device from Larynx, External Approach #> 20 500 ML Glucose 50 MG/ML Injectable Solution [GLUCOSE B.BROWN] #> 21 81.9 ML Clarithromycin 25 MG/ML Oral Granules [Clarithromycin Ct] Box of 5 by AbZ-Pharma #> 22 Gloria Med Soft class 2 (23-32mmHg) thigh length open toe with waist attachment max lymphoedema garment long medium left Beige (Gardamed Ltd) 1 device #> 23 <NA> #> 24 20000 MG Eucalyptol 0.015 MG/MG / LEVOMENTHOL 0.1 MG/MG Inhalant Solution [Inhalo Rhinathiol] #> 25 cajuput oil 0.0701 MG/MG / Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Mentha piperita extract 0.0598 MG/MG [Tiger Balm Ro] #> 26 8000 MG LEVOMENTHOL 0.1 MG/MG Topical Ointment [Tiger Balm Rot N] by Queisser #> 27 LEVOMENTHOL 0.1 MG/MG Topical Ointment #> 28 cajuput oil 0.07 MG/MG / Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Mentha piperita extract 0.06 MG/MG Topical Ointment Box of 1 #> 29 19400 MG cajuput oil 0.0701 MG/MG / Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Mentha piperita extract 0.0598 MG/MG Topical Ointment #> 30 cajuput oil 0.07 MG/MG / Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Mentha piperita extract 0.06 MG/MG Topical Ointment #> 31 Eucalyptol 0.015 MG/MG / LEVOMENTHOL 0.1 MG/MG Inhalant Solution [Inhalo Rhinathiol] #> 32 Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Melaleuca ericifolia leaf oil 0.07 MG/MG / Peppermint preparation 0.06 MG/MG Topical Ointment #> 33 19400 MG LEVOMENTHOL 0.1 MG/MG Topical Ointment [Tiger Balm Rot N] by Queisser #> 34 LEVOMENTHOL 0.1 MG/MG #> 35 10000 MG Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Melaleuca ericifolia leaf oil 0.07 MG/MG / Peppermint preparation 0.06 MG/MG Topical Ointment [Tiger Balm Rot N] by Queisser #> 36 19400 MG LEVOMENTHOL 0.1 MG/MG Topical Ointment [Tiger Balm Rot N] #> 37 19400 MG cajuput oil 0.0701 MG/MG / Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Mentha piperita extract 0.0598 MG/MG Topical Ointment Box of 1 #> 38 LEVOMENTHOL 0.1 MG/MG Topical Ointment [Tiger Balm Rot N] #> 39 20000 MG Eucalyptol 0.015 MG/MG / LEVOMENTHOL 0.1 MG/MG Inhalant Solution [Inhalo Rhinathiol] by Sanofi #> 40 cajuput oil 0.07 MG/MG / Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Mentha piperita extract 0.06 MG/MG [Tiger Balm Ro] #> 41 19400 MG cajuput oil 0.0701 MG/MG / Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Mentha piperita extract 0.0598 MG/MG Topical Ointment [Tiger Balm Ro] Box of 1 #> 42 19400 MG LEVOMENTHOL 0.1 MG/MG Topical Ointment #> 43 4000 MG LEVOMENTHOL 0.1 MG/MG Topical Ointment #> 44 cajuput oil 0.07 MG/MG / Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Mentha piperita extract 0.06 MG/MG Topical Ointment [Tiger Balm Ro] #> 45 cajuput oil 0.0701 MG/MG / Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Mentha piperita extract 0.0598 MG/MG Topical Ointment [Tiger Balm Ro] Box of 1 #> 46 Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Melaleuca ericifolia leaf oil 0.07 MG/MG / Peppermint preparation 0.06 MG/MG [Tiger Balm Rot N] #> 47 cajuput oil 0.07 MG/MG / Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Mentha piperita extract 0.06 MG/MG Topical Ointment [Tiger Balm Ro] Box of 1 #> 48 LEVOMENTHOL 0.1 MG/MG [Tiger Balm Rot N] #> 49 19400 MG cajuput oil 0.0701 MG/MG / Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Mentha piperita extract 0.0598 MG/MG Topical Ointment [Tiger Balm Ro] #> 50 cajuput oil 0.0701 MG/MG / Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Mentha piperita extract 0.0598 MG/MG Topical Ointment #> 51 10000 MG Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Melaleuca ericifolia leaf oil 0.07 MG/MG / Peppermint preparation 0.06 MG/MG Topical Ointment [Tiger Balm Rot N] #> 52 20000 MG Eucalyptol 0.015 MG/MG / LEVOMENTHOL 0.1 MG/MG Inhalant Solution #> 53 Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Melaleuca ericifolia leaf oil 0.07 MG/MG / Peppermint preparation 0.06 MG/MG Topical Ointment [Tiger Balm Rot N] #> 54 8000 MG LEVOMENTHOL 0.1 MG/MG Topical Ointment #> 55 4000 MG LEVOMENTHOL 0.1 MG/MG Topical Ointment [Tiger Balm Rot N] by Queisser #> 56 4000 MG LEVOMENTHOL 0.1 MG/MG Topical Ointment [Tiger Balm Rot N] #> 57 10000 MG Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Melaleuca ericifolia leaf oil 0.07 MG/MG / Peppermint preparation 0.06 MG/MG Topical Ointment #> 58 cajuput oil 0.0701 MG/MG / Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Mentha piperita extract 0.0598 MG/MG Topical Ointment [Tiger Balm Ro] #> 59 cajuput oil 0.0701 MG/MG / Camphor 0.11 MG/MG / LEVOMENTHOL 0.1 MG/MG / Mentha piperita extract 0.0598 MG/MG Topical Ointment Box of 1 #> 60 Eucalyptol 0.015 MG/MG / LEVOMENTHOL 0.1 MG/MG [Inhalo Rhinathiol] #> 61 Eucalyptol 0.015 MG/MG / LEVOMENTHOL 0.1 MG/MG Inhalant Solution #> 62 8000 MG LEVOMENTHOL 0.1 MG/MG Topical Ointment [Tiger Balm Rot N] #> 63 <NA> #> 64 olmesartan 20 MG Oral Tablet [Olmetec] Box of 56 by Cc #> 65 <NA> #> 66 Bisoprolol 5 MG / Hydrochlorothiazide 12.5 MG Oral Tablet [BISOPROLOL/HYDROCHLOROTHIAZIDE TEVA] Box of 100 #> descendant_domain_id descendant_vocabulary_id descendant_concept_class_id #> 1 Drug SPL OTC Drug #> 2 Drug RxNorm Extension Branded Drug #> 3 Drug RxNorm Extension Branded Drug Box #> 4 Drug RxNorm Extension Marketed Product #> 5 Drug RxNorm Extension Marketed Product #> 6 Drug RxNorm Extension Branded Drug #> 7 Drug RxNorm Extension Branded Drug Box #> 8 Drug RxNorm Extension Branded Drug Box #> 9 Drug RxNorm Extension Marketed Product #> 10 Drug RxNorm Extension Branded Drug Comp #> 11 <NA> <NA> <NA> #> 12 Condition SNOMED Clinical Finding #> 13 Condition SNOMED Clinical Finding #> 14 Condition SNOMED Clinical Finding #> 15 Condition SNOMED Clinical Finding #> 16 Condition SNOMED Clinical Finding #> 17 <NA> <NA> <NA> #> 18 <NA> <NA> <NA> #> 19 Procedure ICD10PCS ICD10PCS #> 20 Drug RxNorm Extension Quant Branded Drug #> 21 Drug RxNorm Extension Marketed Product #> 22 Device SNOMED Physical Object #> 23 <NA> <NA> <NA> #> 24 Drug RxNorm Extension Quant Branded Drug #> 25 Drug RxNorm Extension Branded Drug Comp #> 26 Drug RxNorm Extension Marketed Product #> 27 Drug RxNorm Extension Clinical Drug #> 28 Drug RxNorm Extension Clinical Drug Box #> 29 Drug RxNorm Extension Quant Clinical Drug #> 30 Drug RxNorm Extension Clinical Drug #> 31 Drug RxNorm Extension Branded Drug #> 32 Drug RxNorm Extension Clinical Drug #> 33 Drug RxNorm Extension Marketed Product #> 34 Drug RxNorm Extension Clinical Drug Comp #> 35 Drug RxNorm Extension Marketed Product #> 36 Drug RxNorm Extension Quant Branded Drug #> 37 Drug RxNorm Extension Quant Clinical Box #> 38 Drug RxNorm Extension Branded Drug #> 39 Drug RxNorm Extension Marketed Product #> 40 Drug RxNorm Extension Branded Drug Comp #> 41 Drug RxNorm Extension Quant Branded Box #> 42 Drug RxNorm Extension Quant Clinical Drug #> 43 Drug RxNorm Extension Quant Clinical Drug #> 44 Drug RxNorm Extension Branded Drug #> 45 Drug RxNorm Extension Branded Drug Box #> 46 Drug RxNorm Extension Branded Drug Comp #> 47 Drug RxNorm Extension Branded Drug Box #> 48 Drug RxNorm Extension Branded Drug Comp #> 49 Drug RxNorm Extension Quant Branded Drug #> 50 Drug RxNorm Extension Clinical Drug #> 51 Drug RxNorm Extension Quant Branded Drug #> 52 Drug RxNorm Extension Quant Clinical Drug #> 53 Drug RxNorm Extension Branded Drug #> 54 Drug RxNorm Extension Quant Clinical Drug #> 55 Drug RxNorm Extension Marketed Product #> 56 Drug RxNorm Extension Quant Branded Drug #> 57 Drug RxNorm Extension Quant Clinical Drug #> 58 Drug RxNorm Extension Branded Drug #> 59 Drug RxNorm Extension Clinical Drug Box #> 60 Drug RxNorm Extension Branded Drug Comp #> 61 Drug RxNorm Extension Clinical Drug #> 62 Drug RxNorm Extension Quant Branded Drug #> 63 <NA> <NA> <NA> #> 64 Drug RxNorm Extension Marketed Product #> 65 <NA> <NA> <NA> #> 66 Drug RxNorm Extension Branded Drug Box #> descendant_standard_concept descendant_concept_code #> 1 C c7a2c97a-8fa7-463b-b024-b199bc7cf469 #> 2 S OMOP2099783 #> 3 S OMOP2037589 #> 4 S OMOP2424116 #> 5 S OMOP3047276 #> 6 S OMOP3038340 #> 7 S OMOP3045932 #> 8 S OMOP2193443 #> 9 S OMOP2486005 #> 10 S OMOP2462552 #> 11 <NA> <NA> #> 12 S 6659005 #> 13 S 91217009 #> 14 S 87806008 #> 15 S 82895008 #> 16 S 27798002 #> 17 <NA> <NA> #> 18 <NA> <NA> #> 19 S 0CPSXDZ #> 20 S OMOP4645243 #> 21 S OMOP820089 #> 22 S 33842011000001103 #> 23 <NA> <NA> #> 24 S OMOP3134070 #> 25 S OMOP2729209 #> 26 S OMOP775257 #> 27 S OMOP996860 #> 28 S OMOP2128962 #> 29 S OMOP2682138 #> 30 S OMOP2097864 #> 31 S OMOP3119018 #> 32 S OMOP681311 #> 33 S OMOP792621 #> 34 S OMOP992836 #> 35 S OMOP776488 #> 36 S OMOP792620 #> 37 S OMOP2682141 #> 38 S OMOP679275 #> 39 S OMOP3134072 #> 40 S OMOP2246002 #> 41 S OMOP2682158 #> 42 S OMOP792619 #> 43 S OMOP763073 #> 44 S OMOP2296724 #> 45 S OMOP2734396 #> 46 S OMOP681302 #> 47 S OMOP2233983 #> 48 S OMOP679254 #> 49 S OMOP2682160 #> 50 S OMOP2732792 #> 51 S OMOP776487 #> 52 S OMOP3134041 #> 53 S OMOP681323 #> 54 S OMOP775255 #> 55 S OMOP763075 #> 56 S OMOP763074 #> 57 S OMOP776486 #> 58 S OMOP2733811 #> 59 S OMOP2739370 #> 60 S OMOP3122761 #> 61 S OMOP3120799 #> 62 S OMOP775256 #> 63 <NA> <NA> #> 64 S OMOP2332057 #> 65 <NA> <NA> #> 66 S OMOP3119275 #> descendant_valid_start_date descendant_valid_end_date #> 1 2019-05-13 2099-12-31 #> 2 2017-08-24 2099-12-31 #> 3 2017-08-24 2099-12-31 #> 4 2017-08-24 2099-12-31 #> 5 2017-10-06 2099-12-31 #> 6 2017-10-06 2099-12-31 #> 7 2017-10-06 2099-12-31 #> 8 2017-08-24 2099-12-31 #> 9 2017-08-24 2099-12-31 #> 10 2017-08-24 2099-12-31 #> 11 <NA> <NA> #> 12 2002-01-31 2099-12-31 #> 13 2002-01-31 2099-12-31 #> 14 2002-01-31 2099-12-31 #> 15 2002-01-31 2099-12-31 #> 16 2002-01-31 2099-12-31 #> 17 <NA> <NA> #> 18 <NA> <NA> #> 19 2014-04-22 2099-12-31 #> 20 2018-08-21 2099-12-31 #> 21 2017-08-24 2099-12-31 #> 22 2017-03-01 2099-12-31 #> 23 <NA> <NA> #> 24 2017-10-01 2099-12-31 #> 25 2017-08-24 2099-12-31 #> 26 2017-08-24 2099-12-31 #> 27 2017-08-24 2099-12-31 #> 28 2017-08-24 2099-12-31 #> 29 2017-08-24 2099-12-31 #> 30 2017-08-24 2099-12-31 #> 31 2017-10-01 2099-12-31 #> 32 2017-08-24 2099-12-31 #> 33 2017-08-24 2099-12-31 #> 34 2017-08-24 2099-12-31 #> 35 2017-08-24 2099-12-31 #> 36 2017-08-24 2099-12-31 #> 37 2017-08-24 2099-12-31 #> 38 2017-08-24 2099-12-31 #> 39 2017-10-01 2099-12-31 #> 40 2017-08-24 2099-12-31 #> 41 2017-08-24 2099-12-31 #> 42 2017-08-24 2099-12-31 #> 43 2017-08-24 2099-12-31 #> 44 2017-08-24 2099-12-31 #> 45 2017-08-24 2099-12-31 #> 46 2017-08-24 2099-12-31 #> 47 2017-08-24 2099-12-31 #> 48 2017-08-24 2099-12-31 #> 49 2017-08-24 2099-12-31 #> 50 2017-08-24 2099-12-31 #> 51 2017-08-24 2099-12-31 #> 52 2017-10-01 2099-12-31 #> 53 2017-08-24 2099-12-31 #> 54 2017-08-24 2099-12-31 #> 55 2017-08-24 2099-12-31 #> 56 2017-08-24 2099-12-31 #> 57 2017-08-24 2099-12-31 #> 58 2017-08-24 2099-12-31 #> 59 2017-08-24 2099-12-31 #> 60 2017-10-01 2099-12-31 #> 61 2017-10-01 2099-12-31 #> 62 2017-08-24 2099-12-31 #> 63 <NA> <NA> #> 64 2017-08-24 2099-12-31 #> 65 <NA> <NA> #> 66 2017-10-01 2099-12-31 #> descendant_invalid_reason #> 1 <NA> #> 2 <NA> #> 3 <NA> #> 4 <NA> #> 5 <NA> #> 6 <NA> #> 7 <NA> #> 8 <NA> #> 9 <NA> #> 10 <NA> #> 11 <NA> #> 12 <NA> #> 13 <NA> #> 14 <NA> #> 15 <NA> #> 16 <NA> #> 17 <NA> #> 18 <NA> #> 19 <NA> #> 20 <NA> #> 21 <NA> #> 22 <NA> #> 23 <NA> #> 24 <NA> #> 25 <NA> #> 26 <NA> #> 27 <NA> #> 28 <NA> #> 29 <NA> #> 30 <NA> #> 31 <NA> #> 32 <NA> #> 33 <NA> #> 34 <NA> #> 35 <NA> #> 36 <NA> #> 37 <NA> #> 38 <NA> #> 39 <NA> #> 40 <NA> #> 41 <NA> #> 42 <NA> #> 43 <NA> #> 44 <NA> #> 45 <NA> #> 46 <NA> #> 47 <NA> #> 48 <NA> #> 49 <NA> #> 50 <NA> #> 51 <NA> #> 52 <NA> #> 53 <NA> #> 54 <NA> #> 55 <NA> #> 56 <NA> #> 57 <NA> #> 58 <NA> #> 59 <NA> #> 60 <NA> #> 61 <NA> #> 62 <NA> #> 63 <NA> #> 64 <NA> #> 65 <NA> #> 66 <NA> #> [ reached 'max' / getOption("max.print") -- omitted 10 rows ]#> [2021-05-26 16:07:05] Target column: test_concept_id #> [2021-05-26 16:07:05] Dropping patelm9.V20210526160705... #> [2021-05-26 16:07:05] ✓ Open connection #> [2021-05-26 16:07:05] ✓ JDBC connection #> [2021-05-26 16:07:05] SQL: DROP TABLE IF EXISTS patelm9.V20210526160705; #> [2021-05-26 16:07:05] Sending... #> [2021-05-26 16:07:05] Sending...complete #> [2021-05-26 16:07:05] Dropping patelm9.V20210526160705...complete #> [2021-05-26 16:07:05] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:05] Writing patelm9.V20210526160705... #> [2021-05-26 16:07:05] Writing patelm9.V20210526160705...complete #> [2021-05-26 16:07:05] ✓ Open connection #> [2021-05-26 16:07:05] ✓ JDBC connection #> [2021-05-26 16:07:05] SQL: SELECT a.*, b.ancestor_concept_id,b.min_levels_of_separation,b.max_levels_of_separation FROM patelm9.V20210526160705 a LEFT JOIN omop_vocabulary.concept_ancestor b ON a.test_concept_id = b.descendant_concept_id #> [2021-05-26 16:07:05] Querying... #> [2021-05-26 16:07:05] Querying...complete #> [2021-05-26 16:07:05] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:05] Dropping patelm9.V20210526160705... #> [2021-05-26 16:07:05] ✓ Open connection #> [2021-05-26 16:07:05] ✓ JDBC connection #> [2021-05-26 16:07:05] SQL: DROP TABLE IF EXISTS patelm9.V20210526160705; #> [2021-05-26 16:07:05] Sending... #> [2021-05-26 16:07:05] Sending...complete #> [2021-05-26 16:07:05] Dropping patelm9.V20210526160705...complete #> [2021-05-26 16:07:05] Target column: ancestor_concept_id #> [2021-05-26 16:07:05] Dropping patelm9.V20210526160705... #> [2021-05-26 16:07:05] ✓ Open connection #> [2021-05-26 16:07:05] ✓ JDBC connection #> [2021-05-26 16:07:05] SQL: DROP TABLE IF EXISTS patelm9.V20210526160705; #> [2021-05-26 16:07:05] Sending... #> [2021-05-26 16:07:05] Sending...complete #> [2021-05-26 16:07:05] Dropping patelm9.V20210526160705...complete #> [2021-05-26 16:07:05] ✓ Data 'data' has more than 0 rows #> [2021-05-26 16:07:05] Writing patelm9.V20210526160705... #> [2021-05-26 16:07:05] Writing patelm9.V20210526160705...complete #> [2021-05-26 16:07:05] ✓ Open connection #> [2021-05-26 16:07:05] ✓ JDBC connection #> [2021-05-26 16:07:05] SQL: SELECT a.*, b.* FROM patelm9.V20210526160705 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:05] Querying... #> [2021-05-26 16:07:05] Querying...complete #> [2021-05-26 16:07:05] ✓ Returned data has more than 0 rows #> [2021-05-26 16:07:05] Dropping patelm9.V20210526160705... #> [2021-05-26 16:07:05] ✓ Open connection #> [2021-05-26 16:07:05] ✓ JDBC connection #> [2021-05-26 16:07:05] SQL: DROP TABLE IF EXISTS patelm9.V20210526160705; #> [2021-05-26 16:07:05] Sending... #> [2021-05-26 16:07:05] Sending...complete #> [2021-05-26 16:07:05] Dropping patelm9.V20210526160705...complete#> test_concept_id #> 1 822160 #> 2 41264590 #> 3 41264590 #> 4 41264590 #> 5 41264590 #> 6 41264590 #> 7 41264590 #> 8 41264590 #> 9 41264590 #> 10 21453274 #> 11 4100962 #> 12 4100962 #> 13 4100962 #> 14 4100962 #> 15 4100962 #> 16 4100962 #> 17 4100962 #> 18 4100962 #> 19 4100962 #> 20 4100962 #> 21 4100962 #> 22 4100962 #> 23 4100962 #> 24 4100962 #> 25 4100962 #> 26 4100962 #> 27 4100962 #> 28 4100962 #> 29 4100962 #> 30 4100962 #> 31 4100962 #> 32 4100962 #> 33 4100962 #> 34 4100962 #> 35 4100962 #> 36 21221431 #> 37 37293276 #> 38 2749194 #> 39 2749194 #> 40 2749194 #> 41 2749194 #> 42 2749194 #> 43 2749194 #> 44 2749194 #> 45 2749194 #> 46 2749194 #> 47 2749194 #> 48 2749194 #> 49 2749194 #> 50 2749194 #> 51 2749194 #> 52 2749194 #> 53 2749194 #> 54 2749194 #> 55 2749194 #> 56 2749194 #> 57 2749194 #> 58 2749194 #> 59 2749194 #> 60 2749194 #> 61 2749194 #> 62 2749194 #> 63 2749194 #> 64 2749194 #> 65 2749194 #> 66 2749194 #> test_concept_name #> 1 titanium dioxide and zinc oxide 35mg/mL / 45.5mg/mL TOPICAL LIQUID [sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen deep, sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen light, sugar r... #> 2 topiramate 50 MG [Topiramat Basics] #> 3 topiramate 50 MG [Topiramat Basics] #> 4 topiramate 50 MG [Topiramat Basics] #> 5 topiramate 50 MG [Topiramat Basics] #> 6 topiramate 50 MG [Topiramat Basics] #> 7 topiramate 50 MG [Topiramat Basics] #> 8 topiramate 50 MG [Topiramat Basics] #> 9 topiramate 50 MG [Topiramat Basics] #> 10 Haddenham Veni class 1 (18-21mmHg) tights open toe lymphoedema garment extra wide short size V #> 11 Megaloblastic anemia due to impaired absorption of folate #> 12 Megaloblastic anemia due to impaired absorption of folate #> 13 Megaloblastic anemia due to impaired absorption of folate #> 14 Megaloblastic anemia due to impaired absorption of folate #> 15 Megaloblastic anemia due to impaired absorption of folate #> 16 Megaloblastic anemia due to impaired absorption of folate #> 17 Megaloblastic anemia due to impaired absorption of folate #> 18 Megaloblastic anemia due to impaired absorption of folate #> 19 Megaloblastic anemia due to impaired absorption of folate #> 20 Megaloblastic anemia due to impaired absorption of folate #> 21 Megaloblastic anemia due to impaired absorption of folate #> 22 Megaloblastic anemia due to impaired absorption of folate #> 23 Megaloblastic anemia due to impaired absorption of folate #> 24 Megaloblastic anemia due to impaired absorption of folate #> 25 Megaloblastic anemia due to impaired absorption of folate #> 26 Megaloblastic anemia due to impaired absorption of folate #> 27 Megaloblastic anemia due to impaired absorption of folate #> 28 Megaloblastic anemia due to impaired absorption of folate #> 29 Megaloblastic anemia due to impaired absorption of folate #> 30 Megaloblastic anemia due to impaired absorption of folate #> 31 Megaloblastic anemia due to impaired absorption of folate #> 32 Megaloblastic anemia due to impaired absorption of folate #> 33 Megaloblastic anemia due to impaired absorption of folate #> 34 Megaloblastic anemia due to impaired absorption of folate #> 35 Megaloblastic anemia due to impaired absorption of folate #> 36 Piroxicam 20mg capsules #> 37 ethanol 0.7 ML/ML Topical Gel #> 38 Removal of Intraluminal Device from Larynx, External Approach #> 39 Removal of Intraluminal Device from Larynx, External Approach #> 40 Removal of Intraluminal Device from Larynx, External Approach #> 41 Removal of Intraluminal Device from Larynx, External Approach #> 42 Removal of Intraluminal Device from Larynx, External Approach #> 43 Removal of Intraluminal Device from Larynx, External Approach #> 44 Removal of Intraluminal Device from Larynx, External Approach #> 45 Removal of Intraluminal Device from Larynx, External Approach #> 46 Removal of Intraluminal Device from Larynx, External Approach #> 47 Removal of Intraluminal Device from Larynx, External Approach #> 48 Removal of Intraluminal Device from Larynx, External Approach #> 49 Removal of Intraluminal Device from Larynx, External Approach #> 50 Removal of Intraluminal Device from Larynx, External Approach #> 51 Removal of Intraluminal Device from Larynx, External Approach #> 52 Removal of Intraluminal Device from Larynx, External Approach #> 53 Removal of Intraluminal Device from Larynx, External Approach #> 54 Removal of Intraluminal Device from Larynx, External Approach #> 55 Removal of Intraluminal Device from Larynx, External Approach #> 56 Removal of Intraluminal Device from Larynx, External Approach #> 57 Removal of Intraluminal Device from Larynx, External Approach #> 58 Removal of Intraluminal Device from Larynx, External Approach #> 59 Removal of Intraluminal Device from Larynx, External Approach #> 60 Removal of Intraluminal Device from Larynx, External Approach #> 61 Removal of Intraluminal Device from Larynx, External Approach #> 62 Removal of Intraluminal Device from Larynx, External Approach #> 63 Removal of Intraluminal Device from Larynx, External Approach #> 64 Removal of Intraluminal Device from Larynx, External Approach #> 65 Removal of Intraluminal Device from Larynx, External Approach #> 66 Removal of Intraluminal Device from Larynx, External Approach #> test_concept_code min_levels_of_separation #> 1 c7a2c97a-8fa7-463b-b024-b199bc7cf469 0 #> 2 OMOP2462552 1 #> 3 OMOP2462552 0 #> 4 OMOP2462552 5 #> 5 OMOP2462552 4 #> 6 OMOP2462552 3 #> 7 OMOP2462552 2 #> 8 OMOP2462552 1 #> 9 OMOP2462552 0 #> 10 26196011000001108 NA #> 11 27798002 2 #> 12 27798002 3 #> 13 27798002 1 #> 14 27798002 4 #> 15 27798002 4 #> 16 27798002 4 #> 17 27798002 6 #> 18 27798002 5 #> 19 27798002 6 #> 20 27798002 3 #> 21 27798002 7 #> 22 27798002 0 #> 23 27798002 5 #> 24 27798002 2 #> 25 27798002 4 #> 26 27798002 3 #> 27 27798002 6 #> 28 27798002 2 #> 29 27798002 3 #> 30 27798002 7 #> 31 27798002 7 #> 32 27798002 5 #> 33 27798002 6 #> 34 27798002 5 #> 35 27798002 6 #> 36 13244211000001106 NA #> 37 78072050047 NA #> 38 0CPSXDZ 4 #> 39 0CPSXDZ 0 #> 40 0CPSXDZ 2 #> 41 0CPSXDZ 6 #> 42 0CPSXDZ 3 #> 43 0CPSXDZ 1 #> 44 0CPSXDZ 5 #> 45 0CPSXDZ 5 #> 46 0CPSXDZ 6 #> 47 0CPSXDZ 3 #> 48 0CPSXDZ 4 #> 49 0CPSXDZ 4 #> 50 0CPSXDZ 3 #> 51 0CPSXDZ 5 #> 52 0CPSXDZ 3 #> 53 0CPSXDZ 3 #> 54 0CPSXDZ 2 #> 55 0CPSXDZ 3 #> 56 0CPSXDZ 2 #> 57 0CPSXDZ 2 #> 58 0CPSXDZ 3 #> 59 0CPSXDZ 1 #> 60 0CPSXDZ 4 #> 61 0CPSXDZ 4 #> 62 0CPSXDZ 2 #> 63 0CPSXDZ 4 #> 64 0CPSXDZ 5 #> 65 0CPSXDZ 4 #> 66 0CPSXDZ 1 #> max_levels_of_separation ancestor_concept_id #> 1 0 822160 #> 2 1 742267 #> 3 0 742343 #> 4 5 21604180 #> 5 4 21604389 #> 6 3 21604390 #> 7 2 21604428 #> 8 1 21604433 #> 9 0 41264590 #> 10 NA NA #> 11 2 435789 #> 12 4 439777 #> 13 1 440977 #> 14 12 441840 #> 15 5 443723 #> 16 5 4013074 #> 17 7 4013518 #> 18 6 4013842 #> 19 7 4021915 #> 20 3 4022198 #> 21 10 4041436 #> 22 0 4100962 #> 23 6 4179922 #> 24 2 4181204 #> 25 5 4267432 #> 26 6 4274025 #> 27 7 4276572 #> 28 2 4280354 #> 29 3 4308125 #> 30 8 37203927 #> 31 11 40480457 #> 32 6 40480513 #> 33 9 40481841 #> 34 7 40484533 #> 35 8 42538830 #> 36 NA NA #> 37 NA NA #> 38 4 2749167 #> 39 0 2749194 #> 40 2 2799259 #> 41 6 2801516 #> 42 3 2860756 #> 43 1 2889378 #> 44 5 2897108 #> 45 5 4029205 #> 46 6 4040390 #> 47 3 4040400 #> 48 4 4040721 #> 49 4 4042150 #> 50 3 4042518 #> 51 5 4043017 #> 52 3 4043021 #> 53 3 4043022 #> 54 2 4043023 #> 55 3 4046265 #> 56 2 4046266 #> 57 2 4047655 #> 58 3 4134423 #> 59 1 4142040 #> 60 7 4180627 #> 61 4 4180941 #> 62 2 4304477 #> 63 4 4306074 #> 64 8 4322976 #> 65 5 36675054 #> 66 1 40486576 #> ancestor_concept_name #> 1 titanium dioxide and zinc oxide 35mg/mL / 45.5mg/mL TOPICAL LIQUID [sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen deep, sugar rush skin treat poreless tinted moisturizer broad spectrum spf 20 sunscreen light, sugar r... #> 2 topiramate #> 3 topiramate 50 MG #> 4 NERVOUS SYSTEM #> 5 ANTIEPILEPTICS #> 6 ANTIEPILEPTICS #> 7 Other antiepileptics #> 8 topiramate; oral #> 9 topiramate 50 MG [Topiramat Basics] #> 10 <NA> #> 11 Megaloblastic anemia #> 12 Anemia #> 13 Megaloblastic anemia due to folate deficiency #> 14 Clinical finding #> 15 Disorder of cellular component of blood #> 16 Hemoglobin low #> 17 RBC count abnormal #> 18 RBC count low #> 19 Hematopoietic system finding #> 20 Anemia related to disturbed DNA synthesis #> 21 Measurement finding #> 22 Megaloblastic anemia due to impaired absorption of folate #> 23 Cytopenia #> 24 Nutritional deficiency associated condition #> 25 Erythropenia #> 26 Disease #> 27 Protein level - finding #> 28 Nutritional anemia #> 29 Macrocytic anemia #> 30 Finding of substance level #> 31 Evaluation finding #> 32 Hemoglobin level outside reference range #> 33 Measurement finding outside reference range #> 34 Measurement finding below reference range #> 35 Abnormal blood cell count #> 36 <NA> #> 37 <NA> #> 38 Mouth and Throat, Removal #> 39 Removal of Intraluminal Device from Larynx, External Approach #> 40 Medical and Surgical @ Mouth and Throat @ Removal @ Larynx @ External #> 41 Medical and Surgical (Procedure) #> 42 Medical and Surgical @ Mouth and Throat @ Removal @ Larynx #> 43 Medical and Surgical @ Mouth and Throat @ Removal @ Larynx @ External @ Intraluminal Device #> 44 Medical and Surgical @ Mouth and Throat (Procedure) #> 45 Procedure by method #> 46 Procedure on body system #> 47 Procedure on organ #> 48 Procedure on head AND/OR neck #> 49 Removal #> 50 Procedure on upper respiratory tract #> 51 Procedure on respiratory system #> 52 Procedure on neck #> 53 Procedure on trunk #> 54 Procedure on thorax #> 55 Evacuation procedure #> 56 Drainage procedure #> 57 Procedure on larynx #> 58 Removal of device #> 59 Closed drainage of chest #> 60 Procedure by site #> 61 Procedure categorized by device involved #> 62 Removal of stent #> 63 Respiratory tract procedure #> 64 Procedure #> 65 Procedure on body region #> 66 Removal of stent from larynx #> ancestor_domain_id ancestor_vocabulary_id ancestor_concept_class_id #> 1 Drug SPL OTC Drug #> 2 Drug RxNorm Ingredient #> 3 Drug RxNorm Clinical Drug Comp #> 4 Drug ATC ATC 1st #> 5 Drug ATC ATC 2nd #> 6 Drug ATC ATC 3rd #> 7 Drug ATC ATC 4th #> 8 Drug ATC ATC 5th #> 9 Drug RxNorm Extension Branded Drug Comp #> 10 <NA> <NA> <NA> #> 11 Condition SNOMED Clinical Finding #> 12 Condition SNOMED Clinical Finding #> 13 Condition SNOMED Clinical Finding #> 14 Condition SNOMED Clinical Finding #> 15 Condition SNOMED Clinical Finding #> 16 Condition SNOMED Clinical Finding #> 17 Condition SNOMED Clinical Finding #> 18 Condition SNOMED Clinical Finding #> 19 Condition SNOMED Clinical Finding #> 20 Condition SNOMED Clinical Finding #> 21 Condition SNOMED Clinical Finding #> 22 Condition SNOMED Clinical Finding #> 23 Condition SNOMED Clinical Finding #> 24 Condition SNOMED Clinical Finding #> 25 Condition SNOMED Clinical Finding #> 26 Condition SNOMED Clinical Finding #> 27 Condition SNOMED Clinical Finding #> 28 Condition SNOMED Clinical Finding #> 29 Condition SNOMED Clinical Finding #> 30 Condition SNOMED Clinical Finding #> 31 Condition SNOMED Clinical Finding #> 32 Condition SNOMED Clinical Finding #> 33 Condition SNOMED Clinical Finding #> 34 Condition SNOMED Clinical Finding #> 35 Condition SNOMED Clinical Finding #> 36 <NA> <NA> <NA> #> 37 <NA> <NA> <NA> #> 38 Procedure ICD10PCS ICD10PCS Hierarchy #> 39 Procedure ICD10PCS ICD10PCS #> 40 Procedure ICD10PCS ICD10PCS Hierarchy #> 41 Procedure ICD10PCS ICD10PCS Hierarchy #> 42 Procedure ICD10PCS ICD10PCS Hierarchy #> 43 Procedure ICD10PCS ICD10PCS Hierarchy #> 44 Procedure ICD10PCS ICD10PCS Hierarchy #> 45 Procedure SNOMED Procedure #> 46 Procedure SNOMED Procedure #> 47 Procedure SNOMED Procedure #> 48 Procedure SNOMED Procedure #> 49 Procedure SNOMED Procedure #> 50 Procedure SNOMED Procedure #> 51 Procedure SNOMED Procedure #> 52 Procedure SNOMED Procedure #> 53 Procedure SNOMED Procedure #> 54 Procedure SNOMED Procedure #> 55 Procedure SNOMED Procedure #> 56 Procedure SNOMED Procedure #> 57 Procedure SNOMED Procedure #> 58 Procedure SNOMED Procedure #> 59 Procedure SNOMED Procedure #> 60 Procedure SNOMED Procedure #> 61 Procedure SNOMED Procedure #> 62 Procedure SNOMED Procedure #> 63 Procedure SNOMED Procedure #> 64 Procedure SNOMED Procedure #> 65 Procedure SNOMED Procedure #> 66 Procedure SNOMED Procedure #> ancestor_standard_concept ancestor_concept_code #> 1 C c7a2c97a-8fa7-463b-b024-b199bc7cf469 #> 2 S 38404 #> 3 S 335759 #> 4 C N #> 5 C N03 #> 6 C N03A #> 7 C N03AX #> 8 C N03AX11 #> 9 S OMOP2462552 #> 10 <NA> <NA> #> 11 S 53165003 #> 12 S 271737000 #> 13 S 85649008 #> 14 S 404684003 #> 15 S 414022008 #> 16 S 165397008 #> 17 S 165427000 #> 18 S 165423001 #> 19 S 106200001 #> 20 S 105599000 #> 21 S 118245000 #> 22 S 27798002 #> 23 S 50820005 #> 24 S 363246002 #> 25 S 62574001 #> 26 S 64572001 #> 27 S 365799007 #> 28 S 66612000 #> 29 S 83414005 #> 30 S 785671009 #> 31 S 441742003 #> 32 S 441793007 #> 33 S 442096005 #> 34 S 442686002 #> 35 S 762656009 #> 36 <NA> <NA> #> 37 <NA> <NA> #> 38 S 0CP #> 39 S 0CPSXDZ #> 40 S 0CPSX #> 41 S 0 #> 42 S 0CPS #> 43 S 0CPSXD #> 44 S 0C #> 45 S 128927009 #> 46 S 118664000 #> 47 S 118717007 #> 48 S 118950002 #> 49 S 118292001 #> 50 S 118670006 #> 51 S 118669005 #> 52 S 118693000 #> 53 S 118694006 #> 54 S 118695007 #> 55 S 122461007 #> 56 S 122462000 #> 57 S 123865001 #> 58 S 128538000 #> 59 S 34193001 #> 60 S 362958002 #> 61 S 363691001 #> 62 S 103718005 #> 63 S 387662008 #> 64 S 71388002 #> 65 S 771329004 #> 66 S 447794006 #> ancestor_valid_start_date ancestor_valid_end_date ancestor_invalid_reason #> 1 2019-05-13 2099-12-31 <NA> #> 2 1970-01-01 2099-12-31 <NA> #> 3 1970-01-01 2099-12-31 <NA> #> 4 1970-01-01 2099-12-31 <NA> #> 5 1970-01-01 2099-12-31 <NA> #> 6 1970-01-01 2099-12-31 <NA> #> 7 1970-01-01 2099-12-31 <NA> #> 8 1970-01-01 2099-12-31 <NA> #> 9 2017-08-24 2099-12-31 <NA> #> 10 <NA> <NA> <NA> #> 11 2002-01-31 2099-12-31 <NA> #> 12 2002-01-31 2099-12-31 <NA> #> 13 2002-01-31 2099-12-31 <NA> #> 14 2004-01-31 2099-12-31 <NA> #> 15 2005-01-31 2099-12-31 <NA> #> 16 2002-01-31 2099-12-31 <NA> #> 17 2002-01-31 2099-12-31 <NA> #> 18 2002-01-31 2099-12-31 <NA> #> 19 2002-01-31 2099-12-31 <NA> #> 20 2002-01-31 2099-12-31 <NA> #> 21 2002-01-31 2099-12-31 <NA> #> 22 2002-01-31 2099-12-31 <NA> #> 23 2002-01-31 2099-12-31 <NA> #> 24 2002-01-31 2099-12-31 <NA> #> 25 2002-01-31 2099-12-31 <NA> #> 26 2002-01-31 2099-12-31 <NA> #> 27 2002-01-31 2099-12-31 <NA> #> 28 2002-01-31 2099-12-31 <NA> #> 29 2002-01-31 2099-12-31 <NA> #> 30 2019-07-31 2099-12-31 <NA> #> 31 2009-07-31 2099-12-31 <NA> #> 32 2009-07-31 2099-12-31 <NA> #> 33 2009-07-31 2099-12-31 <NA> #> 34 2009-07-31 2099-12-31 <NA> #> 35 2018-01-31 2099-12-31 <NA> #> 36 <NA> <NA> <NA> #> 37 <NA> <NA> <NA> #> 38 1970-01-01 2099-12-31 <NA> #> 39 2014-04-22 2099-12-31 <NA> #> 40 1970-01-01 2099-12-31 <NA> #> 41 1970-01-01 2099-12-31 <NA> #> 42 1970-01-01 2099-12-31 <NA> #> 43 1970-01-01 2099-12-31 <NA> #> 44 1970-01-01 2099-12-31 <NA> #> 45 2002-01-31 2099-12-31 <NA> #> 46 2002-01-31 2099-12-31 <NA> #> 47 2002-01-31 2099-12-31 <NA> #> 48 2002-01-31 2099-12-31 <NA> #> 49 2002-01-31 2099-12-31 <NA> #> 50 2002-01-31 2099-12-31 <NA> #> 51 2002-01-31 2099-12-31 <NA> #> 52 2002-01-31 2099-12-31 <NA> #> 53 2002-01-31 2099-12-31 <NA> #> 54 2002-01-31 2099-12-31 <NA> #> 55 2002-01-31 2099-12-31 <NA> #> 56 2002-01-31 2099-12-31 <NA> #> 57 2002-01-31 2099-12-31 <NA> #> 58 2002-01-31 2099-12-31 <NA> #> 59 2002-01-31 2099-12-31 <NA> #> 60 2002-01-31 2099-12-31 <NA> #> 61 2002-01-31 2099-12-31 <NA> #> 62 2002-01-31 2099-12-31 <NA> #> 63 2003-01-31 2099-12-31 <NA> #> 64 2002-01-31 2099-12-31 <NA> #> 65 2019-01-31 2099-12-31 <NA> #> 66 2011-07-31 2099-12-31 <NA> #> [ reached 'max' / getOption("max.print") -- omitted 228 rows ]#> [2021-05-26 16:07:05] Postgres connection to 'athena' closed