Property talk:P5842
Latest comment: 10 months ago by Back ache in topic API
Documentation
Apple Podcasts podcast ID
identifier for a podcast in iTunes
identifier for a podcast in iTunes
[create Create a translatable help page (preferably in English) for this property to be included here]
Type “podcast (Q24634210)”: item must contain property “instance of (P31)” with classes “podcast (Q24634210)” or their subclasses (defined using subclass of (P279)). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P5842#Type Q24634210, SPARQL
Single value: this property generally contains a single value. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P5842#Single value, SPARQL
Distinct values: this property likely contains a value that is different from all other items. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P5842#Unique value, SPARQL (every item), SPARQL (by value)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P5842#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P5842#Format, SPARQL
Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P5842#Entity types
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P5842#Item P1476, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P5842#Item P1476, SPARQL
Item “language of work or name (P407)”: Items with this property should also have “language of work or name (P407)”. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P5842#Item P407, search, SPARQL
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P5842#Item P136, search, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P5842#Item P136, search, SPARQL
Item “distribution format (P437): audio podcast (Q24633474)”: Items with this property should also have “distribution format (P437): audio podcast (Q24633474)”. (Help)
List of violations of this constraint: Database reports/Constraint violations/P5842#Item P437, hourly updated report, search, SPARQLItem “number of episodes (P1113)”: Items with this property should also have “number of episodes (P1113)”. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P5842#Item P1113, SPARQL
Item “web feed URL (P1019)”: Items with this property should also have “web feed URL (P1019)”. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P5842#Item P1019, SPARQL
Conflicts with “instance of (P31): radio program (Q1555508), radio series (Q14623351)”: this property must not be used with the listed properties and values. (Help)
List of violations of this constraint: Database reports/Constraint violations/P5842#Conflicts with P31, hourly updated report, SPARQLConflicts with “instance of (P31): podcast (Q20899), audio podcast (Q24633474), video podcast (Q3276244)”: this property must not be used with the listed properties and values. (Help)
List of violations of this constraint: Database reports/Constraint violations/P5842#Conflicts with P31, hourly updated report, SPARQLConflicts with “inception (P571)”: this property must not be used with the listed properties and values. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P5842#Conflicts with P571, SPARQL
Conflicts with “publication date (P577)”: this property must not be used with the listed properties and values. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P5842#Conflicts with P577, SPARQL
Conflicts with “instance of (P31): human (Q5)”: this property must not be used with the listed properties and values. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P5842#Conflicts with P31, search, SPARQL
Conflicts with “country (P17)”: this property must not be used with the listed properties and values. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P5842#Conflicts with P17, search, SPARQL
|
Querys
editShow entries with an appleID but not an end-date
edithttps://w.wiki/7WJa Back ache (talk) 13:47, 21 September 2023 (UTC)
Show entries with an AppleID but not a feed
editpodcast not updated in the last 24hours and without linkrot or an end time
editSELECT DISTINCT ?item WHERE { BIND ((now() - "P7D"^^xsd:duration) AS ?date_) ?item p:P5842 ?statement0. ?item schema:dateModified ?date . ?statement0 (ps:P5842) _:anyValueP5842. MINUS { ?item p:P582 ?statement_1. ?statement_1 psv:P582 ?statementValue_1. ?statementValue_1 wikibase:timeValue ?P582_1. } MINUS { ?item p:P1534 ?statement2. ?statement2 (ps:P1534/(wdt:P279*)) wd:Q1193907. } FILTER (?date < ?date_) } LIMIT 5000
API
editFor a given ID the Apple ID gives lots of useful information all available for free
For example to query with the Apple ID for "The Civic Hacker Podcast" would be http://itunes.apple.com/lookup?id=1581339367 and will give you the JSON
{
"resultCount":1,
"results": [
{"wrapperType":"track", "kind":"podcast", "collectionId":1581339367, "trackId":1581339367, "artistName":"Lori McNeill, Founder | Civic Hacker Network", "collectionName":"The Civic Hacker Podcast", "trackName":"The Civic Hacker Podcast", "collectionCensoredName":"The Civic Hacker Podcast", "trackCensoredName":"The Civic Hacker Podcast", "collectionViewUrl":"https://podcasts.apple.com/us/podcast/the-civic-hacker-podcast/id1581339367?uo=4", "feedUrl":"https://anchor.fm/s/3407aeac/podcast/rss", "trackViewUrl":"https://podcasts.apple.com/us/podcast/the-civic-hacker-podcast/id1581339367?uo=4", "artworkUrl30":"https://is1-ssl.mzstatic.com/image/thumb/Podcasts115/v4/ae/20/ef/ae20ef14-cde6-b373-a3c1-9d22e3c4d765/mza_6252416178948969788.jpg/30x30bb.jpg", "artworkUrl60":"https://is1-ssl.mzstatic.com/image/thumb/Podcasts115/v4/ae/20/ef/ae20ef14-cde6-b373-a3c1-9d22e3c4d765/mza_6252416178948969788.jpg/60x60bb.jpg", "artworkUrl100":"https://is1-ssl.mzstatic.com/image/thumb/Podcasts115/v4/ae/20/ef/ae20ef14-cde6-b373-a3c1-9d22e3c4d765/mza_6252416178948969788.jpg/100x100bb.jpg", "collectionPrice":0.00, "trackPrice":0.00, "collectionHdPrice":0, "releaseDate":"2023-09-26T02:22:00Z", "collectionExplicitness":"notExplicit", "trackExplicitness":"cleaned", "trackCount":36, "trackTimeMillis":2931, "country":"USA", "currency":"USD", "primaryGenreName":"Technology", "contentAdvisoryRating":"Clean", "artworkUrl600":"https://is1-ssl.mzstatic.com/image/thumb/Podcasts115/v4/ae/20/ef/ae20ef14-cde6-b373-a3c1-9d22e3c4d765/mza_6252416178948969788.jpg/600x600bb.jpg", "genreIds":["1318", "26"], "genres":["Technology", "Podcasts"]}]
}
Back ache (talk) 16:41, 18 November 2023 (UTC)