Abstract：
:The use of primary care electronic health records for research is abundant. The benefits gained from utilising such records lies in their size, longitudinal data collection and data quality. However, the use of such data to undertake high quality epidemiological studies, can lead to significant challenges particularly in dealing with misclassification, variation in coding and the significant effort required to pre-process the data in a meaningful format for statistical analysis. In this paper, we describe a methodology to aid with the extraction and processing of such databases, delivered by a novel software programme; the "Data extraction for epidemiological research" (DExtER). The basis of DExtER relies on principles of extract, transform and load processes. The tool initially provides the ability for the healthcare dataset to be extracted, then transformed in a format whereby data is normalised, converted and reformatted. DExtER has a user interface designed to obtain data extracts specific to each research question and observational study design. There are facilities to input the requirements for; eligible study period, definition of exposed and unexposed groups, outcome measures and important baseline covariates. To date the tool has been utilised and validated in a multitude of settings. There have been over 35 peer-reviewed publications using the tool, and DExtER has been implemented as a validated public health surveillance tool for obtaining accurate statistics on epidemiology of key morbidities. Future direction of this work will be the application of the framework to linked as well as international datasets and the development of standardised methods for conducting electronic pre-processing and extraction from datasets for research purposes.
journal_name
Eur J Epidemioljournal_title
European journal of epidemiologyauthors
Gokhale KM,Chandan JS,Toulis K,Gkoutos G,Tino P,Nirantharakumar Kdoi
10.1007/s10654-020-00677-6subject
Has Abstractpub_date
2020-08-27 00:00:00eissn
0393-2990issn
1573-7284pii
10.1007/s10654-020-00677-6pub_type
杂志文章abstract：:We describe a Dot-ELISA system for the rapid, specific and reliable assessment of a subject's antitetanus immune status. The conditions for Dot-ELISA were selected to give positive reactions only for sera with antitetanus antibody titers equal to or higher than 0.06 I.U./ml, considered to represent protection when usi...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1007/BF00145053
更新日期：1989-03-01 00:00:00
abstract：:The reasons for the seasonality and annual changes in the impact of influenza epidemics remain poorly understood. We investigated the covariations between a major component of climate, namely the El Niño Southern Oscillation (ENSO), and indicators of the impact of influenza, as measured by morbidity, excess mortality ...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1007/s10654-004-2450-9
更新日期：2004-01-01 00:00:00
abstract：:The article was originally published electronically on the publisher's internet portal (currently SpringerLink) on 24 January 2018 without open access. ...
journal_title：European journal of epidemiology
pub_type： 杂志文章,已发布勘误
doi：10.1007/s10654-018-0412-x
更新日期：2018-09-01 00:00:00
abstract：:The relationship of socioeconomic indicators (education, occupation and residence) to short-term all cause mortality and coronary heart disease (CHD) mortality was evaluated in an Italian population sample. Socioeconomic indicators (education, occupational level and residence) and major CHD risk factors were measured ...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1023/a:1007640424387
更新日期：2000-06-01 00:00:00
abstract：:Respiratory health effects of short-term exposure to ambient air pollution have been examined in 120 'asthma-like' school-aged children in some areas of Emilia-Romagna (urban-industrial and rural area). They kept a daily diary, through 12 weeks, for respiratory symptoms, PEF measurements, drug consumption and daily ac...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1023/b:ejep.0000032373.28250.84
更新日期：2004-01-01 00:00:00
abstract：:Whether and how coffee use influences glucose metabolism is still a matter for debate. We investigated whether baseline coffee consumption is longitudinally associated with risk of impaired fasting glucose in a cohort of 18-to-45 year old subjects screened for stage 1 hypertension and whether CYP1A2 polymorphism modul...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1007/s10654-015-9990-z
更新日期：2015-03-01 00:00:00
abstract：:Chronic health problems may be related to body mass index (BMI, kg/m(2)), but this has been best documented in overweight and obese adults. The primary objective of this study was to identify factors associated with different categories of BMI in elderly men and women from the general population, also including the lo...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1007/s10654-009-9422-z
更新日期：2010-03-01 00:00:00
abstract：:The Singapore Preconception Study of Long-Term Maternal and Child Outcomes (S-PRESTO) is a preconception, longitudinal cohort study that aims to study the effects of nutrition, lifestyle, and maternal mood prior to and during pregnancy on the epigenome of the offspring and clinically important outcomes including durat...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1007/s10654-020-00697-2
更新日期：2021-01-01 00:00:00
abstract：:To assess whether two inflammatory markers, C-reactive protein (CRP) and interleukin-6 (IL-6), and change in their concentrations over 12 years, are associated with lung function (FVC and FEV(1)) 12 years after baseline. Data are from over 1,500 participants free from self-reported respiratory problems in a large-scal...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1007/s10654-010-9526-5
更新日期：2011-02-01 00:00:00
abstract：:Maternal obesity during pregnancy is an important public health problem in Western countries. Currently, obesity prevalence rates in pregnant women are estimated to be as high as 30%. In addition, approximately 40% of women gain an excessive amount of weight during pregnancy in Western countries. An accumulating body ...
journal_title：European journal of epidemiology
pub_type： 杂志文章,评审
doi：10.1007/s10654-015-0085-7
更新日期：2015-11-01 00:00:00
abstract：:To determine whether deer may play a role in the cycle of the Lyme disease spirochete Borrelia burgdorferi, we sought evidence for the presence of the pathogen in skin of deer and roe deer. Biopsies of 2 mm3 were taken at four different levels from nail to tarsus. A total of 50 animals (200 biopsies) were shot in the ...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1023/a:1007646216035
更新日期：2000-01-01 00:00:00
abstract：:Did you ever hear about epidemiology in Germany? Starting from an epidemiological desert the discipline has grown remarkably, especially during the last 10-15 years: research institutes have been established, research funding has improved, multiple curriculae in Epidemiology and Public Health are offered. This increas...
journal_title：European journal of epidemiology
pub_type： 历史文章,杂志文章
doi：10.1007/s10654-017-0290-7
更新日期：2017-08-01 00:00:00
abstract：: ...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1007/s10654-018-0461-1
更新日期：2019-01-01 00:00:00
abstract：:No population-based study has assessed the prognostic impact on survival of the CD19 positive lymphocyte count, evaluated by immunophenotyping at diagnosis, in B-cell chronic lymphocytic leukemia (B-CLL). Aiming at addressing this issue, we investigated the clinical outcome of a well-defined population of B-CLL patien...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1007/s10654-005-3777-6
更新日期：2005-01-01 00:00:00
abstract：:The benefits of leisure time physical activity (LTPA) in cardiovascular prevention are well established. While cardiac rehabilitation programmes have been demonstrated as improving myocardial infarction (MI) prognosis, the strength of the association between LTPA and post-MI survival has yet to be quantified. We evalu...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1007/s10654-010-9523-8
更新日期：2011-02-01 00:00:00
abstract：:Prior studies have yielded inconsistent evidence regarding the association between formaldehyde exposure and amyotrophic lateral sclerosis (ALS). We conducted a population case-control study in the Danish National Registries on the relationship between occupationally-derived formaldehyde exposure and ALS. Occupational...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1007/s10654-017-0249-8
更新日期：2017-10-01 00:00:00
abstract：:The follow-up of the French cohort of uranium miners has been extended to 1994, and a new source of information for causes of death has been used. The paper presents the new results regarding the risk of death among the cohort, and analyses the impact of the methodological changes on these results. The extension of th...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1023/b:ejep.0000017824.38966.01
更新日期：2004-01-01 00:00:00
abstract：:The aim of the study is to consider some ethical aspects of the provision of information, to the cases or their families, about the assessment of occupational asbestos exposure obtained in a case-control study of malignant mesothelioma of the pleura. An informative letter with the result of the evaluation of their occ...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1023/a:1010926807569
更新日期：2001-01-01 00:00:00
abstract：:The pattern of faecal excretion of Vibrio cholerae was studied over a duration of eight months among 13 cholera convalescents by two-weekly surveillance cultures. Stools and rectal swabs were cultured on Thiosulphate citrate bile salts sucrose (TCBS) agar for the recovery of vibrio pathogens. Clinical phase and conval...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1023/a:1007541317104
更新日期：1999-04-01 00:00:00
abstract：:Recent studies have confirmed important regional differences in the prevalence of obesity, as well as a tendency for this prevalence to increase. Determination of the social factors involved in obesity may be very useful to design intervention and prevention strategies. This transverse study was undertaken in Pizarra ...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1023/b:ejep.0000013254.93980.97
更新日期：2004-01-01 00:00:00
abstract：BACKGROUND:Fetal life events may affect the development of the immune and/or respiratory system and increase the risk of asthma and allergic diseases. The objective of this study was to test the hypothesis that pregnancy complications are associated with the risk of developing asthma in the off-spring. METHODS:The stu...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1023/a:1025395405101
更新日期：2003-01-01 00:00:00
abstract：:The aims of the NYU Children's Health and Environment Study (CHES) are to evaluate influences of prenatal non-persistent chemical exposures on fetal and postnatal growth and pool our data with the US National Institutes of Health Environmental influences on Child Health Outcomes (ECHO) Program to answer collaborative ...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1007/s10654-020-00623-6
更新日期：2020-03-01 00:00:00
abstract：:Faecal swabs obtained from 126 calves and 118 cows in Argentina were investigated for the presence of verotoxin-producing Escherichia coli (VTEC). VTEC strains were recovered from 10 (23%) of 43 calves with diarrhoea, from 24 (29%) of 83 healthy calves, from 40 (44%) of 91 healthy cows waiting at the slaughterhouse, a...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1023/a:1007427925583
更新日期：1998-06-01 00:00:00
abstract：:Evidence that childbearing is associated with future development of diabetes remains conflicting and the role of pregnancy loss in this association has not been investigated. We aimed to examine whether pregnancy and/or pregnancy loss (miscarriage, abortion, or stillbirth) are associated with maternal higher risk of d...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1007/s10654-012-9683-9
更新日期：2012-05-01 00:00:00
abstract：:Big Data and precision medicine, two major contemporary challenges for epidemiology, are critically examined from two different angles. In Part 1 Big Data collected for research purposes (Big research Data) and Big Data used for research although collected for other primary purposes (Big secondary Data) are discussed ...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1007/s10654-018-0385-9
更新日期：2018-03-01 00:00:00
abstract：:A group of 709 randomly selected males aged 18-55 years living in the city of Amsterdam, the Netherlands, were questioned about sexual lifestyle and related behavior. A substantial proportion (10%) of these men appeared to be homo- or bisexual. Of these homo- and bisexual men, 16.5% were predicted to be HIV seropositi...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1007/BF00157403
更新日期：1993-07-01 00:00:00
abstract：OBJECTIVES:Associations of cognitive function assessed in adulthood with coronary heart disease (CHD) and stroke might reflect a causal effect or could be explained by residual confounding or a common underlying pathology (atherosclerosis) that links both declines in cognitive function and increased risk of cardiovascu...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1007/s10654-008-9281-z
更新日期：2008-01-01 00:00:00
abstract：:Biomarkers are considered as tools to enhance cardiovascular risk estimation. However, the value of biomarkers on risk estimation beyond European risk scores, their comparative impact among different European regions and their role towards personalised medicine remains uncertain. Biomarker for Cardiovascular Risk Asse...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1007/s10654-014-9952-x
更新日期：2014-10-01 00:00:00
abstract：:In addition to gastroduodenal diseases, Helicobacter pylori infection has been associated with extradigestive diseases, including coronary heart disease. Different studies have failed to demonstrate a clear association. The aim of this work was to carry out a meta-analysis of these studies' results, with a special emp...
journal_title：European journal of epidemiology
pub_type： 杂志文章,meta分析
doi：10.1023/a:1007640609707
更新日期：1999-08-01 00:00:00
abstract：:Although a regular moderate physical activity is commonly accepted as an important heath promoting factor, the role of professional sport training is still under debate. The presented mortality analysis, concerning the period of 1946-2000, was performed for three groups of people completely healthy in youth, but exhib...
journal_title：European journal of epidemiology
pub_type： 杂志文章
doi：10.1007/s10654-008-9237-3
更新日期：2008-01-01 00:00:00
