Table: tomba_linkedin

Get detailed information of email address from a Linkedin url.

The tomba_linkedin table requires the url field to be specified in all queries, defining the URL to lookup.

Examples

Info about an Linkedin Finder

select
  email,
  first_name,
  last_name
from
  tomba_linkedin
where
  url = 'https://www.linkedin.com/in/alex-maccaw-ab592978';

Find Enrichment Email Sources

select
  p ->> 'uri' as uri,
  p ->> 'extracted_on' as extracted_on,
  p ->> 'still_on_page' as still_on_page
from
  tomba_linkedin,
  jsonb_array_elements(sources) as p
where
  url = 'https://www.linkedin.com/in/mohamed-ben-rebia';

Schema for tomba_linkedin

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
company	text		The company of person (if found)
country	text		The Two letter country code based on location.
email	text		The email address.
first_name	text		The First name of person.
gender	text		The person gender.
last_name	text		The Last name of person.
linkedin	text		The LinkedIn handle for the person (if found).
sources	jsonb		The given email address somewhere on the web.
twitter	text		The Twitter handle for the person (if found).
url	text	=	The URL of the Linkedin. For example, `https://www.linkedin.com/in/alex-maccaw-ab592978`.
website_url	text		The Company domain.