Back ache

Mein Shiff 3

I'm puzzled why you added 2 locations to Mein Schiff 3 (Q16323072), when by their nature ships have lots of locations, until their final resting place as a museum ship or wreck. Vicarage (talk) 14:36, 31 October 2023 (UTC)

It was right at the time of adding hence why it has the "point in time" property, the data came from the gps aboard the ship, if it was available I was also back-filling any other data the ship provided. I have stopped the project now Back ache (talk) 18:47, 31 October 2023 (UTC)

I can't see any advantage in putting such data in WD. Can you point me to a description of the project, so we can discuss its merits in WikiProject:Ships? Vicarage (talk) 19:00, 31 October 2023 (UTC)

it's a moot point tbh, I've already stopped. Back ache (talk) 20:23, 31 October 2023 (UTC)

Podcast

Could you please stop adding retrieved (P813) as a qualifier of number of episodes (P1113)? It's not even a valid qualifier for that property and you are just creating hundreds of constraint violations Trade (talk) 22:10, 11 November 2023 (UTC)

OKay Back ache (talk) 00:15, 12 November 2023 (UTC)

And also to stop listing podcast (Q24634210) as a genre Trade (talk) 03:14, 12 November 2023 (UTC)

iAlso please stop using name (P2561) on podcasts (Q123401326)--Trade (talk) 03:17, 12 November 2023 (UTC)

thanks for the feedback, I have done a lot of work to fix the gaps in a lot of entries and its nce or someone to notice :-) Back ache (talk) 07:32, 12 November 2023 (UTC)

Could you make a batch that removes the wrong properties and qualifiers from items? Trade (talk) 11:46, 12 November 2023 (UTC)

WDQS refuse to query entries with "name" and QS can be very "quirky", but I am looking into it. Back ache (talk) 09:22, 13 November 2023 (UTC)

Is Next 2 Blow Podcast (Q113559381) supposed to be about a podcast or a human? Biy confused Trade (talk) 13:38, 13 November 2023 (UTC)

Looks like someone going a bit batch-crazy so better you ask the person that did it, its the kind of thing a script could fix, but for now I have tidied it up Back ache (talk) 14:06, 13 November 2023 (UTC)

I have written and run one that removed any "titles" on "podcasts" Back ache (talk) 07:43, 24 November 2023 (UTC)

Something wrong? Trade (talk) 23:46, 12 November 2023 (UTC)

no, just got some personal stuff going on Back ache (talk) 09:26, 13 November 2023 (UTC)

Do you have time to run a sccript that removes the "retrieved" qualifier? Trade (talk) 21:54, 18 November 2023 (UTC)

done Back ache (talk) 12:03, 27 November 2023 (UTC)

Any chance you could import review scores from Apple Podcasts?--Trade (talk) 10:45, 17 November 2023 (UTC)

That's a good idea, I will take a look , Back ache (talk) 17:18, 17 November 2023 (UTC)

Alright, would like to see some test edits if you figure it out Trade (talk) 01:00, 18 November 2023 (UTC)

Thankyou, this has been a lonely task at times :-) Back ache (talk) 15:42, 18 November 2023 (UTC)

Have done one test edit so far, on Bill Gates' new podcast https://www.wikidata.org/wiki/Q123470663 let me know what you think Back ache (talk) 22:57, 18 November 2023 (UTC)

Could make a test with the changes i made?Trade (talk) 16:35, 19 November 2023 (UTC)

Please stop the batch until you have fixed the constraint errors you are creating --Trade (talk) 21:56, 23 November 2023 (UTC)

what constraint errors? Let me know what they are or where they are listedBack ache (talk) 04:21, 24 November 2023 (UTC)

Part of it is that, in edits like this, you should be using retrieved (P813) as part of the reference, not as a qualifier of the statement.

More generally, you should be checking that any sort of mass-edit does not produce constraint violations or other errors before you make it. It does look like you've been adding some helpful info about podcasts, so that's appreciated, but when it's not formatted properly it creates additional work for others to clean up. {{u|Sdkb}} ^talk 06:33, 24 November 2023 (UTC)

Thanks for appreciating what I am doing, I have removed from the script the part that adds the retrieved (it was intended for the reference not the statement) and culled then re-added the "number of episodes" that were affected. Back ache (talk) 11:32, 27 November 2023 (UTC)

Podcasts with the statement URL (P2699) should be moved to exact match (P2888) instead Trade (talk) 10:45, 24 November 2023 (UTC)

Podcast tidy-up

