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 = 5572 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
21963 Thompson and Kalkowska (2020) 
{
    "link": "https://onlinelibrary.wiley.com/doi/pdfdirect/10.1111/risa.13557",
    "additionalInfo": "This dataset shows actual and estimated costs of polio vaccines by type, dosage, route of administration and type of vaccination schedule. \n\nPolio vaccines can be of two types: Oral Poliovirus Vaccines (OPV) or Inactivated Poliovirus Vaccines (IPV). They can be given at different doses (full or fractional). They can be administered in different ways: orally (for OPVs), by needle, device, or patch (for IPVs). They are either given during routine immunizations (RI) or during supplementary immunization activities (SIAs) where large groups tend to be vaccinated at the same time. SIAs are performed as preventative (pSIAs) or as part of an outbreak-response (oSIAs). \n\nIn eligible countries, Gavi funds IPVs to make them more affordable.",
    "dataPublishedBy": "Thompson, K. M., & Kalkowska, D. A. (2021). Potential future use, costs, and value of poliovirus vaccines. Risk Analysis, 41(2), 349-363.",
    "dataPublisherSource": "Actual price lists from UNICEF (2019) and personal communications with manufacturers"
}
 2022-04-05 14:18:02 2022-04-05 14:18:02 Polio vaccine costs in low-income countries 5572 This dataset shows actual and estimated costs of polio vaccines by type, dosage, route of administration and type of vaccination schedule. Polio vaccines can be of two types: Oral Poliovirus Vaccines (OPV) or Inactivated Poliovirus Vaccines (IPV). They can be given at different doses (full or fractional). They can be administered in different ways: orally (for OPVs), by needle, device, or patch (for IPVs). They are either given during routine immunizations (RI) or during supplementary immunization activities (SIAs) where large groups tend to be vaccinated at the same time. SIAs are performed as preventative (pSIAs) or as part of an outbreak-response (oSIAs). In eligible countries, Gavi funds IPVs to make them more affordable. https://onlinelibrary.wiley.com/doi/pdfdirect/10.1111/risa.13557 Thompson, K. M., & Kalkowska, D. A. (2021). Potential future use, costs, and value of poliovirus vaccines. Risk Analysis, 41(2), 349-363.

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");