variables
Data license: CC-BY
6 rows where datasetId = 5032 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit, createdAt, createdAt (date), updatedAt (date)
| id ▲ | name | unit | description | createdAt | updatedAt | code | coverage | timespan | datasetId | sourceId | shortUnit | display | columnOrder | originalMetadata | grapherConfigAdmin | shortName | catalogPath | dimensions | schemaVersion | processingLevel | processingLog | titlePublic | titleVariant | attributionShort | attribution | descriptionShort | descriptionFromProducer | descriptionKey | descriptionProcessing | licenses | license | grapherConfigETL | type | sort | dataChecksum | metadataChecksum |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 136628 | Credit to Agriculture - Total Credit - 23018 - Value US$ - 6110 - millions | millions | The Credit to Agriculture dataset provides national data for over 100 countries on the amount of loans provided by the private/commercial banking sector to producers in agriculture, forestry and fisheries, including household producers, cooperatives, and agro-businesses. For some countries, the three subsectors of agriculture, forestry, and fishing are completely specified. In other cases, complete disaggregations are not available. The dataset also provides statistics on the total credit to all industries, indicators on the share of credit to agricultural producers, and an agriculture orientation index (the agriculture share of credit, over the agriculture share of GDP). | 2020-02-14 02:51:30 | 2023-06-15 05:05:42 | IC - 23018 - 6110 - millions | Investment: Credit to Agriculture 5032 | Investment: Credit to Agriculture 17763 | {} |
0 | 1 | |||||||||||||||||||||||||
| 136627 | Credit to Agriculture - Total Credit - 23018 - Value Local Currency - 6109 - millions | millions | The Credit to Agriculture dataset provides national data for over 100 countries on the amount of loans provided by the private/commercial banking sector to producers in agriculture, forestry and fisheries, including household producers, cooperatives, and agro-businesses. For some countries, the three subsectors of agriculture, forestry, and fishing are completely specified. In other cases, complete disaggregations are not available. The dataset also provides statistics on the total credit to all industries, indicators on the share of credit to agricultural producers, and an agriculture orientation index (the agriculture share of credit, over the agriculture share of GDP). | 2020-02-14 02:51:30 | 2023-06-15 05:05:42 | IC - 23018 - 6109 - millions | Investment: Credit to Agriculture 5032 | Investment: Credit to Agriculture 17763 | {} |
0 | 1 | |||||||||||||||||||||||||
| 136626 | Credit to Agriculture - Credit to Agriculture, Forestry and Fishing - 23068 - Value US$ - 6110 - millions | millions | The Credit to Agriculture dataset provides national data for over 100 countries on the amount of loans provided by the private/commercial banking sector to producers in agriculture, forestry and fisheries, including household producers, cooperatives, and agro-businesses. For some countries, the three subsectors of agriculture, forestry, and fishing are completely specified. In other cases, complete disaggregations are not available. The dataset also provides statistics on the total credit to all industries, indicators on the share of credit to agricultural producers, and an agriculture orientation index (the agriculture share of credit, over the agriculture share of GDP). | 2020-02-14 02:51:30 | 2023-06-15 05:05:42 | IC - 23068 - 6110 - millions | Investment: Credit to Agriculture 5032 | Investment: Credit to Agriculture 17763 | {} |
0 | 1 | |||||||||||||||||||||||||
| 136625 | Credit to Agriculture - Credit to Agriculture, Forestry and Fishing - 23068 - Value Local Currency - 6109 - millions | millions | The Credit to Agriculture dataset provides national data for over 100 countries on the amount of loans provided by the private/commercial banking sector to producers in agriculture, forestry and fisheries, including household producers, cooperatives, and agro-businesses. For some countries, the three subsectors of agriculture, forestry, and fishing are completely specified. In other cases, complete disaggregations are not available. The dataset also provides statistics on the total credit to all industries, indicators on the share of credit to agricultural producers, and an agriculture orientation index (the agriculture share of credit, over the agriculture share of GDP). | 2020-02-14 02:51:29 | 2023-06-15 05:05:42 | IC - 23068 - 6109 - millions | Investment: Credit to Agriculture 5032 | Investment: Credit to Agriculture 17763 | {} |
0 | 1 | |||||||||||||||||||||||||
| 136624 | Credit to Agriculture - Credit to Agriculture, Forestry and Fishing - 23068 - Share of Total Credit - 6113 - % | % | The Credit to Agriculture dataset provides national data for over 100 countries on the amount of loans provided by the private/commercial banking sector to producers in agriculture, forestry and fisheries, including household producers, cooperatives, and agro-businesses. For some countries, the three subsectors of agriculture, forestry, and fishing are completely specified. In other cases, complete disaggregations are not available. The dataset also provides statistics on the total credit to all industries, indicators on the share of credit to agricultural producers, and an agriculture orientation index (the agriculture share of credit, over the agriculture share of GDP). | 2020-02-14 02:51:29 | 2023-06-15 05:05:42 | IC - 23068 - 6113 - % | Investment: Credit to Agriculture 5032 | Investment: Credit to Agriculture 17763 | {} |
0 | 1 | |||||||||||||||||||||||||
| 136623 | Credit to Agriculture - Credit to Agriculture, Forestry and Fishing - 23068 - Agriculture orientation index - 6112 - index | index | The Credit to Agriculture dataset provides national data for over 100 countries on the amount of loans provided by the private/commercial banking sector to producers in agriculture, forestry and fisheries, including household producers, cooperatives, and agro-businesses. For some countries, the three subsectors of agriculture, forestry, and fishing are completely specified. In other cases, complete disaggregations are not available. The dataset also provides statistics on the total credit to all industries, indicators on the share of credit to agricultural producers, and an agriculture orientation index (the agriculture share of credit, over the agriculture share of GDP). | 2020-02-14 02:51:29 | 2023-06-15 05:05:42 | IC - 23068 - 6112 - index | Investment: Credit to Agriculture 5032 | Investment: Credit to Agriculture 17763 | {} |
0 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "variables" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"name" VARCHAR(750) NULL ,
"unit" VARCHAR(255) NOT NULL ,
"description" TEXT NULL ,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
"updatedAt" DATETIME NULL ,
"code" VARCHAR(255) NULL ,
"coverage" VARCHAR(255) NOT NULL ,
"timespan" VARCHAR(255) NOT NULL ,
"datasetId" INTEGER NOT NULL ,
"sourceId" INTEGER NULL ,
"shortUnit" VARCHAR(255) NULL ,
"display" TEXT NOT NULL ,
"columnOrder" INTEGER NOT NULL DEFAULT '0' ,
"originalMetadata" TEXT NULL ,
"grapherConfigAdmin" TEXT NULL ,
"shortName" VARCHAR(255) NULL ,
"catalogPath" VARCHAR(767) NULL ,
"dimensions" TEXT NULL ,
"schemaVersion" INTEGER NOT NULL DEFAULT '1' ,
"processingLevel" VARCHAR(30) NULL ,
"processingLog" TEXT NULL ,
"titlePublic" VARCHAR(512) NULL ,
"titleVariant" VARCHAR(255) NULL ,
"attributionShort" VARCHAR(512) NULL ,
"attribution" TEXT NULL ,
"descriptionShort" TEXT NULL ,
"descriptionFromProducer" TEXT NULL ,
"descriptionKey" TEXT NULL ,
"descriptionProcessing" TEXT NULL ,
"licenses" TEXT NULL ,
"license" TEXT NULL ,
"grapherConfigETL" TEXT NULL ,
"type" TEXT NULL ,
"sort" TEXT NULL ,
"dataChecksum" VARCHAR(64) NULL ,
"metadataChecksum" VARCHAR(64) NULL,
FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath");
CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId");
CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId");
CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId");
CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId");
CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");