datasets
Data license: CC-BY
41 rows where createdByUserId = 58 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: description, namespace, isPrivate, metadataEditedByUserId, isArchived, shortName, version, createdAt (date), updatedAt (date), metadataEditedAt (date), dataEditedAt (date), version (date)
id ▲ | name | description | createdAt | updatedAt | namespace | isPrivate | createdByUserId | metadataEditedAt | metadataEditedByUserId | dataEditedAt | dataEditedByUserId | nonRedistributable | isArchived | sourceChecksum | shortName | version | updatePeriodDays |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5830 | UK historical electricity (DUKES, 2022) | 2022-12-13 08:08:45 | 2022-12-13 08:08:45 | energy | 0 | Pablo Rosado 58 | 2022-12-13 08:08:45 | Pablo Rosado 58 | 2022-12-13 08:08:45 | Pablo Rosado 58 | 0 | 1 | c2cb56b318117f21d12727ec59e3e6d1 | uk_historical_electricity | 2022-12-12 | ||
5829 | Electricity mix (BP & Ember, 2022b) | 2022-12-12 15:53:38 | 2022-12-12 16:32:16 | energy | 0 | Pablo Rosado 58 | 2022-12-12 16:32:16 | Pablo Rosado 58 | 2022-12-12 16:32:16 | Pablo Rosado 58 | 0 | 1 | 85cb9d2a84aeac8d9d3589af9569c6a1 | electricity_mix | 2022-12-12 | ||
5778 | UK historical electricity | 2022-09-26 07:33:18 | 2022-09-26 07:33:18 | energy | 0 | Pablo Rosado 58 | 2022-09-26 07:33:18 | Pablo Rosado 58 | 2022-09-26 07:33:18 | Pablo Rosado 58 | 0 | 1 | 5aaa6ee7d1acef8c8e7ef461948eaa0e | uk_historical_electricity | 2022-09-22 | ||
5713 | Inputs: Fertilizers by Nutrient (FAO, 2022-05-17) | 2022-08-23 19:51:01 | 2022-08-24 13:57:28 | faostat | 1 | Pablo Rosado 58 | 2022-08-24 13:57:28 | Pablo Rosado 58 | 2022-08-24 13:57:28 | Pablo Rosado 58 | 0 | 1 | 5cfc1fc7b3a1ffc6cf4445e0e70ea0b5 | faostat_rfn | 2022-05-17 | ||
5712 | Food Security: Suite of Food Security Indicators (FAO, 2022-05-17) | 2022-08-23 19:50:51 | 2022-08-23 19:50:51 | faostat | 1 | Pablo Rosado 58 | 2022-08-23 19:50:51 | Pablo Rosado 58 | 2022-08-23 19:50:51 | Pablo Rosado 58 | 0 | 1 | 02764eb514eaaaff7cbdcc45783d65e8 | faostat_fs | 2022-05-17 | ||
5711 | Inputs: Fertilizers by Product (FAO, 2022-05-17) | 2022-08-23 19:50:36 | 2023-04-10 10:50:16 | faostat | 1 | Pablo Rosado 58 | 2023-04-06 12:01:01 | Pablo Rosado 58 | 2023-04-06 12:01:01 | Pablo Rosado 58 | 0 | 1 | 72d7782d6fee005e7683b89b146cf9a0 | faostat_rfb | 2022-05-17 | ||
5710 | Agri-Environmental Indicators: Livestock Patterns (FAO, 2022-05-17) | 2022-08-23 19:50:25 | 2022-09-08 12:49:02 | faostat | 1 | Pablo Rosado 58 | 2022-09-08 12:49:02 | Pablo Rosado 58 | 2022-09-08 12:49:02 | Pablo Rosado 58 | 0 | 1 | 7630da2dfbf5a987525c32343d44cbbc | faostat_ek | 2022-05-17 | ||
5709 | Inputs: Pesticides Trade (FAO, 2022-05-17) | 2022-08-23 19:50:09 | 2022-08-23 19:50:09 | faostat | 1 | Pablo Rosado 58 | 2022-08-23 19:50:09 | Pablo Rosado 58 | 2022-08-23 19:50:09 | Pablo Rosado 58 | 0 | 1 | 46ed47106152ed7ae41c369234c16f82 | faostat_rt | 2022-05-17 | ||
5708 | SDG Indicators: SDG Indicators (FAO, 2022-05-17) | 2022-08-23 19:49:58 | 2022-09-08 12:49:55 | faostat | 1 | Pablo Rosado 58 | 2022-09-08 12:49:55 | Pablo Rosado 58 | 2022-09-08 12:49:55 | Pablo Rosado 58 | 0 | 1 | 53190e389c85920338334786f04de4a3 | faostat_sdgb | 2022-05-17 | ||
5707 | Agri-Environmental Indicators: Fertilizers indicators (FAO, 2022-05-17) | 2022-08-23 19:49:52 | 2022-08-24 15:21:46 | faostat | 1 | Pablo Rosado 58 | 2022-08-24 15:21:46 | Pablo Rosado 58 | 2022-08-24 15:21:46 | Pablo Rosado 58 | 0 | 1 | 5b8275449bf0cea800ab58f8841b7b34 | faostat_ef | 2022-05-17 | ||
5706 | Production: Production Indices (FAO, 2022-05-17) | 2022-08-23 19:49:04 | 2022-08-24 14:38:32 | faostat | 1 | Pablo Rosado 58 | 2022-08-24 14:38:32 | Pablo Rosado 58 | 2022-08-24 14:38:32 | Pablo Rosado 58 | 0 | 1 | 7ca5f6a87c7ce01266183881536971e6 | faostat_qi | 2022-05-17 | ||
5705 | Agri-Environmental Indicators: Pesticides indicators (FAO, 2022-05-17) | 2022-08-23 19:49:00 | 2023-04-06 11:53:48 | faostat | 1 | Pablo Rosado 58 | 2023-04-06 11:53:48 | Pablo Rosado 58 | 2023-04-06 11:53:48 | Pablo Rosado 58 | 0 | 1 | cd46223dd9fc2bd911bea99fba6b0e48 | faostat_ep | 2022-05-17 | ||
5704 | Forestry: Forestry Production and Trade (FAO, 2022-05-17) | 2022-08-23 19:48:13 | 2022-08-23 19:48:13 | faostat | 1 | Pablo Rosado 58 | 2022-08-23 19:48:13 | Pablo Rosado 58 | 2022-08-23 19:48:13 | Pablo Rosado 58 | 0 | 1 | 9e78753829049a95c5b5dc836923f667 | faostat_fo | 2022-05-17 | ||
5703 | Food Balances (old methodology before 2010, and new from 2010 onwards) (FAO, 2022-05-17) | 2022-08-23 19:31:50 | 2022-08-24 14:48:31 | faostat | 1 | Pablo Rosado 58 | 2022-08-24 14:48:31 | Pablo Rosado 58 | 2022-08-24 14:48:31 | Pablo Rosado 58 | 0 | 1 | 0bbb0e667ca33208e5e2fa5d7c3676f0 | faostat_fbsc | 2022-05-17 | ||
5702 | Inputs: Land Use (FAO, 2022-05-17) | 2022-08-23 19:31:41 | 2023-04-06 12:20:31 | faostat | 1 | Pablo Rosado 58 | 2023-04-06 12:20:31 | Pablo Rosado 58 | 2023-04-06 12:20:31 | Pablo Rosado 58 | 0 | 1 | 03f2265a3cd164513aa70a413989b94f | faostat_rl | 2022-05-17 | ||
5701 | Land, Inputs and Sustainability: Soil nutrient budget (FAO, 2022-05-17) | 2022-08-23 19:31:34 | 2022-08-24 14:36:14 | faostat | 1 | Pablo Rosado 58 | 2022-08-24 14:36:14 | Pablo Rosado 58 | 2022-08-24 14:36:14 | Pablo Rosado 58 | 0 | 1 | 0081c1a0109c8bb37172d39d2db75c66 | faostat_esb | 2022-05-17 | ||
5700 | Agri-Environmental Indicators: Livestock Manure (FAO, 2022-05-17) | 2022-08-23 19:30:53 | 2022-08-24 14:32:26 | faostat | 1 | Pablo Rosado 58 | 2022-08-24 14:32:26 | Pablo Rosado 58 | 2022-08-24 14:32:26 | Pablo Rosado 58 | 0 | 1 | 643a709159e39551a1066149d1d01389 | faostat_emn | 2022-05-17 | ||
5699 | Trade: Trade Indices (FAO, 2022-05-17) | 2022-08-23 19:23:59 | 2022-08-24 14:15:50 | faostat | 1 | Pablo Rosado 58 | 2022-08-24 14:15:50 | Pablo Rosado 58 | 2022-08-24 14:15:50 | Pablo Rosado 58 | 0 | 1 | 51b10519f6cf0703c41cc73fe7a05189 | faostat_ti | 2022-05-17 | ||
5698 | Discontinued archives and data series: Food Aid Shipments (WFP) (FAO, 2022-05-17) | 2022-08-23 19:23:55 | 2022-08-24 14:15:40 | faostat | 1 | Pablo Rosado 58 | 2022-08-24 14:15:40 | Pablo Rosado 58 | 2022-08-24 14:15:40 | Pablo Rosado 58 | 0 | 1 | 6fa710d30b44670221694189ca3b0396 | faostat_fa | 2022-05-17 | ||
5697 | Inputs: Pesticides Use (FAO, 2022-05-17) | 2022-08-23 19:23:47 | 2022-08-24 14:35:54 | faostat | 1 | Pablo Rosado 58 | 2022-08-24 14:35:54 | Pablo Rosado 58 | 2022-08-24 14:35:54 | Pablo Rosado 58 | 0 | 1 | 8585a0c24c78b95689e2e80cc56baedf | faostat_rp | 2022-05-17 | ||
5696 | Food Balances: Supply Utilization Accounts (FAO, 2022-05-17) | 2022-08-23 17:50:51 | 2022-08-25 06:59:42 | faostat | 1 | Pablo Rosado 58 | 2022-08-25 06:59:42 | Pablo Rosado 58 | 2022-08-25 06:59:42 | Pablo Rosado 58 | 0 | 1 | 9c5059063fccb82bac7cc548ff2f0f97 | faostat_scl | 2022-05-17 | ||
5695 | Trade: Crops and livestock products (FAO, 2022-05-17) | 2022-08-23 17:41:54 | 2022-08-24 13:57:41 | faostat | 1 | Pablo Rosado 58 | 2022-08-24 13:57:41 | Pablo Rosado 58 | 2022-08-24 13:57:41 | Pablo Rosado 58 | 0 | 1 | cc5b2175d4d85d7676e5c352f67b78ca | faostat_tcl | 2022-05-17 | ||
5694 | Agri-Environmental Indicators: Land use indicators (FAO, 2022-05-17) | 2022-08-23 17:41:47 | 2023-04-06 14:52:29 | faostat | 1 | Pablo Rosado 58 | 2023-04-06 14:52:29 | Pablo Rosado 58 | 2023-04-06 14:52:29 | Pablo Rosado 58 | 0 | 1 | 3c82e1dfd3b1c11698d3e3b724a8eb7d | faostat_el | 2022-05-17 | ||
5693 | Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) | 2022-08-23 17:41:39 | 2022-08-24 14:48:12 | faostat | 1 | Pablo Rosado 58 | 2022-08-24 14:48:12 | Pablo Rosado 58 | 2022-08-24 14:48:12 | Pablo Rosado 58 | 0 | 1 | 89a794e265d4addc282d83d60081797f | faostat_lc | 2022-05-17 | ||
5692 | Agri-Environmental Indicators: Emissions intensities (FAO, 2022-05-17) | 2022-08-23 17:41:28 | 2022-08-23 17:41:28 | faostat | 1 | Pablo Rosado 58 | 2022-08-23 17:41:28 | Pablo Rosado 58 | 2022-08-23 17:41:28 | Pablo Rosado 58 | 0 | 1 | befb7e1b278b82c49de369d597b88eea | faostat_ei | 2022-05-17 | ||
5691 | Production: Crops and livestock products (FAO, 2022-05-17) | 2022-08-23 17:08:28 | 2023-04-06 12:00:14 | faostat | 1 | Pablo Rosado 58 | 2023-04-06 12:00:14 | Pablo Rosado 58 | 2023-04-06 12:00:14 | Pablo Rosado 58 | 0 | 1 | 32569c0b5f49fe2afc0eb987037fa184 | faostat_qcl | 2022-05-17 | ||
5690 | Production: Value of Agricultural Production (FAO, 2022-05-17) | 2022-08-23 17:05:50 | 2022-09-08 12:41:05 | faostat | 1 | Pablo Rosado 58 | 2022-09-08 12:41:05 | Pablo Rosado 58 | 2022-09-08 12:41:05 | Pablo Rosado 58 | 0 | 1 | b8332a575b36447b680b38d55ac92437 | faostat_qv | 2022-05-17 | ||
5678 | Electricity mix (BP & Ember, 2022) | 2022-08-05 13:02:31 | 2022-11-04 08:51:54 | energy | 0 | Pablo Rosado 58 | 2022-11-04 08:51:54 | Pablo Rosado 58 | 2022-11-04 08:51:54 | Pablo Rosado 58 | 0 | 1 | fe237c38098bec4b2f1ecd808cc4e152 | electricity_mix | 2022-08-03 | ||
5657 | bp_energy_mix__bp_2022 | 2022-07-18 07:35:52 | 2022-07-18 07:35:52 | bp | 0 | Pablo Rosado 58 | 2022-07-18 07:35:52 | Pablo Rosado 58 | 2022-07-18 07:35:52 | Pablo Rosado 58 | 0 | 1 | 4c65d25fdccb389fccd111a4670c1eda | bp_energy_mix | 2022 | ||
5650 | Statistical Review of World Energy - BP (2022) | This is a dataset imported by the automated fetcher | 2022-07-11 09:01:56 | 2023-07-20 14:39:44 | bp_statreview@2022 | 1 | Pablo Rosado 58 | 2022-07-11 09:01:56 | Pablo Rosado 58 | 2022-07-11 09:01:56 | Pablo Rosado 58 | 0 | 1 | ||||
5582 | Global Carbon Budget - Global Carbon Project (v2021) | This is a dataset imported by the automated fetcher | 2022-04-18 08:10:39 | 2022-04-18 08:10:39 | gcp_gcb@v2021 | 0 | Pablo Rosado 58 | 2022-04-18 08:10:39 | Pablo Rosado 58 | 2022-04-18 08:10:39 | Pablo Rosado 58 | 0 | 1 | ||||
5574 | Electricity mix from BP & EMBER (2022) | 2022-04-08 12:20:51 | 2022-05-19 10:48:42 | owid | 0 | Pablo Rosado 58 | 2022-05-19 10:48:42 | Pablo Rosado 58 | 2022-05-19 10:48:42 | Pablo Rosado 58 | 0 | 1 | |||||
5570 | Energy mix from BP (2021) | 2022-03-31 15:05:11 | 2022-03-31 15:05:11 | owid | 0 | Pablo Rosado 58 | 2022-03-31 15:26:19 | Pablo Rosado 58 | 2022-03-31 15:05:11 | Pablo Rosado 58 | 0 | 1 | |||||
5569 | Primary energy consumption BP & EIA (2022) | 2022-03-31 12:09:05 | 2022-03-31 13:42:53 | owid | 0 | Pablo Rosado 58 | 2022-03-31 13:42:53 | Hannah Ritchie 14 | 2022-03-31 13:42:53 | Pablo Rosado 58 | 0 | 1 | |||||
5568 | Fossil fuel production BP & Shift (2022) | 2022-03-31 10:03:07 | 2022-03-31 11:13:11 | owid | 0 | Pablo Rosado 58 | 2022-03-31 11:13:11 | Pablo Rosado 58 | 2022-03-31 11:13:11 | Pablo Rosado 58 | 0 | 1 | |||||
5537 | Global Hunger Index (2021) | 2022-02-25 15:42:48 | 2022-02-25 17:00:47 | owid | 0 | Pablo Rosado 58 | 2022-02-25 17:00:47 | Hannah Ritchie 14 | 2022-02-25 17:00:47 | Pablo Rosado 58 | 0 | 0 | |||||
5527 | Methane emissions by sector (CAIT, 2021) | 2022-02-21 14:42:09 | 2022-04-11 13:54:25 | owid | 1 | Pablo Rosado 58 | 2022-04-11 13:54:25 | Edouard Mathieu 46 | 2022-04-11 13:54:25 | Pablo Rosado 58 | 0 | 1 | |||||
5526 | Nitrous oxide emissions by sector (CAIT, 2021) | 2022-02-21 14:41:55 | 2022-02-21 16:21:21 | owid | 1 | Pablo Rosado 58 | 2022-02-21 16:21:21 | Pablo Rosado 58 | 2022-02-21 16:21:21 | Pablo Rosado 58 | 0 | 1 | |||||
5525 | CO2 emissions by sector (CAIT, 2021) | 2022-02-21 14:14:56 | 2022-02-21 16:20:24 | owid | 1 | Pablo Rosado 58 | 2022-02-21 16:20:24 | Pablo Rosado 58 | 2022-02-21 16:20:24 | Pablo Rosado 58 | 0 | 1 | |||||
5524 | GHG Emissions by Country and Sector (CAIT, 2021) | 2022-02-21 14:14:26 | 2022-04-12 12:42:06 | owid | 1 | Pablo Rosado 58 | 2022-04-12 12:42:06 | Edouard Mathieu 46 | 2022-04-12 12:42:06 | Pablo Rosado 58 | 0 | 1 | |||||
5509 | Electricity mix from BP & EMBER (2022) - archive | 2022-02-10 10:37:57 | 2022-04-08 12:20:29 | owid | 0 | Pablo Rosado 58 | 2022-04-08 12:20:29 | Pablo Rosado 58 | 2022-04-08 12:20:29 | Pablo Rosado 58 | 0 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "datasets" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(512) NOT NULL , "description" TEXT NOT NULL , "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , "updatedAt" DATETIME NULL , "namespace" VARCHAR(255) NOT NULL , "isPrivate" TINYINT NOT NULL DEFAULT '0' , "createdByUserId" INTEGER NOT NULL , "metadataEditedAt" DATETIME NOT NULL , "metadataEditedByUserId" INTEGER NOT NULL , "dataEditedAt" DATETIME NOT NULL , "dataEditedByUserId" INTEGER NOT NULL , "nonRedistributable" TINYINT NOT NULL DEFAULT '0' , "isArchived" TINYINT NOT NULL DEFAULT '0' , "sourceChecksum" VARCHAR(64) NULL , "shortName" VARCHAR(255) NULL , "version" VARCHAR(255) NULL , "updatePeriodDays" INTEGER NULL, FOREIGN KEY("createdByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT, FOREIGN KEY("dataEditedByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT, FOREIGN KEY("metadataEditedByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT ); CREATE INDEX "datasets_createdByUserId" ON "datasets" ("createdByUserId"); CREATE INDEX "datasets_dataEditedByUserId" ON "datasets" ("dataEditedByUserId"); CREATE INDEX "datasets_metadataEditedByUserId" ON "datasets" ("metadataEditedByUserId"); CREATE UNIQUE INDEX "unique_short_name_version_namespace" ON "datasets" ("shortName", "version", "namespace");