home / PuP_PoC_v1

building_networks

25 rows where network_id = "7.4.2"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link building network_id
100460384,7.4.2 100460384 Public Video Fitness 7.4.2
100460386,7.4.2 100460386 Public Video Fitness 7.4.2
100460387,7.4.2 100460387 Public Video Fitness 7.4.2
100466852,7.4.2 100466852 Public Video Fitness 7.4.2
ATV-241980,7.4.2 ATV-241980 Public Video Fitness 7.4.2
ATV-88380,7.4.2 ATV-88380 Public Video Fitness 7.4.2
ATV-88381,7.4.2 ATV-88381 Public Video Fitness 7.4.2
ATV-88382,7.4.2 ATV-88382 Public Video Fitness 7.4.2
ATV-88383,7.4.2 ATV-88383 Public Video Fitness 7.4.2
DMI_AT_00087,7.4.2 DMI_AT_00087 Public Video Fitness 7.4.2
DMI_AT_00088,7.4.2 DMI_AT_00088 Public Video Fitness 7.4.2
DMI_AT_00338,7.4.2 DMI_AT_00338 Public Video Fitness 7.4.2
DMI_AT_00339,7.4.2 DMI_AT_00339 Public Video Fitness 7.4.2
DMI_AT_00776,7.4.2 DMI_AT_00776 Public Video Fitness 7.4.2
DMI_AT_00977,7.4.2 DMI_AT_00977 Public Video Fitness 7.4.2
DMI_AT_01049,7.4.2 DMI_AT_01049 Public Video Fitness 7.4.2
RSG-HH001,7.4.2 RSG-HH001 Public Video Fitness 7.4.2
RSG-HH002,7.4.2 RSG-HH002 Public Video Fitness 7.4.2
RSG-HH003,7.4.2 RSG-HH003 Public Video Fitness 7.4.2
RSG-HH004,7.4.2 RSG-HH004 Public Video Fitness 7.4.2
RSG-HH005,7.4.2 RSG-HH005 Public Video Fitness 7.4.2
RSG-HH006,7.4.2 RSG-HH006 Public Video Fitness 7.4.2
RSG-HH007,7.4.2 RSG-HH007 Public Video Fitness 7.4.2
RSG-HH008,7.4.2 RSG-HH008 Public Video Fitness 7.4.2
RSG-HH010,7.4.2 RSG-HH010 Public Video Fitness 7.4.2

Advanced export

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

CSV options:

CREATE TABLE building_networks (
	building VARCHAR(100) NOT NULL, 
	network_id VARCHAR(100) NOT NULL, 
	PRIMARY KEY (building, network_id), 
	FOREIGN KEY(building) REFERENCES building (id), 
	FOREIGN KEY(network_id) REFERENCES network (id)
);
Powered by Datasette · Queries took 6.895ms