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

2 rows where datasetId = 5820 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
28652 International Renewable Energy Agency (IRENA) (2021) 
{
    "link": "https://www.irena.org/Statistics/View-Data-by-Topic/Innovation-and-Technology/Patents-Evolution",
    "retrievedDate": "2022-10-25",
    "additionalInfo": "\nThe data reports the annual number of new patents filed under the category of each renewable technology.\n\nNote that the number of patents for the last few years may be subject to a time lag; processing times of patent applications vary and some patents submitted over this period may not yet be recorded in the statistics. These figures will be updated with time if additional patent applications are recorded.\n",
    "dataPublishedBy": "International Renewable Energy Agency (IRENA) INSPIRE Platform based on EPO PATSTAT 2021 Autumn edition and on the Climate Change Mitigation Technologies (Y02) classification by EPO."
}
 2023-08-30 22:47:56 2023-12-14 12:08:42 Renewable energy patents 5820 The data reports the annual number of new patents filed under the category of each renewable technology. Note that the number of patents for the last few years may be subject to a time lag; processing times of patent applications vary and some patents submitted over this period may not yet be recorded in the statistics. These figures will be updated with time if additional patent applications are recorded. https://www.irena.org/Statistics/View-Data-by-Topic/Innovation-and-Technology/Patents-Evolution International Renewable Energy Agency (IRENA) INSPIRE Platform based on EPO PATSTAT 2021 Autumn edition and on the Climate Change Mitigation Technologies (Y02) classification by EPO.
27106 International Renewable Energy Agency (IRENA) (2021) 
{
    "link": "https://www.irena.org/Statistics/View-Data-by-Topic/Innovation-and-Technology/Patents-Evolution",
    "retrievedDate": "2022-10-25",
    "additionalInfo": "The data reports the annual number of new patents filed under the category of each renewable technology.\n\nNote that the number of patents for the last few years may be subject to a time lag; processing times of patent applications vary and some patents submitted over this period may not yet be recorded in the statistics. These figures will be updated with time if additional patent applications are recorded.\n",
    "dataPublishedBy": "International Renewable Energy Agency (IRENA) INSPIRE Platform based on EPO PATSTAT 2021 Autumn edition and on the Climate Change Mitigation Technologies (Y02) classification by EPO."
}
 2022-10-27 07:19:27 2023-12-14 12:08:35 Renewable energy patents 5820 The data reports the annual number of new patents filed under the category of each renewable technology. Note that the number of patents for the last few years may be subject to a time lag; processing times of patent applications vary and some patents submitted over this period may not yet be recorded in the statistics. These figures will be updated with time if additional patent applications are recorded. https://www.irena.org/Statistics/View-Data-by-Topic/Innovation-and-Technology/Patents-Evolution International Renewable Energy Agency (IRENA) INSPIRE Platform based on EPO PATSTAT 2021 Autumn edition and on the Climate Change Mitigation Technologies (Y02) classification by EPO.

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