sources

Data license: CC-BY

1 row where datasetId = 2970 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

{
    "link": "(i)https://www.whitehouse.gov/sites/default/files/docs/longtermhealthinsuranceseriesmethodologyfinal.pdf.(ii) http://www.cdc.gov/nchs/data/nhis/earlyrelease/earlyrelease201605_01.pdf",
    "retrievedDate": "19/07/2016",
    "additionalInfo": "For 1978-2015, both\u00a0CEA and NCHS\u00a0relied on historical data from the National Health Interview Survey (NHIS). \u00a0For years prior to 1978\u00a0CEA estimated the overall uninsured rate by combining information from the NHIS on trends in private coverage, with administrative data on Medicare and Medicaid enrollment during those years. See the links above for further details.",
    "dataPublishedBy": "(i) 1963-2013, Council of Economic Advisers; (ii) 2014-2015, National Center for Health Statistics",
    "dataPublisherSource": null
}

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