LinkedIn Company Pages

Explore the interactive ERD

Table & Field Reference

time_bound_follower_statistic

Column	Type	Keys
`_fivetran_id`	String	PK
`day`	Instant	PK
`follower_gains_organic_follower_gain`	Int
`follower_gains_paid_follower_gain`	Int
`organization_entity`	String

comment_history

Column	Type	Keys
`id`	Long	PK
`last_modified_time`	Instant	PK
`actor`	String
`agent`	String
`content`	Json
`created_actor`	String
`created_time`	Instant
`last_modified_actor`	String
`message_text`	String
`object`	String
`urn`	String

post_multi_image

Column	Type	Keys
`id`	String	PK
`_fivetran_id`	String	PKFK
`alt_text`	String
`title`	String

post_distribution_target_seniorities

Column	Type	Keys
`last_modified_time`	Instant	PKFK
`post_id`	String	PKFK
`seniority_id`	Long	PKFK

organization_localized_specialties

Column	Type	Keys
`organization_id`	Long	PKFK
`specialty`	String

ugc_post_history

Column	Type	Keys
`id`	String	PK
`last_modified_time`	Instant	PK
`author`	String
`commentary`	String
`container_entity`	String
`content_call_to_action_label`	String
`content_landing_page`	String
`created_time`	Instant
`distribution_external_distribution_channels`	Json
`distribution_feed_distribution`	String
`first_published_at`	Instant
`is_reshare_disabled_by_author`	Boolean
`lifecycle_state`	String
`lifecycle_state_info_content_status`	String
`lifecycle_state_info_is_edited_by_author`	Boolean
`lifecycle_state_info_review_status`	String
`response_context_parent`	String
`response_context_root`	String
`visibility`	String
`ad_context_`

time_bound_video_analytics

Column	Type	Keys
`_fivetran_id`	String	PK
`day`	Instant	PK
`entity`	String	FK
`statistics_type`	String
`value`	Long

share_history

Column	Type	Keys
`id`	Long	PK
`last_modified_time`	Instant	PK
`author`	String
`commentary`	String
`container_entity`	String
`content_call_to_action_label`	String
`content_landing_page`	String
`created_time`	Instant
`distribution_external_distribution_channels`	Json
`distribution_feed_distribution`	String
`first_published_at`	Instant
`is_reshare_disabled_by_author`	Boolean
`lifecycle_state`	String
`lifecycle_state_info_content_status`	String
`lifecycle_state_info_is_edited_by_author`	Boolean
`lifecycle_state_info_review_status`	String
`response_context_parent`	String
`response_context_root`	String
`visibility`	String
`ad_context_`

followers_by_seniority

Column	Type	Keys
`_fivetran_id`	String	PK
`seniority_id`	Long	FK
`_organization_entity_urn`	String
`follower_counts_organic_follower_count`	Int
`follower_counts_paid_follower_count`	Int

share_statistic

Column	Type	Keys
`_fivetran_id`	String	PK
`_organization_entity_urn`	String
`_share_entity_urn`	String
`click_count`	Int
`comment_count`	Int
`engagement`	Double
`impression_count`	Int
`like_count`	Int
`share_count`	Int

page_statistic_by_geo_country

Column	Type	Keys
`_fivetran_id`	String	PK
`geo_id`	String	FK
`_organization_entity_urn`	String
`about_page_views`	Int
`all_desktop_page_views`	Int
`all_mobile_page_views`	Int
`all_page_views`	Int
`careers_page_views`	Int
`desktop_about_page_views`	Int
`desktop_careers_page_views`	Int
`desktop_insights_page_views`	Int
`desktop_jobs_page_views`	Int
`desktop_life_at_page_views`	Int
`desktop_overview_page_views`	Int
`desktop_people_page_views`	Int
`desktop_products_page_views`	Int
`insights_page_views`	Int
`jobs_page_views`	Int
`life_at_page_views`	Int
`mobile_about_page_views`	Int
`mobile_careers_page_views`	Int
`mobile_insights_page_views`	Int
`mobile_jobs_page_views`	Int
`mobile_life_at_page_views`	Int
`mobile_overview_page_views`	Int
`mobile_people_page_views`	Int
`mobile_products_page_views`	Int
`overview_page_views`	Int
`people_page_views`	Int
`products_page_views`	Int

