catalogue: datasets: 4 rows where licence = "https://www.opendatacommons.org/licenses/pddl/1.0/" 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

4 rows where licence = "https://www.opendatacommons.org/licenses/pddl/1.0/" 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,2r7g4	London Datastore – Greater London Authority data.london.gov.uk	2r7g4	11 11	Paddington Green Representation Hearing Documents	These documents relate to the Representation Hearing for the planning application at Paddington Green Police Station in Westminster (Borough reference 21/02193/FULL), which was held at City Hall on 17 March 2023. The decision notice and section 106 legal agreement published on 24 May 2023 are also provided.	https://data.london.gov.uk/dataset/paddington-green-representation-hearing-documents-2r7g4	Greater London Authority	https://www.opendatacommons.org/licenses/pddl/1.0/	2023-03-09T09:11:27.000Z	2023-05-25T13:31:09.000Z	[]	["Planning"]	2r7g4
data.london.gov.uk,2w1rn	London Datastore – Greater London Authority data.london.gov.uk	2w1rn	11 11	Kingston DoT		https://data.london.gov.uk/dataset/kingston-dot-2w1rn	Greater London Authority	https://www.opendatacommons.org/licenses/pddl/1.0/	2016-06-28T12:24:17.000Z	2016-07-27T15:54:22.000Z	[]	["Planning"]	2w1rn
data.london.gov.uk,e551x	London Datastore – Greater London Authority data.london.gov.uk	e551x	11 11	LFEPA Members’ gifts, hospitality and expenses	This is historic data for the Members of the former London Fire and Emergency Planning Authority (LFEPA) which was abolished on 31 March 2018. This data set is not updated. LFEPA ran the London Fire Brigade (LFB). Details of LFEPA members’ gifts and hospitality received during their time in office plus expenses claimed. Data is by financial year for previous years but by financial year quarters for the current financial year. Data is updated within a month of the quarter end. It includes LFEPA Members’ names, details of the item, and the value. In the case of gifts and hospitality the value may be an estimate and, where relevant, is indicated as such. 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. From 1 April 2008, the LFB is run by the London Fire Commissioner. Details of expenses, gifts and hospitality for senior London Fire Brigade staff can be found here.	https://data.london.gov.uk/dataset/lfepa-members-gifts-hospitality-and-expenses-e551x	London Fire Brigade	https://www.opendatacommons.org/licenses/pddl/1.0/	2017-05-10T11:35:03.000Z	2022-04-12T13:04:48.000Z	["LFB London Fire Brigade"]	["Crime and Community Safety", "Transparency"]	e551x
data.london.gov.uk,e7xdm	London Datastore – Greater London Authority data.london.gov.uk	e7xdm	11 11	Bishopsgate Goodsyard Technical Reports		https://data.london.gov.uk/dataset/bishopsgate-goodsyard-technical-reports-e7xdm	Greater London Authority	https://www.opendatacommons.org/licenses/pddl/1.0/	2016-04-05T17:15:49.000Z	2022-10-05T13:29:19.000Z	[]	["Planning"]	e7xdm

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