They shouldn't use "name"

https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%22.%20%7D%0A%20%20%7B%0A%20%20%20%20SELECT%20DISTINCT%20%3Fitem%20WHERE%20%7B%0A%20%20%20%20%20%20%3Fitem%20p%3AP31%20%3Fstatement0.%0A%20%20%20%20%20%20%3Fstatement0%20%28ps%3AP31%2F%28wdt%3AP279%2a%29%29%20wd%3AQ24634210.%0A%20%20%20%20%20%20%3Fitem%20p%3AP2561%20%3Fstatement1.%0A%20%20%20%20%20%20%3Fstatement1%20%28ps%3AP2561%29%20_%3AanyValueP2561.%0A%20%20%20%20%7D%0A%20%20%20%20LIMIT%20100%0A%20%20%7D%0A%7D Back ache (talk) 04:46, 24 November 2023 (UTC)

Thx Trade (talk) 00:34, 25 November 2023 (UTC)

Their number of episodes shouldn't have a retrieved

SELECT ?item ?itemLabel ?number ?retrieved_as_qualifier WHERE {

 ?item wdt:P31  wd:Q24634210 . 
 ?item p:P1113 ?stat .
 ?stat ps:P1113 ?number .
 {?stat pq:P813 ?retrieved_as_qualifier.}
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } 

}

Podcasts should have an official website

SELECT DISTINCT ?item ?itemLabel WHERE {

 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
 {
   SELECT DISTINCT ?item WHERE {
     ?item p:P31 ?statement0.
     ?statement0 (ps:P31/(wdt:P279*)) wd:Q24634210.
     MINUS {
       ?item p:P856 ?statement1.
       ?statement1 (ps:P856) _:anyValueP856.
     }
   }
   LIMIT 100
 }

} Back ache (talk) 12:04, 27 November 2023 (UTC)

Apple Podcast review score

https://w.wiki/8RLw

SELECT DISTINCT ?item ?itemLabel WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
  {
    SELECT DISTINCT ?item WHERE {
      ?item p:P31 ?statement0.
      ?statement0 (ps:P31/(wdt:P279*)) wd:Q24634210.
      ?item p:P5842 ?statement1.
      ?statement1 (ps:P5842) _:anyValueP5842.
      MINUS {
        ?item p:P444 ?statement2.
        ?statement2 (ps:P444) _:anyValueP444.
      }
    }
    LIMIT 100
  }
}

Try it!

Could you fix them? Trade (talk) 09:56, 8 December 2023 (UTC)

