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 = 4177 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
17005 BOND Internet Trends (2019) 
{
    "link": "https://www.bondcap.com/report/it19/#view/41",
    "retrievedDate": "2019-08-01",
    "additionalInfo": "Other connected devices include over-the-top (OTT) & game consoles. Mobile includes smartphone & tablet. Usage includes both home & work for consumers 18+. Non deduplicated-time is assigned to each medium individually, regardless of multitasking.",
    "dataPublishedBy": "BOND Internet Trends (2019)",
    "dataPublisherSource": "eMarketer 9/14 (2008-2010), eMarketer 4/15 (2011-2013), eMarketer 4/17 (2014-2015), eMarketer 10/18 (2016-2018). Note: Other connected devices include OTT & game consoles. Mobile includes smartphone & tablet. Usage includes both home & work for consumers 18+. Non deduped defined as time spent with each medium individually, regardless of multitasking. "
}
 2019-08-01 11:21:57 2023-04-03 15:44:50 Daily hours spent with digital media per adult user, US (BOND Internet Trends (2019)) 4177 Other connected devices include over-the-top (OTT) & game consoles. Mobile includes smartphone & tablet. Usage includes both home & work for consumers 18+. Non deduplicated-time is assigned to each medium individually, regardless of multitasking. https://www.bondcap.com/report/it19/#view/41 BOND Internet Trends (2019)

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");