variables
Data license: CC-BY
5 rows where sourceId = 29466 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt, timespan, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
802607 | 17.3.1 - Gross receipts by developing countries of private grants (millions of United States dollars) - DC_OSSD_PRVGRT | millions of current united states dollars | Gross receipts by developing countries of private grants (millions of United States dollars) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-03-01.pdf | 2023-08-17 17:14:11 | 2024-07-08 16:16:48 | 2016-2021 | United Nations Sustainable Development Goals (2023-Q2) 6193 | Total Official Support for Sustainable Development (TOSSD) 29466 | { "unit": "millions of current united states dollars" } |
0 | _17_3_1__dc_ossd_prvgrt | grapher/un/2023-08-16/un_sdg/_17_3_1__dc_ossd_prvgrt#_17_3_1__dc_ossd_prvgrt | 1 | [] |
float | [] |
c3271bebe5b97b9d2654e18a10f7fcd2 | 82b3410888ddfc2530acb2446aeba9b9 | ||||||||||||||||||
802606 | 17.3.1 - Gross receipts by developing countries of official non-concessional sustainable development loans (millions of United States dollars) - DC_OSSD_OFFNL | millions of current united states dollars | Gross receipts by developing countries of official non-concessional sustainable development loans (millions of United States dollars) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-03-01.pdf | 2023-08-17 17:14:11 | 2024-07-08 16:16:48 | 2019-2021 | United Nations Sustainable Development Goals (2023-Q2) 6193 | Total Official Support for Sustainable Development (TOSSD) 29466 | { "unit": "millions of current united states dollars" } |
0 | _17_3_1__dc_ossd_offnl | grapher/un/2023-08-16/un_sdg/_17_3_1__dc_ossd_offnl#_17_3_1__dc_ossd_offnl | 1 | [] |
float | [] |
ebd7976ea023fed467f0f28461d8aa56 | c556e626e28b5a9d2a6bd1be8df9c25f | ||||||||||||||||||
802605 | 17.3.1 - Gross receipts by developing countries of official concessional sustainable development loans (millions of United States dollars) - DC_OSSD_OFFCL | millions of current united states dollars | Gross receipts by developing countries of official concessional sustainable development loans (millions of United States dollars) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-03-01.pdf | 2023-08-17 17:14:10 | 2024-07-08 16:16:48 | 2019-2021 | United Nations Sustainable Development Goals (2023-Q2) 6193 | Total Official Support for Sustainable Development (TOSSD) 29466 | { "unit": "millions of current united states dollars" } |
0 | _17_3_1__dc_ossd_offcl | grapher/un/2023-08-16/un_sdg/_17_3_1__dc_ossd_offcl#_17_3_1__dc_ossd_offcl | 1 | [] |
float | [] |
2cf3952b41c3b851f160f80ba592f5b1 | a525edf47bc4b6b79cc01e9d0450423b | ||||||||||||||||||
802604 | 17.3.1 - Gross receipts by developing countries of mobilised private finance (MPF) - on an experimental basis (millions of United States dollars) - DC_OSSD_MPF | millions of current united states dollars | Gross receipts by developing countries of mobilised private finance (MPF) - on an experimental basis (millions of United States dollars) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-03-01.pdf | 2023-08-17 17:14:10 | 2024-07-08 16:16:48 | 2016-2021 | United Nations Sustainable Development Goals (2023-Q2) 6193 | Total Official Support for Sustainable Development (TOSSD) 29466 | { "unit": "millions of current united states dollars" } |
0 | _17_3_1__dc_ossd_mpf | grapher/un/2023-08-16/un_sdg/_17_3_1__dc_ossd_mpf#_17_3_1__dc_ossd_mpf | 1 | [] |
float | [] |
909445e57fceb238600b285ec188540f | 9ed773b22c59158ca9fd35853045d227 | ||||||||||||||||||
802603 | 17.3.1 - Gross receipts by developing countries of official sustainable development grants (millions of United States dollars) - DC_OSSD_GRT | millions of current united states dollars | Gross receipts by developing countries of official sustainable development grants (millions of United States dollars) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-03-01.pdf | 2023-08-17 17:14:09 | 2024-07-08 16:16:48 | 2019-2021 | United Nations Sustainable Development Goals (2023-Q2) 6193 | Total Official Support for Sustainable Development (TOSSD) 29466 | { "unit": "millions of current united states dollars" } |
0 | _17_3_1__dc_ossd_grt | grapher/un/2023-08-16/un_sdg/_17_3_1__dc_ossd_grt#_17_3_1__dc_ossd_grt | 1 | [] |
float | [] |
3a503825b99fbeaf9f62a8f2431bded2 | 88602abb708f1e8e95261a75e58cd434 |
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");