sources

This table contains all the sources for our datasets. The description column contains JSON encoded as text that contains useful additional fields like a longer descriptive text "additionalInfo".

Data license: CC-BY

1 row where datasetId = 5421 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
21256 Dal-Ré et al. (2021) 
{
    "link": "https://www.sciencedirect.com/science/article/pii/S0895435621003577",
    "retrievedDate": "29/11/2021",
    "additionalInfo": "This is a dataset of clinical trials with results reported to the European Clinical Trials Register (EU-CTR). Under EU guidelines, all clinical trials in the European Economic Area are required to be registered in the EudraCT system and to have results submitted within 12 months of the trial's completion or 6 months for certain paediatric trials, as of December 2016. This requirement to report results was retrospectively applied to all completed trials on the registry dating to its launch in 2004. However, many clinical trials breach these requirements. This dataset shows the proportion of all registered clinical trials by non-commercial sponsors in the European Economic Area that reported results in time on the EU-CTR.",
    "dataPublishedBy": "Dal-R\u00e9, R., Goldacre, B., Mahillo-Fern\u00e1ndez, I., & DeVito, N. J. (2021). European non-commercial sponsors showed substantial variation in results reporting to the EU trial registry. Journal of Clinical Epidemiology, S0895435621003577. https://doi.org/10.1016/j.jclinepi.2021.11.005",
    "dataPublisherSource": "Extracted from European Clinical Trials Register (EU-CTR)"
}
 2021-11-29 18:21:13 2021-11-29 18:21:13 Clinical trials results reporting – EU-CTR (Dal-Ré, 2021) 5421 This is a dataset of clinical trials with results reported to the European Clinical Trials Register (EU-CTR). Under EU guidelines, all clinical trials in the European Economic Area are required to be registered in the EudraCT system and to have results submitted within 12 months of the trial's completion or 6 months for certain paediatric trials, as of December 2016. This requirement to report results was retrospectively applied to all completed trials on the registry dating to its launch in 2004. However, many clinical trials breach these requirements. This dataset shows the proportion of all registered clinical trials by non-commercial sponsors in the European Economic Area that reported results in time on the EU-CTR. https://www.sciencedirect.com/science/article/pii/S0895435621003577 Dal-Ré, R., Goldacre, B., Mahillo-Fernández, I., & DeVito, N. J. (2021). European non-commercial sponsors showed substantial variation in results reporting to the EU trial registry. Journal of Clinical Epidemiology, S0895435621003577. https://doi.org/10.1016/j.jclinepi.2021.11.005

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "sources" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(512) NULL  ,
	"description" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");