_dta: 1. by Jean Roth , jroth@nber.org , 6 Apr 2017 2. DEMOyyQq.TXT contains patient demographic and administrative information, a single record for each event report. primaryid: 1. Unique number for identifying a FAERS report. 2. This is the primary link field (primary key) between data files (example: 31234561). 3. This is a concatenated key of Case ID and Case Version Number. 4. It is the Identifier for the case sequence (version) number as reported by the manufacturer. caseid: 1. Number for identifying a FAERS case (example. 3123456). 2. A case consists of one or more versions. 3. A follow-up version (that is, the newest/latest version received by FDA) 4. will have the same CASE number as the initial/oldest version. caseversion: 1. Safety Report Version Number. The Initial Case will be version 1; 2. follow-ups to the case will have sequentially incremented version numbers (for example, 2, 3, 4, etc.). i_f_code: 1. Code for initial or follow-up status of report, as reported by manufacturer. 2. CODE MEANING_TEXT 3. ---- ------------ 4. I Initial 5. F Follow-up event_dt: 1. Date the adverse event occurred or began. (YYYYMMDD format) 2. If a complete date is not available, a partial date is provided. 3. See the NOTE on dates at the end of this section. event_dt_num: 1. Date the adverse event occurred or began. (YYYYMMDD format) 2. YYYY-onlys are converted to midpoint of year: YYYY0702 3. YYYYMM-onlys are converted to midpoint of month: YYYYMM15 mfr_dt: 1. Date manufacturer first received initial information. 2. In subsequent versions of a case, the latest manufacturer received date will be provided (YYYYMMDD format). 3. If a complete date is not available, a partial date will be provided. 4. See the NOTE on dates at the end of this section. mfr_dt_num: 1. Date manufacturer first received initial information. 2. YYYY-onlys are converted to midpoint of year: YYYY0702 3. YYYYMM-onlys are converted to midpoint of month: YYYYMM15 init_fda_dt: 1. Date FDA received first version (Initial) of Case (YYYYMMDD format) fda_dt: 1. Date FDA received Case 2. In subsequent versions of a case, the latest manufacturer received date will be provided (YYYYMMDD format). rept_cod: 1. Code for the type of report submitted. (See table below.) 2. Also, see Section E, End Note 1, below. 3. CODE MEANING_TEXT 4. ---- --------------- 5. EXP Expedited (15-Day) 6. PER Periodic 7. DIR Direct 8. Expedited (15-day) and Periodic reports are from manufacturers; 9. "Direct" reports are voluntarily submitted to the FDA by non-manufacturers. auth_num: 1. Regulatory Authority’s case report number, when available mfr_num: 1. Manufacturer's unique report identifier. mfr_sndr: 1. Coded name of manufacturer sending report; 2. if not found, then verbatim name of organization sending report. age: 1. Numeric value of patient's age at event. age_cod: 1. Unit abbreviation for patient's age. (See table below.) 2. CODE MEANING_TEXT 3. ---- ------------ 4. DEC DECADE 5. YR YEAR 6. MON MONTH 7. WK WEEK 8. DY DAY 9. HR HOUR sex: 1. Code for patient's sex. (See table below.) 2. CODE MEANING_TEXT 3. ---- ------------ 4. UNK Unknown 5. M Male 6. F Female 7. NS Not Specified e_sub: 1. Whether (Y/N) this report was submitted under the electronic submissions procedure for manufacturers. wt: 1. Numeric value of patient's weight. wt_cod: 1. Unit abbreviation for patient's weight. (See table below.) 2. CODE MEANING_TEXT 3. ---- ------------ 4. KG Kilograms 5. LBS Pounds 6. GMS Grams rept_dt: 1. Date report was sent (YYYYMMDD format). 2. If a complete date is not available, a partial date is provided. 3. See the NOTE on dates at the end of this section. to_mfr: 1. Whether (Y/N) voluntary reporter also notified manufacturer (blank for manufacturer reports). occp_cod: 1. Abbreviation for the reporter's type of occupation in the latest version of a case. 2. CODE MEANING_TEXT 3. ---- ------------ 4. MD Physician 5. PH Pharmacist 6. OT Other health-professional 7. LW Lawyer 8. CN Consumer reporter_country: 1. The country of the reporter in the latest version of a case: 2. NOTE: Country codes are available per the links below. 3. http://estri.ich.org/icsr/ICH_ICSR_Specification_V2-3.pdf 4. http://www.iso.org/iso/home/standards/country_codes/iso-3166-1_decoding_t > able.htm occr_country: 1. The country where the event occurred. obs: 399,020 vars: 34 6 Apr 2017 22:10 size: 304,851,280 (_dta has notes) ------------------------------------------------------------------------------- storage display value variable name type format label variable label ------------------------------------------------------------------------------- primaryid long %12.0g * Unique number for identifying a FAERS report caseid long %12.0g * Number for identifying a FAERS case (example. 3123456) caseversion byte %8.0g * Safety Report Version Number i_f_code str1 %9s * Code for initial or follow-up status of report, as reported i_f_code_num float %11.0g i_f_code_num Code for initial or follow-up status of report, as reported event_dt long %12.0g * Date the adverse event occurred or began event_dt_num float %td * Date the adverse event occurred or began mfr_dt long %12.0g * Date manufacturer first received initial information mfr_dt_num float %td * Date manufacturer first received initial information init_fda_dt long %10.0g * Date FDA received first version (Initial) of Case (YYYYMMDD format) init_fda_dt_num float %td Date FDA received first version (Initial) of Case (YYYYMMDD format) fda_dt long %10.0g * Date FDA received Case fda_dt_num float %td Date FDA received Case rept_cod str3 %9s * Code for the type of report submitted rept_cod_num float %22.0g rept_cod_num auth_num str56 %56s * Authority Number mfr_num str63 %63s * Manufacturer's unique report identifier mfr_sndr str34 %34s * Coded name of manufacturer sending report lit_ref str500 %500s Literature Reference age float %9.0g * Numeric value of patient's age at event age_cod str3 %9s * Unit abbreviation for patient's age age_grp str1 %9s Age Group age_grp_num str1 %9s Age Group sex str3 %9s * Code for patient's sex e_sub str1 %9s * (Y/N) report was submitted under the electronic submissions procedure for manufa wt float %9.0g * Numeric Value of Patient's Weight wt_cod str3 %9s * Unit abbreviation for patient's weight rept_dt long %10.0g * Date report was sent (YYYYMMDD format) rept_dt_num float %td Date report was sent (YYYYMMDD format) to_mfr str1 %9s * Whether (Y/N) voluntary reporter also notified manufacturer (blank for manufactu occp_cod str2 %9s * Abbreviation for the reporter's type of occupation in the latest version of a ca reporter_country str21 %21s * The country of the reporter in the latest version of a case occr_country str2 %9s * The country where the event occurred occp_cod_num float %28.0g occp_cod_num * indicated variables have notes ------------------------------------------------------------------------------- Sorted by: primaryid i_f_code_num: 70 F Follow-up 72 I Initial rept_cod_num: 687382 DIR Direct 698880 EXP Expedited (15-Day) 806982 PER Periodic occp_cod_num: 6778 CN Consumer 7687 LW Lawyer 7768 MD Physician 7984 OT Other health-professional 8072 PH Pharmacist 8278 RN Registered Nurse 8365 SALES