sources

This table contains all the sources for our datasets. The description column contains JSON encoded as text that contains useful additional fields like a longer descriptive text "additionalInfo".

Data license: CC-BY

1 row where datasetId = 4173 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
17001 Users by social media platform, Statista and TNW (2019) 
{
    "link": "Statista: https://www.statista.com/statistics/272014/global-social-networks-ranked-by-number-of-users/ and TNW: https://thenextweb.com/tech/2019/06/11/most-popular-social-media-networks-year-animated/",
    "retrievedDate": "22/07/2019",
    "additionalInfo": "Estimates from Statista correspond to yearly averages (Statista publishes monthly or quarterly figures). Estimates from TNW correspond to the first figure provided for the corresponding year (TNW published an animation with interpolated data). \n\nEstimates for Facebook, Twitter, Instagram, Whatsapp, and Pinterest are taken from Statista. All other series come from TNW. TNW does not provide details regarding their underlying sources but our analysis suggests their estimates are consistent with primary sources and reports such as company earnings press releases, official company websites, and published articles.\n\nStatista uses monthly active users to measure social media platform usage. Statista specifies \"Facebook measures monthly active users (MAUs) as users that have logged in during the past 30 days.  Users are counted separately for Facebook and other apps. Statista specifies \"Figures do not include Instagram or WhatsApp users unless they would otherwise qualify as such users, respectively, based on their other activities on Facebook.\"\n\nFurther details regarding the source breakdown for each series can be found <a href=\"https://owid.cloud/wp-content/uploads/2019/07/social-media-doc-v2.xlsx\">here</a>. ",
    "dataPublishedBy": "Statista and The Next Web"
}
 2019-07-22 17:00:30 2019-07-22 17:00:30 Users by social media platform (Statista and TNW (2019)) 4173 Estimates from Statista correspond to yearly averages (Statista publishes monthly or quarterly figures). Estimates from TNW correspond to the first figure provided for the corresponding year (TNW published an animation with interpolated data). Estimates for Facebook, Twitter, Instagram, Whatsapp, and Pinterest are taken from Statista. All other series come from TNW. TNW does not provide details regarding their underlying sources but our analysis suggests their estimates are consistent with primary sources and reports such as company earnings press releases, official company websites, and published articles. Statista uses monthly active users to measure social media platform usage. Statista specifies "Facebook measures monthly active users (MAUs) as users that have logged in during the past 30 days. Users are counted separately for Facebook and other apps. Statista specifies "Figures do not include Instagram or WhatsApp users unless they would otherwise qualify as such users, respectively, based on their other activities on Facebook." Further details regarding the source breakdown for each series can be found <a href="https://owid.cloud/wp-content/uploads/2019/07/social-media-doc-v2.xlsx">here</a>. Statista: https://www.statista.com/statistics/272014/global-social-networks-ranked-by-number-of-users/ and TNW: https://thenextweb.com/tech/2019/06/11/most-popular-social-media-networks-year-animated/ Statista and The Next Web

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "sources" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(512) NULL  ,
	"description" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");