Cities
Urban Statistics and Key Metrics
@datacommons.cities
Urban Statistics and Key Metrics
@datacommons.cities
This dataset includes key statistical variables for worldwide cities, providing data on population, infrastructure, economy, and urban development.
CREATE TABLE ash_township_geoid_2902116 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE ash_township_geoid_4602500 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE ash_township_geoid_4602520 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE ash_valley_township_geoid_2002825 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE ashville_geoid_0102908 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE ashville_geoid_3602825 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE ashville_geoid_3902680 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE ashville_geoid_4203296 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE ashwaubenon_geoid_5503425 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE ashwood_geoid_4503115 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE asiegu_wikidataid_q24942088 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" BIGINT,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE asientos_wikidataid_q2360416 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE asino_wikidataid_q104111 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE asipovichy_wikidataid_q742161 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE asir_wikidataid_q4359029 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE askern_wikidataid_q2555402 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE askewville_geoid_3702320 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE askham_wikidataid_q14080276 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE askov_geoid_2702548 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE askov_wikidataid_q2146889 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE aslan_duz_wikidataid_q4358220 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE asmara_wikidataid_q3642 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE asnawar_wikidataid_q39050839 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" BIGINT,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE asni_res_sur_seine_wikidataid_q191415 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);CREATE TABLE asn_s_wikidataid_q2019461 (
"place_id" VARCHAR,
"place_name" VARCHAR,
"parent_place_id" VARCHAR,
"parent_place_name" VARCHAR,
"variable" VARCHAR,
"date" VARCHAR,
"value" DOUBLE,
"measurement_method" VARCHAR,
"observation_period" VARCHAR,
"import_name" VARCHAR,
"provenance_domain" VARCHAR,
"datacommons_url" VARCHAR
);Anyone who has the link will be able to view this.