Hi everyone, When I try running the vignette in postgresql, I get th

So sorry Trevor! This problem has now been fixed (see <a class="commit-link" data-hove

Error reproducing vignette in postgresql,about ohdsi/cohortmethod

Comments (6)

schuemie commented on June 12, 2024

I'm pretty sure the error message included some SQL. Could you post that as well? (it should have automatically saved the whole message to errorReport.txt in your working directory).

from cohortmethod.

tshaddox commented on June 12, 2024

Yep! Sorry, including that would have been helpful. Here it is.

SQL:
INSERT INTO cohort_covariate_ref (covariate_id, covariate_name, analysis_id, concept_id)
SELECT DISTINCT CAST(cg1.ancestor_concept_id AS BIGINT)*1000 + ccr1.analysis_id AS covariate_id,
CASE WHEN analysis_id = 101 THEN 'Condition occurrence record observed during 365d on or prior to cohort index within condition group: '
WHEN analysis_id = 102 THEN 'Condition occurrence record observed during 30d on or prior to cohort index within condition group: '
WHEN analysis_id = 103 THEN 'Condition occurrence record of primary inpatient diagnosis observed during 180d on or prior to cohort index within condition group: '
WHEN analysis_id = 201 THEN 'Condition era record observed during anytime on or prior to cohort index within condition group: '
WHEN analysis_id = 202 THEN 'Condition era record observed concurrent (overlapping) with cohort index within condition group: '
ELSE 'Other condition group analysis'
END
+ CAST(cg1.ancestor_concept_id AS VARCHAR) || '-' || c1.concept_name
AS covariate_name,
ccr1.analysis_id,
cg1.ancestor_concept_id as concept_id
FROM cohort_covariate cc1
INNER JOIN
(
select covariate_id, covariate_name, analysis_id, concept_id
from cohort_covariate_ref
where analysis_id > 100 and analysis_id < 300
) ccr1
ON cc1.covariate_id = ccr1.covariate_id
INNER JOIN
condition_group cg1
ON ccr1.concept_id = cg1.descendant_concept_id
INNER JOIN
cdm4_sim.concept c1
on cg1.ancestor_concept_id = c1.concept_id

Thank you for your help!

Trevor

from cohortmethod.

schuemie commented on June 12, 2024

Oops, this was caused by some things not being covered by SqlRender (not sure why it didn't show up in my tests).

Please update to the latest version of SqlRender (close all instances of R, start just one instance, and run install_github("ohdsi/SqlRender"). The problem should then be gone.

from cohortmethod.

tshaddox commented on June 12, 2024

Hi Martijn,

Well, that got me a bit farther. Now the error is at 81%. The errorReport.txt information is below:

DBMS:
postgresql

Error:
execute JDBC update query failed in dbSendUpdate (ERROR: syntax error at or near "insert"
Position: 72)

SQL:
insert into Charlson_codes (diag_category_id, icd9) values (1,'410')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.0')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.00')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.01')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.02')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.1')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.10')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.11')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.12')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.2')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.20')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.21')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.22')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.3')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.30')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.31')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.32')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.4')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.40')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.41')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.42')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.5')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.50')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.51')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.52')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.6')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.60')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.61')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.62')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.7')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.70')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.71')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.72')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.8')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.80')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.81')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.82')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.9')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.90')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.91')
insert into Charlson_codes (diag_category_id, icd9) values (1,'410.92')
insert into Charlson_codes (diag_category_id, icd9) values (1,'412')
insert into Charlson_codes (diag_category_id, icd9) values (2,'402.01')
insert into Charlson_codes (diag_category_id, icd9) values (2,'402.11')
insert into Charlson_codes (diag_category_id, icd9) values (2,'402.91')
insert into Charlson_codes (diag_category_id, icd9) values (2,'425')
insert into Charlson_codes (diag_category_id, icd9) values (2,'425.0')
insert into Charlson_codes (diag_category_id, icd9) values (2,'425.1')
insert into Charlson_codes (diag_category_id, icd9) values (2,'425.2')
insert into Charlson_codes (diag_category_id, icd9) values (2,'425.3')
insert into Charlson_codes (diag_category_id, icd9) values (2,'425.4')
insert into Charlson_codes (diag_category_id, icd9) values (2,'425.5')
insert into Charlson_codes (diag_category_id, icd9) values (2,'425.7')
insert into Charlson_codes (diag_category_id, icd9) values (2,'425.8')
insert into Charlson_codes (diag_category_id, icd9) values (2,'425.9')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.0')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.1')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.2')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.20')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.21')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.22')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.23')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.3')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.30')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.31')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.32')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.33')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.4')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.40')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.41')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.42')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.43')
insert into Charlson_codes (diag_category_id, icd9) values (2,'428.9')
insert into Charlson_codes (diag_category_id, icd9) values (2,'429.3')
insert into Charlson_codes (diag_category_id, icd9) values (3,'440')
insert into Charlson_codes (diag_category_id, icd9) values (3,'440.0')
insert into Charlson_codes (diag_category_id, icd9) values (3,'440.1')
insert into Charlson_codes (diag_category_id, icd9) values (3,'440.2')
insert into Charlson_codes (diag_category_id, icd9) values (3,'440.20')
insert into Charlson_codes (diag_category_id, icd9) values (3,'440.21')
insert into Charlson_codes (diag_category_id, icd9) values (3,'440.22')
insert into Charlson_codes (diag_category_id, icd9) values (3,'440.23')
insert into Charlson_codes (diag_category_id, icd9) values (3,'440.24')
insert into Charlson_codes (diag_category_id, icd9) values (3,'440.29')
insert into Charlson_codes (diag_category_id, icd9) values (3,'440.3')
insert into Charlson_codes (diag_category_id, icd9) values (3,'440.30')
insert into Charlson_codes (diag_category_id, icd9) values (3,'440.31')
insert into Charlson_codes (diag_category_id, icd9) values (3,'440.32')
insert into Charlson_codes (diag_category_id, icd9) values (3,'440.4')
insert into Charlson_codes (diag_category_id, icd9) values (3,'440.8')
insert into Charlson_codes (diag_category_id, icd9) values (3,'440.9')
insert into Charlson_codes (diag_category_id, icd9) values (3,'441')
insert into Charlson_codes (diag_category_id, icd9) values (3,'441.0')
insert into Charlson_codes (diag_category_id, icd9) values (3,'441.00')
insert into Charlson_codes (diag_category_id, icd9) values (3,'441.01')
insert into Charlson_codes (diag_category_id, icd9) values (3,'441.02')
insert into Charlson_codes (diag_category_id, icd9) values (3,'441.03')
insert into Charlson_codes (diag_category_id, icd9) values (3,'441.1')
insert into Charlson_codes (diag_category_id, icd9) values (3,'441.2')
insert into Charlson_codes (diag_category_id, icd9) values (3,'441.3')
insert into Charlson_codes (diag_category_id, icd9) values (3,'441.4')
insert into Charlson_codes (diag_category_id, icd9) values (3,'441.5')
insert into Charlson_codes (diag_category_id, icd9) values (3,'441.6')
insert into Charlson_codes (diag_category_id, icd9) values (3,'441.7')
insert into Charlson_codes (diag_category_id, icd9) values (3,'441.9')
insert into Charlson_codes (diag_category_id, icd9) values (3,'442')
insert into Charlson_codes (diag_category_id, icd9) values (3,'442.0')
insert into Charlson_codes (diag_category_id, icd9) values (3,'442.1')
insert into Charlson_codes (diag_category_id, icd9) values (3,'442.2')
insert into Charlson_codes (diag_category_id, icd9) values (3,'442.3')
insert into Charlson_codes (diag_category_id, icd9) values (3,'442.8')
insert into Charlson_codes (diag_category_id, icd9) values (3,'442.81')
insert into Charlson_codes (diag_category_id, icd9) values (3,'442.82')
insert into Charlson_codes (diag_category_id, icd9) values (3,'442.83')
insert into Charlson_codes (diag_category_id, icd9) values (3,'442.84')
insert into Charlson_codes (diag_category_id, icd9) values (3,'442.89')
insert into Charlson_codes (diag_category_id, icd9) values (3,'442.9')
insert into Charlson_codes (diag_category_id, icd9) values (3,'443.1')
insert into Charlson_codes (diag_category_id, icd9) values (3,'443.2')
insert into Charlson_codes (diag_category_id, icd9) values (3,'443.21')
insert into Charlson_codes (diag_category_id, icd9) values (3,'443.22')
insert into Charlson_codes (diag_category_id, icd9) values (3,'443.23')
insert into Charlson_codes (diag_category_id, icd9) values (3,'443.24')
insert into Charlson_codes (diag_category_id, icd9) values (3,'443.29')
insert into Charlson_codes (diag_category_id, icd9) values (3,'443.8')
insert into Charlson_codes (diag_category_id, icd9) values (3,'443.81')
insert into Charlson_codes (diag_category_id, icd9) values (3,'443.82')
insert into Charlson_codes (diag_category_id, icd9) values (3,'443.89')
insert into Charlson_codes (diag_category_id, icd9) values (3,'443.9')
insert into Charlson_codes (diag_category_id, icd9) values (3,'447.1')
insert into Charlson_codes (diag_category_id, icd9) values (3,'785.4')
insert into Charlson_codes (diag_category_id, icd9) values (4,'362.34')
insert into Charlson_codes (diag_category_id, icd9) values (4,'430')
insert into Charlson_codes (diag_category_id, icd9) values (4,'431')
insert into Charlson_codes (diag_category_id, icd9) values (4,'432')
insert into Charlson_codes (diag_category_id, icd9) values (4,'432.0')
insert into Charlson_codes (diag_category_id, icd9) values (4,'432.1')
insert into Charlson_codes (diag_category_id, icd9) values (4,'432.9')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.0')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.00')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.01')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.1')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.10')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.11')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.2')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.20')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.21')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.3')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.30')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.31')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.8')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.80')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.81')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.9')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.90')
insert into Charlson_codes (diag_category_id, icd9) values (4,'433.91')
insert into Charlson_codes (diag_category_id, icd9) values (4,'434')
insert into Charlson_codes (diag_category_id, icd9) values (4,'434.0')
insert into Charlson_codes (diag_category_id, icd9) values (4,'434.00')
insert into Charlson_codes (diag_category_id, icd9) values (4,'434.01')
insert into Charlson_codes (diag_category_id, icd9) values (4,'434.1')
insert into Charlson_codes (diag_category_id, icd9) values (4,'434.10')
insert into Charlson_codes (diag_category_id, icd9) values (4,'434.11')
insert into Charlson_codes (diag_category_id, icd9) values (4,'434.9')
insert into Charlson_codes (diag_category_id, icd9) values (4,'434.90')
insert into Charlson_codes (diag_category_id, icd9) values (4,'434.91')
insert into Charlson_codes (diag_category_id, icd9) values (4,'435')
insert into Charlson_codes (diag_category_id, icd9) values (4,'435.0')
insert into Charlson_codes (diag_category_id, icd9) values (4,'435.1')
insert into Charlson_codes (diag_category_id, icd9) values (4,'435.2')
insert into Charlson_codes (diag_category_id, icd9) values (4,'435.3')
insert into Charlson_codes (diag_category_id, icd9) values (4,'435.8')
insert into Charlson_codes (diag_category_id, icd9) values (4,'435.9')
insert into Charlson_codes (diag_category_id, icd9) values (4,'436')
insert into Charlson_codes (diag_category_id, icd9) values (4,'437')
insert into Charlson_codes (diag_category_id, icd9) values (4,'437.0')
insert into Charlson_codes (diag_category_id, icd9) values (4,'437.1')
insert into Charlson_codes (diag_category_id, icd9) values (4,'437.9')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.0')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.1')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.10')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.11')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.12')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.19')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.2')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.20')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.21')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.22')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.3')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.30')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.31')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.32')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.4')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.40')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.41')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.42')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.5')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.50')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.51')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.52')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.53')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.6')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.7')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.8')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.81')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.82')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.83')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.84')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.85')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.89')
insert into Charlson_codes (diag_category_id, icd9) values (4,'438.9')
insert into Charlson_codes (diag_category_id, icd9) values (4,'781.4')
insert into Charlson_codes (diag_category_id, icd9) values (4,'784.3')
insert into Charlson_codes (diag_category_id, icd9) values (4,'997.0')
insert into Charlson_codes (diag_category_id, icd9) values (4,'997.00')
insert into Charlson_codes (diag_category_id, icd9) values (4,'997.01')
insert into Charlson_codes (diag_category_id, icd9) values (4,'997.02')
insert into Charlson_codes (diag_category_id, icd9) values (4,'997.09')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290.0')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290.1')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290.10')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290.11')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290.12')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290.13')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290.2')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290.20')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290.21')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290.3')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290.4')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290.40')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290.41')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290.42')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290.43')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290.8')
insert into Charlson_codes (diag_category_id, icd9) values (5,'290.9')
insert into Charlson_codes (diag_category_id, icd9) values (5,'331')
insert into Charlson_codes (diag_category_id, icd9) values (5,'331.0')
insert into Charlson_codes (diag_category_id, icd9) values (5,'331.1')
insert into Charlson_codes (diag_category_id, icd9) values (5,'331.11')
insert into Charlson_codes (diag_category_id, icd9) values (5,'331.19')
insert into Charlson_codes (diag_category_id, icd9) values (5,'331.2')
insert into Charlson_codes (diag_category_id, icd9) values (6,'415.0')
insert into Charlson_codes (diag_category_id, icd9) values (6,'416.8')
insert into Charlson_codes (diag_category_id, icd9) values (6,'416.9')
insert into Charlson_codes (diag_category_id, icd9) values (6,'491')
insert into Charlson_codes (diag_category_id, icd9) values (6,'491.0')
insert into Charlson_codes (diag_category_id, icd9) values (6,'491.1')
insert into Charlson_codes (diag_category_id, icd9) values (6,'491.2')
insert into Charlson_codes (diag_category_id, icd9) values (6,'491.20')
insert into Charlson_codes (diag_category_id, icd9) values (6,'491.21')
insert into Charlson_codes (diag_category_id, icd9) values (6,'491.22')
insert into Charlson_codes (diag_category_id, icd9) values (6,'491.8')
insert into Charlson_codes (diag_category_id, icd9) values (6,'491.9')
insert into Charlson_codes (diag_category_id, icd9) values (6,'492')
insert into Charlson_codes (diag_category_id, icd9) values (6,'492.0')
insert into Charlson_codes (diag_category_id, icd9) values (6,'492.8')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.0')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.00')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.01')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.02')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.1')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.10')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.11')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.12')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.2')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.20')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.21')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.22')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.8')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.81')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.82')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.9')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.90')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.91')
insert into Charlson_codes (diag_category_id, icd9) values (6,'493.92')
insert into Charlson_codes (diag_category_id, icd9) values (6,'494')
insert into Charlson_codes (diag_category_id, icd9) values (7,'710')
insert into Charlson_codes (diag_category_id, icd9) values (7,'710.0')
insert into Charlson_codes (diag_category_id, icd9) values (7,'710.1')
insert into Charlson_codes (diag_category_id, icd9) values (7,'710.2')
insert into Charlson_codes (diag_category_id, icd9) values (7,'710.3')
insert into Charlson_codes (diag_category_id, icd9) values (7,'710.4')
insert into Charlson_codes (diag_category_id, icd9) values (7,'710.5')
insert into Charlson_codes (diag_category_id, icd9) values (7,'710.8')
insert into Charlson_codes (diag_category_id, icd9) values (7,'710.9')
insert into Charlson_codes (diag_category_id, icd9) values (7,'714')
insert into Charlson_codes (diag_category_id, icd9) values (7,'714.0')
insert into Charlson_codes (diag_category_id, icd9) values (7,'714.1')
insert into Charlson_codes (diag_category_id, icd9) values (7,'714.2')
insert into Charlson_codes (diag_category_id, icd9) values (7,'714.3')
insert into Charlson_codes (diag_category_id, icd9) values (7,'714.30')
insert into Charlson_codes (diag_category_id, icd9) values (7,'714.31')
insert into Charlson_codes (diag_category_id, icd9) values (7,'714.32')
insert into Charlson_codes (diag_category_id, icd9) values (7,'714.33')
insert into Charlson_codes (diag_category_id, icd9) values (7,'714.4')
insert into Charlson_codes (diag_category_id, icd9) values (7,'714.8')
insert into Charlson_codes (diag_category_id, icd9) values (7,'714.81')
insert into Charlson_codes (diag_category_id, icd9) values (7,'714.89')
insert into Charlson_codes (diag_category_id, icd9) values (7,'714.9')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.0')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.00')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.01')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.1')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.10')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.11')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.2')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.20')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.21')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.3')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.30')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.31')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.4')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.40')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.41')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.5')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.50')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.51')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.6')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.60')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.61')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.7')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.70')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.71')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.9')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.90')
insert into Charlson_codes (diag_category_id, icd9) values (8,'531.91')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.0')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.00')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.01')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.1')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.10')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.11')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.2')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.20')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.21')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.3')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.30')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.31')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.4')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.40')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.41')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.5')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.50')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.51')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.6')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.60')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.61')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.7')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.70')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.71')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.9')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.90')
insert into Charlson_codes (diag_category_id, icd9) values (8,'532.91')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.0')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.00')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.01')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.1')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.10')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.11')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.2')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.20')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.21')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.3')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.30')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.31')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.4')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.40')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.41')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.5')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.50')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.51')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.6')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.60')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.61')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.7')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.70')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.71')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.9')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.90')
insert into Charlson_codes (diag_category_id, icd9) values (8,'533.91')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.0')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.00')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.01')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.1')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.10')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.11')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.2')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.20')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.21')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.3')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.30')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.31')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.4')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.40')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.41')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.5')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.50')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.51')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.6')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.60')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.61')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.7')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.70')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.71')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.9')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.90')
insert into Charlson_codes (diag_category_id, icd9) values (8,'534.91')
insert into Charlson_codes (diag_category_id, icd9) values (9,'571.2')
insert into Charlson_codes (diag_category_id, icd9) values (9,'571.5')
insert into Charlson_codes (diag_category_id, icd9) values (9,'571.6')
insert into Charlson_codes (diag_category_id, icd9) values (9,'571.8')
insert into Charlson_codes (diag_category_id, icd9) values (9,'571.9')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.0')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.00')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.01')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.02')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.03')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.1')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.10')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.11')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.12')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.13')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.2')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.20')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.21')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.22')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.23')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.3')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.30')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.31')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.32')
insert into Charlson_codes (diag_category_id, icd9) values (10,'250.33')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.4')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.40')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.41')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.42')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.43')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.5')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.50')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.51')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.52')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.53')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.6')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.60')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.61')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.62')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.63')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.7')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.70')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.71')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.72')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.73')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.8')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.80')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.81')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.82')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.83')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.9')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.90')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.91')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.92')
insert into Charlson_codes (diag_category_id, icd9) values (11,'250.93')
insert into Charlson_codes (diag_category_id, icd9) values (12,'342')
insert into Charlson_codes (diag_category_id, icd9) values (12,'342.0')
insert into Charlson_codes (diag_category_id, icd9) values (12,'342.00')
insert into Charlson_codes (diag_category_id, icd9) values (12,'342.01')
insert into Charlson_codes (diag_category_id, icd9) values (12,'342.02')
insert into Charlson_codes (diag_category_id, icd9) values (12,'342.1')
insert into Charlson_codes (diag_category_id, icd9) values (12,'342.10')
insert into Charlson_codes (diag_category_id, icd9) values (12,'342.11')
insert into Charlson_codes (diag_category_id, icd9) values (12,'342.12')
insert into Charlson_codes (diag_category_id, icd9) values (12,'342.8')
insert into Charlson_codes (diag_category_id, icd9) values (12,'342.80')
insert into Charlson_codes (diag_category_id, icd9) values (12,'342.81')
insert into Charlson_codes (diag_category_id, icd9) values (12,'342.82')
insert into Charlson_codes (diag_category_id, icd9) values (12,'342.9')
insert into Charlson_codes (diag_category_id, icd9) values (12,'342.90')
insert into Charlson_codes (diag_category_id, icd9) values (12,'342.91')
insert into Charlson_codes (diag_category_id, icd9) values (12,'342.92')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.0')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.00')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.01')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.02')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.03')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.04')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.09')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.1')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.2')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.3')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.30')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.31')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.32')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.4')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.40')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.41')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.42')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.5')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.6')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.60')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.61')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.8')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.81')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.89')
insert into Charlson_codes (diag_category_id, icd9) values (12,'344.9')
insert into Charlson_codes (diag_category_id, icd9) values (13,'585')
insert into Charlson_codes (diag_category_id, icd9) values (13,'585.1')
insert into Charlson_codes (diag_category_id, icd9) values (13,'585.2')
insert into Charlson_codes (diag_category_id, icd9) values (13,'585.3')
insert into Charlson_codes (diag_category_id, icd9) values (13,'585.4')
insert into Charlson_codes (diag_category_id, icd9) values (13,'585.5')
insert into Charlson_codes (diag_category_id, icd9) values (13,'585.6')
insert into Charlson_codes (diag_category_id, icd9) values (13,'585.9')
insert into Charlson_codes (diag_category_id, icd9) values (13,'586')
insert into Charlson_codes (diag_category_id, icd9) values (13,'V42.0')
insert into Charlson_codes (diag_category_id, icd9) values (13,'V45.1')
insert into Charlson_codes (diag_category_id, icd9) values (13,'V45.11')
insert into Charlson_codes (diag_category_id, icd9) values (13,'V45.12')
insert into Charlson_codes (diag_category_id, icd9) values (13,'V56')
insert into Charlson_codes (diag_category_id, icd9) values (13,'V56.0')
insert into Charlson_codes (diag_category_id, icd9) values (13,'V56.1')
insert into Charlson_codes (diag_category_id, icd9) values (13,'V56.2')
insert into Charlson_codes (diag_category_id, icd9) values (13,'V56.3')
insert into Charlson_codes (diag_category_id, icd9) values (13,'V56.31')
insert into Charlson_codes (diag_category_id, icd9) values (13,'V56.32')
insert into Charlson_codes (diag_category_id, icd9) values (13,'V56.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'140')
insert into Charlson_codes (diag_category_id, icd9) values (14,'140.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'140.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'140.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'140.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'140.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'140.6')
insert into Charlson_codes (diag_category_id, icd9) values (14,'140.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'140.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'141')
insert into Charlson_codes (diag_category_id, icd9) values (14,'141.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'141.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'141.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'141.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'141.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'141.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'141.6')
insert into Charlson_codes (diag_category_id, icd9) values (14,'141.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'141.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'142')
insert into Charlson_codes (diag_category_id, icd9) values (14,'142.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'142.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'142.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'142.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'142.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'143')
insert into Charlson_codes (diag_category_id, icd9) values (14,'143.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'143.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'143.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'143.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'144')
insert into Charlson_codes (diag_category_id, icd9) values (14,'144.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'144.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'144.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'144.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'145')
insert into Charlson_codes (diag_category_id, icd9) values (14,'145.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'145.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'145.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'145.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'145.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'145.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'145.6')
insert into Charlson_codes (diag_category_id, icd9) values (14,'145.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'145.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'146')
insert into Charlson_codes (diag_category_id, icd9) values (14,'146.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'146.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'146.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'146.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'146.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'146.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'146.6')
insert into Charlson_codes (diag_category_id, icd9) values (14,'146.7')
insert into Charlson_codes (diag_category_id, icd9) values (14,'146.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'146.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'147')
insert into Charlson_codes (diag_category_id, icd9) values (14,'147.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'147.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'147.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'147.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'147.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'147.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'148')
insert into Charlson_codes (diag_category_id, icd9) values (14,'148.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'148.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'148.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'148.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'148.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'148.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'149')
insert into Charlson_codes (diag_category_id, icd9) values (14,'149.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'149.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'149.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'149.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'150')
insert into Charlson_codes (diag_category_id, icd9) values (14,'150.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'150.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'150.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'150.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'150.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'150.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'150.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'150.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'151')
insert into Charlson_codes (diag_category_id, icd9) values (14,'151.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'151.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'151.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'151.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'151.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'151.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'151.6')
insert into Charlson_codes (diag_category_id, icd9) values (14,'151.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'151.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'152')
insert into Charlson_codes (diag_category_id, icd9) values (14,'152.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'152.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'152.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'152.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'152.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'152.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'153')
insert into Charlson_codes (diag_category_id, icd9) values (14,'153.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'153.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'153.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'153.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'153.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'153.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'153.6')
insert into Charlson_codes (diag_category_id, icd9) values (14,'153.7')
insert into Charlson_codes (diag_category_id, icd9) values (14,'153.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'153.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'154')
insert into Charlson_codes (diag_category_id, icd9) values (14,'154.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'154.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'154.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'154.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'154.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'155')
insert into Charlson_codes (diag_category_id, icd9) values (14,'155.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'155.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'155.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'156')
insert into Charlson_codes (diag_category_id, icd9) values (14,'156.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'156.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'156.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'156.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'156.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'157')
insert into Charlson_codes (diag_category_id, icd9) values (14,'157.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'157.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'157.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'157.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'157.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'157.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'157.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'158')
insert into Charlson_codes (diag_category_id, icd9) values (14,'158.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'158.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'158.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'159')
insert into Charlson_codes (diag_category_id, icd9) values (14,'159.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'159.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'159.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'159.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'160')
insert into Charlson_codes (diag_category_id, icd9) values (14,'160.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'160.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'160.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'160.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'160.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'160.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'160.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'160.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'161')
insert into Charlson_codes (diag_category_id, icd9) values (14,'161.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'161.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'161.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'161.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'161.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'161.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'162')
insert into Charlson_codes (diag_category_id, icd9) values (14,'162.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'162.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'162.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'162.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'162.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'162.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'162.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'163')
insert into Charlson_codes (diag_category_id, icd9) values (14,'163.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'163.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'163.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'163.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'164')
insert into Charlson_codes (diag_category_id, icd9) values (14,'164.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'164.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'164.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'164.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'164.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'164.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'165')
insert into Charlson_codes (diag_category_id, icd9) values (14,'165.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'165.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'165.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'170')
insert into Charlson_codes (diag_category_id, icd9) values (14,'170.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'170.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'170.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'170.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'170.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'170.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'170.6')
insert into Charlson_codes (diag_category_id, icd9) values (14,'170.7')
insert into Charlson_codes (diag_category_id, icd9) values (14,'170.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'170.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'171')
insert into Charlson_codes (diag_category_id, icd9) values (14,'171.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'171.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'171.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'171.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'171.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'171.6')
insert into Charlson_codes (diag_category_id, icd9) values (14,'171.7')
insert into Charlson_codes (diag_category_id, icd9) values (14,'171.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'171.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'174')
insert into Charlson_codes (diag_category_id, icd9) values (14,'174.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'174.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'174.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'174.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'174.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'174.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'174.6')
insert into Charlson_codes (diag_category_id, icd9) values (14,'174.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'174.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'175')
insert into Charlson_codes (diag_category_id, icd9) values (14,'175.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'175.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'176')
insert into Charlson_codes (diag_category_id, icd9) values (14,'176.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'176.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'176.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'176.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'176.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'176.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'176.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'176.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'179')
insert into Charlson_codes (diag_category_id, icd9) values (14,'180')
insert into Charlson_codes (diag_category_id, icd9) values (14,'180.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'180.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'180.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'180.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'181')
insert into Charlson_codes (diag_category_id, icd9) values (14,'182')
insert into Charlson_codes (diag_category_id, icd9) values (14,'182.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'182.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'182.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'183')
insert into Charlson_codes (diag_category_id, icd9) values (14,'183.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'183.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'183.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'183.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'183.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'183.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'183.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'184')
insert into Charlson_codes (diag_category_id, icd9) values (14,'184.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'184.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'184.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'184.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'184.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'184.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'184.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'185')
insert into Charlson_codes (diag_category_id, icd9) values (14,'186')
insert into Charlson_codes (diag_category_id, icd9) values (14,'186.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'186.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'187')
insert into Charlson_codes (diag_category_id, icd9) values (14,'187.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'187.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'187.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'187.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'187.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'187.6')
insert into Charlson_codes (diag_category_id, icd9) values (14,'187.7')
insert into Charlson_codes (diag_category_id, icd9) values (14,'187.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'187.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'188')
insert into Charlson_codes (diag_category_id, icd9) values (14,'188.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'188.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'188.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'188.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'188.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'188.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'188.6')
insert into Charlson_codes (diag_category_id, icd9) values (14,'188.7')
insert into Charlson_codes (diag_category_id, icd9) values (14,'188.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'188.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'189')
insert into Charlson_codes (diag_category_id, icd9) values (14,'189.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'189.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'189.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'189.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'189.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'189.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'189.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'190')
insert into Charlson_codes (diag_category_id, icd9) values (14,'190.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'190.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'190.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'190.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'190.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'190.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'190.6')
insert into Charlson_codes (diag_category_id, icd9) values (14,'190.7')
insert into Charlson_codes (diag_category_id, icd9) values (14,'190.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'190.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'191')
insert into Charlson_codes (diag_category_id, icd9) values (14,'191.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'191.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'191.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'191.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'191.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'191.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'191.6')
insert into Charlson_codes (diag_category_id, icd9) values (14,'191.7')
insert into Charlson_codes (diag_category_id, icd9) values (14,'191.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'191.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'192')
insert into Charlson_codes (diag_category_id, icd9) values (14,'192.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'192.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'192.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'192.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'192.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'192.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'193')
insert into Charlson_codes (diag_category_id, icd9) values (14,'194')
insert into Charlson_codes (diag_category_id, icd9) values (14,'194.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'194.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'194.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'194.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'194.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'194.6')
insert into Charlson_codes (diag_category_id, icd9) values (14,'194.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'194.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'195')
insert into Charlson_codes (diag_category_id, icd9) values (14,'195.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'195.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'195.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'195.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'195.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'195.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'195.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.00')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.01')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.02')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.03')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.04')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.05')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.06')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.07')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.08')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.10')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.11')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.12')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.13')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.14')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.15')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.16')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.17')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.18')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.20')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.21')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.22')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.23')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.24')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.25')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.26')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.27')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.28')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.30')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.31')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.32')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.33')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.34')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.35')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.36')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.37')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.38')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.40')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.41')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.42')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.43')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.44')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.45')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.46')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.47')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.48')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.50')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.51')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.52')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.54')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.55')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.56')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.58')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.60')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.61')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.62')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.63')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.64')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.65')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.66')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.67')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.68')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.7')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.70')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.71')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.72')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.73')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.74')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.75')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.76')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.77')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.78')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.80')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.81')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.82')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.83')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.84')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.85')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.86')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.87')
insert into Charlson_codes (diag_category_id, icd9) values (14,'200.88')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.00')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.01')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.02')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.03')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.04')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.05')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.06')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.07')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.08')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.10')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.11')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.12')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.13')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.14')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.15')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.16')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.17')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.18')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.20')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.21')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.22')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.23')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.24')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.25')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.26')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.27')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.28')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.40')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.41')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.42')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.43')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.44')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.45')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.46')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.47')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.48')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.50')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.51')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.52')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.53')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.54')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.55')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.56')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.57')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.58')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.6')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.60')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.61')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.62')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.63')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.64')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.65')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.66')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.67')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.68')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.7')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.70')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.71')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.72')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.73')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.74')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.75')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.76')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.77')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.78')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.90')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.91')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.92')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.93')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.94')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.95')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.96')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.97')
insert into Charlson_codes (diag_category_id, icd9) values (14,'201.98')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.00')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.01')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.02')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.03')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.04')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.05')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.06')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.07')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.08')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.10')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.11')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.12')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.13')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.14')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.15')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.16')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.17')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.18')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.20')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.21')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.22')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.23')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.24')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.25')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.26')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.27')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.28')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.30')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.31')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.32')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.33')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.34')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.35')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.36')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.37')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.38')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.4')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.40')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.41')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.42')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.43')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.44')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.45')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.46')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.47')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.48')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.5')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.50')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.51')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.52')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.53')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.54')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.55')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.56')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.57')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.58')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.6')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.60')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.61')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.62')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.63')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.64')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.65')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.66')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.67')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.68')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.7')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.70')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.71')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.72')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.73')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.74')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.75')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.76')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.77')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.78')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.80')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.81')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.82')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.83')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.84')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.85')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.86')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.87')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.88')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.90')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.91')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.92')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.93')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.94')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.95')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.96')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.97')
insert into Charlson_codes (diag_category_id, icd9) values (14,'202.98')
insert into Charlson_codes (diag_category_id, icd9) values (14,'203')
insert into Charlson_codes (diag_category_id, icd9) values (14,'203.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'203.00')
insert into Charlson_codes (diag_category_id, icd9) values (14,'203.01')
insert into Charlson_codes (diag_category_id, icd9) values (14,'203.02')
insert into Charlson_codes (diag_category_id, icd9) values (14,'203.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'203.10')
insert into Charlson_codes (diag_category_id, icd9) values (14,'203.11')
insert into Charlson_codes (diag_category_id, icd9) values (14,'203.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'203.80')
insert into Charlson_codes (diag_category_id, icd9) values (14,'203.81')
insert into Charlson_codes (diag_category_id, icd9) values (14,'204')
insert into Charlson_codes (diag_category_id, icd9) values (14,'204.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'204.00')
insert into Charlson_codes (diag_category_id, icd9) values (14,'204.01')
insert into Charlson_codes (diag_category_id, icd9) values (14,'204.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'204.10')
insert into Charlson_codes (diag_category_id, icd9) values (14,'204.11')
insert into Charlson_codes (diag_category_id, icd9) values (14,'204.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'204.20')
insert into Charlson_codes (diag_category_id, icd9) values (14,'204.21')
insert into Charlson_codes (diag_category_id, icd9) values (14,'204.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'204.80')
insert into Charlson_codes (diag_category_id, icd9) values (14,'204.81')
insert into Charlson_codes (diag_category_id, icd9) values (14,'204.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'204.90')
insert into Charlson_codes (diag_category_id, icd9) values (14,'204.91')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.00')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.01')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.02')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.10')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.11')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.20')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.21')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.22')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.30')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.31')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.80')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.81')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.90')
insert into Charlson_codes (diag_category_id, icd9) values (14,'205.91')
insert into Charlson_codes (diag_category_id, icd9) values (14,'206')
insert into Charlson_codes (diag_category_id, icd9) values (14,'206.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'206.00')
insert into Charlson_codes (diag_category_id, icd9) values (14,'206.01')
insert into Charlson_codes (diag_category_id, icd9) values (14,'206.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'206.10')
insert into Charlson_codes (diag_category_id, icd9) values (14,'206.11')
insert into Charlson_codes (diag_category_id, icd9) values (14,'206.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'206.20')
insert into Charlson_codes (diag_category_id, icd9) values (14,'206.21')
insert into Charlson_codes (diag_category_id, icd9) values (14,'206.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'206.80')
insert into Charlson_codes (diag_category_id, icd9) values (14,'206.81')
insert into Charlson_codes (diag_category_id, icd9) values (14,'206.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'206.90')
insert into Charlson_codes (diag_category_id, icd9) values (14,'206.91')
insert into Charlson_codes (diag_category_id, icd9) values (14,'207')
insert into Charlson_codes (diag_category_id, icd9) values (14,'207.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'207.00')
insert into Charlson_codes (diag_category_id, icd9) values (14,'207.01')
insert into Charlson_codes (diag_category_id, icd9) values (14,'207.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'207.10')
insert into Charlson_codes (diag_category_id, icd9) values (14,'207.11')
insert into Charlson_codes (diag_category_id, icd9) values (14,'207.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'207.20')
insert into Charlson_codes (diag_category_id, icd9) values (14,'207.21')
insert into Charlson_codes (diag_category_id, icd9) values (14,'207.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'207.80')
insert into Charlson_codes (diag_category_id, icd9) values (14,'207.81')
insert into Charlson_codes (diag_category_id, icd9) values (14,'208')
insert into Charlson_codes (diag_category_id, icd9) values (14,'208.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'208.00')
insert into Charlson_codes (diag_category_id, icd9) values (14,'208.01')
insert into Charlson_codes (diag_category_id, icd9) values (14,'208.1')
insert into Charlson_codes (diag_category_id, icd9) values (14,'208.10')
insert into Charlson_codes (diag_category_id, icd9) values (14,'208.11')
insert into Charlson_codes (diag_category_id, icd9) values (14,'208.2')
insert into Charlson_codes (diag_category_id, icd9) values (14,'208.20')
insert into Charlson_codes (diag_category_id, icd9) values (14,'208.21')
insert into Charlson_codes (diag_category_id, icd9) values (14,'208.8')
insert into Charlson_codes (diag_category_id, icd9) values (14,'208.80')
insert into Charlson_codes (diag_category_id, icd9) values (14,'208.81')
insert into Charlson_codes (diag_category_id, icd9) values (14,'208.9')
insert into Charlson_codes (diag_category_id, icd9) values (14,'208.90')
insert into Charlson_codes (diag_category_id, icd9) values (14,'208.91')
insert into Charlson_codes (diag_category_id, icd9) values (14,'208.92')
insert into Charlson_codes (diag_category_id, icd9) values (14,'273.0')
insert into Charlson_codes (diag_category_id, icd9) values (14,'273.3')
insert into Charlson_codes (diag_category_id, icd9) values (14,'V10.46')
insert into Charlson_codes (diag_category_id, icd9) values (15,'456.0')
insert into Charlson_codes (diag_category_id, icd9) values (15,'456.1')
insert into Charlson_codes (diag_category_id, icd9) values (15,'456.2')
insert into Charlson_codes (diag_category_id, icd9) values (15,'456.20')
insert into Charlson_codes (diag_category_id, icd9) values (15,'456.21')
insert into Charlson_codes (diag_category_id, icd9) values (15,'572.2')
insert into Charlson_codes (diag_category_id, icd9) values (15,'572.3')
insert into Charlson_codes (diag_category_id, icd9) values (15,'572.4')
insert into Charlson_codes (diag_category_id, icd9) values (16,'196')
insert into Charlson_codes (diag_category_id, icd9) values (16,'196.0')
insert into Charlson_codes (diag_category_id, icd9) values (16,'196.1')
insert into Charlson_codes (diag_category_id, icd9) values (16,'196.2')
insert into Charlson_codes (diag_category_id, icd9) values (16,'196.3')
insert into Charlson_codes (diag_category_id, icd9) values (16,'196.5')
insert into Charlson_codes (diag_category_id, icd9) values (16,'196.6')
insert into Charlson_codes (diag_category_id, icd9) values (16,'196.8')
insert into Charlson_codes (diag_category_id, icd9) values (16,'196.9')
insert into Charlson_codes (diag_category_id, icd9) values (16,'197')
insert into Charlson_codes (diag_category_id, icd9) values (16,'197.0')
insert into Charlson_codes (diag_category_id, icd9) values (16,'197.1')
insert into Charlson_codes (diag_category_id, icd9) values (16,'197.2')
insert into Charlson_codes (diag_category_id, icd9) values (16,'197.3')
insert into Charlson_codes (diag_category_id, icd9) values (16,'197.4')
insert into Charlson_codes (diag_category_id, icd9) values (16,'197.5')
insert into Charlson_codes (diag_category_id, icd9) values (16,'197.6')
insert into Charlson_codes (diag_category_id, icd9) values (16,'197.7')
insert into Charlson_codes (diag_category_id, icd9) values (16,'197.8')
insert into Charlson_codes (diag_category_id, icd9) values (16,'198')
insert into Charlson_codes (diag_category_id, icd9) values (16,'198.0')
insert into Charlson_codes (diag_category_id, icd9) values (16,'198.1')
insert into Charlson_codes (diag_category_id, icd9) values (16,'198.2')
insert into Charlson_codes (diag_category_id, icd9) values (16,'198.3')
insert into Charlson_codes (diag_category_id, icd9) values (16,'198.4')
insert into Charlson_codes (diag_category_id, icd9) values (16,'198.5')
insert into Charlson_codes (diag_category_id, icd9) values (16,'198.6')
insert into Charlson_codes (diag_category_id, icd9) values (16,'198.7')
insert into Charlson_codes (diag_category_id, icd9) values (16,'198.8')
insert into Charlson_codes (diag_category_id, icd9) values (16,'198.81')
insert into Charlson_codes (diag_category_id, icd9) values (16,'198.82')
insert into Charlson_codes (diag_category_id, icd9) values (16,'198.89')
insert into Charlson_codes (diag_category_id, icd9) values (16,'199')
insert into Charlson_codes (diag_category_id, icd9) values (16,'199.0')
insert into Charlson_codes (diag_category_id, icd9) values (16,'199.1')
insert into Charlson_codes (diag_category_id, icd9) values (17,'042')

insert into Charlson_scoring (diag_category_id, diag_category_name, weight) values (1,'Myocardial infarction', 1)
insert into Charlson_scoring (diag_category_id, diag_category_name, weight) values (2,'Congestive heart failure', 1)
insert into Charlson_scoring (diag_category_id, diag_category_name, weight) values (3,'Peripheral vascular disease', 1)
insert into Charlson_scoring (diag_category_id, diag_category_name, weight) values (4,'Cerebrovascular disease', 1)
insert into Charlson_scoring (diag_category_id, diag_category_name, weight) values (5,'Dementia', 1)
insert into Charlson_scoring (diag_category_id, diag_category_name, weight) values (6,'Chronic pulmonary disease', 1)
insert into Charlson_scoring (diag_category_id, diag_category_name, weight) values (7,'Rheumatologic disease', 1)
insert into Charlson_scoring (diag_category_id, diag_category_name, weight) values (8,'Peptic ulcer disease', 1)
insert into Charlson_scoring (diag_category_id, diag_category_name, weight) values (9,'Mild liver disease', 1)
insert into Charlson_scoring (diag_category_id, diag_category_name, weight) values (10,'Diabetes (mild to moderate)', 1)
insert into Charlson_scoring (diag_category_id, diag_category_name, weight) values (11,'Diabetes with chronic complications', 2)
insert into Charlson_scoring (diag_category_id, diag_category_name, weight) values (12,'Hemoplegia or paralegia', 2)
insert into Charlson_scoring (diag_category_id, diag_category_name, weight) values (13,'Renal disease', 2)
insert into Charlson_scoring (diag_category_id, diag_category_name, weight) values (14,'Any malignancy', 2)
insert into Charlson_scoring (diag_category_id, diag_category_name, weight) values (15,'Moderate to severe liver disease', 3)
insert into Charlson_scoring (diag_category_id, diag_category_name, weight) values (16,'Metastatic solid tumor', 6)
insert into Charlson_scoring (diag_category_id, diag_category_name, weight) values (17,'AIDS', 6)   




INSERT INTO cohort_covariate_ref (covariate_id, covariate_name, analysis_id, concept_id)
VALUES (1100, 'Charlson Index - Romano adaptation, using conditions all time on or prior to cohort index', 1100, 0)

Thank you for your help!

Trevor

from cohortmethod.

schuemie commented on June 12, 2024

So sorry Trevor! This problem has now been fixed (see c6bfe9f) . Please update to the lasted version of the CohortMethod package.

I see now that I was lazy and hadn't tested with all covariates turned on. It should now all work on Postgres (and Oracle).

from cohortmethod.

tshaddox commented on June 12, 2024

Awesome! That worked for me. Thank you for your help!

from cohortmethod.

Error reproducing vignette in postgresql about cohortmethod HOT 6 CLOSED

Comments (6)

Related Issues (20)

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent