Research and Data Entry on Bio pharmaceuticals Companies

The task: to make a .csv file with R&D pipeline by products for global biopharmaceutical companies (13 companies) during 1990-2013 (see details below). The list of companies: 1. Amgen Inc., 2. Eli Lily Inc., 3. Merck & Co Inc., 4. Abbott Laboratories Inc., 5. Bristol Myers Squib Inc., 6. Pfizer Inc., 7. Johnson & Johnson Inc., 8. AstraZeneca Inc., 9. GlaxoSmithKline plc. 10. Novartis AG, 11. Sanofi, 12. Bayer Ag., 13. Takeda Pharmaceutical Company. Data that I will be needed : 1. Company name; 2. Clinical Trial Identifier 3. Official Title; 4. Therapy Area(s); 5. Product name; 6. Trial Phase (preclinical, Phase I, Phase II, Phase III, Phase IV) 7. Indication; 8. Trial Start Date; 9. Trial End Date; 10. The result (withdrawn, move to the next phase); 11. Molecule type {NCE (new chemical entity), NBE (new biologics entity), Line extension, Combination, vaccine)}; 12. Collaborator/Partner; 13. Approved Health Authority (US, EU, Japan, China, Rest of World); 14. Is there any sales (YES/NO) of the drug for the indication in any country.