catalogue: datasets: 5 rows where licence = "https://www.opendatacommons.org/licenses/odbl/1.0/index.html" and portal

The datasets each portal's latest successful harvest found. landing_page is the publisher's page for the dataset; where a catalogue gives none, uri often is.

Data license: CC BY 4.0 (portal directory, derived from Dateno); dataset metadata as each portal publishes it · Data source: Dateno, DataPortals.org, data.europa.eu, opendatArchives, and each portal's DCAT catalogue

key: What identifies the dataset in its portal
landing_page: The publisher's page for the dataset
keywords: JSON list
themes: JSON list of theme IRIs

5 rows where licence = "https://www.opendatacommons.org/licenses/odbl/1.0/index.html" and portal_id = "data.london.gov.uk"

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	portal_id	key	harvest_id	title	description	landing_page	publisher	licence	issued	modified	keywords	themes	identifier
data.london.gov.uk,2ko1x	London Datastore – Greater London Authority data.london.gov.uk	2ko1x	11 11	London Fire Brigade - fleet list	The London Fire Brigade operates a large number of emergency (operational) and non-operational vehicles. There are regular Freedom of Information requests asking for the details of these vehicles and this list is published to largely meet that need. It will be updated annually; usually in the last quarter of the calendar year. From 2020, the list also includes details of appliances removed from service during the year and new appliances coming into service. The London Fire Commissioner is the fire and rescue authority for London, and runs the London Fire Brigade. The format of the fleet list changed in October 2019 (i.e. vehicle registration numbers and vehicle locations removed). This change reflects national security considerations; the format of the list reflects a similar list published by the Metropolitan Police Service (MPS). Data for earlier years has been removed..	https://data.london.gov.uk/dataset/london-fire-brigade-fleet-list-2ko1x	London Fire Brigade	https://www.opendatacommons.org/licenses/odbl/1.0/index.html	2016-09-08T10:46:06.000Z	2026-11-04T10:42:19.863Z	["LFB London Fire Brigade", "appliances"]	["Crime and Community Safety", "Transparency"]	2ko1x
data.london.gov.uk,2oz65	London Datastore – Greater London Authority data.london.gov.uk	2oz65	11 11	Ealing residential pipeline	The residential pipeline for the London Borough of Ealing as at 31st March 20222. The data was extracted from the Planning London Datahub on 29/11/2022 and is subject to further checking.	https://data.london.gov.uk/dataset/ealing-residential-pipeline-2oz65	Greater London Authority	https://www.opendatacommons.org/licenses/odbl/1.0/index.html	2022-11-29T10:55:33.000Z	2022-11-29T10:57:45.000Z	[]	["Housing", "Planning"]	2oz65
data.london.gov.uk,e5637	London Datastore – Greater London Authority data.london.gov.uk	e5637	11 11	Residential approvals of M4(2) Accessible and adaptable and M4(3) Wheelchair user dwellings	This report uses data from the Planning London Datahub (PLD) to show the proportion of new-build residential dwellings that meet the access standards M4(2) Accessible and adaptable dwellings and M4(3) Wheelchair user dwellings, as set out in Part M of the Building Regulations, Access to and use of buildings. The data is broken down by borough and year. Information on individual applications can be found on the Planning London Datahub, or on our Residential Approvals dashboard. Completions can be viewed at Residential Completions dashboard Please note that compliance with part M of the building regulations is not confirmed at application stage, but must be included as a condition on the decision notice when planning permission is granted. We are currently working with London's planning authorities to ensure that the PLD is being correctly updated with the M4 compliance information at the time the decision is issued. The data is therefore currently assumed to under represent the true picture. The dashboard will automatically update as more data becomes available.	https://data.london.gov.uk/dataset/residential-approvals-of-m42-accessible-and-adaptable-and-m43-wh-e5637	Greater London Authority	https://www.opendatacommons.org/licenses/odbl/1.0/index.html	2022-01-18T10:52:32.000Z	2023-02-01T14:01:49.000Z	[]	["Housing", "Planning"]	e5637
data.london.gov.uk,e6ypp	London Datastore – Greater London Authority data.london.gov.uk	e6ypp	11 11	London Fire Brigade senior staff - gifts and hospitality register and expenses claimed	Details of senior London Fire Brigade staff expenses claims and register of gifts and hospitality. Please note that postholders in the office shown in the data (e.g. Commissioner, Director) will change over time. It should not be assumed that historic data relates to current postholders; details of current postholders in the LFB top management structure are available here on the LFB website. Senior staff are defined as those designated as a ‘head of service’ (assistant directors and assistant commissioners), plus Directors/Deputy Commissioners and the London Fire Commissioner. Data is by financial year. Data is updated within a month of the quarter end. It is possible that items may be included in a subsequent financial year where the notification has been made close to the end of a previous financial year. Sometimes an expense claim may relate to an event or travel where a sponsor has agreed to reimburse the LFB's costs. In such cases, there will be a corresponding entry in the register of gifts and hospitality. London Fire Commissioner (LFC) is the fire and rescue authority for London from 1 April 2018, and runs the London Fire Brigade. NOTE: For transparency purposes, we publish staff expense and hospitality data covering the past three financial years (plus the current financial year). Records are held internally for a longer period, in line with financial and legal retention obligations. Senior Officer expenses: Data is published quarterly after end June, September, December and March for the current year; then republished as an annual data set after the year end. Gifts and hospitality: Published as an annual data set after the year end.	https://data.london.gov.uk/dataset/london-fire-brigade-senior-staff-gifts-and-hospitality-register--e6ypp	London Fire Brigade	https://www.opendatacommons.org/licenses/odbl/1.0/index.html	2020-02-25T11:29:06.000Z	2026-02-05T15:22:27.234Z	["London Fire Brigade", "expenses", "finance", "gifts", "hospitality", "london fire commissioner"]	["Crime and Community Safety", "Transparency"]	e6ypp
data.london.gov.uk,vdj65	London Datastore – Greater London Authority data.london.gov.uk	vdj65	11 11	MCIL 2 charging area boundaries	This page contains the spatial boundaries from the Mayor's Community Infrastructure Levy 2019 (known as MCIL 2), which replaces MCIL 1 on 1st April 2019. The following can be downloaded:: Image files of Central London and Isle of Dogs charging areas and the MCIL 2 charging bands MCIL 2 Central London charging area shape file for use in ArcMap or other GIS software MCIL 2 Isle of Dogs charging area shape file for use in ArcMap or other GIS software	https://data.london.gov.uk/dataset/mcil-2-charging-area-boundaries-vdj65	Greater London Authority	https://www.opendatacommons.org/licenses/odbl/1.0/index.html	2019-03-12T12:28:24.000Z	2019-03-12T12:41:23.000Z	["MCIL2", "mcil", "planning"]	["Planning"]	vdj65

Advanced export

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

CREATE TABLE datasets (
    portal_id TEXT NOT NULL REFERENCES portals(id),
    key TEXT NOT NULL,
    harvest_id INTEGER NOT NULL REFERENCES harvests(id),
    title TEXT,
    description TEXT,
    landing_page TEXT,
    publisher TEXT,
    licence TEXT,
    issued TEXT,
    modified TEXT,
    keywords TEXT NOT NULL,
    themes TEXT NOT NULL,
    uri TEXT,
    identifier TEXT,
    PRIMARY KEY (portal_id, key)
);