Appendix B

Column Name		Data Type	Size	Russian Column Description
Table 1: General characteristics, general.dbf
Coalkey		Number	11	Key field
Number		Number	6	Index field
Country		Text	30	Country
Region		Text	30	Region, state
District		Text	30	District, county
Area		Text	30	Land, area
Cbasin		Text	30	Coal basin name
Cdeposit		Text	30	Coal deposit name
Strpname		Text	30	Open-cut (open-strip) name
Age		Text	20	Geological age of coal-bearing sediments
Gostmark		Text	20	Coal mark according to GOST 25543-88: capital letter notation
Metgrade		Text	10	Coal metamorphism grade
minename		Text	30	Mine name
Company		Text	30	Coal mining company (ies)
Samptype		Text	15	Coal sample name: commercial or composite
Geographical location
Dlat		Text	11	Latitude
Dlong		Text	11	Longitude
Ordnum_76		Text	6	Ordinal number on the 1:7,500,000 scale map of coal deposits of the former USSR (1976)
Ordnum_70		Text	6	Ordinal number on the 1:2,500,000 scale map of coal deposits of the former USSR (1976)
Deptype		Text	4	Character of coal deposit: single-bed or multi-bed
Cbedname		Text	30	Coal bed name
Coal bed thickness, meters
Zone_thk		Text	8	Total coal zone thickness, meters
Minedthk		Text	8	Exploited part thickness
Totalthk		Text	8	Entire thickness of coal beds
Coal bed bedding
Dip		Number	6	Angle of inclined strata
Degree of coal deposit exploration
Startyr		Text	6	Mined deposit (from what year)
Endyear		Text	6	Exhausted deposit (from what year)
Lithology of coal-bearing strata (%)
Sandstone		Text	6	Sandstones
Siltstone		Text	6	Aleurolites
Argillite		Text	6	Argillites
Carbargil		Text	6	Coaly argillites
Coal		Text	6	Coals
Reference		Text	50	Reference to the information source (published book, map, catalogue, reference book etc.)
Table 2. Standard characteristics of coal, std_char.dbf
Coalkey	Number		11	Key field
Vr	Text		8	Mean random reflectance of vitrinite Rr , %
Vr_code	Text		10	Characteristics of the vitrinite reflectogram according to the International Codification System for Mean- and High-Rank Coals (ICS)
Res_ohm	Text		8	Electric resistance, Ohm/m (for anthracites)
Anisotropy	Text		8	Anisotropy of vitrinite reflectance A_R, % (for anthracites)
Inertinite	Text		8	Inertinite content, % by volume (mineral matter-free basis) Immf
Liptinite	Text		8	Liptinite content, % by volume (mineral matter-free basis) (for brown and hard coals) Lmmf
Volmat	Text		8	Volatile matter content V^daf, weight %
Min_mat	Text		8	Mineral matter content (impurity), M^d, weight %
Freeswell	Text		8	Crucible swelling number
Ash	Text		8	Ash content A^d, weight %
Sulfur	Text		8	Total sulphur content Std, weight %
Sulfate	Text		10	Sulphate sulphur content S_s^d, weight %
Sulf_pyr	Text		10	Pyritic sulphur content Spd, weight %
Sulf_org	Text		10	Organic sulphur content S_o^d, weight %
Sorg_stot	Text		10	Organic/Total sulphur COEFF, weight %
Calval	Text		8	Gross calorific value (Heating value) Q_i^daf, MJ/kg
Icscode	Text		14	Coal classification code according to the International Codification System (ICS), GOST 30313-95
Gostcode	Text		7	Coal classification code according to the GOST 25543-88
Density	Text		8	Density, g/cm³
Moisture	Text		6	Total analytical moisture content W_t^a, mass, %
Humidity	Text		8	Total humidity (for brown coals) W_max^r, mass, %
Carbon	Text		8	Carbon content, C^daf, weight %
Hydrogen	Text		8	Hydrogen content H^daf, weight %
Nitrogen	Text		8	Nitrogen content, N^daf, weight %
S_orgdaf	Text		8	Organic sulphur content, S_o^daf, weight %
Oxygen	Text		8	Oxygen content (direct determination), O_o^d, weight %
O_calc	Text		8	Oxygen content (calculation), O^daf, weight %
O_org	Text		8	Oxygen content in organic matter with account of mineral matter content, O_o^o, weight %
Phoshorus	Text		10	Phosphorus content, P^d, weight %
Plasticthk	Text		8	Thickness of the plastic layer (Sapozhnikov plastometer), y, mm (for hard coals)
Resin	Text		8	Semicoking resin yield, weight % (for brown coals)
Hum_acid	Text		8	Humic acids content, weight % (for brown coals)
Bitumens	Text		8	Bitumens content, weight % (for brown colas)
Grvti	Text		8	Grindability index according to the GrVTi method
Hgi	Text		8	Hardgrove grindability index (Friability)
Roga	Text		8	Roga index (caking power)
Ash fusibility, ºC
Ashdef	Text		10	Temperature of the initial deformation, t_A, ºC
Ashsoft	Text		10	Temperature of softening, t_B, ºC
Ashfld	Text		10	Temperature of fluid, t_o, ºC
Table 3. Mineral composition of coal (in volume percent) and size distribution (in mm) of coal: fraction yield and ash content in percent; mineral.dbf
Mineral composition of coal, in volume percent
Coalkey	Number		11	Key field
Mintotal	Text		8	Total mineral content
Quartz	Text		8	Quartz
Clay	Text		8	Clay minerals
Pyrite	Text		8	Pyrite
Carbonate	Text		8	Carbonates
Othermin	Text		8	Other minerals
Size distribution (in mm) of coal fraction yield and ash content of fraction, in percent
Yld_gt100	Text		8	Yield - greater than 100 mm, %
Ash_gt100	Text		8	Ash - greater than 100 mm, %
Yld_gt50	Text		8	Yield - greater than 50 mm, %
Ash_gt50	Text		8	Ash - greater than 50 mm, %
Yld50_100	Text		8	Yield - from 50 to 100 mm, %
Ash50_100	Text		8	Ash - from 50 to 100 mm, %
Yld25_100	Text		8	Yield - from 25 to 100 mm, %
Ash25 _100	Text		8	Ash - from 25 to 100 mm, %
Yld13_100	Text		8	Yield - from 13 to 100 mm, %
Ash13_100	Text		8	Ash - from 13 to 100 mm, %
Yld25_50	Text		8	Yield - from 25 to 50 mm, %
Ash25_50	Text		8	Ash - from 25 to 50 mm, %
Yld13_50	Text		8	Yield - from 13 to 50 mm, %
Ash13_50	Text		8	Ash - from 13 t0 50 mm, %
Yld13_25	Text		8	Yield - from 13 to 25 mm, %
Ash13_25	Text		8	Ash - from 13 to 25 mm, %
Yld6-25	Text		8	Yield - from 6 to 25 mm, %
Ash6-25	Text		8	Ash - from 6 to 25 mm, %
Yld6_13	Text		8	Yield - from 6 to 13 mm, %
Ash6_13	Text		8	Ash - from 6 to 13 mm, %
Yld3_13	Text		8	Yield - from 3 to 13 mm, %
Ash3_13	Text		8	Ash - from 3 to 13 mm, %
Yld1-13	Text		8	Yield - from 1 to 13 mm, %
Ash1-13	Text		8	Ash - from 1 to 13 mm, %
Yld500-13K	Text		8	Yield - from 500 to 13000 μm, %
Ash500-13K	Text		8	Ash - from 500 to 13000 μm, %
Yld3-6	Text		8	Yield - from 3 to 6 mm, %
Ash3-6	Text		8	Ash - from 3 to 6 mm, %
Yld1_6	Text		8	Yield - from 1 to 6 mm, %
Ash1_6	Text		8	Ash - from 1 to 6 mm, %
Yld1-3	Text		8	Yield - from 1 to 3 mm, %
Ash1-3	Text		8	Ash - from 1 to 3 mm, %
Yld500_3K	Text		8	Yield - from 500 to 3000 μm, %
Ash500_3K	Text		8	Ash - from 500 to 3000 μm, %
Yld500-1K	Text		8	Yield - from 500 to 1000 μm, %
Ash500-1K	Text		8	Ash - from 500 to 1000 μm, %
Yld0_1	Text		8	Yield - from 0 to 1 mm, %
Ash0_1	Text		8	Ash - from 0 to 1 mm, %
Yld_lt500	Text		8	Yield - less than 500 μm, %
Ash_lt500	Text		8	Ash - less than 500 μm, %
Table 4. Major-, minor-, and trace-elements contents in coal, elemcomp.dbf
Major element composition of coal ash (dry basis, expressed as oxides), weight percent
Coalkey	Number		11	Key field
Sio2	Text		6	SiO_2,, dry basis, weight %,
Al2O3	Text		6	Al₂0₃, dry basis, weight %,
Fe2O3	Text		6	Fe₂0₃, dry basis, weight %,
CaO	Text		6	CaO, dry basis, weight %,
MgO	Text		6	MgO, dry basis, weight %
NA20	Text		6	Na₂0, dry basis, weight %
K2O	Text		6	K₂0, dry basis, weight %
TiIO2	Text		8	TiO₂, dry basis, weight %
MnO2	Text		8	MnO₂, dry basis, weight %
P2O5	Text		8	P₂0₅, dry basis, weight %
Minor and trace element contents in coal (as-analyzed basis, average value, as-analyzed basis), ppm
Ag_ppm	Text		8	Silver - Ag - parts per million, average value, as-analyzed basis
Ag_mthd	Text		4	Silver - Ag - analytical method
As_ppm	Text		8	Arsenic - As - parts per million, average value, as-analyzed basis
As_mthd	Text		4	Arsenic - As - analytical method
Au_ppm	Text		8	Gold - Au - parts per million, average value, as-analyzed basis
Au_mthd	Text		4	Gold - Au - analytical method
B_ppm	Text		8	Boron - B - parts per million, average value, as-analyzed basis
B_mthd	Text		4	Boron - B - analytical method
Ba_ppm	Text		8	Barium - Ba - parts per million, average value, as-analyzed basis
Ba_mthd	Text		4	Barium - Ba - analytical method
Be_ppm	Text		8	Beryllium - Be - parts per million, average value, as-analyzed basis
Be_mthd	Text		4	Beryllium - Be - analytical method
Bi_ppm	Text		8	Bismuth - Bi - parts per million, average value, as-analyzed basis
Bi_mthd	Text		4	Bismuth - Bi - analytical method
Br_ppm	Text		8	Bromine - Br - parts per million, average value, as-analyzed basis
Br_mthd	Text		4	Bromine - Br - analytical method
Cd_ppm	Text		8	Cadmium - Cd - parts per million, average value, as-analyzed basis
Cd_mthd	Text		4	Cadmium - Cd - analytical method
Ce_ppm	Text		8	Cerium - Ce - parts per million, average value, as-analyzed basis
Ce_mthd	Text		4	Cerium - Ce - analytical method
Cl_ppm	Text		8	Chlorine - Cl - parts per million, average value, as-analyzed basis
Cl_mthd	Text		4	Chlorine - Cl - analytical method
Co_ppm	Text		8	Cobalt - Co - parts per million, average value, as-analyzed basis
Co_mthd	Text		4	Cobalt - Co - analytical method
Cr_ppm	Text		8	Chromium - Cr - parts per million, average value, as-analyzed basis
Cr_mthd	Text		4	Chromium - Cr - analytical method
Cs_ppm	Text		8	Cesium - Cs - parts per million, average value, as-analyzed basis
Cs_mthd	Text		4	Cesium - Cs - analytical method
Cu_ppm	Text		8	Copper - Cu - parts per million, average value, as-analyzed basis
Cu_mthd	Text		4	Copper - Cu - analytical method
Dy_ppm	Text		8	Dysprosium - Dy - parts per million, average value, as-analyzed basis
Dy_mthd	Text		4	Dysprosium - Dy - analytical method
Er_ppm	Text		8	Erbium - Er - parts per million, K_i
Er_mthd	Text		4	Erbium - Er - analytical method
Eu_ppm	Text		8	Europium - Eu - parts per million, average value, as-analyzed basis
Eu_mthd	Text		4	Europium - Eu - analytical method
F_ppm	Text		8	Fluorine - F - parts per million, average value, as-analyzed basis
F_mthd	Text		4	Fluorine - F - analytical method
Gd_ppm	Text		8	Gadolinium - Gd - parts per million, average value, as-analyzed basis
Gd_mthd	Text		4	Gadolinium - Gd - analytical method
Ga_ppm	Text		8	Gallium - Ga - parts per million, average value, as-analyzed basis
Ga_mthd	Text		4	Gallium - Ga - analytical method
Ge_ppm	Text		8	Germanium - Ge - parts per million, average value, as-analyzed basis
Ge_mthd	Text		4	Germanium - Ge - analytical method
Hg_ppm	Text		8	Mercury - Hg - parts per million, average value, as-analyzed basis
Hg_mthd	Text		4	Mercury - Hg - analytical method
Hf_ppm	Text		8	Hafnium - Hf - parts per million, average value, as-analyzed basis
Hf_mthd	Text		4	Hafnium - Hf - analytical method
Ho_ppm	Text		8	Holmium - Ho - parts per million, average value, as-analyzed basis
Ho_mthd	Text		4	Holmium - Ho - analytical method
I_ppm	Text		8	Iodine - I - parts per million, average value, as-analyzed basis
I_mthd	Text		4	Iodine - I - analytical method
In_ppm	Text		8	Indium - In - parts per million, average value, as-analyzed basis
In_mthd	Text		4	Indium - In - analytical method
Ir_ppm	Text		8	Iridium - Ir - parts per million, average value, as-analyzed basis
Ir_mthd	Text		4	Iridium - Ir -analytical method
La_ppm	Text		8	Lanthanum - La - parts per million, average value, as-analyzed basis
La_mthd	Text		4	Lanthanum - La - analytical method
Li_ppm	Text		8	Lithium - Li - parts per million, average value, as-analyzed basis
Li_mthd	Text		4	Lithium - Li - analytical method
Lu_ppm	Text		8	Lutetium - Lu - parts per million, average value, as-analyzed basis
Lu_mthd	Text		4	Lutetium - Lu - analytical method

Table 1: General characteristics, general.dbf

Coalkey

Number

11

Key field

Number

Number

6

Index field

Geographical location

Coal bed thickness, meters

Coal bed bedding

Table 4. Major-, minor-, and trace-elements contents in coal, elemcomp.dbf