Name: London Air Quality Network Camden
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

London Air Quality Network Camden

This dataset contains data captured by sensors operated by London Air. This is downloaded via their API (Application Programming Interface) and filtered to only include sensors within the London Borough of Camden.
Publisher name: London Borough of Camden
Last updated: 2022-07-01T04:04:30Z

Tables

Table 1

@ukgov.london_air_quality_network_camden1.table_1

1.12 MB
89755 rows
18 columns


CREATE TABLE table_1 (
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "site_type" VARCHAR,
  "bulletin_date" VARCHAR,
  "bulletin_date_formatted" VARCHAR,
  "no2_air_quality_band" VARCHAR,
  "no2_air_quality_index" BIGINT,
  "latest_capture" VARCHAR,
  "latest_week" VARCHAR,
  "ward_code" VARCHAR,
  "ward_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "spatial_accuracy" VARCHAR,
  "last_uploaded" VARCHAR,
  "location" VARCHAR
);