organization_groups

Column	Type	Keys
`organization_id`	Long	PKFK
`group_urn`	String

organization_alternative_names

Column	Type	Keys
`organization_id`	Long	PKFK
`locale_country`	String
`locale_language`	String
`name`	String

page_statistic_by_geo

Column	Type	Keys
`_fivetran_id`	String	PK
`geo_id`	String	FK
`_organization_entity_urn`	String
`about_page_views`	Int
`all_desktop_page_views`	Int
`all_mobile_page_views`	Int
`all_page_views`	Int
`careers_page_views`	Int
`desktop_about_page_views`	Int
`desktop_careers_page_views`	Int
`desktop_insights_page_views`	Int
`desktop_jobs_page_views`	Int
`desktop_life_at_page_views`	Int
`desktop_overview_page_views`	Int
`desktop_people_page_views`	Int
`desktop_products_page_views`	Int
`insights_page_views`	Int
`jobs_page_views`	Int
`life_at_page_views`	Int
`mobile_about_page_views`	Int
`mobile_careers_page_views`	Int
`mobile_insights_page_views`	Int
`mobile_jobs_page_views`	Int
`mobile_life_at_page_views`	Int
`mobile_overview_page_views`	Int
`mobile_people_page_views`	Int
`mobile_products_page_views`	Int
`overview_page_views`	Int
`people_page_views`	Int
`products_page_views`	Int

time_bound_share_statistic

Column	Type	Keys
`_fivetran_id`	String	PK
`day`	Instant	PK
`click_count`	Int
`comment_count`	Int
`comment_mentions_count`	Int
`engagement`	Double
`impression_count`	Int
`like_count`	Int
`organization_entity`	String
`share_count`	Int
`share_mentions_count`	Int
`unique_impressions_count`	Int

share_carousel_card

Column	Type	Keys
`media_id`	String	PK
`_fivetran_id`	String	PKFK
`landing_page`	String
`media_alt_text`	String
`media_title`	String

share_distribution_target_locations

Column	Type	Keys
`location`	String	PK
`last_modified_time`	Instant	PKFK
`share_id`	Long	PKFK

followers_by_region

Column	Type	Keys
`_fivetran_id`	String	PK
`region_id`	Long	FK
`_organization_entity_urn`	String
`follower_counts_organic_follower_count`	Int
`follower_counts_paid_follower_count`	Int

followers_by_geo_country

Column	Type	Keys
`_fivetran_id`	String	PK
`geo`	String	FK
`_organization_entity_urn`	String
`follower_counts_organic_follower_count`	Int
`follower_counts_paid_follower_count`	Int

post_distribution_target_interface_locales

Column	Type	Keys
`last_modified_time`	Instant	PKFK
`post_id`	String	PKFK
`country`	String
`language`	String

post_content

Column	Type	Keys
`_fivetran_id`	String	PK
`post_id`	String	PKFK
`carousel_id`	Long
`media_alt_text`	String
`media_id`	String
`media_title`	String
`multi_image_alt_text`	String
`poll_question`	String
`poll_settings_duration`	String
`poll_settings_is_voter_visible_to_author`	Boolean
`poll_settings_vote_selection_type`	String
`poll_unique_voters_count`	Long
`reference_id`	String
`type`	String
`article_`

followers_by_association_type

Column	Type	Keys
`_fivetran_id`	String	PK
`_organization_entity_urn`	String
`association_type`	String
`follower_counts_organic_follower_count`	Int
`follower_counts_paid_follower_count`	Int

followers_by_staff_count_range

Column	Type	Keys
`_fivetran_id`	String	PK
`_organization_entity_urn`	String
`follower_counts_organic_follower_count`	Int
`follower_counts_paid_follower_count`	Int
`staff_count_range`	String

organization_industries

