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 = 1851 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
13162 Karl Rupp, Microprocessor Trend Data 
{
    "link": "https://github.com/karlrupp/microprocessor-trend-data",
    "retrievedDate": "2023-03-08",
    "additionalInfo": "Sourced from Karl Rupp series on microprocessor trend data. Rupp's data for the years prior to 2000 from M. Horowitz, F. Labonte, O. Shacham, K. Olukotun, L. Hammond, and C. Batten. '35 Years of Microprocessor Trend Data'.\n\nThis data also correlates to that published in 'The Singularity Is Near: When Humans Transcend Biology' by Ray Kurzweil up to 2003. Available at: http://www.singularity.com/index.html\n\nWhere data of several microprocessors is given for a single year, we have shown the highest transistor count per chip of that year.\n\nData for 2015 and 2017 have been updated by OurWorldinData based on highest transistor count noted at: https://en.wikipedia.org/wiki/Transistor_count. The 2015 record was set by Oracle's 32-core SPARC M7 (https://www.enterprisetech.com/2014/08/13/oracle-cranks-cores-32-sparc-m7-chip/) and in 2017 by the 32-core AMD Epyc microprocessor.",
    "dataPublishedBy": "Karl Rupp, Microprocessor Trend Data"
}
 2017-11-30 16:44:01 2023-03-08 13:59:33 Transistors per microprocessor - Rupp & Horowitz 1851 Sourced from Karl Rupp series on microprocessor trend data. Rupp's data for the years prior to 2000 from M. Horowitz, F. Labonte, O. Shacham, K. Olukotun, L. Hammond, and C. Batten. '35 Years of Microprocessor Trend Data'. This data also correlates to that published in 'The Singularity Is Near: When Humans Transcend Biology' by Ray Kurzweil up to 2003. Available at: http://www.singularity.com/index.html Where data of several microprocessors is given for a single year, we have shown the highest transistor count per chip of that year. Data for 2015 and 2017 have been updated by OurWorldinData based on highest transistor count noted at: https://en.wikipedia.org/wiki/Transistor_count. The 2015 record was set by Oracle's 32-core SPARC M7 (https://www.enterprisetech.com/2014/08/13/oracle-cranks-cores-32-sparc-m7-chip/) and in 2017 by the 32-core AMD Epyc microprocessor. https://github.com/karlrupp/microprocessor-trend-data Karl Rupp, Microprocessor Trend Data

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