Generally, how deep is the data?

Generally, how deep is the data?

Postby JMThomas » Wed Mar 08, 2017 7:47 pm

I hoped that this information would be in the FAQ {wink}...

How many days of data is normally available for the majority of US broadcasters/distributors?

Anything more than 12 or 14 days would make schedulesdirect.org very distinctive!

Is episode information information available for most non "first run" programming?

I expect ABC, et. al. to provide good information. (E.g. "The bachelor narrows his search to 3 finalists...")

But many secondary networks (Cozi, H&I, CW, ATV, etc.) run old shows and movies, for which some services just provide only the title and/or the same generic information for every episode (e.g. "Gunsmoke. Long running Western that made {actors} famous set in a Kansas cattle town..."). Deep information would include the like of guest stars for an individual episode, plot summaries and/or brief reviews for movies, ...

Can I obtain aggregate information for more than my "local area"?

A couple of OTA stations I watch are 35 miles away, and considered generally considered "out of my area". Thus I'd like feeds for my zip code, and a couple of zip codes in non adjacent counties.

I understand that things don't come together all the time, and are subject to change, and can depend on individual station reporting.

But where may I set my general expectations? Thanks!
JMThomas
 
Posts: 2
Joined: Wed Mar 08, 2017 6:09 pm

Re: Generally, how deep is the data?

Postby rkulagow » Thu Mar 09, 2017 8:13 am

Schedules Direct offers two data sources; one is in XML and one is in JSON.

The XML data typically has 12 to 13 days of data in the US. The JSON data has about 20, but the further out you go, the fuzzier it gets. The JSON data supports countries outside of US/Canada/Mexico.

Some applications have native support for the JSON data. Some don't, and therefore are either restricted to just the XML native data set, or use an external program to translate from JSON to XML. (But since not all the fields in JSON are available in XML, some of the information is discarded.)

Since you asked about Gunsmoke, this is what the JSON data looks like. The XML data would have similar episode descriptions, but wouldn't have as deep information about the actors.

Code: Select all
{
    "programID": "EP000019730001",
    "resourceID": "184305",
    "titles": [
        {
            "title120": "Gunsmoke"
        }
    ],
    "descriptions": {
        "description100": [
            {
                "descriptionLanguage": "en",
                "description": "A woman thwarts Matt's efforts to help a former outlaw go straight."
            }
        ],
        "description1000": [
            {
                "descriptionLanguage": "en",
                "description": "Matt Dillon's efforts to help a former outlaw go straight are thwarted by the influence of a beautiful woman."
            }
        ]
    },
    "originalAirDate": "1961-09-30",
    "genres": [
        "Drama",
        "Western"
    ],
    "episodeTitle150": "Perce",
    "metadata": [
        {
            "Gracenote": {
                "season": 7,
                "episode": 1,
                "totalEpisodes": 34
            }
        }
    ],
    "contentRating": [
        {
            "body": "Canadian Parental Rating",
            "code": "PG",
            "country": "CAN"
        },
        {
            "body": "USA Parental Rating",
            "code": "TVPG",
            "country": "USA"
        }
    ],
    "cast": [
        {
            "billingOrder": "01",
            "role": "Actor",
            "nameId": "28953",
            "personId": "28953",
            "name": "James Arness"
        },
        {
            "billingOrder": "02",
            "role": "Actor",
            "nameId": "16465",
            "personId": "16465",
            "name": "Dennis Weaver"
        },
        {
            "billingOrder": "03",
            "role": "Actor",
            "nameId": "46548",
            "personId": "46548",
            "name": "Milburn Stone"
        },
        {
            "billingOrder": "04",
            "role": "Actor",
            "nameId": "82403",
            "personId": "82403",
            "name": "Amanda Blake"
        },
        {
            "billingOrder": "05",
            "role": "Actor",
            "nameId": "415315",
            "personId": "406440",
            "name": "James Nusser"
        },
        {
            "billingOrder": "06",
            "role": "Guest Star",
            "nameId": "83688",
            "personId": "83688",
            "name": "Ed Nelson"
        },
        {
            "billingOrder": "07",
            "role": "Guest Star",
            "nameId": "79701",
            "personId": "79701",
            "name": "Chuck Bail"
        },
        {
            "billingOrder": "08",
            "role": "Guest Star",
            "nameId": "384394",
            "personId": "375519",
            "name": "Chuck Hayward"
        },
        {
            "billingOrder": "09",
            "role": "Guest Star",
            "nameId": "431991",
            "personId": "423116",
            "name": "Alex Sharp"
        },
        {
            "billingOrder": "10",
            "role": "Guest Star",
            "nameId": "120144",
            "personId": "120144",
            "name": "Baynes Barron"
        },
        {
            "billingOrder": "11",
            "role": "Guest Star",
            "nameId": "17359",
            "personId": "17359",
            "name": "Don Russell"
        },
        {
            "billingOrder": "12",
            "role": "Guest Star",
            "nameId": "219458",
            "personId": "217117",
            "name": "Norma Crane"
        },
        {
            "billingOrder": "13",
            "role": "Guest Star",
            "nameId": "230512",
            "personId": "227557",
            "name": "Ken Lynch"
        },
        {
            "billingOrder": "14",
            "role": "Guest Star",
            "nameId": "407182",
            "personId": "398307",
            "name": "Fred McDougall"
        }
    ],
    "crew": [
        {
            "billingOrder": "01",
            "role": "Producer",
            "nameId": "227886",
            "personId": "225083",
            "name": "Norman MacDonnell"
        },
        {
            "billingOrder": "02",
            "role": "Director",
            "nameId": "789611",
            "personId": "83975",
            "name": "Harry Harris Jr."
        },
        {
            "billingOrder": "03",
            "role": "Writer",
            "nameId": "409032",
            "personId": "400157",
            "name": "John Meston"
        }
    ],
    "entityType": "Episode",
    "showType": "Series",
    "md5": "tBqUMzr/HBHKl3kXS3XSEg"
}
rkulagow
SD Staff
 
Posts: 884
Joined: Tue Aug 14, 2007 3:15 pm

Re: Generally, how deep is the data?

Postby JMThomas » Thu Mar 09, 2017 5:00 pm

Thanks! Good info in a very responsive answer.

Perhaps you might like to copy & paste into the FAQ?
How much information is generally available?
Schedules Direct offers two data sources; one is in XML and one is in JSON.

The XML data typically has 12 to 13 days of data in the US. The JSON data has about 20, but the further out you go, the fuzzier it gets. The JSON data supports countries outside of US/Canada/Mexico.

The XML data generally has episode descriptions, but doesn't have deep information about the actors.

Some applications have native support for the JSON data. Those which do not, will have less information available. (Some programs may pre-process JSON data to XML format, but will loose information because not all JSON fields are in the XML layout.)
JMThomas
 
Posts: 2
Joined: Wed Mar 08, 2017 6:09 pm

Re: Generally, how deep is the data?

Postby rmeden » Thu Mar 09, 2017 11:32 pm

If you're going to make it that easy, how can I not do it! Done.
rmeden
SD Board Member
 
Posts: 1486
Joined: Tue Aug 14, 2007 2:31 pm
Location: Cedar Hill, TX


Return to General Discussions

Who is online

Users browsing this forum: Google [Bot] and 4 guests