oh no, what have a I broken now :-( ? Back ache (talk) 11:46, 8 December 2023 (UTC)

The score should look like this instead. I brought it up once before but you forgot to respond--Trade (talk) 12:17, 8 December 2023 (UTC)

ah, so it's just build and add an archive URL Back ache (talk) 17:13, 8 December 2023 (UTC)

And change the order of qualifiers and fill out the unit of number of reviews/ratings Trade (talk) 17:50, 8 December 2023 (UTC)

Did you ran into trouble? Trade (talk) 15:51, 20 December 2023 (UTC)

it's not obvious Back ache (talk) 17:18, 20 December 2023 (UTC)

What's not obvious? Trade (talk) 20:05, 20 December 2023 (UTC)

Telegram

Could i convince you to join the Wikiproject Podcasts telegram channel? It's not easy to communicate when responses takes so long Trade (talk) 01:17, 1 January 2024 (UTC)

I am already, I have been there a while but like the main talk page it does not seem to be very active. Back ache (talk) 14:28, 1 January 2024 (UTC)

Wikiproject Journalists

I've seen that you've contributed to  Wikidata:WikiProject Journalists.

I think it's worth developing the project. However, I suggest to expand the topic to either journalism or medias. What do you think? PAC2 (talk) 21:21, 20 April 2024 (UTC)

Stay focused on journalists, thats a big enough job in itself! Back ache (talk) 06:17, 21 April 2024 (UTC)

Of course but journalists work in media organisations. So it's relevant to document them. PAC2 (talk) 10:40, 21 April 2024 (UTC)

ISNI

1. all items about humans should have an ISNI, WMF should create a process with ISNI IA to achieve this
2. WD should
   1. fix on its side any constraint violations
   2. position the ISNI before VIAF and the VIAF section
   3. add more existing ISNI to existing items

ISNIplus (talk) 19:54, 17 June 2024 (UTC)

I think as the wikidata (and ISNI) community there are things we can do to help, the most obvious being identifying services that we can use to match an ID we already have for them to their ISNI, an example of this (in the other direction) is the following code that provides an ORCID for an ISNI https://github.com/ORCID-EU-Labs/ISNI-ORCID Back ache (talk) 08:05, 18 June 2024 (UTC)

"/"

maybe remove "/" from items like this https://www.wikidata.org/w/index.php?title=Q56755369&oldid=1706609032 159.205.181.252 19:55, 22 June 2024 (UTC)

Meh... you did something in this item, exept removing "/"... don't you see warning in this statement? ("The value for 500 Queer Scientists profile (anson-mackay/) should match the regex \w+.") Here's full report https://www.wikidata.org/wiki/Wikidata:Database_reports/Constraint_violations/P8243 159.205.181.252 12:17, 26 June 2024 (UTC)

Ouch! It probably just means the regex in the URL pattern needs tweaking, anyway it's midnight here and I will look at it tomorrow Back ache (talk) 23:01, 26 June 2024 (UTC)

anyway both the regex and those ID's are fixed now Back ache (talk) 10:25, 27 June 2024 (UTC)

Podcast episode count

Hi! Could you please correct or stop batch-adding number of episodes (P1113) for Ty & That Guy (Q105108860)? This edit has two problems:

• It adds a new value each time, while it should be one value updated instead, as both examples for this property show;
• It adds incorrect numbers — the general quantity, which is not equal to the latest episode's number. — Flipping Switches (talk) 22:50, 31 July 2024 (UTC)

I am currently sitting in a field listening to the recording a popular podcast bereft of both a computer and a decent connection so can not look at this right now.

I am part of the podcast group and the concept to the updates is to both to fill it as much metadata as possible for podcasts and to also help show which is "alive" and being updated and for which whose time has passed.

In regard to the accuracy of the count, the source of the data can be identified from the reference, in your case "apple podcasts".

I shall look at this on my return to civilisation. Back ache (talk) 15:31, 4 August 2024 (UTC)

The issue is that itunes (I guess a from their history as a music player) state the number of tracks as the total, which at the time of writing is 191. However the creators in the (freetext) title of the latest episode say episode 175.

Luckily I can see they do also say in their RSS feed <itunes:episode>175</itunes:episode> this is good, but won't be in place for all podcasts as the way each use RSS is a little "scrappy", I will look to write some kind of "cascade of truth" and with (if it's there) "itunes:episode" as #1 *if* (as in this case) it has one season as otherwise the number will be wrong.

I quite liked the fact that several point in times and the numbers were recorded as it gives an idea of a growth curve however I can see it could get out of control so will also look to code a cull of historic data.

I am a bit busy atm so probably won't be able to code anything for a few weeks but won't run the script before I do.

Thanks for taking the to me to write to me. Back ache (talk) 04:40, 7 August 2024 (UTC)

Thanks for taking time to look into the issue. Yes, I see they didn't use <itunes:episode> on every item even with the 160s, but <title> gives the number with /(?<=Ep\.? )\d+/. This podcast, or any other I'd imagine, wouldn't give a much interesting curve for this parameter (comparing to number of viewers/listeners (P5436) oder social media followers (P8687) growth, for example) - as so far, with the rare exception, they release one numbered episode every Wednesday. And considering that after both occasions of unnumbered reviewing a TV show season they just continued the regular numeration, there is some chance that it will never come to Season 2 of the podcast. Flipping Switches (talk) 12:21, 7 August 2024 (UTC)

True, the curve thing is nerdy where as the episode count does have mass interest. Back ache (talk) 13:05, 7 August 2024 (UTC)

I started randomly checking podcasts with different numbers of P1113 and notice more than one occasion of multiple point in time (P585) qualifiers for several properties, which don't make sense to me - 32 Minute (Q110556037) for example. Could you check them too on occasion? Flipping Switches (talk) 13:18, 7 August 2024 (UTC)

Can you share examples of how multiple values of P1113 are used?

Anyway, in w:uk:Шаблон:Подкаст this created an issue showing all values instead of the latest one. Flipping Switches (talk) 13:38, 7 August 2024 (UTC)

Once I have have updated the script I will (cautiously) be addressing this with all of them, I have also noticed a property called "publication interval" P2896 which could be interesting to compute and add Back ache (talk) 10:22, 8 August 2024 (UTC)

P.S. With the ratio close to 1 to 100 number of season looks like an unlikely problem. Flipping Switches (talk) 13:49, 7 August 2024 (UTC)