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'.
Main index. Continuous internal identifier from the table i_politikere. Is mandatory and unique. Example: Tina Bru is 31610.
What the activity is about, for example ‘Medlem’ or ‘Varaordfører’.
Location of the activity, such as ‘Fylkesting’, ‘Fylkesutvalg’ etc.
County number at the start of the period. The format is integer, which means that any leading 0 is not applied initially.
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 in the role. Is NULL if the year is not specified.
Last year in the role. Is NULL if the year is not specified.
Additional information.
Where the information comes from, if known. Typical values are 'Haffner', 'Lindstøl', 'Politikerarkivet 1814-1986' and 'Stortinget'.