Research in programming Wikidata/Radio programs

A radio program is a mass medium, which is a collection of sound messages and materials. This article is devoted to the study of radio programs based on the Wikidata. For the research, SPARQL queries, working with objects of the "radio program" type, are designed. A list of all the radio programs described in the Wikidata is obtained. Three good and bad objects were singled out, the latter subsequently being filled. In the article there is a result of the analysis of the completeness of the Wikidata, as well as a hundred of Russian radio programs with a link to the country and genre.

Instances of the object "radio programs"
Let's build a list of all radio programs in English.
 * Object: radio program (Q1555508).
 * Property: instance of (P31).

SPARQL-query, 5249 results.

"Good" and "bad" objects "radio programs"
Let's build a list of all radio programs related to Russia.

SPARQL-query, 68 results.

Examples of good, complete radio program are:


 * 1) Miranda;
 * 2) Opry;
 * 3) This American Life.

Examples of bad, incomplete radio program were:


 * 1) Radionyanya;
 * 2) In the work at noon;
 * 3) Moon-44.

Filling in the genre and linking to radio stations
Fill in a hundred objects of radio programs and specify in each of them a binding to the country and genre.

SPARQL-query, 138 results are 5.11 .17.

SPARQL-query, 240 results are 13.11 .17.



The script below shows only radio programs related to Russia.

SPARQL-query, 110 results on the 26.11.17.



The figure above describes the relationship of Russian radio programs with their corresponding genres.

Completeness of Wikidata
There are more than 51,000 radio stations in the world in accordance with the radio portal Radio.ru, in 2017. Thus, even if there is at least one radio broadcast on each of them, it is at least 51 thousand programs. By results of the query that counted the radio programs of the whole world, it turned out to be only 5152 radio programs. In other words, there was only one tenth of the actual number of radio programs, which shows the incompleteness of the Wikidata.

If we talk only about Russian radio programs, then query produces only 5249 results, in the same time it is writen on the portal Radio.ru that the largest number of network radio stations in 2015 is in Ekaterinburg — 36 stations, and this is only one city. There are 1124 cities in Russia.

Future work

 * 1) Find the most frequent first letter in title of stations (English alphabet).
 * 2) Find programs with the number of dictors = 1, more than 1. The results should be presented on a histogram.
 * 3) Display pictures (images) of radio programs for children.

Exercises
{Select the most popular genres of radio in Russia? + Music; - Children's radio; + Entertainment; - Sports.
 * type="[]"}

{How many radios existed in the world in 2017? - 27 000; - 44 000; + 51 000.
 * type=""}

{A radio program is - application to the phone; + mass media; - a tape recorder in the car.
 * type=""}