Column	Type	Keys
`industry_id`	Long	PKFK
`organization_id`	Long	PKFK

function

Column	Type	Keys
`id`	Long	PK
`name`	String

share_content_poll_option

Column	Type	Keys
`text`	String	PK
`_fivetran_id`	String	PKFK
`is_voted_by_viewer`	Boolean
`vote_count`	Long

followers_by_country

Column	Type	Keys
`_fivetran_id`	String	PK
`country_id`	String	FK
`_organization_entity_urn`	String
`follower_counts_organic_follower_count`	Int
`follower_counts_paid_follower_count`	Int

page_statistic_by_country

Column	Type	Keys
`_fivetran_id`	String	PK
`country_id`	String	FK
`_organization_entity_urn`	String
`about_page_views`	Int
`all_desktop_page_views`	Int
`all_mobile_page_views`	Int
`all_page_views`	Int
`careers_page_views`	Int
`desktop_about_page_views`	Int
`desktop_careers_page_views`	Int
`desktop_insights_page_views`	Int
`desktop_jobs_page_views`	Int
`desktop_life_at_page_views`	Int
`desktop_overview_page_views`	Int
`desktop_people_page_views`	Int
`desktop_products_page_views`	Int
`insights_page_views`	Int
`jobs_page_views`	Int
`life_at_page_views`	Int
`mobile_about_page_views`	Int
`mobile_careers_page_views`	Int
`mobile_insights_page_views`	Int
`mobile_jobs_page_views`	Int
`mobile_life_at_page_views`	Int
`mobile_overview_page_views`	Int
`mobile_people_page_views`	Int
`mobile_products_page_views`	Int
`overview_page_views`	Int
`people_page_views`	Int
`products_page_views`	Int

total_share_statistic

Column	Type	Keys
`_fivetran_id`	String	PK
`_organization_entity_urn`	String
`click_count`	Int
`comment_count`	Int
`comment_mentions_count`	Int
`engagement`	Double
`impression_count`	Int
`like_count`	Int
`share_count`	Int
`share_mentions_count`	Int
`unique_impressions_count`	Int

geo

Column	Type	Keys
`id`	Long	PK
`value`	String

post_carousel_card

Column	Type	Keys
`media_id`	String	PK
`_fivetran_id`	String	PKFK
`landing_page`	String
`media_alt_text`	String
`media_title`	String

time_bound_page_statistic

Column	Type	Keys
`_fivetran_id`	String	PK
`day`	Instant	PK
`about_page_views`	Int
`about_unique_page_views`	Int
`all_desktop_page_views`	Int
`all_desktop_unique_page_views`	Int
`all_mobile_page_views`	Int
`all_mobile_unique_page_views`	Int
`all_page_views`	Int
`all_unique_page_views`	Int
`careers_page_banner_promo_clicks`	Int
`careers_page_employees_clicks`	Int
`careers_page_jobs_clicks`	Int
`careers_page_promo_links_clicks`	Int
`careers_page_views`	Int
`careers_unique_page_views`	Int
`desktop_about_page_views`	Int
`desktop_about_unique_page_views`	Int
`desktop_careers_page_views`	Int
`desktop_careers_unique_page_views`	Int
`desktop_insights_page_views`	Int
`desktop_insights_unique_page_views`	Int
`desktop_jobs_page_views`	Int
`desktop_jobs_unique_page_views`	Int
`desktop_life_at_page_views`	Int
`desktop_life_at_unique_page_views`	Int
`desktop_overview_page_views`	Int
`desktop_overview_unique_page_views`	Int
`desktop_people_page_views`	Int
`desktop_people_unique_page_views`	Int
`desktop_products_page_views`	Int
`desktop_products_unique_page_views`	Int
`insights_page_views`	Int
`insights_unique_page_views`	Int
`jobs_page_views`	Int
`jobs_unique_page_views`	Int
`life_at_page_views`	Int
`life_at_unique_page_views`	Int
`mobile_about_page_views`	Int
`mobile_about_unique_page_views`	Int
`mobile_careers_page_employees_clicks`	Int
`mobile_careers_page_jobs_clicks`	Int
`mobile_careers_page_promo_links_clicks`	Int
`mobile_careers_page_views`	Int
`mobile_careers_unique_page_views`	Int
`mobile_insights_page_views`	Int
`mobile_insights_unique_page_views`	Int
`mobile_jobs_page_views`	Int
`mobile_jobs_unique_page_views`	Int
`mobile_life_at_page_views`	Int
`mobile_life_at_unique_page_views`	Int
`mobile_overview_page_views`	Int
`mobile_overview_unique_page_views`	Int
`mobile_people_page_views`	Int
`mobile_people_unique_page_views`	Int
`mobile_products_page_views`	Int
`mobile_products_unique_page_views`	Int
`organization_entity`	String
`overview_page_views`	Int
`overview_unique_page_views`	Int
`people_page_views`	Int
`people_unique_page_views`	Int
`products_page_views`	Int
`products_unique_page_views`	Int

