File formats - Revision history

Nils Duepont: /* Mandatory columns for the dyadic data template */

2024-11-29T10:46:42Z

‎Mandatory columns for the dyadic data template

2024-11-29T10:46:32Z

‎Mandatory columns for the monadic data template

2024-11-29T10:46:01Z

‎Mandatory columns for the dyadic data template

2024-11-29T10:45:28Z

‎Mandatory columns for the monadic data template

2024-09-12T18:11:41Z

‎Mandatory columns for the dyadic data template

2024-09-12T18:11:10Z

‎Mandatory columns for the monadic data template

2024-06-11T09:38:38Z

‎Mandatory columns for the dyadic data template

2024-06-11T09:38:32Z

‎Mandatory columns for the monadic data template

2024-06-11T07:55:49Z

‎Mandatory columns for the dyadic data template

2024-06-11T07:55:00Z

‎Mandatory columns for the monadic data template

@@ Line 125: / Line 125: @@
 |}
-<sup>1</sup> Note that binary is used as a strict boolean type with allowed values of <code>0/1</code> or <code>true/false</code>; if you have a binary indicator but want to use "user-defined missing values", you have to choose "Multinomial" as scale.
+<sup>1</sup> Note that binary is used as a strict boolean type with allowed values of <code>0/1</code> or <code>true/false</code>; if you have a binary indicator but want to use "user-defined missing values", you have to choose "Multinomial" as <code>scale</code>.
 <sup>2</sup> If multiple concerns are raised for the focal value, only the most prevalent one is coded. If you choose "Other" as the response, it is recommended to provide an explanation in the [[Optional_column_names|optional column]] <code>comment</code>.

@@ Line 73: / Line 73: @@
 |}
-<sup>1</sup> Note that binary is used as a strict boolean type with allowed values of <code>0/1</code> or <code>true/false</code>; if you have a binary indicator but want to use "user-defined missing values", you have to choose "Multinomial" as scale.
+<sup>1</sup> Note that binary is used as a strict boolean type with allowed values of <code>0/1</code> or <code>true/false</code>; if you have a binary indicator but want to use "user-defined missing values", you have to choose "Multinomial" as <code>scale</code>.
 <sup>2</sup> If multiple concerns are raised for the focal value, only the most prevalent one is coded. If you choose "Other" as the response, it is recommended to provide an explanation in the [[Optional_column_names|optional column]] <code>comment</code>.

@@ Line 96: / Line 96: @@
 |value||7||yes||Numeric, string or date time||The actual value of the indicator||Always use the dot (.) as the decimal separator for numeric data. For dates follow the [[Coding_rules|date time format]].
 |-
-|user_na_values||8||yes||Symbol||Flag for "missing data"||In principle, you can use an exclamation mark (!) to flag any value(s) as [[File_upload_guide#Uploading_.22missing.22_or_N.2FA_values|"missing data"]]. [[Missing_values|Certain codes]] are strongly recommended, though. The default is a blank cell/column.
+|user_na_values||8||yes||Symbol||Flag for "missing data"||In principle, you can use an exclamation mark (!) to flag any value(s) as [[File_upload_guide#Uploading_.22missing.22_or_N.2FA_values|"missing data"]] . [[Missing_values|Certain codes]] are strongly recommended, though, and the values have to be of the same type as <code>value</code>. The default is a blank cell/column.
 |-
 |unit||9||yes||String||The unit of ''value''||For dates the unit is "date", otherwise name the actual unit of the value (e.g. "per 1000 inhabitants", "as % of GDP" etc.)

@@ Line 44: / Line 44: @@
 |value||5||yes||Numeric, string or date||The actual value of the indicator||Always use the dot (.) as the decimal separator for numeric data. For dates follow the [[Coding_rules|date time format]].
 |-
-|user_na_values||6||yes||Symbol||Flag for "missing data"||In principle, you can use an exclamation mark (!) to flag any value(s) as [[File_upload_guide#Uploading_.22missing.22_or_N.2FA_values|"missing data"]]. [[Missing_values|Certain codes]] are strongly recommended, though. The default is a blank cell/column.
+|user_na_values||6||yes||Symbol||Flag for "missing data"||In principle, you can use an exclamation mark (!) to flag any value(s) as [[File_upload_guide#Uploading_.22missing.22_or_N.2FA_values|"missing data"]] . [[Missing_values|Certain codes]] are strongly recommended, though, and the values have to be of the same type as <code>value</code>. The default is a blank cell/column.
 |-
 |unit||7||yes||String||The unit of ''value''||For dates the unit is "date", otherwise name the actual unit of the value (e.g. "per 1000 inhabitants", "as % of GDP" etc.)

@@ Line 96: / Line 96: @@
 |value||7||yes||Numeric, string or date time||The actual value of the indicator||Always use the dot (.) as the decimal separator for numeric data. For dates follow the [[Coding_rules|date time format]].
 |-
-|user_na_values||8||yes||Symbol||Flag for "missing data"||Use an exclamation mark (!) to flag any value(s) as [[File_upload_guide#Uploading_.22missing.22_or_N.2FA_values|"missing data"]]. The default is a blank cell/column.
+|user_na_values||8||yes||Symbol||Flag for "missing data"||In principle, you can use an exclamation mark (!) to flag any value(s) as [[File_upload_guide#Uploading_.22missing.22_or_N.2FA_values|"missing data"]]. [[Missing_values|Certain codes]] are strongly recommended, though. The default is a blank cell/column.
 |-
 |unit||9||yes||String||The unit of ''value''||For dates the unit is "date", otherwise name the actual unit of the value (e.g. "per 1000 inhabitants", "as % of GDP" etc.)

@@ Line 127: / Line 127: @@
 <sup>1</sup> Note that binary is used as a strict boolean type with allowed values of <code>0/1</code> or <code>true/false</code>; if you have a binary indicator but want to use "user-defined missing values", you have to choose "Multinomial" as scale.
-<sup>2</sup> If multiple concerns are raised for the focal value, only the most prevalent one is coded. If you choose "Other" as the response, it is mandatory to provide an explanation in the [[Optional_column_names|optional column]] <code>comment</code>.
+<sup>2</sup> If multiple concerns are raised for the focal value, only the most prevalent one is coded. If you choose "Other" as the response, it is recommended to provide an explanation in the [[Optional_column_names|optional column]] <code>comment</code>.
 == Misc ==

@@ Line 122: / Line 122: @@
 *Yes, due to limited sources
 *Yes, due to contradicting sources
-*Other
+*Other<sup>2</sup>
 |}
 <sup>1</sup> Note that binary is used as a strict boolean type with allowed values of <code>0/1</code> or <code>true/false</code>; if you have a binary indicator but want to use "user-defined missing values", you have to choose "Multinomial" as scale.
 == Misc ==