owid: sources: 2 rows where datasetId = 6012 sorted by id descending

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

2 rows where datasetId = 6012 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
29562	United States Patent and Trademark Office (2020)	{ "link": "https://www.uspto.gov/web/offices/ac/ido/oeip/taf/reports.htm", "retrievedDate": "2023-05-24", "additionalInfo": "\nThe U.S. Patent and Trademark Office (USPTO)'s Patent Technology Monitoring Team periodically issues general statistics and reports that profile patenting activity. The data imported by Our World in Data focuses on annual, U.S. patent application and grant activity from 1790 to the present. Annual activity is determined based on the calendar year.", "dataPublishedBy": "U.S. Patent and Trademark Office, U.S. Patent Activity Calendar Years 1790 to the Present" }	2023-12-14 12:03:21	2024-07-08 16:28:47	U.S. patent activity since 1790 (USPTO, 2023) 6012	The U.S. Patent and Trademark Office (USPTO)'s Patent Technology Monitoring Team periodically issues general statistics and reports that profile patenting activity. The data imported by Our World in Data focuses on annual, U.S. patent application and grant activity from 1790 to the present. Annual activity is determined based on the calendar year.	https://www.uspto.gov/web/offices/ac/ido/oeip/taf/reports.htm	U.S. Patent and Trademark Office, U.S. Patent Activity Calendar Years 1790 to the Present
27625	United States Patent and Trademark Office (2020)	{ "link": "https://www.uspto.gov/web/offices/ac/ido/oeip/taf/reports.htm", "retrievedDate": "2023-05-24", "additionalInfo": "The U.S. Patent and Trademark Office (USPTO)'s Patent Technology Monitoring Team periodically issues general statistics and reports that profile patenting activity. The data imported by Our World in Data focuses on annual, U.S. patent application and grant activity from 1790 to the present. Annual activity is determined based on the calendar year.", "dataPublishedBy": "U.S. Patent and Trademark Office, U.S. Patent Activity Calendar Years 1790 to the Present" }	2023-05-25 12:50:30	2024-07-08 16:28:46	U.S. patent activity since 1790 (USPTO, 2023) 6012	The U.S. Patent and Trademark Office (USPTO)'s Patent Technology Monitoring Team periodically issues general statistics and reports that profile patenting activity. The data imported by Our World in Data focuses on annual, U.S. patent application and grant activity from 1790 to the present. Annual activity is determined based on the calendar year.	https://www.uspto.gov/web/offices/ac/ido/oeip/taf/reports.htm	U.S. Patent and Trademark Office, U.S. Patent Activity Calendar Years 1790 to the Present

Advanced export

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

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