Cultural Infrastructure Map 2023
Greater London Authority
@ukgov.cultural_infrastructure_map_2023_1
Greater London Authority
@ukgov.cultural_infrastructure_map_2023_1
CREATE TABLE cim_2023_archives (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_artists_workspaces (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_arts_centres (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_cinemas (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_commercial_galleries (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR
);
CREATE TABLE cim_2023_creative_coworking_desk_space (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_creative_workspaces (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_dance_performance_venues (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_dance_rehearsal_studios (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_fashion_and_design (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_jewellery_design (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_lgbt_venues (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_libraries (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_makerspaces (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_making_and_manufacturing (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_museums_and_public_galleries (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_music_recording_studios (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_music_rehearsal_studios (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_prop_and_costume_making (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_set_and_exhibition_building (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_textile_design (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_theatre (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2023_theatre_rehearsal_studios (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2024_music_all (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cim_2024_music_grassroot (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"ward_2022_name" VARCHAR,
"ward_2022_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
Anyone who has the link will be able to view this.