Skip to content

Sample file specifications🔗

Import fields🔗

Default values are applied when the values are left empty.

idno🔗

ESS Panelist identification number (ESS IDNO).

Required

  • Number (max length: 12)

name🔗

Optional | Default: empty

  • Free text

surname🔗

Optional | Default: empty

  • Free text

sex🔗

Required

  • 1 âžœ Male
  • 2 âžœ Female
  • 3 âžœ Other
  • 7 âžœ Refusal
  • 8 âžœ Don't know
  • 9 âžœ No answer

email🔗

Panelist email address.

Required if mobile is empty | Default: empty

  • Email address. It is used by panelists to (optionnally) login to WPSS. It is case sensitive.

mobile🔗

Panelist mobile phone number.

Required if email is empty | Default: empty Text format of the form: + XX YYYYYYYYYY where

  • XX is the country calling code
  • YYYYYYYYYY is the mobile phone number without trailing zero

e.g. +442012345677

propertyname🔗

Name of Property.

Optional | Default: empty

  • Free text

number🔗

Optional | Default: empty

  • Free text

address🔗

Optional | Default: empty

  • Free text

address2🔗

Optional | Default: empty

  • Free text

city🔗

Optional | Default: empty

  • Free text

county🔗

Optional | Default: empty

  • Free text

postcode🔗

Optional | Default: empty

  • Free text

cntry🔗

Country code.

Required

  • AT âžœ Austria
  • BE âžœ Belgium
  • BG âžœ Bulgaria
  • CZ âžœ Czechia
  • HR âžœ Croatia
  • CY âžœ Cyprus
  • EE âžœ Estonia
  • FI âžœ Finland
  • FR âžœ France
  • DE âžœ Germany
  • HU âžœ Hungary
  • IS âžœ Iceland
  • IE âžœ Ireland
  • IT âžœ Italy
  • LV âžœ Latvia
  • LT âžœ Lithuania
  • NL âžœ The Netherlands
  • NO âžœ Norway
  • PL âžœ Poland
  • PT âžœ Portugal
  • SK âžœ Slovakia
  • SI âžœ Slovenia
  • SE âžœ Sweden
  • GB âžœ United Kingdom
  • CH âžœ Switzerland
  • AL âžœ Albania
  • DK âžœ Denmark
  • IL âžœ Israel
  • ME âžœ Montenegro
  • RS âžœ Serbia
  • ES âžœ Spain
  • GR âžœ Greece
  • XK âžœ Kosovo
  • LU âžœ Luxembourg
  • RO âžœ Romania
  • RU âžœ Russia
  • TK âžœ Turkey
  • UA âžœ Ukraine

lng🔗

Panelist language code.

Required

  • CS âžœ Czech
  • DE âžœ German
  • EN âžœ English
  • FI âžœ Finnish
  • FR âžœ French
  • BE-FR âžœ French (Belgium)
  • HU âžœ Hungarian
  • ISL âžœ Icelandic
  • IT âžœ Italian
  • SL âžœ Slovenian
  • SV âžœ Swedish
  • FI-SV âžœ Swedish (Finland)
  • PT âžœ Portuguese
  • BE-NL âžœ Flemish (Belgium)
  • ISL-PL âžœ Polish (Island)

netusoft🔗

Internet use, how often.

Required

  • 1 âžœ Never
  • 2 âžœ Only occasionally
  • 3 âžœ A few times a week
  • 4 âžœ Most days
  • 5 âžœ Every day
  • 7 âžœ Refusal
  • 8 âžœ Don't know
  • 9 âžœ No answer

eduyrs🔗

Years of full-time education completed.

Required

  • 77 Refusal
  • 88 Don't know
  • 99 No answer

dybrn🔗

Day of birth.

Required

  • Value between 1 and 31
  • 77 âžœ Refusal
  • 88 âžœ Don't know
  • 99 âžœ No answer

mthbrn🔗

Month of birth.

Required

  • Value between 1 and 12
  • 77 âžœ Refusal
  • 88 âžœ Don't know
  • 99 âžœ No answer

yrbrn🔗

Year of birth.

Required

  • Value between 1905 and 2005
  • 7777 âžœ Refusal
  • 8888 âžœ Don't know
  • 9999 âžœ No answer

opto🔗

Panelist opted out.

If set to 1 or checked in WPSS, individual links will no longer be generated for this panelist and no messages will be sent to them. If changed back to 0 or unchecked in WPSS, the panelist will be able to participate to next surveys (when new individual links are generated for them).

Optional | Default: 0

  • 0 âžœ do nothing or opts the panelist in if they were out
  • 1 âžœ opts the panelist out

dopto🔗

Date panelist opted out.

Optional if is_opt_out is 0 | Default: empty

  • Date (format: DDMMYYYY)

ropto🔗

Reason(s) why panelist opts out.

Optional if is_opt_out is 0 | Default: empty

  • Free text

delcontactdata🔗

Panelist requests contact data to be deleted.

Optional | Default: 0

  • 0 âžœ do nothing
  • 1 âžœ the panelist asked to delete their data

delsurveydata🔗

Panelist requests survey data to be deleted.

Optional | Default: 0

  • 0 âžœ do nothing
  • 1 âžœ the panelist asked to delete their data

movcntry🔗

Panelist moved out of country.

Optional | Default: 0

  • 0 âžœ do nothing
  • 1 âžœ the panelist is out of the country

noincen🔗

Panelist does not want incentives.

Optional | Default: 0

  • 0 âžœ do nothing
  • 1 âžœ the panelist does not want incentives

nolett🔗

Panelist does not want letters.

Optional | Default: 0

  • 0 âžœ do nothing
  • 1 âžœ the panelist does not want to receive letters

notxt🔗

Panelist does not want text messages.

Optional | Default: 0

  • 0 âžœ do nothing
  • 1 âžœ the panelist does not want to receive text messages

noem🔗

Panelist does not want emails.

Optional | Default: 0

  • 0 âžœ do nothing
  • 1 âžœ the panelist does not want to receive emails

Export fields🔗

The export fields are the same as the import fields. However there is an option to export with additional variables that are the following.

dob🔗

Date of birth.

Format: DDMMYYYY

age🔗

Age of respondent (calculated).

  • 999 âžœ Not available

agegrp🔗

Age group of respondent.

  • 1 âžœ 18-24
  • 2 âžœ 25-34
  • 3 âžœ 35-44
  • 4 âžœ 45-54
  • 5 âžœ 55-64
  • 6 âžœ 65-74
  • 7 âžœ 75+
  • 9 âžœ Not available

uid🔗

Computed variable.

  • Concatenation of cntry and ess_id

emailpres🔗

Email address present in sample file.

  • 0 âžœ not present
  • 1 âžœ present

mobilepres🔗

Mobile phone number present in sample file.

  • 0 âžœ not present
  • 1 âžœ present

addresspres🔗

Address present in sample file.

  • 0 âžœ not present
  • 1 âžœ present

anonsince🔗

Date of anonymization.

falseemail🔗

If the email is false (result of anonymization).

  • 0 âžœ not false
  • 1 âžœ false

panel🔗

Panel name (as set by study coordinators).