Created
October 15, 2019 04:36
-
-
Save etrepum/883915769bbbee9a3c1d0425e18fb6d3 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "cells": [ | |
| { | |
| "metadata": { | |
| "trusted": true | |
| }, | |
| "cell_type": "code", | |
| "source": "import pandas as pd\nimport requests\nimport zipfile\nimport json\nimport io\n\ndef read_zip_json(url):\n req = requests.get(url)\n zf = zipfile.ZipFile(io.BytesIO(req.content))\n for name in zf.namelist():\n if name.endswith('.json'):\n with zf.open(name) as f:\n return json.load(f)\n else:\n raise ValueError(\"No JSON found in zip file\")", | |
| "execution_count": 4, | |
| "outputs": [] | |
| }, | |
| { | |
| "metadata": { | |
| "trusted": true | |
| }, | |
| "cell_type": "code", | |
| "source": "URL = \"https://download.open.fda.gov/drug/enforcement/drug-enforcement-0001-of-0001.json.zip\"\n\njson = read_zip_json(URL)\njson.keys()", | |
| "execution_count": 5, | |
| "outputs": [ | |
| { | |
| "output_type": "execute_result", | |
| "execution_count": 5, | |
| "data": { | |
| "text/plain": "dict_keys(['meta', 'results'])" | |
| }, | |
| "metadata": {} | |
| } | |
| ] | |
| }, | |
| { | |
| "metadata": { | |
| "trusted": true | |
| }, | |
| "cell_type": "code", | |
| "source": "json[\"meta\"]", | |
| "execution_count": 6, | |
| "outputs": [ | |
| { | |
| "output_type": "execute_result", | |
| "execution_count": 6, | |
| "data": { | |
| "text/plain": "{'last_updated': '2019-10-11',\n 'terms': 'https://open.fda.gov/terms/',\n 'results': {'skip': 0, 'total': 10417, 'limit': 10417},\n 'license': 'https://open.fda.gov/license/',\n 'disclaimer': 'Do not rely on openFDA to make decisions regarding medical care. While we make every effort to ensure that data is accurate, you should assume all results are unvalidated. We may limit or otherwise restrict your access to the API in line with our Terms of Service.'}" | |
| }, | |
| "metadata": {} | |
| } | |
| ] | |
| }, | |
| { | |
| "metadata": { | |
| "trusted": true | |
| }, | |
| "cell_type": "code", | |
| "source": "from pandas.io.json import json_normalize\n\ndf = pd.DataFrame(json_normalize(json[\"results\"]))\ndf", | |
| "execution_count": 15, | |
| "outputs": [ | |
| { | |
| "output_type": "execute_result", | |
| "execution_count": 15, | |
| "data": { | |
| "text/html": "<div>\n<style scoped>\n .dataframe tbody tr th:only-of-type {\n vertical-align: middle;\n }\n\n .dataframe tbody tr th {\n vertical-align: top;\n }\n\n .dataframe thead th {\n text-align: right;\n }\n</style>\n<table border=\"1\" class=\"dataframe\">\n <thead>\n <tr style=\"text-align: right;\">\n <th></th>\n <th>address_1</th>\n <th>address_2</th>\n <th>center_classification_date</th>\n <th>city</th>\n <th>classification</th>\n <th>code_info</th>\n <th>country</th>\n <th>distribution_pattern</th>\n <th>event_id</th>\n <th>initial_firm_notification</th>\n <th>...</th>\n <th>product_type</th>\n <th>reason_for_recall</th>\n <th>recall_initiation_date</th>\n <th>recall_number</th>\n <th>recalling_firm</th>\n <th>report_date</th>\n <th>state</th>\n <th>status</th>\n <th>termination_date</th>\n <th>voluntary_mandated</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>0</th>\n <td>8 Joanna Ct</td>\n <td></td>\n <td>20121025</td>\n <td>East Brunswick</td>\n <td>Class II</td>\n <td>Lots a) 15952, 16270,16425, Exp 06/15; b)16459...</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>63384</td>\n <td>E-Mail</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Microbial Contamination of Non-Sterile Product...</td>\n <td>20120904</td>\n <td>D-026-2013</td>\n <td>Raritan Pharmaceuticals, Inc.</td>\n <td>20121031</td>\n <td>NJ</td>\n <td>Terminated</td>\n <td>20141007</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>1</th>\n <td>8 Joanna Ct</td>\n <td></td>\n <td>20121025</td>\n <td>East Brunswick</td>\n <td>Class II</td>\n <td>Lot 15087, Exp 08/15</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>63384</td>\n <td>E-Mail</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Microbial Contamination of Non-Sterile Product...</td>\n <td>20120904</td>\n <td>D-031-2013</td>\n <td>Raritan Pharmaceuticals, Inc.</td>\n <td>20121031</td>\n <td>NJ</td>\n <td>Terminated</td>\n <td>20141007</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>2</th>\n <td>571 Se 14th St</td>\n <td></td>\n <td>20121101</td>\n <td>Pompano Beach</td>\n <td>Class I</td>\n <td>UPC 0 00309 50792 7 All Lots</td>\n <td>United States</td>\n <td>Products were distributed nationwide and inter...</td>\n <td>61669</td>\n <td>Two or more of the following: Email, Fax, Lett...</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Marketed Without an Approved NDA/ANDA: product...</td>\n <td>20120421</td>\n <td>D-037-2013</td>\n <td>XRock Industries, LLC</td>\n <td>20121107</td>\n <td>FL</td>\n <td>Terminated</td>\n <td>20151130</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>3</th>\n <td>700 Rte 206 North</td>\n <td></td>\n <td>20121106</td>\n <td>Bridgewater</td>\n <td>Class III</td>\n <td>All lots with expiration dates between 10/10/1...</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>63488</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Subpotent (Single Ingredient) Drug: This produ...</td>\n <td>20121015</td>\n <td>D-047-2013</td>\n <td>Valeant Pharmaceuticals</td>\n <td>20121114</td>\n <td>NJ</td>\n <td>Terminated</td>\n <td>20130325</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>4</th>\n <td>2481 Hilton Dr</td>\n <td></td>\n <td>20121109</td>\n <td>Gainesville</td>\n <td>Class III</td>\n <td>Lot 06JN1265 Exp 3/14 and 06JN1266 Exp 4/14</td>\n <td>United States</td>\n <td>FL, PA, and VA.</td>\n <td>62940</td>\n <td>E-Mail</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Labeling: Label Mix-up: The affected units wer...</td>\n <td>20120618</td>\n <td>D-050-2013</td>\n <td>Stat Rx USA</td>\n <td>20121121</td>\n <td>GA</td>\n <td>Terminated</td>\n <td>20130131</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>5</th>\n <td>199 Grandview Rd</td>\n <td></td>\n <td>20121220</td>\n <td>Skillman</td>\n <td>Class III</td>\n <td>0142VA, 0132VB, 0112VC, 0122VB, 0102VA, 0102VB...</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>63787</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Superpotent (Single Ingredient Drug): salicyli...</td>\n <td>20121204</td>\n <td>D-098-2013</td>\n <td>Johnson & Johnson</td>\n <td>20121226</td>\n <td>NJ</td>\n <td>Terminated</td>\n <td>20140429</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>6</th>\n <td>697 Waverly St</td>\n <td></td>\n <td>20121231</td>\n <td>Framingham</td>\n <td>Class II</td>\n <td>All lot codes</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>63305</td>\n <td>Two or more of the following: Email, Fax, Lett...</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility</td>\n <td>20120926</td>\n <td>D-118-2013</td>\n <td>New England Compounding Center</td>\n <td>20130109</td>\n <td>MA</td>\n <td>Terminated</td>\n <td>20161007</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>7</th>\n <td>1 DNA Way</td>\n <td></td>\n <td>20130122</td>\n <td>South San Francisco</td>\n <td>Class I</td>\n <td>Lot #: 454138, Exp 07/14 (containing Trastuzum...</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>63258</td>\n <td>E-Mail</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Presence of Particulate Matter: One lot of Bac...</td>\n <td>20120730</td>\n <td>D-135-2013</td>\n <td>Genentech Inc</td>\n <td>20130130</td>\n <td>CA</td>\n <td>Terminated</td>\n <td>20130325</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>8</th>\n <td>120 Vintage Dr NE</td>\n <td></td>\n <td>20130130</td>\n <td>Huntsville</td>\n <td>Class I</td>\n <td>Lot #: All that begin with the letter \"C\" a) C...</td>\n <td>United States</td>\n <td>Nationwide and Puerto Rico</td>\n <td>63818</td>\n <td>Press Release</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Superpotent (Multiple Ingredient) Drug: Compla...</td>\n <td>20121206</td>\n <td>D-138-2013</td>\n <td>Vintage Pharmaceuticals LLC DBA Qualitest Phar...</td>\n <td>20130206</td>\n <td>AL</td>\n <td>Ongoing</td>\n <td>NaN</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>9</th>\n <td>11865 Alameda St</td>\n <td>11840 S Alameda ST</td>\n <td>20130307</td>\n <td>Lynwood</td>\n <td>Class III</td>\n <td>Lot# 71648, 68088; FP-47-041-02535</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>64298</td>\n <td>Two or more of the following: Email, Fax, Lett...</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Presence of Precipitate; white substance confi...</td>\n <td>20130118</td>\n <td>D-187-2013</td>\n <td>Aaron Industries Inc</td>\n <td>20130313</td>\n <td>CA</td>\n <td>Terminated</td>\n <td>20131101</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>10</th>\n <td>Route 120 And Wilson Rd</td>\n <td></td>\n <td>20120925</td>\n <td>Round Lake</td>\n <td>Class II</td>\n <td>Lot #: C828814, Exp 12/12; C841551, Exp 04/13</td>\n <td>United States</td>\n <td>Nationwide and Puerto Rico</td>\n <td>63189</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Chemical Contamination: The IV solutions were ...</td>\n <td>20120921</td>\n <td>D-1688-2012</td>\n <td>Baxter Healthcare Corp.</td>\n <td>20121003</td>\n <td>IL</td>\n <td>Terminated</td>\n <td>20150504</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>11</th>\n <td>9275 Sky Park Ct Ste 101</td>\n <td></td>\n <td>20121018</td>\n <td>San Diego</td>\n <td>Class II</td>\n <td>Lot #: 009-22-A011, 011-28-A011, 004-01-A012,...</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>63406</td>\n <td>E-Mail</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Marketed Without An Approved NDA/ANDA: This pr...</td>\n <td>20121005</td>\n <td>D-009-2013</td>\n <td>Earthborn Products, Inc.</td>\n <td>20121024</td>\n <td>CA</td>\n <td>Terminated</td>\n <td>20130228</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>12</th>\n <td>120 Vintage Dr NE</td>\n <td></td>\n <td>20121022</td>\n <td>Huntsville</td>\n <td>Class II</td>\n <td>Lot C1130511A, Exp 5/13</td>\n <td>United States</td>\n <td>Nationwide and Puerto Rico</td>\n <td>63502</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Tablet Separation: Possibility of cracked or s...</td>\n <td>20121011</td>\n <td>D-010-2013</td>\n <td>Vintage Pharmaceuticals LLC DBA Qualitest Phar...</td>\n <td>20121031</td>\n <td>AL</td>\n <td>Terminated</td>\n <td>20131209</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>13</th>\n <td>1 Squibb Dr</td>\n <td></td>\n <td>20121024</td>\n <td>New Brunswick</td>\n <td>Class II</td>\n <td>Lot # 1J6024PA, 1J6025PA Exp. 09/13; 1K6049PA ...</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>62898</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Labeling; Correct labeled product miscart/misp...</td>\n <td>20120605</td>\n <td>D-019-2013</td>\n <td>Bristol-myers Squibb Company</td>\n <td>20121031</td>\n <td>NJ</td>\n <td>Terminated</td>\n <td>20130710</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>14</th>\n <td>700 Rte 206 North</td>\n <td></td>\n <td>20121106</td>\n <td>Bridgewater</td>\n <td>Class III</td>\n <td>All lots with expiration dates between 10/10/1...</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>63488</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Subpotent (Single Ingredient) Drug: This produ...</td>\n <td>20121015</td>\n <td>D-048-2013</td>\n <td>Valeant Pharmaceuticals</td>\n <td>20121114</td>\n <td>NJ</td>\n <td>Terminated</td>\n <td>20130325</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>15</th>\n <td>8700 Mason Montgomery Rd</td>\n <td></td>\n <td>20121129</td>\n <td>Mason</td>\n <td>Class II</td>\n <td>Lot #2278171941, Exp. 09/14, Lot #2282171981,...</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>63661</td>\n <td>Two or more of the following: Email, Fax, Lett...</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Labeling Illegible: Portions of the product la...</td>\n <td>20121108</td>\n <td>D-069-2013</td>\n <td>Procter & Gamble Co</td>\n <td>20121205</td>\n <td>OH</td>\n <td>Terminated</td>\n <td>20131223</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>16</th>\n <td>604 W Thomas Ave</td>\n <td></td>\n <td>20121203</td>\n <td>Shenandoah</td>\n <td>Class II</td>\n <td>Lot #1095212 exp. 4/30/2013; and #1088877, exp...</td>\n <td>United States</td>\n <td>Distribution was nationwide, including Puerto ...</td>\n <td>62511</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>cGMP Deviations; does not meet in process spec...</td>\n <td>20120709</td>\n <td>D-083-2013</td>\n <td>Lloyd Inc. of Iowa</td>\n <td>20121212</td>\n <td>IA</td>\n <td>Terminated</td>\n <td>20131114</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>17</th>\n <td>697 Waverly St</td>\n <td></td>\n <td>20121231</td>\n <td>Framingham</td>\n <td>Class II</td>\n <td>All lot codes</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>63305</td>\n <td>Two or more of the following: Email, Fax, Lett...</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility</td>\n <td>20120926</td>\n <td>D-124-2013</td>\n <td>New England Compounding Center</td>\n <td>20130109</td>\n <td>MA</td>\n <td>Terminated</td>\n <td>20161007</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>18</th>\n <td>Road 195, Km 1.1</td>\n <td>Union Street</td>\n <td>20130131</td>\n <td>Fajardo</td>\n <td>Class III</td>\n <td>0.45 mg: 505969A</td>\n <td>United States</td>\n <td>US Nationwide</td>\n <td>64014</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Failed Impurity/Degradation Specifications due...</td>\n <td>20121221</td>\n <td>D-142-2013</td>\n <td>Warner Chilcott Company LLC</td>\n <td>20130206</td>\n <td>PR</td>\n <td>Terminated</td>\n <td>20150616</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>19</th>\n <td>60 Columbia Rd Bldg B</td>\n <td></td>\n <td>20130227</td>\n <td>Morristown</td>\n <td>Class III</td>\n <td>Lot CB1D05A,</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>64317</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Failed Dissolution Specifications; 8-hours for...</td>\n <td>20130104</td>\n <td>D-175-2013</td>\n <td>Actavis Pharmaceuticals</td>\n <td>20130306</td>\n <td>NJ</td>\n <td>Terminated</td>\n <td>20140113</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>20</th>\n <td>126 East Main Street</td>\n <td></td>\n <td>20131203</td>\n <td>Newbern</td>\n <td>Class II</td>\n <td>all codes distributed prior to and including 0...</td>\n <td>United States</td>\n <td>nationwide, specifically: AK, AL, AZ, CA, CO,...</td>\n <td>65479</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>The firm received seven reports of adverse rea...</td>\n <td>20130528</td>\n <td>D-176-2014</td>\n <td>Main Street Family Pharmacy, LLC</td>\n <td>20131211</td>\n <td>TN</td>\n <td>Terminated</td>\n <td>20140422</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>21</th>\n <td>126 East Main Street</td>\n <td></td>\n <td>20131203</td>\n <td>Newbern</td>\n <td>Class II</td>\n <td>all codes distributed prior to and including 0...</td>\n <td>United States</td>\n <td>nationwide, specifically: AK, AL, AZ, CA, CO,...</td>\n <td>65479</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>The firm received seven reports of adverse rea...</td>\n <td>20130528</td>\n <td>D-103-2014</td>\n <td>Main Street Family Pharmacy, LLC</td>\n <td>20131211</td>\n <td>TN</td>\n <td>Terminated</td>\n <td>20140422</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>22</th>\n <td>126 East Main Street</td>\n <td></td>\n <td>20131203</td>\n <td>Newbern</td>\n <td>Class II</td>\n <td>all codes distributed prior to and including 0...</td>\n <td>United States</td>\n <td>nationwide, specifically: AK, AL, AZ, CA, CO,...</td>\n <td>65479</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>The firm received seven reports of adverse rea...</td>\n <td>20130528</td>\n <td>D-159-2014</td>\n <td>Main Street Family Pharmacy, LLC</td>\n <td>20131211</td>\n <td>TN</td>\n <td>Terminated</td>\n <td>20140422</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>23</th>\n <td>126 East Main Street</td>\n <td></td>\n <td>20131203</td>\n <td>Newbern</td>\n <td>Class II</td>\n <td>all codes distributed prior to and including 0...</td>\n <td>United States</td>\n <td>nationwide, specifically: AK, AL, AZ, CA, CO,...</td>\n <td>65479</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>The firm received seven reports of adverse rea...</td>\n <td>20130528</td>\n <td>D-280-2014</td>\n <td>Main Street Family Pharmacy, LLC</td>\n <td>20131211</td>\n <td>TN</td>\n <td>Terminated</td>\n <td>20140422</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>24</th>\n <td>126 East Main Street</td>\n <td></td>\n <td>20131203</td>\n <td>Newbern</td>\n <td>Class II</td>\n <td>all codes distributed prior to and including 0...</td>\n <td>United States</td>\n <td>nationwide, specifically: AK, AL, AZ, CA, CO,...</td>\n <td>65479</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>The firm received seven reports of adverse rea...</td>\n <td>20130528</td>\n <td>D-255-2014</td>\n <td>Main Street Family Pharmacy, LLC</td>\n <td>20131211</td>\n <td>TN</td>\n <td>Terminated</td>\n <td>20140422</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>25</th>\n <td>126 East Main Street</td>\n <td></td>\n <td>20131203</td>\n <td>Newbern</td>\n <td>Class II</td>\n <td>all codes distributed prior to and including 0...</td>\n <td>United States</td>\n <td>nationwide, specifically: AK, AL, AZ, CA, CO,...</td>\n <td>65479</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>The firm received seven reports of adverse rea...</td>\n <td>20130528</td>\n <td>D-037-2014</td>\n <td>Main Street Family Pharmacy, LLC</td>\n <td>20131211</td>\n <td>TN</td>\n <td>Terminated</td>\n <td>20140422</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>26</th>\n <td>126 East Main Street</td>\n <td></td>\n <td>20131203</td>\n <td>Newbern</td>\n <td>Class II</td>\n <td>all codes distributed prior to and including 0...</td>\n <td>United States</td>\n <td>nationwide, specifically: AK, AL, AZ, CA, CO,...</td>\n <td>65479</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>The firm received seven reports of adverse rea...</td>\n <td>20130528</td>\n <td>D-171-2014</td>\n <td>Main Street Family Pharmacy, LLC</td>\n <td>20131211</td>\n <td>TN</td>\n <td>Terminated</td>\n <td>20140422</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>27</th>\n <td>126 East Main Street</td>\n <td></td>\n <td>20131203</td>\n <td>Newbern</td>\n <td>Class II</td>\n <td>all codes distributed prior to and including 0...</td>\n <td>United States</td>\n <td>nationwide, specifically: AK, AL, AZ, CA, CO,...</td>\n <td>65479</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>The firm received seven reports of adverse rea...</td>\n <td>20130528</td>\n <td>D-035-2014</td>\n <td>Main Street Family Pharmacy, LLC</td>\n <td>20131211</td>\n <td>TN</td>\n <td>Terminated</td>\n <td>20140422</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>28</th>\n <td>126 East Main Street</td>\n <td></td>\n <td>20131203</td>\n <td>Newbern</td>\n <td>Class II</td>\n <td>all codes distributed prior to and including 0...</td>\n <td>United States</td>\n <td>nationwide, specifically: AK, AL, AZ, CA, CO,...</td>\n <td>65479</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>The firm received seven reports of adverse rea...</td>\n <td>20130528</td>\n <td>D-262-2014</td>\n <td>Main Street Family Pharmacy, LLC</td>\n <td>20131211</td>\n <td>TN</td>\n <td>Terminated</td>\n <td>20140422</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>29</th>\n <td>126 East Main Street</td>\n <td></td>\n <td>20131203</td>\n <td>Newbern</td>\n <td>Class II</td>\n <td>all codes distributed prior to and including 0...</td>\n <td>United States</td>\n <td>nationwide, specifically: AK, AL, AZ, CA, CO,...</td>\n <td>65479</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>The firm received seven reports of adverse rea...</td>\n <td>20130528</td>\n <td>D-060-2014</td>\n <td>Main Street Family Pharmacy, LLC</td>\n <td>20131211</td>\n <td>TN</td>\n <td>Terminated</td>\n <td>20140422</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>...</th>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n </tr>\n <tr>\n <th>10387</th>\n <td>113 W Victoria St</td>\n <td></td>\n <td>20160304</td>\n <td>Long Beach</td>\n <td>Class II</td>\n <td>BUD: 5/3/2016</td>\n <td>United States</td>\n <td>Nationwide. No foreign distribution.</td>\n <td>73304</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility</td>\n <td>20160204</td>\n <td>D-0765-2016</td>\n <td>Hartley Medical Center Pharmacy, Incorporated</td>\n <td>20160316</td>\n <td>CA</td>\n <td>Terminated</td>\n <td>20160809</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10388</th>\n <td>113 W Victoria St</td>\n <td></td>\n <td>20160304</td>\n <td>Long Beach</td>\n <td>Class II</td>\n <td>BUD: 5/3/2016</td>\n <td>United States</td>\n <td>Nationwide. No foreign distribution.</td>\n <td>73304</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility</td>\n <td>20160204</td>\n <td>D-0745-2016</td>\n <td>Hartley Medical Center Pharmacy, Incorporated</td>\n <td>20160316</td>\n <td>CA</td>\n <td>Terminated</td>\n <td>20160809</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10389</th>\n <td>113 W Victoria St</td>\n <td></td>\n <td>20160304</td>\n <td>Long Beach</td>\n <td>Class II</td>\n <td>BUD: 5/3/2016</td>\n <td>United States</td>\n <td>Nationwide. No foreign distribution.</td>\n <td>73304</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility</td>\n <td>20160204</td>\n <td>D-0737-2016</td>\n <td>Hartley Medical Center Pharmacy, Incorporated</td>\n <td>20160316</td>\n <td>CA</td>\n <td>Terminated</td>\n <td>20160809</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10390</th>\n <td>5187 Camino Ruiz</td>\n <td></td>\n <td>20160309</td>\n <td>Camarillo</td>\n <td>Class III</td>\n <td>Lot #GS005602; Exp. 10/15 Lot #GS008855; Exp....</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>73152</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Failed Impurities/Degradation Specifications</td>\n <td>20160127</td>\n <td>D-0767-2016</td>\n <td>Golden State Medical Supply Inc.</td>\n <td>20160316</td>\n <td>CA</td>\n <td>Terminated</td>\n <td>20160628</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10391</th>\n <td>1215 Main St</td>\n <td></td>\n <td>20140513</td>\n <td>Asbury Park</td>\n <td>Class II</td>\n <td>Lot #: 201302275, Exp 01/20/15; 201308384, Exp...</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>68158</td>\n <td>Press Release</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Marketed Without An Approved NDA/ANDA: Parente...</td>\n <td>20140429</td>\n <td>D-1318-2014</td>\n <td>Flawless Beauty LLC</td>\n <td>20140521</td>\n <td>NJ</td>\n <td>Ongoing</td>\n <td>NaN</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10392</th>\n <td>1 Baxter Pkwy</td>\n <td></td>\n <td>20130628</td>\n <td>Deerfield</td>\n <td>Class II</td>\n <td>Lot #: a) Product code 2B0042: P285668, P28566...</td>\n <td>United States</td>\n <td>Nationwide & Puerto Rico</td>\n <td>65288</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility: Specific lot n...</td>\n <td>20130521</td>\n <td>D-624-2013</td>\n <td>Baxter Healthcare Corp.</td>\n <td>20130710</td>\n <td>IL</td>\n <td>Terminated</td>\n <td>20150618</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>10393</th>\n <td>4001 McEwen Rd Suite 110</td>\n <td></td>\n <td>20151118</td>\n <td>Dallas</td>\n <td>Class II</td>\n <td>All lots</td>\n <td>United States</td>\n <td>Nationwide in the US; Australia, Brazil, Baham...</td>\n <td>72455</td>\n <td>Press Release</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility</td>\n <td>20151016</td>\n <td>D-0376-2016</td>\n <td>Downing Labs, LLC</td>\n <td>20151125</td>\n <td>TX</td>\n <td>Terminated</td>\n <td>20160922</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10394</th>\n <td>4625 N University St</td>\n <td></td>\n <td>20151117</td>\n <td>Peoria</td>\n <td>Class II</td>\n <td>Lot #: 062915, Exp 09/29/2015; 070915, Exp 10/...</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>72241</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility: A recall of a...</td>\n <td>20150903</td>\n <td>D-302-2016</td>\n <td>Kalman Health & Wellness, Inc. dba Essential W...</td>\n <td>20151125</td>\n <td>IL</td>\n <td>Terminated</td>\n <td>20171229</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10395</th>\n <td>4001 McEwen Rd Suite 110</td>\n <td></td>\n <td>20151118</td>\n <td>Dallas</td>\n <td>Class II</td>\n <td>All lots</td>\n <td>United States</td>\n <td>Nationwide in the US; Australia, Brazil, Baham...</td>\n <td>72455</td>\n <td>Press Release</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility</td>\n <td>20151016</td>\n <td>D-0342-2016</td>\n <td>Downing Labs, LLC</td>\n <td>20151125</td>\n <td>TX</td>\n <td>Terminated</td>\n <td>20160922</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10396</th>\n <td>1270 Don's Lane</td>\n <td></td>\n <td>20151117</td>\n <td>Conway</td>\n <td>Class II</td>\n <td>Lot Numbers: 20150408@10 BUD: 1/27/2015; 20151...</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>72179</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility; The firm is re...</td>\n <td>20150912</td>\n <td>D-0237-2016</td>\n <td>US Compounding Inc</td>\n <td>20151125</td>\n <td>AR</td>\n <td>Terminated</td>\n <td>20170330</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10397</th>\n <td>4625 N University St</td>\n <td></td>\n <td>20151117</td>\n <td>Peoria</td>\n <td>Class II</td>\n <td>Lot #: 072915, Exp 09/13/2015</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>72241</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility: A recall of a...</td>\n <td>20150903</td>\n <td>D-317-2016</td>\n <td>Kalman Health & Wellness, Inc. dba Essential W...</td>\n <td>20151125</td>\n <td>IL</td>\n <td>Terminated</td>\n <td>20171229</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10398</th>\n <td>1270 Don's Lane</td>\n <td></td>\n <td>20151117</td>\n <td>Conway</td>\n <td>Class II</td>\n <td>Lot Code: 20150806@1 BUD: 12/5/2015, 20150806@...</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>72179</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility; The firm is re...</td>\n <td>20150912</td>\n <td>D-0276-2016</td>\n <td>US Compounding Inc</td>\n <td>20151125</td>\n <td>AR</td>\n <td>Terminated</td>\n <td>20170330</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10399</th>\n <td>1270 Don's Lane</td>\n <td></td>\n <td>20151117</td>\n <td>Conway</td>\n <td>Class II</td>\n <td>Lot Numbers: 20150705@1 BUD: 11/2/2015; 201517...</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>72179</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility; The firm is re...</td>\n <td>20150912</td>\n <td>D-0249-2016</td>\n <td>US Compounding Inc</td>\n <td>20151125</td>\n <td>AR</td>\n <td>Terminated</td>\n <td>20170330</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10400</th>\n <td>4625 N University St</td>\n <td></td>\n <td>20151117</td>\n <td>Peoria</td>\n <td>Class II</td>\n <td>Lot #: 070915, Exp 09/09/2015; and 080315, Exp...</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>72241</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility: A recall of a...</td>\n <td>20150903</td>\n <td>D-334-2016</td>\n <td>Kalman Health & Wellness, Inc. dba Essential W...</td>\n <td>20151125</td>\n <td>IL</td>\n <td>Terminated</td>\n <td>20171229</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10401</th>\n <td>4001 McEwen Rd Suite 110</td>\n <td></td>\n <td>20151118</td>\n <td>Dallas</td>\n <td>Class II</td>\n <td>All lots</td>\n <td>United States</td>\n <td>Nationwide in the US; Australia, Brazil, Baham...</td>\n <td>72455</td>\n <td>Press Release</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility</td>\n <td>20151016</td>\n <td>D-0357-2016</td>\n <td>Downing Labs, LLC</td>\n <td>20151125</td>\n <td>TX</td>\n <td>Terminated</td>\n <td>20160922</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10402</th>\n <td>Office # 43 Block Y Saif Zone</td>\n <td></td>\n <td>20160303</td>\n <td>Sharm</td>\n <td>Class II</td>\n <td>Lot #s: JKP2234A, JKP2235A, Exp 04/17</td>\n <td>United Arab Emirates</td>\n <td>Nationwide and Puerto Rico</td>\n <td>73420</td>\n <td>E-Mail</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Failed Impurities/Degradation Specifications: ...</td>\n <td>20160211</td>\n <td>D-0735-2016</td>\n <td>Sun Pharma Global Fze</td>\n <td>20160309</td>\n <td></td>\n <td>Terminated</td>\n <td>20170523</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10403</th>\n <td>13800 Nw 2nd St Ste 190</td>\n <td></td>\n <td>20130730</td>\n <td>Sunrise</td>\n <td>Class II</td>\n <td>Lot Numbers: 247900, 251000, 256000, 261200, ...</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>65338</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Failed Impurity/Degradation Specification; \"Re...</td>\n <td>20130515</td>\n <td>D-829-2013</td>\n <td>Actavis South Atlantic LLC</td>\n <td>20130807</td>\n <td>FL</td>\n <td>Terminated</td>\n <td>20140515</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10404</th>\n <td>113 W Victoria St</td>\n <td></td>\n <td>20160304</td>\n <td>Long Beach</td>\n <td>Class II</td>\n <td>BUD: 5/3/2016</td>\n <td>United States</td>\n <td>Nationwide. No foreign distribution.</td>\n <td>73304</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility</td>\n <td>20160204</td>\n <td>D-0764-2016</td>\n <td>Hartley Medical Center Pharmacy, Incorporated</td>\n <td>20160316</td>\n <td>CA</td>\n <td>Terminated</td>\n <td>20160809</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10405</th>\n <td>5187 Camino Ruiz</td>\n <td></td>\n <td>20160309</td>\n <td>Camarillo</td>\n <td>Class III</td>\n <td>Lot #GS008856; Exp. 09/17 Lot #GS010268; Exp....</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>73152</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Failed Impurities/Degradation Specifications</td>\n <td>20160127</td>\n <td>D-0768-2016</td>\n <td>Golden State Medical Supply Inc.</td>\n <td>20160316</td>\n <td>CA</td>\n <td>Terminated</td>\n <td>20160628</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10406</th>\n <td>113 W Victoria St</td>\n <td></td>\n <td>20160304</td>\n <td>Long Beach</td>\n <td>Class II</td>\n <td>BUD: 5/3/2016</td>\n <td>United States</td>\n <td>Nationwide. No foreign distribution.</td>\n <td>73304</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility</td>\n <td>20160204</td>\n <td>D-0751-2016</td>\n <td>Hartley Medical Center Pharmacy, Incorporated</td>\n <td>20160316</td>\n <td>CA</td>\n <td>Terminated</td>\n <td>20160809</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10407</th>\n <td>113 W Victoria St</td>\n <td></td>\n <td>20160304</td>\n <td>Long Beach</td>\n <td>Class II</td>\n <td>BUD: 5/3/2016</td>\n <td>United States</td>\n <td>Nationwide. No foreign distribution.</td>\n <td>73304</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Lack of Assurance of Sterility</td>\n <td>20160204</td>\n <td>D-0757-2016</td>\n <td>Hartley Medical Center Pharmacy, Incorporated</td>\n <td>20160316</td>\n <td>CA</td>\n <td>Terminated</td>\n <td>20160809</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10408</th>\n <td>6666 Gulf Fwy</td>\n <td></td>\n <td>20160309</td>\n <td>Houston</td>\n <td>Class I</td>\n <td>All lots</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>72294</td>\n <td>Press Release</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Marketed without an Approved NDA/ANDA: Product...</td>\n <td>20150925</td>\n <td>D-0772-2016</td>\n <td>Tf Supplements</td>\n <td>20160316</td>\n <td>TX</td>\n <td>Ongoing</td>\n <td>NaN</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10409</th>\n <td>1215 Main St</td>\n <td></td>\n <td>20140513</td>\n <td>Asbury Park</td>\n <td>Class II</td>\n <td>Lot #: 556273, Exp 9/25/16; 556219, Exp 8/2/16...</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>68158</td>\n <td>Press Release</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Marketed Without An Approved NDA/ANDA: Parente...</td>\n <td>20140429</td>\n <td>D-1320-2014</td>\n <td>Flawless Beauty LLC</td>\n <td>20140521</td>\n <td>NJ</td>\n <td>Ongoing</td>\n <td>NaN</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10410</th>\n <td>1215 Main St</td>\n <td></td>\n <td>20140513</td>\n <td>Asbury Park</td>\n <td>Class II</td>\n <td>Lot #: UB302, Exp 05/12/15</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>68158</td>\n <td>Press Release</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Marketed Without An Approved NDA/ANDA: Product...</td>\n <td>20140429</td>\n <td>D-1317-2014</td>\n <td>Flawless Beauty LLC</td>\n <td>20140521</td>\n <td>NJ</td>\n <td>Ongoing</td>\n <td>NaN</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10411</th>\n <td>425 Privet Rd</td>\n <td></td>\n <td>20140512</td>\n <td>Horsham</td>\n <td>Class II</td>\n <td>TE32134, Exp. 02/15</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>67811</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>CGMP Deviations; laboratory testing was not fo...</td>\n <td>20140324</td>\n <td>D-1294-2014</td>\n <td>Teva Pharmaceuticals USA</td>\n <td>20140521</td>\n <td>PA</td>\n <td>Terminated</td>\n <td>20141114</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10412</th>\n <td>1215 Main St</td>\n <td></td>\n <td>20140513</td>\n <td>Asbury Park</td>\n <td>Class II</td>\n <td>Lot #: F040, Exp 08/16</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>68158</td>\n <td>Press Release</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Marketed Without An Approved NDA/ANDA: Product...</td>\n <td>20140429</td>\n <td>D-1316-2014</td>\n <td>Flawless Beauty LLC</td>\n <td>20140521</td>\n <td>NJ</td>\n <td>Ongoing</td>\n <td>NaN</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10413</th>\n <td>14450 Getz Rd</td>\n <td></td>\n <td>20140826</td>\n <td>Noblesville</td>\n <td>Class I</td>\n <td>Lot #: E21294K3C Exp Date: 6/29/2014</td>\n <td>United States</td>\n <td>United States: TX, IL, MD, IN</td>\n <td>68191</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Incorrect/ Undeclared Excipient: Contains unde...</td>\n <td>20140421</td>\n <td>D-1565-2014</td>\n <td>Pharmakon Pharmaceuticals</td>\n <td>20140903</td>\n <td>IN</td>\n <td>Terminated</td>\n <td>20141203</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10414</th>\n <td>781 Chestnut Ridge Rd</td>\n <td></td>\n <td>20140822</td>\n <td>Morgantown</td>\n <td>Class III</td>\n <td>Lot 3040063 Exp. 07/14</td>\n <td>United States</td>\n <td>Nationwide</td>\n <td>68645</td>\n <td>Telephone</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Failed Impurities/Degradation Specifications: ...</td>\n <td>20140619</td>\n <td>D-1557-2014</td>\n <td>Mylan Pharmaceuticals Inc.</td>\n <td>20140903</td>\n <td>WV</td>\n <td>Terminated</td>\n <td>20150723</td>\n <td>Voluntary: Firm initiated</td>\n </tr>\n <tr>\n <th>10415</th>\n <td>275 N Field Dr</td>\n <td></td>\n <td>20120919</td>\n <td>Lake Forest</td>\n <td>Class II</td>\n <td>lot numbers Y131994AA, exp AUG 2013; Y141994AA...</td>\n <td>United States</td>\n <td>Nationwide, including Puerto Rico and Guam. ...</td>\n <td>62459</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>The affected lots of Carboplatin Injection, Cy...</td>\n <td>20120627</td>\n <td>D-1680-2012</td>\n <td>Hospira Inc.</td>\n <td>20120926</td>\n <td>IL</td>\n <td>Terminated</td>\n <td>20161215</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n <tr>\n <th>10416</th>\n <td>Road #156, Km. 58.8, Lot 24B</td>\n <td></td>\n <td>20121126</td>\n <td>Caguas</td>\n <td>Class II</td>\n <td>Lots: 3027684 Exp. 5/13, 3027688 Exp. 6/13 20...</td>\n <td>United States</td>\n <td>Natiowide</td>\n <td>62454</td>\n <td>Letter</td>\n <td>...</td>\n <td>Drugs</td>\n <td>Failed USP Content Uniformity Requirements: OO...</td>\n <td>20120629</td>\n <td>D-066-2013</td>\n <td>Mylan LLC.</td>\n <td>20121205</td>\n <td>PR</td>\n <td>Terminated</td>\n <td>20170413</td>\n <td>Voluntary: Firm Initiated</td>\n </tr>\n </tbody>\n</table>\n<p>10417 rows × 45 columns</p>\n</div>", | |
| "text/plain": " address_1 address_2 \\\n0 8 Joanna Ct \n1 8 Joanna Ct \n2 571 Se 14th St \n3 700 Rte 206 North \n4 2481 Hilton Dr \n5 199 Grandview Rd \n6 697 Waverly St \n7 1 DNA Way \n8 120 Vintage Dr NE \n9 11865 Alameda St 11840 S Alameda ST \n10 Route 120 And Wilson Rd \n11 9275 Sky Park Ct Ste 101 \n12 120 Vintage Dr NE \n13 1 Squibb Dr \n14 700 Rte 206 North \n15 8700 Mason Montgomery Rd \n16 604 W Thomas Ave \n17 697 Waverly St \n18 Road 195, Km 1.1 Union Street \n19 60 Columbia Rd Bldg B \n20 126 East Main Street \n21 126 East Main Street \n22 126 East Main Street \n23 126 East Main Street \n24 126 East Main Street \n25 126 East Main Street \n26 126 East Main Street \n27 126 East Main Street \n28 126 East Main Street \n29 126 East Main Street \n... ... ... \n10387 113 W Victoria St \n10388 113 W Victoria St \n10389 113 W Victoria St \n10390 5187 Camino Ruiz \n10391 1215 Main St \n10392 1 Baxter Pkwy \n10393 4001 McEwen Rd Suite 110 \n10394 4625 N University St \n10395 4001 McEwen Rd Suite 110 \n10396 1270 Don's Lane \n10397 4625 N University St \n10398 1270 Don's Lane \n10399 1270 Don's Lane \n10400 4625 N University St \n10401 4001 McEwen Rd Suite 110 \n10402 Office # 43 Block Y Saif Zone \n10403 13800 Nw 2nd St Ste 190 \n10404 113 W Victoria St \n10405 5187 Camino Ruiz \n10406 113 W Victoria St \n10407 113 W Victoria St \n10408 6666 Gulf Fwy \n10409 1215 Main St \n10410 1215 Main St \n10411 425 Privet Rd \n10412 1215 Main St \n10413 14450 Getz Rd \n10414 781 Chestnut Ridge Rd \n10415 275 N Field Dr \n10416 Road #156, Km. 58.8, Lot 24B \n\n center_classification_date city classification \\\n0 20121025 East Brunswick Class II \n1 20121025 East Brunswick Class II \n2 20121101 Pompano Beach Class I \n3 20121106 Bridgewater Class III \n4 20121109 Gainesville Class III \n5 20121220 Skillman Class III \n6 20121231 Framingham Class II \n7 20130122 South San Francisco Class I \n8 20130130 Huntsville Class I \n9 20130307 Lynwood Class III \n10 20120925 Round Lake Class II \n11 20121018 San Diego Class II \n12 20121022 Huntsville Class II \n13 20121024 New Brunswick Class II \n14 20121106 Bridgewater Class III \n15 20121129 Mason Class II \n16 20121203 Shenandoah Class II \n17 20121231 Framingham Class II \n18 20130131 Fajardo Class III \n19 20130227 Morristown Class III \n20 20131203 Newbern Class II \n21 20131203 Newbern Class II \n22 20131203 Newbern Class II \n23 20131203 Newbern Class II \n24 20131203 Newbern Class II \n25 20131203 Newbern Class II \n26 20131203 Newbern Class II \n27 20131203 Newbern Class II \n28 20131203 Newbern Class II \n29 20131203 Newbern Class II \n... ... ... ... \n10387 20160304 Long Beach Class II \n10388 20160304 Long Beach Class II \n10389 20160304 Long Beach Class II \n10390 20160309 Camarillo Class III \n10391 20140513 Asbury Park Class II \n10392 20130628 Deerfield Class II \n10393 20151118 Dallas Class II \n10394 20151117 Peoria Class II \n10395 20151118 Dallas Class II \n10396 20151117 Conway Class II \n10397 20151117 Peoria Class II \n10398 20151117 Conway Class II \n10399 20151117 Conway Class II \n10400 20151117 Peoria Class II \n10401 20151118 Dallas Class II \n10402 20160303 Sharm Class II \n10403 20130730 Sunrise Class II \n10404 20160304 Long Beach Class II \n10405 20160309 Camarillo Class III \n10406 20160304 Long Beach Class II \n10407 20160304 Long Beach Class II \n10408 20160309 Houston Class I \n10409 20140513 Asbury Park Class II \n10410 20140513 Asbury Park Class II \n10411 20140512 Horsham Class II \n10412 20140513 Asbury Park Class II \n10413 20140826 Noblesville Class I \n10414 20140822 Morgantown Class III \n10415 20120919 Lake Forest Class II \n10416 20121126 Caguas Class II \n\n code_info \\\n0 Lots a) 15952, 16270,16425, Exp 06/15; b)16459... \n1 Lot 15087, Exp 08/15 \n2 UPC 0 00309 50792 7 All Lots \n3 All lots with expiration dates between 10/10/1... \n4 Lot 06JN1265 Exp 3/14 and 06JN1266 Exp 4/14 \n5 0142VA, 0132VB, 0112VC, 0122VB, 0102VA, 0102VB... \n6 All lot codes \n7 Lot #: 454138, Exp 07/14 (containing Trastuzum... \n8 Lot #: All that begin with the letter \"C\" a) C... \n9 Lot# 71648, 68088; FP-47-041-02535 \n10 Lot #: C828814, Exp 12/12; C841551, Exp 04/13 \n11 Lot #: 009-22-A011, 011-28-A011, 004-01-A012,... \n12 Lot C1130511A, Exp 5/13 \n13 Lot # 1J6024PA, 1J6025PA Exp. 09/13; 1K6049PA ... \n14 All lots with expiration dates between 10/10/1... \n15 Lot #2278171941, Exp. 09/14, Lot #2282171981,... \n16 Lot #1095212 exp. 4/30/2013; and #1088877, exp... \n17 All lot codes \n18 0.45 mg: 505969A \n19 Lot CB1D05A, \n20 all codes distributed prior to and including 0... \n21 all codes distributed prior to and including 0... \n22 all codes distributed prior to and including 0... \n23 all codes distributed prior to and including 0... \n24 all codes distributed prior to and including 0... \n25 all codes distributed prior to and including 0... \n26 all codes distributed prior to and including 0... \n27 all codes distributed prior to and including 0... \n28 all codes distributed prior to and including 0... \n29 all codes distributed prior to and including 0... \n... ... \n10387 BUD: 5/3/2016 \n10388 BUD: 5/3/2016 \n10389 BUD: 5/3/2016 \n10390 Lot #GS005602; Exp. 10/15 Lot #GS008855; Exp.... \n10391 Lot #: 201302275, Exp 01/20/15; 201308384, Exp... \n10392 Lot #: a) Product code 2B0042: P285668, P28566... \n10393 All lots \n10394 Lot #: 062915, Exp 09/29/2015; 070915, Exp 10/... \n10395 All lots \n10396 Lot Numbers: 20150408@10 BUD: 1/27/2015; 20151... \n10397 Lot #: 072915, Exp 09/13/2015 \n10398 Lot Code: 20150806@1 BUD: 12/5/2015, 20150806@... \n10399 Lot Numbers: 20150705@1 BUD: 11/2/2015; 201517... \n10400 Lot #: 070915, Exp 09/09/2015; and 080315, Exp... \n10401 All lots \n10402 Lot #s: JKP2234A, JKP2235A, Exp 04/17 \n10403 Lot Numbers: 247900, 251000, 256000, 261200, ... \n10404 BUD: 5/3/2016 \n10405 Lot #GS008856; Exp. 09/17 Lot #GS010268; Exp.... \n10406 BUD: 5/3/2016 \n10407 BUD: 5/3/2016 \n10408 All lots \n10409 Lot #: 556273, Exp 9/25/16; 556219, Exp 8/2/16... \n10410 Lot #: UB302, Exp 05/12/15 \n10411 TE32134, Exp. 02/15 \n10412 Lot #: F040, Exp 08/16 \n10413 Lot #: E21294K3C Exp Date: 6/29/2014 \n10414 Lot 3040063 Exp. 07/14 \n10415 lot numbers Y131994AA, exp AUG 2013; Y141994AA... \n10416 Lots: 3027684 Exp. 5/13, 3027688 Exp. 6/13 20... \n\n country \\\n0 United States \n1 United States \n2 United States \n3 United States \n4 United States \n5 United States \n6 United States \n7 United States \n8 United States \n9 United States \n10 United States \n11 United States \n12 United States \n13 United States \n14 United States \n15 United States \n16 United States \n17 United States \n18 United States \n19 United States \n20 United States \n21 United States \n22 United States \n23 United States \n24 United States \n25 United States \n26 United States \n27 United States \n28 United States \n29 United States \n... ... \n10387 United States \n10388 United States \n10389 United States \n10390 United States \n10391 United States \n10392 United States \n10393 United States \n10394 United States \n10395 United States \n10396 United States \n10397 United States \n10398 United States \n10399 United States \n10400 United States \n10401 United States \n10402 United Arab Emirates \n10403 United States \n10404 United States \n10405 United States \n10406 United States \n10407 United States \n10408 United States \n10409 United States \n10410 United States \n10411 United States \n10412 United States \n10413 United States \n10414 United States \n10415 United States \n10416 United States \n\n distribution_pattern event_id \\\n0 Nationwide 63384 \n1 Nationwide 63384 \n2 Products were distributed nationwide and inter... 61669 \n3 Nationwide 63488 \n4 FL, PA, and VA. 62940 \n5 Nationwide 63787 \n6 Nationwide 63305 \n7 Nationwide 63258 \n8 Nationwide and Puerto Rico 63818 \n9 Nationwide 64298 \n10 Nationwide and Puerto Rico 63189 \n11 Nationwide 63406 \n12 Nationwide and Puerto Rico 63502 \n13 Nationwide 62898 \n14 Nationwide 63488 \n15 Nationwide 63661 \n16 Distribution was nationwide, including Puerto ... 62511 \n17 Nationwide 63305 \n18 US Nationwide 64014 \n19 Nationwide 64317 \n20 nationwide, specifically: AK, AL, AZ, CA, CO,... 65479 \n21 nationwide, specifically: AK, AL, AZ, CA, CO,... 65479 \n22 nationwide, specifically: AK, AL, AZ, CA, CO,... 65479 \n23 nationwide, specifically: AK, AL, AZ, CA, CO,... 65479 \n24 nationwide, specifically: AK, AL, AZ, CA, CO,... 65479 \n25 nationwide, specifically: AK, AL, AZ, CA, CO,... 65479 \n26 nationwide, specifically: AK, AL, AZ, CA, CO,... 65479 \n27 nationwide, specifically: AK, AL, AZ, CA, CO,... 65479 \n28 nationwide, specifically: AK, AL, AZ, CA, CO,... 65479 \n29 nationwide, specifically: AK, AL, AZ, CA, CO,... 65479 \n... ... ... \n10387 Nationwide. No foreign distribution. 73304 \n10388 Nationwide. No foreign distribution. 73304 \n10389 Nationwide. No foreign distribution. 73304 \n10390 Nationwide 73152 \n10391 Nationwide 68158 \n10392 Nationwide & Puerto Rico 65288 \n10393 Nationwide in the US; Australia, Brazil, Baham... 72455 \n10394 Nationwide 72241 \n10395 Nationwide in the US; Australia, Brazil, Baham... 72455 \n10396 Nationwide 72179 \n10397 Nationwide 72241 \n10398 Nationwide 72179 \n10399 Nationwide 72179 \n10400 Nationwide 72241 \n10401 Nationwide in the US; Australia, Brazil, Baham... 72455 \n10402 Nationwide and Puerto Rico 73420 \n10403 Nationwide 65338 \n10404 Nationwide. No foreign distribution. 73304 \n10405 Nationwide 73152 \n10406 Nationwide. No foreign distribution. 73304 \n10407 Nationwide. No foreign distribution. 73304 \n10408 Nationwide 72294 \n10409 Nationwide 68158 \n10410 Nationwide 68158 \n10411 Nationwide 67811 \n10412 Nationwide 68158 \n10413 United States: TX, IL, MD, IN 68191 \n10414 Nationwide 68645 \n10415 Nationwide, including Puerto Rico and Guam. ... 62459 \n10416 Natiowide 62454 \n\n initial_firm_notification \\\n0 E-Mail \n1 E-Mail \n2 Two or more of the following: Email, Fax, Lett... \n3 Letter \n4 E-Mail \n5 Letter \n6 Two or more of the following: Email, Fax, Lett... \n7 E-Mail \n8 Press Release \n9 Two or more of the following: Email, Fax, Lett... \n10 Letter \n11 E-Mail \n12 Letter \n13 Letter \n14 Letter \n15 Two or more of the following: Email, Fax, Lett... \n16 Telephone \n17 Two or more of the following: Email, Fax, Lett... \n18 Letter \n19 Letter \n20 Telephone \n21 Telephone \n22 Telephone \n23 Telephone \n24 Telephone \n25 Telephone \n26 Telephone \n27 Telephone \n28 Telephone \n29 Telephone \n... ... \n10387 Telephone \n10388 Telephone \n10389 Telephone \n10390 Letter \n10391 Press Release \n10392 Letter \n10393 Press Release \n10394 Letter \n10395 Press Release \n10396 Letter \n10397 Letter \n10398 Letter \n10399 Letter \n10400 Letter \n10401 Press Release \n10402 E-Mail \n10403 Letter \n10404 Telephone \n10405 Letter \n10406 Telephone \n10407 Telephone \n10408 Press Release \n10409 Press Release \n10410 Press Release \n10411 Letter \n10412 Press Release \n10413 Telephone \n10414 Telephone \n10415 Letter \n10416 Letter \n\n ... product_type \\\n0 ... Drugs \n1 ... Drugs \n2 ... Drugs \n3 ... Drugs \n4 ... Drugs \n5 ... Drugs \n6 ... Drugs \n7 ... Drugs \n8 ... Drugs \n9 ... Drugs \n10 ... Drugs \n11 ... Drugs \n12 ... Drugs \n13 ... Drugs \n14 ... Drugs \n15 ... Drugs \n16 ... Drugs \n17 ... Drugs \n18 ... Drugs \n19 ... Drugs \n20 ... Drugs \n21 ... Drugs \n22 ... Drugs \n23 ... Drugs \n24 ... Drugs \n25 ... Drugs \n26 ... Drugs \n27 ... Drugs \n28 ... Drugs \n29 ... Drugs \n... ... ... \n10387 ... Drugs \n10388 ... Drugs \n10389 ... Drugs \n10390 ... Drugs \n10391 ... Drugs \n10392 ... Drugs \n10393 ... Drugs \n10394 ... Drugs \n10395 ... Drugs \n10396 ... Drugs \n10397 ... Drugs \n10398 ... Drugs \n10399 ... Drugs \n10400 ... Drugs \n10401 ... Drugs \n10402 ... Drugs \n10403 ... Drugs \n10404 ... Drugs \n10405 ... Drugs \n10406 ... Drugs \n10407 ... Drugs \n10408 ... Drugs \n10409 ... Drugs \n10410 ... Drugs \n10411 ... Drugs \n10412 ... Drugs \n10413 ... Drugs \n10414 ... Drugs \n10415 ... Drugs \n10416 ... Drugs \n\n reason_for_recall \\\n0 Microbial Contamination of Non-Sterile Product... \n1 Microbial Contamination of Non-Sterile Product... \n2 Marketed Without an Approved NDA/ANDA: product... \n3 Subpotent (Single Ingredient) Drug: This produ... \n4 Labeling: Label Mix-up: The affected units wer... \n5 Superpotent (Single Ingredient Drug): salicyli... \n6 Lack of Assurance of Sterility \n7 Presence of Particulate Matter: One lot of Bac... \n8 Superpotent (Multiple Ingredient) Drug: Compla... \n9 Presence of Precipitate; white substance confi... \n10 Chemical Contamination: The IV solutions were ... \n11 Marketed Without An Approved NDA/ANDA: This pr... \n12 Tablet Separation: Possibility of cracked or s... \n13 Labeling; Correct labeled product miscart/misp... \n14 Subpotent (Single Ingredient) Drug: This produ... \n15 Labeling Illegible: Portions of the product la... \n16 cGMP Deviations; does not meet in process spec... \n17 Lack of Assurance of Sterility \n18 Failed Impurity/Degradation Specifications due... \n19 Failed Dissolution Specifications; 8-hours for... \n20 The firm received seven reports of adverse rea... \n21 The firm received seven reports of adverse rea... \n22 The firm received seven reports of adverse rea... \n23 The firm received seven reports of adverse rea... \n24 The firm received seven reports of adverse rea... \n25 The firm received seven reports of adverse rea... \n26 The firm received seven reports of adverse rea... \n27 The firm received seven reports of adverse rea... \n28 The firm received seven reports of adverse rea... \n29 The firm received seven reports of adverse rea... \n... ... \n10387 Lack of Assurance of Sterility \n10388 Lack of Assurance of Sterility \n10389 Lack of Assurance of Sterility \n10390 Failed Impurities/Degradation Specifications \n10391 Marketed Without An Approved NDA/ANDA: Parente... \n10392 Lack of Assurance of Sterility: Specific lot n... \n10393 Lack of Assurance of Sterility \n10394 Lack of Assurance of Sterility: A recall of a... \n10395 Lack of Assurance of Sterility \n10396 Lack of Assurance of Sterility; The firm is re... \n10397 Lack of Assurance of Sterility: A recall of a... \n10398 Lack of Assurance of Sterility; The firm is re... \n10399 Lack of Assurance of Sterility; The firm is re... \n10400 Lack of Assurance of Sterility: A recall of a... \n10401 Lack of Assurance of Sterility \n10402 Failed Impurities/Degradation Specifications: ... \n10403 Failed Impurity/Degradation Specification; \"Re... \n10404 Lack of Assurance of Sterility \n10405 Failed Impurities/Degradation Specifications \n10406 Lack of Assurance of Sterility \n10407 Lack of Assurance of Sterility \n10408 Marketed without an Approved NDA/ANDA: Product... \n10409 Marketed Without An Approved NDA/ANDA: Parente... \n10410 Marketed Without An Approved NDA/ANDA: Product... \n10411 CGMP Deviations; laboratory testing was not fo... \n10412 Marketed Without An Approved NDA/ANDA: Product... \n10413 Incorrect/ Undeclared Excipient: Contains unde... \n10414 Failed Impurities/Degradation Specifications: ... \n10415 The affected lots of Carboplatin Injection, Cy... \n10416 Failed USP Content Uniformity Requirements: OO... \n\n recall_initiation_date recall_number \\\n0 20120904 D-026-2013 \n1 20120904 D-031-2013 \n2 20120421 D-037-2013 \n3 20121015 D-047-2013 \n4 20120618 D-050-2013 \n5 20121204 D-098-2013 \n6 20120926 D-118-2013 \n7 20120730 D-135-2013 \n8 20121206 D-138-2013 \n9 20130118 D-187-2013 \n10 20120921 D-1688-2012 \n11 20121005 D-009-2013 \n12 20121011 D-010-2013 \n13 20120605 D-019-2013 \n14 20121015 D-048-2013 \n15 20121108 D-069-2013 \n16 20120709 D-083-2013 \n17 20120926 D-124-2013 \n18 20121221 D-142-2013 \n19 20130104 D-175-2013 \n20 20130528 D-176-2014 \n21 20130528 D-103-2014 \n22 20130528 D-159-2014 \n23 20130528 D-280-2014 \n24 20130528 D-255-2014 \n25 20130528 D-037-2014 \n26 20130528 D-171-2014 \n27 20130528 D-035-2014 \n28 20130528 D-262-2014 \n29 20130528 D-060-2014 \n... ... ... \n10387 20160204 D-0765-2016 \n10388 20160204 D-0745-2016 \n10389 20160204 D-0737-2016 \n10390 20160127 D-0767-2016 \n10391 20140429 D-1318-2014 \n10392 20130521 D-624-2013 \n10393 20151016 D-0376-2016 \n10394 20150903 D-302-2016 \n10395 20151016 D-0342-2016 \n10396 20150912 D-0237-2016 \n10397 20150903 D-317-2016 \n10398 20150912 D-0276-2016 \n10399 20150912 D-0249-2016 \n10400 20150903 D-334-2016 \n10401 20151016 D-0357-2016 \n10402 20160211 D-0735-2016 \n10403 20130515 D-829-2013 \n10404 20160204 D-0764-2016 \n10405 20160127 D-0768-2016 \n10406 20160204 D-0751-2016 \n10407 20160204 D-0757-2016 \n10408 20150925 D-0772-2016 \n10409 20140429 D-1320-2014 \n10410 20140429 D-1317-2014 \n10411 20140324 D-1294-2014 \n10412 20140429 D-1316-2014 \n10413 20140421 D-1565-2014 \n10414 20140619 D-1557-2014 \n10415 20120627 D-1680-2012 \n10416 20120629 D-066-2013 \n\n recalling_firm report_date state \\\n0 Raritan Pharmaceuticals, Inc. 20121031 NJ \n1 Raritan Pharmaceuticals, Inc. 20121031 NJ \n2 XRock Industries, LLC 20121107 FL \n3 Valeant Pharmaceuticals 20121114 NJ \n4 Stat Rx USA 20121121 GA \n5 Johnson & Johnson 20121226 NJ \n6 New England Compounding Center 20130109 MA \n7 Genentech Inc 20130130 CA \n8 Vintage Pharmaceuticals LLC DBA Qualitest Phar... 20130206 AL \n9 Aaron Industries Inc 20130313 CA \n10 Baxter Healthcare Corp. 20121003 IL \n11 Earthborn Products, Inc. 20121024 CA \n12 Vintage Pharmaceuticals LLC DBA Qualitest Phar... 20121031 AL \n13 Bristol-myers Squibb Company 20121031 NJ \n14 Valeant Pharmaceuticals 20121114 NJ \n15 Procter & Gamble Co 20121205 OH \n16 Lloyd Inc. of Iowa 20121212 IA \n17 New England Compounding Center 20130109 MA \n18 Warner Chilcott Company LLC 20130206 PR \n19 Actavis Pharmaceuticals 20130306 NJ \n20 Main Street Family Pharmacy, LLC 20131211 TN \n21 Main Street Family Pharmacy, LLC 20131211 TN \n22 Main Street Family Pharmacy, LLC 20131211 TN \n23 Main Street Family Pharmacy, LLC 20131211 TN \n24 Main Street Family Pharmacy, LLC 20131211 TN \n25 Main Street Family Pharmacy, LLC 20131211 TN \n26 Main Street Family Pharmacy, LLC 20131211 TN \n27 Main Street Family Pharmacy, LLC 20131211 TN \n28 Main Street Family Pharmacy, LLC 20131211 TN \n29 Main Street Family Pharmacy, LLC 20131211 TN \n... ... ... ... \n10387 Hartley Medical Center Pharmacy, Incorporated 20160316 CA \n10388 Hartley Medical Center Pharmacy, Incorporated 20160316 CA \n10389 Hartley Medical Center Pharmacy, Incorporated 20160316 CA \n10390 Golden State Medical Supply Inc. 20160316 CA \n10391 Flawless Beauty LLC 20140521 NJ \n10392 Baxter Healthcare Corp. 20130710 IL \n10393 Downing Labs, LLC 20151125 TX \n10394 Kalman Health & Wellness, Inc. dba Essential W... 20151125 IL \n10395 Downing Labs, LLC 20151125 TX \n10396 US Compounding Inc 20151125 AR \n10397 Kalman Health & Wellness, Inc. dba Essential W... 20151125 IL \n10398 US Compounding Inc 20151125 AR \n10399 US Compounding Inc 20151125 AR \n10400 Kalman Health & Wellness, Inc. dba Essential W... 20151125 IL \n10401 Downing Labs, LLC 20151125 TX \n10402 Sun Pharma Global Fze 20160309 \n10403 Actavis South Atlantic LLC 20130807 FL \n10404 Hartley Medical Center Pharmacy, Incorporated 20160316 CA \n10405 Golden State Medical Supply Inc. 20160316 CA \n10406 Hartley Medical Center Pharmacy, Incorporated 20160316 CA \n10407 Hartley Medical Center Pharmacy, Incorporated 20160316 CA \n10408 Tf Supplements 20160316 TX \n10409 Flawless Beauty LLC 20140521 NJ \n10410 Flawless Beauty LLC 20140521 NJ \n10411 Teva Pharmaceuticals USA 20140521 PA \n10412 Flawless Beauty LLC 20140521 NJ \n10413 Pharmakon Pharmaceuticals 20140903 IN \n10414 Mylan Pharmaceuticals Inc. 20140903 WV \n10415 Hospira Inc. 20120926 IL \n10416 Mylan LLC. 20121205 PR \n\n status termination_date voluntary_mandated \n0 Terminated 20141007 Voluntary: Firm Initiated \n1 Terminated 20141007 Voluntary: Firm Initiated \n2 Terminated 20151130 Voluntary: Firm Initiated \n3 Terminated 20130325 Voluntary: Firm Initiated \n4 Terminated 20130131 Voluntary: Firm Initiated \n5 Terminated 20140429 Voluntary: Firm Initiated \n6 Terminated 20161007 Voluntary: Firm Initiated \n7 Terminated 20130325 Voluntary: Firm Initiated \n8 Ongoing NaN Voluntary: Firm Initiated \n9 Terminated 20131101 Voluntary: Firm Initiated \n10 Terminated 20150504 Voluntary: Firm Initiated \n11 Terminated 20130228 Voluntary: Firm Initiated \n12 Terminated 20131209 Voluntary: Firm Initiated \n13 Terminated 20130710 Voluntary: Firm Initiated \n14 Terminated 20130325 Voluntary: Firm Initiated \n15 Terminated 20131223 Voluntary: Firm Initiated \n16 Terminated 20131114 Voluntary: Firm Initiated \n17 Terminated 20161007 Voluntary: Firm Initiated \n18 Terminated 20150616 Voluntary: Firm Initiated \n19 Terminated 20140113 Voluntary: Firm Initiated \n20 Terminated 20140422 Voluntary: Firm Initiated \n21 Terminated 20140422 Voluntary: Firm Initiated \n22 Terminated 20140422 Voluntary: Firm Initiated \n23 Terminated 20140422 Voluntary: Firm Initiated \n24 Terminated 20140422 Voluntary: Firm Initiated \n25 Terminated 20140422 Voluntary: Firm Initiated \n26 Terminated 20140422 Voluntary: Firm Initiated \n27 Terminated 20140422 Voluntary: Firm Initiated \n28 Terminated 20140422 Voluntary: Firm Initiated \n29 Terminated 20140422 Voluntary: Firm Initiated \n... ... ... ... \n10387 Terminated 20160809 Voluntary: Firm initiated \n10388 Terminated 20160809 Voluntary: Firm initiated \n10389 Terminated 20160809 Voluntary: Firm initiated \n10390 Terminated 20160628 Voluntary: Firm initiated \n10391 Ongoing NaN Voluntary: Firm initiated \n10392 Terminated 20150618 Voluntary: Firm Initiated \n10393 Terminated 20160922 Voluntary: Firm initiated \n10394 Terminated 20171229 Voluntary: Firm initiated \n10395 Terminated 20160922 Voluntary: Firm initiated \n10396 Terminated 20170330 Voluntary: Firm initiated \n10397 Terminated 20171229 Voluntary: Firm initiated \n10398 Terminated 20170330 Voluntary: Firm initiated \n10399 Terminated 20170330 Voluntary: Firm initiated \n10400 Terminated 20171229 Voluntary: Firm initiated \n10401 Terminated 20160922 Voluntary: Firm initiated \n10402 Terminated 20170523 Voluntary: Firm initiated \n10403 Terminated 20140515 Voluntary: Firm initiated \n10404 Terminated 20160809 Voluntary: Firm initiated \n10405 Terminated 20160628 Voluntary: Firm initiated \n10406 Terminated 20160809 Voluntary: Firm initiated \n10407 Terminated 20160809 Voluntary: Firm initiated \n10408 Ongoing NaN Voluntary: Firm initiated \n10409 Ongoing NaN Voluntary: Firm initiated \n10410 Ongoing NaN Voluntary: Firm initiated \n10411 Terminated 20141114 Voluntary: Firm initiated \n10412 Ongoing NaN Voluntary: Firm initiated \n10413 Terminated 20141203 Voluntary: Firm initiated \n10414 Terminated 20150723 Voluntary: Firm initiated \n10415 Terminated 20161215 Voluntary: Firm Initiated \n10416 Terminated 20170413 Voluntary: Firm Initiated \n\n[10417 rows x 45 columns]" | |
| }, | |
| "metadata": {} | |
| } | |
| ] | |
| }, | |
| { | |
| "metadata": { | |
| "trusted": true | |
| }, | |
| "cell_type": "code", | |
| "source": "from IPython.display import FileLink\n\ndef link_to_csv(df, filename):\n df.to_csv(filename, index=False)\n return FileLink(filename)\n\nlink_to_csv(df, \"normalized-data.csv\")", | |
| "execution_count": 24, | |
| "outputs": [ | |
| { | |
| "output_type": "execute_result", | |
| "execution_count": 24, | |
| "data": { | |
| "text/html": "<a href='normalized-data.csv' target='_blank'>normalized-data.csv</a><br>", | |
| "text/plain": "/home/nbuser/library/normalized-data.csv" | |
| }, | |
| "metadata": {} | |
| } | |
| ] | |
| }, | |
| { | |
| "metadata": { | |
| "trusted": true | |
| }, | |
| "cell_type": "code", | |
| "source": "", | |
| "execution_count": null, | |
| "outputs": [] | |
| } | |
| ], | |
| "metadata": { | |
| "kernelspec": { | |
| "name": "python36", | |
| "display_name": "Python 3.6", | |
| "language": "python" | |
| }, | |
| "language_info": { | |
| "mimetype": "text/x-python", | |
| "nbconvert_exporter": "python", | |
| "name": "python", | |
| "pygments_lexer": "ipython3", | |
| "version": "3.6.6", | |
| "file_extension": ".py", | |
| "codemirror_mode": { | |
| "version": 3, | |
| "name": "ipython" | |
| } | |
| } | |
| }, | |
| "nbformat": 4, | |
| "nbformat_minor": 2 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment