To download the data set, please sign up or log in
001 -- Kuntasektorin kuukausipalkat ammateittain vuonna 2007
Tables
-
Dim ammattinimike, Statfinpas ksp pxt 001 200700 fi px, Full historyTSV
Dimension Ammattinimike (Ammattinimike)
-
Dim ammattinimike, Statfinpas ksp pxt 001 200700 fi px, LatestTSV
Dimension Ammattinimike (Ammattinimike)
-
Dim sukupuoli, Statfinpas ksp pxt 001 200700 fi px, Full historyTSV
Dimension Sukupuoli (Sukupuoli)
-
Dim sukupuoli, Statfinpas ksp pxt 001 200700 fi px, LatestTSV
Dimension Sukupuoli (Sukupuoli)
-
Dim tiedot, Statfinpas ksp pxt 001 200700 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
-
Dim tiedot, Statfinpas ksp pxt 001 200700 fi px, LatestTSV
Dimension Tiedot (Tiedot)
-
Fact, Statfinpas ksp pxt 001 200700 fi px, Full historyTSV
Kuntasektorin kuukausipalkat ammateittain vuonna 2007 muuttujina Ammattinimike, Sukupuoli ja Tiedot
-
Fact, Statfinpas ksp pxt 001 200700 fi px, LatestTSV
Kuntasektorin kuukausipalkat ammateittain vuonna 2007 muuttujina Ammattinimike, Sukupuoli ja Tiedot
Column Descriptions
Dim tiedot, Statfinpas ksp pxt 001 200700 fi px, Full history
| Column | Type | Comment |
|---|---|---|
| code | string | The code for the dimension value. Column code has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kans_cv and maximum string is Kans_p90. |
| label | string | The label for the dimension value. Column label has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Kokoaikaisten lukumäärä... and first 25 characters of maximum string: Kokonaisansion variaatiok... |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Dim sukupuoli, Statfinpas ksp pxt 001 200700 fi px, Full history
| Column | Type | Comment |
|---|---|---|
| code | int | The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2. |
| label | string | The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Miehet and maximum string is Naiset. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Fact, Statfinpas ksp pxt 001 200700 fi px, Latest
| Column | Type | Comment |
|---|---|---|
| ammattinimike | string | Datasource did not contain a description for Ammattinimike. Column ammattinimike has 32676 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aikuiskoulutuskeskuksenop... and first 25 characters of maximum string: Äänenjohtaja... |
| sukupuoli | string | Datasource did not contain a description for Sukupuoli. Column sukupuoli has 32676 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is 2. |
| tiedot | string | Datasource did not contain a description for Tiedot. Column tiedot has 32676 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kans_cv and maximum string is Kans_p90. |
| kuntasektorin_kuukausipalkat_ammateittain_vuonna_2007 | int | Datasource did not contain a description for Kuntasektorin_kuukausipalkat_ammateittain_vuonna_2007. Column kuntasektorin_kuukausipalkat_ammateittain_vuonna_2007 has 32676 rows, out of which 10754 are empty, making the null percent 32.91. Minimum value is 1 and maximum value is 407188. |
Dim tiedot, Statfinpas ksp pxt 001 200700 fi px, Latest
| Column | Type | Comment |
|---|---|---|
| code | string | The code for the dimension value. Column code has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kans_cv and maximum string is Kans_p90. |
| label | string | The label for the dimension value. Column label has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Kokoaikaisten lukumäärä... and first 25 characters of maximum string: Kokonaisansion variaatiok... |
Dim sukupuoli, Statfinpas ksp pxt 001 200700 fi px, Latest
| Column | Type | Comment |
|---|---|---|
| code | int | The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2. |
| label | string | The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Miehet and maximum string is Naiset. |
Dim ammattinimike, Statfinpas ksp pxt 001 200700 fi px, Latest
| Column | Type | Comment |
|---|---|---|
| code | string | The code for the dimension value. Column code has 778 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aikuiskoulutuskeskuksenop... and first 25 characters of maximum string: Äänenjohtaja... |
| label | string | The label for the dimension value. Column label has 778 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aikuiskoulutuskeskuksenop... and first 25 characters of maximum string: Äänenjohtaja... |
Dim ammattinimike, Statfinpas ksp pxt 001 200700 fi px, Full history
| Column | Type | Comment |
|---|---|---|
| code | string | The code for the dimension value. Column code has 778 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aikuiskoulutuskeskuksenop... and first 25 characters of maximum string: Äänenjohtaja... |
| label | string | The label for the dimension value. Column label has 778 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aikuiskoulutuskeskuksenop... and first 25 characters of maximum string: Äänenjohtaja... |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Fact, Statfinpas ksp pxt 001 200700 fi px, Full history
| Column | Type | Comment |
|---|---|---|
| ammattinimike | string | Datasource did not contain a description for Ammattinimike. Column ammattinimike has 32676 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aikuiskoulutuskeskuksenop... and first 25 characters of maximum string: Äänenjohtaja... |
| sukupuoli | string | Datasource did not contain a description for Sukupuoli. Column sukupuoli has 32676 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is 2. |
| tiedot | string | Datasource did not contain a description for Tiedot. Column tiedot has 32676 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kans_cv and maximum string is Kans_p90. |
| kuntasektorin_kuukausipalkat_ammateittain_vuonna_2007 | int | Datasource did not contain a description for Kuntasektorin_kuukausipalkat_ammateittain_vuonna_2007. Column kuntasektorin_kuukausipalkat_ammateittain_vuonna_2007 has 32676 rows, out of which 10754 are empty, making the null percent 32.91. Minimum value is 1 and maximum value is 407188. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
| Last Updated | August 4, 2019 |
|---|---|
| Created | August 2, 2019 |