European Medicines Agency

Returns all 175 DHPCs, the urgent safety letters sent to prescribers, each with name_of_medicine, active_substances, dhpc_type, procedure_number, regulatory_outcome, referral_name, ATC code, therapeutic_area_mesh, nationally authorised medicines also affected and the dissemination_date.

Returns all 2,509 past and upcoming EMA events with title, date_start_end_dates, location, whether the event is online or live_broadcast, publication dates and the event url.

Returns the 1,068 general guidance and information pages of the EMA website with title, summary, categories, publication dates and the page url - the site sections not covered by the other exports. categories is a semicolon-joined set drawn from Human, Veterinary, Herbal and Corporate and is empty on ~17% of rows.

Returns the 251 herbal substances on EMA's inventory, each with latin_name, botanical_name, english_common_name, whether it is a combination, therapeutic_area, status, outcome_of_european_assessment and the dates it joined the inventory and the priority list.

Returns all 529 MRL assessments for pharmacologically active substances used in food-producing animals, each with active_substance, mrl_therapeutic_classification, target_species, the Commission implementing decision date and the regulation number and URL.

Returns all 2,754 human and veterinary medicines that have been through the EU centralised procedure, each with name_of_medicine, ema_product_number, medicine_status, opinion_status, INN, active_substance, therapeutic_area_mesh, atc_code_human or atcvet_code_veterinary, pharmacotherapeutic group, full therapeutic_indication text, the orphan/biosimilar/generic/PRIME/conditional/advanced-therapy flags, marketing authorisation holder, and the evaluation, opinion, Commission decision, suspension and withdrawal dates.

Returns the 19 Article 58 scientific opinions on medicines intended for markets outside the EU, each with name_of_medicine, ema_opinion_number, ema_opinion_status, active_substance, INN, therapeutic_area_mesh, atc_code_human, therapeutic_indication, opinion_holder and the opinion and outcome dates.

Returns all 3,896 EMA news items with title, news_summary, whether it is a press_release, the related medicines or referrals, categories, topics, publication dates and the article url.

Returns all 3,310 EU orphan designations and refusals, each with medicine_name, active_substance, eu_designation_number, related_ema_product_number, the intended_use (the rare condition), status and date_of_designation_or_refusal.

Returns all 3,394 PIP decisions, each with pip_number, decision_number, decision_type, decision_date, active_substance, invented_name, therapeutic_area, condition_indication, pharmaceutical_forms, routes_of_administration and the compliance outcome and opinion date.

Returns the 153 open or concluded post-authorisation applications (variations and extensions) with an opinion or withdrawal, each with name_of_medicine, ema_product_number, active_substance, post_authorisation_procedure_status, post_authorisation_opinion_status and date, marketing authorisation holder and the medicine-type flags.

Returns all 2,737 PSUSA procedures, each with procedure_number, the active substances in scope, related_medicines and the regulatory_outcome of the single assessment.

Returns all 592 EU referral procedures, each with referral_name, referral_type, class, current_status, whether it is a safety_referral, the centrally and non-centrally authorised medicines caught by it, PRAC recommendation text, and the procedure start, PRAC recommendation, CMDh position, CHMP/CVMP opinion and Commission decision dates.

Returns all 999 EMA scientific guideline pages with title, category, first_published_date, last_updated_date and the page url. category is a semicolon-joined set drawn from Human, Veterinary, Herbal and Corporate (e.g. "Human;Veterinary"), so match on substring, not equality.

Returns the 85 EU-wide medicine supply shortages EMA is tracking, each with medicine_affected, supply_shortage_status ("Shortage ongoing", "Shortage resolved" or "Medicine discontinued"), INN, therapeutic_area_mesh, pharmaceutical_forms_affected, strengths_affected, availability_of_alternatives, start_of_shortage_date, expected_resolution_date and a free-text expected_resolution.