Property talk:P5842

Documentation

• Start a query
• Current uses
• Statistics by class
• String length
• List of qualifiers
• Count

Apple Podcasts podcast ID
identifier for a podcast in iTunes

Applicable "stated in" value	Apple Podcasts (Q70058728)
Data type	External identifier
Domain	podcast (Q24634210)
Allowed values	[1-9][0-9]*
Usage notes	Do not include the "id" prefix in the value.
Example	Stay Tuned with Preet (Q56542667) → 1265845136 Friday Night Comedy from BBC Radio 4 (Q96757490) → 265307784
Source	https://podcasts.apple.com
Formatter URL	https://podcasts.apple.com/podcast/id$1
See also	App Store app ID (P3861), Apple Music artist ID (U.S. version) (P2850), Apple Music album ID (U.S. version) (P2281), NPR podcast ID (P5840), Spotify show ID (P5916), Deezer show ID (P5988), iHeart podcast ID (P7324), Podchaser podcast ID (P7998), Apple Podcasts episode ID (P10304), Panoptikum podcast ID (P4818), Panoptikum podcast episode ID (P7849)
Lists	Items with the most statements of this property Count of items by number of statements (chart) Items with the most statements Items with the fewest statements Count of items by number of sitelinks (chart) Items with the most sitelinks Items with the most sitelinks, but no link to one Wikipedia (sample: Welsh Wikipedia, cywiki) Items with the fewest sitelinks Most linked wikis Items with the most identifier properties Items with no other external identifier Items with no other statements Most recently created items Items with novalue claims Items with unknown value claims Usage history (total) Usage history (main statement) Chart by item creation date Database reports/Constraint violations/P5842 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 5,576 Main statement 5,233 out of 2,000,000 (0% complete) 93.8% of uses Qualifier 5 <0.1% of uses Reference 338 6.1% of uses
Search for values

[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)

Format “[1-9][0-9]*”: value must be formatted using this pattern (PCRE syntax). (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#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

Item “title (P1476)”: Items with this property should also have “title (P1476)”. (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 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

Item “genre (P136)”: Items with this property should also have “genre (P136)”. (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 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, SPARQL

Item “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, SPARQL

Conflicts 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, SPARQL

Conflicts 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

Show entries with an appleID but not an end-date

https://w.wiki/7WJa Back ache (talk) 13:47, 21 September 2023 (UTC)

Show entries with an AppleID but not a feed

https://w.wiki/8etd

podcast not updated in the last 24hours and without linkrot or an end time

  SELECT 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

For 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)