brand_localized_specialties

Column	Type	Keys
`brand_id`	Long	PKFK
`specialty`	String

social_metadata_summary

Column	Type	Keys
`_fivetran_id`	String	PK
`comment_summary_count`	Int
`comment_summary_top_level_count`	Int
`comments_state`	String
`entity`	String
`reaction_appreciation_count`	Int
`reaction_appreciation_reaction_type`	String
`reaction_celebration_count`	Int
`reaction_celebration_reaction_type`	String
`reaction_empathy_count`	Int
`reaction_empathy_reaction_type`	String
`reaction_interest_count`	Int
`reaction_interest_reaction_type`	String
`reaction_like_count`	Int
`reaction_like_reaction_type`	String
`reaction_maybe_count`	Int
`reaction_maybe_reaction_type`	String
`reaction_praise_count`	Int
`reaction_praise_reaction_type`	String

total_page_statistic

Column	Type	Keys
`_fivetran_id`	String	PK
`_organization_entity_urn`	String
`about_page_views`	Int
`all_desktop_page_views`	Int
`all_mobile_page_views`	Int
`all_page_views`	Int
`careers_page_banner_promo_clicks`	Int
`careers_page_employees_clicks`	Int
`careers_page_jobs_clicks`	Int
`careers_page_promo_links_clicks`	Int
`careers_page_views`	Int
`desktop_about_page_views`	Int
`desktop_careers_page_views`	Int
`desktop_insights_page_views`	Int
`desktop_jobs_page_views`	Int
`desktop_life_at_page_views`	Int
`desktop_overview_page_views`	Int
`desktop_people_page_views`	Int
`desktop_products_page_views`	Int
`insights_page_views`	Int
`jobs_page_views`	Int
`life_at_page_views`	Int
`mobile_about_page_views`	Int
`mobile_careers_page_employees_clicks`	Int
`mobile_careers_page_jobs_clicks`	Int
`mobile_careers_page_promo_links_clicks`	Int
`mobile_careers_page_views`	Int
`mobile_insights_page_views`	Int
`mobile_jobs_page_views`	Int
`mobile_life_at_page_views`	Int
`mobile_overview_page_views`	Int
`mobile_people_page_views`	Int
`mobile_products_page_views`	Int
`overview_page_views`	Int
`people_page_views`	Int
`products_page_views`	Int

post_content_poll_option

Column	Type	Keys
`text`	String	PK
`_fivetran_id`	String	PKFK
`is_voted_by_viewer`	Boolean
`vote_count`	Long

followers_by_industry

Column	Type	Keys
`_fivetran_id`	String	PK
`industry_id`	Long	FK
`_organization_entity_urn`	String
`follower_counts_organic_follower_count`	Int
`follower_counts_paid_follower_count`	Int

post_distribution_target_job_functions

Column	Type	Keys
`function_id`	Long	PKFK
`last_modified_time`	Instant	PKFK
`post_id`	String	PKFK

brand_industries

Column	Type	Keys
`brand_id`	Long	PKFK
`industry_id`	Long	PKFK

country

Column	Type	Keys
`id`	String	PK
`country_group`	String
`name`	String

