Frequencies for first 10,000 rows of lot_num variable in drug2018q3 dataset : Lot number of the drug | Freq. Percent Cum. -------------------------------------+----------------------------------- | 9,237 92.37 92.37 00942701 | 1 0.01 92.38 0566122 | 1 0.01 92.39 08F0099 | 3 0.03 92.42 092414/S0144 | 1 0.01 92.43 1007438,UNKNOWN,UNKNOWN,UNKNOWN | 4 0.04 92.47 1008286,1079563,1079563,1092538 | 4 0.04 92.51 1021136 | 1 0.01 92.52 1021298 | 1 0.01 92.53 1021961 | 1 0.01 92.54 1028644 | 1 0.01 92.55 1038090 | 1 0.01 92.56 1038220 | 1 0.01 92.57 1038237 | 1 0.01 92.58 1040567 | 1 0.01 92.59 1042402 | 1 0.01 92.60 1084483 | 1 0.01 92.61 1091195 | 1 0.01 92.62 10F0525 | 2 0.02 92.64 1100104P1;UNKNOWN | 6 0.06 92.70 1103935 | 1 0.01 92.71 1105078 | 3 0.03 92.74 1106568,1107242 | 3 0.03 92.77 112007/175644 | 3 0.03 92.80 11C28NA | 1 0.01 92.81 11F041MR;17G051ME;17G051ME +MORE | 1 0.01 92.82 12005/MM | 2 0.02 92.84 1232042 | 1 0.01 92.85 130160 | 1 0.01 92.86 1360832PC | 1 0.01 92.87 1481835 | 5 0.05 92.92 1499255 | 1 0.01 92.93 1510866 | 1 0.01 92.94 1523803 | 1 0.01 92.95 1526646PC | 1 0.01 92.96 1543904 | 1 0.01 92.97 1543913 | 2 0.02 92.99 1573867PC/3058940PC,1465164 | 1 0.01 93.00 180384 | 1 0.01 93.01 19368 | 1 0.01 93.02 1F735A | 2 0.02 93.04 1F770A | 1 0.01 93.05 2-M-00840, 2-J-00989 | 1 0.01 93.06 2000175G00 | 1 0.01 93.07 2000474C00 | 1 0.01 93.08 2056841AA | 2 0.02 93.10 2CA8DSA | 1 0.01 93.11 2CC1ASB | 1 0.01 93.12 2CC1ESA | 5 0.05 93.17 2F101A | 1 0.01 93.18 2G95ASA | 2 0.02 93.20 2G95DSA | 4 0.04 93.24 2G95GSA | 5 0.05 93.29 2G96GSA | 1 0.01 93.30 2ZP9316 | 1 0.01 93.31 3000282C00,3001491C00 | 4 0.04 93.35 3000559C00 | 3 0.03 93.38 3058938PC | 1 0.01 93.39 314569/327766 | 1 0.01 93.40 344514 | 1 0.01 93.41 347441/396922 | 1 0.01 93.42 363112/390986 | 1 0.01 93.43 3AF9ESA | 1 0.01 93.44 3DP6ASA | 1 0.01 93.45 3F218A | 1 0.01 93.46 3F267A | 2 0.02 93.48 3F278A | 2 0.02 93.50 3F379A | 2 0.02 93.52 3F76862A | 1 0.01 93.53 40411453A1 | 1 0.01 93.54 434214/495721 | 1 0.01 93.55 4511070 | 2 0.02 93.57 4DH4ASB | 1 0.01 93.58 4F359A | 1 0.01 93.59 4F561A | 1 0.01 93.60 4F848A | 1 0.01 93.61 4F870A | 2 0.02 93.63 4SM1ASA | 1 0.01 93.64 510366 | 1 0.01 93.65 512195 | 1 0.01 93.66 525575/618722 | 1 0.01 93.67 561721/770791 | 1 0.01 93.68 5C74ASA | 1 0.01 93.69 5DH4ASA | 1 0.01 93.70 5EV3ASA | 1 0.01 93.71 5F2089A | 1 0.01 93.72 5F243A | 1 0.01 93.73 5FE8ASA | 1 0.01 93.74 5HX6ASA | 5 0.05 93.79 6026223 | 1 0.01 93.80 6026224 | 1 0.01 93.81 6030047A00 | 1 0.01 93.82 6030052A00 | 1 0.01 93.83 610257531 FI | 3 0.03 93.86 630565 | 1 0.01 93.87 677092/773216 | 1 0.01 93.88 677229/197584 | 1 0.01 93.89 678199 | 1 0.01 93.90 6EV6ASA | 3 0.03 93.93 7634301 | 6 0.06 93.99 7F4623A | 3 0.03 94.02 7F4955A | 2 0.02 94.04 7F5002A | 1 0.01 94.05 7Y0292 | 1 0.01 94.06 802743/871880 | 1 0.01 94.07 802744/898927 | 1 0.01 94.08 830965/871884 | 1 0.01 94.09 853248 | 1 0.01 94.10 8F5166A | 1 0.01 94.11 8F5261A | 1 0.01 94.12 8F5354A | 1 0.01 94.13 8Y0279 | 1 0.01 94.14 904286 | 8 0.08 94.22 95371 | 1 0.01 94.23 A0494 | 2 0.02 94.25 A170562A | 1 0.01 94.26 A9067-G | 1 0.01 94.27 A943696C | 1 0.01 94.28 AA5270J | 1 0.01 94.29 AA8793B02 | 1 0.01 94.30 AB3626H | 1 0.01 94.31 AB6695B01 | 1 0.01 94.32 AH006CR | 1 0.01 94.33 AH00TPA | 1 0.01 94.34 B00240,B00060 | 1 0.01 94.35 B1201B01,B1206B01 | 2 0.02 94.37 B190410 | 1 0.01 94.38 B20051,B20071,B20141,B20091,B20131, | 8 0.08 94.46 B20102,B20112,B20172,B20262 | 2 0.02 94.48 B20131,B20151,B20303,B20343,B2032,B | 8 0.08 94.56 B62282,N3695B04 | 1 0.01 94.57 B6242,B012,B62422 | 1 0.01 94.58 B62502,H0727,H0735,N3722,H0793,N377 | 1 0.01 94.59 B88G | 1 0.01 94.60 BR4126 | 1 0.01 94.61 BXH4C75 | 1 0.01 94.62 BXH5XH3 | 1 0.01 94.63 BXHAJN2 | 1 0.01 94.64 BXHJE41 | 1 0.01 94.65 BXHT4T1 | 1 0.01 94.66 C130611 | 1 0.01 94.67 C160248 | 1 0.01 94.68 C2096C01 | 1 0.01 94.69 C383 | 1 0.01 94.70 C575488E | 1 0.01 94.71 C788572 | 1 0.01 94.72 C798807 | 1 0.01 94.73 CDF058E | 1 0.01 94.74 CN4544 | 1 0.01 94.75 D09216 | 2 0.02 94.77 DC210008W | 1 0.01 94.78 DIC535 | 1 0.01 94.79 DP046P0602/DP047P0501 | 1 0.01 94.80 DW016A0101, NP014P0202 | 1 0.01 94.81 DW016A0101, NP014P0202, NP014P0201 | 1 0.01 94.82 E005621 | 1 0.01 94.83 E116 | 1 0.01 94.84 E67261 | 1 0.01 94.85 F31085 | 1 0.01 94.86 G02470 | 1 0.01 94.87 G35883 | 1 0.01 94.88 H0016,H0004 | 1 0.01 94.89 H06453,B62502 | 1 0.01 94.90 H19368 | 1 0.01 94.91 H4219B01 | 3 0.03 94.94 H4256B01 | 8 0.08 95.02 H75169 | 1 0.01 95.03 H79759 | 1 0.01 95.04 H95949 | 1 0.01 95.05 HA111T | 1 0.01 95.06 HA29F | 1 0.01 95.07 IP015P0101, DP047P0501, OP036P0101 | 1 0.01 95.08 IP029P0101;0P043P0101 | 1 0.01 95.09 J007012 | 1 0.01 95.10 J05186 | 1 0.01 95.11 J41930 | 1 0.01 95.12 J524 | 1 0.01 95.13 J78675 | 1 0.01 95.14 J83045 | 1 0.01 95.15 KJ0224 | 1 0.01 95.16 N0004B02 | 1 0.01 95.17 N0047 | 1 0.01 95.18 N011011 | 1 0.01 95.19 N012218 | 1 0.01 95.20 N1037B01 | 3 0.03 95.23 N18484 | 2 0.02 95.25 N21721 | 1 0.01 95.26 N35021,H06453,H07303 | 4 0.04 95.30 N3756B04,B3756B05 | 2 0.02 95.32 N61570 | 1 0.01 95.33 NOT AVAILABLE | 3 0.03 95.36 NOT AVAILABLE,NOT AVAILABLE | 4 0.04 95.40 NOT AVAILABLE,NOT AVAILABLE,NOT AVA | 7 0.07 95.47 NOT PROVIDED | 7 0.07 95.54 NOT REPORTED | 30 0.30 95.84 NOT REPORTED,NOT REPORTED | 4 0.04 95.88 NOT REPORTED,NOT REPORTED,NOT REPOR | 11 0.11 95.99 P59K | 1 0.01 96.00 PAMP,PAPT | 1 0.01 96.01 POSSIBLY CDF058E (NOT 100% SURE) | 1 0.01 96.02 PT1036H02A | 8 0.08 96.10 Q578 | 1 0.01 96.11 R000213 | 1 0.01 96.12 R852 | 1 0.01 96.13 R85735 | 1 0.01 96.14 R89475 | 1 0.01 96.15 S0003B,SJ770,SCX87 | 7 0.07 96.22 S0003C,SL043,SF944,AVXS219502,AVXS0 | 10 0.10 96.32 S0021A | 1 0.01 96.33 S0023 | 1 0.01 96.34 S0073A,S0072F,S0062,SE068,SN262,ST7 | 17 0.17 96.51 S0090,S0097,SM862 | 11 0.11 96.62 S22442 | 1 0.01 96.63 S553 | 1 0.01 96.64 S80643 | 1 0.01 96.65 S96999 | 1 0.01 96.66 SC287 | 1 0.01 96.67 SDYT | 1 0.01 96.68 SH0016 | 2 0.02 96.70 SN262,SM786 | 4 0.04 96.74 SN695 | 5 0.05 96.79 SP481 | 1 0.01 96.80 SY423 | 1 0.01 96.81 T10788 | 1 0.01 96.82 T17309 | 1 0.01 96.83 T3-10003A | 1 0.01 96.84 T32685 | 1 0.01 96.85 T32687 | 1 0.01 96.86 T33181 | 1 0.01 96.87 T366 | 1 0.01 96.88 T42810 | 1 0.01 96.89 T44426 | 1 0.01 96.90 T46483 | 1 0.01 96.91 T47874 | 1 0.01 96.92 T81545 | 1 0.01 96.93 T9017 | 1 0.01 96.94 TABF | 3 0.03 96.97 UNK | 24 0.24 97.21 UNKNOWN | 256 2.56 99.77 UNKNOWN,UNKNOWN,UNKNOWN | 3 0.03 99.80 UNKNOWN;1707627P1;1710891P1 +MORE | 2 0.02 99.82 UNKNOWN;UNKNOWN | 1 0.01 99.83 UNKNWON | 3 0.03 99.86 V121822 | 1 0.01 99.87 V122014 | 1 0.01 99.88 V122301 | 1 0.01 99.89 V130028 | 1 0.01 99.90 V131368 | 1 0.01 99.91 V131604 | 1 0.01 99.92 W04056 | 1 0.01 99.93 W14413 | 1 0.01 99.94 W41032 | 1 0.01 99.95 W7MP1 | 1 0.01 99.96 W84872 | 1 0.01 99.97 WBM92546,WBM29655,WBM84211 | 1 0.01 99.98 Z0161 | 1 0.01 99.99 Z880 | 1 0.01 100.00 -------------------------------------+----------------------------------- Total | 10,000 100.00 by Jean Roth , jroth@nber.org , 7 Mar 2019