Land Area And Population Density, Ward And Borough
Greater London Authority
@ukgov.land_area_and_population_density_ward_and_borough
Greater London Authority
@ukgov.land_area_and_population_density_ward_and_borough
CREATE TABLE table_1 (
"code" VARCHAR,
"borough" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"population" BIGINT,
"hectares" DOUBLE,
"square_kilometres" DOUBLE,
"population_per_hectare" DOUBLE,
"population_per_square_kilometre" DOUBLE
);
CREATE TABLE table_2 (
"code" VARCHAR,
"name" VARCHAR,
"year" BIGINT,
"source" VARCHAR,
"population" BIGINT,
"inland_area_hectares" DOUBLE,
"total_area_hectares" DOUBLE,
"population_per_hectare" DOUBLE,
"square_kilometres" DOUBLE,
"population_per_square_kilometre" DOUBLE
);
Anyone who has the link will be able to view this.