2023-02-25 16:41:50	[Main thread]	INFO	Achilles	achilles	Beginning single-threaded execution
2023-02-25 16:41:50	[Main thread]	INFO	DatabaseConnector	connectSqlServer	Connecting using SQL Server driver
2023-02-25 16:41:51	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.107 secs
2023-02-25 16:41:51	[Main thread]	INFO	DatabaseConnector	insertTable.default	Inserting data took 0.386 secs
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	Executing multiple queries. This could take a while
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	Analysis 1 (Number of persons) -- START
2023-02-25 16:41:52	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0438 secs
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1 (0.047109 secs)
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	Analysis 2 (Number of persons by gender) -- START
2023-02-25 16:41:52	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0455 secs
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2 (0.048548 secs)
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	Analysis 3 (Number of persons by year of birth) -- START
2023-02-25 16:41:52	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.05 secs
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 3 (0.053302 secs)
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	Analysis 4 (Number of persons by race) -- START
2023-02-25 16:41:52	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0407 secs
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 4 (0.043738 secs)
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	Analysis 5 (Number of persons by ethnicity) -- START
2023-02-25 16:41:52	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0438 secs
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 5 (0.046721 secs)
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	Analysis 7 (Number of persons with invalid provider_id) -- START
2023-02-25 16:41:52	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0453 secs
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 7 (0.047724 secs)
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	Analysis 8 (Number of persons with invalid location_id) -- START
2023-02-25 16:41:52	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0542 secs
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 8 (0.057881 secs)
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	Analysis 9 (Number of persons with invalid care_site_id) -- START
2023-02-25 16:41:52	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0444 secs
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 9 (0.047698 secs)
2023-02-25 16:41:52	[Main thread]	INFO	Achilles	achilles	Analysis 10 (Number of all persons by year of birth by gender) -- START
2023-02-25 16:41:53	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0459 secs
2023-02-25 16:41:53	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 10 (0.049231 secs)
2023-02-25 16:41:53	[Main thread]	INFO	Achilles	achilles	Analysis 11 (Number of non-deceased persons by year of birth by gender) -- START
2023-02-25 16:41:53	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0523 secs
2023-02-25 16:41:53	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 11 (0.055609 secs)
2023-02-25 16:41:53	[Main thread]	INFO	Achilles	achilles	Analysis 12 (Number of persons by race and ethnicity) -- START
2023-02-25 16:41:53	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0601 secs
2023-02-25 16:41:53	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 12 (0.062456 secs)
2023-02-25 16:41:53	[Main thread]	INFO	Achilles	achilles	Analysis 101 (Number of persons by age, with age at first observation period) -- START
2023-02-25 16:41:53	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0464 secs
2023-02-25 16:41:53	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 101 (0.049724 secs)
2023-02-25 16:41:53	[Main thread]	INFO	Achilles	achilles	Analysis 102 (Number of persons by gender by age, with age at first observation period) -- START
2023-02-25 16:41:53	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0426 secs
2023-02-25 16:41:53	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 102 (0.045916 secs)
2023-02-25 16:41:53	[Main thread]	INFO	Achilles	achilles	Analysis 103 (Distribution of age at first observation period) -- START
2023-02-25 16:41:53	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0539 secs
2023-02-25 16:41:53	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 103 (0.057252 secs)
2023-02-25 16:41:53	[Main thread]	INFO	Achilles	achilles	Analysis 104 (Distribution of age at first observation period by gender) -- START
2023-02-25 16:41:53	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.194 secs
2023-02-25 16:41:53	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 104 (0.197045 secs)
2023-02-25 16:41:53	[Main thread]	INFO	Achilles	achilles	Analysis 105 (Length of observation (days) of first observation period) -- START
2023-02-25 16:41:53	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.405 secs
2023-02-25 16:41:53	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 105 (0.408059 secs)
2023-02-25 16:41:53	[Main thread]	INFO	Achilles	achilles	Analysis 106 (Length of observation (days) of first observation period by gender) -- START
2023-02-25 16:41:54	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.275 secs
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 106 (0.277628 secs)
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	Analysis 107 (Length of observation (days) of first observation period by age decile) -- START
2023-02-25 16:41:54	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.169 secs
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 107 (0.171628 secs)
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	Analysis 108 (Number of persons by length of observation period, in 30d increments) -- START
2023-02-25 16:41:54	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0479 secs
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 108 (0.050910 secs)
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	Analysis 109 (Number of persons with continuous observation in each year) -- START
2023-02-25 16:41:54	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0542 secs
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 109 (0.056837 secs)
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	Analysis 110 (Number of persons with continuous observation in each month) -- START
2023-02-25 16:41:54	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0464 secs
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 110 (0.049495 secs)
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	Analysis 111 (Number of persons by observation period start month) -- START
2023-02-25 16:41:54	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0436 secs
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 111 (0.046543 secs)
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	Analysis 112 (Number of persons by observation period end month) -- START
2023-02-25 16:41:54	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0439 secs
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 112 (0.047453 secs)
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	Analysis 113 (Number of persons by number of observation periods) -- START
2023-02-25 16:41:54	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.042 secs
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 113 (0.045399 secs)
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	Analysis 114 (Number of persons with observation period before year-of-birth) -- START
2023-02-25 16:41:54	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0429 secs
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 114 (0.046202 secs)
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	Analysis 115 (Number of persons with observation period end < observation period start) -- START
2023-02-25 16:41:54	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0433 secs
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 115 (0.046617 secs)
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	Analysis 116 (Number of persons with at least one day of observation in each year by gender and age decile) -- START
2023-02-25 16:41:54	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.172 secs
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 116 (0.175837 secs)
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	Analysis 117 (Number of persons with at least one day of observation in each month) -- START
2023-02-25 16:41:54	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0659 secs
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 117 (0.068680 secs)
2023-02-25 16:41:54	[Main thread]	INFO	Achilles	achilles	Analysis 118 (Number of observation periods with invalid person_id) -- START
2023-02-25 16:41:55	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.043 secs
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 118 (0.046486 secs)
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	Analysis 119 (Number of observation period records by period_type_concept_id) -- START
2023-02-25 16:41:55	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0429 secs
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 119 (0.045946 secs)
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	Analysis 200 (Number of persons with at least one visit occurrence, by visit_concept_id) -- START
2023-02-25 16:41:55	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.183 secs
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 200 (0.186046 secs)
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	Analysis 201 (Number of visit occurrence records, by visit_concept_id) -- START
2023-02-25 16:41:55	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0453 secs
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 201 (0.047680 secs)
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	Analysis 202 (Number of persons by visit occurrence start month, by visit_concept_id) -- START
2023-02-25 16:41:55	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0448 secs
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 202 (0.048203 secs)
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	Analysis 203 (Number of distinct visit occurrence concepts per person) -- START
2023-02-25 16:41:55	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.198 secs
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 203 (0.201014 secs)
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	Analysis 204 (Number of persons with at least one visit occurrence, by visit_concept_id by calendar year by gender by age decile) -- START
2023-02-25 16:41:55	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0502 secs
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 204 (0.053542 secs)
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	Analysis 206 (Distribution of age by visit_concept_id) -- START
2023-02-25 16:41:55	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.173 secs
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 206 (0.175967 secs)
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	Analysis 207 (Number of visit records with invalid person_id) -- START
2023-02-25 16:41:55	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0499 secs
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 207 (0.053223 secs)
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	Analysis 209 (Number of visit records with invalid care_site_id) -- START
2023-02-25 16:41:55	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0732 secs
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 209 (0.076609 secs)
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	Analysis 210 (Number of visit_occurrence records outside a valid observation period) -- START
2023-02-25 16:41:55	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0448 secs
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 210 (0.047528 secs)
2023-02-25 16:41:55	[Main thread]	INFO	Achilles	achilles	Analysis 211 (Number of visit records with end date < start date) -- START
2023-02-25 16:41:56	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0451 secs
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 211 (0.047285 secs)
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	Analysis 212 (Number of persons with at least one visit occurrence, by calendar year by gender by age decile) -- START
2023-02-25 16:41:56	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0512 secs
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 212 (0.053909 secs)
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	Analysis 213 (Distribution of length of stay by visit_concept_id) -- START
2023-02-25 16:41:56	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.257 secs
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 213 (0.260347 secs)
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	Analysis 220 (Number of visit occurrence records by visit occurrence start month) -- START
2023-02-25 16:41:56	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0494 secs
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 220 (0.052737 secs)
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	Analysis 221 (Number of persons by visit start year) -- START
2023-02-25 16:41:56	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0471 secs
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 221 (0.049972 secs)
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	Analysis 225 (Number of visit_occurrence records by visit_source_concept_id) -- START
2023-02-25 16:41:56	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0521 secs
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 225 (0.055472 secs)
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	Analysis 226 (Number of records by domain by visit_concept_id) -- START
2023-02-25 16:41:56	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0663 secs
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 226 (0.069568 secs)
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	Analysis 230 (Number of visit_occurrence records inside valid observation period) -- START
2023-02-25 16:41:56	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0482 secs
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 230 (0.051661 secs)
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	Analysis 231 (Proportion of people with at least one visit_occurrence record outside a valid observation period) -- START
2023-02-25 16:41:56	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.103 secs
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 231 (0.106565 secs)
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	Analysis 232 (Proportion of visit_occurrence records outside a valid observation period) -- START
2023-02-25 16:41:56	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.07 secs
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 232 (0.072735 secs)
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	Analysis 300 (Number of providers) -- START
2023-02-25 16:41:56	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0445 secs
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 300 (0.047962 secs)
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	Analysis 301 (Number of providers by specialty concept_id) -- START
2023-02-25 16:41:56	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0446 secs
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 301 (0.047065 secs)
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	Analysis 303 (Number of providers records by specialty_concept_id and visit_concept_id) -- START
2023-02-25 16:41:56	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0578 secs
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 303 (0.060568 secs)
2023-02-25 16:41:56	[Main thread]	INFO	Achilles	achilles	Analysis 325 (Number of provider records by specialty_source_concept_id) -- START
2023-02-25 16:41:57	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0411 secs
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 325 (0.043335 secs)
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	Analysis 400 (Number of persons with at least one condition occurrence, by condition_concept_id) -- START
2023-02-25 16:41:57	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.044 secs
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 400 (0.047062 secs)
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	Analysis 401 (Number of condition occurrence records, by condition_concept_id) -- START
2023-02-25 16:41:57	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0425 secs
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 401 (0.045044 secs)
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	Analysis 402 (Number of persons by condition occurrence start month, by condition_concept_id) -- START
2023-02-25 16:41:57	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0817 secs
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 402 (0.084534 secs)
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	Analysis 403 (Number of distinct condition occurrence concepts per person) -- START
2023-02-25 16:41:57	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.214 secs
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 403 (0.216283 secs)
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	Analysis 404 (Number of persons with at least one condition occurrence, by condition_concept_id by calendar year by gender by age decile) -- START
2023-02-25 16:41:57	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0439 secs
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 404 (0.046553 secs)
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	Analysis 405 (Number of condition occurrence records, by condition_concept_id by condition_type_concept_id) -- START
2023-02-25 16:41:57	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0428 secs
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 405 (0.045403 secs)
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	Analysis 406 (Distribution of age by condition_concept_id) -- START
2023-02-25 16:41:57	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.283 secs
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 406 (0.285970 secs)
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	Analysis 409 (Number of condition occurrence records with invalid person_id) -- START
2023-02-25 16:41:57	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0418 secs
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 409 (0.044625 secs)
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	Analysis 410 (Number of condition occurrence records outside valid observation period) -- START
2023-02-25 16:41:57	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0429 secs
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 410 (0.045195 secs)
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	Analysis 411 (Number of condition occurrence records with end date < start date) -- START
2023-02-25 16:41:57	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0421 secs
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 411 (0.045493 secs)
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	Analysis 412 (Number of condition occurrence records with invalid provider_id) -- START
2023-02-25 16:41:57	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0425 secs
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 412 (0.045712 secs)
2023-02-25 16:41:57	[Main thread]	INFO	Achilles	achilles	Analysis 413 (Number of condition occurrence records with invalid visit_id) -- START
2023-02-25 16:41:58	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0403 secs
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 413 (0.044183 secs)
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	Analysis 414 (Number of condition occurrence records, by condition_status_concept_id) -- START
2023-02-25 16:41:58	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0447 secs
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 414 (0.047745 secs)
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	Analysis 415 (Number of condition occurrence records, by condition_type_concept_id) -- START
2023-02-25 16:41:58	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0441 secs
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 415 (0.046634 secs)
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	Analysis 416 (Number of condition occurrence records, by condition_status_concept_id, condition_type_concept_id) -- START
2023-02-25 16:41:58	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0874 secs
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 416 (0.090701 secs)
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	Analysis 420 (Number of condition occurrence records by condition occurrence start month) -- START
2023-02-25 16:41:58	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0568 secs
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 420 (0.059455 secs)
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	Analysis 425 (Number of condition_occurrence records by condition_source_concept_id) -- START
2023-02-25 16:41:58	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0433 secs
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 425 (0.046109 secs)
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	Analysis 430 (Number of condition_occurrence records inside a valid observation period) -- START
2023-02-25 16:41:58	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0429 secs
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 430 (0.045395 secs)
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	Analysis 431 (Proportion of people with at least one condition_occurrence record outside a valid observation period) -- START
2023-02-25 16:41:58	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0444 secs
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 431 (0.047916 secs)
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	Analysis 432 (Proportion of condition_occurrence records outside a valid observation period) -- START
2023-02-25 16:41:58	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0431 secs
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 432 (0.045660 secs)
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	Analysis 500 (Number of persons with death, by cause_concept_id) -- START
2023-02-25 16:41:58	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.046 secs
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 500 (0.048621 secs)
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	Analysis 501 (Number of records of death, by cause_concept_id) -- START
2023-02-25 16:41:58	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0411 secs
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 501 (0.043437 secs)
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	Analysis 502 (Number of persons by death month) -- START
2023-02-25 16:41:58	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0452 secs
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 502 (0.047826 secs)
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	Analysis 504 (Number of persons with a death, by calendar year by gender by age decile) -- START
2023-02-25 16:41:58	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0433 secs
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 504 (0.045706 secs)
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	Analysis 505 (Number of death records, by death_type_concept_id) -- START
2023-02-25 16:41:58	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0445 secs
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 505 (0.047548 secs)
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	Analysis 506 (Distribution of age at death by gender) -- START
2023-02-25 16:41:58	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.174 secs
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 506 (0.176404 secs)
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	Analysis 509 (Number of death records with invalid person_id) -- START
2023-02-25 16:41:58	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0429 secs
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 509 (0.046224 secs)
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	Analysis 510 (Number of death records outside valid observation period) -- START
2023-02-25 16:41:58	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.047 secs
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 510 (0.050274 secs)
2023-02-25 16:41:58	[Main thread]	INFO	Achilles	achilles	Analysis 511 (Distribution of time from death to last condition) -- START
2023-02-25 16:41:59	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0501 secs
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 511 (0.052681 secs)
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	Analysis 512 (Distribution of time from death to last drug) -- START
2023-02-25 16:41:59	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.174 secs
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 512 (0.176977 secs)
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	Analysis 513 (Distribution of time from death to last visit) -- START
2023-02-25 16:41:59	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.171 secs
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 513 (0.173398 secs)
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	Analysis 514 (Distribution of time from death to last procedure) -- START
2023-02-25 16:41:59	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.17 secs
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 514 (0.172848 secs)
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	Analysis 515 (Distribution of time from death to last observation) -- START
2023-02-25 16:41:59	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.177 secs
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 515 (0.179483 secs)
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	Analysis 525 (Number of death records by cause_source_concept_id) -- START
2023-02-25 16:41:59	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0426 secs
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 525 (0.045638 secs)
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	Analysis 530 (Number of death records inside a valid observation period) -- START
2023-02-25 16:41:59	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0418 secs
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 530 (0.044142 secs)
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	Analysis 531 (Proportion of people with at least one death record outside a valid observation period) -- START
2023-02-25 16:41:59	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0453 secs
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 531 (0.056814 secs)
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	Analysis 532 (Proportion of death records that occur outside a valid observation period) -- START
2023-02-25 16:41:59	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0467 secs
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 532 (0.049416 secs)
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	Analysis 600 (Number of persons with at least one procedure occurrence, by procedure_concept_id) -- START
2023-02-25 16:41:59	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0458 secs
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 600 (0.048466 secs)
2023-02-25 16:41:59	[Main thread]	INFO	Achilles	achilles	Analysis 601 (Number of procedure occurrence records, by procedure_concept_id) -- START
2023-02-25 16:42:00	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0432 secs
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 601 (0.045559 secs)
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	Analysis 602 (Number of persons by procedure occurrence start month, by procedure_concept_id) -- START
2023-02-25 16:42:00	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.047 secs
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 602 (0.049384 secs)
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	Analysis 603 (Number of distinct procedure occurrence concepts per person) -- START
2023-02-25 16:42:00	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.167 secs
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 603 (0.169719 secs)
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	Analysis 604 (Number of persons with at least one procedure occurrence, by procedure_concept_id by calendar year by gender by age decile) -- START
2023-02-25 16:42:00	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0485 secs
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 604 (0.051566 secs)
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	Analysis 605 (Number of procedure occurrence records, by procedure_concept_id by procedure_type_concept_id) -- START
2023-02-25 16:42:00	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0449 secs
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 605 (0.047260 secs)
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	Analysis 606 (Distribution of age by procedure_concept_id) -- START
2023-02-25 16:42:00	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.288 secs
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 606 (0.290143 secs)
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	Analysis 609 (Number of procedure occurrence records with invalid person_id) -- START
2023-02-25 16:42:00	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0426 secs
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 609 (0.045412 secs)
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	Analysis 610 (Number of procedure occurrence records outside valid observation period) -- START
2023-02-25 16:42:00	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0407 secs
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 610 (0.043558 secs)
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	Analysis 612 (Number of procedure occurrence records with invalid provider_id) -- START
2023-02-25 16:42:00	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0456 secs
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 612 (0.048036 secs)
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	Analysis 613 (Number of procedure occurrence records with invalid visit_id) -- START
2023-02-25 16:42:00	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0456 secs
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 613 (0.047836 secs)
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	Analysis 620 (Number of procedure occurrence records  by procedure occurrence start month) -- START
2023-02-25 16:42:00	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0466 secs
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 620 (0.048948 secs)
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	Analysis 625 (Number of procedure_occurrence records by procedure_source_concept_id) -- START
2023-02-25 16:42:00	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0445 secs
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 625 (0.046670 secs)
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	Analysis 630 (Number of procedure_occurrence records inside a valid observation period) -- START
2023-02-25 16:42:00	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.046 secs
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 630 (0.048255 secs)
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	Analysis 631 (Proportion of people with at least one procedure_occurrence record outside a valid observation period) -- START
2023-02-25 16:42:00	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.044 secs
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 631 (0.047600 secs)
2023-02-25 16:42:00	[Main thread]	INFO	Achilles	achilles	Analysis 632 (Proportion of procedure_occurrence records outside a valid observation period) -- START
2023-02-25 16:42:01	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0413 secs
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 632 (0.043822 secs)
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	Analysis 691 (Percentage of total persons that have at least x procedures) -- START
2023-02-25 16:42:01	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0491 secs
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 691 (0.051388 secs)
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	Analysis 700 (Number of persons with at least one drug exposure, by drug_concept_id) -- START
2023-02-25 16:42:01	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0434 secs
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 700 (0.045643 secs)
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	Analysis 701 (Number of drug exposure records, by drug_concept_id) -- START
2023-02-25 16:42:01	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0545 secs
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 701 (0.057809 secs)
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	Analysis 702 (Number of persons by drug exposure start month, by drug_concept_id) -- START
2023-02-25 16:42:01	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0547 secs
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 702 (0.057502 secs)
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	Analysis 703 (Number of distinct drug exposure concepts per person) -- START
2023-02-25 16:42:01	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.198 secs
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 703 (0.202193 secs)
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	Analysis 704 (Number of persons with at least one drug exposure, by drug_concept_id by calendar year by gender by age decile) -- START
2023-02-25 16:42:01	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0475 secs
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 704 (0.050093 secs)
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	Analysis 705 (Number of drug exposure records, by drug_concept_id by drug_type_concept_id) -- START
2023-02-25 16:42:01	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0446 secs
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 705 (0.047357 secs)
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	Analysis 706 (Distribution of age by drug_concept_id) -- START
2023-02-25 16:42:01	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.272 secs
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 706 (0.274523 secs)
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	Analysis 709 (Number of drug exposure records with invalid person_id) -- START
2023-02-25 16:42:01	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0427 secs
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 709 (0.045361 secs)
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	Analysis 710 (Number of drug exposure records outside valid observation period) -- START
2023-02-25 16:42:01	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0392 secs
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 710 (0.041379 secs)
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	Analysis 711 (Number of drug exposure records with end date < start date) -- START
2023-02-25 16:42:01	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0389 secs
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 711 (0.041406 secs)
2023-02-25 16:42:01	[Main thread]	INFO	Achilles	achilles	Analysis 712 (Number of drug exposure records with invalid provider_id) -- START
2023-02-25 16:42:02	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0398 secs
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 712 (0.042060 secs)
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	Analysis 713 (Number of drug exposure records with invalid visit_id) -- START
2023-02-25 16:42:02	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0415 secs
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 713 (0.043967 secs)
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	Analysis 715 (Distribution of days_supply by drug_concept_id) -- START
2023-02-25 16:42:02	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.171 secs
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 715 (0.173809 secs)
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	Analysis 716 (Distribution of refills by drug_concept_id) -- START
2023-02-25 16:42:02	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.166 secs
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 716 (0.168182 secs)
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	Analysis 717 (Distribution of quantity by drug_concept_id) -- START
2023-02-25 16:42:02	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.173 secs
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 717 (0.176529 secs)
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	Analysis 720 (Number of drug exposure records  by drug exposure start month) -- START
2023-02-25 16:42:02	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0488 secs
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 720 (0.052138 secs)
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	Analysis 725 (Number of drug_exposure records by drug_source_concept_id) -- START
2023-02-25 16:42:02	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0436 secs
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 725 (0.047133 secs)
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	Analysis 730 (Number of drug_exposure records inside a valid observation period) -- START
2023-02-25 16:42:02	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0443 secs
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 730 (0.046715 secs)
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	Analysis 731 (Proportion of people with at least one drug_exposure record outside a valid observation period) -- START
2023-02-25 16:42:02	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0473 secs
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 731 (0.049711 secs)
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	Analysis 732 (Proportion of drug_exposure records outside a valid observation period) -- START
2023-02-25 16:42:02	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0461 secs
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 732 (0.048329 secs)
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	Analysis 791 (Percentage of total persons that have at least x drug exposures) -- START
2023-02-25 16:42:02	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0538 secs
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 791 (0.056283 secs)
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	Analysis 800 (Number of persons with at least one observation occurrence, by observation_concept_id) -- START
2023-02-25 16:42:02	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0448 secs
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 800 (0.047140 secs)
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	Analysis 801 (Number of observation occurrence records, by observation_concept_id) -- START
2023-02-25 16:42:02	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0529 secs
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 801 (0.064394 secs)
2023-02-25 16:42:02	[Main thread]	INFO	Achilles	achilles	Analysis 802 (Number of persons by observation occurrence start month, by observation_concept_id) -- START
2023-02-25 16:42:03	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0483 secs
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 802 (0.051392 secs)
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	Analysis 803 (Number of distinct observation occurrence concepts per person) -- START
2023-02-25 16:42:03	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.166 secs
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 803 (0.168375 secs)
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	Analysis 804 (Number of persons with at least one observation occurrence, by observation_concept_id by calendar year by gender by age decile) -- START
2023-02-25 16:42:03	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0453 secs
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 804 (0.047540 secs)
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	Analysis 805 (Number of observation occurrence records, by observation_concept_id by observation_type_concept_id) -- START
2023-02-25 16:42:03	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0454 secs
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 805 (0.047732 secs)
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	Analysis 806 (Distribution of age by observation_concept_id) -- START
2023-02-25 16:42:03	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.283 secs
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 806 (0.285618 secs)
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	Analysis 807 (Number of observation occurrence records, by observation_concept_id and unit_concept_id) -- START
2023-02-25 16:42:03	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0446 secs
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 807 (0.046865 secs)
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	Analysis 809 (Number of observation records with invalid person_id) -- START
2023-02-25 16:42:03	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0427 secs
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 809 (0.045056 secs)
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	Analysis 810 (Number of observation records outside valid observation period) -- START
2023-02-25 16:42:03	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0412 secs
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 810 (0.043577 secs)
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	Analysis 812 (Number of observation records with invalid provider_id) -- START
2023-02-25 16:42:03	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0437 secs
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 812 (0.046235 secs)
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	Analysis 813 (Number of observation records with invalid visit_id) -- START
2023-02-25 16:42:03	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0451 secs
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 813 (0.047446 secs)
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	Analysis 814 (Number of observation records with no value (numeric, string, or concept)) -- START
2023-02-25 16:42:03	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.042 secs
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 814 (0.044347 secs)
2023-02-25 16:42:03	[Main thread]	INFO	Achilles	achilles	Analysis 815 (Distribution of numeric values, by observation_concept_id and unit_concept_id) -- START
2023-02-25 16:42:04	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.42 secs
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 815 (0.421935 secs)
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	Analysis 820 (Number of observation records  by observation start month) -- START
2023-02-25 16:42:04	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0464 secs
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 820 (0.048696 secs)
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	Analysis 822 (Number of observation records, by observation_concept_id and value_as_concept_id) -- START
2023-02-25 16:42:04	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0506 secs
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 822 (0.052877 secs)
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	Analysis 823 (Number of observation records, by observation_concept_id and qualifier_concept_id) -- START
2023-02-25 16:42:04	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0437 secs
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 823 (0.045995 secs)
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	Analysis 825 (Number of observation records by observation_source_concept_id) -- START
2023-02-25 16:42:04	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0444 secs
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 825 (0.046736 secs)
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	Analysis 826 (Number of observation records by value_as_concept_id) -- START
2023-02-25 16:42:04	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.045 secs
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 826 (0.047292 secs)
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	Analysis 827 (Number of observation records by unit_concept_id) -- START
2023-02-25 16:42:04	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0467 secs
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 827 (0.049027 secs)
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	Analysis 830 (Number of observation records inside a valid observation period) -- START
2023-02-25 16:42:04	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0414 secs
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 830 (0.043674 secs)
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	Analysis 831 (Proportion of people with at least one observation record outside a valid observation period) -- START
2023-02-25 16:42:04	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0481 secs
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 831 (0.050906 secs)
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	Analysis 832 (Proportion of observation records outside a valid observation period) -- START
2023-02-25 16:42:04	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0422 secs
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 832 (0.044938 secs)
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	Analysis 891 (Percentage of total persons that have at least x observations) -- START
2023-02-25 16:42:04	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0453 secs
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 891 (0.048452 secs)
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	Analysis 900 (Number of persons with at least one drug era, by drug_concept_id) -- START
2023-02-25 16:42:04	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0415 secs
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 900 (0.043812 secs)
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	Analysis 901 (Number of drug era records, by drug_concept_id) -- START
2023-02-25 16:42:04	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0446 secs
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 901 (0.047004 secs)
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	Analysis 902 (Number of persons by drug era start month, by drug_concept_id) -- START
2023-02-25 16:42:04	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.046 secs
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 902 (0.048283 secs)
2023-02-25 16:42:04	[Main thread]	INFO	Achilles	achilles	Analysis 903 (Number of distinct drug era concepts per person) -- START
2023-02-25 16:42:05	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.164 secs
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 903 (0.166373 secs)
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	Analysis 904 (Number of persons with at least one drug era, by drug_concept_id by calendar year by gender by age decile) -- START
2023-02-25 16:42:05	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0447 secs
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 904 (0.046964 secs)
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	Analysis 906 (Distribution of age by drug_concept_id) -- START
2023-02-25 16:42:05	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.314 secs
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 906 (0.316904 secs)
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	Analysis 907 (Distribution of drug era length, by drug_concept_id) -- START
2023-02-25 16:42:05	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.167 secs
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 907 (0.168839 secs)
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	Analysis 908 (Number of drug eras without valid person) -- START
2023-02-25 16:42:05	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0394 secs
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 908 (0.041641 secs)
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	Analysis 910 (Number of drug_era records outside valid observation period) -- START
2023-02-25 16:42:05	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.041 secs
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 910 (0.043246 secs)
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	Analysis 911 (Number of drug eras with end date < start date) -- START
2023-02-25 16:42:05	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0445 secs
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 911 (0.046724 secs)
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	Analysis 920 (Number of drug era records by drug era start month) -- START
2023-02-25 16:42:05	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0446 secs
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 920 (0.047803 secs)
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	Analysis 930 (Number of drug_era records inside a valid observation period) -- START
2023-02-25 16:42:05	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0422 secs
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 930 (0.044469 secs)
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	Analysis 931 (Proportion of people with at least one drug_era record outside a valid observation period) -- START
2023-02-25 16:42:05	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0454 secs
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 931 (0.047687 secs)
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	Analysis 932 (Proportion of drug_era records outside a valid observation period) -- START
2023-02-25 16:42:05	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0472 secs
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 932 (0.049423 secs)
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	Analysis 1000 (Number of persons with at least one condition era, by condition_concept_id) -- START
2023-02-25 16:42:05	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0445 secs
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1000 (0.046694 secs)
2023-02-25 16:42:05	[Main thread]	INFO	Achilles	achilles	Analysis 1001 (Number of condition era records, by condition_concept_id) -- START
2023-02-25 16:42:06	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0428 secs
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1001 (0.044992 secs)
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	Analysis 1002 (Number of persons by condition era start month, by condition_concept_id) -- START
2023-02-25 16:42:06	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0461 secs
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1002 (0.048477 secs)
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	Analysis 1003 (Number of distinct condition era concepts per person) -- START
2023-02-25 16:42:06	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.176 secs
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1003 (0.179136 secs)
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	Analysis 1004 (Number of persons with at least one condition era, by condition_concept_id by calendar year by gender by age decile) -- START
2023-02-25 16:42:06	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0534 secs
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1004 (0.056038 secs)
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	Analysis 1006 (Distribution of age by condition_concept_id) -- START
2023-02-25 16:42:06	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.279 secs
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1006 (0.281370 secs)
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	Analysis 1007 (Distribution of condition era length, by condition_concept_id) -- START
2023-02-25 16:42:06	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.159 secs
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1007 (0.161366 secs)
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	Analysis 1008 (Number of condition eras without valid person) -- START
2023-02-25 16:42:06	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0454 secs
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1008 (0.048024 secs)
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	Analysis 1010 (Number of condition_era records outside a valid observation period) -- START
2023-02-25 16:42:06	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0427 secs
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1010 (0.044976 secs)
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	Analysis 1011 (Number of condition eras with end date < start date) -- START
2023-02-25 16:42:06	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0381 secs
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1011 (0.040758 secs)
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	Analysis 1020 (Number of condition era records by condition era start month) -- START
2023-02-25 16:42:06	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0441 secs
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1020 (0.046818 secs)
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	Analysis 1030 (Number of condition_era records inside a valid observation period) -- START
2023-02-25 16:42:06	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0415 secs
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1030 (0.044207 secs)
2023-02-25 16:42:06	[Main thread]	INFO	Achilles	achilles	Analysis 1031 (Proportion of people with at least one condition_era record outside a valid observation period) -- START
2023-02-25 16:42:07	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0425 secs
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1031 (0.044744 secs)
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	Analysis 1032 (Proportion of condition_era records outside a valid observation period) -- START
2023-02-25 16:42:07	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0446 secs
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1032 (0.046851 secs)
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	Analysis 1100 (Number of persons by location 3-digit zip) -- START
2023-02-25 16:42:07	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0932 secs
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1100 (0.095593 secs)
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	Analysis 1101 (Number of persons by location state) -- START
2023-02-25 16:42:07	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.114 secs
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1101 (0.115946 secs)
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	Analysis 1102 (Number of care sites by location 3-digit zip) -- START
2023-02-25 16:42:07	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0473 secs
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1102 (0.049619 secs)
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	Analysis 1103 (Number of care sites by location state) -- START
2023-02-25 16:42:07	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0397 secs
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1103 (0.041957 secs)
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	Analysis 1200 (Number of persons by place of service) -- START
2023-02-25 16:42:07	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0466 secs
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1200 (0.049145 secs)
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	Analysis 1201 (Number of visits by place of service) -- START
2023-02-25 16:42:07	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0426 secs
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1201 (0.044867 secs)
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	Analysis 1202 (Number of care sites by place of service) -- START
2023-02-25 16:42:07	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0423 secs
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1202 (0.044456 secs)
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	Analysis 1203 (Number of visits by place of service discharge type) -- START
2023-02-25 16:42:07	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0541 secs
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1203 (0.056528 secs)
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	Analysis 1300 (Number of persons with at least one visit detail, by visit_detail_concept_id) -- START
2023-02-25 16:42:07	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0428 secs
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1300 (0.045569 secs)
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	Analysis 1301 (Number of visit detail records, by visit_detail_concept_id) -- START
2023-02-25 16:42:07	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0434 secs
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1301 (0.046763 secs)
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	Analysis 1302 (Number of persons by visit detail start month, by visit_detail_concept_id) -- START
2023-02-25 16:42:07	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0441 secs
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1302 (0.054085 secs)
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	Analysis 1303 (Number of distinct visit detail concepts per person) -- START
2023-02-25 16:42:07	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.165 secs
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1303 (0.167420 secs)
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	Analysis 1304 (Number of persons with at least one visit detail, by visit_detail_concept_id by calendar year by gender by age decile) -- START
2023-02-25 16:42:07	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0462 secs
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1304 (0.048795 secs)
2023-02-25 16:42:07	[Main thread]	INFO	Achilles	achilles	Analysis 1306 (Distribution of age by visit_detail_concept_id) -- START
2023-02-25 16:42:08	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.17 secs
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1306 (0.172611 secs)
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	Analysis 1307 (Number of visit records with invalid person_id) -- START
2023-02-25 16:42:08	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0422 secs
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1307 (0.044416 secs)
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	Analysis 1309 (Number of visit_detail records with invalid care_site_id) -- START
2023-02-25 16:42:08	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0398 secs
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1309 (0.042174 secs)
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	Analysis 1310 (Number of visit_detail records outside a valid observation period) -- START
2023-02-25 16:42:08	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0424 secs
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1310 (0.044695 secs)
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	Analysis 1311 (Number of visit_detail records with end date < start date) -- START
2023-02-25 16:42:08	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0391 secs
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1311 (0.041358 secs)
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	Analysis 1312 (Number of persons with at least one visit detail, by calendar year by gender by age decile) -- START
2023-02-25 16:42:08	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0432 secs
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1312 (0.045537 secs)
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	Analysis 1313 (Distribution of length of stay by visit_detail_concept_id) -- START
2023-02-25 16:42:08	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.168 secs
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1313 (0.170169 secs)
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	Analysis 1320 (Number of visit detail records by visit detail start month) -- START
2023-02-25 16:42:08	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0418 secs
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1320 (0.044321 secs)
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	Analysis 1321 (Number of persons by visit start year) -- START
2023-02-25 16:42:08	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0452 secs
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1321 (0.047460 secs)
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	Analysis 1325 (Number of visit_detail records by visit_detail_source_concept_id) -- START
2023-02-25 16:42:08	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0442 secs
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1325 (0.046574 secs)
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	Analysis 1326 (Number of records by domain by visit_detail_concept_id) -- START
2023-02-25 16:42:08	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.051 secs
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1326 (0.053285 secs)
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	Analysis 1330 (Number of visit_detail records inside a valid observation period) -- START
2023-02-25 16:42:08	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0398 secs
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1330 (0.042001 secs)
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	Analysis 1331 (Proportion of people with at least one visit_detail record outside a valid observation period) -- START
2023-02-25 16:42:08	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0442 secs
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1331 (0.046587 secs)
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	Analysis 1332 (Proportion of visit_detail records outside a valid observation period) -- START
2023-02-25 16:42:08	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0418 secs
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1332 (0.044106 secs)
2023-02-25 16:42:08	[Main thread]	INFO	Achilles	achilles	Analysis 1406 (Length of payer plan (days) of first payer plan period by gender) -- START
2023-02-25 16:42:09	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.172 secs
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1406 (0.174394 secs)
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	Analysis 1407 (Length of payer plan (days) of first payer plan period by age decile) -- START
2023-02-25 16:42:09	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.157 secs
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1407 (0.159734 secs)
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	Analysis 1408 (Number of persons by length of payer plan period, in 30d increments) -- START
2023-02-25 16:42:09	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0427 secs
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1408 (0.046031 secs)
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	Analysis 1409 (Number of persons with continuous payer plan in each year) -- START
2023-02-25 16:42:09	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.153 secs
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1409 (0.163658 secs)
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	Analysis 1410 (Number of persons with continuous payer plan in each month) -- START
2023-02-25 16:42:09	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.155 secs
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1410 (0.158240 secs)
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	Analysis 1411 (Number of persons by payer plan period start month) -- START
2023-02-25 16:42:09	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0415 secs
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1411 (0.043883 secs)
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	Analysis 1412 (Number of persons by payer plan period end month) -- START
2023-02-25 16:42:09	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0454 secs
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1412 (0.048060 secs)
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	Analysis 1413 (Number of persons by number of payer plan periods) -- START
2023-02-25 16:42:09	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0413 secs
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1413 (0.043575 secs)
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	Analysis 1414 (Number of persons with payer plan period before year-of-birth) -- START
2023-02-25 16:42:09	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0468 secs
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1414 (0.049035 secs)
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	Analysis 1415 (Number of persons with payer plan period end < payer plan period start) -- START
2023-02-25 16:42:09	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0419 secs
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1415 (0.044258 secs)
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	Analysis 1425 (Number of payer_plan_period records by payer_source_concept_id) -- START
2023-02-25 16:42:09	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0448 secs
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1425 (0.047536 secs)
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	Analysis 1800 (Number of persons with at least one measurement occurrence, by measurement_concept_id) -- START
2023-02-25 16:42:09	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0445 secs
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1800 (0.047382 secs)
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	Analysis 1801 (Number of measurement occurrence records, by measurement_concept_id) -- START
2023-02-25 16:42:09	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0412 secs
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1801 (0.044496 secs)
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	Analysis 1802 (Number of persons by measurement occurrence start month, by measurement_concept_id) -- START
2023-02-25 16:42:09	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0439 secs
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1802 (0.046254 secs)
2023-02-25 16:42:09	[Main thread]	INFO	Achilles	achilles	Analysis 1803 (Number of distinct mesurement occurrence concepts per person) -- START
2023-02-25 16:42:10	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.162 secs
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1803 (0.164796 secs)
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	Analysis 1804 (Number of persons with at least one mesurement  occurrence, by measurement_concept_id by calendar year by gender by age decile) -- START
2023-02-25 16:42:10	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0418 secs
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1804 (0.044066 secs)
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	Analysis 1805 (Number of measurement occurrence records, by measurement_concept_id by measurement_type_concept_id) -- START
2023-02-25 16:42:10	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0454 secs
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1805 (0.048268 secs)
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	Analysis 1806 (Distribution of age by measurement_concept_id) -- START
2023-02-25 16:42:10	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.302 secs
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1806 (0.305044 secs)
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	Analysis 1807 (Number of measurement occurrence records, by measurement_concept_id and unit_concept_id) -- START
2023-02-25 16:42:10	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0475 secs
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1807 (0.050879 secs)
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	Analysis 1809 (Number of measurement records with invalid person_id) -- START
2023-02-25 16:42:10	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0414 secs
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1809 (0.044101 secs)
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	Analysis 1810 (Number of measurement records outside valid observation period) -- START
2023-02-25 16:42:10	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0425 secs
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1810 (0.044999 secs)
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	Analysis 1811 (Number of measurement records with a valid value (with a mapped, non-null value_as_number)) -- START
2023-02-25 16:42:10	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0445 secs
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1811 (0.046902 secs)
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	Analysis 1812 (Number of measurement records with invalid provider_id) -- START
2023-02-25 16:42:10	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0441 secs
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1812 (0.046258 secs)
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	Analysis 1813 (Number of measurement records with invalid visit_id) -- START
2023-02-25 16:42:10	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.04 secs
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1813 (0.042678 secs)
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	Analysis 1814 (Number of measurement records with no value (numeric, string, or concept)) -- START
2023-02-25 16:42:10	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0538 secs
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1814 (0.056843 secs)
2023-02-25 16:42:10	[Main thread]	INFO	Achilles	achilles	Analysis 1815 (Distribution of numeric values, by measurement_concept_id and unit_concept_id) -- START
2023-02-25 16:42:11	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.276 secs
2023-02-25 16:42:11	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1815 (0.279325 secs)
2023-02-25 16:42:11	[Main thread]	INFO	Achilles	achilles	Analysis 1816 (Distribution of low range, by measurement_concept_id and unit_concept_id) -- START
2023-02-25 16:42:11	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.437 secs
2023-02-25 16:42:11	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1816 (0.438829 secs)
2023-02-25 16:42:11	[Main thread]	INFO	Achilles	achilles	Analysis 1817 (Distribution of high range, by measurement_concept_id and unit_concept_id) -- START
2023-02-25 16:42:11	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.386 secs
2023-02-25 16:42:11	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1817 (0.387905 secs)
2023-02-25 16:42:11	[Main thread]	INFO	Achilles	achilles	Analysis 1818 (Number of measurement records below/within/above normal range, by measurement_concept_id and unit_concept_id) -- START
2023-02-25 16:42:12	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.153 secs
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1818 (0.156567 secs)
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	Analysis 1819 (Number of measurement records, by measurement_concept_id, with a valid value (with a mapped, non-null value_as_number)) -- START
2023-02-25 16:42:12	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0438 secs
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1819 (0.046121 secs)
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	Analysis 1820 (Number of measurement records  by measurement start month) -- START
2023-02-25 16:42:12	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0441 secs
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1820 (0.046470 secs)
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	Analysis 1821 (Number of measurement records with no numeric value) -- START
2023-02-25 16:42:12	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0436 secs
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1821 (0.045840 secs)
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	Analysis 1822 (Number of measurement records, by measurement_concept_id and value_as_concept_id) -- START
2023-02-25 16:42:12	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.041 secs
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1822 (0.043358 secs)
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	Analysis 1823 (Number of measurement records, by measurement_concept_id and operator_concept_id) -- START
2023-02-25 16:42:12	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0463 secs
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1823 (0.048625 secs)
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	Analysis 1825 (Number of measurement records by measurement_source_concept_id) -- START
2023-02-25 16:42:12	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0396 secs
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1825 (0.041815 secs)
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	Analysis 1826 (Number of measurement records by value_as_concept_id) -- START
2023-02-25 16:42:12	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0425 secs
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1826 (0.044777 secs)
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	Analysis 1827 (Number of measurement records by unit_concept_id) -- START
2023-02-25 16:42:12	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0473 secs
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1827 (0.050009 secs)
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	Analysis 1830 (Number of visit_detail records inside a valid observation period) -- START
2023-02-25 16:42:12	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0434 secs
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1830 (0.045718 secs)
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	Analysis 1831 (Proportion of people with at least one measurement record outside a valid observation period) -- START
2023-02-25 16:42:12	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0438 secs
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1831 (0.046275 secs)
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	Analysis 1832 (Proportion of measurement records outside a valid observation period) -- START
2023-02-25 16:42:12	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0423 secs
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1832 (0.044732 secs)
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	Analysis 1833 (Proportion of measurement records inside a valid observation period and without a value) -- START
2023-02-25 16:42:12	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0414 secs
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1833 (0.043656 secs)
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	Analysis 1891 (Percentage of total persons that have at least x measurements) -- START
2023-02-25 16:42:12	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0444 secs
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1891 (0.046777 secs)
2023-02-25 16:42:12	[Main thread]	INFO	Achilles	achilles	Analysis 1900 (Source values mapped to concept_id 0 by table, by column, by source_value) -- START
2023-02-25 16:42:13	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.587 secs
2023-02-25 16:42:13	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 1900 (0.589588 secs)
2023-02-25 16:42:13	[Main thread]	INFO	Achilles	achilles	Analysis 2000 (Number of patients with at least 1 Dx and 1 Rx) -- START
2023-02-25 16:42:13	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0595 secs
2023-02-25 16:42:13	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2000 (0.062082 secs)
2023-02-25 16:42:13	[Main thread]	INFO	Achilles	achilles	Analysis 2001 (Number of patients with at least 1 Dx and 1 Proc) -- START
2023-02-25 16:42:13	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0504 secs
2023-02-25 16:42:13	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2001 (0.053245 secs)
2023-02-25 16:42:13	[Main thread]	INFO	Achilles	achilles	Analysis 2002 (Number of patients with at least 1 Meas, 1 Dx and 1 Rx) -- START
2023-02-25 16:42:13	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0863 secs
2023-02-25 16:42:13	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2002 (0.089027 secs)
2023-02-25 16:42:13	[Main thread]	INFO	Achilles	achilles	Analysis 2003 (Number of patients with at least 1 Visit) -- START
2023-02-25 16:42:13	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0562 secs
2023-02-25 16:42:13	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2003 (0.058598 secs)
2023-02-25 16:42:13	[Main thread]	INFO	Achilles	achilles	Analysis 2004 (Number of distinct patients that overlap between specific domains) -- START
2023-02-25 16:42:26	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 12.6 secs
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2004 (12.643293 secs)
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	Analysis 2100 (Number of persons with at least one device exposure, by device_concept_id) -- START
2023-02-25 16:42:26	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0558 secs
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2100 (0.058430 secs)
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	Analysis 2101 (Number of device exposure records, by device_concept_id) -- START
2023-02-25 16:42:26	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0484 secs
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2101 (0.050852 secs)
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	Analysis 2102 (Number of persons by device records  start month, by device_concept_id) -- START
2023-02-25 16:42:26	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0441 secs
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2102 (0.046727 secs)
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	Analysis 2104 (Number of persons with at least one device exposure, by device_concept_id by calendar year by gender by age decile) -- START
2023-02-25 16:42:26	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0487 secs
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2104 (0.051017 secs)
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	Analysis 2105 (Number of device exposure records, by device_concept_id by device_type_concept_id) -- START
2023-02-25 16:42:26	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0465 secs
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2105 (0.049218 secs)
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	Analysis 2106 (Distribution of age by device_concept_id) -- START
2023-02-25 16:42:26	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.298 secs
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2106 (0.300372 secs)
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	Analysis 2110 (Number of device_exposure records outside valid observation period) -- START
2023-02-25 16:42:26	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0443 secs
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2110 (0.046909 secs)
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	Analysis 2125 (Number of device_exposure records by device_source_concept_id) -- START
2023-02-25 16:42:26	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0436 secs
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2125 (0.045875 secs)
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	Analysis 2130 (Number of device_exposure records inside a valid observation period) -- START
2023-02-25 16:42:26	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0444 secs
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2130 (0.046665 secs)
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	Analysis 2131 (Proportion of people with at least one device_exposure record outside a valid observation period) -- START
2023-02-25 16:42:26	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0423 secs
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2131 (0.044506 secs)
2023-02-25 16:42:26	[Main thread]	INFO	Achilles	achilles	Analysis 2132 (Proportion of device_exposure records outside a valid observation period) -- START
2023-02-25 16:42:27	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.042 secs
2023-02-25 16:42:27	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2132 (0.044881 secs)
2023-02-25 16:42:27	[Main thread]	INFO	Achilles	achilles	Analysis 2191 (Percentage of total persons that have at least x device exposures) -- START
2023-02-25 16:42:27	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0476 secs
2023-02-25 16:42:27	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2191 (0.049929 secs)
2023-02-25 16:42:27	[Main thread]	INFO	Achilles	achilles	Analysis 2200 (Number of persons with at least one note by  note_type_concept_id) -- START
2023-02-25 16:42:27	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0395 secs
2023-02-25 16:42:27	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2200 (0.042316 secs)
2023-02-25 16:42:27	[Main thread]	INFO	Achilles	achilles	Analysis 2201 (Number of note records, by note_type_concept_id) -- START
2023-02-25 16:42:27	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.0424 secs
2023-02-25 16:42:27	[Main thread]	INFO	Achilles	achilles	[Main Analysis] [COMPLETE] 2201 (0.044747 secs)
2023-02-25 16:43:06	[Main thread]	INFO	Achilles	achilles	Merging scratch Achilles tables
2023-02-25 16:43:10	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 3.68 secs
2023-02-25 16:43:11	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.682 secs
2023-02-25 16:43:11	[Main thread]	INFO	Achilles	achilles	Done. Achilles results can now be found in schema RESULTS
2023-02-25 16:43:11	[Main thread]	INFO	DatabaseConnector	connectSqlServer	Connecting using SQL Server driver
2023-02-25 16:43:12	[Main thread]	INFO	DatabaseConnector	executeSql	Executing SQL took 0.485 secs