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 = 3240 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
16744 Bord et al. (2001); FRED (2015) 
{
    "link": "http://www.jstor.org/stable/3601034?__redirected; http://research.stlouisfed.org/fred2/series/CPALTT01USA661S",
    "additionalInfo": "In the chart, two years in which deflation occurred have been omitted. If the two observations in which deflation (falling prices) occurred are included in the regression in absolute values\u2014reflecting the fact that it is changes in prices that are unpopular\u2014then the relationship shown in the figure is stronger. The R-squared is 0.42 compared to 0.36, and the coefficient on inflation is still negative and significant.",
    "dataPublishedBy": "Inflation before 1950: Michael Bordo, Barry Eichengreen, Daniela Klingebiel, and Maria Soledad Martinez-Peria. 2001. \u2018Is the crisis problem growing more severe?\u2019. Economic Policy 16 (32) (April): pp. 52\u201382;  CPI after 1950: Federal Reserve Bank of St. Louis. 2015. FRED"
}
 2019-03-01 12:36:49 2019-03-01 12:36:49 TE-15.1_inflation 3240 In the chart, two years in which deflation occurred have been omitted. If the two observations in which deflation (falling prices) occurred are included in the regression in absolute values—reflecting the fact that it is changes in prices that are unpopular—then the relationship shown in the figure is stronger. The R-squared is 0.42 compared to 0.36, and the coefficient on inflation is still negative and significant. http://www.jstor.org/stable/3601034?__redirected; http://research.stlouisfed.org/fred2/series/CPALTT01USA661S Inflation before 1950: Michael Bordo, Barry Eichengreen, Daniela Klingebiel, and Maria Soledad Martinez-Peria. 2001. ‘Is the crisis problem growing more severe?’. Economic Policy 16 (32) (April): pp. 52–82; CPI after 1950: Federal Reserve Bank of St. Louis. 2015. FRED

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