Awards (pol_utmerkelser)

Politicians' awards is a field where we must expect large gaps in the data material. Duplicates cannot be avoided either, as the information comes from several older database tables.

sto_UtdanningYrke$ – deals with Storting politicians and is taken from data.stortinget.no. This is probably the most important source and the only one that is updated. Data from 1901 onwards.
B1905_Utdyrke - primarily contains information for representatives who have had a seat in the Storting 1903-1945. There are timed registrations in the period 1850-1938.

Updates will typically take place every four years after a new parliamentary term has been established. The SQL script for this update has not yet been created at the time of writing, but will be able to start by comparing new data with the records we have with source 'Stortinget'.

Personal identification number (person)

Main index. Continuous internal identifier from the table i_politikere. Is mandatory and unique. Example: Tina Bru is 31610.

Award (utmerkelse)

The award in plain text.

Year (år)

Year of the award. Is NULL if the year is not specified.

Note (merknad)

Additional information.

Source (kilde)