Freedom Of Information (ADE) Quarterly Data STAT05Q2.TXT 28OCT05 Selection Time Period: 01-APR-2005 to 30-JUN-2005(completed < 10/28/05) including received reports from 01-JAN-2005 to 31-MAR-2005 where reports were completed between 27-JUL-2005 and 10/28/05 Null counts for selected data fields from Demographic file Column Name Total Count Missing Count ---------------------------------------------------------------------- AGE 80,614 25,520 AGE_COD 80,614 25,506 CASE 80,614 0 EVENT_DT 80,614 24,339 FDA_DT 80,614 0 FOLL_SEQ 80,614 70,822 MFR_DT 80,614 7,081 MFR_NUM 80,614 7,058 MFR_SNDR 80,614 7,079 WT 80,614 53,164 WT_COD 80,614 53,160 REPT_DT 80,614 714 DEATH_DT 80,614 75,004 Null counts for selected data fields from Drug file Column Name Total Count Missing Count ---------------------------------------------------------------------- DOSE_VBM 319,005 231,359 DRUGNAME 319,005 429 LOT_NUM 319,005 305,624 EXP_DT 319,005 313,790 NDA_NUM 319,005 255,951 Null counts for selected data fields from Indications file Column Name Total Count Missing Count ---------------------------------------------------------------------- INDICATIONS 124,568 0 Null counts for selected data fields from Drug Therapy file Column Name Total Count Missing Count ---------------------------------------------------------------------- END_DT 112,334 46,723 START_DT 112,334 9,995 DUR 112,334 87,215 DUR_COD 112,334 87,178 Null counts for selected data fields from Reaction file Column Name Total Count Missing Count ---------------------------------------------------------------------- PT 337,454 0 Frequency counts for selected data fields from DEMO file E_SUB COUNT PERCENT ---------------------------------------------------------------------- Y 28,123 35 N 52,491 65 GNDR_COD COUNT PERCENT ---------------------------------------------------------------------- NULL 3,875 . UNK 803 1.05 M 33,133 43.18 F 42,749 55.71 NS 54 0.07 Frequency counts for selected data fields from DEMO file I_F_COD COUNT PERCENT ---------------------------------------------------------------------- Followup 22,868 28.37 Initial 57,728 71.61 Unknown 18 0.02 REPT_COD COUNT PERCENT ---------------------------------------------------------------------- DIR 7,058 8.76 EXP 52,826 65.53 PER 20,730 25.72 OCCP_COD COUNT PERCENT ---------------------------------------------------------------------- MD 26,450 32.81 PH 4,610 5.72 OT 10,335 12.82 LW 3,562 4.42 CN 12,412 15.40 NULL 23,245 28.83 TO_MFR COUNT PERCENT ---------------------------------------------------------------------- Y 597 0.74 N 6,461 8.01 NULL 73,556 91.24 CONFID COUNT PERCENT ---------------------------------------------------------------------- Y 1,737 2.15 N 5,321 6.60 NULL 73,556 91.24 Frequency counts for selected data fields from DRUG file ROLE_COD COUNT PERCENT ---------------------------------------------------------------------- PS 80,614 25.27 SS 55,837 17.50 C 182,094 57.08 I 460 0.14 Frequency counts for selected data fields from DRUG file VAL_VBM COUNT PERCENT ---------------------------------------------------------------------- Validated trade name used 231,305 72.51 Verbatim name used 87,700 27.49 ROUTE COUNT PERCENT ---------------------------------------------------------------------- NULL 186,963 . AURICULAR (OTIC) 20 0.02 BUCCAL 92 0.07 CUTANEOUS 25 0.02 DENTAL 6 0.00 ENDOSINUSIAL 1 0.00 ENDOTRACHEAL 1 0.00 EPIDURAL 121 0.09 HEMODIALYSIS 2 0.00 INTRA CORPUS CAVERNOSUM 5 0.00 INTRA-AMNIOTIC 4 0.00 INTRA-ARTERIAL 50 0.04 INTRA-ARTICULAR 10 0.01 INTRA-UTERINE 452 0.34 INTRACARDIAC 2 0.00 INTRACAVERNOUS 9 0.01 INTRACORONARY 14 0.01 INTRADERMAL 30 0.02 INTRADISCAL (INTRASPINAL) 1 0.00 INTRAHEPATIC 2 0.00 INTRALESIONAL 2 0.00 INTRALYMPHATIC 4 0.00 INTRAMENINGEAL 4 0.00 INTRAMUSCULAR 4,484 3.40 INTRAOCULAR 73 0.06 INTRAPERITONEAL 74 0.06 INTRAPLEURAL 2 0.00 INTRASYNOVIAL 4 0.00 INTRATHECAL 189 0.14 INTRATHORACIC 40 0.03 INTRATRACHEAL 8 0.01 INTRATUMOR 2 0.00 INTRAVENOUS 18,241 13.81 INTRAVENOUS BOLUS 273 0.21 INTRAVENOUS DRIP 833 0.63 INTRAVESICAL 123 0.09 NASAL 195 0.15 OCCLUSIVE DRESSING TECHNIQUE 5 0.00 OPHTHALMIC 275 0.21 ORAL 68,407 51.81 OROPHARINGEAL 4,985 3.78 OTHER 491 0.37 PARENTERAL 151 0.11 PERINEURAL 29 0.02 RECTAL 151 0.11 RESPIRATORY (INHALATION) 3,012 2.28 RETROBULBAR 15 0.01 SUBCONJUNCTIVAL 13 0.01 SUBCUTANEOUS 8,206 6.21 SUBDERMAL 2 0.00 SUBLINGUAL 95 0.07 TOPICAL 674 0.51 TRANSDERMAL 1,284 0.97 TRANSMAMMARY 9 0.01 TRANSPLACENTAL 404 0.31 UNKNOWN 18,274 13.84 URETHRAL 4 0.00 VAGINAL 158 0.12 DECHAL COUNT PERCENT ---------------------------------------------------------------------- NULL 252,619 . Y 11,732 17.67 N 3,751 5.65 U 11,168 16.82 D 39,735 59.85 RECHAL COUNT PERCENT ---------------------------------------------------------------------- NULL 257,784 . Y 1,301 2.13 N 899 1.47 U 9,696 15.84 D 49,325 80.57 Frequency counts for selected data fields from OUTC file OUTC_COD COUNT PERCENT ---------------------------------------------------------------------- DE 8,358 10.32 LT 4,628 5.71 HO 27,621 34.11 DS 4,225 5.22 CA 411 0.51 OT 33,091 40.86 RI 2,650 3.27 Frequency counts for selected data fields from RPSR file RPSR_COD COUNT PERCENT ---------------------------------------------------------------------- FGN 12,274 14.97 SDY 4,944 6.03 LIT 2,129 2.60 CSM 19,753 24.10 HP 25,867 31.55 UF 117 0.14 CR 5,268 6.43 DT 187 0.23 OTH 11,437 13.95