DATA ON THE POLITICAL SYSTEM

Political activity at the county municipal level (pol_fylpol_aktivitet)

Politicians' county political activity 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:

The table Pol_Bakgrunn has been examined, but is completely covered, and better, by the other tables.

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.

Role (rolle)

What the activity is about, for example ‘Medlem’ or ‘Varaordfører’.

Organ (organ)

Location of the activity, such as ‘Fylkesting’, ‘Fylkesutvalg’ etc.

County (fylke)

County number at the start of the period. The format is integer, which means that any leading 0 is not applied initially.

County name (fylkesnavn)

The name of the county if stated in the base material. Should not be used actively, but is included as a variable in case of problems with identification of historic counties by county number.

First year (fra_år)

First year in the role. Is NULL if the year is not specified.

Last year (til_år)

Last year in the role. Is NULL if the year is not specified.

Note (merknad)

Additional information.

Source (kilde)

Where the information comes from, if known. Typical values are 'Haffner', 'Lindstøl', 'Politikerarkivet 1814-1986' and 'Stortinget'.