Talk:Q24634210

list of 10 podcasts without webfeeds

The Apple ID can be converted to RSS using labnol.org/podcast/

https://listeria.toolforge.org/botstatus.php?action=page&wiki=wikidatawiki&page=Talk:Q24634210

Manually update list

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | TABernacle | Find images | Recent changes | Query: SELECT DISTINCT ?item WHERE { ?item p:P31 ?statement0. ?statement0 (ps:P31/(wdt:P279*)) wd:Q24634210. MINUS { ?item p:P1019 ?statement1. ?statement1 (ps:P1019) _:anyValueP1019. } MINUS { ?item p:P582 ?statement_2. ?statement_2 psv:P582 ?statementValue_2. ?statementValue_2 wikibase:timeValue ?P582_2. } } LIMIT 10

Misc

Article	description	genre	official website	language of work or name	start time	end time	number of episodes	Apple Podcasts podcast ID	Spotify show/podcast ID	iHeart podcast ID	Podcast Index ID	iHeart podcast ID	Pocket Casts ID	Spotify show/podcast ID	RadioPublic show ID (obsolete)	Deezer show ID	TuneIn Podcasts show ID	Panoptikum podcast ID	PodLink ID	Listen Notes podcast ID	Podcast Index ID	fyyd podcast ID	EIDR content ID	Panoptikum podcast ID	Google Knowledge Graph ID	logo URL
GLT Music Podcast	podcast from WGLT
Dímelo: Stories of the Southwest	podcast from Arizona Public Media
WUNC Youth Podcast	podcast from North Carolina Public Radio
First Friday Focus on the Environment	podcast from 89.1 WEMU
KCRW's Cargoland	podcast from KCRW
KCRW's Here Be Monsters	podcast from KCRW
The New Yorker: Poetry	podcast from WNYC Radio
The Waters and Harvey Show	podcast from BPR Classic
Amy Bennett Williams Essays	podcast from WGCU
Views of the News on KBIA	podcast from KBIA

---

∑ 10 items.

End of automatically generated list.

Querys

List podcasts without episode counts

SELECT ?item WHERE {
      ?item p:P31 ?statement0.
      ?statement0 (ps:P31) wd:Q24634210.
      MINUS {
        ?item p:P1113 ?statement1.
        ?statement1 (ps:P1113) _:anyValueP1113.
      }
    }
    LIMIT 100

Try it!

Back ache (talk) 10:02, 16 May 2024 (UTC)

list of 100 podcasts that havnt ended

SELECT DISTINCT ?item WHERE {
  ?item p:P31 ?statement0.
  ?statement0 (ps:P31) wd:Q24634210.
  ?item p:P5842 ?statement1.
  ?statement1 (ps:P5842) _:anyValueP5842.
  MINUS {
    ?item p:P582 ?statement_2.
    ?statement_2 psv:P582 ?statementValue_2.
    ?statementValue_2 wikibase:timeValue ?P582_2.
  }
}
LIMIT 100

Try it!

List of entries with an Apple podcast id, but without an episode count or "link rot"

SELECT DISTINCT ?item WHERE {
  ?item p:P5842 ?statement0.
  ?statement0 (ps:P5842) _:anyValueP5842.
  MINUS {
    ?item p:P1113 ?statement1.
    ?statement1 (psv:P1113/wikibase:quantityAmount) ?numericQuantity.
  }
  MINUS {
    ?item p:P1534 ?statement2.
    ?statement2 (ps:P1534) wd:Q1193907.
  }
}
LIMIT 100

Try it!

List of podcasts without a language defined

SELECT DISTINCT ?item WHERE {
  ?item p:P31 ?statement0.
  ?statement0 (ps:P31) wd:Q24634210.
  ?item p:P1019 ?statement1.
  ?statement1 (ps:P1019) _:anyValueP1019.
  MINUS {
    ?item p:P407 ?statement2.
    ?statement2 (ps:P407/(wdt:P279*)) _:anyValueP407.
  }
}

Try it!

Diagram of the languages usage in podcasts

#Popular languages used in podcasts
#title:Main language used in a podcast
#illustrates bubblechart view, count

#defaultView:BubbleChart
SELECT ?language ?languageLabel (COUNT(?languages) AS ?count)
WHERE
{
  ?languages wdt:P31 wd:Q24634210.
  ?languages wdt:P407 ?language.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?language ?languageLabel
ORDER BY DESC(?count)

Main language used in a podcast

merge

@Jean-Frédéric "Please discuss this first"
Okay, good morning. no difference between the two items and no usage of audio podcast (Q24633474): matching description (italian for example like french: podcast in formato audio - podcast au format audio) (programma audio che consiste in una serie di episodi - episode-based audio program)... then, this item (the main one) is described as instance of (P31) audio content genre (Q108676140) so no reason to exist for another one that just repeat audio and is subclass of (P279) GiovanniPen (talk) 15:53, 1 August 2024 (UTC)

@Jean-Frédéric: one week, no answer... GiovanniPen (talk) 12:40, 7 August 2024 (UTC)

Hi GiovanniPen, apologies for dropping the ball on this.

First, Thanks for looking into this − the items around podcasts are a little bit of a mess. It does look like these two items have somewhat converged, but I’m pretty sure they used to be more different, so not sure whether some repurposing happened at some point. I believe podcast show (Q24634210) is (used to be?) used as instance of (P31) and audio podcast (Q24633474) as distribution format (P437). This probably should be brought up to Wikidata:WikiProject_Podcasts. Jean-Fred (talk) 09:35, 16 August 2024 (UTC)

if we consider podcast generic valid for both audio and video okay, otherwise merge is the option. something should (needs to) be fixed in both cases GiovanniPen (talk) 09:38, 16 August 2024 (UTC)

Well we do have video podcast (Q3276244), and as I understand, it and audio podcast (Q24633474) are counterparts − both are -instance of (P31)product distribution method (Q81941037) (which is consistent with the use in distribution format (P437)) Jean-Fred (talk) 12:36, 16 August 2024 (UTC)

so is this item useless or not? GiovanniPen (talk) 13:07, 16 August 2024 (UTC)