Frequencies for first 10,000 rows of lot_num variable in drug2017q2 dataset : Lot number of the drug | Freq. Percent Cum. -------------------------------------+----------------------------------- | 8,926 89.26 89.26 01200001 | 1 0.01 89.27 0820009 | 2 0.02 89.29 0903062 | 1 0.01 89.30 0908033;0908033 | 1 0.01 89.31 09J08Z06 | 1 0.01 89.32 0E934A | 1 0.01 89.33 0F046A | 2 0.02 89.35 0F689 | 2 0.02 89.37 100096,100594,101388, 100614 | 1 0.01 89.38 1006125,1070353 | 3 0.03 89.41 1011624,UNKNOWN | 3 0.03 89.44 1013650O1;UNKNOWN | 3 0.03 89.47 101757 | 1 0.01 89.48 102102E,NOT AVAILABLE | 2 0.02 89.50 1021464 | 1 0.01 89.51 1024245 | 1 0.01 89.52 1025161 | 1 0.01 89.53 1025265 | 1 0.01 89.54 1028226 | 1 0.01 89.55 1030093 | 1 0.01 89.56 1031212 | 1 0.01 89.57 1031562 | 1 0.01 89.58 1031960 | 1 0.01 89.59 1032907 | 1 0.01 89.60 1033355 | 1 0.01 89.61 1035177 | 1 0.01 89.62 1035711 | 1 0.01 89.63 1036352 | 1 0.01 89.64 1037645 | 1 0.01 89.65 1038089 | 1 0.01 89.66 1041948 | 1 0.01 89.67 1042398 | 1 0.01 89.68 1045726 | 1 0.01 89.69 104720 | 1 0.01 89.70 1047380 | 1 0.01 89.71 1051994 | 1 0.01 89.72 1055266 | 1 0.01 89.73 1058318 | 1 0.01 89.74 106165,106616,105242 | 3 0.03 89.77 1067273 | 1 0.01 89.78 106769 | 1 0.01 89.79 1067754 | 1 0.01 89.80 1069690 | 1 0.01 89.81 1071267 | 1 0.01 89.82 1071270 | 1 0.01 89.83 1071875,1006259,1006259 | 3 0.03 89.86 1071974 | 1 0.01 89.87 1072181 | 1 0.01 89.88 1073075 | 1 0.01 89.89 1073080 | 1 0.01 89.90 1074978 | 1 0.01 89.91 1075997 | 1 0.01 89.92 108074 | 1 0.01 89.93 109919 | 1 0.01 89.94 110053US | 1 0.01 89.95 110122A | 1 0.01 89.96 1105033,1105518,1103317 | 4 0.04 90.00 1113667,1107453 | 2 0.02 90.02 1116234 | 1 0.01 90.03 1116236 | 1 0.01 90.04 112968 | 1 0.01 90.05 11I26VM01 | 1 0.01 90.06 120701 | 1 0.01 90.07 1210943P1 | 1 0.01 90.08 12J092MR | 4 0.04 90.12 1360832PC | 1 0.01 90.13 1360833PC/1526647PC | 1 0.01 90.14 13D280 OR 13D283 | 1 0.01 90.15 13GG141 (05-16) | 2 0.02 90.17 140707S | 1 0.01 90.18 1426156 | 1 0.01 90.19 1470328PC, 3004820PC | 1 0.01 90.20 14BG869;17BG256 | 6 0.06 90.26 1521456PC, 3009832PC, 1426156 | 1 0.01 90.27 15A06 | 1 0.01 90.28 167624V/ 12N677A | 1 0.01 90.29 16AG085XM | 1 0.01 90.30 188711P2A | 3 0.03 90.33 1F728A | 2 0.02 90.35 1F812A | 4 0.04 90.39 1F830A | 2 0.02 90.41 1TAHB002 | 1 0.01 90.42 241932E | 1 0.01 90.43 2695ASA | 1 0.01 90.44 2F935A | 2 0.02 90.46 2F951A | 2 0.02 90.48 2G95GSA | 3 0.03 90.51 2T03089 | 1 0.01 90.52 3000158C00 | 1 0.01 90.53 3000868COO | 1 0.01 90.54 3001235C00 | 1 0.01 90.55 3009832PC | 1 0.01 90.56 302944005892 | 1 0.01 90.57 306EA | 1 0.01 90.58 344DA | 1 0.01 90.59 348194 | 1 0.01 90.60 362052A | 1 0.01 90.61 368G | 1 0.01 90.62 3AF9ESA | 3 0.03 90.65 3DP4ASA | 1 0.01 90.66 3F083A | 1 0.01 90.67 3F200A | 2 0.02 90.69 3F263A | 2 0.02 90.71 3F306A | 2 0.02 90.73 3F352A | 2 0.02 90.75 3F364A | 2 0.02 90.77 3F408A | 2 0.02 90.79 401117 | 2 0.02 90.81 41519 | 1 0.01 90.82 41522 | 1 0.01 90.83 424002 | 1 0.01 90.84 42542 | 1 0.01 90.85 43010 | 1 0.01 90.86 44638 | 1 0.01 90.87 455364 | 1 0.01 90.88 475838D | 1 0.01 90.89 494720 | 1 0.01 90.90 4F059A | 1 0.01 90.91 4F888A | 2 0.02 90.93 4G01ASA | 1 0.01 90.94 50052 | 1 0.01 90.95 504148 | 16 0.16 91.11 50893 | 1 0.01 91.12 509 | 4 0.04 91.16 511618 | 1 0.01 91.17 5140415 | 1 0.01 91.18 52701 | 1 0.01 91.19 527897 | 1 0.01 91.20 534035 | 3 0.03 91.23 53532 | 1 0.01 91.24 54178A | 1 0.01 91.25 551083 | 1 0.01 91.26 57093 | 1 0.01 91.27 57253 | 1 0.01 91.28 59825 | 1 0.01 91.29 5C74ASA | 2 0.02 91.31 5F033A | 2 0.02 91.33 5F18147A | 2 0.02 91.35 5F2088A | 1 0.01 91.36 5F2268A | 2 0.02 91.38 5F439A | 1 0.01 91.39 5F467A | 1 0.01 91.40 5FE9ASA | 1 0.01 91.41 5HN5 | 1 0.01 91.42 5JJ2ASA | 3 0.03 91.45 5K01CSA | 1 0.01 91.46 6075511 | 1 0.01 91.47 61037 | 1 0.01 91.48 62287 | 1 0.01 91.49 63049 | 1 0.01 91.50 64434 | 1 0.01 91.51 64464 | 1 0.01 91.52 64811 | 1 0.01 91.53 67486 | 1 0.01 91.54 67505 | 1 0.01 91.55 68780 | 1 0.01 91.56 68781 | 2 0.02 91.58 6888374 | 1 0.01 91.59 69357 | 1 0.01 91.60 69863 | 2 0.02 91.62 6EH7ASA | 1 0.01 91.63 6EV6ASA | 3 0.03 91.66 6F213A | 1 0.01 91.67 6F3211A | 1 0.01 91.68 6F3289A | 2 0.02 91.70 6F3300A | 2 0.02 91.72 6F3729A | 2 0.02 91.74 6F3746A | 1 0.01 91.75 6F3833A | 1 0.01 91.76 6F424A | 4 0.04 91.80 6F498A | 1 0.01 91.81 6F501A | 6 0.06 91.87 6FW1ASA | 6 0.06 91.93 6FW2ASA | 2 0.02 91.95 6FW3ASA | 2 0.02 91.97 72079 | 1 0.01 91.98 7211477 | 2 0.02 92.00 72949 | 1 0.01 92.01 73343 | 1 0.01 92.02 74365 | 1 0.01 92.03 76675 | 1 0.01 92.04 77871 | 1 0.01 92.05 77909 | 1 0.01 92.06 79228 | 1 0.01 92.07 79566 | 1 0.01 92.08 79934 | 1 0.01 92.09 7F4037A | 3 0.03 92.12 80367 | 1 0.01 92.13 80429 | 1 0.01 92.14 80433 | 2 0.02 92.16 826B | 1 0.01 92.17 835152/957992 | 1 0.01 92.18 87125 | 1 0.01 92.19 91143 | 1 0.01 92.20 9189602 | 1 0.01 92.21 930165 | 1 0.01 92.22 941517 | 1 0.01 92.23 969069/168140 | 1 0.01 92.24 A09022/06-A | 2 0.02 92.26 A2421 | 1 0.01 92.27 A349686 | 1 0.01 92.28 A445841 | 1 0.01 92.29 A81CA092A | 1 0.01 92.30 A90 | 1 0.01 92.31 ABME13A | 1 0.01 92.32 AE1229B01 | 1 0.01 92.33 AF7437K | 1 0.01 92.34 AG1728L | 1 0.01 92.35 AH0024,JB0404 | 1 0.01 92.36 AT0062 | 1 0.01 92.37 AT04018 | 1 0.01 92.38 B087503 | 3 0.03 92.41 B134502 | 1 0.01 92.42 B20172,B30131 | 1 0.01 92.43 B2052,B2044 | 3 0.03 92.46 B6091B01, B6034B01 | 2 0.02 92.48 B6205A, B6072A | 1 0.01 92.49 B62282 | 1 0.01 92.50 B62352 | 3 0.03 92.53 BA0156 | 1 0.01 92.54 BD0001 | 1 0.01 92.55 BK1400782;UNKNOWN | 3 0.03 92.58 BR4126 | 1 0.01 92.59 C001883A | 1 0.01 92.60 C001895A | 1 0.01 92.61 C053194A | 1 0.01 92.62 C087533A | 1 0.01 92.63 C130432 | 1 0.01 92.64 C292706A | 1 0.01 92.65 C467947D | 1 0.01 92.66 C6390H02 | 1 0.01 92.67 C762537 | 1 0.01 92.68 C764454 | 1 0.01 92.69 C771172 | 2 0.02 92.71 C788574 | 2 0.02 92.73 C798805 | 1 0.01 92.74 CK0058 | 1 0.01 92.75 D0673-1 | 1 0.01 92.76 D1536MF | 2 0.02 92.78 DESCONHECIDO | 1 0.01 92.79 DGM52013 | 1 0.01 92.80 DHB4100/DHB43 | 1 0.01 92.81 DJM49011 | 3 0.03 92.84 DW016A0101, NP014P0202 | 2 0.02 92.86 E927A | 1 0.01 92.87 EG040G0401/GG051G0103/WG003360105 | 1 0.01 92.88 F11505511 | 1 0.01 92.89 F95872/G02463 | 1 0.01 92.90 G009242 | 1 0.01 92.91 G02350 | 1 0.01 92.92 G02463 | 1 0.01 92.93 G4910 | 1 0.01 92.94 G52690 | 2 0.02 92.96 G79999 | 1 0.01 92.97 G94914 | 1 0.01 92.98 GIM62016 | 3 0.03 93.01 H0001 | 1 0.01 93.02 H0004 | 1 0.01 93.03 H0006 | 2 0.02 93.05 H006 | 1 0.01 93.06 H0127B12 | 1 0.01 93.07 H0760,N3702,N3738,N3771 | 1 0.01 93.08 H09331 | 1 0.01 93.09 H563685 | 1 0.01 93.10 H56385 | 1 0.01 93.11 H71976 | 1 0.01 93.12 HA080C | 1 0.01 93.13 HA111T | 1 0.01 93.14 HF1801 | 1 0.01 93.15 HH0473 | 1 0.01 93.16 HH0892 | 1 0.01 93.17 HN0440 | 1 0.01 93.18 IC007K | 1 0.01 93.19 IP033P0102 | 1 0.01 93.20 IP041P0101;IP044P0101, IP045P0101 | 1 0.01 93.21 J171 | 3 0.03 93.24 J524 | 1 0.01 93.25 J933 | 1 0.01 93.26 K1400079 | 1 0.01 93.27 L01035 | 1 0.01 93.28 L05303 | 1 0.01 93.29 L11892 | 1 0.01 93.30 M009 | 1 0.01 93.31 M95104 | 1 0.01 93.32 MA00ISM,MA02BPH | 1 0.01 93.33 MA00P3N,MA026BR,MA02BP4,MA02FRR | 1 0.01 93.34 MADC09 | 1 0.01 93.35 MG2262 | 1 0.01 93.36 MO3126 | 1 0.01 93.37 MP2-D-6-D | 1 0.01 93.38 MPC GPCS 159520 | 1 0.01 93.39 N145 | 1 0.01 93.40 N35021,B62392,N33021,H0793,N3728 | 2 0.02 93.42 N35913 | 9 0.09 93.51 N3681 | 9 0.09 93.60 N3722 | 2 0.02 93.62 N437 | 1 0.01 93.63 N47218 | 1 0.01 93.64 N93388 | 1 0.01 93.65 NOT AVAILABLE | 1 0.01 93.66 NOT AVAILABLE,NOT AVAILABLE,NOT AVA | 4 0.04 93.70 NOT PROVIDED | 11 0.11 93.81 NOT REPORTED | 57 0.57 94.38 NOT REQUIRED | 2 0.02 94.40 OBTWC | 1 0.01 94.41 OL59505 | 1 0.01 94.42 OM43147 | 1 0.01 94.43 OM43150 | 1 0.01 94.44 OP029P0101 | 1 0.01 94.45 OP030P0101 | 1 0.01 94.46 P048757 | 1 0.01 94.47 P267 | 1 0.01 94.48 PAMY | 3 0.03 94.51 PDH0000143 | 2 0.02 94.53 PHD0000143 | 1 0.01 94.54 PT1036H02A | 8 0.08 94.62 PT1036H02A,PT1036H02A,PT1036H02A,PT | 6 0.06 94.68 Q125 | 2 0.02 94.70 R02463 | 1 0.01 94.71 R19861 | 1 0.01 94.72 R271A | 2 0.02 94.74 R301C | 1 0.01 94.75 R45536 | 1 0.01 94.76 R614 | 1 0.01 94.77 R65077 | 1 0.01 94.78 R65081 | 1 0.01 94.79 R65118 | 1 0.01 94.80 R76164 | 1 0.01 94.81 R852 | 1 0.01 94.82 S0003C,SH732 | 9 0.09 94.91 S0004,SE068 | 9 0.09 95.00 S0034 | 1 0.01 95.01 S0041 | 1 0.01 95.02 S0053 | 1 0.01 95.03 S0058 | 2 0.02 95.05 S0060 | 1 0.01 95.06 S0065E,SD875 | 7 0.07 95.13 S0066B,S0003B,SE068 | 9 0.09 95.22 S0072C,S0078A,S0065A,S0077A,S0078A, | 1 0.01 95.23 S0073A,S0072F,S0062,SE068 | 13 0.13 95.36 S0116 | 1 0.01 95.37 S0333 | 1 0.01 95.38 S276 | 1 0.01 95.39 S501 | 1 0.01 95.40 S553 | 1 0.01 95.41 S562 | 1 0.01 95.42 S706 | 3 0.03 95.45 S707 | 1 0.01 95.46 SB941A | 1 0.01 95.47 SD905A | 1 0.01 95.48 SE068 | 5 0.05 95.53 SE068,S0004 | 7 0.07 95.60 SE418 | 1 0.01 95.61 SH732 | 3 0.03 95.64 SO207 | 1 0.01 95.65 SO220 | 1 0.01 95.66 T1-10005A | 1 0.01 95.67 T2-AA9358C | 1 0.01 95.68 T2-AB5116C,T2-AC0985B01 | 1 0.01 95.69 T2-AB5117C | 1 0.01 95.70 T2-AB5118D, T2-AC0984B01 | 1 0.01 95.71 T2-AB7975C,T3-AC1963B01 | 1 0.01 95.72 T3-A98177C | 1 0.01 95.73 T9017 | 1 0.01 95.74 U | 1 0.01 95.75 UM012N0301, UM020A0301 | 1 0.01 95.76 UNK | 67 0.67 96.43 UNKNOWN | 295 2.95 99.38 UNKNOWN,69218XD02 | 2 0.02 99.40 UNKNOWN,UNKNOWN | 12 0.12 99.52 UNKNOWN,UNKNOWN,UNKNOWN,UNKNOWN | 4 0.04 99.56 UNKNOWN,UNKNOWN,UNKNOWN,UNKNOWN,UNK | 5 0.05 99.61 UNKNOWN;1513734P1;UNKNOWN +MORE | 5 0.05 99.66 UNKNOWN;UNKNOWN | 9 0.09 99.75 UNKNWON | 1 0.01 99.76 V049 | 3 0.03 99.79 V785 | 2 0.02 99.81 WG0033G0105 | 1 0.01 99.82 WG01360101 | 1 0.01 99.83 X037076AA | 2 0.02 99.85 X20XDZ | 1 0.01 99.86 X210C9 | 1 0.01 99.87 X21DSU | 1 0.01 99.88 X21DUA | 1 0.01 99.89 X21EH3 | 1 0.01 99.90 X21FC6 | 1 0.01 99.91 Z102308 | 1 0.01 99.92 Z111 | 2 0.02 99.94 Z606 | 2 0.02 99.96 Z880 | 2 0.02 99.98 ZWU11568,ZWU70942 | 2 0.02 100.00 -------------------------------------+----------------------------------- Total | 10,000 100.00 by Jean Roth , jroth@nber.org , 8 Feb 2018