page_statistic_by_seniority

Column	Type	Keys
`_fivetran_id`	String	PK
`seniority_id`	Long	FK
`_organization_entity_urn`	String
`about_page_views`	Int
`all_desktop_page_views`	Int
`all_mobile_page_views`	Int
`all_page_views`	Int
`careers_page_views`	Int
`desktop_about_page_views`	Int
`desktop_careers_page_views`	Int
`desktop_insights_page_views`	Int
`desktop_jobs_page_views`	Int
`desktop_life_at_page_views`	Int
`desktop_overview_page_views`	Int
`desktop_people_page_views`	Int
`desktop_products_page_views`	Int
`insights_page_views`	Int
`jobs_page_views`	Int
`life_at_page_views`	Int
`mobile_about_page_views`	Int
`mobile_careers_page_views`	Int
`mobile_insights_page_views`	Int
`mobile_jobs_page_views`	Int
`mobile_life_at_page_views`	Int
`mobile_overview_page_views`	Int
`mobile_people_page_views`	Int
`mobile_products_page_views`	Int
`overview_page_views`	Int
`people_page_views`	Int
`products_page_views`	Int

post_distribution_target_industries

Column	Type	Keys
`industry_id`	Long	PKFK
`last_modified_time`	Instant	PKFK
`post_id`	String	PKFK

page_statistic_by_region

Column	Type	Keys
`_fivetran_id`	String	PK
`region_id`	Long	FK
`_organization_entity_urn`	String
`about_page_views`	Int
`all_desktop_page_views`	Int
`all_mobile_page_views`	Int
`all_page_views`	Int
`careers_page_views`	Int
`desktop_about_page_views`	Int
`desktop_careers_page_views`	Int
`desktop_insights_page_views`	Int
`desktop_jobs_page_views`	Int
`desktop_life_at_page_views`	Int
`desktop_overview_page_views`	Int
`desktop_people_page_views`	Int
`desktop_products_page_views`	Int
`insights_page_views`	Int
`jobs_page_views`	Int
`life_at_page_views`	Int
`mobile_about_page_views`	Int
`mobile_careers_page_views`	Int
`mobile_insights_page_views`	Int
`mobile_jobs_page_views`	Int
`mobile_life_at_page_views`	Int
`mobile_overview_page_views`	Int
`mobile_people_page_views`	Int
`mobile_products_page_views`	Int
`overview_page_views`	Int
`people_page_views`	Int
`products_page_views`	Int

page_statistic_by_industry

Column	Type	Keys
`_fivetran_id`	String	PK
`industry_id`	Long	FK
`_organization_entity_urn`	String
`about_page_views`	Int
`all_desktop_page_views`	Int
`all_mobile_page_views`	Int
`all_page_views`	Int
`careers_page_views`	Int
`desktop_about_page_views`	Int
`desktop_careers_page_views`	Int
`desktop_insights_page_views`	Int
`desktop_jobs_page_views`	Int
`desktop_life_at_page_views`	Int
`desktop_overview_page_views`	Int
`desktop_people_page_views`	Int
`desktop_products_page_views`	Int
`insights_page_views`	Int
`jobs_page_views`	Int
`life_at_page_views`	Int
`mobile_about_page_views`	Int
`mobile_careers_page_views`	Int
`mobile_insights_page_views`	Int
`mobile_jobs_page_views`	Int
`mobile_life_at_page_views`	Int
`mobile_overview_page_views`	Int
`mobile_people_page_views`	Int
`mobile_products_page_views`	Int
`overview_page_views`	Int
`people_page_views`	Int
`products_page_views`	Int

share_distribution_target_interface_locales

Column	Type	Keys
`last_modified_time`	Instant	PKFK
`share_id`	Long	PKFK
`country`	String
`language`	String

page_statistic_by_staff_count_range

