What are the different data sources for pharmaceutical and biotech data?
Use the provided PharmaACE source catalog and source inventory to identify which source types are available, how many active sources exist in each type, and how many of those are global versus regional. Return only source types with at least one active source.
source_type, active_sources, global_sources, regional_sourcesactive_sources descending, then source_type ascending| Column | Type | Description |
|---|---|---|
| source_idPK | INT | Unique identifier for a data source |
| source_name | VARCHAR(255) | Name of the data source |
| source_type | VARCHAR(100) | Type of source, such as clinical, commercial, regulatory, or literature |
| region | VARCHAR(100) | Primary region associated with the source, if applicable |
| Column | Type | Description |
|---|---|---|
| inventory_idPK | INT | Unique inventory record identifier |
| source_id | INT | References the source catalog |
| coverage | VARCHAR(50) | Coverage scope of the source, such as Global or Regional |
| is_active | BOOLEAN | Whether the source is currently active |
| last_reviewed_date | DATE | Most recent review date for the source |