En titles for works

[duncdrum]

This issue supersedes #236 our longest standing open issue.

Here is a list of works for which we are lacking english language titles.
Often this will be due to the fact that the original work is e.g. french, nevertheless not having en titles makes querying the data rather complex, and use unfriendly.

We should make an attempt at batch retrieving english titles for these works from wikidata, or to use a translation service to augment existing entries.

The Work.language field could then hold information about original language of the work in question. It's current description:

not necessarily the original language, but the first tag for sorting purposes

Now the tricky part is maintaining our ability to follow translation flows. A work introduced in China might be translation of a Japanese translation of e.g. Moby Dick.

This requires some more thought, but I'm beginning to think that for works, we might want to refactor the respective tables slightly to reduce the number of duplicate rows,
and to be able to more succinctly differentiate works which are translations, and our translations of work titles for display purposes. We also need to consider how changes to works are reflected across all three sub-tables (W, PS, SS, AW).

List

• W0007
• W0012
• W0013
• W0014
• W0015
• W0017
• W0018
• W0023
• W0037
• W0039
• W0050
• W0051
• W0052
• W0074
• W0075
• W0083
• W0084
• W0089
• W0090
• W0091
• W0094
• W0103
• W0107
• W0119
• W0133
• W0142
• W0148
• W0150
• W0169
• W0170
• W0171
• W0173
• W0177
• W0178
• W0180
• W0181
• W0183
• W0192
• W0195
• W0208
• W0217
• W0218
• W0220
• W0232
• W0242
• W0244
• W0258
• W0259
• W0260
• W0261
• W0262
• W0263
• W0265
• W0378
• W0379
• W0380*
• W0383
• W0384*
• W0394*
• W0396*
• W0398
• W0399*
• W0400
• W0402*
• W0404
• W0405*
• W0409
• W0415
• W0421
• W0423
• W0424
• W0440
• W0525
• W0545
• W0556
• W0583
• W0587
• W0619
• W0622
• W0623
• W0624
• W1000
• W1001

work-ids with a * are also missing pinyin transliterations.