| Literature DB >> 25379130 |
Sharon P Cooper1, Nicholas Heyer2, Eva M Shipp3, E Roberta Ryder4, Edward Hendrikson5, Christina M Socias1, Deborah J Del Junco6, Melissa Valerio1, Sylvia Partida4.
Abstract
INTRODUCTION: The lack of aggregated longitudinal health data on farmworkers has severely limited opportunities to conduct research to improve their health status. To correct this problem, we have created the infrastructure necessary to develop and maintain a national Research Data Repository of migrant and seasonal farmworker patients and other community members receiving medical care from Community and Migrant Health Centers (C/MHCs). Project specific research databases can be easily extracted from this repository.Entities:
Keywords: HbA1c; electronic health records; farmworkers; limited data set
Year: 2014 PMID: 25379130 PMCID: PMC4221089 DOI: 10.5210/ojphi.v6i2.4903
Source DB: PubMed Journal: Online J Public Health Inform ISSN: 1947-2579
Figure 1Relational Database Structure for CBRN Research Database
Pilot Test Findings: Patient Population Description 1/2013-8/2013 (2 centers)
|
|
|
|
| |
| Gender | 503 (40.1) | 863 (53.8) | 1366 (47.8) | 37631 (57.9) |
| Age | 163 (13.0) | 129 (8.0) | 292 (10.2) | 8612 (13.2) |
| Race | 252 (20.1) | 667 (41.6) | 919 (32.2) | 41181 (63.3) |
| Ethnicity | 957 (76.3) | 1133 (70.6) | 2090 (73.1) | 33453 (51.5) |
| Language | 178 (14.2) | 525 (32.7) | 703 (24.6) | 40949 (63.0) |
| Marital
Status | 445 (35.5) | 740 (46.1) | 1185 (41.5) | 39216 (60.3) |
| Homeless | 12 (1.0) | 0 (0.0) | 12 (0.4) | 880 (1.4) |
| Veteran | 3 (0.2) | 12 (0.7) | 15 (0.5) | 511 (0.8) |
| Tobacco | 2 (0.2) | 27 (1.7) | 29 (1.0) | 475 (0.7) |
| Chronic
Diagnosis | 315 (25.1) | 497 (31.0) | 812 (28.4) | 14274 (22.0) |
*Includes 24 records for patients that identified themselves as both M&S.
Average HbA1c values for the first test by demographic variables.
| Variable | 1st Test | 2nd Test | 3rd Test |
| Farmworker
status | 6.9 (4.5-14.6; n=400) | 7.9 (5.2-13.0; n=80) | 8.2 (5.4-14.0; n=18) |
| Gender | 6.9 (4.3-16.2; n=4,249) | 8.0 (4.8-17.3; n=724) | 8.3 (5.0-14.3; n=92) |
| Ethnicity | 6.9 (4.2-15.8; n=2,839) | 7.7 (4.8-17.4; n=496) | 8.0 (4.7-16.0; n=61) |
Note: Observations with missing/unknown demographic values are not shown.
Average 1st Visit HbA1c values & change in HbA1C between 1st and last visit by # of Visits
| All Patients with HbA1c Labs | N | Minimum | Maximum | Mean | Std. Deviation |
| Â Â Â First HbA1c Lab Value (%) | 7158 | 4.2 | 17.8 | 7.093 | 2.1367 |
| Â Â Â Diff in HbA1c Lab Value (%) | -8.20 | 8.50 | -0.0363 | 0.67318 | |
| Â Â Â Time Diff in HbA1c Labs (days) | 0 | 238 | 22.06 | 51.821 | |
| Patients with only 1 HbA1c Lab | N | Minimum | Maximum | Mean | Std. Deviation |
| First HbA1c Lab Value (%) | 5918 | 4.3 | 17.8 | 6.863 | 2.0542 |
| Diff in HbA1c Lab Value (%) | 0.00 | 0.00 | 0.0000 | 0.00000 | |
| Time Diff in HbA1c Labs (days) | 0 | 0 | 0.00 | 0.000 | |
| Patients with only 2 HbA1c Labs | N | Minimum | Maximum | Mean | Std. Deviation |
| First HbA1c Lab Value (%) | 1091 | 4.8 | 17.6 | 8.138 | 2.1834 |
| Diff in HbA1c Lab Value (%) | -8.20 | 8.50 | -0.1889 | 1.57079 | |
| Time Diff in HbA1c Labs (days) | 0 | 238 | 120.74 | 43.080 | |
| Patients with only 3 HbA1c Labs | N | Minimum | Maximum | Mean | Std. Deviation |
| First HbA1c Lab Value (%) | 136 | 4.9 | 13.7 | 8.510 | 2.0635 |
| Diff in HbA1c Lab Value (%) | -6.80 | 5.60 | -0.2963 | 1.82892 | |
| Time Diff in HbA1c Labs (days) | 24 | 234 | 176.40 | 35.700 | |
| Patients with only 4 HbA1c Labs | N | Minimum | Maximum | Mean | Std. Deviation |
| First HbA1c Lab Value (%) | 10 | 4.2 | 14.5 | 8.970 | 3.0096 |
| Diff in HbA1c Lab Value (%) | -5.30 | 1.00 | -0.8300 | 1.76387 | |
| Time Diff in HbA1c Labs (days) | 119 | 219 | 164.10 | 31.963 | |
| Patients with 5 HbA1c Labs | N | Minimum | Maximum | Mean | Std. Deviation |
| First HbA1c Lab Value (%) | 3 | 8.6 | 13.1 | 10.333 | 2.4214 |
| Diff in HbA1c Lab Value (%) | -5.10 | 0.00 | -1.7667 | 2.88848 | |
| Time Diff in HbA1c Labs (days) | 142 | 189 | 173.33 | 27.135 |