A daily updated JSON dataset of all the Open House London venues, events, and metadata

Overview

Open House London listings data

All of it. Automatically scraped hourly with updates committed to git, autogenerated per-day CSV's, and autogenerated per-day maps.

Things you can use

Things to note:

  • This attempts to detect if events are ticketed, both on an event (ticketed) and a listing (ticketed_events) basis
  • Some venues have no events and are open all week, see the all_week field
  • Some events run all day, and have 00:00-23:59 as times for convenience, but also an all_day field
  • fully_booked will be null on events where bookings are handled by an external website such as eventbrite
  • Data not included in the listing will either be [], or null
  • JSON filenames are the OH ID's of venues that persist between events

Example JSON file

{
    "all_week": false,
    "description": "Cullinan Studio converted this Victorian warehouse into their low-energy office in 2012, retaining 80% of the existing building fabric. The Foundry co-working hub is now home to several organisations working in the built environment.",
    "design": {
        "designers": [
            {
                "architect": "Cullinan Studio",
                "description": "Original design",
                "year": "2012"
            }
        ],
        "periods": [
            "Historical/contemporary"
        ],
        "types": [
            "Walk/tour",
            "Offices",
            "Architectural practice"
        ]
    },
    "events": [
        {
            "all_day": false,
            "booking_link": "https://openhouselondon.open-city.org.uk//events/11019/bookings",
            "capacity": 40,
            "date": "2021-09-10",
            "end": "2021-09-10T17:00:00+01:00",
            "fully_booked": false,
            "name": "Open Studio: 4pm - 5pm slot",
            "notes": null,
            "start": "2021-09-10T16:00:00+01:00",
            "ticketed": true
        }
    ],
    "facilities": [
        [
            "Family activities during open house festival",
            "Refreshments",
            "Toilets",
            "Architect on site",
            "Disabled access"
        ]
    ],
    "factsheet": [
        {
            "heading": "New from old",
            "paragraphs": [
                "This Victorian canal-side warehouse was originally a foundry. In the 20th century it was used as a greetings card warehouse and then artists' studios. The warehouse is now home to architects Cullinan Studio, who completed an extensive retrofit of the building into their new offices in 2012. This beautiful and efficient workplace proves that retrofit can be as inspiring as new-build. Cullinan Studio is using their first-hand experience as client, designer and end-user of the building to observe how users interact with the space after handover, and putting that knowledge to good use in future projects."
            ]
        },
        {
            "heading": "Sustainability",
            "paragraphs": [
                "The BREEAM ‘Excellent’ studios are naturally ventilated. Under-floor heating is provided through an air-source heat pump. Using a fabric-first approach, the listed south wall’s insulation has been upgraded to a u-value of 0.1W/sqm/K by using recycled newspaper (Warmcell). The north wall has insulation of up to 380mm thick over the existing rendered façade providing a u-value of 0.08W/sqm/K. PV panels on the south slopes of the roof generate electricity. A Building Management System (BMS) enables us to monitor energy performance and space temperatures."
            ]
        },
    ],
    "id": 7448,
    "images": [
        {
            "description": "Simon Warren · 2014",
            "title": "Cullinan Studio Office adjacent Regents Canal",
            "url": "https://d25hwkr75zzfa.cloudfront.net/store/photo/large/building_7448_cullinanstudioofficeonregentscanal_-simonwarren_a3379b995b46570575a938e095b7bded.jpg"
        },
        {
            "description": "Tim Soar · 2012",
            "title": "An inserted steel frame works with the existing 19th century frame and masonry to support the listed south wall",
            "url": "https://d25hwkr75zzfa.cloudfront.net/store/photo/large/building_7448_cullinanstudiooffice_lowergrdflr_-timsoar_2b363e716ca9d7fbe4407dc6fb153127.jpg"
        },
    ],
    "links": [],
    "location": {
        "address": "Foundry, 5 Baldwin Terrace, N1 7RU",
        "latitude": 51.5332855,
        "longitude": -0.09617,
        "meeting_point": null,
        "travel_info": [
            "Nearest tube: Angel",
            "Nearest train: Essex Road, Old Street",
            "Bus routes: 4, 19, 341, 141, 73, 205, 271"
        ]
    },
    "name": "Foundry Co-Working Hub",
    "original_url": "https://openhouselondon.open-city.org.uk/listings/7448",
    "ticketed_events": true
}