Column	Type	Keys
`_fivetran_id`	String	PK
`_organization_entity_urn`	String
`about_page_views`	Int
`all_desktop_page_views`	Int
`all_mobile_page_views`	Int
`all_page_views`	Int
`careers_page_views`	Int
`desktop_about_page_views`	Int
`desktop_careers_page_views`	Int
`desktop_insights_page_views`	Int
`desktop_jobs_page_views`	Int
`desktop_life_at_page_views`	Int
`desktop_overview_page_views`	Int
`desktop_people_page_views`	Int
`desktop_products_page_views`	Int
`insights_page_views`	Int
`jobs_page_views`	Int
`life_at_page_views`	Int
`mobile_about_page_views`	Int
`mobile_careers_page_views`	Int
`mobile_insights_page_views`	Int
`mobile_jobs_page_views`	Int
`mobile_life_at_page_views`	Int
`mobile_overview_page_views`	Int
`mobile_people_page_views`	Int
`mobile_products_page_views`	Int
`overview_page_views`	Int
`people_page_views`	Int
`products_page_views`	Int
`staff_count_range`	String

share_content

Column	Type	Keys
`_fivetran_id`	String	PK
`share_id`	Long	PKFK
`carousel_id`	Long
`media_alt_text`	String
`media_id`	String
`media_title`	String
`multi_image_alt_text`	String
`poll_question`	String
`poll_settings_duration`	String
`poll_settings_is_voter_visible_to_author`	Boolean
`poll_settings_vote_selection_type`	String
`poll_unique_voters_count`	Long
`reference_id`	String
`type`	String
`article_`

organization_locations

Column	Type	Keys
`organization_id`	Long	PKFK
`description_localized`	Json
`description_preferred_locale_country`	String
`description_preferred_locale_language`	String
`geo_location`	Long
`localized_description`	String
`location_type`	String
`street_address_field_state`	String
`address_`

brand_alternative_names

Column	Type	Keys
`brand_id`	Long	PKFK
`locale_country`	String
`locale_language`	String
`name`	String

share_multi_image

Column	Type	Keys
`id`	String	PK
`_fivetran_id`	String	PKFK
`alt_text`	String
`title`	String

followers_by_geo

Column	Type	Keys
`_fivetran_id`	String	PK
`geo`	String	FK
`_organization_entity_urn`	String
`follower_counts_organic_follower_count`	Int
`follower_counts_paid_follower_count`	Int

page_statistic_by_function

Column	Type	Keys
`_fivetran_id`	String	PK
`function_id`	Long	FK
`_organization_entity_urn`	String
`about_page_views`	Int
`all_desktop_page_views`	Int
`all_mobile_page_views`	Int
`all_page_views`	Int
`careers_page_views`	Int
`desktop_about_page_views`	Int
`desktop_careers_page_views`	Int
`desktop_insights_page_views`	Int
`desktop_jobs_page_views`	Int
`desktop_life_at_page_views`	Int
`desktop_overview_page_views`	Int
`desktop_people_page_views`	Int
`desktop_products_page_views`	Int
`insights_page_views`	Int
`jobs_page_views`	Int
`life_at_page_views`	Int
`mobile_about_page_views`	Int
`mobile_careers_page_views`	Int
`mobile_insights_page_views`	Int
`mobile_jobs_page_views`	Int
`mobile_life_at_page_views`	Int
`mobile_overview_page_views`	Int
`mobile_people_page_views`	Int
`mobile_products_page_views`	Int
`overview_page_views`	Int
`people_page_views`	Int
`products_page_views`	Int

share_distribution_target_industries

Column	Type	Keys
`industry_id`	Long	PKFK
`last_modified_time`	Instant	PKFK
`share_id`	Long	PKFK

region

Column	Type	Keys
`id`	Long	PK
`country`	String
`name`	String

brand

