Variables
# | favorite | Variable | Original name | Description | Concept | Type | Key | Business key | Foreign key | FK ← | In | Out | Rows | Stats | Missing | Duplicates | Nb val. | Values | Frequency | Enumeration | Tags | Dataset | Folder | Provider | Manager | Start | End |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
# | favorite | Variable | Original name | Description | Concept | Type | Key | Business key | Foreign key | FK ← | In | Out | Rows | Stats | Missing | Duplicates | Nb val. | Values | Frequency | Enumeration | Tags | Dataset | Folder | Provider | Manager | Start | End |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ANNEE | Reference year for the internet-use survey. | number |
|
|
| 2006/10 | ||||||||||||||||||||
| 2 | TRANCHE_AGE | Age group of respondents (15-24, 25-34, etc.). | text |
|
|
|
|
| 2020 | ||||||||||||||||||
| 3 | SEXE | Respondents' sex: male, female, other/do not know. | text |
|
|
|
|
| 1996 | ||||||||||||||||||
| 4 | REGION | Region or major region (CH05, CH07, etc.). | text |
|
|
|
| 2016/08/13 | |||||||||||||||||||
| 5 | FREQ_UTIL | Usage frequency: daily, weekly, rare, etc. | text |
|
|
|
|
| 2015/07 | ||||||||||||||||||
| 6 | H_SEMAINE | Number of hours of use per week. | decimal |
|
|
|
|
| 1999/07 | ||||||||||||||||||
| 7 | ACTIVITE_PRINC | Main activity performed online (social networks, news, shopping, etc.). | text |
|
|
|
| 1997 | |||||||||||||||||||
| 8 | EQUIPEMENT | Device used: smartphone, PC, tablet, etc. | text |
|
|
|
| 2010 | |||||||||||||||||||
| 9 | CONN_DOM | Indicates whether the household has an internet connection. | boolean |
|
|
|
|
| 2016 | ||||||||||||||||||
| 10 | CONN_MOB | Internet access via mobile network. | boolean |
|
|
|
|
| 2008 | ||||||||||||||||||
| 11 | COMP_NUM | Digital skills index (0-100). | decimal |
|
|
|
|
| 2009 | ||||||||||||||||||
| 12 | NB_APPLI | Total number of applications used regularly. | number |
|
|
|
|
| |||||||||||||||||||
| 13 | ACHATS_ONLINE | Indicates whether the person made online purchases. | boolean |
|
|
|
|
| 2010 | ||||||||||||||||||
| 14 | STREAM_VIDEO | Use of video streaming services. | boolean |
|
|
|
|
| 2010/04/01 | ||||||||||||||||||
| 15 | SOCIAL_MEDIA | Indicates whether the user uses social networks. | boolean |
|
|
|
|
| 2024/07 | ||||||||||||||||||
| 16 | CONFIANCE | Level of trust in internet use (0-100). | decimal |
|
|
|
|
|
| 2020/05 | |||||||||||||||||
| 17 | SOURCE_DONNEE | Data origin (OPET, FSO, partners, etc.). | text |
|
|
|
|
| 1998 | ||||||||||||||||||
| 18 | ANNEE | Reference year for demographic data. | number |
|
|
|
|
| 2020/07/02 | 2009/03 | |||||||||||||||||
| 19 | REGION | Administrative or statistical region. | text |
|
|
|
|
|
|
| 1997 | 1995/08 | |||||||||||||||
| 20 | CANTON | Canton to which the region belongs. | text |
|
|
|
|
|
| 2011/11/17 | 1996/08/14 | ||||||||||||||||
| 21 | POP_TOTALE | Total resident population in the region. | number |
|
|
|
|
| 1996/06 | 2018/04/20 | |||||||||||||||||
| 22 | POP_SUISSE | People of Swiss nationality in the region. | number |
|
|
|
| 2017 | 1999 | ||||||||||||||||||
| 23 | POP_ETR | People of foreign nationality in the region. | number |
|
|
|
|
| 1995/02 | 2008 | |||||||||||||||||
| 24 | DENSITE | Number of inhabitants per km2. | decimal |
|
|
|
|
| 2015/06 | 2010 | |||||||||||||||||
| 25 | AGE_MEDIAN | Median age of the population in the region. | decimal |
|
|
|
| 2017/11/24 | 2004 | ||||||||||||||||||
| 26 | PART_65_PLUS | Share of the population aged 65 or older (%). | decimal |
|
|
|
|
| 2021 | 2017/03/04 | |||||||||||||||||
| 27 | PART_0_14 | Share of the population aged 0 to 14 (%). | decimal |
|
|
|
|
| 2000/04 | 2023/02 | |||||||||||||||||
| 28 | SUPERFICIE_KM2 | Total area of the region in km2. | decimal |
|
|
|
| 1996/11 | 1995/04/11 | ||||||||||||||||||
| 29 | ALT_MOY | Average altitude of the region (m). | number |
|
|
|
|
| 2010/09/28 | 2004/03/23 | |||||||||||||||||
| 30 | COORD_X | Projected geographic coordinate (CH1903+ / LV95). | decimal |
|
|
|
|
| 2021 | ||||||||||||||||||
| 31 | COORD_Y | Projected geographic coordinate (CH1903+ / LV95). | decimal |
|
|
|
|
|
| 2023/12/27 | 1999/09 | ||||||||||||||||
| 32 | TYPE_REGION | Typology: urban, peri-urban, rural, mountain, etc. | text |
|
|
|
|
|
| 1998 | 1996/03/20 | ||||||||||||||||
| 33 | TAUX_CROISS_DEMO | Annual population change (%). | decimal |
|
|
|
| 1997/04/07 | 2020/08/17 | ||||||||||||||||||
| 34 | SOURCE_DONNEE | Data origin (statistical office, municipalities, registers). | text |
|
|
|
|
| 2014/08/07 | 2004/11 | |||||||||||||||||
| 35 | DATE | Date of the pollution reading. | date |
|
| 5/22/2020 — 3/22/2026 avg. 9/22/2024 ±0 d |
|
| 2004/01/08 | ||||||||||||||||||
| 36 | HEURE | Local time of measurement. | date-time |
|
|
|
|
| 1995 | ||||||||||||||||||
| 37 | STATION | Urban station that performed the measurement. | text |
|
|
|
| 2016/10 | |||||||||||||||||||
| 38 | POLLUANT | Type of pollutant analyzed (PM2.5, PM10, NO2, O3, etc.). | text |
|
|
|
| 2017/02 | |||||||||||||||||||
| 39 | CONCENTRATION | Pollutant concentration (ug/m3). | decimal |
|
|
|
|
| 2019/12 | ||||||||||||||||||
| 40 | UNITE | Measurement unit (ug/m3). | text |
|
|
|
|
| 2020 | ||||||||||||||||||
| 41 | TEMP | Ambient temperature at the time of reading (deg C). | decimal |
|
|
|
|
|
| 1998/01/08 | |||||||||||||||||
| 42 | HUMIDITE | Air humidity (%). | decimal |
|
|
|
| 2008/12/19 | |||||||||||||||||||
| 43 | VENT_VIT | Wind speed (km/h). | decimal |
|
|
|
|
| 2017 | ||||||||||||||||||
| 44 | VENT_DIR | Prevailing wind direction (N, NE, E, etc.). | text |
|
|
|
|
| 1996 | ||||||||||||||||||
| 45 | PRESSION_ATM | Atmospheric pressure (hPa). | decimal |
|
|
|
|
| 2017/03/25 | ||||||||||||||||||
| 46 | PRECIP | Amount of precipitation (mm). | decimal |
|
|
|
| 2020/06 | |||||||||||||||||||
| 47 | IQA | Overall index based on Swiss standards. | number |
|
|
|
| 2020/01/20 | |||||||||||||||||||
| 48 | NIVEAU_ALERTE | Alert level: normal, moderate, high, very high. | text |
|
|
|
|
| 2004/06/11 | ||||||||||||||||||
| 49 | ZONE_URBAINE | Relevant district or urban area. | text |
|
|
|
|
| 2022 | ||||||||||||||||||
| 50 | TRAFIC_LOCAL | Index estimating local traffic intensity. | decimal |
|
|
|
| 2002/12/12 | |||||||||||||||||||
| 51 | SRC_STATION | Estimated contribution from fixed sources (industries, etc.). | decimal |
|
|
|
|
|
| 1999/06 | |||||||||||||||||
| 52 | SRC_MOB | Estimated contribution from vehicles. | decimal |
|
|
|
| 2007 | |||||||||||||||||||
| 53 | COND_METEO | Weather summary: clear, cloudy, rain, fog, etc. | text |
|
|
|
| 2024/07 | |||||||||||||||||||
| 54 | BRUIT | Noise level in dB. | decimal |
|
|
|
|
| 2002/02/28 | ||||||||||||||||||
| 55 | SOURCE_DONNEE | Data origin (FOEN, cantonal stations, etc.). | text |
|
|
|
|
|
| 2004 | |||||||||||||||||
| 56 | ANNEE | Year in which temperatures were measured. | number |
|
|
|
| 1999/03/01 | 2001 | ||||||||||||||||||
| 57 | MOIS | Month of the year (January-December). | text |
|
|
|
|
| 1999/07 | 2015/01/11 | |||||||||||||||||
| 58 | STATION | Relevant meteorological station. | text |
|
|
|
|
| 2021/10 | 2016 | |||||||||||||||||
| 59 | ALTITUDE_STATION | Altitude of the measurement station in meters. | number |
|
|
|
|
| 2004/03 | 2012/07/17 | |||||||||||||||||
| 60 | TEMP_MOY | Monthly average temperature (deg C). | decimal |
|
|
|
|
|
| 2001/04 | 2014/04 | ||||||||||||||||
| 61 | TEMP_MIN | Minimum temperature of the month (deg C). | decimal |
|
|
|
|
|
| 2024 | |||||||||||||||||
| 62 | TEMP_MAX | Maximum temperature of the month (deg C). | decimal |
|
|
|
|
| 2001/11 | 2001/07 | |||||||||||||||||
| 63 | DEV_NORMALE | Difference from the climate normal (deg C). | decimal |
|
|
|
| 2023 | 2013 | ||||||||||||||||||
| 64 | PRECIP_MENS | Monthly precipitation total (mm). | decimal |
|
|
|
|
| 2001 | 2013/01 | |||||||||||||||||
| 65 | NB_JOURS_GEL | Number of days with temperature below 0 deg C. | number |
|
|
|
|
|
| 2016/10/13 | 2007/08 | ||||||||||||||||
| 66 | NB_JOURS_ETE | Number of days with temperature at or above 25 deg C. | number |
|
|
|
|
| 2024/06 | 2013 | |||||||||||||||||
| 67 | NB_JOURS_TRES_CHAUD | Number of days at or above 30 deg C. | number |
|
|
|
|
| 2022/12/20 | 2008/02/02 | |||||||||||||||||
| 68 | HUMIDITE_MOY | Average relative humidity for the month (%). | decimal |
|
|
|
| 2024/10/23 | 2016/02 | ||||||||||||||||||
| 69 | PRESSION_MOY | Average atmospheric pressure (hPa). | decimal |
|
|
|
| 2022/01 | 2024/04 | ||||||||||||||||||
| 70 | ENSOLEILLEMENT | Total sunshine duration (hours). | decimal |
|
|
|
|
| 1995 | 1995/07 | |||||||||||||||||
| 71 | RAY_SOL | Received solar radiation (MJ/m2). | decimal |
|
|
|
| 2024 | 2001/10/10 | ||||||||||||||||||
| 72 | DIR_VENT | Prevailing wind direction (N, NE, E, etc.). | text |
|
|
|
| 2007/07/06 | 2013/12 |
0