Post
This page contains information about the Post data source in the Altmetric BigQuery project.
Post Schema
| Field |
Type |
Description |
Example |
attention_source |
AttentionSource |
Details from the related attention source, contains a subset of columns from the 'attention_sources' table. |
|
attention_source_id |
String |
Identifier of the related attention source. Matches the field 'id' in the 'attention_sources' table. |
ⓘ |
date |
Timestamp Partitioning field |
Timestamp on which the mention was made. |
ⓘ |
id |
String Clustering field |
Unique Altmetric post identifier. |
ⓘ |
identifiers |
Identifiers |
Listing of resolved research output identifiers (i.e. Dimension publications) mentioned within the post. |
|
research_outputs_ids |
Array of < String > |
Array of identifiers mentioned in the post. The array length of this field is the number of mentions for the post. Identifiers in this array match the field 'id' in the 'research_outputs' table. |
ⓘ |
sentiment_scores |
Array of < SentimentScore > |
Sentiment score mappings for each research output mentioned in the post. The array length matches 'research_outputs_ids' — one entry per mention. |
ⓘ |
retweet |
Boolean |
Indicates whether the post is sharing an original X post, with the value TRUE when the post is a repost. |
|
subtype |
String Clustering field |
Some posts, such as Tweets have a subtype associated to them (Currently, one of: repost, quoted, original). |
|
title |
String |
Original title; no maximum length. |
ⓘ |
type |
String Clustering field |
Type of mention (One of: f1000, rdt, qna, pinterest, weibo, msm, blog, peer_review, policy, guideline, gplus, tweet, bluesky, fbwall, wikipedia, video, podcast, linkedin, patent, seminar). |
ⓘ |
url |
String |
The URL of the post. |
ⓘ |
year |
Integer |
Year of post date, (YYYY). |
ⓘ |
Post Links
The diagram below provides an overview of the outgoing links from Post to other sources.
Auxiliary Entities
AttentionSource
| Field |
Type |
Description |
country |
String |
The country name of the attention source, where it is known. |
name |
String |
The name of the attention source. |
type |
String |
The type of mention source (one of: tw, fb, gplus, sw, rdt, blog, msm, linkedin, policy, guideline, bsk, podcast, seminar_series). |
DimensionsIdentifiers
| Field |
Type |
Description |
clinical_trial_ids |
Array of < String > |
Links to Dimensions 'clinical_trials' table (for the associated research outputs identified within the post). |
dataset_ids |
Array of < String > |
Links to Dimensions 'datasets' table (for the associated research outputs identified within the post). |
publication_ids |
Array of < String > |
Links to Dimensions 'publications' table (for the associated research outputs identified within the post). |
Identifiers
| Field |
Type |
Description |
dimensions |
DimensionsIdentifiers |
Dimensions identifiers for publications, datasets and clinical trials related to the research outputs identified within the post. |
SentimentScore
| Field |
Type |
Description |
research_output_id |
String |
Identifier of the research output the sentiment score applies to. Matches a value in the post's 'research_outputs_ids' array and the 'id' field in the 'research_outputs' table. |
sentiment_score |
Integer |
Sentiment score for the research output as expressed in this post. Null when no score is available. |