Column	Type	Keys
`id`	Long	PK
`organization_id`	Long	PKFK
`parent_relationship_parent_id`	Long	FK
`auto_created`	Boolean
`cover_photo_v_2_crop_info_height`	Int
`cover_photo_v_2_crop_info_width`	Int
`cover_photo_v_2_crop_info_x`	Int
`cover_photo_v_2_crop_info_y`	Int
`cover_photo_v_2_cropped`	String
`cover_photo_v_2_original`	String
`default_locale_country`	String
`default_locale_language`	String
`description_localized`	Json
`description_preferred_locale_country`	String
`description_preferred_locale_language`	String
`founded_on_day`	Int
`founded_on_month`	Int
`founded_on_year`	Int
`localized_description`	String
`localized_name`	String
`localized_website`	String
`logo_v_2_crop_info_height`	Int
`logo_v_2_crop_info_width`	Int
`logo_v_2_crop_info_x`	Int
`logo_v_2_crop_info_y`	Int
`logo_v_2_cropped`	String
`logo_v_2_original`	String
`name_localized`	Json
`name_preferred_locale_country`	String
`name_preferred_locale_language`	String
`parent_relationship_status`	String
`parent_relationship_type`	String
`pinned_post`	String
`vanity_name`	String
`version_tag`	String
`website_localized`	Json
`website_preferred_locale_country`	String
`website_preferred_locale_language`	String

organization

Column	Type	Keys
`id`	Long	PK
`parent_relationship_parent_id`	Long	FK
`cover_photo_v_2_crop_info_height`	Int
`cover_photo_v_2_crop_info_width`	Int
`cover_photo_v_2_crop_info_x`	Int
`cover_photo_v_2_crop_info_y`	Int
`cover_photo_v_2_cropped`	String
`cover_photo_v_2_original`	String
`default_locale_country`	String
`default_locale_language`	String
`description_localized`	Json
`description_preferred_locale_country`	String
`description_preferred_locale_language`	String
`founded_on_day`	Int
`founded_on_month`	Int
`founded_on_year`	Int
`localized_description`	String
`localized_name`	String
`localized_website`	String
`logo_v_2_crop_info_height`	Int
`logo_v_2_crop_info_width`	Int
`logo_v_2_crop_info_x`	Int
`logo_v_2_crop_info_y`	Int
`logo_v_2_cropped`	String
`logo_v_2_original`	String
`name_localized`	Json
`name_preferred_locale_country`	String
`name_preferred_locale_language`	String
`organization_status`	String
`organization_type`	String
`overview_photo_v_2_crop_info_height`	Int
`overview_photo_v_2_crop_info_width`	Int
`overview_photo_v_2_crop_info_x`	Int
`overview_photo_v_2_crop_info_y`	Int
`overview_photo_v_2_cropped`	String
`overview_photo_v_2_original`	String
`parent_relationship_status`	String
`parent_relationship_type`	String
`primary_organization_type`	String
`staff_count_range`	String
`vanity_name`	String
`version_tag`	String
`website_localized`	Json
`website_preferred_locale_country`	String
`website_preferred_locale_language`	String
`school_attributes_`

seniority

Column	Type	Keys
`id`	Long	PK
`name`	String

share_distribution_target_seniorities

Column	Type	Keys
`last_modified_time`	Instant	PKFK
`seniority_id`	Long	PKFK
`share_id`	Long	PKFK

post_distribution_target_staff_count_ranges

Column	Type	Keys
`staff_count_range`	String	PK
`last_modified_time`	Instant	PKFK
`post_id`	String	PKFK

share_distribution_target_job_functions

Column	Type	Keys
`function_id`	Long	PKFK
`last_modified_time`	Instant	PKFK
`share_id`	Long	PKFK

industry

Column	Type	Keys
`id`	Long	PK
`name`	String

post_distribution_target_locations

Column	Type	Keys
`location`	String	PK
`last_modified_time`	Instant	PKFK
`post_id`	String	PKFK

followers_by_function

Column	Type	Keys
`_fivetran_id`	String	PK
`function_id`	Long	FK
`_organization_entity_urn`	String
`follower_counts_organic_follower_count`	Int
`follower_counts_paid_follower_count`	Int

share_distribution_target_staff_count_ranges

Column	Type	Keys
`staff_count_range`	String	PK
`last_modified_time`	Instant	PKFK
`share_id`	Long	PKFK

total_follower_statistic

Column	Type	Keys
`_fivetran_id`	String	PK
`_organization_entity_urn`	String
`day`	Instant
`first_degree_size`	Int