An example JSON file is available here example.json along with it's schema here tv-data-exchange-schema.json
{
"source": {
"copyright": "ABC Co",
"licensee": "XYX Co",
"application": "DataEngine 1.0"
},
"criteria": {
"creationDate": "2019-04-01 23:20:19Z",
"channels": [ 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 ],
"dateRange": {
"from": "2019-01-01 00:00:00",
"to": "2019-01-31 23:59:59"
},
"regions": [ "UK", "US" ]
},
"transmissions": [
{
"channel": "A channel name",
"channelId": 32,
"date": "2019-01-01",
"startTime": "06:00:00",
"endTime": "06:58:52",
"startDateTime": "2019-01-01 06:00:00Z",
"endDateTime": "2019-01-01 06:58:52Z",
"day": "Tuesday",
"totalDurationInSeconds": 3532,
"nonIntervalDurationInSeconds": 3219,
"title": "Sample programme",
"region": "UK",
"level": 1,
"genre": "",
"eidr": "",
"contentId": "",
"id": "A3D5A1DD-8019-4354-96CB-A42FAFCEF298",
"episodeNumber": 4,
"seriesNumber": 2,
"episodesInSeries": 8,
"distributor": "Distribution company",
"productionCompany": "Production company",
"productionYear": "2018",
"isOriginal": true,
"isRepeat": false,
"isPremiere": true,
"isSplitTransmission": false,
"imdb": "",
"titles": [
{
"language": "en-US",
"title": "Sample programme"
},
{
"language": "es-BR",
"title": "Programa de muestra"
}
],
"intervals": [
{
"startTime": "06:10:00",
"endTime": "06:12:30",
"durationInSeconds": 150,
"startDateTime": "2019-01-01 06:10:00Z",
"endDateTime": "2019-01-01 06:12:30Z",
"name": "Kinder Surprise",
"type": "BREAK",
"isan": "KRO/FEKS075/020"
},
{
"startTime": "06:20:00",
"endTime": "06:22:30",
"durationInSeconds": 150,
"startDateTime": "2019-01-01 06:20:00Z",
"endDateTime": "2019-01-01 06:22:30Z",
"name": "Amazon Just Ask Alexa",
"type": "OTHER",
"isan": "JLN/AMPR093/030"
}
],
"figures": [
{
"demo": "Adults",
"demoId": 10,
"activity": "Live",
"audience": 300,
"share": 3.2,
"ttv": 12400,
"tvr": 0.4,
"universe": 98200,
"minTvr": 0.23,
"maxTvr": 15.96,
"minAudience": 141.4,
"maxAudience": 626.2,
"minShare": 5.56,
"maxShare": 46.29
},
{
"demo": "Women",
"demoId": 11,
"activity": "Live",
"audience": 200,
"share": 2.2,
"ttv": 11400,
"tvr": 0.4,
"universe": 97200,
"minTvr": 0.53,
"maxTvr": 18.96,
"minAudience": 241.4,
"maxAudience": 426.2,
"minShare": 6.56,
"maxShare": 56.29
}
]
},
{
}
],
"dayParts": [
{
"channel": "A channel name",
"channelId": 32,
"date": "2019-01-01",
"startTime": "06:00:00",
"endTime": "06:01:00",
"startDateTime": "2019-01-01 06:00:00Z",
"endDateTime": "2019-01-01 06:01:00Z",
"durationInSeconds": 60,
"region": "UK",
"figures": [
{
"demo": "Adults",
"demoId": 10,
"activity": "Live",
"audience": 300000,
"share": 3.2,
"ttv": 12400,
"tvr": 0.3,
"universe": 98200,
"minTvr": 0.23,
"maxTvr": 15.96,
"minAudience": 141.4,
"maxAudience": 626.2,
"minShare": 5.56,
"maxShare": 46.29
},
{
"demo": "Women",
"demoId": 11,
"activity": "Live",
"audience": 200,
"share": 2.2,
"tvr": 0.3,
"ttv": 11400,
"universe": 97200,
"minTvr": 0.53,
"maxTvr": 18.96,
"minAudience": 241.4,
"maxAudience": 426.2,
"minShare": 6.56,
"maxShare": 56.29
}
]
}
]
}
{
"$schema": "https://json-schema.org/draft-04/schema",
"$id": "https://tvdataexchange.com/tv-data-exchange-schema.json",
"type": "object",
"additionalProperties": true,
"definitions": {
"transmission": {
"type": "object",
"additionalProperties": true,
"properties": {
"channel": {
"type": "string"
},
"channelId": {
"type": "string"
},
"date": {
"type": "string"
},
"startTime": {
"type": "string"
},
"endTime": {
"type": "string"
},
"startDateTime": {
"type": "string"
},
"endDateTime": {
"type": "string"
},
"day": {
"type": "string"
},
"totalDurationInSeconds": {
"type": "integer"
},
"nonIntervalDurationInSeconds": {
"type": "integer"
},
"title": {
"type": "string"
},
"region": {
"type": "string"
},
"level": {
"type": "string"
},
"genre": {
"type": "string"
},
"eidr": {
"type": "string"
},
"contentId": {
"type": "string"
},
"id": {
"type": "string"
},
"episodeNumber": {
"type": "string"
},
"seriesNumber": {
"type": "string"
},
"episodesInSeries": {
"type": "integer"
},
"distributor": {
"type": "string"
},
"productionCompany": {
"type": "string"
},
"productionYear": {
"type": "string"
},
"isOriginal": {
"type": "boolean"
},
"isRepeat": {
"type": "boolean"
},
"isPremiere": {
"type": "boolean"
},
"isSplitTransmission": {
"type": "boolean"
},
"imdb": {
"type": "string"
},
"titles": {
"type": "array"
},
"intervals": {
"type": "array",
"items": {
"$ref": "#/definitions/interval"
}
},
"transmissions": {
"type": "array",
"items": {
"$ref": "#/definitions/transmission"
}
},
"figures": {
"type": "array",
"items": {
"$ref": "#/definitions/figure"
}
}
}
},
"dayPart": {
"$id": "#/definitions/dayPart",
"type": "object",
"additionalProperties": true,
"properties": {
"channel": {
"type": "string"
},
"channelId": {
"type": "integer"
},
"date": {
"type": "string"
},
"startTime": {
"type": "string"
},
"endTime": {
"type": "string"
},
"startDateTime": {
"type": "string"
},
"endDateTime": {
"type": "string"
},
"durationInSeconds": {
"type": "integer"
},
"region": {
"type": "string"
},
"figures": {
"type": "array",
"additionalItems": true,
"items": {
"$ref": "#/definitions/figure"
}
}
}
},
"interval": {
"type": "object",
"additionalProperties": true,
"properties": {
"startTime": {
"type": "string"
},
"endTime": {
"type": "string"
},
"durationInSeconds": {
"type": "integer"
},
"startDateTime": {
"type": "string"
},
"endDateTime": {
"type": "string"
},
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"isan": {
"type": "string"
},
"figures": {
"type": "array",
"items": {
"$ref": "#/definitions/figure"
}
}
}
},
"figure": {
"type": "object",
"additionalProperties": true,
"properties": {
"demo": {
"type": "string"
},
"demoId": {
"type": "string"
},
"activity": {
"type": "string"
},
"activityId": {
"type": "string"
},
"platform": {
"type": "string"
},
"platformId": {
"type": "string"
},
"audience": {
"type": "number"
},
"share": {
"type": "number"
},
"ttv": {
"type": "number"
},
"tvr": {
"type": "number"
},
"universe": {
"type": "number"
},
"minTvr": {
"type": "number"
},
"maxTvr": {
"type": "number"
},
"minAudience": {
"type": "number"
},
"maxAudience": {
"type": "number"
},
"minShare": {
"type": "number"
},
"maxShare": {
"type": "number"
}
}
}
},
"properties": {
"source": {
"$id": "#/properties/source",
"type": "object",
"title": "The source schema",
"additionalProperties": true,
"properties": {
"copyright": {
"$id": "#/properties/source/properties/copyright",
"type": "string",
"title": "The copyright schema"
},
"licensee": {
"$id": "#/properties/source/properties/licensee",
"type": "string",
"title": "The licensee schema"
},
"application": {
"$id": "#/properties/source/properties/application",
"type": "string",
"title": "The application schema"
}
}
},
"criteria": {
"$id": "#/properties/criteria",
"type": "object",
"title": "The criteria schema",
"additionalProperties": true,
"properties": {
"creationDate": {
"$id": "#/properties/criteria/properties/creationDate",
"type": "string",
"title": "The creationDate schema"
}
}
},
"transmissions": {
"type": "array",
"additionalItems": true,
"items": {
"$ref": "#/definitions/transmission"
}
},
"dayParts": {
"$id": "#/properties/dayParts",
"type": "array",
"title": "The dayParts schema",
"additionalItems": true,
"items": {
"$ref": "#/definitions/dayPart"
}
}
}
}