# Airmid Éireann: data dictionary

Release 2026-10-13T07:23:21+00:00. Every field of every dataset.

## `ctgov_ireland`: ClinicalTrials.gov: studies with a site in Ireland

Publisher: U.S. National Library of Medicine. Licence: [Public data; see ClinicalTrials.gov Terms and Conditions](https://clinicaltrials.gov/about-site/terms-conditions).
Attribution: Source: ClinicalTrials.gov, U.S. National Library of Medicine.
Records: 2,698

| Field | Description |
|---|---|
| `nct_id` | ClinicalTrials.gov identifier |
| `title` | Brief study title |
| `phases` | Trial phase(s); NA = not applicable |
| `overall_status` | Recruitment status as registered |
| `lead_sponsor` | Lead sponsor organisation |
| `conditions` | Conditions studied |
| `start_date` | Study start date (YYYY-MM or YYYY-MM-DD) |
| `last_update` | Date the record was last updated on ClinicalTrials.gov |

## `hpra_medicines`: HPRA: human medicines authorised in Ireland

Publisher: Health Products Regulatory Authority. Licence: [CC BY 4.0 (published on data.gov.ie)](https://creativecommons.org/licenses/by/4.0/).
Attribution: Source: Health Products Regulatory Authority (HPRA), CC BY 4.0.
Records: 10,297

| Field | Description |
|---|---|
| `licence_number` | HPRA product licence number (PA, EU or other) |
| `product_name` | Product name |
| `holder` | Licence holder |
| `authorised_date` | Date first authorised |
| `product_type` | HPRA product type code |
| `market_status` | Marketed or not marketed |
| `registration_status` | HPRA registration status code |
| `dosage_form` | Pharmaceutical form |
| `atc_codes` | ATC classification codes |
| `active_substances` | Active substances |
| `routes` | Routes of administration |
| `dispensing_status` | Legal dispensing status |
| `supply_status` | Legal supply status |
| `legal_basis` | Legal basis of the authorisation |

## `ema_shortages`: EMA: medicine shortages (human)

Publisher: European Medicines Agency. Licence: [EMA website content may be reused with acknowledgement of the source](https://www.ema.europa.eu/en/about-us/legal-notice).
Attribution: Source: European Medicines Agency (EMA).
Records: 85

| Field | Description |
|---|---|
| `medicine` | Medicine affected |
| `inn` | International non-proprietary name or common name |
| `status` | Shortage status |
| `therapeutic_area` | Therapeutic areas (MeSH) |
| `forms` | Pharmaceutical forms affected |
| `strengths` | Strengths affected |
| `alternatives_available` | Whether alternatives are available |
| `start_date` | Start of the shortage |
| `expected_resolution` | Expected resolution |
| `first_published` | First published by EMA |
| `last_updated` | Last updated by EMA |
| `url` | EMA shortage page |

## `ema_medicines`: EMA: human medicines evaluated by the European Medicines Agency

Publisher: European Medicines Agency. Licence: [EMA website content may be reused with acknowledgement of the source](https://www.ema.europa.eu/en/about-us/legal-notice).
Attribution: Source: European Medicines Agency (EMA).
Records: 2,351

| Field | Description |
|---|---|
| `ema_product_number` | EMA product number |
| `medicine_name` | Name of the medicine |
| `inn` | International non-proprietary name or common name |
| `active_substance` | Active substance |
| `status` | Authorisation status |
| `holder` | Marketing authorisation holder / applicant |
| `atc_code` | ATC code |
| `therapeutic_area` | Therapeutic areas (MeSH) |
| `authorisation_date` | Marketing authorisation date |
| `orphan` | Orphan medicine (yes/no) |
| `biosimilar` | Biosimilar (yes/no) |
| `generic` | Generic (yes/no) |
| `conditional_approval` | Conditional marketing authorisation (yes/no) |
| `exceptional_circumstances` | Authorised under exceptional circumstances (yes/no) |
| `accelerated_assessment` | Accelerated assessment (yes/no) |
| `prime` | PRIME priority medicine (yes/no) |
| `advanced_therapy` | Advanced therapy medicinal product (yes/no) |
| `additional_monitoring` | Under additional monitoring (yes/no) |
| `url` | EMA medicine page |
| `last_updated` | Last updated by EMA |

## `ema_orphans`: EMA: EU orphan designations

Publisher: European Medicines Agency. Licence: [EMA website content may be reused with acknowledgement of the source](https://www.ema.europa.eu/en/about-us/legal-notice).
Attribution: Source: European Medicines Agency (EMA).
Records: 3,310

| Field | Description |
|---|---|
| `eu_designation_number` | EU orphan designation number |
| `medicine_name` | Medicine name |
| `active_substance` | Active substance |
| `intended_use` | Condition the designation is for |
| `status` | Designation status |
| `designation_date` | Date of designation or refusal |
| `related_ema_product_number` | Related EMA product number, if authorised |
| `url` | EMA designation page |
| `last_updated` | Last updated by EMA |

## `fda_shortages`: US FDA: drug shortages

Publisher: U.S. Food and Drug Administration (openFDA). Licence: [Public domain (U.S. government work); see openFDA terms](https://open.fda.gov/terms/).
Attribution: Source: U.S. Food and Drug Administration, openFDA. Not endorsed by the FDA.
Records: 1,580

| Field | Description |
|---|---|
| `package_ndc` | National Drug Code of the affected package |
| `generic_name` | Generic name |
| `company_name` | Company |
| `presentation` | Presentation (strength and pack) |
| `dosage_form` | Dosage form |
| `therapeutic_category` | FDA therapeutic categories |
| `status` | Shortage status (e.g. Current, Resolved, To Be Discontinued) |
| `availability` | Availability of the package |
| `shortage_reason` | Reason given |
| `initial_posting_date` | First posted by FDA |
| `update_date` | Last updated by FDA |
| `discontinued_date` | Discontinuation date, if any |

## `fda_approvals`: US FDA: original approvals since 2021 (Drugs@FDA)

Publisher: U.S. Food and Drug Administration (openFDA). Licence: [Public domain (U.S. government work); see openFDA terms](https://open.fda.gov/terms/).
Attribution: Source: U.S. Food and Drug Administration, Drugs@FDA via openFDA. Not endorsed by the FDA.
Records: 4,765

| Field | Description |
|---|---|
| `application_number` | FDA application number |
| `application_type` | NDA (new drug), BLA (biologic) or ANDA (generic) |
| `sponsor_name` | Sponsor |
| `brand_names` | Brand names of the products |
| `active_ingredients` | Active ingredients |
| `dosage_forms` | Dosage forms |
| `routes` | Routes |
| `approval_date` | Approval date of the original submission |
| `review_priority` | STANDARD or PRIORITY review |
| `submission_class` | Submission class (e.g. Type 1 - New Molecular Entity) |

## `hc_approvals`: Health Canada: New Drug Submission approvals since 2016

Publisher: Health Canada. Licence: [Open Government Licence - Canada](https://open.canada.ca/en/open-government-licence-canada).
Attribution: Contains information licensed under the Open Government Licence - Canada. Source: Health Canada, Notice of Compliance database.
Records: 1,057

| Field | Description |
|---|---|
| `noc_number` | Notice of Compliance number |
| `noc_date` | Date of the Notice of Compliance |
| `company` | Manufacturer |
| `submission_type` | Submission type (NDS = New Drug Submission) |
| `submission_class` | Submission class |
| `product_type` | Product type |
| `therapeutic_class` | Therapeutic class |
| `brand_names` | Brand names |
| `ingredients` | Medicinal ingredients |
| `with_conditions` | Issued with conditions (yes/no) |

## `cso_pharma_exports`: CSO: Irish exports of medicinal and pharmaceutical products by country (TSM10)

Publisher: Central Statistics Office, Ireland. Licence: [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/).
Attribution: Source: Central Statistics Office, Ireland (table TSM10), CC BY 4.0.
Records: 6,811

| Field | Description |
|---|---|
| `month` | Month (YYYY-MM) |
| `country_code` | CSO country or territory code |
| `country` | Destination country or territory |
| `exports_eur_thousand` | Value of exports of SITC 54 medicinal and pharmaceutical products, euro thousand; empty = not published |

## `nih_ireland`: NIH RePORTER: US NIH awards to organisations in Ireland

Publisher: U.S. National Institutes of Health. Licence: [Public domain (U.S. government work); see NIH RePORTER terms](https://reporter.nih.gov/faqs).
Attribution: Source: NIH RePORTER, U.S. National Institutes of Health.
Records: 21

| Field | Description |
|---|---|
| `project_number` | NIH project number |
| `fiscal_year` | US federal fiscal year |
| `organisation` | Organisation in Ireland |
| `city` | City |
| `award_usd` | Award amount for the fiscal year, US dollars |
| `institute` | Administering NIH institute or centre |
| `activity_code` | NIH activity code |
| `project_title` | Project title |
| `project_start` | Project start date |
| `project_end` | Project end date |