Todo

  • Download and store images, referring to them by filename rather than absolute path
  • Auto-updated Google Sheet w/tabs
  • Autogenerated datasette DB
  • Delete venues that are no longer listed so git history is accurate
  • Dig up all the previous years data and import as much as possible in the same format
A JSON utility library for Python featuring Django-style queries and mutations.

JSON Enhanced JSON Enhanced implements fast and pythonic queries and mutations for JSON objects. Installation You can install json-enhanced with pip:

Collisio Technologies 4 Aug 22, 2022
No more boilerplate to check and build a Python object from JSON.

JSONloader This module is for you if you're tired of writing boilerplate that: builds a straightforward Python object from loaded JSON. checks that yo

3 Feb 05, 2022
Convert your subscriptions csv file into a valid json for Newpipe!

Newpipe-CSV-Fixer Convert your Google subscriptions CSV file into a valid JSON for Newpipe! Thanks to nikcorg for sharing how to convert the CSV into

Juanjo 44 Dec 29, 2022
simdjson : Parsing gigabytes of JSON per second

JSON is everywhere on the Internet. Servers spend a *lot* of time parsing it. We need a fresh approach. The simdjson library uses commonly available SIMD instructions and microparallel algorithms to

16.3k Dec 29, 2022
import json files directly in your python scripts

Install Install from git repository pip install git+https://github.com/zaghaghi/direct-json-import.git Use With the following json in a file named inf

Hamed Zaghaghi 51 Dec 01, 2021
JSON Schema validation library

jsonschema A JSON Schema validator implementation. It compiles schema into a validation tree to have validation as fast as possible. Supported drafts:

Dmitry Dygalo 309 Jan 01, 2023
Make JSON serialization easier

Make JSON serialization easier

4 Jun 30, 2022
A tools to find the path of a specific key in deep nested JSON.

如何快速从深层嵌套 JSON 中找到特定的 Key #公众号 在爬虫开发的过程中,我们经常遇到一些 Ajax 加载的接口会返回 JSON 数据。

kingname 56 Dec 13, 2022
cysimdjson - Very fast Python JSON parsing library

Fast JSON parsing library for Python, 7-12 times faster than standard Python JSON parser.

TeskaLabs 235 Dec 29, 2022
Define your JSON schema as Python dataclasses

Define your JSON schema as Python dataclasses

62 Sep 20, 2022
jq for Python programmers Process JSON and HTML on the command-line with familiar syntax.

jq for Python programmers Process JSON and HTML on the command-line with familiar syntax.

Denis Volk 3 Jan 09, 2022
Random JSON Key:Pair Json Generator

Random JSON Key:Value Pair Generator This simple script take an engish dictionary of words and and makes random key value pairs. The dictionary has ap

Chris Edwards 1 Oct 14, 2021
Low code JSON to extract data in one line

JSON Inline Low code JSON to extract data in one line ENG RU Installation pip install json-inline Usage Rules Modificator Description ?key:value Searc

Aleksandr Sokolov 12 Mar 09, 2022
A query expression for extracting data from JSON.

JSONPATH A selector expression for extracting data from JSON. Quickstarts Installation Install the stable version from PYPI. pip install jsonpath-extr

林玮 (Jade Lin) 33 Oct 22, 2022
A python library to convert arbitrary strings representing business opening hours into a JSON format that's easier to use in code

A python library to convert arbitrary strings representing business opening hours into a JSON format that's easier to use in code

Adrian Edwards 9 Dec 02, 2022
A fast streaming JSON parser for Python that generates SAX-like events using yajl

json-streamer jsonstreamer provides a SAX-like push parser via the JSONStreamer class and a 'object' parser via the ObjectStreamer class which emits t

Kashif Razzaqui 196 Dec 15, 2022
The ldap2json script allows you to extract the whole LDAP content of a Windows domain into a JSON file.

ldap2json The ldap2json script allows you to extract the whole LDAP content of a Windows domain into a JSON file. Features Authenticate with password

Podalirius 68 Dec 07, 2022
Atom, RSS and JSON feed parser for Python 3

Atoma Atom, RSS and JSON feed parser for Python 3. Quickstart Install Atoma with pip: pip install atoma

Nicolas Le Manchet 95 Nov 28, 2022
Simple, minimal conversion of Bus Open Data Service SIRI-VM data to JSON

Simple, minimal conversion of Bus Open Data Service SIRI-VM data to JSON

Andy Middleton 0 Jan 22, 2022
Convert Wii UI formats to JSON5 and vice versa

Convert Wii UI formats to JSON5 and vice versa

Pablo Stebler 11 Aug 28, 2022