API docs by Redocly

RepublicOfData.io API (0.2.3)

Download OpenAPI specification:Download

The RepublicOfData.io API provides access to a proprietary data platform that captures and analyzes climate change narratives from traditional and social media sources. Our mission is to provide unique insights into climate narrative shifts to researchers, policymakers, journalists, activists, and other stakeholders.

Executes a query

Get media articles and their associated social conversations

query Parameters
query
required
string
Example: query={"measures":["media_conversations.count"]}

The JSON query to execute

media_conversation_pk
string

Unique identifier for the media conversation.

media_article_fk
string

Unique identifier for the media article.

social_network_conversation_fk
string

Unique identifier for the social network conversation.

social_network_post_fk
string

Unique identifier for the social network post.

social_network_user_profile_fk
string

Unique identifier for the social network user profile.

article_source
string

Media source of the article.

article_url
string

URL of the article.

article_title
string

Title of the article.

article_summary
string

Summary of the article.

article_description
string

Description of the article.

article_content
string

Content of the article.

article_tags
string

Tags of the article.

article_author
string

Author of the article.

article_medias
string

Medias associated with the article.

article_publication_ts
string

Publication timestamp of the article.

article_modification_ts
string

Modification timestamp of the article.

social_network_source
string

Social network of the conversation and posts.

conversation_natural_key
string

Unique identifier for the conversation.

post_natural_key
string

Unique identifier for the post.

post_text
string

Text of the conversation post.

post_impression_count
number

The number of impressions of the post.

post_reply_count
number

The number of replies of the post.

post_quote_count
number

The number of quotes of the post.

post_like_count
number

The number of likes of the post.

post_retweet_count
number

The number of retweets of the post.

post_bookmark_count
number

The number of bookmarks of the post.

post_creation_ts
string

Creation timestamp of the conversation post.

social_network_profile_natural_key
string

Unique identifier for the social network profile.

social_network_profile_username
string

Username of the social network profile.

social_network_profile_location_name
string

Location name of the social network profile.

social_network_profile_location_country_name
string

Country name of the social network profile.

social_network_profile_location_country_code
string

Country code of the social network profile.

social_network_profile_location_admin1_name
string

Admin1 name of the social network profile.

social_network_profile_location_admin1_code
string

Admin1 code of the social network profile.

social_network_profile_location_latitude
string

Post author's creation timestamp.

social_network_profile_location_longitude
string

Post author's creation timestamp.

social_network_profile_creation_ts
string

Creation timestamp of the social network profile.

Responses

Request samples 

curl \
  -H "Authorization: <TOKEN>" \
  -G \
  --data-urlencode 'query={
      "limit": 5,
      "dimensions": [
          "media_conversations.article_url",
          "media_conversations.article_title",
          "media_conversations.article_tags"
      ],
      "timeDimensions": [
          {
              "dimension": "media_conversations.article_publication_ts",
              "granularity": "day",
              "dateRange": "This week"
          }
      ],
      "order": {
          "media_conversations.article_url": "asc"
      }
  }' \
  https://neighbouring-rhinoceros.gcp-us-central1.cubecloudapp.dev/cubejs-api/v1/load

Response samples

Content type
application/json
{
  • "query": {
    },
  • "data": [
    ],
  • "lastRefreshTime": "2024-03-13T13:42:34.000Z",
  • "annotation": {
    },
  • "dataSource": "default",
  • "dbType": "snowflake",
  • "extDbType": "cubestore",
  • "external": true,
  • "slowQuery": false,
  • "total": null
}