Seniority (sto_ansiennitet)
The table shows how many years and days each Storting representative and deputy representative has served in the Storting. The variable could have belonged to sto_representant, but with a frequent need for daily updates it is appropriate to have it in a separate table. The source is data.stortinget.no.
Updated from the table sto_Representant_1945- <yyyy>_<yyyy>-<mm>-<dd>$ in sto_ansiennitet oppdatering.sql.
Previously, seniority was stated in days, but now it is years and days. The starting point internally at the Stortingsarkivet is still days, but it is calculated on the basis that one year is 365.25 days. The presentation takes place in whole numbers. So how do we convert to days, which is what we want?
What corresponds to the Storting's own conversion from floating point numbers to whole numbers is to multiply the number of years by 365.25 and then round down to a whole number. Three years gives 1095 days; four gives 1461.
Since the Storting is the source, the data base is limited to representatives and deputy representatives from and including 1945. These include total seniority, also from before 1945. Representatives who have not been elected after 1945 are not included in this table.
Personal identification number (person)
Main index. Continuous internal identifier from the table i_politikere. Is mandatory and unique. Example: Tina Bru is 31610.
Seniority Full Years (ansiennitet_hele_år)
Number of full years of seniority as stated by the Storting's data service.
Seniority Remaining Days (ansiennitet_rest_dager)
Number of whole days remaining when seniority days are divided by 365.25. Provided by the Storting's data service.
Seniority Days (ansiennitet_dager)
Seniority in days, reconstructed on the basis of ansiennitet_hele_år and ansiennitet_rest_dager. See the introduction to the mathematics.
Dato (dato)
Date for downloading data from the Storting's data service. Will usually be the same for all representatives, but in the case of a quick update for data delivery, it may be an idea to only update existing representatives, and then the date will be different for those who have resigned.
Copyright © Sikt – Kunnskapssektorens tjenesteleverandør • Kontakt SIKT • Personvernerklæring Versjon 1.1 • Accessibility Statement (in Norwegian)