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
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
Simple Python Library to convert JSON to XML

json2xml Simple Python Library to convert JSON to XML

Vinit Kumar 79 Nov 11, 2022
A daily updated JSON dataset of all the Open House London venues, events, and metadata

Open House London listings data All of it. Automatically scraped hourly with updates committed to git, autogenerated per-day CSV's, and autogenerated

Jonty Wareing 4 Jan 01, 2022
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
Generate code from JSON schema files

json-schema-codegen Generate code from JSON schema files. Table of contents Introduction Currently supported languages Requirements Installation Usage

Daniele Esposti 30 Dec 23, 2022
With the help of json txt you can use your txt file as a json file in a very simple way

json txt With the help of json txt you can use your txt file as a json file in a very simple way Dependencies re filemod pip install filemod Installat

Kshitij 1 Dec 14, 2022
This open source Python project allow you to create JSON data trees using Minmup.com

This open source Python project allow you to create JSON data trees using Minmup.com. I try to develop this project all the time. But feel free to use :).

Arttu Väisänen 1 Jan 30, 2022
A Cobalt Strike Scanner that retrieves detected Team Server beacons into a JSON object

melting-cobalt 👀 A tool to hunt/mine for Cobalt Strike beacons and "reduce" their beacon configuration for later indexing. Hunts can either be expans

Splunk GitHub 150 Nov 23, 2022
JSONManipulator is a Python package to retrieve, add, delete, change and store objects in JSON files.

JSONManipulator JSONManipulator is a Python package to retrieve, add, delete, change and store objects in JSON files. Installation Use the package man

Andrew Polukhin 1 Jan 07, 2022
Make JSON serialization easier

Make JSON serialization easier

4 Jun 30, 2022
Convert your JSON data to a valid Python object to allow accessing keys with the member access operator(.)

JSONObjectMapper Allows you to transform JSON data into an object whose members can be queried using the member access operator. Unlike json.dumps in

Owen Trump 4 Jul 20, 2022
JSONx - Easy JSON wrapper packed with features.

🈷️ JSONx Easy JSON wrapper packed with features. This was made for small discord bots, for big bots you should not use this JSON wrapper. 📥 Usage Cl

2 Dec 25, 2022
An tiny CLI to load data from a JSON File during development.

JSON Server - An tiny CLI to load data from a JSON File during development.

Yuvraj.M 4 Mar 22, 2022
Package to Encode/Decode some common file formats to json

ZnJSON Package to Encode/Decode some common file formats to json Available via pip install znjson In comparison to pickle this allows having readable

ZINC 2 Feb 02, 2022
Creates fake JSON files from a JSON schema

Use jsf along with fake data generators to provide consistent and meaningful fake data for your system.

Andy Challis 86 Jan 03, 2023
Roamtologseq - A script loads a json export of a Roam graph and cleans it up for import into Logseq

Roam to Logseq The script loads a json export of a Roam graph and cleans it up f

Sebastian Pech 4 Mar 07, 2022
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
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
json|dict to python object

Pyonize convert json|dict to python object Setup pip install pyonize Examples from pyonize import pyonize

bilal alpaslan 45 Nov 25, 2022
Small python wrapper around the valico rust library to provide fast JSON schema validation.

Small python wrapper around the valico rust library to provide fast JSON schema validation.

Simon J Knibbs 5 Jul 12, 2019